An order item is the record of a specific line item within a specific order.
An order item may consist of one or more units of a single product. If an order contains multiple units of the same product, all of the units will be recorded as a single order item, unless one or more units are different in some way.
example
The product Breakfast Blend Coffee (16 oz bag) has a [url=field]product field to allow customers to choose between Whole Bean or Ground Coffee.
A customer orders two units of Breakfast Blend Coffee (16 oz bag) in the Whole Bean version, and one unit of Breakfast Blend Coffee (16 oz bag) in the Ground Coffee version.
The store's database creates one order item record for the two units of Breakfast Blend Coffee (16 oz bag) in the Whole Bean version, and a different order item record for the one unit of Breakfast Blend Coffee (16 oz bag) in the Ground Coffee version.
Every order item record has a unique SID number, and an order item record is created for every line item of every order.
example
A customer orders one unit of product SID 38, five units of product SID 21, two units of product SID 19, and one unit of product SID 37. This order is recorded in the store's database as order SID 112.
Another customer orders 1 unit of product SID 38, three units of product SID 21, and one unit of product SID 24. This order is recorded in the store's database as order SID 113.
The store's database will also contain a record of each line item, as follows:
-
Order item SID 235 contains the record of one unit of product SID 38 for order SID 112.
-
Order item SID 236 contains the record of five units of product SID 21 for order SID 112.
-
Order item SID 237 contains the record of two units of product SID 19 for order SID 112.
-
Order item SID 238 contains the record of one unit of product SID 37 for order SID 112.
-
Order item SID 239 contains the record of one unit of product SID 38 for order SID 113.
-
Order item SID 240 contains the record of three units of product SID 21 for order SID 113.
-
Order item SID 241 contains the record of one unit of product SID 24 for order SID 113.
Exported data for order SID 112 and order SID 113
|
