Back office modifications needed

[fabiensen]

Hi

 

we need an ad hoc work on a already customized Prestashop 1.6.0.6 installation. 

 

It is about back office orders and consequent json summary (got from AdminCarts) and receipts. 

 

The starting point: a customer of ours requests a very particular receipt, which we could do for the e-commerce from end side.

 

Now, the math behind the back office seems to be not the same.

 

First of all, the tax included prices in the back office aren’t always the same as in the front office, when adding a new product. This happens when there are discounts too.

 

In addition, although PS calculates tax included prices starting from tax excluded ones, our customers wants that the math starts from tax included prices.

 

e.g. we have an item with price 8.90€ and it is discounted by 5%. It should be 8.455€ but you will find 8.46€ in the shop, because it is rounded to 2 decimals.

Now, if you consider that 8.90 is tax included we have in the DB a tax excluded of 7,295082.

One should expect that (VAT is 22%) the discounted tax excluded price is 7,295082 * 0,95 = 6,9303279. Our customers want that this price is 8,46 (tax included discounted) / 1,22 = 6,9344262.

Now, if one takes 5 units of this item, discounted by 5%, in the receipt (already customized and working, but only for the e-commerce) the user will see:

 

original tax incl price: 8.90

(same as in e-commerce)

discount: 5%

final price tax incl: 8.46

(same as in e-commerce)

vat: 22%

final tax excl price: 6.93

(rounded but actually is 6,9344262)

qty: 5

total tax excl: 34.67

(that comes from the rounded 6,9344262 * 5)

total tax incl. 42.30

 

So, basically we need to modify the back office in order to have this situation with prices. In the back office, for each product one can change both the discount and the tax included price (but this is already implemented).

We offer all the needed support in order to understand properly some modification we already applied.

 

Regards

Fabio Ricci