Upload Tracking Numbers for Dropship Shipments

To upload tracking numbers for shipments from Dropship vendors, you must use the Data Import tool. Read below for instructions.

Required Data in Import file

To upload tracking numbers, upload a spreadsheet with the following data. We recommend using CSV files:

  • Shipment ID
  • Package Contents
  • Tracking Number
  • Shipping Carrier
  • Shipping Class

Data Formatting

Certain data requires special formatting in the spreadsheet before upload into RO.

Package Contents

For the Package Contents field, you must enter the data in the format below. Note that if there are multiple SKUs in a package, SKUs must be separated by a comma "," character:

SKU1=QTY1,SKU2=QTY2,SKU3=QTY3...

For example:

114402=8,114643=12,114672=4

Multiple Packages For One Shipment

If a shipment has multiple packages with different tracking numbers, the data for each package must be separated by a pipe "|" character for all fields as shown below. Note that for packages with multiple SKUs, SKUs must be separated by a comma "," character.

Multiple Packages For One Shipment

Directions

  1. Create a spreadsheet file with the required data (specified above).
  2. In the RO web app, open the Data Import tool from the nav menu.
  3. Drag-and-drop your spreadsheet file into the designated area.
  4. After the import is complete, click on the file Name.
  5. Either select an existing profile with the Import type of Dropship Tracking or create a new profile with that Import type selected.
  6. For Column match mode, select headers.
  7. Assign each of the columns to their respective fields.
    • For Package Contents, set the Match items on setting to SKU.
  8. If there are any errors, edit data as needed by clicking directly on the desired cell.
  9. When you have resolved all errors (or if there were none to begin with), press the [Apply changes] button.
Directions
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk