Jump to content


  • Content count

  • Joined

  • Last visited

  • Days Won


Everything posted by beerbee

  1. beerbee

    Installation osCommerce v4 Beta 2 - No Admin Page

    Hi, I've had the same problems when I tried to install on a shared hosting into a subfolder like /shop. The problem is with not writing the rewrite base entries in both .htaccess files, only after entering the correct rewrite base values I could access the splash and the admin. No luck with watches and furniture though. Another question maybe a dumb one: What are the symlinks for? And a litlte note: I hope the name of the admin folder will be changeable on install in the future for security reasons. Kind regards Christoph
  2. Yes I know, this fix is already implemented on my install. This shows up : Notice: Undefined index: enthaltene MwSt. 7% in /xxx/phoenix/includes/modules/content/shopping_cart/cm_sc_order_total.php on line 74 under the following circumstances: I'm not logged in, have free shipping because order amount is above level, and have products with 19 and 7 tax in the cart, If I log in all good. I noticed if mixed it always the last products thats added tax, can be 19 too. I have tried to add the fix from core there please check PM the third one seems to fix both ways but I know my limitations... Best regards Christoph
  3. In the hopes of not to be too much of a bore 😉, I get an undefined error regarding tax on shipping (19%) in cm_sc_order_:total.php - I tried something, will pm for the safety of the community. BR C
  4. Hi Rainer, there seems to have something from two page _TWOPAGE_ checkout found its way into cm_sc_shipping.php, line 106 (116 too) $order->delivery = ['postcode' => ($_POST['zip_code'] ?? MODULE_CONTENT_SC_TWOPAGE_SHIPPING_DEFAULT_ZIP), Best regards Christoph
  5. beerbee

    Display Tax Info V3.0

    Hi Rainer, as i was struggling with reviews write I noticed that on the write page the module is not active and can not get activated. Which I think is a result of the scan for pages function which does not include ext/modules files like the write.php there. Best regards Christoph
  6. beerbee

    QTPro BS

    Hi, don't know if it is only me, but if i only have products without attributes in my cart I got two define errors on checkout. changed both lines in 127 and 213 this way: $products_attributes = $order->products[$i]['attributes'] ?? ''; in templates/override/includes/hooks/shop/siteWide/qtPro.php Best regards Christoph
  7. beerbee

    Phoenix v1.0.4.0 und Vokale

    Schau mal ob Du in den Einstellungen etwas von character conversion findest, damit sollten umlaute in urls entsprechend umgewandelt werden.
  8. No, I'm far from live (sadly), so I'll keep it on - it was just to let you know, thanks! BR C
  9. Hi @raiwa, thanks for the update. We have 19% tax on shipping and some of our products are sold with 7%. As long as there are only 7% products in the shopping cart I get: Undefined index: enthaltene MwSt. 19% in /phoenix/includes/modules/order_total/ot_shipping.php on line 56. Best regards Christoph
  10. 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
  11. 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
  12. 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
  13. 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
  14. Yes thanks, I'll do it via template for now. Best regards Christoph
  15. 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
  16. 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
  17. beerbee

    Display Tax Info V3.0

    Hi Rainer, you are right, sorry.
  18. 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
  19. 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
  20. 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
  21. 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
  22. beerbee

    Continue Shopping Button for 2.3.4bs

    Hi, for shoppingcart take a look: Best regards Christoph
  23. 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