This process is currently manual. We have already talked to Sam about automating this, but for now, we are pulling a report and sending a list of deactivations every Monday.
Step 1: Locate the list of returns
From the Drops Source Sheet, follow the link in tab one of the Aiden Returns Sheet: Aiden Returns
Step 2: Export the Latest Data
-
Export the updated Aiden Returns list from the dashboard, starting from where the previous export left off.
Import the new data into the Aiden Returns spreadsheet
Step 4: Confirm deactivation
-
Check to see if the credit has been issued (manually)
If so, step 5
If not, step 6
Step 5: Deduct Credit
- If the credit is redeemed but not yet used, deduct the credit
- If redeemed, make a note to deduct the credit from their return in AfterShip
- If they have redeemed the credit and already issued a refund, call it a loss
Step 6: Request Deactivation
If the customer has not yet redeemed the credit
Once the spreadsheet is updated, send the email list of the customers who have not yet redeemed the credit to Sam to deactivate