12/06/2023 09:05:00 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 12/06/2023 09:05:00 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21151' , '1' , '' , 'nuovo-prodotto' ) 12/06/2023 09:05:00 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '21151' , '1' , '1' , '2' , NOW() , NOW() ) 12/06/2023 09:05:00 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '21151' , '0' , '1' , '0' , '0' ) 12/06/2023 09:06:47 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892229105' AND id_product != '21151' AND ean13 != '' 12/06/2023 09:06:47 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788892229105', date_upd = NOW() WHERE id_product = '21151' 12/06/2023 09:06:47 am >> UPDATE ps_product_lang SET name = 'chiesa che vogliamo - a. chiara', description = '' WHERE id_product = '21151' 12/06/2023 09:06:47 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '19' WHERE id_product = '21151' 12/06/2023 09:06:47 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '19', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21151' 12/06/2023 09:06:47 am >> DELETE FROM ps_specific_price WHERE id_product = '21151' 12/06/2023 09:06:54 am >> 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 = '21151' 12/06/2023 09:06:54 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21152' , '1' , '' , 'nuovo-prodotto' ) 12/06/2023 09:06:54 am >> 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 '21152' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21151' 12/06/2023 09:06:54 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21152' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21151' 12/06/2023 09: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 ( '33' , '633882' , '2023-06-08' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '2.26' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '79.15' , '79.15' , NOW() , NOW() ) 12/06/2023 09: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 = '85806' 12/06/2023 09:09:51 am >> DELETE FROM ps_document_detail WHERE id_document = '85806' 12/06/2023 09: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 ( '85806' , '21151' , 'chiesa che vogliamo - a. chiara' , '1' , '1' , '4' , '19.00' , '19' , '0' , '33' , '12.7300' ) 12/06/2023 09:09:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '21151' AND id_supplier = '7' 12/06/2023 09:09:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21151' , '7' , '1' ) 12/06/2023 09: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 ( '85806' , '19618' , 'CARLO ACUTIS' , '2' , '2' , '4' , '3.90' , '3.9' , '0' , '30' , '5.4600' ) 12/06/2023 09:09:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '19618' AND id_supplier = '7' 12/06/2023 09:09:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19618' , '7' , '1' ) 12/06/2023 09: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 ( '85806' , '16019' , 'MARTA, MARIA E LAZZARO - L. EPICOCO' , '1' , '1' , '4' , '10.00' , '10' , '0' , '30' , '7.0000' ) 12/06/2023 09:09:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '16019' AND id_supplier = '7' 12/06/2023 09:09:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16019' , '7' , '1' ) 12/06/2023 09: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 ( '85806' , '19360' , 'IN PRINCIPIO ERANO FRATELLI - L. EPICOCO' , '1' , '1' , '4' , '10.00' , '10' , '0' , '30' , '7.0000' ) 12/06/2023 09:09:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '19360' AND id_supplier = '7' 12/06/2023 09:09:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19360' , '7' , '1' ) 12/06/2023 09: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 ( '85806' , '20655' , 'ARTE DELLA BUONA BATTAGLIA - F. ROSINI' , '2' , '2' , '4' , '18.00' , '18' , '0' , '33' , '24.1200' ) 12/06/2023 09:09:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '20655' AND id_supplier = '7' 12/06/2023 09:09:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20655' , '7' , '1' ) 12/06/2023 09: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 ( '85806' , '8702' , 'QUANDO IL MAESTRO PARLA AL CUORE - G. COURTOIS' , '1' , '1' , '4' , '14.00' , '14' , '0' , '33' , '9.3800' ) 12/06/2023 09:09:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '8702' AND id_supplier = '7' 12/06/2023 09:09:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8702' , '7' , '1' ) 12/06/2023 09: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 ( '85806' , '21118' , 'MARIA MADRE DELLEUCARISTIA - D. RUOTOLO' , '1' , '1' , '4' , '16.00' , '16' , '0' , '30' , '11.2000' ) 12/06/2023 09:09:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '21118' AND id_supplier = '7' 12/06/2023 09:09:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21118' , '7' , '1' ) 12/06/2023 09:11:47 am >> SELECT document_num FROM ps_document WHERE document_num = '2033' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-12') 12/06/2023 09:11: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' , '2033' , '2023-06-12' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.20' , '2.62' , NOW() , NOW() ) 12/06/2023 09:11: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 = '85807' 12/06/2023 09:11:47 am >> DELETE FROM ps_document_detail WHERE id_document = '85807' 12/06/2023 09:11: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 ( '85807' , '18214' , 'BRACCIALE DECINA LEGNO CORDA - BC566' , '1' , '-1' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '2.00' ) 12/06/2023 09:11: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 ( '85807' , '18892' , 'BRACCIALE DECINA AZZURRO - BC822NP' , '1' , '-1' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '1.20' ) 12/06/2023 09:43:07 am >> SELECT document_num FROM ps_document WHERE document_num = '2034' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-12') 12/06/2023 09:43:07 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' , '2034' , '2023-06-12' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '58.00' , '47.54' , NOW() , NOW() ) 12/06/2023 09:43:07 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 = '85808' 12/06/2023 09:43:07 am >> DELETE FROM ps_document_detail WHERE id_document = '85808' 12/06/2023 09:43:07 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 ( '85808' , '16461' , 'CLERGY NIDO DAPE ML - C 22' , '1' , '-1' , '1' , '58.00' , '47.540983606557' , '22' , '0' , '58.00' ) 12/06/2023 10:24:45 am >> SELECT document_num FROM ps_document WHERE document_num = '2035' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-12') 12/06/2023 10:24:45 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' , '2035' , '2023-06-12' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.50' , '2.05' , NOW() , NOW() ) 12/06/2023 10:24:45 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 = '85809' 12/06/2023 10:24:45 am >> DELETE FROM ps_document_detail WHERE id_document = '85809' 12/06/2023 10:24: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 ( '85809' , '15481' , 'CROCE IHS - 2389/CZ' , '1' , '-1' , '1' , '2.50' , '2.0491803278689' , '22' , '0' , '2.50' ) 12/06/2023 10:43:03 am >> SELECT document_num FROM ps_document WHERE document_num = '2036' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-12') 12/06/2023 10:43:04 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' , '2036' , '2023-06-12' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '126.40' , '110.63' , NOW() , NOW() ) 12/06/2023 10:43:04 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 = '85810' 12/06/2023 10:43:04 am >> DELETE FROM ps_document_detail WHERE id_document = '85810' 12/06/2023 10:43:04 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 ( '85810' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '6' , '-6' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '21.00' ) 12/06/2023 10:43:04 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 ( '85810' , '16689' , 'OSTIA PAN DI CENA mm80' , '10' , '-10' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '20.00' ) 12/06/2023 10:43:04 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 ( '85810' , '17617' , 'IMMAGINI ISONZO X 100' , '3' , '-3' , '1' , '3.80' , '3.1147540983607' , '22' , '0' , '11.40' ) 12/06/2023 10:43:04 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 ( '85810' , '18749' , 'OSTIA MAGNA 200mm - OM 200' , '1' , '-1' , '3' , '8.50' , '8.1730769230769' , '4' , '0' , '8.50' ) 12/06/2023 10:43:04 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 ( '85810' , '2168' , 'CLERGY BASIC - ML - B&P' , '1' , '-1' , '1' , '35.50' , '29.098360655738' , '22' , '0' , '35.50' ) 12/06/2023 10:43:04 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 ( '85810' , '9691' , 'SCAPOLARE DEL CARMELO - PICCOLO - 1215/ITA' , '30' , '-30' , '1' , '1' , '0.81967213114754' , '22' , '0' , '30.00' ) 12/06/2023 10:54:53 am >> SELECT document_num FROM ps_document WHERE document_num = '2037' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-12') 12/06/2023 10:54:53 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' , '2037' , '2023-06-12' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '36.00' , '29.51' , NOW() , NOW() ) 12/06/2023 10:54:53 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 = '85811' 12/06/2023 10:54:53 am >> DELETE FROM ps_document_detail WHERE id_document = '85811' 12/06/2023 10:54:53 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 ( '85811' , '12818' , 'LIBRO DELLE PRIME COMUNIONI' , '1' , '-1' , '1' , '40.00' , '32.786885245902' , '22' , '10' , '36.00' ) 12/06/2023 11:05:51 am >> SELECT ean13 FROM ps_product WHERE ean13 = '001889' AND id_product != '13355' AND ean13 != '' 12/06/2023 11:05:51 am >> UPDATE ps_product SET id_supplier = '16', reference = '', ean13 = '001889', date_upd = NOW() WHERE id_product = '13355' 12/06/2023 11:05:51 am >> UPDATE ps_product_lang SET name = 'ROSARIO CRISTALLO VARI COLORI - 07777', description = '' WHERE id_product = '13355' 12/06/2023 11:05:51 am >> UPDATE ps_product SET wholesale_price = '4.22', on_sale = '0', price = '10.245901639344263' WHERE id_product = '13355' 12/06/2023 11:05:51 am >> UPDATE ps_product_shop SET wholesale_price = '4.22', price = '10.245901639344263', id_tax_rules_group = '1', id_category_default = '210', 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 = '13355' 12/06/2023 11:05:51 am >> DELETE FROM ps_specific_price WHERE id_product = '13355' 12/06/2023 11:11:22 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002152' AND id_product != '21152' AND ean13 != '' 12/06/2023 11:11:22 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002152', date_upd = NOW() WHERE id_product = '21152' 12/06/2023 11:11:22 am >> UPDATE ps_product_lang SET name = 'bracciale arg. - 123/124', description = '' WHERE id_product = '21152' 12/06/2023 11:11:22 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '32.78688524590164' WHERE id_product = '21152' 12/06/2023 11:11:22 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '32.78688524590164', id_tax_rules_group = '1', id_category_default = '210', 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 = '21152' 12/06/2023 11:11:22 am >> DELETE FROM ps_specific_price WHERE id_product = '21152' 12/06/2023 11:11:23 am >> 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 = '21152' 12/06/2023 11:11:23 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21153' , '1' , '' , 'nuovo-prodotto' ) 12/06/2023 11:11:23 am >> 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 '21153' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21152' 12/06/2023 11:11:23 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21153' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21152' 12/06/2023 11:11:53 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002152' AND id_product != '21152' AND ean13 != '' 12/06/2023 11:11:53 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002152', date_upd = NOW() WHERE id_product = '21152' 12/06/2023 11:11:53 am >> UPDATE ps_product_lang SET name = 'BRACCIALE ARG. - 123/124', description = '' WHERE id_product = '21152' 12/06/2023 11:11:53 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '32.7869' WHERE id_product = '21152' 12/06/2023 11:11:53 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '32.7869', id_tax_rules_group = '1', id_category_default = '210', 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 = '21152' 12/06/2023 11:11:53 am >> DELETE FROM ps_specific_price WHERE id_product = '21152' 12/06/2023 11:18:14 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002153' AND id_product != '21153' AND ean13 != '' 12/06/2023 11:18:14 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002153', date_upd = NOW() WHERE id_product = '21153' 12/06/2023 11:18:14 am >> UPDATE ps_product_lang SET name = 'rosario cristallo coppigliato - 18600', description = '' WHERE id_product = '21153' 12/06/2023 11:18:14 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '9.01639344262295' WHERE id_product = '21153' 12/06/2023 11:18:14 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '9.01639344262295', id_tax_rules_group = '1', id_category_default = '210', 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 = '21153' 12/06/2023 11:18:14 am >> DELETE FROM ps_specific_price WHERE id_product = '21153' 12/06/2023 11:18:16 am >> 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 = '21153' 12/06/2023 11:18:16 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21154' , '1' , '' , 'nuovo-prodotto' ) 12/06/2023 11:18:16 am >> 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 '21154' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21153' 12/06/2023 11:18:16 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21154' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21153' 12/06/2023 11:19:47 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002153' AND id_product != '21153' AND ean13 != '' 12/06/2023 11:19:47 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002153', date_upd = NOW() WHERE id_product = '21153' 12/06/2023 11:19:47 am >> UPDATE ps_product_lang SET name = 'ROSARIO CRISTALLO COPPIGLIATO ARGEBN - 18600', description = '' WHERE id_product = '21153' 12/06/2023 11:19:47 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '9.0164' WHERE id_product = '21153' 12/06/2023 11:19:47 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '9.0164', id_tax_rules_group = '1', id_category_default = '210', 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 = '21153' 12/06/2023 11:19:47 am >> DELETE FROM ps_specific_price WHERE id_product = '21153' 12/06/2023 11:20:08 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002153' AND id_product != '21153' AND ean13 != '' 12/06/2023 11:20:08 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002153', date_upd = NOW() WHERE id_product = '21153' 12/06/2023 11:20:08 am >> UPDATE ps_product_lang SET name = 'ROSARIO CRISTALLO COPPIGLIATO ARGEBN - 18600', description = '' WHERE id_product = '21153' 12/06/2023 11:20:08 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '9.0164' WHERE id_product = '21153' 12/06/2023 11:20:08 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '9.0164', id_tax_rules_group = '1', id_category_default = '210', 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 = '21153' 12/06/2023 11:20:08 am >> DELETE FROM ps_specific_price WHERE id_product = '21153' 12/06/2023 11:20:56 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002154' AND id_product != '21154' AND ean13 != '' 12/06/2023 11:20:56 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002154', date_upd = NOW() WHERE id_product = '21154' 12/06/2023 11:20:56 am >> UPDATE ps_product_lang SET name = 'ROSARIO CRISTALLO COPPIGLIATO DORATO - 18620', description = '' WHERE id_product = '21154' 12/06/2023 11:20:56 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '11.065573770491804' WHERE id_product = '21154' 12/06/2023 11:20:56 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '11.065573770491804', id_tax_rules_group = '1', id_category_default = '210', 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 = '21154' 12/06/2023 11:20:56 am >> DELETE FROM ps_specific_price WHERE id_product = '21154' 12/06/2023 11:20:56 am >> 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 = '21154' 12/06/2023 11:20:56 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21155' , '1' , '' , 'nuovo-prodotto' ) 12/06/2023 11:20:56 am >> 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 '21155' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21154' 12/06/2023 11:20:57 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21155' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21154' 12/06/2023 11:21:13 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002154' AND id_product != '21154' AND ean13 != '' 12/06/2023 11:21:13 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002154', date_upd = NOW() WHERE id_product = '21154' 12/06/2023 11:21:13 am >> UPDATE ps_product_lang SET name = 'ROSARIO CRISTALLO COPPIGLIATO DORATO - 18620', description = '' WHERE id_product = '21154' 12/06/2023 11:21:13 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '10.245901639344263' WHERE id_product = '21154' 12/06/2023 11:21:13 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '10.245901639344263', id_tax_rules_group = '1', id_category_default = '210', 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 = '21154' 12/06/2023 11:21:13 am >> DELETE FROM ps_specific_price WHERE id_product = '21154' 12/06/2023 11:22:42 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002155' AND id_product != '21155' AND ean13 != '' 12/06/2023 11:22:42 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002155', date_upd = NOW() WHERE id_product = '21155' 12/06/2023 11:22:42 am >> UPDATE ps_product_lang SET name = 'BRACCIALE TENNIS + MEDAGLIA - 209', description = '' WHERE id_product = '21155' 12/06/2023 11:22:42 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '2.377049180327869' WHERE id_product = '21155' 12/06/2023 11:22:42 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '2.377049180327869', id_tax_rules_group = '1', id_category_default = '210', 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 = '21155' 12/06/2023 11:22:42 am >> DELETE FROM ps_specific_price WHERE id_product = '21155' 12/06/2023 11:22:44 am >> 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 = '21155' 12/06/2023 11:22:44 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21156' , '1' , '' , 'nuovo-prodotto' ) 12/06/2023 11:22:44 am >> 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 '21156' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21155' 12/06/2023 11:22:44 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21156' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21155' 12/06/2023 11:23:17 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' , '490/2023' , '2023-06-09' , '2023' , '0' , '16' , '2611' , 'VIA S. FRNCESCO D\\\'ASSISI, 28 60025 LORETO' , '' , '' , '17.57' , '1' , '0' , '0' , '0' , '' , '9' , '0' , '330.39' , '270.81' , NOW() , NOW() ) 12/06/2023 11:23:17 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 = '85812' 12/06/2023 11:23:17 am >> DELETE FROM ps_document_detail WHERE id_document = '85812' 12/06/2023 11:23:17 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 ( '85812' , '13355' , 'ROSARIO CRISTALLO VARI COLORI - 07777' , '17' , '17' , '1' , '4.79' , '3.9262295081967' , '22' , '3' , '96.3643' ) 12/06/2023 11:23:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '13355' AND id_supplier = '16' 12/06/2023 11:23:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13355' , '16' , '1' ) 12/06/2023 11:23:17 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 ( '85812' , '21152' , 'BRACCIALE ARG. - 123/124' , '2' , '2' , '1' , '16.5' , '13.524590163934' , '22' , '3' , '39.0522' ) 12/06/2023 11:23:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '21152' AND id_supplier = '16' 12/06/2023 11:23:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21152' , '16' , '1' ) 12/06/2023 11:23:17 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 ( '85812' , '21153' , 'ROSARIO CRISTALLO COPPIGLIATO ARGEBN - 18600' , '6' , '6' , '1' , '4.39' , '3.5983606557377' , '22' , '3' , '31.1708' ) 12/06/2023 11:23:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '21153' AND id_supplier = '16' 12/06/2023 11:23:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21153' , '16' , '1' ) 12/06/2023 11:23:17 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 ( '85812' , '21154' , 'ROSARIO CRISTALLO COPPIGLIATO DORATO - 18620' , '2' , '2' , '1' , '4.95' , '4.0573770491803' , '22' , '3' , '11.7157' ) 12/06/2023 11:23:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '21154' AND id_supplier = '16' 12/06/2023 11:23:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21154' , '16' , '1' ) 12/06/2023 11:23:17 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 ( '85812' , '21155' , 'BRACCIALE TENNIS + MEDAGLIA - 209' , '96' , '96' , '1' , '1.15' , '0.94262295081967' , '22' , '3' , '130.6474' ) 12/06/2023 11:23:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '21155' AND id_supplier = '16' 12/06/2023 11:23:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21155' , '16' , '1' ) 12/06/2023 11:35:18 am >> SELECT document_num FROM ps_document WHERE document_num = '2038' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-12') 12/06/2023 11:35:18 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' , '2038' , '2023-06-12' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.60' , '6.23' , NOW() , NOW() ) 12/06/2023 11:35:18 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 = '85813' 12/06/2023 11:35:18 am >> DELETE FROM ps_document_detail WHERE id_document = '85813' 12/06/2023 11:35:18 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 ( '85813' , '17617' , 'IMMAGINI ISONZO X 100' , '2' , '-2' , '1' , '3.80' , '3.1147540983607' , '22' , '0' , '7.60' ) 12/06/2023 12:10:41 pm >> SELECT document_num FROM ps_document WHERE document_num = '2039' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-12') 12/06/2023 12:10: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 ( '11' , '2039' , '2023-06-12' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '31.80' , '30.72' , NOW() , NOW() ) 12/06/2023 12:10: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 = '85814' 12/06/2023 12:10:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '85814' 12/06/2023 12:10: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 ( '85814' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '8' , '-8' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '28.00' ) 12/06/2023 12:10: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 ( '85814' , '3224' , 'CUORE DI DIO FATTO UOMO - POLLANO G.' , '1' , '-1' , '4' , '4.00' , '4' , '0' , '5' , '3.80' ) 12/06/2023 12:22:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '2040' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-12') 12/06/2023 12:22:00 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' , '2040' , '2023-06-12' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '287.40' , '236.01' , NOW() , NOW() ) 12/06/2023 12:22: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 = '85815' 12/06/2023 12:22:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '85815' 12/06/2023 12:22: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 ( '85815' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '285' , '233.60655737705' , '22' , '0' , '285.00' ) 12/06/2023 12:22: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 ( '85815' , '15019' , 'PREGHIAMO CON MARIA' , '3' , '-3' , '4' , '0.80' , '0.8' , '0' , '0' , '2.40' ) 12/06/2023 12:33:40 pm >> SELECT document_num FROM ps_document WHERE document_num = '2041' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-12') 12/06/2023 12:33:40 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' , '2041' , '2023-06-12' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.00' , '10.66' , NOW() , NOW() ) 12/06/2023 12:33: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 = '85816' 12/06/2023 12:33:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '85816' 12/06/2023 12:33: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 ( '85816' , '15206' , 'ANELLO CROCE/MIRACOLOSA' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 12/06/2023 04:40:01 pm >> SELECT document_num FROM ps_document WHERE document_num = '2035' AND id_document != '85809' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-12') 12/06/2023 04:40:01 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2035', document_date = '2023-06-12', 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 = '2.50', price_tax_excluded = '2.05', date_upd = NOW() WHERE id_document = '85809' 12/06/2023 04:40: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 = '85809' 12/06/2023 04:40:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '85809' 12/06/2023 04:40:01 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 ( '85809' , '21155' , 'BRACCIALE TENNIS + MEDAGLIA - 209' , '1' , '-1' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '2.50' ) 12/06/2023 04:40:25 pm >> SELECT document_num FROM ps_document WHERE document_num = '1893' AND id_document != '85630' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-30') 12/06/2023 04:40:25 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1893', document_date = '2023-05-30', 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 = '7.50', price_tax_excluded = '6.15', date_upd = NOW() WHERE id_document = '85630' 12/06/2023 04:40: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 = '85630' 12/06/2023 04:40:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '85630' 12/06/2023 04:40: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 ( '85630' , '14926' , 'VESTINA BATTESIMALE' , '1' , '-1' , '1' , '5.0000' , '4.0983606557377' , '22' , '0' , '5.00' ) 12/06/2023 04:40: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 ( '85630' , '15481' , 'CROCE IHS - 2389/CZ' , '1' , '-1' , '1' , '2.50' , '2.0491803278689' , '22' , '0' , '2.50' ) 12/06/2023 04:41:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '1820' AND id_document != '85545' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-25') 12/06/2023 04:41:32 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1820', document_date = '2023-05-25', 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 = '28.00', price_tax_excluded = '28.00', date_upd = NOW() WHERE id_document = '85545' 12/06/2023 04:41: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 = '85545' 12/06/2023 04:41:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '85545' 12/06/2023 04:41: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 ( '85545' , '21037' , 'SULLA TUA PAROLA LUG/AGO 2023' , '5' , '-5' , '4' , '5.00' , '5' , '0' , '5' , '23.75' ) 12/06/2023 04:41: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 ( '85545' , '21037' , 'SULLA TUA PAROLA LUG/AGO 2023' , '1' , '-1' , '4' , '4.25' , '4.25' , '0' , '0' , '4.25' ) 12/06/2023 04:41:44 pm >> DELETE FROM ps_product WHERE id_product = '4866' 12/06/2023 04:41:44 pm >> DELETE FROM ps_product_shop WHERE id_product = '4866' 12/06/2023 04:41:44 pm >> DELETE FROM ps_product_lang WHERE id_product = '4866' 12/06/2023 04:41:44 pm >> DELETE FROM ps_stock_available WHERE id_product = '4866' 12/06/2023 05:11:56 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001801' AND id_product != '18763' AND ean13 != '' 12/06/2023 05:11:56 pm >> UPDATE ps_product SET id_supplier = '113', reference = '', ean13 = '001801', date_upd = NOW() WHERE id_product = '18763' 12/06/2023 05:11:56 pm >> UPDATE ps_product_lang SET name = 'CROCE TAU ARG - 3736', description = '' WHERE id_product = '18763' 12/06/2023 05:11:56 pm >> UPDATE ps_product SET wholesale_price = '4.75', on_sale = '0', price = '12.2951' WHERE id_product = '18763' 12/06/2023 05:11:56 pm >> UPDATE ps_product_shop SET wholesale_price = '4.75', price = '12.2951', id_tax_rules_group = '1', id_category_default = '421', 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 = '18763' 12/06/2023 05:11:56 pm >> DELETE FROM ps_specific_price WHERE id_product = '18763' 12/06/2023 05:21:27 pm >> SELECT document_num FROM ps_document WHERE document_num = '2042' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-12') 12/06/2023 05:21: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' , '2042' , '2023-06-12' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '85.00' , '75.12' , NOW() , NOW() ) 12/06/2023 05:21: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 = '85817' 12/06/2023 05:21:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '85817' 12/06/2023 05:21: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 ( '85817' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.80' , '3.1147540983607' , '22' , '0' , '3.80' ) 12/06/2023 05:21: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 ( '85817' , '19901' , 'CHIARA - M. BARTOLI' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '5' , '17.10' ) 12/06/2023 05:21: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 ( '85817' , '20578' , 'TOTUM AMORIS EST ' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 12/06/2023 05:21: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 ( '85817' , '18763' , 'CROCE TAO ARG - 3736' , '1' , '-1' , '1' , '15.00' , '12.295081967213' , '22' , '0' , '15.00' ) 12/06/2023 05:21: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 ( '85817' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '11.1' , '11.1' , '0' , '0' , '11.10' ) 12/06/2023 05:21: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 ( '85817' , '1325' , 'BRACCIALE IN CORDA CON TAU - 1649' , '12' , '-12' , '1' , '1.5' , '1.2295081967213' , '22' , '0' , '18.00' ) 12/06/2023 05:21: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 ( '85817' , '11684' , 'BRACCIALE TAU' , '12' , '-12' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '18.00' ) 12/06/2023 05:55:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '2043' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-12') 12/06/2023 05:55: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' , '2043' , '2023-06-12' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '260.00' , '213.11' , NOW() , NOW() ) 12/06/2023 05:55: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 = '85818' 12/06/2023 05:55:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '85818' 12/06/2023 05:55: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 ( '85818' , '20114' , 'FATIMA CM 95 - 1039/P' , '1' , '-1' , '1' , '260' , '213.11475409836' , '22' , '0' , '260.00' ) 12/06/2023 07:03:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '2044' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-12') 12/06/2023 07:03:09 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' , '2044' , '2023-06-12' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '50.00' , '40.98' , NOW() , NOW() ) 12/06/2023 07:03:09 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 = '85819' 12/06/2023 07:03:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '85819' 12/06/2023 07:03:09 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 ( '85819' , '13334' , 'CROCE IN ULIVO CON LACCIO' , '2' , '-2' , '1' , '1' , '0.81967213114754' , '22' , '0' , '2.00' ) 12/06/2023 07:03:09 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 ( '85819' , '20078' , 'ROSARIO ARGENTO' , '1' , '-1' , '1' , '48' , '39.344262295082' , '22' , '0' , '48.00' ) 12/06/2023 07:33:51 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('2023-06-12') 12/06/2023 07:33:51 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' , '2023-06-12' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '24.00' , '19.67' , NOW() , NOW() ) 12/06/2023 07:33:51 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 = '85820' 12/06/2023 07:33:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '85820' 12/06/2023 07:33:51 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 ( '85820' , '13537' , 'ANGELO RESINA CON CUORE - 4208' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 12/06/2023 07:33:51 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 ( '85820' , '21153' , 'ROSARIO CRISTALLO COPPIGLIATO ARGEBN - 18600' , '1' , '-1' , '1' , '11.00' , '9.016393442623' , '22' , '0' , '11.00' ) 12/06/2023 07:34:40 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('2023-06-12') 12/06/2023 07:34:40 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' , '2023-06-12' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '67.52' , '66.90' , NOW() , NOW() ) 12/06/2023 07:34: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 = '85821' 12/06/2023 07:34:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '85821' 12/06/2023 07:34: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 ( '85821' , '21143' , 'AGGIUNTA CANTI 2023' , '12' , '-12' , '4' , '4.50' , '4.5' , '0' , '5' , '51.36' ) 12/06/2023 07:34: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 ( '85821' , '21142' , 'AGGIUNTA SPARTITI 2023' , '2' , '-2' , '3' , '8.50' , '8.1730769230769' , '4' , '5' , '16.16' )