Dashboard Control panel

  1. Home
  2. Dashboard

Order View (23074415602-A - 581507 - RIPLEYCL - CLOSED)

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



Info
id 33004
id_cbt
order_cbt 23074415602-A
order_gsx 581507
date_cbt 2024-11-26 14:43:45
invoice_amount 315.45
buyer_first_name Francisco
buyer_last_name Durán
buyer_company --
buyer_address_line_1 Orompello 1775
buyer_address_line_2 Casa
buyer_city LOS ANGELES
buyer_state VIII REGION
buyer_zip_code
buyer_country CL
buyer_email
buyer_phone --932101289
buyer_shipment_label_location
buyer_mercardolibre_site CL
buyer_mercardolibre_site_order_id
created_system 2024-11-26 14:44:08
is_loaded_to_purchase_system 1
order_amazon /BBY-01 806994076244/112-6700463-7253865
amazon_amount 141.46
amazon_date 2025-01-22 00:00:00
status 8
observation has no amazon products,
shipment_status
international_tracking_id 238612884
easypost_warehouse_date 0000-00-00 00:00:00
easypost_carrier_date 2025-01-30 17:06:26
easypost_delivered_date 2025-02-14 12:11:16
easypost_observation eshopex - ENTREGADO PDA - ENTREGADO
easypost_status delivered
amazon_status
amazon_carrier
amazon_tracking_id
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 /6574073/6579018/6574077/6579032
calculated_sale_price 0
price_amz 0
ship_MX 0
base_price_amz 0
qty_product 4
currency_code USD
cs_site_id RIPLEYCL
qty_items 4
order_esx 523500021104
NationalRegistrationNumber 155929324
globalshopex_warehouse_date 2025-01-27 10:03:32
globalshopex_carrier_date 2025-02-06 17:00:00
invoice_amount_local 299961.00
easypost_carrier starken
shipping_street_1 Orompello 1775
shipping_city LOS ANGELES
shipping_country CL
shipping_phone_1 932101289
shipping_phone_2 --
acceptance_decision_date 2024-11-26 14:43:46
order_cbt_id 5098
esx_masterid 1011374
esx_barcode
international_tracking_url https://www.eshopex.com/pe/TrackingUV.aspx?id=523500021104
shipping_street_2
customer_debited_date 2024-11-26 14:43:46
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 950.90
reason_cancellation
type_of_purchase manual
status_oms
commentary_cancellation
cancellation_date 0000-00-00 00:00:00
robot_date 2024-11-26 14:55:07
merchant BESTBUY,
amazon_order_status
cs_site_id_2
CorporateName
CorporateDocument
FlagIsCorporate
log_date 2025-10-11 22:14:26
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
17748 23074415602-A 581507 0 6574073 
1 78.86 USD 74990.00 CL 950.90 11249.00 RIPLEYCL 2024-11-26 14:43:59
17749 23074415602-A 581507 1 6579018 
1 69.40 USD 65990.00 CL 950.90 9899.00 RIPLEYCL 2024-11-26 14:44:00
17750 23074415602-A 581507 2 6574077 
1 88.33 USD 83990.00 CL 950.90 12599.00 RIPLEYCL 2024-11-26 14:44:06
17751 23074415602-A 581507 3 6579032 
1 78.86 USD 74990.00 CL 950.90 11249.00 RIPLEYCL 2024-11-26 14:44:08
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 6574073  1 78.86 (Rate: 950.90) BESTBUY 1 78.86 74990.00 CL 74568 CL 78.42 67.46 36.74 Correct R7: ([Price Site Local] >= [Price Marketplace]) Profit: 11.4 stock Help!
74568 CL
74990.00 CL
Price Local
78.42 67.46
78.86 (Rate: 950.90)
Price USD
Qty: 1
6574073
BESTBUY
Idx: 0
FOB: 36.74
Correct R7: ([Price Site Local] >= [Price Marketplace]) Profit: 11.4 stock Help!
Amazon - Ofertas de Cyber Monday 30 de noviembre
All SKU's
Quantity 1
View Sheet Product 6574073
Price FOB USD: 6574073
Update Price
Total Commission LOCAL 11249.00 Real Marketplace Commission LOCAL
Total Commission USD 11.83 Real Marketplace Commission USD
FOB 36.74 Estimated Price FOB
SHIPPING 8.68 Estimated International Shipping
COMM 11.02 Estimated International Commission
IVA 10.21 Estimated TAX
SHIPPING2 66.65 FOB+SHIPPING+COMM+IVA
CSCOMM 11.76 Estimated Marketplace Commission
CURR 950.9 Currency Rate
TOTAL 74568 Estimated Total Local
1 6579018  1 69.40 (Rate: 950.90) BESTBUY 1 69.4 65990.00 CL 65345 CL 68.72 59.37 31.49 Correct R7: ([Price Site Local] >= [Price Marketplace]) Profit: 10.03 stock Help!
65345 CL
65990.00 CL
Price Local
68.72 59.37
69.40 (Rate: 950.90)
Price USD
Qty: 1
6579018
BESTBUY
Idx: 1
FOB: 31.49
Correct R7: ([Price Site Local] >= [Price Marketplace]) Profit: 10.03 stock Help!
Amazon - Ofertas de Cyber Monday 30 de noviembre
All SKU's
Quantity 1
View Sheet Product 6579018
Price FOB USD: 6579018
Update Price
Total Commission LOCAL 9899.00 Real Marketplace Commission LOCAL
Total Commission USD 10.41 Real Marketplace Commission USD
FOB 31.49 Estimated Price FOB
SHIPPING 8.68 Estimated International Shipping
COMM 9.45 Estimated International Commission
IVA 8.79 Estimated TAX
SHIPPING2 58.41 FOB+SHIPPING+COMM+IVA
CSCOMM 10.31 Estimated Marketplace Commission
CURR 950.9 Currency Rate
TOTAL 65345 Estimated Total Local
2 6574077  1 88.33 (Rate: 950.90) BESTBUY 1 88.33 83990.00 CL 83820 CL 88.15 75.58 41.99 Correct R7: ([Price Site Local] >= [Price Marketplace]) Profit: 12.75 stock Help!
83820 CL
83990.00 CL
Price Local
88.15 75.58
88.33 (Rate: 950.90)
Price USD
Qty: 1
6574077
BESTBUY
Idx: 2
FOB: 41.99
Correct R7: ([Price Site Local] >= [Price Marketplace]) Profit: 12.75 stock Help!
Amazon - Ofertas de Cyber Monday 30 de noviembre
All SKU's
Quantity 1
View Sheet Product 6574077
Price FOB USD: 6574077
Update Price
Total Commission LOCAL 12599.00 Real Marketplace Commission LOCAL
Total Commission USD 13.25 Real Marketplace Commission USD
FOB 41.99 Estimated Price FOB
SHIPPING 8.68 Estimated International Shipping
COMM 12.6 Estimated International Commission
IVA 11.66 Estimated TAX
SHIPPING2 74.93 FOB+SHIPPING+COMM+IVA
CSCOMM 13.22 Estimated Marketplace Commission
CURR 950.9 Currency Rate
TOTAL 83820 Estimated Total Local
3 6579032  1 78.86 (Rate: 950.90) BESTBUY 1 78.86 74990.00 CL 74598 CL 78.45 67.49 36.74 Correct R7: ([Price Site Local] >= [Price Marketplace]) Profit: 11.37 stock Help!
74598 CL
74990.00 CL
Price Local
78.45 67.49
78.86 (Rate: 950.90)
Price USD
Qty: 1
6579032
BESTBUY
Idx: 3
FOB: 36.74
Correct R7: ([Price Site Local] >= [Price Marketplace]) Profit: 11.37 stock Help!
Amazon - Ofertas de Cyber Monday 30 de noviembre
All SKU's
Quantity 1
View Sheet Product 6579032
Price FOB USD: 6579032
Update Price
Total Commission LOCAL 11249.00 Real Marketplace Commission LOCAL
Total Commission USD 11.83 Real Marketplace Commission USD
FOB 36.74 Estimated Price FOB
SHIPPING 8.68 Estimated International Shipping
COMM 11.02 Estimated International Commission
IVA 10.24 Estimated TAX
SHIPPING2 66.68 FOB+SHIPPING+COMM+IVA
CSCOMM 11.77 Estimated Marketplace Commission
CURR 950.9 Currency Rate
TOTAL 74598 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
15871 23074415602-A 581507 2024-11-29 BBY-01 806994076244 109.97 0.00 0.00 109.97 2024-11-29 15:47:32 0.00 manual sent 0000-00-00 00:00:00
16199 23074415602-A 581507 2025-01-22 112-6700463-7253865 31.49 0.00 0.00 31.49 2025-01-22 18:50:07 0.00 manual 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
/BBY-01 806994076244/112-6700463-7253865 141.46 2025-01-22 00:00:00 0000-00-00


