How can I track active product count in my store?

Shopify Discussion
1

Hey,
How can i get product count of my store based on various parameters like whose status is active, inventory is 0 or 1 1, etc.

1 Like
2

Hi @prathamwadhwa ,
First of all products and inventory are 2 separate entities so getting count of items using all the criterias may be impossible (depends on criterias you want to filter by).

Fow example products status is parameter of products, while quantity is something related to inventory.
You can get count of active products by adding /count.json on your url, like this:
https://{{yourShop}}.myshopify.com/admin/products/count.json?selectedView=all&status=ACTIVE

But inventory doesn’t have such ability, the only option is to set filters on Products >

Inventory and export results into csv file and you will see which items meets your criterias and what’s the count of SKUS.

1 Like
3

You can do all of this using our Report Toaster app. Feel free to take a look and let us know if you have any questions.

4

Actually, you need a reporting app or synchronize data to your database via API.

For reporting, you can use Advanced Reports

Example of the report with filters: https://prnt.sc/yxOCSzJDyK5S

5

Hi there!

To get the product count in your Shopify store based on specific parameters, you can follow these steps:

  1. Log in to your Shopify admin.
  2. Go to the Products section.
  3. Use the available filters to narrow down your products based on parameters like status and inventory.
  4. Shopify will display the products that meet your specified criteria, and at the top, you’ll see the total count.

For a more dynamic or automated approach, especially if you’re comfortable with coding, you might consider using Shopify’s API. With the API, you can fetch product information based on various parameters programmatically.

6

I track active product counts similarly for my boys’ sleeves collection by using Shopify’s admin API to filter products based on status and inventory. You can use a simple API call or a Shopify app to filter products with status: active and inventory levels of 0 or 1. This helps me stay on top of restocking and managing what’s visible on the storefront.