Categories
Used routes:
Categories are imported from the api_categories table, filtered according to navigationstypNr. The data consists of navigational routes (ka-go) and vehicle categories (e.g., PKW 3.5t). A hierarchical tree structure is created from the ParentCatNr relationships, which is then imported into the Shopware program, resulting in a structured representation of categories.
Mapping table:
| Storemanager | Shopware |
|---|---|
| api_categories.Title | name |
| api_categories.Text1 api_categories.Text2 api_categories.Text3 | description |
| api_categories.Pic1 api_categories.Pic2 api_categories.Pic3 | mediaId |
| api_categories.ParentCatNr | parentId |
| api_categories.ParentCatNr api_categories.CatNr api_categories.Style api_categories.CatNumber api_categories.Status api_categories.ShowSubCatItems api_categories.ShowItemGroupItems api_categories.ShowPromoItems api_categories.ShowSuggestions api_categories.SortOrder | customFields [ custom_category_ParentCatNr custom_category_CatNr custom_category_Style custom_category_CatNumber custom_category_Status custom_category_ShowSubCatItems custom_category_ShowItemGroupItems custom_category_ShowPromoItems custom_category_ShowSuggestions custom_category_SortOrder ] |