[login to view URL] Listing/Re-Pricing

Completed Posted Mar 30, 2010 Paid on delivery
Completed Paid on delivery

Basic Requirements:

-Experienced coder with knowledge of [url removed, login to view] that may include any or all of following: Amazon web service, Amazon marketplace service, Amazon API, Microsoft SQL server/client, and database programming.

[url removed, login to view] marketplace listing program

[url removed, login to view] repricing program

[url removed, login to view] web data extraction of [url removed, login to view] product information.

Specific Requirements:

There are 4 elements to the project, all are linked and used with each other (listing program, web search, re-pricer, data base). The Application will be made for windows XP and installed on both the server computer and client(s) computer. We currently are using Microsoft SQL Server 2005 on the server computer for another APP and the client is part of the same network. So these computers are able to share data in this way and we would like to have this new APP do so as well either user same server or some other mehod.

Application is for use in small business and does need to be user friendly but does not need to be visually appealing. Shortcuts/3rd party tools can be used in order to cut down costs and/or time.

## Deliverables

Basic Requirements:

-Experienced coder with knowledge of [url removed, login to view] that may include any or all of following: Amazon web service, Amazon marketplace service, Amazon API, Microsoft SQL server/client, and database programming.

[url removed, login to view] marketplace listing program

[url removed, login to view] repricing program

[url removed, login to view] web data extraction of [url removed, login to view] product information.

Specific Requirements:

There are 4 elements to the project, all are linked and used with each other (listing program, web search, re-pricer, data base). The Application will be made for windows XP and installed on both the server computer and client(s) computer. We currently are using Microsoft SQL Server 2005 on the server computer for another APP and the client is part of the same network. So these computers are able to share data in this way and we would like to have this new APP do so as well either user same server or some other mehod.

Application is for use in small business and does need to be user friendly but does not need to be visually appealing. Shortcuts/3rd party tools can be used in order to cut down costs and/or time.

General Information

-APP should work on both client and server computers. One server and 1 client for now but instructions for installing on additional client computer should be provided.

-Primary purpose of APP is to list individual media items (books, etc) in an [url removed, login to view] marketplace seller account. These books will be entered manually using a list of ASIN#'s stored in two different locations. One from a list of file created using a separate APP and one from a list that is entered directly into the APP to be created here.

-Refer to the Sample Interface Attached for this project. It gives a "General Idea" of what should be included. However, the formatting, style, and location of the different elements of the interface can and should be adjusted as necessary.

-On the APP interface will be a listbox, check box, etc that will allow the user to select between Two Different Lists. Refer to the sample User Interface where it say "Search ASIN". Below this you see "From Saved File" and "From APP". One of these should always be selected with "From Saved File" by default. Where it shows "#" below both of these you should show the # of ASIN#'s remaining in both lists.

1) Listing by ASIN/ISBN# from saved File

-A separate Application will be used on client computer (not part of this Bid Request and done by separate party) will create and save a file on Server computer. This file must be accessed from both server and client computer. This file does not have a format yet and the coder may request the format type. What the file contains is simply a list of ASIN/ISBN#'s. Nothing else. This list of ASIN/ISBN#'s can contain up to 1000 but more than likely will be around 100.

-When this file is added to through separate APP the # of adjusted ASIN/ISBN's should be displayed.

2) Listing Directly through APP

-On the interface you will see a button that says "Add ASIN/ISBN". The user should be able to type in or PASTE an ASIN/ISBN# directly into the box just below it and this # should then be stored in the "From APP" data base. Display the adjusted # of ASINs.

3) Bringing Up Product Info

-Besides the way these two retrieve the ASIN/ISBN#'s they act the same way in terms of listing books.

-When the user opens the APP the first ASIN/ISBN# book in the APP's memory is brought up. At this time the APP queries Amazon and brings forth various information about the ASIN# and displays it in the PP. It displays the Title, Author, Year Published, Publisher, Binding, Amazon Price and Image. This info is all shown in the top left side of the APP as shown.

Note: Amazon Price is the price Amazon is seeling the book for. This price should ONLY be displayed if the book is in stock and ships within 2 days (ships within 24 hours OR ships within 1-3 Days).

