Use the tabs to conveniently add products in bulk, bulk change related products, and bulk edit options and stock quantities.
Go to [Add products] tab to add new products or edit existing products, [Related products settings] tab to edit related products, and [Modify options/inventory] to edit items and stocks.
Download template
You need to download the CSV template first to add new products via CSV.
If you want to edit existing products, you need to select the products you wish to edit and click [Export as CSV] button in [Products>Products>Product list]. For editing products, you need to edit product information in basic template.
CSV template will be updated from time to time without prior notice. If an error occurs while trying to add products via CSV, you need to check if the CSV template you are using is up to date.
Import CSV
1) General
Fields that are required when adding new products via CSV differ depending on the settings for [Calculate price based on] in [My Store>Store setup>Settings>Products (Tab)].
File should be saved in .xlsx or .xls format.
You can add up to 1,000 products at a time.
Note that if more than 1,000 variants are added, page may not load properly.
Note that adding unnecessary spaces may cause issues when your file is uploaded.
When you leave some fields empty in the excel file, the corresponding information will not be updated for the product.
If you add other field headers to the basic template and export the data via CSV, the CSV file will be uploaded but the added information will not be updated.
If [Enable auto-translation for option values] is set as [Yes] in [My Store>Store setup>General settings], option values you add will be automatically translated into your multi-language store's language.
3) Adding new products and editing existing product information
(1) Add new products
When adding a new product, leave the product code field empty. The product code is automatically created by the system once a product is added.
If the product has options, variants will be created automatically when products are added via CSV.
(2) Edit products
When editing products via CSV, you can enter the codes of the products you wish to edit.
(Product code refers to a unique code assigned to each product. A product code is generated automatically when the product is added.)
For products with options, you cannot enable or disable options and edit variant selection methods via CSV.
If you need to add options or variants for the product, you should import the relevant data in [Edit options/inventory] tab.
If you do not have permission to add or edit product categories, data for [Product category number], [Product category: New products] and [Product category: Recommended products] cannot be edited.
If you do not have permission to edit products, data for [Product name], [Taxation type], [MSRP], [Cost] and [Price] cannot be edited.
When you edit the information of a product on a multi-language store, check before saving whether the [Apply default store information] option has been enabled before.
