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