Shopify sales data samples
Order without a refund
{
"order": {
"id": 2198496313386,
"closed_at": "2020-07-03T04:39:09-04:00",
"created_at": "2020-07-03T04:39:00-04:00",
"updated_at": "2020-07-03T04:40:58-04:00",
"number": 540,
"note": "",
"token": "51a51edf24535774e737e65a2c2ce77b",
"gateway": "Cash on Delivery (COD)",
"test": false,
"total_price": "5043.00",
"subtotal_price": "5043.00",
"total_weight": 0,
"total_tax": "1072.13",
"taxes_included": true,
"currency": "HUF",
"financial_status": "partially_refunded",
"confirmed": true,
"total_discounts": "0.00",
"total_line_items_price": "5043.00",
"cart_token": null,
"buyer_accepts_marketing": false,
"name": "#1540",
"referring_site": null,
"landing_site": null,
"cancelled_at": null,
"cancel_reason": null,
"total_price_usd": "16.09",
"checkout_token": null,
"reference": null,
"user_id": 14863302698,
"location_id": 11493277738,
"source_identifier": null,
"source_url": null,
"processed_at": "2020-07-03T04:39:00-04:00",
"device_id": null,
"customer_locale": null,
"app_id": 1354745,
"browser_ip": null,
"landing_site_ref": null,
"order_number": 1540,
"discount_applications": [],
"discount_codes": [],
"note_attributes": [],
"payment_gateway_names": [
"Cash on Delivery (COD)"
],
"processing_method": "manual",
"checkout_id": null,
"source_name": "shopify_draft_order",
"fulfillment_status": "fulfilled",
"tax_lines": [
{
"price": "1072.13",
"rate": 0.27,
"title": "VAT",
"price_set": {
"shop_money": {
"amount": "1072.13",
"currency_code": "HUF"
},
"presentment_money": {
"amount": "1072.13",
"currency_code": "HUF"
}
}
}
],
"tags": "",
"order_status_url": "https:\/\/lifestyle-labels-production.myshopify.com\/27219602\/orders\/51a51edf24535774e737e65a2c2ce77b\/authenticate?key=25d680662cf5d5a982cd7f694f47cb8e",
"presentment_currency": "HUF",
"total_line_items_price_set": {
"shop_money": {
"amount": "5043.00",
"currency_code": "HUF"
},
"presentment_money": {
"amount": "5043.00",
"currency_code": "HUF"
}
},
"total_discounts_set": {
"shop_money": {
"amount": "0.00",
"currency_code": "HUF"
},
"presentment_money": {
"amount": "0.00",
"currency_code": "HUF"
}
},
"total_shipping_price_set": {
"shop_money": {
"amount": "0.00",
"currency_code": "HUF"
},
"presentment_money": {
"amount": "0.00",
"currency_code": "HUF"
}
},
"subtotal_price_set": {
"shop_money": {
"amount": "5043.00",
"currency_code": "HUF"
},
"presentment_money": {
"amount": "5043.00",
"currency_code": "HUF"
}
},
"total_price_set": {
"shop_money": {
"amount": "5043.00",
"currency_code": "HUF"
},
"presentment_money": {
"amount": "5043.00",
"currency_code": "HUF"
}
},
"total_tax_set": {
"shop_money": {
"amount": "1072.13",
"currency_code": "HUF"
},
"presentment_money": {
"amount": "1072.13",
"currency_code": "HUF"
}
},
"line_items": [
{
"id": 4761267601450,
"variant_id": 11778862612522,
"title": "Aback Appreciate Mellow Thread 4812",
"quantity": 1,
"sku": "4812-e11477b8",
"variant_title": "L-DarkGray",
"vendor": "Heineken",
"fulfillment_service": "manual",
"product_id": 1243279032362,
"requires_shipping": true,
"taxable": true,
"gift_card": false,
"name": "Aback Appreciate Mellow Thread 4812 - L-DarkGray",
"variant_inventory_management": "shopify",
"properties": [],
"product_exists": true,
"fulfillable_quantity": 0,
"grams": 0,
"price": "500.00",
"total_discount": "0.00",
"fulfillment_status": "fulfilled",
"price_set": {
"shop_money": {
"amount": "500.00",
"currency_code": "HUF"
},
"presentment_money": {
"amount": "500.00",
"currency_code": "HUF"
}
},
"total_discount_set": {
"shop_money": {
"amount": "0.00",
"currency_code": "HUF"
},
"presentment_money": {
"amount": "0.00",
"currency_code": "HUF"
}
},
"discount_allocations": [],
"tax_lines": [
{
"title": "VAT",
"price": "106.30",
"rate": 0.27,
"price_set": {
"shop_money": {
"amount": "106.30",
"currency_code": "HUF"
},
"presentment_money": {
"amount": "106.30",
"currency_code": "HUF"
}
}
}
]
},
{
"id": 4761267634218,
"variant_id": 11783836696618,
"title": "Aback Arise Measly Bike 29587",
"quantity": 2,
"sku": "29587-e2b4add5",
"variant_title": "XXL-LightSteelBlue",
"vendor": "Lowe's",
"fulfillment_service": "manual",
"product_id": 1244762079274,
"requires_shipping": true,
"taxable": true,
"gift_card": false,
"name": "Aback Arise Measly Bike 29587 - XXL-LightSteelBlue",
"variant_inventory_management": "shopify",
"properties": [],
"product_exists": true,
"fulfillable_quantity": 0,
"grams": 0,
"price": "491.00",
"total_discount": "0.00",
"fulfillment_status": "fulfilled",
"price_set": {
"shop_money": {
"amount": "491.00",
"currency_code": "HUF"
},
"presentment_money": {
"amount": "491.00",
"currency_code": "HUF"
}
},
"total_discount_set": {
"shop_money": {
"amount": "0.00",
"currency_code": "HUF"
},
"presentment_money": {
"amount": "0.00",
"currency_code": "HUF"
}
},
"discount_allocations": [],
"tax_lines": [
{
"title": "VAT",
"price": "208.77",
"rate": 0.27,
"price_set": {
"shop_money": {
"amount": "208.77",
"currency_code": "HUF"
},
"presentment_money": {
"amount": "208.77",
"currency_code": "HUF"
}
}
}
]
},
{
"id": 4761267666986,
"variant_id": 11782975127594,
"title": "Aback Cling Devilish Farm 24253",
"quantity": 3,
"sku": "24253-1da465ca",
"variant_title": "S-DarkOliveGreen",
"vendor": "LEGO",
"fulfillment_service": "manual",
"product_id": 1244525330474,
"requires_shipping": true,
"taxable": true,
"gift_card": false,
"name": "Aback Cling Devilish Farm 24253 - S-DarkOliveGreen",
"variant_inventory_management": "shopify",
"properties": [],
"product_exists": true,
"fulfillable_quantity": 0,
"grams": 0,
"price": "35.00",
"total_discount": "0.00",
"fulfillment_status": "fulfilled",
"price_set": {
"shop_money": {
"amount": "35.00",
"currency_code": "HUF"
},
"presentment_money": {
"amount": "35.00",
"currency_code": "HUF"
}
},
"total_discount_set": {
"shop_money": {
"amount": "0.00",
"currency_code": "HUF"
},
"presentment_money": {
"amount": "0.00",
"currency_code": "HUF"
}
},
"discount_allocations": [],
"tax_lines": [
{
"title": "VAT",
"price": "22.32",
"rate": 0.27,
"price_set": {
"shop_money": {
"amount": "22.32",
"currency_code": "HUF"
},
"presentment_money": {
"amount": "22.32",
"currency_code": "HUF"
}
}
}
]
},
{
"id": 4761267699754,
"variant_id": 11778346188842,
"title": "Aback Delegate Inquisitive Basin 2048",
"quantity": 4,
"sku": "2048-7f2e9a16",
"variant_title": "XXL-Blue",
"vendor": "Gucci",
"fulfillment_service": "manual",
"product_id": 1243151269930,
"requires_shipping": true,
"taxable": true,
"gift_card": false,
"name": "Aback Delegate Inquisitive Basin 2048 - XXL-Blue",
"variant_inventory_management": "shopify",
"properties": [],
"product_exists": true,
"fulfillable_quantity": 0,
"grams": 0,
"price": "864.00",
"total_discount": "0.00",
"fulfillment_status": "fulfilled",
"price_set": {
"shop_money": {
"amount": "864.00",
"currency_code": "HUF"
},
"presentment_money": {
"amount": "864.00",
"currency_code": "HUF"
}
},
"total_discount_set": {
"shop_money": {
"amount": "0.00",
"currency_code": "HUF"
},
"presentment_money": {
"amount": "0.00",
"currency_code": "HUF"
}
},
"discount_allocations": [],
"tax_lines": [
{
"title": "VAT",
"price": "734.74",
"rate": 0.27,
"price_set": {
"shop_money": {
"amount": "734.74",
"currency_code": "HUF"
},
"presentment_money": {
"amount": "734.74",
"currency_code": "HUF"
}
}
}
]
}
],
"fulfillments": [
{
"id": 2072868454442,
"order_id": 2198496313386,
"status": "success",
"created_at": "2020-07-03T04:39:08-04:00",
"service": "manual",
"updated_at": "2020-07-03T04:39:08-04:00",
"tracking_company": null,
"shipment_status": null,
"location_id": 11493277738,
"line_items": [
{
"id": 4761267601450,
"variant_id": 11778862612522,
"title": "Aback Appreciate Mellow Thread 4812",
"quantity": 1,
"sku": "4812-e11477b8",
"variant_title": "L-DarkGray",
"vendor": "Heineken",
"fulfillment_service": "manual",
"product_id": 1243279032362,
"requires_shipping": true,
"taxable": true,
"gift_card": false,
"name": "Aback Appreciate Mellow Thread 4812 - L-DarkGray",
"variant_inventory_management": "shopify",
"properties": [],
"product_exists": true,
"fulfillable_quantity": 0,
"grams": 0,
"price": "500.00",
"total_discount": "0.00",
"fulfillment_status": "fulfilled",
"price_set": {
"shop_money": {
"amount": "500.00",
"currency_code": "HUF"
},
"presentment_money": {
"amount": "500.00",
"currency_code": "HUF"
}
},
"total_discount_set": {
"shop_money": {
"amount": "0.00",
"currency_code": "HUF"
},
"presentment_money": {
"amount": "0.00",
"currency_code": "HUF"
}
},
"discount_allocations": [],
"tax_lines": [
{
"title": "VAT",
"price": "106.30",
"rate": 0.27,
"price_set": {
"shop_money": {
"amount": "106.30",
"currency_code": "HUF"
},
"presentment_money": {
"amount": "106.30",
"currency_code": "HUF"
}
}
}
]
},
{
"id": 4761267634218,
"variant_id": 11783836696618,
"title": "Aback Arise Measly Bike 29587",
"quantity": 2,
"sku": "29587-e2b4add5",
"variant_title": "XXL-LightSteelBlue",
"vendor": "Lowe's",
"fulfillment_service": "manual",
"product_id": 1244762079274,
"requires_shipping": true,
"taxable": true,
"gift_card": false,
"name": "Aback Arise Measly Bike 29587 - XXL-LightSteelBlue",
"variant_inventory_management": "shopify",
"properties": [],
"product_exists": true,
"fulfillable_quantity": 0,
"grams": 0,
"price": "491.00",
"total_discount": "0.00",
"fulfillment_status": "fulfilled",
"price_set": {
"shop_money": {
"amount": "491.00",
"currency_code": "HUF"
},
"presentment_money": {
"amount": "491.00",
"currency_code": "HUF"
}
},
"total_discount_set": {
"shop_money": {
"amount": "0.00",
"currency_code": "HUF"
},
"presentment_money": {
"amount": "0.00",
"currency_code": "HUF"
}
},
"discount_allocations": [],
"tax_lines": [
{
"title": "VAT",
"price": "208.77",
"rate": 0.27,
"price_set": {
"shop_money": {
"amount": "208.77",
"currency_code": "HUF"
},
"presentment_money": {
"amount": "208.77",
"currency_code": "HUF"
}
}
}
]
},
{
"id": 4761267666986,
"variant_id": 11782975127594,
"title": "Aback Cling Devilish Farm 24253",
"quantity": 3,
"sku": "24253-1da465ca",
"variant_title": "S-DarkOliveGreen",
"vendor": "LEGO",
"fulfillment_service": "manual",
"product_id": 1244525330474,
"requires_shipping": true,
"taxable": true,
"gift_card": false,
"name": "Aback Cling Devilish Farm 24253 - S-DarkOliveGreen",
"variant_inventory_management": "shopify",
"properties": [],
"product_exists": true,
"fulfillable_quantity": 0,
"grams": 0,
"price": "35.00",
"total_discount": "0.00",
"fulfillment_status": "fulfilled",
"price_set": {
"shop_money": {
"amount": "35.00",
"currency_code": "HUF"
},
"presentment_money": {
"amount": "35.00",
"currency_code": "HUF"
}
},
"total_discount_set": {
"shop_money": {
"amount": "0.00",
"currency_code": "HUF"
},
"presentment_money": {
"amount": "0.00",
"currency_code": "HUF"
}
},
"discount_allocations": [],
"tax_lines": [
{
"title": "VAT",
"price": "22.32",
"rate": 0.27,
"price_set": {
"shop_money": {
"amount": "22.32",
"currency_code": "HUF"
},
"presentment_money": {
"amount": "22.32",
"currency_code": "HUF"
}
}
}
]
},
{
"id": 4761267699754,
"variant_id": 11778346188842,
"title": "Aback Delegate Inquisitive Basin 2048",
"quantity": 4,
"sku": "2048-7f2e9a16",
"variant_title": "XXL-Blue",
"vendor": "Gucci",
"fulfillment_service": "manual",
"product_id": 1243151269930,
"requires_shipping": true,
"taxable": true,
"gift_card": false,
"name": "Aback Delegate Inquisitive Basin 2048 - XXL-Blue",
"variant_inventory_management": "shopify",
"properties": [],
"product_exists": true,
"fulfillable_quantity": 0,
"grams": 0,
"price": "864.00",
"total_discount": "0.00",
"fulfillment_status": "fulfilled",
"price_set": {
"shop_money": {
"amount": "864.00",
"currency_code": "HUF"
},
"presentment_money": {
"amount": "864.00",
"currency_code": "HUF"
}
},
"total_discount_set": {
"shop_money": {
"amount": "0.00",
"currency_code": "HUF"
},
"presentment_money": {
"amount": "0.00",
"currency_code": "HUF"
}
},
"discount_allocations": [],
"tax_lines": [
{
"title": "VAT",
"price": "734.74",
"rate": 0.27,
"price_set": {
"shop_money": {
"amount": "734.74",
"currency_code": "HUF"
},
"presentment_money": {
"amount": "734.74",
"currency_code": "HUF"
}
}
}
]
}
],
"tracking_number": null,
"tracking_numbers": [],
"tracking_url": null,
"tracking_urls": [],
"receipt": {},
"name": "#1540.1"
}
],
"refunds": [
{
"id": 650362847274,
"order_id": 2198496313386,
"created_at": "2020-07-03T04:40:58-04:00",
"note": "",
"user_id": 14863302698,
"processed_at": "2020-07-03T04:40:58-04:00",
"restock": true,
"refund_line_items": [
{
"id": 155350171690,
"quantity": 1,
"line_item_id": 4761267634218,
"location_id": 11493277738,
"restock_type": "return",
"subtotal": 491.0,
"total_tax": 104.38,
"subtotal_set": {
"shop_money": {
"amount": "491.00",
"currency_code": "HUF"
},
"presentment_money": {
"amount": "491.00",
"currency_code": "HUF"
}
},
"total_tax_set": {
"shop_money": {
"amount": "104.38",
"currency_code": "HUF"
},
"presentment_money": {
"amount": "104.38",
"currency_code": "HUF"
}
},
"line_item": {
"id": 4761267634218,
"variant_id": 11783836696618,
"title": "Aback Arise Measly Bike 29587",
"quantity": 2,
"sku": "29587-e2b4add5",
"variant_title": "XXL-LightSteelBlue",
"vendor": "Lowe's",
"fulfillment_service": "manual",
"product_id": 1244762079274,
"requires_shipping": true,
"taxable": true,
"gift_card": false,
"name": "Aback Arise Measly Bike 29587 - XXL-LightSteelBlue",
"variant_inventory_management": "shopify",
"properties": [],
"product_exists": true,
"fulfillable_quantity": 0,
"grams": 0,
"price": "491.00",
"total_discount": "0.00",
"fulfillment_status": "fulfilled",
"price_set": {
"shop_money": {
"amount": "491.00",
"currency_code": "HUF"
},
"presentment_money": {
"amount": "491.00",
"currency_code": "HUF"
}
},
"total_discount_set": {
"shop_money": {
"amount": "0.00",
"currency_code": "HUF"
},
"presentment_money": {
"amount": "0.00",
"currency_code": "HUF"
}
},
"discount_allocations": [],
"tax_lines": [
{
"title": "VAT",
"price": "208.77",
"rate": 0.27,
"price_set": {
"shop_money": {
"amount": "208.77",
"currency_code": "HUF"
},
"presentment_money": {
"amount": "208.77",
"currency_code": "HUF"
}
}
}
]
}
},
{
"id": 155350204458,
"quantity": 3,
"line_item_id": 4761267666986,
"location_id": 11493277738,
"restock_type": "return",
"subtotal": 105.0,
"total_tax": 22.32,
"subtotal_set": {
"shop_money": {
"amount": "105.00",
"currency_code": "HUF"
},
"presentment_money": {
"amount": "105.00",
"currency_code": "HUF"
}
},
"total_tax_set": {
"shop_money": {
"amount": "22.32",
"currency_code": "HUF"
},
"presentment_money": {
"amount": "22.32",
"currency_code": "HUF"
}
},
"line_item": {
"id": 4761267666986,
"variant_id": 11782975127594,
"title": "Aback Cling Devilish Farm 24253",
"quantity": 3,
"sku": "24253-1da465ca",
"variant_title": "S-DarkOliveGreen",
"vendor": "LEGO",
"fulfillment_service": "manual",
"product_id": 1244525330474,
"requires_shipping": true,
"taxable": true,
"gift_card": false,
"name": "Aback Cling Devilish Farm 24253 - S-DarkOliveGreen",
"variant_inventory_management": "shopify",
"properties": [],
"product_exists": true,
"fulfillable_quantity": 0,
"grams": 0,
"price": "35.00",
"total_discount": "0.00",
"fulfillment_status": "fulfilled",
"price_set": {
"shop_money": {
"amount": "35.00",
"currency_code": "HUF"
},
"presentment_money": {
"amount": "35.00",
"currency_code": "HUF"
}
},
"total_discount_set": {
"shop_money": {
"amount": "0.00",
"currency_code": "HUF"
},
"presentment_money": {
"amount": "0.00",
"currency_code": "HUF"
}
},
"discount_allocations": [],
"tax_lines": [
{
"title": "VAT",
"price": "22.32",
"rate": 0.27,
"price_set": {
"shop_money": {
"amount": "22.32",
"currency_code": "HUF"
},
"presentment_money": {
"amount": "22.32",
"currency_code": "HUF"
}
}
}
]
}
},
{
"id": 155350237226,
"quantity": 1,
"line_item_id": 4761267601450,
"location_id": 11493277738,
"restock_type": "return",
"subtotal": 500.0,
"total_tax": 106.3,
"subtotal_set": {
"shop_money": {
"amount": "500.00",
"currency_code": "HUF"
},
"presentment_money": {
"amount": "500.00",
"currency_code": "HUF"
}
},
"total_tax_set": {
"shop_money": {
"amount": "106.30",
"currency_code": "HUF"
},
"presentment_money": {
"amount": "106.30",
"currency_code": "HUF"
}
},
"line_item": {
"id": 4761267601450,
"variant_id": 11778862612522,
"title": "Aback Appreciate Mellow Thread 4812",
"quantity": 1,
"sku": "4812-e11477b8",
"variant_title": "L-DarkGray",
"vendor": "Heineken",
"fulfillment_service": "manual",
"product_id": 1243279032362,
"requires_shipping": true,
"taxable": true,
"gift_card": false,
"name": "Aback Appreciate Mellow Thread 4812 - L-DarkGray",
"variant_inventory_management": "shopify",
"properties": [],
"product_exists": true,
"fulfillable_quantity": 0,
"grams": 0,
"price": "500.00",
"total_discount": "0.00",
"fulfillment_status": "fulfilled",
"price_set": {
"shop_money": {
"amount": "500.00",
"currency_code": "HUF"
},
"presentment_money": {
"amount": "500.00",
"currency_code": "HUF"
}
},
"total_discount_set": {
"shop_money": {
"amount": "0.00",
"currency_code": "HUF"
},
"presentment_money": {
"amount": "0.00",
"currency_code": "HUF"
}
},
"discount_allocations": [],
"tax_lines": [
{
"title": "VAT",
"price": "106.30",
"rate": 0.27,
"price_set": {
"shop_money": {
"amount": "106.30",
"currency_code": "HUF"
},
"presentment_money": {
"amount": "106.30",
"currency_code": "HUF"
}
}
}
]
}
}
],
"transactions": [
{
"id": 2787302604842,
"order_id": 2198496313386,
"kind": "refund",
"gateway": "Cash on Delivery (COD)",
"status": "success",
"message": "Refunded 10.00 from manual gateway",
"created_at": "2020-07-03T04:40:57-04:00",
"test": false,
"authorization": null,
"location_id": null,
"user_id": 14863302698,
"parent_id": 2787300900906,
"processed_at": "2020-07-03T04:40:57-04:00",
"device_id": null,
"receipt": {},
"error_code": null,
"source_name": "1830279",
"amount": "10.00",
"currency": "HUF"
}
],
"order_adjustments": [
{
"id": 93421666346,
"order_id": 2198496313386,
"refund_id": 650362847274,
"amount": "1086.00",
"tax_amount": "0.00",
"kind": "refund_discrepancy",
"reason": "Refund discrepancy",
"amount_set": {
"shop_money": {
"amount": "1086.00",
"currency_code": "HUF"
},
"presentment_money": {
"amount": "1086.00",
"currency_code": "HUF"
}
},
"tax_amount_set": {
"shop_money": {
"amount": "0.00",
"currency_code": "HUF"
},
"presentment_money": {
"amount": "0.00",
"currency_code": "HUF"
}
}
}
]
}
],
"total_tip_received": "0.0",
"shipping_lines": [],
"shipping_address": {
"city": "Emarcity",
"zip": "1122",
"province": "Emaregion",
"country": "Hungary",
"company": "",
"country_code": "HU",
"province_code": null
},
"customer": {
"id": 3080615788586,
"accepts_marketing": false,
"created_at": "2020-07-02T08:08:54-04:00",
"updated_at": "2020-07-03T04:41:06-04:00",
"orders_count": 1,
"state": "disabled",
"total_spent": "5033.00",
"last_order_id": 2198496313386,
"note": "",
"verified_email": true,
"multipass_identifier": null,
"tax_exempt": false,
"tags": "",
"last_order_name": "#1540",
"currency": "HUF",
"accepts_marketing_updated_at": "2020-07-03T04:04:14-04:00",
"marketing_opt_in_level": null
}
}
}
Click to copy
Refund
{
"id": 650362847274,
"note": "",
"restock": true,
"user_id": 14863302698,
"order_id": 2198496313386,
"created_at": "2020-07-03T04:40:58-04:00",
"processed_at": "2020-07-03T04:40:58-04:00",
"transactions": [
{
"id": 2787302604842,
"kind": "refund",
"test": false,
"amount": "10.00",
"status": "success",
"gateway": "Cash on Delivery (COD)",
"message": "Refunded 10.00 from manual gateway",
"receipt": {},
"user_id": 14863302698,
"currency": "HUF",
"order_id": 2198496313386,
"device_id": null,
"parent_id": 2787300900906,
"created_at": "2020-07-03T04:40:57-04:00",
"error_code": null,
"location_id": null,
"source_name": "1830279",
"processed_at": "2020-07-03T04:40:57-04:00",
"authorization": null,
"admin_graphql_api_id": "gid://shopify/OrderTransaction/2787302604842"
}
],
"order_adjustments": [
{
"id": 93421666346,
"kind": "refund_discrepancy",
"amount": "1086.00",
"reason": "Refund discrepancy",
"order_id": 2198496313386,
"refund_id": 650362847274,
"amount_set": {
"shop_money": {
"amount": "1086.00",
"currency_code": "HUF"
},
"presentment_money": {
"amount": "1086.00",
"currency_code": "HUF"
}
},
"tax_amount": "0.00",
"tax_amount_set": {
"shop_money": {
"amount": "0.00",
"currency_code": "HUF"
},
"presentment_money": {
"amount": "0.00",
"currency_code": "HUF"
}
}
}
],
"refund_line_items": [
{
"id": 155350171690,
"quantity": 1,
"subtotal": 491,
"line_item": {
"id": 4761267634218,
"sku": "29587-e2b4add5",
"name": "Aback Arise Measly Bike 29587 - XXL-LightSteelBlue",
"grams": 0,
"price": "491.00",
"title": "Aback Arise Measly Bike 29587",
"vendor": "Lowe's",
"taxable": true,
"quantity": 2,
"gift_card": false,
"price_set": {
"shop_money": {
"amount": "491.00",
"currency_code": "HUF"
},
"presentment_money": {
"amount": "491.00",
"currency_code": "HUF"
}
},
"tax_lines": [
{
"rate": 0.27,
"price": "208.77",
"title": "VAT",
"price_set": {
"shop_money": {
"amount": "208.77",
"currency_code": "HUF"
},
"presentment_money": {
"amount": "208.77",
"currency_code": "HUF"
}
}
}
],
"product_id": 1244762079274,
"properties": [],
"variant_id": 11783836696618,
"variant_title": "XXL-LightSteelBlue",
"product_exists": true,
"total_discount": "0.00",
"requires_shipping": true,
"fulfillment_status": "fulfilled",
"total_discount_set": {
"shop_money": {
"amount": "0.00",
"currency_code": "HUF"
},
"presentment_money": {
"amount": "0.00",
"currency_code": "HUF"
}
},
"fulfillment_service": "manual",
"admin_graphql_api_id": "gid://shopify/LineItem/4761267634218",
"discount_allocations": [],
"fulfillable_quantity": 0,
"variant_inventory_management": "shopify"
},
"total_tax": 104.38,
"location_id": 11493277738,
"line_item_id": 4761267634218,
"restock_type": "return",
"subtotal_set": {
"shop_money": {
"amount": "491.00",
"currency_code": "HUF"
},
"presentment_money": {
"amount": "491.00",
"currency_code": "HUF"
}
},
"total_tax_set": {
"shop_money": {
"amount": "104.38",
"currency_code": "HUF"
},
"presentment_money": {
"amount": "104.38",
"currency_code": "HUF"
}
}
},
{
"id": 155350204458,
"quantity": 3,
"subtotal": 105,
"line_item": {
"id": 4761267666986,
"sku": "24253-1da465ca",
"name": "Aback Cling Devilish Farm 24253 - S-DarkOliveGreen",
"grams": 0,
"price": "35.00",
"title": "Aback Cling Devilish Farm 24253",
"vendor": "LEGO",
"taxable": true,
"quantity": 3,
"gift_card": false,
"price_set": {
"shop_money": {
"amount": "35.00",
"currency_code": "HUF"
},
"presentment_money": {
"amount": "35.00",
"currency_code": "HUF"
}
},
"tax_lines": [
{
"rate": 0.27,
"price": "22.32",
"title": "VAT",
"price_set": {
"shop_money": {
"amount": "22.32",
"currency_code": "HUF"
},
"presentment_money": {
"amount": "22.32",
"currency_code": "HUF"
}
}
}
],
"product_id": 1244525330474,
"properties": [],
"variant_id": 11782975127594,
"variant_title": "S-DarkOliveGreen",
"product_exists": true,
"total_discount": "0.00",
"requires_shipping": true,
"fulfillment_status": "fulfilled",
"total_discount_set": {
"shop_money": {
"amount": "0.00",
"currency_code": "HUF"
},
"presentment_money": {
"amount": "0.00",
"currency_code": "HUF"
}
},
"fulfillment_service": "manual",
"admin_graphql_api_id": "gid://shopify/LineItem/4761267666986",
"discount_allocations": [],
"fulfillable_quantity": 0,
"variant_inventory_management": "shopify"
},
"total_tax": 22.32,
"location_id": 11493277738,
"line_item_id": 4761267666986,
"restock_type": "return",
"subtotal_set": {
"shop_money": {
"amount": "105.00",
"currency_code": "HUF"
},
"presentment_money": {
"amount": "105.00",
"currency_code": "HUF"
}
},
"total_tax_set": {
"shop_money": {
"amount": "22.32",
"currency_code": "HUF"
},
"presentment_money": {
"amount": "22.32",
"currency_code": "HUF"
}
}
},
{
"id": 155350237226,
"quantity": 1,
"subtotal": 500,
"line_item": {
"id": 4761267601450,
"sku": "4812-e11477b8",
"name": "Aback Appreciate Mellow Thread 4812 - L-DarkGray",
"grams": 0,
"price": "500.00",
"title": "Aback Appreciate Mellow Thread 4812",
"vendor": "Heineken",
"taxable": true,
"quantity": 1,
"gift_card": false,
"price_set": {
"shop_money": {
"amount": "500.00",
"currency_code": "HUF"
},
"presentment_money": {
"amount": "500.00",
"currency_code": "HUF"
}
},
"tax_lines": [
{
"rate": 0.27,
"price": "106.30",
"title": "VAT",
"price_set": {
"shop_money": {
"amount": "106.30",
"currency_code": "HUF"
},
"presentment_money": {
"amount": "106.30",
"currency_code": "HUF"
}
}
}
],
"product_id": 1243279032362,
"properties": [],
"variant_id": 11778862612522,
"variant_title": "L-DarkGray",
"product_exists": true,
"total_discount": "0.00",
"requires_shipping": true,
"fulfillment_status": "fulfilled",
"total_discount_set": {
"shop_money": {
"amount": "0.00",
"currency_code": "HUF"
},
"presentment_money": {
"amount": "0.00",
"currency_code": "HUF"
}
},
"fulfillment_service": "manual",
"admin_graphql_api_id": "gid://shopify/LineItem/4761267601450",
"discount_allocations": [],
"fulfillable_quantity": 0,
"variant_inventory_management": "shopify"
},
"total_tax": 106.3,
"location_id": 11493277738,
"line_item_id": 4761267601450,
"restock_type": "return",
"subtotal_set": {
"shop_money": {
"amount": "500.00",
"currency_code": "HUF"
},
"presentment_money": {
"amount": "500.00",
"currency_code": "HUF"
}
},
"total_tax_set": {
"shop_money": {
"amount": "106.30",
"currency_code": "HUF"
},
"presentment_money": {
"amount": "106.30",
"currency_code": "HUF"
}
}
}
],
"admin_graphql_api_id": "gid://shopify/Refund/650362847274"
}
Click to copy
Adobe Commerce sales data samples
Order without a refund
{
"id": 35,
"adjustment_negative": 0,
"adjustment_positive": 0,
"applied_rule_ids": "2,3",
"base_adjustment_negative": 0,
"base_adjustment_positive": 0,
"base_currency_code": "USD",
"base_discount_amount": -76.4,
"base_discount_invoiced": -76.4,
"base_discount_refunded": -30.8,
"base_grand_total": 355.6,
"base_discount_tax_compensation_amount": 0,
"base_discount_tax_compensation_invoiced": 0,
"base_discount_tax_compensation_refunded": 0,
"base_shipping_amount": 50,
"base_shipping_discount_amount": 0,
"base_shipping_discount_tax_compensation_amnt": 0,
"base_shipping_incl_tax": 50,
"base_shipping_invoiced": 50,
"base_shipping_refunded": 50,
"base_shipping_tax_amount": 0,
"base_shipping_tax_refunded": 0,
"base_subtotal": 382,
"base_subtotal_incl_tax": 382,
"base_subtotal_invoiced": 382,
"base_subtotal_refunded": 154,
"base_tax_amount": 0,
"base_tax_invoiced": 0,
"base_tax_refunded": 0,
"base_total_due": 0,
"base_total_invoiced": 355.6,
"base_total_invoiced_cost": 0,
"base_total_offline_refunded": 173.2,
"base_total_paid": 355.6,
"base_total_refunded": 173.2,
"base_to_global_rate": 1,
"base_to_order_rate": 1,
"billing_address_id": 70,
"created_at": "2020-07-03 08:57:33",
"customer_gender": 0,
"customer_group_id": 1,
"customer_id": 5,
"customer_is_guest": 0,
"customer_note_notify": 0,
"discount_amount": -76.4,
"discount_invoiced": -76.4,
"discount_refunded": -30.8,
"email_sent": 1,
"entity_id": 35,
"global_currency_code": "USD",
"grand_total": 355.6,
"discount_tax_compensation_amount": 0,
"discount_tax_compensation_invoiced": 0,
"discount_tax_compensation_refunded": 0,
"increment_id": "000000035",
"is_virtual": 0,
"order_currency_code": "USD",
"protect_code": "59ee7e877fd382d6f0fcc21ec45e2c80",
"quote_id": 46,
"remote_ip": "10.56.1.3",
"shipping_amount": 50,
"shipping_description": "Flat Rate - Fixed",
"shipping_discount_amount": 0,
"shipping_discount_tax_compensation_amount": 0,
"shipping_incl_tax": 50,
"shipping_invoiced": 50,
"shipping_refunded": 50,
"shipping_tax_amount": 0,
"shipping_tax_refunded": 0,
"state": "complete",
"status": "complete",
"store_currency_code": "USD",
"store_id": 1,
"store_name": "Main Website\nMain Website Store\nDefault Store View",
"store_to_base_rate": 0,
"store_to_order_rate": 0,
"subtotal": 382,
"subtotal_incl_tax": 382,
"subtotal_invoiced": 382,
"subtotal_refunded": 154,
"tax_amount": 0,
"tax_invoiced": 0,
"tax_refunded": 0,
"total_due": 0,
"total_invoiced": 355.6,
"total_item_count": 4,
"total_offline_refunded": 173.2,
"total_paid": 355.6,
"total_qty_ordered": 10,
"total_refunded": 173.2,
"updated_at": "2020-07-03 08:58:55",
"weight": 10,
"x_forwarded_for": "79.122.71.120",
"items": [
{
"amount_refunded": 0,
"applied_rule_ids": "2,3",
"base_amount_refunded": 0,
"base_discount_amount": 4.8,
"base_discount_invoiced": 4.8,
"base_discount_tax_compensation_amount": 0,
"base_discount_tax_compensation_invoiced": 0,
"base_original_price": 24,
"base_price": 24,
"base_price_incl_tax": 24,
"base_row_invoiced": 24,
"base_row_total": 19.2,
"base_row_total_incl_tax": 19.2,
"base_tax_amount": 0,
"base_tax_invoiced": 0,
"created_at": "2020-07-03 08:57:33",
"discount_amount": 4.8,
"discount_invoiced": 4.8,
"discount_percent": 20,
"free_shipping": 0,
"discount_tax_compensation_amount": 0,
"discount_tax_compensation_invoiced": 0,
"is_qty_decimal": 0,
"is_virtual": 0,
"item_id": 66,
"name": "Echo Fit Compression Short",
"no_discount": 0,
"order_id": 35,
"original_price": 24,
"price": 24,
"price_incl_tax": 24,
"product_id": 2003,
"product_type": "configurable",
"qty_canceled": 0,
"qty_invoiced": 1,
"qty_ordered": 1,
"qty_refunded": 0,
"qty_shipped": 1,
"quote_item_id": 87,
"row_invoiced": 24,
"row_total": 19.2,
"row_total_incl_tax": 19.2,
"row_weight": 0,
"sku": "WSH07-28-Blue",
"store_id": 1,
"tax_amount": 0,
"tax_invoiced": 0,
"tax_percent": 0,
"updated_at": "2020-07-03 08:58:16",
"weee_tax_applied": "[]",
"weight": 1,
"product_option": {
"extension_attributes": {
"configurable_item_options": [
{
"option_id": "150",
"option_value": 5599
},
{
"option_id": "93",
"option_value": 5477
}
]
}
}
},
{
"amount_refunded": 0,
"base_amount_refunded": 0,
"base_discount_amount": 0,
"base_discount_invoiced": 0,
"base_discount_tax_compensation_invoiced": 0,
"base_price": 0,
"base_row_invoiced": 0,
"base_row_total": 0,
"base_tax_amount": 0,
"base_tax_invoiced": 0,
"created_at": "2020-07-03 08:57:33",
"discount_amount": 0,
"discount_invoiced": 0,
"discount_percent": 0,
"free_shipping": 0,
"discount_tax_compensation_invoiced": 0,
"is_qty_decimal": 0,
"is_virtual": 0,
"item_id": 67,
"name": "Echo Fit Compression Short-28-Blue",
"no_discount": 0,
"order_id": 35,
"original_price": 0,
"parent_item_id": 66,
"price": 0,
"product_id": 1998,
"product_type": "simple",
"qty_canceled": 0,
"qty_invoiced": 1,
"qty_ordered": 1,
"qty_refunded": 0,
"qty_shipped": 0,
"quote_item_id": 88,
"row_invoiced": 0,
"row_total": 0,
"row_weight": 0,
"sku": "WSH07-28-Blue",
"store_id": 1,
"tax_amount": 0,
"tax_invoiced": 0,
"tax_percent": 0,
"updated_at": "2020-07-03 08:58:07",
"weight": 1,
"parent_item": {
"amount_refunded": 0,
"applied_rule_ids": "2,3",
"base_amount_refunded": 0,
"base_discount_amount": 4.8,
"base_discount_invoiced": 4.8,
"base_discount_tax_compensation_amount": 0,
"base_discount_tax_compensation_invoiced": 0,
"base_original_price": 24,
"base_price": 24,
"base_price_incl_tax": 24,
"base_row_invoiced": 24,
"base_row_total": 19.2,
"base_row_total_incl_tax": 19.2,
"base_tax_amount": 0,
"base_tax_invoiced": 0,
"created_at": "2020-07-03 08:57:33",
"discount_amount": 4.8,
"discount_invoiced": 4.8,
"discount_percent": 20,
"free_shipping": 0,
"discount_tax_compensation_amount": 0,
"discount_tax_compensation_invoiced": 0,
"is_qty_decimal": 0,
"is_virtual": 0,
"item_id": 66,
"name": "Echo Fit Compression Short",
"no_discount": 0,
"order_id": 35,
"original_price": 24,
"price": 24,
"price_incl_tax": 24,
"product_id": 2003,
"product_type": "configurable",
"qty_canceled": 0,
"qty_invoiced": 1,
"qty_ordered": 1,
"qty_refunded": 0,
"qty_shipped": 1,
"quote_item_id": 87,
"row_invoiced": 24,
"row_total": 19.2,
"row_total_incl_tax": 19.2,
"row_weight": 0,
"sku": "WSH07-28-Blue",
"store_id": 1,
"tax_amount": 0,
"tax_invoiced": 0,
"tax_percent": 0,
"updated_at": "2020-07-03 08:58:16",
"weee_tax_applied": "[]",
"weight": 1,
"product_option": {
"extension_attributes": {
"configurable_item_options": [
{
"option_id": "150",
"option_value": 5599
},
{
"option_id": "93",
"option_value": 5477
}
]
}
}
},
"row_total_incl_tax": 0,
"base_row_total_incl_tax": 0
},
{
"amount_refunded": 58,
"applied_rule_ids": "2,3",
"base_amount_refunded": 58,
"base_discount_amount": 11.6,
"base_discount_invoiced": 11.6,
"base_discount_refunded": 11.6,
"base_discount_tax_compensation_amount": 0,
"base_discount_tax_compensation_invoiced": 0,
"base_discount_tax_compensation_refunded": 0,
"base_original_price": 29,
"base_price": 29,
"base_price_incl_tax": 29,
"base_row_invoiced": 58,
"base_row_total": 46.4,
"base_row_total_incl_tax": 46.4,
"base_tax_amount": 0,
"base_tax_invoiced": 0,
"base_tax_refunded": 0,
"created_at": "2020-07-03 08:57:33",
"discount_amount": 11.6,
"discount_invoiced": 11.6,
"discount_percent": 20,
"discount_refunded": 11.6,
"free_shipping": 0,
"discount_tax_compensation_amount": 0,
"discount_tax_compensation_invoiced": 0,
"discount_tax_compensation_refunded": 0,
"is_qty_decimal": 0,
"is_virtual": 0,
"item_id": 68,
"name": "Fiona Fitness Short",
"no_discount": 0,
"order_id": 35,
"original_price": 29,
"price": 29,
"price_incl_tax": 29,
"product_id": 1925,
"product_type": "configurable",
"qty_canceled": 0,
"qty_invoiced": 2,
"qty_ordered": 2,
"qty_refunded": 2,
"qty_shipped": 2,
"quote_item_id": 89,
"row_invoiced": 58,
"row_total": 46.4,
"row_total_incl_tax": 46.4,
"row_weight": 0,
"sku": "WSH01-28-Green",
"store_id": 1,
"tax_amount": 0,
"tax_invoiced": 0,
"tax_percent": 0,
"tax_refunded": 0,
"updated_at": "2020-07-03 08:58:55",
"weee_tax_applied": "[]",
"weight": 1,
"product_option": {
"extension_attributes": {
"configurable_item_options": [
{
"option_id": "150",
"option_value": 5599
},
{
"option_id": "93",
"option_value": 5480
}
]
}
}
},
{
"amount_refunded": 0,
"base_amount_refunded": 0,
"base_discount_amount": 0,
"base_discount_invoiced": 0,
"base_discount_refunded": 0,
"base_discount_tax_compensation_invoiced": 0,
"base_discount_tax_compensation_refunded": 0,
"base_price": 0,
"base_row_invoiced": 0,
"base_row_total": 0,
"base_tax_amount": 0,
"base_tax_invoiced": 0,
"base_tax_refunded": 0,
"created_at": "2020-07-03 08:57:33",
"discount_amount": 0,
"discount_invoiced": 0,
"discount_percent": 0,
"discount_refunded": 0,
"free_shipping": 0,
"discount_tax_compensation_invoiced": 0,
"discount_tax_compensation_refunded": 0,
"is_qty_decimal": 0,
"is_virtual": 0,
"item_id": 69,
"name": "Fiona Fitness Short-28-Green",
"no_discount": 0,
"order_id": 35,
"original_price": 0,
"parent_item_id": 68,
"price": 0,
"product_id": 1911,
"product_type": "simple",
"qty_canceled": 0,
"qty_invoiced": 2,
"qty_ordered": 2,
"qty_refunded": 2,
"qty_shipped": 0,
"quote_item_id": 90,
"row_invoiced": 0,
"row_total": 0,
"row_weight": 0,
"sku": "WSH01-28-Green",
"store_id": 1,
"tax_amount": 0,
"tax_invoiced": 0,
"tax_percent": 0,
"tax_refunded": 0,
"updated_at": "2020-07-03 08:58:55",
"weight": 1,
"parent_item": {
"amount_refunded": 58,
"applied_rule_ids": "2,3",
"base_amount_refunded": 58,
"base_discount_amount": 11.6,
"base_discount_invoiced": 11.6,
"base_discount_refunded": 11.6,
"base_discount_tax_compensation_amount": 0,
"base_discount_tax_compensation_invoiced": 0,
"base_discount_tax_compensation_refunded": 0,
"base_original_price": 29,
"base_price": 29,
"base_price_incl_tax": 29,
"base_row_invoiced": 58,
"base_row_total": 46.4,
"base_row_total_incl_tax": 46.4,
"base_tax_amount": 0,
"base_tax_invoiced": 0,
"base_tax_refunded": 0,
"created_at": "2020-07-03 08:57:33",
"discount_amount": 11.6,
"discount_invoiced": 11.6,
"discount_percent": 20,
"discount_refunded": 11.6,
"free_shipping": 0,
"discount_tax_compensation_amount": 0,
"discount_tax_compensation_invoiced": 0,
"discount_tax_compensation_refunded": 0,
"is_qty_decimal": 0,
"is_virtual": 0,
"item_id": 68,
"name": "Fiona Fitness Short",
"no_discount": 0,
"order_id": 35,
"original_price": 29,
"price": 29,
"price_incl_tax": 29,
"product_id": 1925,
"product_type": "configurable",
"qty_canceled": 0,
"qty_invoiced": 2,
"qty_ordered": 2,
"qty_refunded": 2,
"qty_shipped": 2,
"quote_item_id": 89,
"row_invoiced": 58,
"row_total": 46.4,
"row_total_incl_tax": 46.4,
"row_weight": 0,
"sku": "WSH01-28-Green",
"store_id": 1,
"tax_amount": 0,
"tax_invoiced": 0,
"tax_percent": 0,
"tax_refunded": 0,
"updated_at": "2020-07-03 08:58:55",
"weee_tax_applied": "[]",
"weight": 1,
"product_option": {
"extension_attributes": {
"configurable_item_options": [
{
"option_id": "150",
"option_value": 5599
},
{
"option_id": "93",
"option_value": 5480
}
]
}
}
},
"row_total_incl_tax": 0,
"base_row_total_incl_tax": 0
},
{
"amount_refunded": 96,
"applied_rule_ids": "2,3",
"base_amount_refunded": 96,
"base_discount_amount": 28.8,
"base_discount_invoiced": 28.8,
"base_discount_refunded": 19.2,
"base_discount_tax_compensation_amount": 0,
"base_discount_tax_compensation_invoiced": 0,
"base_discount_tax_compensation_refunded": 0,
"base_original_price": 48,
"base_price": 48,
"base_price_incl_tax": 48,
"base_row_invoiced": 144,
"base_row_total": 115.2,
"base_row_total_incl_tax": 115.2,
"base_tax_amount": 0,
"base_tax_invoiced": 0,
"base_tax_refunded": 0,
"created_at": "2020-07-03 08:57:33",
"discount_amount": 28.8,
"discount_invoiced": 28.8,
"discount_percent": 20,
"discount_refunded": 19.2,
"free_shipping": 0,
"discount_tax_compensation_amount": 0,
"discount_tax_compensation_invoiced": 0,
"discount_tax_compensation_refunded": 0,
"is_qty_decimal": 0,
"is_virtual": 0,
"item_id": 70,
"name": "Ida Workout Parachute Pant",
"no_discount": 0,
"order_id": 35,
"original_price": 48,
"price": 48,
"price_incl_tax": 48,
"product_id": 1839,
"product_type": "configurable",
"qty_canceled": 0,
"qty_invoiced": 3,
"qty_ordered": 3,
"qty_refunded": 2,
"qty_shipped": 3,
"quote_item_id": 91,
"row_invoiced": 144,
"row_total": 115.2,
"row_total_incl_tax": 115.2,
"row_weight": 0,
"sku": "WP03-28-Blue",
"store_id": 1,
"tax_amount": 0,
"tax_invoiced": 0,
"tax_percent": 0,
"tax_refunded": 0,
"updated_at": "2020-07-03 08:58:55",
"weee_tax_applied": "[]",
"weight": 1,
"product_option": {
"extension_attributes": {
"configurable_item_options": [
{
"option_id": "150",
"option_value": 5599
},
{
"option_id": "93",
"option_value": 5477
}
]
}
}
},
{
"amount_refunded": 0,
"base_amount_refunded": 0,
"base_discount_amount": 0,
"base_discount_invoiced": 0,
"base_discount_refunded": 0,
"base_discount_tax_compensation_invoiced": 0,
"base_discount_tax_compensation_refunded": 0,
"base_price": 0,
"base_row_invoiced": 0,
"base_row_total": 0,
"base_tax_amount": 0,
"base_tax_invoiced": 0,
"base_tax_refunded": 0,
"created_at": "2020-07-03 08:57:33",
"discount_amount": 0,
"discount_invoiced": 0,
"discount_percent": 0,
"discount_refunded": 0,
"free_shipping": 0,
"discount_tax_compensation_invoiced": 0,
"discount_tax_compensation_refunded": 0,
"is_qty_decimal": 0,
"is_virtual": 0,
"item_id": 71,
"name": "Ida Workout Parachute Pant-28-Blue",
"no_discount": 0,
"order_id": 35,
"original_price": 0,
"parent_item_id": 70,
"price": 0,
"product_id": 1834,
"product_type": "simple",
"qty_canceled": 0,
"qty_invoiced": 3,
"qty_ordered": 3,
"qty_refunded": 2,
"qty_shipped": 0,
"quote_item_id": 92,
"row_invoiced": 0,
"row_total": 0,
"row_weight": 0,
"sku": "WP03-28-Blue",
"store_id": 1,
"tax_amount": 0,
"tax_invoiced": 0,
"tax_percent": 0,
"tax_refunded": 0,
"updated_at": "2020-07-03 08:58:55",
"weight": 1,
"parent_item": {
"amount_refunded": 96,
"applied_rule_ids": "2,3",
"base_amount_refunded": 96,
"base_discount_amount": 28.8,
"base_discount_invoiced": 28.8,
"base_discount_refunded": 19.2,
"base_discount_tax_compensation_amount": 0,
"base_discount_tax_compensation_invoiced": 0,
"base_discount_tax_compensation_refunded": 0,
"base_original_price": 48,
"base_price": 48,
"base_price_incl_tax": 48,
"base_row_invoiced": 144,
"base_row_total": 115.2,
"base_row_total_incl_tax": 115.2,
"base_tax_amount": 0,
"base_tax_invoiced": 0,
"base_tax_refunded": 0,
"created_at": "2020-07-03 08:57:33",
"discount_amount": 28.8,
"discount_invoiced": 28.8,
"discount_percent": 20,
"discount_refunded": 19.2,
"free_shipping": 0,
"discount_tax_compensation_amount": 0,
"discount_tax_compensation_invoiced": 0,
"discount_tax_compensation_refunded": 0,
"is_qty_decimal": 0,
"is_virtual": 0,
"item_id": 70,
"name": "Ida Workout Parachute Pant",
"no_discount": 0,
"order_id": 35,
"original_price": 48,
"price": 48,
"price_incl_tax": 48,
"product_id": 1839,
"product_type": "configurable",
"qty_canceled": 0,
"qty_invoiced": 3,
"qty_ordered": 3,
"qty_refunded": 2,
"qty_shipped": 3,
"quote_item_id": 91,
"row_invoiced": 144,
"row_total": 115.2,
"row_total_incl_tax": 115.2,
"row_weight": 0,
"sku": "WP03-28-Blue",
"store_id": 1,
"tax_amount": 0,
"tax_invoiced": 0,
"tax_percent": 0,
"tax_refunded": 0,
"updated_at": "2020-07-03 08:58:55",
"weee_tax_applied": "[]",
"weight": 1,
"product_option": {
"extension_attributes": {
"configurable_item_options": [
{
"option_id": "150",
"option_value": 5599
},
{
"option_id": "93",
"option_value": 5477
}
]
}
}
},
"row_total_incl_tax": 0,
"base_row_total_incl_tax": 0
},
{
"amount_refunded": 0,
"applied_rule_ids": "2,3",
"base_amount_refunded": 0,
"base_discount_amount": 31.2,
"base_discount_invoiced": 31.2,
"base_discount_tax_compensation_amount": 0,
"base_discount_tax_compensation_invoiced": 0,
"base_original_price": 39,
"base_price": 39,
"base_price_incl_tax": 39,
"base_row_invoiced": 156,
"base_row_total": 124.8,
"base_row_total_incl_tax": 124.8,
"base_tax_amount": 0,
"base_tax_invoiced": 0,
"created_at": "2020-07-03 08:57:33",
"discount_amount": 31.2,
"discount_invoiced": 31.2,
"discount_percent": 20,
"free_shipping": 0,
"discount_tax_compensation_amount": 0,
"discount_tax_compensation_invoiced": 0,
"is_qty_decimal": 0,
"is_virtual": 0,
"item_id": 72,
"name": "Nora Practice Tank",
"no_discount": 0,
"order_id": 35,
"original_price": 39,
"price": 39,
"price_incl_tax": 39,
"product_id": 1722,
"product_type": "configurable",
"qty_canceled": 0,
"qty_invoiced": 4,
"qty_ordered": 4,
"qty_refunded": 0,
"qty_shipped": 4,
"quote_item_id": 93,
"row_invoiced": 156,
"row_total": 124.8,
"row_total_incl_tax": 124.8,
"row_weight": 0,
"sku": "WT03-S-Red",
"store_id": 1,
"tax_amount": 0,
"tax_invoiced": 0,
"tax_percent": 0,
"updated_at": "2020-07-03 08:58:16",
"weee_tax_applied": "[]",
"weight": 1,
"product_option": {
"extension_attributes": {
"configurable_item_options": [
{
"option_id": "150",
"option_value": 5595
},
{
"option_id": "93",
"option_value": 5485
}
]
}
}
},
{
"amount_refunded": 0,
"base_amount_refunded": 0,
"base_discount_amount": 0,
"base_discount_invoiced": 0,
"base_discount_tax_compensation_invoiced": 0,
"base_price": 0,
"base_row_invoiced": 0,
"base_row_total": 0,
"base_tax_amount": 0,
"base_tax_invoiced": 0,
"created_at": "2020-07-03 08:57:33",
"discount_amount": 0,
"discount_invoiced": 0,
"discount_percent": 0,
"free_shipping": 0,
"discount_tax_compensation_invoiced": 0,
"is_qty_decimal": 0,
"is_virtual": 0,
"item_id": 73,
"name": "Nora Practice Tank-S-Red",
"no_discount": 0,
"order_id": 35,
"original_price": 0,
"parent_item_id": 72,
"price": 0,
"product_id": 1712,
"product_type": "simple",
"qty_canceled": 0,
"qty_invoiced": 4,
"qty_ordered": 4,
"qty_refunded": 0,
"qty_shipped": 0,
"quote_item_id": 94,
"row_invoiced": 0,
"row_total": 0,
"row_weight": 0,
"sku": "WT03-S-Red",
"store_id": 1,
"tax_amount": 0,
"tax_invoiced": 0,
"tax_percent": 0,
"updated_at": "2020-07-03 08:58:07",
"weight": 1,
"parent_item": {
"amount_refunded": 0,
"applied_rule_ids": "2,3",
"base_amount_refunded": 0,
"base_discount_amount": 31.2,
"base_discount_invoiced": 31.2,
"base_discount_tax_compensation_amount": 0,
"base_discount_tax_compensation_invoiced": 0,
"base_original_price": 39,
"base_price": 39,
"base_price_incl_tax": 39,
"base_row_invoiced": 156,
"base_row_total": 124.8,
"base_row_total_incl_tax": 124.8,
"base_tax_amount": 0,
"base_tax_invoiced": 0,
"created_at": "2020-07-03 08:57:33",
"discount_amount": 31.2,
"discount_invoiced": 31.2,
"discount_percent": 20,
"free_shipping": 0,
"discount_tax_compensation_amount": 0,
"discount_tax_compensation_invoiced": 0,
"is_qty_decimal": 0,
"is_virtual": 0,
"item_id": 72,
"name": "Nora Practice Tank",
"no_discount": 0,
"order_id": 35,
"original_price": 39,
"price": 39,
"price_incl_tax": 39,
"product_id": 1722,
"product_type": "configurable",
"qty_canceled": 0,
"qty_invoiced": 4,
"qty_ordered": 4,
"qty_refunded": 0,
"qty_shipped": 4,
"quote_item_id": 93,
"row_invoiced": 156,
"row_total": 124.8,
"row_total_incl_tax": 124.8,
"row_weight": 0,
"sku": "WT03-S-Red",
"store_id": 1,
"tax_amount": 0,
"tax_invoiced": 0,
"tax_percent": 0,
"updated_at": "2020-07-03 08:58:16",
"weee_tax_applied": "[]",
"weight": 1,
"product_option": {
"extension_attributes": {
"configurable_item_options": [
{
"option_id": "150",
"option_value": 5595
},
{
"option_id": "93",
"option_value": 5485
}
]
}
}
},
"row_total_incl_tax": 0,
"base_row_total_incl_tax": 0
}
],
"billing_address": {
"address_type": "billing",
"city": "Emarcity",
"country_id": "HU",
"entity_id": 70,
"parent_id": 35,
"postcode": "1234",
},
"payment": {
"account_status": null,
"additional_information": [
"Check \/ Money order"
],
"amount_ordered": 355.6,
"amount_paid": 355.6,
"amount_refunded": 173.2,
"base_amount_ordered": 355.6,
"base_amount_paid": 355.6,
"base_amount_refunded": 173.2,
"base_shipping_amount": 50,
"base_shipping_captured": 50,
"base_shipping_refunded": 50,
"cc_last4": null,
"entity_id": 35,
"method": "checkmo",
"parent_id": 35,
"shipping_amount": 50,
"shipping_captured": 50,
"shipping_refunded": 50
},
"status_histories": [
{
"comment": "We refunded $173.20 offline.",
"created_at": "2020-07-03 08:58:55",
"entity_id": 24,
"entity_name": "creditmemo",
"is_customer_notified": 0,
"is_visible_on_front": 0,
"parent_id": 35,
"status": "complete"
}
]
}
Click to copy
Refund
{
"id": "26",
"items": [
{
"qty": 2,
"sku": "WSH01-28-Green",
"name": "Fiona Fitness Short",
"price": "29.0000",
"store_id": "1",
"base_cost": null,
"parent_id": null,
"row_total": 58,
"base_price": "29.0000",
"product_id": "1925",
"description": null,
"product_type": "configurable",
"back_to_stock": false,
"order_item_id": "68",
"base_row_total": 58,
"price_incl_tax": "29.0000",
"discount_amount": 11.6,
"weee_tax_applied": "[]",
"row_total_incl_tax": 58,
"base_price_incl_tax": "29.0000",
"base_discount_amount": 11.6,
"weee_tax_disposition": null,
"base_row_total_incl_tax": 58,
"weee_tax_applied_amount": null,
"weee_tax_row_disposition": 0,
"base_weee_tax_disposition": null,
"weee_tax_applied_row_amount": 0,
"base_weee_tax_applied_amount": null,
"base_weee_tax_row_disposition": 0,
"base_weee_tax_applied_row_amnt": null,
"base_weee_tax_applied_row_amount": 0
},
{
"qty": 2,
"sku": "WSH01-28-Green",
"name": "Fiona Fitness Short-28-Green",
"price": "0.0000",
"store_id": "1",
"base_cost": null,
"parent_id": null,
"base_price": "0.0000",
"product_id": "1911",
"description": null,
"parent_item": {
"qty": 2,
"sku": "WSH01-28-Green",
"name": "Fiona Fitness Short",
"price": "29.0000",
"store_id": "1",
"base_cost": null,
"parent_id": null,
"row_total": 58,
"base_price": "29.0000",
"product_id": "1925",
"description": null,
"product_type": "configurable",
"back_to_stock": false,
"order_item_id": "68",
"base_row_total": 58,
"price_incl_tax": "29.0000",
"discount_amount": 11.6,
"weee_tax_applied": "[]",
"row_total_incl_tax": 58,
"base_price_incl_tax": "29.0000",
"base_discount_amount": 11.6,
"weee_tax_disposition": null,
"base_row_total_incl_tax": 58,
"weee_tax_applied_amount": null,
"weee_tax_row_disposition": 0,
"base_weee_tax_disposition": null,
"weee_tax_applied_row_amount": 0,
"base_weee_tax_applied_amount": null,
"base_weee_tax_row_disposition": 0,
"base_weee_tax_applied_row_amnt": null,
"base_weee_tax_applied_row_amount": 0
},
"product_type": "simple",
"back_to_stock": false,
"order_item_id": "69",
"price_incl_tax": null,
"weee_tax_applied": null,
"base_price_incl_tax": null,
"weee_tax_disposition": null,
"weee_tax_applied_amount": null,
"weee_tax_row_disposition": null,
"base_weee_tax_disposition": null,
"weee_tax_applied_row_amount": null,
"base_weee_tax_applied_amount": null,
"base_weee_tax_row_disposition": null,
"base_weee_tax_applied_row_amnt": null
},
{
"qty": 2,
"sku": "WP03-28-Blue",
"name": "Ida Workout Parachute Pant",
"price": "48.0000",
"store_id": "1",
"base_cost": null,
"parent_id": null,
"row_total": 96,
"base_price": "48.0000",
"product_id": "1839",
"description": null,
"product_type": "configurable",
"back_to_stock": false,
"order_item_id": "70",
"base_row_total": 96,
"price_incl_tax": "48.0000",
"discount_amount": 19.2,
"weee_tax_applied": "[]",
"row_total_incl_tax": 96,
"base_price_incl_tax": "48.0000",
"base_discount_amount": 19.2,
"weee_tax_disposition": null,
"base_row_total_incl_tax": 96,
"weee_tax_applied_amount": null,
"weee_tax_row_disposition": 0,
"base_weee_tax_disposition": null,
"weee_tax_applied_row_amount": 0,
"base_weee_tax_applied_amount": null,
"base_weee_tax_row_disposition": 0,
"base_weee_tax_applied_row_amnt": null,
"base_weee_tax_applied_row_amount": 0
},
{
"qty": 2,
"sku": "WP03-28-Blue",
"name": "Ida Workout Parachute Pant-28-Blue",
"price": "0.0000",
"store_id": "1",
"base_cost": null,
"parent_id": null,
"base_price": "0.0000",
"product_id": "1834",
"description": null,
"parent_item": {
"qty": 2,
"sku": "WP03-28-Blue",
"name": "Ida Workout Parachute Pant",
"price": "48.0000",
"store_id": "1",
"base_cost": null,
"parent_id": null,
"row_total": 96,
"base_price": "48.0000",
"product_id": "1839",
"description": null,
"product_type": "configurable",
"back_to_stock": false,
"order_item_id": "70",
"base_row_total": 96,
"price_incl_tax": "48.0000",
"discount_amount": 19.2,
"weee_tax_applied": "[]",
"row_total_incl_tax": 96,
"base_price_incl_tax": "48.0000",
"base_discount_amount": 19.2,
"weee_tax_disposition": null,
"base_row_total_incl_tax": 96,
"weee_tax_applied_amount": null,
"weee_tax_row_disposition": 0,
"base_weee_tax_disposition": null,
"weee_tax_applied_row_amount": 0,
"base_weee_tax_applied_amount": null,
"base_weee_tax_row_disposition": 0,
"base_weee_tax_applied_row_amnt": null,
"base_weee_tax_applied_row_amount": 0
},
"product_type": "simple",
"back_to_stock": false,
"order_item_id": "71",
"price_incl_tax": null,
"weee_tax_applied": null,
"base_price_incl_tax": null,
"weee_tax_disposition": null,
"weee_tax_applied_amount": null,
"weee_tax_row_disposition": null,
"base_weee_tax_disposition": null,
"weee_tax_applied_row_amount": null,
"base_weee_tax_applied_amount": null,
"base_weee_tax_row_disposition": null,
"base_weee_tax_applied_row_amnt": null
}
],
"state": 2,
"order_id": "35",
"store_id": "1",
"subtotal": 154,
"addresses": {
"billing": {
"city": "Emarcity",
"prefix": null,
"region": null,
"suffix": null,
"company": null,
"postcode": "1234",
"entity_id": "70",
"parent_id": "35",
"region_id": null,
"country_id": "HU",
"customer_id": null,
"address_type": "billing",
"vat_is_valid": null,
"vat_request_id": null,
"quote_address_id": "133",
"vat_request_date": null,
"customer_address_id": null,
"vat_request_success": null
},
"shipping": {
"city": "Emarcity",
"prefix": null,
"region": null,
"street": "Emarstreet 1",
"suffix": null,
"company": null,
"postcode": "1234",
"entity_id": "69",
"parent_id": "35",
"region_id": null,
"country_id": "HU",
"customer_id": null,
"address_type": "shipping",
"vat_is_valid": null,
"vat_request_id": null,
"quote_address_id": "132",
"vat_request_date": null,
"customer_address_id": "3",
"vat_request_success": null
}
},
"base_cost": 0,
"entity_id": "26",
"total_qty": 8,
"adjustment": 0,
"created_at": "2020-07-03 08:58:54",
"tax_amount": 0,
"updated_at": "2020-07-03 08:58:54",
"customer_id": "5",
"grand_total": 173.2,
"increment_id": "000000026",
"base_subtotal": 154,
"do_transaction": false,
"base_adjustment": 0,
"base_tax_amount": 0,
"discount_amount": -30.8,
"shipping_amount": 50,
"base_grand_total": 173.2,
"customer_is_guest": "0",
"shipping_incl_tax": 50,
"subtotal_incl_tax": 154,
"base_currency_code": "USD",
"base_to_order_rate": "1.0000",
"billing_address_id": "70",
"store_to_base_rate": "0.0000",
"adjustment_negative": 0,
"adjustment_positive": 0,
"base_to_global_rate": "1.0000",
"order_currency_code": "USD",
"shipping_address_id": "69",
"shipping_tax_amount": 0,
"store_currency_code": "USD",
"store_to_order_rate": "0.0000",
"base_discount_amount": -30.8,
"base_shipping_amount": 50,
"discount_description": null,
"extension_attributes": {},
"global_currency_code": "USD",
"base_shipping_incl_tax": 50,
"base_subtotal_incl_tax": 154,
"base_adjustment_negative": 0,
"base_adjustment_positive": 0,
"base_shipping_tax_amount": 0,
"shipping_discount_amount": "0.0000",
"base_shipping_discount_amount": "0.0000",
"discount_tax_compensation_amount": 0,
"base_discount_tax_compensation_amount": 0
}
Click to copy