Shopify Product CSV Checker

    1

    Catch common Shopify product CSV mistakes and get a row-by-row fix report for prices, variants, headers, and duplicate SKUs.

    $9.99

    Secure checkout via Stripe

    Money-back guarantee

    Converts to your local currency at checkout

    Security scanned

    Works with the AI Agents you already use

    Claude CodeClaude CodeCursorCursorCodex CLICodex CLIMuseMuseDotsDots+21 more

    Shopify Product CSV Checker

    Example session with this skill installed

    Check this fictional product CSV before I import new products into Shopify. Run the local checker, explain the errors and warnings, and give me a fix list. Keep the original file unchanged.

    URL handle,Title,Option1 name,Option1 value,SKU,Price,Compare-at price,Status,Product image URL
    cotton-tee,Cotton Tee,Size,S,000101,$29.00,39.00,active,https://example.com/tee.jpg
    cotton-tee,,Size,M,000101,29.00,20.00,,images/tee.jpg
    
    • Read your context and instructions
    • Compiled the shopify product csv
    • Generated the data export

    Shopify product CSV preflight

    Actual checker output from the included fictional example.

    Mode: new. Records checked: 2.
    Blocking errors: 2. Warnings: 2.

    This report covers supported checks only. It does not establish Shopify import acceptance.

    Record numbers include the header and count quoted multiline cells as one record.

    LevelRecordCheckColumnObserved valueSuggested action
    error2price_formatPrice$29.00Use a nonnegative decimal amount without currency symbols or grouping separators; confirm the intended amount.
    error3image_urlProduct image URLimages/tee.jpgUse a full HTTP(S) image URL. Reachability is not checked.
    warning3compare_at_reviewCompare-at price20.00Compare-at is not above the selling price; confirm the intended sale presentation.
    warning3duplicate_skuSKU000101Also used by another variant at record 2; confirm intentional reuse.

    Unchecked columns: none listed

    Live store state, image accessibility, taxonomy, metafield values, Markets configuration, packed dimensions, and full platform constraints were not validated.

    Next steps

    Confirm the intended numeric price, replace the relative image path with a real publicly accessible image URL, and review the compare-at price and repeated SKU. If you want a repaired copy, supply those decisions and rerun the checker on that copy. The original file remains unchanged, including the leading zeros in SKU 000101. No Shopify upload has taken place.

    tee.jpg

    CSV · data export

    Generated

    Example file from a real run - the skill writes it into your workspace.

    Connects securely to your tools. The creator never sees your data.

    About this skill

    Preparing a Shopify product import? Give your AI agent the CSV and ask it to check the file before you upload it.

    Shopify Product CSV Checker combines a local Python checker with an agent workflow that explains each issue and prepares a repair plan. The report separates blocking errors from warnings that need your judgment.

    What you get

    • Checks for broken CSV structure, duplicate headers, and missing product identity.
    • Price-format checks and review warnings for suspicious compare-at prices.
    • Option-pair checks, repeated variant warnings, and missing option identity checks for updates.
    • Duplicate SKU review that preserves leading zeros.
    • Image URL format checks without contacting the URLs.
    • Markdown and JSON reports with record numbers and suggested actions.
    • A fictional example file, its actual checker output, and 23 automated regression tests.

    Handles selected current and legacy Shopify column names, multiple variants, and extra image rows. The checker leaves your original CSV unchanged. If you ask your agent to repair the file, it can use the report to create a separate draft and explain the changes.

    Best for

    Shopify freelancers, small store teams, and agencies that prepare product imports or product updates.

    Requirements

    An AI agent with local file access and command execution, plus Python 3.9 or newer. No additional Python packages, Shopify account connection, or API key is required by the checker. A text-only chat cannot run the script.

    The package has been tested locally. Compatibility has not been independently verified in every agent or with a live Shopify import.

    Scope

    For Shopify product CSV files only. It does not cover inventory-by-location imports, customer or order imports, or B2B catalog imports. It does not validate live store state, image availability, taxonomy values, metafield definitions, Markets configuration, packed dimensions, or every Shopify constraint. A clean report is not a guarantee that Shopify will accept an import.

    The checker itself is offline and makes no network calls. Any file content you share with an AI agent is still subject to that provider's data handling.

    Independent tool, unaffiliated with Shopify.

    For Shopify product CSVs only; not inventory-by-location, customer, order, or B2B catalog CSVs. Checks selected current and legacy headers and common structural/value issues, not every Shopify constraint. Does not validate live store state, image accessibility, taxonomy membership, metafield definitions, Markets configuration, packed dimensions, or all file-size limits. Requires Python 3.9+ and local command execution. No live Shopify import was performed. A clean report is not an import guarantee. Duplicate SKU and repeated variant findings need human review. Repairs require a separate request and confirmed intended values; the checker itself only writes reports.

    How to use

    1. 1

      Connect your agent to the Agensi MCP

      Copy the prompt and paste it into Claude, ChatGPT, Cursor or any agent that supports MCP. It sets up the connection for you. Manual setup

    2. 2

      Sign in to Agensi

      Your agent shows a sign-in link. Sign in and click Allow.

    3. 3

      Ask for what you need

      Your agent loads this skill and uses it on your task. It always asks before any payment.

    Reviews

    No reviews yet

    Be one of the first to try it. Every listed skill goes through the trust checks below.

    Security scanned

    Checked by our 8-point scan before listing

    Fresh listing

    Recently published to Agensi

    Money-back guarantee

    Doesn't do what its page promises? You get your money back.

    Trust & safety

    Security scan

    Security scan passed 1 month ago

    Requires

    Python

    Permissions

    Terminal / Shell
    Read Files
    Write Files

    File Scopes

    *.csv
    **/report.md
    **/report.json

    Reads the user-selected product CSV and bundled skill resources. Runs a Python standard-library script locally. Creates a new user-selected directory containing report.md and report.json. The checker does not modify the input CSV, make network requests, contact image URLs, access environment variables, or connect to Shopify. If the user separately requests a repair, the agent writes a new CSV copy and change log. AI provider data handling still applies to content shared with the agent.

    Listed1 month ago

    What's inside

    Frequently Asked Questions

    No. The checker reads a product CSV on your computer and writes Markdown and JSON reports. It does not log in to Shopify, require an API key, or make network requests.

    An AI agent that can read local files and run commands, plus Python 3.9 or newer. The script uses only Python's standard library. A text-only chat cannot execute it. Install the unzipped skill folder using your agent's normal SKILL.md installation workflow.

    The checker leaves the original file unchanged and creates report.md and report.json in a new local directory. It does not create or upload products. If you separately request repairs, your agent can create a new CSV draft using the report and your confirmed values.

    No. It checks common structural, identity, price, and selected field issues. Live store state, image availability, advanced field definitions, and all Shopify constraints are outside its coverage. Review the remaining warnings and Shopify's import preview.

    New in E-commerce