26/07/2024 09:03:16 am >> SELECT document_num FROM ps_document WHERE document_num = '2353' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-26') 26/07/2024 09:03: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' , '2353' , '2024-07-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '45.00' , '36.89' , NOW() , NOW() ) 26/07/2024 09:03: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 = '92729' 26/07/2024 09:03:17 am >> DELETE FROM ps_document_detail WHERE id_document = '92729' 26/07/2024 09:03: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 ( '92729' , '22199' , 'VINO LIQUOROSO ROSSO ' , '6' , '-6' , '1' , '7.5' , '6.1475409836066' , '22' , '0' , '45.00' ) 26/07/2024 09:16:22 am >> SELECT ean13 FROM ps_product WHERE ean13 = '501/TP' AND id_product != '12296' AND ean13 != '' 26/07/2024 09:16:22 am >> UPDATE ps_product SET id_supplier = '89', reference = '', ean13 = '501/TP', date_upd = NOW() WHERE id_product = '12296' 26/07/2024 09:16:22 am >> UPDATE ps_product_lang SET name = 'CASULA 100% POLIESTERE - 501/TP', description = '' WHERE id_product = '12296' 26/07/2024 09:16:22 am >> UPDATE ps_product SET wholesale_price = '70.00', on_sale = '0', price = '168.0327868852459' WHERE id_product = '12296' 26/07/2024 09:16:22 am >> UPDATE ps_product_shop SET wholesale_price = '70.00', price = '168.0327868852459', id_tax_rules_group = '1', id_category_default = '396', 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 = '12296' 26/07/2024 09:16:22 am >> DELETE FROM ps_specific_price WHERE id_product = '12296' 26/07/2024 09:17:10 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '387' , '2024-07-23' , '' , '0' , '89' , '2729' , 'VIA COLLE DI NAVA, 127D 12060 MAGLIANO ALPI' , '' , '' , '13' , '1' , '0' , '0' , '0' , '' , '10' , '0' , '501.66' , '411.20' , NOW() , NOW() ) 26/07/2024 09:17:10 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 = '92730' 26/07/2024 09:17:10 am >> DELETE FROM ps_document_detail WHERE id_document = '92730' 26/07/2024 09:17:10 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 ( '92730' , '12296' , 'CASULA 100% POLIESTERE - 501/TP' , '1' , '1' , '1' , '84.9' , '69.590163934426' , '22' , '0' , '103.5780' ) 26/07/2024 09:17:10 am >> DELETE FROM ps_product_supplier WHERE id_product = '12296' AND id_supplier = '89' 26/07/2024 09:17:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12296' , '89' , '1' ) 26/07/2024 09:17:11 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 ( '92730' , '14088' , 'CAMICE IN MICROFIBRA - 429/PMA' , '13' , '13' , '1' , '24.1' , '19.754098360656' , '22' , '0' , '382.2260' ) 26/07/2024 09:17:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '14088' AND id_supplier = '89' 26/07/2024 09:17:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14088' , '89' , '1' ) 26/07/2024 10:06:16 am >> SELECT document_num FROM ps_document WHERE document_num = '2354' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-26') 26/07/2024 10:06:16 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' , '2354' , '2024-07-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '37.95' , '31.96' , NOW() , NOW() ) 26/07/2024 10:06:16 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 = '92731' 26/07/2024 10:06:16 am >> DELETE FROM ps_document_detail WHERE id_document = '92731' 26/07/2024 10:06:16 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 ( '92731' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '5' , '-5' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '17.50' ) 26/07/2024 10:06:16 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 ( '92731' , '1914' , 'CERA DELLA LITURGIA' , '2' , '-2' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '9.80' ) 26/07/2024 10:06:16 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 ( '92731' , '22693' , 'SULLA TUA PAROLA - SETT/OTT 2024' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 26/07/2024 10:06:16 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 ( '92731' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '5.9' , '4.8360655737705' , '22' , '0' , '5.90' ) 26/07/2024 10:52:24 am >> SELECT document_num FROM ps_document WHERE document_num = '2355' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-26') 26/07/2024 10:52:24 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' , '2355' , '2024-07-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '800.00' , '655.74' , NOW() , NOW() ) 26/07/2024 10:52:24 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 = '92732' 26/07/2024 10:52:24 am >> DELETE FROM ps_document_detail WHERE id_document = '92732' 26/07/2024 10:52: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 ( '92732' , '7735' , 'PATENA OTTONE - DIAM. 14 - 900' , '1' , '-1' , '1' , '40' , '32.786885245902' , '22' , '0' , '40.00' ) 26/07/2024 10:52: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 ( '92732' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '720' , '590.16393442623' , '22' , '0' , '720.00' ) 26/07/2024 10:52: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 ( '92732' , '18349' , 'PORTACALICE - 18X28 - 720' , '1' , '-1' , '1' , '40' , '32.786885245902' , '22' , '0' , '40.00' ) 26/07/2024 10:58:43 am >> SELECT document_num FROM ps_document WHERE document_num = '1657' AND id_document != '91890' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-18') 26/07/2024 10:58:44 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1657', document_date = '2024-05-18', 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 = '42.00', price_tax_excluded = '34.43', date_upd = NOW() WHERE id_document = '91890' 26/07/2024 10:58:44 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91890' 26/07/2024 10:58:44 am >> DELETE FROM ps_document_detail WHERE id_document = '91890' 26/07/2024 10:58:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91890' , '16792' , 'SOPRACULLA' , '1' , '-1' , '1' , '18.0000' , '14.754098360656' , '22' , '0' , '18.00' ) 26/07/2024 10:58:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91890' , '18651' , 'SOPRACULLA' , '1' , '-1' , '1' , '16.0000' , '13.114754098361' , '22' , '0' , '16.00' ) 26/07/2024 10:58:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91890' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '1' , '-1' , '1' , '8' , '6.5573770491803' , '22' , '0' , '8.00' ) 26/07/2024 11:03:49 am >> SELECT document_num FROM ps_document WHERE document_num = '85/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-07-26') 26/07/2024 11:03:49 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' , '85/A' , '2024-07-26' , 'A' , '333' , '0' , '4671072' , 'P.ZZA S. MICHELE 84135 RUFOLI' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '50.10' , '43.07' , NOW() , NOW() ) 26/07/2024 11:03:49 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 = '92733' 26/07/2024 11:03:49 am >> DELETE FROM ps_document_detail WHERE id_document = '92733' 26/07/2024 11:03:49 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 ( '92733' , '791' , 'ASSISI IN BUSTA BATTESIMO - 20X270 - BAAS' , '8' , '-8' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '12.00' ) 26/07/2024 11:03:49 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 ( '92733' , '15387' , 'VESTINA BATTESIMALE ' , '8' , '-8' , '1' , '3.00' , '2.4590163934426' , '22' , '0' , '24.00' ) 26/07/2024 11:03:49 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 ( '92733' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '2' , '-2' , '3' , '4.30' , '4.1346153846154' , '4' , '0' , '8.60' ) 26/07/2024 11:03:49 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 ( '92733' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 26/07/2024 11:03:49 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 ( '92733' , '16689' , 'OSTIA PAN DI CENA mm80' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 26/07/2024 11:12:01 am >> SELECT document_num FROM ps_document WHERE document_num = '2356' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-26') 26/07/2024 11:12:01 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' , '2356' , '2024-07-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.50' , '6.97' , NOW() , NOW() ) 26/07/2024 11:12:01 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 = '92734' 26/07/2024 11:12:01 am >> DELETE FROM ps_document_detail WHERE id_document = '92734' 26/07/2024 11:12:01 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 ( '92734' , '14926' , 'VESTINA BATTESIMALE' , '1' , '-1' , '1' , '6.00' , '4.9180327868852' , '22' , '0' , '6.00' ) 26/07/2024 11:12:01 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 ( '92734' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '2.50' ) 26/07/2024 11:22:26 am >> SELECT document_num FROM ps_document WHERE document_num = '2357' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-26') 26/07/2024 11:22:26 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' , '2357' , '2024-07-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '57.50' , '51.03' , NOW() , NOW() ) 26/07/2024 11:22:26 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 = '92735' 26/07/2024 11:22:26 am >> DELETE FROM ps_document_detail WHERE id_document = '92735' 26/07/2024 11:22:26 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 ( '92735' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '5' , '-5' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '17.50' ) 26/07/2024 11:22:26 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 ( '92735' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '10.00' ) 26/07/2024 11:22:26 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 ( '92735' , '19107' , 'INCENSO GRANI 3A - BUSTA' , '1' , '-1' , '1' , '30.00' , '24.590163934426' , '22' , '0' , '30.00' ) 26/07/2024 11:32:03 am >> SELECT document_num FROM ps_document WHERE document_num = '2358' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-26') 26/07/2024 11:32:03 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2358' , '2024-07-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '406.90' , '337.25' , NOW() , NOW() ) 26/07/2024 11:32: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 = '92736' 26/07/2024 11:32:03 am >> DELETE FROM ps_document_detail WHERE id_document = '92736' 26/07/2024 11:32: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 ( '92736' , '803' , 'ASTUCCIO VIATICO - GRANDE - 1933' , '1' , '-1' , '1' , '115.00' , '94.262295081967' , '22' , '0' , '115.00' ) 26/07/2024 11:32: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 ( '92736' , '540' , 'AMPOLLE ALTARE FUSIONE DORATA - 504 ' , '1' , '-1' , '1' , '124.00' , '101.6393442623' , '22' , '0' , '124.00' ) 26/07/2024 11:32: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 ( '92736' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 26/07/2024 11:32: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 ( '92736' , '11151' , 'LIBRI' , '5' , '-5' , '4' , '3.5' , '3.5' , '0' , '0' , '17.50' ) 26/07/2024 11:32: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 ( '92736' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3' , '2.4590163934426' , '22' , '0' , '90.00' ) 26/07/2024 11:32: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 ( '92736' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 26/07/2024 11:33:44 am >> SELECT document_num FROM ps_document WHERE document_num = '2359' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-26') 26/07/2024 11:33:44 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2359' , '2024-07-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '105.00' , '86.07' , NOW() , NOW() ) 26/07/2024 11:33:44 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92737' 26/07/2024 11:33:44 am >> DELETE FROM ps_document_detail WHERE id_document = '92737' 26/07/2024 11:33:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92737' , '19396' , 'CLERGY MISTO COTONE MM - C01' , '3' , '-3' , '1' , '35' , '28.688524590164' , '22' , '0' , '105.00' ) 26/07/2024 11:52:20 am >> SELECT document_num FROM ps_document WHERE document_num = '2360' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-26') 26/07/2024 11:52:20 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2360' , '2024-07-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '90.00' , '73.77' , NOW() , NOW() ) 26/07/2024 11:52:20 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92738' 26/07/2024 11:52:20 am >> DELETE FROM ps_document_detail WHERE id_document = '92738' 26/07/2024 11:52:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92738' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '90' , '73.770491803279' , '22' , '0' , '90.00' ) 26/07/2024 03:06:16 pm >> SELECT document_num FROM ps_document WHERE document_num = '2359' AND id_document != '92737' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-26') 26/07/2024 03:06:16 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2359', document_date = '2024-07-26', 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 = '105.00', price_tax_excluded = '86.07', date_upd = NOW() WHERE id_document = '92737' 26/07/2024 03:06:16 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92737' 26/07/2024 03:06:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '92737' 26/07/2024 03:06:17 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 ( '92737' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '105' , '86.065573770492' , '22' , '0' , '105.00' ) 26/07/2024 04:23:14 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 26/07/2024 04:23:14 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22784' , '1' , '' , 'nuovo-prodotto' ) 26/07/2024 04:23:14 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '22784' , '1' , '1' , '2' , NOW() , NOW() ) 26/07/2024 04:23:15 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '22784' , '0' , '1' , '0' , '0' ) 26/07/2024 04:24:10 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831526258' AND id_product != '22784' AND ean13 != '' 26/07/2024 04:24:10 pm >> UPDATE ps_product SET id_supplier = '', reference = 'ESPOSITORE S. PAOLO', ean13 = '9788831526258', date_upd = NOW() WHERE id_product = '22784' 26/07/2024 04:24:10 pm >> UPDATE ps_product_lang SET name = 'ROSARIO CON PADRE PIO', description = '' WHERE id_product = '22784' 26/07/2024 04:24:10 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '1.5' WHERE id_product = '22784' 26/07/2024 04:24:10 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '1.5', id_tax_rules_group = '4', id_category_default = '27', id_argoment_default = '28', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22784' 26/07/2024 04:24:10 pm >> DELETE FROM ps_specific_price WHERE id_product = '22784' 26/07/2024 04:25:47 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '670839' , '2024-07-24' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '2.02' , '4' , '0' , '0' , '0' , '' , '11' , '0' , '70.49' , '70.49' , NOW() , NOW() ) 26/07/2024 04:25:47 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92739' 26/07/2024 04:25:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '92739' 26/07/2024 04:25:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92739' , '7442' , 'PANE QUOTIDIANO' , '1' , '1' , '4' , '3.90' , '3.9' , '0' , '30' , '2.7300' ) 26/07/2024 04:25:47 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7442' AND id_supplier = '7' 26/07/2024 04:25:47 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7442' , '7' , '1' ) 26/07/2024 04:25:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92739' , '22784' , 'ROSARIO CON PADRE PIO' , '48' , '48' , '4' , '1.50' , '1.5' , '0' , '33' , '48.2400' ) 26/07/2024 04:25:47 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22784' AND id_supplier = '7' 26/07/2024 04:25:47 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22784' , '7' , '1' ) 26/07/2024 04:25:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92739' , '22784' , 'ROSARIO CON PADRE PIO' , '4' , '4' , '4' , '1.50' , '1.5' , '0' , '100' , '0.0000' ) 26/07/2024 04:25:48 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22784' AND id_supplier = '7' 26/07/2024 04:25:48 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22784' , '7' , '1' ) 26/07/2024 04:25:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92739' , '19412' , 'FRANCESCO - COMMENTO AI VANGELI' , '1' , '1' , '4' , '25.00' , '25' , '0' , '30' , '17.5000' ) 26/07/2024 04:25:48 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19412' AND id_supplier = '7' 26/07/2024 04:25:48 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19412' , '7' , '1' ) 26/07/2024 04:48:51 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 26/07/2024 04:48:51 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22785' , '1' , '' , 'nuovo-prodotto' ) 26/07/2024 04:48:51 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '22785' , '1' , '1' , '2' , NOW() , NOW() ) 26/07/2024 04:48:51 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '22785' , '0' , '1' , '0' , '0' ) 26/07/2024 04:50:05 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892243903' AND id_product != '22785' AND ean13 != '' 26/07/2024 04:50:05 pm >> UPDATE ps_product SET id_supplier = '', reference = '6/3', ean13 = '9788892243903', date_upd = NOW() WHERE id_product = '22785' 26/07/2024 04:50:05 pm >> UPDATE ps_product_lang SET name = 'PIENA DI VITA - M. FUSARELLI', description = '' WHERE id_product = '22785' 26/07/2024 04:50:05 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '10' WHERE id_product = '22785' 26/07/2024 04:50:05 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '10', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '74', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22785' 26/07/2024 04:50:05 pm >> DELETE FROM ps_specific_price WHERE id_product = '22785' 26/07/2024 04:50:07 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22785' 26/07/2024 04:50:07 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22786' , '1' , '' , 'nuovo-prodotto' ) 26/07/2024 04:50:07 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22786' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22785' 26/07/2024 04:50:07 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22786' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22785' 26/07/2024 04:50:52 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892243149' AND id_product != '21713' AND ean13 != '' 26/07/2024 04:50:52 pm >> UPDATE ps_product SET id_supplier = '7', reference = '7/6', ean13 = '9788892243149', date_upd = NOW() WHERE id_product = '21713' 26/07/2024 04:50:52 pm >> UPDATE ps_product_lang SET name = 'FEDE SPERANZA E CARITA\' - R. CANTALAMESSA', description = '' WHERE id_product = '21713' 26/07/2024 04:50:52 pm >> UPDATE ps_product SET wholesale_price = '11.39', on_sale = '0', price = '19' WHERE id_product = '21713' 26/07/2024 04:50:52 pm >> UPDATE ps_product_shop SET wholesale_price = '11.39', price = '19', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '23', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21713' 26/07/2024 04:50:52 pm >> DELETE FROM ps_specific_price WHERE id_product = '21713' 26/07/2024 04:54:46 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788821579813' AND id_product != '1826' AND ean13 != '' 26/07/2024 04:54:46 pm >> UPDATE ps_product SET id_supplier = '', reference = '1/1', ean13 = '9788821579813', date_upd = NOW() WHERE id_product = '1826' 26/07/2024 04:54:46 pm >> UPDATE ps_product_lang SET name = 'CATECHISMO DELLA CHIESA CATTOLICA COMPENDIO', description = '' WHERE id_product = '1826' 26/07/2024 04:54:46 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '6.5000' WHERE id_product = '1826' 26/07/2024 04:54:46 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '6.5000', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '22', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '1826' 26/07/2024 04:54:46 pm >> DELETE FROM ps_specific_price WHERE id_product = '1826' 26/07/2024 04:59: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' , '670840' , '2024-07-24' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '54.74' , '4' , '0' , '0' , '0' , '' , '14' , '0' , '1411.69' , '1411.69' , NOW() , NOW() ) 26/07/2024 04:59: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 = '92740' 26/07/2024 04:59:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '92740' 26/07/2024 04:59: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 ( '92740' , '18289' , 'SANTA MESSA DEGLI SPOSI - N.E.' , '30' , '30' , '4' , '1.90' , '1.9' , '0' , '33+26' , '28.2606' ) 26/07/2024 04:59:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18289' AND id_supplier = '7' 26/07/2024 04:59:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18289' , '7' , '1' ) 26/07/2024 04:59: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 ( '92740' , '22698' , 'CALENDARIO LITURGICO 2025' , '150' , '150' , '4' , '0.80' , '0.8' , '0' , '33+26' , '59.4960' ) 26/07/2024 04:59:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22698' AND id_supplier = '7' 26/07/2024 04:59:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22698' , '7' , '1' ) 26/07/2024 04:59: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 ( '92740' , '6962' , 'NELLA CASA DEL DEFUNTO' , '5' , '5' , '4' , '1.50' , '1.5' , '0' , '33+26' , '3.7185' ) 26/07/2024 04:59:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6962' AND id_supplier = '7' 26/07/2024 04:59:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6962' , '7' , '1' ) 26/07/2024 04:59: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 ( '92740' , '22785' , 'PIENA DI VITA - M. FUSARELLI' , '1' , '1' , '4' , '10.00' , '10' , '0' , '33+26' , '4.9580' ) 26/07/2024 04:59:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22785' AND id_supplier = '7' 26/07/2024 04:59:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22785' , '7' , '1' ) 26/07/2024 04:59: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 ( '92740' , '21713' , 'FEDE SPERANZA E CARITA - R. CANTALAMESSA' , '1' , '1' , '4' , '19.00' , '19' , '0' , '33+26' , '9.4202' ) 26/07/2024 04:59:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21713' AND id_supplier = '7' 26/07/2024 04:59:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21713' , '7' , '1' ) 26/07/2024 04:59: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 ( '92740' , '1090' , 'BIBBIA' , '120' , '120' , '4' , '9.90' , '9.9' , '0' , '33+26' , '589.0104' ) 26/07/2024 04:59:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1090' AND id_supplier = '7' 26/07/2024 04:59:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1090' , '7' , '1' ) 26/07/2024 04:59: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 ( '92740' , '20655' , 'ARTE DELLA BUONA BATTAGLIA - F. ROSINI' , '2' , '2' , '4' , '18.00' , '18' , '0' , '33+26' , '17.8488' ) 26/07/2024 04:59:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20655' AND id_supplier = '7' 26/07/2024 04:59:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20655' , '7' , '1' ) 26/07/2024 04:59: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 ( '92740' , '17581' , 'MESSALE QUOTIDIANO N.E. ' , '5' , '5' , '4' , '39.00' , '39' , '0' , '33+26' , '96.6810' ) 26/07/2024 04:59:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17581' AND id_supplier = '7' 26/07/2024 04:59:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17581' , '7' , '1' ) 26/07/2024 04:59: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 ( '92740' , '20250' , 'PREGA MANGIA AMA - L. EPICOCO' , '2' , '2' , '4' , '16.00' , '16' , '0' , '33+26' , '15.8656' ) 26/07/2024 04:59:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20250' AND id_supplier = '7' 26/07/2024 04:59:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20250' , '7' , '1' ) 26/07/2024 04:59:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92740' , '16884' , 'ARTE DI GUARIRE - F. ROSINI' , '1' , '1' , '4' , '18.00' , '18' , '0' , '33+26' , '8.9244' ) 26/07/2024 04:59:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16884' AND id_supplier = '7' 26/07/2024 04:59:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16884' , '7' , '1' ) 26/07/2024 04:59:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92740' , '13432' , 'ARTE DI RICOMINCIARE - F. ROSINI' , '1' , '1' , '4' , '18.00' , '18' , '0' , '33+26' , '8.9244' ) 26/07/2024 04:59:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13432' AND id_supplier = '7' 26/07/2024 04:59:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13432' , '7' , '1' ) 26/07/2024 04:59:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92740' , '21668' , 'ALFABETO DI DIO - G. RAVASI' , '1' , '1' , '4' , '20.00' , '20' , '0' , '33+26' , '9.9160' ) 26/07/2024 04:59:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21668' AND id_supplier = '7' 26/07/2024 04:59:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21668' , '7' , '1' ) 26/07/2024 04:59:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92740' , '18298' , 'SAN GIUSEPPE - F. ROSINI' , '1' , '1' , '4' , '14.00' , '14' , '0' , '33+26' , '6.9412' ) 26/07/2024 04:59:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18298' AND id_supplier = '7' 26/07/2024 04:59:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18298' , '7' , '1' ) 26/07/2024 04:59:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92740' , '22129' , 'PADRE NOSTRO - L. EPICOCO' , '3' , '3' , '4' , '14.00' , '14' , '0' , '33+26' , '20.8236' ) 26/07/2024 04:59:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22129' AND id_supplier = '7' 26/07/2024 04:59:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22129' , '7' , '1' ) 26/07/2024 04:59:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92740' , '12995' , 'SALE, NON MIELE - L. EPICOCO' , '1' , '1' , '4' , '18.00' , '18' , '0' , '33+26' , '8.9244' ) 26/07/2024 04:59:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12995' AND id_supplier = '7' 26/07/2024 04:59:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12995' , '7' , '1' ) 26/07/2024 04:59:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92740' , '1826' , 'CATECHISMO DELLA CHIESA CATTOLICA COMPENDIO' , '4' , '4' , '4' , '6.50' , '6.5' , '0' , '33+26' , '12.8908' ) 26/07/2024 04:59:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1826' AND id_supplier = '7' 26/07/2024 04:59:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1826' , '7' , '1' ) 26/07/2024 04:59:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92740' , '1132' , 'BIBBIA DELLA PRIMA COMUNIONE - RIL' , '10' , '10' , '4' , '12.90' , '12.9' , '0' , '33+26' , '63.9582' ) 26/07/2024 04:59:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1132' AND id_supplier = '7' 26/07/2024 04:59:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1132' , '7' , '1' ) 26/07/2024 04:59:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92740' , '5929' , 'LODI E VESPRI' , '100' , '100' , '4' , '4.50' , '4.5' , '0' , '33+26' , '223.1100' ) 26/07/2024 04:59:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5929' AND id_supplier = '7' 26/07/2024 04:59:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5929' , '7' , '1' ) 26/07/2024 04:59:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92740' , '3528' , 'DIO VIVO E VERO - L. F. LADARIA' , '1' , '1' , '4' , '59.00' , '59' , '0' , '33+26' , '29.2522' ) 26/07/2024 04:59:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '3528' AND id_supplier = '7' 26/07/2024 04:59:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3528' , '7' , '1' ) 26/07/2024 04:59:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92740' , '17529' , 'NUOVO RITO DELLA MESSA' , '10' , '10' , '4' , '1.50' , '1.5' , '0' , '33+26' , '7.4370' ) 26/07/2024 04:59:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17529' AND id_supplier = '7' 26/07/2024 04:59:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17529' , '7' , '1' ) 26/07/2024 04:59:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92740' , '4487' , 'GESÙ NEL CUORE - ALBUM PRIMA COMUNIONE' , '1' , '1' , '4' , '12.90' , '12.9' , '0' , '35+24' , '6.3726' ) 26/07/2024 04:59:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4487' AND id_supplier = '7' 26/07/2024 04:59:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4487' , '7' , '1' ) 26/07/2024 04:59:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92740' , '17186' , 'MIA PRIMA COMUNIONE - ALBUM' , '1' , '1' , '4' , '14.90' , '14.9' , '0' , '35+24' , '7.3606' ) 26/07/2024 04:59:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17186' AND id_supplier = '7' 26/07/2024 04:59:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17186' , '7' , '1' ) 26/07/2024 04:59:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92740' , '15227' , 'ALBUM DELLA PRIMA COMUNIONE' , '1' , '1' , '4' , '12.90' , '12.9' , '0' , '35+24' , '6.3726' ) 26/07/2024 04:59:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15227' AND id_supplier = '7' 26/07/2024 04:59:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15227' , '7' , '1' ) 26/07/2024 04:59:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92740' , '16704' , 'BIBBIA RACCONTATA AI RAGAZZI' , '1' , '1' , '4' , '16.00' , '16' , '0' , '35+24' , '7.9040' ) 26/07/2024 04:59:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16704' AND id_supplier = '7' 26/07/2024 04:59:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16704' , '7' , '1' ) 26/07/2024 04:59:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92740' , '16702' , 'EVANGELIARIO' , '1' , '1' , '4' , '109.00' , '109' , '0' , '33+26' , '54.0422' ) 26/07/2024 04:59:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16702' AND id_supplier = '7' 26/07/2024 04:59:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16702' , '7' , '1' ) 26/07/2024 04:59:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92740' , '14000' , 'GALATEO IN CHIESA' , '10' , '10' , '4' , '1.00' , '1' , '0' , '33+26' , '4.9580' ) 26/07/2024 04:59:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14000' AND id_supplier = '7' 26/07/2024 04:59:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14000' , '7' , '1' ) 26/07/2024 04:59:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92740' , '1102' , 'BIBBIA BROSSURA OLANDESE' , '1' , '1' , '4' , '26.90' , '26.9' , '0' , '33+26' , '13.3370' ) 26/07/2024 04:59:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1102' AND id_supplier = '7' 26/07/2024 04:59:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1102' , '7' , '1' ) 26/07/2024 04:59:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92740' , '21185' , 'RIPORTARE I GIOVANI A MESSA - A. MATTEO' , '1' , '1' , '4' , '13.00' , '13' , '0' , '33+26' , '6.4454' ) 26/07/2024 04:59:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21185' AND id_supplier = '7' 26/07/2024 04:59:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21185' , '7' , '1' ) 26/07/2024 04:59:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92740' , '10914' , 'UNA COMUNITÀ LEGGE IL VANGELO DI GIOVANNI' , '1' , '1' , '4' , '48.00' , '48' , '0' , '33+26' , '23.7984' ) 26/07/2024 04:59:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '10914' AND id_supplier = '7' 26/07/2024 04:59:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10914' , '7' , '1' ) 26/07/2024 05:00:50 pm >> SELECT document_num FROM ps_document WHERE document_num = '2361' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-26') 26/07/2024 05:00: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' , '2361' , '2024-07-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '23.75' , '23.75' , NOW() , NOW() ) 26/07/2024 05:00: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 = '92741' 26/07/2024 05:00:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '92741' 26/07/2024 05:00: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 ( '92741' , '19412' , 'FRANCESCO - COMMENTO AI VANGELI' , '1' , '-1' , '4' , '25.00' , '25' , '0' , '5' , '23.75' ) 26/07/2024 05:01:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '2362' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-26') 26/07/2024 05: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' , '2362' , '2024-07-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '90.00' , '73.77' , NOW() , NOW() ) 26/07/2024 05: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 = '92742' 26/07/2024 05:01:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '92742' 26/07/2024 05:01:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92742' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3' , '2.4590163934426' , '22' , '0' , '90.00' ) 26/07/2024 05:51:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '2363' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-26') 26/07/2024 05:51:59 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2363' , '2024-07-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '23.00' , '18.85' , NOW() , NOW() ) 26/07/2024 05:51: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 = '92743' 26/07/2024 05:51:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '92743' 26/07/2024 05:51: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 ( '92743' , '1370' , 'BROCCHETTE RICAMBIO PER ART. 523 - 500' , '1' , '-1' , '1' , '14.00' , '11.475409836066' , '22' , '0' , '14.00' ) 26/07/2024 05:51: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 ( '92743' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '9' , '7.3770491803279' , '22' , '0' , '9.00' ) 26/07/2024 05:52:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '2364' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-26') 26/07/2024 05:52:22 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' , '2364' , '2024-07-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '110.00' , '90.16' , NOW() , NOW() ) 26/07/2024 05:52:22 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 = '92744' 26/07/2024 05:52:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '92744' 26/07/2024 05:52:22 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 ( '92744' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '110' , '90.16393442623' , '22' , '0' , '110.00' ) 26/07/2024 05:58:07 pm >> SELECT document_num FROM ps_document WHERE document_num = '2365' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-26') 26/07/2024 05:58:07 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' , '2365' , '2024-07-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '23.75' , '23.75' , NOW() , NOW() ) 26/07/2024 05:58:07 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 = '92745' 26/07/2024 05:58:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '92745' 26/07/2024 05:58:07 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 ( '92745' , '1114' , 'BIBBIA DEGLI SPOSI' , '1' , '-1' , '4' , '25.00' , '25' , '0' , '5' , '23.75' ) 26/07/2024 06:12:00 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788811111111111' AND id_product != '22786' AND ean13 != '' 26/07/2024 06:12:01 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788811111111111', date_upd = NOW() WHERE id_product = '22786' 26/07/2024 06:12:01 pm >> UPDATE ps_product_lang SET name = 'RASSEGNA STORICA SALERNITANA 81', description = '' WHERE id_product = '22786' 26/07/2024 06:12:01 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '20' WHERE id_product = '22786' 26/07/2024 06:12:01 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '20', id_tax_rules_group = '4', id_category_default = '509', id_argoment_default = '74', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22786' 26/07/2024 06:12:01 pm >> DELETE FROM ps_specific_price WHERE id_product = '22786' 26/07/2024 06:12:41 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22786' 26/07/2024 06:12:41 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22787' , '1' , '' , 'nuovo-prodotto' ) 26/07/2024 06:12:41 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22787' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22786' 26/07/2024 06:12:41 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22787' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22786' 26/07/2024 06:17:34 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788855252270' AND id_product != '22787' AND ean13 != '' 26/07/2024 06:17:34 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788855252270', date_upd = NOW() WHERE id_product = '22787' 26/07/2024 06:17:34 pm >> UPDATE ps_product_lang SET name = 'GIUSEPPE CASALE', description = '' WHERE id_product = '22787' 26/07/2024 06:17:34 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '25' WHERE id_product = '22787' 26/07/2024 06:17:34 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '25', id_tax_rules_group = '4', id_category_default = '509', id_argoment_default = '74', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22787' 26/07/2024 06:17:34 pm >> DELETE FROM ps_specific_price WHERE id_product = '22787' 26/07/2024 06:17:36 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22787' 26/07/2024 06:17:36 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22788' , '1' , '' , 'nuovo-prodotto' ) 26/07/2024 06:17:36 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22788' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22787' 26/07/2024 06:17:36 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22788' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22787' 26/07/2024 06:18:07 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788855252164' AND id_product != '22788' AND ean13 != '' 26/07/2024 06:18:07 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788855252164', date_upd = NOW() WHERE id_product = '22788' 26/07/2024 06:18:07 pm >> UPDATE ps_product_lang SET name = 'ALBERTA MARESCA', description = '' WHERE id_product = '22788' 26/07/2024 06:18:07 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '25' WHERE id_product = '22788' 26/07/2024 06:18:07 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '25', id_tax_rules_group = '4', id_category_default = '509', id_argoment_default = '74', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22788' 26/07/2024 06:18:07 pm >> DELETE FROM ps_specific_price WHERE id_product = '22788' 26/07/2024 06:18:53 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22788' 26/07/2024 06:18:53 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22789' , '1' , '' , 'nuovo-prodotto' ) 26/07/2024 06:18:53 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22789' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22788' 26/07/2024 06:18:54 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22789' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22788' 26/07/2024 06:19:16 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788855252133' AND id_product != '22789' AND ean13 != '' 26/07/2024 06:19:16 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788855252133', date_upd = NOW() WHERE id_product = '22789' 26/07/2024 06:19:17 pm >> UPDATE ps_product_lang SET name = 'GIUSEPPE CACCIATORE', description = '' WHERE id_product = '22789' 26/07/2024 06:19:17 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '12' WHERE id_product = '22789' 26/07/2024 06:19:17 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '12', id_tax_rules_group = '4', id_category_default = '509', id_argoment_default = '74', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22789' 26/07/2024 06:19:17 pm >> DELETE FROM ps_specific_price WHERE id_product = '22789' 26/07/2024 06:19:31 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22789' 26/07/2024 06:19:31 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22790' , '1' , '' , 'nuovo-prodotto' ) 26/07/2024 06:19:31 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22790' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22789' 26/07/2024 06:19:31 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22790' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22789' 26/07/2024 06:20:00 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788886884044' AND id_product != '22790' AND ean13 != '' 26/07/2024 06:20:00 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788886884044', date_upd = NOW() WHERE id_product = '22790' 26/07/2024 06:20:00 pm >> UPDATE ps_product_lang SET name = 'GRAS', description = '' WHERE id_product = '22790' 26/07/2024 06:20:00 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '15' WHERE id_product = '22790' 26/07/2024 06:20:00 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '15', id_tax_rules_group = '4', id_category_default = '509', id_argoment_default = '74', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22790' 26/07/2024 06:20:00 pm >> DELETE FROM ps_specific_price WHERE id_product = '22790' 26/07/2024 06:20:04 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788886884044' AND id_product != '22790' AND ean13 != '' 26/07/2024 06:20:04 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788886884044', date_upd = NOW() WHERE id_product = '22790' 26/07/2024 06:20:04 pm >> UPDATE ps_product_lang SET name = 'GRAS', description = '' WHERE id_product = '22790' 26/07/2024 06:20:04 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '15' WHERE id_product = '22790' 26/07/2024 06:20:04 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '15', id_tax_rules_group = '4', id_category_default = '509', id_argoment_default = '74', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22790' 26/07/2024 06:20:04 pm >> DELETE FROM ps_specific_price WHERE id_product = '22790' 26/07/2024 06:20:06 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22790' 26/07/2024 06:20:06 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22791' , '1' , '' , 'nuovo-prodotto' ) 26/07/2024 06:20:06 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22791' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22790' 26/07/2024 06:20:06 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22791' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22790' 26/07/2024 06:20:50 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22791' 26/07/2024 06:20:50 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22792' , '1' , '' , 'nuovo-prodotto' ) 26/07/2024 06:20:50 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22792' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22791' 26/07/2024 06:20:50 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22792' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22791' 26/07/2024 06:21:24 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788886884972' AND id_product != '22792' AND ean13 != '' 26/07/2024 06:21:24 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788886884972', date_upd = NOW() WHERE id_product = '22792' 26/07/2024 06:21:24 pm >> UPDATE ps_product_lang SET name = 'STUDIIS FLORENS', description = '' WHERE id_product = '22792' 26/07/2024 06:21:24 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '30' WHERE id_product = '22792' 26/07/2024 06:21:24 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '30', id_tax_rules_group = '4', id_category_default = '509', id_argoment_default = '74', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22792' 26/07/2024 06:21:24 pm >> DELETE FROM ps_specific_price WHERE id_product = '22792' 26/07/2024 06:21:25 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22792' 26/07/2024 06:21:25 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22793' , '1' , '' , 'nuovo-prodotto' ) 26/07/2024 06:21:25 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22793' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22792' 26/07/2024 06:21:25 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22793' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22792' 26/07/2024 06:22:11 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788886884774' AND id_product != '22793' AND ean13 != '' 26/07/2024 06:22:11 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788886884774', date_upd = NOW() WHERE id_product = '22793' 26/07/2024 06:22:11 pm >> UPDATE ps_product_lang SET name = 'RINVENIMENTI MONETALI', description = '' WHERE id_product = '22793' 26/07/2024 06:22:11 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '59' WHERE id_product = '22793' 26/07/2024 06:22:11 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '59', id_tax_rules_group = '4', id_category_default = '509', id_argoment_default = '74', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22793' 26/07/2024 06:22:11 pm >> DELETE FROM ps_specific_price WHERE id_product = '22793' 26/07/2024 06:22:12 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22793' 26/07/2024 06:22:12 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22794' , '1' , '' , 'nuovo-prodotto' ) 26/07/2024 06:22:12 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22794' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22793' 26/07/2024 06:22:12 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22794' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22793' 26/07/2024 06:23:07 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788886884514' AND id_product != '22794' AND ean13 != '' 26/07/2024 06:23:07 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788886884514', date_upd = NOW() WHERE id_product = '22794' 26/07/2024 06:23:07 pm >> UPDATE ps_product_lang SET name = 'PROFUMI NELLE SOCIETA\' ANTICHE', description = '' WHERE id_product = '22794' 26/07/2024 06:23:07 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '36' WHERE id_product = '22794' 26/07/2024 06:23:08 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '36', id_tax_rules_group = '4', id_category_default = '509', id_argoment_default = '74', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22794' 26/07/2024 06:23:08 pm >> DELETE FROM ps_specific_price WHERE id_product = '22794' 26/07/2024 06:23:09 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22794' 26/07/2024 06:23:09 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22795' , '1' , '' , 'nuovo-prodotto' ) 26/07/2024 06:23:09 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22795' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22794' 26/07/2024 06:23:09 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22795' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22794' 26/07/2024 06:23:40 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788886884254' AND id_product != '22795' AND ean13 != '' 26/07/2024 06:23:40 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788886884254', date_upd = NOW() WHERE id_product = '22795' 26/07/2024 06:23:40 pm >> UPDATE ps_product_lang SET name = 'LONGO', description = '' WHERE id_product = '22795' 26/07/2024 06:23:40 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '48' WHERE id_product = '22795' 26/07/2024 06:23:40 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '48', id_tax_rules_group = '4', id_category_default = '509', id_argoment_default = '74', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22795' 26/07/2024 06:23:40 pm >> DELETE FROM ps_specific_price WHERE id_product = '22795' 26/07/2024 06:23:41 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22795' 26/07/2024 06:23:41 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22796' , '1' , '' , 'nuovo-prodotto' ) 26/07/2024 06:23:41 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22796' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22795' 26/07/2024 06:23:41 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22796' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22795' 26/07/2024 06:24:25 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788886884017' AND id_product != '22795' AND ean13 != '' 26/07/2024 06:24:25 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788886884017', date_upd = NOW() WHERE id_product = '22795' 26/07/2024 06:24:25 pm >> UPDATE ps_product_lang SET name = 'POTRANDOLFO', description = '' WHERE id_product = '22795' 26/07/2024 06:24:26 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '26' WHERE id_product = '22795' 26/07/2024 06:24:26 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '26', id_tax_rules_group = '4', id_category_default = '509', id_argoment_default = '74', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22795' 26/07/2024 06:24:26 pm >> DELETE FROM ps_specific_price WHERE id_product = '22795' 26/07/2024 06:40:24 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22795' 26/07/2024 06:40:24 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22797' , '1' , '' , 'nuovo-prodotto' ) 26/07/2024 06:40:24 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22797' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22795' 26/07/2024 06:40:24 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22797' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22795' 26/07/2024 06:40:46 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788886884378' AND id_product != '22797' AND ean13 != '' 26/07/2024 06:40:46 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788886884378', date_upd = NOW() WHERE id_product = '22797' 26/07/2024 06:40:46 pm >> UPDATE ps_product_lang SET name = 'fratte', description = '' WHERE id_product = '22797' 26/07/2024 06:40:46 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '38' WHERE id_product = '22797' 26/07/2024 06:40:46 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '38', id_tax_rules_group = '4', id_category_default = '509', id_argoment_default = '74', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22797' 26/07/2024 06:40:46 pm >> DELETE FROM ps_specific_price WHERE id_product = '22797' 26/07/2024 06:40:51 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22797' 26/07/2024 06:40:51 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22798' , '1' , '' , 'nuovo-prodotto' ) 26/07/2024 06:40:51 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22798' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22797' 26/07/2024 06:40:51 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22798' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22797' 26/07/2024 06:41:11 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788886884378' AND id_product != '22797' AND ean13 != '' 26/07/2024 06:41:11 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788886884378', date_upd = NOW() WHERE id_product = '22797' 26/07/2024 06:41:12 pm >> UPDATE ps_product_lang SET name = 'FRATTE', description = '' WHERE id_product = '22797' 26/07/2024 06:41:12 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '38.0000' WHERE id_product = '22797' 26/07/2024 06:41:12 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '38.0000', id_tax_rules_group = '4', id_category_default = '509', id_argoment_default = '74', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22797' 26/07/2024 06:41:12 pm >> DELETE FROM ps_specific_price WHERE id_product = '22797' 26/07/2024 06:42:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '2366' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-26') 26/07/2024 06:42:15 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2366' , '2024-07-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.50' , '3.50' , NOW() , NOW() ) 26/07/2024 06:42:15 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92746' 26/07/2024 06:42:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '92746' 26/07/2024 06:42:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92746' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '5' , '-5' , '4' , '0.70' , '0.7' , '0' , '0' , '3.50' ) 26/07/2024 06:44:43 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788886884729' AND id_product != '22798' AND ean13 != '' 26/07/2024 06:44:43 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788886884729', date_upd = NOW() WHERE id_product = '22798' 26/07/2024 06:44:43 pm >> UPDATE ps_product_lang SET name = 'FRATTE LE TERRECOTTE', description = '' WHERE id_product = '22798' 26/07/2024 06:44:43 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '38' WHERE id_product = '22798' 26/07/2024 06:44:43 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '38', id_tax_rules_group = '4', id_category_default = '509', id_argoment_default = '74', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22798' 26/07/2024 06:44:43 pm >> DELETE FROM ps_specific_price WHERE id_product = '22798' 26/07/2024 06:44:52 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22798' 26/07/2024 06:44:52 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22799' , '1' , '' , 'nuovo-prodotto' ) 26/07/2024 06:44:52 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22799' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22798' 26/07/2024 06:44:52 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22799' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22798' 26/07/2024 06:45:38 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788886884025' AND id_product != '22799' AND ean13 != '' 26/07/2024 06:45:38 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788886884025', date_upd = NOW() WHERE id_product = '22799' 26/07/2024 06:45:38 pm >> UPDATE ps_product_lang SET name = 'CUOZZO', description = '' WHERE id_product = '22799' 26/07/2024 06:45:38 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '65' WHERE id_product = '22799' 26/07/2024 06:45:38 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '65', id_tax_rules_group = '4', id_category_default = '509', id_argoment_default = '74', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22799' 26/07/2024 06:45:38 pm >> DELETE FROM ps_specific_price WHERE id_product = '22799' 26/07/2024 06:46:00 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22799' 26/07/2024 06:46:00 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22800' , '1' , '' , 'nuovo-prodotto' ) 26/07/2024 06:46:00 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22800' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22799' 26/07/2024 06:46:00 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22800' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22799' 26/07/2024 06:46:35 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788886884941' AND id_product != '22800' AND ean13 != '' 26/07/2024 06:46:35 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788886884941', date_upd = NOW() WHERE id_product = '22800' 26/07/2024 06:46:35 pm >> UPDATE ps_product_lang SET name = 'DIALOGHI SULL\'ARCHEOLOGIA', description = '' WHERE id_product = '22800' 26/07/2024 06:46:35 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '120' WHERE id_product = '22800' 26/07/2024 06:46:35 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '120', id_tax_rules_group = '4', id_category_default = '509', id_argoment_default = '74', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22800' 26/07/2024 06:46:35 pm >> DELETE FROM ps_specific_price WHERE id_product = '22800' 26/07/2024 06:46:36 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22800' 26/07/2024 06:46:36 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22801' , '1' , '' , 'nuovo-prodotto' ) 26/07/2024 06:46:36 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22801' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22800' 26/07/2024 06:46:36 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22801' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22800' 26/07/2024 06:47:58 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788886884804' AND id_product != '22801' AND ean13 != '' 26/07/2024 06:47:58 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788886884804', date_upd = NOW() WHERE id_product = '22801' 26/07/2024 06:47:58 pm >> UPDATE ps_product_lang SET name = 'DIALOGHI SULL\'ARCHEOLOGIA II', description = '' WHERE id_product = '22801' 26/07/2024 06:47:58 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '180' WHERE id_product = '22801' 26/07/2024 06:47:58 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '180', id_tax_rules_group = '4', id_category_default = '509', id_argoment_default = '74', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22801' 26/07/2024 06:47:58 pm >> DELETE FROM ps_specific_price WHERE id_product = '22801' 26/07/2024 06:48:03 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22801' 26/07/2024 06:48:03 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22802' , '1' , '' , 'nuovo-prodotto' ) 26/07/2024 06:48:03 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22802' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22801' 26/07/2024 06:48:03 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22802' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22801' 26/07/2024 06:50:15 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788886884200' AND id_product != '22802' AND ean13 != '' 26/07/2024 06:50:15 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788886884200', date_upd = NOW() WHERE id_product = '22802' 26/07/2024 06:50:15 pm >> UPDATE ps_product_lang SET name = 'ETERNA CONTEMPORANEITA\'', description = '' WHERE id_product = '22802' 26/07/2024 06:50:15 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '150' WHERE id_product = '22802' 26/07/2024 06:50:15 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '150', id_tax_rules_group = '4', id_category_default = '509', id_argoment_default = '74', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22802' 26/07/2024 06:50:15 pm >> DELETE FROM ps_specific_price WHERE id_product = '22802' 26/07/2024 06:50: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 ( '31' , '33' , '2024-07-26' , '' , '0' , '188' , '4679306' , 'VIA CHIESA MADRE 25 84018 SCAFATI' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '532.20' , '532.20' , NOW() , NOW() ) 26/07/2024 06:50: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 = '92747' 26/07/2024 06:50:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '92747' 26/07/2024 06:50: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 ( '92747' , '22786' , 'RASSEGNA STORICA SALERNITANA 81' , '1' , '1' , '4' , '20.00' , '20' , '0' , '40' , '12.0000' ) 26/07/2024 06:50:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22786' AND id_supplier = '188' 26/07/2024 06:50:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22786' , '188' , '1' ) 26/07/2024 06:50: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 ( '92747' , '22787' , 'GIUSEPPE CASALE' , '1' , '1' , '4' , '25.00' , '25' , '0' , '40' , '15.0000' ) 26/07/2024 06:50:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22787' AND id_supplier = '188' 26/07/2024 06:50:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22787' , '188' , '1' ) 26/07/2024 06:50: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 ( '92747' , '22788' , 'ALBERTA MARESCA' , '1' , '1' , '4' , '25.00' , '25' , '0' , '40' , '15.0000' ) 26/07/2024 06:50:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22788' AND id_supplier = '188' 26/07/2024 06:50:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22788' , '188' , '1' ) 26/07/2024 06:50: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 ( '92747' , '22789' , 'GIUSEPPE CACCIATORE' , '1' , '1' , '4' , '12.00' , '12' , '0' , '40' , '7.2000' ) 26/07/2024 06:50:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22789' AND id_supplier = '188' 26/07/2024 06:50:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22789' , '188' , '1' ) 26/07/2024 06:50:35 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 ( '92747' , '22790' , 'GRAS' , '1' , '1' , '4' , '15.00' , '15' , '0' , '40' , '9.0000' ) 26/07/2024 06:50:35 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22790' AND id_supplier = '188' 26/07/2024 06:50:35 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22790' , '188' , '1' ) 26/07/2024 06:50:35 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 ( '92747' , '22792' , 'STUDIIS FLORENS' , '1' , '1' , '4' , '30.00' , '30' , '0' , '40' , '18.0000' ) 26/07/2024 06:50:35 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22792' AND id_supplier = '188' 26/07/2024 06:50:35 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22792' , '188' , '1' ) 26/07/2024 06:50:35 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 ( '92747' , '22793' , 'RINVENIMENTI MONETALI' , '1' , '1' , '4' , '59.00' , '59' , '0' , '40' , '35.4000' ) 26/07/2024 06:50:35 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22793' AND id_supplier = '188' 26/07/2024 06:50:35 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22793' , '188' , '1' ) 26/07/2024 06:50:35 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 ( '92747' , '22794' , 'PROFUMI NELLE SOCIETA ANTICHE' , '1' , '1' , '4' , '36.00' , '36' , '0' , '40' , '21.6000' ) 26/07/2024 06:50:35 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22794' AND id_supplier = '188' 26/07/2024 06:50:35 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22794' , '188' , '1' ) 26/07/2024 06:50:35 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 ( '92747' , '22795' , 'LONGO' , '1' , '1' , '4' , '48.00' , '48' , '0' , '40' , '28.8000' ) 26/07/2024 06:50:35 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22795' AND id_supplier = '188' 26/07/2024 06:50:35 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22795' , '188' , '1' ) 26/07/2024 06:50:35 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 ( '92747' , '22795' , 'POTRANDOLFO' , '1' , '1' , '4' , '26.00' , '26' , '0' , '40' , '15.6000' ) 26/07/2024 06:50:35 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22795' AND id_supplier = '188' 26/07/2024 06:50:35 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22795' , '188' , '1' ) 26/07/2024 06:50:35 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 ( '92747' , '22797' , 'FRATTE' , '1' , '1' , '4' , '38' , '38' , '0' , '40' , '22.8000' ) 26/07/2024 06:50:35 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22797' AND id_supplier = '188' 26/07/2024 06:50:35 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22797' , '188' , '1' ) 26/07/2024 06:50:35 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 ( '92747' , '22798' , 'FRATTE LE TERRECOTTE' , '1' , '1' , '4' , '38.00' , '38' , '0' , '40' , '22.8000' ) 26/07/2024 06:50:35 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22798' AND id_supplier = '188' 26/07/2024 06:50:35 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22798' , '188' , '1' ) 26/07/2024 06:50:35 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 ( '92747' , '22799' , 'CUOZZO' , '1' , '1' , '4' , '65.00' , '65' , '0' , '40' , '39.0000' ) 26/07/2024 06:50:35 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22799' AND id_supplier = '188' 26/07/2024 06:50:35 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22799' , '188' , '1' ) 26/07/2024 06:50:35 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 ( '92747' , '22800' , 'DIALOGHI SULL\'ARCHEOLOGIA' , '1' , '1' , '4' , '120.00' , '120' , '0' , '40' , '72.0000' ) 26/07/2024 06:50:35 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22800' AND id_supplier = '188' 26/07/2024 06:50:35 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22800' , '188' , '1' ) 26/07/2024 06:50:35 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 ( '92747' , '22801' , 'DIALOGHI SULLARCHEOLOGIA II' , '1' , '1' , '4' , '180.00' , '180' , '0' , '40' , '108.0000' ) 26/07/2024 06:50:35 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22801' AND id_supplier = '188' 26/07/2024 06:50:35 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22801' , '188' , '1' ) 26/07/2024 06:50:35 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 ( '92747' , '22802' , 'ETERNA CONTEMPORANEITA' , '1' , '1' , '4' , '150.00' , '150' , '0' , '40' , '90.0000' ) 26/07/2024 06:50:35 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22802' AND id_supplier = '188' 26/07/2024 06:50:35 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22802' , '188' , '1' ) 26/07/2024 06:53:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '2367' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-26') 26/07/2024 06:53:00 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2367' , '2024-07-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '35.00' , '35.00' , NOW() , NOW() ) 26/07/2024 06:53:00 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92748' 26/07/2024 06:53:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '92748' 26/07/2024 06:53:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92748' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '50' , '-50' , '4' , '0.70' , '0.7' , '0' , '0' , '35.00' ) 26/07/2024 06:57:25 pm >> SELECT document_num FROM ps_document WHERE document_num = '80/A' AND id_document != '92454' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-06-28') 26/07/2024 06:57:25 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '80/A', document_date = '2024-06-28', document_letter = 'A', id_customer = '3712', id_supplier = '', id_address = '4671443', address1 = 'VIA DALMAZIA 6 84121 SALERNO', 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 = '43.90', price_tax_excluded = '42.30', date_upd = NOW() WHERE id_document = '92454' 26/07/2024 06:57:25 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 = '92454' 26/07/2024 06:57:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '92454' 26/07/2024 06:57:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92454' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.9000' , '7.2950819672131' , '22' , '0' , '8.90' ) 26/07/2024 06:57:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92454' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '50' , '-50' , '4' , '0.70' , '0.7' , '0' , '0' , '35.00' )