Dashboard Control panel

  1. Home
  2. Dashboard

Order View (234787352 - 542538 - LINIOCL - delivered)

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



Info
id 27123
id_cbt
order_cbt 234787352
order_gsx 542538
date_cbt 2022-11-24 17:09:01
invoice_amount 764.35
buyer_first_name Rosa
buyer_last_name Bravo
buyer_company --
buyer_address_line_1 Domingo Santa Cruz Wilson 7205
buyer_address_line_2 RENCA
buyer_city Metropolitana, Renca
buyer_state --
buyer_zip_code 0013128
buyer_country Chile
buyer_email
buyer_phone --
buyer_shipment_label_location
buyer_mercardolibre_site CL
buyer_mercardolibre_site_order_id
created_system 2022-11-24 20:39:45
is_loaded_to_purchase_system 1
order_amazon /10892887
amazon_amount 368.66
amazon_date 2022-11-24 00:00:00
status 8
observation has no amazon products,
shipment_status
international_tracking_id 5330072272670840013201131284
easypost_warehouse_date 0000-00-00 00:00:00
easypost_carrier_date 0000-00-00 00:00:00
easypost_delivered_date 2022-12-07 15:18:44
easypost_observation Mail Americas - delivered
easypost_status delivered
amazon_status Shipped
amazon_carrier Fedex
amazon_tracking_id 391111000150
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 /VSPLN1921/VSPQ16521/VSPLM3121/VSPOQ2C21/VSPQ15321
calculated_sale_price 0
price_amz 0
ship_MX 0
base_price_amz 0
qty_product 5
currency_code USD
cs_site_id LINIOCL
qty_items 5
order_esx
NationalRegistrationNumber 18423685-0
globalshopex_warehouse_date 2022-11-30 14:58:03
globalshopex_carrier_date 2022-12-01 07:58:54
invoice_amount_local 742948.00
easypost_carrier Mail Americas
shipping_street_1 Domingo Santa Cruz Wilson 7205
shipping_city Metropolitana, Renca
shipping_country Chile
shipping_phone_1 --
shipping_phone_2 --
acceptance_decision_date 0000-00-00 00:00:00
order_cbt_id 9000390
esx_masterid
esx_barcode
international_tracking_url https://mailamericas.com/tracking?tracking=5330072272670840013201131284
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
type_of_purchase automatic
status_oms
commentary_cancellation
cancellation_date 0000-00-00 00:00:00
robot_date 2022-11-24 20:57:57
merchant MADALUXE,
amazon_order_status Shipped
cs_site_id_2
CorporateName
CorporateDocument
FlagIsCorporate
log_date 2025-11-28 01:57:20
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
11613 234787352 542538 0 VSPLN1921 
1 130.65 USD 126990.00 CL 972.00 0.00 LINIOCL 2022-11-24 20:39:41
11614 234787352 542538 1 VSPQ16521 
1 199.58 USD 193990.00 CL 972.00 0.00 LINIOCL 2022-11-24 20:39:42
11615 234787352 542538 2 VSPLM3121 
1 142.99 USD 138990.00 CL 972.00 0.00 LINIOCL 2022-11-24 20:39:43
11616 234787352 542538 3 VSPOQ2C21 
1 135.79 USD 131990.00 CL 972.00 0.00 LINIOCL 2022-11-24 20:39:44
11617 234787352 542538 4 VSPQ15321 
1 155.34 USD 150990.00 CL 972.00 0.00 LINIOCL 2022-11-24 20:39:45
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 VSPLN1921  1 130.65 (Rate: 972.00) MADALUXE 0 130.65 126990.00 CL 91523 CL 94.16 88.42 43.5 Correct R7: ([Price Site Local] >= [Price Marketplace]) Profit: 42.23 out of stock Help!
91523 CL
126990.00 CL
Price Local
94.16 88.42
130.65 (Rate: 972.00)
Price USD
Qty: 1
VSPLN1921
MADALUXE
Idx: 0
FOB: 43.5
Correct R7: ([Price Site Local] >= [Price Marketplace]) Profit: 42.23 out of stock Help!
Amazon - Ofertas de Cyber Monday 30 de noviembre
All SKU's
Quantity 1
View Sheet Product VSPLN1921
Price FOB USD: VSPLN1921
Update Price
Total Commission LOCAL 0 Real Marketplace Commission LOCAL
Total Commission USD 0 Real Marketplace Commission USD
FOB 51.33 Estimated Price FOB
SHIPPING 12 Estimated International Shipping
COMM 7.83 Estimated International Commission
IVA 16.88 Estimated TAX
SHIPPING2 96.25 FOB+SHIPPING+COMM+IVA
CSCOMM 16.04 Estimated Marketplace Commission
CURR 950.9 Currency Rate
TOTAL 91523.11 Estimated Total Local
1 VSPQ16521  1 199.58 (Rate: 972.00) MADALUXE 0 199.58 193990.00 CL 185908 CL 191.26 186.25 98 Correct R7: ([Price Site Local] >= [Price Marketplace]) Profit: 13.33 out of stock Help!
185908 CL
193990.00 CL
Price Local
191.26 186.25
199.58 (Rate: 972.00)
Price USD
Qty: 1
VSPQ16521
MADALUXE
Idx: 1
FOB: 98
Correct R7: ([Price Site Local] >= [Price Marketplace]) Profit: 13.33 out of stock Help!
Amazon - Ofertas de Cyber Monday 30 de noviembre
All SKU's
Quantity 1
View Sheet Product VSPQ16521
Price FOB USD: VSPQ16521
Update Price
Total Commission LOCAL 0 Real Marketplace Commission LOCAL
Total Commission USD 0 Real Marketplace Commission USD
FOB 121.78 Estimated Price FOB
SHIPPING 13 Estimated International Shipping
COMM 18.58 Estimated International Commission
IVA 35.92 Estimated TAX
SHIPPING2 204.83 FOB+SHIPPING+COMM+IVA
CSCOMM 34.14 Estimated Marketplace Commission
CURR 950.9 Currency Rate
TOTAL 194775.28 Estimated Total Local
2 VSPLM3121  1 142.99 (Rate: 972.00) MADALUXE 0 142.99 138990.00 CL 209765 CL 215.81 200.44 111.99 Incorrect R0: ([Price Site Local] < [Price Marketplace]) Profit: -57.45 out of stock Help!
209765 CL
138990.00 CL
Price Local
215.81 200.44
142.99 (Rate: 972.00)
Price USD
Qty: 1
VSPLM3121
MADALUXE
Idx: 2
FOB: 111.99
Incorrect R0: ([Price Site Local] < [Price Marketplace]) Profit: -57.45 out of stock Help!
Amazon - Ofertas de Cyber Monday 30 de noviembre
All SKU's
Quantity 1
View Sheet Product VSPLM3121
Price FOB USD: VSPLM3121
Update Price
Total Commission LOCAL 0 Real Marketplace Commission LOCAL
Total Commission USD 0 Real Marketplace Commission USD
FOB 132.15 Estimated Price FOB
SHIPPING 13 Estimated International Shipping
COMM 20.16 Estimated International Commission
IVA 38.68 Estimated TAX
SHIPPING2 220.6 FOB+SHIPPING+COMM+IVA
CSCOMM 36.77 Estimated Marketplace Commission
CURR 950.9 Currency Rate
TOTAL 209764.95 Estimated Total Local
3 VSPOQ2C21  1 135.79 (Rate: 972.00) MADALUXE 0 135.79 131990.00 CL 124777 CL 128.37 119.88 63 Correct R7: ([Price Site Local] >= [Price Marketplace]) Profit: 15.91 out of stock Help!
124777 CL
131990.00 CL
Price Local
128.37 119.88
135.79 (Rate: 972.00)
Price USD
Qty: 1
VSPOQ2C21
MADALUXE
Idx: 3
FOB: 63
Correct R7: ([Price Site Local] >= [Price Marketplace]) Profit: 15.91 out of stock Help!
Amazon - Ofertas de Cyber Monday 30 de noviembre
All SKU's
Quantity 1
View Sheet Product VSPOQ2C21
Price FOB USD: VSPOQ2C21
Update Price
Total Commission LOCAL 0 Real Marketplace Commission LOCAL
Total Commission USD 0 Real Marketplace Commission USD
FOB 74.34 Estimated Price FOB
SHIPPING 12 Estimated International Shipping
COMM 11.34 Estimated International Commission
IVA 23.01 Estimated TAX
SHIPPING2 131.22 FOB+SHIPPING+COMM+IVA
CSCOMM 21.87 Estimated Marketplace Commission
CURR 950.9 Currency Rate
TOTAL 124776.66 Estimated Total Local
4 VSPQ15321  1 155.34 (Rate: 972.00) MADALUXE 0 155.34 150990.00 CL 160929 CL 165.56 154.08 84.2 Correct R9: ([New Price Site USD] >= [Price Marketplace USD New]) Profit: 1.26 out of stock Help!
160929 CL
150990.00 CL
Price Local
165.56 154.08
155.34 (Rate: 972.00)
Price USD
Qty: 1
VSPQ15321
MADALUXE
Idx: 4
FOB: 84.2
Correct R9: ([New Price Site USD] >= [Price Marketplace USD New]) Profit: 1.26 out of stock Help!
Amazon - Ofertas de Cyber Monday 30 de noviembre
All SKU's
Quantity 1
View Sheet Product VSPQ15321
Price FOB USD: VSPQ15321
Update Price
Total Commission LOCAL 0 Real Marketplace Commission LOCAL
Total Commission USD 0 Real Marketplace Commission USD
FOB 99.36 Estimated Price FOB
SHIPPING 12 Estimated International Shipping
COMM 15.16 Estimated International Commission
IVA 29.68 Estimated TAX
SHIPPING2 169.24 FOB+SHIPPING+COMM+IVA
CSCOMM 28.21 Estimated Marketplace Commission
CURR 950.9 Currency Rate
TOTAL 160929.22 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
10089 234787352 542538 2022-11-24 10892887 368.66 0.00 0.00 368.66 2022-11-24 21:40:04 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
/10892887 368.66 2022-11-24 00:00:00 Shipped Fedex 391111000150 0000-00-00 Shipped


