Quick Updates plugin [support]

[craftzombie]

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?

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.

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

[paulm]

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.

[craftzombie]

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

[paulm]

/me thinks about buying a ticket to Texas!

Thanks for the feedback :-)

[paulm]

I just noticed I forgot to remove some debug lines, and forgot to add two instances of the zen_update_products_price_sorter() as well (which needs to be executed when changing the master category, I think...). These are only minor issues, but of course they need to be fixed, so I will probably upload an updated version soon.

Other than that (and possible other bug fixes) I am taking a break again from this mod, I think ..... ;-)

[paulm]

Attached a new version to this post wich should fix the formentioned issues, and hopefully does not introduce any new issues ;-)

[cataland]

In the last update there is a problem. In the "wholesale price" field will be insert the price in this mode "22.00,19.00" that corresponde with the different level of prices. When I insert this value the script don't function, crash. I think that the problem is in the field format.

[craftzombie]

In the last update there is a problem. In the "wholesale price" field will be insert the price in this mode "22.00,19.00" that corresponde with the different level of prices. When I insert this value the script don't function, crash. I think that the problem is in the field format.

It might be that he didn't realize there are possibilities of different levels of wholesale pricing. I don't know how Quick Updates functions though. I use one set of wholesale prices and its been working fine for me.

[paulm]

In the "wholesale price" field will be insert the price in this mode "22.00,19.00" that corresponde with the different level of prices.

Are you saying the wholesale prices contribution stores more than one price in one column?