Extensiv (3PL Central) Integration

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:

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:

Custom Product Columns

Create the following Custom Product Column:

Custom Order Columns

Create the following Custom Order Columns:

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:

  1. Navigate to Settings > Scheduled Tasks > Manage Scheduled Tasks.
  2. Click the green + icon: Create New Scheduled Task.
  3. 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.
  4. On the Scheduled Task page, click the Edit button at the top right corner.
  5. 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.
  6. In the Export Option s section, set Export To to None.
  7. In the Frequency section, specify the task frequency. For optimal performance, select a range between thirty minutes and one hour.
  8. In the General section, click the Enable toggle button.
  9. 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:

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:

  1. Navigate to Settings > Scheduled Tasks > Manage Scheduled Tasks.
  2. Click the green + icon: Create New Scheduled Task.
  3. 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.
  4. The Scheduled Task Details page will open automatically. Click the Edit button at the top right corner.
  5. In the Details panel:
    1. Click the Import Via menu and select 3PL Central Inventory Import.
  6. In the Import Options panel, set Import From to None.
  7. In the Frequency panel, specify the task frequency. For optimal performance, select a range between thirty minutes and one hour.
  8. In the General panel, click the Enable toggle button.
  9. Click Save.