Managing Ship Via Mappings

Ship Via mappings are managed in BD_ConnectorLinkages_CommerceHub_ShipViaLinkages.

• ShipViaCode - This is the ship via code from your system
• CommerceHubShippingCode - This is the CommerceHub Ship Code / Carrier code from https://dsm.commercehub.com/dsm/gotoIntegratedMessageCodes.do.
  • Go to Order Stream>Admin>Integrated Message Codes>Ship / Carrier Codes
  • Filter - Select the Retailer
  • Choose the appropriate Code that is approved to Send

For example, if you have the Ship Via Code FXG for FedEx Ground in your system then you would want to create a record mapping that to FDEG.

To create a new mapping update the following values appropriately and run the query:

INSERT INTO [dbo].[BD_ConnectorLinkages_CommerceHub_ShipViaLinkages]
           ([ID]
           ,[CreatedTime]
           ,[LastUpdatedTime]
           ,[ConnectorId]
           ,[ShipViaCode]
           ,[CommerceHubShippingCode])
     VALUES
           (NEWID()
           ,GETDATE()
           ,GETDATE()
           ,'{ConnectorId}'
           ,'{Your Ship Via Code}'
           ,'{CommerceHub Ship Code}')

To update an existing mapping update the following values appropriately and run the query:

UPDATE [dbo].[BD_ConnectorLinkages_CommerceHub_ShipViaLinkages]
   SET [ShipViaCode] = '{Your Ship Via Code}'
      ,[CommerceHubShippingCode] = '{CommerceHub Ship Code}'
      ,[LastUpdatedTime] = GETDATE()
 WHERE [ID]={Existing Record ID}