Shipment & Tracking Number Import

Suggest Edits

The Shipping and Tracking # importer allows you to export a file with "shippable" orders and use it as a template to create shipments and import tracking numbers.

Features

Export a file with "shippable" orders
Import Shipments & Tracking Numbers for orders/items
Ship orders partially (Ship only certain items from an order and not others)
Ability to allow/deny ability to ship items that have not been invoiced (payment captured)
Already imported orders/items will not be shipped again
Supports partial shipments - only shipped SKUs/Quantities get shipped
Once all items of an order have been shipped, the order status changes to "Complete"
"Pending" orders will have order status changed to Processing after shipments are imported.
Supports multiple tracking numbers per shipment and import
Groups items into shipments by tracking number
Specify whether or not to notify customer about shipment, including their tracking numbers
Add comments to the shipment
Specify if comment should be included in the customer email

Choose File to upload
Click Upload File
Click Test File

If no errors are found, you will get a button "Import"

Exporting Shippable Orders

You can click to export all Shippable Orders.

What is a Shippable Order?

A Shippable Order is any order that can be shipped. This will exclude any orders that are canceled, complete, or processing where all items have already been shipped.

Specify which orders to export

You can also choose individual orders to export. Select the option from the Export dropdown and check-off which orders you would like to export. Then at the bottom of the list, click the "Export Orders" button.

CSV Template

📘
The order export will give you a "Full" template for the import. Some columns are not required but added to the export to make it easier to read.

744 — First 9 columns of Shippable Order Export File

The template will have 1 row for each product within each order. If an order has multiple items (products) it will need multiple rows in the CSV.

The columns included in the export are below:

Column	Description
Order Number	The order number for the item to be shipped. There will be 1 row for each item in the order. This structure must be kept for the import. *Required
Order Shipping Method	Shipping method selected by the customer for this order. This column is simply in the spreadsheet for reference.
Item ID	This is the unique ID assigned to the item in the order. It is not the product ID or the SKU. this field is essential for correctly generating the shipment. *Required
Item Name	Name of the product purchased
Item Status	This is the status of the item in the order: Invoiced: Qty ordered = Qty invoiced Pending: No items shipped, invoiced, canceled, refunded nor backordered Partial: Qty shipped and/or invoiced is greater than 1, but not equal to Qty ordered Backordered: Qty ordered = Qty backordered Mixed: When the item has been shipped but not invoiced - Note: May not appear in Export Shipped: Qty ordered = Qty shipped - Note: May not appear in Export Canceled: Qty ordered = Qty canceled - Note: May not appear in Export Refunded: Qty ordered = Qty canceled - Note: May not appear in Export
Item SKU	The SKU of the product in the order.
Item Qty Ordered	The quantity of an item that has been ordered.
Item Qty Invoiced	The quantity of the item ordered that has been Invoiced.
Item Qty Shipped	The quantity of the item ordered that has been shipped already.
Qty to Ship	The quantity of the item ordered that you want to ship (Qty may have already been shipped outside of Zoey. This is the Qty we want to now mark as shipped in Zoey.) - Required for generating the shipment. The value here can not be greater than the Item Qty Ordered subtracted by the Item Shipped values. *Required
Carrier	The “Carrier”. Options Below. - Required when adding a tracking number. Optional when NOT adding a tracking number: FedEx, USPS, UPS, DHL, or Custom *Required
Title	A title added to the tracking information (i.e. Standard Shipping - 5-7 days)
Tracking Number	The carrier tracking number for that item that will be added to the shipment record. Multiple items can have the same Tracking number. See “Shipment Generation” documentation below about how Shipments for individual orders will be grouped by matching tracking numbers. *Required
Comments	Comments that can be added to the shipment. Comments by default will be public and emailed to the customer if the Email Customer field is set to 1.
Email Customer	1 or 0 for Yes or No. This will trigger the configured New Shipment Email Template to be sent.
Include Comments In Email	1 or 0 for Yes or No. This will include imported comments if the email is specified to be sent.
Send Bill	Yes/No value to create a Bill for the Shipped Items.
Shipping Cost	Numerical value to set the Shipping Cost on the created Bill. Send Bill must be Yes for Shipping Cost to be applied.

🚧
Note: Non-shippable items will not be included in the Export.
This includes Virtual, Downloadable and Gift Card Products.

Bulk Shipment Import Settings

From the Shipment Import/Export Screen, go to Importer Settings > Click Here to go to the Importer settings.

Bulk Shipments Import Settings
Enabled	Yes or No
Invoice Shipment Settings	Do not allow uninvoiced Items to be shipped or Allow uninvoiced Items to be shipped.
Require Tracking Numbers In Import	Yes or No

Importing Shipments & Tracking Numbers

Once the CSV has been updated with values for the additional 7 fields, you will be able to upload the file in Import & Export > Shipments

Shipment Generation

Shipments will be generated for items grouped by Tracking Number.

Example #1: if 2 items the same order have the same Tracking Number entered into the CSV, the import will generate 1 shipment record for that order which will contain the 2 items and 1 Tracking Number.
Example #2: If a single order has multiple items, each with their own unique tracking numbers entered into the CSV, the import will generate a unique shipment record for that order for each of the items. In this case the customer can receive multiple emails if “Email Customer” is set to “1” in the CSV for all item rows.
Through the import, one shipment can not have multiple tracking numbers.
By default, items that have not been invoiced, or have invoices that are not marked with the status “paid” will not be able to be shipped. This is to protect the administrator from shipping items they have not captured payment for. There will be a setting that will allow the merchant to override this check.
Tracking numbers can not be added to items that have already been shipped. It will simply skip that row in the CSV and continue.
If the import includes item quantities that have already been shipped, the shipment for those items will not be created.

Invoice Setting

By default, you will be restricted from importing shipments for items that have not been Invoiced (payment captured). This setting can be changed in:
Import > Shipments > Importer Settings

Comments

Comments from each row will be aggregated and put onto the Shipment record of its associated Tracking Number. These are not Order comments, but Shipping record comments. They will be emailed to the customer in the New Shipment Email template if “Email Customer” is set to “1” in the CSV for all item rows with comments.

Emails

Emails will be sent for the Shipment and Invoice if both are specified to be created in the CSV (“Qty to Ship” and “Qty to Invoice”). Only one email will be sent per record generated according to the rules in the Shipment Generation and Invoice Generation documentation above. If “Email Customer” is set to “1” (yes) for 1 row, but set to “0” (no) for another, and both rows will be aggregated into a single Invoice or Shipment record, the Email WILL be sent.

Order Statuses

Order Statuses will follow the general rules for Pending - Processing - Complete.

If the order has no invoices or shipments, the Order Status will be “Pending”.
If the Order is partially invoiced or shipped by the import, the Status will change to “Processing”.
If the Order is fully Invoiced or Shipped by the import (but not both), the Order Status will change to “Processing”.
If the Order is fully Invoiced and Shipped by the import, the Order Status will be changed to “Complete”.

Note: this does not take into account any custom order statuses created by the administrator.

Updated 11 days ago