Dashboard Control panel

  1. Home
  2. Dashboard

Order View (237256146 - 503663 - LINIOMX - delivered)

Ticket CBT | Ticket GSX | INSTRUCTIONS | PrefillcartwithURL | PrefillcartwithURL Madaluxe | PrefillcartwithURL BorderX



Info
id 20158
id_cbt
order_cbt 237256146
order_gsx 503663
date_cbt 2021-03-05 21:13:21
invoice_amount 160.88
buyer_first_name emmanue
buyer_last_name serrano
buyer_company --
buyer_address_line_1 tehuacan 211
buyer_address_line_2 Mitras Centro, Monterrey
buyer_city Nuevo León, Nuevo Leon, Monterrey
buyer_state --
buyer_zip_code 64460
buyer_country Mexico
buyer_email
buyer_phone --
buyer_shipment_label_location
buyer_mercardolibre_site MX
buyer_mercardolibre_site_order_id
created_system 2021-03-06 04:29:23
is_loaded_to_purchase_system 0
order_amazon / 112-2669383-3905029/112-5201527-8202616
amazon_amount 82.59
amazon_date 2021-03-06 00:00:00
status 8
observation
shipment_status
international_tracking_id 8990451223
easypost_warehouse_date 2021-11-24 18:17:45
easypost_carrier_date 2021-11-25 15:41:00
easypost_delivered_date 2021-04-08 13:51:11
easypost_observation DHL - delivered
easypost_status delivered
amazon_status Delivered
amazon_carrier Delivery by Amazon
amazon_tracking_id Tracking ID: TBA156188548201
amazon_delivered_date 0000-00-00
merchant_id 2458890
flag_shp 1
flag_del 0
status_cbt delivered
payment_status_cbt
mercadolibre_fee 0
currency_rate 0
free_shipping_cost 0
SKU /B004EYNC0I/B07HHKR88B
calculated_sale_price 0
price_amz 0
ship_MX 0
base_price_amz 0
qty_product 2
currency_code USD
cs_site_id LINIOMX
qty_items 2
order_esx
NationalRegistrationNumber COCE621226C12
globalshopex_warehouse_date 2021-03-09 16:29:40
globalshopex_carrier_date 2021-03-12 14:15:59
invoice_amount_local 3298.00
easypost_carrier dhl
shipping_street_1 tehuacan 211
shipping_city Nuevo León, Nuevo Leon, Monterrey
shipping_country Mexico
shipping_phone_1 --
shipping_phone_2 --
acceptance_decision_date 0000-00-00 00:00:00
order_cbt_id 7543365
esx_masterid
esx_barcode
international_tracking_url http://www.dhl-usa.com/en/express/tracking.html?AWB=8990451223&brand=DHL
shipping_street_2
customer_debited_date 0000-00-00 00:00:00
easypost_carrier_2
international_tracking_id_2
international_tracking_url_2
esx_status
easypost_delivered_date_2 0000-00-00 00:00:00
destination_carrier_date 0000-00-00 00:00:00
invoice_change_rate 20.50
reason_cancellation
type_of_purchase unknown
status_oms
commentary_cancellation
cancellation_date 0000-00-00 00:00:00
robot_date 0000-00-00 00:00:00
merchant
amazon_order_status
cs_site_id_2
CorporateName
CorporateDocument
FlagIsCorporate
log_date 2025-12-08 12:35:33
flag_events_blocked 0
status_cancellation
Details
id order_cbt order_gsx idx sku qty price currency_code price_site currency_code_site change_rate total_commission cs_site_id created_system
4024 237256146 503663 0 B004EYNC0I 
1 112.15 USD 2299.00 MX 20.50 0.00 LINIOMX 2021-03-06 04:29:22
4025 237256146 503663 1 B07HHKR88B 
1 48.73 USD 999.00 MX 20.50 0.00 LINIOMX 2021-03-06 04:29:23
Validation
IDX sku qty Price Site USD Merchant Stock GSX New Price Site USD Price Site Local Price Marketplace Price Marketplace USD Price Marketplace USD New Price FOB USD message
0 B004EYNC0I  1 112.15 (Rate: 20.50) Amazon 0 112.15 2299.00 MX 2206 MX 107.61 107.61 59.99 Correct R7: ([Price Site Local] >= [Price Marketplace]) Profit: 4.54 out of stock Help!
2206 MX
2299.00 MX
Price Local
107.61 107.61
112.15 (Rate: 20.50)
Price USD
Qty: 1
B004EYNC0I
Amazon
Idx: 0
FOB: 59.99
Correct R7: ([Price Site Local] >= [Price Marketplace]) Profit: 4.54 out of stock Help!
Amazon - Ofertas de Cyber Monday 30 de noviembre
All SKU's
Quantity 1
View Sheet Product B004EYNC0I
Price FOB USD: B004EYNC0I
Update Price
Total Commission LOCAL 0 Real Marketplace Commission LOCAL
Total Commission USD 0 Real Marketplace Commission USD
FOB 71.89 Estimated Price FOB
SHIPPING 11 Estimated International Shipping
COMM 7.7 Estimated International Commission
IVA 16.41 Estimated TAX
SHIPPING2 121.15 FOB+SHIPPING+COMM+IVA
CSCOMM 21.85 Estimated Marketplace Commission
CURR 18.21 Currency Rate
TOTAL 2206.17 Estimated Total Local
1 B07HHKR88B  1 48.73 (Rate: 20.50) Amazon 0 48.73 999.00 MX 876 MX 42.73 42.73 24.99 Correct R7: ([Price Site Local] >= [Price Marketplace]) Profit: 6 out of stock Help!
876 MX
999.00 MX
Price Local
42.73 42.73
48.73 (Rate: 20.50)
Price USD
Qty: 1
B07HHKR88B
Amazon
Idx: 1
FOB: 24.99
Correct R7: ([Price Site Local] >= [Price Marketplace]) Profit: 6 out of stock Help!
Amazon - Ofertas de Cyber Monday 30 de noviembre
All SKU's
Quantity 1
View Sheet Product B07HHKR88B
Price FOB USD: B07HHKR88B
Update Price
Total Commission LOCAL 0 Real Marketplace Commission LOCAL
Total Commission USD 0 Real Marketplace Commission USD
FOB 29.95 Estimated Price FOB
SHIPPING 9.5 Estimated International Shipping
COMM 3.21 Estimated International Commission
IVA 0 Estimated TAX
SHIPPING2 48.13 FOB+SHIPPING+COMM+IVA
CSCOMM 8.68 Estimated Marketplace Commission
CURR 18.21 Currency Rate
TOTAL 876.39 Estimated Total Local

