Import CSV products prices but ignore all non matchning references

[Ronnie79]

Hi,

Currently we are updating prices manually one by one in our webshop which is way to time consuming.

I want to update prices and stock by importing a CSV file from the supplier. The problem is that the suppliers CSV contains a lot more products than we are selling. I don´t want it to add the products that we aren't selling, only the matching references.

Example:

Lets say that we have 5000 products that we source from 5 different suppliers, 1000 products from each.
I want to update our prices on 1000 products from one supplier by importing my suppliers CSV with 10000 files without the non matching products to be added. And I don't want anything to happen with our other products (4000) in our webshop from other suppliers.

1. I want Prestashop to only update prices and stock for the matching references (approximately 10% of the suppliers products). Any module required?

2. I want to find a way to match my CSV file with the suppliers CSV and delete all non matching products in the suppliers CSV. Maybe it can be done in PowerQuery or similar?

Many thanks if anyone know how to achieve this?😀 (without manually having to find and delete 9000 products one by one from suppliers CSV)

Edited 9 hours ago by Ronnie79
Less change of misunderstanding (see edit history)

[Daresh]

It should be done using some additional module that allows to be automated with a CRON task. Nobody updates stock manually, as it can change very often.

I do modules like this for my customers on a daily basis. Very often there is some additional logic that needs to be taken into account. For example applying a margin on a price, setting visibility, settings "allow out of stock" option and so on...

Sometimes the CSV file is publicly available, sometimes some credentials are needed to download it. There are many many cases here, so I prefer a dedicated approach.