Error
orderListWhere: { "$and": [ { "$eq": { "IsDeleted": false } }, { "$eq": { "MemberId": "2676798" } } ] }ItemList : { "Items": [ { "AWBNumber": null, "CurrencyCountry": "USD/US", "Currency": "USD", "Country": "US", "InvoiceDate": "2025-04-15T05:11:42.317992+00:00", "InvoiceNumber": 283509, "IsDeleted": false, "IsRecurring": false, "MainOrderId": 0, "MemberId": 2676798, "OrderName": "Marketplace 17986-Market Goods", "PaymentState": "Processing", "StatusId": 11749460, "TotalCost": 0.0, "CreatedDateTime": "2025-04-15T09:11:42.368118+00:00", "HasSubscriptions": false, "HasPaidSubscription": false, "TrackingURL": null, "TransactionId": null, "AmountPaid": 0.0, "AmountPending": 0.0, "OrderCaseType": "None", "StatusShort": { "Id": 11749460, "Name": "Refunded" }, "Discount": null, "GiftVoucher": null, "Tax": null, "ShippingInfo": { "Name": null, "Cost": 0.0, "Address": null, "City": null, "State": null, "Zipcode": null, "Country": "US" }, "Member": { "Id": 2676798, "Email": "[email protected]", "FirstName": "Test", "LastName": "Test" }, "OrderLines": [ { "EntityType": "ModuleItem", "ProductId": 10722, "ProductName": "[SHIP] Economy", "ModuleId": 1984, "Quantity": 1, "UnitPrice": 0.0, "TaxRate": 0.0, "TotalPrice": 0.0, "FileName": null, "IsDownload": false, "Attributes": [], "Id": 14368799 }, { "EntityType": "ModuleItem", "ProductId": 10721, "ProductName": "[PRODUCTS]", "ModuleId": 1984, "Quantity": 1, "UnitPrice": 0.0, "TaxRate": 0.0, "TotalPrice": 0.0, "FileName": null, "IsDownload": false, "Attributes": [], "Id": 14368801 } ], "Payments": [ { "Amount": 6.77, "AmountCaptured": 6.77, "GatewayReason": null, "TransactionId": null, "Status": "Succeeded", "PaymentType": "CreditCard", "PaymentGatewayType": "stripe", "Notes": "pi_3RE5WlLisBXeAJQ326yLLHFD", "CreatedDateTime": "2025-04-15T06:11:17.745216+00:00", "Id": 14368858 }, { "Amount": -6.77, "AmountCaptured": -6.77, "GatewayReason": null, "TransactionId": null, "Status": "Succeeded", "PaymentType": "Refund", "PaymentGatewayType": "stripe", "Notes": "pi_3RE5WlLisBXeAJQ326yLLHFD", "CreatedDateTime": "2025-04-29T08:29:08.434708+00:00", "Id": 14555467 } ], "CustomCrmGroups": { "marketplaceorderinfo": { "CreatedByMnMarketpace": true, "TransactionId": "pi_3RE5WlLisBXeAJQ326yLLHFD", "ShopifyOrderId": "gid://shopify/Order/6261222047992", "MarketplaceOrderId": "15940", "IsMember": true, "SurchargePercent": "0", "ApplicationFee": "5", "BrandStoreId": "17986", "BrandStoreName": "Market Goods", "BrandStoreDiscount": "25", "OrderLineExtendedInfo": "[]", "TaxExtendedInfo": "[{\"Id\":4819,\"Title\":\"California State Tax\",\"Rate\":0.0,\"RatePercentage\":0.0,\"Amount\":0.0}]", "ShippingExtendedInfo": null, "BillingAddress": "{\"Id\":6370,\"FirstName\":\"oleksii\",\"LastName\":\"iagolnyk\",\"Phone\":\"9418991889\",\"Address1\":\"11 Kewen Way\",\"City\":\"Aliso Viejo\",\"State\":\"CA\",\"CountryCode\":\"US\",\"Zip\":\"92656\"}", "ShippingAddress": "{\"ShippingNotes\":\"\",\"Id\":6370,\"FirstName\":\"oleksii\",\"LastName\":\"iagolnyk\",\"Phone\":\"9418991889\",\"Address1\":\"11 Kewen Way\",\"City\":\"Aliso Viejo\",\"State\":\"CA\",\"CountryCode\":\"US\",\"Zip\":\"92656\"}", "OrderSummary": "{\"SubTotalPrice\":0.00,\"NotMemberSurcharge\":0.00,\"TotalSavedPrice\":0.00,\"TotalTaxPrice\":0.0,\"SubtotalWithTax\":0.00,\"TotalShippingPrice\":0.0,\"TotalGiftCardPrice\":0.0,\"TotalPrice\":0.00}", "ReturnLineExtendedInfo": "[{\"Id\":0,\"ShopifyOrderLineItemId\":\"gid://shopify/LineItem/15216023994616\",\"Name\":\"A2Z 200 mg Ibuprofen (30 Tablets)\",\"ProductTitle\":\"A2Z 200 mg Ibuprofen (30 Tablets)\",\"Image\":\"https://cdn.shopify.com/s/files/1/0724/3277/9512/files/healtha2z_ibuprofen_200mg_30count_01_9c49709a-9aa1-426b-9956-5073a22e6ba1.jpg?v=1734973810\",\"FeaturedImage\":\"https://cdn.shopify.com/s/files/1/0724/3277/9512/files/healtha2z_ibuprofen_200mg_30count_01_9c49709a-9aa1-426b-9956-5073a22e6ba1.jpg?v=1734973810\",\"Quantity\":1,\"ActualUnitPrice\":1.87,\"OriginalUnitPrice\":2.49,\"DiscountedPrice\":1.8675,\"SavedPrice\":0.6225,\"TotalTaxPrice\":0.0,\"Variants\":{\"Id\":16139,\"ShopifyVariantId\":\"gid://shopify/ProductVariant/46004172914936\",\"Image\":null,\"DisplayName\":\"A2Z 200 mg Ibuprofen (30 Tablets) - Default Title\",\"Title\":\"Default Title\",\"SelectedOptions\":[{\"Name\":\"Title\",\"Value\":\"Default Title\"}]},\"NonRefundable\":false,\"Reason\":null,\"CMSProductUrl\":\"/brand-store/market-goods-1/a2z-30ct-ibuprofen-200mg-brown\"}]" } }, "ShippingCountry": "US", "Id": 14368780 }, { "AWBNumber": null, "CurrencyCountry": "USD/US", "Currency": "USD", "Country": "US", "InvoiceDate": "2025-04-15T04:59:19.915203+00:00", "InvoiceNumber": 283508, "IsDeleted": false, "IsRecurring": false, "MainOrderId": 0, "MemberId": 2676798, "OrderName": "Marketplace 17986-Market Goods", "PaymentState": "Processing", "StatusId": 11749460, "TotalCost": 0.0, "CreatedDateTime": "2025-04-15T08:59:19.963468+00:00", "HasSubscriptions": false, "HasPaidSubscription": false, "TrackingURL": null, "TransactionId": null, "AmountPaid": 0.0, "AmountPending": 0.0, "OrderCaseType": "None", "StatusShort": { "Id": 11749460, "Name": "Refunded" }, "Discount": null, "GiftVoucher": null, "Tax": null, "ShippingInfo": { "Name": null, "Cost": 0.0, "Address": null, "City": null, "State": null, "Zipcode": null, "Country": "US" }, "Member": { "Id": 2676798, "Email": "[email protected]", "FirstName": "Test", "LastName": "Test" }, "OrderLines": [ { "EntityType": "ModuleItem", "ProductId": 10722, "ProductName": "[SHIP] Economy", "ModuleId": 1984, "Quantity": 1, "UnitPrice": 0.0, "TaxRate": 0.0, "TotalPrice": 0.0, "FileName": null, "IsDownload": false, "Attributes": [], "Id": 14368763 }, { "EntityType": "ModuleItem", "ProductId": 10721, "ProductName": "[PRODUCTS]", "ModuleId": 1984, "Quantity": 1, "UnitPrice": 0.0, "TaxRate": 0.0, "TotalPrice": 0.0, "FileName": null, "IsDownload": false, "Attributes": [], "Id": 14368765 } ], "Payments": [ { "Amount": 6.77, "AmountCaptured": 6.77, "GatewayReason": null, "TransactionId": null, "Status": "Succeeded", "PaymentType": "CreditCard", "PaymentGatewayType": "stripe", "Notes": "pi_3RE5KnLisBXeAJQ31979MjOJ", "CreatedDateTime": "2025-04-15T04:59:35.881168+00:00", "Id": 14368767 }, { "Amount": -6.77, "AmountCaptured": -6.77, "GatewayReason": null, "TransactionId": null, "Status": "Succeeded", "PaymentType": "Refund", "PaymentGatewayType": "stripe", "Notes": "pi_3RE5KnLisBXeAJQ31979MjOJ", "CreatedDateTime": "2025-04-16T09:07:50.607487+00:00", "Id": 14382554 } ], "CustomCrmGroups": { "marketplaceorderinfo": { "CreatedByMnMarketpace": true, "TransactionId": "pi_3RE5KnLisBXeAJQ31979MjOJ", "ShopifyOrderId": "gid://shopify/Order/6261213069560", "MarketplaceOrderId": "15907", "IsMember": true, "SurchargePercent": "0", "ApplicationFee": "5", "BrandStoreId": "17986", "BrandStoreName": "Market Goods", "BrandStoreDiscount": "25", "TaxExtendedInfo": "[{\"Id\":4786,\"Title\":\"California State Tax\",\"Rate\":0.0,\"RatePercentage\":0.0,\"Amount\":0.0}]", "BillingAddress": "{\"Id\":6337,\"FirstName\":\"oleksii\",\"LastName\":\"iagolnyk\",\"Phone\":\"9418991889\",\"Address1\":\"11 Kewen Way\",\"City\":\"Aliso Viejo\",\"State\":\"CA\",\"CountryCode\":\"US\",\"Zip\":\"92656\"}", "ShippingAddress": "{\"ShippingNotes\":\"\",\"Id\":6337,\"FirstName\":\"oleksii\",\"LastName\":\"iagolnyk\",\"Phone\":\"9418991889\",\"Address1\":\"11 Kewen Way\",\"City\":\"Aliso Viejo\",\"State\":\"CA\",\"CountryCode\":\"US\",\"Zip\":\"92656\"}", "OrderLineExtendedInfo": "[]", "ReturnLineExtendedInfo": "[{\"Id\":0,\"ShopifyOrderLineItemId\":\"gid://shopify/LineItem/15216011313400\",\"Name\":\"200' Cling Wrap - 12 Microns\",\"ProductTitle\":\"200' Cling Wrap - 12 Microns\",\"Image\":\"https://cdn.shopify.com/s/files/1/0724/3277/9512/files/freshrite_clingwrap_clearfoodwrap_200sqfeet_01.jpg?v=1740433193\",\"FeaturedImage\":\"https://cdn.shopify.com/s/files/1/0724/3277/9512/files/freshrite_clingwrap_clearfoodwrap_200sqfeet_01.jpg?v=1740433193\",\"Quantity\":1,\"ActualUnitPrice\":1.87,\"OriginalUnitPrice\":2.49,\"DiscountedPrice\":1.8675,\"SavedPrice\":0.6225,\"TotalTaxPrice\":0.0,\"Variants\":{\"Id\":16106,\"ShopifyVariantId\":\"gid://shopify/ProductVariant/46201795444984\",\"Image\":null,\"DisplayName\":\"200' Cling Wrap - 12 Microns - Default Title\",\"Title\":\"Default Title\",\"SelectedOptions\":[{\"Name\":\"Title\",\"Value\":\"Default Title\"}]},\"NonRefundable\":false,\"Reason\":null,\"CMSProductUrl\":\"/brand-store/market-goods-1/200-cling-wrap-12-microns\"}]", "ShippingExtendedInfo": null, "OrderSummary": "{\"SubTotalPrice\":0.00,\"NotMemberSurcharge\":0.00,\"TotalSavedPrice\":0.00,\"TotalTaxPrice\":0.0,\"SubtotalWithTax\":0.00,\"TotalShippingPrice\":0.0,\"TotalGiftCardPrice\":0.0,\"TotalPrice\":0.00}" } }, "ShippingCountry": "US", "Id": 14368744 }, { "AWBNumber": null, "CurrencyCountry": "USD/US", "Currency": "USD", "Country": "US", "InvoiceDate": "2025-04-14T11:22:00.655822+00:00", "InvoiceNumber": 283250, "IsDeleted": false, "IsRecurring": false, "MainOrderId": 0, "MemberId": 2676798, "OrderName": "Marketplace 17986-Market Goods", "PaymentState": "Processing", "StatusId": 11749460, "TotalCost": 0.0, "CreatedDateTime": "2025-04-14T15:22:00.710872+00:00", "HasSubscriptions": false, "HasPaidSubscription": false, "TrackingURL": null, "TransactionId": null, "AmountPaid": 0.0, "AmountPending": 0.0, "OrderCaseType": "None", "StatusShort": { "Id": 11749460, "Name": "Refunded" }, "Discount": null, "GiftVoucher": null, "Tax": null, "ShippingInfo": { "Name": null, "Cost": 0.0, "Address": null, "City": null, "State": null, "Zipcode": null, "Country": "US" }, "Member": { "Id": 2676798, "Email": "[email protected]", "FirstName": "Test", "LastName": "Test" }, "OrderLines": [ { "EntityType": "ModuleItem", "ProductId": 10721, "ProductName": "[PRODUCTS]", "ModuleId": 1984, "Quantity": 1, "UnitPrice": 0.0, "TaxRate": 0.0, "TotalPrice": 0.0, "FileName": null, "IsDownload": false, "Attributes": [], "Id": 14353929 }, { "EntityType": "ModuleItem", "ProductId": 10722, "ProductName": "[SHIP] Economy", "ModuleId": 1984, "Quantity": 1, "UnitPrice": 0.0, "TaxRate": 0.0, "TotalPrice": 0.0, "FileName": null, "IsDownload": false, "Attributes": [], "Id": 14353931 } ], "Payments": [ { "Amount": 6.84, "AmountCaptured": 6.84, "GatewayReason": null, "TransactionId": null, "Status": "Succeeded", "PaymentType": "CreditCard", "PaymentGatewayType": "stripe", "Notes": "pi_3RDopbLisBXeAJQ32miWl0R9", "CreatedDateTime": "2025-04-14T11:22:13.716547+00:00", "Id": 14353937 }, { "Amount": -6.84, "AmountCaptured": -6.84, "GatewayReason": null, "TransactionId": null, "Status": "Succeeded", "PaymentType": "Refund", "PaymentGatewayType": "stripe", "Notes": "pi_3RDopbLisBXeAJQ32miWl0R9", "CreatedDateTime": "2025-04-15T09:58:43.840011+00:00", "Id": 14369754 } ], "CustomCrmGroups": { "marketplaceorderinfo": { "CreatedByMnMarketpace": true, "TransactionId": "pi_3RDopbLisBXeAJQ32miWl0R9", "ShopifyOrderId": "gid://shopify/Order/6260401963256", "MarketplaceOrderId": "15157", "IsMember": true, "SurchargePercent": "0", "ApplicationFee": "5", "BrandStoreId": "17986", "BrandStoreName": "Market Goods", "BrandStoreDiscount": "25", "BillingAddress": "{\"Id\":6207,\"FirstName\":\"oleksii\",\"LastName\":\"iagolnyk\",\"Phone\":\"+19418991889\",\"Address1\":\"11 Kewen Way\",\"City\":\"Aliso Viejo\",\"State\":\"CA\",\"CountryCode\":\"US\",\"Zip\":\"92656\"}", "ShippingAddress": "{\"ShippingNotes\":\"\",\"Id\":6207,\"FirstName\":\"oleksii\",\"LastName\":\"iagolnyk\",\"Phone\":\"+19418991889\",\"Address1\":\"11 Kewen Way\",\"City\":\"Aliso Viejo\",\"State\":\"CA\",\"CountryCode\":\"US\",\"Zip\":\"92656\"}", "OrderSummary": "{\"SubTotalPrice\":0.00,\"NotMemberSurcharge\":0.00,\"TotalSavedPrice\":0.00,\"TotalTaxPrice\":0.0,\"SubtotalWithTax\":0.00,\"TotalShippingPrice\":0.0,\"TotalGiftCardPrice\":0.0,\"TotalPrice\":0.00}", "OrderLineExtendedInfo": "[]", "TaxExtendedInfo": "[{\"Id\":4656,\"Title\":\"California State Tax\",\"Rate\":0.0,\"RatePercentage\":0.0,\"Amount\":0.0}]", "ReturnLineExtendedInfo": "[{\"Id\":0,\"ShopifyOrderLineItemId\":\"gid://shopify/LineItem/15214393655544\",\"Name\":\"Double Zipper 1 qt Storage Bags (22 bags)\",\"ProductTitle\":\"Double Zipper 1 qt Storage Bags (22 bags)\",\"Image\":\"https://cdn.shopify.com/s/files/1/0724/3277/9512/files/uchoice_doublezipper_quartbags_22count_01.jpg?v=1734624943\",\"FeaturedImage\":\"https://cdn.shopify.com/s/files/1/0724/3277/9512/files/uchoice_doublezipper_quartbags_22count_01.jpg?v=1734624943\",\"Quantity\":1,\"ActualUnitPrice\":1.94,\"OriginalUnitPrice\":2.59,\"DiscountedPrice\":1.9425,\"SavedPrice\":0.6475,\"TotalTaxPrice\":0.0,\"Variants\":{\"Id\":15148,\"ShopifyVariantId\":\"gid://shopify/ProductVariant/45990951092472\",\"Image\":null,\"DisplayName\":\"Double Zipper 1 qt Storage Bags (22 bags) - Default Title\",\"Title\":\"Default Title\",\"SelectedOptions\":[{\"Name\":\"Title\",\"Value\":\"Default Title\"}]},\"NonRefundable\":false,\"Reason\":null,\"CMSProductUrl\":\"/brand-store/market-goods-1/22ct-double-zipper-1-quart-storage-bags\"}]", "TrackingCompany": "UPS", "TrackingNumber": "1Z8X330WYN33052768", "TrackingUrl": "http://wwwapps.ups.com/WebTracking/processRequest?HTMLVersion=5.0&Requester=NES&AgreeToTermsAndConditions=yes&loc=en_US&tracknum=1Z8X330WYN33052768", "ShipmentStatus": "fulfilled", "ShippingExtendedInfo": null } }, "ShippingCountry": "US", "Id": 14353911 }, { "AWBNumber": null, "CurrencyCountry": "USD/US", "Currency": "USD", "Country": "US", "InvoiceDate": "2025-02-25T11:15:35.051024+00:00", "InvoiceNumber": 256784, "IsDeleted": false, "IsRecurring": false, "MainOrderId": 0, "MemberId": 2676798, "OrderName": "[PORTAL] Sales report", "PaymentState": "None", "StatusId": 489408, "TotalCost": 20.0, "CreatedDateTime": "2025-02-25T16:15:35.063295+00:00", "HasSubscriptions": false, "HasPaidSubscription": false, "TrackingURL": null, "TransactionId": null, "AmountPaid": 0.0, "AmountPending": 20.0, "OrderCaseType": "FormCase", "StatusShort": { "Id": 489408, "Name": "Awaiting Payment" }, "Discount": null, "GiftVoucher": null, "Tax": null, "ShippingInfo": null, "Member": { "Id": 2676798, "Email": "[email protected]", "FirstName": "Test", "LastName": "Test" }, "OrderLines": [ { "EntityType": "Form", "ProductId": 0, "ProductName": "[PORTAL] Sales report", "ModuleId": 0, "Quantity": 1, "UnitPrice": 20.0, "TaxRate": 0.0, "TotalPrice": 20.0, "FileName": null, "IsDownload": false, "Attributes": [], "Id": 13466825 } ], "Payments": [], "CustomCrmGroups": {}, "ShippingCountry": "US", "Id": 13466835 }, { "AWBNumber": null, "CurrencyCountry": "USD/US", "Currency": "USD", "Country": "US", "InvoiceDate": "2025-02-25T10:38:17.250961+00:00", "InvoiceNumber": 256676, "IsDeleted": false, "IsRecurring": false, "MainOrderId": 0, "MemberId": 2676798, "OrderName": "[PORTAL] Sales report", "PaymentState": "None", "StatusId": 489408, "TotalCost": 11.0, "CreatedDateTime": "2025-02-25T15:38:17.263063+00:00", "HasSubscriptions": false, "HasPaidSubscription": false, "TrackingURL": null, "TransactionId": null, "AmountPaid": 0.0, "AmountPending": 11.0, "OrderCaseType": "FormCase", "StatusShort": { "Id": 489408, "Name": "Awaiting Payment" }, "Discount": null, "GiftVoucher": null, "Tax": null, "ShippingInfo": null, "Member": { "Id": 2676798, "Email": "[email protected]", "FirstName": "Test", "LastName": "Test" }, "OrderLines": [ { "EntityType": "Form", "ProductId": 0, "ProductName": "[PORTAL] Sales report", "ModuleId": 0, "Quantity": 1, "UnitPrice": 11.0, "TaxRate": 0.0, "TotalPrice": 11.0, "FileName": null, "IsDownload": false, "Attributes": [], "Id": 13463945 } ], "Payments": [], "CustomCrmGroups": {}, "ShippingCountry": "US", "Id": 13463955 }, { "AWBNumber": null, "CurrencyCountry": "USD/US", "Currency": "USD", "Country": "US", "InvoiceDate": "2025-02-25T10:34:06.576309+00:00", "InvoiceNumber": 256670, "IsDeleted": false, "IsRecurring": false, "MainOrderId": 0, "MemberId": 2676798, "OrderName": "[PORTAL] Sales report", "PaymentState": "None", "StatusId": 489408, "TotalCost": 11.0, "CreatedDateTime": "2025-02-25T15:34:06.591436+00:00", "HasSubscriptions": false, "HasPaidSubscription": false, "TrackingURL": null, "TransactionId": null, "AmountPaid": 0.0, "AmountPending": 11.0, "OrderCaseType": "FormCase", "StatusShort": { "Id": 489408, "Name": "Awaiting Payment" }, "Discount": null, "GiftVoucher": null, "Tax": null, "ShippingInfo": null, "Member": { "Id": 2676798, "Email": "[email protected]", "FirstName": "Test", "LastName": "Test" }, "OrderLines": [ { "EntityType": "Form", "ProductId": 0, "ProductName": "[PORTAL] Sales report", "ModuleId": 0, "Quantity": 1, "UnitPrice": 11.0, "TaxRate": 0.0, "TotalPrice": 11.0, "FileName": null, "IsDownload": false, "Attributes": [], "Id": 13463814 } ], "Payments": [], "CustomCrmGroups": {}, "ShippingCountry": "US", "Id": 13463824 }, { "AWBNumber": null, "CurrencyCountry": "USD/US", "Currency": "USD", "Country": "US", "InvoiceDate": "2025-02-20T11:40:02.410938+00:00", "InvoiceNumber": 253381, "IsDeleted": false, "IsRecurring": false, "MainOrderId": 0, "MemberId": 2676798, "OrderName": "[PORTAL] Sales report", "PaymentState": "None", "StatusId": 489408, "TotalCost": 20.0, "CreatedDateTime": "2025-02-20T16:40:02.439346+00:00", "HasSubscriptions": false, "HasPaidSubscription": false, "TrackingURL": null, "TransactionId": null, "AmountPaid": 0.0, "AmountPending": 20.0, "OrderCaseType": "FormCase", "StatusShort": { "Id": 489408, "Name": "Awaiting Payment" }, "Discount": null, "GiftVoucher": null, "Tax": null, "ShippingInfo": null, "Member": { "Id": 2676798, "Email": "[email protected]", "FirstName": "Test", "LastName": "Test" }, "OrderLines": [ { "EntityType": "Form", "ProductId": 0, "ProductName": "[PORTAL] Sales report", "ModuleId": 0, "Quantity": 1, "UnitPrice": 20.0, "TaxRate": 0.0, "TotalPrice": 20.0, "FileName": null, "IsDownload": false, "Attributes": [], "Id": 13345887 } ], "Payments": [], "CustomCrmGroups": {}, "ShippingCountry": "US", "Id": 13345897 }, { "AWBNumber": null, "CurrencyCountry": "USD/US", "Currency": "USD", "Country": "US", "InvoiceDate": "2024-12-17T11:19:04.575913+00:00", "InvoiceNumber": 223679, "IsDeleted": false, "IsRecurring": false, "MainOrderId": 0, "MemberId": 2676798, "OrderName": "Marketplace 11391-Spritzal Cookie Company", "PaymentState": "Processing", "StatusId": 489409, "TotalCost": 11.15, "CreatedDateTime": "2024-12-17T16:19:04.616323+00:00", "HasSubscriptions": false, "HasPaidSubscription": false, "TrackingURL": null, "TransactionId": null, "AmountPaid": 11.15, "AmountPending": 0.0, "OrderCaseType": "None", "StatusShort": { "Id": 489409, "Name": "Paid" }, "Discount": null, "GiftVoucher": null, "Tax": null, "ShippingInfo": { "Name": null, "Cost": 0.0, "Address": null, "City": null, "State": null, "Zipcode": null, "Country": "US" }, "Member": { "Id": 2676798, "Email": "[email protected]", "FirstName": "Test", "LastName": "Test" }, "OrderLines": [ { "EntityType": "ModuleItem", "ProductId": 10721, "ProductName": "[PRODUCTS]", "ModuleId": 1984, "Quantity": 1, "UnitPrice": 5.59, "TaxRate": 0.0, "TotalPrice": 5.59, "FileName": null, "IsDownload": false, "Attributes": [], "Id": 11852476 }, { "EntityType": "ModuleItem", "ProductId": 10722, "ProductName": "[SHIP] Ground Advantage", "ModuleId": 1984, "Quantity": 1, "UnitPrice": 5.56, "TaxRate": 0.0, "TotalPrice": 5.56, "FileName": null, "IsDownload": false, "Attributes": [], "Id": 11852478 } ], "Payments": [ { "Amount": 11.15, "AmountCaptured": 11.15, "GatewayReason": null, "TransactionId": null, "Status": "Succeeded", "PaymentType": "CreditCard", "PaymentGatewayType": "stripe", "Notes": "pi_3QX3U6LisBXeAJQ325hQrbGP", "CreatedDateTime": "2024-12-17T11:19:18.279885+00:00", "Id": 11852480 } ], "CustomCrmGroups": { "marketplaceorderinfo": { "CreatedByMnMarketpace": true, "TransactionId": "pi_3QX3U6LisBXeAJQ325hQrbGP", "ShopifyOrderId": "gid://shopify/Order/6408192032958", "MarketplaceOrderId": "627", "IsMember": true, "SurchargePercent": "0", "ApplicationFee": "5", "BrandStoreId": "11391", "BrandStoreName": "Spritzal Cookie Company", "BrandStoreDiscount": "20", "BillingAddress": "{\"Id\":129,\"FirstName\":\"oleksii\",\"LastName\":\"iagolnyk\",\"Phone\":\"9418991889\",\"Address1\":\"11 Kewen Way\",\"City\":\"Aliso Viejo\",\"State\":\"CA\",\"CountryCode\":\"US\",\"Zip\":\"92656\"}", "ShippingAddress": "{\"ShippingNotes\":\"\",\"Id\":129,\"FirstName\":\"oleksii\",\"LastName\":\"iagolnyk\",\"Phone\":\"9418991889\",\"Address1\":\"11 Kewen Way\",\"City\":\"Aliso Viejo\",\"State\":\"CA\",\"CountryCode\":\"US\",\"Zip\":\"92656\"}", "OrderSummary": "{\"SubTotalPrice\":5.59,\"NotMemberSurcharge\":0.00,\"TotalSavedPrice\":1.40,\"TotalTaxPrice\":0.0,\"SubtotalWithTax\":5.59,\"TotalShippingPrice\":5.56,\"TotalGiftCardPrice\":0.0,\"TotalPrice\":11.15}", "TrackingCompany": "USPS", "TrackingNumber": "420926569300110597203873168199", "TrackingUrl": "https://tools.usps.com/go/TrackConfirmAction_input?qtc_tLabels1=420926569300110597203873168199", "ShipmentStatus": "fulfilled", "OrderLineExtendedInfo": "[{\"Id\":688,\"ShopifyOrderLineItemId\":\"gid://shopify/LineItem/14780261433534\",\"Name\":\"Birthday Cake Shortbread Bites\",\"ProductTitle\":\"Birthday Cake Shortbread Bites\",\"Image\":\"https://cdn.shopify.com/s/files/1/0215/3096/8128/files/BirthdayCake.png?v=1689961059\",\"FeaturedImage\":\"https://cdn.shopify.com/s/files/1/0215/3096/8128/files/BirthdayCake.png?v=1689961059\",\"Quantity\":1,\"ActualUnitPrice\":5.59,\"OriginalUnitPrice\":6.99,\"DiscountedPrice\":5.59,\"SavedPrice\":1.40,\"TotalTaxPrice\":0.0,\"Variants\":{\"Id\":688,\"ShopifyVariantId\":\"gid://shopify/ProductVariant/42577241276606\",\"Image\":null,\"DisplayName\":\"Birthday Cake Shortbread Bites - Default Title\",\"Title\":\"Default Title\",\"SelectedOptions\":[{\"Name\":\"Title\",\"Value\":\"Default Title\"}]},\"NonRefundable\":true,\"Reason\":\"\",\"CMSProductUrl\":\"/brand-store/spritzal-cookie-company/birthday-cake-shortbread-bites\"}]", "TaxExtendedInfo": "[{\"Id\":115,\"Title\":\"California State Tax\",\"Rate\":0.0,\"RatePercentage\":0.0,\"Amount\":0.0}]", "ShippingExtendedInfo": "{\"Id\":205,\"ShopifyId\":\"gid://shopify/ShippingLine/4991000936638\",\"Title\":\"Ground Advantage\",\"ShippingRateHandle\":\"7f60d15f6a376e1d1df69857e9d7c933\",\"ServiceHandle\":\"GroundAdvantage\",\"ServiceName\":null,\"ServiceType\":\"shipping\",\"TotalTaxPrice\":0.0,\"ShippingInfoTaxes\":[{\"Tax\":{\"Id\":114,\"Title\":\"California State Tax\",\"Rate\":0.0,\"RatePercentage\":0.0,\"Amount\":0.0}}]}", "ReturnLineExtendedInfo": "[]" } }, "ShippingCountry": "US", "Id": 11852458 }, { "AWBNumber": null, "CurrencyCountry": "USD/US", "Currency": "USD", "Country": "US", "InvoiceDate": "2024-12-02T17:02:55.386535+00:00", "InvoiceNumber": 214054, "IsDeleted": false, "IsRecurring": false, "MainOrderId": 0, "MemberId": 2676798, "OrderName": "Marketplace 10917-Hero Soap Company", "PaymentState": "Processing", "StatusId": 489409, "TotalCost": 0.28, "CreatedDateTime": "2024-12-02T22:02:55.433501+00:00", "HasSubscriptions": false, "HasPaidSubscription": false, "TrackingURL": null, "TransactionId": null, "AmountPaid": 0.28, "AmountPending": 0.0, "OrderCaseType": "None", "StatusShort": { "Id": 489409, "Name": "Paid" }, "Discount": null, "GiftVoucher": null, "Tax": null, "ShippingInfo": { "Name": null, "Cost": 0.0, "Address": null, "City": null, "State": null, "Zipcode": null, "Country": "US" }, "Member": { "Id": 2676798, "Email": "[email protected]", "FirstName": "Test", "LastName": "Test" }, "OrderLines": [ { "EntityType": "ModuleItem", "ProductId": 10719, "ProductName": "[GIFT] TESTQA50", "ModuleId": 1984, "Quantity": 1, "UnitPrice": -11.52, "TaxRate": 0.0, "TotalPrice": -11.52, "FileName": null, "IsDownload": false, "Attributes": [], "Id": 11618311 }, { "EntityType": "ModuleItem", "ProductId": 10721, "ProductName": "[PRODUCTS]", "ModuleId": 1984, "Quantity": 1, "UnitPrice": 6.8, "TaxRate": 0.0, "TotalPrice": 6.8, "FileName": null, "IsDownload": false, "Attributes": [], "Id": 11618309 }, { "EntityType": "ModuleItem", "ProductId": 10722, "ProductName": "[SHIP] US Flat Rate", "ModuleId": 1984, "Quantity": 1, "UnitPrice": 5.0, "TaxRate": 0.0, "TotalPrice": 5.0, "FileName": null, "IsDownload": false, "Attributes": [], "Id": 11618313 } ], "Payments": [ { "Amount": 0.28, "AmountCaptured": 0.28, "GatewayReason": null, "TransactionId": null, "Status": "Succeeded", "PaymentType": "CreditCard", "PaymentGatewayType": "stripe", "Notes": "pi_3QRhhZLisBXeAJQ33cB7UDK6", "CreatedDateTime": "2024-12-02T17:03:06.574716+00:00", "Id": 11618316 } ], "CustomCrmGroups": { "marketplaceorderinfo": { "CreatedByMnMarketpace": true, "TransactionId": "pi_3QRhhZLisBXeAJQ33cB7UDK6", "ShopifyOrderId": "gid://shopify/Order/5840845701362", "MarketplaceOrderId": "410", "IsMember": true, "SurchargePercent": "0", "ApplicationFee": "5", "BrandStoreId": "10917", "BrandStoreName": "Hero Soap Company", "BrandStoreDiscount": "15", "BillingAddress": "{\"Id\":81,\"FirstName\":\"oleksii\",\"LastName\":\"iagolnyk\",\"Phone\":\"+19418991889\",\"Address1\":\"11 Kewen Way\",\"City\":\"Aliso Viejo\",\"State\":\"CA\",\"CountryCode\":\"US\",\"Zip\":\"92656\"}", "ShippingAddress": "{\"ShippingNotes\":\"\",\"Id\":81,\"FirstName\":\"oleksii\",\"LastName\":\"iagolnyk\",\"Phone\":\"+19418991889\",\"Address1\":\"11 Kewen Way\",\"City\":\"Aliso Viejo\",\"State\":\"CA\",\"CountryCode\":\"US\",\"Zip\":\"92656\"}", "OrderSummary": "{\"SubTotalPrice\":6.80,\"NotMemberSurcharge\":0.00,\"TotalSavedPrice\":1.20,\"TotalTaxPrice\":0.0,\"SubtotalWithTax\":6.80,\"TotalShippingPrice\":5.0,\"TotalGiftCardPrice\":11.52,\"TotalPrice\":0.28}", "TrackingCompany": "USPS", "TrackingNumber": "420926569300110597203803329003", "TrackingUrl": "https://tools.usps.com/go/TrackConfirmAction_input?qtc_tLabels1=420926569300110597203803329003", "ShipmentStatus": "fulfilled", "OrderLineExtendedInfo": "[{\"Id\":447,\"ShopifyOrderLineItemId\":\"gid://shopify/LineItem/14306724446450\",\"Name\":\"Lavender\",\"ProductTitle\":\"Lavender\",\"Image\":\"https://cdn.shopify.com/s/files/1/0055/7688/4324/files/Untitled_8.png?v=1723831550\",\"FeaturedImage\":\"https://cdn.shopify.com/s/files/1/0055/7688/4324/files/Untitled_8.png?v=1723831550\",\"Quantity\":1,\"ActualUnitPrice\":6.80,\"OriginalUnitPrice\":8.00,\"DiscountedPrice\":6.80,\"SavedPrice\":1.20,\"TotalTaxPrice\":0.0,\"Variants\":{\"Id\":447,\"ShopifyVariantId\":\"gid://shopify/ProductVariant/30470895665252\",\"Image\":null,\"DisplayName\":\"Lavender - Default Title\",\"Title\":\"Default Title\",\"SelectedOptions\":[{\"Name\":\"Title\",\"Value\":\"Default Title\"}]},\"NonRefundable\":false,\"Reason\":\"\",\"CMSProductUrl\":\"/brand-store/hero-soap-company/lavender\"}]", "TaxExtendedInfo": "[{\"Id\":77,\"Title\":\"California State Tax\",\"Rate\":0.0,\"RatePercentage\":0.0,\"Amount\":0.0}]", "ShippingExtendedInfo": "{\"Id\":135,\"ShopifyId\":\"gid://shopify/ShippingLine/4793601622258\",\"Title\":\"US Flat Rate\",\"ShippingRateHandle\":\"6345e60b04877ef364bfa1f41e5788e7\",\"ServiceHandle\":\"US Flat Rate\",\"ServiceName\":null,\"ServiceType\":\"shipping\",\"TotalTaxPrice\":0.0,\"ShippingInfoTaxes\":[{\"Tax\":{\"Id\":76,\"Title\":\"California State Tax\",\"Rate\":0.0,\"RatePercentage\":0.0,\"Amount\":0.0}}]}", "ReturnLineExtendedInfo": "[]" } }, "ShippingCountry": "US", "Id": 11618291 }, { "AWBNumber": null, "CurrencyCountry": "USD/US", "Currency": "USD", "Country": "US", "InvoiceDate": "2024-12-02T17:02:52.70545+00:00", "InvoiceNumber": 214053, "IsDeleted": false, "IsRecurring": false, "MainOrderId": 0, "MemberId": 2676798, "OrderName": "Marketplace 11056-Expedition Joe Coffee Company", "PaymentState": "Processing", "StatusId": 489409, "TotalCost": 0.22, "CreatedDateTime": "2024-12-02T22:02:52.750852+00:00", "HasSubscriptions": false, "HasPaidSubscription": false, "TrackingURL": null, "TransactionId": null, "AmountPaid": 0.22, "AmountPending": 0.0, "OrderCaseType": "None", "StatusShort": { "Id": 489409, "Name": "Paid" }, "Discount": null, "GiftVoucher": null, "Tax": null, "ShippingInfo": { "Name": null, "Cost": 0.0, "Address": null, "City": null, "State": null, "Zipcode": null, "Country": "US" }, "Member": { "Id": 2676798, "Email": "[email protected]", "FirstName": "Test", "LastName": "Test" }, "OrderLines": [ { "EntityType": "ModuleItem", "ProductId": 10721, "ProductName": "[PRODUCTS]", "ModuleId": 1984, "Quantity": 1, "UnitPrice": 4.01, "TaxRate": 0.0, "TotalPrice": 4.01, "FileName": null, "IsDownload": false, "Attributes": [], "Id": 11618280 }, { "EntityType": "ModuleItem", "ProductId": 10719, "ProductName": "[GIFT] TESTQA50", "ModuleId": 1984, "Quantity": 1, "UnitPrice": -8.78, "TaxRate": 0.0, "TotalPrice": -8.78, "FileName": null, "IsDownload": false, "Attributes": [], "Id": 11618282 }, { "EntityType": "ModuleItem", "ProductId": 10722, "ProductName": "[SHIP] Standard", "ModuleId": 1984, "Quantity": 1, "UnitPrice": 4.99, "TaxRate": 0.0, "TotalPrice": 4.99, "FileName": null, "IsDownload": false, "Attributes": [], "Id": 11618284 } ], "Payments": [ { "Amount": 0.22, "AmountCaptured": 0.22, "GatewayReason": null, "TransactionId": null, "Status": "Succeeded", "PaymentType": "CreditCard", "PaymentGatewayType": "stripe", "Notes": "pi_3QRhhZLisBXeAJQ33cB7UDK6", "CreatedDateTime": "2024-12-02T17:03:05.125617+00:00", "Id": 11618315 } ], "CustomCrmGroups": { "marketplaceorderinfo": { "CreatedByMnMarketpace": true, "TransactionId": "pi_3QRhhZLisBXeAJQ33cB7UDK6", "ShopifyOrderId": "gid://shopify/Order/6257376657583", "MarketplaceOrderId": "409", "IsMember": true, "SurchargePercent": "0", "ApplicationFee": "5", "BrandStoreId": "11056", "BrandStoreName": "Expedition Joe Coffee Company", "BrandStoreDiscount": "10", "BillingAddress": "{\"Id\":81,\"FirstName\":\"oleksii\",\"LastName\":\"iagolnyk\",\"Phone\":\"+19418991889\",\"Address1\":\"11 Kewen Way\",\"City\":\"Aliso Viejo\",\"State\":\"CA\",\"CountryCode\":\"US\",\"Zip\":\"92656\"}", "ShippingAddress": "{\"ShippingNotes\":\"\",\"Id\":81,\"FirstName\":\"oleksii\",\"LastName\":\"iagolnyk\",\"Phone\":\"+19418991889\",\"Address1\":\"11 Kewen Way\",\"City\":\"Aliso Viejo\",\"State\":\"CA\",\"CountryCode\":\"US\",\"Zip\":\"92656\"}", "OrderSummary": "{\"SubTotalPrice\":4.01,\"NotMemberSurcharge\":0.00,\"TotalSavedPrice\":0.44,\"TotalTaxPrice\":0.0,\"SubtotalWithTax\":4.01,\"TotalShippingPrice\":4.99,\"TotalGiftCardPrice\":8.78,\"TotalPrice\":0.22}", "ShipmentStatus": "fulfilled", "TrackingCompany": "USPS", "TrackingNumber": "9400111206239723245175", "TrackingUrl": "https://tools.usps.com/go/TrackConfirmAction_input?qtc_tLabels1=9400111206239723245175", "OrderLineExtendedInfo": "[{\"Id\":445,\"ShopifyOrderLineItemId\":\"gid://shopify/LineItem/14533932187823\",\"Name\":\"Mountain House Mint Chocolate Chip Ice Cream Sandwich\",\"ProductTitle\":\"Mountain House Mint Chocolate Chip Ice Cream Sandwich\",\"Image\":\"https://cdn.shopify.com/s/files/1/0583/9912/9775/files/55529-MH-IceCream-MntChcltChp-Frnt.jpg?v=1729801774\",\"FeaturedImage\":\"https://cdn.shopify.com/s/files/1/0583/9912/9775/files/55529-MH-IceCream-MntChcltChp-Frnt.jpg?v=1729801774\",\"Quantity\":1,\"ActualUnitPrice\":4.01,\"OriginalUnitPrice\":4.45,\"DiscountedPrice\":4.01,\"SavedPrice\":0.44,\"TotalTaxPrice\":0.0,\"Variants\":{\"Id\":445,\"ShopifyVariantId\":\"gid://shopify/ProductVariant/44530319229103\",\"Image\":null,\"DisplayName\":\"Mountain House Mint Chocolate Chip Ice Cream Sandwich - Default Title\",\"Title\":\"Default Title\",\"SelectedOptions\":[{\"Name\":\"Title\",\"Value\":\"Default Title\"}]},\"NonRefundable\":true,\"Reason\":\"\",\"CMSProductUrl\":\"/brand-store/expedition-joe-coffee-company/mountain-house-mint-chocolate-chip-ice-cream-sandwich\"}]", "TaxExtendedInfo": "[{\"Id\":75,\"Title\":\"California State Tax\",\"Rate\":0.0,\"RatePercentage\":0.0,\"Amount\":0.0}]", "ShippingExtendedInfo": "{\"Id\":134,\"ShopifyId\":\"gid://shopify/ShippingLine/4795608498351\",\"Title\":\"Standard\",\"ShippingRateHandle\":\"369e6522aa8440f1b023930bb50e0043\",\"ServiceHandle\":\"Standard\",\"ServiceName\":null,\"ServiceType\":\"shipping\",\"TotalTaxPrice\":0.0,\"ShippingInfoTaxes\":[{\"Tax\":{\"Id\":74,\"Title\":\"California State Tax\",\"Rate\":0.0,\"RatePercentage\":0.0,\"Amount\":0.0}}]}", "ReturnLineExtendedInfo": "[]" } }, "ShippingCountry": "US", "Id": 11618262 } ], "TotalItemsCount": 12 }
orders component: { "Items": [ { "CustomerEmail": "[email protected]", "CustomerEmailToLower": "[email protected]", "PaymentType": null, "State": "Refunded", "Name": "Marketplace 17986-Market Goods", "NameToLower": "marketplace 17986-market goods", "InvoiceNumber": 283509, "InvoiceNumberToLower": "283509", "AmountPaid": 0.0, "InvoiceCode": "283509", "InvoiceCodeToLower": "283509", "InvoiceDate": "2025-04-15T05:11:42.317992", "AWBNumber": null, "TrackingURL": null, "OrderState": "Custom", "IsRecurring": false, "HasActiveSubscription": false, "PaymentIntentId": null, "PaymentIntentClientSecret": null, "SubTotalPrice": 0.0, "TaxRate": 0.0, "DiscountPrice": 0.0, "TotalPrice": 0.0, "GiftVoucherPrice": 0.0, "TaxCode": null, "TaxPrice": 0.0, "AddressLine": null, "ShippingCity": null, "ShippingState": null, "ShippingZipCode": null, "ShippingCountry": "UNITED STATES", "AmountPending": 0.0, "FormId": "0", "MemberId": "2676798", "CaseId": "0", "MainOrderId": null, "ShippingAddress": { "AddressLine": null, "City": null, "State": null, "ZipCode": null, "Country": "UNITED STATES" }, "AmountPaidHtml": "$0.00", "AmountPendingHtml": "$0.00", "Id": "14368780", "TaxPercent": 0.0, "ShippingPrice": 0.0, "ShippingTaxRate": 0.0, "ShippingTaxPrice": 0.0, "ShippingSubTotalPrice": 0.0, "ShippingTotalPrice": 0.0, "SubTotalTaxPrice": 0.0, "DiscountedSubTotalTaxPrice": 0.0, "GrandTotalPrice": 0.0, "TotalPriceExcludingTax": 0.0, "TotalPriceExcludingTaxAndGiftVoucherAmount": 0.0, "DiscountPriceExcludingTax": 0.0, "ShippingOption": { "Id": "14368778", "ShippingOptionId": "0", "Name": null, "Price": 0.0, "TaxPercent": 0.0, "TaxRate": 0.0, "TaxPrice": 0.0, "TotalPrice": 0.0, "SubTotalPrice": 0.0 }, "FormatSetting": { "Id": "556622", "Name": "Default", "Culture": "en-US", "DecimalsQuantity": 2, "Currency": { "Code": "USD", "Symbol": "$", "DigitalCode": "840", "Name": "US Dollar" } }, "DomainCountry": { "Name": "UNITED STATES", "Code": "US" }, "DestinationCountry": { "Name": "UNITED STATES", "Code": "US" }, "Discount": null, "GiftVoucher": null, "TotalPriceExcludingTaxHtml": "$0.00", "TotalPriceExcludingTaxAndGiftVoucherAmountHtml": "$0.00", "GrandTotalPriceHtml": "$0.00", "DiscountPriceHtml": "$0.00", "DiscountedSubTotalTaxPriceHtml": "$0.00", "SubTotalTaxPriceHtml": "$0.00", "TaxPriceHtml": "$0.00", "ShippingTotalPriceHtml": "$0.00", "ShippingPriceHtml": "$0.00", "ShippingTaxPriceHtml": "$0.00", "ShippingTaxPercentHtml": "0%", "TaxPercentHtml": "0%", "GiftVoucherPriceHtml": "$0.00", "TotalPriceHtml": "$0.00", "Items": [ { "EcommerceItemId": 10722, "SmallImage": null, "Name": "[SHIP] Economy", "SKUCode": "782416d1-5a23-4c6a-9acb-b155ee9b186b", "Quantity": 1, "ModuleItemUrl": "/catalogs/mn-marketplace-shipping", "TaxCode": null, "OnSale": false, "Price": 0.0, "TaxRate": 0.0, "UnitPrice": 0.0, "RecommendedPrice": 0.0, "IsDownloadable": false, "WebDomain": "mammoth-live.trialsite.co", "Attributes": [], "Id": "14368799", "ProductFileLink": "", "Url": "/catalogs/mn-marketplace-shipping", "TaxPercent": 0.0, "TaxPrice": 0.0, "TotalPrice": 0.0, "UnitTaxPrice": 0.0, "UnitTotalPrice": 0.0, "UnitRecommendedTaxPrice": 0.0, "UnitRecommendedTotalPrice": 0.0, "UnitRecommendedPrice": 0.0, "TotalPriceExcludingTax": 0.0, "TaxPercentHtml": "0%", "TotalPriceExcludingTaxHtml": "$0.00", "UnitTaxPriceHtml": "$0.00", "UnitTotalPriceHtml": "$0.00", "UnitPriceHtmlTotal": "$0.00", "PriceHtml": "$0.00", "UnitPriceHtml": "$0.00", "TaxPriceHtml": "$0.00", "TotalPriceHtml": "$0.00", "QuantityHtml": "", "RemoveHtml": "", "TaxCodeHtml": "", "UnitRecommendedPriceHtml": "$0.00", "UnitRecommendedTaxPriceHtml": "$0.00", "UnitRecommendedTotalPriceHtml": "$0.00" }, { "EcommerceItemId": 10721, "SmallImage": null, "Name": "[PRODUCTS]", "SKUCode": "8f3af622-fcbe-487a-a5a8-530ef88d4e91", "Quantity": 1, "ModuleItemUrl": "/catalogs/mn-marketplace-product", "TaxCode": null, "OnSale": false, "Price": 0.0, "TaxRate": 0.0, "UnitPrice": 0.0, "RecommendedPrice": 0.0, "IsDownloadable": false, "WebDomain": "mammoth-live.trialsite.co", "Attributes": [], "Id": "14368801", "ProductFileLink": "", "Url": "/catalogs/mn-marketplace-product", "TaxPercent": 0.0, "TaxPrice": 0.0, "TotalPrice": 0.0, "UnitTaxPrice": 0.0, "UnitTotalPrice": 0.0, "UnitRecommendedTaxPrice": 0.0, "UnitRecommendedTotalPrice": 0.0, "UnitRecommendedPrice": 0.0, "TotalPriceExcludingTax": 0.0, "TaxPercentHtml": "0%", "TotalPriceExcludingTaxHtml": "$0.00", "UnitTaxPriceHtml": "$0.00", "UnitTotalPriceHtml": "$0.00", "UnitPriceHtmlTotal": "$0.00", "PriceHtml": "$0.00", "UnitPriceHtml": "$0.00", "TaxPriceHtml": "$0.00", "TotalPriceHtml": "$0.00", "QuantityHtml": "", "RemoveHtml": "", "TaxCodeHtml": "", "UnitRecommendedPriceHtml": "$0.00", "UnitRecommendedTaxPriceHtml": "$0.00", "UnitRecommendedTotalPriceHtml": "$0.00" } ], "SubTotalPriceHtml": "$0.00", "TaxCodeHtml": "", "Params": {} } ], "Params": { "viewtype": "list", "currentmemberonly": "false", "filterby": "MemberId", "filtervalue": "2676798", "limit": "1", "type": "orders", "layout": "", "collectionvariable": "ggg" } }
Success
orderListWhere: { "$and": [ { "$eq": { "IsDeleted": false } }, { "$eq": { "MemberId": "3111061" } } ] }ItemList : { "Items": [ { "AWBNumber": null, "CurrencyCountry": "USD/US", "Currency": "USD", "Country": "US", "InvoiceDate": "2024-12-02T22:18:00.924658+00:00", "InvoiceNumber": 214166, "IsDeleted": false, "IsRecurring": false, "MainOrderId": 0, "MemberId": 3111061, "OrderName": "Marketplace 11056-Expedition Joe Coffee Company", "PaymentState": "Processing", "StatusId": 489409, "TotalCost": 81.85, "CreatedDateTime": "2024-12-03T03:18:00.96975+00:00", "HasSubscriptions": false, "HasPaidSubscription": false, "TrackingURL": null, "TransactionId": null, "AmountPaid": 81.85, "AmountPending": 0.0, "OrderCaseType": "None", "StatusShort": { "Id": 489409, "Name": "Paid" }, "Discount": null, "GiftVoucher": null, "Tax": null, "ShippingInfo": { "Name": null, "Cost": 0.0, "Address": null, "City": null, "State": null, "Zipcode": null, "Country": "US" }, "Member": { "Id": 3111061, "Email": "[email protected]", "FirstName": "Nancy", "LastName": "Haney" }, "OrderLines": [ { "EntityType": "ModuleItem", "ProductId": 10721, "ProductName": "[PRODUCTS]", "ModuleId": 1984, "Quantity": 1, "UnitPrice": 69.9, "TaxRate": 0.0, "TotalPrice": 69.9, "FileName": null, "IsDownload": false, "Attributes": [], "Id": 11620563 }, { "EntityType": "ModuleItem", "ProductId": 10722, "ProductName": "[SHIP] Standard", "ModuleId": 1984, "Quantity": 1, "UnitPrice": 11.95, "TaxRate": 0.0, "TotalPrice": 11.95, "FileName": null, "IsDownload": false, "Attributes": [], "Id": 11620565 } ], "Payments": [ { "Amount": 81.85, "AmountCaptured": 81.85, "GatewayReason": null, "TransactionId": null, "Status": "Succeeded", "PaymentType": "CreditCard", "PaymentGatewayType": "stripe", "Notes": "pi_3QRmcZLisBXeAJQ33OziI3b9", "CreatedDateTime": "2024-12-02T22:18:12.604667+00:00", "Id": 11620567 } ], "CustomCrmGroups": { "marketplaceorderinfo": { "CreatedByMnMarketpace": true, "TransactionId": "pi_3QRmcZLisBXeAJQ33OziI3b9", "ShopifyOrderId": "gid://shopify/Order/6258447548591", "MarketplaceOrderId": "443", "IsMember": true, "SurchargePercent": "0", "ApplicationFee": "5", "BrandStoreId": "11056", "BrandStoreName": "Expedition Joe Coffee Company", "BrandStoreDiscount": "10", "BillingAddress": "{\"Id\":89,\"FirstName\":\"Nancy\",\"LastName\":\"Haney\",\"Phone\":\"2813844140\",\"Address1\":\"230 Private Road 3468\",\"City\":\"Paradise\",\"State\":\"TX\",\"CountryCode\":\"US\",\"Zip\":\"76073\"}", "ShippingAddress": "{\"ShippingNotes\":\"\",\"Id\":89,\"FirstName\":\"Nancy\",\"LastName\":\"Haney\",\"Phone\":\"2813844140\",\"Address1\":\"230 Private Road 3468\",\"City\":\"Paradise\",\"State\":\"TX\",\"CountryCode\":\"US\",\"Zip\":\"76073\"}", "OrderSummary": "{\"SubTotalPrice\":69.90,\"NotMemberSurcharge\":0.00,\"TotalSavedPrice\":7.77,\"TotalTaxPrice\":0.0,\"SubtotalWithTax\":69.90,\"TotalShippingPrice\":11.95,\"TotalGiftCardPrice\":0.0,\"TotalPrice\":81.85}", "TrackingNumber": "9434611206239795948280", "ShipmentStatus": "fulfilled", "TrackingCompany": "USPS", "TrackingUrl": "https://tools.usps.com/go/TrackConfirmAction_input?qtc_tLabels1=9434611206239795948280", "OrderLineExtendedInfo": "[{\"Id\":482,\"ShopifyOrderLineItemId\":\"gid://shopify/LineItem/14536817770671\",\"Name\":\"Custom Coffee Pods - Butter Pecan / 12 Coffee Pods\",\"ProductTitle\":\"Custom Coffee Pods\",\"Image\":\"https://cdn.shopify.com/s/files/1/0583/9912/9775/products/Custom-Coffee-Pods-for-Keurig-from-Expedition-Joe-Coffee.jpg?v=1665671629\",\"FeaturedImage\":\"https://cdn.shopify.com/s/files/1/0583/9912/9775/products/Custom-Coffee-Pods-for-Keurig-from-Expedition-Joe-Coffee.jpg?v=1665671629\",\"Quantity\":2,\"ActualUnitPrice\":11.65,\"OriginalUnitPrice\":12.95,\"DiscountedPrice\":23.31,\"SavedPrice\":2.59,\"TotalTaxPrice\":0.0,\"Variants\":{\"Id\":482,\"ShopifyVariantId\":\"gid://shopify/ProductVariant/42037186298031\",\"Image\":null,\"DisplayName\":\"Custom Coffee Pods - Butter Pecan / 12 Coffee Pods\",\"Title\":\"Butter Pecan / 12 Coffee Pods\",\"SelectedOptions\":[{\"Name\":\"Coffee\",\"Value\":\"Butter Pecan\"},{\"Name\":\"Size\",\"Value\":\"12 Coffee Pods\"}]},\"NonRefundable\":true,\"Reason\":\"\",\"CMSProductUrl\":\"/brand-store/expedition-joe-coffee-company/custom-coffee-pods\"},{\"Id\":483,\"ShopifyOrderLineItemId\":\"gid://shopify/LineItem/14536817803439\",\"Name\":\"Custom Coffee Pods - Sweet Cinnamon Pecan / 12 Coffee Pods\",\"ProductTitle\":\"Custom Coffee Pods\",\"Image\":\"https://cdn.shopify.com/s/files/1/0583/9912/9775/products/Custom-Coffee-Pods-for-Keurig-from-Expedition-Joe-Coffee.jpg?v=1665671629\",\"FeaturedImage\":\"https://cdn.shopify.com/s/files/1/0583/9912/9775/products/Custom-Coffee-Pods-for-Keurig-from-Expedition-Joe-Coffee.jpg?v=1665671629\",\"Quantity\":2,\"ActualUnitPrice\":11.65,\"OriginalUnitPrice\":12.95,\"DiscountedPrice\":23.31,\"SavedPrice\":2.59,\"TotalTaxPrice\":0.0,\"Variants\":{\"Id\":483,\"ShopifyVariantId\":\"gid://shopify/ProductVariant/40689785536687\",\"Image\":null,\"DisplayName\":\"Custom Coffee Pods - Sweet Cinnamon Pecan / 12 Coffee Pods\",\"Title\":\"Sweet Cinnamon Pecan / 12 Coffee Pods\",\"SelectedOptions\":[{\"Name\":\"Coffee\",\"Value\":\"Sweet Cinnamon Pecan\"},{\"Name\":\"Size\",\"Value\":\"12 Coffee Pods\"}]},\"NonRefundable\":true,\"Reason\":\"\",\"CMSProductUrl\":\"/brand-store/expedition-joe-coffee-company/custom-coffee-pods\"},{\"Id\":485,\"ShopifyOrderLineItemId\":\"gid://shopify/LineItem/14536817836207\",\"Name\":\"Custom Coffee Pods - Hazelnut Coffee / 12 Coffee Pods\",\"ProductTitle\":\"Custom Coffee Pods\",\"Image\":\"https://cdn.shopify.com/s/files/1/0583/9912/9775/products/Custom-Coffee-Pods-for-Keurig-from-Expedition-Joe-Coffee.jpg?v=1665671629\",\"FeaturedImage\":\"https://cdn.shopify.com/s/files/1/0583/9912/9775/products/Custom-Coffee-Pods-for-Keurig-from-Expedition-Joe-Coffee.jpg?v=1665671629\",\"Quantity\":2,\"ActualUnitPrice\":11.65,\"OriginalUnitPrice\":12.95,\"DiscountedPrice\":23.31,\"SavedPrice\":2.59,\"TotalTaxPrice\":0.0,\"Variants\":{\"Id\":485,\"ShopifyVariantId\":\"gid://shopify/ProductVariant/43031802314927\",\"Image\":null,\"DisplayName\":\"Custom Coffee Pods - Hazelnut Coffee / 12 Coffee Pods\",\"Title\":\"Hazelnut Coffee / 12 Coffee Pods\",\"SelectedOptions\":[{\"Name\":\"Coffee\",\"Value\":\"Hazelnut Coffee\"},{\"Name\":\"Size\",\"Value\":\"12 Coffee Pods\"}]},\"NonRefundable\":true,\"Reason\":\"\",\"CMSProductUrl\":\"/brand-store/expedition-joe-coffee-company/custom-coffee-pods\"}]", "TaxExtendedInfo": "[{\"Id\":79,\"Title\":\"Texas State Tax\",\"Rate\":0.0,\"RatePercentage\":0.0,\"Amount\":0.0}]", "ShippingExtendedInfo": "{\"Id\":153,\"ShopifyId\":\"gid://shopify/ShippingLine/4796583542959\",\"Title\":\"Standard\",\"ShippingRateHandle\":\"167096e20e1a5061b54db8536499bf82\",\"ServiceHandle\":\"Standard\",\"ServiceName\":null,\"ServiceType\":\"shipping\",\"TotalTaxPrice\":0.0,\"ShippingInfoTaxes\":[{\"Tax\":{\"Id\":78,\"Title\":\"Texas State Tax\",\"Rate\":0.0,\"RatePercentage\":0.0,\"Amount\":0.0}}]}", "ReturnLineExtendedInfo": "[]" } }, "ShippingCountry": "US", "Id": 11620545 }, { "AWBNumber": null, "CurrencyCountry": "USD/US", "Currency": "USD", "Country": "US", "InvoiceDate": "2022-02-17T10:41:27.094443+00:00", "InvoiceNumber": 52633, "IsDeleted": false, "IsRecurring": false, "MainOrderId": 0, "MemberId": 3111061, "OrderName": "Lifetime Membership", "PaymentState": "Succeeded", "StatusId": 489409, "TotalCost": 299.0, "CreatedDateTime": "2022-02-17T15:41:27.197072+00:00", "HasSubscriptions": false, "HasPaidSubscription": false, "TrackingURL": null, "TransactionId": "pi_3KUC6iDXonPN6eJb2eOq13C6", "AmountPaid": 299.0, "AmountPending": 0.0, "OrderCaseType": "FormCase", "StatusShort": { "Id": 489409, "Name": "Paid" }, "Discount": null, "GiftVoucher": null, "Tax": null, "ShippingInfo": null, "Member": { "Id": 3111061, "Email": "[email protected]", "FirstName": "Nancy", "LastName": "Haney" }, "OrderLines": [ { "EntityType": "Form", "ProductId": 0, "ProductName": "Lifetime Membership", "ModuleId": 0, "Quantity": 1, "UnitPrice": 299.0, "TaxRate": 0.0, "TotalPrice": 299.0, "FileName": null, "IsDownload": false, "Attributes": [], "Id": 3112606 } ], "Payments": [ { "Amount": 299.0, "AmountCaptured": 299.0, "GatewayReason": null, "TransactionId": "pi_3KUC6iDXonPN6eJb2eOq13C6", "Status": "Succeeded", "PaymentType": "CreditCard", "PaymentGatewayType": "stripe", "Notes": null, "CreatedDateTime": "2022-02-17T10:41:27.096944+00:00", "Id": 3112627 } ], "CustomCrmGroups": {}, "ShippingCountry": "US", "Id": 3112625 } ], "TotalItemsCount": 2 }
orders component: { "Items": [ { "CustomerEmail": "[email protected]", "CustomerEmailToLower": "[email protected]", "PaymentType": null, "State": "Paid", "Name": "Marketplace 11056-Expedition Joe Coffee Company", "NameToLower": "marketplace 11056-expedition joe coffee company", "InvoiceNumber": 214166, "InvoiceNumberToLower": "214166", "AmountPaid": 81.8500, "InvoiceCode": "214166", "InvoiceCodeToLower": "214166", "InvoiceDate": "2024-12-02T22:18:00.924658", "AWBNumber": null, "TrackingURL": null, "OrderState": "Paid", "IsRecurring": false, "HasActiveSubscription": false, "PaymentIntentId": null, "PaymentIntentClientSecret": null, "SubTotalPrice": 81.8500, "TaxRate": 0.0, "DiscountPrice": 0.0, "TotalPrice": 81.8500, "GiftVoucherPrice": 0.0, "TaxCode": null, "TaxPrice": 0.0, "AddressLine": null, "ShippingCity": null, "ShippingState": null, "ShippingZipCode": null, "ShippingCountry": "UNITED STATES", "AmountPending": 0.0, "FormId": "0", "MemberId": "3111061", "CaseId": "0", "MainOrderId": null, "ShippingAddress": { "AddressLine": null, "City": null, "State": null, "ZipCode": null, "Country": "UNITED STATES" }, "AmountPaidHtml": "$81.85", "AmountPendingHtml": "$0.00", "Id": "11620545", "TaxPercent": 0.0, "ShippingPrice": 0.0, "ShippingTaxRate": 0.0, "ShippingTaxPrice": 0.0, "ShippingSubTotalPrice": 0.0, "ShippingTotalPrice": 0.0, "SubTotalTaxPrice": 0.0, "DiscountedSubTotalTaxPrice": 0.0, "GrandTotalPrice": 81.85000000, "TotalPriceExcludingTax": 81.8500, "TotalPriceExcludingTaxAndGiftVoucherAmount": 81.8500, "DiscountPriceExcludingTax": 0.0, "ShippingOption": { "Id": "11620543", "ShippingOptionId": "0", "Name": null, "Price": 0.0, "TaxPercent": 0.0, "TaxRate": 0.0, "TaxPrice": 0.0, "TotalPrice": 0.0, "SubTotalPrice": 0.0 }, "FormatSetting": { "Id": "556622", "Name": "Default", "Culture": "en-US", "DecimalsQuantity": 2, "Currency": { "Code": "USD", "Symbol": "$", "DigitalCode": "840", "Name": "US Dollar" } }, "DomainCountry": { "Name": "UNITED STATES", "Code": "US" }, "DestinationCountry": { "Name": "UNITED STATES", "Code": "US" }, "Discount": null, "GiftVoucher": null, "TotalPriceExcludingTaxHtml": "$81.85", "TotalPriceExcludingTaxAndGiftVoucherAmountHtml": "$81.85", "GrandTotalPriceHtml": "$81.85", "DiscountPriceHtml": "$0.00", "DiscountedSubTotalTaxPriceHtml": "$0.00", "SubTotalTaxPriceHtml": "$0.00", "TaxPriceHtml": "$0.00", "ShippingTotalPriceHtml": "$0.00", "ShippingPriceHtml": "$0.00", "ShippingTaxPriceHtml": "$0.00", "ShippingTaxPercentHtml": "0%", "TaxPercentHtml": "0%", "GiftVoucherPriceHtml": "$0.00", "TotalPriceHtml": "$81.85", "Items": [ { "EcommerceItemId": 10721, "SmallImage": null, "Name": "[PRODUCTS]", "SKUCode": "8f3af622-fcbe-487a-a5a8-530ef88d4e91", "Quantity": 1, "ModuleItemUrl": "/catalogs/mn-marketplace-product", "TaxCode": null, "OnSale": false, "Price": 0.0, "TaxRate": 0.0, "UnitPrice": 69.9000, "RecommendedPrice": 0.0, "IsDownloadable": false, "WebDomain": "mammoth-live.trialsite.co", "Attributes": [], "Id": "11620563", "ProductFileLink": "", "Url": "/catalogs/mn-marketplace-product", "TaxPercent": 0.0, "TaxPrice": 0.0, "TotalPrice": 69.90000000, "UnitTaxPrice": 0.0, "UnitTotalPrice": 69.90000000, "UnitRecommendedTaxPrice": 0.0, "UnitRecommendedTotalPrice": 0.0, "UnitRecommendedPrice": 0.0, "TotalPriceExcludingTax": 69.9000, "TaxPercentHtml": "0%", "TotalPriceExcludingTaxHtml": "$69.90", "UnitTaxPriceHtml": "$0.00", "UnitTotalPriceHtml": "$69.90", "UnitPriceHtmlTotal": "$69.90", "PriceHtml": "$0.00", "UnitPriceHtml": "$69.90", "TaxPriceHtml": "$0.00", "TotalPriceHtml": "$69.90", "QuantityHtml": "", "RemoveHtml": "", "TaxCodeHtml": "", "UnitRecommendedPriceHtml": "$0.00", "UnitRecommendedTaxPriceHtml": "$0.00", "UnitRecommendedTotalPriceHtml": "$0.00" }, { "EcommerceItemId": 10722, "SmallImage": null, "Name": "[SHIP] Standard", "SKUCode": "782416d1-5a23-4c6a-9acb-b155ee9b186b", "Quantity": 1, "ModuleItemUrl": "/catalogs/mn-marketplace-shipping", "TaxCode": null, "OnSale": false, "Price": 0.0, "TaxRate": 0.0, "UnitPrice": 11.9500, "RecommendedPrice": 0.0, "IsDownloadable": false, "WebDomain": "mammoth-live.trialsite.co", "Attributes": [], "Id": "11620565", "ProductFileLink": "", "Url": "/catalogs/mn-marketplace-shipping", "TaxPercent": 0.0, "TaxPrice": 0.0, "TotalPrice": 11.95000000, "UnitTaxPrice": 0.0, "UnitTotalPrice": 11.95000000, "UnitRecommendedTaxPrice": 0.0, "UnitRecommendedTotalPrice": 0.0, "UnitRecommendedPrice": 0.0, "TotalPriceExcludingTax": 11.9500, "TaxPercentHtml": "0%", "TotalPriceExcludingTaxHtml": "$11.95", "UnitTaxPriceHtml": "$0.00", "UnitTotalPriceHtml": "$11.95", "UnitPriceHtmlTotal": "$11.95", "PriceHtml": "$0.00", "UnitPriceHtml": "$11.95", "TaxPriceHtml": "$0.00", "TotalPriceHtml": "$11.95", "QuantityHtml": "", "RemoveHtml": "", "TaxCodeHtml": "", "UnitRecommendedPriceHtml": "$0.00", "UnitRecommendedTaxPriceHtml": "$0.00", "UnitRecommendedTotalPriceHtml": "$0.00" } ], "SubTotalPriceHtml": "$81.85", "TaxCodeHtml": "", "Params": {} } ], "Params": { "viewtype": "list", "currentmemberonly": "false", "filterby": "MemberId", "filtervalue": "3111061", "limit": "1", "type": "orders", "layout": "", "collectionvariable": "ggg" } }