We are building a new Mageno website and I need some help with it.
We basically have a large database of products, mysql, for multiple types of products.
Clothes with different sizes and collors, electronics with multiple attributes that we want to use for filtering purposes, multiple images for the products.
Because we have a few thousand products we look for a method to import these automatically and update stock automatically.
The MySql db is very flexible and all attributes, prices and sizes are on distinct columns/tables and easy to extract.
Atributes are not created in Magento yet, need to be automatically imported.
Here's what we need:
+ Current product database import
+ Images downloaded/uploaded in the magento server (they are currently on the provider's servers, stored in the mysql db are img URL)
+ Import current product attributes
+ import current product categories
+ Automatically update/add new product attributes to magento instance, from the mysql database when new products are added there
+ php + mysql + cron job files installed on the server, for future updates to work
+ taking in account some products have multiple sizes/colors/options (especially the clothes)
+ stock and price cron job configuration
These imports need to be automated because other products will be added in the database overtime.
We look for a long term partnership.