Sales Order SKUs need to be delivered as a raw data format, one SKU per line comprising

• Sales order number

• Parent only SKU

  • SKU Code

  • SKU Quantity

  • Child SKUs on the same line in further columns:

    • SKU Code1

    • SKU Code1

    • SKU Code2

    • SKU Code2

    • SKU Code2

    • SKU Code3

    • SKU Code4

      • (in this example, 2xSKU Code 1, 3xSKU Code 2, 1xSKU Code 3, 1xSKU Code4)

New Requirements

The SKU layouts should be as follows:

For any sales order, the SKUs which actually go to the warehouse are necessary to be displayed, which is as follows:

SKU Types

A Sales Order can comprise of

• lines where there is a parent SKU and child SKUs of the parent

• lines where there is only a parent SKU and no child SKU

Lines where there is a parent SKU and child SKUs of the parent

In the case of lines where there is a parent SKU and child SKUs of the parent, only the child SKUs need to be extracted.

Lines where there is a parent SKU only

In the case of lines where there is a parent SKU only, the parent SKUs need to be extracted.

Total of each SKU

The total quantity of each SKU across a Sales Order needs to be shown for each Sales Order.

Layout

• Sales Order Number (External Ref)

• SKU

• SKU Quantity