Dashboard Control panel

  1. Home
  2. Dashboard

Order View (0470058842 - 585991 - LIVERPOOLMX - RECEIVED)

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



Info
id 33393
id_cbt
order_cbt 0470058842
order_gsx 585991
date_cbt 2025-01-25 01:54:57
invoice_amount 474.32
buyer_first_name Ana
buyer_last_name Sanchez
buyer_company --
buyer_address_line_1 Calle:Bosques del istmo,Numero:306,
buyer_address_line_2 Reference: Colonia:BOSQUES DEL VALLE 1ER SECTOR,Municipio:SAN PEDRO GARZA GARCIA,entre calle:Bosques del valle,y calle:Bosques de chspultepec
buyer_city Monterrey
buyer_state NUEVO LEON
buyer_zip_code 66250
buyer_country MEXICO
buyer_email --
buyer_phone 81-10504190
buyer_shipment_label_location
buyer_mercardolibre_site MX
buyer_mercardolibre_site_order_id
created_system 2025-01-25 02:38:14
is_loaded_to_purchase_system 1
order_amazon /11260742
amazon_amount 126.2
amazon_date 2025-01-25 00:00:00
status 8
observation has no amazon products,
shipment_status
international_tracking_id 5742752364
easypost_warehouse_date 0000-00-00 00:00:00
easypost_carrier_date 0000-00-00 00:00:00
easypost_delivered_date 0000-00-00 00:00:00
easypost_observation easypost
easypost_status tracking_code_created
amazon_status Shipped
amazon_carrier Fedex
amazon_tracking_id 284781824721
amazon_delivered_date 0000-00-00
merchant_id 2458890
flag_shp 1
flag_del 0
status_cbt RECEIVED
payment_status_cbt
mercadolibre_fee 0
currency_rate 0
free_shipping_cost 0
SKU /VSPOQ2B21/VSPOQ1D21
calculated_sale_price 0
price_amz 0
ship_MX 0
base_price_amz 0
qty_product 2
currency_code USD
cs_site_id LIVERPOOLMX
qty_items 2
order_esx
NationalRegistrationNumber 3763593986
globalshopex_warehouse_date 2025-02-17 15:48:28
globalshopex_carrier_date 2025-03-10 13:35:14
invoice_amount_local 9771.00
easypost_carrier dhl
shipping_street_1 Calle:Bosques del istmo,Numero:306,
shipping_city Monterrey
shipping_country MEXICO
shipping_phone_1 81-10504190
shipping_phone_2 81-10504190
acceptance_decision_date 0000-00-00 00:00:00
order_cbt_id 0470058842
esx_masterid
esx_barcode
international_tracking_url https://www.dhl.com/mx-es/home/tracking/tracking-express.html?submit=1&tracking-id=5742752364
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.60
reason_cancellation
type_of_purchase automatic
status_oms
commentary_cancellation
cancellation_date 0000-00-00 00:00:00
robot_date 2025-01-25 02:45:09
merchant MADALUXE,
amazon_order_status Shipped
cs_site_id_2 --
CorporateName --
CorporateDocument --
FlagIsCorporate
log_date 2025-11-25 05:47:15
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
18149 0470058842 585991 0 VSPOQ2B21 
1 236.94 USD 4881.00 MX 20.60 0.00 LIVERPOOLMX 2025-01-25 02:38:14
18150 0470058842 585991 1 VSPOQ1D21 
1 237.38 USD 4890.00 MX 20.60 0.00 LIVERPOOLMX 2025-01-25 02:38:14
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 VSPOQ2B21  1 236.94 (Rate: 20.60) MADALUXE 1 236.94 4881.00 MX 4881.07 MX 236.95 236.95 63 Incorrect R0: ([Price Site Local] < [Price Marketplace]) Profit: -0.0099999999999909 stock Help!
4881.07 MX
4881.00 MX
Price Local
236.95 236.95
236.94 (Rate: 20.60)
Price USD
Qty: 1
VSPOQ2B21
MADALUXE
Idx: 0
FOB: 63
Incorrect R0: ([Price Site Local] < [Price Marketplace]) Profit: -0.0099999999999909 stock Help!
Amazon - Ofertas de Cyber Monday 30 de noviembre
All SKU's
Quantity 1
View Sheet Product VSPOQ2B21
Price FOB USD: VSPOQ2B21
Update Price
Total Commission LOCAL 0 Real Marketplace Commission LOCAL
Total Commission USD 0 Real Marketplace Commission USD
FOB 85.05 Estimated Price FOB
SHIPPING 43.52 Estimated International Shipping
COMM 22.05 Estimated International Commission
IVA 15.75 Estimated TAX
SHIPPING2 181.26 FOB+SHIPPING+COMM+IVA
CSCOMM 55.68 Estimated Marketplace Commission
CURR 20.6 Currency Rate
TOTAL 4881.07 Estimated Total Local
1 VSPOQ1D21  1 237.38 (Rate: 20.60) MADALUXE 1 237.38 4890.00 MX 4545.01 MX 220.63 220.63 55.2 Correct R7: ([Price Site Local] >= [Price Marketplace]) Profit: 16.75 stock Help!
4545.01 MX
4890.00 MX
Price Local
220.63 220.63
237.38 (Rate: 20.60)
Price USD
Qty: 1
VSPOQ1D21
MADALUXE
Idx: 1
FOB: 55.2
Correct R7: ([Price Site Local] >= [Price Marketplace]) Profit: 16.75 stock Help!
Amazon - Ofertas de Cyber Monday 30 de noviembre
All SKU's
Quantity 1
View Sheet Product VSPOQ1D21
Price FOB USD: VSPOQ1D21
Update Price
Total Commission LOCAL 0 Real Marketplace Commission LOCAL
Total Commission USD 0 Real Marketplace Commission USD
FOB 74.52 Estimated Price FOB
SHIPPING 43.52 Estimated International Shipping
COMM 19.32 Estimated International Commission
IVA 13.8 Estimated TAX
SHIPPING2 168.78 FOB+SHIPPING+COMM+IVA
CSCOMM 51.85 Estimated Marketplace Commission
CURR 20.6 Currency Rate
TOTAL 4545.01 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
16218 0470058842 585991 2025-01-25 11260742 126.20 0.00 0.00 126.20 2025-01-25 03:39:37 0.00 automatic sent 0000-00-00 00:00:00


