We need to migrate an osCommerce DB to a Magento DB. On the one hand, we’ll do a one time migration from osCommerce to Magento (including existing orders, products, categories, etc.). However, as several webshops are using the osCommerce DB for their business, we also need to periodically migrate the Magento DB to osCOmmerce format. This, however, is only a limited set of tables (all products and categories tables).
The osCommerce DB differs slightly from the standard DB, some fields have been abused for different purposes as the field was intended for (for example: products_weight in the products table is used as SKU) and some fields are new (for example ean_code in the products table). All these items are however very limited in impact. An exact mapping of the fields will follow if needed.
So we need the following:
1. Migrate osCommerce DB to Magento (all relevant tables; products, categories, orders, etc.),
2. Migrate Magento to osCommerce DB periodically (every hour)(only categories and products tables)
Please indicate if you could do this, your approach, what the price for the project would be, the time you need and what you need from us to complete the work.
Schema attached. Data (26000 products) made available upon agreement of work.