At the same time the Title of the ASIN/ISBN should be displayed in the search bar located on the very top right side of APP. Just below where it says "Amazon Web Search".

4) Web Search

-Once the title is displayed in the search bar the user can click the "search" button to do a search of Amazon's catalog. The search bar should be able to modified in any way like a normal search bar.

-Now, there are two options with this APP and the coder can use whichever works. I am unsure what is possible so this is left up to the coder to determine.

1: Search directly on Amazon using a browser. Only problem here is if it is possible, as results in search need to be manipulated on browser and am not aware of feasibility.

-If done in this manner than results should be brought up just like any normal search on Amazon. Then user can click on the specific book link (title or image) to bring up the Book product information page on Amazon. Then this book's information (title, author, publisher, published date, binding, image) will then show up in the bottom left side of APP under (Select Book).

Note: In this "search directly on Amazon using a browser" option then Binding, year, amazon price information shown in the bottom left should NOT be there. This is for the second option only. The user should instead use the "Binding List" shown directly on the Amazon page.

From here the user can click on the specific book "binding" from the list shown in the box (hardcover, paperback, etc). If the user does select one from here then the same book info (title, author, etc) again shows under "Select Book" in the bottom left area of APP. When this info is displayed from this point forward the APP works exatly the same as "Search using Amazon Web Service/API".

2: Search using Amazon web service/API, etc.

-In this method a search must still be used searching Amazon's catalot using the search bar. The appearance/amount of info retrieved however can be much simpler. However, it should still search the catalog in the same way a normal search does...using a title. Searches only need to be performed searching "books".

A) 6 Results should be retrieved with the following information only (title, author, publisher, published date, binding, Amazon Price, and image).

Note: Amazon Price is the price Amazon is seeling the book for. This price should ONLY be displayed if the book is in stock and ships within 2 days (ships within 24 hours OR ships within 1-3 Days).

B) The title should be clickable.

-If the title is clicked on these same results should be displayed under "Select Book"...in the same way as above. Title should remain highlighed until another book is clicked.

C) When a book is highlighted any additional "bindings" of the book should be displayed under "Select Book".

-Refer to [url removed, login to view] on how these additional bindings are displayed. For our uses the only information that needs to be displayed is the binding, year published, and [url removed, login to view] price

-If there is not a year or price display nothing or a "-".

-If there are multiple of the same types of bindings (like hardcover) use a tree view style so more can be opened.

-Users should be able to click on any of these bindings and then the results should replace the original bindings' results under Select Book (binding, titel, author, etc)

5) Selecting a Book

-If either method above is used the object is to get a book's info displayed under "Select Book" in the bottom left hand area of the App.

-When the user clicks the "Select" button then the APP must retrieve certain product information from Amazon and compare it to the "Listing Rules" set forth by the user (see "Set Listing Rules") in order to set the Minimum/Maximum prices to be used for the Repricing program.

-The information that it needs to retrieve is:

A) Search New & Used Listings of book to find:

1. First 3 sellers that have 98% or above Lifetime Feedback rating selling Good condition book or Better (Good, Very Good, Like New, New)

-Retrieve the selling price of the highest price of these 3 and store it.

2. First 3 sellers that have 98% or above Lifetime Feedback rating selling Very Good condition book or Better (Very Good, Like New, New)

-Retrieve the selling price of the highest price of these 3 and store it.

B) Store Amazon Price

Note: Amazon Price is the price Amazon is seeling the book for. This price should ONLY be displayed if the book is in stock and ships within 2 days (ships within 24 hours OR ships within 1-3 Days).

Refer to "Set Listing Rules" to see how this information will be used.

6) Binding Type

-User must select a Binding Type as indicated on the sample User Interface. By default have it set to Hardcover.

7) Textbook

-User must select if Textbook or Not. By default have it set to "no"

8) New/Used

-User must select if book is used, new, or both. By default have it set to New

9) Set Listing Rules

-When this button is clicked on a popup window should appear that allows the user to select various criteria used for listing and re-pricing books.

A) Book Descriptions

-User should be able to type/paste in a variety of book descriptions that will be saved in the APP and automatically placed in the comments of the books Listed. The user MUST type/paste the following descriptions:

