- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello,
Forgive me, as I am only a user and not developer. I am trying to export a sample of products to edit data quickly, rather than through the admin. After I export the products, I cannot re-import them without getting errors. Even if I do not manipulate or change the data I still get errors trying to import the same file as the export. Here are some pictures of the settings:
Sample data: https://www.dropbox.com/s/eeuogz1ddsyjejx/export.csv?dl=0
Any help would be appreciated. Thanks
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi. I edited your file so it can be imported. Magento Export tool exports some values in "human readable" format, though Import tool seems not to recognize that. Import needs integer values. So you have to manually replace those "human readable" values onto integers to import file.
https://www.dropbox.com/s/t09es2h5gi0d63c/export_modified.csv?dl=0
1. page_layout
Just remove this column
2. status
Use 1 for Enabled and 2 for Disabled
3. visibility
4 for Catalog & Search, 3 for Search, 2 for Catalog and 1 for Not Visible Individually
4. enable_googlecheckout
1 for Yes and 0 for No
5. tax_class_id
2 for Taxable Goods (may be different. As I can see - you have Taxable Goods in your file, so 2 is match for you)
6. _attribute_set
For dataflow, this column name should not contain underbar. But for just "Import" - column name should start with underbar _
7. _type
Same, for dataflow this column name should not contain underbar. Just "Import" - column name should start with underbar _
8. short_description
If you want to import new products - then you should supply short descriptions
9. weight
Must be a value. Put zeros if product doesn't have any weight
Post whether import worked or not worked for you.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi. I edited your file so it can be imported. Magento Export tool exports some values in "human readable" format, though Import tool seems not to recognize that. Import needs integer values. So you have to manually replace those "human readable" values onto integers to import file.
https://www.dropbox.com/s/t09es2h5gi0d63c/export_modified.csv?dl=0
1. page_layout
Just remove this column
2. status
Use 1 for Enabled and 2 for Disabled
3. visibility
4 for Catalog & Search, 3 for Search, 2 for Catalog and 1 for Not Visible Individually
4. enable_googlecheckout
1 for Yes and 0 for No
5. tax_class_id
2 for Taxable Goods (may be different. As I can see - you have Taxable Goods in your file, so 2 is match for you)
6. _attribute_set
For dataflow, this column name should not contain underbar. But for just "Import" - column name should start with underbar _
7. _type
Same, for dataflow this column name should not contain underbar. Just "Import" - column name should start with underbar _
8. short_description
If you want to import new products - then you should supply short descriptions
9. weight
Must be a value. Put zeros if product doesn't have any weight
Post whether import worked or not worked for you.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Re: IMPORT/EXPORT PRODUCTS ISSUES & ERRORS
Thank you! Worked flawlessly. I never would have figured that out on my own.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Re: IMPORT/EXPORT PRODUCTS ISSUES & ERRORS
Hi @eMagicOne
Can I remove any fields from the file that I do not want to update (like the page_layout), or do they all need to be included?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Re: IMPORT/EXPORT PRODUCTS ISSUES & ERRORS
In case you want to create new products - then you need to supply a lot of fields. You can read more here:
However, if you just need to update price and quantity (etc.) for already existing products - then you may supply only SKU and those columns - price, quantity, etc. Here's a file as example:
https://www.dropbox.com/s/fjelfjrg46x56d8/export_update.csv?dl=0
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Re: IMPORT/EXPORT PRODUCTS ISSUES & ERRORS
I'm not exaggerating, I've been racking my brain all day over this Dataflow Import, and just found your post. Pretty sneaky for the export CSV to have data that won't work on the import. Nevertheless, I've done as you suggested, but the _type field is returning an error "Skip import row, is not valid value "" for field "type".
I've got a 1.7.0.2 so I don't know if that matters. Any insight you might have would be extremely apprecaited.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Re: IMPORT/EXPORT PRODUCTS ISSUES & ERRORS
It seems that you have empty value in _type column and you trying to import new products. For new products you must supply product type.
If you are trying to import simple products (real items, without parent-child relations) - just put "simple" for each product in "_type" column.
You may look at a sample file here:
https://www.dropbox.com/s/t09es2h5gi0d63c/export_modified.csv?dl=0
If you want different product type - put: configurable, virtual, downloadable, grouped or bundle. More details on how to import products here:
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Re: IMPORT/EXPORT PRODUCTS ISSUES & ERRORS
Hello
Can you guys help me with product import?
I am getting " Can not find required columns: sku " error message all the time.
I have tried lot of different configurations of csv file but getting same message.
My Magento ver. 1.9.0.1.
Please help if you can
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Re: IMPORT/EXPORT PRODUCTS ISSUES & ERRORS
Type of encoding UTF-8 w/o bom should help.
If not, here is also case study on what to check -
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Re: Import/Export Products Issue & Errors
Hello,
I am trying to import this file, but for some reason it is getting the below error code when trying to upload. All the fields are identical to the other 2 products that worked, but for some reason the new item I created won't add. Any help would greatly be appreciated. Thanks!
Starting profile execution, please wait...
Warning: Please do not close the window during importing/exporting data
Starting Mage_Dataflow_Model_Convert_Parser_Csv :: parse
Found 8 rows.
Starting catalog/convert_adapter_product :: parse
Image does not exist.
Image does not exist.
Skip import row, is not valid value "" for field "type"
Skip import row, is not valid value "" for field "type"
Image does not exist.
Image does not exist.
Processed 100% 8/8 records
Imported 2 records
Please wait while the indexes are being refreshed.
Finished profile execution.