[Skip to main content](#vessel-content) # How to empty all conical url's with mass action ## - **[renem](/forum/user/47055-renem "View renem's Profile")** - [![renem's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar47055.jpg)](/forum/user/47055-renem "View renem's Profile") Topic Author - [ Offline](/forum/user/47055-renem) Less More - Posts: 198 - Thank you received: 7 - - - [](http://www.muldermedia.nl) - 9 years 1 month ago [\#278534](#278534) by [renem](/forum/user/47055-renem "View renem's Profile") *[How to empty all conical url's with mass action](/forum/25-install-update/891962-how-to-empty-all-conical-urls-with-mass-action#278534 "-- HikaShop version -- : 3.2.0 I'm trying to empty the conical URL's with mass action but got no luck. For now on i get a 0 on every canonical URL i trie to clear. What are the right setting for mass action to clear them all? Regards René")* was created by *[renem](/forum/user/47055-renem "View renem's Profile")* -- HikaShop version -- : 3.2.0 I'm trying to empty the conical URL's with mass action but got no luck. For now on i get a 0 on every canonical URL i trie to clear. What are the right setting for mass action to clear them all? Regards René Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg5MTk2Mi1ob3ctdG8tZW1wdHktYWxsLWNvbmljYWwtdXJscy13aXRoLW1hc3MtYWN0aW9uP3RtcGw9bWFya2Rvd24=) or [Create an account](/register) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86322 - Thank you received: 14280 - - 9 years 1 month ago [\#278540](#278540) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[How to empty all conical url's with mass action](/forum/25-install-update/891962-how-to-empty-all-conical-urls-with-mass-action#278540 "-- HikaShop version -- : 3.2.0 I'm trying to empty the conical URL's with mass action but got no luck. For now on i get a 0 on every canonical URL i trie to clear. What are the right setting for mass action to clear them all? Regards René")* Hi, If you get 0 instead of nothing, it means that you must have selected "integer" instead of "string" for the type of the operation in your action. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg5MTk2Mi1ob3ctdG8tZW1wdHktYWxsLWNvbmljYWwtdXJscy13aXRoLW1hc3MtYWN0aW9uP3RtcGw9bWFya2Rvd24=) or [Create an account](/register) to join the conversation. - **[xatzopou](/forum/user/35543-xatzopou "View xatzopou's Profile")** - [![xatzopou's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/35543-xatzopou "View xatzopou's Profile") - [ Offline](/forum/user/35543-xatzopou) Less More - Posts: 52 - Thank you received: 1 - - 8 years 3 months ago - 8 years 3 months ago [\#295745](#295745) by [xatzopou](/forum/user/35543-xatzopou "View xatzopou's Profile") Replied by *[xatzopou](/forum/user/35543-xatzopou "View xatzopou's Profile")* on topic *[How to empty all conical url's with mass action](/forum/25-install-update/891962-how-to-empty-all-conical-urls-with-mass-action#295745 "-- HikaShop version -- : 3.2.0 I'm trying to empty the conical URL's with mass action but got no luck. For now on i get a 0 on every canonical URL i trie to clear. What are the right setting for mass action to clear them all? Regards René")* Hello, I tried to update -using mass-actions- **products canonical url's** value to be equal to **proionta/product's alias** but i get wrong Canonical URLs. I add an action (see attachment) "**Update the values**", select **product\_canonical** = **STRING** to **proionta/product.product\_alias** ( also experiment with **proionta/product\_alias** or **product\_alias**) E.g. I have the **Product A** with **Alias**: product-a and I want to auto update **Canonical URL to**: proionta/product-a but the result for all of my products is proionta/product.product_alias In the page [ www.hikashop.com/support/documentation/167-massaction-form.html](https://www.hikashop.com/support/documentation/167-massaction-form.html) I saw that you may use hikashop table's fields in your actions. What am I missing? P.S. Hikashop ver HikaShop Business: 3.5.1 - [ ![Screenshot_2018-07-23Massactions.png](/forum/attachment/44311) ](/forum/attachment/44311 "...assactions.png") [ ](/forum/attachment/44311?download=1 "...assactions.png") Last edit: 8 years 3 months ago by [xatzopou](/forum/user/35543-xatzopou "View xatzopou's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg5MTk2Mi1ob3ctdG8tZW1wdHktYWxsLWNvbmljYWwtdXJscy13aXRoLW1hc3MtYWN0aW9uP3RtcGw9bWFya2Rvd24=) or [Create an account](/register) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86322 - Thank you received: 14280 - - 8 years 3 months ago [\#295748](#295748) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[How to empty all conical url's with mass action](/forum/25-install-update/891962-how-to-empty-all-conical-urls-with-mass-action#295748 "-- HikaShop version -- : 3.2.0 I'm trying to empty the conical URL's with mass action but got no luck. For now on i get a 0 on every canonical URL i trie to clear. What are the right setting for mass action to clear them all? Regards René")* Hi, The "string" type won't allow you to do any operation. So the string proionta/product.product_alias will be used "as is" as a canonical URL. You need to change the type to "operation". Also, you need to change the text to be valid MySQL, like that: concat('proionta/',product.product_alias) Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg5MTk2Mi1ob3ctdG8tZW1wdHktYWxsLWNvbmljYWwtdXJscy13aXRoLW1hc3MtYWN0aW9uP3RtcGw9bWFya2Rvd24=) or [Create an account](/register) to join the conversation. - **[xatzopou](/forum/user/35543-xatzopou "View xatzopou's Profile")** - [![xatzopou's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/35543-xatzopou "View xatzopou's Profile") - [ Offline](/forum/user/35543-xatzopou) Less More - Posts: 52 - Thank you received: 1 - - 8 years 3 months ago - 8 years 3 months ago [\#295802](#295802) by [xatzopou](/forum/user/35543-xatzopou "View xatzopou's Profile") Replied by *[xatzopou](/forum/user/35543-xatzopou "View xatzopou's Profile")* on topic *[How to empty all conical url's with mass action](/forum/25-install-update/891962-how-to-empty-all-conical-urls-with-mass-action#295802 "-- HikaShop version -- : 3.2.0 I'm trying to empty the conical URL's with mass action but got no luck. For now on i get a 0 on every canonical URL i trie to clear. What are the right setting for mass action to clear them all? Regards René")* Hello Nicolas, It seems that type "operation" is not working. I applied your suggestions but the result is **concat('proionta/',product.product\_alias)** for all my products. I also experimented with just " **product.product\_alias** " and realized that type "operation" seems to work as "string" type. The result of my second try and for all my products is **product.product\_alias**. Thank you for your reply. Makis - [ ![Screenshot.png](/forum/attachment/44327) ](/forum/attachment/44327 "Screenshot.png") [ ](/forum/attachment/44327?download=1 "Screenshot.png") - [ ![Screenshot2.png](/forum/attachment/44328) ](/forum/attachment/44328 "Screenshot2.png") [ ](/forum/attachment/44328?download=1 "Screenshot2.png") Last edit: 8 years 3 months ago by [xatzopou](/forum/user/35543-xatzopou "View xatzopou's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg5MTk2Mi1ob3ctdG8tZW1wdHktYWxsLWNvbmljYWwtdXJscy13aXRoLW1hc3MtYWN0aW9uP3RtcGw9bWFya2Rvd24=) or [Create an account](/register) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86322 - Thank you received: 14280 - - 8 years 3 months ago [\#295837](#295837) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[How to empty all conical url's with mass action](/forum/25-install-update/891962-how-to-empty-all-conical-urls-with-mass-action#295837 "-- HikaShop version -- : 3.2.0 I'm trying to empty the conical URL's with mass action but got no luck. For now on i get a 0 on every canonical URL i trie to clear. What are the right setting for mass action to clear them all? Regards René")* Hi, I did a similar test on my end and it works fine: [ monosnap.com/file/V46mT80R6yMJZTbmxYUQJTpQHyLss4](https://monosnap.com/file/V46mT80R6yMJZTbmxYUQJTpQHyLss4) [ monosnap.com/file/lSDSHsgKhF8aBxtgIQEu9xrrdVnElM](https://monosnap.com/file/lSDSHsgKhF8aBxtgIQEu9xrrdVnElM) The alias is correctly appended to the test/ in the canonical URL field when I click on the "process" button of the mass action. So I can only think that you didn't do your test with the "operation" type selected. Your result looks as if you were using "string" instead. Can you please double check ? The following user(s) said Thank You: [xatzopou](/forum/user/35543-xatzopou "View xatzopou's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg5MTk2Mi1ob3ctdG8tZW1wdHktYWxsLWNvbmljYWwtdXJscy13aXRoLW1hc3MtYWN0aW9uP3RtcGw9bWFya2Rvd24=) or [Create an account](/register) to join the conversation. Board Categories HikaShop Install & Update Product & Category Display Content Creation Sales and Orders Orders management Reports & Statistics Customers Checkout Payment Methods Shipping Methods Import & Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel & Slider Mass Actions Filters & Search Discount & Coupon Feature Request Integrations Showcase General Talk about HikaShop Development HikaShop 3.0 Beta Translation Commercial Jobs HikaShop Components HikaMarket Market: Feature requests Market: How to? Market: Bug Report HikaSerial General talk about HikaSerial Serial: Bug Report Serial: How to? Support en Français de HikaSerial (French Support) HikaSubscription HikaAuction Auction: Feature requests Auction: How to? Auction: Bug report Hikashop around the world Support en Français (French Support) Russian FAQ. Курс выживания с Hikashop. Частые вопросы и о Расширения Hikashop Наши сайты на Hikashop 日本語版サポート(Japanese Support) Thai German Archives Bug Report How to? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.073 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)