Page 1 of 1

Adding Product Directly to DB not showing on front view

Posted: Tue Jan 14, 2014 5:24 am
by aqibboy2
Hi,As tittle Mention.i have added 10k+ products direct to database manually.i have done this thing by download CSV of following

-Product
-Product_Description
-Product_to_category
-Product_to_Store

After download the CSV i edit the CSV file with 10K products.it took me 12 hours to do this but unfortunately its not showing on website.When i check with DB its showing every thing but is not comming up on front view or even in admin panel.

I have done research on this and people saying there might be problem with product cache...i try lot of thing but nothing really seems to be work.please help me how i can show all my products on front view.

Re: Adding Product Directly to DB not showing on front view

Posted: Tue Jan 14, 2014 6:05 am
by butte
Version?

Did you set the fields (columns, row by row) for enable (1) and for sort_order (0, 1, ...) corresponding to what you see in admin as Enable and Sort Order?

Re: Adding Product Directly to DB not showing on front view

Posted: Tue Jan 14, 2014 11:14 pm
by aqibboy2
Thank you very much for your response but i figure it out by my self.

i did not change language id from 0 to 1.
i did not change status from 0 to 1

after changing status and language id all 11k products showing on my front and admin panel.

Re: Adding Product Directly to DB not showing on front view

Posted: Wed Jan 15, 2014 1:40 am
by butte
Good! Which language or language pack? Some of them are problematical, so bringing it to light will probably help others in several contexts other than product exports/imports. That's a wrinkle that shows in this case why specifiying version, theme, and extensions, together, at the outset can be helpful.