Updating Products In Plugin

[zcoyne]

Hi

My main goal is to have a plugin which inserts/updates my products.

All my products are currently in a business management software database which I have SQL access for. What is the best way to go about this?

I guess what I'm looking for is how to add/update products inside of a plugin.

This it the current plan:

• Have the plugin code run on a CRON job

• Connect to the BMS and select the records (which will include the fields that the Magento Import system requires)

• Go line by line and either inserts or updates the record (guessing by checking if the SKU already exists)

Thanks

[Damian Culotta · Accepted solution]

Hi @zcoyne,

Maybe you can take a look to this library: https://github.com/firegento/FireGento_FastSimpleImport2 (you'll find some examples too: https://github.com/firegento/FireGento_FastSimpleImport2_Demo )

You can create a cronjob or a console command to parse your external data an then use the library to insert/update your products.

On the demo link you'll find some examples of how to use the library.

[zcoyne]

Hi

Thanks for the link. This is exactly what I needed.

Where would I store the products as I can see it's ran via composer.

[Damian Culotta]

Using compsoer you'll be able to install the library.

Then you should create your own module/cron/console command and inside your code you could use the library.

[zcoyne]

Thank you