Kohl's Shipping Orders Manual File Upload via SFTP

By: Karianne Muckle


Manual File Upload in the Portal

Processing orders through file uploads in the portal is much faster than processing one-by-one. Because Kohl’s requires that you ship and invoice at the same time, we have a special file for you to use when manually uploading files to the portal. For this test we are going to ship and invoice an order with two items in it. Choose any of the pending orders. Note: The Ship Carrier, Ship Method, and/or Shipping Service Level Code uploaded MUST match what was requested on the order.

Custom Kohl’s Shipment + Invoice Flat File

Please use this special flat file when uploading shipments and invoices to Dsco for Kohl’s. This file contains all the information Kohl’s needs to close an order. You can download the file here. Once you have created a standard flat file with your shipment and invoice data, continue to the following steps to upload the file. You will upload this file in the Invoices section of Dsco instead of in the Orders section.

  1. Select Invoices in the side navigation, or just click here.
  2. Select the Upload Invoices button under the main navigation.
  3. On the left side of the page, select the File Type you would like to upload. This special file is XLS.
  4. Select the Choose File button and find the file on your computer.
  5. Select the Invoice button to upload the invoice file to Dsco

File Transaction History

A powerful feature in Dsco is the ability to view the history of any file processing in Dsco. This goes for all manual or automated uploads or downloads. You can use it now to see if the file you sent Dsco was properly loaded onto the platform. To check your automation history, select Automation in the main navigation and then select History, or just click here.

On this page, you will see a list of all the processes that have run on your account. On the left side are options to filter the list on the right. One of the most useful is the Did Work checkbox. Selecting this checkbox will filter the list to show only processes that actually performed some type of work importing inventory or exporting orders.

You may see the top process in the list has a Status of Queued, Running, or Finished. If you refresh the page, you may see the status change depending on the state of the process. Some processes may take a couple of minutes to complete if there are many records being processed. Once you see the Status is Finished you can see a summary of the Result of the process —- how many records were Successful, Failed or Ignored —- on the far right side. Click the Finished/Failed link and you will see the specific result of each record in the process. If they were not successful, the history will tell you exactly what failed and why. Contact onboarding support at dscopartnersetup@commercehub.com if you have questions about failures you see.

Order Shipment and Invoice Test

Once you have successfully shipped and invoiced this order, enter its PO number, click the button below and I will validate that you shipped and invoiced the order.

NOTE: The combination of Ship Carrier and Ship Method, or Shipping Service Level Code you give on the shipment MUST match what was requested on the order.