0% found this document useful (0 votes)
9 views79 pages

Product Catalog Data Structure

The document outlines a comprehensive catalog structure for product listings, including mandatory and optional fields such as product details, dimensions, and compliance requirements. It emphasizes the importance of providing valid distinct catalog option combinations for each variant and includes specific guidelines for data entry. Additionally, it contains sections for images, stock and pricing details, and various codes related to product categorization.

Uploaded by

anirudhkp0921
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
9 views79 pages

Product Catalog Data Structure

The document outlines a comprehensive catalog structure for product listings, including mandatory and optional fields such as product details, dimensions, and compliance requirements. It emphasizes the importance of providing valid distinct catalog option combinations for each variant and includes specific guidelines for data entry. Additionally, it contains sections for images, stock and pricing details, and various codes related to product categorization.

Uploaded by

anirudhkp0921
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

Field

Category ID
Product code
Title
Description
Brand
Model
HSN
Alternate Category IDs
Image Groups
Video url link
Keywords
Key features
Importer codes
Manufacturing address codes
Marketer codes
Uom for Price Compare
Fulfillment Channel

Selling Unit
Box contents
Care Instructions
Variant SKU
Variant Title
Variant Default Image
1P Kirana
3P Kirana
RRL FC
Package Label
Manufacturer Warranty Value
Manufacturer Warranty Unit
Assembly Required
Assembled By
Package Dimension length value
Package Dimension width value
Package Dimension height value
Package Dimension depth value
Package Dimension gross weight value
Package Dimension volumetric weight value
Max Order Quantity Restrictions

Item Dimension length value

Item Dimension width value

Item Dimension height value


Item Dimension depth value

Item Dimension net weight value

Item Dimension volume value


Net Quantity Value
Roms Class
Has BIS Certification
Food Type
Item Code
Catalog Option 1: Name
Catalog Option 1: Value
Catalog Option 2: Name
Catalog Option 2: Value

Instructions
Catalog Compliance

Header Groups

Group

Catalog Basic Details

Variant Details
Image Details

Stock and Price Details

Category Specification details

Item and Package Dimension Details

Cell Types

Group

Mandatory

Non-Mandatory

Not Applicable
Mandatory

Yes
Yes
Yes
Yes

Yes

Yes

