You are here:  » Mapping Category: how to do (correctly)?

Active Forum Topics

Mapping Category: how to do (correctly)?

Submitted by magnaromagna on Wed, 2020-12-30 14:07 in

under /PT I created some hierarchy categories, like
- wines
-- wines/white wines
-- wines /red wines

and after importing a feed, I was able to map through Configure and Reverse mapping
(for example I see Chardonnay wines mapped under drink/wines/white wines)
then in wordpress / settings, I run Import, and I correctly see products under posts. The issue:
1) in post list: as category, I don't see the category I created (example: "white wines") but I see the merchant category (example: "home white Chardonnay Pinot")
2) if I navigate on "shopping" I see my categories (wines / white wines, etc.) but they are empty

I'm missing some steps?

3) under PT / Category Hierarchy Mapping, after clicking on Configure, if I use search using - for example - "wine" it not show me all other categories but it seems limited to 5 result

Thank you for help me

Submitted by support on Thu, 2020-12-31 10:10

Hi and welcome to the forum!

It should just be that you need to re-import all feeds as the category value is only set at import time, simply creating a new category in the hierarchy and then mapping feed categories to it won't immediately make products appear in search / navigation until the next import, but if your products still aren't appearing after import let me know and I'll check that out further with you.

Regarding the number of results shown when searching for feed categories to map on the configuration page, this is limited which is why only a few results are shown but this can be removed easily. To do this, edit admin/helper.php and look for the following code at line 22:

    $sql = "SELECT DISTINCT(".$field.") FROM `".$config_databaseTablePrefix."products` WHERE ".$field." LIKE '%".database_safe($q)."%' ORDER BY ".$field." LIMIT 6";

...and REPLACE with:

    $sql = "SELECT DISTINCT(".$field.") FROM `".$config_databaseTablePrefix."products` WHERE ".$field." LIKE '%".database_safe($q)."%' ORDER BY ".$field;


Submitted by rlxd on Mon, 2021-03-15 14:22

Dear David i have the same problem as the topic creator.

In the admin home i multiple times pressed import all. Then in Wordpress reimported the products, and still the original (non-mapped) categories show in the assigned categories.

Thanks in advance

Submitted by support on Tue, 2021-03-16 07:57


That sounds like it may be a caching issue - if you have any caching plugins installed it might be worth temporarily disabling them or if supported run a purge function each time you import so that the latest dynamic data from the Price Tapestry database is displayed - that might be all it is...