nordsecurity Posted April 26, 2011 Share Posted April 26, 2011 Hi, I'm quite new to prestashop but after some week of exploration we finally made it to migrate from our solution to a prestashop site for our B2B activity. When we were about to launch the portal we noticed that Prestashop is displaying very strange pricing in order details etc.We are in a classical business model where all prices must be shown VAT excluded and when you order depending on the country of delivery it adds VAT etc. We have no probem in the final result of Prestashop order details sent to reseller but for some reason ?! in the details of the order and in the email confirmation we receive Prestashop show a product Unit Price that is our Product Unit Price with deduction of VAT! instead of just showing our the same unit price wthout VAT that appears 2 rows beow. I've attached a screenshot of the display when Prestashop shows our VAT exlcuded unit price - VAT ?! I thought it was corrected on latest 1.4.1 version so I installed one parallell shop but same issue there. Althouhg the final result sent to buyers is OK, it is not correct to show these prices , it will generate a lot of sales questions etc If someone has a clue of why and where the formula is wrong when displaying this error in unit price, we would appreciate to be able to launch our site. Link to comment Share on other sites More sharing options...
Univ Posted April 27, 2011 Share Posted April 27, 2011 Here too having the same issue. I can see the unit price on the order details applied wrong, as the group reduction has been applied twice. I checked in the order detail database and found the product price been stored ( base price - group reduction). I am not sure if that's the case that suppose to be. We need someone who can find a deferent way in order to resolve this issue. This been tested on items with attribute and without both cases have the same error. I tried to omit the group_reduction not to be stored in order_detail with no success, we really need a fix to that. Link to comment Share on other sites More sharing options...
nordsecurity Posted April 27, 2011 Author Share Posted April 27, 2011 I suppose that everybody that is using Prestashop B2B must have these problems cause we have also been forced to change our way to handle channel discounts because of the instability in specifying group discounts for each product category. We have around 20 different product/service categories that need for channel to have different discounts.If we create the new discount policy , immediatly after it wll be applied but if you get back some hours later, Prestashop does not apply the special discount anymore, it goes back to the "global" group discount.Have you also experienced this problem/bug ? For an e-commerce solution I think we all can agree that if pricing and discounts are not stable......well it can be the best and fastest solution in the world but still unusuable. I sincerly hope someone can help us out with these problems. This is something we should not fix by buying another model , it is something natively for B2B use that is probably in the core of Prestashop. Link to comment Share on other sites More sharing options...
Univ Posted April 27, 2011 Share Posted April 27, 2011 I am only using group discount, for wholesale purpose set for 4 different type of customers.using ps version 1.4017, and most products have attribute and prices impact. Tested and found so far 2 issues, one I consider minor and the other major. 1st issue occur at the product page viewing items with combination, the prices shown are the base price+the impact increase. but when you add to the cart it adds the correct price (group reduction calculated ), checking out and email notification goes ok. i see the calculation looking ok.2nd issue which I consider major, is as you described in your first topic, when you click on order details it will show the wrong unit prices . ( the already discounted unit price - the group reduction ).It look to me that ps is not storing the correct base unit price in the order_detail table. and in this table I see the group_reduction % is been stored, now when you click on order detail ps is pulling those 2 fields and doing the calculation.and since the base unit_price is wrong, then the calculation goes wrong.I saw this thread and applied some of what suggested but it didn't work. the fix described is for earlier version I guess.you could check it yourself, you might find something that could help us.http://www.prestashop.com/forums/viewthread/89347/I see a member called Rocky is good at that, maybe he could step in and guide us to fix this issue. Link to comment Share on other sites More sharing options...
lenki Posted June 1, 2011 Share Posted June 1, 2011 Hi,has anybody managed to solve this please? I have just discovered this issue today and consider it to be quite a trouble. Any help to fix this would be welcome. Thanx. Link to comment Share on other sites More sharing options...
Recommended Posts