Setting up Merchant SKUs and UPCs - CommerceHub
1.7 min read
|In certain instances, CommerceHub OrderStream necessitates a Merchant SKU or a UPC for individual products during inventory synchronization. To facilitate this, you need to establish these SKUs and UPCs as product aliases within Extensiv Integration Manager. In some cases, system aliases will be imported automatically from your warehouse management system or order management system, necessitating setup in those systems.
As Integration Manager imports orders from CommerceHub, it will make an effort to automatically import any aliases they have provided for the items in that order into Integration Manager, provided they are not already present. However, this process is effective only when you have corresponding product SKUs imported from your warehouse.
View or Add Alias in Integration Manager
To access or include product aliases in Integration Manager, navigate to the merchant within the Merchant tab. Click Locations & Products, and then proceed to Product Alias. From there, choose the specific Product SKU you want to work with.
CommerceHub Setup
UPC
UPCs will be automatically sent to CommerceHub if available. No additional setup is needed beyond having an alias with the name UPC. Your UPC cannot be used as the vendor SKU. Attempting to pass the same value as the UPC and SKU will cause inventory updates to fail in CommerceHub.
Merchant SKU
All your Merchant SKUs should be given the same alias name in Integration Manager. merchantSKU is the preferred default name, but others are allowed.
Go to the CommerceHub cart in Integration Manager and select Edit Setup. For the option named Merchant SKU Alias Name, select which of the alias names your setup that Integration Manager should use when sending the Merchant SKU field to CommerceHub.
Skip items
Not all your products may exist in CommerceHub for sale. If you send inventory to CommerceHub for items they don't expect, they will send loading error emails.
To prevent this, make sure you only add the Merchant SKU Alias to products that actually exist in CommerceHub. Next, make sure to set the Skip Items Without Alias option to: Yes
Manufacturers SKU
This settings works exactly the same as the Merchant SKU above. Very few retailers require this. If CommerceHub complains that this field is missing, make sure to turn it on in the Integration Manager settings and choose the proper alias name.
manufacturerSKU is the preferred default name, but others are allowed.
Vendor SKU
Integration Manager always passes a Vendor SKU. By default this is the Master SKU of the product loaded in Integration Manager. If you need to pass a different alias value to CommerceHub for the Vendor SKU, Go to the CommerceHub cart in Integration Manager and select Edit Setup. For the option named Push Inventory Using Alias (towards the bottom of the page), select which of the alias names your setup that Integration Manager should use when sending the Vendor SKU field to CommerceHub.
Missing Vendor SKU
Any items without a valid Vendor SKU will not have inventory synced to CommerceHub.