Dashboard Control panel

  1. Home
  2. Dashboard

Order View (221111732 - 512980 - LINIOCO - canceled)

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



Info
id 21767
id_cbt
order_cbt 221111732
order_gsx 512980
date_cbt 2021-06-24 21:28:17
invoice_amount 1188.9
buyer_first_name Ricardo
buyer_last_name Jiménez
buyer_company --
buyer_address_line_1 Calle 26a#58-82 Apto 301
buyer_address_line_2 cabañas, Antioquia
buyer_city Bello, Antioquia, Antioquia
buyer_state --
buyer_zip_code --
buyer_country Colombia
buyer_email
buyer_phone --
buyer_shipment_label_location
buyer_mercardolibre_site CO
buyer_mercardolibre_site_order_id
created_system 2021-06-25 03:13:52
is_loaded_to_purchase_system 1
order_amazon /113-8253035-1384200
amazon_amount 270.55
amazon_date 2021-06-25 00:00:00
status 5
observation
shipment_status
international_tracking_id
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_status shipment_canceled
amazon_status
amazon_carrier
amazon_tracking_id
amazon_delivered_date 0000-00-00
merchant_id 2458890
flag_shp 1
flag_del 0
status_cbt canceled
payment_status_cbt
mercadolibre_fee 0
currency_rate 0
free_shipping_cost 0
SKU /B07DVX1HQM/B087G7X8XY/B0856W45VL/B07LC7813V/B07YCVQ1KP
calculated_sale_price 0
price_amz 0
ship_MX 0
base_price_amz 0
qty_product 5
currency_code USD
cs_site_id LINIOCO
qty_items 5
order_esx
NationalRegistrationNumber 1128402354
globalshopex_warehouse_date 0000-00-00 00:00:00
globalshopex_carrier_date 0000-00-00 00:00:00
invoice_amount_local 4500.00
easypost_carrier
shipping_street_1 Calle 26a#58-82 Apto 301
shipping_city Bello, Antioquia, Antioquia
shipping_country Colombia
shipping_phone_1 --
shipping_phone_2 --
acceptance_decision_date 0000-00-00 00:00:00
order_cbt_id 8142108
esx_masterid 0
esx_barcode
international_tracking_url
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 3.79
reason_cancellation price_difference
type_of_purchase unknown
status_oms Cancelled
commentary_cancellation
cancellation_date 2021-06-25 19:49:06
robot_date 0000-00-00 00:00:00
merchant
amazon_order_status
cs_site_id_2
CorporateName
CorporateDocument
FlagIsCorporate
log_date 2025-10-10 22:04:37
flag_events_blocked 0
status_cancellation 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
5724 221111732 512980 0 B07DVX1HQM 
1 237.78 USD 900.00 CO 3.79 0.00 LINIOCO 2021-06-25 03:13:48
5725 221111732 512980 1 B087G7X8XY 
1 237.78 USD 900.00 CO 3.79 0.00 LINIOCO 2021-06-25 03:13:49
5726 221111732 512980 2 B0856W45VL 
1 237.78 USD 900.00 CO 3.79 0.00 LINIOCO 2021-06-25 03:13:50
5727 221111732 512980 3 B07LC7813V 
1 237.78 USD 900.00 CO 3.79 0.00 LINIOCO 2021-06-25 03:13:51
5728 221111732 512980 4 B07YCVQ1KP 
1 237.78 USD 900.00 CO 3.79 0.00 LINIOCO 2021-06-25 03:13:52
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 B07DVX1HQM  1 237.78 (Rate: 3.79) Amazon 0 237.47 900.00 CO 170168 CO 44899.21 44899.21 18.39 Incorrect R0: ([Price Site Local] < [Price Marketplace]) Profit: -44661.74 out of stock Help!
170168 CO
900.00 CO
Price Local
44899.21 44899.21
237.78 (Rate: 3.79)
Price USD
Qty: 1
B07DVX1HQM
Amazon
Idx: 0
FOB: 18.39
Incorrect R0: ([Price Site Local] < [Price Marketplace]) Profit: -44661.74 out of stock Help!
Amazon - Ofertas de Cyber Monday 30 de noviembre
All SKU's
Quantity 1
View Sheet Product B07DVX1HQM
Price FOB USD: B07DVX1HQM
Update Price
Total Commission LOCAL 0 Real Marketplace Commission LOCAL
Total Commission USD 0 Real Marketplace Commission USD
FOB 22.04 Estimated Price FOB
SHIPPING 12.33 Estimated International Shipping
COMM 2.36 Estimated International Commission
IVA 0 Estimated TAX
SHIPPING2 41.24 FOB+SHIPPING+COMM+IVA
CSCOMM 6.87 Estimated Marketplace Commission
CURR 4126.05 Currency Rate
TOTAL 170167.75 Estimated Total Local
1 B087G7X8XY  1 237.78 (Rate: 3.79) Amazon 0 237.47 900.00 CO 268665 CO 70887.86 70887.86 34.99 Incorrect R0: ([Price Site Local] < [Price Marketplace]) Profit: -70650.39 out of stock Help!
268665 CO
900.00 CO
Price Local
70887.86 70887.86
237.78 (Rate: 3.79)
Price USD
Qty: 1
B087G7X8XY
Amazon
Idx: 1
FOB: 34.99
Incorrect R0: ([Price Site Local] < [Price Marketplace]) Profit: -70650.39 out of stock Help!
Amazon - Ofertas de Cyber Monday 30 de noviembre
All SKU's
Quantity 1
View Sheet Product B087G7X8XY
Price FOB USD: B087G7X8XY
Update Price
Total Commission LOCAL 0 Real Marketplace Commission LOCAL
Total Commission USD 0 Real Marketplace Commission USD
FOB 41.93 Estimated Price FOB
SHIPPING 12.33 Estimated International Shipping
COMM 4.49 Estimated International Commission
IVA 0 Estimated TAX
SHIPPING2 65.11 FOB+SHIPPING+COMM+IVA
CSCOMM 10.85 Estimated Marketplace Commission
CURR 4126.05 Currency Rate
TOTAL 268665.34 Estimated Total Local
2 B0856W45VL  1 237.78 (Rate: 3.79) Amazon 0 237.47 900.00 CO 387337 CO 102199.74 102199.74 54.99 Incorrect R0: ([Price Site Local] < [Price Marketplace]) Profit: -101962.27 out of stock Help!
387337 CO
900.00 CO
Price Local
102199.74 102199.74
237.78 (Rate: 3.79)
Price USD
Qty: 1
B0856W45VL
Amazon
Idx: 2
FOB: 54.99
Incorrect R0: ([Price Site Local] < [Price Marketplace]) Profit: -101962.27 out of stock Help!
Amazon - Ofertas de Cyber Monday 30 de noviembre
All SKU's
Quantity 1
View Sheet Product B0856W45VL
Price FOB USD: B0856W45VL
Update Price
Total Commission LOCAL 0 Real Marketplace Commission LOCAL
Total Commission USD 0 Real Marketplace Commission USD
FOB 65.9 Estimated Price FOB
SHIPPING 12.33 Estimated International Shipping
COMM 7.06 Estimated International Commission
IVA 0 Estimated TAX
SHIPPING2 93.88 FOB+SHIPPING+COMM+IVA
CSCOMM 15.65 Estimated Marketplace Commission
CURR 4126.05 Currency Rate
TOTAL 387337.16 Estimated Total Local
3 B07LC7813V  1 237.78 (Rate: 3.79) Amazon 0 237.47 900.00 CO 316134 CO 83412.66 83412.66 42.99 Incorrect R0: ([Price Site Local] < [Price Marketplace]) Profit: -83175.19 out of stock Help!
316134 CO
900.00 CO
Price Local
83412.66 83412.66
237.78 (Rate: 3.79)
Price USD
Qty: 1
B07LC7813V
Amazon
Idx: 3
FOB: 42.99
Incorrect R0: ([Price Site Local] < [Price Marketplace]) Profit: -83175.19 out of stock Help!
Amazon - Ofertas de Cyber Monday 30 de noviembre
All SKU's
Quantity 1
View Sheet Product B07LC7813V
Price FOB USD: B07LC7813V
Update Price
Total Commission LOCAL 0 Real Marketplace Commission LOCAL
Total Commission USD 0 Real Marketplace Commission USD
FOB 51.52 Estimated Price FOB
SHIPPING 12.33 Estimated International Shipping
COMM 5.52 Estimated International Commission
IVA 0 Estimated TAX
SHIPPING2 76.62 FOB+SHIPPING+COMM+IVA
CSCOMM 12.77 Estimated Marketplace Commission
CURR 4126.05 Currency Rate
TOTAL 316134.06 Estimated Total Local
4 B07YCVQ1KP  1 237.78 (Rate: 3.79) Amazon 0 237.47 900.00 CO 811878 CO 214215.83 214215.83 124.95 Incorrect R0: ([Price Site Local] < [Price Marketplace]) Profit: -213978.36 out of stock Help!
811878 CO
900.00 CO
Price Local
214215.83 214215.83
237.78 (Rate: 3.79)
Price USD
Qty: 1
B07YCVQ1KP
Amazon
Idx: 4
FOB: 124.95
Incorrect R0: ([Price Site Local] < [Price Marketplace]) Profit: -213978.36 out of stock Help!
Amazon - Ofertas de Cyber Monday 30 de noviembre
All SKU's
Quantity 1
View Sheet Product B07YCVQ1KP
Price FOB USD: B07YCVQ1KP
Update Price
Total Commission LOCAL 0 Real Marketplace Commission LOCAL
Total Commission USD 0 Real Marketplace Commission USD
FOB 149.74 Estimated Price FOB
SHIPPING 14.23 Estimated International Shipping
COMM 16.04 Estimated International Commission
IVA 0 Estimated TAX
SHIPPING2 196.77 FOB+SHIPPING+COMM+IVA
CSCOMM 32.79 Estimated Marketplace Commission
CURR 4126.05 Currency Rate
TOTAL 811878.31 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
4933 221111732 512980 2021-06-25 113-8253035-1384200 266.91 0.00 3.64 270.55 3004 2021-06-25 03:19:46 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
/113-8253035-1384200 270.55 2021-06-25 00:00:00 0000-00-00


