gillianmccrostie

Jan, many thanks for this. I did replace the existing code with what you wrote. It seemed to have no positive or negative affect regarding streaming customers to a specific pricing tier at account creation. Although I have begun studying php, it is going to be awhile before I have the know-how and experience to create code for this. I think what may work best for now is to build a second site for USA customers and then manually moderate both USA and Canadian wholsale customers. Thanks for your time and the assist! I'll keep studying! Cheers, Gillian

Jan, thanks so much. I will back everything up and give it a try. I am beginning my php classes this weekend - at Sam's and another site another member suggested. I'm learning but not fast enough! I'm looking forward to it as the more I learn about php, the more I want to learn. A bit addictive, isn't it - as there is always another problem to want to solve. Thanks so much! Gillian

Auto-Assigning new accounts to customer groups Writing custom code to direct new accounts to appropriate SPPC tiers: Has anyone tried writing code for special pricing to stream customers directly from account creation to their customer group without manual moderation in order that customers could view the appropriate pricing tier during their initial visit? I understand from Jan Z that this is possible. (Thanks for telling me I was in the wrong list, Jan! :thumbsup:) Is the code below the right area in create_account.php where I need to add custom coding? Anyone? // BOF Separate Pricing Per Customer// register SPPC session variables for the new customer// if there is code above that puts new customers directly into another customer group (default is retail)// then the below code need not be changed, it uses the newly inserted customer group $check_customer_group_info = tep_db_query("select c.customers_group_id, cg.customers_group_show_tax, cg.customers_group_tax_exempt, cg.group_specific_taxes_exempt from " . TABLE_CUSTOMERS . " c left join " . TABLE_CUSTOMERS_GROUPS . " cg using(customers_group_id) where c.customers_id = '" . $customer_id . "'"); $customer_group_info = tep_db_fetch_array($check_customer_group_info); $sppc_customer_group_id = $customer_group_info['customers_group_id']; $sppc_customer_group_show_tax = (int)$customer_group_info['customers_group_show_tax']; $sppc_customer_group_tax_exempt = (int)$customer_group_info['customers_group_tax_exempt']; $sppc_customer_specific_taxes_exempt = ''; if (tep_not_null($customer_group_info['group_specific_taxes_exempt'])) { $sppc_customer_specific_taxes_exempt = $customer_group_info['group_specific_taxes_exempt']; Is it possible to direct new accounts based on the information they enter in customer details for 'country' and 'tax number' Our four customer groups are: Canada Retail, Canada Wholesale, USA Retail, USA Wholesale. Currently when the customer creates an account they are directed to the default pricing tier - Canada Retail We just put our store up about2 weeks ago and I don't yet know how to write php - but I'm learning fast as I can! :'( Any help, direction, re-direction, pointers, advice would be most welcome. Cheers, Gillian

Can someone help please? :blush: I keep trying to post this to the Special Pricing thread to post the topic below. What am I doing wrong? I open that thread, go the most recent page and hit 'new topic'. Ah.... it just occured to me, I should hit 'reply' instead. Thanks for your patience... If there is someone who can remove this topic from General Contributions, I'd be most grateful. I'll try the SPPC thread again... Gillian _______________________________________ Has anyone tried writing code for special pricing to stream customers directly from account creation to their customer group without manual moderation in order that customers could view the appropriate pricing tier during their initial visit? I understand from Jan Z that this is possible. (Thanks for telling me I was in the wrong list, Jan! :thumbsup:) Is the code below the right area in create_account.php where I need to add csutom coding? Anyone? // BOF Separate Pricing Per Customer// register SPPC session variables for the new customer// if there is code above that puts new customers directly into another customer group (default is retail)// then the below code need not be changed, it uses the newly inserted customer group $check_customer_group_info = tep_db_query("select c.customers_group_id, cg.customers_group_show_tax, cg.customers_group_tax_exempt, cg.group_specific_taxes_exempt from " . TABLE_CUSTOMERS . " c left join " . TABLE_CUSTOMERS_GROUPS . " cg using(customers_group_id) where c.customers_id = '" . $customer_id . "'"); $customer_group_info = tep_db_fetch_array($check_customer_group_info); $sppc_customer_group_id = $customer_group_info['customers_group_id']; $sppc_customer_group_show_tax = (int)$customer_group_info['customers_group_show_tax']; $sppc_customer_group_tax_exempt = (int)$customer_group_info['customers_group_tax_exempt']; $sppc_customer_specific_taxes_exempt = ''; if (tep_not_null($customer_group_info['group_specific_taxes_exempt'])) { $sppc_customer_specific_taxes_exempt = $customer_group_info['group_specific_taxes_exempt']; Is it possible to direct new accounts based on the information they enter in customer details for 'country' and 'tax number' Our four customer groups are: Canada Retail, Canada Wholesale, USA Retail, USA Wholesale. We just put our store up about2 weeks ago and I don't yet know how to write php - but I'm learning fast as I can! :'( Any help, direction, re-direction, pointers, advice would be most welcome. Cheers, Gillian

