27/03/2025 09:02:51 am >> SELECT document_num FROM ps_document WHERE document_num = '990' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-27') 27/03/2025 09:02:51 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '990' , '2025-03-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '170.00' , '139.34' , NOW() , NOW() ) 27/03/2025 09:02:51 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96382' 27/03/2025 09:02:51 am >> DELETE FROM ps_document_detail WHERE id_document = '96382' 27/03/2025 09:02:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96382' , '15210' , 'CERO PASQUALE API 80X120' , '1' , '-1' , '1' , '170' , '139.34426229508' , '22' , '0' , '170.00' ) 27/03/2025 09:33:37 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884048936' AND id_product != '22194' AND ean13 != '' 27/03/2025 09:33:37 am >> UPDATE ps_product SET id_supplier = '38', reference = 'ESPOSITORE SHALOM', ean13 = '9788884048936', date_upd = NOW() WHERE id_product = '22194' 27/03/2025 09:33:37 am >> UPDATE ps_product_lang SET name = 'PREGHIAMO CON I SANTI MARIA GORETTI', description = '' WHERE id_product = '22194' 27/03/2025 09:33:37 am >> UPDATE ps_product SET wholesale_price = '1.80', on_sale = '0', price = '3.0000' WHERE id_product = '22194' 27/03/2025 09:33:37 am >> UPDATE ps_product_shop SET wholesale_price = '1.80', price = '3.0000', id_tax_rules_group = '4', id_category_default = '106', 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 = '22194' 27/03/2025 09:33:37 am >> DELETE FROM ps_specific_price WHERE id_product = '22194' 27/03/2025 09:43:29 am >> SELECT document_num FROM ps_document WHERE document_num = '991' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-27') 27/03/2025 09:43: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' , '991' , '2025-03-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '87.00' , '71.31' , NOW() , NOW() ) 27/03/2025 09:43: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 = '96383' 27/03/2025 09:43:29 am >> DELETE FROM ps_document_detail WHERE id_document = '96383' 27/03/2025 09:43: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 ( '96383' , '17617' , 'IMMAGINI ISONZO X 100' , '2' , '-2' , '1' , '3.5' , '2.8688524590164' , '22' , '0' , '7.00' ) 27/03/2025 09:43: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 ( '96383' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3' , '2.4590163934426' , '22' , '0' , '3.00' ) 27/03/2025 09:43: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 ( '96383' , '18799' , 'PARAFIAMMA PIREX PER CARTUCCIA 4 CM - 474/30' , '2' , '-2' , '1' , '11.50' , '9.4262295081967' , '22' , '0' , '23.00' ) 27/03/2025 09:43: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 ( '96383' , '7202' , 'ARTICOLI RELIGIOSI' , '3' , '-3' , '1' , '18' , '14.754098360656' , '22' , '0' , '54.00' ) 27/03/2025 10:13:49 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 27/03/2025 10:13:49 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23603' , '1' , '' , 'nuovo-prodotto' ) 27/03/2025 10:13:49 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '23603' , '1' , '1' , '2' , NOW() , NOW() ) 27/03/2025 10:13:49 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '23603' , '0' , '1' , '0' , '0' ) 27/03/2025 10:14:40 am >> SELECT ean13 FROM ps_product WHERE ean13 = '1000000016604' AND id_product != '23603' AND ean13 != '' 27/03/2025 10:14:40 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '1000000016604', date_upd = NOW() WHERE id_product = '23603' 27/03/2025 10:14:40 am >> UPDATE ps_product_lang SET name = 'CUSTODIA PELLE BIBBIA GERUSALEMME - 732', description = '' WHERE id_product = '23603' 27/03/2025 10:14:40 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '30.327868852459016' WHERE id_product = '23603' 27/03/2025 10:14:40 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '30.327868852459016', id_tax_rules_group = '1', id_category_default = '2', id_argoment_default = '', id_internal_category = '', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23603' 27/03/2025 10:14:40 am >> DELETE FROM ps_specific_price WHERE id_product = '23603' 27/03/2025 10:15:13 am >> SELECT ean13 FROM ps_product WHERE ean13 = '1000000016604' AND id_product != '23603' AND ean13 != '' 27/03/2025 10:15:13 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '1000000016604', date_upd = NOW() WHERE id_product = '23603' 27/03/2025 10:15:13 am >> UPDATE ps_product_lang SET name = 'CUSTODIA PELLE BIBBIA GERUSALEMME - 732', description = '' WHERE id_product = '23603' 27/03/2025 10:15:13 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '30.327868852459016' WHERE id_product = '23603' 27/03/2025 10:15:13 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '30.327868852459016', id_tax_rules_group = '1', id_category_default = '147', id_argoment_default = '42', id_internal_category = '4', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23603' 27/03/2025 10:15:13 am >> DELETE FROM ps_specific_price WHERE id_product = '23603' 27/03/2025 10:15:25 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 27/03/2025 10:15:25 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23604' , '1' , '' , 'nuovo-prodotto' ) 27/03/2025 10:15:25 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '23604' , '1' , '1' , '2' , NOW() , NOW() ) 27/03/2025 10:15:25 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '23604' , '0' , '1' , '0' , '0' ) 27/03/2025 10:16:34 am >> SELECT ean13 FROM ps_product WHERE ean13 = '1000000007862' AND id_product != '23604' AND ean13 != '' 27/03/2025 10:16:34 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '1000000007862', date_upd = NOW() WHERE id_product = '23604' 27/03/2025 10:16:34 am >> UPDATE ps_product_lang SET name = 'ASTUCCIO PORTA TECA - 1939', description = '' WHERE id_product = '23604' 27/03/2025 10:16:34 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '47.540983606557376' WHERE id_product = '23604' 27/03/2025 10:16:34 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '47.540983606557376', id_tax_rules_group = '1', id_category_default = '147', 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 = '23604' 27/03/2025 10:16:34 am >> DELETE FROM ps_specific_price WHERE id_product = '23604' 27/03/2025 10:19:19 am >> SELECT ean13 FROM ps_product WHERE ean13 = '001667' AND id_product != '17988' AND ean13 != '' 27/03/2025 10:19:19 am >> UPDATE ps_product SET id_supplier = '12', reference = '', ean13 = '001667', date_upd = NOW() WHERE id_product = '17988' 27/03/2025 10:19:19 am >> UPDATE ps_product_lang SET name = 'BACILE PALLADIO CM 24 - 688', description = '' WHERE id_product = '17988' 27/03/2025 10:19:19 am >> UPDATE ps_product SET wholesale_price = '31.35', on_sale = '0', price = '68.0327868852459' WHERE id_product = '17988' 27/03/2025 10:19:19 am >> UPDATE ps_product_shop SET wholesale_price = '31.35', price = '68.0327868852459', id_tax_rules_group = '1', id_category_default = '147', 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 = '17988' 27/03/2025 10:19:19 am >> DELETE FROM ps_specific_price WHERE id_product = '17988' 27/03/2025 10:22:07 am >> SELECT ean13 FROM ps_product WHERE ean13 = '001667' AND id_product != '17988' AND ean13 != '' 27/03/2025 10:22:07 am >> UPDATE ps_product SET id_supplier = '12', reference = '', ean13 = '001667', date_upd = NOW() WHERE id_product = '17988' 27/03/2025 10:22:07 am >> UPDATE ps_product_lang SET name = 'BACILE PALLADIO CM 24 - 688', description = '' WHERE id_product = '17988' 27/03/2025 10:22:07 am >> UPDATE ps_product SET wholesale_price = '31.35', on_sale = '0', price = '68.0327868852459' WHERE id_product = '17988' 27/03/2025 10:22:07 am >> UPDATE ps_product_shop SET wholesale_price = '31.35', price = '68.0327868852459', id_tax_rules_group = '1', id_category_default = '147', 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 = '17988' 27/03/2025 10:22:07 am >> DELETE FROM ps_specific_price WHERE id_product = '17988' 27/03/2025 10:23:30 am >> SELECT document_num FROM ps_document WHERE document_num = '992' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-27') 27/03/2025 10:23:30 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '992' , '2025-03-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '469.00' , '415.47' , NOW() , NOW() ) 27/03/2025 10:23:30 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96384' 27/03/2025 10:23:30 am >> DELETE FROM ps_document_detail WHERE id_document = '96384' 27/03/2025 10:23:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96384' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8.5' , '6.9672131147541' , '22' , '0' , '51.00' ) 27/03/2025 10:23:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96384' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 27/03/2025 10:23:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96384' , '16834' , 'LITURGICO CARTA 8GG' , '24' , '-24' , '1' , '3' , '2.4590163934426' , '22' , '0' , '72.00' ) 27/03/2025 10:23:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96384' , '16689' , 'OSTIA PAN DI CENA mm80' , '20' , '-20' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '40.00' ) 27/03/2025 10:23:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96384' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '50' , '-50' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '175.00' ) 27/03/2025 10:23:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96384' , '17993' , 'TRIDUO PASQUALE' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '0' , '3.00' ) 27/03/2025 10:23:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96384' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 27/03/2025 10:23:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96384' , '19818' , 'INCENSO NATURALE 3A KG 1' , '1' , '-1' , '1' , '23.00' , '18.852459016393' , '22' , '0' , '23.00' ) 27/03/2025 10:23:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96384' , '19147' , 'CANDELINE NON GOCCIOLANTI GRECHE' , '2' , '-2' , '1' , '17.8' , '14.590163934426' , '22' , '0' , '35.60' ) 27/03/2025 10:30:45 am >> SELECT document_num FROM ps_document WHERE document_num = '946' AND id_document != '96330' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-21') 27/03/2025 10:30:45 am >> UPDATE ps_document SET id_document_type = '11', document_num = '946', document_date = '2025-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 = '34.00', price_tax_excluded = '27.87', date_upd = NOW() WHERE id_document = '96330' 27/03/2025 10:30: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 = '96330' 27/03/2025 10:30:45 am >> DELETE FROM ps_document_detail WHERE id_document = '96330' 27/03/2025 10:30: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 ( '96330' , '2177' , 'CLERGY BASIC - MM - B&P' , '1' , '-1' , '1' , '34' , '27.868852459016' , '22' , '0' , '34.00' ) 27/03/2025 10:33:22 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 27/03/2025 10:33:22 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23605' , '1' , '' , 'nuovo-prodotto' ) 27/03/2025 10:33:22 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '23605' , '1' , '1' , '2' , NOW() , NOW() ) 27/03/2025 10:33:22 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '23605' , '0' , '1' , '0' , '0' ) 27/03/2025 10:35:33 am >> SELECT ean13 FROM ps_product WHERE ean13 = '1000000007725' AND id_product != '23605' AND ean13 != '' 27/03/2025 10:35:33 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '1000000007725', date_upd = NOW() WHERE id_product = '23605' 27/03/2025 10:35:33 am >> UPDATE ps_product_lang SET name = 'CALICE BAROCCO - 1887', description = '' WHERE id_product = '23605' 27/03/2025 10:35:33 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '281.9672131147541' WHERE id_product = '23605' 27/03/2025 10:35:33 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '281.9672131147541', id_tax_rules_group = '1', id_category_default = '147', 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 = '23605' 27/03/2025 10:35:33 am >> DELETE FROM ps_specific_price WHERE id_product = '23605' 27/03/2025 10:36:04 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 27/03/2025 10:36:04 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23606' , '1' , '' , 'nuovo-prodotto' ) 27/03/2025 10:36:04 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '23606' , '1' , '1' , '2' , NOW() , NOW() ) 27/03/2025 10:36:04 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '23606' , '0' , '1' , '0' , '0' ) 27/03/2025 10:37:02 am >> SELECT ean13 FROM ps_product WHERE ean13 = '001978' AND id_product != '19446' AND ean13 != '' 27/03/2025 10:37:02 am >> UPDATE ps_product SET id_supplier = '12', reference = '', ean13 = '001978', date_upd = NOW() WHERE id_product = '19446' 27/03/2025 10:37:02 am >> UPDATE ps_product_lang SET name = 'FODERA RAME SECCHIELLO', description = '' WHERE id_product = '19446' 27/03/2025 10:37:02 am >> UPDATE ps_product SET wholesale_price = '11.50', on_sale = '0', price = '24.59016393442623' WHERE id_product = '19446' 27/03/2025 10:37:02 am >> UPDATE ps_product_shop SET wholesale_price = '11.50', price = '24.59016393442623', id_tax_rules_group = '1', id_category_default = '147', 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 = '19446' 27/03/2025 10:37:02 am >> DELETE FROM ps_specific_price WHERE id_product = '19446' 27/03/2025 10:39:03 am >> SELECT ean13 FROM ps_product WHERE ean13 = '000078' AND id_product != '545' AND ean13 != '' 27/03/2025 10:39:03 am >> UPDATE ps_product SET id_supplier = '12', reference = '', ean13 = '000078', date_upd = NOW() WHERE id_product = '545' 27/03/2025 10:39:03 am >> UPDATE ps_product_lang SET name = 'AMPOLLE STYLE CON RICAMBIO - CC100 - 1507', description = '' WHERE id_product = '545' 27/03/2025 10:39:03 am >> UPDATE ps_product SET wholesale_price = '27.12', on_sale = '0', price = '71.31147540983606' WHERE id_product = '545' 27/03/2025 10:39:03 am >> UPDATE ps_product_shop SET wholesale_price = '27.12', price = '71.31147540983606', id_tax_rules_group = '1', id_category_default = '147', 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 = '545' 27/03/2025 10:39:03 am >> DELETE FROM ps_specific_price WHERE id_product = '545' 27/03/2025 10:42:13 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '952' , '2025-03-25' , '' , '0' , '12' , '2607' , 'VIA NAZIONALE NORD, 4 - LAGARO 40035 CASTIGLIONE DEI PEPOLI' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '524.45' , '429.88' , NOW() , NOW() ) 27/03/2025 10:42:13 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 = '96385' 27/03/2025 10:42:13 am >> DELETE FROM ps_document_detail WHERE id_document = '96385' 27/03/2025 10:42:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96385' , '21583' , 'CUSTODIA PELLE LITURGIA DELLE ORE - 731' , '1' , '1' , '1' , '13.5' , '11.065573770492' , '22' , '5' , '15.6465' ) 27/03/2025 10:42:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '21583' AND id_supplier = '12' 27/03/2025 10:42:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21583' , '12' , '1' ) 27/03/2025 10:42:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96385' , '23605' , 'CALICE BAROCCO - 1887' , '1' , '1' , '1' , '139' , '113.93442622951' , '22' , '5' , '161.1010' ) 27/03/2025 10:42:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '23605' AND id_supplier = '12' 27/03/2025 10:42:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23605' , '12' , '1' ) 27/03/2025 10:42:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96385' , '19446' , 'FODERA RAME SECCHIELLO' , '2' , '2' , '1' , '14' , '11.475409836066' , '22' , '5' , '32.4520' ) 27/03/2025 10:42:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '19446' AND id_supplier = '12' 27/03/2025 10:42:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19446' , '12' , '1' ) 27/03/2025 10:42:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96385' , '782' , 'ASPERGES PER SECCHIELLO - 701' , '1' , '1' , '1' , '23' , '18.852459016393' , '22' , '5' , '26.6570' ) 27/03/2025 10:42:14 am >> DELETE FROM ps_product_supplier WHERE id_product = '782' AND id_supplier = '12' 27/03/2025 10:42:14 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '782' , '12' , '1' ) 27/03/2025 10:42:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96385' , '547' , 'AMPOLLINE E VASSOIO IN VETRO - 506' , '2' , '2' , '1' , '14' , '11.475409836066' , '22' , '5' , '32.4520' ) 27/03/2025 10:42:14 am >> DELETE FROM ps_product_supplier WHERE id_product = '547' AND id_supplier = '12' 27/03/2025 10:42:14 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '547' , '12' , '1' ) 27/03/2025 10:42:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96385' , '545' , 'AMPOLLE STYLE CON RICAMBIO - CC100 - 1507' , '1' , '1' , '1' , '36' , '29.508196721311' , '22' , '5' , '41.7240' ) 27/03/2025 10:42:14 am >> DELETE FROM ps_product_supplier WHERE id_product = '545' AND id_supplier = '12' 27/03/2025 10:42:14 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '545' , '12' , '1' ) 27/03/2025 10:42:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96385' , '23603' , 'CUSTODIA PELLE BIBBIA GERUSALEMME - 732' , '2' , '2' , '1' , '15.5' , '12.704918032787' , '22' , '5' , '35.9290' ) 27/03/2025 10:42:14 am >> DELETE FROM ps_product_supplier WHERE id_product = '23603' AND id_supplier = '12' 27/03/2025 10:42:14 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23603' , '12' , '1' ) 27/03/2025 10:42:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96385' , '12203' , 'VETRO ANTIVENTO PER F. CAND. DIAM. 5 - 73/50' , '10' , '10' , '1' , '9.5' , '7.7868852459016' , '22' , '5' , '110.1050' ) 27/03/2025 10:42:14 am >> DELETE FROM ps_product_supplier WHERE id_product = '12203' AND id_supplier = '12' 27/03/2025 10:42:14 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12203' , '12' , '1' ) 27/03/2025 10:42:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96385' , '23604' , 'ASTUCCIO PORTA TECA - 1939' , '1' , '1' , '1' , '24' , '19.672131147541' , '22' , '5' , '27.8160' ) 27/03/2025 10:42:14 am >> DELETE FROM ps_product_supplier WHERE id_product = '23604' AND id_supplier = '12' 27/03/2025 10:42:14 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23604' , '12' , '1' ) 27/03/2025 10:42:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96385' , '17988' , 'BACILE PALLADIO CM 24 - 688' , '1' , '1' , '1' , '35' , '28.688524590164' , '22' , '5' , '40.5650' ) 27/03/2025 10:42:14 am >> DELETE FROM ps_product_supplier WHERE id_product = '17988' AND id_supplier = '12' 27/03/2025 10:42:14 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17988' , '12' , '1' ) 27/03/2025 10:44:19 am >> SELECT document_num FROM ps_document WHERE document_num = '60/A' AND id_document != '96226' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-03-13') 27/03/2025 10:44:19 am >> UPDATE ps_document SET id_document_type = '24', document_num = '60/A', document_date = '2025-03-13', document_letter = 'A', id_customer = '922', id_supplier = '', id_address = '4671011', address1 = 'VIA S. MARIA IN MONTICELLI, 28 00186 ROMA', address2 = '', note = 'MATERIALE india', 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 = '2860.70', price_tax_excluded = '2344.84', date_upd = NOW() WHERE id_document = '96226' 27/03/2025 10:44:19 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 = '96226' 27/03/2025 10:44:19 am >> DELETE FROM ps_document_detail WHERE id_document = '96226' 27/03/2025 10:44:19 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 ( '96226' , '7202' , 'CASULE' , '13' , '-13' , '1' , '70.0000' , '57.377049180328' , '22' , '0' , '910.00' ) 27/03/2025 10:44:19 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 ( '96226' , '21377' , 'CASULA POLIESTERE IHS' , '2' , '-2' , '1' , '65.0000' , '53.27868852459' , '22' , '0' , '130.00' ) 27/03/2025 10:44:19 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 ( '96226' , '0' , 'CASULA' , '1' , '-1' , '1' , '65.0000' , '53.27868852459' , '22' , '0' , '65.00' ) 27/03/2025 10:44:19 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 ( '96226' , '11265' , 'COPRILEGGIO - 881' , '1' , '-1' , '1' , '75.0000' , '61.475409836066' , '22' , '0' , '75.00' ) 27/03/2025 10:44:19 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 ( '96226' , '12742' , 'COPRILEGGIO - 310/TP' , '1' , '-1' , '1' , '79.0000' , '64.754098360656' , '22' , '0' , '79.00' ) 27/03/2025 10:44:19 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 ( '96226' , '0' , 'COPRI AMBONE' , '1' , '-1' , '1' , '55.0000' , '45.081967213115' , '22' , '0' , '55.00' ) 27/03/2025 10:44:19 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 ( '96226' , '0' , 'COPRI AMBONE' , '1' , '-1' , '1' , '85.0000' , '69.672131147541' , '22' , '0' , '85.00' ) 27/03/2025 10:44:19 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 ( '96226' , '14924' , 'STOLA - PST015' , '2' , '-2' , '1' , '90.0000' , '73.770491803279' , '22' , '0' , '180.00' ) 27/03/2025 10:44:19 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 ( '96226' , '16188' , 'STOLA QUATTRO EVANGELISTI - PST009' , '1' , '-1' , '1' , '70.8000' , '58.032786885246' , '22' , '0' , '70.80' ) 27/03/2025 10:44:19 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 ( '96226' , '0' , 'STOLA' , '4' , '-4' , '1' , '60.0000' , '49.180327868852' , '22' , '0' , '240.00' ) 27/03/2025 10:44:19 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 ( '96226' , '0' , 'STOLA' , '1' , '-1' , '1' , '65.0000' , '53.27868852459' , '22' , '0' , '65.00' ) 27/03/2025 10:44:19 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 ( '96226' , '20644' , 'STOLA - PST022' , '1' , '-1' , '1' , '35.0000' , '28.688524590164' , '22' , '0' , '35.00' ) 27/03/2025 10:44:19 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 ( '96226' , '23547' , 'STOLA RICAMO CROCE - 652' , '2' , '-2' , '1' , '50.0000' , '40.983606557377' , '22' , '0' , '100.00' ) 27/03/2025 10:44:19 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 ( '96226' , '10251' , 'STOLA ST 340' , '1' , '-1' , '1' , '130.0000' , '106.55737704918' , '22' , '0' , '130.00' ) 27/03/2025 10:44:19 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 ( '96226' , '10244' , 'STOLE' , '4' , '-4' , '1' , '130.0000' , '106.55737704918' , '22' , '0' , '520.00' ) 27/03/2025 10:44:19 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 ( '96226' , '547' , 'AMPOLLINE E VASSOIO IN VETRO - 506' , '1' , '-1' , '1' , '33.90' , '27.786885245902' , '22' , '0' , '33.90' ) 27/03/2025 10:44:19 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 ( '96226' , '545' , 'AMPOLLE STYLE CON RICAMBIO - CC100 - 1507' , '1' , '-1' , '1' , '87.00' , '71.311475409836' , '22' , '0' , '87.00' ) 27/03/2025 10:49:52 am >> SELECT document_num FROM ps_document WHERE document_num = '52' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-03-27') 27/03/2025 10:49: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 ( '21' , '52' , '2025-03-27' , '' , '4097' , '0' , '4679297' , 'VIA G. DONIZETTI 83 06132 PERUGIA' , '' , '' , '5' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '33.50' , '33.50' , NOW() , NOW() ) 27/03/2025 10:49: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 = '96386' 27/03/2025 10:49:52 am >> DELETE FROM ps_document_detail WHERE id_document = '96386' 27/03/2025 10:49: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 ( '96386' , '11097' , 'VANGELO E ATTI DEGLI APOSTOLI' , '6' , '-6' , '4' , '5.00' , '5' , '0' , '5' , '28.50' ) 27/03/2025 10:56:08 am >> SELECT document_num FROM ps_document WHERE document_num = '993' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-27') 27/03/2025 10:56: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' , '993' , '2025-03-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '125.00' , '102.46' , NOW() , NOW() ) 27/03/2025 10:56: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 = '96387' 27/03/2025 10:56:08 am >> DELETE FROM ps_document_detail WHERE id_document = '96387' 27/03/2025 10:56: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 ( '96387' , '19364' , 'CERO MINIATO 80X120' , '1' , '-1' , '1' , '125.00' , '102.45901639344' , '22' , '0' , '125.00' ) 27/03/2025 11:03:45 am >> SELECT document_num FROM ps_document WHERE document_num = '994' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-27') 27/03/2025 11:03: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' , '994' , '2025-03-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.80' , '3.11' , NOW() , NOW() ) 27/03/2025 11:03: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 = '96388' 27/03/2025 11:03:45 am >> DELETE FROM ps_document_detail WHERE id_document = '96388' 27/03/2025 11:03: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 ( '96388' , '15103' , 'GIROCOLLO - 870/24' , '1' , '-1' , '1' , '3.80' , '3.1147540983607' , '22' , '0' , '3.80' ) 27/03/2025 11:09:40 am >> SELECT document_num FROM ps_document WHERE document_num = '995' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-27') 27/03/2025 11:09:40 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '995' , '2025-03-27' , '' , '333' , '0' , '4671072' , 'P.ZZA S. MICHELE 84135 RUFOLI' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '197.70' , '174.61' , NOW() , NOW() ) 27/03/2025 11:09:40 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96389' 27/03/2025 11:09:40 am >> DELETE FROM ps_document_detail WHERE id_document = '96389' 27/03/2025 11:09:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96389' , '1631' , 'CANDELINE NON GOCCIOLANTI ' , '2' , '-2' , '1' , '27.5000' , '22.541' , '22' , '0' , '55.00' ) 27/03/2025 11:09:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96389' , '20798' , 'LEZIONARIO DOMENICALE E FESTIVO - N.E. - ANNO C' , '1' , '-1' , '4' , '60.0000' , '60' , '0' , '5' , '57.00' ) 27/03/2025 11:09:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96389' , '12849' , 'LIBRO DELLE SS. MESSE' , '1' , '-1' , '1' , '20.0000' , '16.3934' , '22' , '10' , '18.00' ) 27/03/2025 11:09:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96389' , '23463' , 'GRUPPO LITURGICO PARROCCHIALE - F. GILARDI' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '0' , '2.00' ) 27/03/2025 11:09:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96389' , '23478' , 'MESSAGGIO PER LA QUARESIMA 2025' , '1' , '-1' , '4' , '1.2000' , '1.2' , '0' , '0' , '1.20' ) 27/03/2025 11:09:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96389' , '15097' , 'CORONA MATRIMONIO - ORO - 197/34' , '1' , '-1' , '1' , '7.5000' , '6.1475' , '22' , '0' , '7.50' ) 27/03/2025 11:09:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96389' , '23101' , 'PORTACHIAVI DECINA GIUBILEO - 1704D' , '20' , '-20' , '1' , '2.2000' , '1.8033' , '22' , '0' , '44.00' ) 27/03/2025 11:09:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96389' , '21597' , 'BIGLIETTI AUGURI SAN PAOLO' , '1' , '-1' , '1' , '1.0000' , '0.8197' , '22' , '0' , '1.00' ) 27/03/2025 11:09:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96389' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '1' , '-1' , '3' , '3.5000' , '3.3654' , '4' , '0' , '3.50' ) 27/03/2025 11:09:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96389' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.5000' , '4.3269' , '4' , '0' , '4.50' ) 27/03/2025 11:09:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96389' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.0000' , '1.9231' , '4' , '0' , '4.00' ) 27/03/2025 11:10:55 am >> SELECT document_num FROM ps_document WHERE document_num = '25/A' AND id_document != '95409' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-01-24') 27/03/2025 11:10:55 am >> UPDATE ps_document SET id_document_type = '24', document_num = '25/A', document_date = '2025-01-24', document_letter = 'A', id_customer = '333', id_supplier = '', id_address = '4671072', address1 = 'P.ZZA S. MICHELE 84135 RUFOLI', 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 = '150.00', price_tax_excluded = '122.95', date_upd = NOW() WHERE id_document = '95409' 27/03/2025 11:10:55 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95409' 27/03/2025 11:10:55 am >> DELETE FROM ps_document_detail WHERE id_document = '95409' 27/03/2025 11:10:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95409' , '1041' , 'BENEDIZIONI' , '500' , '-500' , '1' , '0.1800' , '0.14754098360656' , '22' , '0' , '90.00' ) 27/03/2025 11:10:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95409' , '0' , '9/3/25' , '0' , '0' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 27/03/2025 11:10:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95409' , '23095' , 'PORTACHIAVI GIUBILEO - G1878' , '25' , '-25' , '1' , '2.4000' , '1.9672131147541' , '22' , '0' , '60.00' ) 27/03/2025 11:20:32 am >> SELECT document_num FROM ps_document WHERE document_num = '25/A' AND id_document != '95409' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-01-24') 27/03/2025 11:20:32 am >> UPDATE ps_document SET id_document_type = '24', document_num = '25/A', document_date = '2025-01-24', document_letter = 'A', id_customer = '333', id_supplier = '', id_address = '4671072', address1 = 'P.ZZA S. MICHELE 84135 RUFOLI', 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 = '162.60', price_tax_excluded = '135.55', date_upd = NOW() WHERE id_document = '95409' 27/03/2025 11:20: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 = '95409' 27/03/2025 11:20:32 am >> DELETE FROM ps_document_detail WHERE id_document = '95409' 27/03/2025 11:20: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 ( '95409' , '1041' , 'BENEDIZIONI' , '500' , '-500' , '1' , '0.1800' , '0.14754098360656' , '22' , '0' , '90.00' ) 27/03/2025 11:20: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 ( '95409' , '0' , '9/3/25' , '0' , '0' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 27/03/2025 11:20: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 ( '95409' , '23095' , 'PORTACHIAVI GIUBILEO - G1878' , '25' , '-25' , '1' , '2.4000' , '1.9672131147541' , '22' , '0' , '60.00' ) 27/03/2025 11:20: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 ( '95409' , '' , '27/03' , '1' , '-1' , '0' , '0' , '0' , '' , '0' , '0' ) 27/03/2025 11:20: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 ( '95409' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '18' , '-18' , '4' , '0.70' , '0.7' , '0' , '0' , '12.60' ) 27/03/2025 11:25:53 am >> SELECT document_num FROM ps_document WHERE document_num = '996' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-27') 27/03/2025 11:25:53 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' , '996' , '2025-03-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 27/03/2025 11:25:53 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 = '96390' 27/03/2025 11:25:53 am >> DELETE FROM ps_document_detail WHERE id_document = '96390' 27/03/2025 11:25:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96390' , '23536' , 'SULLA TUA PAROLA - MAG/GIU 25' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 27/03/2025 11:47:03 am >> SELECT document_num FROM ps_document WHERE document_num = '997' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-27') 27/03/2025 11:47:03 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' , '997' , '2025-03-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '160.00' , '131.15' , NOW() , NOW() ) 27/03/2025 11:47:03 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 = '96391' 27/03/2025 11:47:03 am >> DELETE FROM ps_document_detail WHERE id_document = '96391' 27/03/2025 11:47:03 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 ( '96391' , '15210' , 'CERO PASQUALE API 80X120' , '1' , '-1' , '1' , '160' , '131.14754098361' , '22' , '0' , '160.00' ) 27/03/2025 11:49:52 am >> SELECT document_num FROM ps_document WHERE document_num = '995' AND id_document != '96389' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-27') 27/03/2025 11:49:52 am >> UPDATE ps_document SET id_document_type = '11', document_num = '995', document_date = '2025-03-27', document_letter = '', id_customer = '', id_supplier = '', id_address = '', address1 = 'P.ZZA S. MICHELE 84135 RUFOLI', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '197.70', price_tax_excluded = '174.61', date_upd = NOW() WHERE id_document = '96389' 27/03/2025 11:49: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 = '96389' 27/03/2025 11:49:52 am >> DELETE FROM ps_document_detail WHERE id_document = '96389' 27/03/2025 11:49: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 ( '96389' , '1631' , 'CANDELINE NON GOCCIOLANTI ' , '2' , '-2' , '1' , '27.5000' , '22.540983606557' , '22' , '0' , '55.00' ) 27/03/2025 11:49: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 ( '96389' , '20798' , 'LEZIONARIO DOMENICALE E FESTIVO - N.E. - ANNO C' , '1' , '-1' , '4' , '60.0000' , '60' , '0' , '5' , '57.00' ) 27/03/2025 11:49: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 ( '96389' , '12849' , 'LIBRO DELLE SS. MESSE' , '1' , '-1' , '1' , '20.0000' , '16.393442622951' , '22' , '10' , '18.00' ) 27/03/2025 11:49: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 ( '96389' , '23463' , 'GRUPPO LITURGICO PARROCCHIALE - F. GILARDI' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '0' , '2.00' ) 27/03/2025 11:49: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 ( '96389' , '23478' , 'MESSAGGIO PER LA QUARESIMA 2025' , '1' , '-1' , '4' , '1.2000' , '1.2' , '0' , '0' , '1.20' ) 27/03/2025 11:49: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 ( '96389' , '15097' , 'CORONA MATRIMONIO - ORO - 197/34' , '1' , '-1' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '7.50' ) 27/03/2025 11:49: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 ( '96389' , '23101' , 'PORTACHIAVI DECINA GIUBILEO - 1704D' , '20' , '-20' , '1' , '2.2000' , '1.8032786885246' , '22' , '0' , '44.00' ) 27/03/2025 11:49: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 ( '96389' , '21597' , 'BIGLIETTI AUGURI SAN PAOLO' , '1' , '-1' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '1.00' ) 27/03/2025 11:49: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 ( '96389' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '1' , '-1' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '3.50' ) 27/03/2025 11:49: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 ( '96389' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.5000' , '4.3269230769231' , '4' , '0' , '4.50' ) 27/03/2025 11:49: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 ( '96389' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '4.00' ) 27/03/2025 11:50:58 am >> SELECT document_num FROM ps_document WHERE document_num = '858' AND id_document != '96218' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-13') 27/03/2025 11:50:58 am >> UPDATE ps_document SET id_document_type = '11', document_num = '858', document_date = '2025-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 = '144.90', price_tax_excluded = '121.75', date_upd = NOW() WHERE id_document = '96218' 27/03/2025 11:50:58 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 = '96218' 27/03/2025 11:50:58 am >> DELETE FROM ps_document_detail WHERE id_document = '96218' 27/03/2025 11:50:58 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 ( '96218' , '2097' , 'CIPOLLINA MANGIAFUMO - 1057' , '5' , '-5' , '1' , '9.0000' , '7.3770491803279' , '22' , '0' , '45.00' ) 27/03/2025 11:50:58 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 ( '96218' , '18140' , 'TAU SNODATO PADRE NOSTRO MEDIO' , '2' , '-2' , '1' , '10' , '8.1967213114754' , '22' , '0' , '20.00' ) 27/03/2025 11:50:58 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 ( '96218' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '28' , '22.950819672131' , '22' , '0' , '28.00' ) 27/03/2025 11:50:58 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 ( '96218' , '19147' , 'CANDELINE NON GOCCIOLANTI GRECHE' , '1' , '-1' , '1' , '17.9000' , '14.672131147541' , '22' , '0' , '17.90' ) 27/03/2025 11:50:58 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 ( '96218' , '19102' , 'CARBONCINI MM 40' , '1' , '-1' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '13.00' ) 27/03/2025 11:50:58 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 ( '96218' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '6' , '-6' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '21.00' ) 27/03/2025 11:51:35 am >> SELECT ean13 FROM ps_product WHERE ean13 = '001702' AND id_product != '18140' AND ean13 != '' 27/03/2025 11:51:35 am >> UPDATE ps_product SET id_supplier = '148', reference = '', ean13 = '001702', date_upd = NOW() WHERE id_product = '18140' 27/03/2025 11:51:35 am >> UPDATE ps_product_lang SET name = 'TAU SNODATO PADRE NOSTRO MEDIO', description = '' WHERE id_product = '18140' 27/03/2025 11:51:35 am >> UPDATE ps_product SET wholesale_price = '5.20', on_sale = '0', price = '10.491803278688526' WHERE id_product = '18140' 27/03/2025 11:51:35 am >> UPDATE ps_product_shop SET wholesale_price = '5.20', price = '10.491803278688526', id_tax_rules_group = '1', id_category_default = '477', 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 = '18140' 27/03/2025 11:51:35 am >> DELETE FROM ps_specific_price WHERE id_product = '18140' 27/03/2025 11:52:57 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788878793170' AND id_product != '23606' AND ean13 != '' 27/03/2025 11:52:57 am >> UPDATE ps_product SET id_supplier = '', reference = '7/4', ean13 = '9788878793170', date_upd = NOW() WHERE id_product = '23606' 27/03/2025 11:52:57 am >> UPDATE ps_product_lang SET name = 'MESSA MEDITAZIONE - MAG/GIU 25', description = '' WHERE id_product = '23606' 27/03/2025 11:52:57 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '8' WHERE id_product = '23606' 27/03/2025 11:52:57 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '8', id_tax_rules_group = '4', id_category_default = '271', 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 = '23606' 27/03/2025 11:52:57 am >> DELETE FROM ps_specific_price WHERE id_product = '23606' 27/03/2025 11:52:58 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 = '23606' 27/03/2025 11:52:58 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23607' , '1' , '' , 'nuovo-prodotto' ) 27/03/2025 11:52:58 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 '23607' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23606' 27/03/2025 11:52:58 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23607' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23606' 27/03/2025 11:53:30 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788878793187' AND id_product != '23607' AND ean13 != '' 27/03/2025 11:53:30 am >> UPDATE ps_product SET id_supplier = '', reference = '7/4', ean13 = '9788878793187', date_upd = NOW() WHERE id_product = '23607' 27/03/2025 11:53:31 am >> UPDATE ps_product_lang SET name = 'MESSA MEDITAZIONE - LUG/AGO 25', description = '' WHERE id_product = '23607' 27/03/2025 11:53:31 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '8' WHERE id_product = '23607' 27/03/2025 11:53:31 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '8', id_tax_rules_group = '4', id_category_default = '271', 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 = '23607' 27/03/2025 11:53:31 am >> DELETE FROM ps_specific_price WHERE id_product = '23607' 27/03/2025 11:54:48 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '70/2025' , '2025-03-18' , '2025' , '0' , '40' , '2635' , 'VIA CARLO POMA, 2 00151 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '11' , '0' , '86.40' , '86.40' , NOW() , NOW() ) 27/03/2025 11:54:48 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 = '96392' 27/03/2025 11:54:48 am >> DELETE FROM ps_document_detail WHERE id_document = '96392' 27/03/2025 11:54:48 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 ( '96392' , '23606' , 'MESSA MEDITAZIONE - MAG/GIU 25' , '9' , '9' , '4' , '8.00' , '8' , '0' , '40' , '43.2000' ) 27/03/2025 11:54:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '23606' AND id_supplier = '40' 27/03/2025 11:54:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23606' , '40' , '1' ) 27/03/2025 11:54:48 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 ( '96392' , '23607' , 'MESSA MEDITAZIONE - LUG/AGO 25' , '9' , '9' , '4' , '8.00' , '8' , '0' , '40' , '43.2000' ) 27/03/2025 11:54:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '23607' AND id_supplier = '40' 27/03/2025 11:54:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23607' , '40' , '1' ) 27/03/2025 11:55:14 am >> SELECT document_num FROM ps_document WHERE document_num = '998' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-27') 27/03/2025 11:55:14 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '998' , '2025-03-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.50' , '3.69' , NOW() , NOW() ) 27/03/2025 11:55:14 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96393' 27/03/2025 11:55:14 am >> DELETE FROM ps_document_detail WHERE id_document = '96393' 27/03/2025 11:55:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96393' , '3144' , 'CROCE TRILOBATA ' , '1' , '-1' , '1' , '4.50' , '3.6885245901639' , '22' , '0' , '4.50' ) 27/03/2025 11:56:28 am >> SELECT document_num FROM ps_document WHERE document_num = '858' AND id_document != '96218' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-13') 27/03/2025 11:56:28 am >> UPDATE ps_document SET id_document_type = '11', document_num = '858', document_date = '2025-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 = '134.90', price_tax_excluded = '113.55', date_upd = NOW() WHERE id_document = '96218' 27/03/2025 11:56:28 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 = '96218' 27/03/2025 11:56:28 am >> DELETE FROM ps_document_detail WHERE id_document = '96218' 27/03/2025 11:56:28 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 ( '96218' , '2097' , 'CIPOLLINA MANGIAFUMO - 1057' , '5' , '-5' , '1' , '9.0000' , '7.3770491803279' , '22' , '0' , '45.00' ) 27/03/2025 11:56:28 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 ( '96218' , '18140' , 'TAU SNODATO PADRE NOSTRO MEDIO' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 27/03/2025 11:56:28 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 ( '96218' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '28.0000' , '22.950819672131' , '22' , '0' , '28.00' ) 27/03/2025 11:56:28 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 ( '96218' , '19147' , 'CANDELINE NON GOCCIOLANTI GRECHE' , '1' , '-1' , '1' , '17.9000' , '14.672131147541' , '22' , '0' , '17.90' ) 27/03/2025 11:56:28 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 ( '96218' , '19102' , 'CARBONCINI MM 40' , '1' , '-1' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '13.00' ) 27/03/2025 11:56:28 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 ( '96218' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '6' , '-6' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '21.00' ) 27/03/2025 12:05:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '693' AND id_document != '95998' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-01') 27/03/2025 12:05:33 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '693', document_date = '2025-03-01', 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 = '70.00', price_tax_excluded = '57.38', date_upd = NOW() WHERE id_document = '95998' 27/03/2025 12:05:33 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 = '95998' 27/03/2025 12:05:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '95998' 27/03/2025 12:05:33 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 ( '95998' , '22343' , 'LAMPADA IN CRISTALLO LAVORATA' , '2' , '-2' , '1' , '35' , '28.688524590164' , '22' , '0' , '70.00' ) 27/03/2025 12:06:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '834' AND id_document != '96184' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-11') 27/03/2025 12:06:11 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '834', document_date = '2025-03-11', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '45.00', price_tax_excluded = '36.89', date_upd = NOW() WHERE id_document = '96184' 27/03/2025 12:06:11 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 = '96184' 27/03/2025 12:06:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '96184' 27/03/2025 12:06:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96184' , '12527' , 'LAMPADA A SFERA VIOLA' , '2' , '-2' , '1' , '22.5' , '18.44262295082' , '22' , '0' , '45.00' ) 27/03/2025 12:07:40 pm >> SELECT document_num FROM ps_document WHERE document_num = '834' AND id_document != '96184' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-11') 27/03/2025 12:07:40 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '834', document_date = '2025-03-11', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '45.00', price_tax_excluded = '36.89', date_upd = NOW() WHERE id_document = '96184' 27/03/2025 12:07:40 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96184' 27/03/2025 12:07:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '96184' 27/03/2025 12:07:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96184' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '45' , '36.885245901639' , '22' , '0' , '45.00' ) 27/03/2025 12:26:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '997' AND id_document != '96391' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-27') 27/03/2025 12:26:45 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '997', document_date = '2025-03-27', 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 = '160.00', price_tax_excluded = '131.15', date_upd = NOW() WHERE id_document = '96391' 27/03/2025 12:26:45 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 = '96391' 27/03/2025 12:26:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '96391' 27/03/2025 12:26:45 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 ( '96391' , '15210' , 'CERO PASQUALE API 80X120' , '2' , '-2' , '1' , '80' , '65.573770491803' , '22' , '0' , '160.00' ) 27/03/2025 12:27:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '990' AND id_document != '96382' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-27') 27/03/2025 12:27:09 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '990', document_date = '2025-03-27', 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 = '170.00', price_tax_excluded = '139.34', date_upd = NOW() WHERE id_document = '96382' 27/03/2025 12:27:09 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 = '96382' 27/03/2025 12:27:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '96382' 27/03/2025 12:27:09 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 ( '96382' , '15210' , 'CERO PASQUALE API 80X120' , '2' , '-2' , '1' , '85' , '69.672131147541' , '22' , '0' , '170.00' ) 27/03/2025 01:07:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '61/A' AND id_document != '96242' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-03-15') 27/03/2025 01:07:15 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '61/A', document_date = '2025-03-15', document_letter = 'A', id_customer = '2332', id_supplier = '', id_address = '4679092', address1 = 'P.ZZA S. ROCCO 84088 SIANO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '197.80', price_tax_excluded = '183.41', date_upd = NOW() WHERE id_document = '96242' 27/03/2025 01:07: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 = '96242' 27/03/2025 01:07:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '96242' 27/03/2025 01:07: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 ( '96242' , '19253' , 'BRUCIAINCENSO CM 9' , '1' , '-1' , '1' , '19.0000' , '15.573770491803' , '22' , '0' , '19.00' ) 27/03/2025 01:07: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 ( '96242' , '7311' , 'OSTIA SOTTILE 74MM' , '5' , '-5' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '10.00' ) 27/03/2025 01:07: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 ( '96242' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '40' , '-40' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '140.00' ) 27/03/2025 01:07: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 ( '96242' , '20516' , 'CROCE COMUNIONE - 42/08' , '24' , '-24' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '28.80' ) 27/03/2025 03:42:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '999' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-27') 27/03/2025 03:42:32 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '999' , '2025-03-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '84.50' , '69.53' , NOW() , NOW() ) 27/03/2025 03:42: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 = '96394' 27/03/2025 03:42:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '96394' 27/03/2025 03:42: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 ( '96394' , '22211' , 'CROCE IN RESINA 29X20 - 1017' , '1' , '-1' , '1' , '38.00' , '31.147540983607' , '22' , '0' , '38.00' ) 27/03/2025 03:42: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 ( '96394' , '23550' , 'SAN CARLO ACUTIS - 8361' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '0' , '1.50' ) 27/03/2025 03:42: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 ( '96394' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '45' , '36.885245901639' , '22' , '0' , '45.00' ) 27/03/2025 04:10:51 pm >> SELECT document_num FROM ps_document WHERE document_num = '1000' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-27') 27/03/2025 04:10:51 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1000' , '2025-03-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '68.00' , '62.77' , NOW() , NOW() ) 27/03/2025 04:10:51 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96395' 27/03/2025 04:10:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '96395' 27/03/2025 04:10:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96395' , '15097' , 'CORONA MATRIMONIO - ORO - 197/34' , '1' , '-1' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '7.50' ) 27/03/2025 04:10:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96395' , '19724' , 'ROSARIO COPPIGLIATO S. FAMIGLIA MM8 - RE1717-SM' , '1' , '-1' , '1' , '12.50' , '10.245901639344' , '22' , '0' , '12.50' ) 27/03/2025 04:10:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96395' , '18099' , 'CROCE IN RESINA CM 19 - 3831' , '1' , '-1' , '1' , '4.50' , '3.6885245901639' , '22' , '0' , '4.50' ) 27/03/2025 04:10:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96395' , '18098' , 'CROCE IN RESINA CM 19 - 3830' , '1' , '-1' , '1' , '4.50' , '3.6885245901639' , '22' , '0' , '4.50' ) 27/03/2025 04:10:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96395' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '39' , '39' , '0' , '0' , '39.00' ) 27/03/2025 04:18:27 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 27/03/2025 04:18:27 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23608' , '1' , '' , 'nuovo-prodotto' ) 27/03/2025 04:18:27 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '23608' , '1' , '1' , '2' , NOW() , NOW() ) 27/03/2025 04:18:27 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '23608' , '0' , '1' , '0' , '0' ) 27/03/2025 04:20:04 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002358' AND id_product != '23608' AND ean13 != '' 27/03/2025 04:20:04 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002358', date_upd = NOW() WHERE id_product = '23608' 27/03/2025 04:20:04 pm >> UPDATE ps_product_lang SET name = 'quadro decorato 33x33 - pr-rd', description = '' WHERE id_product = '23608' 27/03/2025 04:20:04 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '20.491803278688526' WHERE id_product = '23608' 27/03/2025 04:20:04 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '20.491803278688526', id_tax_rules_group = '1', id_category_default = '276', 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 = '23608' 27/03/2025 04:20:04 pm >> DELETE FROM ps_specific_price WHERE id_product = '23608' 27/03/2025 04:20:39 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002358' AND id_product != '23608' AND ean13 != '' 27/03/2025 04:20:39 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002358', date_upd = NOW() WHERE id_product = '23608' 27/03/2025 04:20:39 pm >> UPDATE ps_product_lang SET name = 'quadro decorato 33x33 - pr-rd', description = '' WHERE id_product = '23608' 27/03/2025 04:20:39 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '20.491803278688526' WHERE id_product = '23608' 27/03/2025 04:20:39 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '20.491803278688526', id_tax_rules_group = '1', id_category_default = '276', 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 = '23608' 27/03/2025 04:20:39 pm >> DELETE FROM ps_specific_price WHERE id_product = '23608' 27/03/2025 04:20:58 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002358' AND id_product != '23608' AND ean13 != '' 27/03/2025 04:20:58 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002358', date_upd = NOW() WHERE id_product = '23608' 27/03/2025 04:20:58 pm >> UPDATE ps_product_lang SET name = 'QUADRO DECORATO 33X33 - PR-RD', description = '' WHERE id_product = '23608' 27/03/2025 04:20:58 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '20.4918' WHERE id_product = '23608' 27/03/2025 04:20:58 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '20.4918', id_tax_rules_group = '1', id_category_default = '276', 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 = '23608' 27/03/2025 04:20:58 pm >> DELETE FROM ps_specific_price WHERE id_product = '23608' 27/03/2025 04:22:14 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002358' AND id_product != '23608' AND ean13 != '' 27/03/2025 04:22:14 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002358', date_upd = NOW() WHERE id_product = '23608' 27/03/2025 04:22:14 pm >> UPDATE ps_product_lang SET name = 'QUADRO DECORATO 33X33 - PR-R', description = '' WHERE id_product = '23608' 27/03/2025 04:22:14 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '20.4918' WHERE id_product = '23608' 27/03/2025 04:22:14 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '20.4918', id_tax_rules_group = '1', id_category_default = '276', 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 = '23608' 27/03/2025 04:22:14 pm >> DELETE FROM ps_specific_price WHERE id_product = '23608' 27/03/2025 04:23:41 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 27/03/2025 04:23:41 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23609' , '1' , '' , 'nuovo-prodotto' ) 27/03/2025 04:23:41 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '23609' , '1' , '1' , '2' , NOW() , NOW() ) 27/03/2025 04:23:42 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '23609' , '0' , '1' , '0' , '0' ) 27/03/2025 04:24:25 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002359' AND id_product != '23609' AND ean13 != '' 27/03/2025 04:24:25 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002359', date_upd = NOW() WHERE id_product = '23609' 27/03/2025 04:24:25 pm >> UPDATE ps_product_lang SET name = 'CALAMITA 8X8 ', description = '' WHERE id_product = '23609' 27/03/2025 04:24:25 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '4.098360655737705' WHERE id_product = '23609' 27/03/2025 04:24:26 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '4.098360655737705', id_tax_rules_group = '1', id_category_default = '276', 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 = '23609' 27/03/2025 04:24:26 pm >> DELETE FROM ps_specific_price WHERE id_product = '23609' 27/03/2025 04:24:50 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '23609' 27/03/2025 04:24:50 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23610' , '1' , '' , 'nuovo-prodotto' ) 27/03/2025 04:24:50 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '23610' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23609' 27/03/2025 04:24:50 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23610' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23609' 27/03/2025 04:27:36 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002360' AND id_product != '23610' AND ean13 != '' 27/03/2025 04:27:36 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002360', date_upd = NOW() WHERE id_product = '23610' 27/03/2025 04:27:36 pm >> UPDATE ps_product_lang SET name = 'lumetto 17x17 - rl', description = '' WHERE id_product = '23610' 27/03/2025 04:27:37 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '30.24590163934426' WHERE id_product = '23610' 27/03/2025 04:27:37 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '30.24590163934426', id_tax_rules_group = '1', id_category_default = '276', 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 = '23610' 27/03/2025 04:27:37 pm >> DELETE FROM ps_specific_price WHERE id_product = '23610' 27/03/2025 04:27:56 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002360' AND id_product != '23610' AND ean13 != '' 27/03/2025 04:27:56 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002360', date_upd = NOW() WHERE id_product = '23610' 27/03/2025 04:27:56 pm >> UPDATE ps_product_lang SET name = 'LUMETTO 17X17 - RL', description = '' WHERE id_product = '23610' 27/03/2025 04:27:56 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '30.2459' WHERE id_product = '23610' 27/03/2025 04:27:56 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '30.2459', id_tax_rules_group = '1', id_category_default = '276', 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 = '23610' 27/03/2025 04:27:56 pm >> DELETE FROM ps_specific_price WHERE id_product = '23610' 27/03/2025 04:29:15 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002361' AND id_product != '15932' AND ean13 != '' 27/03/2025 04:29:16 pm >> UPDATE ps_product SET id_supplier = '50', reference = '', ean13 = '002361', date_upd = NOW() WHERE id_product = '15932' 27/03/2025 04:29:16 pm >> UPDATE ps_product_lang SET name = 'PORTAFOTO - PFR', description = '' WHERE id_product = '15932' 27/03/2025 04:29:16 pm >> UPDATE ps_product SET wholesale_price = '15.00', on_sale = '0', price = '30.3279' WHERE id_product = '15932' 27/03/2025 04:29:16 pm >> UPDATE ps_product_shop SET wholesale_price = '15.00', price = '30.3279', id_tax_rules_group = '1', id_category_default = '276', 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 = '15932' 27/03/2025 04:29:16 pm >> DELETE FROM ps_specific_price WHERE id_product = '15932' 27/03/2025 04:30:41 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002362' AND id_product != '16248' AND ean13 != '' 27/03/2025 04:30:41 pm >> UPDATE ps_product SET id_supplier = '50', reference = '', ean13 = '002362', date_upd = NOW() WHERE id_product = '16248' 27/03/2025 04:30:41 pm >> UPDATE ps_product_lang SET name = 'APPENDICHIAVI 16X11', description = '' WHERE id_product = '16248' 27/03/2025 04:30:41 pm >> UPDATE ps_product SET wholesale_price = '8.00', on_sale = '0', price = '16.3115' WHERE id_product = '16248' 27/03/2025 04:30:41 pm >> UPDATE ps_product_shop SET wholesale_price = '8.00', price = '16.3115', id_tax_rules_group = '1', id_category_default = '276', 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 = '16248' 27/03/2025 04:30:41 pm >> DELETE FROM ps_specific_price WHERE id_product = '16248' 27/03/2025 04:31:29 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002362' AND id_product != '16248' AND ean13 != '' 27/03/2025 04:31:30 pm >> UPDATE ps_product SET id_supplier = '50', reference = '', ean13 = '002362', date_upd = NOW() WHERE id_product = '16248' 27/03/2025 04:31:30 pm >> UPDATE ps_product_lang SET name = 'APPENDICHIAVI 16X11 - RAR', description = '' WHERE id_product = '16248' 27/03/2025 04:31:30 pm >> UPDATE ps_product SET wholesale_price = '8.00', on_sale = '0', price = '16.3115' WHERE id_product = '16248' 27/03/2025 04:31:30 pm >> UPDATE ps_product_shop SET wholesale_price = '8.00', price = '16.3115', id_tax_rules_group = '1', id_category_default = '276', 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 = '16248' 27/03/2025 04:31:30 pm >> DELETE FROM ps_specific_price WHERE id_product = '16248' 27/03/2025 04:31:53 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002362' AND id_product != '16248' AND ean13 != '' 27/03/2025 04:31:53 pm >> UPDATE ps_product SET id_supplier = '50', reference = '', ean13 = '002362', date_upd = NOW() WHERE id_product = '16248' 27/03/2025 04:31:53 pm >> UPDATE ps_product_lang SET name = 'APPENDICHIAVI 16X11 - RAR', description = '' WHERE id_product = '16248' 27/03/2025 04:31:53 pm >> UPDATE ps_product SET wholesale_price = '8.00', on_sale = '0', price = '16.3115' WHERE id_product = '16248' 27/03/2025 04:31:53 pm >> UPDATE ps_product_shop SET wholesale_price = '8.00', price = '16.3115', id_tax_rules_group = '1', id_category_default = '276', 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 = '16248' 27/03/2025 04:31:53 pm >> DELETE FROM ps_specific_price WHERE id_product = '16248' 27/03/2025 04:31:55 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 = '16248' 27/03/2025 04:31:55 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23611' , '1' , '' , 'nuovo-prodotto' ) 27/03/2025 04:31:55 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 '23611' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '16248' 27/03/2025 04:31:55 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23611' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '16248' 27/03/2025 04:33:35 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002363' AND id_product != '13609' AND ean13 != '' 27/03/2025 04:33:35 pm >> UPDATE ps_product SET id_supplier = '50', reference = '', ean13 = '002363', date_upd = NOW() WHERE id_product = '13609' 27/03/2025 04:33:35 pm >> UPDATE ps_product_lang SET name = 'APPENDICHIAVI 12X12 - RAQ', description = '' WHERE id_product = '13609' 27/03/2025 04:33:35 pm >> UPDATE ps_product SET wholesale_price = '6.50', on_sale = '0', price = '13.0328' WHERE id_product = '13609' 27/03/2025 04:33:35 pm >> UPDATE ps_product_shop SET wholesale_price = '6.50', price = '13.0328', id_tax_rules_group = '1', id_category_default = '276', 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 = '13609' 27/03/2025 04:33:35 pm >> DELETE FROM ps_specific_price WHERE id_product = '13609' 27/03/2025 04:46:44 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '225' , '2025-03-25' , '' , '4085' , '0' , '4679275' , 'VIA SEMERIA 19 70014 CONVERSANO' , '' , '' , '25' , '1' , '0' , '0' , '0' , '' , '3' , '0' , '962.58' , '789.00' , NOW() , NOW() ) 27/03/2025 04:46:44 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96396' 27/03/2025 04:46:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '96396' 27/03/2025 04:46:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96396' , '23608' , 'QUADRO DECORATO 33X33 - PR-RD' , '20' , '20' , '1' , '10' , '8.1967213114754' , '22' , '0' , '244.0000' ) 27/03/2025 04:46:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96396' , '23609' , 'CALAMITA 8X8 ' , '100' , '100' , '1' , '2' , '1.6393442622951' , '22' , '0' , '244.0000' ) 27/03/2025 04:46:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96396' , '23610' , 'LUMETTO 17X17 - RL' , '2' , '2' , '1' , '15' , '12.295081967213' , '22' , '0' , '36.6000' ) 27/03/2025 04:46:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96396' , '15932' , 'PORTAFOTO - PFR' , '1' , '1' , '1' , '15' , '12.295081967213' , '22' , '0' , '18.3000' ) 27/03/2025 04:46:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96396' , '16248' , 'APPENDICHIAVI 16X11 - RAR' , '5' , '5' , '1' , '8' , '6.5573770491803' , '22' , '0' , '48.8000' ) 27/03/2025 04:46:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96396' , '13609' , 'APPENDICHIAVI 12X12 - RAQ' , '6' , '6' , '1' , '6.5' , '5.327868852459' , '22' , '0' , '47.5800' ) 27/03/2025 04:46:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96396' , '23608' , 'QUADRO DECORATO 33X33 - PR-R' , '30' , '30' , '1' , '8' , '6.5573770491803' , '22' , '0' , '292.8000' ) 27/03/2025 05:35:33 pm >> UPDATE ps_document SET id_document_type = '31', document_num = '225', document_date = '2025-03-25', document_letter = '', id_customer = '0', id_supplier = '50', id_address = '2645', address1 = 'VIA SEMERIA 19 70014 CONVERSANO', address2 = '', note = '', price_shipping = '25.00', id_tax_shipping_rules = '1', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '962.58', price_tax_excluded = '789.00', date_upd = NOW() WHERE id_document = '96396' 27/03/2025 05:35:33 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 = '96396' 27/03/2025 05:35:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '96396' 27/03/2025 05:35:33 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 ( '96396' , '23608' , 'QUADRO DECORATO 33X33 - PR-RD' , '20' , '20' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '244.00' ) 27/03/2025 05:35:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23608' AND id_supplier = '50' 27/03/2025 05:35:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23608' , '50' , '1' ) 27/03/2025 05:35:33 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 ( '96396' , '23609' , 'CALAMITA 8X8 ' , '100' , '100' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '244.00' ) 27/03/2025 05:35:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23609' AND id_supplier = '50' 27/03/2025 05:35:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23609' , '50' , '1' ) 27/03/2025 05:35:33 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 ( '96396' , '23610' , 'LUMETTO 17X17 - RL' , '2' , '2' , '1' , '15.0000' , '12.295081967213' , '22' , '0' , '36.60' ) 27/03/2025 05:35:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23610' AND id_supplier = '50' 27/03/2025 05:35:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23610' , '50' , '1' ) 27/03/2025 05:35:33 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 ( '96396' , '15932' , 'PORTAFOTO - PFR' , '1' , '1' , '1' , '15.0000' , '12.295081967213' , '22' , '0' , '18.30' ) 27/03/2025 05:35:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15932' AND id_supplier = '50' 27/03/2025 05:35:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15932' , '50' , '1' ) 27/03/2025 05:35:33 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 ( '96396' , '16248' , 'APPENDICHIAVI 16X11 - RAR' , '5' , '5' , '1' , '8.0000' , '6.5573770491803' , '22' , '0' , '48.80' ) 27/03/2025 05:35:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16248' AND id_supplier = '50' 27/03/2025 05:35:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16248' , '50' , '1' ) 27/03/2025 05:35:33 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 ( '96396' , '13609' , 'APPENDICHIAVI 12X12 - RAQ' , '6' , '6' , '1' , '6.5000' , '5.327868852459' , '22' , '0' , '47.58' ) 27/03/2025 05:35:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13609' AND id_supplier = '50' 27/03/2025 05:35:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13609' , '50' , '1' ) 27/03/2025 05:35:34 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 ( '96396' , '23608' , 'QUADRO DECORATO 33X33 - PR-R' , '30' , '30' , '1' , '8.0000' , '6.5573770491803' , '22' , '0' , '292.80' ) 27/03/2025 05:35:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23608' AND id_supplier = '50' 27/03/2025 05:35:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23608' , '50' , '1' ) 27/03/2025 06:22:36 pm >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'DQBIv0L3WSZyQCZN' , NOW() , NOW() ) 27/03/2025 06:22:36 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4203' , '1' ) 27/03/2025 06:22:37 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4203' , '2' ) 27/03/2025 06:22:37 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4203' , '3' ) 27/03/2025 06:24:45 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' , 'FPR48/25' , '2025-03-25' , '25' , '0' , '168' , '4676356' , 'VIA PALATUCCI 2 84048 CASTELLABATE' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '193.44' , '186.00' , NOW() , NOW() ) 27/03/2025 06:24:45 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 = '96397' 27/03/2025 06:24:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '96397' 27/03/2025 06:24:45 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 ( '96397' , '23420' , 'SPERANZA. PER VIVERE NELLA GIOIA - R. LUPI' , '150' , '150' , '3' , '1.24' , '1.1923076923077' , '4' , '0' , '193.4400' ) 27/03/2025 06:24:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23420' AND id_supplier = '168' 27/03/2025 06:24:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23420' , '168' , '1' ) 27/03/2025 07:10:45 pm >> UPDATE ps_document SET id_document_type = '31', document_num = '375', document_date = '2025-03-21', document_letter = '', id_customer = '0', id_supplier = '', id_address = '2643', address1 = 'VIA MAZARA, 209 91025 MARSALA', address2 = '', note = '', price_shipping = '-0.01', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '612.22', price_tax_excluded = '501.82', date_upd = NOW() WHERE id_document = '96361' 27/03/2025 07:10:45 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 = '96361' 27/03/2025 07:10:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '96361' 27/03/2025 07:10:45 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 ( '96361' , '11389' , 'VINO ROSSO DOLCE - 103' , '120' , '120' , '1' , '4.1819' , '3.4277868852459' , '22' , '0' , '612.23' ) 27/03/2025 07:11:14 pm >> UPDATE ps_document SET id_document_type = '31', document_num = '375', document_date = '2025-03-21', document_letter = '', id_customer = '0', id_supplier = '', id_address = '2643', address1 = 'VIA MAZARA, 209 91025 MARSALA', address2 = '', note = '', price_shipping = '-0.01', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '9', id_causal = '0', price_tax_included = '612.22', price_tax_excluded = '501.82', date_upd = NOW() WHERE id_document = '96361' 27/03/2025 07:11: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 = '96361' 27/03/2025 07:11:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '96361' 27/03/2025 07:11: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 ( '96361' , '11389' , 'VINO ROSSO DOLCE - 103' , '120' , '120' , '1' , '4.1819' , '3.4277868852459' , '22' , '0' , '612.23' ) 27/03/2025 09:36:34 pm >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'u2qKBwsv0qj6qSmJ' , NOW() , NOW() ) 27/03/2025 09:36:34 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4204' , '1' ) 27/03/2025 09:36:34 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4204' , '2' ) 27/03/2025 09:36:34 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4204' , '3' )