What are the ways to upload and support a large (from 5000 positions) database in an online store?

Question

CMS

The question is quite general, I would like to begin to understand what approaches exist with their pluses and minuses.
Given:
There are price lists of several suppliers, each with several thousand positions.
There is a store CMS, for example, opencart (I suppose there is not much difference in a specific platform if the database in it is on MySQL).
Task: load products into the database, including categories, prices, characteristics, etc.
Plus further support is up to date.
For myself, I found a solution - one of the programs for processing the range of goods (with the functionality of importing from price lists, uploading directly to the store database, linking categories, etc., in general, a whole "combine"). I will not write the name, so as not to be an advertisement. Tembolee that I am relatively satisfied with the program.
It is convenient because most of the functions work "out of the box" - you do not need to write separate programs. But on the other hand, I am strongly attached to this program and it has some glitches.
I searched for analogues - but did not find.
What options for filling and supporting the database of goods in stores are there?
What approaches are practiced, how is it done in online stores with a product base of 5-10-30-50 thousand products?
*** This is not about a simple filling in the base, but about creating a full-fledged base. With categories, with different product characteristics (color, weight, shape, material, etc.). Regular loading from exel does not solve the problem of creating a full-fledged database. In addition, if a supplier changes hundreds or thousands of positions in the price list at once, changing it manually is not an option.***
PS changed the title from "download" to "upload", then there was confusion.

Answer 1

I have more entries in the test)
As you wish, any method will do! It is not enough

Answer 2

50k is not that many records. I would say little. My devices throw their GPS coordinates, there are only 10-50k points per day from the device . Base 200-1000Gb.
Actually, how to drive positions into the base - wagon options.
You can use the same Excel - if I remember correctly, it can connect directly, but if not, you can save it in CSV and slip it into the database via PHPMyAdmin.
MS Access precisely is able to be connected with bases through ODBC. Those. can be made quite loyal to the Front-End user.
It's more of a matter of preference. It is possible after all and to hammer in a SQL file through a notpad.
There is also Navicat, ToadSQL, MySQL GUI.

Answer 3

If everything is from suppliers, then just a script of import + synchronization
is not surprising, it seems
that almost every second store on the Internet works this way

Answer 4

about the program - it's understandable (7 letters in the name))
well, you can write your own plugins in it ...
and so - the usual caching of previous requests for parsing the XML / YML / sitemap file structure or each of the pages and subsequent comparison to detect new positions for their further filling with a frequency of 4-6 hours (on average).