20/06/2024 08:36:09 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' , '9482/00/2024' , '2024-06-18' , '00' , '0' , '38' , '2633' , 'VIA GALVANI, 1 60020 CAMERATA PICENA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '180.00' , '180.00' , NOW() , NOW() ) 20/06/2024 08:36:09 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 = '92349' 20/06/2024 08:36:09 am >> DELETE FROM ps_document_detail WHERE id_document = '92349' 20/06/2024 08:36:09 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 ( '92349' , '22414' , 'SULLA TUA PAROLA - LUG/AGO 2024' , '40' , '40' , '4' , '5.00' , '5' , '0' , '40' , '120.0000' ) 20/06/2024 08:36:10 am >> DELETE FROM ps_product_supplier WHERE id_product = '22414' AND id_supplier = '38' 20/06/2024 08:36:10 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22414' , '38' , '1' ) 20/06/2024 08:36:10 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 ( '92349' , '22693' , 'SULLA TUA PAROLA - SETT/OTT 2024' , '20' , '20' , '4' , '5.00' , '5' , '0' , '40' , '60.0000' ) 20/06/2024 08:36:10 am >> DELETE FROM ps_product_supplier WHERE id_product = '22693' AND id_supplier = '38' 20/06/2024 08:36:10 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22693' , '38' , '1' ) 20/06/2024 10:28:37 am >> SELECT document_num FROM ps_document WHERE document_num = '2040' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-20') 20/06/2024 10:28:37 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' , '2040' , '2024-06-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '42.90' , '42.36' , NOW() , NOW() ) 20/06/2024 10:28:37 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 = '92350' 20/06/2024 10:28:37 am >> DELETE FROM ps_document_detail WHERE id_document = '92350' 20/06/2024 10:28:37 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 ( '92350' , '22129' , 'PADRE NOSTRO - L. EPICOCO' , '1' , '-1' , '4' , '14.00' , '14' , '0' , '5' , '13.30' ) 20/06/2024 10:28:37 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 ( '92350' , '22325' , 'PREGHIERA DEI SALMI - R. VIRGILI' , '1' , '-1' , '4' , '14.00' , '14' , '0' , '5' , '13.30' ) 20/06/2024 10:28:37 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 ( '92350' , '22102' , 'INIZIAZIONE ALLA PREGHIERA - R. PASOLINI' , '1' , '-1' , '4' , '14.00' , '14' , '0' , '5' , '13.30' ) 20/06/2024 10:28:37 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 ( '92350' , '17005' , 'BIGLIETTO AUGURALE medio' , '3' , '-3' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '3.00' ) 20/06/2024 10:29:47 am >> SELECT document_num FROM ps_document WHERE document_num = '2041' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-20') 20/06/2024 10:29:47 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' , '2041' , '2024-06-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.26' , '12.26' , NOW() , NOW() ) 20/06/2024 10:29:47 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 = '92351' 20/06/2024 10:29:47 am >> DELETE FROM ps_document_detail WHERE id_document = '92351' 20/06/2024 10:29:47 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 ( '92351' , '22695' , 'ON THE ROAD' , '1' , '-1' , '4' , '12.90' , '12.9' , '0' , '5' , '12.26' ) 20/06/2024 10:39:13 am >> SELECT document_num FROM ps_document WHERE document_num = '2042' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-20') 20/06/2024 10:39:13 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2042' , '2024-06-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '155.00' , '127.05' , NOW() , NOW() ) 20/06/2024 10:39:13 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92352' 20/06/2024 10:39:13 am >> DELETE FROM ps_document_detail WHERE id_document = '92352' 20/06/2024 10:39:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92352' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '155' , '127.04918032787' , '22' , '0' , '155.00' ) 20/06/2024 10:40:39 am >> SELECT document_num FROM ps_document WHERE document_num = '2043' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-20') 20/06/2024 10:40:39 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' , '2043' , '2024-06-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.40' , '1.97' , NOW() , NOW() ) 20/06/2024 10:40:39 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 = '92353' 20/06/2024 10:40:39 am >> DELETE FROM ps_document_detail WHERE id_document = '92353' 20/06/2024 10:40:39 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 ( '92353' , '20516' , 'CROCE COMUNIONE - 42/08' , '2' , '-2' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '2.40' ) 20/06/2024 10:42:00 am >> SELECT document_num FROM ps_document WHERE document_num = '1933' AND id_document != '92231' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-10') 20/06/2024 10:42:00 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1933', document_date = '2024-06-10', 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 = '152.00', price_tax_excluded = '124.59', date_upd = NOW() WHERE id_document = '92231' 20/06/2024 10:42:00 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 = '92231' 20/06/2024 10:42:00 am >> DELETE FROM ps_document_detail WHERE id_document = '92231' 20/06/2024 10:42:00 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 ( '92231' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '2' , '-2' , '1' , '70.0000' , '57.377049180328' , '22' , '0' , '140.00' ) 20/06/2024 10:42:00 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 ( '92231' , '20487' , 'STELLARIO CM 14 - ART. 70' , '1' , '-1' , '1' , '12' , '9.8360655737705' , '22' , '0' , '12.00' ) 20/06/2024 10:49:11 am >> SELECT document_num FROM ps_document WHERE document_num = '27/E' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-06-20') 20/06/2024 10:49:11 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '23' , '27/E' , '2024-06-20' , 'E' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '14' , '0' , '925.00' , '925.00' , NOW() , NOW() ) 20/06/2024 10:49:11 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92354' 20/06/2024 10:49:11 am >> DELETE FROM ps_document_detail WHERE id_document = '92354' 20/06/2024 10:49:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92354' , '21899' , 'SACRA BIBBIA cei/uelci ' , '100' , '-100' , '4' , '18.50' , '18.5' , '0' , '50' , '925.00' ) 20/06/2024 11:20:48 am >> SELECT document_num FROM ps_document WHERE document_num = '2044' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-20') 20/06/2024 11:20:48 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' , '2044' , '2024-06-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.80' , '7.67' , NOW() , NOW() ) 20/06/2024 11:20:48 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 = '92355' 20/06/2024 11:20:48 am >> DELETE FROM ps_document_detail WHERE id_document = '92355' 20/06/2024 11:20:48 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 ( '92355' , '22690' , 'MI AMI TU - 2023' , '1' , '-1' , '4' , '4.50' , '4.5' , '0' , '0' , '4.50' ) 20/06/2024 11:20:48 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 ( '92355' , '20431' , 'PARTICOLA TAGLIO CHIUSO 35MM - W500' , '1' , '-1' , '3' , '3.30' , '3.1730769230769' , '4' , '0' , '3.30' ) 20/06/2024 12:35:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '2045' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-20') 20/06/2024 12:35: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' , '2045' , '2024-06-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.40' , '12.62' , NOW() , NOW() ) 20/06/2024 12:35: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 = '92356' 20/06/2024 12:35:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '92356' 20/06/2024 12:35: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 ( '92356' , '6304' , 'MATTHAEUS 25G - CINNAMONO - EVE ' , '1' , '-1' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '1.50' ) 20/06/2024 12:35: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 ( '92356' , '5473' , 'IOHANNES 25G - ROSA - EVE ' , '1' , '-1' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '1.50' ) 20/06/2024 12:35: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 ( '92356' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '2.4' , '1.9672131147541' , '22' , '0' , '2.40' ) 20/06/2024 12:35: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 ( '92356' , '1375' , 'BRUCIAINCENSI LEGNO - BRUL' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 20/06/2024 03:06:09 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 20/06/2024 03:06:09 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22709' , '1' , '' , 'nuovo-prodotto' ) 20/06/2024 03:06:10 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '22709' , '1' , '1' , '2' , NOW() , NOW() ) 20/06/2024 03:06:10 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '22709' , '0' , '1' , '0' , '0' ) 20/06/2024 03:07:28 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788898573288' AND id_product != '22709' AND ean13 != '' 20/06/2024 03:07:28 pm >> UPDATE ps_product SET id_supplier = '', reference = '7/5', ean13 = '9788898573288', date_upd = NOW() WHERE id_product = '22709' 20/06/2024 03:07:28 pm >> UPDATE ps_product_lang SET name = 'MARIA IL FIORE DEI POETI - R. VIRGILI', description = '' WHERE id_product = '22709' 20/06/2024 03:07:28 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '12' WHERE id_product = '22709' 20/06/2024 03:07:28 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '12', id_tax_rules_group = '4', id_category_default = '419', id_argoment_default = '73', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22709' 20/06/2024 03:07:28 pm >> DELETE FROM ps_specific_price WHERE id_product = '22709' 20/06/2024 03:07:29 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 = '22709' 20/06/2024 03:07:29 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22710' , '1' , '' , 'nuovo-prodotto' ) 20/06/2024 03:07:29 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 '22710' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22709' 20/06/2024 03:07:29 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22710' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22709' 20/06/2024 03:10:41 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791281071087' AND id_product != '22710' AND ean13 != '' 20/06/2024 03:10:41 pm >> UPDATE ps_product SET id_supplier = '', reference = '7/3', ean13 = '9791281071087', date_upd = NOW() WHERE id_product = '22710' 20/06/2024 03:10:41 pm >> UPDATE ps_product_lang SET name = 'PRIMA DI STENDERE LE BRACCIA - O. VEZZOLI', description = '' WHERE id_product = '22710' 20/06/2024 03:10:41 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '15' WHERE id_product = '22710' 20/06/2024 03:10:41 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '15', id_tax_rules_group = '4', id_category_default = '419', id_argoment_default = '64', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22710' 20/06/2024 03:10:41 pm >> DELETE FROM ps_specific_price WHERE id_product = '22710' 20/06/2024 03:10:42 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 = '22710' 20/06/2024 03:10:42 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22711' , '1' , '' , 'nuovo-prodotto' ) 20/06/2024 03:10:42 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 '22711' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22710' 20/06/2024 03:10:42 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22711' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22710' 20/06/2024 03:11:05 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791281071087' AND id_product != '22710' AND ean13 != '' 20/06/2024 03:11:05 pm >> UPDATE ps_product SET id_supplier = '', reference = '7/3', ean13 = '9791281071087', date_upd = NOW() WHERE id_product = '22710' 20/06/2024 03:11:05 pm >> UPDATE ps_product_lang SET name = 'PRIMA DI STENDERE LE BRACCIA - O. VEZZOLI', description = '' WHERE id_product = '22710' 20/06/2024 03:11:05 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '15.0000' WHERE id_product = '22710' 20/06/2024 03:11:05 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '15.0000', id_tax_rules_group = '4', id_category_default = '419', id_argoment_default = '64', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22710' 20/06/2024 03:11:05 pm >> DELETE FROM ps_specific_price WHERE id_product = '22710' 20/06/2024 03:11:48 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '2024000003384' , '2024-06-19' , '' , '0' , '107' , '4669100' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '6' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '67.21' , '67.21' , NOW() , NOW() ) 20/06/2024 03:11:48 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92357' 20/06/2024 03:11:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '92357' 20/06/2024 03:11:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92357' , '22709' , 'MARIA IL FIORE DEI POETI - R. VIRGILI' , '1' , '1' , '4' , '12.00' , '12' , '0' , '35' , '7.8000' ) 20/06/2024 03:11:48 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22709' AND id_supplier = '107' 20/06/2024 03:11:48 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22709' , '107' , '1' ) 20/06/2024 03:11:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92357' , '22710' , 'PRIMA DI STENDERE LE BRACCIA - O. VEZZOLI' , '1' , '1' , '4' , '15.00' , '15' , '0' , '35' , '9.7500' ) 20/06/2024 03:11:48 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22710' AND id_supplier = '107' 20/06/2024 03:11:48 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22710' , '107' , '1' ) 20/06/2024 03:11:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92357' , '15785' , 'IN PREGHIERA CON MARIA - MADRE DECORO CARMELO' , '3' , '3' , '4' , '10.90' , '10.9' , '0' , '35' , '21.2550' ) 20/06/2024 03:11:48 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15785' AND id_supplier = '107' 20/06/2024 03:11:48 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15785' , '107' , '1' ) 20/06/2024 03:11:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92357' , '4229' , 'FONTI FRANCESCANE - ED. MINOR' , '1' , '1' , '4' , '32.00' , '32' , '0' , '30' , '22.4000' ) 20/06/2024 03:11:48 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4229' AND id_supplier = '107' 20/06/2024 03:11:48 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4229' , '107' , '1' ) 20/06/2024 03:19:42 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002265' AND id_product != '22464' AND ean13 != '' 20/06/2024 03:19:42 pm >> UPDATE ps_product SET id_supplier = '163', reference = '', ean13 = '002265', date_upd = NOW() WHERE id_product = '22464' 20/06/2024 03:19:42 pm >> UPDATE ps_product_lang SET name = 'CASULA LEGGERA - 1212', description = '' WHERE id_product = '22464' 20/06/2024 03:19:42 pm >> UPDATE ps_product SET wholesale_price = '61.00', on_sale = '0', price = '61.47540983606557' WHERE id_product = '22464' 20/06/2024 03:19:42 pm >> UPDATE ps_product_shop SET wholesale_price = '61.00', price = '61.47540983606557', id_tax_rules_group = '1', id_category_default = '499', 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 = '22464' 20/06/2024 03:19:42 pm >> DELETE FROM ps_specific_price WHERE id_product = '22464' 20/06/2024 03:20:29 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '520' , '2024-06-18' , '' , '0' , '163' , '4674530' , 'VIA CORTI 29 24126 BERGAMO' , '' , '' , '15' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '527.40' , '435.00' , NOW() , NOW() ) 20/06/2024 03:20: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 = '92358' 20/06/2024 03:20:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '92358' 20/06/2024 03:20: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 ( '92358' , '22464' , 'CASULA LEGGERA - 1212' , '15' , '15' , '1' , '28' , '22.950819672131' , '22' , '0' , '512.4000' ) 20/06/2024 03:20:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22464' AND id_supplier = '163' 20/06/2024 03:20:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22464' , '163' , '1' ) 20/06/2024 04:22:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '2046' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-20') 20/06/2024 04:22:59 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' , '2046' , '2024-06-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '34.80' , '28.52' , NOW() , NOW() ) 20/06/2024 04:22:59 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 = '92359' 20/06/2024 04:22:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '92359' 20/06/2024 04:22:59 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 ( '92359' , '7202' , 'ARTICOLI RELIGIOSI' , '12' , '-12' , '1' , '2.9' , '2.3770491803279' , '22' , '0' , '34.80' ) 20/06/2024 04:43:38 pm >> SELECT document_num FROM ps_document WHERE document_num = '2047' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-20') 20/06/2024 04:43:38 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' , '2047' , '2024-06-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.00' , '15.57' , NOW() , NOW() ) 20/06/2024 04:43:38 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 = '92360' 20/06/2024 04:43:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '92360' 20/06/2024 04:43: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 ( '92360' , '15208' , 'ANELLO DECINA CON CRISTALLI - ARG 925' , '1' , '-1' , '1' , '19.00' , '15.573770491803' , '22' , '0' , '19.00' ) 20/06/2024 05:11:13 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788825055221' AND id_product != '21396' AND ean13 != '' 20/06/2024 05:11:13 pm >> UPDATE ps_product SET id_supplier = '7', reference = '6/2', ean13 = '9788825055221', date_upd = NOW() WHERE id_product = '21396' 20/06/2024 05:11:13 pm >> UPDATE ps_product_lang SET name = 'CRISTO NOSTRA VITA - A. BASILE', description = '' WHERE id_product = '21396' 20/06/2024 05:11:13 pm >> UPDATE ps_product SET wholesale_price = '14.00', on_sale = '0', price = '20.0000' WHERE id_product = '21396' 20/06/2024 05:11:14 pm >> UPDATE ps_product_shop SET wholesale_price = '14.00', price = '20.0000', id_tax_rules_group = '4', id_category_default = '17', id_argoment_default = '23', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21396' 20/06/2024 05:11:14 pm >> DELETE FROM ps_specific_price WHERE id_product = '21396' 20/06/2024 05:33:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '2048' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-20') 20/06/2024 05:33:33 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2048' , '2024-06-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '40.00' , '32.79' , NOW() , NOW() ) 20/06/2024 05:33:33 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92361' 20/06/2024 05:33:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '92361' 20/06/2024 05:33: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 ( '92361' , '19594' , 'POLO JERSEY COTONE 100%' , '1' , '-1' , '1' , '40' , '32.786885245902' , '22' , '0' , '40.00' ) 20/06/2024 05:49:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '94' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-06-20') 20/06/2024 05:49:31 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' , '94' , '2024-06-20' , '' , '344' , '0' , '4679249' , 'L.GO MONS. G. PALUMBO 84020 OLIVETO CITRA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '15' , '0' , '17.00' , '17.00' , NOW() , NOW() ) 20/06/2024 05:49: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 = '92362' 20/06/2024 05:49:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '92362' 20/06/2024 05:49: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 ( '92362' , '15020' , 'PREGARE OGNI GIORNO' , '20' , '-20' , '4' , '1.00' , '1' , '0' , '15' , '17.00' ) 20/06/2024 05:50:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '94' AND id_document != '92362' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-06-20') 20/06/2024 05:50:15 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '94', document_date = '2024-06-20', document_letter = '', id_customer = '344', id_supplier = '', id_address = '4679249', address1 = 'L.GO MONS. G. PALUMBO 84020 OLIVETO CITRA', 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 = '17.00', price_tax_excluded = '17.00', date_upd = NOW() WHERE id_document = '92362' 20/06/2024 05:50:15 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92362' 20/06/2024 05:50:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '92362' 20/06/2024 05:50:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92362' , '15020' , 'PREGARE OGNI GIORNO' , '20' , '-20' , '4' , '1.0000' , '1' , '0' , '15' , '17.00' ) 20/06/2024 06:12:35 pm >> SELECT document_num FROM ps_document WHERE document_num = '2049' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-20') 20/06/2024 06:12:35 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2049' , '2024-06-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.00' , '1.64' , NOW() , NOW() ) 20/06/2024 06:12:35 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92363' 20/06/2024 06:12:35 pm >> DELETE FROM ps_document_detail WHERE id_document = '92363' 20/06/2024 06:12:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92363' , '19104' , 'LUMINELLI A OLIO' , '2' , '-2' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '2.00' ) 20/06/2024 06:38:49 pm >> SELECT document_num FROM ps_document WHERE document_num = '2046' AND id_document != '92359' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-20') 20/06/2024 06:38:49 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2046', document_date = '2024-06-20', 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 = '34.80', price_tax_excluded = '28.52', date_upd = NOW() WHERE id_document = '92359' 20/06/2024 06:38:49 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 = '92359' 20/06/2024 06:38:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '92359' 20/06/2024 06:38:49 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 ( '92359' , '13363' , 'CORONA MM 6 ' , '12' , '-12' , '1' , '2.90' , '2.3770491803279' , '22' , '0' , '34.80' ) 20/06/2024 06:40:40 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '0827/28' AND id_product != '13363' AND ean13 != '' 20/06/2024 06:40:40 pm >> UPDATE ps_product SET id_supplier = '39', reference = '', ean13 = '0827/28', date_upd = NOW() WHERE id_product = '13363' 20/06/2024 06:40:40 pm >> UPDATE ps_product_lang SET name = 'CORONA MM 6 pietra colorata', description = '' WHERE id_product = '13363' 20/06/2024 06:40:40 pm >> UPDATE ps_product SET wholesale_price = '1.05', on_sale = '0', price = '2.3770' WHERE id_product = '13363' 20/06/2024 06:40:40 pm >> UPDATE ps_product_shop SET wholesale_price = '1.05', price = '2.3770', id_tax_rules_group = '1', id_category_default = '187', 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 = '13363' 20/06/2024 06:40:40 pm >> DELETE FROM ps_specific_price WHERE id_product = '13363'