13/09/2022 09:11:32 am >> SELECT document_num FROM ps_document WHERE document_num = '2715' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-13') 13/09/2022 09:11:32 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' , '2715' , '2022-09-13' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.80' , '16.23' , NOW() , NOW() ) 13/09/2022 09:11:32 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 = '61774' 13/09/2022 09:11:32 am >> DELETE FROM ps_document_detail WHERE id_document = '61774' 13/09/2022 09:11:32 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 ( '61774' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '4.8' , '3.9344262295082' , '22' , '0' , '4.80' ) 13/09/2022 09:11:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 13/09/2022 09:11:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 13/09/2022 09:11:32 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 ( '61774' , '1220' , 'BICCHIERI FLAMBEAUX - PZ. 50' , '1' , '-1' , '1' , '15.00' , '12.295081967213' , '22' , '0' , '15.00' ) 13/09/2022 09:11:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '1220' AND id_supplier = '' 13/09/2022 09:11:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1220' , '' , '1' ) 13/09/2022 09:43:38 am >> SELECT document_num FROM ps_document WHERE document_num = '2716' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-13') 13/09/2022 09:43: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 ( '11' , '2716' , '2022-09-13' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '197.70' , '167.37' , NOW() , NOW() ) 13/09/2022 09:43: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 = '61775' 13/09/2022 09:43:38 am >> DELETE FROM ps_document_detail WHERE id_document = '61775' 13/09/2022 09:43: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 ( '61775' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8' , '6.5573770491803' , '22' , '0' , '48.00' ) 13/09/2022 09:43:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '11384' AND id_supplier = '' 13/09/2022 09:43:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11384' , '' , '1' ) 13/09/2022 09:43: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 ( '61775' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '6' , '-6' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '21.00' ) 13/09/2022 09:43:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 13/09/2022 09:43:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 13/09/2022 09:43: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 ( '61775' , '7311' , 'OSTIA SOTTILE 74MM' , '4' , '-4' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '7.60' ) 13/09/2022 09:43:39 am >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 13/09/2022 09:43:39 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 13/09/2022 09:43: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 ( '61775' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.00' , '3.8461538461538' , '4' , '0' , '4.00' ) 13/09/2022 09:43:39 am >> DELETE FROM ps_product_supplier WHERE id_product = '16691' AND id_supplier = '' 13/09/2022 09:43:39 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16691' , '' , '1' ) 13/09/2022 09:43: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 ( '61775' , '15335' , 'CANDELA VOTIVA 20X40 DECORATA' , '25' , '-25' , '1' , '2' , '1.6393442622951' , '22' , '0' , '50.00' ) 13/09/2022 09:43:39 am >> DELETE FROM ps_product_supplier WHERE id_product = '15335' AND id_supplier = '' 13/09/2022 09:43:39 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15335' , '' , '1' ) 13/09/2022 09:43: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 ( '61775' , '7202' , 'ARTICOLI RELIGIOSI' , '25' , '-25' , '1' , '0.35' , '0.28688524590164' , '22' , '0' , '8.75' ) 13/09/2022 09:43:39 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 13/09/2022 09:43:39 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 13/09/2022 09:43: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 ( '61775' , '4221' , 'FLAMBEAUX IN PLASTICA - PZ 50 - OGGETTI' , '1' , '-1' , '1' , '15.00' , '12.295081967213' , '22' , '0' , '15.00' ) 13/09/2022 09:43:39 am >> DELETE FROM ps_product_supplier WHERE id_product = '4221' AND id_supplier = '' 13/09/2022 09:43:39 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4221' , '' , '1' ) 13/09/2022 09:43: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 ( '61775' , '19693' , 'CALENDARIO LITURGICO 2023' , '2' , '-2' , '4' , '0.50' , '0.5' , '0' , '0' , '1.00' ) 13/09/2022 09:43:39 am >> DELETE FROM ps_product_supplier WHERE id_product = '19693' AND id_supplier = '' 13/09/2022 09:43:39 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19693' , '' , '1' ) 13/09/2022 09:43: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 ( '61775' , '14712' , 'VERGINE DEL SILENZIO - E. ANTENUCCI' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 13/09/2022 09:43:39 am >> DELETE FROM ps_product_supplier WHERE id_product = '14712' AND id_supplier = '' 13/09/2022 09:43:39 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14712' , '' , '1' ) 13/09/2022 09:43: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 ( '61775' , '19922' , 'AGENDA DEVOZIONALE 2023 - 40808' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '5' , '9.50' ) 13/09/2022 09:43:39 am >> DELETE FROM ps_product_supplier WHERE id_product = '19922' AND id_supplier = '' 13/09/2022 09:43:39 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19922' , '' , '1' ) 13/09/2022 09:43: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 ( '61775' , '19150' , 'MOCCOLO 70X200' , '4' , '-4' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '30.00' ) 13/09/2022 09:43:39 am >> DELETE FROM ps_product_supplier WHERE id_product = '19150' AND id_supplier = '' 13/09/2022 09:43:39 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19150' , '' , '1' ) 13/09/2022 10:04:40 am >> SELECT document_num FROM ps_document WHERE document_num = '2717' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-13') 13/09/2022 10:04:40 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2717' , '2022-09-13' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '70.00' , '60.12' , NOW() , NOW() ) 13/09/2022 10:04:40 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61776' 13/09/2022 10:04:40 am >> DELETE FROM ps_document_detail WHERE id_document = '61776' 13/09/2022 10:04:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61776' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 13/09/2022 10:04:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '17160' AND id_supplier = '' 13/09/2022 10:04:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17160' , '' , '1' ) 13/09/2022 10:04: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 ( '61776' , '17966' , 'DEI VIZI E DELLE VIRTU - PAPA FRANCESCO' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 13/09/2022 10:04:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '17966' AND id_supplier = '' 13/09/2022 10:04:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17966' , '' , '1' ) 13/09/2022 10:04: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 ( '61776' , '18217' , 'BRACCIALE DECINA PIETRE - BD019' , '1' , '-1' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '2.00' ) 13/09/2022 10:04:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '18217' AND id_supplier = '' 13/09/2022 10:04:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18217' , '' , '1' ) 13/09/2022 10:04: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 ( '61776' , '18896' , 'BRACCIALE DECINA CROMO - BC1759' , '1' , '-1' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '2.00' ) 13/09/2022 10:04:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '18896' AND id_supplier = '' 13/09/2022 10:04:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18896' , '' , '1' ) 13/09/2022 10:04: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 ( '61776' , '18897' , 'BRACCIALE DECINA PIETRA - BC1843' , '1' , '-1' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '2.00' ) 13/09/2022 10:04:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '18897' AND id_supplier = '' 13/09/2022 10:04:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18897' , '' , '1' ) 13/09/2022 10:04: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 ( '61776' , '1350' , 'BRACCIALETTO CON CROCE - 29002 03' , '1' , '-1' , '1' , '3.00' , '2.4590163934426' , '22' , '0' , '3.00' ) 13/09/2022 10:04:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '1350' AND id_supplier = '' 13/09/2022 10:04:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1350' , '' , '1' ) 13/09/2022 10:04: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 ( '61776' , '19594' , 'POLO JERSEY COTONE 100%' , '1' , '-1' , '1' , '35.8' , '29.344262295082' , '22' , '0' , '35.80' ) 13/09/2022 10:04:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '19594' AND id_supplier = '' 13/09/2022 10:04:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19594' , '' , '1' ) 13/09/2022 10:07:39 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 13/09/2022 10:07:39 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19925' , '1' , '' , 'nuovo-prodotto' ) 13/09/2022 10:07:39 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '19925' , '1' , '1' , '2' , NOW() , NOW() ) 13/09/2022 10:07:39 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '19925' , '0' , '1' , '0' , '0' ) 13/09/2022 10:09:22 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892226715' AND id_product != '19925' AND ean13 != '' 13/09/2022 10:09:22 am >> UPDATE ps_product SET id_supplier = '', reference = '10/2', ean13 = '9788892226715', date_upd = NOW() WHERE id_product = '19925' 13/09/2022 10:09:22 am >> UPDATE ps_product_lang SET name = 'AMEN - NOV. 2022', description = '' WHERE id_product = '19925' 13/09/2022 10:09:22 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3.9' WHERE id_product = '19925' 13/09/2022 10:09:22 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3.9', 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 = '19925' 13/09/2022 10:09:22 am >> DELETE FROM ps_specific_price WHERE id_product = '19925' 13/09/2022 10:09:23 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '19925' 13/09/2022 10:09:23 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19926' , '1' , '' , 'nuovo-prodotto' ) 13/09/2022 10:09:23 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '19926' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19925' 13/09/2022 10:09:23 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19926' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19925' 13/09/2022 10:09:43 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892226722' AND id_product != '19926' AND ean13 != '' 13/09/2022 10:09:43 am >> UPDATE ps_product SET id_supplier = '', reference = '10/2', ean13 = '9788892226722', date_upd = NOW() WHERE id_product = '19926' 13/09/2022 10:09:43 am >> UPDATE ps_product_lang SET name = 'AMEN - DIC. 2022', description = '' WHERE id_product = '19926' 13/09/2022 10:09:43 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3.9' WHERE id_product = '19926' 13/09/2022 10:09:43 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3.9', 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 = '19926' 13/09/2022 10:09:43 am >> DELETE FROM ps_specific_price WHERE id_product = '19926' 13/09/2022 10:09:46 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 = '19926' 13/09/2022 10:09:46 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19927' , '1' , '' , 'nuovo-prodotto' ) 13/09/2022 10:09:46 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 '19927' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19926' 13/09/2022 10:09:46 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19927' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19926' 13/09/2022 10:10:22 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8051739455243' AND id_product != '19927' AND ean13 != '' 13/09/2022 10:10:22 am >> UPDATE ps_product SET id_supplier = '', reference = '10/2', ean13 = '8051739455243', date_upd = NOW() WHERE id_product = '19927' 13/09/2022 10:10:22 am >> UPDATE ps_product_lang SET name = 'INSIEME NELLA MESSA - NOV. 2022', description = '' WHERE id_product = '19927' 13/09/2022 10:10:22 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '1.8' WHERE id_product = '19927' 13/09/2022 10:10:22 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '1.8', 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 = '19927' 13/09/2022 10:10:22 am >> DELETE FROM ps_specific_price WHERE id_product = '19927' 13/09/2022 10:10:28 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 = '19927' 13/09/2022 10:10:28 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19928' , '1' , '' , 'nuovo-prodotto' ) 13/09/2022 10:10:28 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 '19928' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19927' 13/09/2022 10:10:28 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19928' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19927' 13/09/2022 10:11:04 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8051739455113' AND id_product != '19928' AND ean13 != '' 13/09/2022 10:11:04 am >> UPDATE ps_product SET id_supplier = '', reference = '10/2', ean13 = '8051739455113', date_upd = NOW() WHERE id_product = '19928' 13/09/2022 10:11:04 am >> UPDATE ps_product_lang SET name = 'PAROLA E PREGHIERA - OTT. 2022', description = '' WHERE id_product = '19928' 13/09/2022 10:11:04 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '2.9' WHERE id_product = '19928' 13/09/2022 10:11:04 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '2.9', 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 = '19928' 13/09/2022 10:11:04 am >> DELETE FROM ps_specific_price WHERE id_product = '19928' 13/09/2022 10:11:05 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 = '19928' 13/09/2022 10:11:05 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19929' , '1' , '' , 'nuovo-prodotto' ) 13/09/2022 10:11:05 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 '19929' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19928' 13/09/2022 10:11:05 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19929' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19928' 13/09/2022 10:11:26 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8051739455120' AND id_product != '19929' AND ean13 != '' 13/09/2022 10:11:26 am >> UPDATE ps_product SET id_supplier = '', reference = '10/2', ean13 = '8051739455120', date_upd = NOW() WHERE id_product = '19929' 13/09/2022 10:11:26 am >> UPDATE ps_product_lang SET name = 'PAROLA E PREGHIERA - NOV. 2022', description = '' WHERE id_product = '19929' 13/09/2022 10:11:26 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '2.9' WHERE id_product = '19929' 13/09/2022 10:11:26 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '2.9', 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 = '19929' 13/09/2022 10:11:26 am >> DELETE FROM ps_specific_price WHERE id_product = '19929' 13/09/2022 10:11:28 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 = '19929' 13/09/2022 10:11:28 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19930' , '1' , '' , 'nuovo-prodotto' ) 13/09/2022 10:11:28 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 '19930' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19929' 13/09/2022 10:11:28 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19930' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19929' 13/09/2022 10:13:04 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788885589643' AND id_product != '19930' AND ean13 != '' 13/09/2022 10:13:04 am >> UPDATE ps_product SET id_supplier = '', reference = '10/2', ean13 = '9788885589643', date_upd = NOW() WHERE id_product = '19930' 13/09/2022 10:13:04 am >> UPDATE ps_product_lang SET name = 'PANE QUOTIDIANO - NOV/DIC 2022', description = '' WHERE id_product = '19930' 13/09/2022 10:13:04 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3.5' WHERE id_product = '19930' 13/09/2022 10:13:04 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3.5', id_tax_rules_group = '4', id_category_default = '343', 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 = '19930' 13/09/2022 10:13:04 am >> DELETE FROM ps_specific_price WHERE id_product = '19930' 13/09/2022 10:16:14 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '38697' , '2022-09-09' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , 'CONTO DEPOSITO FINO AL 31/12/2022' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '167.50' , '167.50' , NOW() , NOW() ) 13/09/2022 10:16:14 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61777' 13/09/2022 10:16:14 am >> DELETE FROM ps_document_detail WHERE id_document = '61777' 13/09/2022 10:16:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61777' , '3649' , 'DON ERNEST SIMONI - M. MUOLO' , '20' , '20' , '4' , '12.50' , '12.5' , '0' , '33' , '167.5000' ) 13/09/2022 10:16:14 am >> DELETE FROM ps_product_supplier WHERE id_product = '3649' AND id_supplier = '7' 13/09/2022 10:16:14 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3649' , '7' , '1' ) 13/09/2022 10:20:23 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 13/09/2022 10:20:23 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19931' , '1' , '' , 'nuovo-prodotto' ) 13/09/2022 10:20:23 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '19931' , '1' , '1' , '2' , NOW() , NOW() ) 13/09/2022 10:20:23 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '19931' , '0' , '1' , '0' , '0' ) 13/09/2022 10:21:09 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892870123' AND id_product != '19931' AND ean13 != '' 13/09/2022 10:21:09 am >> UPDATE ps_product SET id_supplier = '', reference = '5/4', ean13 = '9788892870123', date_upd = NOW() WHERE id_product = '19931' 13/09/2022 10:21:09 am >> UPDATE ps_product_lang SET name = '100 IDEE PER IL CATECHISMO', description = '' WHERE id_product = '19931' 13/09/2022 10:21:09 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '14.9' WHERE id_product = '19931' 13/09/2022 10:21:10 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '14.9', id_tax_rules_group = '4', id_category_default = '26', id_argoment_default = '25', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19931' 13/09/2022 10:21:10 am >> DELETE FROM ps_specific_price WHERE id_product = '19931' 13/09/2022 10:21:11 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 = '19931' 13/09/2022 10:21:11 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19932' , '1' , '' , 'nuovo-prodotto' ) 13/09/2022 10:21:11 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 '19932' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19931' 13/09/2022 10:21:11 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19932' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19931' 13/09/2022 10:21:46 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892870130' AND id_product != '19932' AND ean13 != '' 13/09/2022 10:21:46 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788892870130', date_upd = NOW() WHERE id_product = '19932' 13/09/2022 10:21:46 am >> UPDATE ps_product_lang SET name = '100 IDEE PER IL CATECHISMO 2', description = '' WHERE id_product = '19932' 13/09/2022 10:21:46 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '14.9' WHERE id_product = '19932' 13/09/2022 10:21:46 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '14.9', id_tax_rules_group = '4', id_category_default = '26', id_argoment_default = '25', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19932' 13/09/2022 10:21:46 am >> DELETE FROM ps_specific_price WHERE id_product = '19932' 13/09/2022 10:21:47 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 = '19932' 13/09/2022 10:21:47 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19933' , '1' , '' , 'nuovo-prodotto' ) 13/09/2022 10:21:47 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 '19933' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19932' 13/09/2022 10:21:47 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19933' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19932' 13/09/2022 10:22:44 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892870147' AND id_product != '19933' AND ean13 != '' 13/09/2022 10:22:44 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788892870147', date_upd = NOW() WHERE id_product = '19933' 13/09/2022 10:22:44 am >> UPDATE ps_product_lang SET name = 'PADRE NOSTRO PER I PICCOLI', description = '' WHERE id_product = '19933' 13/09/2022 10:22:44 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3.5' WHERE id_product = '19933' 13/09/2022 10:22:44 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3.5', id_tax_rules_group = '4', id_category_default = '26', id_argoment_default = '25', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19933' 13/09/2022 10:22:44 am >> DELETE FROM ps_specific_price WHERE id_product = '19933' 13/09/2022 10:22:45 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 = '19933' 13/09/2022 10:22:45 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19934' , '1' , '' , 'nuovo-prodotto' ) 13/09/2022 10:22:45 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 '19934' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19933' 13/09/2022 10:22:45 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19934' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19933' 13/09/2022 10:23:03 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892870154' AND id_product != '19934' AND ean13 != '' 13/09/2022 10:23:03 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788892870154', date_upd = NOW() WHERE id_product = '19934' 13/09/2022 10:23:03 am >> UPDATE ps_product_lang SET name = 'PREGHIERE PIù BELLE', description = '' WHERE id_product = '19934' 13/09/2022 10:23:03 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3.5' WHERE id_product = '19934' 13/09/2022 10:23:03 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3.5', id_tax_rules_group = '4', id_category_default = '26', id_argoment_default = '25', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19934' 13/09/2022 10:23:03 am >> DELETE FROM ps_specific_price WHERE id_product = '19934' 13/09/2022 10:23:04 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 = '19934' 13/09/2022 10:23:04 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19935' , '1' , '' , 'nuovo-prodotto' ) 13/09/2022 10:23:04 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 '19935' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19934' 13/09/2022 10:23:04 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19935' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19934' 13/09/2022 10:24:13 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892870055' AND id_product != '19935' AND ean13 != '' 13/09/2022 10:24:13 am >> UPDATE ps_product SET id_supplier = '', reference = '8/1', ean13 = '9788892870055', date_upd = NOW() WHERE id_product = '19935' 13/09/2022 10:24:13 am >> UPDATE ps_product_lang SET name = 'CONDIVIDERE LA PAROLA ANNO A - U. DE VANNA', description = '' WHERE id_product = '19935' 13/09/2022 10:24:13 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '18' WHERE id_product = '19935' 13/09/2022 10:24:13 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '18', id_tax_rules_group = '4', id_category_default = '26', 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 = '19935' 13/09/2022 10:24:13 am >> DELETE FROM ps_specific_price WHERE id_product = '19935' 13/09/2022 10:24:15 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 = '19935' 13/09/2022 10:24:15 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19936' , '1' , '' , 'nuovo-prodotto' ) 13/09/2022 10:24:15 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 '19936' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19935' 13/09/2022 10:24:15 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19936' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19935' 13/09/2022 10:25:04 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788861249813' AND id_product != '19936' AND ean13 != '' 13/09/2022 10:25:04 am >> UPDATE ps_product SET id_supplier = '', reference = '2/2', ean13 = '9788861249813', date_upd = NOW() WHERE id_product = '19936' 13/09/2022 10:25:04 am >> UPDATE ps_product_lang SET name = 'SANTI PER IL CATECHISMO', description = '' WHERE id_product = '19936' 13/09/2022 10:25:04 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '9.9' WHERE id_product = '19936' 13/09/2022 10:25:04 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '9.9', id_tax_rules_group = '4', id_category_default = '26', 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 = '19936' 13/09/2022 10:25:04 am >> DELETE FROM ps_specific_price WHERE id_product = '19936' 13/09/2022 10:25:05 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 = '19936' 13/09/2022 10:25:05 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19937' , '1' , '' , 'nuovo-prodotto' ) 13/09/2022 10:25:05 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 '19937' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19936' 13/09/2022 10:25:05 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19937' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19936' 13/09/2022 10:25:45 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788861249738' AND id_product != '19937' AND ean13 != '' 13/09/2022 10:25:45 am >> UPDATE ps_product SET id_supplier = '', reference = '5/4', ean13 = '9788861249738', date_upd = NOW() WHERE id_product = '19937' 13/09/2022 10:25:45 am >> UPDATE ps_product_lang SET name = 'SANTI A COLORI', description = '' WHERE id_product = '19937' 13/09/2022 10:25:45 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '8.9' WHERE id_product = '19937' 13/09/2022 10:25:45 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '8.9', id_tax_rules_group = '4', id_category_default = '26', id_argoment_default = '25', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19937' 13/09/2022 10:25:45 am >> DELETE FROM ps_specific_price WHERE id_product = '19937' 13/09/2022 10:25:45 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 = '19937' 13/09/2022 10:25:46 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19938' , '1' , '' , 'nuovo-prodotto' ) 13/09/2022 10:25:46 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 '19938' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19937' 13/09/2022 10:25:46 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19938' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19937' 13/09/2022 10:32:05 am >> SELECT ean13 FROM ps_product WHERE ean13 = '' AND id_product != '19938' AND ean13 != '' 13/09/2022 10:32:05 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '', date_upd = NOW() WHERE id_product = '19938' 13/09/2022 10:32:05 am >> UPDATE ps_product_lang SET name = 'AGENDA 2023 SAN PAOLO', description = '' WHERE id_product = '19938' 13/09/2022 10:32:05 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '9.01639344262295' WHERE id_product = '19938' 13/09/2022 10:32:05 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '9.01639344262295', id_tax_rules_group = '1', id_category_default = '30', id_argoment_default = '107', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19938' 13/09/2022 10:32:05 am >> DELETE FROM ps_specific_price WHERE id_product = '19938' 13/09/2022 10:33: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 ( '33' , '607810' , '2022-09-09' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '6.09' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '257.84' , '231.27' , NOW() , NOW() ) 13/09/2022 10:33: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 = '61778' 13/09/2022 10:33:11 am >> DELETE FROM ps_document_detail WHERE id_document = '61778' 13/09/2022 10:33: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 ( '61778' , '19931' , '100 IDEE PER IL CATECHISMO' , '1' , '1' , '4' , '14.90' , '14.9' , '0' , '30' , '10.4300' ) 13/09/2022 10:33:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '19931' AND id_supplier = '7' 13/09/2022 10:33:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19931' , '7' , '1' ) 13/09/2022 10:33: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 ( '61778' , '19932' , '100 IDEE PER IL CATECHISMO 2' , '1' , '1' , '4' , '14.90' , '14.9' , '0' , '30' , '10.4300' ) 13/09/2022 10:33:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '19932' AND id_supplier = '7' 13/09/2022 10:33:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19932' , '7' , '1' ) 13/09/2022 10:33: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 ( '61778' , '19933' , 'PADRE NOSTRO PER I PICCOLI' , '3' , '3' , '4' , '3.50' , '3.5' , '0' , '30' , '7.3500' ) 13/09/2022 10:33:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '19933' AND id_supplier = '7' 13/09/2022 10:33:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19933' , '7' , '1' ) 13/09/2022 10:33: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 ( '61778' , '19934' , 'PREGHIERE PIù BELLE' , '3' , '3' , '4' , '3.5' , '3.5' , '0' , '30' , '7.3500' ) 13/09/2022 10:33:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '19934' AND id_supplier = '7' 13/09/2022 10:33:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19934' , '7' , '1' ) 13/09/2022 10:33: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 ( '61778' , '19935' , 'CONDIVIDERE LA PAROLA ANNO A - U. DE VANNA' , '1' , '1' , '4' , '18.00' , '18' , '0' , '30' , '12.6000' ) 13/09/2022 10:33:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '19935' AND id_supplier = '7' 13/09/2022 10:33:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19935' , '7' , '1' ) 13/09/2022 10:33: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 ( '61778' , '19936' , 'SANTI PER IL CATECHISMO' , '2' , '2' , '4' , '9.90' , '9.9' , '0' , '30' , '13.8600' ) 13/09/2022 10:33:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '19936' AND id_supplier = '7' 13/09/2022 10:33:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19936' , '7' , '1' ) 13/09/2022 10:33: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 ( '61778' , '19937' , 'SANTI A COLORI' , '1' , '1' , '4' , '8.90' , '8.9' , '0' , '30' , '6.2300' ) 13/09/2022 10:33:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '19937' AND id_supplier = '7' 13/09/2022 10:33:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19937' , '7' , '1' ) 13/09/2022 10:33: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 ( '61778' , '19693' , 'CALENDARIO LITURGICO 2023' , '108' , '108' , '4' , '0.50' , '0.5' , '0' , '33' , '36.1800' ) 13/09/2022 10:33:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '19693' AND id_supplier = '7' 13/09/2022 10:33:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19693' , '7' , '1' ) 13/09/2022 10:33: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 ( '61778' , '19693' , 'CALENDARIO LITURGICO 2023' , '9' , '9' , '4' , '0.50' , '0.5' , '0' , '100' , '0.0000' ) 13/09/2022 10:33:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '19693' AND id_supplier = '7' 13/09/2022 10:33:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19693' , '7' , '1' ) 13/09/2022 10:33: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 ( '61778' , '19938' , 'AGENDA 2023 SAN PAOLO' , '25' , '25' , '1' , '4.83' , '3.9590163934426' , '22' , '0' , '147.3150' ) 13/09/2022 10:33:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '19938' AND id_supplier = '7' 13/09/2022 10:33:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19938' , '7' , '1' ) 13/09/2022 10:37:06 am >> SELECT document_num FROM ps_document WHERE document_num = '2718' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-13') 13/09/2022 10:37:06 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2718' , '2022-09-13' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '20.90' , '18.48' , NOW() , NOW() ) 13/09/2022 10:37: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 = '61779' 13/09/2022 10:37:06 am >> DELETE FROM ps_document_detail WHERE id_document = '61779' 13/09/2022 10:37: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 ( '61779' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 13/09/2022 10:37:06 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 13/09/2022 10:37:06 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 13/09/2022 10:37: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 ( '61779' , '16689' , 'OSTIA PAN DI CENA mm80' , '3' , '-3' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '6.00' ) 13/09/2022 10:37:06 am >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = '' 13/09/2022 10:37:06 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '' , '1' ) 13/09/2022 10:37: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 ( '61779' , '11756' , 'VINO BIANCO SECCO - 14%' , '1' , '-1' , '1' , '6.50' , '5.327868852459' , '22' , '0' , '6.50' ) 13/09/2022 10:37:06 am >> DELETE FROM ps_product_supplier WHERE id_product = '11756' AND id_supplier = '' 13/09/2022 10:37:06 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11756' , '' , '1' ) 13/09/2022 10:37: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 ( '61779' , '1914' , 'CERA DELLA LITURGIA' , '1' , '-1' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '4.90' ) 13/09/2022 10:37:06 am >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 13/09/2022 10:37:06 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 13/09/2022 10:38:51 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 13/09/2022 10:38:51 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19939' , '1' , '' , 'nuovo-prodotto' ) 13/09/2022 10:38:51 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '19939' , '1' , '1' , '2' , NOW() , NOW() ) 13/09/2022 10:38:51 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '19939' , '0' , '1' , '0' , '0' ) 13/09/2022 10:39:35 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788832047806' AND id_product != '19939' AND ean13 != '' 13/09/2022 10:39:35 am >> UPDATE ps_product SET id_supplier = '', reference = '5/5', ean13 = '9788832047806', date_upd = NOW() WHERE id_product = '19939' 13/09/2022 10:39:35 am >> UPDATE ps_product_lang SET name = 'GIANNA BERETTA MOLLA - M. ANTOGNAZZA', description = '' WHERE id_product = '19939' 13/09/2022 10:39:35 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '8.5' WHERE id_product = '19939' 13/09/2022 10:39:35 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '8.5', id_tax_rules_group = '4', id_category_default = '57', id_argoment_default = '25', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19939' 13/09/2022 10:39:35 am >> DELETE FROM ps_specific_price WHERE id_product = '19939' 13/09/2022 10:39:36 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 = '19939' 13/09/2022 10:39:36 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19940' , '1' , '' , 'nuovo-prodotto' ) 13/09/2022 10:39:36 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 '19940' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19939' 13/09/2022 10:39:36 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19940' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19939' 13/09/2022 10:40:28 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884247612' AND id_product != '19940' AND ean13 != '' 13/09/2022 10:40:28 am >> UPDATE ps_product SET id_supplier = '', reference = '6/5', ean13 = '9788884247612', date_upd = NOW() WHERE id_product = '19940' 13/09/2022 10:40:28 am >> UPDATE ps_product_lang SET name = 'VANGELO SECONDO MARIA - A. TRADIGO', description = '' WHERE id_product = '19940' 13/09/2022 10:40:28 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '14' WHERE id_product = '19940' 13/09/2022 10:40:28 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '14', id_tax_rules_group = '4', id_category_default = '83', id_argoment_default = '73', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19940' 13/09/2022 10:40:28 am >> DELETE FROM ps_specific_price WHERE id_product = '19940' 13/09/2022 10:40:28 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 = '19940' 13/09/2022 10:40:28 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19941' , '1' , '' , 'nuovo-prodotto' ) 13/09/2022 10:40:28 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 '19941' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19940' 13/09/2022 10:40:28 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19941' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19940' 13/09/2022 10:41:14 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884247605' AND id_product != '19941' AND ean13 != '' 13/09/2022 10:41:14 am >> UPDATE ps_product SET id_supplier = '', reference = '7/7', ean13 = '9788884247605', date_upd = NOW() WHERE id_product = '19941' 13/09/2022 10:41:14 am >> UPDATE ps_product_lang SET name = 'SEMINATORI DI SPERANZA - AAVV', description = '' WHERE id_product = '19941' 13/09/2022 10:41:14 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '14' WHERE id_product = '19941' 13/09/2022 10:41:14 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '14', id_tax_rules_group = '4', id_category_default = '83', 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 = '19941' 13/09/2022 10:41:14 am >> DELETE FROM ps_specific_price WHERE id_product = '19941' 13/09/2022 10:41:15 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 = '19941' 13/09/2022 10:41:15 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19942' , '1' , '' , 'nuovo-prodotto' ) 13/09/2022 10:41:15 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 '19942' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19941' 13/09/2022 10:41:15 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19942' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19941' 13/09/2022 10:42:29 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892229396' AND id_product != '19942' AND ean13 != '' 13/09/2022 10:42:29 am >> UPDATE ps_product SET id_supplier = '', reference = '7/4', ean13 = '9788892229396', date_upd = NOW() WHERE id_product = '19942' 13/09/2022 10:42:29 am >> UPDATE ps_product_lang SET name = 'ORGOGLIO CONTRO UMILTA\' - A. COMASTRI', description = '' WHERE id_product = '19942' 13/09/2022 10:42:29 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '15' WHERE id_product = '19942' 13/09/2022 10:42:29 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '15', 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 = '19942' 13/09/2022 10:42:29 am >> DELETE FROM ps_specific_price WHERE id_product = '19942' 13/09/2022 10:42:30 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 = '19942' 13/09/2022 10:42:30 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19943' , '1' , '' , 'nuovo-prodotto' ) 13/09/2022 10:42:30 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 '19943' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19942' 13/09/2022 10:42:30 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19943' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19942' 13/09/2022 10:43:19 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892229365' AND id_product != '19943' AND ean13 != '' 13/09/2022 10:43:19 am >> UPDATE ps_product SET id_supplier = '', reference = '7/5', ean13 = '9788892229365', date_upd = NOW() WHERE id_product = '19943' 13/09/2022 10:43:19 am >> UPDATE ps_product_lang SET name = 'PASTORI DENTRO - A. BAGNASCO', description = '' WHERE id_product = '19943' 13/09/2022 10:43:19 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '18' WHERE id_product = '19943' 13/09/2022 10:43:19 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '18', id_tax_rules_group = '4', id_category_default = '30', 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 = '19943' 13/09/2022 10:43:19 am >> DELETE FROM ps_specific_price WHERE id_product = '19943' 13/09/2022 10:43:19 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 = '19943' 13/09/2022 10:43:19 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19944' , '1' , '' , 'nuovo-prodotto' ) 13/09/2022 10:43:19 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 '19944' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19943' 13/09/2022 10:43:19 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19944' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19943' 13/09/2022 10:44:05 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892229549' AND id_product != '19944' AND ean13 != '' 13/09/2022 10:44:05 am >> UPDATE ps_product SET id_supplier = '', reference = '7/5', ean13 = '9788892229549', date_upd = NOW() WHERE id_product = '19944' 13/09/2022 10:44:05 am >> UPDATE ps_product_lang SET name = 'COME UNA PICCOLA CREATURE - G. FORLAI', description = '' WHERE id_product = '19944' 13/09/2022 10:44:05 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '16' WHERE id_product = '19944' 13/09/2022 10:44:05 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '16', 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 = '19944' 13/09/2022 10:44:05 am >> DELETE FROM ps_specific_price WHERE id_product = '19944' 13/09/2022 10:44:06 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 = '19944' 13/09/2022 10:44:06 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19945' , '1' , '' , 'nuovo-prodotto' ) 13/09/2022 10:44:06 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 '19945' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19944' 13/09/2022 10:44:06 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19945' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19944' 13/09/2022 10:45:59 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892229556' AND id_product != '19945' AND ean13 != '' 13/09/2022 10:45:59 am >> UPDATE ps_product SET id_supplier = '', reference = '13/6', ean13 = '9788892229556', date_upd = NOW() WHERE id_product = '19945' 13/09/2022 10:45:59 am >> UPDATE ps_product_lang SET name = 'GENERE DEL SACRAMENTO - A. GRILLO', description = '' WHERE id_product = '19945' 13/09/2022 10:45:59 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '35' WHERE id_product = '19945' 13/09/2022 10:45:59 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '35', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '65', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19945' 13/09/2022 10:45:59 am >> DELETE FROM ps_specific_price WHERE id_product = '19945' 13/09/2022 10:46:00 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 = '19945' 13/09/2022 10:46:00 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19946' , '1' , '' , 'nuovo-prodotto' ) 13/09/2022 10:46:00 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 '19946' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19945' 13/09/2022 10:46:00 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19946' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19945' 13/09/2022 10:47:02 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831278683' AND id_product != '19946' AND ean13 != '' 13/09/2022 10:47:02 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788831278683', date_upd = NOW() WHERE id_product = '19946' 13/09/2022 10:47:02 am >> UPDATE ps_product_lang SET name = 'PENSIERI EUCARISTICI 2023', description = '' WHERE id_product = '19946' 13/09/2022 10:47:02 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '6.9' WHERE id_product = '19946' 13/09/2022 10:47:02 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '6.9', id_tax_rules_group = '4', id_category_default = '97', id_argoment_default = '107', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19946' 13/09/2022 10:47:02 am >> DELETE FROM ps_specific_price WHERE id_product = '19946' 13/09/2022 10:47:03 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 = '19946' 13/09/2022 10:47:03 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19947' , '1' , '' , 'nuovo-prodotto' ) 13/09/2022 10:47:03 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 '19947' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19946' 13/09/2022 10:47:03 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19947' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19946' 13/09/2022 10:48:12 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788839922038' AND id_product != '19947' AND ean13 != '' 13/09/2022 10:48:12 am >> UPDATE ps_product SET id_supplier = '', reference = '11/4', ean13 = '9788839922038', date_upd = NOW() WHERE id_product = '19947' 13/09/2022 10:48:12 am >> UPDATE ps_product_lang SET name = 'COSI\' STA SCRITTO - B. BOURGINE', description = '' WHERE id_product = '19947' 13/09/2022 10:48:12 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '32' WHERE id_product = '19947' 13/09/2022 10:48:12 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '32', id_tax_rules_group = '4', id_category_default = '111', id_argoment_default = '65', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19947' 13/09/2022 10:48:12 am >> DELETE FROM ps_specific_price WHERE id_product = '19947' 13/09/2022 10:48:13 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 = '19947' 13/09/2022 10:48:13 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19948' , '1' , '' , 'nuovo-prodotto' ) 13/09/2022 10:48:13 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 '19948' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19947' 13/09/2022 10:48:13 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19948' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19947' 13/09/2022 10:49:35 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8019118024992' AND id_product != '19948' AND ean13 != '' 13/09/2022 10:49:35 am >> UPDATE ps_product SET id_supplier = '', reference = '8/3', ean13 = '8019118024992', date_upd = NOW() WHERE id_product = '19948' 13/09/2022 10:49:35 am >> UPDATE ps_product_lang SET name = 'CHIESA DEL SIGNORE - CD', description = '' WHERE id_product = '19948' 13/09/2022 10:49:35 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '10.573770491803279' WHERE id_product = '19948' 13/09/2022 10:49:35 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '10.573770491803279', id_tax_rules_group = '1', id_category_default = '27', id_argoment_default = '66', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19948' 13/09/2022 10:49:35 am >> DELETE FROM ps_specific_price WHERE id_product = '19948' 13/09/2022 10:49:36 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 = '19948' 13/09/2022 10:49:36 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19949' , '1' , '' , 'nuovo-prodotto' ) 13/09/2022 10:49:36 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 '19949' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19948' 13/09/2022 10:49:36 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19949' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19948' 13/09/2022 10:51:25 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892228986' AND id_product != '19949' AND ean13 != '' 13/09/2022 10:51:25 am >> UPDATE ps_product SET id_supplier = '', reference = '7/1', ean13 = '9788892228986', date_upd = NOW() WHERE id_product = '19949' 13/09/2022 10:51:25 am >> UPDATE ps_product_lang SET name = 'VERBUM CARO ', description = '' WHERE id_product = '19949' 13/09/2022 10:51:25 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '49' WHERE id_product = '19949' 13/09/2022 10:51:25 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '49', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '72', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19949' 13/09/2022 10:51:25 am >> DELETE FROM ps_specific_price WHERE id_product = '19949' 13/09/2022 10:51:26 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 = '19949' 13/09/2022 10:51:26 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19950' , '1' , '' , 'nuovo-prodotto' ) 13/09/2022 10:51:26 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 '19950' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19949' 13/09/2022 10:51:26 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19950' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19949' 13/09/2022 10:52:18 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892228573' AND id_product != '19950' AND ean13 != '' 13/09/2022 10:52:18 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788892228573', date_upd = NOW() WHERE id_product = '19950' 13/09/2022 10:52:18 am >> UPDATE ps_product_lang SET name = 'BIBBIA SCRUTATE BIANCA GIGANTE', description = '' WHERE id_product = '19950' 13/09/2022 10:52:18 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '129' WHERE id_product = '19950' 13/09/2022 10:52:18 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '129', id_tax_rules_group = '4', id_category_default = '30', 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 = '19950' 13/09/2022 10:52:18 am >> DELETE FROM ps_specific_price WHERE id_product = '19950' 13/09/2022 10:52:25 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 = '19950' 13/09/2022 10:52:25 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19951' , '1' , '' , 'nuovo-prodotto' ) 13/09/2022 10:52:25 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 '19951' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19950' 13/09/2022 10:52:25 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19951' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19950' 13/09/2022 10:53:30 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831554688' AND id_product != '19951' AND ean13 != '' 13/09/2022 10:53:30 am >> UPDATE ps_product SET id_supplier = '', reference = '13/2', ean13 = '9788831554688', date_upd = NOW() WHERE id_product = '19951' 13/09/2022 10:53:30 am >> UPDATE ps_product_lang SET name = 'MATRIMONIO E FAMIGLIA - FIDALGO/GRILLO', description = '' WHERE id_product = '19951' 13/09/2022 10:53:30 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '26' WHERE id_product = '19951' 13/09/2022 10:53:30 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '26', id_tax_rules_group = '4', id_category_default = '27', id_argoment_default = '59', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19951' 13/09/2022 10:53:30 am >> DELETE FROM ps_specific_price WHERE id_product = '19951' 13/09/2022 10:53:36 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 = '19951' 13/09/2022 10:53:36 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19952' , '1' , '' , 'nuovo-prodotto' ) 13/09/2022 10:53:36 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 '19952' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19951' 13/09/2022 10:53:36 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19952' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19951' 13/09/2022 10:56:20 am >> SELECT document_num FROM ps_document WHERE document_num = '2719' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-13') 13/09/2022 10:56:20 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2719' , '2022-09-13' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '104.50' , '104.50' , NOW() , NOW() ) 13/09/2022 10:56:20 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61780' 13/09/2022 10:56:20 am >> DELETE FROM ps_document_detail WHERE id_document = '61780' 13/09/2022 10:56:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61780' , '17329' , 'MESSALE ROMANO D\'ALTARE N.E' , '1' , '-1' , '4' , '110.00' , '110' , '0' , '5' , '104.50' ) 13/09/2022 10:56:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '17329' AND id_supplier = '' 13/09/2022 10:56:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17329' , '' , '1' ) 13/09/2022 10:58:28 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788880713135' AND id_product != '19952' AND ean13 != '' 13/09/2022 10:58:28 am >> UPDATE ps_product SET id_supplier = '', reference = '1/2', ean13 = '9788880713135', date_upd = NOW() WHERE id_product = '19952' 13/09/2022 10:58:28 am >> UPDATE ps_product_lang SET name = 'FORMAZIONE CATECHISTICA DEI PRESBITERI', description = '' WHERE id_product = '19952' 13/09/2022 10:58:28 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '15' WHERE id_product = '19952' 13/09/2022 10:58:28 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '15', id_tax_rules_group = '4', id_category_default = '52', id_argoment_default = '22', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19952' 13/09/2022 10:58:28 am >> DELETE FROM ps_specific_price WHERE id_product = '19952' 13/09/2022 10:58:29 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 = '19952' 13/09/2022 10:58:29 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19953' , '1' , '' , 'nuovo-prodotto' ) 13/09/2022 10:58:29 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 '19953' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19952' 13/09/2022 10:58:29 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19953' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19952' 13/09/2022 10:59:23 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9728884241661' AND id_product != '19953' AND ean13 != '' 13/09/2022 10:59:23 am >> UPDATE ps_product SET id_supplier = '', reference = '5/1', ean13 = '9728884241661', date_upd = NOW() WHERE id_product = '19953' 13/09/2022 10:59:24 am >> UPDATE ps_product_lang SET name = 'FELIZ CITTA\' - GIOCO CARLO ACUTIS', description = '' WHERE id_product = '19953' 13/09/2022 10:59:24 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '15' WHERE id_product = '19953' 13/09/2022 10:59:24 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '15', id_tax_rules_group = '4', id_category_default = '83', 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 = '19953' 13/09/2022 10:59:24 am >> DELETE FROM ps_specific_price WHERE id_product = '19953' 13/09/2022 10:59:24 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 = '19953' 13/09/2022 10:59:25 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19954' , '1' , '' , 'nuovo-prodotto' ) 13/09/2022 10:59:25 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 '19954' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19953' 13/09/2022 10:59:25 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19954' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19953' 13/09/2022 11:00:27 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788825054316' AND id_product != '19954' AND ean13 != '' 13/09/2022 11:00:27 am >> UPDATE ps_product SET id_supplier = '', reference = '10/2', ean13 = '9788825054316', date_upd = NOW() WHERE id_product = '19954' 13/09/2022 11:00:27 am >> UPDATE ps_product_lang SET name = 'PICCOLO BREVIARIO FRANCESCANO', description = '' WHERE id_product = '19954' 13/09/2022 11:00:27 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '14' WHERE id_product = '19954' 13/09/2022 11:00:27 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '14', id_tax_rules_group = '4', id_category_default = '17', id_argoment_default = '28', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19954' 13/09/2022 11:00:27 am >> DELETE FROM ps_specific_price WHERE id_product = '19954' 13/09/2022 11:02:14 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '607510' , '2022-09-07' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '12.99' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '451.90' , '450.27' , NOW() , NOW() ) 13/09/2022 11:02:14 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61781' 13/09/2022 11:02:14 am >> DELETE FROM ps_document_detail WHERE id_document = '61781' 13/09/2022 11:02:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61781' , '19939' , 'GIANNA BERETTA MOLLA - M. ANTOGNAZZA' , '1' , '1' , '4' , '8.50' , '8.5' , '0' , '30' , '5.9500' ) 13/09/2022 11:02:14 am >> DELETE FROM ps_product_supplier WHERE id_product = '19939' AND id_supplier = '7' 13/09/2022 11:02:14 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19939' , '7' , '1' ) 13/09/2022 11:02:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61781' , '19940' , 'VANGELO SECONDO MARIA - A. TRADIGO' , '1' , '1' , '4' , '14.00' , '14' , '0' , '30' , '9.8000' ) 13/09/2022 11:02:14 am >> DELETE FROM ps_product_supplier WHERE id_product = '19940' AND id_supplier = '7' 13/09/2022 11:02:14 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19940' , '7' , '1' ) 13/09/2022 11:02:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61781' , '19941' , 'SEMINATORI DI SPERANZA - AAVV' , '1' , '1' , '4' , '14.00' , '14' , '0' , '30' , '9.8000' ) 13/09/2022 11:02:14 am >> DELETE FROM ps_product_supplier WHERE id_product = '19941' AND id_supplier = '7' 13/09/2022 11:02:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19941' , '7' , '1' ) 13/09/2022 11:02:15 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 ( '61781' , '19942' , 'ORGOGLIO CONTRO UMILTA - A. COMASTRI' , '1' , '1' , '4' , '15.00' , '15' , '0' , '33' , '10.0500' ) 13/09/2022 11:02:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '19942' AND id_supplier = '7' 13/09/2022 11:02:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19942' , '7' , '1' ) 13/09/2022 11:02:15 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 ( '61781' , '19943' , 'PASTORI DENTRO - A. BAGNASCO' , '1' , '1' , '4' , '18.00' , '18' , '0' , '33' , '12.0600' ) 13/09/2022 11:02:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '19943' AND id_supplier = '7' 13/09/2022 11:02:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19943' , '7' , '1' ) 13/09/2022 11:02:15 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 ( '61781' , '19944' , 'COME UNA PICCOLA CREATURE - G. FORLAI' , '1' , '1' , '4' , '16.00' , '16' , '0' , '33' , '10.7200' ) 13/09/2022 11:02:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '19944' AND id_supplier = '7' 13/09/2022 11:02:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19944' , '7' , '1' ) 13/09/2022 11:02:15 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 ( '61781' , '19945' , 'GENERE DEL SACRAMENTO - A. GRILLO' , '1' , '1' , '4' , '35.00' , '35' , '0' , '33' , '23.4500' ) 13/09/2022 11:02:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '19945' AND id_supplier = '7' 13/09/2022 11:02:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19945' , '7' , '1' ) 13/09/2022 11:02:15 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 ( '61781' , '19946' , 'PENSIERI EUCARISTICI 2023' , '2' , '2' , '4' , '6.90' , '6.9' , '0' , '30' , '9.6600' ) 13/09/2022 11:02:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '19946' AND id_supplier = '7' 13/09/2022 11:02:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19946' , '7' , '1' ) 13/09/2022 11:02:15 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 ( '61781' , '19947' , 'COSI STA SCRITTO - B. BOURGINE' , '1' , '1' , '4' , '32.00' , '32' , '0' , '30' , '22.4000' ) 13/09/2022 11:02:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '19947' AND id_supplier = '7' 13/09/2022 11:02:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19947' , '7' , '1' ) 13/09/2022 11:02:15 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 ( '61781' , '19948' , 'CHIESA DEL SIGNORE - CD' , '1' , '1' , '1' , '10.57' , '8.6639344262295' , '22' , '30' , '9.0268' ) 13/09/2022 11:02:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '19948' AND id_supplier = '7' 13/09/2022 11:02:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19948' , '7' , '1' ) 13/09/2022 11:02:15 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 ( '61781' , '19949' , 'VERBUM CARO ' , '1' , '1' , '4' , '49.00' , '49' , '0' , '33' , '32.8300' ) 13/09/2022 11:02:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '19949' AND id_supplier = '7' 13/09/2022 11:02:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19949' , '7' , '1' ) 13/09/2022 11:02:15 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 ( '61781' , '19950' , 'BIBBIA SCRUTATE BIANCA GIGANTE' , '1' , '1' , '4' , '129.00' , '129' , '0' , '33' , '86.4300' ) 13/09/2022 11:02:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '19950' AND id_supplier = '7' 13/09/2022 11:02:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19950' , '7' , '1' ) 13/09/2022 11:02:15 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 ( '61781' , '19951' , 'MATRIMONIO E FAMIGLIA - FIDALGO/GRILLO' , '1' , '1' , '4' , '26.00' , '26' , '0' , '33' , '17.4200' ) 13/09/2022 11:02:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '19951' AND id_supplier = '7' 13/09/2022 11:02:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19951' , '7' , '1' ) 13/09/2022 11:02:15 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 ( '61781' , '19925' , 'AMEN - NOV. 2022' , '24' , '24' , '4' , '3.90' , '3.9' , '0' , '33' , '62.7120' ) 13/09/2022 11:02:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '19925' AND id_supplier = '7' 13/09/2022 11:02:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19925' , '7' , '1' ) 13/09/2022 11:02:15 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 ( '61781' , '19925' , 'AMEN - NOV. 2022' , '2' , '2' , '4' , '3.90' , '3.9' , '0' , '100' , '0.0000' ) 13/09/2022 11:02:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '19925' AND id_supplier = '7' 13/09/2022 11:02:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19925' , '7' , '1' ) 13/09/2022 11:02:15 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 ( '61781' , '19926' , 'AMEN - DIC. 2022' , '24' , '24' , '4' , '3.90' , '3.9' , '0' , '33' , '62.7120' ) 13/09/2022 11:02:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '19926' AND id_supplier = '7' 13/09/2022 11:02:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19926' , '7' , '1' ) 13/09/2022 11:02:15 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 ( '61781' , '19926' , 'AMEN - DIC. 2022' , '2' , '2' , '4' , '3.90' , '3.9' , '0' , '100' , '0.0000' ) 13/09/2022 11:02:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '19926' AND id_supplier = '7' 13/09/2022 11:02:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19926' , '7' , '1' ) 13/09/2022 11:02:15 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 ( '61781' , '19928' , 'PAROLA E PREGHIERA - OTT. 2022' , '5' , '5' , '4' , '2.90' , '2.9' , '0' , '33' , '9.7150' ) 13/09/2022 11:02:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '19928' AND id_supplier = '7' 13/09/2022 11:02:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19928' , '7' , '1' ) 13/09/2022 11:02:15 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 ( '61781' , '19929' , 'PAROLA E PREGHIERA - NOV. 2022' , '5' , '5' , '4' , '2.90' , '2.9' , '0' , '33' , '9.7150' ) 13/09/2022 11:02:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '19929' AND id_supplier = '7' 13/09/2022 11:02:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19929' , '7' , '1' ) 13/09/2022 11:02:15 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 ( '61781' , '19930' , 'PANE QUOTIDIANO - NOV/DIC 2022' , '1' , '1' , '4' , '3.50' , '3.5' , '0' , '30' , '2.4500' ) 13/09/2022 11:02:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '19930' AND id_supplier = '7' 13/09/2022 11:02:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19930' , '7' , '1' ) 13/09/2022 11:02:15 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 ( '61781' , '19927' , 'INSIEME NELLA MESSA - NOV. 2022' , '1' , '1' , '4' , '1.80' , '1.8' , '0' , '33' , '1.2060' ) 13/09/2022 11:02:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '19927' AND id_supplier = '7' 13/09/2022 11:02:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19927' , '7' , '1' ) 13/09/2022 11:02:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61781' , '19952' , 'FORMAZIONE CATECHISTICA DEI PRESBITERI' , '1' , '1' , '4' , '15.00' , '15' , '0' , '30' , '10.5000' ) 13/09/2022 11:02:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '19952' AND id_supplier = '7' 13/09/2022 11:02:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19952' , '7' , '1' ) 13/09/2022 11:02:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61781' , '19953' , 'FELIZ CITTA - GIOCO CARLO ACUTIS' , '1' , '1' , '4' , '15.00' , '15' , '0' , '30' , '10.5000' ) 13/09/2022 11:02:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '19953' AND id_supplier = '7' 13/09/2022 11:02:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19953' , '7' , '1' ) 13/09/2022 11:02:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61781' , '19954' , 'PICCOLO BREVIARIO FRANCESCANO' , '1' , '1' , '4' , '14.00' , '14' , '0' , '30' , '9.8000' ) 13/09/2022 11:02:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '19954' AND id_supplier = '7' 13/09/2022 11:02:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19954' , '7' , '1' ) 13/09/2022 11:11:32 am >> SELECT ean13 FROM ps_product WHERE ean13 = '' AND id_product != '19938' AND ean13 != '' 13/09/2022 11:11:32 am >> UPDATE ps_product SET id_supplier = '7', reference = '', ean13 = '', date_upd = NOW() WHERE id_product = '19938' 13/09/2022 11:11:32 am >> UPDATE ps_product_lang SET name = 'AGENDA 2023 SAN PAOLO', description = '' WHERE id_product = '19938' 13/09/2022 11:11:32 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '8.19672131147541' WHERE id_product = '19938' 13/09/2022 11:11:32 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '8.19672131147541', id_tax_rules_group = '1', id_category_default = '30', id_argoment_default = '107', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19938' 13/09/2022 11:11:32 am >> DELETE FROM ps_specific_price WHERE id_product = '19938' 13/09/2022 11:12:05 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8051739455816' AND id_product != '19938' AND ean13 != '' 13/09/2022 11:12:05 am >> UPDATE ps_product SET id_supplier = '7', reference = '', ean13 = '8051739455816', date_upd = NOW() WHERE id_product = '19938' 13/09/2022 11:12:05 am >> UPDATE ps_product_lang SET name = 'AGENDA 2023 SAN PAOLO', description = '' WHERE id_product = '19938' 13/09/2022 11:12:05 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '8.1967' WHERE id_product = '19938' 13/09/2022 11:12:05 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '8.1967', id_tax_rules_group = '1', id_category_default = '30', id_argoment_default = '107', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19938' 13/09/2022 11:12:05 am >> DELETE FROM ps_specific_price WHERE id_product = '19938' 13/09/2022 11:23:16 am >> SELECT document_num FROM ps_document WHERE document_num = '2720' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-13') 13/09/2022 11:23:16 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' , '2720' , '2022-09-13' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '92.50' , '77.08' , NOW() , NOW() ) 13/09/2022 11:23:16 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61782' 13/09/2022 11:23:16 am >> DELETE FROM ps_document_detail WHERE id_document = '61782' 13/09/2022 11:23:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61782' , '15387' , 'VESTINA BATTESIMALE ' , '20' , '-20' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '50.00' ) 13/09/2022 11:23:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '15387' AND id_supplier = '' 13/09/2022 11:23:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15387' , '' , '1' ) 13/09/2022 11:23:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61782' , '791' , 'ASSISI IN BUSTA BATTESIMO - 20X270 - BAAS' , '20' , '-20' , '1' , '1.40' , '1.1475409836066' , '22' , '0' , '28.00' ) 13/09/2022 11:23:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '791' AND id_supplier = '' 13/09/2022 11:23:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '791' , '' , '1' ) 13/09/2022 11:23:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61782' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '1' , '-1' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '7.50' ) 13/09/2022 11:23:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '11757' AND id_supplier = '' 13/09/2022 11:23:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11757' , '' , '1' ) 13/09/2022 11:23:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61782' , '11151' , 'LIBRI' , '2' , '-2' , '4' , '3.5' , '3.5' , '0' , '0' , '7.00' ) 13/09/2022 11:23:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 13/09/2022 11:23:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 13/09/2022 11:28:22 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788888758671' AND id_product != '19505' AND ean13 != '' 13/09/2022 11:28:22 am >> UPDATE ps_product SET id_supplier = '7', reference = '1/2', ean13 = '9788888758671', date_upd = NOW() WHERE id_product = '19505' 13/09/2022 11:28:22 am >> UPDATE ps_product_lang SET name = 'MEMORIA FEDELTA\' PROFEZIA - CACUCCI/RUCCIA', description = '' WHERE id_product = '19505' 13/09/2022 11:28:22 am >> UPDATE ps_product SET wholesale_price = '5.60', on_sale = '0', price = '8.0000' WHERE id_product = '19505' 13/09/2022 11:28:22 am >> UPDATE ps_product_shop SET wholesale_price = '5.60', price = '8.0000', id_tax_rules_group = '4', id_category_default = '497', 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 = '19505' 13/09/2022 11:28:22 am >> DELETE FROM ps_specific_price WHERE id_product = '19505' 13/09/2022 11:39:49 am >> SELECT document_num FROM ps_document WHERE document_num = '2721' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-13') 13/09/2022 11:39: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' , '2721' , '2022-09-13' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '95.61' , '81.02' , NOW() , NOW() ) 13/09/2022 11:39: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 = '61783' 13/09/2022 11:39:49 am >> DELETE FROM ps_document_detail WHERE id_document = '61783' 13/09/2022 11:39: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 ( '61783' , '18618' , 'MEDAGLIA SAN MICHELE - OV22/MC' , '10' , '-10' , '1' , '0.20' , '0.16393442622951' , '22' , '0' , '2.00' ) 13/09/2022 11:39:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '18618' AND id_supplier = '' 13/09/2022 11:39:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18618' , '' , '1' ) 13/09/2022 11:39: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 ( '61783' , '6338' , 'MEDAGLIA OVALE DECORATA - SAN MICHELE - G291-D' , '14' , '-14' , '1' , '0.60' , '0.49180327868852' , '22' , '0' , '8.40' ) 13/09/2022 11:39:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '6338' AND id_supplier = '' 13/09/2022 11:39:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6338' , '' , '1' ) 13/09/2022 11:39: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 ( '61783' , '6339' , 'MEDAGLIA OVALE DORATA/SMALTINO' , '11' , '-11' , '1' , '0.6' , '0.49180327868852' , '22' , '0' , '6.60' ) 13/09/2022 11:39:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '6339' AND id_supplier = '' 13/09/2022 11:39:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6339' , '' , '1' ) 13/09/2022 11:39: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 ( '61783' , '9184' , 'ROSARIO S. MICHELE IN CRISTALLO - RL 753/C' , '5' , '-5' , '1' , '4.80' , '3.9344262295082' , '22' , '0' , '24.00' ) 13/09/2022 11:39:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '9184' AND id_supplier = '' 13/09/2022 11:39:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9184' , '' , '1' ) 13/09/2022 11:39: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 ( '61783' , '9183' , 'ROSARIO S. MICHELE - LEGNO RL 753 ' , '5' , '-5' , '1' , '4.50' , '3.6885245901639' , '22' , '0' , '22.50' ) 13/09/2022 11:39:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '9183' AND id_supplier = '' 13/09/2022 11:39:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9183' , '' , '1' ) 13/09/2022 11:39: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 ( '61783' , '15030' , 'PREGHIERE A SAN MICHELE ARCANGELO' , '10' , '-10' , '4' , '1.00' , '1' , '0' , '5' , '9.50' ) 13/09/2022 11:39:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '15030' AND id_supplier = '' 13/09/2022 11:39:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15030' , '' , '1' ) 13/09/2022 11:39: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 ( '61783' , '9224' , 'S. MICHELE ARC. - 256' , '1' , '-1' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '3.50' ) 13/09/2022 11:39:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '9224' AND id_supplier = '' 13/09/2022 11:39:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9224' , '' , '1' ) 13/09/2022 11:39: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 ( '61783' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '3.50' ) 13/09/2022 11:39:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '17617' AND id_supplier = '' 13/09/2022 11:39:50 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17617' , '' , '1' ) 13/09/2022 11:39:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61783' , '19685' , 'AMEN - OTT 2022' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 13/09/2022 11:39:50 am >> DELETE FROM ps_product_supplier WHERE id_product = '19685' AND id_supplier = '' 13/09/2022 11:39:50 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19685' , '' , '1' ) 13/09/2022 11:39:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61783' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '1.90' ) 13/09/2022 11:39:50 am >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 13/09/2022 11:39:50 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 13/09/2022 11:39:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61783' , '11756' , 'VINO BIANCO SECCO - 14%' , '1' , '-1' , '1' , '6.50' , '5.327868852459' , '22' , '0' , '6.50' ) 13/09/2022 11:39:50 am >> DELETE FROM ps_product_supplier WHERE id_product = '11756' AND id_supplier = '' 13/09/2022 11:39:50 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11756' , '' , '1' ) 13/09/2022 11:39:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61783' , '6154' , 'MAGNETI IMBUSTATI CM 4X6 - OGGETTI' , '7' , '-7' , '1' , '0.5' , '0.40983606557377' , '22' , '0' , '3.50' ) 13/09/2022 11:39:50 am >> DELETE FROM ps_product_supplier WHERE id_product = '6154' AND id_supplier = '' 13/09/2022 11:39:50 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6154' , '' , '1' ) 13/09/2022 12:09:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '2722' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-13') 13/09/2022 12:09:31 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' , '2722' , '2022-09-13' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1730.00' , '1418.03' , NOW() , NOW() ) 13/09/2022 12:09:31 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 = '61784' 13/09/2022 12:09:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '61784' 13/09/2022 12:09:31 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 ( '61784' , '19434' , 'CASULA MARIANA MISTO LANA - CASOM70' , '1' , '-1' , '1' , '1730.00' , '1418.0327868852' , '22' , '0' , '1730.00' ) 13/09/2022 12:09:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19434' AND id_supplier = '' 13/09/2022 12:09:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19434' , '' , '1' ) 13/09/2022 12:26:08 pm >> SELECT document_num FROM ps_document WHERE document_num = '2723' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-13') 13/09/2022 12:26: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' , '2723' , '2022-09-13' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 13/09/2022 12:26: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 = '61785' 13/09/2022 12:26:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '61785' 13/09/2022 12:26: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 ( '61785' , '19909' , 'SULLA TUA PAROLA - NOV/DIC 2022' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 13/09/2022 12:26:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19909' AND id_supplier = '' 13/09/2022 12:26:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19909' , '' , '1' ) 13/09/2022 12:28:48 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '835' , '2022-09-13' , '' , '0' , '80' , '2687' , 'via Trapani, C.DA Venera, 7 91025 MARSALA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '642.89' , '527.06' , NOW() , NOW() ) 13/09/2022 12:28:48 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 = '61786' 13/09/2022 12:28:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '61786' 13/09/2022 12:28:48 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 ( '61786' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '150' , '150' , '1' , '3.51' , '2.8770491803279' , '22' , '0' , '642.3300' ) 13/09/2022 12:28:48 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11757' AND id_supplier = '80' 13/09/2022 12:28:48 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11757' , '80' , '1' ) 13/09/2022 12:28:48 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 ( '61786' , '' , 'ARROTONDAMENTO' , '1' , '1' , '4' , '0.56' , '0.56' , '0' , '0' , '0.5600' ) 13/09/2022 12:28:48 pm >> DELETE FROM ps_product_supplier WHERE id_product = '' AND id_supplier = '80' 13/09/2022 12:28:48 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '' , '80' , '1' ) 13/09/2022 12:32:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '2716' AND id_document != '61775' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-13') 13/09/2022 12:32:31 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2716', document_date = '2022-09-13', 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 = '197.70', price_tax_excluded = '167.37', date_upd = NOW() WHERE id_document = '61775' 13/09/2022 12:32:31 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 = '61775' 13/09/2022 12:32:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '61775' 13/09/2022 12:32:31 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 ( '61775' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8.0000' , '6.5573770491803' , '22' , '0' , '48.00' ) 13/09/2022 12:32:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11384' AND id_supplier = '' 13/09/2022 12:32:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11384' , '' , '1' ) 13/09/2022 12:32:31 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 ( '61775' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '6' , '-6' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '21.00' ) 13/09/2022 12:32:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 13/09/2022 12:32:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 13/09/2022 12:32:31 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 ( '61775' , '7311' , 'OSTIA SOTTILE 74MM' , '4' , '-4' , '3' , '1.9000' , '1.8269230769231' , '4' , '0' , '7.60' ) 13/09/2022 12:32:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 13/09/2022 12:32:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 13/09/2022 12:32:31 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 ( '61775' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.0000' , '3.8461538461538' , '4' , '0' , '4.00' ) 13/09/2022 12:32:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16691' AND id_supplier = '' 13/09/2022 12:32:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16691' , '' , '1' ) 13/09/2022 12:32:31 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 ( '61775' , '15335' , 'CANDELA VOTIVA 20X40 DECORATA' , '25' , '-25' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '50.00' ) 13/09/2022 12:32:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15335' AND id_supplier = '' 13/09/2022 12:32:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15335' , '' , '1' ) 13/09/2022 12:32:31 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 ( '61775' , '7202' , 'ARTICOLI RELIGIOSI' , '25' , '-25' , '1' , '0.3500' , '0.28688524590164' , '22' , '0' , '8.75' ) 13/09/2022 12:32:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 13/09/2022 12:32:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 13/09/2022 12:32:31 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 ( '61775' , '4221' , 'FLAMBEAUX IN PLASTICA - PZ 50 - OGGETTI' , '1' , '-1' , '1' , '15.0000' , '12.295081967213' , '22' , '0' , '15.00' ) 13/09/2022 12:32:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4221' AND id_supplier = '' 13/09/2022 12:32:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4221' , '' , '1' ) 13/09/2022 12:32:31 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 ( '61775' , '19693' , 'CALENDARIO LITURGICO 2023' , '2' , '-2' , '4' , '0.5000' , '0.5' , '0' , '0' , '1.00' ) 13/09/2022 12:32:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19693' AND id_supplier = '' 13/09/2022 12:32:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19693' , '' , '1' ) 13/09/2022 12:32:32 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 ( '61775' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '2.85' , '2.85' , '0' , '0' , '2.85' ) 13/09/2022 12:32:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 13/09/2022 12:32:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 13/09/2022 12:32:32 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 ( '61775' , '19922' , 'AGENDA DEVOZIONALE 2023 - 40808' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '5' , '9.50' ) 13/09/2022 12:32:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19922' AND id_supplier = '' 13/09/2022 12:32:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19922' , '' , '1' ) 13/09/2022 12:32:32 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 ( '61775' , '19150' , 'MOCCOLO 70X200' , '4' , '-4' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '30.00' ) 13/09/2022 12:32:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19150' AND id_supplier = '' 13/09/2022 12:32:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19150' , '' , '1' ) 13/09/2022 02:36:38 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3379' 13/09/2022 02:36:38 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 ( '3379' , '10' , '123' , 'PARROCCHIA MARIA SS. VERGINE DI POMPEI' , 'MANNO' , 'DON ANTONIO' , 'VIA SALVATORE LA ROSA' , '' , '92021' , 'ARAGONA' , 'ORDINA TESE GIUSEPPE 3393809871 - giuseppetese1946@gmail.com\r\nvia pisani 274 - 90129 palermo' , '' , '' , '' , '' , NOW() , NOW() ) 13/09/2022 02:36:38 pm >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '3379' 13/09/2022 03:11:38 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001246' AND id_product != '14919' AND ean13 != '' 13/09/2022 03:11:39 pm >> UPDATE ps_product SET id_supplier = '122', reference = '', ean13 = '001246', date_upd = NOW() WHERE id_product = '14919' 13/09/2022 03:11:39 pm >> UPDATE ps_product_lang SET name = 'CASULA - POLIESTERE - PCA022', description = '' WHERE id_product = '14919' 13/09/2022 03:11:39 pm >> UPDATE ps_product SET wholesale_price = '30.00', on_sale = '0', price = '64.75409836065575' WHERE id_product = '14919' 13/09/2022 03:11:39 pm >> UPDATE ps_product_shop SET wholesale_price = '30.00', price = '64.75409836065575', id_tax_rules_group = '1', id_category_default = '441', 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 = '14919' 13/09/2022 03:11:39 pm >> DELETE FROM ps_specific_price WHERE id_product = '14919' 13/09/2022 03:11:48 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001267' AND id_product != '16070' AND ean13 != '' 13/09/2022 03:11:48 pm >> UPDATE ps_product SET id_supplier = '122', reference = '', ean13 = '001267', date_upd = NOW() WHERE id_product = '16070' 13/09/2022 03:11:48 pm >> UPDATE ps_product_lang SET name = 'CASULA - PCA020', description = '' WHERE id_product = '16070' 13/09/2022 03:11:48 pm >> UPDATE ps_product SET wholesale_price = '30.00', on_sale = '0', price = '64.75409836065575' WHERE id_product = '16070' 13/09/2022 03:11:48 pm >> UPDATE ps_product_shop SET wholesale_price = '30.00', price = '64.75409836065575', 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 = '16070' 13/09/2022 03:11:48 pm >> DELETE FROM ps_specific_price WHERE id_product = '16070' 13/09/2022 03:11:58 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001256' AND id_product != '15916' AND ean13 != '' 13/09/2022 03:11:58 pm >> UPDATE ps_product SET id_supplier = '122', reference = '', ean13 = '001256', date_upd = NOW() WHERE id_product = '15916' 13/09/2022 03:11:58 pm >> UPDATE ps_product_lang SET name = 'CASULA - PCA033', description = '' WHERE id_product = '15916' 13/09/2022 03:11:58 pm >> UPDATE ps_product SET wholesale_price = '27.50', on_sale = '0', price = '64.75409836065575' WHERE id_product = '15916' 13/09/2022 03:11:58 pm >> UPDATE ps_product_shop SET wholesale_price = '27.50', price = '64.75409836065575', 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 = '15916' 13/09/2022 03:11:58 pm >> DELETE FROM ps_specific_price WHERE id_product = '15916' 13/09/2022 03:12:15 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001310' AND id_product != '16405' AND ean13 != '' 13/09/2022 03:12:15 pm >> UPDATE ps_product SET id_supplier = '122', reference = '', ean13 = '001310', date_upd = NOW() WHERE id_product = '16405' 13/09/2022 03:12:15 pm >> UPDATE ps_product_lang SET name = 'CASULA MORELLO', description = '' WHERE id_product = '16405' 13/09/2022 03:12:15 pm >> UPDATE ps_product SET wholesale_price = '27.50', on_sale = '0', price = '64.75409836065575' WHERE id_product = '16405' 13/09/2022 03:12:15 pm >> UPDATE ps_product_shop SET wholesale_price = '27.50', price = '64.75409836065575', 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 = '16405' 13/09/2022 03:12:15 pm >> DELETE FROM ps_specific_price WHERE id_product = '16405' 13/09/2022 03:12:26 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001548' AND id_product != '17101' AND ean13 != '' 13/09/2022 03:12:26 pm >> UPDATE ps_product SET id_supplier = '122', reference = '', ean13 = '001548', date_upd = NOW() WHERE id_product = '17101' 13/09/2022 03:12:26 pm >> UPDATE ps_product_lang SET name = 'CASULA POLIESTERE CROCE ORO - AECU04', description = '' WHERE id_product = '17101' 13/09/2022 03:12:26 pm >> UPDATE ps_product SET wholesale_price = '29.50', on_sale = '0', price = '64.75409836065575' WHERE id_product = '17101' 13/09/2022 03:12:27 pm >> UPDATE ps_product_shop SET wholesale_price = '29.50', price = '64.75409836065575', 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 = '17101' 13/09/2022 03:12:27 pm >> DELETE FROM ps_specific_price WHERE id_product = '17101' 13/09/2022 03:24:06 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001306' AND id_product != '16374' AND ean13 != '' 13/09/2022 03:24:06 pm >> UPDATE ps_product SET id_supplier = '122', reference = '', ean13 = '001306', date_upd = NOW() WHERE id_product = '16374' 13/09/2022 03:24:06 pm >> UPDATE ps_product_lang SET name = 'CASULA ROSA', description = '' WHERE id_product = '16374' 13/09/2022 03:24:06 pm >> UPDATE ps_product SET wholesale_price = '27.50', on_sale = '0', price = '64.75409836065575' WHERE id_product = '16374' 13/09/2022 03:24:06 pm >> UPDATE ps_product_shop SET wholesale_price = '27.50', price = '64.75409836065575', 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 = '16374' 13/09/2022 03:24:06 pm >> DELETE FROM ps_specific_price WHERE id_product = '16374' 13/09/2022 03:26:55 pm >> SELECT ean13 FROM ps_product WHERE ean13 = 'MD088HHH069' AND id_product != '14925' AND ean13 != '' 13/09/2022 03:26:55 pm >> UPDATE ps_product SET id_supplier = '122', reference = '', ean13 = 'MD088HHH069', date_upd = NOW() WHERE id_product = '14925' 13/09/2022 03:26:55 pm >> UPDATE ps_product_lang SET name = 'CASULA CROCE SP L', description = '' WHERE id_product = '14925' 13/09/2022 03:26:55 pm >> UPDATE ps_product SET wholesale_price = '32.98', on_sale = '0', price = '81.72131147540983' WHERE id_product = '14925' 13/09/2022 03:26:55 pm >> UPDATE ps_product_shop SET wholesale_price = '32.98', price = '81.72131147540983', id_tax_rules_group = '1', id_category_default = '441', 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 = '14925' 13/09/2022 03:26:55 pm >> DELETE FROM ps_specific_price WHERE id_product = '14925' 13/09/2022 03:27:43 pm >> SELECT ean13 FROM ps_product WHERE ean13 = 'MD088HHH007' AND id_product != '14921' AND ean13 != '' 13/09/2022 03:27:43 pm >> UPDATE ps_product SET id_supplier = '122', reference = '', ean13 = 'MD088HHH007', date_upd = NOW() WHERE id_product = '14921' 13/09/2022 03:27:43 pm >> UPDATE ps_product_lang SET name = 'CASULA - POLIESTERE', description = '' WHERE id_product = '14921' 13/09/2022 03:27:44 pm >> UPDATE ps_product SET wholesale_price = '35.28', on_sale = '0', price = '70.90163934426229' WHERE id_product = '14921' 13/09/2022 03:27:44 pm >> UPDATE ps_product_shop SET wholesale_price = '35.28', price = '70.90163934426229', id_tax_rules_group = '1', id_category_default = '441', 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 = '14921' 13/09/2022 03:27:44 pm >> DELETE FROM ps_specific_price WHERE id_product = '14921' 13/09/2022 03:28:38 pm >> SELECT document_num FROM ps_document WHERE document_num = '2239' AND id_document != '59138' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-11') 13/09/2022 03:28:38 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2239', document_date = '2022-07-11', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '54.00', price_tax_excluded = '44.26', date_upd = NOW() WHERE id_document = '59138' 13/09/2022 03:28: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 = '59138' 13/09/2022 03:28:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '59138' 13/09/2022 03:28: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 ( '59138' , '14921' , 'CASULA - POLIESTERE' , '1' , '-1' , '1' , '54' , '44.262295081967' , '22' , '0' , '54.00' ) 13/09/2022 03:28:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14921' AND id_supplier = '' 13/09/2022 03:28:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14921' , '' , '1' ) 13/09/2022 03:30:38 pm >> SELECT document_num FROM ps_document WHERE document_num = '1885' AND id_document != '58725' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-11') 13/09/2022 03:30:38 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1885', document_date = '2022-06-11', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '1900.00', price_tax_excluded = '1567.46', date_upd = NOW() WHERE id_document = '58725' 13/09/2022 03:30: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 = '58725' 13/09/2022 03:30:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '58725' 13/09/2022 03:30: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 ( '58725' , '7311' , 'OSTIA SOTTILE 74MM' , '5' , '-5' , '3' , '1.9000' , '1.8269230769231' , '4' , '0' , '9.50' ) 13/09/2022 03:30:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 13/09/2022 03:30:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 13/09/2022 03:30: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 ( '58725' , '15020' , 'PREGARE OGNI GIORNO' , '30' , '-30' , '4' , '0.7000' , '0.7' , '0' , '0' , '21.00' ) 13/09/2022 03:30:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15020' AND id_supplier = '' 13/09/2022 03:30:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15020' , '' , '1' ) 13/09/2022 03:30: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 ( '58725' , '17710' , 'OSTIA MAGNA CM 14 - OM 140' , '1' , '-1' , '3' , '4.5000' , '4.3269230769231' , '4' , '0' , '4.50' ) 13/09/2022 03:30:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17710' AND id_supplier = '' 13/09/2022 03:30:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17710' , '' , '1' ) 13/09/2022 03:30: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 ( '58725' , '19090' , 'OSTIA MAGNA 170 - OM170' , '1' , '-1' , '3' , '8.5000' , '8.1730769230769' , '4' , '0' , '8.50' ) 13/09/2022 03:30:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19090' AND id_supplier = '' 13/09/2022 03:30:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19090' , '' , '1' ) 13/09/2022 03:30: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 ( '58725' , '17160' , 'CARBONCINI ROSSI - CARRO' , '2' , '-2' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '20.00' ) 13/09/2022 03:30:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17160' AND id_supplier = '' 13/09/2022 03:30:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17160' , '' , '1' ) 13/09/2022 03:30: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 ( '58725' , '11756' , 'VINO BIANCO SECCO - 14%' , '6' , '-6' , '1' , '5.5000' , '4.5081967213115' , '22' , '0' , '33.00' ) 13/09/2022 03:30:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11756' AND id_supplier = '' 13/09/2022 03:30:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11756' , '' , '1' ) 13/09/2022 03:30: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 ( '58725' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '56.40' ) 13/09/2022 03:30:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 13/09/2022 03:30:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 13/09/2022 03:30: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 ( '58725' , '19097' , 'CINGOLO - CING04' , '1' , '-1' , '1' , '29.0000' , '23.770491803279' , '22' , '0' , '29.00' ) 13/09/2022 03:30:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19097' AND id_supplier = '' 13/09/2022 03:30:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19097' , '' , '1' ) 13/09/2022 03:30: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 ( '58725' , '7942' , 'PERGAMENE - OCCASIONI MOD. B' , '1' , '-1' , '1' , '0.6700' , '0.54918032786885' , '22' , '0' , '0.67' ) 13/09/2022 03:30:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7942' AND id_supplier = '' 13/09/2022 03:30:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7942' , '' , '1' ) 13/09/2022 03:30: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 ( '58725' , '18260' , 'CLERGY GRIGIO NIDO DAPE MM - XL' , '1' , '-1' , '1' , '40.0000' , '32.786885245902' , '22' , '0' , '40.00' ) 13/09/2022 03:30:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18260' AND id_supplier = '' 13/09/2022 03:30:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18260' , '' , '1' ) 13/09/2022 03:30: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 ( '58725' , '19594' , 'POLO JERSEY COTONE 100%' , '1' , '-1' , '1' , '36.9000' , '30.245901639344' , '22' , '0' , '36.90' ) 13/09/2022 03:30:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19594' AND id_supplier = '' 13/09/2022 03:30:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19594' , '' , '1' ) 13/09/2022 03:30: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 ( '58725' , '19455' , 'CAMICE MISTO COTONE - CAM0M29' , '1' , '-1' , '1' , '525.0000' , '430.32786885246' , '22' , '0' , '525.00' ) 13/09/2022 03:30:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19455' AND id_supplier = '' 13/09/2022 03:30:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19455' , '' , '1' ) 13/09/2022 03:30: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 ( '58725' , '17801' , 'CASULA - 548' , '1' , '-1' , '1' , '380.0000' , '311.47540983607' , '22' , '0' , '380.00' ) 13/09/2022 03:30:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17801' AND id_supplier = '' 13/09/2022 03:30:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17801' , '' , '1' ) 13/09/2022 03:30: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 ( '58725' , '19447' , 'CASULA L/S MOIRE\' - RICAMO DIRETTO - 7976LS' , '1' , '-1' , '1' , '595.0000' , '487.70491803279' , '22' , '0' , '595.00' ) 13/09/2022 03:30:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19447' AND id_supplier = '' 13/09/2022 03:30:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19447' , '' , '1' ) 13/09/2022 03:30: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 ( '58725' , '14919' , 'CASULA - POLIESTERE - PCA022' , '1' , '-1' , '1' , '72' , '59.016393442623' , '22' , '0' , '72.00' ) 13/09/2022 03:30:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14919' AND id_supplier = '' 13/09/2022 03:30:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14919' , '' , '1' ) 13/09/2022 03:30: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 ( '58725' , '13334' , 'CROCE IN ULIVO CON LACCIO' , '5' , '-5' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '6.00' ) 13/09/2022 03:30:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13334' AND id_supplier = '' 13/09/2022 03:30:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13334' , '' , '1' ) 13/09/2022 03:30:40 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 ( '58725' , '6663' , 'MIE PREGHIERE' , '1' , '-1' , '4' , '1.5000' , '1.5' , '0' , '0' , '1.50' ) 13/09/2022 03:30:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6663' AND id_supplier = '' 13/09/2022 03:30:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6663' , '' , '1' ) 13/09/2022 03:30:40 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 ( '58725' , '15387' , 'VESTINA BATTESIMALE ' , '3' , '-3' , '1' , '2.8000' , '2.2950819672131' , '22' , '0' , '8.40' ) 13/09/2022 03:30:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15387' AND id_supplier = '' 13/09/2022 03:30:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15387' , '' , '1' ) 13/09/2022 03:30:40 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 ( '58725' , '15805' , 'TREDICINA A SANTANTONIO DI PADOVA' , '1' , '-1' , '4' , '1.0000' , '1' , '0' , '0' , '1.00' ) 13/09/2022 03:30:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15805' AND id_supplier = '' 13/09/2022 03:30:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15805' , '' , '1' ) 13/09/2022 03:30:40 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 ( '58725' , '9015' , 'RITO DELLA CONFERMAZIONE' , '1' , '-1' , '4' , '15.5000' , '15.5' , '0' , '5' , '14.73' ) 13/09/2022 03:30:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9015' AND id_supplier = '' 13/09/2022 03:30:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9015' , '' , '1' ) 13/09/2022 03:30:40 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 ( '58725' , '19594' , 'POLO JERSEY COTONE 100%' , '1' , '-1' , '1' , '36.9000' , '30.245901639344' , '22' , '0' , '36.90' ) 13/09/2022 03:30:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19594' AND id_supplier = '' 13/09/2022 03:30:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19594' , '' , '1' ) 13/09/2022 03:32:59 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001175' AND id_product != '15427' AND ean13 != '' 13/09/2022 03:32:59 pm >> UPDATE ps_product SET id_supplier = '122', reference = '', ean13 = '001175', date_upd = NOW() WHERE id_product = '15427' 13/09/2022 03:32:59 pm >> UPDATE ps_product_lang SET name = 'COPRILEGGIO 4 EVANGELISTI - PCP001', description = '' WHERE id_product = '15427' 13/09/2022 03:32:59 pm >> UPDATE ps_product SET wholesale_price = '35.00', on_sale = '0', price = '85.24590163934427' WHERE id_product = '15427' 13/09/2022 03:32:59 pm >> UPDATE ps_product_shop SET wholesale_price = '35.00', price = '85.24590163934427', 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 = '15427' 13/09/2022 03:32:59 pm >> DELETE FROM ps_specific_price WHERE id_product = '15427' 13/09/2022 03:37:05 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001547' AND id_product != '15784' AND ean13 != '' 13/09/2022 03:37:05 pm >> UPDATE ps_product SET id_supplier = '122', reference = '', ean13 = '001547', date_upd = NOW() WHERE id_product = '15784' 13/09/2022 03:37:05 pm >> UPDATE ps_product_lang SET name = 'COPRILEGGIO MARIANO - PCP004B05', description = '' WHERE id_product = '15784' 13/09/2022 03:37:05 pm >> UPDATE ps_product SET wholesale_price = '28.00', on_sale = '0', price = '63.9344262295082' WHERE id_product = '15784' 13/09/2022 03:37:06 pm >> UPDATE ps_product_shop SET wholesale_price = '28.00', price = '63.9344262295082', 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 = '15784' 13/09/2022 03:37:06 pm >> DELETE FROM ps_specific_price WHERE id_product = '15784' 13/09/2022 03:44:28 pm >> SELECT ean13 FROM ps_product WHERE ean13 = 'MD090HHH060' AND id_product != '14924' AND ean13 != '' 13/09/2022 03:44:28 pm >> UPDATE ps_product SET id_supplier = '122', reference = '', ean13 = 'MD090HHH060', date_upd = NOW() WHERE id_product = '14924' 13/09/2022 03:44:28 pm >> UPDATE ps_product_lang SET name = 'STOLA - PST015', description = '' WHERE id_product = '14924' 13/09/2022 03:44:28 pm >> UPDATE ps_product SET wholesale_price = '32.98', on_sale = '0', price = '81.72131147540983' WHERE id_product = '14924' 13/09/2022 03:44:28 pm >> UPDATE ps_product_shop SET wholesale_price = '32.98', price = '81.72131147540983', id_tax_rules_group = '1', id_category_default = '441', 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 = '14924' 13/09/2022 03:44:28 pm >> DELETE FROM ps_specific_price WHERE id_product = '14924' 13/09/2022 03:46:58 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001248' AND id_product != '15834' AND ean13 != '' 13/09/2022 03:46:58 pm >> UPDATE ps_product SET id_supplier = '122', reference = '', ean13 = '001248', date_upd = NOW() WHERE id_product = '15834' 13/09/2022 03:46:59 pm >> UPDATE ps_product_lang SET name = 'STOLA CROCE /UVA - MD090HHH011', description = '' WHERE id_product = '15834' 13/09/2022 03:46:59 pm >> UPDATE ps_product SET wholesale_price = '24.00', on_sale = '0', price = '55.9016393442623' WHERE id_product = '15834' 13/09/2022 03:46:59 pm >> UPDATE ps_product_shop SET wholesale_price = '24.00', price = '55.9016393442623', 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 = '15834' 13/09/2022 03:46:59 pm >> DELETE FROM ps_specific_price WHERE id_product = '15834' 13/09/2022 03:48:56 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001282' AND id_product != '16188' AND ean13 != '' 13/09/2022 03:48:56 pm >> UPDATE ps_product SET id_supplier = '122', reference = '', ean13 = '001282', date_upd = NOW() WHERE id_product = '16188' 13/09/2022 03:48:56 pm >> UPDATE ps_product_lang SET name = 'STOLA QUATTRO EVANGELISTI - PST009', description = '' WHERE id_product = '16188' 13/09/2022 03:48:56 pm >> UPDATE ps_product SET wholesale_price = '23.00', on_sale = '0', price = '58.0327868852459' WHERE id_product = '16188' 13/09/2022 03:48:56 pm >> UPDATE ps_product_shop SET wholesale_price = '23.00', price = '58.0327868852459', 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 = '16188' 13/09/2022 03:48:56 pm >> DELETE FROM ps_specific_price WHERE id_product = '16188' 13/09/2022 03:50:35 pm >> SELECT ean13 FROM ps_product WHERE ean13 = 'PCM005B00' AND id_product != '15040' AND ean13 != '' 13/09/2022 03:50:36 pm >> UPDATE ps_product SET id_supplier = '122', reference = '', ean13 = 'PCM005B00', date_upd = NOW() WHERE id_product = '15040' 13/09/2022 03:50:36 pm >> UPDATE ps_product_lang SET name = 'CAMICE APERTO POLIESTERE', description = '' WHERE id_product = '15040' 13/09/2022 03:50:36 pm >> UPDATE ps_product SET wholesale_price = '39.50', on_sale = '0', price = '84.91803278688525' WHERE id_product = '15040' 13/09/2022 03:50:36 pm >> UPDATE ps_product_shop SET wholesale_price = '39.50', price = '84.91803278688525', 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 = '15040' 13/09/2022 03:50:36 pm >> DELETE FROM ps_specific_price WHERE id_product = '15040' 13/09/2022 03:52:43 pm >> SELECT ean13 FROM ps_product WHERE ean13 = 'AECM16B05' AND id_product != '15041' AND ean13 != '' 13/09/2022 03:52:44 pm >> UPDATE ps_product SET id_supplier = '122', reference = '', ean13 = 'AECM16B05', date_upd = NOW() WHERE id_product = '15041' 13/09/2022 03:52:44 pm >> UPDATE ps_product_lang SET name = 'CAMICE MONASTICO - MISTO', description = '' WHERE id_product = '15041' 13/09/2022 03:52:44 pm >> UPDATE ps_product SET wholesale_price = '112.00', on_sale = '0', price = '240.81967213114754' WHERE id_product = '15041' 13/09/2022 03:52:44 pm >> UPDATE ps_product_shop SET wholesale_price = '112.00', price = '240.81967213114754', 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 = '15041' 13/09/2022 03:52:44 pm >> DELETE FROM ps_specific_price WHERE id_product = '15041' 13/09/2022 04:06:13 pm >> SELECT document_num FROM ps_document WHERE document_num = '55' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-09-13') 13/09/2022 04:06:13 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' , '55' , '2022-09-13' , '' , '3379' , '0' , '74680486' , 'VIA SALVATORE LA ROSA 92021 ARAGONA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '18.00' , '18.00' , NOW() , NOW() ) 13/09/2022 04:06:13 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 = '5412' 13/09/2022 04:06:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '5412' 13/09/2022 04:06:13 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 ( '5412' , '133' , 'LIBRO AGENDA CATTOLICO 2023' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '0' , '18.00' ) 13/09/2022 04:14:12 pm >> SELECT document_num FROM ps_document WHERE document_num = '55' AND id_document != '5412' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-09-13') 13/09/2022 04:14:12 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '55', document_date = '2022-09-13', document_letter = '', id_customer = '3379', id_supplier = '', id_address = '74680486', address1 = 'VIA SALVATORE LA ROSA 92021 ARAGONA', address2 = '', note = 'bonifico - TESE', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '9', id_causal = '0', price_tax_included = '18.00', price_tax_excluded = '18.00', date_upd = NOW() WHERE id_document = '5412' 13/09/2022 04:14: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 = '5412' 13/09/2022 04:14:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '5412' 13/09/2022 04:14: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 ( '5412' , '133' , 'LIBRO AGENDA CATTOLICO 2023' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 13/09/2022 04:14:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '133' AND id_supplier = '' 13/09/2022 04:14:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '133' , '' , '1' ) 13/09/2022 05:30:41 pm >> SELECT document_num FROM ps_document WHERE document_num = '2724' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-13') 13/09/2022 05:30:41 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' , '2724' , '2022-09-13' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.50' , '4.51' , NOW() , NOW() ) 13/09/2022 05:30:41 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 = '61787' 13/09/2022 05:30:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '61787' 13/09/2022 05:30:41 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 ( '61787' , '17277' , 'BRACCIALE PIETRE DURE - 4633' , '1' , '-1' , '1' , '5.50' , '4.5081967213115' , '22' , '0' , '5.50' ) 13/09/2022 05:30:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17277' AND id_supplier = '' 13/09/2022 05:30:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17277' , '' , '1' ) 13/09/2022 05:55:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '114' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-09-13') 13/09/2022 05:55:14 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' , '114' , '2022-09-13' , '' , '84' , '0' , '4671448' , 'VIA MANFREDI, 30 29122 PIACENZA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '600.40' , '600.40' , NOW() , NOW() ) 13/09/2022 05:55:14 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61788' 13/09/2022 05:55:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '61788' 13/09/2022 05:55:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61788' , '5444' , 'IO SONO CON VOI - CAT.' , '25' , '-25' , '4' , '5.50' , '5.5' , '0' , '5' , '130.63' ) 13/09/2022 05:55:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61788' , '5457' , 'IO SONO CON VOI 1 PARTE' , '25' , '-25' , '4' , '2.50' , '2.5' , '0' , '15' , '53.13' ) 13/09/2022 05:55:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61788' , '5458' , 'IO SONO CON VOI 2 PARTE' , '30' , '-30' , '4' , '2.50' , '2.5' , '0' , '15' , '63.75' ) 13/09/2022 05:55:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61788' , '11193' , 'VENITE CON ME CAT.' , '35' , '-35' , '4' , '5.50' , '5.5' , '0' , '5' , '182.88' ) 13/09/2022 05:55:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61788' , '11191' , 'VENITE CON ME 1 PARTE' , '35' , '-35' , '4' , '2.50' , '2.5' , '0' , '15' , '74.38' ) 13/09/2022 05:55:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61788' , '11192' , 'VENITE CON ME 2 PARTE' , '45' , '-45' , '4' , '2.50' , '2.5' , '0' , '15' , '95.63' ) 13/09/2022 05:55:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61788' , '' , 'calendari omaggio' , '1' , '-1' , '4' , '0' , '0' , '0' , '0' , '0' ) 13/09/2022 06:04:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '2725' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-13') 13/09/2022 06:04:32 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' , '2725' , '2022-09-13' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.00' , '15.00' , NOW() , NOW() ) 13/09/2022 06:04:32 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 = '61789' 13/09/2022 06:04:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '61789' 13/09/2022 06:04:32 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 ( '61789' , '19647' , 'ANTICORPI DI PACE - TONiNO BELLO' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '0' , '15.00' ) 13/09/2022 06:04:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19647' AND id_supplier = '' 13/09/2022 06:04:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19647' , '' , '1' ) 13/09/2022 06:18:40 pm >> SELECT document_num FROM ps_document WHERE document_num = '2726' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-13') 13/09/2022 06:18:40 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' , '2726' , '2022-09-13' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.80' , '17.12' , NOW() , NOW() ) 13/09/2022 06:18:40 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 = '61790' 13/09/2022 06:18:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '61790' 13/09/2022 06:18:40 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 ( '61790' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '4' , '-4' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '14.00' ) 13/09/2022 06:18:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 13/09/2022 06:18:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 13/09/2022 06:18:40 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 ( '61790' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '3.80' ) 13/09/2022 06:18:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 13/09/2022 06:18:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 13/09/2022 06:56:30 pm >> SELECT document_num FROM ps_document WHERE document_num = '2727' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-13') 13/09/2022 06:56:30 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2727' , '2022-09-13' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '26.80' , '21.97' , NOW() , NOW() ) 13/09/2022 06:56:30 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61791' 13/09/2022 06:56:30 pm >> DELETE FROM ps_document_detail WHERE id_document = '61791' 13/09/2022 06:56:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61791' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '26' , '21.311475409836' , '22' , '0' , '26.00' ) 13/09/2022 06:56:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 13/09/2022 06:56:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 13/09/2022 06:56:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61791' , '17004' , 'BIGLIETTO AUGURALE PICCOLO' , '1' , '-1' , '1' , '0.80' , '0.65573770491803' , '22' , '0' , '0.80' ) 13/09/2022 06:56:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17004' AND id_supplier = '' 13/09/2022 06:56:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17004' , '' , '1' ) 13/09/2022 06:57:02 pm >> SELECT document_num FROM ps_document WHERE document_num = '2728' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-13') 13/09/2022 06:57:02 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2728' , '2022-09-13' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 13/09/2022 06:57:02 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61792' 13/09/2022 06:57:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '61792' 13/09/2022 06:57:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61792' , '7851' , 'PER VIVERE DA CRISTIANI - L. DELLA TORRE' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 13/09/2022 06:57:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7851' AND id_supplier = '' 13/09/2022 06:57:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7851' , '' , '1' ) 13/09/2022 07:18:12 pm >> SELECT document_num FROM ps_document WHERE document_num = '2729' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-13') 13/09/2022 07:18: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' , '2729' , '2022-09-13' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.90' , '5.66' , NOW() , NOW() ) 13/09/2022 07:18: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 = '61793' 13/09/2022 07:18:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '61793' 13/09/2022 07:18: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 ( '61793' , '2757' , 'CORONA DEL DISCEPOLO' , '1' , '-1' , '1' , '6.90' , '5.655737704918' , '22' , '0' , '6.90' ) 13/09/2022 07:18:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2757' AND id_supplier = '' 13/09/2022 07:18:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2757' , '' , '1' )