Quick Product Updates for osc 2.3+

[♥BrockleyJohn]

I am uploading a new version of the addon and since the original support thread is dead, here is a new one.

The new version is compatible with all 2.3+ versions of osCommerce including 2.3.4BS Edge and requires no file changes or separate SQL on installation.

Download link to follow shortly.

[♥BrockleyJohn]

ok - so I don't have update access! Link to follow when that's worked around...

The new version adds support for bulk update of specials and product prices where specials exist.

[♥BrockleyJohn]

Thanks @justcatering - who funded this version, did much of the port to 2.3 and just uploaded the latest file to:

https://apps.oscommerce.com/XpKWd&quick-update-bs

[♥JcMagpie]

Hi John,

Trying to check some price changes on live site, was just wanting to prevew a posiable price rise but its not allowing this, all I get is an error and no change is shown in preview! Individual  prices changes work but it will not allow % preview

[♥JcMagpie]

Also selecting a catogory and picking a manufacturer will not work? It only shows products in a catogry if all manufacturers is selected.

[♥JcMagpie]

Ok the security warning is a firefox problem as it is not shown in chrome, but it still will not preview!

[♥JcMagpie]

OK individual price updates work fine, % discount changes ok and no errors in updating DB, issue only appeares to be with % change preview.

[♥BrockleyJohn]

In case anyone other than Zahid is following, I'm looking into this. Zero prices were not in my test plan (or design), I confess.

[♥JcMagpie]

security warning was due to my **/**/congfig.php having not defined https on all lines, Sorry silly error. Preview works fine once this is fixed.

Edited February 9, 2018 by justcatering

[♥JcMagpie]

Hi John,

Just some more feedback, not sure why this should be happening but the layout changes depending on number of products beeing displayed. Only happens when you do a preview in the layout shown. When i remove Model it works. It also only occures when you select more than 55 products to display!

[♥BrockleyJohn]

That's just because you're displaying too many fields to fit into the screen width - could perhaps do something different with the specials date format (like put it into the field as a placeholder instead)

[Guest]

Will this contribution work with 2.3.4.1 CE?

- Andrea

[♥BrockleyJohn]

22 hours ago, puggybelle said:

Will this contribution work with 2.3.4.1 CE?

- Andrea

I don't know that it's actually been tried on 2.3.4.1 CE but it's a stand-alone admin page so it should be fine. It is running in sites with code only a month or so older than that. You can't break anything else by installing it.

[Guest]

Okay, I'll give it a shot!

I have Quick Updates in my 2.2 site and it's an invaluable tool to have for shops with thousands of items. 

Thanks!

- Andrea

[♥SCH_001]

A couple of questions - using Frozen CE BS

1. Can the price field be changed to use and modify the Products Price (Gross):  instead of Products Price (Net):  <- as it is know we have to use a calc to work out the ex gst price each time
2. I have update the date layout in includes/languages/english.php  and admin/includes/languages/english.php  but the special section still wants 0000-00-00 <- needs to be dd-mm-yyyy

Many thanks

[♥BrockleyJohn]

5 hours ago, supercheaphobb said:

A couple of questions - using Frozen CE BS

1. Can the price field be changed to use and modify the Products Price (Gross):  instead of Products Price (Net):  <- as it is know we have to use a calc to work out the ex gst price each time
2. I have update the date layout in includes/languages/english.php  and admin/includes/languages/english.php  but the special section still wants 0000-00-00 <- needs to be dd-mm-yyyy

Many thanks

Both are possible, though the specials date layout is taken directly from the core specials page. I think the gross/net is more likely to be generally useful (it's a lot harder to do tax calculations in your head every time than think about a date format on occasion). I'll message you...

[radhavallabh]

Hi,

I get this error on Top category level-

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

select manufacturers_name from manufacturers where manufacturers_id=

[TEP STOP]

Please help.. Using Frozen BS 3 version;

Thank you for helping me in advance;

Regds/

radhavallabh

[♥BrockleyJohn]

30 minutes ago, radhavallabh said:

Hi,

I get this error on Top category level-

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

select manufacturers_name from manufacturers where manufacturers_id=

[TEP STOP]

Please help.. Using Frozen BS 3 version;

Thank you for helping me in advance;

Regds/

radhavallabh

Yeah, that's a bit of crap old code. As a workaround, enable manufacturer updates in the settings and the error will go away. I'm working on an update for Troy and will incorporate a fix.

[radhavallabh]

20 hours ago, BrockleyJohn said:

Yeah, that's a bit of crap old code. As a workaround, enable manufacturer updates in the settings and the error will go away. I'm working on an update for Troy and will incorporate a fix.

Thank you so much dear!! Works perfectly.

Warm Regds./

radhavallabh

[radhavallabh]

I want to update all products at once but it has a page limit, Can you please suggest a fix..

[♥BrockleyJohn]

28 minutes ago, radhavallabh said:

I want to update all products at once but it has a page limit, Can you please suggest a fix..

What are you trying to achieve? You can probably do it in phpmyadmin.

[♥Dan Cole]

10 minutes ago, BrockleyJohn said:

What are you trying to achieve? You can probably do it in phpmyadmin.

Or perhaps Easy Populate.

Dan

[radhavallabh]

19 hours ago, BrockleyJohn said:

What are you trying to achieve? You can probably do it in phpmyadmin.

I am trying to update the prices site wide by x%.. I used Modify Prices in previous Oscommerce versions to achieve it.

Your help will be deeply appreciated.

[♥BrockleyJohn]

46 minutes ago, radhavallabh said:

I am trying to update the prices site wide by x%.. I used Modify Prices in previous Oscommerce versions to achieve it.

Your help will be deeply appreciated.

ok, you can do this in the addon by cheating a little. Start by changing the page to show the maximum number of lines in the drop-down (100). You'll see this adds a parameter to the end of the url: row_by_page=100

Just edit this to a bigger number than the number of products you have, eg row_by_page=10000

BUT the code is not written very efficiently and you may find that it times out trying to update too many products.

 

 

[♥JcMagpie]

A simple solution may be to simply use phpMyAdmin to run a simple SQL query somthng like,

UPDATE products SET `products_price`=`products_price`+100 (100 can be replaced by any number you like)

Test by first simulating on your db and backup first.