Jump to content

dreamlab

Members
  • Content count

    58
  • Joined

  • Last visited

Profile Information

  • Real Name
    Dick
  • Gender
    Male
  1. dreamlab

    Fedex Zone Contrib version 2.0 ready

    Hello, Thank you for a great contribution. While installing the contribution I found that the excel table provided from FedEx for FedEx Ground Standard List Rates effective 1-1-2012 contains a dash (-) in the column of results for FedEx Ground Shipping from my zip code to Puerto Rico and I am wondering if I should remove the dashs as well as the references to Zone "10" (Puerto Rico) before processing the CSV file via buildfedexdata.php or will the shipping rate calculations be negatively affected if I do so? There was a reference to "Piece was non-numeric: -" in the buildfedexdata.php processing output results but I am not sure if that would constitue an error and would affect the shipping rate results or not. Thank you in advance for your reply and assistance. Dreamlab
  2. dreamlab

    cDynamic Meta Tags

    Hello, I'm looking for a code modification that will allow for displaying both the category name and subcategory name (when in a subcategory) at the same time in the title for cDynamic Meta Tags Version 1.3? Currently, either only the category name or subcategory name is displayed. Can anyone please share with me how to do this? Your help is greatly appreciated. Regards, Dreamlab
  3. Hello, I'm looking for a code modification that will allow for displaying both the category name and subcategory name (when in a subcategory) at the same time in the title for cDynamic Meta Tags Version 1.3? Currently, either only the category name or subcategory name is displayed. Can anyone please share with me how to do this? Your help is greatly appreciated. Regards, Dreamlab
  4. Hello, I am trying to add a page to display all products compatible with the Separate Pricing Per Customer code modification in the index.php page but have not had any luck getting it to work and any help would be greatly appreciated. I would be willing to pay for your time if a solution is provided. The all products page is category 1 (all-products-c-1.html) on my development website. The page does not error but no products display. The code is duplicated from the SPPC version 4.1.6 index.php page code but with a new reference to "$cPath == 1 AND" in every IF statement. Here is the code I have so far: // show the products of a specified manufacturer CUSTOM FROM HERE if ($cPath == 1 AND isset($HTTP_GET_VARS['manufacturers_id'])) { if ($cPath == 1 AND isset($HTTP_GET_VARS['filter_id']) && tep_not_null($HTTP_GET_VARS['filter_id'])) { // We are asked to show only a specific category // BOF Separate Pricing Per Customer if ($cPath == 1 AND $status_product_prices_table == true) { $listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, tmp_pp.products_price, p.products_tax_class_id, IF(tmp_pp.status, tmp_pp.specials_new_products_price, NULL) as specials_new_products_price, IF(tmp_pp.status, tmp_pp.specials_new_products_price, tmp_pp.products_price) as final_price from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd left join " . $product_prices_table . " as tmp_pp using(products_id), " . TABLE_MANUFACTURERS . " m, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_status = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$HTTP_GET_VARS['filter_id'] . "'"; } else { // either retail or no need to get correct special prices $listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c left join " . TABLE_SPECIALS_RETAIL_PRICES . " s on p.products_id = s.products_id where p.products_status = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$HTTP_GET_VARS['filter_id'] . "'"; } // end else { // either retail... // EOF Separate Pricing Per Customer } else { // We show them all // BOF Separate Pricing Per Customer if ($cPath == 1 AND $status_product_prices_table == true) { $listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, tmp_pp.products_price, p.products_tax_class_id, IF(tmp_pp.status, tmp_pp.specials_new_products_price, NULL) as specials_new_products_price, IF(tmp_pp.status, tmp_pp.specials_new_products_price, tmp_pp.products_price) as final_price from " . TABLE_PRODUCTS . " p left join " . $product_prices_table . " as tmp_pp using(products_id), " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "'"; } else { // either retail or no need to get correct special prices $listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m left join " . TABLE_SPECIALS_RETAIL_PRICES . " s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "'"; } // end else { // either retail... // EOF Separate Pricing Per Customer } } else { // show the products in a given categorie if ($cPath == 1 AND isset($HTTP_GET_VARS['filter_id']) && tep_not_null($HTTP_GET_VARS['filter_id'])) { // We are asked to show only specific catgeory; // BOF Separate Pricing Per Customer if ($cPath == 1 AND $status_product_prices_table == true) { $listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, tmp_pp.products_price, p.products_tax_class_id, IF(tmp_pp.status, tmp_pp.specials_new_products_price, NULL) as specials_new_products_price, IF(tmp_pp.status, tmp_pp.specials_new_products_price, tmp_pp.products_price) as final_price from " . TABLE_PRODUCTS . " p left join " . $product_prices_table . " as tmp_pp using(products_id), " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_status = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['filter_id'] . "' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$current_category_id . "'"; } else { // either retail or no need to get correct special prices $listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c left join " . TABLE_SPECIALS_RETAIL_PRICES . " s using(products_id) where p.products_status = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['filter_id'] . "' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$current_category_id . "'"; } // end else { // either retail... // EOF Separate Pricing Per Customer } else { // We show them all // BOF Separate Pricing Per Customer if ($cPath == 1 AND $status_product_prices_table == true) { $listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, tmp_pp.products_price, p.products_tax_class_id, IF(tmp_pp.status, tmp_pp.specials_new_products_price, NULL) as specials_new_products_price, IF(tmp_pp.status, tmp_pp.specials_new_products_price, tmp_pp.products_price) as final_price from " . TABLE_PRODUCTS_DESCRIPTION . " pd left join " . $product_prices_table . " as tmp_pp using(products_id) left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id, " . TABLE_PRODUCTS . " p" . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$current_category_id . "'"; } else { // either retail or no need to get correct special prices $listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id left join " . TABLE_SPECIALS_RETAIL_PRICES . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$current_category_id . "'"; } // end else { // either retail... // EOF Separate Pricing per Customer } } Please let me know if you need any additional information or see what the problem is and if you have any suggested solutions. Thank you in advance for your reply and assistance. Regards, Dick Dreamlab
  5. dreamlab

    USPS Domestic Shipping Troubles

    Tim, I am using USPS Methods 2.8d with the May 14th update. I have attempted to make the changes you touched upon but am not able to get the USPS display to function properly. Can you, or anyone else, please be more specific as to what exact changes need to be made in which files and how to update the records in the configuration? Thanks in advance for your help. Regards, Dick
  6. dreamlab

    USPS International = NEW NAMES update

    Jayman, Are you certain that suggested solution fixed your problem? It didn't fix mine. I double checked my usps.php file (and my complete OSCommerce script package using Dreamweaver) and found no reference to the capitalized "PARCEL", "PRIORITY" or "EXPRESS" text that is currently displaying during the check out process, only the lower case "Parcel Post", "Priority Mail" and "Express Mail" text in $this->types = array options, so I still have no clue as to why the capitalized USPS shipping methods are displaying or why the script is defaulting to PARCEL even though other USPS shipping choices are selected. Everything was working perfectly until recently. Just to be sure, I reuploaded the usps.php file and still have the same display results. I wonder if this has to do with the fact that I have not upgraded to 2.2RC1 at this time? Any other solution suggestions would be greatly appreciated. Dick
  7. dreamlab

    [Contribution] - USPS Methods

    Jason, Yes, I too am having a similar problem, although my shipping type defaults to PARCEL since I am not offering First Class. I've noticed that my USPS International options do not seem to be affected, only USPS Domestic options. I hope that a solution is forthcoming. Dick
  8. dreamlab

    [Contribution] - USPS Methods

    Hello, I recently discovered some strange functional behavior with the USPS Methods contribution and wonder if anyone else has the same problem or might know how to correct it. I am using the latest USPS Methods 2.8d with the USPS service and rates updates effective May 14, 2007 by grapesmuggler and kbucher. My US domestic calculator seems to work fine but when I enter more than 528 items (or $1584. total cost) in the shopping cart, the display of the following international shipping options stops showing (and only the three Global Express Guaranteed options show): Express Mail International (EMS) Priority Mail International Since I sell my product by the pound (and use the item count as quantity of lbs), any order at 529 lbs (or $1587. total cost) and above stops the display of the least expensive Express Mail International (EMS) and Priority Mail International shipping options. I've triple checked my code and do not see any errors. Does anyone have the same problem and/or a suggested work around? Thanks in advance for your help! Regards, Dick
  9. dreamlab

    Fedex Freight from Canada Won't Display Quote?

    Brian, Thanks for the reply and information. Then the recent changes you made correct the issue that I was having with the Canadian Post Code error and all is well now. Thank you so much for your help! Dick
  10. dreamlab

    Fedex Freight from Canada Won't Display Quote?

    Hi Brian, I received an emailed error message today but as long as the FedEx Freight quote is displaying it works great for me. I wonder if the error message below relates to the fact that I sell my product by the pound (which may look like "items" to the script) and will receive errors because the script only processes orders up to quantities of six. This error log was generated when customer David (Customer ID: 271) checked out on 2007-01-20 22:45: FedEx Freight returned an error or invalid response.http://www.fedexfreight.fedex.com/XMLRating.jsp?as_shipterms=prepaid&as_shzip=68632&as_shcntry=US&as_cnzip=96247&as_cncntry=US&as_iamthe=shipper&as_class1=050&as_weight1=7&as_pcs1=7&as_haz1=0&as_freezable1=0&as_class2=050&as_weight2=7&as_pcs2=7&as_haz2=0&as_freezable2=0 If that is the cause of the emailed error messages I'm receiving, can you recommend a solution for my particular application? If not, do you see what may be causing the emailed error message since updating the script? Thank you so much for your help! Best regards, Dick
  11. dreamlab

    Fedex Freight from Canada Won't Display Quote?

    Brian, Many thanks, it worked! Sorry for the delay in replying, I was testing thoroughly. I was able to fix the spacing issue using your first suggestion but using your second suggestion still did not display the FedEx Freight shipping quote. I can now successfully see quotes for Canadian customers with and without the space in the Canadian Post Code. Thank you so much for your help! Best regards, Dick
  12. dreamlab

    Fedex Freight from Canada Won't Display Quote?

    Brian, More info. Here is the emailed error message I receive when I attempt to use a Canadian Post Code with the space between the first and last three character groups: This error log was generated when customer Dick (Customer ID: 1) checked out on 2007-01-19 19:32: FedEx Freight returned an error or invalid response.http://www.fedexfreight.fedex.com/XMLRating.jsp?as_shipterms=prepaid&as_shzip=68632&as_shcntry=US&as_cnzip=V2L 3V&as_cncntry=CA&as_iamthe=shipper&as_class1=050&as_weight1=5&as_pcs1=5&as_haz1=0&as_freezable1=0 Thanks again for all your help. Dick
  13. dreamlab

    Fedex Freight from Canada Won't Display Quote?

    Brian, I've found some threads on how to remove spaces from Post Codes but do not know how to impliment it in your FedEx Freight contribution (or elsewhere). Perhaps this is better done during the create account process? Here are the threads: http://forums.oscommerce.com/index.php?s=&...st&p=915965 http://forums.oscommerce.com/index.php?s=&...st&p=294073 Hope this helps. Dick
  14. dreamlab

    Fedex Freight from Canada Won't Display Quote?

    Brian, Good eye! I did not catch that. That change seems to correct the problem of a Canadian Post Code without a space but still errors if the Canadian Post Code is entered by the client as the Canadian standard (with the break in between the first three character group and the second three character group). In the OSC Admin area there is a Configuration setting for the Minimum Value for Post Code (mine is set to 5 characters) but no Configuration setting to control the Maximum Value for Post Code to 6 characters (forcing Canadians to not enter a Post Code space). Even doing that would be sketchy because all they need is 5 characters for the error checking to be accepted and their Post Code would be incomplete. Is there a way to remove the effect on the FedEx Freight script from any space that a Canadian may provide in the Canadian Post Code or any other workaround that you can think of? Your help solving this is greatly appreciated! In the mean time, I'll continue to peruse the forum for a solution to that. Dick
  15. dreamlab

    Fedex Freight from Canada Won't Display Quote?

    Brian, The previous result was when I logged in with a Canadian address but when I logged in with a US address the results were: Array ( [0] => Array ( [pcs] => 1 => http://www.fedexfreight.fedex.com/XMLRatin...as_freezable1=0 ) ) 1 Dick
×