11/05/2023 09:08:57 am >> SELECT document_num FROM ps_document WHERE document_num = '1603' AND id_document != '84264' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-10') 11/05/2023 09:08:57 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1603', document_date = '2023-05-10', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = 'P.ZZA S. MICHELE 84135 RUFOLI', 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 = '79.00', price_tax_excluded = '75.32', date_upd = NOW() WHERE id_document = '84264' 11/05/2023 09:08:57 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 = '84264' 11/05/2023 09:08:57 am >> DELETE FROM ps_document_detail WHERE id_document = '84264' 11/05/2023 09:08:57 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 ( '84264' , '20630' , 'NIENTALTRO CHE LA VERITA - G. GANSWEIN' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '5' , '19.00' ) 11/05/2023 09:08:57 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 ( '84264' , '17702' , 'BENEDETTO XVI - P. SEEWALD' , '1' , '-1' , '4' , '40.0000' , '40' , '0' , '5' , '38.00' ) 11/05/2023 09:08:57 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 ( '84264' , '7915' , 'PERGAMENE - 1A COMUNIONE MOD. D' , '40' , '-40' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '20.00' ) 11/05/2023 09:08:57 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 ( '84264' , '16689' , 'OSTIA PAN DI CENA mm80' , '1' , '-1' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '2.00' ) 11/05/2023 09:10:02 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 11/05/2023 09:10:02 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21062' , '1' , '' , 'nuovo-prodotto' ) 11/05/2023 09:10:02 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '21062' , '1' , '1' , '2' , NOW() , NOW() ) 11/05/2023 09:10:02 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '21062' , '0' , '1' , '0' , '0' ) 11/05/2023 09:11:33 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788894984132' AND id_product != '21062' AND ean13 != '' 11/05/2023 09:11:33 am >> UPDATE ps_product SET id_supplier = '', reference = '5/5', ean13 = '9788894984132', date_upd = NOW() WHERE id_product = '21062' 11/05/2023 09:11:33 am >> UPDATE ps_product_lang SET name = 'MIO PARROCO NON E\' COME GLI ALTRI! - CAVADI/GENCO', description = '' WHERE id_product = '21062' 11/05/2023 09:11:33 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '9.9' WHERE id_product = '21062' 11/05/2023 09:11:33 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '9.9', id_tax_rules_group = '4', id_category_default = '286', id_argoment_default = '40', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21062' 11/05/2023 09:11:33 am >> DELETE FROM ps_specific_price WHERE id_product = '21062' 11/05/2023 09:11:34 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 = '21062' 11/05/2023 09:11:34 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21063' , '1' , '' , 'nuovo-prodotto' ) 11/05/2023 09:11:34 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 '21063' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21062' 11/05/2023 09:11:34 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21063' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21062' 11/05/2023 09:13:39 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791259752635' AND id_product != '21063' AND ean13 != '' 11/05/2023 09:13:39 am >> UPDATE ps_product SET id_supplier = '', reference = '6/4', ean13 = '9791259752635', date_upd = NOW() WHERE id_product = '21063' 11/05/2023 09:13:39 am >> UPDATE ps_product_lang SET name = 'MATTEO FARINA - G. CISTERNINO', description = '' WHERE id_product = '21063' 11/05/2023 09:13:39 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '12' WHERE id_product = '21063' 11/05/2023 09:13:39 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '12', id_tax_rules_group = '4', id_category_default = '267', id_argoment_default = '53', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21063' 11/05/2023 09:13:39 am >> DELETE FROM ps_specific_price WHERE id_product = '21063' 11/05/2023 09:13:40 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 = '21063' 11/05/2023 09:13:40 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21064' , '1' , '' , 'nuovo-prodotto' ) 11/05/2023 09:13:40 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 '21064' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21063' 11/05/2023 09:13:40 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21064' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21063' 11/05/2023 09:15:35 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791259752529' AND id_product != '21064' AND ean13 != '' 11/05/2023 09:15:35 am >> UPDATE ps_product SET id_supplier = '', reference = '11/7', ean13 = '9791259752529', date_upd = NOW() WHERE id_product = '21064' 11/05/2023 09:15:35 am >> UPDATE ps_product_lang SET name = 'COME SIGILLO SUL TUO CUORE - S. TARDIO', description = '' WHERE id_product = '21064' 11/05/2023 09:15:35 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '16' WHERE id_product = '21064' 11/05/2023 09:15:35 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '16', id_tax_rules_group = '4', id_category_default = '267', id_argoment_default = '16', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21064' 11/05/2023 09:15:35 am >> DELETE FROM ps_specific_price WHERE id_product = '21064' 11/05/2023 09:15:36 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 = '21064' 11/05/2023 09:15:36 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21065' , '1' , '' , 'nuovo-prodotto' ) 11/05/2023 09:15:36 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 '21065' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21064' 11/05/2023 09:15:36 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21065' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21064' 11/05/2023 09:16:59 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892241435' AND id_product != '21065' AND ean13 != '' 11/05/2023 09:16:59 am >> UPDATE ps_product SET id_supplier = '', reference = '11/2', ean13 = '9788892241435', date_upd = NOW() WHERE id_product = '21065' 11/05/2023 09:16:59 am >> UPDATE ps_product_lang SET name = 'BIBBIA - SCRUTATE LE SCRITTURE - BIANCA', description = '' WHERE id_product = '21065' 11/05/2023 09:16:59 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '39' WHERE id_product = '21065' 11/05/2023 09:16:59 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '39', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '170', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21065' 11/05/2023 09:16:59 am >> DELETE FROM ps_specific_price WHERE id_product = '21065' 11/05/2023 09:17:00 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 = '21065' 11/05/2023 09:17:00 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21066' , '1' , '' , 'nuovo-prodotto' ) 11/05/2023 09:17:00 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 '21066' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21065' 11/05/2023 09:17:00 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21066' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21065' 11/05/2023 09:18:53 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884247834' AND id_product != '21066' AND ean13 != '' 11/05/2023 09:18:53 am >> UPDATE ps_product SET id_supplier = '', reference = '13/7', ean13 = '9788884247834', date_upd = NOW() WHERE id_product = '21066' 11/05/2023 09:18:53 am >> UPDATE ps_product_lang SET name = 'STRADA PER LA FELICITA\' - F. SHEEN', description = '' WHERE id_product = '21066' 11/05/2023 09:18:53 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '14' WHERE id_product = '21066' 11/05/2023 09:18:53 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '14', id_tax_rules_group = '4', id_category_default = '83', id_argoment_default = '8', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21066' 11/05/2023 09:18:53 am >> DELETE FROM ps_specific_price WHERE id_product = '21066' 11/05/2023 09:20:03 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 11/05/2023 09:20:03 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21067' , '1' , '' , 'nuovo-prodotto' ) 11/05/2023 09:20:03 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '21067' , '1' , '1' , '2' , NOW() , NOW() ) 11/05/2023 09:20:03 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '21067' , '0' , '1' , '0' , '0' ) 11/05/2023 09:20:34 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892240483' AND id_product != '21067' AND ean13 != '' 11/05/2023 09:20:34 am >> UPDATE ps_product SET id_supplier = '', reference = '7/4', ean13 = '9788892240483', date_upd = NOW() WHERE id_product = '21067' 11/05/2023 09:20:34 am >> UPDATE ps_product_lang SET name = 'AMEN - AGO 2023', description = '' WHERE id_product = '21067' 11/05/2023 09:20:34 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3.9' WHERE id_product = '21067' 11/05/2023 09:20:34 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3.9', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '64', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21067' 11/05/2023 09:20:34 am >> DELETE FROM ps_specific_price WHERE id_product = '21067' 11/05/2023 09:20:36 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 = '21067' 11/05/2023 09:20:36 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21068' , '1' , '' , 'nuovo-prodotto' ) 11/05/2023 09:20:36 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 '21068' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21067' 11/05/2023 09:20:36 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21068' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21067' 11/05/2023 09:21:04 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791281253322' AND id_product != '21068' AND ean13 != '' 11/05/2023 09:21:04 am >> UPDATE ps_product SET id_supplier = '', reference = '7/4', ean13 = '9791281253322', date_upd = NOW() WHERE id_product = '21068' 11/05/2023 09:21:04 am >> UPDATE ps_product_lang SET name = 'MESSALINO AGO/SET/OTT 2023', description = '' WHERE id_product = '21068' 11/05/2023 09:21:04 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '6' WHERE id_product = '21068' 11/05/2023 09:21:05 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '6', id_tax_rules_group = '4', id_category_default = '518', id_argoment_default = '64', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21068' 11/05/2023 09:21:05 am >> DELETE FROM ps_specific_price WHERE id_product = '21068' 11/05/2023 09:22:03 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' , '630878' , '2023-05-08' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '5.12' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '180.40' , '180.40' , NOW() , NOW() ) 11/05/2023 09:22:03 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 = '84269' 11/05/2023 09:22:03 am >> DELETE FROM ps_document_detail WHERE id_document = '84269' 11/05/2023 09:22:03 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 ( '84269' , '21062' , 'MIO PARROCO NON E COME GLI ALTRI! - CAVADI/GENCO' , '1' , '1' , '4' , '9.90' , '9.9' , '0' , '33' , '6.6330' ) 11/05/2023 09:22:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '21062' AND id_supplier = '7' 11/05/2023 09:22:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21062' , '7' , '1' ) 11/05/2023 09:22:03 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 ( '84269' , '21063' , 'MATTEO FARINA - G. CISTERNINO' , '1' , '1' , '4' , '12.00' , '12' , '0' , '30' , '8.4000' ) 11/05/2023 09:22:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '21063' AND id_supplier = '7' 11/05/2023 09:22:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21063' , '7' , '1' ) 11/05/2023 09:22:03 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 ( '84269' , '21064' , 'COME SIGILLO SUL TUO CUORE - S. TARDIO' , '1' , '1' , '4' , '16.00' , '16' , '0' , '30' , '11.2000' ) 11/05/2023 09:22:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '21064' AND id_supplier = '7' 11/05/2023 09:22:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21064' , '7' , '1' ) 11/05/2023 09:22:03 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 ( '84269' , '21065' , 'BIBBIA - SCRUTATE LE SCRITTURE - BIANCA' , '1' , '1' , '4' , '39.00' , '39' , '0' , '33' , '26.1300' ) 11/05/2023 09:22:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '21065' AND id_supplier = '7' 11/05/2023 09:22:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21065' , '7' , '1' ) 11/05/2023 09:22:03 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 ( '84269' , '21066' , 'STRADA PER LA FELICITA - F. SHEEN' , '1' , '1' , '4' , '14.00' , '14' , '0' , '30' , '9.8000' ) 11/05/2023 09:22:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '21066' AND id_supplier = '7' 11/05/2023 09:22:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21066' , '7' , '1' ) 11/05/2023 09:22:03 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 ( '84269' , '21067' , 'AMEN - AGO 2023' , '24' , '24' , '4' , '3.90' , '3.9' , '0' , '33' , '62.7120' ) 11/05/2023 09:22:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '21067' AND id_supplier = '7' 11/05/2023 09:22:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21067' , '7' , '1' ) 11/05/2023 09:22:03 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 ( '84269' , '21067' , 'AMEN - AGO 2023' , '2' , '2' , '4' , '3.90' , '3.9' , '0' , '100' , '0.0000' ) 11/05/2023 09:22:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '21067' AND id_supplier = '7' 11/05/2023 09:22:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21067' , '7' , '1' ) 11/05/2023 09:22:03 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 ( '84269' , '21068' , 'MESSALINO AGO/SET/OTT 2023' , '12' , '12' , '4' , '6.00' , '6' , '0' , '30' , '50.4000' ) 11/05/2023 09:22:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '21068' AND id_supplier = '7' 11/05/2023 09:22:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21068' , '7' , '1' ) 11/05/2023 09:22:03 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 ( '84269' , '21068' , 'MESSALINO AGO/SET/OTT 2023' , '1' , '1' , '4' , '6.00' , '6' , '0' , '100' , '0.0000' ) 11/05/2023 09:22:04 am >> DELETE FROM ps_product_supplier WHERE id_product = '21068' AND id_supplier = '7' 11/05/2023 09:22:04 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21068' , '7' , '1' ) 11/05/2023 09:24:17 am >> SELECT document_num FROM ps_document WHERE document_num = '22/A' AND id_document != '81317' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-02-10') 11/05/2023 09:24:17 am >> UPDATE ps_document SET id_document_type = '24', document_num = '22/A', document_date = '2023-02-10', document_letter = 'A', id_customer = '206', id_supplier = '', id_address = '4671015', address1 = 'VIA N. BUONSERVIZI, 25 84135 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '15.70', price_tax_excluded = '15.70', date_upd = NOW() WHERE id_document = '81317' 11/05/2023 09:24:17 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81317' 11/05/2023 09:24:17 am >> DELETE FROM ps_document_detail WHERE id_document = '81317' 11/05/2023 09:24:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81317' , '20999' , 'AMEN - LUG 23' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 11/05/2023 09:24:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81317' , '21037' , 'SULLA TUA PAROLA LUG/AGO 2023' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '0' , '5.00' ) 11/05/2023 09:24:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81317' , '20998' , 'PAROLA E PREGHIERA - LUG. 23' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 11/05/2023 09:24:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81317' , '21067' , 'AMEN - AGO 2023' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '0' , '3.90' ) 11/05/2023 10:24:41 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 11/05/2023 10:24:41 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21069' , '1' , '' , 'nuovo-prodotto' ) 11/05/2023 10:24:41 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '21069' , '1' , '1' , '2' , NOW() , NOW() ) 11/05/2023 10:24:41 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '21069' , '0' , '1' , '0' , '0' ) 11/05/2023 10:25:39 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884047984' AND id_product != '21069' AND ean13 != '' 11/05/2023 10:25:39 am >> UPDATE ps_product SET id_supplier = '', reference = 'ESPOSITORE SHALOM', ean13 = '9788884047984', date_upd = NOW() WHERE id_product = '21069' 11/05/2023 10:25:39 am >> UPDATE ps_product_lang SET name = 'MARIA ROSA MISTICA - 8093', description = '' WHERE id_product = '21069' 11/05/2023 10:25:39 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3' WHERE id_product = '21069' 11/05/2023 10:25:39 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '28', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21069' 11/05/2023 10:25:39 am >> DELETE FROM ps_specific_price WHERE id_product = '21069' 11/05/2023 10:27: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 ( '31' , '8003/00/2023' , '2023-05-09' , '00' , '0' , '38' , '2633' , 'VIA GALVANI, 1 60020 CAMERATA PICENA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '124.20' , '124.20' , NOW() , NOW() ) 11/05/2023 10:27: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 = '84270' 11/05/2023 10:27:16 am >> DELETE FROM ps_document_detail WHERE id_document = '84270' 11/05/2023 10:27: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 ( '84270' , '21037' , 'SULLA TUA PAROLA LUG/AGO 2023' , '25' , '25' , '4' , '5.00' , '5' , '0' , '40' , '75.0000' ) 11/05/2023 10:27:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '21037' AND id_supplier = '38' 11/05/2023 10:27:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21037' , '38' , '1' ) 11/05/2023 10:27: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 ( '84270' , '21069' , 'MARIA ROSA MISTICA - 8093' , '3' , '3' , '4' , '3.00' , '3' , '0' , '40' , '5.4000' ) 11/05/2023 10:27:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '21069' AND id_supplier = '38' 11/05/2023 10:27:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21069' , '38' , '1' ) 11/05/2023 10:27: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 ( '84270' , '6417' , 'MESE DI MAGGIO CON LE GLORIE DI MARIA - 8463' , '1' , '1' , '4' , '9.00' , '9' , '0' , '40' , '5.4000' ) 11/05/2023 10:27:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '6417' AND id_supplier = '38' 11/05/2023 10:27:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6417' , '38' , '1' ) 11/05/2023 10:27: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 ( '84270' , '13830' , 'VANGELO E ATTI - ECOPELLE BIANCA - 8592' , '16' , '16' , '4' , '4.00' , '4' , '0' , '40' , '38.4000' ) 11/05/2023 10:27:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '13830' AND id_supplier = '38' 11/05/2023 10:27:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13830' , '38' , '1' ) 11/05/2023 10:38:40 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884047984' AND id_product != '21069' AND ean13 != '' 11/05/2023 10:38:40 am >> UPDATE ps_product SET id_supplier = '', reference = 'ESPOSITORE SHALOM', ean13 = '9788884047984', date_upd = NOW() WHERE id_product = '21069' 11/05/2023 10:38:40 am >> UPDATE ps_product_lang SET name = 'MARIA ROSA MISTICA - 8093', description = '' WHERE id_product = '21069' 11/05/2023 10:38:40 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3' WHERE id_product = '21069' 11/05/2023 10:38:40 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '28', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21069' 11/05/2023 10:38:40 am >> DELETE FROM ps_specific_price WHERE id_product = '21069' 11/05/2023 10:40:09 am >> SELECT document_num FROM ps_document WHERE document_num = '1608' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-11') 11/05/2023 10:40:09 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1608' , '2023-05-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '410.00' , '410.00' , NOW() , NOW() ) 11/05/2023 10:40:09 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84271' 11/05/2023 10:40:09 am >> DELETE FROM ps_document_detail WHERE id_document = '84271' 11/05/2023 10:40:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84271' , '' , 'TUNICA PRIMA COMUNIONE' , '8' , '-8' , '0' , '45' , '45' , '' , '0' , '360.00' ) 11/05/2023 10:40:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84271' , '' , 'TUNICA PRIMA COMUNIONE' , '1' , '-1' , '0' , '50' , '50' , '' , '0' , '50.00' ) 11/05/2023 10:40:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84271' , '' , 'CINGOLI ' , '9' , '-9' , '0' , '0' , '0' , '' , '0' , '0.00' ) 11/05/2023 10:40:28 am >> DELETE FROM ps_document WHERE id_document = '84271' 11/05/2023 10:40:28 am >> DELETE FROM ps_document_detail WHERE id_document = '84271' 11/05/2023 11:01:11 am >> SELECT document_num FROM ps_document WHERE document_num = '1608' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-11') 11/05/2023 11:01:11 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1608' , '2023-05-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '575.00' , '493.58' , NOW() , NOW() ) 11/05/2023 11:01:11 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84272' 11/05/2023 11:01:11 am >> DELETE FROM ps_document_detail WHERE id_document = '84272' 11/05/2023 11:01:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84272' , '13751' , 'TUNICA SVASATA AVORIO - 191 TPA' , '9' , '-9' , '1' , '40' , '32.786885245902' , '22' , '0' , '360.00' ) 11/05/2023 11:01:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84272' , '17330' , 'MESSALE ROMANO D\'ALTARE N. E. TAGLIO ORO' , '1' , '-1' , '4' , '130.00' , '130' , '0' , '5' , '123.50' ) 11/05/2023 11:01:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84272' , '547' , 'AMPOLLINE E VASSOIO IN VETRO - 506' , '1' , '-1' , '1' , '30' , '24.590163934426' , '22' , '0' , '30.00' ) 11/05/2023 11:01:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84272' , '778' , 'ASPERGES CON VASETTO O. S. - 1700 ' , '1' , '-1' , '1' , '61.5' , '50.409836065574' , '22' , '0' , '61.50' ) 11/05/2023 11:35:22 am >> SELECT document_num FROM ps_document WHERE document_num = '61/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-05-11') 11/05/2023 11:35:22 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 ( '24' , '61/A' , '2023-05-11' , 'A' , '949' , '0' , '4671033' , 'VIA P. PALMIERI, 39 10138 TORINO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '84.00' , '84.00' , NOW() , NOW() ) 11/05/2023 11:35:22 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 = '84273' 11/05/2023 11:35:22 am >> DELETE FROM ps_document_detail WHERE id_document = '84273' 11/05/2023 11:35:22 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 ( '84273' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '30' , '-30' , '4' , '2.80' , '2.8' , '0' , '0' , '84.00' ) 11/05/2023 11:39:31 am >> SELECT document_num FROM ps_document WHERE document_num = '58/A' AND id_document != '84077' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-05-02') 11/05/2023 11:39:31 am >> UPDATE ps_document SET id_document_type = '24', document_num = '58/A', document_date = '2023-05-02', document_letter = 'A', id_customer = '204', id_supplier = '', id_address = '4671483', address1 = 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO', address2 = '', note = 'cappellania SAN LEONARDO', 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 = '95.56', price_tax_excluded = '92.86', date_upd = NOW() WHERE id_document = '84077' 11/05/2023 11:39:31 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 = '84077' 11/05/2023 11:39:31 am >> DELETE FROM ps_document_detail WHERE id_document = '84077' 11/05/2023 11:39:31 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 ( '84077' , '20766' , 'AMEN - GIU 23' , '5' , '-5' , '4' , '3.9000' , '3.9' , '0' , '5' , '18.52' ) 11/05/2023 11:39:31 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 ( '84077' , '20765' , 'AMEN - MAG 23' , '5' , '-5' , '4' , '3.9000' , '3.9' , '0' , '5' , '18.52' ) 11/05/2023 11:39:31 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 ( '84077' , '20999' , 'AMEN - LUG 23' , '5' , '-5' , '4' , '3.9000' , '3.9' , '0' , '5' , '18.52' ) 11/05/2023 11:39:31 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 ( '84077' , '0' , 'SUPPLICA' , '2' , '-2' , '0' , '10.0000' , '10' , '0' , '0' , '20.00' ) 11/05/2023 11:39:31 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 ( '84077' , '13103' , 'BRACCIALE BAMBOO - CY B 774' , '15' , '-15' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '15.00' ) 11/05/2023 11:39:31 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 ( '84077' , '2448' , 'COLUI IN CUI CREDO' , '2' , '-2' , '4' , '2.50' , '2.5' , '0' , '0' , '5.00' ) 11/05/2023 11:48:19 am >> SELECT document_num FROM ps_document WHERE document_num = '55/A' AND id_document != '82940' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-04-22') 11/05/2023 11:48:19 am >> UPDATE ps_document SET id_document_type = '24', document_num = '55/A', document_date = '2023-04-22', document_letter = 'A', id_customer = '371', id_supplier = '', id_address = '4670910', address1 = 'VIA PIAVE, 4 84080 CASTEL SAN GIORGIO', address2 = '', note = 'PER COMUNIONI', 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 = '87.50', price_tax_excluded = '83.98', date_upd = NOW() WHERE id_document = '82940' 11/05/2023 11:48:19 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 = '82940' 11/05/2023 11:48:19 am >> DELETE FROM ps_document_detail WHERE id_document = '82940' 11/05/2023 11:48:19 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 ( '82940' , '3073' , 'CROCE PRIMA COMUNIONE - LEGNO SCURO - 713/15' , '15' , '-15' , '1' , '1.3000' , '1.0655737704918' , '22' , '0' , '19.50' ) 11/05/2023 11:48:19 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 ( '82940' , '' , 'FATIMA - LOTTERIA' , '1' , '-1' , '0' , '68' , '68' , '' , '0' , '68.00' ) 11/05/2023 12:11:30 pm >> SELECT document_num FROM ps_document WHERE document_num = '1609' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-11') 11/05/2023 12:11:30 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1609' , '2023-05-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.50' , '2.05' , NOW() , NOW() ) 11/05/2023 12:11:30 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84274' 11/05/2023 12:11:30 pm >> DELETE FROM ps_document_detail WHERE id_document = '84274' 11/05/2023 12:11:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84274' , '15481' , 'CROCE IHS - 2389/CZ' , '1' , '-1' , '1' , '2.50' , '2.0491803278689' , '22' , '0' , '2.50' ) 11/05/2023 02:56:29 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '2620/00' , '2023-05-10' , '00' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , 'RIENTRO - V. E.' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '560.00' , '560.00' , NOW() , NOW() ) 11/05/2023 02:56:29 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '11071' 11/05/2023 02:56:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '11071' 11/05/2023 02:56:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11071' , '89' , 'COMUNIONE SPIEGATA AI RAGAZZI' , '28' , '28' , '4' , '1.5' , '1.5' , '0' , '0' , '42.0000' ) 11/05/2023 02:56:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11071' , '17' , 'LA FEDE NELLO ZAINETTO' , '3' , '3' , '4' , '5' , '5' , '0' , '0' , '15.0000' ) 11/05/2023 02:56:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11071' , '50' , 'PERDONAMI SIGNORE' , '127' , '127' , '4' , '2' , '2' , '0' , '0' , '254.0000' ) 11/05/2023 02:56:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11071' , '110' , 'SE MI AMI NON PIANGERE' , '166' , '166' , '4' , '1.5' , '1.5' , '0' , '0' , '249.0000' ) 11/05/2023 03:01:03 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 11/05/2023 03:01:03 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21070' , '1' , '' , 'nuovo-prodotto' ) 11/05/2023 03:01:04 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '21070' , '1' , '1' , '2' , NOW() , NOW() ) 11/05/2023 03:01:04 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '21070' , '0' , '1' , '0' , '0' ) 11/05/2023 03:02:22 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788832235524' AND id_product != '21070' AND ean13 != '' 11/05/2023 03:02:22 pm >> UPDATE ps_product SET id_supplier = '', reference = 'GONDOLA 1', ean13 = '9788832235524', date_upd = NOW() WHERE id_product = '21070' 11/05/2023 03:02:22 pm >> UPDATE ps_product_lang SET name = 'A GESU\' CON FRANCESCO E C. ACUTIS - FERREIRA/CALVARESE', description = '' WHERE id_product = '21070' 11/05/2023 03:02:22 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3.5' WHERE id_product = '21070' 11/05/2023 03:02:22 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3.5', id_tax_rules_group = '4', id_category_default = '472', id_argoment_default = '23', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21070' 11/05/2023 03:02:22 pm >> DELETE FROM ps_specific_price WHERE id_product = '21070' 11/05/2023 03:02:23 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 = '21070' 11/05/2023 03:02:23 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21071' , '1' , '' , 'nuovo-prodotto' ) 11/05/2023 03:02:23 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 '21071' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21070' 11/05/2023 03:02:23 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21071' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21070' 11/05/2023 03:03:33 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788873576471' AND id_product != '21071' AND ean13 != '' 11/05/2023 03:03:34 pm >> UPDATE ps_product SET id_supplier = '', reference = '6/2', ean13 = '9788873576471', date_upd = NOW() WHERE id_product = '21071' 11/05/2023 03:03:34 pm >> UPDATE ps_product_lang SET name = 'SANT\'IGNAZIO DI LOYOLA AUTOBIOGRAFIA', description = '' WHERE id_product = '21071' 11/05/2023 03:03:34 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '5' WHERE id_product = '21071' 11/05/2023 03:03:34 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '5', id_tax_rules_group = '4', id_category_default = '178', id_argoment_default = '333', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21071' 11/05/2023 03:03:34 pm >> DELETE FROM ps_specific_price WHERE id_product = '21071' 11/05/2023 03:03:35 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 = '21071' 11/05/2023 03:03:35 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21072' , '1' , '' , 'nuovo-prodotto' ) 11/05/2023 03:03:35 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 '21072' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21071' 11/05/2023 03:03:35 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21072' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21071' 11/05/2023 03:04:43 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788830818828' AND id_product != '21072' AND ean13 != '' 11/05/2023 03:04:43 pm >> UPDATE ps_product SET id_supplier = '', reference = '7/5', ean13 = '9788830818828', date_upd = NOW() WHERE id_product = '21072' 11/05/2023 03:04:43 pm >> UPDATE ps_product_lang SET name = 'INSEGNACI A PREGARE - A. BARBI', description = '' WHERE id_product = '21072' 11/05/2023 03:04:43 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '22.9' WHERE id_product = '21072' 11/05/2023 03:04:43 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '22.9', id_tax_rules_group = '4', id_category_default = '11', id_argoment_default = '188', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21072' 11/05/2023 03:04:43 pm >> DELETE FROM ps_specific_price WHERE id_product = '21072' 11/05/2023 03:04:44 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 = '21072' 11/05/2023 03:04:44 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21073' , '1' , '' , 'nuovo-prodotto' ) 11/05/2023 03:04:44 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 '21073' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21072' 11/05/2023 03:04:44 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21073' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21072' 11/05/2023 03:06:09 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788830818804' AND id_product != '21073' AND ean13 != '' 11/05/2023 03:06:10 pm >> UPDATE ps_product SET id_supplier = '', reference = '11/7', ean13 = '9788830818804', date_upd = NOW() WHERE id_product = '21073' 11/05/2023 03:06:10 pm >> UPDATE ps_product_lang SET name = 'SUI PASSI DI ELIA - M. CROCIATA', description = '' WHERE id_product = '21073' 11/05/2023 03:06:10 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '14.5' WHERE id_product = '21073' 11/05/2023 03:06:10 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '14.5', id_tax_rules_group = '4', id_category_default = '11', id_argoment_default = '16', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21073' 11/05/2023 03:06:10 pm >> DELETE FROM ps_specific_price WHERE id_product = '21073' 11/05/2023 03:06:11 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 = '21073' 11/05/2023 03:06:11 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21074' , '1' , '' , 'nuovo-prodotto' ) 11/05/2023 03:06:11 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 '21074' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21073' 11/05/2023 03:06:11 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21074' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21073' 11/05/2023 03:07:11 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791254821176' AND id_product != '21074' AND ean13 != '' 11/05/2023 03:07:11 pm >> UPDATE ps_product SET id_supplier = '', reference = '13/7', ean13 = '9791254821176', date_upd = NOW() WHERE id_product = '21074' 11/05/2023 03:07:11 pm >> UPDATE ps_product_lang SET name = 'SACERDOZIO MINISTERIALE E VITA ', description = '' WHERE id_product = '21074' 11/05/2023 03:07:11 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '30' WHERE id_product = '21074' 11/05/2023 03:07:11 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '30', id_tax_rules_group = '4', id_category_default = '272', id_argoment_default = '65', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21074' 11/05/2023 03:07:11 pm >> DELETE FROM ps_specific_price WHERE id_product = '21074' 11/05/2023 03:07:13 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 = '21074' 11/05/2023 03:07:13 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21075' , '1' , '' , 'nuovo-prodotto' ) 11/05/2023 03:07:13 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 '21075' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21074' 11/05/2023 03:07:13 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21075' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21074' 11/05/2023 03:08:15 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791254821268' AND id_product != '21075' AND ean13 != '' 11/05/2023 03:08:15 pm >> UPDATE ps_product SET id_supplier = '', reference = '13/7', ean13 = '9791254821268', date_upd = NOW() WHERE id_product = '21075' 11/05/2023 03:08:15 pm >> UPDATE ps_product_lang SET name = 'ECCLESIOLOGIA DI J. RATZINGER', description = '' WHERE id_product = '21075' 11/05/2023 03:08:15 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '18' WHERE id_product = '21075' 11/05/2023 03:08:15 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '18', id_tax_rules_group = '4', id_category_default = '272', id_argoment_default = '349', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21075' 11/05/2023 03:08:15 pm >> DELETE FROM ps_specific_price WHERE id_product = '21075' 11/05/2023 03:08: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 = '21075' 11/05/2023 03:08:16 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21076' , '1' , '' , 'nuovo-prodotto' ) 11/05/2023 03:08: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 '21076' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21075' 11/05/2023 03:08:16 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21076' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21075' 11/05/2023 03:09:18 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788821315589' AND id_product != '21076' AND ean13 != '' 11/05/2023 03:09:18 pm >> UPDATE ps_product SET id_supplier = '', reference = '1/2', ean13 = '9788821315589', date_upd = NOW() WHERE id_product = '21076' 11/05/2023 03:09:18 pm >> UPDATE ps_product_lang SET name = 'RACCONTARE LA FEDE AI GIOVANI ', description = '' WHERE id_product = '21076' 11/05/2023 03:09:18 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '15' WHERE id_product = '21076' 11/05/2023 03:09:18 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '15', id_tax_rules_group = '4', id_category_default = '87', id_argoment_default = '22', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21076' 11/05/2023 03:09:18 pm >> DELETE FROM ps_specific_price WHERE id_product = '21076' 11/05/2023 03:09:19 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 = '21076' 11/05/2023 03:09:19 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21077' , '1' , '' , 'nuovo-prodotto' ) 11/05/2023 03:09:19 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 '21077' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21076' 11/05/2023 03:09:19 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21077' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21076' 11/05/2023 03:10:48 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9783907227121' AND id_product != '21077' AND ean13 != '' 11/05/2023 03:10:48 pm >> UPDATE ps_product SET id_supplier = '', reference = '7/5', ean13 = '9783907227121', date_upd = NOW() WHERE id_product = '21077' 11/05/2023 03:10:48 pm >> UPDATE ps_product_lang SET name = 'ROSARIO UN VIAGGIO CHE CAMBIA LA VITA - SUOR E. MAILLARD', description = '' WHERE id_product = '21077' 11/05/2023 03:10:48 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '12' WHERE id_product = '21077' 11/05/2023 03:10:48 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '12', id_tax_rules_group = '4', id_category_default = '426', id_argoment_default = '188', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21077' 11/05/2023 03:10:48 pm >> DELETE FROM ps_specific_price WHERE id_product = '21077' 11/05/2023 03:10:49 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 = '21077' 11/05/2023 03:10:49 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21078' , '1' , '' , 'nuovo-prodotto' ) 11/05/2023 03:10:49 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 '21078' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21077' 11/05/2023 03:10:49 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21078' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21077' 11/05/2023 03:11:47 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9783907227107' AND id_product != '21078' AND ean13 != '' 11/05/2023 03:11:47 pm >> UPDATE ps_product SET id_supplier = '', reference = '7/2', ean13 = '9783907227107', date_upd = NOW() WHERE id_product = '21078' 11/05/2023 03:11:47 pm >> UPDATE ps_product_lang SET name = 'VITA DI SUOR MARGHERITA - L. DE CISSEY', description = '' WHERE id_product = '21078' 11/05/2023 03:11:47 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '15.9' WHERE id_product = '21078' 11/05/2023 03:11:47 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '15.9', id_tax_rules_group = '4', id_category_default = '426', id_argoment_default = '71', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21078' 11/05/2023 03:11:47 pm >> DELETE FROM ps_specific_price WHERE id_product = '21078' 11/05/2023 03:11:48 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 = '21078' 11/05/2023 03:11:48 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21079' , '1' , '' , 'nuovo-prodotto' ) 11/05/2023 03:11:48 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 '21079' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21078' 11/05/2023 03:11:48 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21079' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21078' 11/05/2023 03:13:01 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788852607493' AND id_product != '21079' AND ean13 != '' 11/05/2023 03:13:01 pm >> UPDATE ps_product SET id_supplier = '', reference = '13/3', ean13 = '9788852607493', date_upd = NOW() WHERE id_product = '21079' 11/05/2023 03:13:01 pm >> UPDATE ps_product_lang SET name = 'RALLEGRATI IL SIGNORE E\' QUI - MADRE M. DELL\'ANNUNCIAZIONE', description = '' WHERE id_product = '21079' 11/05/2023 03:13:01 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '5' WHERE id_product = '21079' 11/05/2023 03:13:01 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '5', id_tax_rules_group = '4', id_category_default = '285', id_argoment_default = '28', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21079' 11/05/2023 03:13:01 pm >> DELETE FROM ps_specific_price WHERE id_product = '21079' 11/05/2023 03:13:01 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 = '21079' 11/05/2023 03:13:02 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21080' , '1' , '' , 'nuovo-prodotto' ) 11/05/2023 03:13:02 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 '21080' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21079' 11/05/2023 03:13:02 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21080' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21079' 11/05/2023 03:13:38 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '2023000002621' , '2023-05-10' , '' , '0' , '107' , '4669100' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '6' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '103.70' , '103.70' , NOW() , NOW() ) 11/05/2023 03:13:38 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84275' 11/05/2023 03:13:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '84275' 11/05/2023 03:13:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84275' , '21070' , 'A GESU CON FRANCESCO E C. ACUTIS - FERREIRA/CALVARESE' , '2' , '2' , '4' , '3.50' , '3.5' , '0' , '35' , '4.5500' ) 11/05/2023 03:13:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21070' AND id_supplier = '107' 11/05/2023 03:13:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21070' , '107' , '1' ) 11/05/2023 03:13:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84275' , '21071' , 'SANTIGNAZIO DI LOYOLA AUTOBIOGRAFIA' , '1' , '1' , '4' , '5.00' , '5' , '0' , '35' , '3.2500' ) 11/05/2023 03:13:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21071' AND id_supplier = '107' 11/05/2023 03:13:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21071' , '107' , '1' ) 11/05/2023 03:13:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84275' , '21072' , 'INSEGNACI A PREGARE - A. BARBI' , '1' , '1' , '4' , '22.90' , '22.9' , '0' , '35' , '14.8850' ) 11/05/2023 03:13:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21072' AND id_supplier = '107' 11/05/2023 03:13:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21072' , '107' , '1' ) 11/05/2023 03:13:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84275' , '21073' , 'SUI PASSI DI ELIA - M. CROCIATA' , '1' , '1' , '4' , '14.50' , '14.5' , '0' , '35' , '9.4250' ) 11/05/2023 03:13:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21073' AND id_supplier = '107' 11/05/2023 03:13:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21073' , '107' , '1' ) 11/05/2023 03:13:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84275' , '21074' , 'SACERDOZIO MINISTERIALE E VITA ' , '1' , '1' , '4' , '30.00' , '30' , '0' , '35' , '19.5000' ) 11/05/2023 03:13:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21074' AND id_supplier = '107' 11/05/2023 03:13:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21074' , '107' , '1' ) 11/05/2023 03:13:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84275' , '21075' , 'ECCLESIOLOGIA DI J. RATZINGER' , '1' , '1' , '4' , '18.00' , '18' , '0' , '35' , '11.7000' ) 11/05/2023 03:13:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21075' AND id_supplier = '107' 11/05/2023 03:13:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21075' , '107' , '1' ) 11/05/2023 03:13:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84275' , '21076' , 'RACCONTARE LA FEDE AI GIOVANI ' , '1' , '1' , '4' , '15.00' , '15' , '0' , '35' , '9.7500' ) 11/05/2023 03:13:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21076' AND id_supplier = '107' 11/05/2023 03:13:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21076' , '107' , '1' ) 11/05/2023 03:13:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84275' , '21077' , 'ROSARIO UN VIAGGIO CHE CAMBIA LA VITA - SUOR E. MAILLARD' , '1' , '1' , '4' , '12.00' , '12' , '0' , '35' , '7.8000' ) 11/05/2023 03:13:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21077' AND id_supplier = '107' 11/05/2023 03:13:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21077' , '107' , '1' ) 11/05/2023 03:13:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84275' , '21078' , 'VITA DI SUOR MARGHERITA - L. DE CISSEY' , '1' , '1' , '4' , '15.90' , '15.9' , '0' , '35' , '10.3350' ) 11/05/2023 03:13:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21078' AND id_supplier = '107' 11/05/2023 03:13:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21078' , '107' , '1' ) 11/05/2023 03:13:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84275' , '21079' , 'RALLEGRATI IL SIGNORE E QUI - MADRE M. DELLANNUNCIAZIONE' , '2' , '2' , '4' , '5.00' , '5' , '0' , '35' , '6.5000' ) 11/05/2023 03:13:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21079' AND id_supplier = '107' 11/05/2023 03:13:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21079' , '107' , '1' ) 11/05/2023 03:27:54 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '1936/CAV' AND id_product != '20078' AND ean13 != '' 11/05/2023 03:27:54 pm >> UPDATE ps_product SET id_supplier = '113', reference = '', ean13 = '1936/CAV', date_upd = NOW() WHERE id_product = '20078' 11/05/2023 03:27:54 pm >> UPDATE ps_product_lang SET name = 'ROSARIO ARGENTO', description = '' WHERE id_product = '20078' 11/05/2023 03:27:55 pm >> UPDATE ps_product SET wholesale_price = '18.91', on_sale = '0', price = '42.622950819672134' WHERE id_product = '20078' 11/05/2023 03:27:55 pm >> UPDATE ps_product_shop SET wholesale_price = '18.91', price = '42.622950819672134', id_tax_rules_group = '1', id_category_default = '421', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20078' 11/05/2023 03:27:55 pm >> DELETE FROM ps_specific_price WHERE id_product = '20078' 11/05/2023 03:28:18 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '1936/CAV' AND id_product != '20078' AND ean13 != '' 11/05/2023 03:28:18 pm >> UPDATE ps_product SET id_supplier = '113', reference = '', ean13 = '1936/CAV', date_upd = NOW() WHERE id_product = '20078' 11/05/2023 03:28:18 pm >> UPDATE ps_product_lang SET name = 'ROSARIO ARGENTO', description = '' WHERE id_product = '20078' 11/05/2023 03:28:18 pm >> UPDATE ps_product SET wholesale_price = '18.91', on_sale = '0', price = '42.622950819672134' WHERE id_product = '20078' 11/05/2023 03:28:18 pm >> UPDATE ps_product_shop SET wholesale_price = '18.91', price = '42.622950819672134', id_tax_rules_group = '1', id_category_default = '421', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20078' 11/05/2023 03:28:18 pm >> DELETE FROM ps_specific_price WHERE id_product = '20078' 11/05/2023 03:29:57 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '328/CAV' AND id_product != '21080' AND ean13 != '' 11/05/2023 03:29:57 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '328/CAV', date_upd = NOW() WHERE id_product = '21080' 11/05/2023 03:29:57 pm >> UPDATE ps_product_lang SET name = 'ROSARIO ARG. MADREPERLA - 328CAV', description = '' WHERE id_product = '21080' 11/05/2023 03:29:57 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '28.278688524590166' WHERE id_product = '21080' 11/05/2023 03:29:57 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '28.278688524590166', id_tax_rules_group = '1', id_category_default = '421', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21080' 11/05/2023 03:29:57 pm >> DELETE FROM ps_specific_price WHERE id_product = '21080' 11/05/2023 03:31:11 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '1826RA' AND id_product != '20076' AND ean13 != '' 11/05/2023 03:31:11 pm >> UPDATE ps_product SET id_supplier = '113', reference = '', ean13 = '1826RA', date_upd = NOW() WHERE id_product = '20076' 11/05/2023 03:31:11 pm >> UPDATE ps_product_lang SET name = 'ROSARIO ARGENTO/QUARZO', description = '' WHERE id_product = '20076' 11/05/2023 03:31:11 pm >> UPDATE ps_product SET wholesale_price = '19.00', on_sale = '0', price = '47.540983606557376' WHERE id_product = '20076' 11/05/2023 03:31:11 pm >> UPDATE ps_product_shop SET wholesale_price = '19.00', price = '47.540983606557376', id_tax_rules_group = '1', id_category_default = '421', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20076' 11/05/2023 03:31:11 pm >> DELETE FROM ps_specific_price WHERE id_product = '20076' 11/05/2023 03:31:30 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '1826RA' AND id_product != '20076' AND ean13 != '' 11/05/2023 03:31:30 pm >> UPDATE ps_product SET id_supplier = '113', reference = '', ean13 = '1826RA', date_upd = NOW() WHERE id_product = '20076' 11/05/2023 03:31:30 pm >> UPDATE ps_product_lang SET name = 'ROSARIO ARGENTO/QUARZO', description = '' WHERE id_product = '20076' 11/05/2023 03:31:30 pm >> UPDATE ps_product SET wholesale_price = '19.00', on_sale = '0', price = '47.540983606557376' WHERE id_product = '20076' 11/05/2023 03:31:30 pm >> UPDATE ps_product_shop SET wholesale_price = '19.00', price = '47.540983606557376', id_tax_rules_group = '1', id_category_default = '421', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20076' 11/05/2023 03:31:30 pm >> DELETE FROM ps_specific_price WHERE id_product = '20076' 11/05/2023 03:31:41 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '328/CAV' AND id_product != '21080' AND ean13 != '' 11/05/2023 03:31:41 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '328/CAV', date_upd = NOW() WHERE id_product = '21080' 11/05/2023 03:31:41 pm >> UPDATE ps_product_lang SET name = 'ROSARIO ARG. MADREPERLA - 328CAV', description = '' WHERE id_product = '21080' 11/05/2023 03:31:41 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '28.278688524590166' WHERE id_product = '21080' 11/05/2023 03:31:41 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '28.278688524590166', id_tax_rules_group = '1', id_category_default = '421', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21080' 11/05/2023 03:31:41 pm >> DELETE FROM ps_specific_price WHERE id_product = '21080' 11/05/2023 03:31: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 = '21080' 11/05/2023 03:31:42 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21081' , '1' , '' , 'nuovo-prodotto' ) 11/05/2023 03:31: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 '21081' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21080' 11/05/2023 03:31:42 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21081' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21080' 11/05/2023 03:32:47 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '1300/CAV' AND id_product != '21081' AND ean13 != '' 11/05/2023 03:32:47 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '1300/CAV', date_upd = NOW() WHERE id_product = '21081' 11/05/2023 03:32:47 pm >> UPDATE ps_product_lang SET name = 'ROSARGIO ARG. EMATITE - 1300CAV', description = '' WHERE id_product = '21081' 11/05/2023 03:32:47 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '32.704918032786885' WHERE id_product = '21081' 11/05/2023 03:32:47 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '32.704918032786885', id_tax_rules_group = '1', id_category_default = '421', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21081' 11/05/2023 03:32:47 pm >> DELETE FROM ps_specific_price WHERE id_product = '21081' 11/05/2023 03:32:50 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 = '21081' 11/05/2023 03:32:50 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21082' , '1' , '' , 'nuovo-prodotto' ) 11/05/2023 03:32:50 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 '21082' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21081' 11/05/2023 03:32:50 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21082' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21081' 11/05/2023 03:33:41 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '1497/CAV' AND id_product != '20075' AND ean13 != '' 11/05/2023 03:33:41 pm >> UPDATE ps_product SET id_supplier = '113', reference = '', ean13 = '1497/CAV', date_upd = NOW() WHERE id_product = '20075' 11/05/2023 03:33:41 pm >> UPDATE ps_product_lang SET name = 'ROSARIO ARGENTO/EMATITE', description = '' WHERE id_product = '20075' 11/05/2023 03:33:41 pm >> UPDATE ps_product SET wholesale_price = '14.63', on_sale = '0', price = '34.42622950819672' WHERE id_product = '20075' 11/05/2023 03:33:41 pm >> UPDATE ps_product_shop SET wholesale_price = '14.63', price = '34.42622950819672', id_tax_rules_group = '1', id_category_default = '421', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20075' 11/05/2023 03:33:41 pm >> DELETE FROM ps_specific_price WHERE id_product = '20075' 11/05/2023 03:33:57 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '1497/CAV' AND id_product != '20075' AND ean13 != '' 11/05/2023 03:33:57 pm >> UPDATE ps_product SET id_supplier = '113', reference = '', ean13 = '1497/CAV', date_upd = NOW() WHERE id_product = '20075' 11/05/2023 03:33:57 pm >> UPDATE ps_product_lang SET name = 'ROSARIO ARGENTO/EMATITE', description = '' WHERE id_product = '20075' 11/05/2023 03:33:57 pm >> UPDATE ps_product SET wholesale_price = '14.63', on_sale = '0', price = '34.42622950819672' WHERE id_product = '20075' 11/05/2023 03:33:57 pm >> UPDATE ps_product_shop SET wholesale_price = '14.63', price = '34.42622950819672', id_tax_rules_group = '1', id_category_default = '421', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20075' 11/05/2023 03:33:57 pm >> DELETE FROM ps_specific_price WHERE id_product = '20075' 11/05/2023 03:34:26 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '1931/CAV' AND id_product != '19771' AND ean13 != '' 11/05/2023 03:34:26 pm >> UPDATE ps_product SET id_supplier = '113', reference = '', ean13 = '1931/CAV', date_upd = NOW() WHERE id_product = '19771' 11/05/2023 03:34:26 pm >> UPDATE ps_product_lang SET name = 'ROSARIO ARGENTO/EMATITE', description = '' WHERE id_product = '19771' 11/05/2023 03:34:26 pm >> UPDATE ps_product SET wholesale_price = '12.83', on_sale = '0', price = '30.737704918032787' WHERE id_product = '19771' 11/05/2023 03:34:26 pm >> UPDATE ps_product_shop SET wholesale_price = '12.83', price = '30.737704918032787', id_tax_rules_group = '1', id_category_default = '421', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19771' 11/05/2023 03:34:26 pm >> DELETE FROM ps_specific_price WHERE id_product = '19771' 11/05/2023 03:34:49 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '1931/CAV' AND id_product != '19771' AND ean13 != '' 11/05/2023 03:34:49 pm >> UPDATE ps_product SET id_supplier = '113', reference = '', ean13 = '1931/CAV', date_upd = NOW() WHERE id_product = '19771' 11/05/2023 03:34:49 pm >> UPDATE ps_product_lang SET name = 'ROSARIO ARGENTO/EMATITE - 1931CAV', description = '' WHERE id_product = '19771' 11/05/2023 03:34:49 pm >> UPDATE ps_product SET wholesale_price = '12.83', on_sale = '0', price = '30.737704918032787' WHERE id_product = '19771' 11/05/2023 03:34:49 pm >> UPDATE ps_product_shop SET wholesale_price = '12.83', price = '30.737704918032787', id_tax_rules_group = '1', id_category_default = '421', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19771' 11/05/2023 03:34:49 pm >> DELETE FROM ps_specific_price WHERE id_product = '19771' 11/05/2023 03:37:56 pm >> SELECT document_num FROM ps_document WHERE document_num = '1610' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-11') 11/05/2023 03:37:56 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1610' , '2023-05-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.00' , '5.00' , NOW() , NOW() ) 11/05/2023 03:37: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 = '84276' 11/05/2023 03:37:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '84276' 11/05/2023 03:37: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 ( '84276' , '4120' , 'FEDE NELLO ZAINETTO' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '0' , '5.00' ) 11/05/2023 03:42:57 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '1374/CAV' AND id_product != '19772' AND ean13 != '' 11/05/2023 03:42:57 pm >> UPDATE ps_product SET id_supplier = '113', reference = '', ean13 = '1374/CAV', date_upd = NOW() WHERE id_product = '19772' 11/05/2023 03:42:57 pm >> UPDATE ps_product_lang SET name = 'BRACCIALE ARGENTO/EMATITE', description = '' WHERE id_product = '19772' 11/05/2023 03:42:57 pm >> UPDATE ps_product SET wholesale_price = '7.03', on_sale = '0', price = '16.3934' WHERE id_product = '19772' 11/05/2023 03:42:57 pm >> UPDATE ps_product_shop SET wholesale_price = '7.03', price = '16.3934', id_tax_rules_group = '1', id_category_default = '421', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19772' 11/05/2023 03:42:57 pm >> DELETE FROM ps_specific_price WHERE id_product = '19772' 11/05/2023 03:48:53 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '1375/CAV' AND id_product != '20077' AND ean13 != '' 11/05/2023 03:48:53 pm >> UPDATE ps_product SET id_supplier = '113', reference = '', ean13 = '1375/CAV', date_upd = NOW() WHERE id_product = '20077' 11/05/2023 03:48:53 pm >> UPDATE ps_product_lang SET name = 'BRACCIALE ARGENTO', description = '' WHERE id_product = '20077' 11/05/2023 03:48:53 pm >> UPDATE ps_product SET wholesale_price = '8.93', on_sale = '0', price = '20.0820' WHERE id_product = '20077' 11/05/2023 03:48:53 pm >> UPDATE ps_product_shop SET wholesale_price = '8.93', price = '20.0820', id_tax_rules_group = '1', id_category_default = '421', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20077' 11/05/2023 03:48:53 pm >> DELETE FROM ps_specific_price WHERE id_product = '20077' 11/05/2023 03:49:36 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '1375/CAV' AND id_product != '20077' AND ean13 != '' 11/05/2023 03:49:36 pm >> UPDATE ps_product SET id_supplier = '113', reference = '', ean13 = '1375/CAV', date_upd = NOW() WHERE id_product = '20077' 11/05/2023 03:49:36 pm >> UPDATE ps_product_lang SET name = 'BRACCIALE ARGENTO', description = '' WHERE id_product = '20077' 11/05/2023 03:49:36 pm >> UPDATE ps_product SET wholesale_price = '8.93', on_sale = '0', price = '20.0820' WHERE id_product = '20077' 11/05/2023 03:49:36 pm >> UPDATE ps_product_shop SET wholesale_price = '8.93', price = '20.0820', id_tax_rules_group = '1', id_category_default = '421', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20077' 11/05/2023 03:49:36 pm >> DELETE FROM ps_specific_price WHERE id_product = '20077' 11/05/2023 03:51:32 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '1941/CAV' AND id_product != '21082' AND ean13 != '' 11/05/2023 03:51:32 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '1941/CAV', date_upd = NOW() WHERE id_product = '21082' 11/05/2023 03:51:32 pm >> UPDATE ps_product_lang SET name = 'BRACCIALE ARG. ESAGONALE - 1941CAV', description = '' WHERE id_product = '21082' 11/05/2023 03:51:32 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '19.262295081967213' WHERE id_product = '21082' 11/05/2023 03:51:32 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '19.262295081967213', id_tax_rules_group = '1', id_category_default = '421', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21082' 11/05/2023 03:51:32 pm >> DELETE FROM ps_specific_price WHERE id_product = '21082' 11/05/2023 03:51:33 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 = '21082' 11/05/2023 03:51:33 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21083' , '1' , '' , 'nuovo-prodotto' ) 11/05/2023 03:51:33 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 '21083' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21082' 11/05/2023 03:51:33 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21083' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21082' 11/05/2023 03:53:50 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '1351/CAV' AND id_product != '21083' AND ean13 != '' 11/05/2023 03:53:50 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '1351/CAV', date_upd = NOW() WHERE id_product = '21083' 11/05/2023 03:53:50 pm >> UPDATE ps_product_lang SET name = 'BRACCIALE ARG. CRISTALLO - 1351CAV', description = '' WHERE id_product = '21083' 11/05/2023 03:53:50 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '13.852459016393441' WHERE id_product = '21083' 11/05/2023 03:53:50 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '13.852459016393441', id_tax_rules_group = '1', id_category_default = '421', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21083' 11/05/2023 03:53:50 pm >> DELETE FROM ps_specific_price WHERE id_product = '21083' 11/05/2023 03:53:51 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 = '21083' 11/05/2023 03:53:51 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21084' , '1' , '' , 'nuovo-prodotto' ) 11/05/2023 03:53:51 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 '21084' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21083' 11/05/2023 03:53:51 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21084' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21083' 11/05/2023 03:54:17 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001800' AND id_product != '18762' AND ean13 != '' 11/05/2023 03:54:17 pm >> UPDATE ps_product SET id_supplier = '113', reference = '', ean13 = '001800', date_upd = NOW() WHERE id_product = '18762' 11/05/2023 03:54:17 pm >> UPDATE ps_product_lang SET name = 'BRACCIALE ARG. - 1568/1570', description = '' WHERE id_product = '18762' 11/05/2023 03:54:17 pm >> UPDATE ps_product SET wholesale_price = '14.11', on_sale = '0', price = '34.42622950819672' WHERE id_product = '18762' 11/05/2023 03:54:17 pm >> UPDATE ps_product_shop SET wholesale_price = '14.11', price = '34.42622950819672', id_tax_rules_group = '1', id_category_default = '421', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '18762' 11/05/2023 03:54:17 pm >> DELETE FROM ps_specific_price WHERE id_product = '18762' 11/05/2023 03:54:36 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001800' AND id_product != '18762' AND ean13 != '' 11/05/2023 03:54:36 pm >> UPDATE ps_product SET id_supplier = '113', reference = '', ean13 = '001800', date_upd = NOW() WHERE id_product = '18762' 11/05/2023 03:54:36 pm >> UPDATE ps_product_lang SET name = 'BRACCIALE ARG. - 1568/1570', description = '' WHERE id_product = '18762' 11/05/2023 03:54:36 pm >> UPDATE ps_product SET wholesale_price = '14.11', on_sale = '0', price = '34.34426229508197' WHERE id_product = '18762' 11/05/2023 03:54:36 pm >> UPDATE ps_product_shop SET wholesale_price = '14.11', price = '34.34426229508197', id_tax_rules_group = '1', id_category_default = '421', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '18762' 11/05/2023 03:54:36 pm >> DELETE FROM ps_specific_price WHERE id_product = '18762' 11/05/2023 03:54:55 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001800' AND id_product != '18762' AND ean13 != '' 11/05/2023 03:54:55 pm >> UPDATE ps_product SET id_supplier = '113', reference = '', ean13 = '001800', date_upd = NOW() WHERE id_product = '18762' 11/05/2023 03:54:55 pm >> UPDATE ps_product_lang SET name = 'BRACCIALE ARG. - 1568/1570', description = '' WHERE id_product = '18762' 11/05/2023 03:54:55 pm >> UPDATE ps_product SET wholesale_price = '14.11', on_sale = '0', price = '34.34426229508197' WHERE id_product = '18762' 11/05/2023 03:54:55 pm >> UPDATE ps_product_shop SET wholesale_price = '14.11', price = '34.34426229508197', id_tax_rules_group = '1', id_category_default = '421', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '18762' 11/05/2023 03:54:55 pm >> DELETE FROM ps_specific_price WHERE id_product = '18762' 11/05/2023 03:56:08 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002141' AND id_product != '21084' AND ean13 != '' 11/05/2023 03:56:08 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002141', date_upd = NOW() WHERE id_product = '21084' 11/05/2023 03:56:08 pm >> UPDATE ps_product_lang SET name = 'BRACCIALE ARG. DIAMANTATO - 1835', description = '' WHERE id_product = '21084' 11/05/2023 03:56:08 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '20.081967213114755' WHERE id_product = '21084' 11/05/2023 03:56:08 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '20.081967213114755', id_tax_rules_group = '1', id_category_default = '421', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21084' 11/05/2023 03:56:08 pm >> DELETE FROM ps_specific_price WHERE id_product = '21084' 11/05/2023 03:57:06 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002141' AND id_product != '21084' AND ean13 != '' 11/05/2023 03:57:06 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002141', date_upd = NOW() WHERE id_product = '21084' 11/05/2023 03:57:06 pm >> UPDATE ps_product_lang SET name = 'BRACCIALE ARG. DIAMANTATO - 1835', description = '' WHERE id_product = '21084' 11/05/2023 03:57:06 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '20.081967213114755' WHERE id_product = '21084' 11/05/2023 03:57:06 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '20.081967213114755', id_tax_rules_group = '1', id_category_default = '421', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21084' 11/05/2023 03:57:06 pm >> DELETE FROM ps_specific_price WHERE id_product = '21084' 11/05/2023 03:57:17 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 = '21084' 11/05/2023 03:57:17 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21085' , '1' , '' , 'nuovo-prodotto' ) 11/05/2023 03:57:17 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 '21085' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21084' 11/05/2023 03:57:17 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21085' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21084' 11/05/2023 03:57:46 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '1537BIMBA' AND id_product != '21085' AND ean13 != '' 11/05/2023 03:57:46 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '1537BIMBA', date_upd = NOW() WHERE id_product = '21085' 11/05/2023 03:57:46 pm >> UPDATE ps_product_lang SET name = 'BRACCIALE ARG. BIMBA - 1537BIMBA', description = '' WHERE id_product = '21085' 11/05/2023 03:57:46 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '13.852459016393441' WHERE id_product = '21085' 11/05/2023 03:57:46 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '13.852459016393441', id_tax_rules_group = '1', id_category_default = '421', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21085' 11/05/2023 03:57:46 pm >> DELETE FROM ps_specific_price WHERE id_product = '21085' 11/05/2023 03:57:47 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 = '21085' 11/05/2023 03:57:47 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21086' , '1' , '' , 'nuovo-prodotto' ) 11/05/2023 03:57:47 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 '21086' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21085' 11/05/2023 03:57:47 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21086' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21085' 11/05/2023 04:09:50 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '1803/CAV' AND id_product != '21086' AND ean13 != '' 11/05/2023 04:09:50 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '1803/CAV', date_upd = NOW() WHERE id_product = '21086' 11/05/2023 04:09:50 pm >> UPDATE ps_product_lang SET name = 'BRACCIALE ARG. E CRISTALLO - 1803CAV', description = '' WHERE id_product = '21086' 11/05/2023 04:09:50 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '18.442622950819672' WHERE id_product = '21086' 11/05/2023 04:09:50 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '18.442622950819672', id_tax_rules_group = '1', id_category_default = '421', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21086' 11/05/2023 04:09:50 pm >> DELETE FROM ps_specific_price WHERE id_product = '21086' 11/05/2023 04:09:51 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 = '21086' 11/05/2023 04:09:51 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21087' , '1' , '' , 'nuovo-prodotto' ) 11/05/2023 04:09:51 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 '21087' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21086' 11/05/2023 04:09:51 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21087' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21086' 11/05/2023 04:11:05 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '1639/CAV' AND id_product != '21087' AND ean13 != '' 11/05/2023 04:11:05 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '1639/CAV', date_upd = NOW() WHERE id_product = '21087' 11/05/2023 04:11:05 pm >> UPDATE ps_product_lang SET name = 'BRACCIALE ARG. EMATITE - 1639CAV', description = '' WHERE id_product = '21087' 11/05/2023 04:11:05 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '15.98360655737705' WHERE id_product = '21087' 11/05/2023 04:11:05 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '15.98360655737705', id_tax_rules_group = '1', id_category_default = '421', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21087' 11/05/2023 04:11:05 pm >> DELETE FROM ps_specific_price WHERE id_product = '21087' 11/05/2023 04:11:06 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 = '21087' 11/05/2023 04:11:06 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21088' , '1' , '' , 'nuovo-prodotto' ) 11/05/2023 04:11:06 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 '21088' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21087' 11/05/2023 04:11:06 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21088' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21087' 11/05/2023 04:12:19 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '1631/CAV' AND id_product != '21088' AND ean13 != '' 11/05/2023 04:12:19 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '1631/CAV', date_upd = NOW() WHERE id_product = '21088' 11/05/2023 04:12:19 pm >> UPDATE ps_product_lang SET name = 'BRACCIALE ARG. EMATITE - 1631CAV', description = '' WHERE id_product = '21088' 11/05/2023 04:12:19 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '16.39344262295082' WHERE id_product = '21088' 11/05/2023 04:12:19 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '16.39344262295082', id_tax_rules_group = '1', id_category_default = '421', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21088' 11/05/2023 04:12:19 pm >> DELETE FROM ps_specific_price WHERE id_product = '21088' 11/05/2023 04:12:20 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 = '21088' 11/05/2023 04:12:20 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21089' , '1' , '' , 'nuovo-prodotto' ) 11/05/2023 04:12:20 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 '21089' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21088' 11/05/2023 04:12:20 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21089' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21088' 11/05/2023 04:16:39 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '6372' AND id_product != '16289' AND ean13 != '' 11/05/2023 04:16:39 pm >> UPDATE ps_product SET id_supplier = '113', reference = '', ean13 = '6372', date_upd = NOW() WHERE id_product = '16289' 11/05/2023 04:16:39 pm >> UPDATE ps_product_lang SET name = 'ANELLO IN ARG. ', description = '' WHERE id_product = '16289' 11/05/2023 04:16:39 pm >> UPDATE ps_product SET wholesale_price = '34.49', on_sale = '0', price = '90.16393442622952' WHERE id_product = '16289' 11/05/2023 04:16:39 pm >> UPDATE ps_product_shop SET wholesale_price = '34.49', price = '90.16393442622952', id_tax_rules_group = '1', id_category_default = '421', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '16289' 11/05/2023 04:16:39 pm >> DELETE FROM ps_specific_price WHERE id_product = '16289' 11/05/2023 04:21:32 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002142' AND id_product != '21089' AND ean13 != '' 11/05/2023 04:21:32 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002142', date_upd = NOW() WHERE id_product = '21089' 11/05/2023 04:21:32 pm >> UPDATE ps_product_lang SET name = 'ANELLO ROSARIO ARG.', description = '' WHERE id_product = '21089' 11/05/2023 04:21:32 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '22.950819672131146' WHERE id_product = '21089' 11/05/2023 04:21:32 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '22.950819672131146', id_tax_rules_group = '1', id_category_default = '421', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21089' 11/05/2023 04:21:32 pm >> DELETE FROM ps_specific_price WHERE id_product = '21089' 11/05/2023 04:21:33 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 = '21089' 11/05/2023 04:21:33 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21090' , '1' , '' , 'nuovo-prodotto' ) 11/05/2023 04:21:33 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 '21090' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21089' 11/05/2023 04:21:33 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21090' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21089' 11/05/2023 04:23:29 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002143' AND id_product != '21090' AND ean13 != '' 11/05/2023 04:23:29 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002143', date_upd = NOW() WHERE id_product = '21090' 11/05/2023 04:23:29 pm >> UPDATE ps_product_lang SET name = 'ANELLO ARG. - 6269', description = '' WHERE id_product = '21090' 11/05/2023 04:23:29 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '18.852459016393443' WHERE id_product = '21090' 11/05/2023 04:23:29 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '18.852459016393443', id_tax_rules_group = '1', id_category_default = '421', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21090' 11/05/2023 04:23:29 pm >> DELETE FROM ps_specific_price WHERE id_product = '21090' 11/05/2023 04:23:32 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 = '21090' 11/05/2023 04:23:32 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21091' , '1' , '' , 'nuovo-prodotto' ) 11/05/2023 04:23:32 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 '21091' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21090' 11/05/2023 04:23:32 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21091' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21090' 11/05/2023 04:24:31 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002142' AND id_product != '21089' AND ean13 != '' 11/05/2023 04:24:31 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002142', date_upd = NOW() WHERE id_product = '21089' 11/05/2023 04:24:31 pm >> UPDATE ps_product_lang SET name = 'ANELLO ROSARIO ARG. - 6450', description = '' WHERE id_product = '21089' 11/05/2023 04:24:31 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '22.9508' WHERE id_product = '21089' 11/05/2023 04:24:31 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '22.9508', id_tax_rules_group = '1', id_category_default = '421', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21089' 11/05/2023 04:24:31 pm >> DELETE FROM ps_specific_price WHERE id_product = '21089' 11/05/2023 04:26:20 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '18020' AND id_product != '21091' AND ean13 != '' 11/05/2023 04:26:20 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '18020', date_upd = NOW() WHERE id_product = '21091' 11/05/2023 04:26:20 pm >> UPDATE ps_product_lang SET name = 'RENI IN ARG - 18020', description = '' WHERE id_product = '21091' 11/05/2023 04:26:20 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '77.8688524590164' WHERE id_product = '21091' 11/05/2023 04:26:20 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '77.8688524590164', id_tax_rules_group = '1', id_category_default = '421', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21091' 11/05/2023 04:26:20 pm >> DELETE FROM ps_specific_price WHERE id_product = '21091' 11/05/2023 04:26:21 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 = '21091' 11/05/2023 04:26:21 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21092' , '1' , '' , 'nuovo-prodotto' ) 11/05/2023 04:26:21 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 '21092' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21091' 11/05/2023 04:26:21 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21092' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21091' 11/05/2023 04:31:41 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '1374/CAV' AND id_product != '19772' AND ean13 != '' 11/05/2023 04:31:42 pm >> UPDATE ps_product SET id_supplier = '113', reference = '', ean13 = '1374/CAV', date_upd = NOW() WHERE id_product = '19772' 11/05/2023 04:31:42 pm >> UPDATE ps_product_lang SET name = 'BRACCIALE ARGENTO/EMATITE - 1374CAV', description = '' WHERE id_product = '19772' 11/05/2023 04:31:42 pm >> UPDATE ps_product SET wholesale_price = '7.03', on_sale = '0', price = '16.3934' WHERE id_product = '19772' 11/05/2023 04:31:42 pm >> UPDATE ps_product_shop SET wholesale_price = '7.03', price = '16.3934', id_tax_rules_group = '1', id_category_default = '421', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19772' 11/05/2023 04:31:42 pm >> DELETE FROM ps_specific_price WHERE id_product = '19772' 11/05/2023 04:32:17 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '1375/CAV' AND id_product != '20077' AND ean13 != '' 11/05/2023 04:32:17 pm >> UPDATE ps_product SET id_supplier = '113', reference = '', ean13 = '1375/CAV', date_upd = NOW() WHERE id_product = '20077' 11/05/2023 04:32:17 pm >> UPDATE ps_product_lang SET name = 'BRACCIALE ARGENTO - 1375CAV', description = '' WHERE id_product = '20077' 11/05/2023 04:32:17 pm >> UPDATE ps_product SET wholesale_price = '8.93', on_sale = '0', price = '20.0820' WHERE id_product = '20077' 11/05/2023 04:32:17 pm >> UPDATE ps_product_shop SET wholesale_price = '8.93', price = '20.0820', id_tax_rules_group = '1', id_category_default = '421', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20077' 11/05/2023 04:32:17 pm >> DELETE FROM ps_specific_price WHERE id_product = '20077' 11/05/2023 04:32:51 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '1793/CAV' AND id_product != '19781' AND ean13 != '' 11/05/2023 04:32:51 pm >> UPDATE ps_product SET id_supplier = '113', reference = '', ean13 = '1793/CAV', date_upd = NOW() WHERE id_product = '19781' 11/05/2023 04:32:51 pm >> UPDATE ps_product_lang SET name = 'BRACCIALE ARGENTO/EMATITE - 1793CAV', description = '' WHERE id_product = '19781' 11/05/2023 04:32:51 pm >> UPDATE ps_product SET wholesale_price = '6.75', on_sale = '0', price = '15.1639' WHERE id_product = '19781' 11/05/2023 04:32:51 pm >> UPDATE ps_product_shop SET wholesale_price = '6.75', price = '15.1639', id_tax_rules_group = '1', id_category_default = '421', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19781' 11/05/2023 04:32:51 pm >> DELETE FROM ps_specific_price WHERE id_product = '19781' 11/05/2023 04:34:36 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '1537/BIMB' AND id_product != '21085' AND ean13 != '' 11/05/2023 04:34:36 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '1537/BIMB', date_upd = NOW() WHERE id_product = '21085' 11/05/2023 04:34:36 pm >> UPDATE ps_product_lang SET name = 'BRACCIALE ARG. BIMBA - 1537BIMB', description = '' WHERE id_product = '21085' 11/05/2023 04:34:36 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '13.8525' WHERE id_product = '21085' 11/05/2023 04:34:36 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '13.8525', id_tax_rules_group = '1', id_category_default = '421', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21085' 11/05/2023 04:34:36 pm >> DELETE FROM ps_specific_price WHERE id_product = '21085' 11/05/2023 04:35:58 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '6578SR' AND id_product != '19778' AND ean13 != '' 11/05/2023 04:35:58 pm >> UPDATE ps_product SET id_supplier = '113', reference = '', ean13 = '6578SR', date_upd = NOW() WHERE id_product = '19778' 11/05/2023 04:35:58 pm >> UPDATE ps_product_lang SET name = 'ANELLO CROCE/S. RITA - 6578SR', description = '' WHERE id_product = '19778' 11/05/2023 04:35:58 pm >> UPDATE ps_product SET wholesale_price = '4.56', on_sale = '0', price = '10.6557' WHERE id_product = '19778' 11/05/2023 04:35:58 pm >> UPDATE ps_product_shop SET wholesale_price = '4.56', price = '10.6557', id_tax_rules_group = '1', id_category_default = '421', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19778' 11/05/2023 04:35:58 pm >> DELETE FROM ps_specific_price WHERE id_product = '19778' 11/05/2023 04:36:27 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '6578SB' AND id_product != '19777' AND ean13 != '' 11/05/2023 04:36:27 pm >> UPDATE ps_product SET id_supplier = '113', reference = '', ean13 = '6578SB', date_upd = NOW() WHERE id_product = '19777' 11/05/2023 04:36:27 pm >> UPDATE ps_product_lang SET name = 'ANELLO CROCE/S.BENEDETTO - 6578SB', description = '' WHERE id_product = '19777' 11/05/2023 04:36:28 pm >> UPDATE ps_product SET wholesale_price = '5.42', on_sale = '0', price = '12.2951' WHERE id_product = '19777' 11/05/2023 04:36:28 pm >> UPDATE ps_product_shop SET wholesale_price = '5.42', price = '12.2951', id_tax_rules_group = '1', id_category_default = '421', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19777' 11/05/2023 04:36:28 pm >> DELETE FROM ps_specific_price WHERE id_product = '19777' 11/05/2023 04:37:06 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '6372' AND id_product != '16289' AND ean13 != '' 11/05/2023 04:37:06 pm >> UPDATE ps_product SET id_supplier = '113', reference = '', ean13 = '6372', date_upd = NOW() WHERE id_product = '16289' 11/05/2023 04:37:06 pm >> UPDATE ps_product_lang SET name = 'ANELLO IN ARG. - 6372', description = '' WHERE id_product = '16289' 11/05/2023 04:37:06 pm >> UPDATE ps_product SET wholesale_price = '34.49', on_sale = '0', price = '90.1639' WHERE id_product = '16289' 11/05/2023 04:37:06 pm >> UPDATE ps_product_shop SET wholesale_price = '34.49', price = '90.1639', id_tax_rules_group = '1', id_category_default = '421', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '16289' 11/05/2023 04:37:06 pm >> DELETE FROM ps_specific_price WHERE id_product = '16289' 11/05/2023 04:38:19 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '489' , '2023-05-05' , '' , '0' , '113' , '4669149' , 'VIA VALLE CALDA, 7 16013 CAMPO LIGURE' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '424.89' , '348.27' , NOW() , NOW() ) 11/05/2023 04:38:19 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84277' 11/05/2023 04:38:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '84277' 11/05/2023 04:38: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 ( '84277' , '20078' , 'ROSARIO ARGENTO' , '1' , '1' , '1' , '21.4' , '17.540983606557' , '22' , '5' , '24.8026' ) 11/05/2023 04:38:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20078' AND id_supplier = '113' 11/05/2023 04:38:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20078' , '113' , '1' ) 11/05/2023 04:38: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 ( '84277' , '21080' , 'ROSARIO ARG. MADREPERLA - 328CAV' , '1' , '1' , '1' , '14.1' , '11.55737704918' , '22' , '5' , '16.3419' ) 11/05/2023 04:38:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21080' AND id_supplier = '113' 11/05/2023 04:38:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21080' , '113' , '1' ) 11/05/2023 04:38: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 ( '84277' , '20076' , 'ROSARIO ARGENTO/QUARZO' , '1' , '1' , '1' , '23.9' , '19.590163934426' , '22' , '5' , '27.7001' ) 11/05/2023 04:38:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20076' AND id_supplier = '113' 11/05/2023 04:38:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20076' , '113' , '1' ) 11/05/2023 04:38: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 ( '84277' , '21081' , 'ROSARGIO ARG. EMATITE - 1300CAV' , '1' , '1' , '1' , '16.2' , '13.27868852459' , '22' , '5' , '18.7758' ) 11/05/2023 04:38:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21081' AND id_supplier = '113' 11/05/2023 04:38:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21081' , '113' , '1' ) 11/05/2023 04:38: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 ( '84277' , '20075' , 'ROSARIO ARGENTO/EMATITE' , '1' , '1' , '1' , '16.4' , '13.44262295082' , '22' , '5' , '19.0076' ) 11/05/2023 04:38:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20075' AND id_supplier = '113' 11/05/2023 04:38:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20075' , '113' , '1' ) 11/05/2023 04:38:20 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 ( '84277' , '19771' , 'ROSARIO ARGENTO/EMATITE - 1931CAV' , '1' , '1' , '1' , '15.3' , '12.540983606557' , '22' , '5' , '17.7327' ) 11/05/2023 04:38:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19771' AND id_supplier = '113' 11/05/2023 04:38:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19771' , '113' , '1' ) 11/05/2023 04:38:20 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 ( '84277' , '19772' , 'BRACCIALE ARGENTO/EMATITE' , '1' , '1' , '1' , '8.3' , '6.8032786885246' , '22' , '5' , '9.6197' ) 11/05/2023 04:38:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19772' AND id_supplier = '113' 11/05/2023 04:38:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19772' , '113' , '1' ) 11/05/2023 04:38:20 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 ( '84277' , '20077' , 'BRACCIALE ARGENTO - 1375CAV' , '3' , '3' , '1' , '9.9' , '8.1147540983607' , '22' , '5' , '34.4223' ) 11/05/2023 04:38:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20077' AND id_supplier = '113' 11/05/2023 04:38:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20077' , '113' , '1' ) 11/05/2023 04:38:20 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 ( '84277' , '19781' , 'BRACCIALE ARGENTO/EMATITE - 1793CAV' , '1' , '1' , '1' , '7.5' , '6.1475409836066' , '22' , '5' , '8.6925' ) 11/05/2023 04:38:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19781' AND id_supplier = '113' 11/05/2023 04:38:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19781' , '113' , '1' ) 11/05/2023 04:38:20 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 ( '84277' , '21082' , 'BRACCIALE ARG. ESAGONALE - 1941CAV' , '1' , '1' , '1' , '9.5' , '7.7868852459016' , '22' , '5' , '11.0105' ) 11/05/2023 04:38:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21082' AND id_supplier = '113' 11/05/2023 04:38:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21082' , '113' , '1' ) 11/05/2023 04:38:20 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 ( '84277' , '21083' , 'BRACCIALE ARG. CRISTALLO - 1351CAV' , '2' , '2' , '1' , '6.9' , '5.655737704918' , '22' , '5' , '15.9942' ) 11/05/2023 04:38:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21083' AND id_supplier = '113' 11/05/2023 04:38:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21083' , '113' , '1' ) 11/05/2023 04:38:20 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 ( '84277' , '18762' , 'BRACCIALE ARG. - 1568/1570' , '1' , '1' , '1' , '16.8' , '13.770491803279' , '22' , '5' , '19.4712' ) 11/05/2023 04:38:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18762' AND id_supplier = '113' 11/05/2023 04:38:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18762' , '113' , '1' ) 11/05/2023 04:38:20 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 ( '84277' , '21084' , 'BRACCIALE ARG. DIAMANTATO - 1835' , '1' , '1' , '1' , '10.10' , '8.2786885245902' , '22' , '5' , '11.7059' ) 11/05/2023 04:38:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21084' AND id_supplier = '113' 11/05/2023 04:38:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21084' , '113' , '1' ) 11/05/2023 04:38:20 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 ( '84277' , '21085' , 'BRACCIALE ARG. BIMBA - 1537BIMB' , '1' , '1' , '1' , '6.9' , '5.655737704918' , '22' , '5' , '7.9971' ) 11/05/2023 04:38:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21085' AND id_supplier = '113' 11/05/2023 04:38:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21085' , '113' , '1' ) 11/05/2023 04:38:20 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 ( '84277' , '21086' , 'BRACCIALE ARG. E CRISTALLO - 1803CAV' , '1' , '1' , '1' , '9.1' , '7.4590163934426' , '22' , '5' , '10.5469' ) 11/05/2023 04:38:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21086' AND id_supplier = '113' 11/05/2023 04:38:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21086' , '113' , '1' ) 11/05/2023 04:38:20 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 ( '84277' , '21087' , 'BRACCIALE ARG. EMATITE - 1639CAV' , '1' , '1' , '1' , '7.9' , '6.4754098360656' , '22' , '5' , '9.1561' ) 11/05/2023 04:38:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21087' AND id_supplier = '113' 11/05/2023 04:38:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21087' , '113' , '1' ) 11/05/2023 04:38:20 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 ( '84277' , '21088' , 'BRACCIALE ARG. EMATITE - 1631CAV' , '1' , '1' , '1' , '8.1' , '6.6393442622951' , '22' , '5' , '9.3879' ) 11/05/2023 04:38:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21088' AND id_supplier = '113' 11/05/2023 04:38:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21088' , '113' , '1' ) 11/05/2023 04:38:20 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 ( '84277' , '19778' , 'ANELLO CROCE/S. RITA - 6578SR' , '3' , '3' , '1' , '5' , '4.0983606557377' , '22' , '5' , '17.3850' ) 11/05/2023 04:38:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19778' AND id_supplier = '113' 11/05/2023 04:38:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19778' , '113' , '1' ) 11/05/2023 04:38:20 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 ( '84277' , '19777' , 'ANELLO CROCE/S.BENEDETTO - 6578SB' , '2' , '2' , '1' , '5.9' , '4.8360655737705' , '22' , '5' , '13.6762' ) 11/05/2023 04:38:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19777' AND id_supplier = '113' 11/05/2023 04:38:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19777' , '113' , '1' ) 11/05/2023 04:38:20 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 ( '84277' , '16289' , 'ANELLO IN ARG. - 6372' , '1' , '1' , '1' , '44.7' , '36.639344262295' , '22' , '5' , '51.8073' ) 11/05/2023 04:38:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16289' AND id_supplier = '113' 11/05/2023 04:38:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16289' , '113' , '1' ) 11/05/2023 04:38:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84277' , '21089' , 'ANELLO ROSARIO ARG. - 6450' , '1' , '1' , '1' , '11.6' , '9.5081967213115' , '22' , '5' , '13.4444' ) 11/05/2023 04:38:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21089' AND id_supplier = '113' 11/05/2023 04:38:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21089' , '113' , '1' ) 11/05/2023 04:38:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84277' , '21090' , 'ANELLO ARG. - 6269' , '1' , '1' , '1' , '9.5' , '7.7868852459016' , '22' , '5' , '11.0105' ) 11/05/2023 04:38:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21090' AND id_supplier = '113' 11/05/2023 04:38:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21090' , '113' , '1' ) 11/05/2023 04:38:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84277' , '21091' , 'RENI IN ARG - 18020' , '1' , '1' , '1' , '39' , '31.967213114754' , '22' , '5' , '45.2010' ) 11/05/2023 04:38:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21091' AND id_supplier = '113' 11/05/2023 04:38:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21091' , '113' , '1' ) 11/05/2023 04:39:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '1552' AND id_document != '84198' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-06') 11/05/2023 04:39:59 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1552', document_date = '2023-05-06', 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 = '36.89', date_upd = NOW() WHERE id_document = '84198' 11/05/2023 04:39: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 = '84198' 11/05/2023 04:39:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '84198' 11/05/2023 04:39: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 ( '84198' , '19772' , 'BRACCIALE ARGENTO/EMATITE - 1374CAV' , '1' , '-1' , '1' , '20.00' , '16.393442622951' , '22' , '0' , '20.00' ) 11/05/2023 04:39: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 ( '84198' , '20077' , 'BRACCIALE ARGENTO - 1375CAV' , '1' , '-1' , '1' , '24.50' , '20.081967213115' , '22' , '0' , '24.50' ) 11/05/2023 04:39: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 ( '84198' , '17004' , 'BIGLIETTO AUGURALE PICCOLO' , '1' , '-1' , '1' , '0.5' , '0.40983606557377' , '22' , '0' , '0.50' ) 11/05/2023 04:40:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '1611' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-11') 11/05/2023 04:40: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' , '1611' , '2023-05-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '37.50' , '30.74' , NOW() , NOW() ) 11/05/2023 04:40:26 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84278' 11/05/2023 04:40:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '84278' 11/05/2023 04:40:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84278' , '19771' , 'ROSARIO ARGENTO/EMATITE - 1931CAV' , '1' , '-1' , '1' , '37.50' , '30.737704918033' , '22' , '0' , '37.50' ) 11/05/2023 04:55:33 pm >> SELECT document_num FROM ps_document WHERE document_num = '58/A' AND id_document != '84077' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-05-02') 11/05/2023 04:55:33 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '58/A', document_date = '2023-05-02', document_letter = 'A', id_customer = '204', id_supplier = '', id_address = '4671483', address1 = 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO', address2 = '', note = 'cappellania SAN LEONARDO', 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 = '102.26', price_tax_excluded = '98.35', date_upd = NOW() WHERE id_document = '84077' 11/05/2023 04:55:33 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84077' 11/05/2023 04:55:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '84077' 11/05/2023 04:55:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84077' , '20766' , 'AMEN - GIU 23' , '5' , '-5' , '4' , '3.9000' , '3.9' , '0' , '5' , '18.52' ) 11/05/2023 04:55:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84077' , '20765' , 'AMEN - MAG 23' , '5' , '-5' , '4' , '3.9000' , '3.9' , '0' , '5' , '18.52' ) 11/05/2023 04:55:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84077' , '20999' , 'AMEN - LUG 23' , '5' , '-5' , '4' , '3.9000' , '3.9' , '0' , '5' , '18.52' ) 11/05/2023 04:55:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84077' , '0' , 'SUPPLICA' , '2' , '-2' , '0' , '10.0000' , '10' , '0' , '0' , '20.00' ) 11/05/2023 04:55:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84077' , '13103' , 'BRACCIALE BAMBOO - CY B 774' , '15' , '-15' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '15.00' ) 11/05/2023 04:55:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84077' , '2448' , 'COLUI IN CUI CREDO' , '2' , '-2' , '4' , '2.5000' , '2.5' , '0' , '0' , '5.00' ) 11/05/2023 04:55:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84077' , '14772' , 'BRACCIALE SAN BENEDETTO 4 COLORI - 0818/3' , '1' , '-1' , '1' , '2.50' , '2.0491803278689' , '22' , '0' , '2.50' ) 11/05/2023 04:55:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84077' , '18892' , 'BRACCIALE DECINA AZZURRO - BC822NP' , '1' , '-1' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '1.20' ) 11/05/2023 04:55:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84077' , '18214' , 'BRACCIALE DECINA LEGNO CORDA - BC566' , '1' , '-1' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '2.00' ) 11/05/2023 04:55:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84077' , '18215' , 'BRACCIALE DECINA VARI COL. - BC752' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 11/05/2023 05:17:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '1612' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-11') 11/05/2023 05:17: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' , '1612' , '2023-05-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '27.00' , '22.13' , NOW() , NOW() ) 11/05/2023 05:17: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 = '84279' 11/05/2023 05:17:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '84279' 11/05/2023 05:17: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 ( '84279' , '19315' , 'SCATOLINA METALLO CON CORONCINA COMUNIONE - 1016/K209' , '9' , '-9' , '1' , '3.00' , '2.4590163934426' , '22' , '0' , '27.00' ) 11/05/2023 05:24:27 pm >> SELECT document_num FROM ps_document WHERE document_num = '1335' AND id_document != '82916' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-21') 11/05/2023 05:24:27 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1335', document_date = '2023-04-21', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '7.00', price_tax_excluded = '5.74', date_upd = NOW() WHERE id_document = '82916' 11/05/2023 05:24:27 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82916' 11/05/2023 05:24:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '82916' 11/05/2023 05:24:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82916' , '20537' , 'VESTINA BATTESIMALE - 101TCB' , '1' , '-1' , '1' , '4.5000' , '3.6885245901639' , '22' , '0' , '4.50' ) 11/05/2023 05:24:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82916' , '15055' , 'CROCE PADRE NOSTRO' , '1' , '-1' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '2.50' ) 11/05/2023 05:25:13 pm >> SELECT document_num FROM ps_document WHERE document_num = '61/A' AND id_document != '84273' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-05-11') 11/05/2023 05:25:13 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '61/A', document_date = '2023-05-11', document_letter = 'A', id_customer = '949', id_supplier = '', id_address = '4671033', address1 = 'VIA P. PALMIERI, 39 10138 TORINO', 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 = '151.20', price_tax_excluded = '151.20', date_upd = NOW() WHERE id_document = '84273' 11/05/2023 05:25:13 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 = '84273' 11/05/2023 05:25:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '84273' 11/05/2023 05:25:13 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 ( '84273' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '30' , '-30' , '4' , '2.8000' , '2.8' , '0' , '0' , '84.00' ) 11/05/2023 05:25:13 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 ( '84273' , '' , 'GIA\' INVIATI' , '1' , '-1' , '0' , '0' , '0' , '' , '0' , '0' ) 11/05/2023 05:25:13 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 ( '84273' , '15055' , 'CROCE PADRE NOSTRO' , '24' , '-24' , '0' , '2.80' , '2.8' , '' , '0' , '67.20' ) 11/05/2023 05:33:38 pm >> SELECT document_num FROM ps_document WHERE document_num = '1613' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-11') 11/05/2023 05:33:38 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1613' , '2023-05-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '83.84' , '78.07' , NOW() , NOW() ) 11/05/2023 05:33:38 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84280' 11/05/2023 05:33:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '84280' 11/05/2023 05:33:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84280' , '17580' , 'NUOVO MESSALINO PER RAGAZZI' , '16' , '-16' , '4' , '1.90' , '1.9' , '0' , '5' , '28.96' ) 11/05/2023 05:33:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84280' , '14487' , 'PREGHIERA DELLE 5 DITA' , '16' , '-16' , '4' , '1.5' , '1.5' , '0' , '5' , '22.88' ) 11/05/2023 05:33:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84280' , '11683' , 'CROCE CON COLOMBA E LACCIO - 0872/09' , '16' , '-16' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '32.00' ) 11/05/2023 06:02:10 pm >> SELECT document_num FROM ps_document WHERE document_num = '1614' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-11') 11/05/2023 06:02:10 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' , '1614' , '2023-05-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.20' , '15.20' , NOW() , NOW() ) 11/05/2023 06:02:10 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 = '84281' 11/05/2023 06:02:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '84281' 11/05/2023 06:02:10 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 ( '84281' , '20928' , 'CHI E MARIA? - C. MAGGIONI' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 11/05/2023 06:05:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '1615' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-11') 11/05/2023 06:05: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' , '1615' , '2023-05-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '47.00' , '41.50' , NOW() , NOW() ) 11/05/2023 06:05: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 = '84282' 11/05/2023 06:05:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '84282' 11/05/2023 06:05: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 ( '84282' , '16446' , 'LOURDES ROSARIO DI S. BERNARDETTE - 8981' , '2' , '-2' , '4' , '3.00' , '3' , '0' , '5' , '5.70' ) 11/05/2023 06:05: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 ( '84282' , '19753' , 'INCENSO GLORIA' , '1' , '-1' , '1' , '15.50' , '12.704918032787' , '22' , '0' , '15.50' ) 11/05/2023 06:05: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 ( '84282' , '10712' , 'TRATTATO DELLA VERA DEVOZIONE A MARIA - 8113' , '1' , '-1' , '4' , '9.00' , '9' , '0' , '5' , '8.55' ) 11/05/2023 06:05: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 ( '84282' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '2.25' , '2.25' , '0' , '0' , '2.25' ) 11/05/2023 06:05: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 ( '84282' , '12613' , 'TURIBOLO 10 CM' , '1' , '-1' , '1' , '15.00' , '12.295081967213' , '22' , '0' , '15.00' ) 11/05/2023 06:32:34 pm >> SELECT document_num FROM ps_document WHERE document_num = '1616' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-11') 11/05/2023 06:32:34 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1616' , '2023-05-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '18.00' , '14.75' , NOW() , NOW() ) 11/05/2023 06:32:34 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84283' 11/05/2023 06:32:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '84283' 11/05/2023 06:32:34 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 ( '84283' , '16061' , 'MEDAGLIA S. RITA- FM022' , '60' , '-60' , '1' , '0.30' , '0.24590163934426' , '22' , '0' , '18.00' ) 11/05/2023 07:06:48 pm >> SELECT document_num FROM ps_document WHERE document_num = '1617' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-11') 11/05/2023 07:06:48 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1617' , '2023-05-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '52.00' , '42.62' , NOW() , NOW() ) 11/05/2023 07:06: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 = '84284' 11/05/2023 07:06:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '84284' 11/05/2023 07:06: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 ( '84284' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '45' , '36.885245901639' , '22' , '0' , '45.00' ) 11/05/2023 07:06: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 ( '84284' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '7' , '5.7377049180328' , '22' , '0' , '7.00' ) 11/05/2023 07:26:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '1618' AND id_document != '' AND id_document_type LIKE '14' AND YEAR(document_date) = YEAR('2023-05-11') 11/05/2023 07:26:15 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' , '1618' , '2023-05-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '37.00' , '30.33' , NOW() , NOW() ) 11/05/2023 07:26:15 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84285' 11/05/2023 07:26:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '84285' 11/05/2023 07:26:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84285' , '19395' , 'CLERGY MISTO COTONE ML - C01' , '1' , '-1' , '1' , '37.00' , '30.327868852459' , '22' , '0' , '37.00' ) 11/05/2023 07:28:47 pm >> SELECT document_num FROM ps_document WHERE document_num = '1619' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-11') 11/05/2023 07:28:47 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1619' , '2023-05-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '49.35' , '46.10' , NOW() , NOW() ) 11/05/2023 07:28:47 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84286' 11/05/2023 07:28:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '84286' 11/05/2023 07:28:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84286' , '18222' , 'ROSARIO COLORATO - R316' , '18' , '-18' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '12.60' ) 11/05/2023 07:28:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84286' , '13504' , 'SACRAMENTO DELLA RICONCILIAZIONE RAGAZZI' , '18' , '-18' , '1' , '0.30' , '0.24590163934426' , '22' , '0' , '5.40' ) 11/05/2023 07:28:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84286' , '19550' , 'PAROLA AI GIOVANI - L. AMENDOLAGINE' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 11/05/2023 07:28:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84286' , '20975' , 'DOTTRINA SOCIALE DELLA CHIESA - G. COMOLLI' , '1' , '-1' , '4' , '17.00' , '17' , '0' , '5' , '16.15' ) 11/05/2023 07:34:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '1617' AND id_document != '84284' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-11') 11/05/2023 07:34:39 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1617', document_date = '2023-05-11', 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 = '52.00', price_tax_excluded = '42.62', date_upd = NOW() WHERE id_document = '84284' 11/05/2023 07:34:39 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84284' 11/05/2023 07:34:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '84284' 11/05/2023 07:34:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84284' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '45.0000' , '36.885245901639' , '22' , '0' , '45.00' ) 11/05/2023 07:34:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84284' , '205' , 'ACCONCIATURA CON NASTRINI' , '1' , '-1' , '1' , '7' , '5.7377049180328' , '22' , '0' , '7.00' ) 11/05/2023 07:43:37 pm >> SELECT document_num FROM ps_document WHERE document_num = '1620' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-11') 11/05/2023 07:43:37 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' , '1620' , '2023-05-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.00' , '15.57' , NOW() , NOW() ) 11/05/2023 07:43:37 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 = '84287' 11/05/2023 07:43:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '84287' 11/05/2023 07:43:37 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 ( '84287' , '19314' , 'CROCE ARGENTATA CRESIMA - 1316/K0050' , '5' , '-5' , '1' , '3.80' , '3.1147540983607' , '22' , '0' , '19.00' ) 11/05/2023 08:01:06 pm >> SELECT document_num FROM ps_document WHERE document_num = '1621' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-11') 11/05/2023 08:01: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' , '1621' , '2023-05-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '109.10' , '90.56' , NOW() , NOW() ) 11/05/2023 08:01: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 = '84288' 11/05/2023 08:01:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '84288' 11/05/2023 08:01: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 ( '84288' , '20515' , 'DECINA ULIVO - 04/7-D' , '100' , '-100' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '50.00' ) 11/05/2023 08:01: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 ( '84288' , '13335' , 'COLOMBA CON LACCIO' , '16' , '-16' , '1' , '1.60' , '1.3114754098361' , '22' , '0' , '25.60' ) 11/05/2023 08:01: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 ( '84288' , '7914' , 'PERGAMENE - 1A COMUNIONE MOD. C' , '20' , '-20' , '1' , '0.30' , '0.24590163934426' , '22' , '0' , '6.00' ) 11/05/2023 08:01: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 ( '84288' , '7917' , 'PERGAMENE - 1A RICONCILIAZIONE MOD. B' , '30' , '-30' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '15.00' ) 11/05/2023 08:01: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 ( '84288' , '7935' , 'PERGAMENE - CRESIMA MOD. B' , '15' , '-15' , '1' , '0.30' , '0.24590163934426' , '22' , '0' , '4.50' ) 11/05/2023 08:01: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 ( '84288' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '2' , '-2' , '3' , '4.00' , '3.8461538461538' , '4' , '0' , '8.00' )