Biztalk/CatalogManager/Sequencing
Hi,
I have Biztalk importing Catalog Item changes (Items that already exisit in Commerce Server) that seems to be working fine except for one issue.
The integration seems to put any modified items at the end of of Category that was Sequenced. So for instance if the part is supposed to come up first for a given Category once the integration runs and updates the given part - the part automatically gets moved to the bottom of the Category.
Note: the Integration does not bring in all the Items for the given Catalog/Category just Items that have been changed (ie there description changed etc.)
I am sending XML files to Biztalk and use Pass-Thru Transmit - I also verified that the import was set to Incremental as opposed to Replace.
Any help would be greatly appreciated.
Xcel.
[841 byte] By [
Xcel] at [2008-1-9]
I am still having a problem with this and the client is starting to get frustrated.
To recap I need to update Items that already exist in Catalog Manager throught Biztalk. Unfortunately the Biztalk process always puts the updated part at the end of the custom sequence. I am using the Catalog Adapter in Biztalk. I have enclosed the sample xml file that I send to Biztalk. NOTE: I have had tried changing the Rank value to 1, not sending it at all etc. all with same results.
Is this a "bug" in Commerce Server/Biztalk or am I missing something.
<MSCommerceCatalogCollection2 version="3.0">
<Catalog name="HP" id="HP9/11/2007" variantUID="ServiceLevel" productUID="SKU" currency="USD" weight_measuring_unit="lbs" DefaultLanguage="en-US" ReportingLanguage="en-US" languages="en-US">
<Product Definition="Parts" SKU="RG5-2661-000" UseCategoryPricing="0" ListPrice="0.00" LastModified="2006-01-16T14:00:00" ItemNmbr="HP4000-FUS" Manufacturer="HP" ManufacturerNmbr="C4118-69003/c4118-69011/RG5-2657/RG5-2661" Category="FUSER" Description="HP 4000/4050 Fuser Assy" ProductWeight="5" Image_filename="Images/HP4000-FUSS.jpg" Image_height="250" Image_width="225" ID="XSID_RG5-2661-000">
<DisplayName Value="HP 4000/4050 Fuser Assy" Language="en-US" />
<ParentCategory Rank="0">LJ 4000</ParentCategory>
<ProductVariant ServiceLevel="EXCHANGE" ListPrice="73" LastModified="2006-01-16T14:00:00" Price="73" ID="XSID_EXCRG5-2661-000">
<DisplayName Value="HP 4000/4050 Fuser Assy" Language="en-US" />
</ProductVariant>
<ProductVariant ServiceLevel="NEW EXCHANGE" ListPrice="117" LastModified="2006-01-16T14:00:00" Price="117" ID="XSID_OEMEXRG5-2661-000">
<DisplayName Value="HP 4000/4050 Fuser Assy" Language="en-US" />
</ProductVariant>
<ProductVariant ServiceLevel="REFURB SALE" ListPrice="99" LastModified="2006-01-16T14:00:00" Price="99" ID="XSID_REFRG5-2661-000">
<DisplayName Value="HP 4000/4050 Fuser Assy" Language="en-US" />
</ProductVariant>
<ProductVariant ServiceLevel="RES SALE" ListPrice="148.66" LastModified="2006-01-16T14:00:00" Price="148.66" ID="XSID_RESSRG5-2661-000">
<DisplayName Value="HP 4000/4050 Fuser Assy" Language="en-US" />
</ProductVariant>
</Product>
</Catalog>
</MSCommerceCatalogCollection2>
I did some research into this and you need to create a rank attrabute:
<Product Definition="Parts" SKU="RG5-2661-000" UseCategoryPricing="0" ListPrice="0.00" LastModified="2006-01-16T14:00:00" ItemNmbr="HP4000-FUS" Manufacturer="HP" ManufacturerNmbr="C4118-69003/c4118-69011/RG5-2657/RG5-2661" Category="FUSER" Description="HP 4000/4050 Fuser Assy" ProductWeight="5" Image_filename="Images/HP4000-FUSS.jpg" Image_height="250" Image_width="225" ID="XSID_RG5-2661-000"
rank=1>
If there is no rank but the rest of the products are ranked the import process should push the product in the last position.
In my previouse post I noted that you should set the "Overwrite Relationships set to False" try setting it to True. I tested this using the Catalog Manager as the BizTalk adapter uses the same function and it works as expected.
Good luck,
-Max
