Vendor catalog import - There are no valid products to import

(0) Share

Report

Posted on by Community Member

Hi Everyone,

I've been trying to import a vendor catalog for a while now and I always receive the error "There are no valid products to import"

I see there are a couple of threads about this issue but none give any information neither about the cause nor about a possible solution

I have done the following which may cause an issue:

- I enabled the vendor for catalog import

- I assigned the vendor to the desired category

- I checked the mapping of the import project

- I made sure all provided data in the xml file conform to the master data

What else may cause the issue?

Am I missing anything?

Thanks in advance,

Simeon

I have the same question (0)

All responses (7)

Answers (0)

MATTGUO 22,349 Moderator on at

Like (0)

Report

Hi Simeon,

I get information that this issue is related to the difference of local computer and user option time zone. Please search the issue ID 554445 in LCS.

If it still does not work, please create a support ticket.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks. The only thing of value in this issue is the workaround to specify my time zone and time standard. I tried but it didn't work.

This is the error in Data management:

Package execution failed please check event log in DMF service box-

'0' 'Vendor catalogs' record(s) inserted in staging

This is the import template I am using:

<?xml version="1.0" encoding="utf-8"?><Document>

<CatVendorCatalogMaintenanceRequestEntity>

<UploadDateTime></UploadDateTime>

<CatVendorProductCandidateEntity>

<ProductCategoryHierarchyName>Procurement-OfficeSupplies</ProductCategoryHierarchyName>

<ProductCategoryName>Computers</ProductCategoryName>

<ActionType>Add</ActionType>

<ProductNumber>10031-1</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>

Do you see anything amiss?

Thanks,

Simeon

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks. The only thing of value in this issue is the workaround to specify my time zone and time standard. I tried but it didn't work.

This is the error in Data management:

Package execution failed please check event log in DMF service box-

'0' 'Vendor catalogs' record(s) inserted in staging

This is the import template I am using:

<?xml version="1.0" encoding="utf-8"?><Document>

<CatVendorCatalogMaintenanceRequestEntity>

<UploadDateTime></UploadDateTime>

<CatVendorProductCandidateEntity>

<ProductCategoryHierarchyName>Procurement-OfficeSupplies</ProductCategoryHierarchyName>

<ProductCategoryName>Computers</ProductCategoryName>

<ActionType>Add</ActionType>

<ProductNumber>10031-1</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>

Do you see anything amiss?

Thanks,

Simeon

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Can you import a vendor catalog at the moment, can you please share your settings of import template?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Below you can see the settings of the target mapping of the import project.

The vendor has been configured for catalog import.

The import xml template has been cited in my previous post.

Is there anything else that needs to be configured?

Was this reply helpful? Yes No
ToddB on at

Like (0)

Report

Hi Simeon,

Were you able to open a support incident as recommended by Matt Guo?

Was this reply helpful? Yes No
Guy Terry 28,924 Moderator on at

Like (0)

Report

Hi Simeon

Per this blog post

cloudblogs.microsoft.com/.../

You should not have the following line in the file you are importing:

<UploadDateTime></UploadDateTime>

That line should be in the file you use to create the DMF mappings, but you need to remove it when you populate the template with data and try to import it.

Was this reply helpful? Yes No