You can use SHOPLINE’s Bulk Product Editor to mass update products and product variations in your online store. This tool allows you to edit multiple product properties, including name, SKU, images, price, stock, weight, etc. Product information is presented in a tabular sheet which makes the mass editing process fast and easy.
The Bulk product editor is available from Products page in your SHOPLINE admin. You can use this function to instantly enable, disable, or delete selected products, change prices, and more.
Download SHOPLINE Bulk Import Template
CSV format has the advantage of saving a large amount of data in a small file size. Thus, SHOPLINE uses CSV documents for bulk import and export product management.
Currently, the system only recognises properly formatted CSV files. CSV is a special data storage file format. Some versions of Microsoft Excel cannot open the CSV file correctly. Please use a professional CSV editor or WPS software to edit and save the file to avoid file format damage and failure in importing product information.
| Do not modify the field content and field order in the first row of the template, as that may cause import failure. |
Table of content
- Bulk import form introduction
- Editing product properties
- Bulk edit via bulk editor tool
- View bulk product import progress
Bulk import form introduction
- Please complete all mandatory fields marked with an "*".
- Please pay attention to the instructions for filling in each field to avoid import failure.
- When doing an overwrite update, SHOPLINE will overwrite any existing products with the same handle and existing values will be used for any missing columns.
- For example, if Product A is under the Brand "Apple", yet the "Brand" column of Product A is empty in the CSV file, the brand information of Product A will be overwritten with a blank after the import.
- You can leave the optional fields blank, but do not delete the column.
You can edit the following product properties using Bulk Product Editor:
|
Fields in the form |
Instruction |
|
Handle |
Optional.
(If you wish to overwrite the current product information, please keep the product handle in the form the same as that of the existing product, all the information of the corresponding product will be overwritten) |
|
Title* |
Title of the product, e.g. Hard disk
|
|
Subtitle |
Optional. A brief note of the product, e.g. Generation X
|
|
Product Description Html |
Optional.
|
|
Brand |
Optional. The brand name.
|
|
Tags |
Optional. Product tags, e.g.: shirt, beauty, summer
|
|
Collections |
Optional. Name of the collection/category, e.g.: shirt, beauty, summer
|
|
Master Image |
Optional.
|
|
SEO title |
Optional.
|
|
SEO description |
Optional.
|
|
SEO keywords |
Optional. |
|
Status |
Optional.
|
|
SKU |
Optional.
|
|
Option1 name |
Optional. Enter the first option if the product has multiple options, e.g.: "Color".
|
|
Option1 value |
Optional. If the product has multiple options, enter the value corresponding to the first option, e.g.: "Yellow".
|
|
Option2 name |
Same as the Option1 name
|
|
Option2 value |
Same as Option1 value |
|
Option3 name |
Same as Option1 name |
|
Option3 value |
Same as Option1 value |
|
Option4 name |
Same as Option1 name |
|
Option4 value |
Same as Option1 value |
|
Option5 name |
Same as Option1 name |
|
Option5 value |
Same as Option1 value |
|
Image |
Optional. Image of the option. 1 image for 1 SKU only.
|
|
SKU price |
Optional. Product price per SKU.
|
|
SKU compare at price |
Optional.
|
|
SKU weight |
Optional.
|
|
SKU weight unit |
Optional.
|
|
SKU Inventory Tracker |
If you enable inventory tracking, the inventory will change with the sale of goods. If not, the inventory quantity remains unchanged.
|
|
SKU Inventory Policy
|
If you allow the product to be oversold, when the product inventory reaches 0, the product is still available for sale.
|
|
SKU inventory quantity
|
Optional.
|
|
Cost per item
|
Optional.
|
|
Barcode (ISBN, UPC, GTIN, etc.)
|
Optional.
|
Editing product properties
Once you select products for editing and proceed to the Bulk Product Editor sheet, you will see these products, as well as their variations, listed in the table. Products are table rows, and product properties are table columns:
You can edit the columns related to the headers in the sheet.
To bulk edit product properties:
-
From your SHOPLINE admin, go to Products.
- Bulk Select, then Export the products you want to bulk edit.
- Download the export file from your inbox.
- Open CSV file. Click on the profile icon and select Bulk processing progress > click All records.
- Make the necessary changes and click Save.
Bulk edit via bulk editor tool
You can edit the following properties using Bulk Product Editor:
- Name
- SKU
- Price
- Compare at price
- Tax
- Fulfillment
- Brand
- Category
- Barcode
- Weight
Before entering the Bulk Product Editor, you need to choose which products you want to update. You can either mass update all the products in your SHOPLINE store or select several items.
To mass edit your product properties:
-
From your SHOPLINE admin, go to Products.
- Select the products you want to bulk edit.
- Click on Enter the bulk editor.
-
After you click on Enter the bulk editor, you can edit the product properties.
- Click Update.
Viewing bulk product import progress
If some products are filled incorrectly and the update fails, you can download the reason for failure on the progress page. If the updated files contain both correct and incorrect product information updates, the correct portion will still update as usual.
Once you have finished the steps above, you will be able to bulk edit products including bulk publish/unpublish/deletion or import product information to efficiently manage your product information.
To view bulk processing progress:
- From your SHOPLINE admin, go to Admin (icon).
- Click on Bulking processing progress to view import/export records.
Get in touch
SHOPLINE has a specialized Merchant Success Team available to assist you with any questions or issues. Please feel free to contact us via the chatbox in the lower right corner of your SHOPLINE admin panel or on the SHOPLINE official website. We are always here to support you every step of the way and help your business thrive.
Comments