20/07/2023 08:48:31 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3481' 20/07/2023 08:48:31 am >> 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 ( '3481' , '10' , '157' , '' , 'VILLANI' , 'DON MASSIMILIANO ' , 'VIA SAN COLOMBANO 119' , '' , '50018' , 'SCANDICCI' , '' , '' , '3280976012' , '' , '' , NOW() , NOW() ) 20/07/2023 08:48:31 am >> UPDATE ps_customer SET email = 'massimilianovillani.71@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '3481' 20/07/2023 09:04:50 am >> SELECT document_num FROM ps_document WHERE document_num = '2440' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-07-20') 20/07/2023 09:04:50 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2440' , '2023-07-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.25' , '14.25' , NOW() , NOW() ) 20/07/2023 09:04:50 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86823' 20/07/2023 09:04:50 am >> DELETE FROM ps_document_detail WHERE id_document = '86823' 20/07/2023 09:04:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86823' , '21412' , 'COME DARIA - A. DADAMO' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 20/07/2023 09:38:56 am >> SELECT document_num FROM ps_document WHERE document_num = '2441' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-07-20') 20/07/2023 09:38:56 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2441' , '2023-07-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '24.75' , '23.98' , NOW() , NOW() ) 20/07/2023 09:38:56 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 = '86824' 20/07/2023 09:38:56 am >> DELETE FROM ps_document_detail WHERE id_document = '86824' 20/07/2023 09:38:56 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 ( '86824' , '21192' , 'SULLA TUA PAROLA - SET/OTT 23' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 20/07/2023 09:38:56 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 ( '86824' , '11152' , 'VARIE - OSTIE - PARTICOLE' , '1' , '-1' , '3' , '20' , '19.230769230769' , '4' , '0' , '20.00' ) 20/07/2023 09:42:02 am >> SELECT document_num FROM ps_document WHERE document_num = '2441' AND id_document != '86824' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-07-20') 20/07/2023 09:42:02 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2441', document_date = '2023-07-20', 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 = '24.75', price_tax_excluded = '23.98', date_upd = NOW() WHERE id_document = '86824' 20/07/2023 09:42:02 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 = '86824' 20/07/2023 09:42:02 am >> DELETE FROM ps_document_detail WHERE id_document = '86824' 20/07/2023 09:42:02 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 ( '86824' , '21192' , 'SULLA TUA PAROLA - SET/OTT 23' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 20/07/2023 09:42:02 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 ( '86824' , '7311' , 'OSTIA SOTTILE 74MM' , '10' , '-10' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '20.00' ) 20/07/2023 09:57:09 am >> SELECT document_num FROM ps_document WHERE document_num = '2442' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-07-20') 20/07/2023 09:57:09 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2442' , '2023-07-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '25.00' , '20.49' , NOW() , NOW() ) 20/07/2023 09:57:09 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86825' 20/07/2023 09:57:09 am >> DELETE FROM ps_document_detail WHERE id_document = '86825' 20/07/2023 09:57:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86825' , '11694' , 'BRACCIALE ROSARIO LEGNO - 186/R' , '1' , '-1' , '1' , '3.00' , '2.4590163934426' , '22' , '0' , '3.00' ) 20/07/2023 09:57:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86825' , '13142' , 'CERETTI DIAM 26X350 - 2635' , '10' , '-10' , '1' , '2.20' , '1.8032786885246' , '22' , '0' , '22.00' ) 20/07/2023 10:19:17 am >> SELECT document_num FROM ps_document WHERE document_num = '2443' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-07-20') 20/07/2023 10:19:17 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2443' , '2023-07-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '120.00' , '98.36' , NOW() , NOW() ) 20/07/2023 10:19:17 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86826' 20/07/2023 10:19:17 am >> DELETE FROM ps_document_detail WHERE id_document = '86826' 20/07/2023 10:19: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 ( '86826' , '19595' , 'POLO JERSEY COTONE 100% - EXTRA' , '3' , '-3' , '1' , '40' , '32.786885245902' , '22' , '0' , '120.00' ) 20/07/2023 10:19:52 am >> SELECT document_num FROM ps_document WHERE document_num = '2444' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-07-20') 20/07/2023 10:19:52 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2444' , '2023-07-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.00' , '11.48' , NOW() , NOW() ) 20/07/2023 10:19:52 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86827' 20/07/2023 10:19:52 am >> DELETE FROM ps_document_detail WHERE id_document = '86827' 20/07/2023 10:19:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86827' , '17534' , 'CINGOLO - CING05' , '1' , '-1' , '1' , '14.00' , '11.475409836066' , '22' , '0' , '14.00' ) 20/07/2023 10:54:07 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 20/07/2023 10:54:07 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21420' , '1' , '' , 'nuovo-prodotto' ) 20/07/2023 10:54:07 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '21420' , '1' , '1' , '2' , NOW() , NOW() ) 20/07/2023 10:54:07 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '21420' , '0' , '1' , '0' , '0' ) 20/07/2023 10:55:27 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002165' AND id_product != '21420' AND ean13 != '' 20/07/2023 10:55:27 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002165', date_upd = NOW() WHERE id_product = '21420' 20/07/2023 10:55:27 am >> UPDATE ps_product_lang SET name = 'STOLA IN RASO IHS - 7871', description = '' WHERE id_product = '21420' 20/07/2023 10:55:27 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '139.34426229508196' WHERE id_product = '21420' 20/07/2023 10:55:27 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '139.34426229508196', id_tax_rules_group = '1', id_category_default = '448', 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 = '21420' 20/07/2023 10:55:27 am >> DELETE FROM ps_specific_price WHERE id_product = '21420' 20/07/2023 10:55:32 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '21420' 20/07/2023 10:55:32 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21421' , '1' , '' , 'nuovo-prodotto' ) 20/07/2023 10:55:32 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '21421' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21420' 20/07/2023 10:55:32 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21421' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21420' 20/07/2023 10:56:41 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002166' AND id_product != '21421' AND ean13 != '' 20/07/2023 10:56:41 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002166', date_upd = NOW() WHERE id_product = '21421' 20/07/2023 10:56:41 am >> UPDATE ps_product_lang SET name = 'STOLA IN RASO SPIGHE E UVA - 6725', description = '' WHERE id_product = '21421' 20/07/2023 10:56:41 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '139.34426229508196' WHERE id_product = '21421' 20/07/2023 10:56:41 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '139.34426229508196', id_tax_rules_group = '1', id_category_default = '448', 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 = '21421' 20/07/2023 10:56:41 am >> DELETE FROM ps_specific_price WHERE id_product = '21421' 20/07/2023 10:57:17 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002166' AND id_product != '21421' AND ean13 != '' 20/07/2023 10:57:17 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002166', date_upd = NOW() WHERE id_product = '21421' 20/07/2023 10:57:17 am >> UPDATE ps_product_lang SET name = 'STOLA IN RASO SPIGHE E UVA - 6725', description = '' WHERE id_product = '21421' 20/07/2023 10:57:17 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '139.34426229508196' WHERE id_product = '21421' 20/07/2023 10:57:17 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '139.34426229508196', id_tax_rules_group = '1', id_category_default = '448', 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 = '21421' 20/07/2023 10:57:17 am >> DELETE FROM ps_specific_price WHERE id_product = '21421' 20/07/2023 10:57:22 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 = '21421' 20/07/2023 10:57:22 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21422' , '1' , '' , 'nuovo-prodotto' ) 20/07/2023 10:57:22 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 '21422' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21421' 20/07/2023 10:57:22 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21422' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21421' 20/07/2023 11:07:45 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002167' AND id_product != '21422' AND ean13 != '' 20/07/2023 11:07:45 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002167', date_upd = NOW() WHERE id_product = '21422' 20/07/2023 11:07:45 am >> UPDATE ps_product_lang SET name = 'STOLA ROMANA IN RASO BIANCO - 7336S', description = '' WHERE id_product = '21422' 20/07/2023 11:07:45 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '323.7704918032787' WHERE id_product = '21422' 20/07/2023 11:07:45 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '323.7704918032787', id_tax_rules_group = '1', id_category_default = '448', 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 = '21422' 20/07/2023 11:07:45 am >> DELETE FROM ps_specific_price WHERE id_product = '21422' 20/07/2023 11:07:56 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '21422' 20/07/2023 11:07:56 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21423' , '1' , '' , 'nuovo-prodotto' ) 20/07/2023 11:07:56 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '21423' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21422' 20/07/2023 11:07:56 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21423' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21422' 20/07/2023 11:09:48 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002168' AND id_product != '21423' AND ean13 != '' 20/07/2023 11:09:48 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002168', date_upd = NOW() WHERE id_product = '21423' 20/07/2023 11:09:48 am >> UPDATE ps_product_lang SET name = 'STOLA ROMANA S. MOIRE - 7092S', description = '' WHERE id_product = '21423' 20/07/2023 11:09:48 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '282.78688524590166' WHERE id_product = '21423' 20/07/2023 11:09:48 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '282.78688524590166', id_tax_rules_group = '1', id_category_default = '448', 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 = '21423' 20/07/2023 11:09:48 am >> DELETE FROM ps_specific_price WHERE id_product = '21423' 20/07/2023 11:10:08 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002168' AND id_product != '21423' AND ean13 != '' 20/07/2023 11:10:08 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002168', date_upd = NOW() WHERE id_product = '21423' 20/07/2023 11:10:08 am >> UPDATE ps_product_lang SET name = 'STOLA ROMANA S. MOIRE - 7092S', description = '' WHERE id_product = '21423' 20/07/2023 11:10:08 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '282.78688524590166' WHERE id_product = '21423' 20/07/2023 11:10:08 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '282.78688524590166', id_tax_rules_group = '1', id_category_default = '448', 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 = '21423' 20/07/2023 11:10:08 am >> DELETE FROM ps_specific_price WHERE id_product = '21423' 20/07/2023 11:10:09 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '21423' 20/07/2023 11:10:09 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21424' , '1' , '' , 'nuovo-prodotto' ) 20/07/2023 11:10:09 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '21424' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21423' 20/07/2023 11:10:09 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21424' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21423' 20/07/2023 11:11:59 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002169' AND id_product != '21424' AND ean13 != '' 20/07/2023 11:11:59 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002169', date_upd = NOW() WHERE id_product = '21424' 20/07/2023 11:11:59 am >> UPDATE ps_product_lang SET name = 'STOLA ROMANA S. MOIRE\' - 7248S', description = '' WHERE id_product = '21424' 20/07/2023 11:11:59 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '319.672131147541' WHERE id_product = '21424' 20/07/2023 11:11:59 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '319.672131147541', id_tax_rules_group = '1', id_category_default = '448', 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 = '21424' 20/07/2023 11:11:59 am >> DELETE FROM ps_specific_price WHERE id_product = '21424' 20/07/2023 11:12:00 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '21424' 20/07/2023 11:12:00 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21425' , '1' , '' , 'nuovo-prodotto' ) 20/07/2023 11:12:00 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '21425' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21424' 20/07/2023 11:12:00 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21425' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21424' 20/07/2023 11:12:34 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002167' AND id_product != '21422' AND ean13 != '' 20/07/2023 11:12:35 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002167', date_upd = NOW() WHERE id_product = '21422' 20/07/2023 11:12:35 am >> UPDATE ps_product_lang SET name = 'STOLA ROMANA IN RASO BIANCO - 7336S', description = '' WHERE id_product = '21422' 20/07/2023 11:12:35 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '340.1639344262295' WHERE id_product = '21422' 20/07/2023 11:12:35 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '340.1639344262295', id_tax_rules_group = '1', id_category_default = '448', 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 = '21422' 20/07/2023 11:12:35 am >> DELETE FROM ps_specific_price WHERE id_product = '21422' 20/07/2023 11:13:11 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002167' AND id_product != '21422' AND ean13 != '' 20/07/2023 11:13:11 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002167', date_upd = NOW() WHERE id_product = '21422' 20/07/2023 11:13:11 am >> UPDATE ps_product_lang SET name = 'STOLA ROMANA IN RASO BIANCO - 7336S', description = '' WHERE id_product = '21422' 20/07/2023 11:13:11 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '340.1639344262295' WHERE id_product = '21422' 20/07/2023 11:13:11 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '340.1639344262295', id_tax_rules_group = '1', id_category_default = '448', 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 = '21422' 20/07/2023 11:13:11 am >> DELETE FROM ps_specific_price WHERE id_product = '21422' 20/07/2023 11:16:55 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' , '109' , '2023-07-18' , '' , '0' , '126' , '4669995' , 'VIA DELLE INDUSTRIE, 75 06083 BASTIA UMBRA' , '' , '' , '12' , '1' , '0' , '0' , '0' , '' , '10' , '0' , '1161.44' , '952.00' , NOW() , NOW() ) 20/07/2023 11:16:55 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 = '86828' 20/07/2023 11:16:55 am >> DELETE FROM ps_document_detail WHERE id_document = '86828' 20/07/2023 11:16:55 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 ( '86828' , '18421' , 'STOLA RASO CON RICAMO CROCE - 7757' , '1' , '1' , '1' , '50' , '40.983606557377' , '22' , '0' , '61.0000' ) 20/07/2023 11:16:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '18421' AND id_supplier = '126' 20/07/2023 11:16:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18421' , '126' , '1' ) 20/07/2023 11:16:55 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 ( '86828' , '18184' , 'STOLA RASO CON RICAMO UVA - 7877' , '1' , '1' , '1' , '70' , '57.377049180328' , '22' , '0' , '85.4000' ) 20/07/2023 11:16:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '18184' AND id_supplier = '126' 20/07/2023 11:16:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18184' , '126' , '1' ) 20/07/2023 11:16:55 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 ( '86828' , '21420' , 'STOLA IN RASO IHS - 7871' , '1' , '1' , '1' , '70' , '57.377049180328' , '22' , '0' , '85.4000' ) 20/07/2023 11:16:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '21420' AND id_supplier = '126' 20/07/2023 11:16:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21420' , '126' , '1' ) 20/07/2023 11:16:55 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 ( '86828' , '21421' , 'STOLA IN RASO SPIGHE E UVA - 6725' , '4' , '4' , '1' , '70' , '57.377049180328' , '22' , '0' , '341.6000' ) 20/07/2023 11:16:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '21421' AND id_supplier = '126' 20/07/2023 11:16:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21421' , '126' , '1' ) 20/07/2023 11:16:55 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 ( '86828' , '21422' , 'STOLA ROMANA IN RASO BIANCO - 7336S' , '1' , '1' , '1' , '170' , '139.34426229508' , '22' , '0' , '207.4000' ) 20/07/2023 11:16:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '21422' AND id_supplier = '126' 20/07/2023 11:16:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21422' , '126' , '1' ) 20/07/2023 11:16:55 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 ( '86828' , '21423' , 'STOLA ROMANA S. MOIRE - 7092S' , '1' , '1' , '1' , '140' , '114.75409836066' , '22' , '0' , '170.8000' ) 20/07/2023 11:16:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '21423' AND id_supplier = '126' 20/07/2023 11:16:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21423' , '126' , '1' ) 20/07/2023 11:16:56 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 ( '86828' , '21424' , 'STOLA ROMANA S. MOIRE - 7248S' , '1' , '1' , '1' , '160' , '131.14754098361' , '22' , '0' , '195.2000' ) 20/07/2023 11:16:56 am >> DELETE FROM ps_product_supplier WHERE id_product = '21424' AND id_supplier = '126' 20/07/2023 11:16:56 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21424' , '126' , '1' ) 20/07/2023 11:18:23 am >> SELECT document_num FROM ps_document WHERE document_num = '2445' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-07-20') 20/07/2023 11:18:23 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2445' , '2023-07-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '345.00' , '282.79' , NOW() , NOW() ) 20/07/2023 11:18:23 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86829' 20/07/2023 11:18:23 am >> DELETE FROM ps_document_detail WHERE id_document = '86829' 20/07/2023 11:18:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86829' , '21376' , 'CASULA POL. LEGGERO - CS25L' , '1' , '-1' , '1' , '65.00' , '53.27868852459' , '22' , '0' , '65.00' ) 20/07/2023 11:18:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86829' , '14354' , 'CAMICE BENEDETTINO LINO - 3010' , '2' , '-2' , '1' , '140' , '114.75409836066' , '22' , '0' , '280.00' ) 20/07/2023 11:48:33 am >> SELECT document_num FROM ps_document WHERE document_num = '2446' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-07-20') 20/07/2023 11:48:33 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2446' , '2023-07-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '24.50' , '20.08' , NOW() , NOW() ) 20/07/2023 11:48:33 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86830' 20/07/2023 11:48:33 am >> DELETE FROM ps_document_detail WHERE id_document = '86830' 20/07/2023 11:48:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86830' , '20077' , 'BRACCIALE ARGENTO - 1375CAV' , '1' , '-1' , '1' , '24.50' , '20.081967213115' , '22' , '0' , '24.50' ) 20/07/2023 11:51:32 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788815149503' AND id_product != '21425' AND ean13 != '' 20/07/2023 11:51:32 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788815149503', date_upd = NOW() WHERE id_product = '21425' 20/07/2023 11:51:32 am >> UPDATE ps_product_lang SET name = 'LIBERI TUTTI', description = '' WHERE id_product = '21425' 20/07/2023 11:51:32 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '14' WHERE id_product = '21425' 20/07/2023 11:51:32 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '14', id_tax_rules_group = '4', id_category_default = '364', 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 = '21425' 20/07/2023 11:51:32 am >> DELETE FROM ps_specific_price WHERE id_product = '21425' 20/07/2023 11:51: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 = '21425' 20/07/2023 11:51:33 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21426' , '1' , '' , 'nuovo-prodotto' ) 20/07/2023 11:51: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 '21426' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21425' 20/07/2023 11:51:33 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21426' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21425' 20/07/2023 11:52:55 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788870949681' AND id_product != '21426' AND ean13 != '' 20/07/2023 11:52:55 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788870949681', date_upd = NOW() WHERE id_product = '21426' 20/07/2023 11:52:55 am >> UPDATE ps_product_lang SET name = 'COMMENTO AL VANGELO DI GIOVANNI - VOL I - T. D\'AQUINO', description = '' WHERE id_product = '21426' 20/07/2023 11:52:55 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '49' WHERE id_product = '21426' 20/07/2023 11:52:55 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '49', id_tax_rules_group = '4', id_category_default = '77', id_argoment_default = '20', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21426' 20/07/2023 11:52:55 am >> DELETE FROM ps_specific_price WHERE id_product = '21426' 20/07/2023 11:52:56 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '21426' 20/07/2023 11:52:56 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21427' , '1' , '' , 'nuovo-prodotto' ) 20/07/2023 11:52:56 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '21427' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21426' 20/07/2023 11:52:56 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21427' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21426' 20/07/2023 11:55:27 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788832713930' AND id_product != '21427' AND ean13 != '' 20/07/2023 11:55:27 am >> UPDATE ps_product SET id_supplier = '', reference = '1/2', ean13 = '9788832713930', date_upd = NOW() WHERE id_product = '21427' 20/07/2023 11:55:27 am >> UPDATE ps_product_lang SET name = 'WORK IN PROGRESS', description = '' WHERE id_product = '21427' 20/07/2023 11:55:27 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '7' WHERE id_product = '21427' 20/07/2023 11:55:27 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '7', id_tax_rules_group = '4', id_category_default = '80', id_argoment_default = '251', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21427' 20/07/2023 11:55:27 am >> DELETE FROM ps_specific_price WHERE id_product = '21427' 20/07/2023 11:55:28 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 = '21427' 20/07/2023 11:55:28 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21428' , '1' , '' , 'nuovo-prodotto' ) 20/07/2023 11:55:28 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 '21428' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21427' 20/07/2023 11:55:28 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21428' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21427' 20/07/2023 11:56:11 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788832713886' AND id_product != '21428' AND ean13 != '' 20/07/2023 11:56:11 am >> UPDATE ps_product SET id_supplier = '', reference = '2/4', ean13 = '9788832713886', date_upd = NOW() WHERE id_product = '21428' 20/07/2023 11:56:12 am >> UPDATE ps_product_lang SET name = 'TOCCA A TE - GUIDA 2023/24 GIOVANI', description = '' WHERE id_product = '21428' 20/07/2023 11:56:12 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '11.5' WHERE id_product = '21428' 20/07/2023 11:56:12 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '11.5', id_tax_rules_group = '4', id_category_default = '80', id_argoment_default = '251', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21428' 20/07/2023 11:56:12 am >> DELETE FROM ps_specific_price WHERE id_product = '21428' 20/07/2023 11:56:12 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '21428' 20/07/2023 11:56:12 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21429' , '1' , '' , 'nuovo-prodotto' ) 20/07/2023 11:56:12 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '21429' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21428' 20/07/2023 11:56:12 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21429' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21428' 20/07/2023 11:56:54 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788832713855' AND id_product != '21429' AND ean13 != '' 20/07/2023 11:56:54 am >> UPDATE ps_product SET id_supplier = '', reference = '1/2', ean13 = '9788832713855', date_upd = NOW() WHERE id_product = '21429' 20/07/2023 11:56:54 am >> UPDATE ps_product_lang SET name = 'VITE A CONTATTO - ADULTI', description = '' WHERE id_product = '21429' 20/07/2023 11:56:54 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '11' WHERE id_product = '21429' 20/07/2023 11:56:54 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '11', id_tax_rules_group = '4', id_category_default = '80', id_argoment_default = '251', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21429' 20/07/2023 11:56:54 am >> DELETE FROM ps_specific_price WHERE id_product = '21429' 20/07/2023 11:56:55 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 = '21429' 20/07/2023 11:56:55 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21430' , '1' , '' , 'nuovo-prodotto' ) 20/07/2023 11:56:55 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 '21430' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21429' 20/07/2023 11:56:55 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21430' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21429' 20/07/2023 11:57:17 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' , '102619' , '2023-07-18' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '438.40' , '438.40' , NOW() , NOW() ) 20/07/2023 11:57:17 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86831' 20/07/2023 11:57:17 am >> DELETE FROM ps_document_detail WHERE id_document = '86831' 20/07/2023 11:57: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 ( '86831' , '21425' , 'LIBERI TUTTI' , '1' , '1' , '4' , '14.00' , '14' , '0' , '0' , '14.00' ) 20/07/2023 11:57:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '21425' AND id_supplier = '109' 20/07/2023 11:57:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21425' , '109' , '1' ) 20/07/2023 11:57: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 ( '86831' , '21426' , 'COMMENTO AL VANGELO DI GIOVANNI - VOL I - T. DAQUINO' , '1' , '1' , '4' , '49.00' , '49' , '0' , '0' , '49.00' ) 20/07/2023 11:57:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '21426' AND id_supplier = '109' 20/07/2023 11:57:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21426' , '109' , '1' ) 20/07/2023 11:57: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 ( '86831' , '10916' , 'UNA COMUNITÀ LEGGE IL VANGELO DI MARCO' , '2' , '2' , '4' , '57.00' , '57' , '0' , '0' , '114.0000' ) 20/07/2023 11:57:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '10916' AND id_supplier = '109' 20/07/2023 11:57:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10916' , '109' , '1' ) 20/07/2023 11:57: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 ( '86831' , '1142' , 'BIBBIA DI GERUSALEMME - TASC.' , '2' , '2' , '4' , '31.00' , '31' , '0' , '0' , '62.0000' ) 20/07/2023 11:57:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '1142' AND id_supplier = '109' 20/07/2023 11:57:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1142' , '109' , '1' ) 20/07/2023 11:57: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 ( '86831' , '10915' , 'UNA COMUNITÀ LEGGE IL VANGELO DI LUCA' , '1' , '1' , '4' , '63.00' , '63' , '0' , '0' , '63.00' ) 20/07/2023 11:57:18 am >> DELETE FROM ps_product_supplier WHERE id_product = '10915' AND id_supplier = '109' 20/07/2023 11:57:18 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10915' , '109' , '1' ) 20/07/2023 11:57:18 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 ( '86831' , '2824' , 'COSTITUZIONI DEL VATICANO II - CONCILIO VATICANO II' , '1' , '1' , '4' , '4.90' , '4.9' , '0' , '0' , '4.90' ) 20/07/2023 11:57:18 am >> DELETE FROM ps_product_supplier WHERE id_product = '2824' AND id_supplier = '109' 20/07/2023 11:57:18 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2824' , '109' , '1' ) 20/07/2023 11:57:18 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 ( '86831' , '10917' , 'UNA COMUNITÀ LEGGE IL VANGELO DI MATTEO' , '2' , '2' , '4' , '51.00' , '51' , '0' , '0' , '102.0000' ) 20/07/2023 11:57:18 am >> DELETE FROM ps_product_supplier WHERE id_product = '10917' AND id_supplier = '109' 20/07/2023 11:57:18 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10917' , '109' , '1' ) 20/07/2023 11:57:18 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 ( '86831' , '21427' , 'WORK IN PROGRESS' , '1' , '1' , '4' , '7.00' , '7' , '0' , '0' , '7.00' ) 20/07/2023 11:57:18 am >> DELETE FROM ps_product_supplier WHERE id_product = '21427' AND id_supplier = '109' 20/07/2023 11:57:18 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21427' , '109' , '1' ) 20/07/2023 11:57:18 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 ( '86831' , '21428' , 'TOCCA A TE - GUIDA 2023/24 GIOVANI' , '1' , '1' , '4' , '11.50' , '11.5' , '0' , '0' , '11.50' ) 20/07/2023 11:57:18 am >> DELETE FROM ps_product_supplier WHERE id_product = '21428' AND id_supplier = '109' 20/07/2023 11:57:18 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21428' , '109' , '1' ) 20/07/2023 11:57:18 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 ( '86831' , '21429' , 'VITE A CONTATTO - ADULTI' , '1' , '1' , '4' , '11.00' , '11' , '0' , '0' , '11.00' ) 20/07/2023 11:57:18 am >> DELETE FROM ps_product_supplier WHERE id_product = '21429' AND id_supplier = '109' 20/07/2023 11:57:18 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21429' , '109' , '1' ) 20/07/2023 12:52:56 pm >> SELECT document_num FROM ps_document WHERE document_num = '2447' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-07-20') 20/07/2023 12:52:56 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2447' , '2023-07-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '65.00' , '61.39' , NOW() , NOW() ) 20/07/2023 12:52:56 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86832' 20/07/2023 12:52:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '86832' 20/07/2023 12:52:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86832' , '18893' , 'ROSARIO PIETRA - R472' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 20/07/2023 12:52:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86832' , '19717' , 'ROSARIO LEGNO SAN BENEDETTO - RE5042NAT' , '1' , '-1' , '1' , '5' , '4.0983606557377' , '22' , '0' , '5.00' ) 20/07/2023 12:52:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86832' , '18354' , 'PORTA ROSARIO IN VELLUTO GRANDE - 314- NT 4' , '2' , '-2' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '2.00' ) 20/07/2023 12:52:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86832' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '45' , '45' , '0' , '0' , '45.00' ) 20/07/2023 04:32:49 pm >> SELECT document_num FROM ps_document WHERE document_num = '2448' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-07-20') 20/07/2023 04:32:50 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' , '2448' , '2023-07-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.98' , '9.98' , NOW() , NOW() ) 20/07/2023 04:32:50 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 = '86833' 20/07/2023 04:32:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '86833' 20/07/2023 04:32:50 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 ( '86833' , '9441' , 'SAN GERARDO MAIELLA' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 20/07/2023 04:32:50 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 ( '86833' , '4310' , 'FRATICELLO CHE GIOCAVA CON DIO - S. GERARDO' , '1' , '-1' , '4' , '7.00' , '7' , '0' , '5' , '6.65' ) 20/07/2023 04:34:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '2337' AND id_document != '86690' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-07-08') 20/07/2023 04:34:04 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2337', document_date = '2023-07-08', 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 = '249.70', price_tax_excluded = '231.09', date_upd = NOW() WHERE id_document = '86690' 20/07/2023 04:34: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 = '86690' 20/07/2023 04:34:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '86690' 20/07/2023 04:34: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 ( '86690' , '6811' , 'MOCCOLO 80X200' , '3' , '-3' , '1' , '9.0000' , '7.3770491803279' , '22' , '0' , '27.00' ) 20/07/2023 04:34: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 ( '86690' , '11384' , 'VINO BIANCO DOLCE - 102' , '2' , '-2' , '1' , '8.5000' , '6.9672131147541' , '22' , '0' , '17.00' ) 20/07/2023 04:34: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 ( '86690' , '9442' , 'SAN GERARDO MAIELLA - 52' , '4' , '-4' , '1' , '3.8000' , '3.1147540983607' , '22' , '0' , '15.20' ) 20/07/2023 04:34: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 ( '86690' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' , '-2' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '7.00' ) 20/07/2023 04:34: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 ( '86690' , '21192' , 'SULLA TUA PAROLA - SET/OTT 23' , '1' , '-1' , '4' , '3.9' , '3.9' , '0' , '0' , '3.90' ) 20/07/2023 04:34: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 ( '86690' , '19877' , 'CROCE VETRO FIORE - 755/820' , '1' , '-1' , '1' , '35.0000' , '28.688524590164' , '22' , '0' , '35.00' ) 20/07/2023 04:34: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 ( '86690' , '15097' , 'CORONA MATRIMONIO - ORO' , '1' , '-1' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '7.50' ) 20/07/2023 04:34: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 ( '86690' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '120' , '-120' , '4' , '0.7000' , '0.7' , '0' , '0' , '84.00' ) 20/07/2023 04:34: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 ( '86690' , '9253' , 'SACRA BIBBIA CEI - UELCI' , '1' , '-1' , '4' , '17.0000' , '17' , '0' , '0' , '17.00' ) 20/07/2023 04:34: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 ( '86690' , '21003' , 'FARE CATECHESI OGGI - U. MONTISCI' , '1' , '-1' , '4' , '38.0000' , '38' , '0' , '5' , '36.10' ) 20/07/2023 05:00:06 pm >> SELECT document_num FROM ps_document WHERE document_num = '2449' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-07-20') 20/07/2023 05:00: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' , '2449' , '2023-07-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '110.00' , '90.16' , NOW() , NOW() ) 20/07/2023 05:00: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 = '86834' 20/07/2023 05:00:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '86834' 20/07/2023 05:00: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 ( '86834' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 20/07/2023 05:00: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 ( '86834' , '20850' , 'CARTUCCIA ' , '2' , '-2' , '1' , '35' , '28.688524590164' , '22' , '0' , '70.00' ) 20/07/2023 05:00: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 ( '86834' , '12578' , 'RICAMBIO VETRO PER ART. 486 - 65' , '2' , '-2' , '1' , '15.00' , '12.295081967213' , '22' , '0' , '30.00' ) 20/07/2023 05:05:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '2450' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-07-20') 20/07/2023 05:05: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' , '2450' , '2023-07-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 20/07/2023 05:05: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 = '86835' 20/07/2023 05:05:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '86835' 20/07/2023 05:05: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 ( '86835' , '16024' , 'IL MESE DI FEBBRAIO CON MARIA - 8979' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 20/07/2023 05:07:12 pm >> SELECT document_num FROM ps_document WHERE document_num = '2370' AND id_document != '86731' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-07-12') 20/07/2023 05:07:12 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2370', document_date = '2023-07-12', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '28.00', price_tax_excluded = '24.90', date_upd = NOW() WHERE id_document = '86731' 20/07/2023 05:07:12 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86731' 20/07/2023 05:07:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '86731' 20/07/2023 05:07: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 ( '86731' , '17610' , 'CATENINA IN ACCIAIO CM 55' , '1' , '-1' , '1' , '4.2000' , '3.4426229508197' , '22' , '0' , '4.20' ) 20/07/2023 05:07: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 ( '86731' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '4.15' , '4.15' , '0' , '0' , '4.15' ) 20/07/2023 05:07: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 ( '86731' , '19778' , 'ANELLO CROCE/S. RITA - 6578SR' , '1' , '-1' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '13.00' ) 20/07/2023 05:07: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 ( '86731' , '4310' , 'FRATICELLO CHE GIOCAVA CON DIO - S. GERARDO' , '1' , '-1' , '4' , '7.00' , '7' , '0' , '5' , '6.65' ) 20/07/2023 05:09:02 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884040893' AND id_product != '4310' AND ean13 != '' 20/07/2023 05:09:02 pm >> UPDATE ps_product SET id_supplier = '38', reference = 'ESPOSITORE SHALOM', ean13 = '9788884040893', date_upd = NOW() WHERE id_product = '4310' 20/07/2023 05:09:02 pm >> UPDATE ps_product_lang SET name = 'FRATICELLO CHE GIOCAVA CON DIO - S. GERARDO - 8328', description = '' WHERE id_product = '4310' 20/07/2023 05:09:02 pm >> UPDATE ps_product SET wholesale_price = '4.20', on_sale = '0', price = '7.0000' WHERE id_product = '4310' 20/07/2023 05:09:02 pm >> UPDATE ps_product_shop SET wholesale_price = '4.20', price = '7.0000', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '53', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '4310' 20/07/2023 05:09:02 pm >> DELETE FROM ps_specific_price WHERE id_product = '4310' 20/07/2023 05:33:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '2451' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-07-20') 20/07/2023 05:33:14 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2451' , '2023-07-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '93.10' , '93.10' , NOW() , NOW() ) 20/07/2023 05:33:14 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86836' 20/07/2023 05:33:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '86836' 20/07/2023 05:33:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86836' , '21404' , 'COMMENTO AL VANGELO DI GIOVANNI - T. DAQUINO' , '1' , '-1' , '4' , '49.00' , '49' , '0' , '5' , '46.55' ) 20/07/2023 05:33:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86836' , '21426' , 'COMMENTO AL VANGELO DI GIOVANNI - VOL I - T. DAQUINO' , '1' , '-1' , '4' , '49.00' , '49' , '0' , '5' , '46.55' ) 20/07/2023 06:17:29 pm >> SELECT document_num FROM ps_document WHERE document_num = '2452' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-07-20') 20/07/2023 06:17:29 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2452' , '2023-07-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.50' , '2.87' , NOW() , NOW() ) 20/07/2023 06:17:29 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86837' 20/07/2023 06:17:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '86837' 20/07/2023 06:17:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86837' , '13049' , 'LITURGICO ART. 60LT BIANCO SUPER' , '1' , '-1' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '3.50' )