Dashboard Control panel

  1. Home
  2. Dashboard

Order View (297881732 - 512962 - LINIOCO - canceled)

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



Info
id 21763
id_cbt
order_cbt 297881732
order_gsx 512962
date_cbt 2021-06-24 16:28:36
invoice_amount 1188.9
buyer_first_name GUSTAVO
buyer_last_name LONDOÑO RAMIREZ
buyer_company --
buyer_address_line_1 CR 17B 12A 57
buyer_address_line_2 LA NUEVA, Antioquia
buyer_city Girardota, 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-24 22:13:56
is_loaded_to_purchase_system 1
order_amazon /114-6266315-8155427
amazon_amount 54.3
amazon_date 2021-06-24 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 /B079TG94Z6/B084J12LV4/B085PGXCFV/B087MZBSX6/B0869CBNS4
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 7628881
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 CR 17B 12A 57
shipping_city Girardota, Antioquia, Antioquia
shipping_country Colombia
shipping_phone_1 --
shipping_phone_2 --
acceptance_decision_date 0000-00-00 00:00:00
order_cbt_id 8140153
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:44:22
robot_date 0000-00-00 00:00:00
merchant
amazon_order_status
cs_site_id_2
CorporateName
CorporateDocument
FlagIsCorporate
log_date 2025-10-11 03:31:57
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
5684 297881732 512962 0 B079TG94Z6 
1 237.78 USD 900.00 CO 3.79 0.00 LINIOCO 2021-06-24 22:13:53
5685 297881732 512962 1 B084J12LV4 
1 237.78 USD 900.00 CO 3.79 0.00 LINIOCO 2021-06-24 22:13:53
5686 297881732 512962 2 B085PGXCFV 
1 237.78 USD 900.00 CO 3.79 0.00 LINIOCO 2021-06-24 22:13:54
5687 297881732 512962 3 B087MZBSX6 
1 237.78 USD 900.00 CO 3.79 0.00 LINIOCO 2021-06-24 22:13:55
5688 297881732 512962 4 B0869CBNS4 
1 237.78 USD 900.00 CO 3.79 0.00 LINIOCO 2021-06-24 22:13:56
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 B079TG94Z6  1 237.78 (Rate: 3.79) Amazon 0 237.47 900.00 CO 138067 CO 36429.29 36429.29 12.98 Incorrect R0: ([Price Site Local] < [Price Marketplace]) Profit: -36191.82 out of stock Help!
138067 CO
900.00 CO
Price Local
36429.29 36429.29
237.78 (Rate: 3.79)
Price USD
Qty: 1
B079TG94Z6
Amazon
Idx: 0
FOB: 12.98
Incorrect R0: ([Price Site Local] < [Price Marketplace]) Profit: -36191.82 out of stock Help!
Amazon - Ofertas de Cyber Monday 30 de noviembre
All SKU's
Quantity 1
View Sheet Product B079TG94Z6
Price FOB USD: B079TG94Z6
Update Price
Total Commission LOCAL 0 Real Marketplace Commission LOCAL
Total Commission USD 0 Real Marketplace Commission USD
FOB 15.56 Estimated Price FOB
SHIPPING 12.33 Estimated International Shipping
COMM 1.67 Estimated International Commission
IVA 0 Estimated TAX
SHIPPING2 33.46 FOB+SHIPPING+COMM+IVA
CSCOMM 5.58 Estimated Marketplace Commission
CURR 4126.05 Currency Rate
TOTAL 138067.03 Estimated Total Local
1 B084J12LV4  1 237.78 (Rate: 3.79) Amazon 0 237.47 900.00 CO 120326 CO 31748.28 31748.28 9.99 Incorrect R0: ([Price Site Local] < [Price Marketplace]) Profit: -31510.81 out of stock Help!
120326 CO
900.00 CO
Price Local
31748.28 31748.28
237.78 (Rate: 3.79)
Price USD
Qty: 1
B084J12LV4
Amazon
Idx: 1
FOB: 9.99
Incorrect R0: ([Price Site Local] < [Price Marketplace]) Profit: -31510.81 out of stock Help!
Amazon - Ofertas de Cyber Monday 30 de noviembre
All SKU's
Quantity 1
View Sheet Product B084J12LV4
Price FOB USD: B084J12LV4
Update Price
Total Commission LOCAL 0 Real Marketplace Commission LOCAL
Total Commission USD 0 Real Marketplace Commission USD
FOB 11.97 Estimated Price FOB
SHIPPING 12.33 Estimated International Shipping
COMM 1.28 Estimated International Commission
IVA 0 Estimated TAX
SHIPPING2 29.16 FOB+SHIPPING+COMM+IVA
CSCOMM 4.86 Estimated Marketplace Commission
CURR 4126.05 Currency Rate
TOTAL 120325.6 Estimated Total Local
2 B085PGXCFV  1 237.78 (Rate: 3.79) Amazon 0 237.47 900.00 CO 120326 CO 31748.28 31748.28 9.99 Incorrect R0: ([Price Site Local] < [Price Marketplace]) Profit: -31510.81 out of stock Help!
120326 CO
900.00 CO
Price Local
31748.28 31748.28
237.78 (Rate: 3.79)
Price USD
Qty: 1
B085PGXCFV
Amazon
Idx: 2
FOB: 9.99
Incorrect R0: ([Price Site Local] < [Price Marketplace]) Profit: -31510.81 out of stock Help!
Amazon - Ofertas de Cyber Monday 30 de noviembre
All SKU's
Quantity 1
View Sheet Product B085PGXCFV
Price FOB USD: B085PGXCFV
Update Price
Total Commission LOCAL 0 Real Marketplace Commission LOCAL
Total Commission USD 0 Real Marketplace Commission USD
FOB 11.97 Estimated Price FOB
SHIPPING 12.33 Estimated International Shipping
COMM 1.28 Estimated International Commission
IVA 0 Estimated TAX
SHIPPING2 29.16 FOB+SHIPPING+COMM+IVA
CSCOMM 4.86 Estimated Marketplace Commission
CURR 4126.05 Currency Rate
TOTAL 120325.6 Estimated Total Local
3 B087MZBSX6  1 237.78 (Rate: 3.79) Amazon 0 237.47 900.00 CO 120326 CO 31748.28 31748.28 9.99 Incorrect R0: ([Price Site Local] < [Price Marketplace]) Profit: -31510.81 out of stock Help!
120326 CO
900.00 CO
Price Local
31748.28 31748.28
237.78 (Rate: 3.79)
Price USD
Qty: 1
B087MZBSX6
Amazon
Idx: 3
FOB: 9.99
Incorrect R0: ([Price Site Local] < [Price Marketplace]) Profit: -31510.81 out of stock Help!
Amazon - Ofertas de Cyber Monday 30 de noviembre
All SKU's
Quantity 1
View Sheet Product B087MZBSX6
Price FOB USD: B087MZBSX6
Update Price
Total Commission LOCAL 0 Real Marketplace Commission LOCAL
Total Commission USD 0 Real Marketplace Commission USD
FOB 11.97 Estimated Price FOB
SHIPPING 12.33 Estimated International Shipping
COMM 1.28 Estimated International Commission
IVA 0 Estimated TAX
SHIPPING2 29.16 FOB+SHIPPING+COMM+IVA
CSCOMM 4.86 Estimated Marketplace Commission
CURR 4126.05 Currency Rate
TOTAL 120325.6 Estimated Total Local
4 B0869CBNS4  1 237.78 (Rate: 3.79) Amazon 0 237.47 900.00 CO 310319 CO 81878.36 81878.36 42.01 Incorrect R0: ([Price Site Local] < [Price Marketplace]) Profit: -81640.89 out of stock Help!
310319 CO
900.00 CO
Price Local
81878.36 81878.36
237.78 (Rate: 3.79)
Price USD
Qty: 1
B0869CBNS4
Amazon
Idx: 4
FOB: 42.01
Incorrect R0: ([Price Site Local] < [Price Marketplace]) Profit: -81640.89 out of stock Help!
Amazon - Ofertas de Cyber Monday 30 de noviembre
All SKU's
Quantity 1
View Sheet Product B0869CBNS4
Price FOB USD: B0869CBNS4
Update Price
Total Commission LOCAL 0 Real Marketplace Commission LOCAL
Total Commission USD 0 Real Marketplace Commission USD
FOB 50.34 Estimated Price FOB
SHIPPING 12.33 Estimated International Shipping
COMM 5.39 Estimated International Commission
IVA 0 Estimated TAX
SHIPPING2 75.21 FOB+SHIPPING+COMM+IVA
CSCOMM 12.53 Estimated Marketplace Commission
CURR 4126.05 Currency Rate
TOTAL 310319.16 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
4931 297881732 512962 2021-06-24 114-6266315-8155427 51.14 0.00 3.16 54.30 3004 2021-06-24 22:19:52 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
/114-6266315-8155427 54.3 2021-06-24 00:00:00 0000-00-00


