Important: As of March 1, 2024, Shopify has deprecated the 'processing_method' field in the Orders API. We kindly request that you update the mapping from the 'processing method' field to the 'payment gateway' field.
This article helps you update the mapping of the import fields from the Shopify processing method to the payment gateway.
Important: This update is relevant only if you populate the payment method mapping under Settings > Order > Payment > Map Payment Method; if not, no further action is required.
Reason for update
Shopify announced that the “processing_method” field in the Orders API will be deprecated soon. To overcome this business problem, Celigo has enhanced the integration app to leverage the “gateway” field in the Transactions API. So, all the merchants using the “processing_method” field for payments must now move the payment method mapping from the processing method to the payment gateway.
Important: The 'processing_method' field can only be seen in API versions 2023-01 and below, but not in higher versions.
Before you update
In Shopify, depending on the payment gateway that you are using, get the values of the gateway field from the order transactions JSON as explained below. Once you get the gateway field values, enter them into the Shopify Payment Method field and map them with the corresponding NetSuite Payment Method field values.
Important: You must repeat the steps below for each payment gateway used to obtain the correct value for the 'gateway' field.
To get the Shopify gateway field values:
- Go to your Shopify store.
- In the left pane, click Orders.
- Open the appropriate order that has the associated payment transactions.
- In the browser address bar (URL), after the Shopify order number, enter /transactions.json to see the gateway value.
- Example: https://usstore.myshopify.com/admin/orders/1356273254482/transactions.json
- Click Enter.
- In JSON, below "transactions", you can find the “gateway”.
Update payment method mapping
- Ensure you add the gateway field values in the Shopify Payment Method field before enabling the Map Shopify payment gateway to NetSuite payment method checkbox.
- In the Map Payment Method setting, be sure that you do not delete the existing one-to-one mappings configured with the processing_method, until the last step of this update. The update is live and real-time, and following this prerequisite will ensure that you don't miss any order transactions synced during the update.
From the previous step, you have collected all the gateway field values from Shopify > Order > Transactions JSON. Now, add all those values to the Shopify Payment Method field and map with the corresponding NetSuite Payment Method field.
Follow the below steps:
- Navigate to Settings > Order > Payment > Map Payment Methods.
- In the Shopify Payment Method field, enter the Shopify gateway value.
- In the NetSuite Payment Method field, enter the corresponding value for the NetSuite payment method.
Note: While selecting a value in the NetSuite Payment Method field, if no data is yet visible, click Refresh to fetch the values from NetSuite.
You can also perform additional actions if a unique match is not found:
- Fail Record:
- If no results are found in the static mapping, the request returns an empty string and fails.
- This option is selected by default & used by most of our customers. Enabling this setting means the order processing would fail if an exact match is not found for the Payment Method in NetSuite for the corresponding value from the eCommerce platform or the online marketplace.
- Use Empty String as Default value: Choose this option to use an empty string ('') as the default value. This value is used if your mapping doesn’t have the required value.
- Use Null as Default Value: Use ‘null’ as the default value if your mapping doesn’t have the required value.
- Use Custom Default Value: Specify a default value to be set for the extracted field. You can also provide a default value for the NetSuite "Payment Method" field here if no match is found in the lookup table.
- Fail Record:
- Click Save.
- Select the Map Shopify payment gateway to NetSuite payment method checkbox to move the Shopify payment method mapping from the processing method to the payment gateway.
- Click Save.
Note: You can now safely delete the existing one-to-one mappings configured with the processing_method.
- Order transaction status is a success.
- If an order has multiple transactions, Netsuite will consider the higher amount as the payment gateway as it only allows one payment method per order.
Impacted flows
The following flows are affected by this update:
- Shopify order to NetSuite cash sale (add)
- Shopify order to NetSuite order (cash sale or sales order)
- Shopify order to NetSuite sales order (add)
- NetSuite order to Shopify order (add)
- Shopify refund to NetSuite refund (add)
Once you have made the above changes, open any of the above-mentioned flows > mapping, and you will notice the updated gateway field mapping.
The following screenshot is an example of the Shopify order to NetSuite cash sale (add) flow.
The following screenshot is an example of the Shopify refund to NetSuite refund (add) flow.
Users who have custom flows or DIY flows and are using the Processing Method to map the Payment method need to amend their existing mapping.
Shopify has provided alternative fields that can be used to replace the Processing Method.
The processing_method property is no longer available due to orders supporting multiple transactions with various processing methods. The field contained incorrect data.
The values processing_method provided can be inferred from various sources:
- Free - is accessible through the order totals.
- checkout - can be determined by the presence of checkout_id on an order.
- express, direct, offsite, and manual - can be inferred through the OrderTransaction gateway and payment_details properties.