Coupon Restriction by Manufacturer

[solo_400]

I have customized the ot_coupon.php in order to get all I want.
When go on restriction coupon page I can't see any button to allow all hundreds of products for my manufacturer. Please tell me I don't have to manually allow them one by one ..

[Ajeh]

You do not see in the dropdown an:
Add All Manufactures Products

if selected and you click Allow, it will add all of the Products for that Manufacturer ...

[solo_400]

At the bottom page I did :

Selected the Manufacturer name ( from dropdown )
Add all manufacturer products ( from dropdown )
Allow ( from dropdown )
I pressed the "Update" button

At the top of the page I can see the message : "Category Not Completed" and nothing changed .

Any idea ?

[Ajeh]

In your Zen Cart Admin, go to the Coupon and check for its coupon_id ...

Next, in phpMyAdmin, look at the table:
coupon_restrict

If you search that table for your Coupon based on the coupon_id, do any records come up?

You mentioned you had a lot of Products for this manufacturer, about how many would you think you have?

[solo_400]

Linda, your persuasive way to help solved my issue.
It works but first i had to "Remove all manufacturer products" for that manufacturer and then "Add all manufacturer products" using selected "Allow" option from dropdown. I believe bulk "update" button isn't working. It's about 360 products available on coupon_restrict table by my coupon_id .

Your help is really appreciated

[Ajeh]

The remove will clear out all of the products for a manufacturer and perhaps that cleaned things up so you could add them all ...

I cannot really trigger that error message and have tested it where a few products of the manufacturer are already added and then I run the add all for the manufacturer ...

'tis a mystery ...

Do let us know if it happens again that you see the error message, and hopefully you will recall if anything odd happened to produce it ...

[trigi]

I tried adding prefix but still same thing. Just to make sure where should I add prefix in following lines:

if ($_GET['build_man'] > 0 && $_POST['products_drop'] == -1) {
          // to insert new products from a given manufacturers_id for a coupon_code that are not already in the table
          // products in the table from the manufacturers_id are skipped
            $new_products_query = "select products_id from products where manufacturers_id = '" . $_GET['build_man'] . "' and products_id not in (select product_id from coupon_restrict where coupon_id = '" . $_GET['cid'] . "')";
            $new_products = $db->Execute($new_products_query);
          }

          if ($_GET['build_man'] > 0 && $_POST['products_drop'] == -2) {
          // to delete existing products from a given manufacturers_id for a coupon_code that are already in the table
          // products in the table from the manufacturers_id are skipped
            $new_products_query = "select products_id from products where manufacturers_id = '" . $_GET['build_man'] . "' and products_id in (select product_id from coupon_restrict where coupon_restrict = '" . $status . "' and coupon_id = '" . $_GET['cid'] . "')";
            $new_products = $db->Execute($new_products_query);

Thank you Ajeh!

Works like a charm with this fix.