...
Adding new file deletes the data already present and the latest input is utilized
store_id must be unique
Product Master
Master file consisting of all SKU and Style details like Category, Subcategory, MRP etc.-
SKU is the SKU barcode (e.g. EAN). Must be unique across rows
Style is the ID of the style to which the SKU belongs to. This parameter must be an ID (not a name)
The image_url parameter may be used to specify the image location for a style.
style_enabled represents if a style is enabled or not. Value 1 represents enabled and value 0 represents disabled.
sku | style | size | mrp | brand | category | subcategory | gender | mrp_bucket | image_url | style_enabled |
|---|---|---|---|---|---|---|---|---|---|---|
1239878987 | S3001 | 6 | 599 | Victor’s Secret | Shoe | Casual | Male | 50-100 | 1 | |
1239878989 | S3002 | 8 | 1299 | Victor’s Secret | Shoe | Formal | Male | 101-150 | 0 |
Attributes Master
Valid data ranges to accept for styles attributes, e.g. brand, category. All your sales data is clustered using these attributes.
...
sku is the SKU barcode (e.g. EAN). Must be unique across rows.
style and size must refer to the inputs above
sku | style | size | mrp |
|---|---|---|---|
1239878987 | S3001 | 6 | 599 |
1239878989 | S3002 | 8 | 1299 |
Data present already is updated and new rows are added when a new file is uploaded.
SKU/EAN must be unique
...