Quick Updates plugin [support]

[Blackguard]

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?

[Blackguard]

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

[Blackguard]

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.

[paulm]

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)

[paulm]

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 (when viewing with "Edit Linked Cats" selected).

But fortunately it's easy to fix

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.

[DVDTitan]

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.

[paulm]

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

[chadderuski]

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.

[chadderuski]

Oh! I forgot!

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

[paulm]

Oh! I forgot!

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

Yes and No
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