Field | Type | IMPORT notes |
|---|
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 |
Alternate Name (English) | Text(1000) | |
Alternate Name (French) | Text(1000) | |
Alternate Name (Spanish) | Text(1000) | |
BLANK (empty field) | | repeatable - used to provide blank column |
Common Name | Text(1000) | |
Cost Amount1 | Float | 1 All 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 Quantity1 | 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 | |
Ingredient Statement Key | INT | |
Ingredient Stmt (English) | Text (MAX) | |
Ingredient Stmt (French) | Text (MAX) | |
Ingredient Stmt (Spanish) | Text (MAX) | |
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 Weight2 | Float | 2 All 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) |
Unit Gram Weight2 | Float | 3 All three 'Volume [X]' fields are used together.
For example "1.5 cup = 350 g" - Gram Weight: 350 | Measure: Cup | Quantity: 1.5 |
Unit Measure2 | Exact Text or ENUM | See Document:
Available Measures (Import) |
Unit Quantity2 | Float | |