This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
admin:add_chargebacks_sheet [2025/06/22 13:29] 20.171.207.43 old revision restored (2025/05/22 07:25) |
admin:add_chargebacks_sheet [2025/06/22 13:52] (current) 20.171.207.43 old revision restored (2025/06/22 13:28) |
||
---|---|---|---|
Line 3: | Line 3: | ||
We need to update the CB sheet every day and let ADMIN Uknow when it is ready for processing. They will follow the instructions from our wiki to blacklist the customers and cancel their subs. | We need to update the CB sheet every day and let ADMIN Uknow when it is ready for processing. They will follow the instructions from our wiki to blacklist the customers and cancel their subs. | ||
- | **CB Tracker**- https:// | + | **CB Tracker**- https:// |
- | **CB911 Login** - https:// | + | **CB911 Login** - https:// |
To update the CB Sheet: | To update the CB Sheet: | ||
Line 26: | Line 26: | ||
7. Open the file in Excel. You will need to expand the Post Date and Trans Date columns to prevent the values ` from appearing as ######. | 7. Open the file in Excel. You will need to expand the Post Date and Trans Date columns to prevent the values ` from appearing as ######. | ||
- | + | 8. Select the Chargeback ID column (column A) and click Sort & Filter > Sort Smallest to Largest. | |
- | 8. Select the Chargeback ID column (column A) and click Sort & Filter > Sort Smallest to Largest. | + | |
- | + | ||
9. Match the last Chargeback ID from the CB Tracker sheet to the record in Excel. Delete that row and prior ones so we are only left with the new records. | 9. Match the last Chargeback ID from the CB Tracker sheet to the record in Excel. Delete that row and prior ones so we are only left with the new records. | ||
- | 10. Remove | + | 10. Highlight the remaining data, except the headers on row 1, and CTRL-C to copy. |
{{: | {{: |