Advertisement
froks

Untitled

Jul 18th, 2017
183
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 72.98 KB | None | 0 0
  1. ##QUOTES
  2.  
  3. INSERT INTO quote (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, ebizmarts_abandonedcart_counter, ebizmarts_abandonedcart_flag, ebizmarts_abandonedcart_token, is_persistent, gift_message_id) VALUES (1, '2017-07-18 21:48:04', null, null, 1, 0, 0, 0, 0.0000, 0, 0.0000, 0.0000, 'EUR', 'EUR', 'EUR', 0.0000, 0.0000, null, null, null, 0, null, null, null, null, null, null, null, null, 1, 0, '2001:8a0:ddc7:9e01:20c5:5ccf:bdf', null, null, null, null, 'EUR', 1.0000, 1.0000, null, null, 0.0000, 0.0000, 0.0000, 0.0000, 1, 0, null, 0, 0, '0', 0, null);
  4. INSERT INTO quote (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, ebizmarts_abandonedcart_counter, ebizmarts_abandonedcart_flag, ebizmarts_abandonedcart_token, is_persistent, gift_message_id) VALUES (1, '2017-07-18 21:41:49', null, null, 1, 0, 0, 1, 1.0000, 0, 0.0000, 0.0000, 'EUR', 'EUR', 'EUR', 14.9000, 14.9000, null, null, 3, 0, null, null, null, null, null, null, null, null, 1, 0, '2001:8a0:f815:101:142a:d6f6:6330', null, null, null, null, 'EUR', 1.0000, 1.0000, null, null, 14.0600, 14.0600, 14.0600, 14.0600, 1, 0, null, 0, 0, '0', 0, null);
  5. INSERT INTO quote (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, ebizmarts_abandonedcart_counter, ebizmarts_abandonedcart_flag, ebizmarts_abandonedcart_token, is_persistent, gift_message_id) VALUES (1, '2017-07-18 21:41:31', null, null, 1, 0, 0, 1, 1.0000, 0, 0.0000, 0.0000, 'EUR', 'EUR', 'EUR', 54.5100, 54.5100, null, null, 3, 0, null, null, null, null, null, null, null, null, 1, 0, '81.193.227.202', null, null, null, null, 'EUR', 1.0000, 1.0000, null, null, 51.4200, 51.4200, 51.4200, 51.4200, 1, 0, null, 0, 0, '0', 0, null);
  6. INSERT INTO quote (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, ebizmarts_abandonedcart_counter, ebizmarts_abandonedcart_flag, ebizmarts_abandonedcart_token, is_persistent, gift_message_id) VALUES (1, '2017-07-18 21:37:23', null, null, 1, 0, 0, 0, 0.0000, 0, 0.0000, 0.0000, 'EUR', 'EUR', 'EUR', 0.0000, 0.0000, null, 26942, null, 1, 'ana.1d.piolho@gmail.com', null, 'Ana', null, 'Almeida', null, null, null, 1, 0, '2001:8a0:e27e:4d01:d81f:e27f:b90', null, null, null, null, 'EUR', 1.0000, 1.0000, null, null, 0.0000, 0.0000, 0.0000, 0.0000, 1, 0, null, 0, 0, '0', 0, null);
  7. INSERT INTO quote (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, ebizmarts_abandonedcart_counter, ebizmarts_abandonedcart_flag, ebizmarts_abandonedcart_token, is_persistent, gift_message_id) VALUES (1, '2017-07-18 21:36:09', null, null, 1, 0, 0, 1, 1.0000, 0, 0.0000, 0.0000, 'EUR', 'EUR', 'EUR', 4.5400, 4.5400, null, null, 3, 0, null, null, null, null, null, null, null, null, 1, 0, '193.126.174.180', null, null, null, null, 'EUR', 1.0000, 1.0000, null, null, 3.6900, 3.6900, 3.6900, 3.6900, 1, 0, null, 0, 0, '0', 0, null);
  8. INSERT INTO quote (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, ebizmarts_abandonedcart_counter, ebizmarts_abandonedcart_flag, ebizmarts_abandonedcart_token, is_persistent, gift_message_id) VALUES (1, '2017-07-18 21:30:23', null, null, 1, 0, 0, 0, 0.0000, 0, 0.0000, 0.0000, 'EUR', 'EUR', 'EUR', 0.0000, 0.0000, null, 26869, null, 1, 'jess-ica.gregorio@hotmail.com', null, 'Jéssica', null, 'Gregório', null, null, null, 1, 0, '89.180.62.158', null, null, null, null, 'EUR', 1.0000, 1.0000, null, null, 0.0000, 0.0000, 0.0000, 0.0000, 1, 0, null, 0, 0, '0', 0, null);
  9. INSERT INTO quote (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, ebizmarts_abandonedcart_counter, ebizmarts_abandonedcart_flag, ebizmarts_abandonedcart_token, is_persistent, gift_message_id) VALUES (1, '2017-07-18 21:24:31', null, null, 1, 0, 0, 1, 1.0000, 0, 0.0000, 0.0000, 'EUR', 'EUR', 'EUR', 33.6200, 33.6200, null, null, 3, 0, null, null, null, null, null, null, null, null, 1, 0, '94.60.205.155', null, null, null, null, 'EUR', 1.0000, 1.0000, null, null, 27.3300, 27.3300, 27.3300, 27.3300, 1, 0, null, 0, 0, '0', 0, null);
  10. INSERT INTO quote (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, ebizmarts_abandonedcart_counter, ebizmarts_abandonedcart_flag, ebizmarts_abandonedcart_token, is_persistent, gift_message_id) VALUES (1, '2017-07-18 21:22:18', null, null, 1, 0, 0, 0, 0.0000, 0, 0.0000, 0.0000, 'EUR', 'EUR', 'EUR', 0.0000, 0.0000, null, 18146, null, 1, 'rita_mestre93@hotmail.com', null, 'Rita', null, 'Araújo', null, null, null, 1, 0, '89.153.66.229', null, null, null, null, 'EUR', 1.0000, 1.0000, null, null, 0.0000, 0.0000, 0.0000, 0.0000, 1, 0, null, 0, 0, '0', 0, null);
  11. INSERT INTO quote (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, ebizmarts_abandonedcart_counter, ebizmarts_abandonedcart_flag, ebizmarts_abandonedcart_token, is_persistent, gift_message_id) VALUES (1, '2017-07-18 21:18:34', null, null, 1, 0, 0, 0, 0.0000, 0, 0.0000, 0.0000, 'EUR', 'EUR', 'EUR', 0.0000, 0.0000, null, null, null, 0, null, null, null, null, null, null, null, null, 1, 0, '89.153.142.19', null, null, null, null, 'EUR', 1.0000, 1.0000, null, null, 0.0000, 0.0000, 0.0000, 0.0000, 1, 0, null, 0, 0, '0', 0, null);
  12. INSERT INTO quote (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, ebizmarts_abandonedcart_counter, ebizmarts_abandonedcart_flag, ebizmarts_abandonedcart_token, is_persistent, gift_message_id) VALUES (1, '2017-07-18 21:14:57', null, null, 1, 0, 0, 0, 0.0000, 0, 0.0000, 0.0000, 'EUR', 'EUR', 'EUR', 0.0000, 0.0000, null, 6581, null, 1, 'anafseverino@hotmail.com', null, 'Ana', null, 'Severino', null, null, null, 1, 0, '37.28.202.114', null, null, null, null, 'EUR', 1.0000, 1.0000, '216140960', null, 0.0000, 0.0000, 0.0000, 0.0000, 1, 0, null, 0, 0, '0', 0, null);
  13.  
  14.  
  15. ## SALES_INVOICE
  16.  
  17. INSERT INTO sales_invoice (store_id, base_grand_total, shipping_tax_amount, tax_amount, base_tax_amount, store_to_order_rate, base_shipping_tax_amount, base_discount_amount, base_to_order_rate, grand_total, shipping_amount, subtotal_incl_tax, base_subtotal_incl_tax, store_to_base_rate, base_shipping_amount, total_qty, base_to_global_rate, subtotal, base_subtotal, discount_amount, billing_address_id, is_used_for_refund, order_id, email_sent, send_email, can_void_flag, state, shipping_address_id, store_currency_code, transaction_id, order_currency_code, base_currency_code, global_currency_code, increment_id, created_at, updated_at, 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, base_total_refunded, discount_description, customer_note, customer_note_notify, affiliateplus_discount, base_affiliateplus_discount, affiliate_credit, base_affiliate_credit, onestepcheckout_giftwrap_amount, onestepcheckout_base_giftwrap_amount) VALUES (1, 70.6100, 0.0000, 13.2000, 13.2000, 1.0000, 0.0000, 0.0000, 1.0000, 70.6100, 0.0000, 70.6100, 70.6100, 1.0000, 0.0000, 4.0000, 1.0000, 57.4100, 57.4100, 0.0000, 158122, null, 79061, null, null, 0, 2, 158121, 'EUR', null, 'EUR', 'EUR', 'EUR', '1000057022', '2017-07-18 20:55:09', '2017-07-18 20:55:09', 0.0000, 0.0000, 0.0000, null, 0.0000, 0.0000, null, null, null, null, null, null, null, null, 0.0000, null);
  18. INSERT INTO sales_invoice (store_id, base_grand_total, shipping_tax_amount, tax_amount, base_tax_amount, store_to_order_rate, base_shipping_tax_amount, base_discount_amount, base_to_order_rate, grand_total, shipping_amount, subtotal_incl_tax, base_subtotal_incl_tax, store_to_base_rate, base_shipping_amount, total_qty, base_to_global_rate, subtotal, base_subtotal, discount_amount, billing_address_id, is_used_for_refund, order_id, email_sent, send_email, can_void_flag, state, shipping_address_id, store_currency_code, transaction_id, order_currency_code, base_currency_code, global_currency_code, increment_id, created_at, updated_at, 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, base_total_refunded, discount_description, customer_note, customer_note_notify, affiliateplus_discount, base_affiliateplus_discount, affiliate_credit, base_affiliate_credit, onestepcheckout_giftwrap_amount, onestepcheckout_base_giftwrap_amount) VALUES (1, 76.9500, 0.0000, 14.3900, 14.3900, 1.0000, 0.0000, 0.0000, 1.0000, 76.9500, 0.0000, 76.9500, 76.9500, 1.0000, 0.0000, 3.0000, 1.0000, 62.5600, 62.5600, 0.0000, null, null, 79095, null, null, null, 2, null, 'EUR', '48P30455HT681601X', 'EUR', 'EUR', 'EUR', '1000057021', '2017-07-18 20:54:42', '2017-07-18 20:54:42', 0.0000, 0.0000, 0.0000, null, null, null, null, null, null, null, null, null, null, null, 0.0000, null);
  19. INSERT INTO sales_invoice (store_id, base_grand_total, shipping_tax_amount, tax_amount, base_tax_amount, store_to_order_rate, base_shipping_tax_amount, base_discount_amount, base_to_order_rate, grand_total, shipping_amount, subtotal_incl_tax, base_subtotal_incl_tax, store_to_base_rate, base_shipping_amount, total_qty, base_to_global_rate, subtotal, base_subtotal, discount_amount, billing_address_id, is_used_for_refund, order_id, email_sent, send_email, can_void_flag, state, shipping_address_id, store_currency_code, transaction_id, order_currency_code, base_currency_code, global_currency_code, increment_id, created_at, updated_at, 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, base_total_refunded, discount_description, customer_note, customer_note_notify, affiliateplus_discount, base_affiliateplus_discount, affiliate_credit, base_affiliate_credit, onestepcheckout_giftwrap_amount, onestepcheckout_base_giftwrap_amount) VALUES (1, 23.9500, 1.0800, 4.4700, 4.4700, 1.0000, 1.0800, 0.0000, 1.0000, 23.9500, 4.7200, 18.1500, 18.1500, 1.0000, 4.7200, 1.0000, 1.0000, 14.7600, 14.7600, 0.0000, 158156, null, 79078, null, null, 0, 2, 158155, 'EUR', null, 'EUR', 'EUR', 'EUR', '1000057020', '2017-07-18 20:48:55', '2017-07-18 20:48:55', 0.0000, 0.0000, 0.0000, null, 5.8000, 5.8000, null, null, null, null, null, null, null, null, 0.0000, null);
  20. INSERT INTO sales_invoice (store_id, base_grand_total, shipping_tax_amount, tax_amount, base_tax_amount, store_to_order_rate, base_shipping_tax_amount, base_discount_amount, base_to_order_rate, grand_total, shipping_amount, subtotal_incl_tax, base_subtotal_incl_tax, store_to_base_rate, base_shipping_amount, total_qty, base_to_global_rate, subtotal, base_subtotal, discount_amount, billing_address_id, is_used_for_refund, order_id, email_sent, send_email, can_void_flag, state, shipping_address_id, store_currency_code, transaction_id, order_currency_code, base_currency_code, global_currency_code, increment_id, created_at, updated_at, 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, base_total_refunded, discount_description, customer_note, customer_note_notify, affiliateplus_discount, base_affiliateplus_discount, affiliate_credit, base_affiliate_credit, onestepcheckout_giftwrap_amount, onestepcheckout_base_giftwrap_amount) VALUES (1, 36.0800, 0.0000, 6.7500, 6.7500, 0.0000, 0.0000, 0.0000, 1.0000, 36.0800, 0.0000, 36.0800, 36.0800, 0.0000, 0.0000, 3.0000, 1.0000, 29.3300, 29.3300, 0.0000, 158158, null, 79079, null, null, 0, 2, 158157, 'EUR', null, 'EUR', 'EUR', 'EUR', '1000057019', '2017-07-18 20:43:52', '2017-07-18 20:43:52', 0.0000, 0.0000, 0.0000, null, 0.0000, 0.0000, null, null, null, null, null, null, null, null, 0.0000, null);
  21. INSERT INTO sales_invoice (store_id, base_grand_total, shipping_tax_amount, tax_amount, base_tax_amount, store_to_order_rate, base_shipping_tax_amount, base_discount_amount, base_to_order_rate, grand_total, shipping_amount, subtotal_incl_tax, base_subtotal_incl_tax, store_to_base_rate, base_shipping_amount, total_qty, base_to_global_rate, subtotal, base_subtotal, discount_amount, billing_address_id, is_used_for_refund, order_id, email_sent, send_email, can_void_flag, state, shipping_address_id, store_currency_code, transaction_id, order_currency_code, base_currency_code, global_currency_code, increment_id, created_at, updated_at, 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, base_total_refunded, discount_description, customer_note, customer_note_notify, affiliateplus_discount, base_affiliateplus_discount, affiliate_credit, base_affiliate_credit, onestepcheckout_giftwrap_amount, onestepcheckout_base_giftwrap_amount) VALUES (1, 38.1800, 0.0000, 7.1400, 7.1400, 0.0000, 0.0000, 0.0000, 1.0000, 38.1800, 0.0000, 38.1800, 38.1800, 0.0000, 0.0000, 2.0000, 1.0000, 31.0400, 31.0400, 0.0000, 158160, null, 79080, null, null, 0, 2, 158159, 'EUR', null, 'EUR', 'EUR', 'EUR', '1000057018', '2017-07-18 20:37:36', '2017-07-18 20:37:36', 0.0000, 0.0000, 0.0000, null, 0.0000, 0.0000, null, null, null, null, null, null, null, null, 0.0000, null);
  22. INSERT INTO sales_invoice (store_id, base_grand_total, shipping_tax_amount, tax_amount, base_tax_amount, store_to_order_rate, base_shipping_tax_amount, base_discount_amount, base_to_order_rate, grand_total, shipping_amount, subtotal_incl_tax, base_subtotal_incl_tax, store_to_base_rate, base_shipping_amount, total_qty, base_to_global_rate, subtotal, base_subtotal, discount_amount, billing_address_id, is_used_for_refund, order_id, email_sent, send_email, can_void_flag, state, shipping_address_id, store_currency_code, transaction_id, order_currency_code, base_currency_code, global_currency_code, increment_id, created_at, updated_at, 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, base_total_refunded, discount_description, customer_note, customer_note_notify, affiliateplus_discount, base_affiliateplus_discount, affiliate_credit, base_affiliate_credit, onestepcheckout_giftwrap_amount, onestepcheckout_base_giftwrap_amount) VALUES (1, 144.2100, 0.0000, 26.9700, 26.9700, 1.0000, 0.0000, 0.0000, 1.0000, 144.2100, 0.0000, 144.2100, 144.2100, 1.0000, 0.0000, 5.0000, 1.0000, 117.2400, 117.2400, 0.0000, 158162, null, 79081, null, null, 0, 2, 158161, 'EUR', null, 'EUR', 'EUR', 'EUR', '1000057017', '2017-07-18 20:35:45', '2017-07-18 20:35:45', 0.0000, 0.0000, 0.0000, null, 0.0000, 0.0000, null, null, null, null, null, null, null, null, 0.0000, null);
  23. INSERT INTO sales_invoice (store_id, base_grand_total, shipping_tax_amount, tax_amount, base_tax_amount, store_to_order_rate, base_shipping_tax_amount, base_discount_amount, base_to_order_rate, grand_total, shipping_amount, subtotal_incl_tax, base_subtotal_incl_tax, store_to_base_rate, base_shipping_amount, total_qty, base_to_global_rate, subtotal, base_subtotal, discount_amount, billing_address_id, is_used_for_refund, order_id, email_sent, send_email, can_void_flag, state, shipping_address_id, store_currency_code, transaction_id, order_currency_code, base_currency_code, global_currency_code, increment_id, created_at, updated_at, 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, base_total_refunded, discount_description, customer_note, customer_note_notify, affiliateplus_discount, base_affiliateplus_discount, affiliate_credit, base_affiliate_credit, onestepcheckout_giftwrap_amount, onestepcheckout_base_giftwrap_amount) VALUES (1, 63.6500, 0.0000, 11.9000, 11.9000, 0.0000, 0.0000, 0.0000, 1.0000, 63.6500, 0.0000, 63.6500, 63.6500, 0.0000, 0.0000, 1.0000, 1.0000, 51.7500, 51.7500, 0.0000, 158164, null, 79082, null, null, 0, 2, 158163, 'EUR', null, 'EUR', 'EUR', 'EUR', '1000057016', '2017-07-18 20:32:54', '2017-07-18 20:32:54', 0.0000, 0.0000, 0.0000, null, 0.0000, 0.0000, null, null, null, null, null, null, null, null, 0.0000, null);
  24. INSERT INTO sales_invoice (store_id, base_grand_total, shipping_tax_amount, tax_amount, base_tax_amount, store_to_order_rate, base_shipping_tax_amount, base_discount_amount, base_to_order_rate, grand_total, shipping_amount, subtotal_incl_tax, base_subtotal_incl_tax, store_to_base_rate, base_shipping_amount, total_qty, base_to_global_rate, subtotal, base_subtotal, discount_amount, billing_address_id, is_used_for_refund, order_id, email_sent, send_email, can_void_flag, state, shipping_address_id, store_currency_code, transaction_id, order_currency_code, base_currency_code, global_currency_code, increment_id, created_at, updated_at, 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, base_total_refunded, discount_description, customer_note, customer_note_notify, affiliateplus_discount, base_affiliateplus_discount, affiliate_credit, base_affiliate_credit, onestepcheckout_giftwrap_amount, onestepcheckout_base_giftwrap_amount) VALUES (1, 73.9000, 0.0000, 13.8200, 13.8200, 0.0000, 0.0000, 0.0000, 1.0000, 73.9000, 0.0000, 73.9000, 73.9000, 0.0000, 0.0000, 3.0000, 1.0000, 60.0800, 60.0800, 0.0000, 158172, null, 79086, null, null, 0, 2, 158171, 'EUR', null, 'EUR', 'EUR', 'EUR', '1000057015', '2017-07-18 20:23:00', '2017-07-18 20:23:00', 0.0000, 0.0000, 0.0000, null, 0.0000, 0.0000, null, null, null, null, null, null, null, null, 0.0000, null);
  25. INSERT INTO sales_invoice (store_id, base_grand_total, shipping_tax_amount, tax_amount, base_tax_amount, store_to_order_rate, base_shipping_tax_amount, base_discount_amount, base_to_order_rate, grand_total, shipping_amount, subtotal_incl_tax, base_subtotal_incl_tax, store_to_base_rate, base_shipping_amount, total_qty, base_to_global_rate, subtotal, base_subtotal, discount_amount, billing_address_id, is_used_for_refund, order_id, email_sent, send_email, can_void_flag, state, shipping_address_id, store_currency_code, transaction_id, order_currency_code, base_currency_code, global_currency_code, increment_id, created_at, updated_at, 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, base_total_refunded, discount_description, customer_note, customer_note_notify, affiliateplus_discount, base_affiliateplus_discount, affiliate_credit, base_affiliate_credit, onestepcheckout_giftwrap_amount, onestepcheckout_base_giftwrap_amount) VALUES (1, 35.5900, 0.0000, 7.5900, 7.5900, 1.0000, 0.0000, -5.0000, 1.0000, 35.5900, 0.0000, 40.5900, 40.5900, 1.0000, 0.0000, 4.0000, 1.0000, 33.0000, 33.0000, -5.0000, 158180, null, 79090, null, null, 0, 2, 158179, 'EUR', null, 'EUR', 'EUR', 'EUR', '1000057014', '2017-07-18 20:15:06', '2017-07-18 20:15:06', 0.0000, 0.0000, 0.0000, null, 0.0000, 0.0000, null, null, null, null, null, null, null, null, 0.0000, null);
  26. INSERT INTO sales_invoice (store_id, base_grand_total, shipping_tax_amount, tax_amount, base_tax_amount, store_to_order_rate, base_shipping_tax_amount, base_discount_amount, base_to_order_rate, grand_total, shipping_amount, subtotal_incl_tax, base_subtotal_incl_tax, store_to_base_rate, base_shipping_amount, total_qty, base_to_global_rate, subtotal, base_subtotal, discount_amount, billing_address_id, is_used_for_refund, order_id, email_sent, send_email, can_void_flag, state, shipping_address_id, store_currency_code, transaction_id, order_currency_code, base_currency_code, global_currency_code, increment_id, created_at, updated_at, 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, base_total_refunded, discount_description, customer_note, customer_note_notify, affiliateplus_discount, base_affiliateplus_discount, affiliate_credit, base_affiliate_credit, onestepcheckout_giftwrap_amount, onestepcheckout_base_giftwrap_amount) VALUES (1, 81.7700, 0.0000, 15.2900, 15.2900, 1.0000, 0.0000, 0.0000, 1.0000, 81.7700, 0.0000, 81.7700, 81.7700, 1.0000, 0.0000, 3.0000, 1.0000, 66.4800, 66.4800, 0.0000, 158186, null, 79093, null, null, 0, 2, 158185, 'EUR', null, 'EUR', 'EUR', 'EUR', '1000057013', '2017-07-18 20:04:48', '2017-07-18 20:04:48', 0.0000, 0.0000, 0.0000, null, 0.0000, 0.0000, null, null, null, null, null, null, null, null, 0.0000, null);
  27.  
  28.  
  29. ## SALES_ORDER
  30.  
  31. INSERT INTO sales_order (state, status, coupon_code, protect_code, shipping_description, is_virtual, store_id, customer_id, base_discount_amount, base_discount_canceled, base_discount_invoiced, base_discount_refunded, base_grand_total, base_shipping_amount, base_shipping_canceled, base_shipping_invoiced, base_shipping_refunded, base_shipping_tax_amount, base_shipping_tax_refunded, base_subtotal, base_subtotal_canceled, base_subtotal_invoiced, base_subtotal_refunded, base_tax_amount, base_tax_canceled, base_tax_invoiced, base_tax_refunded, base_to_global_rate, base_to_order_rate, base_total_canceled, base_total_invoiced, base_total_invoiced_cost, base_total_offline_refunded, base_total_online_refunded, base_total_paid, base_total_qty_ordered, base_total_refunded, discount_amount, discount_canceled, discount_invoiced, discount_refunded, grand_total, shipping_amount, shipping_canceled, shipping_invoiced, shipping_refunded, shipping_tax_amount, shipping_tax_refunded, store_to_base_rate, store_to_order_rate, subtotal, subtotal_canceled, subtotal_invoiced, subtotal_refunded, tax_amount, tax_canceled, tax_invoiced, tax_refunded, total_canceled, total_invoiced, total_offline_refunded, total_online_refunded, total_paid, total_qty_ordered, total_refunded, can_ship_partially, can_ship_partially_item, customer_is_guest, customer_note_notify, billing_address_id, customer_group_id, edit_increment, email_sent, send_email, forced_shipment_with_invoice, payment_auth_expiration, quote_address_id, quote_id, shipping_address_id, adjustment_negative, adjustment_positive, base_adjustment_negative, base_adjustment_positive, base_shipping_discount_amount, base_subtotal_incl_tax, base_total_due, payment_authorization_amount, shipping_discount_amount, subtotal_incl_tax, total_due, weight, customer_dob, increment_id, applied_rule_ids, base_currency_code, customer_email, customer_firstname, customer_lastname, customer_middlename, customer_prefix, customer_suffix, customer_taxvat, discount_description, ext_customer_id, ext_order_id, global_currency_code, hold_before_state, hold_before_status, order_currency_code, original_increment_id, relation_child_id, relation_child_real_id, relation_parent_id, relation_parent_real_id, remote_ip, shipping_method, store_currency_code, store_name, x_forwarded_for, customer_note, created_at, updated_at, total_item_count, customer_gender, discount_tax_compensation_amount, base_discount_tax_compensation_amount, shipping_discount_tax_compensation_amount, base_shipping_discount_tax_compensation_amnt, discount_tax_compensation_invoiced, base_discount_tax_compensation_invoiced, discount_tax_compensation_refunded, base_discount_tax_compensation_refunded, shipping_incl_tax, base_shipping_incl_tax, coupon_rule_name, ebizmarts_abandonedcart_flag, affiliateplus_discount, base_affiliateplus_discount, base_affiliate_credit, affiliate_credit, account_ids, onestepcheckout_order_comment, onestepcheckout_giftwrap_amount, onestepcheckout_base_giftwrap_amount, gift_message_id, paypal_ipn_customer_notified) VALUES ('new', 'pending', 'First17asdS', '50dd57', 'Envio Via CTT – Entrega em 7 a 20 dias úteis', 0, 2, 30935, -5.0000, null, null, null, 55.2400, 16.0000, null, null, null, 0.0000, null, 44.2400, null, null, null, 0.0000, null, null, null, 1.0000, 3.8486, null, null, null, null, null, null, null, null, -19.2200, null, null, null, 212.6200, 61.5800, null, null, null, 0.0000, null, 0.0000, 0.0000, 170.2600, null, null, null, 0.0000, null, null, null, null, null, null, null, null, 4.0000, null, null, null, 0, 1, 158192, 1, null, null, null, null, null, null, 355640, 158191, null, null, null, null, 0.0000, 44.2400, 55.2400, null, 0.0000, 170.2600, 212.6200, 0.8400, null, '7000080197', '196', 'EUR', 'sheron.scj@gmail.com', 'sheron ', 'marto orofino', null, null, null, null, 'Voucher Primeira Compra: Oferta 5€', null, null, 'EUR', null, null, 'BRL', null, null, null, null, null, '186.251.16.4', 'matrixrate_matrixrate_1485', 'EUR', 'Skin BR
  32. Skin Brasil
  33. Brasil', null, null, '2017-07-18 21:12:19', '2017-07-18 21:12:19', 2, null, 0.0000, 0.0000, 0.0000, null, null, null, null, null, 61.5800, 16.0000, 'Voucher Primeira Compra: Oferta 5€', 0, null, null, null, null, null, null, null, null, null, 0);
  34. INSERT INTO sales_order (state, status, coupon_code, protect_code, shipping_description, is_virtual, store_id, customer_id, base_discount_amount, base_discount_canceled, base_discount_invoiced, base_discount_refunded, base_grand_total, base_shipping_amount, base_shipping_canceled, base_shipping_invoiced, base_shipping_refunded, base_shipping_tax_amount, base_shipping_tax_refunded, base_subtotal, base_subtotal_canceled, base_subtotal_invoiced, base_subtotal_refunded, base_tax_amount, base_tax_canceled, base_tax_invoiced, base_tax_refunded, base_to_global_rate, base_to_order_rate, base_total_canceled, base_total_invoiced, base_total_invoiced_cost, base_total_offline_refunded, base_total_online_refunded, base_total_paid, base_total_qty_ordered, base_total_refunded, discount_amount, discount_canceled, discount_invoiced, discount_refunded, grand_total, shipping_amount, shipping_canceled, shipping_invoiced, shipping_refunded, shipping_tax_amount, shipping_tax_refunded, store_to_base_rate, store_to_order_rate, subtotal, subtotal_canceled, subtotal_invoiced, subtotal_refunded, tax_amount, tax_canceled, tax_invoiced, tax_refunded, total_canceled, total_invoiced, total_offline_refunded, total_online_refunded, total_paid, total_qty_ordered, total_refunded, can_ship_partially, can_ship_partially_item, customer_is_guest, customer_note_notify, billing_address_id, customer_group_id, edit_increment, email_sent, send_email, forced_shipment_with_invoice, payment_auth_expiration, quote_address_id, quote_id, shipping_address_id, adjustment_negative, adjustment_positive, base_adjustment_negative, base_adjustment_positive, base_shipping_discount_amount, base_subtotal_incl_tax, base_total_due, payment_authorization_amount, shipping_discount_amount, subtotal_incl_tax, total_due, weight, customer_dob, increment_id, applied_rule_ids, base_currency_code, customer_email, customer_firstname, customer_lastname, customer_middlename, customer_prefix, customer_suffix, customer_taxvat, discount_description, ext_customer_id, ext_order_id, global_currency_code, hold_before_state, hold_before_status, order_currency_code, original_increment_id, relation_child_id, relation_child_real_id, relation_parent_id, relation_parent_real_id, remote_ip, shipping_method, store_currency_code, store_name, x_forwarded_for, customer_note, created_at, updated_at, total_item_count, customer_gender, discount_tax_compensation_amount, base_discount_tax_compensation_amount, shipping_discount_tax_compensation_amount, base_shipping_discount_tax_compensation_amnt, discount_tax_compensation_invoiced, base_discount_tax_compensation_invoiced, discount_tax_compensation_refunded, base_discount_tax_compensation_refunded, shipping_incl_tax, base_shipping_incl_tax, coupon_rule_name, ebizmarts_abandonedcart_flag, affiliateplus_discount, base_affiliateplus_discount, base_affiliate_credit, affiliate_credit, account_ids, onestepcheckout_order_comment, onestepcheckout_giftwrap_amount, onestepcheckout_base_giftwrap_amount, gift_message_id, paypal_ipn_customer_notified) VALUES ('processing', 'processing', null, '796a4b', 'Portes Gratuitos', 0, 1, 3755, 0.0000, null, 0.0000, null, 76.9500, 0.0000, null, 0.0000, null, 0.0000, null, 62.5600, null, 62.5600, null, 14.3900, null, 14.3900, null, 1.0000, 1.0000, null, 76.9500, 45.8400, null, null, 76.9500, null, null, 0.0000, null, 0.0000, null, 76.9500, 0.0000, null, 0.0000, null, 0.0000, null, 1.0000, 1.0000, 62.5600, null, 62.5600, null, 14.3900, null, 14.3900, null, null, 76.9500, null, null, 76.9500, 3.0000, null, null, null, 0, 1, 158190, 1, null, 1, 1, null, null, null, 293502, 158189, null, null, null, null, 0.0000, 76.9500, 0.0000, null, 0.0000, 76.9500, 0.0000, 0.8500, null, '1000080314', null, 'EUR', 'vero.iness@gmail.com', 'Verónica', 'Domingues', null, null, null, null, null, null, null, 'EUR', null, null, 'EUR', null, null, null, null, null, '89.114.176.55', 'freeshipping_freeshipping', 'EUR', 'Skin PT
  35. Skin
  36. Portugal', null, null, '2017-07-18 20:54:42', '2017-07-18 20:54:44', 3, null, 0.0000, 0.0000, 0.0000, null, 0.0000, 0.0000, null, null, 0.0000, 0.0000, null, 0, null, null, null, null, null, null, null, null, null, 0);
  37. INSERT INTO sales_order (state, status, coupon_code, protect_code, shipping_description, is_virtual, store_id, customer_id, base_discount_amount, base_discount_canceled, base_discount_invoiced, base_discount_refunded, base_grand_total, base_shipping_amount, base_shipping_canceled, base_shipping_invoiced, base_shipping_refunded, base_shipping_tax_amount, base_shipping_tax_refunded, base_subtotal, base_subtotal_canceled, base_subtotal_invoiced, base_subtotal_refunded, base_tax_amount, base_tax_canceled, base_tax_invoiced, base_tax_refunded, base_to_global_rate, base_to_order_rate, base_total_canceled, base_total_invoiced, base_total_invoiced_cost, base_total_offline_refunded, base_total_online_refunded, base_total_paid, base_total_qty_ordered, base_total_refunded, discount_amount, discount_canceled, discount_invoiced, discount_refunded, grand_total, shipping_amount, shipping_canceled, shipping_invoiced, shipping_refunded, shipping_tax_amount, shipping_tax_refunded, store_to_base_rate, store_to_order_rate, subtotal, subtotal_canceled, subtotal_invoiced, subtotal_refunded, tax_amount, tax_canceled, tax_invoiced, tax_refunded, total_canceled, total_invoiced, total_offline_refunded, total_online_refunded, total_paid, total_qty_ordered, total_refunded, can_ship_partially, can_ship_partially_item, customer_is_guest, customer_note_notify, billing_address_id, customer_group_id, edit_increment, email_sent, send_email, forced_shipment_with_invoice, payment_auth_expiration, quote_address_id, quote_id, shipping_address_id, adjustment_negative, adjustment_positive, base_adjustment_negative, base_adjustment_positive, base_shipping_discount_amount, base_subtotal_incl_tax, base_total_due, payment_authorization_amount, shipping_discount_amount, subtotal_incl_tax, total_due, weight, customer_dob, increment_id, applied_rule_ids, base_currency_code, customer_email, customer_firstname, customer_lastname, customer_middlename, customer_prefix, customer_suffix, customer_taxvat, discount_description, ext_customer_id, ext_order_id, global_currency_code, hold_before_state, hold_before_status, order_currency_code, original_increment_id, relation_child_id, relation_child_real_id, relation_parent_id, relation_parent_real_id, remote_ip, shipping_method, store_currency_code, store_name, x_forwarded_for, customer_note, created_at, updated_at, total_item_count, customer_gender, discount_tax_compensation_amount, base_discount_tax_compensation_amount, shipping_discount_tax_compensation_amount, base_shipping_discount_tax_compensation_amnt, discount_tax_compensation_invoiced, base_discount_tax_compensation_invoiced, discount_tax_compensation_refunded, base_discount_tax_compensation_refunded, shipping_incl_tax, base_shipping_incl_tax, coupon_rule_name, ebizmarts_abandonedcart_flag, affiliateplus_discount, base_affiliateplus_discount, base_affiliate_credit, affiliate_credit, account_ids, onestepcheckout_order_comment, onestepcheckout_giftwrap_amount, onestepcheckout_base_giftwrap_amount, gift_message_id, paypal_ipn_customer_notified) VALUES ('new', 'pending', null, '1f26eb', 'Envio Via CTT – Entrega em 7 a 20 dias úteis', 0, 2, 30935, 0.0000, null, null, null, 60.2400, 16.0000, null, null, null, 0.0000, null, 44.2400, null, null, null, 0.0000, null, null, null, 1.0000, 3.8486, null, null, null, null, null, null, null, null, 0.0000, null, null, null, 231.8400, 61.5800, null, null, null, 0.0000, null, 0.0000, 0.0000, 170.2600, null, null, null, 0.0000, null, null, null, null, null, null, null, null, 4.0000, null, null, null, 0, 1, 158188, 1, null, null, null, null, null, null, 354670, 158187, null, null, null, null, 0.0000, 44.2400, 60.2400, null, 0.0000, 170.2600, 231.8400, 0.8400, null, '7000080196', null, 'EUR', 'sheron.scj@gmail.com', 'sheron ', 'marto orofino', null, null, null, null, null, null, null, 'EUR', null, null, 'BRL', null, null, null, null, null, '186.251.16.4', 'matrixrate_matrixrate_1485', 'EUR', 'Skin BR
  38. Skin Brasil
  39. Brasil', null, null, '2017-07-18 19:12:27', '2017-07-18 19:12:27', 2, null, 0.0000, 0.0000, 0.0000, null, null, null, null, null, 61.5800, 16.0000, null, 0, null, null, null, null, null, null, null, null, null, 0);
  40. INSERT INTO sales_order (state, status, coupon_code, protect_code, shipping_description, is_virtual, store_id, customer_id, base_discount_amount, base_discount_canceled, base_discount_invoiced, base_discount_refunded, base_grand_total, base_shipping_amount, base_shipping_canceled, base_shipping_invoiced, base_shipping_refunded, base_shipping_tax_amount, base_shipping_tax_refunded, base_subtotal, base_subtotal_canceled, base_subtotal_invoiced, base_subtotal_refunded, base_tax_amount, base_tax_canceled, base_tax_invoiced, base_tax_refunded, base_to_global_rate, base_to_order_rate, base_total_canceled, base_total_invoiced, base_total_invoiced_cost, base_total_offline_refunded, base_total_online_refunded, base_total_paid, base_total_qty_ordered, base_total_refunded, discount_amount, discount_canceled, discount_invoiced, discount_refunded, grand_total, shipping_amount, shipping_canceled, shipping_invoiced, shipping_refunded, shipping_tax_amount, shipping_tax_refunded, store_to_base_rate, store_to_order_rate, subtotal, subtotal_canceled, subtotal_invoiced, subtotal_refunded, tax_amount, tax_canceled, tax_invoiced, tax_refunded, total_canceled, total_invoiced, total_offline_refunded, total_online_refunded, total_paid, total_qty_ordered, total_refunded, can_ship_partially, can_ship_partially_item, customer_is_guest, customer_note_notify, billing_address_id, customer_group_id, edit_increment, email_sent, send_email, forced_shipment_with_invoice, payment_auth_expiration, quote_address_id, quote_id, shipping_address_id, adjustment_negative, adjustment_positive, base_adjustment_negative, base_adjustment_positive, base_shipping_discount_amount, base_subtotal_incl_tax, base_total_due, payment_authorization_amount, shipping_discount_amount, subtotal_incl_tax, total_due, weight, customer_dob, increment_id, applied_rule_ids, base_currency_code, customer_email, customer_firstname, customer_lastname, customer_middlename, customer_prefix, customer_suffix, customer_taxvat, discount_description, ext_customer_id, ext_order_id, global_currency_code, hold_before_state, hold_before_status, order_currency_code, original_increment_id, relation_child_id, relation_child_real_id, relation_parent_id, relation_parent_real_id, remote_ip, shipping_method, store_currency_code, store_name, x_forwarded_for, customer_note, created_at, updated_at, total_item_count, customer_gender, discount_tax_compensation_amount, base_discount_tax_compensation_amount, shipping_discount_tax_compensation_amount, base_shipping_discount_tax_compensation_amnt, discount_tax_compensation_invoiced, base_discount_tax_compensation_invoiced, discount_tax_compensation_refunded, base_discount_tax_compensation_refunded, shipping_incl_tax, base_shipping_incl_tax, coupon_rule_name, ebizmarts_abandonedcart_flag, affiliateplus_discount, base_affiliateplus_discount, base_affiliate_credit, affiliate_credit, account_ids, onestepcheckout_order_comment, onestepcheckout_giftwrap_amount, onestepcheckout_base_giftwrap_amount, gift_message_id, paypal_ipn_customer_notified) VALUES ('processing', 'processing', null, '36dd91', 'Portes Gratuitos', 0, 1, 22661, 0.0000, null, 0.0000, null, 81.7700, 0.0000, null, 0.0000, null, 0.0000, null, 66.4800, null, 66.4800, null, 15.2900, null, 15.2900, null, 1.0000, 1.0000, null, 81.7700, 43.1345, null, null, 81.7700, null, null, 0.0000, null, 0.0000, null, 81.7700, 0.0000, null, 0.0000, null, 0.0000, null, 1.0000, 1.0000, 66.4800, null, 66.4800, null, 15.2900, null, 15.2900, null, null, 81.7700, null, null, 81.7700, 3.0000, null, null, null, 0, 0, 158186, 1, null, 1, 1, null, null, null, 351829, 158185, null, null, null, null, 0.0000, 81.7700, 0.0000, null, 0.0000, 81.7700, 0.0000, 0.1420, null, '1000080312', null, 'EUR', 'ana_rit16@hotmail.com', 'Ana Rita', 'Abreu Sobreiro', null, null, null, null, null, null, null, 'EUR', null, null, 'EUR', null, null, null, null, null, '77.54.49.82', 'freeshipping_freeshipping', 'EUR', 'Skin PT
  41. Skin
  42. Portugal', null, null, '2017-07-18 18:56:10', '2017-07-18 20:04:48', 3, null, 0.0000, 0.0000, 0.0000, null, 0.0000, 0.0000, null, null, 0.0000, 0.0000, null, 0, null, null, null, null, null, null, null, null, null, 0);
  43. INSERT INTO sales_order (state, status, coupon_code, protect_code, shipping_description, is_virtual, store_id, customer_id, base_discount_amount, base_discount_canceled, base_discount_invoiced, base_discount_refunded, base_grand_total, base_shipping_amount, base_shipping_canceled, base_shipping_invoiced, base_shipping_refunded, base_shipping_tax_amount, base_shipping_tax_refunded, base_subtotal, base_subtotal_canceled, base_subtotal_invoiced, base_subtotal_refunded, base_tax_amount, base_tax_canceled, base_tax_invoiced, base_tax_refunded, base_to_global_rate, base_to_order_rate, base_total_canceled, base_total_invoiced, base_total_invoiced_cost, base_total_offline_refunded, base_total_online_refunded, base_total_paid, base_total_qty_ordered, base_total_refunded, discount_amount, discount_canceled, discount_invoiced, discount_refunded, grand_total, shipping_amount, shipping_canceled, shipping_invoiced, shipping_refunded, shipping_tax_amount, shipping_tax_refunded, store_to_base_rate, store_to_order_rate, subtotal, subtotal_canceled, subtotal_invoiced, subtotal_refunded, tax_amount, tax_canceled, tax_invoiced, tax_refunded, total_canceled, total_invoiced, total_offline_refunded, total_online_refunded, total_paid, total_qty_ordered, total_refunded, can_ship_partially, can_ship_partially_item, customer_is_guest, customer_note_notify, billing_address_id, customer_group_id, edit_increment, email_sent, send_email, forced_shipment_with_invoice, payment_auth_expiration, quote_address_id, quote_id, shipping_address_id, adjustment_negative, adjustment_positive, base_adjustment_negative, base_adjustment_positive, base_shipping_discount_amount, base_subtotal_incl_tax, base_total_due, payment_authorization_amount, shipping_discount_amount, subtotal_incl_tax, total_due, weight, customer_dob, increment_id, applied_rule_ids, base_currency_code, customer_email, customer_firstname, customer_lastname, customer_middlename, customer_prefix, customer_suffix, customer_taxvat, discount_description, ext_customer_id, ext_order_id, global_currency_code, hold_before_state, hold_before_status, order_currency_code, original_increment_id, relation_child_id, relation_child_real_id, relation_parent_id, relation_parent_real_id, remote_ip, shipping_method, store_currency_code, store_name, x_forwarded_for, customer_note, created_at, updated_at, total_item_count, customer_gender, discount_tax_compensation_amount, base_discount_tax_compensation_amount, shipping_discount_tax_compensation_amount, base_shipping_discount_tax_compensation_amnt, discount_tax_compensation_invoiced, base_discount_tax_compensation_invoiced, discount_tax_compensation_refunded, base_discount_tax_compensation_refunded, shipping_incl_tax, base_shipping_incl_tax, coupon_rule_name, ebizmarts_abandonedcart_flag, affiliateplus_discount, base_affiliateplus_discount, base_affiliate_credit, affiliate_credit, account_ids, onestepcheckout_order_comment, onestepcheckout_giftwrap_amount, onestepcheckout_base_giftwrap_amount, gift_message_id, paypal_ipn_customer_notified) VALUES ('new', 'pending', 'First17asdS', 'd5f3d3', 'Portes Gratuitos', 0, 1, 10335, -5.0000, null, null, null, 62.0600, 0.0000, null, null, null, 0.0000, null, 54.5200, null, null, null, 12.5400, null, null, null, 1.0000, 1.0000, null, null, null, null, null, null, null, null, -5.0000, null, null, null, 62.0600, 0.0000, null, null, null, 0.0000, null, 1.0000, 1.0000, 54.5200, null, null, null, 12.5400, null, null, null, null, null, null, null, null, 4.0000, null, null, null, 0, 1, 158184, 1, null, 1, 1, null, null, null, 255863, 158183, null, null, null, null, 0.0000, 67.0600, 62.0600, null, 0.0000, 67.0600, 62.0600, 0.7700, null, '1000080310', '196', 'EUR', 'ines.p.carreira@gmail.com', 'Inês', 'Carreira', null, null, null, '205144179', 'Voucher Primeira Compra: Oferta 5€', null, null, 'EUR', null, null, 'EUR', null, null, null, null, null, '87.103.61.61', 'freeshipping_freeshipping', 'EUR', 'Skin PT
  44. Skin
  45. Portugal', null, null, '2017-07-18 17:58:26', '2017-07-18 17:58:29', 4, null, 0.0000, 0.0000, 0.0000, null, null, null, null, null, 0.0000, 0.0000, 'Voucher Primeira Compra: Oferta 5€', 0, null, null, null, null, null, null, null, null, null, 0);
  46. INSERT INTO sales_order (state, status, coupon_code, protect_code, shipping_description, is_virtual, store_id, customer_id, base_discount_amount, base_discount_canceled, base_discount_invoiced, base_discount_refunded, base_grand_total, base_shipping_amount, base_shipping_canceled, base_shipping_invoiced, base_shipping_refunded, base_shipping_tax_amount, base_shipping_tax_refunded, base_subtotal, base_subtotal_canceled, base_subtotal_invoiced, base_subtotal_refunded, base_tax_amount, base_tax_canceled, base_tax_invoiced, base_tax_refunded, base_to_global_rate, base_to_order_rate, base_total_canceled, base_total_invoiced, base_total_invoiced_cost, base_total_offline_refunded, base_total_online_refunded, base_total_paid, base_total_qty_ordered, base_total_refunded, discount_amount, discount_canceled, discount_invoiced, discount_refunded, grand_total, shipping_amount, shipping_canceled, shipping_invoiced, shipping_refunded, shipping_tax_amount, shipping_tax_refunded, store_to_base_rate, store_to_order_rate, subtotal, subtotal_canceled, subtotal_invoiced, subtotal_refunded, tax_amount, tax_canceled, tax_invoiced, tax_refunded, total_canceled, total_invoiced, total_offline_refunded, total_online_refunded, total_paid, total_qty_ordered, total_refunded, can_ship_partially, can_ship_partially_item, customer_is_guest, customer_note_notify, billing_address_id, customer_group_id, edit_increment, email_sent, send_email, forced_shipment_with_invoice, payment_auth_expiration, quote_address_id, quote_id, shipping_address_id, adjustment_negative, adjustment_positive, base_adjustment_negative, base_adjustment_positive, base_shipping_discount_amount, base_subtotal_incl_tax, base_total_due, payment_authorization_amount, shipping_discount_amount, subtotal_incl_tax, total_due, weight, customer_dob, increment_id, applied_rule_ids, base_currency_code, customer_email, customer_firstname, customer_lastname, customer_middlename, customer_prefix, customer_suffix, customer_taxvat, discount_description, ext_customer_id, ext_order_id, global_currency_code, hold_before_state, hold_before_status, order_currency_code, original_increment_id, relation_child_id, relation_child_real_id, relation_parent_id, relation_parent_real_id, remote_ip, shipping_method, store_currency_code, store_name, x_forwarded_for, customer_note, created_at, updated_at, total_item_count, customer_gender, discount_tax_compensation_amount, base_discount_tax_compensation_amount, shipping_discount_tax_compensation_amount, base_shipping_discount_tax_compensation_amnt, discount_tax_compensation_invoiced, base_discount_tax_compensation_invoiced, discount_tax_compensation_refunded, base_discount_tax_compensation_refunded, shipping_incl_tax, base_shipping_incl_tax, coupon_rule_name, ebizmarts_abandonedcart_flag, affiliateplus_discount, base_affiliateplus_discount, base_affiliate_credit, affiliate_credit, account_ids, onestepcheckout_order_comment, onestepcheckout_giftwrap_amount, onestepcheckout_base_giftwrap_amount, gift_message_id, paypal_ipn_customer_notified) VALUES ('new', 'pending', null, '4ab6b1', 'Portes Gratuitos', 0, 1, 31317, 0.0000, null, null, null, 131.6100, 0.0000, null, null, null, 0.0000, null, 131.6100, null, null, null, 0.0000, null, null, null, 1.0000, 1.0000, null, null, null, null, null, null, null, null, 0.0000, null, null, null, 131.6100, 0.0000, null, null, null, 0.0000, null, 0.0000, 0.0000, 131.6100, null, null, null, 0.0000, null, null, null, null, null, null, null, null, 2.0000, null, null, null, 0, 1, 158182, 1, null, 1, 1, null, null, null, 355445, 158181, null, null, null, null, 0.0000, 131.6100, 131.6100, null, 0.0000, 131.6100, 131.6100, 0.2000, null, '1000080309', null, 'EUR', 'franlima2001@yahoo.com.br', 'Fran', 'Lima', null, null, null, null, null, null, null, 'EUR', null, null, 'EUR', null, null, null, null, null, '2804:14d:78d4:4464:648a:b945:bff', 'freeshipping_freeshipping', 'EUR', 'Skin PT
  47. Skin
  48. Portugal', null, null, '2017-07-18 17:43:01', '2017-07-18 17:43:03', 2, null, 0.0000, 0.0000, 0.0000, null, null, null, null, null, 0.0000, 0.0000, null, 0, null, null, null, null, null, null, null, null, null, 0);
  49. INSERT INTO sales_order (state, status, coupon_code, protect_code, shipping_description, is_virtual, store_id, customer_id, base_discount_amount, base_discount_canceled, base_discount_invoiced, base_discount_refunded, base_grand_total, base_shipping_amount, base_shipping_canceled, base_shipping_invoiced, base_shipping_refunded, base_shipping_tax_amount, base_shipping_tax_refunded, base_subtotal, base_subtotal_canceled, base_subtotal_invoiced, base_subtotal_refunded, base_tax_amount, base_tax_canceled, base_tax_invoiced, base_tax_refunded, base_to_global_rate, base_to_order_rate, base_total_canceled, base_total_invoiced, base_total_invoiced_cost, base_total_offline_refunded, base_total_online_refunded, base_total_paid, base_total_qty_ordered, base_total_refunded, discount_amount, discount_canceled, discount_invoiced, discount_refunded, grand_total, shipping_amount, shipping_canceled, shipping_invoiced, shipping_refunded, shipping_tax_amount, shipping_tax_refunded, store_to_base_rate, store_to_order_rate, subtotal, subtotal_canceled, subtotal_invoiced, subtotal_refunded, tax_amount, tax_canceled, tax_invoiced, tax_refunded, total_canceled, total_invoiced, total_offline_refunded, total_online_refunded, total_paid, total_qty_ordered, total_refunded, can_ship_partially, can_ship_partially_item, customer_is_guest, customer_note_notify, billing_address_id, customer_group_id, edit_increment, email_sent, send_email, forced_shipment_with_invoice, payment_auth_expiration, quote_address_id, quote_id, shipping_address_id, adjustment_negative, adjustment_positive, base_adjustment_negative, base_adjustment_positive, base_shipping_discount_amount, base_subtotal_incl_tax, base_total_due, payment_authorization_amount, shipping_discount_amount, subtotal_incl_tax, total_due, weight, customer_dob, increment_id, applied_rule_ids, base_currency_code, customer_email, customer_firstname, customer_lastname, customer_middlename, customer_prefix, customer_suffix, customer_taxvat, discount_description, ext_customer_id, ext_order_id, global_currency_code, hold_before_state, hold_before_status, order_currency_code, original_increment_id, relation_child_id, relation_child_real_id, relation_parent_id, relation_parent_real_id, remote_ip, shipping_method, store_currency_code, store_name, x_forwarded_for, customer_note, created_at, updated_at, total_item_count, customer_gender, discount_tax_compensation_amount, base_discount_tax_compensation_amount, shipping_discount_tax_compensation_amount, base_shipping_discount_tax_compensation_amnt, discount_tax_compensation_invoiced, base_discount_tax_compensation_invoiced, discount_tax_compensation_refunded, base_discount_tax_compensation_refunded, shipping_incl_tax, base_shipping_incl_tax, coupon_rule_name, ebizmarts_abandonedcart_flag, affiliateplus_discount, base_affiliateplus_discount, base_affiliate_credit, affiliate_credit, account_ids, onestepcheckout_order_comment, onestepcheckout_giftwrap_amount, onestepcheckout_base_giftwrap_amount, gift_message_id, paypal_ipn_customer_notified) VALUES ('processing', 'processing', 'First17asdS', 'c17967', 'Portes Gratuitos', 0, 1, 23264, -5.0000, null, -5.0000, null, 35.5900, 0.0000, null, 0.0000, null, 0.0000, null, 33.0000, null, 33.0000, null, 7.5900, null, 7.5900, null, 1.0000, 1.0000, null, 35.5900, 17.9978, null, null, 35.5900, null, null, -5.0000, null, -5.0000, null, 35.5900, 0.0000, null, 0.0000, null, 0.0000, null, 1.0000, 1.0000, 33.0000, null, 33.0000, null, 7.5900, null, 7.5900, null, null, 35.5900, null, null, 35.5900, 4.0000, null, null, null, 0, 0, 158180, 1, null, 1, 1, null, null, null, 348753, 158179, null, null, null, null, 0.0000, 40.5900, 0.0000, null, 0.0000, 40.5900, 0.0000, 0.7740, null, '1000080308', '196', 'EUR', 'natachafmarques@hotmail.com', 'Natacha', 'Marques', null, null, null, '234308877', 'Voucher Primeira Compra: Oferta 5€', null, null, 'EUR', null, null, 'EUR', null, null, null, null, null, '62.28.46.35', 'freeshipping_freeshipping', 'EUR', 'Skin PT
  50. Skin
  51. Portugal', null, null, '2017-07-18 17:19:48', '2017-07-18 20:15:06', 4, null, 0.0000, 0.0000, 0.0000, null, 0.0000, 0.0000, null, null, 0.0000, 0.0000, 'Voucher Primeira Compra: Oferta 5€', 0, null, null, null, null, null, null, null, null, null, 0);
  52. INSERT INTO sales_order (state, status, coupon_code, protect_code, shipping_description, is_virtual, store_id, customer_id, base_discount_amount, base_discount_canceled, base_discount_invoiced, base_discount_refunded, base_grand_total, base_shipping_amount, base_shipping_canceled, base_shipping_invoiced, base_shipping_refunded, base_shipping_tax_amount, base_shipping_tax_refunded, base_subtotal, base_subtotal_canceled, base_subtotal_invoiced, base_subtotal_refunded, base_tax_amount, base_tax_canceled, base_tax_invoiced, base_tax_refunded, base_to_global_rate, base_to_order_rate, base_total_canceled, base_total_invoiced, base_total_invoiced_cost, base_total_offline_refunded, base_total_online_refunded, base_total_paid, base_total_qty_ordered, base_total_refunded, discount_amount, discount_canceled, discount_invoiced, discount_refunded, grand_total, shipping_amount, shipping_canceled, shipping_invoiced, shipping_refunded, shipping_tax_amount, shipping_tax_refunded, store_to_base_rate, store_to_order_rate, subtotal, subtotal_canceled, subtotal_invoiced, subtotal_refunded, tax_amount, tax_canceled, tax_invoiced, tax_refunded, total_canceled, total_invoiced, total_offline_refunded, total_online_refunded, total_paid, total_qty_ordered, total_refunded, can_ship_partially, can_ship_partially_item, customer_is_guest, customer_note_notify, billing_address_id, customer_group_id, edit_increment, email_sent, send_email, forced_shipment_with_invoice, payment_auth_expiration, quote_address_id, quote_id, shipping_address_id, adjustment_negative, adjustment_positive, base_adjustment_negative, base_adjustment_positive, base_shipping_discount_amount, base_subtotal_incl_tax, base_total_due, payment_authorization_amount, shipping_discount_amount, subtotal_incl_tax, total_due, weight, customer_dob, increment_id, applied_rule_ids, base_currency_code, customer_email, customer_firstname, customer_lastname, customer_middlename, customer_prefix, customer_suffix, customer_taxvat, discount_description, ext_customer_id, ext_order_id, global_currency_code, hold_before_state, hold_before_status, order_currency_code, original_increment_id, relation_child_id, relation_child_real_id, relation_parent_id, relation_parent_real_id, remote_ip, shipping_method, store_currency_code, store_name, x_forwarded_for, customer_note, created_at, updated_at, total_item_count, customer_gender, discount_tax_compensation_amount, base_discount_tax_compensation_amount, shipping_discount_tax_compensation_amount, base_shipping_discount_tax_compensation_amnt, discount_tax_compensation_invoiced, base_discount_tax_compensation_invoiced, discount_tax_compensation_refunded, base_discount_tax_compensation_refunded, shipping_incl_tax, base_shipping_incl_tax, coupon_rule_name, ebizmarts_abandonedcart_flag, affiliateplus_discount, base_affiliateplus_discount, base_affiliate_credit, affiliate_credit, account_ids, onestepcheckout_order_comment, onestepcheckout_giftwrap_amount, onestepcheckout_base_giftwrap_amount, gift_message_id, paypal_ipn_customer_notified) VALUES ('new', 'pending', null, 'f667d6', 'CTT registado: Entrega em 1 dia útil após expedição', 0, 1, 24306, 0.0000, null, null, null, 22.5200, 2.8500, null, null, null, 0.6500, null, 15.4600, null, null, null, 4.2100, null, null, null, 1.0000, 1.0000, null, null, null, null, null, null, null, null, 0.0000, null, null, null, 22.5200, 2.8500, null, null, null, 0.6500, null, 1.0000, 1.0000, 15.4600, null, null, null, 4.2100, null, null, null, null, null, null, null, null, 1.0000, null, null, null, 0, 1, 158178, 1, null, 1, 1, null, null, null, 263348, 158177, null, null, null, null, 0.0000, 19.0200, 22.5200, null, 0.0000, 19.0200, 22.5200, 0.4000, null, '1000080307', null, 'EUR', 'patricia.voliveira@hotmail.com', 'Patricia', 'Oliveira', null, null, null, '231087195', null, null, null, 'EUR', null, null, 'EUR', null, null, null, null, null, '2001:8a0:70d9:b01:f87f:ef57:c8ab', 'matrixrate_matrixrate_1748', 'EUR', 'Skin PT
  53. Skin
  54. Portugal', null, null, '2017-07-18 16:53:54', '2017-07-18 16:53:55', 1, null, 0.0000, 0.0000, 0.0000, null, null, null, null, null, 3.5000, 3.5000, null, 0, null, null, null, null, null, null, null, null, null, 0);
  55. INSERT INTO sales_order (state, status, coupon_code, protect_code, shipping_description, is_virtual, store_id, customer_id, base_discount_amount, base_discount_canceled, base_discount_invoiced, base_discount_refunded, base_grand_total, base_shipping_amount, base_shipping_canceled, base_shipping_invoiced, base_shipping_refunded, base_shipping_tax_amount, base_shipping_tax_refunded, base_subtotal, base_subtotal_canceled, base_subtotal_invoiced, base_subtotal_refunded, base_tax_amount, base_tax_canceled, base_tax_invoiced, base_tax_refunded, base_to_global_rate, base_to_order_rate, base_total_canceled, base_total_invoiced, base_total_invoiced_cost, base_total_offline_refunded, base_total_online_refunded, base_total_paid, base_total_qty_ordered, base_total_refunded, discount_amount, discount_canceled, discount_invoiced, discount_refunded, grand_total, shipping_amount, shipping_canceled, shipping_invoiced, shipping_refunded, shipping_tax_amount, shipping_tax_refunded, store_to_base_rate, store_to_order_rate, subtotal, subtotal_canceled, subtotal_invoiced, subtotal_refunded, tax_amount, tax_canceled, tax_invoiced, tax_refunded, total_canceled, total_invoiced, total_offline_refunded, total_online_refunded, total_paid, total_qty_ordered, total_refunded, can_ship_partially, can_ship_partially_item, customer_is_guest, customer_note_notify, billing_address_id, customer_group_id, edit_increment, email_sent, send_email, forced_shipment_with_invoice, payment_auth_expiration, quote_address_id, quote_id, shipping_address_id, adjustment_negative, adjustment_positive, base_adjustment_negative, base_adjustment_positive, base_shipping_discount_amount, base_subtotal_incl_tax, base_total_due, payment_authorization_amount, shipping_discount_amount, subtotal_incl_tax, total_due, weight, customer_dob, increment_id, applied_rule_ids, base_currency_code, customer_email, customer_firstname, customer_lastname, customer_middlename, customer_prefix, customer_suffix, customer_taxvat, discount_description, ext_customer_id, ext_order_id, global_currency_code, hold_before_state, hold_before_status, order_currency_code, original_increment_id, relation_child_id, relation_child_real_id, relation_parent_id, relation_parent_real_id, remote_ip, shipping_method, store_currency_code, store_name, x_forwarded_for, customer_note, created_at, updated_at, total_item_count, customer_gender, discount_tax_compensation_amount, base_discount_tax_compensation_amount, shipping_discount_tax_compensation_amount, base_shipping_discount_tax_compensation_amnt, discount_tax_compensation_invoiced, base_discount_tax_compensation_invoiced, discount_tax_compensation_refunded, base_discount_tax_compensation_refunded, shipping_incl_tax, base_shipping_incl_tax, coupon_rule_name, ebizmarts_abandonedcart_flag, affiliateplus_discount, base_affiliateplus_discount, base_affiliate_credit, affiliate_credit, account_ids, onestepcheckout_order_comment, onestepcheckout_giftwrap_amount, onestepcheckout_base_giftwrap_amount, gift_message_id, paypal_ipn_customer_notified) VALUES ('new', 'pending', null, 'da96bf', 'Portes Gratuitos', 0, 1, 31317, 0.0000, null, null, null, 134.5700, 0.0000, null, null, null, 0.0000, null, 134.5700, null, null, null, 0.0000, null, null, null, 1.0000, 1.0000, null, null, null, null, null, null, null, null, 0.0000, null, null, null, 134.5700, 0.0000, null, null, null, 0.0000, null, 0.0000, 0.0000, 134.5700, null, null, null, 0.0000, null, null, null, null, null, null, null, null, 2.0000, null, null, null, 0, 1, 158176, 1, null, 1, 1, null, null, null, 355439, 158175, null, null, null, null, 0.0000, 134.5700, 134.5700, null, 0.0000, 134.5700, 134.5700, 0.4000, null, '1000080306', null, 'EUR', 'franlima2001@yahoo.com.br', 'Fran', 'Lima', null, null, null, null, null, null, null, 'EUR', null, null, 'EUR', null, null, null, null, null, '2607:5300:60:755a::2', 'freeshipping_freeshipping', 'EUR', 'Skin PT
  56. Skin
  57. Portugal', null, null, '2017-07-18 13:48:51', '2017-07-18 13:48:54', 2, null, 0.0000, 0.0000, 0.0000, null, null, null, null, null, 0.0000, 0.0000, null, 0, null, null, null, null, null, null, null, null, null, 0);
  58. INSERT INTO sales_order (state, status, coupon_code, protect_code, shipping_description, is_virtual, store_id, customer_id, base_discount_amount, base_discount_canceled, base_discount_invoiced, base_discount_refunded, base_grand_total, base_shipping_amount, base_shipping_canceled, base_shipping_invoiced, base_shipping_refunded, base_shipping_tax_amount, base_shipping_tax_refunded, base_subtotal, base_subtotal_canceled, base_subtotal_invoiced, base_subtotal_refunded, base_tax_amount, base_tax_canceled, base_tax_invoiced, base_tax_refunded, base_to_global_rate, base_to_order_rate, base_total_canceled, base_total_invoiced, base_total_invoiced_cost, base_total_offline_refunded, base_total_online_refunded, base_total_paid, base_total_qty_ordered, base_total_refunded, discount_amount, discount_canceled, discount_invoiced, discount_refunded, grand_total, shipping_amount, shipping_canceled, shipping_invoiced, shipping_refunded, shipping_tax_amount, shipping_tax_refunded, store_to_base_rate, store_to_order_rate, subtotal, subtotal_canceled, subtotal_invoiced, subtotal_refunded, tax_amount, tax_canceled, tax_invoiced, tax_refunded, total_canceled, total_invoiced, total_offline_refunded, total_online_refunded, total_paid, total_qty_ordered, total_refunded, can_ship_partially, can_ship_partially_item, customer_is_guest, customer_note_notify, billing_address_id, customer_group_id, edit_increment, email_sent, send_email, forced_shipment_with_invoice, payment_auth_expiration, quote_address_id, quote_id, shipping_address_id, adjustment_negative, adjustment_positive, base_adjustment_negative, base_adjustment_positive, base_shipping_discount_amount, base_subtotal_incl_tax, base_total_due, payment_authorization_amount, shipping_discount_amount, subtotal_incl_tax, total_due, weight, customer_dob, increment_id, applied_rule_ids, base_currency_code, customer_email, customer_firstname, customer_lastname, customer_middlename, customer_prefix, customer_suffix, customer_taxvat, discount_description, ext_customer_id, ext_order_id, global_currency_code, hold_before_state, hold_before_status, order_currency_code, original_increment_id, relation_child_id, relation_child_real_id, relation_parent_id, relation_parent_real_id, remote_ip, shipping_method, store_currency_code, store_name, x_forwarded_for, customer_note, created_at, updated_at, total_item_count, customer_gender, discount_tax_compensation_amount, base_discount_tax_compensation_amount, shipping_discount_tax_compensation_amount, base_shipping_discount_tax_compensation_amnt, discount_tax_compensation_invoiced, base_discount_tax_compensation_invoiced, discount_tax_compensation_refunded, base_discount_tax_compensation_refunded, shipping_incl_tax, base_shipping_incl_tax, coupon_rule_name, ebizmarts_abandonedcart_flag, affiliateplus_discount, base_affiliateplus_discount, base_affiliate_credit, affiliate_credit, account_ids, onestepcheckout_order_comment, onestepcheckout_giftwrap_amount, onestepcheckout_base_giftwrap_amount, gift_message_id, paypal_ipn_customer_notified) VALUES ('complete', 'complete', null, '77291e', 'Portes Gratuitos', 0, 1, null, 0.0000, null, 0.0000, null, 51.6600, 0.0000, null, 0.0000, null, 0.0000, null, 42.0000, null, 42.0000, null, 9.6600, null, 9.6600, null, 1.0000, 1.0000, null, 51.6600, 34.3700, null, null, 51.6600, null, null, 0.0000, null, 0.0000, null, 51.6600, 0.0000, null, 0.0000, null, 0.0000, null, 0.0000, 0.0000, 42.0000, null, 42.0000, null, 9.6600, null, 9.6600, null, null, 51.6600, null, null, 51.6600, 2.0000, null, null, null, 1, 1, 158174, 0, null, 1, 1, null, null, null, 355402, 158173, null, null, null, null, 0.0000, 51.6600, 0.0000, null, 0.0000, 51.6600, 0.0000, 0.6500, null, '1000080305', null, 'EUR', 'anacpinhos@gmail.com', null, null, null, null, null, null, null, null, null, 'EUR', null, null, 'EUR', null, null, null, null, null, '2607:5300:60:755a::2', 'freeshipping_freeshipping', 'EUR', 'Skin PT
  59. Skin
  60. Portugal', '83.223.232.240, 2607:5300:60:755', null, '2017-07-18 12:11:13', '2017-07-18 16:40:03', 2, null, 0.0000, 0.0000, 0.0000, null, 0.0000, 0.0000, null, null, 0.0000, 0.0000, null, 0, null, null, null, null, null, null, null, null, null, 0);
  61.  
  62. ## SALES_SHIPMENT
  63.  
  64. INSERT INTO sales_shipment (store_id, total_weight, total_qty, email_sent, send_email, order_id, customer_id, shipping_address_id, billing_address_id, shipment_status, increment_id, created_at, updated_at, packages, shipping_label, customer_note, customer_note_notify) VALUES (1, null, 2.0000, null, null, 79046, 18490, 158091, 158092, null, '1000056672', '2017-07-18 16:56:08', '2017-07-18 16:56:08', 'a:0:{}', null, null, null);
  65. INSERT INTO sales_shipment (store_id, total_weight, total_qty, email_sent, send_email, order_id, customer_id, shipping_address_id, billing_address_id, shipment_status, increment_id, created_at, updated_at, packages, shipping_label, customer_note, customer_note_notify) VALUES (1, null, 1.0000, null, null, 79025, 31292, 158049, 158050, null, '1000056671', '2017-07-18 16:56:02', '2017-07-18 16:56:02', 'a:0:{}', null, null, null);
  66. INSERT INTO sales_shipment (store_id, total_weight, total_qty, email_sent, send_email, order_id, customer_id, shipping_address_id, billing_address_id, shipment_status, increment_id, created_at, updated_at, packages, shipping_label, customer_note, customer_note_notify) VALUES (1, null, 2.0000, null, null, 79020, 31285, 158039, 158040, null, '1000056670', '2017-07-18 16:50:45', '2017-07-18 16:50:45', 'a:0:{}', null, null, null);
  67. INSERT INTO sales_shipment (store_id, total_weight, total_qty, email_sent, send_email, order_id, customer_id, shipping_address_id, billing_address_id, shipment_status, increment_id, created_at, updated_at, packages, shipping_label, customer_note, customer_note_notify) VALUES (1, null, 4.0000, null, null, 78839, 20773, 157678, 157677, null, '1000056669', '2017-07-18 16:47:37', '2017-07-18 16:47:37', 'a:0:{}', null, null, null);
  68. INSERT INTO sales_shipment (store_id, total_weight, total_qty, email_sent, send_email, order_id, customer_id, shipping_address_id, billing_address_id, shipment_status, increment_id, created_at, updated_at, packages, shipping_label, customer_note, customer_note_notify) VALUES (1, null, 2.0000, null, null, 79087, null, 158173, 158174, null, '1000056668', '2017-07-18 16:40:03', '2017-07-18 16:40:03', 'a:0:{}', null, null, null);
  69. INSERT INTO sales_shipment (store_id, total_weight, total_qty, email_sent, send_email, order_id, customer_id, shipping_address_id, billing_address_id, shipment_status, increment_id, created_at, updated_at, packages, shipping_label, customer_note, customer_note_notify) VALUES (1, null, 4.0000, null, null, 79056, 14269, 158111, 158112, null, '1000056667', '2017-07-18 16:37:29', '2017-07-18 16:37:29', 'a:0:{}', null, null, null);
  70. INSERT INTO sales_shipment (store_id, total_weight, total_qty, email_sent, send_email, order_id, customer_id, shipping_address_id, billing_address_id, shipment_status, increment_id, created_at, updated_at, packages, shipping_label, customer_note, customer_note_notify) VALUES (1, null, 3.0000, null, null, 79070, 31263, 158139, 158140, null, '1000056666', '2017-07-18 16:37:20', '2017-07-18 16:37:20', 'a:0:{}', null, null, null);
  71. INSERT INTO sales_shipment (store_id, total_weight, total_qty, email_sent, send_email, order_id, customer_id, shipping_address_id, billing_address_id, shipment_status, increment_id, created_at, updated_at, packages, shipping_label, customer_note, customer_note_notify) VALUES (1, null, 1.0000, null, null, 79059, 30773, 158117, 158118, null, '1000056665', '2017-07-18 16:35:08', '2017-07-18 16:35:08', 'a:0:{}', null, null, null);
  72. INSERT INTO sales_shipment (store_id, total_weight, total_qty, email_sent, send_email, order_id, customer_id, shipping_address_id, billing_address_id, shipment_status, increment_id, created_at, updated_at, packages, shipping_label, customer_note, customer_note_notify) VALUES (1, null, 3.0000, null, null, 79034, 31283, 158067, 158068, null, '1000056664', '2017-07-18 16:33:07', '2017-07-18 16:33:07', 'a:0:{}', null, null, null);
  73. INSERT INTO sales_shipment (store_id, total_weight, total_qty, email_sent, send_email, order_id, customer_id, shipping_address_id, billing_address_id, shipment_status, increment_id, created_at, updated_at, packages, shipping_label, customer_note, customer_note_notify) VALUES (1, null, 2.0000, null, null, 79057, 16496, 158113, 158114, null, '1000056663', '2017-07-18 16:32:50', '2017-07-18 16:32:50', 'a:0:{}', null, null, null);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement