Magento Forum

Import with website_id
 
rrobinson
Jr. Member
 
Avatar
Total Posts:  15
Joined:  2008-05-19
Portland, Or
 

Not sure if this is really a bug or some design consideration so thought I would post here first.

I have managed to successfully circumvent the issue by running sql’s on the database but maybe I missed
something.

I imported a little over 9000 products, the import went well and the products showed up in the admin inteface with
proper attribute settings.

The products did not show up on the website. I traced this to the products not having an entry in the catalog_product_website
table. Of course I knew this before the 9000 products, I found the issue in a test run.

I did some test runs with the website_id field but the import process seems to ignore it.

After the final import I used a select/insert to get it working.

Did I miss something?

 
Magento Community Magento Community
Magento Community
Magento Community
 
bratzi
Jr. Member
 
Total Posts:  2
Joined:  2008-06-01
 

I`ve got the same Problem.

The products import via CSV-File runs very well and the products are shown in the admin panel as active, but they are not shown in the Frontend!

Do`s anyone have en idea??

If i wont to change the status to deactivatetd the skript runs 30 second`s and the stop`s it, becouse of the maximum execution Time - diffrent from the import it runs over 10 or 15 minutes without problems!!

 
Magento Community Magento Community
Magento Community
Magento Community
 
rrobinson
Jr. Member
 
Avatar
Total Posts:  15
Joined:  2008-05-19
Portland, Or
 

This is the sql I use on an initial import of products.

DELETE FROM catalog_product_website;

INSERT INTO catalog_product_websiteproduct_id )
    
SELECT entity_id FROM catalog_product_entity;

UPDATE catalog_product_website SET website_id=1;
 
Magento Community Magento Community
Magento Community
Magento Community
 
Dr.Malcom
Jr. Member
 
Total Posts:  3
Joined:  2010-08-19
 

Can somebody help with this problem ? Same happened for me and I can’t find the answer…

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top