Is there a way to ignore upper case vs. lower case letters when matching product names?
While capitalization is useful for the product title display, I would like the products to match in the mapping without actually mapping each capitalized version... I would like Widget, WIDGET, widget, WIDget, etc. to all be the same product.
That seems to bypass many of the products that I have already mapped and puts the different versions back in the database.
UPDATE: Actually, it looks like all of the products I had already mapped were not imported at all.
Hi,
Could you email me your includes/admin.php as an attachment and I'll check it out...
Cheers,
David.
Thanks, the updated code above seems to be working great.
Hi David,
Won't this result in the end product name being in lower case? Is there any other way of doing this to avoid that happening?
Cheers.
Keeop
Hi Keeop,
It's only the comparison that is being made case insensitive (i.e. they keys into the $admin_importProductMappings array); the actual alternate product name, which is taken as the value of that array is applied exactly as it appears in the master product name...
Cheers,
David.
Hi David,
Is it?? Sorry, if there's one thing I hate it's arrays! I implemented this code but it didn't seem to work so I assumed it was changing the case of the record values which was then causing problems with some other stuff I do later on in the script with those values. OK, I'll have another look and try and see what's going on.
Cheers.
Keeop
Hi Keeop,
Have a look at the print_r() function with the $admin_importProductMappings array which should indicate what's going on. Let's say a mapping had been created for the master product name "Blue Widget", with an alternatives of "Big Blue Widget", and "Widget Blue". With the keys being strtolower()'d by the modification, the array should contain:
$admin_importProductMappings["big blue widget"] = "Blue Widget"
$admin_importProductMappings["widget blue"] = "Blue Widget"
The product name being imported is then also strtolower()'d, and used to check that array, and if a value is found the product name field is overwritten with the master product name.
(I normally use exit(); immediate after debugging with print_r() so that you can view the first instance otherwise it will generate lots of output - once for every product being imported!)
Hope this helps!
Cheers,
David.
Hi David
Trust your well
trying to sort out the product mapping at the minute,
i seem to have two instances of
$alternate = trim($alternate);regards
Phil Stone
www.buy24-7.net
Hi Phil,
Yes sorry - the first instance refers to Category Mapping, so it's the second instance you want, which is at line 414 in the 11/09A distribution.
Cheers,
David.
--
PriceTapestry.com
Hi David - I am using the new 12/10B version, what changes do I need to make to my includes/admin.php to make this modification. I am not quite sure what do with the second set changes you noted above. Your help would be much appreciated - thanks!
Hi,
To make Product Mapping case insensitive in 12/10B, first look for the following code at line 473:
$alternate = trim($alternate);...and REPLACE with:
$alternate = strtolower(trim($alternate));And then look for the following code at line 270:
if (isset($admin_importProductMappings["=".$importRecord["name"]]))
{
$importRecord["name"] = $admin_importProductMappings["=".$importRecord["name"]];
}...and REPLACE with:
if (isset($admin_importProductMappings["=".strtolower($importRecord["name"])]))
{
$importRecord["name"] = $admin_importProductMappings["=".strtolower($importRecord["name"])];
}...and finally look for this code at line 288:
if (strpos($importRecord["name"],$word) !== FALSE) $found++;...and REPALCE with:
if (stripos($importRecord["name"],$word) !== FALSE) $found++;Cheers,
David.
--
PriceTapestry.com
Thanks David! But does this only work for products that have been mapped using the "Product Mapping" tool?
Hi cfoss,
It makes the process of applying Product Mapping case insensitive, but otherwise, the product grouping is, itself, not case sensitive anyway, so if you have the same products from different merchants called "RED WIDGET" and "Red Widget" they should compare.
If you're not sure, let me know the URLs of a couple of products on your site (I'll remove the URLs before posting your reply) that you want to be compared but are not being I'll take a look for you...
Cheers,
David.
--
PriceTapestry.com
Ok, below are some URL's of a couple of the products I am having trouble with from two different merchants. I've pulled the feeds and they look normal, so I am not sure what the problem is. Also, I am not sure how extensive the problem is, a lot products work just fine, but I've noticed this problem on a handful of searches I have done. Let me know if you need access to my ftp site. Thanks for your help!
{link saved}
Hi,
To make Product Mapping case insensitive; first look for the following code around line 368 of includes/admin.php
$alternate = trim($alternate);...and REPLACE this with:
$alternate = strtolower(trim($alternate));And then higher up the same file, look for the following code within the import record handler function starting at around about line 228:
/* apply product mappings */if (isset($admin_importProductMappings[$record[$admin_importFeed["field_name"]]]))
{
$record[$admin_importFeed["field_name"]] = $admin_importProductMappings[$record[$admin_importFeed["field_name"]]];
}
...and REPLACE that with:
/* apply product mappings */if (isset($admin_importProductMappings[strtolower($record[$admin_importFeed["field_name"]])]))
{
$record[$admin_importFeed["field_name"]] = $admin_importProductMappings[strtolower($record[$admin_importFeed["field_name"]])];
}
Hope this helps!
Cheers,
David.