Quick Updates plugin [support]

Gamer:

I get a blank page when I pull up the quickupdates page.. The configuration page shows up fine.

I use Plesk with a split ssl directory.... IE.. My httpdocs and https docs are not linked...

Did I mis something?

I must have been using an outdated file or missing something.. It works great after the 4th install. :)

Its defiantly worth the time to install.

Hello ,

i have just tried to install the latest version of Quick update. Everything works fine, but i got the following error when i tried to execute the sql file:

------------ cut ---------------------------
1136 Column count doesn't match value count at row 1
in:
[INSERT INTO zen_configuration_group VALUES ('', 'Quick Updates', 'Set Quick Updates Options', '1', '1');]
------------ cut --------------------------
i use now a database with zen_ Prefix, there is an old unused version without prefix on my server.

I use Zencart 1.3.7 and MySQL 4.0.27-

I hope there is anybody who can help me.
Excuse my bad english.

with best regards

Reiner

I have just installed the Module.

Install patch gave me following error:

ERROR: Cannot insert configuration_key "" because it already exists

Module works as expected except the quick update page only displays the product ID, not it's name.

How can I display the product name?

Also, when I go to configuration/quick updates, I get an empty page - it's a zencart page with no options regarding quick updates.

Ok, I found it - the sql patch tried to insert an invalid value - 0 - instead of the actual group_id_value assigned to the table row. I manually replaced the @t4 variable in the patch with the appropriate value from the configuration_group tabla and can now edit the configurations from the admin.

When I install Zen Cart I make sure to leave the optional table prefix empty. Then you can install all sql using phpMyAdmin without modification :-)

When your database tables do have a prefix however, you need to add that same prefix to the table names in the sql file before you can feed it to phpMyAdmin.

(no idea what exactly causes the error messages in some cases, I only know using phpMyAdmin helps)

update for v2.03

While checking the number of queries and query time I found that, when viewing only 320 products in approximately 60 categories, the script would execute over 22000 queries :shocking::shocking: (when viewing with "Edit Linked Cats" selected).

But fortunately it's easy to fix :smile:

Open admin/quick_updates.php for editting and:

replace all (2 instances?):

zen_get_category_tree()

by:

$quick_updates_category_tree

and after:

// eof get manufacturers

add:

// bof get category_tree
$quick_updates_category_tree = zen_get_category_tree();
// eof get category_tree

After these changes the number of queries, and the query time, are reduced over 20x (number of queries from 22335 to 1097) in the formentioned example.

Just struggling with this mod in terms of displaying the product cost and margin. Everything else seems to work fine.

I want to know how exactly i enable the products_purchase_price and margin feature?

i have read through the thread 3 times now but am still not sure how to create the necessary coulmns.

Any help would be appreciated very much.

Is the problem with adding the fields to your database? Or?

Has anyone compiled a list of corrections/fixes/mods for Quick Update 2.03?

Paulm: such as the one you just posted :)

Also, I have added field for Product Qty Minimum and Product Qty Units (but need to add an admin switch for them).

If we could get a solid list of accepted fixes we could post an updated version however minor it may be.

Oh! I forgot!

Paulm... are you still working on a 3.x version???

chadderuski:

Oh! I forgot!

Paulm... are you still working on a 3.x version???Yes and No :smartalec:
I still think about it sometimes and even write some lines code now and then. But at a certain point I started to get more and more doubts about it's core and about what direction it should move. And so I slowely but surely got further and further away from a release.
Has anyone compiled a list of corrections/fixes/mods for Quick Update 2.03?

Paulm: such as the one you just posted :)The only real issue that I know about is the one I just posted. More improvents will be possible of course. For example posting all old and new data values (which qu currently does) all the time seems not very smart, I think there are better/faster ways, which also would reduce the bandwith usage dramaticly when updating lots of products. But those are ideas only, not fixes...

I don't have plans to upload an updated version. But if you are going to release one, and it includes the above queries fix, I think it would great :smile:

Hey Paul!

A major rewrite is a major pain, agreed...

Perhaps a minor update (2.04?) which incorporates some just the minor issues and a new thread 2.04 <> for zencart 1.3.7 ... etc.

BUT, I'm not familiar with all the niggling issues 2.03 has. I just made it work for me. However, I can see that others may have some fields they'd like to see - switchable in admin of course.

I'd like to be able to change in admin the field widths of some items (different browsers & mac/pc interepret these differently) would be more user customizable. Just hard coding it now.

REALLY like to be able to click next <> prev through the category tree without having to use the drop box each time. Haven't attempted though.

Would also be nice to have the update button change color when you've made changes (don't know if this is doable with current design) and need to update to save changes...

