Jump to content


  • Content count

  • Joined

  • Last visited

Profile Information

  1. And I'm talking to myself again! But I've been busy finding stuff out which might interest others in the future, like how to sort a drop-down list and how to move the drop-down list over above the Add To Cart button, so they are more visible - both of these fixes apply only to stores with QT Pro installed, as the file that gets changed is a QT Pro file. I found the fix for the sorting of attributes here. But you don't need to install the add-on. Here are "MikeySwede"s instructions: In catalog/includes/classes/pad_base.php Find this: $products_options_query = tep_db_query("select pov.products_options_values_id, pov.products_options_values_name, pa.options_values_price, pa.price_prefix from " . TABLE_PRODUCTS_ATTRIBUTES . " pa, " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov where pa.products_id = '" . (int)$this->products_id . "' and pa.options_id = '" . (int)$products_options_name['products_options_id'] . "' and pa.options_values_id = pov.products_options_values_id and pov.language_id = '" . (int)$languages_id . "'"); REPLACE with this: // BOE: Attribute Sort with Clone Tool $products_options_query = tep_db_query("select pov.products_options_values_id, pov.products_options_values_name, pa.options_values_price, pa.price_prefix from " . TABLE_PRODUCTS_ATTRIBUTES . " pa, " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov where pa.products_id = '" . (int)$this->products_id . "' and pa.options_id = '" . (int)$products_options_name['products_options_id'] . "' and pa.options_values_id = pov.products_options_values_id and pov.language_id = '" . (int)$languages_id . "'" . " order by pa.options_values_price, pa.Products_attributes_id"); // EOE: Attribute Sort with Clone Tool And that sorts the attributes out. The odd thing is that it's not just an alphabetical sorting - I had three attributes come out like this: Small Medium Large When alphabetical sorting would have been: Large Medium Small To move the drop-down box and associated text across to the right, above the Add To Cart button, find, again in catalog/includes/classes/pad_base.php $out =' <table border="0" cellspacing="0" cellpadding="2">'; and change it to $out =' <table border="0" cellspacing="0" align="right" cellpadding="2">'; Works for me, but a reminder that "pad_base.php" comes with QR Pro, so these changes will only work for stores with QT Pro installed. I use QT Pro v4.6.1_1 and Oscommerce 2.3.1. If someone wants to see what these changes look like, my site is http://www.woofsandwags.co.uk/ Most of the Collars have attributes, so they will demonstrate what I'm talking about. Hope this helps someone.
  2. Apologies for talking to myself here! But I've sort of stumbled across a solution to having "Please Select" at the top of the drop-down list, so I thought I'd share it, in case it benefits someone else. The fix from earlier in the thread works, if you also choose the correct options in the QT Pro section of the admin. So, with belated thanks to mbi15, whose "hack" this is: Open /includes/functions/html_output.php Find for ($i=0, $n=sizeof($values); $i<$n; $i++) { Immediately before that line add: $field .= '<option value="select"'; $field .= '>Please select ...</option>'; My options in Admin/Configuration/Prod Info (QTPro) are: On a product with choice of colour (with no price variation) and choice of size (with price variation) two drop down lists, the top one's default is "First Select Colour" and the default of the second drop down is "Please Select". Out of stock items are not displayed. If a customer tries to add a product to the cart without changing the default drop-down list option, a pop-up prevents them from doing so. I have the "add-weight-to-product-attributes" add-on installed and the weight and price differential gets passed into the shopping cart. So I'm happy enough with that, so far. Now all I need is the whole lot aligned to the right, just above the Add To Cart button, and I'll be a happy camper, until the next time, anyway.
  3. For adding the "Please Select" line at the top of the drop down list, there's a hack earlier in the thread, involving adding a couple of lines of code to html_output.php, which gets "Please Select" at the top of the drop down, but it also gets an "The combination of options you have selected is currently out of stock. Please select another combination" error message. I'd like that error message to appear only if the customer tries to Add the product to the cart without selecting an attribute, or if an attribute is out of stock.
  4. Hi, I have QT Pro installed on my 2.3.1 store and it's working fine. But there are a few tweaks that I'd like, to make it more intuitive for the customer to use. First, is it possible for "Please Select" to be at the top of the drop-downs, with some kind of warning to the customer if they fail to select an attribute? I've had customers not changing the default and then moaning that they didn't want that colour/size. And, as the "Add To Cart" button is on the right, I think it would be more visible if the drop down list was just above it. I can do it in Paint Shop Pro, but not in php! Now: I'd like it to be like this: I'd be grateful of any help on either of these points. Kudos to all those involved in this add-on, as it already adds a lot of flexibility to the way I list products.
  5. Davefromcornwall

    Actual Attribute Price V1.0

    Has anyone got this useful-sounding add-on working with a fairly heavily modded 2.3.1 and with the "add-weight-to-product-attributes" add-on? Because I can't get it working, which is a shame. First it wasn't passing weights to the shopping cart. Tried a fix in the instructions, but that brought up an error message. Then I saw an old fix for it not passing weights across, applied it and it started missing out the shipping methods page of the checkout process altogether. So I've uninstalled it. If anyone does get it working with "add-weight-to-product-attributes" on 2.3.1, then I'd love to give it another try, as it is a useful add-on.
  6. Davefromcornwall

    family 3.0 problems

    It would have saved me a lot of time if the fact that the installation instructions only apply to stores with STS installed had been mentioned prominently in the add-on history section. I've spent a bit of time installing it all, at least as far as it starts going on about STS, come here and found out that the instructions only apply to STS stores and am now going to uninstall it! Annoying!
  7. Davefromcornwall

    Using Paypal Website Standard for more than one site.

    Thanks for that. Yeah, I've decided to go with "1." and got a more general email address for the Paypal account, which will serve both stores without confusing the customer too much. Since then, I've had a friend buy a product, pay with Paypal and tell me where they got redirected to and it all went smoothly and they were redirected back to the site that they bought the item from, so my "Problem 2" doesn't look to be a problem. I'll keep an eye out to see how often the "This invoice has already been paid" errors occur and see what I can do about it if it does happen too often. Thanks again for your help.
  8. Davefromcornwall

    Using Paypal Website Standard for more than one site.

    Thanks, but it doesn't really help much, I don't think. I don't use Chrome at all. I use Firefox mostly. So it doesn't look like a browser-specific problem, which is at least some help, I suppose.
  9. Hi, I already have one osCommerce site and am trying to set up another, but I'm running into problems. Problem 1: The customer buys his item and goes to pay at the Paypal site, where he is greeted by the email address for the other Paypal site in huge letters at the top of the page. I suppose we could get a neutral email address for Paypal, but I'd prefer it if I could use dedicated email addresses for each site. Is this possible and if so, how? Problem 2: I don't know if this actually happens, because I haven't got that far in the checkout process, but I think the customer will get redirected back to the other site, rather than the new one, which would be very undesirable. Problem 3: I am getting sporadic "This invoice has already been paid" errors. I've looked around the forum for previous answers, but most of them seem to refer to Paypal IPN. I feel like I'm missing something really simple (or is that just wishful thinking!) like creating a new profile for a new site in the same Paypal account, which would solve most of these problems, but I can't see how to do that. I'm very confused at the minute and any help from those with more experience of Paypal would be really welcome. Thanks for reading.
  10. Davefromcornwall

    jQuery/Ajax Shopping Cart

    I'd just like to add my voice to those asking if some kind person could possibly get this to work on 2.3.1 and then amend the installation instructions accordingly. It would be nice to be able to install this great-sounding add-on.
  11. Davefromcornwall

    fast easy checkout

    Hi, I have FEC installed and it works beautifully, except for returning customers. I've searched the thread, and someone else has had exactly the same problem and got an answer. But I don't understand the answer. The reply (in italics) is from "nana". If someone could explain what I'm supposed to do, I'd be very grateful, as this is an annoying little problem. How do I make it delete the old account and then create a new one? Thanks for reading this.
  12. Davefromcornwall

    Optional Related Products, Version 4.0

    Thanks for this excellent add-on to an excellent add-on! I've managed to get the Related Products in Cart add-on working, but it looks a bit odd, in my view. The text for each item is in the form of a list under the thumbnails, rather than under the thumbnail it corresponds to. Maybe it would be easier if you saw for yourselves. Here's a product with related products. If you add it to the cart, you'll see what it looks like (careful though, it's a live site). It's still perfectly usable, but for a consistent look, I would prefer the text under the thumbnail.
  13. Davefromcornwall

    Optional Related Products, Version 4.0

    I shouldn't really be here, as I don't need any support, but I have to say that this is a really excellent contribution with precise installation instructions. Thank you very much to all those involved in the development of this useful and well thought out add-on.
  14. Davefromcornwall

    fast easy checkout

    Persistence is a wonderful thing! I seem to have got this excellent contribution working, more through luck than judgement! For those having the same problem as the one that I had, I had my includes/configure.php set up wrong. I had the url to my shared SSL as the "HTTPS_COOKIE_DOMAIN". I changed this to my domain name, and it seems to be working (I completed a test order and all the info got sent to Paypal). Thanks to all who have been involved in the development of this contribution. It is probably the most useful addition I've seen, in that it greatly simplifies the buying experience. Cheers, Dave
  15. Davefromcornwall

    fast easy checkout

    Unfortunately I've had to uninstall this excellent contribution, as I can't afford to be without a functioning checkout. But I've only renamed the files, so if anyone can come up with an answer to my problem, I'm certainly willing to give it another try. Thanks Dave.