nicolas wrote: You can run such queries via the SQL interface of your phpmyadmin:
community.mybb.com/thread-4720.html
Thank you eliot and nicolas, and I hope what I write here will be taken into "SERIOUS" consideration.
Here is a little more backgorund on me first. When CS-Cart first came out years ago, a friend of mine Doug from
www.Hockinson.com
and I were on the team with the "ruskies" for the initial development of it. And many great features got into it, and I still consider it a "class act" as far as shopping carts are concerned.
I also spent "way too much time" with osCommerce also, and the problems there were TOO MANY PEOPLE working on modules, and things not get fully tested to work...and it got messy....
With that said? That is why I am here and have purchased the business, is for the support factor...and results and fixes getting done in a timely matter and I thank everyone for that.
Now, this is an issue that really needs to be addressed please...as let us face it, "Prices Change" and therefore this issue will happen to anyone, who is using this cart..and with the "year end" coming, that is when companies [suppliers aka BRANDS] re-evaluate costs...and then will either increase or possibly decrease items.
Many companies just will do a standard "across the board" "Global" [BRAND] price increase for all the products...and sometimes will just go on certain [Categories]
Therefore, PLEASE think seriously about scripting for this UI work flow such as:
1) Is this a Global [all products] Price Increase? [ Yes or No ]
2) If No, Is this increase (decrease) per "BRAND" [ Yes or No ]
3) If Yes? Is this Increase (decrease) applied to ALL Categories (of BRAND), IF no? Then radio or check box categories related to Brand.
Am I making sense so far please? As the catalog I am building will have 100 brands, and of curse Categories and Products..
Total items in this cart will be over 5,000 and no way in "heck" do I want to increase a product one at a time as that would take 2 minutes each at least, and no TRACKING method really .
2 minutes? 5,000 Products? Guess what?
That is 166 Hours of manual work..