Details
order_cbt order_gsx po_number amazon_status amazon_carrier amazon_tracking_id amazon_delivered_date amazon_order_status
234787352 542538 10892887 Shipped Fedex 391111000150 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
234787352 542538 10892887 Shipped Fedex 391111000150 0000-00-00 Shipped

Form



Shipping
id 21704
order_cbt 234787352
order_gsx 542538
type S
city Metropolitana, Renca
company --
country Chile
country_iso_code --
firstname Rosa
lastname Bravo
phone_secondary --
state --
street_1 Domingo Santa Cruz Wilson 7205
street_2 RENCA
zip_code 0013128
type_doc NationalRegistrationNumber
id_doc 18423685-0


Billing
id 21703
order_cbt 234787352
order_gsx 542538
type B
city --
company --
country Chile
country_iso_code --
firstname Rosa Bravo
lastname --
phone_secondary --
state --
street_1
street_2 --
zip_code 00000
type_doc NationalRegistrationNumber
id_doc 18423685-0


Quote
id 1852692
order_cbt 234787352
order_gsx 542538
idx 0
website_id LINIO-CL
sku VSPLN1921
sku_supplier
sku_seller
package_weight 0.2300
fob 65.9000
local_shipping 0.0000
local_tax 0.0000
cif 65.9000
international_shipping 8.0000
international_commission 0.0000
tax 22.2400
duties 0.0000
fee 0.0000
handling 0.0000
marketplace_shipping 0.00
marketplace_commission 18.0200
marketplace_fixed_fee 0.0000
currency_rate 972.0000
price_seller 126977.0700
quantity 2
invoice_fob 65.9000
invoice_tax 22.2400
invoice_shipping 42.5100
invoice_total 130.6500
invoice_qty 1
invoice_price 130.6500
invoice_currency_code USD
invoice_price_site 126990.0000
invoice_currency_code_site CL
invoice_change_rate 972.0000
invoice_total_commission 0.0000
adjust_discount_value 0.0200
created_at 2022-11-24 20:39:40