This is a similar positing to a couple projects in the past, so to save some effort I'm going to edit my requirements into a new listing. I am looking for someone familiar with X-Cart customization and PHP.
X-Cart customization: Subscription payments based on initial pay date without a setup fee. The monthly fee (subscription fee) will vary and decrease depending on how long the customer has been enrolled in the subscription service. Also, I will need X-Cart to be customized to reduce the subscription charge for customers depending on how many months they are enrolled in my subscription (details below).
I will be using X-Cart automatic paysubscription script for recurring billing on my website. By default in X-Cart, monthly subscription fees charge on the 1st of each month regardless of initial pay date.
But I do not want to set specific dates for recurring billing – I want it only based on the customer's initial pay date. Example: If they order our product on March 14th, I would like it to bill them again on April 14th, and so on.
I'm basically going to be selling a monthly subscription option to customers on my website using X-Cart. My payment gateway is likely to be authorize.net. The recurring billing date can only be set to 1st of each month for all customers using X-Cart Subscription Module.
I want different dates for each customer, based on their initial subscription purchase date and the subscription type. Example: If they order our product on March 14th, it would bill them again on April 14th, and so on.
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. I do not wish to use prorate rates at all and I want to be able to do away with the setup fee as well (if I choose) e.g. set it to zero which would not display it at the product level at all of the cart.
The way X-Cart is currently setup, if you visit a website and add a subscription based product (e.g. magazine subscription) 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.
Another element to the subscription amount is the shipping and tax amounts. Currently the subscription model does not cope with recharging the shipping component. I am not sure about the tax but if applicable in the sale the amount in the database for recharging each month should include taxes and shipping. It would be preferrable to choose if this is applicable to be charged on and on-going basis at the setup of the subscription product in the first instance.
Now, I need the subscription based payments to decrease on a monthly schedule. These numbers will not change, so everyone that signs up for the subscription will get this same payment schedule until they cancel the service. Note, these numbers do not include taxes and shipping. I can add those as well if it makes it easier.
$37.95 for Month 1
$29.95 for Months 2-5
$27.95 for Months 6-12
$24.95 for Months 13+
So, basically a customer would pay $37.95 plus shipping when they enroll. Exactly one month later, they would be charged $29.95 plus shipping. Basically, the pattern would repeat according to the schedule above.
So, to further clarify, I'll provide some examples:
Scenario 1: Suppose Customer Adam placed his subscription order on October 12th, I’d like to charge him initially $37.95 plus $7.95 shipping at the first month rate. I’d like to charge him $29.95 plus $7.95 shipping on November 12th and continue to charge him on the 12th of every month thereafter (at the rate schedule above) until he cancels.
Scenario 2: Suppose Customer Brian placed his subscription order on October 20th, I’d like to charge him initially $37.95 plus $7.95 shipping at the first month rate. I’d like to charge him $29.95 plus $7.95 shipping on November 20th and continue to charge him on the 20th of every month thereafter (at the rate schedule above) 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 $37.95 plus $7.95 shipping 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.
Admin issues: I would like to be able to continue to look in the subscriptions section of the admin and click on the billing date and update/edit it if required.
I would also like a button that tells me the number of subscriptions due for renewal in the current week/month/year and the dollar value associated with each.
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 sooner than what X-cart quoted me. If you can do it for cheaper than X-Cart's quote, I would certainly appreciate that as well. I will hire the person who can do it the cheapest.
This project requires knowledge in PHP and familiarity in X-Cart. Feel free to PM me if you have any questions. Thanks!