Jump to content

theman

Members
  • Content count

    157
  • Joined

  • Last visited

Everything posted by theman

  1. nm that was the part where i had to edit product info..just working on fixing the tables to align properly now sorry for buggin anyone
  2. ok got the first problem fixed........so product stock i can set correctly but when i order a product it does not deduct the stock
  3. hi im having some problems with this contribution i did everything (except add to product_info.php..im in the process of doing that as it is a very heavily modified version) but when i go to stock.php it doesent work this is how it looks i dont know what is wrong
  4. theman

    Seperate Pricing Per Customer v3.5

    Hi guys...i installed this contrib and it is working expcept for one error.... eg.. Item 1 Retail Price: $10 Wholesale: $5 if im logged in as a wholesale acount it shows item 1 as the proper pricing...the shopping_cart box on the right column shows the proper total price..but when i go into my shoppingcart..and from then on (shipping_confirmation) it shows retail price as item price...i dont know what error has been made... plz help..in which file would this function for calling the total place reside?
  5. Hi guys...i installed this contrib and it is working expcept for one error.... eg.. Item 1 Retail Price: $10 Wholesale: $5 if im logged in as a wholesale acount it shows item 1 as the proper pricing...the shopping_cart box on the right column shows the proper total price..but when i go into my shoppingcart..and from then on (shipping_confirmation) it shows retail price as item price...i dont know what error has been made... plz help..in which file would this function for calling the total place reside?
  6. theman

    Seperate Pricing Per Customer v3.5

    Hi, I have added a specials table (using Specials on Default.php contribution) to my index.php so it shows my specials on the first page...and tried doing the specials addon for this seperate pricing per customer contribution, but i dont know what to change in this one php file to make it work correctly, any help would be greatly appreciated. Here is the code for my default_specials.php <?php /* ?$Id: default_specials.php,v 2.0 2003/06/13 ?osCommerce, Open Source E-Commerce Solutions ?http://www.oscommerce.com ?Copyright (c) 2003 osCommerce ?Released under the GNU General Public License */ if ( (!isset($new_products_category_id)) || ($new_products_category_id == '0') ) { ?$new = tep_db_query("select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_SPECIALS . " s where p.products_status = '1' and s.products_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '" . $languages_id . "' and s.status = '1' order by s.specials_date_added DESC limit " . MAX_DISPLAY_SPECIAL_PRODUCTS); } else { ?$new = tep_db_query("select distinct p.products_id, p.products_image, p.products_tax_class_id, if(s.status, s.specials_new_products_price, p.products_price) as products_price, s.specials_new_products_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.parent_id = '" . (int)$new_products_category_id . "' and p.products_status = '1' and s.status = '1' order by p.products_date_added desc limit " . MAX_DISPLAY_NEW_PRODUCTS); } if (tep_db_num_rows($new) > 0) { ?> <!-- default_specials //--> ?<tr> ? ? ?</tr> ? ? ?<tr> ? ? ? ?<td><table border="0" width="100%" cellspacing="0" cellpadding="2"> ? ? ? ? ?<tr> <?php $info_box_contents = array(); ?$info_box_contents[] = array('align' => 'left', 'text' => sprintf(TABLE_HEADING_DEFAULT_SPECIALS, strftime('%B'))); ?//new infoBoxHeading($info_box_contents, false, false, tep_href_link(FILENAME_SPECIALS)); ?new infoBoxHeading($info_box_contents,false,false); ?$info_box_contents = array(); ?$row = 0; ?$col = 0; ?while ($default_specials = tep_db_fetch_array($new)) { ? ?$default_specials['products_name'] = tep_get_products_name($default_specials['products_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=' . $default_specials["products_id"]) . '">' . tep_image(DIR_WS_IMAGES . $default_specials['products_image'], $default_specials['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a><br><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $default_specials['products_id']) . '">' . $default_specials['products_name'] . '</a><br><s>' . $currencies->display_price($default_specials['products_price'], tep_get_tax_rate($default_specials['products_tax_class_id'])) . '</s><br><span class="productSpecialPrice">' . $currencies->display_price($default_specials['specials_new_products_price'], tep_get_tax_rate($default_specials['products_tax_class_id'])) . '</span>'); ? ?$col ++; ? ?if ($col > 2) { ? ? ?$col = 0; ? ? ?$row ++; ? ?} ?} ?new contentBox($info_box_contents); } ?> <!-- default_specials_eof //-->
  7. Hi, I am currently using easy populate along with seperate pricing per customer....it was working fine, and now i try to update/add products and it only adds one new product then gives me the following error: 1064 - You have an error in your SQL syntax near ')' at line 10 INSERT INTO products_groups VALUES ( 1, 54.95, 1910, ) [TEP STOP] i do not know whats wrong..can someone please help me
  8. I am currently using EP but when i want to include attributes it becomes a problem..I am trying to add the atrribute COLOR but the problem is i have many different colors available (blue,black,blue with black stripes,bluewith white stripes etc,etc,etc) now do i have to make a column for each color or is there an easier way around this
  9. theman

    Seperate Pricing Per Customer v3.5

    Hello, I recently installed this mod workin great except few things when i find product threw either search or categories it displays web price and not group discount price..but when item is clicked on it displays current price..could i have missed something? if so which file would i look at help would be greatly aprreciated..
  10. theman

    Seperate Pricing Per Customer v3.5

    hmm..seems Scott has dissappeared...so im guessing waiting for vers 4.0 with ability to hide products to some users wont be coming anytime soon? if anyone else could work on this mod would be greatly appreciated by me and many others i presume.
  11. theman

    QuickBooks Contrib

    would like to know if its possible to import QuickBook Pro / POS vers into oscommerce, like i would like to import my product database...i thought that this might be the easiest solution? any help would be geratly appreciated
  12. theman

    coolMenu

    indafastln, i follwed that post and it did not lock the toolbar (still moves when i resize the page) i dont know what im doing worng im pretty sure i folloewd the code jus as posted...plz hellp!
  13. theman

    coolMenu

    if anyone can help me that would be great..lookin for a way to lock the coolmenu infobox in place (so that when i add more categories or change resolution the box wont move on me and overlap other infoboxes such as the manufacturer box etc. thanks in advances
×