Creating multiple coupons

  • Brian
  • Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
9 years 7 months ago #69043 by Brian
Creating multiple coupons was created by Brian
I use this extension to sell registrations to races. We sell tickets via Groupon and need to be able to upload or create 500-1000 coupons per event and all at once. I do not see a way to upload them. Is there a way to do this? Can we have a way to upload them via FileManager or FTP? Can we have custom coding done to be able to?

Thank-you.

Please Log in or Create an account to join the conversation.

More
9 years 7 months ago - 9 years 7 months ago #69047 by James Riley
Replied by James Riley on topic Creating multiple coupons
The Devs might have a better suggestion on hoe to do this, but what *** I *** would do is get someone to write me a mySQL routine that slogs through the datefile I want to import and inserts the data directly into the _eb_coupons table. Here's a snapshot of what the table looks like in my database (sensitive info hidden):


code: your coupon code
coupon_type: 0=% and 1=dollars-off
discount: % or $ off
event_id: 0=all events, or the unique id of the event that you want the coupon to be valid for
time: number of times the coupon can be used (set it to 1 for you Groupon codes)
used: number of times the code has been used (for you, 0 will be unredeemed, 1 will be redeemed)
valid_from / valid_to: self explanatory. The "zero" entry in the above example is a coupon that has NO expiry.
published: 1=code is live and will work if a user tries to enter it, 0=code will not work

James Riley .: EventBooking user since 2014 ::: JoomDonation user since 2016 :.
.: grfx & web design / IT / AV @ St. Therese Institute of Faith and Mission, Bruno, SK, Canada :.
Attachments:
Last edit: 9 years 7 months ago by James Riley. Reason: corrected typos

Please Log in or Create an account to join the conversation.

More
9 years 7 months ago - 9 years 7 months ago #69048 by James Riley
Replied by James Riley on topic Creating multiple coupons
Option #2:
You can do the import without programming if your hosting provider gives you some sort of mySQL manager (eg. phpMyAdmin). You'll need to format your datafile to match with what the manager wants/expects.

WARNING WARNING WARNING: Just be careful messing around in the db if you don't know what you're doing as you could ruin your whole website!

James Riley .: EventBooking user since 2014 ::: JoomDonation user since 2016 :.
.: grfx & web design / IT / AV @ St. Therese Institute of Faith and Mission, Bruno, SK, Canada :.
Last edit: 9 years 7 months ago by James Riley.
The following user(s) said Thank You: Brian

Please Log in or Create an account to join the conversation.

More
9 years 7 months ago #69057 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Creating multiple coupons

Brian wrote: I use this extension to sell registrations to races. We sell tickets via Groupon and need to be able to upload or create 500-1000 coupons per event and all at once. I do not see a way to upload them. Is there a way to do this? Can we have a way to upload them via FileManager or FTP? Can we have custom coding done to be able to?

Thank-you.


I think the solution would be writing some custom code to allow importing coupons from a csv file. This will cost you 50$ for the customization.

So if you agree, we can customize it for you

The other option is importing via php myadmin as James mentioned. However, you should only do it if you know how to do, otherwise, the database table might be messed up

Regards,

Tuan

Please Log in or Create an account to join the conversation.

  • Brian
  • Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
9 years 6 months ago #70448 by Brian
Replied by Brian on topic Creating multiple coupons
Thank-you. I would like to hire you for the custom code Tuan. Please advise where to contact you as this is an urgent matter.

Please Log in or Create an account to join the conversation.

Moderators: Tuan Pham Ngoc