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
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
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.
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.
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
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
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
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
Thanks once again for your 5 star support!!
regards
Phil Stone
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.
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
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.
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
Thanks David,
It works perfectly, as always.
Cheers
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.