18/01/2025 10:04:50 am >> SELECT document_num FROM ps_document WHERE document_num = '182' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-18') 18/01/2025 10:04:50 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' , '182' , '2025-01-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.00' , '13.93' , NOW() , NOW() ) 18/01/2025 10:04:50 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 = '95337' 18/01/2025 10:04:50 am >> DELETE FROM ps_document_detail WHERE id_document = '95337' 18/01/2025 10:04:50 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 ( '95337' , '22300' , 'BRUCIA INCENSO NIKEL CM 8' , '1' , '-1' , '1' , '14.00' , '11.475409836066' , '22' , '0' , '14.00' ) 18/01/2025 10:04:50 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 ( '95337' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '3' , '2.4590163934426' , '22' , '0' , '3.00' ) 18/01/2025 10:45:34 am >> SELECT document_num FROM ps_document WHERE document_num = '183' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-18') 18/01/2025 10:45:34 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' , '183' , '2025-01-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '36.10' , '36.10' , NOW() , NOW() ) 18/01/2025 10:45:34 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 = '95338' 18/01/2025 10:45:34 am >> DELETE FROM ps_document_detail WHERE id_document = '95338' 18/01/2025 10:45:34 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 ( '95338' , '11881' , 'IO E TE - BIBBIA DEI PICCOLI - 8828' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 18/01/2025 10:45:34 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 ( '95338' , '16704' , 'BIBBIA RACCONTATA AI RAGAZZI' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 18/01/2025 10:45:35 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 ( '95338' , '15722' , 'BIBBIA DEI PICCOLI' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 18/01/2025 11:30:31 am >> SELECT document_num FROM ps_document WHERE document_num = '184' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-18') 18/01/2025 11:30: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' , '184' , '2025-01-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '200.00' , '163.93' , NOW() , NOW() ) 18/01/2025 11:30: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 = '95339' 18/01/2025 11:30:31 am >> DELETE FROM ps_document_detail WHERE id_document = '95339' 18/01/2025 11:30: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 ( '95339' , '22233' , 'CAMICE MISTO LANA - 70/000150' , '1' , '-1' , '1' , '200' , '163.93442622951' , '22' , '0' , '200.00' ) 18/01/2025 11:30:44 am >> SELECT document_num FROM ps_document WHERE document_num = '185' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-18') 18/01/2025 11:30:44 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' , '185' , '2025-01-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.00' , '14.00' , NOW() , NOW() ) 18/01/2025 11:30:44 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 = '95340' 18/01/2025 11:30:44 am >> DELETE FROM ps_document_detail WHERE id_document = '95340' 18/01/2025 11:30:44 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 ( '95340' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '20' , '-20' , '4' , '0.70' , '0.7' , '0' , '0' , '14.00' ) 18/01/2025 11:39:17 am >> SELECT document_num FROM ps_document WHERE document_num = '186' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-18') 18/01/2025 11:39: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' , '186' , '2025-01-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '18.00' , '14.75' , NOW() , NOW() ) 18/01/2025 11:39: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 = '95341' 18/01/2025 11:39:17 am >> DELETE FROM ps_document_detail WHERE id_document = '95341' 18/01/2025 11:39: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 ( '95341' , '22105' , 'CANDELINE NON GOCCIOLANTI IN BUSTA - CHA25' , '1' , '-1' , '1' , '18.00' , '14.754098360656' , '22' , '0' , '18.00' ) 18/01/2025 11:57:57 am >> SELECT document_num FROM ps_document WHERE document_num = '187' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-18') 18/01/2025 11:57: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' , '187' , '2025-01-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '55.00' , '45.08' , NOW() , NOW() ) 18/01/2025 11:57: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 = '95342' 18/01/2025 11:57:57 am >> DELETE FROM ps_document_detail WHERE id_document = '95342' 18/01/2025 11:57: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 ( '95342' , '19071' , 'BAMBINELLO CM 32 - PB9941' , '1' , '-1' , '1' , '55' , '45.081967213115' , '22' , '0' , '55.00' ) 18/01/2025 12:02:12 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 18/01/2025 12:02:12 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23351' , '1' , '' , 'nuovo-prodotto' ) 18/01/2025 12:02:12 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '23351' , '1' , '1' , '2' , NOW() , NOW() ) 18/01/2025 12:02:12 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '23351' , '0' , '1' , '0' , '0' ) 18/01/2025 12:26:36 pm >> SELECT document_num FROM ps_document WHERE document_num = '188' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-18') 18/01/2025 12:26:36 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '188' , '2025-01-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '55.00' , '53.51' , NOW() , NOW() ) 18/01/2025 12:26: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 = '95343' 18/01/2025 12:26:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '95343' 18/01/2025 12:26: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 ( '95343' , '21614' , 'RITO DEL BATTESIMO DEI BAMBINI N.E.' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '5' , '19.00' ) 18/01/2025 12:26: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 ( '95343' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 18/01/2025 12:26: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 ( '95343' , '22199' , 'VINO LIQUOROSO ROSSO ' , '1' , '-1' , '1' , '7.39' , '6.0573770491803' , '22' , '0' , '7.39' ) 18/01/2025 12:26: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 ( '95343' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '7' , '7' , '0' , '5' , '6.65' ) 18/01/2025 12:26: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 ( '95343' , '23239' , 'TU SEI AMATO - P. CURTAZ' , '1' , '-1' , '4' , '18.90' , '18.9' , '0' , '5' , '17.96' ) 18/01/2025 12:34:50 pm >> SELECT document_num FROM ps_document WHERE document_num = '189' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-18') 18/01/2025 12:34:50 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' , '189' , '2025-01-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '37.91' , '37.91' , NOW() , NOW() ) 18/01/2025 12:34: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 = '95344' 18/01/2025 12:34:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '95344' 18/01/2025 12:34: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 ( '95344' , '23028' , 'SU E GIU SULLE SCALE PAZZE - GIOCO' , '1' , '-1' , '4' , '22.00' , '22' , '0' , '5' , '20.90' ) 18/01/2025 12:34: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 ( '95344' , '10430' , 'TABOR' , '1' , '-1' , '4' , '17.90' , '17.9' , '0' , '5' , '17.01' ) 18/01/2025 12:47:58 pm >> SELECT document_num FROM ps_document WHERE document_num = '190' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-18') 18/01/2025 12:47: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' , '190' , '2025-01-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '55.00' , '45.08' , NOW() , NOW() ) 18/01/2025 12:47: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 = '95345' 18/01/2025 12:47:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '95345' 18/01/2025 12:47: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 ( '95345' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '55' , '45.081967213115' , '22' , '0' , '55.00' ) 18/01/2025 12:49:18 pm >> SELECT document_num FROM ps_document WHERE document_num = '191' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-18') 18/01/2025 12:49: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' , '191' , '2025-01-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.03' , '14.80' , NOW() , NOW() ) 18/01/2025 12:49: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 = '95346' 18/01/2025 12:49:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '95346' 18/01/2025 12:49: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 ( '95346' , '23313' , 'LITURGIA PENITENZIALE COMUNITARIA' , '1' , '-1' , '4' , '9.50' , '9.5' , '0' , '5' , '9.03' ) 18/01/2025 12:49: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 ( '95346' , '7311' , 'OSTIA SOTTILE 74MM' , '3' , '-3' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '6.00' )