Wholesale prices on products.tpl
 

Ok.. if I view the source for products.tpl it includes another tpl called buy_now.tpl

buy_now.tpl includes the wholesale tpl called product_prices.tpl.. this is the same tpl that product.tpl includes on the item view page... so.. why will it not display on the product list page?

I am trying to display the wholesale prices on the product list page, like the product view page does.. where is the wholesale prices stored? In the database? if so where? i checked every table.. is it on the file system?

I have read many posts where people want this simple functionality that should ship out of the box.. but it does not.. unless i have not enabled a certain function..

If I can find where x-cart stores the wholesale prices, I will release a patch for all that will show wholesale prices on product list..

please.. just point me in the right direction either by telling me where wholesale prices are stored, or let me know why products.tpl will not show the prices when the file is included....

Re: Wholesale prices on products.tpl
 

^^

Re: Wholesale prices on products.tpl
 

If you want wholesale prices to be displayed, in admin click "modules" and make sure "Wholesale Trading" is checked. Once you do this, each product will have a section named "Wholesale prices" where you can define the wholesale price.

There is also a customer "Wholesale" membership class. This will allow you to have only "wholesale" members use the wholesale pricing.

Re: Wholesale prices on products.tpl
 

I do have the module enabled.. and it DOES show them on the product.tpl page... but NOT on the products.tpl

product.tpl shows the item along with weight and wholesale prices

products.tpl shows the items in the catagory with just a buy now link and a price.. the user is unknowingly forced to make a extra click to see the wholesale prices... I need these prices to be seen on the product list page which is products.tpl..

any help i can get would be greatly appreciated..

--or--

show me where the wholesale prices are stored, then I could just assign the prices to an array and iterate though the array on the template side..

please advise...

Re: Wholesale prices on products.tpl
 

^ bump ^

Re: Wholesale prices on products.tpl
 

Is this out of the scope of the forum user base? I have wholesale enabled and working.. but just trying to find a way to display prices on product list page.. so customer does not have to click the product to see that there is wholesale pricing structure...

Re: Wholesale prices on products.tpl
 

The wholesale prices is stored in database, the table is xcart_pricing. It contains all prices for all products and variants. If field quantity is equal 1, it's usual price, if more that 1, it's wholesale price.

Re: Wholesale prices on products.tpl
 

Try this in your skin1/customer/main/products.tpl file where you want it to display.


I am using it at http://www.jbholcombe.com to show the wholesale prices. Click on almost any category to see it in action.

Regards
Wayne

Re: Wholesale prices on products.tpl
 

using that tpl code does not display wholesale prices on the product list page.. I really do appreciate your help though... :)

I have been communicating with the help desk.. this is our latest..

> If the customer is viewing a list of products.. I want the customer to see
> the wholesale trading prices on that list... As it operates now.. the
> customer has no idea that wholesale pricing is available unless they click
> MORE INFO.. I also have the buy now link enabled... I want the customer to
> be able to add a item to the cart WITHOUT HAVING to click more info.......

All right, thank you for clarifications. The default x-cart lets you achieve the initially described appearance on product details pages but not on product listing (category details) pages. The task appears to be rather time consuming to be implemented within support service, but please let me suggest you our Custom Development service. You will find more information on the service at http://www.qualiteam.biz/custom_development.html.

Re: Wholesale prices on products.tpl
 

I have developed a solution for this.. it is a hackish fix.. but it does display the wholesale prices on product list..

what I did was included a file into products.php.

In the included file I got the product id and added it to the $products array.. then I created a db connection and queryed the db and assigned the output to a smarty var then displayed it in products.tpl..

If anyone is interested in this fix, please reply here... Only two file edits are required and one new file needs to be uploaded..

Untill x-cart adds this basic functionality to the cart software.. i will use this solution..

i want to thank everyone for their help.. :)

Re: Wholesale prices on products.tpl
 

Please look at http://forum.x-cart.com/showthread.php?p=238087 near the bottom. I missed the fact that I edited the products.php file along with the code I posted above.

It is an easy fix and I assure you it works. I just tried it on a fresh installation. There is no need to do an extra sql query.

Regards
Wayne

Re: Wholesale prices on products.tpl
 

ok mp.. lets give it another whirl... the fix you provide is much more elegant than mine.... :)

I'll be back with some feedback

Re: Wholesale prices on products.tpl
 

You my friend, are awsome!! I cant begin to tell you how much I appreciate your help and the fact that you were willing to take time out of your day to help me. It worked.. right out of the box!!! Even got featured items working as well..

Thank you so much again.. My approach was nasty, but it worked.. but using this solution was what I was secretly waiting for the whole time.. does it seem like I am making a bigger deal out of this than I should? who cares.. I have spent so many hours and hours of sleep working on this and getting help.. my client is happy now.. I am happy..

Please let me know if you need any help down the road in return..

also.. I will leave links to this thread in all the other theads on this board pertaining to this issue..

thank you sir....

Re: Wholesale prices on products.tpl
 

Glad it worked for you. I just hate it when I see a post for a problem I have solved. I feel obligated to find the solution and pass it along.

Good Luck
Wayne

Re: Wholesale prices on products.tpl
 

Please help me to solve same issue, wholesale price does not appear on site, even for wholesale member. second wholesale price only shows in details if lodge for all member. Kindly help

Re: Wholesale prices on products.tpl
 

I am in xcart 4.4 and cannot find the listed code. Is there anyone who knows what code it is in 4.4?