Extensiv (3PL Central) Integration

Overview

3PL Central (aka Extensiv) is a third-party logistics (3PL) technology used by a number of 3PL providers. This connection between 3PL Central and Sellercloud is done through plugins and scheduled tasks.

With the integration, you can access 3PL Central‘s inventory management and reporting capabilities. Additionally, you can send order information, such as tracking numbers, back to Sellercloud.

Integrate with 3PL Central

The following specialized plugins must be set up to integrate with 3PL Central:

• 3PL Central Order Export
• 3PL Central Get Tracking Import
• 3PL Central Inventory Import (optional)

3PL Central Order Export

The plugin uses 3PL Central’s REST API.

• The plugin will get a token from the API before sending orders using the credentials from these settings: (The values can be received from 3PL Сentral)
  • 3PLCentralClientID
  • 3PLCentralClientSecretKey
  • 3PLCentralClientTPL

• The order is sent in JSON format
• CustomerID and FacilityID are taken from the following custom settings:
  • 3PLCentralCustomerID
  • 3PLCentralFacilityID
  • 3PLWarehouseID

We will send the OrderSourceOrderID of the order in Sellercloud as the reference field to 3PL Central. If the OrderSourceOrderID is missing or empty, we will export the OrderID as the reference ID instead.
If there is a customer shipping account set on the customer level, Sellercloud will send that account number.
The order is set to Dropship: Requested so that it does not go into any other shipping software.

3PL Central Get Tracking Order Export

This plugin also uses the above settings.

• Sellercloud requests from 3PL Central all closed orders with tracking that were modified in the past 30 days.
• The orders should be marked as shipped with tracking if not marked yet.

3PL Central Inventory Import

This plugin also uses all of the above settings. Takes the value from the “Available” field in the response and imports it into the designated warehouse in Sellercloud.

• 3PLWarehouseID – the Sellercloud warehouse ID to import the inventory in.

Automate Order Export and Tracking Import

You can automate the process of exporting orders and importing tracking by creating scheduled tasks. Read more about Scheduled Tasks.

Create a Scheduled Task for Order Export

To create a scheduled task for order export in your Sellercloud account:

1. Go to Settings > Scheduled Tasks > Manage Scheduled Tasks.
2. Click the plus icon to create a new scheduled task.
3. Select Export Orders as the Task Type from the dropdown menu.
4. Populate the following fields: Task Name, Company, and Start Time.
5. Click Create. A new scheduled task will be created and displayed in the list on the Manage Scheduled Tasks page.
6. Select your task to open the task details page. Click Edit.
   Note: The frequency of the tasks should be chosen based on the volume of orders.
7. Go to the Details panel > User ID > Select the ID of the account where the Saved Search for the export was created from the dropdown menu > Select the search.
8.  Go to Export Via panel > Select 3PL Central Order Export > Type the File Name in the field below.
9. Go to Export Options panel > Export To > Select where the orders should be exported.
10. Click Save to save the changes.

Create a Scheduled Task for Tracking Import

For the plugin to be able to Import Shipping Information for your orders, you need an Order Export type task, as it exports an API call that requests the tracking.

To create a scheduled task for tracking import in your Sellercloud account:

1. Go to Settings > Scheduled Tasks > Manage Scheduled Tasks.
2. Click the plus icon to create a new scheduled task.
3. Select Export Orders as the Task Type from the dropdown menu.
4. Populate the following fields: Task Name, Company, and Start Time.
5. Click Create. A new task will be created and displayed in the list on the Manage Scheduled Tasks page.
6. Select your task to open the task details page. Click Edit.
7. Go to the Details panel > User ID > Select the ID of the account where the Saved Search for the export was created from the dropdown menu > Select the search.
8. In the Plugin field, select 3PL Central Get Tracking Order Export from the dropdown menu.
9. Click Save to save the changes.

Create a Scheduled Task for Inventory Import

1. Go to Settings > Scheduled Tasks > Manage Scheduled Tasks.
2. Click the plus icon to create a new scheduled task.
3. Select Import Products as the Task Type from the dropdown menu.
4. Populate the following fields: Task Name, Company, and Start Time.
5. Click Create. A new task will be created and displayed in the list on the Manage Scheduled Tasks page.
6. Select your task to open the task details page. Click Edit.
7. In the Plugin field, select 3PL Central Inventory Import from the dropdown menu.
8. Click Save to save the changes.