1. Home
  2. Docs
  3. IRIS-SAAS
  4. File Formats

File Formats

Various inputs required by the system are given below. Note that Masters are crucial for data validation. If your sales, planogram, AOP inputs contain data which are not in the master, then the system will not upload that data and an error will be shown on the screen. 
All data must be uploaded in TSV format (tab separated values). You can always store your Excel files using TSV format. We don’t use CSV, as it creates issues in reading data when the values contain a comma.

Important: Please use numbers, where numbers are shown in the following formats. Use only values for revenue etc., do not put USD, INR etc. Also make sure that files are uploaded in the order they are asked for.

Data Format
Stores Master List of all stores. We do not support new stores currently.
  • partner_id represents your store partner network. E.g. Amazon, EBO (exclusive brand outlets), Costco (a partner chain) etc.
  • region represents how you’ve divided your stores into regions. This helps in understanding your business in and across regions
  • store_id represents a unique identifier for your store. It must be unique across all rows.

partner_idregionstore_idstore_name
EBOsouthBLR_123Bangalore Indranagar Outlet
EBOsouthBLR_124Bangalore Indranagar Outlet
AmazoncountryAmazonStoreAmazon E-Commerce
AlibabacountryAlibabaStoreAlibaba E-Commerce
Attributes Master Valid data ranges to accept for styles attributes, e.g. brand, category. All your sales data is clustered using these attributes.
  • The exit_flag flag tells the system whether to exit a size from the store, if it is not selling well there. This is generally relevant only where number of sizes is too large (e.g. Lingerie).
  • The mrp_bucket parameter is used to identify MRP range for that style. Example, it could be 101-200, 201-300 etc. Another example could be LOW, MEDIUM, HIGH. This parameter helps us understand what MRP price ranges your customers are comfortable in buying.

brand category subcategory gender mrp_bucket exit_flag
Victor’s Secret shoe casual shoe M 101-200 true
Victor’s Secret shoe casual shoe M 201-300 true
Styles Master All styles along with their attributes are uploaded in this file. All sales data is clustered using these attributes.
  • The style parameter must be an ID (not a name) and must be unique for all styles.
  • The mrp_bucket parameter is used to identify MRP range for that style. Example, it could be 101-200, 201-300 etc. Another example could be LOW, MEDIUM, HIGH. This parameter helps us understand what MRP price ranges your customer’s are comfortable for buying.
  • The image_url parameter may be used to specify the image location for a style.

style brand category subcategory gender mrp mrp_bucket image_url
S3001 Victor’s Secret Shoe Casual Male 99.90 50-100 http://vs.com/s3001.img
S3002 Victor’s Secret Shoe Formal Male 102.90 101-150 http://vs.com/s3001.img
Category Size Set Master All valid sizes for different brand, categories, subcategories and gender are provided here.
brand category subcategory gender sizes
Victor’s Secret shoe casual shoe M 6,7,8,9,10,11,12
Victor’s Secret shirt tshirt M s,m,l,xl,xxl
Victor’s Secret shirt formal M 32,34,36,38,40
SKU Master All SKUs, which style they belong to, and their sizes are uploaded in this input.
  • 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
1239878987 S3001 6
1239878989 S3002 8
Sales Daily sales data for every store and SKU
  • date must be in yyyy-mm-dd format
  • revenue is daily aggregated value.
  • discount will be calculated using revenue, MRP and quantity (discount = (MRP * quantity) – revenue). The MRP is used from the style data.
  • large data can be uploaded in multiple smaller file chunks
  • sales data is updated every time you upload a file. If a new day, store_id and sku combination is uploaded, it is treated as a new entry. However, if an existing day, store_id and sku combination is uploaded, the corresponding revenue and quantity is updated.
  • delete option is provided to delete sales data for a store or within a given date range
day store_id sku revenue quantity
2018-01-18 BLR_123 1239878987 74.00 1
2018-01-18 BLR_123 1239878989 198.60 2
2018-01-19 BLR_123 1239878987 74.00 1
AOP Annual Operating Plan at Store level. This corresponds to the revenue target for each store for each month.
  • month must be in yyyy-mm format
  • revenue is the targeted monthly revenue. This cannot be derived, as one may change targets based on changing business conditions (e.g. working capital, promotions etc.).

store_id month revenue
BLR_123 2019-01 80000
Warehouse Inventory Combined inventory across all warehouse on sku level

sku quantity
1239878987 70
1239878989 32
Store Inventory Current store inventory

store_id sku quantity
BLR_123 1239878987 8
BLR_123 1239878989 4
Store Planogram Store planogram corresponds to the capacity for each store for each category. Further
  • size_set_qty is the quantity of a style which should be sent to a store while allocating.
store_id category capacity size_set_qty
BLR_123 shoe 100 4
BLR_123 shirt 200 3

Was this article helpful to you? Yes No

How can we help?