Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. Variants Missing in Catalog XML Export

Variants Missing in Catalog XML Export

View products that this article applies to.

This article was previously published under Q322386

↑ Back to the top

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.

↑ Back to the top

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.

↑ Back to the top

Workaround

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

↑ Back to the top

Status

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

↑ Back to the top

Keywords: KB322386, kbpending, kbbug

↑ Back to the top

Article Info
Article ID : 322386
Revision : 1
Created on : 10/16/2002
Published on : 10/16/2002
Exists online : False
Views : 322