Jump to content


  • Content count

  • Joined

  • Last visited

Profile Information

  • Real Name
    Mary Brunton
  1. maryb

    TNT Australia Shipping Module

    Duh, thanks that worked mary
  2. maryb

    TNT Australia Shipping Module

    Hi I have installed TNT Australia Shipping based on postcode. It's working well except for orders over 100kg, where it calculates it to an amount that is less than at 99kg. Could this be a bug? Any idea how to fix it? Thanks mary
  3. maryb

    Seperate Pricing Per Customer v3.5

    Hi Jan I've probably done something wrong but it's not working automatically, ie, putting the customer in the correct group in admin automatically, they always in 'retail' (I have 2 groups 'retail' and 'asofia'). Here's the bits of code from create_account.php I've changed... line 30 $firstname = tep_db_prepare_input($HTTP_POST_VARS['firstname']); $lastname = tep_db_prepare_input($HTTP_POST_VARS['lastname']); if (ACCOUNT_DOB == 'true') $dob = tep_db_prepare_input($HTTP_POST_VARS['dob']); $email_address = tep_db_prepare_input($HTTP_POST_VARS['email_address']); $retail = tep_db_prepare_input($HTTP_POST_VARS['retail']); $asofia = tep_db_prepare_input($HTTP_POST_VARS['asofia']); line 241 // 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 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']; // EOF Separate Pricing Per Customer $customer_first_name = $firstname; $customer_default_address_id = $address_id; $customer_country_id = $country; $customer_zone_id = $zone_id; tep_session_register('customer_id'); tep_session_register('customer_first_name'); tep_session_register('customer_default_address_id'); tep_session_register('customer_country_id'); tep_session_register('customer_zone_id'); // BOF Separate Pricing Per Customer tep_session_register('sppc_customer_group_id'); tep_session_register('sppc_customer_group_show_tax'); tep_session_register('sppc_customer_group_tax_exempt'); // EOF Separate Pricing Per Customer line 284 // BOF Separate Pricing Per Customer: alert shop owner of account created by a company // if you would like to have an email when either a company name has been entered in // the appropriate field or a tax id number, or both then uncomment the next line and comment the default // setting: only email when a tax_id number has been given // if ( (ACCOUNT_COMPANY == 'true' && tep_not_null($company) ) || (ACCOUNT_COMPANY == 'true' && tep_not_null($company_tax_id) ) ) { /* if ( ACCOUNT_COMPANY == 'true' && tep_not_null($company_tax_id) ) { $alert_email_text = "Please note that " . $firstname . " " . $lastname . " of the company: " . $company . " has created an account."; tep_mail(STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS, 'Company account created', $alert_email_text, STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS); } */ if ( $_POST['request_cg'] != 'retail' ) { $alert_email_text = "Please note that " . $firstname . " " . $lastname . " has created an account and applied for a " . tep_db_prepare_input($_POST['request_cg']). " account."; $request_subject = tep_db_prepare_input($_POST['request_cg']). " account created"; tep_mail(STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS, $request_subject, $alert_email_text, STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS); } // EOF Separate Pricing Per Customer: alert shop owner of account created by a company line 424 <!-- BOF Separate Pricing Per Customer: drop-down menu for authorization request --> <tr> <td class="main"><?php define('ENTRY_REQUEST_CUSTOMER_GROUP', 'Are you a member of<br> ASOFIA, ASGA or ISP? '); echo ENTRY_REQUEST_CUSTOMER_GROUP; ?></td> <td class="main"><?php $request_cg_array[] = array('id' => 'retail', 'text' => 'not a member'); $request_cg_array[] = array('id' => 'asofia', 'text' => 'yes I am a member'); echo tep_draw_pull_down_menu('request_cg', $request_cg_array) ?></td> </tr> <!-- EOF Separate Pricing Per Customer: drop-down menu for authorization request --> My groups are called 'retail' and 'asofia' in admin. Any ideas about what's wrong? Thanks mary
  4. maryb

    Product Listing in Columns v2.0

    This contribution does it a better way http://www.oscommerce.com/community/contributions,4235 thanks spinball
  5. maryb

    Seperate Pricing Per Customer v3.5

    Hi, I've just installed SPPC. Don't know if this questions has been asked before without reading through all the 131 pages but... Is there any way to automate the allocating of customers to groups without having to do it manually in admin? Like, can they choose a group in create_account.php, and it automatically puts them in that group in Admin. I can check before I send out the goods whether they're entittled to the discount - not so worried about verifiy them before they shop. Thanks for your help