Hello, I just found that (what it looks like) I made a mistake when doing Category Mapping, - I mapped a category to a wrong category! How should I find out which is the original category name and "remap" it? - Is it possible at all with the current setup? I mean I dont see the original categories being stored in DB along side the products, - does that make it impossible to find out the original category of a certain product?
Thanks a lot
Pasha
David, I think (because of my English probably) I did not explain properly and you have missed my point in this one...
Ok so I have a product called "Marshall Speaker" which is currently mapped to a Master Category called "Acoustic Guitars".
In the same time category "Acoustic Guitars" currently has 186 alternative names.
I can not tell which was the original category that brought me the "Marshall Speaker" to "Acoustic Guitars" by the name of the alternative, so how can I find out which of the alternative names is in its wrong place?
Am I right to assume that the ONLY WAY to actually get the "alternative category name" that corresponds to a mapped product is to:
1 - select the product name from DB to get its master category name
2 - using the master category name select an array of all the corresponding "alternative category names"
3 - Search for the "Product Name" + "One of the Alternative Category names" match in the product feed itself?
Thanks in advance.
Pasha
Hello Pasha,
As long as you know what feed the product is in, I would temporarily remove the mapped category (using a text editor, save the master category name, and the list of alternatives so you can quickly replace them); then delete the master category. Then, import the feed again, at which point the product "Marshal Speaker" will be import with its original category.
You can then find the category from the DB; or alternatively add the following debug code at the bottom of html/product.php:
<?php
print "Category: ".$mainProduct["category"];
?>
...then, you will know which alternative is incorrect, and can remove that from the list before re-instating the master category / alternatives...
Cheers,
David.
Hello Pasha,
That's correct (unfortunately, I guess) - mapping is applied during import; replacing the category in the product record before it reaches the products table.
However, you should (assuming your category mapping is manageable) be able to nip through each of the master categories (the mapped names) and then check through the list for the incorrect entry as it will definitely be there - in other words nothing is going to be mapped unless it appears in one of the "alternative" lists...
Hope this helps...
Cheers,
David.