The batch tool also supports the generation of templates for batch modification of basic information, sales information, and shipping information. Through these templates, we can batch edit product information, prices, inventory, and delivery information. Similarly, click the drop-down menu to the right of “My Products” – “Batch Tools” and select the “Batch Update” option.
In the “Batch Update” page, we can see that the Shopee platform supports generating batch update templates for sellers to download. These templates can be saved for 30 days. It should be noted that the tables generated by batch updates on the Shopee platform also require Microsoft Excel 2007 or above to be opened, and the uploaded file cannot exceed 5MB.
We can select the template that needs to be generated, click the “Generate” button, and you can see the generated template in “Records”.
The template types that can be generated in the “Batch Update” page are as follows.
1. Basic information template
The basic information template is used to modify product IDs, main product numbers, product names, and product descriptions in batches.
2. Sales data template
Based on the product ID, main product number, product name or variant, we can modify the variant name, variant price, variant inventory and other information . If there are too many products, the sales data template we download may be a compressed package of multiple files.
3. Shipping data template
Based on the product ID, main product number, product name and other information, we can modify the product weight, length, width, height, shipping method switch and freight.
4. Shipping days data template
Based on product ID, main product number, product name, product classification and other information, we can modify the stocking days and pre-sale of non-pre-sale products The preparation time and stocking days of the product. The modifiable value of the stocking days is within the time range of pre-sale products, that is, 5 to 15 days, or the default is 2 days. The default stocking days of non-pre-sale products are 2 days.
It should be noted that in order to avoid misoperation, these documents are in a worksheet protected state by default after downloading and need to be revoked in Excel review before they can be edited.
After completing the batch editing of the above table, click the “Upload” option on the “Batch Update” page and select the edited file to upload. If the upload fails, you can click the “Download” button to view it. The reason for the upload failure. If the upload is successful, it will be displayed as completed. At this time, the batch update process is completed, and the uploaded files will be retained for 30 days. Note: A maximum of 1,000 pieces of product information can be uploaded at one time.