Volusion sql code needed to export customer rewards points

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.

Compétences : SQL, Volusion

en voir plus : rewards volusion, id to code, export sql volusion, volusion export rewards points, Sql code, Sql 2012, volusion export sql, export sql, customer database needed, customer rewards, simple export, rewards code, simple sql, database volusion, needed customer database, sql volusion, volusion code, sql number, points rewards, code number, volusion sql, volusion export, simple sql database, code needed, export database

Concernant l'employeur :
( 0 commentaires ) Novato, United States

Nº du projet : #2381964

3 freelance font une offre moyenne de $30 pour ce travail


I can help you.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(2 Commentaires)

Ready to start....

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(18 Commentaires)

############# *********** PLEASE CHECK THE PM *********** #############

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(4 Commentaires)

I can do it.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(0 Commentaires)