14/04/2023 09:29:35 am >> SELECT document_num FROM ps_document WHERE document_num = '1100' AND id_document != '82611' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-03') 14/04/2023 09:29:35 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1100', document_date = '2023-04-03', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = 'VIA BUONSERVIZI, 25 84135 SALERNO', 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 = '55.00', price_tax_excluded = '54.45', date_upd = NOW() WHERE id_document = '82611' 14/04/2023 09:29:35 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 = '82611' 14/04/2023 09:29:35 am >> DELETE FROM ps_document_detail WHERE id_document = '82611' 14/04/2023 09:29:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82611' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '3' , '-3' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '10.50' ) 14/04/2023 09:29:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82611' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '1.9000' , '1.8269230769231' , '4' , '0' , '3.80' ) 14/04/2023 09:29:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82611' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '16.95' , '16.95' , '0' , '0' , '16.95' ) 14/04/2023 09:29:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82611' , '8274' , 'PREGHIERA DEI FEDELI NEI GIORNI FERIALI - 1 - TEMPI FORTI' , '1' , '-1' , '4' , '25.00' , '25' , '0' , '5' , '23.75' ) 14/04/2023 09:36:08 am >> SELECT document_num FROM ps_document WHERE document_num = '1248' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-14') 14/04/2023 09:36:08 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' , '1248' , '2023-04-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.42' , '13.42' , NOW() , NOW() ) 14/04/2023 09:36:08 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 = '82802' 14/04/2023 09:36:08 am >> DELETE FROM ps_document_detail WHERE id_document = '82802' 14/04/2023 09:36:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82802' , '20767' , 'INSIEME NELLA MESSA - MAG 2023' , '1' , '-1' , '4' , '1.80' , '1.8' , '0' , '5' , '1.71' ) 14/04/2023 09:36:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82802' , '20868' , 'INSIEME NELLA MESSA - GIU 23' , '1' , '-1' , '4' , '1.80' , '1.8' , '0' , '5' , '1.71' ) 14/04/2023 09:36:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82802' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '10' , '10' , '0' , '0' , '10.00' ) 14/04/2023 09:42:51 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 14/04/2023 09:42:51 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20910' , '1' , '' , 'nuovo-prodotto' ) 14/04/2023 09:42:51 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '20910' , '1' , '1' , '2' , NOW() , NOW() ) 14/04/2023 09:42:51 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '20910' , '0' , '1' , '0' , '0' ) 14/04/2023 09:43:47 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788834348192' AND id_product != '20910' AND ean13 != '' 14/04/2023 09:43:47 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788834348192', date_upd = NOW() WHERE id_product = '20910' 14/04/2023 09:43:47 am >> UPDATE ps_product_lang SET name = 'sud il capitale che serve - c. borgomeo', description = '' WHERE id_product = '20910' 14/04/2023 09:43:47 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '15' WHERE id_product = '20910' 14/04/2023 09:43:48 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '15', id_tax_rules_group = '4', id_category_default = '444', 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 = '20910' 14/04/2023 09:43:48 am >> DELETE FROM ps_specific_price WHERE id_product = '20910' 14/04/2023 09:43:54 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 = '20910' 14/04/2023 09:43:54 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20911' , '1' , '' , 'nuovo-prodotto' ) 14/04/2023 09:43:54 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 '20911' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20910' 14/04/2023 09:43:54 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20911' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20910' 14/04/2023 09:44:46 am >> SELECT document_num FROM ps_document WHERE document_num = '1249' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-14') 14/04/2023 09:44:46 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1249' , '2023-04-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.50' , '9.50' , NOW() , NOW() ) 14/04/2023 09:44:46 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82803' 14/04/2023 09:44:46 am >> DELETE FROM ps_document_detail WHERE id_document = '82803' 14/04/2023 09:44:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82803' , '20795' , 'SULLA TUA PAROLA MAG/GIU 2023 - 516' , '2' , '-2' , '4' , '5.00' , '5' , '0' , '5' , '9.50' ) 14/04/2023 09:49:53 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788810559857' AND id_product != '20911' AND ean13 != '' 14/04/2023 09:49:53 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788810559857', date_upd = NOW() WHERE id_product = '20911' 14/04/2023 09:49:53 am >> UPDATE ps_product_lang SET name = 'SOGNO DA VIVERE INSIEME', description = '' WHERE id_product = '20911' 14/04/2023 09:49:53 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '9' WHERE id_product = '20911' 14/04/2023 09:49:53 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '9', id_tax_rules_group = '4', id_category_default = '9', 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 = '20911' 14/04/2023 09:49:53 am >> DELETE FROM ps_specific_price WHERE id_product = '20911' 14/04/2023 09:49:54 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 = '20911' 14/04/2023 09:49:54 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20912' , '1' , '' , 'nuovo-prodotto' ) 14/04/2023 09:49:54 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 '20912' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20911' 14/04/2023 09:49:54 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20912' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20911' 14/04/2023 09:50:12 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788810559376' AND id_product != '20912' AND ean13 != '' 14/04/2023 09:50:12 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788810559376', date_upd = NOW() WHERE id_product = '20912' 14/04/2023 09:50:12 am >> UPDATE ps_product_lang SET name = 'FALSI MITI', description = '' WHERE id_product = '20912' 14/04/2023 09:50:13 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '10' WHERE id_product = '20912' 14/04/2023 09:50:13 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '10', id_tax_rules_group = '4', id_category_default = '9', 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 = '20912' 14/04/2023 09:50:13 am >> DELETE FROM ps_specific_price WHERE id_product = '20912' 14/04/2023 09:50: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 = '20912' 14/04/2023 09:50:13 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20913' , '1' , '' , 'nuovo-prodotto' ) 14/04/2023 09:50: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 '20913' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20912' 14/04/2023 09:50:14 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20913' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20912' 14/04/2023 09:50:31 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788810559284' AND id_product != '20913' AND ean13 != '' 14/04/2023 09:50:31 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788810559284', date_upd = NOW() WHERE id_product = '20913' 14/04/2023 09:50:31 am >> UPDATE ps_product_lang SET name = 'RIFARSI UNA VITA', description = '' WHERE id_product = '20913' 14/04/2023 09:50:31 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '10' WHERE id_product = '20913' 14/04/2023 09:50:31 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '10', id_tax_rules_group = '4', id_category_default = '9', 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 = '20913' 14/04/2023 09:50:31 am >> DELETE FROM ps_specific_price WHERE id_product = '20913' 14/04/2023 09:50:31 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 = '20913' 14/04/2023 09:50:31 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20914' , '1' , '' , 'nuovo-prodotto' ) 14/04/2023 09:50:31 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 '20914' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20913' 14/04/2023 09:50:32 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20914' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20913' 14/04/2023 09:51:13 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788810559666' AND id_product != '20914' AND ean13 != '' 14/04/2023 09:51:13 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788810559666', date_upd = NOW() WHERE id_product = '20914' 14/04/2023 09:51:13 am >> UPDATE ps_product_lang SET name = 'CI VUOLE UN FIORE', description = '' WHERE id_product = '20914' 14/04/2023 09:51:13 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '10' WHERE id_product = '20914' 14/04/2023 09:51:13 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '10', id_tax_rules_group = '4', id_category_default = '9', 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 = '20914' 14/04/2023 09:51:13 am >> DELETE FROM ps_specific_price WHERE id_product = '20914' 14/04/2023 09:51:14 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 = '20914' 14/04/2023 09:51:14 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20915' , '1' , '' , 'nuovo-prodotto' ) 14/04/2023 09:51:14 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 '20915' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20914' 14/04/2023 09:51:14 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20915' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20914' 14/04/2023 09:51:36 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788810559543' AND id_product != '20915' AND ean13 != '' 14/04/2023 09:51:36 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788810559543', date_upd = NOW() WHERE id_product = '20915' 14/04/2023 09:51:36 am >> UPDATE ps_product_lang SET name = 'PER PICCINA CHE TU SIA', description = '' WHERE id_product = '20915' 14/04/2023 09:51:36 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '10' WHERE id_product = '20915' 14/04/2023 09:51:36 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '10', id_tax_rules_group = '4', id_category_default = '9', 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 = '20915' 14/04/2023 09:51:36 am >> DELETE FROM ps_specific_price WHERE id_product = '20915' 14/04/2023 09:51:37 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 = '20915' 14/04/2023 09:51:37 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20916' , '1' , '' , 'nuovo-prodotto' ) 14/04/2023 09:51:37 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 '20916' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20915' 14/04/2023 09:51:37 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20916' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20915' 14/04/2023 09:51:55 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788810559475' AND id_product != '20916' AND ean13 != '' 14/04/2023 09:51:55 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788810559475', date_upd = NOW() WHERE id_product = '20916' 14/04/2023 09:51:55 am >> UPDATE ps_product_lang SET name = 'ZAINO DA RIEMPIRE', description = '' WHERE id_product = '20916' 14/04/2023 09:51:55 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '10' WHERE id_product = '20916' 14/04/2023 09:51:55 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '10', id_tax_rules_group = '4', id_category_default = '9', 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 = '20916' 14/04/2023 09:51:55 am >> DELETE FROM ps_specific_price WHERE id_product = '20916' 14/04/2023 09:51:57 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 = '20916' 14/04/2023 09:51:57 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20917' , '1' , '' , 'nuovo-prodotto' ) 14/04/2023 09:51:57 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 '20917' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20916' 14/04/2023 09:51:57 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20917' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20916' 14/04/2023 09:53:49 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788810410486' AND id_product != '20917' AND ean13 != '' 14/04/2023 09:53:49 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788810410486', date_upd = NOW() WHERE id_product = '20917' 14/04/2023 09:53:49 am >> UPDATE ps_product_lang SET name = 'GESU\' E IL CREATO', description = '' WHERE id_product = '20917' 14/04/2023 09:53:49 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '17' WHERE id_product = '20917' 14/04/2023 09:53:49 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '17', id_tax_rules_group = '4', id_category_default = '9', 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 = '20917' 14/04/2023 09:53:49 am >> DELETE FROM ps_specific_price WHERE id_product = '20917' 14/04/2023 09:53:50 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 = '20917' 14/04/2023 09:53:50 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20918' , '1' , '' , 'nuovo-prodotto' ) 14/04/2023 09:53:50 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 '20918' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20917' 14/04/2023 09:53:50 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20918' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20917' 14/04/2023 09:55:07 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788810204887' AND id_product != '20918' AND ean13 != '' 14/04/2023 09:55:07 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788810204887', date_upd = NOW() WHERE id_product = '20918' 14/04/2023 09:55:07 am >> UPDATE ps_product_lang SET name = 'TOTUM AMORIS EST', description = '' WHERE id_product = '20918' 14/04/2023 09:55:07 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '4' WHERE id_product = '20918' 14/04/2023 09:55:07 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '4', id_tax_rules_group = '4', id_category_default = '9', 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 = '20918' 14/04/2023 09:55:07 am >> DELETE FROM ps_specific_price WHERE id_product = '20918' 14/04/2023 10:00:25 am >> SELECT document_num FROM ps_document WHERE document_num = '1250' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-14') 14/04/2023 10:00:25 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1250' , '2023-04-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '54.50' , '46.39' , NOW() , NOW() ) 14/04/2023 10:00:25 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82804' 14/04/2023 10:00:25 am >> DELETE FROM ps_document_detail WHERE id_document = '82804' 14/04/2023 10:00:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82804' , '14163' , 'PARACERA OTTONE LUCIDO - Q120' , '1' , '-1' , '1' , '45.00' , '36.885245901639' , '22' , '0' , '45.00' ) 14/04/2023 10:00:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82804' , '20795' , 'SULLA TUA PAROLA MAG/GIU 2023 - 516' , '2' , '-2' , '4' , '5.00' , '5' , '0' , '5' , '9.50' ) 14/04/2023 10:01:12 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788810204887' AND id_product != '20918' AND ean13 != '' 14/04/2023 10:01:12 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788810204887', date_upd = NOW() WHERE id_product = '20918' 14/04/2023 10:01:12 am >> UPDATE ps_product_lang SET name = 'TOTUM AMORIS EST', description = '' WHERE id_product = '20918' 14/04/2023 10:01:12 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '4' WHERE id_product = '20918' 14/04/2023 10:01:12 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '4', id_tax_rules_group = '4', id_category_default = '9', 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 = '20918' 14/04/2023 10:01:12 am >> DELETE FROM ps_specific_price WHERE id_product = '20918' 14/04/2023 10:01:12 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 = '20918' 14/04/2023 10:01:12 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20919' , '1' , '' , 'nuovo-prodotto' ) 14/04/2023 10:01:12 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 '20919' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20918' 14/04/2023 10:01:12 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20919' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20918' 14/04/2023 10:05:30 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788810221969' AND id_product != '20919' AND ean13 != '' 14/04/2023 10:05:30 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788810221969', date_upd = NOW() WHERE id_product = '20919' 14/04/2023 10:05:30 am >> UPDATE ps_product_lang SET name = 'GESU\' DI NAZARET NELLE CULTURE DEL SUO TEMPO', description = '' WHERE id_product = '20919' 14/04/2023 10:05:30 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '22' WHERE id_product = '20919' 14/04/2023 10:05:30 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '22', id_tax_rules_group = '4', id_category_default = '9', 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 = '20919' 14/04/2023 10:05:30 am >> DELETE FROM ps_specific_price WHERE id_product = '20919' 14/04/2023 10:05:31 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 = '20919' 14/04/2023 10:05:31 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20920' , '1' , '' , 'nuovo-prodotto' ) 14/04/2023 10:05:31 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 '20920' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20919' 14/04/2023 10:05:31 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20920' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20919' 14/04/2023 10:06:13 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788810432358' AND id_product != '20920' AND ean13 != '' 14/04/2023 10:06:13 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788810432358', date_upd = NOW() WHERE id_product = '20920' 14/04/2023 10:06:13 am >> UPDATE ps_product_lang SET name = 'INTRODUZIONE ALLA SACRA SCRITTURA - G. PULCINELLI', description = '' WHERE id_product = '20920' 14/04/2023 10:06:13 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '24' WHERE id_product = '20920' 14/04/2023 10:06:13 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '24', id_tax_rules_group = '4', id_category_default = '9', id_argoment_default = '20', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20920' 14/04/2023 10:06:13 am >> DELETE FROM ps_specific_price WHERE id_product = '20920' 14/04/2023 10:06: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 = '20920' 14/04/2023 10:06:15 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20921' , '1' , '' , 'nuovo-prodotto' ) 14/04/2023 10:06: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 '20921' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20920' 14/04/2023 10:06:15 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20921' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20920' 14/04/2023 10:07:13 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788810260029' AND id_product != '20921' AND ean13 != '' 14/04/2023 10:07:13 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788810260029', date_upd = NOW() WHERE id_product = '20921' 14/04/2023 10:07:14 am >> UPDATE ps_product_lang SET name = 'ESODO DELLA PAROLA - P. STEFANI', description = '' WHERE id_product = '20921' 14/04/2023 10:07:14 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '32' WHERE id_product = '20921' 14/04/2023 10:07:14 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '32', id_tax_rules_group = '4', id_category_default = '9', 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 = '20921' 14/04/2023 10:07:14 am >> DELETE FROM ps_specific_price WHERE id_product = '20921' 14/04/2023 10:07:18 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 = '20921' 14/04/2023 10:07:18 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20922' , '1' , '' , 'nuovo-prodotto' ) 14/04/2023 10:07:18 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 '20922' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20921' 14/04/2023 10:07:18 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20922' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20921' 14/04/2023 10:07:54 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788810412541' AND id_product != '20922' AND ean13 != '' 14/04/2023 10:07:54 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788810412541', date_upd = NOW() WHERE id_product = '20922' 14/04/2023 10:07:54 am >> UPDATE ps_product_lang SET name = 'TRASMETTERE UN VANGELO DI LIBERTA\' - C. THEOBALD', description = '' WHERE id_product = '20922' 14/04/2023 10:07:54 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '18' WHERE id_product = '20922' 14/04/2023 10:07:54 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '18', id_tax_rules_group = '4', id_category_default = '9', 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 = '20922' 14/04/2023 10:07:54 am >> DELETE FROM ps_specific_price WHERE id_product = '20922' 14/04/2023 10:07:55 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 = '20922' 14/04/2023 10:07:55 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20923' , '1' , '' , 'nuovo-prodotto' ) 14/04/2023 10:07:55 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 '20923' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20922' 14/04/2023 10:07:55 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20923' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20922' 14/04/2023 10:09:15 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788810565186' AND id_product != '20923' AND ean13 != '' 14/04/2023 10:09:15 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788810565186', date_upd = NOW() WHERE id_product = '20923' 14/04/2023 10:09:15 am >> UPDATE ps_product_lang SET name = 'LETTERA ALLA COSTITUZIONE - M. ZUPPI', description = '' WHERE id_product = '20923' 14/04/2023 10:09:15 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '10' WHERE id_product = '20923' 14/04/2023 10:09:15 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '10', id_tax_rules_group = '4', id_category_default = '9', 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 = '20923' 14/04/2023 10:09:15 am >> DELETE FROM ps_specific_price WHERE id_product = '20923' 14/04/2023 10:28: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 ( '33' , 'PO000050' , '2023-04-11' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , 'INVIATO DA IL PORTICO' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1604.00' , '1604.00' , NOW() , NOW() ) 14/04/2023 10:28: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 = '82805' 14/04/2023 10:28:32 am >> DELETE FROM ps_document_detail WHERE id_document = '82805' 14/04/2023 10:28: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 ( '82805' , '20911' , 'SOGNO DA VIVERE INSIEME' , '10' , '10' , '4' , '9.00' , '9' , '0' , '0' , '90.0000' ) 14/04/2023 10:28:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '20911' AND id_supplier = '109' 14/04/2023 10:28:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20911' , '109' , '1' ) 14/04/2023 10:28: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 ( '82805' , '20912' , 'FALSI MITI' , '10' , '10' , '4' , '10.00' , '10' , '0' , '0' , '100.0000' ) 14/04/2023 10:28:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '20912' AND id_supplier = '109' 14/04/2023 10:28:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20912' , '109' , '1' ) 14/04/2023 10:28: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 ( '82805' , '20913' , 'RIFARSI UNA VITA' , '10' , '10' , '4' , '10.00' , '10' , '0' , '0' , '100.0000' ) 14/04/2023 10:28:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '20913' AND id_supplier = '109' 14/04/2023 10:28:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20913' , '109' , '1' ) 14/04/2023 10:28: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 ( '82805' , '13152' , 'RAGAZZI IN PANCHINA' , '10' , '10' , '4' , '10.00' , '10' , '0' , '0' , '100.0000' ) 14/04/2023 10:28:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '13152' AND id_supplier = '109' 14/04/2023 10:28:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13152' , '109' , '1' ) 14/04/2023 10:28:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82805' , '20914' , 'CI VUOLE UN FIORE' , '10' , '10' , '4' , '10.00' , '10' , '0' , '0' , '100.0000' ) 14/04/2023 10:28:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '20914' AND id_supplier = '109' 14/04/2023 10:28:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20914' , '109' , '1' ) 14/04/2023 10:28:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82805' , '20915' , 'PER PICCINA CHE TU SIA' , '10' , '10' , '4' , '10.00' , '10' , '0' , '0' , '100.0000' ) 14/04/2023 10:28:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '20915' AND id_supplier = '109' 14/04/2023 10:28:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20915' , '109' , '1' ) 14/04/2023 10:28:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82805' , '20916' , 'ZAINO DA RIEMPIRE' , '10' , '10' , '4' , '10.00' , '10' , '0' , '0' , '100.0000' ) 14/04/2023 10:28:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '20916' AND id_supplier = '109' 14/04/2023 10:28:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20916' , '109' , '1' ) 14/04/2023 10:28:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82805' , '20903' , 'CARITAS SPES FIDES - BENEDETTO XVI' , '10' , '10' , '4' , '19.00' , '19' , '0' , '0' , '190.0000' ) 14/04/2023 10:28:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '20903' AND id_supplier = '109' 14/04/2023 10:28:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20903' , '109' , '1' ) 14/04/2023 10:28:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82805' , '20917' , 'GESU E IL CREATO' , '5' , '5' , '4' , '17.00' , '17' , '0' , '0' , '85.0000' ) 14/04/2023 10:28:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '20917' AND id_supplier = '109' 14/04/2023 10:28:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20917' , '109' , '1' ) 14/04/2023 10:28:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82805' , '19382' , 'REGNO DEI CIELI E PIENO COMPIMENTO - E. MANICARDI' , '5' , '5' , '4' , '21.00' , '21' , '0' , '0' , '105.0000' ) 14/04/2023 10:28:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '19382' AND id_supplier = '109' 14/04/2023 10:28:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19382' , '109' , '1' ) 14/04/2023 10:28:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82805' , '20918' , 'TOTUM AMORIS EST' , '10' , '10' , '4' , '4.00' , '4' , '0' , '0' , '40.0000' ) 14/04/2023 10:28:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '20918' AND id_supplier = '109' 14/04/2023 10:28:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20918' , '109' , '1' ) 14/04/2023 10:28:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82805' , '20919' , 'GESU DI NAZARET NELLE CULTURE DEL SUO TEMPO' , '5' , '5' , '4' , '22.00' , '22' , '0' , '0' , '110.0000' ) 14/04/2023 10:28:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '20919' AND id_supplier = '109' 14/04/2023 10:28:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20919' , '109' , '1' ) 14/04/2023 10:28:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82805' , '20920' , 'INTRODUZIONE ALLA SACRA SCRITTURA - G. PULCINELLI' , '1' , '1' , '4' , '24.00' , '24' , '0' , '0' , '24.00' ) 14/04/2023 10:28:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '20920' AND id_supplier = '109' 14/04/2023 10:28:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20920' , '109' , '1' ) 14/04/2023 10:28:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82805' , '20921' , 'ESODO DELLA PAROLA - P. STEFANI' , '5' , '5' , '4' , '32.00' , '32' , '0' , '0' , '160.0000' ) 14/04/2023 10:28:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '20921' AND id_supplier = '109' 14/04/2023 10:28:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20921' , '109' , '1' ) 14/04/2023 10:28:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82805' , '20922' , 'TRASMETTERE UN VANGELO DI LIBERTA - C. THEOBALD' , '5' , '5' , '4' , '18.00' , '18' , '0' , '0' , '90.0000' ) 14/04/2023 10:28:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '20922' AND id_supplier = '109' 14/04/2023 10:28:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20922' , '109' , '1' ) 14/04/2023 10:28:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82805' , '20417' , 'NON SARA SUBITO LA FINE - G. ZANCHI' , '5' , '5' , '4' , '12.00' , '12' , '0' , '0' , '60.0000' ) 14/04/2023 10:28:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '20417' AND id_supplier = '109' 14/04/2023 10:28:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20417' , '109' , '1' ) 14/04/2023 10:28:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82805' , '20923' , 'LETTERA ALLA COSTITUZIONE - M. ZUPPI' , '5' , '5' , '4' , '10.00' , '10' , '0' , '0' , '50.0000' ) 14/04/2023 10:28:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '20923' AND id_supplier = '109' 14/04/2023 10:28:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20923' , '109' , '1' ) 14/04/2023 10:30:02 am >> INSERT INTO ps_supplier ( name , email , `date_add` , `date_upd` ) VALUES ( '' , '' , NOW() , NOW() ) 14/04/2023 10:30:02 am >> INSERT INTO ps_supplier_shop ( id_supplier , id_shop ) VALUES ( '176' , '1' ) 14/04/2023 10:30:02 am >> INSERT INTO ps_supplier_lang ( id_supplier , id_lang ) VALUES ( '176' , '1' ) 14/04/2023 10:30:02 am >> INSERT INTO ps_address ( id_supplier , id_country , id_state , alias , lastname , firstname , address1 , city , date_add , date_upd ) VALUES ( '176' , '10' , '0' , '' , '' , '' , '' , '' , NOW() , NOW() ) 14/04/2023 10:32:05 am >> UPDATE ps_address SET id_state = '180', lastname = 'VITA E PENSIERO', address1 = 'LARGO GEMELLI 1 ', address2 = '', postcode = '20123', dni = '', vat_number = '02133120150', city = 'MILANO', phone = '', phone_mobile = '', date_upd = NOW() WHERE id_supplier = '176' 14/04/2023 10:32:05 am >> UPDATE ps_supplier SET email = 'commerciale.vp@unicatt.it', name = 'VITA E PENSIERO', date_upd = NOW() WHERE id_supplier = '176' 14/04/2023 10:32:05 am >> UPDATE ps_supplier_lang SET description = '', meta_title = '', meta_description = '' WHERE id_supplier = '176' 14/04/2023 10:32:37 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' , '1179' , '2023-04-12' , '' , '0' , '176' , '4678847' , 'LARGO GEMELLI 1 20123 MILANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '600.00' , '600.00' , NOW() , NOW() ) 14/04/2023 10:32:37 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 = '82806' 14/04/2023 10:32:37 am >> DELETE FROM ps_document_detail WHERE id_document = '82806' 14/04/2023 10:32:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82806' , '20910' , 'sud il capitale che serve - c. borgomeo' , '40' , '40' , '4' , '15.00' , '15' , '0' , '0' , '600.0000' ) 14/04/2023 10:32:37 am >> DELETE FROM ps_product_supplier WHERE id_product = '20910' AND id_supplier = '176' 14/04/2023 10:32:37 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20910' , '176' , '1' ) 14/04/2023 10:39:53 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 14/04/2023 10:39:53 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20924' , '1' , '' , 'nuovo-prodotto' ) 14/04/2023 10:39:53 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '20924' , '1' , '1' , '2' , NOW() , NOW() ) 14/04/2023 10:39:53 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '20924' , '0' , '1' , '0' , '0' ) 14/04/2023 10:41:09 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791259752598' AND id_product != '20924' AND ean13 != '' 14/04/2023 10:41:09 am >> UPDATE ps_product SET id_supplier = '', reference = '6/5', ean13 = '9791259752598', date_upd = NOW() WHERE id_product = '20924' 14/04/2023 10:41:09 am >> UPDATE ps_product_lang SET name = 'LIETI NELLA SPERANZA - G. BENTOGLIO', description = '' WHERE id_product = '20924' 14/04/2023 10:41:09 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '16' WHERE id_product = '20924' 14/04/2023 10:41:10 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '16', id_tax_rules_group = '4', id_category_default = '267', 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 = '20924' 14/04/2023 10:41:10 am >> DELETE FROM ps_specific_price WHERE id_product = '20924' 14/04/2023 10:41:10 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 = '20924' 14/04/2023 10:41:10 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20925' , '1' , '' , 'nuovo-prodotto' ) 14/04/2023 10:41:10 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 '20925' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20924' 14/04/2023 10:41:10 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20925' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20924' 14/04/2023 10:42:11 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801068436' AND id_product != '423' AND ean13 != '' 14/04/2023 10:42:11 am >> UPDATE ps_product SET id_supplier = '7', reference = '1/2', ean13 = '9788801068436', date_upd = NOW() WHERE id_product = '423' 14/04/2023 10:42:11 am >> UPDATE ps_product_lang SET name = 'ALTRE STORIE - B. FERRERO', description = '' WHERE id_product = '423' 14/04/2023 10:42:11 am >> UPDATE ps_product SET wholesale_price = '7.96', on_sale = '0', price = 'NaN' WHERE id_product = '423' 14/04/2023 10:42:11 am >> UPDATE ps_product_shop SET wholesale_price = '7.96', price = 'NaN', id_tax_rules_group = '4', id_category_default = '19', id_argoment_default = '35', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '423' 14/04/2023 10:42:11 am >> DELETE FROM ps_specific_price WHERE id_product = '423' 14/04/2023 10:49:45 am >> SELECT document_num FROM ps_document WHERE document_num = '1251' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-14') 14/04/2023 10:49:45 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1251' , '2023-04-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.15' , '5.86' , NOW() , NOW() ) 14/04/2023 10:49:45 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82807' 14/04/2023 10:49:45 am >> DELETE FROM ps_document_detail WHERE id_document = '82807' 14/04/2023 10:49:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82807' , '4404' , 'GESÙ CONFIDO IN TE - 296' , '2' , '-2' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '7.00' ) 14/04/2023 10:49:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82807' , '4406' , 'GESÙ CONFIDO IN TE - ARS 70' , '1' , '-1' , '1' , '0.15' , '0.12295081967213' , '22' , '0' , '0.15' ) 14/04/2023 10:53:52 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801068429' AND id_product != '20925' AND ean13 != '' 14/04/2023 10:53:52 am >> UPDATE ps_product SET id_supplier = '', reference = '5/1', ean13 = '9788801068429', date_upd = NOW() WHERE id_product = '20925' 14/04/2023 10:53:52 am >> UPDATE ps_product_lang SET name = 'INTORNO A UNA STORIA', description = '' WHERE id_product = '20925' 14/04/2023 10:53:52 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '9.9' WHERE id_product = '20925' 14/04/2023 10:53:52 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '9.9', id_tax_rules_group = '4', id_category_default = '19', id_argoment_default = '35', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20925' 14/04/2023 10:53:52 am >> DELETE FROM ps_specific_price WHERE id_product = '20925' 14/04/2023 10:54: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 = '20925' 14/04/2023 10:54:05 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20926' , '1' , '' , 'nuovo-prodotto' ) 14/04/2023 10:54: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 '20926' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20925' 14/04/2023 10:54:05 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20926' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20925' 14/04/2023 10:55:53 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801068474' AND id_product != '20926' AND ean13 != '' 14/04/2023 10:55:53 am >> UPDATE ps_product SET id_supplier = '', reference = '6/4', ean13 = '9788801068474', date_upd = NOW() WHERE id_product = '20926' 14/04/2023 10:55:53 am >> UPDATE ps_product_lang SET name = 'DON BOSCO E LA REALTA\' DIGITALE - G. SANTOS', description = '' WHERE id_product = '20926' 14/04/2023 10:55:53 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '10' WHERE id_product = '20926' 14/04/2023 10:55:53 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '10', id_tax_rules_group = '4', id_category_default = '19', id_argoment_default = '71', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20926' 14/04/2023 10:55:53 am >> DELETE FROM ps_specific_price WHERE id_product = '20926' 14/04/2023 10:55:55 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 = '20926' 14/04/2023 10:55:55 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20927' , '1' , '' , 'nuovo-prodotto' ) 14/04/2023 10:55:55 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 '20927' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20926' 14/04/2023 10:55:55 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20927' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20926' 14/04/2023 10:56:54 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788839934529' AND id_product != '20927' AND ean13 != '' 14/04/2023 10:56:54 am >> UPDATE ps_product SET id_supplier = '', reference = '13/6', ean13 = '9788839934529', date_upd = NOW() WHERE id_product = '20927' 14/04/2023 10:56:54 am >> UPDATE ps_product_lang SET name = 'FEDE SENZA VERITA\' - M. SEEWALD', description = '' WHERE id_product = '20927' 14/04/2023 10:56:54 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '33' WHERE id_product = '20927' 14/04/2023 10:56:54 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '33', 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 = '20927' 14/04/2023 10:56:54 am >> DELETE FROM ps_specific_price WHERE id_product = '20927' 14/04/2023 10:56:55 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 = '20927' 14/04/2023 10:56:55 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20928' , '1' , '' , 'nuovo-prodotto' ) 14/04/2023 10:56:55 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 '20928' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20927' 14/04/2023 10:56:55 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20928' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20927' 14/04/2023 10:57:42 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892241701' AND id_product != '20928' AND ean13 != '' 14/04/2023 10:57:42 am >> UPDATE ps_product SET id_supplier = '', reference = '7/5', ean13 = '9788892241701', date_upd = NOW() WHERE id_product = '20928' 14/04/2023 10:57:42 am >> UPDATE ps_product_lang SET name = 'CHI E\' MARIA? - C. MAGGIONI', description = '' WHERE id_product = '20928' 14/04/2023 10:57:42 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '16' WHERE id_product = '20928' 14/04/2023 10:57:42 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '16', id_tax_rules_group = '4', id_category_default = '30', 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 = '20928' 14/04/2023 10:57:42 am >> DELETE FROM ps_specific_price WHERE id_product = '20928' 14/04/2023 10:57:43 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 = '20928' 14/04/2023 10:57:43 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20929' , '1' , '' , 'nuovo-prodotto' ) 14/04/2023 10:57:43 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 '20929' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20928' 14/04/2023 10:57:43 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20929' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20928' 14/04/2023 11:00:46 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892241541' AND id_product != '20929' AND ean13 != '' 14/04/2023 11:00:46 am >> UPDATE ps_product SET id_supplier = '', reference = '13/6', ean13 = '9788892241541', date_upd = NOW() WHERE id_product = '20929' 14/04/2023 11:00:46 am >> UPDATE ps_product_lang SET name = 'SULLE ORME DEI SAPIENTI - M. GILBERT', description = '' WHERE id_product = '20929' 14/04/2023 11:00:46 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '28' WHERE id_product = '20929' 14/04/2023 11:00:46 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '28', 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 = '20929' 14/04/2023 11:00:46 am >> DELETE FROM ps_specific_price WHERE id_product = '20929' 14/04/2023 11:01:10 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 = '20929' 14/04/2023 11:01:10 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20930' , '1' , '' , 'nuovo-prodotto' ) 14/04/2023 11:01:10 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 '20930' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20929' 14/04/2023 11:01:10 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20930' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20929' 14/04/2023 11:03:03 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801068368' AND id_product != '20930' AND ean13 != '' 14/04/2023 11:03:03 am >> UPDATE ps_product SET id_supplier = '', reference = '7/7', ean13 = '9788801068368', date_upd = NOW() WHERE id_product = '20930' 14/04/2023 11:03:03 am >> UPDATE ps_product_lang SET name = 'LITURGIA FESTIVA DELLA PAROLA', description = '' WHERE id_product = '20930' 14/04/2023 11:03:03 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '19' WHERE id_product = '20930' 14/04/2023 11:03:03 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '19', id_tax_rules_group = '4', id_category_default = '19', id_argoment_default = '89', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20930' 14/04/2023 11:03:03 am >> DELETE FROM ps_specific_price WHERE id_product = '20930' 14/04/2023 11:03: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 = '20930' 14/04/2023 11:03:30 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20931' , '1' , '' , 'nuovo-prodotto' ) 14/04/2023 11:03: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 '20931' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20930' 14/04/2023 11:03:30 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20931' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20930' 14/04/2023 11:04:58 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831554800' AND id_product != '20931' AND ean13 != '' 14/04/2023 11:04:58 am >> UPDATE ps_product SET id_supplier = '', reference = '5/2', ean13 = '9788831554800', date_upd = NOW() WHERE id_product = '20931' 14/04/2023 11:04:58 am >> UPDATE ps_product_lang SET name = 'BIBBIA IMMAGINI E RACCONTI', description = '' WHERE id_product = '20931' 14/04/2023 11:04:58 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '24' WHERE id_product = '20931' 14/04/2023 11:04:58 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '24', id_tax_rules_group = '4', id_category_default = '27', 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 = '20931' 14/04/2023 11:04:58 am >> DELETE FROM ps_specific_price WHERE id_product = '20931' 14/04/2023 11:05: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 = '20931' 14/04/2023 11:05:03 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20932' , '1' , '' , 'nuovo-prodotto' ) 14/04/2023 11:05: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 '20932' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20931' 14/04/2023 11:05:03 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20932' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20931' 14/04/2023 11:08:07 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788851426811' AND id_product != '20932' AND ean13 != '' 14/04/2023 11:08:07 am >> UPDATE ps_product SET id_supplier = '', reference = '13/5', ean13 = '9788851426811', date_upd = NOW() WHERE id_product = '20932' 14/04/2023 11:08:07 am >> UPDATE ps_product_lang SET name = 'SOSTARE CON DIO', description = '' WHERE id_product = '20932' 14/04/2023 11:08:07 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3' WHERE id_product = '20932' 14/04/2023 11:08:07 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3', id_tax_rules_group = '4', id_category_default = '98', 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 = '20932' 14/04/2023 11:08:07 am >> DELETE FROM ps_specific_price WHERE id_product = '20932' 14/04/2023 11:08:08 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 = '20932' 14/04/2023 11:08:08 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20933' , '1' , '' , 'nuovo-prodotto' ) 14/04/2023 11:08:08 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 '20933' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20932' 14/04/2023 11:08:08 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20933' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20932' 14/04/2023 11:09:23 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788868946081' AND id_product != '20933' AND ean13 != '' 14/04/2023 11:09:23 am >> UPDATE ps_product SET id_supplier = '', reference = '5/5', ean13 = '9788868946081', date_upd = NOW() WHERE id_product = '20933' 14/04/2023 11:09:23 am >> UPDATE ps_product_lang SET name = 'OGNI SERA UNA PREGHIERA - M. DELPINI', description = '' WHERE id_product = '20933' 14/04/2023 11:09:23 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3.5' WHERE id_product = '20933' 14/04/2023 11:09:23 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3.5', id_tax_rules_group = '4', id_category_default = '98', 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 = '20933' 14/04/2023 11:09:23 am >> DELETE FROM ps_specific_price WHERE id_product = '20933' 14/04/2023 11:10:12 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 = '20933' 14/04/2023 11:10:12 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20934' , '1' , '' , 'nuovo-prodotto' ) 14/04/2023 11:10:12 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 '20934' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20933' 14/04/2023 11:10:12 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20934' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20933' 14/04/2023 11:13:17 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788868946098' AND id_product != '20934' AND ean13 != '' 14/04/2023 11:13:17 am >> UPDATE ps_product SET id_supplier = '', reference = '1/2', ean13 = '9788868946098', date_upd = NOW() WHERE id_product = '20934' 14/04/2023 11:13:17 am >> UPDATE ps_product_lang SET name = 'E CHI E\' MIO PROSSIMO?', description = '' WHERE id_product = '20934' 14/04/2023 11:13:18 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '2.8' WHERE id_product = '20934' 14/04/2023 11:13:18 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '2.8', id_tax_rules_group = '4', id_category_default = '103', id_argoment_default = '86', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20934' 14/04/2023 11:13:18 am >> DELETE FROM ps_specific_price WHERE id_product = '20934' 14/04/2023 11:13:59 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788868946098' AND id_product != '20934' AND ean13 != '' 14/04/2023 11:13:59 am >> UPDATE ps_product SET id_supplier = '', reference = '1/2', ean13 = '9788868946098', date_upd = NOW() WHERE id_product = '20934' 14/04/2023 11:13:59 am >> UPDATE ps_product_lang SET name = 'E CHI E\' MIO PROSSIMO?', description = '' WHERE id_product = '20934' 14/04/2023 11:13:59 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '2.8' WHERE id_product = '20934' 14/04/2023 11:13:59 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '2.8', id_tax_rules_group = '4', id_category_default = '103', id_argoment_default = '86', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20934' 14/04/2023 11:13:59 am >> DELETE FROM ps_specific_price WHERE id_product = '20934' 14/04/2023 11:14: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 = '20934' 14/04/2023 11:14:00 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20935' , '1' , '' , 'nuovo-prodotto' ) 14/04/2023 11:14: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 '20935' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20934' 14/04/2023 11:14:00 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20935' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20934' 14/04/2023 11:14:53 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788868946074' AND id_product != '20935' AND ean13 != '' 14/04/2023 11:14:53 am >> UPDATE ps_product SET id_supplier = '', reference = '1/2', ean13 = '9788868946074', date_upd = NOW() WHERE id_product = '20935' 14/04/2023 11:14:53 am >> UPDATE ps_product_lang SET name = 'TU X TUTTI', description = '' WHERE id_product = '20935' 14/04/2023 11:14:53 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '12' WHERE id_product = '20935' 14/04/2023 11:14:53 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '12', id_tax_rules_group = '4', id_category_default = '103', id_argoment_default = '86', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20935' 14/04/2023 11:14:53 am >> DELETE FROM ps_specific_price WHERE id_product = '20935' 14/04/2023 11:14:54 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 = '20935' 14/04/2023 11:14:54 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20936' , '1' , '' , 'nuovo-prodotto' ) 14/04/2023 11:14:54 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 '20936' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20935' 14/04/2023 11:14:54 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20936' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20935' 14/04/2023 11:16:35 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791281253254' AND id_product != '20936' AND ean13 != '' 14/04/2023 11:16:35 am >> UPDATE ps_product SET id_supplier = '', reference = 'ESPOSITORE GIREVOLE', ean13 = '9791281253254', date_upd = NOW() WHERE id_product = '20936' 14/04/2023 11:16:35 am >> UPDATE ps_product_lang SET name = 'SANTA RITA - VITA BREVIS', description = '' WHERE id_product = '20936' 14/04/2023 11:16:35 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '2' WHERE id_product = '20936' 14/04/2023 11:16:35 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '2', id_tax_rules_group = '4', id_category_default = '518', id_argoment_default = '53', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20936' 14/04/2023 11:16:35 am >> DELETE FROM ps_specific_price WHERE id_product = '20936' 14/04/2023 11:19:58 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788872981917' AND id_product != '16882' AND ean13 != '' 14/04/2023 11:19:58 am >> UPDATE ps_product SET id_supplier = '7', reference = 'ESPOSITORE GIREVOLE', ean13 = '9788872981917', date_upd = NOW() WHERE id_product = '16882' 14/04/2023 11:19:58 am >> UPDATE ps_product_lang SET name = 'S. RITA DA CASCIA VITA BREVIS', description = '' WHERE id_product = '16882' 14/04/2023 11:19:58 am >> UPDATE ps_product SET wholesale_price = '1.40', on_sale = '0', price = '2.0000' WHERE id_product = '16882' 14/04/2023 11:19:58 am >> UPDATE ps_product_shop SET wholesale_price = '1.40', price = '2.0000', id_tax_rules_group = '4', id_category_default = '29', id_argoment_default = '71', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '16882' 14/04/2023 11:19:58 am >> DELETE FROM ps_specific_price WHERE id_product = '16882' 14/04/2023 11:21:55 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801068436' AND id_product != '423' AND ean13 != '' 14/04/2023 11:21:55 am >> UPDATE ps_product SET id_supplier = '7', reference = '1/2', ean13 = '9788801068436', date_upd = NOW() WHERE id_product = '423' 14/04/2023 11:21:55 am >> UPDATE ps_product_lang SET name = 'ALTRE STORIE - B. FERRERO', description = '' WHERE id_product = '423' 14/04/2023 11:21:56 am >> UPDATE ps_product SET wholesale_price = '7.96', on_sale = '0', price = '9.9' WHERE id_product = '423' 14/04/2023 11:21:56 am >> UPDATE ps_product_shop SET wholesale_price = '7.96', price = '9.9', id_tax_rules_group = '4', id_category_default = '19', id_argoment_default = '35', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '423' 14/04/2023 11:21:56 am >> DELETE FROM ps_specific_price WHERE id_product = '423' 14/04/2023 11:23:31 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788868946081' AND id_product != '20933' AND ean13 != '' 14/04/2023 11:23:31 am >> UPDATE ps_product SET id_supplier = '', reference = '5/5', ean13 = '9788868946081', date_upd = NOW() WHERE id_product = '20933' 14/04/2023 11:23:31 am >> UPDATE ps_product_lang SET name = 'OGNI SERA UNA PREGHIERA - M. DELPINI', description = '' WHERE id_product = '20933' 14/04/2023 11:23:31 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3.5000' WHERE id_product = '20933' 14/04/2023 11:23:31 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3.5000', id_tax_rules_group = '4', id_category_default = '103', 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 = '20933' 14/04/2023 11:23:31 am >> DELETE FROM ps_specific_price WHERE id_product = '20933' 14/04/2023 11:25: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 ( '33' , '628186' , '2023-04-06' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '3.9' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '141.46' , '141.46' , NOW() , NOW() ) 14/04/2023 11:25: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 = '82808' 14/04/2023 11:25:20 am >> DELETE FROM ps_document_detail WHERE id_document = '82808' 14/04/2023 11:25: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 ( '82808' , '20936' , 'SANTA RITA - VITA BREVIS' , '5' , '5' , '4' , '2.00' , '2' , '0' , '30' , '7.0000' ) 14/04/2023 11:25:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '20936' AND id_supplier = '7' 14/04/2023 11:25:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20936' , '7' , '1' ) 14/04/2023 11:25: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 ( '82808' , '20924' , 'LIETI NELLA SPERANZA - G. BENTOGLIO' , '1' , '1' , '4' , '16.00' , '16' , '0' , '30' , '11.2000' ) 14/04/2023 11:25:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '20924' AND id_supplier = '7' 14/04/2023 11:25:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20924' , '7' , '1' ) 14/04/2023 11:25: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 ( '82808' , '20930' , 'LITURGIA FESTIVA DELLA PAROLA' , '1' , '1' , '4' , '19.00' , '19' , '0' , '35' , '12.3500' ) 14/04/2023 11:25:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '20930' AND id_supplier = '7' 14/04/2023 11:25:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20930' , '7' , '1' ) 14/04/2023 11:25: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 ( '82808' , '20925' , 'INTORNO A UNA STORIA' , '1' , '1' , '4' , '9.90' , '9.9' , '0' , '35' , '6.4350' ) 14/04/2023 11:25:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '20925' AND id_supplier = '7' 14/04/2023 11:25:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20925' , '7' , '1' ) 14/04/2023 11:25: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 ( '82808' , '423' , 'ALTRE STORIE - B. FERRERO' , '1' , '1' , '4' , '9.90' , '9.9' , '0' , '35' , '6.4350' ) 14/04/2023 11:25:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '423' AND id_supplier = '7' 14/04/2023 11:25:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '423' , '7' , '1' ) 14/04/2023 11:25: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 ( '82808' , '20929' , 'SULLE ORME DEI SAPIENTI - M. GILBERT' , '1' , '1' , '4' , '28.00' , '28' , '0' , '33' , '18.7600' ) 14/04/2023 11:25:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '20929' AND id_supplier = '7' 14/04/2023 11:25:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20929' , '7' , '1' ) 14/04/2023 11:25: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 ( '82808' , '20928' , 'CHI E MARIA? - C. MAGGIONI' , '1' , '1' , '4' , '16.00' , '16' , '0' , '33' , '10.7200' ) 14/04/2023 11:25:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '20928' AND id_supplier = '7' 14/04/2023 11:25:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20928' , '7' , '1' ) 14/04/2023 11:25: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 ( '82808' , '20927' , 'FEDE SENZA VERITA - M. SEEWALD' , '1' , '1' , '4' , '33.00' , '33' , '0' , '30' , '23.1000' ) 14/04/2023 11:25:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '20927' AND id_supplier = '7' 14/04/2023 11:25:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20927' , '7' , '1' ) 14/04/2023 11:25: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 ( '82808' , '20932' , 'SOSTARE CON DIO' , '2' , '2' , '4' , '3.00' , '3' , '0' , '30' , '4.2000' ) 14/04/2023 11:25:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '20932' AND id_supplier = '7' 14/04/2023 11:25:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20932' , '7' , '1' ) 14/04/2023 11:25:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82808' , '20933' , 'OGNI SERA UNA PREGHIERA - M. DELPINI' , '2' , '2' , '4' , '3.50' , '3.5' , '0' , '30' , '4.9000' ) 14/04/2023 11:25:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '20933' AND id_supplier = '7' 14/04/2023 11:25:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20933' , '7' , '1' ) 14/04/2023 11:25:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82808' , '20934' , 'E CHI E MIO PROSSIMO?' , '1' , '1' , '4' , '2.80' , '2.8' , '0' , '30' , '1.9600' ) 14/04/2023 11:25:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '20934' AND id_supplier = '7' 14/04/2023 11:25:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20934' , '7' , '1' ) 14/04/2023 11:25:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82808' , '20931' , 'BIBBIA IMMAGINI E RACCONTI' , '1' , '1' , '4' , '24.00' , '24' , '0' , '35' , '15.6000' ) 14/04/2023 11:25:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '20931' AND id_supplier = '7' 14/04/2023 11:25:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20931' , '7' , '1' ) 14/04/2023 11:25:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82808' , '20926' , 'DON BOSCO E LA REALTA DIGITALE - G. SANTOS' , '1' , '1' , '4' , '10.00' , '10' , '0' , '35' , '6.5000' ) 14/04/2023 11:25:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '20926' AND id_supplier = '7' 14/04/2023 11:25:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20926' , '7' , '1' ) 14/04/2023 11:25:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82808' , '20935' , 'TU X TUTTI' , '1' , '1' , '4' , '12.00' , '12' , '0' , '30' , '8.4000' ) 14/04/2023 11:25:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '20935' AND id_supplier = '7' 14/04/2023 11:25:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20935' , '7' , '1' ) 14/04/2023 11:48:01 am >> SELECT document_num FROM ps_document WHERE document_num = '1252' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-14') 14/04/2023 11:48:01 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1252' , '2023-04-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.70' , '8.77' , NOW() , NOW() ) 14/04/2023 11:48:01 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82809' 14/04/2023 11:48:01 am >> DELETE FROM ps_document_detail WHERE id_document = '82809' 14/04/2023 11:48:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82809' , '5536' , 'LACCIO' , '1' , '-1' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '0.70' ) 14/04/2023 11:48:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82809' , '20552' , 'TAU CON LACCIO E APPLICAZIONE - RES101' , '1' , '-1' , '1' , '5.00' , '4.0983606557377' , '22' , '0' , '5.00' ) 14/04/2023 11:48:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82809' , '20553' , 'TAU CON LACCIO E APPLICAZIONE - RES101' , '1' , '-1' , '1' , '5.00' , '4.0983606557377' , '22' , '0' , '5.00' ) 14/04/2023 11:50:52 am >> SELECT document_num FROM ps_document WHERE document_num = '1253' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-14') 14/04/2023 11:50:52 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1253' , '2023-04-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.00' , '7.00' , NOW() , NOW() ) 14/04/2023 11:50:52 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82810' 14/04/2023 11:50:52 am >> DELETE FROM ps_document_detail WHERE id_document = '82810' 14/04/2023 11:50:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82810' , '14141' , 'BEATO BARTOLO LONGO - 8859' , '1' , '-1' , '4' , '7.00' , '7' , '0' , '0' , '7.00' ) 14/04/2023 12:02:54 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001821' AND id_product != '18838' AND ean13 != '' 14/04/2023 12:02:54 pm >> UPDATE ps_product SET id_supplier = '6', reference = '', ean13 = '001821', date_upd = NOW() WHERE id_product = '18838' 14/04/2023 12:02:54 pm >> UPDATE ps_product_lang SET name = 'CAPOCULLA PICCOLO', description = '' WHERE id_product = '18838' 14/04/2023 12:02:54 pm >> UPDATE ps_product SET wholesale_price = '6.50', on_sale = '0', price = '15.573770491803279' WHERE id_product = '18838' 14/04/2023 12:02:54 pm >> UPDATE ps_product_shop SET wholesale_price = '6.50', price = '15.573770491803279', id_tax_rules_group = '1', id_category_default = '120', 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 = '18838' 14/04/2023 12:02:54 pm >> DELETE FROM ps_specific_price WHERE id_product = '18838' 14/04/2023 12:03:04 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001821' AND id_product != '18838' AND ean13 != '' 14/04/2023 12:03:04 pm >> UPDATE ps_product SET id_supplier = '6', reference = '', ean13 = '001821', date_upd = NOW() WHERE id_product = '18838' 14/04/2023 12:03:04 pm >> UPDATE ps_product_lang SET name = 'CAPOCULLA ', description = '' WHERE id_product = '18838' 14/04/2023 12:03:04 pm >> UPDATE ps_product SET wholesale_price = '6.50', on_sale = '0', price = '15.573770491803279' WHERE id_product = '18838' 14/04/2023 12:03:04 pm >> UPDATE ps_product_shop SET wholesale_price = '6.50', price = '15.573770491803279', id_tax_rules_group = '1', id_category_default = '120', 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 = '18838' 14/04/2023 12:03:04 pm >> DELETE FROM ps_specific_price WHERE id_product = '18838' 14/04/2023 12:04: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 ( '31' , 'FT 1/1572' , '2023-04-14' , '1572' , '0' , '6' , '2601' , 'ZONO ASI SUD - CENTRO ORAFO \\\"IL TARÍ\\\" 81025 MARCIANISE' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '47.58' , '39.00' , NOW() , NOW() ) 14/04/2023 12:04: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 = '82811' 14/04/2023 12:04:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '82811' 14/04/2023 12:04: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 ( '82811' , '17287' , 'CAPOCULLA 7X9' , '2' , '2' , '1' , '6' , '4.9180327868852' , '22' , '0' , '14.6400' ) 14/04/2023 12:04:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17287' AND id_supplier = '6' 14/04/2023 12:04:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17287' , '6' , '1' ) 14/04/2023 12:04: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 ( '82811' , '18840' , 'CAPOCULLA ' , '2' , '2' , '1' , '9.5' , '7.7868852459016' , '22' , '0' , '23.1800' ) 14/04/2023 12:04:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18840' AND id_supplier = '6' 14/04/2023 12:04:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18840' , '6' , '1' ) 14/04/2023 12:04: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 ( '82811' , '18838' , 'CAPOCULLA ' , '1' , '1' , '1' , '8' , '6.5573770491803' , '22' , '0' , '9.7600' ) 14/04/2023 12:04:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18838' AND id_supplier = '6' 14/04/2023 12:04:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18838' , '6' , '1' ) 14/04/2023 12:16:10 pm >> SELECT document_num FROM ps_document WHERE document_num = '1254' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-14') 14/04/2023 12:16:10 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' , '1254' , '2023-04-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '115.00' , '94.26' , NOW() , NOW() ) 14/04/2023 12:16:10 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82812' 14/04/2023 12:16:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '82812' 14/04/2023 12:16:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82812' , '2371' , 'CLERGY NERO ML - MISTO 42 ' , '1' , '-1' , '1' , '35' , '28.688524590164' , '22' , '' , '35.00' ) 14/04/2023 12:16:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82812' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '38' , '31.147540983607' , '22' , '0' , '38.00' ) 14/04/2023 12:16:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82812' , '16119' , 'CLERGY GRIGIO JEANS - L' , '1' , '-1' , '1' , '42.00' , '34.426229508197' , '22' , '0' , '42.00' ) 14/04/2023 12:27:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '1255' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-14') 14/04/2023 12:27: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 ( '11' , '1255' , '2023-04-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '23.00' , '23.00' , NOW() , NOW() ) 14/04/2023 12:27: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 = '82813' 14/04/2023 12:27:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '82813' 14/04/2023 12:27: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 ( '82813' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '23' , '23' , '0' , '0' , '23.00' ) 14/04/2023 12:29:38 pm >> SELECT document_num FROM ps_document WHERE document_num = '1180' AND id_document != '82717' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-07') 14/04/2023 12:29:39 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1180', document_date = '2023-04-07', 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 = '74.00', price_tax_excluded = '60.66', date_upd = NOW() WHERE id_document = '82717' 14/04/2023 12:29:39 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82717' 14/04/2023 12:29:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '82717' 14/04/2023 12:29: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 ( '82717' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '1' , '-1' , '1' , '68.0000' , '55.737704918033' , '22' , '0' , '68.00' ) 14/04/2023 12:29: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 ( '82717' , '10444' , 'TAPPI RICAMBIO - ORO ' , '1' , '-1' , '1' , '6.00' , '4.9180327868852' , '22' , '0' , '6.00' ) 14/04/2023 12:52:23 pm >> SELECT document_num FROM ps_document WHERE document_num = '1254' AND id_document != '82812' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-14') 14/04/2023 12:52:23 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1254', document_date = '2023-04-14', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '115.00', price_tax_excluded = '94.26', date_upd = NOW() WHERE id_document = '82812' 14/04/2023 12:52:23 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82812' 14/04/2023 12:52:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '82812' 14/04/2023 12:52:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82812' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '73' , '59.83606557377' , '22' , '0' , '73.00' ) 14/04/2023 12:52:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82812' , '16119' , 'CLERGY GRIGIO JEANS - L' , '1' , '-1' , '1' , '42.0000' , '34.426229508197' , '22' , '0' , '42.00' ) 14/04/2023 02:15:54 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 14/04/2023 02:15:54 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20937' , '1' , '' , 'nuovo-prodotto' ) 14/04/2023 02:15:54 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '20937' , '1' , '1' , '2' , NOW() , NOW() ) 14/04/2023 02:15:54 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '20937' , '0' , '1' , '0' , '0' ) 14/04/2023 02:17:10 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788832713701' AND id_product != '20937' AND ean13 != '' 14/04/2023 02:17:10 pm >> UPDATE ps_product SET id_supplier = '', reference = '1/2', ean13 = '9788832713701', date_upd = NOW() WHERE id_product = '20937' 14/04/2023 02:17:10 pm >> UPDATE ps_product_lang SET name = 'STORIE #NOFILTER', description = '' WHERE id_product = '20937' 14/04/2023 02:17:10 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '9' WHERE id_product = '20937' 14/04/2023 02:17:10 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '9', id_tax_rules_group = '4', id_category_default = '80', id_argoment_default = '217', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20937' 14/04/2023 02:17:10 pm >> DELETE FROM ps_specific_price WHERE id_product = '20937' 14/04/2023 02:17:12 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '20937' 14/04/2023 02:17:12 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20938' , '1' , '' , 'nuovo-prodotto' ) 14/04/2023 02:17:12 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '20938' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20937' 14/04/2023 02:17:12 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20938' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20937' 14/04/2023 02:17:36 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788832713763' AND id_product != '20938' AND ean13 != '' 14/04/2023 02:17:37 pm >> UPDATE ps_product SET id_supplier = '', reference = '1/2', ean13 = '9788832713763', date_upd = NOW() WHERE id_product = '20938' 14/04/2023 02:17:37 pm >> UPDATE ps_product_lang SET name = 'TU SEI UNA PROMESSA', description = '' WHERE id_product = '20938' 14/04/2023 02:17:37 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '16' WHERE id_product = '20938' 14/04/2023 02:17:37 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '16', id_tax_rules_group = '4', id_category_default = '80', id_argoment_default = '217', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20938' 14/04/2023 02:17:37 pm >> DELETE FROM ps_specific_price WHERE id_product = '20938' 14/04/2023 02:17:37 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '20938' 14/04/2023 02:17:37 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20939' , '1' , '' , 'nuovo-prodotto' ) 14/04/2023 02:17:37 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '20939' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20938' 14/04/2023 02:17:37 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20939' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20938' 14/04/2023 02:18:37 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791254711644' AND id_product != '20939' AND ean13 != '' 14/04/2023 02:18:37 pm >> UPDATE ps_product SET id_supplier = '', reference = '6/4', ean13 = '9791254711644', date_upd = NOW() WHERE id_product = '20939' 14/04/2023 02:18:37 pm >> UPDATE ps_product_lang SET name = 'REGOLA DI FRANCESCO SPIEGATA - G. BUFFON', description = '' WHERE id_product = '20939' 14/04/2023 02:18:37 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '14' WHERE id_product = '20939' 14/04/2023 02:18:37 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '14', id_tax_rules_group = '4', id_category_default = '259', id_argoment_default = '41', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20939' 14/04/2023 02:18:37 pm >> DELETE FROM ps_specific_price WHERE id_product = '20939' 14/04/2023 02:18:38 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '20939' 14/04/2023 02:18:38 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20940' , '1' , '' , 'nuovo-prodotto' ) 14/04/2023 02:18:38 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '20940' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20939' 14/04/2023 02:18:38 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20940' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20939' 14/04/2023 02:19:43 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791259620248' AND id_product != '20940' AND ean13 != '' 14/04/2023 02:19:43 pm >> UPDATE ps_product SET id_supplier = '', reference = '7/5', ean13 = '9791259620248', date_upd = NOW() WHERE id_product = '20940' 14/04/2023 02:19:43 pm >> UPDATE ps_product_lang SET name = 'PAPA MINISTERO E MISSIONE - G.L. MULLER', description = '' WHERE id_product = '20940' 14/04/2023 02:19:43 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '26' WHERE id_product = '20940' 14/04/2023 02:19:44 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '26', id_tax_rules_group = '4', id_category_default = '143', 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 = '20940' 14/04/2023 02:19:44 pm >> DELETE FROM ps_specific_price WHERE id_product = '20940' 14/04/2023 02:19:46 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '20940' 14/04/2023 02:19:46 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20941' , '1' , '' , 'nuovo-prodotto' ) 14/04/2023 02:19:46 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '20941' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20940' 14/04/2023 02:19:46 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20941' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20940' 14/04/2023 02:20:17 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791259623836' AND id_product != '20941' AND ean13 != '' 14/04/2023 02:20:17 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9791259623836', date_upd = NOW() WHERE id_product = '20941' 14/04/2023 02:20:17 pm >> UPDATE ps_product_lang SET name = 'PASSIONE DI GESU\' - E. BERNARDI', description = '' WHERE id_product = '20941' 14/04/2023 02:20:17 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '18' WHERE id_product = '20941' 14/04/2023 02:20:17 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '18', id_tax_rules_group = '4', id_category_default = '143', 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 = '20941' 14/04/2023 02:20:17 pm >> DELETE FROM ps_specific_price WHERE id_product = '20941' 14/04/2023 02:20:19 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '20941' 14/04/2023 02:20:19 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20942' , '1' , '' , 'nuovo-prodotto' ) 14/04/2023 02:20:19 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '20942' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20941' 14/04/2023 02:20:19 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20942' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20941' 14/04/2023 02:22:06 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '906261' , '2023-04-12' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '83.00' , '83.00' , NOW() , NOW() ) 14/04/2023 02:22:06 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 = '82814' 14/04/2023 02:22:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '82814' 14/04/2023 02:22:06 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 ( '82814' , '20939' , 'REGOLA DI FRANCESCO SPIEGATA - G. BUFFON' , '1' , '1' , '4' , '14.00' , '14' , '0' , '0' , '14.00' ) 14/04/2023 02:22:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20939' AND id_supplier = '109' 14/04/2023 02:22:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20939' , '109' , '1' ) 14/04/2023 02:22:06 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 ( '82814' , '20941' , 'PASSIONE DI GESU - E. BERNARDI' , '1' , '1' , '4' , '18.00' , '18' , '0' , '0' , '18.00' ) 14/04/2023 02:22:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20941' AND id_supplier = '109' 14/04/2023 02:22:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20941' , '109' , '1' ) 14/04/2023 02:22:06 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 ( '82814' , '20940' , 'PAPA MINISTERO E MISSIONE - G.L. MULLER' , '1' , '1' , '4' , '26.00' , '26' , '0' , '0' , '26.00' ) 14/04/2023 02:22:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20940' AND id_supplier = '109' 14/04/2023 02:22:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20940' , '109' , '1' ) 14/04/2023 02:22:06 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 ( '82814' , '20938' , 'TU SEI UNA PROMESSA' , '1' , '1' , '4' , '16.00' , '16' , '0' , '0' , '16.00' ) 14/04/2023 02:22:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20938' AND id_supplier = '109' 14/04/2023 02:22:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20938' , '109' , '1' ) 14/04/2023 02:22:06 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 ( '82814' , '20937' , 'STORIE #NOFILTER' , '1' , '1' , '4' , '9.00' , '9' , '0' , '0' , '9.00' ) 14/04/2023 02:22:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20937' AND id_supplier = '109' 14/04/2023 02:22:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20937' , '109' , '1' ) 14/04/2023 02:25:02 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892223059' AND id_product != '20942' AND ean13 != '' 14/04/2023 02:25:02 pm >> UPDATE ps_product SET id_supplier = '', reference = '5/2', ean13 = '9788892223059', date_upd = NOW() WHERE id_product = '20942' 14/04/2023 02:25:02 pm >> UPDATE ps_product_lang SET name = 'BIBBIA RACCONTATA AI PICCOLI', description = '' WHERE id_product = '20942' 14/04/2023 02:25:02 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '14.9' WHERE id_product = '20942' 14/04/2023 02:25:03 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '14.9', id_tax_rules_group = '4', id_category_default = '30', 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 = '20942' 14/04/2023 02:25:03 pm >> DELETE FROM ps_specific_price WHERE id_product = '20942' 14/04/2023 02:25:03 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '20942' 14/04/2023 02:25:04 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20943' , '1' , '' , 'nuovo-prodotto' ) 14/04/2023 02:25:04 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '20943' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20942' 14/04/2023 02:25:04 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20943' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20942' 14/04/2023 02:25:31 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892213869' AND id_product != '16704' AND ean13 != '' 14/04/2023 02:25:32 pm >> UPDATE ps_product SET id_supplier = '7', reference = '5/2', ean13 = '9788892213869', date_upd = NOW() WHERE id_product = '16704' 14/04/2023 02:25:32 pm >> UPDATE ps_product_lang SET name = 'BIBBIA RACCONTATA AI RAGAZZI', description = '' WHERE id_product = '16704' 14/04/2023 02:25:32 pm >> UPDATE ps_product SET wholesale_price = '9.10', on_sale = '0', price = '16' WHERE id_product = '16704' 14/04/2023 02:25:32 pm >> UPDATE ps_product_shop SET wholesale_price = '9.10', price = '16', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '40', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '16704' 14/04/2023 02:25:32 pm >> DELETE FROM ps_specific_price WHERE id_product = '16704' 14/04/2023 02:26:39 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831551977' AND id_product != '20943' AND ean13 != '' 14/04/2023 02:26:39 pm >> UPDATE ps_product SET id_supplier = '', reference = '5/2', ean13 = '9788831551977', date_upd = NOW() WHERE id_product = '20943' 14/04/2023 02:26:39 pm >> UPDATE ps_product_lang SET name = 'GRANDE BIBBIA DEI PICCOLI', description = '' WHERE id_product = '20943' 14/04/2023 02:26:39 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '11.9' WHERE id_product = '20943' 14/04/2023 02:26:39 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '11.9', id_tax_rules_group = '4', id_category_default = '30', 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 = '20943' 14/04/2023 02:26:39 pm >> DELETE FROM ps_specific_price WHERE id_product = '20943' 14/04/2023 02:26:40 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '20943' 14/04/2023 02:26:40 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20944' , '1' , '' , 'nuovo-prodotto' ) 14/04/2023 02:26:40 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '20944' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20943' 14/04/2023 02:26:40 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20944' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20943' 14/04/2023 02:27:28 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831526227' AND id_product != '20944' AND ean13 != '' 14/04/2023 02:27:28 pm >> UPDATE ps_product SET id_supplier = '', reference = '5/2', ean13 = '9788831526227', date_upd = NOW() WHERE id_product = '20944' 14/04/2023 02:27:28 pm >> UPDATE ps_product_lang SET name = 'BIBBIA DEI RAGAZZI', description = '' WHERE id_product = '20944' 14/04/2023 02:27:28 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '9.5' WHERE id_product = '20944' 14/04/2023 02:27:28 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '9.5', id_tax_rules_group = '4', id_category_default = '27', id_argoment_default = '40', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20944' 14/04/2023 02:27:28 pm >> DELETE FROM ps_specific_price WHERE id_product = '20944' 14/04/2023 02:27:30 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '20944' 14/04/2023 02:27:30 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20945' , '1' , '' , 'nuovo-prodotto' ) 14/04/2023 02:27:30 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '20945' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20944' 14/04/2023 02:27:30 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20945' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20944' 14/04/2023 02:28:25 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831552110' AND id_product != '20945' AND ean13 != '' 14/04/2023 02:28:25 pm >> UPDATE ps_product SET id_supplier = '', reference = '5/2', ean13 = '9788831552110', date_upd = NOW() WHERE id_product = '20945' 14/04/2023 02:28:25 pm >> UPDATE ps_product_lang SET name = 'MIA BIBBIA', description = '' WHERE id_product = '20945' 14/04/2023 02:28:25 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '6.9' WHERE id_product = '20945' 14/04/2023 02:28:25 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '6.9', id_tax_rules_group = '4', id_category_default = '27', id_argoment_default = '40', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20945' 14/04/2023 02:28:25 pm >> DELETE FROM ps_specific_price WHERE id_product = '20945' 14/04/2023 02:28:25 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '20945' 14/04/2023 02:28:26 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20946' , '1' , '' , 'nuovo-prodotto' ) 14/04/2023 02:28:26 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '20946' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20945' 14/04/2023 02:28:26 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20946' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20945' 14/04/2023 02:30:02 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788867571307' AND id_product != '20946' AND ean13 != '' 14/04/2023 02:30:02 pm >> UPDATE ps_product SET id_supplier = '', reference = '5/2', ean13 = '9788867571307', date_upd = NOW() WHERE id_product = '20946' 14/04/2023 02:30:02 pm >> UPDATE ps_product_lang SET name = 'MIE PRIME STORIE DELLA BIBBIA', description = '' WHERE id_product = '20946' 14/04/2023 02:30:02 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '12.9' WHERE id_product = '20946' 14/04/2023 02:30:02 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '12.9', id_tax_rules_group = '4', id_category_default = '51', 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 = '20946' 14/04/2023 02:30:02 pm >> DELETE FROM ps_specific_price WHERE id_product = '20946' 14/04/2023 02:30:03 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '20946' 14/04/2023 02:30:03 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20947' , '1' , '' , 'nuovo-prodotto' ) 14/04/2023 02:30:03 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '20947' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20946' 14/04/2023 02:30:03 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20947' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20946' 14/04/2023 02:31:28 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788867571796' AND id_product != '20947' AND ean13 != '' 14/04/2023 02:31:28 pm >> UPDATE ps_product SET id_supplier = '', reference = '5/2', ean13 = '9788867571796', date_upd = NOW() WHERE id_product = '20947' 14/04/2023 02:31:28 pm >> UPDATE ps_product_lang SET name = 'MIA BIBBIA DELLA BUONA NOTTE', description = '' WHERE id_product = '20947' 14/04/2023 02:31:28 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '9.9' WHERE id_product = '20947' 14/04/2023 02:31:28 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '9.9', id_tax_rules_group = '4', id_category_default = '51', 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 = '20947' 14/04/2023 02:31:28 pm >> DELETE FROM ps_specific_price WHERE id_product = '20947' 14/04/2023 02:31:29 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '20947' 14/04/2023 02:31:29 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20948' , '1' , '' , 'nuovo-prodotto' ) 14/04/2023 02:31:29 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '20948' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20947' 14/04/2023 02:31:29 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20948' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20947' 14/04/2023 02:32:23 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801066548' AND id_product != '20948' AND ean13 != '' 14/04/2023 02:32:23 pm >> UPDATE ps_product SET id_supplier = '', reference = '5/2', ean13 = '9788801066548', date_upd = NOW() WHERE id_product = '20948' 14/04/2023 02:32:23 pm >> UPDATE ps_product_lang SET name = 'MIA PRIMA GRANDE BIBBIA', description = '' WHERE id_product = '20948' 14/04/2023 02:32:23 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '9' WHERE id_product = '20948' 14/04/2023 02:32:23 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '9', id_tax_rules_group = '4', id_category_default = '19', 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 = '20948' 14/04/2023 02:32:23 pm >> DELETE FROM ps_specific_price WHERE id_product = '20948' 14/04/2023 02:32:30 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '20948' 14/04/2023 02:32:30 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20949' , '1' , '' , 'nuovo-prodotto' ) 14/04/2023 02:32:30 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '20949' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20948' 14/04/2023 02:32:30 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20949' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20948' 14/04/2023 02:35:42 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791281253452' AND id_product != '20949' AND ean13 != '' 14/04/2023 02:35:42 pm >> UPDATE ps_product SET id_supplier = '', reference = 'GONDOLA 2', ean13 = '9791281253452', date_upd = NOW() WHERE id_product = '20949' 14/04/2023 02:35:42 pm >> UPDATE ps_product_lang SET name = 'MARIA OMELIE E DISCORSI SCELTI - BENEDETTO XVI', description = '' WHERE id_product = '20949' 14/04/2023 02:35:42 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '15' WHERE id_product = '20949' 14/04/2023 02:35:42 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '15', id_tax_rules_group = '4', id_category_default = '518', id_argoment_default = '78', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20949' 14/04/2023 02:35:42 pm >> DELETE FROM ps_specific_price WHERE id_product = '20949' 14/04/2023 02:35:43 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '20949' 14/04/2023 02:35:43 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20950' , '1' , '' , 'nuovo-prodotto' ) 14/04/2023 02:35:43 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '20950' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20949' 14/04/2023 02:35:43 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20950' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20949' 14/04/2023 02:36:16 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '628517' , '2023-04-12' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '5.22' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '181.43' , '181.43' , NOW() , NOW() ) 14/04/2023 02:36:16 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 = '82815' 14/04/2023 02:36:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '82815' 14/04/2023 02:36:16 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 ( '82815' , '16884' , 'ARTE DI GUARIRE - F. ROSINI' , '1' , '1' , '4' , '16.00' , '16' , '0' , '33' , '10.7200' ) 14/04/2023 02:36:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16884' AND id_supplier = '7' 14/04/2023 02:36:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16884' , '7' , '1' ) 14/04/2023 02:36:16 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 ( '82815' , '20942' , 'BIBBIA RACCONTATA AI PICCOLI' , '1' , '1' , '4' , '14.90' , '14.9' , '0' , '35' , '9.6850' ) 14/04/2023 02:36:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20942' AND id_supplier = '7' 14/04/2023 02:36:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20942' , '7' , '1' ) 14/04/2023 02:36:16 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 ( '82815' , '16704' , 'BIBBIA RACCONTATA AI RAGAZZI' , '1' , '1' , '4' , '16.00' , '16' , '0' , '35' , '10.4000' ) 14/04/2023 02:36:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16704' AND id_supplier = '7' 14/04/2023 02:36:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16704' , '7' , '1' ) 14/04/2023 02:36:16 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 ( '82815' , '15563' , 'MIA PRIMA BIBBIA' , '1' , '1' , '4' , '14.00' , '14' , '0' , '35' , '9.1000' ) 14/04/2023 02:36:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15563' AND id_supplier = '7' 14/04/2023 02:36:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15563' , '7' , '1' ) 14/04/2023 02:36:16 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 ( '82815' , '20943' , 'GRANDE BIBBIA DEI PICCOLI' , '1' , '1' , '4' , '11.90' , '11.9' , '0' , '35' , '7.7350' ) 14/04/2023 02:36:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20943' AND id_supplier = '7' 14/04/2023 02:36:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20943' , '7' , '1' ) 14/04/2023 02:36:16 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 ( '82815' , '20944' , 'BIBBIA DEI RAGAZZI' , '1' , '1' , '4' , '9.50' , '9.5' , '0' , '35' , '6.1750' ) 14/04/2023 02:36:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20944' AND id_supplier = '7' 14/04/2023 02:36:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20944' , '7' , '1' ) 14/04/2023 02:36:16 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 ( '82815' , '20945' , 'MIA BIBBIA' , '1' , '1' , '4' , '6.90' , '6.9' , '0' , '35' , '4.4850' ) 14/04/2023 02:36:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20945' AND id_supplier = '7' 14/04/2023 02:36:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20945' , '7' , '1' ) 14/04/2023 02:36:16 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 ( '82815' , '20946' , 'MIE PRIME STORIE DELLA BIBBIA' , '1' , '1' , '4' , '12.90' , '12.9' , '0' , '30' , '9.0300' ) 14/04/2023 02:36:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20946' AND id_supplier = '7' 14/04/2023 02:36:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20946' , '7' , '1' ) 14/04/2023 02:36:16 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 ( '82815' , '20947' , 'MIA BIBBIA DELLA BUONA NOTTE' , '1' , '1' , '4' , '9.90' , '9.9' , '0' , '30' , '6.9300' ) 14/04/2023 02:36:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20947' AND id_supplier = '7' 14/04/2023 02:36:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20947' , '7' , '1' ) 14/04/2023 02:36:16 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 ( '82815' , '20948' , 'MIA PRIMA GRANDE BIBBIA' , '1' , '1' , '4' , '9.00' , '9' , '0' , '35' , '5.8500' ) 14/04/2023 02:36:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20948' AND id_supplier = '7' 14/04/2023 02:36:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20948' , '7' , '1' ) 14/04/2023 02:36:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82815' , '20817' , 'FACCIA A FACCIA CON GESU - D. RUOTOLO' , '1' , '1' , '4' , '16.00' , '16' , '0' , '30' , '11.2000' ) 14/04/2023 02:36:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20817' AND id_supplier = '7' 14/04/2023 02:36:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20817' , '7' , '1' ) 14/04/2023 02:36:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82815' , '20819' , 'PREGARE ALLA SCUOLA DI GRANDI MAESTRI - E. BOLIS' , '1' , '1' , '4' , '15.00' , '15' , '0' , '30' , '10.5000' ) 14/04/2023 02:36:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20819' AND id_supplier = '7' 14/04/2023 02:36:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20819' , '7' , '1' ) 14/04/2023 02:36:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82815' , '20815' , 'FRATE FRANCESCO - R. MURANO' , '1' , '1' , '4' , '19.00' , '19' , '0' , '30' , '13.3000' ) 14/04/2023 02:36:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20815' AND id_supplier = '7' 14/04/2023 02:36:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20815' , '7' , '1' ) 14/04/2023 02:36:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82815' , '20886' , 'VIAGGIO NEL CIELO DELLANIMA CON TERESA DAVILA - R. TAVELLI' , '2' , '2' , '4' , '17.00' , '17' , '0' , '30' , '23.8000' ) 14/04/2023 02:36:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20886' AND id_supplier = '7' 14/04/2023 02:36:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20886' , '7' , '1' ) 14/04/2023 02:36:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82815' , '20530' , 'ULTIME PAROLE - TERESA DI GESU BAMBINO' , '1' , '1' , '4' , '20.00' , '20' , '0' , '33' , '13.4000' ) 14/04/2023 02:36:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20530' AND id_supplier = '7' 14/04/2023 02:36:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20530' , '7' , '1' ) 14/04/2023 02:36:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82815' , '20801' , 'PREGHIERA RESPIRO DELLANIMA - PAPA FRANCESCO' , '1' , '1' , '4' , '20.00' , '20' , '0' , '33' , '13.4000' ) 14/04/2023 02:36:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20801' AND id_supplier = '7' 14/04/2023 02:36:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20801' , '7' , '1' ) 14/04/2023 02:36:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82815' , '20949' , 'MARIA OMELIE E DISCORSI SCELTI - BENEDETTO XVI' , '1' , '1' , '4' , '15.00' , '15' , '0' , '30' , '10.5000' ) 14/04/2023 02:36:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20949' AND id_supplier = '7' 14/04/2023 02:36:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20949' , '7' , '1' ) 14/04/2023 02:42: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 ( '33' , '2106/00' , '2023-04-12' , '00' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , 'RIENTRO FUORI CATALOGO' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1071.05' , '1071.05' , NOW() , NOW() ) 14/04/2023 02:42: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 = '82816' 14/04/2023 02:42:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '82816' 14/04/2023 02:42: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 ( '82816' , '8254' , 'PREGHIAMO CON MARIA' , '7' , '7' , '4' , '0.65' , '0.65' , '0' , '0' , '4.5500' ) 14/04/2023 02:42: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 ( '82816' , '8243' , 'PREGARE OGNI GIORNO' , '3' , '3' , '4' , '1.00' , '1' , '0' , '0' , '3.0000' ) 14/04/2023 02:42: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 ( '82816' , '8710' , 'QUANDO PREGATE DITE...' , '95' , '95' , '4' , '2.40' , '2.4' , '0' , '0' , '228.0000' ) 14/04/2023 02:42: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 ( '82816' , '14030' , 'PADRE NOSTRO' , '276' , '276' , '4' , '3.00' , '3' , '0' , '0' , '828.0000' ) 14/04/2023 02:42: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 ( '82816' , '11308' , 'VIA CRUCIS ' , '5' , '5' , '4' , '1.50' , '1.5' , '0' , '0' , '7.5000' ) 14/04/2023 03:04:28 pm >> SELECT document_num FROM ps_document WHERE document_num = '54/A' AND id_document != '59768' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-07-23') 14/04/2023 03:04:28 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '54/A', document_date = '2022-07-23', document_letter = 'A', id_customer = '230', id_supplier = '', id_address = '4668969', address1 = 'VIA G. NICOTERA, 66 84080 PELLEZZANO', address2 = '', note = 'ACCONTO € 400', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '485.00', price_tax_excluded = '485.00', date_upd = NOW() WHERE id_document = '59768' 14/04/2023 03:04:28 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 = '59768' 14/04/2023 03:04:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '59768' 14/04/2023 03:04:28 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 ( '59768' , '0' , 'bambino + culla terracot 450+35' , '1' , '-1' , '0' , '485.0000' , '485' , '0' , '0' , '485.00' ) 14/04/2023 03:05:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '48/A' AND id_document != '82684' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-04-05') 14/04/2023 03:05:31 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '48/A', document_date = '2023-04-05', document_letter = 'A', id_customer = '230', id_supplier = '', id_address = '4668969', address1 = 'VIA G. NICOTERA, 66 84080 PELLEZZANO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '300.00', price_tax_excluded = '245.90', date_upd = NOW() WHERE id_document = '82684' 14/04/2023 03:05: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 = '82684' 14/04/2023 03:05:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '82684' 14/04/2023 03:05: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 ( '82684' , '16514' , 'CROCIFISSO 105X60 - 1015' , '1' , '-1' , '1' , '300.0000' , '245.90163934426' , '22' , '0' , '300.00' ) 14/04/2023 03:09:30 pm >> SELECT document_num FROM ps_document WHERE document_num = '890' AND id_document != '82360' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-18') 14/04/2023 03:09:30 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '890', document_date = '2023-03-18', 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 = '20.00', price_tax_excluded = '17.30', date_upd = NOW() WHERE id_document = '82360' 14/04/2023 03:09: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 = '82360' 14/04/2023 03:09:30 pm >> DELETE FROM ps_document_detail WHERE id_document = '82360' 14/04/2023 03:09: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 ( '82360' , '15334' , 'CANDELA VOTIVA 20X40' , '5' , '-5' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '5.00' ) 14/04/2023 03:09: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 ( '82360' , '5461' , 'IO SONO IL PANE DELLA VITA' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '0' , '2.00' ) 14/04/2023 03:09: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 ( '82360' , '13840' , 'NONNI SONO UN TESORO' , '2' , '-2' , '4' , '1.5000' , '1.5' , '0' , '0' , '3.00' ) 14/04/2023 03:09: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 ( '82360' , '16796' , 'LUMINO 5F BIANCO' , '50' , '-50' , '1' , '0.20' , '0.16393442622951' , '22' , '0' , '10.00' ) 14/04/2023 03:10:10 pm >> SELECT document_num FROM ps_document WHERE document_num = '1255' AND id_document != '82813' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-14') 14/04/2023 03:10:10 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1255', document_date = '2023-04-14', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '23.00', price_tax_excluded = '23.00', date_upd = NOW() WHERE id_document = '82813' 14/04/2023 03:10:10 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82813' 14/04/2023 03:10:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '82813' 14/04/2023 03:10:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82813' , '20639' , 'CATECHISMO DELLA VITA SPIRITUALE - R. SARAH' , '1' , '-1' , '4' , '23' , '23' , '0' , '0' , '23.00' ) 14/04/2023 03:13:49 pm >> SELECT document_num FROM ps_document WHERE document_num = '900' AND id_document != '82373' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-20') 14/04/2023 03:13:49 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '900', document_date = '2023-03-20', 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 = '55.00', price_tax_excluded = '45.08', date_upd = NOW() WHERE id_document = '82373' 14/04/2023 03:13:49 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82373' 14/04/2023 03:13:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '82373' 14/04/2023 03:13:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82373' , '17787' , 'BRACCIALE SIMILPELLE CROCE - SL301-R' , '1' , '-1' , '1' , '26.00' , '21.311475409836' , '22' , '0' , '26.00' ) 14/04/2023 03:13:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82373' , '13953' , 'BRACCIALE IN CUOIO PADRE NOSTRO' , '1' , '-1' , '1' , '22.00' , '18.032786885246' , '22' , '0' , '22.00' ) 14/04/2023 03:13:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82373' , '7911' , 'PERGAMENE - 1A COMUNIONE MOD. B' , '14' , '-14' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '7.00' ) 14/04/2023 03:24:30 pm >> SELECT document_num FROM ps_document WHERE document_num = '1256' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-14') 14/04/2023 03:24: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' , '1256' , '2023-04-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '55.00' , '45.08' , NOW() , NOW() ) 14/04/2023 03:24: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 = '82817' 14/04/2023 03:24:30 pm >> DELETE FROM ps_document_detail WHERE id_document = '82817' 14/04/2023 03:24: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 ( '82817' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '55' , '45.081967213115' , '22' , '0' , '55.00' ) 14/04/2023 03:26:23 pm >> SELECT document_num FROM ps_document WHERE document_num = '1257' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-14') 14/04/2023 03:26:23 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1257' , '2023-04-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.10' , '2.10' , NOW() , NOW() ) 14/04/2023 03:26:23 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82818' 14/04/2023 03:26:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '82818' 14/04/2023 03:26:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82818' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '3' , '-3' , '4' , '0.70' , '0.7' , '0' , '0' , '2.10' ) 14/04/2023 03:48:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '1258' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-14') 14/04/2023 03:48:46 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' , '1258' , '2023-04-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '23.75' , '23.75' , NOW() , NOW() ) 14/04/2023 03:48:46 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 = '82819' 14/04/2023 03:48:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '82819' 14/04/2023 03:48:46 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 ( '82819' , '20795' , 'SULLA TUA PAROLA MAG/GIU 2023 - 516' , '5' , '-5' , '4' , '5.00' , '5' , '0' , '5' , '23.75' ) 14/04/2023 03:48:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '1259' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-14') 14/04/2023 03:48:59 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1259' , '2023-04-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '25.20' , '20.66' , NOW() , NOW() ) 14/04/2023 03:48:59 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82820' 14/04/2023 03:48:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '82820' 14/04/2023 03:48:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82820' , '7202' , 'ARTICOLI RELIGIOSI' , '12' , '-12' , '1' , '2.1' , '1.7213114754098' , '22' , '0' , '25.20' ) 14/04/2023 05:55:23 pm >> SELECT document_num FROM ps_document WHERE document_num = '830' AND id_document != '82284' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-13') 14/04/2023 05:55:23 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '830', document_date = '2023-03-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 = '390.00', price_tax_excluded = '341.00', date_upd = NOW() WHERE id_document = '82284' 14/04/2023 05:55:23 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82284' 14/04/2023 05:55:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '82284' 14/04/2023 05:55:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82284' , '15331' , 'CERO PASQUALE 80X120 - RILIEVO IN CERA' , '1' , '-1' , '1' , '135.0000' , '110.65573770492' , '22' , '0' , '135.00' ) 14/04/2023 05:55:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82284' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '10' , '-10' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '35.00' ) 14/04/2023 05:55:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82284' , '16689' , 'OSTIA PAN DI CENA mm80' , '10' , '-10' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '20.00' ) 14/04/2023 05:55:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82284' , '11805' , 'TECA IHS - 823' , '1' , '-1' , '1' , '25.0000' , '20.491803278689' , '22' , '0' , '25.00' ) 14/04/2023 05:55:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82284' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '5' , '-5' , '1' , '20.0000' , '16.393442622951' , '22' , '0' , '100.00' ) 14/04/2023 05:55:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82284' , '20719' , 'CORONA DELL’ADDOLORATA' , '50' , '-50' , '4' , '1.5' , '1.5' , '0' , '0' , '75.00' ) 14/04/2023 05:55:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '910' AND id_document != '82387' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-21') 14/04/2023 05:55:55 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '910', document_date = '2023-03-21', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '250.00', price_tax_excluded = '213.57', date_upd = NOW() WHERE id_document = '82387' 14/04/2023 05:55:55 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82387' 14/04/2023 05:55:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '82387' 14/04/2023 05:55:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82387' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '56.40' ) 14/04/2023 05:55:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82387' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '1' , '-1' , '1' , '12.6000' , '10.327868852459' , '22' , '0' , '12.60' ) 14/04/2023 05:55:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82387' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 14/04/2023 05:55:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82387' , '5229' , 'INCENSO PONTIFICAL' , '1' , '-1' , '1' , '24.0000' , '19.672131147541' , '22' , '0' , '24.00' ) 14/04/2023 05:55:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82387' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3.3000' , '2.7049180327869' , '22' , '0' , '99.00' ) 14/04/2023 05:55:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82387' , '20719' , 'CORONA DELL’ADDOLORATA' , '32' , '-32' , '4' , '1.5' , '1.5' , '0' , '0' , '48.00' ) 14/04/2023 05:56:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '1060' AND id_document != '82566' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-30') 14/04/2023 05:56:15 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1060', document_date = '2023-03-30', 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 = '45.00', price_tax_excluded = '45.00', date_upd = NOW() WHERE id_document = '82566' 14/04/2023 05:56:15 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82566' 14/04/2023 05:56:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '82566' 14/04/2023 05:56:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82566' , '20719' , 'CORONA DELL’ADDOLORATA' , '30' , '-30' , '4' , '1.5' , '1.5' , '0' , '0' , '45.00' ) 14/04/2023 05:58:24 pm >> SELECT document_num FROM ps_document WHERE document_num = '1260' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-14') 14/04/2023 05:58:24 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1260' , '2023-04-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.50' , '3.69' , NOW() , NOW() ) 14/04/2023 05:58:24 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82821' 14/04/2023 05:58:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '82821' 14/04/2023 05:58:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82821' , '13322' , 'IMMAGINI 70X100 GESU\' MISERICORDIOSO' , '1' , '-1' , '1' , '4.5' , '3.6885245901639' , '22' , '0' , '4.50' ) 14/04/2023 06:25:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '1261' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-14') 14/04/2023 06:25:26 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1261' , '2023-04-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.50' , '7.79' , NOW() , NOW() ) 14/04/2023 06:25:26 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82822' 14/04/2023 06:25:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '82822' 14/04/2023 06:25:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82822' , '1375' , 'BRUCIAINCENSI LEGNO - BRUL' , '1' , '-1' , '1' , '9.50' , '7.7868852459016' , '22' , '0' , '9.50' ) 14/04/2023 06:53:49 pm >> SELECT document_num FROM ps_document WHERE document_num = '1262' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-14') 14/04/2023 06:53:49 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1262' , '2023-04-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.40' , '11.40' , NOW() , NOW() ) 14/04/2023 06:53:49 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82823' 14/04/2023 06:53:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '82823' 14/04/2023 06:53:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82823' , '20864' , 'MESSALINO QUOTIDIANO - MAG/GIU/LUG 23' , '2' , '-2' , '4' , '6.00' , '6' , '0' , '5' , '11.40' )