Allow Import for multi-currency prices for product Library

CelinTeo

The new multi-currency feature is wonderful, however, when importing products via CSV, the 'product price' column maps only to default set company currency. We need the ability to match multiple currency columns from the .csv import to additional currencies set up in the account. e.g. if I have 1000s of products that we sell at different price points around the world (different currencies), I will not be able to import these currencies directly and would need to manually edit them, which will take weeks and potentially a lot of human error to enter these all manually via the web interface.

HubSpot updates
Re: Allow Import for multi-currency prices for product Library - changed to: Delivered
Jan 2, 2019

5 Replies
deborahfelicio
Participant

most definetely useful, lucky we only have 52 products. 

Eliot
Member | Partner

I just did this with feedback from the support team.

Here are the column headers I used:

Name,Product description,Product price,Cost of goods sold,Price [GBP],Price [USD],Price [EUR]
 

The only problem I have is it seems to import duplicates rather than upating/overwriting...

Status updated to: Delivered
hroberts
HubSpot Product Team
 
jasonbeckett
Member

I will try this, but I have 3000 skus, so importing duplicates instead of updating/overwriting is a non-starter.  

jasonbeckett
Member

if you export first (including the product ID field, then import with the checkbox checked, 'Update existing products using "Product ID" exported from Hubspot' it updates the new pricing fields to the existing products.  Voila! This just saved me a about 2 days of manual updates.