INSERT INTO `quote` (`entity_id`, `store_id`, `created_at`, `updated_at`, `converted_at`, `is_active`, `is_virtual`, `is_multi_shipping`, `items_count`, `items_qty`, `orig_order_id`, `store_to_base_rate`, `store_to_quote_rate`, `base_currency_code`, `store_currency_code`, `quote_currency_code`, `grand_total`, `base_grand_total`, `checkout_method`, `customer_id`, `customer_tax_class_id`, `customer_group_id`, `customer_email`, `customer_prefix`, `customer_firstname`, `customer_middlename`, `customer_lastname`, `customer_suffix`, `customer_dob`, `customer_note`, `customer_note_notify`, `customer_is_guest`, `remote_ip`, `applied_rule_ids`, `reserved_order_id`, `password_hash`, `coupon_code`, `global_currency_code`, `base_to_global_rate`, `base_to_quote_rate`, `customer_taxvat`, `customer_gender`, `subtotal`, `base_subtotal`, `subtotal_with_discount`, `base_subtotal_with_discount`, `is_changed`, `trigger_recollect`, `ext_shipping_info`, `is_persistent`, `gift_message_id`, `store_code`, `store_name`, `pic_type_commande`, `redevance_dob`, `redevance_country`, `redevance_city`, `redevance_postcode`, `shipping_uuid`, `frais_traitement`) VALUES (1563368, 1, '2017-11-18 11:57:26', '2017-11-24 16:59:20', NULL, 1, 0, 0, 1, 1.0000, 0, 0.0000, 0.0000, 'EUR', 'EUR', 'EUR', 269.8300, 269.8300, NULL, 2823396, 3, 1, 'jordan.choplin@laposte.net', NULL, 'Jordan', NULL, 'Choplin', NULL, NULL, NULL, 1, 0, '91.195.164.7', NULL, NULL, NULL, NULL, 'EUR', 1.0000, 1.0000, NULL, '1', 253.8300, 253.8300, 253.8300, 253.8300, 1, 1, NULL, 0, NULL, '', '', 1, NULL, NULL, NULL, NULL, NULL, NULL);





INSERT INTO `quote_item` (`item_id`, `quote_id`, `created_at`, `updated_at`, `product_id`, `store_id`, `parent_item_id`, `is_virtual`, `sku`, `name`, `description`, `applied_rule_ids`, `additional_data`, `is_qty_decimal`, `no_discount`, `weight`, `qty`, `price`, `base_price`, `custom_price`, `discount_percent`, `discount_amount`, `base_discount_amount`, `tax_percent`, `tax_amount`, `base_tax_amount`, `row_total`, `base_row_total`, `row_total_with_discount`, `row_weight`, `product_type`, `base_tax_before_discount`, `tax_before_discount`, `original_custom_price`, `redirect_url`, `base_cost`, `price_incl_tax`, `base_price_incl_tax`, `row_total_incl_tax`, `base_row_total_incl_tax`, `discount_tax_compensation_amount`, `base_discount_tax_compensation_amount`, `free_shipping`, `gift_message_id`, `weee_tax_applied`, `weee_tax_applied_amount`, `weee_tax_applied_row_amount`, `weee_tax_disposition`, `weee_tax_row_disposition`, `base_weee_tax_applied_amount`, `base_weee_tax_applied_row_amnt`, `base_weee_tax_disposition`, `base_weee_tax_row_disposition`, `is_differe`, `screenable`, `related_warranty_id`, `related_warranty_qty`) VALUES (1170722, 1563368, '2017-11-24 15:52:51', '0000-00-00 00:00:00', 8082, 1, NULL, 0, '000000000000955308', 'Réfrigérateur combiné VALBERG CNF 295 A+ WMIC', NULL, NULL, NULL, 0, 0, 74.0000, 1.0000, 253.8300, 253.8300, NULL, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 253.8300, 253.8300, 0.0000, 74.0000, 'simple', NULL, NULL, NULL, NULL, NULL, 253.8300, 253.8300, 253.8300, 253.8300, 0.0000, 0.0000, 0, NULL, '[{"code":"tax_ecotax","title":"d\'\\u00e9co-participation","base_amount":"16.0000","amount":16,"row_amount":16,"base_row_amount":16,"base_amount_incl_tax":"16.0000","amount_incl_tax":16,"row_amount_incl_tax":16,"base_row_amount_incl_tax":16}]', 16.0000, 16.0000, 0.0000, 0.0000, 16.0000, 16.0000, 0.0000, 0.0000, 0, 1, NULL, NULL);





