Dashboard Control panel

  1. Home
  2. Dashboard

Order View (229291412 - 550421 - LINIOCL - delivered)

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



Info
id 28348
id_cbt
order_cbt 229291412
order_gsx 550421
date_cbt 2023-03-22 23:02:25
invoice_amount 302.45
buyer_first_name Alejandra
buyer_last_name Fuentes
buyer_company --
buyer_address_line_1 Juan Bosco 2038
buyer_address_line_2 CONCEPCION
buyer_city Biobio, Concepcion
buyer_state --
buyer_zip_code 0008101
buyer_country Chile
buyer_email
buyer_phone --
buyer_shipment_label_location
buyer_mercardolibre_site CL
buyer_mercardolibre_site_order_id
created_system 2023-03-23 02:09:21
is_loaded_to_purchase_system 1
order_amazon /230323-174358565-4627/10941428
amazon_amount 139.78
amazon_date 2023-03-23 00:00:00
status 5
observation has no amazon products,
shipment_status
international_tracking_id 001690010001940196072001001
easypost_warehouse_date 0000-00-00 00:00:00
easypost_carrier_date 0000-00-00 00:00:00
easypost_delivered_date 2023-04-05 06:48:07
easypost_observation Mail Americas - delivered
easypost_status delivered
amazon_status Shipped
amazon_carrier USPS
amazon_tracking_id 9400111206207130067246
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 /VSPEW0619/703c46cb779c42de_5551797
calculated_sale_price 0
price_amz 0
ship_MX 0
base_price_amz 0
qty_product 2
currency_code USD
cs_site_id LINIOCL
qty_items 2
order_esx
NationalRegistrationNumber 12106625-4
globalshopex_warehouse_date 2023-03-27 12:19:12
globalshopex_carrier_date 2023-03-29 15:13:34
invoice_amount_local 293981.00
easypost_carrier Mail Americas
shipping_street_1 Juan Bosco 2038
shipping_city Biobio, Concepcion
shipping_country Chile
shipping_phone_1 --
shipping_phone_2 --
acceptance_decision_date 0000-00-00 00:00:00
order_cbt_id 9237595
esx_masterid
esx_barcode
international_tracking_url https://mailamericas.com/tracking?tracking=001690010001940196072001001
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 972.00
reason_cancellation cancelled_by_customer
type_of_purchase automatic
status_oms Cancelled
commentary_cancellation ARREPENTIMIENTO DE COMPRA
cancellation_date 2023-12-05 19:43:46
robot_date 2023-03-23 02:18:42
merchant MADALUXE, BorderX,
amazon_order_status DELIVERED
cs_site_id_2
CorporateName
CorporateDocument
FlagIsCorporate
log_date 2025-09-27 16:18:51
flag_events_blocked 0
status_cancellation Finance Pending
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
12900 229291412 550421 0 VSPEW0619 
1 192.38 USD 186990.00 CL 972.00 0.00 LINIOCL 2023-03-23 02:09:21
12901 229291412 550421 1 703c46cb779c42de_5551797 
1 110.07 USD 106990.00 CL 972.00 0.00 LINIOCL 2023-03-23 02:09:21
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 VSPEW0619  1 192.38 (Rate: 972.00) MADALUXE 0 192.38 186990.00 CL 129893 CL 133.63 124.72 66 Correct R7: ([Price Site Local] >= [Price Marketplace]) Profit: 67.66 out of stock Help!
129893 CL
186990.00 CL
Price Local
133.63 124.72
192.38 (Rate: 972.00)
Price USD
Qty: 1
VSPEW0619
MADALUXE
Idx: 0
FOB: 66
Correct R7: ([Price Site Local] >= [Price Marketplace]) Profit: 67.66 out of stock Help!
Amazon - Ofertas de Cyber Monday 30 de noviembre
All SKU's
Quantity 1
View Sheet Product VSPEW0619
Price FOB USD: VSPEW0619
Update Price
Total Commission LOCAL 0 Real Marketplace Commission LOCAL
Total Commission USD 0 Real Marketplace Commission USD
FOB 77.88 Estimated Price FOB
SHIPPING 12 Estimated International Shipping
COMM 11.88 Estimated International Commission
IVA 23.95 Estimated TAX
SHIPPING2 136.6 FOB+SHIPPING+COMM+IVA
CSCOMM 22.77 Estimated Marketplace Commission
CURR 950.9 Currency Rate
TOTAL 129892.59 Estimated Total Local
1 703c46cb779c42de_5551797  1 110.07 (Rate: 972.00) BorderX 0 110.07 106990.00 CL 104296 CL 107.3 100.5 44.99 Correct R7: ([Price Site Local] >= [Price Marketplace]) Profit: 9.57 out of stock Help!
104296 CL
106990.00 CL
Price Local
107.3 100.5
110.07 (Rate: 972.00)
Price USD
Qty: 1
703c46cb779c42de_5551797
BorderX
Idx: 1
FOB: 44.99
Correct R7: ([Price Site Local] >= [Price Marketplace]) Profit: 9.57 out of stock Help!
Amazon - Ofertas de Cyber Monday 30 de noviembre
All SKU's
Quantity 1
View Sheet Product 703c46cb779c42de_5551797
Price FOB USD: 703c46cb779c42de_5551797
Update Price
Total Commission LOCAL 0 Real Marketplace Commission LOCAL
Total Commission USD 0 Real Marketplace Commission USD
FOB 60.17 Estimated Price FOB
SHIPPING 12 Estimated International Shipping
COMM 9.18 Estimated International Commission
IVA 19.23 Estimated TAX
SHIPPING2 109.68 FOB+SHIPPING+COMM+IVA
CSCOMM 18.28 Estimated Marketplace Commission
CURR 950.9 Currency Rate
TOTAL 104295.88 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
11335 229291412 550421 2023-03-23 230323-174358565-4627 50.98 0.00 0.00 50.98 3412 2023-03-23 17:43:59 0.00 automatic sent 0000-00-00 00:00:00 borderx
11336 229291412 550421 2023-03-23 10941428 88.80 0.00 0.00 88.80 2023-03-23 17:46:27 0.00 automatic sent 0000-00-00 00:00:00 madaluxe


