Skin Cupid

Skin Cupid PR/Giveaway Operations Portal

Contacts, PR projects and Mintsoft exports — marketing builds, operations ships

v6.7

Project

Upload Your List

Excel (.xlsx / .xls) or CSV. Drop it in and the portal maps the columns, formats the addresses, finds the SKUs and builds the file. It only stops if something genuinely can't be resolved.

Drop a file here, or click to browse PR lists, gifting lists, winner lists, seeding lists — anything with names, addresses and products

Map Your Columns

Auto-detected where possible. Only Name, Address and Products are required.

Preview

First 5 rows as read from the file.

Click a row to open it. Red = must fix before export. Amber = worth a look. Learned SKU matches are remembered for next time.

Export

Mintsoft MultiLineOrderTemplate schema — one row per SKU per recipient.

Preview


  







  

    
SKU Catalogue

    
Every SKU in Shopify, pulled live through the Worker. The Admin API token stays on the Worker and never reaches this page.

    

      
      
      
      
      
    

    
Not synced yet — set the Worker URL on the Settings tab, then hit Sync.

    
Which statuses can be matched and picked:

    

      
      
      
      
      
      
    

    

    

  

  

    
Learned Aliases

    
Every manual SKU pick you make is saved here, so the same wording matches automatically next time.

    

  







  

    
Order Settings

    
Applied to every order in the batch.

    

      

        
        
        
Must match your Mintsoft dropdown exactly.

      

      

        
        
        
Builds PREFIX-INITIALS-001

      

      

        
        
      

      

        
        
      

      

        
        
      

      

        
        
      

    

  

  

    
Shopify Connection

    
Points at the Worker that holds the Shopify Admin token. Reuses the same custom app as the Staff Ordering Portal — read_products is the only scope it needs.

    

      

        
        
        
Pre-filled. Clear it to fall back to the built-in default.

        
No trailing slash. https:// is added if you leave it off. The portal calls /api/catalogue on it.

      

      

        
        
        
Full auto still stops if a SKU or address can't be resolved.

      

      

        
        
        

          
          
        

      

    

  

  

    
What's Shared With the Team

    
Worth knowing when someone else opens the portal, or you use a different browser.

    

      
DataStoredShared?

      
ContactsDatabaseyes — whole team

      
PR projects & giveawaysDatabaseyes — whole team

      
Shopify catalogueRe-synced per browsersame data

      
Learned SKU matchesThis browserno

      
Settings on this tabThis browserno

    

    
Everyone needs the portal password to see contacts and projects.

  

  

    
Address Book

    
For placeholder addresses like "Skin Cupid Office" that appear in PR lists instead of a real address. One per line: Label | Addr1 | Addr2 | Town | Postcode

    
  

  

    
Skip Rules

    

      

      

      

      

    

    

      
      
    

    

      
      
    

  







  

    
PR Contact Book

    

      
      
      
      
      
      
    

    

      
      
      
    

    

    

  

  

    
Edit Contact

    

      

      

      

      

      

      

      

      

      

      

      

      

      

      

      

    

    

    

      
      
      
    

  

  

    
Bulk Upload — Map the Columns

    
Matched on email first, then name. Anyone already in the book is updated rather than duplicated.

    

    

      
      
      
    

  







  

    

      
PR Projects

      
Marketing builds the list and hits Finalise; operations picks it up, fixes anything that needs fixing, and exports to Mintsoft.

      

        
        
        
      

      

    

  


  

    

      
Project Details

      

        

        

        

        

        

          

        

      

      


    


    

      
Import a List

      
Got the PR list as a spreadsheet? Drop it here and it'll pull out the people, addresses and products and add them straight into this project.

      

        Drop a file, or click to browse
        .xlsx / .xls / .csv — you'll see what it found before anything is added
      

      

    


    

      
The Kit

      
What everyone gets by default. Add it here once, then override per person below if shades differ.

      

      

        

        

      

      

      

        
        Only overwrites people who have nothing yet.
      

    


    

      
Recipients

      

        
        
        
        
      

      
Only people marked accepted go into the Mintsoft file.

      

        

          

          

               

        

        

      

      

    


    

      
Hand Over to Operations

      
When the list is settled and you've heard back from everyone you're going to hear back from, finalise it. Operations picks it up from there — nothing is locked, so you can still make changes if something lands late.