Dashboard Control panel

  1. Home
  2. Dashboard

Order View (271577916 - 557368 - LINIOCO - delivered)

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



Info
id 29637
id_cbt
order_cbt 271577916
order_gsx 557368
date_cbt 2023-08-02 15:20:06
invoice_amount 401.19
buyer_first_name Luis Fernando
buyer_last_name Alvarez Contreras
buyer_company --
buyer_address_line_1 Carrera 18 54-45 Sur, Int Casa
buyer_address_line_2 San Carlos, Bogota D.C
buyer_city Tunjuelito, Bogota D.c, Bogota D.c
buyer_state --
buyer_zip_code --
buyer_country Colombia
buyer_email
buyer_phone --6012793371
buyer_shipment_label_location
buyer_mercardolibre_site CO
buyer_mercardolibre_site_order_id
created_system 2023-08-02 20:41:19
is_loaded_to_purchase_system 1
order_amazon /10986870
amazon_amount 226.6
amazon_date 2023-08-02 00:00:00
status 8
observation has no amazon products,
shipment_status
international_tracking_id MLCO005407096EX
easypost_warehouse_date 0000-00-00 00:00:00
easypost_carrier_date 0000-00-00 00:00:00
easypost_delivered_date 2023-08-17 22:18:25
easypost_observation Mail Americas - delivered
easypost_status delivered
amazon_status Shipped
amazon_carrier Fedex
amazon_tracking_id 781983001044
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 /VSPEV1121/VSPVV1121/VSPZZ0121
calculated_sale_price 0
price_amz 0
ship_MX 0
base_price_amz 0
qty_product 3
currency_code USD
cs_site_id LINIOCO
qty_items 3
order_esx
NationalRegistrationNumber 79544384
globalshopex_warehouse_date 2023-08-05 10:38:37
globalshopex_carrier_date 2023-08-07 16:26:49
invoice_amount_local 1917688.00
easypost_carrier Mail Americas
shipping_street_1 Carrera 18 54-45 Sur, Int Casa
shipping_city Tunjuelito, Bogota D.c, Bogota D.c
shipping_country Colombia
shipping_phone_1 6012793371
shipping_phone_2 --
acceptance_decision_date 0000-00-00 00:00:00
order_cbt_id 11583899
esx_masterid
esx_barcode
international_tracking_url https://mailamericas.com/tracking?tracking=MLCO005407096EX
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 4780.00
reason_cancellation
type_of_purchase automatic
status_oms
commentary_cancellation
cancellation_date 0000-00-00 00:00:00
robot_date 2023-08-02 20:49:58
merchant MADALUXE,
amazon_order_status Shipped
cs_site_id_2
CorporateName
CorporateDocument
FlagIsCorporate
log_date 2026-01-11 01:25:56
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
14261 271577916 557368 0 VSPEV1121 
1 133.87 USD 639900.00 CO 4780.00 0.00 LINIOCO 2023-08-02 20:41:18
14262 271577916 557368 1 VSPVV1121 
1 125.71 USD 600900.00 CO 4780.00 0.00 LINIOCO 2023-08-02 20:41:18
14263 271577916 557368 2 VSPZZ0121 
1 141.61 USD 676900.00 CO 4780.00 0.00 LINIOCO 2023-08-02 20:41:19
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 VSPEV1121  1 133.87 (Rate: 4780.00) MADALUXE 0 133.87 639900.00 CO 549986 CO 115.06 115.06 79 Correct R7: ([Price Site Local] >= [Price Marketplace]) Profit: 18.81 out of stock Help!
549986 CO
639900.00 CO
Price Local
115.06 115.06
133.87 (Rate: 4780.00)
Price USD
Qty: 1
VSPEV1121
MADALUXE
Idx: 0
FOB: 79
Correct R7: ([Price Site Local] >= [Price Marketplace]) Profit: 18.81 out of stock Help!
Amazon - Ofertas de Cyber Monday 30 de noviembre
All SKU's
Quantity 1
View Sheet Product VSPEV1121
Price FOB USD: VSPEV1121
Update Price
Total Commission LOCAL 0 Real Marketplace Commission LOCAL
Total Commission USD 0 Real Marketplace Commission USD
FOB 98.75 Estimated Price FOB
SHIPPING 12.33 Estimated International Shipping
COMM 19.75 Estimated International Commission
IVA 0 Estimated TAX
SHIPPING2 133.3 FOB+SHIPPING+COMM+IVA
CSCOMM 22.22 Estimated Marketplace Commission
CURR 4126.05 Currency Rate
TOTAL 549985.94 Estimated Total Local
1 VSPVV1121  1 125.71 (Rate: 4780.00) MADALUXE 0 125.71 600900.00 CO 655200 CO 137.07 137.07 96 Incorrect R0: ([Price Site Local] < [Price Marketplace]) Profit: -11.36 out of stock Help!
655200 CO
600900.00 CO
Price Local
137.07 137.07
125.71 (Rate: 4780.00)
Price USD
Qty: 1
VSPVV1121
MADALUXE
Idx: 1
FOB: 96
Incorrect R0: ([Price Site Local] < [Price Marketplace]) Profit: -11.36 out of stock Help!
Amazon - Ofertas de Cyber Monday 30 de noviembre
All SKU's
Quantity 1
View Sheet Product VSPVV1121
Price FOB USD: VSPVV1121
Update Price
Total Commission LOCAL 0 Real Marketplace Commission LOCAL
Total Commission USD 0 Real Marketplace Commission USD
FOB 129.6 Estimated Price FOB
SHIPPING 12.33 Estimated International Shipping
COMM 33.6 Estimated International Commission
IVA 0 Estimated TAX
SHIPPING2 170.32 FOB+SHIPPING+COMM+IVA
CSCOMM 28.39 Estimated Marketplace Commission
CURR 4126.05 Currency Rate
TOTAL 702732.31 Estimated Total Local
2 VSPZZ0121  1 141.61 (Rate: 4780.00) MADALUXE 0 141.61 676900.00 CO 694810 CO 145.36 145.36 102.4 Incorrect R0: ([Price Site Local] < [Price Marketplace]) Profit: -3.75 out of stock Help!
694810 CO
676900.00 CO
Price Local
145.36 145.36
141.61 (Rate: 4780.00)
Price USD
Qty: 1
VSPZZ0121
MADALUXE
Idx: 2
FOB: 102.4
Incorrect R0: ([Price Site Local] < [Price Marketplace]) Profit: -3.75 out of stock Help!
Amazon - Ofertas de Cyber Monday 30 de noviembre
All SKU's
Quantity 1
View Sheet Product VSPZZ0121
Price FOB USD: VSPZZ0121
Update Price
Total Commission LOCAL 0 Real Marketplace Commission LOCAL
Total Commission USD 0 Real Marketplace Commission USD
FOB 138.24 Estimated Price FOB
SHIPPING 12.33 Estimated International Shipping
COMM 35.84 Estimated International Commission
IVA 0 Estimated TAX
SHIPPING2 180.68 FOB+SHIPPING+COMM+IVA
CSCOMM 30.11 Estimated Marketplace Commission
CURR 4126.05 Currency Rate
TOTAL 745511.19 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
12617 271577916 557368 2023-08-02 10986870 226.60 0.00 0.00 226.60 2023-08-02 21:41:52 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
/10986870 226.6 2023-08-02 00:00:00 Shipped Fedex 781983001044 0000-00-00 Shipped


