Pólónagyker API: live stock and wholesale prices in your own system

Complete live stock feed

One authenticated request returns stock for every published variant, including zero stock. There is no pagination or filtering. Withdrawn and deleted products disappear from the complete list, so replace the previous list on each refresh.

Live data means the current committed stock in the webshop database, following imports, manual edits and background internal-stock deductions for webshop orders. It is not a direct connection to the warehouse system or a file generated every 15 minutes.

The default is JSON; format=json returns the same response and format=csv downloads CSV. Other formats return a 422 JSON error. data contains the complete list, meta.generated_at is the response time in UTC, and meta.total is the row count.

Send your existing key in the Authorization: Bearer or X-API-Key header, never in the URL. The feed shares the rate limit with other API requests: normally 60 requests per minute per account. Missing or invalid key: 401; rate limit exceeded: 429.

sku

Variant SKU, as text.

title

Variant title in the selected API language.

base_sku

Base product SKU, as text.

internal_quantity

Internal stock quantity, as an integer.

internal_restock_date

Expected internal restock date: YYYY-MM-DD or null.

external_quantity

External stock quantity, as an integer.

external_restock_date

Expected external restock date: YYYY-MM-DD or null.

Missing stock gives quantity 0 and a null arrival date. Quantities are summed across warehouses of the same type; the earliest arrival date is returned.

JSON and CSV examples

curl "https://polonagyker.hu/index.php/api/v1/stock-feed" \
  -H "X-API-Key: key"

curl "https://polonagyker.hu/index.php/api/v1/stock-feed?format=csv" \
  -H "Authorization: Bearer key"

{
  "data": [{
    "sku": "00123-M",
    "title": "T-shirt M",
    "base_sku": "00123",
    "internal_quantity": 120,
    "internal_restock_date": null,
    "external_quantity": 500,
    "external_restock_date": "2026-10-20"
  }],
  "meta": {
    "generated_at": "2026-10-06T12:00:00+00:00",
    "total": 1
  }
}

sku,title,base_sku,internal_quantity,internal_restock_date,external_quantity,external_restock_date
00123-M,T-shirt M,00123,120,,500,2026-10-20

CSV uses UTF-8, commas and standard quoting. Missing dates are empty cells. Text that could be interpreted as a formula gets a leading apostrophe; JSON preserves the original text. Import both SKU columns as Text to preserve leading zeros.

Excel Power Query: authenticated refresh

1. In Excel, choose Data > Get Data > From Other Sources > Blank Query.
2. In the Power Query editor, use Manage Parameters to create a Text parameter named ApiKey and enter your own API key.
3. Paste the JSON query below into the Advanced Editor. If Excel asks for an authentication method, choose Anonymous for the web address: the code sends your API key in the header.
4. Choose Close & Load. Later, Data > Refresh All retrieves the complete stock list again. Share the workbook containing your key only with people authorised to use the API.

let
    Source = Json.Document(Web.Contents("https://polonagyker.hu/index.php", [
        RelativePath = "api/v1/stock-feed",
        Headers = [#"X-API-Key" = ApiKey]
    ])),
    Rows = Table.FromRecords(Source[data], {
        "sku", "title", "base_sku", "internal_quantity", "internal_restock_date",
        "external_quantity", "external_restock_date"
    }),
    Typed = Table.TransformColumnTypes(Rows, {
        {"sku", type text}, {"title", type text}, {"base_sku", type text},
        {"internal_quantity", Int64.Type}, {"internal_restock_date", type date},
        {"external_quantity", Int64.Type}, {"external_restock_date", type date}
    })
in
    Typed

    Source = Csv.Document(Web.Contents("https://polonagyker.hu/index.php", [
        RelativePath = "api/v1/stock-feed",
        Query = [format = "csv"],
        Headers = [#"X-API-Key" = ApiKey]
    ]), [Delimiter = ",", Encoding = 65001, QuoteStyle = QuoteStyle.Csv]),
    Promoted = Table.PromoteHeaders(Source, [PromoteAllScalars = true]),
    Rows = Table.ReplaceValue(Promoted, "", null, Replacer.ReplaceValue,
        {"internal_restock_date", "external_restock_date"}),