Dashboard Control panel

  1. Home
  2. Dashboard

Order View (221647112 - 554871 - LINIOPE - canceled)

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



Info
id 29093
id_cbt
order_cbt 221647112
order_gsx 554871
date_cbt 2023-06-15 00:55:24
invoice_amount 380.8
buyer_first_name Wendy Carola
buyer_last_name Alvaro Tambra
buyer_company --
buyer_address_line_1 jr brigadier pumacahua
buyer_address_line_2 --
buyer_city Lima, Lima, Lince
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 2023-06-15 06:36:33
is_loaded_to_purchase_system 1
order_amazon /10969563
amazon_amount 176.4
amazon_date 2023-06-15 00:00:00
status 5
observation has no amazon products,
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 Shipped
amazon_carrier Fedex
amazon_tracking_id 399674230283
amazon_delivered_date 0000-00-00
merchant_id 2458890
flag_shp 1
flag_del 0
status_cbt canceled
payment_status_cbt
mercadolibre_fee 0
currency_rate 0
free_shipping_cost 0
SKU /VSPOS5821/VSPOS6421
calculated_sale_price 0
price_amz 0
ship_MX 0
base_price_amz 0
qty_product 2
currency_code USD
cs_site_id LINIOPE
qty_items 2
order_esx
NationalRegistrationNumber 40970780
globalshopex_warehouse_date 0000-00-00 00:00:00
globalshopex_carrier_date 0000-00-00 00:00:00
invoice_amount_local 1428.00
easypost_carrier
shipping_street_1 jr brigadier pumacahua
shipping_city Lima, Lima, Lince
shipping_country Peru
shipping_phone_1 --
shipping_phone_2 --
acceptance_decision_date 0000-00-00 00:00:00
order_cbt_id 9631920
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 3.75
reason_cancellation out_of_stock
type_of_purchase automatic
status_oms Cancelled
commentary_cancellation ARREPENTIMIENTO DEL CLIENTE - MADALUXE SE DEMORA ENVIAR UN PRODUCTO
cancellation_date 2023-07-05 17:16:27
robot_date 2023-06-15 07:04:55
merchant MADALUXE,
amazon_order_status Shipped
cs_site_id_2
CorporateName
CorporateDocument
FlagIsCorporate
log_date 2025-11-26 09:07:34
flag_events_blocked 0
status_cancellation 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
13690 221647112 554871 0 VSPOS5821 
1 183.73 USD 689.00 PE 3.75 0.00 LINIOPE 2023-06-15 06:36:32
13691 221647112 554871 1 VSPOS6421 
1 197.07 USD 739.00 PE 3.75 0.00 LINIOPE 2023-06-15 06:36:33
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 VSPOS5821  1 183.73 (Rate: 3.75) MADALUXE 0 183.73 689.00 PE 1521 PE 405.6 389.6 216 Incorrect R0: ([Price Site Local] < [Price Marketplace]) Profit: -205.87 out of stock Help!
1521 PE
689.00 PE
Price Local
405.6 389.6
183.73 (Rate: 3.75)
Price USD
Qty: 1
VSPOS5821
MADALUXE
Idx: 0
FOB: 216
Incorrect R0: ([Price Site Local] < [Price Marketplace]) Profit: -205.87 out of stock Help!
Amazon - Ofertas de Cyber Monday 30 de noviembre
All SKU's
Quantity 1
View Sheet Product VSPOS5821
Price FOB USD: VSPOS5821
Update Price
Total Commission LOCAL 0 Real Marketplace Commission LOCAL
Total Commission USD 0 Real Marketplace Commission USD
FOB 254.88 Estimated Price FOB
SHIPPING 16.22 Estimated International Shipping
COMM 38.88 Estimated International Commission
IVA 62.49 Estimated TAX
SHIPPING2 400.31 FOB+SHIPPING+COMM+IVA
CSCOMM 66.72 Estimated Marketplace Commission
CURR 3.8 Currency Rate
TOTAL 1521.19 Estimated Total Local
1 VSPOS6421  1 197.07 (Rate: 3.75) MADALUXE 0 197.07 739.00 PE 565 PE 150.67 134.67 95.2 Correct R7: ([Price Site Local] >= [Price Marketplace]) Profit: 62.4 out of stock Help!
565 PE
739.00 PE
Price Local
150.67 134.67
197.07 (Rate: 3.75)
Price USD
Qty: 1
VSPOS6421
MADALUXE
Idx: 1
FOB: 95.2
Correct R7: ([Price Site Local] >= [Price Marketplace]) Profit: 62.4 out of stock Help!
Amazon - Ofertas de Cyber Monday 30 de noviembre
All SKU's
Quantity 1
View Sheet Product VSPOS6421
Price FOB USD: VSPOS6421
Update Price
Total Commission LOCAL 0 Real Marketplace Commission LOCAL
Total Commission USD 0 Real Marketplace Commission USD
FOB 131.22 Estimated Price FOB
SHIPPING 11.5 Estimated International Shipping
COMM 20.02 Estimated International Commission
IVA 0 Estimated TAX
SHIPPING2 171.26 FOB+SHIPPING+COMM+IVA
CSCOMM 28.54 Estimated Marketplace Commission
CURR 3.8 Currency Rate
TOTAL 650.81 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
12079 221647112 554871 2023-06-15 10969563 176.40 0.00 0.00 176.40 2023-06-15 07:36:57 0.00 automatic 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
/10969563 176.4 2023-06-15 00:00:00 Shipped Fedex 399674230283 0000-00-00 Shipped


