20/05/2022 09:21:43 am >> SELECT document_num FROM ps_document WHERE document_num = '1596' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-20') 20/05/2022 09:21:44 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' , '1596' , '2022-05-20' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '27.00' , '22.13' , NOW() , NOW() ) 20/05/2022 09:21:44 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 = '57857' 20/05/2022 09:21:44 am >> DELETE FROM ps_document_detail WHERE id_document = '57857' 20/05/2022 09:21:44 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 ( '57857' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '27' , '22.131147540984' , '22' , '0' , '27.00' ) 20/05/2022 09:21:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 20/05/2022 09:21:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 20/05/2022 09:36:04 am >> SELECT document_num FROM ps_document WHERE document_num = '1597' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-20') 20/05/2022 09:36:04 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' , '1597' , '2022-05-20' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.30' , '11.07' , NOW() , NOW() ) 20/05/2022 09:36:04 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 = '57858' 20/05/2022 09:36:04 am >> DELETE FROM ps_document_detail WHERE id_document = '57858' 20/05/2022 09:36:04 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 ( '57858' , '5190' , 'IN ONORE DI SAN GIUSEPPE - 8190' , '5' , '-5' , '4' , '2.00' , '2' , '0' , '0' , '10.00' ) 20/05/2022 09:36:04 am >> DELETE FROM ps_product_supplier WHERE id_product = '5190' AND id_supplier = '' 20/05/2022 09:36:04 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5190' , '' , '1' ) 20/05/2022 09:36:04 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 ( '57858' , '14777' , 'DECINA LEGNO CON LACCIO' , '1' , '-1' , '1' , '1.3' , '1.0655737704918' , '22' , '0' , '1.30' ) 20/05/2022 09:36:04 am >> DELETE FROM ps_product_supplier WHERE id_product = '14777' AND id_supplier = '' 20/05/2022 09:36:04 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14777' , '' , '1' ) 20/05/2022 09:51:28 am >> SELECT document_num FROM ps_document WHERE document_num = '1598' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-20') 20/05/2022 09:51:28 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' , '1598' , '2022-05-20' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.20' , '5.90' , NOW() , NOW() ) 20/05/2022 09:51:28 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 = '57859' 20/05/2022 09:51:28 am >> DELETE FROM ps_document_detail WHERE id_document = '57859' 20/05/2022 09:51:28 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 ( '57859' , '17005' , 'BIGLIETTO AUGURALE medio' , '4' , '-4' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '4.00' ) 20/05/2022 09:51:28 am >> DELETE FROM ps_product_supplier WHERE id_product = '17005' AND id_supplier = '' 20/05/2022 09:51:28 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17005' , '' , '1' ) 20/05/2022 09:51:28 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 ( '57859' , '17004' , 'BIGLIETTO AUGURALE PICCOLO' , '4' , '-4' , '1' , '0.80' , '0.65573770491803' , '22' , '0' , '3.20' ) 20/05/2022 09:51:29 am >> DELETE FROM ps_product_supplier WHERE id_product = '17004' AND id_supplier = '' 20/05/2022 09:51:29 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17004' , '' , '1' ) 20/05/2022 10:13:03 am >> SELECT document_num FROM ps_document WHERE document_num = '1599' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-20') 20/05/2022 10:13:03 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' , '1599' , '2022-05-20' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '40.00' , '38.74' , NOW() , NOW() ) 20/05/2022 10:13:03 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 = '57860' 20/05/2022 10:13:03 am >> DELETE FROM ps_document_detail WHERE id_document = '57860' 20/05/2022 10:13:03 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 ( '57860' , '17414' , 'BIBBIA SCRUTATE LE SCRITTURE - TELATA' , '1' , '-1' , '4' , '34.00' , '34' , '0' , '5' , '32.30' ) 20/05/2022 10:13:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '17414' AND id_supplier = '' 20/05/2022 10:13:04 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17414' , '' , '1' ) 20/05/2022 10:13:04 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 ( '57860' , '17617' , 'IMMAGINI ISONZO X 100' , '2' , '-2' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '7.00' ) 20/05/2022 10:13:04 am >> DELETE FROM ps_product_supplier WHERE id_product = '17617' AND id_supplier = '' 20/05/2022 10:13:04 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17617' , '' , '1' ) 20/05/2022 10:13:04 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 ( '57860' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '0.7' , '0.7' , '0' , '0' , '0.70' ) 20/05/2022 10:13:04 am >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 20/05/2022 10:13:04 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 20/05/2022 10:23:48 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 20/05/2022 10:23:48 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19565' , '1' , '' , 'nuovo-prodotto' ) 20/05/2022 10:23:48 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '19565' , '1' , '1' , '2' , NOW() , NOW() ) 20/05/2022 10:23:48 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '19565' , '0' , '1' , '0' , '0' ) 20/05/2022 10:24:40 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788867571901' AND id_product != '19565' AND ean13 != '' 20/05/2022 10:24:41 am >> UPDATE ps_product SET id_supplier = '', reference = '2/4', ean13 = '9788867571901', date_upd = NOW() WHERE id_product = '19565' 20/05/2022 10:24:41 am >> UPDATE ps_product_lang SET name = 'scopriamo insieme segni e simboli', description = '' WHERE id_product = '19565' 20/05/2022 10:24:41 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '4.9' WHERE id_product = '19565' 20/05/2022 10:24:41 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '4.9', id_tax_rules_group = '4', id_category_default = '51', id_argoment_default = '58', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19565' 20/05/2022 10:24:41 am >> DELETE FROM ps_specific_price WHERE id_product = '19565' 20/05/2022 10:24:47 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 = '19565' 20/05/2022 10:24:47 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19566' , '1' , '' , 'nuovo-prodotto' ) 20/05/2022 10:24:47 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 '19566' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19565' 20/05/2022 10:24:47 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19566' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19565' 20/05/2022 10:26:02 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831554909' AND id_product != '19566' AND ean13 != '' 20/05/2022 10:26:02 am >> UPDATE ps_product SET id_supplier = '', reference = '13/2', ean13 = '9788831554909', date_upd = NOW() WHERE id_product = '19566' 20/05/2022 10:26:02 am >> UPDATE ps_product_lang SET name = 'famiglia amoris laetitia', description = '' WHERE id_product = '19566' 20/05/2022 10:26:02 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '14' WHERE id_product = '19566' 20/05/2022 10:26:02 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '14', id_tax_rules_group = '4', id_category_default = '27', id_argoment_default = '59', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19566' 20/05/2022 10:26:02 am >> DELETE FROM ps_specific_price WHERE id_product = '19566' 20/05/2022 10:26:17 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 ( '33' , '600186' , '2022-05-18' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '16.24' , '16.24' , NOW() , NOW() ) 20/05/2022 10:26:17 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 = '57861' 20/05/2022 10:26:17 am >> DELETE FROM ps_document_detail WHERE id_document = '57861' 20/05/2022 10:26:17 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 ( '57861' , '19565' , 'scopriamo insieme segni e simboli' , '2' , '2' , '4' , '4.90' , '4.9' , '0' , '30' , '6.8600' ) 20/05/2022 10:26:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '19565' AND id_supplier = '7' 20/05/2022 10:26:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19565' , '7' , '1' ) 20/05/2022 10:26:17 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 ( '57861' , '19566' , 'famiglia amoris laetitia' , '1' , '1' , '4' , '14.00' , '14' , '0' , '33' , '9.3800' ) 20/05/2022 10:26:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '19566' AND id_supplier = '7' 20/05/2022 10:26:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19566' , '7' , '1' ) 20/05/2022 10:29:57 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '1308' 20/05/2022 10:29:57 am >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '1308' , '10' , '160' , 'PARR. SANTA LUCIA V.M. ' , 'MANNA ' , 'DON NATALINO' , 'VIA MADONNA DI LORETO ' , '' , '03030' , 'CASTROCIELO' , '' , '' , '' , '' , '81006460604' , NOW() , NOW() ) 20/05/2022 10:29:57 am >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '1308' 20/05/2022 10:31:48 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '1308' 20/05/2022 10:31:48 am >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '1308' , '10' , '160' , 'PARR. SANTA LUCIA V.M. ' , 'MANNA ' , 'DON NATALINO' , 'VIA MADONNA DI LORETO ' , '' , '03030' , 'CASTROCIELO' , 'sig. emanuela longo ; via campo grimaldi I , n. 23 - 03030 castroci\r\nlongo.emanuela@libero.it' , '' , '3498374915' , '' , '81006460604' , NOW() , NOW() ) 20/05/2022 10:31:48 am >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '1308' 20/05/2022 10:35:13 am >> SELECT document_num FROM ps_document WHERE document_num = '1600' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-20') 20/05/2022 10:35:13 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' , '1600' , '2022-05-20' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '159.94' , '142.39' , NOW() , NOW() ) 20/05/2022 10:35:13 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 = '57862' 20/05/2022 10:35:13 am >> DELETE FROM ps_document_detail WHERE id_document = '57862' 20/05/2022 10:35:13 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 ( '57862' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '7' , '-7' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '24.50' ) 20/05/2022 10:35:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 20/05/2022 10:35:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 20/05/2022 10:35:13 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 ( '57862' , '17710' , 'OSTIA MAGNA CM 14 - OM 140' , '1' , '-1' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '4.50' ) 20/05/2022 10:35:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '17710' AND id_supplier = '' 20/05/2022 10:35:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17710' , '' , '1' ) 20/05/2022 10:35:13 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 ( '57862' , '7311' , 'OSTIA SOTTILE 74MM' , '4' , '-4' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '7.60' ) 20/05/2022 10:35:14 am >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 20/05/2022 10:35:14 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 20/05/2022 10:35:14 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 ( '57862' , '19328' , 'AMEN - GIU. 2022' , '2' , '-2' , '4' , '3.90' , '3.9' , '0' , '5' , '7.42' ) 20/05/2022 10:35:14 am >> DELETE FROM ps_product_supplier WHERE id_product = '19328' AND id_supplier = '' 20/05/2022 10:35:14 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19328' , '' , '1' ) 20/05/2022 10:35:14 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 ( '57862' , '19515' , 'AMEN - LUG 2022' , '2' , '-2' , '4' , '3.90' , '3.9' , '0' , '5' , '7.42' ) 20/05/2022 10:35:14 am >> DELETE FROM ps_product_supplier WHERE id_product = '19515' AND id_supplier = '' 20/05/2022 10:35:14 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19515' , '' , '1' ) 20/05/2022 10:35:14 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 ( '57862' , '15387' , 'VESTINA BATTESIMALE ' , '20' , '-20' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '50.00' ) 20/05/2022 10:35:14 am >> DELETE FROM ps_product_supplier WHERE id_product = '15387' AND id_supplier = '' 20/05/2022 10:35:14 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15387' , '' , '1' ) 20/05/2022 10:35:14 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 ( '57862' , '19528' , 'CATECHISTI OGGI IN ITALIA' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '5' , '19.00' ) 20/05/2022 10:35:14 am >> DELETE FROM ps_product_supplier WHERE id_product = '19528' AND id_supplier = '' 20/05/2022 10:35:14 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19528' , '' , '1' ) 20/05/2022 10:35:14 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 ( '57862' , '13506' , 'SANTO ROSARIO' , '50' , '-50' , '1' , '0.30' , '0.24590163934426' , '22' , '5' , '14.50' ) 20/05/2022 10:35:14 am >> DELETE FROM ps_product_supplier WHERE id_product = '13506' AND id_supplier = '' 20/05/2022 10:35:14 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13506' , '' , '1' ) 20/05/2022 10:35:14 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 ( '57862' , '7915' , 'PERGAMENE - 1A COMUNIONE MOD. D' , '50' , '-50' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '25.00' ) 20/05/2022 10:35:14 am >> DELETE FROM ps_product_supplier WHERE id_product = '7915' AND id_supplier = '' 20/05/2022 10:35:14 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7915' , '' , '1' ) 20/05/2022 10:36:28 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '1308' 20/05/2022 10:36:28 am >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '1308' , '10' , '160' , 'PARR. SANTA LUCIA V.M. ' , 'MANNA ' , 'DON NATALINO' , 'VIA MADONNA DI LORETO ' , '' , '03030' , 'CASTROCIELO' , 'sig. emanuela longo ; via campo grimaldi I , n. 23 - 03030 castroci\r\nlongo.emanuela@libero.it' , '' , '3498374915' , '' , '81006460604' , NOW() , NOW() ) 20/05/2022 10:36:28 am >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '1308' 20/05/2022 10:37:14 am >> SELECT document_num FROM ps_document WHERE document_num = '85' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-05-20') 20/05/2022 10:37:14 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 ( '21' , '85' , '2022-05-20' , '' , '1308' , '0' , '4674286' , 'VIA MADONNA DI LORETO 03030 CASTROCIELO' , '' , '' , '5' , '4' , '0' , '0' , '0' , '' , '7' , '0' , '39.00' , '39.00' , NOW() , NOW() ) 20/05/2022 10:37:14 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 = '57863' 20/05/2022 10:37:14 am >> DELETE FROM ps_document_detail WHERE id_document = '57863' 20/05/2022 10:37:14 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 ( '57863' , '11104' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. RAGAZZI' , '25' , '-25' , '4' , '1.60' , '1.6' , '0' , '15' , '34.00' ) 20/05/2022 10:41:31 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 20/05/2022 10:41:31 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19567' , '1' , '' , 'nuovo-prodotto' ) 20/05/2022 10:41:31 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '19567' , '1' , '1' , '2' , NOW() , NOW() ) 20/05/2022 10:41:31 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '19567' , '0' , '1' , '0' , '0' ) 20/05/2022 10:42:11 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8051739455090' AND id_product != '19567' AND ean13 != '' 20/05/2022 10:42:11 am >> UPDATE ps_product SET id_supplier = '', reference = '10/2', ean13 = '8051739455090', date_upd = NOW() WHERE id_product = '19567' 20/05/2022 10:42:11 am >> UPDATE ps_product_lang SET name = 'PAROLA E PREGHIERA - AGO 2022', description = '' WHERE id_product = '19567' 20/05/2022 10:42:11 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '2.9' WHERE id_product = '19567' 20/05/2022 10:42:11 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '2.9', id_tax_rules_group = '4', id_category_default = '30', 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 = '19567' 20/05/2022 10:42:11 am >> DELETE FROM ps_specific_price WHERE id_product = '19567' 20/05/2022 10:42:12 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 = '19567' 20/05/2022 10:42:12 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19568' , '1' , '' , 'nuovo-prodotto' ) 20/05/2022 10:42:12 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 '19568' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19567' 20/05/2022 10:42:12 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19568' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19567' 20/05/2022 10:42:55 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8051739455212' AND id_product != '19568' AND ean13 != '' 20/05/2022 10:42:55 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8051739455212', date_upd = NOW() WHERE id_product = '19568' 20/05/2022 10:42:55 am >> UPDATE ps_product_lang SET name = 'INSIEME NELLA MESSA - AGO 2022', description = '' WHERE id_product = '19568' 20/05/2022 10:42:55 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '1.8' WHERE id_product = '19568' 20/05/2022 10:42:55 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '1.8', id_tax_rules_group = '4', id_category_default = '30', 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 = '19568' 20/05/2022 10:42:55 am >> DELETE FROM ps_specific_price WHERE id_product = '19568' 20/05/2022 10:42:56 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 = '19568' 20/05/2022 10:42:56 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19569' , '1' , '' , 'nuovo-prodotto' ) 20/05/2022 10:42:56 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 '19569' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19568' 20/05/2022 10:42:56 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19569' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19568' 20/05/2022 10:43:13 am >> UPDATE ps_document SET id_document_type = '33', document_num = '600186', document_date = '2022-05-18', document_letter = '', id_customer = '0', id_supplier = '', id_address = '2602', address1 = 'P. ZZA SAN PAOLO, 14 12051 ALBA', 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 = '27.16', price_tax_excluded = '27.16', date_upd = NOW() WHERE id_document = '57861' 20/05/2022 10:43:13 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 = '57861' 20/05/2022 10:43:13 am >> DELETE FROM ps_document_detail WHERE id_document = '57861' 20/05/2022 10:43:13 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 ( '57861' , '19565' , 'scopriamo insieme segni e simboli' , '2' , '2' , '4' , '4.9000' , '4.9' , '0' , '30' , '6.86' ) 20/05/2022 10:43:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '19565' AND id_supplier = '' 20/05/2022 10:43:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19565' , '' , '1' ) 20/05/2022 10:43:13 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 ( '57861' , '19566' , 'famiglia amoris laetitia' , '1' , '1' , '4' , '14.0000' , '14' , '0' , '33' , '9.38' ) 20/05/2022 10:43:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '19566' AND id_supplier = '' 20/05/2022 10:43:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19566' , '' , '1' ) 20/05/2022 10:43:13 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 ( '57861' , '19567' , 'PAROLA E PREGHIERA - AGO 2022' , '5' , '5' , '4' , '2.90' , '2.9' , '0' , '33' , '9.7150' ) 20/05/2022 10:43:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '19567' AND id_supplier = '' 20/05/2022 10:43:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19567' , '' , '1' ) 20/05/2022 10:43:13 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 ( '57861' , '19568' , 'INSIEME NELLA MESSA - AGO 2022' , '1' , '1' , '4' , '1.80' , '1.8' , '0' , '33' , '1.2060' ) 20/05/2022 10:43:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '19568' AND id_supplier = '' 20/05/2022 10:43:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19568' , '' , '1' ) 20/05/2022 10:46:18 am >> SELECT document_num FROM ps_document WHERE document_num = '18/A' AND id_document != '53221' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-03-12') 20/05/2022 10:46:18 am >> UPDATE ps_document SET id_document_type = '24', document_num = '18/A', document_date = '2022-03-12', document_letter = 'A', id_customer = '3812', id_supplier = '', id_address = '4672633', address1 = 'LARGO PLEBISCITO 12 84121 SALERNO ', 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 = '50.00', price_tax_excluded = '44.67', date_upd = NOW() WHERE id_document = '53221' 20/05/2022 10:46:18 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 = '53221' 20/05/2022 10:46:18 am >> DELETE FROM ps_document_detail WHERE id_document = '53221' 20/05/2022 10:46:18 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 ( '53221' , '17161' , 'CARBONCINI NERI - CARNE' , '1' , '-1' , '1' , '11.0000' , '9.016393442623' , '22' , '0' , '11.00' ) 20/05/2022 10:46:18 am >> DELETE FROM ps_product_supplier WHERE id_product = '17161' AND id_supplier = '' 20/05/2022 10:46:18 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17161' , '' , '1' ) 20/05/2022 10:46:18 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 ( '53221' , '19102' , 'CARBONCINI MM 40' , '1' , '-1' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '13.00' ) 20/05/2022 10:46:18 am >> DELETE FROM ps_product_supplier WHERE id_product = '19102' AND id_supplier = '' 20/05/2022 10:46:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19102' , '' , '1' ) 20/05/2022 10:46: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 ( '53221' , '7311' , 'OSTIA SOTTILE 74MM' , '10' , '-10' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '19.00' ) 20/05/2022 10:46:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 20/05/2022 10:46:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 20/05/2022 10:46: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 ( '53221' , '7673' , 'PARTICOLE MM38' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 20/05/2022 10:46:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '7673' AND id_supplier = '' 20/05/2022 10:46:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7673' , '' , '1' ) 20/05/2022 10:48:17 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788880712985' AND id_product != '19569' AND ean13 != '' 20/05/2022 10:48:17 am >> UPDATE ps_product SET id_supplier = '', reference = '13/2', ean13 = '9788880712985', date_upd = NOW() WHERE id_product = '19569' 20/05/2022 10:48:17 am >> UPDATE ps_product_lang SET name = 'FRATELLI TUTTI - O. VIZZOLI', description = '' WHERE id_product = '19569' 20/05/2022 10:48:17 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '10' WHERE id_product = '19569' 20/05/2022 10:48:17 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '10', id_tax_rules_group = '4', id_category_default = '52', id_argoment_default = '59', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19569' 20/05/2022 10:48:17 am >> DELETE FROM ps_specific_price WHERE id_product = '19569' 20/05/2022 10:48:20 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 = '19569' 20/05/2022 10:48:20 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19570' , '1' , '' , 'nuovo-prodotto' ) 20/05/2022 10:48:20 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 '19570' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19569' 20/05/2022 10:48:20 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19570' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19569' 20/05/2022 10:50:18 am >> UPDATE ps_document SET id_document_type = '33', document_num = '600186', document_date = '2022-05-18', document_letter = '', id_customer = '0', id_supplier = '', id_address = '2602', address1 = 'P. ZZA SAN PAOLO, 14 12051 ALBA', 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 = '107.00', price_tax_excluded = '107.00', date_upd = NOW() WHERE id_document = '57861' 20/05/2022 10:50:18 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 = '57861' 20/05/2022 10:50:18 am >> DELETE FROM ps_document_detail WHERE id_document = '57861' 20/05/2022 10:50:18 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 ( '57861' , '19565' , 'scopriamo insieme segni e simboli' , '2' , '2' , '4' , '4.9000' , '4.9' , '0' , '30' , '6.86' ) 20/05/2022 10:50:18 am >> DELETE FROM ps_product_supplier WHERE id_product = '19565' AND id_supplier = '' 20/05/2022 10:50:18 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19565' , '' , '1' ) 20/05/2022 10:50:18 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 ( '57861' , '19566' , 'famiglia amoris laetitia' , '1' , '1' , '4' , '14.0000' , '14' , '0' , '33' , '9.38' ) 20/05/2022 10:50:18 am >> DELETE FROM ps_product_supplier WHERE id_product = '19566' AND id_supplier = '' 20/05/2022 10:50:18 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19566' , '' , '1' ) 20/05/2022 10:50:18 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 ( '57861' , '19567' , 'PAROLA E PREGHIERA - AGO 2022' , '5' , '5' , '4' , '2.9000' , '2.9' , '0' , '33' , '9.72' ) 20/05/2022 10:50:18 am >> DELETE FROM ps_product_supplier WHERE id_product = '19567' AND id_supplier = '' 20/05/2022 10:50:18 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19567' , '' , '1' ) 20/05/2022 10:50:18 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 ( '57861' , '19568' , 'INSIEME NELLA MESSA - AGO 2022' , '1' , '1' , '4' , '1.8000' , '1.8' , '0' , '33' , '1.21' ) 20/05/2022 10:50:18 am >> DELETE FROM ps_product_supplier WHERE id_product = '19568' AND id_supplier = '' 20/05/2022 10:50:18 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19568' , '' , '1' ) 20/05/2022 10:50:18 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 ( '57861' , '19569' , 'FRATELLI TUTTI - O. VIZZOLI' , '1' , '1' , '4' , '10.00' , '10' , '0' , '30' , '7.0000' ) 20/05/2022 10:50:18 am >> DELETE FROM ps_product_supplier WHERE id_product = '19569' AND id_supplier = '' 20/05/2022 10:50:18 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19569' , '' , '1' ) 20/05/2022 10:50:18 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 ( '57861' , '16884' , 'ARTE DI GUARIRE - F. ROSINI' , '1' , '1' , '4' , '16.00' , '16' , '0' , '33' , '10.7200' ) 20/05/2022 10:50:18 am >> DELETE FROM ps_product_supplier WHERE id_product = '16884' AND id_supplier = '' 20/05/2022 10:50:18 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16884' , '' , '1' ) 20/05/2022 10:50:18 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 ( '57861' , '10064' , 'SOLO LAMORE CREA - F. ROSINI' , '1' , '1' , '4' , '12.00' , '12' , '0' , '33' , '8.0400' ) 20/05/2022 10:50:18 am >> DELETE FROM ps_product_supplier WHERE id_product = '10064' AND id_supplier = '' 20/05/2022 10:50:18 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10064' , '' , '1' ) 20/05/2022 10:50:18 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 ( '57861' , '13432' , 'ARTE DI RICOMINCIARE - F. ROSINI' , '1' , '1' , '4' , '16.00' , '16' , '0' , '33' , '10.7200' ) 20/05/2022 10:50:18 am >> DELETE FROM ps_product_supplier WHERE id_product = '13432' AND id_supplier = '' 20/05/2022 10:50:18 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13432' , '' , '1' ) 20/05/2022 10:50:18 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 ( '57861' , '12705' , 'QUELLO CHE SEI PER ME - L. EPICOCO' , '1' , '1' , '4' , '10.00' , '10' , '0' , '33' , '6.7000' ) 20/05/2022 10:50:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '12705' AND id_supplier = '' 20/05/2022 10:50:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12705' , '' , '1' ) 20/05/2022 10:50: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 ( '57861' , '1132' , 'BIBBIA DELLA PRIMA COMUNIONE - RIL' , '3' , '3' , '4' , '12.90' , '12.9' , '0' , '33' , '25.9290' ) 20/05/2022 10:50:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '1132' AND id_supplier = '' 20/05/2022 10:50:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1132' , '' , '1' ) 20/05/2022 10:50: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 ( '57861' , '18261' , 'PIETRA SCARTATA - L. EPICOCO' , '1' , '1' , '4' , '16.00' , '16' , '0' , '33' , '10.7200' ) 20/05/2022 10:50:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '18261' AND id_supplier = '' 20/05/2022 10:50:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18261' , '' , '1' ) 20/05/2022 10:56:38 am >> SELECT document_num FROM ps_document WHERE document_num = '1601' AND id_document != '' AND id_document_type LIKE '14' AND YEAR(document_date) = YEAR('2022-05-20') 20/05/2022 10:56:38 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' , '1601' , '2022-05-20' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.30' , '13.30' , NOW() , NOW() ) 20/05/2022 10:56:38 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 = '57864' 20/05/2022 10:56:38 am >> DELETE FROM ps_document_detail WHERE id_document = '57864' 20/05/2022 10:56:38 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 ( '57864' , '206' , 'ACCORGIMENTI PER CURARE LE MALATTIE DELLANIMA - C. ACQUAVIVA' , '1' , '-1' , '4' , '14.00' , '14' , '0' , '5' , '13.30' ) 20/05/2022 10:56:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '206' AND id_supplier = '' 20/05/2022 10:56:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '206' , '' , '1' ) 20/05/2022 10:58:31 am >> SELECT document_num FROM ps_document WHERE document_num = '18/A' AND id_document != '53221' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-03-12') 20/05/2022 10:58:31 am >> UPDATE ps_document SET id_document_type = '24', document_num = '18/A', document_date = '2022-03-12', document_letter = 'A', id_customer = '3812', id_supplier = '', id_address = '4672633', address1 = 'LARGO PLEBISCITO 12 84121 SALERNO ', 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 = '117.40', price_tax_excluded = '99.92', date_upd = NOW() WHERE id_document = '53221' 20/05/2022 10:58:32 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 = '53221' 20/05/2022 10:58:32 am >> DELETE FROM ps_document_detail WHERE id_document = '53221' 20/05/2022 10:58:32 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 ( '53221' , '17161' , 'CARBONCINI NERI - CARNE' , '2' , '-2' , '1' , '11.0000' , '9.016393442623' , '22' , '0' , '22.00' ) 20/05/2022 10:58:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '17161' AND id_supplier = '' 20/05/2022 10:58:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17161' , '' , '1' ) 20/05/2022 10:58:32 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 ( '53221' , '19102' , 'CARBONCINI MM 40' , '1' , '-1' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '13.00' ) 20/05/2022 10:58:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '19102' AND id_supplier = '' 20/05/2022 10:58:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19102' , '' , '1' ) 20/05/2022 10:58:32 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 ( '53221' , '7311' , 'OSTIA SOTTILE 74MM' , '10' , '-10' , '3' , '1.9000' , '1.8269230769231' , '4' , '0' , '19.00' ) 20/05/2022 10:58:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 20/05/2022 10:58:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 20/05/2022 10:58:32 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 ( '53221' , '7673' , 'PARTICOLE MM38' , '2' , '-2' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '7.00' ) 20/05/2022 10:58:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '7673' AND id_supplier = '' 20/05/2022 10:58:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7673' , '' , '1' ) 20/05/2022 10:58:32 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 ( '53221' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 20/05/2022 10:58:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 20/05/2022 10:58:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 20/05/2022 11:02:35 am >> SELECT document_num FROM ps_document WHERE document_num = '1602' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-20') 20/05/2022 11:02:35 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' , '1602' , '2022-05-20' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '305.54' , '260.53' , NOW() , NOW() ) 20/05/2022 11:02:35 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 = '57865' 20/05/2022 11:02:35 am >> DELETE FROM ps_document_detail WHERE id_document = '57865' 20/05/2022 11:02:35 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 ( '57865' , '18383' , 'TALENTO DI VIVERE TUTTO - E. HILLESUM' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '5' , '2.76' ) 20/05/2022 11:02:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '18383' AND id_supplier = '' 20/05/2022 11:02:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18383' , '' , '1' ) 20/05/2022 11:02:35 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 ( '57865' , '18377' , 'CHI RESTA SALDO? - E. BIANCHI' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '5' , '2.76' ) 20/05/2022 11:02:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '18377' AND id_supplier = '' 20/05/2022 11:02:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18377' , '' , '1' ) 20/05/2022 11:02:35 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 ( '57865' , '18384' , 'SULLE TRACCE DI GESU - C. MARTINI' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '5' , '2.76' ) 20/05/2022 11:02:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '18384' AND id_supplier = '' 20/05/2022 11:02:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18384' , '' , '1' ) 20/05/2022 11:02:35 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 ( '57865' , '19501' , 'PACE INTERIORE - CHIARA AMIRANTE' , '1' , '-1' , '4' , '12.90' , '12.9' , '0' , '5' , '12.26' ) 20/05/2022 11:02:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '19501' AND id_supplier = '' 20/05/2022 11:02:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19501' , '' , '1' ) 20/05/2022 11:02:35 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 ( '57865' , '15529' , 'TUNICA 2 PIEGONI COLLO RISV. - PTA002B00' , '6' , '-6' , '1' , '40' , '32.786885245902' , '22' , '0' , '240.00' ) 20/05/2022 11:02:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '15529' AND id_supplier = '' 20/05/2022 11:02:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15529' , '' , '1' ) 20/05/2022 11:02:35 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 ( '57865' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '10' , '-10' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '35.00' ) 20/05/2022 11:02:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 20/05/2022 11:02:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 20/05/2022 11:02: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 ( '57865' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '10.00' ) 20/05/2022 11:02:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = '' 20/05/2022 11:02:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '' , '1' ) 20/05/2022 11:04:21 am >> SELECT document_num FROM ps_document WHERE document_num = '1603' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-20') 20/05/2022 11:04:21 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' , '1603' , '2022-05-20' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '48.50' , '44.79' , NOW() , NOW() ) 20/05/2022 11:04:21 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 = '57866' 20/05/2022 11:04:21 am >> DELETE FROM ps_document_detail WHERE id_document = '57866' 20/05/2022 11:04:21 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 ( '57866' , '19102' , 'CARBONCINI MM 40' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 20/05/2022 11:04:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '19102' AND id_supplier = '' 20/05/2022 11:04:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19102' , '' , '1' ) 20/05/2022 11:04:21 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 ( '57866' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.00' , '3.8461538461538' , '4' , '0' , '4.00' ) 20/05/2022 11:04:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '16691' AND id_supplier = '' 20/05/2022 11:04:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16691' , '' , '1' ) 20/05/2022 11:04:21 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 ( '57866' , '19089' , 'OSTIA MAGNA 150 -OM150' , '1' , '-1' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '4.50' ) 20/05/2022 11:04:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '19089' AND id_supplier = '' 20/05/2022 11:04:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19089' , '' , '1' ) 20/05/2022 11:04:21 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 ( '57866' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '5' , '-5' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '17.50' ) 20/05/2022 11:04:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 20/05/2022 11:04:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 20/05/2022 11:04:21 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 ( '57866' , '7311' , 'OSTIA SOTTILE 74MM' , '5' , '-5' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '9.50' ) 20/05/2022 11:04:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 20/05/2022 11:04:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 20/05/2022 11:05:21 am >> SELECT document_num FROM ps_document WHERE document_num = '1604' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-20') 20/05/2022 11:05:21 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' , '1604' , '2022-05-20' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '45.00' , '36.89' , NOW() , NOW() ) 20/05/2022 11:05:21 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 = '57867' 20/05/2022 11:05:21 am >> DELETE FROM ps_document_detail WHERE id_document = '57867' 20/05/2022 11:05:21 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 ( '57867' , '7202' , 'ARTICOLI RELIGIOSI' , '3' , '-3' , '1' , '15' , '12.295081967213' , '22' , '0' , '45.00' ) 20/05/2022 11:05:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 20/05/2022 11:05:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 20/05/2022 11:08:22 am >> SELECT document_num FROM ps_document WHERE document_num = '1605' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-20') 20/05/2022 11:08: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 ( '11' , '1605' , '2022-05-20' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.00' , '12.30' , NOW() , NOW() ) 20/05/2022 11:08: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 = '57868' 20/05/2022 11:08:22 am >> DELETE FROM ps_document_detail WHERE id_document = '57868' 20/05/2022 11:08: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 ( '57868' , '11389' , 'VINO ROSSO DOLCE - 103' , '2' , '-2' , '1' , '7.5' , '6.1475409836066' , '22' , '0' , '15.00' ) 20/05/2022 11:08:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '11389' AND id_supplier = '' 20/05/2022 11:08:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11389' , '' , '1' ) 20/05/2022 11:18:46 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892225589' AND id_product != '19570' AND ean13 != '' 20/05/2022 11:18:46 am >> UPDATE ps_product SET id_supplier = '', reference = '5/5', ean13 = '9788892225589', date_upd = NOW() WHERE id_product = '19570' 20/05/2022 11:18:46 am >> UPDATE ps_product_lang SET name = 'MIO PRIMO ALFABETIERE', description = '' WHERE id_product = '19570' 20/05/2022 11:18:46 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '6.5' WHERE id_product = '19570' 20/05/2022 11:18:46 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '6.5', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '25', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19570' 20/05/2022 11:18:46 am >> DELETE FROM ps_specific_price WHERE id_product = '19570' 20/05/2022 11:19:23 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892225589' AND id_product != '19570' AND ean13 != '' 20/05/2022 11:19:23 am >> UPDATE ps_product SET id_supplier = '', reference = '5/5', ean13 = '9788892225589', date_upd = NOW() WHERE id_product = '19570' 20/05/2022 11:19:23 am >> UPDATE ps_product_lang SET name = 'MIO PRIMO ALFABETIERE', description = '' WHERE id_product = '19570' 20/05/2022 11:19:23 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '6.5' WHERE id_product = '19570' 20/05/2022 11:19:23 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '6.5', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '25', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19570' 20/05/2022 11:19:23 am >> DELETE FROM ps_specific_price WHERE id_product = '19570' 20/05/2022 11:19:24 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 = '19570' 20/05/2022 11:19:24 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19571' , '1' , '' , 'nuovo-prodotto' ) 20/05/2022 11:19:24 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 '19571' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19570' 20/05/2022 11:19:24 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19571' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19570' 20/05/2022 11:19:58 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892225596' AND id_product != '19571' AND ean13 != '' 20/05/2022 11:19:58 am >> UPDATE ps_product SET id_supplier = '', reference = '5/5', ean13 = '9788892225596', date_upd = NOW() WHERE id_product = '19571' 20/05/2022 11:19:58 am >> UPDATE ps_product_lang SET name = 'MIEI PRIMI NUMERI', description = '' WHERE id_product = '19571' 20/05/2022 11:19:58 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '6.5' WHERE id_product = '19571' 20/05/2022 11:19:58 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '6.5', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '25', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19571' 20/05/2022 11:19:58 am >> DELETE FROM ps_specific_price WHERE id_product = '19571' 20/05/2022 11:19:59 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 = '19571' 20/05/2022 11:19:59 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19572' , '1' , '' , 'nuovo-prodotto' ) 20/05/2022 11:19:59 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 '19572' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19571' 20/05/2022 11:19:59 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19572' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19571' 20/05/2022 11:20:15 am >> UPDATE ps_document SET id_document_type = '33', document_num = '600186', document_date = '2022-05-18', document_letter = '', id_customer = '0', id_supplier = '', id_address = '2602', address1 = 'P. ZZA SAN PAOLO, 14 12051 ALBA', 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 = '115.71', price_tax_excluded = '115.71', date_upd = NOW() WHERE id_document = '57861' 20/05/2022 11:20:16 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 = '57861' 20/05/2022 11:20:16 am >> DELETE FROM ps_document_detail WHERE id_document = '57861' 20/05/2022 11:20:16 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 ( '57861' , '19565' , 'scopriamo insieme segni e simboli' , '2' , '2' , '4' , '4.9000' , '4.9' , '0' , '30' , '6.86' ) 20/05/2022 11:20:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '19565' AND id_supplier = '' 20/05/2022 11:20:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19565' , '' , '1' ) 20/05/2022 11:20:16 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 ( '57861' , '19566' , 'famiglia amoris laetitia' , '1' , '1' , '4' , '14.0000' , '14' , '0' , '33' , '9.38' ) 20/05/2022 11:20:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '19566' AND id_supplier = '' 20/05/2022 11:20:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19566' , '' , '1' ) 20/05/2022 11:20:16 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 ( '57861' , '19567' , 'PAROLA E PREGHIERA - AGO 2022' , '5' , '5' , '4' , '2.9000' , '2.9' , '0' , '33' , '9.72' ) 20/05/2022 11:20:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '19567' AND id_supplier = '' 20/05/2022 11:20:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19567' , '' , '1' ) 20/05/2022 11:20:16 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 ( '57861' , '19568' , 'INSIEME NELLA MESSA - AGO 2022' , '1' , '1' , '4' , '1.8000' , '1.8' , '0' , '33' , '1.21' ) 20/05/2022 11:20:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '19568' AND id_supplier = '' 20/05/2022 11:20:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19568' , '' , '1' ) 20/05/2022 11:20:16 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 ( '57861' , '19569' , 'FRATELLI TUTTI - O. VIZZOLI' , '1' , '1' , '4' , '10.0000' , '10' , '0' , '30' , '7.00' ) 20/05/2022 11:20:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '19569' AND id_supplier = '' 20/05/2022 11:20:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19569' , '' , '1' ) 20/05/2022 11:20:16 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 ( '57861' , '16884' , 'ARTE DI GUARIRE - F. ROSINI' , '1' , '1' , '4' , '16.0000' , '16' , '0' , '33' , '10.72' ) 20/05/2022 11:20:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '16884' AND id_supplier = '' 20/05/2022 11:20:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16884' , '' , '1' ) 20/05/2022 11:20:16 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 ( '57861' , '10064' , 'SOLO LAMORE CREA - F. ROSINI' , '1' , '1' , '4' , '12.0000' , '12' , '0' , '33' , '8.04' ) 20/05/2022 11:20:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '10064' AND id_supplier = '' 20/05/2022 11:20:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10064' , '' , '1' ) 20/05/2022 11:20:16 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 ( '57861' , '13432' , 'ARTE DI RICOMINCIARE - F. ROSINI' , '1' , '1' , '4' , '16.0000' , '16' , '0' , '33' , '10.72' ) 20/05/2022 11:20:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '13432' AND id_supplier = '' 20/05/2022 11:20:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13432' , '' , '1' ) 20/05/2022 11:20:16 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 ( '57861' , '12705' , 'QUELLO CHE SEI PER ME - L. EPICOCO' , '1' , '1' , '4' , '10.0000' , '10' , '0' , '33' , '6.70' ) 20/05/2022 11:20:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '12705' AND id_supplier = '' 20/05/2022 11:20:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12705' , '' , '1' ) 20/05/2022 11:20:16 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 ( '57861' , '1132' , 'BIBBIA DELLA PRIMA COMUNIONE - RIL' , '3' , '3' , '4' , '12.9000' , '12.9' , '0' , '33' , '25.93' ) 20/05/2022 11:20:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '1132' AND id_supplier = '' 20/05/2022 11:20:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1132' , '' , '1' ) 20/05/2022 11:20:17 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 ( '57861' , '18261' , 'PIETRA SCARTATA - L. EPICOCO' , '1' , '1' , '4' , '16.0000' , '16' , '0' , '33' , '10.72' ) 20/05/2022 11:20:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '18261' AND id_supplier = '' 20/05/2022 11:20:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18261' , '' , '1' ) 20/05/2022 11:20:17 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 ( '57861' , '19570' , 'MIO PRIMO ALFABETIERE' , '1' , '1' , '4' , '6.50' , '6.5' , '0' , '33' , '4.3550' ) 20/05/2022 11:20:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '19570' AND id_supplier = '' 20/05/2022 11:20:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19570' , '' , '1' ) 20/05/2022 11:20:17 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 ( '57861' , '19571' , 'MIEI PRIMI NUMERI' , '1' , '1' , '4' , '6.50' , '6.5' , '0' , '33' , '4.3550' ) 20/05/2022 11:20:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '19571' AND id_supplier = '' 20/05/2022 11:20:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19571' , '' , '1' ) 20/05/2022 11:20:29 am >> SELECT document_num FROM ps_document WHERE document_num = '1606' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-20') 20/05/2022 11:20:29 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' , '1606' , '2022-05-20' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.80' , '8.03' , NOW() , NOW() ) 20/05/2022 11:20:29 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 = '57869' 20/05/2022 11:20:29 am >> DELETE FROM ps_document_detail WHERE id_document = '57869' 20/05/2022 11:20:29 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 ( '57869' , '1914' , 'CERA DELLA LITURGIA' , '2' , '-2' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '9.80' ) 20/05/2022 11:20:29 am >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 20/05/2022 11:20:29 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 20/05/2022 11:24:34 am >> UPDATE ps_document SET id_document_type = '33', document_num = '600186', document_date = '2022-05-18', document_letter = '', id_customer = '0', id_supplier = '', id_address = '2602', address1 = 'P. ZZA SAN PAOLO, 14 12051 ALBA', address2 = '', note = '', price_shipping = '3.18', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '118.90', price_tax_excluded = '118.90', date_upd = NOW() WHERE id_document = '57861' 20/05/2022 11:24:34 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 = '57861' 20/05/2022 11:24:34 am >> DELETE FROM ps_document_detail WHERE id_document = '57861' 20/05/2022 11:24:34 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 ( '57861' , '19565' , 'scopriamo insieme segni e simboli' , '2' , '2' , '4' , '4.9000' , '4.9' , '0' , '30' , '6.86' ) 20/05/2022 11:24:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '19565' AND id_supplier = '' 20/05/2022 11:24:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19565' , '' , '1' ) 20/05/2022 11:24:34 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 ( '57861' , '19566' , 'famiglia amoris laetitia' , '1' , '1' , '4' , '14.0000' , '14' , '0' , '33' , '9.38' ) 20/05/2022 11:24:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '19566' AND id_supplier = '' 20/05/2022 11:24:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19566' , '' , '1' ) 20/05/2022 11:24:34 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 ( '57861' , '19567' , 'PAROLA E PREGHIERA - AGO 2022' , '5' , '5' , '4' , '2.9000' , '2.9' , '0' , '33' , '9.72' ) 20/05/2022 11:24:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '19567' AND id_supplier = '' 20/05/2022 11:24:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19567' , '' , '1' ) 20/05/2022 11:24:34 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 ( '57861' , '19568' , 'INSIEME NELLA MESSA - AGO 2022' , '1' , '1' , '4' , '1.8000' , '1.8' , '0' , '33' , '1.21' ) 20/05/2022 11:24:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '19568' AND id_supplier = '' 20/05/2022 11:24:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19568' , '' , '1' ) 20/05/2022 11:24:34 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 ( '57861' , '19569' , 'FRATELLI TUTTI - O. VIZZOLI' , '1' , '1' , '4' , '10.0000' , '10' , '0' , '30' , '7.00' ) 20/05/2022 11:24:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '19569' AND id_supplier = '' 20/05/2022 11:24:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19569' , '' , '1' ) 20/05/2022 11:24:34 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 ( '57861' , '16884' , 'ARTE DI GUARIRE - F. ROSINI' , '1' , '1' , '4' , '16.0000' , '16' , '0' , '33' , '10.72' ) 20/05/2022 11:24:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '16884' AND id_supplier = '' 20/05/2022 11:24:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16884' , '' , '1' ) 20/05/2022 11:24:34 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 ( '57861' , '10064' , 'SOLO LAMORE CREA - F. ROSINI' , '1' , '1' , '4' , '12.0000' , '12' , '0' , '33' , '8.04' ) 20/05/2022 11:24:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '10064' AND id_supplier = '' 20/05/2022 11:24:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10064' , '' , '1' ) 20/05/2022 11:24:34 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 ( '57861' , '13432' , 'ARTE DI RICOMINCIARE - F. ROSINI' , '1' , '1' , '4' , '16.0000' , '16' , '0' , '33' , '10.72' ) 20/05/2022 11:24:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '13432' AND id_supplier = '' 20/05/2022 11:24:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13432' , '' , '1' ) 20/05/2022 11:24:34 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 ( '57861' , '12705' , 'QUELLO CHE SEI PER ME - L. EPICOCO' , '1' , '1' , '4' , '10.0000' , '10' , '0' , '33' , '6.70' ) 20/05/2022 11:24:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '12705' AND id_supplier = '' 20/05/2022 11:24:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12705' , '' , '1' ) 20/05/2022 11:24:34 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 ( '57861' , '1132' , 'BIBBIA DELLA PRIMA COMUNIONE - RIL' , '3' , '3' , '4' , '12.9000' , '12.9' , '0' , '33' , '25.93' ) 20/05/2022 11:24:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '1132' AND id_supplier = '' 20/05/2022 11:24:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1132' , '' , '1' ) 20/05/2022 11:24:35 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 ( '57861' , '18261' , 'PIETRA SCARTATA - L. EPICOCO' , '1' , '1' , '4' , '16.0000' , '16' , '0' , '33' , '10.72' ) 20/05/2022 11:24:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '18261' AND id_supplier = '' 20/05/2022 11:24:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18261' , '' , '1' ) 20/05/2022 11:24:35 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 ( '57861' , '19570' , 'MIO PRIMO ALFABETIERE' , '1' , '1' , '4' , '6.5000' , '6.5' , '0' , '33' , '4.36' ) 20/05/2022 11:24:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '19570' AND id_supplier = '' 20/05/2022 11:24:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19570' , '' , '1' ) 20/05/2022 11:24:35 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 ( '57861' , '19571' , 'MIEI PRIMI NUMERI' , '1' , '1' , '4' , '6.5000' , '6.5' , '0' , '33' , '4.36' ) 20/05/2022 11:24:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '19571' AND id_supplier = '' 20/05/2022 11:24:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19571' , '' , '1' ) 20/05/2022 11:26:46 am >> SELECT document_num FROM ps_document WHERE document_num = '1585' AND id_document != '57846' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-19') 20/05/2022 11:26:47 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1585', document_date = '2022-05-19', 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 = '102.00', price_tax_excluded = '83.61', date_upd = NOW() WHERE id_document = '57846' 20/05/2022 11:26:47 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 = '57846' 20/05/2022 11:26:47 am >> DELETE FROM ps_document_detail WHERE id_document = '57846' 20/05/2022 11:26:47 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 ( '57846' , '8106' , 'POLO CELESTE - XL' , '1' , '-1' , '1' , '29.0000' , '23.770491803279' , '22' , '0' , '29.00' ) 20/05/2022 11:26:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '8106' AND id_supplier = '' 20/05/2022 11:26:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8106' , '' , '1' ) 20/05/2022 11:26:47 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 ( '57846' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '33.0000' , '27.049180327869' , '22' , '0' , '33.00' ) 20/05/2022 11:26:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 20/05/2022 11:26:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 20/05/2022 11:26:47 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 ( '57846' , '18244' , 'CLERGY GRIGIO NIDO DAPE MM - XXL' , '1' , '-1' , '1' , '40.00' , '32.786885245902' , '22' , '0' , '40.00' ) 20/05/2022 11:26:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '18244' AND id_supplier = '' 20/05/2022 11:26:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18244' , '' , '1' ) 20/05/2022 12:02:07 pm >> SELECT document_num FROM ps_document WHERE document_num = '1607' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-20') 20/05/2022 12:02:07 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' , '1607' , '2022-05-20' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.00' , '7.69' , NOW() , NOW() ) 20/05/2022 12:02:07 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 = '57870' 20/05/2022 12:02:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '57870' 20/05/2022 12:02:07 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 ( '57870' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '2' , '-2' , '3' , '4.00' , '3.8461538461538' , '4' , '0' , '8.00' ) 20/05/2022 12:02:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16691' AND id_supplier = '' 20/05/2022 12:02:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16691' , '' , '1' ) 20/05/2022 12:20:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '1608' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-20') 20/05/2022 12:20: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' , '1608' , '2022-05-20' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.70' , '14.48' , NOW() , NOW() ) 20/05/2022 12:20: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 = '57871' 20/05/2022 12:20:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '57871' 20/05/2022 12:20: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 ( '57871' , '1763' , 'CASTELLO INTERIORE - TERESA D\'AVILA' , '1' , '-1' , '4' , '8.50' , '8.5' , '0' , '0' , '8.50' ) 20/05/2022 12:20:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1763' AND id_supplier = '' 20/05/2022 12:20:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1763' , '' , '1' ) 20/05/2022 12:20: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 ( '57871' , '15846' , 'CARLO ACUTIS - F. OCCHETTA' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '0' , '5.00' ) 20/05/2022 12:20:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15846' AND id_supplier = '' 20/05/2022 12:20:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15846' , '' , '1' ) 20/05/2022 12:20: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 ( '57871' , '15085' , 'BRACCIALE DECINA COLORATA - BC506' , '1' , '-1' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '1.20' ) 20/05/2022 12:20:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15085' AND id_supplier = '' 20/05/2022 12:20:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15085' , '' , '1' ) 20/05/2022 12:26:21 pm >> SELECT document_num FROM ps_document WHERE document_num = '1609' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-20') 20/05/2022 12:26:21 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' , '1609' , '2022-05-20' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '34.20' , '28.03' , NOW() , NOW() ) 20/05/2022 12:26:21 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 = '57872' 20/05/2022 12:26:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '57872' 20/05/2022 12:26:21 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 ( '57872' , '12817' , 'LIBRO DEI MATRIMONI' , '1' , '-1' , '1' , '38.00' , '31.147540983607' , '22' , '10' , '34.20' ) 20/05/2022 12:26:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12817' AND id_supplier = '' 20/05/2022 12:26:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12817' , '' , '1' ) 20/05/2022 12:27:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '1610' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-20') 20/05/2022 12:27:12 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' , '1610' , '2022-05-20' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.50' , '9.13' , NOW() , NOW() ) 20/05/2022 12:27:12 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 = '57873' 20/05/2022 12:27:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '57873' 20/05/2022 12:27:12 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 ( '57873' , '7311' , 'OSTIA SOTTILE 74MM' , '5' , '-5' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '9.50' ) 20/05/2022 12:27:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 20/05/2022 12:27:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 20/05/2022 12:28:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '1611' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-20') 20/05/2022 12:28: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' , '1611' , '2022-05-20' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.30' , '2.70' , NOW() , NOW() ) 20/05/2022 12:28: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 = '57874' 20/05/2022 12:28:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '57874' 20/05/2022 12:28: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 ( '57874' , '13049' , 'LITURGICO ART. 60LT BIANCO SUPER' , '1' , '-1' , '1' , '3.30' , '2.7049180327869' , '22' , '0' , '3.30' ) 20/05/2022 12:28:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13049' AND id_supplier = '' 20/05/2022 12:28:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13049' , '' , '1' ) 20/05/2022 12:58:37 pm >> SELECT document_num FROM ps_document WHERE document_num = '1612' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-20') 20/05/2022 12:58:37 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' , '1612' , '2022-05-20' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '230.00' , '188.52' , NOW() , NOW() ) 20/05/2022 12:58:37 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 = '57875' 20/05/2022 12:58:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '57875' 20/05/2022 12:58:37 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 ( '57875' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '230' , '188.52459016393' , '22' , '0' , '230.00' ) 20/05/2022 12:58:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 20/05/2022 12:58:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 20/05/2022 02:27:33 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788830818286' AND id_product != '19572' AND ean13 != '' 20/05/2022 02:27:33 pm >> UPDATE ps_product SET id_supplier = '', reference = '8/2', ean13 = '9788830818286', date_upd = NOW() WHERE id_product = '19572' 20/05/2022 02:27:33 pm >> UPDATE ps_product_lang SET name = 'LITURGIA FONDAMENTALE - A. GRILLO', description = '' WHERE id_product = '19572' 20/05/2022 02:27:33 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '29.9' WHERE id_product = '19572' 20/05/2022 02:27:33 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '29.9', id_tax_rules_group = '4', id_category_default = '11', id_argoment_default = '89', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19572' 20/05/2022 02:27:33 pm >> DELETE FROM ps_specific_price WHERE id_product = '19572' 20/05/2022 02:27:34 pm >> 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 = '19572' 20/05/2022 02:27:34 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19573' , '1' , '' , 'nuovo-prodotto' ) 20/05/2022 02:27:34 pm >> 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 '19573' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19572' 20/05/2022 02:27:34 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19573' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19572' 20/05/2022 02:28:19 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788830818309' AND id_product != '19573' AND ean13 != '' 20/05/2022 02:28:19 pm >> UPDATE ps_product SET id_supplier = '', reference = '8/2', ean13 = '9788830818309', date_upd = NOW() WHERE id_product = '19573' 20/05/2022 02:28:19 pm >> UPDATE ps_product_lang SET name = 'NEL SEGNO DELLA BELLEZZA - TOMASSINI', description = '' WHERE id_product = '19573' 20/05/2022 02:28:19 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '15.9' WHERE id_product = '19573' 20/05/2022 02:28:19 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '15.9', id_tax_rules_group = '4', id_category_default = '11', id_argoment_default = '89', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19573' 20/05/2022 02:28:19 pm >> DELETE FROM ps_specific_price WHERE id_product = '19573' 20/05/2022 02:28:20 pm >> 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 = '19573' 20/05/2022 02:28:20 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19574' , '1' , '' , 'nuovo-prodotto' ) 20/05/2022 02:28:20 pm >> 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 '19574' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19573' 20/05/2022 02:28:20 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19574' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19573' 20/05/2022 02:29:15 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788830818354' AND id_product != '19574' AND ean13 != '' 20/05/2022 02:29:15 pm >> UPDATE ps_product SET id_supplier = '', reference = '7/3', ean13 = '9788830818354', date_upd = NOW() WHERE id_product = '19574' 20/05/2022 02:29:15 pm >> UPDATE ps_product_lang SET name = 'FINO A FARSI FRATELLO DI TUTTI - SALVARANI', description = '' WHERE id_product = '19574' 20/05/2022 02:29:15 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '14.9' WHERE id_product = '19574' 20/05/2022 02:29:15 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '14.9', id_tax_rules_group = '4', id_category_default = '11', id_argoment_default = '23', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19574' 20/05/2022 02:29:15 pm >> DELETE FROM ps_specific_price WHERE id_product = '19574' 20/05/2022 02:29:16 pm >> 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 = '19574' 20/05/2022 02:29:16 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19575' , '1' , '' , 'nuovo-prodotto' ) 20/05/2022 02:29:16 pm >> 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 '19575' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19574' 20/05/2022 02:29:16 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19575' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19574' 20/05/2022 02:30:07 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788830818378' AND id_product != '19575' AND ean13 != '' 20/05/2022 02:30:07 pm >> UPDATE ps_product SET id_supplier = '', reference = '13/2', ean13 = '9788830818378', date_upd = NOW() WHERE id_product = '19575' 20/05/2022 02:30:07 pm >> UPDATE ps_product_lang SET name = 'DIMENSIONE REGALE ... - SCORRANO', description = '' WHERE id_product = '19575' 20/05/2022 02:30:07 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '29.5' WHERE id_product = '19575' 20/05/2022 02:30:07 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '29.5', id_tax_rules_group = '4', id_category_default = '11', id_argoment_default = '59', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19575' 20/05/2022 02:30:07 pm >> DELETE FROM ps_specific_price WHERE id_product = '19575' 20/05/2022 02:30:09 pm >> 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 = '19575' 20/05/2022 02:30:09 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19576' , '1' , '' , 'nuovo-prodotto' ) 20/05/2022 02:30:09 pm >> 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 '19576' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19575' 20/05/2022 02:30:09 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19576' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19575' 20/05/2022 02:32:28 pm >> INSERT INTO ps_category ( id_parent , `date_add` , `date_upd` , level_depth ) VALUES ( '4' , NOW() , NOW() , '3' ) 20/05/2022 02:32:28 pm >> INSERT INTO ps_category_group ( id_category , id_group ) VALUES ( '498' , '1' ) 20/05/2022 02:32:28 pm >> INSERT INTO ps_category_group ( id_category , id_group ) VALUES ( '498' , '2' ) 20/05/2022 02:32:28 pm >> INSERT INTO ps_category_group ( id_category , id_group ) VALUES ( '498' , '3' ) 20/05/2022 02:32:28 pm >> INSERT INTO ps_category_lang ( id_category , id_lang , name , link_rewrite ) VALUES ( '498' , '1' , 'NOVA MILLENNIUM ROMAE' , LOWER('NOVA-MILLENNIUM-ROMAE') ) 20/05/2022 02:32:28 pm >> INSERT INTO ps_category_shop ( id_category , id_shop , position ) VALUES ( '498' , '1' , '0' ) 20/05/2022 02:32:38 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788887117653' AND id_product != '19576' AND ean13 != '' 20/05/2022 02:32:38 pm >> UPDATE ps_product SET id_supplier = '', reference = '6/5', ean13 = '9788887117653', date_upd = NOW() WHERE id_product = '19576' 20/05/2022 02:32:38 pm >> UPDATE ps_product_lang SET name = 'ABBRACCIATI A MARIA - M.G. DARCO', description = '' WHERE id_product = '19576' 20/05/2022 02:32:38 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '15' WHERE id_product = '19576' 20/05/2022 02:32:38 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '15', id_tax_rules_group = '4', id_category_default = '498', id_argoment_default = '73', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19576' 20/05/2022 02:32:38 pm >> DELETE FROM ps_specific_price WHERE id_product = '19576' 20/05/2022 02:32:40 pm >> 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 = '19576' 20/05/2022 02:32:40 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19577' , '1' , '' , 'nuovo-prodotto' ) 20/05/2022 02:32:40 pm >> 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 '19577' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19576' 20/05/2022 02:32:40 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19577' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19576' 20/05/2022 02:33:39 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788873576914' AND id_product != '19577' AND ean13 != '' 20/05/2022 02:33:39 pm >> UPDATE ps_product SET id_supplier = '', reference = '6/2', ean13 = '9788873576914', date_upd = NOW() WHERE id_product = '19577' 20/05/2022 02:33:39 pm >> UPDATE ps_product_lang SET name = 'AUTOBIOGRAFIA S. IGNAZIO DI LOYOLA', description = '' WHERE id_product = '19577' 20/05/2022 02:33:39 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '24' WHERE id_product = '19577' 20/05/2022 02:33:39 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '24', id_tax_rules_group = '4', id_category_default = '178', id_argoment_default = '333', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19577' 20/05/2022 02:33:39 pm >> DELETE FROM ps_specific_price WHERE id_product = '19577' 20/05/2022 02:33:42 pm >> 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 = '19577' 20/05/2022 02:33:42 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19578' , '1' , '' , 'nuovo-prodotto' ) 20/05/2022 02:33:42 pm >> 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 '19578' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19577' 20/05/2022 02:33:42 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19578' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19577' 20/05/2022 02:34:56 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788898080090' AND id_product != '19578' AND ean13 != '' 20/05/2022 02:34:56 pm >> UPDATE ps_product SET id_supplier = '', reference = '1/5', ean13 = '9788898080090', date_upd = NOW() WHERE id_product = '19578' 20/05/2022 02:34:56 pm >> UPDATE ps_product_lang SET name = 'MATRIMONIO? SOLO PER CHI SA AMARE - GIUSTI', description = '' WHERE id_product = '19578' 20/05/2022 02:34:56 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '10' WHERE id_product = '19578' 20/05/2022 02:34:56 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '10', id_tax_rules_group = '4', id_category_default = '322', id_argoment_default = '243', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19578' 20/05/2022 02:34:56 pm >> DELETE FROM ps_specific_price WHERE id_product = '19578' 20/05/2022 02:34:57 pm >> 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 = '19578' 20/05/2022 02:34:57 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19579' , '1' , '' , 'nuovo-prodotto' ) 20/05/2022 02:34:57 pm >> 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 '19579' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19578' 20/05/2022 02:34:57 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19579' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19578' 20/05/2022 02:35:30 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788898080106' AND id_product != '19579' AND ean13 != '' 20/05/2022 02:35:30 pm >> UPDATE ps_product SET id_supplier = '', reference = '1/5', ean13 = '9788898080106', date_upd = NOW() WHERE id_product = '19579' 20/05/2022 02:35:30 pm >> UPDATE ps_product_lang SET name = 'FAMIGLIA PORTA DELLA FEDE', description = '' WHERE id_product = '19579' 20/05/2022 02:35:30 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '10' WHERE id_product = '19579' 20/05/2022 02:35:30 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '10', id_tax_rules_group = '4', id_category_default = '322', id_argoment_default = '243', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19579' 20/05/2022 02:35:30 pm >> DELETE FROM ps_specific_price WHERE id_product = '19579' 20/05/2022 02:35:31 pm >> 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 = '19579' 20/05/2022 02:35:31 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19580' , '1' , '' , 'nuovo-prodotto' ) 20/05/2022 02:35:31 pm >> 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 '19580' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19579' 20/05/2022 02:35:31 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19580' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19579' 20/05/2022 02:36:09 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 ( '33' , '2022000002976' , '2022-05-19' , '' , '0' , '107' , '4669100' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '6' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '125.73' , '125.73' , NOW() , NOW() ) 20/05/2022 02:36:09 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 = '57876' 20/05/2022 02:36:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '57876' 20/05/2022 02:36:09 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 ( '57876' , '19572' , 'LITURGIA FONDAMENTALE - A. GRILLO' , '1' , '1' , '4' , '29.90' , '29.9' , '0' , '35' , '19.4350' ) 20/05/2022 02:36:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19572' AND id_supplier = '107' 20/05/2022 02:36:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19572' , '107' , '1' ) 20/05/2022 02:36:09 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 ( '57876' , '19573' , 'NEL SEGNO DELLA BELLEZZA - TOMASSINI' , '1' , '1' , '4' , '15.90' , '15.9' , '0' , '35' , '10.3350' ) 20/05/2022 02:36:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19573' AND id_supplier = '107' 20/05/2022 02:36:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19573' , '107' , '1' ) 20/05/2022 02:36:09 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 ( '57876' , '19574' , 'FINO A FARSI FRATELLO DI TUTTI - SALVARANI' , '1' , '1' , '4' , '14.90' , '14.9' , '0' , '35' , '9.6850' ) 20/05/2022 02:36:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19574' AND id_supplier = '107' 20/05/2022 02:36:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19574' , '107' , '1' ) 20/05/2022 02:36:09 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 ( '57876' , '19575' , 'DIMENSIONE REGALE ... - SCORRANO' , '1' , '1' , '4' , '29.50' , '29.5' , '0' , '35' , '19.1750' ) 20/05/2022 02:36:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19575' AND id_supplier = '107' 20/05/2022 02:36:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19575' , '107' , '1' ) 20/05/2022 02:36:09 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 ( '57876' , '19576' , 'ABBRACCIATI A MARIA - M.G. DARCO' , '1' , '1' , '4' , '15.00' , '15' , '0' , '35' , '9.7500' ) 20/05/2022 02:36:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19576' AND id_supplier = '107' 20/05/2022 02:36:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19576' , '107' , '1' ) 20/05/2022 02:36:09 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 ( '57876' , '19577' , 'AUTOBIOGRAFIA S. IGNAZIO DI LOYOLA' , '1' , '1' , '4' , '24.00' , '24' , '0' , '35' , '15.6000' ) 20/05/2022 02:36:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19577' AND id_supplier = '107' 20/05/2022 02:36:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19577' , '107' , '1' ) 20/05/2022 02:36:09 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 ( '57876' , '19578' , 'MATRIMONIO? SOLO PER CHI SA AMARE - GIUSTI' , '1' , '1' , '4' , '10.00' , '10' , '0' , '35' , '6.5000' ) 20/05/2022 02:36:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19578' AND id_supplier = '107' 20/05/2022 02:36:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19578' , '107' , '1' ) 20/05/2022 02:36:09 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 ( '57876' , '19579' , 'FAMIGLIA PORTA DELLA FEDE' , '1' , '1' , '4' , '10.00' , '10' , '0' , '35' , '6.5000' ) 20/05/2022 02:36:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19579' AND id_supplier = '107' 20/05/2022 02:36:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19579' , '107' , '1' ) 20/05/2022 02:36:09 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 ( '57876' , '19139' , 'IMMACOLATA MADRE DI DIO ......' , '1' , '1' , '4' , '35.00' , '35' , '0' , '35' , '22.7500' ) 20/05/2022 02:36:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19139' AND id_supplier = '107' 20/05/2022 02:36:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19139' , '107' , '1' ) 20/05/2022 03:44:28 pm >> SELECT document_num FROM ps_document WHERE document_num = '778' AND id_document != '53285' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-03-16') 20/05/2022 03:44:28 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '778', document_date = '2022-03-16', 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 = '220.00', price_tax_excluded = '180.33', date_upd = NOW() WHERE id_document = '53285' 20/05/2022 03:44:28 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 = '53285' 20/05/2022 03:44:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '53285' 20/05/2022 03:44:28 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 ( '53285' , '15732' , 'CASULA 3 CR. - 207' , '1' , '-1' , '1' , '220' , '180.32786885246' , '22' , '0' , '220.00' ) 20/05/2022 03:44:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15732' AND id_supplier = '' 20/05/2022 03:44:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15732' , '' , '1' ) 20/05/2022 03:45:58 pm >> DELETE FROM ps_document WHERE id_document = '57262' 20/05/2022 03:45:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '57262' 20/05/2022 03:46:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '989' AND id_document != '54582' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-04-05') 20/05/2022 03:46:55 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '989', document_date = '2022-04-05', 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 = '174.00', price_tax_excluded = '142.62', date_upd = NOW() WHERE id_document = '54582' 20/05/2022 03:46:55 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 = '54582' 20/05/2022 03:46:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '54582' 20/05/2022 03:46:55 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 ( '54582' , '1914' , 'CERA DELLA LITURGIA' , '1' , '-1' , '1' , '4.0000' , '3.2786885245902' , '22' , '0' , '4.00' ) 20/05/2022 03:46:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 20/05/2022 03:46:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 20/05/2022 03:46:55 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 ( '54582' , '15732' , 'CASULA 3 CR. - 207' , '1' , '-1' , '1' , '170' , '139.34426229508' , '22' , '0' , '170.00' ) 20/05/2022 03:46:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15732' AND id_supplier = '' 20/05/2022 03:46:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15732' , '' , '1' ) 20/05/2022 04:29:40 pm >> DELETE FROM ps_document WHERE id_document = '57837' 20/05/2022 04:29:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '57837' 20/05/2022 05:09:35 pm >> SELECT document_num FROM ps_document WHERE document_num = '1613' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-20') 20/05/2022 05:09:35 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' , '1613' , '2022-05-20' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '39.60' , '32.46' , NOW() , NOW() ) 20/05/2022 05:09:35 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 = '57877' 20/05/2022 05:09:35 pm >> DELETE FROM ps_document_detail WHERE id_document = '57877' 20/05/2022 05:09:35 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 ( '57877' , '15703' , 'CARTONCINO CRESIMA CON CROCETTA - 2370/K51' , '18' , '-18' , '1' , '2.2' , '1.8032786885246' , '22' , '0' , '39.60' ) 20/05/2022 05:09:35 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15703' AND id_supplier = '' 20/05/2022 05:09:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15703' , '' , '1' ) 20/05/2022 05:20:02 pm >> SELECT document_num FROM ps_document WHERE document_num = '1614' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-20') 20/05/2022 05:20:03 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' , '1614' , '2022-05-20' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '79.60' , '66.44' , NOW() , NOW() ) 20/05/2022 05:20:03 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 = '57878' 20/05/2022 05:20:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '57878' 20/05/2022 05:20:03 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 ( '57878' , '17617' , 'IMMAGINI ISONZO X 100' , '8' , '-8' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '28.00' ) 20/05/2022 05:20:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17617' AND id_supplier = '' 20/05/2022 05:20:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17617' , '' , '1' ) 20/05/2022 05:20:03 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 ( '57878' , '7934' , 'PERGAMENE - CRESIMA MOD. B' , '100' , '-100' , '1' , '0.50' , '0.40983606557377' , '22' , '10' , '45.00' ) 20/05/2022 05:20:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7934' AND id_supplier = '' 20/05/2022 05:20:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7934' , '' , '1' ) 20/05/2022 05:20:03 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 ( '57878' , '11151' , 'LIBRI' , '3' , '-3' , '4' , '2.2' , '2.2' , '0' , '0' , '6.60' ) 20/05/2022 05:20:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 20/05/2022 05:20:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 20/05/2022 05:48:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '1615' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-20') 20/05/2022 05:48:19 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' , '1615' , '2022-05-20' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.50' , '10.25' , NOW() , NOW() ) 20/05/2022 05:48:19 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 = '57879' 20/05/2022 05:48:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '57879' 20/05/2022 05:48:19 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 ( '57879' , '9798' , 'SEGNALIBRO CRESIMA 95-S.G. - 95-30' , '50' , '-50' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '12.50' ) 20/05/2022 05:48:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9798' AND id_supplier = '' 20/05/2022 05:48:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9798' , '' , '1' ) 20/05/2022 05:56:59 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '256000/30' AND id_product != '19409' AND ean13 != '' 20/05/2022 05:56:59 pm >> UPDATE ps_product SET id_supplier = '98', reference = '', ean13 = '256000/30', date_upd = NOW() WHERE id_product = '19409' 20/05/2022 05:56:59 pm >> UPDATE ps_product_lang SET name = 'SAN GIUSEPPE CM 30', description = '' WHERE id_product = '19409' 20/05/2022 05:56:59 pm >> UPDATE ps_product SET wholesale_price = '109.76', on_sale = '0', price = '221.31147540983608' WHERE id_product = '19409' 20/05/2022 05:56:59 pm >> UPDATE ps_product_shop SET wholesale_price = '109.76', price = '221.31147540983608', id_tax_rules_group = '1', id_category_default = '412', 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 = '19409' 20/05/2022 05:56:59 pm >> DELETE FROM ps_specific_price WHERE id_product = '19409' 20/05/2022 05:57:45 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '256000/30' AND id_product != '19409' AND ean13 != '' 20/05/2022 05:57:45 pm >> UPDATE ps_product SET id_supplier = '98', reference = '', ean13 = '256000/30', date_upd = NOW() WHERE id_product = '19409' 20/05/2022 05:57:45 pm >> UPDATE ps_product_lang SET name = 'SAN GIUSEPPE CM 30', description = '' WHERE id_product = '19409' 20/05/2022 05:57:45 pm >> UPDATE ps_product SET wholesale_price = '109.76', on_sale = '0', price = '221.31147540983608' WHERE id_product = '19409' 20/05/2022 05:57:45 pm >> UPDATE ps_product_shop SET wholesale_price = '109.76', price = '221.31147540983608', id_tax_rules_group = '1', id_category_default = '412', 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 = '19409' 20/05/2022 05:57:45 pm >> DELETE FROM ps_specific_price WHERE id_product = '19409' 20/05/2022 05:58:06 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '256000/30' AND id_product != '19409' AND ean13 != '' 20/05/2022 05:58:06 pm >> UPDATE ps_product SET id_supplier = '98', reference = '', ean13 = '256000/30', date_upd = NOW() WHERE id_product = '19409' 20/05/2022 05:58:06 pm >> UPDATE ps_product_lang SET name = 'SAN GIUSEPPE CM 30', description = '' WHERE id_product = '19409' 20/05/2022 05:58:06 pm >> UPDATE ps_product SET wholesale_price = '109.76', on_sale = '0', price = '221.31147540983608' WHERE id_product = '19409' 20/05/2022 05:58:06 pm >> UPDATE ps_product_shop SET wholesale_price = '109.76', price = '221.31147540983608', id_tax_rules_group = '1', id_category_default = '412', 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 = '19409' 20/05/2022 05:58:06 pm >> DELETE FROM ps_specific_price WHERE id_product = '19409' 20/05/2022 05:59:04 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '252000/30' AND id_product != '19410' AND ean13 != '' 20/05/2022 05:59:04 pm >> UPDATE ps_product SET id_supplier = '98', reference = '', ean13 = '252000/30', date_upd = NOW() WHERE id_product = '19410' 20/05/2022 05:59:04 pm >> UPDATE ps_product_lang SET name = 'SACRO CUORE CM 30', description = '' WHERE id_product = '19410' 20/05/2022 05:59:04 pm >> UPDATE ps_product SET wholesale_price = '107.70', on_sale = '0', price = '209.01639344262296' WHERE id_product = '19410' 20/05/2022 05:59:04 pm >> UPDATE ps_product_shop SET wholesale_price = '107.70', price = '209.01639344262296', id_tax_rules_group = '1', id_category_default = '412', 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 = '19410' 20/05/2022 05:59:04 pm >> DELETE FROM ps_specific_price WHERE id_product = '19410' 20/05/2022 06:19:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '1616' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-20') 20/05/2022 06:19: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' , '1616' , '2022-05-20' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.00' , '1.64' , NOW() , NOW() ) 20/05/2022 06:19: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 = '57880' 20/05/2022 06:19:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '57880' 20/05/2022 06:19: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 ( '57880' , '17005' , 'BIGLIETTO AUGURALE medio' , '2' , '-2' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '2.00' ) 20/05/2022 06:19:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17005' AND id_supplier = '' 20/05/2022 06:19:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17005' , '' , '1' ) 20/05/2022 06:45:02 pm >> UPDATE ps_product_shop SET active = '0' WHERE id_product = '7934' 20/05/2022 06:50:04 pm >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '9798' 20/05/2022 06:50:04 pm >> UPDATE ps_stock_available SET quantity = quantity + '-2' WHERE id_product = '9798' 20/05/2022 06:55:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '1614' AND id_document != '57878' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-20') 20/05/2022 06:55:19 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1614', document_date = '2022-05-20', 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 = '79.60', price_tax_excluded = '66.44', date_upd = NOW() WHERE id_document = '57878' 20/05/2022 06:55:19 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 = '57878' 20/05/2022 06:55:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '57878' 20/05/2022 06:55:19 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 ( '57878' , '7934' , 'PERGAMENE - CRESIMA MOD. B' , '100' , '-100' , '1' , '0.5000' , '0.40983606557377' , '22' , '10' , '45.00' ) 20/05/2022 06:55:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7934' AND id_supplier = '' 20/05/2022 06:55:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7934' , '' , '1' ) 20/05/2022 06:55:19 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 ( '57878' , '11151' , 'LIBRI' , '3' , '-3' , '4' , '2.2000' , '2.2' , '0' , '0' , '6.60' ) 20/05/2022 06:55:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 20/05/2022 06:55:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 20/05/2022 06:55:19 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 ( '57878' , '9230' , 'SANTA RITA DA CASCIA - 10 ' , '4' , '-4' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '14.00' ) 20/05/2022 06:55:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9230' AND id_supplier = '' 20/05/2022 06:55:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9230' , '' , '1' ) 20/05/2022 06:55:20 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 ( '57878' , '5111' , 'SANTA RITA DA CASCIA - 11 BIS' , '4' , '-4' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '14.00' ) 20/05/2022 06:55:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5111' AND id_supplier = '' 20/05/2022 06:55:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5111' , '' , '1' ) 20/05/2022 07:30:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '86' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-05-20') 20/05/2022 07:30:04 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 ( '21' , '86' , '2022-05-20' , '' , '1529' , '0' , '4671563' , 'P.ZZA S. CROCE, 1 80059 TORRE DEL GRECO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '280.50' , '280.50' , NOW() , NOW() ) 20/05/2022 07:30:04 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 = '57881' 20/05/2022 07:30:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '57881' 20/05/2022 07:30:04 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 ( '57881' , '17257' , 'IO TI BATTEZZO ' , '100' , '-100' , '4' , '1.80' , '1.8' , '0' , '15' , '153.00' ) 20/05/2022 07:30:04 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 ( '57881' , '13462' , 'SE MI AMI NON PIANGERE' , '100' , '-100' , '4' , '1.50' , '1.5' , '0' , '15' , '127.50' )