PO NUMBER
order_amazon amazon_amount amazon_date amazon_status amazon_carrier amazon_tracking_id amazon_delivered_date amazon_order_status
/11260742 126.2 2025-01-25 00:00:00 Shipped Fedex 284781824721 0000-00-00 Shipped


Details
order_cbt order_gsx po_number amazon_status amazon_carrier amazon_tracking_id amazon_delivered_date amazon_order_status
0470058842 585991 11260742 Shipped Fedex 284781824721 0000-00-00 Shipped

Form

Details
order_cbt order_gsx po_number amazon_status amazon_carrier amazon_tracking_id amazon_delivered_date amazon_order_status
0470058842 585991 11260742 Shipped Fedex 284781824721 0000-00-00 Shipped

Form

Details
id order_cbt order_gsx po_number carrier tracking created_system observation
22599 0470058842 585991 585991 dhl 5742752364 2025-03-13 16:39:47


Shipping
id 34244
order_cbt 0470058842
order_gsx 585991
type S
city Monterrey
company --
country MEXICO
country_iso_code --
firstname Ana
lastname Sanchez
phone_secondary 81-10504190
state NUEVO LEON
street_1 Calle:Bosques del istmo,Numero:306,
street_2 Reference: Colonia:BOSQUES DEL VALLE 1ER SECTOR,Municipio:SAN PEDRO GARZA GARCIA,entre calle:Bosques del valle,y calle:Bosques de chspultepec
zip_code 66250
type_doc NationalRegistrationNumber
id_doc 3763593986


Billing
id 34243
order_cbt 0470058842
order_gsx 585991
type B
city Monterrey
company --
country MEXICO
country_iso_code --
firstname ana maria sanchez cantu
lastname .
phone_secondary 00-00000000
state NUEVO LEON
street_1 Calle:Bosques del istmo,Numero:306,
street_2 Reference: Colonia:BOSQUES DEL VALLE 1ER SECTOR,Municipio:SAN PEDRO GARZA GARCIA
zip_code 66250
type_doc NationalRegistrationNumber
id_doc 3763593986


Quote
id 1874724
order_cbt 0470058842
order_gsx 585991
idx 0
website_id LIVERPOOL-MX
sku VSPOQ2B21
sku_supplier
sku_seller
package_weight 0.2300
fob 63.0000
local_shipping 0.0000
local_tax 0.0000
cif 85.0500
international_shipping 43.5200
international_commission 22.0500
tax 15.7500
duties 0.0000
fee 0.0000
handling 0.0000
marketplace_shipping 0.00
marketplace_commission 55.6800
marketplace_fixed_fee 36.9400
currency_rate 20.6000
price_seller 4881.0700
quantity 2
invoice_fob 63.0000
invoice_tax 15.7500
invoice_shipping 158.1900
invoice_total 236.9400
invoice_qty 1
invoice_price 236.9400
invoice_currency_code USD
invoice_price_site 4881.0000
invoice_currency_code_site MX
invoice_change_rate 20.6000
invoice_total_commission 0.0000
adjust_discount_value 0.0000
created_at 2025-01-25 02:38:14