Microsoft KB Archive/322386

= Variants Missing in Catalog XML Export =

Article ID: 322386

Article Last Modified on 10/16/2002

-

APPLIES TO


 * Microsoft Commerce Server 2000 Standard Edition

-



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 &quot;TOP 10000&quot; from the query so that all variants can be exported.



STATUS
Microsoft has confirmed that this is a problem in Microsoft Commerce Server 2000.

Additional query words: plutonium

Keywords: kbbug kbpending KB322386

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.