Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

ambishop

Archived
  • Posts

    13
  • Joined

  • Last visited

Profile Information

  • Real Name
    Martin Bishop

ambishop's Achievements

  1. I recommend using an older version than V2.3 pbor1234's v2.3 seems to have something strange going on. I had troubles as well. I am running V2.23 and it works fine. You can also add the cron job support to the older versions.
  2. Warning: implode() [function.implode]: Bad arguments. in XXXX/admin/includes/classes/recover_cart_sales.php on line 238 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 ') and date_purchased >= "0"' at line 1 select orders_id, orders_status from orders where (customers_id = 266 OR customers_email_address like "[email protected]" or customers_name like "XXX") and orders_status NOT IN () and date_purchased >= "0" [TEP STOP]
  3. Paul, thanks for updating this contribution but I am having issues with your classes/recover_cart_sales.php file. I fixed one issue but right now I can not see to figure out the issue here Call to undefined function: _getcustomersessions() Can you make sure the classes/recover_cart_sales.php file is the most updated
  4. When first installing this contribution, I personally struggled with Category file names with "certain names" not listing the contents of the products within the group. The simple fix was to change the product category names to something else. Not sure if this is a bug with this contribution or my others, but the simple fix was to just change the category name to something else. If your products do not show up after installing this contribution Try changing the Category name to something else and testing. For Example: The category name "Popular Items" showed No products found when clearly there were items in the Category, but changing the Name to "Best Sellers" showed all products. Very odd issue, but something to check if you are not able to see your products
  5. Please note: When using this contribution with one such as Product Options With Details that provide html links for details, you must change the option details link to something other than .html For some reason the RewriteRule in .htaccess will mix things up and you will get a product not found on a detail link. For example the link: http://www.bimmernav.com/store/catalog/bmw...03-item-90.html has javascript popup details on the options and were previously names xyz.html and clicking the links returned a product not found error as a result of the rewriterule The simple fix is to change all links under the .htacess folders to .htm This also applies to javascript popups in such as PHPOnline Live Chat. File name extensions should not be the same as used in other files.
  6. Try to add this to your .htaccess <IfModule mod_setenvif.c> <IfDefine SSL> SetEnvIf User-Agent ".*MSIE.*" \ nokeepalive ssl-unclean-shutdown \ downgrade-1.0 force-response-1.0 </IfDefine> </IfModule>
  7. I had issues with product reviews working properly and made some changes to the following files to fix. Feel free to post this as a fix. Change .htaccess and includes/classes/seo_class.php file name rewrites for reviews and reviews info FROM .htaccess RewriteRule ^(.*)-pr-([0-9]+).html$ product_reviews.php?products_id=$2&%{QUERY_STRING} and RewriteRule ^(.*)-pri-([0-9]+).html$ product_reviews_info.php?products_id=$2&%{QUERY_STRING} AND seo_class.php 'products_id_review' => '-pr-', 'products_id_review_info' => '-pri-', TO: RewriteRule ^(.*)-review-([0-9]+).html$ product_reviews.php?products_id=$2&%{QUERY_STRING} RewriteRule ^(.*)-reviewinfo-([0-9]+).html$ product_reviews_info.php?products_id=$2&%{QUERY_STRING} AND 'products_id_review' => '-review-', 'products_id_review_info' => '-reviewinfo-', See details below .htaccess Options +FollowSymLinks RewriteEngine On RewriteBase /directory/ RewriteRule ^(.*)-p-(.*).html$ product_info.php?products_id=$2&%{QUERY_STRING} RewriteRule ^(.*)-c-(.*).html$ index.php?cPath=$2&%{QUERY_STRING} RewriteRule ^(.*)-m-([0-9]+).html$ index.php?manufacturers_id=$2&%{QUERY_STRING} RewriteRule ^(.*)-pi-([0-9]+).html$ popup_image.php?pID=$2&%{QUERY_STRING} RewriteRule ^(.*)-t-([0-9]+).html$ articles.php?tPath=$2&%{QUERY_STRING} RewriteRule ^(.*)-a-([0-9]+).html$ article_info.php?articles_id=$2&%{QUERY_STRING} RewriteRule ^(.*)-review-([0-9]+).html$ product_reviews.php?products_id=$2&%{QUERY_STRING} RewriteRule ^(.*)-reviewinfo-([0-9]+).html$ product_reviews_info.php?products_id=$2&%{QUERY_STRING} RewriteRule ^(.*)-i-([0-9]+).html$ information.php?info_id=$2&%{QUERY_STRING} seo_class.php //ojp lPath -links- definition $this->reg_anchors = array('products_id' => '-p-', 'cPath' => '-c-', 'manufacturers_id' => '-m-', 'pID' => '-pi-', 'tPath' => '-t-', 'articles_id' => '-a-', 'products_id_review' => '-review-', 'products_id_review_info' => '-reviewinfo-', 'info_id' => '-i-', 'lPath' => '-links-' ); Not sure why this worked but it did for me You can also change the "p" to "item" and the "c" to index to make better looking URLs (in my opinion) I also noticed an extra space in case ( $page == FILENAME_PRODUCT_REVIEWS ): and case ( $page == FILENAME_PRODUCT_REVIEWS_INFO ): which I changed to ( $page == FILENAME_PRODUCT_REVIEWS): and ( $page == FILENAME_PRODUCT_REVIEWS): but do not think this has ant effect on the issue I was having with reviews not being displayed
  8. thanks for the headsup!!! good thing that was mostly testing
  9. :lol: :lol: :lol: :lol: :lol: :lol: :lol: :lol: :lol: IT WORKS! I knew I stayed up too late last night to figure this thing out. thanks Ski for your work on this contribution!!!! Plus thanks for finding my error. I now can "ship to areas outside the US" at least according to Google Checkout. I used my code of and changed the <address-filters> tag to the <shipping-restrictions> tag $data .= ' <shipping-methods>' . $eol; $data .= ' <flat-rate-shipping name="' . htmlentities($order->info['shipping_method']) . '">' . $eol; $data .= ' <price currency="' . $order->info['currency'] . '">' . number_format($order->info['shipping_cost'], 2, '.', '') . '</price>' . $eol; $data .= ' <shipping-restrictions>' . $eol; $data .= ' <allowed-areas>' . $eol; $data .= ' <world-area/>' . $eol; $data .= ' </allowed-areas>' . $eol; $data .= ' </shipping-restrictions>' . $eol; $data .= ' </flat-rate-shipping>' . $eol; $data .= ' </shipping-methods>' . $eol; } I am really excited about this. If you want to see a working cart, check out http://www.bimmernav.com/store/catalog/ Martin
  10. Good point. I missed that line in my code Note: If you are using flat-rate or pickup shipping methods, you can modify Examples 1 and 2 to work with your shipping methods by replacing the <address-filters> tags with <shipping-restrictions> tags. I will try it out tonight
  11. I tried modifying the google.php file and am still not getting the shipping for international customers to work. Here is what I was using $data .= ' <shipping-methods>' . $eol; $data .= ' <flat-rate-shipping name="' . htmlentities($order->info['shipping_method']) . '">' . $eol; $data .= ' <price currency="' . $order->info['currency'] . '">' . number_format($order->info['shipping_cost'], 2, '.', '') . '</price>' . $eol; $data .= ' <address-filters>' . $eol; $data .= ' <allowed-areas>' . $eol; $data .= ' <world-area/>' . $eol; $data .= ' </allowed-areas>' . $eol; $data .= ' </address-filters>' . $eol; $data .= ' </flat-rate-shipping>' . $eol; $data .= ' </shipping-methods>' . $eol; based on this example http://code.google.com/apis/checkout/devel...ml#xml_examples
  12. here is an update from Google to get rid of the stupid issue on International shipment and the ERROR that shows when a customer selects a country outside the US. The issue is that I have tried to change google.php to include the <world-area/> tag but I can not get it to work correctly. I get the cart correct, but Google still shows my store does not ship to other countries (which is BS) Google Checkout world area support GoogleCheckoutPro Google employee View profile (1 user) More options May 10, 5:28 pm From: GoogleCheckoutPro <[email protected]> Date: Thu, 10 May 2007 22:28:08 -0000 Local: Thurs, May 10 2007 5:28 pm Subject: International Availability for Buyers Forward | Print | Individual message | Show original | Report this message | Find messages by this author Hi Everyone, Since Google Checkout was recently made available to merchants in the United Kingdom, we wanted to take the opportunity to let you know about international availability to your buyers. Specifically, we've noticed that both merchants and buyers believe orders can only be shipped to buyers in the United States and the United Kingdom. To clarify, Google Checkout supports international buyers with billing addresses in over 150 countries! Orders may be shipped internationally wherever Google Checkout is available. To see a list of these locations, please visit: http://checkout.google.com/support/bin/ans...py?answer=48115 Buyers with billing addresses in any of these countries can make purchases with Google Checkout. One thing to note is the ability to ship to these countries depend on the shipping options provided by the individual merchant. If the buyer makes a purchase in a supported billing location, orders may be shipped internationally as long as the merchant offers the option. Keep in mind that as a merchant, if you are integrated via the Google Checkout API, the ability to ship internationally needs to be updated. You must specify in the shopping cart that international shipping is offered by using the <world-area\> tag. You can learn more about this tag in the XML API Developer's Guide here: http://code.google.com/apis/checkout/devel...#tag_world-area Although this is the XML API Developer's Guide, if you're HTML API enabled, you can easily convert an XML cart to an HTML cart. To learn how, please click on the link below. It will redirect you to a post in the Google Checkout Developer's Forum: http://groups.google.com/group/google-chec...leshooting/br... Also, please note that all orders are billed in US dollars if a buyer places an order with a U.S. merchant and billed in Great Britain pounds if a buyer places an order with a U.K. merchant. Happy Shopping, Google Checkout Team
×
×
  • Create New...