16/03/2023 08:57:03 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884048493' AND id_product != '20795' AND ean13 != '' 16/03/2023 08:57:03 am >> UPDATE ps_product SET id_supplier = '38', reference = '', ean13 = '9788884048493', date_upd = NOW() WHERE id_product = '20795' 16/03/2023 08:57:03 am >> UPDATE ps_product_lang SET name = 'SULLA TUA PAROLA MAG/GIU 2023 - 516', description = '' WHERE id_product = '20795' 16/03/2023 08:57:03 am >> UPDATE ps_product SET wholesale_price = '3.00', on_sale = '0', price = '5.0000' WHERE id_product = '20795' 16/03/2023 08:57:03 am >> UPDATE ps_product_shop SET wholesale_price = '3.00', price = '5.0000', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '64', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20795' 16/03/2023 08:57:03 am >> DELETE FROM ps_specific_price WHERE id_product = '20795' 16/03/2023 09:03:41 am >> SELECT ean13 FROM ps_product WHERE ean13 = '000400' AND id_product != '7553' AND ean13 != '' 16/03/2023 09:03:41 am >> UPDATE ps_product SET id_supplier = '12', reference = '2013', ean13 = '000400', date_upd = NOW() WHERE id_product = '7553' 16/03/2023 09:03:41 am >> UPDATE ps_product_lang SET name = 'PARAFIAMMA PIREX PER CARTUCCIA 3.2 - 474/25', description = '' WHERE id_product = '7553' 16/03/2023 09:03:41 am >> UPDATE ps_product SET wholesale_price = '3.28', on_sale = '0', price = '8.19672131147541' WHERE id_product = '7553' 16/03/2023 09:03:41 am >> UPDATE ps_product_shop SET wholesale_price = '3.28', price = '8.19672131147541', id_tax_rules_group = '1', id_category_default = '147', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '7553' 16/03/2023 09:03:41 am >> DELETE FROM ps_specific_price WHERE id_product = '7553' 16/03/2023 09:17:14 am >> SELECT ean13 FROM ps_product WHERE ean13 = '000450' AND id_product != '6011' AND ean13 != '' 16/03/2023 09:17:14 am >> UPDATE ps_product SET id_supplier = '12', reference = '2013', ean13 = '000450', date_upd = NOW() WHERE id_product = '6011' 16/03/2023 09:17:14 am >> UPDATE ps_product_lang SET name = 'LUMINELLO VETRO - 474', description = '' WHERE id_product = '6011' 16/03/2023 09:17:14 am >> UPDATE ps_product SET wholesale_price = '4.28', on_sale = '0', price = '8.1967' WHERE id_product = '6011' 16/03/2023 09:17:14 am >> UPDATE ps_product_shop SET wholesale_price = '4.28', price = '8.1967', id_tax_rules_group = '1', id_category_default = '147', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '6011' 16/03/2023 09:17:14 am >> DELETE FROM ps_specific_price WHERE id_product = '6011' 16/03/2023 09:19:06 am >> SELECT ean13 FROM ps_product WHERE ean13 = '001812' AND id_product != '18799' AND ean13 != '' 16/03/2023 09:19:06 am >> UPDATE ps_product SET id_supplier = '12', reference = '', ean13 = '001812', date_upd = NOW() WHERE id_product = '18799' 16/03/2023 09:19:06 am >> UPDATE ps_product_lang SET name = 'PARAFIAMMA PIREX PER CARTUCCIA 4 CM - 474/30', description = '' WHERE id_product = '18799' 16/03/2023 09:19:06 am >> UPDATE ps_product SET wholesale_price = '3.80', on_sale = '0', price = '8.19672131147541' WHERE id_product = '18799' 16/03/2023 09:19:06 am >> UPDATE ps_product_shop SET wholesale_price = '3.80', price = '8.19672131147541', id_tax_rules_group = '1', id_category_default = '147', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '18799' 16/03/2023 09:19:06 am >> DELETE FROM ps_specific_price WHERE id_product = '18799' 16/03/2023 09:20:12 am >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'DSsLpqO6JaLEPEDh' , NOW() , NOW() ) 16/03/2023 09:20:12 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '7039' , '1' ) 16/03/2023 09:20:12 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '7039' , '2' ) 16/03/2023 09:20:12 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '7039' , '3' ) 16/03/2023 09:22:12 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '7039' 16/03/2023 09:22:13 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 ( '7039' , '10' , '208' , '' , 'CILLI' , 'NORMA' , 'VIA DELLE BALENERE 126 INTERNO B/10' , '' , '00121' , 'OSTIA' , 'GIRARDI ELEONORA (FIGLIA)' , '0656342674' , '3333081041' , '' , '' , NOW() , NOW() ) 16/03/2023 09:22:13 am >> UPDATE ps_customer SET email = '', sdi = 'annacilli55@gmail.com', pec = '', date_upd = NOW() WHERE id_customer = '7039' 16/03/2023 09:23:01 am >> SELECT document_num FROM ps_document WHERE document_num = '13' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-03-16') 16/03/2023 09:23:01 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '13' , '2023-03-16' , '' , '7039' , '0' , '130686723' , 'VIA DELLE BALENERE 126 INTERNO B/10 00121 OSTIA' , '' , '' , '6.25' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '70.00' , '70.00' , NOW() , NOW() ) 16/03/2023 09:23:01 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '11059' 16/03/2023 09:23:01 am >> DELETE FROM ps_document_detail WHERE id_document = '11059' 16/03/2023 09:23:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11059' , '25' , 'PICCOLO DIZIONARIO DEL CRISTIANO' , '25' , '-25' , '4' , '3.00' , '3' , '0' , '15' , '63.75' ) 16/03/2023 09:34:04 am >> SELECT ean13 FROM ps_product WHERE ean13 = '000692' AND id_product != '4200' AND ean13 != '' 16/03/2023 09:34:04 am >> UPDATE ps_product SET id_supplier = '12', reference = '2015', ean13 = '000692', date_upd = NOW() WHERE id_product = '4200' 16/03/2023 09:34:04 am >> UPDATE ps_product_lang SET name = 'FINTA CANDELA 3,2X80 - 136', description = '' WHERE id_product = '4200' 16/03/2023 09:34:04 am >> UPDATE ps_product SET wholesale_price = '5.70', on_sale = '0', price = '13.114754098360656' WHERE id_product = '4200' 16/03/2023 09:34:04 am >> UPDATE ps_product_shop SET wholesale_price = '5.70', price = '13.114754098360656', id_tax_rules_group = '1', id_category_default = '147', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '4200' 16/03/2023 09:34:04 am >> DELETE FROM ps_specific_price WHERE id_product = '4200' 16/03/2023 09:39:17 am >> SELECT ean13 FROM ps_product WHERE ean13 = '000692' AND id_product != '4200' AND ean13 != '' 16/03/2023 09:39:17 am >> UPDATE ps_product SET id_supplier = '12', reference = '2015', ean13 = '000692', date_upd = NOW() WHERE id_product = '4200' 16/03/2023 09:39:17 am >> UPDATE ps_product_lang SET name = 'FINTA CANDELA 3,2X80 - 136', description = '' WHERE id_product = '4200' 16/03/2023 09:39:17 am >> UPDATE ps_product SET wholesale_price = '5.70', on_sale = '0', price = '13.934426229508198' WHERE id_product = '4200' 16/03/2023 09:39:17 am >> UPDATE ps_product_shop SET wholesale_price = '5.70', price = '13.934426229508198', id_tax_rules_group = '1', id_category_default = '147', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '4200' 16/03/2023 09:39:17 am >> DELETE FROM ps_specific_price WHERE id_product = '4200' 16/03/2023 09:41:51 am >> SELECT document_num FROM ps_document WHERE document_num = '858' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-16') 16/03/2023 09:41:51 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' , '858' , '2023-03-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '35.00' , '28.69' , NOW() , NOW() ) 16/03/2023 09:41:51 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 = '82318' 16/03/2023 09:41:51 am >> DELETE FROM ps_document_detail WHERE id_document = '82318' 16/03/2023 09:41:51 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 ( '82318' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '35' , '28.688524590164' , '22' , '0' , '35.00' ) 16/03/2023 09:55:58 am >> SELECT ean13 FROM ps_product WHERE ean13 = '1000000017793' AND id_product != '15000' AND ean13 != '' 16/03/2023 09:55:58 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '1000000017793', date_upd = NOW() WHERE id_product = '15000' 16/03/2023 09:55:58 am >> UPDATE ps_product_lang SET name = 'TECA ALTA IHS - 825', description = '' WHERE id_product = '15000' 16/03/2023 09:55:59 am >> UPDATE ps_product SET wholesale_price = '10.45', on_sale = '0', price = '24.59016393442623' WHERE id_product = '15000' 16/03/2023 09:55:59 am >> UPDATE ps_product_shop SET wholesale_price = '10.45', price = '24.59016393442623', id_tax_rules_group = '1', id_category_default = '147', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '15000' 16/03/2023 09:55:59 am >> DELETE FROM ps_specific_price WHERE id_product = '15000' 16/03/2023 09:56:53 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 16/03/2023 09:56:54 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20850' , '1' , '' , 'nuovo-prodotto' ) 16/03/2023 09:56:54 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '20850' , '1' , '1' , '2' , NOW() , NOW() ) 16/03/2023 09:56:54 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '20850' , '0' , '1' , '0' , '0' ) 16/03/2023 09:58:00 am >> SELECT ean13 FROM ps_product WHERE ean13 = '486/C' AND id_product != '20850' AND ean13 != '' 16/03/2023 09:58:00 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '486/C', date_upd = NOW() WHERE id_product = '20850' 16/03/2023 09:58:00 am >> UPDATE ps_product_lang SET name = 'CARTUCCIA ', description = '' WHERE id_product = '20850' 16/03/2023 09:58:00 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '30.327868852459016' WHERE id_product = '20850' 16/03/2023 09:58:00 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '30.327868852459016', id_tax_rules_group = '1', id_category_default = '147', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20850' 16/03/2023 09:58:00 am >> DELETE FROM ps_specific_price WHERE id_product = '20850' 16/03/2023 10:02:11 am >> SELECT ean13 FROM ps_product WHERE ean13 = '1000000017755' AND id_product != '11805' AND ean13 != '' 16/03/2023 10:02:11 am >> UPDATE ps_product SET id_supplier = '12', reference = '', ean13 = '1000000017755', date_upd = NOW() WHERE id_product = '11805' 16/03/2023 10:02:11 am >> UPDATE ps_product_lang SET name = 'TECA IHS - 823', description = '' WHERE id_product = '11805' 16/03/2023 10:02:11 am >> UPDATE ps_product SET wholesale_price = '11.54', on_sale = '0', price = '20.491803278688526' WHERE id_product = '11805' 16/03/2023 10:02:11 am >> UPDATE ps_product_shop SET wholesale_price = '11.54', price = '20.491803278688526', id_tax_rules_group = '1', id_category_default = '147', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '11805' 16/03/2023 10:02:11 am >> DELETE FROM ps_specific_price WHERE id_product = '11805' 16/03/2023 10:03:46 am >> SELECT ean13 FROM ps_product WHERE ean13 = '1000000032130' AND id_product != '20850' AND ean13 != '' 16/03/2023 10:03:46 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '1000000032130', date_upd = NOW() WHERE id_product = '20850' 16/03/2023 10:03:46 am >> UPDATE ps_product_lang SET name = 'CARTUCCIA ', description = '' WHERE id_product = '20850' 16/03/2023 10:03:46 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '30.3279' WHERE id_product = '20850' 16/03/2023 10:03:46 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '30.3279', id_tax_rules_group = '1', id_category_default = '147', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20850' 16/03/2023 10:03:46 am >> DELETE FROM ps_specific_price WHERE id_product = '20850' 16/03/2023 10:04:27 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 16/03/2023 10:04:27 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20851' , '1' , '' , 'nuovo-prodotto' ) 16/03/2023 10:04:27 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '20851' , '1' , '1' , '2' , NOW() , NOW() ) 16/03/2023 10:04:27 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '20851' , '0' , '1' , '0' , '0' ) 16/03/2023 10:05:22 am >> SELECT ean13 FROM ps_product WHERE ean13 = '1000000004250' AND id_product != '20851' AND ean13 != '' 16/03/2023 10:05:22 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '1000000004250', date_upd = NOW() WHERE id_product = '20851' 16/03/2023 10:05:22 am >> UPDATE ps_product_lang SET name = 'FINTA CANDELA COMPLETA CARTUCCIA 8X25 - 1187', description = '' WHERE id_product = '20851' 16/03/2023 10:05:23 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '31.557377049180328' WHERE id_product = '20851' 16/03/2023 10:05:23 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '31.557377049180328', id_tax_rules_group = '1', id_category_default = '147', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20851' 16/03/2023 10:05:23 am >> DELETE FROM ps_specific_price WHERE id_product = '20851' 16/03/2023 10:06:10 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '857' , '2023-03-13' , '' , '0' , '12' , '2607' , 'VIA NAZIONALE NORD, 4 - LAGARO 40035 CASTIGLIONE DEI PEPOLI' , '' , '' , '17.65' , '1' , '0' , '0' , '0' , '' , '9' , '0' , '719.25' , '589.55' , NOW() , NOW() ) 16/03/2023 10:06:10 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82319' 16/03/2023 10:06:10 am >> DELETE FROM ps_document_detail WHERE id_document = '82319' 16/03/2023 10:06:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82319' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '100' , '100' , '1' , '0.23' , '0.18852459016393' , '22' , '5' , '26.6570' ) 16/03/2023 10:06:10 am >> DELETE FROM ps_product_supplier WHERE id_product = '18122' AND id_supplier = '12' 16/03/2023 10:06:10 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18122' , '12' , '1' ) 16/03/2023 10:06:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82319' , '5975' , 'LUCERNA COLORATA - 1491' , '4' , '4' , '1' , '9' , '7.3770491803279' , '22' , '5' , '41.7240' ) 16/03/2023 10:06:10 am >> DELETE FROM ps_product_supplier WHERE id_product = '5975' AND id_supplier = '12' 16/03/2023 10:06:10 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5975' , '12' , '1' ) 16/03/2023 10:06:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82319' , '7553' , 'PARAFIAMMA PIREX PER CARTUCCIA 3.2 - 474/25' , '6' , '6' , '1' , '4.5' , '3.6885245901639' , '22' , '5' , '31.2930' ) 16/03/2023 10:06:10 am >> DELETE FROM ps_product_supplier WHERE id_product = '7553' AND id_supplier = '12' 16/03/2023 10:06:10 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7553' , '12' , '1' ) 16/03/2023 10:06:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82319' , '6011' , 'LUMINELLO VETRO - 474' , '4' , '4' , '1' , '4.5' , '3.6885245901639' , '22' , '5' , '20.8620' ) 16/03/2023 10:06:10 am >> DELETE FROM ps_product_supplier WHERE id_product = '6011' AND id_supplier = '12' 16/03/2023 10:06:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6011' , '12' , '1' ) 16/03/2023 10:06:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82319' , '18799' , 'PARAFIAMMA PIREX PER CARTUCCIA 4 CM - 474/30' , '2' , '2' , '1' , '4.5' , '3.6885245901639' , '22' , '5' , '10.4310' ) 16/03/2023 10:06:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '18799' AND id_supplier = '12' 16/03/2023 10:06:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18799' , '12' , '1' ) 16/03/2023 10:06:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82319' , '780' , 'ASPERGES MAXI CON CUSTODIA - 700' , '3' , '3' , '1' , '20' , '16.393442622951' , '22' , '5' , '69.5400' ) 16/03/2023 10:06:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '780' AND id_supplier = '12' 16/03/2023 10:06:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '780' , '12' , '1' ) 16/03/2023 10:06:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82319' , '4200' , 'FINTA CANDELA 3,2X80 - 136' , '4' , '4' , '1' , '7' , '5.7377049180328' , '22' , '5' , '32.4520' ) 16/03/2023 10:06:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '4200' AND id_supplier = '12' 16/03/2023 10:06:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4200' , '12' , '1' ) 16/03/2023 10:06:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82319' , '15000' , 'TECA ALTA IHS - 825' , '4' , '4' , '1' , '13' , '10.655737704918' , '22' , '5' , '60.2680' ) 16/03/2023 10:06:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '15000' AND id_supplier = '12' 16/03/2023 10:06:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15000' , '12' , '1' ) 16/03/2023 10:06:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82319' , '20850' , 'CARTUCCIA ' , '2' , '2' , '1' , '16.5' , '13.524590163934' , '22' , '5' , '38.2470' ) 16/03/2023 10:06:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '20850' AND id_supplier = '12' 16/03/2023 10:06:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20850' , '12' , '1' ) 16/03/2023 10:06:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82319' , '12317' , 'SCATOLA PORTA OSTIE IN ALLUMINIO - 1879' , '5' , '5' , '1' , '4.5' , '3.6885245901639' , '22' , '5' , '26.0775' ) 16/03/2023 10:06:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '12317' AND id_supplier = '12' 16/03/2023 10:06:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12317' , '12' , '1' ) 16/03/2023 10:06:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82319' , '1751' , 'CARTUCCIA TRASPARENTE DIAM. 4 - 455' , '4' , '4' , '1' , '5.5' , '4.5081967213115' , '22' , '5' , '25.4980' ) 16/03/2023 10:06:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '1751' AND id_supplier = '12' 16/03/2023 10:06:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1751' , '12' , '1' ) 16/03/2023 10:06:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82319' , '11805' , 'TECA IHS - 823' , '25' , '25' , '1' , '10' , '8.1967213114754' , '22' , '5+5' , '275.2625' ) 16/03/2023 10:06:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '11805' AND id_supplier = '12' 16/03/2023 10:06:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11805' , '12' , '1' ) 16/03/2023 10:06:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82319' , '20851' , 'FINTA CANDELA COMPLETA CARTUCCIA 8X25 - 1187' , '2' , '2' , '1' , '17' , '13.934426229508' , '22' , '5' , '39.4060' ) 16/03/2023 10:06:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '20851' AND id_supplier = '12' 16/03/2023 10:06:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20851' , '12' , '1' ) 16/03/2023 11:08:04 am >> SELECT document_num FROM ps_document WHERE document_num = '859' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-16') 16/03/2023 11:08:04 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '859' , '2023-03-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '310.00' , '260.20' , NOW() , NOW() ) 16/03/2023 11:08:04 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82320' 16/03/2023 11:08:04 am >> DELETE FROM ps_document_detail WHERE id_document = '82320' 16/03/2023 11:08: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 ( '82320' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '148' , '121.31147540984' , '22' , '0' , '148.00' ) 16/03/2023 11:08: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 ( '82320' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '10' , '-10' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '35.00' ) 16/03/2023 11:08: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 ( '82320' , '20429' , 'OSTIA SENZA TOSTATURA MORREALE - OS25' , '4' , '-4' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '8.00' ) 16/03/2023 11:08: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 ( '82320' , '14114' , 'CINGOLO ORO - CING08ORO' , '1' , '-1' , '1' , '34.00' , '27.868852459016' , '22' , '0' , '34.00' ) 16/03/2023 11:08: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 ( '82320' , '19710' , 'CINGOLO ORO - 55/8898' , '1' , '-1' , '1' , '29.00' , '23.770491803279' , '22' , '0' , '29.00' ) 16/03/2023 11:08: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 ( '82320' , '15649' , 'CLERGY CELESTE - 100% - 44 - 160/10' , '1' , '-1' , '1' , '56' , '45.901639344262' , '22' , '0' , '56.00' ) 16/03/2023 11:11:44 am >> SELECT document_num FROM ps_document WHERE document_num = '860' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-16') 16/03/2023 11:11:44 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' , '860' , '2023-03-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '65.00' , '59.79' , NOW() , NOW() ) 16/03/2023 11:11:44 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 = '82321' 16/03/2023 11:11:44 am >> DELETE FROM ps_document_detail WHERE id_document = '82321' 16/03/2023 11:11:44 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 ( '82321' , '20795' , 'SULLA TUA PAROLA MAG/GIU 2023 - 516' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 16/03/2023 11:11:44 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 ( '82321' , '20527' , 'AMEN - APR 23' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 16/03/2023 11:11:44 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 ( '82321' , '20843' , 'MESSA MEDITAZIONE - MAG/GIU 2023' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '5' , '7.60' ) 16/03/2023 11:11:44 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 ( '82321' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '8.34' , '8.34' , '0' , '0' , '8.34' ) 16/03/2023 11:11:44 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 ( '82321' , '17034' , 'SACRAMENTO DEL PERDONO' , '3' , '-3' , '4' , '2.00' , '2' , '0' , '5' , '5.70' ) 16/03/2023 11:11:44 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 ( '82321' , '20652' , 'VIA CRUCIS CON GLI SCRITTI DI C. LUBICH - PADRE G. VALSECCHI' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 16/03/2023 11:11:44 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 ( '82321' , '20725' , 'NELLO STUPORE DELLA CROCE - U. DE VANNA' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 16/03/2023 11:11:44 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 ( '82321' , '20773' , 'VIA CRUCIS CON BENEDETTO XVI' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 16/03/2023 11:11:44 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 ( '82321' , '13504' , 'SACRAMENTO DELLA RICONCILIAZIONE RAGAZZI' , '3' , '-3' , '1' , '0.30' , '0.24590163934426' , '22' , '0' , '0.90' ) 16/03/2023 11:11:44 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 ( '82321' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '3.50' ) 16/03/2023 11:11:44 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 ( '82321' , '2764' , 'CORONA EMATITE TONDA ' , '1' , '-1' , '1' , '4.50' , '3.6885245901639' , '22' , '0' , '4.50' ) 16/03/2023 11:11:44 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 ( '82321' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '1' , '-1' , '1' , '20' , '16.393442622951' , '22' , '0' , '20.00' ) 16/03/2023 11:44:57 am >> SELECT document_num FROM ps_document WHERE document_num = '861' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-16') 16/03/2023 11:44:57 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' , '861' , '2023-03-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.50' , '3.50' , NOW() , NOW() ) 16/03/2023 11:44:57 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82322' 16/03/2023 11:44:57 am >> DELETE FROM ps_document_detail WHERE id_document = '82322' 16/03/2023 11:44:58 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 ( '82322' , '20846' , 'REDEMPTOR HOMINIS' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '0' , '3.50' ) 16/03/2023 11:46:48 am >> SELECT document_num FROM ps_document WHERE document_num = '862' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-16') 16/03/2023 11:46:48 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' , '862' , '2023-03-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '793.80' , '793.80' , NOW() , NOW() ) 16/03/2023 11:46:48 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 = '82323' 16/03/2023 11:46:48 am >> DELETE FROM ps_document_detail WHERE id_document = '82323' 16/03/2023 11:46:48 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 ( '82323' , '20745' , 'SPERANZA CHE CERCHI - F. CRISTOFARO' , '63' , '-63' , '4' , '12.6' , '12.6' , '0' , '0' , '793.80' ) 16/03/2023 11:51:25 am >> SELECT document_num FROM ps_document WHERE document_num = '863' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-16') 16/03/2023 11:51:25 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '863' , '2023-03-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.30' , '10.87' , NOW() , NOW() ) 16/03/2023 11:51:25 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82324' 16/03/2023 11:51:25 am >> DELETE FROM ps_document_detail WHERE id_document = '82324' 16/03/2023 11:51:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82324' , '20431' , 'PARTICOLA TAGLIO CHIUSO 35MM - W500' , '1' , '-1' , '3' , '3.30' , '3.1730769230769' , '4' , '0' , '3.30' ) 16/03/2023 11:51:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82324' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '2' , '-2' , '3' , '4.00' , '3.8461538461538' , '4' , '0' , '8.00' ) 16/03/2023 12:20:53 pm >> DELETE FROM ps_document WHERE id_document = '82094' 16/03/2023 12:20:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '82094' 16/03/2023 12:38:05 pm >> SELECT document_num FROM ps_document WHERE document_num = '864' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-16') 16/03/2023 12:38:05 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' , '864' , '2023-03-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '191.40' , '156.89' , NOW() , NOW() ) 16/03/2023 12:38:05 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82325' 16/03/2023 12:38:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '82325' 16/03/2023 12:38:05 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 ( '82325' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '135' , '110.65573770492' , '22' , '0' , '135.00' ) 16/03/2023 12:38:05 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 ( '82325' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 16/03/2023 12:38:36 pm >> SELECT document_num FROM ps_document WHERE document_num = '865' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-16') 16/03/2023 12:38:36 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '865' , '2023-03-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '60.00' , '49.18' , NOW() , NOW() ) 16/03/2023 12:38:36 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82326' 16/03/2023 12:38:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '82326' 16/03/2023 12:38:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82326' , '17783' , 'MEDAGLIA OVALE S. GIUSEPPE CM 2,2 ' , '100' , '-100' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '25.00' ) 16/03/2023 12:38:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82326' , '17748' , 'SEGNALIBRO - PR 349' , '100' , '-100' , '1' , '0.35' , '0.28688524590164' , '22' , '0' , '35.00' ) 16/03/2023 02:33:43 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' , '111' , '2023-03-10' , '' , '0' , '53' , '2648' , 'VIA TERRE RISAIE 13 84131 SALERNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '5414.60' , '4990.00' , NOW() , NOW() ) 16/03/2023 02:33:43 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82327' 16/03/2023 02:33:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '82327' 16/03/2023 02:33:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82327' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '10000' , '10000' , '3' , '0.215' , '0.20673076923077' , '4' , '0' , '2236.0000' ) 16/03/2023 02:33:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16665' AND id_supplier = '53' 16/03/2023 02:33:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16665' , '53' , '1' ) 16/03/2023 02:33:44 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 ( '82327' , '20720' , 'PADRE NOSTRO - L. CALABRETTA' , '1000' , '1000' , '3' , '0.77' , '0.74038461538462' , '4' , '0' , '800.8000' ) 16/03/2023 02:33:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20720' AND id_supplier = '53' 16/03/2023 02:33:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20720' , '53' , '1' ) 16/03/2023 02:33:44 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 ( '82327' , '20721' , 'AVE MARIA - L. CALABRETTA' , '1000' , '1000' , '3' , '0.82' , '0.78846153846154' , '4' , '0' , '852.8000' ) 16/03/2023 02:33:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20721' AND id_supplier = '53' 16/03/2023 02:33:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20721' , '53' , '1' ) 16/03/2023 02:33:44 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 ( '82327' , '20652' , 'GRAFICA' , '1' , '1' , '1' , '1250' , '1024.5901639344' , '22' , '0' , '1525.0000' ) 16/03/2023 02:33:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20652' AND id_supplier = '53' 16/03/2023 02:33:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20652' , '53' , '1' ) 16/03/2023 03:11:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '866' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-16') 16/03/2023 03:12:00 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' , '866' , '2023-03-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '23.75' , '23.75' , NOW() , NOW() ) 16/03/2023 03:12:00 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 = '82328' 16/03/2023 03:12:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '82328' 16/03/2023 03:12:00 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 ( '82328' , '20827' , 'DANTE E GRANDI QUESTIONI ESCATOLOGICHE - L. AZZETTA' , '1' , '-1' , '4' , '25.00' , '25' , '0' , '5' , '23.75' ) 16/03/2023 03:16:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '867' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-16') 16/03/2023 03:16:42 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' , '867' , '2023-03-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '36.80' , '31.03' , NOW() , NOW() ) 16/03/2023 03:16:42 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 = '82329' 16/03/2023 03:16:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '82329' 16/03/2023 03:16:42 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 ( '82329' , '7202' , 'ARTICOLI RELIGIOSI' , '40' , '-40' , '1' , '0.8' , '0.65573770491803' , '22' , '0' , '32.00' ) 16/03/2023 03:16:42 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 ( '82329' , '18175' , 'VIA DI SAN GIUSEPPE - G. POLIDORO' , '1' , '-1' , '4' , '4.80' , '4.8' , '0' , '0' , '4.80' ) 16/03/2023 03:19:12 pm >> SELECT document_num FROM ps_document WHERE document_num = '854' AND id_document != '82311' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-15') 16/03/2023 03:19:12 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '854', document_date = '2023-03-15', 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 = '17.60', price_tax_excluded = '14.43', date_upd = NOW() WHERE id_document = '82311' 16/03/2023 03:19: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 = '82311' 16/03/2023 03:19:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '82311' 16/03/2023 03:19:12 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 ( '82311' , '20028' , 'CANDELA ALTARE 26X350' , '1' , '-1' , '1' , '2.4000' , '1.9672131147541' , '22' , '0' , '2.40' ) 16/03/2023 03:19:12 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 ( '82311' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '1.7' , '1.3934426229508' , '22' , '0' , '1.70' ) 16/03/2023 03:19:12 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 ( '82311' , '19431' , 'PALLONCINO MAGNETE 12X15 - PM' , '1' , '-1' , '1' , '12.2000' , '10' , '22' , '0' , '12.20' ) 16/03/2023 03:19:12 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 ( '82311' , '20220' , 'MEDAGLIA SAN BENEDETTO CM 2 - 400/n0217' , '1' , '-1' , '1' , '1.30' , '1.0655737704918' , '22' , '0' , '1.30' ) 16/03/2023 03:46:29 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 16/03/2023 03:46:29 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20852' , '1' , '' , 'nuovo-prodotto' ) 16/03/2023 03:46:29 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '20852' , '1' , '1' , '2' , NOW() , NOW() ) 16/03/2023 03:46:29 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '20852' , '0' , '1' , '0' , '0' ) 16/03/2023 03:47:34 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002124' AND id_product != '20852' AND ean13 != '' 16/03/2023 03:47:34 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002124', date_upd = NOW() WHERE id_product = '20852' 16/03/2023 03:47:34 pm >> UPDATE ps_product_lang SET name = 'CALICE OTTONE IN FUSIONE ARGENTATA - 099A', description = '' WHERE id_product = '20852' 16/03/2023 03:47:34 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '1225.4098360655737' WHERE id_product = '20852' 16/03/2023 03:47:34 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '1225.4098360655737', id_tax_rules_group = '1', id_category_default = '480', 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 = '20852' 16/03/2023 03:47:34 pm >> DELETE FROM ps_specific_price WHERE id_product = '20852' 16/03/2023 03:47:35 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '20852' 16/03/2023 03:47:35 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20853' , '1' , '' , 'nuovo-prodotto' ) 16/03/2023 03:47:35 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '20853' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20852' 16/03/2023 03:47:35 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20853' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20852' 16/03/2023 03:52:37 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002125' AND id_product != '20853' AND ean13 != '' 16/03/2023 03:52:37 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002125', date_upd = NOW() WHERE id_product = '20853' 16/03/2023 03:52:37 pm >> UPDATE ps_product_lang SET name = 'CALICE IN FUSINONE ARG - 193A', description = '' WHERE id_product = '20853' 16/03/2023 03:52:37 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '1196.72131147541' WHERE id_product = '20853' 16/03/2023 03:52:37 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '1196.72131147541', id_tax_rules_group = '1', id_category_default = '480', 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 = '20853' 16/03/2023 03:52:37 pm >> DELETE FROM ps_specific_price WHERE id_product = '20853' 16/03/2023 03:52:42 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '20853' 16/03/2023 03:52:42 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20854' , '1' , '' , 'nuovo-prodotto' ) 16/03/2023 03:52:42 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '20854' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20853' 16/03/2023 03:52:42 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20854' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20853' 16/03/2023 03:53:50 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002126' AND id_product != '20854' AND ean13 != '' 16/03/2023 03:53:50 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002126', date_upd = NOW() WHERE id_product = '20854' 16/03/2023 03:53:50 pm >> UPDATE ps_product_lang SET name = 'CALICE ARGENTATO - 055', description = '' WHERE id_product = '20854' 16/03/2023 03:53:50 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '1270.4918032786886' WHERE id_product = '20854' 16/03/2023 03:53:50 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '1270.4918032786886', id_tax_rules_group = '1', id_category_default = '480', 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 = '20854' 16/03/2023 03:53:50 pm >> DELETE FROM ps_specific_price WHERE id_product = '20854' 16/03/2023 03:53:51 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '20854' 16/03/2023 03:53:51 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20855' , '1' , '' , 'nuovo-prodotto' ) 16/03/2023 03:53: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 '20855' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20854' 16/03/2023 03:53:52 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20855' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20854' 16/03/2023 03:54: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 ( '31' , '26' , '2023-03-16' , '' , '0' , '149' , '4671100' , 'STRADA DEL LAVORO 211 47894 CHIESANUOVA R.S.M.' , '' , '' , '25' , '1' , '0' , '0' , '0' , '' , '9' , '0' , '2335.75' , '1914.55' , NOW() , NOW() ) 16/03/2023 03:54: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 = '82330' 16/03/2023 03:54:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '82330' 16/03/2023 03:54: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 ( '82330' , '19842' , 'CALICE OTTONE SABBIATO - 083' , '1' , '1' , '1' , '148' , '121.31147540984' , '22' , '5' , '171.5320' ) 16/03/2023 03:54:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19842' AND id_supplier = '149' 16/03/2023 03:54:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19842' , '149' , '1' ) 16/03/2023 03:54: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 ( '82330' , '20852' , 'CALICE OTTONE IN FUSIONE ARGENTATA - 099A' , '1' , '1' , '1' , '611' , '500.81967213115' , '22' , '5' , '708.1490' ) 16/03/2023 03:54:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20852' AND id_supplier = '149' 16/03/2023 03:54:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20852' , '149' , '1' ) 16/03/2023 03:54: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 ( '82330' , '20853' , 'CALICE IN FUSINONE ARG - 193A' , '1' , '1' , '1' , '598' , '490.16393442623' , '22' , '5' , '693.0820' ) 16/03/2023 03:54:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20853' AND id_supplier = '149' 16/03/2023 03:54:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20853' , '149' , '1' ) 16/03/2023 03:54: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 ( '82330' , '20854' , 'CALICE ARGENTATO - 055' , '1' , '1' , '1' , '632' , '518.03278688525' , '22' , '5' , '732.4880' ) 16/03/2023 03:54:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20854' AND id_supplier = '149' 16/03/2023 03:54:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20854' , '149' , '1' ) 16/03/2023 04:53:01 pm >> SELECT document_num FROM ps_document WHERE document_num = '868' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-16') 16/03/2023 04:53:01 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '868' , '2023-03-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.00' , '10.00' , NOW() , NOW() ) 16/03/2023 04:53:01 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82331' 16/03/2023 04:53:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '82331' 16/03/2023 04:53:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82331' , '11376' , 'VIENI SPIRITO SANTO' , '50' , '-50' , '4' , '0.20' , '0.2' , '0' , '0' , '10.00' ) 16/03/2023 04:59:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '869' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-16') 16/03/2023 04:59: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' , '869' , '2023-03-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '23.00' , '18.85' , NOW() , NOW() ) 16/03/2023 04:59: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 = '82332' 16/03/2023 04:59:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '82332' 16/03/2023 04:59: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 ( '82332' , '19818' , 'INCENSO NATURALE 3A KG 1' , '1' , '-1' , '1' , '23.00' , '18.852459016393' , '22' , '0' , '23.00' ) 16/03/2023 05:02:50 pm >> SELECT document_num FROM ps_document WHERE document_num = '870' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-16') 16/03/2023 05:02: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' , '870' , '2023-03-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.00' , '16.35' , NOW() , NOW() ) 16/03/2023 05:02: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 = '82333' 16/03/2023 05:02:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '82333' 16/03/2023 05:02: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 ( '82333' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 16/03/2023 05:02: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 ( '82333' , '14064' , 'STELLARIO PLEX CM 16' , '1' , '-1' , '1' , '13.50' , '11.065573770492' , '22' , '0' , '13.50' ) 16/03/2023 05:02: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 ( '82333' , '16689' , 'OSTIA PAN DI CENA mm80' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 16/03/2023 05:04:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '223' AND id_document != '80462' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-21') 16/03/2023 05:04:14 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '223', document_date = '2023-01-21', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '117.00', price_tax_excluded = '117.00', date_upd = NOW() WHERE id_document = '80462' 16/03/2023 05:04: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 = '80462' 16/03/2023 05:04:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '80462' 16/03/2023 05:04: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 ( '80462' , '15746' , 'ADORIAMO IL SS SACRAMENTO - VOL 1 - 8958' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '0' , '3.00' ) 16/03/2023 05:04: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 ( '80462' , '12590' , 'VANGELO DI GIOVANNI - S. FAUSTI' , '1' , '-1' , '4' , '44.0000' , '44' , '0' , '5' , '41.80' ) 16/03/2023 05:04: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 ( '80462' , '12921' , 'BARTOLO LONGO DAL SALENTO A POMPEI - A. ILLIBATO' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '5' , '11.40' ) 16/03/2023 05:04: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 ( '80462' , '15308' , 'CHI E PAOLO - G. LAJOLO' , '1' , '-1' , '4' , '25.0000' , '25' , '0' , '5' , '23.75' ) 16/03/2023 05:04: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 ( '80462' , '17648' , 'ANDIAMO A SCUOLA DI AMORE - A. COMASTRI' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '5' , '11.40' ) 16/03/2023 05:04:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80462' , '9615' , 'SANTA TERESA DI LISIEUX - TERESA DI LISIEUX' , '1' , '-1' , '4' , '11.0000' , '11' , '0' , '5' , '10.45' ) 16/03/2023 05:04:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80462' , '15898' , 'DAMMI LA SAPIENZA - C. DUMONT' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '5' , '15.20' ) 16/03/2023 05:25:51 pm >> SELECT document_num FROM ps_document WHERE document_num = '867' AND id_document != '82329' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-16') 16/03/2023 05:25:51 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '867', document_date = '2023-03-16', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '36.80', price_tax_excluded = '31.03', date_upd = NOW() WHERE id_document = '82329' 16/03/2023 05:25:51 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82329' 16/03/2023 05:25:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '82329' 16/03/2023 05:25:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82329' , '18175' , 'VIA DI SAN GIUSEPPE - G. POLIDORO' , '1' , '-1' , '4' , '4.8000' , '4.8' , '0' , '0' , '4.80' ) 16/03/2023 05:25:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82329' , '6339' , 'MEDAGLIA OVALE DORATA/SMALTINO' , '40' , '-40' , '1' , '0.80' , '0.65573770491803' , '22' , '0' , '32.00' ) 16/03/2023 05:29:16 pm >> SELECT document_num FROM ps_document WHERE document_num = '871' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-16') 16/03/2023 05:29:16 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '871' , '2023-03-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.50' , '4.50' , NOW() , NOW() ) 16/03/2023 05:29:16 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82334' 16/03/2023 05:29:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '82334' 16/03/2023 05:29:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82334' , '14642' , 'FIDES ET RATIO - GIOVANNI PAOLO II' , '1' , '-1' , '4' , '4.5' , '4.5' , '0' , '0' , '4.50' ) 16/03/2023 05:29:40 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831516952' AND id_product != '14642' AND ean13 != '' 16/03/2023 05:29:40 pm >> UPDATE ps_product SET id_supplier = '7', reference = '14', ean13 = '9788831516952', date_upd = NOW() WHERE id_product = '14642' 16/03/2023 05:29:40 pm >> UPDATE ps_product_lang SET name = 'FIDES ET RATIO - GIOVANNI PAOLO II', description = '' WHERE id_product = '14642' 16/03/2023 05:29:40 pm >> UPDATE ps_product SET wholesale_price = '2.68', on_sale = '0', price = '4.5' WHERE id_product = '14642' 16/03/2023 05:29:40 pm >> UPDATE ps_product_shop SET wholesale_price = '2.68', price = '4.5', id_tax_rules_group = '4', id_category_default = '27', id_argoment_default = '69', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '14642' 16/03/2023 05:29:40 pm >> DELETE FROM ps_specific_price WHERE id_product = '14642' 16/03/2023 05:39:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '872' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-16') 16/03/2023 05:39:59 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '872' , '2023-03-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '135.00' , '110.66' , NOW() , NOW() ) 16/03/2023 05:39:59 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82335' 16/03/2023 05:39:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '82335' 16/03/2023 05:39:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82335' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '135' , '110.65573770492' , '22' , '0' , '135.00' ) 16/03/2023 06:30:07 pm >> SELECT document_num FROM ps_document WHERE document_num = '873' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-16') 16/03/2023 06:30: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 ( '11' , '873' , '2023-03-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.70' , '7.13' , NOW() , NOW() ) 16/03/2023 06:30: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 = '82336' 16/03/2023 06:30:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '82336' 16/03/2023 06:30: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 ( '82336' , '9688' , 'SCAPOLARE 10X15 CUORE DI GESÙ - 2202 ' , '3' , '-3' , '1' , '2.90' , '2.3770491803279' , '22' , '0' , '8.70' ) 16/03/2023 07:26:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '874' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-16') 16/03/2023 07:26:45 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' , '874' , '2023-03-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '45.00' , '36.89' , NOW() , NOW() ) 16/03/2023 07:26:45 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 = '82337' 16/03/2023 07:26:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '82337' 16/03/2023 07:26:45 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 ( '82337' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '45' , '36.885245901639' , '22' , '0' , '45.00' )