3.2 Mapping Products to Categories

Due to the scope of the task of categorizing products, PSS has elected to have the categorization of products done on a product group basis.  This substantially reduces the amount of data that needs to be manipulated.  

Example:  Shoei Neotec Solid Helmet comes in 48 different variations.  Instead of having to list all 48 products out on the csv, we reduce it to one product group.  The category assigned to the group will apply to all of the products in the group.

That being said, upon sign-up you likely opted to use our stock category structure and product mapping in order to get the site filled and to market, quickly.  While the majority of our users elect to use our structure and product mapping as is, some prefer to take on the significant task of custom categorization and product mapping.

Before you begin remapping products you will want to make sure that you have your final category structure already uploaded to PSS.  Once that is done, follow the steps below to remap product groups:

Step 1 - From the PSS Dash, go to File Center > Schedule a Job.  

Webstore Categories and Products - Client: Export Product Mapping

Step 2 - Download

When you request the product mapping file you will put in an email address to notify you when complete.  These files can take some time to generate due to their size.  Once you have been notified that the file is available, go back into File Center and retrieve it.  Download.

Step 3 - Identify the data to work with

This file will have every product group.  We recommend that you work in batches.  Sort the .csv file by Manufacturer or Webstore Category Path and deal with chunks at a time rather than the entire catalog.  1,000-3,000 product groups at a time is a good start.

Start a new .csv file and title it as you wish.  Consider a document title in relation to the date and the type of filtering you used to drill down to these results.

Copy/Paste Values of the mapping file header, onto your new csv.

Copy/Paste Values of the lines of data that you are going to work with, onto your new csv.

Once you have the header and 1,000-3,000 lines of data on your new csv, save your work.

Step 4 - Remapping

The only two columns that we recommend focusing on are webstorecategory.path and webstoreproduct.featured.  Do Not amend .id or .name columns.  Leave them be.  


Phase One

1. Unmap all products on your .csv file.  Clear the values in the category path column.  Hit Save.

2. Go into PSS Dash > File Center.  Schedule a Job.

Webstore Categories and Products - Client: Import Product Mapping

3. This action clears the category path so you can next move forward with a new path.  You will again put in an email address to notify you when the job is complete.  As soon as you import the file with cleared category paths you can begin working on your csv file and creating new category paths.

Phase Two

1. Create your new category paths.  Triple check to make sure that they jive with the category structure that you have previously updated.  Make sure there are no misspellings or unintended spaces.  Hit Save.

2. Go into PSS Dash > File Center.  Schedule a Job.

Webstore Categories and Products - Client: Import Product Mapping

Notes and key info:

*You are able to simply replace the old category path with the desired new path however, this does not provide instant results.  By not clearing the category path first and unmapping the products it will take up to 4 days for the mapping changes to take effect.  In our experience clients prefer quicker results and that is why we advise to first upload a file to unmap and then upload a file to remap.  If you want to keep it simple and don't mind a wait, feel free to skip the steps pertaining to clearing the existing mapping.

*As mentioned above, all header columns must be retained.  Even if they are not being used you must have them present on the csv file or else the upload will fail.

*As you are importing these files you will want to pay attention to their failure and success.  After each import is complete you will be able to review a processing report in File Center.  If a job fails, you will need to correct the cause for failure and re-upload.

*Can I add a product group to multiple categories?

Yes. To do so use the same Category Path column and add both category paths separated by a semi-colon ; with no spaces. Tires>ATV>Mud;Tires>ATV>Sport

*Again, try to work with a small number of product groups at a time.  We advise that you do not try and upload an entire mapping file with minimal changes due to the processing time required to check/revise 60,000+ product groups.  Work in managable batches.  Save your csv files.  Work methodically.

Feedback and Knowledge Base