How To

The Import Shipping and Tracking File Template

Using the import shipping and tracking file template, merchants can bulk import tracking numbers and shipping dates for orders into ChannelAdvisor. To get a full overview of the methods for performing this task please see the Updating Shipping and Tracking Information page.

 

Prerequisites


You should be familiar with the following topics before continuing:

 

Shipping and Tracking Upload File Template Overview


First and foremost, you need to know that there are two shipment types –  Order Level Shipment and SKU Level Shipment. Here's the difference between those two types:

  • Order Level (Full) – Use this format to set the entire order as shipped.
  • SKU Level (Partial) – Use this format to set each SKU or line item from an order as shipped individually.

You can combine both shipment types in one file. But to do so you need to add the required information for an order or SKU in the specific columns of the file as shown in the table below.
If you want to send an Order Level Shipment you only need to supply the Invoice Number – the other columns are optional. If you want to send a SKU Level Shipment you need to supply the Invoice Number, SKU, Tracking Number, Quantity, and, if your account is MDC-enabled, DC Code.

To create a blank Shipping and Tracking Upload File simply click the icon below. A full description of each field in the file can also be referenced.

 

Field Name Description Order Level Shipment (Full) SKU Level Shipment (Partial)
Invoice Number

Must match either the Order ID or the Internal Invoice Number from the Checkout Report. If the number in the upload file does not match an Order ID, the system will check for a match on the Internal Invoice Number.

Required

Required

SKUThe item included in the order which has been shipped. You can include a row for each item in the order which has been fulfilled. 

Required

Tracking Number

The number assigned by the carrier to track the shipment.

 

Required

Quantity

The number of items that were included in the shipment for a specific SKU.

 

Required

DC Code

The code of the distribution center the items are being fulfilled from. Providing a DC Code allows ChannelAdvisor to be updated with the actual distribution center used for fulfillment and to maintain proper quantity levels.

When sending SKU level shipments for accounts where the multiple distribution center function is enabled, this field is required – even if you only have a single distribution center.
To check if your account is MDC-enabled go to Inventory > Settings > Inventory Settings and click the DC Settings button in the upper right corner. On the next page you should see this message in the first section Multiple Distribution Centers.

 

Conditionally Required (MDC accounts only)

Date Shipped

Date the order was shipped. If there is no Date Shipped value supplied, the system will use the import date as the Date Shipped. The date format for the file should match the date format of the posting account locale as visible on the All Sales page. The format of YYYY/MM/DD will work for all locales also.

  
Shipping Carrier Code

Must match a valid shipping carrier configured in the account.

  
Shipping Class Code

Must match a valid shipping class configured in the account. Required if Shipping Carrier has been supplied.

  
ShipmentCost

The actual shipment cost.

  
ShipmentTaxCost

The actual shipment tax cost.

  
ShipmentInsuranceCost

The actual shipment insurance cost.

  
SellerFulfillmentID

A unique identifier from the sellers shipment system, if provided.

  
PreventSiteProcessing

If this column is provided and contains a value of 'true' the marketplace will not be notified of this shipment.

  

Using the import shipping and tracking file template, merchants can bulk import tracking numbers and shipping dates for orders into ChannelAdvisor. To get a full overview of the methods for performing this task please see the Updating Shipping and Tracking Information page.

 

Prerequisites


You should be familiar with the following topics before continuing:

 

Shipping and Tracking Upload File Template Overview


First and foremost, you need to know that there are two shipment types –  Order Level Shipment and SKU Level Shipment. Here's the difference between those two types:

  • Order Level (Full) – Use this format to set the entire order as shipped.
  • SKU Level (Partial) – Use this format to set each SKU or line item from an order as shipped individually.

You can combine both shipment types in one file. But to do so you need to add the required information for an order or SKU in the specific columns of the file as shown in the table below.
If you want to send an Order Level Shipment you only need to supply the Invoice Number – the other columns are optional. If you want to send a SKU Level Shipment you need to supply the Invoice Number, SKU, Tracking Number, Quantity, and, if your account is MDC-enabled, DC Code.

To create a blank Shipping and Tracking Upload File simply click the icon below. A full description of each field in the file can also be referenced.

 

Field Name Description Order Level Shipment (Full) SKU Level Shipment (Partial)
Invoice Number

Must match either the Order ID or the Internal Invoice Number from the Checkout Report. If the number in the upload file does not match an Order ID, the system will check for a match on the Internal Invoice Number.

Required

Required

SKUThe item included in the order which has been shipped. You can include a row for each item in the order which has been fulfilled. 

Required

Tracking Number

The number assigned by the carrier to track the shipment.

 

Required

Quantity

The number of items that were included in the shipment for a specific SKU.

 

Required

DC Code

The code of the distribution center the items are being fulfilled from. Providing a DC Code allows ChannelAdvisor to be updated with the actual distribution center used for fulfillment and to maintain proper quantity levels.

When sending SKU level shipments for accounts where the multiple distribution center function is enabled, this field is required – even if you only have a single distribution center.
To check if your account is MDC-enabled go to Inventory > Settings > Inventory Settings and click the DC Settings button in the upper right corner. On the next page you should see this message in the first section Multiple Distribution Centers.

 

Conditionally Required (MDC accounts only)

Date Shipped

Date the order was shipped. If there is no Date Shipped value supplied, the system will use the import date as the Date Shipped. The date format for the file should match the date format of the posting account locale as visible on the All Sales page. The format of YYYY/MM/DD will work for all locales also.

  
Shipping Carrier Code

Must match a valid shipping carrier configured in the account.

  
Shipping Class Code

Must match a valid shipping class configured in the account. Required if Shipping Carrier has been supplied.

  
ShipmentCost

The actual shipment cost.

  
ShipmentTaxCost

The actual shipment tax cost.

  
ShipmentInsuranceCost

The actual shipment insurance cost.

  
SellerFulfillmentID

A unique identifier from the sellers shipment system, if provided.

  
PreventSiteProcessing

If this column is provided and contains a value of 'true' the marketplace will not be notified of this shipment.

  
0
Your rating: None
0
Your rating: None