Skip to content

Unit model import / update specifications

Names of fields listed here are the exact case and spelling required to be recognized by AyaNova for importing / updating.

Any field in the import file that is not listed on this page will be removed before sending to the server for import.

Required fields

  • Name

Key field used to match to existing records

  • Name

Fields directly importable / updateable

  • Name (import only)
  • Active
  • Notes
  • Wiki
  • Tags
  • UPC
  • LifeTimeWarranty
  • IntroducedDate
  • Discontinued
  • DiscontinuedDate
  • WarrantyLength
  • WarrantyTerms"

Linked object fields

The following linked objects are supported for import / update:

  • Unit model Vendor via "VendorViz" field which must contain the name of an existing Vendor

JSON file format

The .json file must contain an array of one or more objects.

[
    {
        "Name": "Silverado Kids - 394697",
        "Active": true,
        "Notes": "Quia neque dolorem quis cum sit dolores omnis dolores ex.",
        "Wiki": null,
        "Tags": [
            "quince",
            "silver",
            "violet",
            "yellow",
            "zone9"
        ],
        "VendorViz": "Ruecker - Jakubowski",
        "UPC": "2626181040130",
        "LifeTimeWarranty": false,
        "IntroducedDate": "2017-10-26T17:06:35.479433Z",
        "Discontinued": false,
        "DiscontinuedDate": null,
        "WarrantyLength": 36,
        "WarrantyTerms": "Service only"
    },
    {
        "Name": "Sentra Electronics - 598797",
        "Active": true,
        "Notes": "Incidunt officiis minus vero distinctio quasi.",
        "Wiki": null,
        "Tags": [
            "brown",
            "mauve",
            "white",
            "zone2",
            "zone7"
        ],
        "VendorViz": "Senger, Schinner and Zieme",
        "UPC": "3036454614095",
        "LifeTimeWarranty": false,
        "IntroducedDate": "2018-12-28T21:40:59.003417Z",
        "Discontinued": false,
        "DiscontinuedDate": null,
        "WarrantyLength": 24,
        "WarrantyTerms": "Service only"
    },
    {
        "Name": "Ranchero Garden - 625229",
        "Active": true,
        "Notes": "Ipsum ea nam exercitationem ea perspiciatis.",
        "Wiki": null,
        "Tags": [
            "brown",
            "gold",
            "mauve",
            "purple",
            "zone8"
        ],
        "VendorViz": "Pfeffer - Dicki",
        "UPC": "0805820409756",
        "LifeTimeWarranty": false,
        "IntroducedDate": "2018-06-01T17:29:48.427245Z",
        "Discontinued": false,
        "DiscontinuedDate": null,
        "WarrantyLength": 1,
        "WarrantyTerms": "Parts only"
    }
]

CSV file format

The first row of the .csv file must contain column headers that match the field names listed above.

Name,Active,Notes,Wiki,Tags,VendorViz,UPC,LifeTimeWarranty,IntroducedDate,Discontinued,DiscontinuedDate,WarrantyLength,WarrantyTerms
Silverado Kids - 394697,true,Quia neque dolorem quis cum sit dolores omnis dolores ex.,,"quince,silver,violet,yellow,zone9",Ruecker - Jakubowski,2626181040130,false,2017-10-26T17:06:35.479433Z,false,,36,Service only
Sentra Electronics - 598797,true,Incidunt officiis minus vero distinctio quasi.,,"brown,mauve,white,zone2,zone7","Senger, Schinner and Zieme",3036454614095,false,2018-12-28T21:40:59.003417Z,false,,24,Service only
Ranchero Garden - 625229,true,Ipsum ea nam exercitationem ea perspiciatis.,,"brown,gold,mauve,purple,zone8",Pfeffer - Dicki,0805820409756,false,2018-06-01T17:29:48.427245Z,false,,1,Parts only