Dashboard Control panel

  1. Home
  2. Dashboard

Order View (287143732 - 512990 - LINIOCO - canceled)

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



Info
id 21774
id_cbt
order_cbt 287143732
order_gsx 512990
date_cbt 2021-06-25 02:08:18
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:20
is_loaded_to_purchase_system 1
order_amazon /111-4408683-0577814
amazon_amount 92.43
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 /B07V34728C/B07NPS6S41/B07GSD86QH/B06XWVD5NT
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 2021-06-29 13:00:42
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 8143141
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:55:03
robot_date 0000-00-00 00:00:00
merchant
amazon_order_status
cs_site_id_2
CorporateName
CorporateDocument
FlagIsCorporate
log_date 2025-11-26 01:46:51
flag_events_blocked 0
status_cancellation Finance 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
5739 287143732 512990 0 B07V34728C 
1 237.78 USD 900.00 CO 3.79 0.00 LINIOCO 2021-06-25 07:14:18
5740 287143732 512990 1 B07NPS6S41 
1 237.78 USD 900.00 CO 3.79 0.00 LINIOCO 2021-06-25 07:14:18
5741 287143732 512990 2 B07GSD86QH 
1 237.78 USD 900.00 CO 3.79 0.00 LINIOCO 2021-06-25 07:14:19
5742 287143732 512990 3 B06XWVD5NT 
1 237.78 USD 900.00 CO 3.79 0.00 LINIOCO 2021-06-25 07:14:20
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 B07V34728C  1 237.78 (Rate: 3.79) Amazon 0 237.47 900.00 CO 221197 CO 58363.32 58363.32 26.99 Incorrect R0: ([Price Site Local] < [Price Marketplace]) Profit: -58125.85 out of stock Help!
221197 CO
900.00 CO
Price Local
58363.32 58363.32
237.78 (Rate: 3.79)
Price USD
Qty: 1
B07V34728C
Amazon
Idx: 0
FOB: 26.99
Incorrect R0: ([Price Site Local] < [Price Marketplace]) Profit: -58125.85 out of stock Help!
Amazon - Ofertas de Cyber Monday 30 de noviembre
All SKU's
Quantity 1
View Sheet Product B07V34728C
Price FOB USD: B07V34728C
Update Price
Total Commission LOCAL 0 Real Marketplace Commission LOCAL
Total Commission USD 0 Real Marketplace Commission USD
FOB 32.34 Estimated Price FOB
SHIPPING 12.33 Estimated International Shipping
COMM 3.47 Estimated International Commission
IVA 0 Estimated TAX
SHIPPING2 53.61 FOB+SHIPPING+COMM+IVA
CSCOMM 8.93 Estimated Marketplace Commission
CURR 4126.05 Currency Rate
TOTAL 221196.63 Estimated Total Local
1 B07NPS6S41  1 237.78 (Rate: 3.79) Amazon 0 237.47 900.00 CO 209329 CO 55231.93 55231.93 24.99 Incorrect R0: ([Price Site Local] < [Price Marketplace]) Profit: -54994.46 out of stock Help!
209329 CO
900.00 CO
Price Local
55231.93 55231.93
237.78 (Rate: 3.79)
Price USD
Qty: 1
B07NPS6S41
Amazon
Idx: 1
FOB: 24.99
Incorrect R0: ([Price Site Local] < [Price Marketplace]) Profit: -54994.46 out of stock Help!
Amazon - Ofertas de Cyber Monday 30 de noviembre
All SKU's
Quantity 1
View Sheet Product B07NPS6S41
Price FOB USD: B07NPS6S41
Update Price
Total Commission LOCAL 0 Real Marketplace Commission LOCAL
Total Commission USD 0 Real Marketplace Commission USD
FOB 29.95 Estimated Price FOB
SHIPPING 12.33 Estimated International Shipping
COMM 3.21 Estimated International Commission
IVA 0 Estimated TAX
SHIPPING2 50.73 FOB+SHIPPING+COMM+IVA
CSCOMM 8.46 Estimated Marketplace Commission
CURR 4126.05 Currency Rate
TOTAL 209329.45 Estimated Total Local
2 B07GSD86QH  1 237.78 (Rate: 3.79) Amazon 0 237.47 900.00 CO 227130 CO 59928.76 59928.76 27.99 Incorrect R0: ([Price Site Local] < [Price Marketplace]) Profit: -59691.29 out of stock Help!
227130 CO
900.00 CO
Price Local
59928.76 59928.76
237.78 (Rate: 3.79)
Price USD
Qty: 1
B07GSD86QH
Amazon
Idx: 2
FOB: 27.99
Incorrect R0: ([Price Site Local] < [Price Marketplace]) Profit: -59691.29 out of stock Help!
Amazon - Ofertas de Cyber Monday 30 de noviembre
All SKU's
Quantity 1
View Sheet Product B07GSD86QH
Price FOB USD: B07GSD86QH
Update Price
Total Commission LOCAL 0 Real Marketplace Commission LOCAL
Total Commission USD 0 Real Marketplace Commission USD
FOB 33.54 Estimated Price FOB
SHIPPING 12.33 Estimated International Shipping
COMM 3.59 Estimated International Commission
IVA 0 Estimated TAX
SHIPPING2 55.05 FOB+SHIPPING+COMM+IVA
CSCOMM 9.17 Estimated Marketplace Commission
CURR 4126.05 Currency Rate
TOTAL 227130.22 Estimated Total Local
3 B06XWVD5NT  1 237.78 (Rate: 3.79) Amazon 0 237.47 900.00 CO 173728 CO 45838.52 45838.52 18.99 Incorrect R0: ([Price Site Local] < [Price Marketplace]) Profit: -45601.05 out of stock Help!
173728 CO
900.00 CO
Price Local
45838.52 45838.52
237.78 (Rate: 3.79)
Price USD
Qty: 1
B06XWVD5NT
Amazon
Idx: 3
FOB: 18.99
Incorrect R0: ([Price Site Local] < [Price Marketplace]) Profit: -45601.05 out of stock Help!
Amazon - Ofertas de Cyber Monday 30 de noviembre
All SKU's
Quantity 1
View Sheet Product B06XWVD5NT
Price FOB USD: B06XWVD5NT
Update Price
Total Commission LOCAL 0 Real Marketplace Commission LOCAL
Total Commission USD 0 Real Marketplace Commission USD
FOB 22.76 Estimated Price FOB
SHIPPING 12.33 Estimated International Shipping
COMM 2.44 Estimated International Commission
IVA 0 Estimated TAX
SHIPPING2 42.11 FOB+SHIPPING+COMM+IVA
CSCOMM 7.02 Estimated Marketplace Commission
CURR 4126.05 Currency Rate
TOTAL 173727.91 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
4939 287143732 512990 2021-06-25 111-4408683-0577814 90.54 0.00 1.89 92.43 3004 2021-06-25 08:25:05 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
/111-4408683-0577814 92.43 2021-06-25 00:00:00 0000-00-00


Form

Form



Shipping
id 10992
order_cbt 287143732
order_gsx 512990
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 10991
order_cbt 287143732
order_gsx 512990
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 1834276
order_cbt 287143732
order_gsx 512990
idx 0
website_id LINIO-CO
sku B07V34728C
sku_supplier
sku_seller
package_weight 0.3900
fob 26.9900
local_shipping 0.0000
local_tax 0.0000
cif 26.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 5.1800
marketplace_fixed_fee 0.0000
currency_rate 3.7900
price_seller 210.3900
quantity 2
invoice_fob 26.9900
invoice_tax 0.0000
invoice_shipping 210.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 182.2700
created_at 2021-06-25 07:14:17