bglkk

Yeah, the CRELoaded forks have caused a lot of confusion. More ranting on the same subject in the main support thread. http://www.oscommerce.com/forums/index.php?sho...ic=54032&st=320 At least the latest forked version is labeled clearly ("Order Editor Update for CreLoaded version 6.1a")--unlike the Oct. 30 2004 version.... *#!*&$#

Hi: Yah, the versions are confusing. v1.61 works for my installation, but you'll also want to look at Michel Haase's 18 Feb. solution for tax calculations. The default "Optional Tax Rates" values in edit_orders.php were screwing up calculations on orders that didn't even have taxes added. >_< Optional Tax Rates, e.g. shipping tax of 17.5% is "17.5" $AddCustomTax = "20.0"; // class "ot_custom", used for all unknown total modules $AddShippingTax = "20.0"; // class "ot_shippping" $AddLevelDiscountTax = "7.6"; // class "ot_lev_discount" $AddCustomerDiscountTax = "7.6"; // class "ot_customer_discount" Changing the above values to 0.0 fixed the calculation problem for me. (Michel's edit_orders.php file also contains other tax calculation fixes that I haven't applied.)

Hi Tom: As you may have guessed, you can add a link to catalog/files.php. I don't think you can break it... ;)

Thanks for pointing this out. Those default tax rates were screwing up calculations on my orders even with no taxes applied. >_< Cheers to Michel Haase for his fix too.

I think you're confusing OpenSSL with an SSL certificate. OpenSSL is an open-source protocol, and it is free: http://www.openssl.org/ An SSL cert, however, requires a modest investment (usually yearly). For more info, search for StarterSSL, FreeSSL, InstantSSL, GeoTrust, Verisign, Thawte...

Reply from Chris Binkert: "Yeah, my version 1.6x was based on "Order Editor 1.59 - German translation" released on 20 Oct 2004." So that would predate the forked project version... B)

We've got a calculation issue with v1.61... Adding a product--no problem. Subtotal and Total calculate correctly (shipping doesn't change, but that's another story). But when we remove a product or substitute a model with lower price, the Subtotal is correct but the Total is wrong (less than it should be). For example: Original Order: Product 1: $9.99 Product 2: $299.99 Subtotal: $309.98 Shipping: $19.20 Total: $329.18 Edited Order: Product 1: $9.99 Product 2: $199.99 Subtotal: $209.98 (Correct) Shipping: $19.20 Total: $225.98 (Incorrect. $209.98 + $19.20 = $229.18--a discrepancy of $3.20) And changing the order back to the original products doesn't help--the Total still comes up short of what it was originally. Any ideas? Thanks.

I see, thanks. I think I've got this mess traced. There are actually two v1.6 downloads, one from John Parker (posted Oct. 30, 2004) and one from Christian Binkert (posted Jan. 4, 2005). The filename for John Parker's 1.60 version is OrderEditor1.606.1a.zip He should have put that into the contribution page notes too, but he didn't. <_< Of course Didier's posting #235 (Nov. 4, 2004) is only talking about John Parker's version, posted five days earlier. http://www.oscommerce.com/forums/index.php?sho...ndpost&p=477438 I'm supposing that Binkert put his v1.6 back on the non-forked project track (based on v1.59 or even v1.58--not John Parker's v1.60). At any rate, the version history in Roscilli's v1.61 says nothing about Parker's v1.60. ******************************************************************************** ************ v.1.61 by Riccardo Roscilli http://www.oscommerce.it/ First of all, thank you very much to all the guys partecipating in this contrib. Only a fix about specials prices. When you add a product, if this is in specials table the price will be the special price instead of the standard price. ******************************************************************************** ************ v.1.60 by Christian Binkert This is a large update for using the order editor in western europe (tested in switzerland / germany) but should work everywhere. I updated and reworked almost everything, so it was impossible to comment all the changes;-). Mainly there are some bugfixes (e.g. corrected tax calculation for this version, currency issues), some new features (different taxes for discount modules, extentable) and a new (nice;-) layout. Just try it out, it's not an official update and probably too specific for my country needs, but it brings a lot of useful stuff... ******************************************************************************** ************ v.1.59 by Didier Debbaut - multi-language support for product options and product description - correction of currency display during display of tax, subtotal and total (currency is displayed AFTER the amount) - bigger display fields of payment method, product name and options values - the option value prefix if now displayed I'm new to this contribution and haven't checked the code carefully yet, but v1.61 seems to work fine on my non-forked project osC. I'll try to give Binkert a shout and see what he has to say. P.S. Is CRE short for cretinous? :devil:

