08/07/2023 08:59:29 am >> SELECT document_num FROM ps_document WHERE document_num = '2329' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-07-08') 08/07/2023 08:59:29 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' , '2329' , '2023-07-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.45' , '10.45' , NOW() , NOW() ) 08/07/2023 08:59:29 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 = '86680' 08/07/2023 08:59:29 am >> DELETE FROM ps_document_detail WHERE id_document = '86680' 08/07/2023 08:59:29 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 ( '86680' , '21116' , 'LIBERTA DI ANTONIO - L. EPICOCO' , '1' , '-1' , '4' , '11.00' , '11' , '0' , '5' , '10.45' ) 08/07/2023 09:30:33 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788810820568' AND id_product != '1147' AND ean13 != '' 08/07/2023 09:30:33 am >> UPDATE ps_product SET id_supplier = '109', reference = '11/1', ean13 = '9788810820568', date_upd = NOW() WHERE id_product = '1147' 08/07/2023 09:30:33 am >> UPDATE ps_product_lang SET name = 'BIBBIA DI GERUSALEMME X STUDIO', description = '' WHERE id_product = '1147' 08/07/2023 09:30:33 am >> UPDATE ps_product SET wholesale_price = '25.81', on_sale = '0', price = '46' WHERE id_product = '1147' 08/07/2023 09:30:33 am >> UPDATE ps_product_shop SET wholesale_price = '25.81', price = '46', id_tax_rules_group = '4', id_category_default = '9', id_argoment_default = '170', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '1147' 08/07/2023 09:30:33 am >> DELETE FROM ps_specific_price WHERE id_product = '1147' 08/07/2023 09:30:56 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788810820346' AND id_product != '1142' AND ean13 != '' 08/07/2023 09:30:56 am >> UPDATE ps_product SET id_supplier = '109', reference = '11/1', ean13 = '9788810820346', date_upd = NOW() WHERE id_product = '1142' 08/07/2023 09:30:56 am >> UPDATE ps_product_lang SET name = 'BIBBIA DI GERUSALEMME - TASC.', description = '' WHERE id_product = '1142' 08/07/2023 09:30:56 am >> UPDATE ps_product SET wholesale_price = '19.01', on_sale = '0', price = '31' WHERE id_product = '1142' 08/07/2023 09:30:56 am >> UPDATE ps_product_shop SET wholesale_price = '19.01', price = '31', id_tax_rules_group = '4', id_category_default = '9', id_argoment_default = '170', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '1142' 08/07/2023 09:30:56 am >> DELETE FROM ps_specific_price WHERE id_product = '1142' 08/07/2023 09:31:20 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788810820353' AND id_product != '1145' AND ean13 != '' 08/07/2023 09:31:20 am >> UPDATE ps_product SET id_supplier = '109', reference = '11/1', ean13 = '9788810820353', date_upd = NOW() WHERE id_product = '1145' 08/07/2023 09:31:20 am >> UPDATE ps_product_lang SET name = 'BIBBIA DI GERUSALEMME BOTT. TASC.', description = '' WHERE id_product = '1145' 08/07/2023 09:31:20 am >> UPDATE ps_product SET wholesale_price = '24.74', on_sale = '0', price = '42' WHERE id_product = '1145' 08/07/2023 09:31:20 am >> UPDATE ps_product_shop SET wholesale_price = '24.74', price = '42', id_tax_rules_group = '4', id_category_default = '9', id_argoment_default = '170', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '1145' 08/07/2023 09:31:20 am >> DELETE FROM ps_specific_price WHERE id_product = '1145' 08/07/2023 09:32:38 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788810820353' AND id_product != '1145' AND ean13 != '' 08/07/2023 09:32:38 am >> UPDATE ps_product SET id_supplier = '109', reference = '11/1', ean13 = '9788810820353', date_upd = NOW() WHERE id_product = '1145' 08/07/2023 09:32:38 am >> UPDATE ps_product_lang SET name = 'BIBBIA DI GERUSALEMME BOTT. TASC.', description = '' WHERE id_product = '1145' 08/07/2023 09:32:38 am >> UPDATE ps_product SET wholesale_price = '24.74', on_sale = '0', price = '42' WHERE id_product = '1145' 08/07/2023 09:32:38 am >> UPDATE ps_product_shop SET wholesale_price = '24.74', price = '42', id_tax_rules_group = '4', id_category_default = '9', id_argoment_default = '170', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '1145' 08/07/2023 09:32:38 am >> DELETE FROM ps_specific_price WHERE id_product = '1145' 08/07/2023 09:37:05 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '100696' , '2023-07-04' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '12' , '0' , '190.00' , '190.00' , NOW() , NOW() ) 08/07/2023 09:37:05 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86681' 08/07/2023 09:37:05 am >> DELETE FROM ps_document_detail WHERE id_document = '86681' 08/07/2023 09:37:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86681' , '1144' , 'BIBBIA DI GERUSALEMME - TELATA' , '5' , '5' , '4' , '38.00' , '38' , '0' , '0' , '190.0000' ) 08/07/2023 09:37:05 am >> DELETE FROM ps_product_supplier WHERE id_product = '1144' AND id_supplier = '109' 08/07/2023 09:37:05 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1144' , '109' , '1' ) 08/07/2023 09:43:49 am >> SELECT document_num FROM ps_document WHERE document_num = '2330' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-07-08') 08/07/2023 09:43: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 ( '11' , '2330' , '2023-07-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.80' , '3.93' , NOW() , NOW() ) 08/07/2023 09:43: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 = '86682' 08/07/2023 09:43:49 am >> DELETE FROM ps_document_detail WHERE id_document = '86682' 08/07/2023 09:43: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 ( '86682' , '9691' , 'SCAPOLARE DEL CARMELO - PICCOLO - 1215/ITA' , '3' , '-3' , '1' , '1.10' , '0.9016393442623' , '22' , '0' , '3.30' ) 08/07/2023 09:43: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 ( '86682' , '15261' , 'MEDAGLIA SAN BENEDETTO' , '1' , '-1' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '1.50' ) 08/07/2023 10:09:51 am >> SELECT document_num FROM ps_document WHERE document_num = '2331' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2023-07-08') 08/07/2023 10:09:51 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2331' , '2023-07-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '23.75' , '23.75' , NOW() , NOW() ) 08/07/2023 10:09:51 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86683' 08/07/2023 10:09:51 am >> DELETE FROM ps_document_detail WHERE id_document = '86683' 08/07/2023 10:09:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86683' , '21037' , 'SULLA TUA PAROLA LUG/AGO 23' , '5' , '-5' , '4' , '5.00' , '5' , '0' , '5' , '23.75' ) 08/07/2023 10:14:43 am >> SELECT document_num FROM ps_document WHERE document_num = '2332' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-07-08') 08/07/2023 10:14:43 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' , '2332' , '2023-07-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '26.50' , '21.72' , NOW() , NOW() ) 08/07/2023 10:14:43 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 = '86684' 08/07/2023 10:14:43 am >> DELETE FROM ps_document_detail WHERE id_document = '86684' 08/07/2023 10:14:43 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 ( '86684' , '2935' , 'CROCE 20 CM FORATO - 4493/2' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 08/07/2023 10:14:43 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 ( '86684' , '20964' , 'STATUA SAN MICHELE - ST322-SM' , '1' , '-1' , '1' , '13.50' , '11.065573770492' , '22' , '0' , '13.50' ) 08/07/2023 10:15:33 am >> SELECT document_num FROM ps_document WHERE document_num = '48/A' AND id_document != '82684' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-04-05') 08/07/2023 10:15:33 am >> UPDATE ps_document SET id_document_type = '24', document_num = '48/A', document_date = '2023-04-05', document_letter = 'A', id_customer = '230', id_supplier = '', id_address = '4668969', address1 = 'VIA G. NICOTERA, 66 84080 PELLEZZANO', 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 = '597.20', price_tax_excluded = '489.51', date_upd = NOW() WHERE id_document = '82684' 08/07/2023 10:15: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 = '82684' 08/07/2023 10:15:33 am >> DELETE FROM ps_document_detail WHERE id_document = '82684' 08/07/2023 10:15: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 ( '82684' , '16514' , 'CROCIFISSO 105X60 - 1015' , '1' , '-1' , '1' , '300.0000' , '245.90163934426' , '22' , '0' , '300.00' ) 08/07/2023 10:15: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 ( '82684' , '0' , '20/05/2022' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 08/07/2023 10:15: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 ( '82684' , '0' , 'ROSA' , '1' , '-1' , '1' , '85.0000' , '69.672131147541' , '22' , '0' , '85.00' ) 08/07/2023 10:15: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 ( '82684' , '18217' , 'BRACCIALE DECINA PIETRE - BD019' , '4' , '-4' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '8.00' ) 08/07/2023 10:15: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 ( '82684' , '20704' , 'QUADRO 63X35' , '1' , '-1' , '1' , '98.0000' , '80.327868852459' , '22' , '0' , '98.00' ) 08/07/2023 10:15: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 ( '82684' , '19560' , 'PERGAMENA 17X25' , '16' , '-16' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '11.20' ) 08/07/2023 10:15: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 ( '82684' , '21178' , 'GEMELLO ARGENTO - GEM53' , '1' , '-1' , '1' , '74.00' , '60.655737704918' , '22' , '0' , '74.00' ) 08/07/2023 10:15: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 ( '82684' , '21179' , 'ORECCHINI ARGENTO/CRISTALLO - 5447' , '1' , '-1' , '1' , '21.00' , '17.213114754098' , '22' , '0' , '21.00' ) 08/07/2023 10:24:34 am >> SELECT document_num FROM ps_document WHERE document_num = '2333' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-07-08') 08/07/2023 10:24:35 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2333' , '2023-07-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '215.00' , '176.23' , NOW() , NOW() ) 08/07/2023 10:24:35 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86685' 08/07/2023 10:24:35 am >> DELETE FROM ps_document_detail WHERE id_document = '86685' 08/07/2023 10:24:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86685' , '17544' , 'CAMICE BAMBOO' , '1' , '-1' , '1' , '140' , '114.75409836066' , '22' , '0' , '140.00' ) 08/07/2023 10:24:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86685' , '19594' , 'POLO JERSEY COTONE 100%' , '2' , '-2' , '1' , '37.5' , '30.737704918033' , '22' , '0' , '75.00' ) 08/07/2023 10:48:54 am >> SELECT document_num FROM ps_document WHERE document_num = '2334' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-07-08') 08/07/2023 10:48:54 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' , '2334' , '2023-07-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '180.00' , '147.54' , NOW() , NOW() ) 08/07/2023 10:48:54 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 = '86686' 08/07/2023 10:48:54 am >> DELETE FROM ps_document_detail WHERE id_document = '86686' 08/07/2023 10:48:54 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 ( '86686' , '17544' , 'CAMICE BAMBOO' , '1' , '-1' , '1' , '140' , '114.75409836066' , '22' , '0' , '140.00' ) 08/07/2023 10:48:54 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 ( '86686' , '19595' , 'POLO JERSEY COTONE 100% - EXTRA' , '1' , '-1' , '1' , '40' , '32.786885245902' , '22' , '0' , '40.00' ) 08/07/2023 10:54:55 am >> SELECT document_num FROM ps_document WHERE document_num = '2335' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-07-08') 08/07/2023 10:54:55 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2335' , '2023-07-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.30' , '4.13' , NOW() , NOW() ) 08/07/2023 10:54:55 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86687' 08/07/2023 10:54:55 am >> DELETE FROM ps_document_detail WHERE id_document = '86687' 08/07/2023 10:54:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86687' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.30' , '4.1346153846154' , '4' , '0' , '4.30' ) 08/07/2023 11:03:02 am >> SELECT document_num FROM ps_document WHERE document_num = '107' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-07-08') 08/07/2023 11:03:02 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '107' , '2023-07-08' , '' , '229' , '0' , '4673704' , 'VIA TORINO 84092 BELLIZZI' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '76.50' , '76.50' , NOW() , NOW() ) 08/07/2023 11:03:02 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86688' 08/07/2023 11:03:02 am >> DELETE FROM ps_document_detail WHERE id_document = '86688' 08/07/2023 11:03:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86688' , '17257' , 'IO TI BATTEZZO ' , '50' , '-50' , '4' , '1.80' , '1.8' , '0' , '15' , '76.50' ) 08/07/2023 11:08:31 am >> SELECT document_num FROM ps_document WHERE document_num = '107' AND id_document != '86688' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-07-08') 08/07/2023 11:08:31 am >> UPDATE ps_document SET id_document_type = '21', document_num = '107', document_date = '2023-07-08', document_letter = '', id_customer = '229', id_supplier = '', id_address = '4673704', address1 = 'VIA TORINO 84092 BELLIZZI', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '15', id_causal = '0', price_tax_included = '76.50', price_tax_excluded = '76.50', date_upd = NOW() WHERE id_document = '86688' 08/07/2023 11:08:31 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86688' 08/07/2023 11:08:31 am >> DELETE FROM ps_document_detail WHERE id_document = '86688' 08/07/2023 11:08:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86688' , '17257' , 'IO TI BATTEZZO ' , '50' , '-50' , '4' , '1.8000' , '1.8' , '0' , '15' , '76.50' ) 08/07/2023 11:24:16 am >> SELECT document_num FROM ps_document WHERE document_num = '2336' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-07-08') 08/07/2023 11:24:16 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2336' , '2023-07-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '298.00' , '245.70' , NOW() , NOW() ) 08/07/2023 11:24:16 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86689' 08/07/2023 11:24:16 am >> DELETE FROM ps_document_detail WHERE id_document = '86689' 08/07/2023 11:24:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86689' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 08/07/2023 11:24:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86689' , '20429' , 'OSTIA SENZA TOSTATURA MORREALE - OS25' , '3' , '-3' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '6.00' ) 08/07/2023 11:24:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86689' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8' , '6.5573770491803' , '22' , '0' , '48.00' ) 08/07/2023 11:24:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86689' , '21196' , 'CALENDARIO LITURGICO 2024' , '1' , '-1' , '4' , '0.50' , '0.5' , '0' , '0' , '0.50' ) 08/07/2023 11:24:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86689' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '240' , '196.72131147541' , '22' , '0' , '240.00' ) 08/07/2023 11:44:40 am >> SELECT document_num FROM ps_document WHERE document_num = '2337' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-07-08') 08/07/2023 11:44:40 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' , '2337' , '2023-07-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '249.70' , '231.09' , NOW() , NOW() ) 08/07/2023 11:44:40 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 = '86690' 08/07/2023 11:44:40 am >> DELETE FROM ps_document_detail WHERE id_document = '86690' 08/07/2023 11:44:40 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 ( '86690' , '6811' , 'MOCCOLO 80X200' , '3' , '-3' , '1' , '9.00' , '7.3770491803279' , '22' , '0' , '27.00' ) 08/07/2023 11:44:40 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 ( '86690' , '11384' , 'VINO BIANCO DOLCE - 102' , '2' , '-2' , '1' , '8.50' , '6.9672131147541' , '22' , '0' , '17.00' ) 08/07/2023 11:44:40 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 ( '86690' , '9442' , 'SAN GERARDO MAIELLA - 52' , '4' , '-4' , '1' , '3.80' , '3.1147540983607' , '22' , '0' , '15.20' ) 08/07/2023 11:44:40 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 ( '86690' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 08/07/2023 11:44:40 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 ( '86690' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '57' , '57' , '0' , '0' , '57.00' ) 08/07/2023 11:44:40 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 ( '86690' , '19877' , 'CROCE VETRO FIORE - 755/820' , '1' , '-1' , '1' , '35.00' , '28.688524590164' , '22' , '0' , '35.00' ) 08/07/2023 11:44:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86690' , '15097' , 'CORONA MATRIMONIO - ORO' , '1' , '-1' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '7.50' ) 08/07/2023 11:44:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86690' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '120' , '-120' , '4' , '0.70' , '0.7' , '0' , '0' , '84.00' ) 08/07/2023 12:09:08 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788821595707' AND id_product != '6263' AND ean13 != '' 08/07/2023 12:09:08 pm >> UPDATE ps_product SET id_supplier = '7', reference = '7/5', ean13 = '9788821595707', date_upd = NOW() WHERE id_product = '6263' 08/07/2023 12:09:09 pm >> UPDATE ps_product_lang SET name = 'MARIA, DONNA DEI GIORNI NOSTRI - T.BELLO', description = '' WHERE id_product = '6263' 08/07/2023 12:09:09 pm >> UPDATE ps_product SET wholesale_price = '6.70', on_sale = '0', price = '14' WHERE id_product = '6263' 08/07/2023 12:09:09 pm >> UPDATE ps_product_shop SET wholesale_price = '6.70', price = '14', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '62', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '6263' 08/07/2023 12:09:09 pm >> DELETE FROM ps_specific_price WHERE id_product = '6263' 08/07/2023 12:09:18 pm >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '6263' 08/07/2023 12:09:18 pm >> UPDATE ps_stock_available SET quantity = quantity + '-1' WHERE id_product = '6263'