What data is available within Reports?

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.

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 a 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

Zipcode 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.

✔

✔

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.

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.

✔

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.

✔

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 the sales channels.

✔

✔

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.

Shipping: evaluate shipping services; plan strategic addition of warehouses.

Marketing: generate regional campaigns.

✔

✔

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.

✔

✔

✔

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.

✔

✔

Order Count

Total number of orders (Domestic plus International) on the date specified

✔

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.

✔

✔

✔

Category

✔

✔

✔

Item Name

Name assigned to your products.

✔

✔

✔

Order Count

Amount of orders shipped containing the specific SKU

✔

✔

✔

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)

✔

✔

✔

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

✔

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

✔

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

✔

✔

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)

✔

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

✔

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 preorder 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

✔

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

✔

Units Sold (7-Day)

✔

Units Sold (14-Day)

✔

Units Sold (30-Day)

✔

Units Sold (60-Day)

✔

Units Sold (90-Day)

✔