https://ripleyperu-prod.mirakl.net/api/orders?paginate=true&max=1&offset=200
{"orders":[{"acceptance_decision_date":"2020-10-15T23:47:28Z","can_cancel":false,"can_shop_ship":false,"channel":null,"commercial_id":"30426549","created_date":"2020-10-15T23:42:48Z","currency_iso_code":"PEN","customer":{"billing_address":{"city":"MIRAFLORES","company":null,"company_2":null,"country":"PE","country_iso_code":null,"firstname":"CHRISTINA","lastname":"FLORES","phone":"013403865","phone_secondary":"990296101","state":"LIMA","street_1":"CALLE CORONEL INCLAN 421 DPT 201","street_2":"LIMA","zip_code":"LIMA18"},"civility":null,"customer_id":"40122325","firstname":"Christina","lastname":"Flores","locale":null,"shipping_address":{"additional_info":"","city":"MIRAFLORES","company":null,"company_2":null,"country":"PE","country_iso_code":null,"firstname":"CHRISTINA","lastname":"FLORES","phone":"013403865","phone_secondary":"990296101","state":"LIMA","street_1":"CALLE CORONEL INCLAN 421 DPT 201","street_2":"LIMA","zip_code":"LIMA18"}},"customer_debited_date":"2020-10-15T23:52:28.028Z","customer_directly_pays_seller":false,"customer_notification_email":"notification+noz9v4fjd8nsflg64o7oebnt6.kbd7rtf19@us.notification.mirakl.net","delivery_date":null,"fulfillment":{"center":{"code":"DEFAULT"}},"fully_refunded":true,"has_customer_message":false,"has_incident":false,"has_invoice":false,"last_updated_date":"2020-10-23T19:16:53Z","leadtime_to_ship":30,"order_additional_fields":[{"code":"dni","type":"STRING","value":"40122325"}],"order_id":"30426549-A","order_lines":[{"can_refund":false,"cancelations":[],"category_code":"Libreros y estantes","category_label":"Libreros y estantes","commission_fee":25.38,"commission_rate_vat":0,"commission_taxes":[{"amount":0,"code":"TAXDEFAULT","rate":0}],"commission_vat":0,"created_date":"2020-10-15T23:42:48Z","debited_date":"2020-10-15T23:52:28Z","description":null,"fees":[],"last_updated_date":"2020-10-23T19:16:53Z","offer_id":262290,"offer_sku":"B07WNLND34","offer_state_code":"11","order_line_additional_fields":[],"order_line_id":"85142202","order_line_index":1,"order_line_state":"REFUNDED","order_line_state_reason_code":null,"order_line_state_reason_label":null,"price":141,"price_additional_info":null,"price_amount_breakdown":{"parts":[{"amount":141,"commissionable":true,"debitable_from_customer":true,"payable_to_shop":true}]},"price_unit":141,"product_medias":[{"media_url":"\/media\/product\/image\/2601581e-ae2e-4691-b006-d1a30a537835","mime_type":"JPG","type":"LARGE"},{"media_url":"\/media\/product\/image\/83f50fdc-649f-43ce-9448-8313bacaf153","mime_type":"JPG","type":"SMALL"},{"media_url":"\/media\/product\/image\/c6b491a8-da7e-4cf2-a960-0cb0dcf8d34c","mime_type":"JPG","type":"MEDIUM"}],"product_shop_sku":"B07WNLND34","product_sku":"PMP00000989236-1","product_title":"ORGANIZADOR DE ESCRITORIO DE MADERA MULTIFUNCIONAL","promotions":[],"quantity":1,"received_date":null,"refunds":[{"amount":141,"amount_breakdown":{"parts":[{"amount":141,"commissionable":true,"debitable_from_customer":true,"payable_to_shop":true}]},"commission_amount":25.38,"commission_tax_amount":0,"commission_taxes":[{"amount":0,"code":"TAXDEFAULT"}],"commission_total_amount":25.38,"created_date":"2020-10-20T16:53:32Z","fees":[],"id":"9363","order_refund_id":"49c95cee-d375-410e-ae8f-df89892b1c65","quantity":1,"reason_code":"15","refund_state":"REFUNDED","shipping_amount":4,"shipping_amount_breakdown":{"parts":[{"amount":4,"commissionable":false,"debitable_from_customer":true,"payable_to_shop":false}]},"shipping_taxes":[],"state":"REFUNDED","taxes":[]}],"shipped_date":null,"shipping_price":4,"shipping_price_additional_unit":null,"shipping_price_amount_breakdown":{"parts":[{"amount":4,"commissionable":false,"debitable_from_customer":true,"payable_to_shop":false}]},"shipping_price_unit":null,"shipping_taxes":[],"taxes":[],"total_commission":25.38,"total_price":145},{"can_refund":false,"cancelations":[],"category_code":"Libreros y estantes","category_label":"Libreros y estantes","commission_fee":44.1,"commission_rate_vat":0,"commission_taxes":[{"amount":0,"code":"TAXDEFAULT","rate":0}],"commission_vat":0,"created_date":"2020-10-15T23:42:48Z","debited_date":"2020-10-15T23:52:28Z","description":null,"fees":[],"last_updated_date":"2020-10-23T19:16:53Z","offer_id":262287,"offer_sku":"B089136FJH","offer_state_code":"11","order_line_additional_fields":[],"order_line_id":"85142286","order_line_index":2,"order_line_state":"REFUNDED","order_line_state_reason_code":null,"order_line_state_reason_label":null,"price":245,"price_additional_info":null,"price_amount_breakdown":{"parts":[{"amount":245,"commissionable":true,"debitable_from_customer":true,"payable_to_shop":true}]},"price_unit":245,"product_medias":[{"media_url":"\/media\/product\/image\/305bb73c-abbf-43ed-9b99-5840c8928081","mime_type":"JPG","type":"LARGE"},{"media_url":"\/media\/product\/image\/3b160075-d22f-4aa6-adbc-7ecee6634a09","mime_type":"JPG","type":"SMALL"},{"media_url":"\/media\/product\/image\/f1133430-1dd7-450a-b03f-e02c9899f14e","mime_type":"JPG","type":"MEDIUM"}],"product_shop_sku":"B089136FJH","product_sku":"PMP00000989230-1","product_title":"ORGANIZADOR DE ESCRITORIO DE MADERA DE PINO","promotions":[],"quantity":1,"received_date":null,"refunds":[{"amount":245,"amount_breakdown":{"parts":[{"amount":245,"commissionable":true,"debitable_from_customer":true,"payable_to_shop":true}]},"commission_amount":44.1,"commission_tax_amount":0,"commission_taxes":[{"amount":0,"code":"TAXDEFAULT"}],"commission_total_amount":44.1,"created_date":"2020-10-20T16:53:32Z","fees":[],"id":"9362","order_refund_id":"adba06f3-4dd7-48ab-aa27-902758fec337","quantity":1,"reason_code":"15","refund_state":"REFUNDED","shipping_amount":4,"shipping_amount_breakdown":{"parts":[{"amount":4,"commissionable":false,"debitable_from_customer":true,"payable_to_shop":false}]},"shipping_taxes":[],"state":"REFUNDED","taxes":[]}],"shipped_date":null,"shipping_price":4,"shipping_price_additional_unit":null,"shipping_price_amount_breakdown":{"parts":[{"amount":4,"commissionable":false,"debitable_from_customer":true,"payable_to_shop":false}]},"shipping_price_unit":null,"shipping_taxes":[],"taxes":[],"total_commission":44.1,"total_price":249}],"order_refunds":null,"order_state":"CLOSED","order_state_reason_code":"REFUNDED","order_state_reason_label":"Reembolsado","order_tax_mode":"TAX_EXCLUDED","order_taxes":null,"paymentType":"TARJETA_PAYME","payment_type":"TARJETA_PAYME","payment_workflow":"PAY_ON_ACCEPTANCE","price":386,"promotions":{"applied_promotions":[],"total_deduced_amount":0},"quote_id":null,"shipping_carrier_code":null,"shipping_carrier_standard_code":null,"shipping_company":null,"shipping_deadline":"2020-11-14T23:47:47.396Z","shipping_price":8,"shipping_pudo_id":null,"shipping_tracking":null,"shipping_tracking_url":null,"shipping_type_code":"15a20","shipping_type_label":"Env\u00edo Internacional: Entrega a domicilio de 15 a 20 d\u00edas h\u00e1biles","shipping_type_standard_code":null,"shipping_zone_code":"201010","shipping_zone_label":"LIMA METROPOLITANA 1","total_commission":69.48,"total_price":394}],"total_count":8731}
array(23) { ["OrderDate"]=> string(19) "2020-10-15 11:42:48" ["MOrderNumber"]=> string(7) "2458890" ["SessionID"]=> string(0) "" ["OrderTotal"]=> float(101.58) ["OrderSubTotal"]=> float(51.98) ["Shipping"]=> float(49.6) ["CustomsDuties"]=> float(0) ["LocalShipping"]=> string(1) "0" ["LocalTAX"]=> string(1) "0" ["OtherAmount"]=> string(1) "0" ["PaymentType"]=> string(14) "VENDORTRANSFER" ["CreditCardName"]=> string(0) "" ["CreditCardNumber"]=> string(0) "" ["CreditCardMonth"]=> string(0) "" ["CreditCardYear"]=> string(0) "" ["CreditCardCCV2"]=> string(0) "" ["CreditCardIBN"]=> string(0) "" ["CreditCardITelephone"]=> string(0) "" ["ReferenceNumber"]=> string(10) "30426549-A" ["OrderNotes"]=> string(70) "Order Import Ripley 30426549-A. NationalRegistrationNumber: 40122325. " ["Billing_Order"]=> array(13) { ["FirstName"]=> string(9) "CHRISTINA" ["LastName"]=> string(6) "FLORES" ["Email"]=> string(0) "" ["AddressLine1"]=> string(32) "CALLE CORONEL INCLAN 421 DPT 201" ["AddressLine2"]=> string(4) "LIMA" ["AddressLine3"]=> string(2) "--" ["City"]=> string(10) "MIRAFLORES" ["State"]=> string(4) "LIMA" ["Zipcode"]=> string(6) "LIMA18" ["Country"]=> string(2) "PE" ["PhoneNumber1"]=> string(9) "013403865" ["PhoneNumber2"]=> string(9) "990296101" ["DocumentID"]=> string(8) "40122325" } ["Shipping_Order"]=> array(13) { ["FirstName"]=> string(9) "CHRISTINA" ["LastName"]=> string(6) "FLORES" ["Email"]=> string(0) "" ["AddressLine1"]=> string(32) "CALLE CORONEL INCLAN 421 DPT 201" ["AddressLine2"]=> string(4) "LIMA" ["AddressLine3"]=> string(2) "--" ["City"]=> string(10) "MIRAFLORES" ["State"]=> string(4) "LIMA" ["Zipcode"]=> string(6) "LIMA18" ["Country"]=> string(2) "PE" ["PhoneNumber1"]=> string(9) "013403865" ["PhoneNumber2"]=> string(9) "990296101" ["DocumentID"]=> string(8) "40122325" } ["OrderDetail"]=> array(2) { [0]=> array(13) { ["ProductSKU"]=> string(10) "B07WNLND34" ["ProductQty"]=> int(1) ["ProductWeight"]=> float(1.94) ["ProductPrice"]=> float(13.99) ["ProductLink"]=> string(57) "https://www.amazon.com/dp/B07WNLND34?language=en_US&psc=1" ["ProductBrand"]=> string(0) "" ["ProductSize"]=> string(0) "" ["ProductColor"]=> string(0) "" ["ProductCountry"]=> string(2) "US" ["ProductDesc"]=> string(50) "ORGANIZADOR DE ESCRITORIO DE MADERA MULTIFUNCIONAL" ["ProductStatus"]=> string(0) "" ["TrackingURL"]=> string(0) "" ["Comments"]=> string(0) "" } [1]=> array(13) { ["ProductSKU"]=> string(10) "B089136FJH" ["ProductQty"]=> int(1) ["ProductWeight"]=> float(2.87) ["ProductPrice"]=> float(37.99) ["ProductLink"]=> string(57) "https://www.amazon.com/dp/B089136FJH?language=en_US&psc=1" ["ProductBrand"]=> string(0) "" ["ProductSize"]=> string(0) "" ["ProductColor"]=> string(0) "" ["ProductCountry"]=> string(2) "US" ["ProductDesc"]=> string(43) "ORGANIZADOR DE ESCRITORIO DE MADERA DE PINO" ["ProductStatus"]=> string(0) "" ["TrackingURL"]=> string(0) "" ["Comments"]=> string(0) "" } } }0