Fields List - Ingredient Import (Create)

Name*^

Text(1000)

* Required for Import
^ On Import - Create: Value will be written (INSERT). 
^ On Import - Update, used as 3rd of 3 Key fields (PrimaryKey, UserCode, Name)

Gram Weight (g)* ^

Float

* Required for Import
^ Listed here for reference, but found under ‘Nutrients’ drop-down within ESHA Port

BLANK (empty field)

repeatable - used to provide blank column

Common Name

Text(1000)

Cost Amount¹

Float

¹ All three 'Cost [X]' fields  are used together.
For example "5 pounds costs 2.75" - Amount: 2.75 | Measure: Pound | Quantity: 5

Cost Measure¹

Exact Text or ENUM

See Document:
Available Measures (Import)

Cost Quantity¹

Float

Creation Date

DateTime

ESHA Code⁺

⁺ Do Not Include during Import.
If included, import will error (user-created cannot have an ESHA Code value)

Gov. Code

INT

Ing Stmt Name (English)

Text(1000)

Ing Stmt Name (French)

Text(1000)

Ing Stmt Name (Spanish)

Text(1000)

Ingredient Statement (English)

Text (MAX)

Ingredient Statement (French)

Text (MAX)

Ingredient Statement (Spanish)

Text (MAX)

Ingredient Statement Key

INT

Is Fat

Boolean

Is Sugar

Boolean

Is Sweetener

Boolean

Modified Date

DateTime

Notes 1

Text (MAX)

Notes 2

Text (MAX)

Notes 3

Text (MAX)

Primary Key^{^}

INT

^{^} On Import - Create: leave BLANK (NULL) to auto-generate.
^ On Import - Update, used as 1st of 3 Key fields (PrimaryKey, UserCode, Name)

Product Code

INT

Product Name

Text (75)

Supplier Code

INT

Supplier Name

Text (255)

Unit Gram Weight²

Float

² All three 'Unit [X]' fields are used together. 
For example "5 pieces = 75 g" - Gram Weight: 75 | Measure: Piece | Quantity: 5

Unit Measure²

Exact Text or ENUM

See Document:
Available Measures (Import)

Unit Quantity²

Float

User Code

Text(400)

^{^} On Import - Create: Value will be written (INSERT). 
^{^} On Import - Update, used as 2nd of 3 Key fields (PrimaryKey, UserCode, Name)

Volume Gram Weight³

Float

³ All three 'Volume [X]' fields are used together. 
For example "1.5 cup = 350 g" - Gram Weight: 350 | Measure: Cup | Quantity: 1.5

Volume Measure³

Exact Text or ENUM

See Document:
Available Measures (Import)

Volume Quantity³

Float

10:0 - Capric (g)

Float

12:0 - Lauric (g)

Float

14:0 - Myristic (g)

Float

14:1 - Myristol (g)

Float

15:0 - Pentadec (g)

Float

15:1 - Pentadecenoic (g)

Float

16:0 - Palmitic (g)

Float

16:1 - Palmitol (g)

Float

17:0 - Heptadec (g)

Float

17:1 - Heptadecenoic (g)

Float

18:0 - Stearic (g)

Float

18:1 - Oleic (g)

Float

18:2 - Linoleic (g)

Float

18:3 - Linolenic (g)

Float

18:4 - Stearidon (g)

Float

20:0 - Arachidic (g)

Float

20:1 - Eicosen (g)

Float

20:3 - Eicosatrienoic (g)

Float

20:4 - Arachidon (g)

Float

20:5 - EPA (g)

Float

22:0 - Behenate (g)

Float

22:1 - Erucic (g)

Float

22:5 - DPA (g)

Float

22:6 - DHA (g)

Float

24:0 - Tetracos (g)

Float

24:1 - Nervonic (g)

Float

4:0 - Butyric (g)

Float

6:0 - Caprioc (g)

Float

8:0 - Caprylic (g)

Float

Acetic Acid (g)

Float

Added Sugar (g)

Float

Alanine (g)

Float

Alcohol (g)

Float

Allulose

Float

Alpha-Carotene (mcg)

Float

Arginine (g)

Float

Artificial Sweetener (mg)

Float

Ash (g)

Float

Aspartame (mg)

Float

Aspartic Acid (g)

Float

Beta-Carotene (mcg)

Float

Beta-Carotene Equiv (mcg)

Float

Biotin (mcg)

Float

Boron (mcg)

Float

Caffeine (mg)

Float

Calcium (mg)

Float

Calories (kcal)

Float

Calories from Fat (kcal)

Ignored: Calculated from Total Fat

Calories from SatFat (kcal)

Ignored: Calculated from SaturatedFat

Calories from TransFat (kcal)

Ignored: Calculated from Trans Fat

Carbohydrate (Available) (g)

Float

Carbohydrates (g)

Float

Carotenoid RE (mcg)

Float

CBD (mg)

Float

Chloride (mg)

Float

Cholesterol (mg)

Float

Choline (mg)

Float

Chromium (mcg)

Float

Citric Acid (g)

Float

Copper (mg)

Float

Cost

Export Field only
Ignored: Calculated as Cost per defined Gram Weight

Cryptoxanthin (mcg)

Float

Cystine (g)

Float

Dietary Fiber (2016) (g)

Float

Disaccharides (g)

Float

Erythritol (g)

Float

