Check supplier price lists and BOM cost impact with Claude API

Upload a supplier's price list (PDF, Excel or CSV) and compare it with the prices you accepted last time. It normalises every row to a price per base unit

Input

Send these Fields as input. A Field not listed here is refused.

supplier

Supplier

  • Type: string
  • Required: yes
  • Length in characters: 1 to 200

price_list

Price list file

An https URL or an upload id.

  • Type: string
  • Required: yes
  • Length in characters: at least 1

valid_from

Valid from (YYYY-MM-DD; empty means today)

  • Type: string
  • Required: no
  • Length in characters: at most 10

list_type

List type

  • Type: string
  • Required: yes
  • Allowed values: Full price list (missing items are discontinued), Partial update (only listed items changed)

accepted_prices

Accepted prices (the supplier_prices.csv your last Run returned; empty for a first list)

An https URL or an upload id.

  • Type: string
  • Required: no

bom

Bill of materials (product_code, product_name, supplier, supplier_sku, qty_per_product, base_unit, annual_volume)

An https URL or an upload id.

  • Type: string
  • Required: no

currency

Your currency (ISO code; lines in another currency stay out of the totals)

  • Type: string
  • Required: yes
  • Length in characters: 1 to 30000

accept_rows

Flagged rows to accept (supplier codes from a previous Run, one per line)

  • Type: string
  • Required: no
  • Length in characters: at most 5000

brief_language

Brief language

  • Type: string
  • Required: no
  • Length in characters: at most 40

Run it

One call presses the Widget and answers the run once its status is succeeded or failed, however long it takes. The key is read from ABYSS_API_KEY. Install the library with npm install abysshub or pip install abysshub; cURL sends the Fields as a form.

JavaScript

// index.mjs
import Abyss, { file } from "abysshub";

const abyss = new Abyss();

const run = await abyss.run("widget_394", {
  supplier: "Nordhaven Fasteners",
  price_list: file("nordhaven-price-list-2027.csv"),
  valid_from: "2027-01-01",
  list_type: "Full price list (missing items are discontinued)",
  accepted_prices: file("supplier_prices.csv"),
  bom: file("bom_lines.csv"),
  currency: "EUR",
  accept_rows: "NF-BLT-M8X40Z",
  brief_language: "English",
});

console.log(run.result);
for (const path of await run.save("output")) {
  console.log(path);
}

Python

from abysshub import Abyss, file

abyss = Abyss()

run = abyss.run("widget_394", {
    "supplier": "Nordhaven Fasteners",
    "price_list": file("nordhaven-price-list-2027.csv"),
    "valid_from": "2027-01-01",
    "list_type": "Full price list (missing items are discontinued)",
    "accepted_prices": file("supplier_prices.csv"),
    "bom": file("bom_lines.csv"),
    "currency": "EUR",
    "accept_rows": "NF-BLT-M8X40Z",
    "brief_language": "English",
})

print(run.result)
for path in run.save("output"):
    print(path)

cURL

curl https://api.abysshub.com/v1/widgets/widget_394/runs \
  -H "Authorization: Bearer $ABYSS_API_KEY" \
  -F 'supplier=Nordhaven Fasteners' \
  -F price_list=@nordhaven-price-list-2027.csv \
  -F valid_from=2027-01-01 \
  -F 'list_type=Full price list (missing items are discontinued)' \
  -F accepted_prices=@supplier_prices.csv \
  -F bom=@bom_lines.csv \
  -F currency=EUR \
  -F accept_rows=NF-BLT-M8X40Z \
  -F brief_language=English

A succeeded run carries its result and its output_files. Their URLs are signed for each read: re-read the run, never store a URL. A run still queued or running in the answer (after an hour, or when the API is busy) is read again at its Location with ?wait=true.

What it answers

The Example Run's result, the JSON the Widget wrote to output/output.json:

