The Shopify Order Export Service is a ERP connector that automatically creates orders in Shopify stores based on payment events from external systems. This service is designed for shops that want to integrate with the Jay platform and automatically sync orders to their Shopify store.
- Receives payment events from external systems (e.g., Stripe)
- Fetches additional transaction details from payment processors (Stripe)
- Maps order data to Shopify format
- Creates orders in Shopify with complete billing/shipping information
- Marks orders as paid automatically
- Product Variants: Maps product SKUs to Shopify variant IDs
- Customer Information: Creates orders with billing and shipping addresses
- Tax Calculation: Automatic tax calculation (19% MwSt by default)
- Shipping Costs: Configurable shipping amounts
- Order Status: Orders are automatically marked as "PAID"
- Transaction Tracking: Links orders to original payment transaction IDs
Your Shopify store must have:
Admin API Access Token with the following permissions:
write_orders- Create and modify ordersread_products- Access product variants
Product Setup:
- Products must be created in Shopify before orders can be placed
- Product variants must have unique SKUs that match your external system
| Parameter | Type | Required | Description |
|---|---|---|---|
shopify_shop_name | String | Yes | Your Shopify shop name (without .myshopify.com) |
shopify_access_token | String | Yes | Admin API access token with required permissions |
api_version | String | No | Shopify API version (defaults to 2025-01) |
| Field Category | Required | Description |
|---|---|---|
| Products | Yes | Array with SKU, quantity, price information |
| Customer Data | Yes | Retrieved automatically from payment processor |
| Transaction Details | Yes | Payment processor transaction ID |
| Shipping Costs | No | Optional shipping costs via custom fields |
- Uses Shopify Admin API version 2025-01
- GraphQL-based API communication
Created orders include:
- Line items with correct variant IDs and pricing
- Customer billing/shipping addresses
- Tax lines (configurable rate)
- Transaction records marking payment as complete
- Order notes with transaction tracking information
- Tags for order classification
As the simplified checkout only fetches one address, the CSV file may return the same address for both the invoice and the shipping address.
- Invalid product SKUs result in order creation failure
- Network errors are logged and reported
- Failed orders are stored for debugging
- Automated Order Flow: No manual order entry required
- Complete Order Data: Full customer and transaction information
- Inventory Sync: Leverages Shopify's inventory management
- Payment Tracking: Clear link between payments and orders
- Tax Compliance: Automatic tax calculation and reporting
- Shopify Plus or Advanced Plan (for API access)
- Product Catalog Setup in Shopify with proper SKUs
- Admin API Access Token with required permissions
- Jay Platform Integration for order event processing
Currently supports:
- Stripe: Full integration with transaction detail fetching
- Extensible architecture for additional processors
The connector handles:
- Invalid product variant IDs
- Missing customer information
- Payment processor API failures
- Shopify API rate limiting
- Network connectivity issues
All errors are logged and failed orders are stored for manual review.
Support
For any questions or support needs during implementation, please contact the Jay Support Team.