Form

Details
id order_cbt order_gsx date_order po_number subtotal shipping tax total card created_system observation discount type_of_purchase purchase_id status canceled_at merchant
3347 237256146 503663 2021-03-06 112-2669383-3905029 22.99 0.00 1.61 24.60 4313 2021-03-06 18:38:54 0.00 sent 0000-00-00 00:00:00
3348 237256146 503663 2021-03-06 112-5201527-8202616 57.99 0.00 0.00 57.99 4313 2021-03-06 18:39:36 0.00 sent 0000-00-00 00:00:00 amazon


PO NUMBER
order_amazon amazon_amount amazon_date amazon_status amazon_carrier amazon_tracking_id amazon_delivered_date amazon_order_status
/ 112-2669383-3905029/112-5201527-8202616 82.59 2021-03-06 00:00:00 Delivered Delivery by Amazon Tracking ID: TBA156188548201 0000-00-00


Details
order_cbt order_gsx po_number amazon_status amazon_carrier amazon_tracking_id amazon_delivered_date amazon_order_status
237256146 503663 112-5201527-8202616 Delivered Delivery by Amazon Tracking ID: TBA156188548201 0000-00-00
237256146 503663 112-2669383-3905029 Delivered Delivery by Amazon Tracking ID: TBA156188548201 0000-00-00

Form

Details
order_cbt order_gsx po_number amazon_status amazon_carrier amazon_tracking_id amazon_delivered_date amazon_order_status
237256146 503663 112-5201527-8202616 Delivered Delivery by Amazon Tracking ID: TBA156188548201 0000-00-00
237256146 503663 112-2669383-3905029 Delivered Delivery by Amazon Tracking ID: TBA156188548201 0000-00-00

Form

Details
id order_cbt order_gsx po_number carrier tracking created_system observation
5015 237256146 503663 503663 dhl 8990451223 2021-03-12 19:17:48


Shipping
id 7760
order_cbt 237256146
order_gsx 503663
type S
city Nuevo León, Nuevo Leon, Monterrey
company --
country Mexico
country_iso_code --
firstname emmanue
lastname serrano
phone_secondary --
state --
street_1 tehuacan 211
street_2 Mitras Centro, Monterrey
zip_code 64460
type_doc NationalRegistrationNumber
id_doc COCE621226C12


Billing
id 7759
order_cbt 237256146
order_gsx 503663
type B
city -
company --
country -
country_iso_code --
firstname -
lastname -
phone_secondary --
state --
street_1 -
street_2 -
zip_code -
type_doc NationalRegistrationNumber
id_doc COCE621226C12


Quote
id 1830729
order_cbt 237256146
order_gsx 503663
idx 0
website_id LINIO-MX
sku B004EYNC0I
sku_supplier
sku_seller
package_weight 0.0700
fob 57.9900
local_shipping 0.0000
local_tax 0.0000
cif 57.9900
international_shipping 19.8500
international_commission 0.0000
tax 20.0100
duties 0.0000
fee 0.0000
handling 0.0000
marketplace_shipping 0.00
marketplace_commission 12.4200
marketplace_fixed_fee 0.8000
currency_rate 772.0000
price_seller 94254.9500
quantity 2
invoice_fob 57.9900
invoice_tax 20.0100
invoice_shipping 34.1500
invoice_total 112.1500
invoice_qty 1
invoice_price 112.1500
invoice_currency_code USD
invoice_price_site 2299.0000
invoice_currency_code_site MX
invoice_change_rate 20.5000
invoice_total_commission 0.0000
adjust_discount_value -9.9400
created_at 2021-03-06 04:29:22