views:

402

answers:

2

Edit: This was a bogus question. The problem was that I had quotes in my description field. The entire field should be wrapped in one set of quotes with none inside. Changed quotes to apostrophes to fix. Magento is working correctly.

I am using a Profile in the Import/Export section of my Magento admin to import a CSV document.

My description fields are very long (around 10k file size). Two issues are occurring:

  1. On the published product, only the first 50% or so of the description is present.

  2. The Magento system does not import the next column on the import document (brief description).

Does anybody know how to fix this?

+1  A: 

The proplem is much more likley the application you export your product data with and which creates the CSV.

Did you check if the CSV contains the full description prior to importing it? Maybe the application only allows a certain amount of characters in a column and truncates the rest.

jitter
Good theory, but... I made the application that creates the csv. Yes, it does contain the full description.
Sorry jitter, you were right! I had quotes in my description, which was breaking the import.
+1  A: 

I believe I read there is a bug (not necessarily confirmed) in the CVS import if your 'short_description' is more than a sentence or two long, it causes problems elsewhere. You've got long, long descriptions, but you didn't mention how short, your short descriptions are. Could you try importing with a one sentence 'short_description', then see what happens.

I'm not sure the protocol of recommending a commercial product here, but there's a windows program (I run it in vmware) that does imports/exports with a direct connection to the magento database, skipping the long-winded dataflow api). I've imported products from there in much faster time frames without issue. I've never had to deal with long descriptions, though. It's not cheap at $200, but the time saved has been worth for it for me. It's the first result for 'magento manager' in google.

Have you confirmed by creating by hand a single product with a huge description that magento doesn't choke on it?

4.669201
Thanks for the info. I have tried importing one-sentence "short descriptions"... will try again. Yes, I have confirmed that adding a single product description directly through the Magento admin (not importing) works just fine.
You can try rolling your own import: http://activecodeline.com/programatically-manually-creating-simple-magento-product/comment-page-1I'd break the import into 100 or so products at a time, maybe even as low as 10 at a time. You could also try just updating the descriptions via by SKU using MySQL after the CSV import w/o them. You also don't say how many products you have or your deadline. You could always use mechanical turk (https://www.mturk.com) and pay a few cents per manually import if your time is short.
4.669201
I was thinking the same (updating the description by SKU using MySQL...). Of course, I would like to avoid that, but it seems like a good solution. I have around 300 products.
The error was that I had quotes inside my description field.