Dashboard Control panel

  1. Home
  2. Dashboard

Order View (255638112 - 554602 - LINIOPE - delivered)

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



Info
id 29044
id_cbt
order_cbt 255638112
order_gsx 554602
date_cbt 2023-06-10 09:46:44
invoice_amount 519.19
buyer_first_name Maria carolina
buyer_last_name Lpez
buyer_company --
buyer_address_line_1 calle calvino urb la calera de la merced
buyer_address_line_2 --
buyer_city Lima, Lima, Surquillo
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-10 15:36:19
is_loaded_to_purchase_system 1
order_amazon /10968065
amazon_amount 290.7
amazon_date 2023-06-10 00:00:00
status 8
observation has no amazon products,
shipment_status
international_tracking_id MLPE0082015E
easypost_warehouse_date 0000-00-00 00:00:00
easypost_carrier_date 0000-00-00 00:00:00
easypost_delivered_date 2023-07-04 03:48:07
easypost_observation Mail Americas - delivered
easypost_status delivered
amazon_status Shipped
amazon_carrier Fedex
amazon_tracking_id 399497037380
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 /VSPOS6721/VSPOS5921/VSPVO2221
calculated_sale_price 0
price_amz 0
ship_MX 0
base_price_amz 0
qty_product 3
currency_code USD
cs_site_id LINIOPE
qty_items 3
order_esx
NationalRegistrationNumber 15748658
globalshopex_warehouse_date 2023-06-14 12:25:49
globalshopex_carrier_date 2023-06-14 12:27:25
invoice_amount_local 1947.00
easypost_carrier Mail Americas
shipping_street_1 calle calvino urb la calera de la merced
shipping_city Lima, Lima, Surquillo
shipping_country Peru
shipping_phone_1 --
shipping_phone_2 --
acceptance_decision_date 0000-00-00 00:00:00
order_cbt_id 9628564
esx_masterid
esx_barcode
international_tracking_url https://mailamericas.com/tracking?tracking=MLPE0082015E
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
type_of_purchase automatic
status_oms
commentary_cancellation
cancellation_date 0000-00-00 00:00:00
robot_date 2023-06-10 16:06:22
merchant MADALUXE,
amazon_order_status Shipped
cs_site_id_2
CorporateName
CorporateDocument
FlagIsCorporate
log_date 2026-01-10 07:42:48
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
13637 255638112 554602 0 VSPOS6721 
1 159.73 USD 599.00 PE 3.75 0.00 LINIOPE 2023-06-10 15:36:17
13638 255638112 554602 1 VSPOS5921 
1 183.73 USD 689.00 PE 3.75 0.00 LINIOPE 2023-06-10 15:36:18
13639 255638112 554602 2 VSPVO2221 
1 175.73 USD 659.00 PE 3.75 0.00 LINIOPE 2023-06-10 15:36:19
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 VSPOS6721  1 159.73 (Rate: 3.75) MADALUXE 0 159.73 599.00 PE 569 PE 151.73 135.73 95.99 Correct R7: ([Price Site Local] >= [Price Marketplace]) Profit: 24 out of stock Help!
569 PE
599.00 PE
Price Local
151.73 135.73
159.73 (Rate: 3.75)
Price USD
Qty: 1
VSPOS6721
MADALUXE
Idx: 0
FOB: 95.99
Correct R7: ([Price Site Local] >= [Price Marketplace]) Profit: 24 out of stock Help!
Amazon - Ofertas de Cyber Monday 30 de noviembre
All SKU's
Quantity 1
View Sheet Product VSPOS6721
Price FOB USD: VSPOS6721
Update Price
Total Commission LOCAL 0 Real Marketplace Commission LOCAL
Total Commission USD 0 Real Marketplace Commission USD
FOB 113.27 Estimated Price FOB
SHIPPING 11.5 Estimated International Shipping
COMM 17.28 Estimated International Commission
IVA 0 Estimated TAX
SHIPPING2 149.73 FOB+SHIPPING+COMM+IVA
CSCOMM 24.95 Estimated Marketplace Commission
CURR 3.8 Currency Rate
TOTAL 568.96 Estimated Total Local
1 VSPOS5921  1 183.73 (Rate: 3.75) MADALUXE 0 183.73 689.00 PE 515 PE 137.33 121.33 85.99 Correct R7: ([Price Site Local] >= [Price Marketplace]) Profit: 62.4 out of stock Help!
515 PE
689.00 PE
Price Local
137.33 121.33
183.73 (Rate: 3.75)
Price USD
Qty: 1
VSPOS5921
MADALUXE
Idx: 1
FOB: 85.99
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 VSPOS5921
Price FOB USD: VSPOS5921
Update Price
Total Commission LOCAL 0 Real Marketplace Commission LOCAL
Total Commission USD 0 Real Marketplace Commission USD
FOB 121.78 Estimated Price FOB
SHIPPING 11.5 Estimated International Shipping
COMM 18.58 Estimated International Commission
IVA 0 Estimated TAX
SHIPPING2 159.94 FOB+SHIPPING+COMM+IVA
CSCOMM 26.66 Estimated Marketplace Commission
CURR 3.8 Currency Rate
TOTAL 607.76 Estimated Total Local
2 VSPVO2221  1 175.73 (Rate: 3.75) MADALUXE 0 175.73 659.00 PE 876 PE 233.6 217.6 153 Incorrect R0: ([Price Site Local] < [Price Marketplace]) Profit: -41.87 out of stock Help!
876 PE
659.00 PE
Price Local
233.6 217.6
175.73 (Rate: 3.75)
Price USD
Qty: 1
VSPVO2221
MADALUXE
Idx: 2
FOB: 153
Incorrect R0: ([Price Site Local] < [Price Marketplace]) Profit: -41.87 out of stock Help!
Amazon - Ofertas de Cyber Monday 30 de noviembre
All SKU's
Quantity 1
View Sheet Product VSPVO2221
Price FOB USD: VSPVO2221
Update Price
Total Commission LOCAL 0 Real Marketplace Commission LOCAL
Total Commission USD 0 Real Marketplace Commission USD
FOB 180.54 Estimated Price FOB
SHIPPING 11.5 Estimated International Shipping
COMM 27.54 Estimated International Commission
IVA 0 Estimated TAX
SHIPPING2 230.45 FOB+SHIPPING+COMM+IVA
CSCOMM 38.41 Estimated Marketplace Commission
CURR 3.8 Currency Rate
TOTAL 875.72 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
12031 255638112 554602 2023-06-10 10968065 290.70 0.00 0.00 290.70 2023-06-10 16:36:59 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
/10968065 290.7 2023-06-10 00:00:00 Shipped Fedex 399497037380 0000-00-00 Shipped


