04/05/2023 08:54:15 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 04/05/2023 08:54:15 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21037' , '1' , '' , 'nuovo-prodotto' ) 04/05/2023 08:54:15 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '21037' , '1' , '1' , '2' , NOW() , NOW() ) 04/05/2023 08:54:16 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '21037' , '0' , '1' , '0' , '0' ) 04/05/2023 08:55:05 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884048608' AND id_product != '21037' AND ean13 != '' 04/05/2023 08:55:05 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788884048608', date_upd = NOW() WHERE id_product = '21037' 04/05/2023 08:55:05 am >> UPDATE ps_product_lang SET name = 'SULLA TUA PAROLA LUG/AGO 2023', description = '' WHERE id_product = '21037' 04/05/2023 08:55:05 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '5' WHERE id_product = '21037' 04/05/2023 08:55:05 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '5', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '64', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21037' 04/05/2023 08:55:05 am >> DELETE FROM ps_specific_price WHERE id_product = '21037' 04/05/2023 08:55:07 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '21037' 04/05/2023 08:55:07 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21038' , '1' , '' , 'nuovo-prodotto' ) 04/05/2023 08:55:07 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '21038' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21037' 04/05/2023 08:55:07 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21038' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21037' 04/05/2023 08:55:39 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '7479/00/2023' , '2023-05-02' , '00' , '0' , '38' , '2633' , 'VIA GALVANI, 1 60020 CAMERATA PICENA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '130.80' , '130.80' , NOW() , NOW() ) 04/05/2023 08:55:39 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84133' 04/05/2023 08:55:39 am >> DELETE FROM ps_document_detail WHERE id_document = '84133' 04/05/2023 08:55:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84133' , '20795' , 'SULLA TUA PAROLA MAG/GIU 2023 - 516' , '25' , '25' , '4' , '5.00' , '5' , '0' , '40' , '75.0000' ) 04/05/2023 08:55:39 am >> DELETE FROM ps_product_supplier WHERE id_product = '20795' AND id_supplier = '38' 04/05/2023 08:55:39 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20795' , '38' , '1' ) 04/05/2023 08:55:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84133' , '21037' , 'SULLA TUA PAROLA LUG/AGO 2023' , '15' , '15' , '4' , '5.00' , '5' , '0' , '40' , '45.0000' ) 04/05/2023 08:55:39 am >> DELETE FROM ps_product_supplier WHERE id_product = '21037' AND id_supplier = '38' 04/05/2023 08:55:39 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21037' , '38' , '1' ) 04/05/2023 08:55:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84133' , '19503' , 'UN MESE CON MARIA - 8064' , '1' , '1' , '4' , '9.00' , '9' , '0' , '40' , '5.4000' ) 04/05/2023 08:55:39 am >> DELETE FROM ps_product_supplier WHERE id_product = '19503' AND id_supplier = '38' 04/05/2023 08:55:39 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19503' , '38' , '1' ) 04/05/2023 08:55:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84133' , '8219' , 'PRATICA DI AMAR GESÙ CRISTO - 8464' , '1' , '1' , '4' , '9.00' , '9' , '0' , '40' , '5.4000' ) 04/05/2023 08:55:39 am >> DELETE FROM ps_product_supplier WHERE id_product = '8219' AND id_supplier = '38' 04/05/2023 08:55:39 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8219' , '38' , '1' ) 04/05/2023 09:37:28 am >> SELECT document_num FROM ps_document WHERE document_num = '1496' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-04') 04/05/2023 09:37:28 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' , '1496' , '2023-05-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '74.00' , '60.66' , NOW() , NOW() ) 04/05/2023 09:37:28 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84134' 04/05/2023 09:37:28 am >> DELETE FROM ps_document_detail WHERE id_document = '84134' 04/05/2023 09:37:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84134' , '11389' , 'VINO ROSSO DOLCE - 103' , '6' , '-6' , '1' , '8' , '6.5573770491803' , '22' , '0' , '48.00' ) 04/05/2023 09:37:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84134' , '6404' , 'MENSA BIANCA 80X240 - M8024' , '2' , '-2' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '26.00' ) 04/05/2023 09:41:02 am >> SELECT ean13 FROM ps_product WHERE ean13 = '000404' AND id_product != '6404' AND ean13 != '' 04/05/2023 09:41:02 am >> UPDATE ps_product SET id_supplier = '31', reference = '2013', ean13 = '000404', date_upd = NOW() WHERE id_product = '6404' 04/05/2023 09:41:02 am >> UPDATE ps_product_lang SET name = 'MENSA BIANCA 80X240 - M8024', description = '' WHERE id_product = '6404' 04/05/2023 09:41:02 am >> UPDATE ps_product SET wholesale_price = '4.75', on_sale = '0', price = '11.065573770491804' WHERE id_product = '6404' 04/05/2023 09:41:02 am >> UPDATE ps_product_shop SET wholesale_price = '4.75', price = '11.065573770491804', id_tax_rules_group = '1', id_category_default = '169', 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 = '6404' 04/05/2023 09:41:02 am >> DELETE FROM ps_specific_price WHERE id_product = '6404' 04/05/2023 09:41:59 am >> SELECT document_num FROM ps_document WHERE document_num = '915' AND id_document != '82395' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-21') 04/05/2023 09:41:59 am >> UPDATE ps_document SET id_document_type = '11', document_num = '915', document_date = '2023-03-21', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '133.86', price_tax_excluded = '116.73', date_upd = NOW() WHERE id_document = '82395' 04/05/2023 09:41: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 = '82395' 04/05/2023 09:41:59 am >> DELETE FROM ps_document_detail WHERE id_document = '82395' 04/05/2023 09:41: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 ( '82395' , '18046' , 'TECA PLACCA SMALTATA - 504' , '2' , '-2' , '1' , '33.5000' , '27.459016393443' , '22' , '0' , '67.00' ) 04/05/2023 09:41: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 ( '82395' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '4' , '-4' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '1.00' ) 04/05/2023 09:41: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 ( '82395' , '20797' , 'QUALCHE PAROLA PRIMA DELLAPOCALISSE - A. CANDIARD' , '1' , '-1' , '4' , '11.0000' , '11' , '0' , '5' , '10.45' ) 04/05/2023 09:41: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 ( '82395' , '17904' , 'CELEBRIAMO LA PASQUA - N.E.' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '5' , '3.71' ) 04/05/2023 09:41: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 ( '82395' , '8416' , 'PREPARARE E CELEBRARE - TRIDUO PASQUALE' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '5' , '19.00' ) 04/05/2023 09:41: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 ( '82395' , '20739' , 'OLIO DI LETIZIA - M. MANCA' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '5' , '5.70' ) 04/05/2023 09:41: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 ( '82395' , '16271' , 'FERMAGLIO ORO - B18/FE' , '1' , '-1' , '1' , '14.0000' , '11.475409836066' , '22' , '0' , '14.00' ) 04/05/2023 09:41: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 ( '82395' , '6404' , 'MENSA BIANCA 80X240 - M8024' , '1' , '-1' , '1' , '13' , '10.655737704918' , '22' , '0' , '13.00' ) 04/05/2023 09:42:41 am >> SELECT document_num FROM ps_document WHERE document_num = '980' AND id_document != '82474' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-25') 04/05/2023 09:42:41 am >> UPDATE ps_document SET id_document_type = '11', document_num = '980', document_date = '2023-03-25', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '45.00', price_tax_excluded = '36.89', date_upd = NOW() WHERE id_document = '82474' 04/05/2023 09:42:41 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82474' 04/05/2023 09:42:41 am >> DELETE FROM ps_document_detail WHERE id_document = '82474' 04/05/2023 09:42:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82474' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '4' , '3.2786885245902' , '22' , '0' , '4.00' ) 04/05/2023 09:42:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82474' , '6404' , 'MENSA BIANCA 80X240 - M8024' , '2' , '-2' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '26.00' ) 04/05/2023 09:42:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82474' , '12613' , 'TURIBOLO 10 CM' , '1' , '-1' , '1' , '15.0000' , '12.295081967213' , '22' , '0' , '15.00' ) 04/05/2023 09:51:17 am >> SELECT document_num FROM ps_document WHERE document_num = '1497' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-04') 04/05/2023 09:51:17 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' , '1497' , '2023-05-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.80' , '8.03' , NOW() , NOW() ) 04/05/2023 09:51:17 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 = '84135' 04/05/2023 09:51:17 am >> DELETE FROM ps_document_detail WHERE id_document = '84135' 04/05/2023 09:51:17 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 ( '84135' , '1914' , 'CERA DELLA LITURGIA' , '2' , '-2' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '9.80' ) 04/05/2023 10:11:41 am >> SELECT document_num FROM ps_document WHERE document_num = '1498' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-04') 04/05/2023 10:11:41 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1498' , '2023-05-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '32.50' , '27.77' , NOW() , NOW() ) 04/05/2023 10:11:41 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84136' 04/05/2023 10:11:41 am >> DELETE FROM ps_document_detail WHERE id_document = '84136' 04/05/2023 10:11:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84136' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '2' , '-2' , '3' , '4.00' , '3.8461538461538' , '4' , '0' , '8.00' ) 04/05/2023 10:11:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84136' , '19560' , 'PERGAMENA 17X25' , '35' , '-35' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '24.50' ) 04/05/2023 10:13:57 am >> SELECT document_num FROM ps_document WHERE document_num = '1499' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-04') 04/05/2023 10:13:57 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' , '1499' , '2023-05-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.00' , '5.74' , NOW() , NOW() ) 04/05/2023 10:13:57 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 = '84137' 04/05/2023 10:13:57 am >> DELETE FROM ps_document_detail WHERE id_document = '84137' 04/05/2023 10:13:57 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 ( '84137' , '791' , 'ASSISI IN BUSTA BATTESIMO - 20X270 - BAAS' , '5' , '-5' , '1' , '1.40' , '1.1475409836066' , '22' , '0' , '7.00' ) 04/05/2023 10:15:31 am >> SELECT document_num FROM ps_document WHERE document_num = '1500' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-04') 04/05/2023 10:15: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 ( '11' , '1500' , '2023-05-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.50' , '9.50' , NOW() , NOW() ) 04/05/2023 10:15: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 = '84138' 04/05/2023 10:15:31 am >> DELETE FROM ps_document_detail WHERE id_document = '84138' 04/05/2023 10:15: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 ( '84138' , '20795' , 'SULLA TUA PAROLA MAG/GIU 2023 - 516' , '2' , '-2' , '4' , '5.00' , '5' , '0' , '5' , '9.50' ) 04/05/2023 10:35:03 am >> SELECT document_num FROM ps_document WHERE document_num = '1501' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-04') 04/05/2023 10:35:03 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1501' , '2023-05-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '94.00' , '77.69' , NOW() , NOW() ) 04/05/2023 10:35:03 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84139' 04/05/2023 10:35:03 am >> DELETE FROM ps_document_detail WHERE id_document = '84139' 04/05/2023 10:35:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84139' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 04/05/2023 10:35:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84139' , '19089' , 'OSTIA MAGNA 150 -OM150' , '1' , '-1' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '4.50' ) 04/05/2023 10:35:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84139' , '20982' , 'POLO MM VISCOSA 100%' , '2' , '-2' , '1' , '39.75' , '32.581967213115' , '22' , '0' , '79.50' ) 04/05/2023 10:47:58 am >> SELECT document_num FROM ps_document WHERE document_num = '54/A' AND id_document != '59768' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-07-23') 04/05/2023 10:47:58 am >> UPDATE ps_document SET id_document_type = '24', document_num = '54/A', document_date = '2022-07-23', document_letter = 'A', id_customer = '230', id_supplier = '', id_address = '4668969', address1 = 'VIA G. NICOTERA, 66 84080 PELLEZZANO', address2 = '', note = 'ACCONTO € 400 + 85', 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 = '485.00', price_tax_excluded = '485.00', date_upd = NOW() WHERE id_document = '59768' 04/05/2023 10:47: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 = '59768' 04/05/2023 10:47:58 am >> DELETE FROM ps_document_detail WHERE id_document = '59768' 04/05/2023 10:47: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 ( '59768' , '0' , 'bambino + culla terracot 450+35' , '1' , '-1' , '0' , '485.0000' , '485' , '0' , '0' , '485.00' ) 04/05/2023 10:54:14 am >> SELECT document_num FROM ps_document WHERE document_num = '34/A' AND id_document != '56617' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-05-05') 04/05/2023 10:54:14 am >> UPDATE ps_document SET id_document_type = '24', document_num = '34/A', document_date = '2022-05-05', document_letter = 'A', id_customer = '230', id_supplier = '', id_address = '4668969', address1 = 'VIA G. NICOTERA, 66 84080 PELLEZZANO', address2 = '', note = 'acconto € 100,00 5/4/23 - 200 04/05', 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 = '1460.00', price_tax_excluded = '1196.72', date_upd = NOW() WHERE id_document = '56617' 04/05/2023 10:54:14 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '56617' 04/05/2023 10:54:14 am >> DELETE FROM ps_document_detail WHERE id_document = '56617' 04/05/2023 10:54:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56617' , '0' , 'COTTA ' , '1' , '-1' , '1' , '680.0000' , '557.37704918033' , '22' , '0' , '680.00' ) 04/05/2023 10:54:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56617' , '19802' , 'CASULA CON PALLIO L-LAME\' - NUOVA PRIMAVERA - 8254C****' , '1' , '-1' , '1' , '780.0000' , '639.34426229508' , '22' , '0' , '780.00' ) 04/05/2023 10:56:20 am >> SELECT document_num FROM ps_document WHERE document_num = '1502' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-04') 04/05/2023 10:56: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' , '1502' , '2023-05-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.75' , '7.21' , NOW() , NOW() ) 04/05/2023 10:56: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 = '84140' 04/05/2023 10:56:20 am >> DELETE FROM ps_document_detail WHERE id_document = '84140' 04/05/2023 10:56: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 ( '84140' , '18124' , 'PREGHIERE A MARIA' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 04/05/2023 10:56: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 ( '84140' , '13506' , 'SANTO ROSARIO' , '10' , '-10' , '1' , '0.30' , '0.24590163934426' , '22' , '0' , '3.00' ) 04/05/2023 11:03:13 am >> SELECT document_num FROM ps_document WHERE document_num = '1503' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-04') 04/05/2023 11:03:13 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1503' , '2023-05-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '26.60' , '21.80' , NOW() , NOW() ) 04/05/2023 11:03:13 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84141' 04/05/2023 11:03:13 am >> DELETE FROM ps_document_detail WHERE id_document = '84141' 04/05/2023 11:03:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84141' , '18222' , 'ROSARIO COLORATO - R316' , '26' , '-26' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '18.20' ) 04/05/2023 11:03:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84141' , '13504' , 'SACRAMENTO DELLA RICONCILIAZIONE RAGAZZI' , '28' , '-28' , '1' , '0.30' , '0.24590163934426' , '22' , '0' , '8.40' ) 04/05/2023 11:05:44 am >> DELETE FROM ps_document WHERE id_document = '59768' 04/05/2023 11:05:44 am >> DELETE FROM ps_document_detail WHERE id_document = '59768' 04/05/2023 11:27:29 am >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'fWIFX8weqlF9HUJE' , NOW() , NOW() ) 04/05/2023 11:27:29 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4016' , '1' ) 04/05/2023 11:27:29 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4016' , '2' ) 04/05/2023 11:27:29 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4016' , '3' ) 04/05/2023 11:29:38 am >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , '81WnVjz9Xo2eLsbF' , NOW() , NOW() ) 04/05/2023 11:29:38 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '7042' , '1' ) 04/05/2023 11:29:38 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '7042' , '2' ) 04/05/2023 11:29:38 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '7042' , '3' ) 04/05/2023 11:30:46 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '7042' 04/05/2023 11:30:46 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 ( '7042' , '10' , '150' , 'PARROCCHIA SAN GIORGIO' , 'DI SALVO' , 'DON GIUSEPPE' , 'PIAZZA SAN GIORGIO' , '' , '87040' , 'ZUMPANO' , '' , '' , '3382760783' , '' , '' , NOW() , NOW() ) 04/05/2023 11:30:47 am >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '7042' 04/05/2023 11:31:16 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '7042' 04/05/2023 11:31:16 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 ( '7042' , '10' , '150' , 'PARROCCHIA SAN GIORGIO' , 'DI SALVO' , 'DON GIUSEPPE' , 'PIAZZA SAN GIORGIO' , '' , '87040' , 'ZUMPANO' , '' , '' , '3382760783' , '' , '' , NOW() , NOW() ) 04/05/2023 11:31:16 am >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '7042' 04/05/2023 11:31:44 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '7042' 04/05/2023 11:31:44 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 ( '7042' , '10' , '150' , 'PARROCCHIA SAN GIORGIO' , 'DI SALVO' , 'DON GIUSEPPE' , 'PIAZZA SAN GIORGIO' , '' , '87040' , 'ZUMPANO' , '' , '' , '3382760783' , '' , '' , NOW() , NOW() ) 04/05/2023 11:31:44 am >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '7042' 04/05/2023 11:32:58 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4016' 04/05/2023 11:32:58 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 ( '4016' , '10' , '150' , 'PARROCCHIA SAN GIORGIO MARTIRE' , 'DI SALVO' , 'DON GIUSEPPE' , 'PIAZZA SAN GIORGIO ' , '' , '87040' , 'ZUMPANO' , '' , '' , '3389272601' , '' , '' , NOW() , NOW() ) 04/05/2023 11:32:58 am >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4016' 04/05/2023 11:33:06 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '7042' 04/05/2023 11:33:06 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 ( '7042' , '10' , '150' , 'PARROCCHIA SAN GIORGIO' , 'DI SALVO' , 'DON GIUSEPPE' , 'PIAZZA SAN GIORGIO' , '' , '87040' , 'ZUMPANO' , '' , '' , '3382760783' , '' , '' , NOW() , NOW() ) 04/05/2023 11:33:06 am >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '7042' 04/05/2023 11:38:53 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788852607516' AND id_product != '21038' AND ean13 != '' 04/05/2023 11:38:53 am >> UPDATE ps_product SET id_supplier = '', reference = '13/7', ean13 = '9788852607516', date_upd = NOW() WHERE id_product = '21038' 04/05/2023 11:38:53 am >> UPDATE ps_product_lang SET name = 'CONVERSAZIONI SULLA CHIESA', description = '' WHERE id_product = '21038' 04/05/2023 11:38:53 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '18' WHERE id_product = '21038' 04/05/2023 11:38:53 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '18', id_tax_rules_group = '4', id_category_default = '285', id_argoment_default = '65', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21038' 04/05/2023 11:38:53 am >> DELETE FROM ps_specific_price WHERE id_product = '21038' 04/05/2023 11:38:54 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 = '21038' 04/05/2023 11:38:54 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21039' , '1' , '' , 'nuovo-prodotto' ) 04/05/2023 11:38:54 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 '21039' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21038' 04/05/2023 11:38:54 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21039' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21038' 04/05/2023 11:39:55 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788887129212' AND id_product != '13780' AND ean13 != '' 04/05/2023 11:39:55 am >> UPDATE ps_product SET id_supplier = '107', reference = '1/2', ean13 = '9788887129212', date_upd = NOW() WHERE id_product = '13780' 04/05/2023 11:39:55 am >> UPDATE ps_product_lang SET name = 'RISCOPRIAMO LA BELLEZZA DEL BATTESIMO', description = '' WHERE id_product = '13780' 04/05/2023 11:39:55 am >> UPDATE ps_product SET wholesale_price = '3.50', on_sale = '0', price = '5.0000' WHERE id_product = '13780' 04/05/2023 11:39:55 am >> UPDATE ps_product_shop SET wholesale_price = '3.50', price = '5.0000', id_tax_rules_group = '4', id_category_default = '255', id_argoment_default = '108', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '13780' 04/05/2023 11:39:55 am >> DELETE FROM ps_specific_price WHERE id_product = '13780' 04/05/2023 11:40:08 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '2023000002504' , '2023-05-03' , '' , '0' , '107' , '4669100' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '6' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '74.62' , '74.62' , NOW() , NOW() ) 04/05/2023 11:40:08 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84142' 04/05/2023 11:40:08 am >> DELETE FROM ps_document_detail WHERE id_document = '84142' 04/05/2023 11:40:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84142' , '20139' , 'BANALITA DEL MALE - V. SERPE' , '3' , '3' , '4' , '12.00' , '12' , '0' , '35' , '23.4000' ) 04/05/2023 11:40:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '20139' AND id_supplier = '107' 04/05/2023 11:40:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20139' , '107' , '1' ) 04/05/2023 11:40:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84142' , '18810' , 'ANTIFONE - E. DELLA CORTE' , '1' , '1' , '4' , '10.00' , '10' , '0' , '35' , '6.5000' ) 04/05/2023 11:40:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '18810' AND id_supplier = '107' 04/05/2023 11:40:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18810' , '107' , '1' ) 04/05/2023 11:40:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84142' , '18314' , 'FARE DI CRISTO IL CUORE... FESTIVO - E. DELLA CORTE' , '1' , '1' , '4' , '19.00' , '19' , '0' , '35' , '12.3500' ) 04/05/2023 11:40:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '18314' AND id_supplier = '107' 04/05/2023 11:40:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18314' , '107' , '1' ) 04/05/2023 11:40:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84142' , '21038' , 'CONVERSAZIONI SULLA CHIESA' , '1' , '1' , '4' , '18.00' , '18' , '0' , '28.5' , '12.8700' ) 04/05/2023 11:40:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '21038' AND id_supplier = '107' 04/05/2023 11:40:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21038' , '107' , '1' ) 04/05/2023 11:40:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84142' , '19138' , 'ATTO DI ABBANDONO - D. D. RUOTOLO' , '10' , '10' , '4' , '1.00' , '1' , '0' , '35' , '6.5000' ) 04/05/2023 11:40:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '19138' AND id_supplier = '107' 04/05/2023 11:40:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19138' , '107' , '1' ) 04/05/2023 11:40:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84142' , '13780' , 'RISCOPRIAMO LA BELLEZZA DEL BATTESIMO' , '2' , '2' , '4' , '5.00' , '5' , '0' , '30' , '7.0000' ) 04/05/2023 11:40:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '13780' AND id_supplier = '107' 04/05/2023 11:40:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13780' , '107' , '1' ) 04/05/2023 12:14:01 pm >> SELECT document_num FROM ps_document WHERE document_num = '1504' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-04') 04/05/2023 12:14: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' , '1504' , '2023-05-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.00' , '19.00' , NOW() , NOW() ) 04/05/2023 12:14: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 = '84143' 04/05/2023 12:14:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '84143' 04/05/2023 12:14: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 ( '84143' , '20795' , 'SULLA TUA PAROLA MAG/GIU 2023 - 516' , '4' , '-4' , '4' , '5.00' , '5' , '0' , '5' , '19.00' ) 04/05/2023 12:36:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '1505' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-04') 04/05/2023 12:36:59 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' , '1505' , '2023-05-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.90' , '4.02' , NOW() , NOW() ) 04/05/2023 12:36:59 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 = '84144' 04/05/2023 12:36:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '84144' 04/05/2023 12:36:59 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 ( '84144' , '1914' , 'CERA DELLA LITURGIA' , '1' , '-1' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '4.90' ) 04/05/2023 12:38:47 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '70-1431' AND id_product != '18386' AND ean13 != '' 04/05/2023 12:38:47 pm >> UPDATE ps_product SET id_supplier = '129', reference = '', ean13 = '70-1431', date_upd = NOW() WHERE id_product = '18386' 04/05/2023 12:38:47 pm >> UPDATE ps_product_lang SET name = 'PALLA IN SETA CON AGNELLO ORO M.F. - 70/1431', description = '' WHERE id_product = '18386' 04/05/2023 12:38:47 pm >> UPDATE ps_product SET wholesale_price = '134.83', on_sale = '0', price = '254.0984' WHERE id_product = '18386' 04/05/2023 12:38:47 pm >> UPDATE ps_product_shop SET wholesale_price = '134.83', price = '254.0984', id_tax_rules_group = '1', id_category_default = '450', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '18386' 04/05/2023 12:38:47 pm >> DELETE FROM ps_specific_price WHERE id_product = '18386' 04/05/2023 12:41:21 pm >> SELECT document_num FROM ps_document WHERE document_num = '1506' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-04') 04/05/2023 12:41: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' , '1506' , '2023-05-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.40' , '10.98' , NOW() , NOW() ) 04/05/2023 12:41: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 = '84145' 04/05/2023 12:41:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '84145' 04/05/2023 12:41: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 ( '84145' , '11389' , 'VINO ROSSO DOLCE - 103' , '1' , '-1' , '1' , '8.50' , '6.9672131147541' , '22' , '0' , '8.50' ) 04/05/2023 12:41: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 ( '84145' , '1914' , 'CERA DELLA LITURGIA' , '1' , '-1' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '4.90' ) 04/05/2023 12:44:20 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '50-372' AND id_product != '21039' AND ean13 != '' 04/05/2023 12:44:20 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '50-372', date_upd = NOW() WHERE id_product = '21039' 04/05/2023 12:44:20 pm >> UPDATE ps_product_lang SET name = 'PALLA IN SETA RICAMO MARIANO - 50/372', description = '' WHERE id_product = '21039' 04/05/2023 12:44:20 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0' WHERE id_product = '21039' 04/05/2023 12:44:20 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0', id_tax_rules_group = '1', id_category_default = '450', id_argoment_default = '42', id_internal_category = '4', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21039' 04/05/2023 12:44:20 pm >> DELETE FROM ps_specific_price WHERE id_product = '21039' 04/05/2023 12:44:22 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 = '21039' 04/05/2023 12:44:22 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21040' , '1' , '' , 'nuovo-prodotto' ) 04/05/2023 12:44:22 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 '21040' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21039' 04/05/2023 12:44:22 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21040' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21039' 04/05/2023 12:45:46 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '50/63123' AND id_product != '21040' AND ean13 != '' 04/05/2023 12:45:46 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '50/63123', date_upd = NOW() WHERE id_product = '21040' 04/05/2023 12:45:46 pm >> UPDATE ps_product_lang SET name = 'PALLA IN SETA CON CROCE - 50/63123', description = '' WHERE id_product = '21040' 04/05/2023 12:45:46 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0.0000' WHERE id_product = '21040' 04/05/2023 12:45:46 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0.0000', id_tax_rules_group = '1', id_category_default = '450', id_argoment_default = '42', id_internal_category = '4', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21040' 04/05/2023 12:45:46 pm >> DELETE FROM ps_specific_price WHERE id_product = '21040' 04/05/2023 12:45:47 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 = '21040' 04/05/2023 12:45:47 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21041' , '1' , '' , 'nuovo-prodotto' ) 04/05/2023 12:45:47 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 '21041' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21040' 04/05/2023 12:45:47 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21041' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21040' 04/05/2023 12:46:52 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '60/1010' AND id_product != '21041' AND ean13 != '' 04/05/2023 12:46:52 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '60/1010', date_upd = NOW() WHERE id_product = '21041' 04/05/2023 12:46:52 pm >> UPDATE ps_product_lang SET name = 'COMPLETO MESSA LINO RIC. A MANO - 60/1010', description = '' WHERE id_product = '21041' 04/05/2023 12:46:52 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0.0000' WHERE id_product = '21041' 04/05/2023 12:46:52 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0.0000', id_tax_rules_group = '1', id_category_default = '450', id_argoment_default = '42', id_internal_category = '4', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21041' 04/05/2023 12:46:52 pm >> DELETE FROM ps_specific_price WHERE id_product = '21041' 04/05/2023 12:46:56 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 = '21041' 04/05/2023 12:46:56 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21042' , '1' , '' , 'nuovo-prodotto' ) 04/05/2023 12:46:56 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 '21042' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21041' 04/05/2023 12:46:56 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21042' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21041' 04/05/2023 12:47:31 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '60/3113' AND id_product != '21042' AND ean13 != '' 04/05/2023 12:47:31 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '60/3113', date_upd = NOW() WHERE id_product = '21042' 04/05/2023 12:47:31 pm >> UPDATE ps_product_lang SET name = 'AMITTO MISTO LANA - 60/3113', description = '' WHERE id_product = '21042' 04/05/2023 12:47:31 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0.0000' WHERE id_product = '21042' 04/05/2023 12:47:31 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0.0000', id_tax_rules_group = '1', id_category_default = '450', id_argoment_default = '42', id_internal_category = '4', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21042' 04/05/2023 12:47:31 pm >> DELETE FROM ps_specific_price WHERE id_product = '21042' 04/05/2023 12:47:33 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 = '21042' 04/05/2023 12:47:33 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21043' , '1' , '' , 'nuovo-prodotto' ) 04/05/2023 12:47:33 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 '21043' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21042' 04/05/2023 12:47:33 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21043' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21042' 04/05/2023 12:48:23 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '75/1633' AND id_product != '21043' AND ean13 != '' 04/05/2023 12:48:23 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '75/1633', date_upd = NOW() WHERE id_product = '21043' 04/05/2023 12:48:23 pm >> UPDATE ps_product_lang SET name = 'STOLA IN LANA TESS. TELAIO - 75/1633', description = '' WHERE id_product = '21043' 04/05/2023 12:48:23 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0.0000' WHERE id_product = '21043' 04/05/2023 12:48:23 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0.0000', id_tax_rules_group = '1', id_category_default = '450', id_argoment_default = '42', id_internal_category = '4', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21043' 04/05/2023 12:48:23 pm >> DELETE FROM ps_specific_price WHERE id_product = '21043' 04/05/2023 12:48:24 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 = '21043' 04/05/2023 12:48:24 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21044' , '1' , '' , 'nuovo-prodotto' ) 04/05/2023 12:48:24 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 '21044' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21043' 04/05/2023 12:48:24 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21044' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21043' 04/05/2023 12:48:57 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '75/1602' AND id_product != '21044' AND ean13 != '' 04/05/2023 12:48:57 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '75/1602', date_upd = NOW() WHERE id_product = '21044' 04/05/2023 12:48:57 pm >> UPDATE ps_product_lang SET name = 'STOLA IN LANA TESS. TELAIO - 75/1602', description = '' WHERE id_product = '21044' 04/05/2023 12:48:57 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0.0000' WHERE id_product = '21044' 04/05/2023 12:48:57 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0.0000', id_tax_rules_group = '1', id_category_default = '450', id_argoment_default = '42', id_internal_category = '4', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21044' 04/05/2023 12:48:57 pm >> DELETE FROM ps_specific_price WHERE id_product = '21044' 04/05/2023 12:49:00 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 = '21044' 04/05/2023 12:49:00 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21045' , '1' , '' , 'nuovo-prodotto' ) 04/05/2023 12:49:00 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 '21045' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21044' 04/05/2023 12:49:00 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21045' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21044' 04/05/2023 12:59:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '1507' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-04') 04/05/2023 12:59:15 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' , '1507' , '2023-05-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.50' , '2.50' , NOW() , NOW() ) 04/05/2023 12:59:15 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84146' 04/05/2023 12:59:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '84146' 04/05/2023 12:59:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84146' , '21030' , 'MAGGIO CON MARIA' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '0' , '2.50' ) 04/05/2023 05:07:53 pm >> SELECT document_num FROM ps_document WHERE document_num = '1508' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-04') 04/05/2023 05:07:54 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' , '1508' , '2023-05-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.35' , '12.35' , NOW() , NOW() ) 04/05/2023 05:07:54 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 = '84147' 04/05/2023 05:07:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '84147' 04/05/2023 05:07: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 ( '84147' , '15024' , 'CATECHISMO DELLA CHIESA CATTOLICA N.E.' , '1' , '-1' , '4' , '13.00' , '13' , '0' , '5' , '12.35' ) 04/05/2023 05:14:16 pm >> SELECT document_num FROM ps_document WHERE document_num = '1509' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2023-05-04') 04/05/2023 05:14:16 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' , '1509' , '2023-05-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.00' , '1.64' , NOW() , NOW() ) 04/05/2023 05:14: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 = '84148' 04/05/2023 05:14:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '84148' 04/05/2023 05:14: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 ( '84148' , '791' , 'ASSISI IN BUSTA BATTESIMO - 20X270 - BAAS' , '1' , '-1' , '1' , '2' , '1.6393442622951' , '22' , '0' , '2.00' ) 04/05/2023 05:15:24 pm >> SELECT document_num FROM ps_document WHERE document_num = '1510' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-04') 04/05/2023 05:15:24 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1510' , '2023-05-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.50' , '7.97' , NOW() , NOW() ) 04/05/2023 05:15:24 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84149' 04/05/2023 05:15:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '84149' 04/05/2023 05:15:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84149' , '18134' , 'CROCE SAN BENEDETTO CM 7 - CSB3' , '1' , '-1' , '1' , '4.50' , '3.6885245901639' , '22' , '0' , '4.50' ) 04/05/2023 05:15:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84149' , '19231' , 'CARD CARLO ACUTIS - RN93' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 04/05/2023 05:15:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84149' , '3104' , 'CROCE SAN BENEDETTO - CARTONCINO' , '2' , '-2' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '3.00' ) 04/05/2023 05:15:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84149' , '19138' , 'ATTO DI ABBANDONO - D. D. RUOTOLO' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 04/05/2023 05:21:37 pm >> SELECT document_num FROM ps_document WHERE document_num = '1511' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-04') 04/05/2023 05:21:37 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1511' , '2023-05-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.30' , '5.98' , NOW() , NOW() ) 04/05/2023 05:21:37 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84150' 04/05/2023 05:21:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '84150' 04/05/2023 05:21:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84150' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '6' , '4.9180327868852' , '22' , '0' , '6.00' ) 04/05/2023 05:21:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84150' , '12936' , 'SCATOLA 4X4' , '1' , '-1' , '1' , '0.3' , '0.24590163934426' , '22' , '0' , '0.30' ) 04/05/2023 05:21:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84150' , '7924' , 'PERGAMENE - BATTESIMO MOD. A' , '2' , '-2' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '1.00' ) 04/05/2023 05:40:24 pm >> SELECT document_num FROM ps_document WHERE document_num = '1512' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-04') 04/05/2023 05:40:24 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1512' , '2023-05-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '51.50' , '42.21' , NOW() , NOW() ) 04/05/2023 05:40:24 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84151' 04/05/2023 05:40:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '84151' 04/05/2023 05:40: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 ( '84151' , '20186' , 'COPPIA ANGELI CON COFANETTO - AR28' , '1' , '-1' , '1' , '6.50' , '5.327868852459' , '22' , '0' , '6.50' ) 04/05/2023 05:40: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 ( '84151' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '45' , '36.885245901639' , '22' , '0' , '45.00' ) 04/05/2023 05:40:53 pm >> SELECT document_num FROM ps_document WHERE document_num = '1513' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-04') 04/05/2023 05:40:53 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' , '1513' , '2023-05-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '45.00' , '45.00' , NOW() , NOW() ) 04/05/2023 05:40: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 = '84152' 04/05/2023 05:40:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '84152' 04/05/2023 05:40: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 ( '84152' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '45' , '45' , '0' , '0' , '45.00' ) 04/05/2023 05:43:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '1514' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-04') 04/05/2023 05:43:55 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' , '1514' , '2023-05-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.12' , '9.12' , NOW() , NOW() ) 04/05/2023 05:43:55 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 = '84153' 04/05/2023 05:43:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '84153' 04/05/2023 05:43:55 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 ( '84153' , '12253' , 'MIO LIBRO DI PREGHIERE' , '2' , '-2' , '4' , '2.80' , '2.8' , '0' , '5' , '5.32' ) 04/05/2023 05:43:55 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 ( '84153' , '8398' , 'PREGHIERE PRIMA E DOPO LA COMUNIONE - 8276' , '1' , '-1' , '4' , '4.00' , '4' , '0' , '5' , '3.80' ) 04/05/2023 05:52:39 pm >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '20071' 04/05/2023 05:52:39 pm >> UPDATE ps_stock_available SET quantity = quantity + '-2' WHERE id_product = '20071' 04/05/2023 05:55:23 pm >> SELECT document_num FROM ps_document WHERE document_num = '1515' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2023-05-04') 04/05/2023 05:55:23 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' , '1515' , '2023-05-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.00' , '2.00' , NOW() , NOW() ) 04/05/2023 05:55: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 = '84154' 04/05/2023 05:55:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '84154' 04/05/2023 05:55: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 ( '84154' , '4842' , 'HUMANAE VITAE' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 04/05/2023 05:58:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '1516' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-04') 04/05/2023 05:58:32 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1516' , '2023-05-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '42.86' , '42.86' , NOW() , NOW() ) 04/05/2023 05:58:32 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84155' 04/05/2023 05:58:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '84155' 04/05/2023 05:58:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84155' , '4842' , 'HUMANAE VITAE' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 04/05/2023 05:58:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84155' , '16822' , 'POPULORUM PROGRESSIO' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 04/05/2023 05:58:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84155' , '21027' , 'CENTESIMUS ANNUS' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 04/05/2023 05:58:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84155' , '21026' , 'LABOREM EXERCENS' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 04/05/2023 05:58:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84155' , '19143' , 'BIBBIA SCRUTATE - TASC.' , '1' , '-1' , '4' , '33.00' , '33' , '0' , '5' , '31.35' ) 04/05/2023 06:06:51 pm >> SELECT document_num FROM ps_document WHERE document_num = '1517' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-04') 04/05/2023 06:06:51 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1517' , '2023-05-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.00' , '7.69' , NOW() , NOW() ) 04/05/2023 06:06:51 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84156' 04/05/2023 06:06:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '84156' 04/05/2023 06:06:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84156' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '2' , '-2' , '3' , '4.00' , '3.8461538461538' , '4' , '0' , '8.00' ) 04/05/2023 06:54:18 pm >> SELECT document_num FROM ps_document WHERE document_num = '1518' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-04') 04/05/2023 06:54:18 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' , '1518' , '2023-05-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '140.00' , '114.75' , NOW() , NOW() ) 04/05/2023 06:54:18 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 = '84157' 04/05/2023 06:54:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '84157' 04/05/2023 06:54:18 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 ( '84157' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '140' , '114.75409836066' , '22' , '0' , '140.00' )