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

Updated May 14, 2024 00:03