WWStitching Posted July 8, 2022 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.
bsmither Posted July 8, 2022 Posted July 8, 2022 That would be the database table 'CubeCart_inventory', 'minimum_quantity' column.
WWStitching Posted July 9, 2022 Author Posted July 9, 2022 Thank you! My tech is on vacation and my database knowledge is dangerous to the system at best!
WWStitching Posted July 12, 2022 Author 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?
bsmither Posted July 12, 2022 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.
WWStitching Posted July 14, 2022 Author 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.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.