What to do if I get an error message after uploading the price spreadsheet? What to do if I get an error message after uploading the price spreadsheet?

What to do if I get an error message after uploading the price spreadsheet?

Diego Diego

mceclip0.png

Some of the price spreadsheet errors occur because:

  • The file was incorrectly saved.
  • No format update was performed for the numbers.
  • SKU is not correct.

Please note that when you open the file on the computer, the Excel program (depending on each computer) displays very large values in the " SKU" columns in scientific notation.

mceclip1.png

Also, notice that it replaces the correct value with zeros, which is why the system does not find it.

If this has happens, here is a tutorial on how to correctly save the price spreadsheet.

A) Download the file again.

The current file can no longer be used since Excel replaced the correct values.

mceclip2.png

B) Go to the SKU column and select it.

mceclip3.png

C) Right-click and then select "Cell format".

mceclip5.png

D) Select the "Number" option and "0" for the decimals.

mceclip6.png

E) Press "Accept".

Notice that the values are now in the correct format.

mceclip7.png

F) Go to the “Date of Validity” column.

mceclip8.png

G) Right-click and select “Cell format”.

mceclip9.png

H) Select the "Date" option and set the "year month day" format.

mceclip11.png

I) Click on “Accept”. 

Check whether the dates are now shown in the correct format.

J) Save the file and upload it again.

We hope this was helpful.

Add comment

Please sign in to leave a comment.