Calling Developers!
We are reenergizing our code contribution process! Learn More

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?

Options
U03T08LE3CP
U03T08LE3CP Posts: 185 🧑🏻‍🚀 - Cadet

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

Comments

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

    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
    Options

    @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 ^^