Using Products Price Manager & Discount Pricing Group Together

[MeltDown]

A number of my categories use the Products Price Manager to define multiple-tier quantity discounts. If I create a coupon or offer the customer-specific Discount Pricing Group, the discounts are combined at checkout, when what I want is to ignore the Products Price Manager quantity discounts, replacing it with the coupon or Discount Pricing Group discount.

Is this possible?

Thanks

[swguy]

Nothing is built-in to do this; you'd have to change the code. And it would be a bit of a shock, since coupons aren't entered until page 2, so you could have (say) a subtotal of $100 going onto the payment page, enter a coupon, and wind up on the checkout confirmation page with a total of (say) $120 if you were to do this (since the products price manager changes the price of the product in the cart).

[MeltDown]

Nothing is built-in to do this; you'd have to change the code. And it would be a bit of a shock, since coupons aren't entered until page 2, so you could have (say) a subtotal of $100 going onto the payment page, enter a coupon, and wind up on the checkout confirmation page with a total of (say) $120 if you were to do this (since the products price manager changes the price of the product in the cart).

Thanks Scott - Do you have any modules that do what I need?

[swguy]

You could use Quantity Discounts from the Plugins Area instead of Products Price Manager, but you'd still need to add code to turn them off if a coupon is used or Group Pricing is used. Also, if you upgrade from 1.3.8 (you really should) you'll get all the fixes to make coupon restrictions work so that you can disallow using coupons on things with quantity discounts.

[MeltDown]

Hi Scott - I've begun the process of upgrading to 1.5.1. You said:

you'll get all the fixes to make coupon restrictions work so that you can disallow using coupons on things with quantity discounts.

Did you mean that by using your Quantity Discounts add-on I could make coupon restrictions to disallow pre-set quantity discounts? Or that I could do so with Zen's Products Price Manager? Could you expound on how I would go about this?

Thanks for you help.

[swguy]

This wasn't very clear. You'll have to pick and choose the items that are currently quantity discounted (using the Products Price Manager) and add those in as restrictions that the coupon cannot be used against. There's no mechanism to say, "Don't apply the coupon to anything with a quantity discount" without actually changing code to work this way.

[MeltDown]

If using your Quantity Discounts add-on (foregoing the Products Price Manager completely), is it possible to create coupon restrictions to disallow pre-set quantity discounts?

If not, how does one restrict existing Products Price Manager discounts so that the coupon cannot be used against these products?.

Thanks again

[swguy]

Question 1: No.

Question 2: Like I said, you'd have to customize code. Nothing is built in to any of this.

[Ajeh]

To Restrict ALL Products that are using Discount Quantities from a Discount Coupon, you could to the EXPORT/IMPORT game with phpMyAdmin ...

You need to read through this a few times and test the results ...

First ... Backup database before doing this, as you can really make a mess when you least expect it ...


Make Discount Coupon and get coupon_id, EXAMPLE: coupon_id 7

In phpMyAdmin, get all products_id that have products_discount_quantity:

SELECT distinct products_id, 7 AS coupon_id, 0 AS category_id, 'Y' AS coupon_restrict FROM products_discount_quantity

Export DATA ONLY to a SQL

Check new SQL that you exported for all fieldnames and data ...

Example to restrict all products with discount quantities initially should look like something like this:

INSERT INTO products_discount_quantity (products_id, coupon_id, category_id, coupon_restrict) VALUES
(8, 7, 0, 'Y'),
(127, 7, 0, 'Y'),
(130, 7, 0, 'Y'),
(175, 7, 0, 'Y'),
(176, 7, 0, 'Y'),
(177, 7, 0, 'Y'),
(178, 7, 0, 'Y'),
(205, 7, 0, 'Y');

Edit exported SQL and change table name from:
products_discount_quantity

to read:
coupon_restrict

Change field name:
products_id

to be:
product_id

SQL should now look something like this:

INSERT INTO coupon_restrict (products_id, coupon_id, category_id, coupon_restrict) VALUES
(8, 7, 0, 'Y'),
(127, 7, 0, 'Y'),
(130, 7, 0, 'Y'),
(175, 7, 0, 'Y'),
(176, 7, 0, 'Y'),
(177, 7, 0, 'Y'),
(178, 7, 0, 'Y'),
(205, 7, 0, 'Y');

IMPORT from SQL and check the Coupon Restrictions on this Discount Coupon to ensure all are correct ...

Fun, eh?

[MeltDown]

Thanks, Ajeh, it looks interesting - I'll give it a whirl :)

To be honest, I'm surprised that more people haven't had "quantity discounts / coupon" issues, thus generating add-ons to deal with it. I'm wondering if I'm missing something, and that there is a better way to offer quantity discounts without negatively affecting one's coupon marketing program.