Shopify Catalog & Stockout Auditor avatar

Shopify Catalog & Stockout Auditor

Pricing

Pay per usage

Go to Apify Store
Shopify Catalog & Stockout Auditor

Shopify Catalog & Stockout Auditor

Fetches public Shopify /products.json feeds and checks every variant for stockouts, discounts, missing SKUs, and 0g weights. Outputs a 4-sheet Excel file (.xlsx), an HTML summary report, and dataset records.

Pricing

Pay per usage

Rating

0.0

(0)

Developer

Nazım Yurtcan

Nazım Yurtcan

Maintained by Community

Actor stats

0

Bookmarked

2

Total users

1

Monthly active users

2 days ago

Last modified

Categories

Features

Limited permissions

Share

Extracts product and variant data from public Shopify stores via the /products.json endpoint and runs a catalog audit across four areas: out-of-stock variants, active discounts (compare_at_price), missing SKUs, and 0g shipping weights.

Outputs

Every run generates three outputs:

  1. Excel Workbook (Live_Shopify_Audit.xlsx in Key-Value Store):
    • 1_Executive_Benchmark: Store-level summary (total products, variants, stockout rate %, average variant price, and estimated monthly out-of-stock revenue risk).
    • 2_Out_Of_Stock_Audit: Full list of unavailable variants with prices, weights, and direct product URLs.
    • 3_Markdown_Promo_Tracker: Variants currently on sale (price < compare_at_price), discount percentages, and >30% OFF flags.
    • 4_Catalog_Hygiene_Errors: Variants missing a SKU identifier or configured with 0g weight.
  2. HTML Report (Live_Shopify_Report.html in Key-Value Store): Visual summary table ready to open in any browser.
  3. Apify Dataset: Variant-level JSON/CSV records for API or webhook integrations.

Input Parameters

  • stores (array): One or more public Shopify store URLs (e.g., https://www.keychron.com).
  • maxPages (integer, default 40): Maximum pagination depth per store (250 products per page).
  • maxOosPrice (integer, default 15000): Filters out placeholder prices above this threshold when calculating revenue risk.
  • oosBaselineUnits (integer, default 5): Multiplier used to estimate monthly revenue at risk per out-of-stock variant.

Example Input

{
"stores": [
"https://www.keychron.com"
],
"maxPages": 40,
"maxOosPrice": 15000,
"oosBaselineUnits": 5
}