{"section":"tutorials","requestedLocale":"en","requestedSlug":"mapping-categories-and-brands-for-the-marketplace","locale":"en","slug":"mapping-categories-and-brands-for-the-marketplace","path":"docs/en/tutorials/sellers/categories-and-brands/mapping-categories-and-brands-for-the-marketplace.md","branch":"main","content":"When a store acts as a marketplace, it is important to remember that the sellers' catalogs have a completely independent structure. In order to make definitions between both catalogs compatible, [categories](/en/docs/tracks/categories-concept-definition), [brands](/en/docs/tracks/brands-concept-definition) and [specifications](/en/docs/tracks/specifications-concept-definition) have to be mapped when sellers:\n\n- Send their products for the first time  \n- Send products with data that has not been mapped before  \n\nThis allows entering the products sent by the seller with equivalent information in the marketplace catalog. It is important to note that sending a new item whose information is not yet mapped does not modify values already mapped in the marketplace. To map brands, categories, and specifications:\n\n 1. In the *Marketplace* section of your admin, go to the __Sellers__.  \n 2. Click __Categories and brands__.  \n 3. Click __New mapping__.  \n 4. Select a seller from the dropdown and click __Add__.  \n 5. For the seller that was added to the panel:  \n  a. [Map the categories](/en/docs/tutorials/mapping-categories-and-brands-for-the-marketplace#mapping-categories).  \n  b. [Map the brands](/en/docs/tutorials/mapping-categories-and-brands-for-the-marketplace#mapping-brands).  \n  c. [Map the specifications](/en/docs/tutorials/mapping-categories-and-brands-for-the-marketplace#mapping-specifications).  \n 6. Click __Update mapping__.  \n\n## Mapping Categories\nAfter the seller sends the products to the marketplace, the marketplace has to map the categories. Matching between marketplace and seller categories is done through a template.  \n\n### Using the template\nYou can download the updated template by clicking the Download current mapping table button in the seller you added to the Categories and brands page. The template contains the following columns: \n\n| Column | Name                               | Description                                                                                                                                            |\n|--------|------------------------------------|--------------------------------------------------------------------------------------------------------------------------------------------------------|\n| A      | Marketplace categories             | This is the category name in the VTEX marketplace. The number in square brackets is the marketplace category ID.                                       |\n| B      | Categories sent by seller          | This is the category name in the seller's catalog. If the mapping has not been done before, this column will have empty cells.                         |\n| C      | Unmapped categories sent by seller | Seller categories that have not been mapped yet. If this column is empty, it means that the seller has not sent their products to the marketplace yet. |\n\nTo complete the template:  \n\n1. Check all the categories in __column A__. These are the values that you will match with the seller's categories from column C in step 2.  \n2. Fill __column B__ with the matching category from __column C__.   \n3. Repeat the process until __column C__ is empty.  \n4. Save the template __XLS file__.  \n5. In *Categories mapping*, upload the updated template using the __Change categories mapping button__.   \n\n> ℹ️ If the program you used for opening the template uses semicolons (“;”) as separators, you have to replace them with commas (“,”) before importing the file.\n\n### Example\nIn this example, we downloaded the current template, which has the following values in the columns:\n\n| Marketplace categories                  | Categories sent by seller | Unmapped categories sent by seller |\n|-----------------------------------------|---------------------------|------------------------------------|\n| [3] Women \\| [2] Accessories \\| [8] Bag |                           | <br />Jeans / Shorts                 |\n| [3] Women \\| [28] Jeans                 |                           | Beach / Bags                       |\n|                                         |                           | Jeans / Bermudas                   |\n\nWe will map the seller's categories, trying to find the best possible match with the existing marketplace categories. After the mapping is done, the template will look as follows:\n\n| Marketplace categories                  | Categories sent by seller | Unmapped categories sent by seller |\n|-----------------------------------------|---------------------------|------------------------------------|\n| [3] Women \\| [2] Accessories \\| [8] Bag | Beach / Bags              | <br />                               |\n| [3] Women \\| [28] Jeans                 | Jeans / Shorts            |                                    |\n| [3] Women \\| [28] Jeans                 | Jeans / Bermudas          |                                    |\n\n> ℹ️ Note that more than one category in the seller's catalog fell in the same marketplace category (Women / Jeans). In that case, duplicate the row in **Marketplace categories** and paste the values from *Unmapped categories sent by seller* into each duplicated row.\n\n## Mapping Brands\nAfter the seller [sends the products to the marketplace](/en/tutorial/entendendo-a-catalogacao-de-produtos-para-o-marketplace), the marketplace has to map the brands. Matching between marketplace and seller brands is done through a template.  \n\n### Using the template\nYou can download the updated template by clicking the Download current mapping table button in the seller you added to the *Categories and brands* page. The template contains the following columns: \n\n| Column | Name                           | Description                                                                                                          |\n|--------|--------------------------------|----------------------------------------------------------------------------------------------------------------------|\n| A      | Marketplace brands             | This is the brand name in the VTEX marketplace. The number in square brackets is the marketplace brand ID.           |\n| B      | Brands sent by seller          | This is the brand name in the seller's catalog. If the mapping has not been done before, this column will be empty.  |\n| C      | Unmapped brands sent by seller | Seller brands that have not been mapped yet.                                                                         |\n\n1. Check all the brands in __column A__. These are the values that you will match with the seller's brands from column C in step 2.  \n2. Fill __column B__ with the matching brand from __column C__.   \n3. Repeat the process until __column C__ is empty.  \n4. Save the template __XLS file__.  \n5. In *Brands mapping*, upload the updated template using the __Change categories mapping__ button.   \n\n> ℹ️ If the program you used for opening the template uses semicolons (“;”) as separators, you have to replace them with commas (“,”) before importing the file.\n\n### Example\nIn this example, we downloaded the current template, which has the following values in the columns:\n\n| Marketplace brands | Brands sent by seller | Unmapped brands sent by seller |\n|--------------------|-----------------------|--------------------------------|\n| Adidas             |                       | Animale                        |\n| C&A                |                       | Farm                           |\n| Animale            |                       |                                |\n| Farm               |                       |                                |\n\nWe will map the seller's brands by matching the existing marketplace brands with the ones sent by the seller. After the mapping is done, the template will look as follows:\n\n| Marketplace brands | Brands sent by seller | Unmapped brands sent by seller |\n|--------------------|-----------------------|--------------------------------|\n| Adidas             |                       |                                |\n| C&A                |                       |                                |\n| Animale            | Animale               |                                |\n| Farm               | Farm                  |                                |\n\nNote that not all marketplace brands had a match in this case. This varies depending on the seller's product offering and the variety of marketplace brands.\n\n## Mapping Specifications\n\nSpecifications are additional properties that can be added to your store's products or SKUs. After the seller sends the products, the marketplace has to map the product and SKU specifications. Mapping is done manually through the Categories and brands page to match the fields between the marketplace and the seller. \n\nWhen a seller submits a product with a specification that has not been mapped by the marketplace and the marketplace [approves](/en/docs/tutorials/manual-sku-cataloging) this product, a new SKU is created, even though there is already a SKU in the marketplace catalog to associate it with. The unmapped specification (for example, color) or its value (for example, yellow) will be registered as an **unstructured attribute** in the marketplace catalog, but **will not be displayed in the marketplace storefront**. Therefore, it is necessary to map all the specifications and their values so that they are visible to buyers. You can view the unstructured attributes in your Admin. Go to *Catalog > Products and SKUs > choose an item from the list > click the Specifications tab*.\n\nTo map product and SKUs’ specifications, follow the steps below:\n\n1. In *Specifications mapping*, click __Map product/SKU specifications.__\n2. In the Seller column, enter the specification value that matches the __seller__ catalog.     \n3. In the *Marketplace* column, enter the value that matches the specification in the __marketplace__ catalog. You can find it by navigating the category tree available in Products > Catalog > Categories.      \n4. Click __Add new entry__ to repeat the process until all seller specifications have a match.      \n4. Click __Update mapping__.       \n\n### Example\nWe will map the seller's specifications by matching the existing marketplace specifications with the ones found in the seller catalog. Note that all divergent specifications have to be mapped, even if the only difference is word capitalization. After the mapping is done, the table will look as follows:\n\n| Seller | Marketplace |\n|--------|-------------|\n| VOLTS  | Volts       |\n| 10     | 12          |\n| size   | Size        |\n| Woman  | women       |\n| l      | L           |\n| NUMBER | Number      |\n\n### Specifications and received SKUs approval\n\nSpecification mapping is applied on the marketplace website in different ways, depending on the actions done in the [Received SKUs](/en/tutorial/entendendo-a-catalogacao-de-produtos-para-o-marketplace) module when approving seller SKUs:\n\n- __Link to existing SKU:__ the specification mapping is ignored by the marketplace system because the SKU already exists in the marketplace with the same specifications.    \n- __Link to an existing product:__ the specification mapping is only considered for SKU specifications because the product specifications already exist in the marketplace.    \n- __Approve as new product:__ the mapping is applied in full for product and SKU specifications coming from the seller.    \n\n## Learn more\n\n- [Approving products](/en/tutorial/sugerindo-e-aprovando-skus/)  \n- [Creating a trade policy](/en/docs/tutorials/creating-a-trade-policy)    \n- [Trade policy for marketplaces](/en/docs/tutorials/configuring-a-marketplace-trade-policy)"}