Jump to content


  • Content count

  • Joined

  • Last visited

About pbor1234

  • Birthday 02/01/1976

Profile Information

Recent Profile Visitors

15,110 profile views
  1. I was looking at the sql modifications and have doubts. It seems to be possible to filter on gifts without the additional column to products: select count(distinct p.products_id) as total from products p left join (specials s) on (p.products_id = s.products_id) left join (products_description pd) on (p.products_id = pd.products_id and pd.language_id = '4') <...> left join (`free_gifts` f) on (p.products_id = f.products_id) where p.products_status = '1' and f.products_id IS NULL Anyone thoughts on this? Paul
  2. Hoi Wiljo, Might be that i was seeing the tax on giftwrap + tax on shipping (iso tax on products). It's wrong anyway,,,, I guess i need to refactor simply the workings on discount_coupons the class + integration into the order. Thing is that each ot-contribution is hacked differently into the codebase :( It's a mess :( BTW: Have you tried to use the order_editor (contribution) icw added ot's? Try to update the order-total items and see what happens.... Paul
  3. Found another issue; display prices with tax = 'true', then create an order of 5$ + shipping of 3$ (for example), include discount coupon fixed 10$, in the total/confirmation page you will notice that the total price isn't 0 but equal to the tax of products + shipping. It's the ot_'s that add the tax to the $info['total']. I'm working on a hack to correct the 'total' from the ot_discount_coupon::process(); moving finalize_discount here seems to do the trick but i have no clue what impact of such change may be; since the modules are also used by admin...!? Paul
  4. Wiljo, If i want give EUR 5 discount (incl tax), i may need to enter 4,20 (excl 19% tax) or 4,72; or anything in between since customer may order 19% tax'ed items and/or 6% items. So it doesn't work on the base price...? Regarding the $tax_address; if i die/print_r, i see its simply not defined, even when i declare it global, it's not defined. I do have it in classes/order.php but there its a local as well. See also php.net Paul
  5. Customers expect discount to be incl. tax; or in fact customers are only interrested in nett. prices incl tax, since that is what they need to pay. It's rather strange to give a customer 5$ discount while in fact its 5,95$ discount incl tax...!? Regarding the $tax_address, yes it's in order.php but shouldn't it be declared global in the total_valid_products function? Paul
  6. Think i found a bug, in discount_coupon.php, function total_valid_products, there tax is calculated when DISPLAY_PRICE_WITH_TAX = true but an unknown array $tax_address is used causing tax to be always 0. So while the whole shop may be displaying prices with tax, the coupon-codes modules is calculating discounts always based on prices without tax (and then optionally adding tax again for displaying). All very confusing ... Paul
  7. Hi pbor1234,

    Hope all is excellent with you. Re: Store Statistics v1.4 - Thanks it's a great tool.

    How to adjust font size? Is there an explanation on how to interpret graph data?

    Thanks for your generosity.

    Happy Holidays.


  8. I just installed your php5 tnt export

    But when i use it it doesnt export the streetname

    can you maybbee be any help

    Groet danta67

  9. Did you merge the bottom section in applicationtop.php?
  10. I've uploaded an update that should work at once on vanilla osc2.2ms2 Remarks are highly appreciated! Paul
  11. PBOR1234,

    I just installed your store_stats ... Great, it's (almost) really what I wanted.

    2 remarks however:

    - store_stats_order_total.php geeft geen beeld ...

    - Ik zou graag overzicht van 60 weken zien, 13 maanden, maar dan krijg ik een "mix-up" van de overlappende weken/maanden

    any hint?


  12. Jim, Carine, Thanks for the response; i'll try to complete a first working contribution based on 2.2ms2. Meanwhile you can see it in action on my webshop (see link in my profile). It's only in dutch but i guess it will be no problem to understand the logic ;) Paul
  13. Just being curious; is there really no interest in a faceted search function to osc? Actually i had expected more replies on this subject.... Paul
  14. I've just uploaded a first working (admin only) version of the contribution. See http://addons.oscommerce.com/info/7192
  15. I'm actually still running the basic oscommerce (advanced) search scripts on my webshop. Up till now i only excluded some features i didn't want to offer (like search on date) and i had to make an improvement to the raw query when my hoster started to complain ;) Anyway, i wanted to '''upgrade''' the search functionality with the following: - search suggest while typing - did you mean... function on 0 hits on a per keyword basis - offer additional filters as search results (for example indicate number of hits per categorie in a link as part of the results). I believe the more expensive word to this function is: Faceted Search - Misspellings (aspell integration using custom dictionary) I started investigating what tools are available (without the need for a deamon) and ended up with Sphider. Currently i'm integrating the Sphider solution in terms of queries/tables and logic into oscommerce. I'm planning to first build an admin only solution to be able to 'play' with the functions (index, search, reindex, ...). Only then the catalog side will be build. Who is interested in giving advise, performing code review and alike? Expecting first admin version in about 2 weeks time. Paul