Dashboard Control panel

  1. Home
  2. Dashboard

Order View (203962873 - 495084 - LINIOPE - pending)

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



Info
id 18507
id_cbt
order_cbt 203962873
order_gsx 495084
date_cbt 2020-11-29 20:57:06
invoice_amount 626.68
buyer_first_name Jeanette Myrian
buyer_last_name Pozo Eche
buyer_company --
buyer_address_line_1 AAHH 2 DE FEBRERO B-33 AAHH 2 DE FEBRERO B-33
buyer_address_line_2 --
buyer_city Talara, Piura, PariÑas
buyer_state --
buyer_zip_code --
buyer_country Peru
buyer_email
buyer_phone --
buyer_shipment_label_location
buyer_mercardolibre_site PE
buyer_mercardolibre_site_order_id
created_system 2020-11-30 02:26:20
is_loaded_to_purchase_system 0
order_amazon /111-3609253-7765021 / 111-6424914-5827405
amazon_amount 387.78
amazon_date 2020-12-03 00:00:00
status 5
observation
shipment_status
international_tracking_id 6736700784
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
easypost_status tracking_code_created
amazon_status
amazon_carrier
amazon_tracking_id
amazon_delivered_date 0000-00-00
merchant_id 2458890
flag_shp 1
flag_del 0
status_cbt pending
payment_status_cbt
mercadolibre_fee 0
currency_rate 0
free_shipping_cost 0
SKU /B014RVQLI2/B0071AQCR2/B071D116HF/B00F2V2HMG/B01M8G6V0L/B01MQCKGNV
calculated_sale_price 0
price_amz 0
ship_MX 0
base_price_amz 0
qty_product 6
currency_code USD
cs_site_id LINIOPE
qty_items 6
order_esx
NationalRegistrationNumber 20102937580
globalshopex_warehouse_date 2020-12-15 12:23:21
globalshopex_carrier_date 2020-12-07 14:56:09
invoice_amount_local 2256.00
easypost_carrier dhl
shipping_street_1 AAHH 2 DE FEBRERO B-33 AAHH 2 DE FEBRERO B-33
shipping_city Talara, Piura, PariÑas
shipping_country Peru
shipping_phone_1 --
shipping_phone_2 --
acceptance_decision_date 0000-00-00 00:00:00
order_cbt_id 6083152
esx_masterid
esx_barcode
international_tracking_url http://www.dhl-usa.com/en/express/tracking.html?AWB=6736700784&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 3.60
reason_cancellation out_of_stock
type_of_purchase unknown
status_oms
commentary_cancellation
cancellation_date 2021-01-27 12:49:26
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 On Sale Pending
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
2300 203962873 495084 0 B014RVQLI2 
1 70.56 USD 254.00 PE 3.60 0.00 LINIOPE 2020-11-30 02:26:18
2301 203962873 495084 1 B0071AQCR2 
1 198.33 USD 714.00 PE 3.60 0.00 LINIOPE 2020-11-30 02:26:18
2302 203962873 495084 2 B071D116HF 
1 73.06 USD 263.00 PE 3.60 0.00 LINIOPE 2020-11-30 02:26:19
2303 203962873 495084 3 B00F2V2HMG 
1 69.17 USD 249.00 PE 3.60 0.00 LINIOPE 2020-11-30 02:26:19
2304 203962873 495084 4 B01M8G6V0L 
1 146.39 USD 527.00 PE 3.60 0.00 LINIOPE 2020-11-30 02:26:20
2305 203962873 495084 5 B01MQCKGNV 
1 69.17 USD 249.00 PE 3.60 0.00 LINIOPE 2020-11-30 02:26:20
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 B014RVQLI2  1 70.56 (Rate: 3.60) Amazon 0 70.56 254.00 PE 288 PE 80 64 40.99 Correct R9: ([New Price Site USD] >= [Price Marketplace USD New]) Profit: 6.56 out of stock Help!
288 PE
254.00 PE
Price Local
80 64
70.56 (Rate: 3.60)
Price USD
Qty: 1
B014RVQLI2
Amazon
Idx: 0
FOB: 40.99
Correct R9: ([New Price Site USD] >= [Price Marketplace USD New]) Profit: 6.56 out of stock Help!
Amazon - Ofertas de Cyber Monday 30 de noviembre
All SKU's
Quantity 1
View Sheet Product B014RVQLI2
Price FOB USD: B014RVQLI2
Update Price
Total Commission LOCAL 0 Real Marketplace Commission LOCAL
Total Commission USD 0 Real Marketplace Commission USD
FOB 51.75 Estimated Price FOB
SHIPPING 11.5 Estimated International Shipping
COMM 7.89 Estimated International Commission
IVA 0 Estimated TAX
SHIPPING2 75.91 FOB+SHIPPING+COMM+IVA
CSCOMM 12.65 Estimated Marketplace Commission
CURR 3.8 Currency Rate
TOTAL 288.46 Estimated Total Local
1 B0071AQCR2  1 198.33 (Rate: 3.60) Amazon 0 198.33 714.00 PE 851 PE 236.39 220.39 138.72 Incorrect R0: ([Price Site Local] < [Price Marketplace]) Profit: -22.06 out of stock Help!
851 PE
714.00 PE
Price Local
236.39 220.39
198.33 (Rate: 3.60)
Price USD
Qty: 1
B0071AQCR2
Amazon
Idx: 1
FOB: 138.72
Incorrect R0: ([Price Site Local] < [Price Marketplace]) Profit: -22.06 out of stock Help!
Amazon - Ofertas de Cyber Monday 30 de noviembre
All SKU's
Quantity 1
View Sheet Product B0071AQCR2
Price FOB USD: B0071AQCR2
Update Price
Total Commission LOCAL 0 Real Marketplace Commission LOCAL
Total Commission USD 0 Real Marketplace Commission USD
FOB 175.15 Estimated Price FOB
SHIPPING 11.5 Estimated International Shipping
COMM 26.72 Estimated International Commission
IVA 0 Estimated TAX
SHIPPING2 223.98 FOB+SHIPPING+COMM+IVA
CSCOMM 37.33 Estimated Marketplace Commission
CURR 3.8 Currency Rate
TOTAL 851.14 Estimated Total Local
2 B071D116HF  1 73.06 (Rate: 3.60) Amazon 0 73.06 263.00 PE 317 PE 88.06 72.06 45.99 Correct R9: ([New Price Site USD] >= [Price Marketplace USD New]) Profit: 1 out of stock Help!
317 PE
263.00 PE
Price Local
88.06 72.06
73.06 (Rate: 3.60)
Price USD
Qty: 1
B071D116HF
Amazon
Idx: 2
FOB: 45.99
Correct R9: ([New Price Site USD] >= [Price Marketplace USD New]) Profit: 1 out of stock Help!
Amazon - Ofertas de Cyber Monday 30 de noviembre
All SKU's
Quantity 1
View Sheet Product B071D116HF
Price FOB USD: B071D116HF
Update Price
Total Commission LOCAL 0 Real Marketplace Commission LOCAL
Total Commission USD 0 Real Marketplace Commission USD
FOB 58.07 Estimated Price FOB
SHIPPING 11.5 Estimated International Shipping
COMM 8.86 Estimated International Commission
IVA 0 Estimated TAX
SHIPPING2 83.49 FOB+SHIPPING+COMM+IVA
CSCOMM 13.91 Estimated Marketplace Commission
CURR 3.8 Currency Rate
TOTAL 317.25 Estimated Total Local
3 B00F2V2HMG  1 69.17 (Rate: 3.60) Amazon 0 69.17 249.00 PE 248 PE 68.89 52.89 33.99 Correct R7: ([Price Site Local] >= [Price Marketplace]) Profit: 16.28 out of stock Help!
248 PE
249.00 PE
Price Local
68.89 52.89
69.17 (Rate: 3.60)
Price USD
Qty: 1
B00F2V2HMG
Amazon
Idx: 3
FOB: 33.99
Correct R7: ([Price Site Local] >= [Price Marketplace]) Profit: 16.28 out of stock Help!
Amazon - Ofertas de Cyber Monday 30 de noviembre
All SKU's
Quantity 1
View Sheet Product B00F2V2HMG
Price FOB USD: B00F2V2HMG
Update Price
Total Commission LOCAL 0 Real Marketplace Commission LOCAL
Total Commission USD 0 Real Marketplace Commission USD
FOB 42.92 Estimated Price FOB
SHIPPING 11.5 Estimated International Shipping
COMM 6.55 Estimated International Commission
IVA 0 Estimated TAX
SHIPPING2 65.3 FOB+SHIPPING+COMM+IVA
CSCOMM 10.88 Estimated Marketplace Commission
CURR 3.8 Currency Rate
TOTAL 248.16 Estimated Total Local
4 B01M8G6V0L  1 146.39 (Rate: 3.60) Amazon 0 146.39 527.00 PE 779 PE 216.39 200.39 126.27 Incorrect R0: ([Price Site Local] < [Price Marketplace]) Profit: -54 out of stock Help!
779 PE
527.00 PE
Price Local
216.39 200.39
146.39 (Rate: 3.60)
Price USD
Qty: 1
B01M8G6V0L
Amazon
Idx: 4
FOB: 126.27
Incorrect R0: ([Price Site Local] < [Price Marketplace]) Profit: -54 out of stock Help!
Amazon - Ofertas de Cyber Monday 30 de noviembre
All SKU's
Quantity 1
View Sheet Product B01M8G6V0L
Price FOB USD: B01M8G6V0L
Update Price
Total Commission LOCAL 0 Real Marketplace Commission LOCAL
Total Commission USD 0 Real Marketplace Commission USD
FOB 159.43 Estimated Price FOB
SHIPPING 11.5 Estimated International Shipping
COMM 24.32 Estimated International Commission
IVA 0 Estimated TAX
SHIPPING2 205.12 FOB+SHIPPING+COMM+IVA
CSCOMM 34.19 Estimated Marketplace Commission
CURR 3.8 Currency Rate
TOTAL 779.46 Estimated Total Local
5 B01MQCKGNV  1 69.17 (Rate: 3.60) Amazon 0 69.17 249.00 PE 283 PE 78.61 62.61 39.99 Correct R9: ([New Price Site USD] >= [Price Marketplace USD New]) Profit: 6.56 out of stock Help!
283 PE
249.00 PE
Price Local
78.61 62.61
69.17 (Rate: 3.60)
Price USD
Qty: 1
B01MQCKGNV
Amazon
Idx: 5
FOB: 39.99
Correct R9: ([New Price Site USD] >= [Price Marketplace USD New]) Profit: 6.56 out of stock Help!
Amazon - Ofertas de Cyber Monday 30 de noviembre
All SKU's
Quantity 1
View Sheet Product B01MQCKGNV
Price FOB USD: B01MQCKGNV
Update Price
Total Commission LOCAL 0 Real Marketplace Commission LOCAL
Total Commission USD 0 Real Marketplace Commission USD
FOB 50.49 Estimated Price FOB
SHIPPING 11.5 Estimated International Shipping
COMM 7.7 Estimated International Commission
IVA 0 Estimated TAX
SHIPPING2 74.4 FOB+SHIPPING+COMM+IVA
CSCOMM 12.4 Estimated Marketplace Commission
CURR 3.8 Currency Rate
TOTAL 282.7 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
1842 203962873 495084 2020-12-03 111-3609253-7765021 / 111-6424914-5827405 387.78 0.00 0.00 387.78 3913 2020-12-03 18:44:11 0.00 sent 0000-00-00 00:00:00


