Overview
The Orders page displays all orders synced from your Shopify store. It provides a searchable, paginated list of customer orders with key details and a drill-down view for full order details including line items, customer info, and fulfillment status.
Synced Shopify Orders
Orders are synced from Shopify via the Orders API. The sync captures:
- Order number and creation date
- Customer information (name, email, shipping address)
- Line items (SKU, product name, quantity, price)
- Order totals (subtotal, tax, shipping, grand total)
- Financial status (paid, pending, refunded, etc.)
- Fulfillment status (fulfilled, partial, unfulfilled)
Sync Frequency: Orders are synced automatically based on the sync schedule configured in Settings. You can also trigger a manual sync from the Products page.
Orders List — Columns
| Column | Description |
|---|
| Order # | Shopify order number (e.g., #1001, #1002) |
| Date | Order creation date from Shopify |
| Customer | Customer display name (first + last name) |
| Total | Grand total (subtotal + tax + shipping) |
| Status | Fulfillment status (Fulfilled, Partial, Unfulfilled) |
| Items | Count of line items in the order |
Order Status Badges
| Status | Badge | Description |
|---|
| Fulfilled | Fulfilled | All line items shipped |
| Partial | Partial | Some line items shipped, others pending |
| Unfulfilled | Unfulfilled | No items shipped yet |
| Refunded | Refunded | Order refunded (financial status override) |
Pagination
The Orders list uses server-side pagination to handle large order volumes:
- Page size: 20 orders per page (configurable in Settings)
- Navigation: Previous / Next buttons plus numbered page links
- Total count: Shows "Showing 1–20 of 49 orders" above the table
- Sorting: Orders sorted by date descending (newest first) by default
Pagination Controls
| Control | Behavior |
|---|
| « Previous | Go to previous page (disabled on page 1) |
| Page numbers | Jump to a specific page |
| Next » | Go to next page (disabled on last page) |
Order Details
Clicking any order row opens the Order Details view, showing the full order information:
Order Header
| Field | Description |
|---|
| Order # | Shopify order number |
| Date | Order creation date and time |
| Financial Status | Paid, Pending, Authorized, Refunded, Partially Refunded |
| Fulfillment Status | Fulfilled, Partial, Unfulfilled |
| Total | Grand total charged to customer |
Customer Information
| Field | Description |
|---|
| Name | Customer first and last name |
| Email | Customer email address |
| Shipping Address | Full shipping address (street, city, state, zip, country) |
Line Items
| SKU | Product | Qty | Price | Total |
|---|
| SPK-RED-001 | Bluetooth Speaker - Red | 2 | $49.99 | $99.98 |
| CABLE-USB-C | USB-C Cable - 2m | 3 | $12.99 | $38.97 |
Totals Breakdown
| Component | Amount |
|---|
| Subtotal | $138.95 |
| Shipping | $5.99 |
| Tax | $11.12 |
| Grand Total | $156.06 |
Data Sources
| Data | Source | Update Frequency |
|---|
| Order List | /api/orders | Synced from Shopify Orders API |
| Order Details | /api/orders/:id | Real-time from database |
| Customer Info | Shopify Orders API | Captured during sync |
| Sales History | sales_history table | Updated during order sync |
Sync Note: Order data is only as fresh as the last sync. If you have recent Shopify orders not showing, trigger a manual sync or wait for the next scheduled sync.