Dashboard Control panel

  1. Home
  2. Dashboard

Order View (6382219001-A - 561080 - RIPLEYPE - CLOSED)

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



Info
id 30310
id_cbt
order_cbt 6382219001-A
order_gsx 561080
date_cbt 2023-10-18 02:14:04
invoice_amount 301.55
buyer_first_name Briggid
buyer_last_name Mejia Cardenas
buyer_company --
buyer_address_line_1 Santa Inés Jr los brillantes 621 621, 101 G
buyer_address_line_2 LA LIBERTAD
buyer_city TRUJILLO
buyer_state LA LIBERTAD
buyer_zip_code
buyer_country PE
buyer_email
buyer_phone --986500504
buyer_shipment_label_location
buyer_mercardolibre_site PE
buyer_mercardolibre_site_order_id
created_system 2023-10-18 02:42:32
is_loaded_to_purchase_system 1
order_amazon /11012716
amazon_amount 147
amazon_date 2023-10-18 00:00:00
status 8
observation has no amazon products,
shipment_status
international_tracking_id WYB206185503
easypost_warehouse_date 2023-10-21 11:24:08
easypost_carrier_date 2023-10-25 03:51:00
easypost_delivered_date 2023-11-02 12:25:00
easypost_observation eshopex - ENTREGADO - ENTREGADO
easypost_status delivered
amazon_status Shipped
amazon_carrier Fedex
amazon_tracking_id 785213684665
amazon_delivered_date 0000-00-00
merchant_id 2458890
flag_shp 1
flag_del 0
status_cbt CLOSED
payment_status_cbt
mercadolibre_fee 0
currency_rate 0
free_shipping_cost 0
SKU /VSPOY8821/VSPOY7921/VSPOY9221
calculated_sale_price 0
price_amz 0
ship_MX 0
base_price_amz 0
qty_product 3
currency_code USD
cs_site_id RIPLEYPE
qty_items 3
order_esx 523500016845
NationalRegistrationNumber 72416885
globalshopex_warehouse_date 2023-10-20 10:42:05
globalshopex_carrier_date 2023-10-25 17:00:00
invoice_amount_local 1167.00
easypost_carrier urbano
shipping_street_1 Santa Inés Jr los brillantes 621 621, 101 G
shipping_city TRUJILLO
shipping_country PE
shipping_phone_1 986500504
shipping_phone_2 --
acceptance_decision_date 2023-10-18 02:14:07
order_cbt_id 6709
esx_masterid 1010563
esx_barcode
international_tracking_url https://www.eshopex.com/pe/TrackingUV.aspx?id=523500016845
shipping_street_2
customer_debited_date 2023-10-18 02:14:07
easypost_carrier_2
international_tracking_id_2
international_tracking_url_2
esx_status delivered
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
type_of_purchase automatic
status_oms
commentary_cancellation
cancellation_date 0000-00-00 00:00:00
robot_date 2023-10-18 03:22:54
merchant MADALUXE,
amazon_order_status Shipped
cs_site_id_2
CorporateName
CorporateDocument
FlagIsCorporate
log_date 2026-01-11 06:38:58
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
14965 6382219001-A 561080 0 VSPOY8821 
1 95.35 USD 369.00 PE 3.87 66.42 RIPLEYPE 2023-10-18 02:42:30
14966 6382219001-A 561080 1 VSPOY7921 
1 103.10 USD 399.00 PE 3.87 71.82 RIPLEYPE 2023-10-18 02:42:31
14967 6382219001-A 561080 2 VSPOY9221 
1 103.10 USD 399.00 PE 3.87 71.82 RIPLEYPE 2023-10-18 02:42:32
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 VSPOY8821  1 95.35 (Rate: 3.87) MADALUXE 0 95.35 369.00 PE 310 PE 80.1 72.24 39.99 Correct R7: ([Price Site Local] >= [Price Marketplace]) Profit: 23.11 out of stock Help!
310 PE
369.00 PE
Price Local
80.1 72.24
95.35 (Rate: 3.87)
Price USD
Qty: 1
VSPOY8821
MADALUXE
Idx: 0
FOB: 39.99
Correct R7: ([Price Site Local] >= [Price Marketplace]) Profit: 23.11 out of stock Help!
Amazon - Ofertas de Cyber Monday 30 de noviembre
All SKU's
Quantity 1
View Sheet Product VSPOY8821
Price FOB USD: VSPOY8821
Update Price
Total Commission LOCAL 66.42 Real Marketplace Commission LOCAL
Total Commission USD 17.16 Real Marketplace Commission USD
FOB 39.99 Estimated Price FOB
SHIPPING 15.1 Estimated International Shipping
COMM 10 Estimated International Commission
IVA 0 Estimated TAX
SHIPPING2 65.08 FOB+SHIPPING+COMM+IVA
CSCOMM 16.27 Estimated Marketplace Commission
CURR 3.8 Currency Rate
TOTAL 310 Estimated Total Local
1 VSPOY7921  1 103.10 (Rate: 3.87) MADALUXE 0 103.1 399.00 PE 498 PE 128.68 100.06 66.4 Correct R9: ([New Price Site USD] >= [Price Marketplace USD New]) Profit: 3.04 out of stock Help!
498 PE
399.00 PE
Price Local
128.68 100.06
103.10 (Rate: 3.87)
Price USD
Qty: 1
VSPOY7921
MADALUXE
Idx: 1
FOB: 66.4
Correct R9: ([New Price Site USD] >= [Price Marketplace USD New]) Profit: 3.04 out of stock Help!
Amazon - Ofertas de Cyber Monday 30 de noviembre
All SKU's
Quantity 1
View Sheet Product VSPOY7921
Price FOB USD: VSPOY7921
Update Price
Total Commission LOCAL 71.82 Real Marketplace Commission LOCAL
Total Commission USD 18.56 Real Marketplace Commission USD
FOB 66.4 Estimated Price FOB
SHIPPING 15.1 Estimated International Shipping
COMM 23.24 Estimated International Commission
IVA 0 Estimated TAX
SHIPPING2 104.74 FOB+SHIPPING+COMM+IVA
CSCOMM 26.18 Estimated Marketplace Commission
CURR 3.8 Currency Rate
TOTAL 498 Estimated Total Local
2 VSPOY9221  1 103.10 (Rate: 3.87) MADALUXE 0 103.1 399.00 PE 426 PE 110.08 88.86 55.2 Correct R9: ([New Price Site USD] >= [Price Marketplace USD New]) Profit: 14.24 out of stock Help!
426 PE
399.00 PE
Price Local
110.08 88.86
103.10 (Rate: 3.87)
Price USD
Qty: 1
VSPOY9221
MADALUXE
Idx: 2
FOB: 55.2
Correct R9: ([New Price Site USD] >= [Price Marketplace USD New]) Profit: 14.24 out of stock Help!
Amazon - Ofertas de Cyber Monday 30 de noviembre
All SKU's
Quantity 1
View Sheet Product VSPOY9221
Price FOB USD: VSPOY9221
Update Price
Total Commission LOCAL 71.82 Real Marketplace Commission LOCAL
Total Commission USD 18.56 Real Marketplace Commission USD
FOB 55.2 Estimated Price FOB
SHIPPING 15.1 Estimated International Shipping
COMM 19.32 Estimated International Commission
IVA 0 Estimated TAX
SHIPPING2 89.62 FOB+SHIPPING+COMM+IVA
CSCOMM 22.4 Estimated Marketplace Commission
CURR 3.8 Currency Rate
TOTAL 426 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
13276 6382219001-A 561080 2023-10-18 11012716 147.00 0.00 0.00 147.00 2023-10-18 04:15:27 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
/11012716 147 2023-10-18 00:00:00 Shipped Fedex 785213684665 0000-00-00 Shipped


