How to Update RMA TRACKER
RMA TRACKER https://docs.google.com/spreadsheets/d/1kuO72fpvgpvnCEHDFEHjZIqQcQIMGixcFeDAzUJHw6Y/edit#gid=325023542
FDC PORTAL https://oms.fulfillment.com/ user [email protected] / goldink1234
1.Open the RMA Tracker spreadsheet in a new window. Make sure you are in the tab for the correct month, and locate the last entry in the RMA TRACKER
2.In a separate window or tab, login to the FDC portal as user [email protected] / goldink1234
3.Click Returns > Returns List
4.Set your date range based on the record you noted in step 1. You want to see new records since then. Click Apply.
5.Select any new returns that are under the reason CUSTOMER RETURNED and then click export.
6.Open the file in Excel and remove all columns EXCEPT
MERCHANT ORDER ID
UPDATED AT
DETAIL ITEM 1
DETAIL 1 RMA Number
7. Copy and paste these values into the RMA TRACKER for processing
RMA TRACKER https://docs.google.com/spreadsheets/d/1kuO72fpvgpvnCEHDFEHjZIqQcQIMGixcFeDAzUJHw6Y/edit#gid=325023542