{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Welcome","Instructions & Definitions","Settings","Offer"],"not_rendered":{"charts":0,"images":9,"macros":1,"external_links":1,"defined_names":5,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Welcome","index":0,"n_rows":18,"n_cols":4,"rows_kept":18,"cut":false,"hidden":true,"merged":[[17,3,17,12],[8,3,8,12],[10,3,10,12],[12,3,12,12],[14,3,14,12],[16,3,16,12]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Thank you for using Walmart Price and Promotions Template"]
[]
[null,null,null,"**You are seeing this message because your macros are disabled**"]
[]
[null,null,null,"Walmart Price and Promotions Template uses macros to validate your data. This ensures that you will see fewer or no errors after uploading your file to Walmart. "]
[]
[null,null,null,"When you opened this worksheet, you clicked on \"Disable Macros\". Depending on version of excel you are using, you may have been presented with \"Enable Editing\", \"Enable Content\", \"Enable Macros\". "]
[]
[null,null,null,"How to enable Macros?"]
[null,null,null,"Please close this excel and re-open it. When presented with the macros pop-up, please click on \"Enable Macros\". Depending on version of excel, please click on \"Enable Macros\", \"Enable Editing\" or \"Enable Conent\"."]

{"sheet":"Instructions & Definitions","index":1,"n_rows":74,"n_cols":2,"rows_kept":74,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"Price & Promotions Bulk Update Instructions"]
[null,"Introduction"]
[]
[null,"This Excel template is designed for updating prices and promotions in bulk through the Seller Center. If you do not want to set up promotions, you can leave the promotions sections blank. The workbook uses macros to validate your entries. It is highly recommended that you leave macros enabled while working on the spreadsheet. If you disable macros prior to uploading, you should save your changes, close the worksheet, reopen it with macros turned on and run the validations."]
[]
[null,"For more details on the attributes you need to fill out in this Excel workbook, refer to the online Knowledge Base articles:"]
[null,"Updating Your Pricing Through The Seller Center"]
[null,"Improve Price Parity"]
[null,"Understanding Promotional Pricing"]
[null,"Creating Promotional Pricing In The Seller Center Via Excel Bulk Upload"]
[]
[null,"** NOTE: Do not delete any columns in the Excel. You can hide columns if necessary. **"]
[]
[null,"Walmart macros are supported by the following PC or Mac Excel versions: \n"]
[null,"   •    Mac: 2011 Excel 14.0 (part of Office 2011)\n   •    Mac: 2015 Excel 15.0 (part of Office 2016) \n   •    PC: Excel 2010 (v14) (part of Office 2010)\n   •    PC: Excel 2013 (v15) (part of Office 2013)\n   •    PC: Excel 2016 (v16) (part of Office 2016)"]
[]
[null,"Walmart Toolbar"]
[]
[null,"Depending on the version of Excel that you are using, you will see a Walmart Toolbar as shown below:"]
[]
[]
[null,"The toolbar's buttons do the following:"]
[null,"    View Knowledge Base – Takes you to the Walmart Knowledge Base, where you can read detailed articles on item setup. "]
[null,"    Validate Fields – Checks the workbook for errors and highlights any errors found."]
[]
[null,"Validation Macros"]
[null,"After you click on Validate on the Walmart toolbar, the validate column will change colors and your cells will be highlighted in different colors based on the type of errors they contain."]
[null," Green Validation Cell – No errors have been found in this row."]
[null," Red Validation Cell – One or more cells in this row contain an error. The cell with an error will be highlighted in the following colors:"]
[null," Gray – Cell contains invalid data. Choose an option from the dropdown."]
[null," Blue – Sheet contains duplicate SKU. Delete or correct one of the SKUs."]
[null," Salmon – This cell is required based on the other information provided. Please fill it in."]
[]
[]
[null,"** NOTE: The macros will help identify and eliminate common errors, but they will not verify the accuracy of your data or prevent system errors. **"]
[]
[null,"Entering Data"]
[]
[null,"Data Definitions"]
[]
[]
[]
[null,"Update Price"]
[null,"If you would like to update price but not create a promotion, you can fill out SKU and Price only. Leave all promotion-related sections blank. When you upload your file in the Seller Center, make sure to select Price Updates from the pop-up menu."]
[]
[null,"Creating Promotions"]
[null,"To set up a promotion, enter your Promo Price after you have filled out the SKU and the Price. Note that your Promo Price will be the Price for the duration of the promotion, and the Price may be displayed for comparison during the promotion. This will automatically set the Promotions Status to Active. Provide the Promo Start Date and Promo End Date, making sure that the Start Date is earlier than the End Date. If desired, fill in the optional attributes listed below."]
[]
[null,"Promo Type is an attribute that allows for a flag on your item with the word \"Clearance\" or \"Reduced\". If you leave this blank, your item will publish with no flag. If Walmart customers can find the same item for the same price or less on another marketplace, you should leave this attribute blank. "]
[null," Clearance:  This type should be used only when you're trying to clear out your \ninventory by significantly reducing the price. For example, when an item has been \ndiscontinued."]
[null," Reduced: This type should be used if savings are greater than $5 for items that \ncost more than $100, or 5% for items less than $100."]
[null," Base: This isn't a flag, but is a feature that allows you to delete a promotion that \nis currently active. Follow the instructions below to use this feature."]
[]
[null,"Promo Placement is an attribute you should only use when you are selling your items for less than the Minimum Advertised Price."]
[null,"    MAP - Cart: This placement will prevent the price from being displayed until a customer has put the item in their cart."]
[null,"    MAP - Checkout: This placement will prevent the price from being displayed until a customer has begun the checkout process."]
[]
[null,"When you upload your file in the Seller Center, make sure to select Promotional Price Updates. If you select Price Updates, your prices will update but your promotions will not. If you accidentally select Price Updates, simply upload the file again and select Promotional Price Updates."]
[]
[null,"Planning Multiple Promotions"]
[null,"If you would like to schedule multiple promotions, you can use the additional promotion columns. You can schedule up to 5 promotions at a time. Ensure \nthat the dates of your promotions do not overlap. If any of your promotions overlap, you will not be allowed to set them up."]
[]
[null,"If you realize you would like to create a new promotion after you've submitted an older promotion for an item, you should create that new promotion in the next slot (e.g., Promotion 2) and make sure to leave the first promotion in its slot (e.g., Promotion 1). Submitting a file with the Promotions Status as Active will wipe all previous promotions, so you must include all previous promotions in future uploads unless you want them to be deleted."]
[]
[null,"Changing Promotions"]
[null,"Walmart will not keep track of your promotions. If you've previously planned promotions and you want to change them, just upload a new Excel with the promotions you want and the Promotions Status set to Active. This will wipe and replace the previous promotions. If you change some promotional cells but the Promotions Status is not Active, your promotions will not update."]
[]
[null,"Deleting Promotions"]
[null,"If you would like to delete planned promotions, set the Promotions Status to Delete All. This will wipe and replace the previous promotions. If you delete the contents of the promotional cells but do not select Delete All, your promotions will not be deleted."]
[]
[null,"If you would like to delete a promotion that is currently live, set the Promo Type to Base and set the Promo Price equal to the Price. This will cause both cells to be gray. Upload this file and your current promotion will effectively cease because the prices are the same. You can later reupload the file with the promotions you want to set for future dates. However, you cannot upload a promotion that overlaps the promotion you've inactivated. Exercise caution when setting up promos to verify that the dates are correct before the promo goes live. The screenshot below indicates how you would inactivate a promotion currently running."]

{"sheet":"Settings","index":2,"n_rows":307,"n_cols":143,"rows_kept":307,"cut":false,"hidden":true,"merged":[[303,75,303,76],[303,77,303,78],[303,83,303,84],[303,100,303,101],[303,106,303,108],[301,141,301,142],[303,4,303,5],[303,27,303,28],[303,29,303,30],[303,31,303,32],[303,33,303,34],[303,37,303,38],[303,39,303,40],[303,41,303,42],[303,43,303,44],[301,23,301,44],[301,45,301,61],[301,62,301,79],[301,80,301,84],[301,85,301,111],[303,59,303,60],[301,112,301,140],[300,3,300,10],[301,1,305,1],[301,2,301,12],[301,13,301,14],[301,15,301,19],[301,20,301,22],[303,71,303,72],[303,62,303,63],[303,64,303,65],[303,66,303,67],[303,68,303,69],[303,112,303,113],[303,116,303,117],[303,137,303,138],[303,73,303,74]]}
["Fields Showing:","A",null,null,"Reduced","MAP - Cart",null,null,null,null,null,"AF","Afghanistan","Afghanistan - AF"]
[null,null,null,null,"Clearance","MAP - Checkout",null,null,null,null,null,"AL","Albania","Albania - AL"]
[null,null,null,null,"Base",null,null,null,null,null,null,"DZ","Algeria","Algeria - DZ"]
[null,null,null,null,null,null,null,null,null,null,null,"AS","American Samoa","American Samoa - AS"]
[null,null,null,null,null,null,null,null,null,null,null,"AD","Andorra","Andorra - AD"]
[null,null,null,null,null,null,null,null,null,null,null,"AO","Angola","Angola - AO"]
[null,null,null,null,null,null,null,null,null,null,null,"AI","Anguilla","Anguilla - AI"]
[null,null,null,null,null,null,null,null,null,null,null,"AQ","Antarctica","Antarctica - AQ"]
[null,null,null,null,null,null,null,null,null,null,null,"AG","Antigua and Barbuda","Antigua and Barbuda - AG"]
[null,null,null,null,null,null,null,null,null,null,null,"AR","Argentina","Argentina - AR"]
[null,null,null,null,null,null,null,null,null,null,null,"AM","Armenia","Armenia - AM"]
[null,null,null,null,null,null,null,null,null,null,null,"AW","Aruba","Aruba - AW"]
[null,null,null,null,null,null,null,null,null,null,null,"AU","Australia","Australia - AU"]
[null,null,null,null,null,null,null,null,null,null,null,"AT","Austria","Austria - AT"]
[null,null,null,null,null,null,null,null,null,null,null,"AZ","Azerbaijan","Azerbaijan - AZ"]
[null,null,null,null,null,null,null,null,null,null,null,"BS","Bahamas","Bahamas - BS"]
[null,null,null,null,null,null,null,null,null,null,null,"BH","Bahrain","Bahrain - BH"]
[null,null,null,null,null,null,null,null,null,null,null,"BD","Bangladesh","Bangladesh - BD"]
[null,null,null,null,null,null,null,null,null,null,null,"BB","Barbados","Barbados - BB"]
[null,null,null,null,null,null,null,null,null,null,null,"BY","Belarus","Belarus - BY"]
[null,null,null,null,null,null,null,null,null,null,null,"BE","Belgium","Belgium - BE"]
[null,null,null,null,null,null,null,null,null,null,null,"BZ","Belize","Belize - BZ"]
[null,null,null,null,null,null,null,null,null,null,null,"BJ","Benin","Benin - BJ"]
[null,null,null,null,null,null,null,null,null,null,null,"BM","Bermuda","Bermuda - BM"]
[null,null,null,null,null,null,null,null,null,null,null,"BT","Bhutan","Bhutan - BT"]
[null,null,null,null,null,null,null,null,null,null,null,"BO","Bolivia","Bolivia - BO"]
[null,null,null,null,null,null,null,null,null,null,null,"BA","Bosnia and Herzegovina","Bosnia and Herzegovina - BA"]
[null,null,null,null,null,null,null,null,null,null,null,"BW","Botswana","Botswana - BW"]
[null,null,null,null,null,null,null,null,null,null,null,"BV","Bouvet Island","Bouvet Island - BV"]
[null,null,null,null,null,null,null,null,null,null,null,"BR","Brazil","Brazil - BR"]
[null,null,null,null,null,null,null,null,null,null,null,"IO","British Indian Ocean Territory","British Indian Ocean Territory - IO"]
[null,null,null,null,null,null,null,null,null,null,null,"BN","Brunei Darussalam","Brunei Darussalam - BN"]
[null,null,null,null,null,null,null,null,null,null,null,"BG","Bulgaria","Bulgaria - BG"]
[null,null,null,null,null,null,null,null,null,null,null,"BF","Burkina Faso","Burkina Faso - BF"]
[null,null,null,null,null,null,null,null,null,null,null,"BI","Burundi","Burundi - BI"]
[null,null,null,null,null,null,null,null,null,null,null,"KH","Cambodia","Cambodia - KH"]
[null,null,null,null,null,null,null,null,null,null,null,"CM","Cameroon","Cameroon - CM"]
[null,null,null,null,null,null,null,null,null,null,null,"CA","Canada","Canada - CA"]
[null,null,null,null,null,null,null,null,null,null,null,"CV","Cape Verde","Cape Verde - CV"]
[null,null,null,null,null,null,null,null,null,null,null,"KY","Cayman Islands","Cayman Islands - KY"]
[null,null,null,null,null,null,null,null,null,null,null,"CF","Central African Republic","Central African Republic - CF"]
[null,null,null,null,null,null,null,null,null,null,null,"TD","Chad","Chad - TD"]
[null,null,null,null,null,null,null,null,null,null,null,"CL","Chile","Chile - CL"]
[null,null,null,null,null,null,null,null,null,null,null,"CN","China","China - CN"]
[null,null,null,null,null,null,null,null,null,null,null,"CX","Christmas Island","Christmas Island - CX"]
[null,null,null,null,null,null,null,null,null,null,null,"CC","Cocos (Keeling) Islands","Cocos (Keeling) Islands - CC"]
[null,null,null,null,null,null,null,null,null,null,null,"CO","Colombia","Colombia - CO"]
[null,null,null,null,null,null,null,null,null,null,null,"KM","Comoros","Comoros - KM"]
[null,null,null,null,null,null,null,null,null,null,null,"CG","Congo","Congo - CG"]
[null,null,null,null,null,null,null,null,null,null,null,"CK","Cook Islands","Cook Islands - CK"]
[null,null,null,null,null,null,null,null,null,null,null,"CR","Costa Rica","Costa Rica - CR"]
[null,null,null,null,null,null,null,null,null,null,null,"CI","Cote d Ivoire","Cote d Ivoire - CI"]
[null,null,null,null,null,null,null,null,null,null,null,"HR","Croatia","Croatia - HR"]
[null,null,null,null,null,null,null,null,null,null,null,"CU","Cuba","Cuba - CU"]
[null,null,null,null,null,null,null,null,null,null,null,"CY","Cyprus","Cyprus - CY"]
[null,null,null,null,null,null,null,null,null,null,null,"CZ","Czech Republic","Czech Republic - CZ"]
[null,null,null,null,null,null,null,null,null,null,null,"DK","Denmark","Denmark - DK"]
[null,null,null,null,null,null,null,null,null,null,null,"DJ","Djibouti","Djibouti - DJ"]
[null,null,null,null,null,null,null,null,null,null,null,"DM","Dominica","Dominica - DM"]
[null,null,null,null,null,null,null,null,null,null,null,"DO","Dominican Republic","Dominican Republic - DO"]
[null,null,null,null,null,null,null,null,null,null,null,"TP","East Timor","East Timor - TP"]
[null,null,null,null,null,null,null,null,null,null,null,"EC","Ecuador","Ecuador - EC"]
[null,null,null,null,null,null,null,null,null,null,null,"EG","Egypt","Egypt - EG"]
[null,null,null,null,null,null,null,null,null,null,null,"SV","El Salvador","El Salvador - SV"]
[null,null,null,null,null,null,null,null,null,null,null,"GQ","Equatorial Guinea","Equatorial Guinea - GQ"]
[null,null,null,null,null,null,null,null,null,null,null,"ER","Eritrea","Eritrea - ER"]
[null,null,null,null,null,null,null,null,null,null,null,"EE","Estonia","Estonia - EE"]
[null,null,null,null,null,null,null,null,null,null,null,"ET","Ethiopia","Ethiopia - ET"]
[null,null,null,null,null,null,null,null,null,null,null,"FK","Falkland Islands (Malvinas)","Falkland Islands (Malvinas) - FK"]
[null,null,null,null,null,null,null,null,null,null,null,"FO","Faroe Islands","Faroe Islands - FO"]
[null,null,null,null,null,null,null,null,null,null,null,"FJ","Fiji","Fiji - FJ"]
[null,null,null,null,null,null,null,null,null,null,null,"FI","Finland","Finland - FI"]
[null,null,null,null,null,null,null,null,null,null,null,"FR","France","France - FR"]
[null,null,null,null,null,null,null,null,null,null,null,"FX","France, Metropolitan","France, Metropolitan - FX"]
[null,null,null,null,null,null,null,null,null,null,null,"GF","French Guiana","French Guiana - GF"]
[null,null,null,null,null,null,null,null,null,null,null,"PF","French Polynesia","French Polynesia - PF"]
[null,null,null,null,null,null,null,null,null,null,null,"TF","French Southern Territories","French Southern Territories - TF"]
[null,null,null,null,null,null,null,null,null,null,null,"GA","Gabon","Gabon - GA"]
[null,null,null,null,null,null,null,null,null,null,null,"GM","Gambia","Gambia - GM"]
[null,null,null,null,null,null,null,null,null,null,null,"GE","Georgia","Georgia - GE"]
[null,null,null,null,null,null,null,null,null,null,null,"DE","Germany","Germany - DE"]
[null,null,null,null,null,null,null,null,null,null,null,"GH","Ghana","Ghana - GH"]
[null,null,null,null,null,null,null,null,null,null,null,"GI","Gibraltar","Gibraltar - GI"]
[null,null,null,null,null,null,null,null,null,null,null,"GR","Greece","Greece - GR"]
[null,null,null,null,null,null,null,null,null,null,null,"GL","Greenland","Greenland - GL"]
[null,null,null,null,null,null,null,null,null,null,null,"GD","Grenada","Grenada - GD"]
[null,null,null,null,null,null,null,null,null,null,null,"GP","Guadeloupe","Guadeloupe - GP"]
[null,null,null,null,null,null,null,null,null,null,null,"GU","Guam","Guam - GU"]
[null,null,null,null,null,null,null,null,null,null,null,"GT","Guatemala","Guatemala - GT"]
[null,null,null,null,null,null,null,null,null,null,null,"GN","Guinea","Guinea - GN"]
[null,null,null,null,null,null,null,null,null,null,null,"GW","Guinea-Bissau","Guinea-Bissau - GW"]
[null,null,null,null,null,null,null,null,null,null,null,"GY","Guyana","Guyana - GY"]
[null,null,null,null,null,null,null,null,null,null,null,"HT","Haiti","Haiti - HT"]
[null,null,null,null,null,null,null,null,null,null,null,"HM","Heard Island & McDonald Isl","Heard Island & McDonald Isl - HM"]
[null,null,null,null,null,null,null,null,null,null,null,"VA","Holy See","Holy See - VA"]
[null,null,null,null,null,null,null,null,null,null,null,"HN","Honduras","Honduras - HN"]
[null,null,null,null,null,null,null,null,null,null,null,"HK","Hong Kong","Hong Kong - HK"]
[null,null,null,null,null,null,null,null,null,null,null,"HU","Hungary","Hungary - HU"]
[null,null,null,null,null,null,null,null,null,null,null,"IS","Iceland","Iceland - IS"]
[null,null,null,null,null,null,null,null,null,null,null,"IN","India","India - IN"]
[null,null,null,null,null,null,null,null,null,null,null,"ID","Indonesia","Indonesia - ID"]
[null,null,null,null,null,null,null,null,null,null,null,"IR","Iran","Iran - IR"]
[null,null,null,null,null,null,null,null,null,null,null,"IQ","Iraq","Iraq - IQ"]
[null,null,null,null,null,null,null,null,null,null,null,"IE","Ireland","Ireland - IE"]
[null,null,null,null,null,null,null,null,null,null,null,"IM","Isle of Man","Isle of Man - IM"]
[null,null,null,null,null,null,null,null,null,null,null,"IL","Israel","Israel - IL"]
[null,null,null,null,null,null,null,null,null,null,null,"IT","Italy","Italy - IT"]
[null,null,null,null,null,null,null,null,null,null,null,"JM","Jamaica","Jamaica - JM"]
[null,null,null,null,null,null,null,null,null,null,null,"JP","Japan","Japan - JP"]
[null,null,null,null,null,null,null,null,null,null,null,"JE","Jersey","Jersey - JE"]
[null,null,null,null,null,null,null,null,null,null,null,"JO","Jordan","Jordan - JO"]
[null,null,null,null,null,null,null,null,null,null,null,"KZ","Kazakhstan","Kazakhstan - KZ"]
[null,null,null,null,null,null,null,null,null,null,null,"KE","Kenya","Kenya - KE"]
[null,null,null,null,null,null,null,null,null,null,null,"KI","Kiribati","Kiribati - KI"]
[null,null,null,null,null,null,null,null,null,null,null,"KP","Korea, North","Korea, North - KP"]
[null,null,null,null,null,null,null,null,null,null,null,"KR","Korea, South","Korea, South - KR"]
[null,null,null,null,null,null,null,null,null,null,null,"KW","Kuwait","Kuwait - KW"]
[null,null,null,null,null,null,null,null,null,null,null,"KG","Kyrgyzstan","Kyrgyzstan - KG"]
[null,null,null,null,null,null,null,null,null,null,null,"LA","Lao People's Democratic Republic","Lao People's Democratic Republic - LA"]
[null,null,null,null,null,null,null,null,null,null,null,"LV","Latvia","Latvia - LV"]
[null,null,null,null,null,null,null,null,null,null,null,"LB","Lebanon","Lebanon - LB"]
[null,null,null,null,null,null,null,null,null,null,null,"LS","Lesotho","Lesotho - LS"]
[null,null,null,null,null,null,null,null,null,null,null,"LR","Liberia","Liberia - LR"]
[null,null,null,null,null,null,null,null,null,null,null,"LY","Libyan Arab Jamahiriya","Libyan Arab Jamahiriya - LY"]
[null,null,null,null,null,null,null,null,null,null,null,"LI","Liechtenstein","Liechtenstein - LI"]
[null,null,null,null,null,null,null,null,null,null,null,"LT","Lithuania","Lithuania - LT"]
[null,null,null,null,null,null,null,null,null,null,null,"LU","Luxembourg","Luxembourg - LU"]
[null,null,null,null,null,null,null,null,null,null,null,"MO","Macao Special Administrative Region of the People's Republic of China","Macao Special Administrative Region of the People's Republic of China - MO"]
[null,null,null,null,null,null,null,null,null,null,null,"MK","Macedonia","Macedonia - MK"]
[null,null,null,null,null,null,null,null,null,null,null,"MG","Madagascar","Madagascar - MG"]
[null,null,null,null,null,null,null,null,null,null,null,"MW","Malawi","Malawi - MW"]
[null,null,null,null,null,null,null,null,null,null,null,"MY","Malaysia","Malaysia - MY"]
[null,null,null,null,null,null,null,null,null,null,null,"MV","Maldives","Maldives - MV"]
[null,null,null,null,null,null,null,null,null,null,null,"ML","Mali","Mali - ML"]
[null,null,null,null,null,null,null,null,null,null,null,"MT","Malta","Malta - MT"]
[null,null,null,null,null,null,null,null,null,null,null,"MH","Marshall Islands","Marshall Islands - MH"]
[null,null,null,null,null,null,null,null,null,null,null,"MQ","Martinique","Martinique - MQ"]
[null,null,null,null,null,null,null,null,null,null,null,"MR","Mauritania","Mauritania - MR"]
[null,null,null,null,null,null,null,null,null,null,null,"MU","Mauritius","Mauritius - MU"]
[null,null,null,null,null,null,null,null,null,null,null,"YT","Mayotte","Mayotte - YT"]
[null,null,null,null,null,null,null,null,null,null,null,"MX","Mexico","Mexico - MX"]
[null,null,null,null,null,null,null,null,null,null,null,"FM","Micronesia","Micronesia - FM"]
[null,null,null,null,null,null,null,null,null,null,null,"MC","Monaco","Monaco - MC"]
[null,null,null,null,null,null,null,null,null,null,null,"MN","Mongolia","Mongolia - MN"]
[null,null,null,null,null,null,null,null,null,null,null,"MS","Montserrat","Montserrat - MS"]
[null,null,null,null,null,null,null,null,null,null,null,"MA","Morocco","Morocco - MA"]
[null,null,null,null,null,null,null,null,null,null,null,"MZ","Mozambique","Mozambique - MZ"]
[null,null,null,null,null,null,null,null,null,null,null,"MM","Myanmar","Myanmar - MM"]
[null,null,null,null,null,null,null,null,null,null,null,"NA","Namibia","Namibia - NA"]
[null,null,null,null,null,null,null,null,null,null,null,"NR","Nauru","Nauru - NR"]
[null,null,null,null,null,null,null,null,null,null,null,"NP","Nepal","Nepal - NP"]
[null,null,null,null,null,null,null,null,null,null,null,"NL","Netherlands","Netherlands - NL"]
[null,null,null,null,null,null,null,null,null,null,null,"AN","Netherlands Antilles","Netherlands Antilles - AN"]
[null,null,null,null,null,null,null,null,null,null,null,"NC","New Caledonia","New Caledonia - NC"]
[null,null,null,null,null,null,null,null,null,null,null,"NZ","New Zealand","New Zealand - NZ"]
[null,null,null,null,null,null,null,null,null,null,null,"NI","Nicaragua","Nicaragua - NI"]
[null,null,null,null,null,null,null,null,null,null,null,"NE","Niger","Niger - NE"]
[null,null,null,null,null,null,null,null,null,null,null,"NG","Nigeria","Nigeria - NG"]
[null,null,null,null,null,null,null,null,null,null,null,"NU","Niue","Niue - NU"]
[null,null,null,null,null,null,null,null,null,null,null,"NF","Norfolk Island","Norfolk Island - NF"]
[null,null,null,null,null,null,null,null,null,null,null,"MP","Northern Mariana Islands","Northern Mariana Islands - MP"]
[null,null,null,null,null,null,null,null,null,null,null,"NO","Norway","Norway - NO"]
[null,null,null,null,null,null,null,null,null,null,null,"OM","Oman","Oman - OM"]
[null,null,null,null,null,null,null,null,null,null,null,"PK","Pakistan","Pakistan - PK"]
[null,null,null,null,null,null,null,null,null,null,null,"PW","Palau","Palau - PW"]
[null,null,null,null,null,null,null,null,null,null,null,"PA","Panama","Panama - PA"]
[null,null,null,null,null,null,null,null,null,null,null,"PG","Papua New Guinea","Papua New Guinea - PG"]
[null,null,null,null,null,null,null,null,null,null,null,"PY","Paraguay","Paraguay - PY"]
[null,null,null,null,null,null,null,null,null,null,null,"PE","Peru","Peru - PE"]
[null,null,null,null,null,null,null,null,null,null,null,"PH","Philippines","Philippines - PH"]
[null,null,null,null,null,null,null,null,null,null,null,"PN","Pitcairn","Pitcairn - PN"]
[null,null,null,null,null,null,null,null,null,null,null,"PL","Poland","Poland - PL"]
[null,null,null,null,null,null,null,null,null,null,null,"PT","Portugal","Portugal - PT"]
[null,null,null,null,null,null,null,null,null,null,null,"PR","Puerto Rico","Puerto Rico - PR"]
[null,null,null,null,null,null,null,null,null,null,null,"QA","Qatar","Qatar - QA"]
[null,null,null,null,null,null,null,null,null,null,null,"CD","Republic of Congo","Republic of Congo - CD"]
[null,null,null,null,null,null,null,null,null,null,null,"MD","Republic of Moldova","Republic of Moldova - MD"]
[null,null,null,null,null,null,null,null,null,null,null,"RE","Reunion","Reunion - RE"]
[null,null,null,null,null,null,null,null,null,null,null,"RO","Romania","Romania - RO"]
[null,null,null,null,null,null,null,null,null,null,null,"RU","Russian Federation","Russian Federation - RU"]
[null,null,null,null,null,null,null,null,null,null,null,"RW","Rwanda","Rwanda - RW"]
[null,null,null,null,null,null,null,null,null,null,null,"SH","Saint Helena","Saint Helena - SH"]
[null,null,null,null,null,null,null,null,null,null,null,"KN","Saint Kitts And Nevis","Saint Kitts And Nevis - KN"]
[null,null,null,null,null,null,null,null,null,null,null,"LC","Saint Lucia","Saint Lucia - LC"]
[null,null,null,null,null,null,null,null,null,null,null,"PM","Saint Pierre And Miquelon","Saint Pierre And Miquelon - PM"]
[null,null,null,null,null,null,null,null,null,null,null,"VC","Saint Vincent & the Grenadines","Saint Vincent & the Grenadines - VC"]
[null,null,null,null,null,null,null,null,null,null,null,"WS","Samoa","Samoa - WS"]
[null,null,null,null,null,null,null,null,null,null,null,"SM","San Marino","San Marino - SM"]
[null,null,null,null,null,null,null,null,null,null,null,"ST","Sao Tome and Principe","Sao Tome and Principe - ST"]
[null,null,null,null,null,null,null,null,null,null,null,"SA","Saudi Arabia","Saudi Arabia - SA"]
[null,null,null,null,null,null,null,null,null,null,null,"SN","Senegal","Senegal - SN"]
[null,null,null,null,null,null,null,null,null,null,null,"CS","Serbia and Montenegro","Serbia and Montenegro - CS"]
[null,null,null,null,null,null,null,null,null,null,null,"SC","Seychelles","Seychelles - SC"]
[null,null,null,null,null,null,null,null,null,null,null,"SL","Sierra Leone","Sierra Leone - SL"]
[null,null,null,null,null,null,null,null,null,null,null,"SG","Singapore","Singapore - SG"]
[null,null,null,null,null,null,null,null,null,null,null,"SK","Slovakia","Slovakia - SK"]
[null,null,null,null,null,null,null,null,null,null,null,"SI","Slovenia","Slovenia - SI"]
[null,null,null,null,null,null,null,null,null,null,null,"SB","Solomon Islands","Solomon Islands - SB"]
[null,null,null,null,null,null,null,null,null,null,null,"SO","Somalia","Somalia - SO"]
[null,null,null,null,null,null,null,null,null,null,null,"ZA","South Africa","South Africa - ZA"]
[null,null,null,null,null,null,null,null,null,null,null,"GS","South Georgia/So Sandwich Isl","South Georgia/So Sandwich Isl - GS"]
[null,null,null,null,null,null,null,null,null,null,null,"ES","Spain","Spain - ES"]
[null,null,null,null,null,null,null,null,null,null,null,"LK","Sri Lanka","Sri Lanka - LK"]
[null,null,null,null,null,null,null,null,null,null,null,"PS","State of Palestine","State of Palestine - PS"]
[null,null,null,null,null,null,null,null,null,null,null,"SD","Sudan","Sudan - SD"]
[null,null,null,null,null,null,null,null,null,null,null,"SR","Suriname","Suriname - SR"]
[null,null,null,null,null,null,null,null,null,null,null,"SJ","Svalbard and Jan Mayen","Svalbard and Jan Mayen - SJ"]
[null,null,null,null,null,null,null,null,null,null,null,"SZ","Swaziland","Swaziland - SZ"]
[null,null,null,null,null,null,null,null,null,null,null,"SE","Sweden","Sweden - SE"]
[null,null,null,null,null,null,null,null,null,null,null,"CH","Switzerland","Switzerland - CH"]
[null,null,null,null,null,null,null,null,null,null,null,"SY","Syrian Arab Republic","Syrian Arab Republic - SY"]
[null,null,null,null,null,null,null,null,null,null,null,"TW","Taiwan","Taiwan - TW"]
[null,null,null,null,null,null,null,null,null,null,null,"TJ","Tajikistan","Tajikistan - TJ"]
[null,null,null,null,null,null,null,null,null,null,null,"TZ","Tanzania","Tanzania - TZ"]
[null,null,null,null,null,null,null,null,null,null,null,"TH","Thailand","Thailand - TH"]
[null,null,null,null,null,null,null,null,null,null,null,"TL","Timor-Leste","Timor-Leste - TL"]
[null,null,null,null,null,null,null,null,null,null,null,"TG","Togo","Togo - TG"]
[null,null,null,null,null,null,null,null,null,null,null,"TK","Tokelau","Tokelau - TK"]
[null,null,null,null,null,null,null,null,null,null,null,"TO","Tonga","Tonga - TO"]
[null,null,null,null,null,null,null,null,null,null,null,"TT","Trinidad and Tobago","Trinidad and Tobago - TT"]
[null,null,null,null,null,null,null,null,null,null,null,"TN","Tunisia","Tunisia - TN"]
[null,null,null,null,null,null,null,null,null,null,null,"TR","Turkey","Turkey - TR"]
[null,null,null,null,null,null,null,null,null,null,null,"TM","Turkmenistan","Turkmenistan - TM"]
[null,null,null,null,null,null,null,null,null,null,null,"TC","Turks and Caicos Islands","Turks and Caicos Islands - TC"]
[null,null,null,null,null,null,null,null,null,null,null,"TV","Tuvalu","Tuvalu - TV"]
[null,null,null,null,null,null,null,null,null,null,null,"UM","US Minor Outlying Islands","US Minor Outlying Islands - UM"]
[null,null,null,null,null,null,null,null,null,null,null,"UG","Uganda","Uganda - UG"]
[null,null,null,null,null,null,null,null,null,null,null,"UA","Ukraine","Ukraine - UA"]
[null,null,null,null,null,null,null,null,null,null,null,"AE","United Arab Emirates","United Arab Emirates - AE"]
[null,null,null,null,null,null,null,null,null,null,null,"GB","United Kingdom","United Kingdom - GB"]
[null,null,null,null,null,null,null,null,null,null,null,"US","United States","United States - US"]
[null,null,null,null,null,null,null,null,null,null,null,"UY","Uruguay","Uruguay - UY"]
[null,null,null,null,null,null,null,null,null,null,null,"UZ","Uzbekistan","Uzbekistan - UZ"]
[null,null,null,null,null,null,null,null,null,null,null,"VU","Vanuatu","Vanuatu - VU"]
[null,null,null,null,null,null,null,null,null,null,null,"VE","Venezuela","Venezuela - VE"]
[null,null,null,null,null,null,null,null,null,null,null,"VN","Viet Nam","Viet Nam - VN"]
[null,null,null,null,null,null,null,null,null,null,null,"VG","Virgin Islands (British)","Virgin Islands (British) - VG"]
[null,null,null,null,null,null,null,null,null,null,null,"VI","Virgin Islands (U.S.)","Virgin Islands (U.S.) - VI"]
[null,null,null,null,null,null,null,null,null,null,null,"WF","Wallis and Futuna Islands","Wallis and Futuna Islands - WF"]
[null,null,null,null,null,null,null,null,null,null,null,"EH","Western Sahara","Western Sahara - EH"]
[null,null,null,null,null,null,null,null,null,null,null,"YE","Yemen","Yemen - YE"]
[null,null,null,null,null,null,null,null,null,null,null,"YU","Yugoslavia","Yugoslavia - YU"]
[null,null,null,null,null,null,null,null,null,null,null,"ZR","Zaire","Zaire - ZR"]
[null,null,null,null,null,null,null,null,null,null,null,"ZM","Zambia","Zambia - ZM"]
[null,null,null,null,null,null,null,null,null,null,null,"ZW","Zimbabwe","Zimbabwe - ZW"]
[null,null,null,null,null,null,null,null,null,null,null,"AX","Åland Islands","Åland Islands - AX"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Version=Supplier-wpspec-3.0,ArtAndCraftCategory,ArtAndCraft","The top 6 rows are for Walmart use only. Do not modify or delete the top 6 rows."]
[null,"Validate","Basic",null,null,null,null,null,null,null,null,null,null,"Images",null,"Offer",null,null,null,null,"Logistics",null,null,"Owned Logistics",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Discoverability",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dimensions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item Variants",null,null,null,null,"Compliance",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Additional Category Attributes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nice to Have"]
[null,null,null,null,null,"Add More",null,"Add More",null,null,null,null,null,null,"Add More",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Add More","Add More","Add More","Add More",null,null,null,null,null,null,null,null,null,"Add More",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Add More",null,null,"Add More",null,null,null,null,"Add More",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Add More","Add More","Add More",null,null,"Add More","Add More",null,null,null,null,null,"Add More","Add More",null,null,"Add More",null,null,null,null,null,null,null,null,null,null,"Add More","Add More",null,null,null,"Add More","Add More"]
[null,null,null,null,"Product Identifiers (productIdentifiers)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vendor Pack Depth (vendorPackDepth)",null,"Vendor Pack Width (vendorPackWidth)",null,"Vendor Pack Height (vendorPackHeight)",null,"Vendor Pack Weight (vendorPackWeight)",null,null,null,"Warehouse Pack Depth (warehousePackDepth)",null,"Warehouse Pack Width (warehousePackWidth)",null,"Warehouse Pack Height (warehousePackHeight)",null,"Warehouse Pack Weight (warehousePackWeight)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Age Range (ageRange)",null,null,"Assembled Product Length (assembledProductLength)",null,"Assembled Product Width (assembledProductWidth)",null,"Assembled Product Height (assembledProductHeight)",null,"Assembled Product Weight (assembledProductWeight)",null,null,"Shipping Dimensions Depth (ShippingDimensionsDepth)",null,"Shipping Dimensions Width (ShippingDimensionsWidth)",null,"Shipping Dimensions Height (ShippingDimensionsHeight)",null,"Shipping Weight (ShippingWeight)",null,null,null,null,null,"Swatch Images (swatchImages)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Shelf Life (shelfLife)",null,null,null,null,null,"State Restrictions (stateRestrictions)",null,null,null,null,null,"Fabric Content (fabricContent)",null,null,null,"Diameter (diameter)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chain Length (chainLength)"]
[null,null,"SKU","Product Name","Product ID Type","Product ID","Short Description","Key Features","Package Count","Brand","Manufacturer","Manufacturer Part Number","Model Number","Main Image URL","Additional Image URL","MSRP","Price","Minimum Advertised Price","Site Start Date","Site End Date","Unit Cost","Vendor Contract Number","Channel Type","Is Direct Import","RPPC","Vendor Pack GTIN","Vendor Pack Quantity","Measure","Unit","Measure","Unit","Measure","Unit","Measure","Unit","Warehouse Pack GTIN","Warehouse Pack Quantity","Measure","Unit","Measure","Unit","Measure","Unit","Measure","Unit","Color","Color Category","Material","Pattern","Count","Size","Metal","Plating","Finish","Form","Shape","Scent","Gender","Age Group","Range Minimum","Range Maximum","Art Paint Type","Measure","Unit","Measure","Unit","Measure","Unit","Measure","Unit","Number of Boxes for Product","Measure","Unit","Measure","Unit","Measure","Unit","Measure","Unit","Ships in Original Packaging","Variant Group ID","Variant Attribute Names","Is Primary Variant","Swatch Variant Attribute","Swatch Image URL","Is Private Label","Is Exclusive Brand","Is Prop 65 Warning Required","Prop 65 Warning Text","Small Parts Warning Code","Is Intended for Human Consumption","Contains Batteries","Contained Battery Type","Has Ingredient List","Ingredient List Image","Is Aerosol","Is Chemical","Composite Wood Certification Code","Has Fuel Container","Has Expiration","Measure","Unit","Has Warranty","Warranty URL","Warranty Text","Has State Restrictions","States","ZIP Codes","State Restrictions Reason","Country of Origin - Assembly / Manufacture","Country of Origin - Components / Ingredients","Factory ID","Fabric Material Name","Fabric Material Percentage","Fabric Care Instructions","Capacity","Measure","Unit","Cultural Style","Subject","Theme","Occasion","Is Antique","Is Collectible","Character","Is Powered","Power Type","Is Bulk","Is Handmade","Is Self-Adhesive","Is Antitarnish","Is Reusable","Is Refillable","Is Disposable","Is Recyclable","Recommended Uses","Recommended Surfaces","Measure","Unit","Skill Level","Brand License","Additional Features","Keywords"]
[null,null,"sku","productName","productIdType","productId","shortDescription","keyFeatures","unitsPerConsumerUnit","brand","manufacturer","manufacturerPartNumber","modelNumber","mainImageUrl","productSecondaryImageURL","msrp","price","MinimumAdvertisedPrice","StartDate","EndDate","unitCost","vendorContractNumber","channelType","isDirectImport","rppc","vendorPackGtin","vendorPackQuantity","measure","unit","measure","unit","measure","unit","measure","unit","warehousePackGtin","warehousePackQuantity","measure","unit","measure","unit","measure","unit","measure","unit","color","colorCategory","material","pattern","count","size","metal","plating","finish","form","shape","scent","gender","ageGroup","RangeMinimum","RangeMaximum","artPaintType","measure","unit","measure","unit","measure","unit","measure","unit","numberOfBoxesForProduct","measure","unit","measure","unit","measure","unit","measure","unit","shipsInOriginalPackaging","variantGroupId","variantAttributeNames","isPrimaryVariant","swatchVariantAttribute","swatchImageUrl","isPrivateLabelOrUnbranded","exclusiveBrandsIndicator","isProp65WarningRequired","prop65WarningText","smallPartsWarnings","isIntendedForHumanConsumption","hasBatteries","batteryTechnologyType","hasIngredientList","ingredientListImage","isAerosol","isChemical","compositeWoodCertificationCode","hasFuelContainer","hasExpiration","measure","unit","hasWarranty","warrantyURL","warrantyText","hasStateRestrictions","states","zipCodes","stateRestrictionsText","countryOfOriginAssembly","countryOfOriginComponents","factoryId","materialName","materialPercentage","fabricCareInstructions","capacity","measure","unit","culturalStyle","subject","theme","occasion","isAntique","isCollectible","character","isPowered","powerType","isBulk","isHandmade","isSelfAdhesive","isAntitarnish","isReusable","isRefillable","isDisposable","isRecyclable","recommendedUses","recommendedSurfaces","measure","unit","skillLevel","globalBrandLicense","features","keywords"]
[null,null,"B","B","B","B","B",null,null,"B","B",null,null,"B",null,null,"B",null,null,null,"B","B","B",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"B",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"B","B","B",null,"B","B","B",null,"B",null,"B","B","B","B",null,null,null,"B",null,null,"B",null,null,null,"B","B"]

{"sheet":"Offer","index":3,"n_rows":6,"n_cols":40,"rows_kept":6,"cut":false,"hidden":false,"merged":[[2,1,3,1],[2,4,3,4]]}
[null,null,"Version=offer-spec-3.0","The top 4 rows are for Walmart use only. Do not modify or delete the top 4 rows.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-11-21T17:59:44"]
[null,"Hidden->","B","B"]
[null,"Validate","Price",null,"Promotions Status","Promotion 1",null,null,null,null,"Promotion 2",null,null,null,null,"Promotion 3",null,null,null,null,"Promotion 4",null,null,null,null,"Promotion 5",null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-10-24T15:47:35"]
[null,null,"SKU *","Price *",null,"Promo Price","Promo Type","Promo Placement","Promo Start Date","Promo End Date","Promo Price","Promo Type","Promo Placement","Promo Start Date","Promo End Date","Promo Price","Promo Type","Promo Placement","Promo Start Date","Promo End Date","Promo Price","Promo Type","Promo Placement","Promo Start Date","Promo End Date","Promo Price","Promo Type","Promo Placement","Promo Start Date","Promo End Date",null,null,null,null,null,null,null,null,null,"2016-10-24T15:48:29"]
[null,null,"AAR2312965",12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-03-03T18:21:42"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-11-23T19:42:08"]