Retrieve Channel Specific Titles, Prices and Descriptions - Report added to Query Database
Martin West
started a topic
about 5 years ago
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
Mark Aldous
said
almost 5 years ago
Hi,
this report is available in the system.
I can not remember when it was first added, but I am sure it has been there for over a year at least
Martin West
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