It would be nice if this option was added to the list to choose from, rather than having to paste below in each time. A useful feature when moving to new marketplaces.

It would be nice to be able to group and edit this list to make the 'search' easier.

 Retrieve Channel Specific Titles, Prices and Descriptions

-- Retrieve Title, Price and Description as used by LinnLive when generating listings

DECLARE @Source NVARCHAR(25) = 'EBAY'

DECLARE @SubSource NVARCHAR(255) = 'EBAY1'

SELECT 

si.ItemNumber, 

t.Source,

t.SubSource,

t.Title,

p.SalePrice,

d.Description

FROM

[StockItem] si

INNER JOIN StockItem_Titles t ON si.pkStockItemId = t.fkStockItemId

INNER JOIN StockItem_Descriptions d ON si.pkStockItemId = d.fkStockItemId

AND t.Source = d.Source

AND t.SubSource = d.SubSource

INNER JOIN StockItem_Pricing p ON si.pkStockItemId = p.fkStockItemId

AND t.Source = p.Source 

AND t.SubSource = p.SubSource

WHERE

si.bLogicalDelete = 0

AND t.Source = @Source

AND t.SubSource = @SubSource

ORDER BY

si.ItemNumber