Are there any good solutions for displaying data in tabular form for 40,000 products?

Question

PHP

The client has a large online plumbing store. They have 40,000 products there, so now, in order to massively change something, they unload all these 40,000 products into an Excel spreadsheet, change something and upload it back.
Maybe there are solutions to show them the same data in the form of a table directly in the browser with the ability to edit.
Who faced similar? And maybe someone knows good solutions.
The site is written in php.

Answer 1

JqGrid

Answer 2

And what is the problem with a small admin area where the client can simply update/delete/add a product by finding it using filters or just using the URL on the site?
Or does he need to see all 40,000 clearly?

Answer 3

Use for example Yii2. It has a simple implementation of the CRUD interface that is quickly written and actually what you need

Answer 4

Probably the prices for me .. so do upload the name of the id and the price .. change and upload back ... or the micro admin panel .. it all depends on the needs ...

Answer 5

With a high probability, in addition to this plate, the client has some other software with these products in mind. Most often, in such cases, synchronization with 1C is written, periodically uploading data on the availability of goods and prices to the site.

Answer 6

40,000 products are more convenient to edit in excel or 1c. Don't even think about the web interface. However, it is worthwhile to implement mass change functions. For example, multiply the price of all by x. Or any particular category. Or for some other reason.
A web interface in the form of a table will not be easy for a browser at all when it comes to more than 100 lines. So either with pagination and filters - or excel.
You can link excel or 1c with a database, which is also convenient. To get away from unloading-loading, or rather to simplify it.