Issue:
This use case utilizes the Out of the Box Shopify POS. When accepting CASH, the POS does not pass a Processing_Method from Shopify. That value is blank. Celigo's out-of-the-box Integration App utilizes this field to determine payment methods and because of this, Cash Transactions are not captured through the Celigo Integration App with an applicable Payment Method.
Resolution:
- Do not map any values under the Advanced Settings > Payment > Map Payment Methods.
- Instead, go into the Field Mapping tool for Order and change the Shopify Export value from Processing_Method to Gateway, as shown here.
Before
After
- Create a Static Lookup to achieve the proper Payment Method within NetSuite.
- Lookups:
| Shopify Gateway | NetSuite Payment Method |
| Shopify Payments | Credit Cards/Apple Pay |
| amazon_payments | Amazon |
| Cash | Cash |
| paypal | paypal |