Amazon.com Order Management

Qualified coder required for server based application that can be used on the web (although only for private use). There are three separate parts of this application, all related/linked to one another. 1) Process Orders The application will need to take orders directly from my [login to view URL] seller account and display them in the web application. 2) Print Labels The application will be able to take the processed orders and display them on another page. From here the user can print small laser printer labels indicating what item is to be shipped. 3) Ship Orders The application will be able to display unshipped orders and automatically copy addresses that will then be pasted into my (separate) shipping software. Printing shipping labels IS NOT part of this application. There will many features to each of these applications to make their use quick and user friendly. ## Deliverables The application needs to create a server program to be set up on one computer and run on two others via the web. And I will need help setting all this up. Detailed help with setting up the server and web page(s). First, the application will need to retrieve order information from my [login to view URL] selling account. This information is then displayed on the first form/database of the application, called "Order Processing". ** Order Processing Data Base:** 1) What orders are displayed in the Order Processing data base? -Any orders moved from the data base into the Label Printing Data Base or Shipping Data Base. 2) How is the Order Processing Data Base first populated with orders? -An option at the top of the application will be present that allows user to select "Import Orders". Clicking on this will bring up a calendar/date range to select to import orders from. The app should then import ALL orders within that date range (based upon when the order was PLACED). 3) Displaying Orders -The following information should be displayed in the Order Processing Data Base. 3a) Title (The full title of the book)-should have a clickable link that will open up a web page to the Amazon product 3b) Address (Full address of buyer) 3c) Price paid (only the item price...not including shipping and not "total". 3d) Shipping type/speed (Standard, expedited, or international)-international should be determined by if the price paid per item is $12.49. 3e) Purchase Date 3f) Ship Date 3g) Quanity 3h) Condition (new, very good, etc) 3i) Condition Notes (there can be a mouseover to see full notes) 3j) ASIN# 3k) Buyer's Name 3l) Binding (binding is not visible sometimes on order page but should be able to obtain using keyword search of title or ASIN# and Amazon web page...?) 4) Additional Layout Details -Orders should be grouped together in a certain way...based on certain criteria...going from most important to least (below) 4a) Order Date -Always group orders based on oldest first (then sub-divided below) 4ab) Sub-divided into shipping class -Expedited grouped together at top, Standard and International grouped together below expedited 4aab) Sub-divided by binding -Hardcovers at top, paperbacks next, unknown binding next, audio cd's & cd roms grouped together next, and anything else last 4aaab) Sub-divided by alphabetically *Order Processing Data Base Features/Use:* 1) Highlight Order -Should be able to highlight/click on order 2) Once highlighted -Full shipping address should be displayed if not already 2A) Address Use -Address should be broken up into 4 lines. F1 Copies the first line (to be able to paste on to another app) F2 Second line F3 Third line F4 Fourth li 2B) Hit Return/Enter once title highlighted to bring up Message Box -Message Box displays 2B1) Processed (P), Shipped(S), Cancel(C)? -user clicks on letter of choice 2B1A) Processed -Brings up another message box (closes first) --check below for "Message Box 2" 2B1B) Shipped -Deletes title and information from data base (title is no longer needed for anything) 2B1C) Cancel -Message Box is closed. Nothing else happens. Message Box 2 2B2) Arrival Date -Brings up calendar from date of order to 7 days from order. User selects one of these dates with mouse and date stored by application. -have option to cancel like first message box -Then 3rd message box brought up Message Box 3 2B3) Shipment Type -Show list of options to choose from (select #)-also have option to cancel and go back to data base. Store string selected based on # selected 1) Standard Box, 2) Standard Mailer, 3) First Class, 4) Priority Envelope, 5) Priority Box, 6) First Class International, 7) Priority International After this # is selected the title and all display information is moved (along with information stored from message boxes) to the Label Printing Data Base. 3) Key word search -Have the ability to search by keyword 4) Store two values for copying -Have two boxes at top of application where strings can be entered. -click in boxes and type text -Pressing F5 copies the text in first box -Pressing F6 copies the text in second box --copies text can be pasted in another app **Label Printing Data Base:** 1) Displays all orders that have been moved from Order Processing to Label Printing 2) Information/Titles should be displayed just like Order Processing with the exception that it should show the information obtained from message boxes 2 & 3 (Arrival Date & Shipment Type) 3) Additional Layout Details -Sort by Arrival Date First (at top) -No other sorting necessary 4) Features/Use -Click "Print" button to print labels for a specific day or group of days. Bring up calendar. Confirm or cancel...if confirm print labels for the day (s). Labels to be printed are for a laser printer (small size shipping labels?). Exact size will be advised. Information Printed on labels: -Print labels based on arrival date first (latest date first up to earliest date), and alphabetically second a) Title (item title) b) Arrival Date c) Package Type (standard box, priority envelope, etc) d) # between 1-1000 -Start first print at 1 and print each label one # higher (1st label = 1, 2nd label =2, etc) --Keep track of this # in database even if finished printing for the day(keep same # for next printing session)... ---Once get to 1,000 start over again at 0 5) Keyword search option at top 6) Once labels have printed for the day move ALL titles printing and information to the "Shipment Data Base" ** Shipment Data Base:** 1) Displays all orders that have been moved from the Label Printing data base 2) Information/Titles should be displayed just like Order Processing with the exception that it should show the information obtained from message boxes 2 & 3 (Arrival Date & Shipment Type) 2A) Also display # generated in Label Printing Data Base (between 1-1000) 3) Additional Layout Details -Sort by Label Printing # (between 1-1000) 4) Should be box at top that says "Shipment #" -Cursor should always rest here. Hit Tab to bring cursor here if moved -Enter # in box and it highlights corresponding title (between 1-1000) 4A) Press enter and address is brought up in message box and automatically copied (to be pasted) or press F1 or to copy. -Also, in message box select either Shipped(S) or Cancel(C) --Canceling puts cursor back in original box...no title highlighted -If Shipped(S) then item is removed/deleted from data base...cursor back to home. 5) Keyword search Finished...