Quick Updates plugin [support]

Re: Quick Updates 1.3 ?

I also have 2 quick updates links under catalog

Background
I’m working on an update “new_store” for zen-cart 1.5.4, using the latest quick updates version downloaded from DivaVocals’ Github. My current live store is on the same server using quick updates 2.06 working on zen-cart 1.5.1.

I have tried everything, including deleting all quick updates files (on the new_store) indicated in the instructions, and this thread, and when that did not work, manually deleting every quick updates file in the “new_store”, manually running the uninstall SQL (the uninstall button is inoperable) and re-uploading the mod and still have the two links. Before people say read the thread, I did delete the three files indicated in the instructions, and these two files:

admin/includes/functions/extra_functions/quick_updates_functions.php
admin/includes/functions/extra_functions/reg_quick_updates.php

One final thing. When I manually deleted all files, and manually ran the uninstall SQL, even when I started over, there was no install button, I uploaded all files, and quick updates appeared. No install link to click. It appears to be working fine, except I have 2 links. Is there a fix to remove the two links?

Re: Quick Updates 1.3 ?

Quote:

Originally Posted by paranoia

Thanks for your help,When I readed all information in this support threads,fixed this problem,but now have 2 of "quick updated" tag in my admin>catalog dropdown.

Do you know how was that happen?

The double entry is caused by two separate database entries, which are identical except for the sort order. In my case, in updating from another version, all files were deleted, but the uninstall script did not remove the database table. So you need to delete the earlier entry.

backup your zen cart database
go to cpanel »» phpmyadmin »» click on the database »» click zen_admin_pages »» click browse

you should find two entries (not necessarily on the same page) like this:
quick_updates_catalog BOX_CATALOG_QUICK_UPDATES