If I may inquire, where did you get this info that v1.59 was the latest version for 'regular' osC? I've just installed v1.61 (update by Riccardo Roscilli) on a 'regular' osC, and it's working well. (There are some issues with recalculation of taxes & shipping, but I see no indication that those are forked project issues...) There is no mention of a forked project in the v1.61 readme file or code comments, and of course not in the contribution notes. If there is a forked project fork, that is obviously not a good thing... >_< Can you confirm?

Our "solution" (and it isn't one, really) was to only offer USPS shipping to Puerto Rico--since UPS to Puerto Rico is expensive anyway. When PR customers get to Shipping Method they see three choices for USPS, and United Parcel Service We are unable to obtain a rate quote for UPS shipping. Please contact the store if no other alternative is shown. Yeah and as pointed out, for USPS customers from PR have to use a shipping address with US as country; if the country is PR, they get -2147219080 - Missing value for Country. A pain in the butt.

Hi: This info is stored in the countries, geo_zones, and zones_to_geo_zones tables in your database. Is that what you're asking? B)

We've been using Linkpoint for a year, and haven't had any major problems. But we're now looking at switching to Authorize.net because we want to participate in the Verified by Visa and MasterCard SecureCode programs, and Linkpoint doesn't support those through the API. They also don't make their LinkShield fraud protection service available through the API. Go figure. Linkpoint's customer support is terse, to say the least. Here is their *complete* response to my query about obtaining the VbB/MCSC and LinkShield services: I guess that's to the point, but it doesn't exactly leave me with a warm and fuzzy feeling. :huh:

Coming from a B2B business background, we were used to having our customers make bank transfers. We installed an osCommerce bank transfer module and of course we'd prefer that people use it (no chargebacks!). Unfortunately we find that few do...they place an order and then never complete the payment. For us the lesson is that bank transfers don't work well for B2C business.

Hi: Just for kicks, I've merged Alpha Ray's code for changing the background of the Categories box into this great contribution. This version lets you have bullets, lines, and a different background color for the box. Alpha Ray's code can be found here: http://www.oscommerce.com/forums/index.php?sho...ndpost&p=528149 Here's the merged code. I'm not a programmer, so there may be a better way to do this--but it's working on my site. Note: This also requires adding several new stylesheet definitions (TD.infoCatBoxHeading, .infoCatBox, .infoCatBoxContents, and .CatboxText), as detailed in Alpha Ray's post. <?php /* $Id: categories.php,v 1.23 2002/11/12 14:09:30 dgw_ Exp $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2002 osCommerce Released under the GNU General Public License */ function tep_show_category($counter) { global $foo, $categories_string, $id, $aa; for ($a=0; $a<$foo[$counter]['level']; $a++) { if ($a == $foo[$counter]['level']-1) { $categories_string .= "<font color='#ff0000'> </font>"; } else { $categories_string .= "<font color='#ff0000'> </font>"; } } if ($foo[$counter]['level'] == 0) { if ($aa == 1) { $categories_string .= "<hr>"; } else {$aa=1;} } $categories_string .= '<nobr><a nowrap href="'; if ($foo[$counter]['parent'] == 0) { $cPath_new = 'cPath=' . $counter; } else { $cPath_new = 'cPath=' . $foo[$counter]['path']; } $categories_string .= tep_href_link(FILENAME_DEFAULT, $cPath_new); $categories_string .= '">' . tep_image(DIR_WS_IMAGES . 'checkout_bullet.gif', '') . ' ';; if ( ($id) && (in_array($counter, $id)) ) { $categories_string .= "<b><font color='#ff0000'>"; } // display category name $categories_string .= $foo[$counter]['name']; if ( ($id) && (in_array($counter, $id)) ) { $categories_string .= '</font></b>'; } // if (tep_has_category_subcategories($counter)) { // $categories_string .= '->'; // } $categories_string .= '</nobr></a>'; // if (SHOW_COUNTS == 'true') { // $products_in_category = tep_count_products_in_category($counter); // if ($products_in_category > 0) { // $categories_string .= ' (' . $products_in_category . ')'; // } } $categories_string .= '<br>'; if ($foo[$counter]['next_id']) { tep_show_category($foo[$counter]['next_id']); } } ?> <!-- categories //--> <tr> <td> <?php $aa = 0; class infoCatBox extends tableBox { function infoCatBox($contents) { $info_box_contents = array(); $info_box_contents[] = array('text' => $this->infoBoxContents($contents)); $this->table_cellpadding = '1'; $this->table_parameters = 'class="infoCatBox"'; $this->tableBox($info_box_contents, true); } function infoBoxContents($contents) { $this->table_cellpadding = '3'; $this->table_parameters = 'class="infoCatBoxContents"'; /* $info_box_contents[] = array('align' => 'left', 'text' => BOX_HEADING_CATEGORIES ); */ $info_box_contents = array(); $info_box_contents[] = array(array('text' => tep_draw_separator('pixel_trans.gif', '100%', '1'))); for ($i=0, $n=sizeof($contents); $i<$n; $i++) { $info_box_contents[] = array(array('align' => (isset($contents[$i]['align']) ? $contents[$i]['align'] : ''), 'form' => (isset($contents[$i]['form']) ? $contents[$i]['form'] : ''), 'params' => 'class="SearchCatText"', 'text' => (isset($contents[$i]['text']) ? $contents[$i]['text'] : ''))); } $info_box_contents[] = array(array('text' => tep_draw_separator('pixel_trans.gif', '100%', '1'))); return $this->tableBox($info_box_contents); } } class infoCatBoxHeading extends tableBox { function infoCatBoxHeading($contents, $left_corner = true, $right_corner = true, $right_arrow = false) { $this->table_cellpadding = '0'; if ($right_arrow == true) $this->table_row_parameters = 'onclick="javascript:window.location=\''.$right_arrow.'\'"' . ' onmouseover="this.style.cursor=\'hand\'"'; /* if ($left_corner == true) { $left_corner = tep_image(DIR_WS_IMAGES . 'infobox/corner_left.gif'); } else { $left_corner = tep_image(DIR_WS_IMAGES . 'infobox/corner_right_left.gif'); } */ $left_corner = ' '; if ($right_arrow == true) { $right_arrow = '<a href="' . $right_arrow . '">' . tep_image(DIR_WS_IMAGES . 'infobox/arrow_right.gif', ICON_ARROW_RIGHT) . '</a>'; } else { $right_arrow = ''; } $right_corner = false; if ($right_corner == true) { $right_corner = $right_arrow . tep_image(DIR_WS_IMAGES . 'infobox/corner_right.gif'); } else { $right_corner = $right_arrow . tep_draw_separator('pixel_trans.gif', '11', '14'); } $info_box_contents = array(); $info_box_contents[] = array(array('params' => 'height="14" class="infoCatBoxHeading"', 'text' => $left_corner), array('params' => 'width="100%" height="14" class="infoCatBoxHeading"', 'text' => $contents[0]['text']), array('params' => 'height="14" class="infoCatBoxHeading" nowrap', 'text' => $right_corner)); $this->tableBox($info_box_contents, true); } } $info_box_contents = array(); $info_box_contents[] = array('text' => BOX_HEADING_CATEGORIES); new infoCatBoxHeading($info_box_contents, false, false); $categories_string = ''; $tree = array(); // add links to products with no category $product_query = tep_db_query("select p.products_id, pd.products_name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = p2c.products_id and p2c.categories_id = 0 and p.products_id = pd.products_id and pd.language_id ='" . (int)$languages_id . "' order by pd.products_name " ); while ($no_category = tep_db_fetch_array($product_query)) { $no_cat_product_id = $no_category['products_id']; $no_cat_products_name = $no_category['products_name']; $myref = "<a href=" . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $no_cat_product_id) . '>' . $no_cat_products_name . '</a><br><br>'; $categories_string .= $myref; } // end links to products with no category $categories_query = tep_db_query("select c.categories_id, cd.categories_name, c.parent_id from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id='" . $languages_id ."' order by sort_order, cd.categories_name"); while ($categories = tep_db_fetch_array($categories_query)) { $foo[$categories['categories_id']] = array( 'name' => $categories['categories_name'], 'parent' => $categories['parent_id'], 'level' => 0, 'path' => $categories['categories_id'], 'next_id' => false ); if (isset($prev_id)) { $foo[$prev_id]['next_id'] = $categories['categories_id']; } $prev_id = $categories['categories_id']; if (!isset($first_element)) { $first_element = $categories['categories_id']; } } //------------------------ if ($cPath) { $new_path = ''; $id = split('_', $cPath); reset($id); while (list($key, $value) = each($id)) { unset($prev_id); unset($first_id); $categories_query = tep_db_query("select c.categories_id, cd.categories_name, c.parent_id from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.parent_id = '" . $value . "' and c.categories_id = cd.categories_id and cd.language_id='" . $languages_id ."' order by sort_order, cd.categories_name"); $category_check = tep_db_num_rows($categories_query); if ($category_check > 0) { $new_path .= $value; while ($row = tep_db_fetch_array($categories_query)) { $foo[$row['categories_id']] = array( 'name' => $row['categories_name'], 'parent' => $row['parent_id'], 'level' => $key+1, 'path' => $new_path . '_' . $row['categories_id'], 'next_id' => false ); if (isset($prev_id)) { $foo[$prev_id]['next_id'] = $row['categories_id']; } $prev_id = $row['categories_id']; if (!isset($first_id)) { $first_id = $row['categories_id']; } $last_id = $row['categories_id']; } $foo[$last_id]['next_id'] = $foo[$value]['next_id']; $foo[$value]['next_id'] = $first_id; $new_path .= '_'; } else { break; } } } tep_show_category($first_element); $info_box_contents = array(); $info_box_contents[] = array('align' => 'left', 'text' => $categories_string ); // WebMakers.com Added: All products or All Products Multiple Purchase // new infoBox($info_box_contents); // WebMakers.com Added: Show All Products Listing if (SHOW_ALL_PRODUCTS_BOX=='1') { $info_box_contents[] = array('align' => 'center" valign="top', 'text' => '<hr><a href="' . tep_href_link(FILENAME_ALLPRODS, '', 'NONSSL') . '">' . BOX_INFORMATION_ALLPRODS . '</a>'); } // WebMakers.com Added: Show multiple product listing add for all products if (SHOW_PRODUCT_LISTINGS_MULTI_ADD_BOX=='1') { // All Products Multiple Purchase $info_box_contents[] = array('align' => 'center" valign="top', 'text' => '<hr><a href="' . tep_href_link(FILENAME_PRODUCTS_ALL, '', 'NONSSL') . '">' . BOX_INFORMATION_PRODUCT_ALL . '</a>'); } new infoCatBox($info_box_contents); ?> </td> </tr> <!-- categories_eof //-->

Not necessary, IMO. Must be a law of nature or something that a script starts out lightweight and simple, and then gets more complex as more people start messing with it... :o File size would be handy to see, and maybe the number of downloads.

Hi Toby: Don't mind me, I just like to skip over instructions like "make sure that catalog/files exists..." Must have been excessive fatigue from snow shoveling... :blush: Your contribution works as advertised, and thanks for the quick response & update. Just a few cosmetic things (and I hope to not insert foot in mouth again)... * Admin says, "Please fill out the following information for the new country". * I'm missing language definitions for TEXT_FILES_COVER_IMAGE, TEXT_DELETE_IMAGE, and NAVBAR_TITLE. No big deal.

Hi Toby: Thanks for this, it looks like a great contribution. I've just installed v1.2, but admin is not saving the file path or image path. Clicking Save in admin gives me two "Error: Destination does not exist." messages. (The file is in the catalog/download/ directory, and the image is in the catalog/images/ directory--both are defined correctly in configuration.) I've tried chmodding both directories with 755 and 777, no joy. But both paths save successfully when I enter them via phpmyadmin. Then when I delete a file with the TEXT_DELETE_IMAGE checkbox checked (there is no assigned image, because the path won't save...), I get this: Cheers.

You've asked a lot of questions, but I'll take a stab at one or two... The UPS and USPS modules both work pretty much as Shane has described for Auspost. In other words, shipping costs are calculated by the UPS and USPS APIs based on weight and destination. The available shipping methods will then appear on your site--unlike Paypal, your customers will not leave your site. UPS provides tracking numbers... You can direct your customers to the UPS site for tracking, or you can install the 'UPS Order Tracking XML' contribution so they can track from your site. http://www.oscommerce.com/community/contributions,113/

This is a common problem, due to USPS changing their International Rates API some time back. http://www.oscommerce.com/forums/index.php?sho...20entry362202

If you don't have it already, get phpMyAdmin. You server control panel (such as cPanel) might provide it already--if not, go here: http://www.phpmyadmin.net/home_page/index.php "phpMyAdmin is a tool written in PHP intended to handle the administration of MySQL over the Web. Currently it can create and drop databases, create/drop/alter tables, delete/edit/add fields, execute any SQL statement, manage keys on fields, manage privileges,export data into various formats and is available in 47 languages."

Here's a recent thread on the same topic, and there are many others... http://www.oscommerce.com/forums/index.php?showtopic=119042

Hi: Yes, USPS changed the International API quite a while back, causing the problem you describe. http://www.oscommerce.com/forums/index.php?sho...20entry362202 It seems like every week somebody hits this issue, because the stock USPS module hasn't been updated. I don't think this is any relation to the Domestic Rates API update.

Hi: We'd like to enable the Linkpoint module only for a certain Payment Zone. Sounds simple, right? But strangely, no matter which Payment Zone we select, the credit card payment option still appears for customers from all countries. We've never had any problem using a Payment Zone to restrict Paypal to certain countries, so I'm stumped on why Linkpoint isn't behaving the same way. I've run through every possible solution I can think of: * selected different Payment Zones, including the zone that we are successfully using for Paypal. * removed and reinstalled the Linkpoint module. * confirmed in the Configuration table that MODULE_PAYMENT_LINKPOINTMS1_ZONE has the correct zone value. * hardcoded the correct zone value ('5', below) into the payment/linkpointms1.php file: 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 ('Payment Zone', 'MODULE_PAYMENT_LINKPOINTMS1_ZONE', '5', 'If a zone is selected, only enable this payment method for that zone.', '6', '2', 'tep_get_zone_class_title', 'tep_cfg_pull_down_zone_classes(', now())"); But nothing changes--the Linkpoint payment option is still available to customers from every country. What am I missing? :blink:

This problem is due to changes that USPS made to their International Rates Engine API. It's bitten a lot of people. http://www.oscommerce.com/forums/index.php?sho...20entry362202

Hi Scott: I've just tried giving this a go, first dropping return.php into catalog/includes/linkpoint/ (together with lphp.php). That resulted in permission problems (403 Forbidden--"You don't have permission to access /catalog/includes/linkpoint/return.php on this server.")...I've tweaked my .htaccess files and changed folder/file permissions, but no joy. So then I copied both return.php and lphp.php into the catalog directory--no permission problems there, but instead I get this: Status: < Error: Looking into result.php, that would seem to indicate "transaction failed"... As recommended, using full system path for the key file in return.php: /home/myserver/public_html/catalog/includes/linkpoint/mystore#.pem Any ideas?