Dump data 29.08.2024
SQL files - 9.5GB
sample:
INSERT INTO `ps_customer_09_08_24` (`id_customer`, `id_shop_group`, `id_shop`, `id_gender`, `id_default_group`, `id_lang`, `id_risk`, `company`, `siret`, `ape`, `firstname`, `lastname`, `email`, `passwd`, `last_passwd_gen`, `birthday`, `newsletter`, `ip_registration_newsletter`, `newsletter_date_add`, `optin`, `website`, `outstanding_allow_amount`, `show_public_prices`, `max_payment_days`, `secure_key`, `note`, `active`, `is_guest`, `deleted`, `date_add`, `date_upd`, `reset_password_token`, `reset_password_validity`, `facturauto`, `is_company_art`) VALUES
(237370, 1, 1, 0, 3, 11, 0, NULL, NULL, NULL, 'Ana', 'Courelas', '39ab052a-d666-4235-b0ad-300d54bc9bc9@marketplace.fnac.com', '3d59ef06f9aef1074c4637e9d2d0eed2', '2022-02-22 17:15:03', '0000-00-00', 0, NULL, '0000-00-00 00:00:00', 0, NULL, '0.000000', 0, 0, 'b068e15ae6703a6ed0189ed47756f650', NULL, 1, 0, 0, '2022-02-23 00:15:03', '2022-02-23 00:15:03', NULL, '0000-00-00 00:00:00', 0, 0),
(237371, 1, 1, 0, 3, 11, 0, NULL, NULL, NULL, 'Jamie', 'Baker Kennett', 'bpjn2nhgtpnkvtj@marketplace.amazon.co.uk', 'b875c4af8754cc6f2b718f9a8624bd90', '2022-02-22 17:15:12', '0000-00-00', 0, NULL, '0000-00-00 00:00:00', 0, NULL, '0.000000', 0, 0, 'efab6ef2a4009e36eacd174ba29395b1', NULL, 1, 0, 0, '2022-02-23 00:15:12', '2022-02-23 00:15:12', NULL, '0000-00-00 00:00:00', 0, 0),
(237372, 1, 1, 0, 3, 1, 0, NULL, NULL, NULL, 'Jesus', 'Jesus', 'jjzgycj1jggfsd9@marketplace.amazon.es', '60e61d8bc23ce1519c5cca9057aeb01d', '2022-02-22 17:15:16', '0000-00-00', 0, NULL, '0000-00-00 00:00:00', 0, NULL, '0.000000', 0, 0, 'ffe3a57ab455a6f6255b19ff034f600f', NULL, 1, 0, 0, '2022-02-23 00:15:16', '2022-02-23 00:15:16', NULL, '0000-00-00 00:00:00', 0, 0),
INSERT INTO `ps_migrationpro_pass` (`id`, `id_customer`, `mail`, `passwd`) VALUES
(394241, 61972, 'bljdq6k5p9nnfs2@marketplace.amazon.co.uk', 'c92f8e8b429998f748125ccb9db4a7fc'),
(394242, 61973, 'j77bd87n3w3f52h@marketplace.amazon.co.uk', 'f55bec12468f70b0eb50aa7961c41e4f'),
(394243, 61974, 'lgf7cfhz6m9hnqr@marketplace.amazon.fr', '8a6266bbae9b9a9d9ebcbec56bc18689'),
INSERT INTO `ps_address_14_02_2024` (`id_address`, `id_country`, `id_state`, `id_customer`, `id_manufacturer`, `id_supplier`, `id_warehouse`, `alias`, `company`, `lastname`, `firstname`, `address1`, `address2`, `postcode`, `city`, `other`, `phone`, `phone_mobile`, `vat_number`, `dni`, `date_add`, `date_upd`, `active`, `deleted`) VALUES
(140346, 6, 0, 121495, 0, 0, 0, '1fbd192c9c427e1c28527464ee8917cd', '', 'Arellano', 'Iria', 'C/Ausias March, 128, 2Вє 1Вє', '', '08013', 'Barcelona', '', '630893523', '630893523', '46991780C', '46991780C', '2019-11-28 17:40:13', '2019-11-28 17:40:13', 1, 0),
(140347, 6, 351, 121497, 0, 0, 0, '2ebacf45317f29e01dc4a5d832b1df2f', '', 'Cuevas', 'Jose Antonio de las', 'CALLE ALHUCEMA, 12', 'Montequinto', '41089', 'DOS HERMANAS', '', '656634988', '', '', '', '2019-11-28 17:45:15', '2019-11-28 17:45:15', 1, 0),
INSERT INTO `ps_orders_29_05_2024` (`id_order`, `reference`, `id_shop_group`, `id_shop`, `id_carrier`, `id_lang`, `id_customer`, `id_cart`, `id_currency`, `id_address_delivery`, `id_address_invoice`, `current_state`, `secure_key`, `payment`, `conversion_rate`, `module`, `recyclable`, `gift`, `gift_message`, `mobile_theme`, `shipping_number`, `total_discounts`, `total_discounts_tax_incl`, `total_discounts_tax_excl`, `total_paid`, `total_paid_tax_incl`, `total_paid_tax_excl`, `total_paid_real`, `total_products`, `total_products_wt`, `total_shipping`, `total_shipping_tax_incl`, `total_shipping_tax_excl`, `carrier_tax_rate`, `total_wrapping`, `total_wrapping_tax_incl`, `total_wrapping_tax_excl`, `round_mode`, `round_type`, `invoice_number`, `delivery_number`, `invoice_date`, `delivery_date`, `valid`, `date_add`, `date_upd`, `mp_order_id`, `mp_status`, `canal`) VALUES
(472661, 'frBMKXZSXCC', 1, 1, 394, 1, 326282, 1072883, 1, 404987, 404987, 5, '', 'Pagos por transferencia bancaria', '1.000000', 'ps_wirepayment', 0, 0, '', 0, '', '0.000000', '0.000000', '0.000000', '20.500000', '20.500000', '16.940000', '20.500000', '14.050000', '17.000000', '3.500000', '3.500000', '2.890000', '21.000', '0.000000', '0.000000', '0.000000', 0, 0, 0, 462739, '0000-00-00 00:00:00', '2024-01-03 21:11:57', 1, '2023-12-28 05:28:29', '2024-01-03 21:11:58', '830', NULL, 'Frikiverso'),
(472662, 'RWUIJDIDY', 1, 1, 330, 13, 326283, 1072884, 5, 404988, 404988, 21, '63c7b1e9afd22a0438103a70bd7a590b', 'Amazon MarketPlace', '1.457672', 'amazon', 0, 0, '', 0, 'LR028015115NL', '0.000000', '0.000000', '0.000000', '75.220000', '75.220000', '75.220000', '75.220000', '50.220000', '50.220000', '25.000000', '25.000000', '25.000000', '0.000', '0.000000', '0.000000', '0.000000', 2, 3, 0, 462740, '0000-00-00 00:00:00', '2023-12-28 15:32:00', 1, '2023-12-28 04:11:58', '2023-12-28 15:32:00', '', 6, 'Amazon'),
Is this really you tanaka?
thanku so much