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.
• Configure Business entity transaction type to account mapping manually for every Shopify business entity that processes payouts, including the primary business entity. Values from the four deprecated payout account settings are not automatically copied into this mapping. The GraphQL payout flow remains disabled until you enable it.
• 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, manually configure account mappings for every Shopify business entity that processes payouts, including the primary business entity.
• 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 applicable tax 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 when payout data is processed again during re-sync.

Action required

1. Go to Settings > Payout > Business entity transaction type to account mapping.
2. Manually configure Charge, Refund, Adjustment, and Variance (catch-all) with the appropriate NetSuite GL accounts for every business entity that processes payouts, including the primary business entity. Configure additional transaction types as applicable, then select Save.
3. Save the configuration, then enable and test Shopify payout to NetSuite payout and deposit flow.
4. Validate the resulting NetSuite records before moving the production schedule to the GraphQL flow and disabling the deprecated payout flows.

For configuration and migration instructions, see Configure the GraphQL payout flow.