Importing tracking information and fulfilling Shopify orders

Details about the following DropShop components
  1. Tracking details section
  2. Choosing a file to import and supported file types
  3. File import preview and column selection
  4. Communicating with customers
  5. Multiple tracking numbers per import file
  6. Managing parsing and fulfillment errors

Tracking Details Section

This section is used to help store owners understand how many associated tracking numbers have been imported so far for the DropShop bulk order 

Shopify Orders

The Shopify orders table column provides a count of the number of Shopify orders that were involved with this bulk order export. 

Imported Tracking Numbers

This column provides a count of how many tracking numbers have been imported and associated with the Shopify orders that relate to this bulk order. Usually there should be a one to one match between tracking numbers and orders, however, if your supplier needs to split up an order, and you have selected expect more than one tracking number per order, then these numbers may differ.


Choosing a file to import

Click within the 'Click here to choose a file' area to start the file import process. DropShop will store one file for each bulk export order. To associate a file with an order upload the file on the tracking details page. 

Supported file types

DropShop currently supports importing files of type .XLS, .XLSX, and .CSV 

If additional file types are required, please let us know and we will be happy to add a feature request.


Imported file preview and field selection

Once a file has been imported to a DropShop order, it needs to be processed in order to fulfill Shopify orders. This is completed by examining a preview of the file, mapping the corresponding file columns to DropShop fields, and then submitting the form. This will trigger fulfillment of Shopify orders and optionally email customers tracking updates.

File previews and multiple headers

This section shows a preview of the currently uploaded and unprocessed tracking file. Once an order has been successfully (or unsuccessfully) processed the imported file preview will not appear. The preview should show up to the first 4 lines from a file in order to give the store owner an opportunity to review the file for mapping purposes.

If the file was exported with bilingual column headings, or just multiple file heading in general, in order to begin file processing on the 3rd row of the file the user should select the checkbox signifying that "This import file has two header rows". If this setting is not chosen (and there is only one header) file processing will begin on the 2nd row of the file.

Column selection and mapping

Using the dropdown selectors the store owner can map import file columns with the required DropShop mapping fields of order ID (can either use the actual numeric Shopify order ID, or your stores vernacular Shopify order name), a tracking number to import (see more on import files with multiple tracking numbers per file), and a product SKU column to associate line items with supplier products.

If the 'multiple headers' checkbox was selected than both rows of header column values will appear in the dropdowns. You can choose an entry from either row 1 or 2, it doesn't matter. For example (when the 'multiple headers' checkbox is selected) from the file preview image above a user could select either '订单号' or 'Order Number' for the 'order id' drop down selector.


Communicating tracking numbers with customers

When the checkbox to 'Send an email tracking update to customers' is selected the regular Shopify shipping confirmation and update emails will be sent to customers at the time of DropShop tracking import. To review your shipping confirmation and update notifications you should visit your stores admin.

If you re-import tracking information, you may send multiple notifications to your customers. 


Multiple tracking numbers per file

When you import a file to DropShop by default we look for one tracking number to associate with each Shopify order. This means that for an imported file, for each Shopify order we will search from the top of the file to the bottom of the file and select the first tracking number found for each order. We will then skip any other tracking numbers until the Shopify order name or ID changes. We have found that most suppliers will provide one tracking number per shipment.


Handling parsing and fulfillment errors

When you upload and then process a file in DropShop the app may encounter two types of issues. One type relates to the structure and column selection of the file, and the other relates to the action of fulfilling Shopify orders with the provided tracking details.

File import parsing errors

This section details up to 15 errors and warnings that were detected when importing the selected file.

Some of these issues may just be warnings (in which case most of the file will still be imported) but some denoted with a line starting in "error" will stop that row from importing.

File fulfillment errors

This section details up to 15 errors and warning relating to the fulfillment of Shopify orders

When errors occur in this section, it is most likely caused by order already being fulfilled within Shopify. To avoid fulfillment issues you should follow the DropShop order workflow

Note: If there are errors in this section, you may want to examine the order within the Shopify admin to determine what went wrong.

Still need help? Contact Us Contact Us