Quick Updates plugin [support]

[numinix]

If you are going to use v2.03b, you need to also ALTER TABLE to add the correct ePier fields to the products. If you aren't using ePier, do not use version "b", instead, use "a" or just 2.03. In fact 2.03b does not provide UPC/ISBN support and is therefore not an upgrade to 2.03a.

Also, as stated in the post directly above you, by removing the # on the correct line in the installation SQL, you can install the ePier field and avoid SQL errors. From our conversation in the UPC/ISBN thread, you should be using 2.03a.

[numinix]

It would be great if you can please provide this contribution without support/integration with epier. The assumption that every user of Quick Updates wants epier is faulty.

Thanks!

There is no assumption. V2.03b is only available from my website and not available from the downloads section. It was created solely for the purpose of supporting the ePier Generator.

However, v2.03a is available both on my website and in the downloads section and SQL errors will occur if not using those fields. Therefore, it is recommended that users run the ALTER TABLE lines regardless of whether or not they are going to input information into those fields or revert back to v2.03 which has the same functionality but without UPC/ISBN support.

[BlessIsaacola]

There is no assumption. V2.03b is only available from my website and not available from the downloads section. It was created solely for the purpose of supporting the ePier Generator.

However, v2.03a is available both on my website and in the downloads section and SQL errors will occur if not using those fields. Therefore, it is recommended that users run the ALTER TABLE lines regardless of whether or not they are going to input information into those fields or revert back to v2.03 which has the same functionality but without UPC/ISBN support.

Ah, believe it or not, some of us actually frequent your site for your mods more than the download section. Simply for the fact that updates are available sooner on your site before it becomes available on ZC download section.

To avoid confusion you might want to put a disclaimer in the readme file or on your site that v2.03b is ONLY for users of ePier. I will downgrade accordingly.

Thanks!

[numinix]

I'll look into it when I have time. There is no SQl errors as long as the user runs the ALTER TABLE lines which are commented out by default. It will work just the same as the original 2.03 but with an additional ePier field which the user can ignore.

I'm currently working on an eBay CSV creator that is taking up all of my time.

[redmonds]

I have installed QU 2.03a on to ZC 1.3.7.1.

I had some problems as I had not yet installed the UPC/ISBN mod. Prior to installing the UPC/ISBN mod I was getting an error when access the QuickUpdates page but from memory the QuickUpdates configuration menu was working.

I have now installed the UPC/ISBN mod and the QuickUpdates page is working but I can not get the configuration page up. The Configuration menu is there but when I click on it I get Quick Updates page with now options. The page displays and is formated and even has the table headings but no options.

I have tried rerunning, deleting and rerunning the SQL entries. I even tried re-uploading all the files although even wiht my very basic knowledge I was pretty sure it is an SQL problem.

Would appreciate any help you can give. Thanks

[numinix]

Run this to uninstall the SQL:

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; 

Then cut and paste this in to install:

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', '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''),'); 

If that doesn't work for you then it's something external to this module. Furthermore, my update is very minor and only adds the UPC and ISBN.

[numinix]

btw, there is an error in the SQL. I accidentally entered the UPC/ISBN twice. This can be fixed by deleting the last two lines in the SQL and ending the new last line with a semi-colon ;

I've already dealt with this issue previously if you had just read the posts since the release of 2.03a. I will no longer provide support for this issue. I will release a patch when I have the chance.

[redmonds]

Thanks numinix. I managed to get it working although I am still not sure what I did. Just repeat and test. ok.

Never look a gift horse in the mouth;-)

[kimsonvu]

After update to new version, i see this problem:

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.epier, 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 handicraproducts p LEFT JOIN handicraproducts_description pd ON (p.products_id = pd.products_id and pd.language_id = '1') LEFT JOIN handicramanufacturers m ON (p.manufacturers_id = m.manufacturers_id) LEFT JOIN handicraproducts_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.

Anyone know how to fix?

[chadderuski]

Hi All,

currently using: v2.03

Has anyone tried to add the "Product Qty Minimum" and "Product Qty Units" to Quick Updates? Would be very useful for those of use that price by EA but sell in cases.

I looked in the .php code, but it isn't a "simple" fix - lol.

need to add:
products_quantity_order_min and products_quantity_order_units


any suggestions on how to start, or anyone else has done this mod would really be appreciated.

Thanks!

-cj