Loyalty managment
Budget: ₹1,500 – ₹12,500 INR
Hello
I would like to create a macros based excel loyalty program in google sheets were i would like to onboard the customer using a unique identification number (and various other data) created centrally.
we have multiple branches so each branch will be given two excels , one for loyalty point accumulation and one for loyalty point redemption. From these both sheets the loyalty points will be added and deducted in the central consolidated sheet.
For better check we feel during the loyalty redemption in a particular branch there should be an otp verification procedure to redeem the points entered by the branch in the particular redemption sheet.
Our billing is through a separate software and we donot want to integrate the same, hence the redemption value will be entered by our particular consultant in the billing software.
I need the sheets to be available in google sheets so that my branches can operate real time. We need a proper otp solution during the redemption stage by the particular branch.
A basic template has been provided for your understanding.
Regards
Anish
I would like to create a macros based excel loyalty program in google sheets were i would like to onboard the customer using a unique identification number (and various other data) created centrally.
we have multiple branches so each branch will be given two excels , one for loyalty point accumulation and one for loyalty point redemption. From these both sheets the loyalty points will be added and deducted in the central consolidated sheet.
For better check we feel during the loyalty redemption in a particular branch there should be an otp verification procedure to redeem the points entered by the branch in the particular redemption sheet.
Our billing is through a separate software and we donot want to integrate the same, hence the redemption value will be entered by our particular consultant in the billing software.
I need the sheets to be available in google sheets so that my branches can operate real time. We need a proper otp solution during the redemption stage by the particular branch.
A basic template has been provided for your understanding.
Regards
Anish