Quick Updates plugin [support]

Sorry, I only take a quick look at this thread now and then, but I really have no plans to update or seriously support the 2.x versions. Unless someone pays me to do so, or I get very bored for some reason, maybe :smartalec:.

But everyone is free to fix it of course :smile: In that case lookup all get forms, and ad the zen_hide_session_id() function like in other Zen Cart code.

I would fix any cookie issues with your site too though. As far as I know you won't have a problem with this if the cookies work.

Is it somehow possible to modify Quick Updates so that you can also add products and not just edit existing ones?

I have Quick Updates v2.03 installed on a ZenCart 1.3.8a. I've been using earlier versions of Quick Updates on earlier ZC versions and not had this issue come up:

I recently added a product. It has a long description field of 4 or 5 paragraphs. It has a hyper link in it. When displaying the Quick Updates page, the descriptions only show if you mouse-over the "e" button in the description column. However for this new product, part of the description for this new product is inserted into the quick updates line and pushes the rest of the columns way over to the right. See photo.

After playing around with the text in the description for a while, I found that the only text that got inserted incorrectly into the Quick Updates row was a hyperlink and the text after the hyperlink. The text prior to the hyperlink would show up normally when you do the mouseover the "e" button, and the rest of the text would be inserted into the table displaying the Quick Updates fields, messing it all up.

I've found that wherever I move the hyperlink, the same phenomena occurs. And it always starts with the hyperlink. The mouseover will show the text up to the hyperlink, and the hyperlink and all following text will jam itself into the Quick Updates table.

Here's the hyperlink:```html
For the full installation instructions, please go to <a target="_blank" href="http://www.fuelsaver-mpg.com/doc/afr_efie_install.html">Wide Band EFIE Installation Instructions</a>.

Thanks.

n_36:

Hi all,

I've got an issue where I get logged-out of the admin panel whenever I click one of the drop-down menu's in Quick Updates 2.04, anyone got any ideas why this is happening and how to stop it doing this?

I recently updated my php to 5.2.5 and had some issues with being able to log in the admin panel at all, but got resolved, not sure if this is related.

Cheers...
I was having this same issue. After some research I was able to get rid of this "bug"...sorta....or at least I found a work around. Here's what I did:
Change /cache permissions to 777
Disabled firewall while using Quick Updates - I have Zone Alarm running on my PC and for some reason it was part of the problem.

Ensure you clear your cache, close all browser windows, then shutdown firewall. Then open your browser and go to your admin login page directly. If you don't have it bookmarked, I'd do that to limit your computers exposure to the outside realm:smile:
After that I was able to select anything with the pull down menus, update products, etc... without getting returned to the login page.:clap:

This works for me, I am running zencart 1.3.8a and using Quick Updates v2.04

Hmmm. This sounds a little bit much for me, but it points me in a direction I had looked at. I'm not surprised that the firewall has managed to get involved in this. I use Kaspersky. I'll look into that...

kehrli,

Did you figure out what was causing this issue. I just installed Quick Updates 2.04 and am having the EXACT same issue as you describe and show in your screenshot with the columns.

paulm:

Sorry, I only take a quick look at this thread now and then, but I really have no plans to update or seriously support the 2.x versions. Unless someone pays me to do so, or I get very bored for some reason, maybe :smartalec:.

But everyone is free to fix it of course :smile: In that case lookup all get forms, and ad the zen_hide_session_id() function like in other Zen Cart code.

I would fix any cookie issues with your site too though. As far as I know you won't have a problem with this if the cookies work.

