Product export => XML with price, stock and more

Sonni Tost

Posted on 06/10/2015 11:31:51

Hi all,

Is there an easy way to make an export of all products / product variants with stock status, price, delivery time into an xml file with the format below. Can it be done using the Data Integration?

   <product>
       <Category>{Category}</Category>
       <ProductName>{Name of product}</ProductName>
       <ProductSKU>{ID of product}</ProductSKU>
       <Price>{Price}</Price>
       <ShippingCost>{Shipping cost}</ShippingCost>
       <ProductURL>{http://productnum}</ProductURL>
       <ManufacturerSKU>-</ManufacturerSKU>
       <ManufacturerName>-</ManufacturerName>
       <EAN />
       <Description>{Description of product}</Description>
       <imageURL>{http://web/product.jpg}</imageURL>
       <StockStatus>{På lager}</StockStatus>
       <DeliveryTime>{1-3 dage}</DeliveryTime>
       <RetailerMessage>{Message}</RetailerMessage>
   </product>

Kind regards

Sonni T.

Replies

Jonas Krarup Dam

Posted on 06/10/2015 12:15:53

Hi Sonni,

In the Data Integration, when using the XML Destination provider, you can define an XSLT to be applied to the output after the export is completed.

This should allow you to export product data in any XML format you need.

Regards, Jonas

Adrian Ursu

Posted on 06/10/2015 12:18:54

I believe productURL is not available as a field in DataIntegration. It would be very nice to have a CanonicalUrl field available in DataIntegration

Jonas Krarup Dam

Posted on 06/10/2015 13:23:27

You are right Adrian. - I missed that one.

You'll have to construct that url as part of the XSLT.

Regards, Jonas

Adrian Ursu

Posted on 06/10/2015 14:40:16

You probably can't :)

In order to construct that URL you need PageID, GroupID and ProductID.

While you might have a single PageID for the catalog, the GroupID is missing from the DataIntegration options if I remember correctly. I might be mistaken, so please don't take my word for it.

Adrian

Nicolai Høeg Pedersen

Posted on 06/10/2015 15:26:44

The best option for doing this, is making a page with the ecommerce module attached, give it a template that creates a feed in the desired format, and publish that.

See this article: http://developer.dynamicweb.com/documentation/how-to-guides/ecommerce/google-merchant-feed.aspx

You can combine that with paging, searching, sorting and then publish it in any text based format you like. That would also generate the URLs for you.

BR Nicolai

Sonni Tost

Posted on 06/10/2015 16:00:14

Hi all,

Thank you all for your input!

I was just about to try out the Data Integration export with xsl - but the suggestion from you, Nicolai, seems much simpler, Nicolai. Why didn't i think of that!? Anyway - I will try that out! :-)

Kind regards

Sonni T.

You must be logged in to post in the forum

Developer forum

Product export => XML with price, stock and more

Replies