You are here:  » How to organize product mapping listing


How to organize product mapping listing

Submitted by Bakalinge on Wed, 2013-11-27 16:49 in

Hi David,

I started recently to map a lot of products manually, but I encounter difficulties with the management of this task : with a list of hundreds (and probably soon thousands) of products, it's hard to identify which products have been mapped or not. I was wondering if there were a way to classify products (by category for example but I'm open to any idea) in "Product mapping" section, as it would significantly help to do the job...

Thank you !

Bak

Submitted by support on Wed, 2013-11-27 17:17

Hello Bak,

I see you're already using scripts to identify unmapped products so I think this is a different requirement. Would category be for example a simple "completed / not completed" that you set manually to indicate Product Mapping entries that you are currently working on so that they can be located easily in the list (which could be filtered by this marker for example)?

Cheers,
David.
--
PriceTapestry.com

Submitted by Bakalinge on Wed, 2013-11-27 21:32

Hi David,

Sometimes I need to check if a unmapped product already exists in product mapping, but it can take a while before I find it because the name can be slightly different. If the product mapping has a filter (or if they are indexed in a way), then it's easier. Would it be possible for product mapping to display in front of each product the category it belongs to (and then I would just have to add a multi-column sorting with Jquery for example) ?

Thanks !

Bak

Submitted by support on Thu, 2013-11-28 08:58

Hello Bak,

If by 'category' you mean the Custom Category override field as found on the configuration page for a mapping then it is already included in the SELECT that generates the index on the Product Mapping home page, so in admin/productsmap.php if you look for the following code at line 64:

  print "<th class='key'>".$productmap["name"]."</th>";

...and REPLACE with:

  print "<th class='key'>".$productmap["name"]."</th>";
  print "<td>".$productmap["category"]."</td>";

...that will give you a Category column on the table. If instead you wanted to pull the category from the product database itself, that's straight forward in principle but bear in mind that unless Category Mapping has been applied there is not necessarily a 1-1 mapping between product name and category, but let me know if that is what you want to do (the column could show all categories from the database for that product of course, which would in-fact double as a guide to what Category Mappings to add...!)

Cheers,
David.
--
PriceTapestry.com

Submitted by Bakalinge on Thu, 2013-11-28 22:00

Hi David,

Perfect, exactly what I needed :)

Thanks !

Bak