Jump to content


  • Content count

  • Joined

  • Last visited

  1. I just installed this, and my URLs are coming up weird. My html links are all output as such: domain.com/-p-[productid].html There's no product name. Does anyone know why? Thanks.
  2. jonlai9

    Simple Price Break Contribution

    I need some help guys! I'm getting the right (discounted) subtotal, but the line total shows the regular price. When you checkout, the line totals are used, so right now the customer is not getting any discount. What's the solution to this problem?
  3. jonlai9

    Official PayPal IPN Support Thread

    Some more information.. bump Lately, some of my orders have been acting wierd. After I changed their order status to processing or shipped, these wierd orders will bounce back to pending every few hours. If I put them back to their correct status, they'll go back to pending a few hours later - it's very annoying. Does anyone know what's making it do this? FYI, all the wierd orders I'm talking about were paid via Paypal. The problem started with orders coming in from July 10th, but strangely, one of the orders on the 11th do not act this way. Does anyone also know which PHP page has code that might be affecting this? Please help, thanks!
  4. jonlai9

    Official PayPal IPN Support Thread

    Hey guys, something wierd's going on. I use Paypal solely for my osCommerce website. Lately, some orders have been acting up in the sense that when I chnaged the order status to either processing or delivered, it goes back to pending within a few hours. I know it has something to do with the Paypal IPN because everytime it goes back to pending it gives me that Paypal payment notice, something like "PayPal IPN Verified [Completed (Unverified; $xxx.xx)] " Anyone know what's wrong?
  5. jonlai9

    Automatically send data feed to Froogle

    Hey guys, please advise! I've been using this contrib for a year now, and it's been working great, but today, I just listed new products on my catalog and when I tried making the feeder file, I got this error: : SQL error The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay| sql = SELECT concat( 'http://www.emvee.ca/product_info.php?currency=USD&products_id=' ,products.products_id) AS product_url, products_model AS prodModel, products_weight, manufacturers.manufacturers_name AS mfgName, manufacturers.manufacturers_id, products.products_id AS id, products_description.products_name AS name, products_description.products_description AS description, products.products_quantity AS quantity, products.products_status AS prodStatus, FORMAT( IFNULL(specials.specials_new_products_price, products.products_price) * 1,2) AS price, CONCAT( 'http://www.emvee.ca/images/' ,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 = 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 ORDER BY products.products_id ASC Anyone know what's wrong and how I can fix it?
  6. jonlai9

    Seach Engine Friendly URL Support

    Is there a "find" and "replace" file available for v1.10? I can't figure out what to dow tih the .diff file..
  7. jonlai9

    Payment method fee 2.1

    How can I get this working with Paypal?
  8. jonlai9

    Newsletter & Subscribtion for MS2

    Does anyone know how to get this working with the NEWSLETTER PRODUCTS contrib?
  9. jonlai9

    Canada Post Module Postal Code Illegal

    Anyone know how to integrate a checkbox to add 1% for insurance?
  10. jonlai9

    Newsletter products, HTML email

    I'm using that code. The image is not appearing, it's X-ed out. When I check the properties, it just links to my /images/ directory, it doesn't link to the name of the file.jpg
  11. jonlai9

    Newsletter products, HTML email

    Thanks! The prices and slashed prices where special price is evident is now appearing, however, the product's picture is appearing as it's caption in words, so now instead of pic+product name, I simply have the product name appear twice. How would you fix this?
  12. jonlai9

    Newsletter products, HTML email

    Okay, now it works, but I get a screen with each product being $0.00... no product name, no product image... something wrong?