Data reference

Introduction

Cafe24 is one of the largest Korean DTC (direct-to-consumer) e-commerce platforms, powering individual merchant malls. Each mall has its own subdomain, and a single mall account may operate multiple shops. The connector authenticates against Cafe24’s Admin REST API v2 over OAuth2 and syncs order and product data for dashboards. The connector exposes orders, products, and reconstructed sales metrics. Cafe24 issues values in the mall’s currency (typically KRW), and a single connection can be split across multiple shops by creating one data source per shop. Pre-aggregated dashboard data (visits, ad effect, category sales, and similar) is exposed separately by the Cafe24 Analytics data source. As an e-commerce connector, order, revenue, and product breakdowns are standardized so widgets can aggregate alongside ad-platform sources without additional configuration. To connect this data source, see How to connect Cafe24 to Adriel.

Data refresh strategy

Architecture data

Architecture covers products and their catalog metadata. Products are fully refreshed once per day. Each product record carries name, SKU, price, retail (compare-at) price, image, status, and category metadata, paged in cursor batches of 100 (by last product number).

Reports data

Reports include order-level financial and status data. Orders are refreshed daily (there is no hourly refresh cadence for this connector). At every refresh, orders made or modified in the most recent 3-day window are re-pulled to capture status transitions such as payment, cancellation, and refund. Orders are fetched in two parallel passes and then deduplicated by order ID:

Regular orders are pulled by payment date (pay_date) when the data source uses payment-date mode, or by order date (order_date) otherwise.
Cancelled orders are pulled by cancellation-complete date (cancel_complete_date).

An order appearing in both passes (for example, paid and cancelled on the same day) is kept once. Orders are paged in batches of 1000 with item lines embedded inline. Revenue is reported in the asset’s configured currency, converted from the mall currency (default KRW) at sync time.

Architecture levels

Mall → Shop → Product catalog → Order → Order line. Each order line is a separate row on the order. A cancelled order additionally produces a separate cancellation record.

Date range limits

Breakdown	Max range
Daily	93 days
Weekly (Start: Mon) / Weekly (Start: Sun)	1 year
Monthly / Quarterly / Yearly	No explicit cap (bounded by the 90-day historical window)

Historical orders can be back-filled up to 90 days; data older than 90 days cannot be retrieved through this connector.

Metrics

How to read the columnsThe Data type column uses this vocabulary: Number, Currency, Percentage, Ratio, Duration, Date, Text, URL, Array, Boolean.The API Key column uses code style like order_price_amount for the literal Cafe24 field name. Italic text describes how a value is produced when it doesn’t map to a single Cafe24 field — typically an Adriel-side aggregation across order rows or a computed formula.

Orders

Metric	Description	Data type	API Key
Order Count	Number of unique orders in the period.	Number	Aggregated from order rows
Order Item Count	Total number of items in an order.	Number	Aggregated from order line items
Order Date	Date the order was placed.	Date	`order_date`
Order Payment Date	Date the order’s payment cleared.	Date	`payment_date`
Order Updated Date	Date the order was last modified.	Date	Derived from the order record
Order Currency	Currency the order was placed in.	Text	`currency`

Revenue & sales

Metric	Description	Data type	API Key
Order Price Amount	Order price before shipping and discounts. Falls back to the payment amount when the order price is `0`.	Currency	`order_price_amount` / `payment_amount`
Order Payment Amount	Amount actually paid on the order.	Currency	Computed: `order_price_amount + shipping_fee - discount_amount`
Order Amount Due	Outstanding amount due on the order.	Currency	`total_amount_due`
Order Tax Amount	Tax on the order.	Currency	`tax`
Order Options Total Additional Price	Additional price contributed by selected product options across the order’s items.	Currency	Computed: `Sum(items.option_price)`
Order Cancelled Payment Amount	Cancelled or refunded payment amount. Populated only on cancellation records; always `0` for regular orders, and `0` for cancellations whose items have no refund date.	Currency	Adriel-computed from item refund amounts

Products

Metric	Description	Data type	API Key
Product Price	Listed product price.	Currency	`price`
Product Retail Price	Retail (compare-at) price.	Currency	`retail_price`
Product Currency	Currency of the product price.	Text	Derived from shop settings
Product Image	Product detail image URL.	URL	`detail_image`
Product Created Date	Date the product was created.	Date	`created_date`
Product Updated Date	Date the product was last updated.	Date	`updated_date`
Product Order Price Amount	Revenue tied to a specific product within an order (item price × quantity).	Currency	Computed from order line items
Product Order Quantity	Units of a specific product sold within an order.	Number	Computed from order line items

