Bulk Uploads Using CSV Files
You can upload many products at once using a CSV file. This is basically a spreadsheet saved with the CSV file extension. Many platforms have this function. Each platform has some specific set ups for their CSV files. When you download products from another platform, you will most likely have to make some adjustments to the file before you can upload it here.
Below will take each column and define what goes in it to make it easy for you to create an upload file that will get your products set up and ready to go. Unless noted otherwise, all of the columns and fields are mandatory.
The first column – Column A needs to be labeled Unique ID. You will need to assign a unique number (numerical characters only). If you have a product with variants (i.e. size or color options) you will need to use the same number for each option and list each option as a separate line item.
Column B – needs to be labeled Title. This is where the title of your product goes. This will show up on all of the pages that list individual products in the marketplace.
Column C – needs to be labeled Description. This is where you want to put all of the information you put in your listings that describes the product.
Column D – needs to be labeled Vendor Email – put the email that you associated with your seller account. This is how the marketplace knows to list this product in your shop rather than someone else’s shop.
Column E – must be labeled Type – Here put what type of product this is – example: Tarot or Altar Cloth
Column F – must be labeled Tags – tags are very important. They drive what collection (category) your product shows up in. If your product qualifies for more than one collection, just add the appropriate tags and it will show up on those pages as well. See Collections and Tags for more information on what these tags are and how to use them.
Column G – must be labeled Option1 Name. For the products with variants this field needs to have the name of the product option. For example, a shirt that comes in small, medium and large sizes will be labeled Size. The products without variants will need to say Title.
Column H – must be labeled Option1 Value : Products with no variants will need say Default Title. The products that do have variants will have the actual variant in this field. For example, a shirt that comes in small, medium and large would have small in this field on the line for the small shirt, medium in this field for the medium shirt and so on.
Column I – must be labeled Option2 Name : If you have second options or variants you can put the name of that variant here. For example – the shirts we used in the example above also come in Blue, White or Black. You would put Color in this field. If your products do not have secondary variants you can leave this field blank.
Column J – must be labeled Option2 Value: In the example we used above, this would be where you put White or Blue or Black. Remember you have a separate line for each variant you offer on a product. This column can be left blank under the label Option2 Value
Column K – Option3 Name – for use when you offer a third variant on the product. In the example we used above Size was the first variant, Color the second variant and the third variant might be Image if you offer the shirt with different images on them. In this case you would put Image in the field. This column can be left blank under the label Option3 Name if it is not needed.
Column L - Option3 Value : for use when you offer a third variant. This is the product value for the third variant. In the example above the third variant is Image so this would say which image. For example if you offer an American Flag as one image and a British Flag as another image you would put each of these options in the field on the two lines for the product. This field can be left blank.
Column M - Variant SKU : This field is where you put a sku for your product. It allows the marketplace to track inventory for you and not oversell what you have available. This is mandatory.
Column N - Variant Grams : This is the weight of the item to allow shipping to be charged by weight. The program requires grams. As we are based in the United States, most of our sellers will probably have theirs set up in pounds and ounces. To convert your weight into grams for this field you can easily search for a conversion or use this conversion tool by Rapid Tables. This is the variant weight in grams. You need to type just the number, not the measurement unit. Example : 10
Column O - Variant Track Inventory: If you want the marketplace to keep track of your inventory and not oversell what you have you will need to type shopify in this field. If you do not want the marketplace to keep track of inventory just leave this field blank under the heading.
Column P - Variant Qty : Put the quantity of each item you have that you are listing. This will allow the marketplace to know that you have enough of each item to sell.
Column Q - Variant price: This is the price you want to charge the customer. No need to specify the currency. Example : 299.00
Column R - Variant Compare at Price: This column would be where you would put a comparison price if you are selling this item at a lower price. This column can be left blank under the heading.
Column S - Variant Requires Shipping : Use 'TRUE' if this product must be shipped and ‘FALSE’ if it does not need to be shipped. For example: if you are selling a reading, you would email the customer the reading rather than shipping them something so the reading would be labeled ‘FALSE’
Column T - Variant Barcode : Barcode, ISBN or UPC of the product – This field is not mandatory to fill out. However, if you are selling an item with an ISBN or UPC it is a field that helps the SEO of your product. For example: when customers are looking for a specific book they often type the ISBN into search engines. If your book does not list the ISBN in the field then it will not come up in potential customer searches for that ISBN.
Column U - Collection: This is the name of the collection in which you want to add the product. One product can be added to only one collection by this method. Smart collection cannot be added here. Recommendation is to leave this field blank and use the Tags column to determine what collections your product shows up in.
Column V - Custom Fields: Contact admin support if you require custom fields. Otherwise no need to even create this column.
Note : • If a product has variants, then enter all the fields (described above) for the product on the first line. On the following lines, enter the unique id of the product. Then, skip the Title, Description, Vendor Email, Type, Tags and Collection fields. And fill out the rest of the fields for variants.