<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Information on end-of-life for products in Ask A Question for DataSource</title>
    <link>https://community.1worldsync.com/t5/Ask-A-Question-for-DataSource/Information-on-end-of-life-for-products/m-p/18575#M21</link>
    <description>&lt;P&gt;At our company we need information about the&amp;nbsp;&lt;STRONG&gt;end-of-life&amp;nbsp;&lt;/STRONG&gt;for products.&lt;/P&gt;&lt;P&gt;&lt;A href="https://en.wikipedia.org/wiki/Product_lifecycle#Phase_4:_Service" target="_blank" rel="noopener"&gt;https://en.wikipedia.org/wiki/Product_lifecycle#Phase_4:_Service&lt;/A&gt;&lt;/P&gt;&lt;P&gt;In our database we have a lot of old products which we can no longer sell to our customers as distributors do no longer deliver these products. Examples are:&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;TABLE border="1" width="100%"&gt;&lt;TBODY&gt;&lt;TR&gt;&lt;TD width="50%"&gt;&lt;STRONG&gt;Mfg part number&lt;/STRONG&gt;&lt;/TD&gt;&lt;TD width="25%"&gt;&lt;STRONG&gt;DataSource SKU ID&lt;/STRONG&gt;&lt;/TD&gt;&lt;TD width="25%"&gt;&lt;STRONG&gt;Date of creation&lt;BR /&gt;(at our company)&lt;/STRONG&gt;&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD width="50%"&gt;283266-B21&lt;/TD&gt;&lt;TD width="25%"&gt;S1192379&lt;/TD&gt;&lt;TD width="25%"&gt;2004-02-21&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD width="50%"&gt;&lt;SPAN&gt;UR795E&lt;/SPAN&gt;&lt;/TD&gt;&lt;TD width="25%"&gt;&lt;SPAN&gt;S6662363&lt;/SPAN&gt;&lt;/TD&gt;&lt;TD width="25%"&gt;&lt;SPAN&gt;2009-11-07&lt;/SPAN&gt;&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD width="50%"&gt;AT152A#0D1&lt;/TD&gt;&lt;TD width="25%"&gt;&lt;SPAN&gt;S14964478&lt;/SPAN&gt;&lt;/TD&gt;&lt;TD width="25%"&gt;&lt;SPAN&gt;2014-06-17&lt;/SPAN&gt;&lt;/TD&gt;&lt;/TR&gt;&lt;/TBODY&gt;&lt;/TABLE&gt;&lt;DIV class=""&gt;&amp;nbsp;&lt;/DIV&gt;&lt;DIV class=""&gt;I wrote the following query:&lt;/DIV&gt;&lt;LI-CODE lang="python"&gt;SELECT 
	p.MfPN
	,a.IsObsolete
FROM
	CnetContent.dbo.cds_Catalog a WITH(READUNCOMMITTED)
	INNER JOIN CnetContent.dbo.cds_Prod p WITH(READUNCOMMITTED) ON a.ProdID = p.ProdID
