HI, I need to update a vritual catalog.
I am able to update its base catalog with the following:
(I see the price update in the table Lifesciences_CatalogProducts)
<MSCommerceCatalogCollection2 version="3.0">
<Catalog name="Lifesciences" languages="en-US" DefaultLanguage="en-US"
Re****tingLanguage="en-US" VC_CultureName="en-US" productUID="ProductId"
variantUID="VariantId">
<Product Definition="Product Definition 2" ProductId="1000-50"
lastmodified="2007-04-17T13:39:55">
<ProductVariant listprice="11.0000" VariantId="CA"
lastmodified="2007-04-17T13:39:55" />
<ProductVariant listprice="11.0000" VariantId="PK"
lastmodified="2007-04-17T13:39:55" />
</Product>
</Catalog>
</MSCommerceCatalogCollection2>
The equivalent for the virtual catalog has no effect:
(I don't see the price updated anywhere, should be in the table
Lifesciences_en-US_CatalogProducts)
<MSCommerceCatalogCollection2 version="3.0">
<VirtualCatalog name="Lifesciences_en-US" DefaultLanguage="en-US"
Re****tingLanguage="en-US" VC_CultureName="en-US" languages="en-US">
<VirtualProduct Definition="Product Definition 2"
ProductId="1000-50(Lifesciences)" lastmodified="2007-06-14T13:39:55">
<VirtualProductVariant VariantId="CA(Lifesciences)"
lastmodified="2007-05-17T13:39:55" listprice="25.0000" />
<VirtualProductVariant VariantId="PK(Lifesciences)"
lastmodified="2007-05-17T13:39:55" listprice="25.0000" />
</VirtualProduct>
</VirtualCatalog>
</MSCommerceCatalogCollection2>
The im****t show as success full, no errors anywhere, but no price update
either.
I even saw he price flowing in the db trace:
exec sp_executesql N'
UPDATE dbo.[Lifesciences_en-US_CatalogProducts]
SET [#MaterializationNeeded] = 1,
[lastmodified]=@[EMAIL PROTECTED]
WHERE [VcOid]=1204'
,N'
@[EMAIL PROTECTED]
nvarchar(128),
@[EMAIL PROTECTED]
datetime,
@[EMAIL PROTECTED]
real,
@[EMAIL PROTECTED]
bit',
@[EMAIL PROTECTED]
'2007-05-17 13:39:55:000',
@[EMAIL PROTECTED]
tried with and without the virtual catalog being materialized.
Any clues why it doensn't work?
Thanks
|
