Pushbuild

Distributor Price List Cleaner - Excel, CSV, PDF to UPC

Turn a supplier's messy Excel, CSV or PDF price list into clean rows: check-digit-validated UPC/EAN, item number, brand, description, case pack, unit and case cost, MSRP and margin. Finds the header row and common column names on its own. Ready for wholesale product sourcing.

$0.40 per 1,000 rows

Get an API key

What it returns

Turn a supplier's messy Excel, CSV or PDF price list into clean rows: check-digit-validated UPC/EAN, item number, brand, description, case pack, unit and case cost, MSRP and margin. Finds the header row and common column names on its own. Ready for wholesale product sourcing.

Request

POST https://api.pushbuild.com/distributor-price-list-cleaner/run with a JSON body. Send your key in the X-API-Key header.

FieldTypeDescription
fileUrls requiredlist of stringsLinks to .xlsx, .csv or .pdf price lists (up to 10, 50 MB each)
validUpcOnlybooleanDrop rows whose code fails the check digit or is missing Default: false.
maxItemsintegerMaximum items to return (1-500). Default: 100.

Example

curl -X POST https://api.pushbuild.com/distributor-price-list-cleaner/run \
  -H "X-API-Key: YOUR_KEY" \
  -H "Content-Type: application/json" \
  -d '{"fileUrls": ["https://example.com/pricelist.xlsx"], "maxItems": 20}'

Response

{"count": 20, "truncated": false, "seconds": 1.4, "items": [ { ... } ]}

Each call returns up to 500 items. Records that fail validation or are not found are flagged in the items and not charged.

Pricing

Pay only for results returned: $0.40 per 1,000 rows. No charge for errors or empty searches.

Tell us what you need built.

Questions about this API, higher volumes, or a data source you need that we don't cover yet.

hello@pushbuild.com

(617) 299-8887

Tell us about your project

A few questions so we can come back with a written scope. We reply within one business day.