28/07/2022 09:12:23 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 28/07/2022 09:12:23 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19830' , '1' , '' , 'nuovo-prodotto' ) 28/07/2022 09:12:23 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '19830' , '1' , '1' , '2' , NOW() , NOW() ) 28/07/2022 09:12:23 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '19830' , '0' , '1' , '0' , '0' ) 28/07/2022 09:13:38 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892216006' AND id_product != '19830' AND ean13 != '' 28/07/2022 09:13:38 am >> UPDATE ps_product SET id_supplier = '', reference = '7/1', ean13 = '9788892216006', date_upd = NOW() WHERE id_product = '19830' 28/07/2022 09:13:38 am >> UPDATE ps_product_lang SET name = 'magistero - giovanni paolo i', description = '' WHERE id_product = '19830' 28/07/2022 09:13:38 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '29' WHERE id_product = '19830' 28/07/2022 09:13:38 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '29', id_tax_rules_group = '4', id_category_default = '238', id_argoment_default = '41', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19830' 28/07/2022 09:13:38 am >> DELETE FROM ps_specific_price WHERE id_product = '19830' 28/07/2022 09:13:41 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 = '19830' 28/07/2022 09:13:41 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19831' , '1' , '' , 'nuovo-prodotto' ) 28/07/2022 09:13:41 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 '19831' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19830' 28/07/2022 09:13:41 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19831' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19830' 28/07/2022 09:15:12 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788898065929' AND id_product != '19831' AND ean13 != '' 28/07/2022 09:15:12 am >> UPDATE ps_product SET id_supplier = '', reference = '5/5', ean13 = '9788898065929', date_upd = NOW() WHERE id_product = '19831' 28/07/2022 09:15:12 am >> UPDATE ps_product_lang SET name = 'generale dalla chiesa - c. virzi\'', description = '' WHERE id_product = '19831' 28/07/2022 09:15:12 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '12.9' WHERE id_product = '19831' 28/07/2022 09:15:12 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '12.9', id_tax_rules_group = '4', id_category_default = '61', id_argoment_default = '40', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19831' 28/07/2022 09:15:12 am >> DELETE FROM ps_specific_price WHERE id_product = '19831' 28/07/2022 09:15:39 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788898065929' AND id_product != '19831' AND ean13 != '' 28/07/2022 09:15:39 am >> UPDATE ps_product SET id_supplier = '', reference = '5/5', ean13 = '9788898065929', date_upd = NOW() WHERE id_product = '19831' 28/07/2022 09:15:39 am >> UPDATE ps_product_lang SET name = 'GENERALE DALLA CHIESA - C. VIRZI\'', description = '' WHERE id_product = '19831' 28/07/2022 09:15:39 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '12.9000' WHERE id_product = '19831' 28/07/2022 09:15:39 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '12.9000', id_tax_rules_group = '4', id_category_default = '61', id_argoment_default = '40', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19831' 28/07/2022 09:15:39 am >> DELETE FROM ps_specific_price WHERE id_product = '19831' 28/07/2022 09:16:24 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892216006' AND id_product != '19830' AND ean13 != '' 28/07/2022 09:16:24 am >> UPDATE ps_product SET id_supplier = '', reference = '7/1', ean13 = '9788892216006', date_upd = NOW() WHERE id_product = '19830' 28/07/2022 09:16:24 am >> UPDATE ps_product_lang SET name = 'MAGISTERO - GIOVANNI PAOLO I', description = '' WHERE id_product = '19830' 28/07/2022 09:16:24 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '29.0000' WHERE id_product = '19830' 28/07/2022 09:16:24 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '29.0000', id_tax_rules_group = '4', id_category_default = '238', id_argoment_default = '41', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19830' 28/07/2022 09:16:24 am >> DELETE FROM ps_specific_price WHERE id_product = '19830' 28/07/2022 09:18:27 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' , '605829' , '2022-07-26' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '3.97' , '4' , '0' , '0' , '0' , '' , '11' , '0' , '135.95' , '135.95' , NOW() , NOW() ) 28/07/2022 09:18:27 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 = '59826' 28/07/2022 09:18:27 am >> DELETE FROM ps_document_detail WHERE id_document = '59826' 28/07/2022 09:18:27 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 ( '59826' , '19831' , 'GENERALE DALLA CHIESA - C. VIRZI' , '1' , '1' , '4' , '12.90' , '12.9' , '0' , '30' , '9.0300' ) 28/07/2022 09:18:27 am >> DELETE FROM ps_product_supplier WHERE id_product = '19831' AND id_supplier = '7' 28/07/2022 09:18:27 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19831' , '7' , '1' ) 28/07/2022 09:18:27 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 ( '59826' , '19662' , 'MESSALINO QUOTIDIANO - AGO/SET/OTT 2022' , '2' , '2' , '4' , '5.00' , '5' , '0' , '30' , '7.0000' ) 28/07/2022 09:18:27 am >> DELETE FROM ps_product_supplier WHERE id_product = '19662' AND id_supplier = '7' 28/07/2022 09:18:27 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19662' , '7' , '1' ) 28/07/2022 09:18:27 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 ( '59826' , '19830' , 'MAGISTERO - GIOVANNI PAOLO I' , '1' , '1' , '4' , '29.00' , '29' , '0' , '33' , '19.4300' ) 28/07/2022 09:18:27 am >> DELETE FROM ps_product_supplier WHERE id_product = '19830' AND id_supplier = '7' 28/07/2022 09:18:27 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19830' , '7' , '1' ) 28/07/2022 09:18:27 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 ( '59826' , '12808' , 'OMELIE PER LE ESEQUIE' , '1' , '1' , '4' , '9.50' , '9.5' , '0' , '30' , '6.6500' ) 28/07/2022 09:18:27 am >> DELETE FROM ps_product_supplier WHERE id_product = '12808' AND id_supplier = '7' 28/07/2022 09:18:27 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12808' , '7' , '1' ) 28/07/2022 09:18:27 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 ( '59826' , '16293' , 'ALBUM RICORDO DEL MIO BATTESIMO ROSA' , '1' , '1' , '4' , '12.00' , '12' , '0' , '33' , '8.0400' ) 28/07/2022 09:18:27 am >> DELETE FROM ps_product_supplier WHERE id_product = '16293' AND id_supplier = '7' 28/07/2022 09:18:28 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16293' , '7' , '1' ) 28/07/2022 09:18: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 ( '59826' , '19513' , 'CARLO ACUTIS -DALLA PISTA .... - M. MUSOLINO' , '1' , '1' , '4' , '12.90' , '12.9' , '0' , '30' , '9.0300' ) 28/07/2022 09:18:28 am >> DELETE FROM ps_product_supplier WHERE id_product = '19513' AND id_supplier = '7' 28/07/2022 09:18:28 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19513' , '7' , '1' ) 28/07/2022 09:18: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 ( '59826' , '11020' , 'VANGELI SINOTTICI E ATTI DEGLI APOSTOLI - 5 - LOGOS' , '1' , '1' , '4' , '39.00' , '39' , '0' , '35' , '25.3500' ) 28/07/2022 09:18:28 am >> DELETE FROM ps_product_supplier WHERE id_product = '11020' AND id_supplier = '7' 28/07/2022 09:18:28 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11020' , '7' , '1' ) 28/07/2022 09:18: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 ( '59826' , '5739' , 'LETTERE PAOLINE E ALTRE LETTERE - 6 - LOGOS' , '1' , '1' , '4' , '35.00' , '35' , '0' , '35' , '22.7500' ) 28/07/2022 09:18:28 am >> DELETE FROM ps_product_supplier WHERE id_product = '5739' AND id_supplier = '7' 28/07/2022 09:18:28 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5739' , '7' , '1' ) 28/07/2022 09:18: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 ( '59826' , '7240' , 'OPERA GIOVANNEA - 7 - CORSO STUDI BIBLICI - LOGOS' , '1' , '1' , '4' , '38.00' , '38' , '0' , '35' , '24.7000' ) 28/07/2022 09:18:28 am >> DELETE FROM ps_product_supplier WHERE id_product = '7240' AND id_supplier = '7' 28/07/2022 09:18:28 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7240' , '7' , '1' ) 28/07/2022 09:43:29 am >> SELECT document_num FROM ps_document WHERE document_num = '2383' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-28') 28/07/2022 09:43: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' , '2383' , '2022-07-28' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '35.15' , '35.15' , NOW() , NOW() ) 28/07/2022 09:43: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 = '59827' 28/07/2022 09:43:29 am >> DELETE FROM ps_document_detail WHERE id_document = '59827' 28/07/2022 09:43: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 ( '59827' , '19822' , 'CRISTIANESIMO COME FORMA DI VITA' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 28/07/2022 09:43:29 am >> DELETE FROM ps_product_supplier WHERE id_product = '19822' AND id_supplier = '' 28/07/2022 09:43:29 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19822' , '' , '1' ) 28/07/2022 09:43: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 ( '59827' , '19825' , '1945 PAROLE PER UN NUOVO ORIENTAMENTO - R. GUARDINI' , '1' , '-1' , '4' , '22.00' , '22' , '0' , '5' , '20.90' ) 28/07/2022 09:43:29 am >> DELETE FROM ps_product_supplier WHERE id_product = '19825' AND id_supplier = '' 28/07/2022 09:43:29 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19825' , '' , '1' ) 28/07/2022 10:06:40 am >> SELECT document_num FROM ps_document WHERE document_num = '2384' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-28') 28/07/2022 10:06:40 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' , '2384' , '2022-07-28' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '407.00' , '339.02' , NOW() , NOW() ) 28/07/2022 10:06:40 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 = '59828' 28/07/2022 10:06:40 am >> DELETE FROM ps_document_detail WHERE id_document = '59828' 28/07/2022 10:06:40 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 ( '59828' , '795' , 'ASTUCCIO A 3 OLI SANTI IN ALLUMINIO - 1958' , '1' , '-1' , '1' , '67.00' , '54.918032786885' , '22' , '0' , '67.00' ) 28/07/2022 10:06:40 am >> DELETE FROM ps_product_supplier WHERE id_product = '795' AND id_supplier = '' 28/07/2022 10:06:40 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '795' , '' , '1' ) 28/07/2022 10:06:40 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 ( '59828' , '17101' , 'CASULA POLIESTERE CROCE ORO - AECU04' , '4' , '-4' , '1' , '70' , '57.377049180328' , '22' , '0' , '280.00' ) 28/07/2022 10:06:40 am >> DELETE FROM ps_product_supplier WHERE id_product = '17101' AND id_supplier = '' 28/07/2022 10:06:40 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17101' , '' , '1' ) 28/07/2022 10:06:40 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 ( '59828' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '30' , '30' , '0' , '0' , '30.00' ) 28/07/2022 10:06:40 am >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 28/07/2022 10:06:40 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 28/07/2022 10:06:40 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 ( '59828' , '547' , 'AMPOLLINE E VASSOIO IN VETRO - 506' , '1' , '-1' , '1' , '30' , '24.590163934426' , '22' , '0' , '30.00' ) 28/07/2022 10:06:40 am >> DELETE FROM ps_product_supplier WHERE id_product = '547' AND id_supplier = '' 28/07/2022 10:06:40 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '547' , '' , '1' ) 28/07/2022 10:11:03 am >> SELECT document_num FROM ps_document WHERE document_num = '2385' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-28') 28/07/2022 10:11: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' , '2385' , '2022-07-28' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.20' , '10.82' , NOW() , NOW() ) 28/07/2022 10:11: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 = '59829' 28/07/2022 10:11:03 am >> DELETE FROM ps_document_detail WHERE id_document = '59829' 28/07/2022 10:11: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 ( '59829' , '16252' , 'CUORE PENDENTE' , '1' , '-1' , '1' , '12.20' , '10' , '22' , '0' , '12.20' ) 28/07/2022 10:11:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '16252' AND id_supplier = '' 28/07/2022 10:11:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16252' , '' , '1' ) 28/07/2022 10:11: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 ( '59829' , '17005' , 'BIGLIETTO AUGURALE medio' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 28/07/2022 10:11:04 am >> DELETE FROM ps_product_supplier WHERE id_product = '17005' AND id_supplier = '' 28/07/2022 10:11:04 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17005' , '' , '1' ) 28/07/2022 10:29:45 am >> SELECT document_num FROM ps_document WHERE document_num = '2386' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-28') 28/07/2022 10:29:45 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' , '2386' , '2022-07-28' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '27.25' , '24.91' , NOW() , NOW() ) 28/07/2022 10:29:45 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 = '59830' 28/07/2022 10:29:45 am >> DELETE FROM ps_document_detail WHERE id_document = '59830' 28/07/2022 10:29:45 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 ( '59830' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '2' , '-2' , '1' , '6.50' , '5.327868852459' , '22' , '0' , '13.00' ) 28/07/2022 10:29:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '11757' AND id_supplier = '' 28/07/2022 10:29:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11757' , '' , '1' ) 28/07/2022 10:29:45 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 ( '59830' , '19662' , 'MESSALINO QUOTIDIANO - AGO/SET/OTT 2022' , '3' , '-3' , '4' , '5.00' , '5' , '0' , '5' , '14.25' ) 28/07/2022 10:29:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '19662' AND id_supplier = '' 28/07/2022 10:29:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19662' , '' , '1' ) 28/07/2022 11:03:14 am >> SELECT document_num FROM ps_document WHERE document_num = '2387' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-28') 28/07/2022 11:03: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 ( '11' , '2387' , '2022-07-28' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '77.00' , '63.84' , NOW() , NOW() ) 28/07/2022 11:03: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 = '59831' 28/07/2022 11:03:14 am >> DELETE FROM ps_document_detail WHERE id_document = '59831' 28/07/2022 11:03: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 ( '59831' , '19395' , 'CLERGY MISTO COTONE ML - C01' , '2' , '-2' , '1' , '36.50' , '29.918032786885' , '22' , '0' , '73.00' ) 28/07/2022 11:03:14 am >> DELETE FROM ps_product_supplier WHERE id_product = '19395' AND id_supplier = '' 28/07/2022 11:03:14 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19395' , '' , '1' ) 28/07/2022 11:03: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 ( '59831' , '19805' , 'DESIDERIO DESIDERAVI' , '2' , '-2' , '4' , '2.00' , '2' , '0' , '0' , '4.00' ) 28/07/2022 11:03:14 am >> DELETE FROM ps_product_supplier WHERE id_product = '19805' AND id_supplier = '' 28/07/2022 11:03:14 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19805' , '' , '1' ) 28/07/2022 12:01:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '1323' AND id_document != '56505' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-04-29') 28/07/2022 12:01:19 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1323', document_date = '2022-04-29', 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 = '76.00', price_tax_excluded = '62.30', date_upd = NOW() WHERE id_document = '56505' 28/07/2022 12:01: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 = '56505' 28/07/2022 12:01:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '56505' 28/07/2022 12:01: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 ( '56505' , '2269' , 'CLERGY GRIGIO CHIARO ML - COTONE 44 ' , '1' , '-1' , '1' , '45.0000' , '36.885245901639' , '22' , '15' , '38.25' ) 28/07/2022 12:01:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2269' AND id_supplier = '' 28/07/2022 12:01:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2269' , '' , '1' ) 28/07/2022 12:01: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 ( '56505' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '7.75' , '6.3524590163934' , '22' , '0' , '7.75' ) 28/07/2022 12:01:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 28/07/2022 12:01:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 28/07/2022 12:01: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 ( '56505' , '2297' , 'CLERGY GRIGIO CHIARO MM - MISTO 45 ' , '1' , '-1' , '1' , '30' , '24.590163934426' , '22' , '0' , '30.00' ) 28/07/2022 12:01:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2297' AND id_supplier = '' 28/07/2022 12:01:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2297' , '' , '1' ) 28/07/2022 12:03:47 pm >> SELECT document_num FROM ps_document WHERE document_num = '1726' AND id_document != '58532' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-31') 28/07/2022 12:03:47 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1726', document_date = '2022-05-31', 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 = '42.00', price_tax_excluded = '34.43', date_upd = NOW() WHERE id_document = '58532' 28/07/2022 12:03:47 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 = '58532' 28/07/2022 12:03:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '58532' 28/07/2022 12:03:47 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 ( '58532' , '7915' , 'PERGAMENE - 1A COMUNIONE MOD. D' , '4' , '-4' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '2.00' ) 28/07/2022 12:03:47 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7915' AND id_supplier = '' 28/07/2022 12:03:47 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7915' , '' , '1' ) 28/07/2022 12:03:47 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 ( '58532' , '19595' , 'POLO JERSEY COTONE 100% - EXTRA' , '1' , '-1' , '1' , '40' , '32.786885245902' , '22' , '0' , '40.00' ) 28/07/2022 12:03:47 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19595' AND id_supplier = '' 28/07/2022 12:03:47 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19595' , '' , '1' ) 28/07/2022 12:44:10 pm >> SELECT document_num FROM ps_document WHERE document_num = '2388' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-28') 28/07/2022 12:44:10 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' , '2388' , '2022-07-28' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '46.81' , '46.54' , NOW() , NOW() ) 28/07/2022 12:44:10 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 = '59832' 28/07/2022 12:44:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '59832' 28/07/2022 12:44:10 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 ( '59832' , '19812' , 'IO SONO LA POLVERE - GIOVANNI PAOLO I' , '1' , '-1' , '4' , '39.00' , '39' , '0' , '5' , '37.05' ) 28/07/2022 12:44:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19812' AND id_supplier = '' 28/07/2022 12:44:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19812' , '' , '1' ) 28/07/2022 12:44:10 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 ( '59832' , '18380' , 'BELLEZZA DELLORDINE - S. WEIL' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '5' , '2.76' ) 28/07/2022 12:44:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18380' AND id_supplier = '' 28/07/2022 12:44:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18380' , '' , '1' ) 28/07/2022 12:44:10 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 ( '59832' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 28/07/2022 12:44:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 28/07/2022 12:44:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 28/07/2022 12:44:28 pm >> SELECT document_num FROM ps_document WHERE document_num = '2389' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-28') 28/07/2022 12:44:29 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' , '2389' , '2022-07-28' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.00' , '15.57' , NOW() , NOW() ) 28/07/2022 12:44:29 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 = '59833' 28/07/2022 12:44:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '59833' 28/07/2022 12:44:29 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 ( '59833' , '2943' , 'CROCE ASSISI' , '1' , '-1' , '1' , '19.00' , '15.573770491803' , '22' , '0' , '19.00' ) 28/07/2022 12:44:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2943' AND id_supplier = '' 28/07/2022 12:44:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2943' , '' , '1' ) 28/07/2022 12:52:31 pm >> SELECT ean13 FROM ps_product WHERE ean13 = 'OF1-NERO' AND id_product != '19817' AND ean13 != '' 28/07/2022 12:52:31 pm >> UPDATE ps_product SET id_supplier = '147', reference = '', ean13 = 'OF1-NERO', date_upd = NOW() WHERE id_product = '19817' 28/07/2022 12:52:31 pm >> UPDATE ps_product_lang SET name = 'OFFERTORIO IN FERRO', description = '' WHERE id_product = '19817' 28/07/2022 12:52:31 pm >> UPDATE ps_product SET wholesale_price = '165.00', on_sale = '0', price = '327.8688524590164' WHERE id_product = '19817' 28/07/2022 12:52:31 pm >> UPDATE ps_product_shop SET wholesale_price = '165.00', price = '327.8688524590164', id_tax_rules_group = '1', id_category_default = '474', 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 = '19817' 28/07/2022 12:52:31 pm >> DELETE FROM ps_specific_price WHERE id_product = '19817' 28/07/2022 12:52:40 pm >> SELECT document_num FROM ps_document WHERE document_num = '56/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-07-28') 28/07/2022 12:52:40 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 ( '24' , '56/A' , '2022-07-28' , 'A' , '3865' , '0' , '4673708' , 'VIA CROCE 1 - FRAZ. SALITTO 84062 OLEVANO SUL TUSCIANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '400.00' , '327.87' , NOW() , NOW() ) 28/07/2022 12:52:40 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '59834' 28/07/2022 12:52:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '59834' 28/07/2022 12:52:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59834' , '19817' , 'OFFERTORIO IN FERRO' , '1' , '-1' , '1' , '400.00' , '327.86885245902' , '22' , '0' , '400.00' ) 28/07/2022 02:40:58 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 28/07/2022 02:40:58 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19832' , '1' , '' , 'nuovo-prodotto' ) 28/07/2022 02:40:58 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '19832' , '1' , '1' , '2' , NOW() , NOW() ) 28/07/2022 02:40:58 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '19832' , '0' , '1' , '0' , '0' ) 28/07/2022 02:41:38 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788872299722' AND id_product != '19832' AND ean13 != '' 28/07/2022 02:41:38 pm >> UPDATE ps_product SET id_supplier = '', reference = '5/4', ean13 = '9788872299722', date_upd = NOW() WHERE id_product = '19832' 28/07/2022 02:41:38 pm >> UPDATE ps_product_lang SET name = 'PICCOLA VIA ', description = '' WHERE id_product = '19832' 28/07/2022 02:41:38 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '13' WHERE id_product = '19832' 28/07/2022 02:41:39 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '13', id_tax_rules_group = '4', id_category_default = '128', 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 = '19832' 28/07/2022 02:41:39 pm >> DELETE FROM ps_specific_price WHERE id_product = '19832' 28/07/2022 02:41: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 = '19832' 28/07/2022 02:41:40 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19833' , '1' , '' , 'nuovo-prodotto' ) 28/07/2022 02:41: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 '19833' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19832' 28/07/2022 02:41:40 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19833' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19832' 28/07/2022 02:42:45 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791280210227' AND id_product != '19833' AND ean13 != '' 28/07/2022 02:42:45 pm >> UPDATE ps_product SET id_supplier = '', reference = '6/4', ean13 = '9791280210227', date_upd = NOW() WHERE id_product = '19833' 28/07/2022 02:42:45 pm >> UPDATE ps_product_lang SET name = 'PADRE PIO MODELLO DI SANTITA\' - GUARINO/STANZIONE', description = '' WHERE id_product = '19833' 28/07/2022 02:42:45 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '13' WHERE id_product = '19833' 28/07/2022 02:42:45 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '13', id_tax_rules_group = '4', id_category_default = '99', id_argoment_default = '71', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19833' 28/07/2022 02:42:45 pm >> DELETE FROM ps_specific_price WHERE id_product = '19833' 28/07/2022 02:42:46 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 = '19833' 28/07/2022 02:42:46 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19834' , '1' , '' , 'nuovo-prodotto' ) 28/07/2022 02:42:46 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 '19834' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19833' 28/07/2022 02:42:46 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19834' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19833' 28/07/2022 02:43:21 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788817013369' AND id_product != '19834' AND ean13 != '' 28/07/2022 02:43:21 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788817013369', date_upd = NOW() WHERE id_product = '19834' 28/07/2022 02:43:21 pm >> UPDATE ps_product_lang SET name = 'IL CORANO', description = '' WHERE id_product = '19834' 28/07/2022 02:43:21 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '14' WHERE id_product = '19834' 28/07/2022 02:43:21 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '14', id_tax_rules_group = '4', id_category_default = '239', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19834' 28/07/2022 02:43:21 pm >> DELETE FROM ps_specific_price WHERE id_product = '19834' 28/07/2022 02:43:22 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 = '19834' 28/07/2022 02:43:22 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19835' , '1' , '' , 'nuovo-prodotto' ) 28/07/2022 02:43:22 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 '19835' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19834' 28/07/2022 02:43:22 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19835' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19834' 28/07/2022 02:43:47 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' , '4017' , '2022-07-26' , '' , '0' , '47' , '2642' , 'V.LE BACCHIGLIONE, 20 20139 MILANO' , '' , '' , '5' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '46.14' , '46.14' , NOW() , NOW() ) 28/07/2022 02:43:47 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 = '59835' 28/07/2022 02:43:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '59835' 28/07/2022 02:43:47 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 ( '59835' , '16751' , 'RIVELAZIONI PROFETICHE SR. M. NATALIA' , '1' , '1' , '4' , '18.00' , '18' , '0' , '27' , '13.1400' ) 28/07/2022 02:43:47 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16751' AND id_supplier = '47' 28/07/2022 02:43:47 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16751' , '47' , '1' ) 28/07/2022 02:43:47 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 ( '59835' , '19832' , 'PICCOLA VIA ' , '1' , '1' , '4' , '13.00' , '13' , '0' , '30' , '9.1000' ) 28/07/2022 02:43:47 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19832' AND id_supplier = '47' 28/07/2022 02:43:47 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19832' , '47' , '1' ) 28/07/2022 02:43:47 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 ( '59835' , '19833' , 'PADRE PIO MODELLO DI SANTITA - GUARINO/STANZIONE' , '1' , '1' , '4' , '13.00' , '13' , '0' , '30' , '9.1000' ) 28/07/2022 02:43:47 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19833' AND id_supplier = '47' 28/07/2022 02:43:47 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19833' , '47' , '1' ) 28/07/2022 02:43:47 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 ( '59835' , '19834' , 'IL CORANO' , '1' , '1' , '4' , '14.00' , '14' , '0' , '30' , '9.8000' ) 28/07/2022 02:43:47 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19834' AND id_supplier = '47' 28/07/2022 02:43:47 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19834' , '47' , '1' ) 28/07/2022 02:47:13 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788858126707' AND id_product != '19835' AND ean13 != '' 28/07/2022 02:47:13 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788858126707', date_upd = NOW() WHERE id_product = '19835' 28/07/2022 02:47:13 pm >> UPDATE ps_product_lang SET name = 'CHIESA SINODALE', description = '' WHERE id_product = '19835' 28/07/2022 02:47:13 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '24' WHERE id_product = '19835' 28/07/2022 02:47:13 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '24', id_tax_rules_group = '4', id_category_default = '350', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19835' 28/07/2022 02:47:13 pm >> DELETE FROM ps_specific_price WHERE id_product = '19835' 28/07/2022 02:47:14 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 = '19835' 28/07/2022 02:47:14 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19836' , '1' , '' , 'nuovo-prodotto' ) 28/07/2022 02:47:14 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 '19836' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19835' 28/07/2022 02:47:14 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19836' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19835' 28/07/2022 02:48:18 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788855450522' AND id_product != '19836' AND ean13 != '' 28/07/2022 02:48:18 pm >> UPDATE ps_product SET id_supplier = '', reference = '7/5', ean13 = '9788855450522', date_upd = NOW() WHERE id_product = '19836' 28/07/2022 02:48:18 pm >> UPDATE ps_product_lang SET name = 'MISTERO MISTAGOGIA MISTICA - Y DE ANDIA', description = '' WHERE id_product = '19836' 28/07/2022 02:48:18 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '30' WHERE id_product = '19836' 28/07/2022 02:48:18 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '30', id_tax_rules_group = '4', id_category_default = '77', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19836' 28/07/2022 02:48:18 pm >> DELETE FROM ps_specific_price WHERE id_product = '19836' 28/07/2022 02:48:18 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 = '19836' 28/07/2022 02:48:18 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19837' , '1' , '' , 'nuovo-prodotto' ) 28/07/2022 02:48:18 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 '19837' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19836' 28/07/2022 02:48:18 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19837' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19836' 28/07/2022 02:49:26 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791254780084' AND id_product != '19837' AND ean13 != '' 28/07/2022 02:49:26 pm >> UPDATE ps_product SET id_supplier = '', reference = '7/6', ean13 = '9791254780084', date_upd = NOW() WHERE id_product = '19837' 28/07/2022 02:49:26 pm >> UPDATE ps_product_lang SET name = 'ABBANDONATEVI A CRISTO - F. SHEEN', description = '' WHERE id_product = '19837' 28/07/2022 02:49:26 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '25' WHERE id_product = '19837' 28/07/2022 02:49:26 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '25', id_tax_rules_group = '4', id_category_default = '100', 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 = '19837' 28/07/2022 02:49:26 pm >> DELETE FROM ps_specific_price WHERE id_product = '19837' 28/07/2022 02:49:27 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 = '19837' 28/07/2022 02:49:27 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19838' , '1' , '' , 'nuovo-prodotto' ) 28/07/2022 02:49:27 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 '19838' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19837' 28/07/2022 02:49:27 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19838' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19837' 28/07/2022 02:50:15 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788869298547' AND id_product != '19838' AND ean13 != '' 28/07/2022 02:50:15 pm >> UPDATE ps_product SET id_supplier = '', reference = '6/4', ean13 = '9788869298547', date_upd = NOW() WHERE id_product = '19838' 28/07/2022 02:50:15 pm >> UPDATE ps_product_lang SET name = 'NATUZZA EVOLO E L\'ALDILA\' - V. MARINELLI', description = '' WHERE id_product = '19838' 28/07/2022 02:50:15 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '18' WHERE id_product = '19838' 28/07/2022 02:50:15 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '18', id_tax_rules_group = '4', id_category_default = '45', id_argoment_default = '71', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19838' 28/07/2022 02:50:15 pm >> DELETE FROM ps_specific_price WHERE id_product = '19838' 28/07/2022 02:50: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 = '19838' 28/07/2022 02:50:16 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19839' , '1' , '' , 'nuovo-prodotto' ) 28/07/2022 02:50: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 '19839' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19838' 28/07/2022 02:50:16 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19839' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19838' 28/07/2022 02:50:55 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788869298608' AND id_product != '19839' AND ean13 != '' 28/07/2022 02:50:55 pm >> UPDATE ps_product SET id_supplier = '', reference = '6/3', ean13 = '9788869298608', date_upd = NOW() WHERE id_product = '19839' 28/07/2022 02:50:55 pm >> UPDATE ps_product_lang SET name = 'SAN GIOVANNI DELLA CROCE - M. TONDO', description = '' WHERE id_product = '19839' 28/07/2022 02:50:55 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '16' WHERE id_product = '19839' 28/07/2022 02:50:55 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '16', id_tax_rules_group = '4', id_category_default = '45', id_argoment_default = '71', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19839' 28/07/2022 02:50:55 pm >> DELETE FROM ps_specific_price WHERE id_product = '19839' 28/07/2022 02:50:56 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 = '19839' 28/07/2022 02:50:56 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19840' , '1' , '' , 'nuovo-prodotto' ) 28/07/2022 02:50:56 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 '19840' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19839' 28/07/2022 02:50:56 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19840' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19839' 28/07/2022 02:51:31 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788869297656' AND id_product != '19840' AND ean13 != '' 28/07/2022 02:51:31 pm >> UPDATE ps_product SET id_supplier = '', reference = '7/3', ean13 = '9788869297656', date_upd = NOW() WHERE id_product = '19840' 28/07/2022 02:51:31 pm >> UPDATE ps_product_lang SET name = 'PERLE DI DON DOLINDO', description = '' WHERE id_product = '19840' 28/07/2022 02:51:31 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '12' WHERE id_product = '19840' 28/07/2022 02:51:31 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '12', id_tax_rules_group = '4', id_category_default = '45', 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 = '19840' 28/07/2022 02:51:31 pm >> DELETE FROM ps_specific_price WHERE id_product = '19840' 28/07/2022 02:51:32 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 = '19840' 28/07/2022 02:51:32 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19841' , '1' , '' , 'nuovo-prodotto' ) 28/07/2022 02:51:32 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 '19841' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19840' 28/07/2022 02:51:32 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19841' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19840' 28/07/2022 02:51:40 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' , '599243' , '2022-07-27' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '125.00' , '125.00' , NOW() , NOW() ) 28/07/2022 02:51:40 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '59836' 28/07/2022 02:51:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '59836' 28/07/2022 02:51:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59836' , '19835' , 'CHIESA SINODALE' , '1' , '1' , '4' , '24.00' , '24' , '0' , '0' , '24.00' ) 28/07/2022 02:51:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19835' AND id_supplier = '109' 28/07/2022 02:51:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19835' , '109' , '1' ) 28/07/2022 02:51:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59836' , '19836' , 'MISTERO MISTAGOGIA MISTICA - Y DE ANDIA' , '1' , '1' , '4' , '30.00' , '30' , '0' , '0' , '30.00' ) 28/07/2022 02:51:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19836' AND id_supplier = '109' 28/07/2022 02:51:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19836' , '109' , '1' ) 28/07/2022 02:51:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59836' , '19837' , 'ABBANDONATEVI A CRISTO - F. SHEEN' , '1' , '1' , '4' , '25.00' , '25' , '0' , '0' , '25.00' ) 28/07/2022 02:51:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19837' AND id_supplier = '109' 28/07/2022 02:51:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19837' , '109' , '1' ) 28/07/2022 02:51:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59836' , '19838' , 'NATUZZA EVOLO E LALDILA - V. MARINELLI' , '1' , '1' , '4' , '18.00' , '18' , '0' , '0' , '18.00' ) 28/07/2022 02:51:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19838' AND id_supplier = '109' 28/07/2022 02:51:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19838' , '109' , '1' ) 28/07/2022 02:51:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59836' , '19839' , 'SAN GIOVANNI DELLA CROCE - M. TONDO' , '1' , '1' , '4' , '16.00' , '16' , '0' , '0' , '16.00' ) 28/07/2022 02:51:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19839' AND id_supplier = '109' 28/07/2022 02:51:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19839' , '109' , '1' ) 28/07/2022 02:51:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59836' , '19840' , 'PERLE DI DON DOLINDO' , '1' , '1' , '4' , '12.00' , '12' , '0' , '0' , '12.00' ) 28/07/2022 02:51:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19840' AND id_supplier = '109' 28/07/2022 02:51:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19840' , '109' , '1' ) 28/07/2022 03:04:08 pm >> INSERT INTO ps_supplier ( name , email , `date_add` , `date_upd` ) VALUES ( '' , '' , NOW() , NOW() ) 28/07/2022 03:04:09 pm >> INSERT INTO ps_supplier_shop ( id_supplier , id_shop ) VALUES ( '164' , '1' ) 28/07/2022 03:04:09 pm >> INSERT INTO ps_supplier_lang ( id_supplier , id_lang ) VALUES ( '164' , '1' ) 28/07/2022 03:04:09 pm >> INSERT INTO ps_address ( id_supplier , id_country , id_state , alias , lastname , firstname , address1 , city , date_add , date_upd ) VALUES ( '164' , '10' , '0' , '' , '' , '' , '' , '' , NOW() , NOW() ) 28/07/2022 03:06:08 pm >> UPDATE ps_address SET id_state = '147', lastname = 'GLESANT srl', address1 = 'VIA DEI CONTI FALLUC, 70/A', address2 = '', postcode = '88100', dni = '', vat_number = '02536940790', city = 'CATANZARO', phone = '0961764049', phone_mobile = '', date_upd = NOW() WHERE id_supplier = '164' 28/07/2022 03:06:08 pm >> UPDATE ps_supplier SET email = 'info@glesant.it', name = 'GLESANT srl', date_upd = NOW() WHERE id_supplier = '164' 28/07/2022 03:06:08 pm >> UPDATE ps_supplier_lang SET description = '', meta_title = '', meta_description = '' WHERE id_supplier = '164' 28/07/2022 03:06:31 pm >> INSERT INTO ps_category ( id_parent , `date_add` , `date_upd` , level_depth ) VALUES ( '4' , NOW() , NOW() , '3' ) 28/07/2022 03:06:31 pm >> INSERT INTO ps_category_group ( id_category , id_group ) VALUES ( '500' , '1' ) 28/07/2022 03:06:31 pm >> INSERT INTO ps_category_group ( id_category , id_group ) VALUES ( '500' , '2' ) 28/07/2022 03:06:31 pm >> INSERT INTO ps_category_group ( id_category , id_group ) VALUES ( '500' , '3' ) 28/07/2022 03:06:31 pm >> INSERT INTO ps_category_lang ( id_category , id_lang , name , link_rewrite ) VALUES ( '500' , '1' , 'GLESANT' , LOWER('GLESANT') ) 28/07/2022 03:06:31 pm >> INSERT INTO ps_category_shop ( id_category , id_shop , position ) VALUES ( '500' , '1' , '0' ) 28/07/2022 03:34:13 pm >> SELECT document_num FROM ps_document WHERE document_num = '2000' AND id_document != '58852' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-22') 28/07/2022 03:34:13 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2000', document_date = '2022-06-22', 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 = '66.50', price_tax_excluded = '54.51', date_upd = NOW() WHERE id_document = '58852' 28/07/2022 03:34:13 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 = '58852' 28/07/2022 03:34:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '58852' 28/07/2022 03:34:13 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 ( '58852' , '17277' , 'BRACCIALE PIETRE DURE - 4633' , '5' , '-5' , '1' , '5.5000' , '4.5081967213115' , '22' , '0' , '27.50' ) 28/07/2022 03:34:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17277' AND id_supplier = '' 28/07/2022 03:34:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17277' , '' , '1' ) 28/07/2022 03:34:13 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 ( '58852' , '3075' , 'CROCE S. BENEDETTO BAGNO ORO 24KT' , '2' , '-2' , '1' , '9.0000' , '7.3770491803279' , '22' , '0' , '18.00' ) 28/07/2022 03:34:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '3075' AND id_supplier = '' 28/07/2022 03:34:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3075' , '' , '1' ) 28/07/2022 03:34:13 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 ( '58852' , '8179' , 'PORTACORONA - 017' , '5' , '-5' , '1' , '1.7000' , '1.3934426229508' , '22' , '0' , '8.50' ) 28/07/2022 03:34:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8179' AND id_supplier = '' 28/07/2022 03:34:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8179' , '' , '1' ) 28/07/2022 03:34:13 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 ( '58852' , '12192' , 'CROCE BIANCA CM 11,5 - GAY MATTIOLO' , '1' , '-1' , '1' , '12.5' , '10.245901639344' , '22' , '0' , '12.50' ) 28/07/2022 03:34:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12192' AND id_supplier = '' 28/07/2022 03:34:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12192' , '' , '1' ) 28/07/2022 05:20:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '2390' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-28') 28/07/2022 05:20:55 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' , '2390' , '2022-07-28' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '110.00' , '110.00' , NOW() , NOW() ) 28/07/2022 05:20: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 = '59837' 28/07/2022 05:20:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '59837' 28/07/2022 05:20: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 ( '59837' , '11020' , 'VANGELI SINOTTICI E ATTI DEGLI APOSTOLI - 5 - LOGOS' , '1' , '-1' , '4' , '39.00' , '39' , '0' , '5' , '37.05' ) 28/07/2022 05:20:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11020' AND id_supplier = '' 28/07/2022 05:20:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11020' , '' , '1' ) 28/07/2022 05:20: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 ( '59837' , '7240' , 'OPERA GIOVANNEA - 7 - CORSO STUDI BIBLICI - LOGOS' , '1' , '-1' , '4' , '38.00' , '38' , '0' , '5' , '36.10' ) 28/07/2022 05:20:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7240' AND id_supplier = '' 28/07/2022 05:20:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7240' , '' , '1' ) 28/07/2022 05:20: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 ( '59837' , '5739' , 'LETTERE PAOLINE E ALTRE LETTERE - 6 - LOGOS' , '1' , '-1' , '4' , '35.00' , '35' , '0' , '5' , '33.25' ) 28/07/2022 05:20:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5739' AND id_supplier = '' 28/07/2022 05:20:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5739' , '' , '1' ) 28/07/2022 05:20: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 ( '59837' , '19684' , 'AMEN - SET. 2022' , '1' , '-1' , '4' , '3.6' , '3.6' , '0' , '' , '3.60' ) 28/07/2022 05:20:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19684' AND id_supplier = '' 28/07/2022 05:20:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19684' , '' , '1' ) 28/07/2022 05:21:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '2182' AND id_document != '59062' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-06') 28/07/2022 05:21:59 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2182', document_date = '2022-07-06', 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 = '72.00', price_tax_excluded = '60.28', date_upd = NOW() WHERE id_document = '59062' 28/07/2022 05:21:59 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 = '59062' 28/07/2022 05:21:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '59062' 28/07/2022 05:21:59 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 ( '59062' , '16408' , 'AMPOLLE DORATE CON BECCUCCIO - 1503' , '1' , '-1' , '1' , '65.0000' , '53.27868852459' , '22' , '0' , '65.00' ) 28/07/2022 05:21:59 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16408' AND id_supplier = '' 28/07/2022 05:21:59 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16408' , '' , '1' ) 28/07/2022 05:21:59 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 ( '59062' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '3.29' , '3.29' , '0' , '0' , '3.29' ) 28/07/2022 05:21:59 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 28/07/2022 05:22:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 28/07/2022 05:22:00 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 ( '59062' , '19685' , 'AMEN - OTT 2022' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 28/07/2022 05:22:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19685' AND id_supplier = '' 28/07/2022 05:22:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19685' , '' , '1' ) 28/07/2022 05:25:44 pm >> SELECT document_num FROM ps_document WHERE document_num = '2182' AND id_document != '59062' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-06') 28/07/2022 05:25:44 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2182', document_date = '2022-07-06', 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 = '72.00', price_tax_excluded = '60.28', date_upd = NOW() WHERE id_document = '59062' 28/07/2022 05:25:44 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 = '59062' 28/07/2022 05:25:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '59062' 28/07/2022 05:25:44 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 ( '59062' , '16408' , 'AMPOLLE DORATE CON BECCUCCIO - 1503' , '1' , '-1' , '1' , '65.0000' , '53.27868852459' , '22' , '0' , '65.00' ) 28/07/2022 05:25:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16408' AND id_supplier = '' 28/07/2022 05:25:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16408' , '' , '1' ) 28/07/2022 05:25:44 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 ( '59062' , '19622' , 'SULLA TUA PAROLA - SETT/OTT 2022' , '1' , '-1' , '4' , '3.29' , '3.29' , '0' , '0' , '3.29' ) 28/07/2022 05:25:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19622' AND id_supplier = '' 28/07/2022 05:25:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19622' , '' , '1' ) 28/07/2022 05:25:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59062' , '19685' , 'AMEN - OTT 2022' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '5' , '3.71' ) 28/07/2022 05:25:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19685' AND id_supplier = '' 28/07/2022 05:25:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19685' , '' , '1' ) 28/07/2022 06:34:58 pm >> SELECT document_num FROM ps_document WHERE document_num = '2391' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-28') 28/07/2022 06:34:58 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' , '2391' , '2022-07-28' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.20' , '10.00' , NOW() , NOW() ) 28/07/2022 06:34:58 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 = '59838' 28/07/2022 06:34:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '59838' 28/07/2022 06:34:58 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 ( '59838' , '19431' , 'PALLONCINO MAGNETE 12X15 - PM' , '1' , '-1' , '1' , '12.20' , '10' , '22' , '0' , '12.20' ) 28/07/2022 06:34:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19431' AND id_supplier = '' 28/07/2022 06:34:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19431' , '' , '1' ) 28/07/2022 06:38:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '2392' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-28') 28/07/2022 06:38:46 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' , '2392' , '2022-07-28' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.50' , '9.50' , NOW() , NOW() ) 28/07/2022 06:38:46 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 = '59839' 28/07/2022 06:38:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '59839' 28/07/2022 06:38:46 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 ( '59839' , '19622' , 'SULLA TUA PAROLA - SETT/OTT 2022' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 28/07/2022 06:38:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19622' AND id_supplier = '' 28/07/2022 06:38:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19622' , '' , '1' ) 28/07/2022 06:38:46 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 ( '59839' , '19467' , 'SULLA TUA PAROLA - LUG/AGO 2022' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 28/07/2022 06:38:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19467' AND id_supplier = '' 28/07/2022 06:38:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19467' , '' , '1' )