[Skip to main content](#vessel-content) # Blank Products Uploaded ## - **[MyWorld](/forum/user/862-myworld "View MyWorld's Profile")** - [![MyWorld's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/862-myworld "View MyWorld's Profile") Topic Author - [ Offline](/forum/user/862-myworld) Less More - Posts: 966 - Thank you received: 11 - - 13 years 9 months ago [\#87204](#87204) by [MyWorld](/forum/user/862-myworld "View MyWorld's Profile") *[Blank Products Uploaded](/forum/4-how-to/77778-blank-products-uploaded#87204 "I'm not sure what happened to my CSV file but it was working fine and all of a sudden the number of products uploaded went from 99 to 8000. When I check the product categories they are all correct except for the main category (root > product category). That's where the rest of the items go uploaded to. The name field is empty, and the product code is like this product_204, product_205, product_206, etc... The price is $0.00. Can someone please explain what's happening. I can delete them but it will take forever as it says page 1 of 517. Thanks in advance!!")* was created by *[MyWorld](/forum/user/862-myworld "View MyWorld's Profile")* I'm not sure what happened to my CSV file but it was working fine and all of a sudden the number of products uploaded went from 99 to 8000. When I check the product categories they are all correct except for the main category (root > product category). That's where the rest of the items go uploaded to. The name field is empty, and the product code is like this product_204, product_205, product_206, etc... The price is $0.00. Can someone please explain what's happening. I can delete them but it will take forever as it says page 1 of 517. Thanks in advance!! Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzc3Nzc4LWJsYW5rLXByb2R1Y3RzLXVwbG9hZGVkP3RtcGw9bWFya2Rvd24=) 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: 14281 - - 13 years 9 months ago [\#87345](#87345) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Blank Products Uploaded](/forum/4-how-to/77778-blank-products-uploaded#87345 "I'm not sure what happened to my CSV file but it was working fine and all of a sudden the number of products uploaded went from 99 to 8000. When I check the product categories they are all correct except for the main category (root > product category). That's where the rest of the items go uploaded to. The name field is empty, and the product code is like this product_204, product_205, product_206, etc... The price is $0.00. Can someone please explain what's happening. I can delete them but it will take forever as it says page 1 of 517. Thanks in advance!!")* You can delete 500 products in 10 seconds. Simply change the number of items per pages to "all", check the main checkbox of the listing, and click on the delete button and all the 500 hundred products are deleted. Regarding the CSV import, it seems that there was indeed an issue with the categories in the CSV. If you got new products in the main category, it means that the system didn't find any category in the categories column for the products and thus assigned them to the main category of the shop. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzc3Nzc4LWJsYW5rLXByb2R1Y3RzLXVwbG9hZGVkP3RtcGw9bWFya2Rvd24=) or [Create an account](/register) to join the conversation. - **[MyWorld](/forum/user/862-myworld "View MyWorld's Profile")** - [![MyWorld's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/862-myworld "View MyWorld's Profile") Topic Author - [ Offline](/forum/user/862-myworld) Less More - Posts: 966 - Thank you received: 11 - - 13 years 9 months ago [\#87519](#87519) by [MyWorld](/forum/user/862-myworld "View MyWorld's Profile") Replied by *[MyWorld](/forum/user/862-myworld "View MyWorld's Profile")* on topic *[Blank Products Uploaded](/forum/4-how-to/77778-blank-products-uploaded#87519 "I'm not sure what happened to my CSV file but it was working fine and all of a sudden the number of products uploaded went from 99 to 8000. When I check the product categories they are all correct except for the main category (root > product category). That's where the rest of the items go uploaded to. The name field is empty, and the product code is like this product_204, product_205, product_206, etc... The price is $0.00. Can someone please explain what's happening. I can delete them but it will take forever as it says page 1 of 517. Thanks in advance!!")* Hi Nicolas, It's page 1 of 516 - each page has 200 items. For some reason when I select "All" from the display it doesn't show all the items it only show 500. I tried it before I post that's why I made the post. I thought if I select "All" it would show All the items - then I could just click delete and am done. Regarding your last comment, I think those rows must have been added in error 'cause I definitely do not have that much products. Thanks!! Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzc3Nzc4LWJsYW5rLXByb2R1Y3RzLXVwbG9hZGVkP3RtcGw9bWFya2Rvd24=) or [Create an account](/register) to join the conversation. - **[MyWorld](/forum/user/862-myworld "View MyWorld's Profile")** - [![MyWorld's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/862-myworld "View MyWorld's Profile") Topic Author - [ Offline](/forum/user/862-myworld) Less More - Posts: 966 - Thank you received: 11 - - 13 years 8 months ago [\#91485](#91485) by [MyWorld](/forum/user/862-myworld "View MyWorld's Profile") Replied by *[MyWorld](/forum/user/862-myworld "View MyWorld's Profile")* on topic *[Blank Products Uploaded](/forum/4-how-to/77778-blank-products-uploaded#91485 "I'm not sure what happened to my CSV file but it was working fine and all of a sudden the number of products uploaded went from 99 to 8000. When I check the product categories they are all correct except for the main category (root > product category). That's where the rest of the items go uploaded to. The name field is empty, and the product code is like this product_204, product_205, product_206, etc... The price is $0.00. Can someone please explain what's happening. I can delete them but it will take forever as it says page 1 of 517. Thanks in advance!!")* Can you pleeeese help me with this? It's messing up my previously viewed module - It's showing the blank products. I need to remove them and it's going to take forever if I do each page. There are 65 pages - see attached please. Thanks!! - [ ![blank-products.jpg](/forum/attachment/8728) ](/forum/attachment/8728 "...k-products.jpg") [ ](/forum/attachment/8728?download=1 "...k-products.jpg") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzc3Nzc4LWJsYW5rLXByb2R1Y3RzLXVwbG9hZGVkP3RtcGw9bWFya2Rvd24=) 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: 14281 - - 13 years 8 months ago [\#91709](#91709) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Blank Products Uploaded](/forum/4-how-to/77778-blank-products-uploaded#91709 "I'm not sure what happened to my CSV file but it was working fine and all of a sudden the number of products uploaded went from 99 to 8000. When I check the product categories they are all correct except for the main category (root > product category). That's where the rest of the items go uploaded to. The name field is empty, and the product code is like this product_204, product_205, product_206, etc... The price is $0.00. Can someone please explain what's happening. I can delete them but it will take forever as it says page 1 of 517. Thanks in advance!!")* Of course it doesn't display all the products when you select 'all'. If we allowed that, your website would just display a blank page as there would be too much data to display. There is nothing we can do to avoid that. It takes less than 10 seconds to select all the products of a page (with the global checkbox at the top) and click on delete and validate. That's less than 15 minutes to delete all the products of the 65 pages. I don't see the problem here ? If you want to delete all the products in one operation, you can probably do it by running a query via your phpmyadmin: DELETE FROM jos_hikashop_product WHERE product_id IN (SELECT product_id FROM jos_hikashop_product_category WHERE category_id = XXX); Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzc3Nzc4LWJsYW5rLXByb2R1Y3RzLXVwbG9hZGVkP3RtcGw9bWFya2Rvd24=) 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.076 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)