26/07/2022 09:22:04 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 26/07/2022 09:22:05 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19805' , '1' , '' , 'nuovo-prodotto' ) 26/07/2022 09:22:05 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '19805' , '1' , '1' , '2' , NOW() , NOW() ) 26/07/2022 09:22:05 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '19805' , '0' , '1' , '0' , '0' ) 26/07/2022 09:23:42 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831555692' AND id_product != '19805' AND ean13 != '' 26/07/2022 09:23:42 am >> UPDATE ps_product SET id_supplier = '', reference = '14', ean13 = '9788831555692', date_upd = NOW() WHERE id_product = '19805' 26/07/2022 09:23:42 am >> UPDATE ps_product_lang SET name = 'desiderio desideravi', description = '' WHERE id_product = '19805' 26/07/2022 09:23:42 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '2' WHERE id_product = '19805' 26/07/2022 09:23:42 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '2', id_tax_rules_group = '4', id_category_default = '27', id_argoment_default = '69', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19805' 26/07/2022 09:23:42 am >> DELETE FROM ps_specific_price WHERE id_product = '19805' 26/07/2022 09:23:49 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '19805' 26/07/2022 09:23:49 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19806' , '1' , '' , 'nuovo-prodotto' ) 26/07/2022 09:23:49 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '19806' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19805' 26/07/2022 09:23:50 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19806' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19805' 26/07/2022 09:25:00 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801068061' AND id_product != '19806' AND ean13 != '' 26/07/2022 09:25:00 am >> UPDATE ps_product SET id_supplier = '', reference = '2/3', ean13 = '9788801068061', date_upd = NOW() WHERE id_product = '19806' 26/07/2022 09:25:00 am >> UPDATE ps_product_lang SET name = 'AGENDA DEL CATECHISTA 2022-2023', description = '' WHERE id_product = '19806' 26/07/2022 09:25:00 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '1.5' WHERE id_product = '19806' 26/07/2022 09:25:00 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '1.5', id_tax_rules_group = '4', id_category_default = '19', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19806' 26/07/2022 09:25:00 am >> DELETE FROM ps_specific_price WHERE id_product = '19806' 26/07/2022 09:25:03 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 = '19806' 26/07/2022 09:25:03 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19807' , '1' , '' , 'nuovo-prodotto' ) 26/07/2022 09:25:03 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 '19807' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19806' 26/07/2022 09:25:03 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19807' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19806' 26/07/2022 09:30:24 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801068009' AND id_product != '19807' AND ean13 != '' 26/07/2022 09:30:24 am >> UPDATE ps_product SET id_supplier = '', reference = '1/2', ean13 = '9788801068009', date_upd = NOW() WHERE id_product = '19807' 26/07/2022 09:30:24 am >> UPDATE ps_product_lang SET name = 'GIOVANI FEDE, VOCAZIONE... - AAVV', description = '' WHERE id_product = '19807' 26/07/2022 09:30:24 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '18' WHERE id_product = '19807' 26/07/2022 09:30:24 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '18', id_tax_rules_group = '4', id_category_default = '19', id_argoment_default = '75', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19807' 26/07/2022 09:30:24 am >> DELETE FROM ps_specific_price WHERE id_product = '19807' 26/07/2022 09:32:36 am >> SELECT document_num FROM ps_document WHERE document_num = '2159' AND id_document != '59036' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-04') 26/07/2022 09:32:36 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2159', document_date = '2022-07-04', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = 'P.ZZA DUOMO, 1 84096 MONTECORVINO ROVELLA', 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 = '314.00', price_tax_excluded = '276.82', date_upd = NOW() WHERE id_document = '59036' 26/07/2022 09:32:36 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 = '59036' 26/07/2022 09:32:36 am >> DELETE FROM ps_document_detail WHERE id_document = '59036' 26/07/2022 09:32:36 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 ( '59036' , '2777' , 'CORONCINA E NOVENA ALLA DIVINA MISERICORDIA' , '10' , '-10' , '4' , '2.0000' , '2' , '0' , '5' , '19.00' ) 26/07/2022 09:32:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '2777' AND id_supplier = '' 26/07/2022 09:32:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2777' , '' , '1' ) 26/07/2022 09:32:36 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 ( '59036' , '17526' , 'PREGHIERE EUCARISTICHE PER CONCELEBRAZIONE N.E.' , '4' , '-4' , '4' , '6.0000' , '6' , '0' , '5' , '22.80' ) 26/07/2022 09:32:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '17526' AND id_supplier = '' 26/07/2022 09:32:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17526' , '' , '1' ) 26/07/2022 09:32:36 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 ( '59036' , '7311' , 'OSTIA SOTTILE 74MM' , '14' , '-14' , '3' , '1.9000' , '1.8269230769231' , '4' , '0' , '26.60' ) 26/07/2022 09:32:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 26/07/2022 09:32:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 26/07/2022 09:32:36 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 ( '59036' , '7673' , 'PARTICOLE MM38' , '7' , '-7' , '3' , '3.0000' , '2.8846153846154' , '4' , '0' , '21.00' ) 26/07/2022 09:32:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '7673' AND id_supplier = '' 26/07/2022 09:32:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7673' , '' , '1' ) 26/07/2022 09:32:36 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 ( '59036' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '2' , '-2' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '7.00' ) 26/07/2022 09:32:37 am >> DELETE FROM ps_product_supplier WHERE id_product = '16691' AND id_supplier = '' 26/07/2022 09:32:37 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16691' , '' , '1' ) 26/07/2022 09:32:37 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 ( '59036' , '15666' , 'MIRACOLOSA CM 60' , '1' , '-1' , '1' , '180.0000' , '147.54098360656' , '22' , '0' , '180.00' ) 26/07/2022 09:32:37 am >> DELETE FROM ps_product_supplier WHERE id_product = '15666' AND id_supplier = '' 26/07/2022 09:32:37 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15666' , '' , '1' ) 26/07/2022 09:32:37 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 ( '59036' , '3073' , 'CROCE PRIMA COMUNIONE - LEGNO SCURO - 713/15' , '10' , '-10' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '12.00' ) 26/07/2022 09:32:37 am >> DELETE FROM ps_product_supplier WHERE id_product = '3073' AND id_supplier = '' 26/07/2022 09:32:37 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3073' , '' , '1' ) 26/07/2022 09:32:37 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 ( '59036' , '19662' , 'MESSALINO QUOTIDIANO - AGO/SET/OTT 2022' , '1' , '-1' , '4' , '4.1' , '4.1' , '0' , '0' , '4.10' ) 26/07/2022 09:32:37 am >> DELETE FROM ps_product_supplier WHERE id_product = '19662' AND id_supplier = '' 26/07/2022 09:32:37 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19662' , '' , '1' ) 26/07/2022 09:32:37 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 ( '59036' , '16689' , 'OSTIA PAN DI CENA mm80' , '6' , '-6' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '12.00' ) 26/07/2022 09:32:37 am >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = '' 26/07/2022 09:32:37 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '' , '1' ) 26/07/2022 09:32:37 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 ( '59036' , '19622' , 'SULLA TUA PAROLA - SETT/OTT 2022' , '2' , '-2' , '4' , '5.0000' , '5' , '0' , '5' , '9.50' ) 26/07/2022 09:32:37 am >> DELETE FROM ps_product_supplier WHERE id_product = '19622' AND id_supplier = '' 26/07/2022 09:32:37 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19622' , '' , '1' ) 26/07/2022 09:33:05 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 26/07/2022 09:33:05 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19808' , '1' , '' , 'nuovo-prodotto' ) 26/07/2022 09:33:05 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '19808' , '1' , '1' , '2' , NOW() , NOW() ) 26/07/2022 09:33:05 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '19808' , '0' , '1' , '0' , '0' ) 26/07/2022 09:36:42 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801068108' AND id_product != '19808' AND ean13 != '' 26/07/2022 09:36:42 am >> UPDATE ps_product SET id_supplier = '', reference = '1/2', ean13 = '9788801068108', date_upd = NOW() WHERE id_product = '19808' 26/07/2022 09:36:42 am >> UPDATE ps_product_lang SET name = 'A MESSA CON I PICCOLI - S. DE MULLENHEIM', description = '' WHERE id_product = '19808' 26/07/2022 09:36:42 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '4.9' WHERE id_product = '19808' 26/07/2022 09:36:42 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '4.9', id_tax_rules_group = '4', id_category_default = '19', id_argoment_default = '86', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19808' 26/07/2022 09:36:42 am >> DELETE FROM ps_specific_price WHERE id_product = '19808' 26/07/2022 09:36:43 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '19808' 26/07/2022 09:36:43 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19809' , '1' , '' , 'nuovo-prodotto' ) 26/07/2022 09:36:43 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '19809' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19808' 26/07/2022 09:36:43 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19809' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19808' 26/07/2022 09:38:52 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801068092' AND id_product != '2464' AND ean13 != '' 26/07/2022 09:38:52 am >> UPDATE ps_product SET id_supplier = '7', reference = '1/2', ean13 = '9788801068092', date_upd = NOW() WHERE id_product = '2464' 26/07/2022 09:38:52 am >> UPDATE ps_product_lang SET name = 'COME ANIMARE IL GRUPPO DI CATECHESI - G. MARCHIONI', description = '' WHERE id_product = '2464' 26/07/2022 09:38:52 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '6.9' WHERE id_product = '2464' 26/07/2022 09:38:52 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '6.9', id_tax_rules_group = '4', id_category_default = '19', 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 = '2464' 26/07/2022 09:38:52 am >> DELETE FROM ps_specific_price WHERE id_product = '2464' 26/07/2022 09:39:01 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '2464' 26/07/2022 09:39:01 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19810' , '1' , '' , 'nuovo-prodotto' ) 26/07/2022 09:39:01 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 '19810' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '2464' 26/07/2022 09:39:01 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19810' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '2464' 26/07/2022 09:40:26 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892229228' AND id_product != '19810' AND ean13 != '' 26/07/2022 09:40:26 am >> UPDATE ps_product SET id_supplier = '', reference = '1/4', ean13 = '9788892229228', date_upd = NOW() WHERE id_product = '19810' 26/07/2022 09:40:26 am >> UPDATE ps_product_lang SET name = 'QUELLA STANA COPPIA ', description = '' WHERE id_product = '19810' 26/07/2022 09:40:26 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '10' WHERE id_product = '19810' 26/07/2022 09:40:26 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '10', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '134', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19810' 26/07/2022 09:40:26 am >> DELETE FROM ps_specific_price WHERE id_product = '19810' 26/07/2022 09:40:32 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 = '19810' 26/07/2022 09:40:32 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19811' , '1' , '' , 'nuovo-prodotto' ) 26/07/2022 09:40:32 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 '19811' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19810' 26/07/2022 09:40:32 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19811' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19810' 26/07/2022 09:41:08 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8051739455700' AND id_product != '19811' AND ean13 != '' 26/07/2022 09:41:08 am >> UPDATE ps_product SET id_supplier = '', reference = 'BANCO', ean13 = '8051739455700', date_upd = NOW() WHERE id_product = '19811' 26/07/2022 09:41:08 am >> UPDATE ps_product_lang SET name = 'AGENDINA 2023', description = '' WHERE id_product = '19811' 26/07/2022 09:41:08 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0.9' WHERE id_product = '19811' 26/07/2022 09:41:08 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0.9', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '107', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19811' 26/07/2022 09:41:08 am >> DELETE FROM ps_specific_price WHERE id_product = '19811' 26/07/2022 09:41:09 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 = '19811' 26/07/2022 09:41:09 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19812' , '1' , '' , 'nuovo-prodotto' ) 26/07/2022 09:41:09 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 '19812' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19811' 26/07/2022 09:41:09 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19812' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19811' 26/07/2022 09:42:10 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892228313' AND id_product != '19812' AND ean13 != '' 26/07/2022 09:42:10 am >> UPDATE ps_product SET id_supplier = '', reference = '6/1', ean13 = '9788892228313', date_upd = NOW() WHERE id_product = '19812' 26/07/2022 09:42:10 am >> UPDATE ps_product_lang SET name = 'IO SONO LA POLVERE - GIOVANNI PAOLO I', description = '' WHERE id_product = '19812' 26/07/2022 09:42:10 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '39' WHERE id_product = '19812' 26/07/2022 09:42:10 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '39', id_tax_rules_group = '4', id_category_default = '30', 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 = '19812' 26/07/2022 09:42:10 am >> DELETE FROM ps_specific_price WHERE id_product = '19812' 26/07/2022 09:42:12 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 = '19812' 26/07/2022 09:42:12 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19813' , '1' , '' , 'nuovo-prodotto' ) 26/07/2022 09:42:12 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 '19813' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19812' 26/07/2022 09:42:12 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19813' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19812' 26/07/2022 09:42:39 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8051739455236' AND id_product != '19813' AND ean13 != '' 26/07/2022 09:42:39 am >> UPDATE ps_product SET id_supplier = '', reference = '10/2', ean13 = '8051739455236', date_upd = NOW() WHERE id_product = '19813' 26/07/2022 09:42:39 am >> UPDATE ps_product_lang SET name = 'INSIEME NELLA MESSA - OTT. 2022', description = '' WHERE id_product = '19813' 26/07/2022 09:42:39 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '1.8' WHERE id_product = '19813' 26/07/2022 09:42:39 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '1.8', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '64', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19813' 26/07/2022 09:42:39 am >> DELETE FROM ps_specific_price WHERE id_product = '19813' 26/07/2022 09:42: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 = '19813' 26/07/2022 09:42:40 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19814' , '1' , '' , 'nuovo-prodotto' ) 26/07/2022 09:42: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 '19814' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19813' 26/07/2022 09:42:40 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19814' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19813' 26/07/2022 09:44:37 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831278645' AND id_product != '19814' AND ean13 != '' 26/07/2022 09:44:38 am >> UPDATE ps_product SET id_supplier = '', reference = '13/3', ean13 = '9788831278645', date_upd = NOW() WHERE id_product = '19814' 26/07/2022 09:44:38 am >> UPDATE ps_product_lang SET name = 'RADICE DELL\'AMORE - CHARLES DE FOUCAULD', description = '' WHERE id_product = '19814' 26/07/2022 09:44:38 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '9.5' WHERE id_product = '19814' 26/07/2022 09:44:38 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '9.5', id_tax_rules_group = '4', id_category_default = '97', 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 = '19814' 26/07/2022 09:44:38 am >> DELETE FROM ps_specific_price WHERE id_product = '19814' 26/07/2022 09:44:39 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '19814' 26/07/2022 09:44:39 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19815' , '1' , '' , 'nuovo-prodotto' ) 26/07/2022 09:44:39 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '19815' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19814' 26/07/2022 09:44:39 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19815' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19814' 26/07/2022 09:46:09 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788832047714' AND id_product != '19815' AND ean13 != '' 26/07/2022 09:46:09 am >> UPDATE ps_product SET id_supplier = '', reference = '1/5', ean13 = '9788832047714', date_upd = NOW() WHERE id_product = '19815' 26/07/2022 09:46:09 am >> UPDATE ps_product_lang SET name = 'PERCHE\' LA NOSTRA GIOIA SIA PIENA', description = '' WHERE id_product = '19815' 26/07/2022 09:46:09 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3.3' WHERE id_product = '19815' 26/07/2022 09:46:09 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3.3', id_tax_rules_group = '4', id_category_default = '57', id_argoment_default = '145', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19815' 26/07/2022 09:46:09 am >> DELETE FROM ps_specific_price WHERE id_product = '19815' 26/07/2022 09:47:02 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831555692' AND id_product != '19805' AND ean13 != '' 26/07/2022 09:47:02 am >> UPDATE ps_product SET id_supplier = '', reference = '14', ean13 = '9788831555692', date_upd = NOW() WHERE id_product = '19805' 26/07/2022 09:47:02 am >> UPDATE ps_product_lang SET name = 'DESIDERIO DESIDERAVI', description = '' WHERE id_product = '19805' 26/07/2022 09:47:02 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '2.0000' WHERE id_product = '19805' 26/07/2022 09:47:02 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '2.0000', id_tax_rules_group = '4', id_category_default = '27', id_argoment_default = '69', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19805' 26/07/2022 09:47:02 am >> DELETE FROM ps_specific_price WHERE id_product = '19805' 26/07/2022 09:50:52 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '605243' , '2022-07-19' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '4.33' , '4' , '0' , '0' , '0' , '' , '11' , '0' , '147.63' , '147.63' , NOW() , NOW() ) 26/07/2022 09:50:52 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '59801' 26/07/2022 09:50:52 am >> DELETE FROM ps_document_detail WHERE id_document = '59801' 26/07/2022 09:50:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59801' , '19805' , 'DESIDERIO DESIDERAVI' , '36' , '36' , '4' , '2.00' , '2' , '0' , '33' , '48.2400' ) 26/07/2022 09:50:52 am >> DELETE FROM ps_product_supplier WHERE id_product = '19805' AND id_supplier = '7' 26/07/2022 09:50:52 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19805' , '7' , '1' ) 26/07/2022 09:50:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59801' , '19805' , 'DESIDERIO DESIDERAVI' , '3' , '3' , '4' , '2.00' , '2' , '0' , '100' , '0.0000' ) 26/07/2022 09:50:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '19805' AND id_supplier = '7' 26/07/2022 09:50:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19805' , '7' , '1' ) 26/07/2022 09:50:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59801' , '19806' , 'AGENDA DEL CATECHISTA 2022-2023' , '12' , '12' , '4' , '1.50' , '1.5' , '0' , '35' , '11.7000' ) 26/07/2022 09:50:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '19806' AND id_supplier = '7' 26/07/2022 09:50:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19806' , '7' , '1' ) 26/07/2022 09:50:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59801' , '19806' , 'AGENDA DEL CATECHISTA 2022-2023' , '1' , '1' , '4' , '1.50' , '1.5' , '0' , '100' , '0.0000' ) 26/07/2022 09:50:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '19806' AND id_supplier = '7' 26/07/2022 09:50:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19806' , '7' , '1' ) 26/07/2022 09:50:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59801' , '2464' , 'COME ANIMARE IL GRUPPO DI CATECHESI - G. MARCHIONI' , '1' , '1' , '4' , '6.90' , '6.9' , '0' , '35' , '4.4850' ) 26/07/2022 09:50:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '2464' AND id_supplier = '7' 26/07/2022 09:50:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2464' , '7' , '1' ) 26/07/2022 09:50:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59801' , '19808' , 'A MESSA CON I PICCOLI - S. DE MULLENHEIM' , '3' , '3' , '4' , '4.90' , '4.9' , '0' , '35' , '9.5550' ) 26/07/2022 09:50:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '19808' AND id_supplier = '7' 26/07/2022 09:50:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19808' , '7' , '1' ) 26/07/2022 09:50:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59801' , '19807' , 'GIOVANI FEDE, VOCAZIONE... - AAVV' , '1' , '1' , '4' , '18.00' , '18' , '0' , '35' , '11.7000' ) 26/07/2022 09:50:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '19807' AND id_supplier = '7' 26/07/2022 09:50:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19807' , '7' , '1' ) 26/07/2022 09:50:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59801' , '19812' , 'IO SONO LA POLVERE - GIOVANNI PAOLO I' , '1' , '1' , '4' , '39.00' , '39' , '0' , '33' , '26.1300' ) 26/07/2022 09:50:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '19812' AND id_supplier = '7' 26/07/2022 09:50:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19812' , '7' , '1' ) 26/07/2022 09:50:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59801' , '19813' , 'INSIEME NELLA MESSA - OTT. 2022' , '1' , '1' , '4' , '1.80' , '1.8' , '0' , '33' , '1.2060' ) 26/07/2022 09:50:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '19813' AND id_supplier = '7' 26/07/2022 09:50:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19813' , '7' , '1' ) 26/07/2022 09:50:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59801' , '19815' , 'PERCHE LA NOSTRA GIOIA SIA PIENA' , '1' , '1' , '4' , '3.30' , '3.3' , '0' , '30' , '2.3100' ) 26/07/2022 09:50:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '19815' AND id_supplier = '7' 26/07/2022 09:50:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19815' , '7' , '1' ) 26/07/2022 09:50:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59801' , '19814' , 'RADICE DELLAMORE - CHARLES DE FOUCAULD' , '1' , '1' , '4' , '9.50' , '9.5' , '0' , '30' , '6.6500' ) 26/07/2022 09:50:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '19814' AND id_supplier = '7' 26/07/2022 09:50:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19814' , '7' , '1' ) 26/07/2022 09:50:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59801' , '19810' , 'QUELLA STANA COPPIA ' , '1' , '1' , '4' , '10.00' , '10' , '0' , '33' , '6.7000' ) 26/07/2022 09:50:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '19810' AND id_supplier = '7' 26/07/2022 09:50:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19810' , '7' , '1' ) 26/07/2022 09:50:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59801' , '19811' , 'AGENDINA 2023' , '25' , '25' , '4' , '0.90' , '0.9' , '0' , '35' , '14.6250' ) 26/07/2022 09:50:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '19811' AND id_supplier = '7' 26/07/2022 09:50:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19811' , '7' , '1' ) 26/07/2022 10:10:11 am >> DELETE FROM ps_document WHERE id_document = '59079' 26/07/2022 10:10:11 am >> DELETE FROM ps_document_detail WHERE id_document = '59079' 26/07/2022 10:11:04 am >> SELECT document_num FROM ps_document WHERE document_num = '2364' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-26') 26/07/2022 10:11:04 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2364' , '2022-07-26' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '177.10' , '152.79' , NOW() , NOW() ) 26/07/2022 10:11:04 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '59802' 26/07/2022 10:11:04 am >> DELETE FROM ps_document_detail WHERE id_document = '59802' 26/07/2022 10:11:04 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59802' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '8' , '-8' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '28.00' ) 26/07/2022 10:11:05 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 26/07/2022 10:11:05 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 26/07/2022 10:11:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59802' , '17160' , 'CARBONCINI ROSSI - CARRO' , '2' , '-2' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '20.00' ) 26/07/2022 10:11:05 am >> DELETE FROM ps_product_supplier WHERE id_product = '17160' AND id_supplier = '' 26/07/2022 10:11:05 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17160' , '' , '1' ) 26/07/2022 10:11:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59802' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 26/07/2022 10:11:05 am >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = '' 26/07/2022 10:11:05 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '' , '1' ) 26/07/2022 10:11:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59802' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3' , '2.4590163934426' , '22' , '0' , '90.00' ) 26/07/2022 10:11:05 am >> DELETE FROM ps_product_supplier WHERE id_product = '5903' AND id_supplier = '' 26/07/2022 10:11:05 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5903' , '' , '1' ) 26/07/2022 10:11:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59802' , '17868' , '100 OMELIE ANGELO COMASTRI' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '5' , '17.10' ) 26/07/2022 10:11:05 am >> DELETE FROM ps_product_supplier WHERE id_product = '17868' AND id_supplier = '' 26/07/2022 10:11:05 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17868' , '' , '1' ) 26/07/2022 10:11:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59802' , '18664' , 'BRACCIALE ARG. E CAUCCIU - 7655' , '1' , '-1' , '1' , '18.00' , '14.754098360656' , '22' , '0' , '18.00' ) 26/07/2022 10:11:05 am >> DELETE FROM ps_product_supplier WHERE id_product = '18664' AND id_supplier = '' 26/07/2022 10:11:05 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18664' , '' , '1' ) 26/07/2022 10:21:11 am >> SELECT document_num FROM ps_document WHERE document_num = '2365' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-26') 26/07/2022 10:21: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' , '2365' , '2022-07-26' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '72.20' , '72.20' , NOW() , NOW() ) 26/07/2022 10:21: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 = '59803' 26/07/2022 10:21:11 am >> DELETE FROM ps_document_detail WHERE id_document = '59803' 26/07/2022 10:21: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 ( '59803' , '12055' , 'VANGELI APOCRIFI - II/2' , '1' , '-1' , '4' , '32.00' , '32' , '0' , '5' , '30.40' ) 26/07/2022 10:21:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '12055' AND id_supplier = '' 26/07/2022 10:21:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12055' , '' , '1' ) 26/07/2022 10:21: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 ( '59803' , '11006' , 'VANGELI APOCRIFI II/I' , '1' , '-1' , '4' , '30.00' , '30' , '0' , '5' , '28.50' ) 26/07/2022 10:21:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '11006' AND id_supplier = '' 26/07/2022 10:21:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11006' , '' , '1' ) 26/07/2022 10:21:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59803' , '14903' , 'VANGELI APOCRIFI- M. COLAVITA' , '1' , '-1' , '4' , '14.00' , '14' , '0' , '5' , '13.30' ) 26/07/2022 10:21:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '14903' AND id_supplier = '' 26/07/2022 10:21:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14903' , '' , '1' ) 26/07/2022 10:33:15 am >> SELECT document_num FROM ps_document WHERE document_num = '2366' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-26') 26/07/2022 10:33:15 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' , '2366' , '2022-07-26' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '138.00' , '115.95' , NOW() , NOW() ) 26/07/2022 10:33:15 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 = '59804' 26/07/2022 10:33:15 am >> DELETE FROM ps_document_detail WHERE id_document = '59804' 26/07/2022 10:33:15 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 ( '59804' , '7202' , 'ARTICOLI RELIGIOSI' , '4' , '-4' , '1' , '3.7' , '3.0327868852459' , '22' , '0' , '14.80' ) 26/07/2022 10:33:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 26/07/2022 10:33:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 26/07/2022 10:33:15 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 ( '59804' , '7202' , 'ARTICOLI RELIGIOSI' , '6' , '-6' , '1' , '2.2' , '1.8032786885246' , '22' , '0' , '13.20' ) 26/07/2022 10:33:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 26/07/2022 10:33:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 26/07/2022 10:33:15 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 ( '59804' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '5' , '-5' , '3' , '4.00' , '3.8461538461538' , '4' , '0' , '20.00' ) 26/07/2022 10:33:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '16691' AND id_supplier = '' 26/07/2022 10:33:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16691' , '' , '1' ) 26/07/2022 10:33:15 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 ( '59804' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3' , '2.4590163934426' , '22' , '0' , '90.00' ) 26/07/2022 10:33:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '5903' AND id_supplier = '' 26/07/2022 10:33:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5903' , '' , '1' ) 26/07/2022 11:06:53 am >> INSERT INTO ps_supplier ( name , email , `date_add` , `date_upd` ) VALUES ( '' , '' , NOW() , NOW() ) 26/07/2022 11:06:53 am >> INSERT INTO ps_supplier_shop ( id_supplier , id_shop ) VALUES ( '130' , '1' ) 26/07/2022 11:06:53 am >> INSERT INTO ps_supplier_lang ( id_supplier , id_lang ) VALUES ( '130' , '1' ) 26/07/2022 11:06:53 am >> INSERT INTO ps_address ( id_supplier , id_country , id_state , alias , lastname , firstname , address1 , city , date_add , date_upd ) VALUES ( '130' , '10' , '0' , '' , '' , '' , '' , '' , NOW() , NOW() ) 26/07/2022 12:40:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '2367' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-26') 26/07/2022 12:40:46 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2367' , '2022-07-26' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '94.90' , '77.79' , NOW() , NOW() ) 26/07/2022 12:40:46 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '59805' 26/07/2022 12:40:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '59805' 26/07/2022 12:40:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59805' , '14773' , 'BRACCIALE RIGATO - 0825N' , '73' , '-73' , '1' , '1.30' , '1.0655737704918' , '22' , '0' , '94.90' ) 26/07/2022 12:40:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14773' AND id_supplier = '' 26/07/2022 12:40:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14773' , '' , '1' ) 26/07/2022 12:40:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59805' , '14773' , 'BRACCIALE RIGATO - 0825N' , '2' , '-2' , '1' , '1.30' , '1.0655737704918' , '22' , '100' , '0.00' ) 26/07/2022 12:40:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14773' AND id_supplier = '' 26/07/2022 12:40:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14773' , '' , '1' ) 26/07/2022 02:52:53 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 26/07/2022 02:52:53 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19816' , '1' , '' , 'nuovo-prodotto' ) 26/07/2022 02:52:53 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '19816' , '1' , '1' , '2' , NOW() , NOW() ) 26/07/2022 02:52:53 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '19816' , '0' , '1' , '0' , '0' ) 26/07/2022 02:53:59 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788826427171' AND id_product != '19816' AND ean13 != '' 26/07/2022 02:53:59 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788826427171', date_upd = NOW() WHERE id_product = '19816' 26/07/2022 02:53:59 pm >> UPDATE ps_product_lang SET name = 'PASTORI DI UNA CHIESA SINODALE', description = '' WHERE id_product = '19816' 26/07/2022 02:53:59 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '25' WHERE id_product = '19816' 26/07/2022 02:53:59 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '25', id_tax_rules_group = '4', id_category_default = '104', id_argoment_default = '141', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19816' 26/07/2022 02:53:59 pm >> DELETE FROM ps_specific_price WHERE id_product = '19816' 26/07/2022 02:55:13 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' , '2317' , '2022-07-25' , '' , '0' , '79' , '2686' , 'CITTA\\\' DEL VATICANO 00120 CITTA\\\' DEL VATICANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '11' , '0' , '52.75' , '52.75' , NOW() , NOW() ) 26/07/2022 02:55: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 = '59806' 26/07/2022 02:55:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '59806' 26/07/2022 02:55:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59806' , '5764' , 'LEZIONARIO FERIALE ANNO PARI - TEMPO ORDINARIO' , '1' , '1' , '4' , '60.00' , '60' , '0' , '35' , '39.0000' ) 26/07/2022 02:55:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5764' AND id_supplier = '79' 26/07/2022 02:55:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5764' , '79' , '1' ) 26/07/2022 02:55:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59806' , '19816' , 'PASTORI DI UNA CHIESA SINODALE' , '1' , '1' , '4' , '25.00' , '25' , '0' , '45' , '13.7500' ) 26/07/2022 02:55:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19816' AND id_supplier = '79' 26/07/2022 02:55:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19816' , '79' , '1' ) 26/07/2022 03:37:52 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 26/07/2022 03:37:52 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19817' , '1' , '' , 'nuovo-prodotto' ) 26/07/2022 03:37:52 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '19817' , '1' , '1' , '2' , NOW() , NOW() ) 26/07/2022 03:37:52 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '19817' , '0' , '1' , '0' , '0' ) 26/07/2022 03:38:54 pm >> SELECT ean13 FROM ps_product WHERE ean13 = 'OF1-NERO' AND id_product != '19817' AND ean13 != '' 26/07/2022 03:38:54 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = 'OF1-NERO', date_upd = NOW() WHERE id_product = '19817' 26/07/2022 03:38:54 pm >> UPDATE ps_product_lang SET name = 'OFFERTORIO IN FERRO', description = '' WHERE id_product = '19817' 26/07/2022 03:38:54 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '303.27868852459017' WHERE id_product = '19817' 26/07/2022 03:38:54 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '303.27868852459017', id_tax_rules_group = '1', id_category_default = '474', 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 = '19817' 26/07/2022 03:38:54 pm >> DELETE FROM ps_specific_price WHERE id_product = '19817' 26/07/2022 03:38:55 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 = '19817' 26/07/2022 03:38:55 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19818' , '1' , '' , 'nuovo-prodotto' ) 26/07/2022 03:38:55 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 '19818' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19817' 26/07/2022 03:38:55 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19818' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19817' 26/07/2022 03:39:24 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '49/2022' , '2022-07-26' , '2022' , '0' , '147' , '4671058' , 'VIA NICOLA FIORENTINO, 57 80026 CASORIA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '201.30' , '165.00' , NOW() , NOW() ) 26/07/2022 03:39:24 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '59807' 26/07/2022 03:39:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '59807' 26/07/2022 03:39:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59807' , '19817' , 'OFFERTORIO IN FERRO' , '1' , '1' , '1' , '330' , '270.49180327869' , '22' , '50' , '201.3000' ) 26/07/2022 03:39:24 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19817' AND id_supplier = '147' 26/07/2022 03:39:24 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19817' , '147' , '1' ) 26/07/2022 04:13:34 pm >> DELETE FROM ps_document WHERE id_document = '59080' 26/07/2022 04:13:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '59080' 26/07/2022 04:14:23 pm >> SELECT document_num FROM ps_document WHERE document_num = '2368' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-26') 26/07/2022 04:14:23 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2368' , '2022-07-26' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '31.60' , '25.90' , NOW() , NOW() ) 26/07/2022 04:14:23 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '59808' 26/07/2022 04:14:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '59808' 26/07/2022 04:14:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59808' , '19109' , 'LUCERNA IN VETRO TRASPARENTE - DIAM. 10 - 1492' , '2' , '-2' , '1' , '15.80' , '12.950819672131' , '22' , '0' , '31.60' ) 26/07/2022 04:14:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19109' AND id_supplier = '' 26/07/2022 04:14:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19109' , '' , '1' ) 26/07/2022 05:33:47 pm >> SELECT document_num FROM ps_document WHERE document_num = '2369' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-26') 26/07/2022 05:33: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' , '2369' , '2022-07-26' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '90.00' , '73.77' , NOW() , NOW() ) 26/07/2022 05:33: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 = '59809' 26/07/2022 05:33:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '59809' 26/07/2022 05:33: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 ( '59809' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3' , '2.4590163934426' , '22' , '0' , '90.00' ) 26/07/2022 05:33:47 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5903' AND id_supplier = '' 26/07/2022 05:33:47 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5903' , '' , '1' ) 26/07/2022 06:51:37 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000856' AND id_product != '19818' AND ean13 != '' 26/07/2022 06:51:37 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '000856', date_upd = NOW() WHERE id_product = '19818' 26/07/2022 06:51:37 pm >> UPDATE ps_product_lang SET name = 'INCENSO NATURALE 3A KG 1', description = '' WHERE id_product = '19818' 26/07/2022 06:51:37 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '16.39344262295082' WHERE id_product = '19818' 26/07/2022 06:51:37 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '16.39344262295082', id_tax_rules_group = '1', id_category_default = '489', 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 = '19818' 26/07/2022 06:51:37 pm >> DELETE FROM ps_specific_price WHERE id_product = '19818' 26/07/2022 06:51:39 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 = '19818' 26/07/2022 06:51:39 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19819' , '1' , '' , 'nuovo-prodotto' ) 26/07/2022 06:51:39 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 '19819' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19818' 26/07/2022 06:51:39 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19819' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19818' 26/07/2022 06:52:21 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000857' AND id_product != '19819' AND ean13 != '' 26/07/2022 06:52:21 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '000857', date_upd = NOW() WHERE id_product = '19819' 26/07/2022 06:52:21 pm >> UPDATE ps_product_lang SET name = 'INCENSO NATURALE 1 ST GRADE - KG 1', description = '' WHERE id_product = '19819' 26/07/2022 06:52:22 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '20.491803278688526' WHERE id_product = '19819' 26/07/2022 06:52:22 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '20.491803278688526', id_tax_rules_group = '1', id_category_default = '489', 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 = '19819' 26/07/2022 06:52:22 pm >> DELETE FROM ps_specific_price WHERE id_product = '19819' 26/07/2022 06:52:22 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '19819' 26/07/2022 06:52:22 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19820' , '1' , '' , 'nuovo-prodotto' ) 26/07/2022 06:52:22 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '19820' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19819' 26/07/2022 06:52:22 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19820' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19819' 26/07/2022 06:53:39 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '774' , '2022-07-18' , '' , '0' , '157' , '4673300' , '10 AGIAS ANNIS STR 17778 ATHENS - GRECIA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '2323.00' , '2323.00' , NOW() , NOW() ) 26/07/2022 06:53: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 = '59810' 26/07/2022 06:53:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '59810' 26/07/2022 06:53: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 ( '59810' , '19099' , 'INCENSO A' , '30' , '30' , '0' , '18' , '18' , '' , '0' , '540.0000' ) 26/07/2022 06:53:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19099' AND id_supplier = '157' 26/07/2022 06:53:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19099' , '157' , '1' ) 26/07/2022 06:53: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 ( '59810' , '19100' , 'INCENSO B' , '26' , '26' , '0' , '8.5' , '8.5' , '' , '0' , '221.0000' ) 26/07/2022 06:53:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19100' AND id_supplier = '157' 26/07/2022 06:53:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19100' , '157' , '1' ) 26/07/2022 06:53: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 ( '59810' , '19101' , 'INCENSO C' , '24' , '24' , '0' , '6.5' , '6.5' , '' , '0' , '156.0000' ) 26/07/2022 06:53:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19101' AND id_supplier = '157' 26/07/2022 06:53:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19101' , '157' , '1' ) 26/07/2022 06:53:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59810' , '19107' , 'INCENSO GRANI 3A' , '60' , '60' , '0' , '8' , '8' , '' , '0' , '480.0000' ) 26/07/2022 06:53:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19107' AND id_supplier = '157' 26/07/2022 06:53:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19107' , '157' , '1' ) 26/07/2022 06:53:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59810' , '19818' , 'INCENSO NATURALE 3A KG 1' , '50' , '50' , '0' , '5.8' , '5.8' , '' , '0' , '290.0000' ) 26/07/2022 06:53:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19818' AND id_supplier = '157' 26/07/2022 06:53:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19818' , '157' , '1' ) 26/07/2022 06:53:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59810' , '19819' , 'INCENSO NATURALE 1 ST GRADE - KG 1' , '20' , '20' , '0' , '7.8' , '7.8' , '' , '0' , '156.0000' ) 26/07/2022 06:53:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19819' AND id_supplier = '157' 26/07/2022 06:53:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19819' , '157' , '1' ) 26/07/2022 06:53:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59810' , '19102' , 'CARBONCINI MM 40' , '60' , '60' , '0' , '4' , '4' , '' , '0' , '240.0000' ) 26/07/2022 06:53:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19102' AND id_supplier = '157' 26/07/2022 06:53:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19102' , '157' , '1' ) 26/07/2022 06:53:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59810' , '10133' , 'SPESE DI TRASPORTO' , '1' , '1' , '4' , '240' , '240' , '0' , '0' , '240.0000' ) 26/07/2022 06:53:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '10133' AND id_supplier = '157' 26/07/2022 06:53:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10133' , '157' , '1' )