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

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

hi there,

My client has asked if the off/on buttons can be colorized to be red/green for easier scanning.

Has anyone else done this for this module, in which case can you please share? 

Share this post


Link to post
Share on other sites

@drusky Donna, radio buttons are rendered by the browser directly using built-in images so they can't be styled directly. The technique of images inside links used on the admin/categories page for status wouldn't be any good here because it requires reloading the page to change the button.

On the other hand, it is possible to do something with pseudo elements - basically hide the radio buttons themselves and show something that can be styled instead. The technique is described in this answer on stackoverflow: https://stackoverflow.com/a/38468320/4384632

 


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

I have just uploaded v3.1.2 to the addons area - https://apps.oscommerce.com/XpKWd&quick-update-bs

This version, sponsored by @drusky, introduces coloured radio buttons for product and special status:

It also includes the image fix by @dreumel and a bunch of fixes for php7.2 compatibility.

Tested against CE Phoenix v1.0.1.2

Screenshot-v3.1.2.jpg


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

×