The total number of products in your OpenCart catalogue, counted at product level across every status, the simplest read on catalogue size.
At a glance
Total Products is the raw count of product rows in your OpenCart catalogue, regardless of whether each one is enabled, disabled, in stock, or out of stock. OpenCart counts at the product level, not the variant level: options and variant combinations (size, colour) live on a single product and do not each count as a separate product. This is a catalogue-size baseline, not a “live and sellable” figure. To understand how many of these are actually available to shoppers, read it against the disabled, out-of-stock, and missing-data cards.
| What it counts | COUNT(products) across the whole catalogue, every status. Read from oc_product. |
| Product vs variant | OpenCart counts at product level. Options and variant combinations are attached to a single oc_product row and do not count separately, so a product with 12 size/colour combinations is one product here. |
| Enabled vs disabled | Both included. A disabled product still exists in oc_product with status = 0. To see only the live subset, subtract Disabled Products. |
| Out of stock | Included. An out-of-stock product is still a catalogue row. See Out of Stock Products for the sellable view. |
| Multi-store | A product can be assigned to one or more stores via store_id links. The headline counts distinct products across the whole catalogue; the detail view can split by store. |
| Currency / tax | n/a, this is a count. |
| Time window | RT (real-time, reflects the catalogue at last sync) |
| Alert trigger | None |
| Roles | owner, operations |
Calculation
Worked example
A German lighting retailer on OpenCart 4.x. Snapshot taken 12 Apr 26. The catalogue has grown through a recent supplier onboarding, but a chunk of the new range is not yet live.| Segment | Products | Note |
|---|---|---|
| Enabled and in stock | 1,840 | Live and sellable |
| Enabled but out of stock | 210 | Visible, cannot convert |
Disabled (status = 0) | 360 | Hidden from storefront |
| Missing SKU / model | 95 | Live but hard to manage |
| Total Products (this card) | 2,410 | All statuses |
- The headline overstates what shoppers can actually buy. Of 2,410 products, only 1,840 are both enabled and in stock. The 360 disabled and 210 out-of-stock products inflate the catalogue-size number well above the live, sellable count. Read this card next to Disabled Products and Out of Stock Products to get the real availability picture.
- A jump in this number is usually an import. Catalogue size moves in steps, not smoothly. A 400-product jump overnight almost always means a supplier feed or CSV import ran. If the live count did not move with it, the new products were imported disabled, worth confirming that was intentional.
- Variant-heavy catalogues look smaller here than merchants expect. Because OpenCart counts at product level, a store with 500 products each carrying 10 size/colour options still shows 500 here, not 5,000. If you are comparing against a marketplace that counts listings at the variant level, expect the marketplace number to be far higher.
- The 95 products missing a SKU or model are a management risk hiding in the total. They count toward catalogue size but are hard to reconcile against suppliers and marketplaces. Products Missing SKU / Model isolates them.
Sibling cards merchants should reference together
| Card | Why pair it with Total Products |
|---|---|
| Disabled Products | Subtract from Total Products to get the live, visible catalogue size. |
| Out of Stock Products | The portion of the catalogue that is visible but cannot convert. |
| Low Stock SKUs | Products about to drop out of the sellable set. |
| Products Missing SKU / Model | The hard-to-manage slice of the total. |
| Empty Categories (0 Products) | Catalogue size means little if products are not reachable through categories. |
| OpenCart Inventory vs Marketplace Listings | Compares this catalogue against what is live on a connected marketplace. |
Reconciling against OpenCart
Where to look in OpenCart admin: Catalog → Products shows the full product list with a total count at the bottom of the table. That count is at product level and includes every status, which is the same basis as this card. The underlying data is theproduct_id and status columns on oc_product, with store assignment via the product-to-store links.
Other OpenCart views that look like the same number but are not:
- The storefront category counts: count only enabled products that are assigned to a category, so they are always lower than the catalogue total.
- Reports → Products Viewed / Purchased: count products with activity, not the whole catalogue.
- An export or feed file: may expand to variant level depending on the extension, producing a much larger row count than this product-level figure.
| Reason | Direction of divergence |
|---|---|
| Product vs variant counting. This card counts at product level; a variant-expanding export or a marketplace feed counts each option combination. | Vortex IQ lower than variant-level exports |
| Multi-store. The admin product list can be filtered by store; this card counts distinct products across all stores by default. | Either direction |
| Status inclusion. Some admin filters hide disabled products; this card includes them. | Vortex IQ higher than a status-filtered list |
| Sync lag. Products added or deleted in the last few minutes appear on the next sync. | Self-resolves at next sync |
Known limitations / merchant FAQs
Does this count variants or just products? Just products. OpenCart counts at the product level, so a product with many size or colour options is one product here. If you need a variant-level count, an export at the option-combination level will be larger. Are disabled products included? Yes. A disabled product still exists in the catalogue withstatus = 0. To see only the live, visible catalogue, subtract Disabled Products from this figure.
Why did this number jump overnight?
Almost always an import. Supplier feeds and CSV imports add products in bulk. Check whether the live, in-stock count moved with the total; if it did not, the new products came in disabled.
My marketplace shows far more listings than this, why?
Marketplaces typically count at the listing or variant level and may carry listings created outside OpenCart. Use OpenCart Inventory vs Marketplace Listings to see the relationship rather than comparing raw totals.
Does multi-store change the number?
The headline counts distinct products across all stores. If you filter the admin product list to a single store, you will see fewer products. The detail view can split by store_id.
Is there an alert on this card?
No. Catalogue size is a baseline that moves with merchandising decisions, not a health signal that benefits from a fixed threshold. The cards that pair with it (disabled, out of stock, missing data) carry the actionable alerts.
How does this relate to the live, sellable catalogue?
Total Products is the ceiling. Subtract disabled and out-of-stock products, and set aside those missing critical data, to arrive at the genuinely sellable subset. The companion availability cards do that subtraction for you.