Details
order_cbt order_gsx po_number amazon_status amazon_carrier amazon_tracking_id amazon_delivered_date amazon_order_status
221647112 554871 10969563 Shipped Fedex 399674230283 0000-00-00 Shipped

Form

Details
order_cbt order_gsx po_number amazon_status amazon_carrier amazon_tracking_id amazon_delivered_date amazon_order_status
221647112 554871 10969563 Shipped Fedex 399674230283 0000-00-00 Shipped

Form



Shipping
id 25644
order_cbt 221647112
order_gsx 554871
type S
city Lima, Lima, Lince
company --
country Peru
country_iso_code --
firstname Wendy Carola
lastname Alvaro Tambra
phone_secondary --
state --
street_1 jr brigadier pumacahua
street_2 --
zip_code --
type_doc NationalRegistrationNumber
id_doc 40970780


Billing
id 25643
order_cbt 221647112
order_gsx 554871
type B
city --
company --
country Peru
country_iso_code --
firstname Wendy Carola Alvaro Tambra
lastname --
phone_secondary --
state --
street_1 00000
street_2 --
zip_code --
type_doc NationalRegistrationNumber
id_doc 40970780


Quote
id 1860695
order_cbt 221647112
order_gsx 554871
idx 0
website_id LINIO-PE
sku VSPOS5821
sku_supplier
sku_seller
package_weight 0.4100
fob 98.0000
local_shipping 0.0000
local_tax 0.0000
cif 139.3200
international_shipping 16.3000
international_commission 36.1200
tax 0.0000
duties 0.0000
fee 0.0000
handling 0.0000
marketplace_shipping 0.00
marketplace_commission 28.0100
marketplace_fixed_fee 0.0000
currency_rate 3.7500
price_seller 688.6200
quantity 2
invoice_fob 98.0000
invoice_tax 0.0000
invoice_shipping 85.7300
invoice_total 183.7300
invoice_qty 1
invoice_price 183.7300
invoice_currency_code USD
invoice_price_site 689.0000
invoice_currency_code_site PE
invoice_change_rate 3.7500
invoice_total_commission 0.0000
adjust_discount_value 0.1000
created_at 2023-06-15 06:36:32