Data Mapping

Everything about attributes mapping: categories, manufacturers and product data.

Manufacturer / Vendor Mapping

Manufacturer mapping is needed when you have more than one data supplier. Different suppliers sometimes give different naming to product brands. Therefore if you want to have good quality products catalog and avoid duplicates (HP, HP Corp., Hewlett Packard) - you must first need to map them.

Step 1. Create your Manufacturers

Before you start mapping, you need to create you own categories. Navigate to Data mapping → Manufacturer mapper → My manufacturers

To add a new manufacturer, click "Add manufacturer" and enter Manufacturer code and label.

Add Manufacturer

Click "Create" and your Manufacturer is saved.

If you plan on creating many manufacturers - send an email to support@wise2sync.com with attached XLS document and we will be happy to import them for you.

Step 2. Map Manufacturers

Navigate to Data mapping → Manufacturer mapper → Supplier manufacturers. There you see all the brands that Wise2Sync has found in your product feeds and suppliers.

Find the manufacturer you want to map and click "Edit" icon in the corresponding row. Use "Alias" field to find you manufacturer and click Update.

Map manufacturer

After you are done mapping, you can use manufacturer attribute for pricing rules, product filtering etc.

We have improved our mapping feature!  If you wish to try our new auto-mapping option follow the guidelines here

Category Mapping

Same as with product brands, category mapping is needed to standardize your products catalogue. This is used to make sure products from different data feeds fall into the same category tree.

Manual category mapping

Step 1. Create your categories list

Before you start mapping categories, you need to create your own category list. If you are starting fresh, we recommend creating a categories list first in a spreadsheet. Give categories some meaningful names, like:

Once you know your categories tree, navigate to Data mapping → Category mapper → My categories and click "Add category".

Pop-up will appear, where you can enter two values:

Click "Create" and your new category is saved.

If you have a list of categories from your existing store, you can use Auto category mapping feature. You can import the filled-in CSV yourself or send it to support@wise2sync.com and we will make an import for you to speed up the process.

Step 2. Map categories

Navigate to Data mapping → Category mapper → Supplier categories. Here you will see a list of all categories that Wise2Sync has found in suppliers feeds. All categories are also split by data sources.

  1. Choose a data source (supplier) tab
  2. Find a category you want to map
  3. Click on Edit icon in the corresponding row and a pop-up will open:

Category mapping

Use the Alias field to find your created category in Step 1.

Some product feeds or suppliers have very extensive categories of trees. Sometimes it can reach 1000 and more categories per supplier/data feed. You can use a bulk attribute mapper to speed up the process:

  1. Use the search field to narrow the categories list
  2. Select desired categories
  3. Choose the "Edit" action and click "Submit".

Category bulk mapping

All the selected categories will be mapped at once.

Auto category mapping

Step 1. Download CSV file with supplier categories list.

The fast way to map all categories is to import them. Before you start importing categories, you need to download the supplier category list from Wise2Sync. Navigate to Data mapping → Category mapper → Supplier categories. Here you will see a list of all categories that Wise2Sync has found in suppliers feeds. All categories are also split by data sources. In CSV file with categories, you will see column supplier name so you will be able to map all categories from all data sources at once.

  1. Press Import/Export icon on the top right corner
  2. Click on Export and a pop-up will open
  3. Choose default if you have not created any category sets yet and press export:

image-1627993905146.png

image-1627976727795.png

Step 2. Map your categories with supplier categories in CSV file.

Columns Supplier name and Supplier category must stay the same. Make changes only in Client category code and Client category label columns. If you use Shopify or Woocommerce in column Client category code put category ID. Check Woocommerce and Shopify category mapping. For other platforms, you can use the same category name in both columns. 

image-1627994764276.png

Step 3. Import your categories.

After you are done with your categories mapping in CSV file you can import it. Navigate to Data mapping → Category mapper → Supplier categories.

  1. Press Import/Export icon on the top right corner
  2. Click on Import and a pop-up will open
  3. Choose default if you have not created any category sets yet and press Upload CSV file:
  4. Select file you want to import (be sure you choose the right file because after import you will not be able to redo changes) and press Import:

image-1627979603634.png

You will see if the file was uploaded successfully and categories mapped as in CSV file.

image-1627994825038.png

After you are done mapping you will be able to use your categories for product filtering, price margins etc.

Attribute Mapping

By default, Wise2Sync maps main product information like brand, manufacturer, price, stock level etc. However, additional product information like delivery term, weight, dimensions etc. can be useful in your export as well. In this article we will explain how to map these attributes so this data can be used in export profiles.

