Jump to content


  • Content count

  • Joined

  • Last visited

  • Days Won


beerbee last won the day on January 18 2018

beerbee had the most liked content!

About beerbee

  • Rank
    A rich man born in the body of a poor one
  • Birthday 11/16/1964

Profile Information

  • Real Name
  • Gender
  • Location
    Kulmbach Germany

Recent Profile Visitors

11,234 profile views
  1. Yes thanks, I'll do it via template for now. Best regards Christoph
  2. Hi, @raiwa thanks for making this clear to me. As far as I understand it now there would be no way around changing every display of price on the shop side which I'd really like to avoid. Best regards Christoph
  3. Hi Burt. there are three db fields added to product info: the factor for multiplication, which is numeric and is calculated based on the entries made on the admin side and then entered into db. eg factor 0.5 if have 200g or 2 if have 50g. the unit, a text field aka 100 g for displaying the unit aka per 100 g a third one not relevant here, only for googlebase. so that the calculation always fits - price changes or special So architecture/logic is clear, working fine on product_info.php (using global $product_info inside the hook,) getting the products_id for retrieving the fields for factor and unit, but not on any listings be it product or shopping card listing. So naively thinking: the currency class always "knows" the products_id everywhere but I don't get...it. Best regards Christoph
  4. Hi, in Germany if selling food, cosmetics etc. we are obliged to to show base prices for products: E.g Green Tea 50g 5,50 € - we have to show makes 11€/100g also. In the livestore (frozen) we use an old contribution which takes also the display of taxes with the products price in to account which we are also obliged to show. So the base_price is simply a numeric DB entry in table products which provides factor which is applied to the price. This is the old one https://apps.oscommerce.com/Get&4L2fE&N3gNj (we use 2.0 which does not take varying attributes prices into account -we dont need it) What was relatively easy´: To create a hook for the admin part creating a new tab in categories edit product. On the shop side I was not successful. As there is already Display Tax Info by raiwa I was thinking I could get the output inside of the hook_shop_siteWide_priceTax provided herein. https://apps.oscommerce.com/6ONOh&display-tax-info-phoenix My problem is: I don't know how to get the $product_id inside the hook which is needed for retrieving the information from table products - apart from a single product shown on product_info which is easily done by using the global $product info. So on product_info everything is fine, but sadly we have to show it everywhere. Thanks in advance! Best regards Christoph
  5. beerbee

    Display Tax Info V3.0

    Hi Rainer, you are right, sorry.
  6. beerbee

    Display Tax Info V3.0

    Hi @raiwa, as our shop is in Germany and some of our products are food or cosmetics there is no way around showing base prices. We need only a simple version as we have no individual attribute prices. With my limited abilities I was able to create a hook/tab for the admin/categories and now I'm trying to get it working on the shop side by editing the shop hook priceTax as we need that anyway too. I'd need to get the baseprice factor and unit from the products table inside the hook. Which works, but only for product_info.php but not any listings which is obviously caused by stupidly using global $product_info for getting product_id for select . So if there is way to get this working everywhere? Best regards and TIA Christoph
  7. beerbee

    Automatically send data feed to Froogle

    Well whatever, I have to set it to 3 because without it no tax calculation (with differing taxes for e.g. food) would be done. There is an option which is checked for, but it does not exist? By the way my middle name is PIA since now, I guess. Best regards Christoph
  8. beerbee

    Automatically send data feed to Froogle

    Hi Jack, sorry, I may misunderstand you, but there is an option 3. line 402 does what I need; if (OPTIONS_ENABLED_INCLUDE_TAX == 3) { Option 2 says define('OPTIONS_TAX_CALC', (OPTIONS_ENABLED_INCLUDE_TAX == 2 ? (OPTIONS_TAX_RATE/100) + 1 : '1')); //UK. US tax rate - US is ignorded since it is 1 so maybe you meant: if(OPTIONS_ENABLED_INCLUDE_TAX == 1 || OPTIONS_ENABLED_INCLUDE_TAX == 2) $output .= "\ttax"; Best regards Christoph
  9. beerbee

    Automatically send data feed to Froogle

    @Jack_mcs, Regarding the price with tax I ended up with this: $row->price = $currencies->display_raw($row->price_no_tax, tep_get_tax_rate((int)$row->tax_id)); Another thing I had a problem with was if(OPTIONS_ENABLED_INCLUDE_TAX == 1 || OPTIONS_ENABLED_INCLUDE_TAX == 3) $output .= "\ttax"; As I have OPTIONS_ENABLED_INCLUDE_TAX == 3 the heading would a add a tab stop with title tax but the feed would not have the have tax rate (I could not find anything which would put that there in the code) nor the tab stop in it, which produced errors at merchants.google missing that tab stop. So I changed to if(OPTIONS_ENABLED_INCLUDE_TAX == 1) $output .= "\ttax"; Best regards Christoph
  10. beerbee

    Continue Shopping Button for 2.3.4bs

    Hi, for shoppingcart take a look: Best regards Christoph
  11. beerbee

    Automatically send data feed to Froogle

    @Jack_mcs No sorry I'm just into Euros.. Did this for now from: $row->price = $price_w_tax; to: $row->price = round($price_w_tax,2); puts out nor more then two digits after dot, seems to work, any caveats with this? Best regards Christoph
  12. beerbee

    Automatically send data feed to Froogle

    Hi @Jack_mcs, I have a problem with the prices (with taxes from the $price_w_tax): If the result is e.g 69.899 (three numbers after the dot) this is seen by google as EUR 69.899,00 which is a bit too much. If the result ist eg. 27.8955 (four number after the dot) is used correctly : EUR 27,90. Any clues? Another thing would be nice to have: Base price functionality as it is required for certain products in the EU. I know this requires at least two new columns in products and accordingly changes to admin/categories. Best regards Christoph
  13. beerbee

    QTPro BS

    Hi @raiwa , sadly i have noticed, that qtpro doctor is slowing down admin/categories.php heavily. We have 256 products with tracked stock, which often means over 25 combinations per product, I guess this produces big load on mysql as admin/qtprodoctor.php is also very slow. It got really very much faster after commenting out //Create the product investigation for this product that are used in this page. and the following lines out of categories.php Best regards Christoph
  14. beerbee

    Modular Shopping Cart

    @raiwa, works like a charm, thanks! I think others might like it too. Best regards Christoph
  15. beerbee

    Modular Shopping Cart

    Hi again Rainer @raiwa, already tried putting $navigation as global into function execute() of cm_sc_checkout (wrong place?), for testing i put $sc_checkout = '<div class="row">' . sizeof($navigation->path); It stays zero. But this seems to be all over the site, regardless (index, product_info) of where I put it: always zero. Best regards Christoph