backoffice order total showing wrong price, invoice showing correct price

[iwithorg]

Greetings,

 

We have a shop at botigavirtual.xarxaconsum.net where we've seen differences between two clients' orders' prices. Here I attach two screenshots showing their invoice and their backoffice order total.

 

As you can see, the order total is greater than their invoice total, showing confusing numbers on the order listing.

 

- Shipping costs are always free, taxes are disabled.

- We have the product properties extension installed to enable buying by weight, and we had to manually adapt the theme to work with it. 

- clients use the cash on delivery module to pay

- we also have a custom field module to assign some info to each client, and it gives an error when showing both clients' order on the backoffice order listing. One of these clients has two orders, one with this post's issue, and another without it.

 

Notice a la línia 397 del fitxer /Applications/MAMP/htdocs/bxo/modules/customfields/customfields.php
[8] Undefined index: select

Notice a la línia 399 del fitxer /Applications/MAMP/htdocs/bxo/modules/customfields/customfields.php
[8] Undefined index: join

 

I haven't been able to reproduce the bug, so I would like some kind of advice in case this happens again, maybe it's caused by the theme tpl checkout, or maybe a module on the backoffice listing.

 

Thanks

David

[NemoPS]

I have to guess the products by weight module is breaking the total. Can you check the real value in the database? ps_orders table, there should be a value for total_paid_tax_incl

[iwithorg]

I have to guess the products by weight module is breaking the total. Can you check the real value in the database? ps_orders table, there should be a value for total_paid_tax_incl

 

Greetings!

Thanks for answering. 

 

case 748:

• total_paid: 19.110000
• total_paid_tax_incl: 19.110000
• total_paid_tax_exl: 19.110000
• total_paid_real: 16.250000 (right price)
• total_products: 19.110000
• total_products_wt: 19.110000

case 751:

• total_paid: 18.750000
• total_paid_tax_incl: 18.750000
• total_paid_tax_exl: 18.750000
• total_paid_real: 22.550000 (wrong price, it should be 11.95 as invoice says)
• total_products: 18.750000
• total_products_wt: 18.750000

 

 

Thanks, any ideas are appreciated!

David

[tuk66]

It is very important to see all relevant database records of both orders. It can help to find the reason.

[iwithorg]

Greetings!

 

Here they are:

 

751:

{

"data":

[

{

"id_order": 751,

"reference": "QYPWLZCSB",

"id_shop_group": 1,

"id_shop": 1,

"id_carrier": 19,

"id_lang": 2,

"id_customer": 61,

"id_cart": 98,

"id_currency": 1,

"id_address_delivery": 113,

"id_address_invoice": 113,

"current_state": 3,

"payment": "Pagar a la recollida en botiga",

"conversion_rate": 1,

"module": "cashondelivery",

"recyclable": 0,

"gift": 0,

"gift_message": "",

"mobile_theme": 0,

"shipping_number": "",

"total_discounts": 0,

"total_discounts_tax_incl": 0,

"total_discounts_tax_excl": 0,

"total_paid": 18.75,

"total_paid_tax_incl": 18.75,

"total_paid_tax_excl": 18.75,

"total_paid_real": 22.55,

"total_products": 18.75,

"total_products_wt": 18.75,

"total_shipping": 0,

"total_shipping_tax_incl": 0,

"total_shipping_tax_excl": 0,

"carrier_tax_rate": 0,

"total_wrapping": 0,

"total_wrapping_tax_incl": 0,

"total_wrapping_tax_excl": 0,

"round_mode": 2,

"round_type": 2,

"invoice_number": 55,

"delivery_number": 0,

"invoice_date": "2016-05-02 17:39:38",

"delivery_date": "0000-00-00 00:00:00",

"valid": 1,

"date_add": "2016-05-02 17:39:37",

"date_upd": "2016-05-11 17:33:30"

}

]

}

 

748:

 

{

"data":

[

{

"id_order": 748,

"reference": "EEPNTZFOR",

"id_shop_group": 1,

"id_shop": 1,

"id_carrier": 25,

"id_lang": 2,

"id_customer": 161,

"id_cart": 84,

"id_currency": 1,

"id_address_delivery": 291,

"id_address_invoice": 291,

"current_state": 3,

"payment": "Pagar a la recollida en botiga",

"conversion_rate": 1,

"module": "cashondelivery",

"recyclable": 0,

"gift": 0,

"gift_message": "",

"mobile_theme": 0,

"shipping_number": "",

"total_discounts": 0,

"total_discounts_tax_incl": 0,

"total_discounts_tax_excl": 0,

"total_paid": 19.11,

"total_paid_tax_incl": 19.11,

"total_paid_tax_excl": 19.11,

"total_paid_real": 16.25,

"total_products": 19.11,

"total_products_wt": 19.11,

"total_shipping": 0,

"total_shipping_tax_incl": 0,

"total_shipping_tax_excl": 0,

"carrier_tax_rate": 0,

"total_wrapping": 0,

"total_wrapping_tax_incl": 0,

"total_wrapping_tax_excl": 0,

"round_mode": 2,

"round_type": 2,

"invoice_number": 52,

"delivery_number": 0,

"invoice_date": "2016-05-01 22:16:57",

"delivery_date": "0000-00-00 00:00:00",

"valid": 1,

"date_add": "2016-05-01 22:16:56",

"date_upd": "2016-05-12 13:36:28"

}

]

}

 

Regards!

David

Edited May 13, 2016 by iwithorg (see edit history)

[NemoPS]

My only guess is that the invoice sums up the product prices using the order_detail table, while the other total is grabbed from there (I honestly forgot how the invoice part works)
That said, the override that creates the order (PaymentModule class override?) is messing things up I guess, especially if it happens with all payment methods. So my suggestion is to try to debug that out step by step

[tuk66]

It seems the ps_order_invoice table contains different amounts than the ps_orders one.

[NemoPS]

Although for for reason order 751 does have the wrong value stored in ps_order, while the other has the right one

[Jagotic]

On 5/18/2016 at 2:15 PM, NemoPS said:

Although for for reason order 751 does have the wrong value stored in ps_order, while the other has the right one

Hmm, What should we do in this cases, i'm facing very frequenly. In my case, Total in BackOffice is okay, but invoice showing wrong amount