Encerrado

Data Mapping to OSCMAX

Data Mapping Project

Purpose

The purpose of the project is to create windows based software (preferred visual basic .net) to process data that consist of product list from multiple vendors into one product list which is later injected to online store database (Mysql)

Processing/Product Mapping

System must be able to process product:

-. As the product list always contain same product from different vendor, it is good to sort the data in best priority and pick best one to update to website ( always sort the cheapest and available and nearest location). This means that the identical products will only be chosen one which is the best price, availability and nearest vendor location) the second priority sit as backup when the most efficient product running out from particular supplier. The order of vendor will be decided or set by my preferences.

[url removed, login to view] to product mapping for business function

-. At local, it ok to combine everything together (same products form multi suppliers) so I can search internally which supplier supply particular product.

-. Result of data process are required to be migrated to mysql database which supporting oscmax (oscommerce maximised) REMEMBER !!!only the best product!!! (REMOVE SIMILAR PRODUCTS)

Product mapping details:

-. The main entities from vendor product list are : product_model. Product_name, product_price, product_availability

-. I want to have grouping function, when I search with some keywords, couples of product turns up and if I see some of them are same product but different vendor, I am able to tick on it and put them as same product group and then the order of product will be based on my preferences of vendor priority to be displayed on OSCMAX.

-. I want to be able to add profit margin to my current product list:

[url removed, login to view] the current price to new field called product_cost_price

-. I have to be able to add profit margin formula to each product based on the price range for example:

-. $1- $5 product, add $10 dollar.

-. $10-$50 product , add $5 dollar

-. And so on

-. When updating with oscmax productlist, if there is product is nolonger available in newest price list of vendors, the product will be moved to new table (don’t delete it)

-. Retail price field is not available in oscmax, I will add one later. As well as availability

Everything must be finalized at local (it’s ok to run local mysql, I will setup one too) KEEP REMOTE DATABASE AS SMALL N SIMPLE AS WE CAN.

This program will be run at least three times a day to update the price and availability of the product.

More detail requirement will be sent to successful candidate!

Habilidades: .NET, Processamento de Dados, Processamento de dados, Administrador do Sistema, Visual Basic

Ver mais: visual basic price, vendor product, suppliers online, simple dollar, setup online business, set data, retail online business, purpose means, product suppliers online store, product supplier database, priority one, online store suppliers, online store supplier, online business data processing, online business net, multi program online, multi online business, formula it, everything dollar website, everything dollar store, everything dollar, data process online, cheapest suppliers, best website profit online, basic website price list

Acerca do Empregador:
( 0 comentários ) sydney, Australia

ID do Projeto: #145319

2 freelancers estão ofertando em média $93 para este trabalho

sfsahiwala

I am interested in doing your project

$100 USD in 4 dias
(0 Comentários)
1.2
bahetikr

I am having 5 years of experience in VB SQL I will do this on urgent basis

$85 USD in 3 dias
(0 Comentários)
0.0