# Order Line Items

- BigQuery table name: `amazon_order_items_with_cogs`
- Available in: Seller Central
- Data scheme index: https://api.datadoe.com/api/v1/spec/data-scheme.md

Log of all orders per order id and order item. Aggregate this table to get order level data and sales per product or date.

- Source type: `SELLER_CENTRAL`
- Source ID: `89b27535d27c2a94db5ae39af4717f542624ff4df7802fd633e16c78674a1778`
- Requires a date period: yes
- Contains PII: no
- Premium table: no
- User-managed: no
- Default dataset: yes
- Rows count towards billing: yes
- Hub: https://www.datadoe.com/hub/data-scheme?source=SELLER_CENTRAL&table=89b27535d27c2a94db5ae39af4717f542624ff4df7802fd633e16c78674a1778

## Fetch periods

- `INITIAL` (730 days)
- `RECURRING_DAILY` (28 days)

## Data availability

- `REAL_TIME` — Orders are available up to 1 hour after being placed. Refresh: 10am, 1pm, 4pm, 7pm.

## Related actions

- `AMAZON_ORDERS_CANCEL` — writes: writes rows to this table
- `AMAZON_ORDERS_CONFIRM_SHIPMENT` — writes: writes rows to this table
- `AMAZON_ORDERS_CREATE_SHIPMENT` — writes: writes rows to this table
- `AMAZON_ORDERS_CANCEL_SHIPMENT` — writes: writes rows to this table
- `AMAZON_ORDERS_GET_SHIPPING_RATES` — live: reads a fresher live value
- `AMAZON_ORDERS_GET_SHIPMENT_DOCS` — live: reads a fresher live value

## Search aliases

- orders
- order lines
- line items
- units sold

## Columns (44)

- `date` (`DATE`, required) — Date of the purchase in the local timezone of the marketplace.
- `order_purchased_at_utc` (`DATE`, required) — Date and time of purchase in UTC timezone. May be different than the timezone of the marketplace or of the user.
- `marketplace_id` (`TEXT`, required) — Amazon provided ID that represents a specific country where the Seller or Vendor operates.
- `marketplace_country_code` (`TEXT`, required) — ISO country code for the Amazon marketplace.
- `marketplace_country_name` (`TEXT`, required) — Human-readable country name for the marketplace (derived from marketplace_id).
- `seller_or_vendor_id` (`TEXT`, required) — DataDoe account identifier used by MCP/API calls (sellers_and_vendors_list, exports). Not unique in amazon_sellers_and_vendors_context when one account has multiple connection contexts — join that table on connection_context_id instead.
- `seller_or_vendor_name` (`TEXT`, required) — DataDoe connection context display name for the seller or vendor.
- `marketplace_seller_id` (`TEXT`, nullable) — Amazon Seller Central seller ID from the connection (connection_seller_id). Null when the connection has no seller ID.
- `amazon_order_id` (`TEXT`, required)
- `amazon_order_item_id` (`TEXT`, required)
- `child_asin` (`TEXT`, nullable) — May be null for orders placed in the last 4h.
- `sku` (`TEXT`, required)
- `product_name` (`TEXT`, nullable) — May be null for orders placed in the last 4h.
- `line_item_number` (`TEXT`, required)
- `merchant_order_id` (`TEXT`, nullable) — May be null for orders placed in the last 4h.
- `amazon_order_updated_at` (`DATE`, nullable)
- `amazon_order_status` (`TEXT`, required) — Pending/Unshipped/Shipped/Canceled; some Unshipped and Shipped statuses have marketplace specific values which have `Unshipped` or `Shipped` prefix.
- `fulfillment_channel` (`TEXT`, required) — 'Amazon' or 'Merchant'
- `sales_channel` (`TEXT`, nullable) — Sales channel the order was placed through, e.g. 'Amazon.com' for native Amazon orders or a non-Amazon value for Multi-Channel Fulfillment (MCF) orders placed on other platforms (e.g. Shopify) and fulfilled by Amazon. May be null for orders placed in the last 4h.
- `amazon_order_channel` (`TEXT`, required) — Amazon order channel: MOBILEAPP maps from ClientAppOrderChannel, WEBSITE from WebsiteOrderChannel, and OTHER from any other or missing source value. OTHER is a fallback, not a separate marketplace or an off-Amazon sales channel. Use sales_channel to identify where the order was sold.
- `ship_service_level` (`TEXT`, nullable) — May be null for orders placed in the last 4h.
- `item_status` (`TEXT`, nullable) — Unshipped/Shipping/Shipped/Canceled; may be null for orders placed in the last 4h, for such orders amazon_order_status has current status
- `quantity` (`NUMBER`, required) — Units purchased on this order line item.
- `item_price_value` (`NUMBER`, nullable) — Line item price. Excludes buyer shipping. May be null for orders placed in the last 4h.
- `item_price_currency` (`TEXT`, nullable) — Currency code. May be null for orders placed in the last 4h.
- `item_tax_value` (`NUMBER`, nullable) — Item tax collected on this line item. Positive number or zero. May be null for orders placed in the last 4h.
- `item_shipping_price_value` (`NUMBER`, nullable) — Buyer shipping charged on this line item. May be null for orders placed in the last 4h.
- `item_shipping_tax_value` (`NUMBER`, nullable) — Tax on buyer shipping for this line item. May be null for orders placed in the last 4h.
- `item_ship_promotion_discount_value` (`NUMBER`, nullable) — Shipping promotion discount on this line item. May be null for orders placed in the last 4h.
- `gift_wrap_price_value` (`NUMBER`, nullable) — May be null for orders placed in the last 4h.
- `gift_wrap_tax_value` (`NUMBER`, nullable) — May be null for orders placed in the last 4h.
- `address_city` (`TEXT`, nullable) — May be null for orders placed in the last 4h.
- `address_state` (`TEXT`, nullable) — May be null for orders placed in the last 4h.
- `address_country` (`TEXT`, nullable) — May be null for orders placed in the last 4h.
- `address_postal_code` (`TEXT`, required)
- `order_is_business` (`LOGIC`, required) — When TRUE, the order is a B2B order. When FALSE, the order is a B2C order.
- `purchase_order_number` (`TEXT`, nullable) — May be null for orders placed in the last 4h.
- `cogs_item_value` (`NUMBER`, nullable) — Item COGS for this order line: unit item cost from amazon_cogs as of the order date, times quantity. — definition: `(amazon_cogs.cost_item_value ?? 0) * (amazon_order_items_with_cogs.quantity ?? 0)`
- `cogs_shipping_value` (`NUMBER`, nullable) — Shipping COGS for this order line: unit shipping cost from amazon_cogs as of the order date, times quantity. — definition: `(amazon_cogs.cost_item_shipping_value ?? 0) * (amazon_order_items_with_cogs.quantity ?? 0)`
- `cogs_total_value` (`NUMBER`, nullable) — Sum of cogs_item_value and cogs_shipping_value. — definition: `((amazon_cogs.cost_item_value ?? 0) + (amazon_cogs.cost_item_shipping_value ?? 0)) * (amazon_order_items_with_cogs.quantity ?? 0)`
- `cogs_present` (`LOGIC`, required) — True when an uploaded COGS record applies to this row. Zero cost can still be valid.
- `cogs_currency` (`TEXT`, nullable) — Currency code for COGS.
- `item_supplier_name` (`TEXT`, nullable) — Supplier name for the item COGS, if provided in COGS upload.
- `order_date` (`DATE`, required) — Duplicate of date column. Prefer to use date column for date filtering.

---

Query live via DataDoe MCP `exports_source_get` (connected accounts only), or request rows with `exports_create`.