Dashboard Control panel

  1. Home
  2. Dashboard

Order View (271423732 - 513039 - LINIOCO - canceled)

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



Info
id 21801
id_cbt
order_cbt 271423732
order_gsx 513039
date_cbt 2021-06-25 06:32:20
invoice_amount 1.44
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 16:55:48
is_loaded_to_purchase_system 0
order_amazon
amazon_amount 0
amazon_date 0000-00-00 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 0
flag_del 0
status_cbt canceled
payment_status_cbt
mercadolibre_fee 0
currency_rate 0
free_shipping_cost 0
SKU /B07GDVR8VF/B08222MCRN/B0858XTDJ9/B078JLZ3X9/B084Z2RGKB/B07JN9C548
calculated_sale_price 0
price_amz 0
ship_MX 0
base_price_amz 0
qty_product 6
currency_code USD
cs_site_id LINIOCO
qty_items 6
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 5450.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 8143370
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 3785.00
reason_cancellation price_difference
type_of_purchase unknown
status_oms Cancelled
commentary_cancellation
cancellation_date 2021-06-25 19:59:59
robot_date 0000-00-00 00:00:00
merchant
amazon_order_status
cs_site_id_2
CorporateName
CorporateDocument
FlagIsCorporate
log_date 2025-11-24 14:15:39
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
5977 271423732 513039 0 B07GDVR8VF 
1 0.24 USD 900.00 CO 3785.00 0.00 LINIOCO 2021-06-25 16:55:43
5978 271423732 513039 1 B08222MCRN 
1 0.24 USD 900.00 CO 3785.00 0.00 LINIOCO 2021-06-25 16:55:44
5979 271423732 513039 2 B0858XTDJ9 
1 0.24 USD 900.00 CO 3785.00 0.00 LINIOCO 2021-06-25 16:55:45
5980 271423732 513039 3 B078JLZ3X9 
1 0.24 USD 900.00 CO 3785.00 0.00 LINIOCO 2021-06-25 16:55:46
5981 271423732 513039 4 B084Z2RGKB 
1 0.24 USD 900.00 CO 3785.00 0.00 LINIOCO 2021-06-25 16:55:47
5982 271423732 513039 5 B07JN9C548 
1 0.24 USD 900.00 CO 3785.00 0.00 LINIOCO 2021-06-25 16:55:48
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 B07GDVR8VF  1 0.24 (Rate: 3785.00) Amazon 0 0.24 900.00 CO 268665 CO 70.98 70.98 34.99 Incorrect R0: ([Price Site Local] < [Price Marketplace]) Profit: -70.74 out of stock Help!
268665 CO
900.00 CO
Price Local
70.98 70.98
0.24 (Rate: 3785.00)
Price USD
Qty: 1
B07GDVR8VF
Amazon
Idx: 0
FOB: 34.99
Incorrect R0: ([Price Site Local] < [Price Marketplace]) Profit: -70.74 out of stock Help!
Amazon - Ofertas de Cyber Monday 30 de noviembre
All SKU's
Quantity 1
View Sheet Product B07GDVR8VF
Price FOB USD: B07GDVR8VF
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 B08222MCRN  1 0.24 (Rate: 3785.00) Amazon 0 0.24 900.00 CO 132193 CO 34.93 34.93 11.99 Incorrect R0: ([Price Site Local] < [Price Marketplace]) Profit: -34.69 out of stock Help!
132193 CO
900.00 CO
Price Local
34.93 34.93
0.24 (Rate: 3785.00)
Price USD
Qty: 1
B08222MCRN
Amazon
Idx: 1
FOB: 11.99
Incorrect R0: ([Price Site Local] < [Price Marketplace]) Profit: -34.69 out of stock Help!
Amazon - Ofertas de Cyber Monday 30 de noviembre
All SKU's
Quantity 1
View Sheet Product B08222MCRN
Price FOB USD: B08222MCRN
Update Price
Total Commission LOCAL 0 Real Marketplace Commission LOCAL
Total Commission USD 0 Real Marketplace Commission USD
FOB 14.37 Estimated Price FOB
SHIPPING 12.33 Estimated International Shipping
COMM 1.54 Estimated International Commission
IVA 0 Estimated TAX
SHIPPING2 32.04 FOB+SHIPPING+COMM+IVA
CSCOMM 5.34 Estimated Marketplace Commission
CURR 4126.05 Currency Rate
TOTAL 132192.78 Estimated Total Local
2 B0858XTDJ9  1 0.24 (Rate: 3785.00) Amazon 0 0.24 900.00 CO 129205 CO 34.14 34.14 10.99 Incorrect R0: ([Price Site Local] < [Price Marketplace]) Profit: -33.9 out of stock Help!
129205 CO
900.00 CO
Price Local
34.14 34.14
0.24 (Rate: 3785.00)
Price USD
Qty: 1
B0858XTDJ9
Amazon
Idx: 2
FOB: 10.99
Incorrect R0: ([Price Site Local] < [Price Marketplace]) Profit: -33.9 out of stock Help!
Amazon - Ofertas de Cyber Monday 30 de noviembre
All SKU's
Quantity 1
View Sheet Product B0858XTDJ9
Price FOB USD: B0858XTDJ9
Update Price
Total Commission LOCAL 0 Real Marketplace Commission LOCAL
Total Commission USD 0 Real Marketplace Commission USD
FOB 13.17 Estimated Price FOB
SHIPPING 12.93 Estimated International Shipping
COMM 1.41 Estimated International Commission
IVA 0 Estimated TAX
SHIPPING2 31.31 FOB+SHIPPING+COMM+IVA
CSCOMM 5.22 Estimated Marketplace Commission
CURR 4126.05 Currency Rate
TOTAL 129205.19 Estimated Total Local
3 B078JLZ3X9  1 0.24 (Rate: 3785.00) Amazon 0 0.24 900.00 CO 630614 CO 166.61 166.61 95.99 Incorrect R0: ([Price Site Local] < [Price Marketplace]) Profit: -166.37 out of stock Help!
630614 CO
900.00 CO
Price Local
166.61 166.61
0.24 (Rate: 3785.00)
Price USD
Qty: 1
B078JLZ3X9
Amazon
Idx: 3
FOB: 95.99
Incorrect R0: ([Price Site Local] < [Price Marketplace]) Profit: -166.37 out of stock Help!
Amazon - Ofertas de Cyber Monday 30 de noviembre
All SKU's
Quantity 1
View Sheet Product B078JLZ3X9
Price FOB USD: B078JLZ3X9
Update Price
Total Commission LOCAL 0 Real Marketplace Commission LOCAL
Total Commission USD 0 Real Marketplace Commission USD
FOB 115.03 Estimated Price FOB
SHIPPING 12.33 Estimated International Shipping
COMM 12.33 Estimated International Commission
IVA 0 Estimated TAX
SHIPPING2 152.84 FOB+SHIPPING+COMM+IVA
CSCOMM 25.47 Estimated Marketplace Commission
CURR 4126.05 Currency Rate
TOTAL 630614.31 Estimated Total Local
4 B084Z2RGKB  1 0.24 (Rate: 3785.00) Amazon 0 0.24 900.00 CO 209270 CO 55.29 55.29 24.98 Incorrect R0: ([Price Site Local] < [Price Marketplace]) Profit: -55.05 out of stock Help!
209270 CO
900.00 CO
Price Local
55.29 55.29
0.24 (Rate: 3785.00)
Price USD
Qty: 1
B084Z2RGKB
Amazon
Idx: 4
FOB: 24.98
Incorrect R0: ([Price Site Local] < [Price Marketplace]) Profit: -55.05 out of stock Help!
Amazon - Ofertas de Cyber Monday 30 de noviembre
All SKU's
Quantity 1
View Sheet Product B084Z2RGKB
Price FOB USD: B084Z2RGKB
Update Price
Total Commission LOCAL 0 Real Marketplace Commission LOCAL
Total Commission USD 0 Real Marketplace Commission USD
FOB 29.94 Estimated Price FOB
SHIPPING 12.33 Estimated International Shipping
COMM 3.21 Estimated International Commission
IVA 0 Estimated TAX
SHIPPING2 50.72 FOB+SHIPPING+COMM+IVA
CSCOMM 8.45 Estimated Marketplace Commission
CURR 4126.05 Currency Rate
TOTAL 209270.11 Estimated Total Local
5 B07JN9C548  1 0.24 (Rate: 3785.00) Amazon 0 0.24 900.00 CO 224223 CO 59.24 59.24 27.5 Incorrect R0: ([Price Site Local] < [Price Marketplace]) Profit: -59 out of stock Help!
224223 CO
900.00 CO
Price Local
59.24 59.24
0.24 (Rate: 3785.00)
Price USD
Qty: 1
B07JN9C548
Amazon
Idx: 5
FOB: 27.5
Incorrect R0: ([Price Site Local] < [Price Marketplace]) Profit: -59 out of stock Help!
Amazon - Ofertas de Cyber Monday 30 de noviembre
All SKU's
Quantity 1
View Sheet Product B07JN9C548
Price FOB USD: B07JN9C548
Update Price
Total Commission LOCAL 0 Real Marketplace Commission LOCAL
Total Commission USD 0 Real Marketplace Commission USD
FOB 32.96 Estimated Price FOB
SHIPPING 12.33 Estimated International Shipping
COMM 3.53 Estimated International Commission
IVA 0 Estimated TAX
SHIPPING2 54.34 FOB+SHIPPING+COMM+IVA
CSCOMM 9.06 Estimated Marketplace Commission
CURR 4126.05 Currency Rate
TOTAL 224222.77 Estimated Total Local

Form



PO NUMBER
order_amazon amazon_amount amazon_date amazon_status amazon_carrier amazon_tracking_id amazon_delivered_date amazon_order_status
0 0000-00-00 00:00:00 0000-00-00


Form

Form



Shipping
id 11046
order_cbt 271423732
order_gsx 513039
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 11045
order_cbt 271423732
order_gsx 513039
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 1834770
order_cbt 271423732
order_gsx 513039
idx 0
website_id LINIO-CO
sku B07GDVR8VF
sku_supplier
sku_seller
package_weight 0.2300
fob 34.9900
local_shipping 0.0000
local_tax 0.0000
cif 34.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 6.7100
marketplace_fixed_fee 0.0000
currency_rate 3785.0000
price_seller 252204.9200
quantity 2
invoice_fob 34.9900
invoice_tax 0.0000
invoice_shipping -34.7500
invoice_total 0.2400
invoice_qty 1
invoice_price 0.2400
invoice_currency_code USD
invoice_price_site 900.0000
invoice_currency_code_site CO
invoice_change_rate 3785.0000
invoice_total_commission 0.0000
adjust_discount_value -66.3900
created_at 2021-06-25 16:55:43