11/07/2024 08:36:19 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '32' , '485/24' , '2024-07-10' , '24' , '0' , '129' , '74680480' , 'STRADA STATALE 7/bis 45-47 83030 MANOCALZATI' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1187.68' , '1142.00' , NOW() , NOW() ) 11/07/2024 08:36:19 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '14738' 11/07/2024 08:36:19 am >> DELETE FROM ps_document_detail WHERE id_document = '14738' 11/07/2024 08:36:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14738' , '132' , 'MINISTRANTI IERI, OGGI, DOMANI' , '3000' , '0' , '3' , '0.380667' , '0.36602596153846' , '4' , '0' , '1187.6810' ) 11/07/2024 08:36:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '132' AND id_supplier = '129' 11/07/2024 08:36:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '132' , '129' , '1' ) 11/07/2024 08:36:36 am >> UPDATE ps_document SET id_document_type = '32', document_num = '485/24', document_date = '2024-07-10', document_letter = '24', id_customer = '0', id_supplier = '', id_address = '74680480', address1 = 'STRADA STATALE 7/bis 45-47 83030 MANOCALZATI', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '1187.68', price_tax_excluded = '1142.00', date_upd = NOW() WHERE id_document = '14738' 11/07/2024 08:36:36 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '14738' 11/07/2024 08:36:36 am >> DELETE FROM ps_document_detail WHERE id_document = '14738' 11/07/2024 08:36:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14738' , '132' , 'MINISTRANTI IERI, OGGI, DOMANI' , '3000' , '0' , '3' , '0.3807' , '0.36605769230769' , '4' , '0' , '1187.68' ) 11/07/2024 08:56:29 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 11/07/2024 08:56:29 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22753' , '1' , '' , 'nuovo-prodotto' ) 11/07/2024 08:56:29 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '22753' , '1' , '1' , '2' , NOW() , NOW() ) 11/07/2024 08:56:29 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '22753' , '0' , '1' , '0' , '0' ) 11/07/2024 08:57:29 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788878793095' AND id_product != '22753' AND ean13 != '' 11/07/2024 08:57:29 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788878793095', date_upd = NOW() WHERE id_product = '22753' 11/07/2024 08:57:29 am >> UPDATE ps_product_lang SET name = 'MESSA MEDITAZIONE - SETT/OTT 2024', description = '' WHERE id_product = '22753' 11/07/2024 08:57:29 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '8' WHERE id_product = '22753' 11/07/2024 08:57:29 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '8', id_tax_rules_group = '4', id_category_default = '271', id_argoment_default = '64', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22753' 11/07/2024 08:57:29 am >> DELETE FROM ps_specific_price WHERE id_product = '22753' 11/07/2024 08:57:30 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22753' 11/07/2024 08:57:30 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22754' , '1' , '' , 'nuovo-prodotto' ) 11/07/2024 08:57:30 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22754' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22753' 11/07/2024 08:57:30 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22754' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22753' 11/07/2024 08:58:00 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788878793101' AND id_product != '22754' AND ean13 != '' 11/07/2024 08:58:00 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788878793101', date_upd = NOW() WHERE id_product = '22754' 11/07/2024 08:58:00 am >> UPDATE ps_product_lang SET name = 'MESSA MEDITAZIONE - NOV/DIC 2024', description = '' WHERE id_product = '22754' 11/07/2024 08:58:00 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '8' WHERE id_product = '22754' 11/07/2024 08:58:00 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '8', id_tax_rules_group = '4', id_category_default = '271', id_argoment_default = '64', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22754' 11/07/2024 08:58:00 am >> DELETE FROM ps_specific_price WHERE id_product = '22754' 11/07/2024 08:58:03 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22754' 11/07/2024 08:58:03 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22755' , '1' , '' , 'nuovo-prodotto' ) 11/07/2024 08:58:03 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22755' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22754' 11/07/2024 08:58:03 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22755' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22754' 11/07/2024 09:00:00 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '251/24' , '2024-06-27' , '24' , '0' , '40' , '2635' , 'VIA CARLO POMA, 2 00151 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '86.40' , '86.40' , NOW() , NOW() ) 11/07/2024 09:00:00 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92593' 11/07/2024 09:00:00 am >> DELETE FROM ps_document_detail WHERE id_document = '92593' 11/07/2024 09:00:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92593' , '22753' , 'MESSA MEDITAZIONE - SETT/OTT 2024' , '9' , '9' , '4' , '8.00' , '8' , '0' , '40' , '43.2000' ) 11/07/2024 09:00:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '22753' AND id_supplier = '40' 11/07/2024 09:00:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22753' , '40' , '1' ) 11/07/2024 09:00:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92593' , '22754' , 'MESSA MEDITAZIONE - NOV/DIC 2024' , '9' , '9' , '4' , '8.00' , '8' , '0' , '40' , '43.2000' ) 11/07/2024 09:00:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '22754' AND id_supplier = '40' 11/07/2024 09:00:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22754' , '40' , '1' ) 11/07/2024 10:31:08 am >> SELECT document_num FROM ps_document WHERE document_num = '2240' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-11') 11/07/2024 10:31:08 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2240' , '2024-07-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.00' , '11.48' , NOW() , NOW() ) 11/07/2024 10:31:08 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92594' 11/07/2024 10:31:08 am >> DELETE FROM ps_document_detail WHERE id_document = '92594' 11/07/2024 10:31:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92594' , '15948' , 'CARTUCCIA VETRO DIAM. 5 - 1456' , '1' , '-1' , '1' , '14' , '11.475409836066' , '22' , '0' , '14.00' ) 11/07/2024 10:32:18 am >> SELECT ean13 FROM ps_product WHERE ean13 = '1000000005530' AND id_product != '15948' AND ean13 != '' 11/07/2024 10:32:18 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '1000000005530', date_upd = NOW() WHERE id_product = '15948' 11/07/2024 10:32:18 am >> UPDATE ps_product_lang SET name = 'CARTUCCIA VETRO DIAM. 5 - 1456', description = '' WHERE id_product = '15948' 11/07/2024 10:32:18 am >> UPDATE ps_product SET wholesale_price = '4.56', on_sale = '0', price = '12.704918032786885' WHERE id_product = '15948' 11/07/2024 10:32:18 am >> UPDATE ps_product_shop SET wholesale_price = '4.56', price = '12.704918032786885', id_tax_rules_group = '1', id_category_default = '147', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '15948' 11/07/2024 10:32:18 am >> DELETE FROM ps_specific_price WHERE id_product = '15948' 11/07/2024 10:52:07 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002290' AND id_product != '22755' AND ean13 != '' 11/07/2024 10:52:08 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002290', date_upd = NOW() WHERE id_product = '22755' 11/07/2024 10:52:08 am >> UPDATE ps_product_lang SET name = 'CROCIFISSO SAGOMATO 45X26 - 1045163', description = '' WHERE id_product = '22755' 11/07/2024 10:52:08 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '102.45901639344262' WHERE id_product = '22755' 11/07/2024 10:52:08 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '102.45901639344262', id_tax_rules_group = '1', id_category_default = '192', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22755' 11/07/2024 10:52:08 am >> DELETE FROM ps_specific_price WHERE id_product = '22755' 11/07/2024 10:52:14 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22755' 11/07/2024 10:52:14 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22756' , '1' , '' , 'nuovo-prodotto' ) 11/07/2024 10:52:14 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22756' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22755' 11/07/2024 10:52:14 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22756' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22755' 11/07/2024 10:53:05 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002291' AND id_product != '22756' AND ean13 != '' 11/07/2024 10:53:05 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002291', date_upd = NOW() WHERE id_product = '22756' 11/07/2024 10:53:05 am >> UPDATE ps_product_lang SET name = 'CROCIFISSO SAGOMATO 30X19 - 1030161', description = '' WHERE id_product = '22756' 11/07/2024 10:53:05 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '64.75409836065575' WHERE id_product = '22756' 11/07/2024 10:53:05 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '64.75409836065575', id_tax_rules_group = '1', id_category_default = '192', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22756' 11/07/2024 10:53:05 am >> DELETE FROM ps_specific_price WHERE id_product = '22756' 11/07/2024 10:53:06 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22756' 11/07/2024 10:53:06 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22757' , '1' , '' , 'nuovo-prodotto' ) 11/07/2024 10:53:06 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22757' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22756' 11/07/2024 10:53:06 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22757' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22756' 11/07/2024 10:57:22 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '291' , '2024-07-09' , '' , '0' , '13' , '2608' , 'VIA ECCE HOMO, 15 37054 NOGARA' , '' , '' , '17' , '1' , '0' , '0' , '0' , '' , '9' , '0' , '466.38' , '382.28' , NOW() , NOW() ) 11/07/2024 10:57:22 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92595' 11/07/2024 10:57:22 am >> DELETE FROM ps_document_detail WHERE id_document = '92595' 11/07/2024 10:57:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92595' , '16865' , 'CROCIFISSO SAGOMATO 28X20 - 102860' , '3' , '3' , '1' , '34' , '27.868852459016' , '22' , '5' , '118.2180' ) 11/07/2024 10:57:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '16865' AND id_supplier = '13' 11/07/2024 10:57:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16865' , '13' , '1' ) 11/07/2024 10:57:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92595' , '22755' , 'CROCIFISSO SAGOMATO 45X26 - 1045163' , '2' , '2' , '1' , '54' , '44.262295081967' , '22' , '5' , '125.1720' ) 11/07/2024 10:57:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '22755' AND id_supplier = '13' 11/07/2024 10:57:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22755' , '13' , '1' ) 11/07/2024 10:57:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92595' , '22756' , 'CROCIFISSO SAGOMATO 30X19 - 1030161' , '4' , '4' , '1' , '34' , '27.868852459016' , '22' , '5' , '157.6240' ) 11/07/2024 10:57:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '22756' AND id_supplier = '13' 11/07/2024 10:57:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22756' , '13' , '1' ) 11/07/2024 10:57:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92595' , '18561' , 'FORMELLA SAGOMATA 26X26 ' , '1' , '1' , '1' , '38.5' , '31.55737704918' , '22' , '5' , '44.6215' ) 11/07/2024 10:57:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '18561' AND id_supplier = '13' 11/07/2024 10:57:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18561' , '13' , '1' ) 11/07/2024 11:09:07 am >> SELECT document_num FROM ps_document WHERE document_num = '2241' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-11') 11/07/2024 11:09:07 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2241' , '2024-07-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '18.00' , '14.75' , NOW() , NOW() ) 11/07/2024 11:09:07 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92596' 11/07/2024 11:09:07 am >> DELETE FROM ps_document_detail WHERE id_document = '92596' 11/07/2024 11:09:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92596' , '1912' , 'CERA DELL\'EREMO - 415/B ' , '3' , '-3' , '1' , '6.00' , '4.9180327868852' , '22' , '0' , '18.00' ) 11/07/2024 11:37:01 am >> SELECT document_num FROM ps_document WHERE document_num = '2242' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-11') 11/07/2024 11:37:02 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2242' , '2024-07-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '30.00' , '24.59' , NOW() , NOW() ) 11/07/2024 11:37:02 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92597' 11/07/2024 11:37:02 am >> DELETE FROM ps_document_detail WHERE id_document = '92597' 11/07/2024 11:37:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92597' , '9702' , 'SCAPOLARE TIPO GRANDE - 1216/ITA ' , '20' , '-20' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '30.00' ) 11/07/2024 12:06:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '2243' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-11') 11/07/2024 12:06:31 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2243' , '2024-07-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '55.00' , '45.08' , NOW() , NOW() ) 11/07/2024 12:06:31 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92598' 11/07/2024 12:06:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '92598' 11/07/2024 12:06:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92598' , '16764' , 'AMPOLLE SU VASSOIO IN VETRO - 1521' , '1' , '-1' , '1' , '55.00' , '45.081967213115' , '22' , '0' , '55.00' ) 11/07/2024 12:13:40 pm >> SELECT document_num FROM ps_document WHERE document_num = '2243' AND id_document != '92598' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-11') 11/07/2024 12:13:40 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2243', document_date = '2024-07-11', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '55.00', price_tax_excluded = '45.08', date_upd = NOW() WHERE id_document = '92598' 11/07/2024 12:13:40 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92598' 11/07/2024 12:13:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '92598' 11/07/2024 12:13:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92598' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '55' , '45.081967213115' , '22' , '0' , '55.00' ) 11/07/2024 12:14:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '2242' AND id_document != '92597' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-11') 11/07/2024 12:14:11 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2242', document_date = '2024-07-11', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '30.00', price_tax_excluded = '24.59', date_upd = NOW() WHERE id_document = '92597' 11/07/2024 12:14:11 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92597' 11/07/2024 12:14:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '92597' 11/07/2024 12:14:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92597' , '9702' , 'SCAPOLARE TIPO GRANDE - 1216/ITA ' , '10' , '-10' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '15.00' ) 11/07/2024 12:14:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92597' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '15' , '12.295081967213' , '22' , '0' , '15.00' ) 11/07/2024 05:53:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '2244' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-11') 11/07/2024 05:53:45 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2244' , '2024-07-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.00' , '2.46' , NOW() , NOW() ) 11/07/2024 05:53:45 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92599' 11/07/2024 05:53:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '92599' 11/07/2024 05:53:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92599' , '6304' , 'MATTHAEUS 25G - CINNAMONO - EVE ' , '2' , '-2' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '3.00' ) 11/07/2024 06:40:08 pm >> SELECT document_num FROM ps_document WHERE document_num = '2245' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-11') 11/07/2024 06:40:08 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2245' , '2024-07-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '60.00' , '49.18' , NOW() , NOW() ) 11/07/2024 06:40:08 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92600' 11/07/2024 06:40:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '92600' 11/07/2024 06:40:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92600' , '17047' , 'SERVIZIO MESSA LINO - BIANCO' , '1' , '-1' , '1' , '60.00' , '49.180327868852' , '22' , '0' , '60.00' ) 11/07/2024 06:41:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '2246' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-11') 11/07/2024 06:41:15 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2246' , '2024-07-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.50' , '9.50' , NOW() , NOW() ) 11/07/2024 06:41:15 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92601' 11/07/2024 06:41:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '92601' 11/07/2024 06:41:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92601' , '22693' , 'SULLA TUA PAROLA - SETT/OTT 2024' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 11/07/2024 06:41:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92601' , '22414' , 'SULLA TUA PAROLA - LUG/AGO 2024' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' )