Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Answered

Product Master(PM) with Variants Import

Posted on by 2,172

Hello All,

I want to import product master with variants data(size, color and style). Which DMF entity should i use to import PM. I have a plan to use Product DIXF entity. But it seems like not having the variant fields as i required. Please suggest me to do this.

  • Anand AX Profile Picture
    Anand AX 2,172 on at
    RE: Product Master(PM) with Variants Import

    Hi Varun,

    First, i used product entity to import product master as below.

    Product Product Sub Type Product Number Item Number Product Description
    Item Product Master M10 M10 MTN 10 Kwacha
    Item Product Master 120000000 120000000 Galaxy Bar Chocolates

    Search Name PUOM SUOM IUOM Item Model Group Item Group
    M10 PCS PCS PCS WAC TTK
    GBAR CARTON BOX PCS WAC CHOC

    Product Dimension Group Storage Dimension Group Tracking Dimension Group
    SizeColor SWL NONE
    Color SWL NONE

    Then i used Variant Entity to import product dimensions as below.

    Display

    ProductNumber

    EcoResProductTranslation_

    LanguageId

    EcoResProductTranslation_Name ItemId RetailVariantId
    M10:Size:color En-Us M10:Size:color M10 M10Var1

    SearchName InventStyleId InventConfigId InventSizeId InventColorId

    EcoResProduct

    Translation_Description

    M10:Size:color 16mm Blue Test product
  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Product Master(PM) with Variants Import

    Hi Anand ,

    I am also facing a similar issue(variants),Can u explain how u successfully approached this issues??

    Thanks in advance

    Varun Gowrishankar

  • Anand AX Profile Picture
    Anand AX 2,172 on at
    RE: Product Master(PM) with Variants Import

    Hi John Krish,

    I used Variant entity and imported successfully.

  • Anand AX Profile Picture
    Anand AX 2,172 on at
    RE: Product Master(PM) with Variants Import

    Hi John Krish,

    Thanks for reply.  As i said, i want to import size, color and style variants. can you please mention the field name in variant entity for the above variants, because i can't find exactly.

  • Verified answer
    Johnkrish Profile Picture
    Johnkrish 781 on at
    RE: Product Master(PM) with Variants Import

    Hi Anand,

    In DMF, first import product master with Product entity and then use Variant entity to import product variants.

    Regards,

    Johnkrish

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

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,558 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,645 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans