Follow

What data is available within Reports?

Created:   |   Updated:

ShippingEasy's REPORTS page features a set of preconfigured reports with the added option to create custom reports.

TIP: if you're new to ShippingEasy REPORTS, take a look at our overview guide.

Data sets accessible via preconfigured reports:

Each of these preconfigured reports includes a unique set of metrics, most of which can be found among the data metrics available in custom reports. Learn more about creating a custom report.

Data metrics available within ShippingEasy's REPORTS page:

 

Shipping Reports

  Report Type
Complete Shipping Shipping Destinations Shipping Services
Metric Description Suggested Use      
Carrier Date displayed on the shipping label. Shipping: tracking status of orders.  
Confirmation Option Specific carrier confirmation option added to service. Shipping: evaluate shipping services.    
Creation Date Date the shipment was created. Productivity: compare with Order Date to find throughput rate; combine with User, Store, or Ship From data to find productivity of an individual or location.      
Creation Time Time the shipment was created. Productivity: compare with Order Date to find throughput rate; combine with User, Store, or Ship From data to find productivity of an individual or location.      

 

  Report Type
Complete Shipping Shipping Destinations Shipping Services
Metric Description Suggested Use      
Destination Address Line 1 Address to which the shipment was sent. Shipping: tracking orders.    
Destination Address Line 2 Secondary address line, to which the shipment was sent. Shipping: tracking orders.    
Destination City City to which the shipment was sent. Marketing: generate regional campaigns.  
Destination Company Company to which the shipment was sent. Marketing: generate contact list.    
Destination Country Country to which the shipment was sent. Traffic: track growth of international sales channels.  
Destination Phone Phone number of the package recipient. Shipping: tracking orders.    
Destination Postal Code Zip code to which the shipment was sent. Shipping: tracking orders.
Marketing: generate regional campaigns.
   
Destination State/Province State (if domestic) or province (if international) to which the shipment was sent. Shipping: plan strategic addition of warehouses.
Marketing: generate regional campaigns.
 

 

  Report Type
Complete Shipping Shipping Destinations Shipping Services
Metric Description Suggested Use      
Discount Amount Any discounts applied to the order total; available for select platforms (Amazon, Bigcommerce, Shopify, Magento, Volusion, WooCommerce). Business: evaluate effectiveness of discounts.
Marketing: generate contact lists (customers who got a discount once will likely jump at another).
   
Email Address Email address used to receive the shipment confirmation email or alias provided by platform (ie: Amazon, eBay). Marketing: generate contact list.    
Height (inches) Measure of package height in inches. Shipping: evaluate shipping services and packing methods.      
Insurance Cost If you added insurance, amount your business paid for shipment insurance; relates to the declared value for coverage. Business: shipping cost analysis.  
Length (inches) Measure of package length in inches. Shipping: evaluate shipping services and packing methods.      

 

  Report Type
Complete Shipping Shipping Destinations Shipping Services
Metric Description Suggested Use      
Order Date Date the customer placed the order on your website. Store: sales activity over a time frame.
Marketing: generate contact lists based on purchase dates.
 
Order Number Reference number assigned to your order. Store: reconcile shipments.  
Order Total Total amount your customer paid to you including item cost, shipping charge and taxes. Business: gross profit analysis.
Marketing: generate contact lists based on purchase amount.
 
Package Type Specific carrier package option selected to ship order. Note: currently, this does not include custom packages. Shipping: evaluate packing supply needs.    
Postage Cost Amount your business paid for the shipping label. Business: shipping cost analysis.
Quantity Number of items included in shipment. Inventory: compare with SKU and/or Item Description to track inventory turnover.    

 

  Report Type
Complete Shipping Shipping Destinations Shipping Services
Metric Description Suggested Use      
Rate Provider Carrier account used to purchase postage. Business: tax preparations.    
Recipient Customer name. Marketing: generate contact list.  
Recipient Billing Address Address of the individual that purchased the order. Marketing: generate regional campaigns.    
Recipient Shipping Address Address of the individual receiving the order. Marketing: generate regional campaigns.    
Sales Tax Amount your customer paid in Sales Tax. Business: tax preparations.    
Service Type Specific carrier service selected to ship the order. Shipping: evaluate shipping services; estimate speed of delivery.    

 

  Report Type

Complete Shipping

Shipping Destinations

