1) Create MySQL tables that conclusively address every needed product and category field for Magento
2) Create an interface which imports data from excel/csv file into the data base. It must identify changes in product listings/ additions. There must be a way to identify if products from this master list were omitted. Items which would potentially be omitted items would be flagged so that a report could be reviewed prior to deletion.
3) Certain table fields would have specific options per Dealer website. These special values will need to be saved for each dealer. Example: Price is determined using a markup calculation which is particular to each Dealer's website. If an update to the master sheet is made this dealer's calculation would still calculate and an export of product list would produce a special csv for this dealer which shows his updated price levels.
4) Each Dealer may choose not to include certain Brands, categories or certain products. Their specific criteria needs to be easily configured, so that this dealer's csv only includes what they want listed.
DO NOT submit a bid if you do not have EXPERT knowledge on Magento, database, PHP, Script writing for Export and import into Magento.
Please bid accurately and ignore bid range