I set sale prices on items for a week all the time, but I want the sale price to NOT impact any chosen attribute addons for the listings...
I set sale prices on items for a week all the time, but I want the sale price to NOT impact any chosen attribute addons for the listings...
First, what are you using to apply the sale pricing?
Second a code filter could shelter the products/attributes.
Twitch.
https://www.twitchtoo.com Do you work for free? Please donate.
Twitch Base7 with Wholesale PRO - 88 preinstalled plugins zero errors.
How would you like the sheltered products/attributes to work?
Using:
- relational or associative connection with product
- category
- 3rd variable filter
- customer group
- price range
- attribute group
- delivery location
or some unique method your business uses that I missed?
Twitch.
https://www.twitchtoo.com Do you work for free? Please donate.
Twitch Base7 with Wholesale PRO - 88 preinstalled plugins zero errors.
I just want all attributes to be imune to price adjustments via sale or removing sale price.
Impacting all categories
In each attribute you would have to use the "Apply Discounts Used by Product Special/Sale: Y/N" setting. This setting is in the edit attribute page's "rainbow" bar =)
~Melanie
PRO-Webs, Inc. :: Recent Zen Cart Projects :: Zen Cart SEO – 12 Steps to Success
**I answer questions in the forum, private messages are NOT answered. You are welcome to contact us via our website for professional engagements.
But if I have added the attribute to a thousand products, lets say, is there a SQL code I could use to apply it to everything at once or do I have to change them to all special items and as I add new items on special? I'll try it the manual way right now, thank you Melanie!!!
Update: Applying it manually to each item on special is working, thank you!
It would be nice if I could change them all at once though.
Last edited by jmberman; 16 Jan 2020 at 05:23 PM.
Backup first
~MelanieCode:UPDATE `products_attributes` SET `attributes_discounted` = '1' WHERE `products_attributes`.`attributes_discounted` = 0;
PRO-Webs, Inc. :: Recent Zen Cart Projects :: Zen Cart SEO – 12 Steps to Success
**I answer questions in the forum, private messages are NOT answered. You are welcome to contact us via our website for professional engagements.
You could try this in phpmyadmin to change all products at once
Beware, I did not test this, and make a backup of your database before doing thisCode:UPDATE products_attributes SET attributes_discounted = 1
Zen cart installation / maintenance / customisation / hosting
Supported Modules: Dutch language pack, Multi site, Dynamic Price Updater and more.
Bookmarks