UPDATE for anyone else with the same problem I had re: being logged out when selecting an option from the manufacturer/category etc. I finally got it working using the above advice (as I'm not a programmer).

1. Open up: quick_updates.php
2. Add:

. zen_hide_session_id() .

...just after the: '  ' in lines 599 to 602 for the drop down menus.

3. Voila.. should all work now.

i love this mod, anyone know if there is anything like this for attribute prices?

Hi All,

I installed quick updates and what a fantastic module this is because it does save a lot of time with updating bulk items at once.

My question is that I installed quick updates some months back and all is working great and have no problems at all but I then installed another module products_profit_margin_calculator_reportv1.1 which is another good module where you put in your cost price and % margin that you want.

What I was wondering was when quick updates screen comes up it does not show the percentage markup column and if there is a fix for this issue in order to make it work within quick updates so both mods work together in order to update pricing in the future.

Any advice would be great as I love quick updates but really need the profit margin module as we work on % on cost and have several different %'s depending on cost of the item and we adding product on a daily basis so you can see why we need quick updates as well otherwise it would take days to redo the % markup on cost.

When adding the SQL patch there is an error:

ERROR: Cannot insert configuration_key "" because it already exists
Note: 1 statements ignored. See "upgrade_exceptions" table for additional details.

This seems simple and I've had this error before but I can't remember the solution.

shocker:

When adding the SQL patch there is an error:

ERROR: Cannot insert configuration_key "" because it already exists
Note: 1 statements ignored. See "upgrade_exceptions" table for additional details.

This seems simple and I've had this error before but I can't remember the solution.

You must rewrite install.sql.

a_berezin:

You must rewrite install.sql.

Can you be more elaborate?

shocker:

Can you be more elaborate?

It is difficult to explain. If you show me your install.sql - I can tell you how to change it.

a_berezin:

It is difficult to explain. If you show me your install.sql - I can tell you how to change it.

Sorry, man I just looked at my original post. I would have sworn that I put the SQL code in it. My apologies. Here is the code.

# remove Quick Updates setting 
#

#SELECT @quick_updates_id:=configuration_group_id
#FROM configuration_group WHERE configuration_group_title="Quick Updates";
#DELETE FROM configuration WHERE configuration_group_id=@quick_updates_id;
#DELETE FROM configuration_group WHERE configuration_group_id=@quick_updates_id;


SET @t4=0;
SELECT (@t4:=configuration_group_id) as t4 
FROM configuration_group
WHERE configuration_group_title= 'Quick Updates';
DELETE FROM configuration WHERE configuration_group_id = @t4;
DELETE FROM configuration_group WHERE configuration_group_id = @t4;

INSERT INTO configuration_group VALUES ('', 'Quick Updates', 'Set Quick Updates Options', '1', '1');
UPDATE configuration_group SET sort_order = last_insert_id() WHERE configuration_group_id = last_insert_id();

SET @t4=0;
SELECT (@t4:=configuration_group_id) as t4 
FROM configuration_group
WHERE configuration_group_title= 'Quick Updates';

INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES
('', 'Display the ID.', 'QUICKUPDATES_DISPLAY_ID', 'true', 'Enable/Disable the products id displaying', @t4, 1, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),'),
('', 'Display the thumbnail.', 'QUICKUPDATES_DISPLAY_THUMBNAIL', 'true', 'Enable/Disable the products thumbnail displaying', @t4, 2, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),'),
('', 'Modify the model.', 'QUICKUPDATES_MODIFY_MODEL', 'true', 'Enable/Disable the products model displaying and modification', @t4, 3, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),'),
('', 'Modify the name.', 'QUICKUPDATES_MODIFY_NAME', 'true', 'Enable/Disable the products name editing', @t4, 4, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),'),
('', 'Modify the Description.', 'QUICKUPDATES_MODIFY_DESCRIPTION', 'true', 'Enable/Disable the displaying and modification of products description', @t4, 5, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),'),
('', 'Modify the status of the products.', 'QUICKUPDATES_MODIFY_STATUS', 'true', 'Allow/Disallow the Status displaying and modification', @t4, 6, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),'),
('', 'Modify the weight of the products.', 'QUICKUPDATES_MODIFY_WEIGHT', 'true', 'Allow/Disallow the Weight displaying and modification?', @t4, 7, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),'),
('', 'Modify the quantity of the products.', 'QUICKUPDATES_MODIFY_QUANTITY', 'true', 'Allow/Disallow the quantity displaying and modification', @t4, 8, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),'),
('', 'Modify the manufacturer of the products.', 'QUICKUPDATES_MODIFY_MANUFACTURER', 'false', 'Allow/Disallow the Manufacturer displaying and modification', @t4, 9, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),'),
('', 'Modify the class of tax of the products.', 'QUICKUPDATES_MODIFY_TAX', 'false', 'Allow/Disallow the Class of tax displaying and modification', @t4, 10, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),'),
('', 'Modify the category.', 'QUICKUPDATES_MODIFY_CATEGORY', 'true', 'Enable/Disable the products category modify', @t4, 11, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),'),
('', 'Display price with all included of tax.', 'QUICKUPDATES_DISPLAY_TVA_OVER', 'true', 'Enable/Disable the displaying of the Price with all tax included when your mouse is over a product', @t4, 20, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),'),
('', 'Display the link towards the products information page.', 'QUICKUPDATES_DISPLAY_PREVIEW', 'false', 'Enable/Disable the display of the link towards the products information page ', @t4, 30, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),'),
('', 'Display the link towards the page where you will be able to edit the product.', 'QUICKUPDATES_DISPLAY_EDIT', 'true', 'Enable/Disable the display of the link towards the page where you will be able to edit the product', @t4, 31, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),'),
('', 'Activate or desactivate the commercial margin.', 'QUICKUPDATES_ACTIVATE_COMMERCIAL_MARGIN', 'true', 'Do you want that the commercial margin be activate or not ?', @t4, 40, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),'),
('', 'Modify the sort order.', 'QUICKUPDATES_MODIFY_SORT_ORDER', 'true', 'Enable/Disable the products sort order modify', @t4, 11, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),'),
('', 'Use popup edit.', 'QUICKUPDATES_MODIFY_DESCRIPTION_POPUP', 'true', 'Enable/Disable using popup edit link to description editing', @t4, 11, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),');

shocker:

Here is the code.
Wow! This is very very old manner code :oops:
Use this:

SET @configuration_group_id=0;
SELECT (@configuration_group_id:=configuration_group_id) FROM configuration_group WHERE configuration_group_title= 'Quick Updates' LIMIT 1;
DELETE FROM configuration WHERE configuration_group_id = @configuration_group_id AND configuration_group_id != 0;
DELETE FROM configuration_group WHERE configuration_group_id = @configuration_group_id AND configuration_group_id != 0;

INSERT INTO configuration_group (configuration_group_id, configuration_group_title, configuration_group_description, sort_order, visible) VALUES (NULL, 'Quick Updates', 'Set Quick Updates Options', '1', '1');
SET @configuration_group_id=last_insert_id();
UPDATE configuration_group SET sort_order = @configuration_group_id WHERE configuration_group_id = @configuration_group_id;

INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES (NULL, 'Display the ID.', 'QUICKUPDATES_DISPLAY_ID', 'true', 'Enable/Disable the products id displaying', @configuration_group_id, 1, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES (NULL, 'Display the thumbnail.', 'QUICKUPDATES_DISPLAY_THUMBNAIL', 'true', 'Enable/Disable the products thumbnail displaying', @configuration_group_id, 2, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES (NULL, 'Modify the model.', 'QUICKUPDATES_MODIFY_MODEL', 'true', 'Enable/Disable the products model displaying and modification', @configuration_group_id, 3, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES (NULL, 'Modify the name.', 'QUICKUPDATES_MODIFY_NAME', 'true', 'Enable/Disable the products name editing', @configuration_group_id, 4, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES (NULL, 'Modify the Description.', 'QUICKUPDATES_MODIFY_DESCRIPTION', 'true', 'Enable/Disable the displaying and modification of products description', @configuration_group_id, 5, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES (NULL, 'Modify the status of the products.', 'QUICKUPDATES_MODIFY_STATUS', 'true', 'Allow/Disallow the Status displaying and modification', @configuration_group_id, 6, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES (NULL, 'Modify the weight of the products.', 'QUICKUPDATES_MODIFY_WEIGHT', 'true', 'Allow/Disallow the Weight displaying and modification?', @configuration_group_id, 7, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES (NULL, 'Modify the quantity of the products.', 'QUICKUPDATES_MODIFY_QUANTITY', 'true', 'Allow/Disallow the quantity displaying and modification', @configuration_group_id, 8, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES (NULL, 'Modify the manufacturer of the products.', 'QUICKUPDATES_MODIFY_MANUFACTURER', 'false', 'Allow/Disallow the Manufacturer displaying and modification', @configuration_group_id, 9, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES (NULL, 'Modify the class of tax of the products.', 'QUICKUPDATES_MODIFY_TAX', 'false', 'Allow/Disallow the Class of tax displaying and modification', @configuration_group_id, 10, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES (NULL, 'Modify the category.', 'QUICKUPDATES_MODIFY_CATEGORY', 'true', 'Enable/Disable the products category modify', @configuration_group_id, 11, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES (NULL, 'Display price with all included of tax.', 'QUICKUPDATES_DISPLAY_TVA_OVER', 'true', 'Enable/Disable the displaying of the Price with all tax included when your mouse is over a product', @configuration_group_id, 20, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES (NULL, 'Display the link towards the products information page.', 'QUICKUPDATES_DISPLAY_PREVIEW', 'false', 'Enable/Disable the display of the link towards the products information page ', @configuration_group_id, 30, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES (NULL, 'Display the link towards the page where you will be able to edit the product.', 'QUICKUPDATES_DISPLAY_EDIT', 'true', 'Enable/Disable the display of the link towards the page where you will be able to edit the product', @configuration_group_id, 31, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES (NULL, 'Activate or desactivate the commercial margin.', 'QUICKUPDATES_ACTIVATE_COMMERCIAL_MARGIN', 'true', 'Do you want that the commercial margin be activate or not ?', @configuration_group_id, 40, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES (NULL, 'Modify the sort order.', 'QUICKUPDATES_MODIFY_SORT_ORDER', 'true', 'Enable/Disable the products sort order modify', @configuration_group_id, 11, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES (NULL, 'Use popup edit.', 'QUICKUPDATES_MODIFY_DESCRIPTION_POPUP', 'true', 'Enable/Disable using popup edit link to description editing', @configuration_group_id, 11, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),');

Thanks a_berezin.
That worked.

Without my having to analyze the code too much, what was the problem?

I have another SQL code block that' giving me similar problems:

Great mod! What a time saver!:clap:

shocker:

what was the problem?
The main problem - the use of the extended syntax INSERT INTO

shocker:

Great mod! What a time saver!:clap:
You can save even more time :cool:

is there a way to easily add multilanguage edits for product description and name?