Dashboard Control panel

  1. Home
  2. Dashboard

Order View (275738332 - 491888 - LINIOMX - delivered)

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



Info
id 17945
id_cbt
order_cbt 275738332
order_gsx 491888
date_cbt 2020-11-01 12:25:08
invoice_amount 251.7
buyer_first_name Miguel Angel
buyer_last_name Gomez Flores
buyer_company --
buyer_address_line_1 Amsterdam 231, Int 501
buyer_address_line_2 Hipódromo Condesa, Cuauhtémoc
buyer_city Distrito Federal, Ciudad De México, Cuauhtémoc
buyer_state --
buyer_zip_code 06170
buyer_country Mexico
buyer_email
buyer_phone --
buyer_shipment_label_location
buyer_mercardolibre_site MX
buyer_mercardolibre_site_order_id
created_system 2020-11-01 22:27:25
is_loaded_to_purchase_system 0
order_amazon /112-9534891-7635444
amazon_amount 97.98
amazon_date 2020-11-02 00:00:00
status 8
observation
shipment_status
international_tracking_id 9349878580
easypost_warehouse_date 2020-11-04 12:58:27
easypost_carrier_date 2020-11-04 16:01:18
easypost_delivered_date 2020-11-06 14:11:11
easypost_observation dhl - Delivered - Signed for by
easypost_status delivered
amazon_status Delivered
amazon_carrier Shipped with UPS
amazon_tracking_id Tracking ID: 1Z065R0Y0310061898
amazon_delivered_date 2020-11-04
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 /B01K2UP6JW/B01K2UP6JW
calculated_sale_price 0
price_amz 0
ship_MX 0
base_price_amz 0
qty_product 2
currency_code USD
cs_site_id LINIOMX
qty_items 2
order_esx
NationalRegistrationNumber
globalshopex_warehouse_date 2020-11-04 10:58:36
globalshopex_carrier_date 2020-11-04 12:53:09
invoice_amount_local 6232.00
easypost_carrier dhl
shipping_street_1 Amsterdam 231, Int 501
shipping_city Distrito Federal, Ciudad De México, Cuauhtémoc
shipping_country Mexico
shipping_phone_1 --
shipping_phone_2 --
acceptance_decision_date 0000-00-00 00:00:00
order_cbt_id 7173010
esx_masterid
esx_barcode
international_tracking_url http://www.dhl-usa.com/en/express/tracking.html?AWB=9349878580&brand=DHL
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 24.76
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
1720 275738332 491888 0 B01K2UP6JW 
1 125.85 USD 3116.00 MX 24.76 0.00 LINIOMX 2020-11-01 22:27:25
1721 275738332 491888 1 B01K2UP6JW 
1 125.85 USD 3116.00 MX 24.76 0.00 LINIOMX 2020-11-01 22:27:25
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 B01K2UP6JW  1 125.85 (Rate: 24.76) Amazon 0 125.85 3116.00 MX 2844 MX 114.86 114.86 79.99 Correct R7: ([Price Site Local] >= [Price Marketplace]) Profit: 10.99 out of stock Help!
2844 MX
3116.00 MX
Price Local
114.86 114.86
125.85 (Rate: 24.76)
Price USD
Qty: 1
B01K2UP6JW
Amazon
Idx: 0
FOB: 79.99
Correct R7: ([Price Site Local] >= [Price Marketplace]) Profit: 10.99 out of stock Help!
Amazon - Ofertas de Cyber Monday 30 de noviembre
All SKU's
Quantity 1
View Sheet Product B01K2UP6JW
Price FOB USD: B01K2UP6JW
Update Price
Total Commission LOCAL 0 Real Marketplace Commission LOCAL
Total Commission USD 0 Real Marketplace Commission USD
FOB 95.86 Estimated Price FOB
SHIPPING 11 Estimated International Shipping
COMM 10.27 Estimated International Commission
IVA 21.16 Estimated TAX
SHIPPING2 156.18 FOB+SHIPPING+COMM+IVA
CSCOMM 28.16 Estimated Marketplace Commission
CURR 18.21 Currency Rate
TOTAL 2844.08 Estimated Total Local
1 B01K2UP6JW  1 125.85 (Rate: 24.76) Amazon 0 125.85 3116.00 MX 2844 MX 114.86 114.86 79.99 Correct R7: ([Price Site Local] >= [Price Marketplace]) Profit: 10.99 out of stock Help!
2844 MX
3116.00 MX
Price Local
114.86 114.86
125.85 (Rate: 24.76)
Price USD
Qty: 1
B01K2UP6JW
Amazon
Idx: 1
FOB: 79.99
Correct R7: ([Price Site Local] >= [Price Marketplace]) Profit: 10.99 out of stock Help!
Amazon - Ofertas de Cyber Monday 30 de noviembre
All SKU's
Quantity 1
View Sheet Product B01K2UP6JW
Price FOB USD: B01K2UP6JW
Update Price
Total Commission LOCAL 0 Real Marketplace Commission LOCAL
Total Commission USD 0 Real Marketplace Commission USD
FOB 95.86 Estimated Price FOB
SHIPPING 11 Estimated International Shipping
COMM 10.27 Estimated International Commission
IVA 21.16 Estimated TAX
SHIPPING2 156.18 FOB+SHIPPING+COMM+IVA
CSCOMM 28.16 Estimated Marketplace Commission
CURR 18.21 Currency Rate
TOTAL 2844.08 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
1227 275738332 491888 2020-11-02 112-9534891-7635444 97.98 0.00 0.00 97.98 1028 2020-11-02 14:52:19 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
/112-9534891-7635444 97.98 2020-11-02 00:00:00 Delivered Shipped with UPS Tracking ID: 1Z065R0Y0310061898 2020-11-04


