I need a simple sql code for Volusion to export the total number of myrewards points for each customer. This export would consist of 2 columns: the "customer ID" and the current # of myrewards points, for our whole customer database.
Please note: This is not a regular sql export from Volusion. The "customer rewards points" in the Volusion software is a specific piece of data that is very hard to find, unlike regular data that you can simply pull from one of their tables. The rewards points are not included in any tables that are publicly available. Volusion customer service claims that "you cannot export rewards points," but that being said, they do not offer any assistance with sql so it is unlikely they would know how anyway.
Rewards points only show up in one location on the Volusion back end (see attached screen shot). They show up on the Customer Management page under Special Privileges. They are not on the gift certificate table or the customer table. I do not know how Volusion is generating them but they do show up on this screen so they must exist SOMEWHERE.
Please do not bid on this project unless you have done it before. I want someone with specific experience writing a script or sql code to export "VOLUSION CUSTOMER REWARDS POINTS" and not any other data from Volusion.