| MMv4 KB |
 |
|
|
Order Item |
| Last Edited - 04/1/2013 4:04pm PDT | |
| Category Path - Glossary | |
|
| 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:
Exported data for order SID 112 and order SID 113
|