Shopify Duplicate SKU & Variant Cleanup Audit

Find duplicate SKUs, missing SKUs, messy variants, zero-price variants, duplicate option values, and catalog cleanup problems before inventory, POS, ads, or marketplace sync breaks.

This Actor is for Shopify sellers, ecommerce operators, agencies, inventory managers, collectibles shops, apparel stores, and marketplace sellers who need cleaner product variant data for Shopify, Google Shopping, Meta catalogs, eBay, CedCommerce, POS systems, or warehouse tools.

What it checks

• variants with missing/blank SKUs
• duplicate SKUs across products or variants
• zero, negative, missing, or invalid variant prices
• duplicate variant titles within a product
• repeated option values that may confuse variant selection
• placeholder option names/values like Default Title
• products with no variants
• products with very large variant counts
• product cleanup score and top fix per product

Input

{
  "storeUrl": "https://example.com",
  "maxProducts": 100,
  "requireSkus": true,
  "checkDuplicateSkus": true,
  "checkPrices": true,
  "checkOptions": true,
  "maxVariantsPerProduct": 100,
  "includePassingProducts": false
}

Fields

• storeUrl — public Shopify storefront URL.
• maxProducts — maximum products to scan.
• requireSkus — flag variants with missing SKUs.
• checkDuplicateSkus — find SKU values used by multiple variants.
• checkPrices — flag missing, invalid, zero, or negative variant prices.
• checkOptions — flag confusing option/variant structures.
• maxVariantsPerProduct — warn on very large variant sets.
• includePassingProducts — include products with no detected issues.

Output

Dataset row types:

• summary
• product_cleanup_audit
• variant_issue
• duplicate_sku_group

Example product row:

{
  "recordType": "product_cleanup_audit",
  "title": "Trading Card Booster Box",
  "url": "https://store.com/products/trading-card-booster-box",
  "variantCount": 4,
  "missingSkuCount": 2,
  "duplicateSkuCount": 0,
  "zeroPriceCount": 1,
  "duplicateVariantTitleCount": 0,
  "score": 61,
  "grade": "needs_work",
  "issueCodes": ["missing_sku", "zero_or_negative_price"],
  "topFix": "Add unique SKUs to variants so downstream systems can identify inventory correctly."
}

Example duplicate SKU group row:

{
  "recordType": "duplicate_sku_group",
  "sku": "ABC-123",
  "variantCount": 2,
  "productCount": 2,
  "productTitles": ["Product A", "Product B"],
  "variantIds": [111, 222],
  "severity": "critical",
  "suggestedFix": "Assign a unique SKU to each distinct sellable variant, or intentionally consolidate inventory outside this public catalog data."
}

Why this matters

SKU and variant problems can break or confuse:

• Shopify inventory reporting
• POS and warehouse systems
• Google Shopping and Meta catalogs
• eBay/CedCommerce marketplace sync
• paid ad catalogs
• order fulfillment
• customer variant selection

The Actor does not modify your Shopify store. It reads the public Shopify product catalog endpoint and produces a CSV/API-friendly cleanup report.