[Skip to main content](#vessel-content) # Delete Product in test database ## - **[charlesdh](/forum/user/33634-charlesdh "View charlesdh's Profile")** - [![charlesdh's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar33634.jpg)](/forum/user/33634-charlesdh "View charlesdh's Profile") Topic Author - [ Offline](/forum/user/33634-charlesdh) - Proficient with Excel Less More - Posts: 36 - Thank you received: 5 - - - - 11 years 1 month ago [\#212950](#212950) by [charlesdh](/forum/user/33634-charlesdh "View charlesdh's Profile") *[Delete Product in test database](/forum/37-import-export-csv-xls/879033-delete-product-in-test-database#212950 "Hi, I have a test database that I wish to remove all products in HikaShop. (Even products that are hidden) I access HikaShop" through a "Joomla" test site in order to upload files to "HikaShop". Is there a easy solution for the deletion?")* was created by *[charlesdh](/forum/user/33634-charlesdh "View charlesdh's Profile")* Hi, I have a test database that I wish to remove all products in HikaShop. (Even products that are hidden) I access HikaShop" through a "Joomla" test site in order to upload files to "HikaShop". Is there a easy solution for the deletion? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NzkwMzMtZGVsZXRlLXByb2R1Y3QtaW4tdGVzdC1kYXRhYmFzZT90bXBsPW1hcmtkb3du) 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") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86287 - Thank you received: 14264 - - 11 years 1 month ago [\#212951](#212951) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Delete Product in test database](/forum/37-import-export-csv-xls/879033-delete-product-in-test-database#212951 "Hi, I have a test database that I wish to remove all products in HikaShop. (Even products that are hidden) I access HikaShop" through a "Joomla" test site in order to upload files to "HikaShop". Is there a easy solution for the deletion?")* Hi, There is no easy solution to delete all the products if you have more than a few hundred. You'll have to go in phpmyadmin and clear the hikashop_product, hikashop_product_category, hikashop_price, hikashop_file, hikashop_related, hikashop_variant tables. Otherwise, you can go on your products listing, display a 100 of products and set the "direct sub elements" dropdown to "all sub elements" and use the global checkbox of the listing to select the first 100 products and click on the delete button. Rince and repeat until none are left. The following user(s) said Thank You: [charlesdh](/forum/user/33634-charlesdh "View charlesdh's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NzkwMzMtZGVsZXRlLXByb2R1Y3QtaW4tdGVzdC1kYXRhYmFzZT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[charlesdh](/forum/user/33634-charlesdh "View charlesdh's Profile")** - [![charlesdh's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar33634.jpg)](/forum/user/33634-charlesdh "View charlesdh's Profile") Topic Author - [ Offline](/forum/user/33634-charlesdh) - Proficient with Excel Less More - Posts: 36 - Thank you received: 5 - - - - 11 years 1 month ago [\#213046](#213046) by [charlesdh](/forum/user/33634-charlesdh "View charlesdh's Profile") Replied by *[charlesdh](/forum/user/33634-charlesdh "View charlesdh's Profile")* on topic *[Delete Product in test database](/forum/37-import-export-csv-xls/879033-delete-product-in-test-database#213046 "Hi, I have a test database that I wish to remove all products in HikaShop. (Even products that are hidden) I access HikaShop" through a "Joomla" test site in order to upload files to "HikaShop". Is there a easy solution for the deletion?")* nicolas, Thanks for the info. I did this before. However, when I exported a supposedly empty product list the export showed data that was not displayed in the product list. Also, where is the phpmyadmin? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NzkwMzMtZGVsZXRlLXByb2R1Y3QtaW4tdGVzdC1kYXRhYmFzZT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Jerome](/forum/user/80-jerome "View Jerome's Profile")** - [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile") - [ Offline](/forum/user/80-jerome) - HikaShop core developer Less More - Posts: 26394 - Thank you received: 4078 - - [](http://obsi.dev) - 11 years 1 month ago [\#213048](#213048) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Delete Product in test database](/forum/37-import-export-csv-xls/879033-delete-product-in-test-database#213048 "Hi, I have a test database that I wish to remove all products in HikaShop. (Even products that are hidden) I access HikaShop" through a "Joomla" test site in order to upload files to "HikaShop". Is there a easy solution for the deletion?")* Hi, Before trying to use PHPMyAdmin (which is not related to HikaShop or Joomla) ; I think you can try with a "mass action". [ www.hikashop.com/support/support/documen...massaction-form.html](http://www.hikashop.com/support/support/documentation/167-massaction-form.html) Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. The following user(s) said Thank You: [charlesdh](/forum/user/33634-charlesdh "View charlesdh's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NzkwMzMtZGVsZXRlLXByb2R1Y3QtaW4tdGVzdC1kYXRhYmFzZT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[charlesdh](/forum/user/33634-charlesdh "View charlesdh's Profile")** - [![charlesdh's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar33634.jpg)](/forum/user/33634-charlesdh "View charlesdh's Profile") Topic Author - [ Offline](/forum/user/33634-charlesdh) - Proficient with Excel Less More - Posts: 36 - Thank you received: 5 - - - - 11 years 1 month ago [\#213185](#213185) by [charlesdh](/forum/user/33634-charlesdh "View charlesdh's Profile") Replied by *[charlesdh](/forum/user/33634-charlesdh "View charlesdh's Profile")* on topic *[Delete Product in test database](/forum/37-import-export-csv-xls/879033-delete-product-in-test-database#213185 "Hi, I have a test database that I wish to remove all products in HikaShop. (Even products that are hidden) I access HikaShop" through a "Joomla" test site in order to upload files to "HikaShop". Is there a easy solution for the deletion?")* HI, I looked at the "MassAction" and was able to get rid of all but what I show in the attachment. Column "AW" still shows data. I tried various approaches to getting rig of the data but was unsuccessful. *This attachment is hidden for guests. Please log in or register to see it.* Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NzkwMzMtZGVsZXRlLXByb2R1Y3QtaW4tdGVzdC1kYXRhYmFzZT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Xavier](/forum/user/4105-xavier "View Xavier's Profile")** - [![Xavier's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar4105.png)](/forum/user/4105-xavier "View Xavier's Profile") - [ Offline](/forum/user/4105-xavier) Less More - Posts: 13201 - Thank you received: 2322 - - - - [](http://www.kidiweb.fr) - 11 years 1 month ago [\#213196](#213196) by [Xavier](/forum/user/4105-xavier "View Xavier's Profile") Replied by *[Xavier](/forum/user/4105-xavier "View Xavier's Profile")* on topic *[Delete Product in test database](/forum/37-import-export-csv-xls/879033-delete-product-in-test-database#213196 "Hi, I have a test database that I wish to remove all products in HikaShop. (Even products that are hidden) I access HikaShop" through a "Joomla" test site in order to upload files to "HikaShop". Is there a easy solution for the deletion?")* Hi, This csv file contains only header, no data so it seems to be ok. There is no more data. The following user(s) said Thank You: [charlesdh](/forum/user/33634-charlesdh "View charlesdh's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NzkwMzMtZGVsZXRlLXByb2R1Y3QtaW4tdGVzdC1kYXRhYmFzZT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[charlesdh](/forum/user/33634-charlesdh "View charlesdh's Profile")** - [![charlesdh's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar33634.jpg)](/forum/user/33634-charlesdh "View charlesdh's Profile") Topic Author - [ Offline](/forum/user/33634-charlesdh) - Proficient with Excel Less More - Posts: 36 - Thank you received: 5 - - - - 11 years 1 month ago [\#213267](#213267) by [charlesdh](/forum/user/33634-charlesdh "View charlesdh's Profile") Replied by *[charlesdh](/forum/user/33634-charlesdh "View charlesdh's Profile")* on topic *[Delete Product in test database](/forum/37-import-export-csv-xls/879033-delete-product-in-test-database#213267 "Hi, I have a test database that I wish to remove all products in HikaShop. (Even products that are hidden) I access HikaShop" through a "Joomla" test site in order to upload files to "HikaShop". Is there a easy solution for the deletion?")* Hi, Thanks for the reply. I was concerned about column "AW" where it shows a "Header" of "categories" in row 1 and in row 2 it has "product category". But, as s you mentioned there is no data in the other columns. So I'm guessing the info in the column mentioned is a moot point. Thank you! Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NzkwMzMtZGVsZXRlLXByb2R1Y3QtaW4tdGVzdC1kYXRhYmFzZT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[charlesdh](/forum/user/33634-charlesdh "View charlesdh's Profile")** - [![charlesdh's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar33634.jpg)](/forum/user/33634-charlesdh "View charlesdh's Profile") Topic Author - [ Offline](/forum/user/33634-charlesdh) - Proficient with Excel Less More - Posts: 36 - Thank you received: 5 - - - - 11 years 1 month ago [\#213363](#213363) by [charlesdh](/forum/user/33634-charlesdh "View charlesdh's Profile") Replied by *[charlesdh](/forum/user/33634-charlesdh "View charlesdh's Profile")* on topic *[Delete Product in test database](/forum/37-import-export-csv-xls/879033-delete-product-in-test-database#213363 "Hi, I have a test database that I wish to remove all products in HikaShop. (Even products that are hidden) I access HikaShop" through a "Joomla" test site in order to upload files to "HikaShop". Is there a easy solution for the deletion?")* Hi, While still on this subject. When I upload my test file I can see the "Products". Now when I export the data the Excel sheet show a extra row. The 1st row shows in Column "AW" shows "Category" and "Product Category" in row 2. Then the rest of the rows show the correct data. Am I still missing something? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NzkwMzMtZGVsZXRlLXByb2R1Y3QtaW4tdGVzdC1kYXRhYmFzZT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Jerome](/forum/user/80-jerome "View Jerome's Profile")** - [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile") - [ Offline](/forum/user/80-jerome) - HikaShop core developer Less More - Posts: 26394 - Thank you received: 4078 - - [](http://obsi.dev) - 11 years 1 month ago [\#213364](#213364) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Delete Product in test database](/forum/37-import-export-csv-xls/879033-delete-product-in-test-database#213364 "Hi, I have a test database that I wish to remove all products in HikaShop. (Even products that are hidden) I access HikaShop" through a "Joomla" test site in order to upload files to "HikaShop". Is there a easy solution for the deletion?")* Hi, That data is related to the categories, to help HikaShop to reimport it afterwards. Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NzkwMzMtZGVsZXRlLXByb2R1Y3QtaW4tdGVzdC1kYXRhYmFzZT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[charlesdh](/forum/user/33634-charlesdh "View charlesdh's Profile")** - [![charlesdh's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar33634.jpg)](/forum/user/33634-charlesdh "View charlesdh's Profile") Topic Author - [ Offline](/forum/user/33634-charlesdh) - Proficient with Excel Less More - Posts: 36 - Thank you received: 5 - - - - 11 years 1 month ago [\#213414](#213414) by [charlesdh](/forum/user/33634-charlesdh "View charlesdh's Profile") Replied by *[charlesdh](/forum/user/33634-charlesdh "View charlesdh's Profile")* on topic *[Delete Product in test database](/forum/37-import-export-csv-xls/879033-delete-product-in-test-database#213414 "Hi, I have a test database that I wish to remove all products in HikaShop. (Even products that are hidden) I access HikaShop" through a "Joomla" test site in order to upload files to "HikaShop". Is there a easy solution for the deletion?")* Thanks, I think I now understand what happens. If you do not use "MassAction" for "Export" all "Headers" will show regardless if they have data. So for "Exporting" you need to do a "MassAction" and select the columns (Headers) you wish to populate. Some time ago when I first started it seemed to me that when I first uploaded a test file and then "Exported" the file to see what happens it only exported the "Same" headers and product that was first imported. Am I wrong in this part?. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NzkwMzMtZGVsZXRlLXByb2R1Y3QtaW4tdGVzdC1kYXRhYmFzZT90bXBsPW1hcmtkb3du) 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") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86287 - Thank you received: 14264 - - 11 years 1 month ago [\#213421](#213421) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Delete Product in test database](/forum/37-import-export-csv-xls/879033-delete-product-in-test-database#213421 "Hi, I have a test database that I wish to remove all products in HikaShop. (Even products that are hidden) I access HikaShop" through a "Joomla" test site in order to upload files to "HikaShop". Is there a easy solution for the deletion?")* You're wrong. The export has always exported all the columns, regardless of how the products were added. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NzkwMzMtZGVsZXRlLXByb2R1Y3QtaW4tdGVzdC1kYXRhYmFzZT90bXBsPW1hcmtkb3du) 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.338 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)