Jump to content

gaspower

Members
  • Content count

    453
  • Joined

  • Last visited

Everything posted by gaspower

  1. gaspower

    Linkpoint API Problems

    Thank you very much for the reply JR
  2. Hey jrvs, Thanks for the reply. Tried that, but still get the error. Seems to import the fist product fine, but after that the error occurs?? Size: 2533 | MSIMPRO | Microsoft | Every elem | www.micros | microsoft/ | 500 | 125 | | | | | | | | | | | | | | 300 | 1 | 200 | 2 | 0 | 3 | 0 | 4 | 0 | 7 | 11/30/1999 | 8/7/2007 1 | Warner | Hardware | category_h | Mice | subcategor | | | Taxable Go | Active Updated 1136 - Column count doesn't match value count at row 1 INSERT INTO products_groups VALUES ( 1, 300, 3 ) ----------------------------------------------------------------- EP File txt v_products_model v_products_name_1 v_products_description_1 v_products_url_1 v_products_image v_products_price v_products_cost v_products_image_med v_products_image_lrg v_products_image_sm_1 v_products_image_xl_1 v_products_image_sm_2 v_products_image_xl_2 v_products_image_sm_3 v_products_image_xl_3 v_products_image_sm_4 v_products_image_xl_4 v_products_image_sm_5 v_products_image_xl_5 v_products_image_sm_6 v_customer_price_1 v_customer_group_id_1 v_customer_price_2 v_customer_group_id_2 v_customer_price_3 v_customer_group_id_3 v_customer_price_4 v_customer_group_id_4 v_products_quantity v_products_weight v_date_avail v_date_added v_manufacturers_name v_categories_name_1 v_categories_image_1 v_categories_name_2 v_categories_image_2 v_categories_name_3 v_categories_image_3 v_tax_class_title v_status EOREOR MSIMPRO Microsoft IntelliMouse Pro Every element of IntelliMouse Pro - from its unique arched shape to the texture of the rubber grip around its base - is the product of extensive customer and ergonomic research. Microsofts popular wheel control which now allows zooming and universal scrolling functions gives IntelliMouse Pro outstanding comfort and efficiency. www.microsoft.com/hardware/mouse/intellimouse.asp microsoft/msimpro.gif 500 125 300 1 200 2 0 3 0 4 0 7 11/30/1999 0:00 8/7/2007 15:14 Warner Hardware category_hardware.gif Mice subcategory_mice.gif Taxable Goods Active EOREOR MSIMEXP Microsoft IntelliMouse Explorer Microsoft introduces its most advanced mouse the IntelliMouse Explorer! IntelliMouse Explorer features a sleek design an industrial-silver finish a glowing red underside and taillight creating a style and look unlike any other mouse. IntelliMouse Explorer combines the accuracy and reliability of Microsoft IntelliEye optical tracking technology the convenience of two new customizable function buttons the efficiency of the scrolling wheel and the comfort of expert ergonomic design. All these great features make this the best mouse for the PC! www.microsoft.com/hardware/mouse/explorer.asp microsoft/imexplorer.gif 500 125 ofn19004.jpg ofn19004.jpg ofn19028.jpg ofn19028.jpg ofn28001.jpg ofn28001.jpg 300 1 200 2 0 3 0 4 21 1 11/30/1999 0:00 8/7/2007 15:14 Microsoft Hardware category_hardware.gif Mice subcategory_mice.gif Taxable Goods Active EOREOR OFN19001 OFNA Crown Gear OFNA Crown Gear ofn19001.jpg 20 5 15 1 10 2 0 3 0 4 100 0.03 11/30/1999 0:00 11/9/2007 11:04 Canon Parts ofn19001.jpg Taxable Goods Active EOREOR Thanks JR
  3. gaspower

    Linkpoint API Problems

    Hello, Is it possible at all for Linkpoint to work on a shared server that port 1129 is not open. My friend is on a shared server with Network Solutions, and they will not open port 1129. Any work around? Thanks JR
  4. gaspower

    Seperate Pricing Per Customer v3.5

    Hey Jan, Hope all is well. By chance have you used the Quantity Price Breaks with Easy Populate? I get a 1136 error, but from what I can see, there are equal fields and data on the EP import? Thanks JR
  5. gaspower

    Seperate Pricing Per Customer v3.5

    Hey Jan, Fixed the issue with inserting new specials, but still have the issue of not showing the price for retail. Thanks JR
  6. gaspower

    Seperate Pricing Per Customer v3.5

    Hey Jan, Also relating to my above note, and this also be part of the issue, is that I can not insert new specials? Once the insert button is pressed, it just reverts back to the original specials page? Thanks JR
  7. gaspower

    Seperate Pricing Per Customer v3.5

    Hey Jan, Thanks for the note, makes sense. I do have another question (of course HA!). I noticed on one of my sites, and I have four identical with you SPPC and Quantity Breaks that one of them in the admin specials where product drop down menu is, that retail is $0.00. The rest of the groups have pricing and it is only on one of the sites, this issue. I copied over specials.php from another site that is working fine and still same issue. Where should I look? Thanks JR
  8. gaspower

    Seperate Pricing Per Customer v3.5

    Hey Jan, I am using the quantity price break contribution of yours with the SPPC 4.20. All installed perfect and seems to all work except for one issue. And I might be crazy, because I thought it worked prior. I thought when the group price is set below the quantity discount price the table that shows the quantity pricing disappeared? Is this correct. On my site, no matter what I set the group price, the quantity price table always shows. If it is supposed to disappear, what did I mis? Thanks JR
  9. gaspower

    Seperate Pricing Per Customer v3.5

    Hey Jan, Thank you. I did fined it there, but one issue I can not get around. Now if a product has a quantity discount it shows, MSRP: $20.00 Your Price: $4.00 3+ $3.00 Done here in getPriceString function, else { $lc_text = '<table align="top" border="0" cellspacing="0" cellpadding="0">'; $lc_text .= '<tr><TD class="pageHeading">Your Price: </TD><td align="center" class="pageHeading" colspan="2">' . $currencies->display_price($this->thePrice, tep_get_tax_rate($this->taxClass)) . '</td></tr>'; ------------------------------------------------------------------------------------------------------ But item without quanity discount, I loose the "Your Price"? MSRP: $300.00 $60.00 ---------------------------------------------------------------------------------------------------------- I am trying to see in Priceformatter.php where when an item does not have quanity discount, where the group price is loaded? Thanks Jr
  10. gaspower

    Seperate Pricing Per Customer v3.5

    Hey Jan, Question on the quantity price breaks. I currently in product info have it viewing like this: MSRP: $20.00 Your Price: $4.00 And line in product_info.php is, <?php if ($customer_group_id > 0) { $retail_price = $currencies->display_price($product_info['retail_price'], tep_get_tax_rate($product_info['products_tax_class_id'])); echo TEXT_RETAIL_PRICE; echo $retail_price; } ?> <BR> <?php echo TEXT_YOUR_PRICE; ?><?php echo $products_price; ?> ----------------------------------------------------------------------------------------------------------------------- And when I initiate a quantity discount on an item I get this, MSRP: $20.00 Your Price: $4.00 3+ $3.00 --------------------------------------------------------------------------------------------------------------------------------- I would prefer to remove the $4.00 from current line and bring back to original view, so it looks like this, MSRP: $20.00 Your Price: $4.00 3+ $3.00 Thanks JR
  11. gaspower

    Seperate Pricing Per Customer v3.5

    Hey Jan, Sorry, I mis-read the install sheet. Should not do this early in the morning HA!. Works fine Thanks JR
  12. gaspower

    Seperate Pricing Per Customer v3.5

    Hey Jan, I am trying another one of your great contributions, Quantity Discounts 1.2. Having a little issue. I have altered the database with the sql, and changed the product_listing.php and application_top.php. As I change files I like to refresh the site to make sure no errors before getting to deep. I notice after updating the two above files, product listings page breaks (I loose the right column)? I viewed other pages to be modified, but did not notice any that would effect this page? So This: break; // EOF Separate Pricing per Customer case 'PRODUCT_LIST_BUY_NOW': $lc_align = 'center'; $lc_text = '<a href="' . tep_href_link(basename($PHP_SELF), tep_get_all_get_params(array('action')) . 'action=buy_now&products_id=' . $listing[$x]['products_id']) . '">' . tep_image_button('button_buy_now.gif', IMAGE_BUTTON_BUY_NOW) . '</a> '; break; } -------------------------------------------- to this: // BOF Separate Pricing per Customer, Price Break 1.11.3 modification $no_of_listings = tep_db_num_rows($listing_query); // global variable (session) $sppc_customer_group_id -> local variable customer_group_id if(!tep_session_is_registered('sppc_customer_group_id')) { $customer_group_id = '0'; } else { $customer_group_id = $sppc_customer_group_id; } $default_settings = array('products_price1' => '0.0000', 'products_price2' => '0.0000', 'products_price3' => '0.0000', 'products_price4' => '0.0000', 'products_price5' => '0.0000', 'products_price6' => '0.0000', 'products_price7' => '0.0000', 'products_price8' => '0.0000', 'products_price1_qty' => '0', 'products_price2_qty' => '0', 'products_price3_qty' => '0', 'products_price4_qty' => '0', 'products_price5_qty' => '0', 'products_price6_qty' => '0', 'products_price7_qty' => '0', 'products_price8_qty' => '0', 'products_qty_blocks' => '1'); while ($_listing = tep_db_fetch_array($listing_query)) { // let's start with default settings, you never know $_new_listing = array_merge($_listing , $default_settings); $listing[] = $_new_listing; $list_of_prdct_ids[] = $_listing['products_id']; } // next part is a debug feature, when uncommented it will print the info that this module receives /* echo '<pre>'; print_r($listing); echo '</pre>'; */ $select_list_of_prdct_ids = "products_id = '".$list_of_prdct_ids[0]."' "; if ($no_of_listings > 1) { for ($n = 1 ; $n < count($list_of_prdct_ids) ; $n++) { $select_list_of_prdct_ids .= "or products_id = '".$list_of_prdct_ids[$n]."' "; } } // to avoid messing with index.php, which is complicated of itself already // we add another query here to get the price break variables for retail customers // for other groups we change the $pg_query from the one in SPPC4 if ($customer_group_id == '0') { $retail_price_break_query = tep_db_query("select p.products_id, p.products_price1, p.products_price2, p.products_price3, p.products_price4, p.products_price5, p.products_price6, p.products_price7, p.products_price8, p.products_price1_qty, p.products_price2_qty, p.products_price3_qty, p.products_price4_qty, p.products_price5_qty, p.products_price6_qty, p.products_price7_qty, p.products_price8_qty, p.products_qty_blocks from " . TABLE_PRODUCTS . " p where " . $select_list_of_prdct_ids . ""); while ($rp_break = tep_db_fetch_array($retail_price_break_query)) { for ($u = 0; $u < $no_of_listings; $u++) { if ($rp_break['products_id'] == $listing[$u]['products_id']) { $listing[$u]['products_price1'] = $rp_break['products_price1']; $listing[$u]['products_price2'] = $rp_break['products_price2']; $listing[$u]['products_price3'] = $rp_break['products_price3']; $listing[$u]['products_price4'] = $rp_break['products_price4']; $listing[$u]['products_price5'] = $rp_break['products_price5']; $listing[$u]['products_price6'] = $rp_break['products_price6']; $listing[$u]['products_price7'] = $rp_break['products_price7']; $listing[$u]['products_price8'] = $rp_break['products_price8']; $listing[$u]['products_price1_qty'] = $rp_break['products_price1_qty']; $listing[$u]['products_price2_qty'] = $rp_break['products_price2_qty']; $listing[$u]['products_price3_qty'] = $rp_break['products_price3_qty']; $listing[$u]['products_price4_qty'] = $rp_break['products_price4_qty']; $listing[$u]['products_price5_qty'] = $rp_break['products_price5_qty']; $listing[$u]['products_price6_qty'] = $rp_break['products_price6_qty']; $listing[$u]['products_price7_qty'] = $rp_break['products_price7_qty']; $listing[$u]['products_price8_qty'] = $rp_break['products_price8_qty']; $listing[$u]['products_qty_blocks'] = $rp_break['products_qty_blocks']; } // end if ($rp_break['products_id'] == $listing[$u]['products_id']) } // end for ($u = 0; $u < $no_of_listings; $u++) } // end while ($rp_break = tep_db_fetch_array($retail_price_break_query) } // end if ($customer_group_id == '0') // get all product prices for products with the particular customer_group_id // however not necessary for customer_group_id = 0 if ($customer_group_id != '0') { $pg_query = tep_db_query("select pg.products_id, customers_group_price as price, pg.products_price1, pg.products_price2, pg.products_price3, pg.products_price4, pg.products_price5, pg.products_price6, pg.products_price7, pg.products_price8, pg.products_price1_qty, pg.products_price2_qty, pg.products_price3_qty, pg.products_price4_qty, pg.products_price5_qty, pg.products_price6_qty, pg.products_price7_qty, pg.products_price8_qty, pg.products_qty_blocks from " . TABLE_PRODUCTS_GROUPS . " pg where (".$select_list_of_prdct_ids.") and pg.customers_group_id = '".$customer_group_id."' "); // $no_of_pg_products = tep_db_num_rows($pg_query) ; while ($pg_array = tep_db_fetch_array($pg_query)) { $new_prices[] = array ('products_id' => $pg_array['products_id'], 'products_price' => $pg_array['price'], 'specials_new_products_price' => '', 'final_price' => $pg_array['price'], 'products_price1' => $pg_array['products_price1'], 'products_price2' => $pg_array['products_price2'], 'products_price3' => $pg_array['products_price3'], 'products_price4' => $pg_array['products_price4'], 'products_price5' => $pg_array['products_price5'], 'products_price6' => $pg_array['products_price6'], 'products_price7' => $pg_array['products_price7'], 'products_price8' => $pg_array['products_price8'], 'products_price1_qty' => $pg_array['products_price1_qty'], 'products_price2_qty' => $pg_array['products_price2_qty'], 'products_price3_qty' => $pg_array['products_price3_qty'], 'products_price4_qty' => $pg_array['products_price4_qty'], 'products_price5_qty' => $pg_array['products_price5_qty'], 'products_price6_qty' => $pg_array['products_price6_qty'], 'products_price7_qty' => $pg_array['products_price7_qty'], 'products_price8_qty' => $pg_array['products_price8_qty'], 'products_qty_blocks' => $pg_array['products_qty_blocks']); } for ($x = 0; $x < $no_of_listings; $x++) { // replace products prices with those from customers_group table if(!empty($new_prices)) { for ($i = 0; $i < count($new_prices); $i++) { if( $listing[$x]['products_id'] == $new_prices[$i]['products_id'] ) { $listing[$x]['products_price'] = $new_prices[$i]['products_price']; $listing[$x]['final_price'] = $new_prices[$i]['final_price']; $listing[$x]['products_price1'] = $new_prices[$i]['products_price1']; $listing[$x]['products_price2'] = $new_prices[$i]['products_price2']; $listing[$x]['products_price3'] = $new_prices[$i]['products_price3']; $listing[$x]['products_price4'] = $new_prices[$i]['products_price4']; $listing[$x]['products_price5'] = $new_prices[$i]['products_price5']; $listing[$x]['products_price6'] = $new_prices[$i]['products_price6']; $listing[$x]['products_price7'] = $new_prices[$i]['products_price7']; $listing[$x]['products_price8'] = $new_prices[$i]['products_price8']; $listing[$x]['products_price1_qty'] = $new_prices[$i]['products_price1_qty']; $listing[$x]['products_price2_qty'] = $new_prices[$i]['products_price2_qty']; $listing[$x]['products_price3_qty'] = $new_prices[$i]['products_price3_qty']; $listing[$x]['products_price4_qty'] = $new_prices[$i]['products_price4_qty']; $listing[$x]['products_price5_qty'] = $new_prices[$i]['products_price5_qty']; $listing[$x]['products_price6_qty'] = $new_prices[$i]['products_price6_qty']; $listing[$x]['products_price7_qty'] = $new_prices[$i]['products_price7_qty']; $listing[$x]['products_price8_qty'] = $new_prices[$i]['products_price8_qty']; $listing[$x]['products_qty_blocks'] = $new_prices[$i]['products_qty_blocks']; } } } // end if(!empty($new_prices) $listing[$x]['specials_new_products_price'] = ''; // makes sure that a retail specials price doesn't carry over to another customer group $listing[$x]['final_price'] = $listing[$x]['products_price']; // final price should not be the retail special price } // end for ($x = 0; $x < $no_of_listings; $x++) } // end if ($customer_group_id != '0') // an extra query is needed for all the specials $specials_query = tep_db_query("select products_id, specials_new_products_price from " . TABLE_SPECIALS . " where (".$select_list_of_prdct_ids.") and status = '1' and customers_group_id = '" .$customer_group_id. "'"); while ($specials_array = tep_db_fetch_array($specials_query)) { $new_s_prices[] = array ('products_id' => $specials_array['products_id'], 'products_price' => '', 'specials_new_products_price' => $specials_array['specials_new_products_price'] , 'final_price' => $specials_array['specials_new_products_price']); } // add the correct specials_new_products_price and replace final_price for ($x = 0; $x < $no_of_listings; $x++) { if(!empty($new_s_prices)) { for ($i = 0; $i < count($new_s_prices); $i++) { if( $listing[$x]['products_id'] == $new_s_prices[$i]['products_id'] ) { $listing[$x]['specials_new_products_price'] = $new_s_prices[$i]['specials_new_products_price']; $listing[$x]['final_price'] = $new_s_prices[$i]['final_price']; } } } // end if(!empty($new_s_prices) } // end for ($x = 0; $x < $no_of_listings; $x++) // while ($listing = tep_db_fetch_array($listing_query)) { (was original code) for ($x = 0; $x < $no_of_listings; $x++) { $rows++; if (($rows/2) == floor($rows/2)) { $list_box_contents[] = array('params' => 'class="productListing-even"'); } else { $list_box_contents[] = array('params' => 'class="productListing-odd"'); } $cur_row = sizeof($list_box_contents) - 1; for ($col=0, $n=sizeof($column_list); $col<$n; $col++) { $lc_align = ''; switch ($column_list[$col]) { case 'PRODUCT_LIST_MODEL': $lc_align = ''; $lc_text = ' ' . $listing[$x]['products_model'] . ' '; break; case 'PRODUCT_LIST_NAME': $lc_align = ''; if (isset($HTTP_GET_VARS['manufacturers_id'])) { $lc_text = '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'manufacturers_id=' . $HTTP_GET_VARS['manufacturers_id'] . '&products_id=' . $listing[$x]['products_id']) . '">' . $listing[$x]['products_name'] . '</a>'; } else { $lc_text = ' <a href="' . tep_href_link(FILENAME_PRODUCT_INFO, ($cPath ? 'cPath=' . $cPath . '&' : '') . 'products_id=' . $listing[$x]['products_id']) . '">' . $listing[$x]['products_name'] . '</a> '; } break; case 'PRODUCT_LIST_MANUFACTURER': $lc_align = ''; $lc_text = ' <a href="' . tep_href_link(FILENAME_DEFAULT, 'manufacturers_id=' . $listing[$x]['manufacturers_id']) . '">' . $listing[$x]['manufacturers_name'] . '</a> '; break; case 'PRODUCT_LIST_PRICE': $lc_align = 'right'; /* removed for price break modification if (tep_not_null($listing[$x]['specials_new_products_price'])) { $lc_text = ' <s>' . $currencies->display_price($listing[$x]['products_price'], tep_get_tax_rate($listing[$x]['products_tax_class_id'])) . '</s> <span class="productSpecialPrice">' . $currencies->display_price($listing[$x]['specials_new_products_price'], tep_get_tax_rate($listing[$x]['products_tax_class_id'])) . '</span> '; } else { $lc_text = ' ' . $currencies->display_price($listing[$x]['products_price'], tep_get_tax_rate($listing[$x]['products_tax_class_id'])) . ' '; } end removed for price break modification, see next two lines for replacement code */ $pf->parse($listing[$x]); $lc_text = $pf->getPriceStringShort(); break; case 'PRODUCT_LIST_QUANTITY': $lc_align = 'right'; $lc_text = ' ' . $listing[$x]['products_quantity'] . ' '; break; case 'PRODUCT_LIST_WEIGHT': $lc_align = 'right'; $lc_text = ' ' . $listing[$x]['products_weight'] . ' '; break; case 'PRODUCT_LIST_IMAGE': $lc_align = 'center'; if (isset($HTTP_GET_VARS['manufacturers_id'])) { $lc_text = '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'manufacturers_id=' . $HTTP_GET_VARS['manufacturers_id'] . '&products_id=' . $listing[$x]['products_id']) . '">' . tep_image(DIR_WS_IMAGES . $listing[$x]['products_image'], $listing[$x]['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a>'; } else { $lc_text = ' <a href="' . tep_href_link(FILENAME_PRODUCT_INFO, ($cPath ? 'cPath=' . $cPath . '&' : '') . 'products_id=' . $listing[$x]['products_id']) . '">' . tep_image(DIR_WS_IMAGES . $listing[$x]['products_image'], $listing[$x]['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a> '; } break; case 'PRODUCT_LIST_BUY_NOW': $lc_align = 'center'; $lc_text = '<a href="' . tep_href_link(basename($PHP_SELF), tep_get_all_get_params(array('action')) . 'action=buy_now&products_id=' . $listing[$x]['products_id']) . '">' . tep_image_button('button_buy_now.gif', IMAGE_BUTTON_BUY_NOW) . '</a> '; break; } // EOF Separate Pricing per Customer, Price Break 1.11.3 modification Thanks JR
  13. gaspower

    [Contribution] - USPS Methods

    Hello, Please disregard the above question, I apologize, when I re-set the database it put the zip code to none, it now works. Thanks JR
  14. gaspower

    [Contribution] - USPS Methods

    Hello, In the past I have always used v2.76 and go through the new rate updates. But on my new server, I thought I would try v2.92a. But, I get the message, An error occured with the USPS shipping calculations. If you prefer to use USPS as your shipping method, please contact the store owner. Please if someone can tell me if the steps I followed are correct, 1. Uploaded the new catalog usps.php 2. modified other files as instructed. 3. ALTER TABLE `configuration` CHANGE `set_function` `set_function` TEXT 4. UPDATE `configuration` SET `set_function` = 'tep_cfg_select_multioption(array(''Global Express'', ''Global Express Non-Doc Rect'', ''Global Express Non-Doc Non-Rect'', ''Express Mail Int'', ''Express Mail Int Flat Rate Env'', ''Priority Mail Int'', ''Priority Mail Int Flat Rate Env'', ''Priority Mail Int Flat Rate Box'', ''First-Class Mail Int''),' WHERE `configuration_id` =196 LIMIT 1 ; 5. Then ran update.sql supplied in 2.92a contribution. Any help would be great. Thanks JR
  15. Hello, No this means currently that the longest number you can enter is up to 12 digits. You can change this value to whatever, but will also need to change it in the configuration portion of the admin to match. JR
  16. Hello, I just uploaded as a contribution a version of Easy Populate that will work with Ultra Pics. I hope it makes things easier for you. http://addons.oscommerce.com/info/5578 JR
  17. Hello, I am using EP 2.76F-MS2 r1, and works great until I added Ultra Pics. Has anyone been able to get any of the EP versions to work with Ultra Pics? I do not see a Ultra Pic define in EP2.76F, and turned on unknown image support? Thanks JR
  18. gaspower

    Seperate Pricing Per Customer v3.5

    Hello Jan, I have one site using the SPPC 4.16 version, but for some reason, just noticed it, specials are showing in all groups. I have specials in group 2 (dealers), and it is showing in group 0 (retail)? What should I be looking for to fix? I probably crossed something wrong, but I did check loin.php and specials.php and did not see anything wrong? Thanks JR
  19. gaspower

    Seperate Pricing Per Customer v3.5

    Thank you as always JR
  20. gaspower

    Seperate Pricing Per Customer v3.5

    Hello, I uploaded a contribution for SPPC, Quick Group Discount Module, (http://addons.oscommerce.com/info/5569/v,22). It allows from admin panel to give complete groups percentage discounts. Example, say you had a group called dealers and currently the discount from retail is 40%, but you wanted to change the entire group to 50%, just go to this panel and set the dealers to 50%, entire group will now reflect 50% off of retail. First contribution, and hope it saves you time. Thanks JR
  21. gaspower

    Seperate Pricing Per Customer v3.5

    Hello, I have been using SPPC for a while and it works great. I just started a new site and I am getting the following error, 1054 - Unknown column 'c.entry_company_tax_id' in 'field list' select c.customers_id, c.customers_gender, c.customers_firstname, c.customers_lastname, c.customers_dob, c.customers_email_address, a.entry_company, c.entry_company_tax_id, a.entry_street_address, a.entry_suburb, a.entry_postcode, a.entry_city, a.entry_state, a.entry_zone_id, a.entry_country_id, c.customers_telephone, c.customers_fax, c.customers_newsletter, c.customers_group_id, c.customers_group_ra, c.customers_payment_allowed, c.customers_shipment_allowed, c.customers_specific_taxes_exempt, c.customers_default_address_id from customers c left join address_book a on c.customers_default_address_id = a.address_book_id where a.customers_id = c.customers_id and c.customers_id = '3' Any help would be great, Thanks JR
  22. Hello, Sorry, was able to find the error, had , , in the statement. Thanks JR
  23. Hello, I am getting the following error, 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' p.products_image_med, p.products_image_lrg, p.products_image_sm_1, p.products_i' at line 1 Happens as soon as I add the following line, , p.products_image_med, p.products_image_lrg, p.products_image_sm_1, p.products_image_xl_1, p.products_image_sm_2, p.products_image_xl_2, p.products_image_sm_3, p.products_image_xl_3, p.products_image_sm_4, p.products_image_xl_4, p.products_image_sm_5, p.products_image_xl_5, p.products_image_sm_6, p.products_image_xl_6 To get get final $product_query = tep_db_query("select pd.products_name, pd.products_description, pd.products_url, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_image_med, p.products_image_lrg, p.products_image_sm_1, p.products_image_xl_1, p.products_image_sm_2, p.products_image_xl_2, p.products_image_sm_3, p.products_image_xl_3, p.products_image_sm_4, p.products_image_xl_4, p.products_image_sm_5, p.products_image_xl_5, p.products_image_sm_6, p.products_image_xl_6, p.products_price, p.products_weight, p.products_date_added, p.products_last_modified, date_format(p.products_date_available, '%Y-%m-%d') as products_date_available, p.products_status, p.products_tax_class_id, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = '" . (int)$HTTP_GET_VARS['pID'] . "' and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "'"); Thanks JR
  24. gaspower

    QUICK PRICE/STOCK UPDATE

    Hello, Will version 1.13 work with contribution Special Pricing Per Customer 4.16? Thanks JR
  25. gaspower

    Low Stock Report v2.0

    Hello, I am using version 2.02 and it works great. Was just wondering if it currently has the ability to not show items that have been set to active off? Currently it is showing all items below the set amount in the admin, even though I have many not activated anymore. Thanks JR
×