Thanks Doc. That did the trick.
For anyone using Quick Order, it's a simple change. Find the file includes/modules/pages/quick_order/header_php.php
In that file, find the comment // LOOK UP ALTERNATE SKUS
In the SELECT statement just below that, find
PHP Code:
SELECT p.products_model, pd.products_name FROM %s AS p, %s AS pd WHERE p.products_id = pd.products_id AND
...and replace it with this...
PHP Code:
SELECT p.products_model, pd.products_name FROM %s AS p, %s AS pd WHERE p.products_status = 1 AND p.products_id = pd.products_id AND
In other words, add p.products_status = 1 to the WHERE clause.
Any time someone enters a correct model number (into the Quick Order form) for a product that is temporarily disabled via admin, they'll get a warning message and the product won't be added to the shopping cart. You can edit the warning in includes/languages/english.php, as usual.
Thanks again,
Rob
Bookmarks