Sales Database


This program needs to be web based so that multiple users can access it (maybe using PHP and MYSQL)

I currently sell from an online auction site called bidorbuy.co.za.

I can click a button to export all my sales to spreadsheet format (see example of attached csv file).

I'm not sure exactly how it works, but this is the web site it shows when I click on the 'export button':

[url removed, login to view]

I need the following to happen:

1) Automatically retreive the csv file from my profile on bidorbuy every hour.

2) insert the sale details into a datababase (which I need created)

3) add on the following the following column for 'order status' which includes the following slectable options:

a) pending (default option), (cell color must change orange)

b) paid, to ship (cell colour must change to Red)

c) shipped (cell colour must change to Green)

d) Customer collecting (cell colour must change to Yellow)

e) Waiting to file SNC (cell colour must change to Purple)

f) Payment not received, filed SNC (cell colour must change to Brown)

g) Order cancelled (cell colour must change to Blue)

4) Add another column for 'shipping method' with the following selectable options:

a) fedex

b) speed services

c) Economail

5) Add on another column for 'tracking number'

6) Make a button that I can click on, that will export the following fields to an excel document: 'customer name', 'item description', 'shipping address', 'shipping method'

7) A button to 'print shipping label'

8) An automatic, customized email must be sent to the customer's email address as soon as they win the auction. This will thank them for their order, instruct them to complete the order process on birobuy, and inform them of our bank details

9) An automatic, customized email must be sent to the customer's email address as soon as I select either 'paid' or 'shipping'. The email will include the tracking number and customer's name

10) If status has not changed from 'pending' to 'paid' within 3 days, an automatic, customized email must be sent to customer to remind them to pay

11) If status has not changed from pending to 'paid' within 7 days, then the order must automatically be sorted under 'waiting to file SNC'

12) I should be able to click one button to automatically filter any one of the above mentioned statuses or shipping methods

13) Each order must be able to be clicked on to show the following extra info:

a) A time/date stamp with the history log of the order statuses

b) 'notes from customers' (to paste extra info that customers might have emailed about)

Kemahiran: PHP

Lihat lagi: www sales co za, www fedex, speed color, services database, sell print online, sell excel services, seller which have shipping, seller profile example, sale co, profile bank, payment not received from bank, online excel works, mysql customer database, make program and sell online, jsp services, jsp profile web, how to sell services online, how excel works, email bank details, customers bank, click sales, c&f bank, c and f bank, access database services, 1 hour email address

Tentang Majikan:
( 0 ulasan ) Lyndhurst, South Africa

ID Projek: #311466

6 pekerja bebas membida secara purata $472 untuk pekerjaan ini


Over 3 years experience in PHP, Mysql, MSSQL. Web-based portal(PHP, ORACLE). Programmed (with team) for [login to view URL](PHP, Mysql). Developed Asset Management Software for Spice Nepal (PHP, Mysql). Developed Attendance Lagi

$300 USD dalam 15 hari
(0 Ulasan)

Dear Sir Please check your PM

$280 USD dalam 15 hari
(0 Ulasan)

Ascenders Technologies is an IT services company and one of our main focus is web & Software development that specialises in providing outstanding value for money services for web design & development, flash design, we Lagi

$600 USD dalam 15 hari
(0 Ulasan)

Hi, I have gone through your [login to view URL] further discussion plz check PMB. Thanks & Regards gayatri

$750 USD dalam 25 hari
(0 Ulasan)

Pls check out my bid

$400 USD dalam 20 hari
(0 Ulasan)

hello sir, [login to view URL] is provider for total solutions for starting a complete E- Business, It’s a Complete center for all online business needs. [login to view URL] is committed to absolute excellence. That is why our cor Lagi

$501 USD dalam 21 hari
(0 Ulasan)