X-Cart forums

[astralbaby]

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

[astralbaby]

^^

[JWait]

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.

[astralbaby]

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

[astralbaby]

^ bump ^

[astralbaby]

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

[Holub]

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.

[mpdaddy]

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

{* Display Lowest Wholesale Prices Start *}
{include file="customer/main/product_prices.tpl" product_wholesale=$products[product].wholesale}
{* Display Lowest Wholesale Prices End *}

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

[astralbaby]

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.

[astralbaby]

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