{
  "runId": "20261120123146-n7qj",
  "supplier": "Nordhaven Fasteners",
  "fileName": "nordhaven-price-list-2027.csv",
  "validFrom": "2027-01-01",
  "currency": "EUR",
  "firstRun": false,
  "counts": {
    "rows_read": 23,
    "skipped": 1,
    "increase": 11,
    "decrease": 2,
    "unchanged": 8,
    "new": 1,
    "discontinued": 1,
    "needs_review": 2,
    "rejected": 1
  },
  "alerts": [
    {
      "sku": "NF-SHT-15",
      "description": "Steel sheet 1.5 mm cold rolled",
      "old_price": 24.8,
      "new_price": 27.9,
      "unit": "m2",
      "change_pct": 12.5
    },
    {
      "sku": "NF-TUB-25",
      "description": "Square steel tube 25x25x2",
      "old_price": 3.1,
      "new_price": 3.42,
      "unit": "m",
      "change_pct": 10.32
    },
    {
      "sku": "NF-TUB-40",
      "description": "Square steel tube 40x40x2",
      "old_price": 4.95,
      "new_price": 5.45,
      "unit": "m",
      "change_pct": 10.1
    },
    {
      "sku": "NF-SCR-4X30",
      "description": "Wood screw 4x30 zinc, box of 200",
      "old_price": 0.021,
      "new_price": 0.0231,
      "unit": "pcs",
      "change_pct": 10
    },
    {
      "sku": "NF-ANG-40",
      "description": "Steel angle bracket 40x40 mm",
      "old_price": 0.38,
      "new_price": 0.41,
      "unit": "pcs",
      "change_pct": 7.89
    },
    {
      "sku": "NF-BLT-M8X40Z",
      "description": "Hex bolt M8x40 zinc plated class 8.8",
      "old_price": 0.115,
      "new_price": 0.124,
      "unit": "pcs",
      "change_pct": 7.83
    },
    {
      "sku": "NF-CST-75",
      "description": "Swivel castor 75 mm with brake",
      "old_price": 6.4,
      "new_price": 6.9,
      "unit": "pcs",
      "change_pct": 7.81
    },
    {
      "sku": "NF-BLT-M10X60",
      "description": "Hex bolt M10x60 zinc plated",
      "old_price": 0.235,
      "new_price": 0.252,
      "unit": "pcs",
      "change_pct": 7.23
    },
    {
      "sku": "NF-NUT-M8",
      "description": "Hex nut M8 zinc",
      "old_price": 0.018,
      "new_price": 0.019,
      "unit": "pcs",
      "change_pct": 5.56
    },
    {
      "sku": "NF-CST-75F",
      "description": "Fixed castor 75 mm",
      "old_price": 4.85,
      "new_price": 5.1,
      "unit": "pcs",
      "change_pct": 5.15
    },
    {
      "sku": "NF-WSH-M10",
      "description": "Flat washer M10 zinc",
      "old_price": 0.0095,
      "new_price": 0.0098,
      "unit": "pcs",
      "change_pct": 3.16
    }
  ],
  "impact": [
    {
      "product_code": "SH-100",
      "product_name": "Steel shelf unit, 4 tiers",
      "cost_before": 77.21,
      "cost_after": 85.01,
      "delta_per_unit": 7.81,
      "delta_pct": 10.11,
      "annual_impact": 9369.6,
      "drivers": [
        {
          "sku": "NF-SHT-15",
          "delta": 4.96
        },
        {
          "sku": "NF-TUB-25",
          "delta": 2.69
        },
        {
          "sku": "NF-BLT-M8X40",
          "delta": 0.14
        }
      ]
    },
    {
      "product_code": "WB-200",
      "product_name": "Workbench 1500 mm",
      "cost_before": 135.78,
      "cost_after": 149.3,
      "delta_per_unit": 13.52,
      "delta_pct": 9.96,
      "annual_impact": 6084.54,
      "drivers": [
        {
          "sku": "NF-SHT-15",
          "delta": 6.82
        },
        {
          "sku": "NF-TUB-40",
          "delta": 6.25
        },
        {
          "sku": "NF-ANG-40",
          "delta": 0.24
        }
      ]
    },
    {
      "product_code": "TR-300",
      "product_name": "Tool trolley, 3 shelves",
      "cost_before": 81.34,
      "cost_after": 88.22,
      "delta_per_unit": 6.87,
      "delta_pct": 8.45,
      "annual_impact": 5496.96,
      "drivers": [
        {
          "sku": "NF-SHT-15",
          "delta": 3.41
        },
        {
          "sku": "NF-TUB-25",
          "delta": 1.98
        },
        {
          "sku": "NF-CST-75",
          "delta": 1
        }
      ]
    }
  ],
  "totalAnnualImpact": 20951.1,
  "issues": [
…

More

Keys, files, errors and limits: API access.