Zen Cart Logo
Forums / Addon Admin Tools / Quick Updates plugin [support]

Quick Updates plugin [support]

Views: 180,419

Results 281 to 300 of 670
24 Jun 2007, 6:14 PM
#281
craftzombie avatar

craftzombie

Zen Follower

Join Date:
Jul 2006
Posts:
494
Plugin Contributions:
0

Quick Updates plugin [support]

gcampos:

I installed QU, very nice!

Upon looking at it in Admin, I see on some products the following"

Invalid master!(4/0)

What does this mean, and how can i fix it.

Thanks,

Gerry

This happened to me when I moved products from one category to another in admin>catalog>categories/products. Sometimes in QU it shows "invalid master" after I do that. To fix it, I just selected the correct category from the dropdown menu in QU and clicked on update.

26 Jun 2007, 5:43 AM
#282
sadie avatar

sadie

Zen Follower

Join Date:
Aug 2004
Posts:
252
Plugin Contributions:
0

Re: Quick Updates plugin [support]

Installed quick updates. In the admin, confirguration page, the Quick Updates info is there. But when I go to the products page to change a price, etc. everything is the same. On what page should I see the quick updates file to update an entire category at once.

26 Jun 2007, 5:50 AM
#283
craftzombie avatar

craftzombie

Zen Follower

Join Date:
Jul 2006
Posts:
494
Plugin Contributions:
0

Re: Quick Updates plugin [support]

sadie:

Installed quick updates. In the admin, confirguration page, the Quick Updates info is there. But when I go to the products page to change a price, etc. everything is the same. On what page should I see the quick updates file to update an entire category at once.

Just to clarify... are you going to admin>catalog>quick updates ?

26 Jun 2007, 5:56 AM
#284
sadie avatar

sadie

Zen Follower

Join Date:
Aug 2004
Posts:
252
Plugin Contributions:
0

Re: Quick Updates plugin [support]

craftzombie:

Just to clarify... are you going to admin>catalog>quick updates ?

No, admin>configuration>quick updates.

There is no quick updates in admin catalog. I uploaded all of the files, and installed the sql patch. Is there something else I should have done?

26 Jun 2007, 6:04 AM
#285
craftzombie avatar

craftzombie

Zen Follower

Join Date:
Jul 2006
Posts:
494
Plugin Contributions:
0

Re: Quick Updates plugin [support]

sadie:

No, admin>configuration>quick updates.

There is no quick updates in admin catalog. I uploaded all of the files, and installed the sql patch. Is there something else I should have done?

admin>configuration>quick updates is where you make your changes to the products. if you don't have that in your admin, try uploading again because something is missing.

26 Jun 2007, 6:08 AM
#286
craftzombie avatar

craftzombie

Zen Follower

Join Date:
Jul 2006
Posts:
494
Plugin Contributions:
0

Re: Quick Updates plugin [support]

I think the file that makes QU appear in admin>catalog is admin\includes\boxes\extra_boxes\quick_update_catalog_dhtml.php, but don't quote me on that because I am no QU expert.

26 Jun 2007, 6:16 AM
#287
sadie avatar

sadie

Zen Follower

Join Date:
Aug 2004
Posts:
252
Plugin Contributions:
0

Re: Quick Updates plugin [support]

craftzombie:

admin>configuration>quick updates is where you make your changes to the products. if you don't have that in your admin, try uploading again because something is missing.

I am not sure what is going on, but, I think there should be a quick update listing in admin/calogue/ in addition to admin/configuration. I will probably remove all of these files, and try again tomorrow.

Thanks anyway

26 Jun 2007, 6:25 AM
#288
craftzombie avatar

craftzombie

Zen Follower

Join Date:
Jul 2006
Posts:
494
Plugin Contributions:
0

Re: Quick Updates plugin [support]

Definitely try again. It happens quite frequently (at least to me and also to several other people on this forum) that mod files either pretend to upload themselves or are uploaded to the wrong files by a sleepy, overworked zenner. Those files are sneakly little bastards sometimes.

26 Jun 2007, 7:23 AM
#289
sadie avatar

sadie

Zen Follower

Join Date:
Aug 2004
Posts:
252
Plugin Contributions:
0

Re: Quick Updates plugin [support]

craftzombie:

Definitely try again. It happens quite frequently (at least to me and also to several other people on this forum) that mod files either pretend to upload themselves or are uploaded to the wrong files by a sleepy, overworked zenner. Those files are sneakly little bastards sometimes.

It is working now. Not all of the files downloaded the first time. I guess I should not be working on this in the middle of the night.

