Suoritettu

Price Comparison Backend

XML datafeed importer for Price Comparison Web site.

Any previous experience with Affilate datafeeds and affiliate processes would be of great benefit.

See deliverables for further info on the project.

## Deliverables

I require a backend XML import system that takes Affiliate Window datafeeds of merchant & products and imports them into a database (either mysql or MS sql server, not 100% sure which yet). Please see [www.**feedprocessor**.com][1], this does a lot of what I need in that you can add the merchants XML file and then map it to the relevant DB fields. But instead of spitting out 100's of HTML pages I would like the data to be written to the DB, and so none of the HTML template functionality will be needed. The DB will also save any settings/mappings I may have entered for each merchant.

The Product table also needs to contain only unique products, so if a 2 or more merchants have the same product it will only be stored once in the table. So when products are added to the DB there will be an element of fuzzy matching to see if that product already exists, exact matching will not be possible as not all merchants will use the exact same product name i.e.

Merchant A: Panasonic 42" PW7

Merchant B: Panasonic TH42PW7

This is the same product but described in different ways. So if the products exists do not add it again, otherwise add it.

Each product will also be part of a 4 tier architecture, this is the DB architecture and is not replicated in the feeds:

Dept: Electrical

Category: Audio

Sub-Category: MP3 Player

Product: iPod

The feeds have a CategoryID but is only at Sub-Category level so if a feed has a CategoryID of 'MP3 Player' there must be some form of relation to the 'Audio' Category and so it will inherit the 'Electrical' department. I see this as being a series of link tables to form a relationship from products to department or vica versa. Once all the products have been added there will probably have to be some sort of manual proces that links each Sub-Category with a Category but should only need to be done once and updated if and when there is a new Sub-Category.

As with products the merchant will only be stored once and so once in the DB need not be added again.

I plan on this being a web based app and so a secure login page will be needed as well as editing functionality for products and merchants as well as the ability to manually match a merchant with a product (just in case the system cannot) and a method of matching the sub-categories to categories.

Please see XML feed supplied and an image of a rough ER diagram.

1) Complete and fully-functional working program(s) in DLL 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

Windows, IE 6 upwards, ASP.NET, MS SQL Server or MySQL database.

Taidot: .NET, ASP, tekniikka, Javascript, MySQL, PHP, tietojärjestelmäarkkitehtuuri, Ohjelmistojen testaus, SQL, Visual Basic, XML, XSLT

Näytä lisää: price comparison backend, what is use case diagram, what is the use case diagram, what is ms project plan, what is a use case diagram, what is an use case diagram, use case map, use case diagram of, use case diagram login, use case diagram for login form, use case diagram components, system architecture diagram, sql price, sites with login html 5, relationship in use case diagram, need of use case diagram, ms project xml import, ms project import xml, import ms project, html 5 mp3 player, hire electrical, functionality diagram, electrical hire, components of use case diagram, a use case diagram

Tietoa työnantajasta:
( 2 arvostelua ) Nottingham, United Kingdom

Projektin tunnus: #3913332

Myönnetty käyttäjälle:

Raves

See private message.

$191.24 USD 87 päivässä
(14 Arvostelua)
4.9

3 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

avanisolutions

See private message.

$237.15 USD 87 päivässä
(23 arvostelua)
5.1
webitechvw

See private message.

$85 USD 87 päivässä
(6 arvostelua)
1.3