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.
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.
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:
|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|
|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.
- Choose the Task Type (Import Orders), Task Name, Company 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.
- 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.
- Navigate to the Import Options and choose None from the dropdown.
- 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.
- Click on the Toggle button to enable the task.
Create a Scheduled Task for Tracking and Invoice Export
- Go to Settings > Scheduled Tasks > Click on the plus icon to create a new scheduled task.
- 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.
- Go to Details panel > User ID > Select the ID of the account where the Saved searches were previously created.
- From the drop-down menu > Select the respective searches for the task.
- Go to Export via > Select the appropriate plugin/s from the drop-down menu.
- Enable the settings This Is Tracking Export for the Tracking Export task and This Is Invoice Export for the Invoice Export task.
- Go to the Export Options and choose None from the dropdown.
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.
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:
Once you’re fully ready to automate the integration, go to each scheduled task you’ve created and mark it as Enabled.