You can use SHOPLINE’s Bulk Product template 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.
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.
| Note: 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
- Before you start
- Downloading the product template file
- Understanding the product fields in the product template
- Adding standard product
- Adding products with variants
- Importing product file
Before you start
Using a spreadsheet (CSV, XLSX, or XLS) to format product data quickly, you can easily import products into your SHOPLINE POS store in bulk.
Before you start, prepare the following product information:
-
Names of your products
-
Any variations, such as sizes, colors, and flavors
-
Retail prices of your products
-
These are tax-exclusive prices if your store displays prices exclusive of tax
-
These are tax-inclusive prices if your store displays prices inclusive of tax
-
- Supply prices of your products
- Existing barcode/SKU numbers
Downloading the product template file
To get started, download the product template spreadsheet file. The product template is pre-designed and contains all the necessary product details that can be recorded in SHOPLINE POS.
We highly suggest using Excel or free spreadsheet software like Google Sheets to open the product template spreadsheet file in order to maintain the required formatting.
Understanding the product fields in the product template
Once you download the product template spreadsheet file, you will need to add your product information.
There are two different types of products that can be added to your store and each will require slightly different information:
- Standard product:
-
- Single product with a single SKU and its own inventory.
- Single product with a single SKU and its own inventory.
-
- Product with variants:
-
- A product that is offered in different variations, such as size or color — each variant is a unique SKU with its own inventory.
-
Product details import form introduction
- Please fulfil all mandatory fields marked required in the Requirement column.
- 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.
The following is a list of product data columns present in the product template spreadsheet file, along with the required information for each:
| Field Name | Description | Requirements |
|
Handle |
Note: 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. |
Optional
|
|
Title |
Title of the product, e.g.: Harddisk
|
Required |
|
Subtitle |
A brief note of the product, e.g.: Generation 10 Character limit: 255 |
Optional |
|
Product Description Html |
|
Optional |
|
Vendor |
The brand name. Character limit: 64 |
Optional |
|
Tags |
Product tags, e.g.: shirt, beauty, summer
|
Optional |
|
Collections |
Name of the collection/category, e.g.: shirt, beauty, summer
|
Optional |
|
Master Image |
|
Optional |
|
SEO title |
SEO title, also known as a title tag, is a brief and concise text that appears at the top of the web browser's window and as the main headline in the search engine results pages (SERPs). It is one of the most important on-page SEO factors and plays a crucial role in optimising a web page for search engines. Character limit: 255 |
Optional |
|
SEO description |
SEO description, also known as meta description, is a brief summary or preview of the content on a web page that appears in the search engine results pages (SERPs) below the page title and URL. It provides a concise description of what a web page is about and entices users to click through to the website. Character limit: 1024 |
Optional |
|
SEO keywords |
SEO keywords, also known as search terms or key phrases, are the words or phrases that people use to search for information on search engines like Google, Bing, or Yahoo. They are the main focus of search engine optimization (SEO) because search engines use keywords to understand what a web page is about and rank it accordingly in their search results. | Optional |
|
Status |
|
Optional |
|
SKU |
|
Optional. |
|
Option1 name |
Enter the first option if the product has multiple options, e.g.: "Color".
|
Optional |
|
Option1 value |
If the product has multiple options, enter the value corresponding to the first option, e.g.: "Yellow".
|
Optional |
|
Option2 name |
Same as the Option1 name
|
Optional |
|
Option2 value |
Same as Option1 value |
Optional |
|
Option3 name |
Same as Option1 name | Optional |
|
Option3 value |
Same as Option1 value | Optional |
|
Option4 name |
Same as Option1 name | Optional |
|
Option4 value |
Same as Option1 value | Optional |
|
Option5 name |
Same as Option1 name | Optional |
|
Option5 value |
Same as Option1 value | Optional |
|
Image |
Image of the option. 1 image for 1 SKU only.
|
Optional |
|
SKU price |
SKU price refers to the actual selling price of a product or item, which is often determined based on the cost of production or purchase, as well as other factors such as marketing and distribution costs, competition, and consumer demand.
|
Optional |
|
SKU compare at price |
SKU compare at price refers to the original or suggested retail price of a product or item, which is often used as a reference point for discount pricing. It is an important metric for businesses that sell products online or in retail settings, as it can impact their pricing strategies and marketing efforts.
|
Optional |
|
SKU weight |
SKU weight, also known as Stock Keeping Unit weight, refers to the weight of a particular product or item that is used for inventory and order management purposes. It is a unique identifier that helps businesses keep track of their products and ensures accurate inventory management. Supports up to 2 decimal places e.g.: 4.732 rounded to 2 decimal places would be 4.73 |
Optional |
|
SKU weight unit |
SKU weight unit refers to the unit of measurement used to indicate the weight of a particular product or item for inventory and order management purposes. Common SKU weight units include pounds (lbs), ounces (oz), kilograms (kg), and grams (g). Supported weight units are: g/kg/lb (pounds)/oz (ounces) |
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.
|
Optional |
|
SKU Inventory Policy
|
If you allow the product to be oversold, when the product inventory reaches 0, the product is still available for sale.
|
Optional |
|
SKU inventory quantity
|
SKU inventory quantity refers to the number of units of a particular product or item that a business has in stock. It is an important metric for inventory management and order fulfillment, as it helps businesses track the movement of their inventory and ensure that they have sufficient stock to meet customer demand.
|
Optional |
|
Cost per item
|
Cost per item refers to the amount of money a business pays to purchase or produce a single unit of a product or item. It is an important metric for businesses that sell physical products, as it directly affects their profitability and pricing strategies.
|
Optional |
|
Barcode (ISBN, UPC, GTIN, etc.)
|
A barcode is a machine-readable code consisting of a series of parallel bars and spaces that represent numbers or letters. Barcodes are used for a variety of purposes, including inventory management, product identification, and tracking. There are several types of barcodes, including ISBN, UPC, and GTIN.
Character limit: 100 |
Optional |
Adding standard product
A standard product refers to a single item with a unique SKU and its own inventory.
To create a standard product, start by assigning a name to your product. It's essential to ensure that each product name is unique and specific to avoid confusion, especially if your store offers similar items. Avoid using general or vague names like "t-shirt" and instead, use a specific name like "SHOPLINE Anniversary T-shirt" for easy identification.
You have the option to either create your own SKU for the product or allow Retail POS to automatically generate a SKU by leaving the corresponding field blank.
Similarly, you can manually create a handle by entering a supported format handle, or you can leave the handle field blank and allow the SHOPLINE system to generate one automatically.
It is essential to provide a retail price for your product. Leaving the retail price column blank will result in the product being priced at $0.
To add more standard products, navigate to the next line in the spreadsheet and follow the same steps mentioned above. Repeat the process for as many products as needed.
Adding products with variants
When creating a product with variants, it's important that each variant product has a different name to group them together.
As an example, let's say you want to upload a T-shirt that has two different variants rules: Color and Size.
Option 1 Name: Enter the name of the first variant, for example, "Color".
Option 1 Value: Enter the value of the first variant, for example, "Red", "Yellow" and "Blue".
Option 2 Name: Enter the name of the first variant, for example, "Size".
Option 2 Value: Enter the value of the first variant, for example, "S, "M" and "L".
To add more variant products, navigate to the next line in the spreadsheet and follow the same steps mentioned above. Repeat the process for as many products as needed.
Importing product file
Once you have finished filling out your product template spreadsheet file, you can import it into your SHOPLINE admin, product management page.
You can choose to update/overwrite the same product, and existing values will be used for any missing columns.
To upload the product template spreadsheet file:
- From your SHOPLINE admin, go to Products.
- To import products, navigate to the product page and click on Import products > Import locally.
- Upload the saved product template file, then click Import.
- If the import is successful, you will be able to view the uploaded products in your product management.
To ensure the accuracy of the uploaded data, click on the product and review the variant section.
Get in touch
SHOPLINE has a dedicated local support team for merchants looking for help with their issues and concerns. You can contact SHOPLINE support by reaching out to us through our live chat on your SHOPLINE admin, website, dropping us an email or WhatsApp our customer support with your queries.
Comments