Quick Updates plugin [support]

Quote:

---

Originally Posted by 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?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.

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:

Quote:

---

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.

Quote:

---

Originally Posted by 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

/me thinks about buying a ticket to Texas! :P

Thanks for the feedback :-)

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

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

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.

Quote:

---

Originally Posted by 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.

---

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.

Quote:

---

Originally Posted by cataland

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? :shocking: