Jump to content

Swami

Members
  • Content count

    19
  • Joined

  • Last visited

  1. I've got SPPC with PBPC installed. I've also installed Discount Coupon Codes with the addon for excluding groups. All of this works very well, although percentages are difficult to apply to override SPPC quantity discounts. For example: GroupA doesn't pay MSRP (SPPC) and gets 20% off for ordering 1 item. They get 30% for 12 items. We'd like to offer a coupon code granting them 30% off no matter how many items they order. Discount Coupon understandably discounts at the subtotal part of the checkout process, but this applies a blanket discount over the top of their price break. So GroupA buys 12 items and gets 30% off and then another 30% off on top of that. It'd be possible to make a multiplier of .875 that would work to bring 20% to 30% if they order under 12 items, but that doesn't prevent the usage on 12 or more items. It seems like it would be difficult to override the current item prices, as they are already in the cart, unless you wrote a custom query to grab the product_price MSRP and recalculated the whole cart with options just for the discount process and passed it to the checkout_confirmation as the new total. Or is there way to format the discount type so that it only applies to total quantities under a certain amount? Ideas on an easier way to achieve this ability? I know it is tough, but would likely be very helpful to SPPC+QPB users.
  2. Swami

    Seperate Pricing Per Customer v3.5

    My previous post is unneeded. I just realized that the PBPCategory is already working as I'd like. I do not know why. I can add ANY products in ANY combination from ANY category and the price breaks trigger. I'd like to know why this is functioning this way so I don't accidently fix it. Perhaps I've got the database information messed up so it gets a NULL result and lumps all products together?
  3. Swami

    Seperate Pricing Per Customer v3.5

    I've now got SPPC with PBPCategory functioning. It appears to work flawlessly. I'd like to make the jump now to create a 'discount_category' that I can refer to so that PBPC thinks everything is in one category so ALL products count towards the price breaks. I think I can do that in sql with a modify statement like this (what do you think?): alter table products add column discount_category decimal(15,4) not null default 0.0, update products set discount_category=1 where products_status=1; If the above is right, would I need to add a 'discount_category' to products_groups as well? And then I populate the column with the exact same values for all products (update statement shown above for all active products)? Also, I'd need to edit any reference to 'TABLE_PRODUCTS_TO_CATEGORIES'? If so, which files and what would they change to? Thanks in advance! I'm learning.
  4. Swami

    Seperate Pricing Per Customer v3.5

    Rather than make all the categories to the same id (which would break category links, no?), if the categories_id is not needed and you could set the categories_id to 1, couldn't you therefore test against ANY integer field in the products database with an insane > or < operation instead of "=1"? For instance, products_price > 0.00 or category_id < 5000? I'm really grasping for a solution without much expertise in applying the actual code. :/ Desperate.
  5. Swami

    Seperate Pricing Per Customer v3.5

    I am in need of php pro help. Can anyone help me very specifically to set up SPPC + QPBPP (already installed and working) so that ANY combination of products triggers the discounts? I don't want price breaks per category. I need price breaks per number of items. I can't tell where or how many places to edit to achieve this. Please help! Jan Z, your advice sounds like it should be good, but I do not know where to make these edits. This is less obvious for me:
  6. Swami

    Seperate Pricing Per Customer v3.5

    Do you mean editing sql directly, or editing the sql query in the PBPCategory code? If right in mysql, how can multiple categories have one id without breaking categories? If code, which file(s) and where would I set this? I'd need to put in the PBPCategory code then edit shopping_cart.php here? // BOF Price Break for SPPC mod, price break per category $products_query = tep_db_query("select products_to_categories.products_id, categories_id, customers_basket_quantity from " . TABLE_CUSTOMERS_BASKET . " LEFT JOIN " . TABLE_PRODUCTS_TO_CATEGORIES . " using(products_id) where customers_id = '" . (int)$customer_id . "'"); while ($products = tep_db_fetch_array($products_query)) { $this->contents[$products['products_id']] = array('qty' => $products['customers_basket_quantity'], 'category' => $products['categories_id']); // EOF Price Break for SPPC mod, price break per category I'm fearful of breaking the groups functionality that just started working. I'm terrible with PHP, but learning.
  7. Swami

    Seperate Pricing Per Customer v3.5

    I've presently got SPPC + QPBPP working great, thanks to this thread. I'd like to make QPBPP give breaks for ANY combinations of products ordered by wholesaler accounts, not just for one product or category. Where might I modify QPBPP for SPPC in order to make this happen? I saw that QPBPP for SPPC has a per-category method you can adjust to. Could I perhaps modify the category comparison as shown in the install for PBPC and make it a less-than operation and make the number a large integer that I will never reach in categories? (and how would I go about this?) I saw that OhYeah's problem is what I need. lol. Jan Z mentioned this: Could I accomplish what I want through a PriceFormatter or PriceFormatterStore edit without modifying PBPC into my SPPC+QPBPP?
  8. Swami

    Seperate Pricing Per Customer v3.5

    Success! TracyS's login.php code showed I was missing an all important reference. I probably had it in there at one point and modded myself right out of it. Since I was using STS, I couldn't see the session capture's success after login because I was using the product_info template. NOTE TO OTHERS: Turn off STS's product_info template if you plan to use SPPC. Easy fix once the login.php was set right. Thanks to Jan Z and TracyS! Your support has made OsC worthwhile. I do have *one* more issue: My AttributePercentage mod no longer works. If you have ideas, great. If not, I'll be in their support thread readin their codez.
  9. Swami

    Seperate Pricing Per Customer v3.5

    If the sppc_customer_group_id isn't there after login, either, then what? It doesn't show up. I get: ) [customer_id] => 2 [customer_default_address_id] => 2 [customer_first_name] => ProTest [customer_country_id] => 223 [customer_zone_id] => 22 ) <br>Customer group id: <br>0</pre> --></body>
  10. Swami

    Seperate Pricing Per Customer v3.5

    I need to make sure SPPC is capable of the following: + Guests only see retail price. + Logged-in users see price break. (break(s) with qpbpp) - Everyone sees the first prices entered into the product page. I can't make anyone see the second set of pricing. Are there known tweaks/incompatibilities with: STS 4.5.x I backed out the changes that QPBPP made to SPPC and I still can't make the single price change for ANY user. It always shows the first price from the product editing screen. :/
  11. Swami

    Seperate Pricing Per Customer v3.5

    + So the Wholesale user isn't getting the discounted prices? I switched the ID #'s and I still just get the QPBPP prices from the first list of breaks in the product editor. + After applying the code above, I got the array stuff, but nothing about sppc at all. The bottom of the output did show: [customer_id] => 2 [customer_default_address_id] => 2 [customer_first_name] => ProTest [customer_country_id] => 223 [customer_zone_id] => 22 ) <br>Customer group id: <br>0</pre> So where am I going wrong if there's no sppc_customer_group_id? Tired.
  12. Swami

    Seperate Pricing Per Customer v3.5

    Jan, Turns out that replacing both customers.php files solved the inability to assign customers to groups. I thought I did that but probably missed one of them. You know your stuff! I am very thankful to you. :D I'm still having issues with making only the retail price show up for the guest users. I fear it is the Quantity module that is jacking things up. Everyone can see the same quantity price break regardless of group. Have you encountered this before, and where should I look in the code to make sure the customer is being recognized properly? I added a piece of code to see session information on login.php, yet didn't see anything there about any customer_id or such. Thoughts on confirming that customers are being ID-checked? I'm still looking into the code you gave that forces new accounts to be guests. I'll see if that functions. Thanks again. Here's the session info from login.php (white space removed to shorten. sorry to post long code...hope it is helpful): Array ( [cart] => shoppingcart Object ( [contents] => Array ( ) [total] => 0 [weight] => 0 [cartID] => [content_type] => ) [language] => english [languages_id] => 1 [currency] => USD [navigation] => navigationhistory Object ( [path] => Array ( [0] => Array ( => index.php [mode] => NONSSL [get] => Array ( ) [post] => Array ( ) ) [1] => Array ( => advanced_search_result.php [mode] => NONSSL [get] => Array ( [keywords] => 3/4 ) [post] => Array ( ) ) [2] => Array ( => product_info.php [mode] => NONSSL [get] => Array ( [products_id] => 62 ) [post] => Array ( ) ) [3] => Array ( => account.php [mode] => NONSSL [get] => Array ( ) [post] => Array ( ) ) [4] => Array ( => login.php [mode] => SSL [get] => Array ( ) [post] => Array ( ) ) ) [snapshot] => Array ( => account.php [mode] => NONSSL [get] => Array ( ) [post] => Array ( ) ) ) )
  13. Swami

    Seperate Pricing Per Customer v3.5

    Ugh, I'm at a loss. I've got SPPC w/QPBPP installed, along with Attribute Percentage, Options as Images, and Attrib_Sort. My issue is that I can't assign users to groups in the Customer admin area for SPPC. I can enter prices in products, but everyone who visits can see the QPBPP prices. I want the visitors to see the single MSRP listed from SPPC. What files should I check if the customer edit screen has no method of changing their groups? I'd be happy with a straight sql edit. Any ideas?
  14. Swami

    Attribute Percentage

    I'd be interested to know how to have more than one attribute with a % assigned to it. How would I go about making each attribute compile a % of the original product price, not daisy chaining off of each other? Example: Product1 = $100, Option1 increases the total 10%, Option2 increases the total 10%, making the total $120. Right now, the module does this: Product1 = $100, Option1 increases the total 10%, Option2 increases the total 10%, making the total $111. Any ideas? This would effectively help to discount attributes when a quantity price break is in effect (since we have a consistent sliding % for the attribute.) Swami
×