Build a price book SQL Database
Budget: $250 – $750 USD
I need a SQL database created to combine price books from multiple vendors into a uniform format.
I need an uploader that can handle 500k to 1M lines, in CSV, RTF, Excel, etc. and can remap the incoming file to the database structure. And the uploader needs to update line items by the part number. We also need to be able to set some default data for some columns per file. (Supplier, Brand, etc).
The primary key will need to be a unique ID but I would like the database indexed by Part Number and UPC for faster lookups. Some files will have more then one UPC also.
I need an uploader that can handle 500k to 1M lines, in CSV, RTF, Excel, etc. and can remap the incoming file to the database structure. And the uploader needs to update line items by the part number. We also need to be able to set some default data for some columns per file. (Supplier, Brand, etc).
The primary key will need to be a unique ID but I would like the database indexed by Part Number and UPC for faster lookups. Some files will have more then one UPC also.