Rank low BigCommerce stock by what actually sells

**Objective:** List product variants with inventory at or below `{threshold}` units (default 10) and say which to reorder first, optionally for brand `{brand-name}`.

**Step 1: Resolve the brand (optional)**

If a brand name was given, call `bigcommerce-get-brand` with `name`; stop if it does not match exactly one brand. Use its id as `brand-id` in Step 2.

**Step 2: Find low variants**

Call `bigcommerce-get-product-variant` with `inventory-level.max` set to the threshold. Note each variant's `inventory-warning` and `purchasing-disabled` values.

**Step 3: Add product context**

For each distinct `product-id` (up to 25), call `bigcommerce-get-product` with `id` set to it (and keep only those whose `brand-id` matches if a brand was given). Read `name`, `visible`, `availability` and `total-sold`.

**Step 4: Rank and report**

Rank by `total-sold` (highest first), then by lowest stock. Table: product, sku, stock, warning level, total sold, visible, purchasing disabled. Mark zero-stock variants still purchasable as urgent, and ignore products that are not visible unless asked.

**Rules & Guidelines:**

* This is a read-only job. Never call any `bigcommerce-*-add`, `bigcommerce-*-update` or `bigcommerce-*-delete` tool. Do not suggest that you changed anything.

**Validation:**

* If a read returns no records, say so plainly and stop; do not invent figures.
* If a result hits the maximum records limit, say the figures may be incomplete and name the filter that would narrow it.