How to Generate a TNT Rate Shop Comparison Table Report [Step-by-Step Guide]

Modified on Wed, 22 Oct at 2:08 PM

The TNT Rate Shop Comparison Table report shows how techOMS selected shipping options based on Time and Transit (TNT) rate shopping for successfully allocated sales orders. This report allows you to analyze both the cost savings and the profitability of the selected shipping options.

WARNING: These decisions rely on transit time data provided by techSHIP. A sales order rule with the Calculate Time & Transit Action must be enabled; otherwise, the report will be empty.

NOTE: For more details on the Calculate Time & Transit Action, refer to Rules Conditions and Actions Guide [Information]. For guidance on creating a sales order rule, see How to Create Sales/Purchase Order Rules [Step-by-step guide].

This report includes data only for orders that successfully ran through the TNT process and resulted in a shipment creation.

This article is divided into the following sections:

Report Structure
How to Generate the Report

I. REPORT STRUCTURE

The exported report is a comma-separated value (CSV) file that you can use for business analysis. It serves two main purposes:

It allows you to analyze the shipping options considered for each order to quantify cost savings achieved by comparing the selected option against alternatives.
It provides data to analyze the profitability of the selected rate, helping you understand how much revenue is generated from your shipping markups.

Its schema is:

Order #: Sales order number.
Reference #: Shipment reference number.
Client Id: Customer ID as configured in the Extensiv Stable Fulfillment Channel settings. Blank otherwise.
Warehouse Id: Identifier of the warehouse considered.
Date And Time: Timestamp when the TNT options were evaluated for the order (this value is in UTC).
Selected: Indicates whether this specific shipping option (row) was the one selected by the TNT logic.
Enough Stock: Indicates whether the considered warehouse had enough stock to fulfill the entire order at the time of evaluation.
Carrier: Carrier code provided by techSHIP.
Service: Service code provided by techSHIP.
Rate: Shipping rate provided by techSHIP.
Estimated Delivery Days: Estimated delivery days, as provided by techSHIP.
Minimum Saving: The difference between the selected rate and the next cheapest rate.
Maximum Saving: The difference between the selected rate and the most expensive rate.
Amount: The total charge excluding taxes.
Fee Markup: The monetary value of the markup applied.
Zone Skipping: Zone skipping costs.

NOTE: For Minimum and Maximum savings, only warehouses with enough stock are considered. This information appears only on the row where Selected is Yes.

II. HOW TO GENERATE THE REPORT

To generate a TNT Rate Shop Comparison Table report:

1. Select the desired account from the header switcher.

2. Click Sales Orders from the left menu under the Sales section.

3. Press Reports.

4. Click TNT Rate Shop Comparison Table.

5. Set Date Start and Date End to define the period to be covered by the report.

6. Press Export and save the report file in the desired location.

NOTE: The report will include data:

Based on the account's timezone.
Between the specified Date Start and Date End (inclusive).
Regardless of any filters applied to the Sales Orders.

All timestamps in the resulting CSV file will be in UTC.