Binding products to category

Search and select products, paste SKU list, or use Excel to bind, remove, and export products in the Products tab of category details; step-by-step guide and video.

There are several ways to bind products to a category: search and select the product, paste a SKU list, or upload an Excel file. All are done from the Products tab in category details; from the same tab you can remove products and export the list. This page explains the process step-by-step; the video of the same explanation is below.

<video controls preload="metadata" playsinline width="1920" height="1080" poster="https://files.docs.hebiar.com/videos/console/pim/categories/detail/kategoriye-urun-baglama.en.jpg" src="https://files.docs.hebiar.com/videos/console/pim/categories/detail/kategoriye-urun-baglama.en.mp4"><a href="https://files.docs.hebiar.com/videos/console/pim/categories/detail/kategoriye-urun-baglama.en.mp4">Open the video</a></video>

For other tabs of the category screen see Category detail. Automatic binding by attribute is explained on Binding products to category by rule, sorting on Sorting products in category.

Before you start

  • Regardless of the binding method, the product appears in the category's Products tab: Manual, by SKU list, Excel, binding rule, or AI suggestion.
  • The Binding column shows how the product is bound: Manual for manual, Auto for rule-based binding.
  • Adding from this tab binds the product to the category manually. Rule-bound products are managed by the rule; they cannot be removed by list and their selection boxes are disabled.
  • The category tree is not the same as the site menu; the site menu is managed separately (CMS › Store menus).

Adding by searching and selecting products

  1. In PIM & Catalog › Categories, search and open the category, then switch to the Products tab.
  2. From the Add products menu, select Add by picking products.
  3. Enter the product name, SKU, barcode, or option code in the Search box and click Filter. To search by many codes, use Filter by list.
  4. Mark the products you want to add; you can continue selecting across pages.
  5. Click Add selected. Products appear at the top of the list as Manual.

At the bottom of the window, Add all products binds all products in the setup to the category; use only if you really want this.

Adding by pasting SKU list

  1. From the Add products menu, select Add by SKU list (Excel / paste).
  2. Paste SKUs line by line into the Paste box. Columns copied from Excel are tab-separated; the first column is read as SKU.
  3. Check the number of records read at the bottom of the window and click Add.

Adding by Excel file

  1. In the same window, click Choose file (.xlsx, .csv, .txt) and select your file.
  2. The first column of the file is read as SKU. The header row is also read; the file should contain only SKUs.
  3. Check the number of records read and click Add.

Removing products

  • Individually: mark products, select Remove menu then Remove from category, and confirm.
  • Bulk: from Remove menu select Remove by SKU list (Excel / paste), then paste SKUs or upload a file.

Rule-bound products cannot be removed by list; they are managed by the rule.

Exporting

In the Export menu, Export all (Excel) downloads all products in the category, Export visible page (CSV) downloads only the current page. You can work on the file and reload the list by SKU list.

Checking the result

Added products are listed as Manual in the Products tab; Open in product list opens the same products filtered in the product list. The record is first written to PIM; it appears on the site when the scheduled transfer task runs. To send immediately, you can trigger the transfer task from the Tasks screen.

Common situations

  • Symptom: Number of records read is more than expected. The file may have a header row or another column in the first row; leave only SKUs in the first column.
  • Symptom: I cannot select or remove the product by list. The product is bound by rule (Auto); change the rule.
  • Symptom: The product I added does not appear in the category on the site. The transfer task has not run yet or the product is not for sale.