New Hardcover

Used Hardcover

New Paperback

Used Paperback

New Audio Book

Used Audio Book

New Other

Used Other

New Hardcover Textbook

New Paperback Textbook

Used Hardcover Textbook

Used Paperback Textbook

-Refer to "List Book" for how this information is stored.

B) Set New Book Minimum/Maximum Price

-Here the user must enter a variety of #'s into some text boxes and these #'s are stored to be used later (these #'s can be positive or negative). The text boxes should be empty and be proceeded by another # that identifies them. There should be two text boxes following the # identifier. One for Minimum price and one for Maximum.

These #'s are: 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31-40, 41-50, 51-60, 61-70, 71-80, 81-90, 91-100, 101-110, 111-120, 121-130, 131-140, 141-150, 151-160, 161-170, 171-180. One for each minimum and maximum= 80 Total text boxes.

For example, "6) [ ] [ ]"

C) Set Used Book Minimum/Maximum Price

-Do the exact same thing for used books as new except include the following #'s: 0, 1, 2, 3, 4, 5. For a total of 92.

D) Set New Book Quantity

-Enter a # in the text box to be used for the quantity value of new books

E) Set Used Book Quantity

-Enter a # in the text box to be used for the quantity value of used books

10) List Book

-Now that all the information is saved and selected the book can be listed in the Data Base and used for repricing.

-When the user selects the "List Book" button the APP checks various information found and stored and then lists the book on Amazon for sale, as well as setting up the Minimum/Maximum price to be sold for (for repricing purposes).

A) List all general book info

-If "New" or "Used" is checked by the user than only one listing is created. If "Both" is selected than both new and used listings are created. They should both be created at the same time based on information entered/stored by user and collected by the APP.

-List anything associated with the ASIN/ISBN# of the book. This includes title, author, binding, etc. Whatever is needed to create a listing.

-Create a unique SKU for the listing or listings.

-Assign quantity for Used/New or Both of listing(s) created based on input in "Set Listing Rules"

-Assign description of listing(s) based on user input in "Set Pricing Rules" and what they selected for "Binding Type" and "Textbook".

-Assign Minimum and Maximum price based on information retrieved during Web Search, #'s entered in "Set Listing Rules", and if book is a Textbook.

Textbook:

-If Texbook = Yes then use the "Good Condition" results found during the Web Search for USED listings.

-If Textbook = No than use the "Very Good Condition" results found during the Web Search for USED listings.

Finding Used Condition Minimum & Maximum Price:

-Take the used book price found from the seller and compare it to "Set Listing Rules" set by user. Always ROUND UP to the nearest dollar.

For example, if the book is a hardcover non textbook and the price of the highest of the 3 sellers is $5.55. Round this up to $6.

-Now locate the stored price rule for $6 and the two #'s stored by the user for used books. Use these two #'s for the Maximum and Minimum price for the repricer.

-The listing created should be for Very Good because it is not a textbook.

-The comments should be for a used hardcover stored.

Finding New Condition Minimum & Maximum Price:

-Take the new book price found from Amazon and compare it to "Set Listing Rules" set by user. Always ROUND UP to the nearest dollar.

For example, if the book is an Audio Book with found value sold by Amazon of $22.50. Round this up to $23.

-Now locate the stored price rule for $23 and the two #'s stored by the user for new books. Use these two #'s for the Maximum and Minimum price for the repricer.

-The listing should be for a New Audio Book.

-The comments should be for a new Audio Book.

Important: When a book is listed it should be listed in one of two separate Data Bases (two data bases should be created).

-Any listing created using "From Saved File" should be stored in the Client Data Base.

-Any listing created using "From APP" should be stored in the Server Data Base.

--The reason for this is that the two separate Data Bases will be using different repricing rules.

-Note: Users may enter in new ASIN/ISBN #'s into APP using either the server or client computer for the List. They may also List books from either the Server or Client and they must be sorted accordingly.

THE LISTING SHOULD NOW BE CREATED AND LISTED ON AMAZON AND IN THE DATA BASE.

Repricing:

-Under "Set Pricing Rules" the user may enter the pricing rules.

