Tips, Tricks & Best Practices

JRobertshaw
参加者

Bulk Update of Products

解決

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 いいね!
1件の承認済みベストアンサー
CateDuarte
解決策
トップ投稿者 | Diamond Partner
トップ投稿者 | Diamond Partner

Bulk Update of Products

解決

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

元の投稿で解決策を見る

2件の返信
Olivia_Bagnall
ガイド役 | Platinum Partner
ガイド役 | Platinum Partner

Bulk Update of Products

解決

@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 and Project Manager

Baskey

o.bagnall@baskey.eu
www.baskey.eu
Rheingasse 14, 50676 Köln
CateDuarte
解決策
トップ投稿者 | Diamond Partner
トップ投稿者 | Diamond Partner

Bulk Update of Products

解決

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