Dashboard Control panel

  1. Home
  2. Dashboard

Order View (6685240901-A - 572622 - RIPLEYPE - CLOSED)

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



Info
id 32277
id_cbt
order_cbt 6685240901-A
order_gsx 572622
date_cbt 2024-06-27 17:44:00
invoice_amount 143.54
buyer_first_name Lia Luisa
buyer_last_name Peña Laban
buyer_company --
buyer_address_line_1 URB MIRAFLORES COUNTRY CLUB Mz-BE 20,21, piso3
buyer_address_line_2 PIURA
buyer_city CASTILLA
buyer_state PIURA
buyer_zip_code
buyer_country PE
buyer_email
buyer_phone --950586740
buyer_shipment_label_location
buyer_mercardolibre_site PE
buyer_mercardolibre_site_order_id
created_system 2024-06-27 18:43:03
is_loaded_to_purchase_system 1
order_amazon
amazon_amount 0
amazon_date 0000-00-00 00:00:00
status 5
observation Is not posible logon by captcha, please Review
shipment_status
international_tracking_id 6685240901-A
easypost_warehouse_date 0000-00-00 00:00:00
easypost_carrier_date 0000-00-00 00:00:00
easypost_delivered_date 0000-00-00 00:00:00
easypost_observation
easypost_status tracking_code_created
amazon_status
amazon_carrier
amazon_tracking_id
amazon_delivered_date 0000-00-00
merchant_id 2458890
flag_shp 0
flag_del 0
status_cbt CLOSED
payment_status_cbt
mercadolibre_fee 0
currency_rate 0
free_shipping_cost 0
SKU /B000TQXNKE/B072N3TLPF/B08SQTYX33
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
NationalRegistrationNumber 45841825
globalshopex_warehouse_date 0000-00-00 00:00:00
globalshopex_carrier_date 0000-00-00 00:00:00
invoice_amount_local 567.00
easypost_carrier
shipping_street_1 URB MIRAFLORES COUNTRY CLUB Mz-BE 20,21, piso3
shipping_city CASTILLA
shipping_country PE
shipping_phone_1 950586740
shipping_phone_2 --
acceptance_decision_date 2024-06-27 17:44:02
order_cbt_id 7979
esx_masterid 0
esx_barcode
international_tracking_url
shipping_street_2
customer_debited_date 2024-06-27 17:44:02
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.95
reason_cancellation cancelled_by_customer
type_of_purchase unknown
status_oms Cancelled
commentary_cancellation COMENTARIO: "Orden no comprada"
cancellation_date 2024-06-27 22:23:48
robot_date 2024-06-27 18:47:50
merchant Amazon,
amazon_order_status
cs_site_id_2
CorporateName
CorporateDocument
FlagIsCorporate
log_date 2025-12-18 17:18:20
flag_events_blocked 0
status_cancellation Finished
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
16998 6685240901-A 572622 0 B000TQXNKE 
1 40.25 USD 159.00 PE 3.95 28.62 RIPLEYPE 2024-06-27 18:43:00
16999 6685240901-A 572622 1 B072N3TLPF 
1 42.78 USD 169.00 PE 3.95 30.42 RIPLEYPE 2024-06-27 18:43:01
17000 6685240901-A 572622 2 B08SQTYX33 
1 60.51 USD 239.00 PE 3.95 43.02 RIPLEYPE 2024-06-27 18:43:03
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 B000TQXNKE  1 40.25 (Rate: 3.95) Amazon 0 40.25 159.00 PE 170 PE 43.04 41.15 17.57 Incorrect R0: ([Price Site Local] < [Price Marketplace]) Profit: -0.9 out of stock Help!
170 PE
159.00 PE
Price Local
43.04 41.15
40.25 (Rate: 3.95)
Price USD
Qty: 1
B000TQXNKE
Amazon
Idx: 0
FOB: 17.57
Incorrect R0: ([Price Site Local] < [Price Marketplace]) Profit: -0.9 out of stock Help!
Amazon - Ofertas de Cyber Monday 30 de noviembre
All SKU's
Quantity 1
View Sheet Product B000TQXNKE
Price FOB USD: B000TQXNKE
Update Price
Total Commission LOCAL 28.62 Real Marketplace Commission LOCAL
Total Commission USD 7.25 Real Marketplace Commission USD
FOB 18.8 Estimated Price FOB
SHIPPING 15.1 Estimated International Shipping
COMM 1.88 Estimated International Commission
IVA 0 Estimated TAX
SHIPPING2 35.78 FOB+SHIPPING+COMM+IVA
CSCOMM 8.94 Estimated Marketplace Commission
CURR 3.8 Currency Rate
TOTAL 170 Estimated Total Local
1 B072N3TLPF  1 42.78 (Rate: 3.95) Amazon 0 42.78 169.00 PE 156 PE 39.49 38.84 14.99 Correct R7: ([Price Site Local] >= [Price Marketplace]) Profit: 3.94 out of stock Help!
156 PE
169.00 PE
Price Local
39.49 38.84
42.78 (Rate: 3.95)
Price USD
Qty: 1
B072N3TLPF
Amazon
Idx: 1
FOB: 14.99
Correct R7: ([Price Site Local] >= [Price Marketplace]) Profit: 3.94 out of stock Help!
Amazon - Ofertas de Cyber Monday 30 de noviembre
All SKU's
Quantity 1
View Sheet Product B072N3TLPF
Price FOB USD: B072N3TLPF
Update Price
Total Commission LOCAL 30.42 Real Marketplace Commission LOCAL
Total Commission USD 7.7 Real Marketplace Commission USD
FOB 16.04 Estimated Price FOB
SHIPPING 15.1 Estimated International Shipping
COMM 1.6 Estimated International Commission
IVA 0 Estimated TAX
SHIPPING2 32.74 FOB+SHIPPING+COMM+IVA
CSCOMM 8.18 Estimated Marketplace Commission
CURR 3.8 Currency Rate
TOTAL 156 Estimated Total Local
2 B08SQTYX33  1 60.51 (Rate: 3.95) Amazon 0 60.51 239.00 PE 191 PE 48.35 48.86 19.98 Correct R7: ([Price Site Local] >= [Price Marketplace]) Profit: 11.65 out of stock Help!
191 PE
239.00 PE
Price Local
48.35 48.86
60.51 (Rate: 3.95)
Price USD
Qty: 1
B08SQTYX33
Amazon
Idx: 2
FOB: 19.98
Correct R7: ([Price Site Local] >= [Price Marketplace]) Profit: 11.65 out of stock Help!
Amazon - Ofertas de Cyber Monday 30 de noviembre
All SKU's
Quantity 1
View Sheet Product B08SQTYX33
Price FOB USD: B08SQTYX33
Update Price
Total Commission LOCAL 43.02 Real Marketplace Commission LOCAL
Total Commission USD 10.89 Real Marketplace Commission USD
FOB 21.38 Estimated Price FOB
SHIPPING 16.6 Estimated International Shipping
COMM 2.14 Estimated International Commission
IVA 0 Estimated TAX
SHIPPING2 40.11 FOB+SHIPPING+COMM+IVA
CSCOMM 10.03 Estimated Marketplace Commission
CURR 3.8 Currency Rate
TOTAL 191 Estimated Total Local

