Proposal summary

A process to update sales order memo field and sales order status change.

Requirement

If Magento Status = ‘Closed’ & RMA has been created in NS Then update Sales Order > Memo field = “Full – ” + RMA ID Else then update Sales Order > Memo field = “Partial – ” + Latest RMA ID.

When creating the Cash Refund form, can the script update the original Sales Order to the “Closed” status if the Magento order status is also “Closed”.

Our Solution

1. As per the understanding, whenever the status from the JSON response is “Closed” & RMA has been created in NS then we will load the sales order with the given ID in the JSON response and will update the Sales Order “Memo” field as “Full – ” + RMA ID.
2. If the RMA is not created and the status is the same as closed then we will update the Sales Order Memo field as “Partial – ” + Latest RMA ID.
3. When creating the Cash Refund form, we will look at the Magento status from the JSON response whether it is “Closed” or not. If closed and refunded then we will make the sales order status as closed by checking the “closed” check box on each item line.
4. After checking those checkboxes the sales order status will be changed to closed.

Note

• The JSON data must include the details regarding the status.
• All item lines will be checked as closed in the sales order.
• The Memo field will be editable.
• We will consider the changes only for the status “Closed”.