I have tried to calculate the age of my inventory some of which can be up to twelve months old .
I only have approx 350 SKUS can anyone suggest how I can achieve this?
Hi — here are a few practical ways to get an inventory aging view for your ~350 SKUs:
1. Shopify’s built-in reports
In Analytics → Reports, check if you have “Inventory value” or “Average inventory sold per day” (depends on your plan). They don’t show “age” directly, but they help you see what’s moving. For true aging (e.g. “received date → today”), you usually need either an app or an export.
2. Use “received at” or “created at” for age
If you track received date (or use the date inventory was added) in a metafield or in your CSV/Excel, you can compute age as “today − received date” in days or months. With 350 SKUs, exporting to Excel/Sheets and adding a column like =DATEDIF(received_date, TODAY(), “M”) (or “D”) gives you months or days old. You can then pivot or filter to get an aging report (e.g. 0–3 months, 3–6, 6–12, 12+).
3. Apps that do inventory aging
Search the App Store for “inventory aging” or “inventory reports”. Some apps connect to your inventory and received dates (or first stock date) and build aging buckets (e.g. 0–30 days, 31–90, 91–365, 12+ months). Worth trying a free trial on one that matches how you record dates.
4. If you need “exact age in years, months and days”
For reports or templates that require a precise “X years, Y months, Z days” from a given date to today (e.g. for one-off checks or custom exports), you can use a free chronological age calculator (enter “received date” and today’s date) to get that format. For 350 SKUs you’d still do the main aging in bulk via export + formula or an app, but it’s handy for checking the math or for a small set of dates.
Summary: For 350 SKUs, the most practical path is: export inventory (with received/created date) → Excel/Sheets with a DATEDIF (or similar) column → aging buckets, and/or an inventory aging app from the App Store. If you say whether you already have “received date” (or similar) in Shopify, we can narrow down the exact steps.