Quick Updates plugin [support]

Hello everyone!

As I solved the products_artlid-Thing for me, last night(5.30a.m.), I wanted to post the way I used for me. May others'd like to use it too.
That are just two little things more to do while instaling the QU:

1. add the Table to the Database (I used the code:
   ALTER TABLE products ADD products_artlid VARCHAR( 32 ) DEFAULT 'NULL' AFTER products_model; )
2. switch the Extracolumnfeature in the /admin/includes/extra_configures/quick_updates.php to on (and renamed artlid to something more meaningful here in Germany)
   That's it!

The only problem left I got with zen-cart now, is that I didn't find out to now, how to modify the category-drop-down-list in the manufacturers-search-results to show the complete category-path instead only the last subcategories of the products..

@ HeathenMagic - maybe it's also a tip for you: With the html-Area used as Popupeditor, it somehow don't save the (pre)edits for me that I can't update them via the Update-Button as mentioned by paulm, but the updating works fine after editing the Description in the plain-text-mode..

Great Mod, It saves my staff tons of time.. Is there a way to get this mod to work with Group Pricing (per Item) module? Groups A-D

:clap:

http://www.zen-cart.com/index.php?main_page=product_contrib_info&products_id=256

brylees:

You are exactly right. I was just frustrated at the time trying to resolve what I thought was a problem. I do appreciate those out here making Zen Cart what it is. Zen Cart has been a blessing for me and I am really happy with what it has become so far. I expect meany great things in the future and will contribute any usefull information I may come up with.

How did you resolve your layout problem. I am having similar shifting.
Thanks

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.

Hi,
Do you replaced her:
SET @t4=0;

or ???

To everyone that gets this message when installing quick updates (or any other mod that requires you to add sql to the datase):

ERROR: Cannot insert configuration_key "" because it already exists

First install this sql (using the "Install SQL Patches" tool):

DELETE FROM configuration WHERE configuration_key = "";

And then try to install the quick updates sql again. Let us know if it helps.

Before I install Quick Updates, does anyone know if Quick Updates can be used to find products that are assigned to categories that don't exists?

Thanks

As long as you do not select a category in quick updates I think it will show all the products.

Cool, I'll give it a try!

I have move lots of product and category data around in our current iHTML store and know there are orphend products. With over 5K of products sorted under 100's of categories, going through one-at-a-time will be crazy making.

Having a list to work from will be much easier!

paulm:

To everyone that gets this message when installing quick updates (or any other mod that requires you to add sql to the datase):

First install this sql (using the "Install SQL Patches" tool):

DELETE FROM configuration WHERE configuration_key = "";

> And then try to install the quick updates sql again. Let us know if it helps.
 
 
HEEELP!!!
I install:
DELETE FROM configuration WHERE configuration_key = "";
And reinstall the quick updates sql again
But…
Some orders are registered and some orders not after the modification.
The system skip orders…
 
How can I remove this:
DELETE FROM configuration WHERE configuration_key = "";
:shocking:

Restore from your backup made before you installed the mod.

You DID make a backup didn't you?:bangin:

And in addition to the above I would like to add that I have strong doubts that your skipped orders are caused by the formentioned query.

paulm:

And in addition to the above I would like to add that I have strong doubts that your skipped orders are caused by the formentioned query.

I must agree with Paul here, there is NO associate between the two.

This advice is NEVER repeated enough:

1. MAKE A FULL BACKUP OF YOUR DATA from with phpMyAdmin. The zencart admin mysql backup tool is good, but you can brute force the restore with phpMyAdmin.

2. When installing a mod you have no experience with, PLEASE for your own sanity backup your store into a subdirectory, install your data into another database, and first test here. If you botch something, you loose nothing but some time. This requires a little setup time (you need to update your configure.php files), but well worth it in the long run.

-Chaddro

Hi,
Yes I make a complete database backup and I tested the shop and it seem woks fine in the beginning.
I observed the problem first after a lot of the orders! Many of them was skipped.
I restored configuration table from the backup and it’s OK now!

Glad to hear you are ok again.:yes:

Zis:

I restored configuration table from the backup and it’s OK now!Hi Zis, I think it would be interesting to take a look at the empty configuration_key rows in your database. Especially if removing the empty configuration_key rows from your configuration table really caused the skipping of orders.

If you are willing to mail me both configuration tables (or at least the current one, that has the empty configuration_key) so I can take a look, please send me a PM.

It appears that many Zen Cart shops have a configuration table entry like this:

(1018, 'Installed Modules', '', '', 'This is automatically updated. No need to edit.', 6, 0, NULL, '2008-03-07 11:51:49', NULL, NULL),This is the offending empty configuration_key that results in a duplicate configuration_key error message (when using the sql patch tool, and under certain circumstances). Normally the 'Installed Modules' key would be MODULE_SHIPPING_INSTALLED, MODULE_ORDER_TOTAL_INSTALLED or MODULE_PAYMENT_INSTALLED. Maybe there are more? No idea how and when the empty key is added to the configuration table. Most shops don't have it.

Quick question: Can stock quantities be updated with Quick Updates?

Quick answer: Yes.

Thanks :D

I don't know if this has been done or not. I spent a while looking for a solution.

I need Quick Updates to work with Group Pricing per item. Any ideas?