Details
order_cbt order_gsx po_number amazon_status amazon_carrier amazon_tracking_id amazon_delivered_date amazon_order_status
271577916 557368 10986870 Shipped Fedex 781983001044 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
271577916 557368 10986870 Shipped Fedex 781983001044 0000-00-00 Shipped

Form



Shipping
id 26732
order_cbt 271577916
order_gsx 557368
type S
city Tunjuelito, Bogota D.c, Bogota D.c
company --
country Colombia
country_iso_code --
firstname Luis Fernando
lastname Alvarez Contreras
phone_secondary --6012793371
state --
street_1 Carrera 18 54-45 Sur, Int Casa
street_2 San Carlos, Bogota D.C
zip_code --
type_doc NationalRegistrationNumber
id_doc 79544384


Billing
id 26731
order_cbt 271577916
order_gsx 557368
type B
city Tunjuelito
company --
country Colombia
country_iso_code --
firstname Luis Fernando
lastname Alvarez Contreras
phone_secondary --6012793371
state --
street_1 Carrera 18 54-45 Sur
street_2 San Carlos
zip_code 11001
type_doc NationalRegistrationNumber
id_doc 79544384


Quote
id 1861839
order_cbt 271577916
order_gsx 557368
idx 0
website_id LINIO-CO
sku VSPEV1121
sku_supplier
sku_seller
package_weight 0.4100
fob 77.6000
local_shipping 0.0000
local_tax 0.0000
cif 97.0000
international_shipping 16.3000
international_commission 19.4000
tax 0.0000
duties 0.0000
fee 0.0000
handling 0.0000
marketplace_shipping 0.00
marketplace_commission 20.3900
marketplace_fixed_fee 0.0000
currency_rate 4780.0000
price_seller 639057.3100
quantity 2
invoice_fob 77.6000
invoice_tax 0.0000
invoice_shipping 56.2700
invoice_total 133.8700
invoice_qty 1
invoice_price 133.8700
invoice_currency_code USD
invoice_price_site 639900.0000
invoice_currency_code_site CO
invoice_change_rate 4780.0000
invoice_total_commission 0.0000
adjust_discount_value 0.1800
created_at 2023-08-02 20:41:17