-Note: The rules for repricing must be set for the Server Data Base on the Server computer. The rules for repricing must be set for the Client Data Base on the Client computer.

Rules are fairly simple.

1) Exclude my store name for pricing against. If I have multiple items in stock I do not wish to reprice against myself.

2) Have a +/- list box for price. Should be default of "0". Then can go up/down in increments of "1". (Up = 1, 2, 3) (Down = -1, -2, -3).

-If 0 then repricer should match lowest price.

-If -1 then repricer should go 1 cent below lowest price

-If +1 then repricer should go 1 cent above lowest price.

3) Set auto reprice to Yes/No

4) Set auto reprice to either 15 Minutes/30 Minutes/45 minutes/1 Hour

How to Reprice:

1) Repricer should reprice against lowest price for same condition. For example, if the book is new price only against new condition books. If the book is used reprice only against used condition books.

2) Repricer should be very quick and allow repricing every 15 minutes. Very important it be quick.

-Repricer should query Amazon to get must recent prices and then begin repricing.

-Repricer should not get slow because of # of inventory items. Even with many thousands of listings repricer should be as quick. If this requires using a server other than local server or some other method this is something that needs to be worked out.

-Repricer should reprice client with client's pricing rules and server with server's pricing rules.

-There should be an AutoRepricer that allows options of how often to reprice. This time period should be able to be different for both client and server data base.

The Data Bases:

-The Data Bases on both the Server and Client computers should have Data Bases that can be viewed and updated.

-The information the Data Base should show (in this order) is Title, Binding, Condition, Minimum Price, Maximum Price, ASIN/ISBN#.

-The Minimum and Maximum price fields should be able to be adjusted to anything. When adjusted the adjusted # should be saved for data base.

-There should be a "Update Data Base" button at the top of data base.

---When the user decides to update the Data Base what it does it check all listings in the data base against Amazon's catalog & against my current listings.

1) Against Amazon's Catalog

-If any of the ASIN#'s in the Data Base are no longer in [url removed, login to view]'s catalog then the listing should be removed from the Data Base.

2) Against my Current Listings

-If any of the listings currently have a Quantity = 0 in my currently listings of my marketplace account then remove the listing from the Data Base.

Adding Existing Inventory to Data Bases:

-Currently our inventory to be repriced is kept on 3 separate computers. We are using Aman Pro ([url removed, login to view]) to reprice inventory and all the pricing rules (minimum/maximum prices) are kept here.

-What we need to do is get these files and transfer them to the new Data Bases. And take the necessary information ONLY that is needed (the information that is stored in new Data Bases, including the minimum and maximum price settings)

-I am unsure of the current file format or files need and may need assistance in this area. Also, am not sure what the best way to get the saved files to the right computers is. Probably just send them through internet and then save them on correct computer.

-Currently one of the computers with AmanPro files is the server. The files from this computer should be saved in the new Data Base on server.

-Another computer with AmanPro is not part of the Network. These files need to also be saved on Server computer.

-Another computer with AmaPro is not part of the Network. These files need to be saved on the client computer (not this computer).

End...

Amazon Web Services Database Administration Engineering Microsoft MySQL PHP Project Management Software Architecture Software Testing SQL Windows Desktop

Project ID: #3305631

About the project

9 proposals Remote project Active Apr 28, 2010

Awarded to:

silverglass

See private message.

$1445 USD in 14 days
(12 Reviews)
5.8

9 freelancers are bidding on average $1409 for this job

eye4tech

See private message.

$3400 USD in 14 days
(40 Reviews)
7.0
stephen85

See private message.

$552.5 USD in 14 days
(153 Reviews)
6.0
jayawardanajapan

See private message.

$680 USD in 14 days
(18 Reviews)
5.0
racddd

See private message.

$637.5 USD in 14 days
(5 Reviews)
2.1
webgoldsolutions

See private message.

$1207 USD in 14 days
(2 Reviews)
0.0
coderscentral

See private message.

$2125 USD in 14 days
(1 Review)
0.0
amitusaineu

See private message.

$1530 USD in 14 days
(0 Reviews)
0.0
gvays

See private message.

$1105 USD in 14 days
(0 Reviews)
0.0