Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

ukgoods

Archived
  • Posts

    104
  • Joined

  • Last visited

Everything posted by ukgoods

  1. Is there any way to see what items the dimensional weight code decides to put in each box? I can see the size of each box by turning on the logging feature. But I can't see what items, it actually put in what box. I think this would be great for debugging purposes. Thanks, Donna
  2. Hi, I'm hoping someone can help me. I just got negotiated rate support with UPS. When I turn it on and go to the checkout_shipping page, it works fine. However, the estimated shipping box gives me the following error: upsxml.log 2007-03-29 10:46:59 TimeInTransit 270032: Invalid Destination Postal Code and City 2007-03-29 10:47:00 Rates 111210: The requested service is unavailable between the selected locations. 2007-03-29 10:49:30 TimeInTransit 270032: Invalid Destination Postal Code and City 2007-03-29 10:49:31 Rates 111210: The requested service is unavailable between the selected locations. 2007-03-29 10:50:24 TimeInTransit 270032: Invalid Destination Postal Code and City 2007-03-29 10:50:25 Rates 111210: The requested service is unavailable between the selected locations. 2007-03-29 10:50:30 Rates 110206: Missing/Illegal ShipTo/Address/StateProvCode 9232 Apparently, the estimated shipping code does not take the complete address info, if you are logged in. Any idea how I can fix this? Thanks, Donna Gordon UKGoods.com
  3. I have a contract with UPS for lower air rates. Could someone tell me how to modify this program for air services. I tried the negotiated rates change but it did not work. I would like to multiply all rates (other than Ground and 3 Day Select) by a percentage and return the lower rate. Any help would be very much appreciated. Thanks, Donna
  4. Please disregard my previous post. It was a problem with the Ultimate SEO contribution. FYI, the "Output W3C valid URLs (parameter string)?" string in Ultimate SEO's needs to be set to false. Regards, Donna UKGoods
  5. I am using the Add Multiple Products contribution and it works great EXCEPT if I turn cookies off. Then the add to cart button, adds the items to the cart but loses the session. Any ideas? Thanks, Donna Gordon UKGoods
  6. Supressing the error message if the zipcode is empty makes the most sense. Also, just so you know, I got UPS to work by removing the word "dummy" from the Delivery City field. I also remove the word "dummy" from the company field as 99% of my customers deliver to a residential address. I just left the two quotes in these fields. This is something I have been looking for forever. I have a large amount of customers who don't want to go through creating the account process until they know how much shipping is. I can tell by watching who's online that they come to the site, put items in their shopping cart and then go to the shipping explanation page. After that they leave the site. This contribution solves that problem :) Thanks again, Donna
  7. Is there a way to NOT have the estimates show up if the customer is not registerd and they haven't put their zipcode in yet? I get the following error message when first putting items in my cart. UPS 111210: The requested service is unavailable between the selected locations. If you prefer to use ups as your shipping method, please contact UKGoods via Email. United States Postal Service An error occured with the USPS shipping calculations. If you prefer to use USPS as your shipping method, please contact the store owner. It should not try to contact UPS or USPS unless there is a zipcode there. Thanks, Donna Gordon UKGoods.com PS Love the contribution!!!
  8. Is there somewhere I can see a demo of this before I actually install it? Thanks, Donna Gordon UKGoods.com
  9. Did you ever get this to work right? Thanks, Donna
  10. The executable MUST be in the path. Mine is: /home3/ur/public_html/cgi-bin/pfpro Notice the name of the executabe (pfpro) without any extension. This payment module is a bear to get working but once working is excellent. Keep with it :) Regards, Donna
  11. Change the $product_query_raw to this: $product_query_raw = tep_db_query("select p.products_id, pd.language_id, pd.products_name, pd.products_description, pd.products_url, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_weight, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = pd.products_id and p.products_id = '" . (int)$HTTP_GET_VARS['pID'] . "'"); The creator of the module had extra fields in his query. Regards, Donna Gordon UKGoods.com
  12. I love this module!!!!! Can anyone tell me how to integrate it with the Quick Stock Updater module? Thanks, Donna Gordon UKGoods.com
  13. I ran https://www.ukgoods.com/admin/includes/reset_meta_cache.php from the browser. Here is the product query (from around line 170): $products_query = tep_db_query("SELECT p.products_id, pc.products_id, pd.products_name, pc.categories_id FROM " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " pc WHERE p.products_status='1' and p.products_id = pd.products_id and pc.products_id = p.products_id and language_id = '" . (int)$languages_id . "' and pd.language_id = '" . (int)$languages_id . "' and pc.categories_id = '".$current_category_id."' ORDER BY rand()"); Is this correct? Thanks, Donna
  14. I made the change, reset the meta change and my seo cache and it is still bringing up the inactive items. Any suggestions? Thanks, Donna
  15. I noticed that inactive items are showing up in the meta keywords tag on when displaying all items in a category. Any idea how can I change the query to only get active items? For an example: http://www.ukgoods.com/biscuits-mcvities-c-33_52.html The meta keywords are showing up as: <meta NAME="Keywords" Content="mcvities, mcvities favourites biscuit tin, mcvities fruit shortcake, mcvities plain chocolate hobnobs, mcvities victoria biscuit tin, mcvities hobnobs, mcvities rich tea biscuits, mcvities milk"> The McVities Favourites Biscuit Tin and McVities Victoria Biscuit Tin are specialty Christmas items and are inactive. Thanks, Donna Gordon
  16. I am using a modified version of the MYOB contribution to write my orders to an ascii file. It works perfectly with osCommerce PayPal IPN module except for the order number and the order total. I have placed if (CREATE_SALE_MYOB_TXT_FILE) {include(DIR_WS_INCLUDES . 'bwg_sale.php');} after: $this->after_process(); How can I get the order number and the order total into this file? Thanks, Donna
  17. My existing Google pages are coming up with a "Product not found" message. The urls Goodle has spidered looks like this: www.ukgoods.com/product_info.php/products_id/59 I gather something should be fixed in .htaccess but I am afeered of messing with it :) Any ideas? Also, I would like to that Bobby for all his work. This is a great contribution!!!! Thanks, Donna
  18. When I try to remove a cart with the Recover Cart "Reset" button, I receive the following error: 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 '' at line 1 delete from customers_basket where customers_id= [TEP STOP] It appears that this line in the recover_cart_sales.php is not working properly: $reset_query_raw = "delete from " . TABLE_CUSTOMERS_BASKET . " where customers_id=$HTTP_GET_VARS[customer_id]"; Would someone please tell me how to fix this? Thanks, Donna Gordon UKGoods
  19. Does anyone know how to sort the product rows by model number in the batch print contribution? It would make it much easier for my pickers if the items were sorted by model numbers. Thanks, Donna Gordon UKGoods.com
  20. The TimeInTransit part only works with shipments inside the US. Search for the following line and comment it out: $this->timeintransit = $this->_upsgetTime(); Regards, Donna Gordon
  21. I am confused about the OSC Afilliate contribution. I would like my affiliates to place one link on their site like: UKGoods.com - All your favourite British foods here in America This link would take the customer to my site and any order they placed, the referring website would get a commission. I see that I can create links for each product but I do not want to do that. Is the OSC Affiliate contribution the right one for me? I will probably be having multiple websites referring to me in the near future and want to do this right. Thanks, Donna Gordon UKGoods.com
  22. I had the same issue with the UPS XML module. After taking out CODE ® and CODE <sup>SM</sup> from includes/languages/english/modules/shipping/upsxml.php it works fine. For example change this line to: CODE define 'MODULE_SHIPPING_UPSXML_SERVICE_CODE_US_ORIGIN_12', 'UPS 3 Day Select®'); CODE define 'MODULE_SHIPPING_UPSXML_SERVICE_CODE_US_ORIGIN_12', 'UPS 3 Day Select'); You should take out all the instances of ® and <sup>SM</sup>. Hope this helps.
  23. This is a really nice contribution! Is there any way to get the shipping estimate to show up in the shopping cart that shows in column_right? Thanks, Donna Gordon UKGoods.com
  24. Have you run the tests which come with the SDK? If the SDK outside of OSCommerce is not working, it will not work inside. Regards, Donna Gordon UKGoods
×
×
  • Create New...