eStore – send different email when no serials left

[end255]

Hi, I’m setting up an online store for sales of iTunes gift card codes, using

WP eStore Version: 7.2.1

WP Version: 4.2.2

There has been no modification to any of the eStore plugin code.

I’ve been testing this site (located at [https://cheapitunes.com/]) in Sandbox mode to ensure it works well before moving to production use.

I have set the “available quantity” of the product to the number of leftover codes, so

One test I did was to fire off two purchases in a row when only one serial was left. The PayPal sandbox simulated a payment being held up for review; so I logged into the sandbox and approved both payments.

The system then sent two emails – one email containing the last serial, and then an email with no serial in it:

---

Dear Test Buyer,

Thank you for your purchase of:

iTunes US$50 Gift Card Code x 1 – $70 (AUD)

Your serial numbers are below.

Thanks

---

Additionally, I noted that the available quantity of the product was decreased to -1!

I know it’s not very likely to occur, but rather than sending out a “success” email with no serial embedded, would it be possible to:

1- preferably, automatically reverse the PayPal transaction and notify the customer as to what has happened

2- failing that, send an alternative email to the customer explaining what has happened

Evidently the system is aware that it’s out of serials (“SUCCESS :This product does not have any serial key available.” appears in the debug log), so it’d be nice to be able to send a different email template to explain to the customer what has happened and let them know I will go into PayPal to manually refund them.

(Due to the nature of the product being sold, I expect I will often be out-of-stock)

Yes, I’ve seen the thread at https://support.tipsandtricks-hq.com/forums/topic/estore-email-notification-to-seller-when-last-serial-number-used – but that’s about emailing the store owner, not the customer.

Let me know if further information is required.

[wzp]

What you are describing is a situation that can best be described as a “race condition,” and would only occur when there are multiple orders being processed by PayPal for the one remaining serial key.

If this is anticipated to be a popular item, perhaps you can set the available quantity, so as to allow you a 1 or 2 serial key “buffer.” Alternatively, you can place any message of your choosing in the key database; as long as it does not contain a comma, as follows:

172635, 938465, OUT OF SERIAL NUMBER ERROR — PLEASE CONTACT US ASAP FOR RESOLUTION

[Author]

Posts