Export created coupons

Hi,

At this moment there’s no such feature.

It is on my wishlist for this plugin, or possibly a ‘pro’ version of it, but it all depends on the number of requests for this feature ??

I do believe it is posible to export the Coupons custom post type via the standard WordPress exporter, though I’m not sure if that fits your needs with the fields that are exported..

Hope that answers your question ??

Cheers,
Jeroen Sormani

I would love this feature… In fact, I don’t know why you would want to make 100 coupons at a time if you can’t get them out of the system and put them on something. My idea is I would like to make 100 coupons to make my digital product 100% free.

Then I will export them, print them out on labels, and then be able to sell digital products at my events in person. They pay me, I hand them one of the cards, and boom! They have the product.

As you have it, I would have to copy and paste out 100 per product I have. No thanks.

Any chance you have developed this yet? Any chance you could get developing it soon.

Thanks much for your work. I love how easy your plugin was, just can’t use it if I have to do all the back end stuff by hand.

Thanks.

Hi,

Thank you for letting me know your interest in the feature ??

I haven’t developed this feature yet, and have no concrete plans to do so either. If you’re a developer, the code is on GitHub and I do accept pull requests ??

If you’re looking for a solution, it is possible to do a relative simple SQL query, so if you have direct access to the database you can directly export it from there..

(to others: please also let me hear you if you want a feature)

Have a great weekend!
Jeroen

Yeah, you kind of need this feature. It really is a requirement for many business cases.

The reason to generate hundreds or thousands of codes… Include a unique, one-time use code in an email blast to your customers.

Create the codes, export the codes and import to your mass email distribution tool like MailChimp or Constant Contact. Create the email and display the unique code in the email.

Thank you.

Hi Steve,

Thanks for letting me know about the interest in the feature ??

Have a great weekend!
Jeroen

For those looking for a solution…

Open the WordPress database using myPHPAdmin (from your cPanel). Click on the Search tab. Search for shop_coupon in the wp_posts table. Click on Browse to view the results, which include all of the posts that are the coupon code. (At least I think it should show them all.

Scroll to the bottom of the page and click on Export. Set the format as CSV. Go.

A file named wp_posts.csv will be downloaded locally. The CSV file will include a list of ALL of your coupon codes, not just the ones created in bulk by this plugin. Column L should have the coupon codes created, and you can sort by Column C which is probably the creation date to find the ones you just created.

Copy and paste the codes created into where you need.

=== Additional info not related to the original question ===

For me, I exported a Segment of my MailChimp distribution list, deleted all columns except for email, firstname and lastname. Added a column for Coupon, and then imported the CSV file back into MailChimp using the Auto Update Existing List option.

Of course, you need to assign the column for the coupon to a field in MailChimp. The Auto Update Existing List option updates the records in MailChimp, leaving all of the history and just adding the Coupon field.

Then I was able to create the email in MailChimp, and “pull in” the coupon code from the “MailMerge” functionality so each email I sent had it’s own, unique coupon code.

Thanks for posting Steve ??

In addition, it is also possible to Query the coupons directly, there should be a ‘Query’ option in phpMyAdmin too (or any other MySQL application you may use).

Use this query to get a list of the coupon codes:
SELECT post_title FROM wp_posts WHERE post_type = 'shop_coupon' ORDER BY post_date DESC LIMIT 0,10000

1) Do change the ‘wp_posts’ to your correctly prefixed table name
2) Change the ‘LIMIT 0,10000’ to the correct amount of coupons you generated to get the last generated coupons

Cheers,
Jeroen

HI Jeroen,
What about the e-mail restriction? Would love to at least match a company domain like google.com to get at least the right public connected to the coupon. Is this possible by using goog.com instead of [email protected] e.g. or *@google.com ??
Going to work it out if not will post it here…

Hi,

As far as I know the coupons feature in WooCommerce doesn’t support wildcards or domains only (doesn’t say it, but I haven’t checked that ever..).

If you’d need this you’d have to modify how the coupons work in WooCommerce.

Jeroen

Hi Jeroen-

Thanks for the work so far.

My client needs to generate a number of coupons at once. Your plugin does that well.

Then they need to email them to a customer, or have the customer order their own block of coupon codes via WOoCommerce as a product…. Your plugin does not do that. THey’d like a list output in a text field or at least an excel or csv download button to do this.

So far I see a paid plugin that might do what they need, at $50/site. That’s what I’m going to to have to try next…

I also vote for the export feature ??

Thank you for this plugin Jeroen! Only feature missing is the export function.
If any of you are still looking for a solution to export the coupons, I finally managed to export the coupons to CSV with the ‘WP All Export’ plugin or ‘Export WordPress data to XML/CSV’ plugin. https://nl.www.ads-software.com/plugins/wp-all-export/. Hope it helps!

Iordache