How to import Prestashop 1.6 products using CSV, keeping category nesting?

Question

Prestashop

I need to import a price list with products. For each product there is a tree of categories, for example "Cookware, Glassware, Mugs"

Are there plugins or code examples how to finalize the import tool standards.

ps It is not possible to download the category tree separately, it is necessary to add the product according to the tree to all the necessary categories when loading products (if they are not there, create them while maintaining nesting). I wrote a similar tool, but not for Prestashop, there is no way to convert it to another engine

pps It is also necessary to pull pictures by article from a given folder. For example, for a product with the article 444-jj-666, the picture is in site.ru/img_product/444-jj-666.jpg, etc. It is also necessary to change the CNC so that the product page has the same name as the article, for example site.ru/bytovaya-tekhnika/444-jj-666. Is there any platinum or preferably code examples for finalizing the engine (I know that you can specify {category:/}{id}-{reference} in the CNC settings, but there is a mandatory ID, and I need to remove it)

Answer 1

It is with the help of the usual CSV import that the nesting of categories during the import of goods cannot be identified.
Only import directly into the database with third-party tools/code. In any case, you will first have to import (correct) the category tree, and then import the products, but you can write code that does it all yourself.