minionsweb

We got that too. A day late and a dollar short don't you think? To throw a curve in this.... Is anyone using USPS methods and using this? usps shipping labels contrib If they can work together, it would make our life a little easier here.

Is any one else still experiencing spotty connectivity with USPS? I have had some orders come thru, but I have also been adding a Credit Card contrib. So I wonder if my edits here and there are honking things up... USPS was working just a bit ago, then I edited a value to report differently. Of course the test run yielded no USPS connection again...

Does anyone know where to check the api lookup values so we can figure out what the issue may be?

Yep, we are hosed at the moment too. Folks are using flat rate as an over-ride, but it will not work for my store. Figures, since we sent out 25000 emails last night announcing a sale....

Currently USPS is having shipping calc issues, it may not be associated with your install today if you have previously resolved the issue.

Hmmm, You should see if your hosting provider has performed any system updates, especially on the php or mysql deployments. Did you apply any other contrib recently?

Did you request to be put to the live USPS server, and have your confirmation code?

Did you revert the sql and then re-apply? Or did you just run the statements again, without backing them out? Big differences between revert and apply and just overlaying.

Also all references still in my usps.php that cover international (some have been edited out since I limit the selections) includes\modules\shipping\usps.php(52): 'Express' => 'Express Mail International (EMS)', includes\modules\shipping\usps.php(53): 'Express FlatEnv' => 'Express Mail International (EMS) Flat Rate Envelope', includes\modules\shipping\usps.php(54): 'Priority Intl' => 'Priority Mail International', includes\modules\shipping\usps.php(55): 'Priority Intl FlatEnv' => 'Priority Mail International Flat Rate Envelope', includes\modules\shipping\usps.php(56): 'Priority Intl FlatBox' => 'Priority Mail International Flat Rate Box', includes\modules\shipping\usps.php(57): 'FirstClass Intl' => 'First-Class Mail International'); includes\modules\shipping\usps.php(155): 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 ('Int\'l Shipping Methods', 'MODULE_SHIPPING_USPS_TYPES_INTL', 'GXG, GXG Non-Doc Rect, GXG Non-Doc Non-Rect, Express, Express FlatEnv, Priority Intl, Priority Intl FlatEnv, Priority Intl FlatBox, FirstClass Intl', 'Select the international services to be offered:', '6', '15', 'tep_cfg_select_multioption(array(\'GXG\', \'GXG Non-Doc Rect\', \'GXG Non-Doc Non-Rect\', \'Express\', \'Express FlatEnv\', \'Priority Intl\', \'Priority Intl FlatEnv\', \'Priority Intl FlatBox\', \'FirstClass Intl\'),', now())");

Earlier in this thread are the replacement names used by USPS, and where to change them in the contrib. basically the case was the change, but some were labelled a little differently. includes\modules\shipping\usps.php(47): $this->types = array('EXPRESS' => 'Express Mail', 'FIRST CLASS' => 'First-Class Mail', 'PRIORITY' => 'Priority Mail', 'PARCEL' => 'Parcel', 'BPM' => 'Bound Printed Material', 'Library' => 'Library', 'Media' => 'Media Mail'); and includes\modules\shipping\usps.php(154): 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 ('Domestic Shipping Methods', 'MODULE_SHIPPING_USPS_TYPES', 'EXPRESS, PRIORITY, FIRST CLASS, PARCEL, BPM, Library, Media,', 'Select the domestic services to be offered:', '6', '14', 'tep_cfg_select_multioption(array(\'EXPRESS\', \'PRIORITY\', \'FIRST CLASS\', \'PARCEL\',\'BPM\',\'Library\',\'Media\'), ', now())"); And includes\modules\shipping\usps.php(155): 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 ('Int\'l Shipping Methods', 'MODULE_SHIPPING_USPS_TYPES_INTL', 'GXG, GXG Non-Doc Rect, GXG Non-Doc Non-Rect, Express, Express FlatEnv, Priority Intl, Priority Intl FlatEnv, Priority Intl FlatBox, FirstClass Intl', 'Select the international services to be offered:', '6', '15', 'tep_cfg_select_multioption(array(\'GXG\', \'GXG Non-Doc Rect\', \'GXG Non-Doc Non-Rect\', \'Express\', \'Express FlatEnv\', \'Priority Intl\', \'Priority Intl FlatEnv\', \'Priority Intl FlatBox\', \'FirstClass Intl\'),', now())"); Mind you this is edited to match up the code from v2.9.2 Do not drop this directly into your instance until you compare the structures and code to make sure it is compatible with your revision. Also, the line numbers may not match considering the extensive work that has been applied since build 2.9.2. I cannot suggest strongly enough that when updating and installing contribs you use a tool such as examdiff, or beyondcompare to look at the files you will be adding and updating compared to what already exists in your catalog. Of course you should always download and datestamp a backup before applying any new contrib. This is your safety net. Duplicate the back up to another directory to be your transitional copy that you perform edits on. I even keep a third testing version just in case. Additionally, you should always backup your database before executing any sql statements against your existing database. This will always permit you to roll back to a working revision. I hope this helps.

