19/07/2022 08:45:12 am >> UPDATE ps_document SET id_document_type = '31', document_num = '292', document_date = '2022-07-18', document_letter = '', id_customer = '0', id_supplier = '', id_address = '4669176', address1 = 'VIALE EUROPA, 102 36075 MONTECCHIO MAGGIORE', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '1', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '606.50', price_tax_excluded = '497.13', date_upd = NOW() WHERE id_document = '59112' 19/07/2022 08:45:12 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 = '59112' 19/07/2022 08:45:12 am >> DELETE FROM ps_document_detail WHERE id_document = '59112' 19/07/2022 08:45: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 ( '59112' , '14354' , 'CAMICE BENEDETTINO LINO - 3010' , '8' , '8' , '1' , '56.0000' , '45.901639344262' , '22' , '3' , '530.16' ) 19/07/2022 08:45:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '14354' AND id_supplier = '' 19/07/2022 08:45:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14354' , '' , '1' ) 19/07/2022 08:45: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 ( '59112' , '19194' , 'STOLA DIACONALE - 209' , '2' , '2' , '1' , '25.5000' , '20.901639344262' , '22' , '3' , '60.35' ) 19/07/2022 08:45:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '19194' AND id_supplier = '' 19/07/2022 08:45:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19194' , '' , '1' ) 19/07/2022 08:45: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 ( '59112' , '10133' , 'SPESE DI TRASPORTO' , '1' , '1' , '1' , '13.5100' , '11.073770491803' , '22' , '3' , '15.99' ) 19/07/2022 08:45:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '10133' AND id_supplier = '' 19/07/2022 08:45:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10133' , '' , '1' ) 19/07/2022 08:45:37 am >> UPDATE ps_document SET id_document_type = '31', document_num = '292', document_date = '2022-07-18', document_letter = '', id_customer = '0', id_supplier = '', id_address = '4669176', address1 = 'VIALE EUROPA, 102 36075 MONTECCHIO MAGGIORE', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '1', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '9', id_causal = '0', price_tax_included = '606.50', price_tax_excluded = '497.13', date_upd = NOW() WHERE id_document = '59112' 19/07/2022 08:45:37 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 = '59112' 19/07/2022 08:45:37 am >> DELETE FROM ps_document_detail WHERE id_document = '59112' 19/07/2022 08:45: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 ( '59112' , '14354' , 'CAMICE BENEDETTINO LINO - 3010' , '8' , '8' , '1' , '56.0000' , '45.901639344262' , '22' , '3' , '530.16' ) 19/07/2022 08:45:37 am >> DELETE FROM ps_product_supplier WHERE id_product = '14354' AND id_supplier = '' 19/07/2022 08:45:37 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14354' , '' , '1' ) 19/07/2022 08:45: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 ( '59112' , '19194' , 'STOLA DIACONALE - 209' , '2' , '2' , '1' , '25.5000' , '20.901639344262' , '22' , '3' , '60.35' ) 19/07/2022 08:45:37 am >> DELETE FROM ps_product_supplier WHERE id_product = '19194' AND id_supplier = '' 19/07/2022 08:45:37 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19194' , '' , '1' ) 19/07/2022 08:45: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 ( '59112' , '10133' , 'SPESE DI TRASPORTO' , '1' , '1' , '1' , '13.5100' , '11.073770491803' , '22' , '3' , '15.99' ) 19/07/2022 08:45:37 am >> DELETE FROM ps_product_supplier WHERE id_product = '10133' AND id_supplier = '' 19/07/2022 08:45:37 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10133' , '' , '1' ) 19/07/2022 10:52:03 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 19/07/2022 10:52:03 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19757' , '1' , '' , 'nuovo-prodotto' ) 19/07/2022 10:52:03 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '19757' , '1' , '1' , '2' , NOW() , NOW() ) 19/07/2022 10:52:03 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '19757' , '0' , '1' , '0' , '0' ) 19/07/2022 10:52:50 am >> SELECT ean13 FROM ps_product WHERE ean13 = '5901821651837' AND id_product != '19757' AND ean13 != '' 19/07/2022 10:52:50 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '5901821651837', date_upd = NOW() WHERE id_product = '19757' 19/07/2022 10:52:50 am >> UPDATE ps_product_lang SET name = 'PIVIALE - KKP/024/02/20', description = '' WHERE id_product = '19757' 19/07/2022 10:52:50 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '299.1803278688525' WHERE id_product = '19757' 19/07/2022 10:52:50 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '299.1803278688525', id_tax_rules_group = '1', id_category_default = '194', 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 = '19757' 19/07/2022 10:52:50 am >> DELETE FROM ps_specific_price WHERE id_product = '19757' 19/07/2022 10:53:28 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 19/07/2022 10:53:28 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19758' , '1' , '' , 'nuovo-prodotto' ) 19/07/2022 10:53:28 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '19758' , '1' , '1' , '2' , NOW() , NOW() ) 19/07/2022 10:53:28 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '19758' , '0' , '1' , '0' , '0' ) 19/07/2022 10:54:27 am >> SELECT ean13 FROM ps_product WHERE ean13 = '5901597468363' AND id_product != '19044' AND ean13 != '' 19/07/2022 10:54:27 am >> UPDATE ps_product SET id_supplier = '5', reference = '', ean13 = '5901597468363', date_upd = NOW() WHERE id_product = '19044' 19/07/2022 10:54:27 am >> UPDATE ps_product_lang SET name = 'VELO OMERALE - KWL018-05', description = '' WHERE id_product = '19044' 19/07/2022 10:54:27 am >> UPDATE ps_product SET wholesale_price = '70.27', on_sale = '0', price = '172.13114754098362' WHERE id_product = '19044' 19/07/2022 10:54:27 am >> UPDATE ps_product_shop SET wholesale_price = '70.27', price = '172.13114754098362', id_tax_rules_group = '1', id_category_default = '194', 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 = '19044' 19/07/2022 10:54:27 am >> DELETE FROM ps_specific_price WHERE id_product = '19044' 19/07/2022 10:56:36 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8056697750096' AND id_product != '13079' AND ean13 != '' 19/07/2022 10:56:36 am >> UPDATE ps_product SET id_supplier = '5', reference = '', ean13 = '8056697750096', date_upd = NOW() WHERE id_product = '13079' 19/07/2022 10:56:36 am >> UPDATE ps_product_lang SET name = 'COPPIA CANDELIERI IN LEGNO - 033', description = '' WHERE id_product = '13079' 19/07/2022 10:56:36 am >> UPDATE ps_product SET wholesale_price = '19.40', on_sale = '0', price = '45.0820' WHERE id_product = '13079' 19/07/2022 10:56:36 am >> UPDATE ps_product_shop SET wholesale_price = '19.40', price = '45.0820', id_tax_rules_group = '1', id_category_default = '194', 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 = '13079' 19/07/2022 10:56:36 am >> DELETE FROM ps_specific_price WHERE id_product = '13079' 19/07/2022 10:59:39 am >> SELECT ean13 FROM ps_product WHERE ean13 = '1112' AND id_product != '15046' AND ean13 != '' 19/07/2022 10:59:39 am >> UPDATE ps_product SET id_supplier = '5', reference = '', ean13 = '1112', date_upd = NOW() WHERE id_product = '15046' 19/07/2022 10:59:39 am >> UPDATE ps_product_lang SET name = 'ICONA DIPINTA 14X18', description = '' WHERE id_product = '15046' 19/07/2022 10:59:39 am >> UPDATE ps_product SET wholesale_price = '55.00', on_sale = '0', price = '65.1639344262295' WHERE id_product = '15046' 19/07/2022 10:59:39 am >> UPDATE ps_product_shop SET wholesale_price = '55.00', price = '65.1639344262295', id_tax_rules_group = '1', id_category_default = '194', 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 = '15046' 19/07/2022 10:59:39 am >> DELETE FROM ps_specific_price WHERE id_product = '15046' 19/07/2022 11:00:33 am >> SELECT ean13 FROM ps_product WHERE ean13 = '1112' AND id_product != '15046' AND ean13 != '' 19/07/2022 11:00:33 am >> UPDATE ps_product SET id_supplier = '5', reference = '', ean13 = '1112', date_upd = NOW() WHERE id_product = '15046' 19/07/2022 11:00:33 am >> UPDATE ps_product_lang SET name = 'ICONA DIPINTA 14X18', description = '' WHERE id_product = '15046' 19/07/2022 11:00:33 am >> UPDATE ps_product SET wholesale_price = '55.00', on_sale = '0', price = '73.68852459016394' WHERE id_product = '15046' 19/07/2022 11:00:33 am >> UPDATE ps_product_shop SET wholesale_price = '55.00', price = '73.68852459016394', id_tax_rules_group = '1', id_category_default = '194', 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 = '15046' 19/07/2022 11:00:33 am >> DELETE FROM ps_specific_price WHERE id_product = '15046' 19/07/2022 11:01: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 ( '31' , '288' , '2022-07-15' , '' , '0' , '5' , '2600' , 'VIA DEL MANDORLO, 52 70022 ALTAMURA' , '' , '' , '10' , '1' , '0' , '0' , '0' , '' , '9' , '0' , '346.01' , '283.62' , NOW() , NOW() ) 19/07/2022 11:01: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 = '59722' 19/07/2022 11:01:03 am >> DELETE FROM ps_document_detail WHERE id_document = '59722' 19/07/2022 11:01: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 ( '59722' , '19757' , 'PIVIALE - KKP/024/02/20' , '1' , '1' , '1' , '142.28' , '116.62295081967' , '22' , '3' , '168.3742' ) 19/07/2022 11:01:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '19757' AND id_supplier = '5' 19/07/2022 11:01:04 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19757' , '5' , '1' ) 19/07/2022 11:01: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 ( '59722' , '19044' , 'VELO OMERALE - KWL018-05' , '1' , '1' , '1' , '83.3' , '68.27868852459' , '22' , '3' , '98.5772' ) 19/07/2022 11:01:04 am >> DELETE FROM ps_product_supplier WHERE id_product = '19044' AND id_supplier = '5' 19/07/2022 11:01:04 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19044' , '5' , '1' ) 19/07/2022 11:01: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 ( '59722' , '13079' , 'COPPIA CANDELIERI IN LEGNO - 033' , '1' , '1' , '1' , '20' , '16.393442622951' , '22' , '3' , '23.6680' ) 19/07/2022 11:01:04 am >> DELETE FROM ps_product_supplier WHERE id_product = '13079' AND id_supplier = '5' 19/07/2022 11:01:04 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13079' , '5' , '1' ) 19/07/2022 11:01: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 ( '59722' , '15046' , 'ICONA DIPINTA 14X18' , '1' , '1' , '1' , '36.5' , '29.918032786885' , '22' , '3' , '43.1941' ) 19/07/2022 11:01:04 am >> DELETE FROM ps_product_supplier WHERE id_product = '15046' AND id_supplier = '5' 19/07/2022 11:01:04 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15046' , '5' , '1' ) 19/07/2022 11:23:46 am >> SELECT ean13 FROM ps_product WHERE ean13 = 'PCM005B00' AND id_product != '15040' AND ean13 != '' 19/07/2022 11:23:46 am >> UPDATE ps_product SET id_supplier = '122', reference = '', ean13 = 'PCM005B00', date_upd = NOW() WHERE id_product = '15040' 19/07/2022 11:23:46 am >> UPDATE ps_product_lang SET name = 'CAMICE aperto POLIESTERE', description = '' WHERE id_product = '15040' 19/07/2022 11:23:46 am >> UPDATE ps_product SET wholesale_price = '32.34', on_sale = '0', price = '69.6721' WHERE id_product = '15040' 19/07/2022 11:23:46 am >> UPDATE ps_product_shop SET wholesale_price = '32.34', price = '69.6721', id_tax_rules_group = '1', id_category_default = '440', 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 = '15040' 19/07/2022 11:23:46 am >> DELETE FROM ps_specific_price WHERE id_product = '15040' 19/07/2022 11:24:03 am >> SELECT ean13 FROM ps_product WHERE ean13 = 'PCM005B00' AND id_product != '15040' AND ean13 != '' 19/07/2022 11:24:03 am >> UPDATE ps_product SET id_supplier = '122', reference = '', ean13 = 'PCM005B00', date_upd = NOW() WHERE id_product = '15040' 19/07/2022 11:24:03 am >> UPDATE ps_product_lang SET name = 'CAMICE aperto POLIESTERE', description = '' WHERE id_product = '15040' 19/07/2022 11:24:03 am >> UPDATE ps_product SET wholesale_price = '32.34', on_sale = '0', price = '80.32786885245902' WHERE id_product = '15040' 19/07/2022 11:24:03 am >> UPDATE ps_product_shop SET wholesale_price = '32.34', price = '80.32786885245902', id_tax_rules_group = '1', id_category_default = '440', 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 = '15040' 19/07/2022 11:24:03 am >> DELETE FROM ps_specific_price WHERE id_product = '15040' 19/07/2022 11:24:37 am >> SELECT ean13 FROM ps_product WHERE ean13 = 'PCM005B00' AND id_product != '15040' AND ean13 != '' 19/07/2022 11:24:38 am >> UPDATE ps_product SET id_supplier = '122', reference = '', ean13 = 'PCM005B00', date_upd = NOW() WHERE id_product = '15040' 19/07/2022 11:24:38 am >> UPDATE ps_product_lang SET name = 'CAMICE APERTO POLIESTERE', description = '' WHERE id_product = '15040' 19/07/2022 11:24:38 am >> UPDATE ps_product SET wholesale_price = '32.34', on_sale = '0', price = '80.3279' WHERE id_product = '15040' 19/07/2022 11:24:38 am >> UPDATE ps_product_shop SET wholesale_price = '32.34', price = '80.3279', id_tax_rules_group = '1', id_category_default = '440', 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 = '15040' 19/07/2022 11:24:38 am >> DELETE FROM ps_specific_price WHERE id_product = '15040' 19/07/2022 11:43: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 ( '33' , '721' , '2022-07-12' , '' , '0' , '122' , '4669556' , 'VIA XXV APRILE, 17 24050 GRASSOBBIO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '247.66' , '203.00' , NOW() , NOW() ) 19/07/2022 11:43: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 = '59723' 19/07/2022 11:43:16 am >> DELETE FROM ps_document_detail WHERE id_document = '59723' 19/07/2022 11:43: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 ( '59723' , '16068' , 'CAMICE PIEGONI 2 INSERTI - AECM17B05' , '1' , '1' , '1' , '45' , '36.885245901639' , '22' , '0' , '54.9000' ) 19/07/2022 11:43:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '16068' AND id_supplier = '122' 19/07/2022 11:43:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16068' , '122' , '1' ) 19/07/2022 11:43: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 ( '59723' , '15040' , 'CAMICE APERTO POLIESTERE' , '1' , '1' , '1' , '39.5' , '32.377049180328' , '22' , '0' , '48.1900' ) 19/07/2022 11:43:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '15040' AND id_supplier = '122' 19/07/2022 11:43:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15040' , '122' , '1' ) 19/07/2022 11:43: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 ( '59723' , '16070' , 'CASULA - PCA020' , '1' , '1' , '1' , '30' , '24.590163934426' , '22' , '0' , '36.6000' ) 19/07/2022 11:43:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '16070' AND id_supplier = '122' 19/07/2022 11:43:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16070' , '122' , '1' ) 19/07/2022 11:43: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 ( '59723' , '17101' , 'CASULA POLIESTERE CROCE ORO - AECU04' , '3' , '3' , '1' , '29.5' , '24.180327868852' , '22' , '0' , '107.9700' ) 19/07/2022 11:43:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '17101' AND id_supplier = '122' 19/07/2022 11:43:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17101' , '122' , '1' ) 19/07/2022 11:53:19 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788832713404' AND id_product != '19758' AND ean13 != '' 19/07/2022 11:53:19 am >> UPDATE ps_product SET id_supplier = '', reference = '4/1', ean13 = '9788832713404', date_upd = NOW() WHERE id_product = '19758' 19/07/2022 11:53:19 am >> UPDATE ps_product_lang SET name = 'RAGAZZI CHE SQUADRA - 1', description = '' WHERE id_product = '19758' 19/07/2022 11:53:19 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '16.5' WHERE id_product = '19758' 19/07/2022 11:53:19 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '16.5', id_tax_rules_group = '4', id_category_default = '80', id_argoment_default = '12', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19758' 19/07/2022 11:53:19 am >> DELETE FROM ps_specific_price WHERE id_product = '19758' 19/07/2022 11:53:20 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 = '19758' 19/07/2022 11:53:20 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19759' , '1' , '' , 'nuovo-prodotto' ) 19/07/2022 11:53:20 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 '19759' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19758' 19/07/2022 11:53:20 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19759' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19758' 19/07/2022 11:53:59 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788832713411' AND id_product != '19759' AND ean13 != '' 19/07/2022 11:53:59 am >> UPDATE ps_product SET id_supplier = '', reference = '5/1', ean13 = '9788832713411', date_upd = NOW() WHERE id_product = '19759' 19/07/2022 11:53:59 am >> UPDATE ps_product_lang SET name = 'RAGAZZI CHE SQUADRA - 2', description = '' WHERE id_product = '19759' 19/07/2022 11:53:59 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '16.5' WHERE id_product = '19759' 19/07/2022 11:53:59 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '16.5', id_tax_rules_group = '4', id_category_default = '80', id_argoment_default = '12', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19759' 19/07/2022 11:53:59 am >> DELETE FROM ps_specific_price WHERE id_product = '19759' 19/07/2022 11:54: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 = '19759' 19/07/2022 11:54:01 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19760' , '1' , '' , 'nuovo-prodotto' ) 19/07/2022 11:54: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 '19760' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19759' 19/07/2022 11:54:01 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19760' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19759' 19/07/2022 11:54:31 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788832713428' AND id_product != '19760' AND ean13 != '' 19/07/2022 11:54:31 am >> UPDATE ps_product SET id_supplier = '', reference = '5/1', ean13 = '9788832713428', date_upd = NOW() WHERE id_product = '19760' 19/07/2022 11:54:31 am >> UPDATE ps_product_lang SET name = 'RAGAZZI CHE SQUADRA - 3', description = '' WHERE id_product = '19760' 19/07/2022 11:54:31 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '16.5' WHERE id_product = '19760' 19/07/2022 11:54:31 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '16.5', id_tax_rules_group = '4', id_category_default = '80', id_argoment_default = '21', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19760' 19/07/2022 11:54:31 am >> DELETE FROM ps_specific_price WHERE id_product = '19760' 19/07/2022 11:54:33 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 = '19760' 19/07/2022 11:54:33 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19761' , '1' , '' , 'nuovo-prodotto' ) 19/07/2022 11:54:33 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 '19761' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19760' 19/07/2022 11:54:33 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19761' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19760' 19/07/2022 11:55:03 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788832713398' AND id_product != '19761' AND ean13 != '' 19/07/2022 11:55:04 am >> UPDATE ps_product SET id_supplier = '', reference = '5/1', ean13 = '9788832713398', date_upd = NOW() WHERE id_product = '19761' 19/07/2022 11:55:04 am >> UPDATE ps_product_lang SET name = 'RAGAZZI CHE SQUADRA', description = '' WHERE id_product = '19761' 19/07/2022 11:55:04 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '16.5' WHERE id_product = '19761' 19/07/2022 11:55:04 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '16.5', id_tax_rules_group = '4', id_category_default = '80', id_argoment_default = '12', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19761' 19/07/2022 11:55:04 am >> DELETE FROM ps_specific_price WHERE id_product = '19761' 19/07/2022 11:55:05 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '19761' 19/07/2022 11:55:05 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19762' , '1' , '' , 'nuovo-prodotto' ) 19/07/2022 11:55:05 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '19762' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19761' 19/07/2022 11:55:05 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19762' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19761' 19/07/2022 11:55:58 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788832713374' AND id_product != '19762' AND ean13 != '' 19/07/2022 11:55:58 am >> UPDATE ps_product SET id_supplier = '', reference = '5/1', ean13 = '9788832713374', date_upd = NOW() WHERE id_product = '19762' 19/07/2022 11:55:58 am >> UPDATE ps_product_lang SET name = 'PRIMO PASSO ', description = '' WHERE id_product = '19762' 19/07/2022 11:55:58 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '12.5' WHERE id_product = '19762' 19/07/2022 11:55:58 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '12.5', id_tax_rules_group = '4', id_category_default = '80', id_argoment_default = '217', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19762' 19/07/2022 11:55:58 am >> DELETE FROM ps_specific_price WHERE id_product = '19762' 19/07/2022 11:55:59 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 = '19762' 19/07/2022 11:55:59 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19763' , '1' , '' , 'nuovo-prodotto' ) 19/07/2022 11:55:59 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 '19763' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19762' 19/07/2022 11:55:59 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19763' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19762' 19/07/2022 11:57:41 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788832713350' AND id_product != '19763' AND ean13 != '' 19/07/2022 11:57:41 am >> UPDATE ps_product SET id_supplier = '', reference = '1/5', ean13 = '9788832713350', date_upd = NOW() WHERE id_product = '19763' 19/07/2022 11:57:41 am >> UPDATE ps_product_lang SET name = 'FATTI DI VOCE ', description = '' WHERE id_product = '19763' 19/07/2022 11:57:41 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '11' WHERE id_product = '19763' 19/07/2022 11:57:41 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '11', id_tax_rules_group = '4', id_category_default = '80', 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 = '19763' 19/07/2022 11:57:41 am >> DELETE FROM ps_specific_price WHERE id_product = '19763' 19/07/2022 11:57:42 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '19763' 19/07/2022 11:57:42 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19764' , '1' , '' , 'nuovo-prodotto' ) 19/07/2022 11:57:42 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '19764' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19763' 19/07/2022 11:57:43 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19764' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19763' 19/07/2022 11:59:11 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788832713367' AND id_product != '19764' AND ean13 != '' 19/07/2022 11:59:11 am >> UPDATE ps_product SET id_supplier = '', reference = '5/1', ean13 = '9788832713367', date_upd = NOW() WHERE id_product = '19764' 19/07/2022 11:59:11 am >> UPDATE ps_product_lang SET name = 'PRIMO PASSO - TACCUINO', description = '' WHERE id_product = '19764' 19/07/2022 11:59:11 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '5' WHERE id_product = '19764' 19/07/2022 11:59:11 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '5', id_tax_rules_group = '4', id_category_default = '80', id_argoment_default = '58', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19764' 19/07/2022 11:59:11 am >> DELETE FROM ps_specific_price WHERE id_product = '19764' 19/07/2022 11:59:14 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '19764' 19/07/2022 11:59:14 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19765' , '1' , '' , 'nuovo-prodotto' ) 19/07/2022 11:59:14 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '19765' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19764' 19/07/2022 11:59:14 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19765' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19764' 19/07/2022 12:00:05 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788832713381' AND id_product != '19765' AND ean13 != '' 19/07/2022 12:00:05 pm >> UPDATE ps_product SET id_supplier = '', reference = '5/1', ean13 = '9788832713381', date_upd = NOW() WHERE id_product = '19765' 19/07/2022 12:00:05 pm >> UPDATE ps_product_lang SET name = 'TUTTI I SANTI GIORNI - GUIDA', description = '' WHERE id_product = '19765' 19/07/2022 12:00:05 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '11.5' WHERE id_product = '19765' 19/07/2022 12:00:05 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '11.5', id_tax_rules_group = '4', id_category_default = '80', id_argoment_default = '58', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19765' 19/07/2022 12:00:05 pm >> DELETE FROM ps_specific_price WHERE id_product = '19765' 19/07/2022 12:00: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 = '19765' 19/07/2022 12:00:06 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19766' , '1' , '' , 'nuovo-prodotto' ) 19/07/2022 12:00: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 '19766' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19765' 19/07/2022 12:00:06 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19766' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19765' 19/07/2022 12:01:27 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788832713435' AND id_product != '19766' AND ean13 != '' 19/07/2022 12:01:27 pm >> UPDATE ps_product SET id_supplier = '', reference = '1/2', ean13 = '9788832713435', date_upd = NOW() WHERE id_product = '19766' 19/07/2022 12:01:27 pm >> UPDATE ps_product_lang SET name = 'WORK IN PROGRESS', description = '' WHERE id_product = '19766' 19/07/2022 12:01:27 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '7' WHERE id_product = '19766' 19/07/2022 12:01:27 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '7', id_tax_rules_group = '4', id_category_default = '80', id_argoment_default = '35', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19766' 19/07/2022 12:01:27 pm >> DELETE FROM ps_specific_price WHERE id_product = '19766' 19/07/2022 12:01:28 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '19766' 19/07/2022 12:01:28 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19767' , '1' , '' , 'nuovo-prodotto' ) 19/07/2022 12:01:28 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '19767' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19766' 19/07/2022 12:01:28 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19767' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19766' 19/07/2022 12:03:38 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788832713442' AND id_product != '19767' AND ean13 != '' 19/07/2022 12:03:39 pm >> UPDATE ps_product SET id_supplier = '', reference = '5/1', ean13 = '9788832713442', date_upd = NOW() WHERE id_product = '19767' 19/07/2022 12:03:39 pm >> UPDATE ps_product_lang SET name = 'RAGAZZI CHE SQUADRA - CALENDARIO', description = '' WHERE id_product = '19767' 19/07/2022 12:03:39 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '7' WHERE id_product = '19767' 19/07/2022 12:03:39 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '7', id_tax_rules_group = '4', id_category_default = '80', 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 = '19767' 19/07/2022 12:03:39 pm >> DELETE FROM ps_specific_price WHERE id_product = '19767' 19/07/2022 12:03:40 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 = '19767' 19/07/2022 12:03:40 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19768' , '1' , '' , 'nuovo-prodotto' ) 19/07/2022 12:03:40 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 '19768' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19767' 19/07/2022 12:03:40 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19768' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19767' 19/07/2022 12:05:58 pm >> SELECT document_num FROM ps_document WHERE document_num = '2299' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-19') 19/07/2022 12:05:58 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' , '2299' , '2022-07-19' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '139.00' , '113.93' , NOW() , NOW() ) 19/07/2022 12:05:58 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 = '59724' 19/07/2022 12:05:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '59724' 19/07/2022 12:05:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59724' , '14354' , 'CAMICE BENEDETTINO LINO - 3010' , '1' , '-1' , '1' , '139.00' , '113.93442622951' , '22' , '0' , '139.00' ) 19/07/2022 12:05:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14354' AND id_supplier = '' 19/07/2022 12:05:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14354' , '' , '1' ) 19/07/2022 12:07:52 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788832713176' AND id_product != '19768' AND ean13 != '' 19/07/2022 12:07:52 pm >> UPDATE ps_product SET id_supplier = '', reference = '7/7', ean13 = '9788832713176', date_upd = NOW() WHERE id_product = '19768' 19/07/2022 12:07:52 pm >> UPDATE ps_product_lang SET name = 'LAVORO 4.0', description = '' WHERE id_product = '19768' 19/07/2022 12:07:52 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '12' WHERE id_product = '19768' 19/07/2022 12:07:52 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '12', id_tax_rules_group = '4', id_category_default = '80', 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 = '19768' 19/07/2022 12:07:52 pm >> DELETE FROM ps_specific_price WHERE id_product = '19768' 19/07/2022 12:10:13 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788832713374' AND id_product != '19762' AND ean13 != '' 19/07/2022 12:10:13 pm >> UPDATE ps_product SET id_supplier = '', reference = '5/1', ean13 = '9788832713374', date_upd = NOW() WHERE id_product = '19762' 19/07/2022 12:10:13 pm >> UPDATE ps_product_lang SET name = 'PRIMO PASSO - GUIDA', description = '' WHERE id_product = '19762' 19/07/2022 12:10:13 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '12.5000' WHERE id_product = '19762' 19/07/2022 12:10:13 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '12.5000', id_tax_rules_group = '4', id_category_default = '80', id_argoment_default = '217', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19762' 19/07/2022 12:10:13 pm >> DELETE FROM ps_specific_price WHERE id_product = '19762' 19/07/2022 12:11: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 ( '33' , '596260' , '2022-07-18' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '144.00' , '144.00' , NOW() , NOW() ) 19/07/2022 12:11: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 = '59725' 19/07/2022 12:11:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '59725' 19/07/2022 12:11: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 ( '59725' , '19763' , 'FATTI DI VOCE ' , '1' , '1' , '4' , '11.00' , '11' , '0' , '0' , '11.00' ) 19/07/2022 12:11:24 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19763' AND id_supplier = '109' 19/07/2022 12:11:24 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19763' , '109' , '1' ) 19/07/2022 12:11: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 ( '59725' , '19766' , 'WORK IN PROGRESS' , '1' , '1' , '4' , '7.00' , '7' , '0' , '0' , '7.00' ) 19/07/2022 12:11:24 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19766' AND id_supplier = '109' 19/07/2022 12:11:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19766' , '109' , '1' ) 19/07/2022 12:11:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59725' , '19761' , 'RAGAZZI CHE SQUADRA' , '1' , '1' , '4' , '16.50' , '16.5' , '0' , '0' , '16.50' ) 19/07/2022 12:11:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19761' AND id_supplier = '109' 19/07/2022 12:11:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19761' , '109' , '1' ) 19/07/2022 12:11:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59725' , '19758' , 'RAGAZZI CHE SQUADRA - 1' , '1' , '1' , '4' , '16.50' , '16.5' , '0' , '0' , '16.50' ) 19/07/2022 12:11:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19758' AND id_supplier = '109' 19/07/2022 12:11:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19758' , '109' , '1' ) 19/07/2022 12:11:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59725' , '19759' , 'RAGAZZI CHE SQUADRA - 2' , '1' , '1' , '4' , '16.50' , '16.5' , '0' , '0' , '16.50' ) 19/07/2022 12:11:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19759' AND id_supplier = '109' 19/07/2022 12:11:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19759' , '109' , '1' ) 19/07/2022 12:11:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59725' , '19760' , 'RAGAZZI CHE SQUADRA - 3' , '1' , '1' , '4' , '16.50' , '16.5' , '0' , '0' , '16.50' ) 19/07/2022 12:11:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19760' AND id_supplier = '109' 19/07/2022 12:11:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19760' , '109' , '1' ) 19/07/2022 12:11:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59725' , '19767' , 'RAGAZZI CHE SQUADRA - CALENDARIO' , '1' , '1' , '4' , '7.00' , '7' , '0' , '0' , '7.00' ) 19/07/2022 12:11:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19767' AND id_supplier = '109' 19/07/2022 12:11:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19767' , '109' , '1' ) 19/07/2022 12:11:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59725' , '19765' , 'TUTTI I SANTI GIORNI - GUIDA' , '1' , '1' , '4' , '11.50' , '11.5' , '0' , '0' , '11.50' ) 19/07/2022 12:11:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19765' AND id_supplier = '109' 19/07/2022 12:11:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19765' , '109' , '1' ) 19/07/2022 12:11:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59725' , '19768' , 'LAVORO 4.0' , '2' , '2' , '4' , '12.00' , '12' , '0' , '0' , '24.0000' ) 19/07/2022 12:11:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19768' AND id_supplier = '109' 19/07/2022 12:11:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19768' , '109' , '1' ) 19/07/2022 12:11:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59725' , '19762' , 'PRIMO PASSO - GUIDA' , '1' , '1' , '4' , '12.50' , '12.5' , '0' , '0' , '12.50' ) 19/07/2022 12:11:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19762' AND id_supplier = '109' 19/07/2022 12:11:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19762' , '109' , '1' ) 19/07/2022 12:11:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59725' , '19764' , 'PRIMO PASSO - TACCUINO' , '1' , '1' , '4' , '5.00' , '5' , '0' , '0' , '5.00' ) 19/07/2022 12:11:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19764' AND id_supplier = '109' 19/07/2022 12:11:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19764' , '109' , '1' ) 19/07/2022 12:17:45 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892227750' AND id_product != '19065' AND ean13 != '' 19/07/2022 12:17:46 pm >> UPDATE ps_product SET id_supplier = '7', reference = '1/2', ean13 = '9788892227750', date_upd = NOW() WHERE id_product = '19065' 19/07/2022 12:17:46 pm >> UPDATE ps_product_lang SET name = 'SANTUARIO PORTA APERTA...', description = '' WHERE id_product = '19065' 19/07/2022 12:17:46 pm >> UPDATE ps_product SET wholesale_price = '10.72', on_sale = '0', price = '16.0000' WHERE id_product = '19065' 19/07/2022 12:17:46 pm >> UPDATE ps_product_shop SET wholesale_price = '10.72', price = '16.0000', id_tax_rules_group = '4', id_category_default = '30', 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 = '19065' 19/07/2022 12:17:46 pm >> DELETE FROM ps_specific_price WHERE id_product = '19065' 19/07/2022 12:18:04 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892227750' AND id_product != '19065' AND ean13 != '' 19/07/2022 12:18:04 pm >> UPDATE ps_product SET id_supplier = '7', reference = '13/7', ean13 = '9788892227750', date_upd = NOW() WHERE id_product = '19065' 19/07/2022 12:18:04 pm >> UPDATE ps_product_lang SET name = 'SANTUARIO PORTA APERTA...', description = '' WHERE id_product = '19065' 19/07/2022 12:18:04 pm >> UPDATE ps_product SET wholesale_price = '10.72', on_sale = '0', price = '16.0000' WHERE id_product = '19065' 19/07/2022 12:18:04 pm >> UPDATE ps_product_shop SET wholesale_price = '10.72', price = '16.0000', id_tax_rules_group = '4', id_category_default = '30', 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 = '19065' 19/07/2022 12:18:04 pm >> DELETE FROM ps_specific_price WHERE id_product = '19065' 19/07/2022 12:18:20 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892220799' AND id_product != '16386' AND ean13 != '' 19/07/2022 12:18:20 pm >> UPDATE ps_product SET id_supplier = '7', reference = '13/7', ean13 = '9788892220799', date_upd = NOW() WHERE id_product = '16386' 19/07/2022 12:18:20 pm >> UPDATE ps_product_lang SET name = 'SACERDOTE MISSIONARIO DELLA MISERICORDIA ', description = '' WHERE id_product = '16386' 19/07/2022 12:18:20 pm >> UPDATE ps_product SET wholesale_price = '10.72', on_sale = '0', price = '16.0000' WHERE id_product = '16386' 19/07/2022 12:18:20 pm >> UPDATE ps_product_shop SET wholesale_price = '10.72', price = '16.0000', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '36', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '16386' 19/07/2022 12:18:20 pm >> DELETE FROM ps_specific_price WHERE id_product = '16386' 19/07/2022 12:36:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '2300' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-19') 19/07/2022 12:36:17 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2300' , '2022-07-19' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.00' , '7.38' , NOW() , NOW() ) 19/07/2022 12:36:17 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '59726' 19/07/2022 12:36:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '59726' 19/07/2022 12:36:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59726' , '6809' , 'MOCCOLO 60X165' , '1' , '-1' , '1' , '4.50' , '3.6885245901639' , '22' , '0' , '4.50' ) 19/07/2022 12:36:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6809' AND id_supplier = '' 19/07/2022 12:36:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6809' , '' , '1' ) 19/07/2022 12:36:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59726' , '4697' , 'GLORIA MISCELA 25G - GLORE' , '3' , '-3' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '4.50' ) 19/07/2022 12:36:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4697' AND id_supplier = '' 19/07/2022 12:36:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4697' , '' , '1' ) 19/07/2022 12:58:33 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '364' 19/07/2022 12:58:33 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '364' , '10' , '210' , 'PARROCCHIA SACRO CUORE DI GESU\' IN FARINIA' , 'KASSEHIN' , 'DON CARLOS' , 'VIA LAGO LACENO' , '' , '84098' , 'PONTECAGNANO' , '' , '' , '3480389454' , '' , '95007560659' , NOW() , NOW() ) 19/07/2022 12:58:33 pm >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '364' 19/07/2022 12:58:37 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '364' 19/07/2022 12:58:37 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '364' , '10' , '210' , 'PARROCCHIA SACRO CUORE DI GESU\' IN FARINIA' , 'KASSEHIN' , 'DON CARLOS' , 'VIA LAGO LACENO' , '' , '84098' , 'PONTECAGNANO' , '' , '' , '' , '' , '95007560659' , NOW() , NOW() ) 19/07/2022 12:58:37 pm >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '364' 19/07/2022 12:58:41 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '364' 19/07/2022 12:58:41 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '364' , '10' , '210' , 'PARROCCHIA SACRO CUORE DI GESU\' IN FARINIA' , 'KASSEHIN' , 'DON CARLOS' , 'VIA LAGO LACENO' , '' , '84098' , 'PONTECAGNANO' , '' , '' , '' , '' , '95007560659' , NOW() , NOW() ) 19/07/2022 12:58:41 pm >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '364' 19/07/2022 03:25:57 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 19/07/2022 03:25:57 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19769' , '1' , '' , 'nuovo-prodotto' ) 19/07/2022 03:25:57 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '19769' , '1' , '1' , '2' , NOW() , NOW() ) 19/07/2022 03:25:57 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '19769' , '0' , '1' , '0' , '0' ) 19/07/2022 03:28:01 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '1774' AND id_product != '19769' AND ean13 != '' 19/07/2022 03:28:01 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '1774', date_upd = NOW() WHERE id_product = '19769' 19/07/2022 03:28:01 pm >> UPDATE ps_product_lang SET name = 'BRACCIALE ARGENTO S. BENEDETTO', description = '' WHERE id_product = '19769' 19/07/2022 03:28:01 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '40.98360655737705' WHERE id_product = '19769' 19/07/2022 03:28:01 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '40.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 = '19769' 19/07/2022 03:28:01 pm >> DELETE FROM ps_specific_price WHERE id_product = '19769' 19/07/2022 03:28:05 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '19769' 19/07/2022 03:28:05 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19770' , '1' , '' , 'nuovo-prodotto' ) 19/07/2022 03:28:05 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '19770' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19769' 19/07/2022 03:28:05 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19770' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19769' 19/07/2022 03:28:48 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '1398/SB' AND id_product != '19770' AND ean13 != '' 19/07/2022 03:28:48 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '1398/SB', date_upd = NOW() WHERE id_product = '19770' 19/07/2022 03:28:48 pm >> UPDATE ps_product_lang SET name = 'BRACCIALE ARGENTO/ULIVO S. BENEDETTO', description = '' WHERE id_product = '19770' 19/07/2022 03:28:48 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '18.852459016393443' WHERE id_product = '19770' 19/07/2022 03:28:48 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 = '19770' 19/07/2022 03:28:48 pm >> DELETE FROM ps_specific_price WHERE id_product = '19770' 19/07/2022 03:28: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 = '19770' 19/07/2022 03:28:49 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19771' , '1' , '' , 'nuovo-prodotto' ) 19/07/2022 03:28: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 '19771' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19770' 19/07/2022 03:28:49 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19771' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19770' 19/07/2022 03:32:46 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '1931/CAV' AND id_product != '19771' AND ean13 != '' 19/07/2022 03:32:46 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '1931/CAV', date_upd = NOW() WHERE id_product = '19771' 19/07/2022 03:32:46 pm >> UPDATE ps_product_lang SET name = 'ROSARIO ARGENTO/EMATITE', description = '' WHERE id_product = '19771' 19/07/2022 03:32:46 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '27.868852459016395' WHERE id_product = '19771' 19/07/2022 03:32:46 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '27.868852459016395', 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' 19/07/2022 03:32:46 pm >> DELETE FROM ps_specific_price WHERE id_product = '19771' 19/07/2022 03:33: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 = '19771' 19/07/2022 03:33:23 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19772' , '1' , '' , 'nuovo-prodotto' ) 19/07/2022 03:33: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 '19772' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19771' 19/07/2022 03:33:23 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19772' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19771' 19/07/2022 03:34:18 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '1374/CAV' AND id_product != '19772' AND ean13 != '' 19/07/2022 03:34:18 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '1374/CAV', date_upd = NOW() WHERE id_product = '19772' 19/07/2022 03:34:18 pm >> UPDATE ps_product_lang SET name = 'BRACCIALE ARGENTO/EMATITE', description = '' WHERE id_product = '19772' 19/07/2022 03:34:18 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '16.39344262295082' WHERE id_product = '19772' 19/07/2022 03:34:18 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 = '19772' 19/07/2022 03:34:18 pm >> DELETE FROM ps_specific_price WHERE id_product = '19772' 19/07/2022 03:34:59 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '1374/CAV' AND id_product != '19772' AND ean13 != '' 19/07/2022 03:35:00 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '1374/CAV', date_upd = NOW() WHERE id_product = '19772' 19/07/2022 03:35:00 pm >> UPDATE ps_product_lang SET name = 'BRACCIALE ARGENTO/EMATITE', description = '' WHERE id_product = '19772' 19/07/2022 03:35:00 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '16.39344262295082' WHERE id_product = '19772' 19/07/2022 03:35:00 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 = '19772' 19/07/2022 03:35:00 pm >> DELETE FROM ps_specific_price WHERE id_product = '19772' 19/07/2022 03:35: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 = '19772' 19/07/2022 03:35:06 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19773' , '1' , '' , 'nuovo-prodotto' ) 19/07/2022 03:35: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 '19773' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19772' 19/07/2022 03:35:06 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19773' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19772' 19/07/2022 03:41:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '2301' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-19') 19/07/2022 03:41: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' , '2301' , '2022-07-19' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.00' , '7.00' , NOW() , NOW() ) 19/07/2022 03:41: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 = '59727' 19/07/2022 03:41:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '59727' 19/07/2022 03:41: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 ( '59727' , '7566' , 'PAROLA DEL SIGNORE VANGELI E ATTI' , '1' , '-1' , '4' , '7.00' , '7' , '0' , '0' , '7.00' ) 19/07/2022 03:41:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7566' AND id_supplier = '' 19/07/2022 03:41:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7566' , '' , '1' ) 19/07/2022 03:48:02 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '1481' AND id_product != '19773' AND ean13 != '' 19/07/2022 03:48:02 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '1481', date_upd = NOW() WHERE id_product = '19773' 19/07/2022 03:48:02 pm >> UPDATE ps_product_lang SET name = 'ROSARIO ARGENTO/LEGNO S. BENEDETTO', description = '' WHERE id_product = '19773' 19/07/2022 03:48:02 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '32.704918032786885' WHERE id_product = '19773' 19/07/2022 03:48:02 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 = '19773' 19/07/2022 03:48:02 pm >> DELETE FROM ps_specific_price WHERE id_product = '19773' 19/07/2022 03:48:43 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '1481' AND id_product != '19773' AND ean13 != '' 19/07/2022 03:48:43 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '1481', date_upd = NOW() WHERE id_product = '19773' 19/07/2022 03:48:43 pm >> UPDATE ps_product_lang SET name = 'ROSARIO ARGENTO/LEGNO S. BENEDETTO', description = '' WHERE id_product = '19773' 19/07/2022 03:48:43 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '32.704918032786885' WHERE id_product = '19773' 19/07/2022 03:48:43 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 = '19773' 19/07/2022 03:48:43 pm >> DELETE FROM ps_specific_price WHERE id_product = '19773' 19/07/2022 03:48: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 = '19773' 19/07/2022 03:48:44 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19774' , '1' , '' , 'nuovo-prodotto' ) 19/07/2022 03:48: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 '19774' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19773' 19/07/2022 03:48:44 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19774' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19773' 19/07/2022 03:54:03 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '1738/4AG' AND id_product != '19774' AND ean13 != '' 19/07/2022 03:54:03 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '1738/4AG', date_upd = NOW() WHERE id_product = '19774' 19/07/2022 03:54:03 pm >> UPDATE ps_product_lang SET name = 'ROSARIO ARGENTO', description = '' WHERE id_product = '19774' 19/07/2022 03:54:03 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '46.721311475409834' WHERE id_product = '19774' 19/07/2022 03:54:03 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '46.721311475409834', 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 = '19774' 19/07/2022 03:54:03 pm >> DELETE FROM ps_specific_price WHERE id_product = '19774' 19/07/2022 03:54: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 = '19774' 19/07/2022 03:54:20 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19775' , '1' , '' , 'nuovo-prodotto' ) 19/07/2022 03:54: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 '19775' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19774' 19/07/2022 03:54:20 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19775' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19774' 19/07/2022 03:56:14 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '333' AND id_product != '19775' AND ean13 != '' 19/07/2022 03:56:14 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '333', date_upd = NOW() WHERE id_product = '19775' 19/07/2022 03:56:14 pm >> UPDATE ps_product_lang SET name = 'BRACCIALE ARGENTO/VETRO', description = '' WHERE id_product = '19775' 19/07/2022 03:56:14 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '14.754098360655737' WHERE id_product = '19775' 19/07/2022 03:56:14 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '14.754098360655737', 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 = '19775' 19/07/2022 03:56:14 pm >> DELETE FROM ps_specific_price WHERE id_product = '19775' 19/07/2022 03:56: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 = '19775' 19/07/2022 03:56:39 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19776' , '1' , '' , 'nuovo-prodotto' ) 19/07/2022 03:56: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 '19776' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19775' 19/07/2022 03:56:39 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19776' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19775' 19/07/2022 03:58:38 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '1517/CAV' AND id_product != '19776' AND ean13 != '' 19/07/2022 03:58:38 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '1517/CAV', date_upd = NOW() WHERE id_product = '19776' 19/07/2022 03:58:38 pm >> UPDATE ps_product_lang SET name = 'BRACCIALE ARGENTO/EMATITE', description = '' WHERE id_product = '19776' 19/07/2022 03:58:38 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '16.80327868852459' WHERE id_product = '19776' 19/07/2022 03:58:38 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '16.80327868852459', 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 = '19776' 19/07/2022 03:58:38 pm >> DELETE FROM ps_specific_price WHERE id_product = '19776' 19/07/2022 03:58:43 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 = '19776' 19/07/2022 03:58:43 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19777' , '1' , '' , 'nuovo-prodotto' ) 19/07/2022 03:58:43 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 '19777' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19776' 19/07/2022 03:58:43 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19777' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19776' 19/07/2022 04:00:06 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '6578MIR' AND id_product != '15206' AND ean13 != '' 19/07/2022 04:00:06 pm >> UPDATE ps_product SET id_supplier = '113', reference = '', ean13 = '6578MIR', date_upd = NOW() WHERE id_product = '15206' 19/07/2022 04:00:06 pm >> UPDATE ps_product_lang SET name = 'ANELLO CROCE/MIRACOLOSA', description = '' WHERE id_product = '15206' 19/07/2022 04:00:06 pm >> UPDATE ps_product SET wholesale_price = '4.37', on_sale = '0', price = '10.6557' WHERE id_product = '15206' 19/07/2022 04:00:06 pm >> UPDATE ps_product_shop SET wholesale_price = '4.37', 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 = '15206' 19/07/2022 04:00:06 pm >> DELETE FROM ps_specific_price WHERE id_product = '15206' 19/07/2022 04:01:26 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '6578SB' AND id_product != '19777' AND ean13 != '' 19/07/2022 04:01:26 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '6578SB', date_upd = NOW() WHERE id_product = '19777' 19/07/2022 04:01:26 pm >> UPDATE ps_product_lang SET name = 'ANELLO CROCE/S.BENEDETTO', description = '' WHERE id_product = '19777' 19/07/2022 04:01:26 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '12.295081967213115' WHERE id_product = '19777' 19/07/2022 04:01:26 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '12.295081967213115', 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' 19/07/2022 04:01:26 pm >> DELETE FROM ps_specific_price WHERE id_product = '19777' 19/07/2022 04:01: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 = '19777' 19/07/2022 04:01:39 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19778' , '1' , '' , 'nuovo-prodotto' ) 19/07/2022 04:01: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 '19778' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19777' 19/07/2022 04:01:39 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19778' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19777' 19/07/2022 04:18:25 pm >> SELECT document_num FROM ps_document WHERE document_num = '2302' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-19') 19/07/2022 04:18:25 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2302' , '2022-07-19' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '63.60' , '52.13' , NOW() , NOW() ) 19/07/2022 04:18:25 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '59728' 19/07/2022 04:18:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '59728' 19/07/2022 04:18:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59728' , '19774' , 'ROSARIO ARGENTO' , '1' , '-1' , '1' , '57.00' , '46.72131147541' , '22' , '0' , '57.00' ) 19/07/2022 04:18:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19774' AND id_supplier = '' 19/07/2022 04:18:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19774' , '' , '1' ) 19/07/2022 04:18:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59728' , '13049' , 'LITURGICO ART. 60LT BIANCO SUPER' , '2' , '-2' , '1' , '3.30' , '2.7049180327869' , '22' , '0' , '6.60' ) 19/07/2022 04:18:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13049' AND id_supplier = '' 19/07/2022 04:18:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13049' , '' , '1' ) 19/07/2022 04:21:49 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '6578SR' AND id_product != '19778' AND ean13 != '' 19/07/2022 04:21:49 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '6578SR', date_upd = NOW() WHERE id_product = '19778' 19/07/2022 04:21:49 pm >> UPDATE ps_product_lang SET name = 'ANELLO CROCE/S. RITA', description = '' WHERE id_product = '19778' 19/07/2022 04:21:49 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '10.655737704918034' WHERE id_product = '19778' 19/07/2022 04:21:49 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '10.655737704918034', 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' 19/07/2022 04:21:49 pm >> DELETE FROM ps_specific_price WHERE id_product = '19778' 19/07/2022 04:21: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 = '19778' 19/07/2022 04:21:50 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19779' , '1' , '' , 'nuovo-prodotto' ) 19/07/2022 04:21: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 '19779' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19778' 19/07/2022 04:21:50 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19779' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19778' 19/07/2022 04:22:39 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '6578CUORE' AND id_product != '19779' AND ean13 != '' 19/07/2022 04:22:39 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '6578CUORE', date_upd = NOW() WHERE id_product = '19779' 19/07/2022 04:22:39 pm >> UPDATE ps_product_lang SET name = 'ANELLO CROCE/CUORE', description = '' WHERE id_product = '19779' 19/07/2022 04:22:39 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '12.295081967213115' WHERE id_product = '19779' 19/07/2022 04:22:39 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '12.295081967213115', 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 = '19779' 19/07/2022 04:22:39 pm >> DELETE FROM ps_specific_price WHERE id_product = '19779' 19/07/2022 04:23:14 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 = '19779' 19/07/2022 04:23:14 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19780' , '1' , '' , 'nuovo-prodotto' ) 19/07/2022 04:23:14 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 '19780' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19779' 19/07/2022 04:23:14 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19780' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19779' 19/07/2022 04:24:42 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '1976/CAV' AND id_product != '19780' AND ean13 != '' 19/07/2022 04:24:42 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '1976/CAV', date_upd = NOW() WHERE id_product = '19780' 19/07/2022 04:24:42 pm >> UPDATE ps_product_lang SET name = 'BRACCIALE ARGENTO/EMATITE', description = '' WHERE id_product = '19780' 19/07/2022 04:24:42 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '14.754098360655737' WHERE id_product = '19780' 19/07/2022 04:24:42 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '14.754098360655737', 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 = '19780' 19/07/2022 04:24:42 pm >> DELETE FROM ps_specific_price WHERE id_product = '19780' 19/07/2022 04:25:05 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '1976/CAV' AND id_product != '19780' AND ean13 != '' 19/07/2022 04:25:05 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '1976/CAV', date_upd = NOW() WHERE id_product = '19780' 19/07/2022 04:25:05 pm >> UPDATE ps_product_lang SET name = 'BRACCIALE ARGENTO/EMATITE', description = '' WHERE id_product = '19780' 19/07/2022 04:25:05 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '13.114754098360656' WHERE id_product = '19780' 19/07/2022 04:25:05 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '13.114754098360656', 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 = '19780' 19/07/2022 04:25:05 pm >> DELETE FROM ps_specific_price WHERE id_product = '19780' 19/07/2022 04:25:28 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '19780' 19/07/2022 04:25:28 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19781' , '1' , '' , 'nuovo-prodotto' ) 19/07/2022 04:25:28 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '19781' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19780' 19/07/2022 04:25:28 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19781' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19780' 19/07/2022 04:26:24 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '1793/CAV' AND id_product != '19781' AND ean13 != '' 19/07/2022 04:26:24 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '1793/CAV', date_upd = NOW() WHERE id_product = '19781' 19/07/2022 04:26:24 pm >> UPDATE ps_product_lang SET name = 'BRACCIALE ARGENTO/EMATITE', description = '' WHERE id_product = '19781' 19/07/2022 04:26:24 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '15.163934426229508' WHERE id_product = '19781' 19/07/2022 04:26:24 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '15.163934426229508', 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' 19/07/2022 04:26:24 pm >> DELETE FROM ps_specific_price WHERE id_product = '19781' 19/07/2022 04:26:29 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 = '19781' 19/07/2022 04:26:29 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19782' , '1' , '' , 'nuovo-prodotto' ) 19/07/2022 04:26:29 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 '19782' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19781' 19/07/2022 04:26:29 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19782' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19781' 19/07/2022 04:30:27 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '1993/CAV' AND id_product != '19782' AND ean13 != '' 19/07/2022 04:30:27 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '1993/CAV', date_upd = NOW() WHERE id_product = '19782' 19/07/2022 04:30:27 pm >> UPDATE ps_product_lang SET name = 'BRACCIALE ARGENTO/EMATITE', description = '' WHERE id_product = '19782' 19/07/2022 04:30:27 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '18.852459016393443' WHERE id_product = '19782' 19/07/2022 04:30:27 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 = '19782' 19/07/2022 04:30:27 pm >> DELETE FROM ps_specific_price WHERE id_product = '19782' 19/07/2022 04:30:28 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '19782' 19/07/2022 04:30:28 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19783' , '1' , '' , 'nuovo-prodotto' ) 19/07/2022 04:30:28 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '19783' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19782' 19/07/2022 04:30:28 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19783' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19782' 19/07/2022 04:33:09 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '6413' AND id_product != '19783' AND ean13 != '' 19/07/2022 04:33:09 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '6413', date_upd = NOW() WHERE id_product = '19783' 19/07/2022 04:33:09 pm >> UPDATE ps_product_lang SET name = 'ANELLO CROCE ', description = '' WHERE id_product = '19783' 19/07/2022 04:33:09 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '11.885245901639344' WHERE id_product = '19783' 19/07/2022 04:33:09 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '11.885245901639344', 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 = '19783' 19/07/2022 04:33:09 pm >> DELETE FROM ps_specific_price WHERE id_product = '19783' 19/07/2022 04:33:12 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 = '19783' 19/07/2022 04:33:12 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19784' , '1' , '' , 'nuovo-prodotto' ) 19/07/2022 04:33:12 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 '19784' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19783' 19/07/2022 04:33:12 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19784' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19783' 19/07/2022 04:34:14 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '1994/ELA' AND id_product != '19784' AND ean13 != '' 19/07/2022 04:34:14 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '1994/ELA', date_upd = NOW() WHERE id_product = '19784' 19/07/2022 04:34:14 pm >> UPDATE ps_product_lang SET name = 'BRACCIALE ELASTICO ARGENTO/EMATITE', description = '' WHERE id_product = '19784' 19/07/2022 04:34:14 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '16.311475409836063' WHERE id_product = '19784' 19/07/2022 04:34:14 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '16.311475409836063', 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 = '19784' 19/07/2022 04:34:14 pm >> DELETE FROM ps_specific_price WHERE id_product = '19784' 19/07/2022 04:38:52 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 = '19784' 19/07/2022 04:38:52 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19785' , '1' , '' , 'nuovo-prodotto' ) 19/07/2022 04:38:52 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 '19785' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19784' 19/07/2022 04:38:52 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19785' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19784' 19/07/2022 04:39:46 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002008' AND id_product != '19785' AND ean13 != '' 19/07/2022 04:39:46 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002008', date_upd = NOW() WHERE id_product = '19785' 19/07/2022 04:39:46 pm >> UPDATE ps_product_lang SET name = 'ROSARIO MADREPERLA MM4 - 10M4', description = '' WHERE id_product = '19785' 19/07/2022 04:39:46 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '5.737704918032787' WHERE id_product = '19785' 19/07/2022 04:39:46 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '5.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 = '19785' 19/07/2022 04:39:46 pm >> DELETE FROM ps_specific_price WHERE id_product = '19785' 19/07/2022 04:40:31 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 = '19785' 19/07/2022 04:40:31 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19786' , '1' , '' , 'nuovo-prodotto' ) 19/07/2022 04:40:31 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 '19786' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19785' 19/07/2022 04:40:31 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19786' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19785' 19/07/2022 04:41:01 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002009' AND id_product != '19786' AND ean13 != '' 19/07/2022 04:41:01 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002009', date_upd = NOW() WHERE id_product = '19786' 19/07/2022 04:41:01 pm >> UPDATE ps_product_lang SET name = 'ROSARIO MADREPERLA MM5 - 10M5', description = '' WHERE id_product = '19786' 19/07/2022 04:41:01 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '6.147540983606557' WHERE id_product = '19786' 19/07/2022 04:41:01 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '6.147540983606557', 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 = '19786' 19/07/2022 04:41:01 pm >> DELETE FROM ps_specific_price WHERE id_product = '19786' 19/07/2022 04:41:27 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 = '19786' 19/07/2022 04:41:27 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19787' , '1' , '' , 'nuovo-prodotto' ) 19/07/2022 04:41:27 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 '19787' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19786' 19/07/2022 04:41:27 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19787' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19786' 19/07/2022 04:42:23 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002010' AND id_product != '19787' AND ean13 != '' 19/07/2022 04:42:23 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002010', date_upd = NOW() WHERE id_product = '19787' 19/07/2022 04:42:23 pm >> UPDATE ps_product_lang SET name = 'ROSARIO METALLO MM4 - 48M4', description = '' WHERE id_product = '19787' 19/07/2022 04:42:23 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '4.918032786885246' WHERE id_product = '19787' 19/07/2022 04:42:23 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '4.918032786885246', 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 = '19787' 19/07/2022 04:42:23 pm >> DELETE FROM ps_specific_price WHERE id_product = '19787' 19/07/2022 05:03:07 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' , '827/2022' , '2022-07-18' , '2022' , '0' , '113' , '4669149' , 'VIA VALLE CALDA, 7 16013 CAMPO LIGURE' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '540.56' , '443.08' , NOW() , NOW() ) 19/07/2022 05:03:07 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 = '59729' 19/07/2022 05:03:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '59729' 19/07/2022 05:03: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 ( '59729' , '19769' , 'BRACCIALE ARGENTO S. BENEDETTO' , '2' , '2' , '1' , '23' , '18.852459016393' , '22' , '5' , '53.3140' ) 19/07/2022 05:03:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19769' AND id_supplier = '113' 19/07/2022 05:03:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19769' , '113' , '1' ) 19/07/2022 05:03: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 ( '59729' , '19770' , 'BRACCIALE ARGENTO/ULIVO S. BENEDETTO' , '3' , '3' , '1' , '9.6' , '7.8688524590164' , '22' , '5' , '33.3792' ) 19/07/2022 05:03:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19770' AND id_supplier = '113' 19/07/2022 05:03:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19770' , '113' , '1' ) 19/07/2022 05:03: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 ( '59729' , '19771' , 'ROSARIO ARGENTO/EMATITE' , '3' , '3' , '1' , '13.4' , '10.983606557377' , '22' , '5' , '46.5918' ) 19/07/2022 05:03:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19771' AND id_supplier = '113' 19/07/2022 05:03:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19771' , '113' , '1' ) 19/07/2022 05:03: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 ( '59729' , '19772' , 'BRACCIALE ARGENTO/EMATITE' , '3' , '3' , '1' , '7.4' , '6.0655737704918' , '22' , '5' , '25.7298' ) 19/07/2022 05:03:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19772' AND id_supplier = '113' 19/07/2022 05:03:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19772' , '113' , '1' ) 19/07/2022 05:03: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 ( '59729' , '19773' , 'ROSARIO ARGENTO/LEGNO S. BENEDETTO' , '1' , '1' , '1' , '15.7' , '12.868852459016' , '22' , '5' , '18.1963' ) 19/07/2022 05:03:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19773' AND id_supplier = '113' 19/07/2022 05:03:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19773' , '113' , '1' ) 19/07/2022 05:03: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 ( '59729' , '19774' , 'ROSARIO ARGENTO' , '1' , '1' , '1' , '23.7' , '19.426229508197' , '22' , '5' , '27.4683' ) 19/07/2022 05:03:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19774' AND id_supplier = '113' 19/07/2022 05:03:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19774' , '113' , '1' ) 19/07/2022 05:03: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 ( '59729' , '15206' , 'ANELLO CROCE/MIRACOLOSA' , '10' , '10' , '1' , '4.8' , '3.9344262295082' , '22' , '5' , '55.6320' ) 19/07/2022 05:03:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15206' AND id_supplier = '113' 19/07/2022 05:03:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15206' , '113' , '1' ) 19/07/2022 05:03: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 ( '59729' , '19775' , 'BRACCIALE ARGENTO/VETRO' , '1' , '1' , '1' , '6.7' , '5.4918032786885' , '22' , '5' , '7.7653' ) 19/07/2022 05:03:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19775' AND id_supplier = '113' 19/07/2022 05:03:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19775' , '113' , '1' ) 19/07/2022 05:03:08 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 ( '59729' , '19776' , 'BRACCIALE ARGENTO/EMATITE' , '1' , '1' , '1' , '7.9' , '6.4754098360656' , '22' , '5' , '9.1561' ) 19/07/2022 05:03:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19776' AND id_supplier = '113' 19/07/2022 05:03:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19776' , '113' , '1' ) 19/07/2022 05:03:08 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 ( '59729' , '19777' , 'ANELLO CROCE/S.BENEDETTO' , '2' , '2' , '1' , '5.7' , '4.672131147541' , '22' , '5' , '13.2126' ) 19/07/2022 05:03:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19777' AND id_supplier = '113' 19/07/2022 05:03:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19777' , '113' , '1' ) 19/07/2022 05:03:08 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 ( '59729' , '19778' , 'ANELLO CROCE/S. RITA' , '2' , '2' , '1' , '4.8' , '3.9344262295082' , '22' , '5' , '11.1264' ) 19/07/2022 05:03:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19778' AND id_supplier = '113' 19/07/2022 05:03:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19778' , '113' , '1' ) 19/07/2022 05:03:08 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 ( '59729' , '19779' , 'ANELLO CROCE/CUORE' , '2' , '2' , '1' , '5.2' , '4.2622950819672' , '22' , '5' , '12.0536' ) 19/07/2022 05:03:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19779' AND id_supplier = '113' 19/07/2022 05:03:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19779' , '113' , '1' ) 19/07/2022 05:03:08 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 ( '59729' , '19780' , 'BRACCIALE ARGENTO/EMATITE' , '1' , '1' , '1' , '6.5' , '5.327868852459' , '22' , '5' , '7.5335' ) 19/07/2022 05:03:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19780' AND id_supplier = '113' 19/07/2022 05:03:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19780' , '113' , '1' ) 19/07/2022 05:03:08 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 ( '59729' , '19781' , 'BRACCIALE ARGENTO/EMATITE' , '1' , '1' , '1' , '7.1' , '5.8196721311475' , '22' , '5' , '8.2289' ) 19/07/2022 05:03:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19781' AND id_supplier = '113' 19/07/2022 05:03:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19781' , '113' , '1' ) 19/07/2022 05:03:08 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 ( '59729' , '19782' , 'BRACCIALE ARGENTO/EMATITE' , '1' , '1' , '1' , '8.6' , '7.0491803278689' , '22' , '5' , '9.9674' ) 19/07/2022 05:03:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19782' AND id_supplier = '113' 19/07/2022 05:03:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19782' , '113' , '1' ) 19/07/2022 05:03:08 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 ( '59729' , '19783' , 'ANELLO CROCE ' , '3' , '3' , '1' , '5.6' , '4.5901639344262' , '22' , '5' , '19.4712' ) 19/07/2022 05:03:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19783' AND id_supplier = '113' 19/07/2022 05:03:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19783' , '113' , '1' ) 19/07/2022 05:03:08 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 ( '59729' , '19784' , 'BRACCIALE ELASTICO ARGENTO/EMATITE' , '1' , '1' , '1' , '7.8' , '6.3934426229508' , '22' , '5' , '9.0402' ) 19/07/2022 05:03:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19784' AND id_supplier = '113' 19/07/2022 05:03:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19784' , '113' , '1' ) 19/07/2022 05:03:08 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 ( '59729' , '19785' , 'ROSARIO MADREPERLA MM4 - 10M4' , '18' , '18' , '1' , '2.7' , '2.2131147540984' , '22' , '5' , '56.3274' ) 19/07/2022 05:03:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19785' AND id_supplier = '113' 19/07/2022 05:03:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19785' , '113' , '1' ) 19/07/2022 05:03:08 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 ( '59729' , '19786' , 'ROSARIO MADREPERLA MM5 - 10M5' , '26' , '26' , '1' , '2.8' , '2.2950819672131' , '22' , '5' , '84.3752' ) 19/07/2022 05:03:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19786' AND id_supplier = '113' 19/07/2022 05:03:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19786' , '113' , '1' ) 19/07/2022 05:03:08 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 ( '59729' , '19787' , 'ROSARIO METALLO MM4 - 48M4' , '12' , '12' , '1' , '2.3' , '1.8852459016393' , '22' , '5' , '31.9884' ) 19/07/2022 05:03:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19787' AND id_supplier = '113' 19/07/2022 05:03:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19787' , '113' , '1' ) 19/07/2022 05:04:13 pm >> SELECT document_num FROM ps_document WHERE document_num = '2303' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-19') 19/07/2022 05:04: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 ( '11' , '2303' , '2022-07-19' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.30' , '2.70' , NOW() , NOW() ) 19/07/2022 05:04: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 = '59730' 19/07/2022 05:04:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '59730' 19/07/2022 05:04: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 ( '59730' , '1319' , 'BRACCIALE DECINA TAU' , '1' , '-1' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '1.20' ) 19/07/2022 05:04:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1319' AND id_supplier = '' 19/07/2022 05:04:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1319' , '' , '1' ) 19/07/2022 05:04: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 ( '59730' , '16986' , 'QUADRETTO SMUSSATO 7X10 SACRO CUORE' , '1' , '-1' , '1' , '2.10' , '1.7213114754098' , '22' , '0' , '2.10' ) 19/07/2022 05:04:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16986' AND id_supplier = '' 19/07/2022 05:04:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16986' , '' , '1' ) 19/07/2022 06:04:23 pm >> SELECT document_num FROM ps_document WHERE document_num = '1431' AND id_document != '56637' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-06') 19/07/2022 06:04:23 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1431', document_date = '2022-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 = '12.00', price_tax_excluded = '9.84', date_upd = NOW() WHERE id_document = '56637' 19/07/2022 06:04: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 = '56637' 19/07/2022 06:04:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '56637' 19/07/2022 06:04: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 ( '56637' , '15206' , 'ANELLO CROCE/MIRACOLOSA' , '1' , '-1' , '1' , '12' , '9.8360655737705' , '22' , '0' , '12.00' ) 19/07/2022 06:04:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15206' AND id_supplier = '' 19/07/2022 06:04:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15206' , '' , '1' ) 19/07/2022 06:16:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '2304' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-19') 19/07/2022 06:16:04 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2304' , '2022-07-19' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.50' , '11.89' , NOW() , NOW() ) 19/07/2022 06:16:04 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '59731' 19/07/2022 06:16:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '59731' 19/07/2022 06:16:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59731' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 19/07/2022 06:16:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1710' AND id_supplier = '' 19/07/2022 06:16:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1710' , '' , '1' ) 19/07/2022 06:16:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59731' , '5958' , 'LUCAS 25G - FIORI DARANCIO - EVE ' , '1' , '-1' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '1.50' ) 19/07/2022 06:16:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5958' AND id_supplier = '' 19/07/2022 06:16:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5958' , '' , '1' ) 19/07/2022 06:23:23 pm >> SELECT document_num FROM ps_document WHERE document_num = '2305' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-19') 19/07/2022 06:23: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' , '2305' , '2022-07-19' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '18.00' , '14.75' , NOW() , NOW() ) 19/07/2022 06:23: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 = '59732' 19/07/2022 06:23:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '59732' 19/07/2022 06:23: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 ( '59732' , '12407' , 'SEME DELLA FEDE ORO - 10X15' , '1' , '-1' , '1' , '18.00' , '14.754098360656' , '22' , '0' , '18.00' ) 19/07/2022 06:23:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12407' AND id_supplier = '' 19/07/2022 06:23:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12407' , '' , '1' ) 19/07/2022 06:37:06 pm >> SELECT document_num FROM ps_document WHERE document_num = '2306' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-19') 19/07/2022 06:37: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' , '2306' , '2022-07-19' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '50.00' , '40.98' , NOW() , NOW() ) 19/07/2022 06:37: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 = '59733' 19/07/2022 06:37:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '59733' 19/07/2022 06:37: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 ( '59733' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '50' , '40.983606557377' , '22' , '0' , '50.00' ) 19/07/2022 06:37:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 19/07/2022 06:37:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 19/07/2022 07:38:35 pm >> SELECT document_num FROM ps_document WHERE document_num = '2307' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-19') 19/07/2022 07:38:35 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2307' , '2022-07-19' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.00' , '12.30' , NOW() , NOW() ) 19/07/2022 07:38:35 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '59734' 19/07/2022 07:38:35 pm >> DELETE FROM ps_document_detail WHERE id_document = '59734' 19/07/2022 07:38:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59734' , '1737' , 'CARTA DI IDENTITÀ - RP66' , '10' , '-10' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '15.00' ) 19/07/2022 07:38:35 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1737' AND id_supplier = '' 19/07/2022 07:38:35 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1737' , '' , '1' )