Articles on: Products & Inventory

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 NameDescriptionType/ValueExample/Default Value
HandleThe handle is a product identifier.Lower case text, Hyphens, NumbersiPhone-14-64-gb
TitleThe title is the product name that potential buyers identify withText, NumbersiPhone 14 64 GB
DescriptionThe description are details about the productText, NumbersiPhone is a great product
VendorThe Vendor is typically the supplier of the productText, Numbers and -Apple, vendor-78
PublishedWhether the product is Listed or Unlisted on the websiteAcceptable values: TRUE or FALSEN/A
Option1 NameProduct optionText OnlyColor
Option1 ValueProduct option valueText and NumbersGreen, 100 ml
Option2 NameProduct optionText OnlyStorage
Option2 ValueProduct option valueText and Numbers128GB
Option3 NameProduct optionText OnlyWireless
Option3 ValueProduct option valueText and NumbersCellular, 100 ml
Variant SKUSKU value of the variantText & NumbersSKUQWRTY123
Variant Inventory PolicyCan 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 stockDENY
Variant Fulfillment ServiceA service that fulfils your orderAcceptable value: MANUALMANUAL
Variant PricePrice of the variantNumbers25.00
Variant Compare At PriceThe original price, if your Variant Price is a discounted priceNumbers.300.00
Variant Requires ShippingIs the variant a physical product? Can it be shipped?Acceptable values: TRUE or FALSEFALSE
Variant TaxableShould additional tax be charged on the variant price?Acceptable values: TRUE or FALSETRUE
Variant BarcodeUnique identifier of the variantNumbers123456789
Variant ImageThe image URL of the variantText as a URLhttps://unsplash.com/photos/A6JxK37IlPo
Variant Weight UnitUnit of the variant itemAcceptable values: KILOGRAMS, GRAMS, OUNCES, POUNDSGRAMS
Variant Tax CodeSpecifies the Avalara tax code for the product variantTextDA04000 - Applicable only for USA stores and if Avalara is installed
Gift CardTells whether the variant is a gift card productAcceptable values: TRUE or FALSETRUE
TagsTags associated to the productMultiple Text, Numbers separated by a comma (,)Black, 128GB, Premium
Image SrcThe image of the variantMultiple URL(s) separated by a comma (,)https://unsplash.com/photos/A6JxK37IlPo,https://unsplash.com/photos/A6JxK37IlPo
Image Alt TextAn explanation of the product imageTextMy new shiny iPhone
Cost per itemThe cost of the product variantNumbers12.50
Track QuantityWhether variant inventory should be trackedAcceptable values: TRUE or FALSEFALSE
Inventory LocationThe quantity of product variant for this locationNumbers13


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?

Share your feedback

Cancel

Thank you!