Add category-reference as field in category table

[madsoliver]

The problem

When importing/exporting products from/to other systems, I allways use the product reference field to match between the two systems. Sometimes I might use field like EAN13 or one of the other unique, optional, "free", not NOT auto-incremented fields to match the same items for both systems.

Such a non-auto-incremented "reference"-field is NOT available for categories in PrestaShop, and it is a big issue when importing.

Sometimes one can be lucky that the import file has number-type reference, and you ar importing to a fresh prestashop with no existing category structure -> You can actually set the IDs in the prestashop category table.

The solution

Create a new field in the category table, called "reference".
Make it optional.
Make it available i the edit category page.
Make it possible to import, and also make fields like "parent category reference" in the import, so that one can build a category structure from a csv-import file. (today one must do this my category id or name).
Also "category reference" should be a optional field in the product import.

Alternatives

One could always make a module specific category references-table, that will serve the same purpose, but seems a bit bulky.
Also it makes sense to have the field built into prestashop in order to make the category import better.

Additional context

No response

Do you plan to work on this subject?

• I'm willing to contribute a formal specification.
• I'm willing to provide any wireframes or design assets required for this feature.
• I'm willing to submit a Pull Request that implements this feature.
• I'm willing to help verify that the implemented feature works as intended and produces no unintended side effects.