This category lets you import items and product hierarchy according to the organization's product inventory.

You can have up to four levels above items including brands and categories. For example, if L1, L2, L3, and L4 are four categories from top to bottom level, you can import all categories at a time with a proper mapping or one by one from L1 to L4.  However, it is recommended to use the second case to ensure proper mapping.

It is important to understand the following points while configuring Profile Templates.

ActionBehavior

If same field is selected in both update and ignore

Data will be updated
A column is selected to update but not mappedField data will not be updated

Column not selected to update but mapped

Field data will not be updated

Updating item-code details for a category or brand ensuring that the Category and brand import is correct

Data will be updated

 

TABLE OF CONTENTS


Category

You will have item code by default which is the lowest level. You can add up to four levels above the item code.

Assume L4, L3, L2, L1, L0 as different levels where L0 is item code and L4 is the super parent. You need to first import a parent category followed by child category.

You can make a super parent category a root category using the option Mark parent category as root if not mapped for existing categories.


This profile lets you update existing categories of a brand or add new child categories. To use this profile, the org should have at least one parent category under it.

  • Category Code
  • Parent Category Code
  • Category Name
  • Category Description 

Leave the Parent Category Code blank for parent categories and specify the respective parent category code for child categories.

CSV Sample:

Category Code,Parent Category Code, Category Name,Category Description
Shirts,Apparels,categoryName,Men Apparels

Configuring Template

  1. Add the fields that you want to allow updating for the current template, Any field that you did not add here will be ignored even if you do the field mapping
  2. Select Mark parent category as root if not mapped for new categories, to enable converting a new category parent if not mapped any parent category
  3. Select Mark parent category as root if not mapped for existing categories, to convert existing categories - that are not mapped to any parent category - as parent categories
  4. Click Submit to save the template

  • Mark parent category as root if not mapped for new categories: Check this option to make new parent categories of the current import as root brands.
  • Mark parent category as root if not mapped for existing categories: Check this option to make existing parent categories as root brands through the current import.

Inventory

This profile allows you to import product inventory for an organization. For this, you need to have categories created for the Org and you can specify values of each category in the data file. To import root categories and brands use the profiles Category and Brands respectively. Please navigate to the respective sections for more details. 

If any new category is identified in the file that you import, a category is created  without any parent mapping. Hence, if you have new categories, it is recommended to do a category import before importing inventory details.

Important checklist for inventory import:

Before importing inventory

  • identify hierarchy levels and new attributes in the file.
  • Item codes are alpha-numeric and do not have special characters, spaces, blank or null values.
  • Item codes are unique and no duplicate codes are available.
  • An item code is associated only to one category.
  • Character count of item codes do not exceed 50 (Else, contact the Platform API Team to extend the character limit)
  • If an item-code has prefix '0' or long digit value, example: 9988777665511, 00006785, it is recommended not to open the file directly on Notepad.
  • You can use only predefined attributes or custom attributes configured in InTouch > Settings > Miscellaneous > Inventory Operations > Inventory Attributes. Any unknown attribute will be ignored automatically. Make sure to configure your required attributes on the Inventory Attributes page before importing

 

Inventory hierarchy

Each organization might have a different product hierarchy - it could be hierarchy levels, supported attributes, brands or any other attribute. Before starting with the import, you need to validate the data file of the organization with that of the Capillary's.

This profile is used to import the inventory details of stores. The CSV file should contain all the mandatory fields along with supported optional fields.

  • SKU*
  • EAN*
  • Price
  • Description
  • Brand Code
  • Category Code
  • Style Code

Prerequisites

  • Data Quality Report (DQR) to check the quality of data mapping (in percentage).
  • Compare inventory item-codes with that of transaction line-items before importing.

CSV Sample:

Sku,Ean,Price,Description,BrandCode,CategoryCode,StyleCode

1234567,1234567,32,Pencils,Camelin,Camelinpencil2HB,PencilSytle

Configuring Template

OPTIONDESCRIPTION
Disable existing data updationCheck this box to not allow updating existing inventory details if the field value is already available. Not applicable for first time import.
Create brand if provided brand_code does not existCheck this box to allow creating brands automatically if any new brand code (as per the Capillary database) appears in the CSV file.
Create category if provided category_code does not existCheck this box to allow creating categories automatically if a new category code (that is not in the Capillary database) is identified in the CSV file.
Create style if provided style_code does not existCheck this box to allow creating styles automatically if any style code provided in the CSV file does not exist in the database.
Select fields to be ignored if invalidAdd fields that you want to ignore from updating in case of invalid field names identified in the CSV file.
Select fields to be updatedAdd fields that you want to update in the current import. Any other field that is available in the CSV file will be ignored even if you do the field mapping.
Disable updation of custom fields with empty valuesCheck this box to not allow updating custom field values with null values if found in the csv file

Update Inventory Line-items

This profile lets you update line-item ids (item codes) in the loyalty_bill_lineitems table. Use this profile to update item ids that are wrongly entered or with null values.

  • Line-item id
  • Item Code

Prerequisites

Compare inventory item-codes with that of transaction line-items before importing

CSV Sample

Line Item Id, Item Code
9970661,GB58

Configuring Template

Check the Update the existing item code box to allow updating existing item codes with the new values in the csv file and click Submit.

Brands

This profile lets you add child brands, or update existing brands. To use this profile, the org should have configured at least with one parent brand.

  • Brand Code
  • Brand Parent Code
  • Brand Name
  • Brand Description

CSV Sample:

Brand Code,Parent Brand Code, Brand Name,Brand  Description
Shirts,Apparels,Brand Name,Men Apparels

Configuring Template

 Add the fields that you want to include for the current profile template and click Submit to save the template.   

  • Mark parent brand as root if not mapped for new brands: Check this option to make new parent brands of the current import as root brands
  • Mark parent brand as root if not mapped for existing brands: Check this option to make existing parent brands as root brands through the current import