In Progress

multi vendor inventory collaboration/managment sys

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 don’t 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 & Ma’s 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

Skills: .NET, ASP, C Programming, Visual Basic, XML

See more: working seek, work illinois, website jersey design, website page managers, website design chicago, web seek, web programmer tools, vendor product, us seek, useful website programmer, tvs design, total tools, the seek, static interface, sources format, sites login html, seek us, seek site, seek on, seek login page, seek login, seek local, seek it, seek information, seek employees

About the Employer:
( 19 reviews ) brooklyn, United States

Project ID: #20329

Awarded to:

teckit

Hello I read all you requirements and will provide a solution that will meat those requirements plus it will be flexible enough to add more or change them as you business changes

$2000 USD in 60 days
(15 Reviews)
6.2

51 freelancers are bidding on average $2367 for this job

siddhartha1

Dear sir, we have gone through the details and assure you of doing the project with quality,pls contact us via pm to discuss further,thanx

$2500 USD in 50 days
(19 Reviews)
7.2
secom

hi we can help you to get it done.

$3000 USD in 60 days
(69 Reviews)
7.0
evsoft

Hi! Please see PMB for surther details. Regards Adeel (BDE-ISF)

$2000 USD in 30 days
(9 Reviews)
6.8
rajelensoft

Dear Sir, please check your pmb for details. regards, raj for elensoft

$3000 USD in 30 days
(9 Reviews)
6.4
surajitmitra

Greetings, The application as specified can be made in 45 days. I can get started as soon as you award the project. Please view PMB for further detials. Thanks and regards Surajit Mitra

$2250 USD in 45 days
(6 Reviews)
6.3
websoftech

Plz check PMB

$2250 USD in 15 days
(3 Reviews)
6.3
riazi

I have developed many systems and applications both standalone and web based. I can do it for you with best resutls.

$3000 USD in 50 days
(27 Reviews)
5.9
Spin

We will doing all that you want (and more... :-))). Quickly, Professional, Quality - our answer you and your organization. There are questions?

$1800 USD in 25 days
(2 Reviews)
5.9
imarims

You will benefit for sure from our experience.More info via PMB on demand only.Regards Marius.

$3000 USD in 30 days
(5 Reviews)
5.8
encodedart

Our Company is software and web site development company base in Toronto, Canada. Our team is highly innovative and professional. At EncodedArt client’s dead line, quality work and effective cost are our first priori More

$2000 USD in 30 days
(3 Reviews)
5.5
sphereidc

Dear Sir, We thank you for the opportunity to bid on your project.Details in PMB. Regards, Vijay Rao. SphereIDC.

$2400 USD in 35 days
(1 Review)
5.2
ciplindia

Dear sir, We are really very happy to say that we have already developed Stock Management System(PC based), Inventory Management System (Web Based). So we have a deep knowledge & experience of such applications. More i More

$3000 USD in 90 days
(1 Review)
5.1
izwan00

I can do it for you. Please contact me soon.

$1000 USD in 60 days
(17 Reviews)
5.2
nidle

Dear Sir/ Madam, We got extremely interested in the project proposed by you. We are an IT company specializing in web technologies and programming. Our specialists are ready to start working on the required inventory More

$3000 USD in 55 days
(1 Review)
4.8
eenavin

i will prefer c/c++ .

$2500 USD in 60 days
(3 Reviews)
4.7
viaden

Dear Friends! We've gone through your description and are ready to create the most unique and professional multi vendor inventory collaboration/managment system with all the features you require. Our company has bee More

$3000 USD in 60 days
(1 Review)
4.7
vyasINFOTECH

Hi, We take this opportunity to introduce ourselves as Vyas Infotech Private Limited, ISO 9001:2000, 14001 Certified IT Solution Provider Company based at Ahmedabad, India. Though we are new at Getafreelancer, we are More

$1200 USD in 40 days
(4 Reviews)
5.1
WebIntegrated400

Do not sacrifice quality for cheap promises. Please view pmb for complete bidding details and allow Web Integrated weave your inspirations.

$3000 USD in 45 days
(1 Review)
4.2
auraspan

Sure can create the mapping product with ease

$1900 USD in 21 days
(5 Reviews)
3.6
ebusiness2

Our bid is for really very high quality work for your multi vendor inventory collaboration/managment sys that will be made to be upgradable in case you need some upgrades in future. We will always be available for upgr More

$2600 USD in 29 days
(2 Reviews)
3.3