just tossing out some thoughts....

Would it be possible to update the installation (and uninstall) instructions / script?
Seems like THIS issues is the biggest problem that people have.

Like to hear your thoughts :)

Hi chadderuski,

to be honest I am not interested at all to update 2.03 (or any other 2.x version). If I have a simple fix for something I might (or might not) post it here, but as said I don't know about any issues (other than the one I posted here 2 days ago).

Would it be possible to update the installation (and uninstall) instructions / script?I think the install script is fine. The issues some have they probably have with lots of other sql install scripts too. I can only advise them to use phpMyAdmin (repeating this advice over and over is starting to become very boring though, so I think I give up on that soon..). And if you, or anyone else, wants to rewrite the instructions thats fine with me of course :smile:

And, maybe it were your questions and suggestions that inpired me, but today I decided to work on my new version again and it looks like I can release something soon after all :cool: It won't be a "polished" and well supported contribution or something, but only targetted at the ones that are not afraid to experiment a bit now and then :smile:

I am using the MSRP mod and the quick update, however the quick update updates the Products Price (Net):, the MSRP mod adds Products Cost:.... I would like to add a column to quick update that would update the Products Cost:

Can this be done?

Is there a way to make the picture larger?

I am trying to modify all the titles and need to see the differences...

milobloom:

Is there a way to make the picture larger?
in admin\includes\extra_configures\quick_updates.php

  define('QUICKUPDATES_DISPLAY_THUMBNAIL_WIDTH', '30');
  define('QUICKUPDATES_DISPLAY_THUMBNAIL_HEIGHT', '');

And to enlarge the hover image size you need to edit the quick updates stylesheet.

lextechs:

I would like to add a column to quick update that would update the Products Cost:

Can this be done?Adding columns is not complicated, but it does require some custom coding. You can take a look at the code and use the existing columns as an example.

When I change

define('QUICKUPDATES_DISPLAY_THUMBNAIL_WIDTH', '30');
define('QUICKUPDATES_DISPLAY_THUMBNAIL_HEIGHT', '');

It will only display the same size width (The image enlarges but it gets cut off. )

Is this image supposed to get bigger if I put the mouse over it?
I have image handler installed. If so sounds like another area to troubleshoot.

Paul,

Perhaps you can spot what I'm doing wrong here... I am adding a checkbox for product_is_call (and maybe the others if I figure this out!) and just can't seem to get it to work correctly. This is as CLOSE as I'm getting:

	// product_is_call - added by chadd
    if($_POST['quick_updates_old']['product_is_call']){
      foreach($_POST['quick_updates_old']['product_is_call'] as $products_id => $status) {
        if ($_POST['quick_updates_new']['product_is_call'][$products_id] != $_POST['quick_updates_old']['product_is_call'][$products_id]) {
          $quick_updates_count['product_is_call'][$products_id] = $products_id;
		  if (!isset($_POST['quick_updates_new']['product_is_call'][$products_id])) {
		  	$db->Execute("UPDATE " . TABLE_PRODUCTS . " SET product_is_call='" . '0' . "', products_last_modified=now() WHERE products_id=" . (int)$products_id);
			}
		  else {
		  	$db->Execute("UPDATE " . TABLE_PRODUCTS . " SET product_is_call='" . '1' . "', products_last_modified=now() WHERE products_id=" . (int)$products_id);
			}
	    }
      }
    }

This will let me set and unset the product_is_call field, but it does it for every product on the page, not just the one changed.

If I use "new" instead of "old":

	// product_is_call - added by chadd
    if($_POST['quick_updates_new']['product_is_call']){
      foreach($_POST['quick_updates_new']['product_is_call'] as $products_id => $status) {
        if ($_POST['quick_updates_new']['product_is_call'][$products_id] != $_POST['quick_updates_old']['product_is_call'][$products_id]) {
          $quick_updates_count['product_is_call'][$products_id] = $products_id;
		  if (!isset($_POST['quick_updates_new']['product_is_call'][$products_id])) {
		  	$db->Execute("UPDATE " . TABLE_PRODUCTS . " SET product_is_call='" . '0' . "', products_last_modified=now() WHERE products_id=" . (int)$products_id);
			}
		  else {
		  	$db->Execute("UPDATE " . TABLE_PRODUCTS . " SET product_is_call='" . '1' . "', products_last_modified=now() WHERE products_id=" . (int)$products_id);
			}
	    }
      }
    }

I can only SET the checkmark, not UNSET it, it updates, but doesn't change the database for unsetting checkmark.

I've tried a dozen different ways, but seem to be missing something... hope you can point me in the right direction!

-Chaddro