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.

No changes to Column 1

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.

Creating Products by Batch

A pop-up window will appear. Click the 'Export to CSV' button to download the template.

Export existing listing

The csv template will be downloaded and will look like this.

CSV title row

Please edit the product details corresponding to that of your preferred item for updating. See below.

Updating values of existing products or add new ones

Once all fields are filled-out, save the csv file. Click the 'Choose File' **button and upload through the **'Upload button'

Creating Products by Batch 5

Review columns mapping. They are useful for confirming Inventory Locations and Metafields

Review column mappings

Review uploaded content and fix errors

Review 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

Was this article helpful?

Thank you!