Name

 The name of the frame

Text

Required

 Material

 The material the frame is made from

Text

Required

 Color

 The color of the frame

Text

Required

 Eye

 The eye measurement

Integer

Required

 Temple

 The temple measurement

Integer

Required

 Bridge

 The bridge measurement

Integer

Required

 Stock Status

Whether or not the item should be kept on hand (stocked) or ordered when required (special)

Text

Required

Stocked: stock, a, active, y, t, true yes, 1
Special Order: s, special, special_order specialorder, special_order_item, specialorderitem

 Manufacturer

 The manufacturer of the frame

Text

Required

 Edge Type

 The edge type of the frame

Text

Optional

 Gender

 The gender that the frame is designed for

Text

Optional

 Requested Base Curve

 The requested base curve of the frame

Text

Optional

 Minimum Base Curve

 The minimum base curve of the frame

Text

Optional

 Prop 65?

 Whether the frame is prop65 or not

Text

Optional

 Brand

 The brand of the frame

Text

Optional

 Collection

 The collection of the frame

Text

Optional

 Model

 The model of the frame

Text

Optional

 Frame Class

 The class of the frame

Text

Optional

Status

The inventory status of the item (active, inactive, discontinued, on order, backordered, recalled)

Text

Optional

Active: a, active, y, t, true yes, 1
Inactive: inactive, I, 0, no, false, n, f
Discontinued: discontinued, d
On order: on_order, onorder, oo, o
Back Ordered: backordered, backorder, back_ordered, back_order, bo, b
Recalled: recalled, r

 A

 The horizontal width of each lens at its widest point

Float (with single decimal place)

Optional

 B

 The vertical height of the lenses at the widest point of the lens within the frame

Float (with single decimal place)

Optional

 ED

 The longest diagonal distance inside the frame edges in mm

Float (with single decimal place)

Optional

 Part Type

 What portion of a frame the model represents

Text

Required
if Import file contains parts/miscellaneous items flag is checked

 UPC

 UPC of the frame

Text

Optional

 Manufacturer UPC

 The manufacturer's frame UPC

Text

Optional

 Trace

 The trace of the frame

Text

Optional

 Standard Cost

 Standard cost of the frame

Float (with two decimal place)

Optional

 Average Cost

 The average cost of the frame across all receipts at all warehouses

Float (with two decimal place)

Optional

MSRP

 Manufacturer Suggested Retail Price of the frame

Float (with two decimal place)

Optional

Suggested Retail Price

 Suggested Retail Price of the frame

Float (with two decimal place)

Optional

 Price Group

 The price group that the frame is a member of

Text

Optional

 Last Used

 The last time this item was used by the system

Datetime

Optional

 Backorder Date

 The date and time the item is expected to be available again

Date

Optional

 Reorder Method

 The method used to reorder this item

Text

Optional

 Dynamic Days

 The number of days after item creation to switch from min/max to usage history reorder method

Integer

Optional

 Description

 An optional freetext description of the item

Text

Optional

 Web

 This flag tracks if the frame is displayed on the lab's website, if applicable

Boolean

Optional

y, t, true yes, 1

 Vision Star Item Number

 Item number from VisionStar

Text

Optional

 Name

 The name of the frame

Text

Required