New Walmart Workflow using Match and Spec File
- Open Dash2 > make sure WMT SKUs are created and linked to master design page parent
- Check Images, bullets, title, etc. in Dash2 online description (If there are no images, download from AMZ/SC and upload to Dash2)
- Export Walmart Main file and open it
- Open "UPC Check file" in excel templates (saved in your excel templates)
- Copy the UPCs from the "Walmart Main" file and paste in "UPC Check file" in the "Product Id" column
- Put in SKUs in the SKU column of the "UPC Check file" (ex: 0N1533SWtest1, 0N1533SWtest2, etc.) > Copy the rest of the information down (tax code, price, etc.) > save as "excel macro enabled workbook (.xlsm)" and upload to Walmart
- Monitor feed ID to see which UPCs are valid to use (if any are invalid, get a UPC from Dash2 and reupload the "UPC Check file" with new SKU)
- Once you have valid UPCs, open "Walmart Listing Template" from personal excel templates > copy data from "Walmart Main File" (row 7 down) > paste in cell A7 of the "Walmart Listing Template" file in excel
- Check the file (Common issues listed below)
- "ProductIdUpdate" and "SkuUpdate" must be blank for every row
- "colorCategory" - "Multicolor" is NOT a valid value. Select "Multi-color" from dropdown
- 'clothingSizeGroup' - "Boy"/"Girl" are NOT valid values. Select "Boys"/"Girls" from dropdown
- 'variantAttributeNames' and 'swatchVariantAttribute' are case sensitive "Color" is NOT valid. Select "color" from the dropdown
- 'swatchImageUrl' and 'swatchImageUrl2' - if empty, paste the main image link for all the SKUs
- If all field are validated, save as "excel macro enabled workbook (.xlsm)" and upload to Walmart https://seller.walmart.com/items-and-inventory/add-items/full-item-setup