# Shopify Duplicate SKU & Variant Cleanup Audit (`charlieakan/shopify-duplicate-sku-variant-cleanup-audit`) Actor Find duplicate SKUs, missing SKUs, messy variants, zero-price variants, duplicate option values, and catalog cleanup issues before inventory or marketplace sync breaks. - **URL**: https://apify.com/charlieakan/shopify-duplicate-sku-variant-cleanup-audit.md - **Developed by:** [CharlieAKAN](https://apify.com/charlieakan) (community) - **Categories:** E-commerce, SEO tools, Automation - **Stats:** 1 total users, 0 monthly users, 0.0% runs succeeded, 0 bookmarks - **User rating**: No ratings yet ## Pricing from $1.00 / completed shopify sku cleanup audit This Actor is paid per event and usage. You are charged both the fixed price for specific events and for Apify platform usage. Learn more: https://docs.apify.com/platform/actors/running/actors-in-store#pay-per-event ## What's an Apify Actor? Actors are a software tools running on the Apify platform, for all kinds of web data extraction and automation use cases. In Batch mode, an Actor accepts a well-defined JSON input, performs an action which can take anything from a few seconds to a few hours, and optionally produces a well-defined JSON output, datasets with results, or files in key-value store. In Standby mode, an Actor provides a web server which can be used as a website, API, or an MCP server. Actors are written with capital "A". ## How to integrate an Actor? If asked about integration, you help developers integrate Actors into their projects. You adapt to their stack and deliver integrations that are safe, well-documented, and production-ready. The best way to integrate Actors is as follows. In JavaScript/TypeScript projects, use official [JavaScript/TypeScript client](https://docs.apify.com/api/client/js.md): ```bash npm install apify-client ``` In Python projects, use official [Python client library](https://docs.apify.com/api/client/python.md): ```bash pip install apify-client ``` In shell scripts, use [Apify CLI](https://docs.apify.com/cli/docs.md): ````bash # MacOS / Linux curl -fsSL https://apify.com/install-cli.sh | bash # Windows irm https://apify.com/install-cli.ps1 | iex ```bash In AI frameworks, you might use the [Apify MCP server](https://docs.apify.com/platform/integrations/mcp.md). If your project is in a different language, use the [REST API](https://docs.apify.com/api/v2.md). For usage examples, see the [API](#api) section below. For more details, see Apify documentation as [Markdown index](https://docs.apify.com/llms.txt) and [Markdown full-text](https://docs.apify.com/llms-full.txt). # README ## 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 ```json { "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: ```json { "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: ```json { "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. # Actor input Schema ## `storeUrl` (type: `string`): Public Shopify storefront URL, for example https://example.com. ## `maxProducts` (type: `integer`): Maximum number of products to audit. ## `requireSkus` (type: `boolean`): Flag variants with missing/blank SKUs. ## `checkDuplicateSkus` (type: `boolean`): Flag SKU values used by more than one variant. ## `checkPrices` (type: `boolean`): Flag zero, missing, negative, or suspicious variant prices. ## `checkOptions` (type: `boolean`): Flag duplicate option values, placeholder option names, and default-title variants mixed with real variants. ## `maxVariantsPerProduct` (type: `integer`): Products above this variant count are flagged as potentially hard to manage/sync. ## `includePassingProducts` (type: `boolean`): Include product rows even when no issues were found. ## Actor input object example ```json { "maxProducts": 100, "requireSkus": true, "checkDuplicateSkus": true, "checkPrices": true, "checkOptions": true, "maxVariantsPerProduct": 100, "includePassingProducts": false } ``` # Actor output Schema ## `results` (type: `string`): No description # API You can run this Actor programmatically using our API. Below are code examples in JavaScript, Python, and CLI, as well as the OpenAPI specification and MCP server setup. ## JavaScript example ```javascript import { ApifyClient } from 'apify-client'; // Initialize the ApifyClient with your Apify API token // Replace the '' with your token const client = new ApifyClient({ token: '', }); // Prepare Actor input const input = {}; // Run the Actor and wait for it to finish const run = await client.actor("charlieakan/shopify-duplicate-sku-variant-cleanup-audit").call(input); // Fetch and print Actor results from the run's dataset (if any) console.log('Results from dataset'); console.log(`💾 Check your data here: https://console.apify.com/storage/datasets/${run.defaultDatasetId}`); const { items } = await client.dataset(run.defaultDatasetId).listItems(); items.forEach((item) => { console.dir(item); }); // 📚 Want to learn more 📖? Go to → https://docs.apify.com/api/client/js/docs ``` ## Python example ```python from apify_client import ApifyClient # Initialize the ApifyClient with your Apify API token # Replace '' with your token. client = ApifyClient("") # Prepare the Actor input run_input = {} # Run the Actor and wait for it to finish run = client.actor("charlieakan/shopify-duplicate-sku-variant-cleanup-audit").call(run_input=run_input) # Fetch and print Actor results from the run's dataset (if there are any) print("💾 Check your data here: https://console.apify.com/storage/datasets/" + run["defaultDatasetId"]) for item in client.dataset(run["defaultDatasetId"]).iterate_items(): print(item) # 📚 Want to learn more 📖? Go to → https://docs.apify.com/api/client/python/docs/quick-start ``` ## CLI example ```bash echo '{}' | apify call charlieakan/shopify-duplicate-sku-variant-cleanup-audit --silent --output-dataset ``` ## MCP server setup ```json { "mcpServers": { "apify": { "command": "npx", "args": [ "mcp-remote", "https://mcp.apify.com/?tools=charlieakan/shopify-duplicate-sku-variant-cleanup-audit", "--header", "Authorization: Bearer " ] } } } ``` ## OpenAPI specification ```json { "openapi": "3.0.1", "info": { "title": "Shopify Duplicate SKU & Variant Cleanup Audit", "description": "Find duplicate SKUs, missing SKUs, messy variants, zero-price variants, duplicate option values, and catalog cleanup issues before inventory or marketplace sync breaks.", "version": "0.1", "x-build-id": "ETaJGzJoIDGHQXkdm" }, "servers": [ { "url": "https://api.apify.com/v2" } ], "paths": { "/acts/charlieakan~shopify-duplicate-sku-variant-cleanup-audit/run-sync-get-dataset-items": { "post": { "operationId": "run-sync-get-dataset-items-charlieakan-shopify-duplicate-sku-variant-cleanup-audit", "x-openai-isConsequential": false, "summary": "Executes an Actor, waits for its completion, and returns Actor's dataset items in response.", "tags": [ "Run Actor" ], "requestBody": { "required": true, "content": { "application/json": { "schema": { "$ref": "#/components/schemas/inputSchema" } } } }, "parameters": [ { "name": "token", "in": "query", "required": true, "schema": { "type": "string" }, "description": "Enter your Apify token here" } ], "responses": { "200": { "description": "OK" } } } }, "/acts/charlieakan~shopify-duplicate-sku-variant-cleanup-audit/runs": { "post": { "operationId": "runs-sync-charlieakan-shopify-duplicate-sku-variant-cleanup-audit", "x-openai-isConsequential": false, "summary": "Executes an Actor and returns information about the initiated run in response.", "tags": [ "Run Actor" ], "requestBody": { "required": true, "content": { "application/json": { "schema": { "$ref": "#/components/schemas/inputSchema" } } } }, "parameters": [ { "name": "token", "in": "query", "required": true, "schema": { "type": "string" }, "description": "Enter your Apify token here" } ], "responses": { "200": { "description": "OK", "content": { "application/json": { "schema": { "$ref": "#/components/schemas/runsResponseSchema" } } } } } } }, "/acts/charlieakan~shopify-duplicate-sku-variant-cleanup-audit/run-sync": { "post": { "operationId": "run-sync-charlieakan-shopify-duplicate-sku-variant-cleanup-audit", "x-openai-isConsequential": false, "summary": "Executes an Actor, waits for completion, and returns the OUTPUT from Key-value store in response.", "tags": [ "Run Actor" ], "requestBody": { "required": true, "content": { "application/json": { "schema": { "$ref": "#/components/schemas/inputSchema" } } } }, "parameters": [ { "name": "token", "in": "query", "required": true, "schema": { "type": "string" }, "description": "Enter your Apify token here" } ], "responses": { "200": { "description": "OK" } } } } }, "components": { "schemas": { "inputSchema": { "type": "object", "required": [ "storeUrl" ], "properties": { "storeUrl": { "title": "Shopify store URL", "type": "string", "description": "Public Shopify storefront URL, for example https://example.com." }, "maxProducts": { "title": "Max products", "minimum": 1, "maximum": 5000, "type": "integer", "description": "Maximum number of products to audit.", "default": 100 }, "requireSkus": { "title": "Require SKUs", "type": "boolean", "description": "Flag variants with missing/blank SKUs.", "default": true }, "checkDuplicateSkus": { "title": "Check duplicate SKUs", "type": "boolean", "description": "Flag SKU values used by more than one variant.", "default": true }, "checkPrices": { "title": "Check prices", "type": "boolean", "description": "Flag zero, missing, negative, or suspicious variant prices.", "default": true }, "checkOptions": { "title": "Check options", "type": "boolean", "description": "Flag duplicate option values, placeholder option names, and default-title variants mixed with real variants.", "default": true }, "maxVariantsPerProduct": { "title": "Max variants per product before warning", "minimum": 1, "maximum": 250, "type": "integer", "description": "Products above this variant count are flagged as potentially hard to manage/sync.", "default": 100 }, "includePassingProducts": { "title": "Include passing products", "type": "boolean", "description": "Include product rows even when no issues were found.", "default": false } } }, "runsResponseSchema": { "type": "object", "properties": { "data": { "type": "object", "properties": { "id": { "type": "string" }, "actId": { "type": "string" }, "userId": { "type": "string" }, "startedAt": { "type": "string", "format": "date-time", "example": "2025-01-08T00:00:00.000Z" }, "finishedAt": { "type": "string", "format": "date-time", "example": "2025-01-08T00:00:00.000Z" }, "status": { "type": "string", "example": "READY" }, "meta": { "type": "object", "properties": { "origin": { "type": "string", "example": "API" }, "userAgent": { "type": "string" } } }, "stats": { "type": "object", "properties": { "inputBodyLen": { "type": "integer", "example": 2000 }, "rebootCount": { "type": "integer", "example": 0 }, "restartCount": { "type": "integer", "example": 0 }, "resurrectCount": { "type": "integer", "example": 0 }, "computeUnits": { "type": "integer", "example": 0 } } }, "options": { "type": "object", "properties": { "build": { "type": "string", "example": "latest" }, "timeoutSecs": { "type": "integer", "example": 300 }, "memoryMbytes": { "type": "integer", "example": 1024 }, "diskMbytes": { "type": "integer", "example": 2048 } } }, "buildId": { "type": "string" }, "defaultKeyValueStoreId": { "type": "string" }, "defaultDatasetId": { "type": "string" }, "defaultRequestQueueId": { "type": "string" }, "buildNumber": { "type": "string", "example": "1.0.0" }, "containerUrl": { "type": "string" }, "usage": { "type": "object", "properties": { "ACTOR_COMPUTE_UNITS": { "type": "integer", "example": 0 }, "DATASET_READS": { "type": "integer", "example": 0 }, "DATASET_WRITES": { "type": "integer", "example": 0 }, "KEY_VALUE_STORE_READS": { "type": "integer", "example": 0 }, "KEY_VALUE_STORE_WRITES": { "type": "integer", "example": 1 }, "KEY_VALUE_STORE_LISTS": { "type": "integer", "example": 0 }, "REQUEST_QUEUE_READS": { "type": "integer", "example": 0 }, "REQUEST_QUEUE_WRITES": { "type": "integer", "example": 0 }, "DATA_TRANSFER_INTERNAL_GBYTES": { "type": "integer", "example": 0 }, "DATA_TRANSFER_EXTERNAL_GBYTES": { "type": "integer", "example": 0 }, "PROXY_RESIDENTIAL_TRANSFER_GBYTES": { "type": "integer", "example": 0 }, "PROXY_SERPS": { "type": "integer", "example": 0 } } }, "usageTotalUsd": { "type": "number", "example": 0.00005 }, "usageUsd": { "type": "object", "properties": { "ACTOR_COMPUTE_UNITS": { "type": "integer", "example": 0 }, "DATASET_READS": { "type": "integer", "example": 0 }, "DATASET_WRITES": { "type": "integer", "example": 0 }, "KEY_VALUE_STORE_READS": { "type": "integer", "example": 0 }, "KEY_VALUE_STORE_WRITES": { "type": "number", "example": 0.00005 }, "KEY_VALUE_STORE_LISTS": { "type": "integer", "example": 0 }, "REQUEST_QUEUE_READS": { "type": "integer", "example": 0 }, "REQUEST_QUEUE_WRITES": { "type": "integer", "example": 0 }, "DATA_TRANSFER_INTERNAL_GBYTES": { "type": "integer", "example": 0 }, "DATA_TRANSFER_EXTERNAL_GBYTES": { "type": "integer", "example": 0 }, "PROXY_RESIDENTIAL_TRANSFER_GBYTES": { "type": "integer", "example": 0 }, "PROXY_SERPS": { "type": "integer", "example": 0 } } } } } } } } } } ```