15/03/2023 09:27:27 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 15/03/2023 09:27:27 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20843' , '1' , '' , 'nuovo-prodotto' ) 15/03/2023 09:27:27 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '20843' , '1' , '1' , '2' , NOW() , NOW() ) 15/03/2023 09:27:27 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '20843' , '0' , '1' , '0' , '0' ) 15/03/2023 09:28:58 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788878793019' AND id_product != '20843' AND ean13 != '' 15/03/2023 09:28:58 am >> UPDATE ps_product SET id_supplier = '', reference = '7/4', ean13 = '9788878793019', date_upd = NOW() WHERE id_product = '20843' 15/03/2023 09:28:58 am >> UPDATE ps_product_lang SET name = 'MESSA MEDITAZIONE - MAG/GIU 2023', description = '' WHERE id_product = '20843' 15/03/2023 09:28:58 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '8' WHERE id_product = '20843' 15/03/2023 09:28:58 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '8', id_tax_rules_group = '4', id_category_default = '271', id_argoment_default = '64', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20843' 15/03/2023 09:28:58 am >> DELETE FROM ps_specific_price WHERE id_product = '20843' 15/03/2023 09:29:46 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' , '233/23' , '2023-03-09' , '23' , '0' , '40' , '2635' , 'VIA VIRGINIA AGNELLI, 100 00151 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '12' , '0' , '43.20' , '43.20' , NOW() , NOW() ) 15/03/2023 09:29:46 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 = '82301' 15/03/2023 09:29:46 am >> DELETE FROM ps_document_detail WHERE id_document = '82301' 15/03/2023 09:29:46 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 ( '82301' , '20843' , 'MESSA MEDITAZIONE - MAG/GIU 2023' , '9' , '9' , '4' , '8.00' , '8' , '0' , '40' , '43.2000' ) 15/03/2023 09:29:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '20843' AND id_supplier = '40' 15/03/2023 09:29:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20843' , '40' , '1' ) 15/03/2023 09:47:16 am >> SELECT document_num FROM ps_document WHERE document_num = '34/A' AND id_document != '56617' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-05-05') 15/03/2023 09:47:16 am >> UPDATE ps_document SET id_document_type = '24', document_num = '34/A', document_date = '2022-05-05', document_letter = 'A', id_customer = '230', id_supplier = '', id_address = '4668969', address1 = 'VIA G. NICOTERA, 66 84080 PELLEZZANO', address2 = '', note = 'acconto: 300,00 13/10/2022 - 300,00 18/11 - 250,00 10/12 - 100,00 03/23+300 2/2/23 + 200 15/3/23', 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 = '3310.00', price_tax_excluded = '2713.11', date_upd = NOW() WHERE id_document = '56617' 15/03/2023 09:47: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 = '56617' 15/03/2023 09:47:16 am >> DELETE FROM ps_document_detail WHERE id_document = '56617' 15/03/2023 09:47: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 ( '56617' , '18788' , 'CASULA ACETATO VISCOSA - 65/020628' , '1' , '-1' , '1' , '1850.0000' , '1516.393442623' , '22' , '0' , '1850.00' ) 15/03/2023 09:47: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 ( '56617' , '0' , 'COTTA ' , '1' , '-1' , '1' , '680.0000' , '557.37704918033' , '22' , '0' , '680.00' ) 15/03/2023 09:47: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 ( '56617' , '19802' , 'CASULA CON PALLIO L-LAME\' - NUOVA PRIMAVERA - 8254C****' , '1' , '-1' , '1' , '780.0000' , '639.34426229508' , '22' , '0' , '780.00' ) 15/03/2023 09:48:27 am >> SELECT document_num FROM ps_document WHERE document_num = '54/A' AND id_document != '59768' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-07-23') 15/03/2023 09:48:27 am >> UPDATE ps_document SET id_document_type = '24', document_num = '54/A', document_date = '2022-07-23', document_letter = 'A', id_customer = '230', id_supplier = '', id_address = '4668969', address1 = 'VIA G. NICOTERA, 66 84080 PELLEZZANO', address2 = '', note = 'ACCONTO € 50,00+100 2/2/23 + 50,00 24/02 + 50,00 15/3/22', 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 = '485.00', price_tax_excluded = '485.00', date_upd = NOW() WHERE id_document = '59768' 15/03/2023 09:48: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 = '59768' 15/03/2023 09:48:27 am >> DELETE FROM ps_document_detail WHERE id_document = '59768' 15/03/2023 09:48: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 ( '59768' , '0' , 'bambino + culla terracot 450+35' , '1' , '-1' , '0' , '485.0000' , '485' , '0' , '0' , '485.00' ) 15/03/2023 09:49:03 am >> SELECT document_num FROM ps_document WHERE document_num = '34/A' AND id_document != '56617' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-05-05') 15/03/2023 09:49:03 am >> UPDATE ps_document SET id_document_type = '24', document_num = '34/A', document_date = '2022-05-05', document_letter = 'A', id_customer = '230', id_supplier = '', id_address = '4668969', address1 = 'VIA G. NICOTERA, 66 84080 PELLEZZANO', address2 = '', note = 'acconto: 300,00 13/10/2022 - 300,00 18/11 - 250,00 10/12 - 100,00 03/23+300 2/2/23 + 250 15/3/23', 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 = '3310.00', price_tax_excluded = '2713.11', date_upd = NOW() WHERE id_document = '56617' 15/03/2023 09:49: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 = '56617' 15/03/2023 09:49:03 am >> DELETE FROM ps_document_detail WHERE id_document = '56617' 15/03/2023 09:49: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 ( '56617' , '18788' , 'CASULA ACETATO VISCOSA - 65/020628' , '1' , '-1' , '1' , '1850.0000' , '1516.393442623' , '22' , '0' , '1850.00' ) 15/03/2023 09:49: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 ( '56617' , '0' , 'COTTA ' , '1' , '-1' , '1' , '680.0000' , '557.37704918033' , '22' , '0' , '680.00' ) 15/03/2023 09:49: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 ( '56617' , '19802' , 'CASULA CON PALLIO L-LAME\' - NUOVA PRIMAVERA - 8254C****' , '1' , '-1' , '1' , '780.0000' , '639.34426229508' , '22' , '0' , '780.00' ) 15/03/2023 10:02:45 am >> SELECT document_num FROM ps_document WHERE document_num = '845' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-15') 15/03/2023 10:02: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' , '845' , '2023-03-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '70.00' , '60.12' , NOW() , NOW() ) 15/03/2023 10:02: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 = '82302' 15/03/2023 10:02:45 am >> DELETE FROM ps_document_detail WHERE id_document = '82302' 15/03/2023 10:02: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 ( '82302' , '20431' , 'PARTICOLA TAGLIO CHIUSO 35MM - W500' , '2' , '-2' , '3' , '3.30' , '3.1730769230769' , '4' , '0' , '6.60' ) 15/03/2023 10:02: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 ( '82302' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 15/03/2023 10:02: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 ( '82302' , '7311' , 'OSTIA SOTTILE 74MM' , '3' , '-3' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '5.70' ) 15/03/2023 10:02: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 ( '82302' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '3' , '-3' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '22.50' ) 15/03/2023 10:02: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 ( '82302' , '7202' , 'ARTICOLI RELIGIOSI' , '3' , '-3' , '1' , '9.4' , '7.7049180327869' , '22' , '0' , '28.20' ) 15/03/2023 10:11:07 am >> SELECT document_num FROM ps_document WHERE document_num = '846' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-15') 15/03/2023 10:11:07 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '846' , '2023-03-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.70' , '4.67' , NOW() , NOW() ) 15/03/2023 10:11:07 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82303' 15/03/2023 10:11:07 am >> DELETE FROM ps_document_detail WHERE id_document = '82303' 15/03/2023 10:11: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 ( '82303' , '13357' , 'PORTACHIAVI DEVOZIONALI' , '1' , '-1' , '1' , '1.70' , '1.3934426229508' , '22' , '0' , '1.70' ) 15/03/2023 10:11: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 ( '82303' , '13103' , 'BRACCIALE BAMBOO - CY B 774' , '3' , '-3' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '3.00' ) 15/03/2023 10:11: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 ( '82303' , '1331' , 'BRACCIALE LEGNO BICOLORE - 034CYB499' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 15/03/2023 10:14:12 am >> SELECT document_num FROM ps_document WHERE document_num = '847' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-15') 15/03/2023 10:14:12 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' , '847' , '2023-03-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '36.10' , '36.10' , NOW() , NOW() ) 15/03/2023 10:14:12 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 = '82304' 15/03/2023 10:14:12 am >> DELETE FROM ps_document_detail WHERE id_document = '82304' 15/03/2023 10:14:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82304' , '1144' , 'BIBBIA DI GERUSALEMME - TELATA' , '1' , '-1' , '4' , '38.00' , '38' , '0' , '5' , '36.10' ) 15/03/2023 10:15:10 am >> SELECT document_num FROM ps_document WHERE document_num = '848' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-15') 15/03/2023 10:15:10 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' , '848' , '2023-03-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '57.95' , '57.95' , NOW() , NOW() ) 15/03/2023 10:15:10 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 = '82305' 15/03/2023 10:15:10 am >> DELETE FROM ps_document_detail WHERE id_document = '82305' 15/03/2023 10:15:10 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 ( '82305' , '17713' , 'FARSI SANTI CON CIO CHE CE - L. EPICOCO' , '1' , '-1' , '4' , '9.00' , '9' , '0' , '5' , '8.55' ) 15/03/2023 10:15:10 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 ( '82305' , '20804' , 'AFFIDABILI STORIE DI DONNE - L. M. EPICOCO' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 15/03/2023 10:15:10 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 ( '82305' , '17001' , 'SPERANZA NON E MORTA - L. EPICOCO' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 15/03/2023 10:15:10 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 ( '82305' , '20655' , 'ARTE DELLA BUONA BATTAGLIA - F. ROSINI' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '5' , '17.10' ) 15/03/2023 10:15:10 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 ( '82305' , '17852' , 'CON CUORE DI PADRE - L. EPICOCO' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 15/03/2023 10:18:41 am >> SELECT document_num FROM ps_document WHERE document_num = '849' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-15') 15/03/2023 10:18:41 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' , '849' , '2023-03-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '54.75' , '52.86' , NOW() , NOW() ) 15/03/2023 10:18:41 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 = '82306' 15/03/2023 10:18:41 am >> DELETE FROM ps_document_detail WHERE id_document = '82306' 15/03/2023 10:18:41 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 ( '82306' , '20804' , 'AFFIDABILI STORIE DI DONNE - L. M. EPICOCO' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 15/03/2023 10:18:41 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 ( '82306' , '20801' , 'PREGHIERA RESPIRO DELLANIMA - PAPA FRANCESCO' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '5' , '19.00' ) 15/03/2023 10:18:41 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 ( '82306' , '17876' , 'GIUSEPPE NON TEMERE! - M. GATTAFONI' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 15/03/2023 10:18:41 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 ( '82306' , '17853' , 'SAN GIUSEPPE, AFFIDAMENTO - A. COMASTRI' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '0' , '2.50' ) 15/03/2023 10:18:41 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 ( '82306' , '17748' , 'SEGNALIBRO - PR 349' , '30' , '-30' , '1' , '0.35' , '0.28688524590164' , '22' , '0' , '10.50' ) 15/03/2023 10:18:41 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 ( '82306' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '8.5' , '8.5' , '0' , '0' , '8.50' ) 15/03/2023 10:29:47 am >> SELECT document_num FROM ps_document WHERE document_num = '850' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-15') 15/03/2023 10:29:47 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' , '850' , '2023-03-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '190.90' , '161.55' , NOW() , NOW() ) 15/03/2023 10:29:47 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82307' 15/03/2023 10:29:47 am >> DELETE FROM ps_document_detail WHERE id_document = '82307' 15/03/2023 10:29:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82307' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 15/03/2023 10:29:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82307' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '6' , '-6' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '45.00' ) 15/03/2023 10:29:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82307' , '19147' , 'CANDELINE NON GOCCIOLANTI GRECHE' , '3' , '-3' , '1' , '17.90' , '14.672131147541' , '22' , '0' , '53.70' ) 15/03/2023 10:29:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82307' , '20431' , 'PARTICOLA TAGLIO CHIUSO 35MM - W500' , '6' , '-6' , '3' , '3.30' , '3.1730769230769' , '4' , '0' , '19.80' ) 15/03/2023 10:29:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82307' , '20429' , 'OSTIA SENZA TOSTATURA MORREALE - OS25' , '8' , '-8' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '16.00' ) 15/03/2023 10:30:10 am >> SELECT document_num FROM ps_document WHERE document_num = '851' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-15') 15/03/2023 10:30:10 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' , '851' , '2023-03-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '40.80' , '33.44' , NOW() , NOW() ) 15/03/2023 10:30:10 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 = '82308' 15/03/2023 10:30:10 am >> DELETE FROM ps_document_detail WHERE id_document = '82308' 15/03/2023 10:30:10 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 ( '82308' , '19147' , 'CANDELINE NON GOCCIOLANTI GRECHE' , '2' , '-2' , '1' , '17.90' , '14.672131147541' , '22' , '0' , '35.80' ) 15/03/2023 10:30:10 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 ( '82308' , '11654' , 'SET ADESIVO CERO PASQUALE' , '1' , '-1' , '1' , '5' , '4.0983606557377' , '22' , '0' , '5.00' ) 15/03/2023 10:43:47 am >> SELECT document_num FROM ps_document WHERE document_num = '852' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-15') 15/03/2023 10:43:48 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' , '852' , '2023-03-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.00' , '9.02' , NOW() , NOW() ) 15/03/2023 10:43:48 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 = '82309' 15/03/2023 10:43:48 am >> DELETE FROM ps_document_detail WHERE id_document = '82309' 15/03/2023 10:43:48 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 ( '82309' , '14063' , 'STELLARIO PLEX CM 10 / 12' , '1' , '-1' , '1' , '11.00' , '9.016393442623' , '22' , '0' , '11.00' ) 15/03/2023 10:54:43 am >> SELECT document_num FROM ps_document WHERE document_num = '853' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-15') 15/03/2023 10:54:43 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' , '853' , '2023-03-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '30.00' , '24.59' , NOW() , NOW() ) 15/03/2023 10:54:43 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 = '82310' 15/03/2023 10:54:43 am >> DELETE FROM ps_document_detail WHERE id_document = '82310' 15/03/2023 10:54:43 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 ( '82310' , '16058' , 'MEDAGLIA S. GIUSEPPE - FM022' , '100' , '-100' , '1' , '0.30' , '0.24590163934426' , '22' , '0' , '30.00' ) 15/03/2023 11:14:14 am >> SELECT document_num FROM ps_document WHERE document_num = '854' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-15') 15/03/2023 11:14: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' , '854' , '2023-03-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.60' , '14.43' , NOW() , NOW() ) 15/03/2023 11:14: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 = '82311' 15/03/2023 11:14:14 am >> DELETE FROM ps_document_detail WHERE id_document = '82311' 15/03/2023 11:14: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 ( '82311' , '20028' , 'CANDELA ALTARE 26X350' , '1' , '-1' , '1' , '2.40' , '1.9672131147541' , '22' , '0' , '2.40' ) 15/03/2023 11:14: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 ( '82311' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '3' , '2.4590163934426' , '22' , '0' , '3.00' ) 15/03/2023 11:14: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 ( '82311' , '19431' , 'PALLONCINO MAGNETE 12X15 - PM' , '1' , '-1' , '1' , '12.20' , '10' , '22' , '0' , '12.20' ) 15/03/2023 11:22:03 am >> SELECT document_num FROM ps_document WHERE document_num = '855' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-15') 15/03/2023 11:22: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' , '855' , '2023-03-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '45.25' , '45.25' , NOW() , NOW() ) 15/03/2023 11:22: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 = '82312' 15/03/2023 11:22:03 am >> DELETE FROM ps_document_detail WHERE id_document = '82312' 15/03/2023 11:22: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 ( '82312' , '20769' , 'SULLA STRADA DELLAMORE - V. ROSSI' , '25' , '-25' , '4' , '1.90' , '1.9' , '0' , '5' , '45.25' ) 15/03/2023 11:22:43 am >> SELECT document_num FROM ps_document WHERE document_num = '856' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-15') 15/03/2023 11:22:43 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' , '856' , '2023-03-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 15/03/2023 11:22:43 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 = '82313' 15/03/2023 11:22:43 am >> DELETE FROM ps_document_detail WHERE id_document = '82313' 15/03/2023 11:22:43 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 ( '82313' , '20795' , 'SULLA TUA PAROLA MAG GIU 2023 - 516' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 15/03/2023 12:20:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '650' AND id_document != '82043' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-27') 15/03/2023 12:20:09 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '650', document_date = '2023-02-27', 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 = '179.67', price_tax_excluded = '152.10', date_upd = NOW() WHERE id_document = '82043' 15/03/2023 12:20:09 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82043' 15/03/2023 12:20:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '82043' 15/03/2023 12:20:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82043' , '20762' , 'ABBIAMO VISTO IL SIGNORE - CD' , '1' , '-1' , '1' , '15.0000' , '12.295081967213' , '22' , '5' , '14.25' ) 15/03/2023 12:20:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82043' , '20763' , 'ABBIAMO VISTO IL SIGNORE - SPARTITO' , '1' , '-1' , '3' , '18.0000' , '17.307692307692' , '4' , '5' , '17.10' ) 15/03/2023 12:20:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82043' , '16094' , 'CON GESU SULLA VIA DELLA CROCE - VIA CRUCIS' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '0' , '2.00' ) 15/03/2023 12:20:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82043' , '20769' , 'SULLA STRADA DELLAMORE - V. ROSSI' , '1' , '-1' , '4' , '1.9000' , '1.9' , '0' , '5' , '1.81' ) 15/03/2023 12:20:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82043' , '20747' , 'VIA CRUCIS PER I PICCOLI' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '5' , '3.33' ) 15/03/2023 12:20:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82043' , '20748' , 'VERSO LA PASQUA' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '5' , '3.33' ) 15/03/2023 12:20:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82043' , '19376' , 'INCONTRARE IL CROCIFISSO - T. HALIK' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 15/03/2023 12:20:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82043' , '20228' , 'BAMBINELLO IN GESSO CM 30 STILE ANTICO - J202/30' , '1' , '-1' , '1' , '135' , '110.65573770492' , '22' , '0' , '135.00' ) 15/03/2023 12:26:31 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 15/03/2023 12:26:31 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20844' , '1' , '' , 'nuovo-prodotto' ) 15/03/2023 12:26:31 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '20844' , '1' , '1' , '2' , NOW() , NOW() ) 15/03/2023 12:26:31 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '20844' , '0' , '1' , '0' , '0' ) 15/03/2023 12:28:01 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791280546456' AND id_product != '20844' AND ean13 != '' 15/03/2023 12:28:01 pm >> UPDATE ps_product SET id_supplier = '', reference = '7/6', ean13 = '9791280546456', date_upd = NOW() WHERE id_product = '20844' 15/03/2023 12:28:01 pm >> UPDATE ps_product_lang SET name = 'SE LO DICE GESU\' - G. AGAGLIATI', description = '' WHERE id_product = '20844' 15/03/2023 12:28:01 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '10' WHERE id_product = '20844' 15/03/2023 12:28:01 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '10', id_tax_rules_group = '4', id_category_default = '483', 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 = '20844' 15/03/2023 12:28:01 pm >> DELETE FROM ps_specific_price WHERE id_product = '20844' 15/03/2023 12:28:25 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 = '20844' 15/03/2023 12:28:25 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20845' , '1' , '' , 'nuovo-prodotto' ) 15/03/2023 12:28:25 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 '20845' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20844' 15/03/2023 12:28:25 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20845' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20844' 15/03/2023 12:29:01 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831514699' AND id_product != '20845' AND ean13 != '' 15/03/2023 12:29:01 pm >> UPDATE ps_product SET id_supplier = '', reference = '14', ean13 = '9788831514699', date_upd = NOW() WHERE id_product = '20845' 15/03/2023 12:29:01 pm >> UPDATE ps_product_lang SET name = 'CRISTIANESIMO E LE RELIGIONI', description = '' WHERE id_product = '20845' 15/03/2023 12:29:01 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3' WHERE id_product = '20845' 15/03/2023 12:29:02 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3', id_tax_rules_group = '4', id_category_default = '27', id_argoment_default = '69', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20845' 15/03/2023 12:29:02 pm >> DELETE FROM ps_specific_price WHERE id_product = '20845' 15/03/2023 12:29:43 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 = '20845' 15/03/2023 12:29:43 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20846' , '1' , '' , 'nuovo-prodotto' ) 15/03/2023 12:29:43 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 '20846' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20845' 15/03/2023 12:29:43 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20846' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20845' 15/03/2023 12:30:09 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831505376' AND id_product != '20846' AND ean13 != '' 15/03/2023 12:30:09 pm >> UPDATE ps_product SET id_supplier = '', reference = '14', ean13 = '9788831505376', date_upd = NOW() WHERE id_product = '20846' 15/03/2023 12:30:09 pm >> UPDATE ps_product_lang SET name = 'REDEMPTOR HOMINIS', description = '' WHERE id_product = '20846' 15/03/2023 12:30:10 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3.5' WHERE id_product = '20846' 15/03/2023 12:30:10 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3.5', id_tax_rules_group = '4', id_category_default = '27', id_argoment_default = '69', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20846' 15/03/2023 12:30:10 pm >> DELETE FROM ps_specific_price WHERE id_product = '20846' 15/03/2023 12:31:17 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 = '20846' 15/03/2023 12:31:17 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20847' , '1' , '' , 'nuovo-prodotto' ) 15/03/2023 12:31:17 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 '20847' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20846' 15/03/2023 12:31:17 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20847' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20846' 15/03/2023 12:32:33 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831288347' AND id_product != '20847' AND ean13 != '' 15/03/2023 12:32:33 pm >> UPDATE ps_product SET id_supplier = '', reference = '13/6', ean13 = '9788831288347', date_upd = NOW() WHERE id_product = '20847' 15/03/2023 12:32:33 pm >> UPDATE ps_product_lang SET name = 'STUPORE DI ESISTERE - C. MOLARI', description = '' WHERE id_product = '20847' 15/03/2023 12:32:33 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '10' WHERE id_product = '20847' 15/03/2023 12:32:33 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '10', id_tax_rules_group = '4', id_category_default = '428', id_argoment_default = '65', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20847' 15/03/2023 12:32:33 pm >> DELETE FROM ps_specific_price WHERE id_product = '20847' 15/03/2023 12:32: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 ( '33' , '625889' , '2023-03-14' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '2.74' , '4' , '0' , '0' , '0' , '' , '11' , '0' , '95.17' , '95.17' , NOW() , NOW() ) 15/03/2023 12:32: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 = '82314' 15/03/2023 12:32:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '82314' 15/03/2023 12:32: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 ( '82314' , '20844' , 'SE LO DICE GESU - G. AGAGLIATI' , '1' , '1' , '4' , '10.00' , '10' , '0' , '30' , '7.0000' ) 15/03/2023 12:32:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20844' AND id_supplier = '7' 15/03/2023 12:32:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20844' , '7' , '1' ) 15/03/2023 12:32: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 ( '82314' , '20845' , 'CRISTIANESIMO E LE RELIGIONI' , '1' , '1' , '4' , '3.00' , '3' , '0' , '33' , '2.0100' ) 15/03/2023 12:32:59 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20845' AND id_supplier = '7' 15/03/2023 12:32:59 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20845' , '7' , '1' ) 15/03/2023 12:32: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 ( '82314' , '20801' , 'PREGHIERA RESPIRO DELLANIMA - PAPA FRANCESCO' , '2' , '2' , '4' , '20.00' , '20' , '0' , '33' , '26.8000' ) 15/03/2023 12:32:59 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20801' AND id_supplier = '7' 15/03/2023 12:32:59 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20801' , '7' , '1' ) 15/03/2023 12:32: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 ( '82314' , '6004' , 'LUMEN FIDEI ' , '1' , '1' , '4' , '2.20' , '2.2' , '0' , '33' , '1.4740' ) 15/03/2023 12:32:59 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6004' AND id_supplier = '7' 15/03/2023 12:32:59 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6004' , '7' , '1' ) 15/03/2023 12:32: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 ( '82314' , '20846' , 'REDEMPTOR HOMINIS' , '2' , '2' , '4' , '3.50' , '3.5' , '0' , '33' , '4.6900' ) 15/03/2023 12:32:59 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20846' AND id_supplier = '7' 15/03/2023 12:32:59 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20846' , '7' , '1' ) 15/03/2023 12:32: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 ( '82314' , '20817' , 'FACCIA A FACCIA CON GESU - D. RUOTOLO' , '1' , '1' , '4' , '16.00' , '16' , '0' , '30' , '11.2000' ) 15/03/2023 12:32:59 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20817' AND id_supplier = '7' 15/03/2023 12:32:59 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20817' , '7' , '1' ) 15/03/2023 12:32: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 ( '82314' , '20527' , 'AMEN - APR 23' , '1' , '1' , '4' , '3.90' , '3.9' , '0' , '33' , '2.6130' ) 15/03/2023 12:32:59 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20527' AND id_supplier = '7' 15/03/2023 12:32:59 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20527' , '7' , '1' ) 15/03/2023 12:32: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 ( '82314' , '20769' , 'SULLA STRADA DELLAMORE - V. ROSSI' , '24' , '24' , '4' , '1.90' , '1.9' , '0' , '35' , '29.6400' ) 15/03/2023 12:32:59 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20769' AND id_supplier = '7' 15/03/2023 12:32:59 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20769' , '7' , '1' ) 15/03/2023 12:32: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 ( '82314' , '20769' , 'SULLA STRADA DELLAMORE - V. ROSSI' , '2' , '2' , '4' , '1.90' , '1.9' , '0' , '100' , '0.0000' ) 15/03/2023 12:32:59 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20769' AND id_supplier = '7' 15/03/2023 12:32:59 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20769' , '7' , '1' ) 15/03/2023 12:32: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 ( '82314' , '20847' , 'STUPORE DI ESISTERE - C. MOLARI' , '1' , '1' , '4' , '10.00' , '10' , '0' , '30' , '7.0000' ) 15/03/2023 12:32:59 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20847' AND id_supplier = '7' 15/03/2023 12:32:59 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20847' , '7' , '1' ) 15/03/2023 12:45:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '772' AND id_document != '82210' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-09') 15/03/2023 12:45:14 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '772', document_date = '2023-03-09', 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 = '9.00', price_tax_excluded = '7.92', date_upd = NOW() WHERE id_document = '82210' 15/03/2023 12:45:14 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 = '82210' 15/03/2023 12:45:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '82210' 15/03/2023 12:45:14 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 ( '82210' , '16190' , 'VESTINA BATTESIMALE CANDELA/FONTE' , '1' , '-1' , '1' , '6.0000' , '4.9180327868852' , '22' , '0' , '6.00' ) 15/03/2023 12:45:14 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 ( '82210' , '6663' , 'MIE PREGHIERE - 8783' , '2' , '-2' , '4' , '1.50' , '1.5' , '0' , '0' , '3.00' ) 15/03/2023 12:46:06 pm >> SELECT document_num FROM ps_document WHERE document_num = '836' AND id_document != '82291' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-14') 15/03/2023 12:46:06 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '836', document_date = '2023-03-14', 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 = '4.75', price_tax_excluded = '4.75', date_upd = NOW() WHERE id_document = '82291' 15/03/2023 12:46:07 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82291' 15/03/2023 12:46:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '82291' 15/03/2023 12:46:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82291' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '3.25' , '3.25' , '0' , '0' , '3.25' ) 15/03/2023 12:46:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82291' , '6663' , 'MIE PREGHIERE - 8783' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '0' , '1.50' ) 15/03/2023 12:46:43 pm >> DELETE FROM ps_document WHERE id_document = '82283' 15/03/2023 12:46:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '82283' 15/03/2023 12:48:12 pm >> SELECT document_num FROM ps_document WHERE document_num = '35/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-03-15') 15/03/2023 12:48:12 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '35/A' , '2023-03-15' , 'A' , '230' , '0' , '4668969' , 'VIA G. NICOTERA, 66 84080 PELLEZZANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '400.00' , '400.00' , NOW() , NOW() ) 15/03/2023 12:48:12 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82315' 15/03/2023 12:48:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '82315' 15/03/2023 12:48:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82315' , '' , 'COTTA REGALO RAIMO' , '1' , '-1' , '0' , '400' , '400' , '' , '0' , '400.00' ) 15/03/2023 02:39:32 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 15/03/2023 02:39:32 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20848' , '1' , '' , 'nuovo-prodotto' ) 15/03/2023 02:39:32 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '20848' , '1' , '1' , '2' , NOW() , NOW() ) 15/03/2023 02:39:32 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '20848' , '0' , '1' , '0' , '0' ) 15/03/2023 02:40:36 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001665' AND id_product != '20848' AND ean13 != '' 15/03/2023 02:40:36 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '001665', date_upd = NOW() WHERE id_product = '20848' 15/03/2023 02:40:36 pm >> UPDATE ps_product_lang SET name = 'CAMICE MONASTICO CON CAPPUCCIO - 21MON', description = '' WHERE id_product = '20848' 15/03/2023 02:40:36 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '184.4262295081967' WHERE id_product = '20848' 15/03/2023 02:40:36 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '184.4262295081967', id_tax_rules_group = '1', id_category_default = '432', 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 = '20848' 15/03/2023 02:40:36 pm >> DELETE FROM ps_specific_price WHERE id_product = '20848' 15/03/2023 02:40: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 = '20848' 15/03/2023 02:40:40 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20849' , '1' , '' , 'nuovo-prodotto' ) 15/03/2023 02:40: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 '20849' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20848' 15/03/2023 02:40:40 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20849' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20848' 15/03/2023 02:41:35 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001326' AND id_product != '16460' AND ean13 != '' 15/03/2023 02:41:35 pm >> UPDATE ps_product SET id_supplier = '118', reference = '', ean13 = '001326', date_upd = NOW() WHERE id_product = '16460' 15/03/2023 02:41:35 pm >> UPDATE ps_product_lang SET name = 'SERVIZIO MESSA LINO - 5 PZ 74100', description = '' WHERE id_product = '16460' 15/03/2023 02:41:35 pm >> UPDATE ps_product SET wholesale_price = '34.92', on_sale = '0', price = '77.8688524590164' WHERE id_product = '16460' 15/03/2023 02:41:35 pm >> UPDATE ps_product_shop SET wholesale_price = '34.92', price = '77.8688524590164', id_tax_rules_group = '1', id_category_default = '432', 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 = '16460' 15/03/2023 02:41:35 pm >> DELETE FROM ps_specific_price WHERE id_product = '16460' 15/03/2023 02:42:47 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001894' AND id_product != '19087' AND ean13 != '' 15/03/2023 02:42:47 pm >> UPDATE ps_product SET id_supplier = '118', reference = '', ean13 = '001894', date_upd = NOW() WHERE id_product = '19087' 15/03/2023 02:42:47 pm >> UPDATE ps_product_lang SET name = 'SERVIZIO MESSA LINO - 74101', description = '' WHERE id_product = '19087' 15/03/2023 02:42:47 pm >> UPDATE ps_product SET wholesale_price = '25.22', on_sale = '0', price = '55.73770491803279' WHERE id_product = '19087' 15/03/2023 02:42:47 pm >> UPDATE ps_product_shop SET wholesale_price = '25.22', price = '55.73770491803279', id_tax_rules_group = '1', id_category_default = '432', 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 = '19087' 15/03/2023 02:42:47 pm >> DELETE FROM ps_specific_price WHERE id_product = '19087' 15/03/2023 02:45:02 pm >> DELETE FROM ps_product WHERE id_product = '15731' 15/03/2023 02:45:02 pm >> DELETE FROM ps_product_shop WHERE id_product = '15731' 15/03/2023 02:45:02 pm >> DELETE FROM ps_product_lang WHERE id_product = '15731' 15/03/2023 02:45:02 pm >> DELETE FROM ps_stock_available WHERE id_product = '15731' 15/03/2023 02:45:33 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001576' AND id_product != '17352' AND ean13 != '' 15/03/2023 02:45:33 pm >> UPDATE ps_product SET id_supplier = '118', reference = '', ean13 = '001576', date_upd = NOW() WHERE id_product = '17352' 15/03/2023 02:45:33 pm >> UPDATE ps_product_lang SET name = 'STOLA MARIANA MISTO SETA- 1021 AM', description = '' WHERE id_product = '17352' 15/03/2023 02:45:33 pm >> UPDATE ps_product SET wholesale_price = '52.38', on_sale = '0', price = '121.31147540983606' WHERE id_product = '17352' 15/03/2023 02:45:33 pm >> UPDATE ps_product_shop SET wholesale_price = '52.38', price = '121.31147540983606', id_tax_rules_group = '1', id_category_default = '432', 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 = '17352' 15/03/2023 02:45:33 pm >> DELETE FROM ps_specific_price WHERE id_product = '17352' 15/03/2023 02:46:23 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 ( '31' , '109' , '2023-03-14' , '' , '0' , '118' , '4669176' , 'VIALE EUROPA, 102 36075 MONTECCHIO MAGGIORE' , '' , '' , '13.5' , '1' , '0' , '0' , '0' , '' , '9' , '0' , '718.23' , '588.71' , NOW() , NOW() ) 15/03/2023 02:46:23 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 = '82316' 15/03/2023 02:46:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '82316' 15/03/2023 02:46:23 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 ( '82316' , '14577' , 'CAMICE BENEDETTINO COCOLLE - MISTO LANA 328' , '2' , '2' , '1' , '54' , '44.262295081967' , '22' , '3' , '127.8072' ) 15/03/2023 02:46:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14577' AND id_supplier = '118' 15/03/2023 02:46:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14577' , '118' , '1' ) 15/03/2023 02:46:23 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 ( '82316' , '14578' , 'CAMICE GOTICO - MISTO LANA LEGGERO - 328' , '1' , '1' , '1' , '78' , '63.934426229508' , '22' , '3' , '92.3052' ) 15/03/2023 02:46:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14578' AND id_supplier = '118' 15/03/2023 02:46:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14578' , '118' , '1' ) 15/03/2023 02:46:23 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 ( '82316' , '20848' , 'CAMICE MONASTICO CON CAPPUCCIO - 21MON' , '3' , '3' , '1' , '93' , '76.229508196721' , '22' , '3' , '330.1686' ) 15/03/2023 02:46:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20848' AND id_supplier = '118' 15/03/2023 02:46:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20848' , '118' , '1' ) 15/03/2023 02:46:23 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 ( '82316' , '16460' , 'SERVIZIO MESSA LINO - 5 PZ 74100' , '1' , '1' , '1' , '39' , '31.967213114754' , '22' , '3' , '46.1526' ) 15/03/2023 02:46:24 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16460' AND id_supplier = '118' 15/03/2023 02:46:24 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16460' , '118' , '1' ) 15/03/2023 02:46:24 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 ( '82316' , '19087' , 'SERVIZIO MESSA LINO - 74101' , '1' , '1' , '1' , '28' , '22.950819672131' , '22' , '3' , '33.1352' ) 15/03/2023 02:46:24 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19087' AND id_supplier = '118' 15/03/2023 02:46:24 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19087' , '118' , '1' ) 15/03/2023 02:46:24 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 ( '82316' , '17352' , 'STOLA MARIANA MISTO SETA- 1021 AM' , '1' , '1' , '1' , '61' , '50' , '22' , '3' , '72.1874' ) 15/03/2023 02:46:24 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17352' AND id_supplier = '118' 15/03/2023 02:46:24 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17352' , '118' , '1' ) 15/03/2023 03:05:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '28/A' AND id_document != '82094' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-03-02') 15/03/2023 03:05:15 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '28/A', document_date = '2023-03-02', document_letter = 'A', id_customer = '2624', id_supplier = '', id_address = '4670911', address1 = 'P. ZZA ANNUNZIATA 84095 GIFFONI VALLE PIANA', address2 = '', note = 'conto vendita presentazione libro', 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 = '756.00', price_tax_excluded = '756.00', date_upd = NOW() WHERE id_document = '82094' 15/03/2023 03:05:15 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82094' 15/03/2023 03:05:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '82094' 15/03/2023 03:05:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82094' , '20745' , 'SPERANZA CHE CERCHI - F. CRISTOFARO' , '45' , '-45' , '4' , '14.0000' , '14' , '0' , '10' , '567.00' ) 15/03/2023 03:05:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82094' , '0' , '13/03' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 15/03/2023 03:05:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82094' , '20745' , 'SPERANZA CHE CERCHI - F. CRISTOFARO' , '15' , '-15' , '4' , '14.0000' , '14' , '0' , '10' , '189.00' ) 15/03/2023 04:08:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '28/A' AND id_document != '82094' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-03-02') 15/03/2023 04:08:14 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '28/A', document_date = '2023-03-02', document_letter = 'A', id_customer = '2624', id_supplier = '', id_address = '4670911', address1 = 'P. ZZA ANNUNZIATA 84095 GIFFONI VALLE PIANA', address2 = '', note = 'conto vendita presentazione libro', 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 = '793.80', price_tax_excluded = '793.80', date_upd = NOW() WHERE id_document = '82094' 15/03/2023 04:08:14 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 = '82094' 15/03/2023 04:08:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '82094' 15/03/2023 04:08:14 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 ( '82094' , '20745' , 'SPERANZA CHE CERCHI - F. CRISTOFARO' , '45' , '-45' , '4' , '14.0000' , '14' , '0' , '10' , '567.00' ) 15/03/2023 04:08:14 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 ( '82094' , '0' , '13/03' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 15/03/2023 04:08:14 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 ( '82094' , '20745' , 'SPERANZA CHE CERCHI - F. CRISTOFARO' , '15' , '-15' , '4' , '14.0000' , '14' , '0' , '10' , '189.00' ) 15/03/2023 04:08:14 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 ( '82094' , '' , '15/03' , '1' , '-1' , '0' , '0' , '0' , '' , '0' , '0' ) 15/03/2023 04:08:14 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 ( '82094' , '20745' , 'SPERANZA CHE CERCHI - F. CRISTOFARO' , '3' , '-3' , '4' , '14.00' , '14' , '0' , '10' , '37.80' ) 15/03/2023 06:10:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '857' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-15') 15/03/2023 06:10:09 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '857' , '2023-03-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.40' , '6.40' , NOW() , NOW() ) 15/03/2023 06:10:09 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82317' 15/03/2023 06:10:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '82317' 15/03/2023 06:10:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82317' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '6.4' , '6.4' , '0' , '0' , '6.40' )