Implemented

Retrieve Channel Specific Titles, Prices and Descriptions - Report added to Query Database

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

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


Please use the following to take a look at all the reports in the system



Login to post a comment