Dashboard Control panel

  1. Home
  2. Dashboard

Order View (6613236001-A - 570244 - RIPLEYPE - CLOSED)

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



Info
id 31857
id_cbt
order_cbt 6613236001-A
order_gsx 570244
date_cbt 2024-04-21 15:57:20
invoice_amount 92.8
buyer_first_name Zenaida
buyer_last_name Garcia
buyer_company --
buyer_address_line_1 Jr tiahuanaco 1111 , Casa
buyer_address_line_2 LIMA
buyer_city SAN JUAN DE LURIGANCHO
buyer_state LIMA
buyer_zip_code
buyer_country PE
buyer_email
buyer_phone --991301032
buyer_shipment_label_location
buyer_mercardolibre_site PE
buyer_mercardolibre_site_order_id
created_system 2024-04-21 16:46:22
is_loaded_to_purchase_system 1
order_amazon /114-8144797-2169851
amazon_amount 35.06
amazon_date 2024-04-22 00:00:00
status 8
observation Is not posible logon by captcha, please Review
shipment_status
international_tracking_id WYB248522399
easypost_warehouse_date 2024-04-26 10:35:48
easypost_carrier_date 2024-04-27 13:24:00
easypost_delivered_date 2024-05-02 13:34:00
easypost_observation eshopex - ENTREGADO - EN
easypost_status delivered
amazon_status Shipped
amazon_carrier UPS
amazon_tracking_id 1Z803R420313556607
amazon_delivered_date 2024-04-23
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 /B07MZ6TBWX/B01DVTFRTA
calculated_sale_price 0
price_amz 0
ship_MX 0
base_price_amz 0
qty_product 2
currency_code USD
cs_site_id RIPLEYPE
qty_items 2
order_esx 523500018899
NationalRegistrationNumber 10658206
globalshopex_warehouse_date 2024-04-25 13:47:04
globalshopex_carrier_date 2024-04-27 17:00:00
invoice_amount_local 348.00
easypost_carrier urbano
shipping_street_1 Jr tiahuanaco 1111 , Casa
shipping_city SAN JUAN DE LURIGANCHO
shipping_country PE
shipping_phone_1 991301032
shipping_phone_2 --
acceptance_decision_date 2024-04-21 15:57:23
order_cbt_id 7734
esx_masterid 1010903
esx_barcode
international_tracking_url https://www.eshopex.com/pe/TrackingUV.aspx?id=523500018899
shipping_street_2
customer_debited_date 2024-04-21 15:57:23
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.75
reason_cancellation
type_of_purchase manual
status_oms
commentary_cancellation
cancellation_date 0000-00-00 00:00:00
robot_date 2024-04-21 16:47:28
merchant Amazon,
amazon_order_status Closed
cs_site_id_2
CorporateName
CorporateDocument
FlagIsCorporate
log_date 2025-12-28 09:20:24
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
16574 6613236001-A 570244 0 B07MZ6TBWX 
1 42.40 USD 159.00 PE 3.75 25.76 RIPLEYPE 2024-04-21 16:46:21
16575 6613236001-A 570244 1 B01DVTFRTA 
1 50.40 USD 189.00 PE 3.75 30.62 RIPLEYPE 2024-04-21 16:46:22
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 B07MZ6TBWX  1 42.40 (Rate: 3.75) Amazon 0 42.4 159.00 PE 166 PE 44.27 40.66 17.47 Correct R9: ([New Price Site USD] >= [Price Marketplace USD New]) Profit: 1.74 out of stock Help!
166 PE
159.00 PE
Price Local
44.27 40.66
42.40 (Rate: 3.75)
Price USD
Qty: 1
B07MZ6TBWX
Amazon
Idx: 0
FOB: 17.47
Correct R9: ([New Price Site USD] >= [Price Marketplace USD New]) Profit: 1.74 out of stock Help!
Amazon - Ofertas de Cyber Monday 30 de noviembre
All SKU's
Quantity 1
View Sheet Product B07MZ6TBWX
Price FOB USD: B07MZ6TBWX
Update Price
Total Commission LOCAL 25.76 Real Marketplace Commission LOCAL
Total Commission USD 6.87 Real Marketplace Commission USD
FOB 18.69 Estimated Price FOB
SHIPPING 15.1 Estimated International Shipping
COMM 1.87 Estimated International Commission
IVA 0 Estimated TAX
SHIPPING2 35.66 FOB+SHIPPING+COMM+IVA
CSCOMM 7.83 Estimated Marketplace Commission
CURR 3.8 Currency Rate
TOTAL 166 Estimated Total Local
1 B01DVTFRTA  1 50.40 (Rate: 3.75) Amazon 0 50.4 189.00 PE 177 PE 47.2 44.08 19.45 Correct R7: ([Price Site Local] >= [Price Marketplace]) Profit: 6.32 out of stock Help!
177 PE
189.00 PE
Price Local
47.2 44.08
50.40 (Rate: 3.75)
Price USD
Qty: 1
B01DVTFRTA
Amazon
Idx: 1
FOB: 19.45
Correct R7: ([Price Site Local] >= [Price Marketplace]) Profit: 6.32 out of stock Help!
Amazon - Ofertas de Cyber Monday 30 de noviembre
All SKU's
Quantity 1
View Sheet Product B01DVTFRTA
Price FOB USD: B01DVTFRTA
Update Price
Total Commission LOCAL 30.62 Real Marketplace Commission LOCAL
Total Commission USD 8.17 Real Marketplace Commission USD
FOB 20.81 Estimated Price FOB
SHIPPING 15.1 Estimated International Shipping
COMM 2.08 Estimated International Commission
IVA 0 Estimated TAX
SHIPPING2 37.99 FOB+SHIPPING+COMM+IVA
CSCOMM 8.34 Estimated Marketplace Commission
CURR 3.8 Currency Rate
TOTAL 177 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
14750 6613236001-A 570244 2024-04-22 114-8144797-2169851 35.06 0.00 0.00 35.06 7807 2024-04-22 21:47:49 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
/114-8144797-2169851 35.06 2024-04-22 00:00:00 Shipped UPS 1Z803R420313556607 2024-04-23 Closed


