Quick Updates plugin [support]

craftzombie:

One more thing though (as if you didn't have enough on your plate already) is that I can't get the page to move to the next page when using the drop-down menu on the bottom. A previous closed thread mentioned turning register globals on, which they are, so any thoughts?Better turn register globals off again, unless you have to have to on for other reasons. Off is better for security! (if the code is free of errors/flaws it should not make any difference, but .......)

I tried, and noticed the problem (caused by me I suppose, oops ), an easy fix is to change this (assuming you're using the latest version posted in this thread):

if(isset($_GET['page']) && $_GET['page'] != '')
  $page = (int)$_GET['page'];

To:

if(isset($_REQUEST['page']) && $_REQUEST['page'] != '')
  $page = (int)$_REQUEST['page'];
```(that way both the page links, as the $_POST page switch are supported)


:laugh: :laugh: :laugh:  on the love/stomach talk.

I can't promise anything about the feature requests, I would love (love again? :-) ) to do it all, but time is limited and I *really* need to get some other things done first. (and I am afraid I am a slow coder ;-) )

paulm:

Better turn register globals off again, unless you have to have to on for other reasons. Off is better for security! (if the code is free of errors/flaws it should not make any difference, but .......

I can't remember exactly why, but it was turned on for a reason when I first started tweaking my cart. Too many instances of editing files and now I can't remember why.

paulm:

I can't promise anything about the feature requests, I would love (love again? :-) ) to do it all, but time is limited and I really need to get some other things done first. (and I am afraid I am a slow coder ;-) )

It's okay, I fixed all 1150 of my products through phpMyAdmin. I got lucky because I've never been in there before and I found out where to edit. I probably couldn't find it again, it was pure luck! It took a few hours and my hand is killing me, but it would've taken FOREVER to edit in the admin. I knew you were busy and I really needed to have all of my products have wholesale prices (i just landed a wholesale customer :smile: ) right away. If only I had known these things from the beginning of my Zen adventure.

paulm + espresso = faster coding! that's why it's 3 a.m. and I'm still awake. :shocking:

craftzombie:

paulm + espresso = faster coding! that's why it's 3 a.m. and I'm still awake. :shocking: :-) That's quite normal for me, still being awake at times like that.

Actually I am not sure what wholesale prices are :blush: I have added purchase prices (=the prices I have to pay to my wholesaler (?)) to my shop and the quick updates module. But I think your are talking about you being a wholesaler yourself, and you offer different prices for your resellers?

(note that English is not my native Language)

cataland:

Hi, I just install this very usefull mod. I want's to add another comlumn, "p.product_price_w" for the wholesale price of the dual pricing contribution. What can I do to do this

I reconsidered, and decided to add the wholesale price after all. It costed only very little extra time since I was updating anyway. It's totally untested though!!!

Now I only need someone that wants to test my new version extensively. Do lots of updates, and copying products and such. Using a test database of course! ;-)

Anyone?

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)

Changes report:

v-november-16th-2006

1. Added column for wholesale price (= totally untested!)
2. Added quick copy: quickly copy one or more products as new products, and one click repeated copy.
3. Fixed multilinked categories problems and main_categories_id issue.
4. And added link to products_to_categories
5. Fixed page dropdown selection
6. Several other changes and code fixes
   (to update overwrite your old files, no changes to the sql since previous version)(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

paulm:

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

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 :smartass:

paulm:

main_categories_id? I meant master_categories_id of course....

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.

ghgarcia:

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.

paulm:

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,

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...

ghgarcia:

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:blush: ). 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)

paulm:

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!

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?main_page=product_contrib_info&products_id=166

But maybe other modules exist that use other column names?

paulm:

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?main_page=product_contrib_info&products_id=166

But maybe other modules exist that use other column names?

Hmmm, thats the mod I'm using. And I do have wholesale prices working correctly on every product. I'll have to poke around and see if I can figure this out.

Hi craftzombie,

I think I found the error. It should be products_price_w i.s.o. product_price_w. If I remember well, someone posted p.product_price_w in this thread, and I used that because I did not know anything about the contribution and assumed it was the correct column name. But of course it's possible I did not read it correctly.

Anyway, now I checked it, and it appears it should be products_price_w (and p.products_price_w in the query).

Found it:> Hi, I just install this very usefull mod. I want's to add another comlumn, "p.product_price_w" for the wholesale price of the dual pricing contribution.So I did read it correctly after all :-) But the contribution does use products_price_w, so that's what you need.

paulm:

Hi craftzombie,

I think I found the error. It should be products_price_w i.s.o. product_price_w. If I remember well, someone posted p.product_price_w in this thread, and I used that because I did not know anything about the contribution and assumed it was the correct column name. But of course it's possible I did not read it correctly.

Anyway, now I checked it, and it appears it should be products_price_w (and p.products_price_w in the query).

Thanks for saving the day... again! I fixed it and tested it and it works beautifully. xoxo