Nice to see there is support for this contrib. Wonder if this can be tagged as the support thread for it, as it seems to be making a lazurus... Here is where I am at, and maybe someone can shed some light on completing my update... In the Show sold out items contrib: http://addons.oscommerce.com/info/4884 I have merged the core Sold out items contrib, & out of stock/notify me when available function, to work with the QPBPP contrib: http://addons.oscommerce.com/info/1242 I see there is a new addition since I started my work...so I will also merge the SSO in reviews component when I get a chance. One thing I noticed, was when an item was in a category breakout page, it still showed as sold out, where I think showing out of stock/notify me when available is a better option (we go thru a lot of hot melt glue this time of year). I have the image working and you can select it. But it is added to, and the customer is taken to the cart...which it should not do. Additionally it is NOT added to the notifications page. Please note the change at lines 131-136 Here is the code as I have it: <?php /* $Id: product_listing.php,v 1.44 2003/06/09 22:49:59 hpdl Exp $ adapted for QPBPP v1.2.0 2006/12/23 osCommerce, Open Source E-Commerce Solutions [url="http://www.oscommerce.com"]http://www.oscommerce.com[/url] Copyright © 2003 osCommerce Released under the GNU General Public License */ $listing_split = new splitPageResults($listing_sql, MAX_DISPLAY_SEARCH_RESULTS, 'p.products_id'); if ( ($listing_split->number_of_rows > 0) && ( (PREV_NEXT_BAR_LOCATION == '1') || (PREV_NEXT_BAR_LOCATION == '3') ) ) { ?> <table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <td class="smallText"><?php echo $listing_split->display_count(TEXT_DISPLAY_NUMBER_OF_PRODUCTS); ?></td> <td class="smallText" align="right"><?php echo TEXT_RESULT_PAGE . ' ' . $listing_split->display_links(MAX_DISPLAY_PAGE_LINKS, tep_get_all_get_params(array('page', 'info', 'x', 'y'))); ?></td> </tr> </table> <?php } $list_box_contents = array(); for ($col=0, $n=sizeof($column_list); $col<$n; $col++) { switch ($column_list[$col]) { case 'PRODUCT_LIST_MODEL': $lc_text = TABLE_HEADING_MODEL; $lc_align = ''; break; case 'PRODUCT_LIST_NAME': $lc_text = TABLE_HEADING_PRODUCTS; $lc_align = ''; break; case 'PRODUCT_LIST_MANUFACTURER': $lc_text = TABLE_HEADING_MANUFACTURER; $lc_align = ''; break; case 'PRODUCT_LIST_PRICE': $lc_text = TABLE_HEADING_PRICE; $lc_align = 'right'; break; case 'PRODUCT_LIST_QUANTITY': $lc_text = TABLE_HEADING_QUANTITY; $lc_align = 'right'; break; case 'PRODUCT_LIST_WEIGHT': $lc_text = TABLE_HEADING_WEIGHT; $lc_align = 'right'; break; case 'PRODUCT_LIST_IMAGE': $lc_text = TABLE_HEADING_IMAGE; $lc_align = 'center'; break; case 'PRODUCT_LIST_BUY_NOW': $lc_text = TABLE_HEADING_BUY_NOW; $lc_align = 'center'; break; } if ( ($column_list[$col] != 'PRODUCT_LIST_BUY_NOW') && ($column_list[$col] != 'PRODUCT_LIST_IMAGE') ) { $lc_text = tep_create_sort_heading($HTTP_GET_VARS['sort'], $col+1, $lc_text); } $list_box_contents[0][] = array('align' => $lc_align, 'params' => 'class="productListing-heading"', 'text' => ' ' . $lc_text . ' '); } if ($listing_split->number_of_rows > 0) { $rows = 0; $listing_query = tep_db_query($listing_split->sql_query); while ($listing = tep_db_fetch_array($listing_query)) { $rows++; if (($rows/2) == floor($rows/2)) { $list_box_contents[] = array('params' => 'class="productListing-even"'); } else { $list_box_contents[] = array('params' => 'class="productListing-odd"'); } $cur_row = sizeof($list_box_contents) - 1; for ($col=0, $n=sizeof($column_list); $col<$n; $col++) { $lc_align = ''; switch ($column_list[$col]) { case 'PRODUCT_LIST_MODEL': $lc_align = ''; $lc_text = ' ' . $listing['products_model'] . ' '; break; case 'PRODUCT_LIST_NAME': $lc_align = ''; if (isset($HTTP_GET_VARS['manufacturers_id'])) { $lc_text = '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'manufacturers_id=' . $HTTP_GET_VARS['manufacturers_id'] . '&products_id=' . $listing['products_id']) . '">' . $listing['products_name'] . '</a>'; } else { $lc_text = ' <a href="' . tep_href_link(FILENAME_PRODUCT_INFO, ($cPath ? 'cPath=' . $cPath . '&' : '') . 'products_id=' . $listing['products_id']) . '">' . $listing['products_name'] . '</a> '; } break; case 'PRODUCT_LIST_MANUFACTURER': $lc_align = ''; $lc_text = ' <a href="' . tep_href_link(FILENAME_DEFAULT, 'manufacturers_id=' . $listing['manufacturers_id']) . '">' . $listing['manufacturers_name'] . '</a> '; break; case 'PRODUCT_LIST_PRICE': $lc_align = 'right'; $pf->parse($listing); $lc_text = $pf->getPriceStringShort(); break; case 'PRODUCT_LIST_QUANTITY': $lc_align = 'right'; $lc_text = ' ' . $listing['products_quantity'] . ' '; break; case 'PRODUCT_LIST_WEIGHT': $lc_align = 'right'; $lc_text = ' ' . $listing['products_weight'] . ' '; break; case 'PRODUCT_LIST_IMAGE': $lc_align = 'center'; if (isset($HTTP_GET_VARS['manufacturers_id'])) { $lc_text = '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'manufacturers_id=' . $HTTP_GET_VARS['manufacturers_id'] . '&products_id=' . $listing['products_id']) . '">' . tep_image(DIR_WS_IMAGES . $listing['products_image'], $listing['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a>'; } else { $lc_text = ' <a href="' . tep_href_link(FILENAME_PRODUCT_INFO, ($cPath ? 'cPath=' . $cPath . '&' : '') . 'products_id=' . $listing['products_id']) . '">' . tep_image(DIR_WS_IMAGES . $listing['products_image'], $listing['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a> '; } break; case 'PRODUCT_LIST_BUY_NOW': $lc_align = 'center'; // Merged Out of Stock/Notify if ($listing['products_quantity'] > 0 ) $lc_text = '<a href="' . tep_href_link(basename($PHP_SELF), tep_get_all_get_params(array('action')) . 'action=buy_now&products_id=' . $listing['products_id']) . '">' . tep_image_button('button_buy_now.gif', IMAGE_BUTTON_BUY_NOW) . '</a> '; else $lc_text = '<a href="' . tep_href_link(basename($PHP_SELF), tep_get_all_get_params(array('action')) . 'action=notify, $request_type') . '">' . tep_image_button('button_out_notify.gif', BOX_HEADING_NOTIFICATIONS) . '</a> '; // END Merged Out of Stock/Notify break; } $list_box_contents[$cur_row][] = array('align' => $lc_align, 'params' => 'class="productListing-data"', 'text' => $lc_text); } } new productListingBox($list_box_contents); } else { $list_box_contents = array(); $list_box_contents[0] = array('params' => 'class="productListing-odd"'); $list_box_contents[0][] = array('params' => 'class="productListing-data"', 'text' => TEXT_NO_PRODUCTS); new productListingBox($list_box_contents); } if ( ($listing_split->number_of_rows > 0) && ((PREV_NEXT_BAR_LOCATION == '2') || (PREV_NEXT_BAR_LOCATION == '3')) ) { ?> <table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <td class="smallText"><?php echo $listing_split->display_count(TEXT_DISPLAY_NUMBER_OF_PRODUCTS); ?></td> <td class="smallText" align="right"><?php echo TEXT_RESULT_PAGE . ' ' . $listing_split->display_links(MAX_DISPLAY_PAGE_LINKS, tep_get_all_get_params(array('page', 'info', 'x', 'y'))); ?></td> </tr> </table> <?php } ?> I thought adding this . $listing['products_id'] in line 135 $lc_text = '<a href="' . tep_href_link(basename($PHP_SELF), tep_get_all_get_params(array('action')) . 'action=notify, $request_type' HERE) . '">' . tep_image_button('button_out_notify.gif', BOX_HEADING_NOTIFICATIONS) . '</a> '; but it makes no difference. Category breakout Notify me does not work here An example of it in the category break out: http://www.minionsweb.com/osStore/index.php?cPath=1_16_37_64 Stand alone IS working to add the notify me. An example of it in its standalone listing - http://www.minionsweb.com/osStore/product_...products_id=165 Any help would be appreciated.

