Quick Updates plugin [support]

[mafiasam]

Changes report:
(Quote from the version history file)

edit:
quickly copy one or more products as new products, and one click repeated copy

should be:
quickly copy one product as one or more new products, and one click repeated copy

sweet! I will be testing for you.
thanks so much this is amazing.
mafiasam

p.s. - let me know when you want that cup of coffee

[paulm]

I have sent you a pm mafiasam :-)

Note about the 16th November release:
the issues with main_categories_id v.s. categories_id, and multilinked products, are *not* solved yet. Which is not really unexpected BTW. I do have some ideas to really fix it, and I expect to update this part soon (but probably not before my headache stops!).

Other than that it seems to work well on my live shop. I just updated 100+ stock values in a *very* short amount of time

[paulm]

main_categories_id

? I meant master_categories_id of course....

[ghgarcia]

Noticed that on line 472 of quick_updates.php you are still using fixed colors. A change here to use CSS would be great if you have the time.

Again thanks for a wonderful module.

[paulm]

Noticed that on line 472 of quick_updates.php you are still using fixed colors.

That sounds like I coded it that way, which I didn't (just to be clear). I just did not get to throwing out all the depricated html stuff yet (if ever), trying to focus on functionality first.

[ghgarcia]

That sounds like I coded it that way, which I didn't (just to be clear). I just did not get to throwing out all the deprecated html stuff yet (if ever), trying to focus on functionality first.

You are quite correct functionality, operation and testing is primary to development. Presentation can be done later.

Again appreciate the effort,

[paulm]

I think I have really fixed the master_categories_id problems now. It at least works a lot better now than with any previous version. It now also allows to quickly fix multiple invalid linked categories (and if you don't know what an invalid category is, try a search on these forums for "+invalid +master_categories_id" ;-)).

Probably I will upload after this weekend (and probably I will fix the hardcoded color issues before upload). Or maybe sooner, if all tests run well and time permits...

[paulm]

Noticed that on line 472 of quick_updates.php you are still using fixed colors.

Sorry, but I thought there where still many instances of fixed colors (and such), but now I noticed that was the only fixed color left (and so I removed it :-) + some other depricated html stuff ).

Now only the CSS should actually be totally revamped, inluding the class and id names themselves (the ones I added myself don't make much sense either ). But on the other I think it does not matter much in this case, so I will leave it as it is for now (maybe someone else feels like doing it ? ;-) ).


New version:

Quote from version-history.txt

v-november-19th-2006 by Paul Mathot
1) New fix for categories issues. Added quick master_categories_id updates.
2) Several small fixes
3) Saves page number (in some cases)
4) Added links to products_to_categories.php manager
(to update overwrite your old files, no changes to the sql since previous version)

[craftzombie]

Attached new version to this post. It includes the wholesales price column (as said untested!), and default it's switched off. To enable it edit admin\includes\extra_configures\quick_updates.php and change:

define('QUICKUPDATES_MODIFY_WHOLESALE_PRICE', 'false');

to

define('QUICKUPDATES_MODIFY_WHOLESALE_PRICE', 'true');

Don't forget to backup your database, and try this version on a testshop first. Feedback welcome!!

Advised browser: Firefox (IE will work, but has some issues with css :hover features)

I tested the copy feature and it works great! Thanks! Now for the wholesale price feature, I changed it to "true", but when I click on Quick Updates in the admin, I get this:

1054 Unknown column 'p.product_price_w' in 'field list'
in:
[select DISTINCT p.products_id, p.products_type, p.products_image, p.product_price_w, p.products_model, pd.products_name, p.products_status, 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 products p LEFT JOIN products_description pd ON (p.products_id = pd.products_id and pd.language_id = '1') LEFT JOIN manufacturers m ON (p.manufacturers_id = m.manufacturers_id) LEFT JOIN products_to_categories p2c ON (p.products_id = p2c.products_id) where p2c.categories_id = '127' order by p.products_id DESC limit 0, 25]
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.

I wish I could help!

[paulm]

1054 Unknown column 'p.product_price_w' in 'field list'

It shows the column does not exist in your products table. Did you install a wholesale price contribution?

I am not using any myself, but the one I found adds a column products_price_w to the products table.
Wholesale contribution:
http://www.zen-cart.com/index.php?ma...roducts_id=166

But maybe other modules exist that use other column names?