zpupster
-
Posts
370 -
Joined
-
Last visited
Posts posted by zpupster
-
-
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.
-
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.');
-
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; } } ?>
-
looked at this one Free Shipping Per Product_1_2 this does not fit for us.
-
I tried Separate Shipping Per Product. but it did not work for me
-
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
-
example given:
model 1--0.00 plus ship wt 3
model 2--10.00 plus ship wt 5
model 3--20.00 plus ship wt 12
how to get the shipping weight to add when going through checkout
-
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
-
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
-
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.
-
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??
-
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.
-
the suggestions did not seem to work i am deleting and reinstalling the database and site backups
thanks
-
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??
-
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.
-
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
-
we are switching to bootstrap, just thought i would give it a try since we are still testing.
if no one answers i will install HeaderTags_SEO_V_3.2.7.
-
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
-
thanks Bob and Jack
-
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.
-
hello,
has anyone seen an addon that formats the telephone numbers from the customers database so that when they are called are displayed as (555)555-5555 ?
i have been googling and searching for a while now and have not found an answer
-
the iframe on the right that contains the product description edit view is the unsecured(http).
-
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.
-
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.
New UPS XML Shipping Module available
in General Add-Ons Support
Posted
Thank You Jim,
this worked like a charm,
the request freight quote still appears for packages under the weight set.
is there a line i could add to stop the freight quote appearing for weights under weight set to turn off UPS.
Craig