OK, I get it, but I thought the threshold was already in the methods admin page, so this does confuse me. So threshold being - intl priority limit is 4# unless you use onerate box, there order is more than 4#, so it automagically switches the package to onerate intl, right? Being it is my busy season, no way am I putting alpha or beta builds in the store. Cannot afford to have any down time, when I can get b7y with what I have (like v2.9.2 I believe :) ) I will be happy to play some time in November. I have not looked -obviously- yet to see functionality, but have you dealt with the thresholds multi packaging calcs? Where it has been simply dividing the # packages into the total weight for an average weight per package top charge? Seems this is a truly poor method of calculating shipping, especially if you have one item at threshold (say 15#) and another item say at (3#) you end up with 2 boxes of approx 9lbs (plus tare) instead if the 15 & 3 boxes. Additionally, this should also have a choice to include tare in box weight calcs or to not include them. My tare for example is always .85# a 15# item plus tare then calcs 2 boxes of just under 8# - see where I am heading... About the rounding, it is possible that the db is set as something like num(5,2), or DECIMAL(5,2) or float(5,2) or have you looked for regex in the code? Instead of the round() function? (yeah I write software all day for a real job, tho I consider myself a code moron) Another point regarding weights ZERO WEIGHTS.... Items with no weight should not pass .01 to USPS, instead they should escape the add items loop tallying the weight totals and not be factored into the total shipping. Some folks would like to add items that have no effective weight, or do a free shipping sale, or have items that need to be calculated separately (say truck freight or larger than USPS weight max of 80# or greater dimensions that the 108" max length + girth (seee where dimensional weight is really needed?)). In my case, I would use it to allow customers to download a set of documents (instructions & MSDS) when buying certain goods, thereby validating the own the product and should have access to said docs. All stuff to consider....

