Proof of payment for membership. Help!!! :)

[dsmith4712]

Hi and thanks for your time.

I'm investigating a new purchase of Miva Express to address an existing problem that Yahoo's ecommerce solution can not provide.

I have a web site requirement that collects a yearly membership fee. Step#1 the user is given a membership info. collection page that is stored into a mysql database (via php) and then directed to select one of three levels of membership.
Step#2 Each of the individual membership level is actually a product that once selected is placed in the shop cart.
Step#3 the user checks out and receives an order.

The problem: How to confirm that the membership has been paid for the member added to the membership database??? We currently must manually go to the order database and then manually enter the order info. into the membership database. Very time consuming.

My thought is that I could write a PHP script to daily check the Miva orders database for a matching member name (perhaps login ID) for the payment. Not sure how much of a learning curve is required with this solution. I already know how to write PHP calls to a mysql database. Is reading from the Miva database as elegant. Prefer using the Miva database versus Miva mysql solution for simplicity sake.

Or do you have another recommended solution for this problem?:o

Thanks!!!

[Vic - WolfPaw Computers]

Re: Proof of payment for membership. Help!!! :)

This could actually be done quite easy with MM5 on MySQL.

You put a call to your php script to be called from the INVC screen in Merchant. Using a real time payment gateway, only orders that are funded will get to the INVC screen - thus the php script kicked off and you could pass the database fields for most of the customer information to your membership database.

Hi and thanks for your time.

I'm investigating a new purchase of Miva Express to address an existing problem that Yahoo's ecommerce solution can not provide.

I have a web site requirement that collects a yearly membership fee. Step#1 the user is given a membership info. collection page that is stored into a mysql database (via php) and then directed to select one of three levels of membership.
Step#2 Each of the individual membership level is actually a product that once selected is placed in the shop cart.
Step#3 the user checks out and receives an order.

The problem: How to confirm that the membership has been paid for the member added to the membership database??? We currently must manually go to the order database and then manually enter the order info. into the membership database. Very time consuming.

My thought is that I could write a PHP script to daily check the Miva orders database for a matching member name (perhaps login ID) for the payment. Not sure how much of a learning curve is required with this solution. I already know how to write PHP calls to a mysql database. Is reading from the Miva database as elegant. Prefer using the Miva database versus Miva mysql solution for simplicity sake.

Or do you have another recommended solution for this problem?:o

Thanks!!!

[d_host]

Re: Proof of payment for membership. Help!!! :)

It sounds like you need a membership management system more than MIVA Merchant - which is just a shopping cart system, not designed for what you describe at all. A proper membership management system will let your visitors sign up for whichever membership level they want, create logins for them, keep the accounts active until the last day they paid until, and then auto-renew (and auto-bill them) if necessary. Check out aMember Pro - much more suitable to what you want to accomplish than MIVA Merchant.

[Julie Wilber]

Re: Proof of payment for membership. Help!!! :)

I moved this thread to the MIVA Merchant Express Forum. =)

[dsmith4712]

Re: Proof of payment for membership. Help!!! :)

Thank you!