Details
order_cbt order_gsx po_number amazon_status amazon_carrier amazon_tracking_id amazon_delivered_date amazon_order_status
6613236001-A 570244 114-8144797-2169851 Shipped UPS 1Z803R420313556607 2024-04-23 Closed

Form

Details
order_cbt order_gsx po_number amazon_status amazon_carrier amazon_tracking_id amazon_delivered_date amazon_order_status
6613236001-A 570244 114-8144797-2169851 Shipped UPS 1Z803R420313556607 2024-04-23 Closed

Form

Details
id order_cbt order_gsx po_number carrier tracking created_system observation
20678 6613236001-A 570244 570244 eshopex 523500018899 2024-04-27 04:27:23
20729 6613236001-A 570244 523500018899 urbano WYB248522399 2024-04-30 19:28:05


Shipping
id 31171
order_cbt 6613236001-A
order_gsx 570244
type S
city SAN JUAN DE LURIGANCHO
company
country PE
country_iso_code PER
firstname Zenaida
lastname Garcia
phone_secondary 991301032
state LIMA
street_1 Jr tiahuanaco 1111 , Casa
street_2 LIMA
zip_code
type_doc NationalRegistrationNumber
id_doc 10658206


Billing
id 31172
order_cbt 6613236001-A
order_gsx 570244
type B
city SAN JUAN DE LURIGANCHO
company
country PE
country_iso_code PER
firstname Zenaida
lastname Garcia
phone_secondary 991301032
state LIMA
street_1 Jr tiahuanaco 1111
street_2
zip_code
type_doc NationalRegistrationNumber
id_doc 10658206


Quote
id 1869048
order_cbt 6613236001-A
order_gsx 570244
idx 0
website_id RIPLEY-PE
sku B07MZ6TBWX
sku_supplier
sku_seller
package_weight 0.4500
fob 17.9800
local_shipping 0.0000
local_tax 0.0000
cif 17.9800
international_shipping 15.1000
international_commission 1.9200
tax 0.0000
duties 0.0000
fee 0.0000
handling 0.0000
marketplace_shipping 0.00
marketplace_commission 7.9600
marketplace_fixed_fee 0.0000
currency_rate 3.7500
price_seller 166.0000
quantity 2
invoice_fob 17.9800
invoice_tax 0.0000
invoice_shipping 24.4200
invoice_total 42.4000
invoice_qty 1
invoice_price 42.4000
invoice_currency_code USD
invoice_price_site 159.0000
invoice_currency_code_site PE
invoice_change_rate 3.7500
invoice_total_commission 25.7600
adjust_discount_value -1.8700
created_at 2024-04-21 16:46:20