26/05/2022 09:29:24 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '316/2022' , '2022-05-23' , '2022' , '0' , '50' , '2645' , 'VIA P. G. SEMERIA, 19 70014 CONVERSANO' , '' , '' , '18' , '1' , '0' , '0' , '0' , '' , '3' , '0' , '326.96' , '268.00' , NOW() , NOW() ) 26/05/2022 09:29:24 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58446' 26/05/2022 09:29:24 am >> DELETE FROM ps_document_detail WHERE id_document = '58446' 26/05/2022 09:29:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58446' , '19432' , 'QUADRO DECORATO 35X25 - R35' , '4' , '4' , '1' , '50' , '40.983606557377' , '22' , '50' , '122.0000' ) 26/05/2022 09:29:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '19432' AND id_supplier = '50' 26/05/2022 09:29:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19432' , '50' , '1' ) 26/05/2022 09:29:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58446' , '16252' , 'CUORE PENDENTE' , '30' , '30' , '1' , '10' , '8.1967213114754' , '22' , '50' , '183.0000' ) 26/05/2022 09:29:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '16252' AND id_supplier = '50' 26/05/2022 09:29:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16252' , '50' , '1' ) 26/05/2022 10:00:36 am >> SELECT document_num FROM ps_document WHERE document_num = '1657' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-26') 26/05/2022 10:00: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' , '1657' , '2022-05-26' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '40.00' , '39.91' , NOW() , NOW() ) 26/05/2022 10:00: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 = '58447' 26/05/2022 10:00:36 am >> DELETE FROM ps_document_detail WHERE id_document = '58447' 26/05/2022 10:00: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 ( '58447' , '17865' , 'MESSALE QUOTIDIANO - N. E.' , '1' , '-1' , '4' , '39.50' , '39.5' , '0' , '' , '39.50' ) 26/05/2022 10:00:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '17865' AND id_supplier = '' 26/05/2022 10:00:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17865' , '' , '1' ) 26/05/2022 10:00: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 ( '58447' , '17004' , 'BIGLIETTO AUGURALE PICCOLO' , '1' , '-1' , '1' , '0.5' , '0.40983606557377' , '22' , '0' , '0.50' ) 26/05/2022 10:00:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '17004' AND id_supplier = '' 26/05/2022 10:00:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17004' , '' , '1' ) 26/05/2022 10:14:32 am >> SELECT document_num FROM ps_document WHERE document_num = '1658' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-26') 26/05/2022 10:14: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' , '1658' , '2022-05-26' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 26/05/2022 10:14: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 = '58448' 26/05/2022 10:14:32 am >> DELETE FROM ps_document_detail WHERE id_document = '58448' 26/05/2022 10:14: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 ( '58448' , '19467' , 'SULLA TUA PAROLA - LUG/AGO 2022' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 26/05/2022 10:14:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '19467' AND id_supplier = '' 26/05/2022 10:14:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19467' , '' , '1' ) 26/05/2022 10:20:39 am >> SELECT ean13 FROM ps_product WHERE ean13 = '001286' AND id_product != '16068' AND ean13 != '' 26/05/2022 10:20:39 am >> UPDATE ps_product SET id_supplier = '122', reference = '', ean13 = '001286', date_upd = NOW() WHERE id_product = '16068' 26/05/2022 10:20:39 am >> UPDATE ps_product_lang SET name = 'CAMICE PIEGONI 2 INSERTI - AECM17B05', description = '' WHERE id_product = '16068' 26/05/2022 10:20:39 am >> UPDATE ps_product SET wholesale_price = '45.00', on_sale = '0', price = '94.26229508196721' WHERE id_product = '16068' 26/05/2022 10:20:39 am >> UPDATE ps_product_shop SET wholesale_price = '45.00', price = '94.26229508196721', id_tax_rules_group = '1', id_category_default = '440', 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 = '16068' 26/05/2022 10:20:39 am >> DELETE FROM ps_specific_price WHERE id_product = '16068' 26/05/2022 10:24:49 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '510' , '2022-05-23' , '' , '0' , '122' , '4669556' , 'VIA XXV APRILE, 17 24050 GRASSOBBIO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '319.64' , '262.00' , NOW() , NOW() ) 26/05/2022 10:24:49 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58449' 26/05/2022 10:24:49 am >> DELETE FROM ps_document_detail WHERE id_document = '58449' 26/05/2022 10:24:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58449' , '16070' , 'CASULA - PCA020' , '1' , '1' , '1' , '30' , '24.590163934426' , '22' , '0' , '36.6000' ) 26/05/2022 10:24:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '16070' AND id_supplier = '122' 26/05/2022 10:24:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16070' , '122' , '1' ) 26/05/2022 10:24:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58449' , '14919' , 'CASULA - POLIESTERE - PCA022' , '1' , '1' , '1' , '30' , '24.590163934426' , '22' , '0' , '36.6000' ) 26/05/2022 10:24:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '14919' AND id_supplier = '122' 26/05/2022 10:24:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14919' , '122' , '1' ) 26/05/2022 10:24:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58449' , '16068' , 'CAMICE PIEGONI 2 INSERTI - AECM17B05' , '2' , '2' , '1' , '45' , '36.885245901639' , '22' , '0' , '109.8000' ) 26/05/2022 10:24:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '16068' AND id_supplier = '122' 26/05/2022 10:24:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16068' , '122' , '1' ) 26/05/2022 10:24:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58449' , '15041' , 'CAMICE MONASTICO - MISTO' , '1' , '1' , '1' , '112' , '91.803278688525' , '22' , '0' , '136.6400' ) 26/05/2022 10:24:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '15041' AND id_supplier = '122' 26/05/2022 10:24:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15041' , '122' , '1' ) 26/05/2022 10:38:44 am >> SELECT document_num FROM ps_document WHERE document_num = '1659' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-26') 26/05/2022 10:38:44 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1659' , '2022-05-26' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '41.00' , '35.95' , NOW() , NOW() ) 26/05/2022 10:38:44 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58450' 26/05/2022 10:38:44 am >> DELETE FROM ps_document_detail WHERE id_document = '58450' 26/05/2022 10:38:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58450' , '15085' , 'BRACCIALE DECINA COLORATA - BC506' , '10' , '-10' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '12.00' ) 26/05/2022 10:38:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '15085' AND id_supplier = '' 26/05/2022 10:38:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15085' , '' , '1' ) 26/05/2022 10:38:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58450' , '7916' , 'PERGAMENE - 1A RICONCILIAZIONE MOD. A' , '10' , '-10' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '5.00' ) 26/05/2022 10:38:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '7916' AND id_supplier = '' 26/05/2022 10:38:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7916' , '' , '1' ) 26/05/2022 10:38:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58450' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '7.50' ) 26/05/2022 10:38:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '11384' AND id_supplier = '' 26/05/2022 10:38:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11384' , '' , '1' ) 26/05/2022 10:38:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58450' , '16689' , 'OSTIA PAN DI CENA mm80' , '3' , '-3' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '6.00' ) 26/05/2022 10:38:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = '' 26/05/2022 10:38:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '' , '1' ) 26/05/2022 10:38:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58450' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '3' , '-3' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '10.50' ) 26/05/2022 10:38:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 26/05/2022 10:38:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 26/05/2022 11:00:32 am >> SELECT document_num FROM ps_document WHERE document_num = '40/A' AND id_document != '58421' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-05-24') 26/05/2022 11:00:32 am >> UPDATE ps_document SET id_document_type = '24', document_num = '40/A', document_date = '2022-05-24', document_letter = 'A', id_customer = '3355', id_supplier = '', id_address = '4674401', address1 = 'L. GO G. LUCIANI, 1 84125 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '42.00', price_tax_excluded = '36.23', date_upd = NOW() WHERE id_document = '58421' 26/05/2022 11:00: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 = '58421' 26/05/2022 11:00:32 am >> DELETE FROM ps_document_detail WHERE id_document = '58421' 26/05/2022 11:00: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 ( '58421' , '0' , 'PERGAMENE' , '20' , '-20' , '0' , '0.5000' , '0.5' , '0' , '0' , '10.00' ) 26/05/2022 11:00:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '' 26/05/2022 11:00:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' ) 26/05/2022 11:00: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 ( '58421' , '19315' , 'SCATOLINA METALLO CON CORONCINA COMUNIONE - 1016/K209' , '5' , '-5' , '1' , '2.8000' , '2.2950819672131' , '22' , '0' , '14.00' ) 26/05/2022 11:00:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '19315' AND id_supplier = '' 26/05/2022 11:00:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19315' , '' , '1' ) 26/05/2022 11:00:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58421' , '15406' , 'CROCE IN POLIMERO - CRESIMA - 2381/K0161' , '6' , '-6' , '1' , '3.00' , '2.4590163934426' , '22' , '0' , '18.00' ) 26/05/2022 11:00:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '15406' AND id_supplier = '' 26/05/2022 11:00:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15406' , '' , '1' ) 26/05/2022 11:06:33 am >> SELECT document_num FROM ps_document WHERE document_num = '1660' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-26') 26/05/2022 11:06:33 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1660' , '2022-05-26' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '68.00' , '55.74' , NOW() , NOW() ) 26/05/2022 11:06:33 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58451' 26/05/2022 11:06:33 am >> DELETE FROM ps_document_detail WHERE id_document = '58451' 26/05/2022 11:06:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58451' , '15801' , 'ARGENTO A PESO' , '1' , '-1' , '1' , '55' , '45.081967213115' , '22' , '0' , '55.00' ) 26/05/2022 11:06:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '15801' AND id_supplier = '' 26/05/2022 11:06:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15801' , '' , '1' ) 26/05/2022 11:06:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58451' , '19431' , 'PALLONCINO MAGNETE 12X15 - PM' , '1' , '-1' , '1' , '13' , '10.655737704918' , '22' , '0' , '13.00' ) 26/05/2022 11:06:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '19431' AND id_supplier = '' 26/05/2022 11:06:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19431' , '' , '1' ) 26/05/2022 11:10:20 am >> SELECT document_num FROM ps_document WHERE document_num = '1661' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-26') 26/05/2022 11:10:20 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1661' , '2022-05-26' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '90.40' , '79.58' , NOW() , NOW() ) 26/05/2022 11:10:20 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58452' 26/05/2022 11:10:20 am >> DELETE FROM ps_document_detail WHERE id_document = '58452' 26/05/2022 11:10:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58452' , '15010' , 'CHARLES DE FOUCAULD - P. SOURISSEAU' , '1' , '-1' , '4' , '32.00' , '32' , '0' , '5' , '30.40' ) 26/05/2022 11:10:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '15010' AND id_supplier = '' 26/05/2022 11:10:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15010' , '' , '1' ) 26/05/2022 11:10:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58452' , '3045' , 'CROCE METALLO BUON PASTORE CM 3,8 - G352' , '100' , '-100' , '1' , '0.6' , '0.49180327868852' , '22' , '0' , '60.00' ) 26/05/2022 11:10:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '3045' AND id_supplier = '' 26/05/2022 11:10:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3045' , '' , '1' ) 26/05/2022 11:11:01 am >> SELECT document_num FROM ps_document WHERE document_num = '90' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-05-26') 26/05/2022 11:11:01 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '90' , '2022-05-26' , '' , '979' , '0' , '4671729' , 'VIA ROBERTO MAZZETTI, 5/A 84135 SALERNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '15' , '0' , '47.60' , '47.60' , NOW() , NOW() ) 26/05/2022 11:11:01 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58453' 26/05/2022 11:11:01 am >> DELETE FROM ps_document_detail WHERE id_document = '58453' 26/05/2022 11:11:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58453' , '11105' , 'VANGELO E ATTI DEGLI APOSTOLI PER OCCASIONI' , '16' , '-16' , '4' , '3.50' , '3.5' , '0' , '15' , '47.60' ) 26/05/2022 12:05:25 pm >> SELECT document_num FROM ps_document WHERE document_num = '1662' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-26') 26/05/2022 12:05:25 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1662' , '2022-05-26' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.50' , '11.50' , NOW() , NOW() ) 26/05/2022 12:05:25 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58454' 26/05/2022 12:05:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '58454' 26/05/2022 12:05:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58454' , '19467' , 'SULLA TUA PAROLA - LUG/AGO 2022' , '2' , '-2' , '4' , '5.00' , '5' , '0' , '5' , '9.50' ) 26/05/2022 12:05:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19467' AND id_supplier = '' 26/05/2022 12:05:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19467' , '' , '1' ) 26/05/2022 12:05:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58454' , '5461' , 'IO SONO IL PANE DELLA VITA' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 26/05/2022 12:05:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5461' AND id_supplier = '' 26/05/2022 12:05:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5461' , '' , '1' ) 26/05/2022 12:19:12 pm >> SELECT document_num FROM ps_document WHERE document_num = '1663' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-26') 26/05/2022 12:19: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' , '1663' , '2022-05-26' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.20' , '15.20' , NOW() , NOW() ) 26/05/2022 12:19: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 = '58455' 26/05/2022 12:19:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '58455' 26/05/2022 12:19: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 ( '58455' , '19588' , 'SCELTA DI ENEA - L. EPICOCO' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 26/05/2022 12:19:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19588' AND id_supplier = '' 26/05/2022 12:19:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19588' , '' , '1' ) 26/05/2022 12:41:55 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 26/05/2022 12:41:55 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19596' , '1' , '' , 'nuovo-prodotto' ) 26/05/2022 12:41:55 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '19596' , '1' , '1' , '2' , NOW() , NOW() ) 26/05/2022 12:41:55 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '19596' , '0' , '1' , '0' , '0' ) 26/05/2022 12:43:00 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8027846045844' AND id_product != '19596' AND ean13 != '' 26/05/2022 12:43:00 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8027846045844', date_upd = NOW() WHERE id_product = '19596' 26/05/2022 12:43:00 pm >> UPDATE ps_product_lang SET name = 'MEDAGLIA SAN BENEDETTO ARG. RA630', description = '' WHERE id_product = '19596' 26/05/2022 12:43:00 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '9.836065573770492' WHERE id_product = '19596' 26/05/2022 12:43:00 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '9.836065573770492', id_tax_rules_group = '1', id_category_default = '151', 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 = '19596' 26/05/2022 12:43:00 pm >> DELETE FROM ps_specific_price WHERE id_product = '19596' 26/05/2022 12:43:01 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 = '19596' 26/05/2022 12:43:01 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19597' , '1' , '' , 'nuovo-prodotto' ) 26/05/2022 12:43:01 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 '19597' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19596' 26/05/2022 12:43:01 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19597' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19596' 26/05/2022 12:44:10 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8027846045851' AND id_product != '19597' AND ean13 != '' 26/05/2022 12:44:10 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8027846045851', date_upd = NOW() WHERE id_product = '19597' 26/05/2022 12:44:10 pm >> UPDATE ps_product_lang SET name = 'MEDAGLIA SAN BENEDETTO ARG. RA631', description = '' WHERE id_product = '19597' 26/05/2022 12:44:10 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '13.934426229508198' WHERE id_product = '19597' 26/05/2022 12:44:10 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '13.934426229508198', id_tax_rules_group = '1', id_category_default = '151', 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 = '19597' 26/05/2022 12:44:10 pm >> DELETE FROM ps_specific_price WHERE id_product = '19597' 26/05/2022 12:44:10 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 = '19597' 26/05/2022 12:44:10 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19598' , '1' , '' , 'nuovo-prodotto' ) 26/05/2022 12:44:10 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 '19598' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19597' 26/05/2022 12:44:11 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19598' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19597' 26/05/2022 12:45:32 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001997' AND id_product != '19598' AND ean13 != '' 26/05/2022 12:45:32 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '001997', date_upd = NOW() WHERE id_product = '19598' 26/05/2022 12:45:32 pm >> UPDATE ps_product_lang SET name = 'MEDAGLIA SPILLA SPIRITO SANTO - G24OX', description = '' WHERE id_product = '19598' 26/05/2022 12:45:32 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '1.0655737704918034' WHERE id_product = '19598' 26/05/2022 12:45:32 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '1.0655737704918034', id_tax_rules_group = '1', id_category_default = '151', 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 = '19598' 26/05/2022 12:45:32 pm >> DELETE FROM ps_specific_price WHERE id_product = '19598' 26/05/2022 12:45:37 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 = '19598' 26/05/2022 12:45:37 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19599' , '1' , '' , 'nuovo-prodotto' ) 26/05/2022 12:45:37 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 '19599' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19598' 26/05/2022 12:45:37 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19599' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19598' 26/05/2022 12:47:31 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001613' AND id_product != '17786' AND ean13 != '' 26/05/2022 12:47:32 pm >> UPDATE ps_product SET id_supplier = '43', reference = '', ean13 = '001613', date_upd = NOW() WHERE id_product = '17786' 26/05/2022 12:47:32 pm >> UPDATE ps_product_lang SET name = 'CROCE METALLO CM 10 - FX125-SA', description = '' WHERE id_product = '17786' 26/05/2022 12:47:32 pm >> UPDATE ps_product SET wholesale_price = '3.33', on_sale = '0', price = '8.032786885245903' WHERE id_product = '17786' 26/05/2022 12:47:32 pm >> UPDATE ps_product_shop SET wholesale_price = '3.33', price = '8.032786885245903', id_tax_rules_group = '1', id_category_default = '151', 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 = '17786' 26/05/2022 12:47:32 pm >> DELETE FROM ps_specific_price WHERE id_product = '17786' 26/05/2022 12:50:01 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' , '997/2022' , '2022-05-25' , '2022' , '0' , '43' , '2638' , 'VIA COSTABIANCA, 43 60025 LORETO' , '' , '' , '15' , '1' , '0' , '0' , '0' , '' , '3' , '0' , '145.73' , '119.45' , NOW() , NOW() ) 26/05/2022 12:50:01 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 = '58456' 26/05/2022 12:50:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '58456' 26/05/2022 12:50:02 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 ( '58456' , '3045' , 'CROCE METALLO BUON PASTORE CM 3,8 - G352' , '150' , '150' , '1' , '0.25' , '0.20491803278689' , '22' , '5' , '43.4625' ) 26/05/2022 12:50:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '3045' AND id_supplier = '43' 26/05/2022 12:50:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3045' , '43' , '1' ) 26/05/2022 12:50:02 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 ( '58456' , '19234' , 'ANELLO A FASCIA ROSATO - RA085 -CU' , '2' , '2' , '1' , '9.4' , '7.7049180327869' , '22' , '5' , '21.7892' ) 26/05/2022 12:50:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19234' AND id_supplier = '43' 26/05/2022 12:50:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19234' , '43' , '1' ) 26/05/2022 12:50:02 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 ( '58456' , '17602' , 'BRACCIALE SIMIL PELLE BLU - AC120P' , '1' , '1' , '1' , '5.97' , '4.8934426229508' , '22' , '5' , '6.9192' ) 26/05/2022 12:50:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17602' AND id_supplier = '43' 26/05/2022 12:50:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17602' , '43' , '1' ) 26/05/2022 12:50:02 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 ( '58456' , '17603' , 'BRACCIALE SIMIL PELLE NERO - AC120D' , '1' , '1' , '1' , '5.97' , '4.8934426229508' , '22' , '5' , '6.9192' ) 26/05/2022 12:50:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17603' AND id_supplier = '43' 26/05/2022 12:50:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17603' , '43' , '1' ) 26/05/2022 12:50:02 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 ( '58456' , '19596' , 'MEDAGLIA SAN BENEDETTO ARG. RA630' , '1' , '1' , '1' , '4.41' , '3.6147540983607' , '22' , '5' , '5.1112' ) 26/05/2022 12:50:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19596' AND id_supplier = '43' 26/05/2022 12:50:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19596' , '43' , '1' ) 26/05/2022 12:50:02 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 ( '58456' , '19597' , 'MEDAGLIA SAN BENEDETTO ARG. RA631' , '1' , '1' , '1' , '6.83' , '5.5983606557377' , '22' , '5' , '7.9160' ) 26/05/2022 12:50:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19597' AND id_supplier = '43' 26/05/2022 12:50:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19597' , '43' , '1' ) 26/05/2022 12:50:02 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 ( '58456' , '19598' , 'MEDAGLIA SPILLA SPIRITO SANTO - G24OX' , '50' , '50' , '1' , '0.53' , '0.4344262295082' , '22' , '5' , '30.7135' ) 26/05/2022 12:50:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19598' AND id_supplier = '43' 26/05/2022 12:50:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19598' , '43' , '1' ) 26/05/2022 12:50:02 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 ( '58456' , '17786' , 'CROCE METALLO CM 10 - FX125-SA' , '1' , '1' , '1' , '3.97' , '3.2540983606557' , '22' , '5' , '4.6012' ) 26/05/2022 12:50:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17786' AND id_supplier = '43' 26/05/2022 12:50:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17786' , '43' , '1' ) 26/05/2022 02:37:07 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001998' AND id_product != '19599' AND ean13 != '' 26/05/2022 02:37:07 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '001998', date_upd = NOW() WHERE id_product = '19599' 26/05/2022 02:37:07 pm >> UPDATE ps_product_lang SET name = 'ROSARIO PERLA PRIMA COMUNIONE - 197/13', description = '' WHERE id_product = '19599' 26/05/2022 02:37:07 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '2.2950819672131146' WHERE id_product = '19599' 26/05/2022 02:37:07 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '2.2950819672131146', id_tax_rules_group = '1', id_category_default = '154', 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 = '19599' 26/05/2022 02:37:07 pm >> DELETE FROM ps_specific_price WHERE id_product = '19599' 26/05/2022 02:37:09 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '19599' 26/05/2022 02:37:09 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19600' , '1' , '' , 'nuovo-prodotto' ) 26/05/2022 02:37:09 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '19600' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19599' 26/05/2022 02:37:09 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19600' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19599' 26/05/2022 02:38:42 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001143' AND id_product != '15097' AND ean13 != '' 26/05/2022 02:38:42 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '001143', date_upd = NOW() WHERE id_product = '15097' 26/05/2022 02:38:42 pm >> UPDATE ps_product_lang SET name = 'CORONA MATRIMONIO - ORO', description = '' WHERE id_product = '15097' 26/05/2022 02:38:42 pm >> UPDATE ps_product SET wholesale_price = '2.40', on_sale = '0', price = '6.147540983606557' WHERE id_product = '15097' 26/05/2022 02:38:42 pm >> UPDATE ps_product_shop SET wholesale_price = '2.40', price = '6.147540983606557', id_tax_rules_group = '1', id_category_default = '154', 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 = '15097' 26/05/2022 02:38:42 pm >> DELETE FROM ps_specific_price WHERE id_product = '15097' 26/05/2022 02:40:09 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001142' AND id_product != '15096' AND ean13 != '' 26/05/2022 02:40:09 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '001142', date_upd = NOW() WHERE id_product = '15096' 26/05/2022 02:40:09 pm >> UPDATE ps_product_lang SET name = 'CORONA MATRIMONIO - ARG ', description = '' WHERE id_product = '15096' 26/05/2022 02:40:09 pm >> UPDATE ps_product SET wholesale_price = '2.40', on_sale = '0', price = '6.147540983606557' WHERE id_product = '15096' 26/05/2022 02:40:09 pm >> UPDATE ps_product_shop SET wholesale_price = '2.40', price = '6.147540983606557', id_tax_rules_group = '1', id_category_default = '154', 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 = '15096' 26/05/2022 02:40:09 pm >> DELETE FROM ps_specific_price WHERE id_product = '15096' 26/05/2022 02:41:18 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '18/16' AND id_product != '3268' AND ean13 != '' 26/05/2022 02:41:18 pm >> UPDATE ps_product SET id_supplier = '60', reference = '2016', ean13 = '18/16', date_upd = NOW() WHERE id_product = '3268' 26/05/2022 02:41:18 pm >> UPDATE ps_product_lang SET name = 'CUSTODIA S. ROSARIO + DECINA', description = '' WHERE id_product = '3268' 26/05/2022 02:41:18 pm >> UPDATE ps_product SET wholesale_price = '0.78', on_sale = '0', price = '1.4754098360655739' WHERE id_product = '3268' 26/05/2022 02:41:18 pm >> UPDATE ps_product_shop SET wholesale_price = '0.78', price = '1.4754098360655739', id_tax_rules_group = '1', id_category_default = '154', 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 = '3268' 26/05/2022 02:41:18 pm >> DELETE FROM ps_specific_price WHERE id_product = '3268' 26/05/2022 02:44:00 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '510/21' AND id_product != '3193' AND ean13 != '' 26/05/2022 02:44:00 pm >> UPDATE ps_product SET id_supplier = '', reference = '2016', ean13 = '510/21', date_upd = NOW() WHERE id_product = '3193' 26/05/2022 02:44:00 pm >> UPDATE ps_product_lang SET name = 'CROCIFISSO ULIVO SMUSSATO CM 21', description = '' WHERE id_product = '3193' 26/05/2022 02:44:00 pm >> UPDATE ps_product SET wholesale_price = '6.61', on_sale = '0', price = '8.19672131147541' WHERE id_product = '3193' 26/05/2022 02:44:00 pm >> UPDATE ps_product_shop SET wholesale_price = '6.61', price = '8.19672131147541', id_tax_rules_group = '1', id_category_default = '154', 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 = '3193' 26/05/2022 02:44:00 pm >> DELETE FROM ps_specific_price WHERE id_product = '3193' 26/05/2022 02:46:03 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001999' AND id_product != '19600' AND ean13 != '' 26/05/2022 02:46:03 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '001999', date_upd = NOW() WHERE id_product = '19600' 26/05/2022 02:46:03 pm >> UPDATE ps_product_lang SET name = 'ROSARIO SPIRITO SANTO', description = '' WHERE id_product = '19600' 26/05/2022 02:46:03 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3.1147540983606556' WHERE id_product = '19600' 26/05/2022 02:46:03 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3.1147540983606556', id_tax_rules_group = '1', id_category_default = '154', 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 = '19600' 26/05/2022 02:46:03 pm >> DELETE FROM ps_specific_price WHERE id_product = '19600' 26/05/2022 02:55:26 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' , '0000' , '2022-05-23' , '' , '0' , '60' , '2655' , 'Z.I. PIANE MAVONE 64042 COLLEDARA' , '' , '' , '20' , '1' , '0' , '0' , '0' , '' , '9' , '0' , '953.20' , '781.31' , NOW() , NOW() ) 26/05/2022 02:55:26 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 = '58457' 26/05/2022 02:55:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '58457' 26/05/2022 02:55:26 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 ( '58457' , '19599' , 'ROSARIO PERLA PRIMA COMUNIONE - 197/13' , '48' , '48' , '1' , '1.1' , '0.9016393442623' , '22' , '0' , '64.4160' ) 26/05/2022 02:55:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19599' AND id_supplier = '60' 26/05/2022 02:55:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19599' , '60' , '1' ) 26/05/2022 02:55:26 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 ( '58457' , '15097' , 'CORONA MATRIMONIO - ORO' , '84' , '84' , '1' , '2.75' , '2.2540983606557' , '22' , '0' , '281.8200' ) 26/05/2022 02:55:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15097' AND id_supplier = '60' 26/05/2022 02:55:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15097' , '60' , '1' ) 26/05/2022 02:55:26 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 ( '58457' , '15096' , 'CORONA MATRIMONIO - ARG ' , '24' , '24' , '1' , '2.6' , '2.1311475409836' , '22' , '0' , '76.1280' ) 26/05/2022 02:55:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15096' AND id_supplier = '60' 26/05/2022 02:55:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15096' , '60' , '1' ) 26/05/2022 02:55:26 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 ( '58457' , '3268' , 'CUSTODIA S. ROSARIO + DECINA' , '343' , '343' , '1' , '0.72' , '0.59016393442623' , '22' , '0' , '301.2912' ) 26/05/2022 02:55:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '3268' AND id_supplier = '60' 26/05/2022 02:55:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3268' , '60' , '1' ) 26/05/2022 02:55:26 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 ( '58457' , '3193' , 'CROCIFISSO ULIVO SMUSSATO CM 21' , '25' , '25' , '1' , '3.75' , '3.0737704918033' , '22' , '0' , '114.3750' ) 26/05/2022 02:55:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '3193' AND id_supplier = '60' 26/05/2022 02:55:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3193' , '60' , '1' ) 26/05/2022 02:55:26 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 ( '58457' , '19600' , 'ROSARIO SPIRITO SANTO' , '48' , '48' , '1' , '1.55' , '1.2704918032787' , '22' , '0' , '90.7680' ) 26/05/2022 02:55:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19600' AND id_supplier = '60' 26/05/2022 02:55:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19600' , '60' , '1' ) 26/05/2022 02:57:07 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '510/21' AND id_product != '3193' AND ean13 != '' 26/05/2022 02:57:07 pm >> UPDATE ps_product SET id_supplier = '60', reference = '2016', ean13 = '510/21', date_upd = NOW() WHERE id_product = '3193' 26/05/2022 02:57:07 pm >> UPDATE ps_product_lang SET name = 'CROCIFISSO ULIVO SMUSSATO CM 21', description = '' WHERE id_product = '3193' 26/05/2022 02:57:07 pm >> UPDATE ps_product SET wholesale_price = '6.61', on_sale = '0', price = '9.836065573770492' WHERE id_product = '3193' 26/05/2022 02:57:07 pm >> UPDATE ps_product_shop SET wholesale_price = '6.61', price = '9.836065573770492', id_tax_rules_group = '1', id_category_default = '154', 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 = '3193' 26/05/2022 02:57:07 pm >> DELETE FROM ps_specific_price WHERE id_product = '3193' 26/05/2022 04:09:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '1664' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-26') 26/05/2022 04:09:32 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' , '1664' , '2022-05-26' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '16.30' , '14.50' , NOW() , NOW() ) 26/05/2022 04:09:32 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 = '58458' 26/05/2022 04:09:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '58458' 26/05/2022 04:09:32 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 ( '58458' , '7936' , 'PERGAMENE - CRESIMA MOD. C' , '20' , '-20' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '10.00' ) 26/05/2022 04:09:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7936' AND id_supplier = '' 26/05/2022 04:09:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7936' , '' , '1' ) 26/05/2022 04:09:32 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 ( '58458' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '6.3' , '6.3' , '0' , '0' , '6.30' ) 26/05/2022 04:09:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 26/05/2022 04:09:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 26/05/2022 04:10:50 pm >> SELECT document_num FROM ps_document WHERE document_num = '29' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-05-26') 26/05/2022 04:10:50 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '29' , '2022-05-26' , '' , '333' , '0' , '4670235' , 'P.ZZA S. MICHELE 84135 RUFOLI' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '124.95' , '124.95' , NOW() , NOW() ) 26/05/2022 04:10:50 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '5364' 26/05/2022 04:10:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '5364' 26/05/2022 04:10:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5364' , '33' , '100 GIORNI CON LO SPIRITO' , '21' , '-21' , '4' , '7.00' , '7' , '0' , '15' , '124.95' ) 26/05/2022 04:31:29 pm >> SELECT document_num FROM ps_document WHERE document_num = '29' AND id_document != '5364' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-05-26') 26/05/2022 04:31:29 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '29', document_date = '2022-05-26', document_letter = '', id_customer = '333', id_supplier = '', id_address = '4670235', address1 = 'P.ZZA S. MICHELE 84135 RUFOLI', address2 = '', note = 'da saldare', 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 = '124.95', price_tax_excluded = '124.95', date_upd = NOW() WHERE id_document = '5364' 26/05/2022 04:31: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 = '5364' 26/05/2022 04:31:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '5364' 26/05/2022 04:31: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 ( '5364' , '33' , '100 GIORNI CON LO SPIRITO' , '21' , '-21' , '4' , '7.0000' , '7' , '0' , '15' , '124.95' ) 26/05/2022 04:31:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '33' AND id_supplier = '' 26/05/2022 04:31:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '33' , '' , '1' ) 26/05/2022 04:40:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '40/A' AND id_document != '58421' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-05-24') 26/05/2022 04:40:39 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '40/A', document_date = '2022-05-24', document_letter = 'A', id_customer = '3355', id_supplier = '', id_address = '4674401', address1 = 'L. GO G. LUCIANI, 1 84125 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '128.00', price_tax_excluded = '106.72', date_upd = NOW() WHERE id_document = '58421' 26/05/2022 04:40:39 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58421' 26/05/2022 04:40:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '58421' 26/05/2022 04:40:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58421' , '0' , 'PERGAMENE' , '20' , '-20' , '0' , '0.5000' , '0.5' , '0' , '0' , '10.00' ) 26/05/2022 04:40:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '' 26/05/2022 04:40:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' ) 26/05/2022 04:40:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58421' , '19315' , 'SCATOLINA METALLO CON CORONCINA COMUNIONE - 1016/K209' , '5' , '-5' , '1' , '2.8000' , '2.2950819672131' , '22' , '0' , '14.00' ) 26/05/2022 04:40:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19315' AND id_supplier = '' 26/05/2022 04:40:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19315' , '' , '1' ) 26/05/2022 04:40:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58421' , '15406' , 'CROCE IN POLIMERO - CRESIMA - 2381/K0161' , '7' , '-7' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '21.00' ) 26/05/2022 04:40:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15406' AND id_supplier = '' 26/05/2022 04:40:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15406' , '' , '1' ) 26/05/2022 04:40:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58421' , '14623' , 'BAMBINO DI PRAGA BABY - 023 IP/9 BB' , '3' , '-3' , '1' , '8.00' , '6.5573770491803' , '22' , '0' , '24.00' ) 26/05/2022 04:40:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14623' AND id_supplier = '' 26/05/2022 04:40:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14623' , '' , '1' ) 26/05/2022 04:40:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58421' , '782' , 'ASPERGES PER SECCHIELLO - 701' , '1' , '-1' , '1' , '51' , '41.803278688525' , '22' , '0' , '51.00' ) 26/05/2022 04:40:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '782' AND id_supplier = '' 26/05/2022 04:40:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '782' , '' , '1' ) 26/05/2022 04:40:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58421' , '9212' , 'S. FRANCESCO BABY - 023 SF/9 BB' , '1' , '-1' , '1' , '8.00' , '6.5573770491803' , '22' , '0' , '8.00' ) 26/05/2022 04:40:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9212' AND id_supplier = '' 26/05/2022 04:40:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9212' , '' , '1' ) 26/05/2022 04:42:27 pm >> SELECT document_num FROM ps_document WHERE document_num = '1665' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-26') 26/05/2022 04:42:27 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' , '1665' , '2022-05-26' , '' , '' , '' , '' , 'L. GO G. LUCIANI, 1 84125 SALERNO' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '128.00' , '106.72' , NOW() , NOW() ) 26/05/2022 04:42:27 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 = '58459' 26/05/2022 04:42:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '58459' 26/05/2022 04:42:27 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 ( '58459' , '0' , 'PERGAMENE' , '20' , '-20' , '0' , '0.5000' , '0.5' , '0' , '0' , '10.00' ) 26/05/2022 04:42:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '' 26/05/2022 04:42:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' ) 26/05/2022 04:42:27 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 ( '58459' , '19315' , 'SCATOLINA METALLO CON CORONCINA COMUNIONE - 1016/K209' , '5' , '-5' , '1' , '2.8000' , '2.2951' , '22' , '0' , '14.00' ) 26/05/2022 04:42:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19315' AND id_supplier = '' 26/05/2022 04:42:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19315' , '' , '1' ) 26/05/2022 04:42:27 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 ( '58459' , '15406' , 'CROCE IN POLIMERO - CRESIMA - 2381/K0161' , '7' , '-7' , '1' , '3.0000' , '2.459' , '22' , '0' , '21.00' ) 26/05/2022 04:42:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15406' AND id_supplier = '' 26/05/2022 04:42:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15406' , '' , '1' ) 26/05/2022 04:42:27 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 ( '58459' , '14623' , 'BAMBINO DI PRAGA BABY - 023 IP/9 BB' , '3' , '-3' , '1' , '8.0000' , '6.5574' , '22' , '0' , '24.00' ) 26/05/2022 04:42:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14623' AND id_supplier = '' 26/05/2022 04:42:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14623' , '' , '1' ) 26/05/2022 04:42:27 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 ( '58459' , '782' , 'ASPERGES PER SECCHIELLO - 701' , '1' , '-1' , '1' , '51.0000' , '41.8033' , '22' , '0' , '51.00' ) 26/05/2022 04:42:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '782' AND id_supplier = '' 26/05/2022 04:42:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '782' , '' , '1' ) 26/05/2022 04:42:27 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 ( '58459' , '9212' , 'S. FRANCESCO BABY - 023 SF/9 BB' , '1' , '-1' , '1' , '8.0000' , '6.5574' , '22' , '0' , '8.00' ) 26/05/2022 04:42:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9212' AND id_supplier = '' 26/05/2022 04:42:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9212' , '' , '1' ) 26/05/2022 04:49:40 pm >> SELECT document_num FROM ps_document WHERE document_num = '90' AND id_document != '58453' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-05-26') 26/05/2022 04:49:40 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '90', document_date = '2022-05-26', document_letter = '', id_customer = '979', id_supplier = '', id_address = '4671729', address1 = 'VIA ROBERTO MAZZETTI, 5/A 84135 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '47.60', price_tax_excluded = '47.60', date_upd = NOW() WHERE id_document = '58453' 26/05/2022 04:49:40 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58453' 26/05/2022 04:49:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '58453' 26/05/2022 04:49:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58453' , '11105' , 'VANGELO E ATTI DEGLI APOSTOLI PER OCCASIONI' , '16' , '-16' , '4' , '3.5000' , '3.5' , '0' , '15' , '47.60' ) 26/05/2022 04:49:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11105' AND id_supplier = '' 26/05/2022 04:49:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11105' , '' , '1' ) 26/05/2022 05:37:31 pm >> UPDATE ps_document SET id_document_type = '31', document_num = '138/2018', document_date = '2018-07-19', document_letter = '2018', id_customer = '0', id_supplier = '', id_address = '2672', address1 = 'UL. MALBORSKA, 8 42200 CZESTOCHOWA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '429.05', price_tax_excluded = '429.05', date_upd = NOW() WHERE id_document = '58440' 26/05/2022 05:37:31 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 = '58440' 26/05/2022 05:37:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '58440' 26/05/2022 05:37:31 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 ( '58440' , '8147' , 'POLO NERA MM - COTONE - XXL - OGGETTI' , '5' , '5' , '0' , '10.5000' , '10.5' , '0' , '0' , '52.50' ) 26/05/2022 05:37:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8147' AND id_supplier = '' 26/05/2022 05:37:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8147' , '' , '1' ) 26/05/2022 05:37:32 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 ( '58440' , '8129' , 'POLO GRIGIO CHIARO MM - COTONE - XXL - OGGETTI' , '5' , '5' , '0' , '10.5000' , '10.5' , '0' , '0' , '52.50' ) 26/05/2022 05:37:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8129' AND id_supplier = '' 26/05/2022 05:37:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8129' , '' , '1' ) 26/05/2022 05:37:32 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 ( '58440' , '8127' , 'POLO GRIGIO CHIARO MM - COTONE - M' , '2' , '2' , '0' , '10.5000' , '10.5' , '0' , '0' , '21.00' ) 26/05/2022 05:37:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8127' AND id_supplier = '' 26/05/2022 05:37:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8127' , '' , '1' ) 26/05/2022 05:37:32 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 ( '58440' , '8113' , 'POLO CELESTE MM - COTONE - XXL - OGGETTI' , '2' , '2' , '0' , '10.5000' , '10.5' , '0' , '0' , '21.00' ) 26/05/2022 05:37:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8113' AND id_supplier = '' 26/05/2022 05:37:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8113' , '' , '1' ) 26/05/2022 05:37:32 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 ( '58440' , '8111' , 'POLO CELESTE MM - COTONE - M' , '1' , '1' , '0' , '10.5000' , '10.5' , '0' , '0' , '10.50' ) 26/05/2022 05:37:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8111' AND id_supplier = '' 26/05/2022 05:37:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8111' , '' , '1' ) 26/05/2022 05:37:32 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 ( '58440' , '14296' , 'POLO BLU MM - M ' , '3' , '3' , '0' , '10.5000' , '10.5' , '0' , '0' , '31.50' ) 26/05/2022 05:37:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14296' AND id_supplier = '' 26/05/2022 05:37:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14296' , '' , '1' ) 26/05/2022 05:37:32 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 ( '58440' , '8101' , 'POLO BLU MM - COTONE - XL - OGGETTI' , '1' , '1' , '0' , '10.5000' , '10.5' , '0' , '0' , '10.50' ) 26/05/2022 05:37:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8101' AND id_supplier = '' 26/05/2022 05:37:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8101' , '' , '1' ) 26/05/2022 05:37:32 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 ( '58440' , '8098' , 'POLO BLU MM - COTONE - 3XL - OGGETTI' , '1' , '1' , '0' , '11.8500' , '11.85' , '0' , '0' , '11.85' ) 26/05/2022 05:37:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8098' AND id_supplier = '' 26/05/2022 05:37:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8098' , '' , '1' ) 26/05/2022 05:37:32 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 ( '58440' , '8102' , 'POLO BLU MM - COTONE - XXL - OGGETTI' , '5' , '5' , '0' , '10.5000' , '10.5' , '0' , '0' , '52.50' ) 26/05/2022 05:37:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8102' AND id_supplier = '' 26/05/2022 05:37:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8102' , '' , '1' ) 26/05/2022 05:37:32 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 ( '58440' , '12766' , 'CLERGY CELESTE MISTO MM - S' , '1' , '1' , '0' , '11.6500' , '11.65' , '0' , '0' , '11.65' ) 26/05/2022 05:37:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12766' AND id_supplier = '' 26/05/2022 05:37:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12766' , '' , '1' ) 26/05/2022 05:37: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 ( '58440' , '2177' , 'CLERGY CELESTE MISTO MM - M' , '2' , '2' , '0' , '11.6500' , '11.65' , '0' , '0' , '23.30' ) 26/05/2022 05:37:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2177' AND id_supplier = '' 26/05/2022 05:37:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2177' , '' , '1' ) 26/05/2022 05:37: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 ( '58440' , '14297' , 'CLERGY NERO ML - MISTO - S' , '2' , '2' , '0' , '11.6500' , '11.65' , '0' , '0' , '23.30' ) 26/05/2022 05:37:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14297' AND id_supplier = '' 26/05/2022 05:37:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14297' , '' , '1' ) 26/05/2022 05:37: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 ( '58440' , '2304' , 'CLERGY GRIGIO MISTO ML - XXL' , '2' , '2' , '0' , '11.6500' , '11.65' , '0' , '0' , '23.30' ) 26/05/2022 05:37:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2304' AND id_supplier = '' 26/05/2022 05:37:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2304' , '' , '1' ) 26/05/2022 05:37: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 ( '58440' , '14299' , 'CLERGY BIANCO MM - MISTO - XL' , '1' , '1' , '0' , '11.6500' , '11.65' , '0' , '0' , '11.65' ) 26/05/2022 05:37:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14299' AND id_supplier = '' 26/05/2022 05:37:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14299' , '' , '1' ) 26/05/2022 05:37: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 ( '58440' , '14300' , 'CLERGY BIANCO MM - MISTO - L' , '1' , '1' , '0' , '11.6500' , '11.65' , '0' , '0' , '11.65' ) 26/05/2022 05:37:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14300' AND id_supplier = '' 26/05/2022 05:37:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14300' , '' , '1' ) 26/05/2022 05:37: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 ( '58440' , '14301' , 'CLERGY BIANCO MM - MISTO - M' , '1' , '1' , '0' , '11.6500' , '11.65' , '0' , '0' , '11.65' ) 26/05/2022 05:37:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14301' AND id_supplier = '' 26/05/2022 05:37:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14301' , '' , '1' ) 26/05/2022 05:37: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 ( '58440' , '14302' , 'CLERGY BIANCO MM - MISTO - 3XL' , '1' , '1' , '0' , '13.7500' , '13.75' , '0' , '0' , '13.75' ) 26/05/2022 05:37:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14302' AND id_supplier = '' 26/05/2022 05:37:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14302' , '' , '1' ) 26/05/2022 05:37: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 ( '58440' , '14303' , 'CLERGY BIANCO MM - MISTO - XXL' , '3' , '3' , '0' , '11.6500' , '11.65' , '0' , '0' , '34.95' ) 26/05/2022 05:37:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14303' AND id_supplier = '' 26/05/2022 05:37:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14303' , '' , '1' ) 26/05/2022 05:46:41 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' , '80/2022' , '2022-05-26' , '2022' , '0' , '77' , '2672' , 'UL. MALBORSKA, 8 42200 CZESTOCHOWA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '1249.00' , '1249.00' , NOW() , NOW() ) 26/05/2022 05:46:41 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 = '58460' 26/05/2022 05:46:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '58460' 26/05/2022 05:46:41 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 ( '58460' , '19594' , 'POLO JERSEY COTONE 100%' , '48' , '48' , '0' , '16' , '16' , '' , '0' , '768.0000' ) 26/05/2022 05:46:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19594' AND id_supplier = '77' 26/05/2022 05:46:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19594' , '77' , '1' ) 26/05/2022 05:46:41 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 ( '58460' , '19595' , 'POLO JERSEY COTONE 100% - EXTRA' , '26' , '26' , '0' , '18.5' , '18.5' , '' , '0' , '481.0000' ) 26/05/2022 05:46:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19595' AND id_supplier = '77' 26/05/2022 05:46:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19595' , '77' , '1' ) 26/05/2022 05:54:02 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000851' AND id_product != '8082' AND ean13 != '' 26/05/2022 05:54:02 pm >> UPDATE ps_product SET id_supplier = '77', reference = '2016', ean13 = '000851', date_upd = NOW() WHERE id_product = '8082' 26/05/2022 05:54:02 pm >> UPDATE ps_product_lang SET name = 'POLO LIMITED ', description = '' WHERE id_product = '8082' 26/05/2022 05:54:02 pm >> UPDATE ps_product SET wholesale_price = '12.00', on_sale = '0', price = '23.7705' WHERE id_product = '8082' 26/05/2022 05:54:02 pm >> UPDATE ps_product_shop SET wholesale_price = '12.00', price = '23.7705', id_tax_rules_group = '1', id_category_default = '253', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '8082' 26/05/2022 05:54:02 pm >> DELETE FROM ps_specific_price WHERE id_product = '8082' 26/05/2022 05:54:39 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000853' AND id_product != '8079' AND ean13 != '' 26/05/2022 05:54:39 pm >> UPDATE ps_product SET id_supplier = '', reference = '2016', ean13 = '000853', date_upd = NOW() WHERE id_product = '8079' 26/05/2022 05:54:39 pm >> UPDATE ps_product_lang SET name = 'POLO LIMITED EXTRA', description = '' WHERE id_product = '8079' 26/05/2022 05:54:39 pm >> UPDATE ps_product SET wholesale_price = '10.75', on_sale = '0', price = 'NaN' WHERE id_product = '8079' 26/05/2022 05:54:39 pm >> UPDATE ps_product_shop SET wholesale_price = '10.75', price = 'NaN', id_tax_rules_group = '1', id_category_default = '253', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '8079' 26/05/2022 05:54:39 pm >> DELETE FROM ps_specific_price WHERE id_product = '8079' 26/05/2022 05:56:48 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000853' AND id_product != '8079' AND ean13 != '' 26/05/2022 05:56:48 pm >> UPDATE ps_product SET id_supplier = '', reference = '2016', ean13 = '000853', date_upd = NOW() WHERE id_product = '8079' 26/05/2022 05:56:48 pm >> UPDATE ps_product_lang SET name = 'POLO LIMITED EXTRA', description = '' WHERE id_product = '8079' 26/05/2022 05:56:48 pm >> UPDATE ps_product SET wholesale_price = '10.75', on_sale = '0', price = '26.639344262295083' WHERE id_product = '8079' 26/05/2022 05:56:48 pm >> UPDATE ps_product_shop SET wholesale_price = '10.75', price = '26.639344262295083', id_tax_rules_group = '1', id_category_default = '253', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '8079' 26/05/2022 05:56:48 pm >> DELETE FROM ps_specific_price WHERE id_product = '8079' 26/05/2022 05:57:24 pm >> UPDATE ps_document SET id_document_type = '31', document_num = '68/2017', document_date = '2017-05-04', document_letter = '2017', id_customer = '0', id_supplier = '', id_address = '2672', address1 = 'UL. MALBORSKA, 8 42200 CZESTOCHOWA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '0', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '790.60', price_tax_excluded = '790.60', date_upd = NOW() WHERE id_document = '2322' 26/05/2022 05:57:25 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '2322' 26/05/2022 05:57:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '2322' 26/05/2022 05:57:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '2322' , '8123' , 'CLERGY QUADRI - XL' , '3' , '3' , '0' , '15.9000' , '15.9' , '0' , '0' , '47.70' ) 26/05/2022 05:57:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8123' AND id_supplier = '' 26/05/2022 05:57:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8123' , '' , '1' ) 26/05/2022 05:57:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '2322' , '8122' , 'CLERGY QUADRI - L' , '3' , '3' , '0' , '15.9000' , '15.9' , '0' , '0' , '47.70' ) 26/05/2022 05:57:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8122' AND id_supplier = '' 26/05/2022 05:57:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8122' , '' , '1' ) 26/05/2022 05:57:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '2322' , '8121' , 'CLERGY QUADRI - M' , '3' , '3' , '0' , '15.9000' , '15.9' , '0' , '0' , '47.70' ) 26/05/2022 05:57:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8121' AND id_supplier = '' 26/05/2022 05:57:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8121' , '' , '1' ) 26/05/2022 05:57:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '2322' , '8139' , 'CLERGY QUADRI - XXL' , '3' , '3' , '0' , '15.9000' , '15.9' , '0' , '0' , '47.70' ) 26/05/2022 05:57:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8139' AND id_supplier = '' 26/05/2022 05:57:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8139' , '' , '1' ) 26/05/2022 05:57:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '2322' , '8120' , 'CLERGY QUADRI - 3XL' , '2' , '2' , '0' , '18.8000' , '18.8' , '0' , '0' , '37.60' ) 26/05/2022 05:57:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8120' AND id_supplier = '' 26/05/2022 05:57:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8120' , '' , '1' ) 26/05/2022 05:57:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '2322' , '8082' , 'POLO LIMITED ' , '31' , '31' , '0' , '10.75' , '10.75' , '' , '0' , '333.2500' ) 26/05/2022 05:57:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8082' AND id_supplier = '' 26/05/2022 05:57:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8082' , '' , '1' ) 26/05/2022 05:57:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '2322' , '8079' , 'POLO LIMITED EXTRA' , '19' , '19' , '0' , '12.05' , '12.05' , '' , '0' , '228.9500' ) 26/05/2022 05:57:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8079' AND id_supplier = '' 26/05/2022 05:57:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8079' , '' , '1' ) 26/05/2022 06:03:14 pm >> DELETE FROM ps_document WHERE id_document = '58440' 26/05/2022 06:03:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '58440' 26/05/2022 06:04:19 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000327' AND id_product != '8147' AND ean13 != '' 26/05/2022 06:04:19 pm >> UPDATE ps_product SET id_supplier = '77', reference = '2013', ean13 = '000327', date_upd = NOW() WHERE id_product = '8147' 26/05/2022 06:04:19 pm >> UPDATE ps_product_lang SET name = 'POLO BASIC', description = '' WHERE id_product = '8147' 26/05/2022 06:04:19 pm >> UPDATE ps_product SET wholesale_price = '10.50', on_sale = '0', price = '22.1300' WHERE id_product = '8147' 26/05/2022 06:04:19 pm >> UPDATE ps_product_shop SET wholesale_price = '10.50', price = '22.1300', id_tax_rules_group = '1', id_category_default = '253', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '8147' 26/05/2022 06:04:19 pm >> DELETE FROM ps_specific_price WHERE id_product = '8147' 26/05/2022 06:07:43 pm >> UPDATE ps_document SET id_document_type = '31', document_num = '65/2018', document_date = '2018-04-23', document_letter = '2018', id_customer = '0', id_supplier = '', id_address = '2672', address1 = 'UL. MALBORSKA, 8 42200 CZESTOCHOWA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '134.20', price_tax_excluded = '134.20', date_upd = NOW() WHERE id_document = '7939' 26/05/2022 06:07:43 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '7939' 26/05/2022 06:07:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '7939' 26/05/2022 06:07:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '7939' , '8082' , 'POLO LIMITED ' , '8' , '8' , '0' , '10.75' , '10.75' , '' , '0' , '86.0000' ) 26/05/2022 06:07:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8082' AND id_supplier = '' 26/05/2022 06:07:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8082' , '' , '1' ) 26/05/2022 06:07:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '7939' , '8079' , 'POLO LIMITED EXTRA' , '4' , '4' , '0' , '12.05' , '12.05' , '' , '0' , '48.2000' ) 26/05/2022 06:07:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8079' AND id_supplier = '' 26/05/2022 06:07:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8079' , '' , '1' ) 26/05/2022 06:10:43 pm >> UPDATE ps_document SET id_document_type = '31', document_num = '138/2018', document_date = '2018-07-12', document_letter = '2018', id_customer = '0', id_supplier = '', id_address = '2672', address1 = 'UL. MALBORSKA, 8 42200 CZESTOCHOWA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '429.05', price_tax_excluded = '429.05', date_upd = NOW() WHERE id_document = '9910' 26/05/2022 06:10:43 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '9910' 26/05/2022 06:10:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '9910' 26/05/2022 06:10:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '9910' , '12766' , 'CLERGY CELESTE MISTO MM - S' , '1' , '1' , '0' , '11.6500' , '11.65' , '0' , '0' , '11.65' ) 26/05/2022 06:10:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12766' AND id_supplier = '' 26/05/2022 06:10:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12766' , '' , '1' ) 26/05/2022 06:10:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '9910' , '2177' , 'CLERGY CELESTE MISTO MM - M' , '2' , '2' , '0' , '11.6500' , '11.65' , '0' , '0' , '23.30' ) 26/05/2022 06:10:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2177' AND id_supplier = '' 26/05/2022 06:10:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2177' , '' , '1' ) 26/05/2022 06:10:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '9910' , '14297' , 'CLERGY NERO ML - MISTO - S' , '2' , '2' , '0' , '11.6500' , '11.65' , '0' , '0' , '23.30' ) 26/05/2022 06:10:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14297' AND id_supplier = '' 26/05/2022 06:10:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14297' , '' , '1' ) 26/05/2022 06:10:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '9910' , '2304' , 'CLERGY GRIGIO MISTO ML - XXL' , '2' , '2' , '0' , '11.6500' , '11.65' , '0' , '0' , '23.30' ) 26/05/2022 06:10:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2304' AND id_supplier = '' 26/05/2022 06:10:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2304' , '' , '1' ) 26/05/2022 06:10:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '9910' , '14299' , 'CLERGY BIANCO MM - MISTO - XL' , '1' , '1' , '0' , '11.6500' , '11.65' , '0' , '0' , '11.65' ) 26/05/2022 06:10:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14299' AND id_supplier = '' 26/05/2022 06:10:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14299' , '' , '1' ) 26/05/2022 06:10:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '9910' , '14300' , 'CLERGY BIANCO MM - MISTO - L' , '1' , '1' , '0' , '11.6500' , '11.65' , '0' , '0' , '11.65' ) 26/05/2022 06:10:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14300' AND id_supplier = '' 26/05/2022 06:10:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14300' , '' , '1' ) 26/05/2022 06:10:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '9910' , '14301' , 'CLERGY BIANCO MM - MISTO - M' , '1' , '1' , '0' , '11.6500' , '11.65' , '0' , '0' , '11.65' ) 26/05/2022 06:10:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14301' AND id_supplier = '' 26/05/2022 06:10:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14301' , '' , '1' ) 26/05/2022 06:10:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '9910' , '14302' , 'CLERGY BIANCO MM - MISTO - 3XL' , '1' , '1' , '0' , '13.7500' , '13.75' , '0' , '0' , '13.75' ) 26/05/2022 06:10:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14302' AND id_supplier = '' 26/05/2022 06:10:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14302' , '' , '1' ) 26/05/2022 06:10:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '9910' , '14303' , 'CLERGY BIANCO MM - MISTO - XXL' , '3' , '3' , '0' , '11.6500' , '11.65' , '0' , '0' , '34.95' ) 26/05/2022 06:10:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14303' AND id_supplier = '' 26/05/2022 06:10:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14303' , '' , '1' ) 26/05/2022 06:10:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '9910' , '8147' , 'POLO BASIC' , '21' , '21' , '0' , '10.5' , '10.5' , '' , '0' , '220.5000' ) 26/05/2022 06:10:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8147' AND id_supplier = '' 26/05/2022 06:10:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8147' , '' , '1' ) 26/05/2022 06:10:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '9910' , '8147' , 'POLO BASIC' , '1' , '1' , '0' , '11.85' , '11.85' , '' , '0' , '11.8500' ) 26/05/2022 06:10:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8147' AND id_supplier = '' 26/05/2022 06:10:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8147' , '' , '1' ) 26/05/2022 06:10:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '9910' , '8082' , 'POLO LIMITED ' , '3' , '3' , '0' , '10.5' , '10.5' , '' , '0' , '31.5000' ) 26/05/2022 06:10:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8082' AND id_supplier = '' 26/05/2022 06:10:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8082' , '' , '1' ) 26/05/2022 06:18:27 pm >> UPDATE ps_document SET id_document_type = '31', document_num = '68/2019', document_date = '2019-04-26', document_letter = '2019', id_customer = '0', id_supplier = '', id_address = '2672', address1 = 'UL. MALBORSKA, 8 42200 CZESTOCHOWA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '9', id_causal = '0', price_tax_included = '852.45', price_tax_excluded = '852.45', date_upd = NOW() WHERE id_document = '19371' 26/05/2022 06:18:27 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 = '19371' 26/05/2022 06:18:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '19371' 26/05/2022 06:18:27 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 ( '19371' , '15683' , 'CLERGY GRIGIO CHIARO MM - S' , '1' , '1' , '0' , '11.6500' , '11.65' , '0' , '0' , '11.65' ) 26/05/2022 06:18:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15683' AND id_supplier = '' 26/05/2022 06:18:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15683' , '' , '1' ) 26/05/2022 06:18:27 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 ( '19371' , '2262' , 'CLERGY GRIGIO CHIARO MISTO MM - M - OGGETTI' , '2' , '2' , '0' , '11.6500' , '11.65' , '0' , '0' , '23.30' ) 26/05/2022 06:18:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2262' AND id_supplier = '' 26/05/2022 06:18:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2262' , '' , '1' ) 26/05/2022 06:18:27 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 ( '19371' , '15682' , 'CLERGY GRIGIO CHIARO MM - XL ' , '3' , '3' , '0' , '11.6500' , '11.65' , '0' , '0' , '34.95' ) 26/05/2022 06:18:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15682' AND id_supplier = '' 26/05/2022 06:18:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15682' , '' , '1' ) 26/05/2022 06:18:27 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 ( '19371' , '2257' , 'CLERGY GRIGIO CHIARO MISTO MM - 3XL' , '1' , '1' , '0' , '13.7500' , '13.75' , '0' , '0' , '13.75' ) 26/05/2022 06:18:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2257' AND id_supplier = '' 26/05/2022 06:18:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2257' , '' , '1' ) 26/05/2022 06:18:27 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 ( '19371' , '12761' , 'CLERGY GRIGIO MM - L' , '1' , '1' , '0' , '11.6500' , '11.65' , '0' , '0' , '11.65' ) 26/05/2022 06:18:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12761' AND id_supplier = '' 26/05/2022 06:18:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12761' , '' , '1' ) 26/05/2022 06:18:27 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 ( '19371' , '12765' , 'CLERGY GRIGIO MM - 3XL' , '2' , '2' , '0' , '13.7500' , '13.75' , '0' , '0' , '27.50' ) 26/05/2022 06:18:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12765' AND id_supplier = '' 26/05/2022 06:18:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12765' , '' , '1' ) 26/05/2022 06:18:28 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 ( '19371' , '15684' , 'CLERGY NERO MISTO MM - S' , '1' , '1' , '0' , '11.6500' , '11.65' , '0' , '0' , '11.65' ) 26/05/2022 06:18:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15684' AND id_supplier = '' 26/05/2022 06:18:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15684' , '' , '1' ) 26/05/2022 06:18:28 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 ( '19371' , '2367' , 'CLERGY NERO MISTO MM - XXL' , '1' , '1' , '0' , '11.6500' , '11.65' , '0' , '0' , '11.65' ) 26/05/2022 06:18:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2367' AND id_supplier = '' 26/05/2022 06:18:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2367' , '' , '1' ) 26/05/2022 06:18:28 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 ( '19371' , '15685' , 'CLERGY CELESTE 80% - MM - L' , '2' , '2' , '0' , '17.1500' , '17.15' , '0' , '0' , '34.30' ) 26/05/2022 06:18:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15685' AND id_supplier = '' 26/05/2022 06:18:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15685' , '' , '1' ) 26/05/2022 06:18:28 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 ( '19371' , '15689' , 'CLERGY CELESTE 80% - MM - M' , '2' , '2' , '0' , '17.1500' , '17.15' , '0' , '0' , '34.30' ) 26/05/2022 06:18:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15689' AND id_supplier = '' 26/05/2022 06:18:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15689' , '' , '1' ) 26/05/2022 06:18:28 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 ( '19371' , '15687' , 'CLERGY CELESTE 80% - MM - XL' , '2' , '2' , '0' , '17.1500' , '17.15' , '0' , '0' , '34.30' ) 26/05/2022 06:18:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15687' AND id_supplier = '' 26/05/2022 06:18:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15687' , '' , '1' ) 26/05/2022 06:18:28 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 ( '19371' , '15688' , 'CLERGY CELESTE 80% - MM - XXL' , '2' , '2' , '0' , '17.1500' , '17.15' , '0' , '0' , '34.30' ) 26/05/2022 06:18:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15688' AND id_supplier = '' 26/05/2022 06:18:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15688' , '' , '1' ) 26/05/2022 06:18:28 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 ( '19371' , '2304' , 'CLERGY GRIGIO MISTO ML - XXL' , '3' , '3' , '0' , '12.1500' , '12.15' , '0' , '0' , '36.45' ) 26/05/2022 06:18:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2304' AND id_supplier = '' 26/05/2022 06:18:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2304' , '' , '1' ) 26/05/2022 06:18:28 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 ( '19371' , '2302' , 'CLERGY GRIGIO MISTO ML - L' , '1' , '1' , '0' , '12.1500' , '12.15' , '0' , '0' , '12.15' ) 26/05/2022 06:18:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2302' AND id_supplier = '' 26/05/2022 06:18:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2302' , '' , '1' ) 26/05/2022 06:18:28 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 ( '19371' , '15690' , 'CLERGY GRIGIO CHIARO MISTO MM - S' , '1' , '1' , '0' , '12.1500' , '12.15' , '0' , '0' , '12.15' ) 26/05/2022 06:18:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15690' AND id_supplier = '' 26/05/2022 06:18:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15690' , '' , '1' ) 26/05/2022 06:18:28 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 ( '19371' , '12764' , 'CLERGY GRIGIO MM - S' , '1' , '1' , '0' , '11.6500' , '11.65' , '0' , '0' , '11.65' ) 26/05/2022 06:18:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12764' AND id_supplier = '' 26/05/2022 06:18:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12764' , '' , '1' ) 26/05/2022 06:18:28 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 ( '19371' , '14384' , 'CLERGY NERO ML - MISTO - S' , '1' , '1' , '0' , '12.1500' , '12.15' , '0' , '0' , '12.15' ) 26/05/2022 06:18:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14384' AND id_supplier = '' 26/05/2022 06:18:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14384' , '' , '1' ) 26/05/2022 06:18:28 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 ( '19371' , '2353' , 'CLERGY NERO MISTO ML - M' , '1' , '1' , '0' , '12.1500' , '12.15' , '0' , '0' , '12.15' ) 26/05/2022 06:18:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2353' AND id_supplier = '' 26/05/2022 06:18:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2353' , '' , '1' ) 26/05/2022 06:18: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 ( '19371' , '2352' , 'CLERGY NERO MISTO ML - L ' , '2' , '2' , '0' , '12.1500' , '12.15' , '0' , '0' , '24.30' ) 26/05/2022 06:18:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2352' AND id_supplier = '' 26/05/2022 06:18:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2352' , '' , '1' ) 26/05/2022 06:18: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 ( '19371' , '2354' , 'CLERGY NERO MISTO ML - XL' , '1' , '1' , '0' , '12.1500' , '12.15' , '0' , '0' , '12.15' ) 26/05/2022 06:18:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2354' AND id_supplier = '' 26/05/2022 06:18:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2354' , '' , '1' ) 26/05/2022 06:18: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 ( '19371' , '2355' , 'CLERGY NERO MISTO ML - XXL' , '3' , '3' , '0' , '12.1500' , '12.15' , '0' , '0' , '36.45' ) 26/05/2022 06:18:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2355' AND id_supplier = '' 26/05/2022 06:18:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2355' , '' , '1' ) 26/05/2022 06:18: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 ( '19371' , '2363' , 'CLERGY NERO MISTO MM - M' , '1' , '1' , '0' , '11.6500' , '11.65' , '0' , '0' , '11.65' ) 26/05/2022 06:18:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2363' AND id_supplier = '' 26/05/2022 06:18:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2363' , '' , '1' ) 26/05/2022 06:18: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 ( '19371' , '8082' , 'POLO LIMITED ' , '30' , '30' , '0' , '11.25' , '11.25' , '' , '0' , '337.5000' ) 26/05/2022 06:18:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8082' AND id_supplier = '' 26/05/2022 06:18:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8082' , '' , '1' ) 26/05/2022 06:18: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 ( '19371' , '8079' , 'POLO LIMITED EXTRA' , '4' , '4' , '0' , '12.6' , '12.6' , '' , '0' , '50.4000' ) 26/05/2022 06:18:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8079' AND id_supplier = '' 26/05/2022 06:18:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8079' , '' , '1' ) 26/05/2022 06:22:31 pm >> UPDATE ps_document SET id_document_type = '31', document_num = '100/2020', document_date = '2020-06-19', document_letter = '2020', id_customer = '0', id_supplier = '', id_address = '2672', address1 = 'UL. MALBORSKA, 8 42200 CZESTOCHOWA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '1024.20', price_tax_excluded = '1024.20', date_upd = NOW() WHERE id_document = '24310' 26/05/2022 06:22:31 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 = '24310' 26/05/2022 06:22:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '24310' 26/05/2022 06:22:31 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 ( '24310' , '2168' , 'CLERGY CELESTE MISTO ML - M ' , '2' , '2' , '0' , '12.6500' , '12.65' , '0' , '0' , '25.30' ) 26/05/2022 06:22:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2168' AND id_supplier = '' 26/05/2022 06:22:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2168' , '' , '1' ) 26/05/2022 06:22:31 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 ( '24310' , '2255' , 'CLERGY GRIGIO CHIARO MISTO ML - XL - OGGETTI' , '2' , '2' , '0' , '12.6500' , '12.65' , '0' , '0' , '25.30' ) 26/05/2022 06:22:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2255' AND id_supplier = '' 26/05/2022 06:22:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2255' , '' , '1' ) 26/05/2022 06:22:31 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 ( '24310' , '2353' , 'CLERGY NERO MISTO ML - M' , '1' , '1' , '0' , '12.6500' , '12.65' , '0' , '0' , '12.65' ) 26/05/2022 06:22:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2353' AND id_supplier = '' 26/05/2022 06:22:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2353' , '' , '1' ) 26/05/2022 06:22:31 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 ( '24310' , '2303' , 'CLERGY GRIGIO MISTO ML - XL' , '2' , '2' , '0' , '12.6500' , '12.65' , '0' , '0' , '25.30' ) 26/05/2022 06:22:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2303' AND id_supplier = '' 26/05/2022 06:22:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2303' , '' , '1' ) 26/05/2022 06:22:31 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 ( '24310' , '14385' , 'CLERGY GRIGIO MISTO ML - S' , '1' , '1' , '0' , '12.6500' , '12.65' , '0' , '0' , '12.65' ) 26/05/2022 06:22:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14385' AND id_supplier = '' 26/05/2022 06:22:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14385' , '' , '1' ) 26/05/2022 06:22:31 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 ( '24310' , '12762' , 'CLERGY GRIGIO MM - XL' , '2' , '2' , '0' , '12.1500' , '12.15' , '0' , '0' , '24.30' ) 26/05/2022 06:22:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12762' AND id_supplier = '' 26/05/2022 06:22:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12762' , '' , '1' ) 26/05/2022 06:22:31 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 ( '24310' , '15683' , 'CLERGY GRIGIO CHIARO MM - S' , '1' , '1' , '0' , '12.1500' , '12.15' , '0' , '0' , '12.15' ) 26/05/2022 06:22:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15683' AND id_supplier = '' 26/05/2022 06:22:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15683' , '' , '1' ) 26/05/2022 06:22:31 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 ( '24310' , '2176' , 'CLERGY CELESTE MISTO MM - L ' , '2' , '2' , '0' , '12.1500' , '12.15' , '0' , '0' , '24.30' ) 26/05/2022 06:22:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2176' AND id_supplier = '' 26/05/2022 06:22:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2176' , '' , '1' ) 26/05/2022 06:22:31 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 ( '24310' , '2367' , 'CLERGY NERO MISTO MM - XXL' , '3' , '3' , '0' , '12.1500' , '12.15' , '0' , '0' , '36.45' ) 26/05/2022 06:22:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2367' AND id_supplier = '' 26/05/2022 06:22:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2367' , '' , '1' ) 26/05/2022 06:22:31 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 ( '24310' , '8082' , 'POLO LIMITED ' , '57' , '57' , '0' , '11.5' , '11.5' , '' , '0' , '655.5000' ) 26/05/2022 06:22:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8082' AND id_supplier = '' 26/05/2022 06:22:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8082' , '' , '1' ) 26/05/2022 06:22:31 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 ( '24310' , '8079' , 'POLO LIMITED EXTRA' , '13' , '13' , '0' , '13.1' , '13.1' , '' , '0' , '170.3000' ) 26/05/2022 06:22:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8079' AND id_supplier = '' 26/05/2022 06:22:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8079' , '' , '1' ) 26/05/2022 06:23:37 pm >> UPDATE ps_document SET id_document_type = '31', document_num = '77/2021', document_date = '2021-05-25', document_letter = '2021', id_customer = '0', id_supplier = '', id_address = '2672', address1 = 'UL. MALBORSKA, 8 42200 CZESTOCHOWA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '890.25', price_tax_excluded = '890.25', date_upd = NOW() WHERE id_document = '28970' 26/05/2022 06:23:37 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 = '28970' 26/05/2022 06:23:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '28970' 26/05/2022 06:23:37 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 ( '28970' , '18243' , 'CLERGY GRIGIO NIDO DAPE MM - M' , '3' , '3' , '0' , '16.6500' , '16.65' , '0' , '0' , '49.95' ) 26/05/2022 06:23:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18243' AND id_supplier = '' 26/05/2022 06:23:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18243' , '' , '1' ) 26/05/2022 06:23:37 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 ( '28970' , '18244' , 'CLERGY GRIGIO NIDO DAPE MM - XXL' , '3' , '3' , '0' , '16.6500' , '16.65' , '0' , '0' , '49.95' ) 26/05/2022 06:23:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18244' AND id_supplier = '' 26/05/2022 06:23:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18244' , '' , '1' ) 26/05/2022 06:23:37 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 ( '28970' , '18245' , 'CLERGY GRIGIO NIDO DAPE MM - 3XL' , '2' , '2' , '0' , '18.1500' , '18.15' , '0' , '0' , '36.30' ) 26/05/2022 06:23:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18245' AND id_supplier = '' 26/05/2022 06:23:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18245' , '' , '1' ) 26/05/2022 06:23:37 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 ( '28970' , '18246' , 'CLERGY JEANS NIDO DAPE MM - S' , '1' , '1' , '0' , '16.6500' , '16.65' , '0' , '0' , '16.65' ) 26/05/2022 06:23:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18246' AND id_supplier = '' 26/05/2022 06:23:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18246' , '' , '1' ) 26/05/2022 06:23:37 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 ( '28970' , '18247' , 'CLERGY JEANS NIDO DAPE MM - M' , '3' , '3' , '0' , '16.6500' , '16.65' , '0' , '0' , '49.95' ) 26/05/2022 06:23:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18247' AND id_supplier = '' 26/05/2022 06:23:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18247' , '' , '1' ) 26/05/2022 06:23:37 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 ( '28970' , '18248' , 'CLERGY JEANS NIDO DAPE MM - L' , '3' , '3' , '0' , '16.6500' , '16.65' , '0' , '0' , '49.95' ) 26/05/2022 06:23:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18248' AND id_supplier = '' 26/05/2022 06:23:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18248' , '' , '1' ) 26/05/2022 06:23:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '28970' , '18249' , 'CLERGY JEANS NIDO DAPE MM - XL' , '3' , '3' , '0' , '16.6500' , '16.65' , '0' , '0' , '49.95' ) 26/05/2022 06:23:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18249' AND id_supplier = '' 26/05/2022 06:23:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18249' , '' , '1' ) 26/05/2022 06:23:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '28970' , '18250' , 'CLERGY JEANS NIDO DAPE MM - XXL' , '3' , '3' , '0' , '16.6500' , '16.65' , '0' , '0' , '49.95' ) 26/05/2022 06:23:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18250' AND id_supplier = '' 26/05/2022 06:23:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18250' , '' , '1' ) 26/05/2022 06:23:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '28970' , '18251' , 'CLERGY JEANS NIDO DAPE MM - 3XL' , '2' , '2' , '0' , '18.1500' , '18.15' , '0' , '0' , '36.30' ) 26/05/2022 06:23:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18251' AND id_supplier = '' 26/05/2022 06:23:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18251' , '' , '1' ) 26/05/2022 06:23:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '28970' , '18252' , 'CLERGY BLU NIDO DAPE MM - M' , '3' , '3' , '0' , '16.6500' , '16.65' , '0' , '0' , '49.95' ) 26/05/2022 06:23:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18252' AND id_supplier = '' 26/05/2022 06:23:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18252' , '' , '1' ) 26/05/2022 06:23:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '28970' , '18253' , 'CLERGY BLU NIDO DAPE MM - L' , '3' , '3' , '0' , '16.6500' , '16.65' , '0' , '0' , '49.95' ) 26/05/2022 06:23:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18253' AND id_supplier = '' 26/05/2022 06:23:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18253' , '' , '1' ) 26/05/2022 06:23:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '28970' , '18254' , 'CLERGY BLU NIDO DAPE MM - XL' , '3' , '3' , '0' , '16.6500' , '16.65' , '0' , '0' , '49.95' ) 26/05/2022 06:23:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18254' AND id_supplier = '' 26/05/2022 06:23:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18254' , '' , '1' ) 26/05/2022 06:23:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '28970' , '18255' , 'CLERGY BLU NIDO DAPE MM - XXL' , '3' , '3' , '0' , '16.6500' , '16.65' , '0' , '0' , '49.95' ) 26/05/2022 06:23:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18255' AND id_supplier = '' 26/05/2022 06:23:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18255' , '' , '1' ) 26/05/2022 06:23:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '28970' , '18256' , 'CLERGY BLU NIDO DAPE MM - 3XL' , '2' , '2' , '0' , '18.1500' , '18.15' , '0' , '0' , '36.30' ) 26/05/2022 06:23:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18256' AND id_supplier = '' 26/05/2022 06:23:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18256' , '' , '1' ) 26/05/2022 06:23:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '28970' , '18257' , 'CLERGY BLU NIDO DAPE MM - S' , '1' , '1' , '0' , '16.6500' , '16.65' , '0' , '0' , '16.65' ) 26/05/2022 06:23:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18257' AND id_supplier = '' 26/05/2022 06:23:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18257' , '' , '1' ) 26/05/2022 06:23:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '28970' , '18258' , 'CLERGY GRIGIO NIDO DAPE MM - S' , '1' , '1' , '0' , '16.6500' , '16.65' , '0' , '0' , '16.65' ) 26/05/2022 06:23:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18258' AND id_supplier = '' 26/05/2022 06:23:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18258' , '' , '1' ) 26/05/2022 06:23:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '28970' , '18259' , 'CLERGY GRIGIO NIDO DAPE MM - L' , '3' , '3' , '0' , '16.6500' , '16.65' , '0' , '0' , '49.95' ) 26/05/2022 06:23:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18259' AND id_supplier = '' 26/05/2022 06:23:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18259' , '' , '1' ) 26/05/2022 06:23:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '28970' , '18260' , 'CLERGY GRIGIO NIDO DAPE MM - XL' , '3' , '3' , '0' , '16.6500' , '16.65' , '0' , '0' , '49.95' ) 26/05/2022 06:23:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18260' AND id_supplier = '' 26/05/2022 06:23:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18260' , '' , '1' ) 26/05/2022 06:23:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '28970' , '8082' , 'POLO LIMITED ' , '11' , '11' , '0' , '12' , '12' , '' , '0' , '132.0000' ) 26/05/2022 06:23:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8082' AND id_supplier = '' 26/05/2022 06:23:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8082' , '' , '1' ) 26/05/2022 06:24:21 pm >> UPDATE ps_document SET id_document_type = '31', document_num = '80/2022', document_date = '2022-05-26', document_letter = '2022', id_customer = '0', id_supplier = '', id_address = '2672', address1 = 'UL. MALBORSKA, 8 42200 CZESTOCHOWA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '1357.00', price_tax_excluded = '1357.00', date_upd = NOW() WHERE id_document = '58460' 26/05/2022 06:24:21 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 = '58460' 26/05/2022 06:24:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '58460' 26/05/2022 06:24:21 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 ( '58460' , '19594' , 'POLO JERSEY COTONE 100%' , '48' , '48' , '0' , '16.0000' , '16' , '0' , '0' , '768.00' ) 26/05/2022 06:24:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19594' AND id_supplier = '' 26/05/2022 06:24:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19594' , '' , '1' ) 26/05/2022 06:24:21 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 ( '58460' , '19595' , 'POLO JERSEY COTONE 100% - EXTRA' , '26' , '26' , '0' , '18.5000' , '18.5' , '0' , '0' , '481.00' ) 26/05/2022 06:24:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19595' AND id_supplier = '' 26/05/2022 06:24:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19595' , '' , '1' ) 26/05/2022 06:24:21 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 ( '58460' , '8082' , 'POLO LIMITED ' , '9' , '9' , '0' , '12' , '12' , '' , '0' , '108.0000' ) 26/05/2022 06:24:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8082' AND id_supplier = '' 26/05/2022 06:24:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8082' , '' , '1' ) 26/05/2022 06:27:00 pm >> UPDATE ps_document SET id_document_type = '31', document_num = '151/2018', document_date = '2018-07-24', document_letter = '2018', id_customer = '0', id_supplier = '', id_address = '2672', address1 = 'UL. MALBORSKA, 8 42200 CZESTOCHOWA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '283.80', price_tax_excluded = '283.80', date_upd = NOW() WHERE id_document = '10016' 26/05/2022 06:27:00 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '10016' 26/05/2022 06:27:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '10016' 26/05/2022 06:27:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '10016' , '8147' , 'POLO BASIC' , '18' , '18' , '0' , '10.5' , '10.5' , '' , '0' , '189.0000' ) 26/05/2022 06:27:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8147' AND id_supplier = '' 26/05/2022 06:27:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8147' , '' , '1' ) 26/05/2022 06:27:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '10016' , '8147' , 'POLO BASIC' , '8' , '8' , '0' , '11.85' , '11.85' , '' , '0' , '94.8000' ) 26/05/2022 06:27:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8147' AND id_supplier = '' 26/05/2022 06:27:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8147' , '' , '1' ) 26/05/2022 06:36:12 pm >> SELECT document_num FROM ps_document WHERE document_num = '1666' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-26') 26/05/2022 06:36: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' , '1666' , '2022-05-26' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '38.00' , '38.00' , NOW() , NOW() ) 26/05/2022 06:36: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 = '58461' 26/05/2022 06:36:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '58461' 26/05/2022 06:36: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 ( '58461' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '38' , '38' , '0' , '0' , '38.00' ) 26/05/2022 06:36:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 26/05/2022 06:36:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 26/05/2022 06:52:25 pm >> SELECT document_num FROM ps_document WHERE document_num = '1667' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-26') 26/05/2022 06:52:25 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1667' , '2022-05-26' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '34.00' , '27.87' , NOW() , NOW() ) 26/05/2022 06:52:25 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58462' 26/05/2022 06:52:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '58462' 26/05/2022 06:52:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58462' , '3137' , 'CROCE TAU VETRO DEC. G. MATTIOLI' , '1' , '-1' , '1' , '34.00' , '27.868852459016' , '22' , '0' , '34.00' ) 26/05/2022 06:52:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '3137' AND id_supplier = '' 26/05/2022 06:52:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3137' , '' , '1' )