I've had great results here before and I know that this
is a very simple project for the right programmer who
knows what he/she is doing.
I need a program done that manages multiple product order
forms as well as a simple customer database.
(PHP & MySql)
What should happen is this...
I should be allowed to create new product records in the
program where I specify the following,
1) Product Name
2) Price
3) Optional Shipping costs that I specify or, make use
of UPS's realtime online shipping table.
4) The path to a header graphic I'd like to use on the
product's specific order form.
5) Product Weight (optional)
6) Any optional customer HTML I would want inserted on
the order form below the header graphic and above the
text boxes.
7) A thank-you page for each product where they are sent
after they successfully order.
When these details are input the program outputs a URL
for a dynamic order form it created that I link to from
my main website so that people can enter all their details,
*EXCEPT* the credit card number, expiry date and CVS#.
(I should be able to retrieve any of these html links for
the specific order forms at any time as well.)
I would need the program to allow me as said before to
create as many of these 'Product Records' as I want.
Then a separate 'ACCOUNT' module where I enter
Merchant Name: (My name)
Merchant Email: my return email address that will appear in
the header and body of the email sent to your customer.
Gateway Merchant ID: the login ID or HTML serial number for
the processing system ([login to view URL])
They credit card processor I need it to then feed that
information to is [login to view URL] - so when someone uses
one of my custom order forms, and they hit "SUBMIT" it
passes the info collected to the [login to view URL] order form
on the fly... Paysystems then collects the credit card
details on their 'order form'.
When the order is processed I then want to use the
Postback feature in Paysystems to send back the following
so that my custom made program can keep a record of sales
done.
- Customer name
- Customer email
- Purchase price
- Phone number
- Order number given by [login to view URL]
- IP address
Then another module is needed to show me statistics.
(This should just be aggregate ($) figures.)
I should be able to view general sales stats for any
period I specify, product specific sales over any period,
daily sales and monthly sales.
Apart from that I also want to be able to view a table
listing all sales for a particluar month in the order
that they happened, ( DATE - NAME - PHONE - AMOUNT ),
have the ability to edit the details of any sale record
in the database and to delete a sale if I do a refund,
where that refunded sales is then added to a "refunds
report"
The ability to export the databases into a comma separated
text file is something else I would like to have.
Of course I'd have to have some where I can setup my
shipping tables, and specify which shipping table I
want to use for each product, (optional).
So basically a php script that acts as the "go-between"
from my customer to my credit card gateway and records
what happens.
Send me an email automatically when
1) A new sale is made, stating the product sold and any
relevant customer details.
2) When an attempted sale is made but was not completed.
(ie declined, not autohorized etc.)
Hope this is all clear and hope that it attracts some
prolific programmers.