Gift Certificate Help Please

Thank you. One more question. Witch way would be the best. If gv_mail.php would be, What do I need to insert or change in it. Thank you again for all you help.

If you are a coder than you can customize the code in the:
/admin/gv_mail.php

If you are comfortable with editing database tables then you can do that in phpMyAdmin ...

If you are not comfortable with either, then you might want to post in the Commercial Help Wanted for someone to customize the code for you ...

Custom Code is always better than raw database manipulations as there would be less likelihood of errors that way ...

Thank you Ajeh for you help. I will look into that.

This has probably been addressed already but I am testing this out & I keep getting this message...

Please update your order ...
Product Name: Gift Certificate ... Quantity Units errors -
You ordered a total of: 1 Units: 0

Thanks Zen Team!

You cannot buy in Units of zero ... division by zero will fail ...

Edit your Product and set it at least to 1 meaning that you can buy Products providing the quantity is divisible by 1 ...

Anybody can enlighten me ?

I tried configuring gift certificate but in product types. The count is zero.

So I encounter the error that payment is not accepted at your region.

What have I missed out ? I followed the instructions from FAQ/knowledge base.
https://www.zen-cart.com/tutorials/index.php?article=64

How can I determine how much is in the Gift Certificate bank of a customer?
I can see when they email gifts to another, but I don't see their amount.
I am sure everything works perfectly, it is just a check..
Short of looking in the mysql db.

We got our website live and the 3rd order was for a gift certificate... Cool..

Thanks...

Ajeh,

I have a customer that has already purchased custom gift certificates (w/ codes) . How do I change the code generated code in the database to the one's printed on the cards? I can 'browse' the coupon_code and see the code's but, it will only allow me to view them.

How do I get to the codes to change them?

Thanks in advance!

p.s. I am using phpmyadmin

Ajeh:

If you are a coder than you can customize the code in the:
/admin/gv_mail.php

If you are comfortable with editing database tables then you can do that in phpMyAdmin ...

If you are not comfortable with either, then you might want to post in the Commercial Help Wanted for someone to customize the code for you ...

Custom Code is always better than raw database manipulations as there would be less likelihood of errors that way ...

kevinw:

How can I determine how much is in the Gift Certificate bank of a customer?
I can see when they email gifts to another, but I don't see their amount.
I am sure everything works perfectly, it is just a check..
Short of looking in the mysql db.

We got our website live and the 3rd order was for a gift certificate... Cool..

Thanks...

You can browse, in phpMyAdmin, the table coupon_gv_customer

In the upcoming v1.3.8 you will see the customers' balance on the customers.php in the Admin if Gift Certificates are installed ...

Thank You, now I can see the balance of current Gift Vouchers...
Be Well

I believe I have followed everything the Book says for setting up GC. I have also read many, many posts... followed those as well.

I have GC enabled on my site, (https://www.ambersscrapattic.com) however the FAQ link that should be on the home page is not there.

I also can not figure out where my customers tell me who the GC is going to? I have "bought" a GC to send and don't see anything special. Are they just supposed to write in the comment box an address and name?

What am I doing wrong???

Any help would be great. THANK YOU!!!

Amber

This could be your template or you do not have the Gift Certificates installed and enabled in the Modules ... Order Total ... Gift Certificates ot_gv.php

Ajeh:

This could be your template or you do not have the Gift Certificates installed and enabled in the Modules ... Order Total ... Gift Certificates ot_gv.php

I'm not sure about it being my template. I did get it from the downloads section here.

As for the install... I did follow those steps. Mod,Ord Total,GC, as directed above and in the book.

If it's the template... any ideas as to where to start looking to find the cause?

I also would like to know how am I supposed to know who the GC goes to. I seem to be missing a step somewhere.

Thank you,
Amber

Hi, on our shop we have an order total module calls discount_by_payment_type. When customers choose the credit card option, they will get 2% discount.

The second thing is group_pricing that we apply to our customers if they have purchased above a certain amount. For examlpe 40% VIP discount.

All these also apply if they purchased for Gift Certificates. Why??

Example 1:

Customer belongs to a group_pricing with 40% VIP discount.
He buys a GV for 1000$.

On checkout_payment:

Sub-Total:      $ 1.000
VIP discount: -$ 80 (-40% ???)
Discount on payment type: -$ 18 (-2% ???)
Free shipping:    $ 0

Total:            $ 902

Example 2:

When the same customer by an item for 100$ and a GV for 900$.

On checkout_payment:

Item:     $100
GV:       $900
Sub-Total:      $ 1.000
VIP discount: -$ 80 (-40% ???)
Discount on payment type: -$ 18 (-2% ???)
Free shipping:    $ 0

Total:            $ 902

1. The discounts shall not apply to the GV
2. 80$ is not 40% of 1000$
3. 18$ is not 2% of 920$

What is wrong her? Have I configured something wrong, or is this a bug from ot_group_pricing and ot_discount_payment_type? I've have tried all the setup guides from this forum without any changes. Please help me..

pepsishot:

I'm not sure about it being my template. I did get it from the downloads section here.

As for the install... I did follow those steps. Mod,Ord Total,GC, as directed above and in the book.

If it's the template... any ideas as to where to start looking to find the cause?

I also would like to know how am I supposed to know who the GC goes to. I seem to be missing a step somewhere.

Thank you,
Amber

Did you make a Gift Certificate? As in send one to yourself? :unsure:

Why display the box if there has never been one created to utilize it? :lamo:

bondee,

If I am understanding this right ...

Gift Certificates are never Discounted

Because you can buy one for $100 ...

Send to friend ...

Friend buys another for $100 ... but got the discount and sends off to friend ...

Do this long enough and your discounts, if allowed on Gift Certificates, will end up with you paying the customer to buy from you ... :eek:

Ajeh:

bondee,

If I am understanding this right ...

Gift Certificates are never Discounted
That was what I thought too, until this happened.
How can I disallowed this?

Help! :oops:

I setup the gift certificate feature and it works ok. My problem is that I tested it by purchasing and then sending a 25.00 gift cert to myself. I received the email with the code, but I deleted the order before redeeming it. Now it shows I have a 25.00 gift certificate balance in my custgomer account, and the code I was emailed doesn't work. :oops: :censored:

How do I clear this up and out?? I'm running 1.3.7 zencart.

Can anyone help me fix this?

You may wish to upgrade to v1.3.7.1 if this is a fairly new install ...
http://www.zen-cart.com/forum/showthread.php?t=69769

As to the Gift Certificates that are ordered and not released yet, those are in the table:
coupon_gv_queue

Once released there will be an entry in the table:
coupon_gv_customer

with the amount for the customers_id ...

When sent to someone, the email is then tracked in the table:
coupon_email_track
coupons

NOTE: when you claim the Gift Certificate with the redemption code, you will then see a balance in your Gift Certificate account in the table:
coupon_gv_customer

and it will show in the Catalog for your My Account and during checkout_payment you will see a place to redeem codes that have not yet been redeemed and a place to Apply some or all of the balance towards an order ...

Hello there.. any ideas on my problem?