X-Cart forums

[grnyj93]

What do I need to change in my templates to display the list_price and price from the products detail page (in admin section) on the products/category pages in the front end regardless of whether it has variants or not.

I have products set up as follows:

product list_price: $99.99
product price: $89.99

variant 1 (actual product) list_price: $99.99
variant 1 (actual product) price: $89.99

variant 2 (repair kit for product) list_price: $4.99
variant 2 (repair kit for product) price: $3.99

Problem is that on the products/category page as well as in the featured products it will display:

Product list_price; $99.99
variant 2 price: $3.99
And show a discount of 96%

Very misleading.

I need it to have it display the list_price and price from the main product (not the cheapest variant) so that I can show the pricing for the product and not the list_price of the product and the price of the repair kit.

I have searched the forum and found this problem posted a few times with no fixes.

I would just like to know where in the code I need to edit so that it doesn't display pricing from the variants on the products/category pages.

Thanks,
Jason.

[grnyj93]

Am I not making sense? Or is there really no one here who knows where to manipulate xcart so that it always pulls the pricing (list price and actual price) from the main product and not the variants.

Help please. I can't have a product that says it is on sale for 96% off the list price because of this.

[Jon]

In include/search.php

FIND:

				if($products[$k]['descr'] == strip_tags($products[$k]['descr']))
					$products[$k]['descr'] = str_replace("\n","
",$products[$k]['descr']);
				if($products[$k]['fulldescr'] == strip_tags($products[$k]['fulldescr']))
					$products[$k]['fulldescr'] = str_replace("\n","
",$products[$k]['fulldescr']);

After put:

			$tempid = $products[$k]['productid'];
			$maxprice = func_query_first("SELECT price FROM $sql_tbl[pricing] WHERE quantity='1' AND productid='$tempid' AND membership=''");
			if ($maxprice[price] > 0) { $products[$k]['maxprice'] = $maxprice[price]; }
			else { $products[$k]['maxprice'] = $products[$k]['price']; }

Then use $products[whatever].maxprice in your templates.

[grnyj93]

Thanks for the help. I appreciate it.

Jason.

[grnyj93]

I implimented the mod and it appears to be working perfectly - Thanks a ton for the help.

[thumbsatplay]

Is this a bug? It sounds like a bug to me......I tried a different scenario.

1. Create a product with 2 variants.
2. Modify the quantity in stock for the first variant to 5 or something greater than 1
3. Modify the quantity in stock for the second variant to 0

When I see that product under it's category, it says "Out Of Stock".

I'm going to log a support ticket and will update this.

[grnyj93]

Good point, I hadn't thought about it being a bug. Definetely let us know how it goes.

[Jon]

Many people have complained about this, but x-cart says it is a "feature" that is working as it should.

[thumbsatplay]

I logged a ticket with X-cart and they uploaded a fix (patch) into my file area. If enough people log a ticket, perhaps, they will realize that the feature in its current state is rather useless.

I said in my ticket if I had two variants A and B and A was In Stock, and B was Out Of Stock, then B would show up in the products list page; on the product details page, Product A shows up. This functionality is useless because if Product B is out of stock, and the products list page shows it as Out Of Stock, then customers are not going to drill down to see if there is another variant In Stock (Product A). They will just say, "Well, that's out of stock" and move on.

[Dongan]

Hi thumbsatplay,

Could you pls share the solution ?