18/03/2024 09:03:55 am >> SELECT document_num FROM ps_document WHERE document_num = '787' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-18') 18/03/2024 09:03:55 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '787' , '2024-03-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '158.00' , '129.51' , NOW() , NOW() ) 18/03/2024 09:03:55 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90801' 18/03/2024 09:03:55 am >> DELETE FROM ps_document_detail WHERE id_document = '90801' 18/03/2024 09:03:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90801' , '15210' , 'CERO PASQUALE API 80X120' , '1' , '-1' , '1' , '140' , '114.75409836066' , '22' , '0' , '140.00' ) 18/03/2024 09:03:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90801' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '18' , '14.754098360656' , '22' , '0' , '18.00' ) 18/03/2024 09:23:31 am >> SELECT document_num FROM ps_document WHERE document_num = '788' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-18') 18/03/2024 09:23: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 ( '11' , '788' , '2024-03-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.00' , '9.02' , NOW() , NOW() ) 18/03/2024 09:23: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 = '90802' 18/03/2024 09:23:31 am >> DELETE FROM ps_document_detail WHERE id_document = '90802' 18/03/2024 09:23: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 ( '90802' , '1427' , 'BUSTE PER PALMA BENEDETTA - PZ 200 ' , '1' , '-1' , '1' , '11.00' , '9.016393442623' , '22' , '0' , '11.00' ) 18/03/2024 09:26:32 am >> SELECT document_num FROM ps_document WHERE document_num = '789' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-18') 18/03/2024 09:26: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' , '789' , '2024-03-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '16.00' , '13.11' , NOW() , NOW() ) 18/03/2024 09:26: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 = '90803' 18/03/2024 09:26:32 am >> DELETE FROM ps_document_detail WHERE id_document = '90803' 18/03/2024 09:26: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 ( '90803' , '17883' , 'CROCE MOGANO CORPO MET CM 28- 169M' , '1' , '-1' , '1' , '16.00' , '13.114754098361' , '22' , '0' , '16.00' ) 18/03/2024 10:10:38 am >> SELECT document_num FROM ps_document WHERE document_num = '790' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-18') 18/03/2024 10:10:38 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' , '790' , '2024-03-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '18.00' , '14.75' , NOW() , NOW() ) 18/03/2024 10:10:38 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90804' 18/03/2024 10:10:38 am >> DELETE FROM ps_document_detail WHERE id_document = '90804' 18/03/2024 10:10:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90804' , '1912' , 'CERA DELL\'EREMO - 415/B ' , '3' , '-3' , '1' , '6.00' , '4.9180327868852' , '22' , '0' , '18.00' ) 18/03/2024 10:44:53 am >> SELECT document_num FROM ps_document WHERE document_num = '791' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-18') 18/03/2024 10:44: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' , '791' , '2024-03-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '47.40' , '38.85' , NOW() , NOW() ) 18/03/2024 10:44: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 = '90805' 18/03/2024 10:44:53 am >> DELETE FROM ps_document_detail WHERE id_document = '90805' 18/03/2024 10:44: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 ( '90805' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '6' , '-6' , '1' , '7.90' , '6.4754098360656' , '22' , '0' , '47.40' ) 18/03/2024 10:45:15 am >> SELECT document_num FROM ps_document WHERE document_num = '792' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-18') 18/03/2024 10:45:15 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' , '792' , '2024-03-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.80' , '3.11' , NOW() , NOW() ) 18/03/2024 10:45:15 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 = '90806' 18/03/2024 10:45:15 am >> DELETE FROM ps_document_detail WHERE id_document = '90806' 18/03/2024 10:45:15 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 ( '90806' , '18276' , 'CINGOLO CON NODI - 3280' , '1' , '-1' , '1' , '2.50' , '2.0491803278689' , '22' , '0' , '2.50' ) 18/03/2024 10:45:15 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 ( '90806' , '3073' , 'CROCE PRIMA COMUNIONE - LEGNO SCURO - 713/15' , '1' , '-1' , '1' , '1.30' , '1.0655737704918' , '22' , '0' , '1.30' ) 18/03/2024 10:53:22 am >> SELECT document_num FROM ps_document WHERE document_num = '791' AND id_document != '90805' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-18') 18/03/2024 10:53:22 am >> UPDATE ps_document SET id_document_type = '11', document_num = '791', document_date = '2024-03-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 = '47.40', price_tax_excluded = '38.85', date_upd = NOW() WHERE id_document = '90805' 18/03/2024 10:53:22 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 = '90805' 18/03/2024 10:53:22 am >> DELETE FROM ps_document_detail WHERE id_document = '90805' 18/03/2024 10:53:22 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 ( '90805' , '11756' , 'VINO BIANCO SECCO - 14%' , '7' , '-7' , '1' , '6.5' , '5.327868852459' , '22' , '0' , '45.50' ) 18/03/2024 10:53:22 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 ( '90805' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '1.9' , '1.5573770491803' , '22' , '0' , '1.90' ) 18/03/2024 11:04:04 am >> SELECT document_num FROM ps_document WHERE document_num = '793' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-18') 18/03/2024 11:04:05 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' , '793' , '2024-03-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '164.00' , '134.43' , NOW() , NOW() ) 18/03/2024 11:04:05 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 = '90807' 18/03/2024 11:04:05 am >> DELETE FROM ps_document_detail WHERE id_document = '90807' 18/03/2024 11:04:05 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 ( '90807' , '15210' , 'CERO PASQUALE API 80X120' , '1' , '-1' , '1' , '120' , '98.360655737705' , '22' , '0' , '120.00' ) 18/03/2024 11:04:05 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 ( '90807' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '2' , '-2' , '1' , '22' , '18.032786885246' , '22' , '0' , '44.00' ) 18/03/2024 11:15:22 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 ( '33' , '659300' , '2024-03-14' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '2.12' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '75.71' , '75.71' , NOW() , NOW() ) 18/03/2024 11:15:22 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 = '90808' 18/03/2024 11:15:22 am >> DELETE FROM ps_document_detail WHERE id_document = '90808' 18/03/2024 11:15:22 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 ( '90808' , '16884' , 'ARTE DI GUARIRE - F. ROSINI' , '1' , '1' , '4' , '18.00' , '18' , '0' , '33' , '12.0600' ) 18/03/2024 11:15:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '16884' AND id_supplier = '7' 18/03/2024 11:15:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16884' , '7' , '1' ) 18/03/2024 11:15:22 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 ( '90808' , '19638' , 'STORIA DI CARLO ACUTIS' , '1' , '1' , '4' , '1.90' , '1.9' , '0' , '30' , '1.3300' ) 18/03/2024 11:15:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '19638' AND id_supplier = '7' 18/03/2024 11:15:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19638' , '7' , '1' ) 18/03/2024 11:15:22 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 ( '90808' , '22227' , 'MALE NEGLI OCCHI DELLAMORE - G. BORGHI' , '1' , '1' , '4' , '14.00' , '14' , '0' , '30' , '9.8000' ) 18/03/2024 11:15:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '22227' AND id_supplier = '7' 18/03/2024 11:15:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22227' , '7' , '1' ) 18/03/2024 11:15:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90808' , '22270' , 'QUESTA E LA NOSTRA FEDE - AAVV' , '1' , '1' , '4' , '36.00' , '36' , '0' , '30' , '25.2000' ) 18/03/2024 11:15:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '22270' AND id_supplier = '7' 18/03/2024 11:15:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22270' , '7' , '1' ) 18/03/2024 11:15:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90808' , '22169' , 'PIANTO DEL CRISTO - F. SHEEN' , '2' , '2' , '4' , '18.00' , '18' , '0' , '30' , '25.2000' ) 18/03/2024 11:15:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '22169' AND id_supplier = '7' 18/03/2024 11:15:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22169' , '7' , '1' ) 18/03/2024 11:35:15 am >> SELECT document_num FROM ps_document WHERE document_num = '794' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-18') 18/03/2024 11:35:15 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' , '794' , '2024-03-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '27.55' , '27.55' , NOW() , NOW() ) 18/03/2024 11:35:15 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 = '90809' 18/03/2024 11:35:15 am >> DELETE FROM ps_document_detail WHERE id_document = '90809' 18/03/2024 11:35:15 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 ( '90809' , '21149' , 'MEDJUGORJE - RACCOLTA MESSAGGI - 8104' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 18/03/2024 11:35:15 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 ( '90809' , '20886' , 'VIAGGIO NEL CIELO DELLANIMA CON TERESA DAVILA - R. TAVELLI' , '1' , '-1' , '4' , '17.00' , '17' , '0' , '5' , '16.15' ) 18/03/2024 11:43:06 am >> SELECT document_num FROM ps_document WHERE document_num = '795' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-18') 18/03/2024 11:43:06 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' , '795' , '2024-03-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.00' , '10.66' , NOW() , NOW() ) 18/03/2024 11:43:06 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 = '90810' 18/03/2024 11:43:06 am >> DELETE FROM ps_document_detail WHERE id_document = '90810' 18/03/2024 11:43:06 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 ( '90810' , '17938' , 'SAN GIUSEPPE - ARS 119' , '100' , '-100' , '1' , '0.13' , '0.10655737704918' , '22' , '0' , '13.00' ) 18/03/2024 11:51:41 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 18/03/2024 11:51:41 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22293' , '1' , '' , 'nuovo-prodotto' ) 18/03/2024 11:51:41 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '22293' , '1' , '1' , '2' , NOW() , NOW() ) 18/03/2024 11:51:41 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '22293' , '0' , '1' , '0' , '0' ) 18/03/2024 11:55:35 am >> SELECT document_num FROM ps_document WHERE document_num = '56' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-03-18') 18/03/2024 11:55:35 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 ( '21' , '56' , '2024-03-18' , '' , '161' , '0' , '161' , 'VIA G. MAZZINI VICO III, 8 81047 MACERATA CAMPANIA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '205.10' , '205.10' , NOW() , NOW() ) 18/03/2024 11:55:35 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 = '90811' 18/03/2024 11:55:35 am >> DELETE FROM ps_document_detail WHERE id_document = '90811' 18/03/2024 11:55:35 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 ( '90811' , '21697' , 'ORME SUL CUORE - A. ROMANO' , '9' , '-9' , '4' , '12.00' , '12' , '0' , '5' , '102.60' ) 18/03/2024 11:55:35 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 ( '90811' , '21847' , 'UNDICESIMO: SALVA LA TESTA! - P. PELLEGRINO' , '30' , '-30' , '4' , '3.00' , '3' , '0' , '5' , '85.50' ) 18/03/2024 11:55:35 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 ( '90811' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '20' , '-20' , '4' , '1.00' , '1' , '0' , '15' , '17.00' ) 18/03/2024 12:05:26 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '30-642' AND id_product != '22293' AND ean13 != '' 18/03/2024 12:05:26 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '30-642', date_upd = NOW() WHERE id_product = '22293' 18/03/2024 12:05:27 pm >> UPDATE ps_product_lang SET name = 'RELIQUIARIO CM 25 ', description = '' WHERE id_product = '22293' 18/03/2024 12:05:27 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '110.65573770491804' WHERE id_product = '22293' 18/03/2024 12:05:27 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '110.65573770491804', id_tax_rules_group = '1', id_category_default = '2', 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 = '22293' 18/03/2024 12:05:27 pm >> DELETE FROM ps_specific_price WHERE id_product = '22293' 18/03/2024 12:05:30 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 = '22293' 18/03/2024 12:05:30 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22294' , '1' , '' , 'nuovo-prodotto' ) 18/03/2024 12:05:30 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 '22294' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22293' 18/03/2024 12:05:30 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22294' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22293' 18/03/2024 12:06:13 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '30-650' AND id_product != '18901' AND ean13 != '' 18/03/2024 12:06:13 pm >> UPDATE ps_product SET id_supplier = '86', reference = '', ean13 = '30-650', date_upd = NOW() WHERE id_product = '18901' 18/03/2024 12:06:13 pm >> UPDATE ps_product_lang SET name = 'RELIQUIARIO CM 22', description = '' WHERE id_product = '18901' 18/03/2024 12:06:13 pm >> UPDATE ps_product SET wholesale_price = '47.82', on_sale = '0', price = '110.65573770491804' WHERE id_product = '18901' 18/03/2024 12:06:13 pm >> UPDATE ps_product_shop SET wholesale_price = '47.82', price = '110.65573770491804', id_tax_rules_group = '1', id_category_default = '394', 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 = '18901' 18/03/2024 12:06:13 pm >> DELETE FROM ps_specific_price WHERE id_product = '18901' 18/03/2024 12:10:23 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '30-532' AND id_product != '22294' AND ean13 != '' 18/03/2024 12:10:23 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '30-532', date_upd = NOW() WHERE id_product = '22294' 18/03/2024 12:10:23 pm >> UPDATE ps_product_lang SET name = 'RELIQUIARIO CON PIETRE CM 32', description = '' WHERE id_product = '22294' 18/03/2024 12:10:23 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '162.29508196721312' WHERE id_product = '22294' 18/03/2024 12:10:23 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '162.29508196721312', id_tax_rules_group = '1', id_category_default = '394', 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 = '22294' 18/03/2024 12:10:23 pm >> DELETE FROM ps_specific_price WHERE id_product = '22294' 18/03/2024 12:10: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 = '22294' 18/03/2024 12:10:24 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22295' , '1' , '' , 'nuovo-prodotto' ) 18/03/2024 12:10: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 '22295' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22294' 18/03/2024 12:10:24 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22295' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22294' 18/03/2024 12:11:38 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '10-220M' AND id_product != '22295' AND ean13 != '' 18/03/2024 12:11:38 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '10-220M', date_upd = NOW() WHERE id_product = '22295' 18/03/2024 12:11:38 pm >> UPDATE ps_product_lang SET name = 'RELIQUIARIO DORATO CM 32', description = '' WHERE id_product = '22295' 18/03/2024 12:11:38 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '162.29508196721312' WHERE id_product = '22295' 18/03/2024 12:11:38 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '162.29508196721312', id_tax_rules_group = '1', id_category_default = '394', 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 = '22295' 18/03/2024 12:11:38 pm >> DELETE FROM ps_specific_price WHERE id_product = '22295' 18/03/2024 12:11:39 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 = '22295' 18/03/2024 12:11:39 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22296' , '1' , '' , 'nuovo-prodotto' ) 18/03/2024 12:11:39 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 '22296' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22295' 18/03/2024 12:11:39 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22296' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22295' 18/03/2024 12:13:23 pm >> SELECT document_num FROM ps_document WHERE document_num = '796' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-18') 18/03/2024 12:13:23 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' , '796' , '2024-03-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '26.60' , '26.60' , NOW() , NOW() ) 18/03/2024 12:13:23 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 = '90812' 18/03/2024 12:13:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '90812' 18/03/2024 12:13:23 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 ( '90812' , '22206' , 'GESU E SE FOSSE TUTTO VERO? - A. COMASTRI' , '1' , '-1' , '4' , '28.00' , '28' , '0' , '5' , '26.60' ) 18/03/2024 12:16:48 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '30-783' AND id_product != '22296' AND ean13 != '' 18/03/2024 12:16:48 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '30-783', date_upd = NOW() WHERE id_product = '22296' 18/03/2024 12:16:48 pm >> UPDATE ps_product_lang SET name = 'RELIQUIARI TASCABILE CM 3,5', description = '' WHERE id_product = '22296' 18/03/2024 12:16:48 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '6.967213114754099' WHERE id_product = '22296' 18/03/2024 12:16:48 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '6.967213114754099', id_tax_rules_group = '1', id_category_default = '394', 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 = '22296' 18/03/2024 12:16:48 pm >> DELETE FROM ps_specific_price WHERE id_product = '22296' 18/03/2024 12:16:49 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 = '22296' 18/03/2024 12:16:50 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22297' , '1' , '' , 'nuovo-prodotto' ) 18/03/2024 12:16: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 '22297' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22296' 18/03/2024 12:16:50 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22297' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22296' 18/03/2024 12:17:49 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '10-167' AND id_product != '22297' AND ean13 != '' 18/03/2024 12:17:49 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '10-167', date_upd = NOW() WHERE id_product = '22297' 18/03/2024 12:17:49 pm >> UPDATE ps_product_lang SET name = 'RELIQUIARIO DORATO CM 20', description = '' WHERE id_product = '22297' 18/03/2024 12:17:49 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '130.327868852459' WHERE id_product = '22297' 18/03/2024 12:17:49 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '130.327868852459', id_tax_rules_group = '1', id_category_default = '394', 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 = '22297' 18/03/2024 12:17:49 pm >> DELETE FROM ps_specific_price WHERE id_product = '22297' 18/03/2024 12:18:12 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '10-167' AND id_product != '22297' AND ean13 != '' 18/03/2024 12:18:12 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '10-167', date_upd = NOW() WHERE id_product = '22297' 18/03/2024 12:18:12 pm >> UPDATE ps_product_lang SET name = 'RELIQUIARIO DORATO CM 20', description = '' WHERE id_product = '22297' 18/03/2024 12:18:12 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '130.327868852459' WHERE id_product = '22297' 18/03/2024 12:18:12 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '130.327868852459', id_tax_rules_group = '1', id_category_default = '394', 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 = '22297' 18/03/2024 12:18:12 pm >> DELETE FROM ps_specific_price WHERE id_product = '22297' 18/03/2024 12:18:13 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 = '22297' 18/03/2024 12:18:13 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22298' , '1' , '' , 'nuovo-prodotto' ) 18/03/2024 12:18:13 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 '22298' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22297' 18/03/2024 12:18:13 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22298' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22297' 18/03/2024 12:20:53 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '10-218M' AND id_product != '22298' AND ean13 != '' 18/03/2024 12:20:53 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '10-218M', date_upd = NOW() WHERE id_product = '22298' 18/03/2024 12:20:53 pm >> UPDATE ps_product_lang SET name = 'RELIQUIARIODORATO CON PIETRE CM 23', description = '' WHERE id_product = '22298' 18/03/2024 12:20:53 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '118.85245901639344' WHERE id_product = '22298' 18/03/2024 12:20:53 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '118.85245901639344', id_tax_rules_group = '1', id_category_default = '394', 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 = '22298' 18/03/2024 12:20:53 pm >> DELETE FROM ps_specific_price WHERE id_product = '22298' 18/03/2024 12:20:54 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 = '22298' 18/03/2024 12:20:54 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22299' , '1' , '' , 'nuovo-prodotto' ) 18/03/2024 12:20:54 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 '22299' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22298' 18/03/2024 12:20:54 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22299' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22298' 18/03/2024 12:23:20 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '12-750' AND id_product != '22299' AND ean13 != '' 18/03/2024 12:23:20 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '12-750', date_upd = NOW() WHERE id_product = '22299' 18/03/2024 12:23:20 pm >> UPDATE ps_product_lang SET name = 'BRUCIA INCENSO PADELLA CM 17', description = '' WHERE id_product = '22299' 18/03/2024 12:23:20 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '15.573770491803279' WHERE id_product = '22299' 18/03/2024 12:23:20 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '15.573770491803279', id_tax_rules_group = '1', id_category_default = '394', 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 = '22299' 18/03/2024 12:23:20 pm >> DELETE FROM ps_specific_price WHERE id_product = '22299' 18/03/2024 12:23:52 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '12-750' AND id_product != '22299' AND ean13 != '' 18/03/2024 12:23:52 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '12-750', date_upd = NOW() WHERE id_product = '22299' 18/03/2024 12:23:52 pm >> UPDATE ps_product_lang SET name = 'BRUCIA INCENSO PADELLA CM 17', description = '' WHERE id_product = '22299' 18/03/2024 12:23:52 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '15.573770491803279' WHERE id_product = '22299' 18/03/2024 12:23:52 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '15.573770491803279', id_tax_rules_group = '1', id_category_default = '394', 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 = '22299' 18/03/2024 12:23:52 pm >> DELETE FROM ps_specific_price WHERE id_product = '22299' 18/03/2024 12:23: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 = '22299' 18/03/2024 12:23:53 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22300' , '1' , '' , 'nuovo-prodotto' ) 18/03/2024 12:23: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 '22300' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22299' 18/03/2024 12:23:53 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22300' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22299' 18/03/2024 12:26:43 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '12-703' AND id_product != '22300' AND ean13 != '' 18/03/2024 12:26:43 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '12-703', date_upd = NOW() WHERE id_product = '22300' 18/03/2024 12:26:43 pm >> UPDATE ps_product_lang SET name = 'BRUCIA INCENSO NIKEL CM 8', description = '' WHERE id_product = '22300' 18/03/2024 12:26:43 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '11.475409836065573' WHERE id_product = '22300' 18/03/2024 12:26:43 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '11.475409836065573', id_tax_rules_group = '1', id_category_default = '394', 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 = '22300' 18/03/2024 12:26:43 pm >> DELETE FROM ps_specific_price WHERE id_product = '22300' 18/03/2024 12:26:44 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 = '22300' 18/03/2024 12:26:44 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22301' , '1' , '' , 'nuovo-prodotto' ) 18/03/2024 12:26:44 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 '22301' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22300' 18/03/2024 12:26:44 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22301' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22300' 18/03/2024 12:28:06 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '12-100' AND id_product != '12613' AND ean13 != '' 18/03/2024 12:28:06 pm >> UPDATE ps_product SET id_supplier = '86', reference = '', ean13 = '12-100', date_upd = NOW() WHERE id_product = '12613' 18/03/2024 12:28:06 pm >> UPDATE ps_product_lang SET name = 'TURIBOLO 10 CM', description = '' WHERE id_product = '12613' 18/03/2024 12:28:06 pm >> UPDATE ps_product SET wholesale_price = '5.49', on_sale = '0', price = '13.114754098360656' WHERE id_product = '12613' 18/03/2024 12:28:06 pm >> UPDATE ps_product_shop SET wholesale_price = '5.49', price = '13.114754098360656', id_tax_rules_group = '1', id_category_default = '394', 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 = '12613' 18/03/2024 12:28:06 pm >> DELETE FROM ps_specific_price WHERE id_product = '12613' 18/03/2024 12:42:42 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '32-737' AND id_product != '22301' AND ean13 != '' 18/03/2024 12:42:42 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '32-737', date_upd = NOW() WHERE id_product = '22301' 18/03/2024 12:42:42 pm >> UPDATE ps_product_lang SET name = 'BRUCIA INCENSO REGOLABILE CM 11', description = '' WHERE id_product = '22301' 18/03/2024 12:42:42 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '15.98360655737705' WHERE id_product = '22301' 18/03/2024 12:42:42 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '15.98360655737705', id_tax_rules_group = '1', id_category_default = '394', 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 = '22301' 18/03/2024 12:42:42 pm >> DELETE FROM ps_specific_price WHERE id_product = '22301' 18/03/2024 12:42:44 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 = '22301' 18/03/2024 12:42:45 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22302' , '1' , '' , 'nuovo-prodotto' ) 18/03/2024 12:42:45 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 '22302' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22301' 18/03/2024 12:42:45 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22302' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22301' 18/03/2024 12:44:21 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '10-521' AND id_product != '22302' AND ean13 != '' 18/03/2024 12:44:21 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '10-521', date_upd = NOW() WHERE id_product = '22302' 18/03/2024 12:44:21 pm >> UPDATE ps_product_lang SET name = 'BRUCIA INCENSOB CM 11 REGOLABILE', description = '' WHERE id_product = '22302' 18/03/2024 12:44:21 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '13.524590163934427' WHERE id_product = '22302' 18/03/2024 12:44:21 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '13.524590163934427', id_tax_rules_group = '1', id_category_default = '394', 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 = '22302' 18/03/2024 12:44:21 pm >> DELETE FROM ps_specific_price WHERE id_product = '22302' 18/03/2024 12:44:22 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 = '22302' 18/03/2024 12:44:22 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22303' , '1' , '' , 'nuovo-prodotto' ) 18/03/2024 12:44:22 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 '22303' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22302' 18/03/2024 12:44:22 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22303' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22302' 18/03/2024 12:45:16 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '2024-00736' , '2024-03-14' , '' , '0' , '86' , '2723' , 'WEIDACHSTRABE, 6 85609 ASCHHEIM - GERMANIA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '492.14' , '492.14' , NOW() , NOW() ) 18/03/2024 12:45: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 = '90813' 18/03/2024 12:45:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '90813' 18/03/2024 12:45:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90813' , '22293' , 'RELIQUIARIO CM 25 ' , '1' , '1' , '0' , '52.6' , '52.6' , '' , '0' , '52.6000' ) 18/03/2024 12:45:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22293' AND id_supplier = '86' 18/03/2024 12:45:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22293' , '86' , '1' ) 18/03/2024 12:45:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90813' , '18901' , 'RELIQUIARIO CM 22' , '1' , '1' , '0' , '52.6' , '52.6' , '' , '0' , '52.6000' ) 18/03/2024 12:45:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18901' AND id_supplier = '86' 18/03/2024 12:45:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18901' , '86' , '1' ) 18/03/2024 12:45:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90813' , '22294' , 'RELIQUIARIO CON PIETRE CM 32' , '1' , '1' , '0' , '79.51' , '79.51' , '' , '0' , '79.5100' ) 18/03/2024 12:45:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22294' AND id_supplier = '86' 18/03/2024 12:45:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22294' , '86' , '1' ) 18/03/2024 12:45:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90813' , '22295' , 'RELIQUIARIO DORATO CM 32' , '1' , '1' , '0' , '79.51' , '79.51' , '' , '0' , '79.5100' ) 18/03/2024 12:45:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22295' AND id_supplier = '86' 18/03/2024 12:45:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22295' , '86' , '1' ) 18/03/2024 12:45:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90813' , '22296' , 'RELIQUIARI TASCABILE CM 3,5' , '4' , '4' , '0' , '3.2' , '3.2' , '' , '0' , '12.8000' ) 18/03/2024 12:45:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22296' AND id_supplier = '86' 18/03/2024 12:45:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22296' , '86' , '1' ) 18/03/2024 12:45:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90813' , '22297' , 'RELIQUIARIO DORATO CM 20' , '1' , '1' , '0' , '63.38' , '63.38' , '' , '0' , '63.3800' ) 18/03/2024 12:45:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22297' AND id_supplier = '86' 18/03/2024 12:45:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22297' , '86' , '1' ) 18/03/2024 12:45:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90813' , '22298' , 'RELIQUIARIODORATO CON PIETRE CM 23' , '1' , '1' , '0' , '56.47' , '56.47' , '' , '0' , '56.4700' ) 18/03/2024 12:45:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22298' AND id_supplier = '86' 18/03/2024 12:45:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22298' , '86' , '1' ) 18/03/2024 12:45:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90813' , '22299' , 'BRUCIA INCENSO PADELLA CM 17' , '2' , '2' , '0' , '6.73' , '6.73' , '' , '0' , '13.4600' ) 18/03/2024 12:45:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22299' AND id_supplier = '86' 18/03/2024 12:45:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22299' , '86' , '1' ) 18/03/2024 12:45:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90813' , '20824' , 'BRUCIA INCENSO CM 14' , '2' , '2' , '0' , '9.68' , '9.68' , '' , '0' , '19.3600' ) 18/03/2024 12:45:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20824' AND id_supplier = '86' 18/03/2024 12:45:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20824' , '86' , '1' ) 18/03/2024 12:45:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90813' , '22300' , 'BRUCIA INCENSO NIKEL CM 8' , '2' , '2' , '0' , '5.19' , '5.19' , '' , '0' , '10.3800' ) 18/03/2024 12:45:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22300' AND id_supplier = '86' 18/03/2024 12:45:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22300' , '86' , '1' ) 18/03/2024 12:45: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 ( '90813' , '12613' , 'TURIBOLO 10 CM' , '6' , '6' , '0' , '5.53' , '5.53' , '' , '0' , '33.1800' ) 18/03/2024 12:45:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12613' AND id_supplier = '86' 18/03/2024 12:45:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12613' , '86' , '1' ) 18/03/2024 12:45: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 ( '90813' , '22301' , 'BRUCIA INCENSO REGOLABILE CM 11' , '1' , '1' , '0' , '7.15' , '7.15' , '' , '0' , '7.1500' ) 18/03/2024 12:45:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22301' AND id_supplier = '86' 18/03/2024 12:45:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22301' , '86' , '1' ) 18/03/2024 12:45: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 ( '90813' , '22302' , 'BRUCIA INCENSOB CM 11 REGOLABILE' , '2' , '2' , '0' , '5.87' , '5.87' , '' , '0' , '11.7400' ) 18/03/2024 12:45:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22302' AND id_supplier = '86' 18/03/2024 12:45:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22302' , '86' , '1' ) 18/03/2024 02:42:26 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '10-521' AND id_product != '22302' AND ean13 != '' 18/03/2024 02:42:26 pm >> UPDATE ps_product SET id_supplier = '86', reference = '', ean13 = '10-521', date_upd = NOW() WHERE id_product = '22302' 18/03/2024 02:42:26 pm >> UPDATE ps_product_lang SET name = 'BRUCIA INCENSO CM 11 REGOLABILE', description = '' WHERE id_product = '22302' 18/03/2024 02:42:26 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '13.5246' WHERE id_product = '22302' 18/03/2024 02:42:26 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '13.5246', id_tax_rules_group = '1', id_category_default = '394', 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 = '22302' 18/03/2024 02:42:26 pm >> DELETE FROM ps_specific_price WHERE id_product = '22302' 18/03/2024 02:43:41 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '32-706' AND id_product != '18905' AND ean13 != '' 18/03/2024 02:43:41 pm >> UPDATE ps_product SET id_supplier = '86', reference = '', ean13 = '32-706', date_upd = NOW() WHERE id_product = '18905' 18/03/2024 02:43:41 pm >> UPDATE ps_product_lang SET name = 'PORTA TURIBOLO CM 147', description = '' WHERE id_product = '18905' 18/03/2024 02:43:41 pm >> UPDATE ps_product SET wholesale_price = '134.99', on_sale = '0', price = '290.9836065573771' WHERE id_product = '18905' 18/03/2024 02:43:41 pm >> UPDATE ps_product_shop SET wholesale_price = '134.99', price = '290.9836065573771', id_tax_rules_group = '1', id_category_default = '394', 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 = '18905' 18/03/2024 02:43:41 pm >> DELETE FROM ps_specific_price WHERE id_product = '18905' 18/03/2024 02:45:28 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '12-259' AND id_product != '18902' AND ean13 != '' 18/03/2024 02:45:28 pm >> UPDATE ps_product SET id_supplier = '86', reference = '', ean13 = '12-259', date_upd = NOW() WHERE id_product = '18902' 18/03/2024 02:45:28 pm >> UPDATE ps_product_lang SET name = 'TURIBOLO CM 24', description = '' WHERE id_product = '18902' 18/03/2024 02:45:28 pm >> UPDATE ps_product SET wholesale_price = '59.40', on_sale = '0', price = '135.24590163934425' WHERE id_product = '18902' 18/03/2024 02:45:28 pm >> UPDATE ps_product_shop SET wholesale_price = '59.40', price = '135.24590163934425', id_tax_rules_group = '1', id_category_default = '394', 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 = '18902' 18/03/2024 02:45:28 pm >> DELETE FROM ps_specific_price WHERE id_product = '18902' 18/03/2024 02:47:40 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '12-024S' AND id_product != '22303' AND ean13 != '' 18/03/2024 02:47:40 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '12-024S', date_upd = NOW() WHERE id_product = '22303' 18/03/2024 02:47:40 pm >> UPDATE ps_product_lang SET name = 'TURIBOLO PLACCATO ARG. CM 26', description = '' WHERE id_product = '22303' 18/03/2024 02:47:40 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '102.45901639344262' WHERE id_product = '22303' 18/03/2024 02:47:40 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '102.45901639344262', id_tax_rules_group = '1', id_category_default = '394', 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 = '22303' 18/03/2024 02:47:40 pm >> DELETE FROM ps_specific_price WHERE id_product = '22303' 18/03/2024 02:47: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 = '22303' 18/03/2024 02:47:41 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22304' , '1' , '' , 'nuovo-prodotto' ) 18/03/2024 02:47: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 '22304' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22303' 18/03/2024 02:47:41 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22304' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22303' 18/03/2024 02:49:14 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '12-952' AND id_product != '22304' AND ean13 != '' 18/03/2024 02:49:14 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '12-952', date_upd = NOW() WHERE id_product = '22304' 18/03/2024 02:49:15 pm >> UPDATE ps_product_lang SET name = 'TURIBOLO PLACCATO ARG. CM 17', description = '' WHERE id_product = '22304' 18/03/2024 02:49:15 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '57.37704918032787' WHERE id_product = '22304' 18/03/2024 02:49:15 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '57.37704918032787', id_tax_rules_group = '1', id_category_default = '394', 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 = '22304' 18/03/2024 02:49:15 pm >> DELETE FROM ps_specific_price WHERE id_product = '22304' 18/03/2024 02:49:15 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 = '22304' 18/03/2024 02:49:16 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22305' , '1' , '' , 'nuovo-prodotto' ) 18/03/2024 02:49:16 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 '22305' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22304' 18/03/2024 02:49:16 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22305' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22304' 18/03/2024 02:50:58 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '12-779' AND id_product != '22305' AND ean13 != '' 18/03/2024 02:50:58 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '12-779', date_upd = NOW() WHERE id_product = '22305' 18/03/2024 02:50:58 pm >> UPDATE ps_product_lang SET name = 'NASVETTA CM 13', description = '' WHERE id_product = '22305' 18/03/2024 02:50:58 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '20.491803278688526' WHERE id_product = '22305' 18/03/2024 02:50:58 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '20.491803278688526', id_tax_rules_group = '1', id_category_default = '394', 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 = '22305' 18/03/2024 02:50:58 pm >> DELETE FROM ps_specific_price WHERE id_product = '22305' 18/03/2024 02:50:59 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 = '22305' 18/03/2024 02:50:59 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22306' , '1' , '' , 'nuovo-prodotto' ) 18/03/2024 02:50:59 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 '22306' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22305' 18/03/2024 02:50:59 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22306' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22305' 18/03/2024 02:52:18 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '10-747' AND id_product != '22306' AND ean13 != '' 18/03/2024 02:52:18 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '10-747', date_upd = NOW() WHERE id_product = '22306' 18/03/2024 02:52:18 pm >> UPDATE ps_product_lang SET name = 'TURIBOLO CM 24', description = '' WHERE id_product = '22306' 18/03/2024 02:52:18 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '131.14754098360655' WHERE id_product = '22306' 18/03/2024 02:52:18 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '131.14754098360655', id_tax_rules_group = '1', id_category_default = '394', 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 = '22306' 18/03/2024 02:52:18 pm >> DELETE FROM ps_specific_price WHERE id_product = '22306' 18/03/2024 02:53:06 pm >> UPDATE ps_document SET id_document_type = '31', document_num = '2024-00736', document_date = '2024-03-14', document_letter = '', id_customer = '0', id_supplier = '', id_address = '2723', address1 = 'WEIDACHSTRABE, 6 85609 ASCHHEIM - GERMANIA', address2 = '', note = '', price_shipping = '53.7', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '9', id_causal = '0', price_tax_included = '926.65', price_tax_excluded = '926.65', date_upd = NOW() WHERE id_document = '90813' 18/03/2024 02:53:06 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 = '90813' 18/03/2024 02:53:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '90813' 18/03/2024 02:53:06 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 ( '90813' , '22293' , 'RELIQUIARIO CM 25 ' , '1' , '1' , '0' , '52.6000' , '52.6' , '0' , '0' , '52.60' ) 18/03/2024 02:53:06 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 ( '90813' , '18901' , 'RELIQUIARIO CM 22' , '1' , '1' , '0' , '52.6000' , '52.6' , '0' , '0' , '52.60' ) 18/03/2024 02:53:06 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 ( '90813' , '22294' , 'RELIQUIARIO CON PIETRE CM 32' , '1' , '1' , '0' , '79.5100' , '79.51' , '0' , '0' , '79.51' ) 18/03/2024 02:53: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 ( '90813' , '22295' , 'RELIQUIARIO DORATO CM 32' , '1' , '1' , '0' , '79.5100' , '79.51' , '0' , '0' , '79.51' ) 18/03/2024 02:53: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 ( '90813' , '22296' , 'RELIQUIARI TASCABILE CM 3,5' , '4' , '4' , '0' , '3.2000' , '3.2' , '0' , '0' , '12.80' ) 18/03/2024 02:53: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 ( '90813' , '22297' , 'RELIQUIARIO DORATO CM 20' , '1' , '1' , '0' , '63.3800' , '63.38' , '0' , '0' , '63.38' ) 18/03/2024 02:53: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 ( '90813' , '22298' , 'RELIQUIARIODORATO CON PIETRE CM 23' , '1' , '1' , '0' , '56.4700' , '56.47' , '0' , '0' , '56.47' ) 18/03/2024 02:53: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 ( '90813' , '22299' , 'BRUCIA INCENSO PADELLA CM 17' , '2' , '2' , '0' , '6.7300' , '6.73' , '0' , '0' , '13.46' ) 18/03/2024 02:53: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 ( '90813' , '20824' , 'BRUCIA INCENSO CM 14' , '2' , '2' , '0' , '9.6800' , '9.68' , '0' , '0' , '19.36' ) 18/03/2024 02:53: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 ( '90813' , '22300' , 'BRUCIA INCENSO NIKEL CM 8' , '2' , '2' , '0' , '5.1900' , '5.19' , '0' , '0' , '10.38' ) 18/03/2024 02:53: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 ( '90813' , '12613' , 'TURIBOLO 10 CM' , '6' , '6' , '0' , '5.5300' , '5.53' , '0' , '0' , '33.18' ) 18/03/2024 02:53: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 ( '90813' , '22301' , 'BRUCIA INCENSO REGOLABILE CM 11' , '1' , '1' , '0' , '7.1500' , '7.15' , '0' , '0' , '7.15' ) 18/03/2024 02:53: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 ( '90813' , '22302' , 'BRUCIA INCENSOB CM 11 REGOLABILE' , '2' , '2' , '0' , '5.8700' , '5.87' , '0' , '0' , '11.74' ) 18/03/2024 02:53: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 ( '90813' , '18905' , 'PORTA TURIBOLO CM 147' , '1' , '1' , '0' , '139.17' , '139.17' , '' , '0' , '139.1700' ) 18/03/2024 02:53: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 ( '90813' , '12238' , 'NAVETTA CLASSICA H13 CM' , '2' , '2' , '0' , '18.1' , '18.1' , '' , '0' , '36.2000' ) 18/03/2024 02:53: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 ( '90813' , '18902' , 'TURIBOLO CM 24' , '1' , '1' , '0' , '63.38' , '63.38' , '' , '0' , '63.3800' ) 18/03/2024 02:53: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 ( '90813' , '22303' , 'TURIBOLO PLACCATO ARG. CM 26' , '1' , '1' , '0' , '48.39' , '48.39' , '' , '0' , '48.3900' ) 18/03/2024 02:53: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 ( '90813' , '22304' , 'TURIBOLO PLACCATO ARG. CM 17' , '1' , '1' , '0' , '23.62' , '23.62' , '' , '0' , '23.6200' ) 18/03/2024 02:53: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 ( '90813' , '22305' , 'NASVETTA CM 13' , '1' , '1' , '0' , '9.09' , '9.09' , '' , '0' , '9.0900' ) 18/03/2024 02:53: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 ( '90813' , '22306' , 'TURIBOLO CM 24' , '1' , '1' , '0' , '60.96' , '60.96' , '' , '0' , '60.9600' ) 18/03/2024 02:56:33 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '132' , '2024-03-18' , '' , '0' , '60' , '2655' , 'Z.I. PIANE MAVONE 64042 COLLEDARA' , '' , '' , '22' , '1' , '0' , '0' , '0' , '' , '0' , '0' , '514.84' , '422.00' , NOW() , NOW() ) 18/03/2024 02:56:33 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90814' 18/03/2024 02:56:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '90814' 18/03/2024 02:56:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90814' , '20516' , 'CROCE COMUNIONE - 42/08' , '1000' , '1000' , '1' , '0.4' , '0.32786885245902' , '22' , '0' , '488.0000' ) 18/03/2024 02:56:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20516' AND id_supplier = '60' 18/03/2024 02:56:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20516' , '60' , '1' ) 18/03/2024 02:57:41 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '10-219M' AND id_product != '18164' AND ean13 != '' 18/03/2024 02:57:41 pm >> UPDATE ps_product SET id_supplier = '86', reference = '', ean13 = '10-219M', date_upd = NOW() WHERE id_product = '18164' 18/03/2024 02:57:41 pm >> UPDATE ps_product_lang SET name = 'RELIQUIARIO H 28', description = '' WHERE id_product = '18164' 18/03/2024 02:57:41 pm >> UPDATE ps_product SET wholesale_price = '70.43', on_sale = '0', price = '154.9180' WHERE id_product = '18164' 18/03/2024 02:57:41 pm >> UPDATE ps_product_shop SET wholesale_price = '70.43', price = '154.9180', id_tax_rules_group = '1', id_category_default = '394', 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 = '18164' 18/03/2024 02:57:41 pm >> DELETE FROM ps_specific_price WHERE id_product = '18164' 18/03/2024 02:57:47 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '10-219M' AND id_product != '18164' AND ean13 != '' 18/03/2024 02:57:47 pm >> UPDATE ps_product SET id_supplier = '86', reference = '', ean13 = '10-219M', date_upd = NOW() WHERE id_product = '18164' 18/03/2024 02:57:47 pm >> UPDATE ps_product_lang SET name = 'RELIQUIARIO H 28', description = '' WHERE id_product = '18164' 18/03/2024 02:57:47 pm >> UPDATE ps_product SET wholesale_price = '70.43', on_sale = '0', price = '159.8360655737705' WHERE id_product = '18164' 18/03/2024 02:57:47 pm >> UPDATE ps_product_shop SET wholesale_price = '70.43', price = '159.8360655737705', id_tax_rules_group = '1', id_category_default = '394', 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 = '18164' 18/03/2024 02:57:47 pm >> DELETE FROM ps_specific_price WHERE id_product = '18164' 18/03/2024 03:05:16 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '10-219M' AND id_product != '18164' AND ean13 != '' 18/03/2024 03:05:16 pm >> UPDATE ps_product SET id_supplier = '86', reference = '', ean13 = '10-219M', date_upd = NOW() WHERE id_product = '18164' 18/03/2024 03:05:16 pm >> UPDATE ps_product_lang SET name = 'RELIQUIARIO H 28', description = '' WHERE id_product = '18164' 18/03/2024 03:05:16 pm >> UPDATE ps_product SET wholesale_price = '70.43', on_sale = '0', price = '159.8360655737705' WHERE id_product = '18164' 18/03/2024 03:05:16 pm >> UPDATE ps_product_shop SET wholesale_price = '70.43', price = '159.8360655737705', id_tax_rules_group = '1', id_category_default = '394', 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 = '18164' 18/03/2024 03:05:16 pm >> DELETE FROM ps_specific_price WHERE id_product = '18164' 18/03/2024 04:35:29 pm >> SELECT document_num FROM ps_document WHERE document_num = '797' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-18') 18/03/2024 04:35:29 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' , '797' , '2024-03-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '21.20' , '17.38' , NOW() , NOW() ) 18/03/2024 04:35:29 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 = '90815' 18/03/2024 04:35:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '90815' 18/03/2024 04:35:29 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 ( '90815' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '8.5' , '6.9672131147541' , '22' , '0' , '8.50' ) 18/03/2024 04:35:29 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 ( '90815' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '6.9' , '5.655737704918' , '22' , '0' , '6.90' ) 18/03/2024 04:35:29 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 ( '90815' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '5.8' , '4.7540983606557' , '22' , '0' , '5.80' ) 18/03/2024 04:48:12 pm >> SELECT document_num FROM ps_document WHERE document_num = '798' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-18') 18/03/2024 04:48:12 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' , '798' , '2024-03-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '20.40' , '16.72' , NOW() , NOW() ) 18/03/2024 04:48:12 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 = '90816' 18/03/2024 04:48:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '90816' 18/03/2024 04:48:12 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 ( '90816' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '2' , '-2' , '1' , '7.90' , '6.4754098360656' , '22' , '0' , '15.80' ) 18/03/2024 04:48:12 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 ( '90816' , '17276' , 'CONFEZIONE COLLANINA CON MIRACOLOSA E STRASS - 1911' , '1' , '-1' , '1' , '4.60' , '3.7704918032787' , '22' , '0' , '4.60' ) 18/03/2024 05:21:07 pm >> SELECT document_num FROM ps_document WHERE document_num = '799' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-18') 18/03/2024 05:21: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' , '799' , '2024-03-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '105.00' , '86.07' , NOW() , NOW() ) 18/03/2024 05:21: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 = '90817' 18/03/2024 05:21:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '90817' 18/03/2024 05:21: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 ( '90817' , '19790' , 'STOLA IN MISTO LANA - 666' , '1' , '-1' , '1' , '105.00' , '86.065573770492' , '22' , '0' , '105.00' ) 18/03/2024 05:24:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '800' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-18') 18/03/2024 05:24: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' , '800' , '2024-03-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.00' , '9.84' , NOW() , NOW() ) 18/03/2024 05:24: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 = '90818' 18/03/2024 05:24:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '90818' 18/03/2024 05:24: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 ( '90818' , '19596' , 'MEDAGLIA SAN BENEDETTO ARG. RA630' , '1' , '-1' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '12.00' ) 18/03/2024 05:35:52 pm >> SELECT document_num FROM ps_document WHERE document_num = '801' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-18') 18/03/2024 05:35:52 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '801' , '2024-03-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '220.00' , '180.33' , NOW() , NOW() ) 18/03/2024 05:35:52 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90819' 18/03/2024 05:35:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '90819' 18/03/2024 05:35: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 ( '90819' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3' , '2.4590163934426' , '22' , '0' , '90.00' ) 18/03/2024 05:35: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 ( '90819' , '1425' , 'BUSTA 100 FLAMBEAUX IN CARTA - FLAM' , '2' , '-2' , '1' , '7.8' , '6.3934426229508' , '22' , '0' , '15.60' ) 18/03/2024 05:35: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 ( '90819' , '20160' , 'BRACCIALE IN CORDA E METALLO - 800/328' , '88' , '-88' , '1' , '1.30' , '1.0655737704918' , '22' , '0' , '114.40' ) 18/03/2024 05:38:35 pm >> SELECT document_num FROM ps_document WHERE document_num = '441' AND id_document != '90338' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-14') 18/03/2024 05:38:35 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '441', document_date = '2024-02-14', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '625.00', price_tax_excluded = '521.66', date_upd = NOW() WHERE id_document = '90338' 18/03/2024 05:38:35 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 = '90338' 18/03/2024 05:38:35 pm >> DELETE FROM ps_document_detail WHERE id_document = '90338' 18/03/2024 05:38: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 ( '90338' , '1914' , 'CERA DELLA LITURGIA' , '72' , '-72' , '1' , '4.5000' , '3.6885245901639' , '22' , '0' , '324.00' ) 18/03/2024 05:38:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90338' , '11756' , 'VINO BIANCO SECCO - 14%' , '4' , '-4' , '1' , '6.9000' , '5.655737704918' , '22' , '0' , '27.60' ) 18/03/2024 05:38:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90338' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '2' , '-2' , '1' , '7.9000' , '6.4754098360656' , '22' , '0' , '15.80' ) 18/03/2024 05:38:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90338' , '11272' , 'VETRO ROSSO RUBINO - VKINGS' , '1' , '-1' , '1' , '12.5000' , '10.245901639344' , '22' , '0' , '12.50' ) 18/03/2024 05:38:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90338' , '6011' , 'LUMINELLO VETRO - 474' , '1' , '-1' , '1' , '11.0000' , '9.016393442623' , '22' , '0' , '11.00' ) 18/03/2024 05:38:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90338' , '17617' , 'IMMAGINI ISONZO X 100' , '2' , '-2' , '1' , '3.12' , '2.5573770491803' , '22' , '0' , '6.24' ) 18/03/2024 05:38:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90338' , '19599' , 'ROSARIO PER LA PRIMA COMUNIONE - 197/13' , '2' , '-2' , '1' , '2.8000' , '2.2950819672131' , '22' , '0' , '5.60' ) 18/03/2024 05:38:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90338' , '2764' , 'CORONA EMATITE TONDA ' , '1' , '-1' , '1' , '4.5000' , '3.6885245901639' , '22' , '0' , '4.50' ) 18/03/2024 05:38:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90338' , '6771' , 'MISSA DE ANGELIS' , '1' , '-1' , '1' , '13.0000' , '10.655737704918' , '22' , '5' , '12.35' ) 18/03/2024 05:38:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90338' , '6578' , 'MESSE GREGORIANE' , '1' , '-1' , '1' , '15.9000' , '13.032786885246' , '22' , '5' , '15.11' ) 18/03/2024 05:38:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90338' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '12' , '-12' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '42.00' ) 18/03/2024 05:38:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90338' , '16689' , 'OSTIA PAN DI CENA mm80' , '12' , '-12' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '24.00' ) 18/03/2024 05:38:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90338' , '17160' , 'CARBONCINI ROSSI - CARRO' , '2' , '-2' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '20.00' ) 18/03/2024 05:38:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90338' , '17161' , 'CARBONCINI NERI - CARNE' , '2' , '-2' , '1' , '12.0000' , '9.8360655737705' , '22' , '0' , '24.00' ) 18/03/2024 05:38:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90338' , '19102' , 'CARBONCINI MM 40' , '2' , '-2' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '26.00' ) 18/03/2024 05:38:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90338' , '19107' , 'INCENSO GRANI 3A - BUSTA' , '1' , '-1' , '1' , '30.0000' , '24.590163934426' , '22' , '0' , '30.00' ) 18/03/2024 05:38:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90338' , '19818' , 'INCENSO NATURALE 3A KG 1' , '1' , '-1' , '1' , '23.0000' , '18.852459016393' , '22' , '0' , '23.00' ) 18/03/2024 05:38:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90338' , '20160' , 'BRACCIALE IN CORDA E METALLO - 800/328' , '1' , '-1' , '1' , '1.30' , '1.0655737704918' , '22' , '0' , '1.30' ) 18/03/2024 06:02:13 pm >> SELECT document_num FROM ps_document WHERE document_num = '802' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-18') 18/03/2024 06:02:13 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '802' , '2024-03-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '16.50' , '13.52' , NOW() , NOW() ) 18/03/2024 06:02:13 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90820' 18/03/2024 06:02:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '90820' 18/03/2024 06:02:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90820' , '17617' , 'IMMAGINI ISONZO X 100' , '5' , '-5' , '1' , '3.3' , '2.7049180327869' , '22' , '0' , '16.50' ) 18/03/2024 06:08:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '803' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-18') 18/03/2024 06:08:42 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' , '803' , '2024-03-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '160.00' , '131.15' , NOW() , NOW() ) 18/03/2024 06:08:42 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 = '90821' 18/03/2024 06:08:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '90821' 18/03/2024 06:08:42 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 ( '90821' , '1425' , 'BUSTA 100 FLAMBEAUX IN CARTA - FLAM' , '3' , '-3' , '1' , '8.00' , '6.5573770491803' , '22' , '0' , '24.00' ) 18/03/2024 06:08:42 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 ( '90821' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '1' , '-1' , '1' , '70.00' , '57.377049180328' , '22' , '0' , '70.00' ) 18/03/2024 06:08:42 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 ( '90821' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '3' , '-3' , '1' , '22' , '18.032786885246' , '22' , '0' , '66.00' ) 18/03/2024 06:35:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '718' AND id_document != '90716' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-11') 18/03/2024 06:35:04 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '718', document_date = '2024-03-11', 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 = '71.90', price_tax_excluded = '58.93', date_upd = NOW() WHERE id_document = '90716' 18/03/2024 06:35:04 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 = '90716' 18/03/2024 06:35:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '90716' 18/03/2024 06:35:04 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 ( '90716' , '5651' , 'LEGGIO IN LEGNO ' , '1' , '-1' , '1' , '25.0000' , '20.491803278689' , '22' , '0' , '25.00' ) 18/03/2024 06:35:04 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 ( '90716' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '2' , '-2' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '7.00' ) 18/03/2024 06:35:04 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 ( '90716' , '21150' , 'QUADRO - BD15X15' , '1' , '-1' , '1' , '19.9000' , '16.311475409836' , '22' , '0' , '19.90' ) 18/03/2024 06:35:04 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 ( '90716' , '17005' , 'BIGLIETTO AUGURALE medio' , '6' , '-6' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '6.00' ) 18/03/2024 06:35:04 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 ( '90716' , '17004' , 'BIGLIETTO AUGURALE PICCOLO' , '3' , '-3' , '1' , '0.8000' , '0.65573770491803' , '22' , '0' , '2.40' ) 18/03/2024 06:35:04 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 ( '90716' , '19298' , 'BIGLIETTO AUGURALE GRANDE' , '3' , '-3' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '3.60' ) 18/03/2024 06:35:04 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 ( '90716' , '22198' , 'CORONCINA PRIMA COMUNIONE - 3313' , '1' , '-1' , '1' , '8.00' , '6.5573770491803' , '22' , '0' , '8.00' )