Dashboard Control panel

  1. Home
  2. Dashboard

Order View (137924850-A - 517043 - RIPLEYCL - CLOSED)

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



Info
id 22351
id_cbt
order_cbt 137924850-A
order_gsx 517043
date_cbt 2021-08-27 00:01:49
invoice_amount 210.12
buyer_first_name juan carlos
buyer_last_name salgado
buyer_company --
buyer_address_line_1 arturo perez canto villa nueva san felipe 222
buyer_address_line_2 222
buyer_city SAN FELIPE
buyer_state V REGION
buyer_zip_code
buyer_country CL
buyer_email
buyer_phone --
buyer_shipment_label_location
buyer_mercardolibre_site CL
buyer_mercardolibre_site_order_id
created_system 2021-08-27 00:25:16
is_loaded_to_purchase_system 1
order_amazon /114-8808919-3508249
amazon_amount 101.61
amazon_date 2021-09-02 00:00:00
status 5
observation Products qty on page is not equal with the --> Qty on order 6 -->Qty on page = 4
shipment_status
international_tracking_id
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 shipment_canceled
amazon_status Shipped
amazon_carrier Amazon Logistics
amazon_tracking_id TBA165161259501
amazon_delivered_date 2021-09-04
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 /B07BWFVPNT/B07NWJNB1L/B07521KFRR/B07V7L16NN/B078K6RDS6/B078K6RDS6
calculated_sale_price 0
price_amz 0
ship_MX 0
base_price_amz 0
qty_product 6
currency_code USD
cs_site_id RIPLEYCL
qty_items 6
order_esx
NationalRegistrationNumber 137798751
globalshopex_warehouse_date 2021-09-08 06:47:25
globalshopex_carrier_date 0000-00-00 00:00:00
invoice_amount_local 168096.00
easypost_carrier
shipping_street_1 arturo perez canto villa nueva san felipe 222
shipping_city SAN FELIPE
shipping_country CL
shipping_phone_1 99312026
shipping_phone_2 --
acceptance_decision_date 2021-08-27 00:14:03
order_cbt_id 3109
esx_masterid 0
esx_barcode
international_tracking_url
shipping_street_2
customer_debited_date 2021-08-27 00:19:30
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 800.00
reason_cancellation cancelled_by_customer
type_of_purchase manual
status_oms Cancelled
commentary_cancellation
cancellation_date 2021-09-22 18:52:22
robot_date 0000-00-00 00:00:00
merchant
amazon_order_status Closed
cs_site_id_2
CorporateName
CorporateDocument
FlagIsCorporate
log_date 2025-09-28 10:56:01
flag_events_blocked 0
status_cancellation Finance Pending
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
6563 137924850-A 517043 0 B07BWFVPNT 
1 34.66 USD 27731.00 CL 800.00 4992.00 RIPLEYCL 2021-08-27 00:25:06
6564 137924850-A 517043 1 B07NWJNB1L 
1 26.36 USD 21089.00 CL 800.00 3796.00 RIPLEYCL 2021-08-27 00:25:08
6565 137924850-A 517043 2 B07521KFRR 
1 44.87 USD 35893.00 CL 800.00 6461.00 RIPLEYCL 2021-08-27 00:25:10
6566 137924850-A 517043 3 B07V7L16NN 
1 31.69 USD 25350.00 CL 800.00 4563.00 RIPLEYCL 2021-08-27 00:25:12
6567 137924850-A 517043 4 B078K6RDS6 
1 36.27 USD 29012.00 CL 800.00 5222.00 RIPLEYCL 2021-08-27 00:25:14
6568 137924850-A 517043 5 B078K6RDS6 
1 36.27 USD 29012.00 CL 800.00 5222.00 RIPLEYCL 2021-08-27 00:25:16
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 B07BWFVPNT  1 34.66 (Rate: 800.00) Amazon 1 34.66 27731.00 CL 35859 CL 44.82 32.03 15.99 Correct R9: ([New Price Site USD] >= [Price Marketplace USD New]) Profit: 2.63 stock Help!
35859 CL
27731.00 CL
Price Local
44.82 32.03
34.66 (Rate: 800.00)
Price USD
Qty: 1
B07BWFVPNT
Amazon
Idx: 0
FOB: 15.99
Correct R9: ([New Price Site USD] >= [Price Marketplace USD New]) Profit: 2.63 stock Help!
Amazon - Ofertas de Cyber Monday 30 de noviembre
All SKU's
Quantity 1
View Sheet Product B07BWFVPNT
Price FOB USD: B07BWFVPNT
Update Price
Total Commission LOCAL 4992.00 Real Marketplace Commission LOCAL
Total Commission USD 6.24 Real Marketplace Commission USD
FOB 17.11 Estimated Price FOB
SHIPPING 8.68 Estimated International Shipping
COMM 5.13 Estimated International Commission
IVA 0 Estimated TAX
SHIPPING2 30.92 FOB+SHIPPING+COMM+IVA
CSCOMM 6.79 Estimated Marketplace Commission
CURR 950.9 Currency Rate
TOTAL 35859 Estimated Total Local
1 B07NWJNB1L  1 26.36 (Rate: 800.00) Amazon 1 26.36 21089.00 CL 31020 CL 38.78 27.33 12.99 Incorrect R0: ([Price Site Local] < [Price Marketplace]) Profit: -0.97 stock Help!
31020 CL
21089.00 CL
Price Local
38.78 27.33
26.36 (Rate: 800.00)
Price USD
Qty: 1
B07NWJNB1L
Amazon
Idx: 1
FOB: 12.99
Incorrect R0: ([Price Site Local] < [Price Marketplace]) Profit: -0.97 stock Help!
Amazon - Ofertas de Cyber Monday 30 de noviembre
All SKU's
Quantity 1
View Sheet Product B07NWJNB1L
Price FOB USD: B07NWJNB1L
Update Price
Total Commission LOCAL 3796.00 Real Marketplace Commission LOCAL
Total Commission USD 4.75 Real Marketplace Commission USD
FOB 13.9 Estimated Price FOB
SHIPPING 8.68 Estimated International Shipping
COMM 4.17 Estimated International Commission
IVA 0 Estimated TAX
SHIPPING2 26.75 FOB+SHIPPING+COMM+IVA
CSCOMM 5.87 Estimated Marketplace Commission
CURR 950.9 Currency Rate
TOTAL 31020 Estimated Total Local
2 B07521KFRR  1 44.87 (Rate: 800.00) Amazon 1 44.87 35893.00 CL 34504 CL 43.13 32.97 15.15 Correct R7: ([Price Site Local] >= [Price Marketplace]) Profit: 11.9 stock Help!
34504 CL
35893.00 CL
Price Local
43.13 32.97
44.87 (Rate: 800.00)
Price USD
Qty: 1
B07521KFRR
Amazon
Idx: 2
FOB: 15.15
Correct R7: ([Price Site Local] >= [Price Marketplace]) Profit: 11.9 stock Help!
Amazon - Ofertas de Cyber Monday 30 de noviembre
All SKU's
Quantity 1
View Sheet Product B07521KFRR
Price FOB USD: B07521KFRR
Update Price
Total Commission LOCAL 6461.00 Real Marketplace Commission LOCAL
Total Commission USD 8.08 Real Marketplace Commission USD
FOB 16.21 Estimated Price FOB
SHIPPING 8.68 Estimated International Shipping
COMM 4.86 Estimated International Commission
IVA 0 Estimated TAX
SHIPPING2 29.75 FOB+SHIPPING+COMM+IVA
CSCOMM 6.53 Estimated Marketplace Commission
CURR 950.9 Currency Rate
TOTAL 34504 Estimated Total Local
3 B07V7L16NN  1 31.69 (Rate: 800.00) Amazon 0 31.69 25350.00 CL 32617 CL 40.77 29.34 13.98 Correct R9: ([New Price Site USD] >= [Price Marketplace USD New]) Profit: 2.35 out of stock Help!
32617 CL
25350.00 CL
Price Local
40.77 29.34
31.69 (Rate: 800.00)
Price USD
Qty: 1
B07V7L16NN
Amazon
Idx: 3
FOB: 13.98
Correct R9: ([New Price Site USD] >= [Price Marketplace USD New]) Profit: 2.35 out of stock Help!
Amazon - Ofertas de Cyber Monday 30 de noviembre
All SKU's
Quantity 1
View Sheet Product B07V7L16NN
Price FOB USD: B07V7L16NN
Update Price
Total Commission LOCAL 4563.00 Real Marketplace Commission LOCAL
Total Commission USD 5.7 Real Marketplace Commission USD
FOB 14.96 Estimated Price FOB
SHIPPING 8.68 Estimated International Shipping
COMM 4.49 Estimated International Commission
IVA 0 Estimated TAX
SHIPPING2 28.13 FOB+SHIPPING+COMM+IVA
CSCOMM 6.17 Estimated Marketplace Commission
CURR 950.9 Currency Rate
TOTAL 32617 Estimated Total Local
4 B078K6RDS6  1 36.27 (Rate: 800.00) Amazon 1 36.27 29012.00 CL 32471 CL 40.59 30.07 13.89 Correct R9: ([New Price Site USD] >= [Price Marketplace USD New]) Profit: 6.2 stock Help!
32471 CL
29012.00 CL
Price Local
40.59 30.07
36.27 (Rate: 800.00)
Price USD
Qty: 1
B078K6RDS6
Amazon
Idx: 4
FOB: 13.89
Correct R9: ([New Price Site USD] >= [Price Marketplace USD New]) Profit: 6.2 stock Help!
Amazon - Ofertas de Cyber Monday 30 de noviembre
All SKU's
Quantity 1
View Sheet Product B078K6RDS6
Price FOB USD: B078K6RDS6
Update Price
Total Commission LOCAL 5222.00 Real Marketplace Commission LOCAL
Total Commission USD 6.53 Real Marketplace Commission USD
FOB 14.86 Estimated Price FOB
SHIPPING 8.68 Estimated International Shipping
COMM 4.46 Estimated International Commission
IVA 0 Estimated TAX
SHIPPING2 28 FOB+SHIPPING+COMM+IVA
CSCOMM 6.15 Estimated Marketplace Commission
CURR 950.9 Currency Rate
TOTAL 32471 Estimated Total Local
5 B078K6RDS6  1 36.27 (Rate: 800.00) Amazon 1 36.27 29012.00 CL 32471 CL 40.59 30.07 13.89 Correct R9: ([New Price Site USD] >= [Price Marketplace USD New]) Profit: 6.2 stock Help!
32471 CL
29012.00 CL
Price Local
40.59 30.07
36.27 (Rate: 800.00)
Price USD
Qty: 1
B078K6RDS6
Amazon
Idx: 5
FOB: 13.89
Correct R9: ([New Price Site USD] >= [Price Marketplace USD New]) Profit: 6.2 stock Help!
Amazon - Ofertas de Cyber Monday 30 de noviembre
All SKU's
Quantity 1
View Sheet Product B078K6RDS6
Price FOB USD: B078K6RDS6
Update Price
Total Commission LOCAL 5222.00 Real Marketplace Commission LOCAL
Total Commission USD 6.53 Real Marketplace Commission USD
FOB 14.86 Estimated Price FOB
SHIPPING 8.68 Estimated International Shipping
COMM 4.46 Estimated International Commission
IVA 0 Estimated TAX
SHIPPING2 28 FOB+SHIPPING+COMM+IVA
CSCOMM 6.15 Estimated Marketplace Commission
CURR 950.9 Currency Rate
TOTAL 32471 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
5438 137924850-A 517043 2021-09-02 114-8808919-3508249 94.95 0.00 6.66 101.61 3004 2021-09-02 14:48:50 0.00 manual 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
/114-8808919-3508249 101.61 2021-09-02 00:00:00 Shipped Amazon Logistics TBA165161259501 2021-09-04 Closed


