HelpExport your product list
Download an Excel file with all your store's products, to check against, send to your accountant, or edit and import back.
Each variant is one row, with its price, quantity, SKU and image links.
Do it now in .Open Products
Export the product file
- Go to Products.
- If you only need some of the products, search by keyword or filter by status.
- Click More actions › Export. On a phone, tap the three-dot icon More actions and choose Export.
- Check the number of products and the filters in the Export products dialog.
- Click Export.
An .xlsx file downloads to your computer. The file name has your store name and the export date.
Read the exported file
The file has the same columns as the template used to import products. The column headers in the file are in Vietnamese, so the table shows each header with its meaning.
| Column | What it holds |
|---|---|
| ID sản phẩm, Slug sản phẩm, Tên sản phẩm (product ID, product slug, product name) | The product's details, repeated on every variant row of that product. |
| ID SKU, Tùy chọn biến thể (SKU ID, variant options) | The variant's code in EcomWeb and its options, for example Color: Red, Size: M. |
| Giá bán (VND), Số lượng (price in VND, quantity) | The variant's price and the quantity available to sell. |
| SKU người bán (seller SKU) | The SKU you set for the variant. |
| Hình ảnh chính to Hình ảnh 9 (main image to image 9) | Links to the product's images. |
| Ngày tạo, Ngày cập nhật, Trạng thái (created date, updated date, status) | The date created, the date last changed, and the status. |
To edit in bulk and put the changes back in your store, see Import products from an Excel file. To count and edit stock quantities with a file, see Update stock in bulk with a file.
Thanks for your feedback.