You are here:  » productsmap.php Name

Active Forum Topics


productsmap.php Name

Submitted by Tobix on Sat, 2021-10-09 07:17 in

Hi, David,
how can I make the search bar found on the productsmap.php page longer? Sometimes I write articles that have long names and that's a problem. Thanks.

Submitted by support on Sat, 2021-10-09 09:47

Hi Tobix,

I'm not sure I understand sorry - the product name (on pt_products) and a mapped product name (as entered in Product Mapping) is limited to 255 characters do you need to make that longer so you can use longer names?

Cheers,
David.
--
PriceTapestry.com

Submitted by Tobix on Sat, 2021-10-09 12:38

Excuse me, I explained myself badly. I'm talking about the string or box that manages to cover a few words and every time I have to scroll through it.

Submitted by support on Mon, 2021-10-11 07:11

Hi Tobix,

You can make the select box much wider; it's in admin/helper.php at line 105 where you'll find the style attribute of the select element...

style='width:100%;height:110px;'

width:100% will set it to the width of the foundation small-6 columns container but you could use a fixed much wider width and it will overflow e.g;

style='width:800px;height:110px;'

Cheers,
David.
--
PriceTapestry.com

Submitted by Tobix on Tue, 2021-10-12 14:28

I changed but I'm going to change the box of another content. I need to edit this /admin/productsmap.php file
is the box is called "Name". Where you write the name of the article to be mapped. I would like that long.

Submitted by support on Wed, 2021-10-13 07:26

Hi,

Yes that box is in admin/productsmap.php, to make it full width look for the following code at line 56:

  widget_textBox("Name","name",TRUE,(isset($_POST["name"])?$_POST["name"]:""),"",3);

...and REPLACE with:

  widget_textBox("Name","name",TRUE,(isset($_POST["name"])?$_POST["name"]:""),"",12);

Cheers,
David.
--
PriceTapestry.com

Submitted by Tobix on Wed, 2021-10-13 14:00

Great! this is what I wanted! :)

Submitted by support on Fri, 2021-10-15 07:50

Hi Tobix,

My apologies I have been having some issues with the forum database, if you are still having problems with the discount percentage modification for Featured Products / Search Results let me know and I'll check that out further with you; specifically if after making the changes there were no errors; just no savings being shown where they should be?

Cheers,
David.
--
PriceTapestry.com

Submitted by Tobix on Fri, 2021-10-15 14:09

Hi Davide,
On the products page I see everything fine.
I don't see anything instead, as if I hadn't put the code in either the searchresults.php or futured.php.

:(

Submitted by support on Mon, 2021-10-18 07:25

Hi Tobix,

Let's get it working for Featured Products first. So just to confirm the modifications in index.php you have added the AVG(price) AS avgPrice at line 33 so you have;

    $sql = "SELECT * , MIN( price ) AS minPrice, MAX( price ) AS maxPrice, AVG( price ) AS avgPrice, COUNT( id ) AS numMerchants, ".$sqlCase." FROM `".$config_databaseTablePrefix."products` WHERE normalised_name IN (".$sqlIn.") GROUP BY normalised_name ORDER BY sequence";

And then at the top of html/featured.php you have added:

<?php
  
foreach($featured["products"] as $k=> $product)
  {
    
$featured["products"][$k]["saving"] = round((($product["avgPrice"] - $featured["products"][0]["price"])/$product["avgPrice"])*100,2);
  }
?>

With the above in place; please can you post the additional code you have added to html/featured.php to actually output $product["saving"] within the loop and I'll check that out for you...

Cheers,
David.
--
PriceTapestry.com

Submitted by Tobix on Mon, 2021-10-18 15:01

Hi David,
i copy this is Code:

<span class="radius secondary label"><?php if ($saving): ?>
RISPARMI <bold><?php print $saving?>%</bold>
<?php endif; ?></span>

Submitted by support on Tue, 2021-10-19 07:27

Hi Tobix,

The code needs to use $product["saving"] rather than $saving in this case; have a go with:

<span class="radius secondary label"><?php if ($product["saving"]): ?>
RISPARMI <bold><?php print $product["saving"]; ?>%</bold>
<?php endif; ?></span>

Cheers,
David.
--
PriceTapestry.com

Submitted by Tobix on Tue, 2021-10-19 14:08

We are almost there. The problem is that the percentage is wrong very often gives me an example -211% o -240.06% :(

Submitted by support on Wed, 2021-10-20 07:51

Hi Tobix,

Ah, the code to calculate the saving was using the price from the first Featured Product for all products, it should be using the minPrice value from the current product. The correct code for the top of html/featured.php:

<?php
  
foreach($featured["products"] as $k=> $product)
  {
    
$featured["products"][$k]["saving"] = round((($product["avgPrice"] - $product["minPrice"])/$product["avgPrice"])*100,2);
  }
?>

Let me know once that's all OK and then will details the same for search results...

Cheers,
David.
--
PriceTapestry.com