Jump to content
eagleg

Product price chage module for 2.3.4.1

Recommended Posts

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!

 

Share this post


Link to post
Share on other sites

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]

 

Share this post


Link to post
Share on other sites

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

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

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites
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?

Edited by ruden

Share this post


Link to post
Share on other sites

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

 

Share this post


Link to post
Share on other sites

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!


For a new install or if your store isn't mobile-friendly, get the community-supported responsive osCommerce (Phoenix).

here: on the official osc download page

Working on generalising bespoke solutions for Quickbooks integration, Easify integration and pay4later (DEKO) integration at 2.3.x

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×