MantikiFeed
Standard sales
Sales are split into two tables in MantikiFeed.
dbo.sales
id | store_code | sales_order_group_number | sales_order_number | shipment_reference_number | customer_number | order_created_on | order_shipped_on | sales_channel | order_type | goods_gross_inc_tax | goods_discount_inc_tax | goods_discount_tax | winebank_interest_inc_tax | winebank_interest_tax | goods_net_inc_tax | goods_tax | goods_net_ex_tax | delivery_gross_inc_tax | delivery_discount_inc_tax | delivery_discount_tax | delivery_net_inc_tax | delivery_tax | delivery_net_ex_tax | User_Field_1 | User_Field_2 | User_Field_3 | Description | promotion_goods_discount | agent_goods_discount_tax | payment_promotional_credit | payment_promotional_credit_tax | promotion_shipping_discount | promotion_shipping_discount_tax | agent_shipping_discount | agent_shipping_discount_tax | entry_created_on | promotion_goods_discount_tax | agent_goods_discount |
31896 | vwshop | V0017798 | V0017798AA | V0017798AA-D001 | 84002060 | 11/10/17 12:00 AM | 11/13/17 12:00 AM | Subscription | standard | 101.88 | 0 | 0 | 0 | 0 | 101.88 | 16.98 | 84.9 | 7.99 | 0 | 0 | 7.99 | 1.33 | 6.66 | 84002060 | [NULL] | V0017798 | V0017798AA | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 11/13/17 03:22 PM | 0 | 0 |
dbo.sales_payment
id | payment_gateway | authorisation_transaction_id | settlement_transaction_id | gateway_authorisation_transaction_id | gateway_settlement_transaction_id | payment_method | card_type | card_number | amount | sales_id | User_Field_1 | User_Field_2 | User_Field_3 | Description | entry_created_on |
31960 | WorldPay-HC | V0017798-P001 | V0017798-P001-S001 | 2002616180 | 2004506280 | Card | Visa Credit Card | ********1111 | 109.87 | 31896 | [NULL] | 2004506280 | [NULL] | [NULL] | 11/13/17 03:22 PM |
Preorders
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.