Need Reward Point Reset or Delete

m using nopCommerece 2.50 i gives a reward point to my coustomers for theier purchases
but when if i delete any order given by customer (due to some reason) but aloted reward point
cannot deduct back from their account. there is big problem pls give me some solution.

Mobile Doctor wrote:
You can add negative points (i.e. deduct) in admin>customer>edit (your customer account)>reward points tab

its good, if we need to delete whole history of reward point for any cutomer account then....

Mobile Doctor wrote:
For that you need to do some customization work

eadameg wrote:

Pls explain me in detail, i will do it (even edit database)

Mobile Doctor wrote:
I am afraid I can't help you because I don't have programing experience

Hi Mobile Doctor,

There are a number of options to delete the whole set of records for 1 customer.

If you are only doing it very rarely then just run some SQL on the DB table to delete all the records for that customer

eg

DELETE FROM RewardPointsHistory WHERE CustomerId = ###;

Haven't tested that you might have issues with the FK's and that's from Nop 2.3 DB

You could also delete a specific orders reward point history in a similar fashion.

I would warn against either as the customer may get upset. Better to make an adjustment and note why. That way when they contact you in 6 months time asking where their reward points are, you know why they are not there.

HTH

Dave

daveb wrote:

Thanks Daveb, U spent valuable time for me. as u wrote when customer contact you in 6 months time asking where their reward points are, you know why they are not there.

its ok,  but u think order placed by customer deleteed any time by admin even pending, processing  or  Compeleted.
so why the reward point delete option think big issue.

I know in Nop 1.7 there are settings as to when reward points are allocated eg when order is completed / paid etc
and when they are removed eg cancelled.

Try playing around with those? cant imagine they have been removed don't have 2.5 set up in front of me to test.

HTH

eadameg wrote:

this is manual work to negative points. on the other way when order is canceled, given reward point also deducted. so why when delete order it must reward point also deleted linked with order.