one had 'configuration', 'Y', 103 (the old version)
the other had 'configuration', 'Y', 1010 (the beta version from divavocals' GitHub)

Delete the entry that has the earlier module version, (103) table, and the extra entry in the admin will disappear. This link gives an explanation of the admin table:
http://www.zen-cart.com/content.php?...e-v1-5-0-admin

It’s pretty shocking that a month has passed since you posted, and no one could help with this issue. I’m not sure what’s happened to this forum.

Two identical entries were for the catalog for quick updates, and both had different sort orders.

zen_admin_pages

I searched the files on my computer for the older version, and it had a sort order of 103. The other entry in the phpmyadmin had an entry of 1010, so I deleted the 103 entry, and the table was removed from the admin.

Re: Quick Updates 1.3 ?

Quote:

Originally Posted by paranoia

Thanks for your help,When I readed all information in this support threads,fixed this problem,but now have 2 of "quick updated" tag in my admin>catalog dropdown.

Do you know how was that happen?

The double entry is caused by two separate database entries, which are identical except for the sort order. In my case, in updating from another version, all files were deleted, but the uninstall script did not remove the database table. So you need to delete the earlier entry.

backup your zen cart database
go to cpanel »» phpmyadmin »» click on the database »» click zen_admin_pages »» click browse

you should find two entries (not necessarily on the same page) like this:
quick_updates_catalog BOX_CATALOG_QUICK_UPDATES

one had 'configuration', 'Y', 103 (the old version)
the other had 'configuration', 'Y', 1010 (the beta version from divavocals' GitHub)

Delete the entry that has the earlier module version, (103) table, and the extra entry in the admin will disappear. This link gives an explanation of the admin table:
http://www.zen-cart.com/content.php?...e-v1-5-0-admin

It’s pretty shocking that a month has passed since you posted, and no one could help with this issue. I’m not sure what’s happened to this forum.

Re: Quick Updates 1.3 ?

Quote:

Originally Posted by sadie

It’s pretty shocking that a month has passed since you posted, and no one could help with this issue. I’m not sure what’s happened to this forum.

Has it been a month?? Hmmm.. Shocking eh??:no:

What happened?? Okay well speaking only for myself here.. I've been busy.. Busy with paying projects.. too busy with projects that actually help put food on my table to in fact to get back to troubleshooting something I maintain when I have FREE time..

Thanks for sharing the issue, and you're posting the solution here will help others.. I'll test what went wrong in the uninstaller and make the changes accordingly.. When my FREE time permits.. In the meantime the beauty of Github is ANYONE can do this and send me a pull request, and I can incorporate the fix into the master repo..

1 Attachment(s)

Missing picture? Logo?

Just installed Quick updates on my server, everything runs great but there's a broken image above the uninstall Quick Update link on the upper right hand corner of the page. It appears to simply point to my /image/ directory, which it's not browsable for security reasons.

What exactly is supposed to be at this location, and how can I "fix" it?
Attached image for reference.
Server is ZC 1.5.5a, Quick updates v.2.07

Thanks.

Attachment 16541

Re: Missing picture? Logo?

Quote:

Originally Posted by chibipaw

Just installed Quick updates on my server, everything runs great but there's a broken image above the uninstall Quick Update link on the upper right hand corner of the page. It appears to simply point to my /image/ directory, which it's not browsable for security reasons.

What exactly is supposed to be at this location, and how can I "fix" it?
Attached image for reference.
Server is ZC 1.5.5a, Quick updates v.2.07

Thanks.

Attachment 16541

In the image your heading shows v.2.06 but you are stating that you are using v.2.07.

Did you recently upgrade from 2.06 to 2.07? If so, are all the new files uploaded?

Re: Missing picture? Logo?

Odd. I just pulled whatever the using the "download latest" on July 25th. The zip file is actually labeled quick_updates-v2.07.zip. Perhaps some of the definitions in the package itself hasn't been updated, which it's rather common actually. But I notice there's now a 2.07b. I'll update to that and see if it'll go away, and the version number would be correct in that package..

Quote:

Originally Posted by frank18

In the image your heading shows v.2.06 but you are stating that you are using v.2.07.

Did you recently upgrade from 2.06 to 2.07? If so, are all the new files uploaded?

1 Attachment(s)

Re: Missing picture? Logo?

Updated to v2.07b, got rid of that weird broken image box.

However, someone done did goofed on admin/includes/languages/english/quick_updates.php .
in line 24 it reads:
define('HEADING_TITLE', 'Quick Updates - v2.06');

So plugged in a silly definition into mine.

Cheers.

Attachment 16552

Quote:

Originally Posted by frank18

In the image your heading shows v.2.06 but you are stating that you are using v.2.07.

Did you recently upgrade from 2.06 to 2.07? If so, are all the new files uploaded?

Re: Missing picture? Logo?

For reference, there is an updated version on GitHub that does fix this issue as well as a few others
https://github.com/DivaVocals/zen_QuickUpdates

Re: Missing picture? Logo?

I am using Zencart V1.54.

I tried installing the latest version. When I click install to configure, I get Warning: error occurred. I can go back to the quick update page, but things are missing such as product name.

I went to github and downloaded vdr 2.08. This caused even a worse situation. I had to go in and remove the updated database files, and remove the autoloader to be able to get back into my admin. Also noticed on github it said version 2.08 last updated 2 years ago.

Really would like to get this thing working correctly.

Re: Missing picture? Logo?

Quote:

Originally Posted by dspeak35640

I am using Zencart V1.54.

I tried installing the latest version. When I click install to configure, I get Warning: error occurred. I can go back to the quick update page, but things are missing such as product name.

I went to github and downloaded vdr 2.08. This caused even a worse situation. I had to go in and remove the updated database files, and remove the autoloader to be able to get back into my admin. Also noticed on github it said version 2.08 last updated 2 years ago.

Really would like to get this thing working correctly.

Need more information to be of any help. When you installed the first time, did you check your 'logs' folder. What was the error message? What other plugins have you installed on your store?

Re: Missing picture? Logo?

Here is what my log showed. I x'd out site info.

[05-Aug-2016 16:45:23 UTC] PHP Fatal error: 1136:Column count doesn't match value count at row 1 :: INSERT INTO zc_configuration_group (configuration_group_id, configuration_group_title, configuration_group_description , sort_order, visible) VALUES ('Quick Updates', 'Quick Updates Configuration', '1', '1') ==> (as called by) /home/xxxxxxx/xxxxxx/xxxxxxx/includes/functions/extra_functions/quick_updates_functions.php on line 39 <== in /home/xxxxxxxxx/public_html/includes/classes/db/mysql/query_factory.php on line 155

Re: Missing picture? Logo?

I am guessing from this it has something to do with the database not being updated properly.

Re: Missing picture? Logo?

It's trying to give a sort order that is already in use. You can try to change the sort order to something like 40 and see if that works.
BACKUP FIRST!

Code:

INSERT INTO zc_configuration_group (configuration_group_id, configuration_group_title, configuration_group_description , sort_order, visible) VALUES ('Quick Updates', 'Quick Updates Configuration', '1', '1')

becomes

Code:

INSERT INTO zc_configuration_group (configuration_group_id, configuration_group_title, configuration_group_description , sort_order, visible) VALUES ('Quick Updates', 'Quick Updates Configuration', '40', '1')

Re: Missing picture? Logo?

The issue is the "over-specification" of the table's fields:

Code:

INSERT INTO zc_configuration_group (configuration_group_id, configuration_group_title, configuration_group_description , sort_order, visible) VALUES ('Quick Updates', 'Quick Updates Configuration', '1', '1')

mySQL is complaining because the statement specifies 5 fields to be updated, but only provided values for 4.

Change that statement to:

Code:

INSERT INTO zc_configuration_group (configuration_group_title, configuration_group_description , sort_order, visible) VALUES ('Quick Updates', 'Quick Updates Configuration', '1', '1')

and you should be "all better".

Re: Missing picture? Logo?

That was it!!! Thank you so very much Lat9. It installed correctly now and looks good. Thank you, thank you, thank you.

Re: Missing picture? Logo?

gotta get new trifocals:blush:

Re: Missing picture? Logo?

I am getting the same error:

HTML Code:

PHP Fatal error: 1136:Column count doesn't match value count at row 1 :: INSERT INTO zen_configuration_group (configuration_group_id, configuration_group_title, configuration_group_description , sort_order, visible) VALUES ('Quick Updates', 'Quick Updates Configuration', '1', '1')

I tried 2 solutions mentioned above but it did not work. Any idea how to fix it?

I have the file which came with latest module version and ZC 1.5.3

Re: Missing picture? Logo?

The error you posted indicates that you haven't removed the configuration_group_id field name from the SQL:

Code:

INSERT INTO zen_configuration_group (configuration_group_id, configuration_group_title, configuration_group_description , sort_order, visible) VALUES ('Quick Updates', 'Quick Updates Configuration', '1', '1')

As I indicated above, just remove the highlighted field (that doesn't have a value) and the query will work just fine:

Code:

INSERT INTO zen_configuration_group (configuration_group_title, configuration_group_description , sort_order, visible) VALUES ('Quick Updates', 'Quick Updates Configuration', '1', '1')

Re: Missing picture? Logo?

I don't see configuration_group_id in insert line. I manually added configuration_group_id but still same error. File I got from module is and getting error:

Code:

<?php/** * @package admin * @copyright Copyright 2003-2006 Zen Cart Development Team * @copyright Portions Copyright 2003 osCommerce * @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0 * @version $Id: copy_to_confirm.php 3380 2006-04-06 05:12:45Z drbyte $ */ if (!defined('IS_ADMIN_FLAG')) { die('Illegal Access'); } function install_quick_updates() { global $db; $project = PROJECT_VERSION_MAJOR.'.'.PROJECT_VERSION_MINOR; if ( (substr($project,0,5) == "1.3.8") || (substr($project,0,5) == "1.3.9") ) { $db->Execute("INSERT INTO ".TABLE_CONFIGURATION_GROUP." (configuration_group_title, configuration_group_description , sort_order, visible) VALUES ('Quick Updates', 'Quick Updates Configuration', '1', '1')"); $group_id = mysql_insert_id(); $db->Execute("UPDATE ".TABLE_CONFIGURATION_GROUP." SET sort_order = ".$group_id." WHERE configuration_group_id = ".$group_id); $db->Execute("INSERT INTO ".TABLE_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', ".$group_id.", '1', NULL, NOW(), NULL, 'zen_cfg_select_option(array(\"true\", \"false\"),'), (NULL, 'Display the thumbnail.', 'QUICKUPDATES_DISPLAY_THUMBNAIL', 'true', 'Enable/Disable the products thumbnail displaying', ".$group_id.", '2', NULL, NOW(), NULL, 'zen_cfg_select_option(array(\"true\", \"false\"),'), (NULL, 'Modify the model.', 'QUICKUPDATES_MODIFY_MODEL', 'true', 'Enable/Disable the products model displaying and modification', ".$group_id.", '3', NULL, NOW(), NULL, 'zen_cfg_select_option(array(\"true\", \"false\"),'), (NULL, 'Modify the name.', 'QUICKUPDATES_MODIFY_NAME', 'true', 'Enable/Disable the products name editing', ".$group_id.", '4', NULL, NOW(), NULL, 'zen_cfg_select_option(array(\"true\", \"false\"),'), (NULL, 'Modify the Description.', 'QUICKUPDATES_MODIFY_DESCRIPTION', 'true', 'Enable/Disable the displaying and modification of products description', ".$group_id.", '5', NULL, NOW(), NULL, 'zen_cfg_select_option(array(\"true\", \"false\"),'), (NULL, 'Modify the status of the products.', 'QUICKUPDATES_MODIFY_STATUS', 'true', 'Allow/Disallow the Status displaying and modification', ".$group_id.", '6', NULL, NOW(), NULL, 'zen_cfg_select_option(array(\"true\", \"false\"),'), (NULL, 'Modify the weight of the products.', 'QUICKUPDATES_MODIFY_WEIGHT', 'true', 'Allow/Disallow the Weight displaying and modification?', ".$group_id.", '7', NULL, NOW(), NULL, 'zen_cfg_select_option(array(\"true\", \"false\"),'), (NULL, 'Modify the quantity of the products.', 'QUICKUPDATES_MODIFY_QUANTITY', 'true', 'Allow/Disallow the quantity displaying and modification', ".$group_id.", '8', NULL, NOW(), NULL, 'zen_cfg_select_option(array(\"true\", \"false\"),'), (NULL, 'Modify the manufacturer of the products.', 'QUICKUPDATES_MODIFY_MANUFACTURER', 'false', 'Allow/Disallow the Manufacturer displaying and modification', ".$group_id.", '9', NULL, NOW(), NULL, 'zen_cfg_select_option(array(\"true\", \"false\"),'), (NULL, 'Modify the class of tax of the products.', 'QUICKUPDATES_MODIFY_TAX', 'false', 'Allow/Disallow the Class of tax displaying and modification', ".$group_id.", '10', NULL, NOW(), NULL, 'zen_cfg_select_option(array(\"true\", \"false\"),'), (NULL, 'Modify the category.', 'QUICKUPDATES_MODIFY_CATEGORY', 'true', 'Enable/Disable the products category modify', ".$group_id.", '11', NULL, NOW(), NULL, 'zen_cfg_select_option(array(\"true\", \"false\"),'), (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', ".$group_id.", '20', NULL, NOW(), NULL, 'zen_cfg_select_option(array(\"true\", \"false\"),'), (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 ', ".$group_id.", '30', NULL, NOW(), NULL, 'zen_cfg_select_option(array(\"true\", \"false\"),'), (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', ".$group_id.", '31', NULL, NOW(), NULL, 'zen_cfg_select_option(array(\"true\", \"false\"),'), (NULL, 'Activate or desactivate the commercial margin.', 'QUICKUPDATES_ACTIVATE_COMMERCIAL_MARGIN', 'true', 'Do you want that the commercial margin be activate or not ?',".$group_id.", '40', NULL, NOW(), NULL, 'zen_cfg_select_option(array(\"true\", \"false\"),'), (NULL, 'Modify the sort order.', 'QUICKUPDATES_MODIFY_SORT_ORDER', 'true', 'Enable/Disable the products sort order modify', ".$group_id.", '12', NULL, NOW(), NULL, 'zen_cfg_select_option(array(\"true\", \"false\"),'), (NULL, 'Use popup edit.', 'QUICKUPDATES_MODIFY_DESCRIPTION_POPUP', 'true', 'Enable/Disable using popup edit link to description editing', ".$group_id.", '13', NULL, NOW(), NULL, 'zen_cfg_select_option(array(\"true\", \"false\"),') "); } elseif (substr($project,0,3) == "1.5") { $db->Execute("INSERT INTO ".TABLE_CONFIGURATION_GROUP." (configuration_group_id, configuration_group_title, configuration_group_description , sort_order, visible) VALUES ('Quick Updates', 'Quick Updates Configuration', '1', '1')"); $group_id = $db->Insert_ID(); $db->Execute("UPDATE ".TABLE_CONFIGURATION_GROUP." SET sort_order = ".$group_id." WHERE configuration_group_id = ".$group_id); zen_register_admin_page('quick_updates_config', 'BOX_CATALOG_QUICK_UPDATES','FILENAME_CONFIGURATION', 'gID='.$group_id, 'configuration', 'Y', 103); $db->Execute("INSERT INTO ".TABLE_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', ".$group_id.", '1', NULL, NOW(), NULL, 'zen_cfg_select_option(array(\"true\", \"false\"),'), (NULL, 'Display the thumbnail.', 'QUICKUPDATES_DISPLAY_THUMBNAIL', 'true', 'Enable/Disable the products thumbnail displaying', ".$group_id.", '2', NULL, NOW(), NULL, 'zen_cfg_select_option(array(\"true\", \"false\"),'), (NULL, 'Modify the model.', 'QUICKUPDATES_MODIFY_MODEL', 'true', 'Enable/Disable the products model displaying and modification', ".$group_id.", '3', NULL, NOW(), NULL, 'zen_cfg_select_option(array(\"true\", \"false\"),'), (NULL, 'Modify the name.', 'QUICKUPDATES_MODIFY_NAME', 'true', 'Enable/Disable the products name editing', ".$group_id.", '4', NULL, NOW(), NULL, 'zen_cfg_select_option(array(\"true\", \"false\"),'), (NULL, 'Modify the Description.', 'QUICKUPDATES_MODIFY_DESCRIPTION', 'true', 'Enable/Disable the displaying and modification of products description', ".$group_id.", '5', NULL, NOW(), NULL, 'zen_cfg_select_option(array(\"true\", \"false\"),'), (NULL, 'Modify the status of the products.', 'QUICKUPDATES_MODIFY_STATUS', 'true', 'Allow/Disallow the Status displaying and modification', ".$group_id.", '6', NULL, NOW(), NULL, 'zen_cfg_select_option(array(\"true\", \"false\"),'), (NULL, 'Modify the weight of the products.', 'QUICKUPDATES_MODIFY_WEIGHT', 'true', 'Allow/Disallow the Weight displaying and modification?', ".$group_id.", '7', NULL, NOW(), NULL, 'zen_cfg_select_option(array(\"true\", \"false\"),'), (NULL, 'Modify the quantity of the products.', 'QUICKUPDATES_MODIFY_QUANTITY', 'true', 'Allow/Disallow the quantity displaying and modification', ".$group_id.", '8', NULL, NOW(), NULL, 'zen_cfg_select_option(array(\"true\", \"false\"),'), (NULL, 'Modify the manufacturer of the products.', 'QUICKUPDATES_MODIFY_MANUFACTURER', 'false', 'Allow/Disallow the Manufacturer displaying and modification', ".$group_id.", '9', NULL, NOW(), NULL, 'zen_cfg_select_option(array(\"true\", \"false\"),'), (NULL, 'Modify the class of tax of the products.', 'QUICKUPDATES_MODIFY_TAX', 'false', 'Allow/Disallow the Class of tax displaying and modification', ".$group_id.", '10', NULL, NOW(), NULL, 'zen_cfg_select_option(array(\"true\", \"false\"),'), (NULL, 'Modify the category.', 'QUICKUPDATES_MODIFY_CATEGORY', 'true', 'Enable/Disable the products category modify', ".$group_id.", '11', NULL, NOW(), NULL, 'zen_cfg_select_option(array(\"true\", \"false\"),'), (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', ".$group_id.", '20', NULL, NOW(), NULL, 'zen_cfg_select_option(array(\"true\", \"false\"),'), (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 ', ".$group_id.", '30', NULL, NOW(), NULL, 'zen_cfg_select_option(array(\"true\", \"false\"),'), (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', ".$group_id.", '31', NULL, NOW(), NULL, 'zen_cfg_select_option(array(\"true\", \"false\"),'), (NULL, 'Activate or desactivate the commercial margin.', 'QUICKUPDATES_ACTIVATE_COMMERCIAL_MARGIN', 'true', 'Do you want that the commercial margin be activate or not ?',".$group_id.", '40', NULL, NOW(), NULL, 'zen_cfg_select_option(array(\"true\", \"false\"),'), (NULL, 'Modify the sort order.', 'QUICKUPDATES_MODIFY_SORT_ORDER', 'true', 'Enable/Disable the products sort order modify', ".$group_id.", '12', NULL, NOW(), NULL, 'zen_cfg_select_option(array(\"true\", \"false\"),'), (NULL, 'Use popup edit.', 'QUICKUPDATES_MODIFY_DESCRIPTION_POPUP', 'true', 'Enable/Disable using popup edit link to description editing', ".$group_id.", '13', NULL, NOW(), NULL, 'zen_cfg_select_option(array(\"true\", \"false\"),') "); } else { // unsupported version // i should do something here! } } function remove_quick_updates() { global $db; $project = PROJECT_VERSION_MAJOR.'.'.PROJECT_VERSION_MINOR; if ( (substr($project,0,5) == "1.3.8") || (substr($project,0,5) == "1.3.9") ) { $sql = "SELECT configuration_group_id FROM ".TABLE_CONFIGURATION_GROUP." WHERE configuration_group_title = 'Quick Updates' LIMIT 1"; $result = $db->Execute($sql); if (mysql_num_rows($result)) { $group_id = mysql_fetch_array($result); $db->Execute("DELETE FROM ".TABLE_CONFIGURATION." WHERE configuration_group_id = ".$group_id[0]); $db->Execute("DELETE FROM ".TABLE_CONFIGURATION_GROUP." WHERE configuration_group_id = ".$group_id[0]); } } elseif (substr($project,0,3) == "1.5") { $sql = "SELECT configuration_group_id FROM ".TABLE_CONFIGURATION_GROUP." WHERE configuration_group_title = 'Quick Updates' LIMIT 1"; $result = $db->Execute($sql); if ($result->RecordCount() > 0) { $group_id = $result->fields['configuration_group_id']; $db->Execute("DELETE FROM ".TABLE_CONFIGURATION." WHERE configuration_group_id = ".$group_id); $db->Execute("DELETE FROM ".TABLE_CONFIGURATION_GROUP." WHERE configuration_group_id = ".$group_id); $db->Execute("DELETE FROM ".TABLE_ADMIN_PAGES." WHERE page_key = 'quick_updates'"); $db->Execute("DELETE FROM ".TABLE_ADMIN_PAGES." WHERE page_key = 'quick_updates_config'"); } } else { // unsupported version } } ?>

Re: Missing picture? Logo?

Got it working. I was looking at different line then what you referring to.

Re: Missing picture? Logo?

Change all occurrences of (NULL, to ( in the following section:

Code:

(NULL, 'Display the ID.', 'QUICKUPDATES_DISPLAY_ID', 'true', 'Enable/Disable the products id displaying', ".$group_id.", '1', NULL, NOW(), NULL, 'zen_cfg_select_option(array(\"true\", \"false\"),'), (NULL, 'Display the thumbnail.', 'QUICKUPDATES_DISPLAY_THUMBNAIL', 'true', 'Enable/Disable the products thumbnail displaying', ".$group_id.", '2', NULL, NOW(), NULL, 'zen_cfg_select_option(array(\"true\", \"false\"),'), (NULL, 'Modify the model.', 'QUICKUPDATES_MODIFY_MODEL', 'true', 'Enable/Disable the products model displaying and modification', ".$group_id.", '3', NULL, NOW(), NULL, 'zen_cfg_select_option(array(\"true\", \"false\"),'), (NULL, 'Modify the name.', 'QUICKUPDATES_MODIFY_NAME', 'true', 'Enable/Disable the products name editing', ".$group_id.", '4', NULL, NOW(), NULL, 'zen_cfg_select_option(array(\"true\", \"false\"),'), (NULL, 'Modify the Description.', 'QUICKUPDATES_MODIFY_DESCRIPTION', 'true', 'Enable/Disable the displaying and modification of products description', ".$group_id.", '5', NULL, NOW(), NULL, 'zen_cfg_select_option(array(\"true\", \"false\"),'), (NULL, 'Modify the status of the products.', 'QUICKUPDATES_MODIFY_STATUS', 'true', 'Allow/Disallow the Status displaying and modification', ".$group_id.", '6', NULL, NOW(), NULL, 'zen_cfg_select_option(array(\"true\", \"false\"),'), (NULL, 'Modify the weight of the products.', 'QUICKUPDATES_MODIFY_WEIGHT', 'true', 'Allow/Disallow the Weight displaying and modification?', ".$group_id.", '7', NULL, NOW(), NULL, 'zen_cfg_select_option(array(\"true\", \"false\"),'), (NULL, 'Modify the quantity of the products.', 'QUICKUPDATES_MODIFY_QUANTITY', 'true', 'Allow/Disallow the quantity displaying and modification', ".$group_id.", '8', NULL, NOW(), NULL, 'zen_cfg_select_option(array(\"true\", \"false\"),'), (NULL, 'Modify the manufacturer of the products.', 'QUICKUPDATES_MODIFY_MANUFACTURER', 'false', 'Allow/Disallow the Manufacturer displaying and modification', ".$group_id.", '9', NULL, NOW(), NULL, 'zen_cfg_select_option(array(\"true\", \"false\"),'), (NULL, 'Modify the class of tax of the products.', 'QUICKUPDATES_MODIFY_TAX', 'false', 'Allow/Disallow the Class of tax displaying and modification', ".$group_id.", '10', NULL, NOW(), NULL, 'zen_cfg_select_option(array(\"true\", \"false\"),'), (NULL, 'Modify the category.', 'QUICKUPDATES_MODIFY_CATEGORY', 'true', 'Enable/Disable the products category modify', ".$group_id.", '11', NULL, NOW(), NULL, 'zen_cfg_select_option(array(\"true\", \"false\"),'), (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', ".$group_id.", '20', NULL, NOW(), NULL, 'zen_cfg_select_option(array(\"true\", \"false\"),'), (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 ', ".$group_id.", '30', NULL, NOW(), NULL, 'zen_cfg_select_option(array(\"true\", \"false\"),'), (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', ".$group_id.", '31', NULL, NOW(), NULL, 'zen_cfg_select_option(array(\"true\", \"false\"),'), (NULL, 'Activate or desactivate the commercial margin.', 'QUICKUPDATES_ACTIVATE_COMMERCIAL_MARGIN', 'true', 'Do you want that the commercial margin be activate or not ?',".$group_id.", '40', NULL, NOW(), NULL, 'zen_cfg_select_option(array(\"true\", \"false\"),'), (NULL, 'Modify the sort order.', 'QUICKUPDATES_MODIFY_SORT_ORDER', 'true', 'Enable/Disable the products sort order modify', ".$group_id.", '12', NULL, NOW(), NULL, 'zen_cfg_select_option(array(\"true\", \"false\"),'), (NULL, 'Use popup edit.', 'QUICKUPDATES_MODIFY_DESCRIPTION_POPUP', 'true', 'Enable/Disable using popup edit link to description editing', ".$group_id.", '13', NULL, NOW(), NULL, 'zen_cfg_select_option(array(\"true\", \"false\"),') "); } elseif (substr($project,0,3) == "1.5") { $db->Execute("INSERT INTO ".TABLE_CONFIGURATION_GROUP." (configuration_group_id, configuration_group_title, configuration_group_description , sort_order, visible) VALUES ('Quick Updates', 'Quick Updates Configuration', '1', '1')"); $group_id = $db->Insert_ID(); $db->Execute("UPDATE ".TABLE_CONFIGURATION_GROUP." SET sort_order = ".$group_id." WHERE configuration_group_id = ".$group_id); zen_register_admin_page('quick_updates_config', 'BOX_CATALOG_QUICK_UPDATES','FILENAME_CONFIGURATION', 'gID='.$group_id, 'configuration', 'Y', 103); $db->Execute("INSERT INTO ".TABLE_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', ".$group_id.", '1', NULL, NOW(), NULL, 'zen_cfg_select_option(array(\"true\", \"false\"),'), (NULL, 'Display the thumbnail.', 'QUICKUPDATES_DISPLAY_THUMBNAIL', 'true', 'Enable/Disable the products thumbnail displaying', ".$group_id.", '2', NULL, NOW(), NULL, 'zen_cfg_select_option(array(\"true\", \"false\"),'), (NULL, 'Modify the model.', 'QUICKUPDATES_MODIFY_MODEL', 'true', 'Enable/Disable the products model displaying and modification', ".$group_id.", '3', NULL, NOW(), NULL, 'zen_cfg_select_option(array(\"true\", \"false\"),'), (NULL, 'Modify the name.', 'QUICKUPDATES_MODIFY_NAME', 'true', 'Enable/Disable the products name editing', ".$group_id.", '4', NULL, NOW(), NULL, 'zen_cfg_select_option(array(\"true\", \"false\"),'), (NULL, 'Modify the Description.', 'QUICKUPDATES_MODIFY_DESCRIPTION', 'true', 'Enable/Disable the displaying and modification of products description', ".$group_id.", '5', NULL, NOW(), NULL, 'zen_cfg_select_option(array(\"true\", \"false\"),'), (NULL, 'Modify the status of the products.', 'QUICKUPDATES_MODIFY_STATUS', 'true', 'Allow/Disallow the Status displaying and modification', ".$group_id.", '6', NULL, NOW(), NULL, 'zen_cfg_select_option(array(\"true\", \"false\"),'), (NULL, 'Modify the weight of the products.', 'QUICKUPDATES_MODIFY_WEIGHT', 'true', 'Allow/Disallow the Weight displaying and modification?', ".$group_id.", '7', NULL, NOW(), NULL, 'zen_cfg_select_option(array(\"true\", \"false\"),'), (NULL, 'Modify the quantity of the products.', 'QUICKUPDATES_MODIFY_QUANTITY', 'true', 'Allow/Disallow the quantity displaying and modification', ".$group_id.", '8', NULL, NOW(), NULL, 'zen_cfg_select_option(array(\"true\", \"false\"),'), (NULL, 'Modify the manufacturer of the products.', 'QUICKUPDATES_MODIFY_MANUFACTURER', 'false', 'Allow/Disallow the Manufacturer displaying and modification', ".$group_id.", '9', NULL, NOW(), NULL, 'zen_cfg_select_option(array(\"true\", \"false\"),'), (NULL, 'Modify the class of tax of the products.', 'QUICKUPDATES_MODIFY_TAX', 'false', 'Allow/Disallow the Class of tax displaying and modification', ".$group_id.", '10', NULL, NOW(), NULL, 'zen_cfg_select_option(array(\"true\", \"false\"),'), (NULL, 'Modify the category.', 'QUICKUPDATES_MODIFY_CATEGORY', 'true', 'Enable/Disable the products category modify', ".$group_id.", '11', NULL, NOW(), NULL, 'zen_cfg_select_option(array(\"true\", \"false\"),'), (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', ".$group_id.", '20', NULL, NOW(), NULL, 'zen_cfg_select_option(array(\"true\", \"false\"),'), (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 ', ".$group_id.", '30', NULL, NOW(), NULL, 'zen_cfg_select_option(array(\"true\", \"false\"),'), (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', ".$group_id.", '31', NULL, NOW(), NULL, 'zen_cfg_select_option(array(\"true\", \"false\"),'), (NULL, 'Activate or desactivate the commercial margin.', 'QUICKUPDATES_ACTIVATE_COMMERCIAL_MARGIN', 'true', 'Do you want that the commercial margin be activate or not ?',".$group_id.", '40', NULL, NOW(), NULL, 'zen_cfg_select_option(array(\"true\", \"false\"),'), (NULL, 'Modify the sort order.', 'QUICKUPDATES_MODIFY_SORT_ORDER', 'true', 'Enable/Disable the products sort order modify', ".$group_id.", '12', NULL, NOW(), NULL, 'zen_cfg_select_option(array(\"true\", \"false\"),'), (NULL, 'Use popup edit.', 'QUICKUPDATES_MODIFY_DESCRIPTION_POPUP', 'true', 'Enable/Disable using popup edit link to description editing', ".$group_id.", '13', NULL, NOW(), NULL, 'zen_cfg_select_option(array(\"true\", \"false\"),') "); } else { // unsupported version // i should do something here! } }

1 Attachment(s)

Re: Missing picture? Logo?

can't get this to install.. i'm using zen 1.5.5a and when i click on 'install' in the admin i get the error 'WARNING: An Error occurred, please refresh the page and try again.'. please see screen shot for my admin of 'quick updates'..Attachment 16613

Re: Missing picture? Logo?

Quote:

Originally Posted by lidlchris

can't get this to install.. i'm using zen 1.5.5a and when i click on 'install' in the admin i get the error 'WARNING: An Error occurred, please refresh the page and try again.'. please see screen shot for my admin of 'quick updates'..Attachment 16613

Check your error logs for details on what the error actually is.

Re: Missing picture? Logo?

Quote:

Originally Posted by jeking

Check your error logs for details on what the error actually is.

here is what i see:

[26-Aug-2016 11:58:57 America/Chicago] PHP Fatal error: 1136:Column count doesn't match value count at row 1 :: INSERT INTO configuration_group (configuration_group_id, configuration_group_title, configuration_group_description , sort_order, visible) VALUES ('Quick Updates', 'Quick Updates Configuration', '1', '1') ==> (as called by) /home4/csicatalog/public_html/MYADMIN/includes/functions/extra_functions/quick_updates_functions.php on line 39 <== in /home4/csicatalog/public_html/includes/classes/db/mysql/query_factory.php on line 167

Re: Missing picture? Logo?

fixed it.. there was a bug in /quick/updates/functions.php..

line 39 was:
$db->Execute("INSERT INTO ".TABLE_CONFIGURATION_GROUP." (configuration_group_id, configuration_group_title, configuration_group_description , sort_order, visible) VALUES ('Quick Updates', 'Quick Updates Configuration', '1', '1')");

and i changed it to
$db->Execute("INSERT INTO ".TABLE_CONFIGURATION_GROUP." (configuration_group_id, configuration_group_title, configuration_group_description , sort_order, visible) VALUES ('43','Quick Updates', 'Quick Updates Configuration', '1', '1')"); the '43' for configuration_group_id was the next number available in that table.

Re: Quick Updates - Support Thread

Installed this plugin and all is working, except it doubles my sales tax rate and I can not figure out how to stop that.
Any suggestions?

Re: Quick Updates - Support Thread

Anyone!!!!

Re: Quick Updates - Support Thread

Hi

Works perfectly on 1.5.5b - one question though, how can we adjust it to not show product description - the descriptions on our site are quite long and won't need changing via Quick Updates. Having description showing on Quick Updates means scrolling across the screen to get to the other fields.

Many thanks

Mark

Re: Missing picture? Logo?

Quote:

Originally Posted by lidlchris

fixed it.. there was a bug in /quick/updates/functions.php..

line 39 was:
$db->Execute("INSERT INTO ".TABLE_CONFIGURATION_GROUP." (configuration_group_id, configuration_group_title, configuration_group_description , sort_order, visible) VALUES ('Quick Updates', 'Quick Updates Configuration', '1', '1')");

and i changed it to
$db->Execute("INSERT INTO ".TABLE_CONFIGURATION_GROUP." (configuration_group_id, configuration_group_title, configuration_group_description , sort_order, visible) VALUES ('43','Quick Updates', 'Quick Updates Configuration', '1', '1')"); the '43' for configuration_group_id was the next number available in that table.

thanks this helped, also on 1.55a i had to change to

PHP Code:

$db->Execute("INSERT INTO ".TABLE_CONFIGURATION_GROUP." (configuration_group_id, configuration_group_title, configuration_group_description , sort_order, visible) VALUES ('','Quick Updates', 'Quick Updates Configuration', '1', '1')");

i think this just uses the next configuration_group_id rather than needing to know

move categories section

Hi... got to say what a time saving addon.. thanks for the hard work.. downloaded "newest" from the zen addons page, I'm using ZC1.5.4 got the warning page after install like most..LOL... changed the quick_updates_functions.php like the tread suggests and all went well... playing with around 40 main categories and 100 sub cat with 3300 products, between this and easy populate4 made redoing my store a breeze after a hard drive crash... boohoo

anyway my question is... is there a way to compress or remove the "description" section (cuz I have some LONG descriptions).. OR move the "categories" section to just after the "name" section in the layout, so I don't have to bouncing from one end to the other to change categories for a product???... cuz I'm getting dizzy... hahaha

Again THANKS for the great addon
hivtop

Re: move categories section

You can enable or disable columns in the configuration menu - admin>configuration>quick updates.

Re: move categories section

cool, now you're just teasing me with more goodies the addon can do.... since it worked "out of the box" (with one little fix) I was so busy changing cats never even looked at config drop down... my bad...

hivtop

If it isn't fun... Don't do it! Remember... The mind is like a parachute. It works only when open.

Re: Missing picture? Logo?

Quote:

Originally Posted by lidlchris

fixed it.. there was a bug in /quick/updates/functions.php..

line 39 was:
$db->Execute("INSERT INTO ".TABLE_CONFIGURATION_GROUP." (configuration_group_id, configuration_group_title, configuration_group_description , sort_order, visible) VALUES ('Quick Updates', 'Quick Updates Configuration', '1', '1')");

and i changed it to
$db->Execute("INSERT INTO ".TABLE_CONFIGURATION_GROUP." (configuration_group_id, configuration_group_title, configuration_group_description , sort_order, visible) VALUES ('43','Quick Updates', 'Quick Updates Configuration', '1', '1')"); the '43' for configuration_group_id was the next number available in that table.

This got me up and running on 1.5.5f. thanks!

Re: Missing picture? Logo?

In admin/quick_updates.php you should change

if(QUICKUPDATES_MODIFY_NEW_COLUMN_1 == 'true')
echo zen_quickupdates_table_head('p.' . QUICKUPDATES_MODIFY_NEW_COLUMN_1, TABLE_HEADING_NEW_COLUMN_1);

to

if(QUICKUPDATES_MODIFY_NEW_COLUMN_1 == 'true')
echo zen_quickupdates_table_head('p.' . QUICKUPDATES_NEW_COLUMN_1, TABLE_HEADING_NEW_COLUMN_1);

if you want to add another column.

This modification has been submitted to the plugins area.

1 Attachment(s)

Product description with link inside

Zen Cart 1.5.5e
I found the problem with products description, while there is link inside. Part of the description is visible on main page - please have a look at the screen attachedAttachment 17849.
Meksicus

Length of description

It will be usefull to display actual length of description and be able to sort listing by this field.
It will help to find products with short description (it has a big impact on SEO) and correct it quickly.

Re: Length of description

Just installed this and it looks like it will be a really great addition. But when I try to access it displays the message at the top of the administration page
Quick Updates Configuration Keys Not installed. Please install your configuration by clicking Install
When try clicking the link I am getting an error of message WARNING: An Error occurred, please refresh the page and try again. Refreshing page does solve it.

Re: Length of description

Look in your log files, there should be an error log in there with some info about what's going on. Post it here, but xxxx out the name of your admin folder for security

Re: Length of description

Code:

[07-Sep-2018 04:28:19 UTC] PHP Fatal error: Uncaught Error: Call to undefined function ereg() in /home/........../public_html/store/admin folder/quick_updates.php:412 Stack trace: #0 {main} thrown in /home/............../public_html/store/admin folder/quick_updates.php on line 412

Any clue what is going on...

Re: Length of description

Yep, your store is running a PHP version 7.0.0 or later ... in which the ereg function (deprecated in 5.3.0) was fully removed. The referenced line in quick_updates.php should be changed to use the PHP preg_match function instead.

See this link for additional information: https://docstore.mik.ua/orelly/webpr...ok/ch13_02.htm

Re: Length of description

It would appear you are using an older version of this plugin. Try upgrading to the current version and that error should go away.

Re: move categories section

Quote:

Originally Posted by lankeeyankee

You can enable or disable columns in the configuration menu - admin>configuration>quick updates.

This section seems to be missing from my config menu.... but I am able to use the quick updates fine... now sure how to proceed...

Re: Quick Updates 1.3 ?

I started experiencing a strange error recently and could not find any threads dealing with this.

I have been using ZenCart for many years, currently on ver 1.5.5e. Also, have been using QuickUpdates for many years now...

When I try to update any product in only SOME of the categories, I get the 'Forbidden You don't have permission to access /'Path'/'AdminFolder'/quick_updates.php on this server' error. All products in other categories work fine.

I can, however, update these products using the Admin - Catalog - Categories/Products route.

Anybody have any ideas of what could be triggering this behaviour?

Re: Quick Updates 1.3 ?

Not sure if anybody else gets this, when editing descriptions and updating, it shows all the html tags and similar on live page for that item. I have been told that the module is over sanitising the output. I am not getting the same issue when creating an item, and only noticed this issue since updating zencart to one of the new versions in the past year (it has updated sanitise file too).

Re: Quick Updates 1.3 ?

Quote:

Originally Posted by HeathenMagic

Not sure if anybody else gets this, when editing descriptions and updating, it shows all the html tags and similar on live page for that item. I have been told that the module is over sanitising the output. I am not getting the same issue when creating an item, and only noticed this issue since updating zencart to one of the new versions in the past year (it has updated sanitise file too).

I was able to also see this over sanitization in the product description and product name fields where characters such as &, <, >, etc... were converted into their html entities of &, <, >, etc...

In applying the fileset to a nearly ZC 1.5.7 setup with php 7.3 and reporting all errors I believe I have a method that will apply the desired sanitization allowing continued use and I've also updated the code to work in that php environment (and backwards compatible to php 5.x). I somewhat plan to submit the update though I otherwise haven't used the application so do not know of any other issues that need addressing nor have significant knowledge of it. I may also post the software to github. Details when available will be posted here, though I don't know how much other support I'll be able to provide.

Re: Quick Updates 1.3 ?

Thanks for your reply and possibility of an update. I did think of reverting to an older version of sanitise.php but I expect security would be compromised in some way, it must have been updated to curb hacks or something. Just a bit stringent but I understand the modules have to change to keep up to new standards.

Re: Quick Updates 1.3 ?

How can I insert product search on this page so that an item can be search and updated on this page.

Re: Quick Updates 1.3 ?

Using the Display Category and then sort by, say, ID doesn't get you there like you want?

Re: Quick Updates 1.3 ?

Quote:

Originally Posted by dbltoe

Using the Display Category and then sort by, say, ID doesn't get you there like you want?

Not sure how to do that can you please share code so I can try. Each category has lot of products so by selecting category and then looking for specific product in that category manually is very time consuming. Looking to insert a search box on this page where an item can be search using name/model and then update that item quickly.

Re: Quick Updates 1.3 ?

The Categories / Products page uses this code for selecting any ID, Model #, etc. I suppose it could be added into the display page for Quick Updates. Maybe someone more familiar with the php can tell us how.

Code:

<div class="col-md-4"> <?php echo zen_draw_form('set_editor_form', FILENAME_CATEGORY_PRODUCT_LISTING, '', 'get', 'class="form-horizontal"'); ?> <div class="form-group"> <?php echo zen_draw_label(TEXT_EDITOR_INFO, 'reset_editor', 'class="col-sm-6 col-md-4 control-label"'); ?> <div class="col-sm-6 col-md-8"> <?php echo zen_draw_pull_down_menu('reset_editor', $editors_pulldown, $current_editor_key, 'onchange="this.form.submit();" class="form-control" id="reset_editor"'); ?> </div> <?php echo zen_hide_session_id(); echo zen_draw_hidden_field('cID', $cPath); echo zen_draw_hidden_field('cPath', $cPath); echo (isset($_GET['pID']) ? zen_draw_hidden_field('pID', $_GET['pID']) : ''); echo (isset($_GET['page']) ? zen_draw_hidden_field('page', $_GET['page']) : ''); echo zen_draw_hidden_field('action', 'set_editor'); ?> </div> <?php echo '</form>'; ?> <?php // check for which buttons to show for categories and products $check_categories = zen_has_category_subcategories($current_category_id); $check_products = zen_products_in_category_count($current_category_id, true, false, 1); $zc_skip_products = false; $zc_skip_categories = false; if ($check_products == 0) { $zc_skip_products = false; $zc_skip_categories = false; } if ($check_categories == true) { $zc_skip_products = true; $zc_skip_categories = false; } if ($check_products > 0) { $zc_skip_products = false; $zc_skip_categories = true; } if (isset($_GET['search']) && !empty($_GET['search']) && $action != 'edit_category') { $zc_skip_products = false; } if ($zc_skip_products == true) { // toggle switch for display sort order $categories_products_sort_order_array = array(array('id' => '0', 'text' => TEXT_SORT_CATEGORIES_SORT_ORDER_PRODUCTS_NAME), array('id' => '1', 'text' => TEXT_SORT_CATEGORIES_NAME) ); } else { // toggle switch for display sort order $categories_products_sort_order_array = array( array('id' => '0', 'text' => TEXT_SORT_PRODUCTS_SORT_ORDER_PRODUCTS_NAME), array('id' => '1', 'text' => TEXT_SORT_PRODUCTS_NAME), array('id' => '2', 'text' => TEXT_SORT_PRODUCTS_MODEL), array('id' => '3', 'text' => TEXT_SORT_PRODUCTS_QUANTITY), array('id' => '4', 'text' => TEXT_SORT_PRODUCTS_QUANTITY_DESC), array('id' => '5', 'text' => TEXT_SORT_PRODUCTS_PRICE), array('id' => '6', 'text' => TEXT_SORT_PRODUCTS_PRICE_DESC) ); } echo zen_draw_form('set_categories_products_sort_order_form', FILENAME_CATEGORY_PRODUCT_LISTING, '', 'get', 'class="form-horizontal"'); ?> <div class="form-group"> <?php echo zen_draw_label(TEXT_CATEGORIES_PRODUCTS_SORT_ORDER_INFO, 'reset_categories_products_sort_order', 'class="col-sm-6 col-md-4 control-label"'); ?> <div class="col-sm-6 col-md-8"> <?php echo zen_draw_pull_down_menu('reset_categories_products_sort_order', $categories_products_sort_order_array, $reset_categories_products_sort_order, 'onchange="this.form.submit();" class="form-control" id="reset_categories_products_sort_order"'); ?> </div> <?php echo zen_hide_session_id(); echo zen_draw_hidden_field('cID', $cPath); echo zen_draw_hidden_field('cPath', $cPath); echo (isset($_GET['pID']) ? zen_draw_hidden_field('pID', $_GET['pID']) : ''); echo (isset($_GET['page']) ? zen_draw_hidden_field('page', $_GET['page']) : ''); echo (isset($_GET['search']) ? zen_draw_hidden_field('search', $_GET['search']) : ''); echo zen_draw_hidden_field('action', 'set_categories_products_sort_order'); ?> </div> <?php echo '</form>'; if (!isset($_GET['page'])) { $_GET['page'] = ''; } if (isset($_GET['set_display_categories_dropdown'])) { $_SESSION['display_categories_dropdown'] = $_GET['set_display_categories_dropdown']; } if (!isset($_SESSION['display_categories_dropdown'])) { $_SESSION['display_categories_dropdown'] = 0; } ?> </div>

Re: Quick Updates 1.3 ?

Quote:

Originally Posted by dbltoe

The Categories / Products page uses this code for selecting any ID, Model #, etc. I suppose it could be added into the display page for Quick Updates. Maybe someone more familiar with the php can tell us how.

Code:

<div class="col-md-4"> <?php echo zen_draw_form('set_editor_form', FILENAME_CATEGORY_PRODUCT_LISTING, '', 'get', 'class="form-horizontal"'); ?> <div class="form-group"> <?php echo zen_draw_label(TEXT_EDITOR_INFO, 'reset_editor', 'class="col-sm-6 col-md-4 control-label"'); ?> <div class="col-sm-6 col-md-8"> <?php echo zen_draw_pull_down_menu('reset_editor', $editors_pulldown, $current_editor_key, 'onchange="this.form.submit();" class="form-control" id="reset_editor"'); ?> </div> <?php echo zen_hide_session_id(); echo zen_draw_hidden_field('cID', $cPath); echo zen_draw_hidden_field('cPath', $cPath); echo (isset($_GET['pID']) ? zen_draw_hidden_field('pID', $_GET['pID']) : ''); echo (isset($_GET['page']) ? zen_draw_hidden_field('page', $_GET['page']) : ''); echo zen_draw_hidden_field('action', 'set_editor'); ?> </div> <?php echo '</form>'; ?> <?php // check for which buttons to show for categories and products $check_categories = zen_has_category_subcategories($current_category_id); $check_products = zen_products_in_category_count($current_category_id, true, false, 1); $zc_skip_products = false; $zc_skip_categories = false; if ($check_products == 0) { $zc_skip_products = false; $zc_skip_categories = false; } if ($check_categories == true) { $zc_skip_products = true; $zc_skip_categories = false; } if ($check_products > 0) { $zc_skip_products = false; $zc_skip_categories = true; } if (isset($_GET['search']) && !empty($_GET['search']) && $action != 'edit_category') { $zc_skip_products = false; } if ($zc_skip_products == true) { // toggle switch for display sort order $categories_products_sort_order_array = array(array('id' => '0', 'text' => TEXT_SORT_CATEGORIES_SORT_ORDER_PRODUCTS_NAME), array('id' => '1', 'text' => TEXT_SORT_CATEGORIES_NAME) ); } else { // toggle switch for display sort order $categories_products_sort_order_array = array( array('id' => '0', 'text' => TEXT_SORT_PRODUCTS_SORT_ORDER_PRODUCTS_NAME), array('id' => '1', 'text' => TEXT_SORT_PRODUCTS_NAME), array('id' => '2', 'text' => TEXT_SORT_PRODUCTS_MODEL), array('id' => '3', 'text' => TEXT_SORT_PRODUCTS_QUANTITY), array('id' => '4', 'text' => TEXT_SORT_PRODUCTS_QUANTITY_DESC), array('id' => '5', 'text' => TEXT_SORT_PRODUCTS_PRICE), array('id' => '6', 'text' => TEXT_SORT_PRODUCTS_PRICE_DESC) ); } echo zen_draw_form('set_categories_products_sort_order_form', FILENAME_CATEGORY_PRODUCT_LISTING, '', 'get', 'class="form-horizontal"'); ?> <div class="form-group"> <?php echo zen_draw_label(TEXT_CATEGORIES_PRODUCTS_SORT_ORDER_INFO, 'reset_categories_products_sort_order', 'class="col-sm-6 col-md-4 control-label"'); ?> <div class="col-sm-6 col-md-8"> <?php echo zen_draw_pull_down_menu('reset_categories_products_sort_order', $categories_products_sort_order_array, $reset_categories_products_sort_order, 'onchange="this.form.submit();" class="form-control" id="reset_categories_products_sort_order"'); ?> </div> <?php echo zen_hide_session_id(); echo zen_draw_hidden_field('cID', $cPath); echo zen_draw_hidden_field('cPath', $cPath); echo (isset($_GET['pID']) ? zen_draw_hidden_field('pID', $_GET['pID']) : ''); echo (isset($_GET['page']) ? zen_draw_hidden_field('page', $_GET['page']) : ''); echo (isset($_GET['search']) ? zen_draw_hidden_field('search', $_GET['search']) : ''); echo zen_draw_hidden_field('action', 'set_categories_products_sort_order'); ?> </div> <?php echo '</form>'; if (!isset($_GET['page'])) { $_GET['page'] = ''; } if (isset($_GET['set_display_categories_dropdown'])) { $_SESSION['display_categories_dropdown'] = $_GET['set_display_categories_dropdown']; } if (!isset($_SESSION['display_categories_dropdown'])) { $_SESSION['display_categories_dropdown'] = 0; } ?> </div>

Thank you but I tried this code earlier and search worked but when search is perform it shows results on categories page instead of quick updates page where can not update item quickly like on quick update page.

I see earlier in this thread few people mentioned about search via UPC but their provided links (years ago) are not valid nor they have provided codes / solution in this forum. I messaged them but have not heard back. Any one know how to accomplish this?

Re: Quick Updates 1.3 ?

Quote:

Originally Posted by jsarwar

Thank you but I tried this code earlier and search worked but when search is perform it shows results on categories page instead of quick updates page where can not update item quickly like on quick update page.

I see earlier in this thread few people mentioned about search via UPC but their provided links (years ago) are not valid nor they have provided codes / solution in this forum. I messaged them but have not heard back. Any one know how to accomplish this?

what would you like to accomplish with UPCs? are they already in your database? or do you need them to get into the db and then be able to search by them afterwards?

best.

Re: Quick Updates 1.3 ?

Looking to insert a search box on this page (quick update) where an item can be search using name/model/UPC and then update that item quickly on this page. Item name, model, upc are already in database just need search box on this item to search an item and update quickly.

Re: Quick Updates 1.3 ?

Quote:

Originally Posted by carlwhat

what would you like to accomplish with UPCs? are they already in your database? or do you need them to get into the db and then be able to search by them afterwards?

best.

Any update on this?

Re: Quick Updates 1.3 ?

Quote:

Originally Posted by jsarwar

Any update on this?

yes. i did look at it (i have never used this module before); but not something to which i can currently devote my time.

if i were to go about it, i would utilize the soon to be merged (one hopes) search box code for v158:

https://github.com/zencart/zencart/pull/3948

and then utilize the new function in v158 called zen_build_keyword_where_clause:

https://github.com/zencart/zencart/b...ons_search.php

so you would add 2 new separate files into your install, check that they get loaded, then add the search box in the quick updates code; and then take the post variables from that to modify the sql where statement.

piece of steak! (unless u r a vegetarian....)

best.

Re: Quick Updates 1.3 ?

Quote:

Originally Posted by carlwhat

if i were to go about it, i would utilize the soon to be merged (one hopes) search box code for v158:

https://github.com/zencart/zencart/pull/3948

and then utilize the new function in v158 called zen_build_keyword_where_clause:

https://github.com/zencart/zencart/b...ons_search.php

Hmmm ... be careful when toying with unreleased code from newer versions when updating code on older versions. Sometimes things get moved around and have incompatibilities when used out of context. And remember that the unreleased code from newer versions may change many times before being finally released and therefore won't be an exact match when attempting to apply the upgrade. Use with caution.

Re: Quick Updates 1.3 ?

Quote:

Originally Posted by carlwhat

yes. i did look at it (i have never used this module before); but not something to which i can currently devote my time.

if i were to go about it, i would utilize the soon to be merged (one hopes) search box code for v158:

https://github.com/zencart/zencart/pull/3948

and then utilize the new function in v158 called zen_build_keyword_where_clause:

https://github.com/zencart/zencart/b...ons_search.php

so you would add 2 new separate files into your install, check that they get loaded, then add the search box in the quick updates code; and then take the post variables from that to modify the sql where statement.

piece of steak! (unless u r a vegetarian....)

best.

It did not work for 1.5.3. I uploaded files you mentioned on links above. If any one know the solution please let me know.

Re: Quick Updates 1.3 ?

Quote:

Originally Posted by jsarwar

It did not work for 1.5.3. I uploaded files you mentioned on links above. If any one know the solution please let me know.

Not a surprise at all. Four major releases since then and MANY versions of PHP.

It's really time to update. Six years is a long time in softwareville.

Re: Quick Updates 1.3 ?

Zencart 1.5.7d PHP 7.4
Can anyone help with this php warning:
PHP Warning: sizeof(): Parameter must be an array or an object that implements Countable in /admin/quick_updates.php on line 202.
line 202 is if(sizeof($_POST['quick_updates_new']) > 0){

// bof prepare al new data for database input
if(sizeof($_POST['quick_updates_new']) > 0){
foreach($_POST['quick_updates_new'] as $key => $value){
// $value is an array here (contains values like ['products_model'][$products_id] = '1' for example)
$_POST['quick_updates_new'][$key] = zen_db_prepare_input($value);
}
}
// eof prepare al new data for database input

Thanks

Re: Quick Updates 1.3 ?

Hello. Does anyone have experience with the interaction of the plugin Quick Updates and Group Pricing (per Item)?
Because each module works with different prices. But it would be great if you could quickly adjust the group prices via quick updates.

Re: Quick Updates v2.07

Hi All,

I am running a test version of 1.58a of zencart with all the latest versions of php etc

My question is that I have added fields are displayed in version 1.5.5e (so I can edit using quick updates) and are wanting to do the same with version 1.5.8a.

I need to know what file would have all the information in it please.

Any help is appreciated.

Re: Quick Updates v2.07

Hi All,

I am running a test version of 1.58a of zencart with all the latest versions of php etc

My question is that I have added fields are displayed in version 1.5.5e (so I can edit using quick updates) and are wanting to do the same with version 1.5.8a.

I need to know what file would have all the information in it please.

Any help is appreciated.

Re: Quick Updates 1.3 ?

https://www.zen-cart.com/downloads.php?do=file&id=26

Not running with php 8 and above

in admin /quick_updates.php
says error in line 45 :
$currencies->currencies[DEFAULT_CURRENCY]['decimal_places'] = 4;

and in line 425:
$rows = $split_page * MAX_DISPLAY_ROW_BY_PAGE - MAX_DISPLAY_ROW_BY_PAGE;

Re: Quick Updates 1.3 ?

You could try using this plug-in https://www.zen-cart.com/downloads.php?do=file&id=2358 not as comprehensive but might work with php 8 and above

Re: Quick Updates v2.06

Hi All,

I am using Quick Updates on a linux Server with version 1.58a, php 8.1, Numinix Product Fields and EP$ and I am having the following issue.

QUICK UPDATES
7 Product(s) Updated!
extra_field, product_id(s): 49357, 49356, 49355, 49354, 49353, 49352, 49351

1. Showing that the field has been updated but it is not showing when it goes back to the item list

2. When I go to the product itself (admin Categories / Products) the stock location is not showing the location either.

3. If I change the Stock location (numinix product field) in the product, it does not show in the product when I preview and then press update.

4. It does not appear to be recording in the database even though it is saying that it has been updated.

5. I have other numinix product fields like Condition, Waranty, Handling Fee, Additional Handling Fee (which are Working as they should)

6. Not working are the Stock Location (extra_field) and Suppliers in the product section but you are able to update in Quick Update no issue.

It apears that some fields are working and some are not so I am at a loss as to what I should do.

I am not real sure how to find an item number in the database so any assistance would be appreciated

Re: Quick Updates 1.3 ?

Quote:

Originally Posted by carlwhat

yes. i did look at it (i have never used this module before); but not something to which i can currently devote my time.

if i were to go about it, i would utilize the soon to be merged (one hopes) search box code for v158:

https://github.com/zencart/zencart/pull/3948

and then utilize the new function in v158 called zen_build_keyword_where_clause:

https://github.com/zencart/zencart/b...ons_search.php

so you would add 2 new separate files into your install, check that they get loaded, then add the search box in the quick updates code; and then take the post variables from that to modify the sql where statement.

piece of steak! (unless u r a vegetarian....)

best.

Running 1.5.8a add following code to quick update page

HTML Code:

<div class="col-sm-offset-8 col-sm-4">``` <?php include DIR_WS_MODULES . 'search_box.php'; ?> </div>

other two mentioned files are already included in this ZC version but when search is performed it does not do anything.
How to include search box on this page to quickly search for a product to update it?