16/06/2022 08:22:24 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 16/06/2022 08:22:24 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19654' , '1' , '' , 'nuovo-prodotto' ) 16/06/2022 08:22:24 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '19654' , '1' , '1' , '2' , NOW() , NOW() ) 16/06/2022 08:22:24 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '19654' , '0' , '1' , '0' , '0' ) 16/06/2022 08:23:17 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831537605' AND id_product != '19654' AND ean13 != '' 16/06/2022 08:23:17 am >> UPDATE ps_product SET id_supplier = '', reference = '5/6', ean13 = '9788831537605', date_upd = NOW() WHERE id_product = '19654' 16/06/2022 08:23:17 am >> UPDATE ps_product_lang SET name = 'ALBUM RICORDO PRIMA COMUNIONE', description = '' WHERE id_product = '19654' 16/06/2022 08:23:17 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '12.5' WHERE id_product = '19654' 16/06/2022 08:23:17 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '12.5', id_tax_rules_group = '4', id_category_default = '27', 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 = '19654' 16/06/2022 08:23:17 am >> DELETE FROM ps_specific_price WHERE id_product = '19654' 16/06/2022 08:23:19 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 = '19654' 16/06/2022 08:23:19 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19655' , '1' , '' , 'nuovo-prodotto' ) 16/06/2022 08:23:19 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 '19655' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19654' 16/06/2022 08:23:19 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19655' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19654' 16/06/2022 08:24:04 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831552974' AND id_product != '19655' AND ean13 != '' 16/06/2022 08:24:04 am >> UPDATE ps_product SET id_supplier = '', reference = '5/6', ean13 = '9788831552974', date_upd = NOW() WHERE id_product = '19655' 16/06/2022 08:24:04 am >> UPDATE ps_product_lang SET name = 'FESTA DELLA PRIMA COMUNIONE', description = '' WHERE id_product = '19655' 16/06/2022 08:24:04 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '13.9' WHERE id_product = '19655' 16/06/2022 08:24:04 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '13.9', id_tax_rules_group = '4', id_category_default = '27', 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 = '19655' 16/06/2022 08:24:04 am >> DELETE FROM ps_specific_price WHERE id_product = '19655' 16/06/2022 08:24:05 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 = '19655' 16/06/2022 08:24:05 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19656' , '1' , '' , 'nuovo-prodotto' ) 16/06/2022 08:24:05 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 '19656' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19655' 16/06/2022 08:24:05 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19656' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19655' 16/06/2022 08:25: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 ( '33' , '602423' , '2022-06-14' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '2.3' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '77.97' , '77.97' , NOW() , NOW() ) 16/06/2022 08:25: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 = '58788' 16/06/2022 08:25:45 am >> DELETE FROM ps_document_detail WHERE id_document = '58788' 16/06/2022 08:25: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 ( '58788' , '19157' , 'COMUNIONE AGLI INFERMI - N.E.' , '12' , '12' , '4' , '2.00' , '2' , '0' , '33' , '16.0800' ) 16/06/2022 08:25:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '19157' AND id_supplier = '7' 16/06/2022 08:25:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19157' , '7' , '1' ) 16/06/2022 08:25: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 ( '58788' , '19157' , 'COMUNIONE AGLI INFERMI - N.E.' , '1' , '1' , '4' , '2.00' , '2' , '0' , '100' , '0.0000' ) 16/06/2022 08:25:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '19157' AND id_supplier = '7' 16/06/2022 08:25:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19157' , '7' , '1' ) 16/06/2022 08:25: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 ( '58788' , '15227' , 'ALBUM DELLA PRIMA COMUNIONE' , '1' , '1' , '4' , '12.90' , '12.9' , '0' , '35' , '8.3850' ) 16/06/2022 08:25:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '15227' AND id_supplier = '7' 16/06/2022 08:25:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15227' , '7' , '1' ) 16/06/2022 08:25: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 ( '58788' , '370' , 'ALBUM DELLA MIA PRIMA COMUNIONE' , '1' , '1' , '4' , '12.90' , '12.9' , '0' , '35' , '8.3850' ) 16/06/2022 08:25:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '370' AND id_supplier = '7' 16/06/2022 08:25:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '370' , '7' , '1' ) 16/06/2022 08:25: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 ( '58788' , '19654' , 'ALBUM RICORDO PRIMA COMUNIONE' , '1' , '1' , '4' , '12.50' , '12.5' , '0' , '33' , '8.3750' ) 16/06/2022 08:25:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '19654' AND id_supplier = '7' 16/06/2022 08:25:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19654' , '7' , '1' ) 16/06/2022 08:25: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 ( '58788' , '4487' , 'GESÙ NEL CUORE - ALBUM PRIMA COMUNIONE' , '1' , '1' , '4' , '12.90' , '12.9' , '0' , '35' , '8.3850' ) 16/06/2022 08:25:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '4487' AND id_supplier = '7' 16/06/2022 08:25:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4487' , '7' , '1' ) 16/06/2022 08:25: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 ( '58788' , '19655' , 'FESTA DELLA PRIMA COMUNIONE' , '1' , '1' , '4' , '13.90' , '13.9' , '0' , '33' , '9.3130' ) 16/06/2022 08:25:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '19655' AND id_supplier = '7' 16/06/2022 08:25:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19655' , '7' , '1' ) 16/06/2022 08:25: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 ( '58788' , '18907' , 'ANGELO MI DISSE - A. COMASTRI' , '1' , '1' , '4' , '25.00' , '25' , '0' , '33' , '16.7500' ) 16/06/2022 08:25:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '18907' AND id_supplier = '7' 16/06/2022 08:25:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18907' , '7' , '1' ) 16/06/2022 08:48:11 am >> SELECT document_num FROM ps_document WHERE document_num = '1846' AND id_document != '58679' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-09') 16/06/2022 08:48:11 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1846', document_date = '2022-06-09', 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 = '18.00', price_tax_excluded = '14.75', date_upd = NOW() WHERE id_document = '58679' 16/06/2022 08:48: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 = '58679' 16/06/2022 08:48:11 am >> DELETE FROM ps_document_detail WHERE id_document = '58679' 16/06/2022 08:48: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 ( '58679' , '12047' , 'MAXI CARD - M0107/K131' , '8' , '-8' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '9.60' ) 16/06/2022 08:48:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '12047' AND id_supplier = '' 16/06/2022 08:48:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12047' , '' , '1' ) 16/06/2022 08:48: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 ( '58679' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '3.7' , '3.0327868852459' , '22' , '0' , '3.70' ) 16/06/2022 08:48:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 16/06/2022 08:48:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 16/06/2022 08:48: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 ( '58679' , '9719' , 'SCATOLINA CON PERGAMENA IN POLIMERO - COMUNIONE - 2301 ' , '1' , '-1' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '1.20' ) 16/06/2022 08:48:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '9719' AND id_supplier = '' 16/06/2022 08:48:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9719' , '' , '1' ) 16/06/2022 08:48:12 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 ( '58679' , '16969' , 'CORONA DELLE ROSE - 10974' , '1' , '-1' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '3.50' ) 16/06/2022 08:48:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '16969' AND id_supplier = '' 16/06/2022 08:48:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16969' , '' , '1' ) 16/06/2022 09:05:19 am >> SELECT ean13 FROM ps_product WHERE ean13 = '000348' AND id_product != '19656' AND ean13 != '' 16/06/2022 09:05:19 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '000348', date_upd = NOW() WHERE id_product = '19656' 16/06/2022 09:05:19 am >> UPDATE ps_product_lang SET name = 'VIA CRUCIS 15 STAZIONI - 37X28', description = '' WHERE id_product = '19656' 16/06/2022 09:05:19 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0' WHERE id_product = '19656' 16/06/2022 09:05:19 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0', id_tax_rules_group = '1', id_category_default = '165', 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 = '19656' 16/06/2022 09:05:19 am >> DELETE FROM ps_specific_price WHERE id_product = '19656' 16/06/2022 09:05: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 = '19656' 16/06/2022 09:05:23 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19657' , '1' , '' , 'nuovo-prodotto' ) 16/06/2022 09:05: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 '19657' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19656' 16/06/2022 09:05:23 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19657' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19656' 16/06/2022 09:06:29 am >> SELECT ean13 FROM ps_product WHERE ean13 = '000350' AND id_product != '19657' AND ean13 != '' 16/06/2022 09:06:29 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '000350', date_upd = NOW() WHERE id_product = '19657' 16/06/2022 09:06:29 am >> UPDATE ps_product_lang SET name = 'STATUA ADDOLORATA CM 20 - 355', description = '' WHERE id_product = '19657' 16/06/2022 09:06:29 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '34.42622950819672' WHERE id_product = '19657' 16/06/2022 09:06:29 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '34.42622950819672', id_tax_rules_group = '1', id_category_default = '165', 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 = '19657' 16/06/2022 09:06:29 am >> DELETE FROM ps_specific_price WHERE id_product = '19657' 16/06/2022 09:06:31 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 = '19657' 16/06/2022 09:06:31 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19658' , '1' , '' , 'nuovo-prodotto' ) 16/06/2022 09:06:31 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 '19658' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19657' 16/06/2022 09:06:31 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19658' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19657' 16/06/2022 09:07:06 am >> SELECT ean13 FROM ps_product WHERE ean13 = '000348' AND id_product != '19656' AND ean13 != '' 16/06/2022 09:07:06 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '000348', date_upd = NOW() WHERE id_product = '19656' 16/06/2022 09:07:06 am >> UPDATE ps_product_lang SET name = 'VIA CRUCIS 15 STAZIONI - 37X28', description = '' WHERE id_product = '19656' 16/06/2022 09:07:06 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '754.0983606557377' WHERE id_product = '19656' 16/06/2022 09:07:06 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '754.0983606557377', id_tax_rules_group = '1', id_category_default = '165', 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 = '19656' 16/06/2022 09:07:06 am >> DELETE FROM ps_specific_price WHERE id_product = '19656' 16/06/2022 09:07:46 am >> SELECT ean13 FROM ps_product WHERE ean13 = '000348' AND id_product != '19656' AND ean13 != '' 16/06/2022 09:07:46 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '000348', date_upd = NOW() WHERE id_product = '19656' 16/06/2022 09:07:46 am >> UPDATE ps_product_lang SET name = 'VIA CRUCIS 15 STAZIONI - 37X28', description = '' WHERE id_product = '19656' 16/06/2022 09:07:46 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '788.5245901639345' WHERE id_product = '19656' 16/06/2022 09:07:46 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '788.5245901639345', id_tax_rules_group = '1', id_category_default = '165', 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 = '19656' 16/06/2022 09:07:46 am >> DELETE FROM ps_specific_price WHERE id_product = '19656' 16/06/2022 09:08:05 am >> SELECT ean13 FROM ps_product WHERE ean13 = '000350' AND id_product != '19657' AND ean13 != '' 16/06/2022 09:08:05 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '000350', date_upd = NOW() WHERE id_product = '19657' 16/06/2022 09:08:05 am >> UPDATE ps_product_lang SET name = 'STATUA ADDOLORATA CM 20 - 355', description = '' WHERE id_product = '19657' 16/06/2022 09:08:05 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '36.0655737704918' WHERE id_product = '19657' 16/06/2022 09:08:05 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '36.0655737704918', id_tax_rules_group = '1', id_category_default = '165', 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 = '19657' 16/06/2022 09:08:05 am >> DELETE FROM ps_specific_price WHERE id_product = '19657' 16/06/2022 09:08:28 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' , '242/2022' , '2022-06-14' , '2022' , '0' , '130' , '4670548' , 'VIA CARRAIA,4/6/8 55025 COREGLIA ANTELMINELLI' , '' , '' , '20' , '1' , '0' , '0' , '0' , '' , '3' , '0' , '503.81' , '412.96' , NOW() , NOW() ) 16/06/2022 09:08:28 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 = '58789' 16/06/2022 09:08:28 am >> DELETE FROM ps_document_detail WHERE id_document = '58789' 16/06/2022 09:08:28 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 ( '58789' , '19656' , 'VIA CRUCIS 15 STAZIONI - 37X28' , '1' , '1' , '1' , '396' , '324.59016393443' , '22' , '5' , '458.9640' ) 16/06/2022 09:08:28 am >> DELETE FROM ps_product_supplier WHERE id_product = '19656' AND id_supplier = '130' 16/06/2022 09:08:28 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19656' , '130' , '1' ) 16/06/2022 09:08:28 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 ( '58789' , '19657' , 'STATUA ADDOLORATA CM 20 - 355' , '1' , '1' , '1' , '17.64' , '14.459016393443' , '22' , '5' , '20.4448' ) 16/06/2022 09:08:28 am >> DELETE FROM ps_product_supplier WHERE id_product = '19657' AND id_supplier = '130' 16/06/2022 09:08:28 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19657' , '130' , '1' ) 16/06/2022 09:47:41 am >> SELECT document_num FROM ps_document WHERE document_num = '1944' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-16') 16/06/2022 09:47:41 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' , '1944' , '2022-06-16' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '70.00' , '57.38' , NOW() , NOW() ) 16/06/2022 09:47:41 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 = '58790' 16/06/2022 09:47:41 am >> DELETE FROM ps_document_detail WHERE id_document = '58790' 16/06/2022 09:47:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58790' , '17101' , 'CASULA POLIESTERE CROCE ORO - AECU04' , '1' , '-1' , '1' , '70' , '57.377049180328' , '22' , '0' , '70.00' ) 16/06/2022 09:47:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '17101' AND id_supplier = '' 16/06/2022 09:47:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17101' , '' , '1' ) 16/06/2022 10:56:53 am >> SELECT document_num FROM ps_document WHERE document_num = '1945' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-16') 16/06/2022 10:56: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' , '1945' , '2022-06-16' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '105.00' , '86.07' , NOW() , NOW() ) 16/06/2022 10:56: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 = '58791' 16/06/2022 10:56:53 am >> DELETE FROM ps_document_detail WHERE id_document = '58791' 16/06/2022 10:56: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 ( '58791' , '19396' , 'CLERGY MISTO COTONE MM - C01' , '1' , '-1' , '1' , '35' , '28.688524590164' , '22' , '0' , '35.00' ) 16/06/2022 10:56:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '19396' AND id_supplier = '' 16/06/2022 10:56:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19396' , '' , '1' ) 16/06/2022 10:56: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 ( '58791' , '19594' , 'POLO JERSEY COTONE 100%' , '1' , '-1' , '1' , '36' , '29.508196721311' , '22' , '0' , '36.00' ) 16/06/2022 10:56:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '19594' AND id_supplier = '' 16/06/2022 10:56:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19594' , '' , '1' ) 16/06/2022 10:56: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 ( '58791' , '2177' , 'CLERGY BASIC - MM - B&P' , '1' , '-1' , '1' , '32' , '26.229508196721' , '22' , '0' , '32.00' ) 16/06/2022 10:56:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '2177' AND id_supplier = '' 16/06/2022 10:56:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2177' , '' , '1' ) 16/06/2022 10:56: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 ( '58791' , '9333' , 'SACRO CUORE DI GESÙ - 208 ' , '1' , '-1' , '1' , '2' , '1.6393442622951' , '22' , '0' , '2.00' ) 16/06/2022 10:56:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '9333' AND id_supplier = '' 16/06/2022 10:56:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9333' , '' , '1' ) 16/06/2022 11:17:01 am >> SELECT document_num FROM ps_document WHERE document_num = '1946' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-16') 16/06/2022 11:17:02 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1946' , '2022-06-16' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.52' , '5.52' , NOW() , NOW() ) 16/06/2022 11:17:02 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58792' 16/06/2022 11:17:02 am >> DELETE FROM ps_document_detail WHERE id_document = '58792' 16/06/2022 11:17:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58792' , '19517' , 'PAROLA E PREGHIERA - LUG 2022' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '5' , '2.76' ) 16/06/2022 11:17:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '19517' AND id_supplier = '' 16/06/2022 11:17:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19517' , '' , '1' ) 16/06/2022 11:17:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58792' , '19567' , 'PAROLA E PREGHIERA - AGO 2022' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '5' , '2.76' ) 16/06/2022 11:17:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '19567' AND id_supplier = '' 16/06/2022 11:17:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19567' , '' , '1' ) 16/06/2022 11:27:38 am >> SELECT document_num FROM ps_document WHERE document_num = '1947' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-16') 16/06/2022 11:27:38 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' , '1947' , '2022-06-16' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.25' , '14.25' , NOW() , NOW() ) 16/06/2022 11:27:38 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 = '58793' 16/06/2022 11:27:38 am >> DELETE FROM ps_document_detail WHERE id_document = '58793' 16/06/2022 11:27:38 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 ( '58793' , '19647' , 'ANTICORPI DI PACE - TONONO BELLO' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 16/06/2022 11:27:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '19647' AND id_supplier = '' 16/06/2022 11:27:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19647' , '' , '1' ) 16/06/2022 12:12:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '1948' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-16') 16/06/2022 12:12:57 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' , '1948' , '2022-06-16' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.50' , '11.07' , NOW() , NOW() ) 16/06/2022 12:12:57 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 = '58794' 16/06/2022 12:12:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '58794' 16/06/2022 12:12:58 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 ( '58794' , '1912' , 'CERA DELL\'EREMO - 415/B ' , '2' , '-2' , '1' , '5.50' , '4.5081967213115' , '22' , '0' , '11.00' ) 16/06/2022 12:12:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1912' AND id_supplier = '' 16/06/2022 12:12:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1912' , '' , '1' ) 16/06/2022 12:12:58 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 ( '58794' , '14772' , 'BRACCIALE SAN BENEDETTO 4 COLORI - 0818/3' , '1' , '-1' , '1' , '2.50' , '2.0491803278689' , '22' , '0' , '2.50' ) 16/06/2022 12:12:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14772' AND id_supplier = '' 16/06/2022 12:12:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14772' , '' , '1' ) 16/06/2022 01:20:01 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000351' AND id_product != '19658' AND ean13 != '' 16/06/2022 01:20:01 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '000351', date_upd = NOW() WHERE id_product = '19658' 16/06/2022 01:20:01 pm >> UPDATE ps_product_lang SET name = 'cotta - m070 lino100%', description = '' WHERE id_product = '19658' 16/06/2022 01:20:01 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '532.7868852459017' WHERE id_product = '19658' 16/06/2022 01:20:01 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '532.7868852459017', id_tax_rules_group = '1', id_category_default = '494', 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 = '19658' 16/06/2022 01:20:01 pm >> DELETE FROM ps_specific_price WHERE id_product = '19658' 16/06/2022 01:20:25 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '100' , '2022-06-15' , '' , '0' , '160' , '4673832' , 'VIA TIRABOSCHI 13 24017 SERINA ' , '' , 'cambiare numero' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '0.00' , '0.00' , NOW() , NOW() ) 16/06/2022 01:20:25 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58795' 16/06/2022 01:20:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '58795' 16/06/2022 01:20:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58795' , '19658' , 'cotta - m070 lino100%' , '1' , '1' , '1' , '0' , '0' , '22' , '0' , '0.0000' ) 16/06/2022 01:20:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19658' AND id_supplier = '160' 16/06/2022 01:20:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19658' , '160' , '1' ) 16/06/2022 03:19:20 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892229006' AND id_product != '19647' AND ean13 != '' 16/06/2022 03:19:20 pm >> UPDATE ps_product SET id_supplier = '7', reference = '6/5', ean13 = '9788892229006', date_upd = NOW() WHERE id_product = '19647' 16/06/2022 03:19:20 pm >> UPDATE ps_product_lang SET name = 'ANTICORPI DI PACE - TONiNO BELLO', description = '' WHERE id_product = '19647' 16/06/2022 03:19:20 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '15.0000' WHERE id_product = '19647' 16/06/2022 03:19:20 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '15.0000', id_tax_rules_group = '4', id_category_default = '30', 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 = '19647' 16/06/2022 03:19:20 pm >> DELETE FROM ps_specific_price WHERE id_product = '19647' 16/06/2022 03:22:21 pm >> SELECT document_num FROM ps_document WHERE document_num = '1949' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-16') 16/06/2022 03:22:21 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' , '1949' , '2022-06-16' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.90' , '12.90' , NOW() , NOW() ) 16/06/2022 03:22:21 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58796' 16/06/2022 03:22:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '58796' 16/06/2022 03:22:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58796' , '15227' , 'ALBUM DELLA PRIMA COMUNIONE' , '1' , '-1' , '4' , '12.90' , '12.9' , '0' , '0' , '12.90' ) 16/06/2022 03:22:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15227' AND id_supplier = '' 16/06/2022 03:22:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15227' , '' , '1' ) 16/06/2022 03:37:20 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788895783178' AND id_product != '14330' AND ean13 != '' 16/06/2022 03:37:20 pm >> UPDATE ps_product SET id_supplier = '107', reference = '2/4', ean13 = '9788895783178', date_upd = NOW() WHERE id_product = '14330' 16/06/2022 03:37:20 pm >> UPDATE ps_product_lang SET name = '100 GIORNI CON LO SPIRITO', description = '' WHERE id_product = '14330' 16/06/2022 03:37:20 pm >> UPDATE ps_product SET wholesale_price = '4.55', on_sale = '0', price = '7.5' WHERE id_product = '14330' 16/06/2022 03:37:20 pm >> UPDATE ps_product_shop SET wholesale_price = '4.55', price = '7.5', id_tax_rules_group = '4', id_category_default = '37', id_argoment_default = '108', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '14330' 16/06/2022 03:37:20 pm >> DELETE FROM ps_specific_price WHERE id_product = '14330' 16/06/2022 03:38:05 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788895783178' AND id_product != '33' AND ean13 != '' 16/06/2022 03:38:05 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788895783178', date_upd = NOW() WHERE id_product = '33' 16/06/2022 03:38:05 pm >> UPDATE ps_product_lang SET name = '100 GIORNI CON LO SPIRITO', description = '

