Forums / Managing Customers and Orders / Which table is the Gift Certificate amount in?

Which table is the Gift Certificate amount in?

Locked

Results 1 to 3 of 3

This thread is locked. New replies are disabled.

8 Jun 2006, 2:22 PM

libracorn

New Zenner

Join Date:: Jul 2005
Posts:: 44
Plugin Contributions:: 0

Which table is the Gift Certificate amount in?

I looked through the coupons_gv_customers and coupons_gv_queue but neither show the amount of a gift certificate used on an order.

For instance, you have a $10 order and the customer used a $2 gift certicate ultimately paying $8. Which table/field is that $2 amount stored in the database?

8 Jun 2006, 4:27 PM

absolute

Totally Zenned

Join Date:: May 2005
Location:: Bath, Somerset
Posts:: 1,054
Plugin Contributions:: 2

Re: Which table is the Gift Certificate amount in?

It is stored in the orders_total table. It is just saved as the entry for the amount deducted, with a class of ot_gv, linked to the order it was used on.

Absolute

8 Jun 2006, 4:41 PM

libracorn

New Zenner

Join Date:: Jul 2005
Posts:: 44
Plugin Contributions:: 0

Re: Which table is the Gift Certificate amount in?

Thank you!