การอัปโหลดสินค้าหลายรายการแบบใหม่

SHOPLINE's "Bulk Import Products" feature allows merchants to batch-create multiple product listings. It provides a "Bulk Create Products" template covering basic product information, descriptions, categories, prices, options, and other fields. When merchants need to list a large volume of products at once or regularly update existing product data, using this feature can significantly save time compared to creating listings manually one by one.

The following sections will cover:

• Points to note before importing product data
• How to bulk create products in SHOPLINE Admin?
  • Step 1: Click "Bulk Create Products"
  • Step 2: Download the form and fill it in according to the example
  • Step 3: Upload the file
• Field explanations for bulk product import template
  • Product Handle column (Required)
  • Product Name, Product Summary, Product Description, SEO, Preorder Product, Online Store Publish Status 
  • Product Image, Additional Images
  • Online Store Categories
  • Price, SKU, Quantity
  • Weight (KG), Supplier
  • Product Tag and Hidden Product
  • Custom Filters
  • Excluded Payment Options, Excluded Shipping Options
  • Specifications and Options
  • Variant Price, Variant Weight, SKU
  • Barcode
• Field explanations related to retail store
• How to handle import report failures?

1. Points to note before importing product data

Before starting to import product data, please pay attention to the following points:

• The 3 fields "Product Handle", "Product Name", and "Main Product Image" must not be left blank; otherwise, the data cannot be imported. Please use the template provided by the system to enter product data.
• For a complete product, in addition to the required fields above, it is recommended to include "Price", "Inventory Quantity", and "Product Category". If you do not fill in the "Price" field, the system will automatically set the price as hidden after bulk importing products, and customers can only contact the merchant to purchase instead of buying directly.
• Please be sure to use Excel or Google Sheets to edit the file and verify the content before uploading. If some products in the file already exist in the store but are entered into the spreadsheet and imported again, duplicate products will appear in the store.
• You can import up to 20,000 data rows at a time (excluding header rows). For example: if there are two main products in the import file, one with a single spec (treated as 1 row) and another split into three variants based on different specs (treated as 3 rows), importing this file will count as 4 data rows in total.

2. How to bulk create products in SHOPLINE Admin?

Step 1: Click "Bulk Create Products" 

Go to SHOPLINE Admin > [Products & Categories] > [Products], open the Import drop-down menu, and click Bulk Create Products.

On the page below, first click example.xlsx to download the file and read the instructions carefully, then click Download Template to enter product data.

*Note: If you are using this feature for the first time, please download and read the sample data for bulk product import (example.xlsx) first, which contains bulk import instructions and file filling examples. Please use the template provided by the system to enter product data.

Step 2: Download the form and fill it in according to the example

After downloading the file, start entering product data according to the Field explanations:

Before starting to fill in, please note:

• Starting from the 3rd row of the template, each row can add a new product item.
• Do not modify column names, or insert/delete columns in the table.
• Each product must have at least "Product Handle, Product Name, Main Product Image".
• If your store supports multiple languages, the system will generate an import template based on your supported languages; product names, spec names (if any), and option names (if any) must be entered in at least one language.
• If you only need to upload data in a specific language, do not enter data for other languages, and do not delete columns for other languages.
• Please ensure all categories are already set up in the Admin before using batch upload; the system cannot create new categories during batch upload.
• Image links must not contain spaces.
• If you change member tier names, you must export a new template file again.
• Member tier names must not duplicate each other or match "Member Price"; otherwise, the system cannot fetch the correct data.
• Retail store branch names must not duplicate each other; otherwise, the system cannot fetch the correct branch price data.

Step 3: Upload the file

After completing the entries, save the spreadsheet, return to SHOPLINE Admin, click Choose File, and upload the saved spreadsheet.

After uploading, an import completion page will be displayed.

3. Field explanations for bulk product import template

The following will demonstrate step by step how to fill out the bulk product import table.

*Note: The field positions below apply only to the example below. Because supported languages vary by store, final output field positions will differ.

 

1. Product Handle column (Required)

Please enter the same handle for the same product, meaning specification options under the same main product must also share the same product handle.

2. Product Name, Product Summary, Product Description, SEO, Preorder Product, Online Store Publish Status 

• Product Name: Product Name is a required field, please fill it in completely. (If only Chinese information is available, leave the English field blank.)
• Product Summary: If only Chinese information is available, leave the English field blank, and enter up to 300 characters max.
• Product Description: If only Chinese information is available, leave the English field blank.
  The product description field supports HTML syntax. If your HTML code is correct, the system can parse the data.
  If text in the product description needs line breaks or other styles, please enter corresponding HTML tags yourself.
  
  The following uses "line break effect" as an example:
  *Note: If line breaks are needed, please enter the line break tag <br>.
  
  After uploading, line breaks will be displayed on the storefront:
  
   
• SEO Title/Description: A brief product description used for display when sharing on social media, search engines, etc.
• Preorder Product: Enter "Y" to set the product as a preorder item; enter "N" to not set it as a preorder item.
   
