How To Creat & UPload Your CSV Product File

 

1. Create Your CSV Product file

Due January 20 (New Brands Only)

This deadline is to review your product file to ensure that your formatting is on the right track. This does not need to be your final file. After reviewing your CSV product file, you will be given feedback and may continue to edit individual products, images, pricing etc. (If you have recently contracted, and missed any deadlines DO continue to submit your materials as soon as possible!)

Please download the CSV product file template here (also available below) AND watch the tutorial video here (also available below) before starting to build your CSV product file.

 
  • Step 1 - Export your items into a Product CSV file.
    Link: Exporting Product CSV from Shopify

    Step 2 - Add the following columns to the file:

    1. Min Quantity
    2. Product Status
    3. Sort Order
    4. Color, Room
    5. Origin, Values
    6. Materials.
    Any extra columns with information that are not listed on our Product File Template will be ignored by the system. You may delete it or leave it.

    Set aside ample time to define and cross-check TAXONOMY (mentioned below) — the Type (Category, SubCategory), Filter, and Product Tag columns, per product. Your Shopify file will already have a Category and Product Tag column. You may leave them there however please format the data to match our template. These are SO important and will be worth your time and attention: you do not want to be missed while buyers search by keywords!

    Step 3 - Update your wholesale pricing and quantities and DELETE the PUBLISHED column.

    If you are exporting from a retail site, please change your “Variant Price” to your wholesale pricing. Minimum Quantity is treated as case pack quantity and will increase in multiples just like case packs. Please delete the "Published" column.

    Step 4 - Use the Sort Order column to Order your products. Items will appear from the lowest sort number to the highest. We recommend using multiples of 10 while numbering (10, 20, 30 , 40...) so that you may easily insert products between your original sequence without having to renumber everything. ie If you wanted to insert a product between 10 and 20, simply number it 11.

    Step 5 - Save your file as CSV or comma separated value. The first row must be the column headers.
    If you are working in Apple Numbers, it will automatically add a header row with the file name. Please be sure to delete that.

    Step 6 - Send to hello@shoppeobject.com for a final check by January 20

    Step 7 - Upload your final CSV Product file to the SHOPPE ONLINE site after your file review is complete.

  • Step 1 - Export your items into a Product CSV file from your existing site. If you do not have the ability to export a CSV file, you may create your own by following Step 2 below.
    Link: Exporting Product CSV from SquareSpace

    Step 2 - Please use the Product File Template to match your export from your site. Please follow the directions within the template to ensure for a seamless upload to SHOPPE ONLINE. You may need to delete some columns and add others such as minimum quantity and all five or our filters.

    Please be sure to check your tags, type, and filters. Set aside ample time to define and cross-check TAXONOMY (mentioned below) — the Type (Category, Subcategory), Filter, and Product Tag columns, per product. These are SO important and will be worth your time and attention: you do not want to be missed while buyers search by keywords!

    Step 3 - Use the Sort Order column to Order your products. Items will appear with from the lowest sort number to the highest. We recommend using multiples of 10 while numbering (10, 20, 30 , 40...) so that you may easily insert products between your original sequence without having to renumber everything. ie If you wanted to insert a product between 10 and 20, simply number it 11.

    Step 4 - Save your file as CSV or comma separated value. The first row must be the column headers.
    If you are working in Apple Numbers, it will automatically add a header row with the file name. Please be sure to delete that.

    Step 5 - Send to hello@shoppeobject.com for a final check by January 20

    Step 6 - Upload your final CSV file to the SHOPPE ONLINE site after your file review is complete.

  • Each product must be listed on one row and have a:

    1. Title

    2. Description

    3. Image URL*

    4. Wholesale Price

    5. SKU

    6. Minimum Quantity

    7. Product Status

    8. Sort Order

    *Multiple image URLs will be listed one per row, please see the template and video above for how to list multiple images.
    **Your main product image should be a regular product image with a white or neutral background. You may use your lifestyle images as secondary images for the product.
    ***
    IMPORTANT! All product images on Shoppe ONLINE are square. If you have rectangular images, they will be cropped to center automatically.

  • Some of your products may have variations such as different sizes, color options, wording etc. each product may have up to three different types of options with unlimited choices for each option. For example, a shoe may have a gender option (Womens or Mens), a color option (Blue, Red, Yellow, Black etc), and a size option (6, 7, 8, 9 etc). You would need to list each possible combination Women's, Blue, Size 6, Women's, Blue, Size 7 etc with it's own unique SKU.

    Each product variation option must be listed on a separate row — please see the template for how product variations must be listed. Each product variation option must have it's own unique SKU. Each product variation option may have one Variant Image URL that will be shown to buyers when that selection is made.

  • Taxonomy is how your product will be found within different search methods on the Shoppe Online platform. Please see the section below for a full description of Taxonomy.

    Your product file will include: Type (where you list your Categories) Product Tags (this includes the Shoppe Online Marketing Story Tags as well as any tags you wish to use) Five Filter Columns (Color, Room, Values, Materials, Origin).

    You can learn more about taxonomy below.