Exchange - Alcohol

Float

Exchange - Fat

Float

Exchange - Fruit

Float

Exchange - Lean Meat

Float

Exchange - NonFat Milk

Float

Exchange - Other Carbs

Float

Exchange - Starch

Float

Exchange - Vegetables

Float

Fat (g)

Float

Fluoride (mg)

Float

Folate (mcg)

Float

Folate, DFE (mcg DFE)

Float

Folate, food (mcg)

Float

Folic Acid (mcg)

Float

Fructose (g)

Float

Galactose (g)

Float

Glucose (g)

Float

Glutamic Acid (g)

Float

Glycemic Index

Float

Glycemic Load

Float

Glycerol (g)

Float

Glycine (g)

Float

Gram Weight (g)* ^

Float

• Required for Import

^ Listed here for reference, but found under ‘Nutrients’ drop-down within ESHA Port

Histidine (g)

Float

Inositol (g)

Float

Insoluble Fiber (2016) (g)

Float

Insoluble Non-digestible Carbohydrate (g)

Float

Iodine (mcg)

Float

Iron (mg)

Float

Isoleucine (g)

Float

Kilojoules (kJ)

Float

Lactic Acid (g)

Float

Lactitol (g)

Float

Lactose (g)

Float

Leucine (g)

Float

Lutein & Zeaxanthin (mcg)

Float

Lycopene (mcg)

Float

Lysine (g)

Float

Magnesium (mg)

Float

Malic Acid (g)

Float

Maltitol (g)

Float

Maltose (g)

Float

Manganese (mg)

Float

Mannitol (g)

Float

Methionine (g)

Float

Molybdenum (mcg)

Float

Mono Fat (g)

Float

Monosaccharides (g)

Float

MyPlate - Dairy (c)

Float

MyPlate - Fruit (c)

Float

MyPlate - Grain Total (oz-eq)

Float

MyPlate - Protein Total (oz-eq)

Float

MyPlate - Vegetable Total (c)

Float

Net Carbs (g)

Ignored: Calculated

Non-digestible Carbohydrate (g)

Float

Omega 3 Fatty Acid (g)

Float

Omega 6 Fatty Acid (g)

Float

Organic Acids (g)

Float

Other Carbs (g)

Float

Pantothenic Acid (mg)

Float

Phenylalanine (g)

Float

Phosphorus (mg)

Float

Poly Fat (g)

Float

Polydextrose (g)

Float

Potassium (mg)

Float

Proline (g)

Float

Protein (g)

Float

Retinol RE (mcg)

Float

Saccharin (mg)

Float

Salatrims (g)

Float

Salt (g)

Float

Saturated Fat (g)

Float

Selenium (mcg)

Float

Serine (g)

Float

Sodium (mg)

Float

Soluble Fiber (2016) (g)

Float

Soluble Non-digestible Carbohydrate (g)

Float

Sorbitol (g)

Float

Starch (g)

Float

Sucrose (g)

Float

Sugar Alcohol (g)

Float

Sulfites (mg)

Float

Sulfites (ppm)

Float

Tagatose (g)

Float

Taurine (g)

Float

THC (mg)

Float

Threonine (g)

Float

Total Dietary Fiber (g)

Float

Total Insoluble Fiber (g)

Float

Total Soluble Fiber (g)

Float

Total Sugars (g)

Float

Trans Fatty Acid (g)

Float

Tryptophan (g)

Float

Tyrosine (g)

Float

Valine (g)

Float

Vitamin A - IU (IU)

Float

Vitamin A - RAE (mcg)

Float

Vitamin A - RE (mcg)

Float

Vitamin B1 - Thiamin (mg)

Float

Vitamin B12 (mcg)

Float

Vitamin B2 - Riboflavin (mg)

Float

Vitamin B3 - Niacin (mg)

Float

Vitamin B3 - Niacin Equiv (mg)

Float

Vitamin B6 (mg)

Float

Vitamin C (mg)

Float

Vitamin D - IU (IU)

Float

Vitamin D - mcg (mcg)

Float

Vitamin E - Alpha-Toco (mg)

Float

Vitamin E - Alpha-Toco Equiv (mg)

Float

Vitamin E - IU (IU)

Float

Vitamin E - mg (mg)

Float

Vitamin K (mcg)

Float

Water (g)

Float

Xylitol (g)

Float

Zinc (mg)

Float

Allergen Celery

Boolean

Allergen Crustaceans

Boolean

Allergen Egg

Boolean

Allergen Fish

Boolean

Allergen Gluten

Boolean

Allergen Lupin

Boolean

Allergen Milk

Boolean

Allergen Molluscs

Boolean

Allergen Mustard

Boolean

Allergen Peanut

Boolean

Allergen Sesame Seeds

Boolean

Allergen Shellfish

Boolean

Allergen Soy

Boolean

Allergen Sulphites

Boolean

Allergen Tree Nuts

Boolean

Allergen Wheat

Boolean

Bioengineered

Yes/No/Unknown

Allowed text is "Yes" (Qualifies), "No" (Does Not Qualify) "Unknown" (Unknown). 
Blank/NULL is considered "Unknown"

[User-Added Attributes]

Yes/No/Unknown

Allowed text is "Yes" (Qualifies), "No" (Does Not Qualify) "Unknown" (Unknown). 
Blank/NULL is considered "Unknown"