Magento 1.9 Dataflow Import – Error ‘Skipping Import Row, Required Field “Website” Not Defined’

customerimportexportmagento-1.9

getting this error "Skipping import row, required field "website" is not defined" when importing customer list in dataflow import method

Best Answer

This problem can be due to many reasons:

Empty column value for few rows
If delimiter symbol is incorrect, your file data won’t be parsed properly and you might have broken file with all information in one column.
File header names should be the same as field names in database. This is required by Magento Admin, so in case you have ‘Product Title” column instead of ‘Name’ needed, you have to rename it, since it might not be recognized in the process of Magento import. Please, pay attention that some of database fields names have underscore and some don’t. For instance: _attribute_set VS sku.
Your import file should be saved with correct coding format in order for the data to be correctly recognized. UTF-8 Without BOM can be set in any spreadsheet program you are using to open files.

Update: Make sure the column names do not start with an underscore in your import file.

An example would be the type column – which should be “type” not “_type”.

Same for other column headers in the import file, make sure they do not start with an underscore

Please let me know if the problem still persists.

Related Solutions

Magento Products Not Showing Up After Import – Troubleshooting Guide

I'm not 100 sure but I think it has something to do with the status or visibility or the product.
In the products grid, when retrieving the collection there are 2 inner joins for selecting the status and visibility. (actually there is a third one, for the name but I doubt this is the problem).
If there are no values for visibility and status the product does not appear in the grid.
To test this, edit any product in the backend, then look in the table catalog_product_entity for a record that does not appear in the grid.
Change the id in the url with the one from the product that does not appear and you should be able to edit it. Set a visibility and status and save. If it appears after that int he grid then this is the problem for sure.

TO solve it, make all your products enabled and visible with this script. You can disable later the ones you don't need.

Crete a file called fix.php in the root of the magento instance with this code

<?php
error_reporting(E_ALL | E_STRICT);
define('MAGENTO_ROOT', getcwd());
$mageFilename = MAGENTO_ROOT . '/app/Mage.php';
require_once $mageFilename;
Mage::app();
$ids = Mage::getModel('catalog/product')->getCollection()->getAllIds();
Mage::getSingleton('catalog/product_action')->updateAttributes(
    $ids,
    array('status'=>1, 'visibility'=>4),
    0
);

Magento – Why is the csv file not importing successfully in the Dataflow Profile even when it was verified as valid in Check Data

Please check and make sure that you don't have extra carriage returns/line feeds on the end of your csv file. Open the file, and delete any blank lines/rows.

Often times, when you export from Excel, it will add extra rows to the export that are nothing more than blank lines.

Best Answer

Related Solutions

Magento Products Not Showing Up After Import – Troubleshooting Guide

Magento – Why is the csv file not importing successfully in the Dataflow Profile even when it was verified as valid in Check Data

Related Topic