Details
order_cbt order_gsx po_number amazon_status amazon_carrier amazon_tracking_id amazon_delivered_date amazon_order_status
6382219001-A 561080 11012716 Shipped Fedex 785213684665 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
6382219001-A 561080 11012716 Shipped Fedex 785213684665 0000-00-00 Shipped

Form

Details
id order_cbt order_gsx po_number carrier tracking created_system observation
18558 6382219001-A 561080 561080 eshopex 523500016845 2023-10-22 04:20:45
18677 6382219001-A 561080 523500016845 urbano WYB206185503 2023-10-28 04:39:13


Shipping
id 28077
order_cbt 6382219001-A
order_gsx 561080
type S
city TRUJILLO
company
country PE
country_iso_code PER
firstname Briggid
lastname Mejia Cardenas
phone_secondary 986500504
state LA LIBERTAD
street_1 Santa Inés Jr los brillantes 621 621, 101 G
street_2 LA LIBERTAD
zip_code
type_doc NationalRegistrationNumber
id_doc 72416885


Billing
id 28078
order_cbt 6382219001-A
order_gsx 561080
type B
city TRUJILLO
company
country PE
country_iso_code PER
firstname Briggid
lastname Mejia Cardenas
phone_secondary 986500504
state LA LIBERTAD
street_1 Santa Inés Jr los brillantes 621 621
street_2
zip_code
type_doc NationalRegistrationNumber
id_doc 72416885


Quote
id 1865002
order_cbt 6382219001-A
order_gsx 561080
idx 0
website_id RIPLEY-PE
sku VSPOY8821
sku_supplier
sku_seller
package_weight 0.2300
fob 49.0000
local_shipping 0.0000
local_tax 0.0000
cif 49.0000
international_shipping 15.1000
international_commission 12.2500
tax 0.0000
duties 0.0000
fee 0.0000
handling 0.0000
marketplace_shipping 0.00
marketplace_commission 19.0900
marketplace_fixed_fee 0.0000
currency_rate 3.8700
price_seller 370.0000
quantity 2
invoice_fob 49.0000
invoice_tax 0.0000
invoice_shipping 46.3500
invoice_total 95.3500
invoice_qty 1
invoice_price 95.3500
invoice_currency_code USD
invoice_price_site 369.0000
invoice_currency_code_site PE
invoice_change_rate 3.8700
invoice_total_commission 66.4200
adjust_discount_value -0.2600
created_at 2023-10-18 02:42:30