Develop a MS Access Database for online subscription co

Closed Posted Jun 12, 2014 Paid on delivery
Closed Paid on delivery

We already have a filemaker database but need a new one developed that has a better architecture and connects with our payment system and shipping tool. Current database is around 25 MB in size.

Database functions needed:

-serves as our CRM and hold all account information including payments dates, amounts, shipment dates, tracking numbers, notes about each shipment, refunds, credits, notes, shipping address, etc

-connect via API to our recurring payment system Recurly

-will need to be programmed so that payments are broken up into "x" shipments based on the frequency plan the customer has. Example: Customer A pays $100 every 28 days and has a weekly frequency so 4 payment lines will need to be created, each being $25.

-corresponding shipment dates will need to be programmed for each payment based on state and date of payment

-payments declined will need to be routed to a dashboard so that once payment comes in we can manually enter in the shipment dates

-connect via API to Shiprush or other Fedex system to generate shipping labels and store tracking numbers for each shipment date

-reporting, be able to run a report selecting any combination of field or fields

-search function

-auto input all new customer data

-connect via API to Amazon to input all customer data, payment, order #, order date, shipment date, product ordered, shipment tracking #

Microsoft Access PHP

Project ID: #6062821

About the project

27 proposals Remote project Active Jul 19, 2014

27 freelancers are bidding on average $2288 for this job

esolzsales

We would love to discuss the project details, before placing a firm bid. We have some initial questions and more will follow as we discuss. This will ensure we have a strong grasp on the project. Looking forward to hea More

$2577 USD in 60 days
(251 Reviews)
9.5
rajeshsonisl

Hello, With 99% completion rate, 700 successfully completed projects, and a 5.00 reputation (maximum possible, 5.0) (Yes, not even 4.99 average rating, can be verified on my profile page !!)... you can never go wron More

$4736 USD in 30 days
(480 Reviews)
7.5
zeke

Dear Customer! I am an expert PHP developer with over 6 years of experience and very interested to work on this project. Available to start immediately and finish as soon as possible. My bid is for fast professional s More

$2577 USD in 30 days
(165 Reviews)
7.0
ranganathp

Can help... I am an Expert... Lets Start! Please start a Discussion with me and we can get started from there... Please check the past projects I have handled and check my reviews for what employers have to say about More

$4000 USD in 20 days
(39 Reviews)
6.6
LearningNew

A proposal has not yet been provided

$1894 USD in 25 days
(37 Reviews)
6.4
MarlinSoftware

Hello, I am a developer with over 23 years experience building complex database systems, specialising in the development of applications in MS Access using VBA and WinAPI. I could produce a functional and user friendly More

$3000 USD in 90 days
(24 Reviews)
5.6
elboukharimu

Aucune proposition n'a encore été fournie.

$2000 USD in 25 days
(12 Reviews)
4.6
shallufreelancer

Do you have the developer keys for Fedex ?....................................................................................

$1894 USD in 25 days
(6 Reviews)
3.7
rlpenn

I have been programming in Access for over 15 years. I design databases for small to medium sized business in North Texas. The databases I have written run several of the largest MHMR providers in Texas. I just fini More

$2000 USD in 28 days
(2 Reviews)
2.5
venkatbudarapu

Respected employer I have gone through your requirements, the work is which I would like to work all the time We will deliver 100% what exactly you need or you specified in the requirements and also we will flexible fo More

$1447 USD in 20 days
(4 Reviews)
2.4
nksundaram

Experienced software professional with 20 years in design, development and maintenance of applications.

$833 USD in 20 days
(2 Reviews)
1.8
topdevusa

Thanks for your post on Freelancer, firstly I would like to say that we DO NOT ASK TO RELEASE PAYMENT till the entire project is complete. Only thing that we request is that you put in an escrow deposit that you do no More

$5154 USD in 30 days
(0 Reviews)
0.0
davidrudd

Ask for a demonstration of our standard user interface. We can rapidly build any application using our SaaS platform. High security and reliability for a low predictable cost. Shipment management applications are More

$789 USD in 10 days
(0 Reviews)
0.0
pnjadhav

I have total 13 years of experience in IT which include both software development and web development. I have great experience in managing projects with USA/UK based clients and I manage my work shift timing as per cli More

$2222 USD in 20 days
(0 Reviews)
0.0