Magento

Hi,

I have successfully added 171 Simple Product.

I see them all enabled. I created a Configurable product, I can select each option, add the value for each, but on the Frontend I have only “Choose an option...” but there is nothing in it…

I tried to open and save the Simple Product and it works… i can now see the option on the frontpage…

is there an option or something that I have to import to let me import products without open and save each product ?

thanks,

Jean-Luc B.

here is my first 2 lines in my import csv:

Am facing the same issue and am discussing this in
http://www.magentocommerce.com/boards/viewthread/4828/

Still looking for answers!

Me too Same problem is also discussed here:

http://www.magentocommerce.com/boards/viewthread/4828/

I tried this a couple times and had no problem with having to save the products, in fact they showed on the front end, BUT the images did not appear and had to open each product and reupload the images, to the same location, overwriting where they already were but not showing, then they showed.

@Andyellis

Thats the EXACT same problem I had. Imported ok via XML sheet, but the products were missing images. I’m having to open up each product and re-save it with the image. A long process when you’ve got 150+ items.

there should be someway to streamline this, I wonder whats keeping the image paths from being inserted into the database during import. The other attributes seem to import ok. Odd. I guess i’ll take a look at the product table maybe that’ll turn up some results… needle in haystack though.

NickL - 25 March 2008 07:58 AM

@Andyellis

Thats the EXACT same problem I had. Imported ok via XML sheet, but the products were missing images. I’m having to open up each product and re-save it with the image. A long process when you’ve got 150+ items.

there should be someway to streamline this, I wonder whats keeping the image paths from being inserted into the database during import. The other attributes seem to import ok. Odd. I guess i’ll take a look at the product table maybe that’ll turn up some results… needle in haystack though.

Yes I think its a most peculiar problem. I hope you come up with some answer. I am not mysql savvy, so can’t be much help.  Do you know anyting about my other post about subcats etc? How does that work, have you tried that?
Link here
in case that link doesn’t work its
http://www.magentocommerce.com/boards/viewthread/4857/

this solve my problem !

in file Mage/Catalog/Model/Convert/Adapter/Product.php change in line 266 before: $product->save(); insert

if (isset($row[’row’][’store’])) {
$storeId = Mage::app()->getStore($row[’row’][’store’])->getId();
} else {
$storeId = Mage::registry(’current_convert_profile’)->getStoreId();
}
if ($storeId) {
$product->setWebsiteIds(array($storeId));
}

PS: You have to delete and re-import all the product, otherwise you have to do those by hand !

It works !

@jeanlucb

I havne’t tried this method yet, I will in a few, but does this allow images to be inserted into the imported spreadsheets?

NickL,

No. This is the fix to save the product in the right Store…

Anyway, I don’t need any pictures for the products I am importing since I create manually a configurable product for each csv…

I know there is a bug with the Dataflow and pictures, but i’m sure they’ll fix it in the next release later this week.

cya,

Jean-Luc B.