Kohl’s Account Integration

Overview

Kohl’s is one of the largest retail chains and E-Commerce platforms within the United States, selling clothing, kitchenware, toys, and bedding items. Sellercloud connects to Kohl’s through DSCO’s platform by utilizing custom-built API plugins.

It is recommended to have a company designated for this integration where the company settings and relevant scheduled tasks would be set up.

Prerequisite

To successfully connect your Kohl’s account, you will need to connect to DSCO via the below plugins:

  • DSCO API v3 Order Import
  • DSCO API v3 Tracking Order Export
  • DSCO API v3 Inventory Export
  • DSCO API v3 Invoice Export
  • PDF Invoice Plugin for your integration type

Reach out to the Sellercloud support team to have these plugins installed on your server. You will need to have your Kohl’s account connected to your DSCO account prior to initializing the setup in Sellercloud.

DSCO may require you to perform testing before you could go into production with the integration. This involves completing test orders, invoices, and inventory uploads according to the DSCO-provided test plan. If you would like a dedicated representative to complete the testing for your account and ensure that the setup is configured accordingly, we recommend opting in for Premium Support.

Integrate with Kohl’s through DSCO

Following the plugin installation, it is necessary that you create channel-specific custom columns. You can reach out to our Support team to have them created for you on the backend.

Next, you will need to create the following custom settings under the company in which the integration will be set up. To create the relevant custom company settings, navigate to Settings > Company > Toolbox > Custom settings. Refer to the tables below for a definition of each setting:

SETTING NAME DESCRIPTION
ORDER RELATED COMPANY SETTINGS
DSCO_Token (required) The API token used to connect. Can be requested from the DSCO support.
DSCO_SupplierId (required) Your Supplier ID – provided by DSCO
DSCO_SupplierName (required) Your Supplier Name – provided by DSCO
DSCO_ExportSsccCode (optional)  True or False, if true, exports the SSCC code with the tracking
DSCO_IntegrationName (optional)  Can be set as a Sellercloud channel name; The order source will appear as the set channel name
DSCO_MarkOrdersUnpaid (optional)  True or False; If true, sets the order as “unpaid”
DSCO_LockShippingMethod (optional)  True or False; If true, does not allow shipping methods on orders to be changed
DSCO_IncludeWarehouseCodesInOrderImport (optional)  True or False; If true, sets the “Ship From” warehouse with the order import; Checks setting “DSCO_WarehouseCodes” for the codes
DSCO_WarehouseCodes (optional)  List of Sellercloud WarehouseIDs and DSCO warehouse codes (connected by a hyphen), separated by comma. for example: 144-MyDSCO Warehouse, 145-My OtherWH.  Used when DSCO_IncludeWarehouseCodesInOrderImport is true.
DSCO_ShippingRequiresThirdPartyBilling (optional)  True or False; If true the order ShippingRequiresThirdParty will be set to true
DSCO_AllowShippingUSPS (optional)  True or False, if true, and DSCO_ShippingRequiresThirdPartyBilling is True, and the order’s carrier is USPS, we will NOT set ShippingRequiresThirdParty to “true”
DSCO_AllowShippingUPS (optional)  True or False, if true, and DSCO_ShippingRequiresThirdPartyBilling is True, and the order’s carrier is UPS, we will NOT set ShippingRequiresThirdParty to “true”
DSCO_CreatePayments (optional)  Defaults to true if missing.  Determines if an order payment will be imported or not based on the setting value for the order channel (defaults to Website but can be changed by using company setting DSCO_IntegrationName).
DSCO_StandardWarehouseCode (optional)  DSCO’s standard Warehouse code that is exported with the tracking
DSCO_IncludeWarehouseCodeInTracking (optional)  True or False, if true, sends the DSCO standard warehouse code from the custom setting “DSCO_StandardWarehouseCode”
DSCO_SendOnePackagePerKitParent (optional)  True or False, if true, each kit parent will be in a separate package
DSCO_SendKitParentOnly (optional)  True or False, if true, only sends the parent SKU with the tracking without the components
DSCO_SendShipFromInfo (optional)  True or False, if true, sends Ship from information with the tracking export
DSCO_SendPackageWeight (optional)  True or False, if true, sends the package weights with the tracking export
DSCO_SendInvoiceDate (optional)  True or False, if true, sends the Invoice date
DSCO_SendCurrencyCode (optional)  True or False, if true, sends the exported order’s currency code
DSCO_NetTermDays (optional)  Numeric only; sends NetTermDays with the invoice export
DSCO_NetTermType (optional)  Exported when DSCO_NetTermDays exists and isn’t 0
DSCO_SendShipToInfo (optional)  True or False, if true, sends the “ShipTo” information with the invoice export
DSCO_SendSubtotal (optional)  True or False, if true, enables exporting order line subtotal with the invoice export
SETTING NAME DESCRIPTION
PRODUCT AND INVENTORY CUSTOM COMPANY SETTINGS
Consider replenishable products (optional)  True or False, defaults to False; If true, works with Replenishable qty
Replenishable qty (optional)  Qty that will be exported if available qty is 0 or less; Only works if “Consider Replenishable Products” is set to True
DSCOUseExpectedDeliveryDate (optional)  True or False, defaults to False; When set to true, exports custom column DSCOEXPECTEDDELIVERYDATE. If missing or disabled, the exported date will be a week ahead
DSCO_WarehouseCodes (optional)  List of Sellercloud WarehouseIDs mapped to the DSCO Warehouse codes separated by a hyphen; example: [Sellercloud warehouseID-DSCOWarehouseCode]; 123-Lakewood; 245-BostonWH
DSCO_WarehouseCode (required) DSCO warehouse code used by default when DSCO_WarehouseCodes has no value
DSCO_DontSendItemID (optional)  True or False, defaults to false. When set to true, inventory updates will not include ItemID and DSCO will match to the SKU instead
DSCOSendCost  (optional)  True or False, defaults to false. When set to true, sends custom column DSCOCost
DSCO_SendDiscontinued (optional)  True or False, defaults to false. When set to true, sends custom column DSCOIsDiscontinued.
DSCO_SendUPC (optional)  True or False, defaults to false. When true, sends UPC with the inventory export.

