Jump to content


  • Content count

  • Joined

  • Last visited

Everything posted by stubbsy

  1. stubbsy

    Typical "How to" questions

    How to set up multiple stores with different domain names and shared admin
  2. Hi, I have installed this and have it working ok as far as I can see from the Tag Assistant but my product values are all 0.00 as you can see <script type="text/javascript"> var google_tag_params = { ecomm_prodid: '4102', ecomm_pagetype: 'product', ecomm_totalvalue: '0.00' }; </script> My site is http://www.coastwatersports.com/ you can check any product they are all 0.00 Any idea whats up? Thanks Dave
  3. stubbsy

    Request Product Reviews

    Thanks Jim for an excellent addon. I've just backdated it so that any orders from the past 6 weeks will get emailed and I have reviews rolling in as we speak! Much appreciated Dave
  4. stubbsy

    Request Product Reviews

    Thanks for that, sorted :)
  5. stubbsy

    Request Product Reviews

    Hi there, I've just installed this and have it working but I'd like to send it to customers who have ordered in the last 30 days. At the moment, as per the instructions, all orders have a reminder_set status of 1 What I want to do it make that 0 for orders < 30 days old So something like this UPDATE orders SET reminder_sent = 0 where last_modified <= date/ time Any ideas how to finish it off :) Thanks Dave
  6. stubbsy

    RSS News

    I just popped it into google and it seems its a known issue with rss and wordpress Here is the fix incase anyone else is using wordpress as their feed source http://www.malcolmcoles.co.uk/blog/wordpress-smart-quotes/
  7. stubbsy

    RSS News

    Hi Burt, I just typed it into wordpress and thats what it came out with when i added the feed Maybe theres a setting for it, I'll take a look Thanks Dave
  8. stubbsy

    RSS News

    Hi Jack, If you're around sometime I've just installed this on my hompage and have a problem with wierd / special characters and I wondered if you could help? The feed is coming from my wordpress blog here http://www.coastwatersports.com/blog/feed/ And I've put it on the bottom of my homepage here http://www.coastwatersports.com/ The problematic title of the feed post is The sunshine’s here and I need some new sailing clothing! and it gets translated as The sunshine’s here and I need some new sailing clothing! There's also another one below Our Gul Bodyboards don’t come with the... Any ideas? Thank you Dave
  9. stubbsy

    Amazon/eBay interface?

    Hi, I've used this for a couple of years only on eBay and overall it works great, I have a heavily modified store with attributes stock as one of the major differences and magnalister worked with it fine. During that period I had a few issues with stuff on the site going out of stock and ebay not being updated to match due to problems with the inventory not being synced. Magnalister host the inventory themselves and somehow a lot of the products we had listed through magnalister had got deleted from their database, hence them going out of sync. But apart from that you can easily upload as much as you want and if you set ebay to repeat at the end of the listing period then you can pretty much forget about it. The orders come through as if they were done on the oscommmerce site and on ebay everything gets updated when you mark orders updated on the site. Overall, despite the problems, i would highly recommend it Hope that helps Dave
  10. stubbsy

    [CONTRIBUTION] PDF Customer Invoice

    For anyone getting the error "FPDF error: Some data has already been output, can't send PDF file" none of the fixes in this thread worked for me and eventually I found this fix which worked! http://forums.oscommerce.com/topic/379324-fpdf-error-some-data-has-already-been-output-cant-send-pdf-file/ Hope that helps someone!
  11. stubbsy

    No Paypal button with Paypal Standard instal

    Did you ever find a paypal express addon that automatically creates the account for the customer? Nearly every website I buy stuff on using paypal completes that info for me and I find it hard to believe that there isnt one knocking around yet for osc. we get complaints from customers that they shouldnt have to fill in the create account form when buying stuff with paypal as paypal already has all that info Cheers Dave
  12. ignore that last request, i'm not sure what i was doing wrong but its working fine now :)
  13. Hi all, does anyone know how to make the featured products appear on more than 1 row? Thank you Dave
  14. stubbsy

    AJAX Attribute Manager support

    I have a question about how this functions with QT Pro, which I hope someone can help with... I sell for example a race kit made up of a jersey, pants and gloves. Jerseys range from S - XXL Pants from 28 - 38" and gloves from S - XXL Now that's quite a few options. What I thought I would be able to do with this was to put a quantity next to each item. e.g. Jerseys S = 1 M =10 L = 9 XL = 11.. etc then the same with pants 28" = 5 30" = 6...etc Gloves S = 3 M = 5...etc and so on. But all I seem to be able to do it to pair everything together so I have to enter Jersey Pants Gloves S = 1 28=1 S=1 and I have to try and think of every possible combination that a customer might select. Is this how its supposed to work? Any advice appreciated :) Dave
  15. stubbsy

    AJAX Attribute Manager support

    Thank you very much, hard to believe that this functionality was already there :) Much appreciated Dave
  16. stubbsy

    NEW! Complete Order Editing Tool!

    Hi, I have server error when I add RusNNs' update for QT Pro which relates to his update for qtpro This section causes a 500 server error REPLACE WITH if (ORDER_EDITOR_USE_QTPRO == 'true') { if (isset($_POST['add_product_options'])) { foreach($_POST['add_product_options'] as $option_id => $option_value_id) { $products_stock_attributes[] = $option_id . '-'. $option_value_id; } // for loop sort($products_stock_attributes, SORT_NUMERIC); // Same sort as QT Pro stock $products_stock_attributes = implode($products_stock_attributes, ','); } } $sql_data_array = array('orders_id' => tep_db_prepare_input($oID), 'products_id' => tep_db_prepare_input($add_product_products_id), 'products_model' => tep_db_prepare_input($product['products_model']), 'products_name' => tep_db_prepare_input($product['products_name']), 'products_price' => tep_db_prepare_input($product['products_price']), 'final_price' => tep_db_prepare_input(($product['products_price'] + $AddedOptionsPrice)), 'products_tax' => tep_db_prepare_input($products_tax), 'products_quantity' => tep_db_prepare_input($_POST['add_product_quantity']), 'products_stock_attributes' => tep_db_prepare_input($products_stock_attributes)); tep_db_perform(TABLE_ORDERS_PRODUCTS, $sql_data_array); The first section causes the issue. Any ideas? Thanks Dave
  17. stubbsy

    AJAX Attribute Manager support

    Just a suggestion.. would it be possible to have a text entry box for the sort order as well as the up and down arrows? The reason being: on existing older products which don't have sort orders, when you add a new attribute it creates a sort order which is all out of sync. It is quite easy to spend 20 minutes or so moving options up and down into the correct order. If there was a text entry box and you just popped in the numbers then it would be a bit quicker :) Like I say this is just a suggestion as I'm not clever enough to do it myself :D Dave
  18. stubbsy

    Which Paypal Express Module to use?

    Hi, could anyone suggest a paypal express module which works well? I've been using the certified one, but its pretty basic and had some issues. So I wanted to know what anyone else would recommend? Ideally I would like a but more back end functionality than just taking the money, if that's possible? Thanks Dave
  19. stubbsy

    Which Paypal Express Module to use?

    Hi Chris, Maybe i should have said that I'm using 2.2? A quick search shows around half dozen different express modules, as well as the 'certified' one there are 'official' paypal ones. There are others, some of them appear to give functionality to hold 'address not verified' orders, some say that you can process refunds etc from the back end of osc e.g. We just find it a pain in the bottom to to refunds etc on part orders as you have to log into paypal to do it, so I was wondering if there was a better way which i was missing? All the best Dave
  20. stubbsy

    Paypal Express and Shipping Override Issue

    Try replacing the code with this: // load the selected shipping module require(DIR_WS_CLASSES . 'shipping.php'); $shipping_modules = new shipping($shipping); require(DIR_WS_CLASSES . 'order_total.php'); $order_total_modules = new order_total; } }
  21. stubbsy

    Sort Products By Dropdown

    Just sorted it, I had other contributions installed which meant that my product listing headings were not in the 'standard' osc sort order. I just rearranged these back to the default 'out of the box' sort order and it fixed my 1064 error. This is what I have Display Product Image 1 Display Product Manufaturer Name 2 Display Product Name 3 Display Product Price 4 Display Buy Now column 5 Product Recent Sales 7 Hope that helps someone Dave
  22. stubbsy

    Sort Products By Dropdown

    Hi all, just installed this and get a 1064 error when I try and select either of the sort by price options (the others work) I've checked through the thread and made any fixes suggested regarding sort order but still have the problem this is the 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 'limit 0, 30' at line 1 select p.products_image, m.manufacturers_name, pd.products_name, p.products_recent_sales, p.products_id, p.products_recent_sales, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status = '1' AND s.stores_id = '1', s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status = '1' AND s.stores_id = '1', s.specials_new_products_price, p.products_price) as final_price from products_description pd, products_to_categories p2c, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join specials s on p.products_id = s.products_id and s.stores_id = '1' INNER JOIN products_to_stores p2s ON p.products_id = p2s.products_id where p2s.stores_id = '1' and p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '4437' order by limit 0, 30 [TEP STOP] any ideas? Thanks Dave
  23. stubbsy

    One Page Checkout Support

    Hi there, just having my first play around with this and notice that on IE9 all the pop ups dont work properly. They're all minimised and have to be stretched. Anyone else have the same problem? Also if i try and edit an address it says at the end that that was a problem saving the details but if i cancel and return to the address book then the change has been made. Are there any known solutions for these? Thanks Dave
  24. Hi, a minor query, on any attributes that have a price next to them is shows the price both with and without vat... e.g. "Small (+8.33)(+10.00)" Any ideas why this is, just the price including tax (as standard in osc) would be fine. 2 prices just causes confusion thanks Dave
  25. stubbsy

    Order Tracker New Contrib....

    Hi, I'm trying to get the Orders by Zone file to order by count (number of orders) but whatever I try doesnt work. I've tried adding ORDER BY count DESC to the query but no luck. I cant see why it wouldnt work. $location_pending_query = tep_db_query("select count(*) as count from " . TABLE_ORDERS . " where customers_state = '". $customers_location['zone_name'] ." ' and date_purchased >= '$year-$startmonth-01 00:00:00' and date_purchased <= '$year-$endmonth-31 11:59:59' ORDER BY count DESC"); any ideas? Thanks Dave