So I have over 5K active products. Last evening I have installed to test product variations addon, created one product.
This morning I am opening store, no new orders and guess what I see only 200 in stock products.. O how I was shocked!
I checked logs nothing there. I then disabled variations and those missing products have re appeared in my store, I mean wtf? How many 404 has google had last night from my site?
Whats interesting that if I know product sku I find this hidden products, only diference from those non hidden products are that they have no convert drop down menu.
These products that are not seen in store (whole lot of them) are just simple products without any options or similar. Not sure why they get hidden as soon as I enable variations addon
Any thoughts?
Only difference in products db table I see is some are
`product_type` - 'P' and some ''
default supposed to be
`product_type` char(1) NOT NULL DEFAULT 'P',
maybe this is the reason ?
how to apply 'P' to all '' ?
Only difference in products db table I see is some are
`product_type` - 'P' and some ''default supposed to be
`product_type` char(1) NOT NULL DEFAULT 'P',maybe this is the reason ?
how to apply 'P' to all '' ?
Assuming you talk about the products table do the following:
UPDATE cscart_products SET `product_type` = 'P' WHERE product_type = '';
Do mind that we are always opened for these kinds of issues. Next time dont hesistate to contact us directly.
Success! That was the problem ;) thank you!
Success! That was the problem ;) thank you!
No problem!