Questo piccolo libro nasce con un grande obiettivo: convincere i ragazzi a non mollare.

Dopo i giorni vissuti in preparazione alla\r\nCresima, ecco la sfida: 100 giorni per continuare con fervore il proprio cammino\r\nnella Chiesa.

Ogni giorno un pensiero, un brano di Vangelo, una storia\r\ncommentata per riflettere sui valori della vita, su ciò per cui vale veramente la pena credere e\r\nlottare accompagnato da una bellissima immagine.

' WHERE id_product = '33' 16/06/2022 03:38:05 pm >> UPDATE ps_product SET wholesale_price = '1.65', on_sale = '0', price = '7.5' WHERE id_product = '33' 16/06/2022 03:38:05 pm >> UPDATE ps_product_shop SET wholesale_price = '1.65', price = '7.5', id_tax_rules_group = '4', id_category_default = '2', id_argoment_default = '', id_internal_category = '', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '1', date_upd = NOW() WHERE id_product = '33' 16/06/2022 03:38:05 pm >> DELETE FROM ps_specific_price WHERE id_product = '33' 16/06/2022 03:38:05 pm >> INSERT INTO ps_specific_price ( id_specific_price_rule , id_cart , id_product , id_shop , id_shop_group , id_currency , id_country , id_group , id_customer , id_product_attribute , price , from_quantity , reduction , reduction_tax , reduction_type , `from` , `to`) VALUES ( '0' , '0' , '33' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' ) 16/06/2022 03:39:43 pm >> DELETE FROM ps_product WHERE id_product = '24' 16/06/2022 03:39:43 pm >> DELETE FROM ps_product_shop WHERE id_product = '24' 16/06/2022 03:39:43 pm >> DELETE FROM ps_product_lang WHERE id_product = '24' 16/06/2022 03:39:44 pm >> DELETE FROM ps_stock_available WHERE id_product = '24' 16/06/2022 04:29:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '8/L' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-06-16') 16/06/2022 04:29:55 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 ( '23' , '8/L' , '2022-06-16' , 'L' , '3812' , '0' , '4672633' , 'LARGO PLEBISCITO 12 84121 SALERNO ' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '607.70' , '503.40' , NOW() , NOW() ) 16/06/2022 04:29:55 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 = '58797' 16/06/2022 04:29:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '58797' 16/06/2022 04:29:55 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 ( '58797' , '17161' , 'CARBONCINI NERI - CARNE' , '3' , '-3' , '1' , '11.0000' , '9.0164' , '22' , '0' , '33.00' ) 16/06/2022 04:29:55 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 ( '58797' , '19102' , 'CARBONCINI MM 40' , '2' , '-2' , '1' , '13.0000' , '10.6557' , '22' , '0' , '26.00' ) 16/06/2022 04:29:55 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 ( '58797' , '7311' , 'OSTIA SOTTILE 74MM' , '15' , '-15' , '3' , '1.9000' , '1.8269' , '4' , '0' , '28.50' ) 16/06/2022 04:29:55 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 ( '58797' , '7673' , 'PARTICOLE MM38' , '2' , '-2' , '3' , '3.5000' , '3.3654' , '4' , '0' , '7.00' ) 16/06/2022 04:29:55 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 ( '58797' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7000' , '3.8525' , '22' , '0' , '56.40' ) 16/06/2022 04:29:55 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 ( '58797' , '18095' , 'CROCE IN ULIVO - 2882' , '5' , '-5' , '1' , '24.8000' , '20.3279' , '22' , '0' , '124.00' ) 16/06/2022 04:29:55 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 ( '58797' , '17005' , 'BIGLIETTO AUGURALE medio' , '13' , '-13' , '1' , '1.0000' , '0.8197' , '22' , '0' , '13.00' ) 16/06/2022 04:29:55 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 ( '58797' , '1914' , 'CERA DELLA LITURGIA' , '60' , '-60' , '1' , '4.5000' , '3.6885' , '22' , '0' , '270.00' ) 16/06/2022 04:29:55 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 ( '58797' , '19099' , 'INCENSO A' , '1' , '-1' , '1' , '46.0000' , '37.7049' , '22' , '0' , '46.00' ) 16/06/2022 04:29:55 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 ( '58797' , '17004' , 'BIGLIETTO AUGURALE PICCOLO' , '3' , '-3' , '1' , '0.8000' , '0.6557' , '22' , '0' , '2.40' ) 16/06/2022 04:29:55 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 ( '58797' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '2' , '-2' , '4' , '0.7000' , '0.7' , '0' , '0' , '1.40' ) 16/06/2022 04:30:18 pm >> SELECT document_num FROM ps_document WHERE document_num = '8/L' AND id_document != '58797' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-06-16') 16/06/2022 04:30:18 pm >> UPDATE ps_document SET id_document_type = '23', document_num = '8/L', document_date = '2022-06-16', document_letter = 'L', id_customer = '3812', id_supplier = '', id_address = '4672633', address1 = 'LARGO PLEBISCITO 12 84121 SALERNO ', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '607.70', price_tax_excluded = '503.40', date_upd = NOW() WHERE id_document = '58797' 16/06/2022 04:30:18 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 = '58797' 16/06/2022 04:30:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '58797' 16/06/2022 04:30:19 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 ( '58797' , '17161' , 'CARBONCINI NERI - CARNE' , '3' , '-3' , '1' , '11.0000' , '9.016393442623' , '22' , '0' , '33.00' ) 16/06/2022 04:30:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17161' AND id_supplier = '' 16/06/2022 04:30:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17161' , '' , '1' ) 16/06/2022 04:30:19 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 ( '58797' , '19102' , 'CARBONCINI MM 40' , '2' , '-2' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '26.00' ) 16/06/2022 04:30:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19102' AND id_supplier = '' 16/06/2022 04:30:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19102' , '' , '1' ) 16/06/2022 04:30:19 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 ( '58797' , '7311' , 'OSTIA SOTTILE 74MM' , '15' , '-15' , '3' , '1.9000' , '1.8269230769231' , '4' , '0' , '28.50' ) 16/06/2022 04:30:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 16/06/2022 04:30:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 16/06/2022 04:30:19 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 ( '58797' , '7673' , 'PARTICOLE MM38' , '2' , '-2' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '7.00' ) 16/06/2022 04:30:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7673' AND id_supplier = '' 16/06/2022 04:30:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7673' , '' , '1' ) 16/06/2022 04:30:19 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 ( '58797' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '56.40' ) 16/06/2022 04:30:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 16/06/2022 04:30:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 16/06/2022 04:30:19 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 ( '58797' , '18095' , 'CROCE IN ULIVO - 2882' , '5' , '-5' , '1' , '24.8000' , '20.327868852459' , '22' , '0' , '124.00' ) 16/06/2022 04:30:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18095' AND id_supplier = '' 16/06/2022 04:30:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18095' , '' , '1' ) 16/06/2022 04:30:19 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 ( '58797' , '17005' , 'BIGLIETTO AUGURALE medio' , '13' , '-13' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '13.00' ) 16/06/2022 04:30:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17005' AND id_supplier = '' 16/06/2022 04:30:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17005' , '' , '1' ) 16/06/2022 04:30:19 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 ( '58797' , '1914' , 'CERA DELLA LITURGIA' , '60' , '-60' , '1' , '4.5000' , '3.6885245901639' , '22' , '0' , '270.00' ) 16/06/2022 04:30:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 16/06/2022 04:30:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 16/06/2022 04:30:19 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 ( '58797' , '19099' , 'INCENSO A' , '1' , '-1' , '1' , '46.0000' , '37.704918032787' , '22' , '0' , '46.00' ) 16/06/2022 04:30:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19099' AND id_supplier = '' 16/06/2022 04:30:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19099' , '' , '1' ) 16/06/2022 04:30:19 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 ( '58797' , '17004' , 'BIGLIETTO AUGURALE PICCOLO' , '3' , '-3' , '1' , '0.8000' , '0.65573770491803' , '22' , '0' , '2.40' ) 16/06/2022 04:30:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17004' AND id_supplier = '' 16/06/2022 04:30:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17004' , '' , '1' ) 16/06/2022 04:30:19 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 ( '58797' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '2' , '-2' , '4' , '0.7000' , '0.7' , '0' , '0' , '1.40' ) 16/06/2022 04:30:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4223' AND id_supplier = '' 16/06/2022 04:30:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4223' , '' , '1' ) 16/06/2022 04:46:54 pm >> SELECT document_num FROM ps_document WHERE document_num = '99' AND id_document != '58686' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-06-09') 16/06/2022 04:46:54 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '99', document_date = '2022-06-09', document_letter = '', id_customer = '2332', id_supplier = '', id_address = '4670946', address1 = 'P.ZZA S. ROCCO 84088 SIANO', 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 = '104.13', price_tax_excluded = '104.13', date_upd = NOW() WHERE id_document = '58686' 16/06/2022 04:46:54 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 = '58686' 16/06/2022 04:46:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '58686' 16/06/2022 04:46:54 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 ( '58686' , '11105' , 'VANGELO E ATTI DEGLI APOSTOLI PER OCCASIONI' , '35' , '-35' , '4' , '3.5000' , '3.5' , '0' , '15' , '104.13' ) 16/06/2022 04:46:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11105' AND id_supplier = '' 16/06/2022 04:46:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11105' , '' , '1' ) 16/06/2022 05:06:34 pm >> SELECT document_num FROM ps_document WHERE document_num = '1950' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-16') 16/06/2022 05:06:34 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' , '1950' , '2022-06-16' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '66.20' , '54.77' , NOW() , NOW() ) 16/06/2022 05:06:34 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 = '58798' 16/06/2022 05:06:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '58798' 16/06/2022 05:06: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 ( '58798' , '791' , 'ASSISI IN BUSTA BATTESIMO - 20X270 - BAAS' , '5' , '-5' , '1' , '1.40' , '1.1475409836066' , '22' , '0' , '7.00' ) 16/06/2022 05:06:35 pm >> DELETE FROM ps_product_supplier WHERE id_product = '791' AND id_supplier = '' 16/06/2022 05:06:35 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '791' , '' , '1' ) 16/06/2022 05:06: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 ( '58798' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '4' , '-4' , '4' , '0.70' , '0.7' , '0' , '0' , '2.80' ) 16/06/2022 05:06:35 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4223' AND id_supplier = '' 16/06/2022 05:06:35 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4223' , '' , '1' ) 16/06/2022 05:06: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 ( '58798' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 16/06/2022 05:06:35 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 16/06/2022 05:06:35 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 16/06/2022 05:06:51 pm >> SELECT document_num FROM ps_document WHERE document_num = '1951' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-16') 16/06/2022 05:06: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' , '1951' , '2022-06-16' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '18.50' , '16.52' , NOW() , NOW() ) 16/06/2022 05:06: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 = '58799' 16/06/2022 05:06:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '58799' 16/06/2022 05:06: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 ( '58799' , '15399' , 'CONF. CARTONCINO SIMBOLO MADRE PERLA CONFESSIONE - 1907/J44' , '5' , '-5' , '1' , '2.20' , '1.8032786885246' , '22' , '0' , '11.00' ) 16/06/2022 05:06:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15399' AND id_supplier = '' 16/06/2022 05:06:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15399' , '' , '1' ) 16/06/2022 05:06: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 ( '58799' , '11151' , 'LIBRI' , '5' , '-5' , '4' , '1.5' , '1.5' , '0' , '0' , '7.50' ) 16/06/2022 05:06:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 16/06/2022 05:06:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 16/06/2022 06:00:30 pm >> SELECT document_num FROM ps_document WHERE document_num = '1952' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-16') 16/06/2022 06:00:30 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' , '1952' , '2022-06-16' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '104.50' , '104.50' , NOW() , NOW() ) 16/06/2022 06:00:30 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 = '58800' 16/06/2022 06:00:30 pm >> DELETE FROM ps_document_detail WHERE id_document = '58800' 16/06/2022 06:00:30 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 ( '58800' , '17329' , 'MESSALE ROMANO DALTARE N.E' , '1' , '-1' , '4' , '110.00' , '110' , '0' , '5' , '104.50' ) 16/06/2022 06:00:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17329' AND id_supplier = '' 16/06/2022 06:00:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17329' , '' , '1' ) 16/06/2022 06:01:52 pm >> SELECT document_num FROM ps_document WHERE document_num = '1953' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-16') 16/06/2022 06:01:52 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' , '1953' , '2022-06-16' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '33.88' , '31.99' , NOW() , NOW() ) 16/06/2022 06:01:52 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 = '58801' 16/06/2022 06:01:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '58801' 16/06/2022 06:01:52 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 ( '58801' , '9216' , 'S. GIOVANNI BATTISTA - 63BIS ' , '3' , '-3' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '10.50' ) 16/06/2022 06:01:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9216' AND id_supplier = '' 16/06/2022 06:01:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9216' , '' , '1' ) 16/06/2022 06:01:52 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 ( '58801' , '15020' , 'PREGARE OGNI GIORNO' , '2' , '-2' , '4' , '1.00' , '1' , '0' , '0' , '2.00' ) 16/06/2022 06:01:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15020' AND id_supplier = '' 16/06/2022 06:01:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15020' , '' , '1' ) 16/06/2022 06:01:52 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 ( '58801' , '19050' , 'VENITE ADORIAMO - G. DAMORE' , '1' , '-1' , '4' , '7.00' , '7' , '0' , '5' , '6.65' ) 16/06/2022 06:01:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19050' AND id_supplier = '' 16/06/2022 06:01:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19050' , '' , '1' ) 16/06/2022 06:01:52 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 ( '58801' , '8383' , 'PREGHIERE PER LADORAZIONE EUCARISTICA - 8141' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 16/06/2022 06:01:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8383' AND id_supplier = '' 16/06/2022 06:01:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8383' , '' , '1' ) 16/06/2022 06:01:52 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 ( '58801' , '9450' , 'SAN GIOVANNI BATTISTA - G. PESENTI' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 16/06/2022 06:01:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9450' AND id_supplier = '' 16/06/2022 06:01:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9450' , '' , '1' ) 16/06/2022 06:06:35 pm >> SELECT document_num FROM ps_document WHERE document_num = '1954' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-16') 16/06/2022 06:06: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' , '1954' , '2022-06-16' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '650.00' , '532.79' , NOW() , NOW() ) 16/06/2022 06:06: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 = '58802' 16/06/2022 06:06:35 pm >> DELETE FROM ps_document_detail WHERE id_document = '58802' 16/06/2022 06:06: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 ( '58802' , '19658' , 'cotta - m070 lino100%' , '1' , '-1' , '1' , '650.00' , '532.7868852459' , '22' , '0' , '650.00' ) 16/06/2022 06:06:35 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19658' AND id_supplier = '' 16/06/2022 06:06:35 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19658' , '' , '1' ) 16/06/2022 06:07:29 pm >> SELECT document_num FROM ps_document WHERE document_num = '1955' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-16') 16/06/2022 06:07: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 ( '11' , '1955' , '2022-06-16' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '20.00' , '16.39' , NOW() , NOW() ) 16/06/2022 06:07: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 = '58803' 16/06/2022 06:07:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '58803' 16/06/2022 06:07: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 ( '58803' , '14687' , 'CROCE DELLAMICIZIA IN ULIVO CM 18 - 2842' , '1' , '-1' , '1' , '20.00' , '16.393442622951' , '22' , '0' , '20.00' ) 16/06/2022 06:07:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14687' AND id_supplier = '' 16/06/2022 06:07:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14687' , '' , '1' ) 16/06/2022 06:10:12 pm >> SELECT document_num FROM ps_document WHERE document_num = '1956' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-16') 16/06/2022 06:10:12 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1956' , '2022-06-16' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.00' , '5.74' , NOW() , NOW() ) 16/06/2022 06:10:12 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58804' 16/06/2022 06:10:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '58804' 16/06/2022 06:10:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58804' , '9333' , 'SACRO CUORE DI GESÙ - 208 ' , '2' , '-2' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '7.00' ) 16/06/2022 06:10:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9333' AND id_supplier = '' 16/06/2022 06:10:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9333' , '' , '1' ) 16/06/2022 06:39:26 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884041616' AND id_product != '13633' AND ean13 != '' 16/06/2022 06:39:26 pm >> UPDATE ps_product SET id_supplier = '38', reference = 'ESPOSITORE SHALOM', ean13 = '9788884041616', date_upd = NOW() WHERE id_product = '13633' 16/06/2022 06:39:26 pm >> UPDATE ps_product_lang SET name = 'SAN LUIGI MARIA DI MONTFORT', description = '' WHERE id_product = '13633' 16/06/2022 06:39:26 pm >> UPDATE ps_product SET wholesale_price = '3.00', on_sale = '0', price = '7' WHERE id_product = '13633' 16/06/2022 06:39:26 pm >> UPDATE ps_product_shop SET wholesale_price = '3.00', price = '7', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '71', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '13633' 16/06/2022 06:39:26 pm >> DELETE FROM ps_specific_price WHERE id_product = '13633' 16/06/2022 06:42:01 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884041616' AND id_product != '13633' AND ean13 != '' 16/06/2022 06:42:01 pm >> UPDATE ps_product SET id_supplier = '38', reference = 'ESPOSITORE SHALOM', ean13 = '9788884041616', date_upd = NOW() WHERE id_product = '13633' 16/06/2022 06:42:01 pm >> UPDATE ps_product_lang SET name = 'SAN LUIGI MARIA DI MONTFORT', description = '' WHERE id_product = '13633' 16/06/2022 06:42:01 pm >> UPDATE ps_product SET wholesale_price = '3.00', on_sale = '0', price = '7' WHERE id_product = '13633' 16/06/2022 06:42:01 pm >> UPDATE ps_product_shop SET wholesale_price = '3.00', price = '7', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '71', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '13633' 16/06/2022 06:42:01 pm >> DELETE FROM ps_specific_price WHERE id_product = '13633' 16/06/2022 06:44:59 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884042828' AND id_product != '11452' AND ean13 != '' 16/06/2022 06:45:00 pm >> UPDATE ps_product SET id_supplier = '', reference = 'ESPOSITORE SHALOM', ean13 = '9788884042828', date_upd = NOW() WHERE id_product = '11452' 16/06/2022 06:45:00 pm >> UPDATE ps_product_lang SET name = 'VITA E BRANI SCELTI - S. VERONICA - 8588', description = '' WHERE id_product = '11452' 16/06/2022 06:45:00 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '7' WHERE id_product = '11452' 16/06/2022 06:45:00 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '7', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '53', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '11452' 16/06/2022 06:45:00 pm >> DELETE FROM ps_specific_price WHERE id_product = '11452' 16/06/2022 06:48:39 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884043313' AND id_product != '3513' AND ean13 != '' 16/06/2022 06:48:39 pm >> UPDATE ps_product SET id_supplier = '', reference = '13/4', ean13 = '9788884043313', date_upd = NOW() WHERE id_product = '3513' 16/06/2022 06:48:39 pm >> UPDATE ps_product_lang SET name = 'DIO PERDONA SEMPRE - 8629 - S. TOGNETTI', description = '' WHERE id_product = '3513' 16/06/2022 06:48:39 pm >> UPDATE ps_product SET wholesale_price = '3.00', on_sale = '0', price = '7' WHERE id_product = '3513' 16/06/2022 06:48:39 pm >> UPDATE ps_product_shop SET wholesale_price = '3.00', price = '7', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '22', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '3513' 16/06/2022 06:48:39 pm >> DELETE FROM ps_specific_price WHERE id_product = '3513' 16/06/2022 06:51:59 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884043313' AND id_product != '3513' AND ean13 != '' 16/06/2022 06:51:59 pm >> UPDATE ps_product SET id_supplier = '', reference = '13/4', ean13 = '9788884043313', date_upd = NOW() WHERE id_product = '3513' 16/06/2022 06:51:59 pm >> UPDATE ps_product_lang SET name = 'DIO PERDONA SEMPRE - 8629 - S. TOGNETTI', description = '' WHERE id_product = '3513' 16/06/2022 06:51:59 pm >> UPDATE ps_product SET wholesale_price = '3.00', on_sale = '0', price = '7' WHERE id_product = '3513' 16/06/2022 06:51:59 pm >> UPDATE ps_product_shop SET wholesale_price = '3.00', price = '7', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '22', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '3513' 16/06/2022 06:51:59 pm >> DELETE FROM ps_specific_price WHERE id_product = '3513' 16/06/2022 06:57:21 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788886616898' AND id_product != '10299' AND ean13 != '' 16/06/2022 06:57:21 pm >> UPDATE ps_product SET id_supplier = '38', reference = 'ESPOSITORE SHALOM', ean13 = '9788886616898', date_upd = NOW() WHERE id_product = '10299' 16/06/2022 06:57:21 pm >> UPDATE ps_product_lang SET name = 'STORIA DI UN\'ANIMA - 8203', description = '' WHERE id_product = '10299' 16/06/2022 06:57:21 pm >> UPDATE ps_product SET wholesale_price = '5.40', on_sale = '0', price = '10' WHERE id_product = '10299' 16/06/2022 06:57:21 pm >> UPDATE ps_product_shop SET wholesale_price = '5.40', price = '10', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '74', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '10299' 16/06/2022 06:57:21 pm >> DELETE FROM ps_specific_price WHERE id_product = '10299' 16/06/2022 06:58:42 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788886616898' AND id_product != '10299' AND ean13 != '' 16/06/2022 06:58:42 pm >> UPDATE ps_product SET id_supplier = '38', reference = 'ESPOSITORE SHALOM', ean13 = '9788886616898', date_upd = NOW() WHERE id_product = '10299' 16/06/2022 06:58:42 pm >> UPDATE ps_product_lang SET name = 'STORIA DI UN\'ANIMA - 8203', description = '' WHERE id_product = '10299' 16/06/2022 06:58:42 pm >> UPDATE ps_product SET wholesale_price = '5.40', on_sale = '0', price = '10' WHERE id_product = '10299' 16/06/2022 06:58:42 pm >> UPDATE ps_product_shop SET wholesale_price = '5.40', price = '10', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '74', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '10299' 16/06/2022 06:58:42 pm >> DELETE FROM ps_specific_price WHERE id_product = '10299' 16/06/2022 06:59:49 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884042163' AND id_product != '4699' AND ean13 != '' 16/06/2022 06:59:49 pm >> UPDATE ps_product SET id_supplier = '38', reference = 'ESPOSITORE SHALOM', ean13 = '9788884042163', date_upd = NOW() WHERE id_product = '4699' 16/06/2022 06:59:49 pm >> UPDATE ps_product_lang SET name = 'GLORIE DI MARIA - 8243', description = '' WHERE id_product = '4699' 16/06/2022 06:59:49 pm >> UPDATE ps_product SET wholesale_price = '6.00', on_sale = '0', price = '10.0000' WHERE id_product = '4699' 16/06/2022 06:59:49 pm >> UPDATE ps_product_shop SET wholesale_price = '6.00', price = '10.0000', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '28', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '4699' 16/06/2022 06:59:49 pm >> DELETE FROM ps_specific_price WHERE id_product = '4699' 16/06/2022 07:00:18 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884040404' AND id_product != '13575' AND ean13 != '' 16/06/2022 07:00:18 pm >> UPDATE ps_product SET id_supplier = '38', reference = 'ESPOSITORE SHALOM', ean13 = '9788884040404', date_upd = NOW() WHERE id_product = '13575' 16/06/2022 07:00:18 pm >> UPDATE ps_product_lang SET name = 'GUARIGIONE E LIBERAZIONE CON IL DIGIUNO - 8246', description = '' WHERE id_product = '13575' 16/06/2022 07:00:18 pm >> UPDATE ps_product SET wholesale_price = '4.20', on_sale = '0', price = '9' WHERE id_product = '13575' 16/06/2022 07:00:18 pm >> UPDATE ps_product_shop SET wholesale_price = '4.20', price = '9', id_tax_rules_group = '4', id_category_default = '106', 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 = '13575' 16/06/2022 07:00:18 pm >> DELETE FROM ps_specific_price WHERE id_product = '13575' 16/06/2022 07:06:35 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884040619' AND id_product != '4949' AND ean13 != '' 16/06/2022 07:06:35 pm >> UPDATE ps_product SET id_supplier = '', reference = 'ESPOSITORE SHALOM', ean13 = '9788884040619', date_upd = NOW() WHERE id_product = '4949' 16/06/2022 07:06:35 pm >> UPDATE ps_product_lang SET name = 'IMITAZIONE DI MARIA - 8296', description = '' WHERE id_product = '4949' 16/06/2022 07:06:35 pm >> UPDATE ps_product SET wholesale_price = '4.20', on_sale = '0', price = '9.0000' WHERE id_product = '4949' 16/06/2022 07:06:35 pm >> UPDATE ps_product_shop SET wholesale_price = '4.20', price = '9.0000', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '28', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '4949' 16/06/2022 07:06:35 pm >> DELETE FROM ps_specific_price WHERE id_product = '4949' 16/06/2022 07:10:59 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884041685' AND id_product != '7130' AND ean13 != '' 16/06/2022 07:10:59 pm >> UPDATE ps_product SET id_supplier = '', reference = 'ESPOSITORE SHALOM', ean13 = '9788884041685', date_upd = NOW() WHERE id_product = '7130' 16/06/2022 07:10:59 pm >> UPDATE ps_product_lang SET name = 'NOVISSIMI - 8400', description = '' WHERE id_product = '7130' 16/06/2022 07:10:59 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '5' WHERE id_product = '7130' 16/06/2022 07:10:59 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '5', id_tax_rules_group = '4', id_category_default = '106', 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 = '7130' 16/06/2022 07:10:59 pm >> DELETE FROM ps_specific_price WHERE id_product = '7130' 16/06/2022 07:29:21 pm >> SELECT document_num FROM ps_document WHERE document_num = '1957' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-16') 16/06/2022 07:29:21 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' , '1957' , '2022-06-16' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '40.00' , '36.33' , NOW() , NOW() ) 16/06/2022 07:29:21 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58805' 16/06/2022 07:29:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '58805' 16/06/2022 07:29:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58805' , '11384' , 'VINO BIANCO DOLCE - 102' , '2' , '-2' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '15.00' ) 16/06/2022 07:29:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11384' AND id_supplier = '' 16/06/2022 07:29:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11384' , '' , '1' ) 16/06/2022 07:29:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58805' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 16/06/2022 07:29:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = '' 16/06/2022 07:29:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '' , '1' ) 16/06/2022 07:29:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58805' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '3' , '-3' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '10.50' ) 16/06/2022 07:29:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 16/06/2022 07:29:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 16/06/2022 07:29:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58805' , '15924' , 'OSTIA 3MM - 03M-25' , '1' , '-1' , '3' , '5.5' , '5.2884615384615' , '4' , '0' , '5.50' ) 16/06/2022 07:29:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15924' AND id_supplier = '' 16/06/2022 07:29:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15924' , '' , '1' ) 16/06/2022 07:29:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58805' , '15922' , 'PARTICOLE 3MM - P3M' , '1' , '-1' , '3' , '5' , '4.8076923076923' , '4' , '0' , '5.00' ) 16/06/2022 07:29:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15922' AND id_supplier = '' 16/06/2022 07:29:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15922' , '' , '1' )