Question:
We’re building a data integration for a client. Our client offers subscriptions using the pricing plans WIX feature.
What are you trying to achieve:
We’re trying to pull records of subscription orders. But the searchOrders API endpoint does not return any of those subscription orders, even with no filters. Our assumption is that it would and then fill in the subscriptionInfo object on the lineItems in each order.
Has anyone managed to pull records of subscription payments from the REST API? We’re open to using a different endpoint.
Search Orders is an API for eComm, you will want to use something from Pricing Plans. Here is one example, but others under pricing plans will return subscriptions as well
Thank you! Got it. Is there a way to query all of the payments made that associate with a pricing plan? The listOrders endpoint appears to only show the lastPaymentStatus.
I don’t see that available in the order object - it’s possible there’s some way to calculate the num of payments made based on some of these other fields but I don’t have a site set up to test that theory.
I also checked the collection which you could query directly with wix-data, but I’m not seeing something there that will definitely work. You can take a look as well Wix Pricing Plans "PaidPlans/Plans" Collection Fields
EDIT: I"m also seeing a field in the object for current pay cycle - assuming this likely increments so potentially can calculate the number of payments with this (untested by me)
Will ask the team and follow up in case there is something i’m missing here