Importing CSV file of products.
How Do I?
I’m dreaming of importing nearly 250 records into my database by converting a CSV file into an INSERT sql and running a query. To avoid manually adding them one by one…
One of the things I noticed while digging through phpMyAdmin is there are several tables that handle the title, channel_data and grid_data.
I’m assuming this would require separate imports for each?
Please tell me there is someone out there somewhere that has successfully imported data into and EE3 database?
Anything would be helpful and thanks!
You could do this yourself with sql queries, but I would highly recommend using DataGrab, a third-party add on that will take care of all the complexities for you.
https://devot-ee.com/add-ons/datagrab
Yes, I’ve seen that add on and read some of the docs.
One of the issues I foresee is, I’m using the EE3 grid to handle some specific sizes of most of my products, which unfortunately is stored in a separate table than channel_data. It’s stored in its own table called grid.
I’m fairly confident I can add a few products, export the channel_data sql then populate the sql with my entries. It’s associating the grid data to the channel_data and hope they match up. I’m not sure what link the two together.
Thanks