UPDATE [Volusion_WCL_Categories]  
 SET [CategoryDescription] = '';

 /*---------UPDATE HEARTLAND ROLL PRIDUCT CATEGORIES-----------*/ 
 
UPDATE [Volusion_WCL_Categories]  
 SET [CategoryDescription] = '<div class="LabelTable"><table><tbody><tr><td>Wide</td><td>Long</td><td>Color</td><td>Perf</td><td>Outside Diameter</td><td>Labels Per Roll</td><td>Rolls Per Carton</td><td>Part 
Number</td><td>Shipping</td><td>Price</td><td>Ordering</td></tr>'  
FROM 
        [DistributorFeeds].[dbo].[Volusion_WCL_Categories] [Volusion_WCL_Categories]  
                LEFT OUTER JOIN [DistributorFeeds].[dbo].[Volusion_WCL_Products]  
                [Volusion_WCL_Products]  
                ON CAST([Volusion_WCL_Categories].[categoryid] AS NVARCHAR) = 
						CASE WHEN CHARINDEX(',',[Volusion_WCL_Products].[categoryids]) <> 0
							THEN LEFT ([Volusion_WCL_Products].[categoryids], CHARINDEX(',',[Volusion_WCL_Products].[categoryids])-1)
							ELSE [Volusion_WCL_Products].[categoryids]
						END
--					[Volusion_WCL_Products].[categoryids]  
                        RIGHT OUTER JOIN [DistributorFeeds].[dbo].[Price_List_Heartland]  
                        [Price_List_Heartland]  
                        ON [Price_List_Heartland].[MFGPN] = [Volusion_WCL_Products].  
                        [productcode]
WHERE
	([Volusion_WCL_Categories].[categoryname] LIKE '%roll%');

/* LOOP THROUGH ALL PRODUCT CODES*/
 DECLARE @productcode varchar(150), @width varchar(150)
 DECLARE c1 CURSOR FOR
	SELECT	Volusion_WCL_Products.productcode, [Price_List_Heartland].LAB_Label_Width
	FROM    Volusion_WCL_Products INNER JOIN
            [Price_List_Heartland] ON 
            Volusion_WCL_Products.productcode = [Price_List_Heartland].MFGPN
	ORDER BY 
	[Price_List_Heartland].[LAB_Label_Width] ASC,
	[Price_List_Heartland].[LAB_Label_Length] ASC,
	[Price_List_Heartland].[LAB_Outside_Diameter] ASC

 OPEN c1
 
 FETCH NEXT FROM c1 INTO @productcode, @width
 WHILE @@FETCH_STATUS = 0
 BEGIN
--	PRINT 'Processing product code ' + @productcode

