Information: You can find the integrator.io release notes for May 2020 here.
Auto-assign inventory detail to the Serialized/Lot Numbered items for Shopify cash sale and cash refund records
If you have Serialized/Lot Numbered items, it is mandatory to provide inventory details to create any posting transaction. When you select the Auto-assign inventory detail to Lot Numbered/Serialized items box in the General tab and if your order has Serialized/Lot Numbered items, the “Shopify Order to NetSuite Cash Sale Add” and “Shopify Refund to NetSuite Cash Refund Add” flows are enhanced to auto-assign inventory details to the Serialized/Lot Numbered Items.
For more information, refer here.
Assign detail for inventory with different statuses
The integration app now supports assigning inventory detail for a line item that has inventory assigned to different statues. To assign inventory detail, you have to configure subrecord mappings to the following flows:
- Shopify Order to NetSuite Cash Sale Add
- Shopify Order to NetSuite Order/CashSale Add
- Shopify Refund to NetSuite Refund Add
For more information, refer here.
Note This enhancement is supported, with the integrator.io bundle v1.11.0
Internal check for processing refunds is removed to ensure the order placed through Shopify app are processed without any errors
If an order placed through the Shopify app has the processing method as “null,” and when you run the “Shopify Refund to NetSuite Refund Add” flow, the error message “no cash sale or invoice found” is not displayed and the cash refund record is successfully created in NetSuite. The internal check for processing the refunds is removed in the backend code.
Process refund only for the line items present in cash sale or invoice records in NetSuite
While processing refunds, the “Shopify Refund to NetSuite Refund Add” flow now ensures if all the line items refunded are present in NetSuite cash sale and invoice records. If any of the item items are not present, an error message “The item <item_sku> SKU is deleted from the cash sale or invoice in NetSuite.” is displayed and the refund is not processed further.
Customer deposit record amount and original order total amount should match for partial refund orders
When you have an order with a partial refund and while syncing the customer deposits, the transaction amount is not adjusted with the partial refund amount. An order with a partial or full refund, the customer deposit record amount will now be the same as the original order total amount.
Inclusion of tax groups for tax calculation
When you sync the order taxes using the “NetSuite calculates taxes using its own tax engine” option, the tax groups are now considered for tax calculation. If the order total amount matches in Shopify and NetSuite, no variance is reported in the “eTail Total Tax Variance” field in NetSuite.
New check for “deposit date” is added to sync the payout transactions that are not deposited into NetSuite (invalid sublist or line item operation)
When you sync the Shopify payout transactions using the “Shopify Payout Transactions to NetSuite Deposit” flow, some of the transactions that are already deposited to NetSuite show the status as “undeposited”. To ensure if the transactions are deposited, the flow now checks for the “deposit date.” If the deposit date is present, the flow does not sync these transactions again. Only the payout transactions that are in the “undeposited” status and does not have any deposit date are fetched and synced.
Cart-level discount is overwritten as 0 in custom refund scenarios
A Shopify order has a cart-level discount applied and you do a custom refund to the same order without selecting any items. When you run the “Shopify Refund to NetSuite Refund Add” flow, in the cash refund record, the flow overwrites the cart-level discount amount as 0, as the discount amount should not be considered for a refund.