In this Article:
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 |
Inventoried |
*Required Choose one of the following: |
Storefront Status |
*Required Choose one of the following: |
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
Comments
0 comments
Please sign in to leave a comment.