|
Home > Archive > Commerce Server Catalog > June 2005 > QueryCatalogInfo not populating _product_DefinitionName for variants
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
QueryCatalogInfo not populating _product_DefinitionName for variants
|
|
| Colin Bowern 2005-05-04, 5:55 pm |
| Hi,
QueryCatalogInfo doesn't seem to be populating the _product_DefinitionName
value for product variants that have been added to the cart. I ran a SQL
trace and found that the call to ctlg_GetProductVariantProperties retunrs
everything but the DefinitionName field. Any thoughts as to why it is added
for regular products and not variants?
--- start pipeline log ---
PIPELINE:++ component[0x1] about to be called ProgID:
Commerce.QueryCatalogInfo.1
RootObject: ReadValue items VT_DISPATCH PV=[0x11e030c0] VT_EMPTY __empty__
Items: ReadItem 0 VT_DISPATCH PV=[0x11e03188] VT_EMPTY __empty__
: ReadValue product_catalog VT_BSTR USD VT_EMPTY __empty__
: ReadValue catalog_language VT_NULL __null__ VT_EMPTY __empty__
: ReadValue product_id VT_BSTR CD00002(SupplierA) VT_EMPTY __empty__
: ReadValue product_variant_id VT_NULL __null__ VT_EMPTY __empty__
: WriteValue _product_DeliveryMethod VT_EMPTY __empty__ VT_BSTR Ship
: WriteValue _product_TrackInventory VT_EMPTY __empty__ VT_BSTR 0
: WriteValue _product_TimeLimited VT_EMPTY __empty__ VT_BSTR 0
: WriteValue _product_ExtendedDescription VT_EMPTY __empty__ VT_BSTR
External Description Here
: WriteValue _product_ProductID VT_EMPTY __empty__ VT_BSTR
CD00002(SupplierA)
: WriteValue _product_LastModified VT_EMPTY __empty__ VT_DATE 3/25/2005
5:06:20 PM
: WriteValue _product_OnSale VT_EMPTY __empty__ VT_BSTR 1
: WriteValue _product_OnSaleDate VT_EMPTY __empty__ VT_DATE 3/1/2005
: WriteValue _product_VisibleBeforeOnSale VT_EMPTY __empty__ VT_BSTR 1
: WriteValue _product_MaximumQuantityPerOrder VT_EMPTY __empty__ VT_I4 0
: WriteValue _product_Description VT_EMPTY __empty__ VT_BSTR Nullam
suscipit, ipsum congue mattis blandit, massa ligula ultrices lectus, id
congue ipsum justo ac mauris. Nulla a quam.
: WriteValue _product_DeliveryNote VT_EMPTY __empty__ VT_BSTR Usually ships
within 2 - 3 business days.
: WriteValue _product_oid VT_EMPTY __empty__ VT_I4 17
: WriteValue _product_i_ClassType VT_EMPTY __empty__ VT_I4 4
: WriteValue _product_Label VT_EMPTY __empty__ VT_BSTR Artists Only Records
: WriteValue _product_TaxableCountry VT_EMPTY __empty__ VT_BSTR 1
: WriteValue _product_TaxableRegion VT_EMPTY __empty__ VT_BSTR 1
: WriteValue _product_cy_list_price VT_EMPTY __empty__ VT_CY 7.99
: WriteValue _product_CatalogName VT_EMPTY __empty__ VT_BSTR USD
: WriteValue _product_OriginalPrice VT_EMPTY __empty__ VT_CY 7.99
: WriteValue _product_Artist VT_EMPTY __empty__ VT_BSTR Ki Mani Marley
: WriteValue _product_UPC VT_EMPTY __empty__ VT_BSTR
: WriteValue _product_DisplayName VT_EMPTY __empty__ VT_BSTR Many More Roads
: WriteValue _product_VariantID VT_EMPTY __empty__ VT_BSTR
: WriteValue _product_DefinitionName VT_EMPTY __empty__ VT_BSTR CD
: WriteValue _product_UseCategoryPricing VT_EMPTY __empty__ VT_BOOL 0
: WriteValue _product_ReleaseDate VT_EMPTY __empty__ VT_DATE 1/1/2005
: ReadValue product_id VT_BSTR CD00002(SupplierA) VT_EMPTY __empty__
: ReadValue product_variant_id VT_NULL __null__ VT_EMPTY __empty__
: WriteValue _product_categories VT_EMPTY __empty__ VT_VARIANT | VT_ARRAY
Items: ReadItem 1 VT_DISPATCH PV=[0x11e03d00] VT_EMPTY __empty__
: ReadValue product_catalog VT_BSTR USD VT_EMPTY __empty__
: ReadValue catalog_language VT_NULL __null__ VT_EMPTY __empty__
: ReadValue product_id VT_BSTR CD00003(SupplierA) VT_EMPTY __empty__
: ReadValue product_variant_id VT_NULL __null__ VT_EMPTY __empty__
: WriteValue _product_DeliveryMethod VT_EMPTY __empty__ VT_BSTR Ship
: WriteValue _product_TrackInventory VT_EMPTY __empty__ VT_BSTR 0
: WriteValue _product_TimeLimited VT_EMPTY __empty__ VT_BSTR 0
: WriteValue _product_ExtendedDescription VT_EMPTY __empty__ VT_BSTR
External Description Here
: WriteValue _product_ProductID VT_EMPTY __empty__ VT_BSTR
CD00003(SupplierA)
: WriteValue _product_LastModified VT_EMPTY __empty__ VT_DATE 3/25/2005
5:06:20 PM
: WriteValue _product_OnSale VT_EMPTY __empty__ VT_BSTR 1
: WriteValue _product_OnSaleDate VT_EMPTY __empty__ VT_DATE 3/1/2005
: WriteValue _product_VisibleBeforeOnSale VT_EMPTY __empty__ VT_BSTR 1
: WriteValue _product_MaximumQuantityPerOrder VT_EMPTY __empty__ VT_I4 0
: WriteValue _product_Description VT_EMPTY __empty__ VT_BSTR Vivamus
faucibus nisl. Etiam placerat magna ut tellus. Etiam nulla neque.
: WriteValue _product_DeliveryNote VT_EMPTY __empty__ VT_BSTR This item is
on back order.
: WriteValue _product_oid VT_EMPTY __empty__ VT_I4 18
: WriteValue _product_i_ClassType VT_EMPTY __empty__ VT_I4 4
: WriteValue _product_Label VT_EMPTY __empty__ VT_BSTR Maple Music
: WriteValue _product_TaxableCountry VT_EMPTY __empty__ VT_BSTR 1
: WriteValue _product_TaxableRegion VT_EMPTY __empty__ VT_BSTR 1
: WriteValue _product_cy_list_price VT_EMPTY __empty__ VT_CY 19.99
: WriteValue _product_CatalogName VT_EMPTY __empty__ VT_BSTR USD
: WriteValue _product_OriginalPrice VT_EMPTY __empty__ VT_CY 19.99
: WriteValue _product_Artist VT_EMPTY __empty__ VT_BSTR Triumph
: WriteValue _product_UPC VT_EMPTY __empty__ VT_BSTR
: WriteValue _product_DisplayName VT_EMPTY __empty__ VT_BSTR Just A Game
: WriteValue _product_VariantID VT_EMPTY __empty__ VT_BSTR
: WriteValue _product_DefinitionName VT_EMPTY __empty__ VT_BSTR CD
: WriteValue _product_UseCategoryPricing VT_EMPTY __empty__ VT_BOOL 0
: WriteValue _product_ReleaseDate VT_EMPTY __empty__ VT_DATE 1/1/2005
: ReadValue product_id VT_BSTR CD00003(SupplierA) VT_EMPTY __empty__
: ReadValue product_variant_id VT_NULL __null__ VT_EMPTY __empty__
: WriteValue _product_categories VT_EMPTY __empty__ VT_VARIANT | VT_ARRAY
Items: ReadItem 2 VT_DISPATCH PV=[0x11e021c8] VT_EMPTY __empty__
: ReadValue product_catalog VT_BSTR USD VT_EMPTY __empty__
: ReadValue catalog_language VT_NULL __null__ VT_EMPTY __empty__
: ReadValue product_id VT_BSTR CL00001(SupplierB) VT_EMPTY __empty__
: ReadValue product_variant_id VT_BSTR CL00002(SupplierB) VT_EMPTY __empty__
: ReadValue product_id VT_BSTR CL00001(SupplierB) VT_EMPTY __empty__
: ReadValue product_variant_id VT_BSTR CL00002(SupplierB) VT_EMPTY __empty__
: WriteValue _product_Color VT_EMPTY __empty__ VT_BSTR Blue
: WriteValue _product_DeliveryMethod VT_EMPTY __empty__ VT_BSTR Ship
: WriteValue _product_TrackInventory VT_EMPTY __empty__ VT_BSTR 1
: WriteValue _product_TimeLimited VT_EMPTY __empty__ VT_BSTR 0
: WriteValue _product_ExtendedDescription VT_EMPTY __empty__ VT_BSTR Check
out this warm fuzzy jacket.
: WriteValue _product_ProductID VT_EMPTY __empty__ VT_BSTR
CL00001(SupplierB)
: WriteValue _product_OnSale VT_EMPTY __empty__ VT_BSTR 1
: WriteValue _product_OnSaleDate VT_EMPTY __empty__ VT_DATE 3/1/2005
: WriteValue _product_Gender VT_EMPTY __empty__ VT_BSTR Men
: WriteValue _product_VisibleBeforeOnSale VT_EMPTY __empty__ VT_BSTR 1
: WriteValue _product_MaximumQuantityPerOrder VT_EMPTY __empty__ VT_I4 0
: WriteValue _product_Description VT_EMPTY __empty__ VT_BSTR 100% Cotton
Jacket
: WriteValue _product_DeliveryNote VT_EMPTY __empty__ VT_BSTR Usually ships
within 2 - 3 business days.
: WriteValue _product_oid VT_EMPTY __empty__ VT_I4 17
: WriteValue _product_TaxableCountry VT_EMPTY __empty__ VT_BSTR 1
: WriteValue _product_TaxableRegion VT_EMPTY __empty__ VT_BSTR 1
: WriteValue _product_cy_list_price VT_EMPTY __empty__ VT_CY 69.95
: WriteValue _product_UPC VT_EMPTY __empty__ VT_BSTR
: WriteValue _product_DisplayName VT_EMPTY __empty__ VT_BSTR Jacket
: WriteValue _product_Size VT_EMPTY __empty__ VT_BSTR Small
: ReadValue product_id VT_BSTR CL00001(SupplierB) VT_EMPTY __empty__
: ReadValue product_variant_id VT_BSTR CL00002(SupplierB) VT_EMPTY __empty__
: WriteValue _product_categories VT_EMPTY __empty__ VT_VARIANT | VT_ARRAY
PIPELINE:-- component [0x1] returned hr: 0x0, IErrorLevel=1 in 16
milliseconds
--- end pipeline log ---
Thanks,
Colin
| |
| Vinayak Tadas[MSFT] 2005-06-09, 5:52 pm |
| Typically a DefinitionName is associated with the ProductFamily and not
directly with a variant. Since the definitionName is not a direct property
of a variant it is not populated by the QCI component.
Can you please describe your scenario. This might help us improve this
feature in future releases.
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
--------------------
From: "Colin Bowern" <colin.bowern@nospam.officialcommunity.com>
Subject: QueryCatalogInfo not populating _product_DefinitionName for
variants
Date: Wed, 4 May 2005 13:41:53 -0400
Lines: 137
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2527
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2527
X-RFC2646: Format=Flowed; Original
Message-ID: <##b3mCNUFHA.228@TK2MSFTNGP12.phx.gbl>
Newsgroups: microsoft.public.commerceserver.catalog
NNTP-Posting-Host: mail.officialcommunity.net 207.188.77.211
Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12.phx.gbl
Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.commerceserver.catalog:937
X-Tomcat-NG: microsoft.public.commerceserver.catalog
Hi,
QueryCatalogInfo doesn't seem to be populating the _product_DefinitionName
value for product variants that have been added to the cart. I ran a SQL
trace and found that the call to ctlg_GetProductVariantProperties retunrs
everything but the DefinitionName field. Any thoughts as to why it is
added
for regular products and not variants?
--- start pipeline log ---
PIPELINE:++ component[0x1] about to be called ProgID:
Commerce.QueryCatalogInfo.1
RootObject: ReadValue items VT_DISPATCH PV=[0x11e030c0] VT_EMPTY __empty__
Items: ReadItem 0 VT_DISPATCH PV=[0x11e03188] VT_EMPTY __empty__
: ReadValue product_catalog VT_BSTR USD VT_EMPTY __empty__
: ReadValue catalog_language VT_NULL __null__ VT_EMPTY __empty__
: ReadValue product_id VT_BSTR CD00002(SupplierA) VT_EMPTY __empty__
: ReadValue product_variant_id VT_NULL __null__ VT_EMPTY __empty__
: WriteValue _product_DeliveryMethod VT_EMPTY __empty__ VT_BSTR Ship
: WriteValue _product_TrackInventory VT_EMPTY __empty__ VT_BSTR 0
: WriteValue _product_TimeLimited VT_EMPTY __empty__ VT_BSTR 0
: WriteValue _product_ExtendedDescription VT_EMPTY __empty__ VT_BSTR
External Description Here
: WriteValue _product_ProductID VT_EMPTY __empty__ VT_BSTR
CD00002(SupplierA)
: WriteValue _product_LastModified VT_EMPTY __empty__ VT_DATE 3/25/2005
5:06:20 PM
: WriteValue _product_OnSale VT_EMPTY __empty__ VT_BSTR 1
: WriteValue _product_OnSaleDate VT_EMPTY __empty__ VT_DATE 3/1/2005
: WriteValue _product_VisibleBeforeOnSale VT_EMPTY __empty__ VT_BSTR 1
: WriteValue _product_MaximumQuantityPerOrder VT_EMPTY __empty__ VT_I4 0
: WriteValue _product_Description VT_EMPTY __empty__ VT_BSTR Nullam
suscipit, ipsum congue mattis blandit, massa ligula ultrices lectus, id
congue ipsum justo ac mauris. Nulla a quam.
: WriteValue _product_DeliveryNote VT_EMPTY __empty__ VT_BSTR Usually ships
within 2 - 3 business days.
: WriteValue _product_oid VT_EMPTY __empty__ VT_I4 17
: WriteValue _product_i_ClassType VT_EMPTY __empty__ VT_I4 4
: WriteValue _product_Label VT_EMPTY __empty__ VT_BSTR Artists Only Records
: WriteValue _product_TaxableCountry VT_EMPTY __empty__ VT_BSTR 1
: WriteValue _product_TaxableRegion VT_EMPTY __empty__ VT_BSTR 1
: WriteValue _product_cy_list_price VT_EMPTY __empty__ VT_CY 7.99
: WriteValue _product_CatalogName VT_EMPTY __empty__ VT_BSTR USD
: WriteValue _product_OriginalPrice VT_EMPTY __empty__ VT_CY 7.99
: WriteValue _product_Artist VT_EMPTY __empty__ VT_BSTR Ki Mani Marley
: WriteValue _product_UPC VT_EMPTY __empty__ VT_BSTR
: WriteValue _product_DisplayName VT_EMPTY __empty__ VT_BSTR Many More Roads
: WriteValue _product_VariantID VT_EMPTY __empty__ VT_BSTR
: WriteValue _product_DefinitionName VT_EMPTY __empty__ VT_BSTR CD
: WriteValue _product_UseCategoryPricing VT_EMPTY __empty__ VT_BOOL 0
: WriteValue _product_ReleaseDate VT_EMPTY __empty__ VT_DATE 1/1/2005
: ReadValue product_id VT_BSTR CD00002(SupplierA) VT_EMPTY __empty__
: ReadValue product_variant_id VT_NULL __null__ VT_EMPTY __empty__
: WriteValue _product_categories VT_EMPTY __empty__ VT_VARIANT | VT_ARRAY
Items: ReadItem 1 VT_DISPATCH PV=[0x11e03d00] VT_EMPTY __empty__
: ReadValue product_catalog VT_BSTR USD VT_EMPTY __empty__
: ReadValue catalog_language VT_NULL __null__ VT_EMPTY __empty__
: ReadValue product_id VT_BSTR CD00003(SupplierA) VT_EMPTY __empty__
: ReadValue product_variant_id VT_NULL __null__ VT_EMPTY __empty__
: WriteValue _product_DeliveryMethod VT_EMPTY __empty__ VT_BSTR Ship
: WriteValue _product_TrackInventory VT_EMPTY __empty__ VT_BSTR 0
: WriteValue _product_TimeLimited VT_EMPTY __empty__ VT_BSTR 0
: WriteValue _product_ExtendedDescription VT_EMPTY __empty__ VT_BSTR
External Description Here
: WriteValue _product_ProductID VT_EMPTY __empty__ VT_BSTR
CD00003(SupplierA)
: WriteValue _product_LastModified VT_EMPTY __empty__ VT_DATE 3/25/2005
5:06:20 PM
: WriteValue _product_OnSale VT_EMPTY __empty__ VT_BSTR 1
: WriteValue _product_OnSaleDate VT_EMPTY __empty__ VT_DATE 3/1/2005
: WriteValue _product_VisibleBeforeOnSale VT_EMPTY __empty__ VT_BSTR 1
: WriteValue _product_MaximumQuantityPerOrder VT_EMPTY __empty__ VT_I4 0
: WriteValue _product_Description VT_EMPTY __empty__ VT_BSTR Vivamus
faucibus nisl. Etiam placerat magna ut tellus. Etiam nulla neque.
: WriteValue _product_DeliveryNote VT_EMPTY __empty__ VT_BSTR This item is
on back order.
: WriteValue _product_oid VT_EMPTY __empty__ VT_I4 18
: WriteValue _product_i_ClassType VT_EMPTY __empty__ VT_I4 4
: WriteValue _product_Label VT_EMPTY __empty__ VT_BSTR Maple Music
: WriteValue _product_TaxableCountry VT_EMPTY __empty__ VT_BSTR 1
: WriteValue _product_TaxableRegion VT_EMPTY __empty__ VT_BSTR 1
: WriteValue _product_cy_list_price VT_EMPTY __empty__ VT_CY 19.99
: WriteValue _product_CatalogName VT_EMPTY __empty__ VT_BSTR USD
: WriteValue _product_OriginalPrice VT_EMPTY __empty__ VT_CY 19.99
: WriteValue _product_Artist VT_EMPTY __empty__ VT_BSTR Triumph
: WriteValue _product_UPC VT_EMPTY __empty__ VT_BSTR
: WriteValue _product_DisplayName VT_EMPTY __empty__ VT_BSTR Just A Game
: WriteValue _product_VariantID VT_EMPTY __empty__ VT_BSTR
: WriteValue _product_DefinitionName VT_EMPTY __empty__ VT_BSTR CD
: WriteValue _product_UseCategoryPricing VT_EMPTY __empty__ VT_BOOL 0
: WriteValue _product_ReleaseDate VT_EMPTY __empty__ VT_DATE 1/1/2005
: ReadValue product_id VT_BSTR CD00003(SupplierA) VT_EMPTY __empty__
: ReadValue product_variant_id VT_NULL __null__ VT_EMPTY __empty__
: WriteValue _product_categories VT_EMPTY __empty__ VT_VARIANT | VT_ARRAY
Items: ReadItem 2 VT_DISPATCH PV=[0x11e021c8] VT_EMPTY __empty__
: ReadValue product_catalog VT_BSTR USD VT_EMPTY __empty__
: ReadValue catalog_language VT_NULL __null__ VT_EMPTY __empty__
: ReadValue product_id VT_BSTR CL00001(SupplierB) VT_EMPTY __empty__
: ReadValue product_variant_id VT_BSTR CL00002(SupplierB) VT_EMPTY __empty__
: ReadValue product_id VT_BSTR CL00001(SupplierB) VT_EMPTY __empty__
: ReadValue product_variant_id VT_BSTR CL00002(SupplierB) VT_EMPTY __empty__
: WriteValue _product_Color VT_EMPTY __empty__ VT_BSTR Blue
: WriteValue _product_DeliveryMethod VT_EMPTY __empty__ VT_BSTR Ship
: WriteValue _product_TrackInventory VT_EMPTY __empty__ VT_BSTR 1
: WriteValue _product_TimeLimited VT_EMPTY __empty__ VT_BSTR 0
: WriteValue _product_ExtendedDescription VT_EMPTY __empty__ VT_BSTR Check
out this warm fuzzy jacket.
: WriteValue _product_ProductID VT_EMPTY __empty__ VT_BSTR
CL00001(SupplierB)
: WriteValue _product_OnSale VT_EMPTY __empty__ VT_BSTR 1
: WriteValue _product_OnSaleDate VT_EMPTY __empty__ VT_DATE 3/1/2005
: WriteValue _product_Gender VT_EMPTY __empty__ VT_BSTR Men
: WriteValue _product_VisibleBeforeOnSale VT_EMPTY __empty__ VT_BSTR 1
: WriteValue _product_MaximumQuantityPerOrder VT_EMPTY __empty__ VT_I4 0
: WriteValue _product_Description VT_EMPTY __empty__ VT_BSTR 100% Cotton
Jacket
: WriteValue _product_DeliveryNote VT_EMPTY __empty__ VT_BSTR Usually ships
within 2 - 3 business days.
: WriteValue _product_oid VT_EMPTY __empty__ VT_I4 17
: WriteValue _product_TaxableCountry VT_EMPTY __empty__ VT_BSTR 1
: WriteValue _product_TaxableRegion VT_EMPTY __empty__ VT_BSTR 1
: WriteValue _product_cy_list_price VT_EMPTY __empty__ VT_CY 69.95
: WriteValue _product_UPC VT_EMPTY __empty__ VT_BSTR
: WriteValue _product_DisplayName VT_EMPTY __empty__ VT_BSTR Jacket
: WriteValue _product_Size VT_EMPTY __empty__ VT_BSTR Small
: ReadValue product_id VT_BSTR CL00001(SupplierB) VT_EMPTY __empty__
: ReadValue product_variant_id VT_BSTR CL00002(SupplierB) VT_EMPTY __empty__
: WriteValue _product_categories VT_EMPTY __empty__ VT_VARIANT | VT_ARRAY
PIPELINE:-- component [0x1] returned hr: 0x0, IErrorLevel=1 in 16
milliseconds
--- end pipeline log ---
Thanks,
Colin
|
|
|
|
|