You are here:  » Category Mapping Q


Category Mapping Q

Submitted by Ch3W on Sun, 2014-11-16 22:48 in

Hi there,

I'm currently trying to include a datafeed into my store that doesn't contain a category in a separate field (great, I know). Instead, they have the productName+category in the same column.

Can anyone suggest some sort of manipulation to get PT to understand the category? Perhaps using filters? Or if not, I'll have to find a way of manipulating the feed prior to import.

Cheers,
Matt

Submitted by support on Mon, 2014-11-17 10:02

Hi Matt,

If there is no specific separation between the product name and the category name, and you have category names that consist of more than one word (e.g. "Automotive Products") this is actually very hard (if not impossible!!) to do, however it would be straight forward to extract just the last word of the product name and use that as the category.

To do this, simply register the product name field as the Category field, and then attach a new Explode filter to the Category field, using a single SPACE character as the Explode Character or String, and -1 as the Return Index, which will then return the last word of the product name.

That might result in the majority of categories being extracted successfully - any that consist of more than one word can then be renamed of course using Category Mapping.

Hope this helps!

Cheers,
David.
--
PriceTapestry.com

Submitted by Ch3W on Mon, 2014-11-17 13:04

Awesome idea. Thanks for the guidance!