πΊπΈUnited States allisonc New York
allisonc β created an issue.
π¬ | Commerce Smart Importer | You will not be able to continue because there are some required fields that cant be indexed in given CSV
πΊπΈUnited States allisonc New York
It seems like the line generated from the example is required.
Your product data starts in next row,,,,,,,,,,,,,,,
Without this, the import was giving me the error even though my CSV was comma separated. I was only getting the error regarding the Title field.
var_dump of $headers
array(16) {
[0]=>
string(8) "ο»ΏTitle"
[1]=>
string(4) "Body"
[2]=>
string(17) "Default variation"
[3]=>
string(9) "URL alias"
[4]=>
string(22) "Feeds item(feeds_item)"
[5]=>
string(13) "Product Terms"
[6]=>
string(11) "Redirection"
[7]=>
string(3) "SKU"
[8]=>
string(5) "Image"
[9]=>
string(5) "Price"
[10]=>
string(8) "Currency"
[11]=>
string(10) "List price"
[12]=>
string(10) "Dimensions"
[13]=>
string(22) "Feeds item(feeds_item)"
[14]=>
string(11) "Hidden Data"
[15]=>
string(6) "Weight"
}
var_dump of $fields
array(2) {
["product"]=>
array(7) {
[0]=>
array(6) {
["label"]=>
string(5) "Title"
["machine_names"]=>
string(5) "title"
["field_types"]=>
string(6) "string"
["field_settings"]=>
array(5) {
["max_length"]=>
int(255)
["is_ascii"]=>
bool(false)
["case_sensitive"]=>
bool(false)
["default_value"]=>
string(0) ""
["read-only"]=>
bool(false)
}
["cardinality"]=>
int(1)
["required"]=>
bool(true)
}
[1]=>
array(6) {
["label"]=>
string(17) "Default variation"
["machine_names"]=>
string(17) "default_variation"
["field_types"]=>
string(16) "entity_reference"
["field_settings"]=>
array(5) {
["target_type"]=>
string(26) "commerce_product_variation"
["handler"]=>
string(7) "default"
["handler_settings"]=>
array(1) {
["target_bundles"]=>
array(1) {
["artwork"]=>
string(7) "artwork"
}
}
["default_value"]=>
bool(false)
["read-only"]=>
bool(false)
}
["cardinality"]=>
int(1)
["required"]=>
bool(false)
}
[2]=>
array(6) {
["label"]=>
string(9) "URL alias"
["machine_names"]=>
string(4) "path"
["field_types"]=>
string(4) "path"
["field_settings"]=>
array(2) {
["default_value"]=>
bool(false)
["read-only"]=>
bool(false)
}
["cardinality"]=>
int(1)
["required"]=>
bool(false)
}
[3]=>
array(6) {
["label"]=>
string(4) "Body"
["machine_names"]=>
string(4) "body"
["field_types"]=>
string(17) "text_with_summary"
["field_settings"]=>
array(4) {
["display_summary"]=>
bool(false)
["required_summary"]=>
bool(false)
["default_value"]=>
bool(false)
["read-only"]=>
bool(false)
}
["required"]=>
bool(false)
["cardinality"]=>
int(1)
}
[4]=>
array(6) {
["label"]=>
string(22) "Feeds item(feeds_item)"
["machine_names"]=>
string(10) "feeds_item"
["field_types"]=>
string(10) "feeds_item"
["field_settings"]=>
array(5) {
["handler"]=>
string(18) "default:feeds_feed"
["handler_settings"]=>
array(0) {
}
["target_type"]=>
string(10) "feeds_feed"
["default_value"]=>
bool(false)
["read-only"]=>
bool(false)
}
["required"]=>
bool(false)
["cardinality"]=>
int(-1)
}
[5]=>
array(6) {
["label"]=>
string(13) "Product Terms"
["machine_names"]=>
string(19) "field_product_terms"
["field_types"]=>
string(16) "entity_reference"
["field_settings"]=>
array(5) {
["handler"]=>
string(21) "default:taxonomy_term"
["handler_settings"]=>
array(4) {
["target_bundles"]=>
array(1) {
["painting"]=>
string(8) "painting"
}
["sort"]=>
array(2) {
["field"]=>
string(4) "name"
["direction"]=>
string(3) "asc"
}
["auto_create"]=>
bool(false)
["auto_create_bundle"]=>
string(0) ""
}
["target_type"]=>
string(13) "taxonomy_term"
["default_value"]=>
bool(false)
["read-only"]=>
bool(false)
}
["required"]=>
bool(false)
["cardinality"]=>
int(-1)
}
[6]=>
array(6) {
["label"]=>
string(11) "Redirection"
["machine_names"]=>
string(11) "redirection"
["field_types"]=>
string(11) "redirection"
["required"]=>
bool(false)
["cardinality"]=>
int(-1)
["field_settings"]=>
array(1) {
["read-only"]=>
bool(false)
}
}
}
["variation"]=>
array(9) {
[0]=>
array(6) {
["label"]=>
string(3) "SKU"
["machine_names"]=>
string(3) "sku"
["field_types"]=>
string(6) "string"
["field_settings"]=>
array(6) {
["max_length"]=>
int(255)
["is_ascii"]=>
bool(false)
["case_sensitive"]=>
bool(false)
["display_description"]=>
bool(true)
["default_value"]=>
string(11) "generateSKU"
["read-only"]=>
bool(true)
}
["cardinality"]=>
int(1)
["required"]=>
bool(true)
}
[1]=>
array(6) {
["label"]=>
string(10) "List price"
["machine_names"]=>
string(10) "list_price"
["field_types"]=>
string(14) "commerce_price"
["field_settings"]=>
array(4) {
["available_currencies"]=>
array(0) {
}
["allow_negative"]=>
bool(false)
["default_value"]=>
bool(false)
["read-only"]=>
bool(false)
}
["cardinality"]=>
int(1)
["required"]=>
bool(false)
}
[2]=>
array(6) {
["label"]=>
string(10) "Dimensions"
["machine_names"]=>
string(10) "dimensions"
["field_types"]=>
string(19) "physical_dimensions"
["field_settings"]=>
array(2) {
["default_value"]=>
bool(false)
["read-only"]=>
bool(false)
}
["required"]=>
bool(true)
["cardinality"]=>
int(1)
}
[3]=>
array(6) {
["label"]=>
string(22) "Feeds item(feeds_item)"
["machine_names"]=>
string(10) "feeds_item"
["field_types"]=>
string(10) "feeds_item"
["field_settings"]=>
array(5) {
["handler"]=>
string(18) "default:feeds_feed"
["handler_settings"]=>
array(0) {
}
["target_type"]=>
string(10) "feeds_feed"
["default_value"]=>
bool(false)
["read-only"]=>
bool(false)
}
["required"]=>
bool(false)
["cardinality"]=>
int(-1)
}
[4]=>
array(6) {
["label"]=>
string(11) "Hidden Data"
["machine_names"]=>
string(17) "field_hidden_data"
["field_types"]=>
string(11) "string_long"
["field_settings"]=>
array(3) {
["case_sensitive"]=>
bool(false)
["default_value"]=>
bool(false)
["read-only"]=>
bool(false)
}
["required"]=>
bool(false)
["cardinality"]=>
int(1)
}
[5]=>
array(6) {
["label"]=>
string(5) "Image"
["machine_names"]=>
string(11) "field_image"
["field_types"]=>
string(5) "image"
["field_settings"]=>
array(18) {
["handler"]=>
string(12) "default:file"
["handler_settings"]=>
array(0) {
}
["file_directory"]=>
string(16) "commerce/artwork"
["file_extensions"]=>
string(16) "png gif jpg jpeg"
["max_filesize"]=>
string(0) ""
["max_resolution"]=>
string(0) ""
["min_resolution"]=>
string(0) ""
["alt_field"]=>
bool(true)
["alt_field_required"]=>
bool(false)
["title_field"]=>
bool(true)
["title_field_required"]=>
bool(false)
["default_image"]=>
array(5) {
["uuid"]=>
string(0) ""
["alt"]=>
string(0) ""
["title"]=>
string(0) ""
["width"]=>
NULL
["height"]=>
NULL
}
["target_type"]=>
string(4) "file"
["display_field"]=>
bool(false)
["display_default"]=>
bool(false)
["uri_scheme"]=>
string(6) "public"
["default_value"]=>
bool(false)
["read-only"]=>
bool(false)
}
["required"]=>
bool(false)
["cardinality"]=>
int(-1)
}
[6]=>
array(6) {
["label"]=>
string(6) "Weight"
["machine_names"]=>
string(6) "weight"
["field_types"]=>
string(20) "physical_measurement"
["field_settings"]=>
array(3) {
["measurement_type"]=>
string(6) "weight"
["default_value"]=>
bool(false)
["read-only"]=>
bool(false)
}
["required"]=>
bool(true)
["cardinality"]=>
int(1)
}
[7]=>
array(6) {
["label"]=>
string(5) "Price"
["machine_names"]=>
string(5) "price"
["field_types"]=>
string(14) "commerce_price"
["field_settings"]=>
array(4) {
["available_currencies"]=>
array(0) {
}
["allow_negative"]=>
bool(false)
["default_value"]=>
bool(false)
["read-only"]=>
bool(false)
}
["cardinality"]=>
int(1)
["required"]=>
bool(true)
}
[8]=>
array(5) {
["label"]=>
string(8) "Currency"
["machine_names"]=>
string(8) "currency"
["field_types"]=>
string(8) "currency"
["required"]=>
bool(true)
["cardinality"]=>
int(1)
}
}
}
πΊπΈUnited States allisonc New York
/src/Form/SmartImporterConfigurationForm.php:92
Code should be changed to:
$sql = $this->database->select('commerce_store_field_data', 'cs')->fields('cs', ['store_id', 'name'])->execute()->fetchAll();
πΊπΈUnited States allisonc New York
πΊπΈUnited States allisonc New York
allisonc β created an issue.
πΊπΈUnited States allisonc New York
I fixed this issue based on #7
-
DELETE FROM key_value WHERE name like '%commerce_product%'
- Run https://site.com/rebuild.php