How to mass import product from excel (如何从 Excel 批量导入商品)

 

How to mass import product from excel 

如何从 Excel 批量导入商品

1st Step: Go to backend and login
第一步：登录后台管理系统

2nd Step: Go to items>product information
第二步：进入 “Items（商品）> Product Information（商品信息）”

3rd Step: Click on import
第三步：点击 “Import（导入）”

4th Step: Tick the boxes accordingly (if unsure, just tick all)
第四步：根据需要勾选选项（如果不确定，可全选）

5th Step: Select whether to replace existing item information. (select yes to update product information according to barcode number)(select no when creating new item)
第五步：选择是否替换已有商品信息（选择 “Yes” 根据条码更新商品信息，选择 “No” 创建新商品）

6th Step: Click on select to select your files
第六步：点击 “Select（选择）” 选择文件

7th Step: Click on upload to complete the upload
第七步：点击 “Upload（上传）” 完成导入

8th Step: Wait for the upload to finish. If upload fail, it will prompt an error message below
第八步：等待上传完成，如果上传失败，下方会显示错误信息

-You can click on download import template to get a template excel and fill it up accordingly.
你可以点击 “Download Import Template（下载导入模板）” 获取 Excel 模板并按模板填写

Note: The max amount of item you can upload at a time is 1500.
注意事项：每次最多可导入 1500 条商品

Note: The file must be in xls format and less than 3m
注意事项：文件必须为 xls 格式，且小于 3MB

Note: The barcode number should only be filled with Numbers (you can add a few alphabet and a dash. Eg. S1000-1)
注意事项：条码应主要为数字（可加少量字母和短横线，例如 S1000-1）

Note: You need to filled up all compulsory field(you can fill up stock and cost price as zero if you do not require them)
注意事项：所有必填字段必须填写（如不需要库存或成本价，可填 0）

Note: Ensure all prices field and stock amount are in number format.
注意事项：确保所有价格字段和库存数量为数字格式