Jump to content

bbott

Members
  • Content count

    51
  • Joined

  • Last visited

Everything posted by bbott

  1. bbott

    Header Status Handler

    Hey Jack, great contribution. Exactly what I was looking for. Thank you!
  2. Has anyone gotten SEO URLs to work with extra product image addons? (i.e. http://addons.oscommerce.com/info/1289) I tried modifying the code (examples below, added code is in RED), but it doesn't seem to work. HTACCESS: RewriteRule ^(.*)-pei-(.*).html$ popup_extra_image.php?peiID=$2&%{QUERY_STRING} SEO.CLASS.PHP: //ojp FILENAME_LINKS $seo_pages = array(FILENAME_DEFAULT, FILENAME_PRODUCT_INFO, FILENAME_POPUP_IMAGE, FILENAME_POPUP_EXTRA_IMAGES, ================================================================================ $this->reg_anchors = array('products_id' => '-p-', 'cPath' => '-c-', 'manufacturers_id' => '-m-', 'pID' => '-pi-', 'peiID' => '-pei-', ================================================================================ case 'peiID': switch(true){ case ($page == FILENAME_POPUP_EXTRA_IMAGES): $url = $this->make_url($page, $this->get_product_name($p2[1]), $p2[0], $p2[1], '.html', $separator); break; default: $container[$p2[0]] = $p2[1]; break; } # end switch break; I searched, but haven't had any luck finding my answer.
  3. bbott

    Scrambled Order Numbers

    I'm surprised nobody else has had this issue or has a fix being that PayPal standard is such a popular addon.
  4. bbott

    Scrambled Order Numbers

    Please PM me if you have a solution. Thank you. PayPal Standard Addon: http://addons.oscommerce.com/info/5655 Scrambled Order Addon: http://addons.oscommerce.com/info/2499 I believe you only need to udpate the code in the paypal PHP file. Thanks!!!! :)
  5. Agreed, and apologies. Thanks very much for updating the links, much appreciated.
  6. bbott

    Scrambled Order Numbers

    Has anyone gotten this module to work with paypal_standard.php? I tried and I'm unable to have the scrambled order number sent in the order confirmation email when the payment is made through the paypal_standard.php module. I made the below code modifications in paypal_standard.php, what else am I missing? // >>> BEGIN SCRAMBLED_ORDER_NUMBER require('includes/functions/scrambled_order_num.php'); // <<< END SCRAMBLED_ORDER_NUMBER // lets start with the email confirmation // >>> BEGIN SCRAMBLED_ORDER_NUMBER $scrambled_order_num = randomise_order_num($insert_id); // <<< END SCRAMBLED_ORDER_NUMBER $email_order = STORE_NAME . "\n" . EMAIL_SEPARATOR . "\n" . // >>> BEGIN SCRAMBLED_ORDER_NUMBER EMAIL_TEXT_ORDER_NUMBER . ' ' . $scrambled_order_num . "\n" . EMAIL_TEXT_INVOICE_URL . ' ' . tep_href_link(FILENAME_ACCOUNT_HISTORY_INFO, 'order_id=' . $scrambled_order_num, 'SSL', false) . "\n" . // <<< END SCRAMBLED_ORDER_NUMBER EMAIL_TEXT_ORDER_NUMBER . ' ' . $order_id . "\n" .
  7. Would it be possible for a moderator or admin to comment out my domain name from my posts on page 338 of this thread? Thank you.
  8. Hey Jack, I'd be willing to pay you if you can help me figure this out. I'm trying to solve a duplicate content issue with Google that's hurting my website. It looks like the code is redirecting to the correct SEO URL when I add a '-27' at the end of the URL, but it does not when I enter a '_27'. Is there an easy modification to the code to do the same for underscores? Example: (manipulated URL with hyphen) littmann-classic-stethoscope-p-131-27.html (redirects to correct SEO URL) littmann-classic-stethoscope-p-131.html However the code is not redirecting to the correct SEO URL when I add a '_27' at the end of the URL. Example: (manipulated URL with underscore) littmann-classic-stethoscope-p-131_27.html (does not redirect) littmann-classic-stethoscope-p-131-27.html I honestly don't know how Google got the underscore URLs in their index, I'm still researching. I figure I can fix the issue by validating the URL which the addon seems to already be doing for hyphens but not underscores? Any thoughts?
  9. Is it really broken code though? The issue exists in the core version of oscommerce? http://demo.oscommerce.com/product_info.php?products_id=27_22 http://demo.oscommerce.com/product_info.php?products_id=27
  10. Jack, this doesn't seem to be a template issue, it's occuring on the base install as well. Examples below: http://demo.oscommerce.com/product_info.php?products_id=27_22 http://demo.oscommerce.com/product_info.php?products_id=27_23 http://demo.oscommerce.com/product_info.php?products_id=27_24 http://demo.oscommerce.com/product_info.php?products_id=27_25 http://demo.oscommerce.com/product_info.php?products_id=27_26 http://demo.oscommerce.com/product_info.php?products_id=27_27 Is there anyway to update the SEO URL code to look for a trailing '_" after the category ID and correct the URL? It appears to be correcting if there is a trailing '-', but not a trailing '_'. For example (this works): littmann-classic-stethoscope-p-131-27.html REDIRECTS TO THE CORRECT URL: littmann-classic-stethoscope-p-131.html This does not: littmann-classic-stethoscope-p-131_27.html DOES NOT REDIRECT TO THE CORRECT URL: littmann-classic-stethoscope-p-131.html
  11. You're right, I turned off SEO URLS and the error still persists. Do you know what PHP file the issue may reside in? I'll open up another topic in the general forum, but thought you may be able to point me in the right direction to troubleshoot. My store is heavily modified unfortunately. EDIT: Something interesting I noticed.... I can change the numerical value after the underscore '_' to any value and the URL works. For example: littmann-master-classic-stethoscope-p-121_22.html littmann-master-classic-stethoscope-p-121_23.html littmann-master-classic-stethoscope-p-121_24.html littmann-master-classic-stethoscope-p-121_25.html littmann-master-classic-stethoscope-p-121_26.html littmann-master-classic-stethoscope-p-121_27.html HOWEVER! This issue also exists probably on all OSCOMMERCE storefronts. I just tested on the demo store, see below: http://demo.oscommerce.com/product_info.php?products_id=27_22 http://demo.oscommerce.com/product_info.php?products_id=27_23 http://demo.oscommerce.com/product_info.php?products_id=27_24 http://demo.oscommerce.com/product_info.php?products_id=27_25 http://demo.oscommerce.com/product_info.php?products_id=27_26 http://demo.oscommerce.com/product_info.php?products_id=27_27 Wonder if there is a way to fix this.... I'm still curious why the SEO URL is not showing up for the product URLs that are in the cart. They're using the product_info.php?products_id=121 format...
  12. Interesting... so I did some more digging into this issue. Here is what else I have been able to find out. The SEO URLs are not working on my shopping_cart.php file. If you add the product (Product ID 130) to the shopping cart, the URL to click back into the product is as follows: mystethoscope.com/product_info.php?products_id=130{txt_27}{5}71 I'm guessing this has something to do with this URL mystethoscope.com/littmann-classic-infant-stethoscope-p-130_27.html and how it's working with the '_27'. Any ideas?
  13. www dot myste[remove]thoscope.com[slash]littmann-classic-infant-stethoscope-p-130.html www dot myste[remove]thoscope.com[slash]littmann-classic-infant-stethoscope-p-130_27.html Thanks in advance for your help, Jack.
  14. I have an issue, Google has reported duplicate content for my website via Webmaster Tools. Somehow it indexed a page that contained an underscore and numerical value at the end of the URL, see example below. How do I fix the below scenario? Correct: http://www.website.com/product-one-p-130.html Duplicate (does not redirect to the correct link): http://www.website.com/product-one-p-130_27.html
  15. bbott

    Google XML Sitemap SEO

    I just re-uploaded the latest files and re-ran the update. The category and product count updated, not sure what the issue was but it seems to be resolved! :)
  16. bbott

    Google XML Sitemap SEO

    Hi Jack, great contribution. My install worked fine the first time, however for some reason it's only adding 150 max products to my sitemapproducts.xml. My sitemapcategories.xml seems to cap at 50. Any ideas why it's capping the number of products/categories? I added additional products and categories today, and the count is still at 150 and 50, it definitely does not seem to be updating. When I run /googlesitemap/index.php from my website, I get the below output (no errors): Write /home/web/public_html/sitemapproducts.xml Generated Google Product Sitemap Successfully Write /home/web/public_html/sitemapcategories.xml Generated Google Category Sitemap Successfully Write /home/web/public_html/sitemapindex.xml Generated Google Sitemap Index Successfully CONGRATULATIONS! All files generated successfully.
  17. bbott

    QBI Quickbooks Import

    Anyone? Just paid $400 for quickbooks -- hope I can use it w/ oscomerce!
  18. bbott

    QBI Quickbooks Import

    Hey All, I installed this module w/o any issues, but I'm receiving an error when I attempt to export my sales. 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Estimated Delivery Date'>EDD: March 06, 2007' AND so.qbi_shiposc_car_c' at line 1 SELECT * FROM qbi_shiposc AS so, qbi_shiposc_shipqb AS soqb, qbi_shipqb AS sqb WHERE qbi_shiposc_car_text=' Shipping' AND qbi_shiposc_serv_text='UPS Ground, EDD: March 06, 2007' AND so.qbi_shiposc_car_code=soqb.qbi_shiposc_car_code AND so.qbi_shiposc_serv_code=soqb.qbi_shiposc_serv_code AND sqb.qbi_shipqb_refnum=soqb.qbi_shipqb_refnum [TEP STOP] I realize it's an issue w/ my database, but I can't see what is wrong? Any help is appreciated. Thanks, Brian
  19. bbott

    [Contribution] Purchase Order V2.3

    I figured a fix... in po.php replace all occurences of po_number with purchase_order_number Then in checkout_process.php change the one occurence of po_number to purchase_order_number :)
  20. bbott

    [Contribution] Purchase Order V2.3

    If anyone can figure this out i'll paypal them $20... a little incentive. :) I need to be able to store that PO number the customer enters, otherwise this mod is no good to me :(
  21. bbott

    [Contribution] Purchase Order V2.3

    Another comment to add.... the instructions say to edit: catalog/admin/includes/classes/orders.php well the newest version of oscommerce has order.php not orders.php plural.... was this a typo i'm assuming?
  22. bbott

    Paypal IPN contribution 2679 Paypal logo & link

    "Paypal (credit card / debit)" is in a language file.... something like this... catalog >> includes >> language >> english >> paypalIPN You can input graphics if you want by editing that file, I wouldn't put the giant paypal image there though... Also, make sure you don't use any quotes ("') in the code you input there... Good luck! :)
  23. bbott

    [Contribution] Purchase Order V2.3

    Noticed you guys let his question slip. I am having the same issue here.... it passes the PO number to the checkout confirmation screen, but does not seem to be writing it to the database. I manually checked my mySQL database and the field is blank.... Any ideas? I really need to get this fixed ASAP, otherwise I have uninstall this mod. Thanks in advance!! Brian Brian@eWebDevelopment.net
×