Form



PO NUMBER
order_amazon amazon_amount amazon_date amazon_status amazon_carrier amazon_tracking_id amazon_delivered_date amazon_order_status
0 0000-00-00 00:00:00 0000-00-00


Form

Form



Shipping
id 32011
order_cbt 6685240901-A
order_gsx 572622
type S
city CASTILLA
company
country PE
country_iso_code PER
firstname Lia Luisa
lastname Peña Laban
phone_secondary 950586740
state PIURA
street_1 URB MIRAFLORES COUNTRY CLUB Mz-BE 20,21, piso3
street_2 PIURA
zip_code
type_doc NationalRegistrationNumber
id_doc 45841825


Billing
id 32012
order_cbt 6685240901-A
order_gsx 572622
type B
city CASTILLA
company
country PE
country_iso_code PER
firstname Lia Luisa
lastname Peña Laban
phone_secondary 950586740
state PIURA
street_1 URB MIRAFLORES COUNTRY CLUB Mz-BE 20,21
street_2
zip_code
type_doc NationalRegistrationNumber
id_doc 45841825


Quote
id 1869924
order_cbt 6685240901-A
order_gsx 572622
idx 0
website_id RIPLEY-PE
sku B000TQXNKE
sku_supplier
sku_seller
package_weight 0.1200
fob 14.2500
local_shipping 0.0000
local_tax 0.0000
cif 14.2500
international_shipping 15.1000
international_commission 1.5200
tax 0.0000
duties 0.0000
fee 0.0000
handling 0.0000
marketplace_shipping 0.00
marketplace_commission 7.9700
marketplace_fixed_fee 0.0000
currency_rate 3.9500
price_seller 158.0000
quantity 2
invoice_fob 14.2500
invoice_tax 0.0000
invoice_shipping 26.0000
invoice_total 40.2500
invoice_qty 1
invoice_price 40.2500
invoice_currency_code USD
invoice_price_site 159.0000
invoice_currency_code_site PE
invoice_change_rate 3.9500
invoice_total_commission 28.6200
adjust_discount_value 0.2500
created_at 2024-06-27 18:43:00