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 RetailOps.
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=4Multiple 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.
Directions
- Create a spreadsheet file with the required data (specified above).
- In RetailOps, open the Data Import tool from the left navigation menu.
- Drag-and-drop your spreadsheet file into the designated area.
- After the import is complete, click on the file Name.
- Either select an existing profile with the Import type of Dropship Tracking or create a new profile with that Import type selected.
- For Column match mode, select headers.
- Assign each of the columns to their respective fields.
- For Package Contents, set the Match items on setting to SKU.
- If there are any errors, edit data as needed by clicking directly on the desired cell.
- When you have resolved all errors (or if there were none to begin with), press the [Apply changes] button.
Comments
0 comments
Please sign in to leave a comment.