Variants Missing in Catalog XML Export (322386)


The information in this article applies to:

  • Microsoft Commerce Server 2000
This article was previously published under Q322386

SYMPTOMS

When you export a catalog from the BizDesk, and you use XML format, the generated XML file may not contain all of the variants that are associated with your products.

CAUSE

Your catalog contains more than 10,000 variants and the SQL stored procedure that is used to export the catalog assumes that you have no more than 10,000 variants per product.

WORKAROUND

Modify the SQL stored procedure sp_GetProductsForExport and remove "TOP 10000" from the query so that all variants can be exported.

STATUS

Microsoft has confirmed that this is a problem in Microsoft Commerce Server 2000.
Modification Type:MajorLast Reviewed:10/16/2002
Keywords:kbbug KB322386
©2002 Microsoft Corporation. All rights reserved.