WWStitching Posted July 8, 2022 Share Posted July 8, 2022 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, 2022 Share Posted July 8, 2022 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, 2022 Author Share Posted July 9, 2022 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, 2022 Author Share Posted July 12, 2022 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, 2022 Share Posted July 12, 2022 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, 2022 Author Share Posted July 14, 2022 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.