cancel
Showing results for 
Search instead for 
Did you mean: 

Import/Export Products Issue & Errors

SOLVED

Import/Export Products Issue & Errors

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:

 

Export

 

 

 

 

 

 

Sample data: https://www.dropbox.com/s/eeuogz1ddsyjejx/export.csv?dl=0

 

 

Any help would be appreciated. Thanks

 

1 ACCEPTED SOLUTION

Accepted Solutions

Re: IMPORT/EXPORT PRODUCTS ISSUES & ERRORS

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.

-------Store Manager for Magento 1.x and 2.x - enhances the functionality of default admin web interface, speeds up inventory management, automates daily tasks.

View solution in original post

14 REPLIES 14

Re: IMPORT/EXPORT PRODUCTS ISSUES & ERRORS

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.

-------Store Manager for Magento 1.x and 2.x - enhances the functionality of default admin web interface, speeds up inventory management, automates daily tasks.

Re: IMPORT/EXPORT PRODUCTS ISSUES & ERRORS

Thank you! Worked flawlessly. I never would have figured that out on my own. 

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?

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:

https://www.mag-manager.com/useful-articles/tipstricks/required-csv-file-values-for-error-free-magen...

 

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

-------Store Manager for Magento 1.x and 2.x - enhances the functionality of default admin web interface, speeds up inventory management, automates daily tasks.

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.

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:

https://www.mag-manager.com/useful-articles/tipstricks/required-csv-file-values-for-error-free-magen...

-------Store Manager for Magento 1.x and 2.x - enhances the functionality of default admin web interface, speeds up inventory management, automates daily tasks.

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

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 -

https://www.mag-manager.com/useful-articles/case-studies/error-skip-import-row-required-field-not-de...

Store Manager for Magento 1.x and 2.x - inventory management tool to automatically update products, customers, orders, and other data across multiple sales channels and suppliers.

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.