24/06/2024 08:45:21 am >> SELECT document_num FROM ps_document WHERE document_num = '95' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-06-24') 24/06/2024 08:45:21 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' , '95' , '2024-06-24' , '' , '4082' , '0' , '4679254' , 'PIAZZA GIOVIO 1 22020 TORNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '95.00' , '95.00' , NOW() , NOW() ) 24/06/2024 08:45:21 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 = '92385' 24/06/2024 08:45:21 am >> DELETE FROM ps_document_detail WHERE id_document = '92385' 24/06/2024 08:45:21 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 ( '92385' , '11097' , 'VANGELO E ATTI DEGLI APOSTOLI' , '20' , '-20' , '4' , '5.00' , '5' , '0' , '5' , '95.00' ) 24/06/2024 11:03:36 am >> SELECT document_num FROM ps_document WHERE document_num = '2065' AND id_document != '92382' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-22') 24/06/2024 11:03:36 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2065', document_date = '2024-06-22', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '301.00', price_tax_excluded = '246.72', date_upd = NOW() WHERE id_document = '92382' 24/06/2024 11:03: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 = '92382' 24/06/2024 11:03:36 am >> DELETE FROM ps_document_detail WHERE id_document = '92382' 24/06/2024 11:03: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 ( '92382' , '22163' , 'CALICE CLASSICO - 155' , '1' , '-1' , '1' , '301' , '246.72131147541' , '22' , '0' , '301.00' ) 24/06/2024 11:04:05 am >> SELECT document_num FROM ps_document WHERE document_num = '1575' AND id_document != '91787' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-13') 24/06/2024 11:04:05 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1575', document_date = '2024-05-13', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '55.00', price_tax_excluded = '45.08', date_upd = NOW() WHERE id_document = '91787' 24/06/2024 11:04:05 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91787' 24/06/2024 11:04:05 am >> DELETE FROM ps_document_detail WHERE id_document = '91787' 24/06/2024 11:04:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91787' , '1544' , 'CAMICE RAGLAN - CM 150 - ART.54' , '1' , '-1' , '1' , '55' , '45.081967213115' , '22' , '0' , '55.00' ) 24/06/2024 11:04:20 am >> SELECT document_num FROM ps_document WHERE document_num = '1576' AND id_document != '91788' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-13') 24/06/2024 11:04:21 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1576', document_date = '2024-05-13', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '45.00', price_tax_excluded = '36.89', date_upd = NOW() WHERE id_document = '91788' 24/06/2024 11:04:21 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 = '91788' 24/06/2024 11:04:21 am >> DELETE FROM ps_document_detail WHERE id_document = '91788' 24/06/2024 11:04:21 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 ( '91788' , '1544' , 'CAMICE RAGLAN - CM 150 - ART.54' , '1' , '-1' , '1' , '45' , '36.885245901639' , '22' , '0' , '45.00' ) 24/06/2024 11:05:42 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002125' AND id_product != '20853' AND ean13 != '' 24/06/2024 11:05:42 am >> UPDATE ps_product SET id_supplier = '149', reference = '', ean13 = '002125', date_upd = NOW() WHERE id_product = '20853' 24/06/2024 11:05:42 am >> UPDATE ps_product_lang SET name = 'CALICE IN FUSIONE ARG - 193A', description = '' WHERE id_product = '20853' 24/06/2024 11:05:42 am >> UPDATE ps_product SET wholesale_price = '568.10', on_sale = '0', price = '1196.72131147541' WHERE id_product = '20853' 24/06/2024 11:05:42 am >> UPDATE ps_product_shop SET wholesale_price = '568.10', price = '1196.72131147541', id_tax_rules_group = '1', id_category_default = '480', 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 = '20853' 24/06/2024 11:05:42 am >> DELETE FROM ps_specific_price WHERE id_product = '20853' 24/06/2024 11:39:19 am >> SELECT document_num FROM ps_document WHERE document_num = '2068' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-24') 24/06/2024 11:39:19 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' , '2068' , '2024-06-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '26.00' , '21.31' , NOW() , NOW() ) 24/06/2024 11:39:19 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 = '92386' 24/06/2024 11:39:19 am >> DELETE FROM ps_document_detail WHERE id_document = '92386' 24/06/2024 11:39:19 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 ( '92386' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '2' , '-2' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '7.00' ) 24/06/2024 11:39:19 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 ( '92386' , '13049' , 'LITURGICO ART. 60LT BIANCO SUPER' , '2' , '-2' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '7.00' ) 24/06/2024 11:39:19 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 ( '92386' , '1912' , 'CERA DELL\'EREMO - 415/B ' , '2' , '-2' , '1' , '6.00' , '4.9180327868852' , '22' , '0' , '12.00' ) 24/06/2024 12:46:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '2069' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-24') 24/06/2024 12:46:17 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2069' , '2024-06-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '70.00' , '57.38' , NOW() , NOW() ) 24/06/2024 12:46:17 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92387' 24/06/2024 12:46:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '92387' 24/06/2024 12:46:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92387' , '778' , 'ASPERGES CON VASETTO O. S. - 1700 ' , '1' , '-1' , '1' , '70.00' , '57.377049180328' , '22' , '0' , '70.00' ) 24/06/2024 03:38:06 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000580' AND id_product != '8191' AND ean13 != '' 24/06/2024 03:38:06 pm >> UPDATE ps_product SET id_supplier = '28', reference = '2014', ean13 = '000580', date_upd = NOW() WHERE id_product = '8191' 24/06/2024 03:38:06 pm >> UPDATE ps_product_lang SET name = 'PORTAPILLOLA OVALE GRANDE - 1075', description = '' WHERE id_product = '8191' 24/06/2024 03:38:06 pm >> UPDATE ps_product SET wholesale_price = '2.00', on_sale = '0', price = '4.426229508196721' WHERE id_product = '8191' 24/06/2024 03:38:06 pm >> UPDATE ps_product_shop SET wholesale_price = '2.00', price = '4.426229508196721', id_tax_rules_group = '1', id_category_default = '95', 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 = '8191' 24/06/2024 03:38:06 pm >> DELETE FROM ps_specific_price WHERE id_product = '8191' 24/06/2024 03:40:39 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' , 'A2713' , '2024-06-20' , '' , '0' , '28' , '2623' , 'VIA DEI MILLE 59 80121 NAPOLI' , '' , '' , '3' , '1' , '0' , '0' , '0' , '' , '3' , '0' , '225.69' , '184.99' , NOW() , NOW() ) 24/06/2024 03: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 = '92388' 24/06/2024 03:40:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '92388' 24/06/2024 03: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 ( '92388' , '8191' , 'PORTAPILLOLA OVALE GRANDE - 1075' , '30' , '30' , '1' , '2' , '1.6393442622951' , '22' , '0' , '73.2000' ) 24/06/2024 03:40:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8191' AND id_supplier = '28' 24/06/2024 03:40:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8191' , '28' , '1' ) 24/06/2024 03: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 ( '92388' , '22671' , 'ROSARIO IN METALLO' , '36' , '36' , '1' , '1.42' , '1.1639344262295' , '22' , '0' , '62.3664' ) 24/06/2024 03:40:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22671' AND id_supplier = '28' 24/06/2024 03:40:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22671' , '28' , '1' ) 24/06/2024 03: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 ( '92388' , '21096' , 'CROCE REMOVIBILE EFFETTO PIETRA - 3873' , '5' , '5' , '1' , '4.53' , '3.7131147540984' , '22' , '0' , '27.6330' ) 24/06/2024 03:40:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21096' AND id_supplier = '28' 24/06/2024 03:40:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21096' , '28' , '1' ) 24/06/2024 03: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 ( '92388' , '21095' , 'QUADRETTO DA POGGIO EFFETTO PIETRA - 2950' , '10' , '10' , '1' , '2.62' , '2.1475409836066' , '22' , '0' , '31.9640' ) 24/06/2024 03:40:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21095' AND id_supplier = '28' 24/06/2024 03:40:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21095' , '28' , '1' ) 24/06/2024 03: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 ( '92388' , '21561' , 'QUADRO PIASTRELLA 20X20 - 2189' , '1' , '1' , '1' , '9.06' , '7.4262295081967' , '22' , '0' , '11.0532' ) 24/06/2024 03:40:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21561' AND id_supplier = '28' 24/06/2024 03:40:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21561' , '28' , '1' ) 24/06/2024 03: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 ( '92388' , '21558' , 'ANELLO DECINA ARG - M043' , '3' , '3' , '1' , '4.32' , '3.5409836065574' , '22' , '0' , '15.8112' ) 24/06/2024 03:40:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21558' AND id_supplier = '28' 24/06/2024 03:40:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21558' , '28' , '1' ) 24/06/2024 04:57:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '2070' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-24') 24/06/2024 04:57: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 ( '11' , '2070' , '2024-06-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.50' , '3.69' , NOW() , NOW() ) 24/06/2024 04:57: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 = '92389' 24/06/2024 04:57:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '92389' 24/06/2024 04:57: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 ( '92389' , '5473' , 'IOHANNES 25G - ROSA - EVE ' , '3' , '-3' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '4.50' )