Missing products after update

  • Posts: 75
  • Thank you received: 1
10 years 6 months ago #174860

-- HikaShop version -- : 2.3.3
-- Joomla version -- : 2.5.27
-- PHP version -- : 5.3.24
-- Browser(s) name and version -- : Firefox 32.0.3 (Mac)
-- Error-message(debug-mod must be tuned on) -- : No error message shown

Hi,

After updating from Hikashop business 2.3.1 to 2.3.2 we noticed some product have disappeared from the front-end listings. Unfortunately we didn't notice immediately and cannot easily tell how many of the 1200+ products have gone missing but the client has noticed a few.

• Searching for these products in the back-end fails to shows the product. But if we look from MyphpAdmin I can see the product details (hikashop_product).
• If I try to re-create one of these 'hidden' products I get the message that that Product Code is in use.
• From a backup copy of the site before the update and have exported the Product list as a .CSV file and its has the same number of records as the export from the updated site.
• We have made manual updates to many of the products so its not practical to import the old .CSV

So is there a way to re-index the database to find these missing/hidden products?

Regards
Tim

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

  • Posts: 83671
  • Thank you received: 13545
  • MODERATOR
10 years 6 months ago #174880

Hi,

If you don't see the products but they are there, it means that they are not associated to any category or that they are associated to a category which doesn't exist or something like that.
There is no reason an update of HikaShop would generate such behavior.
Please look at the hikashop_product_category table in your database where you can find the association between products and categories. There, search for the id of a missing product and see if you find any association. If you do, please check the corresponding categories in the hikashop_category table.
Based on what you find we should be able to tell you what to do.

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

  • Posts: 14
  • Thank you received: 0
8 years 11 months ago #240796

Actually I have also noticed that products have gone missing after update. We don't have as many as Nicolas but all were visible before and now are missing. There is no reason as the products as set to display unlimited stock and are associated with categories. Our menu is displaying all categories but the products are missing.

Again this happened and was not noticed straight away.


David

Oxford web design and print at Holywell Press
www.holywellpress.co.uk
www.wickodesign.com

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

  • Posts: 83671
  • Thank you received: 13545
  • MODERATOR
8 years 11 months ago #240800

Hi,

So is there any common points with the different missing products ?
What is different between these products and other products ?
Please look at the hikashop_product_category table in your database where you can find the association between products and categories. There, search for the id of a missing product and see if you find any association. If you do, please check the corresponding categories in the hikashop_category table.

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

Time to create page: 0.064 seconds
Powered by Kunena Forum