Setup Merchant SKUs and UPCs - CommerceHub

Setup Merchant SKUs and UPCs - CommerceHub

CommerceHub OrderStream sometimes requires a Merchant SKU or a UPC for each product when performing inventory syncs. In order for this to work, you must setup these SKUs and UPCs as product aliases in Extensiv Integration Manager. For some systems aliases will load automatically from your WMS/OMS system, so you need to set them up there.

When Integration Manager loads orders from CommerceHub, we will attempt to automatically load any aliases they provide for that order's items into Integration Manager if they don't exist already. This only works if you have matching product skus loaded from your warehouse.

View / Add Alias in Integration Manager

You can view or add product aliases in Integration Manager by going to the merchant in the Merchant tab. Click on Locations & Products and then Product Alias. Select the desired Product SKU.

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.

    • Related Articles

    • Setting Up CommerceHub OrderStream

      Integration Specs: Supported functions: Order Download Inventory Sync Shipment Confirmation - Detailed Required Parameters FTP Server FTP Username FTP Password Your Partner ID Their Partner ID (Retailer ID) Your Vendor ID* (Retailer Dependent) ...
    • CommerceHub OrderStream Settings

      Document Numbers Extensiv Integration Manager supports the following documents with CommerceHub (XML via SFTP). Please see the below section for CommerceHub Data Exchange Method setup.  850 Purchase Order 855/997 Acknowledgement 856 Shipment 810/820 ...
    • CommerceHub Inventory Not Updating

      If Extensiv Integration Manager shows that inventory is syncing successfully to CommerceHub, but CommerceHub or your retailers are saying it is not, follow these steps to find the issue with your inventory setup: Login to the CommerceHub OrderStream ...
    • Setting Up CommerceHub DemandStream

       DemandStream Integration Specs: Supported functions: Order Download Inventory Sync Shipment Confirmation - Detailed Required Parameters FTP Server FTP Username FTP Password Retailer ID Partner ID Step-by-step guide You must have DemandStream enabled ...
    • CommerceHub Walmart.com

      Extensiv Integration Manager does not support the CommerceHub Walmart.com connection due to unreasonable requirements and lack of standardization on the part of CommerceHub. If you are connecting to Walmart.com or Walmart DSV, we recommend you use ...