Commerce Server Catalog - Maximum number of product variants allowed for a product in a cata

Author

Maximum number of product variants allowed for a product in a cata

Arabindh

2005-01-13, 5:51 pm

Hi,
1) Is there any limit to the number of product variants allowed under a
product.

2) We have a requirement such that there are about 50,000 to 10,00,000
product variants for each product in a single catalog. The total number of
variants in the catalog is about 3,00,00,000. Is this much variant
combinations supported in CS 2002. The database gets really slow after
inserting about 20,000 product variants for every single product.

Thanks

Vinayak Tadas[MSFT]

2005-02-11, 8:47 pm

There is no hard coded limt. However for performance reasons you should
design your catalog in such a way that the number of variants in a product
fall upto a reasonable number (upto 5000 variants)
--------------------
Thread-Topic: Maximum number of product variants allowed for a product in a
cata
thread-index: AcT5f5YExFAFOCQMSRSQVtbGoc+1Xg==
X-WBNR-Posting-Host: 203.129.254.201
From: "=?Utf-8?B?QXJhYmluZGg=?=" <Arabindh@discussions.microsoft.com>
Subject: Maximum number of product variants allowed for a product in a cata
Date: Thu, 13 Jan 2005 06:53:04 -0800
Lines: 11
Message-ID: <47D99F76-EB7A-4700-8C5F-B285B12C88FE@microsoft.com>
MIME-Version: 1.0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Content-Class: urn:content-classes:message
Importance: normal
Priority: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
Newsgroups: microsoft.public.commerceserver.catalog
NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
Xref: cpmsftngxa10.phx.gbl microsoft.public.commerceserver.catalog:5170
X-Tomcat-NG: microsoft.public.commerceserver.catalog

Hi,
1) Is there any limit to the number of product variants allowed under a
product.

2) We have a requirement such that there are about 50,000 to 10,00,000
product variants for each product in a single catalog. The total number of
variants in the catalog is about 3,00,00,000. Is this much variant
combinations supported in CS 2002. The database gets really slow after
inserting about 20,000 product variants for every single product.

Thanks

Thanks
Vinayak Tadas
Microsoft
http://blogs.msdn.com/vinayakt

This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2002 Microsoft Corporation. All rights
reserved.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
Get Secure! For more info visit http://www.microsoft.com/security. Please
reply to the newsgroups only. Thanks

suryan

2005-06-28, 12:23 pm

When I am adding product variants for a product in a catalog after entering about 115 variants I am getting this warning message :

Number of records is greater than the maximum allowed (2,000,000,000). Please specify a filter or further search criteria to fetch a smaller list.

However, there is no filter criteria in bizdesk for this particular screen (adding product and product variants to a base catalog).

Any thoughts, please share

Thanks in advance,

Surya

quote:
Originally posted by Arabindh
Hi,
1) Is there any limit to the number of product variants allowed under a
product.

2) We have a requirement such that there are about 50,000 to 10,00,000
product variants for each product in a single catalog. The total number of
variants in the catalog is about 3,00,00,000. Is this much variant
combinations supported in CS 2002. The database gets really slow after
inserting about 20,000 product variants for every single product.

Thanks