Build your feed, update prices & stocks

Build your feed, update prices & stocks

Categories mapping to your site’s categories

It so happened that in most cases there are no categories in the Supplier’s Feed, but the opposite situation also happens — they are.

When a supplier provides in its feed and categories, it becomes necessary to compare these categories with their categories, with the categories of the Main Feed. This is not an obligatory action if you have your own generated feed, and you only need to update prices and quantities.

When you need it

This is relevant when copying a supplier’s feed to a Main Feed in the following cases:

  • When you create your Main Feed from supplier’s feed (you do not have your own feed), and categories are needed here.
  • Adding (manual or automatic) new products from Supplier’s Feed to Main Feed (to your feed). Products need to fall into the correct categories for your feed, and this setting can help with this.

For this to work, the Supplier’s Feed must be loaded with categories. Whether there are categories in the Supplier’s Feed can be checked by going to the desired Supplier’s Feed and pressing the Categories button, there will be something like this picture:

 

If there are categories, you can make settings for the mapping of these categories to your categories — the categories of the Main Feed.

How to do it

In the PSQQQ menu, select Functions → Copy supplier feed into Main feed:

 

A dialog box will open, in which you need to select the Supplier’s Feed from which we will copy the products to the Main Feed and for which you need to configure the mapping of categories. Choose from the list of Supplier’s Feed and download the template (list of categories) for customization:

 

A template is an Excel file with a list of categories. In the second column, you need to indicate the name and nesting of your categories, where you need to transfer products from the Supplier’s Feed to the Main Feed (your feed).

If the category and products do not need to be moved, leave the cell empty:

 

After editing the file, save it and load it back into the system for the required Supplier’s Feed:

 

Example categories mapping

 

 1 Block  — the names were changed with nesting categories

 2 Block — empty cells, these categories will not be copied.

3 Block — if you need to combine several categories into one, write the same name for the destination category.