Why different output of column order_full_price?

Start
Prev
1
Next
End

Lumiga
Topic Author
Away

Posts: 585
Thank you received: 23
Hikaserial Subscription Hikashop Multisite

3 years 6 months ago #332372

Hi Support,

When we export order and we open the file in Excel and we look al the column order_full_price we don't see consistent input.

For example:

Line 1: We have to change the . (point) to a , (comma)
Line 2: We have to divide the cell by 100000 (hundred thousand)
Line 3: we have to divide the cell by 10000 (ten thousand)

Why? this way we cannot quickly add up because we have to manually check all orders first.

I hope you have a solution for this.

Kind regards,
Lumiga

Kind regards,
Lumiga

Attachments:

Last edit: 3 years 6 months ago by Lumiga.

Please Log in or Create an account to join the conversation.

nicolas
Away

Posts: 82867
Thank you received: 13374
MODERATOR

3 years 6 months ago #332386

Hi,

That's because of how your software interpret the number with a dot. Instead of considering it as a decimal separator it considers it as a thousand separator and thus it gets messed up.
Change the "decimal separator" setting of the HikaShop configuration to comma instead of dot and it should help when you export new CSV files and open them with your software.
Alternatively, you can configure your software to use the correct separators when you open the CSV file with it. For example for excel, you need to use the "CSV import" tool ( www.hesa.ac.uk/support/user-guides/import-csv ) instead of just double clicking on the file. If you double click on the file, it just use the default presets of your locale (based on your Excel version, and language, it can vary ).

The following user(s) said Thank You: Lumiga

Please Log in or Create an account to join the conversation.