Details
order_cbt order_gsx po_number amazon_status amazon_carrier amazon_tracking_id amazon_delivered_date amazon_order_status
255638112 554602 10968065 Shipped Fedex 399497037380 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
255638112 554602 10968065 Shipped Fedex 399497037380 0000-00-00 Shipped

Form



Shipping
id 25546
order_cbt 255638112
order_gsx 554602
type S
city Lima, Lima, Surquillo
company --
country Peru
country_iso_code --
firstname Maria carolina
lastname Lpez
phone_secondary --
state --
street_1 calle calvino urb la calera de la merced
street_2 --
zip_code --
type_doc NationalRegistrationNumber
id_doc 15748658


Billing
id 25545
order_cbt 255638112
order_gsx 554602
type B
city --
company --
country Peru
country_iso_code --
firstname Maria carolina Lpez
lastname --
phone_secondary --
state --
street_1 00000
street_2 --
zip_code --
type_doc NationalRegistrationNumber
id_doc 15748658


Quote
id 1860590
order_cbt 255638112
order_gsx 554602
idx 0
website_id LINIO-PE
sku VSPOS6721
sku_supplier
sku_seller
package_weight 0.4100
fob 94.7000
local_shipping 0.0000
local_tax 0.0000
cif 118.3800
international_shipping 16.3000
international_commission 23.6800
tax 0.0000
duties 0.0000
fee 0.0000
handling 0.0000
marketplace_shipping 0.00
marketplace_commission 24.2400
marketplace_fixed_fee 0.0000
currency_rate 3.7500
price_seller 595.9400
quantity 2
invoice_fob 94.7000
invoice_tax 0.0000
invoice_shipping 65.0300
invoice_total 159.7300
invoice_qty 1
invoice_price 159.7300
invoice_currency_code USD
invoice_price_site 599.0000
invoice_currency_code_site PE
invoice_change_rate 3.7500
invoice_total_commission 0.0000
adjust_discount_value 0.8100
created_at 2023-06-10 15:36:17