happytails.ai

Product variant matrix generator

Open Product variant matrix generator on Happytails.ai. This view has the same page content and links, with explicit tool capabilities. Read the processing notes before using a tool.

Tool capabilities

{
  "id": "product-variant-matrix-generator",
  "category": "data-tools",
  "built": true,
  "requirements": "The complete product must fit 10,000 combinations and 100,000 cells before exclusions. Each exclusion matches all named values exactly; overlapping exclusions count once. No partial result is exported. Maximum 1,000,000 input characters, 10,000 records and 100,000 result cells. CSV output is bounded to 4,000,000 characters.",
  "implementation": {
    "fields": [
      {
        "key": "exclusions",
        "label": "Exact exclusion rules",
        "value": "[]",
        "type": "textarea",
        "help": "JSON array, for example [{\"size\":\"S\",\"colour\":\"Red\"}]. Each object matches all its values exactly. Separate objects match independently. Unknown attributes or values are rejected."
      },
      {
        "key": "template",
        "label": "Optional SKU template",
        "value": "",
        "type": "text",
        "help": "For example {size}{sep}{colour}{sep}{n}. Leave empty for combinations only. {n} is the retained one-based sequence."
      },
      {
        "key": "separator",
        "label": "SKU separator",
        "value": "-",
        "type": "text"
      },
      {
        "key": "padding",
        "label": "Sequence zero padding",
        "value": 0,
        "type": "number",
        "min": 0,
        "max": 12,
        "step": 1
      },
      {
        "key": "maxLength",
        "label": "Maximum SKU length",
        "value": 100,
        "type": "number",
        "min": 1,
        "max": 500,
        "step": 1
      },
      {
        "key": "exportMode",
        "label": "Spreadsheet formula handling",
        "value": "Protect formulas",
        "type": "select",
        "values": [
          "Protect formulas",
          "Preserve original cells"
        ]
      }
    ],
    "live": true,
    "background": true,
    "presentation": "metrics",
    "note": "Paste a JSON object of named arrays, for example {\"size\":[\"S\",\"M\"],\"colour\":[\"Red\",\"Blue\"]}. Use 1 to 10 options with distinct nonempty values, up to 200 characters each. The full product must fit 10,000 combinations and 100,000 cells before exclusions. No partial export. SKU collisions are retained and reported, never silently renamed. Runs on your device.",
    "experience": {
      "automatic": true,
      "single": false,
      "inputMaxLength": 1000000,
      "inputMode": "text",
      "label": "Product option sets",
      "placeholder": "JSON object of arrays",
      "help": "Example: {\"size\":[\"S\",\"M\"],\"colour\":[\"Red\",\"Blue\"]} Results update as you type. Up to 1,000,000 characters.",
      "helpParts": [
        "Example: {\"size\":[\"S\",\"M\"],\"colour\":[\"Red\",\"Blue\"]}",
        "Results update as you type.",
        "Up to 1,000,000 characters."
      ],
      "action": null
    },
    "mode": "automatic",
    "interactive": false
  },
  "execution": "Browser interface",
  "api": null,
  "browser_agent": {
    "supported": true,
    "name": "run_current_tool",
    "discovery": "WebMCP on the human page in a supporting browser",
    "verification": "See audit/API-AUDIT.md; availability is not verification"
  }
}

Page guide

Generate exact option combinations, remove explicit exclusions and optionally produce SKUs with visible collision reports.

How to use Product variant matrix generator
  1. Paste a JSON object mapping each option name to a list of distinct values.
  2. Add exact exclusion objects and an optional SKU template.
  3. Review kept and excluded counts, then download the complete CSV and JSON report.

Useful next steps

Exact matching and predictable order

Option names and values are case-sensitive. Results follow the input option and value order. A template can reference option names, {sep} and the retained sequence {n}. Empty, oversized or colliding SKUs remain visible for correction.

Local processing and exports

Processing runs on your device. CSV downloads quote every cell and protect formula prefixes by default. JSON preserves original strings and includes the report and result tables. Spreadsheet import settings can still change identifiers; import them as text.