SLASHCART Shopify Expert- How to Quickly Get a Count of Records in the Shopify Admin

I wanted to share a quick tip to help you manage your store more efficiently. Many people have asked me how to quickly find the total number of records in the Shopify admin, so I thought I should post this tip to benefit everyone.

When viewing records in the Shopify admin, you might notice that most of the pages don’t show the total number of records. While exporting a CSV is an option, it can be quite time-consuming. Thankfully, there’s a much quicker way to get the total count of records by simply adding /count.json to the URL of the listing pages.

Here’s how you can do it:

  1. Customers:
    Go to Shopify Admin → Customers and append /count.json to the URL:
    https://mystore.myshopify.com/admin/customers/count.json

  2. Orders:
    https://mystore.myshopify.com/admin/orders/count.json

  3. Draft Orders:
    https://mystore.myshopify.com/admin/draft_orders/count.json

  4. Products:
    https://mystore.myshopify.com/admin/products/count.json

  5. Variants:
    https://mystore.myshopify.com/admin/variants/count.json

  6. Collections:
    https://mystore.myshopify.com/admin/collections/count.json

  7. Gift Cards:
    https://mystore.myshopify.com/admin/gift_cards/count.json

Just replace mystore with your store’s actual myshopify.com subdomain, and you’ll get the counts instantly. This can save you a lot of time and effort!

I hope you find this tip helpful.

2 Likes

Hi SLASHCART, do you know how to calculate the total number of archived orders in Shopify? What is formula for that?

Hello Lena,
To calculate the total number of archived orders in Shopify, you can use the Shopify Admin API. Unfortunately, there isn’t a direct endpoint for archived orders, but you can filter orders by their status using the Orders API.
You can set the status parameter to ‘any’ and then filter out archived orders in your application based on their processed_at date or similar criteria.

Alternatively, if you’re comfortable with Liquid or Shopify’s GraphQL API, you might be able to create a custom query to get this information.
Let me know if you need more details

1 Like

Hi SLASHCART, I’m not very technical, so I found the explanation a bit complex. Thanks for the help anyway! Lena

Hi Lena,

I understand, no worries! If you’re looking for a simpler way, you might want to try using an app from the Shopify App Store that provides detailed order reporting, including archived orders. These apps often have user-friendly interfaces and can give you the information you need without any coding.

If you need a recommendation for a specific app, feel free to ask!

Best,

SLASHCART

Hi SLASHCART,

Thank you for the suggestion! I would appreciate a recommendation for a specific app that can help with detailed order reporting, including archived orders. I’m looking for something that is easy to use and integrates seamlessly with our Shopify store.

Best regards,

Lena

Hi SLASHCART EXPERT,
Do you know how to find total number of orders by using count.json

  1. Here’s how you can find the total number of orders in Shopify without coding:

    1. Log in to Your Shopify Admin Panel: Go to your Shopify admin panel at your-store.myshopify.com/admin.

    2. Navigate to Orders: Click on Orders from the left-hand sidebar. This will take you to the Orders page where you can see a list of all orders.

    3. Find the Total Number of Orders: At the top of the Orders page, you should see a summary that includes the total number of orders. This is usually displayed directly on the Orders page or can be found in a filter section. For example, you might see something like “Showing 1-50 of 1234 orders,” where “1234” is the total number of orders.

    4. Use Filters if Necessary: If you have filters applied (like specific dates or order statuses), you might need to adjust them to see the total number of orders across all time or specific criteria.

    This method will give you a clear view of the total number of orders directly from your Shopify admin interface.

If you need further assistance or specific details, let me know!