Details
order_cbt order_gsx po_number amazon_status amazon_carrier amazon_tracking_id amazon_delivered_date amazon_order_status
275738332 491888 112-9534891-7635444 Delivered Shipped with UPS Tracking ID: 1Z065R0Y0310061898 2020-11-04

Form

Details
order_cbt order_gsx po_number amazon_status amazon_carrier amazon_tracking_id amazon_delivered_date amazon_order_status
275738332 491888 112-9534891-7635444 Delivered Shipped with UPS Tracking ID: 1Z065R0Y0310061898 2020-11-04

Form

Details
id order_cbt order_gsx po_number carrier tracking created_system observation
2101 275738332 491888 491888 dhl 9349878580 2020-11-06 21:50:47


Shipping
id 3334
order_cbt 275738332
order_gsx 491888
type S
city Distrito Federal, Ciudad De México, Cuauhtémoc
company --
country Mexico
country_iso_code --
firstname Miguel Angel
lastname Gomez Flores
phone_secondary --
state --
street_1 Amsterdam 231, Int 501
street_2 Hipódromo Condesa, Cuauhtémoc
zip_code 06170
type_doc NationalRegistrationNumber
id_doc


Billing
id 3333
order_cbt 275738332
order_gsx 491888
type B
city -
company --
country -
country_iso_code --
firstname -
lastname -
phone_secondary --
state --
street_1 -
street_2 -
zip_code -
type_doc NationalRegistrationNumber
id_doc


Quote
id 1821633
order_cbt 275738332
order_gsx 491888
idx 0
website_id LINIO-MX
sku B01K2UP6JW
sku_supplier
sku_seller
package_weight 0.3200
fob 69.9900
local_shipping 0.0000
local_tax 0.0000
cif 69.9900
international_shipping 15.3000
international_commission 0.0000
tax 15.5600
duties 0.0000
fee 0.0000
handling 0.0000
marketplace_shipping 0.00
marketplace_commission 12.2800
marketplace_fixed_fee 0.8000
currency_rate 24.7600
price_seller 3115.5600
quantity 2
invoice_fob 69.9900
invoice_tax 15.5600
invoice_shipping 40.3000
invoice_total 125.8500
invoice_qty 1
invoice_price 125.8500
invoice_currency_code USD
invoice_price_site 3116.0000
invoice_currency_code_site MX
invoice_change_rate 24.7600
invoice_total_commission 0.0000
adjust_discount_value 0.0200
created_at 2020-11-01 22:27:25