Jump to content

Peper

Members
  • Content count

    610
  • Joined

  • Last visited

Everything posted by Peper

  1. @JcMagpie @Patty I've found something wrong with this. For some products the Out of Stock button shows on products_info page, however my admin shows that qty is in stock, date is empty
  2. Anyone familiar with this desktop program? I need to alter a custom report and bit setback on the SQL part SELECT T1.products_id, T2.products_name, T1.products_model, T1.products_barcode, T1.manufacturers_id, T1.products_price, T1.vendors_id FROM /*PREFIX*/products T1 INNER JOIN /*PREFIX*/products_description T2 ON T2.products_id = T1.products_id And T2.language_id = /*CURRENT_LANGUAGE_ID*/ WHERE T1.products_id /*PRODUCTS_ID_LIST*/ Order by vendors_id Above currently working except it is giving the vendors_id for the product ie. 5 I have a table called vendors, this have vendors_id and vendors name in it How to make the products vendors_id show as vendors_name in above query?
  3. Peper

    Custom forms help on emagicone

    Thanks, got it sorted
  4. @Patty Thanks, just what i was looking for Seems there is no out of stock button or message in stock Phoenix.
  5. Whole lot of undefined errors: https://www.infinitydream.com/mobiles-tablets-apple-iphone-3gs-phones-c-127_128_61_62.html Default langauge is English, yet some buttons is french Google wants to translate Compact and clean site
  6. Their module is way outdated also not php7
  7. Fixed So after a while knowing my admin is showing no products in that category i went to check the database itself in phpmyadmin. Check first the main category number in admin that is causing the problem, mine was 209 example Check phpmyadmin table products_to_categories and sort categories_id Check then if there is a product_id assigned to category_id 209 My case there was 1 product with id 2192 - maybe corrupted sometime or so, 2192 product_id was also not found in table products - so safe to delete Deleted that row, checked front end and bam - working correctly Would be absolutely nice to have a check system build into osc for products/categories for possible issues Hope this helps someone
  8. @burt Strange thing i have another category also with many sub categories - showing fine The other category shows "There are no products available in this category." There are no products in this main category, only sub categories then with products in the subs
  9. @ecartz Ok, i missed it, my word.. However it was enabled so i removed it and reinstalled module There are no products in this category, only contains products in it's sub categories (9) Still showing There are no products available in this category.
  10. @ecartz I realized i have the same issue. Using Phoenix 1.0.5.0 There is no module like this in admin > Modules > Content > Sub Category List Any help pls
  11. Peper

    Add More Fields

    @Jack_mcs Thanks Jack, that was close enough for me <?php echo tep_draw_separator('pixel_trans.gif', '24', '15') . '&nbsp;' . tep_draw_textarea_field($field['field_name'] . '[' . (int)$field['language_id'] . ']', 'soft', 30, 5, $field['field_value']) . '&nbsp; ' . $languages[$field['language_id']-1]['name']; ?>
  12. Peper

    Add More Fields

    @Jack_mcs Old but gold, please help. in categories.php, the input box to text box - how to? tep_draw_input_field($field['field_name'], $field['field_value']); to tep_draw_textarea_field with box size specified Also not to remove html and retain new lines when saving - using table products_description and updated the new field to varchar 512
  13. @milerwan May i ask if you are willing to share the net, gross price display?
  14. Peper

    Automatically send data feed to Froogle

    Google warnings not going away Error is Mismatched [price] (page crawl) This comes in pricing showing excl Tax on site, the googlefeeder.txt is calculated including Tax Google bot is crawling site excluding Tax Google reports Mismatched [price] Web is setup to show pricing excluding tax in admin with tax rates 0% and 15% What needs to be done?
  15. This small things that pulling my hair Please can someone help with this $bundle_query = tep_db_query("SELECT pb.subproduct_id, pb.subproduct_qty, p.products_id, pd.products_name, pd.language_id FROM products p LEFT JOIN products_bundles pb ON (pb.bundle_id=p.products_id) LEFT JOIN products_description pd ON (pd.products_id=pb.subproduct_id) WHERE p.products_model = '" . $order->products[$i]['model'] . "' AND pd.language_id = '1'"); while ($bundle_info = tep_db_fetch_array($bundle_query)) { if (tep_not_null($bundle_info)) { $bundle_info = $bundleContents; $bundleContents = '<br /><em style="font-size:12px;">&nbsp;&nbsp;' . $bundle['subproduct_qty'] . ' x ' . $bundle['products_name'] . '</em>'; } else { $bundleContents = ' '; } } and then later to echo $bundleContents So if contents is in bundle echo this, else echo nothing. I tried many ways to do this but not close. Want to use this in the email order confirmation mail to display the bundle purchased
  16. Peper

    if this bundle then that help

    @14steve14 I do have that module from Gary, I did give it a try a while ago, there were few things but one was the bundle display layout was not working for me. This is not a train smash, i will still pursue a solution for this as it would been great showing in the email confirmation the bundled products instead of just the bundle product name. If you change the bundle after customer purchased a bundle, what products was part of the original bundle?
  17. Peper

    if this bundle then that help

    Check for needle first? Is this useable $bundle_query = tep_db_query('select pb.subproduct_id, pb.subproduct_qty, p.products_bundle, p.products_quantity from products_bundles pb, products p where p.products_id = pb.subproduct_id and bundle_id = ' . (int)tep_get_prid($bundle_id)); while ($bundle_info = tep_db_fetch_array($bundle_query)) { if ($bundle_info['products_bundle'] == 'yes') {
  18. Peper

    if this bundle then that help

    @hungryfrank yes, there is one This is a html email confirmation i'm working on for checkout_process I see though to get model number unrelated from bundle = <td valign="top" align="center"><font face="verdana" style="font-size:14px;">'.$order->products[$i]['qty'].'</font></td> So that one in bundles? getting model number for bundles?
  19. Peper

    if this bundle then that help

    @ruden @ecartz Thanks, i tried both, not showing product bundle Some items are made up of more than on product. I wanted to display the product items included in the bundle example for my admin/invoice.php this is working perfect $bundleContents = ''; $bundle_query = tep_db_query("SELECT pb.subproduct_id, pb.subproduct_qty, p.products_id, pd.products_name, pd.language_id FROM " . TABLE_PRODUCTS . " p LEFT JOIN products_bundles pb ON (pb.bundle_id=p.products_id) LEFT JOIN " . TABLE_PRODUCTS_DESCRIPTION . " pd ON (pd.products_id=pb.subproduct_id) WHERE p.products_model = '" . $order->products[$i]['model'] . "' AND pd.language_id = '1'"); while ($bundle = tep_db_fetch_array($bundle_query)) { echo "<br> <i>" . $bundle['subproduct_qty'] . " x " . $bundle['products_name'] . "</i>"; } My last attempt i tried both normal product or bundle results into "none" $bundle_query = tep_db_query("SELECT pb.subproduct_id, pb.subproduct_qty, p.products_id, pd.products_name, pd.language_id FROM products p LEFT JOIN products_bundles pb ON (pb.bundle_id=p.products_id) LEFT JOIN products_description pd ON (pd.products_id=pb.subproduct_id) WHERE p.products_model = '" . $order->products[$i]['model'] . "' AND pd.language_id = '1'"); if (!tep_db_num_rows($bundle_query) ) { $bundleContents = 'none'; } else { $bundle = tep_db_fetch_array($bundle_query); $bundleContents = '<br /><em style="font-size:12px;">&nbsp;&nbsp;' . $bundle['subproduct_qty'] . ' x ' . $bundle['products_name'] . '</em>'; }
  20. Peper

    KissIT Image Thumbnailer Phoenix

    There are 2 x files needed (Image.php and Image_Helper.php) under catalog/includes/modules/kiss_image_thumbnailer/classes/
  21. Peper

    Email queuing system

    @burt Interested, was this ever released?
  22. Peper

    [contribution] Tracking Module

    Anyone got this working on Phoenix? I have updated the deprecated code Fedex installed Using my old admin/order.php file into ce it works perfect no errors These 2 edits seems to be problem <!-- tracking_module form --> <?php $tracking->display_form(); ?> <!-- end tracking_module form --> and <!-- tracking_module noscript --> <?php $tracking->display_no_js(); ?> <!-- end tracking_module noscript --> Any ideas?
  23. Absolutely strange I setup a new phoenix install with the autocomplete search and is working(local pc) Compared page sources and almost a match except well for https and few little things Diffrence found : The working one have '&amp;search_in_description=1' the non working one '&search_in_description=1' In file ht-twitter-typeahead.js.php I changed '&search_in_description=1\' to read '&amp;search_in_description=1\' Now search is working correctly but even so, my working live site = &search_in_description=1 and works perfectly - same server I'm not so sure the problem was corrected this way changing & to &amp;
×