22/06/2022 09:02:38 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '602724' , '2022-06-17' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '2.06' , '4' , '0' , '0' , '0' , '' , '11' , '0' , '71.37' , '71.37' , NOW() , NOW() ) 22/06/2022 09:02:38 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58833' 22/06/2022 09:02:38 am >> DELETE FROM ps_document_detail WHERE id_document = '58833' 22/06/2022 09:02:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58833' , '17581' , 'MESSALE QUOTIDIANO N.E. ' , '2' , '2' , '4' , '39.00' , '39' , '0' , '33' , '52.2600' ) 22/06/2022 09:02:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '17581' AND id_supplier = '7' 22/06/2022 09:02:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17581' , '7' , '1' ) 22/06/2022 09:02: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 ( '58833' , '18163' , 'GIOCO DELLE PAROLE DI DIO' , '1' , '1' , '4' , '10.00' , '10' , '0' , '30' , '7.0000' ) 22/06/2022 09:02:39 am >> DELETE FROM ps_product_supplier WHERE id_product = '18163' AND id_supplier = '7' 22/06/2022 09:02:39 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18163' , '7' , '1' ) 22/06/2022 09:02: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 ( '58833' , '19647' , 'ANTICORPI DI PACE - TONiNO BELLO' , '1' , '1' , '4' , '15.00' , '15' , '0' , '33' , '10.0500' ) 22/06/2022 09:02:39 am >> DELETE FROM ps_product_supplier WHERE id_product = '19647' AND id_supplier = '7' 22/06/2022 09:02:39 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19647' , '7' , '1' ) 22/06/2022 09:03:10 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 22/06/2022 09:03:10 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19662' , '1' , '' , 'nuovo-prodotto' ) 22/06/2022 09:03:10 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '19662' , '1' , '1' , '2' , NOW() , NOW() ) 22/06/2022 09:03:10 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '19662' , '0' , '1' , '0' , '0' ) 22/06/2022 09:03:56 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788872984680' AND id_product != '19662' AND ean13 != '' 22/06/2022 09:03:56 am >> UPDATE ps_product SET id_supplier = '', reference = '10/2', ean13 = '9788872984680', date_upd = NOW() WHERE id_product = '19662' 22/06/2022 09:03:56 am >> UPDATE ps_product_lang SET name = 'MESSALINO QUOTIDIANO - AGO/SET/OTT 2022', description = '' WHERE id_product = '19662' 22/06/2022 09:03:56 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '5' WHERE id_product = '19662' 22/06/2022 09:03:56 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '5', id_tax_rules_group = '4', id_category_default = '29', id_argoment_default = '64', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19662' 22/06/2022 09:03:56 am >> DELETE FROM ps_specific_price WHERE id_product = '19662' 22/06/2022 09:03:59 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '19662' 22/06/2022 09:03:59 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19663' , '1' , '' , 'nuovo-prodotto' ) 22/06/2022 09:03:59 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '19663' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19662' 22/06/2022 09:03:59 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19663' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19662' 22/06/2022 09:05:36 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '602711' , '2022-06-16' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '2.94' , '4' , '0' , '0' , '0' , '' , '11' , '0' , '105.84' , '105.84' , NOW() , NOW() ) 22/06/2022 09:05:36 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 = '58834' 22/06/2022 09:05:36 am >> DELETE FROM ps_document_detail WHERE id_document = '58834' 22/06/2022 09:05:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58834' , '19662' , 'MESSALINO QUOTIDIANO - AGO/SET/OTT 2022' , '12' , '12' , '4' , '5.00' , '5' , '0' , '30' , '42.0000' ) 22/06/2022 09:05:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '19662' AND id_supplier = '7' 22/06/2022 09:05:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19662' , '7' , '1' ) 22/06/2022 09:05:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58834' , '19662' , 'MESSALINO QUOTIDIANO - AGO/SET/OTT 2022' , '1' , '1' , '4' , '5.00' , '5' , '0' , '100' , '0.0000' ) 22/06/2022 09:05:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '19662' AND id_supplier = '7' 22/06/2022 09:05:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19662' , '7' , '1' ) 22/06/2022 09:05:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58834' , '17647' , 'VANGELI E ATTI ' , '29' , '29' , '4' , '3.00' , '3' , '0' , '30' , '60.9000' ) 22/06/2022 09:05:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '17647' AND id_supplier = '7' 22/06/2022 09:05:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17647' , '7' , '1' ) 22/06/2022 09:05:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58834' , '17647' , 'VANGELI E ATTI ' , '3' , '3' , '4' , '3.00' , '3' , '0' , '100' , '0.0000' ) 22/06/2022 09:05:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '17647' AND id_supplier = '7' 22/06/2022 09:05:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17647' , '7' , '1' ) 22/06/2022 09:27:30 am >> SELECT document_num FROM ps_document WHERE document_num = '1983' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-22') 22/06/2022 09:27: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' , '1983' , '2022-06-22' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.10' , '17.10' , NOW() , NOW() ) 22/06/2022 09:27: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 = '58835' 22/06/2022 09:27:30 am >> DELETE FROM ps_document_detail WHERE id_document = '58835' 22/06/2022 09:27: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 ( '58835' , '19492' , 'GRAZIE E DISGRAZIE DELLA VITA RELIGIOSA - P. SCIADINI' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '5' , '17.10' ) 22/06/2022 09:27:31 am >> DELETE FROM ps_product_supplier WHERE id_product = '19492' AND id_supplier = '' 22/06/2022 09:27:31 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19492' , '' , '1' ) 22/06/2022 09:32:33 am >> SELECT document_num FROM ps_document WHERE document_num = '1984' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-22') 22/06/2022 09:32:33 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' , '1984' , '2022-06-22' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '35.20' , '33.85' , NOW() , NOW() ) 22/06/2022 09:32:33 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 = '58836' 22/06/2022 09:32:33 am >> DELETE FROM ps_document_detail WHERE id_document = '58836' 22/06/2022 09:32:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58836' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '5' , '-5' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '17.50' ) 22/06/2022 09:32:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 22/06/2022 09:32:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 22/06/2022 09:32:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58836' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '3' , '-3' , '3' , '4.00' , '3.8461538461538' , '4' , '0' , '12.00' ) 22/06/2022 09:32:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '16691' AND id_supplier = '' 22/06/2022 09:32:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16691' , '' , '1' ) 22/06/2022 09:32: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 ( '58836' , '7311' , 'OSTIA SOTTILE 74MM' , '3' , '-3' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '5.70' ) 22/06/2022 09:32:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 22/06/2022 09:32:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 22/06/2022 09:35:23 am >> SELECT document_num FROM ps_document WHERE document_num = '1985' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-22') 22/06/2022 09:35:23 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' , '1985' , '2022-06-22' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '110.80' , '94.57' , NOW() , NOW() ) 22/06/2022 09:35:23 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 = '58837' 22/06/2022 09:35:23 am >> DELETE FROM ps_document_detail WHERE id_document = '58837' 22/06/2022 09:35:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58837' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3' , '2.4590163934426' , '22' , '0' , '90.00' ) 22/06/2022 09:35:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '5903' AND id_supplier = '' 22/06/2022 09:35:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5903' , '' , '1' ) 22/06/2022 09:35:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58837' , '11151' , 'LIBRI' , '8' , '-8' , '4' , '2.6' , '2.6' , '0' , '0' , '20.80' ) 22/06/2022 09:35:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 22/06/2022 09:35:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 22/06/2022 10:09:32 am >> SELECT document_num FROM ps_document WHERE document_num = '1986' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-22') 22/06/2022 10:09:33 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' , '1986' , '2022-06-22' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.30' , '10.90' , NOW() , NOW() ) 22/06/2022 10:09:33 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 = '58838' 22/06/2022 10:09:33 am >> DELETE FROM ps_document_detail WHERE id_document = '58838' 22/06/2022 10:09:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58838' , '1312' , 'BRACCIALE DECINA' , '1' , '-1' , '1' , '1.30' , '1.0655737704918' , '22' , '0' , '1.30' ) 22/06/2022 10:09:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '1312' AND id_supplier = '' 22/06/2022 10:09:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1312' , '' , '1' ) 22/06/2022 10:09:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58838' , '583' , 'ANELLO FEDINA IN ARG. 925 - M043/024' , '1' , '-1' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '12.00' ) 22/06/2022 10:09:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '583' AND id_supplier = '' 22/06/2022 10:09:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '583' , '' , '1' ) 22/06/2022 10:26:25 am >> SELECT document_num FROM ps_document WHERE document_num = '1987' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-22') 22/06/2022 10:26:25 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' , '1987' , '2022-06-22' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.00' , '0.82' , NOW() , NOW() ) 22/06/2022 10:26:25 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 = '58839' 22/06/2022 10:26:25 am >> DELETE FROM ps_document_detail WHERE id_document = '58839' 22/06/2022 10:26:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58839' , '18213' , 'BRACCIALE CROCI COLORATO - BC569' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 22/06/2022 10:26:25 am >> DELETE FROM ps_product_supplier WHERE id_product = '18213' AND id_supplier = '' 22/06/2022 10:26:25 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18213' , '' , '1' ) 22/06/2022 10:30:41 am >> SELECT document_num FROM ps_document WHERE document_num = '1988' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-22') 22/06/2022 10:30: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' , '1988' , '2022-06-22' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '35.15' , '35.15' , NOW() , NOW() ) 22/06/2022 10:30: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 = '58840' 22/06/2022 10:30:41 am >> DELETE FROM ps_document_detail WHERE id_document = '58840' 22/06/2022 10:30: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 ( '58840' , '11882' , '365 GIORNI CON LA BIBBIA - 8827' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '5' , '19.00' ) 22/06/2022 10:30:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '11882' AND id_supplier = '' 22/06/2022 10:30:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11882' , '' , '1' ) 22/06/2022 10:30:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58840' , '10712' , 'TRATTATO DELLA VERA DEVOZIONE A MARIA - 8113' , '1' , '-1' , '4' , '7.00' , '7' , '0' , '5' , '6.65' ) 22/06/2022 10:30:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '10712' AND id_supplier = '' 22/06/2022 10:30:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10712' , '' , '1' ) 22/06/2022 10:30:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58840' , '4699' , 'GLORIE DI MARIA - 8243' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 22/06/2022 10:30:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '4699' AND id_supplier = '' 22/06/2022 10:30:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4699' , '' , '1' ) 22/06/2022 10:45:07 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884047502' AND id_product != '19581' AND ean13 != '' 22/06/2022 10:45:07 am >> UPDATE ps_product SET id_supplier = '38', reference = '11/2', ean13 = '9788884047502', date_upd = NOW() WHERE id_product = '19581' 22/06/2022 10:45:07 am >> UPDATE ps_product_lang SET name = 'SACRA BIBBIA - 8055', description = '' WHERE id_product = '19581' 22/06/2022 10:45:07 am >> UPDATE ps_product SET wholesale_price = '15.00', on_sale = '0', price = '25.0000' WHERE id_product = '19581' 22/06/2022 10:45:07 am >> UPDATE ps_product_shop SET wholesale_price = '15.00', price = '25.0000', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '170', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19581' 22/06/2022 10:45:07 am >> DELETE FROM ps_specific_price WHERE id_product = '19581' 22/06/2022 11:00:56 am >> SELECT document_num FROM ps_document WHERE document_num = '1989' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-22') 22/06/2022 11:00:56 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' , '1989' , '2022-06-22' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '134.20' , '111.62' , NOW() , NOW() ) 22/06/2022 11:00:56 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 = '58841' 22/06/2022 11:00:56 am >> DELETE FROM ps_document_detail WHERE id_document = '58841' 22/06/2022 11:00:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58841' , '7311' , 'OSTIA SOTTILE 74MM' , '6' , '-6' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '11.40' ) 22/06/2022 11:00:56 am >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 22/06/2022 11:00:56 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 22/06/2022 11:00:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58841' , '1914' , 'CERA DELLA LITURGIA' , '24' , '-24' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '112.80' ) 22/06/2022 11:00:56 am >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 22/06/2022 11:00:56 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 22/06/2022 11:00:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58841' , '17277' , 'BRACCIALE PIETRE DURE - 4633' , '2' , '-2' , '1' , '5' , '4.0983606557377' , '22' , '0' , '10.00' ) 22/06/2022 11:00:56 am >> DELETE FROM ps_product_supplier WHERE id_product = '17277' AND id_supplier = '' 22/06/2022 11:00:56 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17277' , '' , '1' ) 22/06/2022 11:10:11 am >> SELECT document_num FROM ps_document WHERE document_num = '1990' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-22') 22/06/2022 11:10: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' , '1990' , '2022-06-22' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '86.34' , '84.63' , NOW() , NOW() ) 22/06/2022 11:10: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 = '58842' 22/06/2022 11:10:11 am >> DELETE FROM ps_document_detail WHERE id_document = '58842' 22/06/2022 11:10: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 ( '58842' , '15020' , 'PREGARE OGNI GIORNO' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 22/06/2022 11:10:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '15020' AND id_supplier = '' 22/06/2022 11:10:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15020' , '' , '1' ) 22/06/2022 11:10: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 ( '58842' , '16265' , 'MIE PREGHIERE' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 22/06/2022 11:10:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '16265' AND id_supplier = '' 22/06/2022 11:10:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16265' , '' , '1' ) 22/06/2022 11:10:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58842' , '19481' , 'UN DIO CHE MUORE - P. CURTAZ' , '1' , '-1' , '4' , '9.90' , '9.9' , '0' , '5' , '9.41' ) 22/06/2022 11:10:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '19481' AND id_supplier = '' 22/06/2022 11:10:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19481' , '' , '1' ) 22/06/2022 11:10:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58842' , '19326' , 'sul dolore - p. curtaz' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 22/06/2022 11:10:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '19326' AND id_supplier = '' 22/06/2022 11:10:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19326' , '' , '1' ) 22/06/2022 11:10:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58842' , '18446' , 'MIA BIBBIA MORBIDA' , '1' , '-1' , '4' , '11.90' , '11.9' , '0' , '5' , '11.31' ) 22/06/2022 11:10:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '18446' AND id_supplier = '' 22/06/2022 11:10:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18446' , '' , '1' ) 22/06/2022 11:10:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58842' , '17583' , 'FRATELLI TUTTI' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '5' , '2.76' ) 22/06/2022 11:10:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '17583' AND id_supplier = '' 22/06/2022 11:10:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17583' , '' , '1' ) 22/06/2022 11:10:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58842' , '13648' , 'BIOTESTAMENTO' , '1' , '-1' , '4' , '0.90' , '0.9' , '0' , '0' , '0.90' ) 22/06/2022 11:10:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '13648' AND id_supplier = '' 22/06/2022 11:10:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13648' , '' , '1' ) 22/06/2022 11:10:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58842' , '1905' , 'CENTESIMUS ANNUS - GIOV. PAOLO II' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '0' , '1.50' ) 22/06/2022 11:10:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '1905' AND id_supplier = '' 22/06/2022 11:10:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1905' , '' , '1' ) 22/06/2022 11:10:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58842' , '9505' , 'SAN PIO X - M.CARMINATI' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 22/06/2022 11:10:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '9505' AND id_supplier = '' 22/06/2022 11:10:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9505' , '' , '1' ) 22/06/2022 11:10:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58842' , '1035' , 'BENEDETTO XV - M. DABRIZIO' , '1' , '-1' , '4' , '4.00' , '4' , '0' , '5' , '3.80' ) 22/06/2022 11:10:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '1035' AND id_supplier = '' 22/06/2022 11:10:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1035' , '' , '1' ) 22/06/2022 11:10:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58842' , '8041' , 'PIO XII IL PAPA DELLA CARITÀ - E. ARTIGLIERI' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 22/06/2022 11:10:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '8041' AND id_supplier = '' 22/06/2022 11:10:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8041' , '' , '1' ) 22/06/2022 11:10:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58842' , '9630' , 'SANTI FILIPPO E GIACOMO APOSTOLI - A. GOVERNALE' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 22/06/2022 11:10:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '9630' AND id_supplier = '' 22/06/2022 11:10:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9630' , '' , '1' ) 22/06/2022 11:10:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58842' , '9471' , 'SAN LORENZO MARTIRE - G.PESENTI' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 22/06/2022 11:10:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '9471' AND id_supplier = '' 22/06/2022 11:10:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9471' , '' , '1' ) 22/06/2022 11:10:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58842' , '16065' , 'DIZIONARIO DEI SIMBOLI DEL CRISTIANO' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '5' , '2.38' ) 22/06/2022 11:10:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '16065' AND id_supplier = '' 22/06/2022 11:10:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16065' , '' , '1' ) 22/06/2022 11:10:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58842' , '18658' , 'PICCOLO DIZIONARIO DEL CRISTIANO' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 22/06/2022 11:10:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '18658' AND id_supplier = '' 22/06/2022 11:10:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18658' , '' , '1' ) 22/06/2022 11:10:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58842' , '19420' , 'PREGO ANCHE IO ' , '1' , '-1' , '4' , '1.90' , '1.9' , '0' , '0' , '1.90' ) 22/06/2022 11:10:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '19420' AND id_supplier = '' 22/06/2022 11:10:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19420' , '' , '1' ) 22/06/2022 11:10:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58842' , '10279' , 'STORIA DELLA SALVEZZA RACCONTATA AI BAMBINI 2' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 22/06/2022 11:10:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '10279' AND id_supplier = '' 22/06/2022 11:10:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10279' , '' , '1' ) 22/06/2022 11:10:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58842' , '14162' , 'DIECI COMANDAMENTI' , '1' , '-1' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '1.50' ) 22/06/2022 11:10:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '14162' AND id_supplier = '' 22/06/2022 11:10:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14162' , '' , '1' ) 22/06/2022 11:10:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58842' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '3.5' , '3.5' , '0' , '0' , '3.50' ) 22/06/2022 11:10:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 22/06/2022 11:10:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 22/06/2022 11:10:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58842' , '17277' , 'BRACCIALE PIETRE DURE - 4633' , '1' , '-1' , '1' , '5.50' , '4.5081967213115' , '22' , '0' , '5.50' ) 22/06/2022 11:10:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '17277' AND id_supplier = '' 22/06/2022 11:10:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17277' , '' , '1' ) 22/06/2022 11:10:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58842' , '14777' , 'DECINA LEGNO CON LACCIO' , '1' , '-1' , '1' , '1.31' , '1.0737704918033' , '22' , '0' , '1.31' ) 22/06/2022 11:10:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '14777' AND id_supplier = '' 22/06/2022 11:10:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14777' , '' , '1' ) 22/06/2022 11:10:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58842' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '4' , '4' , '0' , '0' , '4.00' ) 22/06/2022 11:10:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 22/06/2022 11:10:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 22/06/2022 11:10:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58842' , '1319' , 'BRACCIALE DECINA TAU' , '1' , '-1' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '1.20' ) 22/06/2022 11:10:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '1319' AND id_supplier = '' 22/06/2022 11:10:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1319' , '' , '1' ) 22/06/2022 11:13:49 am >> SELECT document_num FROM ps_document WHERE document_num = '1991' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-22') 22/06/2022 11:13:49 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' , '1991' , '2022-06-22' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '38.50' , '36.70' , NOW() , NOW() ) 22/06/2022 11:13:49 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 = '58843' 22/06/2022 11:13:49 am >> DELETE FROM ps_document_detail WHERE id_document = '58843' 22/06/2022 11:13: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 ( '58843' , '19467' , 'SULLA TUA PAROLA - LUG/AGO 2022' , '6' , '-6' , '4' , '5.00' , '5' , '0' , '5' , '28.50' ) 22/06/2022 11:13:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '19467' AND id_supplier = '' 22/06/2022 11:13:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19467' , '' , '1' ) 22/06/2022 11:13: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 ( '58843' , '18130' , 'TAU GRANDE CM 4 - T9' , '10' , '-10' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '10.00' ) 22/06/2022 11:13:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '18130' AND id_supplier = '' 22/06/2022 11:13:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18130' , '' , '1' ) 22/06/2022 11:24:12 am >> SELECT document_num FROM ps_document WHERE document_num = '1992' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-22') 22/06/2022 11:24:12 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1992' , '2022-06-22' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '67.60' , '67.60' , NOW() , NOW() ) 22/06/2022 11:24:12 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58844' 22/06/2022 11:24:12 am >> DELETE FROM ps_document_detail WHERE id_document = '58844' 22/06/2022 11:24:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58844' , '18797' , 'PROFUMO DELLE RELAZIONI - SALVO NOE' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '5' , '17.10' ) 22/06/2022 11:24:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '18797' AND id_supplier = '' 22/06/2022 11:24:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18797' , '' , '1' ) 22/06/2022 11:24:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58844' , '17685' , 'MISTERO DEL DOLORE - CEI' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '5' , '7.60' ) 22/06/2022 11:24:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '17685' AND id_supplier = '' 22/06/2022 11:24:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17685' , '' , '1' ) 22/06/2022 11:24:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58844' , '15925' , 'DIAMO CORDA ALLAMORE - R. BONETTI' , '1' , '-1' , '4' , '13.00' , '13' , '0' , '5' , '12.35' ) 22/06/2022 11:24:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '15925' AND id_supplier = '' 22/06/2022 11:24:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15925' , '' , '1' ) 22/06/2022 11:24:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58844' , '16872' , 'INCARNATI NELLAMORE - C. A. GALLAGHER' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 22/06/2022 11:24:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '16872' AND id_supplier = '' 22/06/2022 11:24:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16872' , '' , '1' ) 22/06/2022 11:24:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58844' , '3965' , 'EUCARISTIA CORPO DI CRISTO - POSTER' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 22/06/2022 11:24:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '3965' AND id_supplier = '' 22/06/2022 11:24:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3965' , '' , '1' ) 22/06/2022 11:24:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58844' , '9321' , 'SACRAMENTO DELLA RICONCILIAZIONE - POSTER' , '1' , '-1' , '4' , '1.80' , '1.8' , '0' , '0' , '1.80' ) 22/06/2022 11:24:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '9321' AND id_supplier = '' 22/06/2022 11:24:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9321' , '' , '1' ) 22/06/2022 11:24:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58844' , '14805' , 'BATTESIMO - POSTER' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '0' , '3.00' ) 22/06/2022 11:24:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '14805' AND id_supplier = '' 22/06/2022 11:24:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14805' , '' , '1' ) 22/06/2022 11:24:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58844' , '19578' , 'MATRIMONIO? SOLO PER CHI SA AMARE - GIUSTI' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 22/06/2022 11:24:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '19578' AND id_supplier = '' 22/06/2022 11:24:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19578' , '' , '1' ) 22/06/2022 11:25:27 am >> SELECT document_num FROM ps_document WHERE document_num = '1993' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-22') 22/06/2022 11:25:27 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1993' , '2022-06-22' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '16.00' , '13.11' , NOW() , NOW() ) 22/06/2022 11:25:27 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58845' 22/06/2022 11:25:27 am >> DELETE FROM ps_document_detail WHERE id_document = '58845' 22/06/2022 11:25:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58845' , '19106' , 'FRAGRANZA NARDO' , '1' , '-1' , '1' , '16.00' , '13.114754098361' , '22' , '0' , '16.00' ) 22/06/2022 11:25:27 am >> DELETE FROM ps_product_supplier WHERE id_product = '19106' AND id_supplier = '' 22/06/2022 11:25:27 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19106' , '' , '1' ) 22/06/2022 12:00:35 pm >> SELECT document_num FROM ps_document WHERE document_num = '1994' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-22') 22/06/2022 12:00:35 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1994' , '2022-06-22' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '18.00' , '18.00' , NOW() , NOW() ) 22/06/2022 12:00:35 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58846' 22/06/2022 12:00:35 pm >> DELETE FROM ps_document_detail WHERE id_document = '58846' 22/06/2022 12:00:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58846' , '19631' , 'DONO DAMORE - M.L. KING' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '0' , '18.00' ) 22/06/2022 12:00:35 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19631' AND id_supplier = '' 22/06/2022 12:00:35 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19631' , '' , '1' ) 22/06/2022 12:04:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '1995' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-22') 22/06/2022 12:04:17 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' , '1995' , '2022-06-22' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '119.00' , '103.36' , NOW() , NOW() ) 22/06/2022 12:04:17 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 = '58847' 22/06/2022 12:04:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '58847' 22/06/2022 12:04:17 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 ( '58847' , '16689' , 'OSTIA PAN DI CENA mm80' , '3' , '-3' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '6.00' ) 22/06/2022 12:04:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = '' 22/06/2022 12:04:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '' , '1' ) 22/06/2022 12:04:17 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 ( '58847' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '10' , '-10' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '35.00' ) 22/06/2022 12:04:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 22/06/2022 12:04:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 22/06/2022 12:04:17 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 ( '58847' , '791' , 'ASSISI IN BUSTA BATTESIMO - 20X270 - BAAS' , '20' , '-20' , '1' , '1.40' , '1.1475409836066' , '22' , '0' , '28.00' ) 22/06/2022 12:04:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '791' AND id_supplier = '' 22/06/2022 12:04:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '791' , '' , '1' ) 22/06/2022 12:04:17 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 ( '58847' , '15387' , 'VESTINA BATTESIMALE ' , '20' , '-20' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '50.00' ) 22/06/2022 12:04:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15387' AND id_supplier = '' 22/06/2022 12:04:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15387' , '' , '1' ) 22/06/2022 12:13:08 pm >> SELECT document_num FROM ps_document WHERE document_num = '1996' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-22') 22/06/2022 12:13:08 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' , '1996' , '2022-06-22' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '50.00' , '40.98' , NOW() , NOW() ) 22/06/2022 12:13:08 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58848' 22/06/2022 12:13:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '58848' 22/06/2022 12:13:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58848' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '50' , '40.983606557377' , '22' , '0' , '50.00' ) 22/06/2022 12:13:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 22/06/2022 12:13:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 22/06/2022 12:14:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '1997' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-22') 22/06/2022 12:14:04 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1997' , '2022-06-22' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.50' , '4.51' , NOW() , NOW() ) 22/06/2022 12:14:04 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58849' 22/06/2022 12:14:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '58849' 22/06/2022 12:14: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 ( '58849' , '11756' , 'VINO BIANCO SECCO - 14%' , '1' , '-1' , '1' , '5.50' , '4.5081967213115' , '22' , '0' , '5.50' ) 22/06/2022 12:14:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11756' AND id_supplier = '' 22/06/2022 12:14:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11756' , '' , '1' ) 22/06/2022 12:16:44 pm >> SELECT document_num FROM ps_document WHERE document_num = '1998' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-22') 22/06/2022 12:16:44 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' , '1998' , '2022-06-22' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '50.00' , '40.98' , NOW() , NOW() ) 22/06/2022 12:16:44 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58850' 22/06/2022 12:16:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '58850' 22/06/2022 12:16:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58850' , '17160' , 'CARBONCINI ROSSI - CARRO' , '2' , '-2' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '20.00' ) 22/06/2022 12:16:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17160' AND id_supplier = '' 22/06/2022 12:16:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17160' , '' , '1' ) 22/06/2022 12:16:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58850' , '19107' , 'INCENSO GRANI 3A' , '1' , '-1' , '1' , '30.00' , '24.590163934426' , '22' , '0' , '30.00' ) 22/06/2022 12:16:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19107' AND id_supplier = '' 22/06/2022 12:16:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19107' , '' , '1' ) 22/06/2022 12:19:57 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892227910' AND id_product != '19326' AND ean13 != '' 22/06/2022 12:19:57 pm >> UPDATE ps_product SET id_supplier = '7', reference = '7/5', ean13 = '9788892227910', date_upd = NOW() WHERE id_product = '19326' 22/06/2022 12:19:57 pm >> UPDATE ps_product_lang SET name = 'SUL DOLORE - P. CURTAZ', description = '' WHERE id_product = '19326' 22/06/2022 12:19:57 pm >> UPDATE ps_product SET wholesale_price = '10.72', on_sale = '0', price = '16.0000' WHERE id_product = '19326' 22/06/2022 12:19:57 pm >> UPDATE ps_product_shop SET wholesale_price = '10.72', price = '16.0000', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '23', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19326' 22/06/2022 12:19:57 pm >> DELETE FROM ps_specific_price WHERE id_product = '19326' 22/06/2022 12:33:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '1999' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-22') 22/06/2022 12:33:26 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' , '1999' , '2022-06-22' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '110.00' , '90.16' , NOW() , NOW() ) 22/06/2022 12:33:26 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 = '58851' 22/06/2022 12:33:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '58851' 22/06/2022 12:33:26 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 ( '58851' , '16964' , 'PALLA IN S/MOIRE - 7985M' , '1' , '-1' , '1' , '62.00' , '50.819672131148' , '22' , '0' , '62.00' ) 22/06/2022 12:33:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16964' AND id_supplier = '' 22/06/2022 12:33:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16964' , '' , '1' ) 22/06/2022 12:33:26 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 ( '58851' , '15893' , 'CINGOLO - CING17' , '1' , '-1' , '1' , '48.00' , '39.344262295082' , '22' , '0' , '48.00' ) 22/06/2022 12:33:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15893' AND id_supplier = '' 22/06/2022 12:33:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15893' , '' , '1' ) 22/06/2022 12:39:54 pm >> SELECT document_num FROM ps_document WHERE document_num = '2000' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-22') 22/06/2022 12:39:54 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' , '2000' , '2022-06-22' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '66.50' , '54.51' , NOW() , NOW() ) 22/06/2022 12:39:54 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58852' 22/06/2022 12:39:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '58852' 22/06/2022 12:39:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58852' , '17277' , 'BRACCIALE PIETRE DURE - 4633' , '5' , '-5' , '1' , '5.50' , '4.5081967213115' , '22' , '0' , '27.50' ) 22/06/2022 12:39:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17277' AND id_supplier = '' 22/06/2022 12:39:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17277' , '' , '1' ) 22/06/2022 12:39:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58852' , '3075' , 'CROCE S. BENEDETTO BAGNO ORO 24KT' , '2' , '-2' , '1' , '9.00' , '7.3770491803279' , '22' , '0' , '18.00' ) 22/06/2022 12:39:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '3075' AND id_supplier = '' 22/06/2022 12:39:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3075' , '' , '1' ) 22/06/2022 12:39:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58852' , '8179' , 'PORTACORONA - 017' , '5' , '-5' , '1' , '1.70' , '1.3934426229508' , '22' , '0' , '8.50' ) 22/06/2022 12:39:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8179' AND id_supplier = '' 22/06/2022 12:39:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8179' , '' , '1' ) 22/06/2022 12:39:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58852' , '7202' , 'ARTICOLI RELIGIOSI' , '5' , '-5' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '12.50' ) 22/06/2022 12:39:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 22/06/2022 12:39:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 22/06/2022 01:00:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '2001' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-22') 22/06/2022 01:00:17 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' , '2001' , '2022-06-22' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '20.00' , '16.39' , NOW() , NOW() ) 22/06/2022 01:00:17 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 = '58853' 22/06/2022 01:00:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '58853' 22/06/2022 01:00:17 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 ( '58853' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '20' , '16.393442622951' , '22' , '0' , '20.00' ) 22/06/2022 01:00:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 22/06/2022 01:00:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 22/06/2022 01:00:31 pm >> DELETE FROM ps_document WHERE id_document = '58692' 22/06/2022 01:00:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '58692' 22/06/2022 01:00:52 pm >> SELECT document_num FROM ps_document WHERE document_num = '2002' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-22') 22/06/2022 01:00:52 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2002' , '2022-06-22' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '55.00' , '45.08' , NOW() , NOW() ) 22/06/2022 01:00:52 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58854' 22/06/2022 01:00:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '58854' 22/06/2022 01:00:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58854' , '11726' , 'COPRI BENEDIZIONALE' , '1' , '-1' , '1' , '55' , '45.081967213115' , '22' , '0' , '55.00' ) 22/06/2022 01:00:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11726' AND id_supplier = '' 22/06/2022 01:00:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11726' , '' , '1' ) 22/06/2022 03:54:53 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001826' AND id_product != '18881' AND ean13 != '' 22/06/2022 03:54:53 pm >> UPDATE ps_product SET id_supplier = '122', reference = '', ean13 = '001826', date_upd = NOW() WHERE id_product = '18881' 22/06/2022 03:54:53 pm >> UPDATE ps_product_lang SET name = 'STOLA POLIESTERE - PST020', description = '' WHERE id_product = '18881' 22/06/2022 03:54:53 pm >> UPDATE ps_product SET wholesale_price = '7.30', on_sale = '0', price = '16.311475409836063' WHERE id_product = '18881' 22/06/2022 03:54:53 pm >> UPDATE ps_product_shop SET wholesale_price = '7.30', price = '16.311475409836063', id_tax_rules_group = '1', id_category_default = '440', 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 = '18881' 22/06/2022 03:54:53 pm >> DELETE FROM ps_specific_price WHERE id_product = '18881' 22/06/2022 04:30:35 pm >> SELECT document_num FROM ps_document WHERE document_num = '2003' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-22') 22/06/2022 04:30:35 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2003' , '2022-06-22' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.50' , '9.50' , NOW() , NOW() ) 22/06/2022 04:30:35 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58855' 22/06/2022 04:30:35 pm >> DELETE FROM ps_document_detail WHERE id_document = '58855' 22/06/2022 04:30:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58855' , '19467' , 'SULLA TUA PAROLA - LUG/AGO 2022' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 22/06/2022 04:30:35 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19467' AND id_supplier = '' 22/06/2022 04:30:35 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19467' , '' , '1' ) 22/06/2022 04:30:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58855' , '19622' , 'SULLA TUA PAROLA - SETT/OTT 2022' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 22/06/2022 04:30:35 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19622' AND id_supplier = '' 22/06/2022 04:30:35 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19622' , '' , '1' ) 22/06/2022 05:14:10 pm >> SELECT document_num FROM ps_document WHERE document_num = '1775' AND id_document != '58592' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-03') 22/06/2022 05:14:10 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1775', document_date = '2022-06-03', 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 = '13.00', price_tax_excluded = '10.66', date_upd = NOW() WHERE id_document = '58592' 22/06/2022 05:14:10 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58592' 22/06/2022 05:14:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '58592' 22/06/2022 05:14:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58592' , '13542' , 'ANGELO RESINA CON MANI GIUNTE - 4200' , '1' , '-1' , '1' , '8.0000' , '6.5573770491803' , '22' , '0' , '8.00' ) 22/06/2022 05:14:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13542' AND id_supplier = '' 22/06/2022 05:14:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13542' , '' , '1' ) 22/06/2022 05:14:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58592' , '17052' , 'CROCETTA S. BENEDETTO METALLO OX CM5X3,3 - PG382' , '3' , '-3' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '2.10' ) 22/06/2022 05:14:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17052' AND id_supplier = '' 22/06/2022 05:14:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17052' , '' , '1' ) 22/06/2022 05:14:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58592' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '5' , '-5' , '1' , '0.20' , '0.16393442622951' , '22' , '0' , '1.00' ) 22/06/2022 05:14:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18617' AND id_supplier = '' 22/06/2022 05:14:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18617' , '' , '1' ) 22/06/2022 05:14:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58592' , '18618' , 'MEDAGLIA SAN MICHELE - OV22/MC' , '5' , '-5' , '1' , '0.20' , '0.16393442622951' , '22' , '0' , '1.00' ) 22/06/2022 05:14:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18618' AND id_supplier = '' 22/06/2022 05:14:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18618' , '' , '1' ) 22/06/2022 05:14:11 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 ( '58592' , '18223' , 'CORONA MISSIONARIA - R102' , '1' , '-1' , '1' , '0.9' , '0.73770491803279' , '22' , '0' , '0.90' ) 22/06/2022 05:14:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18223' AND id_supplier = '' 22/06/2022 05:14:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18223' , '' , '1' ) 22/06/2022 05:15:24 pm >> SELECT document_num FROM ps_document WHERE document_num = '1643' AND id_document != '58429' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-24') 22/06/2022 05:15:24 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1643', document_date = '2022-05-24', 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 = '46.00', price_tax_excluded = '37.70', date_upd = NOW() WHERE id_document = '58429' 22/06/2022 05:15:24 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 = '58429' 22/06/2022 05:15:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '58429' 22/06/2022 05:15: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 ( '58429' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '2' , '-2' , '1' , '3.30' , '2.7049180327869' , '22' , '0' , '6.60' ) 22/06/2022 05:15:24 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5903' AND id_supplier = '' 22/06/2022 05:15:24 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5903' , '' , '1' ) 22/06/2022 05:15: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 ( '58429' , '15529' , 'TUNICA 2 PIEGONI COLLO RISV. - PTA002B00' , '1' , '-1' , '1' , '38.0000' , '31.147540983607' , '22' , '0' , '38.00' ) 22/06/2022 05:15:24 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15529' AND id_supplier = '' 22/06/2022 05:15:24 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15529' , '' , '1' ) 22/06/2022 05:15: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 ( '58429' , '6355' , 'MEDAGLIA S. PIO MM 22 - METALLO OX ' , '7' , '-7' , '1' , '0.20' , '0.16393442622951' , '22' , '0' , '1.40' ) 22/06/2022 05:15:24 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6355' AND id_supplier = '' 22/06/2022 05:15:24 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6355' , '' , '1' ) 22/06/2022 06:05:03 pm >> SELECT document_num FROM ps_document WHERE document_num = '2004' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-22') 22/06/2022 06:05:03 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2004' , '2022-06-22' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '27.00' , '22.13' , NOW() , NOW() ) 22/06/2022 06:05:03 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58856' 22/06/2022 06:05:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '58856' 22/06/2022 06:05: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 ( '58856' , '7202' , 'ARTICOLI RELIGIOSI' , '3' , '-3' , '1' , '9' , '7.3770491803279' , '22' , '0' , '27.00' ) 22/06/2022 06:05:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 22/06/2022 06:05:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 22/06/2022 06:05:20 pm >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'suk6FDJaEYAPkqf2' , NOW() , NOW() ) 22/06/2022 06:05:20 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '3887' , '1' ) 22/06/2022 06:05:20 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '3887' , '2' ) 22/06/2022 06:05:20 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '3887' , '3' ) 22/06/2022 06:09:19 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3887' 22/06/2022 06:09:19 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '3887' , '10' , '183' , 'PARROCCHIA SANTA MARIA DELL\'AURO' , 'GUADAGNUOLO' , 'DON FRANCESCO' , 'PIAZZA DELL\'AURO 1' , '' , '80062' , 'META ' , 'FRANCESCO MANZI: 3335253130 - francesco.sagrestano@gmail.com' , '0818788050' , '' , '' , '90014660634' , NOW() , NOW() ) 22/06/2022 06:09:19 pm >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '3887' 22/06/2022 06:11:23 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3887' 22/06/2022 06:11:23 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '3887' , '10' , '183' , 'PARROCCHIA SANTA MARIA DELL\'AURO' , 'GUADAGNUOLO' , 'DON FRANCESCO' , 'PIAZZA DELL\'AURO 1' , '' , '80062' , 'META ' , 'FRANCESCO MANZI: 3335253130 - francesco.sagrestano@gmail.com\r\nconsegna 7,30-12,00 / 17,00-20,00' , '0818788050' , '' , '' , '90014660634' , NOW() , NOW() ) 22/06/2022 06:11:23 pm >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '3887' 22/06/2022 06:11:51 pm >> SELECT document_num FROM ps_document WHERE document_num = '100' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-06-22') 22/06/2022 06:11:51 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' , '100' , '2022-06-22' , '' , '3887' , '0' , '4674405' , 'PIAZZA DELL\\\'AURO 1 80062 META ' , '' , '' , '5' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '42.10' , '42.10' , NOW() , NOW() ) 22/06/2022 06:11:51 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 = '58857' 22/06/2022 06:11:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '58857' 22/06/2022 06:11:51 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 ( '58857' , '12816' , 'LIBRO DEI DEFUNTI' , '1' , '-1' , '0' , '38.00' , '38' , '' , '10' , '34.20' ) 22/06/2022 06:11:51 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 ( '58857' , '' , 'contrassegno' , '1' , '-1' , '0' , '2.9' , '2.9' , '' , '0' , '2.90' ) 22/06/2022 06:24:01 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3887' 22/06/2022 06:24:01 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '3887' , '10' , '183' , 'PARROCCHIA SANTA MARIA DEL LAURO' , 'GUADAGNUOLO' , 'DON FRANCESCO' , 'PIAZZA DEL LAURO 1' , '' , '80062' , 'META ' , 'FRANCESCO MANZI: 3335253130 - francesco.sagrestano@gmail.com\r\nconsegna 7,30-12,00 / 17,00-20,00' , '0818788050' , '' , '' , '90014660634' , NOW() , NOW() ) 22/06/2022 06:24:01 pm >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '3887' 22/06/2022 06:24:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '100' AND id_document != '58857' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-06-22') 22/06/2022 06:24:23 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '100', document_date = '2022-06-22', document_letter = '', id_customer = '3887', id_supplier = '0', id_address = '4674407', address1 = 'PIAZZA DELL\\\'AURO 1 80062 META ', address2 = '', note = '', price_shipping = '5.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '6', id_causal = '0', price_tax_included = '42.10', price_tax_excluded = '42.10', date_upd = NOW() WHERE id_document = '58857' 22/06/2022 06:24: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 = '58857' 22/06/2022 06:24:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '58857' 22/06/2022 06:24: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 ( '58857' , '12816' , 'LIBRO DEI DEFUNTI' , '1' , '-1' , '0' , '38.0000' , '38' , '0' , '10' , '34.20' ) 22/06/2022 06:24: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 ( '58857' , '0' , 'contrassegno' , '1' , '-1' , '0' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 22/06/2022 06:28:50 pm >> SELECT document_num FROM ps_document WHERE document_num = '2005' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-22') 22/06/2022 06:28:50 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' , '2005' , '2022-06-22' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '215.00' , '176.23' , NOW() , NOW() ) 22/06/2022 06:28:50 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 = '58858' 22/06/2022 06:28:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '58858' 22/06/2022 06:28: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 ( '58858' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '215' , '176.22950819672' , '22' , '0' , '215.00' ) 22/06/2022 06:28:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 22/06/2022 06:28:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 22/06/2022 07:01:24 pm >> SELECT document_num FROM ps_document WHERE document_num = '2006' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-22') 22/06/2022 07:01:24 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' , '2006' , '2022-06-22' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '38.00' , '38.00' , NOW() , NOW() ) 22/06/2022 07:01:24 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 = '58859' 22/06/2022 07:01:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '58859' 22/06/2022 07:01: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 ( '58859' , '19467' , 'SULLA TUA PAROLA - LUG/AGO 2022' , '8' , '-8' , '4' , '5.00' , '5' , '0' , '5' , '38.00' ) 22/06/2022 07:01:24 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19467' AND id_supplier = '' 22/06/2022 07:01:24 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19467' , '' , '1' ) 22/06/2022 07:31:12 pm >> SELECT document_num FROM ps_document WHERE document_num = '2007' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-22') 22/06/2022 07:31:12 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2007' , '2022-06-22' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.30' , '3.80' , NOW() , NOW() ) 22/06/2022 07:31:12 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58860' 22/06/2022 07:31:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '58860' 22/06/2022 07:31:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58860' , '19310' , 'SACCHETTO CON CORONCINA E SEGNALIBRO - 1315/K182' , '1' , '-1' , '1' , '2.80' , '2.2950819672131' , '22' , '0' , '2.80' ) 22/06/2022 07:31:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19310' AND id_supplier = '' 22/06/2022 07:31:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19310' , '' , '1' ) 22/06/2022 07:31:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58860' , '6663' , 'MIE PREGHIERE' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '0' , '1.50' ) 22/06/2022 07:31:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6663' AND id_supplier = '' 22/06/2022 07:31:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6663' , '' , '1' )