Columns in the Orders report

Columns in the Orders report

Below you'll find definitions for all columns available via the Customise button the on Orders report. Click the Customise button to add and remove data points to answer your questions.

Brand

The Registered Brand column returns the Company name or Sub-Brand assigned to the Product entered into the Product Taxonomy screen or falls back to the Registered Brand name in the e-commerce channel ...continue reading

Buy Box Status

The Buy Box Status shows whether your Amazon Seller Central or Amazon Vendor Central account was winning on the Buy Box on a particular day. The Buy Box Status is time-dependent and always displayed ...continue reading

Channel

The Channel name is Vendor Name, and Country Code combined. This column highlights the e-commerce or Advertising channel's name and country or union.

Colour

It’s possible to report by the manufactured colour entered on the product list.

Flavour

When the product type is Grocery or Pet Food, it’s possible to report the flavour stored on the Product Listing.

Fulfilment Channel

The type of service used to dispatch a package to the customer. For example, fulfilment services would include Fulfilment by Amazon or Fulfilment by Merchant.

Order ID

The unique identifier that as assigned to each Order by the Vendor.

Order Item Status

The Order Item Status column returns the current status of an individual item. This data point allows you to track each stage of the fulfilment process where there are multiple items within an order.

Order Status

The Order Status column returns the current status of an order. This data point allows you to track each stage of the fulfilment process.

Parent Product

When there are several variations for a single product, an e-commerce Manager may create a Parent Product to roll up the data to report sales for an entire range of products. Typically when there are ...continue reading

Partner

The name of the Brand or Merchant configured in Ignite by Acorn-i.

Product

The Product column returns the omnichannel Product name entered into the Product Taxonomy screen or falls back to the Search Engine Optimised name visible to shoppers on the Product Detail Page in ...continue reading

Product Action

The Product Action column returns the omnichannel Product Action entered into the Product Taxonomy screen for grouping several products around a common usage by the customer. It's an optional free ...continue reading

Product ID

The unique ID for your Product, for products listed on Amazon, the Product ID will be the ASIN or ISBN. In other e-commerce channels, the Product ID will be the unique database ID for the Product.

Product Line

The Product Line column returns the omnichannel Product Line name entered into the Product Taxonomy screen for grouping several product varations around a common theme. It's an optional free text ...continue reading

Product Packaging

The Product Packaging column returns the omnichannel Product Action entered into the Product Taxonomy screen for grouping several products around different packaging formats. For example,continue reading

Product Range

The Product Range column returns the omnichannel Product Range name entered into the Product Taxonomy screen for grouping several products around a common theme. It's an optional free text field for ...continue reading

Product Size

The Product Size column returns the omnichannel Product Size entered into the Product Taxonomy screen for grouping several products around different formats. For example, 125ml, 330ml, 500ml or 1l.continue reading

Product Title

The Product Title column returns the Search Engine Optimised name visible to shoppers on the Product Detail Page in the e-commerce channel.

Product Type

The Product Type column returns the omnichannel Product Type entered into the Product Taxonomy screen or falls back to the Product Type in the e-commerce channel when there isn't a preferred Product ...continue reading

Registered Brand

The Registered Brand column returns the Company name or Sub-Brand assigned to the Product in the e-commerce channel. For marketplaces like Amazon, entering the correct Brand name for each Product ...continue reading

SKU

The SKU, or Stock Keeping Unit, is the unique ID assigned to a product by an e-commerce Manager to differentiate stock for internal inventory tracking and reporting.

Subscription

This column returns Yes or No to highlight whether the Order was generated automatically or placed by a person browsing the e-commerce channel.

Date

When included, the Date column shows the date when the Order took place in the e-commerce channel.

Day of Week

The Day of Week column shows the day the Order took place in the e-commerce channel.

Hour of Day

The Hour of the Day column shows the hour the Order took place in the e-commerce channel.

Order Datetime

This column shows the exact date and time when the Order took place in the e-commerce channel.

Area Type

The area type column will highlight the population density of the package's destination, whether it's a rural hamlet or a major urban conurbation, to better understand the awareness and interest for ...continue reading

Country

The Country column returns the country recorded on the shipping address of the Order.

Placename

The placement column will display the name of the Village, Town or Borough depending upon the population density to show the package's destination.

Region

The region column will return the County or State included in the shipping address of the Order.

% of Sales

The percentage of Sales Total for a combination of dimensions, calculated as Sales over Sales Total times by 100 (Sales / Sales Total) * 100.

Buyers

The Number of Buyers calculation will return the unique number of customers who placed orders during the selected date range. A Buyer is a Customer who placed an order during a chosen time frame.continue reading

Gift Wrap

The cost incurred to gift wrap your products before dispatch.

Glance Views

Glance Views show the number of times a Product Detail Page was viewed by shoppers on Amazon.

Net PPM

Net Pure Product Margin or Net PPM is Amazon Vendor Central's product profitability measurement after subtracting the cost of goods, vendor funding, and sales discounts.

Orders

The Orders for the selected date range.

Products

When included, the Product calculation will return the distinct number of purchased products within the selected periods. A product is considered unique based upon its Channel and SKU.

Sales

The retail price paid by shoppers for the selected date range.

Sales Discount

The sales discount value redeemed by the shopper when placing an order.

Sales Tax

To correctly record the sales tax, it's critical to apply the appropriate tax code to each non-zero-rated Product Listing in an integrated e-commerce platform. Unfortunately, Ignite by Acorn-i cannot ...continue reading

Shipped Cogs

The revenue using the wholesale price of the units dispatched to the shopper.