Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

zpupster

Members
  • Posts

    370
  • Joined

  • Last visited

Posts posted by zpupster

  1. hello support,

     

    i am using oscommerce 2.3.4 gold, UPSXML_v1_5 add on.  we use ups exclusively.

     

    this problem(over 150 lbs) has been discussed but i did not see a way to solve it--for our needs.

     

    i saw people complaining they are getting an error over 150 lbs,

     

    we do not receive an error it just breaks up into packages,, which is nice.\

     

    ultimately, we would like to have it not break into packages.

     

    When it reaches a single item weighing over 150, we would instruct our customers to call to our brick and mortar to get the shipping charges.

     

    i installed an addon Request freight quote.

     

     

    so my problem is how to stop it breaking it up into packages and turn off ups shipping options when it is over 150.

     

    see attached for my admin>configuration> shipping/packaging.


     

    post-279530-0-25091900-1493571315_thumb.jpg

  2. ok picking this back up.

     

    i added this key:

    'MODULE_XTR_SHIPPING_FREEAMOUNT_ZONE'

    i added a tb_db_query adding this to db in install

    tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) values ('Xtreme no free shipping', 'MODULE_XTR_SHIPPING_FREEAMOUNT_ZONE', 'True', 'Do you want to offer Xtreme free shipping?', '6', '7', 'tep_cfg_select_option(array(\'True\', \'False\'), ', now())");

    and this is my written function:

     

    function check() {
          if (!isset($this->_check)) {
            $check_query = tep_db_query("select category_id from " . TABLE_CONFIGURATION . " where category_id >188 
    then 'MODULE_XTR_SHIPPING_FREEAMOUNT_ZONE'");
            $this->_check = tep_db_num_rows($check_query);
          }
          return $this->_check;
        }

    i think this function statement is not right --what i am trying to ask the statement to do is--

    if the category id is greater than 188 ( and less than TBD) offer no free shipping 

     

    from includes>languages>modules>shipping> freeamount.php

    define('MODULE_XTR_SHIPPING_FREEAMOUNT_ZONE', 'We Offer No Free Shipping For Xtr Products.');
  3. below is the free amount -free shipping module I use

     

    1) i am not sure if i have to query the db for the category ids

    2)if i do i will and write some statement similar to this

     

      if ($category_id== NUMBER_ OF_CATEGORY_I_DO_NOT_ WANT_FREE_SHIPPING _ON)
         {
    then (NUMBER_ OF_CATEGORY_I_DO_NOT_ WANT_FREE_SHIPPING _ON== 'False')

    3) no idea where to place it in this code.

    /*
      $Id$ freeamount.php 2
    
    
      The Exchange Project - Community Made Shopping!
      http://www.theexchangeproject.org
    
    
      Copyright (c) 2003
    
    
      Released under the GNU General Public License
    
    
      ----------------------------------------------
      ane - 06/02/02 - modified freecount.php to
      allow for freeshipping on minimum order amount
      originally written by dwatkins 1/24/02
      Modified BearHappy 09/04/04
      ----------------------------------------------
    */
    
    
      class freeamount {
        var $code, $title, $description, $icon, $enabled;
    
    
    // class constructor
        function freeamount() {
          global $order, $customer;
    
    
          $this->code = 'freeamount';
          $this->title = MODULE_SHIPPING_FREEAMOUNT_TEXT_TITLE;
          $this->description = MODULE_SHIPPING_FREEAMOUNT_TEXT_DESCRIPTION;
          $this->sort_order = MODULE_SHIPPING_FREEAMOUNT_SORT_ORDER;
          $this->icon ='';
          $this->enabled = ((MODULE_SHIPPING_FREEAMOUNT_STATUS == 'True') ? true : false);
    
    
          if ( ($this->enabled == true) && ((int)MODULE_SHIPPING_FREEAMOUNT_ZONE > 0) ) {
    
    
            $check_flag = false;
            $check_query = tep_db_query("select zone_id, zone_country_id from " . TABLE_ZONES_TO_GEO_ZONES . " where geo_zone_id = '" . MODULE_SHIPPING_FREEAMOUNT_ZONE . "' and zone_country_id = '" . $order->delivery['country']['id'] . "' order by zone_id");
            $order_shipping_country = $order->delivery['country']['id'];
    
    
            while ($check = tep_db_fetch_array($check_query)) {
    
    
              if ($check['zone_id'] < 1) {
                $check_flag = true;
                break;
              } elseif ($check['zone_id'] == $order->delivery['zone_id']) {
    //          } elseif ($check['zone_country_id'] == $order->delivery['country']['id']) {
                $check_flag = true;
                break;
              }
            }
            if ($check_flag == false) {
              $this->enabled = false;
            }
         }
    }
    
    
    // class methods
        function quote($method = '') {
          global $order, $cart, $shipping_weight, $shipping_num_boxes;
    
    
          $dest_country = $order->delivery['country']['id'];
          $currency = $order->info['currency'];
          $get_total = false;
          $get_weight = false;
          $cart_total = $cart->show_total();
    
    
        // 2008-02-06 Joshwa
        // I rewrote this section that removes the value of any items in the card that are on
        // special because it did not take into account that items can have multiple quantities
        if (MODULE_SHIPPING_FREEAMOUNT_HIDE_SPECIALS == 'True') {
          if ($cart->count_contents() > 0) {
            $products = $cart->get_products();
            for ($i=0, $n=sizeof($products); $i<$n; $i++) {
              if ($special_price = tep_get_products_special_price($products[$i]['id'])) {
                $cart_total -= ($special_price * $products[$i]['quantity']);
              }
            }
          }
        }
        // End of modification by Joshwa
    
    
     if ($cart_total < MODULE_SHIPPING_FREEAMOUNT_AMOUNT)
     {
    if (MODULE_SHIPPING_FREEAMOUNT_DISPLAY == 'True')
      {
    $this->quotes['error'] = MODULE_SHIPPING_FREEAMOUNT_TEXT_ERROR;
      }
    $get_total = false;
      } else {
       $get_total = true;
      }
     $total_weight = $shipping_num_boxes * $shipping_weight;
          if ($total_weight > MODULE_SHIPPING_FREEAMOUNT_WEIGHT_MAX)
         {
    if (MODULE_SHIPPING_FREEAMOUNT_DISPLAY == 'True')
      {
           $this->quotes['error'] = MODULE_SHIPPING_FREEAMOUNT_TEXT_TO_HEIGHT;
      }
    $get_weight = false;
     } else {
      $get_weight = true;
     }
    
    
    if (($get_total == true && $get_weight == true))
    {
    $this->quotes = array('id' => $this->code,
    'module' => MODULE_SHIPPING_FREEAMOUNT_TEXT_TITLE,
    'methods' => array(array('id' => $this->code,
    'title' => MODULE_SHIPPING_FREEAMOUNT_TEXT_WAY,
    'cost' => MODULE_SHIPPING_FREEAMOUNT_COST)));
    }
    
    
    
    
     if (tep_not_null($this->icon)) $this->quotes['icon'] = tep_image($this->icon, $this->title);
    
    
     return $this->quotes;
    
    
    }
    
    
        function check() {
          if (!isset($this->_check)) {
            $check_query = tep_db_query("select configuration_value from " . TABLE_CONFIGURATION . " where configuration_key = 'MODULE_SHIPPING_FREEAMOUNT_STATUS'");
            $this->_check = tep_db_num_rows($check_query);
          }
          return $this->_check;
        }
    
    
        function install() {
          tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) values ('Enable Free Shipping with Minimum Purchase', 'MODULE_SHIPPING_FREEAMOUNT_STATUS', 'True', 'Do you want to offer minimum order free shipping?', '6', '7', 'tep_cfg_select_option(array(\'True\', \'False\'), ', now())");
          tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id,  sort_order, date_added) values ('Maximum Weight', 'MODULE_SHIPPING_FREEAMOUNT_WEIGHT_MAX', '10', 'What is the maximum weight you will ship?', '6', '8', now())");
          tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) values ('Enable Display', 'MODULE_SHIPPING_FREEAMOUNT_DISPLAY', 'True', 'Do you want to display text way if the minimum amount is not reached?', '6', '7', 'tep_cfg_select_option(array(\'True\', \'False\'), ', now())");
          tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id,  sort_order, date_added) values ('Minimum Cost', 'MODULE_SHIPPING_FREEAMOUNT_AMOUNT', '50.00', 'Minimum order amount purchased before shipping is free?', '6', '8', now())");
          tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id,  sort_order, set_function, date_added) values ('Disable for Specials', 'MODULE_SHIPPING_FREEAMOUNT_HIDE_SPECIALS', 'True', 'Do you want to disable free shipping for products on special?', '6', '7', 'tep_cfg_select_option(array(\'True\', \'False\'), ', now())");
          tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Sort Order', 'MODULE_SHIPPING_FREEAMOUNT_SORT_ORDER', '0', 'Sort order of display.', '6', '0', now())");
          tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function, date_added) values ('Shipping Zone', 'MODULE_SHIPPING_FREEAMOUNT_ZONE', '0', 'If a zone is selected, only enable this shipping method for that zone.', '6', '0', 'tep_get_zone_class_title', 'tep_cfg_pull_down_zone_classes(', now())");
       }
    
    
        function remove() {
          tep_db_query("delete from " . TABLE_CONFIGURATION . " where configuration_key in ('" . implode("', '", $this->keys()) . "')");
        }
    
    
       function keys() {
         $keys = array(
               'MODULE_SHIPPING_FREEAMOUNT_STATUS',
               'MODULE_SHIPPING_FREEAMOUNT_WEIGHT_MAX',
               'MODULE_SHIPPING_FREEAMOUNT_SORT_ORDER',
               'MODULE_SHIPPING_FREEAMOUNT_DISPLAY',
               'MODULE_SHIPPING_FREEAMOUNT_HIDE_SPECIALS',
               'MODULE_SHIPPING_FREEAMOUNT_AMOUNT',
               'MODULE_SHIPPING_FREEAMOUNT_ZONE'
               );
         return $keys;
       }
     }
    ?>
  4. Hello shipping support,

     

    currently using UPS shipping and freeamount shipping module on 2.3.4 BS.

     

    we have my free amount shipping set for free shipping over 500 dollars.

     

    we have a new category that  we can not offer free shipping for that category only.

     

    Can someone suggest an addon for this, 

     

     

    TY,

    Craig

  5. hello support,

     

    I am using Responsive OSCommerce 2.3.4, We started to use the product attributes.

     

    We are using  it for different model numbers , but the  models have different shipping weights,

     

    i have looked at a few of the add ons and most are for 2.2, and the one i found for 2.3 did not carry over the 

    weight with the model number but had the customer pick their shipping weight as an attribute.

     

     

    Could someone suggest an add on that would help me solve my problem.

     

    many thanks,

     

    Craig

  6. hello,

     

    I am using osc234 bootstrap and UPSXML_v1_5 on our website.

     

    everything has been working great.

     

    today i received errors when 3 customers ordered.

    UPSXML Rates Error: : experienced by customer with id 784 on 2016-01-20 16:11:24
    
    Error from cURL: Error [35]: error:1407742E:SSL routines:SSL23_GET_SERVER_HELLO:tlsv1 alert protocol version experienced by customer with id 784 on 2016-01-20 16:11:24

     i received an email from ups 

    Security Upgrade Required for UPS® Developer Kit APIs
    
    Action is Required
    
    UPS is in the process of upgrading communication security protocols for all web-based applications, including UPS Developer Kit Application Programming Interfaces (APIs), which are used to integrate UPS functionality into your website and applications.
    
    Effective January 26, 2016, the UPS test environment will require the TLS 1.2 security protocol, and will be available for your system testing.
    
    Effective May 31, 2016, UPS will require the TLS 1.2 security protocol in production. After that date, any communication requests submitted to UPS using older protocols (TLS 1.1 or earlier) will fail.
    
    NOTE: From January 19 through May 31, 2016, you may see intermittent failures for any non-compliant transactions.
    
    Please contact your company's IT department or your development team to ensure that any security protocols currently used meet the TLS 1.2 requirement. If you have Java enabled, you must be using version 1.7 or higher to use TLS 1.2. 

    as for my troubleshooting i double checked my ssl certificate and everything is fine.

     

    i need some suggestions,

     

    thanks

  7. hello usu5 support,

     

    Ultimate Seo Urls 5 by FWR

    is this recommended for bootstrap.

     

    could someone post what a seo url is supposed to look like so i can check it with what is coming up with mine. like this??

     

    site.com/prodcut-9404-digital-cellphone-7005p-2121.html

     

    thanks.

  8. this works

    echo tep_draw_textarea_field('products_description[' . $languages[$i]['id'] . ']', 'soft', '110', '15', (isset($products_description[$languages[$i]['id']]) ? stripslashes($products_description[$languages[$i]['id']]) : tep_get_products_description($pInfo->products_id, $languages[$i]['id'])), 'id = "products_description[' . $languages[$i]['id'] . ']" class="ckeditor"');

    thanks Jack,

    I'm curious why you would use a version that is not supported, at least by me, and probably won't be updated? Especially since my versions support the BS version.

    could you elaborate, the header tag version that i found was the latest,(i believe)

     

    are you talking about osc234 -- Responsive-osCommerce-master??

  9. installed \HeaderTags_SEO_V_3.3.3_1

    on

    osc234 -- Responsive-osCommerce-master

     

     

    everything seems ok with one pesky problem so far

     

    it knocked out my ckeditor

     

    in the admin .config.HeaderTagsSeo

     enabling CKEditor it works for categories desc but not for for products desc.

     

    here is the error

     

    Products Description:

     

     Fatal error: Call to undefined function tep_draw_textarea_ckeditor() in /home/site/public_html/bs/admin/categories.php on line 636

     

    from admin>includes>template_top.php.i believe the problem is here.

    //this code block is optional - if you want the ability to turn the editor on and off in admin add this - its not necessary and is not needed to make the editor work
    /*** Begin Header Tags SEO ***/
    ?>
    <link rel="stylesheet" type="text/css" href="includes/headertags_seo_styles.css">
    <?php
    switch (HEADER_TAGS_ENABLE_HTML_EDITOR) {
       case 'CKEditor':
         echo '<script type="text/javascript" src="ext/ckeditor/ckeditor.js"></script>';
        echo '<script type="text/javascript" src="ext/ckeditor/adapters/jquery.js"></script>';
       break;
    
    
       case 'FCKEditor':
       break;
             
       case 'TinyMCE':
         if (HEADER_TAGS_ENABLE_EDITOR_CATEGORIES == 'true'   || 
             HEADER_TAGS_ENABLE_EDITOR_PRODUCTS == 'true'     ||
             HEADER_TAGS_ENABLE_EDITOR_LISTING_TEXT == 'true' ||
             HEADER_TAGS_ENABLE_EDITOR_SUB_TEXT == 'true'      
            )
         {  
           if ($action == 'new_product' || $action == 'new_category' || $action == 'edit_category') { // No need to put JS on all pages.
             $languages = tep_get_languages(); // Get all languages
           // Build list of textareas to convert
             $str = '';
             for ($i = 0, $n = sizeof($languages); $i < $n; $i++) {
               if (HEADER_TAGS_ENABLE_EDITOR_CATEGORIES == 'true') $str .= "categories_htc_description[".$languages[$i]['id']."],";
               if (HEADER_TAGS_ENABLE_EDITOR_PRODUCTS == 'true') $str .= "products_description[".$languages[$i]['id']."],";
               if (HEADER_TAGS_ENABLE_EDITOR_LISTING_TEXT == 'true') $str .= "products_head_listing_text[".$languages[$i]['id']."],";
               if (HEADER_TAGS_ENABLE_EDITOR_SUB_TEXT == 'true') $str .= "products_head_sub_text[".$languages[$i]['id']."],";
             }  //end for each language
             $mce_str = rtrim ($str,","); // Removed the last comma from the string.
           // You can add more textareas to convert in the $str, be careful that they are all separated by a comma.
             echo '<script language="javascript" type="text/javascript" src="includes/javascript/tiny_mce/tiny_mce.js"></script>';
             include "includes/javascript/tiny_mce/general.php";
           } 
         }
       break;
    
    
       default: break; 
    }     
    /*** End Header Tags SEO ***/
    if (!defined('USE_CKEDITOR_ADMIN_TEXTAREA')) {
    tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, set_function) values ('', 'Use CKEditor', 'USE_CKEDITOR_ADMIN_TEXTAREA','true','Use CKEditor for WYSIWYG editing of textarea fields in admin',1,99,now(),'tep_cfg_select_option(array(\'true\', \'false\'),' )");
    define ('USE_CKEDITOR_ADMIN_TEXTAREA','true');
    }
    if (USE_CKEDITOR_ADMIN_TEXTAREA == "true") {
    ?>
    
    
    
    
    <script type="text/javascript" src="<?php echo tep_href_link('ext/ckeditor/ckeditor.js'); ?>"></script>
    <!-- If you would rather use ckeditor.js file from a CDN uncomment the line below and comment the line above - if the version number has changed remember to change the version number - you'll actually find the line of code on the ck editor web site for your version -->
    <!-- <script src="//cdn.ckeditor.com/4.4.4/full/ckeditor.js"></script> -->
    <script type="text/javascript" src="<?php echo tep_href_link('ext/ckeditor/adapters/jquery.js'); ?>"></script>
    <script type="text/javascript">
    $(function() {
    var $editors = $('textarea');
    if ($editors.length) {
    $editors.each(function() {
    var editorID = $(this).attr("id");
    var instance = CKEDITOR.instances[editorID];
    if (instance) { CKEDITOR.remove(instance); }
    CKEDITOR.replace(editorID);
    });
    }
    });
    </script>
    
    
    <?php
    // the closing brace here forms part of the php code block above
    } //if you decide to leave out the php code block above then comment or remove this too
    ?>
    </head>

    I tried removing the header tag edits,

    i tried removing the original ckeditor code

     

    i changed the original directory and added second line in

    echo '<script type="text/javascript" src="ext/ckeditor/ckeditor.js"></script>';
        echo '<script type="text/javascript" src="ext/ckeditor/adapters/jquery.js"></script>';

      i have tried quite a few things. i need someone else to see what i am missing.

  10. By the way, in case you are not aware of it, you are installing an older version. I suggest installing the latest one since it has bug fixes in it.
    

    HeaderTags_SEO_V_3.3.3_1 

     

    this was the latest that i saw. that is what i used. from a 234 install the version checker said this was the latest.

     

    do you have a link to another one??

  11. i am trying to install HeaderTags_SEO_V_3.3.3_1 on BS Gold.

     

    everything seemed to go fine in the install, 

     

     

    admin/includes/database_tables.php

    and includes/database_tables

     

    have:

        /*** Begin Header Tags SEO ***/
      define('TABLE_HEADERTAGS', 'headertags');
      define('TABLE_HEADERTAGS_CACHE', 'headertags_cache');
      define('TABLE_HEADERTAGS_DEFAULT', 'headertags_default');
      define('TABLE_HEADERTAGS_KEYWORDS', 'headertags_keywords');
      define('TABLE_HEADERTAGS_SEARCH', 'headertags_search');
      define('TABLE_HEADERTAGS_SILO', 'headertags_silo');
      define('TABLE_HEADERTAGS_SOCIAL', 'headertags_social');
      /*** End Header Tags SEO ***/

    i checked in the admin database tables, the table does exist and is converted to utf8_unicode_ci

     

    permissions are set on header_tags.php at 755 

    i ran the headertags_seo_update.php . i saw that this was recommended in another post.

     

     yet i am getting the error below on index.php

     

     

    1146 - Table 'site.TABLE_HEADERTAGS_DEFAULT' doesn't exist

    select * from TABLE_HEADERTAGS_DEFAULT where language_id = '1'

     

    thanks.

  12. hello support,

     

    this is for osc234

     

     i have searched the addons but no finding what i want.

     

    i am looking for an addon that is similar to amazon here

    roll over product thumbnail image on left and it changes the product picture in main window.

     

    or here at 6pm site click a product thumbnail image and it changes product pic in main image area.

     

    is there an add on like that at oscommerce??

     

    thanks

  13. hello,

     

    i presently have HeaderTags_SEO_V_3.2.7 by Jack.

     

    but we are changing to bootstrap.

     

    Does this addon --HeaderTags_SEO_V_3.2.7 --by burt,

     

    have a category description area?  where each category is able to have  a description  added to the page 

    from a text box provided in admin area.

     

     

    thanks

  14. this the function i used in invoice.php

     

    <?php
    function format_telephone($phone_number)
    {
        $cleaned = preg_replace('/[^[:digit:]]/', '', $phone_number);
        preg_match('/(\d{3})(\d{3})(\d{4})/', $cleaned, $matches);
        return "({$matches[1]}) {$matches[2]}-{$matches[3]}";
    }
    ?>

    called it here:

    <td class="main"><?php echo format_telephone($order->customer['telephone']); ?></td>

    this works,

     

    but should i put the function in a different area of oscommerce.  

  15. in chrome you can click the alert shield located on the right hand side of the address bar, and allow content.

     

    this will allow me to edit the product description, however

     

    the real time edit does not work.  that was a nifty feature. 

     

    thanks again, John, for a nice add on.

  16. yes. i tried divs instead of span.

     

    i think i tracked down part of the problem.

     

    from google chrome console.

    Mixed Content: The page at 'https://myiste.com/admin/aas.php?cPath=4' was loaded over HTTPS, but requested an insecure resource 'http://mysite.com/test-p-942.html?language=en'. This request has been blocked; the content must be served over HTTPS.

    when it loads in IE9, the warning popsup and asks if i should allow content. however in chrome it just does not load the iframe on right panel.

     

    from the warning you can see that the right panel is not secure(https), i am not sure how to fix that.

     

    but that is why the live edit is not working either, i assume.

     

    
    
×
×
  • Create New...