Form

Form

Details
id order_cbt order_gsx po_number carrier tracking created_system observation
22428 23074415602-A 581507 581507 eshopex 523500021104 2025-02-01 05:08:41


Shipping
id 33465
order_cbt 23074415602-A
order_gsx 581507
type S
city LOS ANGELES
company
country CL
country_iso_code CHL
firstname Francisco
lastname Durán
phone_secondary 932101289
state VIII REGION
street_1 Orompello 1775
street_2 Casa
zip_code
type_doc NationalRegistrationNumber
id_doc 155929324


Billing
id 33466
order_cbt 23074415602-A
order_gsx 581507
type B
city LOS ANGELES
company
country CL
country_iso_code CHL
firstname Francisco
lastname Durán
phone_secondary 932101289
state VIII REGION
street_1 Orompello 1775
street_2
zip_code
type_doc NationalRegistrationNumber
id_doc 155929324


Quote
id 1873961
order_cbt 23074415602-A
order_gsx 581507
idx 0
website_id RIPLEY-CL
sku 6574073
sku_supplier
sku_seller
package_weight 0.0700
fob 36.7400
local_shipping 0.0000
local_tax 0.0000
cif 36.7400
international_shipping 8.6800
international_commission 11.0200
tax 10.2100
duties 0.0000
fee 0.0000
handling 0.0000
marketplace_shipping 0.00
marketplace_commission 11.7600
marketplace_fixed_fee 0.0000
currency_rate 950.9000
price_seller 74568.0000
quantity 2
invoice_fob 36.7400
invoice_tax 10.2100
invoice_shipping 31.9100
invoice_total 78.8600
invoice_qty 1
invoice_price 78.8600
invoice_currency_code USD
invoice_price_site 74990.0000
invoice_currency_code_site CL
invoice_change_rate 950.9000
invoice_total_commission 11249.0000
adjust_discount_value 0.4400
created_at 2024-11-26 14:43:58