Jump to content
BrockleyJohn

Quick Product Updates for osc 2.3+

Recommended Posts

Need a bit more control, use manufacturer id to limit changes

update `products` set `products_price` = (`products_price` * '1.10') WHERE `manufacturers_id` = '1';

 


 

Share this post


Link to post
Share on other sites
3 hours ago, BrockleyJohn said:

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.

 

 

Gives a 413 page error too much data..

2 hours ago, JcMagpie said:

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

Need to do it by 5%

 

 

Please Help!!!

Share this post


Link to post
Share on other sites
Posted (edited)

You already have that info. price = price*1.05 is 5%

update `products` set `products_price` = (`products_price` * '1.05') WHERE `manufacturers_id` = '1'; 

 

image.png.7ccad277b0b61ca636f0ad837eb124fd.png

Edited by JcMagpie

 

Share this post


Link to post
Share on other sites
Posted (edited)

if the image does not appear in the top right corner change line 538  and 543 "  .  '/images' . to "   .  'images/'  . " in quick_updates.php.

Edited by dreumel

Share this post


Link to post
Share on other sites
10 hours ago, dreumel said:

if the image does not appear in the top right corner change line 538  and 543 "  .  '/images' . to "   .  'images/'  . " in quick_updates.php.

Wish I'd seen that before building the next release! Incorporated for a future version - there are two places to change; one for the category image and one for the manufacturer image.


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

here: https://github.com/gburton/Responsive-osCommerce/releases

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

version 3.1.1 is available for download from https://apps.oscommerce.com/Apps&XpKWd&quick-update-bs

Sponsored by @supercheaphobb it includes options for working with prices including tax and adding a datepicker to the specials expiry date. It also fixes the manufacturer query error that @radhavallabh hit the other day but not the latest bug above.

Update is simple - just copy the files. New options are added automatically when you access the page and set to default.


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

here: https://github.com/gburton/Responsive-osCommerce/releases

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,
Is there a way to implement a search function? Like the one in the admin/categories tab? Great add-on!

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

×