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. I've generated csv from sheet and it is being successfully imported manually. 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. Now I'm trying to import products by directly save them in database. Is it possible to do that? Or is their another way?

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

Magento Asked by saurabh garg on October 2, 2021

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.

I’ve generated csv from sheet and it is being successfully imported manually.
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.
Now I’m trying to import products by directly save them in database.

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

cron csv importexport magento cron magento2.3

Add your own answers!

Ask a Question

Get help from others!