Store Level > Products > Import Products

In this Article:

• How to import products
• Completing product setup

The Product Import streamlines the process of importing data using a single spreadsheet into the system. 

How to import products:

1. Click on Import Products button in upper right hand corner of the Products screen.

2. Click Download template in the pop up window.

Open the downloaded template and complete fields listed below. There are notes associated to some fields to assist in filling out the template. These notes are listed below as well as within the template itself.

Field	Notes
Import Mode	*Required 0 = Create 1 = Update 2 = Delete
Product ID	Required if Import Mode = 1 (Update) or 2 (Delete)
Product Description
Model #
Search Keywords
Supplier	*Required
Manufacturer
Weight/Dimensions Type	Choose one of the following: Physical Packaged
Weight	Numbers Only 7 character limit Decimal (.) is allowed
Weight Unit	Choose one of the following: lb kg g oz custom
Length	Numbers Only 15 character limit Decimal (.) is allowed
Width	Numbers Only 15 character limit Decimal (.) is allowed
Height	Numbers Only 15 character limit Decimal (.) is allowed
Dimensions Unit	Choose one of the following: in cm
Inventoried	*Required Choose one of the following: Yes No **Note - If attributes are present, this status will be added to all variants.
Storefront Status	*Required Choose one of the following: Active = Available on the storefront Inactive = Not available on the storefront **Note - If attributes are present, this status will be added to all variants.
Cost	Numbers only Up to 2 decimal places **Note - If attributes are present, this cost will be added to all variants.
Base Price	Numbers only Up to 2 decimal places **Note - If attributes are present, this base price will be added to all variants.
Sales Price	Numbers only Up to 2 decimal places **Note - If attributes are present, this sales price will be added to all variants.
Setup Charge	Numbers only Up to 2 decimal places
Group Code	Needs to match a Group Code already existing in Admin>Stores>Products>Storefront>User Group Visibility
Attribute A1/A2	Attribute can be Size or Color. All other attributes will need to be added in Products > Edit Product > Options screen.
Options Name 1-7	Name of Color (ex: Green) or Size (ex: Small)
Option Hex Color 1-7	Use only if Attribute/Option is a Color

4. Drag file to upload or Browse Files to choose the file and then click Import.

When the file is successfully uploaded you will receive the following message.

When the file is uploaded, it could take several minutes to several hours for the import to be completed. The number of products being imported will affect how long the import takes to complete. Once the imported file has been processed, you will receive an email notifying you that it is either successful or there were issues. The email will note how many records processed successfully and the reason if any failed. 

If any records fail to import, you will want to move those records to a new template and upload that new template to complete the import.

Completing Product Setup:

Now that your products have been imported into the store you can complete the setup for each product. This includes things such as:

• Additional Options
• Images
• Storefront settings
• SKU - Customer SKU is required to activate the Pricing and Storefront screens. The other required fields for this screen are part of the product import. You can also add a Supplier SKU, but it is not required.
• Pricing - The import spreadsheet only allows for one Cost, Base Price, Sales Price per product. If there are pricing difference between variants that will need be updated on the Pricing screen. You can also add the additional pricing options if needed for the product at this time (User Group Discounts, Minimum Order Quantity and Quantity Breaks). 

Updated April 09, 2025 18:10