nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Error -25: Invalid amount

donna-r

Hi there!
I am trying to do a sales import and keep getting 'Error -25: Invalid amount'.
I have exported an example of what I need and then mimicked this to import but still get the error.
Import file -

Error message

What am I doing wrong? What is the error telling me?
Thank you

Find more posts tagged with

Accepted answers

Mike_James

Hi @donna-r , in your Excel screenshot I don't see an Amount column? It should appear after Rate.

All comments

donna-r

Thanks Mike, I didn't realise, adding this column worked a treat!! Thanks again

Mike_James

Hi @donna-r , in your Excel screenshot I don't see an Amount column? It should appear after Rate.

donna-r

Thanks Earl!
I had read other posts abt this error and have done everything advised yet am still having the issue.
I submitted a support request at the same time I posted my enquiry here, do you know how long it will take to get a response please?

Earl_HD

Hi @donna-r,

Thanks for the screenshot, super helpful. This occurs because Microsoft Excel adds formatting when saving to text-based formats. When you export a worksheet as Tab Delimited or CSV, Excel automatically wraps any value that contains a comma in double quotes. This is expected behavior and can affect numeric fields that use commas as thousands separators.

There are multiple ways to achieve this, ideally just change the column format in Microsoft Excel, and save the file and import again. If you're having issues doing this, make sure to reach out to our support team directly. You can reach them on Live Chat via our virtual assistant, MOCA or by submitting a support case via MyAccount.

Regards,
Earl