Shipping Services
Metric Description Suggested Use
Ship Date Date displayed on the shipping label. Shipping: tracking status of orders.
Ship From Name of the location from which the shipment was sent. Productivity: track throughput of warehouse.    
Ship From Address Address of processing warehouse and/or return address displayed on the shipping label. Productivity: track throughput of warehouse.    
Shipping Margin Difference between how much your customer paid you for shipping and the amount you paid for the shipping label. Business: shipping cost analysis.    
Shipping Paid (by customer) Amount your customer paid to you for shipping. Business: shipping cost analysis.    
Store Website at which the order was placed. Traffic: sales activity by channel.
Marketing: generate contact lists based on sales channel.
 

 

  Report Type
Complete Shipping Shipping Destinations Shipping Services
Metric Description Suggested Use      
Total Shipping Cost Cost of the shipping label plus any insurance and additional confirmation options. Business: shipping cost analysis.  
Total Wholesale Price Total cost you paid for the products which could include manufacturing costs, supplier costs, etc. Business: evaluate gross profit    
Tracking Number Unique shipment number assigned by the carrier. Shipping: track orders' delivery statuses.
Store: reconcile shipments.
   
User For accounts with multiple user logins: user login which processed the shipment. Productivity: track throughput of staff.    
Weight (oz) Package weight. Shipping: evaluate shipping services.  
Width (inches) Measure of package width in inches. Shipping: evaluate shipping services and packing methods.      
Zone USPS designation which indicates the distance the shipment traveled. Learn more. Shipping: evaluate shipping services (ie: use Regional Rate for lower Zones, learn more); plan strategic addition of warehouses.
Marketing: generate regional campaigns.
 

Order Reports

  Report Type
First 500 Orders Older than 7 Days All Orders
Metric Description Suggested Use      
Alt. Order Number Displays the alternate order number for the shipment    
Domestic Order Count Number of Domestic Orders on the date specified      
International Order Count Number of International orders on the date specified       
Order Count Total number of orders (Domestic plus International) on the date specified      
Order Date Date the customer placed the order on your website. Store: sales activity over a time frame.
Marketing: generate contact lists based on purchase dates.

 

  Report Type
First 500 Orders Older than 7 Days All Orders
Metric Description Suggested Use      
Order Number Reference number assigned to your order. Store: reconcile shipments.  
Order Total Total amount your customer paid to you including item cost, shipping charge and taxes. Business: gross profit analysis.
Marketing: generate contact lists based on purchase amount.
Quantity Number of items included in shipment. Inventory: compare with SKU and/or Item Description to track inventory turnover.  
SKU        
Ship Date Date displayed on the shipping label. Shipping: tracking status of orders.    
Store Website at which the order was placed. Traffic: sales activity by channel.
Marketing: generate contact lists based on sales channel.

Products Reports

  Report Type
Shipped Unshipped All
Metric Description      
Batch Name Name assigned to the batch, if shipments were batched.      
Category  
Custom Field 1 Custom field added to orders from within ShippingEasy. Learn more about custom fields.        
Custom Field 2      
Custom Field 3      

 

  Report Type
Shipped Unshipped All
Metric Description      
Item Name Name assigned to your products.
Last Store Update Column will display "Success" if the Last Store Update was successful, "Failure" if the Last Store Update was unsuccessful, or "Inactive" if we are unable to find the SKU in the current product catalog on your store.      
Master SKU Column will have a value when the SKU is an alias, otherwise the cell will be blank      
Order Count Amount of orders shipped containing the specific SKU
Return Indicates if a shipment was a return shipment.      

 

  Report Type
Shipped Unshipped All
Metric Description      
SKU Unique identifier assigned to your products; most helpful when Product Catalog is used. Learn more.
Total Revenue total amount of revenue of SKU, not including shipping on order
Total Wholesale Price Total cost you paid for the products which could include manufacturing costs, supplier costs, etc.
Total Quantity Total amount of specific SKU shipped across all orders
UPC The Universal Product Code of the product (user-defined) 
Unit Wholesale Price
The Wholesale Price of a single unit of the product (user-defined)

Inventory Reports

  Report Type
Inventory Status Inventory Low Stock Report Linked Stores by Product Products Committed by Date
Metric Description        
Available The Stock minus the Committed    
Available by Date The Current Stock minus the Committed by Date      
Awaiting The total amount of stock you have ordered, but not yet received from your supplier(s).        
Category      
Committed The total amount of stock you have committed to orders that have not yet been shipped    
Committed By Date The Committed amount based on the specified date range      

 

  Report Type