5 Jul 2007, 7:16 PM
#290
lextechs avatar

lextechs

Zen Follower

Join Date:
Mar 2005
Location:
Tempe, AZ
Posts:
316
Plugin Contributions:
0

Re: Quick Updates plugin [support]

Hi,

I just installed Quick Updates 2.03. I have Profit Margin Calculator v1.12 by Farrukh installed what is needed to get Quick update to have that column added.

10 Jul 2007, 10:22 PM
#291
hipctech avatar

hipctech

Totally Zenned

Join Date:
Oct 2004
Location:
Surrey, BC, Canada
Posts:
1,466
Plugin Contributions:
1

Re: Quick Updates plugin [support]

Hello there,

I have found a bug in the QuickUpdates v 2.03.

If I have set the Description to false in the configuration and I go to the QuickUpdates page under Catalog the Description header column will still be there and the other boxes are messed up. So there are lets say 4 headers (including the Description) but only 3 columns underneath the headers because the Description one was turned off.

Thank you. God bless.

12 Jul 2007, 8:53 PM
#292
numinix avatar

numinix

Totally Zenned

Join Date:
Apr 2007
Location:
Vancouver, Canada
Posts:
1,566
Plugin Contributions:
58

Re: Quick Updates plugin [support]

Who is the current author of this script? Please PM me.

I have created a patch that adds UPC and ISBN to the products listing page for use with the Google Base Feeder. Without being able to easily update these new columns, it will be a tiresome task for users. Since UPC and ISBN are now required, this is something that has to happen.

16 Jul 2007, 5:12 AM
#293
numinix avatar

numinix

Totally Zenned

Join Date:
Apr 2007
Location:
Vancouver, Canada
Posts:
1,566
Plugin Contributions:
58

Re: Quick Updates plugin [support]

Quick Updates v2.03a

Added support for UPC/ISBN product fields.

The UPC/ISBN mod was created to allow Zen Cart merchants to add UPC/ISBN information to each product. This information can then be extracted from the database into a feed file with such mods as the Google Base Feeder. To make adding the UPC/ISBN information more efficient, I have updated the Quick Updates module to version 2.03a which does not attempt to fix any bug issues.

The new features are disabled by default as to not interfere with users who have not installed the UPC/ISBN mod. Therefore, if you are not going to be using UPC/ISBN, there is no difference between v2.03 and v2.03a.

16 Jul 2007, 5:20 AM
#294
numinix avatar

numinix

Totally Zenned

Join Date:
Apr 2007
Location:
Vancouver, Canada
Posts:
1,566
Plugin Contributions:
58

Re: Quick Updates plugin [support]

Correction: to use v2.03a, you need to install the UPC/ISBN mod whether or not you are going to use them or not.

Thus, if you are not going to use them, don't bother upgrading.

18 Jul 2007, 7:07 PM
#295
numinix avatar

numinix

Totally Zenned

Join Date:
Apr 2007
Location:
Vancouver, Canada
Posts:
1,566
Plugin Contributions:
58

Re: Quick Updates plugin [support]

If you already did upgrade and haven't already installed UPC/ISBN support, to avoid any SQL errors when trying to run quick updates, install these two SQL commands:

 
ALTER TABLE products ADD products_upc varchar(32) NULL default NULL after products_model; 
ALTER TABLE products ADD products_isbn varchar(32) NULL default NULL after products_upc;
26 Jul 2007, 11:44 PM
#296
turtledove avatar

turtledove

Zen Follower

Join Date:
May 2006
Posts:
182
Plugin Contributions:
0

Re: Quick Updates plugin [support]

I'm trying to upload the SQL patch, but keep getting this error

1062 Duplicate entry 'QUICKUPDATES_MODIFY_UPC' for key 2
in:
[INSERT INTO zen_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 UPC.', 'QUICKUPDATES_MODIFY_UPC', 'true', 'Enable/Disable the products UPC displaying and modification', @t4, 4, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),'), ('', 'Modify the ISBN.', 'QUICKUPDATES_MODIFY_ISBN', 'true', 'Enable/Disable the products ISBN displaying and modification', @t4, 5, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),'), ('', 'Modify the name.', 'QUICKUPDATES_MODIFY_NAME', 'true', 'Enable/Disable the products name editing', @t4, 6, 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, 7, 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, 8, 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, 9, 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, 10, 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, 11, 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, 12, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),'), ('', 'Modify the category.', 'QUICKUPDATES_MODIFY_CATEGORY', 'true', 'Enable/Disable the products category modify', @t4, 13, 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, 14, 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, 14, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),'), ('', 'Modify the UPC.', 'QUICKUPDATES_MODIFY_UPC', 'false', 'Enable/Disable the products UPC displaying and modification', @t4, 15, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),'), ('', 'Modify the ISBN.', 'QUICKUPDATES_MODIFY_ISBN', 'false', 'Enable/Disable the products ISBN displaying and modification', @t4, 16, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),');]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

