We need Magento manager software to import and edit products from XML file. Here are all requirements we need to work with our page.
1. Software should be installed on our server not as part of Magento installation standalone software, connected to store db
2. Software should have his own db
3. Software need to import product descriptions, names, attributes, images, stock, prices, ...
4. Products that are already in store db shouldn't be imported in software only price and stock level should be updated directly in store db
5. Special price calculation based on price value (products $1 to $10 should have 35% margin, products $10 to $20 should have 30% margin and so on...)
6. All images from XML file need to be imported, not only main image
7. Mapping for all options we do have it in our db (option to refresh values if we add new attribute or category in db) Option to connect by hand attributes from XML with attributes from Store db
8. Adding SKU - prefix for XML Sample: for our supplier GM&M we do use prefix in DB: "GMM"-SKU number see attached image) this option allow to connect product from XML with the correct products in db
9. Possibility to edit images, descriptions, tributes, prices,... direct trough software, without login to Magento admin
10. Running XML updates per Cron Job
11. Option to create unlimited users for Software login Our Magento version is 2.1.