What’s enhanced
Stripe card payments support for the Shopify – NetSuite integration app
Shopify updated its payments platform and migrated the legacy Stripe payment provider to the new Stripe card payments provider. With this change, you must update the handlebar expression to ensure smooth reconciliation and accurate transaction tracking when using the Shopify – NetSuite integration app integrated with the Stripe payment gateway.
By updating the handlebar expressions in the specified flow mappings, your integration will continue to capture the correct transaction identifiers as Shopify modernizes its payment infrastructure.
Background: Refer to Stripe’s official announcement for complete details. After this update, Shopify transactions use receipt.payment_id instead of the legacy ch_ (Charge) ID, which may affect reconciliation with Stripe payouts.
To ensure accurate transaction mapping and reconciliation within your Shopify – NetSuite integration app, update the handlebar expressions in the following flows:
-
Shopify order to NetSuite order (cash sale or sales order) flow
-
Import: Post orders to NetSuite
-
Destination field: eTail Transaction Id(s)
{{~#each transactionData~}} {{~#compare gateway "==" "Stripe Card Payments"~}} {{~#if receipt.payment_id~}} {{receipt.payment_id}}{{#unless @last}},{{/unless}} {{~else~}} {{#if authorization}}{{authorization}}{{#unless @last}},{{/unless}}{{/if}} {{~/if~}} {{~else~}} {{~#if authorization~}} {{authorization}}{{#unless @last}},{{/unless}} {{~/if~}} {{~/compare~}} {{~/each~}} -
-
Shopify refund to NetSuite refund (add) flow
-
Import: Post order refunds (invoice or cash sale) to NetSuite
-
Import: Post customer refunds to NetSuite
-
Destination field: eTail Transaction Id(s)
{{~#each transactions~}} {{~#compare gateway "==" "Stripe Card Payments"~}} {{~#if receipt.payment_id~}} {{receipt.payment_id}}{{#unless @last}},{{/unless}} {{~else~}} {{#if authorization}}{{authorization}}{{#unless @last}},{{/unless}}{{/if}} {{~/if~}} {{~else~}} {{~#if authorization~}} {{authorization}}{{#unless @last}},{{/unless}} {{~/if~}} {{~/compare~}} {{~/each~}} -
In each flow, locate the eTail Transaction Id(s) field under the Destination record field (NetSuite). You’ll see that this field is mapped to the sourceTransactionIds field. In the Source record field (Shopify), replace the existing value with the handlebar expression provided for the respective flow.
Note
This update applies only to real-time and scheduled flows where Shopify transaction data is automatically retrieved and synced to NetSuite, and does not apply to On-Demand flows.
Impact
-
Enables accurate reconciliation of Shopify and Stripe transactions after migrating to Stripe card payments.
-
Ensures that the eTail Transaction Id(s) field in NetSuite captures the correct payment reference (receipt.payment_id for Stripe card payments, authorization for other gateways).
-
Maintains end-to-end transaction traceability between Shopify, Stripe, and NetSuite, ensuring reliable reconciliation within the Payout to Reconciliation App.
Additional resources: