Jump to content
Latest News: (loading..)


  • Content count

  • Joined

  • Last visited

  • Days Won


Everything posted by NodsDorf

  1. According to the API documentation Authorize.net will only process request with 30 or less individual line items. REF: https://developer.authorize.net/api/reference/ " • lineItems Contains one or more elements (the maximum is 30 line items " This is not an every shop problem, but for some it maybe more prominent than others. In the last 10+ years of using OSC I have ran into this issue exactly 3 times. It wasn't until this last time I actually found this information and realized what the problem was. The solution that I have used in all 3 cases thus far has been to enable COD payment module to generate a customer order. Then use the Authorize.net manual interface to charge the customer's card. From a professional standpoint this has been a bit lackluster and if I was a customer I would have some apprehensions from a random store owner telling me this is how they have to process my order. Thinking about this and the various industries I would imagine this issue comes up more often for others than myself. My in shop solution thought is currently running along the lines of a BYO (Build Your Own) module much like is used with computer purchases. You start with X Computer then add the options / software / hardware you want. In the end you have only 1 product being purchased but it has a multitude of options with it. Exactly how to port this idea over to a common use-able addon is unclear to me. Scenarios in industries with multiple similar low cost items like stickers, or screws, or greeting cards, or general office supplies may face this problem regularly and I am not sure how you port a BYO system over to such an industry. What have you done in the past to overcome this issue?
  2. USPS Rate V4, Intl Rate V2 (official support thread)

    @@pvoce I see, looks like you went for the last version that had all the frills, I actually installed the version before that. Aside from not getting flat rate values returned from USPS it is working well. USPS Rate V4 Intl Rate V2 - v.1.7 - FIX 11 Feb 2012 Maybe somebody else can lend a hand, or if you don't actually need the product restrict functionality you could use the version above.
  3. USPS Rate V4, Intl Rate V2 (official support thread)

    @@pvoce Did you uninstall the stock oscommerce usps module before installing this one? Also which method did you use, drop on top, or self modify files? Your problem sounds like some data in this database wasn't cleared or ther is a missing character in the code. I don't know if there are any people who had this problem 14 pages is hard to read through, but I can say I did not have that issue. I can try and help if you want to answer those questions or show a screen shot of what the problem looks like.
  4. USPS Rate V4, Intl Rate V2 (official support thread)

    @@aerosmith Hi, did you sign up for an account at USPS.com? I noticed when I installed it I did not get any rates until I called them and told me to put me on the production server. According to the emails they sent me they start everybody out on the test server.
  5. USPS Rate V4, Intl Rate V2 (official support thread)

    @@ehong33234 The following statement in the SQL is incorrect products_length, products_width, products_height, products_ready_to_ship, The error is showing you that it can't find products_length, because the statement is not referencing a table to look at. Notice, all the other request have a p. or pd. in front of them? If you been running your store for 7 years without updating then this isn't the correct module to use as its for 2.3.+ . The statement you referenced likely was part of another addon you installed and not this particular one. Additionally it could be that your previous version of mysql allowed for minor errors in statements which prevented that statement from failing, but recently an upgrade was performed and now the statement needs corrected. If I have to guess I would say this code products_length, products_width, products_height, products_ready_to_ship needs to be p.products_length, p.products_width, p.products_height, p.products_ready_to_ship which would easily be verifiable by looking at your products table in your database to see if those fields are there. Hope that helps
  6. USPS Rate V4, Intl Rate V2 (official support thread)

    Anybody familiar with why this module wouldn't return Flat Rates even if they are selected? I'm getting rates they are just the exact same as that of the priority mail by weight shipment. Example Priority Mail: $6.35 Flat Rate Box: $6.35 --> where it should be $5.15 Emailed the author but no response in a month. Any insights would be appreciated.
  7. As of 11:45am EST 09/16/2012 I am seeing rates returned.
  8. Header Tags SEO

    Hi Jack Step 6 in the catalog install instructions: ====================================================================================================== 6) In includes/database_tables.php, anywhere before the last ?> ADD: /*** Begin Header Tags SEO ***/ define('TABLE_HEADERTAGS', 'headertags'); define('TABLE_HEADERTAGS_CACHE', 'headertags_cache'); define('TABLE_HEADERTAGS_DEFAULT', 'headertags_default'); define('TABLE_HEADERTAGS_SEARCH', 'headertags_search'); define('TABLE_HEADERTAGS_SILO', 'headertags_silo'); /*** End Header Tags SEO ***/ ====================================================================================================== Think it needs added to that: define('TABLE_HEADERTAGS_KEYWORDS', 'headertags_keywords'); At least mine did. Thanks, Don
  9. Google XML Sitemap SEO

    Didn't realize you both had different versions of the original from Chemo. Either way, I rolled back his, installed yours and everything is perfect. Thanks, yet again. Don
  10. Google XML Sitemap SEO

    Hi Jack Is there a way for the sitemap to be generated using FWRMedia Ultimate SEO URL's instead of the strict Oscommerce path? Google may find it odd to keep submitting URL's that all get 301 redirected. Thanks, Don
  11. Automatically send data feed to Froogle

    Yep you are correct, The sql query wasn't formatted correctly Took a lot of trys but this finally worked Changed the $sql query to $sql = " SELECT concat( '" . $productURL . "' ,products.products_id) AS product_url, products_model AS prodModel, manufacturers.manufacturers_id, products.products_id AS id, products.minorder AS minorder, products_description.products_name AS name, products_description.products_description AS description, products.products_quantity AS quantity, products.products_status AS prodStatus, products.products_weight AS prodWeight, " . $extraFields . " FORMAT( IFNULL(specials.specials_new_products_price, products.products_price) * products.minorder * " . OPTIONS_TAX_CALC . ",2) AS price, CONCAT( '" . $imageURL . "' ,products.products_image) AS image_url, products_to_categories.categories_id AS prodCatID, categories.parent_id AS catParentID, categories_description.categories_name AS catName FROM (categories, categories_description, products, products_description, products_to_categories) left join manufacturers on ( manufacturers.manufacturers_id = products.manufacturers_id ) left join specials on ( specials.products_id = products.products_id AND ( ( (specials.expires_date > CURRENT_DATE) OR (specials.expires_date is NULL) OR (specials.expires_date = 0) ) AND ( specials.status = 1 ) ) ) WHERE products.products_id=products_description.products_id AND products.products_id=products_to_categories.products_id AND products_to_categories.categories_id=categories.categories_id AND categories.categories_id=categories_description.categories_id " . $quotes . " AND categories_description.language_id = " . DEFAULT_LANGUAGE_ID . " AND products_description.language_id = " . DEFAULT_LANGUAGE_ID . " ORDER BY products.products_id ASC "; Added an if statement above the output for the name if ( $row->minorder > 1) { $minorder="(Pack of " . $row->minorder . ")"; } else { $minorder=""; } Then added in the variable into the statement preg_replace($_strip_search, $_strip_replace, strip_tags( strtr($row->name, $_cleaner_array) ) ) . $minorder . "\t" . Many thanks for your time and guidance, and knowledge!
  12. Automatically send data feed to Froogle

    I tried Jack, Just can't figure this one out. I just need to add text to the name title that says Pack of $minorder But I don't understand your coding enough to make it work. I tried adding below this $result=mysql_query( $sql )or die( $FunctionName . ": SQL error " . mysql_error() . "| sql = " . htmlentities($sql) ); while $result=mysql_fetch_array($sql) { $minorder =$row[minorder] } Then changing preg_replace($_strip_search, $_strip_replace, strip_tags( strtr($row->name, $_cleaner_array) ) ) . "\t" . to preg_replace($_strip_search, $_strip_replace, strip_tags( strtr($row->name, $_cleaner_array) ) ) . "(Pack of " . $minorder . ")". "\t" . That just causes a infinite loop. I tried a few others things but I just can't seem to get that $minorder appended to anything. I'm able to use the products.minorder column in the $sql query but not able to use its value anywhere else. Any help is appreciated, Don
  13. Automatically send data feed to Froogle

    That is exactly what I meant, thanks Jack. I'll take a crack a modifing that to include the min-order number. Thanks, Don
  14. Automatically send data feed to Froogle

    Hi Jack or anybody that may know.. Google requires us to modify our listing to show the price per minimum order. So I replaced FORMAT( IFNULL(specials.specials_new_products_price, products.products_price) * " . $taxCalc . ",2) AS price, With FORMAT( IFNULL(specials.specials_new_products_price, products.products_price) * products.minorder * " . $taxCalc . ",2) AS price, This works great. But I'm having trouble finding where the title is getting generated, as I would like the output to be `title` && (pack of `minimum order`) Modifying our actual title wouldn't make sense because they are not sold in packs, you can order 20 or 21, but not 19. For Google display reasons we would like our price we are required to give them to be indicitive of the amount they would receive. Can you help with this? Thanks, Don
  15. [Addon} Modular SEO Header Tags

    Okay, may since I have FWR Ultimate SEO URL's installed with .htacces mods maybe the difference.
  16. [Addon} Modular SEO Header Tags

    Thanks Jim, made the changes for the canonical tags you suggested. I would like to point out that you may still have a duplicate problem with including the $domain in the meta_tag name. $link = tep_href_link( FILENAME_PRODUCT_INFO, 'cPath=' . $cPath_new . '&products_id=' . $products_id, 'NONSSL' ); $meta_tag = '<link rel="canonical" href="' . $domain . '/' . $link . '" />' . PHP_EOL; break; Your varaiable $link seems to be getting the domain via the tep_href_link() so putting the domain in front of the link makes it http//:www.site.com/http://www.site.com least that is my case. I just removed the variable $domain from my files and it appears to be working great. Either way, thank you very much. Don
  17. [Addon} Modular SEO Header Tags

    Hi Jim, I agree with you on the canonical tag thing, my issue is that SEOmoz.org likes those canonical tags when doing reports which I have to turn in. So, if I can put them there correctly I will for the heck of it. Either way thanks again. Don
  18. @@Gergely How I missed that I don't know, thank you very much, Everything seems to be working correctly now.
  19. [Addon} Modular SEO Header Tags

    Just another follow up, I'll look into more but from what I can tell $product_id is not a global since it has no value $cPath_new = tep_get_product_path( $products_id ); $link = tep_href_link( FILENAME_PRODUCT_INFO, 'cPath=' . $cPath_new . '&products_id=' . $products_id, 'NONSSL' ); $meta_tag = '<link rel="canonical" href="' . $link . '" />' . PHP_EOL; $cPath_new = tep_get_product_path( $products_id ); returns empty $link = tep_href_link( FILENAME_PRODUCT_INFO, 'cPath=' . $cPath_new . '&products_id=' . $products_id, 'NONSSL' ); returns no product_id Either way in my case this is only half the problem, I also need FILENAME_PRODUCT_INFO to translate to the SEO URL we have setup. I can't spend much more time on this issue right now, but since the product info page is somewhat absoulte, I can remove the tag from them for now.
  20. [Addon} Modular SEO Header Tags

    Fixed the homepage (index.php) and the Category pages by changing this function in catalog/includes/modules/header_tags/ht_connonical.php if( basename( $PHP_SELF ) == FILENAME_DEFAULT ) { $link = tep_href_link( FILENAME_DEFAULT, 'cPath=' . $cPath, 'NONSSL' ); $meta_tag = '<link rel="canonical" href="' . $domain . '/' . $link . '" />' . PHP_EOL; To: if( basename( $PHP_SELF ) == FILENAME_DEFAULT ) { if ($cPath=='') { $link = tep_href_link( FILENAME_DEFAULT, '', 'NONSSL' ); } else $link = tep_href_link( FILENAME_DEFAULT, 'cPath=' . $cPath, 'NONSSL' ); $meta_tag = '<link rel="canonical" href="' . $link . '" />' . PHP_EOL; While this gets the canonical tag to display correctly given the page I'm on, I'm not sure how its shown if you access the url from a different url since my shop will redirect 301 to the correct url which is great for me. So a catagory page access like http://www. somesite .com/catalog/index.php?cPath=1 may or may not display the correct canonical tag.. for me however that would fire a redirect to the correct page which has the correct canonical tag As for the product_info.php pages.. I'm having trouble but working on it still..
  21. [Addon} Modular SEO Header Tags

    Hi Jim, I just installed the 1.4.3 And found a problem with the Canonical Tag I'm getting Canonical tags like this: Home Page: <link rel="canonical" href="http://www.rubberstore.com/http://www.rubberstore.com/231test/?cPath="> Need ROOT/ROOT/ to just ROOT/ and if on home remove ?cPath= Category Page: <link rel="canonical" href="http://www.rubberstore.com/http://www.rubberstore.com/231test/orings-c-33.html"> Need ROOT gone rest is perfect Products Page: <link rel="canonical" href="http://www.rubberstore.com/http://www.rubberstore.com/231test/product_info.php?cPath=&amp;products_id="> Need first ROOT gone, product info switched to SEO URL, cPath included &amp; products Id included I'll work on it myself but if you have a solution that would be great. I have FWRMedia Ultimate SEO URL's Installed as well.
  22. @@Gergely I have the same issue as Veronica. 1146 - Table 'columb22_231osc.TABLE_MENU' doesn't exist select count(*) as total from TABLE_MENU x left join TABLE_MENU_TEXT y on x.menu_id = y.menu_id where y.language_id = '1' The problem is that Header & Footer Conent is not in my Module Box, (see screen shot) I don't know if we skipped some instructions or what. I have read them many times and do not believe I missed any steps. Somewhere we have to get the module installed but I don't see anywhere how to do that. I want to make sure I don't miss anything so here are the instructions: Additionally I have ran the queries you asked Veronica to: SELECT * FROM `configuration_group` WHERE `configuration_group_title` LIKE '%FILENAME%' SELECT * FROM `configuration` WHERE `configuration_key` LIKE '%MENU%' SELECT * FROM `configuration` WHERE `configuration_key` LIKE '%EXTENDS%' I really appreciate all the work you put into this, I would love to get it working correctly. Thank you very much, Don
  23. Just out of curiosity if anybody runs a shop in the Netherlands if you use http://addons.oscommerce.com/info/3736 Or something else to handle PostNL rates. My setup is pretty simple, just going to have 2 different rates one for Europe countries, and one outside of Europe but I also need 2 services, registered and standard luft / lucht / air mail. I was going to setup using Table Rates for Europe and then force it to use Zone rates for outside of Europe, but this doesn't work because of the 2 different shipping options I need. Any thoughts or advise is much appreciated.
  24. PostNL working with 2.3.1? or what do you use?

    Didn't even think of that, thanks Chris I'll do just that.
  25. Authorize Net AIM Problem

    Hi Joe, We noticed this problem as well. You're thinking exactly what I was that the script is timing out. There is a lot of stuff that happens when the customer processes an order and many lines of items tends to cause extra problems. My thinking was to actually limit the amount of unique items allowed in a basket but haven't had time to try and run any modifications yet. Did you find any solutions to the issue?