22/04/2024 08:34:27 am >> SELECT document_num FROM ps_document WHERE document_num = '1226' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-22') 22/04/2024 08:34:27 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1226' , '2024-04-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 22/04/2024 08:34:27 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91358' 22/04/2024 08:34:27 am >> DELETE FROM ps_document_detail WHERE id_document = '91358' 22/04/2024 08:34: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 ( '91358' , '11097' , 'VANGELO E ATTI DEGLI APOSTOLI' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 22/04/2024 04:47:54 pm >> SELECT document_num FROM ps_document WHERE document_num = '52/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-04-22') 22/04/2024 04:47: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 ( '24' , '52/A' , '2024-04-22' , 'A' , '540' , '0' , '4673023' , 'CORSO GARIBALDI, 6 84025 EBOLI' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '990.00' , '990.00' , NOW() , NOW() ) 22/04/2024 04:47: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 = '91359' 22/04/2024 04:47:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '91359' 22/04/2024 04:47: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 ( '91359' , '' , 'TUNICA PRIMA COMUNIONE' , '22' , '-22' , '0' , '45' , '45' , '' , '0' , '990.00' ) 22/04/2024 04:50:13 pm >> SELECT document_num FROM ps_document WHERE document_num = '1227' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-22') 22/04/2024 04:50:13 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1227' , '2024-04-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.50' , '16.83' , NOW() , NOW() ) 22/04/2024 04:50:13 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91360' 22/04/2024 04:50:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '91360' 22/04/2024 04:50:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91360' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '5' , '-5' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '17.50' ) 22/04/2024 04:56:30 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 22/04/2024 04:56:30 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22427' , '1' , '' , 'nuovo-prodotto' ) 22/04/2024 04:56:30 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '22427' , '1' , '1' , '2' , NOW() , NOW() ) 22/04/2024 04:56:30 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '22427' , '0' , '1' , '0' , '0' ) 22/04/2024 05:00:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '1228' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-22') 22/04/2024 05:00:45 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' , '1228' , '2024-04-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.90' , '9.52' , NOW() , NOW() ) 22/04/2024 05:00:45 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 = '91361' 22/04/2024 05:00:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '91361' 22/04/2024 05:00:45 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 ( '91361' , '20431' , 'PARTICOLA TAGLIO CHIUSO 35MM - W500' , '3' , '-3' , '3' , '3.30' , '3.1730769230769' , '4' , '0' , '9.90' ) 22/04/2024 05:06:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '1070' AND id_document != '91161' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-08') 22/04/2024 05:06:11 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1070', document_date = '2024-04-08', 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 = '55.00', price_tax_excluded = '45.08', date_upd = NOW() WHERE id_document = '91161' 22/04/2024 05:06:11 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91161' 22/04/2024 05:06:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '91161' 22/04/2024 05:06:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91161' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '2.50' ) 22/04/2024 05:06:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91161' , '11756' , 'VINO BIANCO SECCO - 14%' , '8' , '-8' , '1' , '6.0000' , '4.9180327868852' , '22' , '0' , '48.00' ) 22/04/2024 05:06:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91161' , '3144' , 'CROCE TRILOBATA ' , '1' , '-1' , '1' , '4.50' , '3.6885245901639' , '22' , '0' , '4.50' ) 22/04/2024 05:07:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '1229' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-22') 22/04/2024 05:07:31 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' , '1229' , '2024-04-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '72.61' , '63.95' , NOW() , NOW() ) 22/04/2024 05:07:31 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 = '91362' 22/04/2024 05:07:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '91362' 22/04/2024 05:07:31 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 ( '91362' , '19560' , 'PERGAMENA COMUNIONE 17X25' , '40' , '-40' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '28.00' ) 22/04/2024 05:07:31 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 ( '91362' , '22370' , 'DIGNITAS INFINITA' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 22/04/2024 05:07:31 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 ( '91362' , '22384' , 'ERESIA DELLINFORME - M. MOSEBACH' , '1' , '-1' , '4' , '22.00' , '22' , '0' , '5' , '20.90' ) 22/04/2024 05:07:31 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 ( '91362' , '16311' , 'DECINA MISSIONARIA - FR17-2' , '40' , '-40' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '20.00' ) 22/04/2024 05:08:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '1230' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-22') 22/04/2024 05:08:43 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' , '1230' , '2024-04-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '47.98' , '47.98' , NOW() , NOW() ) 22/04/2024 05:08:43 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91363' 22/04/2024 05:08:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '91363' 22/04/2024 05:08:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91363' , '19519' , 'CHARLES DE FOUCAULD - M. S. MOSTAJO' , '1' , '-1' , '4' , '17.00' , '17' , '0' , '5' , '16.15' ) 22/04/2024 05:08:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91363' , '22385' , 'SECRETUM - M. FRANCO' , '1' , '-1' , '4' , '20.50' , '20.5' , '0' , '5' , '19.48' ) 22/04/2024 05:08:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91363' , '22271' , 'ADFORAZIONE EUCARISTICA - G. MORETTI' , '1' , '-1' , '4' , '13.00' , '13' , '0' , '5' , '12.35' ) 22/04/2024 05:09:35 pm >> SELECT document_num FROM ps_document WHERE document_num = '1231' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-22') 22/04/2024 05:09: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' , '1231' , '2024-04-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '90.00' , '73.77' , NOW() , NOW() ) 22/04/2024 05:09: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 = '91364' 22/04/2024 05:09:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '91364' 22/04/2024 05:09: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 ( '91364' , '22199' , 'VINO LIQUOROSO ROSSO ' , '12' , '-12' , '1' , '7.5' , '6.1475409836066' , '22' , '0' , '90.00' ) 22/04/2024 05:10:10 pm >> SELECT document_num FROM ps_document WHERE document_num = '1232' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-22') 22/04/2024 05:10:10 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' , '1232' , '2024-04-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 22/04/2024 05:10:10 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 = '91365' 22/04/2024 05:10:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '91365' 22/04/2024 05:10:10 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 ( '91365' , '22341' , 'SULLA TUA PAROLA - MAG/GIU 2024' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 22/04/2024 05:10:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '1233' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-22') 22/04/2024 05:10:39 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' , '1233' , '2024-04-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '28.50' , '28.50' , NOW() , NOW() ) 22/04/2024 05:10:39 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 = '91366' 22/04/2024 05:10:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '91366' 22/04/2024 05:10:39 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 ( '91366' , '22341' , 'SULLA TUA PAROLA - MAG/GIU 2024' , '6' , '-6' , '4' , '5.00' , '5' , '0' , '5' , '28.50' ) 22/04/2024 05:11:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '1234' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-22') 22/04/2024 05:11:14 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' , '1234' , '2024-04-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '49.00' , '47.12' , NOW() , NOW() ) 22/04/2024 05:11:14 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91367' 22/04/2024 05:11:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '91367' 22/04/2024 05:11:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91367' , '20431' , 'PARTICOLA TAGLIO CHIUSO 35MM - W500' , '10' , '-10' , '3' , '3.30' , '3.1730769230769' , '4' , '0' , '33.00' ) 22/04/2024 05:11:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91367' , '7311' , 'OSTIA SOTTILE 74MM' , '8' , '-8' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '16.00' ) 22/04/2024 05:14:40 pm >> SELECT document_num FROM ps_document WHERE document_num = '1235' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-22') 22/04/2024 05:14:40 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' , '1235' , '2024-04-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '110.00' , '90.16' , NOW() , NOW() ) 22/04/2024 05:14:40 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 = '91368' 22/04/2024 05:14:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '91368' 22/04/2024 05:14:40 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 ( '91368' , '21377' , 'CASULA POLIESTERE IHS' , '1' , '-1' , '1' , '55' , '45.081967213115' , '22' , '0' , '55.00' ) 22/04/2024 05:14:40 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 ( '91368' , '21376' , 'CASULA POL. LEGGERO - CS25L' , '1' , '-1' , '1' , '55' , '45.081967213115' , '22' , '0' , '55.00' ) 22/04/2024 05:57:24 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788863664096' AND id_product != '22427' AND ean13 != '' 22/04/2024 05:57:25 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788863664096', date_upd = NOW() WHERE id_product = '22427' 22/04/2024 05:57:25 pm >> UPDATE ps_product_lang SET name = 'ALL\'ASCOLTO DELLA PAROLA - M. DELBREL', description = '' WHERE id_product = '22427' 22/04/2024 05:57:25 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '9.5' WHERE id_product = '22427' 22/04/2024 05:57:25 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '9.5', id_tax_rules_group = '4', id_category_default = '24', id_argoment_default = '', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22427' 22/04/2024 05:57:25 pm >> DELETE FROM ps_specific_price WHERE id_product = '22427' 22/04/2024 05:57:25 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 = '22427' 22/04/2024 05:57:25 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22428' , '1' , '' , 'nuovo-prodotto' ) 22/04/2024 05:57:25 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 '22428' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22427' 22/04/2024 05:57:26 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22428' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22427' 22/04/2024 05:57:54 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788863661149' AND id_product != '22428' AND ean13 != '' 22/04/2024 05:57:54 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788863661149', date_upd = NOW() WHERE id_product = '22428' 22/04/2024 05:57:54 pm >> UPDATE ps_product_lang SET name = 'PRETE SI CONFESSA - A. PRONZATO', description = '' WHERE id_product = '22428' 22/04/2024 05:57:54 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '13' WHERE id_product = '22428' 22/04/2024 05:57:54 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '13', id_tax_rules_group = '4', id_category_default = '24', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22428' 22/04/2024 05:57:54 pm >> DELETE FROM ps_specific_price WHERE id_product = '22428' 22/04/2024 05:57:55 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 = '22428' 22/04/2024 05:57:55 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22429' , '1' , '' , 'nuovo-prodotto' ) 22/04/2024 05:57:55 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 '22429' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22428' 22/04/2024 05:57:55 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22429' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22428' 22/04/2024 05:58:30 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892984264' AND id_product != '22429' AND ean13 != '' 22/04/2024 05:58:30 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788892984264', date_upd = NOW() WHERE id_product = '22429' 22/04/2024 05:58:30 pm >> UPDATE ps_product_lang SET name = 'DAVIDE IL BAMBINO - C. SIGNORELLI', description = '' WHERE id_product = '22429' 22/04/2024 05:58:30 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '15' WHERE id_product = '22429' 22/04/2024 05:58:30 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '15', id_tax_rules_group = '4', id_category_default = '146', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22429' 22/04/2024 05:58:30 pm >> DELETE FROM ps_specific_price WHERE id_product = '22429' 22/04/2024 05:58:31 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 = '22429' 22/04/2024 05:58:31 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22430' , '1' , '' , 'nuovo-prodotto' ) 22/04/2024 05:58:31 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 '22430' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22429' 22/04/2024 05:58:31 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22430' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22429' 22/04/2024 05:59:03 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892984479' AND id_product != '22430' AND ean13 != '' 22/04/2024 05:59:03 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788892984479', date_upd = NOW() WHERE id_product = '22430' 22/04/2024 05:59:03 pm >> UPDATE ps_product_lang SET name = 'MADONNA DI FATIMA - W. WALSH', description = '' WHERE id_product = '22430' 22/04/2024 05:59:03 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '16' WHERE id_product = '22430' 22/04/2024 05:59:03 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '16', id_tax_rules_group = '4', id_category_default = '146', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22430' 22/04/2024 05:59:03 pm >> DELETE FROM ps_specific_price WHERE id_product = '22430' 22/04/2024 05:59:04 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 = '22430' 22/04/2024 05:59:04 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22431' , '1' , '' , 'nuovo-prodotto' ) 22/04/2024 05:59:04 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 '22431' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22430' 22/04/2024 05:59:04 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22431' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22430' 22/04/2024 06:00:03 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791280210333' AND id_product != '22431' AND ean13 != '' 22/04/2024 06:00:03 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9791280210333', date_upd = NOW() WHERE id_product = '22431' 22/04/2024 06:00:03 pm >> UPDATE ps_product_lang SET name = 'TANTO L\'AMORE SI E\' CHINATO', description = '' WHERE id_product = '22431' 22/04/2024 06:00:03 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3' WHERE id_product = '22431' 22/04/2024 06:00:04 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3', id_tax_rules_group = '4', id_category_default = '99', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22431' 22/04/2024 06:00:04 pm >> DELETE FROM ps_specific_price WHERE id_product = '22431' 22/04/2024 06:00:04 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 = '22431' 22/04/2024 06:00:04 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22432' , '1' , '' , 'nuovo-prodotto' ) 22/04/2024 06:00:04 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 '22432' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22431' 22/04/2024 06:00:04 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22432' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22431' 22/04/2024 06:01:27 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791280210234' AND id_product != '22432' AND ean13 != '' 22/04/2024 06:01:27 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9791280210234', date_upd = NOW() WHERE id_product = '22432' 22/04/2024 06:01:27 pm >> UPDATE ps_product_lang SET name = 'IN SINU JESU', description = '' WHERE id_product = '22432' 22/04/2024 06:01:27 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '18' WHERE id_product = '22432' 22/04/2024 06:01:27 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '18', id_tax_rules_group = '4', id_category_default = '99', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22432' 22/04/2024 06:01:27 pm >> DELETE FROM ps_specific_price WHERE id_product = '22432' 22/04/2024 06:01:28 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 = '22432' 22/04/2024 06:01:28 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22433' , '1' , '' , 'nuovo-prodotto' ) 22/04/2024 06:01:28 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 '22433' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22432' 22/04/2024 06:01:28 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22433' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22432' 22/04/2024 06:03:41 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '1967' , '2024-04-17' , '' , '0' , '47' , '2642' , 'V.LE BACCHIGLIONE, 20 20139 MILANO' , '' , '' , '5' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '57.50' , '57.50' , NOW() , NOW() ) 22/04/2024 06:03:41 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 = '91369' 22/04/2024 06:03:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '91369' 22/04/2024 06:03:41 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 ( '91369' , '22427' , 'ALLASCOLTO DELLA PAROLA - M. DELBREL' , '1' , '1' , '4' , '9.50' , '9.5' , '0' , '30' , '6.6500' ) 22/04/2024 06:03:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22427' AND id_supplier = '47' 22/04/2024 06:03:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22427' , '47' , '1' ) 22/04/2024 06:03:41 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 ( '91369' , '22428' , 'PRETE SI CONFESSA - A. PRONZATO' , '1' , '1' , '4' , '13.00' , '13' , '0' , '30' , '9.1000' ) 22/04/2024 06:03:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22428' AND id_supplier = '47' 22/04/2024 06:03:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22428' , '47' , '1' ) 22/04/2024 06:03:41 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 ( '91369' , '22429' , 'DAVIDE IL BAMBINO - C. SIGNORELLI' , '1' , '1' , '4' , '15.00' , '15' , '0' , '30' , '10.5000' ) 22/04/2024 06:03:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22429' AND id_supplier = '47' 22/04/2024 06:03:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22429' , '47' , '1' ) 22/04/2024 06:03:41 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 ( '91369' , '22432' , 'IN SINU JESU' , '1' , '1' , '4' , '18.00' , '18' , '0' , '30' , '12.6000' ) 22/04/2024 06:03:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22432' AND id_supplier = '47' 22/04/2024 06:03:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22432' , '47' , '1' ) 22/04/2024 06:03:41 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 ( '91369' , '22430' , 'MADONNA DI FATIMA - W. WALSH' , '1' , '1' , '4' , '16.00' , '16' , '0' , '30' , '11.2000' ) 22/04/2024 06:03:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22430' AND id_supplier = '47' 22/04/2024 06:03:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22430' , '47' , '1' ) 22/04/2024 06:03:41 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 ( '91369' , '22431' , 'TANTO LAMORE SI E CHINATO' , '1' , '1' , '4' , '3.00' , '3' , '0' , '30' , '2.1000' ) 22/04/2024 06:03:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22431' AND id_supplier = '47' 22/04/2024 06:03:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22431' , '47' , '1' ) 22/04/2024 06:03:41 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 ( '91369' , '22109' , 'QUINDICI MINUTI S. ANTONIO MARIA CLARET' , '1' , '1' , '4' , '0.50' , '0.5' , '0' , '30' , '0.3500' ) 22/04/2024 06:03:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22109' AND id_supplier = '47' 22/04/2024 06:03:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22109' , '47' , '1' ) 22/04/2024 06:29:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '1236' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-22') 22/04/2024 06:29:14 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' , '1236' , '2024-04-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '162.60' , '133.28' , NOW() , NOW() ) 22/04/2024 06:29:14 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91370' 22/04/2024 06:29:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '91370' 22/04/2024 06:29:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91370' , '15403' , 'CROCE IN RESINA CM 9 - 3806/G052' , '40' , '-40' , '1' , '3.5' , '2.8688524590164' , '22' , '0' , '140.00' ) 22/04/2024 06:29:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91370' , '12142' , 'MADONNA DI FATIMA - 157BIS' , '2' , '-2' , '1' , '3.5' , '2.8688524590164' , '22' , '0' , '7.00' ) 22/04/2024 06:29:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91370' , '3074' , 'CROCE PRIMA COMUNIONE LEGNO CHIARO - 713/11' , '12' , '-12' , '1' , '1.30' , '1.0655737704918' , '22' , '0' , '15.60' ) 22/04/2024 06:33:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '1237' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-22') 22/04/2024 06:33:39 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' , '1237' , '2024-04-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.50' , '2.87' , NOW() , NOW() ) 22/04/2024 06:33:39 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 = '91371' 22/04/2024 06:33:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '91371' 22/04/2024 06:33:39 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 ( '91371' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.5' , '2.8688524590164' , '22' , '0' , '3.50' ) 22/04/2024 06:44:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '1238' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-22') 22/04/2024 06:44:00 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' , '1238' , '2024-04-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.00' , '3.00' , NOW() , NOW() ) 22/04/2024 06:44:00 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 = '91372' 22/04/2024 06:44:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '91372' 22/04/2024 06:44:00 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 ( '91372' , '16345' , 'REGOLA DELLORDINE FRANCESCANO SECOLARE' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '0' , '3.00' ) 22/04/2024 06:48:48 pm >> SELECT ean13 FROM ps_product WHERE ean13 = 'P404' AND id_product != '12824' AND ean13 != '' 22/04/2024 06:48:48 pm >> UPDATE ps_product SET id_supplier = '95', reference = '', ean13 = 'P404', date_upd = NOW() WHERE id_product = '12824' 22/04/2024 06:48:48 pm >> UPDATE ps_product_lang SET name = 'PIZZO MARIANO - P404', description = '' WHERE id_product = '12824' 22/04/2024 06:48:48 pm >> UPDATE ps_product SET wholesale_price = '16.88', on_sale = '0', price = '36.8852' WHERE id_product = '12824' 22/04/2024 06:48:48 pm >> UPDATE ps_product_shop SET wholesale_price = '16.88', price = '36.8852', id_tax_rules_group = '1', id_category_default = '411', 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 = '12824' 22/04/2024 06:48:48 pm >> DELETE FROM ps_specific_price WHERE id_product = '12824' 22/04/2024 06:49:23 pm >> SELECT ean13 FROM ps_product WHERE ean13 = 'P404' AND id_product != '12824' AND ean13 != '' 22/04/2024 06:49:23 pm >> UPDATE ps_product SET id_supplier = '95', reference = '', ean13 = 'P404', date_upd = NOW() WHERE id_product = '12824' 22/04/2024 06:49:23 pm >> UPDATE ps_product_lang SET name = 'PIZZO MARIANO - P404', description = '' WHERE id_product = '12824' 22/04/2024 06:49:23 pm >> UPDATE ps_product SET wholesale_price = '16.88', on_sale = '0', price = '42.622950819672134' WHERE id_product = '12824' 22/04/2024 06:49:23 pm >> UPDATE ps_product_shop SET wholesale_price = '16.88', price = '42.622950819672134', id_tax_rules_group = '1', id_category_default = '411', 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 = '12824' 22/04/2024 06:49:23 pm >> DELETE FROM ps_specific_price WHERE id_product = '12824' 22/04/2024 06:56:33 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '22178' AND id_product != '22433' AND ean13 != '' 22/04/2024 06:56:33 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '22178', date_upd = NOW() WHERE id_product = '22433' 22/04/2024 06:56:33 pm >> UPDATE ps_product_lang SET name = 'COPRI BOTTONE - 22178', description = '' WHERE id_product = '22433' 22/04/2024 06:56:33 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '16.39344262295082' WHERE id_product = '22433' 22/04/2024 06:56:33 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '16.39344262295082', id_tax_rules_group = '1', id_category_default = '411', 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 = '22433' 22/04/2024 06:56:33 pm >> DELETE FROM ps_specific_price WHERE id_product = '22433' 22/04/2024 06:56:34 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 = '22433' 22/04/2024 06:56:34 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22434' , '1' , '' , 'nuovo-prodotto' ) 22/04/2024 06:56:34 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 '22434' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22433' 22/04/2024 06:56:34 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22434' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22433' 22/04/2024 06:58:56 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002263' AND id_product != '22434' AND ean13 != '' 22/04/2024 06:58:56 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002263', date_upd = NOW() WHERE id_product = '22434' 22/04/2024 06:58:56 pm >> UPDATE ps_product_lang SET name = 'CORDONIERA CROCE PETTORALE - CORD-CP01', description = '' WHERE id_product = '22434' 22/04/2024 06:58:56 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '46.721311475409834' WHERE id_product = '22434' 22/04/2024 06:58:56 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '46.721311475409834', id_tax_rules_group = '1', id_category_default = '411', 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 = '22434' 22/04/2024 06:58:56 pm >> DELETE FROM ps_specific_price WHERE id_product = '22434' 22/04/2024 06:59:28 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 = '22434' 22/04/2024 06:59:28 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22435' , '1' , '' , 'nuovo-prodotto' ) 22/04/2024 06:59:29 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 '22435' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22434' 22/04/2024 06:59:29 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22435' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22434' 22/04/2024 07:00:51 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000850' AND id_product != '14021' AND ean13 != '' 22/04/2024 07:00:51 pm >> UPDATE ps_product SET id_supplier = '95', reference = '', ean13 = '000850', date_upd = NOW() WHERE id_product = '14021' 22/04/2024 07:00:51 pm >> UPDATE ps_product_lang SET name = 'CINGOLO - CING08', description = '' WHERE id_product = '14021' 22/04/2024 07:00:51 pm >> UPDATE ps_product SET wholesale_price = '10.09', on_sale = '0', price = '27.049180327868854' WHERE id_product = '14021' 22/04/2024 07:00:51 pm >> UPDATE ps_product_shop SET wholesale_price = '10.09', price = '27.049180327868854', id_tax_rules_group = '1', id_category_default = '411', 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 = '14021' 22/04/2024 07:00:51 pm >> DELETE FROM ps_specific_price WHERE id_product = '14021' 22/04/2024 07:00:52 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 = '14021' 22/04/2024 07:00:52 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22436' , '1' , '' , 'nuovo-prodotto' ) 22/04/2024 07:00:52 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 '22436' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '14021' 22/04/2024 07:00:52 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22436' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '14021' 22/04/2024 07:07:22 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000471' AND id_product != '21447' AND ean13 != '' 22/04/2024 07:07:22 pm >> UPDATE ps_product SET id_supplier = '95', reference = '', ean13 = '000471', date_upd = NOW() WHERE id_product = '21447' 22/04/2024 07:07:22 pm >> UPDATE ps_product_lang SET name = 'VELO TULLE ', description = '' WHERE id_product = '21447' 22/04/2024 07:07:23 pm >> UPDATE ps_product SET wholesale_price = '24.06', on_sale = '0', price = '50.73770491803279' WHERE id_product = '21447' 22/04/2024 07:07:23 pm >> UPDATE ps_product_shop SET wholesale_price = '24.06', price = '50.73770491803279', id_tax_rules_group = '1', id_category_default = '411', 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 = '21447' 22/04/2024 07:07:23 pm >> DELETE FROM ps_specific_price WHERE id_product = '21447' 22/04/2024 07:08:47 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '191' , '2024-04-12' , '' , '0' , '95' , '2757' , 'VIA A. POLENGHI, 97 26845 CODOGNO' , '' , 'CONTROLLARE NUMERO' , '0.01' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '552.04' , '452.49' , NOW() , NOW() ) 22/04/2024 07:08:47 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91373' 22/04/2024 07:08:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '91373' 22/04/2024 07:08:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91373' , '12824' , 'PIZZO MARIANO - P404' , '13.5' , '13.5' , '1' , '21.65' , '17.745901639344' , '22' , '10' , '320.9179' ) 22/04/2024 07:08:47 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12824' AND id_supplier = '95' 22/04/2024 07:08:47 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12824' , '95' , '1' ) 22/04/2024 07:08:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91373' , '17533' , 'CINGOLO ORO/COL - CING06' , '5' , '5' , '1' , '7.99' , '6.5491803278689' , '22' , '10' , '43.8651' ) 22/04/2024 07:08:47 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17533' AND id_supplier = '95' 22/04/2024 07:08:47 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17533' , '95' , '1' ) 22/04/2024 07:08:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91373' , '22433' , 'COPRI BOTTONE - 22178' , '2' , '2' , '1' , '8.5' , '6.9672131147541' , '22' , '10' , '18.6660' ) 22/04/2024 07:08:47 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22433' AND id_supplier = '95' 22/04/2024 07:08:47 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22433' , '95' , '1' ) 22/04/2024 07:08:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91373' , '22434' , 'CORDONIERA CROCE PETTORALE - CORD-CP01' , '1' , '1' , '1' , '23.1' , '18.934426229508' , '22' , '10' , '25.3638' ) 22/04/2024 07:08:47 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22434' AND id_supplier = '95' 22/04/2024 07:08:47 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22434' , '95' , '1' ) 22/04/2024 07:08:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91373' , '14021' , 'CINGOLO - CING08' , '2' , '2' , '1' , '13.86' , '11.360655737705' , '22' , '10' , '30.4366' ) 22/04/2024 07:08:47 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14021' AND id_supplier = '95' 22/04/2024 07:08:48 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14021' , '95' , '1' ) 22/04/2024 07:08:48 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 ( '91373' , '15893' , 'CINGOLO - CING17' , '1' , '1' , '1' , '19.46' , '15.950819672131' , '22' , '10' , '21.3671' ) 22/04/2024 07:08:48 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15893' AND id_supplier = '95' 22/04/2024 07:08:48 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15893' , '95' , '1' ) 22/04/2024 07:08:48 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 ( '91373' , '16456' , 'CINGOLO - CING03' , '5' , '5' , '1' , '6.33' , '5.1885245901639' , '22' , '10' , '34.7517' ) 22/04/2024 07:08:48 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16456' AND id_supplier = '95' 22/04/2024 07:08:48 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16456' , '95' , '1' ) 22/04/2024 07:08:48 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 ( '91373' , '21447' , 'VELO TULLE ' , '2' , '2' , '1' , '25.8' , '21.147540983607' , '22' , '10' , '56.6568' ) 22/04/2024 07:08:48 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21447' AND id_supplier = '95' 22/04/2024 07:08:48 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21447' , '95' , '1' ) 22/04/2024 07:25:52 pm >> SELECT document_num FROM ps_document WHERE document_num = '1239' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-22') 22/04/2024 07:25:52 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1239' , '2024-04-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '86.00' , '70.49' , NOW() , NOW() ) 22/04/2024 07:25:52 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91374' 22/04/2024 07:25:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '91374' 22/04/2024 07:25:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91374' , '15445' , 'QUADRO DECORATO 61X38' , '1' , '-1' , '1' , '86.00' , '70.491803278689' , '22' , '0' , '86.00' )