- modify the query for adding the filter of the store for the application connection in the head office
- check the modified query if the applied filter is OK
- as per checking, there is an error encountered, check and fix the error for successful extraction of data
- check the fixed query and test again, as per checking this is now OK
- generate a textfile for checking if it will continue and return a  correct value