Part 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
Description
Notes
Wiki
Tags
ManufacturerNumber
WholeSalerNumber
AlternativeWholeSalerNumber
Cost
Retail
UnitOfMeasure
UPC
PartSerialsViz (update will overwrite all existing serial numbers if this field is included)

Linked object fields¶

The following linked objects are importable / updateable:

Manufacturer via "ManufacturerViz" field which must contain the name of an existing Vendor
Wholesaler via "WholeSalerViz" field which must contain the name of an existing Vendor
Alternative wholesaler via "AlternativeWholeSalerViz" 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": "048902",
        "Active": true,
        "Description": "test description",
        "Notes": "Alias nihil beatae dolores quam quisquam molestiae repudiandae magni consequatur dolores inventore distinctio.",
        "Wiki": "# Headings\n# Heading 1st level\n## Heading 2nd level\n### Heading 3rd level\n#### Heading 4th level\n##### Heading 5th level\n###### Heading 6th level",
        "Tags": [
            "orange",
            "zebra",
            "zone2",
            "zone4",
            "zone5"
        ],
        "ManufacturerViz": "Yellow Cedar Consulting",
        "ManufacturerNumber": "man-048902",
        "WholeSalerViz": "Ruecker - Jakubowski",
        "WholeSalerNumber": "ws-048902",
        "AlternativeWholeSalerViz": "Considine Group",
        "AlternativeWholeSalerNumber": "aws-048902",
        "Cost": 15.200000000000000000,
        "Retail": 18.240000000000000000,
        "UnitOfMeasure": "each",
        "UPC": "4058773855392",
        "PartSerialsViz": "387992910, 387992911, 387992912"
    },
    {
        "Name": "097091",
        "Active": true,
        "Description": null,
        "Notes": "Vel sit id quia provident cum et quaerat.",
        "Wiki": null,
        "Tags": [
            "black",
            "purple",
            "silver",
            "violet",
            "zebra"
        ],
        "ManufacturerViz": "Littel Group",
        "ManufacturerNumber": "man-097091",
        "WholeSalerViz": "Ruecker - Jakubowski",
        "WholeSalerNumber": "ws-097091",
        "AlternativeWholeSalerViz": "Jakubowski, Hoeger and Hauck",
        "AlternativeWholeSalerNumber": "aws-097091",
        "Cost": 18.060000000000000000,
        "Retail": 21.670000000000000000,
        "UnitOfMeasure": "each",
        "UPC": "2820615657752",
        "PartSerialsViz": ""
    },
    {
        "Name": "198660",
        "Active": true,
        "Description": null,
        "Notes": "Fuga quaerat neque quasi ut inventore explicabo velit explicabo delectus.",
        "Wiki": null,
        "Tags": [
            "jade",
            "zone5",
            "zone8",
            "zone9"
        ],
        "ManufacturerViz": "Yellow Cedar Consulting",
        "ManufacturerNumber": "man-198660",
        "WholeSalerViz": "Weimann Group",
        "WholeSalerNumber": "ws-198660",
        "AlternativeWholeSalerViz": "Considine Group",
        "AlternativeWholeSalerNumber": "aws-198660",
        "Cost": 13.740000000000000000,
        "Retail": 16.490000000000000000,
        "UnitOfMeasure": "each",
        "UPC": "5708648426804",
        "PartSerialsViz": ""
    }

]

CSV file format¶

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

Name,Active,Description,Notes,Wiki,Tags,ManufacturerViz,ManufacturerNumber,WholeSalerViz,WholeSalerNumber,AlternativeWholeSalerViz,AlternativeWholeSalerNumber,Cost,Retail,UnitOfMeasure,UPC,PartSerialsViz
048902,true,test description,Alias nihil beatae dolores quam quisquam molestiae repudiandae magni consequatur dolores inventore distinctio.,"# Headings
# Heading 1st level
## Heading 2nd level
### Heading 3rd level
#### Heading 4th level
##### Heading 5th level
###### Heading 6th level","orange,zebra,zone2,zone4,zone5",Yellow Cedar Consulting,man-048902,Ruecker - Jakubowski,ws-048902,Considine Group,aws-048902,15.2,18.24,each,4058773855392,"387992910, 387992911, 387992912"
097091,true,,Vel sit id quia provident cum et quaerat.,,"black,purple,silver,violet,zebra",Littel Group,man-097091,Ruecker - Jakubowski,ws-097091,"Jakubowski, Hoeger and Hauck",aws-097091,18.06,21.67,each,2820615657752,
198660,true,,Fuga quaerat neque quasi ut inventore explicabo velit explicabo delectus.,,"jade,zone5,zone8,zone9",Yellow Cedar Consulting,man-198660,Weimann Group,ws-198660,Considine Group,aws-198660,13.74,16.49,each,5708648426804,