19/05/2022 09:30:33 am >> SELECT document_num FROM ps_document WHERE document_num = '1583' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-19') 19/05/2022 09:30:33 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1583' , '2022-05-19' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.00' , '7.38' , NOW() , NOW() ) 19/05/2022 09:30:33 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '57843' 19/05/2022 09:30:33 am >> DELETE FROM ps_document_detail WHERE id_document = '57843' 19/05/2022 09:30:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '57843' , '11688' , 'CORONA ROSARIO MISERICORDIOSO - 740' , '2' , '-2' , '1' , '4.50' , '3.6885245901639' , '22' , '0' , '9.00' ) 19/05/2022 09:30:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '11688' AND id_supplier = '' 19/05/2022 09:30:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11688' , '' , '1' ) 19/05/2022 09:47:31 am >> SELECT document_num FROM ps_document WHERE document_num = '16/E' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-05-19') 19/05/2022 09:47:31 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '23' , '16/E' , '2022-05-19' , 'E' , '2938' , '0' , '4673025' , 'VIA ARCIVESCOVADO, 31 55100 LUCCA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '334.00' , '334.00' , NOW() , NOW() ) 19/05/2022 09:47:31 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '57844' 19/05/2022 09:47:31 am >> DELETE FROM ps_document_detail WHERE id_document = '57844' 19/05/2022 09:47:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '57844' , '18950' , 'DOV\'E\' FINITO IL CONCILIO? - F. CERRI' , '30' , '-30' , '4' , '18.00' , '18' , '0' , '40' , '324.00' ) 19/05/2022 09:47:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '57844' , '10133' , 'SPESE DI TRASPORTO' , '1' , '-1' , '4' , '10' , '10' , '0' , '0' , '10.00' ) 19/05/2022 10:45:26 am >> SELECT document_num FROM ps_document WHERE document_num = '1584' AND id_document != '' AND id_document_type LIKE '14' AND YEAR(document_date) = YEAR('2022-05-19') 19/05/2022 10:45: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' , '1584' , '2022-05-19' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.50' , '6.15' , NOW() , NOW() ) 19/05/2022 10:45: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 = '57845' 19/05/2022 10:45:26 am >> DELETE FROM ps_document_detail WHERE id_document = '57845' 19/05/2022 10:45: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 ( '57845' , '14247' , 'ROSARIO ULIVO OVALE CON SETA E CROCE SAN DAMIANO' , '5' , '-5' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '7.50' ) 19/05/2022 10:45:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '14247' AND id_supplier = '' 19/05/2022 10:45:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14247' , '' , '1' ) 19/05/2022 10:51:50 am >> SELECT document_num FROM ps_document WHERE document_num = '1585' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-19') 19/05/2022 10:51:50 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1585' , '2022-05-19' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '102.00' , '83.61' , NOW() , NOW() ) 19/05/2022 10:51:50 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '57846' 19/05/2022 10:51:50 am >> DELETE FROM ps_document_detail WHERE id_document = '57846' 19/05/2022 10:51:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '57846' , '8106' , 'POLO CELESTE - XL' , '1' , '-1' , '1' , '29.00' , '23.770491803279' , '22' , '0' , '29.00' ) 19/05/2022 10:51:50 am >> DELETE FROM ps_product_supplier WHERE id_product = '8106' AND id_supplier = '' 19/05/2022 10:51:50 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8106' , '' , '1' ) 19/05/2022 10:51:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '57846' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '33' , '27.049180327869' , '22' , '0' , '33.00' ) 19/05/2022 10:51:50 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 19/05/2022 10:51:50 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 19/05/2022 10:51:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '57846' , '18250' , 'CLERGY JEANS NIDO DAPE MM - XXL' , '1' , '-1' , '1' , '40.00' , '32.786885245902' , '22' , '0' , '40.00' ) 19/05/2022 10:51:50 am >> DELETE FROM ps_product_supplier WHERE id_product = '18250' AND id_supplier = '' 19/05/2022 10:51:50 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18250' , '' , '1' ) 19/05/2022 10:55:53 am >> SELECT document_num FROM ps_document WHERE document_num = '1586' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-19') 19/05/2022 10:55:53 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' , '1586' , '2022-05-19' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.00' , '8.20' , NOW() , NOW() ) 19/05/2022 10:55:53 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 = '57847' 19/05/2022 10:55:53 am >> DELETE FROM ps_document_detail WHERE id_document = '57847' 19/05/2022 10:55:53 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 ( '57847' , '14926' , 'VESTINA BATTESIMALE' , '2' , '-2' , '1' , '5.00' , '4.0983606557377' , '22' , '0' , '10.00' ) 19/05/2022 10:55:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '14926' AND id_supplier = '' 19/05/2022 10:55:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14926' , '' , '1' ) 19/05/2022 11:06:51 am >> SELECT document_num FROM ps_document WHERE document_num = '1587' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-19') 19/05/2022 11:06:51 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1587' , '2022-05-19' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.10' , '17.10' , NOW() , NOW() ) 19/05/2022 11:06:51 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '57848' 19/05/2022 11:06:51 am >> DELETE FROM ps_document_detail WHERE id_document = '57848' 19/05/2022 11:06:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '57848' , '10527' , 'TEMPO DI PREGHIERA' , '2' , '-2' , '4' , '9.00' , '9' , '0' , '5' , '17.10' ) 19/05/2022 11:06:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '10527' AND id_supplier = '' 19/05/2022 11:06:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10527' , '' , '1' ) 19/05/2022 11:12:32 am >> SELECT document_num FROM ps_document WHERE document_num = '1588' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-19') 19/05/2022 11:12:32 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1588' , '2022-05-19' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.00' , '19.00' , NOW() , NOW() ) 19/05/2022 11:12:32 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '57849' 19/05/2022 11:12:32 am >> DELETE FROM ps_document_detail WHERE id_document = '57849' 19/05/2022 11:12:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '57849' , '19467' , 'SULLA TUA PAROLA - LUG AGO 2022' , '4' , '-4' , '4' , '5.00' , '5' , '0' , '5' , '19.00' ) 19/05/2022 11:12:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '19467' AND id_supplier = '' 19/05/2022 11:12:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19467' , '' , '1' ) 19/05/2022 11:13:30 am >> SELECT document_num FROM ps_document WHERE document_num = '1503' AND id_document != '57234' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-12') 19/05/2022 11:13:30 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1503', document_date = '2022-05-12', 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 = '35.00', price_tax_excluded = '28.69', date_upd = NOW() WHERE id_document = '57234' 19/05/2022 11:13:30 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 = '57234' 19/05/2022 11:13:30 am >> DELETE FROM ps_document_detail WHERE id_document = '57234' 19/05/2022 11:13:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '57234' , '14621' , 'SANTA RITA BABY - 023 SR/9 BB' , '4' , '-4' , '1' , '8.00' , '6.5573770491803' , '22' , '0' , '32.00' ) 19/05/2022 11:13:31 am >> DELETE FROM ps_product_supplier WHERE id_product = '14621' AND id_supplier = '' 19/05/2022 11:13:31 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14621' , '' , '1' ) 19/05/2022 11:13:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '57234' , '18199' , 'QUADRETTO EFFETTO PIETRA SANTA RITA' , '1' , '-1' , '1' , '3' , '2.4590163934426' , '22' , '0' , '3.00' ) 19/05/2022 11:13:31 am >> DELETE FROM ps_product_supplier WHERE id_product = '18199' AND id_supplier = '' 19/05/2022 11:13:31 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18199' , '' , '1' ) 19/05/2022 11:14:02 am >> SELECT document_num FROM ps_document WHERE document_num = '1420' AND id_document != '56625' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-06') 19/05/2022 11:14:02 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1420', document_date = '2022-05-06', 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 = '3.90', price_tax_excluded = '3.20', date_upd = NOW() WHERE id_document = '56625' 19/05/2022 11:14:02 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 = '56625' 19/05/2022 11:14:02 am >> DELETE FROM ps_document_detail WHERE id_document = '56625' 19/05/2022 11:14:02 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 ( '56625' , '18199' , 'QUADRETTO EFFETTO PIETRA SANTA RITA' , '1' , '-1' , '1' , '3.7' , '3.0327868852459' , '22' , '0' , '3.70' ) 19/05/2022 11:14:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '18199' AND id_supplier = '' 19/05/2022 11:14:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18199' , '' , '1' ) 19/05/2022 11:14:02 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 ( '56625' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '1' , '-1' , '1' , '0.20' , '0.16393442622951' , '22' , '0' , '0.20' ) 19/05/2022 11:14:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '18617' AND id_supplier = '' 19/05/2022 11:14:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18617' , '' , '1' ) 19/05/2022 11:36:02 am >> SELECT document_num FROM ps_document WHERE document_num = '1589' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-19') 19/05/2022 11:36:02 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' , '1589' , '2022-05-19' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.00' , '0.82' , NOW() , NOW() ) 19/05/2022 11:36:02 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 = '57850' 19/05/2022 11:36:02 am >> DELETE FROM ps_document_detail WHERE id_document = '57850' 19/05/2022 11:36:02 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 ( '57850' , '17005' , 'BIGLIETTO AUGURALE medio' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 19/05/2022 11:36:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '17005' AND id_supplier = '' 19/05/2022 11:36:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17005' , '' , '1' ) 19/05/2022 11:41:28 am >> SELECT document_num FROM ps_document WHERE document_num = '1590' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-19') 19/05/2022 11:41:28 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1590' , '2022-05-19' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.00' , '4.92' , NOW() , NOW() ) 19/05/2022 11:41:28 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '57851' 19/05/2022 11:41:28 am >> DELETE FROM ps_document_detail WHERE id_document = '57851' 19/05/2022 11:41:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '57851' , '538' , 'AMPOLLA RICAMBIO PER ART. 501/5 - 70' , '1' , '-1' , '1' , '6.00' , '4.9180327868852' , '22' , '0' , '6.00' ) 19/05/2022 11:41:28 am >> DELETE FROM ps_product_supplier WHERE id_product = '538' AND id_supplier = '' 19/05/2022 11:41:28 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '538' , '' , '1' ) 19/05/2022 12:20:59 pm >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'BHWHcMMqQhYcHERJ' , NOW() , NOW() ) 19/05/2022 12:20:59 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '3884' , '1' ) 19/05/2022 12:20:59 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '3884' , '2' ) 19/05/2022 12:20:59 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '3884' , '3' ) 19/05/2022 12:25:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '1591' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-19') 19/05/2022 12:25:46 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' , '1591' , '2022-05-19' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '79.00' , '72.27' , NOW() , NOW() ) 19/05/2022 12:25:46 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '57852' 19/05/2022 12:25:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '57852' 19/05/2022 12:25:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '57852' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '10' , '-10' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '35.00' ) 19/05/2022 12:25:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 19/05/2022 12:25:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 19/05/2022 12:25:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '57852' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '10.00' ) 19/05/2022 12:25:47 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = '' 19/05/2022 12:25:47 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '' , '1' ) 19/05/2022 12: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 ( '57852' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '2' , '-2' , '3' , '4.00' , '3.8461538461538' , '4' , '0' , '8.00' ) 19/05/2022 12:25:47 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16691' AND id_supplier = '' 19/05/2022 12:25:47 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16691' , '' , '1' ) 19/05/2022 12: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 ( '57852' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '26' , '21.311475409836' , '22' , '0' , '26.00' ) 19/05/2022 12:25:47 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 19/05/2022 12:25:47 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 19/05/2022 12:27:41 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '1308' 19/05/2022 12:27:41 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '1308' , '10' , '160' , 'PARR. SANTA LUCIA V.M. ' , 'MANNA ' , 'DON NATALINO' , 'VIA MADONNA DI LORETO ' , '' , '03030' , 'CASTROCIELO' , '' , '' , '' , '' , '' , NOW() , NOW() ) 19/05/2022 12:27:41 pm >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '1308' 19/05/2022 12:38:50 pm >> SELECT document_num FROM ps_document WHERE document_num = '1592' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-19') 19/05/2022 12:38: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' , '1592' , '2022-05-19' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '147.50' , '120.90' , NOW() , NOW() ) 19/05/2022 12:38: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 = '57853' 19/05/2022 12:38:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '57853' 19/05/2022 12:38: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 ( '57853' , '19318' , 'ANGELO ALI TORTORA - 4230 ' , '3' , '-3' , '1' , '9.00' , '7.3770491803279' , '22' , '0' , '27.00' ) 19/05/2022 12:38:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19318' AND id_supplier = '' 19/05/2022 12:38:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19318' , '' , '1' ) 19/05/2022 12:38: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 ( '57853' , '7202' , 'ARTICOLI RELIGIOSI' , '4' , '-4' , '1' , '9' , '7.3770491803279' , '22' , '0' , '36.00' ) 19/05/2022 12:38:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 19/05/2022 12:38:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 19/05/2022 12:38: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 ( '57853' , '12042' , 'CROCE IN RESINA EFFETTO PIETRA - 2876/G52' , '23' , '-23' , '1' , '2.50' , '2.0491803278689' , '22' , '0' , '57.50' ) 19/05/2022 12:38:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12042' AND id_supplier = '' 19/05/2022 12:38:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12042' , '' , '1' ) 19/05/2022 12:38: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 ( '57853' , '7924' , 'PERGAMENE - BATTESIMO MOD. A' , '50' , '-50' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '25.00' ) 19/05/2022 12:38:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7924' AND id_supplier = '' 19/05/2022 12:38:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7924' , '' , '1' ) 19/05/2022 12:38: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 ( '57853' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '2' , '-2' , '1' , '1' , '0.81967213114754' , '22' , '0' , '2.00' ) 19/05/2022 12:38:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18122' AND id_supplier = '' 19/05/2022 12:38:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18122' , '' , '1' ) 19/05/2022 12:43:25 pm >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '12042' 19/05/2022 12:43:25 pm >> UPDATE ps_stock_available SET quantity = quantity + '-9' WHERE id_product = '12042' 19/05/2022 02:21:31 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884047632' AND id_product != '19467' AND ean13 != '' 19/05/2022 02:21:31 pm >> UPDATE ps_product SET id_supplier = '38', reference = '', ean13 = '9788884047632', date_upd = NOW() WHERE id_product = '19467' 19/05/2022 02:21:31 pm >> UPDATE ps_product_lang SET name = 'SULLA TUA PAROLA - LUG/AGO 2022', description = '' WHERE id_product = '19467' 19/05/2022 02:21:31 pm >> UPDATE ps_product SET wholesale_price = '3.00', on_sale = '0', price = '5.0000' WHERE id_product = '19467' 19/05/2022 02:21:31 pm >> UPDATE ps_product_shop SET wholesale_price = '3.00', price = '5.0000', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '64', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19467' 19/05/2022 02:21:31 pm >> DELETE FROM ps_specific_price WHERE id_product = '19467' 19/05/2022 02:42:48 pm >> SELECT document_num FROM ps_document WHERE document_num = '12/A' AND id_document != '51968' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-02-28') 19/05/2022 02:42:48 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '12/A', document_date = '2022-02-28', document_letter = 'A', id_customer = '204', id_supplier = '', id_address = '4671483', address1 = 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO', address2 = '', note = 'cappellania s. leonardo - ACCONTO € 50,00 02/05 + 100,00 + 180,00 11/05', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '158.20', price_tax_excluded = '133.64', date_upd = NOW() WHERE id_document = '51968' 19/05/2022 02:42:48 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 = '51968' 19/05/2022 02:42:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '51968' 19/05/2022 02:42: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 ( '51968' , '17402' , 'BRACCIALE ELASTICO ' , '6' , '-6' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '12.00' ) 19/05/2022 02:42:48 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17402' AND id_supplier = '' 19/05/2022 02:42:48 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17402' , '' , '1' ) 19/05/2022 02:42: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 ( '51968' , '14247' , 'ROSARIO ULIVO OVALE CON SETA E CROCE SAN DAMIANO' , '36' , '-36' , '1' , '1.3000' , '1.0655737704918' , '22' , '0' , '46.80' ) 19/05/2022 02:42:48 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14247' AND id_supplier = '' 19/05/2022 02:42:48 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14247' , '' , '1' ) 19/05/2022 02:42:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '51968' , '0' , 'sacro cuore' , '1' , '-1' , '1' , '39.0000' , '31.967213114754' , '22' , '0' , '39.00' ) 19/05/2022 02:42:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '' 19/05/2022 02:42:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' ) 19/05/2022 02:42:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '51968' , '0' , 'MIRACOLOSA' , '1' , '-1' , '0' , '12.0000' , '12' , '0' , '0' , '12.00' ) 19/05/2022 02:42:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '' 19/05/2022 02:42:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' ) 19/05/2022 02:42:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '51968' , '0' , 'SUPPLICA' , '1' , '-1' , '0' , '10.0000' , '10' , '0' , '0' , '10.00' ) 19/05/2022 02:42:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '' 19/05/2022 02:42:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' ) 19/05/2022 02:42:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '51968' , '9128' , 'ROSARIO LEGNO - RLE5896/5812' , '12' , '-12' , '1' , '1.2' , '0.98360655737705' , '22' , '0' , '14.40' ) 19/05/2022 02:42:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9128' AND id_supplier = '' 19/05/2022 02:42:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9128' , '' , '1' ) 19/05/2022 02:42:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '51968' , '6353' , 'MEDAGLIA S. BENEDETTO SMALTATA - M016' , '10' , '-10' , '1' , '1.10' , '0.9016393442623' , '22' , '0' , '11.00' ) 19/05/2022 02:42:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6353' AND id_supplier = '' 19/05/2022 02:42:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6353' , '' , '1' ) 19/05/2022 02:42:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '51968' , '1312' , 'BRACCIALE DECINA' , '10' , '-10' , '1' , '1.30' , '1.0655737704918' , '22' , '0' , '13.00' ) 19/05/2022 02:42:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1312' AND id_supplier = '' 19/05/2022 02:42:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1312' , '' , '1' ) 19/05/2022 04:54:49 pm >> SELECT document_num FROM ps_document WHERE document_num = '1593' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-19') 19/05/2022 04:54:49 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' , '1593' , '2022-05-19' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '45.00' , '36.89' , NOW() , NOW() ) 19/05/2022 04:54:49 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '57854' 19/05/2022 04:54:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '57854' 19/05/2022 04:54:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '57854' , '15529' , 'TUNICA 2 PIEGONI COLLO RISV. - PTA002B00' , '1' , '-1' , '1' , '45.00' , '36.885245901639' , '22' , '0' , '45.00' ) 19/05/2022 04:54:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15529' AND id_supplier = '' 19/05/2022 04:54:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15529' , '' , '1' ) 19/05/2022 04:59:25 pm >> SELECT document_num FROM ps_document WHERE document_num = '1594' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-19') 19/05/2022 04:59:25 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' , '1594' , '2022-05-19' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '60.00' , '49.18' , NOW() , NOW() ) 19/05/2022 04:59: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 = '57855' 19/05/2022 04:59:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '57855' 19/05/2022 04:59: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 ( '57855' , '16963' , 'PALLA IN S/MOIRE - 7988M' , '1' , '-1' , '1' , '60' , '49.180327868852' , '22' , '0' , '60.00' ) 19/05/2022 04:59:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16963' AND id_supplier = '' 19/05/2022 04:59:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16963' , '' , '1' ) 19/05/2022 05:33:06 pm >> DELETE FROM ps_product WHERE id_product = '688' 19/05/2022 05:33:06 pm >> DELETE FROM ps_product_shop WHERE id_product = '688' 19/05/2022 05:33:06 pm >> DELETE FROM ps_product_lang WHERE id_product = '688' 19/05/2022 05:33:06 pm >> DELETE FROM ps_stock_available WHERE id_product = '688' 19/05/2022 06:00:16 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788872982945' AND id_product != '18373' AND ean13 != '' 19/05/2022 06:00:16 pm >> UPDATE ps_product SET id_supplier = '7', reference = '8/1', ean13 = '9788872982945', date_upd = NOW() WHERE id_product = '18373' 19/05/2022 06:00:16 pm >> UPDATE ps_product_lang SET name = 'COMMENTI AI VANGELI - BENEDETTO XVI', description = '' WHERE id_product = '18373' 19/05/2022 06:00:16 pm >> UPDATE ps_product SET wholesale_price = '17.50', on_sale = '0', price = '25.0000' WHERE id_product = '18373' 19/05/2022 06:00:16 pm >> UPDATE ps_product_shop SET wholesale_price = '17.50', price = '25.0000', id_tax_rules_group = '4', id_category_default = '29', id_argoment_default = '20', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '18373' 19/05/2022 06:00:16 pm >> DELETE FROM ps_specific_price WHERE id_product = '18373' 19/05/2022 06:23:31 pm >> DELETE FROM ps_product WHERE id_product = '4865' 19/05/2022 06:23:31 pm >> DELETE FROM ps_product_shop WHERE id_product = '4865' 19/05/2022 06:23:31 pm >> DELETE FROM ps_product_lang WHERE id_product = '4865' 19/05/2022 06:23:31 pm >> DELETE FROM ps_stock_available WHERE id_product = '4865' 19/05/2022 06:52:37 pm >> SELECT document_num FROM ps_document WHERE document_num = '1595' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-19') 19/05/2022 06:52:38 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' , '1595' , '2022-05-19' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '52.50' , '50.39' , NOW() , NOW() ) 19/05/2022 06:52:38 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 = '57856' 19/05/2022 06:52:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '57856' 19/05/2022 06:52:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '57856' , '1319' , 'BRACCIALE DECINA TAU' , '1' , '-1' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '1.20' ) 19/05/2022 06:52:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1319' AND id_supplier = '' 19/05/2022 06:52:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1319' , '' , '1' ) 19/05/2022 06:52:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '57856' , '2766' , 'CORONA PLASTICA FOSFORO - 0100F' , '35' , '-35' , '1' , '0.3' , '0.24590163934426' , '22' , '0' , '10.50' ) 19/05/2022 06:52:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2766' AND id_supplier = '' 19/05/2022 06:52:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2766' , '' , '1' ) 19/05/2022 06:52:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '57856' , '11104' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. RAGAZZI' , '30' , '-30' , '4' , '1.36' , '1.36' , '0' , '0' , '40.80' ) 19/05/2022 06:52:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11104' AND id_supplier = '' 19/05/2022 06:52:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11104' , '' , '1' ) 19/05/2022 07:31:25 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788895983851' AND id_product != '18528' AND ean13 != '' 19/05/2022 07:31:25 pm >> UPDATE ps_product SET id_supplier = '53', reference = '', ean13 = '9788895983851', date_upd = NOW() WHERE id_product = '18528' 19/05/2022 07:31:25 pm >> UPDATE ps_product_lang SET name = 'CON GESU\' VERSO IL CALVARIO - P. G. VALSECCHI', description = '

Ripercorrendo le stazioni della Via Crucis, accompagnando Gesù fino al Calvario, noi cerchiamo di comprendere, per quanto possibile, la grandezza del suo amore. Un amore che deve diventare il nostro programma di vita.

' WHERE id_product = '18528' 19/05/2022 07:31:26 pm >> UPDATE ps_product SET wholesale_price = '0.18', on_sale = '0', price = '1.5000' WHERE id_product = '18528' 19/05/2022 07:31:26 pm >> UPDATE ps_product_shop SET wholesale_price = '0.18', price = '1.5000', id_tax_rules_group = '4', id_category_default = '395', id_argoment_default = '28', id_internal_category = '4', on_sale = '0', on_showcase = '1', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '18528' 19/05/2022 07:31:26 pm >> DELETE FROM ps_specific_price WHERE id_product = '18528' 19/05/2022 07:31:26 pm >> INSERT INTO ps_specific_price ( id_specific_price_rule , id_cart , id_product , id_shop , id_shop_group , id_currency , id_country , id_group , id_customer , id_product_attribute , price , from_quantity , reduction , reduction_tax , reduction_type , `from` , `to`) VALUES ( '0' , '0' , '18528' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' )