WHERE
	p.MfPN IN ('283266-B21', 'UR795E', 'AT152A#0D1')&lt;/LI-CODE&gt;&lt;DIV class=""&gt;This gives me:&lt;/DIV&gt;&lt;DIV class=""&gt;&lt;TABLE border="1" width="99.87834549878346%"&gt;&lt;TBODY&gt;&lt;TR&gt;&lt;TD width="54.74452554744526%" height="17"&gt;&lt;STRONG&gt;MfPN&lt;/STRONG&gt;&lt;/TD&gt;&lt;TD width="45.1338199513382%"&gt;&lt;STRONG&gt;IsObsolete&lt;/STRONG&gt;&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD width="54.74452554744526%" height="17"&gt;283266-B21&lt;/TD&gt;&lt;TD width="45.1338199513382%"&gt;1&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD width="54.74452554744526%" height="17"&gt;AT152A#0D1&lt;/TD&gt;&lt;TD width="45.1338199513382%"&gt;0&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD width="54.74452554744526%" height="17"&gt;UR795E&lt;/TD&gt;&lt;TD width="45.1338199513382%"&gt;0&lt;/TD&gt;&lt;/TR&gt;&lt;/TBODY&gt;&lt;/TABLE&gt;&lt;P&gt;Can you please give me further information on how 1WorldSync defines &lt;STRONG&gt;IsObsolete&lt;/STRONG&gt;?&lt;BR /&gt;Is this term equivalent to&amp;nbsp;&lt;STRONG&gt;end-of-life&lt;/STRONG&gt;?&lt;/P&gt;&lt;/DIV&gt;</description>
    <pubDate>Thu, 26 Jun 2025 11:39:30 GMT</pubDate>
    <dc:creator>MichaelSlupina</dc:creator>
    <dc:date>2025-06-26T11:39:30Z</dc:date>
    <item>
      <title>Information on end-of-life for products</title>
      <link>https://community.1worldsync.com/t5/Ask-A-Question-for-DataSource/Information-on-end-of-life-for-products/m-p/18575#M21</link>
      <description>&lt;P&gt;At our company we need information about the&amp;nbsp;&lt;STRONG&gt;end-of-life&amp;nbsp;&lt;/STRONG&gt;for products.&lt;/P&gt;&lt;P&gt;&lt;A href="https://en.wikipedia.org/wiki/Product_lifecycle#Phase_4:_Service" target="_blank" rel="noopener"&gt;https://en.wikipedia.org/wiki/Product_lifecycle#Phase_4:_Service&lt;/A&gt;&lt;/P&gt;&lt;P&gt;In our database we have a lot of old products which we can no longer sell to our customers as distributors do no longer deliver these products. Examples are:&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;TABLE border="1" width="100%"&gt;&lt;TBODY&gt;&lt;TR&gt;&lt;TD width="50%"&gt;&lt;STRONG&gt;Mfg part number&lt;/STRONG&gt;&lt;/TD&gt;&lt;TD width="25%"&gt;&lt;STRONG&gt;DataSource SKU ID&lt;/STRONG&gt;&lt;/TD&gt;&lt;TD width="25%"&gt;&lt;STRONG&gt;Date of creation&lt;BR /&gt;(at our company)&lt;/STRONG&gt;&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD width="50%"&gt;283266-B21&lt;/TD&gt;&lt;TD width="25%"&gt;S1192379&lt;/TD&gt;&lt;TD width="25%"&gt;2004-02-21&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD width="50%"&gt;&lt;SPAN&gt;UR795E&lt;/SPAN&gt;&lt;/TD&gt;&lt;TD width="25%"&gt;&lt;SPAN&gt;S6662363&lt;/SPAN&gt;&lt;/TD&gt;&lt;TD width="25%"&gt;&lt;SPAN&gt;2009-11-07&lt;/SPAN&gt;&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD width="50%"&gt;AT152A#0D1&lt;/TD&gt;&lt;TD width="25%"&gt;&lt;SPAN&gt;S14964478&lt;/SPAN&gt;&lt;/TD&gt;&lt;TD width="25%"&gt;&lt;SPAN&gt;2014-06-17&lt;/SPAN&gt;&lt;/TD&gt;&lt;/TR&gt;&lt;/TBODY&gt;&lt;/TABLE&gt;&lt;DIV class=""&gt;&amp;nbsp;&lt;/DIV&gt;&lt;DIV class=""&gt;I wrote the following query:&lt;/DIV&gt;&lt;LI-CODE lang="python"&gt;SELECT 
	p.MfPN
	,a.IsObsolete
FROM
	CnetContent.dbo.cds_Catalog a WITH(READUNCOMMITTED)
	INNER JOIN CnetContent.dbo.cds_Prod p WITH(READUNCOMMITTED) ON a.ProdID = p.ProdID
WHERE
	p.MfPN IN ('283266-B21', 'UR795E', 'AT152A#0D1')&lt;/LI-CODE&gt;&lt;DIV class=""&gt;This gives me:&lt;/DIV&gt;&lt;DIV class=""&gt;&lt;TABLE border="1" width="99.87834549878346%"&gt;&lt;TBODY&gt;&lt;TR&gt;&lt;TD width="54.74452554744526%" height="17"&gt;&lt;STRONG&gt;MfPN&lt;/STRONG&gt;&lt;/TD&gt;&lt;TD width="45.1338199513382%"&gt;&lt;STRONG&gt;IsObsolete&lt;/STRONG&gt;&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD width="54.74452554744526%" height="17"&gt;283266-B21&lt;/TD&gt;&lt;TD width="45.1338199513382%"&gt;1&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD width="54.74452554744526%" height="17"&gt;AT152A#0D1&lt;/TD&gt;&lt;TD width="45.1338199513382%"&gt;0&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD width="54.74452554744526%" height="17"&gt;UR795E&lt;/TD&gt;&lt;TD width="45.1338199513382%"&gt;0&lt;/TD&gt;&lt;/TR&gt;&lt;/TBODY&gt;&lt;/TABLE&gt;&lt;P&gt;Can you please give me further information on how 1WorldSync defines &lt;STRONG&gt;IsObsolete&lt;/STRONG&gt;?&lt;BR /&gt;Is this term equivalent to&amp;nbsp;&lt;STRONG&gt;end-of-life&lt;/STRONG&gt;?&lt;/P&gt;&lt;/DIV&gt;</description>
      <pubDate>Thu, 26 Jun 2025 11:39:30 GMT</pubDate>
      <guid>https://community.1worldsync.com/t5/Ask-A-Question-for-DataSource/Information-on-end-of-life-for-products/m-p/18575#M21</guid>
      <dc:creator>MichaelSlupina</dc:creator>
      <dc:date>2025-06-26T11:39:30Z</dc:date>
    </item>
  </channel>
</rss>

