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 following existing flows now display a Deprecated tag:
- [Deprecated] Shopify Payout Transactions to NetSuite Deposit
- [Deprecated] Shopify Payout to NetSuite Payout Custom Record
- The following settings now display a Deprecated tag:
- [Deprecated] NetSuite bank deposit account
- [Deprecated] NetSuite account to track adjustments and fees
- [Deprecated] NetSuite account to track variance
- [Deprecated] NetSuite account to track Marketplace sales tax
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.
- 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.
- 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 Charge, Refund, Adjustment, Variance (catch-all), and Tax (recommended), 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 when payout data is processed again during re-sync.
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 the Business entity transaction type to account mapping. Confirm that Charge, Refund, Adjustment, Variance (catch-all), and Tax (recommended) are each assigned to the appropriate NetSuite GL account. These are required for the flow to process payouts correctly. The flow returns an error if any of these are not mapped when you save.
- Configure and test Shopify payout to NetSuite payout and deposit before moving your production schedule from the existing payout flows. Disable the flows marked Deprecated only after validating the GraphQL payout flow and its resulting NetSuite records.
For configuration and migration instructions, see Configure the GraphQL payout flow.