Data Reference

What data you receive from Sync As A Service.

Data Format

We provide line-item level purchase data — each product/SKU is a separate record with its order context. Available as JSON (API) or CSV (export).

Fields

Field
Description
Example

Retailer

Retailer name

Amazon

Retailer Order ID

Retailer's order number

112-3456789-0123456

Order Date

Purchase date (ISO 8601)

2024-12-05T14:20:00Z

Item Name

Product name/title

Organic Dog Food - 30lb

Brand

Product brand

PetNature

Dept

Department/group

Pet Supplies

Category

Product category

Dog Food

SubCategory

Product sub-category

Dry Food

SKU

Retailer's product identifier

B0DGJ7HYG1 (Amazon ASIN)

Quantity

Units purchased

1

Price

Unit price

45.99

Currency

Currency code

USD

Shipment Status

Human-readable delivery status

Delivered Dec 8

Order Total

Total order amount

45.99

Each record = one item/SKU. Multi-item orders appear as multiple records sharing the same Retailer Order ID.


CSV Export

Request CSV format via the API:

Returns a downloadable file:


JSON Response

The API returns the same data as JSON by default:

See API Reference for query parameters (filtering by retailer, date range, pagination).


Field Availability

Not all fields are guaranteed for every record:

Field
Availability

Retailer

Always

Order Date

Always

Item Name

Usually (~95%)

Price

Usually (~90%)

Brand

Often (~70%)

SKU

Often (~70%)

Dept / Category

Often (~60%)

Shipment Status

Often (~60%)


Retailer Data

Connected retailer accounts (from /sync/connections):

Connection Statuses:

Status
Meaning
User Action

valid

Connected and working

Can sync

invalid

Credentials expired or incorrect

Needs reconnect

pending

Currently validating

Wait


Supported Retailers

Currently supported:

  • Amazon (including Amazon Fresh, Whole Foods)

  • Walmart

  • Target

  • Costco

  • Kroger (and family: Fred Meyer, Ralphs)

  • Safeway (and Albertsons family)

  • Best Buy

  • Home Depot

  • Sephora

  • Chewy

  • PetSmart

15+ retailers with more being added regularly.


Personally Identifiable Information (PII)

What's Included

Minimal PII:

  • User's name (if available)

  • Phone number (for authentication only)

  • Email (if available)

Not Included

  • Credit card numbers

  • Billing or shipping addresses

  • Payment methods

  • Recipient information


Data Freshness

  • Initial sync: Within minutes of connection

  • Recurring sync: Every 24 hours

  • Manual sync: On-demand via API

  • Historical data: Up to 12 months (retailer-dependent)


Example Use Cases

Rewards & Loyalty:

Purchase Verification:

Spending Analytics:

Aggregating to Order Level

If you need order-level totals, group by retailerOrderId:

Last updated

Was this helpful?