Form

Form



Shipping
id 10978
order_cbt 221111732
order_gsx 512980
type S
city Bello, Antioquia, Antioquia
company --
country Colombia
country_iso_code --
firstname Ricardo
lastname Jiménez
phone_secondary --
state --
street_1 Calle 26a#58-82 Apto 301
street_2 cabañas, Antioquia
zip_code --
type_doc NationalRegistrationNumber
id_doc 1128402354


Billing
id 10977
order_cbt 221111732
order_gsx 512980
type B
city Antioquia
company --
country Colombia
country_iso_code --
firstname Ricardo
lastname Jiménez
phone_secondary --
state --
street_1 Calle 26a#58-82 Apto 301
street_2 --
zip_code 05088
type_doc NationalRegistrationNumber
id_doc 1128402354


Quote
id 1834247
order_cbt 221111732
order_gsx 512980
idx 0
website_id LINIO-CO
sku B07DVX1HQM
sku_supplier
sku_seller
package_weight 0.0600
fob 24.4900
local_shipping 0.0000
local_tax 0.0000
cif 24.4900
international_shipping 15.5100
international_commission 0.0000
tax 0.0000
duties 0.0000
fee 0.0000
handling 0.0000
marketplace_shipping 0.00
marketplace_commission 4.7000
marketplace_fixed_fee 0.0000
currency_rate 3.7900
price_seller 197.2200
quantity 2
invoice_fob 24.4900
invoice_tax 0.0000
invoice_shipping 213.2900
invoice_total 237.7800
invoice_qty 1
invoice_price 237.7800
invoice_currency_code USD
invoice_price_site 900.0000
invoice_currency_code_site CO
invoice_change_rate 3.7850
invoice_total_commission 0.0000
adjust_discount_value 185.7400
created_at 2021-06-25 03:13:48