Magento - Import with website_id - Magento DataFlow - eCommerce Software for Growth

Log In

Username or Email

Password:

Forgot Password

or
Register

Skip to site navigation »
Skip to main content »
Skip to footer content »

Magento Forum

Import with website_id

rrobinson Total Posts: 15 Joined: 2008-05-19 Portland, Or Ignore user	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?
	Posted: May 29 2008 \| top

bratzi Total Posts: 2 Joined: 2008-06-01 Ignore user	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!! Signature -------------------------------------------------------------------------------------- Informations about my company: http://www.mbitmedia.de
	Posted: June 3 2008 \| top \| # 1

rrobinson Total Posts: 15 Joined: 2008-05-19 Portland, Or Ignore user	This is the sql I use on an initial import of products. `DELETE FROM catalog_product_website; INSERT INTO catalog_product_website( product_id ) SELECT entity_id FROM catalog_product_entity; UPDATE catalog_product_website SET website_id=1;`
	Posted: June 3 2008 \| top \| # 2

Dr.Malcom Total Posts: 3 Joined: 2010-08-19 Ignore user	Can somebody help with this problem ? Same happened for me and I can’t find the answer…
	Posted: January 4 2011 \| top \| # 3

Magento Community

Magento Community

Back to top

Where does it export? Please help

I need Help With DataFlow to Import Products from 3rd Party