Bulk Coupons - Groupons, Living Social, etc.

**indigobnb** · 23 Sep 2010, 06:42 PM

I've looked all over but can't seem to find a current answer (for the current 1.3.9 version) on gift certificates.

We've been approached for a groupon sale and need to issue a bulk lot of gift voucher numbers. Any ideas on how to do this?

**volks65** · 23 Sep 2010, 08:42 PM

We've got the same situation and they want us to import a .csv file to activate the gift certificate codes. Not sure if it can be done or not. Hopefully someone has the answer.

**indigobnb** · 24 Sep 2010, 04:45 PM

Anyone? We can't be the only one's who've need of this!

**Ajeh** · 24 Sep 2010, 04:59 PM

Gift Certificates are like cash and have NO expiration time ...

Discount Coupons can have start and end times and limits on categories/products that they can be used for as well as how many times per user/coupon they can be used ...

Are you giving away Gift Certificates for "cash" to your customers?

Or, are you trying to give away Discount Coupons?

**indigobnb** · 24 Sep 2010, 06:07 PM

Originally Posted by Ajeh

Gift Certificates are like cash and have NO expiration time ...

Discount Coupons can have start and end times and limits on categories/products that they can be used for as well as how many times per user/coupon they can be used ...

Are you giving away Gift Certificates for "cash" to your customers?

Or, are you trying to give away Discount Coupons?

Which ever is going to be the easiest to do. I don't need to put any limits on the codes. Essentially they need a block of codes to give to their customers who purchase the "30$ of product for $15" deal. So I guess it would be a GC for $30.

Can I import a csv with 500 numbers into the zen_coupons file in the sql database (it shows both coupons and GC's in that file when I browse it) ? I didn't know if this would wipe out the exhisting coupons that were already living in that file.

**Ajeh** · 24 Sep 2010, 07:42 PM

So you want to give 500 customers $30 each ... for Free ... correct?

And, that $30, should never expire, correct?

If so, then you need to add the 500 unique
coupon_code

to the table:
coupons

with the:
coupon_type

set to:
G

Now, if the Customer enters the Gift Certificate redemption code on your site, they will be credited with a $30.00 Gift Certificate balance that can be applied to ALL Products on your site, up to $30.00 of the charge ...

Importing the file, unless you specifically write something to delete all of the existing records, will not affect them ...