eagleg Posted January 11, 2020 Share Posted January 11, 2020 Anyone know of a good module that will allow me to not only bulk price change all prices at once, but products in individual categories? Thanks! Link to comment Share on other sites More sharing options...
♥JcMagpie Posted January 11, 2020 Share Posted January 11, 2020 Yes this addon by @BrockleyJohn will do what you need. Select by category and/or Manufactures, bulk or single update. Value or % 😊 Use it all the time work fine. Quick update BS Link to comment Share on other sites More sharing options...
eagleg Posted January 11, 2020 Author Share Posted January 11, 2020 i get the following error: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1 insert into temp_rates values[TEP STOP] Link to comment Share on other sites More sharing options...
Denzel Posted January 11, 2020 Share Posted January 11, 2020 If temp_rates is the table name, the columbs are missing: INSERT INTO table_name (column1, column2, column3, ...)VALUES (value1, value2, value3, ...); Link to comment Share on other sites More sharing options...
♥ecartz Posted January 11, 2020 Share Posted January 11, 2020 The columns aren't actually a requirement if you provide values (in the right order) for all the columns. I.e. it can infer the columns if the values are set up to match the way that it would infer the columns. Now that said, this could indicate a problem if the code is supposed to be specifying the columns but isn't. But it also may be intentionally using the shorter format. The support thread used to be at but I don't know if @BrockleyJohn monitors it actively or not. You might try posting there and seeing if he has additional insight. Always back up before making changes. Link to comment Share on other sites More sharing options...
eagleg Posted January 11, 2020 Author Share Posted January 11, 2020 I will contact him Link to comment Share on other sites More sharing options...
eagleg Posted January 11, 2020 Author Share Posted January 11, 2020 do you think it is a PHP issue? Link to comment Share on other sites More sharing options...
ruden Posted January 11, 2020 Share Posted January 11, 2020 5 hours ago, eagleg said: i get the following error: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1 insert into temp_rates values[TEP STOP] https://apps.oscommerce.com/XpKWd&quick-update-bs this addon? Link to comment Share on other sites More sharing options...
eagleg Posted January 11, 2020 Author Share Posted January 11, 2020 yes Link to comment Share on other sites More sharing options...
ruden Posted January 12, 2020 Share Posted January 12, 2020 @eagleg tax not used? find $insert = 'insert into temp_rates values '; foreach ($tax_classes as $id => $data) { $insert .= '(' . $id . ',' . $tax_classes[$id]['tax_rate'] . '),'; } replace with if (!empty($tax_classes)) { $insert = 'insert into temp_rates values '; foreach ($tax_classes as $id => $data) { $insert .= '(' . $id . ',' . $tax_classes[$id]['tax_rate'] . '),'; } } Link to comment Share on other sites More sharing options...
BrockleyJohn Posted January 12, 2020 Share Posted January 12, 2020 My copy of that addon does not contain the string ' temp_rates' anywhere (at least not the latest version, I haven't checked any earlier ones) so I have no idea what @eagleg or @ruden are talking about! Contact me for work on updating existing stores - whether to Phoenix or the new osC when it's released. Looking for a payment or shipping module? Maybe I've already done it. Working on generalising bespoke solutions for Quickbooks integration, Easify integration and pay4later (DEKO) integration at 2.3.x Link to comment Share on other sites More sharing options...
eagleg Posted January 12, 2020 Author Share Posted January 12, 2020 Issue has been resolved! Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.