/*--------------YOUR UPDATE ---------------*/ 
	UPDATE [Volusion_WCL_Categories]  
	 SET [CategoryDescription] = convert(nvarchar(max),[CategoryDescription]) +'<tr><td>'+ [Price_List_Heartland].[LAB_Label_Width] + '"</td><td>' + [Price_List_Heartland].[LAB_Label_Length]  
	+ '''</td>      <td>' + [Price_List_Heartland].[LAB_Color] + '</td><td>' + [Price_List_Heartland].[LAB_Perforation] + '</td><td>' + [Price_List_Heartland].[LAB_Outside_Diameter] + '"</td><td>' + [Price_List_Heartland].[LAB_Number_Per_Unit] + '</td><td>' + [Price_List_Heartland].[LAB_Units_Per_Carton] + '</td>'+
					'<td><a href="/product-p/' + [Price_List_Heartland].[MFGPN] +'.htm">' + [Price_List_Heartland].[MFGPN] + '</a></td><td> 
							Same Day Shipping On Orders Before 2:00pm CST</td><td> $' + CAST([Volusion_WCL_Products] .[productprice] AS VARCHAR) +  
							'<br/>Per Carton</td><td><a class="myButton" href="/ShoppingCart.asp?ProductCode=' + [Price_List_Heartland].[MFGPN] + '" "="">Add To Cart</a></td></tr>' 
	FROM 
			[DistributorFeeds].[dbo].[Volusion_WCL_Categories] [Volusion_WCL_Categories]  
					LEFT OUTER JOIN [DistributorFeeds].[dbo].[Volusion_WCL_Products]  
					[Volusion_WCL_Products]  
					ON	CAST([Volusion_WCL_Categories].[categoryid] AS NVARCHAR) = 
-- This case statement CASE..END extracts [categoryids] up to/exluding a comma, if there is one
						CASE WHEN CHARINDEX(',',[Volusion_WCL_Products].[categoryids]) <> 0
							THEN LEFT ([Volusion_WCL_Products].[categoryids], CHARINDEX(',',[Volusion_WCL_Products].[categoryids])-1)
							ELSE [Volusion_WCL_Products].[categoryids]
						END
					RIGHT OUTER JOIN [DistributorFeeds].[dbo].[Price_List_Heartland]  
						[Price_List_Heartland]  
					ON [Price_List_Heartland].[MFGPN] = [Volusion_WCL_Products].[productcode]
							
	-- ONLY APPEND DATA IF @productcode in loop MATCHES
	WHERE @productcode = [Volusion_WCL_Products].[productcode] AND
	([Volusion_WCL_Categories].[categoryname] LIKE '%roll%');

	FETCH NEXT FROM c1 INTO @productcode, @width
 END

DEALLOCATE c1
/* END LOOP */


 /*---------UPDATE HEARTLAND FANFOLD PRIDUCT CATEGORIES-----------*/ 
 
UPDATE [Volusion_WCL_Categories]  
 SET [CategoryDescription] = '<div class="LabelTable"><table><tbody><tr><td>Wide</td><td>Long</td><td>Color</td><td>Perf</td><td>Labels Per Stack</td><td>Stacks Per Carton</td><td>Part 
Number</td><td>Shipping</td><td>Price</td><td>Ordering</td></tr>'  
FROM 
        [DistributorFeeds].[dbo].[Volusion_WCL_Categories] [Volusion_WCL_Categories]  
                LEFT OUTER JOIN [DistributorFeeds].[dbo].[Volusion_WCL_Products]  
                [Volusion_WCL_Products]  
                ON CAST([Volusion_WCL_Categories].[categoryid] AS NVARCHAR) = 
						CASE WHEN CHARINDEX(',',[Volusion_WCL_Products].[categoryids]) <> 0
							THEN LEFT ([Volusion_WCL_Products].[categoryids], CHARINDEX(',',[Volusion_WCL_Products].[categoryids])-1)
							ELSE [Volusion_WCL_Products].[categoryids]
						END
--					[Volusion_WCL_Products].[categoryids]  
                        RIGHT OUTER JOIN [DistributorFeeds].[dbo].[Price_List_Heartland]  
                        [Price_List_Heartland]  
                        ON [Price_List_Heartland].[MFGPN] = [Volusion_WCL_Products].  
                        [productcode]
WHERE
	([Volusion_WCL_Categories].[categoryname] LIKE '%fanfold%');

/* LOOP THROUGH ALL PRODUCT CODES*/
 DECLARE @productcode2 varchar(150), @width2 varchar(150)
 DECLARE c1 CURSOR FOR
	SELECT	Volusion_WCL_Products.productcode, [Price_List_Heartland].LAB_Label_Width
	FROM    Volusion_WCL_Products INNER JOIN
            [Price_List_Heartland] ON 
            Volusion_WCL_Products.productcode = [Price_List_Heartland].MFGPN
	ORDER BY 	[Price_List_Heartland].[LAB_Label_Width] ASC,
	[Price_List_Heartland].[LAB_Label_Length] ASC

 OPEN c1
 
 FETCH NEXT FROM c1 INTO @productcode2, @width2
 WHILE @@FETCH_STATUS = 0
 BEGIN
--	PRINT 'Processing product code ' + @productcode2

/*--------------YOUR UPDATE ---------------*/ 
	UPDATE [Volusion_WCL_Categories]  
	 SET [CategoryDescription] = convert(nvarchar(max),[CategoryDescription]) +'<tr><td>'+ [Price_List_Heartland].[LAB_Label_Width] + '"</td><td>' + [Price_List_Heartland].[LAB_Label_Length]  
	+ '''</td>      <td>' + [Price_List_Heartland].[LAB_Color] + '</td><td>' + [Price_List_Heartland].[LAB_Perforation] + '</td><td>' + [Price_List_Heartland].[LAB_Number_Per_Unit] + '</td><td>' + [Price_List_Heartland].[LAB_Units_Per_Carton] + '</td>'+
					'<td><a href="/product-p/' + [Price_List_Heartland].[MFGPN] +'.htm">' + [Price_List_Heartland].[MFGPN] + '</a></td><td> 
							Same Day Shipping On Orders Before 2:00pm CST</td><td> $' + CAST([Volusion_WCL_Products] .[productprice] AS VARCHAR) +  
							'<br/>Per Carton</td><td><a class="myButton" href="/ShoppingCart.asp?ProductCode=' + [Price_List_Heartland].[MFGPN] + '" "="">Add To Cart</a></td></tr>' 
	FROM 
			[DistributorFeeds].[dbo].[Volusion_WCL_Categories] [Volusion_WCL_Categories]  
					LEFT OUTER JOIN [DistributorFeeds].[dbo].[Volusion_WCL_Products]  
					[Volusion_WCL_Products]  
					ON	CAST([Volusion_WCL_Categories].[categoryid] AS NVARCHAR) = 
