The Ship Order tool is an automation tool designed to support fulfilling orders by uploading order tracking information from an Excel spreadsheet. It eliminates the need to click through multiple OMS screens. By design, this tool will ship all pending items on the orders included and charge the shopper’s credit card for the shipped items. This tool should only be used to process orders where all pending line items are being shipped.
To use the Ship Order tool, an active subscription to Net32’s API.
Log in to OMS with your vendor credentials.
https://www.net32.com/oms/login
From the Tools menu, select Ship Order File Upload.
Preparing the file:
Before you start, you will need your shipsfromaddrid.
To retrieve your shipsfromaddrid, follow the link embedded in the text on the top of the Ship Orders File Upload page
Prepare an Excel file (or csv file) with the pending order numbers and shipping information in the required format. The Excel file must contain the following column headings in the first row of the file and in lowercase:
- Cell A1: orderid
- Cell B1: shipsfromaddrid
- Cell C1: shipdate
- Cell D1: carrier
- Cell E1: tracking
Here is an example of the required column headings. For your convenience, a template is attached at the end of this article.
Each pending order being shipped should be entered on a separate row without any blank rows.
Here is an explanation of each column.
orderid: This is the Net32 order number. The tool will reject files that contain duplicate orderids.
shipsfromaddrid: This is a Net32 id that uniquely identifies your “Ships From” addresses in OMS. Net32 can help you identify your “Ships From” address ids.
shipdate: This is the date the package will be picked up by the shipping carrier. Example: 5/14/2021
The shipping date must be greater than the order date and should not be more than 7 days in the future.
carrier: This is the carrier name should be enter in all capital letters as: FEDEX, UPS, USPS, or LOCAL_DELIVERY
tracking: This is the tracking number for the package. The tool will reject files that contain duplicate tracking numbers.
Once you have entered all required information, save the file as an excel or csv file.
Uploading the file:
The next step is to select the Excel or csv file with the pending order numbers and shipping information:
In the Ship Order tool, click Choose file, browse to find and select your file, and click Import.
The system will read the contents of the selected file and display the details on the screen.
The system will also perform basic validation on the contents of the selected file, checking first for the required column headings, then checking the proper data types and duplicate values. If the file fails any of the basic validation steps, the system will list an error message. If there is an error in the file, make the required corrections and Import again.
When the selected file loads successfully, click Submit.
Please be patient while the system processes each shipment. Do not leave the screen while the system is processing.
Once complete, scroll through the list to identify each successful and unsuccessful shipment.
If successful, the customer’s credit card will be charged for the pending amount, the line items will be marked as shipped, and the order will now be marked as complete.
If unsuccessful, the system will provide a message with the status. If the credit card declined, the order is typically cancelled so you should NOT release the shipment.
Important Tips
1) Net32 API Subscription required
The Ship Order tool requires an active subscription to Net32’s API. If you do not have an active API subscription, you will see a message to contact Net32 to set up your subscription.
You can follow the step outlined here to set up your Net32 API subscription.
2) Error: Order shipment not accepted
If your file uploads correctly but the API does not process successfully, you will see a message similar to this one:
In order to prevent multiple users from trying to update the same order, the Ship Order API will not process the order if there are items in the order's shipment list that were previously added manually. If that is the case, remove all items form the orders shipment list.
Comments
Article is closed for comments.