Dashboard Control panel

  1. Home
  2. Dashboard

Order View (1370220573793-01 - 561314 - DINERSPE - Cancelado)

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



Info
id 30364
id_cbt
order_cbt 1370220573793-01
order_gsx 561314
date_cbt 2023-10-20 01:39:16
invoice_amount 82.68
buyer_first_name Juan
buyer_last_name Carlos Cancharis Sandoval
buyer_company --
buyer_address_line_1 Avenida santa rosa 476 Ate
buyer_address_line_2 Reference: Al frente empresa Braedt Empresa TIGO, fachada verde, al frente empresa braedt - Address Number: 476
buyer_city Lima
buyer_state LIMA
buyer_zip_code 150103
buyer_country PERU
buyer_email jccolo@hotmail.com
buyer_phone +51944701079
buyer_shipment_label_location
buyer_mercardolibre_site PE
buyer_mercardolibre_site_order_id
created_system 2023-10-23 15:14:13
is_loaded_to_purchase_system 1
order_amazon
amazon_amount 0
amazon_date 0000-00-00 00:00:00
status 5
observation Products qty on page is not equal with the --> Qty on order 6 -->Qty on page = 0
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 Cancelado
payment_status_cbt
mercadolibre_fee 0
currency_rate 0
free_shipping_cost 0
SKU /B09BBFP1ZC/B09BBN7SZM/B07QZ32KQ7/B09BBD5PKM/B09BBG4BMX/B09SS729N8
calculated_sale_price 0
price_amz 0
ship_MX 0
base_price_amz 0
qty_product 6
currency_code USD
cs_site_id DINERSPE
qty_items 6
order_esx
NationalRegistrationNumber 41568847
globalshopex_warehouse_date 0000-00-00 00:00:00
globalshopex_carrier_date 0000-00-00 00:00:00
invoice_amount_local 320.00
easypost_carrier
shipping_street_1 Avenida santa rosa 476 Ate
shipping_city Lima
shipping_country PERU
shipping_phone_1 +51944701079
shipping_phone_2 +51944701079
acceptance_decision_date 0000-00-00 00:00:00
order_cbt_id 71e1081f-d6df-4d8a-a1d3-daaa9b5422c8
esx_masterid
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.87
reason_cancellation out_of_stock
type_of_purchase unknown
status_oms
commentary_cancellation SIN STOCK
cancellation_date 2023-11-21 16:52:40
robot_date 2023-10-23 15:17:53
merchant Amazon,
amazon_order_status
cs_site_id_2 --
CorporateName --
CorporateDocument --
FlagIsCorporate
log_date 2025-10-10 04:11: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
15023 1370220573793-01 561314 0 B09BBFP1ZC 
1 13.78 USD 53.34 PE 3.87 0.00 DINERSPE 2023-10-23 15:14:13
15024 1370220573793-01 561314 1 B09BBN7SZM 
1 13.78 USD 53.33 PE 3.87 0.00 DINERSPE 2023-10-23 15:14:13
15025 1370220573793-01 561314 2 B07QZ32KQ7 
1 13.78 USD 53.34 PE 3.87 0.00 DINERSPE 2023-10-23 15:14:13
15026 1370220573793-01 561314 3 B09BBD5PKM 
1 13.78 USD 53.33 PE 3.87 0.00 DINERSPE 2023-10-23 15:14:13
15027 1370220573793-01 561314 4 B09BBG4BMX 
1 13.78 USD 53.33 PE 3.87 0.00 DINERSPE 2023-10-23 15:14:13
15028 1370220573793-01 561314 5 B09SS729N8 
1 13.78 USD 53.33 PE 3.87 0.00 DINERSPE 2023-10-23 15:14:13
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 B09BBFP1ZC  1 13.78 (Rate: 3.87) Amazon 0 13.78 53.34 PE 995 PE 257.11 243.97 165 Incorrect R0: ([Price Site Local] < [Price Marketplace]) Profit: -230.19 out of stock Help!
995 PE
53.34 PE
Price Local
257.11 243.97
13.78 (Rate: 3.87)
Price USD
Qty: 1
B09BBFP1ZC
Amazon
Idx: 0
FOB: 165
Incorrect R0: ([Price Site Local] < [Price Marketplace]) Profit: -230.19 out of stock Help!
Amazon - Ofertas de Cyber Monday 30 de noviembre
All SKU's
Quantity 1
View Sheet Product B09BBFP1ZC
Price FOB USD: B09BBFP1ZC
Update Price
Total Commission LOCAL 0.00 Real Marketplace Commission LOCAL
Total Commission USD 0 Real Marketplace Commission USD
FOB 176.55 Estimated Price FOB
SHIPPING 15.1 Estimated International Shipping
COMM 17.66 Estimated International Commission
IVA 0 Estimated TAX
SHIPPING2 209.3 FOB+SHIPPING+COMM+IVA
CSCOMM 52.33 Estimated Marketplace Commission
CURR 3.8 Currency Rate
TOTAL 995 Estimated Total Local
1 B09BBN7SZM  1 13.78 (Rate: 3.87) Amazon 0 13.78 53.33 PE 718 PE 185.53 176.41 115.48 Incorrect R0: ([Price Site Local] < [Price Marketplace]) Profit: -162.63 out of stock Help!
718 PE
53.33 PE
Price Local
185.53 176.41
13.78 (Rate: 3.87)
Price USD
Qty: 1
B09BBN7SZM
Amazon
Idx: 1
FOB: 115.48
Incorrect R0: ([Price Site Local] < [Price Marketplace]) Profit: -162.63 out of stock Help!
Amazon - Ofertas de Cyber Monday 30 de noviembre
All SKU's
Quantity 1
View Sheet Product B09BBN7SZM
Price FOB USD: B09BBN7SZM
Update Price
Total Commission LOCAL 0.00 Real Marketplace Commission LOCAL
Total Commission USD 0 Real Marketplace Commission USD
FOB 123.56 Estimated Price FOB
SHIPPING 15.1 Estimated International Shipping
COMM 12.36 Estimated International Commission
IVA 0 Estimated TAX
SHIPPING2 151.02 FOB+SHIPPING+COMM+IVA
CSCOMM 37.75 Estimated Marketplace Commission
CURR 3.8 Currency Rate
TOTAL 718 Estimated Total Local
2 B07QZ32KQ7  1 13.78 (Rate: 3.87) Amazon 0 13.78 53.34 PE 309 PE 79.84 76.47 43.71 Incorrect R0: ([Price Site Local] < [Price Marketplace]) Profit: -62.69 out of stock Help!
309 PE
53.34 PE
Price Local
79.84 76.47
13.78 (Rate: 3.87)
Price USD
Qty: 1
B07QZ32KQ7
Amazon
Idx: 2
FOB: 43.71
Incorrect R0: ([Price Site Local] < [Price Marketplace]) Profit: -62.69 out of stock Help!
Amazon - Ofertas de Cyber Monday 30 de noviembre
All SKU's
Quantity 1
View Sheet Product B07QZ32KQ7
Price FOB USD: B07QZ32KQ7
Update Price
Total Commission LOCAL 0.00 Real Marketplace Commission LOCAL
Total Commission USD 0 Real Marketplace Commission USD
FOB 46.77 Estimated Price FOB
SHIPPING 15.1 Estimated International Shipping
COMM 4.68 Estimated International Commission
IVA 0 Estimated TAX
SHIPPING2 66.54 FOB+SHIPPING+COMM+IVA
CSCOMM 14.61 Estimated Marketplace Commission
CURR 3.8 Currency Rate
TOTAL 309 Estimated Total Local
3 B09BBD5PKM  1 13.78 (Rate: 3.87) Amazon 0 13.78 53.33 PE 896 PE 231.52 219.92 147.37 Incorrect R0: ([Price Site Local] < [Price Marketplace]) Profit: -206.14 out of stock Help!
896 PE
53.33 PE
Price Local
231.52 219.92
13.78 (Rate: 3.87)
Price USD
Qty: 1
B09BBD5PKM
Amazon
Idx: 3
FOB: 147.37
Incorrect R0: ([Price Site Local] < [Price Marketplace]) Profit: -206.14 out of stock Help!
Amazon - Ofertas de Cyber Monday 30 de noviembre
All SKU's
Quantity 1
View Sheet Product B09BBD5PKM
Price FOB USD: B09BBD5PKM
Update Price
Total Commission LOCAL 0.00 Real Marketplace Commission LOCAL
Total Commission USD 0 Real Marketplace Commission USD
FOB 157.69 Estimated Price FOB
SHIPPING 15.1 Estimated International Shipping
COMM 15.77 Estimated International Commission
IVA 0 Estimated TAX
SHIPPING2 188.55 FOB+SHIPPING+COMM+IVA
CSCOMM 47.14 Estimated Marketplace Commission
CURR 3.8 Currency Rate
TOTAL 896 Estimated Total Local
4 B09BBG4BMX  1 13.78 (Rate: 3.87) Amazon 0 13.78 53.33 PE 818 PE 211.37 200.79 133.35 Incorrect R0: ([Price Site Local] < [Price Marketplace]) Profit: -187.01 out of stock Help!
818 PE
53.33 PE
Price Local
211.37 200.79
13.78 (Rate: 3.87)
Price USD
Qty: 1
B09BBG4BMX
Amazon
Idx: 4
FOB: 133.35
Incorrect R0: ([Price Site Local] < [Price Marketplace]) Profit: -187.01 out of stock Help!
Amazon - Ofertas de Cyber Monday 30 de noviembre
All SKU's
Quantity 1
View Sheet Product B09BBG4BMX
Price FOB USD: B09BBG4BMX
Update Price
Total Commission LOCAL 0.00 Real Marketplace Commission LOCAL
Total Commission USD 0 Real Marketplace Commission USD
FOB 142.68 Estimated Price FOB
SHIPPING 15.1 Estimated International Shipping
COMM 14.27 Estimated International Commission
IVA 0 Estimated TAX
SHIPPING2 172.05 FOB+SHIPPING+COMM+IVA
CSCOMM 43.01 Estimated Marketplace Commission
CURR 3.8 Currency Rate
TOTAL 818 Estimated Total Local
5 B09SS729N8  1 13.78 (Rate: 3.87) Amazon 0 13.78 53.33 PE 911 PE 235.4 223.51 150 Incorrect R0: ([Price Site Local] < [Price Marketplace]) Profit: -209.73 out of stock Help!
911 PE
53.33 PE
Price Local
235.4 223.51
13.78 (Rate: 3.87)
Price USD
Qty: 1
B09SS729N8
Amazon
Idx: 5
FOB: 150
Incorrect R0: ([Price Site Local] < [Price Marketplace]) Profit: -209.73 out of stock Help!
Amazon - Ofertas de Cyber Monday 30 de noviembre
All SKU's
Quantity 1
View Sheet Product B09SS729N8
Price FOB USD: B09SS729N8
Update Price
Total Commission LOCAL 0.00 Real Marketplace Commission LOCAL
Total Commission USD 0 Real Marketplace Commission USD
FOB 160.5 Estimated Price FOB
SHIPPING 15.1 Estimated International Shipping
COMM 16.05 Estimated International Commission
IVA 0 Estimated TAX
SHIPPING2 191.65 FOB+SHIPPING+COMM+IVA
CSCOMM 47.91 Estimated Marketplace Commission
CURR 3.8 Currency Rate
TOTAL 911 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 28186
order_cbt 1370220573793-01
order_gsx 561314
type S
city Lima
company --
country PERU
country_iso_code --
firstname Juan
lastname Carlos Cancharis Sandoval
phone_secondary +51944701079
state LIMA
street_1 Avenida santa rosa 476 Ate
street_2 Reference: Al frente empresa Braedt Empresa TIGO, fachada verde, al frente empresa braedt - Address Number: 476
zip_code 150103
type_doc NationalRegistrationNumber
id_doc 41568847


