Wix Stores: Importing Products from Another eCommerce Platform
Important:
This article relates to importing products to the new Wix Stores product catalog. If the first field you see on your product creation page is Images and videos, you're on the previous version. Learn more about importing products in the previous version.
Planning to move from another eCommerce platform to Wix Stores? We're glad to have you on board. You can import your products using our template file to get your store up and running.
Before you begin:
To migrate products from a store built on another eCommerce platform, go to that platform and export your product data. Then, proceed to step 1 below.
Step 1 | Download the template file
To import data successfully, you must prepare it in the correct format. Start by downloading the template file and saving it to your computer.
Tip:
The template includes three sample products, two of which have variants, to help illustrate the proper formatting.
To download the template file:
Go to Store Products in your site's dashboard.
Click the More Actions drop-down.
Click Import.
Click Download Template
Open the CSV file.
Note: Mac users should open the file with Numbers or Excel version 15 or higher.
Save the exported file in CSV (Comma delimited) format.
Overview of how products are displayed in the CSV file
Let's look at a sample product and see how the product data is represented in the exported CSV file.
This is what a product looks like in the Wix dashboard. This sample product has one image and no product options. Some of the fields, such as Ribbon, Description, Price, and Strikethrough price are filled in. Other fields such as Brand are blank.
When this product is exported, it appears in the table with 2 rows. One for the product itself, and one for the single product image (each image, GIF, or video has its own row).
Now let's take a look at some of the columns.
Column A show the product's handle. This is an identifier that is automatically added. The handle is the same for both the product row and the media row, as they refer to the same product. Each of your products will need a Wix handle. You can leave this column blank. Missing handles are automatically added.
Column B specifies whether the row contains information about a product or about media (image, GIF, or video). For products with product options, each variant also has a separate row.
Important:
Some columns are only relevant for products (e.g. columns B and C). Others are only relevant for media (e.g. columns F and G). Variants also have columns that are only relevant for them.
To import successfully, you must enter data in the correct format. Review the table in Step 2 below carefully for instructions.
Each platform has its own fields and uses its own terminology. When adapting data from another platform, you will likely need to adapt the data in the file you exported to fit the Wix formatting. You may need to skip some data altogether if a feature isn't supported in Wix.
Step 2 | Add products to the file
Now you can start adding your products to the template file you downloaded.
To add your products:
Enter the product data into the CSV file, following the instructions in the table below.
Save the file in a CSV format.
Important:
To successfully upload products, make sure to follow these instructions:
Do not add or delete columns.
Do not edit column names.
Add data to all mandatory fields (marked in the table below)
If you're unsure how to fill out non-mandatory fields, leave them blank and make changes to products later.
Column | What is it? | Instructions |
handle | A unique label used to identify the product. | Each product variant must have the same handle as the product. Missing handles are automatically added. |
fieldType | Each row must be a product, a variant, or media. | Field is mandatory Must be PRODUCT, VARIANT or MEDIA. This field is case sensitive. |
name | The name you gave your product. | Mandatory for PRODUCTS Rows with VARIANTS or MEDIA should be left blank. Max. length: 80 characters |
visible | If item is hidden or visible in your online store. | Must be TRUE or FALSE. This field is case sensitive. If left blank, marked as TRUE |
plainDescription | Your product description. | Max. length: 16000 characters |
categorySlugs | The names of the categories the product is in. | Enter all categories, separated by semicolons [ ; ] Notes: You can create new categories, but cannot nest them. You'll need to create the hierarchy in the dashboard. |
primaryCategorySlug | The name of product's primary category. | Learn more about primary categories. |
media | Your images, GIFs, or videos. | Must contain either 1 media URL or 1 media ID. Media IDs are automatically added when exporting. For new media, add an image URL to the template. Tip: See FAQ below to learn how to find the URL of uploaded media. Important: Add each product image, GIF, or video in a separate row. The row order determines the media display order on your site. |
mediaAltText | Alt text added to media. | |
ribbon | Ribbon that appears on product on live site. (e.g. New) | Max. length: 30 characters 1 ribbon allowed per product. |
brand | The product brand attribute. | Max. length: 50 characters |
price | The current price of the product or variant. | Field is mandatory |
strikethroughPrice | Strikethrough price is a display of a crossed-out original price. | Must be higher than the product's price. |
baseUnit | The price per unit base price. | E.g. to define a price per 100 grams, enter 100. This price is per product. |
baseUnitMeasurement | The unit of measure used for the base unit. | E.g. to define a price per 100 grams, enter G. This field is case sensitive. Supported units: SQFT, YD, FT, IN, GAL, QT, PT, FLOZ, LB, OZ, SQM, M, CM, MM, KG, G, MG, CBM, L, CL, ML, UNSPECIFIED |
totalUnits | Actual measure of the product or variant. Used for price per unit. | E.g. if a product contain 500 grams, enter 500. For products with variants, leave the product row empty. |
totalUnitsMeasurement | The unit of measure used for the total product quantity. | E.g. if a product contain 500 grams, enter G. For products with variants, leave the product row empty. This field is case sensitive. Supported units: SQFT, YD, FT, IN, GAL, QT, PT, FLOZ, LB, OZ, SQM, M, CM, MM, KG, G, MG, CBM, L, CL, ML, UNSPECIFIED |
cost | The product's cost of goods. | No more than 9 digits No more than 2 digits after decimal point |
inventory | Product or variant inventory amount | Must be IN_STOCK, OUT_OF_STOCK, or an inventory number (e.g. 55). This field is case sensitive. Fields left blank are automatically marked OUT_OF_STOCK |
preOrderEnabled | Whether pre-order is enabled for this product/ variant | Must be TRUE or FALSE. This field is case sensitive. |
preOrderMessage | Message displayed to customers on a pre-order product or variant. | Text must be between 1 to 250 characters. |
preOrderLimit | Number of products or variants customers can pre-order. | To set a pre-order limit, you need to enter a specific inventory number in the Inventory column (not IN_STOCK or OUT_OF_STOCK) |
sku | Stock keeping unit of the product or variant. | Max. length: 40 characters Can be made up of characters or digits. Variant SKUs should be unique. |
barcode | The barcode of the product or variant. | Max. length: 40 characters Must be unique |
weight | Product or variant's shipping weight | No more than 9 digits No more than 3 digits after decimal point |
packageLength | Length of the product package. | Must be greater than 0, up to 2 decimal places. If you enter a value in any dimension field, all 3 must be filled (packageLength, packageWidth, packageHeight). Leave all 3 blank to clear the dimensions for that product or variant. For products with variants, leave the product row empty. Example: 20 |
packageWidth | Width of the product package. | Must be greater than 0, up to 2 decimal places. For products with variants, leave the product row empty. Example: 10.5 |
packageHeight | Height of the product package. | Must be 0 or greater, up to 2 decimal places. For products with variants, leave the product row empty. Example: 5 or 0 |
packageUnit | The unit for all 3 dimension values (length, width, height). | Units can be mm, cm, m, in, ft, yd (not case sensitive). Must match the store's measurement unit setting — a mismatch results in an error. For products with variants, leave the product row empty. Example: cm |
productOptionName[1] | The name you gave to a product option (e.g. color, size) | Max. length: 50 characters |
productOptionType[1] | The type of product option, color or drop-down. | Mandatory for product options. Must be either SWATCH_CHOICES or TEXT_CHOICES This field is case sensitive. |
productOptionChoices[1] | Option choices | PRODUCT rows: Enter all products options, separated by semicolons [ ; ] Examples: Small;Medium;Large or #FFFFFF:White;#808080:Grey VARIANT rows: Enter a single product option choice. Examples: Small or #FFFFF:White |
modifierName[1] | The name you gave to a product modifier (e.g. Name to Embroider) | Max. length: 50 characters |
modifierType[1] | The type of modifier: color drop-down, or text. | Must be either SWATCH_CHOICES, TEXT_CHOICES, or FREE_TEXT This field is case sensitive. |
modifierCharLimit[1] | The maximum number of characters customers can enter. | Must be 500 or less. Relevant only for FREE_TEXT modifiers. |
modifierMandatory[1] | Whether it's mandatory for customers to fill out the text field. | Must be TRUE or FALSE. Relevant only for FREE_TEXT modifiers. This field is case sensitive. |
modifierDescription[1] | Modifier choices. | SWATCH_CHOICES: Enter the color choices separated by semicolons [ ; ] TEXT_CHOICES: Enter the drop-down choices, separated by a semicolons [ ; ] FREE_TEXT: Enter the field title. Max. length: 150 characters |
Step 3 | Import your file
Now you can go back to the Wix dashboard and import the file. Click Continue to get started.
To import your file:
Go to Store Products in your site's dashboard.
If the import screen is not already open, reopen it:
Click More Actions.
Click Import.
Click Continue.
Click Upload File and upload your saved file.
Click Import.
Note: You'll see a summary of successfully uploaded items. Any errors will be displayed by row for review.
Note:
If you have many products, it may take up to one hour for images to upload. You can continue working on your store while the uploads complete in the background.
Step 4 | Handling Errors
If any of the rows in the file contain critical errors, you'll see it in the summary as soon as the import is complete. For more detailed information, click Generate Error CSV.
To handle errors & upload a corrected file:
Click Generate Error CSV and open the file.
Review the errors.
Note: Learn more about what the import errors mean and how to fix them.
Go back to the CSV file, and correct the errors.
Click Import Another File to import the corrected file.
FAQs
Click a question below to learn more about importing products from another eCommerce platform:
Can I use the import tool to move products from one Wix store to another?
Yes. You can export product data from the first Wix store. Then, go to the new store and import your products. Learn more about exporting Wix Stores products and importing to Wix.
Can I use the import tool to make bulk edits to products in my existing Wix store?
Yes. You can export your existing products to a spreadsheet. There, you can update multiple products. After saving your changes, use can import the updated product data back to your store.
Learn how to update products by exporting, updating, and then importing them.
Are there other ways to migrate from other eCommerce platforms?
Yes. You can use the Cart2Cart third-party app to migrate from other platforms:
Learn how to migrate from Shopify using Cart2Cart.
Learn how to migrate from other eCommerce platforms using Cart2Cart.
How can I find the URL of an image, GIF, or video in my Wix store?
Go to Store Products in your site's dashboard.
Select the relevant product.
Click the Plus icon.
In the Site Files tab, click the relevant media item.
Click the relevant image.
Click the File Info section to expand it and click Copy URL.
How many products can I import using one file?
You can import up to:
- 15mb of data
- 10k rows (if there are more, only the first 10K rows will be imported)
Can I import digital products?
No. Importing files containing digital products is currently not supported. Vote for this feature.
Can I import a product file with non-Latin characters?
Yes, but product files with data containing non-Latin characters (e.g. data written in Japanese, Hindi, Arabic) may not upload correctly. To fix this, save the file according to these instructions:
Upload your CSV file to Google Sheets. Learn how to upload to Google Sheets.
Click File, then select Download.
Select Comma-separated values.
Note: Do not open the file.
Can I upload a file with superscript or subscript characters?
Special characters (e.g. trademark signs, registered trademark symbols) display incorrectly when imported. We suggest you remove them from the file and then add them manually to product names, descriptions, or into sections after the import.
What happens if I import from a store with a different currency?
Imported product prices will automatically convert to the currency set in your Wix Store. For example, if your store's currency is USD and you import a product priced at 50 Euros, the price will be displayed as $50.
Need A Professional Website?
Contact Us Today!
I'm a paragraph. I'm connected
I'm a paragraph. I'm connected
I'm a paragraph. I'm connected
I'm a paragraph. I'm connected
I'm a paragraph. I'm connected
I'm a paragraph. I'm connected