Move customers automatically to defined pricing group after first purchase

[mybaby]

Hi, firstly i'd like to thank all the contributors for their efforts over the years. I cannot tell you how many times i have used this forum to find the answers i was looking for. Thank you.

But, I have been searching for sometime now and unable to find a solution to something i need. I can see how you can add 'New Users' to 'Group Pricing' automatically, but i want to add them after they make their first purchase. Instead of installing a Reward Points module to give Returning customers a discount, i'd rather use this.

Perhaps an SQL update on the Email Order Confirmation. Or when you update an order from 'Pending' to 'Shipped'?

Any assistance would be greatly appreciated. p.s my php is lousy!

Thank you

[Ajeh]

Do you want this to happen when the Order is placed?

[mybaby]

Yes, after the order is placed an SQL statement will UPDATE the group_pricing to '2' or whatever number you wish.

Thank you

[Ajeh]

NOTE: If there is any reason that you do not ALWAYS what to update the Customer to Group ID (customers_group_pricing) 2, you will need to add additional limits ...

Edit the file:
/includes/classes/order.php

and around line 645 add the code in RED where 2 is the customers_group_pricing you want to change the customer to be in:

    zen_db_perform(TABLE_ORDERS, $sql_data_array);

// bof: set customer group to 2
   $update_customers_group_sql = "update " . TABLE_CUSTOMERS . " SET customers_group_pricing = '2' WHERE customers_id = '" . $_SESSION['customer_id'] . "'";
   $db->Execute($update_customers_group_sql);
// eof: set customer group to 2

    $insert_id = $db->Insert_ID();

[crystal11]

Yes, upon login. Also, I'd like to be able to offer it as a special and discontinue. thank you.

[Ajeh]

So you want all current customers to be in this group and new customers to automatically be added to this group and then be able to set the group discount amount and whether or not is is available at any time correct?