Zen Cart Logo
Forums / Discounts/Coupons, Gift Certificates, Newsletters, Ads / Database updated incorrectly when Gift Certificate covers order value?

Database updated incorrectly when Gift Certificate covers order value?

Views: 1,603

Results 1 to 4 of 4
30 Sep 2013, 2:55 AM
#1
boardshorts avatar

boardshorts

New Zenner

Join Date:
Jun 2012
Location:
Sydney Australia
Posts:
2
Plugin Contributions:
0

Database updated incorrectly when Gift Certificate covers order value?

Customer has $15 GV value

Places order for $7.95 and applies $7.95 of GV to that order. Customer selects store pickup so no shiiping invloved.

Check out process looks correct and customer gets email which also looks correct

Products

1 x Random Stripe 4ply 50gms 2904 (4082700776863) = $7.95

Sub-Total: $7.95
Store Pickup (Walk In): $0.00
GST TAX 10% + : $0.72
Gift Certificates: -$7.95
Total: $0.00

however when I check the order in admin it looks like this

[TABLE]

Payment Method: |
Gift Certificate/Coupon

[/TD]
[/TR]
[TR]
[TD]
Products |
Model |
Tax |
Price (excl) |
Price (incl) |
Total (excl) |
Total (incl) |

1 x |
Random Stripe 4ply 50gms 2904 |
4082700776863 |
10.00% |
$7.23 |
$7.23 |
$7.23 |
$7.23 |

[TABLE]

Sub-Total: |
$7.23 |

Store Pickup (Walk In): |
$0.00 |

GST TAX 10% + : |
$-0.07 |

Gift Certificates: |
$7.95 |

Total: |
$-0.79

[/TD]
[/TR]
[/TABLE]
[/TD]
[/TR]
[TR]
[TD]Looks as though the tax calculations are reprocessed after checkout and before data is stored in database.

Searched the forum for some time and could not find a solution. All help appreciated.[/TD]
[/TR]
[/TABLE]

20 Dec 2013, 12:33 AM
#2
boardshorts avatar

boardshorts

New Zenner

Join Date:
Jun 2012
Location:
Sydney Australia
Posts:
2
Plugin Contributions:
0

Re: Database updated incorrectly when Gift Certificate covers order value?

<p> Further to problem described above the customer has contacted us about the information that shows in their account, has anyone else experienced this and is able to explain how we might be able to rectify. Thanks. | | | | | | | | --- | --- | --- | --- | --- | --- | | Date | No. | Ship To | Status | Total | View | | 30/09/2013 | # 203 | Customer Name Australia | Delivered | $-0.79 | | and ## Order Information - Order #203
Qty. Products Total
1 ea. Random Stripe 4ply 50gms 2904 $7.95

[/HR]$7.23 Sub-Total: $0.00 Store Pickup (Walk In): $-0.07 GST TAX 10% + : -$7.95 Gift Certificates: $-0.79 Total:

Status History & Comments

Date Order Status Comments
30/09/2013 Processing
30/09/2013 Delivered Comments
</p>
20 Dec 2013, 2:51 AM
#3
mc12345678 avatar

mc12345678

Totally Zenned

Join Date:
Jul 2012
Posts:
16,908
Plugin Contributions:
2

Re: Database updated incorrectly when Gift Certificate covers order value?

boardshorts:

<p> Further to problem described above the customer has contacted us about the information that shows in their account, has anyone else experienced this and is able to explain how we might be able to rectify. Thanks.
Date No. Ship To Status Total View
30/09/2013 # 203 Customer Name Australia Delivered $-0.79
and

Order Information - Order #203

Qty. Products Total
1 ea. Random Stripe 4ply 50gms 2904 $7.95

[/HR]$7.23 Sub-Total: $0.00 Store Pickup (Walk In): $-0.07 GST TAX 10% + : -$7.95 Gift Certificates: $-0.79 Total:

Status History & Comments

Date Order Status Comments
30/09/2013 Processing
30/09/2013 Delivered Comments
</p>

Not that it would have caused the discrepancies that are present, but do you have either super orders or edit orders installed?

Puzzles me a little that the sub-total in two places is different.

25 Dec 2013, 2:00 AM
#4
lhungil avatar

lhungil

Totally Zenned

Join Date:
Feb 2012
Location:
mostly harmless
Posts:
1,818
Plugin Contributions:
4

Re: Database updated incorrectly when Gift Certificate covers order value?

In the checkout email, why does tax show 0.72 which is not applied to the order total? Looks wrong to me in both places...

May be useful to know what sort_order is configured for each order total module AND what tax settings are configured (including for ot_gv)...