Gift Certificate Help Please

[Ajeh]

Thank you Ajeh. I am feeling kind of stupid at the moment because I did manage to find that information on my own later *ughhhh* so I am sorry to have bothered you with a question with such and obvious answer.

Not a problem ... never a stupid answer ...

Now, it is always handy when you find a post that helps you to add in the link to the thread as it can help others with further explanations and such ...

[Ajeh]

I have Ver. 1.38a
I have Group pricing mod A, B, C
Group Pricing for A & B is 100% except Gift Certs & one product are at full charge.
I have Salemaker in place on entire store 60%
With Gift Certs and one product excluded from salemaker

You have an add-on affecting your pricing?

[shoniqua]

You have an add-on affecting your pricing?

Thank you for reply Ajeh, but I don't understand what you mean by 'add-on'?

[Ajeh]

You said you have:

I have Group pricing mod A, B, C
Group Pricing for A & B is 100% except Gift Certs & one product are at full charge.

Is this an add-on or are you using the features of Zen Cart for Group Pricing?

How are you using Group Pricing and excluding anything beyond Gift Certificates which, by design, are already excluded?

[shoniqua]

You said you have:



Is this an add-on or are you using the features of Zen Cart for Group Pricing?

How are you using Group Pricing and excluding anything beyond Gift Certificates which, by design, are already excluded?

Oh I see, I am using the 'Group Pricing' mod by Delia

I followed installation and it works correctly.

But when I created a salemaker sale of 60% off - I did not check 'Gift Certificates' nor the other category to be included within the sale.

Thank you

[wendyshirai]

I am selling Physical Gift Cards and Virtual Gift Certs and i just discovered that both of them are crediting as a Gift Cert value to the customers gift cert balance.

This is a disaster! This CANNOT happen - how do i fix it?

[wendyshirai]

I figured out that they both had model numbers that started with GIFT but how do I reverse the values from a customer's account now for the gift cards that got in the mail and then they got a credit on their gift cert balance too?

Please help! I can't open my store again until i fix this!

[Ajeh]

You would need to go into your phpMyAdmin and manually update the customer balance for any affected customer in the table for the coupon_gv_customer ...

[wendyshirai]

yes, after i calmed down from my panic attack, i realized that. i was very careful to back up my database first and then i went in and edited that table. It always makes me so nervous to touch the tables, it's like touching the cart's eyeball! Anyways, i'm back in business now. Thanks. :)

[Ajeh]

Thanks for the update that you were able to fix this problem and for posting the cause of this issue ...