Extensiv (3PL Central) Integration

Overview

Extensiv, formerly known as 3PL Central, is a leading provider of cloud-based warehouse management software and fulfillment solutions tailored for third-party logistics (3PL) providers, e-commerce businesses, and omnichannel retailers.

Integrating Extensiv allows you to export your channel orders for fulfillment, import tracking information, and receive available inventory data. This integration works by transmitting information between the two services via API through plugins and Scheduled Tasks.

To have a dedicated representative complete the testing for your account and ensure that the setup is configured correctly, we recommend Premium Support.

Prerequisites

Before you can integrate 3PL Central into Sellercloud, complete the following requirements.

We recommend creating a Company where you will set up the Custom Company Settings and automate the plugins with Scheduled Tasks.

3PL Support

You must contact 3PL Central for your API credentials: Client ID, Client Secret Key, and Customer ID. You will need them when setting up the custom company settings.

You may need to request API credentials from your 3PL. Extensiv offers API credentials to its clients, but will not necessarily share them with the customers of their clients. If your 3PL (as an Extensiv customer) cannot locate their credentials in their account, they must contact their account manager at Extensiv.

Sellercloud Support

Open a ticket with Sellercloud Support and request the following plugins to be installed on your server:

3PL Central Order Export – Exports orders from Sellercloud to 3PL Central via API.
3PL Central Get Tracking Order Export – Imports tracking information from 3PL Central via API.
(Optional) 3PL Central Inventory Import Product Import – Imports inventory from 3PL Central via API.

If necessary, you can request additional customizations or other plugins for this integration. Any such modifications will be billable.

Custom Company Settings

Create the following Custom Company Settings in the company designated for the integration:

3PLCentralClientID – Provided by your 3PL.
3PLCentralClientSecretKey – Provided by your 3PL.
3PLCentralClientTPL – Provided by your 3PL.
3PLCentralCustomerID – Provided by your 3PL.
(Optional) 3PLUserLoginID – If populated, will send this ID to the Token Request instead of the above CustomerID.
ThreePLPassword – Your 3PL user password.
ThreePLLogin – Your 3PL user login.
ThreePLKEY – Provided by your 3PL.
3PLCentralFacilityID – Provided by your 3PL.
(Optional) RemoveLTFromURL – This setting allows you to modify the request for shipped orders (tracking). By default, we only import shipments that are Less Than 30 days old. If you set this to TRUE, we will remove this parameter and pull older shipments. However, we recommend keeping this setting disabled to prevent throttling and delays.
(Optional) 3PL Central - Only request closed orders – Defaults to False. If set to True, we will only fetch Closed orders.
(Optional) 3PL Central - Import shipping carrier and method – Defaults to true. Set to True to retrieve carrier information.
UseShippingMethodSelectedIn3plPlugin – Enable to use custom Shipping Method Mapping.
(Optional) 3PLCentralDefaultCarrier – Will send if the setting is created. To send an empty string, enter the value of the custom setting as ‘BLANK’. If the setting doesn’t exist, we will send ‘CUST’, or if UseShippingMethodSelectedIn3plPlugin is enabled will send the order’s shipping service method selected.
(Optional) 3PLCentralDefaultMode – We will send it if the setting is created. To send an empty string, enter the value of the custom setting as ‘BLANK’, otherwise we will send ‘BEST’.
(Optional) 3PLCentralCarrierAccountsFileID – You can fill in the ID of a file you have uploaded to the Custom Documents page of the company. This allows you to set up custom mappings for multiple carrier accounts per customer.
(Optional) UseSCOrderId – Defaults to False. If set to True, we will send the SC order ID as referenceNum. When False, we send the OrderSourceOrderID.
(Optional) 3PLCentralFacilityIDPerWarehouse – Semicolon-delimited list of pairs having the following format: <FacilityID>-<SCWarehouseID>. When populated, we will try to match the FacilityID assigned to the first order item.
3PLWarehouseID – Populate with the Sellrcloud numerical ID of the Warehouse in which the 3PL Central inventory should be added to.
(Optional) 3PLUseInventoryEndPoint – Defaults to FALSE, where it uses stockdetails. Set to TRUE to use inventory, which may be necessary to ensure all locations are returned (such as ones with unsellable quantities).

Custom Product Columns

Create the following Custom Product Column:

(Optional) WarehouseSKU – The product’s SKU at your 3PL. Set the Data Type to String.

