...
We have 2 options to create Provider Interface Settings for the client.
Click Create New button if you wish to manually created the provider interface settings.
...
Note: Each Interface Name along with the address and other credentials should be created.
Enter the following:
Carrier Provider: Indigina TMS
Release Profile: QA = UAT, LIVE = Live
Username: Go to TMS site and copy the API Key.
Add the Interface Name and address.
UAT
Interface Name | Address |
CreateManifest | https://tmsuat.supplystream.com:8081/api/Tms/CreateManifestV2?token= |
CreateShipment | |
DeleteShipment | |
GetShipment | https://tmsuat.supplystream.com:8081/api/TMS/Shipments/{0}?token= |
PrintManifest | https://tmsuat.supplystream.com:8081/api/Tms/PrintManifest?token= |
UpdateShipment |
LIVE
Interface Name | Address |
CreateManifest | https://tms.supplystream.com:8081/api/Tms/CreateManifestV2?token= |
CreateShipment | |
DeleteShipment | |
GetShipment | https://tms.supplystream.com:8081/api/TMS/Shipments/{0}?token= |
PrintManifest | https://tms.supplystream.com:8081/api/Tms/PrintManifest?token= |
UpdateShipment |
Click add and then do the same for the other Interface Name.
...
2. Create Provider Interface Settings via script.
Run the script.
UAT Script
DECLARE @ReleaseProfile int = 0,
@APIToken nvarchar(100) = 'eipnqgvazhdvqcfsgidyhfu0ebmzd1aye29h0kj0',
@ClientID uniqueidentifier = 'A431F2ED-A827-E411-B3F4-000C29DA324D', -- M&S School Uniforms
@UserID uniqueidentifier = '4C95B030-6B07-DF11-B335-000C2989186B', -- admin@supplystream.com
@NEWID1 uniqueidentifier,
@NEWID2 uniqueidentifier,
@NEWID3 uniqueidentifier,
@NEWID4 uniqueidentifier,
@NEWID5 uniqueidentifier,
@NEWID6 uniqueidentifier
SET @NEWID1 = NEWID()
SET @NEWID2 = NEWID()
SET @NEWID3 = NEWID()
SET @NEWID4 = NEWID()
SET @NEWID5 = NEWID()
SET @NEWID6 = NEWID()
INSERT INTO CarrierProviderInterfaceTypeSetting (CarrierProviderInterfaceTypeSettingID, CarrierProviderInterfaceTypeID, ReleaseProfile, [Address], UserName, [Password], CreateDate, CreateUserID, DisableLevel, CustomerID, LastModifiedDate, LastModifiedUserID)
VALUES (@NEWID1, '1D2616E1-3AAC-4C4A-B604-37F6A631C08C', @ReleaseProfile, 'https://tmsuat.supplystream.com:8081/api/Tms/CreateManifestV2?token=', @APIToken, '', GETUTCDATE(), @UserID, 0, @ClientID, GETUTCDATE(), @UserID)
INSERT INTO CarrierProviderInterfaceTypeSetting (CarrierProviderInterfaceTypeSettingID, CarrierProviderInterfaceTypeID, ReleaseProfile, [Address], UserName, [Password], CreateDate, CreateUserID, DisableLevel, CustomerID, LastModifiedDate, LastModifiedUserID)
VALUES (@NEWID2, 'FFF30BD5-E2BD-4F38-B9C7-C567AF52D881', @ReleaseProfile, 'https://tmsuat.supplystream.com:8081/api/Tms?token=', @APIToken, '', GETUTCDATE(), @UserID, 0, @ClientID, GETUTCDATE(), @UserID)
INSERT INTO CarrierProviderInterfaceTypeSetting (CarrierProviderInterfaceTypeSettingID, CarrierProviderInterfaceTypeID, ReleaseProfile, [Address], UserName, [Password], CreateDate, CreateUserID, DisableLevel, CustomerID, LastModifiedDate, LastModifiedUserID)
VALUES (@NEWID3, '6FFA4273-7543-402B-8EFE-95B0FFA78A71', @ReleaseProfile, 'https://tmsuat.supplystream.com:8081/api/Tms/Delete?token=', @APIToken, '', GETUTCDATE(), @UserID, 0, @ClientID, GETUTCDATE(), @UserID)
INSERT INTO CarrierProviderInterfaceTypeSetting (CarrierProviderInterfaceTypeSettingID, CarrierProviderInterfaceTypeID, ReleaseProfile, [Address], UserName, [Password], CreateDate, CreateUserID, DisableLevel, CustomerID, LastModifiedDate, LastModifiedUserID)
VALUES (@NEWID4, 'FEE2726A-E384-4FE0-8CA6-DEC54018C2DB', @ReleaseProfile, 'https://tmsuat.supplystream.com:8081/api/Tms/PrintManifest?token=', @APIToken, '', GETUTCDATE(), @UserID, 0, @ClientID, GETUTCDATE(), @UserID)
INSERT INTO CarrierProviderInterfaceTypeSetting (CarrierProviderInterfaceTypeSettingID, CarrierProviderInterfaceTypeID, ReleaseProfile, [Address], UserName, [Password], CreateDate, CreateUserID, DisableLevel, CustomerID, LastModifiedDate, LastModifiedUserID)
VALUES (@NEWID5, 'D0143356-0418-45A7-B0F8-9438B47711D2', @ReleaseProfile, 'https://tmsuat.supplystream.com:8081/api/Tms/Update?token=', @APIToken, '', GETUTCDATE(), @UserID, 0, @ClientID, GETUTCDATE(), @UserID)
INSERT INTO CarrierProviderInterfaceTypeSetting (CarrierProviderInterfaceTypeSettingID, CarrierProviderInterfaceTypeID, ReleaseProfile, [Address], UserName, [Password], CreateDate, CreateUserID, DisableLevel, CustomerID, LastModifiedDate, LastModifiedUserID)
VALUES (@NEWID6, 'C7D50385-1A3D-40CC-B580-10247E3434CB', @ReleaseProfile, 'https://tmsuat.supplystream.com:8081/api/TMS/Shipments/{0}?token=', @APIToken, '', GETUTCDATE(), @UserID, 0, @ClientID, GETUTCDATE(), @UserID)
Live Script
DECLARE @ReleaseProfile int = 1,
@APIToken nvarchar(100) = 'twvek0p1vwqqfedxtztoeb8knsatp8jzs0ontspo', -- Api Token on the TMS site
@ClientID uniqueidentifier = 'A431F2ED-A827-E411-B3F4-000C29DA324D', -- CompanyID
@UserID uniqueidentifier = '4C95B030-6B07-DF11-B335-000C2989186B', -- admin@supplystream.com
@DCID uniqueidentifier = '18835ACA-CD37-E211-8B11-000C29E98746', --DCID
@NEWID1 uniqueidentifier,
@NEWID2 uniqueidentifier,
@NEWID3 uniqueidentifier,
@NEWID4 uniqueidentifier,
@NEWID5 uniqueidentifier,
@NEWID6 uniqueidentifier
SET @NEWID1 = NEWID()
SET @NEWID2 = NEWID()
SET @NEWID3 = NEWID()
SET @NEWID4 = NEWID()
SET @NEWID5 = NEWID()
SET @NEWID6 = NEWID()
INSERT INTO CarrierProviderInterfaceTypeSetting (CarrierProviderInterfaceTypeSettingID, CarrierProviderInterfaceTypeID, ReleaseProfile, [Address], UserName, [Password], CreateDate, CreateUserID, DisableLevel, DCID, CustomerID, LastModifiedDate, LastModifiedUserID)
VALUES (@NEWID1, '1D2616E1-3AAC-4C4A-B604-37F6A631C08C', @ReleaseProfile, 'https://tms.supplystream.com:8081/api/Tms/CreateManifestV2?token=', @APIToken, '', GETUTCDATE(), @UserID, 0, @DCID, @ClientID, GETUTCDATE(), @UserID)
INSERT INTO CarrierProviderInterfaceTypeSetting (CarrierProviderInterfaceTypeSettingID, CarrierProviderInterfaceTypeID, ReleaseProfile, [Address], UserName, [Password], CreateDate, CreateUserID, DisableLevel, DCID, CustomerID, LastModifiedDate, LastModifiedUserID)
VALUES (@NEWID2, 'FFF30BD5-E2BD-4F38-B9C7-C567AF52D881', @ReleaseProfile, 'https://tms.supplystream.com:8081/api/Tms?token=', @APIToken, '', GETUTCDATE(), @UserID, 0, @DCID, @ClientID, GETUTCDATE(), @UserID)
INSERT INTO CarrierProviderInterfaceTypeSetting (CarrierProviderInterfaceTypeSettingID, CarrierProviderInterfaceTypeID, ReleaseProfile, [Address], UserName, [Password], CreateDate, CreateUserID, DisableLevel, DCID, CustomerID, LastModifiedDate, LastModifiedUserID)
VALUES (@NEWID3, '5388749C-89C8-4612-AF12-19201797F0D6', @ReleaseProfile, 'https://tms.supplystream.com:8081/api/Tms/Delete?token=', @APIToken, '', GETUTCDATE(), @UserID, 0, @DCID, @ClientID, GETUTCDATE(), @UserID)
INSERT INTO CarrierProviderInterfaceTypeSetting (CarrierProviderInterfaceTypeSettingID, CarrierProviderInterfaceTypeID, ReleaseProfile, [Address], UserName, [Password], CreateDate, CreateUserID, DisableLevel, DCID, CustomerID, LastModifiedDate, LastModifiedUserID)
VALUES (@NEWID4, 'FEE2726A-E384-4FE0-8CA6-DEC54018C2DB', @ReleaseProfile, 'https://tms.supplystream.com:8081/api/Tms/PrintManifest?token=', @APIToken, '', GETUTCDATE(), @UserID, 0, @DCID, @ClientID, GETUTCDATE(), @UserID)
INSERT INTO CarrierProviderInterfaceTypeSetting (CarrierProviderInterfaceTypeSettingID, CarrierProviderInterfaceTypeID, ReleaseProfile, [Address], UserName, [Password], CreateDate, CreateUserID, DisableLevel, DCID, CustomerID, LastModifiedDate, LastModifiedUserID)
VALUES (@NEWID5, 'D0143356-0418-45A7-B0F8-9438B47711D2', @ReleaseProfile, 'https://tms.supplystream.com:8081/api/Tms/Update?token=', @APIToken, '', GETUTCDATE(), @UserID, 0, @DCID, @ClientID, GETUTCDATE(), @UserID)
INSERT INTO CarrierProviderInterfaceTypeSetting (CarrierProviderInterfaceTypeSettingID, CarrierProviderInterfaceTypeID, ReleaseProfile, [Address], UserName, [Password], CreateDate, CreateUserID, DisableLevel, DCID, CustomerID, LastModifiedDate, LastModifiedUserID)
VALUES (@NEWID6, 'C7D50385-1A3D-40CC-B580-10247E3434CB', @ReleaseProfile, 'https://tms.supplystream.com:8081/api/TMS/Shipments/{0}?token=', @APIToken, '', GETUTCDATE(), @UserID, 0, @DCID, @ClientID, GETUTCDATE(), @UserID)
Note:
Change the below parameter:
@ReleaseProfile int = 0
If value is 0, This is QA
If value is 1, This is Live
@APIToken nvarchar(100) = 'eipnqgvazhdvqcfsgidyhfu0ebmzd1aye29h0kj0',
It is visible on the TMS site for each Integration Partner as per URL below:
URL_UAT: https://tmsuat.supplystream.com
URL Live: https://tms.supplystream.com
@ClientID uniqueidentifier = 'A431F2ED-A827-E411-B3F4-000C29DA324D', -- M&S School Uniforms
It is a unique identifier value for each customer. Get the CompanyID of the customer on the Company table.
@UserID uniqueidentifier = '4C95B030-6B07-DF11-B335-000C2989186B', -- admin@supplystream.com
It is a default user for reference.
Note: Check the linked DC to the client and make sure that the primary address was set on seko360 (under admin -> companies -> clients).
...
TMS Client Setup – TMS Site
URL_UAT: https://tmsuat.supplystream.com
URL Live: https://tms.supplystream.com
Requirements:
Carriers
Integration ID code: (Code must match the CompanyIntegration Integration ID in SupplyStream)
To Select Intergration Partner
My Account -> Default Integration Partner -> Select @ Set Default Integration Partner list
...
Change Client > Select @ Change Client List - you wish to connect to TMS
...
Entity Setup -> Client Setup -> Maintain Clients
Click the "Create New Client" button
...
Enter the details for the new client (leave the email empty) then save.
...
To Add Carrier to Customer
System Admin -> Security -> Client Entitlements
Select each new client you added and give them access to "DPD NL, TNT NL, DPD, Hermes, Interpost, Omni Parcel, Royal Mail"
...
System Admin -> Settings -> API Credentials
Note down the API Key then log into Supplystream to continue the set up
...
TMS Carrier Setup - WMS Site
SupplyStream UAT: https://demo.supplystream.com
SupplyStream Live: https://www.supplystream.com/
Log into SupplyStream using an admin account.
Carrier List
Select Admin>Carriers>Carrier List
...
Click Create New button.
...
Enter the Carrier Code and Description/Carrier Name then click Save button.
...
New TMS carrier has been setup already.
...
Carrier Company Access
Add/linked the carrier to all relevant customers.
Select Admin>Carriers>Carrier Company Access.
...
Click Create New button.
...
Select the company who need access to the carrier then click Add & Close button.
...
Client has now access to newly setup TMS carrier.
...
Carrier Services
If the TMS carrier requires to add carrier services, Select Admin>Carriers>Carrier Services.
...
Click Create New button.
...
Enter the Service Code and Service Name of the TMS carrier then click Save button.
...
Carrier services has been setup already to TMS carrier.
Note: If more than one service, add it one by one until all services are added.
...
Setup the Carrier Provider (Indigina TMS)
Provider Carrier Mappings
Select Admin>Carrier Providers>Provider Carrier Mappings
...
Click Create New button.
...
Enter the following:
Carrier Provider: Indigina TMS
Carrier: Select the created carrier
Release Profile: Select QA if it’s for UAT and LIVE for live environment
Mapped ID: Leave blank
Mapped Code: Is the carrier code
Once completed, Click Add&Close.
...
Provider carrier mappings has been setup already.
...
Provider Service Mappings
Add the provider service mappings.
Select Admin>Carrier Providers>Provider Service Mappings
...
Click Create New button.
...
Enter the following:
Carrier Provider: Indigina TMS
Carrier: Select the created carrier
Service Type: Select the carrier service
Release Profile: Select QA if it’s for UAT and LIVE for live environment
Mapped ID: Leave blank
Mapped Code: Is the Service Code
Once completed, Click Add&Close.
...
Provider service mappings has been setup already.
Note: If more than one service, add it one by one until all services are added.
...
Provider Integration
Note: Create New button is currently not available. (Back end job needed)
Newly created carrier must be added to activate TMS dispatch.
Select Admin>Carrier Providers>Provider Integration
...
Run the script:
--RUN TO ADD TO CarrierProviderIntegration (TO ACTIVATE TMS DISPATCH)
DECLARE @CarrierProviderID uniqueidentifier, @CarrierID uniqueidentifier, @NEWID uniqueidentifier, @CarrierName nvarchar(max), @CarrierProvider nvarchar(max),
@DCCompanyID uniqueidentifier, @DCID uniqueidentifier, @DCCompanyName nvarchar(max)
SET @CarrierName = 'Omni Parcel'
SET @CarrierProvider = 'Indigina TMS'
SET @DCCompanyName = 'Seko Hong Kong'
SET @NEWID = NEWID()
SELECT TOP 1 @DCCompanyID = CompanyID FROM Company WHERE DisableLevel = 0 AND CompanyID = OwnerCompanyID AND CompanyDescription = @DCCompanyName ORDER BY CreateDate
SELECT TOP 1 @DCID = DCID FROM DC WHERE DisableLevel = 0 AND CompanyID = @DCCompanyID ORDER BY CreateDate
SELECT TOP 1 @CarrierProviderID = CarrierProviderID FROM CarrierProvider WHERE Name = @CarrierProvider
SELECT TOP 1 @CarrierID = CompanyID FROM Company WHERE CompanyDescription = @CarrierName AND OwnerCompanyID = CompanyID AND DisableLevel = 0 ORDER BY CreateDate
INSERT INTO CarrierProviderIntegration (CarrierProviderIntegrationID, CarrierProviderID, CustomerID, DCID, CarrierID, CreateDate)
VALUES (@NEWID, @CarrierProviderID, NULL, @DCID, @CarrierID, GETUTCDATE())
Provider Settings
Note: Create New button is currently not available. (Back end job needed)
This is just an optional if customer requested for the carrier.
Select Admin>Carrier Providers>Provider Settings
...
Run the script:
--MANUAL ADD PROVIDER SETTING / RULES
DECLARE @CarrierProviderID uniqueidentifier, @CarrierID uniqueidentifier, @NEWID uniqueidentifier, @CarrierName nvarchar(max), @CarrierProvider nvarchar(max),
@Setting nvarchar(max), @Value nvarchar(max)
SET @CarrierName = 'P2P NL'
SET @CarrierProvider = 'Indigina TMS'
SET @Setting = 'SendParcelContent'
SET @Value = 'All'
SET @NEWID = NEWID()
SELECT TOP 1 @CarrierProviderID = CarrierProviderID FROM CarrierProvider WHERE Name = @CarrierProvider
SELECT TOP 1 @CarrierID = CompanyID FROM Company WHERE CompanyDescription = @CarrierName AND OwnerCompanyID = CompanyID AND DisableLevel = 0 ORDER BY CreateDate
INSERT INTO CarrierProviderSetting (CarrierProviderSettingID, CarrierProviderID, CustomerID, DCID, CarrierID, Setting, Value, CreateDate)
VALUES (@NEWID, @CarrierProviderID, NULL, NULL, @CarrierID, @Setting, @Value, GETUTCDATE())
TMS Carrier Setup - TMS Site
URL_UAT: https://tmsuat.supplystream.com
URL Live: https://tms.supplystream.com
Notes: Each client normally has their own set identifiers with the carrier.
Example:
For Interpost each client has their own "Authentication Key"
Hermes has a Child Client ID
Royal Mail has a username / password / service occurrence per client
This will identify the client when creating labels with the carrier.
To Set Up Carrier into TMS for customer:
Log into TMS site
My Account -> Default Integration Partner -> Select Indigina iHub
Select client: Ex. Heist Studios
...
System Admin -> Security -> Client Entitlements
Click on customer (ex. Heist Studios)
Tick Carrier (Ex. Hermes)
Click the Save button
...
Entity Setup -> Carrier Setup -> Maintain Carriers
Ex. Click on Hermes
Click the Edit icon next to Heist Studios – enter details on the child client ID for Hermes and Authentication key for Interpost (screenshot below is an example for Hermes)
Child Client ID: 018
Child Client Name: Heist Studios
Click the tick icon
Click the save button
...
NOTES:
These identify Hermes, (Don't change this)
but you can view this at
System Admin -> Settings -> Carrier Provider Settings
Click on Hermes
you will see client id etc. here.
...
That’s it for the TMS Client and Carrier setup in Supply Stream and TMS site.