WWStitching Posted July 8 Share Posted July 8 I need to do a mass update on the minimum order quantity. I don't know what field to use for the database. Anyone know by chance? Running 6.4.5. Quote Link to comment Share on other sites More sharing options...
bsmither Posted July 8 Share Posted July 8 That would be the database table 'CubeCart_inventory', 'minimum_quantity' column. Quote Link to comment Share on other sites More sharing options...
WWStitching Posted July 9 Author Share Posted July 9 Thank you! My tech is on vacation and my database knowledge is dangerous to the system at best! Quote Link to comment Share on other sites More sharing options...
WWStitching Posted July 12 Author Share Posted July 12 Ok I tried this UPDATE `CubeCart_inventory` SET minimum_quantity` = 1; #EOQ through the admin panel query and it is not working. Did I do something wrong? Quote Link to comment Share on other sites More sharing options...
bsmither Posted July 12 Share Posted July 12 If the above is an accurate copy of the query used, then may I direct your attention to the column name that is not correctly enclosed by backticks. Quote Link to comment Share on other sites More sharing options...
WWStitching Posted July 14 Author Share Posted July 14 Got it. Thank you. I typo'd it here but it turns out my server was updating at the same time causing nothing to happen until it was done. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.