[Ariel777]

Thanks, I changed to the non-Ajax and all is well. Shame though — it’s a nice touch. Any plans for making a new Ajax squeeze form?

[Ariel777]

Perfect. Thanks for all your help.

[Ariel777]

I have finally installed the new version, and indeed the subscription_id field has now been added to the customer table. That’s great, thank you.

But, unlike what is written here (https://support.tipsandtricks-hq.com/forums/topic/estore-not-processing-paypal-cancel-subscription-ipn#post-90068), it seems that each recurring PayPal payment is not not recorded as a separate entry in the Customer table. Perhaps this is new behaviour for version 8, or something? So,

(a) Could you confirm that this is so, and that only the first payment of a set of recurring payments (subscriptions) is recorded in the main customer table?

(b) On my website, I accept both PayPal and Stripe gateways. The subscription_id field is populated only for PayPal subscription payments, and not for one-off PayPal payments. But strangely, that same field is populated for every single Stripe payment, even when this is not a subscription or recurring payment. Is that intentional, or a bug?

[Ariel777]

I’m not seeing that value anywhere in the customer record (I’m using the WP Admin to check, haven’t looked at the raw mySQL table just now).

I’m on eStore 7.1.9.

The Paypal IPN for the subscription purchase definitely has the subscr_id value in it (debugging is on so I was able to check).

I can see the Transaction ID, but not the subscription ID.

Can you tell me where exactly I should be seeing the subscriber id?

[Ariel777]

I’ll set something up and post back in a couple of days.

AFAIC, it’s Paypal and Stripe that are of interest.

[Ariel777]

In the link you cite, it seems that it is. Maybe this is something new? Or have I misunderstood?

https://developer.paypal.com/docs/classic/ipn/integration-guide/IPNandPDTVariables/#subscription-variables

Also, in the eStore ipn_handle_debug_log, it seems to show up in a test subscription I did.

[Ariel777]

Thanks for your clear answer.

eMember might be overkill for this one issue, but I will definitely consider it.

Thanks for your help.

[Ariel777]

Thanks. No, of course I didn’t mean manually. I meant that the software would check the eStore customer table to see whether the user is an active subscriber. But it seems that the Payapl cancellation IPN isn’t recorded anywhere in the eStore tables.

I have no problem buying the emember plugin, but I’m worried about slowing down the website with too many plugins.

Based on what you said previously, that each subscription payment is recorded separately in the Customer table, it may work to simply check whether a particular customer (based on their email and product purchased) has paid in the last 30 days. If not, presumably they have cancelled.

[Ariel777]

I see.

I’m trying to set up a simple subscription-licensing option for desktop software I sell. I was hoping I could simply check with the customer table to see whether they have an active, paid-up subscription or whether they’ve cancelled it or a cancellation is pending.

Any ideas how I could do that with eStore?

[Ariel777]

Thank you for the link. I see that it’s not possible.

Bulk transfer: I mean that I have hundreds of customers who have bought one or more items using the eStore plugin. Can I bulk transfer all those customers from the eStore database to eMember, so that if they want, they can sign up for free membership, and then log on, and only then see their purchase history page?

(3) Is it possible to query the eStore plugin (via GET or POST or PHP) to see whether a customer’s subscription/recurring payment has been made, and that they’re an active customer?

[Ariel777]

Hello,

No, I hadn’t! Very nice…

I’ll do some more searching now on the site to see if there’s a way of providing download links as well…

(1) Is there some way to password protect this shortcode, so that the customer has to type not only their email, but also say a serial number, or paypal ID?

(2) If the answer to (1) is that that is only possible with the eMember plugin, then: Is it possible to bulk transfer all the existing customers to the eMember plugin, keeping their purchase history intact?

Thanks very much for your help! I’m going to check out the shortcodes more carefully now…

[Ariel777]

Fantastic, that works great, thank you!

[Ariel777]

Thanks.

[Ariel777]

Hmm, it’s a little tricky to keep track of a dozen or so products. So please consider this an official “feature request” — email notification when licenses have run out (or even better, when they are about to run out, e.g. 3 left or something).

By the way, are we allowed to try and modify the plugin ourselves? If so, could you point me to the .php file that I would want to look at the reads the serial number list — maybe I’ll be able to insert a line to send an email when there are none left, if that is ok according to the Terms and Conditions.

[Ariel777]

Thanks. So far I’ve done 10 test purchases or so, and the serial numbers never seem to be ready. Could you give me an idea of how long it might take before the plugin receives the IPN?

Should I tell the user to keep the page open and press refresh a few times if the serial number is missing?

[Author]

Posts