API Integrations Through DSCO

Prerequisite: This feature requires selecting the Client Setting Enable Custom Company Settings. The custom settings will store company-level information for use by the plugins and channel integrations.

This topic is about integrating your Sellercloud account with channels via DSCO. The channels that utilize this integration method are:

  • Kohl’s
  • Neiman Marcus
  • Nordstrom Rack
  • Nordstrom Rack Hautelook
  • Chewy

Integration workflow

The integration workflow comprises the following components:

  1. Seller: Create a separate company for Lowe’s, and then create the required custom company settings.
  2. Sellercloud Support: Create the required custom order and product columns.
  3. Sellercloud Support: Install the plugins on the server.
  4. Seller: Create saved searches and scheduled tasks for the installed plugins.

Creating custom columns

There are a variety of custom columns that can be created for this integration type. Each is specific to a plugin. Refer to the chart below for information on the custom columns for each plugin. Sellercloud Support will create the following settings for your channel company.

Column Description
DSCOItemID Must be set in Sellercloud
DSCOSafetyQty Sets a safety quantity on a product level
DSCOIsDiscontinued Boolean-type; defaults to false
DSCO_sendDiscontinued Boolean-type; set to true; products MUST be discontinued in Sellercloud
DSCOExpectedDeliveryDate Sellercloud will follow entered date; If no date is entered, 7 days from the current date will be sent

Installing the plugins

A plugin contains instructions on how to create an import or export file. For example, instead of just mapping an order of columns for an export file, a plugin lets you to do more complex tasks than having one row per line item or one row per product. You can also manipulate values that are exported, allowing the file to conform to any standard.

Sellercloud Support will install the following Lowe’s plugins onto the server.

The table below also describes the type of saved search that the seller will create for the plugins’ scheduled tasks.
Plugin Description Instructions
DSCO Inventory Export
 This plugin exports inventory to DSCO using API. However, note:

  • Products must exist in DSCO in order to be exported
  • Prices are not included in inventory export updates
 Requires custom company setting: DSCO_Token

Optional:

DSCO_DontSendItemID

DSCO_WarehouseCodes

  • enter list of warehouse codes separated by semicolons
DSCO Table Order Import
 This plugin imports all new orders from DSCO and creates them in Sellercloud. It also saves the data to DSCO_OrderTable.

It acknowledges that after the order is created, it will be moved to Shipment Pending in DSCO and will no longer be included in the new orders download.

Checks for products by matching:

  • DSCO SKU to UPC
  • DSCO SKU to SC ProductID
  • DSCO UPC to SC UPC
  • DSCOItemID to SC custom column DSCOItemID
  • DSCO PartnerSKU to SC ProductID
 Requires custom company column:

  • DSCO_Token on compeny of import

Optional:

  • DSCO_IntegrationName
    • if set to valid Sellercloud order source name, orders will be created with that order source
  • DSCO_MarkOrdersUnpaid
  • DSCO_LockShippingMethod
DSCO Tracking Export
 This plugin sends tracking info to DSCO via API. It marks orders as SRCUpdatedForShippipng so the saved search can filter by this field. Requires custom company settings:

  • DSCO_Token
  • DSCO_SupplierName
  • DSCO_SupplierID (dscoAccountID)

Optional:

  • DSCO_SendKitParentOnly- if set to true, it will only update DSCO for kit parent information
DSCO API Invoice Export
 This plugin creates an invoice on DSCO via API. It also saves the InvoiceID to a custom column. Requires custom company setting: DSCO_Token

Creating saved searches and scheduled tasks

Each of the plugins requires the setup of a scheduled task, which let you configure certain actions for automatic recurrence at specific intervals. Each of the scheduled tasks will use saved searches.

For example, a scheduled task for the Tracking Export would use a Tracking saved search.

Plugin Saved Search/ Scheduled Tasks
DSCO API Invoice Export
  1. Create an Orders Saved Search.
  2. Filter as follows:
  • Company = Your channel company
  • Status = InProcess or Completed
  • Shipping Status = Fully Shipped
  • Tracking Uploaded = Uploaded
  • Invoice Sent = Not Sent
DSCO Tracking Export
  1. Create an Orders Saved Search.
  2. Filter as follows:
  • Company = Your channel company
  • Status = InProcess or Completed
  • Shipping Status = Fully Shipped
  • Tracking Uploaded = Not Uploaded
DSCO Inventory Export
  1. Create an Inventory Saved Search.
  2. Choose any filters you want to choose which products to send.
Learn how to create a tracking export scheduled task.

Was this article helpful?

Yes No

Related Articles