Inventory Status Inventory Low Stock Report Linked Stores by Product Products Committed by Date
Metric Description        
Current Low Stock Threshold The Low Stock Threshold of the product at the time the report is generated      
Current Stock The total Stock (Available plus Committed) of the product at the time the report is generated      
FBA Stock If the product is stored at FBA, this is the total Stock (Available plus Committed) at the FBA warehouse      
FBA Available If the product is stored at FBA, this is the stock Available for sale (Stock minus Committed) at the FBA warehouse      
FBA Inventory Value The value of the inventory at FBA (Unit Wholesale Price times FBA Stock)      
Item Name The Name of the product      

 

  Report Type
Inventory Status Inventory Low Stock Report Linked Stores by Product Products Committed by Date
Metric Description        
Link Status This column will display "Active" if the product is linked to the store, "Inactive" if there is an issue with the product link to the store, or "Unlinked" if we are unable to find the SKU in the current product catalog on your store.      
Master SKU This column will have a value when the SKU is an alias, otherwise the cell will be blank      
SKU The SKU of the product    
Shortage For Low Stock Products, this is the amount of stock necessary to meet the Low Stock Threshold (Threshold minus Available)      
Shortage by Date The difference between the Current Low Stock Threshold and the Available by Date      
Stock The total Stock (Available plus Committed) of the product    

 

  Report Type
Inventory Status Inventory Low Stock Report Linked Stores by Product Products Committed by Date
Metric Description        
Store The Store Name of the store that is linked to the product      
Store Type The Store Type (or platform) of the store that is linked to the product      
Threshold The Low Stock Threshold of the product (user-defined)      
Total Inventory Value Based on the SKU's Unit Wholesale Price and Stock quantity      
Total Stock The total Stock (Available plus Committed) of the product       
Unit Wholesale Price The Wholesale Price of a single unit of the product (user-defined)      

Sales, Velocity and Forecasting Reports

  Report Type
Sales Velocity Forecasting & Replenishment
Metric Description    
Alias SKU An additional SKU assigned to a product. 
Available stock Stock you actually have on hand  
Awaiting stock Quantity on outstanding purchase orders for the SKU  
DTR (Days to Reorder) Number of days until a PO must be placed to avoid stockout  
Item Name  
Lead Demand Projected demand during the lead time  

 

  Report Type
Sales Velocity Forecasting & Replenishment
Metric Description    
Lead Time User-defined value that identifies the amount of time between when a PO is placed and the replenishment order is received - set globally from Inventory Settings or on the individual product  
Projected Available Projected remaining Available stock taking into account Awaiting Stock and Projected Sales  
Projected Sales Projected sales during the reorder period (Lead Time + Forecast Period)  
QTB (Quantity to Buy) Recommended quantity to buy in order to have enough inventory to fulfill all orders through the reorder period - takes into account the In-stock Expectation set on Inventory Settings  
SKU The Stock Keeping Unit of the product (user-defined)
Supplier Name Name of the Supplier  

 

  Report Type
Sales Velocity Forecasting & Replenishment
Metric Description    
Stockout Days until Available stock is zero  
Units Sold The number of individual units of the SKU that were sold during the designated timeframe (determined by Order Date)  
Units Sold (7-Day) The number of individual units of the SKU that were sold during the last 7 days  
Units Sold (14-Day) The number of individual units of the SKU that were sold during the last 14 Days  
Units Sold (30-Day) The number of individual units of the SKU that were sold during the last 30 Days  
Units Sold (60-Day) The number of individual units of the SKU that were sold during the last 60 days  
Units Sold (90-Day) The number of individual units of the SKU that were sold during the last 90 days  

 

  Report Type
Sales Velocity Forecasting & Replenishment
Metric Description    
7-Day Velocity    
14-Day Velocity    
30-Day Velocity    
60-Day Velocity    
90-Day Velocity    

 


Related articles:

Overview: REPORTS page
How to: Download order and shipment data
How to: Create a custom Report
How to: Edit a custom report
How to: Schedule a recurring shipment Report


Comments

Please sign in to leave a comment.




Community    browse  

COMMUNITY FORUMS
FEATURE REQUESTS

Questions & Answers

Issues & Bugs

Productivity

Partners

Shipping

Inventory

Marketing