Page Comparison

Name*

Text(1000)

* Required for Import

Additional Allergen Stmt (English)

Text (Max)

Additional Allergen Stmt (French)

Text (Max)

Additional Allergen Stmt (Spanish)

Text (Max)

Additional Allergen Stmts Are User Generated

Boolean

T / F

Allergen Statement (English)

Text (Max)

Allergen Statement (French)

Text (Max)

Allergen Statement (Spanish)

Text (Max)

Allergen Stmts Are User Generated

Boolean

T / F

Alternate Name (English)

Text(1000)

Alternate Name (French)

Text(1000)

Alternate Name (Spanish)

Text(1000)

Barcode Checksum

Number

Recommended left blank. If blank (NULL), checksum will be calculated.
If supplied, checksum recorded as an override

Barcode Manufacturer Code

Number

5 digit number

Barcode Product Code

Number

5 digit number

Barcode Product Type

Number

1 digit number

BLANK (empty field)

repeatable - used to provide blank column

Common Name

Text(1000)

Cooking Method

Text (30)

Cooking Temperature

Text (15)

Cooking Time

Text (15)

Cost Amount¹

Float

¹ 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 Per Serving

Float

Cost Quantity¹

Float

Creation Date

Date

Ingredient Statement Key

INT

Ingredient Stmt (English)

Text (MAX)

Ingredient Stmt (French)

Text (MAX)

Ingredient Stmt (Spanish)

Text (MAX)

Ingredient Stmts Are User Generated

Boolean

T / F

Is Fat

Boolean

Is Sugar

Boolean

Is Sweetener

Boolean

Modified Date

Date

Notes 1

Text (MAX)

Notes 2

Text (MAX)

Notes 3

Text (MAX)

Pan Size

Text (45)

Preparation Instructions

Text (3800)

Preparation Time

Text (15)

Primary Key

INT

Product Code

INT

Product Name

Text (75)

Serving Size is by Wgt

Boolean

T / F

Serving Size Measure

Exact Text or ENUM

See Document:
Available Measures (Import)

Serving Size Quantity

Float

Supplier Code

INT

Supplier Name

Text (255)

Unit Gram Weight²

Float

² 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

³ 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

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"