Feed Data Integrity Reivew

This document is in Beta stage and we have try to cover all topics in right hierarchy yet indepth. To make this document better, we need your help. Please give your feedback by rating the stars at the end of each topic. For more updates join slack channel #unbxd-knowledgebase

Use this document for internal purpose only. It is not suppose to be shared with customers


In this stage of feed review, we review and validate the data of different attributes of the feed. An attribute in a feed can contain legitimate values, null values or unknown values. We need to explore these discrepancies in the early stages of the feed review itself so that we can avoid delays and other rework.

Let's consider this sample feed

<?xml version="1.0" encoding="UTF-8"?>
<root>
   <element>
      <categories>Home&gt;Mens&gt;shirts,</categories>
      <description>This is the ultimate flexi-top of the season, thanks to the generous number of prints and hues to add to your summer collection. The Capture Linen Boxy Tee is a brilliant everyday piece with flattering dropped shoulders and a rolled finish to the cuffs for added flair</description>
      <images>https://image.url/image1.jpg,https://image.url/image.jpg,https://image.url/image3.jpg</images>
      <labels>New</labels>
      <parentId null="true" />
      <price>70</price>
      <size>8</size>
      <sku>AD123</sku>
      <is-available>1</is-available>
      <title>Capture Linen Boxy Tee</title>
   </element>
   <element>
      <categories>Home&gt;Mens&gt;shirts,</categories>
      <description>This is the ultimate flexi-top of the season, thanks to the generous number of prints and hues to add to your summer collection. The Capture Linen Boxy Tee is a brilliant everyday piece with flattering dropped shoulders and a rolled finish to the cuffs for added flair</description>
      <images>https://image.url/image1.jpg,https://image.url/image.jpg,https://image.url/image3.jpg</images>
      <labels>New</labels>
      <parentId>AD123</parentId>
      <price></price>
      <size>10</size>
      <sku>AD123</sku>
      <is-available>1</is-available>
      <title>Capture Linen Boxy Tee</title>
   </element>
   <element>
      <categories>Home&gt;Mens&gt;shirts,</categories>
      <description>This is the ultimate flexi-top of the season, thanks to the generous number of prints and hues to add to your summer collection. The Capture Linen Boxy Tee is a brilliant everyday piece with flattering dropped shoulders and a rolled finish to the cuffs for added flair</description>
      <images>https://image.url/image1.jpg,https://image.url/image.jpg,https://image.url/image3.jpg</images>
      <labels>New</labels>
      <parentId>AD123</parentId>
      <price>70</price>
      <size>12</size>
      <sku>AD123</sku>
      <is-available>0</is-available>
      <title>Capture Linen Boxy Tee</title>
   </element>
   <element>
      <categories>Home&gt;Women's&gt;shirts,</categories>
      <description>Enjoy the classic colourways Sara's used for this elegant Tri Button Top. A great all-season piece, this light top has gorgeous drape-style shoulders and with the buttons at the front and side to add subtle, pretty design detail.</description>
      <images>https://image.url/image1.jpg,https://image.url/image.jpg,https://image.url/image3.jpg</images>
      <labels>New</labels>
      <parentId null="true" />
      <price>70</price>
      <size>8</size>
      <sku>AD567</sku>
      <is-available>1</is-available>
      <title>Sara Tri Button Top</title>
   </element>
   <element>
      <categories>Home&gt;Women's&gt;shirts,</categories>
      <description>Enjoy the classic colourways Sara's used for this elegant Tri Button Top. A great all-season piece, this light top has gorgeous drape-style shoulders and with the buttons at the front and side to add subtle, pretty design detail.</description>
      <images>https://image.url/image1.jpg,https://image.url/image.jpg,https://image.url/image3.jpg</images>
      <labels>New</labels>
      <parentId>AD567</parentId>
      <price>70</price>
      <size>10</size>
      <sku>AD567</sku>
      <is-available></is-available>
      <title>Sara Tri Button Top</title>
   </element>
   <element>
      <categories>Home&gt;Women's&gt;shirts,</categories>
      <description>Enjoy the classic colourways Sara's used for this elegant Tri Button Top. A great all-season piece, this light top has gorgeous drape-style shoulders and with the buttons at the front and side to add subtle, pretty design detail.</description>
      <images>https://image.url/image1.jpg,https://image.url/image.jpg,https://image.url/image3.jpg</images>
      <labels>New</labels>
      <parentId>AD567</parentId>
      <price></price>
      <size>12</size>
      <sku>AD567</sku>
      <is-available>1</is-available>
      <title>Sara Tri Button Top</title>
   </element>
</root>

In this stage of feed review, we need to validate different attribute for any unwanted values. However before jumping right into it, it would be helpful if we can infer which attributes are worth checking. This become more important if a feed contains hundred's of product attributes.

So if we take above feed into the consideration then we expect following fields to be worth investigating

  • categories
  • price
  • sku
  • is-available

If we check distinct values on

  • categories field then you would see all product contains legitimate values.
  • price field does have empty values so which does not make sense so here you got a feed review question
  • sku field has all legitimate values.
  • is-available field suppose to have only 1 and 0 but in some products it does not have any value.

So from above exercise you got two feed review questions

Feed Review

Prices for some products are empty and having empty value in is-available flag what does it mean?


Did you find it useful? Rate it

← Feed Product ReviewFeed Logic Review →