Jump to content

Edit History

Ronnie79

Ronnie79


Less change of misunderstanding

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)

Ronnie79

Ronnie79


Less change of misunderstanding

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)

Ronnie79

Ronnie79

Hi,

I want to update my prices and stock from a suppliers CSV with a lot more products?

Example:

We have 5000 products from 5 suppliers, 1000 products from each.

I want to update my prices on 1000 products from one supplier that has given me a CSV with 10000 files, I want Prestashop to only update prices and stock for the reference matching 1000 products.

I don't want the rest (9000) of the non matching reference products added.
I don't want anything to happen with our other products (4000) from other suppliers.

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

×
×
  • Create New...