Jump to content

backoffice order total showing wrong price, invoice showing correct price


Recommended Posts

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

post-1177455-0-98502900-1463062613_thumb.png

post-1177455-0-35454100-1463062623_thumb.png

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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 by iwithorg (see edit history)
Link to comment
Share on other sites

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

Link to comment
Share on other sites

  • 2 years later...
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

 

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...