Anyone help me on extend the Inventory. Actually, I need to add custom fields in Inventory. Please l

U03DBF2H9DY

Anyone help me on extend the Inventory. Actually, I need to add custom fields in Inventory. Please let me know how we can add custom fields.

Alberto Reyer

As with any other db table you want to extend: https://docs.spryker.com/docs/scos/dev/back-end-development/data-manipulation/data-in[…]n/structural-preparations/extending-the-database-schema.html

U03DBF2H9DY

Yes, I need to add the custom fields in database.

U03DBF2H9DY

I know the schema part, I have already extend the customer profile, discount and orders, But I need to know how we can extend the Inventory. Is there any specific module schema ? or we need to create a new module or schema file for that ?

Alberto Reyer

What do you mean by extending the Inventory then?
Do you want to extend the form in Zed, how a inventory is calculated or anything else?
The more specific your question is the easier it is to give a specific answer

U03DBF2H9DY

Actually, I want to add two columns in Inventory table for example :- A quick extension can be adding two attribute types in inventory:
• awanooDescription (String)
• awanooDynAttributes (HashMap) ==> key is string, and value is string

U03DBF2H9DY

And yes from the Zed.

U03DBF2H9DY

For now just need to add two columns.

Alberto Reyer

To my knowledge there is no inventory table in Spryker.
Only spy_availability (src/Pyz/Zed/Availability/Persistence/Propel/Schema/spy_availability.schema.xml and spy_stock (src/Pyz/Zed/Stock/Persistence/Propel/Schema/spy_stock.schema.xml).

U03DBF2H9DY

Thank you 🙂

U03DBF2H9DY

@UL6DGRULR I have one more question :- Could you please let me know how inventory data stored for product in spryker ?

Alberto Reyer

https://docs.spryker.com/docs/scos/dev/feature-walkthroughs/202108.0/inventory-manage[…]re-walkthrough/inventory-management-feature-walkthrough.html and more detailed in https://docs.spryker.com/docs/marketplace/dev/feature-walkthroughs/202108.0/marketplace-inventory-management-feature-walkthrough.html#modul[…]-graph (especially if you use more than one warehouse or a combination of a warehouse and dropshipping)

U03DBF2H9DY

Ok, Got you. Thanks

U03DBF2H9DY

@UL6DGRULR We want to extend the table but we want to add column that refer to multiple key value pair(hashmap) so what is the best approach ?

Alberto Reyer

Propel provides type="ARRAY" for those: http://propelorm.org/documentation/reference/schema.html#other-types

U03DBF2H9DY

Ok, Thanks!! Again 🙂

U03DBF2H9DY

@UL6DGRULR Now we have created the some fields in database. Can you please let me know how we can render that fields in backend and front side. If you let me know the process in detail, I will really appreciate it.

Alberto Reyer

For displaying those fields you can implement the given plugins provided by https://github.com/spryker/availability-gui-extension/tree/master/src/Spryker/Zed/AvailabilityGuiExtension/Dependency/Plugin (*Extension modules in Spryker are used to show which extension points are available, similar to the Symfony contracts).

U03DBF2H9DY

Great!!

Alberto Reyer

On Frontend/Yves side the https://github.com/spryker-shop/availability-widget is what I would look into (see https://github.com/spryker-shop/availability-widget/blob/master/src/SprykerShop/Yv[…]onents/molecules/availability-product/availability-product.twig). Sadly there is no plugin architecture yet to extend it

U03DBF2H9DY

Okay..

U03DBF2H9DY

@UL6DGRULR My last question is how we can extend
Internalization
State Model
We also need to add some custom fields.