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:
- Neiman Marcus
- Nordstrom Rack
- Nordstrom Rack Hautelook
The integration workflow comprises the following components:
- Seller: Create a separate company for Lowe’s, and then create the required custom company settings.
- Sellercloud Support: Create the required custom order and product columns.
- Sellercloud Support: Install the plugins on the server.
- 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.
|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.
DSCO Inventory Export
|This plugin exports inventory to DSCO using API. However, note:
||Requires custom company setting: DSCO_Token
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:
|Requires custom company column:
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 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||
|DSCO Tracking Export||
|DSCO Inventory Export||