Bulk Upload Products

6.SHOPLINE_Support_All-Plan.png

Attention before uploading file:

  • There are four fields you must fill in the bulk upload file. Please fill in the information  completely: Product Handle, Product Name (either Chinese or English), Valid image for main product image, Product description. You can not leave these fields blank or the file won’t be uploaded. Please download our template file and fill in the product information.
  • Besides those four fields above, we suggest that a complete product should contains Price, Quantity, Categories (either Chinese or English).E.g. if you do not fill in the price, our system will hide the price automatically after uploading. Customers can only send message to shop owner for purchasing。
  • Before import the file, please confirm all the content you are going to upload.
    If those products which you filled into the file are already exist in your shop, the system will still import those products and make the duplication in your shop.
  • This feature supports merchant to upload 100 products each time at most currently. ( It depends on the total amount of main products, not counts the product’s multiple variation. )

 

The following article will guide you through the procedure of uploading products in bulk via Excel sheet.

Step 1: Click "Bulk Import"

"Products and Categories" > "Products" > Select "Import" drop down box > Click "Bulk Import"EN_Step1-1.png

 

Enter this pageEN_Step1-2.png

Tip: If this is the first time you use this feature, we strongly recommend you download and read the instruction file (bulkupload_instruction.xlsx)

 

Step 2: Download the form

First, download the form "my_upload.xlsx" and open it on your computerEN_Step2.png

 

Please be reminded that:

  • This form includes product information, descriptions, categories, price and options fields

  • Starting from Row 3, you can add a new product on every line

  • Please do NOT delete or change the columns of this form

  • Every new product should at least has Product Name, Product Description and Images. You can provide both Chinese and English version at the same time. If you wish to use only one language, please leave fields in other language in blank (Column B, D, F, H, L, Q, Y, AA, AC, AE)

  • Please make sure all categories you use are already configured in admin panel. Currently we cannot create new categories in bulk import (Column Q, R)

  • Please do NOT include space in your image links (Column O, P) 

  • We recommend you import no more than 100 products at the same time

 

Let’s see how to add a new product entry step-by-step

 

Step 3: Product Basic Information 

Column A: Product Handle is mandatory
Fill in the cell with a designated number and also for the following rows of the product's variation.EN_Step3.png

 

Step 4: Product Name, Product Description, SEO, etc.

  • Column B~C: Product Name is mandatory.
    If you only have English version, please leave these Chinese fields blank.
  • Column D~E:Product Description 
    The format or performance of description on storefront could be changed by corresponding HTML code.

    For instance, to see wrapped text, you could insert a code <br>.
    EN_Step4-1.png
    The storefront would display texts like this after uploading:EN_Step4-2.png

 

  • Column F~J: Product SEO description
    It can be a simple sentence about your product. It will usually be shown on the search engines like Google and social media sharing.

  • Column K: Preorder Item
    Filling "Y" in Preorder Item, this product will be published as a preorder item.

  • Column N: Status 
    Filling "Y" in Status will makes this product published automatically after import; "N" means making it as a draft without publishing the product yet.

 

You may also refer to the instruction excel file, as shown below, for the bulk upload format.EN_Step4-3.jpg

Tips: Inputting description more than one line

If your product description is longer than one line, you can edit it first using Word Processor like Microsoft Word and then copy and paste it to Excel. Make sure that all description is in the correct cell.

 

Step 5: Images

You can add Images (used as thumbnails and primary pictures) and Additional Images (shown on More Information section after product description in product page) in bulk upload. 

*SHOPLINE has full updated the SSL (Secure Sockets Layer), please remark your domain URL were changed into "https" at beginning to avoid some browsers block a not secure domain using "http" to load the page.

Please enter the URL of the image directly. If you have more than one image, please use a space to separate two URL.EN_Step5.png

 

Tips: How to Get the URL of Images

You can upload your images to online photo album supporting public links like imgur, Flickr, Facebook or search for photos directly on search engine. After uploading, you can open the photos in a new tab, right click and select “Copy Image URL” to copy the URL.

To learn how to upload images in imgur, refer this link for details

 

Step 6: Categories

Before adding new categories, please make sure that you have added corresponding categories in your admin panel ("Products and Categories"> "Categories")

EN_Step6-1.png

 

There're a few scenarios of assigning products to categories you may want to know: 

  • Only assign to the main category, input the name of the category directly e.g. Digitals
  • Assign to a sub category, use “>” to connect e.g. Digitals > Phone
  • Assign multi-categories to a product at the same time, use “#” to connect e.g. Digitals > Phone#Digitals > Trend

If you don't have Chinese Categories, no need to add on column J

EN_Step6-2.png

 

 

Step 7: Price, SKU and Quantity

Fill in the Price, Sales Price, SKU and Quantity of your main product.

If you leave Quantity blank it means unlimited quantity.

Reminder: If a product has different variations, please refer to "Step 9 Specification and Options" and set up Variation Quantity,  Variation Price, Variation SKU for each variation product.EN_Step7.png

 

Step 8: Weight (kg)

If you are now using the newly launched set delivery fee by weight function, you may also add product weight (in kg) in the bulk upload sheet to help counting the delivery fee as order weight at checkout page

If the field is blank, the product would be set as 0 kg.

Reminder: If a product has different variations, please use Bulk Update Product and fill in "Variant Weight" after the product is uploaded to set weight for each variation product.EN_Step8.png

 

Step 9: Specification and Options

First, you have to set the name of each specification e.g “Color” and “ROM”EN_Step9-1.png

Then fill in the corresponding variation name, quantity and price for each specification. 

Shop owner can edit SKU (Stock Keeping Unit) of each specification right now to show the inventory of each product clearly

If you are typing 

You can add more product variations to each product, according to add Variation A, Variation B, Variation quantity, Variation price and Variation SKU (SKU of each variation) from top to below.
After filling in the former product, the next product is on a following line. Add one product for a line.EN_Step9-2.png

 

Step 10: Upload Bulk Upload File

After finishing inputting all information > go back to SHOPLILNE admin panel > upload that file you've saved. EN_Step10-1.png

 

After uploading the file, you could preview items and check them are correct or not > click "Import products" button.EN_Step10-2.png  

Page as below will be shown after products are successfully imported.EN_Step10-3.png

 

 

 

 

 

 

Have more questions? Submit a request

Comments