Jump to content

unit price calculation / display error after csv import


Recommended Posts

Dear community,

 

I am facing an error (?) I could not find any solution in this forum / the web.

 

For manually entered products PS shows the correct unit price (I enterd the price for one pice without VAT => so in Germany it shows selling price 119€ incl. VAT and 119€ unit price - if one pice).

 

But, for products imported via csv this does not work. The displayed unit price is calculatated somehow differently (always less than it should be). If I edit the product manually in PS in the productlist the unit price is correct, when clicking edit under tab "prices" the unit price is another (see attached picture).

 

Checking the database it seems that the unit_price_ratio is calcualted wrongly f you import products via csv.

From what I understand PS is calculation the unit_price_ratio by deviding the total price w/o VAT by the entered / imported unit price w/o VAT. The result should equal the units but it does not (I did not see any "full" numberes in the PS database).

 

So my guess is that PS is calculating the total price w/o VAT using a wrong VAT what leads to wrong unit_price_ratios.

 

Hope anybody has an idea what to do

 

Thanks

 

Marcus

CSV input error.pdf

Link to comment
Share on other sites

  • 1 year later...
×
×
  • Create New...