Multiple suppliers with different feeds needing to be easy to import, update stock levels and bring in uniform and seo practical to image naming.
Development of unique wordpress plugin or 2 to cover as much of the below functionality.
How it needs to work:
Easy to install through the Wordpress system. Not interfere with any other active plugins. Must be stable across all browsers including mobile and tablet. Must be user friendly.
Where possible utilise existing logic and plugins to reduce dev cost.
Should be able to upload large feed spreadsheets or enter URLs of feeds.
Should be able to map which field is to be allocated where. I.e product name, category, ean, image, product description etc as different feeds have different terminology.
Once a new is imported, products should be automatically placed as draft prior to being checked and set live manually to avoid bad experiences.
Products should be unique by SKU.
A nice to have would be to be able to check if title or description is similar to another as some suppliers may have product crossover.
Then take image names and URLs and rename to "Product Name" with _1 _2 etc if more than one image. If more seo friendly solution available please advise. Where duplicates images possible, should be flagged but not fail.
Be able to set regular tasks to update stock through suppliers, or to force update should it need to be done outside of regular tasks. This should work via SKU and EAN if available. It needs to look at stock (in stock, out of stock, qty) and price (risen, reduced) and if it makes an update should be flagged and not visible to public until checked.
Where possible not interfere with any core files to avoid plugin becoming broken everytime plugin or wordpress updates.