Enhanced Shopify payout processing with a consolidated GraphQL flow
The Shopify - NetSuite integration app now provides a GraphQL-based Shopify payout to NetSuite payout and deposit flow.
This flow combines the payout process previously handled by two separate flows. It retrieves Shopify Payments payout summaries and their underlying transactions, then creates the corresponding payout custom records, bank deposits, and variance transactions in NetSuite.
What’s changing
- Shopify payout and transaction retrieval now uses Shopify GraphQL APIs.
- Two existing payout flows are consolidated into one flow with five steps:
- Get payouts from Shopify
- Post payout custom records to NetSuite
- Get Shopify payout transactions
- Post deposits to NetSuite
- Post payout variance transactions to NetSuite
- A new Business entity transaction type to account mapping setting replaces the previous fixed account settings.
- Existing account configurations are automatically migrated to preserve current behavior.
- The existing flows now display a To be deprecated tag:
- Shopify Payout Transactions to NetSuite Deposit (To be deprecated)
- Shopify Payout to NetSuite Payout Custom Record (To be deprecated)
The existing flows remain available during the transition period, but we recommend migrating to Shopify payout to NetSuite payout and deposit.
Key improvements
- Simplified payout processing: A single flow now creates payout custom records, bank deposits, and variance transactions in NetSuite.
- Business entity-based account mapping: Maps Shopify Payments transaction types for each business entity to the appropriate NetSuite GL account and subsidiary.
- Support for additional transaction types: The Transaction types field is a multi-select dropdown that lets you group multiple Shopify Payments transaction types to sync to the same NetSuite GL account. This means transaction types such as Shopify Cash Credit and Shopify Collective can be combined into a single mapping row. If a transaction type is not available in the dropdown, you can enter it manually using the Custom transaction types (comma-separated) field.
- Improved transaction traceability: Shopify payout transactions, including sales, refunds, fees, and adjustments, are synced with the details required for bank reconciliation.
- Non-blocking variance handling: Missing transactions and amount mismatches are recorded as variance transactions without preventing deposit creation.
- Safe reprocessing: Shopify payout and transaction IDs help prevent duplicate records during payout data reprocessing.
Action required
Before running the flow, ensure that a business entity is pre-selected and configured for every Shopify business entity that processes payouts. All business entities must be set up to ensure payout reports sync properly.
Review the automatically migrated entries under Business entity transaction type to account mapping and confirm that each transaction type is assigned to the appropriate NetSuite GL account.
Configure and test Shopify payout to NetSuite payout and deposit before moving your production schedule from the existing payout flows. Disable the flows marked To be deprecated only after validating the GraphQL payout flow and its resulting NetSuite records.
For configuration and migration instructions, see Configure the GraphQL payout flow.