Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

Magento Forum

Watch the formulae in MS Excel when importing your .csv
 
magentomatt
Member
 
Total Posts:  37
Joined:  2008-08-08
 

I’ve been reading through these posts on how to import my images (about 1000) because I’ve been having issues.

The Reason:  When I created my .csv, I had to use a concatenation to populate all of the image fields.  When I was importing, Magento was reading the concatenation value and not the name of the file value [(=CONCATENATION("/”,+SKU,".jpg") instead of /xxx.jpg.].

So, does anyone know how to clear the contents of a field in excel to remove the formulae while leaving the contents?

I don’t.

 
Magento Community Magento Community
Magento Community
Magento Community
 
magentomatt
Member
 
Total Posts:  37
Joined:  2008-08-08
 

duh, “paste special”

sometimes you have to have a conversation with yourself.

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