Jump to content

Peper

Members
  • Content count

    581
  • Joined

  • Last visited

About Peper

  • Birthday 11/28/1975

Profile Information

  • Real Name
    Pierre
  • Gender
    Male
  • Location
    South Africa
  • Website

Recent Profile Visitors

25,743 profile views
  1. 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
  2. @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
  3. @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.
  4. @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
  5. 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']; ?>
  6. 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
  7. @milerwan May i ask if you are willing to share the net, gross price display?
  8. 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?
  9. 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?
  10. 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') {
  11. 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?
  12. 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>'; }
  13. 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
  14. 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/
  15. Peper

    Email queuing system

    @burt Interested, was this ever released?
×