X-Cart customization: Subscription payments based on initial pay date.
I use X-Cart automatic pay_subscription script for recurring billing on my website www.vonbell.com. By default for monthly subscription type it sets the charge on 1st of each month regardless of initial pay date.
But I do not want to set specific date for recurring billing, only type of subscription. And script should check if there are some customers to charge today based on initial pay date.
I'm selling subscriptions to my customers on my website [url removed, login to view] using X-Cart. The recurring billing date can only be set to 1st of each month for all customers using X-Cart Subscription Module.
I want different date for each customer, based on their initial subscription purchase date.
Currently, X-Cart's native Subscription Module initially only charges my customers a fractional amount based on number of remaining days this month (plus one-time setup fee if I set it). It will then charge them monthly rate on the 1st of each following month.
If you visit my website and add a subscription based product to your shopping cart, you will see “Days remain up to end of period” and an amount right below this line which is calculated based on remaining number of days.
What I'd like to do is to charge my subscribers one month fee at the time their orders are placed (plus one-time setup fee if applicable). Then they will be charged monthly rate based on initial pay date.
For clarity, I'll describe this project with examples below.
Scenario 1: Suppose Customer Adam placed his subscription order on October 12th, I’d like to charge him initially for $10.00 setup fee plus $20.00 first month rate ($30.00 total). I’d like to continue charging him $20.00 on the 12th of every month thereafter until he cancels.
Scenario 2: Suppose Customer Brian placed his subscription order on October 20th, I’d like to charge him initially for $10.00 setup fee plus $20.00 first month rate ($30.00 total). I’d like to continue charging him $20.00 on the 20th of every month thereafter until he cancels.
SPECIAL CASE Scenario 3: Suppose Customer Charles placed his subscription order on January 31st, I’d like to charge him initially for $10.00 setup fee plus $20.00 first month rate ($30.00 total). The next bill date would be February 28th or 29th since there are no more than 28 or 29 days in February. Future bill date will be based on original bill date if available; otherwise, set bill date to the last available date of a month.
SPECIAL CASE Scenario 4: Suppose my web server or website is down for 2 days in a row, thus I could not run the subscription script. When I run subscription script the next time after my website is up again, I’d like the script to check and find all the customers that should have been charged during those 2-day downtime (or better yet, since last time the script was run), and charge them accordingly.
I submitted this custom modification project to X-Cart Custom Development team and requested a quote. The quote was $150.00. But the start date is 22 – 24 working days from today, and about 5 working days to complete this project.
I’m posting this project here in hope that someone can start and complete this project much sooner than what X-cart quoted me. I’m willing to pay up to $150.00 for this project.
This project requires knowledge in PHP and familiarity in X-Cart. Feel free to PM me if you have any questions. Thanks!