I have a store selling computer equipment and I want to include the products of a supplier in my articles. The provider provided me with an xml which will import with PHP. I can read it without problem but I am interested to know what tables I have to affect so that the products can be displayed in my store.
Just recently I have developed an import system through CSV. I suggest you forget about tables and use the Product object. He will take care of playing the tables he needs.
To do this simply go through the XML, extract the data of each product and go filling the fields of the Product object. When you finish with a product, make $ product-> add () and for another.
Maybe this can help you lighten up time, it's a ready-made solution with which you only have to adapt the first configuration. link
I hope it's useful for you greetings