You will not be able to continue because there are some required fields that cant be indexed in given CSV

Created on 7 January 2021, over 3 years ago
Updated 3 July 2023, 12 months ago

First of all thank you for building this module. Looks very promising!

I've downloaded my CSV template and filled it in with some data. When i upload it the module returns:

    Unindexed field Title, this is required field
    Unindexed field SKU, this is required field
    Unindexed field Kleur, this is required field
    Unindexed field Maat, this is required field
    Unindexed field Weight, this is required field
    Unindexed field Price, this is required field
    Unindexed field Currency, this is required field


You will not be able to continue because there are some required fields that cant be indexed in given CSV 

Although the fields are filled in.

This is my example CSV, as you can see, the fields like Title and SKU are filled in:

Title;URL alias;Korte omschrijving;Categorie;Levertijd;Uitgebreide omschrijving;Gerelateerd;Reviews;Tags;Youtube;Redirection;SKU;Price;Currency;List price;Kleur;Maat;Afbeelding(en);Belastingtarief;Voorraad;Weight
Dit is een test;;Dit is een test;Mannen;;Dit is een test;;;;;;test1;100;EUR;100;Wit;M;;;;1000
D;;;;;;;;;;;test2;200;EUR;200;Wit;M;;;;2000
Dit is nog een test;;Dit is een test;Mannen;;Dit is een test;;;;;;test3;300;EUR;300;Wit;XL;;;;3000

Anyone has an idea what i'm doing wrong?

Thank you very much!

💬 Support request
Status

Active

Version

1.0

Component

Miscellaneous

Created by

🇳🇱Netherlands mindhunter75

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Comments & Activities

Not all content is available!

It's likely this issue predates Contrib.social: some issue and comment data are missing.

  • 🇺🇸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)
        }
      }
    }
    
Production build 0.69.0 2024