• Online Store Publish Status: Enter "Y" to publish the product after import; enter "N" to unpublish.

3. Product Image, Additional Images

• You can add images (product thumbnails, main images) and additional images for each product (used in more details below product description).
• Please paste the image URL directly. If there is more than one main product image or additional image, enter a space between two URLs as a separator.

*Note: SHOPLINE has fully upgraded SSL encryption. Please make sure to update URLs to start with "https" to prevent browsers from blocking HTTP non-secure URLs.

How to obtain image URLs?

1. Use SHOPLINE's Gallery feature to upload images to "Gallery" and copy image links. For instructions, please refer to: Gallery.
2. Use other online image hosting services that support SSL encryption and public hotlinking (such as "Imgur" or "Facebook"). After uploading, right-click on the image and select "Copy image address" to get the image URL.
3. Search for your product image on a search engine. Open the image in a new tab, right-click the image, and select "Copy image address" to get the URL. Please pay attention to image copyright issues. For detailed explanations, please refer to Google FAQ.

4. Online Store Categories

Before adding categories to the table, please make sure you have created corresponding categories in [Products & Categories] > [Products] > Categories. 

There are 3 modes for assigning categories:

• Assign to main category: If you only need it to appear in a main category, enter "Electronics" directly.
• Assign to subcategory: Connect using ">" (half-width character without spaces before or after), e.g., "Electronics > Mobile Phones".
• Assign to multiple categories: Connect using line breaks.

*Note: If you delete the default "Featured Products" category and create another category with the same name, the system will not support batch/bulk imported products selecting that category; it is recommended to adjust naming, using names like Featured Category, Featured Items, etc.

If you do not have English categories, you do not need to add content to the English column.

5. Price, SKU, Quantity

Enter your product information item by item. If "Quantity" is left blank, it indicates unlimited product inventory.

*Note:

• If your product has different variants/specs, please refer to the "Specifications and Options" fields below to set corresponding quantity, price, and SKU for variant items under "Option Quantity", "Option Price", and "Option SKU".
• Fields related to "Price" and "Quantity" only support inputting "positive integers".
• Branch prices are only supported for merchants on "e-Commerce + Retail POS / Social Commerce + Retail POS / e-Commerce + Social Commerce + Retail POS" plans, and merchants must toggle on "Set different store-specific prices for products" on the product setup page. For details, please refer to: [Coming Soon] Store-specific Price | POS Admin.

6. Weight (KG), Supplier

Weight: In response to the new weight-based shipping setup feature, adjustments have also been made to the template.

Merchants can fill in weight (in KG) to calculate checkout shipping fees by weight. If left blank, the system defaults to 0 kg.

Supplier: If a supplier was not created previously under Admin [Inventory Management] > [Supplier], new suppliers cannot be added via bulk import/update files.

*Note:

• If the product has multiple variants, please fill in the "Variant Weight" column to correctly calculate shipping fees for variant products.
• The "Weight" field only supports inputting up to "two decimal places".

7. Product Tag and Hidden Product

Product Tag: Set product tags for easy backend management. Each tag requires at least 3 characters. For example: AAA or ABC.

Hidden Product: Enter "Y" to set the item as a hidden product, which will not be displayed on the storefront. You can send hidden product links to specified customers for private purchase. For regular products, leave blank or enter "N".

8. Custom Filters

Enter Custom Filters already created in SHOPLINE Admin. If entering multiple filter conditions, separate them with line breaks.

*Note:

• You can only enter existing custom filter condition names; you cannot add or edit filter conditions within the file.
• If left blank, the product will still be created successfully, but no custom filter conditions will be applied.
• If any non-existent custom filter condition name is entered, product creation for that item will fail, without affecting other products.

9. Excluded Payment Options, Excluded Shipping Options

Enter the payment or shipping option names configured in your Admin, using line breaks to distinguish different options. Leave blank if removing existing content.

*Note:

• If any non-existent payment or shipping option name is entered, the update will fail.
• If you have configured payment or shipping options with identical names, the system will execute the option created earlier. It is recommended to rename options temporarily not in use for easier distinction.

10. Specifications and Options

First set different product specification names, such as "Color" or "Size".

*Note:

• If text entered exactly matches Color or Size, it can be automatically set as default specifications (applicable to 5 languages: Traditional Chinese / Simplified Chinese / English / Vietnamese / Thai).
• Product spec names are required in the store's default language (Traditional Chinese); otherwise, the system will recognize them as custom fields (and treat them as empty values).

Then fill in corresponding option names, quantities, and prices for each spec according to your needs, or enter variant image URLs.

*Note:

• Duplicate option names cannot be used within the same language.

  Spec Name 1 (Chinese)	Spec Name 2 (Chinese)	Option Name A (Chinese)	Option Name B (Chinese)
  Color	Size	Yellow	M
  		Yellow	L
  		Yellow	M
  		Green	L

   