Billing
id 28185
order_cbt 1370220573793-01
order_gsx 561314
type B
city Lima
company --
country PERU
country_iso_code --
firstname Juan Carlos
lastname Cancharis Sandoval
phone_secondary +51944701079
state LIMA
street_1 Avenida santa rosa 476 Ate
street_2 Reference: Al frente empresa Braedt - Address Number: 476
zip_code 150103
type_doc NationalRegistrationNumber
id_doc 41568847


Quote
id 1865548
order_cbt 1370220573793-01
order_gsx 561314
idx 0
website_id DINERS-PE
sku B09BBFP1ZC
sku_supplier
sku_seller
package_weight 0.4500
fob 127.3100
local_shipping 0.0000
local_tax 0.0000
cif 127.3100
international_shipping 15.1000
international_commission 13.6200
tax 0.0000
duties 0.0000
fee 0.0000
handling 0.0000
marketplace_shipping 0.00
marketplace_commission 41.2300
marketplace_fixed_fee 0.0000
currency_rate 3.8700
price_seller 798.0000
quantity 2
invoice_fob 127.3100
invoice_tax 0.0000
invoice_shipping -113.5300
invoice_total 13.7800
invoice_qty 1
invoice_price 13.7800
invoice_currency_code USD
invoice_price_site 53.3400
invoice_currency_code_site PE
invoice_change_rate 3.8700
invoice_total_commission 0.0000
adjust_discount_value 0.0000
created_at 2023-10-23 15:14:13