X-Cart forums - Newest Products

X-Cart forums (https://forum.x-cart.com/index.php)

- Dev Questions (https://forum.x-cart.com/forumdisplay.php?f=20)

- - Newest Products (https://forum.x-cart.com/showthread.php?t=1084)

Re: Newest Products

Never mind, got it. I was looking in the wrong place.

Thanks

Re: Newest Products

Did you get it to work .. It should like like this except for I change the dialog box to fit my shop

http://www.lingerieblowout.com/newproducts.php

Re: Newest Products

well, no I could not get it to look the way I wanted so I went with another mod which works great for me. The only sad thing is I found it to late after I bought the other one. O well at lease I am happy now and can move on to something else. Thanks for your help though.

Re: Newest Products

i have this up and running fine except that the quantity pull down box isn't working at all. Any tips on how i can fix this?

Re: Newest Products

I noticed a few of you got the "Newest Products" to show on the home page. I get the " No new products have been listed within timeframe you specified " every time I try to do it.

Did I overlook this in the thread?

Thanks

Re: Newest Products

Quote:

Originally Posted by weston

bump for help?

I have fixed my problem, i have a custom mod and i needed to add:

PHP Code:


		
			
// newproducts .. needed for quantity to work on newproducts module
    $fields[] = "$sql_tbl[products].min_amount";
    $fields[] = "$sql_tbl[products].max_amount";

to include/func/func.product.php

finally working, and you can see it in action at:
http://obeygiant.com/store/newproducts.php

Re: Newest Products

I've tried it on my version 4.0.17. There is no such file as include/func/func.products.php as indicated:

Quote:

Edit $xcart_dir/include/func/func.product.php

FIND (approx line 363):

$fields[] = "$sql_tbl[products].productcode";
$fields[] = "$sql_tbl[products].avail";

Add AFTER:

// newproducts .. needed for quantity to work on newproducts module
$fields[] = "$sql_tbl[products].min_amount";

So I located /include/func.php and added red line:

#
# Generate products availability condition
#
if ($config["General"]["unlimited_products"]=="N" && (($current_area == "C" || $current_area == "B") && $config["General"]["disable_outofstock_products"] == "Y"))
$avail_condition = " AND $sql_tbl[products].avail>0 ";
else
$avail_condition = "";

$select_query = "SELECT $sql_tbl[products].productid, $sql_tbl[products].product, $sql_tbl[products].productcode, $sql_tbl[products].avail, $sql_tbl[products].min_amount, MIN($sql_tbl[pricing].price) AS price";

I followed all other installation instructions, which seem universal to x-cart then opened /newproducts.php url in browser to see what would return and the newest products page was blank nothing delivered.

I cannot figure out what is missing to have a query and get of new product data. Not ready to upgrade store to latest version as it is actively patronized in current state and can't afford to be down for maintenance for longer than a couple of hours. Any coding ideas?

Re: Newest Products

This is a pretty old thread, and has gone through several versions. I had it working fine in versions 4.0.14 to 4.0.19, and now in 4.1.10. The solution is in this thread, but perhaps you should begin at the beginning and find where your particular version is addressed.

As for the blank page, it could be permissions are not set correctly, or just that you need to clear your templates cache.

Re: Newest Products

Quote:

Originally Posted by JWait

Yes. It is an old thread with many many transitions. Assume I didn't weed through the thread at least 3-4 times already. Could you perhaps direct me to the point of thread #XXX aahaaa or offer a useful answer for 4.0.17?:?