Yes
Yes
Identification Color
Identification Color
System generated. Please use the given value for all rows
catalog unique identifier
Name of the product
Product description
Brand of product
Model of product
Harmonized System of Nomenclature (HSN) Number
IDs of alternate categories for the product (seperated by ###)
Allowed Image group names (seperated by ###)
Video link which has more info about the product. Valid url eg: [Link]
Keywords for product (seperated by ###) (Maximum Allowed Values - Max Number of Tags: 250,Min Character Pe
Key features of the product (seperated by ###)
Importer codes for the product (seperated by ###)
Manufacturing address codes for the product (seperated by ###)
Marketer codes for the product (seperated by ###)
Unit which will be used for Price Comparison
Fulfillment channel to followed during order processing
Selling unit of the product. (If left empty, value from category will be used)
[Link] Selling unit is selected as none, Item Dimension length value, Item Dimension width value & Item Dimension he
[Link] Selling unit is selected as pieces, Item Dimension net weight value & Number of Pieces/Product are mandatory
[Link] Selling unit is selected as centimeter, meter or millimeter, Item Dimension length value, Item Dimension width v
[Link] Selling unit is selected as gram, kilogram or milligram, Item Dimension net weight value is mandatory
[Link] Selling unit is selected as liter or milliliter, Item Dimension volume value is mandatory
Box contents (seperated by ###) (Max Character per box content: 128)
Care instructions for product
Variant's unique identifier
Title of variant
Default image for the variant
Item available at 1P Kirana
Item available at 3P Kirana
Item available at RRL FC
Package labels for the product (separated by ###)
Warranty period value as provided by the manufacturer
Warranty period unit as provided by the manufacturer
Whether the product is pre-assembled or to be assembled manually
If not pre-assembled, who can assemble the product
Please enter the Length of the package in cm or mm
Please enter the Breadth of the package in cm or mm
Please enter the Height of the package in cm or mm
Please enter the Depth of the package in cm or mm
Please enter the gross weight of the package in kg or gm
Volumetric weight of the package. Auto calculated as package's (length(in cm) * width(in cm) * height(in cm))/5000
Max Order Quantity Restrictions for the variant (separated by ###). format: time_window_type|time_window_value-

Please enter the length of the item in m or cm or mm; Item Dimension length value is mandatory if selling unit is sel

Please enter the width of the item in m or cm or mm; Item Dimension width value is mandatory if selling unit is selec

Please enter the height of the item in m or cm or mm; Item Dimension height value is mandatory if selling unit is sel
Please enter the depth of the item in m or cm or mm

Please enter the net weight of the item in kg or mg or g; Item Dimension net weight value is mandatory if selling uni

Please enter the volume of the item in l or ml; Item Dimension volume value is mandatory if selling unit is selected a
Specify the quantity by weight/measure/number (in numeric value)
Roms class name of the product
If BIS Certification is available
Select green_dot for 'vegetarian' product, red_dot for 'non-vegetarian' product and black_cross for 'Not For Human
Enter a 4-digit code (between 0001 and 9999) only if this product is to be listed for the one-page order journey
Multi-Variant dimension 1 Name for the catalog
Multi-Variant dimension 1 Value for the catalog
Multi-Variant dimension 2 Name for the catalog
Multi-Variant dimension 2 Value for the catalog

Kindly click here to review our Restricted Product guidelines. Ensuring compliance is crucial to prevent your catalog

Definition

Involves fundamental information about the catalog.

Relates to variations and catalog options of the catalogue.


Covers aspects related to the images associated with the catalogue.

Encompasses information regarding the availability of the catalogue in stock and its pricing.

Pertains to detailed specifications of the catalogue, providing specific information.

Focuses on the dimensions and size-related information for both the individual catalogue and its packaging.

Definition

Cells with a red border must be filled out as they are mandatory.

Cells without any border are optional and can be left blank.

Cells that are grayed out have no relevance to the selected category in column A.
Restrictions
Alphabetic / Numbers / Allowed special characters(:;.,+'*?^$()[]{}|"/_@-%#!&<>=éÉ’`…á]*)
Alphabetic / Numbers / Allowed special characters(:;.,+'*?^$()[]{}|"/_@-%#!&<>=éÉ’`…á]*)
Alphabetic / Numbers / Allowed special characters(:;.,+'*?^$()[]{}|"/_@-%#!&<>=éÉ’`…á]*), max length: 255
Alphabetic / Numbers / Allowed special characters(:;.,+'*?^$()[]{}|"/_@-%#!&<>=éÉ’`…á]*), max length: 65000
Alphabetic / Numbers / Allowed special characters(:;.,+'*?^$()[]{}|"/_@-%#!&<>=éÉ’`…á]*)
Alphabetic / Numbers / Allowed special characters(:;.,+'*?^$()[]{}|"/_@-%#!&<>=éÉ’`…á]*), max length: 255
Positive Numbers
Alphabetic / Numbers / Allowed special characters(:;.,+'*?^$()[]{}|"/_@-%#!&<>=éÉ’`…á]*)
List of category defined image groups
Complete Url (eg: [Link] max length: 100
Alphabetic / Numbers / Allowed special characters(:;.,+'*?^$()[]{}|"/_@-%#!&<>=éÉ’`…á]*)
Alphabetic / Numbers / Allowed special characters(:;.,+'*?^$()[]{}|"/_@-%#!&<>=éÉ’`…á]*)
Alphabetic / Numbers / Allowed special characters(:;.,+'*?^$()[]{}|"/_@-%#!&<>=éÉ’`…á]*)
Alphabetic characters / Numbers
Alphabetic / Numbers / Allowed special characters(:;.,+'*?^$()[]{}|"/_@-%#!&<>=éÉ’`…á]*)
Alphabetic / Numbers / Allowed special characters(:;.,+'*?^$()[]{}|"/_@-%#!&<>=éÉ’`…á]*)

List Of Defined Values


Alphabetic / Numbers / Allowed special characters(:;.,+'*?^$()[]{}|"/_@-%#!&<>=éÉ’`…á]*)
Alphabetic / Numbers / Allowed special characters(:;.,+'*?^$()[]{}|"/_@-%#!&<>=éÉ’`…á]*)
Alphabetic / Numbers / Allowed special characters(:;.,+'*?^$()[]{}|"/_@-%#!&<>=éÉ’`…á]*)
Alphabetic / Numbers / Allowed special characters(:;.,+'*?^$()[]{}|"/_@-%#!&<>=éÉ’`…á]*)
Alphabetic / Numbers / Allowed special characters(:;.,+'*?^$()[]{}|"/_@-%#!&<>=éÉ’`…á]*)

Allowed package labels from the meta list


Positive Numbers Zero excluded
Alphabetic / Numbers / Allowed special characters(:;.,+'*?^$()[]{}|"/_@-%#!&<>=éÉ’`…á]*)

Alphabetic / Numbers / Allowed special characters(:;.,+'*?^$()[]{}|"/_@-%#!&<>=éÉ’`…á]*)


Numbers
Numbers
Numbers
Numbers
Numbers
Numbers
Alphabetic / Numbers / Allowed special characters(:;.,+'*?^$()[]{}|"/_@-%#!&<>=éÉ’`…á]*)

Numbers, min value: 0.1

Numbers, min value: 0.1

Numbers, min value: 0.1


Numbers, min value: 0.1

Numbers, min value: 0.1

Numbers, min value: 0.1


Positive Numbers Zero excluded
Alphabetic / Numbers / Allowed special characters(:;.,+'*?^$()[]{}|"/_@-%#!&<>=éÉ’`…á]*)
Alphabetic characters

Positive Numbers Zero excluded, min value: 1, max value: 9999


Allowed values from the Catalog Options List for the category
Allowed values from the Catalog Options List for the category
Allowed values from the Catalog Options List for the category
Allowed values from the Catalog Options List for the category
Category name Product code
groceries/teethcare/oral_care/toothpaste 9528791222
groceries/teethcare/oral_care/toothpaste 9528791222
groceries/teethcare/oral_care/toothpaste 95287912222
groceries/teethcare/oral_care/toothpaste 95287912222
groceries/teethcare/oral_care/toothpaste 952122222
groceries/teethcare/oral_care/toothpaste 952122222
groceries/teethcare/oral_care/toothpaste 766871
groceries/teethcare/oral_care/toothpaste 766871
Errors
Please provide valid distinct catalog option combinations for each variant.
Please provide valid distinct catalog option combinations for each variant.
Please provide valid distinct catalog option combinations for each variant.
Please provide valid distinct catalog option combinations for each variant.
Please provide valid distinct catalog option combinations for each variant.
Please provide valid distinct catalog option combinations for each variant.
Please provide valid distinct catalog option combinations for each variant.
Please provide valid distinct catalog option combinations for each variant.
Title Description Brand Model
PVC RainCoat Best Raincoats dove
PVC RainCoat Best Raincoats dove
PVC RainCoat Best Raincoats dove
PVC RainCoat Best Raincoats dove
PVC RainCoat Best Raincoats dove
PVC RainCoat Best Raincoats dove
PVC RainCoat Best Raincoats dove
PVC RainCoat Best Raincoats dove
Roms Class HSN HSN code
WHEAT 3204 3204
WHEAT 3204 3204
WHEAT 3204 3204
WHEAT 3204 3204
WHEAT 3204 3204
WHEAT 3204 3204
WHEAT 3204 3204
WHEAT 3204 3204
Alternate Category IDs Keywords
Key features Selling Unit Food Type
-NONE- green_dot
-NONE- green_dot
-NONE- green_dot
-NONE- green_dot
-NONE- green_dot
-NONE- green_dot
-NONE- green_dot
-NONE- green_dot
Uom for Price Compare Importer codes
Manufacturing address codes Marketer codes
Food coupon accepted Weighted Item
false
false
false
false
false
false
false
false
Disclaimer Brand Size Chart Code
Box contents Care Instructions
Safety Warning Safety Rating Video url link
Manufacturer Warranty Value
Manufacturer Warranty Unit Assembly Required
Assembled By Has BIS Certification
yes
yes
yes
yes
yes
yes
yes
yes
Fulfillment Channel Variant Title
1P PVC RainCoat
1P PVC RainCoat
1P PVC RainCoat
1P PVC RainCoat
1P PVC RainCoat
1P PVC RainCoat
1P PVC RainCoat
1P PVC RainCoat
Variant SKU Catalog Option 1: Name
9528791222
9544122222
95287912222
954414422
952122222
952879121
766871
952879122222
Catalog Option 1: Value
Catalog Option 2: Name
Catalog Option 2: Value EAN
112112927812
19105636252
1232563652
191205636252
1905636252
11211927812
1111927812
12325636252
Package Label Number of Pieces/Product
Item Code
Image: Front View 1
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
Image: Front View 2
[Link]
[Link]
[Link]
[Link]
Image: Front View 3 Image: Front View 4
Image: Front View 5 Image: Front View 6
Image: Front View 7 Image: Front View 8
Image: Front View 9 Image: Front View 10
Variant Default Image Stock SKU
9528791222
9544122222
95287912222
954414422
952122222
952879121
766871
952879122222
Max Order Quantity Restrictions
Minimum Order Quantity Maximum Order Quantity
1 4
1 4
1 4
1 4
1 4
1 4
1 4
1 4
Track Inventory Track Inventory For Insta
true true
true true
true true
true true
true true
true true
true true
true true
Shelf life value Shelf life unit
100000 days
100000 days
100000 days
100000 days
100000 days
100000 days
100000 days
100000 days
Country of Origin 1P Kirana 3P Kirana
India
India
India
India
India
India
India
India
RRL FC salt #C1507E_5450
rgaerr
sdfdge
sdfdge
rgaerr
rgaerr
sdfdge
rgaerr
sdfdge
Calcium percentage #C5296N_5450
Net Quantity #C9284T_5450
Gramage #C1067O_5450
Item Dimension length value
10
11
12
13
14
15
16
17
Item Dimension length unit
centimeter
meter
centimeter
meter
centimeter
meter
centimeter
meter
Item Dimension width value
15
20
15
20
15
20
15
20
Item Dimension width unit
centimeter
meter
centimeter
meter
centimeter
meter
centimeter
meter
Item Dimension height value
15
21
15
21
15
21
15
21
Item Dimension height unit
centimeter
meter
centimeter
meter
centimeter
meter
centimeter
meter
Item Dimension depth value
Item Dimension depth unit
Item Dimension net weight value
150
170
150
170
150
170
150
170
Item Dimension net weight unit
gram
kilogram
gram
kilogram
gram
kilogram
gram
kilogram
Item Dimension volume value
Item Dimension volume unit
Package Dimension length value
Package Dimension length unit
Package Dimension width value
Package Dimension width unit
Package Dimension height value
Package Dimension height unit
Package Dimension depth value
Package Dimension depth unit
Package Dimension gross weight value
Package Dimension gross weight unit
Package Dimension volumetric weight value
Package Dimension volumetric weight unit
Net Quantity Value Net Quantity Unit
100 g
150 kg
100 g
150 kg
100 g
150 kg
100 g
150 kg
Category Name
groceries/teethcare/oral_care/toothpaste
Category ID
home_ho10761057_pers_oral_toot
Category Hierarchy
Groceries >> teethcare >> Oral Care >> Toothpaste
Category Name Quantity Weight
groceries/teethcare/oral_care/toothpaste 1pack 100gm
groceries/teethcare/oral_care/toothpaste 2 pack 200gm
groceries/teethcare/oral_care/toothpaste 3 pack 350gm
groceries/teethcare/oral_care/toothpaste 4 pack 500gm
groceries/teethcare/oral_care/toothpaste 5 pack 750gm
groceries/teethcare/oral_care/toothpaste 6 pack
groceries/teethcare/oral_care/toothpaste 7 pack
groceries/teethcare/oral_care/toothpaste 8 pack
groceries/teethcare/oral_care/toothpaste 2pack
Category Name Brands
groceries/teethcare/oral_care/toothpaste Lifeboy
groceries/teethcare/oral_care/toothpaste patanjali
groceries/teethcare/oral_care/toothpaste Colgate
groceries/teethcare/oral_care/toothpaste dove
groceries/teethcare/oral_care/toothpaste LUX
groceries/teethcare/oral_care/toothpaste Haldi Set

You might also like