Shopify Catalog & Stockout Auditor
Pricing
Pay per usage
Go to Apify Store
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
Maintained by CommunityActor 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:
- Excel Workbook (
Live_Shopify_Audit.xlsxin 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% OFFflags.4_Catalog_Hygiene_Errors: Variants missing a SKU identifier or configured with0gweight.
- HTML Report (
Live_Shopify_Report.htmlin Key-Value Store): Visual summary table ready to open in any browser. - 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, default40): Maximum pagination depth per store (250products per page).maxOosPrice(integer, default15000): Filters out placeholder prices above this threshold when calculating revenue risk.oosBaselineUnits(integer, default5): 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}