import Sales Orders, error: "value must be numeric in property discountper

[Former Member]

When i import Sales Orders, the system gives me this error: "value must be numeric in property discountpercent".

where is the problem?

[former_member583013 · Accepted solution]

Hello Lorenzo,

If you carefully read the Error message, it say value must be numeric in property discountpercent

It pertains to the discount percent column and the value you have filled in it.

Please make sure you have only numeric values here. Also make sure that any numeric value is not accidentally saved as charecter type ( you can notice a green triange arrow at the left top corner of each column)

Suda

[Former Member]

Hi,

If you are using comma separated files to import (.csv), make sure there are no commas in any of the fields in your template. This error happens usually when there are some commas left in the template and so in the .csv file the columns slip by one.

Hope it makes sense.

Regards,

Nat