I have an excel sheet of 10,000 products with name of product/product code/price etc (sample content attached) that I email to clients. Each week I have an updated sheet with mostly the same products and the occasional price change. I need a shopping cart where I can import this sheet each week so that the price updates. It is impossible to look through the sheet to see if there are new products so is there some way that I could be alerted to new products (product codes).
I have experience working on carts at a basic level such as opencart, prestashop, woocommerce but I really don't know how to go about such a project or even if it is possible. Is it possible to populate the cart with the products and then afterwards I can assign each product to an appropriate category/sub category and upload a picture. Then each week the cart would import the new xls sheet, update the product prices and would add new products to for example new products, that I then assign these new products to a category and give them a photo.
The overall design of the cart will be up to you also. There is no need for payment gateway as all products are sold cash on delivery. Please feel free to ask for more details or clarification as I'm not sure how easy it is to understand what I'm looking for.