15/05/2023 08:26:58 am >> SELECT document_num FROM ps_document WHERE document_num = '21/E' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-05-15') 15/05/2023 08:26:58 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '23' , '21/E' , '2023-05-15' , 'E' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '14' , '0' , '612.00' , '501.64' , NOW() , NOW() ) 15/05/2023 08:26: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 = '84329' 15/05/2023 08:26:58 am >> DELETE FROM ps_document_detail WHERE id_document = '84329' 15/05/2023 08:26:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84329' , '12817' , 'LIBRO DEI MATRIMONI' , '12' , '-12' , '1' , '40.00' , '32.786885245902' , '22' , '40' , '288.00' ) 15/05/2023 08:26:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84329' , '15298' , 'BENEDIZIONI - MARIA MADRE DI DIO' , '1000' , '-1000' , '1' , '0.18' , '0.14754098360656' , '22' , '40' , '108.00' ) 15/05/2023 08:26:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84329' , '1041' , 'BENEDIZIONI - ICONA CRISTO' , '1000' , '-1000' , '1' , '0.18' , '0.14754098360656' , '22' , '40' , '108.00' ) 15/05/2023 08:26:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84329' , '1041' , 'BENEDIZIONI - SACRA FAMIGLIA' , '1000' , '-1000' , '1' , '0.18' , '0.14754098360656' , '22' , '40' , '108.00' ) 15/05/2023 08:29:00 am >> SELECT document_num FROM ps_document WHERE document_num = '23' AND id_document != '' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2023-05-15') 15/05/2023 08:29:00 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 ( '24' , '23' , '2023-05-15' , '' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2950.00' , '2950.00' , NOW() , NOW() ) 15/05/2023 08:29:00 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 = '84330' 15/05/2023 08:29:00 am >> DELETE FROM ps_document_detail WHERE id_document = '84330' 15/05/2023 08:29:00 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 ( '84330' , '15030' , 'PREGHIERE A SAN MICHELE ARCANGELO' , '350' , '-350' , '4' , '1.00' , '1' , '0' , '' , '350.00' ) 15/05/2023 08:29:00 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 ( '84330' , '19727' , 'LITURGIA IN FRAMMENTI - A. SORRENTINO' , '20' , '-20' , '4' , '35.00' , '35' , '0' , '' , '700.00' ) 15/05/2023 08:29:00 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 ( '84330' , '20722' , 'SEMINATORI DI GIOIA' , '200' , '-200' , '4' , '2.50' , '2.5' , '0' , '0' , '500.00' ) 15/05/2023 08:29:00 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 ( '84330' , '20785' , 'CARTA DIDENTITA DEL CREATO - R. LUPI' , '200' , '-200' , '4' , '2.50' , '2.5' , '0' , '0' , '500.00' ) 15/05/2023 08:29:00 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 ( '84330' , '20954' , 'TEMPO DELL’APOCALISSE ' , '60' , '-60' , '4' , '15.00' , '15' , '0' , '0' , '900.00' ) 15/05/2023 08:30:33 am >> SELECT document_num FROM ps_document WHERE document_num = '9' AND id_document != '' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2023-05-15') 15/05/2023 08:30:33 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 ( '24' , '9' , '2023-05-15' , '' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1390.00' , '1390.00' , NOW() , NOW() ) 15/05/2023 08:30:33 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 = '11329' 15/05/2023 08:30:33 am >> DELETE FROM ps_document_detail WHERE id_document = '11329' 15/05/2023 08:30:33 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 ( '11329' , '92' , 'LA PREGHIERA DEL ROSARIO' , '100' , '-100' , '4' , '2.50' , '2.5' , '0' , '0' , '250.00' ) 15/05/2023 08:30:33 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 ( '11329' , '117' , 'La preghiera delle cinque dita n.e.' , '300' , '-300' , '4' , '1.80' , '1.8' , '0' , '0' , '540.00' ) 15/05/2023 08:30:33 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 ( '11329' , '126' , 'SACRAMENTO DEL PERDONO' , '300' , '-300' , '4' , '2.00' , '2' , '0' , '0' , '600.00' ) 15/05/2023 08:35:32 am >> SELECT document_num FROM ps_document WHERE document_num = '24' AND id_document != '' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2023-05-15') 15/05/2023 08:35:32 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '24' , '2023-05-15' , '' , '3906' , '0' , '4674900' , 'VIA CORSICA 9/17 16128 GENOVA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1050.00' , '1050.00' , NOW() , NOW() ) 15/05/2023 08:35:32 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84331' 15/05/2023 08:35:32 am >> DELETE FROM ps_document_detail WHERE id_document = '84331' 15/05/2023 08:35:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84331' , '20954' , 'TEMPO DELL’APOCALISSE ' , '100' , '-100' , '4' , '15.00' , '15' , '0' , '30' , '1050.00' ) 15/05/2023 10:40:23 am >> SELECT document_num FROM ps_document WHERE document_num = '1660' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-15') 15/05/2023 10:40:23 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1660' , '2023-05-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '118.00' , '96.72' , NOW() , NOW() ) 15/05/2023 10:40:23 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84332' 15/05/2023 10:40:23 am >> DELETE FROM ps_document_detail WHERE id_document = '84332' 15/05/2023 10:40:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84332' , '17161' , 'CARBONCINI NERI - CARNE' , '2' , '-2' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '24.00' ) 15/05/2023 10:40:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84332' , '19107' , 'INCENSO GRANI 3A' , '1' , '-1' , '1' , '30.00' , '24.590163934426' , '22' , '0' , '30.00' ) 15/05/2023 10:40:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84332' , '9535' , 'SANTANTONIO DA PADOVA - 381 ' , '2' , '-2' , '1' , '3.80' , '3.1147540983607' , '22' , '0' , '7.60' ) 15/05/2023 10:40:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84332' , '17617' , 'IMMAGINI ISONZO X 100' , '3' , '-3' , '1' , '3.80' , '3.1147540983607' , '22' , '0' , '11.40' ) 15/05/2023 10:40:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84332' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '37' , '30.327868852459' , '22' , '0' , '37.00' ) 15/05/2023 10:40:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84332' , '15392' , 'TELA 18X25 - CROCE' , '1' , '-1' , '1' , '8.00' , '6.5573770491803' , '22' , '0' , '8.00' ) 15/05/2023 11:10:55 am >> SELECT document_num FROM ps_document WHERE document_num = '1661' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-15') 15/05/2023 11:10:55 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' , '1661' , '2023-05-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.30' , '3.17' , NOW() , NOW() ) 15/05/2023 11:10:55 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 = '84333' 15/05/2023 11:10:55 am >> DELETE FROM ps_document_detail WHERE id_document = '84333' 15/05/2023 11:10:55 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 ( '84333' , '20431' , 'PARTICOLA TAGLIO CHIUSO 35MM - W500' , '1' , '-1' , '3' , '3.30' , '3.1730769230769' , '4' , '0' , '3.30' ) 15/05/2023 11:39:20 am >> SELECT document_num FROM ps_document WHERE document_num = '1662' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-15') 15/05/2023 11:39: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' , '1662' , '2023-05-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '527.00' , '458.60' , NOW() , NOW() ) 15/05/2023 11:39: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 = '84334' 15/05/2023 11:39:20 am >> DELETE FROM ps_document_detail WHERE id_document = '84334' 15/05/2023 11:39: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 ( '84334' , '8053' , 'PISSIDE DIAM 14 C/COPERCHIO - 864' , '1' , '-1' , '1' , '95.00' , '77.868852459016' , '22' , '0' , '95.00' ) 15/05/2023 11:39: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 ( '84334' , '16966' , 'PINZE SPEGNI CANDELA - RCPIN' , '1' , '-1' , '1' , '2.6' , '2.1311475409836' , '22' , '0' , '2.60' ) 15/05/2023 11:39: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 ( '84334' , '17988' , 'BACILE PALLADIO CM 24 - 688' , '1' , '-1' , '1' , '73.00' , '59.83606557377' , '22' , '0' , '73.00' ) 15/05/2023 11:39: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 ( '84334' , '1364' , 'BROCCA E PIATTINO - CM 23 PALLADIATI - 680' , '1' , '-1' , '1' , '190.00' , '155.73770491803' , '22' , '0' , '190.00' ) 15/05/2023 11:39: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 ( '84334' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '7' , '-7' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '24.50' ) 15/05/2023 11:39: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 ( '84334' , '16689' , 'OSTIA PAN DI CENA mm80' , '9' , '-9' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '18.00' ) 15/05/2023 11:39: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 ( '84334' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '3' , '-3' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '10.50' ) 15/05/2023 11:39: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 ( '84334' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '1.90' ) 15/05/2023 11:39: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 ( '84334' , '17329' , 'MESSALE ROMANO D\'ALTARE N.E' , '1' , '-1' , '4' , '110.00' , '110' , '0' , '5' , '104.50' ) 15/05/2023 11:39: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 ( '84334' , '9230' , 'SANTA RITA DA CASCIA - 10 ' , '2' , '-2' , '1' , '3.5' , '2.8688524590164' , '22' , '0' , '7.00' ) 15/05/2023 11:48:29 am >> SELECT document_num FROM ps_document WHERE document_num = '1663' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-15') 15/05/2023 11:48:29 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' , '1663' , '2023-05-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '34.85' , '34.67' , NOW() , NOW() ) 15/05/2023 11:48:29 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 = '84335' 15/05/2023 11:48:29 am >> DELETE FROM ps_document_detail WHERE id_document = '84335' 15/05/2023 11:48:29 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 ( '84335' , '17734' , 'VANGELO E ATTI BAMBINI' , '11' , '-11' , '4' , '3' , '3' , '0' , '5' , '31.35' ) 15/05/2023 11:48:29 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 ( '84335' , '12819' , 'REGISTRO DEL CATECHISTA ' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 15/05/2023 11:48:29 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 ( '84335' , '15762' , 'MIA PRIMA COMUNIONE' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '0' , '2.50' ) 15/05/2023 12:07:16 pm >> SELECT document_num FROM ps_document WHERE document_num = '1664' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-15') 15/05/2023 12:07: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' , '1664' , '2023-05-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '22.40' , '22.40' , NOW() , NOW() ) 15/05/2023 12:07: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 = '84336' 15/05/2023 12:07:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '84336' 15/05/2023 12:07: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 ( '84336' , '11858' , 'FOGLIETTI LA DOMENICA - LER' , '560' , '-560' , '4' , '0.04' , '0.04' , '0' , '0' , '22.40' ) 15/05/2023 12:28:03 pm >> SELECT document_num FROM ps_document WHERE document_num = '1665' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-15') 15/05/2023 12:28:03 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' , '1665' , '2023-05-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.50' , '8.50' , NOW() , NOW() ) 15/05/2023 12:28:03 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 = '84337' 15/05/2023 12:28:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '84337' 15/05/2023 12:28:03 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 ( '84337' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '8.5' , '8.5' , '0' , '0' , '8.50' ) 15/05/2023 12:36:42 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002144' AND id_product != '13562' AND ean13 != '' 15/05/2023 12:36:42 pm >> UPDATE ps_product SET id_supplier = '28', reference = '', ean13 = '002144', date_upd = NOW() WHERE id_product = '13562' 15/05/2023 12:36:42 pm >> UPDATE ps_product_lang SET name = 'CORONCINA IN STOFFA CON ROSE E FOGLIOLINE - 3311', description = '' WHERE id_product = '13562' 15/05/2023 12:36:42 pm >> UPDATE ps_product SET wholesale_price = '1.50', on_sale = '0', price = '4.9200' WHERE id_product = '13562' 15/05/2023 12:36:42 pm >> UPDATE ps_product_shop SET wholesale_price = '1.50', price = '4.9200', id_tax_rules_group = '1', id_category_default = '95', 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 = '13562' 15/05/2023 12:36:42 pm >> DELETE FROM ps_specific_price WHERE id_product = '13562' 15/05/2023 12:39:31 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 15/05/2023 12:39:31 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21095' , '1' , '' , 'nuovo-prodotto' ) 15/05/2023 12:39:31 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '21095' , '1' , '1' , '2' , NOW() , NOW() ) 15/05/2023 12:39:31 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '21095' , '0' , '1' , '0' , '0' ) 15/05/2023 12:41:36 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400181579' AND id_product != '21095' AND ean13 != '' 15/05/2023 12:41:36 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8058400181579', date_upd = NOW() WHERE id_product = '21095' 15/05/2023 12:41:36 pm >> UPDATE ps_product_lang SET name = 'QUADRETTO DA POGGIO EFFETTO PIETRA - 2950', description = '' WHERE id_product = '21095' 15/05/2023 12:41:36 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '5.737704918032787' WHERE id_product = '21095' 15/05/2023 12:41:36 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '5.737704918032787', id_tax_rules_group = '1', id_category_default = '95', 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 = '21095' 15/05/2023 12:41:36 pm >> DELETE FROM ps_specific_price WHERE id_product = '21095' 15/05/2023 12:41:37 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 = '21095' 15/05/2023 12:41:37 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21096' , '1' , '' , 'nuovo-prodotto' ) 15/05/2023 12:41:37 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 '21096' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21095' 15/05/2023 12:41:37 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21096' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21095' 15/05/2023 12:48:05 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002145' AND id_product != '21096' AND ean13 != '' 15/05/2023 12:48:05 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002145', date_upd = NOW() WHERE id_product = '21096' 15/05/2023 12:48:05 pm >> UPDATE ps_product_lang SET name = 'CROCE REMOVIBILE EFFETTO PIETRA - 3873', description = '' WHERE id_product = '21096' 15/05/2023 12:48:05 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '9.836065573770492' WHERE id_product = '21096' 15/05/2023 12:48:05 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '9.836065573770492', id_tax_rules_group = '1', id_category_default = '95', 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 = '21096' 15/05/2023 12:48:05 pm >> DELETE FROM ps_specific_price WHERE id_product = '21096' 15/05/2023 12:48:06 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 = '21096' 15/05/2023 12:48:06 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21097' , '1' , '' , 'nuovo-prodotto' ) 15/05/2023 12:48:06 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 '21097' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21096' 15/05/2023 12:48:06 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21097' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21096' 15/05/2023 12:48: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 ( '31' , 'A1904' , '2023-05-11' , '' , '0' , '28' , '2623' , 'VIA DEI MILLE 59 80121 NAPOLI' , '' , '' , '12' , '1' , '0' , '0' , '0' , '' , '3' , '0' , '270.33' , '221.58' , NOW() , NOW() ) 15/05/2023 12:48: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 = '84338' 15/05/2023 12:48:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '84338' 15/05/2023 12:48: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 ( '84338' , '13562' , 'CORONCINA IN STOFFA CON ROSE E FOGLIOLINE - 3311' , '10' , '10' , '1' , '2.1' , '1.7213114754098' , '22' , '0' , '25.6200' ) 15/05/2023 12:49:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13562' AND id_supplier = '28' 15/05/2023 12:49:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13562' , '28' , '1' ) 15/05/2023 12:49: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 ( '84338' , '21095' , 'QUADRETTO DA POGGIO EFFETTO PIETRA - 2950' , '15' , '15' , '1' , '2.62' , '2.1475409836066' , '22' , '0' , '47.9460' ) 15/05/2023 12:49:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21095' AND id_supplier = '28' 15/05/2023 12:49:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21095' , '28' , '1' ) 15/05/2023 12:49: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 ( '84338' , '15403' , 'CROCE IN RESINA CM 9 - 3806/G052' , '48' , '48' , '1' , '1.4' , '1.1475409836066' , '22' , '0' , '81.9840' ) 15/05/2023 12:49:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15403' AND id_supplier = '28' 15/05/2023 12:49:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15403' , '28' , '1' ) 15/05/2023 12:49: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 ( '84338' , '12040' , 'MEDAGLIA MIRACOLOSA GRANDE IN ARGENTO - M058' , '5' , '5' , '1' , '4.98' , '4.0819672131148' , '22' , '0' , '30.3780' ) 15/05/2023 12:49:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12040' AND id_supplier = '28' 15/05/2023 12:49:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12040' , '28' , '1' ) 15/05/2023 12:49: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 ( '84338' , '17277' , 'BRACCIALE PIETRE DURE - 4633' , '12' , '12' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '36.6000' ) 15/05/2023 12:49:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17277' AND id_supplier = '28' 15/05/2023 12:49:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17277' , '28' , '1' ) 15/05/2023 12:49: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 ( '84338' , '21096' , 'CROCE REMOVIBILE EFFETTO PIETRA - 3873' , '6' , '6' , '1' , '4.53' , '3.7131147540984' , '22' , '0' , '33.1596' ) 15/05/2023 12:49:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21096' AND id_supplier = '28' 15/05/2023 12:49:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21096' , '28' , '1' ) 15/05/2023 03:22:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '1666' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-15') 15/05/2023 03:22:26 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' , '1666' , '2023-05-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '160.00' , '133.35' , NOW() , NOW() ) 15/05/2023 03:22:26 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 = '84339' 15/05/2023 03:22:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '84339' 15/05/2023 03:22:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84339' , '19396' , 'CLERGY MISTO COTONE MM - C01' , '2' , '-2' , '1' , '36.5' , '29.918032786885' , '22' , '0' , '73.00' ) 15/05/2023 03:22:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84339' , '7311' , 'OSTIA SOTTILE 74MM' , '5' , '-5' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '9.50' ) 15/05/2023 03:22:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84339' , '20795' , 'SULLA TUA PAROLA MAG/GIU 2023 - 516' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 15/05/2023 03:22:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84339' , '2424' , 'COLLETTO DOPPIO - CM 3,5 ' , '1' , '-1' , '1' , '7.00' , '5.7377049180328' , '22' , '0' , '7.00' ) 15/05/2023 03:22:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84339' , '20117' , 'FATIMA CM 55 - 1036' , '1' , '-1' , '1' , '65.75' , '53.893442622951' , '22' , '0' , '65.75' ) 15/05/2023 03:54:28 pm >> SELECT document_num FROM ps_document WHERE document_num = '1667' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-15') 15/05/2023 03:54:28 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' , '1667' , '2023-05-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '76.00' , '64.28' , NOW() , NOW() ) 15/05/2023 03:54:28 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 = '84340' 15/05/2023 03:54:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '84340' 15/05/2023 03:54:28 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 ( '84340' , '17160' , 'CARBONCINI ROSSI - CARRO' , '2' , '-2' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '20.00' ) 15/05/2023 03:54:28 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 ( '84340' , '17617' , 'IMMAGINI ISONZO X 100' , '12' , '-12' , '1' , '3.5' , '2.8688524590164' , '22' , '0' , '42.00' ) 15/05/2023 03:54:28 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 ( '84340' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.00' , '3.8461538461538' , '4' , '0' , '4.00' ) 15/05/2023 03:54:28 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 ( '84340' , '20429' , 'OSTIA SENZA TOSTATURA MORREALE - OS25' , '5' , '-5' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '10.00' ) 15/05/2023 04:25:17 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '5902689317088' AND id_product != '21097' AND ean13 != '' 15/05/2023 04:25:18 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '5902689317088', date_upd = NOW() WHERE id_product = '21097' 15/05/2023 04:25:18 pm >> UPDATE ps_product_lang SET name = 'BRACCIALE DECINA - BC1768N', description = '' WHERE id_product = '21097' 15/05/2023 04:25:18 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '1.639344262295082' WHERE id_product = '21097' 15/05/2023 04:25:18 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '1.639344262295082', id_tax_rules_group = '1', id_category_default = '443', 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 = '21097' 15/05/2023 04:25:18 pm >> DELETE FROM ps_specific_price WHERE id_product = '21097' 15/05/2023 04:26:04 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 15/05/2023 04:26:04 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21098' , '1' , '' , 'nuovo-prodotto' ) 15/05/2023 04:26:04 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '21098' , '1' , '1' , '2' , NOW() , NOW() ) 15/05/2023 04:26:04 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '21098' , '0' , '1' , '0' , '0' ) 15/05/2023 04:27:17 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '5902689318863' AND id_product != '21098' AND ean13 != '' 15/05/2023 04:27:17 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '5902689318863', date_upd = NOW() WHERE id_product = '21098' 15/05/2023 04:27:17 pm >> UPDATE ps_product_lang SET name = 'BRACCIALE DECINA PIETRA - BC1885', description = '' WHERE id_product = '21098' 15/05/2023 04:27:17 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '2.0491803278688523' WHERE id_product = '21098' 15/05/2023 04:27:18 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '2.0491803278688523', id_tax_rules_group = '1', id_category_default = '443', 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 = '21098' 15/05/2023 04:27:18 pm >> DELETE FROM ps_specific_price WHERE id_product = '21098' 15/05/2023 04:27:19 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 = '21098' 15/05/2023 04:27:19 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21099' , '1' , '' , 'nuovo-prodotto' ) 15/05/2023 04:27:19 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 '21099' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21098' 15/05/2023 04:27:19 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21099' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21098' 15/05/2023 04:30:15 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '5902689313592' AND id_product != '21099' AND ean13 != '' 15/05/2023 04:30:15 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '5902689313592', date_upd = NOW() WHERE id_product = '21099' 15/05/2023 04:30:15 pm >> UPDATE ps_product_lang SET name = 'BRACCIALE DECINA - BD008', description = '' WHERE id_product = '21099' 15/05/2023 04:30:15 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '1.639344262295082' WHERE id_product = '21099' 15/05/2023 04:30:15 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '1.639344262295082', id_tax_rules_group = '1', id_category_default = '443', 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 = '21099' 15/05/2023 04:30:15 pm >> DELETE FROM ps_specific_price WHERE id_product = '21099' 15/05/2023 04:35:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '1668' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-15') 15/05/2023 04:35: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' , '1668' , '2023-05-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '24.40' , '20.00' , NOW() , NOW() ) 15/05/2023 04:35: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 = '84341' 15/05/2023 04:35:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '84341' 15/05/2023 04:35: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 ( '84341' , '16252' , 'CUORE PENDENTE' , '2' , '-2' , '1' , '12.20' , '10' , '22' , '0' , '24.40' ) 15/05/2023 04:43:42 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001302' AND id_product != '16311' AND ean13 != '' 15/05/2023 04:43:42 pm >> UPDATE ps_product SET id_supplier = '123', reference = '', ean13 = '001302', date_upd = NOW() WHERE id_product = '16311' 15/05/2023 04:43:42 pm >> UPDATE ps_product_lang SET name = 'DECINA MISSIONARIA - FR17-2', description = '' WHERE id_product = '16311' 15/05/2023 04:43:42 pm >> UPDATE ps_product SET wholesale_price = '0.08', on_sale = '0', price = '0.4098' WHERE id_product = '16311' 15/05/2023 04:43:42 pm >> UPDATE ps_product_shop SET wholesale_price = '0.08', price = '0.4098', id_tax_rules_group = '1', id_category_default = '443', 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 = '16311' 15/05/2023 04:43:42 pm >> DELETE FROM ps_specific_price WHERE id_product = '16311' 15/05/2023 04:49:17 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 15/05/2023 04:49:17 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21100' , '1' , '' , 'nuovo-prodotto' ) 15/05/2023 04:49:17 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '21100' , '1' , '1' , '2' , NOW() , NOW() ) 15/05/2023 04:49:17 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '21100' , '0' , '1' , '0' , '0' ) 15/05/2023 04:50:09 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002146' AND id_product != '16308' AND ean13 != '' 15/05/2023 04:50:09 pm >> UPDATE ps_product SET id_supplier = '123', reference = '', ean13 = '002146', date_upd = NOW() WHERE id_product = '16308' 15/05/2023 04:50:09 pm >> UPDATE ps_product_lang SET name = 'PORTACHIAVI SAN BENEDETTO', description = '' WHERE id_product = '16308' 15/05/2023 04:50:09 pm >> UPDATE ps_product SET wholesale_price = '0.31', on_sale = '0', price = '0.8197' WHERE id_product = '16308' 15/05/2023 04:50:09 pm >> UPDATE ps_product_shop SET wholesale_price = '0.31', price = '0.8197', id_tax_rules_group = '1', id_category_default = '443', 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 = '16308' 15/05/2023 04:50:09 pm >> DELETE FROM ps_specific_price WHERE id_product = '16308' 15/05/2023 04:51:32 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '5902689307553' AND id_product != '16310' AND ean13 != '' 15/05/2023 04:51:32 pm >> UPDATE ps_product SET id_supplier = '123', reference = '', ean13 = '5902689307553', date_upd = NOW() WHERE id_product = '16310' 15/05/2023 04:51:32 pm >> UPDATE ps_product_lang SET name = 'PORTACHIAVI COLOMBA - KP027', description = '' WHERE id_product = '16310' 15/05/2023 04:51:32 pm >> UPDATE ps_product SET wholesale_price = '0.29', on_sale = '0', price = '0.8197' WHERE id_product = '16310' 15/05/2023 04:51:32 pm >> UPDATE ps_product_shop SET wholesale_price = '0.29', price = '0.8197', id_tax_rules_group = '1', id_category_default = '443', 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 = '16310' 15/05/2023 04:51:32 pm >> DELETE FROM ps_specific_price WHERE id_product = '16310' 15/05/2023 04:56:46 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '5902689307553' AND id_product != '16310' AND ean13 != '' 15/05/2023 04:56:46 pm >> UPDATE ps_product SET id_supplier = '123', reference = '', ean13 = '5902689307553', date_upd = NOW() WHERE id_product = '16310' 15/05/2023 04:56:46 pm >> UPDATE ps_product_lang SET name = 'PORTACHIAVI COLOMBA - KP027', description = '' WHERE id_product = '16310' 15/05/2023 04:56:46 pm >> UPDATE ps_product SET wholesale_price = '0.29', on_sale = '0', price = '0.9836065573770492' WHERE id_product = '16310' 15/05/2023 04:56:46 pm >> UPDATE ps_product_shop SET wholesale_price = '0.29', price = '0.9836065573770492', id_tax_rules_group = '1', id_category_default = '443', 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 = '16310' 15/05/2023 04:56:46 pm >> DELETE FROM ps_specific_price WHERE id_product = '16310' 15/05/2023 04:58:04 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '5902689379987' AND id_product != '16308' AND ean13 != '' 15/05/2023 04:58:05 pm >> UPDATE ps_product SET id_supplier = '123', reference = '', ean13 = '5902689379987', date_upd = NOW() WHERE id_product = '16308' 15/05/2023 04:58:05 pm >> UPDATE ps_product_lang SET name = 'PORTACHIAVI COLOMBA - KP039', description = '' WHERE id_product = '16308' 15/05/2023 04:58:05 pm >> UPDATE ps_product SET wholesale_price = '0.31', on_sale = '0', price = '0.8197' WHERE id_product = '16308' 15/05/2023 04:58:05 pm >> UPDATE ps_product_shop SET wholesale_price = '0.31', price = '0.8197', id_tax_rules_group = '1', id_category_default = '443', 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 = '16308' 15/05/2023 04:58:05 pm >> DELETE FROM ps_specific_price WHERE id_product = '16308' 15/05/2023 05:01:14 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '5902689379987' AND id_product != '16308' AND ean13 != '' 15/05/2023 05:01:14 pm >> UPDATE ps_product SET id_supplier = '123', reference = '', ean13 = '5902689379987', date_upd = NOW() WHERE id_product = '16308' 15/05/2023 05:01:14 pm >> UPDATE ps_product_lang SET name = 'PORTACHIAVI COLOMBA - KP039', description = '' WHERE id_product = '16308' 15/05/2023 05:01:14 pm >> UPDATE ps_product SET wholesale_price = '0.31', on_sale = '0', price = '0.9836065573770492' WHERE id_product = '16308' 15/05/2023 05:01:14 pm >> UPDATE ps_product_shop SET wholesale_price = '0.31', price = '0.9836065573770492', id_tax_rules_group = '1', id_category_default = '443', 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 = '16308' 15/05/2023 05:01:14 pm >> DELETE FROM ps_specific_price WHERE id_product = '16308' 15/05/2023 05:03:30 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '5902689319426' AND id_product != '21100' AND ean13 != '' 15/05/2023 05:03:30 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '5902689319426', date_upd = NOW() WHERE id_product = '21100' 15/05/2023 05:03:30 pm >> UPDATE ps_product_lang SET name = 'COLLANA CON CROCE ACCIAIO - NS014', description = '' WHERE id_product = '21100' 15/05/2023 05:03:30 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '2.0491803278688523' WHERE id_product = '21100' 15/05/2023 05:03:30 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '2.0491803278688523', id_tax_rules_group = '1', id_category_default = '443', 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 = '21100' 15/05/2023 05:03:30 pm >> DELETE FROM ps_specific_price WHERE id_product = '21100' 15/05/2023 05:03: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 = '21100' 15/05/2023 05:03:33 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21101' , '1' , '' , 'nuovo-prodotto' ) 15/05/2023 05:03: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 '21101' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21100' 15/05/2023 05:03:33 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21101' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21100' 15/05/2023 05:04:15 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '5902689319464' AND id_product != '21101' AND ean13 != '' 15/05/2023 05:04:15 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '5902689319464', date_upd = NOW() WHERE id_product = '21101' 15/05/2023 05:04:15 pm >> UPDATE ps_product_lang SET name = 'COLLANA CON ANGELO IN ACCIAIO - NS018', description = '' WHERE id_product = '21101' 15/05/2023 05:04:15 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '2.0491803278688523' WHERE id_product = '21101' 15/05/2023 05:04:15 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '2.0491803278688523', id_tax_rules_group = '1', id_category_default = '443', 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 = '21101' 15/05/2023 05:04:15 pm >> DELETE FROM ps_specific_price WHERE id_product = '21101' 15/05/2023 05:06:18 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 = '21101' 15/05/2023 05:06:18 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21102' , '1' , '' , 'nuovo-prodotto' ) 15/05/2023 05:06:18 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 '21102' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21101' 15/05/2023 05:06:18 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21102' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21101' 15/05/2023 05:06:55 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '5902689307850' AND id_product != '21102' AND ean13 != '' 15/05/2023 05:06:56 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '5902689307850', date_upd = NOW() WHERE id_product = '21102' 15/05/2023 05:06:56 pm >> UPDATE ps_product_lang SET name = 'BRACCIALE DECINA LEGNO CORDA - BC568', description = '' WHERE id_product = '21102' 15/05/2023 05:06:56 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '1.639344262295082' WHERE id_product = '21102' 15/05/2023 05:06:56 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '1.639344262295082', id_tax_rules_group = '1', id_category_default = '443', 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 = '21102' 15/05/2023 05:06:56 pm >> DELETE FROM ps_specific_price WHERE id_product = '21102' 15/05/2023 05:08:46 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 = '21102' 15/05/2023 05:08:46 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21103' , '1' , '' , 'nuovo-prodotto' ) 15/05/2023 05:08:46 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 '21103' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21102' 15/05/2023 05:08:46 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21103' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21102' 15/05/2023 05:10:00 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002146' AND id_product != '21103' AND ean13 != '' 15/05/2023 05:10:00 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002146', date_upd = NOW() WHERE id_product = '21103' 15/05/2023 05:10:00 pm >> UPDATE ps_product_lang SET name = 'ROSARIO DECINA GIALLO - R333-32', description = '' WHERE id_product = '21103' 15/05/2023 05:10:00 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0.5737704918032787' WHERE id_product = '21103' 15/05/2023 05:10:00 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0.5737704918032787', id_tax_rules_group = '1', id_category_default = '443', 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 = '21103' 15/05/2023 05:10:00 pm >> DELETE FROM ps_specific_price WHERE id_product = '21103' 15/05/2023 05:10:20 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002147' AND id_product != '21103' AND ean13 != '' 15/05/2023 05:10:21 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002147', date_upd = NOW() WHERE id_product = '21103' 15/05/2023 05:10:21 pm >> UPDATE ps_product_lang SET name = 'ROSARIO DECINA GIALLO - R333-32', description = '' WHERE id_product = '21103' 15/05/2023 05:10:21 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0.5738' WHERE id_product = '21103' 15/05/2023 05:10:21 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0.5738', id_tax_rules_group = '1', id_category_default = '443', 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 = '21103' 15/05/2023 05:10:21 pm >> DELETE FROM ps_specific_price WHERE id_product = '21103' 15/05/2023 05:13: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 ( '31' , '466/05/2023' , '2023-05-09' , '05' , '0' , '123' , '4669610' , 'RYNEK WIELUNSKI, 27 42202 CZESTOCHOWA' , '' , '' , '38.98' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '703.69' , '703.69' , NOW() , NOW() ) 15/05/2023 05:13: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 = '84342' 15/05/2023 05:13:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '84342' 15/05/2023 05:13: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 ( '84342' , '20062' , 'BRACCIALE DECINA - BD018' , '96' , '96' , '0' , '0.65' , '0.65' , '' , '0' , '62.4000' ) 15/05/2023 05:13:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20062' AND id_supplier = '123' 15/05/2023 05:13:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20062' , '123' , '1' ) 15/05/2023 05:13: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 ( '84342' , '21098' , 'BRACCIALE DECINA PIETRA - BC1885' , '24' , '24' , '0' , '0.98' , '0.98' , '' , '0' , '23.5200' ) 15/05/2023 05:13:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21098' AND id_supplier = '123' 15/05/2023 05:13:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21098' , '123' , '1' ) 15/05/2023 05:13: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 ( '84342' , '15085' , 'BRACCIALE DECINA COLORATA - BC506' , '35' , '35' , '0' , '0.57' , '0.57' , '' , '0' , '19.9500' ) 15/05/2023 05:13:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15085' AND id_supplier = '123' 15/05/2023 05:13:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15085' , '123' , '1' ) 15/05/2023 05:13: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 ( '84342' , '21099' , 'BRACCIALE DECINA - BD008' , '96' , '96' , '0' , '0.61' , '0.61' , '' , '0' , '58.5600' ) 15/05/2023 05:13:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21099' AND id_supplier = '123' 15/05/2023 05:13:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21099' , '123' , '1' ) 15/05/2023 05:13: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 ( '84342' , '18217' , 'BRACCIALE DECINA PIETRE - BD019' , '96' , '96' , '0' , '0.75' , '0.75' , '' , '0' , '72.0000' ) 15/05/2023 05:13:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18217' AND id_supplier = '123' 15/05/2023 05:13:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18217' , '123' , '1' ) 15/05/2023 05:13: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 ( '84342' , '20062' , 'BRACCIALE DECINA - BD018' , '72' , '72' , '0' , '0.61' , '0.61' , '' , '0' , '43.9200' ) 15/05/2023 05:13:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20062' AND id_supplier = '123' 15/05/2023 05:13:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20062' , '123' , '1' ) 15/05/2023 05:13: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 ( '84342' , '16311' , 'DECINA MISSIONARIA - FR17-2' , '1000' , '1000' , '0' , '0.12' , '0.12' , '' , '0' , '120.0000' ) 15/05/2023 05:13:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16311' AND id_supplier = '123' 15/05/2023 05:13:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16311' , '123' , '1' ) 15/05/2023 05:13: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 ( '84342' , '16308' , 'PORTACHIAVI SAN BENEDETTO' , '120' , '120' , '0' , '0.39' , '0.39' , '' , '0' , '46.8000' ) 15/05/2023 05:13:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16308' AND id_supplier = '123' 15/05/2023 05:13:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16308' , '123' , '1' ) 15/05/2023 05:13: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 ( '84342' , '16310' , 'PORTACHIAVI COLOMBA - KP027' , '156' , '156' , '0' , '0.46' , '0.46' , '' , '0' , '71.7600' ) 15/05/2023 05:13:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16310' AND id_supplier = '123' 15/05/2023 05:13:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16310' , '123' , '1' ) 15/05/2023 05:13:38 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 ( '84342' , '16308' , 'PORTACHIAVI COLOMBA - KP039' , '120' , '120' , '0' , '0.39' , '0.39' , '' , '0' , '46.8000' ) 15/05/2023 05:13:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16308' AND id_supplier = '123' 15/05/2023 05:13:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16308' , '123' , '1' ) 15/05/2023 05:13:38 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 ( '84342' , '21100' , 'COLLANA CON CROCE ACCIAIO - NS014' , '12' , '12' , '0' , '0.85' , '0.85' , '' , '0' , '10.2000' ) 15/05/2023 05:13:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21100' AND id_supplier = '123' 15/05/2023 05:13:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21100' , '123' , '1' ) 15/05/2023 05:13:38 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 ( '84342' , '21101' , 'COLLANA CON ANGELO IN ACCIAIO - NS018' , '24' , '24' , '0' , '0.85' , '0.85' , '' , '0' , '20.4000' ) 15/05/2023 05:13:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21101' AND id_supplier = '123' 15/05/2023 05:13:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21101' , '123' , '1' ) 15/05/2023 05:13:38 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 ( '84342' , '21102' , 'BRACCIALE DECINA LEGNO CORDA - BC568' , '36' , '36' , '0' , '0.7' , '0.7' , '' , '0' , '25.2000' ) 15/05/2023 05:13:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21102' AND id_supplier = '123' 15/05/2023 05:13:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21102' , '123' , '1' ) 15/05/2023 05:13:38 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 ( '84342' , '21103' , 'ROSARIO DECINA GIALLO - R333-32' , '216' , '216' , '0' , '0.2' , '0.2' , '' , '0' , '43.2000' ) 15/05/2023 05:13:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21103' AND id_supplier = '123' 15/05/2023 05:13:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21103' , '123' , '1' ) 15/05/2023 06:05:44 pm >> SELECT document_num FROM ps_document WHERE document_num = '1669' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-15') 15/05/2023 06:05:44 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' , '1669' , '2023-05-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '34.00' , '33.68' , NOW() , NOW() ) 15/05/2023 06:05:44 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 = '84343' 15/05/2023 06:05:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '84343' 15/05/2023 06:05:44 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 ( '84343' , '11858' , 'FOGLIETTI LA DOMENICA - LER' , '640' , '-640' , '4' , '0.04' , '0.04' , '0' , '0' , '25.60' ) 15/05/2023 06:05:44 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 ( '84343' , '17711' , 'OSTIA MAGNA CM 18 - OM 180' , '1' , '-1' , '3' , '8.4' , '8.0769230769231' , '4' , '0' , '8.40' ) 15/05/2023 07:49:58 pm >> SELECT document_num FROM ps_document WHERE document_num = '1670' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-15') 15/05/2023 07:49: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' , '1670' , '2023-05-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '47.30' , '39.13' , NOW() , NOW() ) 15/05/2023 07:49: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 = '84344' 15/05/2023 07:49:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '84344' 15/05/2023 07:49: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 ( '84344' , '18276' , 'CINGOLO CON NODI - 3280' , '3' , '-3' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '7.50' ) 15/05/2023 07:49: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 ( '84344' , '20516' , 'CROCE COMUNIONE - 42/08' , '6' , '-6' , '1' , '1.3' , '1.0655737704918' , '22' , '0' , '7.80' ) 15/05/2023 07:49: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 ( '84344' , '13562' , 'CORONCINA IN STOFFA CON ROSE E FOGLIOLINE - 3311' , '5' , '-5' , '1' , '6.00' , '4.9180327868852' , '22' , '0' , '30.00' ) 15/05/2023 07:49: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 ( '84344' , '8762' , 'QUINDICI GIOVEDÌ DI SANTA RITA - 8405' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' )