27/06/2023 09:15:32 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 27/06/2023 09:15:32 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21192' , '1' , '' , 'nuovo-prodotto' ) 27/06/2023 09:15:33 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '21192' , '1' , '1' , '2' , NOW() , NOW() ) 27/06/2023 09:15:33 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '21192' , '0' , '1' , '0' , '0' ) 27/06/2023 09:16:28 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884048660' AND id_product != '21192' AND ean13 != '' 27/06/2023 09:16:28 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788884048660', date_upd = NOW() WHERE id_product = '21192' 27/06/2023 09:16:28 am >> UPDATE ps_product_lang SET name = 'SULLA TUA PAROLA - SET OTT 23', description = '' WHERE id_product = '21192' 27/06/2023 09:16:28 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '5' WHERE id_product = '21192' 27/06/2023 09:16:28 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '5', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '64', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21192' 27/06/2023 09:16:28 am >> DELETE FROM ps_specific_price WHERE id_product = '21192' 27/06/2023 09:16:29 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 = '21192' 27/06/2023 09:16:29 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21193' , '1' , '' , 'nuovo-prodotto' ) 27/06/2023 09:16:29 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 '21193' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21192' 27/06/2023 09:16:29 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21193' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21192' 27/06/2023 09:16:43 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '10677/00/2023' , '2023-06-23' , '00' , '0' , '38' , '2633' , 'VIA GALVANI, 1 60020 CAMERATA PICENA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '294.00' , '294.00' , NOW() , NOW() ) 27/06/2023 09:16:43 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86528' 27/06/2023 09:16:43 am >> DELETE FROM ps_document_detail WHERE id_document = '86528' 27/06/2023 09:16:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86528' , '21037' , 'SULLA TUA PAROLA LUG/AGO 2023' , '68' , '68' , '4' , '5.00' , '5' , '0' , '40' , '204.0000' ) 27/06/2023 09:16:43 am >> DELETE FROM ps_product_supplier WHERE id_product = '21037' AND id_supplier = '38' 27/06/2023 09:16:43 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21037' , '38' , '1' ) 27/06/2023 09:16:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86528' , '21192' , 'SULLA TUA PAROLA - SET OTT 23' , '30' , '30' , '4' , '5.00' , '5' , '0' , '40' , '90.0000' ) 27/06/2023 09:16:43 am >> DELETE FROM ps_product_supplier WHERE id_product = '21192' AND id_supplier = '38' 27/06/2023 09:16:43 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21192' , '38' , '1' ) 27/06/2023 09:18:23 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892870697' AND id_product != '21193' AND ean13 != '' 27/06/2023 09:18:23 am >> UPDATE ps_product SET id_supplier = '', reference = 'GONDOLA 1', ean13 = '9788892870697', date_upd = NOW() WHERE id_product = '21193' 27/06/2023 09:18:23 am >> UPDATE ps_product_lang SET name = 'ECKOS SALVIAMO LA TERRA', description = '' WHERE id_product = '21193' 27/06/2023 09:18:23 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '12.9' WHERE id_product = '21193' 27/06/2023 09:18:23 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '12.9', id_tax_rules_group = '4', id_category_default = '26', id_argoment_default = '217', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21193' 27/06/2023 09:18:23 am >> DELETE FROM ps_specific_price WHERE id_product = '21193' 27/06/2023 09:18:24 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 = '21193' 27/06/2023 09:18:24 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21194' , '1' , '' , 'nuovo-prodotto' ) 27/06/2023 09:18:24 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 '21194' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21193' 27/06/2023 09:18:24 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21194' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21193' 27/06/2023 09:19:28 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788839934536' AND id_product != '21194' AND ean13 != '' 27/06/2023 09:19:28 am >> UPDATE ps_product SET id_supplier = '', reference = '13/6', ean13 = '9788839934536', date_upd = NOW() WHERE id_product = '21194' 27/06/2023 09:19:28 am >> UPDATE ps_product_lang SET name = 'EMOZIONI DI DIO - E. DURAND', description = '' WHERE id_product = '21194' 27/06/2023 09:19:28 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '27' WHERE id_product = '21194' 27/06/2023 09:19:28 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '27', id_tax_rules_group = '4', id_category_default = '111', id_argoment_default = '65', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21194' 27/06/2023 09:19:28 am >> DELETE FROM ps_specific_price WHERE id_product = '21194' 27/06/2023 09:19:29 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 = '21194' 27/06/2023 09:19:29 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21195' , '1' , '' , 'nuovo-prodotto' ) 27/06/2023 09:19:29 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 '21195' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21194' 27/06/2023 09:19:29 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21195' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21194' 27/06/2023 09:21:10 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892242081' AND id_product != '21195' AND ean13 != '' 27/06/2023 09:21:10 am >> UPDATE ps_product SET id_supplier = '', reference = '6/4', ean13 = '9788892242081', date_upd = NOW() WHERE id_product = '21195' 27/06/2023 09:21:10 am >> UPDATE ps_product_lang SET name = 'IO MA NON PIU\' IO - P. G. FRASSATI - P. ASOLAN', description = '' WHERE id_product = '21195' 27/06/2023 09:21:10 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '20' WHERE id_product = '21195' 27/06/2023 09:21:10 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '20', id_tax_rules_group = '4', id_category_default = '111', 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 = '21195' 27/06/2023 09:21:10 am >> DELETE FROM ps_specific_price WHERE id_product = '21195' 27/06/2023 09:21:11 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 = '21195' 27/06/2023 09:21:11 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21196' , '1' , '' , 'nuovo-prodotto' ) 27/06/2023 09:21:11 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 '21196' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21195' 27/06/2023 09:21:11 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21196' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21195' 27/06/2023 09:21:55 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892241961' AND id_product != '21196' AND ean13 != '' 27/06/2023 09:21:55 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788892241961', date_upd = NOW() WHERE id_product = '21196' 27/06/2023 09:21:55 am >> UPDATE ps_product_lang SET name = 'CALENDARIO LITURGICO 2024', description = '' WHERE id_product = '21196' 27/06/2023 09:21:55 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0.5' WHERE id_product = '21196' 27/06/2023 09:21:55 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0.5', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '107', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21196' 27/06/2023 09:21:55 am >> DELETE FROM ps_specific_price WHERE id_product = '21196' 27/06/2023 09:21: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 = '21196' 27/06/2023 09:21:56 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21197' , '1' , '' , 'nuovo-prodotto' ) 27/06/2023 09:21: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 '21197' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21196' 27/06/2023 09:21:56 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21197' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21196' 27/06/2023 09:22:42 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8051739456028' AND id_product != '21197' AND ean13 != '' 27/06/2023 09:22:42 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8051739456028', date_upd = NOW() WHERE id_product = '21197' 27/06/2023 09:22:42 am >> UPDATE ps_product_lang SET name = 'PAROLA E PREGHIERA - SET 23', description = '' WHERE id_product = '21197' 27/06/2023 09:22:42 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '2.9' WHERE id_product = '21197' 27/06/2023 09:22:42 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '2.9', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '64', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21197' 27/06/2023 09:22:42 am >> DELETE FROM ps_specific_price WHERE id_product = '21197' 27/06/2023 09:22:43 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 = '21197' 27/06/2023 09:22:43 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21198' , '1' , '' , 'nuovo-prodotto' ) 27/06/2023 09:22:43 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 '21198' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21197' 27/06/2023 09:22:43 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21198' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21197' 27/06/2023 09:23:18 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892240490' AND id_product != '21198' AND ean13 != '' 27/06/2023 09:23:18 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788892240490', date_upd = NOW() WHERE id_product = '21198' 27/06/2023 09:23:18 am >> UPDATE ps_product_lang SET name = 'AMEN - SET 2023', description = '' WHERE id_product = '21198' 27/06/2023 09:23:18 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3.9' WHERE id_product = '21198' 27/06/2023 09:23:18 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3.9', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '64', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21198' 27/06/2023 09:23:18 am >> DELETE FROM ps_specific_price WHERE id_product = '21198' 27/06/2023 09: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 = '21198' 27/06/2023 09:23:19 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21199' , '1' , '' , 'nuovo-prodotto' ) 27/06/2023 09: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 '21199' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21198' 27/06/2023 09:23:19 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21199' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21198' 27/06/2023 09:23:37 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892240506' AND id_product != '21199' AND ean13 != '' 27/06/2023 09:23:37 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788892240506', date_upd = NOW() WHERE id_product = '21199' 27/06/2023 09:23:37 am >> UPDATE ps_product_lang SET name = 'AMEN - OTT 2023', description = '' WHERE id_product = '21199' 27/06/2023 09:23:37 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3.9' WHERE id_product = '21199' 27/06/2023 09:23:37 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3.9', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '64', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21199' 27/06/2023 09:23:37 am >> DELETE FROM ps_specific_price WHERE id_product = '21199' 27/06/2023 09:23:38 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 = '21199' 27/06/2023 09:23:38 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21200' , '1' , '' , 'nuovo-prodotto' ) 27/06/2023 09:23:38 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 '21200' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21199' 27/06/2023 09:23:38 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21200' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21199' 27/06/2023 09:24:49 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8051739456141' AND id_product != '21200' AND ean13 != '' 27/06/2023 09:24:49 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8051739456141', date_upd = NOW() WHERE id_product = '21200' 27/06/2023 09:24:49 am >> UPDATE ps_product_lang SET name = 'INSIEME NELLA MESSA - STT 23', description = '' WHERE id_product = '21200' 27/06/2023 09:24:49 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '1.8' WHERE id_product = '21200' 27/06/2023 09:24:49 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '1.8', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '64', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21200' 27/06/2023 09:24:49 am >> DELETE FROM ps_specific_price WHERE id_product = '21200' 27/06/2023 09:24:50 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 = '21200' 27/06/2023 09:24:50 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21201' , '1' , '' , 'nuovo-prodotto' ) 27/06/2023 09:24:50 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 '21201' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21200' 27/06/2023 09:24:50 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21201' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21200' 27/06/2023 09:25:51 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831556651' AND id_product != '21201' AND ean13 != '' 27/06/2023 09:25:51 am >> UPDATE ps_product SET id_supplier = '', reference = 'ESPOSITORE SAN PAOLO', ean13 = '9788831556651', date_upd = NOW() WHERE id_product = '21201' 27/06/2023 09:25:52 am >> UPDATE ps_product_lang SET name = 'PREGHIERA DEI 14 GRAZIE - PAPA FRANCESCO', description = '' WHERE id_product = '21201' 27/06/2023 09:25:52 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '1.5' WHERE id_product = '21201' 27/06/2023 09:25:52 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '1.5', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '64', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21201' 27/06/2023 09:25:52 am >> DELETE FROM ps_specific_price WHERE id_product = '21201' 27/06/2023 09:25: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 = '21201' 27/06/2023 09:25:54 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21202' , '1' , '' , 'nuovo-prodotto' ) 27/06/2023 09:25: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 '21202' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21201' 27/06/2023 09:25:54 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21202' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21201' 27/06/2023 09:27:13 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791281253728' AND id_product != '21202' AND ean13 != '' 27/06/2023 09:27:13 am >> UPDATE ps_product SET id_supplier = '', reference = 'ESPOSITORE SAN PAOLO', ean13 = '9791281253728', date_upd = NOW() WHERE id_product = '21202' 27/06/2023 09:27:13 am >> UPDATE ps_product_lang SET name = 'PREGHIAMO CON IL NONNO E LA NONNA', description = '' WHERE id_product = '21202' 27/06/2023 09:27:13 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '1.5' WHERE id_product = '21202' 27/06/2023 09:27:13 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '1.5', id_tax_rules_group = '4', id_category_default = '518', 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 = '21202' 27/06/2023 09:27:13 am >> DELETE FROM ps_specific_price WHERE id_product = '21202' 27/06/2023 09:27:14 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 = '21202' 27/06/2023 09:27:14 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21203' , '1' , '' , 'nuovo-prodotto' ) 27/06/2023 09:27:14 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 '21203' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21202' 27/06/2023 09:27:14 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21203' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21202' 27/06/2023 09:27:34 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831556651' AND id_product != '21201' AND ean13 != '' 27/06/2023 09:27:34 am >> UPDATE ps_product SET id_supplier = '', reference = 'ESPOSITORE SAN PAOLO', ean13 = '9788831556651', date_upd = NOW() WHERE id_product = '21201' 27/06/2023 09:27:34 am >> UPDATE ps_product_lang SET name = 'PREGHIERA DEI 14 GRAZIE - PAPA FRANCESCO', description = '' WHERE id_product = '21201' 27/06/2023 09:27:34 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '1.5000' WHERE id_product = '21201' 27/06/2023 09:27:34 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '1.5000', id_tax_rules_group = '4', id_category_default = '30', 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 = '21201' 27/06/2023 09:27:34 am >> DELETE FROM ps_specific_price WHERE id_product = '21201' 27/06/2023 09:29:03 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791281009356' AND id_product != '21203' AND ean13 != '' 27/06/2023 09:29:03 am >> UPDATE ps_product SET id_supplier = '', reference = '5/6', ean13 = '9791281009356', date_upd = NOW() WHERE id_product = '21203' 27/06/2023 09:29:03 am >> UPDATE ps_product_lang SET name = 'MIO GRANDE LIBRO DA COLORARE - SUPER', description = '' WHERE id_product = '21203' 27/06/2023 09:29:03 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = 'NaN' WHERE id_product = '21203' 27/06/2023 09:29:04 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = 'NaN', id_tax_rules_group = '4', id_category_default = '61', id_argoment_default = '25', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21203' 27/06/2023 09:29:04 am >> DELETE FROM ps_specific_price WHERE id_product = '21203' 27/06/2023 09:29: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 = '21203' 27/06/2023 09:29:05 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21204' , '1' , '' , 'nuovo-prodotto' ) 27/06/2023 09:29: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 '21204' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21203' 27/06/2023 09:29:05 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21204' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21203' 27/06/2023 09:29:38 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791281009363' AND id_product != '21204' AND ean13 != '' 27/06/2023 09:29:38 am >> UPDATE ps_product SET id_supplier = '', reference = '5/6', ean13 = '9791281009363', date_upd = NOW() WHERE id_product = '21204' 27/06/2023 09:29:39 am >> UPDATE ps_product_lang SET name = 'MIO GRANDE LIBRO DA COLORARE - FAVOLOSO', description = '' WHERE id_product = '21204' 27/06/2023 09:29:39 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '7.9' WHERE id_product = '21204' 27/06/2023 09:29:39 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '7.9', id_tax_rules_group = '4', id_category_default = '61', id_argoment_default = '25', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21204' 27/06/2023 09:29:39 am >> DELETE FROM ps_specific_price WHERE id_product = '21204' 27/06/2023 09:29:39 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 = '21204' 27/06/2023 09:29:39 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21205' , '1' , '' , 'nuovo-prodotto' ) 27/06/2023 09:29:39 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 '21205' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21204' 27/06/2023 09:29:39 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21205' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21204' 27/06/2023 09:29:57 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791281009356' AND id_product != '21203' AND ean13 != '' 27/06/2023 09:29:57 am >> UPDATE ps_product SET id_supplier = '', reference = '5/6', ean13 = '9791281009356', date_upd = NOW() WHERE id_product = '21203' 27/06/2023 09:29:57 am >> UPDATE ps_product_lang SET name = 'MIO GRANDE LIBRO DA COLORARE - SUPER', description = '' WHERE id_product = '21203' 27/06/2023 09:29:57 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '7.9' WHERE id_product = '21203' 27/06/2023 09:29:57 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '7.9', id_tax_rules_group = '4', id_category_default = '61', id_argoment_default = '25', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21203' 27/06/2023 09:29:57 am >> DELETE FROM ps_specific_price WHERE id_product = '21203' 27/06/2023 09:30:32 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' , '634808' , '2023-06-21' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '7.74' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '271.21' , '271.21' , NOW() , NOW() ) 27/06/2023 09:30:32 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 = '86529' 27/06/2023 09:30:32 am >> DELETE FROM ps_document_detail WHERE id_document = '86529' 27/06/2023 09:30:32 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 ( '86529' , '21193' , 'ECKOS SALVIAMO LA TERRA' , '2' , '2' , '4' , '12.90' , '12.9' , '0' , '30' , '18.0600' ) 27/06/2023 09:30:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '21193' AND id_supplier = '7' 27/06/2023 09:30:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21193' , '7' , '1' ) 27/06/2023 09:30:32 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 ( '86529' , '21194' , 'EMOZIONI DI DIO - E. DURAND' , '1' , '1' , '4' , '27.00' , '27' , '0' , '30' , '18.9000' ) 27/06/2023 09:30:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '21194' AND id_supplier = '7' 27/06/2023 09:30:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21194' , '7' , '1' ) 27/06/2023 09:30:32 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 ( '86529' , '21195' , 'IO MA NON PIU IO - P. G. FRASSATI - P. ASOLAN' , '1' , '1' , '4' , '20.00' , '20' , '0' , '33' , '13.4000' ) 27/06/2023 09:30:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '21195' AND id_supplier = '7' 27/06/2023 09:30:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21195' , '7' , '1' ) 27/06/2023 09:30:32 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 ( '86529' , '21196' , 'CALENDARIO LITURGICO 2024' , '24' , '24' , '4' , '0.50' , '0.5' , '0' , '33' , '8.0400' ) 27/06/2023 09:30:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '21196' AND id_supplier = '7' 27/06/2023 09:30:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21196' , '7' , '1' ) 27/06/2023 09:30:32 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 ( '86529' , '21196' , 'CALENDARIO LITURGICO 2024' , '2' , '2' , '4' , '0.50' , '0.5' , '0' , '100' , '0.0000' ) 27/06/2023 09:30:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '21196' AND id_supplier = '7' 27/06/2023 09:30:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21196' , '7' , '1' ) 27/06/2023 09:30:32 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 ( '86529' , '21197' , 'PAROLA E PREGHIERA - SET 23' , '3' , '3' , '4' , '2.90' , '2.9' , '0' , '33' , '5.8290' ) 27/06/2023 09:30:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '21197' AND id_supplier = '7' 27/06/2023 09:30:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21197' , '7' , '1' ) 27/06/2023 09:30:32 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 ( '86529' , '21198' , 'AMEN - SET 2023' , '24' , '24' , '4' , '3.90' , '3.9' , '0' , '33' , '62.7120' ) 27/06/2023 09:30:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '21198' AND id_supplier = '7' 27/06/2023 09:30:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21198' , '7' , '1' ) 27/06/2023 09:30:32 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 ( '86529' , '21198' , 'AMEN - SET 2023' , '2' , '2' , '4' , '3.90' , '3.9' , '0' , '100' , '0.0000' ) 27/06/2023 09:30:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '21198' AND id_supplier = '7' 27/06/2023 09:30:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21198' , '7' , '1' ) 27/06/2023 09:30:32 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 ( '86529' , '21199' , 'AMEN - OTT 2023' , '24' , '24' , '4' , '3.90' , '3.9' , '0' , '33' , '62.7120' ) 27/06/2023 09:30:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '21199' AND id_supplier = '7' 27/06/2023 09:30:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21199' , '7' , '1' ) 27/06/2023 09:30:32 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 ( '86529' , '21199' , 'AMEN - OTT 2023' , '2' , '2' , '4' , '3.90' , '3.9' , '0' , '100' , '0.0000' ) 27/06/2023 09:30:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '21199' AND id_supplier = '7' 27/06/2023 09:30:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21199' , '7' , '1' ) 27/06/2023 09:30:32 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 ( '86529' , '21200' , 'INSIEME NELLA MESSA - STT 23' , '1' , '1' , '4' , '1.80' , '1.8' , '0' , '33' , '1.2060' ) 27/06/2023 09:30:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '21200' AND id_supplier = '7' 27/06/2023 09:30:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21200' , '7' , '1' ) 27/06/2023 09:30:32 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 ( '86529' , '21201' , 'PREGHIERA DEI 14 GRAZIE - PAPA FRANCESCO' , '12' , '12' , '4' , '1.50' , '1.5' , '0' , '33' , '12.0600' ) 27/06/2023 09:30:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '21201' AND id_supplier = '7' 27/06/2023 09:30:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21201' , '7' , '1' ) 27/06/2023 09:30:32 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 ( '86529' , '21201' , 'PREGHIERA DEI 14 GRAZIE - PAPA FRANCESCO' , '1' , '1' , '4' , '1.50' , '1.5' , '0' , '100' , '0.0000' ) 27/06/2023 09:30:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '21201' AND id_supplier = '7' 27/06/2023 09:30:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21201' , '7' , '1' ) 27/06/2023 09:30:32 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 ( '86529' , '21202' , 'PREGHIAMO CON IL NONNO E LA NONNA' , '5' , '5' , '4' , '1.50' , '1.5' , '0' , '30' , '5.2500' ) 27/06/2023 09:30:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '21202' AND id_supplier = '7' 27/06/2023 09:30:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21202' , '7' , '1' ) 27/06/2023 09:30:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86529' , '21203' , 'MIO GRANDE LIBRO DA COLORARE - SUPER' , '5' , '5' , '4' , '7.90' , '7.9' , '0' , '30' , '27.6500' ) 27/06/2023 09:30:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '21203' AND id_supplier = '7' 27/06/2023 09:30:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21203' , '7' , '1' ) 27/06/2023 09:30:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86529' , '21204' , 'MIO GRANDE LIBRO DA COLORARE - FAVOLOSO' , '5' , '5' , '4' , '7.90' , '7.9' , '0' , '30' , '27.6500' ) 27/06/2023 09:30:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '21204' AND id_supplier = '7' 27/06/2023 09:30:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21204' , '7' , '1' ) 27/06/2023 09:31:24 am >> SELECT document_num FROM ps_document WHERE document_num = '22/A' AND id_document != '81317' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-02-10') 27/06/2023 09:31:24 am >> UPDATE ps_document SET id_document_type = '24', document_num = '22/A', document_date = '2023-02-10', document_letter = 'A', id_customer = '206', id_supplier = '', id_address = '4671015', address1 = 'VIA N. BUONSERVIZI, 25 84135 SALERNO', 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 = '20.60', price_tax_excluded = '20.60', date_upd = NOW() WHERE id_document = '81317' 27/06/2023 09:31:24 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 = '81317' 27/06/2023 09:31:24 am >> DELETE FROM ps_document_detail WHERE id_document = '81317' 27/06/2023 09:31:24 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 ( '81317' , '21067' , 'AMEN - AGO 23' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 27/06/2023 09:31:24 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 ( '81317' , '21196' , 'CALENDARIO LITURGICO 2024' , '2' , '-2' , '4' , '0.50' , '0.5' , '0' , '0' , '1.00' ) 27/06/2023 09:31:24 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 ( '81317' , '21197' , 'PAROLA E PREGHIERA - SET 23' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '0' , '2.90' ) 27/06/2023 09:31:24 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 ( '81317' , '21199' , 'AMEN - OTT 2023' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '0' , '3.90' ) 27/06/2023 09:31:24 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 ( '81317' , '21198' , 'AMEN - SET 2023' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '0' , '3.90' ) 27/06/2023 09:31:24 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 ( '81317' , '21192' , 'SULLA TUA PAROLA - SET OTT 23' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '0' , '5.00' ) 27/06/2023 09:40:01 am >> SELECT document_num FROM ps_document WHERE document_num = '2210' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-27') 27/06/2023 09:40:01 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' , '2210' , '2023-06-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.00' , '5.74' , NOW() , NOW() ) 27/06/2023 09:40:01 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 = '86530' 27/06/2023 09:40:01 am >> DELETE FROM ps_document_detail WHERE id_document = '86530' 27/06/2023 09:40:01 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 ( '86530' , '1331' , 'BRACCIALE LEGNO BICOLORE - 034CYB499' , '3' , '-3' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '3.00' ) 27/06/2023 09:40:01 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 ( '86530' , '18214' , 'BRACCIALE DECINA LEGNO CORDA - BC566' , '1' , '-1' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '2.00' ) 27/06/2023 09:40:01 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 ( '86530' , '18899' , 'BRACCIALE DECINA LEGNO - BC169' , '1' , '-1' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '2.00' ) 27/06/2023 10:15:27 am >> SELECT document_num FROM ps_document WHERE document_num = '2211' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-27') 27/06/2023 10:15:27 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' , '2211' , '2023-06-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.50' , '2.05' , NOW() , NOW() ) 27/06/2023 10:15:27 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 = '86531' 27/06/2023 10:15:27 am >> DELETE FROM ps_document_detail WHERE id_document = '86531' 27/06/2023 10:15:27 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 ( '86531' , '20026' , 'CANDELA VOTIVA 20X30' , '1' , '-1' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '2.50' ) 27/06/2023 10:21:43 am >> SELECT document_num FROM ps_document WHERE document_num = '2212' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-27') 27/06/2023 10:21:43 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2212' , '2023-06-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '31.25' , '29.90' , NOW() , NOW() ) 27/06/2023 10:21:43 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86532' 27/06/2023 10:21:43 am >> DELETE FROM ps_document_detail WHERE id_document = '86532' 27/06/2023 10:21:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86532' , '1114' , 'BIBBIA DEGLI SPOSI' , '1' , '-1' , '4' , '25.00' , '25' , '0' , '5' , '23.75' ) 27/06/2023 10:21:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86532' , '15097' , 'CORONA MATRIMONIO - ORO' , '1' , '-1' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '7.50' ) 27/06/2023 10:36:05 am >> SELECT document_num FROM ps_document WHERE document_num = '2178' AND id_document != '86489' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-23') 27/06/2023 10:36:05 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2178', document_date = '2023-06-23', 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 = '50.00', price_tax_excluded = '40.98', date_upd = NOW() WHERE id_document = '86489' 27/06/2023 10:36:05 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86489' 27/06/2023 10:36:05 am >> DELETE FROM ps_document_detail WHERE id_document = '86489' 27/06/2023 10:36:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86489' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '5' , '4.0983606557377' , '22' , '0' , '5.00' ) 27/06/2023 10:36:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86489' , '20173' , 'ANGELO IN PREGHIERA - R17' , '10' , '-10' , '1' , '4.50' , '3.6885245901639' , '22' , '0' , '45.00' ) 27/06/2023 10:41:49 am >> SELECT document_num FROM ps_document WHERE document_num = '2213' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-27') 27/06/2023 10:41:49 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2213' , '2023-06-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '22.50' , '18.44' , NOW() , NOW() ) 27/06/2023 10:41:49 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86533' 27/06/2023 10:41:49 am >> DELETE FROM ps_document_detail WHERE id_document = '86533' 27/06/2023 10:41:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86533' , '20173' , 'ANGELO IN PREGHIERA - R17' , '5' , '-5' , '1' , '4.50' , '3.6885245901639' , '22' , '0' , '22.50' ) 27/06/2023 11:39:04 am >> SELECT document_num FROM ps_document WHERE document_num = '2214' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-27') 27/06/2023 11:39: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' , '2214' , '2023-06-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '206.97' , '206.97' , NOW() , NOW() ) 27/06/2023 11:39: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 = '86534' 27/06/2023 11:39:04 am >> DELETE FROM ps_document_detail WHERE id_document = '86534' 27/06/2023 11:39: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 ( '86534' , '21037' , 'SULLA TUA PAROLA LUG/AGO 2023' , '31' , '-31' , '4' , '5.00' , '5' , '0' , '5' , '147.25' ) 27/06/2023 11:39: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 ( '86534' , '21048' , 'MESSA MEDITAZIONE - LUG/AGO 2023' , '2' , '-2' , '4' , '8.00' , '8' , '0' , '5' , '15.20' ) 27/06/2023 11:39: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 ( '86534' , '20999' , 'AMEN - LUG 23' , '6' , '-6' , '4' , '3.90' , '3.9' , '0' , '5' , '22.26' ) 27/06/2023 11:39: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 ( '86534' , '21067' , 'AMEN - AGO 23' , '6' , '-6' , '4' , '3.90' , '3.9' , '0' , '5' , '22.26' ) 27/06/2023 11:59:50 am >> SELECT document_num FROM ps_document WHERE document_num = '1269' AND id_document != '82831' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-17') 27/06/2023 11:59:50 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1269', document_date = '2023-04-17', 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 = '15.00', price_tax_excluded = '12.30', date_upd = NOW() WHERE id_document = '82831' 27/06/2023 11:59: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 = '82831' 27/06/2023 11:59:51 am >> DELETE FROM ps_document_detail WHERE id_document = '82831' 27/06/2023 11:59: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 ( '82831' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '7' , '5.7377049180328' , '22' , '0' , '7.00' ) 27/06/2023 11:59: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 ( '82831' , '739' , 'ARC. GABRIELE BABY - 023 AR/G/9 BB' , '1' , '-1' , '1' , '8.00' , '6.5573770491803' , '22' , '0' , '8.00' ) 27/06/2023 12:25:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '2215' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-27') 27/06/2023 12:25: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 ( '11' , '2215' , '2023-06-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '29.00' , '28.82' , NOW() , NOW() ) 27/06/2023 12:25: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 = '86535' 27/06/2023 12:25:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '86535' 27/06/2023 12:25: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 ( '86535' , '12995' , 'SALE, NON MIELE - L. EPICOCO' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '0' , '16.00' ) 27/06/2023 12:25: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 ( '86535' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '12' , '12' , '0' , '0' , '12.00' ) 27/06/2023 12:25: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 ( '86535' , '19298' , 'BIGLIETTO AUGURALE GRANDE' , '1' , '-1' , '1' , '1' , '0.81967213114754' , '22' , '0' , '1.00' ) 27/06/2023 12:43:25 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8053853003492' AND id_product != '21205' AND ean13 != '' 27/06/2023 12:43:25 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8053853003492', date_upd = NOW() WHERE id_product = '21205' 27/06/2023 12:43:25 pm >> UPDATE ps_product_lang SET name = 'MI AMI TU? - CD', description = '' WHERE id_product = '21205' 27/06/2023 12:43:25 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '16.8' WHERE id_product = '21205' 27/06/2023 12:43:25 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '16.8', id_tax_rules_group = '4', id_category_default = '76', id_argoment_default = '66', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21205' 27/06/2023 12:43:25 pm >> DELETE FROM ps_specific_price WHERE id_product = '21205' 27/06/2023 12:43:26 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '21205' 27/06/2023 12:43:26 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21206' , '1' , '' , 'nuovo-prodotto' ) 27/06/2023 12:43:26 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '21206' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21205' 27/06/2023 12:43:26 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21206' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21205' 27/06/2023 12:44:56 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '635132' , '2023-06-26' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '3.59' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '144.59' , '144.11' , NOW() , NOW() ) 27/06/2023 12:44:56 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 = '86536' 27/06/2023 12:44:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '86536' 27/06/2023 12:44:56 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 ( '86536' , '21205' , 'MI AMI TU? - CD' , '6' , '6' , '4' , '16.80' , '16.8' , '0' , '30' , '70.5600' ) 27/06/2023 12:44:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21205' AND id_supplier = '7' 27/06/2023 12:44:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21205' , '7' , '1' ) 27/06/2023 12:44:56 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 ( '86536' , '21142' , 'AGGIUNTA SPARTITI 2023' , '2' , '2' , '3' , '8.50' , '8.1730769230769' , '4' , '30' , '12.3760' ) 27/06/2023 12:44:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21142' AND id_supplier = '7' 27/06/2023 12:44:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21142' , '7' , '1' ) 27/06/2023 12:44:56 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 ( '86536' , '21166' , 'ENCICLICHE SOCIALI ' , '1' , '1' , '4' , '26.00' , '26' , '0' , '33' , '17.4200' ) 27/06/2023 12:44:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21166' AND id_supplier = '7' 27/06/2023 12:44:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21166' , '7' , '1' ) 27/06/2023 12:44:56 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 ( '86536' , '20999' , 'AMEN - LUG 23' , '4' , '4' , '4' , '3.90' , '3.9' , '0' , '33' , '10.4520' ) 27/06/2023 12:44:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20999' AND id_supplier = '7' 27/06/2023 12:44:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20999' , '7' , '1' ) 27/06/2023 12:44:56 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 ( '86536' , '21067' , 'AMEN - AGO 23' , '7' , '7' , '4' , '3.90' , '3.9' , '0' , '33' , '18.2910' ) 27/06/2023 12:44:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21067' AND id_supplier = '7' 27/06/2023 12:44:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21067' , '7' , '1' ) 27/06/2023 12:44:56 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 ( '86536' , '21029' , 'MIA VITA PER GLI ULTIMI - CONTE/PILATI' , '1' , '1' , '4' , '17.00' , '17' , '0' , '30' , '11.9000' ) 27/06/2023 12:44:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21029' AND id_supplier = '7' 27/06/2023 12:44:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21029' , '7' , '1' ) 27/06/2023 03:33:51 pm >> SELECT document_num FROM ps_document WHERE document_num = '2216' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-27') 27/06/2023 03: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' , '2216' , '2023-06-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.40' , '1.97' , NOW() , NOW() ) 27/06/2023 03: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 = '86537' 27/06/2023 03:33:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '86537' 27/06/2023 03: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 ( '86537' , '19298' , 'BIGLIETTO AUGURALE GRANDE' , '2' , '-2' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '2.40' ) 27/06/2023 03:50:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '2217' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-27') 27/06/2023 03:50:46 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' , '2217' , '2023-06-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '31.92' , '31.92' , NOW() , NOW() ) 27/06/2023 03:50:46 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 = '86538' 27/06/2023 03:50:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '86538' 27/06/2023 03:50:46 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 ( '86538' , '21205' , 'MI AMI TU? - CD' , '2' , '-2' , '4' , '16.80' , '16.8' , '0' , '5' , '31.92' ) 27/06/2023 04:08:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '2218' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-27') 27/06/2023 04:08:19 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' , '2218' , '2023-06-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '20.00' , '16.39' , NOW() , NOW() ) 27/06/2023 04:08:19 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 = '86539' 27/06/2023 04:08:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '86539' 27/06/2023 04:08: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 ( '86539' , '11662' , 'ICONA 18X24 - S. FAMIGLIA' , '1' , '-1' , '1' , '20.00' , '16.393442622951' , '22' , '0' , '20.00' ) 27/06/2023 04:13:47 pm >> SELECT document_num FROM ps_document WHERE document_num = '2219' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-27') 27/06/2023 04:13:47 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' , '2219' , '2023-06-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.00' , '8.20' , NOW() , NOW() ) 27/06/2023 04:13:47 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 = '86540' 27/06/2023 04:13:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '86540' 27/06/2023 04:13:47 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 ( '86540' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 27/06/2023 05:05:56 pm >> SELECT document_num FROM ps_document WHERE document_num = '2220' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-27') 27/06/2023 05:05:56 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' , '2220' , '2023-06-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '27.00' , '22.13' , NOW() , NOW() ) 27/06/2023 05:05:56 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 = '86541' 27/06/2023 05:05:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '86541' 27/06/2023 05:05:56 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 ( '86541' , '8147' , 'POLO BASIC' , '1' , '-1' , '1' , '27.00' , '22.131147540984' , '22' , '0' , '27.00' ) 27/06/2023 05:20:24 pm >> SELECT document_num FROM ps_document WHERE document_num = '2221' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-27') 27/06/2023 05:20:24 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' , '2221' , '2023-06-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '105.00' , '94.84' , NOW() , NOW() ) 27/06/2023 05:20:24 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 = '86542' 27/06/2023 05:20:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '86542' 27/06/2023 05:20:24 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 ( '86542' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '10' , '-10' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '35.00' ) 27/06/2023 05:20:24 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 ( '86542' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8' , '6.5573770491803' , '22' , '0' , '48.00' ) 27/06/2023 05:20:24 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 ( '86542' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.04' , '3.8846153846154' , '4' , '0' , '4.04' ) 27/06/2023 05:20:24 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 ( '86542' , '17257' , 'IO TI BATTEZZO ' , '1' , '-1' , '4' , '1.80' , '1.8' , '0' , '0' , '1.80' ) 27/06/2023 05:20:24 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 ( '86542' , '5148' , 'IN CAMMINO CON NOSTRO FIGLIO NELLA COMUNITÀ CRISTIANA' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 27/06/2023 05:20:24 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 ( '86542' , '19934' , 'PREGHIERE PIù BELLE' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 27/06/2023 05:20:24 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 ( '86542' , '12147' , 'ANGELO CUSTODE RACCONTATO AI BAMBINI - B. FERRERO' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 27/06/2023 05:20:24 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 ( '86542' , '5250' , 'INCONTRI DI GIOIA - QUADERNO' , '1' , '-1' , '4' , '5.50' , '5.5' , '0' , '5' , '5.23' ) 27/06/2023 05:22:02 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892870154' AND id_product != '19934' AND ean13 != '' 27/06/2023 05:22:02 pm >> UPDATE ps_product SET id_supplier = '7', reference = '5/3', ean13 = '9788892870154', date_upd = NOW() WHERE id_product = '19934' 27/06/2023 05:22:02 pm >> UPDATE ps_product_lang SET name = 'PREGHIERE PIù BELLE', description = '' WHERE id_product = '19934' 27/06/2023 05:22:02 pm >> UPDATE ps_product SET wholesale_price = '2.45', on_sale = '0', price = '3.5000' WHERE id_product = '19934' 27/06/2023 05:22:02 pm >> UPDATE ps_product_shop SET wholesale_price = '2.45', price = '3.5000', id_tax_rules_group = '4', id_category_default = '26', id_argoment_default = '25', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19934' 27/06/2023 05:22:02 pm >> DELETE FROM ps_specific_price WHERE id_product = '19934' 27/06/2023 05:31:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '2042' AND id_document != '85817' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-12') 27/06/2023 05:31:22 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2042', 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 = '85.00', price_tax_excluded = '75.12', date_upd = NOW() WHERE id_document = '85817' 27/06/2023 05:31:22 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' 27/06/2023 05:31:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '85817' 27/06/2023 05:31:22 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.8000' , '3.1147540983607' , '22' , '0' , '3.80' ) 27/06/2023 05:31:22 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.0000' , '18' , '0' , '5' , '17.10' ) 27/06/2023 05:31:22 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.0000' , '2' , '0' , '0' , '2.00' ) 27/06/2023 05:31:22 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.0000' , '12.295081967213' , '22' , '0' , '15.00' ) 27/06/2023 05:31:22 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' , '20935' , 'TU X TUTTI' , '1' , '-1' , '4' , '11.1' , '11.1' , '0' , '0' , '11.10' ) 27/06/2023 05:31:22 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.5000' , '1.2295081967213' , '22' , '0' , '18.00' ) 27/06/2023 05:31:22 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.5000' , '1.2295081967213' , '22' , '0' , '18.00' ) 27/06/2023 05:39:51 pm >> SELECT document_num FROM ps_document WHERE document_num = '2222' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-27') 27/06/2023 05:39: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' , '2222' , '2023-06-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.00' , '10.58' , NOW() , NOW() ) 27/06/2023 05:39: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 = '86543' 27/06/2023 05:39:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '86543' 27/06/2023 05:39: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 ( '86543' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 27/06/2023 05:39: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 ( '86543' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 27/06/2023 05:41:39 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '1420/23' , '2023-06-19' , '23' , '0' , '125' , '4669745' , 'VIA SIBELLUCCIA, AREA P.I.P. 84088 MERCATO SAN SEVERINO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '5881.20' , '5655.00' , NOW() , NOW() ) 27/06/2023 05:41:39 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86544' 27/06/2023 05:41:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '86544' 27/06/2023 05:41:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86544' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '2000' , '2000' , '3' , '0.87' , '0.83653846153846' , '4' , '0' , '1809.6000' ) 27/06/2023 05:41:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4394' AND id_supplier = '125' 27/06/2023 05:41:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4394' , '125' , '1' ) 27/06/2023 05:41: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 ( '86544' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '2500' , '2500' , '3' , '0.87' , '0.83653846153846' , '4' , '0' , '2262.0000' ) 27/06/2023 05:41:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4397' AND id_supplier = '125' 27/06/2023 05:41:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4397' , '125' , '1' ) 27/06/2023 05:41: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 ( '86544' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '2000' , '2000' , '3' , '0.87' , '0.83653846153846' , '4' , '0' , '1809.6000' ) 27/06/2023 05:41:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4495' AND id_supplier = '125' 27/06/2023 05:41:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4495' , '125' , '1' ) 27/06/2023 07:12:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '2223' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-27') 27/06/2023 07:12:04 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' , '2223' , '2023-06-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.00' , '5.74' , NOW() , NOW() ) 27/06/2023 07:12:04 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 = '86545' 27/06/2023 07:12:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '86545' 27/06/2023 07:12:04 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 ( '86545' , '20537' , 'VESTINA BATTESIMALE - 101TCB' , '1' , '-1' , '1' , '4.50' , '3.6885245901639' , '22' , '0' , '4.50' ) 27/06/2023 07:12:04 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 ( '86545' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '2.50' ) 27/06/2023 07:27:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '2224' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-27') 27/06/2023 07:27: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' , '2224' , '2023-06-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.50' , '9.50' , NOW() , NOW() ) 27/06/2023 07:27: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 = '86546' 27/06/2023 07:27:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '86546' 27/06/2023 07:27: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 ( '86546' , '21037' , 'SULLA TUA PAROLA LUG/AGO 2023' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 27/06/2023 07:27: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 ( '86546' , '21192' , 'SULLA TUA PAROLA - SET OTT 23' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 27/06/2023 07:43:12 pm >> SELECT document_num FROM ps_document WHERE document_num = '2225' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-27') 27/06/2023 07:43: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' , '2225' , '2023-06-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '28.50' , '28.50' , NOW() , NOW() ) 27/06/2023 07:43: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 = '86547' 27/06/2023 07:43:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '86547' 27/06/2023 07:43: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 ( '86547' , '21037' , 'SULLA TUA PAROLA LUG/AGO 2023' , '6' , '-6' , '4' , '5.00' , '5' , '0' , '5' , '28.50' )