Hi,
We are running a promotion and we would like to add 20 reward points to all our existing customer accounts as a bonus.
Is there any extension that can do this? I have searched but cannot find one. Or can someone suggest another way to achieve this.
Thanks for your help.
Code: Select all
$query = $this->db->query("SELECT * FROM " . DB_PREFIX . "customer");
foreach ($query->rows as $result) {
$this->db->query("INSERT INTO " . DB_PREFIX . "customer_reward SET customer_id = '" . (int)$result['customer_id'] . "', description = 'Happy holidays', points = '100', date_added = NOW()");
}
Who is online
Users browsing this forum: No registered users and 13 guests
