I would like to ask for a help or hint, how to update SKU, Product Name, Product URL Key via database. My reference (key) is old sku and I have all data in excel sheet. I have about 600 products to be updated so I don't want to do it manually and my developer quoted me 10 hours of work for creating a code which I don't think is fair for this type of work.
I used to work with Woocommerce for Wordpress and there I usually sent tasks to database and updated what was needed. In Excel I generated task code for each row (ex. UPDATE table_name SET name='value' WHERE id='xx') and copy-past it to myPHPAdmin. I thought to create the same for Magento database and deliver this code to my developer to run in in database.
I can't find where SKU, Product Name and Product URL are stored in Magento database. Could anyone help me with this, please?
Or if you have a suggestion for any other solution, I will be happy for that as well, please.
Magento version: 2.4
Thank you very much in advance.