[Skip to main content](#vessel-content) # remove sold items automatically ## - **[karendunne](/forum/user/51903-karendunne "View karendunne's Profile")** - [![karendunne's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/51903-karendunne "View karendunne's Profile") Topic Author - [ Offline](/forum/user/51903-karendunne) Less More - Posts: 112 - Thank you received: 7 - - 3 years 11 months ago [\#346877](#346877) by [karendunne](/forum/user/51903-karendunne "View karendunne's Profile") *[remove sold items automatically](/forum/35-orders-management/905416-remove-sold-items-automatically#346877 "-- url of the page with the problem -- : antiqueswan.com/ -- HikaShop version -- : 4.6.2 -- Joomla version -- : 3.10.11 -- PHP version -- : 8.0 Our site sells one of a kind items. I'd like to know if items that have sold can automatically be removed from the system entirely; the images in particular. The sold items take a lot of space and I'm trying to reduce the size of the site.")* was created by *[karendunne](/forum/user/51903-karendunne "View karendunne's Profile")* -- url of the page with the problem -- : [ antiqueswan.com/](https://antiqueswan.com/) -- HikaShop version -- : 4.6.2 -- Joomla version -- : 3.10.11 -- PHP version -- : 8.0 Our site sells one of a kind items. I'd like to know if items that have sold can automatically be removed from the system entirely; the images in particular. The sold items take a lot of space and I'm trying to reduce the size of the site. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50LzkwNTQxNi1yZW1vdmUtc29sZC1pdGVtcy1hdXRvbWF0aWNhbGx5P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) 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)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86290 - Thank you received: 14268 - - 3 years 11 months ago [\#346880](#346880) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[remove sold items automatically](/forum/35-orders-management/905416-remove-sold-items-automatically#346880 "-- url of the page with the problem -- : antiqueswan.com/ -- HikaShop version -- : 4.6.2 -- Joomla version -- : 3.10.11 -- PHP version -- : 8.0 Our site sells one of a kind items. I'd like to know if items that have sold can automatically be removed from the system entirely; the images in particular. The sold items take a lot of space and I'm trying to reduce the size of the site.")* Hi, You could create a mass action with the trigger "every day" and a filter on the product column "product_quantity" being equal to 0 and an action "delete the elements" and it will delete the products with a stock of 0 once a day. This will also delete the images linked to the products being deleted automatically. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50LzkwNTQxNi1yZW1vdmUtc29sZC1pdGVtcy1hdXRvbWF0aWNhbGx5P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[karendunne](/forum/user/51903-karendunne "View karendunne's Profile")** - [![karendunne's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/51903-karendunne "View karendunne's Profile") Topic Author - [ Offline](/forum/user/51903-karendunne) Less More - Posts: 112 - Thank you received: 7 - - 3 years 10 months ago [\#347017](#347017) by [karendunne](/forum/user/51903-karendunne "View karendunne's Profile") Replied by *[karendunne](/forum/user/51903-karendunne "View karendunne's Profile")* on topic *[remove sold items automatically](/forum/35-orders-management/905416-remove-sold-items-automatically#347017 "-- url of the page with the problem -- : antiqueswan.com/ -- HikaShop version -- : 4.6.2 -- Joomla version -- : 3.10.11 -- PHP version -- : 8.0 Our site sells one of a kind items. I'd like to know if items that have sold can automatically be removed from the system entirely; the images in particular. The sold items take a lot of space and I'm trying to reduce the size of the site.")* Thank you, Nicolas, the mass action makes sense. In this scenario though, I'm haven't been able to find the right filter. The shop is set up as a catalog so when an item is "sold" it's actually sold offline. Then, we manually unpublish the item and add "sold" and "archived" to the category field. Please see screenshot. When an item is for sale, it is published and assigned to various categories. Please see screenshot. I've looked at all the filter possibilities but haven't been able to find an unpublished state to choose, or a "sold" and "archived" category to choose. When selecting "product columns" and "product_published = unpublished" the results (e.g. 1014) are the same as writing in "published," which is not correct. There are 375 published items. Could you offer some guidance for this particular set up? I will certainly run the mass action on a backup copy first, but even before that I wanted to see if I'm even getting close to the right settings. Thanks, Karen - [ ![Screenshot2022-11-29at9.44.38AM.png](/forum/attachment/55999) ](/forum/attachment/55999 "...t9.44.38AM.png") [ ](/forum/attachment/55999?download=1 "...t9.44.38AM.png") - [ ![Screenshot2022-11-29at9.51.37AM.png](/forum/attachment/56000) ](/forum/attachment/56000 "...t9.51.37AM.png") [ ](/forum/attachment/56000?download=1 "...t9.51.37AM.png") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50LzkwNTQxNi1yZW1vdmUtc29sZC1pdGVtcy1hdXRvbWF0aWNhbGx5P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) 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)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86290 - Thank you received: 14268 - - 3 years 10 months ago [\#347018](#347018) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[remove sold items automatically](/forum/35-orders-management/905416-remove-sold-items-automatically#347018 "-- url of the page with the problem -- : antiqueswan.com/ -- HikaShop version -- : 4.6.2 -- Joomla version -- : 3.10.11 -- PHP version -- : 8.0 Our site sells one of a kind items. I'd like to know if items that have sold can automatically be removed from the system entirely; the images in particular. The sold items take a lot of space and I'm trying to reduce the size of the site.")* Hi, You can indeed use the product_published column. You need to use the value "0" instead of "unpublished". Note that if you want to see what is filtered, you can use an action "display the results" instead of the "delete the elements" one. That way, you can confirm that the mass action will delete the correct elements when you change back the action. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50LzkwNTQxNi1yZW1vdmUtc29sZC1pdGVtcy1hdXRvbWF0aWNhbGx5P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[karendunne](/forum/user/51903-karendunne "View karendunne's Profile")** - [![karendunne's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/51903-karendunne "View karendunne's Profile") Topic Author - [ Offline](/forum/user/51903-karendunne) Less More - Posts: 112 - Thank you received: 7 - - 3 years 10 months ago - 3 years 10 months ago [\#347108](#347108) by [karendunne](/forum/user/51903-karendunne "View karendunne's Profile") Replied by *[karendunne](/forum/user/51903-karendunne "View karendunne's Profile")* on topic *[remove sold items automatically](/forum/35-orders-management/905416-remove-sold-items-automatically#347108 "-- url of the page with the problem -- : antiqueswan.com/ -- HikaShop version -- : 4.6.2 -- Joomla version -- : 3.10.11 -- PHP version -- : 8.0 Our site sells one of a kind items. I'd like to know if items that have sold can automatically be removed from the system entirely; the images in particular. The sold items take a lot of space and I'm trying to reduce the size of the site.")* Well, of course, I should have thought to set it to 0 instead of writing unpublished. Thank you. I have it working now from using the "process" button. Even though I had it set to trigger every minute, I had to manually process the mass action. Is that normal? Also, with the trigger selection, there is an option to choose every minutes, days, weeks, or months but not a field to set the number of minutes, days, weeks, or months. The selection being plural, e.g. days, makes me think there should be a trigger that I could set to occur every X number of days. Am I missing something here? Last edit: 3 years 10 months ago by [karendunne](/forum/user/51903-karendunne "View karendunne's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50LzkwNTQxNi1yZW1vdmUtc29sZC1pdGVtcy1hdXRvbWF0aWNhbGx5P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) 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)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86290 - Thank you received: 14268 - - 3 years 10 months ago [\#347111](#347111) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[remove sold items automatically](/forum/35-orders-management/905416-remove-sold-items-automatically#347111 "-- url of the page with the problem -- : antiqueswan.com/ -- HikaShop version -- : 4.6.2 -- Joomla version -- : 3.10.11 -- PHP version -- : 8.0 Our site sells one of a kind items. I'd like to know if items that have sold can automatically be removed from the system entirely; the images in particular. The sold items take a lot of space and I'm trying to reduce the size of the site.")* Hi, For the "every" triggers to work, you need to first setup your cron task: [ www.hikashop.com/support/documentation/5...ashop-cron-task.html](https://www.hikashop.com/support/documentation/55-hikashop-cron-task.html) Also, if you use a cron task triggered every 15 minutes, even if your mass action says every minute, it will only trigger every 15 minutes. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50LzkwNTQxNi1yZW1vdmUtc29sZC1pdGVtcy1hdXRvbWF0aWNhbGx5P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[karendunne](/forum/user/51903-karendunne "View karendunne's Profile")** - [![karendunne's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/51903-karendunne "View karendunne's Profile") Topic Author - [ Offline](/forum/user/51903-karendunne) Less More - Posts: 112 - Thank you received: 7 - - 3 years 10 months ago [\#347237](#347237) by [karendunne](/forum/user/51903-karendunne "View karendunne's Profile") Replied by *[karendunne](/forum/user/51903-karendunne "View karendunne's Profile")* on topic *[remove sold items automatically](/forum/35-orders-management/905416-remove-sold-items-automatically#347237 "-- url of the page with the problem -- : antiqueswan.com/ -- HikaShop version -- : 4.6.2 -- Joomla version -- : 3.10.11 -- PHP version -- : 8.0 Our site sells one of a kind items. I'd like to know if items that have sold can automatically be removed from the system entirely; the images in particular. The sold items take a lot of space and I'm trying to reduce the size of the site.")* Got it, thank you, Nicolas, for the link and explanation. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50LzkwNTQxNi1yZW1vdmUtc29sZC1pdGVtcy1hdXRvbWF0aWNhbGx5P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) 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.365 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)