21/05/2022 09:02:13 am >> SELECT document_num FROM ps_document WHERE document_num = '1617' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-21') 21/05/2022 09:02:13 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1617' , '2022-05-21' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.30' , '7.02' , NOW() , NOW() ) 21/05/2022 09:02:13 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '57882' 21/05/2022 09:02:13 am >> DELETE FROM ps_document_detail WHERE id_document = '57882' 21/05/2022 09:02:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '57882' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '3.80' ) 21/05/2022 09:02:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 21/05/2022 09:02:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 21/05/2022 09:02:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '57882' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 21/05/2022 09:02:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 21/05/2022 09:02:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 21/05/2022 09:22:36 am >> SELECT document_num FROM ps_document WHERE document_num = '1618' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-21') 21/05/2022 09:22:36 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' , '1618' , '2022-05-21' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '150.00' , '128.06' , NOW() , NOW() ) 21/05/2022 09:22:36 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '57883' 21/05/2022 09:22:36 am >> DELETE FROM ps_document_detail WHERE id_document = '57883' 21/05/2022 09:22:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '57883' , '7936' , 'PERGAMENE - CRESIMA MOD. C' , '25' , '-25' , '1' , '0.50' , '0.40983606557377' , '22' , '5' , '12.00' ) 21/05/2022 09:22:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '7936' AND id_supplier = '' 21/05/2022 09:22:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7936' , '' , '1' ) 21/05/2022 09:22:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '57883' , '15406' , 'CROCE IN POLIMERO - CRESIMA - 2381/K0161' , '25' , '-25' , '1' , '3.00' , '2.4590163934426' , '22' , '0' , '75.00' ) 21/05/2022 09:22:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '15406' AND id_supplier = '' 21/05/2022 09:22:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15406' , '' , '1' ) 21/05/2022 09:22:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '57883' , '6809' , 'MOCCOLO 60X165' , '6' , '-6' , '1' , '4.50' , '3.6885245901639' , '22' , '0' , '27.00' ) 21/05/2022 09:22:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '6809' AND id_supplier = '' 21/05/2022 09:22:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6809' , '' , '1' ) 21/05/2022 09:22:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '57883' , '15924' , 'OSTIA 3MM - 03M-25' , '2' , '-2' , '3' , '6.00' , '5.7692307692308' , '4' , '0' , '12.00' ) 21/05/2022 09:22:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '15924' AND id_supplier = '' 21/05/2022 09:22:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15924' , '' , '1' ) 21/05/2022 09:22:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '57883' , '15922' , 'PARTICOLE 3MM - P3M' , '4' , '-4' , '3' , '6' , '5.7692307692308' , '4' , '0' , '24.00' ) 21/05/2022 09:22:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '15922' AND id_supplier = '' 21/05/2022 09:22:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15922' , '' , '1' ) 21/05/2022 09:39:12 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8057829100123' AND id_product != '15922' AND ean13 != '' 21/05/2022 09:39:12 am >> UPDATE ps_product SET id_supplier = '22', reference = '', ean13 = '8057829100123', date_upd = NOW() WHERE id_product = '15922' 21/05/2022 09:39:12 am >> UPDATE ps_product_lang SET name = 'PARTICOLE 3MM - P3M', description = '' WHERE id_product = '15922' 21/05/2022 09:39:12 am >> UPDATE ps_product SET wholesale_price = '2.91', on_sale = '0', price = '5.769230769230769' WHERE id_product = '15922' 21/05/2022 09:39:12 am >> UPDATE ps_product_shop SET wholesale_price = '2.91', price = '5.769230769230769', id_tax_rules_group = '3', id_category_default = '342', 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 = '15922' 21/05/2022 09:39:12 am >> DELETE FROM ps_specific_price WHERE id_product = '15922' 21/05/2022 09:45:41 am >> SELECT document_num FROM ps_document WHERE document_num = '1619' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-21') 21/05/2022 09:45:41 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' , '1619' , '2022-05-21' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '47.00' , '38.52' , NOW() , NOW() ) 21/05/2022 09:45:41 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 = '57884' 21/05/2022 09:45:41 am >> DELETE FROM ps_document_detail WHERE id_document = '57884' 21/05/2022 09:45:41 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 ( '57884' , '3073' , 'CROCE PRIMA COMUNIONE - LEGNO SCURO - 713/15' , '22' , '-22' , '1' , '1' , '0.81967213114754' , '22' , '0' , '22.00' ) 21/05/2022 09:45:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '3073' AND id_supplier = '' 21/05/2022 09:45:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3073' , '' , '1' ) 21/05/2022 09:45:41 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 ( '57884' , '7202' , 'ARTICOLI RELIGIOSI' , '10' , '-10' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '25.00' ) 21/05/2022 09:45:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 21/05/2022 09:45:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 21/05/2022 10:58:11 am >> SELECT document_num FROM ps_document WHERE document_num = '1620' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-21') 21/05/2022 10:58:11 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' , '1620' , '2022-05-21' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '47.00' , '38.52' , NOW() , NOW() ) 21/05/2022 10:58:11 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 = '57885' 21/05/2022 10:58:11 am >> DELETE FROM ps_document_detail WHERE id_document = '57885' 21/05/2022 10:58:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '57885' , '780' , 'ASPERGES MAXI CON CUSTODIA - 700' , '1' , '-1' , '1' , '47.00' , '38.524590163934' , '22' , '0' , '47.00' ) 21/05/2022 10:58:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '780' AND id_supplier = '' 21/05/2022 10:58:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '780' , '' , '1' ) 21/05/2022 12:21:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '1621' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-21') 21/05/2022 12:21:17 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' , '1621' , '2022-05-21' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '21.30' , '18.99' , NOW() , NOW() ) 21/05/2022 12:21:17 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 = '57886' 21/05/2022 12:21:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '57886' 21/05/2022 12:21: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 ( '57886' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 21/05/2022 12:21:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 21/05/2022 12:21:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 21/05/2022 12:21: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 ( '57886' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '3.80' ) 21/05/2022 12:21:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 21/05/2022 12:21:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 21/05/2022 12:21: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 ( '57886' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '7.50' ) 21/05/2022 12:21:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11384' AND id_supplier = '' 21/05/2022 12:21:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11384' , '' , '1' ) 21/05/2022 12:21: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 ( '57886' , '12131' , 'MADONNA DI FATIMA CENTENARIO - 451' , '1' , '-1' , '1' , '3' , '2.4590163934426' , '22' , '0' , '3.00' ) 21/05/2022 12:21:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12131' AND id_supplier = '' 21/05/2022 12:21:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12131' , '' , '1' ) 21/05/2022 12:25:48 pm >> SELECT document_num FROM ps_document WHERE document_num = '1622' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-21') 21/05/2022 12:25:48 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' , '1622' , '2022-05-21' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '45.00' , '36.89' , NOW() , NOW() ) 21/05/2022 12:25:48 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '57887' 21/05/2022 12:25:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '57887' 21/05/2022 12:25:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '57887' , '15529' , 'TUNICA 2 PIEGONI COLLO RISV. - PTA002B00' , '1' , '-1' , '1' , '45.00' , '36.885245901639' , '22' , '0' , '45.00' ) 21/05/2022 12:25:48 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15529' AND id_supplier = '' 21/05/2022 12:25:48 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15529' , '' , '1' ) 21/05/2022 12:29:35 pm >> SELECT document_num FROM ps_document WHERE document_num = '1623' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-21') 21/05/2022 12:29:35 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' , '1623' , '2022-05-21' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.00' , '5.00' , NOW() , NOW() ) 21/05/2022 12:29: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 = '57888' 21/05/2022 12:29:35 pm >> DELETE FROM ps_document_detail WHERE id_document = '57888' 21/05/2022 12:29: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 ( '57888' , '491' , 'AMORE DI GESÙ ETERNA SAPIENZA - 8366' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '0' , '5.00' ) 21/05/2022 12:29:35 pm >> DELETE FROM ps_product_supplier WHERE id_product = '491' AND id_supplier = '' 21/05/2022 12:29:35 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '491' , '' , '1' )