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.
{PR.PE.ER.HE.20.01}
{PR.PE.ER.HE.20.02}
{PR.PE.ER.HE.20.03}
Import CSV
1) General
Column header descriptions
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)].
Save the file as XLSX or XLS and upload the file.
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.