"Total number of products" can mean different things depending on what you're counting. Thrive distinguishes between the total number of products and variants, the quantity in stock, the total number of unique products, and the total number of unique variants.
This guide explains the difference between each count and where to find these numbers in Thrive.
Total # of Products (and Variants)
This number contains all of your products, including their variants, and is what most people are looking for.
You can use bulk uploads to calculate this number, but there are some limitations.
To calculate this number:
Generate an Edit Variants Bulk Upload for a single location.
Scroll to the bottom of the spreadsheet and make note of which row of the last product/variant.
Take that row number and subtract the number of rows that are in the header (top of the spreadsheet) as highlighted here:
Some things to note the spreadsheet will not include Bundles (but their components will show on the spreadsheet.
Another option is to pull an Inventory Report and export it as a CSV. Then calculate the number of rows. This report does not include 1) Bundles 2) products/variants with a null (empty, no value) quantity, or 3) products/variants with inventory tracking disabled.
Total quantity in stock
This number takes into account all your products, variants, and all of their corresponding quantities.
To find this number, run an Inventory Report and the total will be in a Summary Box, as shown here:
To filter by location, use the Filters button.
The Inventory Report Quantity in Stock summary box will show the total number of individual units you have across your entire inventory, regardless of how many different products or variants they represent.
Total # of Products Only
This is the sum of all your simple products plus your products with variants and excludes individual variants.
Regardless of your number of locations, this number will only count the unique products (excluding individual variants).
To see your total number of products:
Use the Consolidated Inventory view.
The total number of products is displayed at the bottom-right corner of the page.
NOTE: The Consolidated Inventory view is typically used for larger accounts to decrease load time. If you prefer the Consolidated view and want it as your new default, just let our Customer Care Team know and we can assist further.
If you use the Filter button or filter using a keyword, the number of products will adjust based on the parameters set.
Remember this is only a total of your products. Variants are not included in this count.
Another option is to follow the steps here, but instead, use the Edit Products Bulk Upload.
Example
Let's say I have a Logo T-Shirt (product) in my catalog, and it comes in different sizes/colors (variants) as shown here:
In addition, we have 10 units in each size/color, for a grand total of 60 units that would fall under the Logo T-Shirt product.
This breaks down to:
# of products and variants: 6
Quantity in Stock: 60
# of products: 1




