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

Wrong number format - Integer becomes decimal on import
 
davidgrun
Sr. Member
 
Total Posts:  245
Joined:  2008-07-10
 

Hello.

I’m having problems with the number formating for the SKU and for my custom attribute ‘page_qty’ when I import throgh admin.
For example, In my Excel file I have SKU = 002 and when I import the file it shows 0.002 on the frontend.  Same with ‘page_qty’ (quantity of pages on a book item).

More details:
The attributes (SKU and page_qty) are set to INT.
I’m using MS Excel for Mac, 2008 on a Mac.
I export from the admin, open on Excel-Mac, make changes, save and import through admin.

Any help will be much appreciated!  Thanks.
David

 
Magento Community Magento Community
Magento Community
Magento Community
 
Sander
Sr. Member
 
Avatar
Total Posts:  232
Joined:  2008-01-08
Netherlands
 

Did you fix this already? Curious about the solution smile

Thanks,
Sander

 
Magento Community Magento Community
Magento Community
Magento Community
 
davidgrun
Sr. Member
 
Total Posts:  245
Joined:  2008-07-10
 

Hello. I solved it by changin program I use for my SCV file. Now I´m using OpenOfice Calc (Free program) and make sure to open it as utf-8.  If you have further questions let me know and I´ll try to put a step by step tutorial on how I import-export products successfully with DataFlow.
It took me a long time to figure it out excatly… Let me know.

 
Magento Community Magento Community
Magento Community
Magento Community
 
Sander
Sr. Member
 
Avatar
Total Posts:  232
Joined:  2008-01-08
Netherlands
 

Thanks a lot! I think I will manage, got Open Office installed too.

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