lukejapanwalker

Hey bsmither, Thanks for your reply. I just checked out SemperFi's "Related Products". I'd rather have the related products shown automatically from the title name of the product, as it would be terribly time consuming to assign related products to each product. Also I'm all for purchasing extensions if they do exactly what I need, but if I can just make use of the search function I'd rather do that. If I can't find a good way I will probably just add an iframe to the description as a last resort, but I'm sure you'd agree that is not ideal.

I want to add a search results to the bottom of the product page, using the title of the product as the keywords. I know it's a bit of a crude method to add related items but I feel it should do what I need it to. I have found "searchCatalogue" and think I just need to call this at the end of the product php, any ideas? Thanks Luke

Thanks a bunch heavenswift-hosting! that did it! And thanks bsmither, I know you are a big contributor to this forum and your old posts too, have helped me a lot. I hope someone else find this useful in the future.

I just checked again and disabling "enable caching" under "Performance" works but ony once and I still have to do it manually, is there anything I can add after my SQL queiry to clear the cache after changing the price? Based on what you said, I believe if I can only clear the cache it should work? Cheers Luke.

Hello thanks for your reply. Ok, in my description there is an iframe that links to a php file (located in the root directory of my store) to update the database, like below. $link = mysqli_connect($servername, $username, $password, $my_db); $sql = "UPDATE gwm_CubeCart_inventory SET price='99.00' WHERE product_id='".$proid."'"; if ($link->query($sql) === TRUE) { echo "New record created successfully"; //echo "O"; } else { echo "Error: " . $sql . "<br>" . $link->error; //echo "X"; }But the price of the item only refreshes when I clear the cache. I tried admin, Store Settings, Advanced tab, Enable Caching >> selected disable from the drop down menu and hit save. It worked once but after running the sql code above it doesnt refresh anymore. I check to make sure it change by looking in phpmyadmin and it did change there but not in my store. Thanks Luke.

Ok that sound perfect! I just did that and it worked for the first refresh and now it's like it's back on again. Is there still an issue with disabling the cache in v6?

Hello bsmither, Thank you for your reply, I tried "$GLOBALS['cache']->clear('sql');" in my sql code for my description and nothing changed. do you know what might be wrong? I'm sure there's probably something I'm just not understanding but I think I just need a way to clear the cache each time someone clicks on a product or something like that. Thanks again for your help. Luke.

I am updating my product prices automatically using sql, but the prices do not change until the cache is cleared manually from the admin control panel. Is there a way to clear the cache via script? Right now I have a sql command hidden in the product description to update the price of the product, what code should I add after that to clear the cache right away? Thank you for your help. Luke.

Hello bsmither, Thank for your help!! The last code you posted looks like just what I'm looking for! Maybe I'm missing something or it hasnt been tested, but I get an error(webesite wont load) when I replace the code above. I'm sure it's probably just a syntax error, I will have a mess around with it to try and find the error and post it here if I do.

Hello bsmither, Thank you very much for your reply, yes I'm using a CSV with a 3rd party program "emagiceone" (which I'm not that fond of) but it lets me import everything very fast. Unfortunately this software was built for cubecart 5 so does not have the option to set the seo_path on import via csv, so I want to edit the code so that it makes a seo_path using the product code or even better the isbn number instead of the title of the product. do you know a way of doing this?

I have had a good crack at it and tracked it down to possibly the seo.class.php file. Does anyone know what part of the code I have to change? I know I can do it manually from the admin but I need it to be automatically generated. Thanks