Tips, Tricks & Best Practices

JRobertshaw
Contributor

Bulk Update of Products

SOLVE

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 

0 Upvotes
1 Accepted solution
CateDuarte
Solution
Top Contributor | Elite Partner
Top Contributor | Elite Partner

Bulk Update of Products

SOLVE

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? 

 

 

Catarina Duarte

Senior Consultant | Periti Digital
Email: cduarte@peritidigital.com

View solution in original post

2 Replies 2
Olivia_Bagnall
Guide | Platinum Partner
Guide | Platinum Partner

Bulk Update of Products

SOLVE

@JRobertshaw 

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

Olivia_Bagnall_0-1658163362654.png

 

 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. 

Olivia_Bagnall_1-1658163362657.png

 

 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. 

Olivia_Bagnall_2-1658163362504.png

 

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

Olivia_Bagnall_3-1658163362482.png

 

 

I really hope this helps!

Olivia Bagnall

Inbound Consultant | HubSpot Specialist | Community Champion

emailAddress
o.bagnall@baskey.eu
website
www.baskeydigital.com
Book a consultation
CateDuarte
Solution
Top Contributor | Elite Partner
Top Contributor | Elite Partner

Bulk Update of Products

SOLVE

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? 

 

 

Catarina Duarte

Senior Consultant | Periti Digital
Email: cduarte@peritidigital.com