What are the Slack Archives?

It’s a history of our time together in the Slack Community! There’s a ton of knowledge in here, so feel free to search through the archives for a possible answer to your question.

Because this space is not active, you won’t be able to create a new post or comment here. If you have a question or want to start a discussion about something, head over to our categories and pick one to post in! You can always refer back to a post from Slack Archives if needed; just copy the link to use it as a reference..

how can I find a product by it's concrete sku in the backoffice?

U03T08LE3CP
U03T08LE3CP Posts: 185 🧑🏻‍🚀 - Cadet
in Help

how can I find a product by it's concrete sku in the backoffice?

Comments

  • sebastian.larisch
    sebastian.larisch Spryker Customer Posts: 143 🧑🏻‍🚀 - Cadet

    I dont think that is possible by default as the ProductTable is on product abstract level

  • sebastian.larisch
    sebastian.larisch Spryker Customer Posts: 143 🧑🏻‍🚀 - Cadet
    edited March 2023

    @U03T08LE3CP I checked again. It is possible with 2 simple changes. you need to override the configuration of Spryker\Zed\ProductManagement\Communication\Table\ProductTable

    1. It needs the SKU column of spy_product to be searchable:
    $config->setSearchable([
...
SpyProductTableMap::COL_SKU
])

    You can either override the table class or use a ProductTableConfigurationExpanderPluginInterface.

    1. And it needs a join to the SpyProduct table. You can override the expandPropelQuery() of the ProductTable like this:
    protected function expandPropelQuery(ModelCriteria $query): ModelCriteria
{
    $query
       ->leftJoinSpyProduct()
       ->distinct();

    return parent::expandPropelQuery($query);
}

    our content management team will be happy ^^

Categories