Form

Form



Shipping
id 10970
order_cbt 297881732
order_gsx 512962
type S
city Girardota, Antioquia, Antioquia
company --
country Colombia
country_iso_code --
firstname GUSTAVO
lastname LONDOÑO RAMIREZ
phone_secondary --
state --
street_1 CR 17B 12A 57
street_2 LA NUEVA, Antioquia
zip_code --
type_doc NationalRegistrationNumber
id_doc 7628881


Billing
id 10969
order_cbt 297881732
order_gsx 512962
type B
city Antioquia
company --
country Colombia
country_iso_code --
firstname GUSTAVO
lastname LONDOÑO RAMIREZ
phone_secondary --
state --
street_1 CR 17B 12A 57
street_2 --
zip_code 05308
type_doc NationalRegistrationNumber
id_doc 7628881


Quote
id 1834167
order_cbt 297881732
order_gsx 512962
idx 0
website_id LINIO-CO
sku B079TG94Z6
sku_supplier
sku_seller
package_weight 0.1100
fob 5.9900
local_shipping 0.0000
local_tax 0.0000
cif 5.9900
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 1.1500
marketplace_fixed_fee 0.0000
currency_rate 3.7900
price_seller 99.7500
quantity 2
invoice_fob 5.9900
invoice_tax 0.0000
invoice_shipping 231.7900
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 211.4600
created_at 2021-06-24 22:13:52