I have a users table (glide), a vendors table (glide), and a listings table (glide).
I am following Bob’s Payhere guide and and also have a subscriptions table (google).
For the time being, each user is also a vendor.
What I would like to do is charge my users/vendors a monthly subscription (say $20) to use my app using Payhere. But I would also like to charge them a listing fee. Let’s say each listing costs $1 and I want the total cost of all their listings within the dates of their monthly subscription to be added to the next monthly charge.
$20 + (10 listings x $1) = $30 on their next automatic payment with Payhere
Hm. That’s not possible with Payhere. When a user subscribes for the first time, that subscription amount is set in stone until they unsubscribe. The only way you be able to achieve this is if they resubscribe every month.
Okay, I was worried about something like that being the case. Is there another method you would advise to have a subscription price and listing fee charged to the user?
I actually need help from the beginning, like how to count the listings per vendor between two dates using math or roll ups or other columns. I’m not sure where to start!
That’s not easy at all. Even with Stripe API. I imagine in Stripe, I would have to create a new “price” object for every new customer, and once they add a listing, I update that price to reflect on their billing for the next month. Very complex.
How difficult would it be to implement something like this? This was at the request of the person who I’m helping build this app. If I can’t make it work I’ll have to convince him to just stick with a monthly subscription price.
I haven’t actually set any of it up yet, because I’m trying to decide if it’s the right way to go. I found a lifetime deal on Appsumo that brings the transaction fee to 1% as well I am planning on using if I go this route.
if, you don’t have a big transaction amount per month, is probably worth it, if yes… i would do my own payment integration…
my VgsCoin doesn’t charge%… is just flat 0.25 C per transaction
Interesting. Some of the vendors could have hundreds of listings per month, which could add up depending on the fee we charge. We haven’t discussed what our monthly subscription fee will be yet. I don’t even know how to set up the data structure and relations so I would need help with that too either way.
I’ll think about it. I’m going to meet with my partner first and figure out what we want to do with our pricing, since he wanted the beta version of the app ready in August.
this is a preview of my system… don’t pay attention to descriptions, and grama… is just a testing model… only Stripe and Checks are working in this simulation… but like I said 1-2 months, it will be ready for public use, I’m so overwhelmed wit my paid contracts now, that I can’t find time to finish it lol…
That would be heavy on the Stripe side, and can eat into your Make/Zapier quota, but that is how I imagine it should work, if you use Stripe as the payment processor.
Basically create a subscription when vendors first sign up, with two items:
@ThinhDinh Thanks for replying, this looks like what I need. Just so I’m understanding correctly, does this still use the Payhere method? Or is there another way to get this working? Sorry I’m so new to this, I didn’t think we could do recurring subscriptions with Stripe in Glide. I’m not sure how to set this all up. I was just going to follow along with Bob’s tutorial.
Thanks for the information. Are there any guides that can help get me started? I have zero experience with Make and Stripe or any APIs but I’d like to give a shot at learning and trying to implement it myself.
This dude’s got some decent how-to Stripe (subscriptions)/Integromat videos on his YT channel. Dunno if these will help but hey, who knows, they just might! Good luck on the build!
