Build a Product and Price List Database

I run a magento store and receive pricelists from many suppliers.

At the moment the live product catalogue is maintained within magento however doing so required a lot of manual work on different pricelist spreadsheets to correctly format each of them for import, to add or update products.

I am looking for a database software or online database configuration set up that allows for easy import of raw csv files that are then mapped to the appropriate fields within the database. Data then has work applied through set profiles or rules to provide outputs that can be used in magento, rather than creating different spreadsheets templates for each and every document.

The work undertaken by the database would include generating final sale prices and wholesale prices, comparing current and previous price, generating product data to add or update these products in magento.

These exports can then be imported into magento or used to create stand alone pricing documents for different customer groups such as wholesalers and resellers.

It is important that the system has provision for comparing current and previous prices, price tiers and making manual changes before export. Example files will be provided to the successful bidder however it is safe to assume the following

Import files will contain example fields such as below


- Product Name

- Description/Colour

- Cost price

Formulas/Actions applied within the database system

- Price markups (different tiers for different products sets, %, fixed plus %, etc)

- Comparison of previous and current price

- Retail price generation

- Wholesale price generation

- Prices per store (different currency)

- Product content such as meta title, keyword, description, URL, etc generation through templates

Export profiles can be set up to allow for configurable file exports according to the intended usages, such as below

- Addition of new products

- Price updates

- Wholesale price list

- Product catalogue

- Regional price list in local currency

A cloud or online solution is preferred has the system will be used by individuals in different regions. I understand that much of this could be handled in magento itself however would like to keep the two databases separate so that only final and agreed values are imported.

I haven't specified a task like this before so if you require additional information please do let me know although I do ask that only experienced and serious individuals apply.

Skills: Cloud Computing, Database Administration, MySQL, PHP, Software Architecture

See more: cloud product price list, import product, wholesalers online, wholesalers c&a, product suppliers for online store, price file, online store suppliers, online database work, online database php, name of product and description, making online of sale, c plus plus list, cloud computing online, a description of a product, spreadsheets online, price comparison online, online price comparison, final price, wholesale products suppliers, online wholesale suppliers, format price, description of a product, wholesale suppliers, wholesale and retail, Sale product

About the Employer:
( 1 review ) Old Bar, Australia

Project ID: #2544541

11 freelancers are bidding on average $694 for this job


Dear Customer! I am an expert web developer with over 6 years of experience and very interested in this project. Available to start immediately and finish as soon as possible. My bid is for fast professional service More

$200 USD in 2 days
(145 Reviews)

please check PM.

$1500 USD in 12 days
(22 Reviews)

Hi there, Freelance professional at your service. Please check my personal message box for suggestions. Cheers, Ela Buwa

$399 USD in 5 days
(18 Reviews)

Hello sir, Please check the message for detail. Thanks, Aking

$1200 USD in 15 days
(2 Reviews)

Our services are destined for complete perfection and Company believes in solidarity and commitments. We complete our targets well within time. We provide services in latest Web 2.0 technologies also. We provide offsho More

$240 USD in 3 days
(0 Reviews)

Professional web enabled database developer with experience with this type of solution.

$1000 USD in 21 days
(0 Reviews)

We are well experienced in this type of work. We are interested to work with you.

$150 USD in 10 days
(0 Reviews)

Hi, YADA Business Solutions Private Limited, a full service Technology Solutions consultancy owned and managed by Industry Experts and congregation of exceptional talents with proven skills in varies industry vertical More

$1100 USD in 60 days
(0 Reviews)

Hello, We work with complex databases and would be able to do the job. Thanks

$850 USD in 21 days
(0 Reviews)

Hi please have look into my PM

$600 USD in 9 days
(0 Reviews)

we have developed recently few magento websites with product list of 500 different products. we have complete competency to do this job.

$400 USD in 5 days
(0 Reviews)