Blank Products Uploaded

  • Posts: 966
  • Thank you received: 11
  • Hikashop Business
11 years 11 months ago #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!!

Please Log in or Create an account to join the conversation.

  • Posts: 83050
  • Thank you received: 13412
  • MODERATOR
11 years 11 months ago #87345

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 or Create an account to join the conversation.

  • Posts: 966
  • Thank you received: 11
  • Hikashop Business
11 years 11 months ago #87519

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 or Create an account to join the conversation.

  • Posts: 966
  • Thank you received: 11
  • Hikashop Business
11 years 10 months ago #91485

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!!

Attachments:

Please Log in or Create an account to join the conversation.

  • Posts: 83050
  • Thank you received: 13412
  • MODERATOR
11 years 10 months ago #91709

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 or Create an account to join the conversation.

Time to create page: 0.044 seconds
Powered by Kunena Forum