Local Product Bulk Import Template Instruction

1. Template introduction

  • Click here to download SHOPLINE local product import template (Note: Please use Chrome for downloading the document)
  • 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 currently 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.

 

2. Product details 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.

*Note: You can leave the optional fields blank, but do not delete the column.

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*

Required. Title of the product, e.g.: Harddisk

  • 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 10

  • 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.

image__1_.png

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.

image__2_.png

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.

 image__3_.png

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.

image__4_.png

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

 

Have more questions? Submit a request

Comments