Store Level > Data > Imports

Imports can be tricky! Your Success Rep and our Success team are standing by to help you through the process is you have any trouble with an import. Just reach out through your normal channels or click Contact Support or the Chat icon at the bottom of the screen.

Select the type of import you would like to complete and follow the on-screen prompts.
Mandatory fields are marked with an asterisk (*). Specific notes for each import type are detailed below.

Import Modes

• 0 = create
• 1 = update
• 2 = delete

Address Book Import

When importing records into Address Book or updating an existing address book record please note the following:

• Import Mode must always be 0
• Combination of User Identifier (Email address) and AddressBookTypeID is used to look up an existing record for update. If record is not found a new record will be added.
• Rows with AddressBookTypeID = 1 will be imported as shipping address
• Rows with AddressBookTypeID = 2 will be imported as billing address

Inventory Import

Inventory import looks up products based on their SKU. It then inputs SKU as Stock ID Number and replaces existing quantity with the new value from the imported excel.

It is important to note the following:

• If the same SKU is repeated across multiple products variants or even multiple unrelated products, they will all be updated with the imported in-stock quantity.
• If while import is in progress (could take up to several hours), please keep track of transactions/orders that would impact the quantity of inventoried products. Once import is completed, please update/adjust quantity of these products manually.

Gift Certificate Import

• Import Mode must always be 0.
• GCCode and GCTypeID must be provided.
  • GCTypeID values:
    • 2 = Gift Certificate
    • 4 = Coupon/Promo Code
    • 6 = Free Shipping

User Import

• There is a 1600 limit to the amount of records that can be imported at one time. Attempts to import larger files will fail.
• Import Mode must always be 0
• Email is mandatory.
• First and Last name are mandatory.
• Address information is optional.

Points Import

• Import Mode must always be 0.
• Program name is mandatory.
• At least one of {UserID, UserAlternateID, UserEmail} must be populated.

Multi Category Import

• Import Mode must always be 0
• Either Product Id or External Product Id is mandatory
• Either Category Id or External Category Code is mandatory

NEW CONTENT from ticket https://dev.azure.com/Commercio/CompanyStores/_workitems/edit/8576

We will be combining the Basic Product Import and Product Catalog Import into one new import called Product Import

• This will replace the Basic Product Import and Product Import Catalog
• Product Import will allow for add, update, and delete using the Import Mode.
• Import will now be found in Admin>Store>Products>Import Products (User Flow)
• Files should process immediately, currently users can get that it can take up to 24hrs to process the file.
• Users receive a successful upload message in UI only.
• User should receive one of two emails once the file finishes processing:
• Import Successful
• Import Failed
• The following fields will be on the new product import (Example XLS). All fields with the red note symbol require validation when processing the XLS.
• Import Mode – Required. Needs to match one of the following options:
• 0 = Add
• 1 = Update
• 2 = Delete
• Product Status - This comes from Basic Details Screen>Status. Needs to match one of the following options:
• Draft
• Live
• Archived
• Product ID
• Required if Import Mode = 1(update) or 2(delete)
• If used needs to match the Product ID/Supplier SKU combination to update or delete the product.
• Product Name
• Product Description
• Supplier SKU - Required
• Customer SKU
• Model #
• Search Keywords
• Supplier
• Manufacturer
• Weight/Dimensions Type - Needs to match one of the following options:
• Physical
• Packaged
• Weight
• Numbers only.
• 7-character limit.
• Decimal (.) is allowed.
• Weight Unit - Needs to match one of the following options:
• lb
• kg
• g
• 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 - Needs to match one of the following options:
• In
• cm
• Storefront Status - This is the same field that is located on the Inventory>Status field:
• Active = Available on the storefront
• Inactive = Not available on the storefront
• Inventoried – Needs to match one of the following options:
• Yes
• No
• Cost
• Numbers only.
• Up to 2 decimals places allowed.
• Base Price
• Numbers only.
• Up to 2 decimals places allowed.
• Setup Charge
• Numbers only.
• Up to 2 decimals places allowed.
• Attribute 1 (A1) – Needs to match one of the following options. All other attributes need to be setup manually in the UI.
• Size
• Color
• Option Name 1 (A1)
• Option Hex Color 1 (A1)
• Option Name 2 (A1)
• Option Hex Color 2 (A1)
• Option Name 3 (A1)
• Option Hex Color 3 (A1)
• Option Name 4 (A1)
• Option Hex Color 4 (A1)
• Option Name 5 (A1)
• Option Hex Color 5 (A1)
• Option Name 6 (A1)
• Option Hex Color 6 (A1)
• Option Name 7 (A1)
• Option Hex Color 7 (A1)
• Attribute 2 (A2) – Needs to match one of the following options. All other attributes need to be setup manually in the UI.
• Size
• Color
• Option Name 1 (A2)
• Option Hex Color 1 (A2)
• Option Name 2 (A2)
• Option Hex Color 2 (A2)
• Option Name 3 (A2)
• Option Hex Color 3 (A2)
• Option Name 4 (A1)
• Option Hex Color 4 (A2)
• Option Name 5 (A2)
• Option Hex Color 5 (A2)
• Option Name 6 (A2)
• Option Hex Color 6 (A2)
• Option Name 7 (A2)
• Option Hex Color 7 (A2)
• Group Code – Needs to match a Group Code already existing in Admin>Store>Products>Storefront>User Group Visibility.

Updated November 19, 2024 22:01