Purpose: Returns processed by warehouse for EU/UK that need to be actioned on Shopify.


Requirements: 

  1. Open file and enable editing. 
  • Remove columns A-E , B-D , F-H

  • Once removed, add filter- Then filter from newest to oldest date (Z-A) 

2. Go to Box file under EU returns tab and copy last entry and search on your report received (Ctrl + F) If order comes up highlight it. 

  • Do the same for UK- Last entry search on recent file.- highlight it. 

3. You are going to copy everything from EU highlighted order and above. 

** If there are no orders above there are no returns to upload.

4. On the same returns report open Sheet1 and Paste these orders.

5. Select column A and CTRL + F to replace 

- 00422

- 00419

6. Once those front numbers have been removed you can add filter to separate orders per site (A-Z).

  • Copy All EU orders starting from line 1 and paste into Sheet 2.
  • Then add filter to return date to oldest to newest (A-Z)

7.  Now that you have all EU orders under Sheet 2 

- Copy EU orders (A-F) and paste into correct sheet on BOX returns file for EU.


8. Go back to returns report file

  • Delete all EU orders from Sheet 1.
  • Now that you are left with only UK orders, add filter to return date to oldest to newest (A-Z)
  • Copy UK orders (A-F) and paste into correct sheet on BOX returns file for UK.

9. On Box return file go to EU tab- search for duplicates.

  • Highlight column A - Select Conditional Formatting- Highlighted Cell Rules- Duplicate Values. LEAVE AS IS.


10. Repeat the same process for UK tab under Box returns file. LEAVE AS IS.


******FINAL- step to get total number of added returns.


  1. Go back to excel report- For each site you are going to get the total number of added returns by removing duplicates. 
  • Highlight line A on Sheet 2 where EU orders are- Select DATA- Remove duplicates- Continue with current selection- Remove duplicate- Ok

- The number you get is what has been added. DO the same process for UK.