In my M2 store I have over 200k products. They were added manually through API (
Nowadays prices of my products are changing frequently and I need to update all of them when I receive price list from my supplier.
What would be the best and quickest way to update prices of all my products? API calls would take too much time.
CSV import using M2 backend was giving me some errors in the past due to large amount of products.
Any idea? One think which comes to my mind is to write a php script to parse my price list CSV file and make directly SQL queries to a database.