I need some help with getting the original channel title for order items in Linnworks. It seems the Linnworks stores all the original channel titles in a table called item_channel_title which uses 2 fields for id and the title.
I am trying to reference the original title from each order item, however, many of the fkChannelTitleId fields do not contain a value which I assume is the id reference as I cannot find anything else in the schema.
oi.fkChannelTitleId AS 'Original ID'
[OrderItem] AS oi
Does anyone know another way to get the original title for the OrderItem as I see it is possible in the Linnworks processed orders export?
Thank you for your question.
The issue here is that you can retrieve titles using your way for all channels apart from eBay because eBay channel titles are not stored in the same database table I am afraid.
But you can retrieve channel titles for OrderItem separately for eBay and all the rest channels.
Here is how you can do it for eBay:
FROM [dbo].[OrderItem] oi
LEFT JOIN StockItems si
ON oi.fkStockid = si.pkStockId
WHERE oi.fkOrderId IN (
Source = 'EBAY')
Hope it helps!
Have a nice day.