17/05/2024 08:55:18 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 17/05/2024 08:55:18 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22534' , '1' , '' , 'nuovo-prodotto' ) 17/05/2024 08:55:18 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '22534' , '1' , '1' , '2' , NOW() , NOW() ) 17/05/2024 08:55:18 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '22534' , '0' , '1' , '0' , '0' ) 17/05/2024 08:56:01 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788810978764' AND id_product != '22534' AND ean13 != '' 17/05/2024 08:56:01 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788810978764', date_upd = NOW() WHERE id_product = '22534' 17/05/2024 08:56:01 am >> UPDATE ps_product_lang SET name = 'GIOISCI MARIA - A. AMAPANI', description = '' WHERE id_product = '22534' 17/05/2024 08:56:01 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3.9' WHERE id_product = '22534' 17/05/2024 08:56:01 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3.9', id_tax_rules_group = '4', id_category_default = '9', id_argoment_default = '', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22534' 17/05/2024 08:56:01 am >> DELETE FROM ps_specific_price WHERE id_product = '22534' 17/05/2024 08:56:15 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 = '22534' 17/05/2024 08:56:15 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22535' , '1' , '' , 'nuovo-prodotto' ) 17/05/2024 08:56:15 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 '22535' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22534' 17/05/2024 08:56:15 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22535' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22534' 17/05/2024 08:56:42 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788817188623' AND id_product != '22535' AND ean13 != '' 17/05/2024 08:56:42 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788817188623', date_upd = NOW() WHERE id_product = '22535' 17/05/2024 08:56:43 am >> UPDATE ps_product_lang SET name = 'CARA GIULIA ', description = '' WHERE id_product = '22535' 17/05/2024 08:56:43 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '15' WHERE id_product = '22535' 17/05/2024 08:56:43 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '15', id_tax_rules_group = '4', id_category_default = '113', id_argoment_default = '', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22535' 17/05/2024 08:56:43 am >> DELETE FROM ps_specific_price WHERE id_product = '22535' 17/05/2024 08:57:42 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 = '22535' 17/05/2024 08:57:42 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22536' , '1' , '' , 'nuovo-prodotto' ) 17/05/2024 08:57:42 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 '22536' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22535' 17/05/2024 08:57:42 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22536' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22535' 17/05/2024 08:58:17 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788849878530' AND id_product != '22536' AND ean13 != '' 17/05/2024 08:58:17 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788849878530', date_upd = NOW() WHERE id_product = '22536' 17/05/2024 08:58:17 am >> UPDATE ps_product_lang SET name = 'MESSA E\' SBIADITA - L. DIOTALLEVI', description = '' WHERE id_product = '22536' 17/05/2024 08:58:17 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '13' WHERE id_product = '22536' 17/05/2024 08:58:17 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '13', id_tax_rules_group = '4', id_category_default = '173', id_argoment_default = '', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22536' 17/05/2024 08:58:17 am >> DELETE FROM ps_specific_price WHERE id_product = '22536' 17/05/2024 08:58: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 ( '33' , '1360293' , '2024-05-09' , '' , '0' , '177' , '4679057' , 'VIA G. VERDI 8 20057 ASSAGO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '109.70' , '109.70' , NOW() , NOW() ) 17/05/2024 08:58: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 = '91855' 17/05/2024 08:58:49 am >> DELETE FROM ps_document_detail WHERE id_document = '91855' 17/05/2024 08:58: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 ( '91855' , '22534' , 'GIOISCI MARIA - A. AMAPANI' , '1' , '1' , '4' , '3.90' , '3.9' , '0' , '0' , '3.90' ) 17/05/2024 08:58:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '22534' AND id_supplier = '177' 17/05/2024 08:58:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22534' , '177' , '1' ) 17/05/2024 08:58: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 ( '91855' , '22535' , 'CARA GIULIA ' , '1' , '1' , '4' , '15.00' , '15' , '0' , '0' , '15.00' ) 17/05/2024 08:58:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '22535' AND id_supplier = '177' 17/05/2024 08:58:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22535' , '177' , '1' ) 17/05/2024 08:58: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 ( '91855' , '21780' , 'FRATELLINO' , '1' , '1' , '4' , '12.00' , '12' , '0' , '0' , '12.00' ) 17/05/2024 08:58:50 am >> DELETE FROM ps_product_supplier WHERE id_product = '21780' AND id_supplier = '177' 17/05/2024 08:58:50 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21780' , '177' , '1' ) 17/05/2024 08:58:50 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 ( '91855' , '22330' , 'LIFE - LA MIA STORIA - PAPA FRANCESCO' , '1' , '1' , '4' , '19.00' , '19' , '0' , '0' , '19.00' ) 17/05/2024 08:58:50 am >> DELETE FROM ps_product_supplier WHERE id_product = '22330' AND id_supplier = '177' 17/05/2024 08:58:50 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22330' , '177' , '1' ) 17/05/2024 08:58:50 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 ( '91855' , '22536' , 'MESSA E SBIADITA - L. DIOTALLEVI' , '2' , '2' , '4' , '13.00' , '13' , '0' , '0' , '26.0000' ) 17/05/2024 08:58:50 am >> DELETE FROM ps_product_supplier WHERE id_product = '22536' AND id_supplier = '177' 17/05/2024 08:58:50 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22536' , '177' , '1' ) 17/05/2024 08:58:50 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 ( '91855' , '21697' , 'ORME SUL CUORE - A. ROMANO' , '1' , '1' , '4' , '12.00' , '12' , '0' , '0' , '12.00' ) 17/05/2024 08:58:50 am >> DELETE FROM ps_product_supplier WHERE id_product = '21697' AND id_supplier = '177' 17/05/2024 08:58:50 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21697' , '177' , '1' ) 17/05/2024 08:58:50 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 ( '91855' , '20326' , 'SEGRETO DI MIO FIGLIO - A. ACUTIS' , '2' , '2' , '4' , '10.90' , '10.9' , '0' , '0' , '21.8000' ) 17/05/2024 08:58:50 am >> DELETE FROM ps_product_supplier WHERE id_product = '20326' AND id_supplier = '177' 17/05/2024 08:58:50 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20326' , '177' , '1' ) 17/05/2024 09:00:49 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 = '22536' 17/05/2024 09:00:49 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22537' , '1' , '' , 'nuovo-prodotto' ) 17/05/2024 09:00:49 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 '22537' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22536' 17/05/2024 09:00:49 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22537' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22536' 17/05/2024 09:02:29 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788832714241' AND id_product != '22537' AND ean13 != '' 17/05/2024 09:02:29 am >> UPDATE ps_product SET id_supplier = '', reference = '1/2', ean13 = '9788832714241', date_upd = NOW() WHERE id_product = '22537' 17/05/2024 09:02:29 am >> UPDATE ps_product_lang SET name = 'HAI LA MIA PAROLA! ', description = '' WHERE id_product = '22537' 17/05/2024 09:02:29 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '16' WHERE id_product = '22537' 17/05/2024 09:02:29 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '16', id_tax_rules_group = '4', id_category_default = '80', 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 = '22537' 17/05/2024 09:02:29 am >> DELETE FROM ps_specific_price WHERE id_product = '22537' 17/05/2024 09:03:08 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 17/05/2024 09:03:08 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22538' , '1' , '' , 'nuovo-prodotto' ) 17/05/2024 09:03:08 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '22538' , '1' , '1' , '2' , NOW() , NOW() ) 17/05/2024 09:03:08 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '22538' , '0' , '1' , '0' , '0' ) 17/05/2024 09:03:50 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788860995698' AND id_product != '22538' AND ean13 != '' 17/05/2024 09:03:50 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788860995698', date_upd = NOW() WHERE id_product = '22538' 17/05/2024 09:03:50 am >> UPDATE ps_product_lang SET name = 'IMPLOSIONE DI UNA RELIGIONE - B. MORI', description = '' WHERE id_product = '22538' 17/05/2024 09:03:50 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '20' WHERE id_product = '22538' 17/05/2024 09:03:50 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '20', id_tax_rules_group = '4', id_category_default = '140', id_argoment_default = '', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22538' 17/05/2024 09:03:50 am >> DELETE FROM ps_specific_price WHERE id_product = '22538' 17/05/2024 09:03:52 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 = '22538' 17/05/2024 09:03:52 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22539' , '1' , '' , 'nuovo-prodotto' ) 17/05/2024 09:03:52 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 '22539' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22538' 17/05/2024 09:03:52 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22539' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22538' 17/05/2024 09:04:26 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788860994844' AND id_product != '22539' AND ean13 != '' 17/05/2024 09:04:26 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788860994844', date_upd = NOW() WHERE id_product = '22539' 17/05/2024 09:04:26 am >> UPDATE ps_product_lang SET name = 'PER UN CRISTIANESIMO SENZA RELIGIONE - B. MORI', description = '' WHERE id_product = '22539' 17/05/2024 09:04:26 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '18.5' WHERE id_product = '22539' 17/05/2024 09:04:26 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '18.5', id_tax_rules_group = '4', id_category_default = '140', id_argoment_default = '', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22539' 17/05/2024 09:04:26 am >> DELETE FROM ps_specific_price WHERE id_product = '22539' 17/05/2024 09:06:13 am >> SELECT document_num FROM ps_document WHERE document_num = '1630' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-17') 17/05/2024 09:06:13 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1630' , '2024-05-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '16.50' , '14.74' , NOW() , NOW() ) 17/05/2024 09:06:13 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91856' 17/05/2024 09:06:13 am >> DELETE FROM ps_document_detail WHERE id_document = '91856' 17/05/2024 09:06:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91856' , '20431' , 'PARTICOLA TAGLIO CHIUSO 35MM - W500' , '2' , '-2' , '3' , '3.30' , '3.1730769230769' , '4' , '0' , '6.60' ) 17/05/2024 09:06:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91856' , '20429' , 'OSTIA SENZA TOSTATURA MORREALE - OS25' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 17/05/2024 09:06:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91856' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '1' , '-1' , '1' , '7.90' , '6.4754098360656' , '22' , '0' , '7.90' ) 17/05/2024 09:07:15 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 17/05/2024 09:07:15 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22540' , '1' , '' , 'nuovo-prodotto' ) 17/05/2024 09:07:15 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '22540' , '1' , '1' , '2' , NOW() , NOW() ) 17/05/2024 09:07:15 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '22540' , '0' , '1' , '0' , '0' ) 17/05/2024 09:07:18 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 = '22539' 17/05/2024 09:07:18 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22541' , '1' , '' , 'nuovo-prodotto' ) 17/05/2024 09:07:18 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 '22541' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22539' 17/05/2024 09:07:18 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22541' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22539' 17/05/2024 09:07:39 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788861382343' AND id_product != '22541' AND ean13 != '' 17/05/2024 09:07:39 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788861382343', date_upd = NOW() WHERE id_product = '22541' 17/05/2024 09:07:39 am >> UPDATE ps_product_lang SET name = 'PORTA DI MEZZO ', description = '' WHERE id_product = '22541' 17/05/2024 09:07:39 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '15' WHERE id_product = '22541' 17/05/2024 09:07:39 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '15', id_tax_rules_group = '4', id_category_default = '47', id_argoment_default = '', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22541' 17/05/2024 09:07:39 am >> DELETE FROM ps_specific_price WHERE id_product = '22541' 17/05/2024 09:08:01 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 = '22541' 17/05/2024 09:08:02 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22542' , '1' , '' , 'nuovo-prodotto' ) 17/05/2024 09:08:02 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 '22542' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22541' 17/05/2024 09:08:02 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22542' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22541' 17/05/2024 09:08:30 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788880770091' AND id_product != '17893' AND ean13 != '' 17/05/2024 09:08:30 am >> UPDATE ps_product SET id_supplier = '47', reference = '7/7', ean13 = '9788880770091', date_upd = NOW() WHERE id_product = '17893' 17/05/2024 09:08:30 am >> UPDATE ps_product_lang SET name = 'POTENZA DELLA LODE - M. CAROTHERS', description = '' WHERE id_product = '17893' 17/05/2024 09:08:30 am >> UPDATE ps_product SET wholesale_price = '7.00', on_sale = '0', price = '11' WHERE id_product = '17893' 17/05/2024 09:08:30 am >> UPDATE ps_product_shop SET wholesale_price = '7.00', price = '11', id_tax_rules_group = '4', id_category_default = '230', 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 = '17893' 17/05/2024 09:08:30 am >> DELETE FROM ps_specific_price WHERE id_product = '17893' 17/05/2024 09:08:52 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' , '1364240' , '2024-05-15' , '' , '0' , '177' , '4679057' , 'VIA G. VERDI 8 20057 ASSAGO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '107.50' , '107.50' , NOW() , NOW() ) 17/05/2024 09:08:52 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 = '91857' 17/05/2024 09:08:52 am >> DELETE FROM ps_document_detail WHERE id_document = '91857' 17/05/2024 09:08:52 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 ( '91857' , '22537' , 'HAI LA MIA PAROLA! ' , '2' , '2' , '4' , '16.00' , '16' , '0' , '0' , '32.0000' ) 17/05/2024 09:08:52 am >> DELETE FROM ps_product_supplier WHERE id_product = '22537' AND id_supplier = '177' 17/05/2024 09:08:52 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22537' , '177' , '1' ) 17/05/2024 09:08:52 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 ( '91857' , '22538' , 'IMPLOSIONE DI UNA RELIGIONE - B. MORI' , '1' , '1' , '4' , '20.00' , '20' , '0' , '0' , '20.00' ) 17/05/2024 09:08:52 am >> DELETE FROM ps_product_supplier WHERE id_product = '22538' AND id_supplier = '177' 17/05/2024 09:08:52 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22538' , '177' , '1' ) 17/05/2024 09:08:52 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 ( '91857' , '22539' , 'PER UN CRISTIANESIMO SENZA RELIGIONE - B. MORI' , '1' , '1' , '4' , '18.50' , '18.5' , '0' , '0' , '18.50' ) 17/05/2024 09:08:52 am >> DELETE FROM ps_product_supplier WHERE id_product = '22539' AND id_supplier = '177' 17/05/2024 09:08:52 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22539' , '177' , '1' ) 17/05/2024 09:08:52 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 ( '91857' , '22541' , 'PORTA DI MEZZO ' , '1' , '1' , '4' , '15.00' , '15' , '0' , '0' , '15.00' ) 17/05/2024 09:08:52 am >> DELETE FROM ps_product_supplier WHERE id_product = '22541' AND id_supplier = '177' 17/05/2024 09:08:52 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22541' , '177' , '1' ) 17/05/2024 09:08:52 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 ( '91857' , '17893' , 'POTENZA DELLA LODE - M. CAROTHERS' , '2' , '2' , '4' , '11.00' , '11' , '0' , '0' , '22.0000' ) 17/05/2024 09:08:52 am >> DELETE FROM ps_product_supplier WHERE id_product = '17893' AND id_supplier = '177' 17/05/2024 09:08:52 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17893' , '177' , '1' ) 17/05/2024 09:25:25 am >> SELECT document_num FROM ps_document WHERE document_num = '88' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-05-17') 17/05/2024 09:25:25 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '88' , '2024-05-17' , '' , '161' , '0' , '4679291' , 'VIA G. MAZZINI VICO III, 8 81047 MACERATA CAMPANIA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '220.40' , '220.40' , NOW() , NOW() ) 17/05/2024 09:25:25 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 = '91858' 17/05/2024 09:25:25 am >> DELETE FROM ps_document_detail WHERE id_document = '91858' 17/05/2024 09:25:25 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 ( '91858' , '21847' , 'UNDICESIMO: SALVA LA TESTA! - P. PELLEGRINO' , '30' , '-30' , '4' , '3.00' , '3' , '0' , '5' , '85.50' ) 17/05/2024 09:25:25 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 ( '91858' , '22374' , 'MOGOL' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '5' , '19.00' ) 17/05/2024 09:25:25 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 ( '91858' , '22536' , 'MESSA E SBIADITA - L. DIOTALLEVI' , '2' , '-2' , '4' , '13.00' , '13' , '0' , '5' , '24.70' ) 17/05/2024 09:25:25 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 ( '91858' , '21697' , 'ORME SUL CUORE - A. ROMANO' , '8' , '-8' , '4' , '12.00' , '12' , '0' , '5' , '91.20' ) 17/05/2024 09:28:50 am >> SELECT document_num FROM ps_document WHERE document_num = '1631' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-17') 17/05/2024 09:28:50 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' , '1631' , '2024-05-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.00' , '4.92' , NOW() , NOW() ) 17/05/2024 09:28:50 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 = '91859' 17/05/2024 09:28:50 am >> DELETE FROM ps_document_detail WHERE id_document = '91859' 17/05/2024 09:28:50 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 ( '91859' , '13562' , 'CORONCINA IN STOFFA CON ROSE E FOGLIOLINE - 3311' , '1' , '-1' , '1' , '6.00' , '4.9180327868852' , '22' , '0' , '6.00' ) 17/05/2024 09:40:34 am >> SELECT document_num FROM ps_document WHERE document_num = '1632' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-17') 17/05/2024 09:40:34 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' , '1632' , '2024-05-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '29.70' , '25.55' , NOW() , NOW() ) 17/05/2024 09:40:34 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 = '91860' 17/05/2024 09:40:34 am >> DELETE FROM ps_document_detail WHERE id_document = '91860' 17/05/2024 09:40:34 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 ( '91860' , '14121' , 'PENTECOSTE - 210' , '2' , '-2' , '1' , '3.6' , '2.9508196721311' , '22' , '0' , '7.20' ) 17/05/2024 09:40:34 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 ( '91860' , '7931' , 'PERGAMENE - CRESIMA MOD. A' , '28' , '-28' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '14.00' ) 17/05/2024 09:40:34 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 ( '91860' , '20429' , 'OSTIA SENZA TOSTATURA MORREALE - OS25' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 17/05/2024 09:40:34 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 ( '91860' , '19089' , 'OSTIA MAGNA 150 - OM 150' , '1' , '-1' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '4.50' ) 17/05/2024 09:59:01 am >> SELECT document_num FROM ps_document WHERE document_num = '1633' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-17') 17/05/2024 09:59: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' , '1633' , '2024-05-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '16.70' , '14.80' , NOW() , NOW() ) 17/05/2024 09:59: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 = '91861' 17/05/2024 09:59:01 am >> DELETE FROM ps_document_detail WHERE id_document = '91861' 17/05/2024 09:59: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 ( '91861' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.90' , '7.2950819672131' , '22' , '0' , '8.90' ) 17/05/2024 09:59: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 ( '91861' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 17/05/2024 09:59: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 ( '91861' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.30' , '4.1346153846154' , '4' , '0' , '4.30' ) 17/05/2024 10:11:10 am >> SELECT document_num FROM ps_document WHERE document_num = '1634' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-17') 17/05/2024 10:11:10 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' , '1634' , '2024-05-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '104.42' , '104.42' , NOW() , NOW() ) 17/05/2024 10:11:10 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 = '91862' 17/05/2024 10:11:10 am >> DELETE FROM ps_document_detail WHERE id_document = '91862' 17/05/2024 10:11:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91862' , '22537' , 'HAI LA MIA PAROLA! ' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 17/05/2024 10:11:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91862' , '22538' , 'IMPLOSIONE DI UNA RELIGIONE - B. MORI' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '5' , '19.00' ) 17/05/2024 10:11:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91862' , '22539' , 'PER UN CRISTIANESIMO SENZA RELIGIONE - B. MORI' , '1' , '-1' , '4' , '18.50' , '18.5' , '0' , '5' , '17.58' ) 17/05/2024 10:11:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91862' , '22283' , 'BIBBIA DI GERUSALEMME VERDE' , '1' , '-1' , '4' , '32.00' , '32' , '0' , '5' , '30.40' ) 17/05/2024 10:11:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91862' , '19424' , 'GESU INTERPRETE DEI SALMI - L. SEMBRANO' , '1' , '-1' , '4' , '14.90' , '14.9' , '0' , '5' , '14.16' ) 17/05/2024 10:11:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91862' , '22191' , 'PREGARE CON I SALMI - 2' , '1' , '-1' , '4' , '8.50' , '8.5' , '0' , '5' , '8.08' ) 17/05/2024 10:33:01 am >> SELECT document_num FROM ps_document WHERE document_num = '1635' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-17') 17/05/2024 10:33: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' , '1635' , '2024-05-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.50' , '9.50' , NOW() , NOW() ) 17/05/2024 10:33: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 = '91863' 17/05/2024 10:33:01 am >> DELETE FROM ps_document_detail WHERE id_document = '91863' 17/05/2024 10:33: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 ( '91863' , '22341' , 'SULLA TUA PAROLA - MAG/GIU 2024' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 17/05/2024 10:33: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 ( '91863' , '22414' , 'SULLA TUA PAROLA - LUG/AGO 2024' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 17/05/2024 10:33:41 am >> SELECT document_num FROM ps_document WHERE document_num = '1636' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-17') 17/05/2024 10:33: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' , '1636' , '2024-05-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.50' , '4.05' , NOW() , NOW() ) 17/05/2024 10:33: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 = '91864' 17/05/2024 10:33:41 am >> DELETE FROM ps_document_detail WHERE id_document = '91864' 17/05/2024 10:33: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 ( '91864' , '17034' , 'SACRAMENTO DEL PERDONO' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 17/05/2024 10:33: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 ( '91864' , '18276' , 'CINGOLO CON NODI - 3280' , '1' , '-1' , '1' , '2.50' , '2.0491803278689' , '22' , '0' , '2.50' ) 17/05/2024 10:36:49 am >> SELECT document_num FROM ps_document WHERE document_num = '1637' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-17') 17/05/2024 10:36: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' , '1637' , '2024-05-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '122.00' , '100.00' , NOW() , NOW() ) 17/05/2024 10:36: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 = '91865' 17/05/2024 10:36:49 am >> DELETE FROM ps_document_detail WHERE id_document = '91865' 17/05/2024 10:36: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 ( '91865' , '4910' , 'ICONA DIPINTA A MANO 18X22' , '1' , '-1' , '1' , '110' , '90.16393442623' , '22' , '0' , '110.00' ) 17/05/2024 10:36: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 ( '91865' , '7202' , 'ARTICOLI RELIGIOSI' , '12' , '-12' , '1' , '1' , '0.81967213114754' , '22' , '0' , '12.00' ) 17/05/2024 10:37:46 am >> SELECT document_num FROM ps_document WHERE document_num = '1638' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-17') 17/05/2024 10:37:46 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' , '1638' , '2024-05-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '200.00' , '163.93' , NOW() , NOW() ) 17/05/2024 10:37:46 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 = '91866' 17/05/2024 10:37:46 am >> DELETE FROM ps_document_detail WHERE id_document = '91866' 17/05/2024 10:37:46 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 ( '91866' , '13071' , 'ICONA DIPINTA A MANO 22X32' , '1' , '-1' , '1' , '200' , '163.93442622951' , '22' , '0' , '200.00' ) 17/05/2024 10:51:23 am >> SELECT document_num FROM ps_document WHERE document_num = '1639' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-17') 17/05/2024 10:51:23 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' , '1639' , '2024-05-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '140.00' , '114.75' , NOW() , NOW() ) 17/05/2024 10:51:23 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 = '91867' 17/05/2024 10:51:23 am >> DELETE FROM ps_document_detail WHERE id_document = '91867' 17/05/2024 10:51:23 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 ( '91867' , '22297' , 'RELIQUIARIO DORATO CM 20' , '1' , '-1' , '1' , '140' , '114.75409836066' , '22' , '0' , '140.00' ) 17/05/2024 10:52:54 am >> SELECT document_num FROM ps_document WHERE document_num = '1640' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-17') 17/05/2024 10:52:54 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' , '1640' , '2024-05-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '105.60' , '86.56' , NOW() , NOW() ) 17/05/2024 10:52:54 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 = '91868' 17/05/2024 10:52:54 am >> DELETE FROM ps_document_detail WHERE id_document = '91868' 17/05/2024 10:52:54 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 ( '91868' , '7202' , 'ARTICOLI RELIGIOSI' , '88' , '-88' , '1' , '1.2' , '0.98360655737705' , '22' , '0' , '105.60' ) 17/05/2024 11:06:16 am >> SELECT document_num FROM ps_document WHERE document_num = '1641' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-17') 17/05/2024 11:06:16 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' , '1641' , '2024-05-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '33.40' , '27.88' , NOW() , NOW() ) 17/05/2024 11:06:16 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 = '91869' 17/05/2024 11:06:16 am >> DELETE FROM ps_document_detail WHERE id_document = '91869' 17/05/2024 11:06:16 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 ( '91869' , '9132' , 'DECINA LEGNO ACERO NATURALE - RG 021-10' , '12' , '-12' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '8.40' ) 17/05/2024 11:06:16 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 ( '91869' , '10475' , 'TEALIGHTS X 50 ' , '3' , '-3' , '1' , '3.90' , '3.1967213114754' , '22' , '0' , '11.70' ) 17/05/2024 11:06:16 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 ( '91869' , '22529' , 'NORME PER PROCEDERE NEL DISCERNIMENTO...' , '1' , '-1' , '4' , '2.80' , '2.8' , '0' , '0' , '2.80' ) 17/05/2024 11:06:16 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 ( '91869' , '19560' , 'PERGAMENA COMUNIONE 17X25' , '15' , '-15' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '10.50' ) 17/05/2024 11:36:18 am >> SELECT ean13 FROM ps_product WHERE ean13 = '5902689302435' AND id_product != '22542' AND ean13 != '' 17/05/2024 11:36:18 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '5902689302435', date_upd = NOW() WHERE id_product = '22542' 17/05/2024 11:36:18 am >> UPDATE ps_product_lang SET name = 'BRACCIALE DECINA COLORATA - BC507', description = '' WHERE id_product = '22542' 17/05/2024 11:36:18 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '1.4' WHERE id_product = '22542' 17/05/2024 11:36:18 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '1.4', id_tax_rules_group = '4', id_category_default = '443', 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 = '22542' 17/05/2024 11:36:18 am >> DELETE FROM ps_specific_price WHERE id_product = '22542' 17/05/2024 11:41:33 am >> SELECT document_num FROM ps_document WHERE document_num = '1642' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-17') 17/05/2024 11:41:33 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' , '1642' , '2024-05-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '77.30' , '64.92' , NOW() , NOW() ) 17/05/2024 11:41:33 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 = '91870' 17/05/2024 11:41:33 am >> DELETE FROM ps_document_detail WHERE id_document = '91870' 17/05/2024 11:41: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 ( '91870' , '22240' , 'PERGAMENA CRESIMA' , '15' , '-15' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '10.50' ) 17/05/2024 11:41: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 ( '91870' , '16310' , 'PORTACHIAVI COLOMBA - KP027' , '9' , '-9' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '10.80' ) 17/05/2024 11:41:34 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 ( '91870' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 17/05/2024 11:41:34 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 ( '91870' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 17/05/2024 11:41:34 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 ( '91870' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '6' , '-6' , '1' , '7.5' , '6.1475409836066' , '22' , '0' , '45.00' ) 17/05/2024 11:48:26 am >> SELECT document_num FROM ps_document WHERE document_num = '1643' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-17') 17/05/2024 11:48:26 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' , '1643' , '2024-05-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.10' , '5.00' , NOW() , NOW() ) 17/05/2024 11:48:26 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 = '91871' 17/05/2024 11:48:26 am >> DELETE FROM ps_document_detail WHERE id_document = '91871' 17/05/2024 11:48:26 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 ( '91871' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.60' , '2.9508196721311' , '22' , '0' , '3.60' ) 17/05/2024 11:48:26 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 ( '91871' , '14772' , 'BRACCIALE SAN BENEDETTO 4 COLORI - 0818/3' , '1' , '-1' , '1' , '2.50' , '2.0491803278689' , '22' , '0' , '2.50' ) 17/05/2024 12:01:34 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '5902689302435' AND id_product != '22542' AND ean13 != '' 17/05/2024 12:01:34 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '5902689302435', date_upd = NOW() WHERE id_product = '22542' 17/05/2024 12:01:34 pm >> UPDATE ps_product_lang SET name = 'BRACCIALE DECINA COLORATA - BC507', description = '' WHERE id_product = '22542' 17/05/2024 12:01:34 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '1.1475409836065573' WHERE id_product = '22542' 17/05/2024 12:01:34 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '1.1475409836065573', id_tax_rules_group = '1', id_category_default = '443', 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 = '22542' 17/05/2024 12:01:34 pm >> DELETE FROM ps_specific_price WHERE id_product = '22542' 17/05/2024 12:02:06 pm >> SELECT document_num FROM ps_document WHERE document_num = '1637' AND id_document != '91865' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-17') 17/05/2024 12:02:06 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1637', document_date = '2024-05-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 = '122.00', price_tax_excluded = '100.00', date_upd = NOW() WHERE id_document = '91865' 17/05/2024 12:02:06 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 = '91865' 17/05/2024 12:02:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '91865' 17/05/2024 12:02:06 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 ( '91865' , '4910' , 'ICONA DIPINTA A MANO 18X22' , '1' , '-1' , '1' , '110.0000' , '90.16393442623' , '22' , '0' , '110.00' ) 17/05/2024 12:02:06 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 ( '91865' , '22542' , 'BRACCIALE DECINA COLORATA - BC507' , '12' , '-12' , '1' , '1' , '0.81967213114754' , '22' , '0' , '12.00' ) 17/05/2024 12:07:45 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 17/05/2024 12:07:45 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22543' , '1' , '' , 'nuovo-prodotto' ) 17/05/2024 12:07:45 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '22543' , '1' , '1' , '2' , NOW() , NOW() ) 17/05/2024 12:07:45 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '22543' , '0' , '1' , '0' , '0' ) 17/05/2024 12:08:33 pm >> SELECT ean13 FROM ps_product WHERE ean13 = 'BC686' AND id_product != '22543' AND ean13 != '' 17/05/2024 12:08:33 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = 'BC686', date_upd = NOW() WHERE id_product = '22543' 17/05/2024 12:08:34 pm >> UPDATE ps_product_lang SET name = 'BRACCIALE DECINA ROSSO - BC686', description = '' WHERE id_product = '22543' 17/05/2024 12:08:34 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0.819672131147541' WHERE id_product = '22543' 17/05/2024 12:08:34 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0.819672131147541', id_tax_rules_group = '1', id_category_default = '443', 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 = '22543' 17/05/2024 12:08:34 pm >> DELETE FROM ps_specific_price WHERE id_product = '22543' 17/05/2024 12:21:05 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 = '22543' 17/05/2024 12:21:05 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22544' , '1' , '' , 'nuovo-prodotto' ) 17/05/2024 12:21:05 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 '22544' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22543' 17/05/2024 12:21:05 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22544' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22543' 17/05/2024 12:21:59 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '5902689313578' AND id_product != '22544' AND ean13 != '' 17/05/2024 12:21:59 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '5902689313578', date_upd = NOW() WHERE id_product = '22544' 17/05/2024 12:21:59 pm >> UPDATE ps_product_lang SET name = 'BRACCIALE DECINA - BD006', description = '' WHERE id_product = '22544' 17/05/2024 12:21:59 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '1.639344262295082' WHERE id_product = '22544' 17/05/2024 12:21:59 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '1.639344262295082', id_tax_rules_group = '1', id_category_default = '443', 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 = '22544' 17/05/2024 12:21:59 pm >> DELETE FROM ps_specific_price WHERE id_product = '22544' 17/05/2024 12:26:22 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 = '22544' 17/05/2024 12:26:22 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22545' , '1' , '' , 'nuovo-prodotto' ) 17/05/2024 12:26:22 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 '22545' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22544' 17/05/2024 12:26:22 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22545' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22544' 17/05/2024 12:26:47 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '5902689317132' AND id_product != '22545' AND ean13 != '' 17/05/2024 12:26:47 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '5902689317132', date_upd = NOW() WHERE id_product = '22545' 17/05/2024 12:26:48 pm >> UPDATE ps_product_lang SET name = 'BRACCIALE DECINA - BD1789N', description = '' WHERE id_product = '22545' 17/05/2024 12:26:48 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '1.639344262295082' WHERE id_product = '22545' 17/05/2024 12:26:48 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '1.639344262295082', id_tax_rules_group = '1', id_category_default = '443', 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 = '22545' 17/05/2024 12:26:48 pm >> DELETE FROM ps_specific_price WHERE id_product = '22545' 17/05/2024 12:36:16 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 = '22545' 17/05/2024 12:36:16 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22546' , '1' , '' , 'nuovo-prodotto' ) 17/05/2024 12:36:16 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 '22546' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22545' 17/05/2024 12:36:16 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22546' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22545' 17/05/2024 12:37:11 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '5902689301193' AND id_product != '22546' AND ean13 != '' 17/05/2024 12:37:11 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '5902689301193', date_upd = NOW() WHERE id_product = '22546' 17/05/2024 12:37:11 pm >> UPDATE ps_product_lang SET name = 'ROSARIO LEGNO - MM5 - R944', description = '' WHERE id_product = '22546' 17/05/2024 12:37:11 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '1.2295081967213115' WHERE id_product = '22546' 17/05/2024 12:37:11 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '1.2295081967213115', id_tax_rules_group = '1', id_category_default = '443', 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 = '22546' 17/05/2024 12:37:11 pm >> DELETE FROM ps_specific_price WHERE id_product = '22546' 17/05/2024 12:37:40 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '5902689301193' AND id_product != '22546' AND ean13 != '' 17/05/2024 12:37:40 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '5902689301193', date_upd = NOW() WHERE id_product = '22546' 17/05/2024 12:37:40 pm >> UPDATE ps_product_lang SET name = 'ROSARIO LEGNO - MM5 - R944', description = '' WHERE id_product = '22546' 17/05/2024 12:37:40 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '1.2295081967213115' WHERE id_product = '22546' 17/05/2024 12:37:40 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '1.2295081967213115', id_tax_rules_group = '1', id_category_default = '443', 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 = '22546' 17/05/2024 12:37:40 pm >> DELETE FROM ps_specific_price WHERE id_product = '22546' 17/05/2024 12:39:28 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 = '22546' 17/05/2024 12:39:28 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22547' , '1' , '' , 'nuovo-prodotto' ) 17/05/2024 12:39:28 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 '22547' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22546' 17/05/2024 12:39:28 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22547' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22546' 17/05/2024 12:40:30 pm >> SELECT ean13 FROM ps_product WHERE ean13 = 'R07' AND id_product != '22547' AND ean13 != '' 17/05/2024 12:40:30 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = 'R07', date_upd = NOW() WHERE id_product = '22547' 17/05/2024 12:40:30 pm >> UPDATE ps_product_lang SET name = 'ROSARIO LEGNO COLORATO - R07', description = '' WHERE id_product = '22547' 17/05/2024 12:40:31 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0.9836065573770492' WHERE id_product = '22547' 17/05/2024 12:40:31 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0.9836065573770492', id_tax_rules_group = '1', id_category_default = '443', 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 = '22547' 17/05/2024 12:40:31 pm >> DELETE FROM ps_specific_price WHERE id_product = '22547' 17/05/2024 12:40:57 pm >> SELECT ean13 FROM ps_product WHERE ean13 = 'R07' AND id_product != '22547' AND ean13 != '' 17/05/2024 12:40:58 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = 'R07', date_upd = NOW() WHERE id_product = '22547' 17/05/2024 12:40:58 pm >> UPDATE ps_product_lang SET name = 'ROSARIO LEGNO COLORATO - R07', description = '' WHERE id_product = '22547' 17/05/2024 12:40:58 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '1.0655737704918034' WHERE id_product = '22547' 17/05/2024 12:40:58 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '1.0655737704918034', id_tax_rules_group = '1', id_category_default = '443', 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 = '22547' 17/05/2024 12:40:58 pm >> DELETE FROM ps_specific_price WHERE id_product = '22547' 17/05/2024 12:43:46 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 17/05/2024 12:43:46 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22548' , '1' , '' , 'nuovo-prodotto' ) 17/05/2024 12:43:46 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '22548' , '1' , '1' , '2' , NOW() , NOW() ) 17/05/2024 12:43:46 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '22548' , '0' , '1' , '0' , '0' ) 17/05/2024 12:45:07 pm >> SELECT ean13 FROM ps_product WHERE ean13 = 'R178' AND id_product != '22548' AND ean13 != '' 17/05/2024 12:45:07 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = 'R178', date_upd = NOW() WHERE id_product = '22548' 17/05/2024 12:45:07 pm >> UPDATE ps_product_lang SET name = 'ROSARIO LEGNO - MM8 - R178', description = '' WHERE id_product = '22548' 17/05/2024 12:45:07 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0.9836065573770492' WHERE id_product = '22548' 17/05/2024 12:45:07 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0.9836065573770492', id_tax_rules_group = '1', id_category_default = '443', 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 = '22548' 17/05/2024 12:45:07 pm >> DELETE FROM ps_specific_price WHERE id_product = '22548' 17/05/2024 12:53:42 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22548' 17/05/2024 12:53:42 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22549' , '1' , '' , 'nuovo-prodotto' ) 17/05/2024 12:53:42 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22549' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22548' 17/05/2024 12:53:42 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22549' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22548' 17/05/2024 12:54:40 pm >> SELECT ean13 FROM ps_product WHERE ean13 = 'R282' AND id_product != '22549' AND ean13 != '' 17/05/2024 12:54:40 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = 'R282', date_upd = NOW() WHERE id_product = '22549' 17/05/2024 12:54:40 pm >> UPDATE ps_product_lang SET name = 'ROSARIO LEGNO MM8 - R282', description = '' WHERE id_product = '22549' 17/05/2024 12:54:40 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0.9836065573770492' WHERE id_product = '22549' 17/05/2024 12:54:40 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0.9836065573770492', id_tax_rules_group = '1', id_category_default = '443', 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 = '22549' 17/05/2024 12:54:40 pm >> DELETE FROM ps_specific_price WHERE id_product = '22549' 17/05/2024 12:57:28 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001716' AND id_product != '18223' AND ean13 != '' 17/05/2024 12:57:28 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '001716', date_upd = NOW() WHERE id_product = '18223' 17/05/2024 12:57:28 pm >> UPDATE ps_product_lang SET name = 'ROSARIO MISSIONARIO MM8 - R102', description = '' WHERE id_product = '18223' 17/05/2024 12:57:28 pm >> UPDATE ps_product SET wholesale_price = '0.33', on_sale = '0', price = '1.1475409836065573' WHERE id_product = '18223' 17/05/2024 12:57:28 pm >> UPDATE ps_product_shop SET wholesale_price = '0.33', price = '1.1475409836065573', id_tax_rules_group = '1', id_category_default = '443', 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 = '18223' 17/05/2024 12:57:28 pm >> DELETE FROM ps_specific_price WHERE id_product = '18223' 17/05/2024 01:01:31 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '591/05/2024' , '2024-05-07' , '05' , '0' , '123' , '4669610' , 'RYNEK WIELUNSKI, 27 42202 CZESTOCHOWA' , '' , '' , '35' , '0' , '0' , '0' , '0' , '' , '9' , '0' , '1076.72' , '1076.72' , NOW() , NOW() ) 17/05/2024 01:01:31 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91872' 17/05/2024 01:01:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '91872' 17/05/2024 01:01:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91872' , '22542' , 'BRACCIALE DECINA COLORATA - BC507' , '360' , '360' , '0' , '0.57' , '0.57' , '' , '0' , '205.2000' ) 17/05/2024 01:01:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22542' AND id_supplier = '123' 17/05/2024 01:01:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22542' , '123' , '1' ) 17/05/2024 01:01:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91872' , '22543' , 'BRACCIALE DECINA ROSSO - BC686' , '72' , '72' , '0' , '0.37' , '0.37' , '' , '0' , '26.6400' ) 17/05/2024 01:01:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22543' AND id_supplier = '123' 17/05/2024 01:01:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22543' , '123' , '1' ) 17/05/2024 01:01:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91872' , '22544' , 'BRACCIALE DECINA - BD006' , '36' , '36' , '0' , '0.65' , '0.65' , '' , '0' , '23.4000' ) 17/05/2024 01:01:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22544' AND id_supplier = '123' 17/05/2024 01:01:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22544' , '123' , '1' ) 17/05/2024 01:01:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91872' , '20062' , 'BRACCIALE DECINA - BD018' , '48' , '48' , '0' , '0.61' , '0.61' , '' , '0' , '29.2800' ) 17/05/2024 01:01:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20062' AND id_supplier = '123' 17/05/2024 01:01:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20062' , '123' , '1' ) 17/05/2024 01:01:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91872' , '21097' , 'BRACCIALE DECINA - BC1768N' , '36' , '36' , '0' , '0.65' , '0.65' , '' , '0' , '23.4000' ) 17/05/2024 01:01:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21097' AND id_supplier = '123' 17/05/2024 01:01:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21097' , '123' , '1' ) 17/05/2024 01:01:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91872' , '22545' , 'BRACCIALE DECINA - BD1789N' , '36' , '36' , '0' , '0.65' , '0.65' , '' , '0' , '23.4000' ) 17/05/2024 01:01:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22545' AND id_supplier = '123' 17/05/2024 01:01:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22545' , '123' , '1' ) 17/05/2024 01:01:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91872' , '18217' , 'BRACCIALE DECINA PIETRE - BD019' , '36' , '36' , '0' , '0.7' , '0.7' , '' , '0' , '25.2000' ) 17/05/2024 01:01:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18217' AND id_supplier = '123' 17/05/2024 01:01:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18217' , '123' , '1' ) 17/05/2024 01:01:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91872' , '18898' , 'BRACCIALE DECINA LEGNO - BC1745' , '36' , '36' , '0' , '0.76' , '0.76' , '' , '0' , '27.3600' ) 17/05/2024 01:01:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18898' AND id_supplier = '123' 17/05/2024 01:01:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18898' , '123' , '1' ) 17/05/2024 01:01:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91872' , '16310' , 'PORTACHIAVI COLOMBA - KP027' , '72' , '72' , '0' , '0.46' , '0.46' , '' , '0' , '33.1200' ) 17/05/2024 01:01:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16310' AND id_supplier = '123' 17/05/2024 01:01:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16310' , '123' , '1' ) 17/05/2024 01:01:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91872' , '22546' , 'ROSARIO LEGNO - MM5 - R944' , '120' , '120' , '0' , '0.61' , '0.61' , '' , '0' , '73.2000' ) 17/05/2024 01:01:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22546' AND id_supplier = '123' 17/05/2024 01:01:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22546' , '123' , '1' ) 17/05/2024 01:01:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91872' , '22547' , 'ROSARIO LEGNO COLORATO - R07' , '228' , '228' , '0' , '0.46' , '0.46' , '' , '0' , '104.8800' ) 17/05/2024 01:01:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22547' AND id_supplier = '123' 17/05/2024 01:01:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22547' , '123' , '1' ) 17/05/2024 01:01:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91872' , '22548' , 'ROSARIO LEGNO - MM8 - R178' , '408' , '408' , '0' , '0.41' , '0.41' , '' , '0' , '167.2800' ) 17/05/2024 01:01:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22548' AND id_supplier = '123' 17/05/2024 01:01:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22548' , '123' , '1' ) 17/05/2024 01:01:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91872' , '22549' , 'ROSARIO LEGNO MM8 - R282' , '144' , '144' , '0' , '0.41' , '0.41' , '' , '0' , '59.0400' ) 17/05/2024 01:01:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22549' AND id_supplier = '123' 17/05/2024 01:01:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22549' , '123' , '1' ) 17/05/2024 01:01:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91872' , '18223' , 'ROSARIO MISSIONARIO MM8 - R102' , '408' , '408' , '0' , '0.54' , '0.54' , '' , '0' , '220.3200' ) 17/05/2024 01:01:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18223' AND id_supplier = '123' 17/05/2024 01:01:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18223' , '123' , '1' ) 17/05/2024 03:06:22 pm >> DELETE FROM ps_product WHERE id_product = '10448' 17/05/2024 03:06:22 pm >> DELETE FROM ps_product_shop WHERE id_product = '10448' 17/05/2024 03:06:22 pm >> DELETE FROM ps_product_lang WHERE id_product = '10448' 17/05/2024 03:06:22 pm >> DELETE FROM ps_stock_available WHERE id_product = '10448' 17/05/2024 03:10:51 pm >> SELECT document_num FROM ps_document WHERE document_num = '1194' AND id_document != '91321' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-18') 17/05/2024 03:10:51 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1194', document_date = '2024-04-18', 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 = '44.00', price_tax_excluded = '39.31', date_upd = NOW() WHERE id_document = '91321' 17/05/2024 03:10: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 = '91321' 17/05/2024 03:10:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '91321' 17/05/2024 03:10: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 ( '91321' , '10453' , 'TAU ULIVO - 21,5X15 - OGGETTI' , '1' , '-1' , '1' , '26' , '21.311475409836' , '22' , '0' , '26.00' ) 17/05/2024 03:10: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 ( '91321' , '12137' , 'CROCIFISSO SAN DAMIANO - 378' , '6' , '-6' , '4' , '3' , '3' , '0' , '0' , '18.00' ) 17/05/2024 03:12:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '1173' AND id_document != '91297' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-16') 17/05/2024 03:12:46 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1173', document_date = '2024-04-16', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '45.00', price_tax_excluded = '40.13', date_upd = NOW() WHERE id_document = '91297' 17/05/2024 03:12: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 = '91297' 17/05/2024 03:12:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '91297' 17/05/2024 03:12: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 ( '91297' , '12137' , 'CROCIFISSO SAN DAMIANO - 378' , '6' , '-6' , '4' , '3' , '3' , '0' , '0' , '18.00' ) 17/05/2024 03:12: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 ( '91297' , '13313' , 'MARIA CHE SCIOGLIE I NODI - 401' , '8' , '-8' , '1' , '3' , '2.4590163934426' , '22' , '0' , '24.00' ) 17/05/2024 03:12: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 ( '91297' , '16398' , 'MADONNA DELLE GRAZIE - 143' , '1' , '-1' , '1' , '3' , '2.4590163934426' , '22' , '0' , '3.00' ) 17/05/2024 03:13:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '1509' AND id_document != '91710' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-09') 17/05/2024 03:13:43 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1509', document_date = '2024-05-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 = '32.00', price_tax_excluded = '26.23', date_upd = NOW() WHERE id_document = '91710' 17/05/2024 03:13:43 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 = '91710' 17/05/2024 03:13:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '91710' 17/05/2024 03:13:43 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 ( '91710' , '2177' , 'CLERGY BASIC - MM - B&P' , '1' , '-1' , '1' , '32' , '26.229508196721' , '22' , '0' , '32.00' ) 17/05/2024 03:29:35 pm >> SELECT document_num FROM ps_document WHERE document_num = '1644' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-17') 17/05/2024 03:29: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' , '1644' , '2024-05-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '28.50' , '28.50' , NOW() , NOW() ) 17/05/2024 03:29: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 = '91873' 17/05/2024 03:29:35 pm >> DELETE FROM ps_document_detail WHERE id_document = '91873' 17/05/2024 03:29: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 ( '91873' , '22412' , 'SACRA BIBBIA - 8602' , '1' , '-1' , '4' , '30.00' , '30' , '0' , '5' , '28.50' ) 17/05/2024 03:34:01 pm >> SELECT document_num FROM ps_document WHERE document_num = '1645' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-17') 17/05/2024 03:34:01 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' , '1645' , '2024-05-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '23.35' , '23.35' , NOW() , NOW() ) 17/05/2024 03:34:01 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91874' 17/05/2024 03:34:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '91874' 17/05/2024 03:34:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91874' , '9613' , 'SANTA TERESA DI LISIEUX' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 17/05/2024 03:34:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91874' , '3776' , 'EDITH STEIN - S.TERESA BENEDETTA DELLA CROCE - V.SALVOLDI' , '1' , '-1' , '4' , '4.00' , '4' , '0' , '5' , '3.80' ) 17/05/2024 03:34:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91874' , '9563' , 'SANTA GEMMA GALGANI - G.DI LUCA' , '1' , '-1' , '4' , '3.40' , '3.4' , '0' , '0' , '3.40' ) 17/05/2024 03:34:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91874' , '9573' , 'SANTA LUCIA' , '1' , '-1' , '4' , '4.00' , '4' , '0' , '5' , '3.80' ) 17/05/2024 03:34:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91874' , '9436' , 'SAN GABRIELE DELLADDOLORATA - V.SALVOLDI' , '1' , '-1' , '4' , '4.00' , '4' , '0' , '5' , '3.80' ) 17/05/2024 03:34:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91874' , '9553' , 'SANTA CHIARA DI ASSISI - G.POLIDORO' , '1' , '-1' , '4' , '4.00' , '4' , '0' , '5' , '3.80' ) 17/05/2024 03:53:18 pm >> SELECT document_num FROM ps_document WHERE document_num = '29/A' AND id_document != '90546' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-02-28') 17/05/2024 03:53:18 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '29/A', document_date = '2024-02-28', document_letter = 'A', id_customer = '470', id_supplier = '', id_address = '4679186', address1 = 'LARGO FRATELLI DEL GIUDICE 37 84069 ROCCADASPIDE', 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 = '124.00', price_tax_excluded = '124.00', date_upd = NOW() WHERE id_document = '90546' 17/05/2024 03:53: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 = '90546' 17/05/2024 03:53:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '90546' 17/05/2024 03:53: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 ( '90546' , '18276' , 'CINGOLO CON NODI - 3280' , '6' , '-6' , '0' , '2.5000' , '2.5' , '0' , '0' , '15.00' ) 17/05/2024 03:53: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 ( '90546' , '22198' , 'CORONCINA PRIMA COMUNIONE - 3313' , '8' , '-8' , '0' , '8.0000' , '8' , '0' , '0' , '64.00' ) 17/05/2024 03:53: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 ( '90546' , '7202' , 'TUNICA 2 PIEG. MISURA 110' , '1' , '-1' , '0' , '45' , '45' , '' , '0' , '45.00' ) 17/05/2024 03:53: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 ( '90546' , '' , 'BUONO TUNICHE SPESO CON CASULA BIANCA' , '0' , '0' , '0' , '0' , '0' , '' , '0' , '0.00' ) 17/05/2024 04:06:59 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '379' , '2024-05-16' , '' , '0' , '50' , '2645' , 'VIA P. G. SEMERIA, 19 70014 CONVERSANO' , '' , '' , '6' , '1' , '0' , '0' , '0' , '' , '9' , '0' , '95.16' , '78.00' , NOW() , NOW() ) 17/05/2024 04:06:59 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91875' 17/05/2024 04:06:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '91875' 17/05/2024 04:06:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91875' , '22336' , 'CALAMITE ' , '6' , '6' , '1' , '2' , '1.6393442622951' , '22' , '0' , '14.6400' ) 17/05/2024 04:06:59 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22336' AND id_supplier = '50' 17/05/2024 04:06:59 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22336' , '50' , '1' ) 17/05/2024 04:06:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91875' , '3181' , 'CALAMITE CROCIFISSO 6X9' , '30' , '30' , '1' , '2' , '1.6393442622951' , '22' , '0' , '73.2000' ) 17/05/2024 04:06:59 pm >> DELETE FROM ps_product_supplier WHERE id_product = '3181' AND id_supplier = '50' 17/05/2024 04:06:59 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3181' , '50' , '1' ) 17/05/2024 04:34:43 pm >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'vZsVe39keaCvL9Xk' , NOW() , NOW() ) 17/05/2024 04:34:43 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4107' , '1' ) 17/05/2024 04:34:44 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4107' , '2' ) 17/05/2024 04:34:44 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4107' , '3' ) 17/05/2024 04:50:06 pm >> SELECT document_num FROM ps_document WHERE document_num = '1646' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-17') 17/05/2024 04:50:06 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' , '1646' , '2024-05-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.40' , '9.34' , NOW() , NOW() ) 17/05/2024 04:50:06 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 = '91876' 17/05/2024 04:50:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '91876' 17/05/2024 04:50:06 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 ( '91876' , '11691' , 'BRACCIALE TRECCIA DECINA - 818/7' , '3' , '-3' , '1' , '3' , '2.4590163934426' , '22' , '0' , '9.00' ) 17/05/2024 04:50:07 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 ( '91876' , '16310' , 'PORTACHIAVI COLOMBA - KP027' , '2' , '-2' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '2.40' ) 17/05/2024 05:20:23 pm >> SELECT document_num FROM ps_document WHERE document_num = '1647' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-17') 17/05/2024 05:20:23 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' , '1647' , '2024-05-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.00' , '15.00' , NOW() , NOW() ) 17/05/2024 05:20:23 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 = '91877' 17/05/2024 05:20:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '91877' 17/05/2024 05:20:23 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 ( '91877' , '22541' , 'PORTA DI MEZZO ' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '0' , '15.00' ) 17/05/2024 05:36:36 pm >> SELECT document_num FROM ps_document WHERE document_num = '1648' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-17') 17/05/2024 05:36:36 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' , '1648' , '2024-05-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '22.50' , '20.61' , NOW() , NOW() ) 17/05/2024 05:36:36 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 = '91878' 17/05/2024 05:36:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '91878' 17/05/2024 05:36:36 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 ( '91878' , '19560' , 'PERGAMENA COMUNIONE 17X25' , '15' , '-15' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '10.50' ) 17/05/2024 05:36:36 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 ( '91878' , '11151' , 'LIBRI' , '10' , '-10' , '4' , '1.2' , '1.2' , '0' , '0' , '12.00' ) 17/05/2024 05:39:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '1649' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-17') 17/05/2024 05:39:14 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' , '1649' , '2024-05-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.00' , '14.00' , NOW() , NOW() ) 17/05/2024 05:39:14 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 = '91879' 17/05/2024 05:39:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '91879' 17/05/2024 05:39:14 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 ( '91879' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '14' , '14' , '0' , '0' , '14.00' ) 17/05/2024 05:42:48 pm >> SELECT document_num FROM ps_document WHERE document_num = '1257' AND id_document != '91399' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-23') 17/05/2024 05:42:48 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1257', document_date = '2024-04-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 = '319.00', price_tax_excluded = '270.84', date_upd = NOW() WHERE id_document = '91399' 17/05/2024 05:42:48 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91399' 17/05/2024 05:42:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '91399' 17/05/2024 05:42:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91399' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '60' , '-60' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '180.00' ) 17/05/2024 05:42:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91399' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '2' , '-2' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '26.00' ) 17/05/2024 05:42:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91399' , '19107' , 'INCENSO GRANI 3A - BUSTA' , '1' , '-1' , '1' , '30.0000' , '24.590163934426' , '22' , '0' , '30.00' ) 17/05/2024 05:42:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91399' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '12' , '-12' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '42.00' ) 17/05/2024 05:42:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91399' , '7311' , 'OSTIA SOTTILE 74MM' , '12' , '-12' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '24.00' ) 17/05/2024 05:42:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91399' , '11691' , 'BRACCIALE TRECCIA DECINA - 818/7' , '1' , '-1' , '1' , '2' , '1.6393442622951' , '22' , '0' , '2.00' ) 17/05/2024 05:42:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91399' , '11691' , 'BRACCIALE TRECCIA DECINA - 818/7' , '5' , '-5' , '1' , '3' , '2.4590163934426' , '22' , '0' , '15.00' ) 17/05/2024 06:11:50 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 17/05/2024 06:11:50 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22550' , '1' , '' , 'nuovo-prodotto' ) 17/05/2024 06:11:50 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '22550' , '1' , '1' , '2' , NOW() , NOW() ) 17/05/2024 06:11:50 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '22550' , '0' , '1' , '0' , '0' ) 17/05/2024 06:15:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '1650' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-17') 17/05/2024 06:15: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' , '1650' , '2024-05-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '715.00' , '715.00' , NOW() , NOW() ) 17/05/2024 06:15: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 = '91880' 17/05/2024 06:15:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '91880' 17/05/2024 06:15:57 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 ( '91880' , '22214' , 'VIE DI MARIA - F. DE CRISTOFARO' , '47' , '-47' , '4' , '13.00' , '13' , '0' , '5' , '580.45' ) 17/05/2024 06:15:57 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 ( '91880' , '19512' , 'SGUARDO DI GESU - F. CRISTOFARO' , '8' , '-8' , '4' , '16.00' , '16' , '0' , '5' , '121.60' ) 17/05/2024 06:15:57 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 ( '91880' , '19512' , 'SGUARDO DI GESU - F. CRISTOFARO' , '1' , '-1' , '4' , '12.95' , '12.95' , '0' , '0' , '12.95' ) 17/05/2024 06:20:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '1651' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-17') 17/05/2024 06:20:26 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1651' , '2024-05-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.80' , '9.18' , NOW() , NOW() ) 17/05/2024 06:20:26 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91881' 17/05/2024 06:20:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '91881' 17/05/2024 06:20:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91881' , '22408' , 'PASTRELLA CRESIMA - 1302/K178' , '1' , '-1' , '1' , '9.00' , '7.3770491803279' , '22' , '0' , '9.00' ) 17/05/2024 06:20:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91881' , '22484' , 'CRESIMA' , '1' , '-1' , '4' , '1.80' , '1.8' , '0' , '0' , '1.80' ) 17/05/2024 06:22:39 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '1000000015881' AND id_product != '22550' AND ean13 != '' 17/05/2024 06:22:39 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '1000000015881', date_upd = NOW() WHERE id_product = '22550' 17/05/2024 06:22:39 pm >> UPDATE ps_product_lang SET name = 'BROCCA E PIATTINO dorati - CM 23 PALLADIATI - 685', description = '' WHERE id_product = '22550' 17/05/2024 06:22:39 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '261.4754098360656' WHERE id_product = '22550' 17/05/2024 06:22:39 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '261.4754098360656', id_tax_rules_group = '1', id_category_default = '147', 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 = '22550' 17/05/2024 06:22:39 pm >> DELETE FROM ps_specific_price WHERE id_product = '22550' 17/05/2024 06:23:47 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000449' AND id_product != '11269' AND ean13 != '' 17/05/2024 06:23:47 pm >> UPDATE ps_product SET id_supplier = '12', reference = '', ean13 = '000449', date_upd = NOW() WHERE id_product = '11269' 17/05/2024 06:23:47 pm >> UPDATE ps_product_lang SET name = 'VETRO BIANCO CON DECORAZIONI 8GG - 1495 ', description = '' WHERE id_product = '11269' 17/05/2024 06:23:47 pm >> UPDATE ps_product SET wholesale_price = '5.70', on_sale = '0', price = '13.934426229508198' WHERE id_product = '11269' 17/05/2024 06:23:47 pm >> UPDATE ps_product_shop SET wholesale_price = '5.70', price = '13.934426229508198', id_tax_rules_group = '1', id_category_default = '147', 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 = '11269' 17/05/2024 06:23:47 pm >> DELETE FROM ps_specific_price WHERE id_product = '11269' 17/05/2024 06:24:49 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' , '1660' , '2024-05-15' , '' , '0' , '12' , '2607' , 'VIA NAZIONALE NORD, 4 - LAGARO 40035 CASTIGLIONE DEI PEPOLI' , '' , '' , '11' , '1' , '0' , '0' , '0' , '' , '9' , '0' , '187.27' , '153.50' , NOW() , NOW() ) 17/05/2024 06:24:49 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91882' 17/05/2024 06:24:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '91882' 17/05/2024 06:24:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91882' , '22550' , 'BROCCA E PIATTINO dorati - CM 23 PALLADIATI - 685' , '1' , '1' , '1' , '131' , '107.37704918033' , '22' , '5' , '151.8290' ) 17/05/2024 06:24:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22550' AND id_supplier = '12' 17/05/2024 06:24:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22550' , '12' , '1' ) 17/05/2024 06:24:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91882' , '11269' , 'VETRO BIANCO CON DECORAZIONI 8GG - 1495 ' , '1' , '1' , '1' , '7' , '5.7377049180328' , '22' , '5' , '8.1130' ) 17/05/2024 06:24:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11269' AND id_supplier = '12' 17/05/2024 06:24:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11269' , '12' , '1' ) 17/05/2024 06:24:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91882' , '1370' , 'BROCCHETTE RICAMBIO PER ART. 523 - 500' , '2' , '2' , '1' , '6' , '4.9180327868852' , '22' , '5' , '13.9080' ) 17/05/2024 06:24:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1370' AND id_supplier = '12' 17/05/2024 06:24:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1370' , '12' , '1' ) 17/05/2024 06:37:25 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400318128' AND id_product != '22408' AND ean13 != '' 17/05/2024 06:37:25 pm >> UPDATE ps_product SET id_supplier = '28', reference = '', ean13 = '8058400318128', date_upd = NOW() WHERE id_product = '22408' 17/05/2024 06:37:25 pm >> UPDATE ps_product_lang SET name = 'PiASTRELLA CRESIMA - 1302/K178', description = '' WHERE id_product = '22408' 17/05/2024 06:37:25 pm >> UPDATE ps_product SET wholesale_price = '3.29', on_sale = '0', price = '7.3770' WHERE id_product = '22408' 17/05/2024 06:37:25 pm >> UPDATE ps_product_shop SET wholesale_price = '3.29', price = '7.3770', id_tax_rules_group = '1', id_category_default = '95', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22408' 17/05/2024 06:37:25 pm >> DELETE FROM ps_specific_price WHERE id_product = '22408' 17/05/2024 06:40:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '1652' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-17') 17/05/2024 06:40: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' , '1652' , '2024-05-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.00' , '7.38' , NOW() , NOW() ) 17/05/2024 06:40: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 = '91883' 17/05/2024 06:40:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '91883' 17/05/2024 06:40: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 ( '91883' , '14062' , 'STELLARIO PLEX CM 8' , '1' , '-1' , '1' , '9.00' , '7.3770491803279' , '22' , '0' , '9.00' ) 17/05/2024 06:52:25 pm >> SELECT document_num FROM ps_document WHERE document_num = '1217' AND id_document != '91345' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-19') 17/05/2024 06:52:25 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1217', document_date = '2024-04-19', 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 = '51.00', price_tax_excluded = '41.80', date_upd = NOW() WHERE id_document = '91345' 17/05/2024 06:52: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 = '91345' 17/05/2024 06:52:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '91345' 17/05/2024 06:52:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91345' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '19' , '15.573770491803' , '22' , '0' , '19.00' ) 17/05/2024 06:52:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91345' , '13562' , 'CORONCINA IN STOFFA CON ROSE E FOGLIOLINE - 3311' , '1' , '-1' , '1' , '6.0000' , '4.9180327868852' , '22' , '0' , '6.00' ) 17/05/2024 06:52:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91345' , '19772' , 'BRACCIALE ARGENTO/EMATITE - 1374CAV' , '1' , '-1' , '1' , '20.00' , '16.393442622951' , '22' , '0' , '20.00' ) 17/05/2024 06:52:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91345' , '14926' , 'VESTINA BATTESIMALE' , '1' , '-1' , '1' , '6.00' , '4.9180327868852' , '22' , '0' , '6.00' ) 17/05/2024 07:03:37 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000449' AND id_product != '11269' AND ean13 != '' 17/05/2024 07:03:37 pm >> UPDATE ps_product SET id_supplier = '12', reference = '', ean13 = '000449', date_upd = NOW() WHERE id_product = '11269' 17/05/2024 07:03:37 pm >> UPDATE ps_product_lang SET name = 'VETRO BIANCO CON DECORAZIONI 8GG - 1495 ', description = '' WHERE id_product = '11269' 17/05/2024 07:03:37 pm >> UPDATE ps_product SET wholesale_price = '5.70', on_sale = '0', price = '13.114754098360656' WHERE id_product = '11269' 17/05/2024 07:03:37 pm >> UPDATE ps_product_shop SET wholesale_price = '5.70', price = '13.114754098360656', id_tax_rules_group = '1', id_category_default = '147', 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 = '11269' 17/05/2024 07:03:37 pm >> DELETE FROM ps_specific_price WHERE id_product = '11269' 17/05/2024 07:05:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '1653' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-17') 17/05/2024 07:05:17 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1653' , '2024-05-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.80' , '3.93' , NOW() , NOW() ) 17/05/2024 07:05:17 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91884' 17/05/2024 07:05:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '91884' 17/05/2024 07:05:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91884' , '20516' , 'CROCE COMUNIONE - 42/08' , '4' , '-4' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '4.80' ) 17/05/2024 07:06:08 pm >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'kZpzxXMb8crKFzCp' , NOW() , NOW() ) 17/05/2024 07:06:08 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4108' , '1' ) 17/05/2024 07:06:08 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4108' , '2' ) 17/05/2024 07:06:08 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4108' , '3' ) 17/05/2024 07:08:09 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4108' 17/05/2024 07:08:10 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '4108' , '10' , '210' , 'SWOT COMPANY SRLS' , '' , '' , 'VIA RENATO DE MARTINO 33' , '' , '84124' , 'SALERNO' , '' , '' , '3383660112' , '05872530653' , '' , NOW() , NOW() ) 17/05/2024 07:08:10 pm >> UPDATE ps_customer SET email = 'info@swotcompany.com', sdi = 'M5UXCR1', pec = 'swotcompanysrls@pec.it', date_upd = NOW() WHERE id_customer = '4108' 17/05/2024 07:09:29 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4108' 17/05/2024 07:09:29 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '4108' , '10' , '210' , 'SWOT COMPANY SRLS' , '' , '' , 'VIA RENATO DE MARTINO 33' , '' , '84124' , 'SALERNO' , '' , '' , '3383660112' , '05872530653' , '' , NOW() , NOW() ) 17/05/2024 07:09:29 pm >> UPDATE ps_customer SET email = 'info@swotcompany.com', sdi = 'M5UXCR1', pec = 'swotcompanysrls@pec.it', date_upd = NOW() WHERE id_customer = '4108' 17/05/2024 07:11:16 pm >> SELECT document_num FROM ps_document WHERE document_num = '3428' AND id_document != '88682' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-02') 17/05/2024 07:11:16 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3428', document_date = '2023-11-02', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '28.00', price_tax_excluded = '22.95', date_upd = NOW() WHERE id_document = '88682' 17/05/2024 07:11:16 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 = '88682' 17/05/2024 07:11:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '88682' 17/05/2024 07:11:16 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 ( '88682' , '7931' , 'PERGAMENE - CRESIMA MOD. A' , '6' , '-6' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '3.00' ) 17/05/2024 07:11:16 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 ( '88682' , '7936' , 'PERGAMENE - CRESIMA MOD. C' , '50' , '-50' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '25.00' ) 17/05/2024 07:11:56 pm >> SELECT document_num FROM ps_document WHERE document_num = '11/L' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-05-17') 17/05/2024 07:11: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 ( '23' , '11/L' , '2024-05-17' , 'L' , '4108' , '0' , '4679325' , 'VIA RENATO DE MARTINO 33 84124 SALERNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '15' , '0' , '70.00' , '63.60' , NOW() , NOW() ) 17/05/2024 07:11: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 = '91885' 17/05/2024 07:11:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '91885' 17/05/2024 07:11: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 ( '91885' , '15801' , 'ARGENTO A PESO' , '1' , '-1' , '1' , '35.5' , '29.098360655738' , '22' , '0' , '35.50' ) 17/05/2024 07:11: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 ( '91885' , '21483' , 'BIBBIA - SCRUTATE - TELATA' , '1' , '-1' , '4' , '34.5' , '34.5' , '0' , '0' , '34.50' ) 17/05/2024 07:41:05 pm >> SELECT document_num FROM ps_document WHERE document_num = '1200' AND id_document != '91327' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-18') 17/05/2024 07:41:05 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1200', document_date = '2024-04-18', 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 = '97.00', price_tax_excluded = '79.51', date_upd = NOW() WHERE id_document = '91327' 17/05/2024 07:41:05 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 = '91327' 17/05/2024 07:41:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '91327' 17/05/2024 07:41:06 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 ( '91327' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '15.5' , '12.704918032787' , '22' , '0' , '15.50' ) 17/05/2024 07:41:06 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 ( '91327' , '3144' , 'CROCE TRILOBATA ' , '2' , '-2' , '1' , '4.5000' , '3.6885245901639' , '22' , '0' , '9.00' ) 17/05/2024 07:41:06 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 ( '91327' , '1331' , 'BRACCIALE LEGNO BICOLORE - 034CYB499' , '145' , '-145' , '1' , '0.5' , '0.40983606557377' , '22' , '0' , '72.50' ) 17/05/2024 07:49:16 pm >> SELECT document_num FROM ps_document WHERE document_num = '1654' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-17') 17/05/2024 07:49:16 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' , '1654' , '2024-05-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.00' , '4.92' , NOW() , NOW() ) 17/05/2024 07:49:16 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 = '91886' 17/05/2024 07:49:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '91886' 17/05/2024 07:49:16 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 ( '91886' , '20062' , 'BRACCIALE DECINA - BD018' , '3' , '-3' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '6.00' )