Product Order metrics link products with their orders. When a Product Order metric is used with a product filter, only the portion of the order tied to that product is included, and only orders containing at least one matching product are shown. If a product has been deleted in Cafe24, the related orders may not appear — use Product Order metrics only when necessary.

Customers

Metric	Description	Data type	API Key
Order Buyer Count	Number of unique buyers who placed an order in the period.	Number	Aggregated from order rows

Buyer anonymization. Cafe24 returns buyer details with each order, but buyer fields are anonymized before persistence, so dashboards do not expose customer PII.

Fulfillment & delivery

Metric	Description	Data type	API Key
Order Shipping Fee	Shipping fee charged on the order.	Currency	`shipping_fee`

Discounts & abandonment

Metric	Description	Data type	API Key
Order Discount Amount	Discounts applied to the order.	Currency	Aggregated order-level discounts

Breakdowns

Products

Breakdown	Description	API Key
Product ID	Cafe24 product number.	`product_no`
Product Name	Product display name.	`product_name`
Product Detailed Name	English product name.	`eng_product_name`
Product SKU	Stock-keeping unit / product code.	`product_code`
Product Status	Product status.	Derived from the product record

Order details

Breakdown	Description	API Key
Order ID	Cafe24 order identifier.	`order_id`
Order Source	Sales channel the order was placed through.	`order_place_name`
Order Payment Method	Payment method used on the order.	Derived from order payment data
Order Status	Order status.	Derived from the order lifecycle

Customer type

Order Customer Type is resolved by Adriel from the buyer’s first-order flag on the order.

Breakdown	Description
Order Customer Type	`New` for the buyer’s first order, `Returning` for subsequent orders.

Time & date grouping

Time groupings are Adriel-side aggregations of the same underlying order data.

Breakdown	Description
Auto Time Breakdown	Automatically picks the best granularity for the date range.
Daily	Split reports by day. Max range 93 days.
Weekly (Start: Mon)	Split reports by week starting Monday. Max range 1 year.
Weekly (Start: Sun)	Split reports by week starting Sunday. Max range 1 year.
Monthly	Split reports by calendar month.
Quarterly	Split reports by calendar quarter.
Yearly	Split reports by calendar year.

When the “from” and “to” filters do not align with the start and end of a period, the entire period is still displayed, though the filters still apply to the Total row.

Overview & status

These groupings are provided by Adriel and do not map to a Cafe24 field.

Breakdown	Description
No Grouping	Do not break down; return one aggregated row.
Datasource Name	Group by the Adriel data source name.

Limitations

Based on the current connector, Cafe24 has:

A 90-day historical limit. Orders older than 90 days from today cannot be back-filled.
Daily refresh cadence. Orders sync daily on a rolling 3-day look-back window; there is no hourly refresh.
One-time-use refresh tokens. Each token refresh issues a new refresh token that replaces the previous one. If a refresh response is missing the new refresh token, the connection is unrecoverable until it is reconnected.
Shared OAuth app account cap. Adriel’s own Cafe24 OAuth app is limited to five accounts. Beyond that, customers must supply their own developer-app credentials (client_app_id / client_app_secret) on the connection, which then take priority over the platform default.
Per-shop scoping. A mall may expose multiple shops; each data source is scoped to exactly one shop. Reporting across several shops requires separate data sources sharing the underlying mall connection.
Cancellations are separate records. A cancelled order produces a distinct cancellation record (order ID suffixed :cancel) that carries only Order Cancelled Payment Amount as non-zero; all other monetary values on it are 0.
No deleted-data retention. Products or orders deleted in Cafe24 no longer appear. Orders that reference a deleted product may not surface under Product Order metrics.
Rate limiting. Requests are throttled to one per 500 ms per asset.

Introduction

Data refresh strategy

Architecture data

Reports data

Architecture levels

Date range limits

Metrics

Orders

Revenue & sales

Products

Customers

Fulfillment & delivery

Discounts & abandonment

Breakdowns

Products

Order details

Customer type

Time & date grouping

Overview & status

Limitations

API references

See also

​Introduction

​Data refresh strategy

​Architecture data

​Reports data

​Architecture levels

​Date range limits

​Metrics

​Orders

​Revenue & sales

​Products

​Customers

​Fulfillment & delivery

​Discounts & abandonment

​Breakdowns

​Products

​Order details

​Customer type

​Time & date grouping

​Overview & status

​Limitations

​API references

​See also

Introduction

Data refresh strategy

Architecture data

Reports data

Architecture levels

Date range limits

Metrics

Orders

Revenue & sales

Products

Customers

Fulfillment & delivery

Discounts & abandonment

Breakdowns

Products

Order details

Customer type

Time & date grouping

Overview & status

Limitations

API references

See also