The very first page has someone who had this same problem, and he found a solution to it, but I don't know what files he was referring to that fixed his problem. What should I do?

27 Jul 2007, 5:28 AM
#297
numinix avatar

numinix

Totally Zenned

Join Date:
Apr 2007
Location:
Vancouver, Canada
Posts:
1,566
Plugin Contributions:
58

Re: Quick Updates plugin [support]

Delete the last two lines of the SQL file and on the third to last line replace the comma , with a colon ;

# 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;

# if not already added, install UPC/ISBNsupport:
#
#ALTER TABLE products ADD products_upc varchar(32) NULL default NULL after products_model; 
#ALTER TABLE products ADD products_isbn varchar(32) NULL default NULL after products_upc;


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 UPC.', 'QUICKUPDATES_MODIFY_UPC', 'false', 'Enable/Disable the products UPC displaying and modification', @t4, 15, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),'),
('', 'Modify the ISBN.', 'QUICKUPDATES_MODIFY_ISBN', 'false', 'Enable/Disable the products ISBN displaying and modification', @t4, 15, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),'),
('', 'Modify the name.', 'QUICKUPDATES_MODIFY_NAME', 'true', 'Enable/Disable the products name editing', @t4, 6, 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, 7, 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, 8, 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, 9, 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, 10, 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, 11, 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, 12, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),'),
('', 'Modify the category.', 'QUICKUPDATES_MODIFY_CATEGORY', 'true', 'Enable/Disable the products category modify', @t4, 13, 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, 14, 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, 14, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),');
27 Jul 2007, 5:31 AM
#298
numinix avatar

numinix

Totally Zenned

Join Date:
Apr 2007
Location:
Vancouver, Canada
Posts:
1,566
Plugin Contributions:
58

Re: Quick Updates plugin [support]

If you haven't already installed the UPC/ISBN remove the # from the appropriate lines and copy and paste those individual lines to be added to your sql database.

27 Jul 2007, 4:49 PM
#299
turtledove avatar

turtledove

Zen Follower

Join Date:
May 2006
Posts:
182
Plugin Contributions:
0

Re: Quick Updates plugin [support]

When I upload the upgrade.sql, I get this error"

1062 Duplicate entry 'QUICKUPDATES_MODIFY_UPC' for key 2
in:
[INSERT INTO zen_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 ('', 'Modify the UPC.', 'QUICKUPDATES_MODIFY_UPC', 'false', 'Enable/Disable the products UPC displaying and modification', @t4, 15, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),'), ('', 'Modify the ISBN.', 'QUICKUPDATES_MODIFY_ISBN', 'false', 'Enable/Disable the products ISBN displaying and modification', @t4, 16, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),');]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

and, when I try access quick updates, i get this error:

1054 Unknown column 'p.products_upc' in 'field list'
in:
[select p.products_id, p.products_type, p.products_image, p.products_model, pd.products_name, p.products_status, p.products_upc, p.products_isbn, p.products_weight, p.products_quantity, p.manufacturers_id, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_quantity_order_min, p.products_quantity_order_units, p.products_priced_by_attribute, p.product_is_free, p.product_is_call, p.products_quantity_mixed, p.product_is_always_free_shipping, pd.products_description, p.products_quantity_order_max, p.products_sort_order, p.master_categories_id, m.manufacturers_name, p2c.categories_id from zen_products p LEFT JOIN zen_products_description pd ON (p.products_id = pd.products_id and pd.language_id = '1') LEFT JOIN zen_manufacturers m ON (p.manufacturers_id = m.manufacturers_id) LEFT JOIN zen_products_to_categories p2c ON (p.products_id = p2c.products_id) order by p.products_id DESC limit 0, 20]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

:shocking:

27 Jul 2007, 5:23 PM
#300
numinix avatar

numinix

Totally Zenned

Join Date:
Apr 2007
Location:
Vancouver, Canada
Posts:
1,566
Plugin Contributions:
58

Re: Quick Updates plugin [support]

I told you how to resolve both issues in my post.

For the second in particular you need to install the "ALTER TABLE" lines from the SQL buy copying and pasting those lines and removing the #.