If doing a campaign that includes product gifting, you will need to provide the product information in a linesheet, either via Excel or CSV. 

Linesheets have the following columns (Note - column order is important):

  • Start Date, End Date, Category, Product Name, Color Options, Gender, Stock Quantity, Product Url, Image Url, Product ID

A few rules:

  1. Every row in the linesheet represents a different product.
  2. If you have multiple color options, group them in the same cell separated by comma
  3. If quantity is unlimited, put a value that won’t run out, ie 9999999
  4. If there are no color (or other variation) options, leave the field empty
  5. If product URL is not available, provide images in ZIP file where each image filename corresponds to it's product ID.
  6. For start/end dates, you can use "now" to indicate the product is live or any standard date format.

 

More tips:

If multiple categories with multiple products and variations (like different types of coats each with different colors), do one line per product:

  • 2017-01-15, 2017-02-15, Coats, Fancy Coat, "Blue, Red, Green", Female, 5, http://mystore.com/fancy-coat, http://mystore.com/images/fancy-coat-5.jpg, 12345
  • 2017-01-15, 2017-02-15, Coats, Casual Coat, "Blue, Red, Green", Female, 3, http://mystore.com/fancy-coat-6, http://mystore.com/images/fancy-coat.jpg, 12346

 

If one product category with multiple products, do one line per product variation:

  • 2017-01-15, 2017-02-15, Skincare, Ultimate Primer, “Universal Light”, Female, 100, linktoprimerimage.jpg, sos00
  • 2017-01-15, 2017-02-15, Skincare, Ultimate Primer, “Rose”, Female, 100, linktoprimerimage1.jpg, sos01

 

 

If multiple product categories, do one line per product:

  • 2017-01-15, 2017-02-15, Skincare, Ultimate Primer, “Universal Light”, Female, 100, linktoprimerimage.jpg, sos00
  • 2017-01-15, 2017-02-15, Beauty, Best Lipstick, “Rose, Rouge, Coral”, Female, 100, linktoprimerimage1.jpg, sos01

 

Put in spreadsheet format, either Excel or CSV. When you provide the file please indicate how many choices the influencer can pick, and any other relevant direction (ex: pick one primer and two lipsticks).