Custom refund import script
Summary of Changes: (The purpose of this table is to keep traceability and Product team to highlight the things that were changed into the scope, based on comments or discussions)
| Version | Date | Created / Updated | Notes |
|---|---|---|---|
| v1.0 | 10/11/2023 | Hristiyan | First publish |
| v1.1 | 26/07/2024 | Milen | Refund reason added |
We have received a request from the WAP team for a custom refund import script for River Island as there are many refunds issued daily, espacially in the upcoming busy period. We do not want to spend too much resources on this as we will have refund imports coming soon, so we have decided to use an already existing script - the Sportsdirect cancellation script, however we will need to do some minor changes. Please make sure the script is transferred from php56 to php82
The current script can be found in Git here - http://git.myhemisphere.com/hristian/sports-direct/-/tree/master/bin?ref_type=heads
As you can see, we have a script for SportsDirect and one for Arcade and they are identical. We want to use the same script and just replicate it for RiverIsland.
We will keep the same file structure so no changes on the file that is being consumed (it is a .csv file with information in it).
The changes we need to do is in the refund reasons mappings. For sd/arcade we are receiving numerours reasons which we map with the correct reasons. For RiverIsland we have agreed that we will receive only three reasons :
Out of stock Change of Mind
<v1.1> Initiated by MP </v1.1>
What we need to do is simply map those reasons when creating the refund in Hemi based on the marketplace :
| CSV File reason | Marketplace | Marketplace Reason | Internal Refund Reason | Comment |
|---|---|---|---|---|
| Out of stock | eBay | SELLER_CANCEL | Out of Stock | |
| Very | Out of stock | |||
| ASOS | [CANCELATION] Unable to Ship - Out of stock | |||
| Secret Sales | [REFUND] Out of stock | |||
| Change of Mind | eBay | BUYER_CANCEL | Change Of Mind | |
| Very | Decline | |||
| ASOS | [REFUND] Item returned | |||
| Secret Sales | [REFUND] Item returned | |||
| <v1.1> Initiated by MP </v1.1> | eBay | BUYER_CANCEL | Initiated by MP | |
| Very | Decline | |||
| ASOS | [REFUND] Item returned | |||
| Secret Sales | [REFUND] Item returned | |||
We also want every created refund to be with Process by MP = Yes
No other marketplaces are expected and no other changes are required for the script at the moment.
Example file :