Adding Products to a Collection - through file upload

This process will show you how to add products to a Collection you created. This process outlines the batch upload process using a CSV file upload, but note that products can also be added to a Collection manually one at a time (steps outline in Article "Adding Products to a Collection- Manually").


Steps to follow for uploading products to a Collection

Step 1: Create a Collection

  1. Go to the “Dashboard” or "Catalog" tab
  2. Scroll down the page where you will see “Collections”, then click “Add +” to add a new collection
  3. Fill out all your Collection information in this page, and once done, click on “Create”


Cover: upload a picture of your Collection, this is a required field entry

Collection Name: enter your Collection name, this is a required field entry

Brand: enter the Brand name your Collection is under

Start Delivery Date: enter the date you will start delivering products from your collection

End Delivery Date: enter the date you will end delivering products from your collection

Privacy: select whether you want your collection to be made private or be seen by your Retailers


  1. Once all this information is entered, click on “Create”

Note: you will see the Collection name you added next to all the other ones in your Dashboard and Catalog view.

Step 2: Create your CSV file to upload

  1. Once you click on "CSV upload+" from your Catalog view, you will be brought to the "Catalog Import" page
  2. Click on "Download CSV Template" which will download the CSV template you need to use to fill out all your collection product information, save as a CSV, before uploading it
  3. Your CSV file must adhere to the following filed parameters:

Field Type Length Required (Y/N) Details
Style Number Text unlimited Y
Product Title Text unlimited N
Product Group Text Unlimited N
Product Description Text Unlimited N
Gender Text Man, women Y man, woman
Collection Text
Y
Product Category Text
Y
Product Sub Category Text
Y
Note Text Unlimited N
Video Or Image Text Unlimited N (separated by comma)
Tags Text Unlimited N (separated by comma)
Size Text Unlimited Y (separated by comma)
Color (primary) Text
N
Brand Color Text
Y
QTY (separated by comma) Number
N (separated by comma)
Fabric Content Text Unlimited N
SKU/UPC (separated by comma) Text Unlimited N (separated by comma)
Availability Text Unlimited N
Country of Origin Text Unlimited N
Currency Text
Y
Wholesale Price Number
Y
MSRP Number
Y
Prepack Sizing Numbers
N (separated by comma)
Prepack Breakdown Numbers
N (separated by comma)
Currency2 Text
N
Wholesale Price2 Number
N
MSRP2 Number
N
Currency3 Text
N
Wholesale Price3 Number
N
MSRP3 Number
N
(add more currencies as required)



Step 3: Upload your CSV file to add your product pictures to your Collection

  1. Once you created your Collection, go back to your catalog page and click on "CSV Upload +"
  2. "Select the Collection" name from the dropdown menu
  3. Under the "Browse" field, select your CSV upload file

IMPORTANT: If products were previously uploaded, don’t forget to check "Overwrite existing products"

  1. Click "Preview", if the onscreen sample is correct, scroll to the bottom and click "Start Upload"

IF THERE IS A MISTAKE: Click "Back" and fix before uploading

  1. The on-screen instructions will notify you when complete and if there were in the file upload. If yes, correct and repush.

  1. If the data upload screen is showing errors:
  • Correct the errors and re-upload
  • Be sure to click "Overwrite"
  • The error log will identify which unique styles, SKUs and/or images contained errors

Use cases - what are some problems that may be experienced with the CSV file upload?

UC # Use Case  Outcome 

1

 Forgot to save the .xls template as a .csv It will not work. Re-save as a .csv and re-upload.

2

 .csv includes equations It will not work. Copy the cells and paste ‘values’ only.

3

 One Style number has multiple prices.

All products that share a style number must sell for the

same price.

Mapping files between ShowroomX and Shopify

Shopify files are subject to unique creation configuration. The following is directional only and will need to be tailored based on how your individual Shopify file is setup.

SHOWROOMX Maps to the following column in Shopify SHOPIFY SAMPLE

Column
Style Number Style Number

A
Product Title Title

C
Product Group Vendor

E
Product Description Handle

B
Gender Google Shopping / Gender

AH
Collection Vendor

E
Product Category Google Shopping / Google Product Category

AG
Product Sub Category Custom Product Type

G
Note Body (HTML)

D
Video Or Image (separated by comma) Image Src

AA
Tags (separated by comma) Tags

H
Size (separated by comma) Option1 Value

K
Color (primary) n/a
Brand Color Option2 Value

M
QTY (separated by comma) Variant Inventory Qty

S
Fabric Content n/a
SKU/UPC (separated by comma) Variant SKU

P
Currency n/a
Wholesale Price Cost per item

AW
MSRP Variant Price

V
Availability n/a
Country of Origin n/a
Prepack Sizing n/a
Prepack Breakdown n/a
Currency2 n/a
Wholesale Price2 n/a
MSRP2 n/a