No problem Greg, I am not all that able to assist with the tech answers as I have never had time to get into the nuts n bolts of the code. But I have a basic understanding of it. Plus having experienced a few snafus I can always throw some experience in for those in need. Explanation please... Does this mean I can add an item and flag it as a certain weight box without it breaking into 3 boxes? And this can be done for numerous items? Or am I completely off base? When you say GUI, within each item listing, or from some new addition to the console? An enquiring mind wants to know

I am hoping this was a freak occurrence, but that never happens..... Just received a notice from paypal for the payment, checked the console, and see the order cited in the paypal notice, but no green check mark or ipn confirmation in the comments field. Anyone else????

We have the opposite issue. Most of my orders pack into priority boxes, and typical max weight will be 10-12 lbs per box, but we also ship other products that are larger, in non priority boxes, so, if someone selects a number of items from us, including larger items, they end up with too many 10-12 lb or fraction there of, boxes.... Would be great to have a flag for items which exceed normal max weight, so they do not get subdivided. Not to mention (as usual)...dimensional shipping .... (flogging the dead horse) I believe the rates are online rates by default, our carts seem to back that up.

OK, other than myself and the few others posting since mid month, is this thread dead? Would love to know if anyone has figured out/added dimensional shipping in this contrib.

Follow this thread back a few months, you will need to edit the shipping clases in 2 locations, one for admin control the other for catalog. You probably missed the edits for the catalog side.

