Bulk Coupons - Groupons, Living Social, etc.

[snowkrash]

Hello,

We have the same need - we need to import the coupon codes that Groupon gives us in the form of a .csv file into the coupon codes database table. My client does not use Gift Certificates anymore in Zen Cart because she can't link that up to her in-store sales (we can't find a way to allow people with a Gift Certificate generated by Zen Cart to make a purchase in the boutique with that Gift Certificate), so she only uses the discount coupon codes online, and does not sell gift certificates online with Zen Cart.

Do I import the .csv with the 1000 numbers Groupon gives us into the coupon codes table and then set the value of the coupon code as the discount amount in the database table, is that it, or are there more settings I need to change or add to that table? I'm not a database person so I need to know how to do this. Thank you!

[Ajeh]

Discount Coupons need to have entrees for both the:
coupons
coupons_description

tables to create valid Discount Coupons ...

Create a manual Discount Coupon to see what the normal Discount Coupon would generate and then you will have a better idea of what is needed for your import ...

[KevinP]

We've gotten several such offers in the last couple weeks. It seems to be a big trend. Apparently we'd need to not only be able to generate a bunch of coupons, but also have the ability to IMPORT a bunch. seems to depend upon how well established the organization is.

For these types of offers, it seems the way to go is to have a coupon with an expiry date, rather than a gift cert.

Just to summarize (and ask a clarification):
1.) For each coupon, we need to add a row to coupons table and to coupons_description table
2.) Coupon types are as follows:
a.) F - fixed amount
b.) P - percentage
c.) G - gift certificate (cannot expire)


Thanks!

[Ajeh]

Are you sure you need unique Discount Coupons or just limit how many you pass out?

Let's say you want 132 Discount Coupons for $5.00 off anything ...

Make a Discount Coupon
Coupon Amount: 5.00

Uses per Coupon: 132

Uses per Customer: 1

Set dates if needed, keep in mind dates are based on Midnight ...

Example: to be good for Only October 14, 2010 you would set the dates to start on: 14 October 2010 end on: 15 October 2010

[snowkrash]

Each person buys a Groupon on Groupon's site, pays something like $20 for $40 worth of goods/services and is given a unique coupon code by Groupon. Groupon gives us the csv file with a column of hundreds of codes they have given the purchasers already, and a column of the full names of the purchaser of each code. It also has a column for whether or not the coupon has been redeemed. These people are not necessarily customers of ours yet, and will not have an account with us, so I am guessing I am not importing their names, only the coupon codes.

So, how does this sound - do I have to make columns in the csv file that correspond to the table columns adding all the correct values in the csv file, then import the whole file?

There is a table column in there about whether or not it is restricted for use with a category (we DO want this, the Groupon is only available for Classes we offer, not for products, and we have Classes set up as one category with an id of 15) - I have tried putting the number "15" into that database field for the manual test I created using the interface, but that did not work. I tried typing the name of the category in all caps, then I tried all lowercase, then I tried exactly as it appears, capitalized, none of these worked - it seems I can only import all this stuff and MANUALLY add the category restriction on each one using the coupon admin area in Zen Cart once the import happens?! That can't be right, but once I did manually add the category restriction in the admin, the database table reflected a blank entry - not null, nothing is in that DB field even though the restriction does work in practice. So, it would seem that nothing I could import into those fields of the DB would work - does that sound right?

If I get 10000 groupon sales, it is not acceptable that I would have to manually go through each one after importing the rest of the info into the database, and manually add the category restriction - does anyone know of a solution for this?

ANY help is appreciated - the Groupon goes live on Friday - TWO DAYS from now and I need to be able to quickly import the info on Saturday so people can use it on SUNDAY.

Thank you!

I'm on Zen Cart 1.3.7

[Ajeh]

You would need to add the Discount Coupon information to the tables:
coupons
coupons_description

Add a Discount Coupon manually, then export the two tables so you can see how the data needs to be added ...

[rmickus]

Snowkrash - just curious...were you able to successfully get the bulk coupon code upload to work? I will be needing to do the exact same thing in about a week for a GroupOn that will soon be running for our Internet business. Any further feedback on what you did and how it worked, etc. would be greatly appreciated! I am not technical, so could use all of the help I can get. Thanks!

Each person buys a Groupon on Groupon's site, pays something like $20 for $40 worth of goods/services and is given a unique coupon code by Groupon. Groupon gives us the csv file with a column of hundreds of codes they have given the purchasers already, and a column of the full names of the purchaser of each code. It also has a column for whether or not the coupon has been redeemed. These people are not necessarily customers of ours yet, and will not have an account with us, so I am guessing I am not importing their names, only the coupon codes.

So, how does this sound - do I have to make columns in the csv file that correspond to the table columns adding all the correct values in the csv file, then import the whole file?

There is a table column in there about whether or not it is restricted for use with a category (we DO want this, the Groupon is only available for Classes we offer, not for products, and we have Classes set up as one category with an id of 15) - I have tried putting the number "15" into that database field for the manual test I created using the interface, but that did not work. I tried typing the name of the category in all caps, then I tried all lowercase, then I tried exactly as it appears, capitalized, none of these worked - it seems I can only import all this stuff and MANUALLY add the category restriction on each one using the coupon admin area in Zen Cart once the import happens?! That can't be right, but once I did manually add the category restriction in the admin, the database table reflected a blank entry - not null, nothing is in that DB field even though the restriction does work in practice. So, it would seem that nothing I could import into those fields of the DB would work - does that sound right?

If I get 10000 groupon sales, it is not acceptable that I would have to manually go through each one after importing the rest of the info into the database, and manually add the category restriction - does anyone know of a solution for this?

ANY help is appreciated - the Groupon goes live on Friday - TWO DAYS from now and I need to be able to quickly import the info on Saturday so people can use it on SUNDAY.

Thank you!

I'm on Zen Cart 1.3.7

[csimmons83]

Can I suggest a social coupon aka Groupon Wiki or Tutorial?

[mkopecky]

I am currently using 1.3.8 and have been able to upload bulk coupon codes via CSV into the database. However, the start date and end date default to 11/30/2036 despite having unique dates in the csv file. I have tried changing the database "structure" to allow for the csv file date columns I created to upload and have been unsuccessful...they all continue to default to 2036.
I currently have the coupon start_date and expire_date set to:
Type=datetime
Default = As defined:
0001-01-01 00:00
Null = No

I need to be able to not only upload the coupons, but also the correct start and expiration date.

Any help or advice would be great.
Thanks,
Mkopecky

[Astarkley]

I'm also looking into coupons and gift certificates. Is it possible to have a coupon or gift certificate downloaded from zen-cart and printed out by the customer?

coupon_active would need to be Y for Active ...

Make sure that is a capital Y ...

NOTE: Zen Cart is not setup of selling Gift Certificates at a discount, unless you mean walk up and down the street with a handful of Gift Certificate cards worth $30 that people can buy for $15 to then be used on the site ...

NOTE: Discount Coupons cannot be used to purchase Gift Certificates either ...