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,489 profile views
  1. beerbee

    QTPro BS

    Hi Rainer, regarding the sort order of options and values. I was stumbling over this as I was looking into pad_base.php In phoenix (v1.0.7.10) /admin/attributes.php expects the field sort_order in table products_options and products_options_values, so this seems to be the core ordering option. In cm_pi_qtpro_options.php the install process seems to look for another field: // Check if option/attributes sort order is used and add configuration entry if (tep_db_num_rows(tep_db_query("SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA='". DB_DATABASE . "' AND TABLE_NAME='products_options' AND COLUMN_NAME LIKE 'products_options_sort_order'")) == 1 ) { So this option won'be available on vanilla phoenix if I understand correctly. There seems to be no option for sorting the values by the column sort_order in products_options_values. Or do I miss something? Best regards Christoph
  2. beerbee

    QTPro BS

    Hi Rainer, I'm on OSCOM CE Phoenix v1.0.7.10 and getting the the follwing error if editing a product that has no attributes, if I try to save. Notice: Undefined index: stockquantity in /includes/hooks/admin/categories/catQtPro.php on line 32 I disabled all other category hooks and don't know what I may be missing. Best regards Christoph
  3. beerbee

    Include pictures in newsletter.

    This would be an open source template builder: https://mosaico.io/ sources on github too. https://github.com/voidlabs/mosaico Best regards Christoph
  4. beerbee

    Help needed understanding gallery module

    For me it it works without !important. The reason might be that I'm using a custom template. So maybe you check which template you are using and then check for the user.css in there.
  5. beerbee

    Help needed understanding gallery module

    Hi, 1. you could try to change the sloth width for the one the gallery is placed inside. admin/modules_content.php?module=cm_pi_modular&action=edit 2. via user.css .carousel-control-prev-icon{background-image:url("data:image/svg+xml,%3csvg xmlns='http://www.w3.org/2000/svg' fill='%23000' width='8' height='8' viewBox='0 0 8 8'%3e%3cpath d='M5.25 0l-4 4 4 4 1.5-1.5L4.25 4l2.5-2.5L5.25 0z'/%3e%3c/svg%3e")} .carousel-control-next-icon{background-image:url("data:image/svg+xml,%3csvg xmlns='http://www.w3.org/2000/svg' fill='%23000' width='8' height='8' viewBox='0 0 8 8'%3e%3cpath d='M2.75 0l-1.5 1.5L3.75 4l-2.5 2.5L2.75 8l4-4-4-4z'/%3e%3c/svg%3e")} .carousel-indicators li{background-color:#000;} Best regards Christoph
  6. Hi, got it working so far, I'm using https://apps.oscommerce.com/4L2fE&base-price-2-0 partially, which means I use the function that is put in functions general (changed a bit) , and DB entires . To avoid core code changes as far as possible I had to make up a new theme, to change tpl_ files there, and also the includes/components/product:_listing.php. Example: from /includes/modules/content/index/templates/tpl_cm_i_card_products 2.php echo sprintf(IS_PRODUCT_SHOW_PRICE, $currencies->display_price($card_products['products_price'], tep_get_tax_rate($card_products['products_tax_class_id']))); to /templates/mytemplate/includes/modules/content/indextpl_cm_i_card_products 2.php echo sprintf(IS_PRODUCT_SHOW_PRICE, $currencies->display_price($card_products['products_price'], tep_get_tax_rate($card_products['products_tax_class_id'])) . tep_get_products_display_price($card_products['products_id'], true)); Best regards Christoph
  7. Yes thanks, I'll do it via template for now. Best regards Christoph
  8. 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
  9. 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
  10. 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
  11. beerbee

    Display Tax Info V3.0

    Hi Rainer, you are right, sorry.
  12. 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
  13. 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