Browse sources$ls -a sources
Logo of shopify
Shopify
Access the data inside e-commerce stores on Shopify
Sync your customers' dataFiber pulls data from your customers' Shopify accounts into your database or cloud storage. Skip months of integration work and begin syncing in minutes.
Logo of shopify
Logo of shopify
Logo of shopify
Logo of shopify
Logo of shopify
Logo of shopify
Logo of shopify
Logo of shopify
Logo of shopify
Logo of shopify
Fiber
postgres-prod
shopify_balance_transactions
shopify_collects
shopify_custom_collections
Your customers' Shopify accounts
Your production database
Meet your new integration toolkit: SQLReplace calls to the Shopify API with an interface you already use. Access the data you need straight from your database.
-- Fetch all the Orders belonging to the Shopify
-- store of a particular user.

SELECT *
FROM fiber.shopify_order
WHERE store_id = '{user.store_id}'
-- Fetch all the Orders belonging to the Shopify
-- store of a particular user.

SELECT *
FROM fiber.shopify_order
WHERE store_id = '{user.store_id}'
Code
CREATE TABLE fiber.shopify_order (
id TEXT NOT NULL,
created_at TIMESTAMP WITH TIME ZONE,
updated_at TIMESTAMP WITH TIME ZONE,
store_id TEXT,
admin_graphql_api_id TEXT,
app_id TEXT,
browser_ip TEXT,
buyer_accepts_marketing BOOLEAN,
cancel_reason TEXT,
cancelled_at TIMESTAMP WITH TIME ZONE,
cart_token TEXT,
checkout_id TEXT,
checkout_token TEXT,
client_details JSONB,
closed_at TIMESTAMP WITH TIME ZONE,
confirmed BOOLEAN,
contact_email TEXT,
currency TEXT,
current_subtotal_price DOUBLE PRECISION,
current_subtotal_price_set JSONB,
current_total_discounts DOUBLE PRECISION,
current_total_discounts_set JSONB,
current_total_duties_set TEXT,
current_total_price DOUBLE PRECISION,
current_total_price_set JSONB,
current_total_tax DOUBLE PRECISION,
current_total_tax_set JSONB,
customer_locale TEXT,
device_id TEXT,
discount_codes JSONB,
email TEXT,
financial_status TEXT,
fulfillment_status TEXT,
gateway TEXT,
landing_site TEXT,
landing_site_ref TEXT,
location_id TEXT,
name TEXT,
note TEXT,
note_attributes JSONB,
number INT,
order_number INT,
order_status_url TEXT,
original_total_duties_set TEXT,
payment_gateway_names TEXT[],
phone TEXT,
presentment_currency TEXT,
processed_at TIMESTAMP WITH TIME ZONE,
processing_method TEXT,
reference TEXT,
referring_site TEXT,
source_identifier TEXT,
source_name TEXT,
source_url TEXT,
shop_url TEXT,
subtotal_price DOUBLE PRECISION,
subtotal_price_set JSONB,
tags TEXT,
tax_lines JSONB,
taxes_included BOOLEAN,
test BOOLEAN,
token TEXT,
total_discounts DOUBLE PRECISION,
total_discounts_set JSONB,
total_line_items_price DOUBLE PRECISION,
total_line_items_price_set JSONB,
total_outstanding DOUBLE PRECISION,
total_price DOUBLE PRECISION,
total_price_set JSONB,
total_price_usd DOUBLE PRECISION,
total_shipping_price_set JSONB,
total_tax DOUBLE PRECISION,
total_tax_set JSONB,
total_tip_received DOUBLE PRECISION,
total_weight INT,
user_id TEXT,
billing_address JSONB,
customer JSONB,
discount_allocations JSONB,
fulfillments JSONB,
line_items JSONB,
payment_details JSONB,
refunds JSONB,
shipping_address JSONB,
shipping_lines JSONB
)
CREATE TABLE fiber.shopify_order (
id TEXT NOT NULL,
created_at TIMESTAMP WITH TIME ZONE,
updated_at TIMESTAMP WITH TIME ZONE,
store_id TEXT,
admin_graphql_api_id TEXT,
app_id TEXT,
browser_ip TEXT,
buyer_accepts_marketing BOOLEAN,
cancel_reason TEXT,
cancelled_at TIMESTAMP WITH TIME ZONE,
cart_token TEXT,
checkout_id TEXT,
checkout_token TEXT,
client_details JSONB,
closed_at TIMESTAMP WITH TIME ZONE,
confirmed BOOLEAN,
contact_email TEXT,
currency TEXT,
current_subtotal_price DOUBLE PRECISION,
current_subtotal_price_set JSONB,
current_total_discounts DOUBLE PRECISION,
current_total_discounts_set JSONB,
current_total_duties_set TEXT,
current_total_price DOUBLE PRECISION,
current_total_price_set JSONB,
current_total_tax DOUBLE PRECISION,
current_total_tax_set JSONB,
customer_locale TEXT,
device_id TEXT,
discount_codes JSONB,
email TEXT,
financial_status TEXT,
fulfillment_status TEXT,
gateway TEXT,
landing_site TEXT,
landing_site_ref TEXT,
location_id TEXT,
name TEXT,
note TEXT,
note_attributes JSONB,
number INT,
order_number INT,
order_status_url TEXT,
original_total_duties_set TEXT,
payment_gateway_names TEXT[],
phone TEXT,
presentment_currency TEXT,
processed_at TIMESTAMP WITH TIME ZONE,
processing_method TEXT,
reference TEXT,
referring_site TEXT,
source_identifier TEXT,
source_name TEXT,
source_url TEXT,
shop_url TEXT,
subtotal_price DOUBLE PRECISION,
subtotal_price_set JSONB,
tags TEXT,
tax_lines JSONB,
taxes_included BOOLEAN,
test BOOLEAN,
token TEXT,
total_discounts DOUBLE PRECISION,
total_discounts_set JSONB,
total_line_items_price DOUBLE PRECISION,
total_line_items_price_set JSONB,
total_outstanding DOUBLE PRECISION,
total_price DOUBLE PRECISION,
total_price_set JSONB,
total_price_usd DOUBLE PRECISION,
total_shipping_price_set JSONB,
total_tax DOUBLE PRECISION,
total_tax_set JSONB,
total_tip_received DOUBLE PRECISION,
total_weight INT,
user_id TEXT,
billing_address JSONB,
customer JSONB,
discount_allocations JSONB,
fulfillments JSONB,
line_items JSONB,
payment_details JSONB,
refunds JSONB,
shipping_address JSONB,
shipping_lines JSONB
)
Model definition
About this source
Logo of shopify
ShopifyE-commerce platform for online stores and retail point-of-sale systems.shopify.com  ↗
Available resources
Missing a resource? We will build it for you.
Similar sources
OAuth
Need help with OAuth for Shopify?Handshake ↗ is a Next.js app boilerplate that handles your OAuth with Shopify and over 200 other APIs. Setup and deploy within minutes.
Related guides
Logo of shopifyIntegrate Shopify using Fiber Fiber makes it easy to access third-party data from Shopify accounts. Get started in just a few minutes.