Step 1. Create desired attributes list

Navigate to Data mapping → Attribute mapper → My attributes. Here you will see a list of already mapped attributes. Click "Add attribute" and a pop-up will open:

Add attribute

After you click "Create" a new attribute will be saved. Repeat this step for all desired attributes.

Step 2. Map attributes

Navigate to Data mapping → Attribute mapper → Supplier attributes where you will see all possible product attributes from your suppliers / data feeds. Column alias shows the connection between supplier attributes and your attributes. Notice the price, stock etc. are already mapped.

Use a search field to find desired attribute and click Edit icon in the corresponding row. A pop-up will open. Use "Alias" field to find an attribute you created in Step 1.

 

Manufacturer / Brand auto-mapping

This feature will speed up the Manufacturer mapping procedure. It would collect all available manufacturers / brands from your suppliers and will create related records in the Wise2Sync app. 

Go to Wise2Sync → open “Supplier Manufacturers” → click on “Auto map manufacturers” button in the top right corner.

image-1704809830993.png


The message will pop up prompting you to click “Yes” option. Once you click on "Yes” option all your manufacturers will be collected and mapped.

image-1704809881191.png

You can open now "My Manufacturers" and you can see that all values were created automatically, you do not need to create them manually. However, you can edit Labels if needed. 

 

After you are done with your mapping, you can use manufacturer attributes for pricing rules, product filtering, etc.

Category Import / Export

Here we will show you how to import your own categories. If you have a list of categories from your existing store, you can import them using CSV file.

Step 1. Download CSV file with supplier categories list.

Before you start importing categories, you need to download the supplier category list from Wise2Sync. Navigate to Data mapping → Category mapper → Supplier categories. Here you will see a list of all categories that Wise2Sync has found in suppliers feeds. All categories are also split by data sources. In CSV file with categories, you will see column supplier name so you will be able to map all categories from all data sources at once.

  1. Press Import/Export icon on the top right corner
  2. Click on Export and a pop-up will open
  3. Choose default if you have not created any category sets yet and press export:

image-1627993905146.png

image-1627976727795.png

Step 2. Map your categories with supplier categories in CSV file.

Columns Supplier name and Supplier category must stay the same. Make changes only in Client category code and Client category label columns. If you use Shopify or Woocommerce in column Client category code put category ID. Check Woocommerce and Shopify category mapping. For other platforms, you can use the same category name in both columns. 

image-1627994764276.png

Step 3. Import your categories.

After you are done with your categories mapping in CSV file you can import it. Navigate to Data mapping → Category mapper → Supplier categories.

  1. Press Import/Export icon on the top right corner
  2. Click on Import and a pop-up will open
  3. Choose default if you have not created any category sets yet and press Upload CSV file:
  4. Select file you want to import (be sure you choose the right file because after import you will not be able to redo changes) and press Import:

image-1627979603634.png

You will see if the file was uploaded successfully and categories mapped as in CSV file.

image-1627994825038.png

After you are done this you will be able to use your categories for product filtering, price margins etc.

 

Category Set

Category sets are useful to use when there is more than one export profile used for different webshops.

Once the categories are created and mapped as per steps in this article Category Mapping. For the new export files that go to a different website, the categories set need to be created:

Go to the Wise2Sync dashboard and choose the "Category Set" option:

Categorie-set.png

In the "Category Set" page click the "add category set" option, on the right-hand side top corner.  The window will pop up prompting you to create the "Category Set".

create-new-category-set.png

Add the ID and Label which is the name of the set and click create.

Next, go to "Supplier Categories" and select the Category Set that you just created.

new-website.png

This will open the supplier categorie's page that are not mapped. Map them with the your categories that are created.

Once this done, you can use your new category set in the export file in the preference tab:

xport-file.png

Some of your categories might have ID number which is already in use, especially in Woocommerce platform. Ask you developer to "incriment the category ID number" in the Woocomerce admin panel.

 

Setting category priorities

In some cases, one product can belong to a few categories. Here we will explain how to prioritize the categories in Wise2Sync.

One product belongs to a few categories

Some suppliers add one product to a few categories, for example, your product is in the "Sell Out" and "PC and servers components" categories.

image-1605861635970.png

For instance, you want to prioritize the  "Sale Out" category.

Go to → Categories→My Categories→edit button. 

Category-image.png

In the priority field for the higher category add the highest number, let's say 100. That way this category in the export file will be exported first, followed by the next category.

image-1605863502563.png

If you are planning to prioritize more categories in the future make sure you leave gaps in between the numbers, so you could organize the priorities easily.