Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

geomilli

Pioneers
  • Posts

    31
  • Joined

  • Last visited

About geomilli

  • Birthday 05/16/1970

Profile Information

  • Real Name
    George Milligan
  • Gender
    Male
  • Location
    Danbury, Connecticut USA
  • Interests
    Computers, Video Games, Comic Books, Collectibles, Skiing, Graphic Arts, Movies, Cartoons, etc.
  • Website

geomilli's Achievements

  1. As with everything here, example and explanation isn't clear enough to get the results we need... so here is my attempt at clarifying what is needed to be done to update the shipping arrays in usps.php. In the contribution for USPS Methods 6.1, you should have a PHP page installed that retrieves an updated array from the USPS server. Type into the address bar "your host... /catalog/admin/USPS_methods_utility.php" The page will display the array that ...catalog/includes/modules/shipping/usps.php needs to be updated with. Below is just a snippet of the results you should see, do not use it. Run the USPS_methods_utility.php yourself, because most likely this array is likely to change. Open usps.php and replace the code completely with the updated array from the request. Uninstall USPS from your admin panel and then reinstall it. Unfortunately, you will have to redo all of your settings... but it should be accurate and complete.
  2. As with everything here, example and explanation isn't clear enough to get the results we need... so here is my attempt at clarifying what is needed to be done to update the shipping arrays in usps.php. In the contribution for USPS Methods 6.1, you should have a PHP page installed that retrieves an updated array from the USPS server. Type into the address bar "your host... /catalog/admin/USPS_methods_utility.php" The page will display the array that ...catalog/includes/modules/shipping/usps.php needs to be updated with. Below is just a snippet of the results you should see, do not use it. Run the USPS_methods_utility.php yourself, because most likely this array is likely to change. Open usps.php and replace the code completely with the updated array from the request. Uninstall USPS from your admin panel and then reinstall it. Unfortunately, you will have to redo all of your settings... but it should be accurate and complete.
  3. OK, maybe Jetta can help here... I use Uniform Server to beta test my site before going live. I used http://addons.oscommerce.com/info/8403 to update the USPS functions and the above occurred in my last post. So, I figured I would go with a live swap out of the files and test it from there (what the heck!)... It works. Don't know why, other than that's a good thing. My provider actually has a older version of PHP running than my version in Uniform Server and MySQL is only a fraction of a version out from each other. I don't see that being the issue. Just thought I would post this little tip to help those that might be trying to resolve their install.
  4. Here's the debate... Use http://addons.oscommerce.com/info/8327 or http://addons.oscommerce.com/info/8403? I personally tried 8403 to the letter and all I get a blank page for checkout_shipping... However, the weight of the product displays when I moved up into the other upgrades. Curious... The min/max/handing dialog goes wacky, perhaps a database issue? I check one of the shipping methods and return to check it, and all I get is a minimum "Parcel Post" and the 70lbs. max jumps to the handling. Any ideas?
  5. In my post #5878, I have come up with a better explanation... If you link a product from one category to another, the product_id is identical. When you view products_new.php it will show the duplicated id's IE products from both categories because of this link. I don't want that. >_< This problem is also in featured_products.php, assuming an identical result. To prove that the code in my quote was not an issue, I started with a fresh install of osC and added SPPC and HP&C. The scenario is the same on product_new.php. I made a new category called "Our Favorites" and then linked the product Unreal Tournament to it. The product then appears in two places when product_new.php is displayed. Any ideas or fixes that I am not aware of? I have read through most of this forum and searched crazily, to no avail. However, I haven't stopped yet. :blink:
  6. Anyone using "Category Box Enhancement", version 1.1? Well, if you are then use the code snippet below to make it work with Hide Categories & Products. Just replace the code from the instructions for catalog/includes/boxes/categories.php. Line 14 // BOF SPPC hide categories from groups for "Category Box Enhancement", version 1.1 global $tree, $categories_string, $cPath_array, $customer_group_id, $languages_id; // EOF SPPC hide categories from groups Line 74 // BOF SPPC hide categories from groups for "Category Box Enhancement", version 1.1 $categories_query = tep_db_query("select c.categories_id, cd.categories_name, c.parent_id from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.parent_id = " . (int)$parent_id . $catstatus . " and c.categories_id = cd.categories_id and cd.language_id='" . (int)$languages_id ."' and find_in_set('" . $customer_group_id . "', categories_hide_from_groups) = 0 order by sort_order, cd.categories_name"); // EOF SPPC hide categories from groups FYI - This is for an install on RC2a.
  7. OOPS! Simple mistake on my end... made a configuration error on the admin side. Best Sellers was set to 5 as a minimum by mistake. However, to get it to work I had to purge my beta orders and customers to reset the system. I suppose from messing around with different groups and orders from those various settings the database was a bit confused. Delete orders and customers either by client or admin software, then you should be good again. I still have a problem with products in two categories or two specials for two groups displaying in various areas. If you have or had a similar problem let me know!
  8. Yes, it works with: Credit Class & Gift Voucher - http://www.oscommerce.com/community/contributions,282 or http://addons.oscommerce.com/info/8002 and if your interested... POINTS AND REWARDS MODULE V1.00 - http://www.oscommerce.com/community/contributions,3220
  9. Best Sellers Missing - Gone - Disappeared (for search reasons, because I can't find anything close in the forums) Has anyone experienced the disappearance of the Best Sellers box after installing SPPC and HP&C? Specials still active with conflicting settings (should this work or just deal with it?) Anyone get it working with Specials as well? There is a little problem with mine if you disable the entire category for retail customers and have specials from that category in a retail group the products from that category still show. Is that normal? Also, if you link to two categories for one product the products_new.php displays two of that same product on the page. My code is modified to be in columns, integrated for Ezier New Fields, SPPC and HP&C, Wishlist and a database name "products_namebreak" that I have created for display formatting so it's funky. I can post the code if anyone is interested, but I know it's not products_new.php, because I replaced it with the unaltered version from the install with the same results. I assume the problem is from somewhere else maybe? The call is from another page handed off to this one? Any insight would be great and if you know the post with the answer, thanks ahead of time!
  10. Ezier New Fields (ENF) and Separate Price Per Customer (SPPC) - product_listing_col.php Todd from post 263 had supplied some good information about installing ENF and SPPC together, however the problem I was experiencing with ENF after installing SPPC was exactly what was described by Todd. The symptoms are ENF works on the advanced_search_result.php but not on pages generated from the index.php. If that's the case then you missed something (like I did). I am a relative noob at PHP and if you are too, here is how the pages lead to each other. Once I realized that, it took me 2 minutes to fix the index.php and correct the display using product_listing_col.php. Product Listing - index.php hands off to product_listing_col.php Perform a Search - advanced_search_results.php hands off to product_listing_col.php advanced_search_result.php calls all the variables again and works if the index page does not. That is because you forgot to add the p.products_retail_price of ENF back into the index.php. Every line in the code below calls tmp_pp.products_price and needs p.products_retail_price added after it. EX: tmp_pp.products_price, p.products_retail_price, // show the products of a specified manufacturer if (isset($HTTP_GET_VARS['manufacturers_id'])) { if (isset($HTTP_GET_VARS['filter_id']) && tep_not_null($HTTP_GET_VARS['filter_id'])) { // We are asked to show only a specific category // BOF Separate Pricing Per Customer if ($status_product_prices_table == true) { // ok in mysql 5 $listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, tmp_pp.products_price, p.products_retail_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['manufacturers_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)$HTTP_GET_VARS['filter_id'] . "'"; } else { // either retail or no need to get correct special prices -- changed for mysql 5 $listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_retail_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 left join " . TABLE_SPECIALS_RETAIL_PRICES . " s on p.products_id = s.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['manufacturers_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)$HTTP_GET_VARS['filter_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) { // ok in mysql 5 $listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, tmp_pp.products_price, p.products_retail_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 -- changed for mysql 5 $listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_retail_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 left join " . TABLE_SPECIALS_RETAIL_PRICES . " s on p.products_id = s.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'] . "'"; } // end else { // either retail... // EOF Separate Pricing Per Customer } } else { // show the products in a given categorie if (isset($HTTP_GET_VARS['filter_id']) && tep_not_null($HTTP_GET_VARS['filter_id'])) { // We are asked to show only specific catgeory; // BOF Separate Pricing Per Customer if ($status_product_prices_table == true) { // ok for mysql 5 $listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, tmp_pp.products_price, p.products_retail_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 -- ok in mysql 5 $listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_retail_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 --last query changed for mysql 5 compatibility if ($status_product_prices_table == true) { // original, no need to change for mysql 5 $listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, tmp_pp.products_price, p.products_retail_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 -- changed for mysql 5 $listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_retail_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 } } Hope that helps! I have clearly defined the issue above so future NOOBS can Google this sucker and know how simple the problem is. (w00t)
  11. Are you using the right version of "customer_group_discounts.php"? I made the mistake of using the one in the folder "SPPC Using Quantity Discount Contribution." This resulted in the 1054 - Unknown column 'p.products_price1' in 'field list'. It made sense to me that I wanted to USE the Quantity Discount Contribution, so I went for the "SPPC Using Quantity Discount Contribution" version. However, if you started from scratch use "SPPC Without Quantity Discount Contribution." I just finished installing SPPC and then added this with no problem. Honestly, I don't know why there are two of them.
  12. To add to this little nugget... The sub-categories are included in the catalog on the storefront by just inserting the root category id, but it will not show in the admin. If you want to have full control you have to include the id from the root categories to the sub-categories. A little flaw in the program, but survivable. Example: 63, 62, 61, 71, 104, 63, 62, 61, is the root of the catalog and 71, 104, are the sub-categories. All of these are now editible in the admin control. If I add more sub-categories to the catalog, I will need to add the number to the string for admin access. Hope that explains the issue better.
  13. I've been looking at code to long and not looking for the obvious. Tony is right... and I will clarify for anyone as dumb as me. Once I had uploaded my catalog, put in multiple categories and started shuffling my sub-categories around, it then "didn't work." Well, it was. Tony just didn't say it was adjusted to work in the Admin Panel and I went and looked at the hard solution. IN THE ADMIN CONTROLS for Product Extra Fields, under the Category field where you put the category the extra field will be related to, enter in ALL. I would do this first (something to add to the contribution) to ensure it works through all of the site, then tweak it to the right parameters as I did. This is a clear case of OT (operator trouble) and not reading the signs here by Tony. Thanks, Dude!
  14. Tony or Whomever may read this, I am wondering the same issue described above, anything not in the first category of the admin product listing will not show Product Extra Fields. I assume it's not reaching for the right category_id or something. I'm no expert and like everyone here we are getting better at it, but a clearer example would be nice. Tony explains to put a comma event if you write one category or write all, well "all" is in there as: OR category_id='all' The rest of the code responsible for the displaying of the fields is here: // BOF Extra Fields Contribution (chapter 1.4) // Sort language by ID for ($i=0, $n=sizeof($languages); $i<$n; $i++) { $languages_array[$languages[$i]['id']]=$languages[$i]; } //relevant fields bof $extra_fields_query = tep_db_query("SELECT * FROM " . TABLE_PRODUCTS_EXTRA_FIELDS . " pef WHERE category_id like '% " . $current_category_id . ",%' OR category_id=" . $current_category_id . " OR category_id='all' OR pef.category_id=(SELECT c.parent_id FROM " . TABLE_CATEGORIES . " as c WHERE c.categories_id = " . $current_category_id . ") ORDER BY products_extra_fields_order"); //relevant fields eof while ($extra_fields = tep_db_fetch_array($extra_fields_query)) { // Display language icon or blank space if ($extra_fields['languages_id']==0) { $m=tep_draw_separator('pixel_trans.gif', '24', '15'); } else $m= tep_image(DIR_WS_CATALOG_LANGUAGES . $languages_array[$extra_fields['languages_id']]['directory'] . '/images/' . $languages_array[$extra_fields['languages_id']]['image'], $languages_array[$extra_fields['languages_id']]['name']); ?> <tr bgcolor="#F0F1F1"> <td class="main"><?php echo $extra_fields['products_extra_fields_name']; ?>:</td> <td class="main"><?php echo $m . ' ' . tep_draw_input_field("extra_field[".$extra_fields['products_extra_fields_id']."]", $pInfo->extra_field[$extra_fields['products_extra_fields_id']]); ?></td> </tr> <?php } // EOF Extra Fields Contribution Any ideas on where to pop this comma or something in? If I find it, I will let you know. Thanks!
  15. Here's an addition to be Inserted into your SQL: INSERT INTO `configuration` (`configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES ('Fancybox Title Position', 'FBTITLE_POSITION', 'outside', 'The position of title. Can be set to Outside, Inside or Over.', 4, 32, NULL, now(), '', 'tep_cfg_select_option(array(\'outside\', \'inside\', \'over\'),'); And in the script settings replace: 'titlePosition' : 'outside', with 'titlePosition' : '<?php echo (FBTITLE_POSITION); ?>', That will now give you control on where the text will be displayed. :thumbsup:
×
×
  • Create New...