Custom Order Site for Company

CLOSED
Bids
31
Avg Bid (USD)
$834
Project Budget (USD)
$250 - $750

Project Description:
I am interesting for a custom made order site.

The site must have admin pages that only the administrators can add customers with the details in the database!

Also the administrator must upload a csv file with the item details
Code, Description, Search Key, Discontinue Item, Alternative Item
908790,item description,search1,disc,909089

He must maintain and insert data to the dates for ordering (periods)
Order Final Date, Order Approval Month1 Date, Order Approval Month2-3 Date
2013/1/15, 2013/1/25,2013/1/30

Also he must maintain the users in the database
Username, Password, Email, Main Address, Branch 1, Branch 2, Branch 3, Category.
User1,Password,email,address,branch1,branch2,branch3,Wholesale

Category in users I need it for different profile pages in his account!
All the customer script is based through his Category.


When a customer logins he see his profile and a menu based in his category!
The main category is Wholesale.

If category is Wholesale then he can view the order menu.

New Order (only new orders.) choose period
Edit Order (Edit orders that are not submitted)
Completed Order (Completed order)
Finalized Order (the order that he tells where to send the items)

All the ordering procedure is based per day/month but he preorder for 3 months.
He can order today for the next month and the 2 more.
The final date to submit the order must be the Order Final Date.
If he submit the orders for the three months then he can only make additional orders for the next months.
If he did not submit the order in this day then this order must be with a flag that he can not use it but the admin can see it and manual if he wants to export it!

The order header is
Username,yearmonth,
User1
And the details
Linenumber,Itemcode,quantity

In the new order now he can add like in excel the item codes and he see the description of the items and post the quantity. If an item disc = 1 then he must see warning and if he wants to choose the alternative item.

He can save the order for later additions or he can submit it to process.
When someone process an order then automatically we must have a csv with the following details
Username,yearmonth,
Linenumber,Itemcode,quantity

But if lines are greater than 40 then it must split the csv to new one with new line numbers. If this is not possible then he stops the order at line 40 (with parameter) and opens a new one.
He can not edit the orders that he submits! Only new ones!

And after that auto send to admin email/emails.

Now the picking is begin and we have another csv that we upload to site
In this csv we have the following
Username,yearmonth,
Linenumber,Itemcode,quantity,Picking,BO

When this procedure completes then he can see the Finalized Order that can be pressed.

When he opens the Finalized Orders.
He will see
ItemCode, Quantity, Picking, BO and now he must choose each item to send it the dates that indicates and those are < than the date of the 2 next final order date he must complete this procedure till Order Approval Month1 Date.

In each line he completes the quantity that he wants to be delivered in the date and branch that he wants also the same for the BO. If he not want BO then he did not request the quantity to be delivered.
He can split the picking or bo quantity to his branches but never allowed to add or leave quantity without choosing where to sent!

After he submit the order and order date is < Order Approval Month1 Date then we have also another csv with the same format

Username,yearmonth,
Linenumber,Itemcode,quantity,Picking,BO,Address,PickingQ,Date,BOQ,Branch1 ,PickingQ,Date,BOQ,Branch2,PickingQ,Date,BOQ,Branch3,PickingQ,Date,BO


This is just for inform you please post your REAL OFFER
and you must accept to have also some changes due to our new order site!

Thanks for your offers

Skills required:
MySQL, PHP, Web Security, Website Design
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 850
in 14 days
$ 1250
in 45 days
$ 1299
in 22 days
$ 1000
in 15 days
$ 1000
in 8 days
$ 750
in 25 days
$ 650
in 10 days
Hire websree
$ 700
in 20 days
$ 2000
in 30 days
$ 750
in 6 days