Project Detail
multi vendor inventory collaboration/managment sys
multi vendor inventory collaboration/managment sys is project number 20329
posted at Freelancer.com. Click here to post your own project.
Bid Count: 52
Average Bid:
$ 2345
07/13/2005 at 1:13 EDT
Project Creator:
mattl
Employer Rating: 
(11 reviews)
Description
We seek the design of a custom built inventory collaboration system to synchronize product availability (stock levels, backorder status, etc), pricing, etc. from multiple sources/vendors in a variety of formats.Currently we maintain a centralized database containing among other things, product data (skus, prices, local stock, brand, etc) we are looking to map both new and existing products in our product database (over 2000 skus) to the data representing that particular product in the vendor feed. Currently most vendors adhere to a specific naming convention and offer a large variety of product data fields containing information useful for mapping (such as brand names, and SKUs, model numbers). It is important that products can be easily automatically mapped, and that there is an efficient interface for managing questionable mappings, manual mappings, etc.
Because we are looking to get a working product as soon as possible we want to start with the most simplistic implementation for gathering vendor data; delimitered feeds.
Currently a good number of the vendors we work with have delimitered feeds that are available on their website for download or are emailed to us. These feeds are usually available in either Microsoft Excel or Comma, Tab, or Pipeline delimitered plain text files. Each of these files are in a different format, contain a wide variety of different products, and related information. We want an interface that will allow us to easily map/assign the columns and field data found in the feeds to the appropriate matching indexes such as SKU, Brand Name, Product Name, Price, Stock Quantity Available, Model Number, UPC, etc. In short, we dont want to have to employ a programmer to add a new vendor feed each time we add a new vendor.
The end result is we would like a database with the compiled information from the product inventory feeds available for access in real time via several efficient sources such as an ASP/VB/etc script or component and/or static html result page generation to facilitate the output display to both the public, as well as internal employees. We would like this script to integrate with our local purchasing database to reflect vendor and recent product purchase information into the results for internal employees. We want the capability to include in the query of availability for a product to reflect recent purchase information for vendors not available in the product availability feeds as well. Additionally we need a script that will identify whether a product is in stock using defined parameters and write to our items database with a simple yes or no for each product. (this is used internally)
There should also be a simple administration interface to configure all of the vendor feeds, item attributes, mapping data, trigger feed parsings, etc.
After this has been developed successfully we would like to add additional methods of harvesting vendor data such as: XML Feeds, Vendor Web Site Login, Navigation, & Spidering/crawling, vendor website/email system for manual communication of product availabilities). We would also like to consider building automated tools for the routine gathering and parsing of these vendor provided feeds from ftp sites, web sites, and email drop boxes (file attachments), etc.
Example output for our website(s) will vary on product and category such as:
Stock: 41 Units In Stock (Numerical Sum of all inventory and plain text identifier in stock)
Stock: In Stock (just plain text identifier in stock)
Stock: In Stock Click for more detailed information
41 Units in Stock
New Jersey 12 Units
California 14 Units
Illinois 15 Units
Example output for our internal sales employees to check availability on a product will read:
Product: : TH42PWD7
Category:
Brand
Stock: 41 Total Units In Stock
CDW Wayne, New Jersey 312-555-1212 12 Units (as of 06/10/05 3:12pm)
Tech Data Culver City, California 305-555-1212 14 units (as of 06/10/05 3:12pm)
Ingram Micro Chicago, Illinois 312-555-1212 15 Units (as of 06/10/05 3:13pm)
Example output for our allocation / purchase managers will read:
Product: : TH42PWD7
Category:
Brand
Options:
Stock: 41 Total Units In Stock
CDW Wayne, New Jersey 312-555-1212 12 Units - $2199 (as of 06/10/05 3:12pm)
Last Purchased: 05/01/04 PO#34013 1pc (closed)
Tech Data Culver City, California 305-555-1212 14 units - $2119 (as of 06/10/05 3:12pm)
Last Purchased: 06/10/05 PO#50121 3pc (open)
Ingram Micro Chicago, Illinois 312-555-1212 15 Units - $2045 (as of 06/10/05 3:13pm)
Last Purchased: 06/02/05 PO#50004 $2099 1pc (closed)
Unverified Vendor: Bob & Mas TVs
Last Purchased: 06/02/05 PO#50004 $2089 1pc (closed)
Detailed Product Summary: last 30 days
Total Sold: 235
Total Purchased: 258
Last Open Purchase: 06/15/05 CDW PO#34013 $2199 1pc
Last Closed Purchase: 06/07/05 CDW PO#32014 $2199 1pc
Additional files submitted:
invapp.doc
|
Job Type |
|
Provider Rating
WHAT IS FREELANCER.COM?
Freelancer.com is a global outsourcing solution and freelance jobs website. Here you can find freelance coders, writers, programmers, designers, marketers and more. You can also outsource projects and save a lot of money in the process. Getting the best web design, professional programming, custom writing or affordable marketing has never been easier!
We have thousands of satisfied clients from every corner of the world. Would you like to outsource your next project? Would you like to find freelance jobs and make money online? Just sign up to get started!
Outsourcing jobs is the process of hiring an outside company or individual to complete your projects. We have created a safe environment for both service buyers and service providers via our secure payment system. You outsource the project and don't release any money until you're satisfied! Try outsourcing for free today! Don't forget to bookmark our homepage for your next project or job.
- Plendo Sweden AB © 2004-2009
- PRIVACY POLICY
- TERMS
- AFFILIATES
- API
- QUOTES
- CONTACT
Freelancer™ is a trademark of Ignition Networks Pty Limited (ACN 134 845 748)
Newly Outsourced Projects fed by 
Follow our Freelance Jobs on Twitter 
Add to your
Google search results