Bulk Virgin Points Upload

Here is a step by step guide to successfully awarding Virgin Points to a customers Virgin Red account. 

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

2. Go to Telesales > Tasks > Bulk Uploader > Virgin Red Account > Bulk Virgin Points

The rest you can fill in in the task GUI

3. Click on 'Choose file' on details screen then upload the file - need to be named as bulk_virgin_points.csv

Add requested fields as picture above - only Reason Code is required and only VRP_MADJ is supported at the moment.

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.