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
...
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:
Code Block | ||||
---|---|---|---|---|
| ||||
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.
The rest you can fill in in the task GUI
2. Go to Telesales > Tasks > Account Bulk Update Uploader > 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
Add requested fields as picture above - only Reason Code is required and only VRP_MAD is supported at the moment.
4. Select the correct file and then click 'open'.
...