pingpongrob
Members-
Posts
104 -
Joined
-
Last visited
Profile Information
-
Real Name
Robert
-
Gender
Male
-
Location
Australia
Recent Profile Visitors
pingpongrob's Achievements
-
Hi Frank, Installed the Australian Postage Module into a new OSCommerce store - Thanks for the contribution. My Problem is that the postal charges that are displayed are all EX GST. I have set up the zones correctly, and my cart updates the product with gst, but not the postage fee. Am I doing something wrong, or is there a bit of code missing. site: www.justtabletennis.com.au The product i'm using for testing is "Plasma 380" all other products are as per fresh install. Thanks in advance. Rob
-
I tried to install this package, but only the express service is showing. Not sure what went wrong.
-
NEW! Complete Order Editing Tool!
pingpongrob replied to jhilgeman's topic in General Add-Ons Support
I noticed that when order are edited, the are not in SSL mode, and sensitive customer data can be seen. Is there any way of changing it so the edits are all done whilst the page is in HTTPS mode. -
Seperate Pricing Per Customer v3.5
pingpongrob replied to scendent's topic in General Add-Ons Support
Thank you Jan, I copied the index.php file from my sister in Laws Website (which I created), and all is fine. Would really like to know how these problems arise. -
Seperate Pricing Per Customer v3.5
pingpongrob replied to scendent's topic in General Add-Ons Support
Hello Jan, When I replace the queries from the Update, I get the following error. Parse error: syntax error, unexpected ';', expecting T_PAAMAYIM_NEKUDOTAYIM in /home/affordab/public_html/shop/index.php on line 233 -
Seperate Pricing Per Customer v3.5
pingpongrob replied to scendent's topic in General Add-Ons Support
Thanks Jan for responding. How do I go about fixing them. Do I have to upgrade to the new version of SPPC. -
Seperate Pricing Per Customer v3.5
pingpongrob replied to scendent's topic in General Add-Ons Support
Hi Jan, not sure what happened this time, but all was working fine and all of a sudden this error occurs. 1054 - Unknown column 'p.products_id' in 'on clause' select count(p.products_id) as total from products p, products_description pd, manufacturers m left join specials_retail_prices s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '27' [TEP STOP] have looked back through the post to see if i could find the error, but I just cant see it. here is the section of the code that I believe the error belongs to: // BOF Separate Pricing Per Customer if ($status_product_prices_table == true) { $listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, tmp_pp.products_price, p.products_tax_class_id, IF(tmp_pp.status, tmp_pp.specials_new_products_price, NULL) as specials_new_products_price, IF(tmp_pp.status, tmp_pp.specials_new_products_price, tmp_pp.products_price) as final_price from " . TABLE_PRODUCTS . " p left join " . $product_prices_table . " as tmp_pp using(products_id), " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_status = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['filter_id'] . "' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$current_category_id . "'"; } else { // either retail or no need to get correct special prices $listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c left join " . TABLE_SPECIALS_RETAIL_PRICES . " s using(products_id) where p.products_status = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['filter_id'] . "' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$current_category_id . "'"; } // end else { // either retail... // EOF Separate Pricing Per Customer } else { // We show them all // BOF Separate Pricing Per Customer if ($status_product_prices_table == true) { $listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, tmp_pp.products_price, p.products_tax_class_id, IF(tmp_pp.status, tmp_pp.specials_new_products_price, NULL) as specials_new_products_price, IF(tmp_pp.status, tmp_pp.specials_new_products_price, tmp_pp.products_price) as final_price from " . TABLE_PRODUCTS_DESCRIPTION . " pd left join " . $product_prices_table . " as tmp_pp using(products_id), " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$current_category_id . "'"; } else { // either retail or no need to get correct special prices $listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id left join " . TABLE_SPECIALS_RETAIL_PRICES . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$current_category_id . "'"; } // end else { // either retail... // EOF Separate Pricing per Customer thanks in advance. -
Free Shipping on orders over $xx, Excluding Certain items
pingpongrob replied to azriel's topic in Shipping Modules
You can istall this Add on Free Shiiping - Exclude items It works, but has a layout problem in Admin. -
[CONTRIBUTION] PDF Customer Invoice
pingpongrob replied to chris23's topic in General Add-Ons Support
Hi, I was wondering if anyone could help me with a couple of problems with my PDF Invoice contribution installation. I have been through it a couple of times adjusting the value's trying to reposition the text, but cannont find the answer. Here are the pics. Notice the PDF_INV_COMMENTS This is the Payment Text all messed up. Any help would be much appreciated. -
Seperate Pricing Per Customer v3.5
pingpongrob replied to scendent's topic in General Add-Ons Support
Thank you very much Jan - that did the trick. -
Seperate Pricing Per Customer v3.5
pingpongrob replied to scendent's topic in General Add-Ons Support
Hi Jan, I added the comma and 2 spaces, and I still the the error below. 1054 - Unknown column 'p.manufacturers_id' in 'on clause' select count(p.products_id) as total from products_description pd left join products_group_prices_cg_1 as tmp_pp using(products_id) left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products p, products_to_categories p2c where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '14' [TEP STOP] -
Seperate Pricing Per Customer v3.5
pingpongrob replied to scendent's topic in General Add-Ons Support
So where should the Comma and 2 spaces be placed. -
Seperate Pricing Per Customer v3.5
pingpongrob replied to scendent's topic in General Add-Ons Support
Hi Jan, Tried that but still got the same error. here's the section of Code. // We show them all // BOF Separate Pricing Per Customer if ($status_product_prices_table == true) { $listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, tmp_pp.products_price, p.products_tax_class_id, IF(tmp_pp.status, tmp_pp.specials_new_products_price, NULL) as specials_new_products_price, IF(tmp_pp.status, tmp_pp.specials_new_products_price, tmp_pp.products_price) as final_price from " . TABLE_PRODUCTS_DESCRIPTION . " pd left join " . $product_prices_table . " as tmp_pp using(products_id) left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id, " . TABLE_PRODUCTS . " p" . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$current_category_id . "'"; } else { // either retail or no need to get correct special prices $listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id left join " . TABLE_SPECIALS_RETAIL_PRICES . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$current_category_id . "'"; } // end else { // either retail... // EOF Separate Pricing per Customer Also I'm sure that their was a way of pasting code into these text boxes in the past. Thanks in advance. -
Seperate Pricing Per Customer v3.5
pingpongrob replied to scendent's topic in General Add-Ons Support
Jan you are still a ledgend, but I jumped the gun. I tested it without loging in to dealer pricing. Once logged in, the error still comes up. I copied a section of code, that might be causing the problem - index.php // BOF Separate Pricing Per Customer if ($status_product_prices_table == true) { $listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, tmp_pp.products_price, p.products_tax_class_id, IF(tmp_pp.status, tmp_pp.specials_new_products_price, NULL) as specials_new_products_price, IF(tmp_pp.status, tmp_pp.specials_new_products_price, tmp_pp.products_price) as final_price from " . TABLE_PRODUCTS . " p left join " . $product_prices_table . " as tmp_pp using(products_id), " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "'"; } else { // either retail or no need to get correct special prices $listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m left join " . TABLE_SPECIALS_RETAIL_PRICES . " s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "'"; } // end else { // either retail... // EOF Separate Pricing Per Customer -
Seperate Pricing Per Customer v3.5
pingpongrob replied to scendent's topic in General Add-Ons Support
Thank you very much Jan, you are an absolute legend of the OS Commerce comunity. :thumbsup: