Field | Type | IMPORT notes |
|---|
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 Amount1 | Float | 1 Three 'Cost [X]' fields are used together.
For example "5 pounds costs 2.75" - Amount: 2.75 | Measure: Pound | Quantity: 5 |
Cost Measure1 | Exact Text or ENUM | See Document:
Available Measures (Import) |
Cost Per Serving | Float | |
Cost Quantity1 | 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 Weight2 | Float | 2 Three 'Unit [X]' fields are used together.
For example "5 pieces = 75 g" - Gram Weight: 75 | Measure: Piece | Quantity: 5 |
Unit Measure2 | Exact Text or ENUM | See Document:
Available Measures (Import) |
Unit Quantity2 | 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 Weight3 | Float | 3 Three 'Volume [X]' fields are used together.
For example "1.5 cup = 350 g" - Gram Weight: 350 | Measure: Cup | Quantity: 1.5 |
Volume Measure3 | Exact Text or ENUM | See Document:
Available Measures (Import) |
Volume Quantity3 | Float | |