Download Categories from Shopware
If a category tree is already maintained in your shop, you should adopt this structure in Business Central instead of creating it again. To do so, the connector downloads the complete category list from Shopware, creates or updates the categories in BC, and stores the respective Shopware ID so that items can be assigned correctly later on.
What is downloaded
The download calls the Shopware search for categories (search/category) and retrieves up to 500 categories in a single run, including all relevant fields:
Structure
ID, name, parent category (parentId), level, number of subcategories, sort order.
Visibility
Active and visible – controls whether the category appears in the shop.
SEO & text
Description, meta title, meta description, and keywords.
Media
Assigned category image (media ID and image URL).
How the download works
The connector works in several passes so that the tree is consistent at the end:
Create/update categories
Each category is created in BC or – if it already exists based on the Shopware ID – updated.
Set parent-child relationships
In the second pass, the parent categories are linked so that the tree is mapped correctly.
Renumber the sort order
The sort order is reassigned per level in clean increments (10, 20, 30 …).
Load image URLs
For categories with an assigned image, the media URL is loaded afterwards.
At the end, the connector reports how many categories were processed successfully and how many errors occurred.
Run the category download before the large item upload. The categories are then available with their Web-IDs and items can be assigned to them directly.
Troubleshooting
Incomplete tree
More than 500 categories? The download is designed for 500 per run – check the structure.
Incorrect sort order
The sort order is reassigned during the download; synchronize subsequent changes again.
No image
Category without a media ID – assign an image in the shop and load it again.
Related topics
Frequently Asked Questions
How do I download all categories from Shopware to Business Central?
The "Download All" action calls search/category (POST, limit 500) and writes the categories to the "SOUSHW Category" table. "Fix Parent Links" repairs the parent-child links, and "Sync Sort Order" applies the sort order.