TABLE OF CONTENTS
- Introduction
- Import Details
- Guidelines To Create A CSV File For Import/Update
- Adding an Import
- Import Statuses
Introduction
Navigate to: Dev Center > Imports
Administrators can use the Imports module to import or bulk update the following:
Product
Product Association
Product Attribute
Attribute Default Value
Product Highlights
Addon Association
Pricing
Inventory
Category
Category Association
Zip Code
Accounts
Customers
Customer Address
SEO Details
Vouchers
Synonyms
They can also download the CSV templates to help organize and format the bulk import data.
Import Details
Detail | Description |
Locale ID | Select a Locale for Import |
Import Type | Select an Import Type from the drop-down |
Family List | Select an Attribute Family. This field is available only for Import Types products and Categories. |
Select Pricing | Select a Price List. This field is available only for Import Type Pricing. |
Select Country | Select a Country. This field is available only for Import Type Zipcode. |
Select Store | Select a Store. This field is available only for Import Types Customer and SEO Details |
Select Template | Select a Template from the drop-down. New templates can be created using the "Create New Template" button. Existing Templates can be downloaded using the "Download Template" button. |
Guidelines To Create A CSV File For Import/Update
It is recommended to download the default template provided with every type of import as a starting point for creating a CSV file for importing/updating the CSV file and including/excluding columns as per the requirements.
The column requirements for every import are described in the Column Requirements section below.
Adding an Import
Navigate to: Admin > Import & Export > "Add New" buttons
Steps to import:
The below steps can be used to import:
Add/Select Imports Details
Attach a file to Import using the "Browse" button. Must be in.CSV or Excel format.
Save Import using the "Import" button
The page refreshes with confirmation that Import has started. Use the "Status" button to check the status of Import. This may take several minutes.
Import is finished when "Status: Completed". After Import is completed, administrators should verify the data that appears in the respective Znode sections.
Column requirements for different imports
Pricing
A.) Mandatory Columns
Following are the columns that should be included in the CSV file to import the Pricing:
SKU
Tier Start Quantity
Retail Price
Sales Price
Tier Price
SKU Activation Date
SKU Expiration Date
Custom 1
B.) Requirements of each column in CSV file
SKU
This is the product SKU in which administrators can save the Alphanumeric value.
The value in this column can not be empty.
Tier Start Quantity
The value in this column can be empty.
Retail Price
This is the product's retail price in which Administrators can save only the numeric value. The value should be between 0 and 999999.
The value in this column can not be empty.
Sales Price
This is the product's sales price in which Administrators can save only the numeric value. The value should be between 0 and 999999.
The value in this column can be empty.
Tier Price
Administrators can save more than 1 product and the price for those products in the Tier pricing. The value should be between 1 and 999999
The value in this column can be empty.
SKU Activation Date
Administrators can set the SKU activation date. It should be a future date.
The value in this column can be empty.
SKU Expiration Date
Administrators can set the SKU expiration date. It should be a future date.
The value in this column can be empty.
Custom 1
Administrators can add Custom prices by adding a value in this section.
The value in this column can be empty.
Inventory
A.) Mandatory Columns
Following are the columns that should be included in the CSV file to import the Inventory:
Quantity
Reorder Level
SKU
Warehouse Code
B.) Requirements of each column in CSV file
Quantity
Administrators can import quantities from this section.
The column should have a numeric value. The value can be from 1 to 9999
The value in this column can not be empty.
Reorder Level
Administrators can import reorder levels(quantity) from this section.
The column should have a numeric value. The value can be from 1 to 9999
The value in this column can be empty.
SKU
Administrators can import the SKUs from this section for which the Inventory has to be set
The value in this column can not be empty.
Warehouse Code
Administrators can import the warehouse in which the above details will be added.
A new line in the CSV file will be added In case of multiple warehouses.
The value in this column can not be empty.
Category
A.) Mandatory Columns
Following are the columns that should be included in the CSV file to import Category:
Category Code
Category Name
Category Title
Long Description
Short Description
Display Order Category
Additional Description
Category Banner
Image Alt Text
Text
Valid Text
Hide Category On Menu
B.) Requirements of each column in CSV file
Category Code
Administrators can import Category Code from this section.
This should be a unique code for each category.
The value in this field can be alphanumeric.
The value in this field can not be empty.
Category Name
Administrators can import Category Names from this section.
This should be a unique Name for each category.
The value in this field can be alphanumeric.
The value in this field can not be empty.
Category Title
Administrators can import Category titles from this section.
This should be a unique title for each category.
The value in this field can be alphanumeric.
The value in this field can not be empty.
Long Description
The administration can import a long description of the category in this section.
The value in this field can be empty.
Short Description
The administration can import a short description of the category in this section.
The value in this field can be empty.
Display Order Category
The display order decides the precedence of the particular category.
If category A has 1 as a display order and B has 2 as a display order then, category A will be displayed first.
The value in this field can not be empty.
Additional Description
The administration can import an additional description of the category in this section.
The value in this field can be empty.
Category Banner
The administration can import a category banner description in this section.
The value in this field can be empty.
Image Alt Text
The administration can import an alternative text for the image from this section.
The value in this field should be alphabetical.
The value in this field can be empty
Text
The administration can import text for the particular category from this section.
The value in this field should be alphabetical.
The value in this field can be empty
Valid Text
The administration can import valid text for the particular category from this section.
The value in this field should be alphabetical.
The value in this field can be empty
Hide Category On Menu
If this field is checked in the category then the particular category is hidden from the main menu but still, it is searchable.
This field can remain empty.
Zip Code
A.) Mandatory Columns
Following are the columns that should be included in the CSV file to import the Zip Code:
CityName
CityType
ZIP
ZIPType
country code
StateCode
Latitude
B.) Requirements of each column in CSV file
City Name
Administrators can import City Name from this section.
This field can not be empty while creating a new import.
City Type
Administrators can import City Type from this section.
This field can not be empty while creating a new import.
ZIP
Duplicate records must be excluded from the import/update file.
This field can not be empty while creating a new import. Input must be unique.
ZIP Type
Administrators can import City Type from this section.
This field can not be empty while creating a new import.
County Code
Administrators can import County Code from this section.
This field can not be empty while creating a new import.
State Code
Input must be available as a State Code value in the database.
This field can not be empty while creating a new import.
Latitude
Administrators can import County Code from this section.
This field can not be empty while creating a new import.
Product Attribute
A.) Mandatory Columns
Following are the columns that should be included in the CSV file to import the Product Attribute:
Attribute Name
Attribute Code
Attribute Type
Display Order
B.) Requirements of each column in CSV file
Attribute Name
Administrators can import the Attribute Name from this section.
This should have an alphabetical character.
This value can be empty.
Attribute Code
Administrators can import the Attribute Code from this section.
This can have an alphanumeric character.
This should be a unique code.
This value can not be empty.
Attribute Type
Administrators can import the Attribute type from this section.
This value can not be empty.
Display Order
Administrators can set the display order from this section.
Display order decides the precedence of the Product Attribute.
This value can be empty.
Category Association
A.) Mandatory Columns
Following are the columns that should be included in the CSV file to import the Category Association:
Category Code
SKU
Display Order
Is Active
B.) Requirements of each column in CSV file
Category Code
Administrators can import category code from this section in which the products need to be associated.
This field should have an alphanumeric value.
This field can not be empty while creating a new import.
SKU
Administrators can import the SKU from this field that needs to be associated with the category.
This field should have an alphanumeric value.
This field can not be empty while creating a new import.
Display Order
Administrators can set the display order from this section.
Display order decides the precedence of the category association.
This value can be empty.
This field can not be empty while creating a new import.
Is Active
The value of this column should be either True or False OR Yes or No OR 1 or 0
This field can not be empty while creating a new import.
Catalog - Category Association
A.) Mandatory Columns
Following are the columns that should be included in the CSV file to import the catalog - category association:
Parent Code
Category Code
Display Order
Action
B.) Requirements of each column in CSV file
Parent Code
The category association can be done at the parent-child hierarchy level
Multi-level category association can be added to the parent code which should be separated using the “/” separator
Any two categories added with the “/” are considered a parent/child category association
For multi-level parent-child categories association, there should be a parent to child category1 association and then in the next row, the parent-to-child category 1 to child category 2 should be added
Ex:
parent category
ParentCategory/ChildCategory1
ParentCategory/ChildCategory1/ChildCategory2
Immediate Parent can only be added in the parent code when there is the child category association can be added
Ex: Apparels/Pants, in this scenario parent category, is Apparel, and the child category is Pants, so Apparel is added to the Parent Code column
Ex: Apparels/Pants/Trousers, in this scenario parent category is Apparel and child 1 category is Pants, and child 2 category is Trousers, so Apparels/Pants is added to the Parent Code column
Administrators can enter a value in this field in alphanumeric format with a maximum of 100 characters without any special characters
The value of this column can remain empty and should be unique for a specific Catalog
When the parent code is empty and there is a value-added in the Category Code column then the value in the category code is considered as the parent category
Parent Code should be associated with an existing Catalog that is available in the admin application.
Category Code
Administrators can enter a value in this field in alphanumeric format with a maximum of 100 characters without any special characters
The value-added should not be case sensitive hence Apparel or apparel both values will be considered valid
The value of this column cannot remain empty and should be unique for a specific Catalog
Category Code should be associated with an existing Category that is available in the admin application
Only a single category to be associated/disassociated should be added in the category code column
Display Order
Administrators can save a value in this field in whole numbers where the value entered should be between 1-99999 without any special characters
The value of this column can remain empty
Display Order indicates the position of the category to be displayed on the web store
If the Display Order added in the CSV file is the same for two categories then the first category available in the CSV file will be listed as the first category in the display orders hierarchy and then the second category available in the CSV file will be listed as the second category in the display orders hierarchy
Ex: When both parent categories have the same display order and no other category in the admin application has a category associated with Display Order = 1
Apparel will be visible as the first category for Display Order = 1
Hardware will be visible as the second category for Display Order =1 (i.e)
All the parent categories will be displayed in the following sequence on the web store:
Apparel
Hardware
Ex: When both parent categories have the same display order and the admin application already has Electrical and Plumbing associated with Display Order = 1
Apparel will be visible as the third category for Display Order = 1
Hardware will be visible as the fourth category for Display Order =1
All the parent categories will be displayed in the following sequence on the web-store:
Electrical
Plumbing
Apparel
Hardware
Ex: When all parents have different display orders and the admin application already has Electrical and Plumbing associated with Display Order = 1
Apparel will be visible as the third category for Display Order = 1
Hardware will be visible as the fourth category for Display Order =1
Tools will be visible as the fifth category for Display Order =1
Lawncare will be visible as the first category for Display Order =2
HVAC will be visible as the first category for Display Order =3
Drills will be visible as the first category for Display Order =30
All the parent categories will be displayed in the following sequence on the web-store:
Electrical
Plumbing
Apparel
Hardware
Tools
Lawncare
HVAC
Drills
Action
Administrators can save a value in this field in alphabetic format with a maximum of 20 characters without any special characters
The value-added should not be case sensitive, hence Add, ADD, add is accepted
The following actions should be considered valid:
Add
Delete
Any other action added apart from Add and Delete will not be considered valid
The value of this column cannot remain empty
After successful Import:
Once Catalog category association import is Completed Successfully or Completed with Errors they are listed on the Catalog edit page of the individual catalog
All Imported Catalogs associations aren’t published directly. They are available as a draft
Catalog publish is required for changes to be reflected on the Web Store (only if the catalog is associated with the store/user/profile)
If the imported catalog is not associated with the store/user/profile then the changes in category association are not visible on the web-store.
Important Notes:
If the added Category association in the CSV is not available against the selected catalog in the Database, then that process is considered a new Import
If the all or some of the category associations in the CSV are already available against the selected catalog in the Database, then the association is skipped and no new entries are inserted in the database, instead, the import process would be considered as Completed Successfully but users can see the following message in the Import Log Details pop up
Catalog association already exists hence no new associations are saved in the Database
The values of the non-mandatory columns that are not available in the CSV file remain unchanged during the import processes
Customer
A.) Mandatory Columns
Following are the columns that should be included in the CSV file to import the Customer:
Username
First Name
Last Name
Email
IsActive
SMS Opt-In is not a mandatory column for importing and updating data
B.) Requirements of each column in CSV file
Username
Administrators can Import Usernames from this section
The value in this field should be alphabetical.
UserName should be in this (abc@xyz.pqr ) respective format without spaces
This column can not be empty while creating a new import
First Name
Administrators can Import First Names from this section
The value in this field should be alphabetical.
This column can not be empty while creating a new import
Last Name
Administrators can Import Last Name from this section
The value in this field should be alphabetical.
This column can not be empty while creating a new import
Email
Administrators can Import the emails for a particular Customer from this section.
Email should be in abc@xyz.pqr respective format.
The value in this field can be alphanumeric.
This column can not be empty while creating a new import
Phone number
Administrators can Import the phone numbers for a particular Customer from this section.
The value in this field should be numeric.
This column can not be empty while creating a new import
Is Active
The value of this column should be either True or False OR Yes or No OR 1 or 0
This column can not be empty while creating a new import
Created Date
Administrators can define a date on which the customer can be created.
The value in this field can remain empty.
Profile Name
Administrators can define a profile name for a specific customer from this section.
Account Code
Administrators can Import Account Code from this section.
Account Code should be available as Account Code with any existing Account.
Account and Customer should belong to the same Store therefore input should be available as Account Code with any existing Account of the respective Store.
Input must include the same value associated with the User since the associated account cannot be changed.
Email Opt-In
The value of this column should be either 1 or 0 OR True or False OR Yes or No.
SMS Opt-In
The value of this column should be either 1 or 0 OR True or False OR Yes or No.
During import, when no value is added Default value is considered.
During the update, when no value is added a value that is already available in the database is considered.
Department Name
Administrators can Import Department Names from this section
Input should be available as Department Names with any existing Account.
Role Name
Administrators can Import Role Names from this section
Role Name cannot be updated.
Input must include either User or Administrator or Manager as a value.
Include the Account Code first to add a Role Name.
Per order Annual Limit
Administrators can set per order limit for a particular customer from this section.
The value in this field should be in numeric format.
The value in this field can be empty
Per Order Limit
Administrators can set per order limit for a particular customer from this section.
The value in this field should be in numeric format.
The value in this field can be empty.
Customer Address
A.) Mandatory Columns
User name
First Name
Last Name
Display Name
Address 1
Address 2
Country Name
State Name
City Name
Postal Code
Phone Number
B.) Requirements of each column in CSV file
User name
Administrators can Import Usernames from this section.
This column can not be empty and should be without spaces while creating a new import.
Input must be available as a Username saved against any existing User.
First Name
Administrators can Import their First Names from this section.
The value in this field should be alphabetical.
This column can not be empty while creating a new import
Last Name
Administrators can Import their First Name from this section
The value in this field should be alphabetical.
This column can not be empty while creating a new import
Display Name
Administrators can Import Display Name from this section
This column can not be empty while creating a new import
Address 1
Administrators can Import Address 1 from this section.
This column can not be empty while creating a new import
Address 2
Administrators can Import Address 2 from this section
Country Name
Administrators can Import Country Names from this section.
Input must include any Country that is associated with the Store.
This column can not be empty while creating a new import and input in this column should be without spaces.
State Name
Administrators can Import State Names from this section.
This column can not be empty while creating a new import and input in this column should be without spaces.
City Name
Administrators can Import City Name from this section
This column can not be empty while creating a new import and input in this column should be without spaces.
Postal Code
Administrators can Import Postal Code from this section
This column can not be empty while creating a new import and input in this column should be without spaces.
Phone Number
Administrators can Import Phone Numbers from this section
This column can not be empty while creating a new import and input in this column should be without spaces.
Product Association
A.) Mandatory Columns
Following are the columns that should be included in the CSV file to import the Product Association:
Parent SKU
Child SKU
Display Order
Is Default
Quantity
B.) Requirements of each column in CSV file
Parent SKU
Administrators can Import Parent SKU from this section.
The value added in this column will have child products associated with it.
The value in this field can be alphanumeric.
The value in this field can not be empty.
Child SKU
Administrators can Import Child SKU from this section.
The value added in this column will have Parent's products associated with it.
The value in this field can be alphanumeric.
The value in this field can not be empty.
Display Order
Administrators can set the display order from this section.
Display order decides the precedence of the Product Association.
The value in this field should be numeric.
The value in this field can not remain empty while creating a new import.
Is Default
Administrators can set the product association as default from this section.
The value in this field should be either true or false.
The value in this field can not remain empty while creating a new import.
Quantity
Administrators can define the quantity of the products from this section.
The value in this field can not remain empty while creating a new import.
SEO details
A.) Mandatory Columns
Following are the columns that should be included in the CSV file to import the SEO Details:
Import Type
Code
SEO Url
Is Active
Redirect From
Redirect To
Robot Tag
B.) Requirements of each column in CSV file
Import Type
The administrator can select Import Type from this section
Input must be available as any predefined value.
Code
This column can not be empty while creating a new import.
SEO Url
Input must be unique.
The input value is required in an alphanumeric format without spaces. Hyphen or Underscore can be used.
Is Active
The value of this column should be either True or False OR Yes or No OR 1 or 0
Redirect From
Duplicate records must be excluded from the import/update file.
Data records Should be valid like this column should not be empty while import
Redirect To
Data records Should be valid like this column should not be empty while import
Robot Tag
Input must include a value from the defined values.
Brand
A.) Mandatory Columns
Following are the columns that should be included in the CSV file to import the Brand:
Brand Code
Is Active
Brand Description
SEO Keyword
SEO Description
Brand Logo
SEO Title
SEO Friendly Page Name
URL Key
Custom 1
B.) Requirements of each column in CSV file
Brand Code
Administrators can use a value that is not associated with any other Brand and exists as a Code value saved against the product attribute Brand.
The value of this column cannot remain empty during import/update.
Is Active
The value of this column should be either True/1/Yes or False/0/No
The value of this column can remain empty in case of an update but will be mandatory in case of a new import.
Brand Description
Administrators can save any value in this field.
The added content gets saved in the source code of this field so that once the import/update process is completed, the application can directly display the formatted content for the Brand.
When no value is added during import/update, the empty value is saved.
SEO Keyword
Administrators can save any value in this field with the maximum character limit of 300.
When no value is added during import/update, the empty value is saved.
SEO Description
Administrators can save any value in this field with the maximum character limit of 300.
When no value is added during import/update, the empty value is saved.
Brand Logo
Administrators can save a file name with the extension that is already available in the Media Explorer.
SEO Title
Users should be allowed to save any value in this field with the maximum character limit of 200.
When no value is added during import/update, the empty value is saved.
SEO Friendly Page Name
Administrators can save any value in this field with the maximum character limit of 300.
The value of this column can be in an alphanumeric format without spaces and only hyphens or Underscore are allowed.
When no value is added during import/update, the empty value is saved.
URL Key
Administrators can save any value in this field with the maximum character limit of 200.
When no value is added during import/update, the empty value is saved.
Custom
Administrators can save any value in this field without any character limit.
When no value is added during import/update, the empty value is saved.
Highlight
A.) Mandatory Columns
Following are the columns that should be included in the CSV file to import the Highlight:
Highlight Code
Highlight Name
B.) Requirements of each column in CSV file
Highlight Code
Input must be available as a Value Code saved against Highlights Attribute that has not been used to create any other Highlight.
The input value is required in an alphanumeric format without spaces.
Duplicate records must be excluded from the import/update file.
Display Pop-up
The value of this column should be either 1 or 0 OR True or False
Highlight Type
Input must be available as any predefined value for this column.
Is Active
The value of this column should be either True or False OR Yes or No OR 1 or 0
Display Order
Input must be a positive numeric value greater than 0 for this column while import.
Input must be an integer value between 1 and 999 for this column while importing.
Addon Association
A.) Mandatory Columns
Following are the columns that should be included in the CSV file to import the Addon Association:
SKU
AddonGroupName
AddOnSKU
B.) Requirements of each column in CSV file
SKU
Input must be available as an SKU saved against any existing product.
Duplicate records must be excluded from the import/update file.
AddonGroupName
Input must be available as a Group Name saved against any existing Add-on Group.
Duplicate records must be excluded from the import/update file.
AddOnSKU
Input must be available as an SKU saved against any existing product.
Duplicate records must be excluded from the import/update file.
DisplayOrder
Input must be an integer value between 1 and 999.
Is Default
The value of this column should be either True or False OR Yes or No OR 1 or 0
Attribute Default Value
A.) Mandatory Columns
Following are the columns that should be included in the CSV file to import the Attribute Default Value:
Attribute Code
Attribute Default Value Code
Attribute Default Value
B.) Requirements of each column in CSV file
Attribute Code
In this Column, Input must be available as a Code saved against any existing Attribute.
Attribute Default Value Code
Duplicate records must be excluded from the import/update file.
The input value is required in an alphanumeric format without spaces.
Is Editable
The value of this column should be either 1 or 0 OR True or False
Display Order
Input must be an integer value between 1 and 99999
Is Default
The value of this column should be either 1 or 0 OR True or False
Voucher
A.) Mandatory Columns
Following are the columns that should be included in the CSV file to import the Vouchers:
Voucher Number
Voucher Name
Store Code
Voucher Amount
Remaining Amount
Start Date
Expiration Date
Is Active
Restrict Voucher to a Customer
Username
These columns except Username are mandatory to import the Vouchers. The username column is mandatory for updates.
B.) Requirements of each column in CSV file
Voucher Number
This is a unique 10 digits value consisting of combinations of upper case alphabets and numbers.
When the value of this column is empty in the CSV, a Voucher Number gets generated automatically and a new voucher gets created and saved in the DataBase.
Voucher Name
The value of this column can be anything within 100 characters.
Store Code
The value of this column should match the Store Code of any existing store. The value should be case insensitive.
When this value is added and imported, the respective Store Name should appear on the Edit Voucher screen.
Voucher Amount
The value of this column should be numeric and in between 0.01 and 999999
Remaining Amount
The value of this column should be numeric and between 0.01 and 999999
When a voucher is created/imported, the remaining amount should be equal to the Voucher Amount.
Note: Admin users can edit/update the remaining Amount to make it greater than Voucher Amount
Start Date
This value can not be empty and the value of this column should be in the date format.
Expiration Date
The value of this can not be a past date, a date before the start date, or empty. It should be in a date format.
Is Active
The value of this column should be either True or False OR Yes or No OR 1 or 0
The behavior of Voucher creation based on the value for this field should be considered for imports/updates.
Restrict Voucher To A Customer
The value of this column should be either 1 or 0 OR True or False
Note - The behavior of Voucher creation based on the value for this field should be considered for imports/updates.
Username
The value of this column should match the username of an existing user account that belongs to the resp. a store whose Store Code is used for import/bulk update.
When this value is added and imported, respective <Username> | <First Name> <Last Name> or <Username> | <First Name> or <Username> should appear on the Edit Voucher screen in admin application.
Account
A.) Mandatory Columns
Following are the columns that should be included in the CSV file to import the Account:
Parent Account Code
Account Name
Account Code
External ID
Catalog Code
Address Name
First Name
Last Name
Company Name
Address Line 1
Address Line 2
Country
State/Province/Region
City
Postal Code
Phone Number
Default Billing Address
Default Shipping Address
B.) Requirements of each column in CSV file
Parent Account Code
Administrators can save a value in this field with a maximum of 100 characters without any special characters.
The added value should belong to any existing Account which is not a child account of any other account.
The value of this column can remain empty.
Account Name
Administrators can save a value in this field with a maximum of 100 characters.
The value should be either alphabets or numbers or a combination of both but not special characters.
The value of this column cannot remain empty.
Account Code
Administrators can save a value in this field with a maximum of 100 characters without any special characters.
The value should be unique for a specific account.
The value of this column cannot remain empty.
External ID
Administrators can save a value in this field with a maximum of 100 characters.
The value of this column can remain empty.
Catalog Code
Administrators can save a value in this field with a maximum of 100 characters.
The added value should belong to any existing catalog.
The value of this column cannot remain empty.
Address Name
Administrators can save a value in this field with a maximum of 200 characters.
The value of this column cannot remain empty.
First Name
Administrators can save a value in this field with a maximum of 300 characters.
The value of this column cannot remain empty.
Last Name
Administrators can save a value in this field with a maximum of 300 characters.
The value of this column cannot remain empty.
Company Name
Administrators can save a value in this field with a maximum of 300 characters.
The value of this column can remain empty.
Address Line 1
Administrators can save a value in this field with a maximum of 200 characters.
The value of this column cannot remain empty
Address Line 2
Administrators can save a value in this field with a maximum of 200 characters.
The value of this column can remain empty
Country
Administrators can save a value in this field from the predefined Country options.
The value of this column cannot remain empty.
State/Province/Region
Administrators can save a value in this field from the predefined State options for the United States country only.
For other countries, the value can be anything with a maximum of 100 characters.
The value of this column cannot remain empty.
City
Administrators can save a value in this field with a maximum of 100 characters.
The value of this column cannot remain empty.
Postal Code
Administrators can save a numeric value in this field with a maximum of 100 characters.
The value of this column cannot remain empty.
Phone Number
Admin users should be allowed to save a value in this field with a maximum of 100 characters.
The value of this column cannot remain empty.
Default Billing Address
The value of this column should be 1 or 0.
The behavior of account creation based on the value for this field should be considered for imports/updates.
The value of this column cannot remain empty.
Default Shipping Address
The value of this column should be 1 or 0.
The behavior of account creation based on the value for this field should be considered for imports/updates.
The value of this column cannot remain empty.
Important Note - Default billing and shipping addresses of accounts reflect under Manage User for account users. The behavior should remain unchanged.
Synonyms
A.) Mandatory Columns
Following are the columns that should be included in the CSV file to import the Synonyms:
Catalog Code
Synonym Code
Rename Synonym Code
Original Term
Replaced By
Is Bidirectional
B.) Requirements of each column in CSV file
Catalog Code
Administrators can save a value in this field in alphanumeric format with a maximum of 100 characters without any special characters
The value should be unique for a specific catalog
The value of this column can remain empty in case of an update but will be mandatory in case of a new import.
Synonym Code
Administrators can save a value in this field in alphanumeric format with a maximum of 100 characters without any special characters
The value should be unique for a specific Synonym
The value of this column cannot remain empty
Rename Synonym Code
Administrators can save a value in this field in alphanumeric format with a maximum of 100 characters without any special characters
The value should be unique for a specific Synonym
The value of this column can remain empty
Note: If there is a value found in this column at the time of a new import, wherein the Synonym code column has a new value, the admin application ignores any value within the Rename Synonym Column
Original Term
Administrators can save one or a maximum of 20 values. For multiple values, every value should be separated by a pipe. Also, every value accepts a maximum 100 number of characters
The value should consist of the following
Alphabets
Numbers
Special characters
Combination of any of the three
The value of this column can remain empty in case of an update but is mandatory in case of a new import
Replaced By
Administrators can save one or a maximum of 20 values. For multiple values, every value should be separated by a pipe. Also, every value accepts a maximum 100 number of characters
The value should consist of the following
Alphabets
Numbers
Special characters
Combination of any of the three
The value of this column can remain empty in case of an update but will be mandatory in case of a new import
Is Bidirectional
The value of this column should be either True/1/Yes or False/0/No
The behavior of Synonyms is considered based on the value of this field
The value of this column can remain empty in case of an update but will be mandatory in case of a new import.
Import Statuses
Status | Description |
Started | When any Import is in progress, the Import Status displays as “Started” |
Completed Successfully | When any Import is completed and there are no failed records, the Import Status displays as “Completed Successfully” |
Completed With Errors | When any Import is completed and there is at least one failed record and at least one succeeded record, the Import Status should be displayed as “Completed With Errors” |
Failed | When any Import is completed and all the records are failed, the Import Status should be displayed as “Failed” |
Note - The Import Status of Product Bulk Update initiated from PIM >> Products page is also displayed on the Admin >> Imports list page.