6 Antworten zu diesem Thema

[leonidas_fs]

Hello everyone,

I am going to host a e-shop with electronics, so I would like to know if there is a way to customize the URL of my website so it will be like:  www.domainname.com/category/product

 

Now once you enter a category and your click on a product, the URL automatically goes like:

www.domainname.com/product

 

 

 

Thank you!

[Wolfgang Schmerge]

Hi,

 

welcome to our forum.

You can enter any url alias in the product details.

 

Regards

 

Wolfgang

Angehängte Bilder

•  url-alias.JPG   68.59K   0 Anzahl Downloads

[leonidas_fs]

Hello,

But how can i add the category before the product on the URL? 
So for example it will be: games/assassins-greed-iii ?

 

Here is my eshop to check what i am talking about.

If you navigate on a category, the URL is like: domainname/category

However if you click on a product, it goes like: domainname/product-url, while I want to be domainame/category/product-url

[Wolfgang Schmerge]

Hi,

 

yes, like this example:

plugadaptors/assassins-creed-iii

 

Regards

 

Wolfgang

Angehängte Bilder

•  url-alias-2.JPG   34.99K   0 Anzahl Downloads

[leonidas_fs]

Ok thank you for your reply!

Is there any way to make the change on bulk?

[Wolfgang Schmerge]

Hello,

 

unfortunately not.

 

Regards

 

Wolfgang

[nickh]

There actually is a fairly easy way to do this in bulk, but it involves writing some SQL:

 

UPDATE

UrlRecord SET Slug = categoryUrl.Slug + '/' + u.Slug

  FROM [SmartStore].[dbo].[Product] p

  inner join [SmartStore].[dbo].Product_Category_Mapping pcm ON pcm.ProductId = p.Id

  inner join [SmartStore].[dbo].Category c on c.Id = pcm.CategoryId

  inner join UrlRecord u on u.EntityId = p.Id AND u.EntityName = 'Product'

  inner join UrlRecord categoryUrl on categoryUrl.EntityId = c.Id AND u.EntityName = 'Category'

 

 

(I don't have a DB to test this on at the moment so there may be bugs with the above SQL).  Run it in a transaction (with rollback), and a "select * from UrlRecord" before and after, to see the results.

 

Hope this helps you see what I mean.