Announcements
No record found.
Hi ALL ;
We need to move (10,000) all products from category to category in AX retail product category as below image :-
We need move in all one time not one by one .
Thanks
*This post is locked for comments
Hi Khaled,
You can also use Data Import Export Framework to load a file with the new category assignments.
Many Thanks fro your replay
Yes I need more detail or steps for that better if there screenshot
Kindly , can you send me more details?
If you want to use the data import export framework, you can read the user guide on internet: docs.microsoft.com/.../data-import-export-framework-user-guide-dixf-dmf
If you then have more detailed questions or you get stuck, do not hesitate to update this thread.
Many thanks,
I need code for update , I wort below code to move items from category to other , but I need the update code , can you help on that?
static void MoveProducutsFromCategToCateg(Args _args) { EcoResProductCategory Prodcat; int i; ; while select forupdate Prodcat where Prodcat.Category ==5637144594 { ttsBegin; Prodcat.Category=5637145528; Prodcat.update(); ++i; ttsCommit; } info(strFmt("NUMBEROFROWS %1,%2",i,Prodcat.Product)); }
You can better use the update_recordset function for bulk updates. It will then do one call to the database which will handle the records at once instead of one by one. This will be performance wise better.
Example:
static void MoveProducutsFromCategToCateg(Args _args) { EcoResProductCategory prodCat; ; ttsbegin; update_recordset prodCat setting Category = 5637145528 where Category == 5637144594; ttsCommit; info("Job done"); }
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Stars!
We are thrilled to have these Champions in our Community!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
CP04-islander 39
Michel ROY 14
imran ul haq 8
