...
process_extract_dream_shipment_payment
MantikiFeed
Standard sales
Sales are split into two tables in MantikiFeed.
dbo.sales
...
Preorders have some specific rules to follow.
- The dbo.sales_payment table must include both the initial payment of the deposit as an entry for eg £12 and upon redemption of the balance, there must be a second entry for the deposit as it is used as part payment for the balance.
- Where multiple items are preordered, the deposit should be credited all against the first item alphabetically, not spread evenly over the balance items:- ie the order with the suffix AA has all of the deposit credited against it. Where the deposit paid is greater than the value of the balance of the first item, only the value of the first item is used from the pool of the deposit and the remainder is credited against the next alphabetical item and so on. This has to be manufactured in the VW code as preorders in Mantiki work at a group level, not the level of the individual order.
Example below of a transaction where the deposit paid covers the price of one of the items fully
Stage 1, place preorder
dbo.sales
...
dbo.sales_payment
...
Stage 2, charge for balance
dbo.sales
...
dbo.sales_payment
...