Custom Order Columns

Create the following Custom Order Columns:

(Optional) Custom_Order_Field_1 – This column should be used for Bill of Lading. If it exists and is populated, we will include it in the Order Export.
(Optional) RetailerID – populates the externalID field in the retailerInfo in the request
(Optional) RetailerName – populates the name field in the retailerInfo in the request

Order Export

The 3PL Central Order Export plugin exports orders from Sellercloud to 3PL Central via API and sets the Dropship Status of the exported orders to Dropship: Requested.

The Custom Company Setting UseSCOrderId controls what identifier we use for the reference field when sending orders to Extensiv. When enabled, we use the Sellercloud Order ID. If it's disabled or missing, we will send the Channel Order ID. In case the setting is disabled and there is no Channel Order ID, we will use the Sellercloud Order ID.

Before you move on, create a Saved Search to determine which orders will be sent to 3PL Central. We recommend using the filter Dropship status – None, but you can add any other criteria to customize the order list.

Automate Order Export

To create a Scheduled Task that exports orders:

Navigate to Settings > Scheduled Tasks > Manage Scheduled Tasks.
Click the green + icon: Create New Scheduled Task.
Complete as follows:
1. Click Task Type and select Export Orders.
2. Set the Task Name.
3. Select the Company.
4. Select the Start Time.
5. Click CREATE.
On the Scheduled Task page, click the Edit button at the top right corner.
In the Details panel:
1. Click the User ID menu and select your email.
2. Click the Saved Search menu and select the saved search you created earlier.
3. Click the Export Via menu and select 3PL Central Order Export.
In the Export Options section, set Export To to None.
In the Frequency section, specify the task frequency. For optimal performance, select a range between thirty minutes and one hour.
In the General section, click the Enable toggle button.
Click Save.

Tracking Import

The 3PL Central Get Tracking Order Export imports tracking information from 3PL Central (Extensiv) into Sellercloud via API. However, the Scheduled Task must be set to Export Orders because the plugin sends an API call from Sellercloud in order to request the latest shipments.

The Scheduled Task requires a Saved Search, however, the requested orders are determined by the API call rather than the selected filters. You can create and set any Saved Search.

You can enable the RemoveLTFromURL Custom Company Setting to ensure the plugin requests orders shipped more than 30 days prior. We recommend only using this when there are specific shipments you need to import, but keep it disabled otherwise.

Automate Tracking Import

To create a Scheduled Task that imports order tracking:

Navigate to Settings > Scheduled Tasks > Manage Scheduled Tasks.
Click the green + icon: Create New Scheduled Task.
Complete as follows:
1. Click Task Type and select Export Orders.
2. Set the Task Name.
3. Select the Company.
4. Select the Start Time.
5. Click CREATE.
On the Scheduled Task page, click the Edit button at the top right corner.
In the Details panel:
1. Click the User ID menu and select your email.
2. Click the Saved Search menu and select the saved search you created earlier.
3. Click the Export Via menu and select 3PL Central Get Tracking Order Export.
In the Export Options section, set Export To to None.
In the Frequency section, specify the task frequency. For optimal performance, select a range between thirty minutes and one hour.
In the General panel, click the Enable toggle button.
Click Save.

Inventory Import

The 3PL Central Inventory Import Product Import imports inventory from 3PL Central (Extensiv) into Sellercloud via API.

We recommend creating a dedicated Warehouse in Sellercloud where the quantities should be imported. You can map it in the 3PLWarehouseID Custom Company Setting. The plugin will zero out all product quantities within the mapped warehouse for the SKUs not received in the latest response.

The plugin imports the quantity we receive in the OnHand property sent by 3PL Central.

Automate Inventory Import

To create a Scheduled Task that imports inventory:

Navigate to Settings > Scheduled Tasks > Manage Scheduled Tasks.
Click the green + icon: Create New Scheduled Task.
Complete as follows:
1. Click Task Type and select Import Products.
2. Set the Task Name.
3. Select the Company.
4. Select the Start Time.
5. Click CREATE.
The Scheduled Task Details page will open automatically. Click the Edit button at the top right corner.
In the Details panel:
1. Click the Import Via menu and select 3PL Central Inventory Import.
In the Import Options panel, set Import From to None.
In the Frequency panel, specify the task frequency. For optimal performance, select a range between thirty minutes and one hour.
In the General panel, click the Enable toggle button.
Click Save.