Details
order_cbt order_gsx po_number amazon_status amazon_carrier amazon_tracking_id amazon_delivered_date amazon_order_status
137924850-A 517043 114-8808919-3508249 Shipped Amazon Logistics TBA165161259501 2021-09-04 Closed

Form

Details
order_cbt order_gsx po_number amazon_status amazon_carrier amazon_tracking_id amazon_delivered_date amazon_order_status
137924850-A 517043 114-8808919-3508249 Shipped Amazon Logistics TBA165161259501 2021-09-04 Closed

Form



Shipping
id 12145
order_cbt 137924850-A
order_gsx 517043
type S
city SAN FELIPE
company
country CL
country_iso_code
firstname juan carlos
lastname salgado
phone_secondary 99312026
state V REGION
street_1 arturo perez canto villa nueva san felipe 222
street_2 222
zip_code
type_doc NationalRegistrationNumber
id_doc 137798751


Billing
id 12146
order_cbt 137924850-A
order_gsx 517043
type B
city SAN FELIPE
company
country CL
country_iso_code
firstname juan carlos
lastname salgado
phone_secondary 99312026
state V REGION
street_1 arturo perez canto villa nueva san felipe 222
street_2 222
zip_code
type_doc NationalRegistrationNumber
id_doc 137798751


Quote
id 1837931
order_cbt 137924850-A
order_gsx 517043
idx 0
website_id RIPLEY-CL
sku B07BWFVPNT
sku_supplier
sku_seller
package_weight 0.0200
fob 15.9900
local_shipping 0.0000
local_tax 0.0000
cif 15.9900
international_shipping 8.6800
international_commission 1.7100
tax 0.0000
duties 0.0000
fee 0.0000
handling 0.0000
marketplace_shipping 0.00
marketplace_commission 6.8800
marketplace_fixed_fee 0.0000
currency_rate 800.0000
price_seller 27501.0000
quantity 0
invoice_fob 15.9900
invoice_tax 0.0000
invoice_shipping 18.6700
invoice_total 34.6600
invoice_qty 1
invoice_price 34.6600
invoice_currency_code USD
invoice_price_site 27731.0000
invoice_currency_code_site CL
invoice_change_rate 800.0000
invoice_total_commission 4992.0000
adjust_discount_value 0.2800
created_at 2021-08-27 00:25:06