Dashboard Control panel

  1. Home
  2. Dashboard

Order View (20725445802-A - 539828 - RIPLEYCL - CLOSED)

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



Info
id 26589
id_cbt
order_cbt 20725445802-A
order_gsx 539828
date_cbt 2022-10-07 14:14:34
invoice_amount 181.05
buyer_first_name carmen
buyer_last_name rodriguez
buyer_company --
buyer_address_line_1 Crezo torres 2
buyer_address_line_2 31
buyer_city LOS ANDES
buyer_state V REGION
buyer_zip_code 0
buyer_country CL
buyer_email
buyer_phone --957458920
buyer_shipment_label_location
buyer_mercardolibre_site CL
buyer_mercardolibre_site_order_id
created_system 2022-10-07 14:54:38
is_loaded_to_purchase_system 1
order_amazon /113-6285025-5965010
amazon_amount 90.97
amazon_date 2022-10-07 00:00:00
status 8
observation
shipment_status
international_tracking_id 976259763
easypost_warehouse_date 0000-00-00 00:00:00
easypost_carrier_date 2022-10-12 14:34:21
easypost_delivered_date 2022-10-24 15:20:40
easypost_observation eshopex - ENTREGADO - ENTREGADO
easypost_status delivered
amazon_status Shipped
amazon_carrier Amazon Logistics
amazon_tracking_id TBA303232641521
amazon_delivered_date 2022-10-10
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 /B01LY46WJN/B003TPPXAU
calculated_sale_price 0
price_amz 0
ship_MX 0
base_price_amz 0
qty_product 2
currency_code USD
cs_site_id RIPLEYCL
qty_items 2
order_esx 523500012556
NationalRegistrationNumber 85810936
globalshopex_warehouse_date 2022-10-12 14:21:35
globalshopex_carrier_date 2022-10-15 17:00:00
invoice_amount_local 175981.00
easypost_carrier starken
shipping_street_1 Crezo torres 2
shipping_city LOS ANDES
shipping_country CL
shipping_phone_1 957458920
shipping_phone_2 --
acceptance_decision_date 2022-10-07 14:14:38
order_cbt_id 4309
esx_masterid 1009857
esx_barcode
international_tracking_url https://www.eshopex.com/pe/TrackingUV.aspx?id=523500012556
shipping_street_2
customer_debited_date 2022-10-07 14:14:38
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 972.00
reason_cancellation
type_of_purchase automatic
status_oms
commentary_cancellation
cancellation_date 0000-00-00 00:00:00
robot_date 2022-10-07 15:09:08
merchant
amazon_order_status Closed
cs_site_id_2
CorporateName
CorporateDocument
FlagIsCorporate
log_date 2026-01-16 23:50:03
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
11034 20725445802-A 539828 0 B01LY46WJN 
1 131.68 USD 127990.00 CL 972.00 23038.00 RIPLEYCL 2022-10-07 14:54:36
11035 20725445802-A 539828 1 B003TPPXAU 
1 49.37 USD 47990.00 CL 972.00 8638.00 RIPLEYCL 2022-10-07 14:54:38
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 B01LY46WJN  1 131.68 (Rate: 972.00) Amazon 0 131.68 127990.00 CL 132947 CL 136.78 121.68 64.99 Correct R9: ([New Price Site USD] >= [Price Marketplace USD New]) Profit: 10 out of stock Help!
132947 CL
127990.00 CL
Price Local
136.78 121.68
131.68 (Rate: 972.00)
Price USD
Qty: 1
B01LY46WJN
Amazon
Idx: 0
FOB: 64.99
Correct R9: ([New Price Site USD] >= [Price Marketplace USD New]) Profit: 10 out of stock Help!
Amazon - Ofertas de Cyber Monday 30 de noviembre
All SKU's
Quantity 1
View Sheet Product B01LY46WJN
Price FOB USD: B01LY46WJN
Update Price
Total Commission LOCAL 23038.00 Real Marketplace Commission LOCAL
Total Commission USD 23.7 Real Marketplace Commission USD
FOB 69.54 Estimated Price FOB
SHIPPING 8.68 Estimated International Shipping
COMM 20.86 Estimated International Commission
IVA 19.76 Estimated TAX
SHIPPING2 118.84 FOB+SHIPPING+COMM+IVA
CSCOMM 20.97 Estimated Marketplace Commission
CURR 950.9 Currency Rate
TOTAL 132947 Estimated Total Local
1 B003TPPXAU  1 49.37 (Rate: 972.00) Amazon 0 49.37 47990.00 CL 84349 CL 86.78 72.35 37.2 Incorrect R0: ([Price Site Local] < [Price Marketplace]) Profit: -22.98 out of stock Help!
84349 CL
47990.00 CL
Price Local
86.78 72.35
49.37 (Rate: 972.00)
Price USD
Qty: 1
B003TPPXAU
Amazon
Idx: 1
FOB: 37.2
Incorrect R0: ([Price Site Local] < [Price Marketplace]) Profit: -22.98 out of stock Help!
Amazon - Ofertas de Cyber Monday 30 de noviembre
All SKU's
Quantity 1
View Sheet Product B003TPPXAU
Price FOB USD: B003TPPXAU
Update Price
Total Commission LOCAL 8638.00 Real Marketplace Commission LOCAL
Total Commission USD 8.89 Real Marketplace Commission USD
FOB 39.8 Estimated Price FOB
SHIPPING 10.95 Estimated International Shipping
COMM 11.94 Estimated International Commission
IVA 12.7 Estimated TAX
SHIPPING2 75.4 FOB+SHIPPING+COMM+IVA
CSCOMM 13.31 Estimated Marketplace Commission
CURR 950.9 Currency Rate
TOTAL 84349 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
9566 20725445802-A 539828 2022-10-07 113-6285025-5965010 90.97 0.00 0.00 90.97 2006 2022-10-07 15:14:52 0.00 automatic 106-9089204-3250607 sent 0000-00-00 00:00:00 amazon


