09/07/2024 10:08:11 am >> SELECT document_num FROM ps_document WHERE document_num = '2058' AND id_document != '92373' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-21') 09/07/2024 10:08:11 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2058', document_date = '2024-06-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 = '184.00', price_tax_excluded = '151.72', date_upd = NOW() WHERE id_document = '92373' 09/07/2024 10:08:11 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92373' 09/07/2024 10:08:11 am >> DELETE FROM ps_document_detail WHERE id_document = '92373' 09/07/2024 10:08:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92373' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '2' , '-2' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '7.00' ) 09/07/2024 10:08:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92373' , '22414' , 'SULLA TUA PAROLA - LUG/AGO 2024' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '0' , '5.00' ) 09/07/2024 10:08:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92373' , '19594' , 'POLO JERSEY COTONE 100%' , '2' , '-2' , '1' , '41.0000' , '33.606557377049' , '22' , '0' , '82.00' ) 09/07/2024 10:08:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92373' , '20645' , 'DALMATICA - 881' , '1' , '-1' , '1' , '90.00' , '73.770491803279' , '22' , '0' , '90.00' ) 09/07/2024 10:13:23 am >> SELECT document_num FROM ps_document WHERE document_num = '2225' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-09') 09/07/2024 10:13:23 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' , '2225' , '2024-07-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.00' , '1.64' , NOW() , NOW() ) 09/07/2024 10:13:23 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 = '92574' 09/07/2024 10:13:23 am >> DELETE FROM ps_document_detail WHERE id_document = '92574' 09/07/2024 10:13:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92574' , '13357' , 'PORTACHIAVI DEVOZIONALI' , '1' , '-1' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '2.00' ) 09/07/2024 10:14:49 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 09/07/2024 10:14:49 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22739' , '1' , '' , 'nuovo-prodotto' ) 09/07/2024 10:14:49 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '22739' , '1' , '1' , '2' , NOW() , NOW() ) 09/07/2024 10:14:49 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '22739' , '0' , '1' , '0' , '0' ) 09/07/2024 10:16:23 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002288' AND id_product != '22739' AND ean13 != '' 09/07/2024 10:16:23 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002288', date_upd = NOW() WHERE id_product = '22739' 09/07/2024 10:16:23 am >> UPDATE ps_product_lang SET name = 'CASULA RIGHE - 65/002024CRO', description = '' WHERE id_product = '22739' 09/07/2024 10:16:23 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '285.24590163934425' WHERE id_product = '22739' 09/07/2024 10:16:23 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '285.24590163934425', id_tax_rules_group = '1', id_category_default = '468', 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 = '22739' 09/07/2024 10:16:23 am >> DELETE FROM ps_specific_price WHERE id_product = '22739' 09/07/2024 10:17:07 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002288' AND id_product != '22739' AND ean13 != '' 09/07/2024 10:17:07 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002288', date_upd = NOW() WHERE id_product = '22739' 09/07/2024 10:17:07 am >> UPDATE ps_product_lang SET name = 'CASULA RIGHE - 65/002024CRO', description = '' WHERE id_product = '22739' 09/07/2024 10:17:07 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '285.24590163934425' WHERE id_product = '22739' 09/07/2024 10:17:07 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '285.24590163934425', id_tax_rules_group = '1', id_category_default = '468', 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 = '22739' 09/07/2024 10:17:07 am >> DELETE FROM ps_specific_price WHERE id_product = '22739' 09/07/2024 10:17:08 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22739' 09/07/2024 10:17:08 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22740' , '1' , '' , 'nuovo-prodotto' ) 09/07/2024 10:17:08 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22740' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22739' 09/07/2024 10:17:08 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22740' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22739' 09/07/2024 10:18:42 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002289' AND id_product != '22740' AND ean13 != '' 09/07/2024 10:18:42 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002289', date_upd = NOW() WHERE id_product = '22740' 09/07/2024 10:18:42 am >> UPDATE ps_product_lang SET name = 'CASULA RICAMO MANTELLO - 65/019945', description = '' WHERE id_product = '22740' 09/07/2024 10:18:42 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '293.44262295081967' WHERE id_product = '22740' 09/07/2024 10:18:42 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '293.44262295081967', id_tax_rules_group = '1', id_category_default = '468', 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 = '22740' 09/07/2024 10:18:42 am >> DELETE FROM ps_specific_price WHERE id_product = '22740' 09/07/2024 10:18:58 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002289' AND id_product != '22740' AND ean13 != '' 09/07/2024 10:18:58 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002289', date_upd = NOW() WHERE id_product = '22740' 09/07/2024 10:18:58 am >> UPDATE ps_product_lang SET name = 'CASULA RICAMO MANTELLO - 65/019945', description = '' WHERE id_product = '22740' 09/07/2024 10:18:58 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '293.44262295081967' WHERE id_product = '22740' 09/07/2024 10:18:58 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '293.44262295081967', id_tax_rules_group = '1', id_category_default = '468', 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 = '22740' 09/07/2024 10:18:58 am >> DELETE FROM ps_specific_price WHERE id_product = '22740' 09/07/2024 10:19:06 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22740' 09/07/2024 10:19:06 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22741' , '1' , '' , 'nuovo-prodotto' ) 09/07/2024 10:19:06 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22741' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22740' 09/07/2024 10:19:06 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22741' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22740' 09/07/2024 10:20:56 am >> SELECT ean13 FROM ps_product WHERE ean13 = '87/027108' AND id_product != '22741' AND ean13 != '' 09/07/2024 10:20:56 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '87/027108', date_upd = NOW() WHERE id_product = '22741' 09/07/2024 10:20:56 am >> UPDATE ps_product_lang SET name = 'MITRIA MARIANA - 87/027108', description = '' WHERE id_product = '22741' 09/07/2024 10:20:56 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '471.3114754098361' WHERE id_product = '22741' 09/07/2024 10:20:56 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '471.3114754098361', id_tax_rules_group = '1', id_category_default = '468', 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 = '22741' 09/07/2024 10:20:56 am >> DELETE FROM ps_specific_price WHERE id_product = '22741' 09/07/2024 10:20: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 = '22741' 09/07/2024 10:20:58 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22742' , '1' , '' , 'nuovo-prodotto' ) 09/07/2024 10:20: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 '22742' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22741' 09/07/2024 10:20:58 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22742' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22741' 09/07/2024 10:21:31 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' , '1055' , '2024-07-05' , '' , '0' , '143' , '4670947' , 'VIA DELLE SELVETTE 324 55018 SEGROMIGNO IN MONTE CAPANNORI' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '1565.64' , '1283.31' , NOW() , NOW() ) 09/07/2024 10:21:31 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 = '92575' 09/07/2024 10:21:31 am >> DELETE FROM ps_document_detail WHERE id_document = '92575' 09/07/2024 10:21:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92575' , '22739' , 'CASULA RIGHE - 65/002024CRO' , '3' , '3' , '1' , '153' , '125.40983606557' , '22' , '3' , '543.1806' ) 09/07/2024 10:21:31 am >> DELETE FROM ps_product_supplier WHERE id_product = '22739' AND id_supplier = '143' 09/07/2024 10:21:31 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22739' , '143' , '1' ) 09/07/2024 10:21:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92575' , '22740' , 'CASULA RICAMO MANTELLO - 65/019945' , '4' , '4' , '1' , '157' , '128.68852459016' , '22' , '3' , '743.1752' ) 09/07/2024 10:21:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '22740' AND id_supplier = '143' 09/07/2024 10:21:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22740' , '143' , '1' ) 09/07/2024 10:21:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92575' , '22741' , 'MITRIA MARIANA - 87/027108' , '1' , '1' , '1' , '236' , '193.44262295082' , '22' , '3' , '279.2824' ) 09/07/2024 10:21:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '22741' AND id_supplier = '143' 09/07/2024 10:21:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22741' , '143' , '1' ) 09/07/2024 10:40:05 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '690' 09/07/2024 10:40:05 am >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '690' , '10' , '222' , '' , 'ZANBENEDETTI ' , 'DON ARNALDO' , 'VIA MUNICIPIO, 2' , '' , '31014' , 'COLLE UMBERTO' , '' , '0438/39746' , '3406775151' , '' , '' , NOW() , NOW() ) 09/07/2024 10:40:06 am >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '690' 09/07/2024 10:40:27 am >> SELECT document_num FROM ps_document WHERE document_num = '99' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-07-09') 09/07/2024 10:40:27 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' , '99' , '2024-07-09' , '' , '690' , '0' , '4670873' , 'VIA MUNICIPIO, 2 31014 COLLE UMBERTO' , '' , '' , '5' , '4' , '0' , '0' , '0' , '' , '7' , '0' , '35.60' , '35.60' , NOW() , NOW() ) 09/07/2024 10:40:27 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 = '92576' 09/07/2024 10:40:27 am >> DELETE FROM ps_document_detail WHERE id_document = '92576' 09/07/2024 10:40:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92576' , '1041' , 'BENEDIZIONI' , '200' , '-200' , '0' , '0.18' , '0.18' , '' , '15' , '30.60' ) 09/07/2024 10:42:45 am >> SELECT document_num FROM ps_document WHERE document_num = '2226' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-09') 09/07/2024 10:42: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' , '2226' , '2024-07-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.50' , '10.25' , NOW() , NOW() ) 09/07/2024 10:42: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 = '92577' 09/07/2024 10:42:45 am >> DELETE FROM ps_document_detail WHERE id_document = '92577' 09/07/2024 10:42: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 ( '92577' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '50' , '-50' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '12.50' ) 09/07/2024 11:14:09 am >> SELECT document_num FROM ps_document WHERE document_num = '2227' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-09') 09/07/2024 11:14:09 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' , '2227' , '2024-07-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.50' , '2.05' , NOW() , NOW() ) 09/07/2024 11:14:09 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 = '92578' 09/07/2024 11:14:09 am >> DELETE FROM ps_document_detail WHERE id_document = '92578' 09/07/2024 11:14:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92578' , '12228' , 'MEDAGLIA OVALE FATIMA' , '10' , '-10' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '2.50' ) 09/07/2024 11:16:49 am >> SELECT document_num FROM ps_document WHERE document_num = '2228' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-09') 09/07/2024 11:16:49 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2228' , '2024-07-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '32.00' , '26.23' , NOW() , NOW() ) 09/07/2024 11:16:49 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92579' 09/07/2024 11:16:49 am >> DELETE FROM ps_document_detail WHERE id_document = '92579' 09/07/2024 11:16:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92579' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '32' , '26.229508196721' , '22' , '0' , '32.00' ) 09/07/2024 11:52:42 am >> SELECT document_num FROM ps_document WHERE document_num = '2229' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-09') 09/07/2024 11:52:42 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' , '2229' , '2024-07-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.50' , '2.05' , NOW() , NOW() ) 09/07/2024 11:52:42 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 = '92580' 09/07/2024 11:52:42 am >> DELETE FROM ps_document_detail WHERE id_document = '92580' 09/07/2024 11:52: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 ( '92580' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '2.50' ) 09/07/2024 03:01:53 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884047700' AND id_product != '19587' AND ean13 != '' 09/07/2024 03:01:53 pm >> UPDATE ps_product SET id_supplier = '38', reference = 'ESPOSITORE SHALOM', ean13 = '9788884047700', date_upd = NOW() WHERE id_product = '19587' 09/07/2024 03:01:53 pm >> UPDATE ps_product_lang SET name = 'GESU\' BAMBINO DI PRAGA - 8079', description = '' WHERE id_product = '19587' 09/07/2024 03:01:53 pm >> UPDATE ps_product SET wholesale_price = '1.80', on_sale = '0', price = '3.0000' WHERE id_product = '19587' 09/07/2024 03:01:53 pm >> UPDATE ps_product_shop SET wholesale_price = '1.80', price = '3.0000', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '28', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19587' 09/07/2024 03:01:53 pm >> DELETE FROM ps_specific_price WHERE id_product = '19587' 09/07/2024 04:59:01 pm >> SELECT document_num FROM ps_document WHERE document_num = '2230' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-09') 09/07/2024 04:59:01 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' , '2230' , '2024-07-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '93.90' , '80.87' , NOW() , NOW() ) 09/07/2024 04:59:01 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 = '92581' 09/07/2024 04:59:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '92581' 09/07/2024 04:59:01 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 ( '92581' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 09/07/2024 04:59:01 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 ( '92581' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '5' , '-5' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '17.50' ) 09/07/2024 04:59:01 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 ( '92581' , '7311' , 'OSTIA SOTTILE 74MM' , '5' , '-5' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '10.00' ) 09/07/2024 04:59:01 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 ( '92581' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 09/07/2024 05:41:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '1940' AND id_document != '92238' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-10') 09/07/2024 05:41:19 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1940', document_date = '2024-06-10', 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 = '190.00', price_tax_excluded = '155.74', date_upd = NOW() WHERE id_document = '92238' 09/07/2024 05:41:19 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 = '92238' 09/07/2024 05:41:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '92238' 09/07/2024 05:41:19 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 ( '92238' , '17037' , 'CLERGY M/LINO MM ' , '2' , '-2' , '1' , '60.0000' , '49.180327868852' , '22' , '0' , '120.00' ) 09/07/2024 05:41:19 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 ( '92238' , '21132' , 'CLERGY F/F MC - C03' , '1' , '-1' , '1' , '37.5000' , '30.737704918033' , '22' , '0' , '37.50' ) 09/07/2024 05:41:19 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 ( '92238' , '21132' , 'CLERGY F/F MC - C03' , '1' , '-1' , '1' , '32.5' , '26.639344262295' , '22' , '0' , '32.50' ) 09/07/2024 05:41:35 pm >> SELECT document_num FROM ps_document WHERE document_num = '1957' AND id_document != '92259' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-12') 09/07/2024 05:41:35 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1957', document_date = '2024-06-12', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '20.00', price_tax_excluded = '16.39', date_upd = NOW() WHERE id_document = '92259' 09/07/2024 05:41:35 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 = '92259' 09/07/2024 05:41:35 pm >> DELETE FROM ps_document_detail WHERE id_document = '92259' 09/07/2024 05:41:35 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 ( '92259' , '13611' , 'QUADRO DECORATO DA APPOGGIO 23X14' , '1' , '-1' , '1' , '20' , '16.393442622951' , '22' , '0' , '20.00' ) 09/07/2024 07:05:36 pm >> SELECT document_num FROM ps_document WHERE document_num = '2231' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-09') 09/07/2024 07:05:36 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' , '2231' , '2024-07-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.50' , '8.50' , NOW() , NOW() ) 09/07/2024 07:05:36 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 = '92582' 09/07/2024 07:05:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '92582' 09/07/2024 07:05:36 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 ( '92582' , '22446' , 'PREGARE CON SANTI E PECCATORI - 4' , '1' , '-1' , '4' , '8.50' , '8.5' , '0' , '0' , '8.50' ) 09/07/2024 07:11:53 pm >> SELECT document_num FROM ps_document WHERE document_num = '1533' AND id_document != '91736' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-10') 09/07/2024 07:11:53 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1533', document_date = '2024-05-10', 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 = '207.10', price_tax_excluded = '172.84', date_upd = NOW() WHERE id_document = '91736' 09/07/2024 07:11:53 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 = '91736' 09/07/2024 07:11:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '91736' 09/07/2024 07:11:54 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 ( '91736' , '22515' , 'BORSA PORTAELEMOSINA CON LUCCHETTO - 750/L' , '2' , '-2' , '1' , '95.0000' , '77.868852459016' , '22' , '0' , '190.00' ) 09/07/2024 07:11:54 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 ( '91736' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '17.1' , '17.1' , '0' , '0' , '17.10' ) 09/07/2024 07:25: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 ( '32' , '1495/2024' , '2024-07-09' , '2024' , '0' , '43' , '2638' , 'VIA COSTABIANCA, 43 60025 LORETO' , '' , '' , '10.8' , '1' , '0' , '0' , '0' , '' , '9' , '0' , '276.57' , '226.70' , NOW() , NOW() ) 09/07/2024 07:25: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 = '92583' 09/07/2024 07:25:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '92583' 09/07/2024 07:25: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 ( '92583' , '22736' , 'MEDAGLIA CARLO ACUTIS SMALTATA - G474-OX' , '100' , '0' , '1' , '0.2900' , '0.2377' , '22' , '10' , '31.84' ) 09/07/2024 07:25:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22736' AND id_supplier = '43' 09/07/2024 07:25:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22736' , '43' , '1' ) 09/07/2024 07:25: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 ( '92583' , '20964' , 'STATUA SAN MICHELE - ST322-SM' , '1' , '0' , '1' , '5.5700' , '4.5656' , '22' , '10' , '6.12' ) 09/07/2024 07:25:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20964' AND id_supplier = '43' 09/07/2024 07:25:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20964' , '43' , '1' ) 09/07/2024 07:25: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 ( '92583' , '19231' , 'CARD CARLO ACUTIS - RN93' , '100' , '0' , '1' , '0.4200' , '0.3443' , '22' , '10' , '46.12' ) 09/07/2024 07:25:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19231' AND id_supplier = '43' 09/07/2024 07:25:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19231' , '43' , '1' ) 09/07/2024 07:25: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 ( '92583' , '22733' , 'BRACCIALE ELASTICO - RL436/435' , '48' , '0' , '1' , '0.9200' , '0.7541' , '22' , '10' , '48.49' ) 09/07/2024 07:25:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22733' AND id_supplier = '43' 09/07/2024 07:25:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22733' , '43' , '1' ) 09/07/2024 07:25:53 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 ( '92583' , '22737' , 'MEDAGLIA SAN BENEDETTO ARG - RA812' , '1' , '0' , '1' , '8.6000' , '7.0492' , '22' , '10' , '9.44' ) 09/07/2024 07:25:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22737' AND id_supplier = '43' 09/07/2024 07:25:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22737' , '43' , '1' ) 09/07/2024 07:25:53 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 ( '92583' , '17607' , 'BRACCIALE BICOLORE ARG.- SL095' , '1' , '0' , '1' , '13.5200' , '11.082' , '22' , '10' , '14.85' ) 09/07/2024 07:25:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17607' AND id_supplier = '43' 09/07/2024 07:25:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17607' , '43' , '1' ) 09/07/2024 07:25:53 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 ( '92583' , '22735' , 'MEDAGLIA SANTANTONIO - G022-25' , '100' , '0' , '1' , '0.1014' , '0.0831' , '22' , '0' , '12.37' ) 09/07/2024 07:25:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22735' AND id_supplier = '43' 09/07/2024 07:25:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22735' , '43' , '1' ) 09/07/2024 07:25:53 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 ( '92583' , '20970' , 'CROCE LEGNO S. BENEDETTO - PG681' , '2' , '0' , '1' , '13.5000' , '11.0656' , '22' , '10' , '29.65' ) 09/07/2024 07:25:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20970' AND id_supplier = '43' 09/07/2024 07:25:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20970' , '43' , '1' ) 09/07/2024 07:25:53 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 ( '92583' , '22734' , 'CROCE SAN BENEDETTO - PG680BR' , '1' , '0' , '1' , '6.9000' , '5.6557' , '22' , '10' , '7.58' ) 09/07/2024 07:25:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22734' AND id_supplier = '43' 09/07/2024 07:25:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22734' , '43' , '1' ) 09/07/2024 07:25:53 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 ( '92583' , '17784' , 'MEDAGLIA S. BENEDETTO MET. OX - Q1010-OX' , '1' , '0' , '1' , '8.3500' , '6.8443' , '22' , '10' , '9.17' ) 09/07/2024 07:25:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17784' AND id_supplier = '43' 09/07/2024 07:25:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17784' , '43' , '1' ) 09/07/2024 07:25:53 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 ( '92583' , '21848' , 'PORTACHIAVI ACUTIS - PC240' , '50' , '0' , '1' , '0.87' , '0.71311475409836' , '22' , '10' , '47.7630' ) 09/07/2024 07:25:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21848' AND id_supplier = '43' 09/07/2024 07:25:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21848' , '43' , '1' ) 09/07/2024 07:26:13 pm >> UPDATE ps_document SET id_document_type = '33', document_num = '1786', document_date = '2024-07-05', document_letter = '', id_customer = '0', id_supplier = '', id_address = '2638', address1 = 'VIA COSTABIANCA, 43 60025 LORETO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '9', id_causal = '0', price_tax_included = '263.39', price_tax_excluded = '215.90', date_upd = NOW() WHERE id_document = '92571' 09/07/2024 07:26: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 = '92571' 09/07/2024 07:26:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '92571' 09/07/2024 07:26: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 ( '92571' , '22736' , 'MEDAGLIA CARLO ACUTIS SMALTATA - G474-OX' , '100' , '100' , '1' , '0.2900' , '0.23770491803279' , '22' , '10' , '31.84' ) 09/07/2024 07:26: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 ( '92571' , '20964' , 'STATUA SAN MICHELE - ST322-SM' , '1' , '1' , '1' , '5.5700' , '4.5655737704918' , '22' , '10' , '6.12' ) 09/07/2024 07:26: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 ( '92571' , '19231' , 'CARD CARLO ACUTIS - RN93' , '100' , '100' , '1' , '0.4200' , '0.34426229508197' , '22' , '10' , '46.12' ) 09/07/2024 07:26: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 ( '92571' , '22733' , 'BRACCIALE ELASTICO - RL436/435' , '48' , '48' , '1' , '0.9200' , '0.75409836065574' , '22' , '10' , '48.49' ) 09/07/2024 07:26: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 ( '92571' , '22737' , 'MEDAGLIA SAN BENEDETTO ARG - RA812' , '1' , '1' , '1' , '8.6000' , '7.0491803278689' , '22' , '10' , '9.44' ) 09/07/2024 07:26: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 ( '92571' , '17607' , 'BRACCIALE BICOLORE ARG.- SL095' , '1' , '1' , '1' , '13.5200' , '11.081967213115' , '22' , '10' , '14.85' ) 09/07/2024 07:26: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 ( '92571' , '22735' , 'MEDAGLIA SANTANTONIO - G022-25' , '100' , '100' , '1' , '0.1014' , '0.083114754098361' , '22' , '0' , '12.37' ) 09/07/2024 07:26: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 ( '92571' , '20970' , 'CROCE LEGNO S. BENEDETTO - PG681' , '2' , '2' , '1' , '13.5000' , '11.065573770492' , '22' , '10' , '29.65' ) 09/07/2024 07:26: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 ( '92571' , '22734' , 'CROCE SAN BENEDETTO - PG680BR' , '1' , '1' , '1' , '6.9000' , '5.655737704918' , '22' , '10' , '7.58' ) 09/07/2024 07:26: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 ( '92571' , '17784' , 'MEDAGLIA S. BENEDETTO MET. OX - Q1010-OX' , '1' , '1' , '1' , '8.3500' , '6.844262295082' , '22' , '10' , '9.17' ) 09/07/2024 07:26: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 ( '92571' , '21848' , 'PORTACHIAVI ACUTIS - PC240' , '50' , '50' , '1' , '0.87' , '0.71311475409836' , '22' , '10' , '47.7630' ) 09/07/2024 07:32:02 pm >> SELECT document_num FROM ps_document WHERE document_num = '2232' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-09') 09/07/2024 07:32: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' , '2232' , '2024-07-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '0.50' , '0.41' , NOW() , NOW() ) 09/07/2024 07:32: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 = '92584' 09/07/2024 07:32:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '92584' 09/07/2024 07:32: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 ( '92584' , '7940' , 'PERGAMENE - OCCASIONI MOD. A' , '1' , '-1' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '0.50' )