-- This case statement CASE..END extracts [categoryids] up to/exluding a comma, if there is one
						CASE WHEN CHARINDEX(',',[Volusion_WCL_Products].[categoryids]) <> 0
							THEN LEFT ([Volusion_WCL_Products].[categoryids], CHARINDEX(',',[Volusion_WCL_Products].[categoryids])-1)
							ELSE [Volusion_WCL_Products].[categoryids]
						END
					RIGHT OUTER JOIN [DistributorFeeds].[dbo].[Price_List_Heartland]  
						[Price_List_Heartland]  
					ON [Price_List_Heartland].[MFGPN] = [Volusion_WCL_Products].[productcode]
							
	-- ONLY APPEND DATA IF @productcode2 in loop MATCHES
	WHERE @productcode2 = [Volusion_WCL_Products].[productcode] AND
	([Volusion_WCL_Categories].[categoryname] LIKE '%fanfold%');

	FETCH NEXT FROM c1 INTO @productcode2, @width2
 END

DEALLOCATE c1
/* END LOOP */

UPDATE [Volusion_WCL_Categories]  
 SET [CategoryDescription] = convert(nvarchar(max),[CategoryDescription]) +'</tbody></table></div>' 
FROM 
        [DistributorFeeds].[dbo].[Volusion_WCL_Categories] [Volusion_WCL_Categories]  
                LEFT OUTER JOIN [DistributorFeeds].[dbo].[Volusion_WCL_Products]  
                [Volusion_WCL_Products]  
                ON CAST([Volusion_WCL_Categories].[categoryid] AS NVARCHAR) = 
						CASE WHEN CHARINDEX(',',[Volusion_WCL_Products].[categoryids]) <> 0
							THEN LEFT ([Volusion_WCL_Products].[categoryids], CHARINDEX(',',[Volusion_WCL_Products].[categoryids])-1)
							ELSE [Volusion_WCL_Products].[categoryids]
						END
--                [Volusion_WCL_Products].[categoryids]  
                        RIGHT OUTER JOIN [DistributorFeeds].[dbo].[Volusion-DNP_Price_List]  
                        [Volusion-DNP_Price_List]  
                        ON [Volusion-DNP_Price_List].[DNPItem] = [Volusion_WCL_Products].  
                        [productcode]; 

 /*---------UPDATE BEFORE DNP PRIDUCTS-----------*/ 
 
UPDATE [Volusion_WCL_Categories]  
 SET [CategoryDescription] = '<div class="LabelTable"><table><tbody><tr><td>Width</td><td>Length</td><td>Ribbon Formulation</td><td>Core Diameter</td><td>Rolls Per Carton</td><td>Part 
Number</td><td>Shipping</td><td>Price</td><td>Ordering</td></tr>'  
FROM 
        [DistributorFeeds].[dbo].[Volusion_WCL_Categories] [Volusion_WCL_Categories]  
                LEFT OUTER JOIN [DistributorFeeds].[dbo].[Volusion_WCL_Products]  
                [Volusion_WCL_Products]  
                ON CAST([Volusion_WCL_Categories].[categoryid] AS NVARCHAR) = 
						CASE WHEN CHARINDEX(',',[Volusion_WCL_Products].[categoryids]) <> 0
							THEN LEFT ([Volusion_WCL_Products].[categoryids], CHARINDEX(',',[Volusion_WCL_Products].[categoryids])-1)
							ELSE [Volusion_WCL_Products].[categoryids]
						END
--					[Volusion_WCL_Products].[categoryids]  
                        RIGHT OUTER JOIN [DistributorFeeds].[dbo].[Volusion-DNP_Price_List]  
                        [Volusion-DNP_Price_List]  
                        ON [Volusion-DNP_Price_List].[DNPItem] = [Volusion_WCL_Products].  
                        [productcode];

/* LOOP THROUGH ALL PRODUCT CODES*/
 DECLARE @productcode3 varchar(150), @width3 varchar(150)
 DECLARE c1 CURSOR FOR
	SELECT	Volusion_WCL_Products.productcode, [Volusion-DNP_Price_List].Widthin
	FROM    Volusion_WCL_Products INNER JOIN
            [Volusion-DNP_Price_List] ON 
            Volusion_WCL_Products.productcode = [Volusion-DNP_Price_List].DNPItem
	ORDER BY [Volusion-DNP_Price_List].Widthin

 OPEN c1
 
 FETCH NEXT FROM c1 INTO @productcode3, @width3
 WHILE @@FETCH_STATUS = 0
 BEGIN
