How To Check Subscription Status

[jhwest]

Hi there,

I have spent over 40 hours trying to figure out how to query this WP Swings Subscriptions Pro plugin to get users current subscriptions status.  I tried using the API (won’t connect), I’ve searched through the database more times than I can even count and I am coming up empty on where you’re storing the subscription status. Another thing that confuses me is that the woocommerce order page has it’s way of controlling and displaying order status but WP Swings apparently does not connect to that in any way that I can decipher. Woocommerce does not have ‘Active, Paused’, etc.  I need to be able create a function dependent on WP Swings subscription status and use my own logic accordingly. I don’t need custom code, I just need to know where the status is being stored in the database and if there are any roadblocks or reasons that I cannot make my own function to handle my needs.

Thanks so much for your time and help.

Jason

[Samael]

Hello,

As per your query, we would like to tell you that, In the database, we store the subscription status on a key named as: wps_subscription_status with respect to the subscription id and based on the site setting if HPOS is enabled then this key will be saved in order meta table and if HPOS is not enabled then this key will be stored in postmeta table.

We hope this makes sense, Still, if you need help please connect with the support team.

They will guide you for the same and will make sure not to happen again

We are here to help

Best Regards,
Sam

[Vinsashaua]

Hey, i have a same problem, but i haven’t wps_subscription_status field in postmeta table and heve not order meta table

[Samael]

Hello,

To check the status of a subscription, please refer to the Subscription table.

We do not create a separate database table specifically for subscriptions. Instead, all subscription-related data is stored in either the ordermeta table or the postmeta table, depending on whether HPOS (High-Performance Order Storage) is enabled in WooCommerce.

In the case of HPOS, WooCommerce handles data storage differently, but the subscription status remains consistent. The subscription status is saved against the subscription ID using the meta key:

wps_subscription_status

[Author]

Posts