Dashboard Control panel

  1. Home
  2. Dashboard

Order View (258143732 - 512988 - LINIOCO - canceled)

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



Info
id 21772
id_cbt
order_cbt 258143732
order_gsx 512988
date_cbt 2021-06-25 01:56:05
invoice_amount 951.12
buyer_first_name Olga Carolina
buyer_last_name Prins Niño
buyer_company --
buyer_address_line_1 Calle 25 #27-179
buyer_address_line_2 Las peñitas, Sucre
buyer_city Sincelejo, Sucre, Sucre
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 07:14:06
is_loaded_to_purchase_system 1
order_amazon /114-6486418-1927451
amazon_amount 82.92
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 /B06X9SCLBQ/B077HKNSX1/B071L13WQM/B074D63G61
calculated_sale_price 0
price_amz 0
ship_MX 0
base_price_amz 0
qty_product 4
currency_code USD
cs_site_id LINIOCO
qty_items 4
order_esx
NationalRegistrationNumber 1052948215
globalshopex_warehouse_date 0000-00-00 00:00:00
globalshopex_carrier_date 0000-00-00 00:00:00
invoice_amount_local 3600.00
easypost_carrier
shipping_street_1 Calle 25 #27-179
shipping_city Sincelejo, Sucre, Sucre
shipping_country Colombia
shipping_phone_1 --
shipping_phone_2 --
acceptance_decision_date 0000-00-00 00:00:00
order_cbt_id 8143129
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:51:50
robot_date 0000-00-00 00:00:00
merchant
amazon_order_status
cs_site_id_2
CorporateName
CorporateDocument
FlagIsCorporate
log_date 2025-11-06 19:26:48
flag_events_blocked 0
status_cancellation Finished
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
5734 258143732 512988 0 B06X9SCLBQ 
1 237.78 USD 900.00 CO 3.79 0.00 LINIOCO 2021-06-25 07:14:04
5735 258143732 512988 1 B077HKNSX1 
1 237.78 USD 900.00 CO 3.79 0.00 LINIOCO 2021-06-25 07:14:04
5736 258143732 512988 2 B071L13WQM 
1 237.78 USD 900.00 CO 3.79 0.00 LINIOCO 2021-06-25 07:14:05
5737 258143732 512988 3 B074D63G61 
1 237.78 USD 900.00 CO 3.79 0.00 LINIOCO 2021-06-25 07:14:06
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 B06X9SCLBQ  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
B06X9SCLBQ
Amazon
Idx: 0
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 B06X9SCLBQ
Price FOB USD: B06X9SCLBQ
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
1 B077HKNSX1  1 237.78 (Rate: 3.79) Amazon 1 237.47 900.00 CO 172423 CO 45494.2 45494.2 18.77 Incorrect R0: ([Price Site Local] < [Price Marketplace]) Profit: -45256.73 stock Help!
172423 CO
900.00 CO
Price Local
45494.2 45494.2
237.78 (Rate: 3.79)
Price USD
Qty: 1
B077HKNSX1
Amazon
Idx: 1
FOB: 18.77
Incorrect R0: ([Price Site Local] < [Price Marketplace]) Profit: -45256.73 stock Help!
Amazon - Ofertas de Cyber Monday 30 de noviembre
All SKU's
Quantity 1
View Sheet Product B077HKNSX1
Price FOB USD: B077HKNSX1
Update Price
Total Commission LOCAL 0 Real Marketplace Commission LOCAL
Total Commission USD 0 Real Marketplace Commission USD
FOB 22.49 Estimated Price FOB
SHIPPING 12.33 Estimated International Shipping
COMM 2.41 Estimated International Commission
IVA 0 Estimated TAX
SHIPPING2 41.79 FOB+SHIPPING+COMM+IVA
CSCOMM 6.96 Estimated Marketplace Commission
CURR 4126.05 Currency Rate
TOTAL 172422.52 Estimated Total Local
2 B071L13WQM  1 237.78 (Rate: 3.79) Amazon 0 237.47 900.00 CO 232826 CO 61431.66 61431.66 28.95 Incorrect R0: ([Price Site Local] < [Price Marketplace]) Profit: -61194.19 out of stock Help!
232826 CO
900.00 CO
Price Local
61431.66 61431.66
237.78 (Rate: 3.79)
Price USD
Qty: 1
B071L13WQM
Amazon
Idx: 2
FOB: 28.95
Incorrect R0: ([Price Site Local] < [Price Marketplace]) Profit: -61194.19 out of stock Help!
Amazon - Ofertas de Cyber Monday 30 de noviembre
All SKU's
Quantity 1
View Sheet Product B071L13WQM
Price FOB USD: B071L13WQM
Update Price
Total Commission LOCAL 0 Real Marketplace Commission LOCAL
Total Commission USD 0 Real Marketplace Commission USD
FOB 34.69 Estimated Price FOB
SHIPPING 12.33 Estimated International Shipping
COMM 3.72 Estimated International Commission
IVA 0 Estimated TAX
SHIPPING2 56.43 FOB+SHIPPING+COMM+IVA
CSCOMM 9.4 Estimated Marketplace Commission
CURR 4126.05 Currency Rate
TOTAL 232826.47 Estimated Total Local
3 B074D63G61  1 237.78 (Rate: 3.79) Amazon 0 237.47 900.00 CO 328061 CO 86559.63 86559.63 45 Incorrect R0: ([Price Site Local] < [Price Marketplace]) Profit: -86322.16 out of stock Help!
328061 CO
900.00 CO
Price Local
86559.63 86559.63
237.78 (Rate: 3.79)
Price USD
Qty: 1
B074D63G61
Amazon
Idx: 3
FOB: 45
Incorrect R0: ([Price Site Local] < [Price Marketplace]) Profit: -86322.16 out of stock Help!
Amazon - Ofertas de Cyber Monday 30 de noviembre
All SKU's
Quantity 1
View Sheet Product B074D63G61
Price FOB USD: B074D63G61
Update Price
Total Commission LOCAL 0 Real Marketplace Commission LOCAL
Total Commission USD 0 Real Marketplace Commission USD
FOB 53.93 Estimated Price FOB
SHIPPING 12.33 Estimated International Shipping
COMM 5.78 Estimated International Commission
IVA 0 Estimated TAX
SHIPPING2 79.51 FOB+SHIPPING+COMM+IVA
CSCOMM 13.25 Estimated Marketplace Commission
CURR 4126.05 Currency Rate
TOTAL 328060.59 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
4938 258143732 512988 2021-06-25 114-6486418-1927451 82.92 0.00 0.00 82.92 3004 2021-06-25 07:40:01 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-6486418-1927451 82.92 2021-06-25 00:00:00 0000-00-00