Obtain an API Token and your DSCO Supplier ID/Name from the DSCO support team and populate them in the designated custom company settings.

You must create a scheduled task for each plugin type. Visit this page here for a step-by-step guide on how to set up scheduled tasks. 

Saved searches are required for the Order Export and Product Export task types. Create and set up Saved Searches for the scheduled tasks and assign them accordingly. Learn more about how to create saved searches here.


Automate Order Download, Tracking and Invoice upload

In order to ensure a seamless integration, you will need to automate the order imports, tracking, and invoice exports, along with the inventory updates. To do that, you will need to create scheduled tasks for each plugin type.

Create a Scheduled Task for Order Import

Navigate to your desired company > Scheduled Tasks > Press the green + icon at the right bottom corner to Create New Scheduled Task. A pop-up will appear.

  1. Choose the Task Type (Import Orders), Task NameCompany and Start Time. The start time includes a calendar date and time. You can select both values from the Calendar and Time View pop-ups. Enter the information required > Create.
  2. Go to the Details panel > Create Orders For Company > Choose the company from the drop-down menu and select the appropriate DSCO API v3 Order Import plugin.
  3. Navigate to the Import Options and choose None from the dropdown.
  4. Specify the task frequency. Schedule the task to recur at your desired intervals.
    The frequency of the tasks should range between thirty minutes to an hour to ensure optimal performance.
  5. Click on the Toggle button to enable the task.

Create a Scheduled Task for Tracking and Invoice Export

  1. Go to Settings > Scheduled Tasks > Click on the plus icon to create a new scheduled task.
  2. Select Export Orders as a Task Type from the dropdown menu > Populate the fields Task Name, Company, and Start Time > Click Create.
    Note: The frequency of the tasks should range between thirty minutes to an hour to ensure optimal performance.
  3. Go to Details panel > User ID > Select the ID of the account where the Saved searches were previously created.
  4. From the drop-down menu > Select the respective searches for the task.
  5. Go to Export via > Select the appropriate plugin/s from the drop-down menu.
  6. Enable the settings This Is Tracking Export for the Tracking Export task and This Is Invoice Export for the Invoice Export task.
  7. Go to the Export Options and choose None from the dropdown.
  8. Save.

Note: All DSCO/Kohl’s scheduled tasks of type Export should be set to Export to > None since they’ll be using a direct server-to-server connection via API.


Set up Kohl’s PDF invoices

If you would like to print your PDF invoices for your Kohl’s orders through either Sellercloud or ShipBridge, you will need to have the Kohl’s Invoice PDF plugin set up under your designated Kohl’s company.

To do that, navigate to Settings > select your Kohl’s Company > Toolbox > Invoice settings > choose your Kohl’s PDF invoice plugin > Save.


Cancel a Kohl’s Order

You can only cancel an order before it is marked Ship Confirmed. If it is already Ship Confirmed, you must issue a refund.

To cancel an order:

Navigate to Orders > Manage Orders > Open an order > Actions menu > Set Cancelled Internally.Cancel Staples Order

Please note that this action will only cancel the order on Sellercloud and not on DSCO.

Once you’re fully ready to automate the integration, go to each scheduled task you’ve created and mark it as Enabled.


Was this article helpful?