Tips, Tricks & Best Practices

fafaba
Participant

Bulk Prices Update of Products (with different currencies)

Hi, 

 

I'm making this article to explain how to bulk update the prices of your product instead of going one by one. I didn't see any explanation for this and I think it's worth knowing and will save time. 

 

First you need to get the Record ID. This isn't visible directly on Hubspot. You need to export your product(s) into a CSV and open it with Excel or Google Sheet. I'm using Google Sheet in my case. 

 

Step 1 : Export your product to find the Record ID 

 

Go to Settings => Data Mangagement => Products 

 

Capture d’écran 2023-09-05 091146.png

 

Select the product(s) where you want their Record ID. Then click Export. 

 

Choose what type of file you want, download as CSV, you're using most likely Excel or GS. 

 

Step 2: Remove unnecessary columns on your CSV file. 

 

This step is not mandatory but it'll make your future import on hubspot cleaner than having dozen of Product Properties empty for no reason. 

 

Capture d’écran 2023-09-05 091646.png

You'll have a lot of empty columns in your CSV export, just delete those columns and keep the ones you want to import. 

 

Step 3: Update your prices 

 

Change your prices in all currencies you want and then download the file as CSV. 

 

Step 4: Import your file with new prices 

 

Go to import on Hubspot. 

 

One file => One object => Products => Find your file on your computer. 

 

Select "Update existing Products only", click Next. If you choose to create new products you may end up with new products. I haven't tried this. 

 

You'll have most likely an error message : 

 

Capture d’écran 2023-09-05 092118.png

 

You need to change "Product Properties" to Record ID. 

 

Capture d’écran 2023-09-05 092208.png

 

You import should look like this: 

 

Capture d’écran 2023-09-05 092553.png

 

Click Next and select your adapted Number Format for your business. 

 

After that, the import will take a moment, once it's done you can check your product prices, they should be updated correctly. 

2 Réponses
AnaPerezUrruti
HubSpot Employee
HubSpot Employee

Bulk Prices Update of Products (with different currencies)

Thank you, this is great.

0 Votes
DianaGomez
Gestionnaire de communauté
Gestionnaire de communauté

Bulk Prices Update of Products (with different currencies)

Hello @fafaba,

 

I want to express my sincere gratitude for sharing this detailed article on the "Bulk Prices Update of Products (with different currencies)." I am confident that the community will find it immensely valuable. Your effort in providing such insightful content is greatly appreciated.

 

Best regards, 

Diana


¿Sabías que la Comunidad está disponible en Español?
¡Participa hoy en conversaciones en el idioma de tu preferencia,cambiando el idioma en tus configuraciones!

Did you know that the Community is available in other languages?
Join regional conversations by changing your language settings !


0 Votes