Hi David,
This is more of a thought than it is a request, but the biggest issue I have with PT in terms of administration is category management. I've got so many categories, that I mostly get lost off and bogged down with the volume so probably only use a fraction of the products in say mapping items.
I therefore wondered whether it is possible to make category mapping easier, through perhaps showing the merchants name against each category in some way (in a different colour perhaps)
Or
Perhaps a way to show each merchant with its related list of categories?
If there are other ways that these can be managed I would really appreciate some direction.
Thanks again
Paul
Hi David,
And here's me thinking it might be a challenge for you! outstanding, will certainly help
Regards
Paul
Hi David,
I love this mod.
I was wondering would it possible to modify the merchant category list to include an option to add selected merchant category names to the feeds filter?
what do you think?
Cheers
Rod
Hello Rod,
I'm afraid I'm not quite sure exactly what you mean - are you thinking about automatically creating a "Drop Record If Not RegExp" filter against the Category field for that merchant's feed; configured to drop all categories NOT selected?
Cheers,
David.
Hi Paul,
Sure - here's a tool to list all categories for a selected merchant - run from /admin/
merchantCategories.php
<?phprequire("../includes/common.php");
require("admin_header.php");
if ($_GET["merchant"])
{
print "<h3>".$_GET["merchant"]." Categories</h3>";
$sql = "SELECT DISTINCT(category) FROM `".$config_databaseTablePrefix."products` WHERE merchant='".database_safe($_GET["merchant"])."' ORDER BY category";
database_querySelect($sql,$products);
foreach($products as $product)
{
print "<p>".$product["category"]."</p>";
}
}
else
{
$sql = "SELECT merchant FROM `".$config_databaseTablePrefix."feeds` ORDER BY merchant";
database_querySelect($sql,$feeds);
foreach($feeds as $feed)
{
print "<p><a href='?merchant=".urlencode($feed["merchant"])."'>".$feed["merchant"]."</a></p>";
}
}
require("admin_footer.php");
?>
Hope this helps!
Cheers,
David.