{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Catalogue data","Sample"],"not_rendered":{"images":1,"macros":1},"read":"whole","date_system":"1900"}

{"sheet":"Catalogue data","index":0,"n_rows":72,"n_cols":1,"rows_kept":72}
[]
["action"]
["item_number"]
["Item_number_type"]
["selcode"]
["hierarchy.node_description"]
["product"]
["hierarchy.product_description"]
["hierarchy.product_description.extended"]
["ITEM.NRF_COLOR_CODE"]
["ITEM.COLOR_DESCRIPTION"]
["ITEM.NRF_SIZE_CODE"]
["ITEM.SIZE_DESCRIPTION"]
["ITEM.NEW_PRODUCT_INTRODUCTORY_PRICE"]
[":UOM"]
[":PRIVATE_ACCOUNT_ID"]
["ITEM.NEW_PRODUCT_INTRODUCTORY_PRICE.EFFECTIVE_DATE"]
["ITEM.NEW_PRODUCT_INTRODUCTORY_PRICE.EXPIRATION_DATE"]
["ITEM.NEW_PRODUCT_INTRODUCTORY_PRICE"]
[":UOM"]
[":PRIVATE_ACCOUNT_ID"]
["ITEM.NEW_PRODUCT_INTRODUCTORY_PRICE.EFFECTIVE_DATE"]
["ITEM.NEW_PRODUCT_INTRODUCTORY_PRICE.EXPIRATION_DATE"]
["ITEM.UNIT_COST"]
[":UOM"]
[":PRIVATE_ACCOUNT_ID"]
["ITEM.UNIT_COST.EFFECTIVE_DATE"]
["ITEM.UNIT_COST.EXPIRATION_DATE"]
["ITEM.UNIT_COST"]
[":UOM"]
[":PRIVATE_ACCOUNT_ID"]
["ITEM.UNIT_COST.EFFECTIVE_DATE"]
["ITEM.UNIT_COST.EXPIRATION_DATE"]
["MANUFACTURER'S SUGGESTED RETAIL PRICE"]
[":UOM"]
["SUGGESTED RETAIL PRICE EFFECTIVE DATE"]
["SUGGESTED RETAIL PRICE EXPIRATION DATE"]
["MANUFACTURER'S SUGGESTED RETAIL PRICE"]
[":UOM"]
["SUGGESTED RETAIL PRICE EFFECTIVE DATE"]
["SUGGESTED RETAIL PRICE EXPIRATION DATE"]
["ITEM.MINIMUM_ADVERTISED_PRICE"]
[":UOM"]
["ITEM.MINIMUM_ADVERTISED_PRICE.EFFECTIVE_DATE"]
["ITEM.MINIMUM_ADVERTISED_PRICE.EXPIRATION_DATE"]
["ITEM.MINIMUM_ADVERTISED_PRICE"]
[":UOM"]
["ITEM.MINIMUM_ADVERTISED_PRICE.EFFECTIVE_DATE"]
["ITEM.MINIMUM_ADVERTISED_PRICE.EXPIRATION_DATE"]
["ITEM.AVAILABLE_DATE"]
["ITEM.AVAILABLE_DATE.CONSUMER"]
["ITEM.TRADE_NAME"]
["ITEM.STYLE_NUMBER"]
["ITEM.WARRANTY_DESC"]
["ITEM.WARRANTY.URL"]
["ITEM.MARKED.RETAIL_PRICE.AMOUNT"]
[":UOM"]
["ITEM.FEATURE_BENEFIT"]
["ITEM.FEATURE_BENEFIT"]
["ITEM.GENDER_BY_AGE"]
["ITEM.VENDOR_SIZE_CODE"]
["ITEM.VENDOR_SIZE_DESC"]
["ITEM.VENDOR_COLOR_CODE"]
["ITEM.VENDOR_COLOR_DESC"]
["ITEM.WARRANTY_PERIOD"]
[":UOM"]
["ITEM.ORIGIN_COUNTRY"]
["ITEM.ORIGIN_COUNTRY"]
["ITEM.MASTER_PACK_QTY"]
["ITEM.MODEL_NUMBER"]
["ITEM.MSDS.URL"]
["ITEM.INNER_PACK_QTY"]

{"sheet":"Sample","index":1,"n_rows":72,"n_cols":6,"rows_kept":72,"merged":[[0,2,0,5],[4,2,4,5],[5,2,5,5],[6,2,6,5],[7,2,7,5],[8,2,8,5]]}
[null,"Sample Data","Acceptable Values/Notes"]
["action","insert","insert","update","delete"]
["item_number","123456000001","12 digit UPC","13 digit EAN","14 digit GTIN","8 digit GTIN"]
["Item_number_type","UP","UP","EN","UK","EO"]
["selcode","100","Selection Code"]
["hierarchy.node_description","RUNNING SHOES","Selection Code Description"]
["product","90001","Product, SKU, or Style Number  (only special characters allowed is  - (hyphen)  )"]
["hierarchy.product_description","WOMENS","Style Description (only special characters allowed are:  - (hyphen), / (forward slash) , & (ampersand)  )"]
["hierarchy.product_description.extended","WOMENS RUNNING SHOES","Style Description (only special characters allowed are:  - (hyphen), / (forward slash) , & (ampersand)  )"]
["ITEM.NRF_COLOR_CODE","675"]
["ITEM.COLOR_DESCRIPTION","BrightPink"]
["ITEM.NRF_SIZE_CODE","50036"]
["ITEM.SIZE_DESCRIPTION","5.5"]
["ITEM.NEW_PRODUCT_INTRODUCTORY_PRICE","149.99"]
[":UOM","USD"]
[":PRIVATE_ACCOUNT_ID","127242733083"]
["ITEM.NEW_PRODUCT_INTRODUCTORY_PRICE.EFFECTIVE_DATE","2014-03-31"]
["ITEM.NEW_PRODUCT_INTRODUCTORY_PRICE.EXPIRATION_DATE","2014-04-28"]
["ITEM.NEW_PRODUCT_INTRODUCTORY_PRICE"]
[":UOM"]
[":PRIVATE_ACCOUNT_ID"]
["ITEM.NEW_PRODUCT_INTRODUCTORY_PRICE.EFFECTIVE_DATE"]
["ITEM.NEW_PRODUCT_INTRODUCTORY_PRICE.EXPIRATION_DATE"]
["ITEM.UNIT_COST","89.00"]
[":UOM","USD"]
[":PRIVATE_ACCOUNT_ID","127242733083"]
["ITEM.UNIT_COST.EFFECTIVE_DATE"]
["ITEM.UNIT_COST.EXPIRATION_DATE"]
["ITEM.UNIT_COST"]
[":UOM"]
[":PRIVATE_ACCOUNT_ID"]
["ITEM.UNIT_COST.EFFECTIVE_DATE"]
["ITEM.UNIT_COST.EXPIRATION_DATE"]
["MANUFACTURER'S SUGGESTED RETAIL PRICE","159.99"]
[":UOM","USD"]
["SUGGESTED RETAIL PRICE EFFECTIVE DATE"]
["SUGGESTED RETAIL PRICE EXPIRATION DATE"]
["MANUFACTURER'S SUGGESTED RETAIL PRICE"]
[":UOM"]
["SUGGESTED RETAIL PRICE EFFECTIVE DATE"]
["SUGGESTED RETAIL PRICE EXPIRATION DATE"]
["ITEM.MINIMUM_ADVERTISED_PRICE","149.99"]
[":UOM","USD"]
["ITEM.MINIMUM_ADVERTISED_PRICE.EFFECTIVE_DATE","2014-03-31"]
["ITEM.MINIMUM_ADVERTISED_PRICE.EXPIRATION_DATE","2014-04-28"]
["ITEM.MINIMUM_ADVERTISED_PRICE"]
[":UOM"]
["ITEM.MINIMUM_ADVERTISED_PRICE.EFFECTIVE_DATE"]
["ITEM.MINIMUM_ADVERTISED_PRICE.EXPIRATION_DATE"]
["ITEM.AVAILABLE_DATE","2013-07-05"]
["ITEM.AVAILABLE_DATE.CONSUMER","2013-07-19"]
["ITEM.TRADE_NAME","ALICE RUNNING SHOE"]
["ITEM.STYLE_NUMBER","TEST STYLE NUMBER"]
["ITEM.WARRANTY_DESC","one year guarantee"]
["ITEM.WARRANTY.URL","www.samplewarrantyurl.com"]
["ITEM.MARKED.RETAIL_PRICE.AMOUNT","159.99"]
[":UOM","USD"]
["ITEM.FEATURE_BENEFIT","Test feature 1"]
["ITEM.FEATURE_BENEFIT","Test feature 2"]
["ITEM.GENDER_BY_AGE","WOMEN'S"]
["ITEM.VENDOR_SIZE_CODE","5.5"]
["ITEM.VENDOR_SIZE_DESC","US = 5.5 = UK = 5 EUROPE = 38"]
["ITEM.VENDOR_COLOR_CODE","PINK/WHITE"]
["ITEM.VENDOR_COLOR_DESC","Atomic Pink/Royal White"]
["ITEM.WARRANTY_PERIOD","365"]
[":UOM","DA"]
["ITEM.ORIGIN_COUNTRY","GBR"]
["ITEM.ORIGIN_COUNTRY"]
["ITEM.MASTER_PACK_QTY","10"]
["ITEM.MODEL_NUMBER","12345"]
["ITEM.MSDS.URL","www.samplemsdsurl.com"]
["ITEM.INNER_PACK_QTY","2"]