Some of the stock spreadsheet errors occur because:
- The file was incorrectly saved.
- No format update was performed for the numbers.
- SKU is not correct.
Note that when you open the file on the computer, Excel (depending on each computer) may display very large values in the "SKU" columns in scientific notation.
Notice that it replaces the correct value with zeros, which is why the system does not find it.
If this has happened to you, here is a guide on how to correctly save the stock spreadsheet.
A) Download the file again.
The current file can no longer be used since Excel replaced the correct values.
B) Go to the SKU column and select it.
C) Right-click and select “Cell format”.
D) Select the “Number” option “0” for the decimals.
E) Press “Accept".
Si te das cuenta los valores ahora si estarán en el formato correcto.
E) Do the same in the UPC column.
F) Edit the file, save it and upload it.
We hope this was helpful!