05/09/2023 09:59:50 am >> SELECT document_num FROM ps_document WHERE document_num = '2734' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-05') 05/09/2023 09:59:50 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' , '2734' , '2023-09-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.00' , '10.00' , NOW() , NOW() ) 05/09/2023 09:59:50 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 = '87186' 05/09/2023 09:59:50 am >> DELETE FROM ps_document_detail WHERE id_document = '87186' 05/09/2023 09:59:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87186' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '10' , '10' , '0' , '0' , '10.00' ) 05/09/2023 10:45:46 am >> SELECT document_num FROM ps_document WHERE document_num = '2735' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-05') 05/09/2023 10:45: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' , '2735' , '2023-09-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '70.00' , '57.38' , NOW() , NOW() ) 05/09/2023 10:45: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 = '87187' 05/09/2023 10:45:46 am >> DELETE FROM ps_document_detail WHERE id_document = '87187' 05/09/2023 10:45: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 ( '87187' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '70' , '57.377049180328' , '22' , '0' , '70.00' ) 05/09/2023 10:48:39 am >> SELECT document_num FROM ps_document WHERE document_num = '2736' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-05') 05/09/2023 10:48:39 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2736' , '2023-09-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '33.25' , '33.25' , NOW() , NOW() ) 05/09/2023 10:48:39 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87188' 05/09/2023 10:48:39 am >> DELETE FROM ps_document_detail WHERE id_document = '87188' 05/09/2023 10:48:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87188' , '5891' , 'LITURGIA DELLE ORE I - FRANCESCANA' , '1' , '-1' , '4' , '35.00' , '35' , '0' , '5' , '33.25' ) 05/09/2023 10:53:29 am >> SELECT document_num FROM ps_document WHERE document_num = '2737' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-05') 05/09/2023 10:53:29 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' , '2737' , '2023-09-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.75' , '9.75' , NOW() , NOW() ) 05/09/2023 10:53:29 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87189' 05/09/2023 10:53:29 am >> DELETE FROM ps_document_detail WHERE id_document = '87189' 05/09/2023 10:53:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87189' , '13780' , 'RISCOPRIAMO LA BELLEZZA DEL BATTESIMO' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 05/09/2023 10:53:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87189' , '19138' , 'ATTO DI ABBANDONO - D. D. RUOTOLO' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 05/09/2023 10:53:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87189' , '21479' , 'PENSIERI E PREGHIERE DI DON DOLINDO - 8517' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 05/09/2023 10:53:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87189' , '5190' , 'IN ONORE DI SAN GIUSEPPE - 8190' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 05/09/2023 11:07:28 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 05/09/2023 11:07:28 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21507' , '1' , '' , 'nuovo-prodotto' ) 05/09/2023 11:07:28 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '21507' , '1' , '1' , '2' , NOW() , NOW() ) 05/09/2023 11:07:28 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '21507' , '0' , '1' , '0' , '0' ) 05/09/2023 11:08:17 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791280192301' AND id_product != '21507' AND ean13 != '' 05/09/2023 11:08:17 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9791280192301', date_upd = NOW() WHERE id_product = '21507' 05/09/2023 11:08:17 am >> UPDATE ps_product_lang SET name = 'LITURGIA DELLE ORE VOL. I N.E.', description = '' WHERE id_product = '21507' 05/09/2023 11:08:17 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '35' WHERE id_product = '21507' 05/09/2023 11:08:17 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '35', id_tax_rules_group = '4', id_category_default = '104', 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 = '21507' 05/09/2023 11:08:17 am >> DELETE FROM ps_specific_price WHERE id_product = '21507' 05/09/2023 11:08:27 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791280192301' AND id_product != '21507' AND ean13 != '' 05/09/2023 11:08:27 am >> UPDATE ps_product SET id_supplier = '', reference = '7/4', ean13 = '9791280192301', date_upd = NOW() WHERE id_product = '21507' 05/09/2023 11:08:27 am >> UPDATE ps_product_lang SET name = 'LITURGIA DELLE ORE VOL. I N.E.', description = '' WHERE id_product = '21507' 05/09/2023 11:08:27 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '35' WHERE id_product = '21507' 05/09/2023 11:08:27 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '35', id_tax_rules_group = '4', id_category_default = '104', 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 = '21507' 05/09/2023 11:08:27 am >> DELETE FROM ps_specific_price WHERE id_product = '21507' 05/09/2023 11:08:34 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 = '21507' 05/09/2023 11:08:34 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21508' , '1' , '' , 'nuovo-prodotto' ) 05/09/2023 11:08:34 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 '21508' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21507' 05/09/2023 11:08:34 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21508' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21507' 05/09/2023 11:09:10 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791280192318' AND id_product != '21508' AND ean13 != '' 05/09/2023 11:09:10 am >> UPDATE ps_product SET id_supplier = '', reference = '7/4', ean13 = '9791280192318', date_upd = NOW() WHERE id_product = '21508' 05/09/2023 11:09:10 am >> UPDATE ps_product_lang SET name = 'LITURGIA DELLE ORE VOL. II N.E.', description = '' WHERE id_product = '21508' 05/09/2023 11:09:10 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '35' WHERE id_product = '21508' 05/09/2023 11:09:10 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '35', id_tax_rules_group = '4', id_category_default = '104', 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 = '21508' 05/09/2023 11:09:10 am >> DELETE FROM ps_specific_price WHERE id_product = '21508' 05/09/2023 11:09: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 = '21508' 05/09/2023 11:09:15 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21509' , '1' , '' , 'nuovo-prodotto' ) 05/09/2023 11:09:16 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 '21509' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21508' 05/09/2023 11:09:16 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21509' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21508' 05/09/2023 11:09:50 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791280192325' AND id_product != '21509' AND ean13 != '' 05/09/2023 11:09:50 am >> UPDATE ps_product SET id_supplier = '', reference = '7/4', ean13 = '9791280192325', date_upd = NOW() WHERE id_product = '21509' 05/09/2023 11:09:50 am >> UPDATE ps_product_lang SET name = 'LITURGIA DELLE ORE VOL. IV N.E.', description = '' WHERE id_product = '21509' 05/09/2023 11:09:50 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '35' WHERE id_product = '21509' 05/09/2023 11:09:51 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '35', id_tax_rules_group = '4', id_category_default = '104', 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 = '21509' 05/09/2023 11:09:51 am >> DELETE FROM ps_specific_price WHERE id_product = '21509' 05/09/2023 11:09:51 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 = '21509' 05/09/2023 11:09:51 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21510' , '1' , '' , 'nuovo-prodotto' ) 05/09/2023 11:09:51 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 '21510' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21509' 05/09/2023 11:09:51 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21510' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21509' 05/09/2023 11:12:32 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788826608150' AND id_product != '21510' AND ean13 != '' 05/09/2023 11:12:32 am >> UPDATE ps_product SET id_supplier = '', reference = '6/7', ean13 = '9788826608150', date_upd = NOW() WHERE id_product = '21510' 05/09/2023 11:12:32 am >> UPDATE ps_product_lang SET name = 'CROCIFISSO DI FRANCESCO D\'ASSISI - C. VALENZIANO', description = '' WHERE id_product = '21510' 05/09/2023 11:12:32 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '22' WHERE id_product = '21510' 05/09/2023 11:12:32 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '22', id_tax_rules_group = '4', id_category_default = '104', id_argoment_default = '198', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21510' 05/09/2023 11:12:32 am >> DELETE FROM ps_specific_price WHERE id_product = '21510' 05/09/2023 11:12:33 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 = '21510' 05/09/2023 11:12:33 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21511' , '1' , '' , 'nuovo-prodotto' ) 05/09/2023 11:12:33 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 '21511' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21510' 05/09/2023 11:12:33 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21511' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21510' 05/09/2023 11:14:06 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788826608273' AND id_product != '21511' AND ean13 != '' 05/09/2023 11:14:06 am >> UPDATE ps_product SET id_supplier = '', reference = 'GONDOLA 1', ean13 = '9788826608273', date_upd = NOW() WHERE id_product = '21511' 05/09/2023 11:14:06 am >> UPDATE ps_product_lang SET name = 'INSTRUMENTUM LABORIS - SINODO', description = '' WHERE id_product = '21511' 05/09/2023 11:14:06 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '8' WHERE id_product = '21511' 05/09/2023 11:14:06 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '8', id_tax_rules_group = '4', id_category_default = '104', id_argoment_default = '69', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21511' 05/09/2023 11:14:06 am >> DELETE FROM ps_specific_price WHERE id_product = '21511' 05/09/2023 11:14:07 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 = '21511' 05/09/2023 11:14:07 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21512' , '1' , '' , 'nuovo-prodotto' ) 05/09/2023 11:14:07 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 '21512' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21511' 05/09/2023 11:14:07 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21512' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21511' 05/09/2023 11:15:32 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788826608174' AND id_product != '21512' AND ean13 != '' 05/09/2023 11:15:32 am >> UPDATE ps_product SET id_supplier = '', reference = 'GONDOLA 1', ean13 = '9788826608174', date_upd = NOW() WHERE id_product = '21512' 05/09/2023 11:15:33 am >> UPDATE ps_product_lang SET name = 'VANGELO DI OGNI DOMENICA - MARCO - PAPA FRANCESCO', description = '' WHERE id_product = '21512' 05/09/2023 11:15:33 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '15' WHERE id_product = '21512' 05/09/2023 11:15:33 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '15', id_tax_rules_group = '4', id_category_default = '104', id_argoment_default = '64', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21512' 05/09/2023 11:15:33 am >> DELETE FROM ps_specific_price WHERE id_product = '21512' 05/09/2023 11:15:33 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 = '21512' 05/09/2023 11:15:33 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21513' , '1' , '' , 'nuovo-prodotto' ) 05/09/2023 11:15:33 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 '21513' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21512' 05/09/2023 11:15:33 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21513' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21512' 05/09/2023 11:16:29 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788820976309' AND id_product != '21513' AND ean13 != '' 05/09/2023 11:16:29 am >> UPDATE ps_product SET id_supplier = '', reference = '13/2', ean13 = '9788820976309', date_upd = NOW() WHERE id_product = '21513' 05/09/2023 11:16:29 am >> UPDATE ps_product_lang SET name = 'COMPENDIO DELLA DOTTRINA SOCIALE DELLA CHIESA', description = '' WHERE id_product = '21513' 05/09/2023 11:16:29 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '15' WHERE id_product = '21513' 05/09/2023 11:16:29 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '15', id_tax_rules_group = '4', id_category_default = '104', id_argoment_default = '69', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21513' 05/09/2023 11:16:29 am >> DELETE FROM ps_specific_price WHERE id_product = '21513' 05/09/2023 11:16: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 = '21513' 05/09/2023 11:16:30 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21514' , '1' , '' , 'nuovo-prodotto' ) 05/09/2023 11:16: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 '21514' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21513' 05/09/2023 11:16:30 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21514' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21513' 05/09/2023 11:17:33 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '2023-DL002258' , '2023-09-04' , '' , '0' , '79' , '2686' , 'CITTA\\\' DEL VATICANO 00120 CITTA\\\' DEL VATICANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1790.40' , '1790.40' , NOW() , NOW() ) 05/09/2023 11:17:33 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87190' 05/09/2023 11:17:33 am >> DELETE FROM ps_document_detail WHERE id_document = '87190' 05/09/2023 11:17: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 ( '87190' , '21507' , 'LITURGIA DELLE ORE VOL. I N.E.' , '1' , '1' , '4' , '35.00' , '35' , '0' , '30' , '24.5000' ) 05/09/2023 11:17:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '21507' AND id_supplier = '79' 05/09/2023 11:17:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21507' , '79' , '1' ) 05/09/2023 11:17:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87190' , '21508' , 'LITURGIA DELLE ORE VOL. II N.E.' , '2' , '2' , '4' , '35.00' , '35' , '0' , '30' , '49.0000' ) 05/09/2023 11:17:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '21508' AND id_supplier = '79' 05/09/2023 11:17:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21508' , '79' , '1' ) 05/09/2023 11:17:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87190' , '5889' , 'LITURGIA DELLE ORE - VOL. III - PER SACERDOTI E RELIGIOSI' , '2' , '2' , '4' , '35.00' , '35' , '0' , '30' , '49.0000' ) 05/09/2023 11:17:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '5889' AND id_supplier = '79' 05/09/2023 11:17:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5889' , '79' , '1' ) 05/09/2023 11:17:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87190' , '21509' , 'LITURGIA DELLE ORE VOL. IV N.E.' , '1' , '1' , '4' , '35.00' , '35' , '0' , '30' , '24.5000' ) 05/09/2023 11:17:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '21509' AND id_supplier = '79' 05/09/2023 11:17:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21509' , '79' , '1' ) 05/09/2023 11:17:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87190' , '17862' , 'DALLINFORMATICA AL CIELO C. ACUTIS - N. GORI' , '1' , '1' , '4' , '12.00' , '12' , '0' , '45' , '6.6000' ) 05/09/2023 11:17:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '17862' AND id_supplier = '79' 05/09/2023 11:17:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17862' , '79' , '1' ) 05/09/2023 11:17:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87190' , '17526' , 'PREGHIERE EUCARISTICHE PER CONCELEBRAZIONE N.E.' , '5' , '5' , '4' , '6.00' , '6' , '0' , '30' , '21.0000' ) 05/09/2023 11:17:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '17526' AND id_supplier = '79' 05/09/2023 11:17:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17526' , '79' , '1' ) 05/09/2023 11:17:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87190' , '21510' , 'CROCIFISSO DI FRANCESCO DASSISI - C. VALENZIANO' , '1' , '1' , '4' , '22.00' , '22' , '0' , '45' , '12.1000' ) 05/09/2023 11:17:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '21510' AND id_supplier = '79' 05/09/2023 11:17:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21510' , '79' , '1' ) 05/09/2023 11:17:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87190' , '17329' , 'MESSALE ROMANO DALTARE N.E' , '2' , '2' , '4' , '110.00' , '110' , '0' , '30' , '154.0000' ) 05/09/2023 11:17:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '17329' AND id_supplier = '79' 05/09/2023 11:17:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17329' , '79' , '1' ) 05/09/2023 11:17:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87190' , '5774' , 'LEZIONARIO PER LE CELEBRAZIONI DEI SANTI' , '1' , '1' , '4' , '90.00' , '90' , '0' , '35' , '58.5000' ) 05/09/2023 11:17:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '5774' AND id_supplier = '79' 05/09/2023 11:17:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5774' , '79' , '1' ) 05/09/2023 11:17:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87190' , '21511' , 'INSTRUMENTUM LABORIS - SINODO' , '3' , '3' , '4' , '8.00' , '8' , '0' , '45' , '13.2000' ) 05/09/2023 11:17:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '21511' AND id_supplier = '79' 05/09/2023 11:17:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21511' , '79' , '1' ) 05/09/2023 11:17:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87190' , '13418' , 'AD RESURGENDUM CUM CHRISTO' , '1' , '1' , '4' , '5.00' , '5' , '0' , '45' , '2.7500' ) 05/09/2023 11:17:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '13418' AND id_supplier = '79' 05/09/2023 11:17:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13418' , '79' , '1' ) 05/09/2023 11:17:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87190' , '21512' , 'VANGELO DI OGNI DOMENICA - MARCO - PAPA FRANCESCO' , '1' , '1' , '4' , '15.00' , '15' , '0' , '45' , '8.2500' ) 05/09/2023 11:17:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '21512' AND id_supplier = '79' 05/09/2023 11:17:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21512' , '79' , '1' ) 05/09/2023 11:17:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87190' , '21513' , 'COMPENDIO DELLA DOTTRINA SOCIALE DELLA CHIESA' , '2' , '2' , '4' , '15.00' , '15' , '0' , '35' , '19.5000' ) 05/09/2023 11:17:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '21513' AND id_supplier = '79' 05/09/2023 11:17:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21513' , '79' , '1' ) 05/09/2023 11:17:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87190' , '5444' , 'IO SONO CON VOI - CAT.' , '200' , '200' , '4' , '5.50' , '5.5' , '0' , '30' , '770.0000' ) 05/09/2023 11:17:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '5444' AND id_supplier = '79' 05/09/2023 11:17:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5444' , '79' , '1' ) 05/09/2023 11:17:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87190' , '11193' , 'VENITE CON ME CAT.' , '150' , '150' , '4' , '5.50' , '5.5' , '0' , '30' , '577.5000' ) 05/09/2023 11:17:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '11193' AND id_supplier = '79' 05/09/2023 11:17:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11193' , '79' , '1' ) 05/09/2023 11:36:15 am >> SELECT document_num FROM ps_document WHERE document_num = '2738' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-05') 05/09/2023 11:36:15 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' , '2738' , '2023-09-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '36.50' , '29.92' , NOW() , NOW() ) 05/09/2023 11:36:15 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 = '87191' 05/09/2023 11:36:15 am >> DELETE FROM ps_document_detail WHERE id_document = '87191' 05/09/2023 11:36:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87191' , '19560' , 'PERGAMENA 17X25' , '20' , '-20' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '14.00' ) 05/09/2023 11:36:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87191' , '20027' , 'CANDELA ALTARE 20X500' , '15' , '-15' , '1' , '1.5' , '1.2295081967213' , '22' , '0' , '22.50' ) 05/09/2023 11:38:14 am >> DELETE FROM ps_document WHERE id_document = '86657' 05/09/2023 11:38:14 am >> DELETE FROM ps_document_detail WHERE id_document = '86657' 05/09/2023 11:38:25 am >> SELECT document_num FROM ps_document WHERE document_num = '2739' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-05') 05/09/2023 11:38: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' , '2739' , '2023-09-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '600.00' , '491.80' , NOW() , NOW() ) 05/09/2023 11:38: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 = '87192' 05/09/2023 11:38:25 am >> DELETE FROM ps_document_detail WHERE id_document = '87192' 05/09/2023 11:38: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 ( '87192' , '15680' , 'CAMICE LANA/POL. SFILATURE A MANO' , '1' , '-1' , '1' , '600' , '491.80327868852' , '22' , '0' , '600.00' ) 05/09/2023 12:19:50 pm >> SELECT document_num FROM ps_document WHERE document_num = '2740' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-05') 05/09/2023 12:19:50 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2740' , '2023-09-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '100.00' , '81.97' , NOW() , NOW() ) 05/09/2023 12:19:50 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87193' 05/09/2023 12:19:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '87193' 05/09/2023 12:19:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87193' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8.5' , '6.9672131147541' , '22' , '0' , '51.00' ) 05/09/2023 12:19:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87193' , '780' , 'ASPERGES MAXI CON CUSTODIA - 700' , '1' , '-1' , '1' , '49.00' , '40.16393442623' , '22' , '0' , '49.00' ) 05/09/2023 12:20:06 pm >> SELECT document_num FROM ps_document WHERE document_num = '2741' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-05') 05/09/2023 12:20: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 ( '11' , '2741' , '2023-09-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '89.00' , '72.95' , NOW() , NOW() ) 05/09/2023 12:20: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 = '87194' 05/09/2023 12:20:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '87194' 05/09/2023 12:20:07 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 ( '87194' , '18561' , 'FORMELLA SAGOMATA 26X26 - TENERO ABBRACCIO 1025130' , '1' , '-1' , '1' , '89.00' , '72.950819672131' , '22' , '0' , '89.00' ) 05/09/2023 12:30:34 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400045048' AND id_product != '3115' AND ean13 != '' 05/09/2023 12:30:35 pm >> UPDATE ps_product SET id_supplier = '', reference = '2015', ean13 = '8058400045048', date_upd = NOW() WHERE id_product = '3115' 05/09/2023 12:30:35 pm >> UPDATE ps_product_lang SET name = 'CROCE SAN DAMIANO SOTTILE - 1237', description = '' WHERE id_product = '3115' 05/09/2023 12:30:35 pm >> UPDATE ps_product SET wholesale_price = '0.70', on_sale = '0', price = '1.8032786885245904' WHERE id_product = '3115' 05/09/2023 12:30:35 pm >> UPDATE ps_product_shop SET wholesale_price = '0.70', price = '1.8032786885245904', id_tax_rules_group = '1', id_category_default = '95', 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 = '3115' 05/09/2023 12:30:35 pm >> DELETE FROM ps_specific_price WHERE id_product = '3115' 05/09/2023 04:16:08 pm >> SELECT document_num FROM ps_document WHERE document_num = '2742' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-05') 05/09/2023 04:16:08 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2742' , '2023-09-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.90' , '2.38' , NOW() , NOW() ) 05/09/2023 04:16:08 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87195' 05/09/2023 04:16:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '87195' 05/09/2023 04:16:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87195' , '21155' , 'BRACCIALE TENNIS + MEDAGLIA - 209' , '1' , '-1' , '1' , '2.90' , '2.3770491803279' , '22' , '0' , '2.90' ) 05/09/2023 05:08:52 pm >> SELECT document_num FROM ps_document WHERE document_num = '2743' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-05') 05/09/2023 05:08:52 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2743' , '2023-09-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.00' , '9.84' , NOW() , NOW() ) 05/09/2023 05:08:52 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87196' 05/09/2023 05:08:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '87196' 05/09/2023 05:08:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87196' , '17161' , 'CARBONCINI NERI - CARNE' , '1' , '-1' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '12.00' ) 05/09/2023 05:45:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '2744' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-05') 05/09/2023 05:45:00 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' , '2744' , '2023-09-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '68.00' , '55.74' , NOW() , NOW() ) 05/09/2023 05:45:00 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 = '87197' 05/09/2023 05:45:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '87197' 05/09/2023 05:45:00 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 ( '87197' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '68' , '55.737704918033' , '22' , '0' , '68.00' ) 05/09/2023 06:56:13 pm >> SELECT document_num FROM ps_document WHERE document_num = '2745' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-05') 05/09/2023 06:56:13 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2745' , '2023-09-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.00' , '7.38' , NOW() , NOW() ) 05/09/2023 06:56:13 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87198' 05/09/2023 06:56:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '87198' 05/09/2023 06:56:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87198' , '13392' , 'STATUETTA BOTTIGLIA LOURDES' , '10' , '-10' , '1' , '0.9' , '0.73770491803279' , '22' , '0' , '9.00' ) 05/09/2023 07:00:56 pm >> SELECT document_num FROM ps_document WHERE document_num = '2746' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-05') 05/09/2023 07:00:56 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2746' , '2023-09-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '29.90' , '29.90' , NOW() , NOW() ) 05/09/2023 07:00:56 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87199' 05/09/2023 07:00:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '87199' 05/09/2023 07:00:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87199' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '29.9' , '29.9' , '0' , '0' , '29.90' ) 05/09/2023 07:08:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '2747' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-05') 05/09/2023 07:08:39 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2747' , '2023-09-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.70' , '3.03' , NOW() , NOW() ) 05/09/2023 07:08: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 = '87200' 05/09/2023 07:08:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '87200' 05/09/2023 07:08: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 ( '87200' , '15403' , 'CROCE IN RESINA CM 9 - 3806/G052' , '1' , '-1' , '1' , '3.70' , '3.0327868852459' , '22' , '0' , '3.70' )