I'm trying to map my own categories because the product feeds I'm working with aren't very compatible.
Problems
- Feed uses the same image, or a different image filename that IS the same image, on many products.
- Feed shows far too many virtually identical products with slight title differences.
- Feed calls a "full exhaust system" simply "full system" and searching for full systems results full ignition systems, etc.
- Main problem - this is taking far too long to sort out.
Solution
- Display thumbnails along with the category/titles in Category Mapping Helper.
I could tear through this process if image thumbnails (or full sized images scaled down to 100x100) were next to the titles. In reality it is not a good idea to return results to a visitor if every item on the page shows the same image, ya know?
How can I add thumbnails to categories_helper.php (it appears inside the iframe of categories_configure.php).
Thanks
Hi,
This should be do-able reasonable easily. If displaying the category image thumbnails below the results select box be suitable, look for the following code in admin/categories_helper.php:
$sql = "SELECT DISTINCT(category) FROM `".$config_databaseTablePrefix."products` WHERE ".$where." ORDER BY category";...and REPLACE with:
$sql = "SELECT MIN(id),category,image_url FROM `".$config_databaseTablePrefix."products` WHERE ".$where." GROUP BY category ORDER BY category";This will pull image_url into the result set, so now it can be displayed below the category result list. To do this, look for the following code at line 88:
print "</table>";...and REPLACE with:
print "</table>";if (count($rows))
{
foreach($rows as $row)
{
print "<p>";
print <img width='100' src='".$row["image_url"]."' /><br />";
print "<span
style='color:blue;text-decoration:underline;cursor:hand;'
onclick='alternateAdd(\"=".$row["category"]."\");'>
=".$row["category"]."
</span>";
print "</p>";
}
}
That should make the category name displayed beneath each thumbnail clickable to add as an exact match...
Cheers,
David.
--
PriceTapestry.com