Online Merchant ''virtual'' inventory system

Cancelled Posted Sep 14, 2006 Paid on delivery
Cancelled Paid on delivery

goal/objective: for the top 20,000 most popular items in each of the 5 categories of books/music/movies-VHS/video games/DVD's on [url removed, login to view], the objective is to scan the Amazon inventory DB every N seconds and sync the lowest priced item (using a median of the 3 lowest prices at the same condition) in our local DB of "virtual" inventory which we re-price with our own seller name and feedback score. The underlying logic is that some shoppers will pay a higher price to purchase the same item from us as a higher-rated seller. This is a total of up to 100k individual items in our local "virtual" inventory DB at all times. THEN, when a buyer purchases an item from us, the system must then source and purchase that exact item from Amazon/Half, verifying that we make the required minimum markup/profit, or WAITING up to 72 hours to purchase it, looking at N interval, for the minimum required profit. The key elements here are: 1) Our local "virtual" item/inventory DB must be continually synchronized with the same items in Amazon/Half's inventory DB. Therefore, we must query the Amazon/Half inventory DB's with a high frequency, requiring ideally 100k open connections (one for each item in the local DB) every X seconds (default 30) to make sure our estimated source cost for each item is not out of alignment with reality. Since Amazon/Half likely attempt to limit concurrent connections/queries to their inventory DB, we must find a way to anonymously accomplish this. This is the major hurdle of the system, and the most challenging requirement. The other details of what the system must do are in the complete spec. The developer must also agree to 90 days of any required updates due to changes in the Amazon/Half system that necessitate a change in our system, and we are willing to pay a $100/month maintenance fee to perform this "as-needed" work beyond the 90 days.

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):

a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.

b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.

3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

## Platform

the system can either run on Windows server 2000 environment OR on an open-source OS environment such as Red-Hat Linux (whichever the developer prefers in order to achieve the required goals of the project). The important element is that the OS AND DB environments MUST NOT require software that will incur extra cost .The DB server envirnment MUST be no--added-cost, such as either M$ SQL 2000, which we own, or an open-source DB such as mySQL. I own 2 colocated servers and this system will run on one of them. One runs Microsoft Server 2000 as an OS and one is currently "blank" (no OS). They are Super-Micro Quad Xeon servers.

Database Administration Engineering MySQL PHP Software Architecture Software Testing SQL Web Hosting Website Management Website Testing

Project ID: #3796706

About the project

Remote project Active Sep 18, 2006