Jump to content
Latest News: (loading..)


  • Content count

  • Joined

  • Last visited

Profile Information

  • Real Name
  • Gender
  • Location

Recent Profile Visitors

6,421 profile views
  1. Still having trouble getting mine to exclude specials, but if it works on everyone else's I must have missed something. So will try and suss out what I've got that is different.
  2. Just replying to the test from Raiwa. I did copy those 2 files over and it did let me select Applies to Order sub-total and then select 'Exclude specials' BUT - the result, it didn't actually exclude the specials product I put in my cart along with others. Was I supposed to highlight anything? Here's my screenshot:
  3. Ok so its never really going to work for most people on selecting all products then. But then of course I can set it on Manufacturers with excluding specials selected. That way I still cover all my products and exclude specials. I've done this. Although when I highlighted all manufacturers, when it created the code - it only listed the first (this got me worried) but actually it does work on all manufacturers products, and excludes specials. Great - some way to get it working. All the calculations are now correct as well! thanks for your time in helping me suss this out and working out whats possible and limitations also. It would still be great to sub-total after the discount etc applied, so I'll watch out in case that gets added later by yourself Raiwa or Lambros. The old discount codes I was using pre BS was ot_discount_coupon_codes_3_34_osc2.3_1_2_3.
  4. 1) On the one hand - that's brilliant Tsimi. Its allowed me to get it to work excluding specials. Can I just suggest putting a tiny bit of text on that page to say - please highlight products from the below list that you want included. It wasn't obvious that these actually needed highlighting and that it wouldn't work with them just listed there. 2) Yes I've run into the problem that Raiwa has identified above. The site has 1200 products. Not huge, but its a working site. The list only let me select up to J!! So half my products were left off. Is there any way of uping the max. post size. Where is this defined? thanks again!
  5. Hello Tsimi. So now I'm getting confused. Under Catalog / Discount codes - Yes I can tick the box for 'excludes specials' when set on Applies to: Products or Categories or Manufacturers, and it will let me click the Save button, but on any of these 'Applies to' it will NOT create the discount code. I click on save and it does nothing. BUT when I select Applies to ' Order Sub-Total ' - it greys out the exclude specials option and when I click on the Save button this time it takes me back to the discount code list showing that a discount code has been created. My new discount code is now added to the list. It also works on Applies to 'Shipping'. But when any other Applies to are selected - then the code will not be created upon clicking on the save button. Is this the behaviour that you are expecting? 1) Are you, when on your site - able to choose select Products and then choose' exclude Specials' and click save and it actually creates that code successfully and adds it to you list? 2) Then does that code follow through and work and actually exclude the specials when you try it out in cart view? many thanks
  6. Thanks Raiwa, I'm trying to get the old module working in BS, as that did work correctly. I'm part way there, but need to iron out some other things. I'll watch this space also for when you're able to look at the new BS version. The adding up in the BS version is a problem (obviously has to be accurate) , and really it does need to show a sub-total 'after' the discount applied. At present it looks like tax is added on after everything else although its already been accounted for (see my image above), so for the sub-total to show the amount after tax and after discount applied will be much clearer to the customer. As it did in the older version. Yes I think it may take a while to iron out problems with this one but thank you for looking at it.
  7. Thanks Raiwa In: includes/modules/order_totals/ot_discount.php So the code in this is straight out of the box and I have of course uploaded it. So nothing I've done or not done to disrupt this.
  8. Hi Raiwa. I'm sorry to say I've found some more things not working quite as they should. I've included a screen shot. So firstly one of those items in the basket is a special, so shouldn't be included anyway. But the totaling is wrong. It should all total to £151.46 not £152.57. So something isn't quite working right. ??
  9. Just tried different option and actually it doesn't exclude discounted items (specials) when any Applies to option is selected. I've changed it back to the original code and the same. So something is going wrong if it is not excluding Specials. Where can I check the code for this?
  10. Raiwa, so with the change to line 192 you sent - it now lets me tick the Exclude Specials box (which using Applies to order Sub Total) but it does not exclude the product that is a reduced item at the customers checkout. So hasn't worked properly.
  11. I've just installed the Discount code BS on my new-ish BS site ( v2.3.4.1 CE ). I did use the previous version Discount code add on my previous non BS site. A couple of questions - 1) I used to be able to configure whether to display the order subtotal either way - including the discount, or before the discount is applied. I did this just by changing the sort order under Order Total by putting Discount code before Sub-Total. Then the sub-total told the customer the amount including the discount. So yes I can change the sort order still (under Order Total) but the sub-total will not now display the price including discount. Is there anyway I can get this functionality back? 2) Exclude specials tick box area is greyed out when set on applies to Order-sub total. Was there a reason for this? Not sure if I've missed anything so any help would be gratefully received!
  12. Rosyweb

    QTPro BS

    Hi Raiwa yes I get the opposite. Installation is a new one and all else is working well. I'll test more when I have the chance. But yes - strange we are getting opposite results!
  13. Rosyweb

    QTPro BS

    Raiwa, I'm not sure if this is a bug or not. It may only have been behaving like this on my site but thought I'd feed back to you. I'm on OSCommerce v2.3.4.1 CE and installed QTPro CE When I have products with attributes attached, all behaves well with the QTPro add on - the admin/stock.php page. I can add stock, I can delete all stock and start again. All fine. However, on my site I have some products that don't have attributes attached and I just rely on the table = products, products_quantity field for the products quantity. When I add stock to one of these products I don't expect it to create an entry in products_stock also. Which is does with the current add on - as the button defaults to Add not Update when stock is 0. The problem being, the Add button automatically creates an entry corresponding to the products id in table products_stock. So what's the problem with that? Well on products WITHOUT attributes, it causes the QTPro doctor to complain that this is a 'sick' product. I got round it in the end, and changed your code - about line 220 (($db_quantity)? BUTTON_UPDATE : BUTTON_ADD ) to ($flag? BUTTON_ADD : BUTTON_UPDATE ) going back to the original way, from an older QTPro contribution. I tweaked in a couple of other places, but this seems to work. I don't know if I'm causing myself other problems here, hopefully not, but now I can take a product without attributes down to 0 stock again, then add stock back to it - now the button is Update not Add!! and no 'sick product' messages in QTPro doctor and no forced entry into table products_stock. If you have a better solution, please let me know. Otherwise this is just feedback on problems encountered.
  14. Rosyweb

    QTPro - stock table sort order

    Just adding this to bootstrap site - a number of years later! I'm finding that LPAD on attNum1 is needed for it to work correctly in this version. $products_stock_query=tep_db_query("SELECT SUBSTR(products_stock_attributes, 1, INSTR(products_stock_attributes,',')-1) AS attNum1, SUBSTR(products_stock_attributes,INSTR(products_stock_attributes,',')+3, 5) AS attNum2, products_stock_attributes, products_stock_quantity FROM products_stock WHERE products_id=" . (int)$_GET['products_id'] ." ORDER BY LPAD(attNum1, 10, 0) DESC, LPAD(attNum2, 10, 0) ASC");
  15. Rosyweb

    Products listing - short description length

    That's brilliant - found it! Yes it was Frozen and in includes/modules/content/index_products/cm_ip_product_listing.php thank you Raiwa