Gift Certificate Help Please

[Renz]

Hi Ajeh,

Yes that "release_flag N that may not be attached to a valid customer_id" is there I have attached an image, what should I do to purge or delete this,

Thanks
RR

[Ajeh]

You need to click on BROWSE to see if you have any records in the coupon_gv_queue table and see if any of the records are marked as release_flag N and what the customer_id is ...

Then, look in the customers table and see if you can find the customers_id that matches that ...

If there isn't a matching customers_id for the customer_id you find in the coupon_gv_queue table then that is most likely the problem ...

[Renz]

Yep it is there and the client has gone it was a test account

So simply delete this?

Sort by key:
Full Texts unique_id customer_id order_id amount date_created ipaddr release_flag
07:32:32 118.208.46.6 N
Edit Delete 5 2 6 25.0000 2009-06-26

[Ajeh]

Once you confirm that this is not a valid customers_id you can delete it ...

NOTE: based on what you are saying you might also check the table coupon_gv_customer and make sure that any customers_id with a balance is valid ... as these are spendable Gift Certificate $$$ ...

[Renz]

Thanks all gone now please write again soon

[sholly]

I have a question im trying to do a dummy purchase of a gift voucher however the only payment option available for it is paymate and i want to be able to offer internet banking (direct deposit) what do i need to do? They are all activated but only showing paymate.

Thanks

I'm having the same problem, can anyone help?

[cycochuck]

I am having an unusual problem. I am trying to setup Zen Cart to replace my current limited one and thought that adding gift certificates would be a good idea. I followed the instructions listed in previous posts and everything went fine on my test gift certificate until I got to the payment page. On the payment page both my right and left side boxes get mixed into the middle unless I add another product to the cart that requires shipping. Can anyone point me out where I need to look to fix this because right now I have no clue. I am not sure if it is the Cherry Zen theme I am running that is messing this up or the Fast and Easy Checkout one.

The first picture is of the checkout with only the gift certificate and the second is of the checkout with the gift certificate and an item that requires shipping.

[cycochuck]

I am having an unusual problem. I am trying to setup Zen Cart to replace my current limited one and thought that adding gift certificates would be a good idea. I followed the instructions listed in previous posts and everything went fine on my test gift certificate until I got to the payment page. On the payment page both my right and left side boxes get mixed into the middle unless I add another product to the cart that requires shipping. Can anyone point me out where I need to look to fix this because right now I have no clue. I am not sure if it is the Cherry Zen theme I am running that is messing this up or the Fast and Easy Checkout one.

The first picture is of the checkout with only the gift certificate and the second is of the checkout with the gift certificate and an item that requires shipping.

I found the fix. In tpl_checkout_stacked.php add the following at the top.

 <!-- Added to fix error with gift  certificates only in cart -->
<?php if ($order->content_type == 'virtual') { ?>
<div class="centerColumn" id="checkoutPayment">
<?php } ?>
<!-- End of gift certificate add on -->

[cycochuck]

Zen Cart allows GVs to be either automatic or by approval ...

Personally ... I prefer to approve all GV purchases ...

Then, when you approve a GV an email is sent with the code ... no there is not fancy image of the GV with that email ... you could code something for this, but there is nothing built in for this to happen ...

Once the GV code is received either the person who got the email can claim it or they could give the code to someone else ... first person to claim it wins ...

Or, they can claim it, then later decide to send it to someone else ...

I am having the problem of the GV code is not being sent when I approve the GV. Where do I look to fix this?

[Ajeh]

Actually I worded that very poorly ...

If you send a Gift Certificate via the Admin, the customer gets an email with a redemption code ...

If the customer buys a Gift Certificate, it is queued ... and when released in the Admin ... an email is sent out saying that the Gift Certificate has been released and the balance will be found in the Customer's account the next time that they log in ...

So the Gift Certificate redemption code only is included on GVs mailed to a customer via the Admin ... and the funds are released to the customer's account when the GVs were first purchased and have been released from the queue ...

Does that make it a bit clearer?