Here is a step by step guide to successfully awarding Virgin Points to a customers Virgin Red account.
Cancellation (VRP-CAN) of Virgin points is not supported via this bulk process.
1.Firstly create the csv spreadsheet and save it using this template bulk_virgin_points.csv
a. The file must contain text only
b. You must enter the customer numbers in
c. You must enter the amount of Virgin points you wish to give in amounts.
d. You must select a store either vwshop or dmshop
e. You need to specify reason for customer account entry - this can be found in DB at the moment it is VRP-ORD, VRP-MADJ:
select id, name from account_type_entry_type where account_type_id = (select id from account_type where account_type.name = 'Virgin Red');
f. You need to specify reason_code that corresponding reason - please use above SQL to find data.
g. You can specified reference order if you wish - this is required for VRP-ORD type account entry.
h. You can specify description.
2. Go to Telesales > Tasks > Account Bulk Update > Virgin Red Account > Bulk Virgin Points
3. Click on 'Choose file' on details screen then upload the file - need to be named as bulk_virgin_points.csv
4. Select the correct file and then click 'open'.
6. Click 'execute task'
7. To check the status click 'Jobs' if the option to click it isn't there then refresh the page.
8. You then click 'Details' and then 'Get report' on the job. If the job is showing as 'unknown' then keep refreshing the page because this means the job is still running
9. This will then load the job report which will tell you weather or not you were successful in adding/removing balance. Alternatively if it has failed to add/remove balance then it will also show you this and give you a reason why.
10.Some common failures you will see are "Customer not found" this will appear when either the customer account doesn't exist. You will also get a failure if you try to minus from an account that has no balance because it can't go lower than zero.