HelpImport products from an Excel file
Fill in the template file with your product list and upload it once, instead of adding products one by one. Before importing, you can see how many products in the file are new and how many already exist.
Each row in the file is one variant. Rows with the same product ID are combined into one product.
Download the template
- Go to Products.
- Click Import. If you don’t see this button, click the three-dot icon More actions and choose Import.
- Choose EcomWeb template, then click Continue.
- Click Download template.
Fill in your product list
The template has three header rows and a few example product rows. Keep the three header rows, delete the example rows, then fill in your products from row 4 on. Don’t rename or delete columns. The column headers in the template are in Vietnamese, so the table shows each header with its meaning.
| Column | How to fill it in |
|---|---|
| ID sản phẩm (product ID) | Required. A code you make up, for example SP001. Rows with the same code are the variants of one product. |
| Tên sản phẩm (product name) | Required. |
| Slug sản phẩm (product slug) | The last part of the product's URL. If you leave it empty, EcomWeb creates it from the product name. |
| Tùy chọn biến thể (variant options) | The option name and value, joined with a colon. For several options, separate them with a comma, for example Color: Red, Size: M. Leave it empty if the product has only one kind. |
| Giá bán (VND) (price in VND) | Numbers only, for example 299000. |
| Số lượng (quantity) | A whole number, the stock you have. |
| SKU người bán (seller SKU) | Your own SKU. Optional. |
| Hình ảnh chính, Hình ảnh 2 to Hình ảnh 9 (main image, image 2 to image 9) | A link to an image that anyone can open. EcomWeb downloads the images into your store. |
A product’s name, description and images are taken from that product’s first row. The other columns, such as description, category, weight and size, can be left empty.
Upload the file and import
- Open the Import with EcomWeb template dialog again, as in the section above.
- Turn on Update existing products if you want to change products you already sell. Leave it off if you only add new products.
- Drag the file into the upload box, or click the box to choose the file.
- Read the summary under Preview import. If the file has rows with errors, fix the rows listed and upload it again.
- Click Start import.
You can close the dialog while it imports, and the import keeps running. When it finishes, the dialog shows how many products were imported, couldn’t be imported and were skipped.
Update existing products with a file
EcomWeb recognizes an existing product by the product slug column. The easiest way to get the right slugs is to export a file from your store, edit that file and import it back. See Export your product list.
When Update existing products is on, each product whose slug matches is replaced with what is in the file, including the name, description, images and all variants. When it is off, existing products are skipped.
Import products from TikTok Shop
If you sell on TikTok Shop, you can import the ZIP file exported from TikTok Shop without filling in anything again.
- Go to Products and click Import.
- Choose From another platform, then click Continue.
- Drag the ZIP file into the upload box. If you don’t have the file yet, click How to export from TikTok Shop to see how to get it.
- Check the preview, then click Start import.
For a file from TikTok Shop, Update existing products matches products by their TikTok product ID.
Frequently asked questions
Do imported products show in my store right away?
No. Products imported from the template are in Draft status. Open each product, check it, and change the status to Active when you want to sell it.
I clicked Start import and it says the preview has expired.
The preview is only kept for 30 minutes. Upload the file again to create a new preview.
What if my file is larger than 30MB?
Split the list into several smaller files and import them one at a time.
Thanks for your feedback.