Who processes price lists in IM?

Question

Electronic commerce

Hello colleagues!
There is a store on OpenCart 1.5.6
There is a supplier who updates his price every 15 minutes and allows you to pick up the price in csv. The weight of the price list is at least 6MB.
There is a need to somehow synchronize this price list with the store.
Tell me who, what uses to process price lists?
Basic requirements:
1. Adding a product
2. Adding pictures by url (this is not so critical, but it doesn't hurt)
3. Disabling a product that was added earlier, but now it is not in the price list.
4. Price
update 5. Attribute update.
6. Ability to work with MySQL.
The main requirement for software is process automation. Those. human participation in the process of updating the price list should be minimal.

Answer 1

parse the price directly into the database. it works for me without problems from 1c xml, there is also from csv from the supplier's website, the only thing that the operator does sometimes is to correct the
ps markup. the parser is run by cron

Answer 2

Self-written updater, launched by cron.
There are no ready-made ones - everyone has everything of their own, there are no standards.

Answer 3

It is logical that you need a custom solution, we use such solutions in several online stores, sometimes working directly with the database when you need frills, sometimes through the api or SDK of the store

Answer 4

Try https://price-matrix.ru/ many functions inside are made for automation.
It might work for you too. But it is necessary to clarify whether it works with opencart.