Step 1. Login to your account through chempharmaassn.net/wp-login.php or any other login URL (e.g. the "Member Login" page in the navigation menu of the website.)

https://s3-us-west-2.amazonaws.com/secure.notion-static.com/775ba236-7721-47c5-9484-f085f217023e/Screen_Shot_2021-03-19_at_10.31.23_AM.png

Step 2. Navigate to the website admin dashboard by hovering over "ChemPharma Professional Association" in the admin navigation bar at the top of the screen, then clicking "Dashboard".

https://s3-us-west-2.amazonaws.com/secure.notion-static.com/0a0d2906-f46e-4f67-94ca-585a45a315ca/Screen_Shot_2021-03-19_at_10.32.36_AM.png

Step 3. Hover over Memberpress in the sidebar and click "Transactions".

https://s3-us-west-2.amazonaws.com/secure.notion-static.com/4196d885-dd9d-4ed6-bcc2-fc7c24e9824f/Screen_Shot_2021-05-28_at_11.29.08_AM.png

Step 4. Scroll all the way to the bottom of the screen and click "Export table as CSV."

https://s3-us-west-2.amazonaws.com/secure.notion-static.com/a15ddeca-4cc0-4484-9991-ecaf5b65d48c/Screen_Shot_2021-05-28_at_11.34.13_AM.png

This will produce a CSV file with all member transactions and from there you can sort by the expiration date or any other data. The column with the expiration date is called "expires_at". This CSV file also contains the members' names and other info. This table contains members whose expiration dates are in the future, so if you sort by the expiration date you can group all expired members at the top / bottom.