Skip to content

# 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,