How do I resolve duplicate SKU errors when uninstalling HubSpot integration?

Related Scenarios

• How to uninstall the HubSpot integration from Chargebee
• Resolving sync errors related to duplicate SKUs in HubSpot
• Managing connections between Chargebee test and live sites with HubSpot

Solution

When uninstalling the HubSpot integration from your Chargebee test site, you might encounter a sync error stating: "Duplicate entry is found for Cbtransformer.item_price.cb_hs_sku." This typically occurs due to duplicate SKUs in the HubSpot Product Library, often caused by connecting both test and live Chargebee sites to the same HubSpot account.

To resolve this issue, follow these steps:

1. Check for Duplicate SKUs in HubSpot:

   • Navigate to your HubSpot account.
   • Go to Sales > Products.
   • Review the Product Library for any duplicate SKUs.
   • Remove or merge any duplicates to ensure each SKU is unique.

2. Ensure Only One Site is Connected:

   • Confirm that only one Chargebee site (either test or live) is connected to your HubSpot account.
   • Disconnect any unnecessary site to prevent conflicts.

3. Clean Up HubSpot Product Library:

   • After removing duplicates, ensure that the Product Library is organized and free of redundant entries.
   • This will help in maintaining a smooth sync process.

4. Retry the Sync:

   • Once the above steps are completed, attempt to sync again.
   • Monitor for any errors and ensure the integration is functioning as expected.

Important Notes

• Always back up your data before making significant changes to your HubSpot Product Library.
• Consider maintaining separate HubSpot accounts for test and live Chargebee environments to avoid conflicts.
• Regularly audit your Product Library to prevent duplicate entries and ensure data integrity.