The goal is to assign a specific item number from a PSOL catalog to each line
Select attributes that might contain the item number (no exact match required; partial matches are sufficient)
Select one or more attributes that might contain the product's SKU. The attribute does not have to exactly match the SKU in the target catalog. It is sufficient if the attribute string contains the SKU.
There are several options for configuring the search:
Timeout: Maximum time per search operation. This ensures that the search does not get stuck on a specific item. If the search operation remains within the specified time limit, the search proceeds to the next item .
Fuzzy: Fuzzy search. Greater tolerance for discrepancies between the search term and the search result (e.g., misspelled words)
Enabled: Sequential search starting with the catalogs with the highest probability of a match.
Example: If catalog "A" has a reliability score of 90 and catalog "B" has a score of 80, then the search term from catalog "A" is used first, and then (if there was no match there) the one from catalog "B".
Disabled: All catalogs found for the row are used simultaneously. Using this option may reduce search performance .
Only unmatched: When enabled, only the rows without matches are included in the next search.
It is possible to select rows in the preview so that the search is performed only on the selected rows instead of on all of them.
Click the " button to run the search. Depending on the number of products, this may take some time. A progress bar will be displayed during the search.
Explanation of the columns in the preview table:
PSOL catalogs: List of catalogs in which item numbers are searched for (specified in the previous tab).
Article number (CSV): Search string for the selected attributes that should contain the article number
PSOL Result: Contains the catalog and the part number of the search result (if available). Use the PARTdataManager icon to open the result in PARTdataManager.
Quality: Estimated quality of the search result (the higher, the better). An exact match (reverse lookup) results in a quality score of 100%.
Search type: The type of search that led to the search result (reverse lookup, subsearch, fuzzy subsearch)
Info: May contain additional information about the search result, e.g., "Catalog with low confidence (60)." This means that the catalog to which the product was assigned has a low confidence score (here 60). Therefore, it is recommended that you carefully review the result to avoid false positives.
Keep: Checkboxes for specifying which products should be included in the next tab. These are automatically preselected based on the search results. The user can manually select or deselect items.
