Notifications
Announcements
No record found.
Can anyone help me?
i just switched my servers and the queries are not working on the new server in turn my pricing is not updating.
Any ideas how to runa new query?
*This post is locked for comments
Can you be more specific about what you're trying to do? Are you in a HQ environment and are trying to change price level A prices at your stores, or are you just running store ops and need to change it for specific items? You said queries...are you trying to update your pricing levels through the back end database?
It is a live database on RMS SO, there are 3 levels of pricing and what i am trying to do is run a querie to update the 3 different prices automatically vs going in and doing it manualy.
I'm still not really following you.
The values for each price level is contained in the PriceA, PriceB, and PriceC columns of the Item table in the database. So an update would generally take the form of something like
"UPDATE item SET PriceA = (whatever value) WHERE (whatever filter you are using) = (whatever value)".
However, if you aren't familiar with SQL I would strongly advise against running update statements like this, as you can do irreversible damage that can't be repaired short of restoring from a backup.
Can you post the queries that you say aren't working on the new server?
I'm not sure that the "Wizard/Inventory Wizard" in Store Operations Manager might be the better tool rather that using SQL queries?
It definitely would be. I'm just queuing off of Danny's original request for a "new query", but if all he needs is a basic way to update price levels, SQL shouldn't be involved at all.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
