Jump to content

CSV import - wrong prices when using formula


Recommended Posts

Hi everyone,

I wanted to ask if anyone has the same problem I have.

I am experimenting with csv import and I noticed that if, in my excel file, I use a formula to calculate the price, ie something like =ARROTONDA.ECCESSO(A4;1), the price shown on the shop is higher by 0.01 Euro (ie. 8.81 instead of 8.80)

if I just write 8.80 in that field, it works fine.

The weirdest thing is that it happens randomly... ie, some of the products, even if their price is calculated via a formula, are shown correctly.

There are no differences in the other data in the csv file (I'm only importing 8-9 products... so they're basically a cut and paste of each other).

 

does this happens to other people too?

is it a known problem?

is there a solution?

 

PS

attached you find the csv file

prodotti.zip

Link to comment
Share on other sites

×
×
  • Create New...