export import article

  • Posts: 48
  • Thank you received: 0
12 years 1 month ago #43626

File Attachment:

File Name: hikashopex...3-18.csv
File Size:3 KB

I did put this question also in general ..... But i thought it would be better to put it in here.
Hello,

When i do an export of the articles, i see a column price_value. I have everything in euro.
In the backend of an article i did put the price of 4, in the export i see 400.000 , am i mising something. Whem i look at the article it is 4 euro.

And when i try an import and change 400.000 to 600.000 the price of that article is 600 euro, it should be 6 euro.

With regards,

Guido

Attachments:

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

  • Posts: 81563
  • Thank you received: 13071
  • MODERATOR
12 years 1 month ago #43628

I opened your CSV file on my end and the price is 4 not 400. It must come from a problem with your CSV editor.
I'm using libreoffice's calc on my end and the price is fine.

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

  • Posts: 48
  • Thank you received: 0
12 years 1 month ago #43630




Nicolas,

You're right.
I attach both files, one with librecalc and one with excel.

Strange that they behave different, i will use librecalc for the export and import from now.

With regards,

Guido

Attachments:
Last edit: 12 years 1 month ago by guido.

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

  • Posts: 81563
  • Thank you received: 13071
  • MODERATOR
12 years 1 month ago #43633

That's strange as we also tested it with excel and other users are using excel too.
Not sure why though but it if works with calc it must be something coming from excel.

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

Time to create page: 0.069 seconds
Powered by Kunena Forum