Advice needed for daily product import (Easy Populate, PHP + MySQL or ??)

[yourguide]

I have a CSV generated daily from a MAS200 database.
The file is then uploaded to my server and currently a PHP script imports the file into an existing MySQL database Table.

I would like to import information from either the MySQL table or directly from the CSV into ZenCart for adding and updating products.

What would be the best way to achieve this?
I have Zen v1.3.9d and Easy Populate 1.2.5.7.csv

The CSV file is not in the correct format for easy populate to import... not sure if I should attempt to go that route then run a scheduled EP import somehow... or if a scheduled PHP script that copied info from one table to another would be better... or if there is some other way I am not thinking of.

All ideas are welcomed! Thanks!

[kobra]

I would like to import information from either the MySQL table or directly from the CSV into ZenCart for adding and updating products.

What would be the best way to achieve this?
I have Zen v1.3.9d and Easy Populate 1.2.5.7.csv

The CSV file is not in the correct format for easy populate to import... not sure if I should attempt to go that route then run a scheduled EP import somehow

It will be cut & paste into a easy populate file

A VB script can automate it eliminating ones that no longer exist and adding new ones while updating price on others