# Need help with Payhere and adding listing fees

**URL:** <https://community.glideapps.com/t/need-help-with-payhere-and-adding-listing-fees/45222>\
**Category:** Ask for Help\
**Created:** [July 25, 2022, 4:06pm UTC](https://community.glideapps.com/t/need-help-with-payhere-and-adding-listing-fees/45222 "2022-07-25T16:06:29Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![NinaDCS](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ninadcs/32/45337_2.png) [@NinaDCS](https://community.glideapps.com/u/NinaDCS)\
**Post date:** [July 25, 2022, 4:06pm UTC](https://community.glideapps.com/t/need-help-with-payhere-and-adding-listing-fees/45222/1 "2022-07-25T16:06:29Z")

</div>

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

How can I do this?

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [July 25, 2022, 11:39pm UTC](https://community.glideapps.com/t/need-help-with-payhere-and-adding-listing-fees/45222/2 "2022-07-25T23:39:46Z")

</div>

Hi Nina!

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.

---

<div class="post-metadata">

**Author:** ![NinaDCS](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ninadcs/32/45337_2.png) [@NinaDCS](https://community.glideapps.com/u/NinaDCS)\
**Post date:** [July 25, 2022, 11:43pm UTC](https://community.glideapps.com/t/need-help-with-payhere-and-adding-listing-fees/45222/3 "2022-07-25T23:43:55Z")

</div>

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!

Thank you for your reply!

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [July 26, 2022, 12:50am UTC](https://community.glideapps.com/t/need-help-with-payhere-and-adding-listing-fees/45222/4 "2022-07-26T00:50:42Z")

</div>

So that $1 listing fee is also monthly, right?

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [July 26, 2022, 1:17am UTC](https://community.glideapps.com/t/need-help-with-payhere-and-adding-listing-fees/45222/5 "2022-07-26T01:17:44Z")

</div>

Ya…she wants a dynamic (but automatic) subscription fee per month based on the number of listings the user has.

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [July 26, 2022, 2:48am UTC](https://community.glideapps.com/t/need-help-with-payhere-and-adding-listing-fees/45222/6 "2022-07-26T02:48:28Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [July 26, 2022, 2:49am UTC](https://community.glideapps.com/t/need-help-with-payhere-and-adding-listing-fees/45222/7 "2022-07-26T02:49:44Z")

</div>

Another idea is to create a subscription with two items:

- Fixed fee for monthly subscription ($20).
- Variable quantity for listings ($1 x quantity).

Then update the quantity for every new listing.

---

<div class="post-metadata">

**Author:** ![NinaDCS](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ninadcs/32/45337_2.png) [@NinaDCS](https://community.glideapps.com/u/NinaDCS)\
**Post date:** [July 26, 2022, 3:11pm UTC](https://community.glideapps.com/t/need-help-with-payhere-and-adding-listing-fees/45222/8 "2022-07-26T15:11:12Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [July 26, 2022, 3:14pm UTC](https://community.glideapps.com/t/need-help-with-payhere-and-adding-listing-fees/45222/9 "2022-07-26T15:14:21Z")

</div>

not very hard… just the right data structure and smart relations…  
I see you are using PayHere… don’t they charge 3% on top of Stripe?

---

<div class="post-metadata">

**Author:** ![NinaDCS](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ninadcs/32/45337_2.png) [@NinaDCS](https://community.glideapps.com/u/NinaDCS)\
**Post date:** [July 26, 2022, 3:18pm UTC](https://community.glideapps.com/t/need-help-with-payhere-and-adding-listing-fees/45222/10 "2022-07-26T15:18:14Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [July 26, 2022, 3:20pm UTC](https://community.glideapps.com/t/need-help-with-payhere-and-adding-listing-fees/45222/11 "2022-07-26T15:20:35Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![NinaDCS](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ninadcs/32/45337_2.png) [@NinaDCS](https://community.glideapps.com/u/NinaDCS)\
**Post date:** [July 26, 2022, 3:25pm UTC](https://community.glideapps.com/t/need-help-with-payhere-and-adding-listing-fees/45222/12 "2022-07-26T15:25:02Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [July 26, 2022, 3:26pm UTC](https://community.glideapps.com/t/need-help-with-payhere-and-adding-listing-fees/45222/13 "2022-07-26T15:26:09Z")

</div>

if is worth it for you, we can set up a Zoom meeting…  
I’m building a public version of my system… should be ready in 1-2 months

---

<div class="post-metadata">

**Author:** ![NinaDCS](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ninadcs/32/45337_2.png) [@NinaDCS](https://community.glideapps.com/u/NinaDCS)\
**Post date:** [July 26, 2022, 3:38pm UTC](https://community.glideapps.com/t/need-help-with-payhere-and-adding-listing-fees/45222/14 "2022-07-26T15:38:00Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [July 26, 2022, 3:45pm UTC](https://community.glideapps.com/t/need-help-with-payhere-and-adding-listing-fees/45222/15 "2022-07-26T15:45:21Z")

</div>

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…

> **[VgsCoin](https://vgscoin.structureartdigital.com/)**

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [July 27, 2022, 12:29am UTC](https://community.glideapps.com/t/need-help-with-payhere-and-adding-listing-fees/45222/16 "2022-07-27T00:29:45Z")

</div>

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/8/985b5e92b762cb577353ba93275add5ac459deed.jpeg)

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:

- Fixed fee for monthly subscription (item 1) - quantity always equals 1 - $20/month.
- Variable fee for listings (item 2) - quantity at start equals 0 - $1/month, update quantity for every add/delete of listing in your app.

> **[Setting subscription quantities](https://stripe.com/docs/billing/subscriptions/quantities)**
>
> Vary the cost of a subscription by subscribing a customer to multiple quantities of a product.

---

<div class="post-metadata">

**Author:** ![NinaDCS](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ninadcs/32/45337_2.png) [@NinaDCS](https://community.glideapps.com/u/NinaDCS)\
**Post date:** [July 27, 2022, 3:30pm UTC](https://community.glideapps.com/t/need-help-with-payhere-and-adding-listing-fees/45222/17 "2022-07-27T15:30:00Z")

</div>

@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.

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [July 28, 2022, 2:16am UTC](https://community.glideapps.com/t/need-help-with-payhere-and-adding-listing-fees/45222/18 "2022-07-28T02:16:41Z")

</div>

> [@NinaDCS](#):
>
> Just so I’m understanding correctly, does this still use the Payhere method?

No, it doesn’t. To be clearer, PayHere is just an extension of Stripe (they’re built as an add-on for Stripe). This uses Stripe directly.

> [@NinaDCS](#):
>
> 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.

You have to build Make/Integromat scenarios for this from scratch, and you can do recurring subscriptions with Stripe, just not the Glide buy button.

---

<div class="post-metadata">

**Author:** ![NinaDCS](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ninadcs/32/45337_2.png) [@NinaDCS](https://community.glideapps.com/u/NinaDCS)\
**Post date:** [July 31, 2022, 10:56pm UTC](https://community.glideapps.com/t/need-help-with-payhere-and-adding-listing-fees/45222/19 "2022-07-31T22:56:28Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![ehdubya](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ehdubya/32/24087_2.png) [@ehdubya](https://community.glideapps.com/u/ehdubya)\
**Post date:** [August 1, 2022, 4:51am UTC](https://community.glideapps.com/t/need-help-with-payhere-and-adding-listing-fees/45222/20 "2022-08-01T04:51:33Z")

</div>

[![](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/4/c40a70ad7b32aa0f5ef0ced513d5d0ff273089ea.jpeg "How to set up Stripe and Integromat to get test events into your workflow") ](https://www.youtube.com/watch?v=XH76L-xT1lM)

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!

[Next page](https://community.glideapps.com/t/need-help-with-payhere-and-adding-listing-fees/45222.md?page=2)