Whoops! I keep trying to put this in the SPPC thread and keep ending up in General Contributions. Is there away of me erasing this? I will try to copy all the SPPC thread. Cheers, Gillian Has anyone tried writing code for special pricing to stream customers directly from account creation to their customer group without manual moderation in order that customers could view the appropriate pricing tier during their initial visit? I understand from Jan Z that this is possible. (Thanks for telling me I was in the wrong list, Jan! :thumbsup:) Is the code below the right area in create_account.php where I need to add csutom coding? Anyone? // BOF Separate Pricing Per Customer// register SPPC session variables for the new customer// if there is code above that puts new customers directly into another customer group (default is retail)// then the below code need not be changed, it uses the newly inserted customer group $check_customer_group_info = tep_db_query("select c.customers_group_id, cg.customers_group_show_tax, cg.customers_group_tax_exempt, cg.group_specific_taxes_exempt from " . TABLE_CUSTOMERS . " c left join " . TABLE_CUSTOMERS_GROUPS . " cg using(customers_group_id) where c.customers_id = '" . $customer_id . "'"); $customer_group_info = tep_db_fetch_array($check_customer_group_info); $sppc_customer_group_id = $customer_group_info['customers_group_id']; $sppc_customer_group_show_tax = (int)$customer_group_info['customers_group_show_tax']; $sppc_customer_group_tax_exempt = (int)$customer_group_info['customers_group_tax_exempt']; $sppc_customer_specific_taxes_exempt = ''; if (tep_not_null($customer_group_info['group_specific_taxes_exempt'])) { $sppc_customer_specific_taxes_exempt = $customer_group_info['group_specific_taxes_exempt']; Is it possible to direct new accounts based on the information they enter in customer details for 'country' and 'tax number' Our four customer groups are: Canada Retail, Canada Wholesale, USA Retail, USA Wholesale. We just put our store up about2 weeks ago and I don't yet know how to write php - but I'm learning fast as I can! :'( Any help, direction, re-direction, pointers, advice would be most welcome. Cheers, Gillian

Sorry about that. It appears I need to learn how to add code to emails as well. It seems the text didn't wrap. Sharp learning curve on everything... Gillian

Do you mean that I could have code written that would stream someone into the 'Canadian wholesale' group based, e.g., on the country and tax number provided? We are dealing with two countries and retail and wholesale for each. I was just looking at the code in create_account'php? (The comments make it interesting to read! Is this where I would need to have code added? I am sure one of the tech guys at my hosting company will do this for me but I am asking now, just because I am interested and trying to learn. If this isn't an appropriate request, please disregard. Cheers, Gillian // BOF Separate Pricing Per Customer // register SPPC session variables for the new customer // if there is code above that puts new customers directly into another customer group (default is retail) // then the below code need not be changed, it uses the newly inserted customer group $check_customer_group_info = tep_db_query("select c.customers_group_id, cg.customers_group_show_tax, cg.customers_group_tax_exempt, cg.group_specific_taxes_exempt from " . TABLE_CUSTOMERS . " c left join " . TABLE_CUSTOMERS_GROUPS . " cg using(customers_group_id) where c.customers_id = '" . $customer_id . "'"); $customer_group_info = tep_db_fetch_array($check_customer_group_info); $sppc_customer_group_id = $customer_group_info['customers_group_id']; $sppc_customer_group_show_tax = (int)$customer_group_info['customers_group_show_tax']; $sppc_customer_group_tax_exempt = (int)$customer_group_info['customers_group_tax_exempt']; $sppc_customer_specific_taxes_exempt = ''; if (tep_not_null($customer_group_info['group_specific_taxes_exempt'])) { $sppc_customer_specific_taxes_exempt = $customer_group_info['group_specific_taxes_exempt'];

Hi folks, I have been looking through past posts in General Contribution Support to see if customers can be auto-assigned to their appropriate customer group. We installed special pricing last week (we love this contribution!) and although I realize customers can be easily assigned manually AFTER account creation, is this the only method? Can a customer be streamed directly from account creation to their customer group without manual moderation in order to see the appropriate pricing tier during their initial visit? Thanks very much! Cheers, Gillian