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-10-10 15:40:02
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 298333 CO 78.82 78.82 39.99 Incorrect R0: ([Price Site Local] < [Price Marketplace]) Profit: -78.58 out of stock Help!
298333 CO
900.00 CO
Price Local
78.82 78.82
0.24 (Rate: 3785.00)
Price USD
Qty: 1
B07GDVR8VF
Amazon
Idx: 0
FOB: 39.99
Incorrect R0: ([Price Site Local] < [Price Marketplace]) Profit: -78.58 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 47.92 Estimated Price FOB
SHIPPING 12.33 Estimated International Shipping
COMM 5.13 Estimated International Commission
IVA 0 Estimated TAX
SHIPPING2 72.3 FOB+SHIPPING+COMM+IVA
CSCOMM 12.05 Estimated Marketplace Commission
CURR 4126.05 Currency Rate
TOTAL 298333.31 Estimated Total Local
1 B08222MCRN  1 0.24 (Rate: 3785.00) Amazon 0 0.24 900.00 CO 117952 CO 31.16 31.16 9.59 Incorrect R0: ([Price Site Local] < [Price Marketplace]) Profit: -30.92 out of stock Help!
117952 CO
900.00 CO
Price Local
31.16 31.16
0.24 (Rate: 3785.00)
Price USD
Qty: 1
B08222MCRN
Amazon
Idx: 1
FOB: 9.59
Incorrect R0: ([Price Site Local] < [Price Marketplace]) Profit: -30.92 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 11.49 Estimated Price FOB
SHIPPING 12.33 Estimated International Shipping
COMM 1.23 Estimated International Commission
IVA 0 Estimated TAX
SHIPPING2 28.59 FOB+SHIPPING+COMM+IVA
CSCOMM 4.76 Estimated Marketplace Commission
CURR 4126.05 Currency Rate
TOTAL 117952.16 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 648830 CO 171.42 171.42 99.06 Incorrect R0: ([Price Site Local] < [Price Marketplace]) Profit: -171.18 out of stock Help!
648830 CO
900.00 CO
Price Local
171.42 171.42
0.24 (Rate: 3785.00)
Price USD
Qty: 1
B078JLZ3X9
Amazon
Idx: 3
FOB: 99.06
Incorrect R0: ([Price Site Local] < [Price Marketplace]) Profit: -171.18 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 118.71 Estimated Price FOB
SHIPPING 12.33 Estimated International Shipping
COMM 12.72 Estimated International Commission
IVA 0 Estimated TAX
SHIPPING2 157.25 FOB+SHIPPING+COMM+IVA
CSCOMM 26.21 Estimated Marketplace Commission
CURR 4126.05 Currency Rate
TOTAL 648830.44 Estimated Total Local
4 B084Z2RGKB  1 0.24 (Rate: 3785.00) Amazon 0 0.24 900.00 CO 256798 CO 67.85 67.85 32.99 Incorrect R0: ([Price Site Local] < [Price Marketplace]) Profit: -67.61 out of stock Help!
256798 CO
900.00 CO
Price Local
67.85 67.85
0.24 (Rate: 3785.00)
Price USD
Qty: 1
B084Z2RGKB
Amazon
Idx: 4
FOB: 32.99
Incorrect R0: ([Price Site Local] < [Price Marketplace]) Profit: -67.61 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 39.54 Estimated Price FOB
SHIPPING 12.33 Estimated International Shipping
COMM 4.24 Estimated International Commission
IVA 0 Estimated TAX
SHIPPING2 62.24 FOB+SHIPPING+COMM+IVA
CSCOMM 10.37 Estimated Marketplace Commission
CURR 4126.05 Currency Rate
TOTAL 256798.17 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