--	PRINT 'Processing product code ' + @productcode3

/*--------------YOUR UPDATE ---------------*/ 
	UPDATE [Volusion_WCL_Categories]  
	 SET [CategoryDescription] = convert(nvarchar(max),[CategoryDescription]) +'<tr><td>'+ [Volusion-DNP_Price_List].[Widthin] + '"</td><td>' + [Volusion-DNP_Price_List].[Lengthft]  
	+ '''</td>      <td>' + [Volusion-DNP_Price_List].[RibbonFormulation] + '</td><td>' +  [Volusion-DNP_Price_List].[Core] + '" Core Rolls</td><td>' + [Volusion-DNP_Price_List].[Rolls-Ctn] + 
					'</td><td><a href="/product-p/' + [Volusion-DNP_Price_List].[DNPItem] +'.htm">' + [Volusion-DNP_Price_List].[DNPItem] + '</a></td><td> 
							Same Day Shipping On Orders Before 1:00pm CST</td><td> $' + CAST([Volusion_WCL_Products] .[productprice] AS VARCHAR) +  
							'<br/>Per Carton</td><td><a class="myButton" href="/ShoppingCart.asp?ProductCode=' + [Volusion-DNP_Price_List].[DNPItem] + '" "="">Add To Cart</a></td></tr>' 
	FROM 
			[DistributorFeeds].[dbo].[Volusion_WCL_Categories] [Volusion_WCL_Categories]  
					LEFT OUTER JOIN [DistributorFeeds].[dbo].[Volusion_WCL_Products]  
					[Volusion_WCL_Products]  
					ON	CAST([Volusion_WCL_Categories].[categoryid] AS NVARCHAR) = 
-- This case statement CASE..END extracts [categoryids] up to/exluding a comma, if there is one
						CASE WHEN CHARINDEX(',',[Volusion_WCL_Products].[categoryids]) <> 0
							THEN LEFT ([Volusion_WCL_Products].[categoryids], CHARINDEX(',',[Volusion_WCL_Products].[categoryids])-1)
							ELSE [Volusion_WCL_Products].[categoryids]
						END
					RIGHT OUTER JOIN [DistributorFeeds].[dbo].[Volusion-DNP_Price_List]  
						[Volusion-DNP_Price_List]  
					ON [Volusion-DNP_Price_List].[DNPItem] = [Volusion_WCL_Products].[productcode]
							
	-- ONLY APPEND DATA IF @productcode in loop MATCHES
	WHERE @productcode3 = [Volusion_WCL_Products].[productcode]

	FETCH NEXT FROM c1 INTO @productcode3, @width3
 END

DEALLOCATE c1
/* END LOOP */

/*---------UPDATE AFTER DNP PRIDUCTS-----------*/ 
 
UPDATE [Volusion_WCL_Categories]  
 SET [CategoryDescription] = convert(nvarchar(max),[CategoryDescription]) +'</tbody></table></div>' 
FROM 
        [DistributorFeeds].[dbo].[Volusion_WCL_Categories] [Volusion_WCL_Categories]  
                LEFT OUTER JOIN [DistributorFeeds].[dbo].[Volusion_WCL_Products]  
                [Volusion_WCL_Products]  
                ON CAST([Volusion_WCL_Categories].[categoryid] AS NVARCHAR) = 
						CASE WHEN CHARINDEX(',',[Volusion_WCL_Products].[categoryids]) <> 0
							THEN LEFT ([Volusion_WCL_Products].[categoryids], CHARINDEX(',',[Volusion_WCL_Products].[categoryids])-1)
							ELSE [Volusion_WCL_Products].[categoryids]
						END
--                [Volusion_WCL_Products].[categoryids]  
                        RIGHT OUTER JOIN [DistributorFeeds].[dbo].[Volusion-DNP_Price_List]  
                        [Volusion-DNP_Price_List]  
                        ON [Volusion-DNP_Price_List].[DNPItem] = [Volusion_WCL_Products].  
                        [productcode]; 


 /*--------- HTML Before Product Tables-----------*/ 

UPDATE [Volusion_WCL_Categories]  
 SET [CategoryDescription] = convert(nvarchar(max),[CategoryDescriptionShort])  + convert(nvarchar(max),[CategoryDescription]);
UPDATE [Volusion_WCL_Categories]  
 SET [CategoryDescription] = '<div class="LabelTableHeading"><p>' + convert(nvarchar(max),[CategoryName]) + '</p></div>' + convert(nvarchar(max),[CategoryDescription]);

/*--------- Update General Fields-----------*/ 

UPDATE [Volusion_WCL_Categories]  
 SET [Display_Rows] = 100,
    [Default_SortBy] = 'Title';