Developer forum

Forum » Ecommerce - Standard features » Populating PIM products into Categories in bulk

Populating PIM products into Categories in bulk

E-mail notifications
Angelo Aviles
Reply
Posted on 21/08/2025 17:40:02

We are updating our navigation on our website and need a way to bulk import products to newly created catgories instead of 1 by 1. we have over 1600 products and would like a way to do this more efficiently.

Any suggestions?


Replies

 
Adrian Ursu Dynamicweb Employee
Adrian Ursu
Posted on 21/08/2025 21:59:43
Reply

Hi Angelo,

All you have to do is update the content of EcomGroupProductRelations. That's where the relations are stored.
Either delete everything and reimport the assignments or create new ones (if you want to keep the old assignments).
The table structure is pretty simple:

GroupProductRelationGroupId GroupProductRelationProductId GroupProductRelationSorting GroupProductRelationIsPrimary GroupProductRelationCreated
GROUP403 PROD400 1 TRUE 2025-08-20
GROUP403 PROD401 2 TRUE 2025-08-20
GROUP403 PROD402 3 TRUE 2025-08-20
GROUP403 PROD403 4 TRUE 2025-08-20
GROUP403 PROD404 5 TRUE 2025-08-20
GROUP403 PROD405 6 TRUE 2025-08-20
GROUP403 PROD406 7 TRUE 2025-08-20
GROUP403 PROD407 8 TRUE 2025-08-20
GROUP403 PROD408 9 TRUE 2025-08-20

 

You need to know the GroupIds and the ProductIds.
Another way would be to use the AutoAssign functionality but it would still mean importing some Group information on the products for AutoAssignment.

Adrian

 

You must be logged in to post in the forum