osCommerce Service Order Entry/Tracking

Project Goal: Develop a Service Order entry and tracking system for osCommerce. DO NOT BID UNLESS YOU READ AND UNDERSTAND THE PROJECT DOCUMENT. *** [login to view URL] *** 1. Customer and Admin must be able to create a Service Order Request. Customer prints service request and sends with order like RMA. (Printer friendly and/or PDF format) ***This needs to be as simple as possible to reduce the hassle for the customer. 2. Shipping/Receiving When the product arrives, the shipping department receives it, scans the included Service Order barcode. We'll handle the barcode function, we just need it on the Service Order. There should be a page/function for the shipping department that enables them to enter the Service Order number and see the details of the order. The next step must enable the shipping department to enter serial numbers for the equipment that has been received or VERIFY the serial numbers submitted by the customer. Shipping department will have Comments Section to document issues such as incorrect serial numbers sent by customer, etc. 3. Repair Tickets A Repair Ticket number will be created that is "Order ID.Serial_Number". The shipping department must then be able to print Repair Tickets that will be attached to each piece of equipment while it is in the repair facility. Each Repair Ticket will function like a "Product" in the normal osCommerce products/orders system. When a customer views the details of a Service Order, they will see each Repair Ticket. Each item on the repair ticket (parts and labor) will be displayed like Product Options are displayed in the normal osCommerce system. When a repair ticket is created, a list of other repair tickets with the same serial number must be displayed on the repair ticket screen (linked so the technicians may review them). 4. Repair Ticket Entry Page. Technicians will only be able to ADD products/procedures - not remove. All items added to the repair ticket will be a permanent record. Admin/Techs can print repair ticket as a whole with all notes and comments. As new item is added to the repair history, and new row is added for the next item. Repair ticket comments will only be visible in admin. See example in 050720_service_order_system.pdf. 5. Service Order Packing Slip Only Procedures/Parts will print on packing slip. (Printer friendly, No prices, No comments, etc.) 6. Repair Ticket Administration Admin must be able to add/edit repair service items, status levels, accepted manufacturers and return reasons. There should be a page that enables the accounting department to edit the prices and status of repair items. More details below. SPECIAL CONSIDERATIONS I have a highly modified osCommerce installation To aid in keeping all the modifications organized some additional commenting will be required. Please consider these additional requirements when bidding. 1. List of all modified/added files. 2. Commenting all changes with // MOD-NSSO Start/End which designates Net Step Service Order. You may add your company name to the comment if you want // MOD-NSSO - YourCompany Single line changes will be /* MOD-NSSO */ to speed things up a bit. 3. TXT files with all mySQL statements must be sent to me for installation. I'll be available constantly, so this should not cause a delay. 4. Admin Access Your own Working/Testing Environment: I will make a copy of my site for you to FTP directly to for installation and testing to ensure the modification works properly with the other installed modifications. You will be able to test the system with a copy my real data so any issues with managing thousands of products can be addressed.