When an Order is created or imported, Line Items related to that Order are created and linked to that Order. The following steps explain the link between OrderLine and OrderLineProduct Entities.
we have an OrderLine entity that stores the information related to Line Items we have received from different marketplaces or created using Direct Retail. Every item in the Order will create one separate line item (Record) in OrderLine.
In eStack we have some special SKUs such as Combo SKU which is a legacy way of special SKUs, now latest is SKU Alias. These SKUs are not single, these are combinations of multiple components. e.g. we have one SKU named SKU123 and this will refer to two different SKUs like SKU1 and SKU2 etc.
Regular SKUs or Special SKUs are stored directly in the OrderLine. Whereas in the case of Special SKUs, we will use the legacy isCombo flag, so that the system can identify this as a special SKU.
In case we are receiving special SKUs, such as Combo(legacy), or 200200-200210(legacy), that are stored directly in the OrderLine table with a Flag like isCombo equal to 1.
But that SKU is not regular, then related to the SKU, we have a different entity named OrderLineProduct. this entity is storing the products related to that OrderLine.
For example, we have SKU abc123 stored in OrderLine, then this SKU is getting parsed, and then products related to this get stored in the OrderLineProduct with an ID of OrderLine and Product ID(which is regular SKU ID )