Wholesale pricing table on products.tpl?

balinor · #1 07-28-2005, 10:18 AM

I seem to remember adding this to a 3.x branch of the cart a long time ago, but that cart is no longer around and I can't seem to track down any posts that cover this. Before I re-invent the wheel, has anyone managed to get the wholesale pricing table to appear on the single column products page (products.tpl)? Thanks!

Light Speed · #2 07-31-2005, 07:02 PM

Wouldn't it have to have an instance for each product so if you have 6 products showing on products.tpl wouldn't you have six wholesale tables? Seems like that would be a mess.

balinor · #3 08-01-2005, 03:36 AM

Which is why I don't want to attempt it if someone else has already done it

sundance · #4 12-12-2005, 08:35 AM

Sounds like nobody has already done it...

I am going to have a crack at this tonight - I have just had my first flush of success updating elitedimensions 'extra fields on products.tpl' mod, so might have a go at this, too...

Something along the lines of... select * from xcart_pricing where productid = pid, and then build the table if there are more than one results...

dunno - that seems unwieldy to be honest - perhaps I will actually make an extra field to indicate whether the product HAS wholesale pricing and then do the SQL based on that... hmm.. not that clean either...

Still, all part of my learning curve. I'll keep you 'post'ed
Rob.

Light Speed · #5 12-12-2005, 10:19 AM

But doesn't the version of the cart that you are using 4.0.17 not use a extra table to display wholesale pricing like the old carts did? It just changes the actual price if someone is logged in as a wholesale member.

sundance · #6 12-12-2005, 02:34 PM

Thanks Light Speed - although I can't find exactly what you are referring to.

Have been fiddling with wholesale prices and they don't appear on the products.tpl list of products even if I am logged in as a wholesale customer.

I may just be looking in the wrong place.

Light Speed · #7 12-12-2005, 04:10 PM

Where did you enter the wholesale price?
Did you apply it to a wholesale member level?

If so then in both product.tpl and products.tpl the prices listed will automatically update to the wholesale price if logged in as a wholesale member.

balinor · #8 12-12-2005, 04:14 PM

We are talking about quantity discounts, not member-specific pricing.

Light Speed · #9 12-12-2005, 05:36 PM

Quote:

Originally Posted by balinor

We are talking about quantity discounts, not member-specific pricing.

I thought the topic title for this thread was "Wholesale pricing table on products.tpl"?

I was discussing wholesale pricing.........

balinor · #10 12-12-2005, 06:16 PM

Yes, quantity discounts are wholesale pricing. If you have quantity ranges set up, it displays a little html chart of the price ranges.