Sometimes, you might encounter corrupted UPCs when you export a CSV file, open a CSV as an XLS doc, or happen to see the UPCs not listing in full.
Below are the steps you take to fix those corrupted UPCs. This is important as Wiser needs the UPC in the correct format—not scientific notation in the application, as we use UPCs to match your products.
This is what typically corrupted UPCs look like in scientific notation format:
In order to fix this, follow these steps:
Step 1
Highlight the UPC column
Step 2
Click Format-> Cells -> Number
Step 3
Switch the Decimal places from 2 to 0
Voila! Your UPC's are no longer corrupt.