API for adding categories and products?

[ddev]

Can someone point me in the right direction,

I want to write a script which automates category adding, and will add products with an image and name I have existing in my current MySQL database.

[kuroi]

There's not presently an API for adding products, but there are lots of ways of doing it that don't involve adding them individually.

The least technical is to export you existing data a spreadsheet and massage it into a format that can be imported via the Easy Populate mod.

At the other end of the extreme, your could do a pure SQL conversion writing a SQL script to take data directly from one database to the other using database admin tools. In which case the database schema would probably be helpful.

In practise when we (Kuroi Web Design) do this professionally we tend to find it most manageable to create temporary tables in the target database to the source tables in their original form, then use a php script to implement the data mapping between the two datasets.