877 views
In this article, we will look at some of the ways in which we can query Solr for commerce catalog items in the Sitecore Master and Web indexes, and the Commerce CatalogItemsScope index.
Catalog Documents
Master and Web Indexes
| Query By | Query String |
| Name | commercesearchitemtype_t:”Catalog” && name_t:”<name>” |
| Display Name | commercesearchitemtype_t:”Catalog” && _displayname:”<display name>“ |
| Entity Id | catalogentityid_t:”Entity-Catalog-<catalog entity id>“ |
| Sitecore Id | sitecoreid_t:”<Sitecore id>“ OR _group:”<squashed Sitecore id>” |
Commerce CatalogItemsScope Index
| Query By | Query String |
| Name | entityid:Entity-Catalog-* && name:”<name>“ |
| Display Name | entityid:Entity-Catalog-* && displayname:”<display name>“ |
| Entity Id | entityid:”Entity-Catalog-<friendly id>” OR entityid:”<entity id>” |
| Sitecore Id | sitecoreid:”<Sitecore id>” |
Category Documents
Master and Web Indexes
| Query By | Query String |
| Name | commercesearchitemtype_t:”Category” && _name:”<name>” |
| Display Name | commercesearchitemtype_t:”Category” && _displayname:”<display name>“ |
| Entity Id | catalogentityid_t:”Entity-Category-<entity id>“ |
| Sitecore Id | sitecoreid_t:”<Sitecore id>“ OR _group:”<squashed Sitecore id>“ |
Commerce CatalogItemsScope Index
| Query By | Query String |
| Name | entityid:Entity-Category-* && name:”<name>“ |
| Display Name | entityid:Entity-Category-* && displayname:”<display name>“ |
| Entity Id | entityid:”Entity-Category-<friendly id>“ OR entityid:”<entity id>“ |
| Sitecore Id | sitecoreid:”<Sitecore id>“ |
Sellable Item Documents
Master and Web Indexes
| Query By | Query String |
| Name | commercesearchitemtype_t:”SellableItem” && _name:”<name>“ |
| Display Name | commercesearchitemtype_t:”SellableItem” && _displayname:”<display name>“ |
| Entity Id | catalogentityid_t:”Entity-SellableItem-<entity id>“ OR productid_t:”<entity id>“ |
| Sitecore Id | _group:<Sitecore id> |
Commerce CatalogItemsScope Index
| Query By | Query String |
| Name | entityid:Entity-SellableItem-* && name:<name>“ |
| Display Name | entityid:Entity-SellableItem-* && displayname:”<display name>” |
| Entity Id | entityid:”Entity-SellableItem-<friendly id>“ OR entityid:”<entity id>“ |
| Variant Id | variantid:”<variant id>“ |
| Variant Display Name | variantdisplayname:*<variant display name>* |
| Sitecore Id | sitecoreid:”<Sitecore id>“ |