topic Re: Bulk Update of Products in Tips, Tricks & Best Practices

Bulk Update of Products

JRobertshaw — Sun, 26 Jun 2022 02:16:34 GMT

Our client has implmented a price change across their 327 products

We have tried using an import with the SKU as the unique identifier to update these prices.

Unfortunately the import fails because these products allready exist. How can we update all of these products in bulk?

Thank you

Re: Bulk Update of Products

CateDuarte — Mon, 27 Jun 2022 08:53:34 GMT

Hi @JRobertshaw I believe you'll need to use the Product ID property to do a bulk update.

Probably you'll need to export current products and use a vlookup to update the prices and re-import?

Re: Bulk Update of Products

Olivia_Bagnall — Mon, 18 Jul 2022 16:56:18 GMT

@JRobertshaw

You can bulk update products via import using the object ID.

To get the product ID of your products you can export them again once they have been imported. You need to go to your product library, tick next to each product and then select 'export' in the toolar.

Once you do this, you will have a CSV file with all your products and their ID. You can then edit the price vales on this filel and import it.

When importing the file, set the 'product ID' as the 'object ID' at the mapping stage

I really hope this helps!