How to bulk create or update vendor products via CSV file?
This guide shows how to create new or update existing products including inventory via CSV in bulk.
Please take note of following before uploading:
Column _id is a unique identifier for each product. Please do not delete the column.
Existing products will have an _id value in the field but you must leave the column blank if this is a new product. Please do not make any changes.
Bulk uploaded products will be in active, draft or pending status depending on the merchant's permission settings.
The Handle should be unique for each product. New variants for the same product should have the same handle.
Images should be in a URL format and should be a direct source to the image (e.g.: https://unsplash.com/photos/A6JxK37IlPo)
If you are a vendor, please leave this column as is.
Supported file type: CSV
All columns are required. Use default values if unsure
Available Columns and Description
Below are the instructions on how you can update existing products by batch.
From your Vendor portal, go to Products and click the Import button.
A pop-up window will appear. Click the 'Export to CSV' button to download the template.
The csv template will be downloaded and will look like this.
Please edit the product details corresponding to that of your preferred item for updating. See below.
Once all fields are filled-out, save the csv file. Click the 'Choose File' button and upload through the 'Upload button'
Review columns mapping. They are useful for confirming Inventory Locations and Metafields
Review uploaded content and fix errors
You can then check for the updated products added in your list by using the Search field in the Products tab.
Please take note of following before uploading:
Column _id is a unique identifier for each product. Please do not delete the column.
Existing products will have an _id value in the field but you must leave the column blank if this is a new product. Please do not make any changes.
Bulk uploaded products will be in active, draft or pending status depending on the merchant's permission settings.
The Handle should be unique for each product. New variants for the same product should have the same handle.
Images should be in a URL format and should be a direct source to the image (e.g.: https://unsplash.com/photos/A6JxK37IlPo)
If you are a vendor, please leave this column as is.
Supported file type: CSV
All columns are required. Use default values if unsure
Available Columns and Description
Column Name | Description | Type/Value | Example/Default Value |
---|---|---|---|
Handle | The handle is a product identifier. | Lower case text, Hyphens, Numbers | iPhone-14-64-gb |
Title | The title is the product name that potential buyers identify with | Text, Numbers | iPhone 14 64 GB |
Description | The description are details about the product | Text, Numbers | iPhone is a great product |
Vendor | The Vendor is typically the supplier of the product | Text, Numbers and - | Apple, vendor-78 |
Published | Whether the product is Listed or Unlisted on the website | Acceptable values: TRUE or FALSE | N/A |
Option1 Name | Product option | Text Only | Color |
Option1 Value | Product option value | Text and Numbers | Green, 100 ml |
Option2 Name | Product option | Text Only | Storage |
Option2 Value | Product option value | Text and Numbers | 128GB |
Option3 Name | Product option | Text Only | Wireless |
Option3 Value | Product option value | Text and Numbers | Cellular, 100 ml |
Variant SKU | SKU value of the variant | Text & Numbers | SKUQWRTY123 |
Variant Inventory Policy | Can items be sold if out of stock? | Acceptable value: DENY - Purchase of this item will not be allowed. CONTINUE - Purchase of this item will be allowed even when out of stock | DENY |
Variant Fulfillment Service | A service that fulfils your order | Acceptable value: MANUAL | MANUAL |
Variant Price | Price of the variant | Numbers | 25.00 |
Variant Compare At Price | The original price, if your Variant Price is a discounted price | Numbers. | 300.00 |
Variant Requires Shipping | Is the variant a physical product? Can it be shipped? | Acceptable values: TRUE or FALSE | FALSE |
Variant Taxable | Should additional tax be charged on the variant price? | Acceptable values: TRUE or FALSE | TRUE |
Variant Barcode | Unique identifier of the variant | Numbers | 123456789 |
Variant Image | The image URL of the variant | Text as a URL | https://unsplash.com/photos/A6JxK37IlPo |
Variant Weight Unit | Unit of the variant item | Acceptable values: KILOGRAMS, GRAMS, OUNCES, POUNDS | GRAMS |
Variant Tax Code | Specifies the Avalara tax code for the product variant | Text | DA04000 - Applicable only for USA stores and if Avalara is installed |
Gift Card | Tells whether the variant is a gift card product | Acceptable values: TRUE or FALSE | TRUE |
Tags | Tags associated to the product | Multiple Text, Numbers separated by a comma (,) | Black, 128GB, Premium |
Image Src | The image of the variant | Multiple URL(s) separated by a comma (,) | https://unsplash.com/photos/A6JxK37IlPo,https://unsplash.com/photos/A6JxK37IlPo |
Image Alt Text | An explanation of the product image | Text | My new shiny iPhone |
Cost per item | The cost of the product variant | Numbers | 12.50 |
Track Quantity | Whether variant inventory should be tracked | Acceptable values: TRUE or FALSE | FALSE |
Inventory Location | The quantity of product variant for this location | Numbers | 13 |
Below are the instructions on how you can update existing products by batch.
From your Vendor portal, go to Products and click the Import button.
A pop-up window will appear. Click the 'Export to CSV' button to download the template.
The csv template will be downloaded and will look like this.
Please edit the product details corresponding to that of your preferred item for updating. See below.
Once all fields are filled-out, save the csv file. Click the 'Choose File' button and upload through the 'Upload button'
Review columns mapping. They are useful for confirming Inventory Locations and Metafields
Review uploaded content and fix errors
You can then check for the updated products added in your list by using the Search field in the Products tab.
Video Guide - How to update existing products by Batch
Updated on: 13/01/2025
Thank you!