Requirement:
Client wants to update values in the field “Shipping Method (Report)”, a custom field in all transactions. Item fulfillment can’t be updated as there is no standard import for it and so we need to update it using script.
- We need to populate the values in the custom field “Shipping Method (Report)” in item fulfilment from the standard field “Shipping method”.
Proposal:
Proposal Summary
This proposal summarizes the functionality for setting the custom field “Shipping Method (Report Purpose)” with the value in “Shipping Method” field.
Requirement
We have to update values in the field “Shipping Method (Report)” in all transactions. Item fulfillment can’t be updated as there is no standard import for it and so we need to update it using script.
Our Solution
- We will deploy a Mass Update scrript to update the custom field “Shipping Method (Report Purpose)” with the value in “Shipping Method” field.
- The Mass update script will perform a mass update on all the item fulfillments in production environment and set the value taken from the field ‘Shipping Method’ in to the custom field ‘Shipping Method (Report Purpose).
Risks
- There are some scripts deployed in item fulfillment record that sends email to customers and other recipients when IF is edited and saved. So, this functionality may trigger these deployed scripts and emails will be sent due to this.
- As a solution for this, we will undeploy these scripts while executing the script for setting shipping method (Report purpose) field, and once this is completed we will deploy the undeployed scripts.
- Since we need to disable the email sending scripts while performing mass update, we will be doing this during your non-business hours only, because disabling these scripts may affect the business flow.
Assumptions
- We assume that we can disable the scripts that triggers email notification and deployed in item fulfillment record while performing mass update:
- Since there are almost 38760 item fulfillment records in production, we will be doing the mass update on batches of Item fulfillments splited based on date range.
Since we need to disable the email sending scripts while performing mass update, we will be doing this during your non-business hours, because disabling these scripts may affect the business flow.
- If there’s any item fulfillment record having account period closed, we will not be able to update the field value in such IFs.