Commerce Server 2007 catalogwebservice and bizTalk 2006

Commerce Server 2007 catalogwebservice and bizTalk 2006

• RMan54

  Hey Dom,

  The query response for Catalog is just the catalog xsd. For instance, in the out of the box schemas, the query response will have the XSD of DefaultCatalog.xsd. For your particular catalog, you want to get the XSD from ExportCatalog.exe.

  Let me know if you have additional questions or need more information.

  Thanks

  Alan

  
  
  

• Enkht

  Thanks again Alan for the info.
  
  I don’t generate the SKUs. I connect to a web service where I download the product SKUs. Then I need to get the product ID from commerce server in an orchestration. I was thinking of using the commerce server catalog adapter to query the product using its SKU that I get from the web service. I have an example of the XML file to send to the adapter and its listed below;
  
  < xml version="1.0" encoding="utf-8" >
  <CommerceServerInventoryQuery InventoryCatalog="Adventure Works Inventory" SearchClause="INV.SkuId = 'AW140-13'"></CommerceServerInventoryQuery>
  
  I am a little confused with the SearchClause attribute. I am not sure how this is formed I want to search on VariantID so I can get the product ID back to insert into my inventory update xml. Can you show me the search clause I would need
  
  Thanks
  Dom

  
  
  
  
  
  
  
  
  

• wendling lionel

  Dom,

  I'm using the Biztalk Inventory Adapter to handle my inventory stock with no problems.

  The OnLine Help is very usefull to get a direction to start the development.

  This links could be usefull

  • Working with the BizTalk Adapters

  http://msdn.microsoft.com/library/default.asp url=/library/en-us/CS07Default/html/02afcee1-5546-4acc-b053-2aa6d7762bd3.asp

  • Configuring an Inventory Adapter Endpoint

  http://msdn.microsoft.com/library/default.asp url=/library/en-us/CS07Default/html/02afcee1-5546-4acc-b053-2aa6d7762bd3.asp

  Willian Leite

  http://wleite.blogspot.com

  
  
  

• thejez

  Thanks Alan,
  
  That worked well, the only thing is that we only have the variant Id and not the product Id given to us. How or what is the best way to update the stock with just the variant Id. Also what does the status field represent in this XML
  
  thanks
  Dom
  
  

• danskcarvalho

  Hey Dom,

  Yes - You can use the Inventory Adapter to update the inventory in your system. The inventory adapter works on an incoming xml file. It will use this file to import the inventory into the system. To have that file be an update, you would need to make sure that you have the import mode set to incremental (not replace). You also need to make sure that you include the new quantity numbers in the incoming inventory xml file for the products that you want to update.

  To query for quantity of products using the Inventory Receive Adapter, you can specify your query clause in the Products And Categories Clause on the Adapter's endpoint configuration. If you are using the Inventory Send Adapter, you can use the query xml to specify the quantity that you want to search/filter on (this is the SearchClause property of the xml search type). You can find sample messages in the SDK directory under your Commerce Server installation directory.

  Hope this helps and let me know if you have additional questions.

  -Alan

  
  
  

• Raymundo Chapa94595

  Hey Dom,

  Did you get a response message back from the Inventory Send Adapter If so, what are the contents of that message

  I see you are missing a couple of fields, the format below will work:

  < xml version="1.0" encoding="utf-8" >

  <MSInventoryCollection version="1.0">

  <InventoryCatalog name="Adventure Works Inventory">

  <InventorySku ProductCatalogName="Adventure Works Catalog" ProductId="AW007-08" VariantId="44" OnHandQuantity="999999" Status="1" />

  .......

  </InventoryCatalog>

  </MSInventoryCollection>

  Hope this helps!

  Alan

  
  
  

• maxym_urt

  Hi,
  
  Thanks for the reply. I have gone as far as installing the adapter and configuring it. Now I am submitting the XML below into it to update the stock Quantity On Hand in the inventory catalog. I do not get any errors or any change in the inventory quantity with this XML below.
  
  <MSInventoryCollection version="1.0">
  <InventoryCatalog name="Default">
  <ProductCatalog name="ADVW"></ProductCatalog>
  <InventorySku ProductCatalogName="ADVW" VariantId="54121380848011" OnHandQuantity="5"></InventorySku>
  </InventoryCatalog>
  </MSInventoryCollection>
  
  I used the example in the SDK to construct this XMl. Am I missing anything from it
  
  Regards
  Dom

  
  
  
  

• Rohit Parasharami

  Thanks for the info.
  
  I did take a look but could not find what i was looking for. Can anyone post the CommerceServerCatalogQueryResponse xsd. I can not seem to find it in the sample messages SDK.
  
  Thanks
  Dom
  
  

• tenchyz

  Dom,

  There is an excellent Web Cast at Microsoft showing the setup of BizTalk and Inventory.

  http://www.microsoft.com/technet/prodtechnol/comm/2007/webcasts.mspx

  Xcel.

  
  

• ku19832001

  Hi Alan,
  
  Great thanks for all your help, it worked great!
  
  Dom
  
  

• YMaod

  Hey Dom,

  The status field is required and represents the following:

  Status = 1 ==> Inventory Sku is enabled

  Status = 0 ==> Inventory Sku is disabled. Product is always out of stock.

  Status = 2 ==> Inventory is ignored. Product is always in stock.

  When updating the Quantity for a Inventory Sku, you must indicate the ProductId and VariantId. This is because the VariantId is only unique for the given ProductId, so you must pass both.

  You can get the ProductId from the InventorySku object (this object is in the Microsoft.CommerceServer.Inventory namespace) for that particular sku. So if you have some business logic to generate the Inventory update xml file, you can add code to get the InventorySku object that is going to be updated, then you can access the ProductId property for that particular sku and output that to the xml file.

  Hope this helps!

  Alan

  
  
  
• Commerce Server 2007 catalogwebservice and bizTalk 2006