Missing Leading Zeros When Mapping SKUs
If you're missing leading zeros when mapping SKUs, this is often related to how the file is formatted using Excel.
To correct this issue, please refer to:
Also, to confirm SKUs are correct in the mapping file, we would recommend double checking it using a text editor, such as Notepad (Windows) or Textedit (OSX).
When you upload the file on the vendor's SKU Mapping page, the Preflight check also shows the first rows of the file, so you can see whether the zeros are still there before you click Map Basic SKUs.
Product SKUs must match your store exactly. If a SKU lost its leading zeros, the job log shows a line like "Product 12345 not found in site. Skipping..." for it.