Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form
Import products, variants, and categories in bulk using a CSV file.
You can import all your products along with their variants and categories from any other Ecommerce platform or from any inventory managing software that allows you to export your product list as CSV. Unlike standard CMS item import which requires manual mapping of fields, product import is automatic in that it maps the fields for you.
In this lesson, we’ll walk you through the process of preparing your CSV file and uploading it. We’ll also show you how to fix uploading issues.
First, you’ll need a list of all your products in CSV format. You can save, download, or export your database from the platform where you manage your inventory. You can also manually create a list and save it as CSV.
If you’re migrating from another Ecommerce platform, follow your platform’s guide on exporting products to get the CSV file.
If you’re exporting from a POS or other inventory management tool, search the help documentation of your software to find the guide for exporting your products in CSV format.
If your product list exists in an Excel file, a Google Sheet, a Numbers file, or any other spreadsheet program, you can export/save/download that file as a CSV file. Just follow the guide provided by your software/app to grab a copy of your product list.
If you do not have a way of exporting your product list in CSV format or you want to manually create a database of your products, you can do so either directly in the Webflow product manager or using any spreadsheet interface like Google Sheets, MS Excel, Numbers, or Airtable to create a spreadsheet with the columns representing the fields and rows representing the products and their values.
Open your project in the Designer, go to Ecommerce → Products, and click the import button. In the modal that appears, click to download our CSV template.
To ensure that you don’t run into any errors during the import process, first make sure your CSV data is formatted correctly and it can be mapped to the right field type. Follow the guidelines below when creating your own database spreadsheet:
Must know
Column headers and entries must match the standard formatting in the template file.
The product handle, or slug, is a text string that’s unique for each product. It’s usually the same as the name of the product only with spaces substituted with dashes.
Type: slug
Example: stacys-pink-donuts
Resulting URL: mywebsite.com/product/stacys-pink-donuts
Maps to field: slug
To pass validation, this field must:
If a product with the same handle already exists in your products collection, the new item from your CSV won’t be uploaded
This is the name of the product.
Type: Plain text
Example: Stacy’s pink donuts
Maps to field: Name
To pass validation, this field must:
The description of the product without any formatting.
Type: plain text
Example: You must try Stacy’s pink donuts! These raspberry donuts just melt in your mouth and transport you to Heaven and back. Made with the most delicious raspberries, these donuts are filled with raspberry jam, coated with raspberry cream and sprinkled with shredded coconuts, pistachios, or sugar sprinkles.
Maps to field: Description
The category or categories the product belongs to.
Type: semicolon-separated text string
Example: glazed donuts; filled donuts; fruit donuts
Maps to field: Categories
Creates: a new category if the category doesn’t exist
Specifies if the product is taxable or not taxable.
Type: true or false (switch)
Example: False
Maps to field: Charge sales tax on this product
To pass validation, value must be blank or any of the following:
Need to know:
The current price of the product or variant
Type: Number
Example: 49.99
Creates: new variant
To pass validation:
The old price of the product, before sale
Type: Number
Example: 58
Creates: new variant
To pass validation:
This is the stock quantity field. It enable inventory tracking as well.
Type: Number
Example: 50
Creates: new variant
To pass validation:
If a product has more than one option set (color, size...), then enter the name of that option set.
Type: Plain text
Example: Size
Creates: variant
If a product has an option, then enter its value (blue, medium, XXL...).
Type: Plain text
Example: Mini
Creates: variant
If a product has a second option set, then enter its name.
Type: Plain text
Example: Topping
Creates: variant
If a product has a second option, then enter its value.
Type: Plain text
Example: Sugar sprinkles
Creates: variant
If a product has a third option set, then enter its name.
Type: Plain text
Example: Filling
Creates: variant
If a product has a third option, then enter its value.
Type: Plain text
Example: Raspberry jam
Creates: variant
This is the URL for the product image. Webflow downloads the images during the import and re-uploads them into your store.
Type: URL
Example: https://assets-global.website-files.com/5c5c66ea0a3f27bc39bf5e24/5c63f4869b9111bfde2e5b0b_800.jpg
To pass validation, this field must:
Need to know:
The SKU of the product or variant.
Example: 001789-DONUT-PINK
The weight of the product or variant without units. The units are specified you want to use in your Ecommerce settings. You must use accurate weights if you intend to offer weight-based shipping.
Type: Number
Example: 38
Type: Number
Example: 5
Type: Number
Example: 5
Type: Number
Example: 1
You can use a spreadsheet editor like Google Sheets to update your CSV to meet the requirements. For example, the price value is required and it should be a number without the currency unit.
Once your file is ready, head back to the Designer and go to Ecommerce → Products and import your CSV file. The system will import your CSV and try to automatically map all the default fields including variants and categories. You’ll be notified once the process is completed and if there were any issues during the importing or mapping process.
Must know
Currently, mapping to custom fields is not supported.
If a category exists (same slug or name), it will be mapped to the existing category. If the category doesn’t exist, a new category will be created.
If there are any issues in uploading, you’ll get a notification that will let you know how many products and variants were important and which were not. You’ll be able to download a text file with the import errors. If any line in the CSV has a problem, then the entire product and its variants get skipped. For example, if a variant has a non-numeric price, then the entire product and all its variants get skipped.
If there are any issues during upload, download the import errors log to fix the issues with your CSV file.
Need more help? Want to report a bug? Contact support
Have feedback on the feature? Submit feature feedback