• Translations corresponding to the same option name must be identical.
  Example illustration: The English translation corresponding to option name "Green" is inconsistent, resulting in product import failure.

  Spec Name 1 (Chinese)	Spec Name 2 (Chinese)	Option Name A (Chinese)	Option Name A (English)	Option Name B (Chinese)	Option Name B (English)
  Color	Size	Yellow	yellow	M	M
  		Yellow	yellow	L	L
  		Green	green	M	M
  		Green	grean	L	L

   

• Translations corresponding to different option names cannot be identical, but can be left blank.
  Example illustration: Option name "M" corresponds to English "M". If option name "L" also enters English "M", product import will fail.

  Spec Name 1 (Chinese)	Spec Name 2 (Chinese)	Option Name A (Chinese)	Option Name A (English)	Option Name B (Chinese)	Option Name B (English)
  Color	Size	Yellow	yellow	M	M
  		Yellow	yellow	L	M
  		Green	green	M	M
  		Green	green	L	L

If you want to set corresponding images for variant products, please enter an image URL starting with https directly in the variant image column.

• This field is optional. If left blank, the variant product will display the first main product image on the storefront.
• This field can enter up to one image URL starting with https. Entering multiple URLs will result in failure to import products.

*Note: If you do not know how to obtain an image URL, please refer to Step 3 above "Tip: How to obtain image URLs".

 

11. Variant Price, Variant Weight, SKU

You can enter distinct SKUs for individual variant products to track inventory levels for each variant clearly.

To configure different specifications and corresponding variants for a product, fill in Spec A, Spec B, Option Quantity (quantity per option), Option Price (price per option), and Option SKU (SKU per option) from top to bottom. Once a product entry is complete, continue immediately with the next product line by line.

12. Barcode

You can set corresponding "Barcodes" for different option products.

• If you are a POS user, imported product barcodes will sync to the POS app for use. If the "Barcode" column is left blank, the system will automatically generate an 8-digit barcode.
• After importing, if you need to view the "Barcode", go to SHOPLINE Admin > Products > Edit > Product Feed Data tab. If you need to use the Barcode field but have not enabled the Product Feed Data tab, please contact an online consultant.

4. Field explanations related to retail store

If you are a merchant subscribed to O2O plan, Retail POS plan, or e-Commerce + Retail POS plan, the bulk product import table supports the following retail store exclusive fields: Store-specific Price, Variant Store-specific Price, Retail Store Status, POS Categories, Supplier, Retail Store Price, Variant Retail Store Price.

*Note: Other template columns will shift right accordingly.

1. Store-specific Price, Variant Store-specific Price

*Store-specific price is only supported for merchants on the "Retail POS" plan, and merchants must toggle on "Set different store-specific prices for products" on the product setup page. For details, please refer to: [Coming Soon] Store-specific Price | POS Admin.

Please enter the price for each branch in the "Store-specific Price" field. If the item is a multi-variant product, fill in the price for each variant across branches under the "Variant Store-specific Price" field.

• Store-specific Price:
  
   

• Variant Store-specific Price:
  

2. Online Store Publish Status, Retail Store Status

Please update your product's online status using the "Online Store Publish Status" column, and update your product's retail store status using the "Retail Store Status" column.

• Online Store Publish Status: Enter "Y" to set product as published after import; "N" to set as unpublished. If left blank, it is treated as unpublished.
• Retail Store Status: Enter "Y" to set product as published after import; "N" to set as unpublished. If left blank, it is treated as unpublished.

3. Online Store Categories, POS Categories

• Online Store Categories: Before adding online store categories in the table, please ensure you have created corresponding categories in [Products & Categories] > [Categories]. If you do not have English categories, leave the English field blank.
  There are several modes for assigning categories:
  • Assign to main category: If you only need it to appear in a main category, enter "Electronics" directly.
  • Assign to subcategory: Connect using ">" (half-width character without spaces before or after), e.g., "Electronics>Mobile Phones".
  • Assign to multiple categories: Separate using line breaks.

• POS Categories: Before adding POS categories in the table, please ensure you have created corresponding categories in [Products & Categories] > [Categories]. Unlike online store categories, POS categories only support importing "main categories".
  If you do not have English POS categories, leave the English field blank.

*Note:

• POS categories currently do not support subcategory setup, so you cannot use ">" to assign to subcategories during import.
• A product currently cannot be assigned to multiple POS categories at the same time, so you cannot use "#" to assign to multiple categories during import.

5. How to handle import report failures?

If certain product information in the template contains errors leading to import failure, the system will first import products with correct information. You can check the overall results under "Bulk Import/Export Progress" or go to [Report & Analytics] > [Bulk Process Progress], and click Download failure report to adjust the failed product data.

The failure report lists the failed products and error fields.

The last column of the report indicates the specific reason for failure. You can adjust the contents of the import table accordingly and re-import products following the steps above.

To speed up system import efficiency, the display order of new products within product categories follows the processing completion sequence. You can also manually adjust the sequence on the Product Category page.
 

Other pages such as the Admin Product List, Inventory Management page, and storefront All Products page will display items according to their order in the file.

Read more

• Add Products | Products
• How to bulk update products?

Last updated: September 2, 2026