Dashboard Control panel

  1. Home
  2. Dashboard

Order View (209953395 - 485946 - LINIOCL - delivered)

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



Info
id 16845
id_cbt
order_cbt 209953395
order_gsx 485946
date_cbt 2020-08-08 16:29:25
invoice_amount 78.97
buyer_first_name Rodrigo Alexis
buyer_last_name Maulén Martínez
buyer_company --
buyer_address_line_1 Av. Libertador Bernardo Ohiggins 777
buyer_address_line_2 TALAGANTE
buyer_city Metropolitana, Talagante
buyer_state --
buyer_zip_code 0013601
buyer_country Chile
buyer_email
buyer_phone --
buyer_shipment_label_location
buyer_mercardolibre_site CL
buyer_mercardolibre_site_order_id
created_system 2020-08-09 06:39:05
is_loaded_to_purchase_system 0
order_amazon /111-0366263-5700223
amazon_amount 32.93
amazon_date 2020-08-09 00:00:00
status 8
observation
shipment_status
international_tracking_id 4878158180
easypost_warehouse_date 0000-00-00 00:00:00
easypost_carrier_date 0000-00-00 00:00:00
easypost_delivered_date 2020-08-26 19:12:08
easypost_observation DHL - delivered
easypost_status tracking_code_created
amazon_status Delivered
amazon_carrier
amazon_tracking_id
amazon_delivered_date 0000-00-00
merchant_id 2458890
flag_shp 1
flag_del 0
status_cbt delivered
payment_status_cbt
mercadolibre_fee 0
currency_rate 0
free_shipping_cost 0
SKU B01N33LIXR
calculated_sale_price 0
price_amz 0
ship_MX 0
base_price_amz 0
qty_product 1
currency_code USD
cs_site_id LINIOCL
qty_items 1
order_esx
NationalRegistrationNumber 13.339.453-2
globalshopex_warehouse_date 2020-08-10 13:17:43
globalshopex_carrier_date 2020-08-12 15:25:15
invoice_amount_local 0.00
easypost_carrier dhl
shipping_street_1 Av. Libertador Bernardo Ohiggins 777
shipping_city Metropolitana, Talagante
shipping_country Chile
shipping_phone_1 --
shipping_phone_2
acceptance_decision_date 0000-00-00 00:00:00
order_cbt_id 3137267
esx_masterid
esx_barcode
international_tracking_url http://www.dhl-usa.com/en/express/tracking.html?AWB=4878158180&brand=DHL
shipping_street_2 TALAGANTE
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 810.00
reason_cancellation
type_of_purchase unknown
status_oms
commentary_cancellation
cancellation_date 0000-00-00 00:00:00
robot_date 0000-00-00 00:00:00
merchant
amazon_order_status
cs_site_id_2
CorporateName
CorporateDocument
FlagIsCorporate
log_date 2023-04-05 05:00:00
flag_events_blocked 0
status_cancellation
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
618 209953395 485946 0 B01N33LIXR 
1 78.97 USD 63967.00 CL 810.00 0.00 LINIOCL 2020-08-09 06:39:05
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 B01N33LIXR  1 78.97 (Rate: 810.00) Amazon 0 78.97 63967.00 CL 129286 CL 159.61 124.14 61.35 Incorrect R0: ([Price Site Local] < [Price Marketplace]) Profit: -45.17 out of stock Help!
129286 CL
63967.00 CL
Price Local
159.61 124.14
78.97 (Rate: 810.00)
Price USD
Qty: 1
B01N33LIXR
Amazon
Idx: 0
FOB: 61.35
Incorrect R0: ([Price Site Local] < [Price Marketplace]) Profit: -45.17 out of stock Help!
Amazon - Ofertas de Cyber Monday 30 de noviembre
All SKU's
Quantity 1
View Sheet Product B01N33LIXR
Price FOB USD: B01N33LIXR
Update Price
Total Commission LOCAL 0 Real Marketplace Commission LOCAL
Total Commission USD 0 Real Marketplace Commission USD
FOB 77.46 Estimated Price FOB
SHIPPING 12 Estimated International Shipping
COMM 11.82 Estimated International Commission
IVA 23.84 Estimated TAX
SHIPPING2 135.96 FOB+SHIPPING+COMM+IVA
CSCOMM 22.66 Estimated Marketplace Commission
CURR 950.9 Currency Rate
TOTAL 129286.34 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
190 209953395 485946 2020-08-09 111-0366263-5700223 32.93 0.00 0.00 32.93 3005 2020-08-09 19:03:56 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-0366263-5700223 32.93 2020-08-09 00:00:00 Delivered 0000-00-00


Details
order_cbt order_gsx po_number amazon_status amazon_carrier amazon_tracking_id amazon_delivered_date amazon_order_status
209953395 485946 111-0366263-5700223 Delivered 0000-00-00

Form

Details
order_cbt order_gsx po_number amazon_status amazon_carrier amazon_tracking_id amazon_delivered_date amazon_order_status
209953395 485946 111-0366263-5700223 Delivered 0000-00-00

Form

Details
id order_cbt order_gsx po_number carrier tracking created_system observation
1422 209953395 485946 485946 dhl 4878158180 2020-09-21 22:39:14


Shipping
id 1134
order_cbt 209953395
order_gsx 485946
type S
city Metropolitana, Talagante
company --
country Chile
country_iso_code --
firstname Rodrigo Alexis
lastname Maulén Martínez
phone_secondary --
state --
street_1 Av. Libertador Bernardo Ohiggins 777
street_2 TALAGANTE
zip_code 0013601
type_doc NationalRegistrationNumber
id_doc 13.339.453-2


Billing
id 1133
order_cbt 209953395
order_gsx 485946
type B
city METROPOLITANA
company --
country Chile
country_iso_code --
firstname Rodrigo Alexis
lastname Maulén Martínez
phone_secondary --
state --
street_1 Av. Libertador Bernardo Ohiggins 777 777
street_2 --
zip_code --
type_doc NationalRegistrationNumber
id_doc 13.339.453-2