Form

Form



Shipping
id 10988
order_cbt 258143732
order_gsx 512988
type S
city Sincelejo, Sucre, Sucre
company --
country Colombia
country_iso_code --
firstname Olga Carolina
lastname Prins Niño
phone_secondary --
state --
street_1 Calle 25 #27-179
street_2 Las peñitas, Sucre
zip_code --
type_doc NationalRegistrationNumber
id_doc 1052948215


Billing
id 10987
order_cbt 258143732
order_gsx 512988
type B
city Sucre
company --
country Colombia
country_iso_code --
firstname Olga Carolina
lastname Prins Niño
phone_secondary --
state --
street_1 Calle 25 #27-179
street_2 --
zip_code 70001
type_doc NationalRegistrationNumber
id_doc 1052948215


Quote
id 1834266
order_cbt 258143732
order_gsx 512988
idx 0
website_id LINIO-CO
sku B06X9SCLBQ
sku_supplier
sku_seller
package_weight 0.4500
fob 19.9900
local_shipping 0.0000
local_tax 0.0000
cif 19.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 3.8300
marketplace_fixed_fee 0.0000
currency_rate 3.7900
price_seller 173.5100
quantity 2
invoice_fob 19.9900
invoice_tax 0.0000
invoice_shipping 217.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 192.0000
created_at 2021-06-25 07:14:03