Deleting Product Library / Work-Around
The biggest issue in uploading and re-uploading a product library is preserving your Product IDs. If you don’t use them as an anchor and simply upload new products you will exponentially increase your product library and produce many duplicates.
My first attempt was to download the Product IDs and copy / paste the only the Product IDs into a new product library. My thought was that Hubspot would overwrite the old data with any new updates based on Product ID. This did not work, however, because Hubspot would find the product NAME attached to a different Product ID and throw an error.
So, I recommend the following steps:
-
Download your library with all current Product IDs
-
Insert new, generic naming data in the NAME field attached to each Product ID row. I used the following naming convention:
NAME
Test 100
Test 101
Test 102
Test 103
Etc.
-
Watch for any duplicate names. Some of my Product Names and SKU names were the same, for example, so I also had to put generic data into the SKU fields.
-
Upload this new file into Hubspot. Hubspot will MATCH on Product ID and OVERWRITE any data you have there with new, generic names as detailed above. (Your product library in Hubspot will now contain this generic naming convention - essentially a clean slate for uploading new data.)
-
Now, take those same Product IDs and attach (copy / paste) them to correct Product Library you wish to upload to Hubspot.
-
Upload this new Product Library. Hubspot will MATCH to the Product ID and OVERWRITE your generic naming with new data.
-
If your new Product Library has fewer rows that the original, you can now search on TEST and pull up only those products. Much easier to delete these “strays”
This should allow you to avoid deleting 20 rows at a time…