19/09/2024 10:32:35 am >> SELECT document_num FROM ps_document WHERE document_num = '2728' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-19') 19/09/2024 10:32:35 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' , '2728' , '2024-09-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '104.50' , '104.50' , NOW() , NOW() ) 19/09/2024 10:32:35 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93196' 19/09/2024 10:32:35 am >> DELETE FROM ps_document_detail WHERE id_document = '93196' 19/09/2024 10:32:36 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 ( '93196' , '17329' , 'MESSALE ROMANO DALTARE N.E' , '1' , '-1' , '4' , '110.00' , '110' , '0' , '5' , '104.50' ) 19/09/2024 10:43:02 am >> SELECT ean13 FROM ps_product WHERE ean13 = '12-779' AND id_product != '22305' AND ean13 != '' 19/09/2024 10:43:02 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '12-779', date_upd = NOW() WHERE id_product = '22305' 19/09/2024 10:43:02 am >> UPDATE ps_product_lang SET name = 'NAVETTA CM 13', description = '' WHERE id_product = '22305' 19/09/2024 10:43:02 am >> UPDATE ps_product SET wholesale_price = '9.09', on_sale = '0', price = '20.4918' WHERE id_product = '22305' 19/09/2024 10:43:02 am >> UPDATE ps_product_shop SET wholesale_price = '9.09', price = '20.4918', id_tax_rules_group = '1', id_category_default = '394', 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 = '22305' 19/09/2024 10:43:02 am >> DELETE FROM ps_specific_price WHERE id_product = '22305' 19/09/2024 11:00:20 am >> SELECT document_num FROM ps_document WHERE document_num = '2729' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-19') 19/09/2024 11:00:20 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2729' , '2024-09-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '50.00' , '50.00' , NOW() , NOW() ) 19/09/2024 11:00:20 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93197' 19/09/2024 11:00:20 am >> DELETE FROM ps_document_detail WHERE id_document = '93197' 19/09/2024 11:00:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93197' , '21436' , 'MIA IMPRONTA NELLA TUA - CALENDALBUM 1 - N.E.' , '10' , '-10' , '4' , '5.00' , '5' , '0' , '5' , '47.50' ) 19/09/2024 11:00:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93197' , '17583' , 'FRATELLI TUTTI' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '0' , '2.50' ) 19/09/2024 11:03:05 am >> SELECT document_num FROM ps_document WHERE document_num = '2730' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-19') 19/09/2024 11:03: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' , '2730' , '2024-09-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '140.00' , '114.75' , NOW() , NOW() ) 19/09/2024 11:03: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 = '93198' 19/09/2024 11:03:05 am >> DELETE FROM ps_document_detail WHERE id_document = '93198' 19/09/2024 11:03: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 ( '93198' , '2168' , 'CLERGY BASIC - ML - B&P' , '4' , '-4' , '1' , '35' , '28.688524590164' , '22' , '0' , '140.00' ) 19/09/2024 11:05:23 am >> SELECT document_num FROM ps_document WHERE document_num = '2731' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-19') 19/09/2024 11:05: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' , '2731' , '2024-09-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '54.60' , '45.69' , NOW() , NOW() ) 19/09/2024 11:05: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 = '93199' 19/09/2024 11:05:23 am >> DELETE FROM ps_document_detail WHERE id_document = '93199' 19/09/2024 11:05: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 ( '93199' , '16535' , 'CLERGY MARANGEL ML - C20' , '1' , '-1' , '1' , '48.00' , '39.344262295082' , '22' , '0' , '48.00' ) 19/09/2024 11:05:24 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 ( '93199' , '20431' , 'PARTICOLA TAGLIO CHIUSO 35MM - W500' , '2' , '-2' , '3' , '3.30' , '3.1730769230769' , '4' , '0' , '6.60' ) 19/09/2024 11:06:59 am >> SELECT document_num FROM ps_document WHERE document_num = '2732' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-19') 19/09/2024 11:06:59 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' , '2732' , '2024-09-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.50' , '9.50' , NOW() , NOW() ) 19/09/2024 11:06:59 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 = '93200' 19/09/2024 11:06:59 am >> DELETE FROM ps_document_detail WHERE id_document = '93200' 19/09/2024 11:06:59 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 ( '93200' , '22693' , 'SULLA TUA PAROLA - SET/OTT 2024' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 19/09/2024 11:06:59 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 ( '93200' , '22845' , 'SULLA TUA PAROLA - NOV/DIC 24' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 19/09/2024 11:17:13 am >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'kV2qnjBSBc3M95cF' , NOW() , NOW() ) 19/09/2024 11:17:13 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4115' , '1' ) 19/09/2024 11:17:13 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4115' , '2' ) 19/09/2024 11:17:13 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4115' , '3' ) 19/09/2024 11:18:45 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4115' 19/09/2024 11:18:45 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 ( '4115' , '10' , '229' , '' , 'MERLIN' , 'MARTA' , 'VIA DON LUIGI BENASSUTI 37' , '' , '37053' , 'CEREA' , '' , '' , '3479340762' , '' , '' , NOW() , NOW() ) 19/09/2024 11:18:45 am >> UPDATE ps_customer SET email = 'martamerlin@libero.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4115' 19/09/2024 11:19:10 am >> SELECT document_num FROM ps_document WHERE document_num = '117' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-09-19') 19/09/2024 11:19:10 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' , '117' , '2024-09-19' , '' , '4115' , '0' , '4679354' , 'VIA DON LUIGI BENASSUTI 37 37053 CEREA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '85.50' , '85.50' , NOW() , NOW() ) 19/09/2024 11:19:10 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 = '93201' 19/09/2024 11:19:10 am >> DELETE FROM ps_document_detail WHERE id_document = '93201' 19/09/2024 11:19:10 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 ( '93201' , '8408' , 'PRENDETE E MANGIATE' , '30' , '-30' , '4' , '3.00' , '3' , '0' , '5' , '85.50' ) 19/09/2024 11:44:53 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 19/09/2024 11:44:53 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22928' , '1' , '' , 'nuovo-prodotto' ) 19/09/2024 11:44:53 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '22928' , '1' , '1' , '2' , NOW() , NOW() ) 19/09/2024 11:44:53 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '22928' , '0' , '1' , '0' , '0' ) 19/09/2024 11:45:55 am >> SELECT ean13 FROM ps_product WHERE ean13 = '1000000015089' AND id_product != '22928' AND ean13 != '' 19/09/2024 11:45:55 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '1000000015089', date_upd = NOW() WHERE id_product = '22928' 19/09/2024 11:45:55 am >> UPDATE ps_product_lang SET name = 'CANDELABRO CM 40 - 621', description = '' WHERE id_product = '22928' 19/09/2024 11:45:55 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '178.68852459016395' WHERE id_product = '22928' 19/09/2024 11:45:55 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '178.68852459016395', id_tax_rules_group = '1', id_category_default = '147', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22928' 19/09/2024 11:45:55 am >> DELETE FROM ps_specific_price WHERE id_product = '22928' 19/09/2024 11:45:56 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 = '22928' 19/09/2024 11:45:56 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22929' , '1' , '' , 'nuovo-prodotto' ) 19/09/2024 11:45:56 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 '22929' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22928' 19/09/2024 11:45:56 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22929' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22928' 19/09/2024 11:46:42 am >> SELECT document_num FROM ps_document WHERE document_num = '2733' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-19') 19/09/2024 11:46: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' , '2733' , '2024-09-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.90' , '10.30' , NOW() , NOW() ) 19/09/2024 11:46: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 = '93202' 19/09/2024 11:46:42 am >> DELETE FROM ps_document_detail WHERE id_document = '93202' 19/09/2024 11:46: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 ( '93202' , '7098' , 'NOVENA A MARIA CHE SCIOGLIE I NODI - 8558' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '0' , '3.00' ) 19/09/2024 11:46: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 ( '93202' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.90' , '7.2950819672131' , '22' , '0' , '8.90' ) 19/09/2024 11:47:16 am >> SELECT ean13 FROM ps_product WHERE ean13 = '1000000015096' AND id_product != '22929' AND ean13 != '' 19/09/2024 11:47:16 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '1000000015096', date_upd = NOW() WHERE id_product = '22929' 19/09/2024 11:47:16 am >> UPDATE ps_product_lang SET name = 'CANDELABRO CM 30 - 622', description = '' WHERE id_product = '22929' 19/09/2024 11:47:16 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '110.65573770491804' WHERE id_product = '22929' 19/09/2024 11:47:16 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '110.65573770491804', id_tax_rules_group = '1', id_category_default = '147', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22929' 19/09/2024 11:47:16 am >> DELETE FROM ps_specific_price WHERE id_product = '22929' 19/09/2024 11:47:17 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 = '22929' 19/09/2024 11:47:17 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22930' , '1' , '' , 'nuovo-prodotto' ) 19/09/2024 11:47:17 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 '22930' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22929' 19/09/2024 11:47:17 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22930' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22929' 19/09/2024 11:48:03 am >> SELECT ean13 FROM ps_product WHERE ean13 = '1000000015355' AND id_product != '22930' AND ean13 != '' 19/09/2024 11:48:03 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '1000000015355', date_upd = NOW() WHERE id_product = '22930' 19/09/2024 11:48:04 am >> UPDATE ps_product_lang SET name = 'CANDELABRO CM 20 - 645', description = '' WHERE id_product = '22930' 19/09/2024 11:48:04 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '61.47540983606557' WHERE id_product = '22930' 19/09/2024 11:48:04 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '61.47540983606557', id_tax_rules_group = '1', id_category_default = '147', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22930' 19/09/2024 11:48:04 am >> DELETE FROM ps_specific_price WHERE id_product = '22930' 19/09/2024 11:56:42 am >> SELECT ean13 FROM ps_product WHERE ean13 = '1000000015355' AND id_product != '22930' AND ean13 != '' 19/09/2024 11:56:42 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '1000000015355', date_upd = NOW() WHERE id_product = '22930' 19/09/2024 11:56:42 am >> UPDATE ps_product_lang SET name = 'CANDELABRO CM 20 - 645', description = '' WHERE id_product = '22930' 19/09/2024 11:56:42 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '61.47540983606557' WHERE id_product = '22930' 19/09/2024 11:56:42 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '61.47540983606557', id_tax_rules_group = '1', id_category_default = '147', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22930' 19/09/2024 11:56:42 am >> DELETE FROM ps_specific_price WHERE id_product = '22930' 19/09/2024 11:56:44 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 = '22930' 19/09/2024 11:56:44 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22931' , '1' , '' , 'nuovo-prodotto' ) 19/09/2024 11:56:44 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 '22931' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22930' 19/09/2024 11:56:44 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22931' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22930' 19/09/2024 11:56:58 am >> SELECT document_num FROM ps_document WHERE document_num = '2734' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-19') 19/09/2024 11:56:58 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2734' , '2024-09-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '90.00' , '73.77' , NOW() , NOW() ) 19/09/2024 11:56:58 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93203' 19/09/2024 11:56:58 am >> DELETE FROM ps_document_detail WHERE id_document = '93203' 19/09/2024 11:56:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93203' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '90' , '73.770491803279' , '22' , '0' , '90.00' ) 19/09/2024 11:58:32 am >> SELECT document_num FROM ps_document WHERE document_num = '2735' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-19') 19/09/2024 11:58:32 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2735' , '2024-09-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '46.20' , '41.23' , NOW() , NOW() ) 19/09/2024 11:58:32 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93204' 19/09/2024 11:58:32 am >> DELETE FROM ps_document_detail WHERE id_document = '93204' 19/09/2024 11:58: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 ( '93204' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 19/09/2024 11:58: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 ( '93204' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 19/09/2024 11:58: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 ( '93204' , '11389' , 'VINO ROSSO DOLCE - 103' , '1' , '-1' , '1' , '8.90' , '7.2950819672131' , '22' , '0' , '8.90' ) 19/09/2024 11:58: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 ( '93204' , '1914' , 'CERA DELLA LITURGIA' , '1' , '-1' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '4.90' ) 19/09/2024 11:58: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 ( '93204' , '22911' , 'AGENDA LITURGICO PASTORALE 2025 - 40821' , '1' , '-1' , '1' , '12.00' , '9.8360655737705' , '22' , '5' , '11.40' ) 19/09/2024 11:58: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 ( '93204' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '10' , '10' , '0' , '0' , '10.00' ) 19/09/2024 12:03:08 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '' AND id_product != '22931' AND ean13 != '' 19/09/2024 12:03:08 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '', date_upd = NOW() WHERE id_product = '22931' 19/09/2024 12:03:08 pm >> UPDATE ps_product_lang SET name = ' FINTA CANDELA CON CARTUCCIA 3,2 X 25 - 1131', description = '' WHERE id_product = '22931' 19/09/2024 12:03:08 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '18.852459016393443' WHERE id_product = '22931' 19/09/2024 12:03:08 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '18.852459016393443', id_tax_rules_group = '1', id_category_default = '147', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22931' 19/09/2024 12:03:08 pm >> DELETE FROM ps_specific_price WHERE id_product = '22931' 19/09/2024 12:03:09 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22931' 19/09/2024 12:03:09 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22932' , '1' , '' , 'nuovo-prodotto' ) 19/09/2024 12:03:09 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22932' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22931' 19/09/2024 12:03:09 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22932' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22931' 19/09/2024 12:04:19 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '1000000031393' AND id_product != '16409' AND ean13 != '' 19/09/2024 12:04:19 pm >> UPDATE ps_product SET id_supplier = '12', reference = '', ean13 = '1000000031393', date_upd = NOW() WHERE id_product = '16409' 19/09/2024 12:04:19 pm >> UPDATE ps_product_lang SET name = 'RICAMBIO VETRO - 32/V', description = '' WHERE id_product = '16409' 19/09/2024 12:04:19 pm >> UPDATE ps_product SET wholesale_price = '6.18', on_sale = '0', price = '13.032786885245903' WHERE id_product = '16409' 19/09/2024 12:04:19 pm >> UPDATE ps_product_shop SET wholesale_price = '6.18', price = '13.032786885245903', id_tax_rules_group = '1', id_category_default = '147', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '16409' 19/09/2024 12:04:19 pm >> DELETE FROM ps_specific_price WHERE id_product = '16409' 19/09/2024 12:09:42 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000608' AND id_product != '540' AND ean13 != '' 19/09/2024 12:09:42 pm >> UPDATE ps_product SET id_supplier = '12', reference = '2014', ean13 = '000608', date_upd = NOW() WHERE id_product = '540' 19/09/2024 12:09:42 pm >> UPDATE ps_product_lang SET name = 'AMPOLLE ALTARE FUSIONE DORATA - 504 ', description = '' WHERE id_product = '540' 19/09/2024 12:09:42 pm >> UPDATE ps_product SET wholesale_price = '48.45', on_sale = '0', price = '110.65573770491804' WHERE id_product = '540' 19/09/2024 12:09:42 pm >> UPDATE ps_product_shop SET wholesale_price = '48.45', price = '110.65573770491804', id_tax_rules_group = '1', id_category_default = '147', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '540' 19/09/2024 12:09:42 pm >> DELETE FROM ps_specific_price WHERE id_product = '540' 19/09/2024 12:12:13 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001170' AND id_product != '15357' AND ean13 != '' 19/09/2024 12:12:13 pm >> UPDATE ps_product SET id_supplier = '12', reference = '', ean13 = '001170', date_upd = NOW() WHERE id_product = '15357' 19/09/2024 12:12:13 pm >> UPDATE ps_product_lang SET name = 'AMPOLLE ABBRACCIO NIKEL - 1512', description = '' WHERE id_product = '15357' 19/09/2024 12:12:13 pm >> UPDATE ps_product SET wholesale_price = '34.58', on_sale = '0', price = '81.9672131147541' WHERE id_product = '15357' 19/09/2024 12:12:14 pm >> UPDATE ps_product_shop SET wholesale_price = '34.58', price = '81.9672131147541', id_tax_rules_group = '1', id_category_default = '147', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '15357' 19/09/2024 12:12:14 pm >> DELETE FROM ps_specific_price WHERE id_product = '15357' 19/09/2024 12:12:49 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001170' AND id_product != '15357' AND ean13 != '' 19/09/2024 12:12:49 pm >> UPDATE ps_product SET id_supplier = '12', reference = '', ean13 = '001170', date_upd = NOW() WHERE id_product = '15357' 19/09/2024 12:12:49 pm >> UPDATE ps_product_lang SET name = 'AMPOLLE ABBRACCIO NIKEL - 1512', description = '' WHERE id_product = '15357' 19/09/2024 12:12:49 pm >> UPDATE ps_product SET wholesale_price = '34.58', on_sale = '0', price = '83.60655737704919' WHERE id_product = '15357' 19/09/2024 12:12:49 pm >> UPDATE ps_product_shop SET wholesale_price = '34.58', price = '83.60655737704919', id_tax_rules_group = '1', id_category_default = '147', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '15357' 19/09/2024 12:12:49 pm >> DELETE FROM ps_specific_price WHERE id_product = '15357' 19/09/2024 12:14:47 pm >> SELECT document_num FROM ps_document WHERE document_num = '2736' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-19') 19/09/2024 12:14:47 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' , '2736' , '2024-09-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.00' , '4.92' , NOW() , NOW() ) 19/09/2024 12:14:47 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 = '93205' 19/09/2024 12:14:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '93205' 19/09/2024 12:14:47 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 ( '93205' , '1912' , 'CERA DELL\'EREMO - 415/B ' , '1' , '-1' , '1' , '6.00' , '4.9180327868852' , '22' , '0' , '6.00' ) 19/09/2024 12:23:08 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '1000000003659' AND id_product != '22931' AND ean13 != '' 19/09/2024 12:23:08 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '1000000003659', date_upd = NOW() WHERE id_product = '22931' 19/09/2024 12:23:08 pm >> UPDATE ps_product_lang SET name = ' FINTA CANDELA CON CARTUCCIA 3,2 X 25 - 1131', description = '' WHERE id_product = '22931' 19/09/2024 12:23:08 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '18.8525' WHERE id_product = '22931' 19/09/2024 12:23:08 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '18.8525', id_tax_rules_group = '1', id_category_default = '147', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22931' 19/09/2024 12:23:08 pm >> DELETE FROM ps_specific_price WHERE id_product = '22931' 19/09/2024 12:30:08 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '1000000005783' AND id_product != '22932' AND ean13 != '' 19/09/2024 12:30:08 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '1000000005783', date_upd = NOW() WHERE id_product = '22932' 19/09/2024 12:30:08 pm >> UPDATE ps_product_lang SET name = 'AMPOLLE - 1502', description = '' WHERE id_product = '22932' 19/09/2024 12:30:08 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '56.55737704918033' WHERE id_product = '22932' 19/09/2024 12:30:08 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '56.55737704918033', id_tax_rules_group = '1', id_category_default = '147', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22932' 19/09/2024 12:30:08 pm >> DELETE FROM ps_specific_price WHERE id_product = '22932' 19/09/2024 12:30:10 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22932' 19/09/2024 12:30:10 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22933' , '1' , '' , 'nuovo-prodotto' ) 19/09/2024 12:30:10 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22933' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22932' 19/09/2024 12:30:10 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22933' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22932' 19/09/2024 12:30:49 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001311' AND id_product != '16408' AND ean13 != '' 19/09/2024 12:30:49 pm >> UPDATE ps_product SET id_supplier = '12', reference = '', ean13 = '001311', date_upd = NOW() WHERE id_product = '16408' 19/09/2024 12:30:49 pm >> UPDATE ps_product_lang SET name = 'AMPOLLE DORATE CON BECCUCCIO - 1503', description = '' WHERE id_product = '16408' 19/09/2024 12:30:49 pm >> UPDATE ps_product SET wholesale_price = '30.40', on_sale = '0', price = '67.21311475409836' WHERE id_product = '16408' 19/09/2024 12:30:49 pm >> UPDATE ps_product_shop SET wholesale_price = '30.40', price = '67.21311475409836', id_tax_rules_group = '1', id_category_default = '147', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '16408' 19/09/2024 12:30:49 pm >> DELETE FROM ps_specific_price WHERE id_product = '16408' 19/09/2024 12:35:49 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '' AND id_product != '22933' AND ean13 != '' 19/09/2024 12:35:49 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '', date_upd = NOW() WHERE id_product = '22933' 19/09/2024 12:35:49 pm >> UPDATE ps_product_lang SET name = 'BORSA CELEBRAZIONI - 1904', description = '' WHERE id_product = '22933' 19/09/2024 12:35:50 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '344.26229508196724' WHERE id_product = '22933' 19/09/2024 12:35:50 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '344.26229508196724', id_tax_rules_group = '1', id_category_default = '147', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22933' 19/09/2024 12:35:50 pm >> DELETE FROM ps_specific_price WHERE id_product = '22933' 19/09/2024 12:35:51 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22933' 19/09/2024 12:35:51 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22934' , '1' , '' , 'nuovo-prodotto' ) 19/09/2024 12:35:51 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22934' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22933' 19/09/2024 12:35:51 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22934' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22933' 19/09/2024 12:36:13 pm >> SELECT document_num FROM ps_document WHERE document_num = '2737' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-19') 19/09/2024 12:36: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' , '2737' , '2024-09-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.00' , '1.00' , NOW() , NOW() ) 19/09/2024 12:36: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 = '93206' 19/09/2024 12:36:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '93206' 19/09/2024 12:36: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 ( '93206' , '22846' , 'CALENDARIO LITURGICO 2025 - 8665' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 19/09/2024 12:36:46 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '1000000007817' AND id_product != '22933' AND ean13 != '' 19/09/2024 12:36:46 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '1000000007817', date_upd = NOW() WHERE id_product = '22933' 19/09/2024 12:36:46 pm >> UPDATE ps_product_lang SET name = 'BORSA CELEBRAZIONI - 1904', description = '' WHERE id_product = '22933' 19/09/2024 12:36:46 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '344.2623' WHERE id_product = '22933' 19/09/2024 12:36:46 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '344.2623', id_tax_rules_group = '1', id_category_default = '147', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22933' 19/09/2024 12:36:46 pm >> DELETE FROM ps_specific_price WHERE id_product = '22933' 19/09/2024 12:37:25 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '2854' , '2024-09-16' , '' , '0' , '12' , '2607' , 'VIA NAZIONALE NORD, 4 - LAGARO 40035 CASTIGLIONE DEI PEPOLI' , '' , '' , '13' , '1' , '0' , '0' , '0' , '' , '9' , '0' , '1460.79' , '1197.37' , NOW() , NOW() ) 19/09/2024 12:37:25 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 = '93207' 19/09/2024 12:37:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '93207' 19/09/2024 12:37:25 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 ( '93207' , '16409' , 'RICAMBIO VETRO - 32/V' , '2' , '2' , '1' , '7' , '5.7377049180328' , '22' , '5' , '16.2260' ) 19/09/2024 12:37:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16409' AND id_supplier = '12' 19/09/2024 12:37:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16409' , '12' , '1' ) 19/09/2024 12:37:25 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 ( '93207' , '538' , 'AMPOLLA RICAMBIO PER ART. 501/5 - 70' , '4' , '4' , '1' , '3' , '2.4590163934426' , '22' , '5' , '13.9080' ) 19/09/2024 12:37:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '538' AND id_supplier = '12' 19/09/2024 12:37:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '538' , '12' , '1' ) 19/09/2024 12:37:25 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 ( '93207' , '803' , 'ASTUCCIO VIATICO - GRANDE - 1933' , '1' , '1' , '1' , '48' , '39.344262295082' , '22' , '5' , '55.6320' ) 19/09/2024 12:37:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '803' AND id_supplier = '12' 19/09/2024 12:37:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '803' , '12' , '1' ) 19/09/2024 12:37:25 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 ( '93207' , '540' , 'AMPOLLE ALTARE FUSIONE DORATA - 504 ' , '1' , '1' , '1' , '56' , '45.901639344262' , '22' , '5' , '64.9040' ) 19/09/2024 12:37:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '540' AND id_supplier = '12' 19/09/2024 12:37:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '540' , '12' , '1' ) 19/09/2024 12:37:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93207' , '15357' , 'AMPOLLE ABBRACCIO NIKEL - 1512' , '1' , '1' , '1' , '42' , '34.426229508197' , '22' , '5' , '48.6780' ) 19/09/2024 12:37:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15357' AND id_supplier = '12' 19/09/2024 12:37:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15357' , '12' , '1' ) 19/09/2024 12:37:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93207' , '12203' , 'VETRO ANTIVENTO PER F. CAND. DIAM. 5 - 73/50' , '2' , '2' , '1' , '9.5' , '7.7868852459016' , '22' , '5' , '22.0210' ) 19/09/2024 12:37:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12203' AND id_supplier = '12' 19/09/2024 12:37:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12203' , '12' , '1' ) 19/09/2024 12:37:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93207' , '15356' , 'AMPOLLE ABBRACCIO DORATE - 1511' , '1' , '1' , '1' , '42.5' , '34.83606557377' , '22' , '5' , '49.2575' ) 19/09/2024 12:37:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15356' AND id_supplier = '12' 19/09/2024 12:37:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15356' , '12' , '1' ) 19/09/2024 12:37:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93207' , '8936' , 'ANTIVENTO PER TORCIA ORO DIAM. 4 - 33' , '3' , '3' , '1' , '21' , '17.213114754098' , '22' , '5' , '73.0170' ) 19/09/2024 12:37:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8936' AND id_supplier = '12' 19/09/2024 12:37:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8936' , '12' , '1' ) 19/09/2024 12:37:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93207' , '22930' , 'CANDELABRO CM 20 - 645' , '2' , '2' , '1' , '30' , '24.590163934426' , '22' , '5' , '69.5400' ) 19/09/2024 12:37:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22930' AND id_supplier = '12' 19/09/2024 12:37:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22930' , '12' , '1' ) 19/09/2024 12:37:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93207' , '22929' , 'CANDELABRO CM 30 - 622' , '2' , '2' , '1' , '55' , '45.081967213115' , '22' , '5' , '127.4900' ) 19/09/2024 12:37:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22929' AND id_supplier = '12' 19/09/2024 12:37:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22929' , '12' , '1' ) 19/09/2024 12:37:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93207' , '22928' , 'CANDELABRO CM 40 - 621' , '2' , '2' , '1' , '89.5' , '73.360655737705' , '22' , '5' , '207.4610' ) 19/09/2024 12:37:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22928' AND id_supplier = '12' 19/09/2024 12:37:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22928' , '12' , '1' ) 19/09/2024 12:37:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93207' , '22931' , ' FINTA CANDELA CON CARTUCCIA 3,2 X 25 - 1131' , '6' , '6' , '1' , '9.5' , '7.7868852459016' , '22' , '5' , '66.0630' ) 19/09/2024 12:37:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22931' AND id_supplier = '12' 19/09/2024 12:37:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22931' , '12' , '1' ) 19/09/2024 12:37:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93207' , '17986' , 'PATENA 15,5 - 1900' , '1' , '1' , '1' , '22' , '18.032786885246' , '22' , '5' , '25.4980' ) 19/09/2024 12:37:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17986' AND id_supplier = '12' 19/09/2024 12:37:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17986' , '12' , '1' ) 19/09/2024 12:37:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93207' , '22216' , 'CALICE CLASSICO - 885' , '1' , '1' , '1' , '74' , '60.655737704918' , '22' , '5' , '85.7660' ) 19/09/2024 12:37:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22216' AND id_supplier = '12' 19/09/2024 12:37:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22216' , '12' , '1' ) 19/09/2024 12:37:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93207' , '780' , 'ASPERGES MAXI CON CUSTODIA - 700' , '4' , '4' , '1' , '21' , '17.213114754098' , '22' , '5' , '97.3560' ) 19/09/2024 12:37:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '780' AND id_supplier = '12' 19/09/2024 12:37:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '780' , '12' , '1' ) 19/09/2024 12:37:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93207' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '100' , '100' , '1' , '0.24' , '0.19672131147541' , '22' , '5' , '27.8160' ) 19/09/2024 12:37:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18122' AND id_supplier = '12' 19/09/2024 12:37:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18122' , '12' , '1' ) 19/09/2024 12:37:27 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 ( '93207' , '22932' , 'AMPOLLE - 1502' , '2' , '2' , '1' , '28.5' , '23.360655737705' , '22' , '5' , '66.0630' ) 19/09/2024 12:37:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22932' AND id_supplier = '12' 19/09/2024 12:37:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22932' , '12' , '1' ) 19/09/2024 12:37:27 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 ( '93207' , '16408' , 'AMPOLLE DORATE CON BECCUCCIO - 1503' , '1' , '1' , '1' , '34' , '27.868852459016' , '22' , '5' , '39.4060' ) 19/09/2024 12:37:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16408' AND id_supplier = '12' 19/09/2024 12:37:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16408' , '12' , '1' ) 19/09/2024 12:37:27 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 ( '93207' , '1750' , 'CARTUCCIA TRASPARENTE DIAM. 3,2 - 454' , '5' , '5' , '1' , '6' , '4.9180327868852' , '22' , '5' , '34.7700' ) 19/09/2024 12:37:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1750' AND id_supplier = '12' 19/09/2024 12:37:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1750' , '12' , '1' ) 19/09/2024 12:37:27 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 ( '93207' , '13523' , 'COPPIA AMPOLLINE 50 CC - 508' , '1' , '1' , '1' , '13.2' , '10.819672131148' , '22' , '5' , '15.2988' ) 19/09/2024 12:37:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13523' AND id_supplier = '12' 19/09/2024 12:37:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13523' , '12' , '1' ) 19/09/2024 12:37:27 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 ( '93207' , '12202' , 'VETRO ANTIVENTO PER F. CAND. DIAM. 4 - 73/40' , '4' , '4' , '1' , '8.5' , '6.9672131147541' , '22' , '5' , '39.4060' ) 19/09/2024 12:37:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12202' AND id_supplier = '12' 19/09/2024 12:37:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12202' , '12' , '1' ) 19/09/2024 12:37:27 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 ( '93207' , '22933' , 'BORSA CELEBRAZIONI - 1904' , '1' , '1' , '1' , '172' , '140.98360655738' , '22' , '5' , '199.3480' ) 19/09/2024 12:37:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22933' AND id_supplier = '12' 19/09/2024 12:37:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22933' , '12' , '1' ) 19/09/2024 12:53:36 pm >> SELECT document_num FROM ps_document WHERE document_num = '83/A' AND id_document != '92691' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-07-22') 19/09/2024 12:53:36 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '83/A', document_date = '2024-07-22', document_letter = 'A', id_customer = '3812', id_supplier = '', id_address = '4678843', address1 = 'LARGO PLEBISCITO 12 84121 SALERNO ', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '920.50', price_tax_excluded = '756.70', date_upd = NOW() WHERE id_document = '92691' 19/09/2024 12:53: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 = '92691' 19/09/2024 12:53:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '92691' 19/09/2024 12:53: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 ( '92691' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '5' , '-5' , '4' , '0.7000' , '0.7' , '0' , '0' , '3.50' ) 19/09/2024 12:53: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 ( '92691' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' , '-2' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '7.00' ) 19/09/2024 12:53: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 ( '92691' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '4.00' ) 19/09/2024 12:53: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 ( '92691' , '17005' , 'BIGLIETTO AUGURALE medio' , '6' , '-6' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '6.00' ) 19/09/2024 12:53: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 ( '92691' , '22930' , 'CANDELABRO CM 20 - 645' , '2' , '-2' , '1' , '75' , '61.475409836066' , '22' , '0' , '150.00' ) 19/09/2024 12:53: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 ( '92691' , '22928' , 'CANDELABRO CM 40 - 621' , '2' , '-2' , '1' , '196' , '160.65573770492' , '22' , '0' , '392.00' ) 19/09/2024 12:53: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 ( '92691' , '22929' , 'CANDELABRO CM 30 - 622' , '2' , '-2' , '1' , '110' , '90.16393442623' , '22' , '0' , '220.00' ) 19/09/2024 12:53: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 ( '92691' , '22931' , ' FINTA CANDELA CON CARTUCCIA 3,2 X 25 - 1131' , '6' , '-6' , '1' , '23' , '18.852459016393' , '22' , '0' , '138.00' ) 19/09/2024 02:06:58 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4115' 19/09/2024 02:06:58 pm >> 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 ( '4115' , '10' , '229' , '' , 'MERLIN' , 'MARTA' , 'VIA DON LUIGI BENASSUTI 37' , '' , '37053' , 'CEREA' , '' , '' , '3479340762' , '' , '' , NOW() , NOW() ) 19/09/2024 02:06:58 pm >> UPDATE ps_customer SET email = 'martamerlin@libero.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4115' 19/09/2024 03:19:58 pm >> SELECT document_num FROM ps_document WHERE document_num = '2738' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-19') 19/09/2024 03:19:58 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' , '2738' , '2024-09-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '50.00' , '41.34' , NOW() , NOW() ) 19/09/2024 03:19:58 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 = '93208' 19/09/2024 03:19:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '93208' 19/09/2024 03:19:58 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 ( '93208' , '12817' , 'LIBRO DEI MATRIMONI' , '1' , '-1' , '1' , '40.00' , '32.786885245902' , '22' , '5' , '38.00' ) 19/09/2024 03:19:58 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 ( '93208' , '22507' , 'SPES NON CONFUNDIT' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 19/09/2024 03:19:58 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 ( '93208' , '22870' , 'AGENDA SAN PAOLO 2025' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 19/09/2024 04:48:12 pm >> SELECT document_num FROM ps_document WHERE document_num = '2739' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-19') 19/09/2024 04:48:12 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' , '2739' , '2024-09-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.00' , '12.30' , NOW() , NOW() ) 19/09/2024 04:48:12 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 = '93209' 19/09/2024 04:48:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '93209' 19/09/2024 04:48:12 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 ( '93209' , '538' , 'AMPOLLA RICAMBIO PER ART. 501/5 - 70' , '2' , '-2' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '15.00' ) 19/09/2024 04:48:29 pm >> SELECT document_num FROM ps_document WHERE document_num = '2740' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-19') 19/09/2024 04:48: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' , '2740' , '2024-09-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.90' , '9.75' , NOW() , NOW() ) 19/09/2024 04:48: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 = '93210' 19/09/2024 04:48:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '93210' 19/09/2024 04:48: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 ( '93210' , '13805' , 'QUADRETTO 10X10 ALBERO DELLA VITA - 2974/F0024' , '1' , '-1' , '1' , '11.90' , '9.7540983606557' , '22' , '0' , '11.90' ) 19/09/2024 04:52:23 pm >> SELECT document_num FROM ps_document WHERE document_num = '39/E' AND id_document != '93193' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-09-18') 19/09/2024 04:52:23 pm >> UPDATE ps_document SET id_document_type = '23', document_num = '39/E', document_date = '2024-09-18', document_letter = 'E', id_customer = '189', id_supplier = '', id_address = '4679063', address1 = 'VIA NAZIONALE APPIA, 128 81022 CASAGIOVE', address2 = '', note = '', price_shipping = '', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '178.44', price_tax_excluded = '176.67', date_upd = NOW() WHERE id_document = '93193' 19/09/2024 04:52:23 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93193' 19/09/2024 04:52:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '93193' 19/09/2024 04:52:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93193' , '15019' , 'PREGHIAMO CON MARIA' , '340' , '-340' , '4' , '0.8000' , '0.8' , '0' , '38' , '168.64' ) 19/09/2024 04:52:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93193' , '10133' , 'SPESE DI TRASPORTO' , '1' , '-1' , '1' , '9.8' , '8.0327868852459' , '22' , '0' , '9.80' ) 19/09/2024 04:52:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '39/E' AND id_document != '93193' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-09-18') 19/09/2024 04:52:43 pm >> UPDATE ps_document SET id_document_type = '23', document_num = '39/E', document_date = '2024-09-18', document_letter = 'E', id_customer = '189', id_supplier = '', id_address = '4679063', address1 = 'VIA NAZIONALE APPIA, 128 81022 CASAGIOVE', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '178.44', price_tax_excluded = '178.44', date_upd = NOW() WHERE id_document = '93193' 19/09/2024 04:52:43 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 = '93193' 19/09/2024 04:52:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '93193' 19/09/2024 04:52:43 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 ( '93193' , '15019' , 'PREGHIAMO CON MARIA' , '340' , '-340' , '4' , '0.8000' , '0.8' , '0' , '38' , '168.64' ) 19/09/2024 04:52:43 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 ( '93193' , '10133' , 'SPESE DI TRASPORTO' , '1' , '-1' , '4' , '9.8000' , '9.8' , '0' , '0' , '9.80' ) 19/09/2024 05:31:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '2741' AND id_document != '' AND id_document_type LIKE '14' AND YEAR(document_date) = YEAR('2024-09-19') 19/09/2024 05:31:19 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2741' , '2024-09-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '131.60' , '108.16' , NOW() , NOW() ) 19/09/2024 05:31: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 = '93211' 19/09/2024 05:31:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '93211' 19/09/2024 05:31: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 ( '93211' , '22698' , 'CALENDARIO LITURGICO 2025' , '2' , '-2' , '4' , '0.80' , '0.8' , '0' , '0' , '1.60' ) 19/09/2024 05:31: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 ( '93211' , '22932' , 'AMPOLLE - 1502' , '2' , '-2' , '1' , '65' , '53.27868852459' , '22' , '0' , '130.00' ) 19/09/2024 05:31:30 pm >> SELECT document_num FROM ps_document WHERE document_num = '2742' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-19') 19/09/2024 05:31:30 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2742' , '2024-09-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '131.00' , '113.15' , NOW() , NOW() ) 19/09/2024 05:31:30 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93212' 19/09/2024 05:31:30 pm >> DELETE FROM ps_document_detail WHERE id_document = '93212' 19/09/2024 05:31:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93212' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '99' , '81.147540983607' , '22' , '0' , '99.00' ) 19/09/2024 05:31:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93212' , '20247' , 'DI PASQUA IN PASQUA - ANNO A - F. ROSINI' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '0' , '16.00' ) 19/09/2024 05:31:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93212' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '16' , '16' , '0' , '0' , '16.00' ) 19/09/2024 05:33:21 pm >> SELECT document_num FROM ps_document WHERE document_num = '2743' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-19') 19/09/2024 05:33:21 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2743' , '2024-09-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '290.00' , '237.70' , NOW() , NOW() ) 19/09/2024 05:33:21 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 = '93213' 19/09/2024 05:33:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '93213' 19/09/2024 05:33:21 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 ( '93213' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '200' , '163.93442622951' , '22' , '0' , '200.00' ) 19/09/2024 05:33:21 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 ( '93213' , '8163' , 'ASTUCCIO PORTA VIATICO DAMASCATO - 23' , '1' , '-1' , '1' , '75.00' , '61.475409836066' , '22' , '0' , '75.00' ) 19/09/2024 05:33:21 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 ( '93213' , '16456' , 'CINGOLO - CING03' , '1' , '-1' , '1' , '15.00' , '12.295081967213' , '22' , '0' , '15.00' ) 19/09/2024 05:39:50 pm >> SELECT document_num FROM ps_document WHERE document_num = '2376' AND id_document != '92758' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-29') 19/09/2024 05:39:50 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2376', document_date = '2024-07-29', 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 = '9.10', price_tax_excluded = '8.22', date_upd = NOW() WHERE id_document = '92758' 19/09/2024 05:39:50 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92758' 19/09/2024 05:39:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '92758' 19/09/2024 05:39:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92758' , '22733' , 'BRACCIALE ELASTICO - RL436/435' , '2' , '-2' , '1' , '2.2000' , '1.8032786885246' , '22' , '0' , '4.40' ) 19/09/2024 05:39:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92758' , '16446' , 'LOURDES ROSARIO DI S. BERNARDETTE - 8981' , '1' , '-1' , '4' , '2.4' , '2.4' , '0' , '0' , '2.40' ) 19/09/2024 05:39:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92758' , '20719' , 'CORONA DELL’ADDOLORATA' , '1' , '-1' , '4' , '1.8000' , '1.8' , '0' , '0' , '1.80' ) 19/09/2024 05:39:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92758' , '21594' , 'CARTONCINO 16X23' , '1' , '-1' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '0.50' ) 19/09/2024 05:40:16 pm >> SELECT document_num FROM ps_document WHERE document_num = '1935' AND id_document != '92233' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-10') 19/09/2024 05:40:16 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1935', 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 = '1.30', price_tax_excluded = '1.07', date_upd = NOW() WHERE id_document = '92233' 19/09/2024 05:40:16 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92233' 19/09/2024 05:40:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '92233' 19/09/2024 05:40:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92233' , '22500' , 'DECINA LEGNO' , '1' , '-1' , '1' , '1.3' , '1.0655737704918' , '22' , '0' , '1.30' ) 19/09/2024 05:41:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '2139' AND id_document != '92476' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-01') 19/09/2024 05:41:20 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2139', document_date = '2024-07-01', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '14.00', price_tax_excluded = '11.48', date_upd = NOW() WHERE id_document = '92476' 19/09/2024 05:41:20 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 = '92476' 19/09/2024 05:41:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '92476' 19/09/2024 05:41:20 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 ( '92476' , '21558' , 'ANELLO DECINA ARG - M043' , '1' , '-1' , '1' , '12.0000' , '9.8360655737705' , '22' , '0' , '12.00' ) 19/09/2024 05:41:20 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 ( '92476' , '11697' , 'SCATOLA PORTA ROSARIO - 7383' , '1' , '-1' , '1' , '2' , '1.6393442622951' , '22' , '0' , '2.00' ) 19/09/2024 06:18:58 pm >> SELECT document_num FROM ps_document WHERE document_num = '2744' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-19') 19/09/2024 06:18:58 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2744' , '2024-09-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '183.90' , '151.94' , NOW() , NOW() ) 19/09/2024 06:18:58 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 = '93214' 19/09/2024 06:18:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '93214' 19/09/2024 06:18:58 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 ( '93214' , '11756' , 'VINO BIANCO SECCO - 14%' , '1' , '-1' , '1' , '6.90' , '5.655737704918' , '22' , '0' , '6.90' ) 19/09/2024 06:18:58 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 ( '93214' , '1914' , 'CERA DELLA LITURGIA' , '5' , '-5' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '24.50' ) 19/09/2024 06:18:58 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 ( '93214' , '18130' , 'TAU GRANDE CM 4 - T9' , '50' , '-50' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '50.00' ) 19/09/2024 06:18:58 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 ( '93214' , '17617' , 'IMMAGINI ISONZO X 100' , '2' , '-2' , '1' , '3.3' , '2.7049180327869' , '22' , '0' , '6.60' ) 19/09/2024 06:18:58 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 ( '93214' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.4' , '2.7868852459016' , '22' , '0' , '3.40' ) 19/09/2024 06:18:58 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 ( '93214' , '17711' , 'OSTIA MAGNA CM 18 - OM 180' , '1' , '-1' , '3' , '8.50' , '8.1730769230769' , '4' , '0' , '8.50' ) 19/09/2024 06:18:58 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 ( '93214' , '22257' , 'QUADRO DECORATO 36X22' , '2' , '-2' , '1' , '42.00' , '34.426229508197' , '22' , '0' , '84.00' )