1. NetSuite Connector
  2. Managing Connectors
  3. Managing the Shopify Connector in NetSuite Connector
  4. Shopify Payout Report Sync

Shopify Payout Report Sync

The Shopify Payout Report sync automatically updates the corresponding order in NetSuite with payments and associated fees from Shopify Payment. The fees are added as lines on the customer deposit record in NetSuite that is linked to the order.

Prerequisites

When you bill Shopify sales orders in NetSuite, you need to ensure that a cash sale is created instead of an invoice. For more information, see Entering a Cash Sale. Cash sales and cash refunds need to be undeposited. The sync creates a deposit record, deposits the corresponding cash sales and cash refunds, then adds lines to the deposit for the fees Shopify charges. Cash sales that are already in deposited status will not work because it needs to be undeposited to be linked to a deposit.

If you want to sync refund payout data, you need to use cash refunds in NetSuite and have refund sync enabled in NetSuite Connector. See the following for more information:

Before using Shopify Payout Report Sync, you need to reauthorize your Shopify account in NetSuite Connector to update the connector permissions. To reauthorize your Shopify account in NetSuite Connector, go to Settings > Credentials then click Reauthorize Account. For more information, see Integrating NetSuite Connector with Shopify.

Shopify Payout Report Sync Settings

You need to define the accounts that are used by the Shopify Payout Report Sync. The payout report sync settings can be configured in NetSuite Connector on the Settlement tab in Shopify > Settings > Other Transactions.

  • Payout Base Account – The internal ID of the account at the base level of the deposit record in NetSuite.

  • Payout Cash Back Account – The internal ID of the cash back account for posting payouts. This is the account that transactions reference in the Cash Back subtab of the deposit record

  • Payout Other Account – The internal ID of the account referenced in the Other Deposits subtab of the deposit record in NetSuite. This is usually the undeposited funds account.

    If a Shopify order is cancelled and refunded, it most likely was never fulfilled. Shopify Payout Reconciliation processes this order into the account set up in this field.

  • Delay Factor for Payouts (in hours) – Sets the number of hours to wait before importing new payouts. Use this setting to ensure that all the cash sales records are created for the sales orders by the time the payout sync runs.

  • Sum fees and add a fee line to payout – Check this box to sum the fees then add the total as a fee line to payout.

  • Order Fee Name – Use this field to customize the name that appears on the memo field for the fee line on the deposit.

  • Add non-imported transactions as standalone lines – Check this box to allow non-imported transactions to be added to the deposit as standalone lines. When checked, orders in the payout that do not have a matching cash sale record will still be added to the deposit as non-matching line.

Enabling Shopify Payout Report Sync

When Shopify Payout Report sync is enabled, the payouts from Shopify are added as deposits to the corresponding order in NetSuite.

To enable Shopify Payout Report Sync:

  1. Log in to app.farapp.com.

  2. Select the Shopify connector and then select the relevant account.

  3. Go to Data Flows > Manage Data Syncs.

  4. Use the toggle switch to enable Payout Sync.

The sync runs every 24 hours from when the sync was enabled. You can change when the sync will run by disabling the sync and then enabling the sync at the desired time.

General Notices