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..

Hello Everyone, Query related to custom attribute/field against Category: We have custom data based

Options
U03D56SF151
U03D56SF151 Posts: 7 🧑🏻‍🚀 - Cadet

Hello Everyone,
Query related to custom attribute/field against Category:
We have custom data based on locale like long_description, short_description for category. Also we have custom data on category level like is_erp_active, is_b2b etc.
How we can handle custom attributes value in category?
Do we need to add columns in spy_category table (For is_erp_active, is_b2b) and spy_category_attribute table for (long_description, short_description)? Or there is a other way to handle category attributes?
Also we want to display attribute in admin section.

Please share any idea for it.
Thanks

Comments

  • Alberto Reyer
    Alberto Reyer Lead Spryker Solution Architect / Technical Director Posts: 690 🪐 - Explorer
    Options

    For is_erp_active & is_b2b I would add columns to the spy_category table because you probably will programm against them (e.g.: if ($category->isB2b()) { ... some crazy b2b only stuff }) and these are not different per country/language.

    For long_/short_description you probably want to have the translatable, which is the reason that spy_category_attribute has an fk_locale. So those are better suited as new columns in spy_category_attribute.

    For showing them in the admin/backoffice you can extend the templates from src/Spryker/Zed/CategoryGui/Presentation in your project