277745 Order Manager Phase3
N/A
Pago na entrega
1) Builed an online form to show all pending order. Needs to excluded orders that have been shipped or cancelled.
2)Connect the online order form to stoneedge inventry table if no stock is found then to search product manager to check for stock order need to map to supplier who has the cheaps price and stock.
The system need to do stock checks at 7AM and at 12PM and move orders to fit stock and prices.
3)Any Orders that are out of stock need to be moved to a new page called out of stock were our purchasing team will update the system with ETA dates.
If an order is marked out of stock it needs to update the in house order page with the line that is out of stock and also update on the customer online search page to advise this out of stock item. It will also show the ETA that has been entered in the out of stock page. The order noted will also be automaticly updated to advise in house staff when the stock is due.
4) The system will also check product manager at 7am and 12pm every day with suppliers to see if stock has arrived.
If stock has arrived it will move the item to the back in stock sheet and update the order to say in stock.
5)All items that are in stock and have been mapped to a supplier based on stock and pricing the system need to set these out as a PO which will be sent to the supplier.
Any items that are not completed will stay in the system and stay on the current stock and pricing check.
6)If a customer has more that 1 line on there order and let say 1 item is out of stock we need to transfer the whole order to the back order sheet as we do not ship orders that have missing items. The system will changes the status to out of stock and update the notes. How ever in house staff will be able to see next to each line which items are in stock and which items are out of stock. The customer search page will just show out of stock with the ETA entered in to the system.
7)As we have budgets we set every day for buying stock from our suppliers i need a way to put in to the system for example i want to spend £10000 today the system will filiter all in stock items for all suppliers and try and complete as much as possible based on the budget. Once the system has complied this infomation it will flagg up to say which suppliers it is completing how much it is spending with each suppliers with an option for us to hit complete. Once we hit complet it will create the PO and email it to the supplier. If the supplier does not have an email address it will print the PO of for faxing or posting. The system needs to keep a record of every PO sent to suppliers for future ref or for duplicate issuing or printing.
8)We also need to option in the PO to move an order to drop ship. This means any lines that are cheaper to send from suppliers we need to be able to override the system to send the order to supplier on some lines as drop ship. This will email the order over to the supplier with the customer detials of were it is being shipped to.
9)We need a page building to show all our suppliers and when you click on the suppliers name it will give you the full address detials and contact detials this infomation will be used to email PO over to suppliers.
10)All PO and Dropship forms needs to be the same as stoneedge forms.
11)We need a report for purchasing so we can working out the profit of each order based on the cost of purchasing. The system will show line by line each product sold and the cost we have sold then for then it will add what it cost to ship the item and what we can sold the item for and work out what we have made on each product sold. The system need to do this on a daily bases and save the reports so can go back late and say for example i want all orders report between 12-15 december 2008 it wil then show then on screen with an option to send them to CSV or PDF for printing.
12)In the in house customer order form the print button needs to be set up so we can email invoice to the customer in PDF for orders marked as shipped.
13)In House customer order page the email link needs to be set up so we can email the customer. This will have a drop down of selected email templates which will be used to email the customer. All emails which are sent will be recorded in the email notes on this page.
14)CC Termainal Needs to be setup. Please use the code from stone edge to connect to paypal web payment pro. Need an option to select lowcostink or cck terminal.
15)If a customer credit card is delined we need to mark the order as payment delicined. in the in house form and customer search an customer search page and email will be sent also. We try all cards three times if the order does not go through the customer order status will be changed to cancelled payment declined. Emails and order notes need to be updated on each stage.
16)Need an online form to update stock in house in to the stoneedge product inventry table for orders.
17)Need an online for for customers to rase returns for fault or unwanted products. The system wil work like this. For unwanted items the system will check the date the order was shipped and then add 10 days to the date. If the item is over the 10 days the system will reject the return and advise the customer we are not able to accept this return. If the customer is within time it will ask a few more question ie is the order still in unopen packaging or has the packing been opened. If the customer section option two
then it will reject the return and advise why. If the customer meets our returns policy then the system will allow for the return to be accepted. If for any reason an order is refused by the return system the order notes need to be updated with the same reason it gave the customer for rejecting the return. If the return is accepted and system will create an pdf which will be emailed or printed from our site this will be an address label. The address lable will have a bar code which is this customer return number which they
will need to add to the front of the parcel being retunred. The system noted will also be update with this infomation. Once receipt of the customer order we need a returns screen were this bar code will be scanned and the customer detials will come up on screen and the return person will mark the return as received. This will email and update all the notes on the system. If the item is faulty and customer is to receive a replacment the system will flag the order back for product manager to check stock and the order proccess will start again. The fault item will then be mark as returned to suppliers with our track number on the notes for internal use.
ID do Projeto: #2024033