PO NUMBER
order_amazon amazon_amount amazon_date amazon_status amazon_carrier amazon_tracking_id amazon_delivered_date amazon_order_status
/111-3609253-7765021 / 111-6424914-5827405 387.78 2020-12-03 00:00:00 0000-00-00


Form

Form

Details
id order_cbt order_gsx po_number carrier tracking created_system observation
3624 203962873 495084 495084 dhl 6736700784 2020-12-31 20:27:21


Shipping
id 4458
order_cbt 203962873
order_gsx 495084
type S
city Talara, Piura, PariÑas
company --
country Peru
country_iso_code --
firstname Jeanette Myrian
lastname Pozo Eche
phone_secondary --
state --
street_1 AAHH 2 DE FEBRERO B-33 AAHH 2 DE FEBRERO B-33
street_2 --
zip_code --
type_doc NationalRegistrationNumber
id_doc 20102937580


Billing
id 4457
order_cbt 203962873
order_gsx 495084
type B
city --
company --
country Peru
country_iso_code --
firstname Servicio de Vigilancia El Cóndor SRL
lastname --
phone_secondary --
state --
street_1 Zona industrial A-28 Talara Alta
street_2 --
zip_code --
type_doc NationalRegistrationNumber
id_doc 20102937580


Quote
id 1828546
order_cbt 203962873
order_gsx 495084
idx 0
website_id LINIO-PE
sku B014RVQLI2
sku_supplier
sku_seller
package_weight 0.0500
fob 40.9900
local_shipping 0.0000
local_tax 0.0000
cif 40.9900
international_shipping 16.6400
international_commission 0.0000
tax 0.0000
duties 0.0000
fee 0.0000
handling 0.0000
marketplace_shipping 0.00
marketplace_commission 7.3200
marketplace_fixed_fee 0.8000
currency_rate 3.6000
price_seller 264.7300
quantity 2
invoice_fob 40.9900
invoice_tax 0.0000
invoice_shipping 29.5700
invoice_total 70.5600
invoice_qty 1
invoice_price 70.5600
invoice_currency_code USD
invoice_price_site 254.0000
invoice_currency_code_site PE
invoice_change_rate 3.6000
invoice_total_commission 0.0000
adjust_discount_value -2.9800
created_at 2020-11-30 02:26:18