Product price chage module for 2.3.4.1

[eagleg]

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!

 

[♥JcMagpie]

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

 

[eagleg]

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]
 

[Denzel]

If temp_rates is the table name, the columbs are missing:

INSERT INTO table_name (column1, column2, column3, ...)
VALUES (value1, value2, value3, ...);

[♥ecartz]

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. 

[eagleg]

I will contact him

 

[eagleg]

do you think it is a PHP issue?

 

[ruden]

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?

[eagleg]

yes

[ruden]

@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'] . '),';
        }
      }

 

[BrockleyJohn]

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!

[eagleg]

Issue has been resolved!