Create Plugin Requires Creating Custom Database tables

Hello guys,

I want to create a plugin that requires creating custom database tables, in order to save data and retrieve on public store to work.

should I add SQL files with tables scripts and add them to the plugin project, then read the sql files and create tables upon installing the plugin?

Any Ideas or hints to kick-start would be appreciated.

I found  a plugin that does what I want.. Nop.Plugin.Feed.GoogleShopping

If anyone need it :)

You can use dbContext in plugin and create service for get and insert records in db table.

You can take reference from Nop.Plugin.Pickup.PickupInStore plugin.

omaani wrote:

Please check the below docs

https://docs.nopcommerce.com/display/en/Plugin+with+data+access

this not working in version 4.40

[email protected] wrote:
create a domain, SchemaMigration & PaymentInfoValidator inside a plugin. check existing domain code by reference.

You might want to have a look at the Nop.Plugin.Shipping.FixedByWeightByTotal Plugin which creates a custom database table