- Joined
- Jun 14, 2024
- Messages
- 2,617
- Reaction score
- 31,196
- Points
- 113
- Thread Author
- #1
www.levelshoes.com (Order Details)
www.levelshoes.com (Order Details)
Format - .SQL
Date - 2023
All Rows - 3.8kk
Size unpacked 9gb+
Website - https://www.levelshoes.com/​
1456476 orders
Sample:
Code:
INSERT INTO `orderdetails` (`id`, `orderid`, `quoteinfo`, `postpayment`, `order_time`) VALUES(1812083, 'APPENUAE8003110000002927450', '{\"module\": \"levelshoes_monitoring\", \"CartTotalModelgrandTotal\": \"540.0\", \"baseGrandTotal\": \"540.0\", \"subtotal\": \"514.29\", \"baseSubtotal\": \"514.29\", \"discountAmount\": \"0.0\", \"baseDiscountAmount\": \"0.0\", \"subtotalWithDiscount\": \"514.29\", \"baseSubtotalWithDiscount\": \"514.29\", \"shippingAmount\": \"0.0\", \"baseShippingAmount\": \"0.0\", \"shippingDiscountAmount\": \"0.0\", \"baseShippingDiscountAmount\": \"0.0\", \"taxAmount\": \"25.71\", \"baseTaxAmount\": \"25.71\", \"weeeTaxAppliedAmount\": \"nil\", \"shippingTaxAmount\": \"0.0\", \"baseShippingTaxAmount\": \"0.0\", \"subtotalInclTax\": \"540.0\", \"shippingInclTax\": \"0.0\", \"coupon_code\": \"nil\", \"taxPercentage\": \"nil\", \"baseShippingInclTax\": \"0.0\", \"baseCurrencyCode\": \"\\\\AED\\\\\", \"quoteCurrencyCode\": \"\\\\AED\\\\\", \"itemsQty\": \"1\", \"items\": \"itemID\", \"price\": \"514.29\", \"basePrice\": \"514.29\", \"qty\": \"1\", \"rowTotal\": \"514.29\", \"baseRowTotal\": \"514.29\", \"rowTotalWithDiscount\": \"nil\", \"taxPercent\": \"5.0\", \"taxAmount-1\": \"25.71\", \"discountAmount-1\": \"0.0\", \"baseDiscountAmount-1\": \"0.0\", \"baseTaxAmount-1\": \"25.71\", \"discountPercent\": \"nil\", \"priceInclTax\": \"540.0\", \"basePriceInclTax\": \"nil\", \"rowTotalInclTax\": \"nil\", \"baseRowTotalInclTax\": \"nil\", \"options\": \"\\\\\\\\\\\\\\\\value\\\\\\\\\\\\\", \"\\\\\\\\\\\\label\\\\\\\\\\\\\": \"\\\\\\\\\\\\Size\\\\\\\\\\\\\\\\\", \"weeeTaxAppliedAmount-1\": \"nil\", \"weeeTaxApplied\": \"nil\", \"extensionAttributes\": \"isFreeProduct\", \"originalRowTotal\": \"980.0\", \"lvl_concession_core_sku\": \"\\\\NA\\\\\", \"zone\": \"255\", \"sku\": \"\\\\023325789369\\\\\", \"brand\": \"\\\\Michael Kors\\\\\", \"image\": \"\\\\/4/2/42s2thfs4d-396_1.jpg\\\\\", \"is_pre_order\": \"\\\\0\\\\\", \"pre_order_expected_date\": \"nil\", \"museReward\": \"514\", \"name\": \"\\\\Theo sneakers\\\\\", \"totalSegments\": \"code\", \"title\": \"\\\\Subtotal\\\\\", \"value\": \"540.0\", \"extensionAttributes-1\": \"TotalshippingAssignments\", \"area\": \"nil\", \"code\": \"\\\\giftwrapping\\\\\", \"title-1\": \"\\\\0 Reward points\\\\\", \"value-1\": \"home\", \"gwBasePrice\": \"\\\\0.0000\\\\\", \"gwItemsPrice\": \"\\\\0.0000\\\\\", \"gwItemsBasePrice\": \"\\\\0.0000\\\\\", \"gwCardPrice\": \"\\\\0.0000\\\\\", \"gwCardBasePrice\": \"\\\\0.0000\\\\\", \"taxGrandtotalDetails\": \"nil\", \"gift_cards\": \"nil\", \"area-1\": \"nil\", \"code-1\": \"\\\\reward\\\\\", \"gwBasePrice-1\": \"nil\", \"gwItemsPrice-1\": \"nil\", \"gwItemsBasePrice-1\": \"nil\", \"gwCardPrice-1\": \"nil\", \"gwCardBasePrice-1\": \"nil\", \"taxGrandtotalDetails-1\": \"amount\", \"rates\": \"percent\", \"groupID\": \"nil\", \"gift_cards-1\": \"nil\", \"isSubscribed\": \"nil\", \"levelupText\": \"nil\", \"museCartTotalDetail\": \"LevelShoes.MuseCartModellvlMuseRedeemablePoints\", \"text\": \"nil\", \"lvlMuseRedeemableAmount\": \"LevelShoes.MusePointsModelvalue\", \"text-1\": \"\\\\Earn 514 points with this purchase\\\\\", \"lvlMuseEarnPoints\": \"LevelShoes.MusePointsModelvalue\", \"lvlMuseGuestEarnPoints\": \"LevelShoes.MusePointsModelvalue\", \"lvlMuseMemberId\": \"\\\\\\\\\", \"paymentMethods\": \"LevelShoes.PaymentMethodiconURL\", \"type\": \"\\\\card\\\\\", \"icon\": \"nil\", \"LevelShoes.PaymentMethodiconURL\": \"\\\\https\", \"type-1\": \"\\\\cod\\\\\", \"icon-1\": \"nil\", \"LevelShoes.PaymentMethodiconURL-1\": \"\\\\https\", \"paymentAssurance\": \"LevelShoes.PaymentAssurancemessage\", \"iconURL\": \"https\", \"build\": \"4.24.1.4\", \"version\": \"4.24.1\", \"shippingAddress\": \"id\", \"customerId\": \"235897\", \"region\": \"region\", \"regionCode\": \"nil\", \"regionID\": \"nil\", \"regionId\": \"0\", \"countryId\": \"AE\", \"street\": \"remraam \", \"company\": \"nil\", \"telephone\": \"971505473070\", \"postcode\": \"000000\", \"city\": \"Dubai\", \"firstname\": \"Yosra\", \"lastname\": \"Jeljli\", \"defaultShipping\": \"true\", \"defaultBilling\": \"true\", \"prefix\": \"Mr\", \"isselected\": \"nil\", \"customAttributes\": \"attributeCode\", \"email\": \"nil\", \"isclickandcollect\": \"false\"}', '{\"module\": \"levelshoes_monitoring\", \"\'charges\": \"shippingTaxAmount\", \"shippingCharges\": \"0.0\", \"total\": \"540.0\", \"discount\": \"440.0\", \"taxAmount\": \"25.71\", \"subtotal\": \"980.0\", \"discountTaxAmount\": \"0\", \"shippingTaxPercentage\": \"0\", \"taxPercentage\": \"5.0\", \"discountTaxPercentage\": \"0\", \"transactionType\": \"LAYINT\", \"customer\": \"firstName\", \"lastName\": \"Jeljli\", \"id\": \"235897\", \"shipTo\": \"address\", \"latitude\": \"25.0040231\", \"line1\": \"remraam \", \"country\": \"AE\", \"longitude\": \"55.2478939\", \"line2\": \"al thamam 28 app 105\", \"firstName\": \"Yosra\", \"lastName-1\": \"Jeljli\", \"phone\": \"971505473070\", \"email\": \"[email protected]\", \"phone-1\": \"971505473070\", \"billTo\": \"title\", \"address\": \"line1\", \"city\": \"Dubai\", \"country-1\": \"AE\", \"line2-1\": \"al thamam 28 app 105\", \"firstName-1\": \"Yosra\", \"title\": \"Ms\", \"items\": \"discountAmount\", \"sku\": \"023325789369\", \"unitRetail\": \"980.0\", \"productPricePaid\": \"540.0\", \"taxPercentage-1\": \"5.0\", \"comments\": \"\", \"vpn\": \"\", \"quantitySign\": \"P\", \"concessionSku\": \"\", \"originCountry\": \"AE\", \"taxAmount-1\": \"25.71\", \"quantity\": \"1\", \"orderId\": \"APPENUAE8003110000002927450\", \"transactionTime\": \"2022-07-14T12\", \"transactionNumber\": \"3000001236\", \"locale\": \"en_US\", \"store\": \"8003\", \"payment\": \"amount\", \"paymentTypeId\": \"3000\", \"paymentCurrency\": \"AED\", \"paymentType\": \"CCARD\", \"paymentCurrencyAmount\": \"540.0\", \"paymentId\": \"pay_5zbtu7v5ydjkze3drrfh5fj5pq\", \"businessDate\": \"20220714\", \"baseCurrency\": \"AED\", \"initiatedBy\": \"Mobileapp\", \"delivery\": \"type\", \"endTime\": \"2022-07-14T14\", \"startTime\": \"2022-07-14T12\", \"status\": \"NEW\'\"}', '2022-07-14 04:45:53'),
(1812084, 'APPENUAE8003110000002927450', '{\"module\": \"levelshoes_monitoring\", \"charges\": \"shippingTaxAmount\", \"shippingCharges\": \"0.0\", \"total\": \"540.0\", \"discount\": \"440.0\", \"taxAmount\": \"25.71\", \"subtotal\": \"980.0\", \"discountTaxAmount\": \"0\", \"shippingTaxPercentage\": \"0\", \"taxPercentage\": \"5.0\", \"discountTaxPercentage\": \"0\", \"transactionType\": \"LAYINT\", \"customer\": \"firstName\", \"lastName\": \"Jeljli\", \"id\": \"235897\", \"shipTo\": \"address\", \"latitude\": \"25.0040231\", \"line1\": \"remraam \", \"country\": \"AE\", \"longitude\": \"55.2478939\", \"line2\": \"al thamam 28 app 105\", \"firstName\": \"Yosra\", \"lastName-1\": \"Jeljli\", \"phone\": \"971505473070\", \"email\": \"[email protected]\", \"phone-1\": \"971505473070\", \"billTo\": \"title\", \"address\": \"line1\", \"city\": \"Dubai\", \"country-1\": \"AE\", \"line2-1\": \"al thamam 28 app 105\", \"firstName-1\": \"Yosra\", \"title\": \"Ms\", \"items\": \"discountAmount\", \"sku\": \"023325789369\", \"unitRetail\": \"980.0\", \"productPricePaid\": \"540.0\", \"taxPercentage-1\": \"5.0\", \"comments\": \"\", \"vpn\": \"\", \"quantitySign\": \"P\", \"concessionSku\": \"\", \"originCountry\": \"AE\", \"taxAmount-1\": \"25.71\", \"quantity\": \"1\", \"orderId\": \"APPENUAE8003110000002927450\", \"transactionTime\": \"2022-07-14T12\", \"transactionNumber\": \"3000001236\", \"locale\": \"en_US\", \"store\": \"8003\", \"payment\": \"amount\", \"paymentTypeId\": \"3000\", \"paymentCurrency\": \"AED\", \"paymentType\": \"CCARD\", \"paymentCurrencyAmount\": \"540.0\", \"paymentId\": \"pay_5zbtu7v5ydjkze3drrfh5fj5pq\", \"businessDate\": \"20220714\", \"baseCurrency\": \"AED\", \"initiatedBy\": \"Mobileapp\", \"delivery\": \"type\", \"endTime\": \"2022-07-14T14\", \"startTime\": \"2022-07-14T12\", \"status\": \"NEW\"}', '{\"module\": \"levelshoes_monitoring\", \"\'charges\": \"shippingTaxAmount\", \"shippingCharges\": \"0.0\", \"total\": \"540.0\", \"discount\": \"440.0\", \"taxAmount\": \"25.71\", \"subtotal\": \"980.0\", \"discountTaxAmount\": \"0\", \"shippingTaxPercentage\": \"0\", \"taxPercentage\": \"5.0\", \"discountTaxPercentage\": \"0\", \"transactionType\": \"LAYINT\", \"customer\": \"firstName\", \"lastName\": \"Jeljli\", \"id\": \"235897\", \"shipTo\": \"address\", \"latitude\": \"25.0040231\", \"line1\": \"remraam \", \"country\": \"AE\", \"longitude\": \"55.2478939\", \"line2\": \"al thamam 28 app 105\", \"firstName\": \"Yosra\", \"lastName-1\": \"Jeljli\", \"phone\": \"971505473070\", \"email\": \"[email protected]\", \"phone-1\": \"971505473070\", \"billTo\": \"title\", \"address\": \"line1\", \"city\": \"Dubai\", \"country-1\": \"AE\", \"line2-1\": \"al thamam 28 app 105\", \"firstName-1\": \"Yosra\", \"title\": \"Ms\", \"items\": \"discountAmount\", \"sku\": \"023325789369\", \"unitRetail\": \"980.0\", \"productPricePaid\": \"540.0\", \"taxPercentage-1\": \"5.0\", \"comments\": \"\", \"vpn\": \"\", \"quantitySign\": \"P\", \"concessionSku\": \"\", \"originCountry\": \"AE\", \"taxAmount-1\": \"25.71\", \"quantity\": \"1\", \"orderId\": \"APPENUAE8003110000002927450\", \"transactionTime\": \"2022-07-14T12\", \"transactionNumber\": \"3000001236\", \"locale\": \"en_US\", \"store\": \"8003\", \"payment\": \"amount\", \"paymentTypeId\": \"3000\", \"paymentCurrency\": \"AED\", \"paymentType\": \"CCARD\", \"paymentCurrencyAmount\": \"540.0\", \"paymentId\": \"pay_5zbtu7v5ydjkze3drrfh5fj5pq\", \"businessDate\": \"20220714\", \"baseCurrency\": \"AED\", \"initiatedBy\": \"Mobileapp\", \"delivery\": \"type\", \"endTime\": \"2022-07-14T14\", \"startTime\": \"2022-07-14T12\", \"status\": \"NEW\'\"}', '2022-07-14 04:47:28'),
(1812085, 'APPENKSA8003110000003165351', '{\"module\": \"levelshoes_monitoring\", \"version\": \"4.24.1\", \"build\": \"4.24.1.4\", \"shippingAddress\": \"id\", \"customerId\": \"137634\", \"region\": \"region\", \"regionCode\": \"nil\", \"regionID\": \"nil\", \"regionId\": \"0\", \"countryId\": \"SA\", \"street\": \"almaseef district \", \"company\": \"nil\", \"telephone\": \"966555560202\", \"postcode\": \"000000\", \"city\": \"Riyadh\", \"firstname\": \"Rawaa\", \"lastname\": \"Alsahhaf\", \"defaultShipping\": \"true\", \"defaultBilling\": \"true\", \"prefix\": \"Mrs\", \"isselected\": \"nil\", \"customAttributes\": \"attributeCode\", \"value\": \"home\", \"email\": \"nil\", \"isclickandcollect\": \"false\", \"cartDetails\": \"CartTotalModelgrandTotal\", \"baseGrandTotal\": \"246.65\", \"subtotal\": \"190.0\", \"baseSubtotal\": \"190.0\", \"discountAmount\": \"-21.85\", \"baseDiscountAmount\": \"-21.85\", \"subtotalWithDiscount\": \"168.15\", \"baseSubtotalWithDiscount\": \"168.15\", \"shippingAmount\": \"50.0\", \"baseShippingAmount\": \"50.0\", \"shippingDiscountAmount\": \"0.0\", \"baseShippingDiscountAmount\": \"0.0\", \"taxAmount\": \"28.5\", \"baseTaxAmount\": \"28.5\", \"weeeTaxAppliedAmount\": \"nil\", \"shippingTaxAmount\": \"0.0\", \"baseShippingTaxAmount\": \"0.0\", \"subtotalInclTax\": \"218.5\", \"shippingInclTax\": \"50.0\", \"coupon_code\": \"\\\\DSS15\\\\\", \"taxPercentage\": \"nil\", \"baseShippingInclTax\": \"50.0\", \"baseCurrencyCode\": \"\\\\SAR\\\\\", \"quoteCurrencyCode\": \"\\\\SAR\\\\\", \"itemsQty\": \"1\", \"items\": \"itemID\", \"price\": \"190.0\", \"basePrice\": \"190.0\", \"qty\": \"1\", \"rowTotal\": \"190.0\", \"baseRowTotal\": \"190.0\", \"rowTotalWithDiscount\": \"nil\", \"taxPercent\": \"15.0\", \"taxAmount-1\": \"28.5\", \"discountAmount-1\": \"21.85\", \"baseDiscountAmount-1\": \"21.85\", \"baseTaxAmount-1\": \"28.5\", \"discountPercent\": \"nil\", \"priceInclTax\": \"218.5\", \"basePriceInclTax\": \"nil\", \"rowTotalInclTax\": \"nil\", \"baseRowTotalInclTax\": \"nil\", \"options\": \"\\\\\\\\\\\\\\\\value\\\\\\\\\\\\\", \"\\\\\\\\\\\\label\\\\\\\\\\\\\": \"\\\\\\\\\\\\Size\\\\\\\\\\\\\\\\\", \"weeeTaxAppliedAmount-1\": \"nil\", \"weeeTaxApplied\": \"nil\", \"extensionAttributes\": \"isFreeProduct\", \"originalRowTotal\": \"320.0\", \"lvl_concession_core_sku\": \"\\\\NA\\\\\", \"zone\": \"255\", \"sku\": \"\\\\054825689095\\\\\", \"brand\": \"\\\\Schutz\\\\\", \"image\": \"\\\\/s/2/s2093200130020u-xzkb-x327_1.jpg\\\\\", \"is_pre_order\": \"\\\\0\\\\\", \"pre_order_expected_date\": \"nil\", \"museReward\": \"190\", \"name\": \"\\\\Posseni sandals \\\\\", \"totalSegments\": \"code\", \"title\": \"\\\\Subtotal\\\\\", \"value-1\": \"0.0\", \"extensionAttributes-1\": \"TotalshippingAssignments\", \"area\": \"nil\", \"code\": \"\\\\giftwrapping\\\\\", \"title-1\": \"\\\\0 Reward points\\\\\", \"gwBasePrice\": \"\\\\0.0000\\\\\", \"gwItemsPrice\": \"\\\\0.0000\\\\\", \"gwItemsBasePrice\": \"\\\\0.0000\\\\\", \"gwCardPrice\": \"\\\\0.0000\\\\\", \"gwCardBasePrice\": \"\\\\0.0000\\\\\", \"taxGrandtotalDetails\": \"nil\", \"gift_cards\": \"nil\", \"area-1\": \"nil\", \"code-1\": \"\\\\reward\\\\\", \"gwBasePrice-1\": \"nil\", \"gwItemsPrice-1\": \"nil\", \"gwItemsBasePrice-1\": \"nil\", \"gwCardPrice-1\": \"nil\", \"gwCardBasePrice-1\": \"nil\", \"taxGrandtotalDetails-1\": \"amount\", \"rates\": \"percent\", \"groupID\": \"nil\", \"gift_cards-1\": \"nil\", \"isSubscribed\": \"nil\", \"levelupText\": \"nil\", \"museCartTotalDetail\": \"LevelShoes.MuseCartModellvlMuseRedeemablePoints\", \"text\": \"nil\", \"lvlMuseRedeemableAmount\": \"LevelShoes.MusePointsModelvalue\", \"text-1\": \"\\\\Earn 190 points with this purchase\\\\\", \"lvlMuseEarnPoints\": \"LevelShoes.MusePointsModelvalue\", \"lvlMuseGuestEarnPoints\": \"LevelShoes.MusePointsModelvalue\", \"lvlMuseMemberId\": \"\\\\\\\\\", \"paymentMethods\": \"LevelShoes.PaymentMethodiconURL\", \"type\": \"\\\\card\\\\\", \"icon\": \"nil\", \"LevelShoes.PaymentMethodiconURL\": \"\\\\https\", \"type-1\": \"\\\\cod\\\\\", \"icon-1\": \"nil\", \"LevelShoes.PaymentMethodiconURL-1\": \"\\\\https\", \"paymentAssurance\": \"LevelShoes.PaymentAssurancemessage\", \"iconURL\": \"https\"}', '{\"module\": \"levelshoes_monitoring\", \"\'delivery\": \"type\", \"initiatedBy\": \"Mobileapp\", \"locale\": \"en_US\", \"charges\": \"total\", \"shippingCharges\": \"50.0\", \"subtotal\": \"348.5\", \"discountTaxAmount\": \"0\", \"discount\": \"151.85\", \"shippingTaxPercentage\": \"0\", \"shippingTaxAmount\": \"0.0\", \"taxAmount\": \"28.5\", \"taxPercentage\": \"15.0\", \"discountTaxPercentage\": \"0\", \"items\": \"discountAmount\", \"taxPercentage-1\": \"0\", \"quantitySign\": \"P\", \"taxAmount-1\": \"0\", \"comments\": \"\", \"unitRetail\": \"320.0\", \"sku\": \"054825689095\", \"quantity\": \"1\", \"vpn\": \"\", \"productPricePaid\": \"196.65\", \"concessionSku\": \"\", \"sku-1\": \"262513883290\", \"discountAmount\": \"0\", \"quantity-1\": \"1\", \"unitRetail-1\": \"28.5\", \"comments-1\": \"Custom Duty Charge\", \"quantitySign-1\": \"P\", \"productPricePaid-1\": \"28.5\", \"businessDate\": \"20220714\", \"customer\": \"id\", \"email\": \"[email protected]\", \"billTo\": \"title\", \"lastName\": \"Alsahhaf\", \"firstName\": \"Rawaa\", \"address\": \"line1\", \"city\": \"Riyadh\", \"country\": \"SA\", \"line2\": \"aljunaify street\", \"phone\": \"966555560202\", \"shipTo\": \"lastName\", \"firstName-1\": \"Rawaa\", \"phone-1\": \"966555560202\", \"address-1\": \"longitude\", \"city-1\": \"Riyadh\", \"line2-1\": \"aljunaify street\", \"line1\": \"almaseef district \", \"country-1\": \"SA\", \"latitude\": \"25.198765\", \"title\": \"Mrs\", \"lastName-1\": \"Alsahhaf\", \"store\": \"8003\", \"transactionType\": \"LAYINT\", \"payment\": \"coupon\", \"paymentTypeId\": \"6003\", \"paymentCurrencyAmount\": \"246.65\", \"paymentType\": \"CCARD\", \"paymentCurrency\": \"SAR\", \"amount\": \"246.65\", \"paymentId\": \"pay_awkvnn7unx7khh2qazh22iynnq\", \"status\": \"NEW\", \"orderId\": \"APPENKSA8003110000003165351\", \"baseCurrency\": \"SAR\", \"transactionNumber\": \"3000001236\", \"transactionTime\": \"2022-07-14T13\"}', '2022-07-14 04:56:57'),
