27/07/2022 09:06:05 am >> SELECT ean13 FROM ps_product WHERE ean13 = '000856' AND id_product != '19818' AND ean13 != '' 27/07/2022 09:06:06 am >> UPDATE ps_product SET id_supplier = '157', reference = '', ean13 = '000856', date_upd = NOW() WHERE id_product = '19818' 27/07/2022 09:06:06 am >> UPDATE ps_product_lang SET name = 'INCENSO NATURALE 3A KG 1', description = '' WHERE id_product = '19818' 27/07/2022 09:06:06 am >> UPDATE ps_product SET wholesale_price = '5.80', on_sale = '0', price = '18.852459016393443' WHERE id_product = '19818' 27/07/2022 09:06:06 am >> UPDATE ps_product_shop SET wholesale_price = '5.80', price = '18.852459016393443', id_tax_rules_group = '1', id_category_default = '489', 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 = '19818' 27/07/2022 09:06:06 am >> DELETE FROM ps_specific_price WHERE id_product = '19818' 27/07/2022 09:15:01 am >> SELECT document_num FROM ps_document WHERE document_num = '2370' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-27') 27/07/2022 09:15:01 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' , '2370' , '2022-07-27' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.90' , '12.92' , NOW() , NOW() ) 27/07/2022 09:15:01 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '59811' 27/07/2022 09:15:01 am >> DELETE FROM ps_document_detail WHERE id_document = '59811' 27/07/2022 09:15:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59811' , '2766' , 'CORONA PLASTICA FOSFORO - 0100F' , '30' , '-30' , '1' , '0.3' , '0.24590163934426' , '22' , '0' , '9.00' ) 27/07/2022 09:15:01 am >> DELETE FROM ps_product_supplier WHERE id_product = '2766' AND id_supplier = '' 27/07/2022 09:15:01 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2766' , '' , '1' ) 27/07/2022 09:15:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59811' , '6629' , 'MIA PREGHIERA' , '6' , '-6' , '4' , '0.65' , '0.65' , '0' , '0' , '3.90' ) 27/07/2022 09:15:01 am >> DELETE FROM ps_product_supplier WHERE id_product = '6629' AND id_supplier = '' 27/07/2022 09:15:01 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6629' , '' , '1' ) 27/07/2022 09:15:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59811' , '7202' , 'ARTICOLI RELIGIOSI' , '2' , '-2' , '1' , '1' , '0.81967213114754' , '22' , '0' , '2.00' ) 27/07/2022 09:15:01 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 27/07/2022 09:15:01 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 27/07/2022 09:19:44 am >> SELECT document_num FROM ps_document WHERE document_num = '2371' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-27') 27/07/2022 09:19:44 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' , '2371' , '2022-07-27' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '795.00' , '651.64' , NOW() , NOW() ) 27/07/2022 09:19:44 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 = '59812' 27/07/2022 09:19:44 am >> DELETE FROM ps_document_detail WHERE id_document = '59812' 27/07/2022 09:19:44 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 ( '59812' , '19436' , 'CAMICE MISTO COTONE - CAM0M70' , '1' , '-1' , '1' , '750' , '614.75409836066' , '22' , '0' , '750.00' ) 27/07/2022 09:19:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '19436' AND id_supplier = '' 27/07/2022 09:19:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19436' , '' , '1' ) 27/07/2022 09:19:44 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 ( '59812' , '15893' , 'CINGOLO - CING17' , '1' , '-1' , '1' , '45' , '36.885245901639' , '22' , '0' , '45.00' ) 27/07/2022 09:19:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '15893' AND id_supplier = '' 27/07/2022 09:19:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15893' , '' , '1' ) 27/07/2022 09:21:51 am >> SELECT document_num FROM ps_document WHERE document_num = '2372' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-27') 27/07/2022 09:21:51 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' , '2372' , '2022-07-27' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 27/07/2022 09:21:51 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 = '59813' 27/07/2022 09:21:51 am >> DELETE FROM ps_document_detail WHERE id_document = '59813' 27/07/2022 09:21:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59813' , '19622' , 'SULLA TUA PAROLA - SETT/OTT 2022' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 27/07/2022 09:21:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '19622' AND id_supplier = '' 27/07/2022 09:21:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19622' , '' , '1' ) 27/07/2022 09:27:52 am >> SELECT document_num FROM ps_document WHERE document_num = '2373' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-27') 27/07/2022 09:27:52 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' , '2373' , '2022-07-27' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '125.90' , '108.33' , NOW() , NOW() ) 27/07/2022 09:27:52 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '59814' 27/07/2022 09:27:52 am >> DELETE FROM ps_document_detail WHERE id_document = '59814' 27/07/2022 09:27:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59814' , '11151' , 'LIBRI' , '6' , '-6' , '4' , '3.5' , '3.5' , '0' , '0' , '21.00' ) 27/07/2022 09:27:52 am >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 27/07/2022 09:27:52 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 27/07/2022 09:27:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59814' , '7311' , 'OSTIA SOTTILE 74MM' , '5' , '-5' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '9.50' ) 27/07/2022 09:27:52 am >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 27/07/2022 09:27:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 27/07/2022 09:27:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59814' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '6' , '-6' , '1' , '6.50' , '5.327868852459' , '22' , '0' , '39.00' ) 27/07/2022 09:27:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '11757' AND id_supplier = '' 27/07/2022 09:27:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11757' , '' , '1' ) 27/07/2022 09:27:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59814' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 27/07/2022 09:27:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 27/07/2022 09:27:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 27/07/2022 09:30:07 am >> SELECT document_num FROM ps_document WHERE document_num = '2374' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-27') 27/07/2022 09:30:07 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2374' , '2022-07-27' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '32.50' , '32.35' , NOW() , NOW() ) 27/07/2022 09:30:07 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '59815' 27/07/2022 09:30:07 am >> DELETE FROM ps_document_detail WHERE id_document = '59815' 27/07/2022 09:30:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59815' , '19622' , 'SULLA TUA PAROLA - SETT/OTT 2022' , '6' , '-6' , '4' , '5.00' , '5' , '0' , '5' , '28.50' ) 27/07/2022 09:30:07 am >> DELETE FROM ps_product_supplier WHERE id_product = '19622' AND id_supplier = '' 27/07/2022 09:30:07 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19622' , '' , '1' ) 27/07/2022 09:30:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59815' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.00' , '3.8461538461538' , '4' , '0' , '4.00' ) 27/07/2022 09:30:07 am >> DELETE FROM ps_product_supplier WHERE id_product = '16691' AND id_supplier = '' 27/07/2022 09:30:07 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16691' , '' , '1' ) 27/07/2022 09:46:22 am >> SELECT document_num FROM ps_document WHERE document_num = '2375' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-27') 27/07/2022 09:46:22 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' , '2375' , '2022-07-27' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 27/07/2022 09:46:22 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 = '59816' 27/07/2022 09:46:22 am >> DELETE FROM ps_document_detail WHERE id_document = '59816' 27/07/2022 09:46:22 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 ( '59816' , '19662' , 'MESSALINO QUOTIDIANO - AGO/SET/OTT 2022' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 27/07/2022 09:46:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '19662' AND id_supplier = '' 27/07/2022 09:46:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19662' , '' , '1' ) 27/07/2022 09:53:32 am >> SELECT ean13 FROM ps_product WHERE ean13 = '000857' AND id_product != '19819' AND ean13 != '' 27/07/2022 09:53:32 am >> UPDATE ps_product SET id_supplier = '157', reference = '', ean13 = '000857', date_upd = NOW() WHERE id_product = '19819' 27/07/2022 09:53:32 am >> UPDATE ps_product_lang SET name = 'INCENSO NATURALE 1 ST GRADE - KG 1', description = '' WHERE id_product = '19819' 27/07/2022 09:53:32 am >> UPDATE ps_product SET wholesale_price = '7.80', on_sale = '0', price = '22.13114754098361' WHERE id_product = '19819' 27/07/2022 09:53:32 am >> UPDATE ps_product_shop SET wholesale_price = '7.80', price = '22.13114754098361', id_tax_rules_group = '1', id_category_default = '489', 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 = '19819' 27/07/2022 09:53:32 am >> DELETE FROM ps_specific_price WHERE id_product = '19819' 27/07/2022 10:04:49 am >> SELECT document_num FROM ps_document WHERE document_num = '2376' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-27') 27/07/2022 10:04: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' , '2376' , '2022-07-27' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '75.00' , '61.48' , NOW() , NOW() ) 27/07/2022 10:04: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 = '59817' 27/07/2022 10:04:49 am >> DELETE FROM ps_document_detail WHERE id_document = '59817' 27/07/2022 10:04: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 ( '59817' , '14247' , 'ROSARIO ULIVO OVALE CON SETA E CROCE SAN DAMIANO' , '50' , '-50' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '75.00' ) 27/07/2022 10:04:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '14247' AND id_supplier = '' 27/07/2022 10:04:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14247' , '' , '1' ) 27/07/2022 10:06:04 am >> SELECT document_num FROM ps_document WHERE document_num = '103' AND id_document != '59081' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-07-06') 27/07/2022 10:06:05 am >> UPDATE ps_document SET id_document_type = '21', document_num = '103', document_date = '2022-07-06', document_letter = '', id_customer = '3888', id_supplier = '', id_address = '4674409', address1 = 'P. ZZA XX SETTEMBRE 84020 BELLOSGUARDO', address2 = '', note = '', price_shipping = '10.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '273.50', price_tax_excluded = '273.50', date_upd = NOW() WHERE id_document = '59081' 27/07/2022 10:06:05 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '59081' 27/07/2022 10:06:05 am >> DELETE FROM ps_document_detail WHERE id_document = '59081' 27/07/2022 10:06:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59081' , '11233' , 'VERITÀ VI FARÀ LIBERI' , '20' , '-20' , '4' , '15.5000' , '15.5' , '0' , '15' , '263.50' ) 27/07/2022 10:06:05 am >> DELETE FROM ps_product_supplier WHERE id_product = '11233' AND id_supplier = '' 27/07/2022 10:06:05 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11233' , '' , '1' ) 27/07/2022 10:09:22 am >> SELECT document_num FROM ps_document WHERE document_num = '103' AND id_document != '59081' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-07-06') 27/07/2022 10:09:22 am >> UPDATE ps_document SET id_document_type = '21', document_num = '103', document_date = '2022-07-06', document_letter = '', id_customer = '3888', id_supplier = '', id_address = '4674409', address1 = 'P. ZZA XX SETTEMBRE 84020 BELLOSGUARDO', address2 = '', note = '', price_shipping = '9.5', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '273.00', price_tax_excluded = '273.00', date_upd = NOW() WHERE id_document = '59081' 27/07/2022 10:09:22 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 = '59081' 27/07/2022 10:09:22 am >> DELETE FROM ps_document_detail WHERE id_document = '59081' 27/07/2022 10:09:22 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 ( '59081' , '11233' , 'VERITÀ VI FARÀ LIBERI' , '20' , '-20' , '4' , '15.5000' , '15.5' , '0' , '15' , '263.50' ) 27/07/2022 10:09:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '11233' AND id_supplier = '' 27/07/2022 10:09:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11233' , '' , '1' ) 27/07/2022 10:14:08 am >> SELECT document_num FROM ps_document WHERE document_num = '2377' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-27') 27/07/2022 10:14:09 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' , '2377' , '2022-07-27' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '36.50' , '29.92' , NOW() , NOW() ) 27/07/2022 10:14:09 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 = '59818' 27/07/2022 10:14:09 am >> DELETE FROM ps_document_detail WHERE id_document = '59818' 27/07/2022 10:14:09 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 ( '59818' , '19395' , 'CLERGY MISTO COTONE ML - C01' , '1' , '-1' , '1' , '36.50' , '29.918032786885' , '22' , '0' , '36.50' ) 27/07/2022 10:14:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '19395' AND id_supplier = '' 27/07/2022 10:14:09 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19395' , '' , '1' ) 27/07/2022 10:24:11 am >> SELECT ean13 FROM ps_product WHERE ean13 = '001590' AND id_product != '17408' AND ean13 != '' 27/07/2022 10:24:12 am >> UPDATE ps_product SET id_supplier = '143', reference = '', ean13 = '001590', date_upd = NOW() WHERE id_product = '17408' 27/07/2022 10:24:12 am >> UPDATE ps_product_lang SET name = 'CAMICE MISTO COT. 70/001035', description = '' WHERE id_product = '17408' 27/07/2022 10:24:12 am >> UPDATE ps_product SET wholesale_price = '51.41', on_sale = '0', price = '113.11475409836066' WHERE id_product = '17408' 27/07/2022 10:24:12 am >> UPDATE ps_product_shop SET wholesale_price = '51.41', price = '113.11475409836066', id_tax_rules_group = '1', id_category_default = '468', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '17408' 27/07/2022 10:24:12 am >> DELETE FROM ps_specific_price WHERE id_product = '17408' 27/07/2022 10:25:50 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 27/07/2022 10:25:50 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19821' , '1' , '' , 'nuovo-prodotto' ) 27/07/2022 10:25:50 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '19821' , '1' , '1' , '2' , NOW() , NOW() ) 27/07/2022 10:25:50 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '19821' , '0' , '1' , '0' , '0' ) 27/07/2022 10:27:05 am >> SELECT ean13 FROM ps_product WHERE ean13 = '000858' AND id_product != '19821' AND ean13 != '' 27/07/2022 10:27:05 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '000858', date_upd = NOW() WHERE id_product = '19821' 27/07/2022 10:27:05 am >> UPDATE ps_product_lang SET name = 'casula righe - 65/1909', description = '' WHERE id_product = '19821' 27/07/2022 10:27:05 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '241.80327868852459' WHERE id_product = '19821' 27/07/2022 10:27:05 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '241.80327868852459', id_tax_rules_group = '1', id_category_default = '468', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19821' 27/07/2022 10:27:05 am >> DELETE FROM ps_specific_price WHERE id_product = '19821' 27/07/2022 10:27:25 am >> SELECT ean13 FROM ps_product WHERE ean13 = '000858' AND id_product != '19821' AND ean13 != '' 27/07/2022 10:27:25 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '000858', date_upd = NOW() WHERE id_product = '19821' 27/07/2022 10:27:25 am >> UPDATE ps_product_lang SET name = 'CASULA RIGHE - 65/1909', description = '' WHERE id_product = '19821' 27/07/2022 10:27:25 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '241.80327868852459' WHERE id_product = '19821' 27/07/2022 10:27:25 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '241.80327868852459', id_tax_rules_group = '1', id_category_default = '468', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19821' 27/07/2022 10:27:25 am >> DELETE FROM ps_specific_price WHERE id_product = '19821' 27/07/2022 10:28:06 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '333' , '2022-07-25' , '' , '0' , '143' , '4670947' , 'VIA DELLE SELVETTE 324 55018 SEGROMIGNO IN MONTE CAPANNORI' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '884.16' , '724.72' , NOW() , NOW() ) 27/07/2022 10:28:06 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '59819' 27/07/2022 10:28:06 am >> DELETE FROM ps_document_detail WHERE id_document = '59819' 27/07/2022 10:28:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59819' , '17408' , 'CAMICE MISTO COT. 70/001035' , '2' , '2' , '1' , '58' , '47.540983606557' , '22' , '3' , '137.2744' ) 27/07/2022 10:28:06 am >> DELETE FROM ps_product_supplier WHERE id_product = '17408' AND id_supplier = '143' 27/07/2022 10:28:06 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17408' , '143' , '1' ) 27/07/2022 10:28:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59819' , '19659' , 'CASULA POLIESTERE - 65/18355' , '2' , '2' , '1' , '130' , '106.55737704918' , '22' , '3' , '307.6840' ) 27/07/2022 10:28:06 am >> DELETE FROM ps_product_supplier WHERE id_product = '19659' AND id_supplier = '143' 27/07/2022 10:28:06 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19659' , '143' , '1' ) 27/07/2022 10:28:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59819' , '19821' , 'CASULA RIGHE - 65/1909' , '3' , '3' , '1' , '120' , '98.360655737705' , '22' , '0' , '439.2000' ) 27/07/2022 10:28:06 am >> DELETE FROM ps_product_supplier WHERE id_product = '19821' AND id_supplier = '143' 27/07/2022 10:28:06 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19821' , '143' , '1' ) 27/07/2022 10:34:29 am >> SELECT document_num FROM ps_document WHERE document_num = '2317' AND id_document != '59746' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-21') 27/07/2022 10:34:29 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2317', document_date = '2022-07-21', 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 = '284.95', price_tax_excluded = '236.14', date_upd = NOW() WHERE id_document = '59746' 27/07/2022 10:34:29 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '59746' 27/07/2022 10:34:29 am >> DELETE FROM ps_document_detail WHERE id_document = '59746' 27/07/2022 10:34:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59746' , '19804' , 'CORONA 5 CM' , '1' , '-1' , '1' , '60.00' , '49.180327868852' , '22' , '0' , '60.00' ) 27/07/2022 10:34:29 am >> DELETE FROM ps_product_supplier WHERE id_product = '19804' AND id_supplier = '' 27/07/2022 10:34:29 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19804' , '' , '1' ) 27/07/2022 10:34:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59746' , '17087' , 'POLO COTONE MM' , '1' , '-1' , '1' , '40.0000' , '32.786885245902' , '22' , '0' , '40.00' ) 27/07/2022 10:34:30 am >> DELETE FROM ps_product_supplier WHERE id_product = '17087' AND id_supplier = '' 27/07/2022 10:34:30 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17087' , '' , '1' ) 27/07/2022 10:34:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59746' , '19595' , 'POLO JERSEY COTONE 100% - EXTRA' , '4' , '-4' , '1' , '40.0000' , '32.786885245902' , '22' , '0' , '160.00' ) 27/07/2022 10:34:30 am >> DELETE FROM ps_product_supplier WHERE id_product = '19595' AND id_supplier = '' 27/07/2022 10:34:30 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19595' , '' , '1' ) 27/07/2022 10:34:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59746' , '19698' , 'UN LUOGO PIENO DI PACE - G. ATTANASIO' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '5' , '14.25' ) 27/07/2022 10:34:30 am >> DELETE FROM ps_product_supplier WHERE id_product = '19698' AND id_supplier = '' 27/07/2022 10:34:30 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19698' , '' , '1' ) 27/07/2022 10:34:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59746' , '6349' , 'MEDAGLIA S. BENEDETTO MET. OX SMALT. 4,8 - Q2008-OX' , '2' , '-2' , '1' , '5.3500' , '4.3852459016393' , '22' , '0' , '10.70' ) 27/07/2022 10:34:30 am >> DELETE FROM ps_product_supplier WHERE id_product = '6349' AND id_supplier = '' 27/07/2022 10:34:30 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6349' , '' , '1' ) 27/07/2022 10:41:55 am >> SELECT document_num FROM ps_document WHERE document_num = '2378' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-27') 27/07/2022 10:41:55 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' , '2378' , '2022-07-27' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '122.50' , '100.41' , NOW() , NOW() ) 27/07/2022 10:41:55 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '59820' 27/07/2022 10:41:55 am >> DELETE FROM ps_document_detail WHERE id_document = '59820' 27/07/2022 10:41:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59820' , '19605' , 'CLERGY SU MISURA - COCOCLER' , '3' , '-3' , '1' , '40' , '32.786885245902' , '22' , '0' , '120.00' ) 27/07/2022 10:41:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '19605' AND id_supplier = '' 27/07/2022 10:41:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19605' , '' , '1' ) 27/07/2022 10:41:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59820' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '2.50' ) 27/07/2022 10:41:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 27/07/2022 10:41:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 27/07/2022 10:53:49 am >> SELECT document_num FROM ps_document WHERE document_num = '2315' AND id_document != '59744' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-21') 27/07/2022 10:53:49 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2315', document_date = '2022-07-21', 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 = '10.70', price_tax_excluded = '8.77', date_upd = NOW() WHERE id_document = '59744' 27/07/2022 10:53: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 = '59744' 27/07/2022 10:53:49 am >> DELETE FROM ps_document_detail WHERE id_document = '59744' 27/07/2022 10:53: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 ( '59744' , '5958' , 'LUCAS 25G - FIORI DARANCIO - EVE ' , '1' , '-1' , '1' , '1.3' , '1.0655737704918' , '22' , '0' , '1.30' ) 27/07/2022 10:53:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '5958' AND id_supplier = '' 27/07/2022 10:53:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5958' , '' , '1' ) 27/07/2022 10:53: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 ( '59744' , '10475' , 'TEALIGHTS X 50 ' , '1' , '-1' , '1' , '3.9000' , '3.1967213114754' , '22' , '0' , '3.90' ) 27/07/2022 10:53:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '10475' AND id_supplier = '' 27/07/2022 10:53:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10475' , '' , '1' ) 27/07/2022 10:53: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 ( '59744' , '19129' , 'BRUCIAINCENSO ALADINO - ALA' , '1' , '-1' , '1' , '5.50' , '4.5081967213115' , '22' , '0' , '5.50' ) 27/07/2022 10:53:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '19129' AND id_supplier = '' 27/07/2022 10:53:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19129' , '' , '1' ) 27/07/2022 11:21:21 am >> SELECT document_num FROM ps_document WHERE document_num = '2379' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-27') 27/07/2022 11:21:21 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' , '2379' , '2022-07-27' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '33.00' , '27.05' , NOW() , NOW() ) 27/07/2022 11:21:21 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 = '59821' 27/07/2022 11:21:21 am >> DELETE FROM ps_document_detail WHERE id_document = '59821' 27/07/2022 11:21:21 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 ( '59821' , '18762' , 'BRACCIALE ARG. - 1568/1570' , '1' , '-1' , '1' , '33' , '27.049180327869' , '22' , '0' , '33.00' ) 27/07/2022 11:21:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '18762' AND id_supplier = '' 27/07/2022 11:21:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18762' , '' , '1' ) 27/07/2022 12:09:58 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 27/07/2022 12:09:58 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19822' , '1' , '' , 'nuovo-prodotto' ) 27/07/2022 12:09:58 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '19822' , '1' , '1' , '2' , NOW() , NOW() ) 27/07/2022 12:09:58 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '19822' , '0' , '1' , '0' , '0' ) 27/07/2022 12:10:48 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788837236212' AND id_product != '19822' AND ean13 != '' 27/07/2022 12:10:48 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788837236212', date_upd = NOW() WHERE id_product = '19822' 27/07/2022 12:10:48 pm >> UPDATE ps_product_lang SET name = 'CRISTIANESIMO COME FORMA DI VITA', description = '' WHERE id_product = '19822' 27/07/2022 12:10:48 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '15' WHERE id_product = '19822' 27/07/2022 12:10:48 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '15', id_tax_rules_group = '4', id_category_default = '2', id_argoment_default = '20', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19822' 27/07/2022 12:10:48 pm >> DELETE FROM ps_specific_price WHERE id_product = '19822' 27/07/2022 12:10:48 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '19822' 27/07/2022 12:10:49 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19823' , '1' , '' , 'nuovo-prodotto' ) 27/07/2022 12:10:49 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '19823' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19822' 27/07/2022 12:10:49 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19823' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19822' 27/07/2022 12:11:22 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788868983208' AND id_product != '19823' AND ean13 != '' 27/07/2022 12:11:22 pm >> UPDATE ps_product SET id_supplier = '', reference = '11/5', ean13 = '9788868983208', date_upd = NOW() WHERE id_product = '19823' 27/07/2022 12:11:22 pm >> UPDATE ps_product_lang SET name = 'PAOLO INTERPRETE INTERPRETATO', description = '' WHERE id_product = '19823' 27/07/2022 12:11:22 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '19' WHERE id_product = '19823' 27/07/2022 12:11:22 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '19', id_tax_rules_group = '4', id_category_default = '257', id_argoment_default = '20', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19823' 27/07/2022 12:11:22 pm >> DELETE FROM ps_specific_price WHERE id_product = '19823' 27/07/2022 12:11:24 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '19823' 27/07/2022 12:11:24 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19824' , '1' , '' , 'nuovo-prodotto' ) 27/07/2022 12:11:24 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '19824' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19823' 27/07/2022 12:11:24 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19824' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19823' 27/07/2022 12:11:42 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788837236212' AND id_product != '19822' AND ean13 != '' 27/07/2022 12:11:42 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788837236212', date_upd = NOW() WHERE id_product = '19822' 27/07/2022 12:11:42 pm >> UPDATE ps_product_lang SET name = 'CRISTIANESIMO COME FORMA DI VITA', description = '' WHERE id_product = '19822' 27/07/2022 12:11:42 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '15.0000' WHERE id_product = '19822' 27/07/2022 12:11:42 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '15.0000', id_tax_rules_group = '4', id_category_default = '161', id_argoment_default = '20', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19822' 27/07/2022 12:11:42 pm >> DELETE FROM ps_specific_price WHERE id_product = '19822' 27/07/2022 12:12:24 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831165945' AND id_product != '19824' AND ean13 != '' 27/07/2022 12:12:24 pm >> UPDATE ps_product SET id_supplier = '', reference = '6/6', ean13 = '9788831165945', date_upd = NOW() WHERE id_product = '19824' 27/07/2022 12:12:24 pm >> UPDATE ps_product_lang SET name = 'DEMONOLOGIA E PRASSI ESORCISTICA - M. LANZA', description = '' WHERE id_product = '19824' 27/07/2022 12:12:24 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '15.9' WHERE id_product = '19824' 27/07/2022 12:12:24 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '15.9', id_tax_rules_group = '4', id_category_default = '13', id_argoment_default = '20', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19824' 27/07/2022 12:12:24 pm >> DELETE FROM ps_specific_price WHERE id_product = '19824' 27/07/2022 12:12:25 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '19824' 27/07/2022 12:12:25 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19825' , '1' , '' , 'nuovo-prodotto' ) 27/07/2022 12:12:25 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '19825' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19824' 27/07/2022 12:12:25 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19825' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19824' 27/07/2022 12:12:41 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831165945' AND id_product != '19824' AND ean13 != '' 27/07/2022 12:12:41 pm >> UPDATE ps_product SET id_supplier = '', reference = '6/6', ean13 = '9788831165945', date_upd = NOW() WHERE id_product = '19824' 27/07/2022 12:12:41 pm >> UPDATE ps_product_lang SET name = 'DEMONOLOGIA E PRASSI ESORCISTICA - M. LANZA', description = '' WHERE id_product = '19824' 27/07/2022 12:12:41 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '15.9000' WHERE id_product = '19824' 27/07/2022 12:12:41 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '15.9000', id_tax_rules_group = '4', id_category_default = '13', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19824' 27/07/2022 12:12:41 pm >> DELETE FROM ps_specific_price WHERE id_product = '19824' 27/07/2022 12:13:48 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788837235680' AND id_product != '19825' AND ean13 != '' 27/07/2022 12:13:48 pm >> UPDATE ps_product SET id_supplier = '', reference = '7/7', ean13 = '9788837235680', date_upd = NOW() WHERE id_product = '19825' 27/07/2022 12:13:48 pm >> UPDATE ps_product_lang SET name = '1945 PAROLE PER UN NUOVO ORIENTAMENTO - R. GUARDINI', description = '' WHERE id_product = '19825' 27/07/2022 12:13:48 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '22' WHERE id_product = '19825' 27/07/2022 12:13:48 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '22', id_tax_rules_group = '4', id_category_default = '13', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19825' 27/07/2022 12:13:48 pm >> DELETE FROM ps_specific_price WHERE id_product = '19825' 27/07/2022 12:13:49 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '19825' 27/07/2022 12:13:49 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19826' , '1' , '' , 'nuovo-prodotto' ) 27/07/2022 12:13:49 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '19826' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19825' 27/07/2022 12:13:49 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19826' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19825' 27/07/2022 12:14:49 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831114646' AND id_product != '19826' AND ean13 != '' 27/07/2022 12:14:49 pm >> UPDATE ps_product SET id_supplier = '', reference = '7/2', ean13 = '9788831114646', date_upd = NOW() WHERE id_product = '19826' 27/07/2022 12:14:49 pm >> UPDATE ps_product_lang SET name = 'LETTERE E SCRITTI - LUIGI GONZAGA', description = '' WHERE id_product = '19826' 27/07/2022 12:14:49 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '15.9' WHERE id_product = '19826' 27/07/2022 12:14:49 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '15.9', id_tax_rules_group = '4', id_category_default = '13', id_argoment_default = '74', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19826' 27/07/2022 12:14:49 pm >> DELETE FROM ps_specific_price WHERE id_product = '19826' 27/07/2022 12:14:50 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '19826' 27/07/2022 12:14:50 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19827' , '1' , '' , 'nuovo-prodotto' ) 27/07/2022 12:14:50 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '19827' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19826' 27/07/2022 12:14:50 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19827' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19826' 27/07/2022 12:15:03 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788837235680' AND id_product != '19825' AND ean13 != '' 27/07/2022 12:15:03 pm >> UPDATE ps_product SET id_supplier = '', reference = '7/7', ean13 = '9788837235680', date_upd = NOW() WHERE id_product = '19825' 27/07/2022 12:15:03 pm >> UPDATE ps_product_lang SET name = '1945 PAROLE PER UN NUOVO ORIENTAMENTO - R. GUARDINI', description = '' WHERE id_product = '19825' 27/07/2022 12:15:03 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '22.0000' WHERE id_product = '19825' 27/07/2022 12:15:03 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '22.0000', id_tax_rules_group = '4', id_category_default = '161', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19825' 27/07/2022 12:15:03 pm >> DELETE FROM ps_specific_price WHERE id_product = '19825' 27/07/2022 12:15:04 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '19825' 27/07/2022 12:15:04 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19828' , '1' , '' , 'nuovo-prodotto' ) 27/07/2022 12:15:04 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '19828' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19825' 27/07/2022 12:15:04 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19828' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19825' 27/07/2022 12:15:37 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831165938' AND id_product != '19828' AND ean13 != '' 27/07/2022 12:15:37 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788831165938', date_upd = NOW() WHERE id_product = '19828' 27/07/2022 12:15:37 pm >> UPDATE ps_product_lang SET name = 'CHIESA SINODALE NELL\'OGGI', description = '' WHERE id_product = '19828' 27/07/2022 12:15:37 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '15.9' WHERE id_product = '19828' 27/07/2022 12:15:37 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '15.9', id_tax_rules_group = '4', id_category_default = '13', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19828' 27/07/2022 12:15:37 pm >> DELETE FROM ps_specific_price WHERE id_product = '19828' 27/07/2022 12:15:38 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '19828' 27/07/2022 12:15:38 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19829' , '1' , '' , 'nuovo-prodotto' ) 27/07/2022 12:15:38 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '19829' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19828' 27/07/2022 12:15:38 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19829' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19828' 27/07/2022 12:17:58 pm >> SELECT document_num FROM ps_document WHERE document_num = '2380' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-27') 27/07/2022 12:17:58 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2380' , '2022-07-27' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.50' , '5.33' , NOW() , NOW() ) 27/07/2022 12:17:58 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '59822' 27/07/2022 12:17:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '59822' 27/07/2022 12:17:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59822' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '1' , '-1' , '1' , '6.50' , '5.327868852459' , '22' , '0' , '6.50' ) 27/07/2022 12:17:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11757' AND id_supplier = '' 27/07/2022 12:17:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11757' , '' , '1' ) 27/07/2022 12:18:29 pm >> SELECT document_num FROM ps_document WHERE document_num = '2381' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-27') 27/07/2022 12:18:29 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2381' , '2022-07-27' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.10' , '4.10' , NOW() , NOW() ) 27/07/2022 12:18:29 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '59823' 27/07/2022 12:18:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '59823' 27/07/2022 12:18:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59823' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '1.9' , '1.9' , '0' , '0' , '1.90' ) 27/07/2022 12:18:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 27/07/2022 12:18:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 27/07/2022 12:18:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59823' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '2.2' , '2.2' , '0' , '0' , '2.20' ) 27/07/2022 12:18:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 27/07/2022 12:18:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 27/07/2022 12:22:58 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '211560' , '2022-07-26' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '198.40' , '198.40' , NOW() , NOW() ) 27/07/2022 12:22:58 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '59824' 27/07/2022 12:22:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '59824' 27/07/2022 12:22:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59824' , '19825' , '1945 PAROLE PER UN NUOVO ORIENTAMENTO - R. GUARDINI' , '1' , '1' , '4' , '22.00' , '22' , '0' , '0' , '22.00' ) 27/07/2022 12:22:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19825' AND id_supplier = '109' 27/07/2022 12:22:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19825' , '109' , '1' ) 27/07/2022 12:22:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59824' , '19822' , 'CRISTIANESIMO COME FORMA DI VITA' , '1' , '1' , '4' , '15.00' , '15' , '0' , '0' , '15.00' ) 27/07/2022 12:22:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19822' AND id_supplier = '109' 27/07/2022 12:22:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19822' , '109' , '1' ) 27/07/2022 12:22:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59824' , '19824' , 'DEMONOLOGIA E PRASSI ESORCISTICA - M. LANZA' , '2' , '2' , '4' , '15.90' , '15.9' , '0' , '0' , '31.8000' ) 27/07/2022 12:22:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19824' AND id_supplier = '109' 27/07/2022 12:22:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19824' , '109' , '1' ) 27/07/2022 12:22:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59824' , '19828' , 'CHIESA SINODALE NELLOGGI' , '2' , '2' , '4' , '15.90' , '15.9' , '0' , '0' , '31.8000' ) 27/07/2022 12:22:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19828' AND id_supplier = '109' 27/07/2022 12:22:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19828' , '109' , '1' ) 27/07/2022 12:22:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59824' , '19826' , 'LETTERE E SCRITTI - LUIGI GONZAGA' , '1' , '1' , '4' , '15.90' , '15.9' , '0' , '0' , '15.90' ) 27/07/2022 12:22:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19826' AND id_supplier = '109' 27/07/2022 12:22:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19826' , '109' , '1' ) 27/07/2022 12:22:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59824' , '15970' , 'DIALOGO DELLA DIVINA PROVVIDENZA - S. CATERINA DA SIENA' , '1' , '1' , '4' , '17.00' , '17' , '0' , '0' , '17.00' ) 27/07/2022 12:22:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15970' AND id_supplier = '109' 27/07/2022 12:22:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15970' , '109' , '1' ) 27/07/2022 12:22:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59824' , '19823' , 'PAOLO INTERPRETE INTERPRETATO' , '1' , '1' , '4' , '19.00' , '19' , '0' , '0' , '19.00' ) 27/07/2022 12:22:59 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19823' AND id_supplier = '109' 27/07/2022 12:22:59 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19823' , '109' , '1' ) 27/07/2022 12:22:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59824' , '19826' , 'LETTERE E SCRITTI - LUIGI GONZAGA' , '1' , '1' , '4' , '15.90' , '15.9' , '0' , '0' , '15.90' ) 27/07/2022 12:22:59 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19826' AND id_supplier = '109' 27/07/2022 12:22:59 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19826' , '109' , '1' ) 27/07/2022 12:22:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59824' , '19381' , 'SINODALITA' , '1' , '1' , '4' , '14.00' , '14' , '0' , '0' , '14.00' ) 27/07/2022 12:22:59 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19381' AND id_supplier = '109' 27/07/2022 12:22:59 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19381' , '109' , '1' ) 27/07/2022 12:22:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59824' , '19380' , 'OGGETTO PREDICA' , '1' , '1' , '4' , '16.00' , '16' , '0' , '0' , '16.00' ) 27/07/2022 12:22:59 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19380' AND id_supplier = '109' 27/07/2022 12:22:59 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19380' , '109' , '1' ) 27/07/2022 12:48:38 pm >> SELECT document_num FROM ps_document WHERE document_num = '2382' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-27') 27/07/2022 12:48:38 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2382' , '2022-07-27' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '45.00' , '37.25' , NOW() , NOW() ) 27/07/2022 12:48:38 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '59825' 27/07/2022 12:48:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '59825' 27/07/2022 12:48:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59825' , '19602' , 'QUADRETTO EFFETTO PIETRA - SACRA FAMIGLIA - 2952' , '10' , '-10' , '1' , '3.70' , '3.0327868852459' , '22' , '0' , '37.00' ) 27/07/2022 12:48:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19602' AND id_supplier = '' 27/07/2022 12:48:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19602' , '' , '1' ) 27/07/2022 12:48:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59825' , '18218' , 'DECINA LEGNO CHIARO - FR52' , '10' , '-10' , '1' , '0.60' , '0.49180327868852' , '22' , '0' , '6.00' ) 27/07/2022 12:48:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18218' AND id_supplier = '' 27/07/2022 12:48:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18218' , '' , '1' ) 27/07/2022 12:48:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59825' , '19805' , 'DESIDERIO DESIDERAVI' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 27/07/2022 12:48:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19805' AND id_supplier = '' 27/07/2022 12:48:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19805' , '' , '1' ) 27/07/2022 03:12:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '2368' AND id_document != '59808' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-26') 27/07/2022 03:12:55 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2368', document_date = '2022-07-26', 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 = '3', id_causal = '0', price_tax_included = '31.60', price_tax_excluded = '25.90', date_upd = NOW() WHERE id_document = '59808' 27/07/2022 03:12:55 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '59808' 27/07/2022 03:12:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '59808' 27/07/2022 03:12:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59808' , '19109' , 'LUCERNA IN VETRO TRASPARENTE - DIAM. 10 - 1492' , '2' , '-2' , '1' , '15.8000' , '12.950819672131' , '22' , '0' , '31.60' ) 27/07/2022 03:12:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19109' AND id_supplier = '' 27/07/2022 03:12:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19109' , '' , '1' ) 27/07/2022 03:14:06 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892226692' AND id_product != '19684' AND ean13 != '' 27/07/2022 03:14:06 pm >> UPDATE ps_product SET id_supplier = '7', reference = '11/2', ean13 = '9788892226692', date_upd = NOW() WHERE id_product = '19684' 27/07/2022 03:14:07 pm >> UPDATE ps_product_lang SET name = 'AMEN - SET. 2022', description = '' WHERE id_product = '19684' 27/07/2022 03:14:07 pm >> UPDATE ps_product SET wholesale_price = '2.61', on_sale = '0', price = '3.9000' WHERE id_product = '19684' 27/07/2022 03:14:07 pm >> UPDATE ps_product_shop SET wholesale_price = '2.61', price = '3.9000', id_tax_rules_group = '4', id_category_default = '30', 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 = '19684' 27/07/2022 03:14:07 pm >> DELETE FROM ps_specific_price WHERE id_product = '19684'