web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Product Master Import ...
Microsoft Dynamics AX (Archived)

Product Master Import No Suggested Variants using DMFProductMasterEntity

(0) ShareShare
ReportReport
Posted on by Alex_R 330

Hi

I have added predefined a size group “fertiliser” with sizes 25Kg, 500Kg, 1000Kg attached. I can create a manual product master within AX. Then under ‘Product Master Tab’ > ‘Product variants’ > ‘variant suggestions’, I get a variant suggestions window with all the sizes for new variants to choose from.

However when I use the DMF Import using DMFProductMasterEntity. “fertisiser” is showing as a size group and the product dimension is populated for size dimensions, but the suggested variants are missing, and infolog error:

“No new variant suggestions for product TestImport001 were found.”

Capturefert.JPGCapturefertvar.JPG

Any Ideas what the import is missing? Or not Populating a field or a link?

Thanks

Alex

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Alex_R Profile Picture
    Alex_R 330 on at
    RE: Product Master Import No Suggested Variants using DMFProductMasterEntity

    Hi All,

    I think there is a little bug - but depends a lot on what your business needs are.  The missing variant suggestions are sourced from 4 tables :

    EcoResProductMasterSize

    EcoResProductMasterStyle

    EcoResProductMasterColor

    EcoResProductMasterConfiguration

    These tables link ProductMaster.RecId, and EcoResSize/Style/Color/Config.RecId which the EcoResProductMasterVariantCreationMgr Class uses to build the suggestions.

    So depending on your business needs the product master import will bring in your master, the variant import will bring in the variant and variant suggestions.  However the variant import assumes that all imported variants belonging to a Size/Style/Color/Config Group are all required.

    However If you choose to create a Size,Style,Color, or Config Group which crosses multiple products. For example footwear size group containing all known shoe sizes.  You may choose to only import current legacy product variants say 5 out of 10 sizes; you would not want to create all variants. You may also want to future proof.  The current import does not allow this.  

    Therefore you need to add a custom function to the master import to populate the EcoResProductMasterSize/Style/Color/Config Tables according to the Size/Style/Color/Config GroupId specified.  You can use the variant function generateProductMater for most of the code, but you’ll need to add a while loop though the Group tables. This will then allow your company product managers to release more variants to the product at will using product variant suggestions.

    You can manually over come this within AX for each product that requires a new variant by adding the variant to Product master>Product dimensions then adding the variant to Product Master>Product variants. But this wont work for 100's/1000's of products.

    Note: When you create a new product manually in AX the variant suggestions already applies and populates said tables, this fix only applies to imported products via the DMF.

    Alex

  • Suggested answer
    robertk Profile Picture
    robertk 360 on at
    RE: Product Master Import No Suggested Variants using DMFProductMasterEntity

    Have you checked the number sequence for variant number sequence (Retails > Setup > Parameters > Retails Parameters > Number Sequence tab). See here.

  • Alex_R Profile Picture
    Alex_R 330 on at
    RE: Product Master Import No Suggested Variants using DMFProductMasterEntity

    Good Tip, however I get the same values for an item created in AX as the imported product, when exported.  I designed the import around an existing product to check like for like, so this make sense. I still have the above issue with the imported product master

  • Suggested answer
    Gilbert Khayat Profile Picture
    Gilbert Khayat 3,254 on at
    RE: Product Master Import No Suggested Variants using DMFProductMasterEntity

    Usually when I face similar errors I try to export the data using DIXF and check what was exported. So create another product master entity with data source AX and then get staging data and then check how variants suggestions got exported. From there it might give you an idea to what's missing on your original file.  

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.

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Our Community Code of Conduct has been updated!

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Syed Haris Shah Profile Picture

Syed Haris Shah 9

#2
Community Member Profile Picture

Community Member 2

#2
Mea_ Profile Picture

Mea_ 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans