API Integrations Through DSCO

Updated 2 weeks ago

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

DSCODiscontinued

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.


How did we do?


Explore our brands and social media
Skustack Memaila Turnstock WayToPay.Me Facebook Instagram Linkedin YouToube Twitter