01/09/2022 09:19:02 am >> SELECT document_num FROM ps_document WHERE document_num = '2584' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-01') 01/09/2022 09:19:02 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2584' , '2022-09-01' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '45.00' , '36.89' , NOW() , NOW() ) 01/09/2022 09:19:02 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61105' 01/09/2022 09:19:02 am >> DELETE FROM ps_document_detail WHERE id_document = '61105' 01/09/2022 09:19:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61105' , '16939' , 'SACCO PORTAELEMOSINA CON ASTA 1 m - 1750' , '1' , '-1' , '1' , '45.00' , '36.885245901639' , '22' , '0' , '45.00' ) 01/09/2022 09:19:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '16939' AND id_supplier = '' 01/09/2022 09:19:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16939' , '' , '1' ) 01/09/2022 09:22:43 am >> SELECT document_num FROM ps_document WHERE document_num = '2585' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-01') 01/09/2022 09: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' , '2585' , '2022-09-01' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 01/09/2022 09: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 = '61106' 01/09/2022 09:22:43 am >> DELETE FROM ps_document_detail WHERE id_document = '61106' 01/09/2022 09: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 ( '61106' , '19622' , 'SULLA TUA PAROLA - SETT/OTT 2022' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 01/09/2022 09:22:43 am >> DELETE FROM ps_product_supplier WHERE id_product = '19622' AND id_supplier = '' 01/09/2022 09:22:43 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19622' , '' , '1' ) 01/09/2022 09:35:20 am >> SELECT document_num FROM ps_document WHERE document_num = '2586' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-01') 01/09/2022 09:35:20 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' , '2586' , '2022-09-01' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.60' , '7.87' , NOW() , NOW() ) 01/09/2022 09:35:20 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 = '61107' 01/09/2022 09:35:20 am >> DELETE FROM ps_document_detail WHERE id_document = '61107' 01/09/2022 09:35:20 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 ( '61107' , '5811' , 'LIBRETTO ROSARIO CON IMM. MADONNA CHE DISFA I NODI E ROSARIO - 7100MDN' , '1' , '-1' , '1' , '5.00' , '4.0983606557377' , '22' , '0' , '5.00' ) 01/09/2022 09:35:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '5811' AND id_supplier = '' 01/09/2022 09:35:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5811' , '' , '1' ) 01/09/2022 09:35:20 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 ( '61107' , '9691' , 'SCAPOLARE DEL CARMELO - PICCOLO - 1215/ITA' , '1' , '-1' , '1' , '1.10' , '0.9016393442623' , '22' , '0' , '1.10' ) 01/09/2022 09:35:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '9691' AND id_supplier = '' 01/09/2022 09:35:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9691' , '' , '1' ) 01/09/2022 09:35:20 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 ( '61107' , '4887' , 'ICONA LEGNO 10X15 - POMPEI - 1222 ' , '1' , '-1' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '3.50' ) 01/09/2022 09:35:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '4887' AND id_supplier = '' 01/09/2022 09:35:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4887' , '' , '1' ) 01/09/2022 10:38:34 am >> SELECT document_num FROM ps_document WHERE document_num = '2587' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-01') 01/09/2022 10:38:34 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' , '2587' , '2022-09-01' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '58.00' , '47.54' , NOW() , NOW() ) 01/09/2022 10:38:34 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61108' 01/09/2022 10:38:34 am >> DELETE FROM ps_document_detail WHERE id_document = '61108' 01/09/2022 10:38:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61108' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 01/09/2022 10:38:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 01/09/2022 10:38:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 01/09/2022 10:38:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61108' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '2' , '-2' , '1' , '0.8' , '0.65573770491803' , '22' , '0' , '1.60' ) 01/09/2022 10:38:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '18122' AND id_supplier = '' 01/09/2022 10:38:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18122' , '' , '1' ) 01/09/2022 10:49:55 am >> SELECT ean13 FROM ps_product WHERE ean13 = '001598' AND id_product != '3365' AND ean13 != '' 01/09/2022 10:49:55 am >> UPDATE ps_product SET id_supplier = '16', reference = '2014', ean13 = '001598', date_upd = NOW() WHERE id_product = '3365' 01/09/2022 10:49:55 am >> UPDATE ps_product_lang SET name = 'DECINA LEGNO MISSIONARIO MM 6 - RG 05/10 ', description = '' WHERE id_product = '3365' 01/09/2022 10:49:55 am >> UPDATE ps_product SET wholesale_price = '0.25', on_sale = '0', price = '0.5738' WHERE id_product = '3365' 01/09/2022 10:49:55 am >> UPDATE ps_product_shop SET wholesale_price = '0.25', price = '0.5738', id_tax_rules_group = '1', id_category_default = '210', 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 = '3365' 01/09/2022 10:49:55 am >> DELETE FROM ps_specific_price WHERE id_product = '3365' 01/09/2022 10:51:06 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') 01/09/2022 10:51:06 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 = '', 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 = '551.00', price_tax_excluded = '451.64', date_upd = NOW() WHERE id_document = '59768' 01/09/2022 10:51: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 = '59768' 01/09/2022 10:51:06 am >> DELETE FROM ps_document_detail WHERE id_document = '59768' 01/09/2022 10:51: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 ( '59768' , '1914' , 'CERA DELLA LITURGIA' , '60' , '-60' , '1' , '4.5000' , '3.6885245901639' , '22' , '0' , '270.00' ) 01/09/2022 10:51:06 am >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 01/09/2022 10:51:06 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 01/09/2022 10:51: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 ( '59768' , '15387' , 'VESTINA BATTESIMALE ' , '20' , '-20' , '1' , '2.5000' , '2.0491803278689' , '22' , '0' , '50.00' ) 01/09/2022 10:51:06 am >> DELETE FROM ps_product_supplier WHERE id_product = '15387' AND id_supplier = '' 01/09/2022 10:51:06 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15387' , '' , '1' ) 01/09/2022 10:51: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 ( '59768' , '18222' , 'ROSARIO COLORATO - R316' , '33' , '-33' , '1' , '0.7000' , '0.57377049180328' , '22' , '0' , '23.10' ) 01/09/2022 10:51:06 am >> DELETE FROM ps_product_supplier WHERE id_product = '18222' AND id_supplier = '' 01/09/2022 10:51:06 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18222' , '' , '1' ) 01/09/2022 10:51: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 ( '59768' , '3365' , 'DECINA LEGNO MISSIONARIO MM 6 - RG 05/10 - OGGETTI' , '297' , '-297' , '1' , '0.7000' , '0.57377049180328' , '22' , '0' , '207.90' ) 01/09/2022 10:51:06 am >> DELETE FROM ps_product_supplier WHERE id_product = '3365' AND id_supplier = '' 01/09/2022 10:51:06 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3365' , '' , '1' ) 01/09/2022 10:52:47 am >> SELECT document_num FROM ps_document WHERE document_num = '1235' AND id_document != '55891' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-04-23') 01/09/2022 10:52:47 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1235', document_date = '2022-04-23', 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 = '500.00', price_tax_excluded = '409.84', date_upd = NOW() WHERE id_document = '55891' 01/09/2022 10:52: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 = '55891' 01/09/2022 10:52:47 am >> DELETE FROM ps_document_detail WHERE id_document = '55891' 01/09/2022 10:52: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 ( '55891' , '17404' , 'CASULA RIGATA' , '1' , '-1' , '1' , '270.0000' , '221.31147540984' , '22' , '0' , '270.00' ) 01/09/2022 10:52:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '17404' AND id_supplier = '' 01/09/2022 10:52:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17404' , '' , '1' ) 01/09/2022 10:52: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 ( '55891' , '19147' , 'CANDELINE NON GOCCIOLANTI GRECHE' , '2' , '-2' , '1' , '15.9000' , '13.032786885246' , '22' , '0' , '31.80' ) 01/09/2022 10:52:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '19147' AND id_supplier = '' 01/09/2022 10:52:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19147' , '' , '1' ) 01/09/2022 10:52: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 ( '55891' , '11384' , 'VINO BIANCO DOLCE - 102' , '3' , '-3' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '22.50' ) 01/09/2022 10:52:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '11384' AND id_supplier = '' 01/09/2022 10:52:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11384' , '' , '1' ) 01/09/2022 10:52: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 ( '55891' , '19107' , 'INCENSO GRANI 3A' , '1' , '-1' , '1' , '30.0000' , '24.590163934426' , '22' , '0' , '30.00' ) 01/09/2022 10:52:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '19107' AND id_supplier = '' 01/09/2022 10:52:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19107' , '' , '1' ) 01/09/2022 10:52: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 ( '55891' , '794' , 'ASTUCCIO 3 BOTTIGLIE CC125 - 964' , '1' , '-1' , '1' , '95.0000' , '77.868852459016' , '22' , '0' , '95.00' ) 01/09/2022 10:52:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '794' AND id_supplier = '' 01/09/2022 10:52:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '794' , '' , '1' ) 01/09/2022 10:52: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 ( '55891' , '18247' , 'CLERGY JEANS NIDO DAPE MM - M' , '1' , '-1' , '1' , '40.0000' , '32.786885245902' , '22' , '0' , '40.00' ) 01/09/2022 10:52:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '18247' AND id_supplier = '' 01/09/2022 10:52:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18247' , '' , '1' ) 01/09/2022 10:52: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 ( '55891' , '12689' , 'IMMAGINI 50X70' , '1' , '-1' , '1' , '4.5000' , '3.6885245901639' , '22' , '0' , '4.50' ) 01/09/2022 10:52:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '12689' AND id_supplier = '' 01/09/2022 10:52:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12689' , '' , '1' ) 01/09/2022 10:52: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 ( '55891' , '18222' , 'ROSARIO COLORATO - R316' , '1' , '-1' , '1' , '0.7000' , '0.57377049180328' , '22' , '0' , '0.70' ) 01/09/2022 10:52:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '18222' AND id_supplier = '' 01/09/2022 10:52:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18222' , '' , '1' ) 01/09/2022 10:52: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 ( '55891' , '3365' , 'DECINA LEGNO MISSIONARIO MM 6 - RG 05/10 ' , '11' , '-11' , '1' , '0.5' , '0.40983606557377' , '22' , '0' , '5.50' ) 01/09/2022 10:52:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '3365' AND id_supplier = '' 01/09/2022 10:52:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3365' , '' , '1' ) 01/09/2022 10:53:29 am >> SELECT document_num FROM ps_document WHERE document_num = '2063' AND id_document != '58926' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-27') 01/09/2022 10:53:29 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2063', document_date = '2022-06-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 = '41.60', price_tax_excluded = '34.10', date_upd = NOW() WHERE id_document = '58926' 01/09/2022 10:53:29 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58926' 01/09/2022 10:53:29 am >> DELETE FROM ps_document_detail WHERE id_document = '58926' 01/09/2022 10:53:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58926' , '3365' , 'DECINA LEGNO MISSIONARIO MM 6 - RG 05/10 ' , '1' , '-1' , '1' , '0.6' , '0.49180327868852' , '22' , '0' , '0.60' ) 01/09/2022 10:53:29 am >> DELETE FROM ps_product_supplier WHERE id_product = '3365' AND id_supplier = '' 01/09/2022 10:53:29 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3365' , '' , '1' ) 01/09/2022 10:53:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58926' , '13113' , 'GUADALUPE BABY - 023 GUA 9 BB' , '2' , '-2' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '20.00' ) 01/09/2022 10:53:29 am >> DELETE FROM ps_product_supplier WHERE id_product = '13113' AND id_supplier = '' 01/09/2022 10:53:29 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13113' , '' , '1' ) 01/09/2022 10:53:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58926' , '14623' , 'BAMBINO DI PRAGA BABY - 023 IP/9 BB' , '1' , '-1' , '1' , '8.0000' , '6.5573770491803' , '22' , '0' , '8.00' ) 01/09/2022 10:53:29 am >> DELETE FROM ps_product_supplier WHERE id_product = '14623' AND id_supplier = '' 01/09/2022 10:53:29 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14623' , '' , '1' ) 01/09/2022 10:53:30 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 ( '58926' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 01/09/2022 10:53:30 am >> DELETE FROM ps_product_supplier WHERE id_product = '17160' AND id_supplier = '' 01/09/2022 10:53:30 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17160' , '' , '1' ) 01/09/2022 10:53:30 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 ( '58926' , '3365' , 'DECINA LEGNO MISSIONARIO MM 6 - RG 05/10 ' , '6' , '-6' , '1' , '0.5' , '0.40983606557377' , '22' , '0' , '3.00' ) 01/09/2022 10:53:30 am >> DELETE FROM ps_product_supplier WHERE id_product = '3365' AND id_supplier = '' 01/09/2022 10:53:30 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3365' , '' , '1' ) 01/09/2022 10:53:53 am >> SELECT document_num FROM ps_document WHERE document_num = '2378' AND id_document != '59820' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-27') 01/09/2022 10:53:53 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2378', document_date = '2022-07-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 = '122.50', price_tax_excluded = '100.41', date_upd = NOW() WHERE id_document = '59820' 01/09/2022 10:53:54 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 = '59820' 01/09/2022 10:53:54 am >> DELETE FROM ps_document_detail WHERE id_document = '59820' 01/09/2022 10:53:54 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 ( '59820' , '19605' , 'CLERGY SU MISURA - COCOCLER' , '3' , '-3' , '1' , '40.0000' , '32.786885245902' , '22' , '0' , '120.00' ) 01/09/2022 10:53:54 am >> DELETE FROM ps_product_supplier WHERE id_product = '19605' AND id_supplier = '' 01/09/2022 10:53:54 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19605' , '' , '1' ) 01/09/2022 10:53:54 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 ( '59820' , '3365' , 'DECINA LEGNO MISSIONARIO MM 6 - RG 05/10 ' , '5' , '-5' , '1' , '0.5' , '0.40983606557377' , '22' , '0' , '2.50' ) 01/09/2022 10:53:54 am >> DELETE FROM ps_product_supplier WHERE id_product = '3365' AND id_supplier = '' 01/09/2022 10:53:54 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3365' , '' , '1' ) 01/09/2022 10:54:48 am >> SELECT document_num FROM ps_document WHERE document_num = '2370' AND id_document != '59811' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-27') 01/09/2022 10:54:48 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2370', document_date = '2022-07-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 = '14.90', price_tax_excluded = '12.92', date_upd = NOW() WHERE id_document = '59811' 01/09/2022 10:54: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 = '59811' 01/09/2022 10:54:48 am >> DELETE FROM ps_document_detail WHERE id_document = '59811' 01/09/2022 10:54: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 ( '59811' , '2766' , 'CORONA PLASTICA FOSFORO - 0100F' , '30' , '-30' , '1' , '0.3000' , '0.24590163934426' , '22' , '0' , '9.00' ) 01/09/2022 10:54:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '2766' AND id_supplier = '' 01/09/2022 10:54:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2766' , '' , '1' ) 01/09/2022 10:54: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 ( '59811' , '6629' , 'MIA PREGHIERA' , '6' , '-6' , '4' , '0.6500' , '0.65' , '0' , '0' , '3.90' ) 01/09/2022 10:54:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '6629' AND id_supplier = '' 01/09/2022 10:54:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6629' , '' , '1' ) 01/09/2022 10:54: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 ( '59811' , '3365' , 'DECINA LEGNO MISSIONARIO MM 6 - RG 05/10 ' , '2' , '-2' , '1' , '0.5' , '0.40983606557377' , '22' , '0' , '1.00' ) 01/09/2022 10:54:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '3365' AND id_supplier = '' 01/09/2022 10:54:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3365' , '' , '1' ) 01/09/2022 10:54:49 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 ( '59811' , '9132' , 'DECINA LEGNO ACERO NATURALE - RG 021-10' , '2' , '-2' , '1' , '0.5' , '0.40983606557377' , '22' , '0' , '1.00' ) 01/09/2022 10:54:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '9132' AND id_supplier = '' 01/09/2022 10:54:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9132' , '' , '1' ) 01/09/2022 10:55:16 am >> SELECT document_num FROM ps_document WHERE document_num = '2425' AND id_document != '59888' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-08-02') 01/09/2022 10:55:16 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2425', document_date = '2022-08-02', 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 = '21.25', price_tax_excluded = '19.99', date_upd = NOW() WHERE id_document = '59888' 01/09/2022 10:55: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 = '59888' 01/09/2022 10:55:16 am >> DELETE FROM ps_document_detail WHERE id_document = '59888' 01/09/2022 10:55: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 ( '59888' , '19662' , 'MESSALINO QUOTIDIANO - AGO/SET/OTT 2022' , '3' , '-3' , '4' , '5.0000' , '5' , '0' , '5' , '14.25' ) 01/09/2022 10:55:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '19662' AND id_supplier = '' 01/09/2022 10:55:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19662' , '' , '1' ) 01/09/2022 10:55: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 ( '59888' , '14247' , 'ROSARIO ULIVO OVALE CON SETA E CROCE SAN DAMIANO' , '1' , '-1' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '1.50' ) 01/09/2022 10:55:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '14247' AND id_supplier = '' 01/09/2022 10:55:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14247' , '' , '1' ) 01/09/2022 10:55: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 ( '59888' , '9113' , 'ROSARIO FRANCESCANO DA COLLO - 2516' , '1' , '-1' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '3.50' ) 01/09/2022 10:55:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '9113' AND id_supplier = '' 01/09/2022 10:55:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9113' , '' , '1' ) 01/09/2022 10:55: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 ( '59888' , '3365' , 'DECINA LEGNO MISSIONARIO MM 6 - RG 05/10 ' , '4' , '-4' , '1' , '0.5' , '0.40983606557377' , '22' , '0' , '2.00' ) 01/09/2022 10:55:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '3365' AND id_supplier = '' 01/09/2022 10:55:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3365' , '' , '1' ) 01/09/2022 11:02:11 am >> SELECT document_num FROM ps_document WHERE document_num = '2588' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-01') 01/09/2022 11:02:11 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' , '2588' , '2022-09-01' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '38.00' , '38.00' , NOW() , NOW() ) 01/09/2022 11:02:11 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 = '61109' 01/09/2022 11:02:11 am >> DELETE FROM ps_document_detail WHERE id_document = '61109' 01/09/2022 11:02:11 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 ( '61109' , '19622' , 'SULLA TUA PAROLA - SETT/OTT 2022' , '8' , '-8' , '4' , '5.00' , '5' , '0' , '5' , '38.00' ) 01/09/2022 11:02:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '19622' AND id_supplier = '' 01/09/2022 11:02:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19622' , '' , '1' ) 01/09/2022 11:10:39 am >> SELECT document_num FROM ps_document WHERE document_num = '2589' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-01') 01/09/2022 11:10:39 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' , '2589' , '2022-09-01' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.80' , '12.80' , NOW() , NOW() ) 01/09/2022 11:10:39 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 = '61110' 01/09/2022 11:10:39 am >> DELETE FROM ps_document_detail WHERE id_document = '61110' 01/09/2022 11:10:39 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 ( '61110' , '16442' , 'CARLO ACUTIS LAMICO DI GESU - 8865' , '1' , '-1' , '4' , '7.00' , '7' , '0' , '0' , '7.00' ) 01/09/2022 11:10:39 am >> DELETE FROM ps_product_supplier WHERE id_product = '16442' AND id_supplier = '' 01/09/2022 11:10:39 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16442' , '' , '1' ) 01/09/2022 11:10:39 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 ( '61110' , '19618' , 'CARLO ACUTIS' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '0' , '3.90' ) 01/09/2022 11:10:39 am >> DELETE FROM ps_product_supplier WHERE id_product = '19618' AND id_supplier = '' 01/09/2022 11:10:40 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19618' , '' , '1' ) 01/09/2022 11:10: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 ( '61110' , '19638' , 'STORIA DI CARLO ACUTIS' , '1' , '-1' , '4' , '1.90' , '1.9' , '0' , '0' , '1.90' ) 01/09/2022 11:10:40 am >> DELETE FROM ps_product_supplier WHERE id_product = '19638' AND id_supplier = '' 01/09/2022 11:10:40 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19638' , '' , '1' ) 01/09/2022 11:19:41 am >> SELECT document_num FROM ps_document WHERE document_num = '2590' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-01') 01/09/2022 11:19: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' , '2590' , '2022-09-01' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '50.00' , '40.98' , NOW() , NOW() ) 01/09/2022 11:19: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 = '61111' 01/09/2022 11:19:41 am >> DELETE FROM ps_document_detail WHERE id_document = '61111' 01/09/2022 11:19: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 ( '61111' , '12528' , 'LAMPADA A SFERA BLU' , '2' , '-2' , '1' , '25.00' , '20.491803278689' , '22' , '0' , '50.00' ) 01/09/2022 11:19:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '12528' AND id_supplier = '' 01/09/2022 11:19:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12528' , '' , '1' ) 01/09/2022 11:25:30 am >> SELECT document_num FROM ps_document WHERE document_num = '2591' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-01') 01/09/2022 11:25:30 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' , '2591' , '2022-09-01' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '109.50' , '90.66' , NOW() , NOW() ) 01/09/2022 11:25:30 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 = '61112' 01/09/2022 11:25:30 am >> DELETE FROM ps_document_detail WHERE id_document = '61112' 01/09/2022 11:25:30 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 ( '61112' , '18027' , 'RELIQUIARIO DORATO H 17' , '1' , '-1' , '1' , '78.00' , '63.934426229508' , '22' , '0' , '78.00' ) 01/09/2022 11:25:30 am >> DELETE FROM ps_product_supplier WHERE id_product = '18027' AND id_supplier = '' 01/09/2022 11:25:30 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18027' , '' , '1' ) 01/09/2022 11:25:31 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 ( '61112' , '17617' , 'IMMAGINI ISONZO X 100' , '2' , '-2' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '7.00' ) 01/09/2022 11:25:31 am >> DELETE FROM ps_product_supplier WHERE id_product = '17617' AND id_supplier = '' 01/09/2022 11:25:31 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17617' , '' , '1' ) 01/09/2022 11:25:31 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 ( '61112' , '18010' , 'DISCEPOLO AMATO - 8012' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '0' , '5.00' ) 01/09/2022 11:25:31 am >> DELETE FROM ps_product_supplier WHERE id_product = '18010' AND id_supplier = '' 01/09/2022 11:25:31 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18010' , '' , '1' ) 01/09/2022 11:25:31 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 ( '61112' , '538' , 'AMPOLLA RICAMBIO PER ART. 501/5 - 70' , '1' , '-1' , '1' , '6.50' , '5.327868852459' , '22' , '0' , '6.50' ) 01/09/2022 11:25:31 am >> DELETE FROM ps_product_supplier WHERE id_product = '538' AND id_supplier = '' 01/09/2022 11:25:31 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '538' , '' , '1' ) 01/09/2022 11:25:31 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 ( '61112' , '19102' , 'CARBONCINI MM 40' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 01/09/2022 11:25:31 am >> DELETE FROM ps_product_supplier WHERE id_product = '19102' AND id_supplier = '' 01/09/2022 11:25:31 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19102' , '' , '1' ) 01/09/2022 11:36:01 am >> SELECT document_num FROM ps_document WHERE document_num = '1802' AND id_document != '58626' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-06') 01/09/2022 11:36:01 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1802', document_date = '2022-06-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 = '31.80', price_tax_excluded = '26.07', date_upd = NOW() WHERE id_document = '58626' 01/09/2022 11:36:01 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 = '58626' 01/09/2022 11:36:01 am >> DELETE FROM ps_document_detail WHERE id_document = '58626' 01/09/2022 11:36:01 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 ( '58626' , '15403' , 'CROCE IN RESINA CM 9 - 3806/G052' , '1' , '-1' , '1' , '3.3000' , '2.7049180327869' , '22' , '0' , '3.30' ) 01/09/2022 11:36:01 am >> DELETE FROM ps_product_supplier WHERE id_product = '15403' AND id_supplier = '' 01/09/2022 11:36:01 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15403' , '' , '1' ) 01/09/2022 11:36:01 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 ( '58626' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '16.1' , '13.196721311475' , '22' , '0' , '16.10' ) 01/09/2022 11:36:01 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 01/09/2022 11:36:01 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 01/09/2022 11:36:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58626' , '18213' , 'BRACCIALE CROCI COLORATO - BC569' , '1' , '-1' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '1.00' ) 01/09/2022 11:36:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '18213' AND id_supplier = '' 01/09/2022 11:36:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18213' , '' , '1' ) 01/09/2022 11:36:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58626' , '6075' , 'LOURDES BABY - 023 LDS/9 BB' , '1' , '-1' , '1' , '8.0000' , '6.5573770491803' , '22' , '0' , '8.00' ) 01/09/2022 11:36:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '6075' AND id_supplier = '' 01/09/2022 11:36:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6075' , '' , '1' ) 01/09/2022 11:36:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58626' , '6405' , 'MENSA DIAM 40X250 - M4025' , '1' , '-1' , '1' , '3.40' , '2.7868852459016' , '22' , '0' , '3.40' ) 01/09/2022 11:36:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '6405' AND id_supplier = '' 01/09/2022 11:36:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6405' , '' , '1' ) 01/09/2022 11:36:26 am >> UPDATE ps_document SET id_document_type = '34', document_num = '8/2022', document_date = '2022-05-31', document_letter = '2022', id_customer = '0', id_supplier = '', id_address = '2645', address1 = 'VIA P. G. SEMERIA, 19 70014 CONVERSANO', address2 = '', note = '', price_shipping = '15.00', id_tax_shipping_rules = '1', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '223.26', price_tax_excluded = '183.00', date_upd = NOW() WHERE id_document = '58597' 01/09/2022 11:36:26 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 = '58597' 01/09/2022 11:36:26 am >> DELETE FROM ps_document_detail WHERE id_document = '58597' 01/09/2022 11:36:26 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 ( '58597' , '19431' , 'PALLONCINO MAGNETE 12X15 - PM' , '30' , '-30' , '1' , '10.0000' , '8.1967213114754' , '22' , '50' , '183.00' ) 01/09/2022 11:36:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '19431' AND id_supplier = '' 01/09/2022 11:36:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19431' , '' , '1' ) 01/09/2022 11:36:26 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 ( '58597' , '7202' , 'ARTICOLI RELIGIOSI' , '30' , '-30' , '1' , '0.6000' , '0.49180327868852' , '22' , '0' , '21.96' ) 01/09/2022 11:36:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 01/09/2022 11:36:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 01/09/2022 11:37:05 am >> UPDATE ps_document SET id_document_type = '34', document_num = '8/2022', document_date = '2022-05-31', document_letter = '2022', id_customer = '0', id_supplier = '', id_address = '2645', address1 = 'VIA P. G. SEMERIA, 19 70014 CONVERSANO', address2 = '', note = '', price_shipping = '15.00', id_tax_shipping_rules = '1', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '223.26', price_tax_excluded = '183.00', date_upd = NOW() WHERE id_document = '58597' 01/09/2022 11:37: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 = '58597' 01/09/2022 11:37:05 am >> DELETE FROM ps_document_detail WHERE id_document = '58597' 01/09/2022 11:37: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 ( '58597' , '19431' , 'PALLONCINO MAGNETE 12X15 - PM' , '30' , '-30' , '1' , '10.0000' , '8.1967213114754' , '22' , '50' , '183.00' ) 01/09/2022 11:37:05 am >> DELETE FROM ps_product_supplier WHERE id_product = '19431' AND id_supplier = '' 01/09/2022 11:37:05 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19431' , '' , '1' ) 01/09/2022 11:37: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 ( '58597' , '7202' , 'VARI' , '30' , '-30' , '1' , '0.6' , '0.49180327868852' , '22' , '0' , '21.9600' ) 01/09/2022 11:37:05 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 01/09/2022 11:37:05 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 01/09/2022 11:38:05 am >> UPDATE ps_document SET id_document_type = '34', document_num = '8/2022', document_date = '2022-05-31', document_letter = '2022', id_customer = '0', id_supplier = '', id_address = '2645', address1 = 'VIA P. G. SEMERIA, 19 70014 CONVERSANO', address2 = '', note = '', price_shipping = '15.00', id_tax_shipping_rules = '1', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '223.26', price_tax_excluded = '183.00', date_upd = NOW() WHERE id_document = '58597' 01/09/2022 11:38: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 = '58597' 01/09/2022 11:38:05 am >> DELETE FROM ps_document_detail WHERE id_document = '58597' 01/09/2022 11:38: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 ( '58597' , '19431' , 'PALLONCINO MAGNETE 12X15 - PM' , '30' , '-30' , '1' , '10.0000' , '8.1967213114754' , '22' , '50' , '183.00' ) 01/09/2022 11:38:05 am >> DELETE FROM ps_product_supplier WHERE id_product = '19431' AND id_supplier = '' 01/09/2022 11:38:05 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19431' , '' , '1' ) 01/09/2022 11:38: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 ( '58597' , '' , 'ARROTONDAMENTO' , '30' , '-30' , '1' , '0.6' , '0.49180327868852' , '22' , '0' , '21.9600' ) 01/09/2022 11:38:05 am >> DELETE FROM ps_product_supplier WHERE id_product = '' AND id_supplier = '' 01/09/2022 11:38:05 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '' , '' , '1' ) 01/09/2022 12:11:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '52' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-09-01') 01/09/2022 12:11: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 ( '21' , '52' , '2022-09-01' , '' , '3350' , '0' , '4669953' , 'VIA RISORGIMENTO, 2 37068 VIGASIO ' , '' , '' , '4.9' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '22.00' , '22.00' , NOW() , NOW() ) 01/09/2022 12:11: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 = '5407' 01/09/2022 12:11:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '5407' 01/09/2022 12:11: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 ( '5407' , '133' , 'LIBRO AGENDA CATTOLICO 2023' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '5' , '17.10' ) 01/09/2022 12:19:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '2592' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-01') 01/09/2022 12:19:39 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' , '2592' , '2022-09-01' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 01/09/2022 12:19:39 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 = '61113' 01/09/2022 12:19:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '61113' 01/09/2022 12:19:39 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 ( '61113' , '19622' , 'SULLA TUA PAROLA - SETT/OTT 2022' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 01/09/2022 12:19:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19622' AND id_supplier = '' 01/09/2022 12:19:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19622' , '' , '1' ) 01/09/2022 01:03:37 pm >> SELECT document_num FROM ps_document WHERE document_num = '2593' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-01') 01/09/2022 01:03:37 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2593' , '2022-09-01' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.00' , '13.63' , NOW() , NOW() ) 01/09/2022 01:03:37 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61114' 01/09/2022 01:03:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '61114' 01/09/2022 01:03:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61114' , '19685' , 'AMEN - OTT 2022' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 01/09/2022 01:03:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19685' AND id_supplier = '' 01/09/2022 01:03:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19685' , '' , '1' ) 01/09/2022 01:03:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61114' , '19684' , 'AMEN - SET. 2022' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 01/09/2022 01:03:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19684' AND id_supplier = '' 01/09/2022 01:03:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19684' , '' , '1' ) 01/09/2022 01:03:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61114' , '11389' , 'VINO ROSSO DOLCE - 103' , '1' , '-1' , '1' , '7.58' , '6.2131147540984' , '22' , '0' , '7.58' ) 01/09/2022 01:03:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11389' AND id_supplier = '' 01/09/2022 01:03:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11389' , '' , '1' ) 01/09/2022 02:40:18 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8006657126102' AND id_product != '11384' AND ean13 != '' 01/09/2022 02:40:18 pm >> UPDATE ps_product SET id_supplier = '48', reference = '2015', ean13 = '8006657126102', date_upd = NOW() WHERE id_product = '11384' 01/09/2022 02:40:18 pm >> UPDATE ps_product_lang SET name = 'VINO BIANCO DOLCE - 102', description = '' WHERE id_product = '11384' 01/09/2022 02:40:18 pm >> UPDATE ps_product SET wholesale_price = '3.69', on_sale = '0', price = '6.967213114754099' WHERE id_product = '11384' 01/09/2022 02:40:18 pm >> UPDATE ps_product_shop SET wholesale_price = '3.69', price = '6.967213114754099', id_tax_rules_group = '1', id_category_default = '376', 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 = '11384' 01/09/2022 02:40:18 pm >> DELETE FROM ps_specific_price WHERE id_product = '11384' 01/09/2022 02:40:50 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8006657324102' AND id_product != '11389' AND ean13 != '' 01/09/2022 02:40:50 pm >> UPDATE ps_product SET id_supplier = '48', reference = '2015', ean13 = '8006657324102', date_upd = NOW() WHERE id_product = '11389' 01/09/2022 02:40:50 pm >> UPDATE ps_product_lang SET name = 'VINO ROSSO DOLCE - 103', description = '' WHERE id_product = '11389' 01/09/2022 02:40:50 pm >> UPDATE ps_product SET wholesale_price = '3.80', on_sale = '0', price = '6.967213114754099' WHERE id_product = '11389' 01/09/2022 02:40:50 pm >> UPDATE ps_product_shop SET wholesale_price = '3.80', price = '6.967213114754099', id_tax_rules_group = '1', id_category_default = '376', 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 = '11389' 01/09/2022 02:40:50 pm >> DELETE FROM ps_specific_price WHERE id_product = '11389' 01/09/2022 02:41:09 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000957' AND id_product != '11757' AND ean13 != '' 01/09/2022 02:41:09 pm >> UPDATE ps_product SET id_supplier = '80', reference = '', ean13 = '000957', date_upd = NOW() WHERE id_product = '11757' 01/09/2022 02:41:09 pm >> UPDATE ps_product_lang SET name = 'VINO LIQUOROSO DOLCE - 16%', description = '' WHERE id_product = '11757' 01/09/2022 02:41:09 pm >> UPDATE ps_product SET wholesale_price = '3.10', on_sale = '0', price = '5.737704918032787' WHERE id_product = '11757' 01/09/2022 02:41:09 pm >> UPDATE ps_product_shop SET wholesale_price = '3.10', price = '5.737704918032787', id_tax_rules_group = '1', id_category_default = '387', 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 = '11757' 01/09/2022 02:41:09 pm >> DELETE FROM ps_specific_price WHERE id_product = '11757' 01/09/2022 02:41:28 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000957' AND id_product != '11757' AND ean13 != '' 01/09/2022 02:41:28 pm >> UPDATE ps_product SET id_supplier = '80', reference = '', ean13 = '000957', date_upd = NOW() WHERE id_product = '11757' 01/09/2022 02:41:28 pm >> UPDATE ps_product_lang SET name = 'VINO LIQUOROSO DOLCE - 16%', description = '' WHERE id_product = '11757' 01/09/2022 02:41:28 pm >> UPDATE ps_product SET wholesale_price = '3.10', on_sale = '0', price = '5.901639344262295' WHERE id_product = '11757' 01/09/2022 02:41:28 pm >> UPDATE ps_product_shop SET wholesale_price = '3.10', price = '5.901639344262295', id_tax_rules_group = '1', id_category_default = '387', 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 = '11757' 01/09/2022 02:41:28 pm >> DELETE FROM ps_specific_price WHERE id_product = '11757' 01/09/2022 02:41:38 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000956' AND id_product != '11756' AND ean13 != '' 01/09/2022 02:41:38 pm >> UPDATE ps_product SET id_supplier = '80', reference = '', ean13 = '000956', date_upd = NOW() WHERE id_product = '11756' 01/09/2022 02:41:38 pm >> UPDATE ps_product_lang SET name = 'VINO BIANCO SECCO - 14%', description = '' WHERE id_product = '11756' 01/09/2022 02:41:38 pm >> UPDATE ps_product SET wholesale_price = '2.50', on_sale = '0', price = '5.163934426229508' WHERE id_product = '11756' 01/09/2022 02:41:38 pm >> UPDATE ps_product_shop SET wholesale_price = '2.50', price = '5.163934426229508', id_tax_rules_group = '1', id_category_default = '387', 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 = '11756' 01/09/2022 02:41:38 pm >> DELETE FROM ps_specific_price WHERE id_product = '11756' 01/09/2022 03:07:00 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 01/09/2022 03:07:00 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19904' , '1' , '' , 'nuovo-prodotto' ) 01/09/2022 03:07:00 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '19904' , '1' , '1' , '2' , NOW() , NOW() ) 01/09/2022 03:07:00 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '19904' , '0' , '1' , '0' , '0' ) 01/09/2022 03:07:54 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '88/000100' AND id_product != '19904' AND ean13 != '' 01/09/2022 03:07:54 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '88/000100', date_upd = NOW() WHERE id_product = '19904' 01/09/2022 03:07:54 pm >> UPDATE ps_product_lang SET name = 'TALARE', description = '' WHERE id_product = '19904' 01/09/2022 03:07:54 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '639.344262295082' WHERE id_product = '19904' 01/09/2022 03:07:54 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '639.344262295082', id_tax_rules_group = '1', id_category_default = '468', 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 = '19904' 01/09/2022 03:07:54 pm >> DELETE FROM ps_specific_price WHERE id_product = '19904' 01/09/2022 03:07:55 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 = '19904' 01/09/2022 03:07:55 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19905' , '1' , '' , 'nuovo-prodotto' ) 01/09/2022 03:07:55 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 '19905' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19904' 01/09/2022 03:07:55 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19905' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19904' 01/09/2022 03:08:23 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000581' AND id_product != '19905' AND ean13 != '' 01/09/2022 03:08:23 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '000581', date_upd = NOW() WHERE id_product = '19905' 01/09/2022 03:08:23 pm >> UPDATE ps_product_lang SET name = 'MOZZETTA ', description = '' WHERE id_product = '19905' 01/09/2022 03:08:23 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '258.1967213114754' WHERE id_product = '19905' 01/09/2022 03:08:23 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '258.1967213114754', id_tax_rules_group = '1', id_category_default = '468', 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 = '19905' 01/09/2022 03:08:23 pm >> DELETE FROM ps_specific_price WHERE id_product = '19905' 01/09/2022 03:08:24 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 = '19905' 01/09/2022 03:08:24 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19906' , '1' , '' , 'nuovo-prodotto' ) 01/09/2022 03:08:24 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 '19906' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19905' 01/09/2022 03:08:24 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19906' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19905' 01/09/2022 03:08:56 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '88/0370188' AND id_product != '19906' AND ean13 != '' 01/09/2022 03:08:56 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '88/0370188', date_upd = NOW() WHERE id_product = '19906' 01/09/2022 03:08:56 pm >> UPDATE ps_product_lang SET name = 'FASCIA', description = '' WHERE id_product = '19906' 01/09/2022 03:08:56 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '77.8688524590164' WHERE id_product = '19906' 01/09/2022 03:08:56 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '77.8688524590164', id_tax_rules_group = '1', id_category_default = '468', 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 = '19906' 01/09/2022 03:08:56 pm >> DELETE FROM ps_specific_price WHERE id_product = '19906' 01/09/2022 03:08:57 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '19906' 01/09/2022 03:08:57 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19907' , '1' , '' , 'nuovo-prodotto' ) 01/09/2022 03:08:57 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '19907' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19906' 01/09/2022 03:08:57 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19907' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19906' 01/09/2022 03:10:57 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' , '1055' , '2022-08-30' , '' , '0' , '143' , '4670947' , 'VIA DELLE SELVETTE 324 55018 SEGROMIGNO IN MONTE CAPANNORI' , '' , '' , '13' , '1' , '0' , '0' , '0' , '' , '3' , '0' , '595.73' , '488.30' , NOW() , NOW() ) 01/09/2022 03:10:57 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 = '61115' 01/09/2022 03:10:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '61115' 01/09/2022 03:10:57 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 ( '61115' , '19904' , 'TALARE' , '1' , '1' , '1' , '321' , '263.11475409836' , '22' , '3' , '379.8714' ) 01/09/2022 03:10:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19904' AND id_supplier = '143' 01/09/2022 03:10:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19904' , '143' , '1' ) 01/09/2022 03:10:57 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 ( '61115' , '19905' , 'MOZZETTA ' , '1' , '1' , '1' , '130' , '106.55737704918' , '22' , '3' , '153.8420' ) 01/09/2022 03:10:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19905' AND id_supplier = '143' 01/09/2022 03:10:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19905' , '143' , '1' ) 01/09/2022 03:10: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 ( '61115' , '19906' , 'FASCIA' , '1' , '1' , '1' , '39' , '31.967213114754' , '22' , '3' , '46.1526' ) 01/09/2022 03:10:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19906' AND id_supplier = '143' 01/09/2022 03:10:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19906' , '143' , '1' ) 01/09/2022 03:58:02 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 ( '32' , '22V604012' , '2022-08-31' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '5.23' , '4' , '0' , '0' , '0' , '' , '11' , '0' , '181.80' , '181.80' , NOW() , NOW() ) 01/09/2022 03:58: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 = '61116' 01/09/2022 03:58:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '61116' 01/09/2022 03:58: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 ( '61116' , '19684' , 'AMEN - SET. 2022' , '2' , '0' , '4' , '3.9000' , '3.9' , '0' , '33' , '5.23' ) 01/09/2022 03:58:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19684' AND id_supplier = '7' 01/09/2022 03:58:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19684' , '7' , '1' ) 01/09/2022 03:58: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 ( '61116' , '18298' , 'SAN GIUSEPPE - F. ROSINI' , '1' , '0' , '4' , '14.0000' , '14' , '0' , '33' , '9.38' ) 01/09/2022 03:58:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18298' AND id_supplier = '7' 01/09/2022 03:58:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18298' , '7' , '1' ) 01/09/2022 03:58: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 ( '61116' , '19812' , 'IO SONO LA POLVERE - GIOVANNI PAOLO I' , '1' , '0' , '4' , '39.0000' , '39' , '0' , '33' , '26.13' ) 01/09/2022 03:58:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19812' AND id_supplier = '7' 01/09/2022 03:58:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19812' , '7' , '1' ) 01/09/2022 03:58: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 ( '61116' , '19143' , 'BIBBIA SCRUTATE - TASC.' , '1' , '0' , '4' , '33.0000' , '33' , '0' , '33' , '22.11' ) 01/09/2022 03:58:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19143' AND id_supplier = '7' 01/09/2022 03:58:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19143' , '7' , '1' ) 01/09/2022 03:58: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 ( '61116' , '19156' , 'CARMEN HERNANDEZ - A. CAYUELA' , '1' , '0' , '4' , '20.0000' , '20' , '0' , '33' , '13.40' ) 01/09/2022 03:58:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19156' AND id_supplier = '7' 01/09/2022 03:58:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19156' , '7' , '1' ) 01/09/2022 03:58: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 ( '61116' , '19894' , 'NON HO FATTO NIENTE DI MALE - C. DALLARI' , '1' , '0' , '4' , '9.0000' , '9' , '0' , '30' , '6.30' ) 01/09/2022 03:58:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19894' AND id_supplier = '7' 01/09/2022 03:58:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19894' , '7' , '1' ) 01/09/2022 03:58: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 ( '61116' , '19900' , 'DIO VUOLE AMORE - C.M. MARTINI' , '1' , '0' , '4' , '12.0000' , '12' , '0' , '33' , '8.04' ) 01/09/2022 03:58:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19900' AND id_supplier = '7' 01/09/2022 03:58:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19900' , '7' , '1' ) 01/09/2022 03:58: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 ( '61116' , '19892' , 'SALVE, REGINA - S. HAHN' , '1' , '0' , '4' , '10.0000' , '10' , '0' , '30' , '7.00' ) 01/09/2022 03:58:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19892' AND id_supplier = '7' 01/09/2022 03:58:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19892' , '7' , '1' ) 01/09/2022 03:58: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 ( '61116' , '19893' , 'SECONDA LETTERA AI CORINZI - L. MONARI' , '1' , '0' , '4' , '15.0000' , '15' , '0' , '30' , '10.50' ) 01/09/2022 03:58:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19893' AND id_supplier = '7' 01/09/2022 03:58:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19893' , '7' , '1' ) 01/09/2022 03:58: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 ( '61116' , '19902' , 'NON DIMENTICATE IL DESIDERIO - ANASTASIO/CORRADI' , '1' , '0' , '4' , '16.0000' , '16' , '0' , '33' , '10.72' ) 01/09/2022 03:58:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19902' AND id_supplier = '7' 01/09/2022 03:58:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19902' , '7' , '1' ) 01/09/2022 03:58: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 ( '61116' , '19899' , 'SORRISO DEL PAPA - A. PREZIOSI' , '1' , '0' , '4' , '22.0000' , '22' , '0' , '33' , '14.74' ) 01/09/2022 03:58:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19899' AND id_supplier = '7' 01/09/2022 03:58:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19899' , '7' , '1' ) 01/09/2022 03:58: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 ( '61116' , '19901' , 'CHIARA - M. BARTOLI' , '1' , '0' , '4' , '18.0000' , '18' , '0' , '33' , '12.06' ) 01/09/2022 03:58:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19901' AND id_supplier = '7' 01/09/2022 03:58:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19901' , '7' , '1' ) 01/09/2022 03:58: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 ( '61116' , '19897' , 'VISIONI E LOCUZIONI INTERIORI - A. MANIGLIA' , '1' , '0' , '4' , '7.9000' , '7.9' , '0' , '33' , '5.29' ) 01/09/2022 03:58:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19897' AND id_supplier = '7' 01/09/2022 03:58:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19897' , '7' , '1' ) 01/09/2022 03:58: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 ( '61116' , '19895' , 'MOTIPLICAZIONE DI BENI - A .SARTO' , '1' , '0' , '4' , '7.9000' , '7.9' , '0' , '33' , '5.29' ) 01/09/2022 03:58:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19895' AND id_supplier = '7' 01/09/2022 03:58:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19895' , '7' , '1' ) 01/09/2022 03:58:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61116' , '19898' , 'VOLI E LEVITAZIONI - L. CRIPPA' , '1' , '0' , '4' , '7.9000' , '7.9' , '0' , '33' , '5.29' ) 01/09/2022 03:58:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19898' AND id_supplier = '7' 01/09/2022 03:58:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19898' , '7' , '1' ) 01/09/2022 03:58:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61116' , '19896' , 'MIRACOLI EUCARISTICI - L . CRIPPA' , '1' , '0' , '4' , '7.9000' , '7.9' , '0' , '33' , '5.29' ) 01/09/2022 03:58:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19896' AND id_supplier = '7' 01/09/2022 03:58:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19896' , '7' , '1' ) 01/09/2022 03:58:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61116' , '19891' , 'FATTI PER LETERNITA - FULTON SHEEN' , '1' , '0' , '4' , '14.0000' , '14' , '0' , '30' , '9.80' ) 01/09/2022 03:58:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19891' AND id_supplier = '7' 01/09/2022 03:58:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19891' , '7' , '1' ) 01/09/2022 04:37:30 pm >> SELECT document_num FROM ps_document WHERE document_num = '2594' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-01') 01/09/2022 04:37:30 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' , '2594' , '2022-09-01' , '' , '' , '' , '' , 'PIAZZA MATTEOTTI 2 84121 SALERNO' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '390.00' , '319.67' , NOW() , NOW() ) 01/09/2022 04:37:30 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 = '61117' 01/09/2022 04:37:30 pm >> DELETE FROM ps_document_detail WHERE id_document = '61117' 01/09/2022 04:37:30 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 ( '61117' , '16276' , 'PIZZO SU RASO MARIANO - P439' , '6' , '-6' , '1' , '29.0000' , '23.7705' , '22' , '0' , '174.00' ) 01/09/2022 04:37:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16276' AND id_supplier = '' 01/09/2022 04:37:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16276' , '' , '1' ) 01/09/2022 04:37:30 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 ( '61117' , '918' , 'BALZA RICAMATA - VIOLA - CM 16 - KOM/030 ' , '2' , '-2' , '1' , '30.0000' , '24.5902' , '22' , '0' , '72.00' ) 01/09/2022 04:37:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '918' AND id_supplier = '' 01/09/2022 04:37:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '918' , '' , '1' ) 01/09/2022 04:37:30 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 ( '61117' , '925' , 'BALZA RICAMATA ROSSA - CM 16 - KOM/030 ' , '2' , '-2' , '1' , '30.0000' , '24.5902' , '22' , '0' , '72.00' ) 01/09/2022 04:37:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '925' AND id_supplier = '' 01/09/2022 04:37:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '925' , '' , '1' ) 01/09/2022 04:37:30 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 ( '61117' , '916' , 'BALZA RICAMATA - BIANCA - CM 16 - KOM/030' , '2' , '-2' , '1' , '30.0000' , '24.5902' , '22' , '0' , '72.00' ) 01/09/2022 04:37:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '916' AND id_supplier = '' 01/09/2022 04:37:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '916' , '' , '1' ) 01/09/2022 04:38:16 pm >> DELETE FROM ps_document WHERE id_document = '59889' 01/09/2022 04:38:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '59889' 01/09/2022 04:56:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '2595' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-01') 01/09/2022 04:56:01 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' , '2595' , '2022-09-01' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '24.80' , '22.38' , NOW() , NOW() ) 01/09/2022 04:56:01 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 = '61118' 01/09/2022 04:56:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '61118' 01/09/2022 04:56:01 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 ( '61118' , '1914' , 'CERA DELLA LITURGIA' , '1' , '-1' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '4.90' ) 01/09/2022 04:56:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 01/09/2022 04:56:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 01/09/2022 04:56:01 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 ( '61118' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.50' , '6.9672131147541' , '22' , '0' , '8.50' ) 01/09/2022 04:56:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11384' AND id_supplier = '' 01/09/2022 04:56:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11384' , '' , '1' ) 01/09/2022 04:56:01 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 ( '61118' , '15019' , 'PREGHIAMO CON MARIA' , '15' , '-15' , '4' , '0.80' , '0.8' , '0' , '5' , '11.40' ) 01/09/2022 04:56:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15019' AND id_supplier = '' 01/09/2022 04:56:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15019' , '' , '1' ) 01/09/2022 04:57:49 pm >> SELECT document_num FROM ps_document WHERE document_num = '2596' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-01') 01/09/2022 04:57:49 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' , '2596' , '2022-09-01' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '24.50' , '21.89' , NOW() , NOW() ) 01/09/2022 04:57:49 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 = '61119' 01/09/2022 04:57:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '61119' 01/09/2022 04:57:49 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 ( '61119' , '9133' , 'ROSARIO LEGNO ADDOLORATA - 01002 - 25' , '1' , '-1' , '1' , '9.00' , '7.3770491803279' , '22' , '0' , '9.00' ) 01/09/2022 04:57:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9133' AND id_supplier = '' 01/09/2022 04:57:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9133' , '' , '1' ) 01/09/2022 04:57:49 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 ( '61119' , '7104' , 'NOVENA A SAN MICHELE ARCANGELO - 8196' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '0' , '1.50' ) 01/09/2022 04:57:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7104' AND id_supplier = '' 01/09/2022 04:57:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7104' , '' , '1' ) 01/09/2022 04:57:49 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 ( '61119' , '9095' , 'ROSARIO DEI SETTE DOLORI DELLA VERGINE - 8140' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '0' , '3.00' ) 01/09/2022 04:57:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9095' AND id_supplier = '' 01/09/2022 04:57:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9095' , '' , '1' ) 01/09/2022 04:57:49 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 ( '61119' , '19486' , 'ROSARIO PER LA PACE - N. SANTILLI' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '0' , '2.50' ) 01/09/2022 04:57:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19486' AND id_supplier = '' 01/09/2022 04:57:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19486' , '' , '1' ) 01/09/2022 04:57:50 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 ( '61119' , '19487' , 'ROSARIO - R. LUPI' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '0' , '3.00' ) 01/09/2022 04:57:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19487' AND id_supplier = '' 01/09/2022 04:57:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19487' , '' , '1' ) 01/09/2022 04:57:50 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 ( '61119' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '5' , '-5' , '1' , '1.10' , '0.9016393442623' , '22' , '0' , '5.50' ) 01/09/2022 04:57:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18122' AND id_supplier = '' 01/09/2022 04:57:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18122' , '' , '1' ) 01/09/2022 05:24:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '2597' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-01') 01/09/2022 05:24:19 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2597' , '2022-09-01' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.20' , '15.20' , NOW() , NOW() ) 01/09/2022 05:24:19 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61120' 01/09/2022 05:24:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '61120' 01/09/2022 05:24:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61120' , '19588' , 'SCELTA DI ENEA - L. EPICOCO' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 01/09/2022 05:24:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19588' AND id_supplier = '' 01/09/2022 05:24:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19588' , '' , '1' ) 01/09/2022 05:25:05 pm >> SELECT document_num FROM ps_document WHERE document_num = '2598' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-01') 01/09/2022 05:25:05 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' , '2598' , '2022-09-01' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '18.05' , '18.05' , NOW() , NOW() ) 01/09/2022 05:25:05 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 = '61121' 01/09/2022 05:25:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '61121' 01/09/2022 05:25:05 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 ( '61121' , '17875' , 'VITA COME FINE DEL MONDO - L. M. EPICOCO' , '1' , '-1' , '4' , '19.00' , '19' , '0' , '5' , '18.05' ) 01/09/2022 05:25:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17875' AND id_supplier = '' 01/09/2022 05:25:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17875' , '' , '1' ) 01/09/2022 05:27:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '2373' AND id_document != '59814' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-27') 01/09/2022 05:27:19 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2373', document_date = '2022-07-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 = '125.90', price_tax_excluded = '108.33', date_upd = NOW() WHERE id_document = '59814' 01/09/2022 05:27:19 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '59814' 01/09/2022 05:27:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '59814' 01/09/2022 05:27:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59814' , '19805' , 'DESIDERIO DESIDERAVI' , '1' , '-1' , '4' , '1.97' , '1.97' , '0' , '0' , '1.97' ) 01/09/2022 05:27:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19805' AND id_supplier = '' 01/09/2022 05:27:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19805' , '' , '1' ) 01/09/2022 05:27:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59814' , '7311' , 'OSTIA SOTTILE 74MM' , '5' , '-5' , '3' , '1.9000' , '1.8269230769231' , '4' , '0' , '9.50' ) 01/09/2022 05:27:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 01/09/2022 05:27:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 01/09/2022 05:27:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59814' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '6' , '-6' , '1' , '6.5000' , '5.327868852459' , '22' , '0' , '39.00' ) 01/09/2022 05:27:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11757' AND id_supplier = '' 01/09/2022 05:27:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11757' , '' , '1' ) 01/09/2022 05:27:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59814' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '56.40' ) 01/09/2022 05:27:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 01/09/2022 05:27:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 01/09/2022 05:27:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59814' , '12808' , 'OMELIE PER LE ESEQUIE' , '1' , '-1' , '4' , '9.5000' , '9.5' , '0' , '5' , '9.03' ) 01/09/2022 05:27:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12808' AND id_supplier = '' 01/09/2022 05:27:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12808' , '' , '1' ) 01/09/2022 05:27:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59814' , '19622' , 'SULLA TUA PAROLA - SETT/OTT 2022' , '2' , '-2' , '4' , '5.0000' , '5' , '0' , '0' , '10.00' ) 01/09/2022 05:27:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19622' AND id_supplier = '' 01/09/2022 05:27:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19622' , '' , '1' ) 01/09/2022 05:30:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '2599' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-01') 01/09/2022 05:30:59 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' , '2599' , '2022-09-01' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '139.00' , '113.93' , NOW() , NOW() ) 01/09/2022 05:30:59 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61122' 01/09/2022 05:30:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '61122' 01/09/2022 05:30: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 ( '61122' , '14354' , 'CAMICE BENEDETTINO LINO - 3010' , '1' , '-1' , '1' , '139.00' , '113.93442622951' , '22' , '0' , '139.00' ) 01/09/2022 05:30:59 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14354' AND id_supplier = '' 01/09/2022 05:30:59 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14354' , '' , '1' ) 01/09/2022 05:31:18 pm >> SELECT document_num FROM ps_document WHERE document_num = '2600' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-01') 01/09/2022 05:31:18 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' , '2600' , '2022-09-01' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '34.00' , '27.87' , NOW() , NOW() ) 01/09/2022 05:31:18 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 = '61123' 01/09/2022 05:31:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '61123' 01/09/2022 05:31:18 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 ( '61123' , '2168' , 'CLERGY BASIC - ML - B&P' , '1' , '-1' , '1' , '34.00' , '27.868852459016' , '22' , '0' , '34.00' ) 01/09/2022 05:31:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2168' AND id_supplier = '' 01/09/2022 05:31:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2168' , '' , '1' ) 01/09/2022 05:39:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '2601' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-01') 01/09/2022 05:39:39 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' , '2601' , '2022-09-01' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '26.00' , '26.00' , NOW() , NOW() ) 01/09/2022 05:39:39 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 = '61124' 01/09/2022 05:39:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '61124' 01/09/2022 05:39:39 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 ( '61124' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '26' , '26' , '0' , '0' , '26.00' ) 01/09/2022 05:39:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 01/09/2022 05:39:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 01/09/2022 06:23:33 pm >> SELECT document_num FROM ps_document WHERE document_num = '2602' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-01') 01/09/2022 06:23:33 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' , '2602' , '2022-09-01' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '330.00' , '270.49' , NOW() , NOW() ) 01/09/2022 06:23:33 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 = '61125' 01/09/2022 06:23:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '61125' 01/09/2022 06:23:33 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 ( '61125' , '17408' , 'CAMICE MISTO COT. 70/001035' , '1' , '-1' , '1' , '135' , '110.65573770492' , '22' , '0' , '135.00' ) 01/09/2022 06:23:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17408' AND id_supplier = '' 01/09/2022 06:23:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17408' , '' , '1' ) 01/09/2022 06:23:33 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 ( '61125' , '14354' , 'CAMICE BENEDETTINO LINO - 3010' , '1' , '-1' , '1' , '135' , '110.65573770492' , '22' , '0' , '135.00' ) 01/09/2022 06:23:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14354' AND id_supplier = '' 01/09/2022 06:23:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14354' , '' , '1' ) 01/09/2022 06:23:33 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 ( '61125' , '14362' , 'CAMICE SVASATO ' , '1' , '-1' , '1' , '60.00' , '49.180327868852' , '22' , '0' , '60.00' ) 01/09/2022 06:23:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14362' AND id_supplier = '' 01/09/2022 06:23:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14362' , '' , '1' ) 01/09/2022 06:59:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '2603' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-01') 01/09/2022 06:59:19 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2603' , '2022-09-01' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.25' , '14.25' , NOW() , NOW() ) 01/09/2022 06:59:19 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61126' 01/09/2022 06:59:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '61126' 01/09/2022 06:59:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61126' , '19622' , 'SULLA TUA PAROLA - SETT/OTT 2022' , '3' , '-3' , '4' , '5.00' , '5' , '0' , '5' , '14.25' ) 01/09/2022 06:59:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19622' AND id_supplier = '' 01/09/2022 06:59:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19622' , '' , '1' ) 01/09/2022 07:02:56 pm >> SELECT document_num FROM ps_document WHERE document_num = '2604' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-01') 01/09/2022 07:02:56 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' , '2604' , '2022-09-01' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '45.00' , '45.00' , NOW() , NOW() ) 01/09/2022 07:02:56 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 = '61127' 01/09/2022 07:02:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '61127' 01/09/2022 07:02:56 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 ( '61127' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '45' , '45' , '0' , '0' , '45.00' ) 01/09/2022 07:02:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 01/09/2022 07:02:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 01/09/2022 07:03:29 pm >> SELECT document_num FROM ps_document WHERE document_num = '2605' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-01') 01/09/2022 07:03:29 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2605' , '2022-09-01' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '90.00' , '73.77' , NOW() , NOW() ) 01/09/2022 07:03:29 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61128' 01/09/2022 07:03:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '61128' 01/09/2022 07:03:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61128' , '7202' , 'ARTICOLI RELIGIOSI' , '2' , '-2' , '1' , '45' , '36.885245901639' , '22' , '0' , '90.00' ) 01/09/2022 07:03:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 01/09/2022 07:03:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 01/09/2022 07:10:23 pm >> SELECT document_num FROM ps_document WHERE document_num = '2606' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-01') 01/09/2022 07:10: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 ( '11' , '2606' , '2022-09-01' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '55.00' , '45.08' , NOW() , NOW() ) 01/09/2022 07:10: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 = '61129' 01/09/2022 07:10:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '61129' 01/09/2022 07:10: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 ( '61129' , '801' , 'ASTUCCIO STOPPINO - MT 2 - 117' , '1' , '-1' , '1' , '6' , '4.9180327868852' , '22' , '0' , '6.00' ) 01/09/2022 07:10:24 pm >> DELETE FROM ps_product_supplier WHERE id_product = '801' AND id_supplier = '' 01/09/2022 07:10:24 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '801' , '' , '1' ) 01/09/2022 07:10: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 ( '61129' , '1751' , 'CARTUCCIA TRASPARENTE DIAM. 4 - 455' , '2' , '-2' , '1' , '14.00' , '11.475409836066' , '22' , '0' , '28.00' ) 01/09/2022 07:10:24 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1751' AND id_supplier = '' 01/09/2022 07:10:24 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1751' , '' , '1' ) 01/09/2022 07:10: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 ( '61129' , '19213' , 'FINTA CANDELA 4X25 - 114' , '2' , '-2' , '1' , '10.50' , '8.6065573770492' , '22' , '0' , '21.00' ) 01/09/2022 07:10:24 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19213' AND id_supplier = '' 01/09/2022 07:10:24 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19213' , '' , '1' )