Products can always be added to your store one at a time using the + Add New Product button on your catalog page. However, there are times when adding many products at once is highly beneficial. Once you learn a couple key techniques, importing products is the fastest way to upload or edit your catalog.
First Things First, What are CSV Files?
A CSV (comma separated values) file contains plain text entries separated by delimiters. Each entry represents a cell in a spreadsheet, each line represents a new row, and each delimiter (comma, semicolon, or tab) indicates where one entry ends and another entry begins.
You can edit your CSV file with spreadsheet editors, like Google Sheets, Microsoft Excel, OpenOffice, or LibreOffice.
If you don't have access to those options, you can edit any CSV with plain text editors like Notepad for Windows or TextEdit for Mac.
To see the import settings in your store, navigate to your Shop App dashboard by clicking Shop App from the iHeart Business dashboard or from the App Menu near the top-left corner of the page. From your Shop App dashboard, click Catalog Products, then click Import Products.
CSV Download Examples
If you'd like to download a CSV to start from, check out the links below. You can download either the product CSV from Bistro 360 or a blank product CSV with only the headers so you can fill it out on your own. Once you've got your products entered in a CSV, you can upload it to your store!
Download Bistro 360 Product CSV
Download blank CSV to start from scratch
How to Import Products to Your Store
From your Shop App dashboard, click Catalog Products from the left column. Here, you'll see a list of the current products in your store.
CSV Contents
Each line in a product import CSV represents a list of attributes associated with a certain product in your store. Each attribute is separated by a delimiter that should be consistent throughout the file.
The first line in the file generally represents the column headers.
Note: If your file contains column headers, check the Skip first line option in your import settings so this line is excluded from the product attributes.
CSV Delimiters
Delimiters indicate where one product attribute ends and another one begins. There are three delimiter options for your CSV files:
- commas
- semicolons
- tabulation (tab key)
When you import your CSV file, please select the same delimiter used in the import settings.
Encoding
The encoding settings determine what kind of characters are included in your CSV. The importer supports more than ten charsets, including UTF-8, UTF-16, and US-ASCII. When you import your CSV file, please select the same encoding used in your CSV file for proper import. If your CSV includes standard letters and numbers, chances are good that UTF-8 is a good option for you.
CSV File Format
To view your import settings, click Catalog Products and click Import Products.
The Product import tool recognizes up to 25 product attributes. This means your CSV may contain up to 25 columns. Here is a brief description of each attribute:
Column name in import dialog |
Column name in CSV file |
Requirement | Type | Limits |
SKU | sku | SKU or Name field is required | String | 255 symbols |
Name | name | SKU or Name is required | String | 255 symbols |
Description | description | Optional | String | No |
Enabled | enabled | Optional | Boolean | "true", "yes", "on", "Y", "1" for enabled, any other values for disabled |
Weight | weight | Optional | Floating number | Any valid floating number for weight, empty value for digital product or services |
Price | price | Optional | Floating number | Any valid floating number |
“Compare to” price | recommended_price | Optional | Floating number | Any valid floating number |
---|---|---|---|---|
Quantity | quantity | Optional | Integer | Any valid integer, empty value for unlimited quantity |
Image | image | Optional | String | http:// or https:// URLs |
Category 1 | category1 | Optional | String | 255 symbols |
Category 2 | category2 | Optional | String | 255 symbols |
Category 3 | category3 |
Optional |
String | 255 symbols |
Store front page | showOnFrontpage | Optional | Boolean | "1" for true, "0" or empty value for false |
Fixed shipping rate | shipping_freight | Optional (legacy) |
Floating number | Any valid floating number |
Fixed shipping rate only | fixed_shipping_rate_only | Optional (legacy) |
Boolean | "true", "yes", "on", "Y", "1" for true, any other values for false |
Shipping rate type | shippingType | Optional | Strings | One of these values: GLOBAL_METHODS, SELECTED_METHODS, FLAT_RATE, FREE_SHIPPING |
Shipping markup | shippingMethodMarkup | Optional It is used with GLOBAL_METHODS shipping rate type |
Floating number | Any valid floating number |
Flat Rate Shipping amount | shippingFlatRate | Optional It is used with FLAT_RATE shipping rate type |
Floating number | Any valid floating number |
Disabled shipping methods | shippingDisabledMethods | Optional It is used with SELECTED_METHODS shipping rate type |
List of strings split by | symbol | A string is *ID of a shipping method |
Enabled shipping methods | shippingEnabledMethods | Optional It is used with SELECTED_METHODS shipping rate type |
List of strings split by | symbol | A string is *ID of a shipping method |
UPC | upc | Optional | String | 255 symbols |
Brand | brand | Optional | String | 255 symbols |
Page title | seo_title | Optional | String | 55 symbols |
Meta description | seo_description | Optional | String | 160 symbols |
Width | width | Optional | Floating number | 5 symbols |
Height | height | Optional | Floating number | 5 symbols |
Length | length | Optional | Floating number | 5 symbols |
To find the ID of the shipping method you’d like to enable/disable for a product via import, navigate to the Shipping & Pickup tab, click on the shipping method in question, and copy its ID from the browser’s address bar as in the example below.
Alternatively, you can set up one product manually in the required way, export it, find IDs of the shipping methods enabled/disabled for it in the downloaded CSV file and use them in your import file.
Importing a CSV file
Once you’ve prepared your CSV file, click Catalog Products and click Import products.
In the import dialogue window:
- Click Choose file and select the CSV file from your computer.
- Select the delimiter used in your file (comma, semicolon or tabulation).
- Select the character encoding used in your file:
- Arrange columns (drag and drop) to mimic your file:
- Uncheck the columns that are not used in the file.
- Use the Skip column option to exclude up to three columns:
- Check the option Delete all products and categories before import if you want to clear the catalog before import.
- Click Import.
You should now see the imported products in your catalog!
Comments
0 comments
Please sign in to leave a comment.