Using Products Price Manager & Discount Pricing Group Together

[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.

[Ajeh]

I think customers are happier from the aspect of the Discount Coupon is not valid on Products with other discounts than they would be to lose the quantity discounts to get the Discount Coupon ...

Trying to take away the Quantity Discounts when a Discount Coupon is used makes it feel like they are getting "ripped off" even though they are not ... but it is a mentality of "I saw Discounts for buy this many and then you "took" them from me!" ... and where many might not notice this happening until *after* completing the order, this might save some grief ...

Let us know how this works out for you ...

[swguy]

Trying to take away the Quantity Discounts when a Discount Coupon is used makes it feel like they are getting "ripped off" even though they are not ... but it is a mentality of "I saw Discounts for buy this many and then you "took" them from me!" ... and where many might not notice this happening until *after* completing the order, this might save some grief ...

I agree with Ajeh - this is a very sensitive issue. I'd rather see you partition things so Coupons only apply to category X and Y, and only category Z has Quantity Discounts.