You are viewing this forum as a guest. Login to an existing account, or create a new account, to reply to topics and to create new topics.
Just recently updated our skins and had to change a few things around. Wondering if you can help me out with a few updates?
First, in the ajax minicart display how can I add the product number as well as the display name so it reads [ 'prodnum', 'displayname']
Second, how can I make a mass update to set the Product Sort/Search Price* === Regular price ?
Thanks!
Last edited by coatzel21 (03-21-2017 09:53:14)
Offline
(1) Edit {private}/apps/ecom/ECOM/includes/skinwidget_minicart.php. Search for name display, mod as needed.
(2) Edit the prodsearchp() function in {private}/apps/ecom/ECOM_Prod/ECOM_Prod.php. Search for 'sortprice' change to 'regprice'.
Offline
Opps sorry on part 1 I meant the minisearch not the mini cart.
On part 2 I made the neccesary changes but my price filtering seems to be numerical rather than by price for instance price down will yield
$950, $907, $90, $880, $80, $750. How can I resolve this?
Offline
(1) Edit {private}/apps/ecom/ECOM/includes/prodsearchajax.php.
(2) Interesting. That's why we use sortprice, as it's an integer. regprice is a varchar, so it makes sense it's sorting that way. I guess you have two options here:
A. Change the code back then execute this SQL to make sortprice=regprice:
UPDATE ecom_prod SET sortprice=regprice
~OR~
B. Alter the regprice column so that it's a FLOAT instead of a VARCHAR. I have no idea if this is going to cause issues elsewhere. It shouldn't, but this has never been tested, do at your own risk.
Offline
What would the global call to Product Number be?
foreach ($ajaxprodsearch as $num => $data) { $link = $this->link_namespace('ecom','prodshow',array('ref'=>$data['id']),$data['seourl']); $name = $this->xhtml_encode($data['name']); $count++; // print '<a href="' . $link . '" title="' . $name . '">'; print '<img src="media/ecom/prodsm/' . $imgname . '" alt="' . $name . '" width="' . $imgwidth . '" /></a>';
Offline