Bulk Product Editor

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 option to instantly enable or 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 recognizes 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.

 

Bulk_Product_Editor_-_1.png

 

Table of content

 


 

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. 

  • The product handle is the only value for identifying each product in the SHOPLINE system
  • Please fill in one row only. Enter one product title for products with multiple variations.
  • The content of this field must be consistent with the product handle to be updated, otherwise, the original product info will not be successfully overwritten and updated.
  • Leave it blank when creating a new handle.
  • When overwriting, all product information (including SKU information) except the handle will be updated.
  • Do not leave spaces in the field. The system will replace all spaces with dashes(-) for data matching.

(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

  • Please fill in one row only. Enter one product title for products with multiple variations.

Subtitle

Optional. A brief note of the product, e.g. Generation X

  • Character limit: 255

Product Description Html

Optional.

  • For multi-SKU products, please fill in the first row.
  • Please upload the description in HTML code if you wish to attach an effect to the storefront.

Brand

Optional. The brand name.

  • Character limit: 64

Tags

Optional. Product tags, e.g.: shirt, beauty, summer

  1. Please keep all tags in a row.
  2. Separate tags by commas.
  3. Case-insensitive, which means "ABC" and "Abc" will be identified as the same tag.

Collections

Optional. Name of the collection/category, e.g.: shirt, beauty, summer

  • Please enter the handle of the collection/category, not the name of the collection. You can find the handle from the SEO link on the product detail page.
    (P)
  • A product can be categorized into multiple collections. Separate the collection handles by commas(,).
  • Enter the data of multiple-SKU products in one row.
  • If you wish to create a new collection, please enter the name in the handle format and replace all spaces with dashes(-). Please make sure that the new handle does not exist in the store or it will result in update failure. SHOPLINE will automatically generate a collection name based on the new handle.
    For example, the value "fashion-shirt" generates a new collection "fashion shirt".
  • The product cannot be bound to a smart category. The system will ignore this if the value matches the handle of a smart category.

Master Image

Optional.

  • Enter the image URL.
  • If you leave this column blank when uploading the CSV file, and check the "Overwrite any current product with the same name" option, the existing images will be cleared.
  • Supported URL formats: JPG, JPEG, PNG, GIF, WEBP; File size: 4MB.
  • Each product can upload up to 40 images.
  • Enter one image URL per cell. If you need to upload multiple product images, you can fill in the image URLs in the vertical order.

SEO title

Optional.

  • Character limit: 255

SEO description

Optional.

  • Character limit: 1024

SEO keywords

Optional.

Status

Optional. 

  • Enter "Y" if the product will be shelved directly after uploading. Otherwise, fill in "N".
  • Enter only the first row for products with multiple variants. The default value is "Y".

SKU

Optional. 

  • If you leave this column blank when uploading the CSV file, and check the "Overwrite any current product with the same name" option, the existing SKUs will be cleared.
  • Each product can enter at most 500 SKUs.
  • 100 characters limit. Data exceeding this character limit will result in upload failure.

Option1 name

Optional. Enter the first option if the product has multiple options, e.g.: "Color".

  • Do not need to fill in option name or value for products with a single option. 
  • Each product can be in 5 options maximum.
  • 50 characters limit.

Option1 value

Optional. If the product has multiple options, enter the value corresponding to the first option, e.g.: "Yellow".

  • If an option name is filled in, the corresponding option value is required.
  • One option value per cell. 
  • Character limit: 255.
  • Each product can be in at most 5 options.

 

Option2 name

Same as the Option1 name

  • If a product has multiple options, you need to fill in all possible combinations of option values ​​in the option value column.

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. 

  • Enter the image URL.
  • One image URL per cell. 
  • Leave the cell blank if not applicable.

SKU price

Optional. Product price per SKU.

  • Do not include any currency symbols. Only enter the price information, e.g. "9.99".
  • The price will be based on the currency set by the store.
  • Enter only the first row for products with no variations. 

SKU compare at price

Optional.

  • Do not include any currency symbols. Only enter the price information, e.g. "9.99".
  • The price will be based on the currency set by the store.
  • Enter only the first row for products with no variations. 

SKU weight

Optional.

  • Supports up to 2 decimal places

SKU weight unit

Optional.

  • Supported weight units are: g/kg/lb (pounds)/oz (ounces)

SKU Inventory Tracker

If you enable inventory tracking, the inventory will change with the sale of goods. If not, the inventory quantity remains unchanged.

  • Enter "T" to start tracking. If not, enter "F".

SKU Inventory Policy

 

If you allow the product to be oversold, when the product inventory reaches 0, the product is still available for sale.

  • Enter "continue" to allow oversold. If not, enter "deny".

SKU inventory quantity

 

Optional.

  • Only enter the integers can be entered here. The value ranges from -999,999 to 999,999.

Cost per item

 

Optional.

  • Do not include any currency symbols. Only enter the price information, e.g. "9.99".
  • The price will be based on the currency set by the store.
  • Enter only the first row for products with no variations. 

Barcode (ISBN, UPC, GTIN, etc.)

 

Optional.

  • Character limit: 100

 


 

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:

Bulk_Product_Editor_-_2.png

You can edit the columns related to the headers in the sheet.

To bulk edit product properties:

  1. From your SHOPLINE admin, go to Products.

  2. Bulk Select, then Export the products you want to bulk edit.

    Bulk_Product_Editor_-_3.png

  3. Download the export file from your inbox.

  4. Open CSV file. Click on the profile icon and select Bulk processing progress > click All records.

    Bulk_Product_Editor_-_4.png

  5. 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
  • Fulfilment
  • 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:

  1. From your SHOPLINE admin, go to Products.

  2. Select the products you want to bulk edit.

  3. Click on Enter the bulk editor.

    Bulk_Product_Editor_-_5.png

  4. After you click on Enter the bulk editor, you can edit the product properties.

    Bulk_Product_Editor_-_6.png

  5. 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:

  1. From your SHOPLINE admin, go to Admin (icon).

    Bulk_Product_Editor_-_1.png

  2. Click on Bulking processing progress to view import/export records.

    mceclip0.png

 


Have more questions? Submit a request

Comments