SQL examples for ODBC

The following SQL examples demonstrate common use cases for this connector. Select a scenario below to view the query syntax and parameters required to interact with Shopify.

• Adjust inventory level
• Bulk create customers using raw JSON body from SQL Server
• Bulk create customers using SQL Server data
• Bulk delete customers using IDs from SQL Server
• Bulk update customers using SQL Server data
• Call generic API request
• Connect inventory item to location
• Create a customer
• Create a customer using raw JSON body
• Create a product
• Create a product variant
• Create an order
• Delete a customer
• Delete a customer (throw error if not found)
• Delete a product
• Delete a product variant
• Delete an order
• Delete an order (throw error if not found)
• Execute GraphQL query
• Read a customer by ID
• Read a product by ID
• Read an inventory item by ID
• Read an order by ID
• Read customers
• Read inventory levels
• Read inventory levels by inventory and location IDs
• Read inventory levels by inventory item IDs
• Read inventory levels by location IDs
• Read multiple customers by IDs
• Read multiple inventory items by IDs
• Read multiple orders by IDs
• Read multiple products by IDs
• Read open orders
• Read order line items
• Read order line items by multiple order IDs
• Read order line items by order ID
• Read orders
• Read product variants
• Read product variants by multiple product IDs
• Read product variants by product ID
• Read products
• Set inventory level
• Set inventory level (generic API)
• Update a customer using raw JSON body
• Update a product
• Update a product variant
• Update an existing customer record
• Update an inventory item
• Update an order