PO NUMBER
order_amazon amazon_amount amazon_date amazon_status amazon_carrier amazon_tracking_id amazon_delivered_date amazon_order_status
/230323-174358565-4627/10941428 139.78 2023-03-23 00:00:00 Shipped USPS 9400111206207130067246 0000-00-00 DELIVERED


Details
order_cbt order_gsx po_number amazon_status amazon_carrier amazon_tracking_id amazon_delivered_date amazon_order_status
229291412 550421 230323-174358565-4627 Pending USPS 9400111206207130067246 0000-00-00 DELIVERED
229291412 550421 10941428 Shipped Fedex 396138474931 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
229291412 550421 230323-174358565-4627 Pending USPS 9400111206207130067246 0000-00-00 DELIVERED
229291412 550421 10941428 Shipped Fedex 396138474931 0000-00-00 Shipped

Form



Shipping
id 24154
order_cbt 229291412
order_gsx 550421
type S
city Biobio, Concepcion
company --
country Chile
country_iso_code --
firstname Alejandra
lastname Fuentes
phone_secondary --
state --
street_1 Juan Bosco 2038
street_2 CONCEPCION
zip_code 0008101
type_doc NationalRegistrationNumber
id_doc 12106625-4


Billing
id 24153
order_cbt 229291412
order_gsx 550421
type B
city --
company --
country Chile
country_iso_code --
firstname Alejandra Fuentes Gallardo
lastname --
phone_secondary --
state --
street_1
street_2 --
zip_code 00000
type_doc NationalRegistrationNumber
id_doc 12106625-4


Quote
id 1859096
order_cbt 229291412
order_gsx 550421
idx 0
website_id LINIO-CL
sku VSPEW0619
sku_supplier
sku_seller
package_weight 0.4100
fob 88.8000
local_shipping 0.0000
local_tax 0.0000
cif 111.0000
international_shipping 17.3000
international_commission 0.0000
tax 34.1900
duties 0.0000
fee 0.0000
handling 0.0000
marketplace_shipping 0.00
marketplace_commission 29.2500
marketplace_fixed_fee 0.0000
currency_rate 972.0000
price_seller 186371.7700
quantity 2
invoice_fob 88.8000
invoice_tax 34.1900
invoice_shipping 69.3900
invoice_total 192.3800
invoice_qty 1
invoice_price 192.3800
invoice_currency_code USD
invoice_price_site 186990.0000
invoice_currency_code_site CL
invoice_change_rate 972.0000
invoice_total_commission 0.0000
adjust_discount_value 0.6400
created_at 2023-03-23 02:09:20