I would like to how I can get the url of all products through a sql query.
I don't want to export all 10000s products in an excel file, I want to get the urls via SQL.
Regards
use [NopCommerce380] -- Use your database name here
go
declare @URL nvarchar(400)
select @URL=URL from Store
--set @URL='http://localhost:380/'
-- here you can hardcode your url also
select p.Id 'ProductId',p.Name 'Product Name',
@URL + 'content/images/' + FORMAT(ppm.PictureId, '0000000') + '_0' +
CASE
WHEN pic.MimeType='image/jpeg' THEN '.jpeg'
WHEN pic.MimeType='image/pjpeg' THEN '.jpg'
WHEN pic.MimeType='image/png' THEN '.png'
--ELSE '.gif'
END 'Image_URL',
@URL + 'content/images/thumbs/' + FORMAT(ppm.PictureId, '0000000') + '_' + u.Slug +
CASE
WHEN pic.MimeType='image/jpeg' THEN '.jpeg'
WHEN pic.MimeType='image/pjpeg' THEN '.jpg'
WHEN pic.MimeType='image/png' THEN '.png'
--ELSE '.gif'
END 'Image_Thumnail_URL'
from UrlRecord U
join Product_Picture_Mapping PPM ON u.EntityId=ppm.ProductId
join Product p on ppm.ProductId=p.Id
join Picture pic on PPM.PictureId=pic.Id
where u.EntityName='Product' and u.IsActive=1
order by p.Id