Dynamics Community Forum Thread Details

Vendor Catalog upload file error "There are no valid products to import".

Hello Everyone,

I am working on import vendor catalog process with the help of the below links.

cloudblogs.microsoft.com/.../

https://resources.westerncomputer.com/dynamics-365/how-to-set-up-vendor-catalog-import-in-dynamics-365-for-finance-and-operations

I have tired to replicate the steps mentioned in links but i am stuck at a point that is uploading xml file in vendor catalog form with the error "There are no valid products to import".

Below is the screen shot of the error:

Below is the xml code used for uploading the file in vendor catalog:

<?xml version="1.0" encoding="utf-8"?><Document>
<CatVendorCatalogMaintenanceRequestEntity>
   <UploadDateTime></UploadDateTime>
   <CatVendorProductCandidateEntity>
             <ProductCategoryHierarchyName>Procurement-OfficeSupplies</ProductCategoryHierarchyName>
             <ProductCategoryName>TestVendorCatalog</ProductCategoryName>
             <ActionType>Add</ActionType>
             <ProductNumber>10031</ProductNumber>
             <ProductSubtype>Product</ProductSubtype>
             <SearchName>VendorProduct10031</SearchName>
             <BarCode></BarCode>
             <ProductColorId></ProductColorId>
             <ProductConfigurationId></ProductConfigurationId>
             <ProductSizeId></ProductSizeId>
             <ProductStyleId></ProductStyleId>
             <CatVendorProductCandidatePurchasePriceEntity>
                <CurrencyCode>CAD</CurrencyCode>
                <UnitSymbol>pl</UnitSymbol>
                <Price>100</Price>
             </CatVendorProductCandidatePurchasePriceEntity>
             <CatVendorProductCandidateSalesPriceEntity>
                <CurrencyCode>CAD</CurrencyCode>
                <UnitSymbol>pl</UnitSymbol>
                <Price>200</Price>
                <SuggestedPrice>220</SuggestedPrice>
            </CatVendorProductCandidateSalesPriceEntity>
            <CatVendorProductCandidateDefaultOrderSettingsEntity>
                <UnitSymbol>pl</UnitSymbol>
                <LeadTime>15</LeadTime>
                <OrderQuantityMultiples>100</OrderQuantityMultiples>
                <MaximumOrderQuantity>1000</MaximumOrderQuantity>
                <MinimumOrderQuantity>100</MinimumOrderQuantity>
                <StandardOrderQuantity>500</StandardOrderQuantity>
            </CatVendorProductCandidateDefaultOrderSettingsEntity>
            <CatVendorProductCandidateTranslationEntity>
            <ProductName>Name for Vendor Product 1003-10</ProductName>
                <Description>Description for Vendor Product 100310</Description>
                <LanguageId>en-us</LanguageId>
</CatVendorProductCandidateTranslationEntity>
</CatVendorProductCandidateEntity>
</CatVendorCatalogMaintenanceRequestEntity></Document>