INSERT INTO `quote_address` (`address_id`, `quote_id`, `created_at`, `updated_at`, `customer_id`, `save_in_address_book`, `customer_address_id`, `address_type`, `email`, `prefix`, `firstname`, `middlename`, `lastname`, `suffix`, `company`, `street`, `city`, `region`, `region_id`, `postcode`, `country_id`, `telephone`, `fax`, `same_as_billing`, `collect_shipping_rates`, `shipping_method`, `shipping_description`, `weight`, `subtotal`, `base_subtotal`, `subtotal_with_discount`, `base_subtotal_with_discount`, `tax_amount`, `base_tax_amount`, `shipping_amount`, `base_shipping_amount`, `shipping_tax_amount`, `base_shipping_tax_amount`, `discount_amount`, `base_discount_amount`, `grand_total`, `base_grand_total`, `customer_notes`, `applied_taxes`, `discount_description`, `shipping_discount_amount`, `base_shipping_discount_amount`, `subtotal_incl_tax`, `base_subtotal_total_incl_tax`, `discount_tax_compensation_amount`, `base_discount_tax_compensation_amount`, `shipping_discount_tax_compensation_amount`, `base_shipping_discount_tax_compensation_amnt`, `shipping_incl_tax`, `base_shipping_incl_tax`, `free_shipping`, `vat_id`, `vat_is_valid`, `vat_request_id`, `vat_request_date`, `vat_request_success`, `gift_message_id`, `horaire`, `nom_retrait`, `code_relay`, `instructions`, `gender`, `shipping_date`, `shipping_size`) VALUES (2528961, 1563368, '2017-11-18 11:57:26', '2017-11-24 16:59:50', 2823396, 0, NULL, 'shipping', 'jordan.choplin@laposte.net', NULL, 'Jordan', NULL, 'Choplin', NULL, NULL, '2 RUE EMILE GALLE              \nZAC EUROMOSELLE NORD', 'MAIZIERES LES METZ        ', NULL, 0, '57280', 'FR', '0601095309', NULL, 0, 1, 'tablerate_mr_cd', NULL, 74.0000, 253.8300, 253.8300, 253.8300, 253.8300, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 269.8300, 269.8300, NULL, 'a:0:{}', NULL, 0.0000, 0.0000, 269.8300, 253.8300, 0.0000, 0.0000, 0.0000, NULL, 0.0000, 0.0000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '{"horairesOuvertureMonday":"08:30-12:00 14:00-18:00","horairesOuvertureTuesday":"08:30-12:00 14:00-18:00","horairesOuvertureWednesday":"08:30-12:00 14:00-18:00","horairesOuvertureThursday":"08:30-12:00 14:00-18:00","horairesOuvertureFriday":"08:30-12:00 14:00-18:00","horairesOuvertureSaturday":"08:30-12:00 00:00-00:00","horairesOuvertureSunday":"00:00-00:00 00:00-00:00"}', 'MONDIAL RELAY METZ             ', '009822', NULL, NULL, NULL, NULL);

INSERT INTO `quote_address` (`address_id`, `quote_id`, `created_at`, `updated_at`, `customer_id`, `save_in_address_book`, `customer_address_id`, `address_type`, `email`, `prefix`, `firstname`, `middlename`, `lastname`, `suffix`, `company`, `street`, `city`, `region`, `region_id`, `postcode`, `country_id`, `telephone`, `fax`, `same_as_billing`, `collect_shipping_rates`, `shipping_method`, `shipping_description`, `weight`, `subtotal`, `base_subtotal`, `subtotal_with_discount`, `base_subtotal_with_discount`, `tax_amount`, `base_tax_amount`, `shipping_amount`, `base_shipping_amount`, `shipping_tax_amount`, `base_shipping_tax_amount`, `discount_amount`, `base_discount_amount`, `grand_total`, `base_grand_total`, `customer_notes`, `applied_taxes`, `discount_description`, `shipping_discount_amount`, `base_shipping_discount_amount`, `subtotal_incl_tax`, `base_subtotal_total_incl_tax`, `discount_tax_compensation_amount`, `base_discount_tax_compensation_amount`, `shipping_discount_tax_compensation_amount`, `base_shipping_discount_tax_compensation_amnt`, `shipping_incl_tax`, `base_shipping_incl_tax`, `free_shipping`, `vat_id`, `vat_is_valid`, `vat_request_id`, `vat_request_date`, `vat_request_success`, `gift_message_id`, `horaire`, `nom_retrait`, `code_relay`, `instructions`, `gender`, `shipping_date`, `shipping_size`) VALUES (2535242, 1563368, '2017-11-18 16:07:18', '0000-00-00 00:00:00', 2823396, 0, NULL, 'billing', 'jordan.choplin@laposte.net', NULL, 'Jordan', NULL, 'Choplin', NULL, NULL, '49 rue principale', 'JURY', NULL, NULL, '57245', 'FR', '0601095309', NULL, 0, 0, NULL, NULL, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, NULL, NULL, 0.0000, 0.0000, 0.0000, 0.0000, NULL, 'N;', NULL, NULL, NULL, 0.0000, NULL, 0.0000, 0.0000, 0.0000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '14', NULL, NULL);



INSERT INTO `quote_item_option` (`option_id`, `item_id`, `product_id`, `code`, `value`) VALUES (1170713, 1170722, 8082, 'info_buyRequest', 'a:7:{s:4:"uenc";s:112:"aHR0cHM6Ly93d3cuZWxlY3Ryb2RlcG90LmZyL3JlZnJpZ2VyYXRldXItY29tYmluZS12YWxiZXJnLWNuZi0yOTUtYS13bWljLTgxNjcuaHRtbA,,";s:7:"product";s:4:"8167";s:17:"pic_type_commande";s:1:"1";s:19:"is_related_warranty";s:0:"";s:28:"selected_configurable_option";s:0:"";s:15:"related_product";s:0:"";s:3:"qty";s:1:"1";}');





INSERT INTO `quote_payment` (`payment_id`, `quote_id`, `created_at`, `updated_at`, `method`, `cc_type`, `cc_number_enc`, `cc_last_4`, `cc_cid_enc`, `cc_owner`, `cc_exp_month`, `cc_exp_year`, `cc_ss_owner`, `cc_ss_start_month`, `cc_ss_start_year`, `po_number`, `additional_data`, `cc_ss_issue`, `additional_information`, `paypal_payer_id`, `paypal_payer_status`, `paypal_correlation_id`) VALUES (266023, 1563368, '2017-11-18 16:07:18', '0000-00-00 00:00:00', 'atos_standard', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, 0, NULL, NULL, NULL, 'N;', NULL, NULL, NULL);