30/05/2022 08:42:36 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400012729' AND id_product != '3074' AND ean13 != '' 30/05/2022 08:42:36 am >> UPDATE ps_product SET id_supplier = '28', reference = '2014', ean13 = '8058400012729', date_upd = NOW() WHERE id_product = '3074' 30/05/2022 08:42:36 am >> UPDATE ps_product_lang SET name = 'CROCE PRIMA COMUNIONE LEGNO CHIARO - 713/11', description = '' WHERE id_product = '3074' 30/05/2022 08:42:36 am >> UPDATE ps_product SET wholesale_price = '0.40', on_sale = '0', price = '0.9836065573770492' WHERE id_product = '3074' 30/05/2022 08:42:36 am >> UPDATE ps_product_shop SET wholesale_price = '0.40', price = '0.9836065573770492', 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 = '3074' 30/05/2022 08:42:36 am >> DELETE FROM ps_specific_price WHERE id_product = '3074' 30/05/2022 08:43:38 am >> SELECT document_num FROM ps_document WHERE document_num = '1528' AND id_document != '57268' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-14') 30/05/2022 08:43:38 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1528', document_date = '2022-05-14', 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 = '13.76', price_tax_excluded = '13.49', date_upd = NOW() WHERE id_document = '57268' 30/05/2022 08:43:38 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 = '57268' 30/05/2022 08:43:38 am >> DELETE FROM ps_document_detail WHERE id_document = '57268' 30/05/2022 08:43:38 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 ( '57268' , '1116' , 'BIBBIA DEI BAMBINI' , '1' , '-1' , '4' , '12.9000' , '12.9' , '0' , '5' , '12.26' ) 30/05/2022 08:43:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '1116' AND id_supplier = '' 30/05/2022 08:43:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1116' , '' , '1' ) 30/05/2022 08:43:38 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 ( '57268' , '5473' , 'IOHANNES 25G - ROSA - EVE ' , '1' , '-1' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '1.50' ) 30/05/2022 08:43:39 am >> DELETE FROM ps_product_supplier WHERE id_product = '5473' AND id_supplier = '' 30/05/2022 08:43:39 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5473' , '' , '1' ) 30/05/2022 08:44:23 am >> SELECT document_num FROM ps_document WHERE document_num = '2008' AND id_document != '29288' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2021-06-17') 30/05/2022 08:44:23 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2008', document_date = '2021-06-17', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '1.00', price_tax_excluded = '0.82', date_upd = NOW() WHERE id_document = '29288' 30/05/2022 08:44: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 = '29288' 30/05/2022 08:44:24 am >> DELETE FROM ps_document_detail WHERE id_document = '29288' 30/05/2022 08:44:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '29288' , '3073' , 'CROCE PRIMA COMUNIONE - LEGNO SCURO - 713/15' , '1' , '-1' , '1' , '1' , '0.81967213114754' , '22' , '0' , '1.00' ) 30/05/2022 08:44:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '3073' AND id_supplier = '' 30/05/2022 08:44:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3073' , '' , '1' ) 30/05/2022 08:44:48 am >> SELECT document_num FROM ps_document WHERE document_num = '2002' AND id_document != '29279' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2021-06-17') 30/05/2022 08:44:48 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2002', document_date = '2021-06-17', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '1.00', price_tax_excluded = '0.82', date_upd = NOW() WHERE id_document = '29279' 30/05/2022 08:44:48 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 = '29279' 30/05/2022 08:44:48 am >> DELETE FROM ps_document_detail WHERE id_document = '29279' 30/05/2022 08:44:48 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 ( '29279' , '3073' , 'CROCE PRIMA COMUNIONE - LEGNO SCURO - 713/15' , '1' , '-1' , '1' , '1' , '0.81967213114754' , '22' , '0' , '1.00' ) 30/05/2022 08:44:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '3073' AND id_supplier = '' 30/05/2022 08:44:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3073' , '' , '1' ) 30/05/2022 09:02:19 am >> SELECT document_num FROM ps_document WHERE document_num = '1621' AND id_document != '57886' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-21') 30/05/2022 09:02:19 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1621', document_date = '2022-05-21', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '21.30', price_tax_excluded = '18.99', date_upd = NOW() WHERE id_document = '57886' 30/05/2022 09:02:19 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 = '57886' 30/05/2022 09:02:19 am >> DELETE FROM ps_document_detail WHERE id_document = '57886' 30/05/2022 09:02:19 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 ( '57886' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '2' , '-2' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '7.00' ) 30/05/2022 09:02:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 30/05/2022 09:02:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 30/05/2022 09:02:19 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 ( '57886' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '1.9000' , '1.8269230769231' , '4' , '0' , '3.80' ) 30/05/2022 09:02:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 30/05/2022 09:02:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 30/05/2022 09:02:19 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 ( '57886' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '7.50' ) 30/05/2022 09:02:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '11384' AND id_supplier = '' 30/05/2022 09:02:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11384' , '' , '1' ) 30/05/2022 09:02:19 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 ( '57886' , '7924' , 'PERGAMENE - BATTESIMO MOD. A' , '10' , '-10' , '1' , '0.3' , '0.24590163934426' , '22' , '0' , '3.00' ) 30/05/2022 09:02:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '7924' AND id_supplier = '' 30/05/2022 09:02:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7924' , '' , '1' ) 30/05/2022 09:02:45 am >> SELECT document_num FROM ps_document WHERE document_num = '1441' AND id_document != '56650' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-07') 30/05/2022 09:02:45 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1441', document_date = '2022-05-07', 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 = '120.01', price_tax_excluded = '102.29', date_upd = NOW() WHERE id_document = '56650' 30/05/2022 09:02:45 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 = '56650' 30/05/2022 09:02:45 am >> DELETE FROM ps_document_detail WHERE id_document = '56650' 30/05/2022 09:02:45 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 ( '56650' , '11693' , 'BRACCIALE DECINA CAUCCIU PIETRA - 805/23' , '6' , '-6' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '9.00' ) 30/05/2022 09:02:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '11693' AND id_supplier = '' 30/05/2022 09:02:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11693' , '' , '1' ) 30/05/2022 09:02:45 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 ( '56650' , '19530' , 'PERGAMENA COMUNIONE 18X24' , '6' , '-6' , '1' , '0.7000' , '0.57377049180328' , '22' , '0' , '4.20' ) 30/05/2022 09:02:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '19530' AND id_supplier = '' 30/05/2022 09:02:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19530' , '' , '1' ) 30/05/2022 09:02:45 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 ( '56650' , '19486' , 'ROSARIO PER LA PACE - N. SANTILLI' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '5' , '2.38' ) 30/05/2022 09:02:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '19486' AND id_supplier = '' 30/05/2022 09:02:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19486' , '' , '1' ) 30/05/2022 09:02:45 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 ( '56650' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 30/05/2022 09:02:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 30/05/2022 09:02:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 30/05/2022 09:02:45 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 ( '56650' , '15085' , 'BRACCIALE DECINA COLORATA - BC506' , '17' , '-17' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '20.40' ) 30/05/2022 09:02:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '15085' AND id_supplier = '' 30/05/2022 09:02:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15085' , '' , '1' ) 30/05/2022 09:02:45 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 ( '56650' , '18217' , 'BRACCIALE DECINA PIETRE - BD019' , '9' , '-9' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '18.00' ) 30/05/2022 09:02:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '18217' AND id_supplier = '' 30/05/2022 09:02:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18217' , '' , '1' ) 30/05/2022 09:02:45 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 ( '56650' , '1319' , 'BRACCIALE DECINA TAU' , '24' , '-24' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '28.80' ) 30/05/2022 09:02:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '1319' AND id_supplier = '' 30/05/2022 09:02:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1319' , '' , '1' ) 30/05/2022 09:02:46 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 ( '56650' , '7098' , 'NOVENA A MARIA CHE SCIOGLIE I NODI - 8558' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '5' , '2.38' ) 30/05/2022 09:02:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '7098' AND id_supplier = '' 30/05/2022 09:02:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7098' , '' , '1' ) 30/05/2022 09:02:46 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 ( '56650' , '15335' , 'CANDELA VOTIVA 20X40 DECORATA' , '5' , '-5' , '1' , '2.5000' , '2.0491803278689' , '22' , '0' , '12.50' ) 30/05/2022 09:02:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '15335' AND id_supplier = '' 30/05/2022 09:02:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15335' , '' , '1' ) 30/05/2022 09:02:46 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 ( '56650' , '1312' , 'BRACCIALE DECINA' , '3' , '-3' , '1' , '1.3000' , '1.0655737704918' , '22' , '0' , '3.90' ) 30/05/2022 09:02:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '1312' AND id_supplier = '' 30/05/2022 09:02:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1312' , '' , '1' ) 30/05/2022 09:02:46 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 ( '56650' , '18737' , 'CORAGGIO DI ESSERE FELICI - PAPA FRANCESCO' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '5' , '14.25' ) 30/05/2022 09:02:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '18737' AND id_supplier = '' 30/05/2022 09:02:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18737' , '' , '1' ) 30/05/2022 09:02:46 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 ( '56650' , '3174' , 'CROCETTA METALLO + SMALTO CM 2 - G048/D' , '1' , '-1' , '1' , '0.7000' , '0.57377049180328' , '22' , '0' , '0.70' ) 30/05/2022 09:02:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '3174' AND id_supplier = '' 30/05/2022 09:02:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3174' , '' , '1' ) 30/05/2022 09:03:36 am >> SELECT document_num FROM ps_document WHERE document_num = '12/A' AND id_document != '51968' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-02-28') 30/05/2022 09:03:36 am >> UPDATE ps_document SET id_document_type = '24', document_num = '12/A', document_date = '2022-02-28', document_letter = 'A', id_customer = '204', id_supplier = '', id_address = '4671483', address1 = 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO', address2 = '', note = 'cappellania s. leonardo - ACCONTO € 50,00 02/05 + 100,00 + 180,00 11/05', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '158.20', price_tax_excluded = '133.64', date_upd = NOW() WHERE id_document = '51968' 30/05/2022 09:03:36 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 = '51968' 30/05/2022 09:03:36 am >> DELETE FROM ps_document_detail WHERE id_document = '51968' 30/05/2022 09:03:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '51968' , '17402' , 'BRACCIALE ELASTICO ' , '6' , '-6' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '12.00' ) 30/05/2022 09:03:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '17402' AND id_supplier = '' 30/05/2022 09:03:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17402' , '' , '1' ) 30/05/2022 09:03:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '51968' , '14247' , 'ROSARIO ULIVO OVALE CON SETA E CROCE SAN DAMIANO' , '36' , '-36' , '1' , '1.3000' , '1.0655737704918' , '22' , '0' , '46.80' ) 30/05/2022 09:03:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '14247' AND id_supplier = '' 30/05/2022 09:03:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14247' , '' , '1' ) 30/05/2022 09:03:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '51968' , '0' , 'sacro cuore' , '1' , '-1' , '1' , '39.0000' , '31.967213114754' , '22' , '0' , '39.00' ) 30/05/2022 09:03:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '' 30/05/2022 09:03:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' ) 30/05/2022 09:03:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '51968' , '0' , 'MIRACOLOSA' , '1' , '-1' , '0' , '12.0000' , '12' , '0' , '0' , '12.00' ) 30/05/2022 09:03:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '' 30/05/2022 09:03:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' ) 30/05/2022 09:03:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '51968' , '0' , 'SUPPLICA' , '1' , '-1' , '0' , '10.0000' , '10' , '0' , '0' , '10.00' ) 30/05/2022 09:03:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '' 30/05/2022 09:03:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' ) 30/05/2022 09:03:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '51968' , '9128' , 'ROSARIO LEGNO - RLE5896/5812***oggetti' , '12' , '-12' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '14.40' ) 30/05/2022 09:03:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '9128' AND id_supplier = '' 30/05/2022 09:03:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9128' , '' , '1' ) 30/05/2022 09:03:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '51968' , '6353' , 'MEDAGLIA S. BENEDETTO SMALTATA - M016' , '10' , '-10' , '1' , '1.1000' , '0.9016393442623' , '22' , '0' , '11.00' ) 30/05/2022 09:03:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '6353' AND id_supplier = '' 30/05/2022 09:03:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6353' , '' , '1' ) 30/05/2022 09:03:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '51968' , '1312' , 'BRACCIALE DECINA' , '10' , '-10' , '1' , '1.3000' , '1.0655737704918' , '22' , '0' , '13.00' ) 30/05/2022 09:03:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '1312' AND id_supplier = '' 30/05/2022 09:03:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1312' , '' , '1' ) 30/05/2022 10:15:13 am >> SELECT document_num FROM ps_document WHERE document_num = '1694' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-30') 30/05/2022 10:15:13 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1694' , '2022-05-30' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '86.00' , '70.49' , NOW() , NOW() ) 30/05/2022 10:15:13 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58492' 30/05/2022 10:15:13 am >> DELETE FROM ps_document_detail WHERE id_document = '58492' 30/05/2022 10:15:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58492' , '15387' , 'VESTINA BATTESIMALE ' , '20' , '-20' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '50.00' ) 30/05/2022 10:15:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '15387' AND id_supplier = '' 30/05/2022 10:15:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15387' , '' , '1' ) 30/05/2022 10:15:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58492' , '12817' , 'LIBRO DEI MATRIMONI' , '1' , '-1' , '1' , '36' , '29.508196721311' , '22' , '0' , '36.00' ) 30/05/2022 10:15:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '12817' AND id_supplier = '' 30/05/2022 10:15:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12817' , '' , '1' ) 30/05/2022 10:42:03 am >> SELECT document_num FROM ps_document WHERE document_num = '12/A' AND id_document != '51968' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-02-28') 30/05/2022 10:42:03 am >> UPDATE ps_document SET id_document_type = '24', document_num = '12/A', document_date = '2022-02-28', document_letter = 'A', id_customer = '204', id_supplier = '', id_address = '4671483', address1 = 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO', address2 = '', note = 'cappellania s. leonardo ', 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 = '302.24', price_tax_excluded = '261.36', date_upd = NOW() WHERE id_document = '51968' 30/05/2022 10:42:03 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '51968' 30/05/2022 10:42:03 am >> DELETE FROM ps_document_detail WHERE id_document = '51968' 30/05/2022 10:42:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '51968' , '17402' , 'BRACCIALE ELASTICO ' , '6' , '-6' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '12.00' ) 30/05/2022 10:42:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '17402' AND id_supplier = '' 30/05/2022 10:42:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17402' , '' , '1' ) 30/05/2022 10:42:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '51968' , '14247' , 'ROSARIO ULIVO OVALE CON SETA E CROCE SAN DAMIANO' , '36' , '-36' , '1' , '1.3000' , '1.0655737704918' , '22' , '0' , '46.80' ) 30/05/2022 10:42:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '14247' AND id_supplier = '' 30/05/2022 10:42:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14247' , '' , '1' ) 30/05/2022 10:42:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '51968' , '0' , 'sacro cuore' , '1' , '-1' , '1' , '39.0000' , '31.967213114754' , '22' , '0' , '39.00' ) 30/05/2022 10:42:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '' 30/05/2022 10:42:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' ) 30/05/2022 10:42:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '51968' , '0' , 'MIRACOLOSA' , '1' , '-1' , '0' , '12.0000' , '12' , '0' , '0' , '12.00' ) 30/05/2022 10:42:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '' 30/05/2022 10:42:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' ) 30/05/2022 10:42:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '51968' , '0' , 'SUPPLICA' , '1' , '-1' , '0' , '10.0000' , '10' , '0' , '0' , '10.00' ) 30/05/2022 10:42:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '' 30/05/2022 10:42:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' ) 30/05/2022 10:42:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '51968' , '9128' , 'ROSARIO LEGNO - RLE5896/5812***oggetti' , '12' , '-12' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '14.40' ) 30/05/2022 10:42:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '9128' AND id_supplier = '' 30/05/2022 10:42:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9128' , '' , '1' ) 30/05/2022 10:42:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '51968' , '6353' , 'MEDAGLIA S. BENEDETTO SMALTATA - M016' , '10' , '-10' , '1' , '1.1000' , '0.9016393442623' , '22' , '0' , '11.00' ) 30/05/2022 10:42:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '6353' AND id_supplier = '' 30/05/2022 10:42:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6353' , '' , '1' ) 30/05/2022 10:42:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '51968' , '1312' , 'BRACCIALE DECINA' , '10' , '-10' , '1' , '1.3000' , '1.0655737704918' , '22' , '0' , '13.00' ) 30/05/2022 10:42:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '1312' AND id_supplier = '' 30/05/2022 10:42:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1312' , '' , '1' ) 30/05/2022 10:42:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '51968' , '11678' , '30/05/2022' , '' , '0' , '1' , '0' , '0' , '22' , '0' , '0.00' ) 30/05/2022 10:42:04 am >> DELETE FROM ps_product_supplier WHERE id_product = '11678' AND id_supplier = '' 30/05/2022 10:42:04 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11678' , '' , '1' ) 30/05/2022 10:42:04 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 ( '51968' , '1319' , 'BRACCIALE DECINA TAU' , '10' , '-10' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '12.00' ) 30/05/2022 10:42:04 am >> DELETE FROM ps_product_supplier WHERE id_product = '1319' AND id_supplier = '' 30/05/2022 10:42:04 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1319' , '' , '1' ) 30/05/2022 10:42:04 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 ( '51968' , '18837' , 'CAPOCULLA PICCOLO MATERNITA' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 30/05/2022 10:42:04 am >> DELETE FROM ps_product_supplier WHERE id_product = '18837' AND id_supplier = '' 30/05/2022 10:42:04 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18837' , '' , '1' ) 30/05/2022 10:42:04 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 ( '51968' , '16689' , 'OSTIA PAN DI CENA mm80' , '7' , '-7' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '14.00' ) 30/05/2022 10:42:04 am >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = '' 30/05/2022 10:42:04 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '' , '1' ) 30/05/2022 10:42:04 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 ( '51968' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 30/05/2022 10:42:04 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 30/05/2022 10:42:04 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 30/05/2022 10:42:04 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 ( '51968' , '15387' , 'VESTINA BATTESIMALE ' , '5' , '-5' , '1' , '2.80' , '2.2950819672131' , '22' , '0' , '14.00' ) 30/05/2022 10:42:04 am >> DELETE FROM ps_product_supplier WHERE id_product = '15387' AND id_supplier = '' 30/05/2022 10:42:04 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15387' , '' , '1' ) 30/05/2022 10:42:04 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 ( '51968' , '791' , 'ASSISI IN BUSTA BATTESIMO - 20X270 - BAAS' , '5' , '-5' , '1' , '1.40' , '1.1475409836066' , '22' , '0' , '7.00' ) 30/05/2022 10:42:04 am >> DELETE FROM ps_product_supplier WHERE id_product = '791' AND id_supplier = '' 30/05/2022 10:42:04 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '791' , '' , '1' ) 30/05/2022 10:42:04 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 ( '51968' , '14247' , 'ROSARIO ULIVO OVALE CON SETA E CROCE SAN DAMIANO' , '12' , '-12' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '18.00' ) 30/05/2022 10:42:04 am >> DELETE FROM ps_product_supplier WHERE id_product = '14247' AND id_supplier = '' 30/05/2022 10:42:04 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14247' , '' , '1' ) 30/05/2022 10:42:04 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 ( '51968' , '18890' , 'ROSARIO LEGNO - R980' , '12' , '-12' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '12.00' ) 30/05/2022 10:42:04 am >> DELETE FROM ps_product_supplier WHERE id_product = '18890' AND id_supplier = '' 30/05/2022 10:42:04 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18890' , '' , '1' ) 30/05/2022 10:42:04 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 ( '51968' , '19515' , 'AMEN - LUG 2022' , '5' , '-5' , '4' , '3.90' , '3.9' , '0' , '5' , '18.52' ) 30/05/2022 10:42:04 am >> DELETE FROM ps_product_supplier WHERE id_product = '19515' AND id_supplier = '' 30/05/2022 10:42:04 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19515' , '' , '1' ) 30/05/2022 10:42:04 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 ( '51968' , '19516' , 'AMEN - AGO 2022' , '5' , '-5' , '4' , '3.90' , '3.9' , '0' , '5' , '18.52' ) 30/05/2022 10:42:04 am >> DELETE FROM ps_product_supplier WHERE id_product = '19516' AND id_supplier = '' 30/05/2022 10:42:04 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19516' , '' , '1' ) 30/05/2022 10:42:04 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 ( '51968' , '11678' , 'SOPRACULLA - 1132' , '4' , '-4' , '1' , '2.50' , '2.0491803278689' , '22' , '0' , '10.00' ) 30/05/2022 10:42:04 am >> DELETE FROM ps_product_supplier WHERE id_product = '11678' AND id_supplier = '' 30/05/2022 10:42:04 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11678' , '' , '1' ) 30/05/2022 11:00:08 am >> SELECT document_num FROM ps_document WHERE document_num = '1695' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-30') 30/05/2022 11:00:08 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1695' , '2022-05-30' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '54.80' , '53.45' , NOW() , NOW() ) 30/05/2022 11:00:08 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58493' 30/05/2022 11:00:08 am >> DELETE FROM ps_document_detail WHERE id_document = '58493' 30/05/2022 11:00:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58493' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '10' , '-10' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '35.00' ) 30/05/2022 11:00:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 30/05/2022 11:00:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 30/05/2022 11:00:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58493' , '11151' , 'LIBRI' , '9' , '-9' , '4' , '2.2' , '2.2' , '0' , '0' , '19.80' ) 30/05/2022 11:00:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 30/05/2022 11:00:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 30/05/2022 11:19:28 am >> SELECT document_num FROM ps_document WHERE document_num = '1696' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-30') 30/05/2022 11:19:28 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1696' , '2022-05-30' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '21.30' , '20.48' , NOW() , NOW() ) 30/05/2022 11:19:28 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58494' 30/05/2022 11:19:28 am >> DELETE FROM ps_document_detail WHERE id_document = '58494' 30/05/2022 11:19: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 ( '58494' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '5' , '-5' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '17.50' ) 30/05/2022 11:19:28 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 30/05/2022 11:19:28 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 30/05/2022 11:19: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 ( '58494' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '3.80' ) 30/05/2022 11:19:28 am >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 30/05/2022 11:19:28 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 30/05/2022 11:35:17 am >> SELECT document_num FROM ps_document WHERE document_num = '1697' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-30') 30/05/2022 11:35:17 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1697' , '2022-05-30' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '43.60' , '37.11' , NOW() , NOW() ) 30/05/2022 11:35:17 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58495' 30/05/2022 11:35:17 am >> DELETE FROM ps_document_detail WHERE id_document = '58495' 30/05/2022 11:35:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58495' , '15283' , 'DIARIO DELLA FELICITA ' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '5' , '7.60' ) 30/05/2022 11:35:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '15283' AND id_supplier = '' 30/05/2022 11:35:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15283' , '' , '1' ) 30/05/2022 11:35:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58495' , '1041' , 'BENEDIZIONI' , '200' , '-200' , '1' , '0.18' , '0.14754098360656' , '22' , '0' , '36.00' ) 30/05/2022 11:35:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '1041' AND id_supplier = '' 30/05/2022 11:35:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1041' , '' , '1' ) 30/05/2022 11:35:51 am >> SELECT document_num FROM ps_document WHERE document_num = '41/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-05-30') 30/05/2022 11:35:51 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' , '41/A' , '2022-05-30' , 'A' , '3432' , '0' , '4670953' , 'VIA SAN GIOVANNI, 18 84019 VIETRI SUL MARE' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '188.10' , '188.10' , NOW() , NOW() ) 30/05/2022 11:35:51 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 = '58496' 30/05/2022 11:35:51 am >> DELETE FROM ps_document_detail WHERE id_document = '58496' 30/05/2022 11:35:51 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 ( '58496' , '1090' , 'BIBBIA' , '20' , '-20' , '4' , '9.90' , '9.9' , '0' , '5' , '188.10' ) 30/05/2022 11:46:41 am >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '8147' 30/05/2022 11:46:41 am >> UPDATE ps_stock_available SET quantity = quantity + '-11' WHERE id_product = '8147' 30/05/2022 11:47:08 am >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '8082' 30/05/2022 11:47:08 am >> UPDATE ps_stock_available SET quantity = quantity + '-117' WHERE id_product = '8082' 30/05/2022 11:47:28 am >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '8079' 30/05/2022 11:47:28 am >> UPDATE ps_stock_available SET quantity = quantity + '-37' WHERE id_product = '8079' 30/05/2022 11:47:49 am >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '8082' 30/05/2022 11:47:49 am >> UPDATE ps_stock_available SET quantity = quantity + '9' WHERE id_product = '8082' 30/05/2022 11:53:51 am >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '2177' 30/05/2022 11:53:51 am >> UPDATE ps_stock_available SET quantity = quantity + '-76' WHERE id_product = '2177' 30/05/2022 11:54:17 am >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '2178' 30/05/2022 11:54:17 am >> UPDATE ps_stock_available SET quantity = quantity + '-23' WHERE id_product = '2178' 30/05/2022 11:59:34 am >> SELECT ean13 FROM ps_product WHERE ean13 = '000380' AND id_product != '2168' AND ean13 != '' 30/05/2022 11:59:34 am >> UPDATE ps_product SET id_supplier = '77', reference = '2013', ean13 = '000380', date_upd = NOW() WHERE id_product = '2168' 30/05/2022 11:59:34 am >> UPDATE ps_product_lang SET name = 'CLERGY BASIC - Ml - B&P', description = '' WHERE id_product = '2168' 30/05/2022 11:59:34 am >> UPDATE ps_product SET wholesale_price = '12.65', on_sale = '0', price = '27.868852459016395' WHERE id_product = '2168' 30/05/2022 11:59:34 am >> UPDATE ps_product_shop SET wholesale_price = '12.65', price = '27.868852459016395', id_tax_rules_group = '1', id_category_default = '253', 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 = '2168' 30/05/2022 11:59:34 am >> DELETE FROM ps_specific_price WHERE id_product = '2168' 30/05/2022 11:59:45 am >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '2168' 30/05/2022 11:59:45 am >> UPDATE ps_stock_available SET quantity = quantity + '17' WHERE id_product = '2168' 30/05/2022 12:00:30 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000386' AND id_product != '2164' AND ean13 != '' 30/05/2022 12:00:30 pm >> UPDATE ps_product SET id_supplier = '', reference = '2013', ean13 = '000386', date_upd = NOW() WHERE id_product = '2164' 30/05/2022 12:00:30 pm >> UPDATE ps_product_lang SET name = 'CLERGY MISTO Ml EXTRA - B&P', description = '' WHERE id_product = '2164' 30/05/2022 12:00:30 pm >> UPDATE ps_product SET wholesale_price = '14.35', on_sale = '0', price = '31.147540983606557' WHERE id_product = '2164' 30/05/2022 12:00:30 pm >> UPDATE ps_product_shop SET wholesale_price = '14.35', price = '31.147540983606557', id_tax_rules_group = '1', id_category_default = '253', 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 = '2164' 30/05/2022 12:00:30 pm >> DELETE FROM ps_specific_price WHERE id_product = '2164' 30/05/2022 12:00:35 pm >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '2164' 30/05/2022 12:00:35 pm >> UPDATE ps_stock_available SET quantity = quantity + '24' WHERE id_product = '2164' 30/05/2022 12:00:56 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000380' AND id_product != '2168' AND ean13 != '' 30/05/2022 12:00:56 pm >> UPDATE ps_product SET id_supplier = '77', reference = '2013', ean13 = '000380', date_upd = NOW() WHERE id_product = '2168' 30/05/2022 12:00:56 pm >> UPDATE ps_product_lang SET name = 'CLERGY BASIC - ML - B&P', description = '' WHERE id_product = '2168' 30/05/2022 12:00:56 pm >> UPDATE ps_product SET wholesale_price = '12.65', on_sale = '0', price = '27.8689' WHERE id_product = '2168' 30/05/2022 12:00:56 pm >> UPDATE ps_product_shop SET wholesale_price = '12.65', price = '27.8689', id_tax_rules_group = '1', id_category_default = '253', 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 = '2168' 30/05/2022 12:00:56 pm >> DELETE FROM ps_specific_price WHERE id_product = '2168' 30/05/2022 12:02:38 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000386' AND id_product != '2164' AND ean13 != '' 30/05/2022 12:02:38 pm >> UPDATE ps_product SET id_supplier = '', reference = '2013', ean13 = '000386', date_upd = NOW() WHERE id_product = '2164' 30/05/2022 12:02:38 pm >> UPDATE ps_product_lang SET name = 'CLERGY MISTO ML EXTRA - B&P', description = '' WHERE id_product = '2164' 30/05/2022 12:02:38 pm >> UPDATE ps_product SET wholesale_price = '14.35', on_sale = '0', price = '31.1475' WHERE id_product = '2164' 30/05/2022 12:02:38 pm >> UPDATE ps_product_shop SET wholesale_price = '14.35', price = '31.1475', id_tax_rules_group = '1', id_category_default = '253', 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 = '2164' 30/05/2022 12:02:38 pm >> DELETE FROM ps_specific_price WHERE id_product = '2164' 30/05/2022 12:08:09 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000386' AND id_product != '2164' AND ean13 != '' 30/05/2022 12:08:09 pm >> UPDATE ps_product SET id_supplier = '', reference = '2013', ean13 = '000386', date_upd = NOW() WHERE id_product = '2164' 30/05/2022 12:08:09 pm >> UPDATE ps_product_lang SET name = 'CLERGY BASIC EXTRA - ML - B&P', description = '' WHERE id_product = '2164' 30/05/2022 12:08:09 pm >> UPDATE ps_product SET wholesale_price = '14.35', on_sale = '0', price = '31.1475' WHERE id_product = '2164' 30/05/2022 12:08:09 pm >> UPDATE ps_product_shop SET wholesale_price = '14.35', price = '31.1475', id_tax_rules_group = '1', id_category_default = '253', 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 = '2164' 30/05/2022 12:08:09 pm >> DELETE FROM ps_specific_price WHERE id_product = '2164' 30/05/2022 12:16:53 pm >> SELECT document_num FROM ps_document WHERE document_num = '1698' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-30') 30/05/2022 12:16:53 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1698' , '2022-05-30' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.00' , '8.20' , NOW() , NOW() ) 30/05/2022 12:16:53 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58497' 30/05/2022 12:16:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '58497' 30/05/2022 12:16:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58497' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 30/05/2022 12:16:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17160' AND id_supplier = '' 30/05/2022 12:16:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17160' , '' , '1' ) 30/05/2022 12:45:03 pm >> SELECT document_num FROM ps_document WHERE document_num = '1699' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-30') 30/05/2022 12:45: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' , '1699' , '2022-05-30' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.90' , '4.02' , NOW() , NOW() ) 30/05/2022 12:45: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 = '58498' 30/05/2022 12:45:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '58498' 30/05/2022 12:45: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 ( '58498' , '17610' , 'CATENINA IN ACCIAIO CM 55' , '1' , '-1' , '1' , '4.20' , '3.4426229508197' , '22' , '0' , '4.20' ) 30/05/2022 12:45:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17610' AND id_supplier = '' 30/05/2022 12:45:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17610' , '' , '1' ) 30/05/2022 12:45: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 ( '58498' , '17052' , 'CROCETTA S. BENEDETTO METALLO OX CM5X3,3 - PG382' , '1' , '-1' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '0.70' ) 30/05/2022 12:45:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17052' AND id_supplier = '' 30/05/2022 12:45:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17052' , '' , '1' ) 30/05/2022 12:49:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '1700' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-30') 30/05/2022 12:49: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' , '1700' , '2022-05-30' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.16' , '14.16' , NOW() , NOW() ) 30/05/2022 12:49: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 = '58499' 30/05/2022 12:49:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '58499' 30/05/2022 12:49: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 ( '58499' , '19388' , 'NOI CREDIAMO - PAPA FRANCESCO' , '1' , '-1' , '4' , '14.90' , '14.9' , '0' , '5' , '14.16' ) 30/05/2022 12:49:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19388' AND id_supplier = '' 30/05/2022 12:49:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19388' , '' , '1' ) 30/05/2022 12:49:40 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 30/05/2022 12:49:40 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19604' , '1' , '' , 'nuovo-prodotto' ) 30/05/2022 12:49:40 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '19604' , '1' , '1' , '2' , NOW() , NOW() ) 30/05/2022 12:49:40 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '19604' , '0' , '1' , '0' , '0' ) 30/05/2022 12:50:36 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788826607108' AND id_product != '19604' AND ean13 != '' 30/05/2022 12:50:36 pm >> UPDATE ps_product SET id_supplier = '', reference = '13/6', ean13 = '9788826607108', date_upd = NOW() WHERE id_product = '19604' 30/05/2022 12:50:36 pm >> UPDATE ps_product_lang SET name = 'QUALE DIACONIA? - E. PETROLINO', description = '' WHERE id_product = '19604' 30/05/2022 12:50:36 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '20.491803278688526' WHERE id_product = '19604' 30/05/2022 12:50:36 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '20.491803278688526', id_tax_rules_group = '1', id_category_default = '104', id_argoment_default = '65', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19604' 30/05/2022 12:50:36 pm >> DELETE FROM ps_specific_price WHERE id_product = '19604' 30/05/2022 12:52:50 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '1787' , '2022-05-27' , '' , '0' , '79' , '2686' , 'CITTA\\\' DEL VATICANO 00120 CITTA\\\' DEL VATICANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '11' , '0' , '236.03' , '233.00' , NOW() , NOW() ) 30/05/2022 12:52:50 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58500' 30/05/2022 12:52:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '58500' 30/05/2022 12:52:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58500' , '17329' , 'MESSALE ROMANO D\'ALTARE N.E' , '2' , '2' , '4' , '110.00' , '110' , '0' , '30' , '154.0000' ) 30/05/2022 12:52:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17329' AND id_supplier = '79' 30/05/2022 12:52:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17329' , '79' , '1' ) 30/05/2022 12:52:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58500' , '5762' , 'LEZIONARIO E RITO DEL MATRIMONIO - KIT 2 VOL.' , '1' , '1' , '4' , '25.00' , '25' , '0' , '35' , '16.2500' ) 30/05/2022 12:52:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5762' AND id_supplier = '79' 30/05/2022 12:52:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5762' , '79' , '1' ) 30/05/2022 12:52:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58500' , '19604' , 'QUALE DIACONIA? - E. PETROLINO' , '1' , '1' , '1' , '25.00' , '20.491803278689' , '22' , '45' , '16.7750' ) 30/05/2022 12:52:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19604' AND id_supplier = '79' 30/05/2022 12:52:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19604' , '79' , '1' ) 30/05/2022 12:52:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58500' , '5889' , 'LITURGIA DELLE ORE - VOL. III - PER SACERDOTI E RELIGIOSI' , '1' , '1' , '4' , '35.00' , '35' , '0' , '30' , '24.5000' ) 30/05/2022 12:52:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5889' AND id_supplier = '79' 30/05/2022 12:52:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5889' , '79' , '1' ) 30/05/2022 12:52:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58500' , '5890' , 'LITURGIA DELLE ORE - VOL. IV - PER SACERDOTI E RELIGIOSI' , '1' , '1' , '4' , '35.00' , '35' , '0' , '30' , '24.5000' ) 30/05/2022 12:52:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5890' AND id_supplier = '79' 30/05/2022 12:52:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5890' , '79' , '1' ) 30/05/2022 02:34:49 pm >> UPDATE ps_document SET id_document_type = '31', document_num = '101', document_date = '2022-05-24', document_letter = '', id_customer = '0', id_supplier = '', id_address = '4670816', address1 = 'VIA G. BATTISTA VICO 73 80010 VILLARICCA', address2 = '', note = '', price_shipping = '10.00', id_tax_shipping_rules = '1', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '109.11', price_tax_excluded = '89.44', date_upd = NOW() WHERE id_document = '58441' 30/05/2022 02:34:49 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 = '58441' 30/05/2022 02:34:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '58441' 30/05/2022 02:34:49 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 ( '58441' , '19397' , 'CLERGY COTONE 100% ML - C02' , '4' , '4' , '1' , '17.3' , '14.180327868852' , '22' , '5' , '80.2028' ) 30/05/2022 02:34:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19397' AND id_supplier = '' 30/05/2022 02:34:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19397' , '' , '1' ) 30/05/2022 02:34:49 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 ( '58441' , '13749' , 'TUNICA SVASATA COLLETTO LISTINO' , '1' , '1' , '1' , '13.7000' , '11.229508196721' , '22' , '0' , '16.71' ) 30/05/2022 02:34:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13749' AND id_supplier = '' 30/05/2022 02:34:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13749' , '' , '1' ) 30/05/2022 02:35:37 pm >> DELETE FROM ps_product WHERE id_product = '16511' 30/05/2022 02:35:37 pm >> DELETE FROM ps_product_shop WHERE id_product = '16511' 30/05/2022 02:35:37 pm >> DELETE FROM ps_product_lang WHERE id_product = '16511' 30/05/2022 02:35:37 pm >> DELETE FROM ps_stock_available WHERE id_product = '16511' 30/05/2022 02:44:22 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001409' AND id_product != '16570' AND ean13 != '' 30/05/2022 02:44:22 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '001409', date_upd = NOW() WHERE id_product = '16570' 30/05/2022 02:44:22 pm >> UPDATE ps_product_lang SET name = 'CLERGY COTONE EXTRA ML - C02', description = '' WHERE id_product = '16570' 30/05/2022 02:44:23 pm >> UPDATE ps_product SET wholesale_price = '17.67', on_sale = '0', price = '34.3443' WHERE id_product = '16570' 30/05/2022 02:44:23 pm >> UPDATE ps_product_shop SET wholesale_price = '17.67', price = '34.3443', id_tax_rules_group = '1', id_category_default = '462', 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 = '16570' 30/05/2022 02:44:23 pm >> DELETE FROM ps_specific_price WHERE id_product = '16570' 30/05/2022 02:45:16 pm >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '16570' 30/05/2022 02:45:16 pm >> UPDATE ps_stock_available SET quantity = quantity + '1' WHERE id_product = '16570' 30/05/2022 02:46:49 pm >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '19397' 30/05/2022 02:46:49 pm >> UPDATE ps_stock_available SET quantity = quantity + '8' WHERE id_product = '19397' 30/05/2022 02:49:00 pm >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '19395' 30/05/2022 02:49:00 pm >> UPDATE ps_stock_available SET quantity = quantity + '15' WHERE id_product = '19395' 30/05/2022 03:02:17 pm >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '19396' 30/05/2022 03:02:17 pm >> UPDATE ps_stock_available SET quantity = quantity + '15' WHERE id_product = '19396' 30/05/2022 03:04:22 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001355' AND id_product != '16489' AND ean13 != '' 30/05/2022 03:04:22 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '001355', date_upd = NOW() WHERE id_product = '16489' 30/05/2022 03:04:22 pm >> UPDATE ps_product_lang SET name = 'CLERGY DIAMANTINO ML - C19', description = '' WHERE id_product = '16489' 30/05/2022 03:04:22 pm >> UPDATE ps_product SET wholesale_price = '28.03', on_sale = '0', price = '56.3934' WHERE id_product = '16489' 30/05/2022 03:04:22 pm >> UPDATE ps_product_shop SET wholesale_price = '28.03', price = '56.3934', id_tax_rules_group = '1', id_category_default = '462', 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 = '16489' 30/05/2022 03:04:22 pm >> DELETE FROM ps_specific_price WHERE id_product = '16489' 30/05/2022 03:06:08 pm >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '16489' 30/05/2022 03:06:08 pm >> UPDATE ps_stock_available SET quantity = quantity + '6' WHERE id_product = '16489' 30/05/2022 03:12:17 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001440' AND id_product != '16657' AND ean13 != '' 30/05/2022 03:12:17 pm >> UPDATE ps_product SET id_supplier = '137', reference = '', ean13 = '001440', date_upd = NOW() WHERE id_product = '16657' 30/05/2022 03:12:17 pm >> UPDATE ps_product_lang SET name = 'CLERGY JEANS - ML ', description = '' WHERE id_product = '16657' 30/05/2022 03:12:17 pm >> UPDATE ps_product SET wholesale_price = '22.40', on_sale = '0', price = '45.0820' WHERE id_product = '16657' 30/05/2022 03:12:17 pm >> UPDATE ps_product_shop SET wholesale_price = '22.40', price = '45.0820', id_tax_rules_group = '1', id_category_default = '462', 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 = '16657' 30/05/2022 03:12:17 pm >> DELETE FROM ps_specific_price WHERE id_product = '16657' 30/05/2022 03:12:45 pm >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '16657' 30/05/2022 03:12:45 pm >> UPDATE ps_stock_available SET quantity = quantity + '6' WHERE id_product = '16657' 30/05/2022 03:13:28 pm >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '16494' 30/05/2022 03:13:28 pm >> UPDATE ps_stock_available SET quantity = quantity + '1' WHERE id_product = '16494' 30/05/2022 03:13:41 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001360' AND id_product != '16494' AND ean13 != '' 30/05/2022 03:13:41 pm >> UPDATE ps_product SET id_supplier = '137', reference = '', ean13 = '001360', date_upd = NOW() WHERE id_product = '16494' 30/05/2022 03:13:41 pm >> UPDATE ps_product_lang SET name = 'CLERGY JEANSATA ML MISTO - C01/J', description = '' WHERE id_product = '16494' 30/05/2022 03:13:41 pm >> UPDATE ps_product SET wholesale_price = '16.82', on_sale = '0', price = '34.3443' WHERE id_product = '16494' 30/05/2022 03:13:41 pm >> UPDATE ps_product_shop SET wholesale_price = '16.82', price = '34.3443', id_tax_rules_group = '1', id_category_default = '462', 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 = '16494' 30/05/2022 03:13:41 pm >> DELETE FROM ps_specific_price WHERE id_product = '16494' 30/05/2022 03:13:54 pm >> DELETE FROM ps_product WHERE id_product = '16498' 30/05/2022 03:13:54 pm >> DELETE FROM ps_product_shop WHERE id_product = '16498' 30/05/2022 03:13:54 pm >> DELETE FROM ps_product_lang WHERE id_product = '16498' 30/05/2022 03:13:54 pm >> DELETE FROM ps_stock_available WHERE id_product = '16498' 30/05/2022 03:16:01 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001327' AND id_product != '16461' AND ean13 != '' 30/05/2022 03:16:01 pm >> UPDATE ps_product SET id_supplier = '137', reference = '', ean13 = '001327', date_upd = NOW() WHERE id_product = '16461' 30/05/2022 03:16:01 pm >> UPDATE ps_product_lang SET name = 'CLERGY NIDO D\'APE ML - C 22', description = '' WHERE id_product = '16461' 30/05/2022 03:16:01 pm >> UPDATE ps_product SET wholesale_price = '22.71', on_sale = '0', price = '45.0820' WHERE id_product = '16461' 30/05/2022 03:16:01 pm >> UPDATE ps_product_shop SET wholesale_price = '22.71', price = '45.0820', id_tax_rules_group = '1', id_category_default = '462', 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 = '16461' 30/05/2022 03:16:01 pm >> DELETE FROM ps_specific_price WHERE id_product = '16461' 30/05/2022 03:16:28 pm >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '16461' 30/05/2022 03:16:28 pm >> UPDATE ps_stock_available SET quantity = quantity + '6' WHERE id_product = '16461' 30/05/2022 03:18:47 pm >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '16588' 30/05/2022 03:18:47 pm >> UPDATE ps_stock_available SET quantity = quantity + '3' WHERE id_product = '16588' 30/05/2022 03:19:08 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001427' AND id_product != '16588' AND ean13 != '' 30/05/2022 03:19:08 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '001427', date_upd = NOW() WHERE id_product = '16588' 30/05/2022 03:19:08 pm >> UPDATE ps_product_lang SET name = 'CLERGY DIAGONALE MISTO ML - C06', description = '' WHERE id_product = '16588' 30/05/2022 03:19:08 pm >> UPDATE ps_product SET wholesale_price = '15.11', on_sale = '0', price = '36.0656' WHERE id_product = '16588' 30/05/2022 03:19:08 pm >> UPDATE ps_product_shop SET wholesale_price = '15.11', price = '36.0656', id_tax_rules_group = '1', id_category_default = '462', 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 = '16588' 30/05/2022 03:19:08 pm >> DELETE FROM ps_specific_price WHERE id_product = '16588' 30/05/2022 03:19:42 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001427' AND id_product != '16588' AND ean13 != '' 30/05/2022 03:19:42 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '001427', date_upd = NOW() WHERE id_product = '16588' 30/05/2022 03:19:42 pm >> UPDATE ps_product_lang SET name = 'CLERGY DIAGONALE MISTO ML - C06', description = '' WHERE id_product = '16588' 30/05/2022 03:19:42 pm >> UPDATE ps_product SET wholesale_price = '15.11', on_sale = '0', price = '36.0656' WHERE id_product = '16588' 30/05/2022 03:19:42 pm >> UPDATE ps_product_shop SET wholesale_price = '15.11', price = '36.0656', id_tax_rules_group = '1', id_category_default = '462', 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 = '16588' 30/05/2022 03:19:42 pm >> DELETE FROM ps_specific_price WHERE id_product = '16588' 30/05/2022 03:23:03 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001506' AND id_product != '17037' AND ean13 != '' 30/05/2022 03:23:03 pm >> UPDATE ps_product SET id_supplier = '137', reference = '', ean13 = '001506', date_upd = NOW() WHERE id_product = '17037' 30/05/2022 03:23:03 pm >> UPDATE ps_product_lang SET name = 'CLERGY M/LINO MM ', description = '' WHERE id_product = '17037' 30/05/2022 03:23:03 pm >> UPDATE ps_product SET wholesale_price = '24.48', on_sale = '0', price = '48.3607' WHERE id_product = '17037' 30/05/2022 03:23:03 pm >> UPDATE ps_product_shop SET wholesale_price = '24.48', price = '48.3607', id_tax_rules_group = '1', id_category_default = '462', 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 = '17037' 30/05/2022 03:23:03 pm >> DELETE FROM ps_specific_price WHERE id_product = '17037' 30/05/2022 03:23:21 pm >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '17037' 30/05/2022 03:23:21 pm >> UPDATE ps_stock_available SET quantity = quantity + '8' WHERE id_product = '17037' 30/05/2022 03:24:51 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001374' AND id_product != '16535' AND ean13 != '' 30/05/2022 03:24:51 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '001374', date_upd = NOW() WHERE id_product = '16535' 30/05/2022 03:24:51 pm >> UPDATE ps_product_lang SET name = 'CLERGY MARANGEL ML - C20', description = '' WHERE id_product = '16535' 30/05/2022 03:24:51 pm >> UPDATE ps_product SET wholesale_price = '19.95', on_sale = '0', price = '39.3443' WHERE id_product = '16535' 30/05/2022 03:24:51 pm >> UPDATE ps_product_shop SET wholesale_price = '19.95', price = '39.3443', id_tax_rules_group = '1', id_category_default = '462', 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 = '16535' 30/05/2022 03:24:51 pm >> DELETE FROM ps_specific_price WHERE id_product = '16535' 30/05/2022 03:25:12 pm >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '16535' 30/05/2022 03:25:12 pm >> UPDATE ps_stock_available SET quantity = quantity + '3' WHERE id_product = '16535' 30/05/2022 03:27:04 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001830' AND id_product != '18947' AND ean13 != '' 30/05/2022 03:27:04 pm >> UPDATE ps_product SET id_supplier = '137', reference = '', ean13 = '001830', date_upd = NOW() WHERE id_product = '18947' 30/05/2022 03:27:05 pm >> UPDATE ps_product_lang SET name = 'CLERGY MISTO 80-20 ML - COM', description = '' WHERE id_product = '18947' 30/05/2022 03:27:05 pm >> UPDATE ps_product SET wholesale_price = '15.30', on_sale = '0', price = '32.7049' WHERE id_product = '18947' 30/05/2022 03:27:05 pm >> UPDATE ps_product_shop SET wholesale_price = '15.30', price = '32.7049', id_tax_rules_group = '1', id_category_default = '462', 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 = '18947' 30/05/2022 03:27:05 pm >> DELETE FROM ps_specific_price WHERE id_product = '18947' 30/05/2022 03:27:33 pm >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '18947' 30/05/2022 03:27:33 pm >> UPDATE ps_stock_available SET quantity = quantity + '14' WHERE id_product = '18947' 30/05/2022 03:29:24 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001792' AND id_product != '18682' AND ean13 != '' 30/05/2022 03:29:24 pm >> UPDATE ps_product SET id_supplier = '137', reference = '', ean13 = '001792', date_upd = NOW() WHERE id_product = '18682' 30/05/2022 03:29:24 pm >> UPDATE ps_product_lang SET name = 'CLERGY ROMANO ML - C17', description = '' WHERE id_product = '18682' 30/05/2022 03:29:24 pm >> UPDATE ps_product SET wholesale_price = '20.81', on_sale = '0', price = '40.1639' WHERE id_product = '18682' 30/05/2022 03:29:24 pm >> UPDATE ps_product_shop SET wholesale_price = '20.81', price = '40.1639', id_tax_rules_group = '1', id_category_default = '462', 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 = '18682' 30/05/2022 03:29:24 pm >> DELETE FROM ps_specific_price WHERE id_product = '18682' 30/05/2022 03:29:45 pm >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '18682' 30/05/2022 03:29:45 pm >> UPDATE ps_stock_available SET quantity = quantity + '3' WHERE id_product = '18682' 30/05/2022 03:30:17 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 30/05/2022 03:30:17 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19605' , '1' , '' , 'nuovo-prodotto' ) 30/05/2022 03:30:17 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '19605' , '1' , '1' , '2' , NOW() , NOW() ) 30/05/2022 03:30:17 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '19605' , '0' , '1' , '0' , '0' ) 30/05/2022 03:30:46 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001372' AND id_product != '19605' AND ean13 != '' 30/05/2022 03:30:47 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '001372', date_upd = NOW() WHERE id_product = '19605' 30/05/2022 03:30:47 pm >> UPDATE ps_product_lang SET name = 'CLERGY SU MISURA - COCOCLER', description = '' WHERE id_product = '19605' 30/05/2022 03:30:47 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0.0000' WHERE id_product = '19605' 30/05/2022 03:30:47 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0.0000', id_tax_rules_group = '1', id_category_default = '462', 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 = '19605' 30/05/2022 03:30:47 pm >> DELETE FROM ps_specific_price WHERE id_product = '19605' 30/05/2022 03:31:46 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001372' AND id_product != '19605' AND ean13 != '' 30/05/2022 03:31:46 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '001372', date_upd = NOW() WHERE id_product = '19605' 30/05/2022 03:31:46 pm >> UPDATE ps_product_lang SET name = 'CLERGY SU MISURA - COCOCLER', description = '' WHERE id_product = '19605' 30/05/2022 03:31:46 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0.0000' WHERE id_product = '19605' 30/05/2022 03:31:46 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0.0000', id_tax_rules_group = '1', id_category_default = '462', 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 = '19605' 30/05/2022 03:31:46 pm >> DELETE FROM ps_specific_price WHERE id_product = '19605' 30/05/2022 03:34:28 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001859' AND id_product != '18984' AND ean13 != '' 30/05/2022 03:34:28 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '001859', date_upd = NOW() WHERE id_product = '18984' 30/05/2022 03:34:28 pm >> UPDATE ps_product_lang SET name = 'POLO FELPATO ML - ', description = '' WHERE id_product = '18984' 30/05/2022 03:34:28 pm >> UPDATE ps_product SET wholesale_price = '24.30', on_sale = '0', price = '48.3607' WHERE id_product = '18984' 30/05/2022 03:34:28 pm >> UPDATE ps_product_shop SET wholesale_price = '24.30', price = '48.3607', id_tax_rules_group = '1', id_category_default = '462', 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 = '18984' 30/05/2022 03:34:28 pm >> DELETE FROM ps_specific_price WHERE id_product = '18984' 30/05/2022 03:36:39 pm >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '18984' 30/05/2022 03:36:39 pm >> UPDATE ps_stock_available SET quantity = quantity + '34' WHERE id_product = '18984' 30/05/2022 03:38:25 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001837' AND id_product != '18962' AND ean13 != '' 30/05/2022 03:38:25 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '001837', date_upd = NOW() WHERE id_product = '18962' 30/05/2022 03:38:25 pm >> UPDATE ps_product_lang SET name = 'POLO MISTO VISCOSA ML ', description = '' WHERE id_product = '18962' 30/05/2022 03:38:25 pm >> UPDATE ps_product SET wholesale_price = '21.60', on_sale = '0', price = '40.9836' WHERE id_product = '18962' 30/05/2022 03:38:25 pm >> UPDATE ps_product_shop SET wholesale_price = '21.60', price = '40.9836', id_tax_rules_group = '1', id_category_default = '462', 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 = '18962' 30/05/2022 03:38:25 pm >> DELETE FROM ps_specific_price WHERE id_product = '18962' 30/05/2022 03:39:06 pm >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '18962' 30/05/2022 03:39:06 pm >> UPDATE ps_stock_available SET quantity = quantity + '33' WHERE id_product = '18962' 30/05/2022 03:40:19 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001534' AND id_product != '17087' AND ean13 != '' 30/05/2022 03:40:19 pm >> UPDATE ps_product SET id_supplier = '137', reference = '', ean13 = '001534', date_upd = NOW() WHERE id_product = '17087' 30/05/2022 03:40:19 pm >> UPDATE ps_product_lang SET name = 'POLO COTONE MM', description = '' WHERE id_product = '17087' 30/05/2022 03:40:19 pm >> UPDATE ps_product SET wholesale_price = '18.90', on_sale = '0', price = '37.7049' WHERE id_product = '17087' 30/05/2022 03:40:19 pm >> UPDATE ps_product_shop SET wholesale_price = '18.90', price = '37.7049', id_tax_rules_group = '1', id_category_default = '462', 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 = '17087' 30/05/2022 03:40:19 pm >> DELETE FROM ps_specific_price WHERE id_product = '17087' 30/05/2022 03:40:50 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001534' AND id_product != '17087' AND ean13 != '' 30/05/2022 03:40:51 pm >> UPDATE ps_product SET id_supplier = '137', reference = '', ean13 = '001534', date_upd = NOW() WHERE id_product = '17087' 30/05/2022 03:40:51 pm >> UPDATE ps_product_lang SET name = 'POLO COTONE MM', description = '' WHERE id_product = '17087' 30/05/2022 03:40:51 pm >> UPDATE ps_product SET wholesale_price = '18.90', on_sale = '0', price = '37.7049' WHERE id_product = '17087' 30/05/2022 03:40:51 pm >> UPDATE ps_product_shop SET wholesale_price = '18.90', price = '37.7049', id_tax_rules_group = '1', id_category_default = '462', 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 = '17087' 30/05/2022 03:40:51 pm >> DELETE FROM ps_specific_price WHERE id_product = '17087' 30/05/2022 03:41:44 pm >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '17087' 30/05/2022 03:41:44 pm >> UPDATE ps_stock_available SET quantity = quantity + '4' WHERE id_product = '17087' 30/05/2022 03:41:51 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001534' AND id_product != '17087' AND ean13 != '' 30/05/2022 03:41:51 pm >> UPDATE ps_product SET id_supplier = '137', reference = '', ean13 = '001534', date_upd = NOW() WHERE id_product = '17087' 30/05/2022 03:41:51 pm >> UPDATE ps_product_lang SET name = 'POLO COTONE MM', description = '' WHERE id_product = '17087' 30/05/2022 03:41:51 pm >> UPDATE ps_product SET wholesale_price = '18.90', on_sale = '0', price = '37.7049' WHERE id_product = '17087' 30/05/2022 03:41:51 pm >> UPDATE ps_product_shop SET wholesale_price = '18.90', price = '37.7049', id_tax_rules_group = '1', id_category_default = '462', 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 = '17087' 30/05/2022 03:41:51 pm >> DELETE FROM ps_specific_price WHERE id_product = '17087' 30/05/2022 03:42:28 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 30/05/2022 03:42:28 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19606' , '1' , '' , 'nuovo-prodotto' ) 30/05/2022 03:42:28 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '19606' , '1' , '1' , '2' , NOW() , NOW() ) 30/05/2022 03:42:28 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '19606' , '0' , '1' , '0' , '0' ) 30/05/2022 03:43:45 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001653' AND id_product != '19606' AND ean13 != '' 30/05/2022 03:43:45 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '001653', date_upd = NOW() WHERE id_product = '19606' 30/05/2022 03:43:45 pm >> UPDATE ps_product_lang SET name = 'SOTTOTALARE MISTO COTONE- C15', description = '' WHERE id_product = '19606' 30/05/2022 03:43:45 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0.0000' WHERE id_product = '19606' 30/05/2022 03:43:45 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0.0000', id_tax_rules_group = '1', id_category_default = '462', 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 = '19606' 30/05/2022 03:43:45 pm >> DELETE FROM ps_specific_price WHERE id_product = '19606' 30/05/2022 03:45:04 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001653' AND id_product != '19606' AND ean13 != '' 30/05/2022 03:45:04 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '001653', date_upd = NOW() WHERE id_product = '19606' 30/05/2022 03:45:04 pm >> UPDATE ps_product_lang SET name = 'SOTTOTALARE MISTO COTONE- C15', description = '' WHERE id_product = '19606' 30/05/2022 03:45:04 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0.0000' WHERE id_product = '19606' 30/05/2022 03:45:04 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0.0000', id_tax_rules_group = '1', id_category_default = '462', 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 = '19606' 30/05/2022 03:45:04 pm >> DELETE FROM ps_specific_price WHERE id_product = '19606' 30/05/2022 03:46:58 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 30/05/2022 03:46:58 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19607' , '1' , '' , 'nuovo-prodotto' ) 30/05/2022 03:46:58 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '19607' , '1' , '1' , '2' , NOW() , NOW() ) 30/05/2022 03:46:58 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '19607' , '0' , '1' , '0' , '0' ) 30/05/2022 03:49:28 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001410' AND id_product != '19607' AND ean13 != '' 30/05/2022 03:49:28 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '001410', date_upd = NOW() WHERE id_product = '19607' 30/05/2022 03:49:28 pm >> UPDATE ps_product_lang SET name = 'CLERGY F/F COTONE ML ', description = '' WHERE id_product = '19607' 30/05/2022 03:49:28 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0.0000' WHERE id_product = '19607' 30/05/2022 03:49:28 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0.0000', id_tax_rules_group = '1', id_category_default = '462', 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 = '19607' 30/05/2022 03:49:28 pm >> DELETE FROM ps_specific_price WHERE id_product = '19607' 30/05/2022 04:02:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '1369' AND id_document != '56557' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-03') 30/05/2022 04:02:14 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1369', document_date = '2022-05-03', 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 = '31.00', price_tax_excluded = '27.03', date_upd = NOW() WHERE id_document = '56557' 30/05/2022 04:02: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 = '56557' 30/05/2022 04:02:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '56557' 30/05/2022 04:02: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 ( '56557' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 30/05/2022 04:02:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17160' AND id_supplier = '' 30/05/2022 04:02:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17160' , '' , '1' ) 30/05/2022 04:02: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 ( '56557' , '17161' , 'CARBONCINI NERI - CARNE' , '1' , '-1' , '1' , '12.0000' , '9.8360655737705' , '22' , '0' , '12.00' ) 30/05/2022 04:02:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17161' AND id_supplier = '' 30/05/2022 04:02:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17161' , '' , '1' ) 30/05/2022 04:02: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 ( '56557' , '19503' , 'UN MESE CON MARIA - 8064' , '1' , '-1' , '4' , '9.0000' , '9' , '0' , '0' , '9.00' ) 30/05/2022 04:02:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19503' AND id_supplier = '' 30/05/2022 04:02:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19503' , '' , '1' ) 30/05/2022 04:06:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '1701' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-30') 30/05/2022 04:06:20 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' , '1701' , '2022-05-30' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '87.00' , '71.31' , NOW() , NOW() ) 30/05/2022 04:06:20 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58501' 30/05/2022 04:06:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '58501' 30/05/2022 04:06:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58501' , '7936' , 'PERGAMENE - CRESIMA MOD. C' , '35' , '-35' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '17.50' ) 30/05/2022 04:06:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7936' AND id_supplier = '' 30/05/2022 04:06:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7936' , '' , '1' ) 30/05/2022 04:06:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58501' , '19598' , 'MEDAGLIA SPILLA SPIRITO SANTO - G24OX' , '35' , '-35' , '1' , '1.30' , '1.0655737704918' , '22' , '0' , '45.50' ) 30/05/2022 04:06:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19598' AND id_supplier = '' 30/05/2022 04:06:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19598' , '' , '1' ) 30/05/2022 04:06:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58501' , '15334' , 'CANDELA VOTIVA 20X40' , '35' , '-35' , '1' , '0.6' , '0.49180327868852' , '22' , '0' , '21.00' ) 30/05/2022 04:06:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15334' AND id_supplier = '' 30/05/2022 04:06:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15334' , '' , '1' ) 30/05/2022 04:06:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58501' , '18276' , 'CINGOLO ' , '1' , '-1' , '1' , '3' , '2.4590163934426' , '22' , '0' , '3.00' ) 30/05/2022 04:06:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18276' AND id_supplier = '' 30/05/2022 04:06:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18276' , '' , '1' ) 30/05/2022 04:33:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '1702' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-30') 30/05/2022 04:33: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' , '1702' , '2022-05-30' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.00' , '2.88' , NOW() , NOW() ) 30/05/2022 04:33: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 = '58502' 30/05/2022 04:33:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '58502' 30/05/2022 04:33: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 ( '58502' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '1' , '-1' , '3' , '3' , '2.8846153846154' , '4' , '0' , '3.00' ) 30/05/2022 04:33:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 30/05/2022 04:33:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 30/05/2022 04:49:50 pm >> SELECT document_num FROM ps_document WHERE document_num = '1703' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-30') 30/05/2022 04:49:50 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1703' , '2022-05-30' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '49.00' , '40.73' , NOW() , NOW() ) 30/05/2022 04:49:50 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58503' 30/05/2022 04:49:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '58503' 30/05/2022 04:49:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58503' , '1750' , 'CARTUCCIA TRASPARENTE DIAM. 3,2 - 454' , '2' , '-2' , '1' , '13' , '10.655737704918' , '22' , '0' , '26.00' ) 30/05/2022 04:49:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1750' AND id_supplier = '' 30/05/2022 04:49:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1750' , '' , '1' ) 30/05/2022 04:49:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58503' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.00' , '3.8461538461538' , '4' , '0' , '4.00' ) 30/05/2022 04:49:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16691' AND id_supplier = '' 30/05/2022 04:49:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16691' , '' , '1' ) 30/05/2022 04:49:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58503' , '5230' , 'INCENSO RAPHAEL ' , '1' , '-1' , '1' , '19.00' , '15.573770491803' , '22' , '0' , '19.00' ) 30/05/2022 04:49:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5230' AND id_supplier = '' 30/05/2022 04:49:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5230' , '' , '1' ) 30/05/2022 04:52:51 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000448' AND id_product != '1750' AND ean13 != '' 30/05/2022 04:52:51 pm >> UPDATE ps_product SET id_supplier = '12', reference = '2013', ean13 = '000448', date_upd = NOW() WHERE id_product = '1750' 30/05/2022 04:52:51 pm >> UPDATE ps_product_lang SET name = 'CARTUCCIA TRASPARENTE DIAM. 3,2 - 454', description = '' WHERE id_product = '1750' 30/05/2022 04:52:51 pm >> UPDATE ps_product SET wholesale_price = '4.75', on_sale = '0', price = '10.655737704918034' WHERE id_product = '1750' 30/05/2022 04:52:51 pm >> UPDATE ps_product_shop SET wholesale_price = '4.75', price = '10.655737704918034', id_tax_rules_group = '1', id_category_default = '147', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '1750' 30/05/2022 04:52:51 pm >> DELETE FROM ps_specific_price WHERE id_product = '1750' 30/05/2022 04:53:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '1704' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-30') 30/05/2022 04:53:55 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1704' , '2022-05-30' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.40' , '1.97' , NOW() , NOW() ) 30/05/2022 04:53:55 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58504' 30/05/2022 04:53:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '58504' 30/05/2022 04:53:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58504' , '18338' , 'CROCE BIANCA CALICE - S2253/CZ' , '1' , '-1' , '1' , '2.40' , '1.9672131147541' , '22' , '0' , '2.40' ) 30/05/2022 04:53:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18338' AND id_supplier = '' 30/05/2022 04:53:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18338' , '' , '1' ) 30/05/2022 05:00:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '1596' AND id_document != '57857' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-20') 30/05/2022 05:00:59 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1596', document_date = '2022-05-20', 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 = '27.00', price_tax_excluded = '22.13', date_upd = NOW() WHERE id_document = '57857' 30/05/2022 05:00: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 = '57857' 30/05/2022 05:00:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '57857' 30/05/2022 05:00: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 ( '57857' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '4' , '-4' , '1' , '3' , '2.4590163934426' , '22' , '0' , '12.00' ) 30/05/2022 05:00:59 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5903' AND id_supplier = '' 30/05/2022 05:00:59 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5903' , '' , '1' ) 30/05/2022 05:00: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 ( '57857' , '11384' , 'VINO BIANCO DOLCE - 102' , '2' , '-2' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '15.00' ) 30/05/2022 05:00:59 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11384' AND id_supplier = '' 30/05/2022 05:00:59 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11384' , '' , '1' ) 30/05/2022 05:01:34 pm >> SELECT document_num FROM ps_document WHERE document_num = '1591' AND id_document != '57852' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-19') 30/05/2022 05:01:34 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1591', document_date = '2022-05-19', 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 = '79.00', price_tax_excluded = '72.27', date_upd = NOW() WHERE id_document = '57852' 30/05/2022 05:01:34 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 = '57852' 30/05/2022 05:01:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '57852' 30/05/2022 05:01:34 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 ( '57852' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '10' , '-10' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '35.00' ) 30/05/2022 05:01:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 30/05/2022 05:01:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 30/05/2022 05:01:34 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 ( '57852' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '10.00' ) 30/05/2022 05:01:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = '' 30/05/2022 05:01:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '' , '1' ) 30/05/2022 05:01:34 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 ( '57852' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '2' , '-2' , '3' , '4.0000' , '3.8461538461538' , '4' , '0' , '8.00' ) 30/05/2022 05:01:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16691' AND id_supplier = '' 30/05/2022 05:01:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16691' , '' , '1' ) 30/05/2022 05:01:34 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 ( '57852' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '7' , '5.7377049180328' , '22' , '0' , '7.00' ) 30/05/2022 05:01:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 30/05/2022 05:01:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 30/05/2022 05:01:34 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 ( '57852' , '5230' , 'INCENSO RAPHAEL ' , '1' , '-1' , '1' , '19.00' , '15.573770491803' , '22' , '0' , '19.00' ) 30/05/2022 05:01:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5230' AND id_supplier = '' 30/05/2022 05:01:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5230' , '' , '1' ) 30/05/2022 05:12:11 pm >> DELETE FROM ps_document WHERE id_document = '58464' 30/05/2022 05:12:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '58464' 30/05/2022 05:26:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '1705' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-30') 30/05/2022 05:26: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' , '1705' , '2022-05-30' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '52.00' , '42.62' , NOW() , NOW() ) 30/05/2022 05:26: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 = '58505' 30/05/2022 05:26:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '58505' 30/05/2022 05:26: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 ( '58505' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '27' , '22.131147540984' , '22' , '0' , '27.00' ) 30/05/2022 05:26:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 30/05/2022 05:26:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 30/05/2022 05:26: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 ( '58505' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '25' , '20.491803278689' , '22' , '0' , '25.00' ) 30/05/2022 05:26:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 30/05/2022 05:26:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 30/05/2022 05:52:33 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' , '22VD00155' , '2022-05-27' , '' , '0' , '63' , '2658' , 'P.ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '137.20' , '137.20' , NOW() , NOW() ) 30/05/2022 05:52:33 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 = '58506' 30/05/2022 05:52:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '58506' 30/05/2022 05:52:33 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 ( '58506' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '350' , '350' , '4' , '0.392' , '0.392' , '0' , '0' , '137.2000' ) 30/05/2022 05:52:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4223' AND id_supplier = '63' 30/05/2022 05:52:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4223' , '63' , '1' ) 30/05/2022 05:56:34 pm >> SELECT document_num FROM ps_document WHERE document_num = '1706' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-30') 30/05/2022 05:56:34 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' , '1706' , '2022-05-30' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.00' , '4.10' , NOW() , NOW() ) 30/05/2022 05:56:34 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 = '58507' 30/05/2022 05:56:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '58507' 30/05/2022 05:56:34 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 ( '58507' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '25' , '-25' , '1' , '0.20' , '0.16393442622951' , '22' , '0' , '5.00' ) 30/05/2022 05:56:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18617' AND id_supplier = '' 30/05/2022 05:56:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18617' , '' , '1' ) 30/05/2022 06:01:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '1707' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-30') 30/05/2022 06:01: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' , '1707' , '2022-05-30' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.50' , '1.23' , NOW() , NOW() ) 30/05/2022 06:01: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 = '58508' 30/05/2022 06:01:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '58508' 30/05/2022 06:01: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 ( '58508' , '4697' , 'GLORIA MISCELA 25G - GLORE' , '1' , '-1' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '1.50' ) 30/05/2022 06:01:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4697' AND id_supplier = '' 30/05/2022 06:01:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4697' , '' , '1' ) 30/05/2022 06:16:23 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001972' AND id_product != '19436' AND ean13 != '' 30/05/2022 06:16:23 pm >> UPDATE ps_product SET id_supplier = '160', reference = '', ean13 = '001972', date_upd = NOW() WHERE id_product = '19436' 30/05/2022 06:16:23 pm >> UPDATE ps_product_lang SET name = 'CAMICE MISTO COTONE - CAM0M70', description = '' WHERE id_product = '19436' 30/05/2022 06:16:23 pm >> UPDATE ps_product SET wholesale_price = '290.32', on_sale = '0', price = '581.9672131147541' WHERE id_product = '19436' 30/05/2022 06:16:23 pm >> UPDATE ps_product_shop SET wholesale_price = '290.32', price = '581.9672131147541', id_tax_rules_group = '1', id_category_default = '494', 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 = '19436' 30/05/2022 06:16:23 pm >> DELETE FROM ps_specific_price WHERE id_product = '19436' 30/05/2022 07:08:40 pm >> SELECT document_num FROM ps_document WHERE document_num = '1708' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-30') 30/05/2022 07:08: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' , '1708' , '2022-05-30' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.00' , '4.10' , NOW() , NOW() ) 30/05/2022 07:08: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 = '58509' 30/05/2022 07:08:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '58509' 30/05/2022 07:08: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 ( '58509' , '7910' , 'PERGAMENE - 1A COMUNIONE MOD. A' , '10' , '-10' , '1' , '0.5' , '0.40983606557377' , '22' , '0' , '5.00' ) 30/05/2022 07:08:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7910' AND id_supplier = '' 30/05/2022 07:08:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7910' , '' , '1' ) 30/05/2022 07:18:58 pm >> SELECT document_num FROM ps_document WHERE document_num = '1709' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-30') 30/05/2022 07:18:58 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1709' , '2022-05-30' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.20' , '15.20' , NOW() , NOW() ) 30/05/2022 07:18:58 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58510' 30/05/2022 07:18:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '58510' 30/05/2022 07:18:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58510' , '11104' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. RAGAZZI' , '10' , '-10' , '4' , '1.60' , '1.6' , '0' , '5' , '15.20' ) 30/05/2022 07:18:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11104' AND id_supplier = '' 30/05/2022 07:18:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11104' , '' , '1' )