# Prepare Supplier CSV for WooCommerce Variations

**Use case:** 

Convert a declared supplier catalog into reviewable WooCommerce parent and variation rows, a source map, and explicit exceptions. This example uses seven synthetic rows and shows the exact supported mapping before a USD 9 completed-bundle run.

## Input

```json
{
  "supplierCsv": "https://api.apify.com/v2/key-value-stores/ijOi26B5fY89fiTgT/records/supplier.csv",
  "mapping": {
    "supplierSkuColumn": "supplier_sku",
    "productNameColumn": "supplier_product_name",
    "parentTokenRegex": "^([A-Z][0-9]{3})-",
    "caseSkuSuffixRegex": "-CASE$",
    "sizeColumn": "size_label",
    "colorColumn": "color_label",
    "inventoryCountColumn": "inventory_count",
    "inventoryUomColumn": "inventory_uom",
    "caseSizeColumn": "case_size",
    "retailPriceColumn": "sell_price_each_usd",
    "sizeSynonyms": {
      "small": "Small",
      "S": "Small",
      "M": "Medium",
      "L": "Large",
      "Large": "Large",
      "XL": "Extra Large",
      "One Size": "One Size"
    },
    "colorSynonyms": {
      "red": "Red",
      "blue": "Blue",
      "navy": "Navy"
    },
    "eachSynonyms": [
      "EA",
      "each"
    ],
    "caseSynonyms": [
      "case",
      "cases"
    ]
  },
  "maxRows": 10000
}
```

## Output

```json
{
  "status": {
    "label": "Run status",
    "format": "string"
  },
  "attempted": {
    "label": "Rows attempted",
    "format": "integer"
  },
  "resolved": {
    "label": "Rows resolved",
    "format": "integer"
  },
  "exceptions": {
    "label": "Rows refused",
    "format": "integer"
  },
  "priceUsd": {
    "label": "Completed bundle price",
    "format": "string"
  },
  "customerRevenueStatus": {
    "label": "Revenue evidence status",
    "format": "string"
  }
}
```

## About this Actor

This example demonstrates how to use [Supplier CSV to WooCommerce Variations — Files + Exceptions](https://apify.com/winstonvale/supplier-csv-to-woocommerce-variations.md) with a specific input configuration. Visit the [Actor detail page](https://apify.com/winstonvale/supplier-csv-to-woocommerce-variations.md) to learn more, explore other use cases, and run it yourself.


## 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.
This Task's input is already configured above — use it as-is rather than inventing a new one.

- **AI agents and MCP clients** — the [Apify MCP server](https://docs.apify.com/integrations/mcp.md) at `https://mcp.apify.com` (remote, streamable HTTP, OAuth on first use).
- **Agentic workflows and local Actor development** — [Agent Skills](https://apify.com/.well-known/agent-skills/index.json) with the [Apify CLI](https://docs.apify.com/cli/docs.md): `npm install -g apify-cli`, then `apify login`.
- **JavaScript/TypeScript projects** — the official [JS/TS client](https://docs.apify.com/api/client/js/docs.md): `npm install apify-client`.
- **Python projects** — the official [Python client](https://docs.apify.com/api/client/python/docs.md): `pip install apify-client`.
- **Any other language** — the [REST API](https://docs.apify.com/api/v2.md).

For full API examples (JavaScript, Python, CLI, MCP, OpenAPI), see this Task's Actor page: https://apify.com/winstonvale/supplier-csv-to-woocommerce-variations.md

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).