Import new and update products and their attributes with a CSV file and cron job Magento2

[vartika_sharma]

I am using Magento 2.3.3 and wants to import products using cron and csv. I have google Sheet which contains all products data and sheet's data changes continuously. So I have to run a cron every day which updates product price, qty and some attributes values.

1. I've generated csv from sheet and it is being successfully imported manually.
2. Then I tried to import csv using cron by hitting some import functions existing in module- import-export. But didn't work and everything messed up.
3. Now I'm trying to import products by directly save them in database.

Is it possible to do that? Or is their another way?

Checked this https://magento.stackexchange.com/questions/214079/magento-2-import-new-and-update-current-products-... also but didn't understand that much.

[Manish Mittal]

@vartika_sharma 

This feature part of Magento 2 commerce to schedule import product auto. You can take reference to do the same. 

https://docs.magento.com/user-guide/system/data-schedule-import.html

Apart from that sharing few plugin, please look it if that can help you:

https://www.mag-manager.com/magento-automated-product-import/

https://github.com/firebearstudio/importexportfree

https://www.beecom.io/post/importing-products-the-how-to-guide