Jump to content

CCTVcams

Members
  • Content count

    58
  • Joined

  • Last visited

  1. CCTVcams

    Seperate Pricing Per Customer v3.5

    Thanks for the feedback, much appreciated!
  2. CCTVcams

    Seperate Pricing Per Customer v3.5

    JanZ, thanks for the reply, and please excuse my ignorance. I read those notes in your comments, but wasn't [and still not] really clear on what that means. This doesn't sound good! So there's a chance the database doesn't get updated when I modify price through the admin catalog? Or does this mean that, say a user happens to be logged in for a period of a few hours, if I modify the price while that user is still in the same session, the price won't get updated? I'm just confused because I've done a fair bit of testing, and turning a special on/off seems to update right away - even without the code. Also added/removed special pricing and sorted by price (no refresh) under both the wholesale and retail logins - seems the correct price gets updated upon sort. By no means challenging your judgement, just want to make sure I understand the risks involved. Of course, correct pricing is way more important than a few seconds load time, but if I can have my cake and eat it too... :thumbsup: By the way, the SPPC install is on my local dev environment, with only 5 test products. Thinking the code probably just isn't jiving with one of the other contributions installed [and there are many].
  3. CCTVcams

    Seperate Pricing Per Customer v3.5

    JanZ, how critical is this line of code in index.php? Including it greatly increase the load time of any page with product listed; however, once the customer logs in, everything seems to return to normal. Can you maybe explain what won't work if not included? Commenting out the code doesn't seem to cause anything to 'break', but thought I'd get your input first. Thanks. // BOF Separate Pricing Per Customer if(!tep_session_is_registered('sppc_customer_group_id')) { $customer_group_id = '0'; } else { $customer_group_id = $sppc_customer_group_id; } // this will build the table with specials prices for the retail group or update it if needed // this function should have been added to includes/functions/database.php if ($customer_group_id == '0') { tep_db_check_age_specials_retail_table(); } $status_product_prices_table = false; $status_need_to_get_prices = false; // find out if sorting by price has been requested if ( (isset($HTTP_GET_VARS['sort'])) && (ereg('[1-8][ad]', $HTTP_GET_VARS['sort'])) && (substr($HTTP_GET_VARS['sort'], 0, 1) <= sizeof($column_list)) && $customer_group_id != '0' ){ $_sort_col = substr($HTTP_GET_VARS['sort'], 0 , 1); if ($column_list[$_sort_col-1] == 'PRODUCT_LIST_PRICE') { $status_need_to_get_prices = true; } } if ($status_need_to_get_prices == true && $customer_group_id != '0') { $product_prices_table = TABLE_PRODUCTS_GROUP_PRICES.$customer_group_id; // the table with product prices for a particular customer group is re-built only a number of times per hour // (setting in /includes/database_tables.php called MAXIMUM_DELAY_UPDATE_PG_PRICES_TABLE, in minutes) // to trigger the update the next function is called (new function that should have been // added to includes/functions/database.php) tep_db_check_age_products_group_prices_cg_table($customer_group_id); $status_product_prices_table = true; } // end if ($status_need_to_get_prices == true && $customer_group_id != '0') // EOF Separate Pricing Per Customer
  4. CCTVcams

    Seperate Pricing Per Customer v3.5

    see, punch-drunk - found an earlier reply here that resolved. :blush:
  5. CCTVcams

    Seperate Pricing Per Customer v3.5

    wow, feeling kind of punch-drunk. started a manual install on a heavily modded and template overlayed shop about 7 hours ago, and can finally see the light!! JanZ, thanks for the great contrib and the excellent documentation, would never have been possible otherwise. :thumbsup: so the final hurdle, when i use a manufacturer filter, there are duplicate product listings if i have a 'special' placed in both the wholesale and retail groups. the duplicate product displays the same [correct] price for the appropriate login [retail or wholesale], but i'm not sure why the duplication. seems to have been a similar issue posted here, but not close enough. i was having the same issue on the product listing page, but i updated index.php based on a combination of the available bugfix contributions (1054 error & v4.1.2), which seemed to resolve that problem. i'm thinking this is related, but i just can't get there. any assistance would be much appreciated - i know i won't sleep tonight until i get this figured out. :blink: here's the section of index.php where i'm thinking the problem lies: // 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 $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 . " s on p.products_id = s.products_id 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 { // We show them all $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 . " 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'] . "'"; } } 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 $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 . " s on p.products_id = s.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 . "'"; } else { // We show them all $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 . "'";
  6. CCTVcams

    Seperate Pricing Per Customer v3.5

    Forum seems to be loading a bit faster this evening, so spent the past few hours getting through this 142 page thread. :P Did you know that the thread is so large that only about 1/3 of it will format for printing or file saving??? JanZ, kudos for an incredible effort at keeping this contrib well supported! Just as impressed by how many "complimentary" modules have been added, thanks for all the hard work. :thumbsup: Have been looking [extensively] for a stable, supported contribution that can be used to keep my shop in compliance with supplier MAP (minimum-advertised-pricing) policy. Excited that I may have finally found a solution. What I'm hoping to do has been previously discussed, with the best example listed here. However, despite considerable searching, I haven't been able to find step-by-step instructions for making this happen. Basically, no one with an account should pay "retail" advertised pricing (i.e., all users auto to level 2 pricing upon sign-up), but I don't want to be involved in the approval process unless the user requests level 3 pricing or higher. Seems like this may be something slated for release v4.20 (around p131), and if so, please advise cuz I'll happily sit tight and wait. :D
  7. CCTVcams

    Seperate Pricing Per Customer v3.5

    looks like a great contrib, and the docs/images give a good feel for functionality prior to install - thanks to all those involved. :thumbsup: any comments on what's the most recent, yet stable, complete install? all the way back to v4.1, there's a folder that says "upgrade_from_40_to_version_41" - does this mean i need to install the 4.0 version first and then apply the bug fixes individually? thanks. p.s. - tried scrolling back a few pages to research for myself, but the board is so slow right now that it's literally taking 5-10 minutes for the pages to load.
  8. wow, i feel stupid. :blush: thanks for making the whole process so easy!
  9. great contribution kgt, and thanks for the extended support! maybe a stupid question, but is there a way to change the text at checkout and on the invoice from "Discount Coupon applied" to something else? if possible, i'd rather it include the discount description (i.e., Discount of [10% off, $50 off, etc.] applied).
  10. apologies - can't seem to edit posts? in any event, included a simple script to test mod_rewrite: RewriteEngine On RewriteRule ^test.htm$ /test1.htm [R=301] and included two "dummy" htm pages to test against. willing to bet my host doesn't have things set up correctly. thanks again.
  11. hi chris - thanks for the reply. yep, tried the default ' / ' as well - no luck. will let you know if i figure it out.
  12. installed the contribution on the local server and had everything working fine. followed the same instructions for the live site and now receiving a "page cannot be found" error. the seo URLs appear to be writing, and i have been ensured by my host that mod_rewrite is enabled, so i'm assuming there's an issue with my .htaccess file? the catalog is in the main folder (ie, no catalog folder), but my host directory is a bit different from what i'm used to. when connecting through ftp, i have to go to the path /username/domain.com/ to get to my files. i've tried updating .htaccess with / , /domain.com/ , and /username/domain.com/ - none seem to work. could my host be "fibbing" about mod_rewrite? :P is there a way to test that this functionality is, in fact, enabled? any advice? would really like to get this great contribution working!
  13. we're trying to decide on a credit card payment module - i've done a lot of research, but this has been by far the most difficult aspect of understanding osCommerce. we use linkpoint on another [non-osCommerce] site, but from what i've read, linkpoint connect with osCommerce requires the user to enter peronsal/shipping information twice (first on the retail site, next for the linkpoint authorization). seems like this may also be the case with authorize.net? we'd rather go with a different processor and even pay a bit higher fees to ensure a seamless experience for the user (i.e., so they're not required to leave the retail site). is my understanding of the linkpoint connect module accurate? is there a way to configure so that the user only enters the information once and doesn't have to leave the site? is the linkpoint API module configured the same way? how about PayPal Pro? i'm fairly certain my host offers dedicated IPs and SSL, if required. are both necessary to keep the customer on-site, or is a shared SSL sufficient? if these issues are addressed elsewhere, please point me in the right direction. i've been searching and reading about payment modules for hours on end, but most newbie questions seem to be overlooked. thanks in advance.
  14. enigma - again, no idea how you did this - but amazing. guess that's why you're the enigma. :D working flawlessly, thanks so much. wish there was some way i could return the favor.
  15. no idea how you're doing this - wish i could be helping! (feel pretty useless) :'( that worked in that now the topics are showing! still when i drill down to the article level, getting the following error: 1054 - Unknown column 'a.authors_id' in 'on clause' select a.articles_id, a.articles_date_added, a.articles_date_available, a.authors_id, ad.articles_name, ad.articles_description, ad.articles_url, au.authors_name from articles a, articles_description ad left join authors au on a.authors_id = au.authors_id where a.articles_status = '1' and a.articles_id = '2' and ad.articles_id = a.articles_id and ad.language_id = '1' [TEP STOP] is this something that i can be changing on my own? usually pretty good technically and beginning to feel very dumb. thanks again for the excellent support enigma.
×