Did you register with USPS and get the access key? Check to make sure you are sending to production not testing server.

Sounds like you have a tare added under the admin configuration>shipping packaging>package tare weight

Have not followed the thread in quite some time...I have a quick question about features. Has a dimensional weight feature been added to this contrib? Thanks

Hey there, a little help would be appreciated..... I too am having cron job issues. I have reset file permissions, but am getting errors right off the php file flag on line 1 of the cron_update_bestsellers.php (see codebox below) I had the cron job firing in test mode (reset to 1/day was firing 1/minute) with that error msg being received. here is how I have the cron tab set /home/serverNameHere/public_html/osStore/cron_update_bestsellers.php /home/serverNameHere/public_html/osStore/cron_update_bestsellers.php: line 1: ?php: No such file or directory /home/serverNameHere/public_html/osStore/cron_update_bestsellers.php: line 2: /aquota.user: Permission denied /home/serverNameHere/public_html/osStore/cron_update_bestsellers.php: line 5: osCommerce,: command not found /home/serverNameHere/public_html/osStore/cron_update_bestsellers.php: line 6: [url="http://www.oscommerce.com:"]http://www.oscommerce.com:[/url] No such file or directory /home/serverNameHere/public_html/osStore/cron_update_bestsellers.php: line 8: syntax error near unexpected token `c' /home/serverNameHere/public_html/osStore/cron_update_bestsellers.php: line 8: ` Copyright © 2003 osCommerce' Yes serverNameHere is to protect the public (ME!) So, what have I done incorrectly? Any insight or better yet, the solution to why it is taking the cron verbatim from the file. The admin panel report is present, has the header row, no data There are over 100 items in the catalog, and a few hundred sales.....so something is missing :) Thanks, Corey

I anyone else getting contacted about transactions not completing once they pass over to paypal? 2 customers called today, both happened to be ordering from me and some other businesses that use osc and the ipn module. If so, anyone aware of the fix to the issue, I do not see mentions in the threads yet?

Also deactivate the stock usps in the admin panel. Be very careful on how you "delete" the contrib! Follow the documentation in reverse order and remove all code added in that order. You should have a clean slate to begin from again. BACK UP BACK UP BACK UP

Create you own! Or use clipart! Or google what you want! I am 3/4 of the way done converting from stock images. See....

What exactly are you asking? Which contrib? Why should you have to duplicate entries? The header is the header is the header.