Magento Database Model
Last updated
Last updated
Magento doesn't come with a built-in feature for managing duties. To fill this gap, we've introduced new tables as an extension to the Magento database model. These additions make it easier to handle duties.
This upgrade enhances Magento allowing Glopal to automatically adjust order summary used on the website and emails, default invoice document and other places where order total is presented. By using these additions you can automatically pull duty and customs amounts into your ERP or other connected systems.
Following Magento's convention, any value prefixed with base_ represents the amount in the original Magento shop currency. Depending on your Glopal account settings, values without the base_ prefix can represent the amount in the presentment currency (default option allowing you to reconcile in the same currency the buyer paid, e.g., destination currency), payout currency (what you will receive), or the same original shop currency.
We extend Magento sales_order with a one-to-one relation to the gl_sales_order_attribute table that adds additional meta information and Customs costs (extra charges).
If Global Duty & Tax calculation is used, two additional tables store calculated duties. The Magento sales_order table is linked one-to-one to gl_sales_order_tcc for order-level amounts, and sales_order_item is linked one-to-one to gl_sales_order_item_tcc for item-level duties.
Name
Type
Description
entity_id
int(10)
Primary key
order_id
int(10)
Foreign key - Magento order id (entity_id)
glopal_id
varchar(255)
Unique Glopal Order ID
transaction_id
varchar(255)
Unique Glopal Transaction ID if Glopal Duty & Tax calculation is used
customer_origin_email
varchar(255)
Customer original email
customer_shipping_address
mediumtext
Customer original shipping address (JSON) if Parcel Forwarding is used
base_extra_amount_net
decimal(20,4)
Base extra amount net
extra_amount_net
decimal(20,4)
Extra amount net
base_extra_tax_on_amount
decimal(20,4)
Base extra tax on amount
extra_tax_on_amount
decimal(20,4)
Extra tax on amount
prealert_status
varchar(255)
Glopal pre-alert status
Name
Type
Description
entity_id
int(10)
Primary key
order_id
int(10)
Foreign key - Magento order id (entity_id)
base_total_duty_amount
decimal(20,4)
Base total order duty amount
total_duty_amount
decimal(20,4)
Total order duty amount
base_total_tax_on_duty
decimal(20,4)
Base total order tax on duty amount
total_tax_on_duty
decimal(20,4)
Total order tax on duty amount
base_items_duty_amount
decimal(20,4)
Base order items duty amount
items_duty_amount
decimal(20,4)
Order items duty amount
base_items_tax_on_duty
decimal(20,4)
Base order items tax on duty amount
items_tax_on_duty
decimal(20,4)
Order items tax on duty amount
base_discount_duty_amount
decimal(20,4)
Base order discount duty amount
discount_duty_amount
decimal(20,4)
Order order discount duty amount
base_discount_tax_on_duty
decimal(20,4)
Base order discount tax on duty amount
discount_tax_on_duty
decimal(20,4)
Order discount tax on duty amount
base_shipping_duty_amount
decimal(20,4)
Base order shipping duty amount
shipping_duty_amount
decimal(20,4)
Order shipping duty amount
base_shipping_tax_on_duty
decimal(20,4)
Base order shipping tax on duty amount
shipping_tax_on_duty
decimal(20,4)
Order shipping tax on duty amount
base_extra_duty_amount
decimal(20,4)
Base order extra duty amount
extra_duty_amount
decimal(20,4)
Order extra duty amount
base_extra_tax_on_duty
decimal(20,4)
Base order extra tax on duty amount
extra_tax_on_duty
decimal(20,4)
Order extra tax on duty amount
Name
Type
Description
entity_id
int(10)
Primary key
order_item_id
int(10)
Foreign key - Magento order item id (item_id)
order_tcc_id
decimal(20,4)
Foreign key - Glopal tcc id (gl_sales_order_tcc)
base_duty_amount
decimal(20,4)
Base order item duty amount
duty_amount
decimal(20,4)
Order item duty amount
base_tax_on_duty
decimal(20,4)
Base order item tax on duty amount
tax_on_duty
decimal(20,4)
Order item tax on duty amount
duty_percent
decimal(12,4)
Duty percents
