19/11/2022 08:26:06 am >> SELECT document_num FROM ps_document WHERE document_num = '2468' AND id_document != '59949' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-08-08') 19/11/2022 08:26:06 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2468', document_date = '2022-08-08', 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 = '45.50', price_tax_excluded = '39.64', date_upd = NOW() WHERE id_document = '59949' 19/11/2022 08:26:06 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 = '59949' 19/11/2022 08:26:06 am >> DELETE FROM ps_document_detail WHERE id_document = '59949' 19/11/2022 08:26:06 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 ( '59949' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 19/11/2022 08:26:07 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 19/11/2022 08:26:07 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 19/11/2022 08:26:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59949' , '7311' , 'OSTIA SOTTILE 74MM' , '5' , '-5' , '3' , '1.9000' , '1.8269230769231' , '4' , '0' , '9.50' ) 19/11/2022 08:26:07 am >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 19/11/2022 08:26:07 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 19/11/2022 08:26:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59949' , '8082' , 'POLO LIMITED ' , '1' , '-1' , '1' , '29.0000' , '23.770491803279' , '22' , '0' , '29.00' ) 19/11/2022 08:26:07 am >> DELETE FROM ps_product_supplier WHERE id_product = '8082' AND id_supplier = '' 19/11/2022 08:26:07 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8082' , '' , '1' ) 19/11/2022 08:26:52 am >> SELECT document_num FROM ps_document WHERE document_num = '1062' AND id_document != '54665' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-04-09') 19/11/2022 08:26:52 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1062', document_date = '2022-04-09', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.02', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '445.00', price_tax_excluded = '411.60', date_upd = NOW() WHERE id_document = '54665' 19/11/2022 08:26:52 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 = '54665' 19/11/2022 08:26:52 am >> DELETE FROM ps_document_detail WHERE id_document = '54665' 19/11/2022 08:26:52 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 ( '54665' , '7311' , 'OSTIA SOTTILE 74MM' , '14' , '-14' , '3' , '1.5000' , '1.4423076923077' , '4' , '0' , '21.00' ) 19/11/2022 08:26:52 am >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 19/11/2022 08:26:52 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 19/11/2022 08:26:52 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 ( '54665' , '11264' , 'VESTINA BATTESIMALE' , '20' , '-20' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '40.00' ) 19/11/2022 08:26:52 am >> DELETE FROM ps_product_supplier WHERE id_product = '11264' AND id_supplier = '' 19/11/2022 08:26:52 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11264' , '' , '1' ) 19/11/2022 08:26:52 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 ( '54665' , '791' , 'ASSISI IN BUSTA BATTESIMO - 20X270 - BAAS' , '20' , '-20' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '24.00' ) 19/11/2022 08:26:52 am >> DELETE FROM ps_product_supplier WHERE id_product = '791' AND id_supplier = '' 19/11/2022 08:26:52 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '791' , '' , '1' ) 19/11/2022 08:26:52 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 ( '54665' , '17160' , 'CARBONCINI ROSSI - CARRO' , '2' , '-2' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '20.00' ) 19/11/2022 08:26:52 am >> DELETE FROM ps_product_supplier WHERE id_product = '17160' AND id_supplier = '' 19/11/2022 08:26:52 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17160' , '' , '1' ) 19/11/2022 08:26:52 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 ( '54665' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '3' , '-3' , '1' , '6.5000' , '5.327868852459' , '22' , '0' , '19.50' ) 19/11/2022 08:26:52 am >> DELETE FROM ps_product_supplier WHERE id_product = '11757' AND id_supplier = '' 19/11/2022 08:26:52 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11757' , '' , '1' ) 19/11/2022 08:26:52 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 ( '54665' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '14' , '-14' , '3' , '2.8' , '2.6923076923077' , '4' , '0' , '39.20' ) 19/11/2022 08:26:52 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 19/11/2022 08:26:52 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 19/11/2022 08:26:52 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 ( '54665' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '25' , '-25' , '1' , '0.2000' , '0.16393442622951' , '22' , '0' , '5.00' ) 19/11/2022 08:26:52 am >> DELETE FROM ps_product_supplier WHERE id_product = '18617' AND id_supplier = '' 19/11/2022 08:26:52 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18617' , '' , '1' ) 19/11/2022 08:26:52 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 ( '54665' , '17940' , 'MIRACOLOSA - ISONZO 152bis' , '1' , '-1' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '3.50' ) 19/11/2022 08:26:52 am >> DELETE FROM ps_product_supplier WHERE id_product = '17940' AND id_supplier = '' 19/11/2022 08:26:52 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17940' , '' , '1' ) 19/11/2022 08:26:52 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 ( '54665' , '7096' , 'NOVE PRIMI VENERDÍ DEL MESE - 8247' , '30' , '-30' , '4' , '2.0000' , '2' , '0' , '5' , '57.00' ) 19/11/2022 08:26:52 am >> DELETE FROM ps_product_supplier WHERE id_product = '7096' AND id_supplier = '' 19/11/2022 08:26:52 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7096' , '' , '1' ) 19/11/2022 08:26:52 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 ( '54665' , '8247' , 'PREGATE, PREGATE, PREGATE - 8100' , '1' , '-1' , '4' , '7.0000' , '7' , '0' , '5' , '6.65' ) 19/11/2022 08:26:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '8247' AND id_supplier = '' 19/11/2022 08:26:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8247' , '' , '1' ) 19/11/2022 08:26:53 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 ( '54665' , '15020' , 'PREGARE OGNI GIORNO' , '4' , '-4' , '4' , '0.6000' , '0.6' , '0' , '0' , '2.40' ) 19/11/2022 08:26:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '15020' AND id_supplier = '' 19/11/2022 08:26:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15020' , '' , '1' ) 19/11/2022 08:26:53 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 ( '54665' , '9333' , 'SACRO CUORE DI GESÙ - 208 ' , '1' , '-1' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '3.50' ) 19/11/2022 08:26:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '9333' AND id_supplier = '' 19/11/2022 08:26:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9333' , '' , '1' ) 19/11/2022 08:26:53 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 ( '54665' , '8247' , 'PREGATE, PREGATE, PREGATE - 8100' , '1' , '-1' , '4' , '7.0000' , '7' , '0' , '5' , '6.65' ) 19/11/2022 08:26:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '8247' AND id_supplier = '' 19/11/2022 08:26:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8247' , '' , '1' ) 19/11/2022 08:26:53 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 ( '54665' , '4372' , 'GESÙ BAMBINO - 265 ' , '1' , '-1' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '3.50' ) 19/11/2022 08:26:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '4372' AND id_supplier = '' 19/11/2022 08:26:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4372' , '' , '1' ) 19/11/2022 08:26:53 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 ( '54665' , '6872' , 'NASCITA DI GESÙ BAMBINO - 189' , '1' , '-1' , '1' , '3.6000' , '2.9508196721311' , '22' , '0' , '3.60' ) 19/11/2022 08:26:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '6872' AND id_supplier = '' 19/11/2022 08:26:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6872' , '' , '1' ) 19/11/2022 08:26:53 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 ( '54665' , '17329' , 'MESSALE ROMANO DALTARE N.E' , '1' , '-1' , '4' , '110.0000' , '110' , '0' , '5' , '104.50' ) 19/11/2022 08:26:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '17329' AND id_supplier = '' 19/11/2022 08:26:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17329' , '' , '1' ) 19/11/2022 08:26:53 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 ( '54665' , '16464' , 'CLERGY BLU NIDO DAPE ML 43 - C22' , '1' , '-1' , '1' , '45.0000' , '36.885245901639' , '22' , '0' , '45.00' ) 19/11/2022 08:26:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '16464' AND id_supplier = '' 19/11/2022 08:26:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16464' , '' , '1' ) 19/11/2022 08:26:53 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 ( '54665' , '9253' , 'SACRA BIBBIA CEI - UELCI' , '1' , '-1' , '4' , '18.5000' , '18.5' , '0' , '5' , '17.58' ) 19/11/2022 08:26:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '9253' AND id_supplier = '' 19/11/2022 08:26:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9253' , '' , '1' ) 19/11/2022 08:26:53 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 ( '54665' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '8' , '-8' , '3' , '2.8000' , '2.6923076923077' , '4' , '0' , '22.40' ) 19/11/2022 08:26:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 19/11/2022 08:26:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 19/11/2022 09:17:16 am >> SELECT document_num FROM ps_document WHERE document_num = '3412' AND id_document != '71508' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-10') 19/11/2022 09:17:16 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3412', document_date = '2022-11-10', 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 = '173.00', price_tax_excluded = '141.80', date_upd = NOW() WHERE id_document = '71508' 19/11/2022 09:17: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 = '71508' 19/11/2022 09:17:16 am >> DELETE FROM ps_document_detail WHERE id_document = '71508' 19/11/2022 09:17: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 ( '71508' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '10' , '8.1967213114754' , '22' , '0' , '10.00' ) 19/11/2022 09:17:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 19/11/2022 09:17:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 19/11/2022 09:17: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 ( '71508' , '17858' , 'LAMPADA IHS - 096DP1K' , '2' , '-2' , '1' , '40.0000' , '32.786885245902' , '22' , '0' , '80.00' ) 19/11/2022 09:17:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '17858' AND id_supplier = '' 19/11/2022 09:17:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17858' , '' , '1' ) 19/11/2022 09:17: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 ( '71508' , '1628' , 'CANDELIERE DELLAVVENTO 4 SETT + 1 - OGGETTI' , '1' , '-1' , '1' , '75.0000' , '61.475409836066' , '22' , '0' , '75.00' ) 19/11/2022 09:17:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '1628' AND id_supplier = '' 19/11/2022 09:17:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1628' , '' , '1' ) 19/11/2022 09:17: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 ( '71508' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '40' , '-40' , '1' , '0.20' , '0.16393442622951' , '22' , '0' , '8.00' ) 19/11/2022 09:17:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '18617' AND id_supplier = '' 19/11/2022 09:17:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18617' , '' , '1' ) 19/11/2022 09:48:31 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 19/11/2022 09:48:31 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20428' , '1' , '' , 'nuovo-prodotto' ) 19/11/2022 09:48:31 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '20428' , '1' , '1' , '2' , NOW() , NOW() ) 19/11/2022 09:48:31 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '20428' , '0' , '1' , '0' , '0' ) 19/11/2022 09:52:06 am >> SELECT ean13 FROM ps_product WHERE ean13 = '000372' AND id_product != '20428' AND ean13 != '' 19/11/2022 09:52:06 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '000372', date_upd = NOW() WHERE id_product = '20428' 19/11/2022 09:52:06 am >> UPDATE ps_product_lang SET name = 'OSTIA TAGLIO CHIUSO 72MM - OTC25', description = '' WHERE id_product = '20428' 19/11/2022 09:52:06 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '1.923076923076923' WHERE id_product = '20428' 19/11/2022 09:52:06 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '1.923076923076923', id_tax_rules_group = '3', id_category_default = '342', 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 = '20428' 19/11/2022 09:52:06 am >> DELETE FROM ps_specific_price WHERE id_product = '20428' 19/11/2022 09:52:09 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 = '20428' 19/11/2022 09:52:09 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20429' , '1' , '' , 'nuovo-prodotto' ) 19/11/2022 09:52:09 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 '20429' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20428' 19/11/2022 09:52:09 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20429' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20428' 19/11/2022 09:53:11 am >> SELECT ean13 FROM ps_product WHERE ean13 = '000373' AND id_product != '20429' AND ean13 != '' 19/11/2022 09:53:11 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '000373', date_upd = NOW() WHERE id_product = '20429' 19/11/2022 09:53:11 am >> UPDATE ps_product_lang SET name = 'OSTIA SENZA TOSTATURA MORREALE - OS25', description = '' WHERE id_product = '20429' 19/11/2022 09:53:11 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '1.923076923076923' WHERE id_product = '20429' 19/11/2022 09:53:11 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '1.923076923076923', id_tax_rules_group = '3', id_category_default = '342', 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 = '20429' 19/11/2022 09:53:11 am >> DELETE FROM ps_specific_price WHERE id_product = '20429' 19/11/2022 09:53:22 am >> SELECT ean13 FROM ps_product WHERE ean13 = '000373' AND id_product != '20429' AND ean13 != '' 19/11/2022 09:53:22 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '000373', date_upd = NOW() WHERE id_product = '20429' 19/11/2022 09:53:22 am >> UPDATE ps_product_lang SET name = 'OSTIA SENZA TOSTATURA MORREALE - OS25', description = '' WHERE id_product = '20429' 19/11/2022 09:53:22 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '1.923076923076923' WHERE id_product = '20429' 19/11/2022 09:53:22 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '1.923076923076923', id_tax_rules_group = '3', id_category_default = '342', 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 = '20429' 19/11/2022 09:53:22 am >> DELETE FROM ps_specific_price WHERE id_product = '20429' 19/11/2022 09:53:23 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 = '20429' 19/11/2022 09:53:23 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20430' , '1' , '' , 'nuovo-prodotto' ) 19/11/2022 09:53:23 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 '20430' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20429' 19/11/2022 09:53:23 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20430' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20429' 19/11/2022 09:55:28 am >> SELECT ean13 FROM ps_product WHERE ean13 = '000374' AND id_product != '20430' AND ean13 != '' 19/11/2022 09:55:28 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '000374', date_upd = NOW() WHERE id_product = '20430' 19/11/2022 09:55:28 am >> UPDATE ps_product_lang SET name = 'PARTICOLE PAN DI CENA SOTTILE MORREALE- PTC38S', description = '' WHERE id_product = '20430' 19/11/2022 09:55:28 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3.3653846153846154' WHERE id_product = '20430' 19/11/2022 09:55:28 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3.3653846153846154', id_tax_rules_group = '3', id_category_default = '342', 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 = '20430' 19/11/2022 09:55:28 am >> DELETE FROM ps_specific_price WHERE id_product = '20430' 19/11/2022 09:55:32 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 = '20430' 19/11/2022 09:55:32 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20431' , '1' , '' , 'nuovo-prodotto' ) 19/11/2022 09:55:32 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 '20431' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20430' 19/11/2022 09:55:32 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20431' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20430' 19/11/2022 09:56:29 am >> SELECT ean13 FROM ps_product WHERE ean13 = '000375' AND id_product != '20431' AND ean13 != '' 19/11/2022 09:56:29 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '000375', date_upd = NOW() WHERE id_product = '20431' 19/11/2022 09:56:29 am >> UPDATE ps_product_lang SET name = 'PARTICOLA TAGLIO CHIUSO 35MM - W500', description = '' WHERE id_product = '20431' 19/11/2022 09:56:29 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3.173076923076923' WHERE id_product = '20431' 19/11/2022 09:56:29 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3.173076923076923', id_tax_rules_group = '3', id_category_default = '342', 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 = '20431' 19/11/2022 09:56:29 am >> DELETE FROM ps_specific_price WHERE id_product = '20431' 19/11/2022 09:56:32 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 = '20431' 19/11/2022 09:56:32 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20432' , '1' , '' , 'nuovo-prodotto' ) 19/11/2022 09:56:32 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 '20432' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20431' 19/11/2022 09:56:32 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20432' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20431' 19/11/2022 09:57:56 am >> SELECT ean13 FROM ps_product WHERE ean13 = '000376' AND id_product != '20432' AND ean13 != '' 19/11/2022 09:57:56 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '000376', date_upd = NOW() WHERE id_product = '20432' 19/11/2022 09:57:56 am >> UPDATE ps_product_lang SET name = 'PARTICOLA 2MM - P2M250', description = '' WHERE id_product = '20432' 19/11/2022 09:57:56 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '4.326923076923077' WHERE id_product = '20432' 19/11/2022 09:57:56 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '4.326923076923077', id_tax_rules_group = '3', id_category_default = '342', 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 = '20432' 19/11/2022 09:57:56 am >> DELETE FROM ps_specific_price WHERE id_product = '20432' 19/11/2022 09:57:57 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 = '20432' 19/11/2022 09:57:57 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20433' , '1' , '' , 'nuovo-prodotto' ) 19/11/2022 09:57:57 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 '20433' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20432' 19/11/2022 09:57:57 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20433' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20432' 19/11/2022 09:59:26 am >> SELECT ean13 FROM ps_product WHERE ean13 = '000377' AND id_product != '20433' AND ean13 != '' 19/11/2022 09:59:26 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '000377', date_upd = NOW() WHERE id_product = '20433' 19/11/2022 09:59:26 am >> UPDATE ps_product_lang SET name = 'PARTICOLA SENZA TOSTATURA MORREALE 38MM - PTC38S', description = '' WHERE id_product = '20433' 19/11/2022 09:59:27 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3.3653846153846154' WHERE id_product = '20433' 19/11/2022 09:59:27 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3.3653846153846154', id_tax_rules_group = '3', id_category_default = '342', 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 = '20433' 19/11/2022 09:59:27 am >> DELETE FROM ps_specific_price WHERE id_product = '20433' 19/11/2022 10:01:05 am >> SELECT document_num FROM ps_document WHERE document_num = '3519' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-19') 19/11/2022 10:01:05 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' , '3519' , '2022-11-19' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '41.00' , '41.00' , NOW() , NOW() ) 19/11/2022 10:01:05 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 = '73721' 19/11/2022 10:01:05 am >> DELETE FROM ps_document_detail WHERE id_document = '73721' 19/11/2022 10:01:05 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 ( '73721' , '5823' , 'LIBRO DORO' , '10' , '-10' , '4' , '0.60' , '0.6' , '0' , '0' , '6.00' ) 19/11/2022 10:01:05 am >> DELETE FROM ps_product_supplier WHERE id_product = '5823' AND id_supplier = '' 19/11/2022 10:01:05 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5823' , '' , '1' ) 19/11/2022 10:01:05 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 ( '73721' , '4494' , 'GESÙ RESTA CON NOI 3 - GUIDA' , '2' , '-2' , '4' , '8.5' , '8.5' , '0' , '0' , '17.00' ) 19/11/2022 10:01:05 am >> DELETE FROM ps_product_supplier WHERE id_product = '4494' AND id_supplier = '' 19/11/2022 10:01:05 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4494' , '' , '1' ) 19/11/2022 10:01:05 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 ( '73721' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '6' , '-6' , '4' , '3' , '3' , '0' , '0' , '18.00' ) 19/11/2022 10:01:05 am >> DELETE FROM ps_product_supplier WHERE id_product = '4397' AND id_supplier = '' 19/11/2022 10:01:05 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4397' , '' , '1' ) 19/11/2022 10:11:11 am >> SELECT ean13 FROM ps_product WHERE ean13 = '000377' AND id_product != '20433' AND ean13 != '' 19/11/2022 10:11:11 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '000377', date_upd = NOW() WHERE id_product = '20433' 19/11/2022 10:11:11 am >> UPDATE ps_product_lang SET name = 'PARTICOLA SENZA TOSTATURA MORREALE 38MM - PTC38S', description = '' WHERE id_product = '20433' 19/11/2022 10:11:11 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3.3653846153846154' WHERE id_product = '20433' 19/11/2022 10:11:11 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3.3653846153846154', id_tax_rules_group = '3', id_category_default = '342', 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 = '20433' 19/11/2022 10:11:11 am >> DELETE FROM ps_specific_price WHERE id_product = '20433' 19/11/2022 10:11: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 = '20433' 19/11/2022 10:11:12 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20434' , '1' , '' , 'nuovo-prodotto' ) 19/11/2022 10:11: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 '20434' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20433' 19/11/2022 10:11:12 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20434' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20433' 19/11/2022 10:13:50 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '3441/22' , '2022-11-09' , '22' , '0' , '22' , '2617' , 'C.DA GIOPPO, 11 89040 CIRELLA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '1587.66' , '1526.60' , NOW() , NOW() ) 19/11/2022 10:13:50 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 = '73722' 19/11/2022 10:13:50 am >> DELETE FROM ps_document_detail WHERE id_document = '73722' 19/11/2022 10:13:50 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 ( '73722' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '140' , '140' , '3' , '1.8' , '1.7307692307692' , '4' , '0' , '262.0800' ) 19/11/2022 10:13:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '22' 19/11/2022 10:13:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '22' , '1' ) 19/11/2022 10:13:51 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 ( '73722' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '100' , '100' , '3' , '1.7' , '1.6346153846154' , '4' , '0' , '176.8000' ) 19/11/2022 10:13:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '16691' AND id_supplier = '22' 19/11/2022 10:13:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16691' , '22' , '1' ) 19/11/2022 10:13:51 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 ( '73722' , '20431' , 'PARTICOLA TAGLIO CHIUSO 35MM - W500' , '200' , '200' , '3' , '1.95' , '1.875' , '4' , '3' , '393.4320' ) 19/11/2022 10:13:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '20431' AND id_supplier = '22' 19/11/2022 10:13:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20431' , '22' , '1' ) 19/11/2022 10:13:51 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 ( '73722' , '20430' , 'PARTICOLE PAN DI CENA SOTTILE MORREALE- PTC38S' , '85' , '85' , '3' , '2.1' , '2.0192307692308' , '4' , '3' , '180.0708' ) 19/11/2022 10:13:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '20430' AND id_supplier = '22' 19/11/2022 10:13:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20430' , '22' , '1' ) 19/11/2022 10:13:51 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 ( '73722' , '20429' , 'OSTIA SENZA TOSTATURA MORREALE - OS25' , '285' , '285' , '3' , '1.05' , '1.0096153846154' , '4' , '3' , '301.8834' ) 19/11/2022 10:13:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '20429' AND id_supplier = '22' 19/11/2022 10:13:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20429' , '22' , '1' ) 19/11/2022 10:13:51 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 ( '73722' , '20432' , 'PARTICOLA 2MM - P2M250' , '6' , '6' , '3' , '1.99' , '1.9134615384615' , '4' , '0' , '12.4176' ) 19/11/2022 10:13:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '20432' AND id_supplier = '22' 19/11/2022 10:13:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20432' , '22' , '1' ) 19/11/2022 10:13:51 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 ( '73722' , '20428' , 'OSTIA TAGLIO CHIUSO 72MM - OTC25' , '50' , '50' , '3' , '1.1' , '1.0576923076923' , '4' , '3' , '55.4840' ) 19/11/2022 10:13:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '20428' AND id_supplier = '22' 19/11/2022 10:13:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20428' , '22' , '1' ) 19/11/2022 10:13:51 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 ( '73722' , '20433' , 'PARTICOLA SENZA TOSTATURA MORREALE 38MM - PTC38S' , '97' , '97' , '3' , '2.1' , '2.0192307692308' , '4' , '3' , '205.4926' ) 19/11/2022 10:13:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '20433' AND id_supplier = '22' 19/11/2022 10:13:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20433' , '22' , '1' ) 19/11/2022 10:39:40 am >> SELECT document_num FROM ps_document WHERE document_num = '3520' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-19') 19/11/2022 10:39: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' , '3520' , '2022-11-19' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '18.00' , '18.00' , NOW() , NOW() ) 19/11/2022 10:39: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 = '73723' 19/11/2022 10:39:40 am >> DELETE FROM ps_document_detail WHERE id_document = '73723' 19/11/2022 10:39: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 ( '73723' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '18' , '18' , '0' , '0' , '18.00' ) 19/11/2022 10:39:40 am >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 19/11/2022 10:39:40 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 19/11/2022 10:47:22 am >> DELETE FROM ps_product WHERE id_product = '20430' 19/11/2022 10:47:22 am >> DELETE FROM ps_product_shop WHERE id_product = '20430' 19/11/2022 10:47:22 am >> DELETE FROM ps_product_lang WHERE id_product = '20430' 19/11/2022 10:47:22 am >> DELETE FROM ps_stock_available WHERE id_product = '20430' 19/11/2022 10:48:28 am >> UPDATE ps_document SET id_document_type = '31', document_num = '3441/22', document_date = '2022-11-09', document_letter = '22', id_customer = '0', id_supplier = '', id_address = '2617', address1 = 'C.DA GIOPPO, 11 89040 CIRELLA', address2 = '', note = '', price_shipping = '0.01', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '9', id_causal = '0', price_tax_included = '1587.66', price_tax_excluded = '1526.60', date_upd = NOW() WHERE id_document = '73722' 19/11/2022 10:48: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 = '73722' 19/11/2022 10:48:28 am >> DELETE FROM ps_document_detail WHERE id_document = '73722' 19/11/2022 10:48: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 ( '73722' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '140' , '140' , '3' , '1.8000' , '1.7307692307692' , '4' , '0' , '262.08' ) 19/11/2022 10:48:28 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 19/11/2022 10:48:28 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 19/11/2022 10:48: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 ( '73722' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '100' , '100' , '3' , '1.7000' , '1.6346153846154' , '4' , '0' , '176.80' ) 19/11/2022 10:48:28 am >> DELETE FROM ps_product_supplier WHERE id_product = '16691' AND id_supplier = '' 19/11/2022 10:48:28 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16691' , '' , '1' ) 19/11/2022 10:48: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 ( '73722' , '20431' , 'PARTICOLA TAGLIO CHIUSO 35MM - W500' , '200' , '200' , '3' , '1.9500' , '1.875' , '4' , '3' , '393.43' ) 19/11/2022 10:48:28 am >> DELETE FROM ps_product_supplier WHERE id_product = '20431' AND id_supplier = '' 19/11/2022 10:48:28 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20431' , '' , '1' ) 19/11/2022 10:48: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 ( '73722' , '20429' , 'OSTIA SENZA TOSTATURA MORREALE - OS25' , '285' , '285' , '3' , '1.0500' , '1.0096153846154' , '4' , '3' , '301.88' ) 19/11/2022 10:48:28 am >> DELETE FROM ps_product_supplier WHERE id_product = '20429' AND id_supplier = '' 19/11/2022 10:48:28 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20429' , '' , '1' ) 19/11/2022 10:48: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 ( '73722' , '20432' , 'PARTICOLA 2MM - P2M250' , '6' , '6' , '3' , '1.9900' , '1.9134615384615' , '4' , '0' , '12.42' ) 19/11/2022 10:48:28 am >> DELETE FROM ps_product_supplier WHERE id_product = '20432' AND id_supplier = '' 19/11/2022 10:48:28 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20432' , '' , '1' ) 19/11/2022 10:48: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 ( '73722' , '20428' , 'OSTIA TAGLIO CHIUSO 72MM - OTC25' , '50' , '50' , '3' , '1.1000' , '1.0576923076923' , '4' , '3' , '55.48' ) 19/11/2022 10:48:28 am >> DELETE FROM ps_product_supplier WHERE id_product = '20428' AND id_supplier = '' 19/11/2022 10:48:28 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20428' , '' , '1' ) 19/11/2022 10:48: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 ( '73722' , '20433' , 'PARTICOLA SENZA TOSTATURA MORREALE 38MM - PTC38S' , '182' , '182' , '3' , '2.1000' , '2.0192307692308' , '4' , '3' , '385.5634' ) 19/11/2022 10:48:28 am >> DELETE FROM ps_product_supplier WHERE id_product = '20433' AND id_supplier = '' 19/11/2022 10:48:29 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20433' , '' , '1' ) 19/11/2022 10:55:03 am >> SELECT document_num FROM ps_document WHERE document_num = '3521' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-19') 19/11/2022 10:55: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' , '3521' , '2022-11-19' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.00' , '11.00' , NOW() , NOW() ) 19/11/2022 10:55: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 = '73724' 19/11/2022 10:55:03 am >> DELETE FROM ps_document_detail WHERE id_document = '73724' 19/11/2022 10:55: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 ( '73724' , '20217' , 'ASCOLTARE 2023 KIKO' , '1' , '-1' , '4' , '11.00' , '11' , '0' , '0' , '11.00' ) 19/11/2022 10:55:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '20217' AND id_supplier = '' 19/11/2022 10:55:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20217' , '' , '1' ) 19/11/2022 11:17:06 am >> SELECT document_num FROM ps_document WHERE document_num = '3522' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-19') 19/11/2022 11:17:06 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' , '3522' , '2022-11-19' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '51.65' , '45.59' , NOW() , NOW() ) 19/11/2022 11:17:06 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 = '73725' 19/11/2022 11:17:06 am >> DELETE FROM ps_document_detail WHERE id_document = '73725' 19/11/2022 11:17:06 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 ( '73725' , '9688' , 'SCAPOLARE 10X15 CUORE DI GESÙ - 2202 ' , '12' , '-12' , '1' , '2.8' , '2.2950819672131' , '22' , '0' , '33.60' ) 19/11/2022 11:17:07 am >> DELETE FROM ps_product_supplier WHERE id_product = '9688' AND id_supplier = '' 19/11/2022 11:17:07 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9688' , '' , '1' ) 19/11/2022 11:17:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73725' , '7096' , 'NOVE PRIMI VENERDÍ DEL MESE - 8247' , '7' , '-7' , '4' , '2.00' , '2' , '0' , '5' , '13.30' ) 19/11/2022 11:17:07 am >> DELETE FROM ps_product_supplier WHERE id_product = '7096' AND id_supplier = '' 19/11/2022 11:17:07 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7096' , '' , '1' ) 19/11/2022 11:17:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73725' , '18009' , 'SCALA PIU CORTA PER SALIRE IN CIELO -8011' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 19/11/2022 11:17:07 am >> DELETE FROM ps_product_supplier WHERE id_product = '18009' AND id_supplier = '' 19/11/2022 11:17:07 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18009' , '' , '1' ) 19/11/2022 11:18:35 am >> SELECT document_num FROM ps_document WHERE document_num = '3003' AND id_document != '65779' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-11') 19/11/2022 11:18:35 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3003', document_date = '2022-10-11', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '14.00', price_tax_excluded = '11.48', date_upd = NOW() WHERE id_document = '65779' 19/11/2022 11:18: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 = '65779' 19/11/2022 11:18:35 am >> DELETE FROM ps_document_detail WHERE id_document = '65779' 19/11/2022 11:18: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 ( '65779' , '9688' , 'SCAPOLARE 10X15 CUORE DI GESÙ - 2202 ' , '7' , '-7' , '1' , '2' , '1.6393442622951' , '22' , '0' , '14.00' ) 19/11/2022 11:18:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '9688' AND id_supplier = '' 19/11/2022 11:18:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9688' , '' , '1' ) 19/11/2022 11:18:53 am >> SELECT document_num FROM ps_document WHERE document_num = '2946' AND id_document != '65182' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-06') 19/11/2022 11:18:53 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2946', document_date = '2022-10-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 = '14.00', price_tax_excluded = '11.48', date_upd = NOW() WHERE id_document = '65182' 19/11/2022 11:18:53 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 = '65182' 19/11/2022 11:18:53 am >> DELETE FROM ps_document_detail WHERE id_document = '65182' 19/11/2022 11:18:53 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 ( '65182' , '9688' , 'SCAPOLARE 10X15 CUORE DI GESÙ - 2202 ' , '7' , '-7' , '1' , '2' , '1.6393442622951' , '22' , '0' , '14.00' ) 19/11/2022 11:18:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '9688' AND id_supplier = '' 19/11/2022 11:18:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9688' , '' , '1' ) 19/11/2022 11:19:37 am >> SELECT document_num FROM ps_document WHERE document_num = '3015' AND id_document != '65800' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-12') 19/11/2022 11:19:37 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3015', document_date = '2022-10-12', 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 = '154.00', price_tax_excluded = '132.81', date_upd = NOW() WHERE id_document = '65800' 19/11/2022 11:19:37 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 = '65800' 19/11/2022 11:19:37 am >> DELETE FROM ps_document_detail WHERE id_document = '65800' 19/11/2022 11:19:37 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 ( '65800' , '13049' , 'LITURGICO ART. 60LT BIANCO SUPER' , '30' , '-30' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '90.00' ) 19/11/2022 11:19:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '13049' AND id_supplier = '' 19/11/2022 11:19:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13049' , '' , '1' ) 19/11/2022 11:19: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 ( '65800' , '7311' , 'OSTIA SOTTILE 74MM' , '6' , '-6' , '3' , '1.9000' , '1.8269230769231' , '4' , '0' , '11.40' ) 19/11/2022 11:19:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 19/11/2022 11:19:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 19/11/2022 11:19: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 ( '65800' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '10' , '-10' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '35.00' ) 19/11/2022 11:19:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 19/11/2022 11:19:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 19/11/2022 11:19: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 ( '65800' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '4.1' , '3.3606557377049' , '22' , '0' , '4.10' ) 19/11/2022 11:19:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 19/11/2022 11:19:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 19/11/2022 11:19: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 ( '65800' , '9688' , 'SCAPOLARE 10X15 CUORE DI GESÙ - 2202 ' , '5' , '-5' , '1' , '2.70' , '2.2131147540984' , '22' , '0' , '13.50' ) 19/11/2022 11:19:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '9688' AND id_supplier = '' 19/11/2022 11:19:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9688' , '' , '1' ) 19/11/2022 12:08:38 pm >> SELECT document_num FROM ps_document WHERE document_num = '3523' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-19') 19/11/2022 12:08:38 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' , '3523' , '2022-11-19' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '27.00' , '22.13' , NOW() , NOW() ) 19/11/2022 12:08:38 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 = '73726' 19/11/2022 12:08:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '73726' 19/11/2022 12:08:38 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 ( '73726' , '7202' , 'ARTICOLI RELIGIOSI' , '27' , '-27' , '1' , '1' , '0.81967213114754' , '22' , '0' , '27.00' ) 19/11/2022 12:08:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 19/11/2022 12:08:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 19/11/2022 12:12:25 pm >> SELECT document_num FROM ps_document WHERE document_num = '3524' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-19') 19/11/2022 12:12:25 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' , '3524' , '2022-11-19' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '21.00' , '17.75' , NOW() , NOW() ) 19/11/2022 12:12:25 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 = '73727' 19/11/2022 12:12:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '73727' 19/11/2022 12:12:25 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 ( '73727' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '18' , '14.754098360656' , '22' , '0' , '18.00' ) 19/11/2022 12:12:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 19/11/2022 12:12:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 19/11/2022 12:12:25 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 ( '73727' , '11099' , 'VANGELO E ATTI DEGLI APOSTOLI' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '0' , '3.00' ) 19/11/2022 12:12:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11099' AND id_supplier = '' 19/11/2022 12:12:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11099' , '' , '1' ) 19/11/2022 12:26:47 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '973' 19/11/2022 12:26:47 pm >> 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 ( '973' , '10' , '130' , 'PARR. SS SALVATORE E SAN MARTINO' , 'DE ANGELIS' , 'DON FERDINANDO' , 'VIA MUNICIPIO' , '' , '83020' , 'TORCHIATI-MONTORO ' , '' , '3386849911' , '' , '' , '92009870640' , NOW() , NOW() ) 19/11/2022 12:26:47 pm >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '973' 19/11/2022 12:28:53 pm >> SELECT document_num FROM ps_document WHERE document_num = '294' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-11-19') 19/11/2022 12:28:53 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' , '294' , '2022-11-19' , '' , '973' , '0' , '4677360' , 'VIA MUNICIPIO 83020 TORCHIATI-MONTORO ' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '52.28' , '52.28' , NOW() , NOW() ) 19/11/2022 12:28:53 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 = '73728' 19/11/2022 12:28:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '73728' 19/11/2022 12:28:53 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 ( '73728' , '5446' , 'IO SONO CON VOI - GUIDA' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '15' , '6.80' ) 19/11/2022 12:28:53 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 ( '73728' , '9675' , 'SARETE MIEI TESTIMONI' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '15' , '2.98' ) 19/11/2022 12:28:53 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 ( '73728' , '5457' , 'IO SONO CON VOI 1 PARTE' , '20' , '-20' , '4' , '2.50' , '2.5' , '0' , '15' , '42.50' ) 19/11/2022 12:33:52 pm >> SELECT document_num FROM ps_document WHERE document_num = '3525' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-19') 19/11/2022 12:33:52 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' , '3525' , '2022-11-19' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.50' , '2.05' , NOW() , NOW() ) 19/11/2022 12:33:52 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 = '73729' 19/11/2022 12:33:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '73729' 19/11/2022 12:33:52 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 ( '73729' , '940' , 'BAMBINO CM 4 - FOSFORO - P1' , '1' , '-1' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '0.25' ) 19/11/2022 12:33:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '940' AND id_supplier = '' 19/11/2022 12:33:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '940' , '' , '1' ) 19/11/2022 12:33:52 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 ( '73729' , '18131' , 'TAU MEDIO CM3 - T6' , '2' , '-2' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '2.00' ) 19/11/2022 12:33:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18131' AND id_supplier = '' 19/11/2022 12:33:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18131' , '' , '1' ) 19/11/2022 12:33:52 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 ( '73729' , '939' , 'BAMBINO CM 4 - CARNE - P1' , '1' , '-1' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '0.25' ) 19/11/2022 12:33:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '939' AND id_supplier = '' 19/11/2022 12:33:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '939' , '' , '1' ) 19/11/2022 12:34:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '3526' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-19') 19/11/2022 12:34:00 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' , '3526' , '2022-11-19' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 19/11/2022 12:34:00 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 = '73730' 19/11/2022 12:34:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '73730' 19/11/2022 12:34: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 ( '73730' , '20275' , 'SULLA TUA PAROLA GEN/FEB 2023' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 19/11/2022 12:34:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20275' AND id_supplier = '' 19/11/2022 12:34:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20275' , '' , '1' ) 19/11/2022 12:37:08 pm >> SELECT document_num FROM ps_document WHERE document_num = '294' AND id_document != '73728' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-11-19') 19/11/2022 12:37:08 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '294', document_date = '2022-11-19', document_letter = '', id_customer = '973', id_supplier = '', id_address = '4677360', address1 = 'VIA MUNICIPIO 83020 TORCHIATI-MONTORO ', address2 = '', note = 'DA SALDARE', 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 = '52.28', price_tax_excluded = '52.28', date_upd = NOW() WHERE id_document = '73728' 19/11/2022 12:37:08 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '73728' 19/11/2022 12:37:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '73728' 19/11/2022 12:37:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73728' , '5446' , 'IO SONO CON VOI - GUIDA' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '15' , '6.80' ) 19/11/2022 12:37:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5446' AND id_supplier = '' 19/11/2022 12:37:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5446' , '' , '1' ) 19/11/2022 12:37:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73728' , '9675' , 'SARETE MIEI TESTIMONI' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '15' , '2.98' ) 19/11/2022 12:37:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9675' AND id_supplier = '' 19/11/2022 12:37:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9675' , '' , '1' ) 19/11/2022 12:37:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73728' , '5457' , 'IO SONO CON VOI 1 PARTE' , '20' , '-20' , '4' , '2.5000' , '2.5' , '0' , '15' , '42.50' ) 19/11/2022 12:37:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5457' AND id_supplier = '' 19/11/2022 12:37:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5457' , '' , '1' ) 19/11/2022 12:40:02 pm >> SELECT document_num FROM ps_document WHERE document_num = '82/A' AND id_document != '68029' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-10-21') 19/11/2022 12:40:02 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '82/A', document_date = '2022-10-21', document_letter = 'A', id_customer = '371', id_supplier = '', id_address = '4670910', address1 = 'VIA PIAVE, 4 84080 CASTEL SAN GIORGIO', 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 = '529.76', price_tax_excluded = '523.21', date_upd = NOW() WHERE id_document = '68029' 19/11/2022 12:40:02 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 = '68029' 19/11/2022 12:40:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '68029' 19/11/2022 12:40:02 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 ( '68029' , '16307' , 'BRACCIALE IN GOMMA DECINA' , '29' , '-29' , '1' , '0.7000' , '0.57377049180328' , '22' , '0' , '20.30' ) 19/11/2022 12:40:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16307' AND id_supplier = '' 19/11/2022 12:40:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16307' , '' , '1' ) 19/11/2022 12:40:02 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 ( '68029' , '18222' , 'ROSARIO COLORATO - R316' , '20' , '-20' , '1' , '0.7000' , '0.57377049180328' , '22' , '0' , '14.00' ) 19/11/2022 12:40:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18222' AND id_supplier = '' 19/11/2022 12:40:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18222' , '' , '1' ) 19/11/2022 12:40:02 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 ( '68029' , '13005' , 'PASSAPORTO DEL CATECHISTA' , '25' , '-25' , '4' , '1.2000' , '1.2' , '0' , '5' , '28.50' ) 19/11/2022 12:40:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13005' AND id_supplier = '' 19/11/2022 12:40:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13005' , '' , '1' ) 19/11/2022 12:40:02 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 ( '68029' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '15' , '-15' , '4' , '3.5000' , '3.5' , '0' , '15' , '44.63' ) 19/11/2022 12:40:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4397' AND id_supplier = '' 19/11/2022 12:40:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4397' , '' , '1' ) 19/11/2022 12:40:02 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 ( '68029' , '12355' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. CENA' , '40' , '-40' , '4' , '1.6000' , '1.6' , '0' , '15' , '54.40' ) 19/11/2022 12:40:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12355' AND id_supplier = '' 19/11/2022 12:40:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12355' , '' , '1' ) 19/11/2022 12:40:02 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 ( '68029' , '12819' , 'REGISTRO DEL CATECHISTA ' , '2' , '-2' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '2.00' ) 19/11/2022 12:40:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12819' AND id_supplier = '' 19/11/2022 12:40:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12819' , '' , '1' ) 19/11/2022 12:40:02 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 ( '68029' , '2679' , 'CONOSCERE GESU\'' , '30' , '-30' , '4' , '3.5000' , '3.5' , '0' , '15' , '89.25' ) 19/11/2022 12:40:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2679' AND id_supplier = '' 19/11/2022 12:40:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2679' , '' , '1' ) 19/11/2022 12:40: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 ( '68029' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '31' , '-31' , '4' , '3.5000' , '3.5' , '0' , '15' , '92.23' ) 19/11/2022 12:40:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8509' AND id_supplier = '' 19/11/2022 12:40:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8509' , '' , '1' ) 19/11/2022 12:40: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 ( '68029' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '30' , '-30' , '4' , '3.5000' , '3.5' , '0' , '15' , '89.25' ) 19/11/2022 12:40:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4394' AND id_supplier = '' 19/11/2022 12:40:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4394' , '' , '1' ) 19/11/2022 12:40: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 ( '68029' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '32' , '-32' , '4' , '3.5000' , '3.5' , '0' , '15' , '95.20' ) 19/11/2022 12:40:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4495' AND id_supplier = '' 19/11/2022 12:40:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4495' , '' , '1' )