Skip to content
Utilerio
All endpoints

Bulk Price Updater

POST/api/v1/tools/bulk-price-updater

Apply a percentage or fixed adjustment to a spreadsheet's price column, with min/max and rounding rules.

Authentication

Requires an API key in the X-API-Key header.

Try it

POST/api/v1/tools/bulk-price-updater

Parameters

rowsstringrequired

Array of row objects (e.g. parsed from a spreadsheet).

priceColumnstringrequired

Key of the price field to adjust.

typestringoptional

Adjustment type. Default percent.

percentfixed
amountnumberoptional

Adjustment amount — e.g. 10 means +10% or +10 currency units. Negative to decrease.

roundingstringoptional

Rounding rule applied after adjustment. Default none.

nonenearestupdownpsychological
minnumberoptional

Optional floor for the new price.

maxnumberoptional

Optional ceiling for the new price.

Request body

{
  "rows": [
    {
      "sku": "A1",
      "price": 100
    },
    {
      "sku": "A2",
      "price": 250
    }
  ],
  "priceColumn": "price",
  "type": "percent",
  "amount": 10,
  "rounding": "nearest"
}

Response codes

  • 200Success.
  • 400Invalid request — check your body or parameters.
  • 401Missing or invalid API key.
  • 403The API key is not scoped to this endpoint.
  • 429Rate limit exceeded — retry after a short wait.

Language

cURL

Request

curl -X POST https://utilerio.com/api/v1/tools/bulk-price-updater \
  -H "X-API-Key: YOUR_KEY" \
  -H "Content-Type: application/json" \
  -d '{"rows":[{"sku":"A1","price":100},{"sku":"A2","price":250}],"priceColumn":"price","type":"percent","amount":10,"rounding":"nearest"}'

Response

{ "rows": [{ "sku": "A1", "price": 100, "new_price": 110 }, { "sku": "A2", "price": 250, "new_price": 275 }], "changedCount": 2 }