Item Status Report Definitions

Item Status Report Definitions

Info
Module: Reports
Path: Reports > Customer Service Reports > Item Status Report 
Topic: Item Status Report
Version(s):  5.1 and up
Editions: All

What Is Item Status Report

  1. Customer Service Reports                          
    1. Item Status - Lists order items by their processing status.

Making The Connection

Where Will I See This Within OLX?

This report shows all products for all orders in a given date range and their current status.

What Imports/Exports Relate to Item Status Report?

  1. At this time there are no imports/exports related to the report

Setup


Preview




You'll notice control buttons displayed just above the results. Review Report Tools (orderlogix.com) article for more information on how to utilize each control button. :
  1. View Report  - Displays results
    1. Displays the toolbar 
  2. Hide Controls - Hides report filters
    1. Show Controls - Displays report filters
  3. Show Schedules  - Displays schedule editor
    1. Format filter will display at top of screen
    2. Delivery and Encryption tabs will display on bottom left of screen
  4. Show Instances - Displays list of previously ran and pending reports. Click on the status to review the job log.
  5. Close  - Close out of the report popup.

Report Definitions

Using Calendar Icon to Set Date(s) is a good article to review when running reports manually or scheduling for automation.

Filters

Filter
Definition
Date Type
  1. User Selected
    1. Allows the user to select any calendar day for start and end range.
  2. Last Week (S)
    1. The previous week starting with Sunday will automatically be set in the Date Range
  3. Last Week (M) 
    1. The previous week starting with Monday will automatically be set in the Date Range
  4. This Quarter
    1. Date Range will set to the current quarter based off the current date and which quarter it falls in:
      1. First quarter, Q1: 1 January – 31 March (90 days or 91 days in leap years)
      2. Second quarter, Q2: 1 April – 30 June (91 days)
      3. Third quarter, Q3: 1 July – 30 September (92 days)
      4. Fourth quarter, Q4: 1 October – 31 December (92 days)
  5. Last Year
    1. Jan 01 of previous year to Dec 31 of previous year
  6. Last Month
    1. Day one of previous month to the last day of the previous month
  7. This Week (S) - Sunday
    1. Current week from Sunday to the following Saturday
  8. This Week (M) - Monday
    1. Current week from Monday to the following Sunday
  9. This Month
    1. First day of current month to last day of current month
  10. This Week to Date (S) - Sunday
    1. Sunday of current week to current date
  11. This Week to Date (M) - Monday
    1. Monday of current week to current date
  12. This Month to Date
    1. First day of current month to current day
  13. Tomorrow
    1. Current day plus one
  14. Now to End of Week (S) - Sunday
    1. Current day the next Sunday
  15. Now to End of Week (M) - Monday
    1. Current day to the next Monday
  16. Now to End of Month
    1. Current date to last day of the current month
  17. Now to End of Year
    1. Current date to Dec 31 (current year)
  18. Last Quarter
    1. Date Range will set to the previous quarter based off the current date and which quarter it falls in:
      1. First quarter, Q1: 1 January – 31 March (90 days or 91 days in leap years)
      2. Second quarter, Q2: 1 April – 30 June (91 days)
      3. Third quarter, Q3: 1 July – 30 September (92 days)
      4. Fourth quarter, Q4: 1 October – 31 December (92 days)
  19. This Quarter To Date
    1. Date Range will set to the current quarter based off the current date up to the current dates data:
      1. First quarter, Q1: 1 January – 31 March (90 days or 91 days in leap years)
      2. Second quarter, Q2: 1 April – 30 June (91 days)
      3. Third quarter, Q3: 1 July – 30 September (92 days)
      4. Fourth quarter, Q4: 1 October – 31 December (92 days)
  20. Year to Date
    1. Jan 01 (current year) to current date
Fiscal Week
(only shows during manual run when utilizing User Selected Date Type above)
This will set the below Date Range to the Monday - Sunday date range selected from this drop down.
Date Range
Order date of the order the item is on
Report Layout
3-layer filter to display report data (see Grouping below)

example if set to Order Date/Item Status/Order ID:

Expand
  1. None
    1. will not expand any of the selected groupings and only show the first layer of the Groupings set in Report Layout
  2. One
    1. will expand only the first Grouping to display the first and second layer of the Groupings set in Report Layout
  3. Two
    1. will expand all Groupings to display all layers of the Groupings set in Report Layout
Order Type
Whether the item is on a regular order or an autoship generated order
Format
(only shows when setting up a schedule)
This is the format that the report will export in:
  1. PDF
  2. Excel
  3. CSV
Client
The client of the source of the order the item is on
Show Inactive (Client)
Show in the report:
  1. Checked - show active and inactive Clients
  2. Unchecked - only show active Clients
Script
The script of the order the item is on
Show Inactive (Script)
Show in the report:
  1. Checked - show active and inactive Script
  2. Unchecked - only show active Script
Campaign
The campaign of the source of the order the item is on
Show Inactive (Campaign)
Show in the report:
  1. Checked - show active and inactive Campaigns
  2. Unchecked - only show active Campaigns
Product Group
The product group of the item
Item Status
The status of the item
Item Type
Whether the item is a debit item or credit item




Grouping/Report Layout

Layout
Definition
Campaign
The campaign of the source of the order the item is on
Customer Name
The name of the customer the order the item is on belongs to
Fiscal Week
The fiscal week of the order date
Item Status
The status of the item
Order Date
Order date of the order the item is on
Order ID
The order ID of the order the item is on
Payment Method
The payment method of the order the item is on
Product Group
The product group of the item
Product Name
The product name of the item
Script
The script of the order the item is on




 Column Definitions

Column
Definition
Product Name
Name of the product
Description
Description of the product
Customer Name
Customer Name for the order the product is on
Order ID
Order ID for the order the product is on
Item Status
Status of the item
# Items
Number of items for that grouping level
Grand Totals
Sum of column(s)



Copyright 2019
Revised 1.07.2026

    • Related Articles

    • Continuity Status Report Definitions

      Module: Reports Path: Reports > Continuity/Installment Reports > Continuity Status Report Topic: Continuity Status Report Version(s): 5.1 and up Editions: All What Is Continuity Status Report Continuity/Installment Reports Continuity Status Report - ...

    • Item List Report Definitions

      You can use the (product) Item list report to view product items by Client, Product Group, or Active status.   The report shows the (product) Item Name, Description, Product Group, External SKU, Client, Active Status, and number of product offers for ...

    • Inventory Item List Report Definitions

      Module: Reports Path: Reports > Inventory Reports > Inventory Item Report Topic: Inventory Item Report Version(s): 5.1 and up Editions: All What Is Reports > Inventory Item Report - View inventory item data. This report shows inventory item ...

    • Order Submission Status Report

      Module: Reports Path: Reports > Processing Reports > Order Submission Status Report Topic: Order Submission Status Version(s): 5.1 & up Editions: All What Is Order Submission Status Report This report is used to track API exceptions which are still ...

    • Inventory Item Association Report

      Module: Reports Path: Reports > Inventory Reports > Inventory Item Association Report Topic: Inventory Item Association Report Version(s): Editions: What Is Inventory Item Association Report See all base item products and the inventory items ...