Magento Products Ordered Report

Magento Products Ordered Report

September 12, 2026 · Illustrated author avatarBy Stefan Bogdanescu
Magento Products Ordered Report

Understanding Magento’s Products Ordered Report

As a senior PHP developer who has worked extensively with e-commerce platforms like Magento, I often encounter questions about its reporting features. One of the most common concerns is understanding how the “Products Ordered” report works and why some products might show as having 0 ordered quantities.

The Date Filter and Ordered Quantity

Let’s break down how this report functions:

The Ordered Quantity column in the Products Ordered report reflects the total number of times a specific product has been purchased. However, it is important to understand that this count is not affected by the date filter you apply on the report page.

For example, if you set the start and end dates for your report to be from January 1st to February 28th, Magento will not exclude any orders placed before or after this period when calculating the ordered quantities. It simply provides a snapshot of all orders that meet the product criteria within that date range.

Why Some Products Show as 0

You mentioned that some products show as having 0 ordered quantities. There are several reasons why this might happen:

  1. The product has never been ordered: If no customer has purchased this particular product, it will naturally display a count of 0.

  2. The product was deleted or its status changed: If the product was deleted from your catalog or if its status was changed to “Disabled” or “Not Visible Individually,” any past orders associated with that SKU would not be reflected in this report.

  3. There’s a mistake in the order data: Sometimes, there might be errors in the order management process that result in the ordered quantities being misrecorded or deleted from the database tables.

  4. You’re looking at the wrong store view: If you have multiple store views and the products were ordered only through one of them, switching to a different store view would show 0 for those products.

Where Magento Keeps the Ordered Quantity Data

Magento tracks all order-related data in its database. The core tables involved are:

  • sales_flat_order: This table stores general information about each order.
  • sales_flat_order_item: This is where individual items or products associated with an order are recorded.
  • catalog_product_entity_int: This table contains various attributes for your products, including the ordered quantity.

The ordered quantity data is updated whenever a new order is placed. The ordered_qty field in sales_flat_order_item represents the number of units of each product item ordered within that specific order.

Best Practices and Troubleshooting

If some products are consistently showing as 0, I would recommend checking for any discrepancies in your order data:

  1. Use the Magento Admin panel to review all past orders for these products.
  2. Check if there are any errors in the order items table (sales_flat_order_item) for these SKUs.
  3. Ensure that the product status and visibility settings are correctly configured.

Remember, Magento’s reporting is robust but it relies on accurate data management. If you notice discrepancies, it might be a good idea to consult with a certified Magento developer or contact our team at Laravel Company for a thorough audit of your system.

Conclusion

Understanding the Products Ordered report requires a clear grasp of how Magento manages its order data. The Ordered Quantity is a static count that isn’t influenced by date filters, and it’s important to verify the integrity of your order data if you notice any discrepancies in the reported quantities.

As always, regular maintenance and professional support can help prevent these issues from occurring in the first place. If you ever need assistance optimizing your Magento store or troubleshooting complex reporting problems, don’t hesitate to reach out to the experts at Laravel Company.

Catalog Orders Customers Import/Export

Our network