By importing a spreadsheet, you are able to import Shipment Information for multiple orders at once. 

Before You Start

For shipment imports to work, you will need to have set-up sales channel and shipping carrier mappings for the Sales Channel you are sharing updates with. This can be done by going to the Settings module and clicking on Sales Channels in the right hand sidebar, selecting the sales channel, clicking “Edit” and filling in the mappings manually.

Importing the Tracking Information

Go to the Orders Module and in the “Filter By” sidebar, select the Pending Fulfillment status dropdown and ensure all is selected. Click the “Import/Export” button and from the dropdown select “Import Shipment”

In the External Shipment Import window, in the yellow box, click on the Import Mappings dropdown. From here you can choose which Sales Channel/Shipment Mappings you want to reference for your import.

If you do not have any import mappings, you can also click the blue “Configure” button and add a new mapping set by clicking “+ New Mappings.” You can also edit existing mappings on this page.

Once you’ve selected your Import Mappings, click on the blue download button and Skubana will download an Excel for you based on the mappings selected.

In the Excel document, the first tab will include the Mappings you selected to download the document. This page can be used to copy and paste the right cell data for the Sales Channel and Shipping Carrier according to the mappings.

The second tab will have an empty Excel grid where you can fill in the following information about the shipments. The information is similar to what is captured on the Create External Shipments window on the Skubana UI. 

  • Sales Channel: Sales channel the order originated from (required)
  • Order Number: Order number as it appears within Skubana (required)
  • Shipping Carrier: Shipping Provider that shipped the order (required)
  • Tracking Number: Tracking number for the order shipment
  • Notify Customer: If YES Skubana will send an e-mail notification to the customer; If NO Skubana will not send an e-mail notification
  • Update Channel: If YES Skubana will share the tracking info with the sales channel; If NO Skubana will not share the tracking info with the sales channel
  • Ship Date: Date the order was shipped (should be included in MM/dd/yyyy format)
    NOTE: The data in these fields must match the data entered in Skubana or it may cause an error on upload.

Once your spreadsheet is completed, return to Skubana and the External Shipment Import modal and select the file you want to upload. Then click “Continue.”

Skubana will review the file and report how many new shipments were added, any existing shipments updated, or any errors in the Excel File. Errors in the file will be captured in the Error Log. A summary of the results can also be e-mailed so you can see which shipments had errors.

If needed, you can check the shipments you added/updated to ensure the changes were applied correctly.

Did this answer your question?