How to do price update from excel file in MySQL?

Question

PHP

I scored all the prices in the database, but now I don’t understand how to make normal synchronization. Maybe there are some ready-made solutions? Or do you have to write everything yourself? There are about 300 prices in the database. It is not desirable to prescribe each cell from where to take the price.

Answer 1

For these purposes, a unique identifier (article) of the product is used. Due to this identifier, you update the values ​​​​in the database.
To work with excel, you can use this https://code.google.com/p/php-excel-reader/