You are here:  » Product Map - Existing Products

Active Forum Topics


Product Map - Existing Products

Submitted by philstone on Wed, 2009-11-11 16:00 in

Hi Dave

Love the new script, thanks so much for the update, slowly working through everything at the minute, to make it look like my current site, was wondering though david, is it possible to make the admin/productsmap.php existing products renameable without have to delete and readd products, now that the hypen is allowed in the script i want to change a lot of the mapped products and was thinking this would save a lot of time

let me know if this is possible

thanks again
philip

Submitted by support on Wed, 2009-11-11 16:12

Hello Philip,

I understand - the easiest way to do this would be to edit the productsmap table directly using a MySQL administration tool such as phpMyAdmin (which you may already have installed as part of your hosting package).

If you browse to your Price Tapestry database, and then the productsmap table; you will be able to edit rows and change the name fields as required...

If that's not an option for you, let me know and I'll look at adding an edit function for you...

Cheers,
David.

Submitted by philstone on Wed, 2009-11-11 23:19

Hi David

having trouble getting acces to phpmyadmin, but waiting on host company looking into it, do you think its possible to have this feature running on the site?

regards

Phil Stone
www.buy24-7.net

Submitted by support on Thu, 2009-11-12 09:57

Hello Phil,

No problem - I've just put together a script to edit all product mapping master product names in a single form. Download, unzip and upload to /admin/. Then browse to /admin/productsmapEdit.php

Hope this helps!

Cheers,
David.

Submitted by philstone on Thu, 2009-11-12 16:39

Thanks David

is that link working at your end?

regards

Phil Stone
www.buy24-7.net

Submitted by support on Thu, 2009-11-12 16:47

Hi Phil,

It's working now - I'd moved the support files around since my earlier post and accidentally moved this file to the wrong place...

Cheers,
David.

Submitted by philstone on Wed, 2011-04-06 22:33

Hi David

Was wondering if in the admin/productsmap.php if its possible to have the number of products using a product map in brackets in another column?, I discovered any not currently being used created an error in the user browser - Error 310 (net::ERR_TOO_MANY_REDIRECTS): There were too many redirects., but doing this it would make it obvious which pm's are no longer required, i can't see there being a way to auto delete these but thought this way would be a safer option anyway, also was wondering could a column on this page show if an amazon product is being linked or not or even display the amazon asin code linked to each pm?

hope this makes sense

thanks again

Phil Stone
www.buy24-7.net

Submitted by support on Thu, 2011-04-07 08:31

Hi Phil,

At what point is the max redirects error occurring? Mappings that aren't applied shouldn't exist in the database at all - can you let me know a little more about the sequence of events that you're taking to cause the problem...

Thanks!

David.
--
PriceTapestry.com

Submitted by philstone on Thu, 2011-04-07 09:44

Hi David

It's for products that have become no longer available, so products that I mapped say a year ago, now they are not supplied by any of my merchants, so really just asking about some type of alert system to warn me when this happens, so that I can delete them

regards

Phil Stone
www.buy24-7.net

Submitted by support on Thu, 2011-04-07 10:41

Hi Phil,

Sure - in admin/productsmap.php you'll find the line where each master product name is output in the table at line 64:

      print "<th align='left'>".$productmap["name"]."</th>";

To show a product count for each entry, REPLACE the above with:

      print "<th align='left'>";
      print $productmap["name"];
      $sql2 = "SELECT COUNT(*) AS productCount FROM `".$config_databaseTablePrefix."products` WHERE name='".database_safe($productmap["name"])."'";
      database_querySelect($sql2,$rows2);
      print " (".$rows2[0]["productCount"].")";
      print "</th>";

Hope this helps!

Cheers,
David.
--
PriceTapestry.com

Submitted by philstone on Thu, 2011-04-07 14:28

Thanks once again for your 5 star support!!

regards

Phil Stone

Submitted by hna84 on Mon, 2021-03-08 17:07

Hi David,

I’ve modified the file productsmapEdit.php to make it work with the table pt_productsmap_regexp, but it opens a full list with every RegExp (+4000), which is too long to work with. Could we include the feature “RegEXP name edit” inside productsmap_regexp_configure.php to modify names one by one?

As you already know, I use the 15/09 version.

Thank you very much.

Submitted by support on Tue, 2021-03-09 08:58

Hi,

Just to confirm what you wanted as in Product Mapping by RegExp, the name (as entered when you create a new mapping) is only for your own convenience in order to refer to what brand / model range the mapping applies to - the actual product name is derived from from the regexp process at import time.

Is that the case, you just want to update your reference names for convenience?

Cheers,
David.
--
PriceTapestry.com

Submitted by hna84 on Tue, 2021-03-09 16:56

Hi,
That’s right, I just want to be able to update my reference names for my convenience. Sometimes, the name of a product may change but I do not need to modify the RegExp.

Thanks,
Héctor.

Submitted by support on Wed, 2021-03-10 08:41

Hi Héctor,

To add an edit field for the mapping name edit admin/productsmap_regexp_configure.php and look for following code at line line 53:

                `brand` = '".database_safe($_POST["brand"])."'

...and REPLACE with:

                `brand` = '".database_safe($_POST["brand"])."',
                `name` = '".database_safe($_POST["name"])."'

Then look for the following code at (now) line 285:

  widget_formButtons(array(translate("Save")=>TRUE,translate("Test")=>TRUE),"productsmap_regexp.php");

...and REPLACE with:

  widget_textBox("Name","name",TRUE,$productmap["name"],"",6);
  widget_formButtons(array(translate("Save")=>TRUE,translate("Test")=>TRUE),"productsmap_regexp.php");

Cheers,
David.
--
PriceTapestry.com

Submitted by hna84 on Wed, 2021-03-10 18:18

Thanks David,
It works perfectly, as always.

Cheers