Bulk Coupons - Groupons, Living Social, etc.

[Kosse]

I need to set up Groupon codes too. Can anyone tell me how to do:

get 50% off an order of $20 or less ( this is the grand total after shipping)

|Please, any help will be appreciated!!!

[wakenine]

***Also posted this in a similar thread....

I have just figured out how to successfully bulk-import coupon codes for events like Groupon, Jasmere, etc. If anyone is interested in a pretty quick and easy run-down on how to do it, let me know. If enough people are needing help with this, I might do a write-up that could possibly be added to the FAQs or something. Either way, I am glad to help.

[Ajeh]

Most likely this would be very helpful to a lot of people and would be appreciated by those who are alos looking for ways to accomplish this ...

[bowserhound]

***Also posted this in a similar thread....

I have just figured out how to successfully bulk-import coupon codes for events like Groupon, Jasmere, etc. If anyone is interested in a pretty quick and easy run-down on how to do it, let me know. If enough people are needing help with this, I might do a write-up that could possibly be added to the FAQs or something. Either way, I am glad to help.

Yes please!

[fran]

Hi, im looking for a way to bulk import Groupon codes too so if that FAQ could be written up, great!

[fran]

It seems like bulk import is possible using PHPMyAdmin, click the coupons table, then click the Import button.

Select your CSV file, change "Number of Rows to Skip" to 1 so as not to import fieldnames on first row.

Select "CSV" as Format, then hit Go.

The problems arise trying to get the file into the correct layout. The date field seems to be the most problematic but the solution is to do this...

In Excel, highlight one of your coupon_start_date or coupon_expiry_date cells and right-click and select "Format Cell". Change the cell type to "Text" because if you leave it as a "Date" cell or any other type, Excel will change around its format to suit the region your PC is set to, whereas Zencart uses the date in a specific format which is:

coupon_start_date
2011-12-01 00:00:01

coupon_expiry_date
2011-12-31 00:00:01

So the date needs to be laid out exactly like this in your CSV file in Excel: YYYY-MM-DD HH:MM:SS

Once that's done and all your other fieldnames are filled in with the proper data, everything should work fine.

[bacrew]

***Also posted this in a similar thread....

I have just figured out how to successfully bulk-import coupon codes for events like Groupon, Jasmere, etc. If anyone is interested in a pretty quick and easy run-down on how to do it, let me know. If enough people are needing help with this, I might do a write-up that could possibly be added to the FAQs or something. Either way, I am glad to help.

Did you manage to write a nice easy walk through?

[skriza]

Hi I need this solution...and fast I already exported in .csv format the zen_coupon in excel 2008 on mac and i need to know how to upload it using phpMyAdmin so i can add 1000 coupon codes all at once. I do not know if i should erase or check certain boxes such as coma, tab, semicolon etc. in order for it to work?? Thanks so much S Kriza

[wakenine]

I have a properly formatted spreadsheet (CSV) that I have used successfully numerous times for clients now. If anyone wants it, PM me and I can send it. Once you know what fields to change, it's pretty simple. You need to be comfortable enough using the import function in phpMyAdmin though.

[revitupmedia]

I have a properly formatted spreadsheet (CSV) that I have used successfully numerous times for clients now. If anyone wants it, PM me and I can send it. Once you know what fields to change, it's pretty simple. You need to be comfortable enough using the import function in phpMyAdmin though.

Any chance you can share the file?

Thanks,
rev