[login to view URL] Order Management

Completado Publicado Sep 5, 2009 Pagado a la entrega
Completado Pagado a la entrega

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 [url removed, login to view] 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 [url removed, login to view] 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...

PHP

Nº del proyecto: #2866555

Sobre el proyecto

13 propuestas Proyecto remoto Activo Sep 9, 2009

Adjudicado a:

hyashaswi

See private message.

$1275 USD en 14 días
(32 comentarios)
5.6

13 freelancers están ofertando un promedio de $2035 por este trabajo

allenjonessl

See private message.

$5907.5 USD en 14 días
(191 comentarios)
8.1
skylane

See private message.

$850 USD en 14 días
(277 comentarios)
7.7
ksil

See private message.

$850 USD en 14 días
(144 comentarios)
7.7
ian11

See private message.

$1020 USD en 14 días
(54 comentarios)
6.0
webexpertzz

See private message.

$3910 USD en 14 días
(82 comentarios)
5.8
Robotapps

See private message.

$2720 USD en 14 días
(101 comentarios)
5.4
venturekeen

See private message.

$1530 USD en 14 días
(15 comentarios)
5.1
webhighway

See private message.

$3400 USD en 14 días
(10 comentarios)
4.8
SajidYousuf

See private message.

$765 USD en 14 días
(16 comentarios)
4.5
Agrippasf

See private message.

$1810.5 USD en 14 días
(7 comentarios)
3.8
erbconsulting

See private message.

$637.5 USD en 14 días
(6 comentarios)
3.0
frosensl

See private message.

$1785 USD en 14 días
(0 comentarios)
3.5