PO NUMBER
order_amazon amazon_amount amazon_date amazon_status amazon_carrier amazon_tracking_id amazon_delivered_date amazon_order_status
/113-6285025-5965010 90.97 2022-10-07 00:00:00 Shipped Amazon Logistics TBA303232641521 2022-10-10 Closed


Details
order_cbt order_gsx po_number amazon_status amazon_carrier amazon_tracking_id amazon_delivered_date amazon_order_status
20725445802-A 539828 113-6285025-5965010 Shipped Amazon Logistics TBA303232641521 2022-10-10 Closed

Form

Details
order_cbt order_gsx po_number amazon_status amazon_carrier amazon_tracking_id amazon_delivered_date amazon_order_status
20725445802-A 539828 113-6285025-5965010 Shipped Amazon Logistics TBA303232641521 2022-10-10 Closed

Form

Details
id order_cbt order_gsx po_number carrier tracking created_system observation
12787 20725445802-A 539828 539828 eshopex 523500012556 2022-10-12 18:53:50


Shipping
id 20635
order_cbt 20725445802-A
order_gsx 539828
type S
city LOS ANDES
company
country CL
country_iso_code
firstname carmen
lastname rodriguez
phone_secondary 957458920
state V REGION
street_1 Crezo torres 2
street_2 31
zip_code 0
type_doc NationalRegistrationNumber
id_doc 85810936


Billing
id 20636
order_cbt 20725445802-A
order_gsx 539828
type B
city LOS ANDES
company
country CL
country_iso_code
firstname carmen
lastname rodriguez
phone_secondary 957458920
state V REGION
street_1 Crezo torres 2
street_2
zip_code 0
type_doc NationalRegistrationNumber
id_doc 85810936


Quote
id 1850998
order_cbt 20725445802-A
order_gsx 539828
idx 0
website_id RIPLEY-CL
sku B01LY46WJN
sku_supplier
sku_seller
package_weight 0.4500
fob 64.9900
local_shipping 0.0000
local_tax 0.0000
cif 64.9900
international_shipping 8.6800
international_commission 6.9500
tax 19.7600
duties 0.0000
fee 0.0000
handling 0.0000
marketplace_shipping 0.00
marketplace_commission 26.2300
marketplace_fixed_fee 0.0000
currency_rate 972.0000
price_seller 127493.0000
quantity 2
invoice_fob 64.9900
invoice_tax 19.7600
invoice_shipping 46.9300
invoice_total 131.6800
invoice_qty 1
invoice_price 131.6800
invoice_currency_code USD
invoice_price_site 127990.0000
invoice_currency_code_site CL
invoice_change_rate 972.0000
invoice_total_commission 23038.0000
adjust_discount_value 0.5100
created_at 2022-10-07 14:54:36