As your online store matures and the number of products increases, SHOPLINE offers the "Bulk Update Products" feature to save you time and manpower. After downloading the file, fill in the corresponding fields. You can update up to 500 main products at once, significantly enhancing operational efficiency.
⚠️ Before you start, please be reminded:
- "Bulk Update Products" is currently available to update the product information in Traditional Chinese, Simplified Chinese, English, Vietnamese, Thai, and Malay. (Multi-language support including Japanese, Indonesian, German, and French will be available soon.)
- If your system supports multiple languages, it will generate the file according to your language setting.
- If the barcode of any product in the file begins with "0" (for example, 00056789), before uploading the file, please make sure to change the cell format of the barcode field to "Text" so that the system can read the barcode properly.
- Names of the membership tier cannot be repeated or identical to "Member Price". Otherwise, the system will not be able to obtain the correct data, and upload failure will occur.
- Names of different stores cannot be repeated. Otherwise, the system will not be able to obtain the correct data of Store-Specific Prices, and upload failure will occur.
This article will cover the following:
- Download current product information
- Update product data
- Upload the edited file
- Check the update progress
1. Download current product information
In the SHOPLINE Admin, go to [Products & Categories] > [Products]. Then, click the Import button and select Bulk Import/Update.
Upon entering the Bulk Update Products page (as shown below), click on the Export Product Bulk Update File button in the second section. The system will send a download link for an Excel file to your email inbox.
*Note: Starting from 21 August 2024, the Excel file will be updated to the latest version. If you've previously downloaded and saved an old version, please click Export Product Bulk Update File again to download the latest version. Using the old version may cause update failures.
If you have activated the Advance Store Management Tools module for your store, you can update up to 500 main products in a single batch (each main product can have up to 400 variations), which means you can upload up to 200,000 products with variations in one go. If this module has not been activated, a main product can have up to 100 variations only.
*Note: The system only allows for updating a maximum of 500 main products in a single batch. Therefore, the update form will be exported in batches, each containing up to 500 main products.
2. Update product data
i. Product name (Chinese & English)
- You can edit the product name.
- The product name will also support multi-language including, Japanese, Indonesian, German, and French (Coming Soon)
- Note: At least one Chinese or English name is required.
ii. Product Summary
- You can edit the product summary. If you have only English content for this field, please leave other fields blank.
- The text limit is 300 characters.
- The product name will also support multi-language including, Japanese, Indonesian, German, and French (Coming Soon)
iii. SEO Title/Description/Keywords
- You can change SEO Title / Description / Keywords for products.
- SEO Title/ Description will also support multi-language including Japanese, Indonesian, German, and French (Coming Soon)
- Note: SEO description has a text limit of 55 characters (spaces and wrap text included).
iv. Hidden Product
- Available for Premium, O2O, and Enterprise Plan
- You can set your product as hidden
- Please use Y/N to set, Y = hidden, N = not hidden.
- You need to publish the product before setting it to hidden. If you need to change the status of the unpublished product to "Hidden," please also change the product status to published (Y).
v. Preorder Product and Notes
- You can set preorder status and notes for products.
- please use Y/N to set, Y = preorder product, N = normal product.
- Preorder Notes will also support multi-language including Japanese, Indonesian, German, and French (coming soon)
vi. Retail Store Status
- You can set publish status for products.
- please use Y/N to set, Y = publish, N = un-publish.
- Bulk import file supports the "Retail Store Status" column.
vii. POS Categories
- Changing the POS category of the main product is supported.
- If your POS category has a Chinese and an English title, you can change the title in either language to update the category.
- Adding new categories in the bulk update file is currently not supported. Before uploading the bulk update file, please make sure you have added the corresponding POS categories in [Products & Categories] > [Categories].
- This column is only available for merchants using O2O, Retail POS, e-Commerce + Retail POS plans.
viii. Price
- You can change the Regular Price, Sale Price, Retail Store Price, Store-specific Price, Member Price, and Membership Tier Price.
-
Notes:
- The Price field is only available for merchants using O2O and Enterprise Plans. Member Price is only available for merchants using the "CRM- Membership" module.
- Retail Store Price is only available for merchants using both e-Commerce + Retail POS plans.
- Store-Specific Price is only available for merchants using the "e-Commerce+Retail POS/ Social Commerce+Retail POS/ e-Commerce+Social Commerce+Retail POS" plans, and merchants must switch on the "Set Store-Specific Prices for products" toggle in the SHOPLINE Admin. For more information, please refer to Store-Specific Price｜POS Admin.
- If you have set all variations to have the same price, the price of variations will show as "same price". To set different prices to variations, please disable the same price option first by inputting N under "Same Price".
- If you have set a hidden price, all prices of variations and the main product will appear hidden. If you want to change prices, please input N for "hide price" before updating the prices.
- If a certain product does not have a Member Price/Variant member price, the fields should appear as 0 in the bulk update file. Please fill in numbers greater than 0 to set the Member.
🔔 Example:
- You can only change the number under the column "Member Price" but not the name "Member Price" or the membership tier order. Update failure will occur when you modify the header fields and try to import the file.
- If a product has two variations, when you want to update the quantity of variation A only, please keep the product data of variation B even if there is no change on that.
ix. Product Cost
- You can edit the cost of the main product and each variant.
x. SKU
- You can edit the SKU of the main product and each variation.
xi. Location ID
- You can edit the Product Location ID.
- location ID has an upper limit of 40 characters.
xii. Inventory
- You can check the current inventory of products in column "Quantity" of your downloaded file but DO NOT EDIT this column.
- If you want to change the quantity of the product, please fill in the column "Update Quantity" by the value you want to add or reduce (if you want to reduce the quantity, remember to put “-” before the value e.g. -10)
- Note: If you want to change the inventory status of a product from unlimited to limited, please enter N in the “unlimited quantity” field or your edit will not be applied. Also, the default quantity after you change "unlimited quantity" to N will be the inventory quantity that you have set before changing "unlimited quantity" to Y. It is recommended that you change the quantity after the update.
xiii. Product Weight
- You can set the weight of the main product and each variant.
- The value would be used to calculate the shipping cost when it is determined by weight.
- Note: the unit of weight will be in kilogram(kg), and only supports the second digit after the decimal.
xiv. Product Tags
- You can set product tags
- Note: Each tag must contain at least 3 characters, and please use a comma (,) to separate different tags.
xv. Product not applicable to discount
- You can set whether the product is applicable to discounts.
- Please use Y/N to set, Y= applicable to discounts, N= not applicable to discounts.
- Leaving the field blank is considered applicable to discounts. If content other than Y or N is entered, the update will fail and an error prompt will appear.
xvi. Product Promotion Label
- You can set the promotion label of the product.
- If your system supports multiple languages, the system will display the fields according to your language setting.
- Product Promotion Label is displayed in the main product field, and editing must also be done in the main product field.
- When Product Promotion Labels are entered in other fields, the system will automatically ignore them.
- Leaving the main product field blank is considered removing the label.
- Supports input in Traditional Chinese and English, special characters and emojis, e.g., !@#$%^& 😍✔.
- The input is limited to 20 characters. If the input exceeds the limit, the update will fail and an error prompt will appear.
xvii. Product Feed Data (optional)
- You can set product brand, MPN, and barcode.
xviii. Fixed Columns (do not edit)
- Please be noted that the columns that are marked “do not edit” (product ID, SL_Key...etc) should not be edited, or there will be errors in your upload.
3. Upload the edited file
Upload the .xlsx/ .xls file on the "Bulk Import/Update" page.
If the file is too large and causes upload/ update failures, the system will display a failure prompt (see below). Please adjust the file size and try again.
4. Check the updating progress
After updating the spreadsheet, you can view the updating progress on the [Report & Analytics] > [Bulk Action Process].
If there are products that can't be successfully updated, you can download the failure report for reference.
If the updated file contains both valid and invalid products, the valid product would still be updated, while the update of the invalid product would be blocked.
*Note: If there is any failed result, please export the latest product update file first and correct the latest download file before reloading.
Read more
Comments