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.
[login to view URL] 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:
[login to view URL] 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!