16/07/2025 08:54:06 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '10603/00/2025' , '2025-07-14' , '00' , '0' , '38' , '2633' , 'VIA GALVANI, 1 60020 CAMERATA PICENA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '390.00' , '390.00' , NOW() , NOW() ) 16/07/2025 08:54:06 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '98107' 16/07/2025 08:54:06 am >> DELETE FROM ps_document_detail WHERE id_document = '98107' 16/07/2025 08:54:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98107' , '23714' , 'SULLA TUA PAROLA - SETT/OTT 25' , '130' , '130' , '4' , '5.00' , '5' , '0' , '40' , '390.0000' ) 16/07/2025 08:54:06 am >> DELETE FROM ps_product_supplier WHERE id_product = '23714' AND id_supplier = '38' 16/07/2025 08:54:06 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23714' , '38' , '1' ) 16/07/2025 09:11:25 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 16/07/2025 09:11:25 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23869' , '1' , '' , 'nuovo-prodotto' ) 16/07/2025 09:11:25 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '23869' , '1' , '1' , '2' , NOW() , NOW() ) 16/07/2025 09:11:25 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '23869' , '0' , '1' , '0' , '0' ) 16/07/2025 09:12:27 am >> SELECT ean13 FROM ps_product WHERE ean13 = '000575' AND id_product != '23869' AND ean13 != '' 16/07/2025 09:12:27 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '000575', date_upd = NOW() WHERE id_product = '23869' 16/07/2025 09:12:27 am >> UPDATE ps_product_lang SET name = 'SERVIZIO MESSA - p/LINO - 6769', description = '' WHERE id_product = '23869' 16/07/2025 09:12:27 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '119.67213114754098' WHERE id_product = '23869' 16/07/2025 09:12:27 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '119.67213114754098', id_tax_rules_group = '1', id_category_default = '448', 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 = '23869' 16/07/2025 09:12:27 am >> DELETE FROM ps_specific_price WHERE id_product = '23869' 16/07/2025 09:12:47 am >> SELECT ean13 FROM ps_product WHERE ean13 = '000575' AND id_product != '23869' AND ean13 != '' 16/07/2025 09:12:47 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '000575', date_upd = NOW() WHERE id_product = '23869' 16/07/2025 09:12:47 am >> UPDATE ps_product_lang SET name = 'SERVIZIO MESSA - P/LINO - 6769', description = '' WHERE id_product = '23869' 16/07/2025 09:12:47 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '119.6721' WHERE id_product = '23869' 16/07/2025 09:12:47 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '119.6721', id_tax_rules_group = '1', id_category_default = '448', 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 = '23869' 16/07/2025 09:12:47 am >> DELETE FROM ps_specific_price WHERE id_product = '23869' 16/07/2025 09:20:32 am >> SELECT ean13 FROM ps_product WHERE ean13 = '000324' AND id_product != '19802' AND ean13 != '' 16/07/2025 09:20:32 am >> UPDATE ps_product SET id_supplier = '126', reference = '', ean13 = '000324', date_upd = NOW() WHERE id_product = '19802' 16/07/2025 09:20:32 am >> UPDATE ps_product_lang SET name = 'CASULA CON PALLIO L-LAME\' - NUOVA PRIMAVERA - 8254C', description = '' WHERE id_product = '19802' 16/07/2025 09:20:32 am >> UPDATE ps_product SET wholesale_price = '360.00', on_sale = '0', price = 'NaN' WHERE id_product = '19802' 16/07/2025 09:20:32 am >> UPDATE ps_product_shop SET wholesale_price = '360.00', price = 'NaN', id_tax_rules_group = '1', id_category_default = '448', 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 = '19802' 16/07/2025 09:20:32 am >> DELETE FROM ps_specific_price WHERE id_product = '19802' 16/07/2025 09:21:04 am >> SELECT ean13 FROM ps_product WHERE ean13 = '000324' AND id_product != '19802' AND ean13 != '' 16/07/2025 09:21:04 am >> UPDATE ps_product SET id_supplier = '126', reference = '', ean13 = '000324', date_upd = NOW() WHERE id_product = '19802' 16/07/2025 09:21:04 am >> UPDATE ps_product_lang SET name = 'CASULA CON PALLIO L-LAME\' - NUOVA PRIMAVERA - 8254C', description = '' WHERE id_product = '19802' 16/07/2025 09:21:04 am >> UPDATE ps_product SET wholesale_price = '360.00', on_sale = '0', price = '777.0491803278688' WHERE id_product = '19802' 16/07/2025 09:21:04 am >> UPDATE ps_product_shop SET wholesale_price = '360.00', price = '777.0491803278688', id_tax_rules_group = '1', id_category_default = '448', 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 = '19802' 16/07/2025 09:21:04 am >> DELETE FROM ps_specific_price WHERE id_product = '19802' 16/07/2025 09:24:06 am >> SELECT ean13 FROM ps_product WHERE ean13 = '7475-7482' AND id_product != '22759' AND ean13 != '' 16/07/2025 09:24:06 am >> UPDATE ps_product SET id_supplier = '126', reference = '', ean13 = '7475-7482', date_upd = NOW() WHERE id_product = '22759' 16/07/2025 09:24:06 am >> UPDATE ps_product_lang SET name = 'MANTOVANA IHS - 7475-7482', description = '' WHERE id_product = '22759' 16/07/2025 09:24:06 am >> UPDATE ps_product SET wholesale_price = '320.00', on_sale = '0', price = '409.8360655737705' WHERE id_product = '22759' 16/07/2025 09:24:06 am >> UPDATE ps_product_shop SET wholesale_price = '320.00', price = '409.8360655737705', id_tax_rules_group = '1', id_category_default = '448', 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 = '22759' 16/07/2025 09:24:06 am >> DELETE FROM ps_specific_price WHERE id_product = '22759' 16/07/2025 09:27:07 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '73/2025' , '2025-07-14' , '2025' , '0' , '126' , '4669995' , 'VIA DELLE INDUSTRIE, 75 06083 BASTIA UMBRA' , '' , '' , '13' , '1' , '0' , '0' , '0' , '' , '10' , '0' , '900.36' , '738.00' , NOW() , NOW() ) 16/07/2025 09:27:07 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '98108' 16/07/2025 09:27:07 am >> DELETE FROM ps_document_detail WHERE id_document = '98108' 16/07/2025 09:27:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98108' , '23869' , 'SERVIZIO MESSA - P/LINO - 6769' , '1' , '1' , '1' , '60' , '49.180327868852' , '22' , '0' , '73.2000' ) 16/07/2025 09:27:07 am >> DELETE FROM ps_product_supplier WHERE id_product = '23869' AND id_supplier = '126' 16/07/2025 09:27:07 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23869' , '126' , '1' ) 16/07/2025 09:27: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 ( '98108' , '19802' , 'CASULA CON PALLIO L-LAME - NUOVA PRIMAVERA - 8254C' , '1' , '1' , '1' , '370' , '303.27868852459' , '22' , '0' , '451.4000' ) 16/07/2025 09:27:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '19802' AND id_supplier = '126' 16/07/2025 09:27:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19802' , '126' , '1' ) 16/07/2025 09:27: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 ( '98108' , '18184' , 'STOLA RASO CON RICAMO UVA - 7877' , '1' , '1' , '1' , '75' , '61.475409836066' , '22' , '0' , '91.5000' ) 16/07/2025 09:27:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '18184' AND id_supplier = '126' 16/07/2025 09:27:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18184' , '126' , '1' ) 16/07/2025 09:27: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 ( '98108' , '22759' , 'MANTOVANA IHS - 7475-7482' , '1' , '1' , '1' , '220' , '180.32786885246' , '22' , '0' , '268.4000' ) 16/07/2025 09:27:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '22759' AND id_supplier = '126' 16/07/2025 09:27:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22759' , '126' , '1' ) 16/07/2025 10:31:40 am >> SELECT document_num FROM ps_document WHERE document_num = '2460' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2025-07-16') 16/07/2025 10:31: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' , '2460' , '2025-07-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.00' , '14.00' , NOW() , NOW() ) 16/07/2025 10:31: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 = '98109' 16/07/2025 10:31:40 am >> DELETE FROM ps_document_detail WHERE id_document = '98109' 16/07/2025 10:31: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 ( '98109' , '23789' , 'SAN PIERGIORGIO FRASSATI' , '1' , '-1' , '4' , '14.00' , '14' , '0' , '0' , '14.00' ) 16/07/2025 10:32:52 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002336' AND id_product != '23333' AND ean13 != '' 16/07/2025 10:32:52 am >> UPDATE ps_product SET id_supplier = '130', reference = '', ean13 = '002336', date_upd = NOW() WHERE id_product = '23333' 16/07/2025 10:32:52 am >> UPDATE ps_product_lang SET name = 'IMMACOLATA DEL MURILLO CM 16 - 270', description = '' WHERE id_product = '23333' 16/07/2025 10:32:52 am >> UPDATE ps_product SET wholesale_price = '11.40', on_sale = '0', price = '24.59016393442623' WHERE id_product = '23333' 16/07/2025 10:32:52 am >> UPDATE ps_product_shop SET wholesale_price = '11.40', price = '24.59016393442623', id_tax_rules_group = '1', id_category_default = '165', 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 = '23333' 16/07/2025 10:32:52 am >> DELETE FROM ps_specific_price WHERE id_product = '23333' 16/07/2025 10:33:55 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002336' AND id_product != '23333' AND ean13 != '' 16/07/2025 10:33:55 am >> UPDATE ps_product SET id_supplier = '130', reference = '', ean13 = '002336', date_upd = NOW() WHERE id_product = '23333' 16/07/2025 10:33:55 am >> UPDATE ps_product_lang SET name = 'IMMACOLATA DEL MURILLO CM 16 - 270', description = '' WHERE id_product = '23333' 16/07/2025 10:33:55 am >> UPDATE ps_product SET wholesale_price = '11.40', on_sale = '0', price = '24.59016393442623' WHERE id_product = '23333' 16/07/2025 10:33:55 am >> UPDATE ps_product_shop SET wholesale_price = '11.40', price = '24.59016393442623', id_tax_rules_group = '1', id_category_default = '165', 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 = '23333' 16/07/2025 10:33:55 am >> DELETE FROM ps_specific_price WHERE id_product = '23333' 16/07/2025 10:34:51 am >> SELECT ean13 FROM ps_product WHERE ean13 = '001784' AND id_product != '18615' AND ean13 != '' 16/07/2025 10:34:51 am >> UPDATE ps_product SET id_supplier = '130', reference = '', ean13 = '001784', date_upd = NOW() WHERE id_product = '18615' 16/07/2025 10:34:51 am >> UPDATE ps_product_lang SET name = 'SAN ROCCO CM 20 - 340', description = '' WHERE id_product = '18615' 16/07/2025 10:34:51 am >> UPDATE ps_product SET wholesale_price = '11.97', on_sale = '0', price = '24.59016393442623' WHERE id_product = '18615' 16/07/2025 10:34:51 am >> UPDATE ps_product_shop SET wholesale_price = '11.97', price = '24.59016393442623', id_tax_rules_group = '1', id_category_default = '165', 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 = '18615' 16/07/2025 10:34:51 am >> DELETE FROM ps_specific_price WHERE id_product = '18615' 16/07/2025 10:37:24 am >> SELECT ean13 FROM ps_product WHERE ean13 = '001784' AND id_product != '18615' AND ean13 != '' 16/07/2025 10:37:24 am >> UPDATE ps_product SET id_supplier = '130', reference = '', ean13 = '001784', date_upd = NOW() WHERE id_product = '18615' 16/07/2025 10:37:24 am >> UPDATE ps_product_lang SET name = 'SAN ROCCO CM 20 - 340', description = '' WHERE id_product = '18615' 16/07/2025 10:37:24 am >> UPDATE ps_product SET wholesale_price = '11.97', on_sale = '0', price = '24.59016393442623' WHERE id_product = '18615' 16/07/2025 10:37:24 am >> UPDATE ps_product_shop SET wholesale_price = '11.97', price = '24.59016393442623', id_tax_rules_group = '1', id_category_default = '165', 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 = '18615' 16/07/2025 10:37:24 am >> DELETE FROM ps_specific_price WHERE id_product = '18615' 16/07/2025 10:41:05 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002243' AND id_product != '22255' AND ean13 != '' 16/07/2025 10:41:05 am >> UPDATE ps_product SET id_supplier = '130', reference = '', ean13 = '002243', date_upd = NOW() WHERE id_product = '22255' 16/07/2025 10:41:05 am >> UPDATE ps_product_lang SET name = 'STATUA SAN GIUSEPPE CM 40 - 804', description = '' WHERE id_product = '22255' 16/07/2025 10:41:05 am >> UPDATE ps_product SET wholesale_price = '41.04', on_sale = '0', price = '88.52459016393443' WHERE id_product = '22255' 16/07/2025 10:41:05 am >> UPDATE ps_product_shop SET wholesale_price = '41.04', price = '88.52459016393443', id_tax_rules_group = '1', id_category_default = '165', 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 = '22255' 16/07/2025 10:41:05 am >> DELETE FROM ps_specific_price WHERE id_product = '22255' 16/07/2025 10:43:57 am >> SELECT ean13 FROM ps_product WHERE ean13 = 'PA611' AND id_product != '15667' AND ean13 != '' 16/07/2025 10:43:57 am >> UPDATE ps_product SET id_supplier = '130', reference = '', ean13 = 'PA611', date_upd = NOW() WHERE id_product = '15667' 16/07/2025 10:43:57 am >> UPDATE ps_product_lang SET name = 'SACRO CUORE CM 60 - PA611', description = '' WHERE id_product = '15667' 16/07/2025 10:43:57 am >> UPDATE ps_product SET wholesale_price = '71.25', on_sale = '0', price = '151.6393' WHERE id_product = '15667' 16/07/2025 10:43:57 am >> UPDATE ps_product_shop SET wholesale_price = '71.25', price = '151.6393', id_tax_rules_group = '1', id_category_default = '165', 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 = '15667' 16/07/2025 10:43:57 am >> DELETE FROM ps_specific_price WHERE id_product = '15667' 16/07/2025 10:44:23 am >> SELECT ean13 FROM ps_product WHERE ean13 = 'PA611' AND id_product != '15667' AND ean13 != '' 16/07/2025 10:44:23 am >> UPDATE ps_product SET id_supplier = '130', reference = '', ean13 = 'PA611', date_upd = NOW() WHERE id_product = '15667' 16/07/2025 10:44:23 am >> UPDATE ps_product_lang SET name = 'SACRO CUORE CM 60 - PA611', description = '' WHERE id_product = '15667' 16/07/2025 10:44:23 am >> UPDATE ps_product SET wholesale_price = '71.25', on_sale = '0', price = '196.72131147540983' WHERE id_product = '15667' 16/07/2025 10:44:23 am >> UPDATE ps_product_shop SET wholesale_price = '71.25', price = '196.72131147540983', id_tax_rules_group = '1', id_category_default = '165', 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 = '15667' 16/07/2025 10:44:23 am >> DELETE FROM ps_specific_price WHERE id_product = '15667' 16/07/2025 10:51:57 am >> SELECT ean13 FROM ps_product WHERE ean13 = '001369' AND id_product != '16514' AND ean13 != '' 16/07/2025 10:51:57 am >> UPDATE ps_product SET id_supplier = '130', reference = '', ean13 = '001369', date_upd = NOW() WHERE id_product = '16514' 16/07/2025 10:51:57 am >> UPDATE ps_product_lang SET name = 'CROCIFISSO 105X60 - 1015', description = '' WHERE id_product = '16514' 16/07/2025 10:51:57 am >> UPDATE ps_product SET wholesale_price = '127.30', on_sale = '0', price = '293.44262295081967' WHERE id_product = '16514' 16/07/2025 10:51:57 am >> UPDATE ps_product_shop SET wholesale_price = '127.30', price = '293.44262295081967', id_tax_rules_group = '1', id_category_default = '165', 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 = '16514' 16/07/2025 10:51:57 am >> DELETE FROM ps_specific_price WHERE id_product = '16514' 16/07/2025 10:54:06 am >> SELECT ean13 FROM ps_product WHERE ean13 = 'PA908' AND id_product != '17399' AND ean13 != '' 16/07/2025 10:54:06 am >> UPDATE ps_product SET id_supplier = '130', reference = '', ean13 = 'PA908', date_upd = NOW() WHERE id_product = '17399' 16/07/2025 10:54:06 am >> UPDATE ps_product_lang SET name = 'MIRACOLOSA CM 80 - PA908', description = '' WHERE id_product = '17399' 16/07/2025 10:54:06 am >> UPDATE ps_product SET wholesale_price = '241.30', on_sale = '0', price = '645.0819672131148' WHERE id_product = '17399' 16/07/2025 10:54:06 am >> UPDATE ps_product_shop SET wholesale_price = '241.30', price = '645.0819672131148', id_tax_rules_group = '1', id_category_default = '165', 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 = '17399' 16/07/2025 10:54:06 am >> DELETE FROM ps_specific_price WHERE id_product = '17399' 16/07/2025 10:56:23 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002243' AND id_product != '22255' AND ean13 != '' 16/07/2025 10:56:24 am >> UPDATE ps_product SET id_supplier = '130', reference = '', ean13 = '002243', date_upd = NOW() WHERE id_product = '22255' 16/07/2025 10:56:24 am >> UPDATE ps_product_lang SET name = 'SAN GIUSEPPE CM 40 - 804', description = '' WHERE id_product = '22255' 16/07/2025 10:56:24 am >> UPDATE ps_product SET wholesale_price = '41.04', on_sale = '0', price = '88.5246' WHERE id_product = '22255' 16/07/2025 10:56:24 am >> UPDATE ps_product_shop SET wholesale_price = '41.04', price = '88.5246', id_tax_rules_group = '1', id_category_default = '165', 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 = '22255' 16/07/2025 10:56:24 am >> DELETE FROM ps_specific_price WHERE id_product = '22255' 16/07/2025 10:56:41 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' , '228/2025' , '2025-07-11' , '2025' , '0' , '130' , '4670548' , 'VIA CARRAIA,4/6/8 55025 COREGLIA ANTELMINELLI' , '' , '' , '50' , '1' , '0' , '0' , '0' , '' , '9' , '0' , '915.39' , '750.32' , NOW() , NOW() ) 16/07/2025 10:56:41 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 = '98110' 16/07/2025 10:56:41 am >> DELETE FROM ps_document_detail WHERE id_document = '98110' 16/07/2025 10:56: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 ( '98110' , '23333' , 'IMMACOLATA DEL MURILLO CM 16 - 270' , '1' , '1' , '1' , '12.96' , '10.622950819672' , '22' , '5' , '15.0206' ) 16/07/2025 10:56:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '23333' AND id_supplier = '130' 16/07/2025 10:56:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23333' , '130' , '1' ) 16/07/2025 10:56: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 ( '98110' , '16514' , 'CROCIFISSO 105X60 - 1015' , '1' , '1' , '1' , '144.72' , '118.62295081967' , '22' , '5' , '167.7305' ) 16/07/2025 10:56:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '16514' AND id_supplier = '130' 16/07/2025 10:56:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16514' , '130' , '1' ) 16/07/2025 10:56: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 ( '98110' , '17399' , 'MIRACOLOSA CM 80 - PA908' , '1' , '1' , '1' , '322.3' , '264.18032786885' , '22' , '5' , '373.5457' ) 16/07/2025 10:56:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '17399' AND id_supplier = '130' 16/07/2025 10:56:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17399' , '130' , '1' ) 16/07/2025 10:56: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 ( '98110' , '18615' , 'SAN ROCCO CM 20 - 340' , '2' , '2' , '1' , '12.96' , '10.622950819672' , '22' , '5' , '30.0413' ) 16/07/2025 10:56:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '18615' AND id_supplier = '130' 16/07/2025 10:56:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18615' , '130' , '1' ) 16/07/2025 10:56: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 ( '98110' , '15666' , 'STATUA MIRACOLOSA CM 60 - PA602' , '1' , '1' , '1' , '90.88' , '74.491803278689' , '22' , '5' , '105.3299' ) 16/07/2025 10:56:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '15666' AND id_supplier = '130' 16/07/2025 10:56:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15666' , '130' , '1' ) 16/07/2025 10:56:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98110' , '15667' , 'SACRO CUORE CM 60 - PA611' , '1' , '1' , '1' , '97.2' , '79.672131147541' , '22' , '5' , '112.6548' ) 16/07/2025 10:56:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '15667' AND id_supplier = '130' 16/07/2025 10:56:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15667' , '130' , '1' ) 16/07/2025 10:56:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98110' , '22255' , 'SAN GIUSEPPE CM 40 - 804' , '1' , '1' , '1' , '43.2' , '35.409836065574' , '22' , '5' , '50.0688' ) 16/07/2025 10:56:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '22255' AND id_supplier = '130' 16/07/2025 10:56:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22255' , '130' , '1' ) 16/07/2025 11:05:28 am >> SELECT ean13 FROM ps_product WHERE ean13 = '75-1635' AND id_product != '17215' AND ean13 != '' 16/07/2025 11:05:28 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '75-1635', date_upd = NOW() WHERE id_product = '17215' 16/07/2025 11:05:28 am >> UPDATE ps_product_lang SET name = 'CASULA LANA TESSUTA A TELAIO', description = '' WHERE id_product = '17215' 16/07/2025 11:05:28 am >> UPDATE ps_product SET wholesale_price = '300.01', on_sale = '0', price = '695.9016393442623' WHERE id_product = '17215' 16/07/2025 11:05:28 am >> UPDATE ps_product_shop SET wholesale_price = '300.01', price = '695.9016393442623', id_tax_rules_group = '1', id_category_default = '450', 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 = '17215' 16/07/2025 11:05:28 am >> DELETE FROM ps_specific_price WHERE id_product = '17215' 16/07/2025 11:06:29 am >> SELECT document_num FROM ps_document WHERE document_num = '2461' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-16') 16/07/2025 11:06: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' , '2461' , '2025-07-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '22.46' , '22.46' , NOW() , NOW() ) 16/07/2025 11:06: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 = '98111' 16/07/2025 11:06:29 am >> DELETE FROM ps_document_detail WHERE id_document = '98111' 16/07/2025 11:06: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 ( '98111' , '23824' , 'PAROLA E PREGHIERA - SET 25' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '5' , '2.76' ) 16/07/2025 11:06: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 ( '98111' , '23714' , 'SULLA TUA PAROLA - SETT/OTT 25' , '4' , '-4' , '4' , '5.00' , '5' , '0' , '5' , '19.00' ) 16/07/2025 11:06: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 ( '98111' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '1' , '-1' , '4' , '0.70' , '0.7' , '0' , '0' , '0.70' ) 16/07/2025 11:16:52 am >> SELECT document_num FROM ps_document WHERE document_num = '2462' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-16') 16/07/2025 11:16:52 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2462' , '2025-07-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.00' , '1.64' , NOW() , NOW() ) 16/07/2025 11:16: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 = '98112' 16/07/2025 11:16:52 am >> DELETE FROM ps_document_detail WHERE id_document = '98112' 16/07/2025 11:16: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 ( '98112' , '18219' , 'CROCE EMATITE CON LACCIO - N169-C' , '1' , '-1' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '2.00' ) 16/07/2025 11:53:46 am >> SELECT document_num FROM ps_document WHERE document_num = '2463' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2025-07-16') 16/07/2025 11:53:46 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2463' , '2025-07-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '36.00' , '29.51' , NOW() , NOW() ) 16/07/2025 11:53:46 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '98113' 16/07/2025 11:53:46 am >> DELETE FROM ps_document_detail WHERE id_document = '98113' 16/07/2025 11:53:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98113' , '2177' , 'CLERGY BASIC - MM - B&P' , '1' , '-1' , '1' , '36' , '29.508196721311' , '22' , '0' , '36.00' ) 16/07/2025 11:54:05 am >> SELECT document_num FROM ps_document WHERE document_num = '2464' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-16') 16/07/2025 11:54:05 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' , '2464' , '2025-07-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.50' , '18.60' , NOW() , NOW() ) 16/07/2025 11:54:05 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '98114' 16/07/2025 11:54:05 am >> DELETE FROM ps_document_detail WHERE id_document = '98114' 16/07/2025 11:54:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98114' , '22603' , 'CATENINA CM 60 - UASS-0025SXL' , '1' , '-1' , '1' , '5.00' , '4.0983606557377' , '22' , '0' , '5.00' ) 16/07/2025 11:54:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98114' , '23714' , 'SULLA TUA PAROLA - SETT/OTT 25' , '2' , '-2' , '4' , '5.00' , '5' , '0' , '5' , '9.50' ) 16/07/2025 11:54:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98114' , '23673' , 'RIVESTITI DI SPERANZA! - V. SIRACUSA' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '0' , '5.00' ) 16/07/2025 12:00:21 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788898577309' AND id_product != '23864' AND ean13 != '' 16/07/2025 12:00:21 pm >> UPDATE ps_product SET id_supplier = '107', reference = '13/2', ean13 = '9788898577309', date_upd = NOW() WHERE id_product = '23864' 16/07/2025 12:00:21 pm >> UPDATE ps_product_lang SET name = 'MARIOLOGIA BIBLICA - S. MANELLI', description = '' WHERE id_product = '23864' 16/07/2025 12:00:21 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '30.0000' WHERE id_product = '23864' 16/07/2025 12:00:21 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '30.0000', id_tax_rules_group = '4', id_category_default = '469', id_argoment_default = '73', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23864' 16/07/2025 12:00:21 pm >> DELETE FROM ps_specific_price WHERE id_product = '23864' 16/07/2025 12:04:02 pm >> SELECT document_num FROM ps_document WHERE document_num = '2465' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-16') 16/07/2025 12:04:02 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2465' , '2025-07-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '20.00' , '19.23' , NOW() , NOW() ) 16/07/2025 12:04:02 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '98115' 16/07/2025 12:04:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '98115' 16/07/2025 12:04:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98115' , '20429' , 'OSTIA SENZA TOSTATURA MORREALE - OS25' , '10' , '-10' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '20.00' ) 16/07/2025 12:27:37 pm >> SELECT document_num FROM ps_document WHERE document_num = '2466' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-16') 16/07/2025 12:27:37 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' , '2466' , '2025-07-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '25.65' , '25.65' , NOW() , NOW() ) 16/07/2025 12:27:37 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 = '98116' 16/07/2025 12:27:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '98116' 16/07/2025 12:27:37 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 ( '98116' , '23689' , 'SULLA TUA PAROLA - LUG/AGO 25' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 16/07/2025 12:27:37 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 ( '98116' , '23714' , 'SULLA TUA PAROLA - SETT/OTT 25' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 16/07/2025 12:27:37 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 ( '98116' , '6317' , 'MEDAGLIA MIRACOLOSA - 8332' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 16/07/2025 12:27:37 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 ( '98116' , '23040' , 'SAN GABRIELE DELLADDOLORATA - 8756' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 16/07/2025 12:41:29 pm >> SELECT document_num FROM ps_document WHERE document_num = '2467' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-16') 16/07/2025 12:41:29 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2467' , '2025-07-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.99' , '8.19' , NOW() , NOW() ) 16/07/2025 12:41:29 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '98117' 16/07/2025 12:41:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '98117' 16/07/2025 12:41:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98117' , '17617' , 'IMMAGINI ISONZO X 100' , '3' , '-3' , '1' , '3.33' , '2.7295081967213' , '22' , '0' , '9.99' ) 16/07/2025 04:03:13 pm >> SELECT document_num FROM ps_document WHERE document_num = '2468' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-16') 16/07/2025 04:03:13 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2468' , '2025-07-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '127.40' , '104.43' , NOW() , NOW() ) 16/07/2025 04:03:13 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '98118' 16/07/2025 04:03:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '98118' 16/07/2025 04:03:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98118' , '9691' , 'SCAPOLARE DEL CARMELO - PICCOLO - 1215/ITA' , '98' , '-98' , '1' , '1.30' , '1.0655737704918' , '22' , '0' , '127.40' ) 16/07/2025 04:13:52 pm >> SELECT document_num FROM ps_document WHERE document_num = '2469' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-16') 16/07/2025 04:13:52 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2469' , '2025-07-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.50' , '8.61' , NOW() , NOW() ) 16/07/2025 04:13:52 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '98119' 16/07/2025 04:13:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '98119' 16/07/2025 04:13:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98119' , '13049' , 'LITURGICO ART. 60LT BIANCO SUPER' , '3' , '-3' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '10.50' ) 16/07/2025 05:30:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '2470' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-16') 16/07/2025 05:30:11 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' , '2470' , '2025-07-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '165.00' , '138.01' , NOW() , NOW() ) 16/07/2025 05:30: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 = '98120' 16/07/2025 05:30:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '98120' 16/07/2025 05:30: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 ( '98120' , '17352' , 'STOLA MARIANA MISTO SETA - 1021 AM' , '1' , '-1' , '1' , '145.5' , '119.26229508197' , '22' , '0' , '145.50' ) 16/07/2025 05:30: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 ( '98120' , '19089' , 'OSTIA MAGNA 150 - OM 150' , '1' , '-1' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '4.50' ) 16/07/2025 05:30: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 ( '98120' , '16689' , 'OSTIA PAN DI CENA mm80' , '4' , '-4' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '8.00' ) 16/07/2025 05:30: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 ( '98120' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 16/07/2025 05:51:07 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '1673765' , '2025-07-15' , '' , '0' , '177' , '4679057' , 'VIA G. VERDI 8 20057 ASSAGO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '120.00' , '120.00' , NOW() , NOW() ) 16/07/2025 05:51:07 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 = '98121' 16/07/2025 05:51:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '98121' 16/07/2025 05:51:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98121' , '21697' , 'ORME SUL CUORE - A. ROMANO' , '10' , '10' , '4' , '12.00' , '12' , '0' , '0' , '120.0000' ) 16/07/2025 05:51:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21697' AND id_supplier = '177' 16/07/2025 05:51:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21697' , '177' , '1' ) 16/07/2025 06:00:24 pm >> SELECT document_num FROM ps_document WHERE document_num = '84' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-07-16') 16/07/2025 06:00:24 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '84' , '2025-07-16' , '' , '161' , '0' , '4679379' , 'VIA G. MAZZINI VICO III, 8 81047 MACERATA CAMPANIA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '161.50' , '161.50' , NOW() , NOW() ) 16/07/2025 06:00:24 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '98122' 16/07/2025 06:00:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '98122' 16/07/2025 06:00:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98122' , '21697' , 'ORME SUL CUORE - A. ROMANO' , '10' , '-10' , '4' , '12.00' , '12' , '0' , '5' , '114.00' ) 16/07/2025 06:00:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98122' , '23862' , 'PONTI NON MURI' , '2' , '-2' , '4' , '25.00' , '25' , '0' , '5' , '47.50' )