Jump to content
BrockleyJohn

Quick Product Updates for osc 2.3+

Recommended Posts

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.


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

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.


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

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


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

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

image.png.5290f9d63ffe4c49a4ce4bab62c974eb.png


 

Share this post


Link to post
Share on other sites

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.


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

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 by justcatering

 

Share this post


Link to post
Share on other sites

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!

image.thumb.png.de022d44a9f3ddefc37b2b04704b7211.png

image.thumb.png.e3c7fff41c546566c25182a169a0eeb1.png


 

Share this post


Link to post
Share on other sites

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)


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
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.


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

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

Share this post


Link to post
Share on other sites

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

Share this post


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


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

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

Share this post


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


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
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

Share this post


Link to post
Share on other sites

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

Share this post


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


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
10 minutes ago, BrockleyJohn said:

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

Or perhaps Easy Populate.

Dan

Share this post


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

Share this post


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

 

 


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

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.

image.thumb.png.443cab97cf9e683391e79d59f6d18e85.png


 

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

×