Jump to content

dootch

Members
  • Content count

    108
  • Joined

  • Last visited

1 Follower

Profile Information

  1. dootch

    UPS no rates displayed

    Down here as well no changes made
  2. dootch

    [Contribution] Ship In Cart

    OK folks here is how I got it to work when a customer is not logged in I installed the latest package 2.2 and used the includes/modules/shipping_estimator.php file from 2.0
  3. dootch

    Automatically send data feed to Froogle

    Is there a way to add append a date to my outfile that I save? I would like to save them for reference rather than overwrite them daily. I suppose It could go froogle-101705.txt I suppose it would be added to this section $OutFile = "../xyz/froogle.txt"; //"CHANGEME-full-path-to-file-with-777-dir-and-file-permissions.fr-outfile.txt"; Does anyone have an idea??
  4. dootch

    Custom Computer Creator v9 Support

    Rushy, Mod the look from the ccc.php file around line 80 for the first screen around line 145-170 or so for the second screen. You can re table that stuff add an image or 2 to get a pretty good look. I added a couple of fields to the db for image files and called them as well as the text in the ccc.php, particularly ccc_fsb_description and ccc_systems_description. Take a look at www.snjcomputers.com/forum the "official CCC support forum" :thumbsup: Leandroc76 reformatted his build.php table to a pretty good look. FYI If you add a pic to the build.php page pulling from the ccc db it will be a broken link if the customer clicks edit from shopping cart page(because the build then becomes a product). You would need another array and an else to then pull the pic from the product_description table if you set up for the image to load into the product_description table. I hope this makes sense. Dig in, it does work but you need some skills its not for the faint of heart.
  5. dootch

    Custom Computer Creator

    Step 1. Start with CCC options create some master configs (System Info) by cpu type, form factor type or whatever. Step 2. Once created click on them now add system types (System Build Name) be it laptops, servers, workstation whatever. Step 3 Now click on newly created System Build Name and add your configuration categories ie. CPU, Memory, Chassis, Hard Drive etc. Step 4 Click on a newly created Category click new product and map it (you will see) from a drop down to an existing category in your shop from there you can add parts to your configurator
  6. dootch

    Custom Computer Creator v9 Support

    I am trying to exclude the "custom" products from the cross sell mod for the admin here is the bit of code used in admin to display the cross sell products. It seems that I would exclude the custom parts from the query but oh where should I place and products_model != 'Custom' Code.... Thanks <?php // X-SELL by Kavita Begin $products_query_selected = tep_db_query("select xsell_id from " . TABLE_PRODUCTS_XSELL . " where products_id = '" . $HTTP_GET_VARS['pID'] . "'"); $products_array_selected = array(array('id' => '')); while ($products = tep_db_fetch_array($products_query_selected)) { $products_array_selected[] = array('id' => $products['xsell_id']); } if ($HTTP_GET_VARS['pID']) { $products_query = tep_db_query("select products_id, products_name from " . TABLE_PRODUCTS_DESCRIPTION . " where language_id = '". $languages_id ."' and products_id != '" . (int)$HTTP_GET_VARS['pID'] . "' order by products_name"); } else { $products_query = tep_db_query("select products_id, products_name from " . TABLE_PRODUCTS_DESCRIPTION . " where language_id = ". $languages_id ." order by products_name"); } while ($products = tep_db_fetch_array($products_query)) { $products_array[] = array('id' => $products['products_id'], 'text' => $products['products_name']); } ?> <tr> <td class="main"><?php echo 'Cross Sell Products'; ?></td> <td class="main"><?php echo tep_draw_separator('pixel_trans.gif', '24', '15') . ' ' . tep_draw_mselect_menu('products_xsell_ids[]', $products_array, $products_array_selected, 'size=10'); ?></td> </tr> <tr> <td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td> </tr> <?php // X-SELL by Kavita End ?>
  7. dootch

    PC Pro Creator

    Any updates on the new version? or should I just install the current and wait for updates?
  8. dootch

    Cross Sell (x-sell) query

    Digging through all the forks of this contrib I found this fix for the header showing when no products are linked this is a new xsell_products.php file to replace the one in catalog/includes/modules <?php /* $Id: xsell_products.php, v1.1 2004/02/16 osCommerce, Open Source E-Commerce Solutions <http://www.oscommerce.com> Copyright (c) 2002 osCommerce Released under the GNU General Public License modified Feb 16, 2004 to not display the x-sell box header if there are no products set for cross-selling. A small change in execution logic. */ if ($HTTP_GET_VARS['products_id']) { $xsell_query = tep_db_query("select distinct p.products_id, p.products_image, pd.products_name, p.products_tax_class_id, products_price from " . TABLE_PRODUCTS_XSELL . " xp, " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where xp.products_id = '" . $HTTP_GET_VARS['products_id'] . "' and xp.xsell_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '" . $languages_id . "' and p.products_status = '1' order by xp.products_id asc limit " . MAX_DISPLAY_ALSO_PURCHASED); $num_products_xsell = tep_db_num_rows($xsell_query); if ($num_products_xsell >= MIN_DISPLAY_XSELL) { ?> <!-- xsell_products //--> <?php $row = 0; $col = 0; $info_box_contents = array(); while ($xsell = tep_db_fetch_array($xsell_query)) { $xsell['specials_new_products_price'] = tep_get_products_special_price($xsell['products_id']); if ($xsell['specials_new_products_price']) { $xsell_price = '<s>' . $currencies->display_price($xsell['products_price'], tep_get_tax_rate($xsell['products_tax_class_id'])) . '</s><br>'; $xsell_price .= '<span class="productSpecialPrice">' . $currencies->display_price($xsell['specials_new_products_price'], tep_get_tax_rate($xsell['products_tax_class_id'])) . '</span>'; } else { $xsell_price = $currencies->display_price($xsell['products_price'], tep_get_tax_rate($xsell['products_tax_class_id'])); } $info_box_contents[$row][$col] = array('align' => 'center', 'params' => 'class="smallText" width="33%" valign="top"', 'text' => '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $xsell['products_id']) . '">' . tep_image(DIR_WS_IMAGES . $xsell['products_image'], $xsell['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a><br><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $xsell['products_id']) . '">' . $xsell['products_name'] .'</a><br>' . $xsell_price. '<br><a href="' . tep_href_link(FILENAME_DEFAULT, tep_get_all_get_params(array('action')) . 'action=buy_now&products_id=' . $xsell['products_id'], 'NONSSL') . '">' . tep_image_button('button_buy_now.gif', TEXT_BUY . $xsell['products_name'] . TEXT_NOW) .'</a>'); $col ++; if ($col > 2) { $col = 0; $row ++; } } // halbert mod - Don't show heading if no cross-sell items if (($num_products_xsell >= MIN_DISPLAY_XSELL) && ($num_products_xsell > 0)) { $info_box_heading = array(); $info_box_heading[] = array('align' => 'left', 'text' => TEXT_XSELL_PRODUCTS); new contentBoxHeading($info_box_heading); new contentBox($info_box_contents); } ?> <!-- xsell_products_eof //--> <?php } } ?> Hope this helps someone
  9. dootch

    Cross Sell (x-sell) query

    Almost works for me box goes away when no cross sell products but infobox header is now gone when displaying. Line around box exists product is in the box but no header???
  10. dootch

    Automatically send data feed to Froogle

    Works like a champ. You RULE!!!!
  11. dootch

    Automatically send data feed to Froogle

    Got the price thing figured out (thanks Jim) Next question is if I want to limit products to those of certain manufacturers. I can get it work with one manufacturer using the following command AND manufacturers.manufacturers_id=284 but I cannot get it to work for more than one (I would like to have about 10). If I add another AND command it returns nothing. I am not an SQL wiz, I got my book out but I cant figure it out so any help will be great
  12. dootch

    Automatically send data feed to Froogle

    OK I got it to work conditionally around line 96 in froogle.php I added the following condition AND products.products_price>=50.00 but if the product is say on special for 39.99 and the regular price is $50.00 it will still end up on the feed. I guess this is not so bad considering.. Any thoughts?
  13. dootch

    Automatically send data feed to Froogle

    Sorry John I should have clarified I have modified this to work with Yahoo and Nextag as well as using it for free froogle..
  14. dootch

    Automatically send data feed to Froogle

    I have alot of items on my store that are very inexpensive so I do not want to pay say $.50 cents per click for a $.10 item. Is there a way to say only pull products that are $50.00 and above for the output file??? I currently manually sort and cut and ftp. I would like to automate this process. Thanks in advance
  15. dootch

    Support Tickets

    An oldie but it may help someone else looking for the answer in faq.php take out the <ul> tag at line 86 and the </ul> tag at line 91
×