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 CartRover. For some systems aliases will load automatically from your WMS/OMS system, so you need to set them up there.

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

View / Add Alias in CartRover

You can view or add product aliases in CartRover 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 CartRover. merchantSKU is the preferred default name, but others are allowed.

Go to the CommerceHub cart in CartRover and select Edit Setup. For the option named Merchant SKU Alias Name, select which of the alias names your setup that CartRover 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 CartRover settings and choose the proper alias name.

manufacturerSKU is the preferred default name, but others are allowed.

Vendor SKU

CartRover always passes a Vendor SKU. By default this is the Master SKU of the product loaded in CartRover. If you need to pass a different alias value to CommerceHub for the Vendor SKU, Go to the CommerceHub cart in CartRover 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 CartRover 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 CartRover 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 Invoice 846 ...
    • CommerceHub Inventory Not Updating

      If CartRover 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 Dashboard Browse to ...
    • 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

      CartRover 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 SPS Commerce or our ...