PPuffstuff Intelligence

Settings

Product categories, customer identity, and Lightspeed API.

Lightspeed API

Pull sales & customers directly instead of (or alongside) CSV upload

Uses the Lightspeed X-Series REST API. Pulled sales run through the same Ecwid-contamination filter and idempotent commit as CSV upload, so re-pulling is safe. Verify field mappings against your account on first pull.

Ecwid live orders (Zapier webhook)

Push orders in real time instead of exporting CSVs

Webhook URL — paste into Zapier's "Webhooks by Zapier → POST" action
http://ecwid.distrx.io/api/webhooks/ecwid?token=ad6940cfad1dc50669f2628c48becb705817bbebd5961d5b
How to set up the Zap
  1. Trigger: Ecwid → "New Paid Order" (the Zap you already have).
  2. Action: "Webhooks by Zapier" → POST.
  3. URL: paste the webhook URL above.
  4. Payload type: JSON.
  5. Data — map Ecwid fields to these keys (extra keys are ignored):
    orderNumber   → Order Number
email         → Customer Email
name          → Customer Name
date          → Order/Paid Date
total         → Order Total
subtotal      → Subtotal        (optional)
tax           → Tax             (optional)
status        → Payment Status  (optional)
items         → Order Items     (optional; array of
                {name, sku, quantity, price})
  6. Even if you can't map items, the order still lands (revenue + customer). Product-level detail needs items.
  7. Re-sends are safe — the same order number is never double-counted.

Possible duplicate customers 0

Same name or phone, different Customer Codes — staff likely created a second record

No likely duplicates found.

Manual merge

Mark two customer records as the same person (reversible)

into →

Product categories

Keyword rules — first match by priority wins

No category rules yet.