30/05/2024 08:02:54 am >> SELECT document_num FROM ps_document WHERE document_num = '1271' AND id_document != '91417' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-24') 30/05/2024 08:02:55 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1271', document_date = '2024-04-24', 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 = '21.50', price_tax_excluded = '17.62', date_upd = NOW() WHERE id_document = '91417' 30/05/2024 08:02: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 = '91417' 30/05/2024 08:02:55 am >> DELETE FROM ps_document_detail WHERE id_document = '91417' 30/05/2024 08:02: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 ( '91417' , '14772' , 'BRACCIALE SAN BENEDETTO 4 COLORI - 0818/3' , '2' , '-2' , '1' , '2.3' , '1.8852459016393' , '22' , '0' , '4.60' ) 30/05/2024 08:02: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 ( '91417' , '9150' , 'ROSARIO LEGNO SCURO E CORDA - 99999' , '13' , '-13' , '1' , '1.30' , '1.0655737704918' , '22' , '0' , '16.90' ) 30/05/2024 08:04:01 am >> SELECT document_num FROM ps_document WHERE document_num = '1354' AND id_document != '91519' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-30') 30/05/2024 08:04:01 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1354', document_date = '2024-04-30', 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 = '159.50', price_tax_excluded = '136.02', date_upd = NOW() WHERE id_document = '91519' 30/05/2024 08:04: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 = '91519' 30/05/2024 08:04:01 am >> DELETE FROM ps_document_detail WHERE id_document = '91519' 30/05/2024 08:04: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 ( '91519' , '20245' , 'FORMELLA CROCIFISSO 25X30' , '2' , '-2' , '1' , '58.6' , '48.032786885246' , '22' , '0' , '117.20' ) 30/05/2024 08:04: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 ( '91519' , '10430' , 'TABOR' , '1' , '-1' , '4' , '17.9000' , '17.9' , '0' , '0' , '17.90' ) 30/05/2024 08:04: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 ( '91519' , '21780' , 'FRATELLINO' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '5' , '11.40' ) 30/05/2024 08:04: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 ( '91519' , '9150' , 'ROSARIO LEGNO SCURO E CORDA - 99999' , '10' , '-10' , '1' , '1.30' , '1.0655737704918' , '22' , '0' , '13.00' ) 30/05/2024 08:04:37 am >> SELECT document_num FROM ps_document WHERE document_num = '1406' AND id_document != '91580' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-03') 30/05/2024 08:04:37 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1406', document_date = '2024-05-03', 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 = '111.00', price_tax_excluded = '90.98', date_upd = NOW() WHERE id_document = '91580' 30/05/2024 08:04:37 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91580' 30/05/2024 08:04:37 am >> DELETE FROM ps_document_detail WHERE id_document = '91580' 30/05/2024 08:04:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91580' , '19395' , 'CLERGY MISTO COTONE ML - C01' , '1' , '-1' , '1' , '37.0000' , '30.327868852459' , '22' , '0' , '37.00' ) 30/05/2024 08:04:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91580' , '20983' , 'CLERGY MM LIMITED 80/20' , '1' , '-1' , '1' , '37.0000' , '30.327868852459' , '22' , '0' , '37.00' ) 30/05/2024 08:04:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91580' , '19102' , 'CARBONCINI MM 40' , '1' , '-1' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '13.00' ) 30/05/2024 08:04:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91580' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 30/05/2024 08:04:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91580' , '9150' , 'ROSARIO LEGNO SCURO E CORDA - 99999' , '14' , '-14' , '1' , '1' , '0.81967213114754' , '22' , '0' , '14.00' ) 30/05/2024 08:31:04 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 30/05/2024 08:31:04 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22668' , '1' , '' , 'nuovo-prodotto' ) 30/05/2024 08:31:04 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '22668' , '1' , '1' , '2' , NOW() , NOW() ) 30/05/2024 08:31:04 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '22668' , '0' , '1' , '0' , '0' ) 30/05/2024 08:31:54 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884049759' AND id_product != '22668' AND ean13 != '' 30/05/2024 08:31:54 am >> UPDATE ps_product SET id_supplier = '', reference = 'ESPOSITORE SHALOM', ean13 = '9788884049759', date_upd = NOW() WHERE id_product = '22668' 30/05/2024 08:31:54 am >> UPDATE ps_product_lang SET name = 'DIAVOLO RICONOSCERLO E VINCERLO - G. AMORT', description = '' WHERE id_product = '22668' 30/05/2024 08:31:54 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '12' WHERE id_product = '22668' 30/05/2024 08:31:55 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '12', id_tax_rules_group = '4', id_category_default = '106', 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 = '22668' 30/05/2024 08:31:55 am >> DELETE FROM ps_specific_price WHERE id_product = '22668' 30/05/2024 08:31: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 = '22668' 30/05/2024 08:31:56 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22669' , '1' , '' , 'nuovo-prodotto' ) 30/05/2024 08:31: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 '22669' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22668' 30/05/2024 08:31:56 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22669' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22668' 30/05/2024 08:33:06 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884049766' AND id_product != '22669' AND ean13 != '' 30/05/2024 08:33:06 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788884049766', date_upd = NOW() WHERE id_product = '22669' 30/05/2024 08:33:06 am >> UPDATE ps_product_lang SET name = 'ABBI CURA - 8669', description = '' WHERE id_product = '22669' 30/05/2024 08:33:06 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '1.5' WHERE id_product = '22669' 30/05/2024 08:33:06 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '1.5', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '28', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22669' 30/05/2024 08:33:06 am >> DELETE FROM ps_specific_price WHERE id_product = '22669' 30/05/2024 08:33:07 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 = '22669' 30/05/2024 08:33:07 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22670' , '1' , '' , 'nuovo-prodotto' ) 30/05/2024 08:33:07 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 '22670' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22669' 30/05/2024 08:33:07 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22670' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22669' 30/05/2024 08:47:15 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884042811' AND id_product != '22670' AND ean13 != '' 30/05/2024 08:47:15 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788884042811', date_upd = NOW() WHERE id_product = '22670' 30/05/2024 08:47:15 am >> UPDATE ps_product_lang SET name = 'GESU\' E\' AMORE - 8693', description = '' WHERE id_product = '22670' 30/05/2024 08:47:15 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '9' WHERE id_product = '22670' 30/05/2024 08:47:15 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '9', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '71', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22670' 30/05/2024 08:47:15 am >> DELETE FROM ps_specific_price WHERE id_product = '22670' 30/05/2024 08:47:17 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 = '22670' 30/05/2024 08:47:17 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22671' , '1' , '' , 'nuovo-prodotto' ) 30/05/2024 08:47:17 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 '22671' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22670' 30/05/2024 08:47:17 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22671' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22670' 30/05/2024 08:47:47 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' , '8300/00/2024' , '2024-05-28' , '00' , '0' , '38' , '2633' , 'VIA GALVANI, 1 60020 CAMERATA PICENA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '124.50' , '124.50' , NOW() , NOW() ) 30/05/2024 08:47:47 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 = '92068' 30/05/2024 08:47:47 am >> DELETE FROM ps_document_detail WHERE id_document = '92068' 30/05/2024 08:47: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 ( '92068' , '22414' , 'SULLA TUA PAROLA - LUG/AGO 2024' , '20' , '20' , '4' , '5.00' , '5' , '0' , '40' , '60.0000' ) 30/05/2024 08:47:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '22414' AND id_supplier = '38' 30/05/2024 08:47:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22414' , '38' , '1' ) 30/05/2024 08:47: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 ( '92068' , '19585' , 'PREGHIERE AL SACRO CUORE - 8071' , '1' , '1' , '4' , '17.00' , '17' , '0' , '40' , '10.2000' ) 30/05/2024 08:47:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '19585' AND id_supplier = '38' 30/05/2024 08:47:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19585' , '38' , '1' ) 30/05/2024 08:47: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 ( '92068' , '8245' , 'PREGATE IL SANTO ROSARIO OGNI GIORNO - 8234' , '1' , '1' , '4' , '2.00' , '2' , '0' , '40' , '1.2000' ) 30/05/2024 08:47:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '8245' AND id_supplier = '38' 30/05/2024 08:47:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8245' , '38' , '1' ) 30/05/2024 08:47: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 ( '92068' , '7098' , 'NOVENA A MARIA CHE SCIOGLIE I NODI - 8558' , '5' , '5' , '4' , '3.00' , '3' , '0' , '40' , '9.0000' ) 30/05/2024 08:47:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '7098' AND id_supplier = '38' 30/05/2024 08:47:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7098' , '38' , '1' ) 30/05/2024 08:47: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 ( '92068' , '22412' , 'SACRA BIBBIA - 8602' , '1' , '1' , '4' , '30.00' , '30' , '0' , '40' , '18.0000' ) 30/05/2024 08:47:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '22412' AND id_supplier = '38' 30/05/2024 08:47:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22412' , '38' , '1' ) 30/05/2024 08:47: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 ( '92068' , '22509' , 'SANTA GEMMA E IL DIAVOLO - 8607' , '1' , '1' , '4' , '9.00' , '9' , '0' , '40' , '5.4000' ) 30/05/2024 08:47:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '22509' AND id_supplier = '38' 30/05/2024 08:47:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22509' , '38' , '1' ) 30/05/2024 08:47: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 ( '92068' , '22668' , 'DIAVOLO RICONOSCERLO E VINCERLO - G. AMORT' , '1' , '1' , '4' , '12.00' , '12' , '0' , '40' , '7.2000' ) 30/05/2024 08:47:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '22668' AND id_supplier = '38' 30/05/2024 08:47:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22668' , '38' , '1' ) 30/05/2024 08:47: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 ( '92068' , '22669' , 'ABBI CURA - 8669' , '3' , '3' , '4' , '1.50' , '1.5' , '0' , '40' , '2.7000' ) 30/05/2024 08:47:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '22669' AND id_supplier = '38' 30/05/2024 08:47:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22669' , '38' , '1' ) 30/05/2024 08:47: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 ( '92068' , '22670' , 'GESU E AMORE - 8693' , '1' , '1' , '4' , '9.00' , '9' , '0' , '40' , '5.4000' ) 30/05/2024 08:47:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '22670' AND id_supplier = '38' 30/05/2024 08:47:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22670' , '38' , '1' ) 30/05/2024 08:47: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 ( '92068' , '14940' , 'SAN CHARBEL - 8850' , '1' , '1' , '4' , '7.00' , '7' , '0' , '40' , '4.2000' ) 30/05/2024 08:47:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '14940' AND id_supplier = '38' 30/05/2024 08:47:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14940' , '38' , '1' ) 30/05/2024 08:47: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 ( '92068' , '17628' , 'PREGHIERE A SAN CHARBEL - 8946' , '1' , '1' , '4' , '2.00' , '2' , '0' , '40' , '1.2000' ) 30/05/2024 08:47:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '17628' AND id_supplier = '38' 30/05/2024 08:47:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17628' , '38' , '1' ) 30/05/2024 09:27:02 am >> SELECT document_num FROM ps_document WHERE document_num = '1806' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-30') 30/05/2024 09:27:02 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' , '1806' , '2024-05-30' , '' , '0' , '0' , '0' , 'VIA BUONSERVIZI, 25 84135 SALERNO' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '900.00' , '737.70' , NOW() , NOW() ) 30/05/2024 09:27: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 = '92069' 30/05/2024 09:27:02 am >> DELETE FROM ps_document_detail WHERE id_document = '92069' 30/05/2024 09:27: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 ( '92069' , '21638' , 'CASULA MARIANA P/LANA - 8418L' , '1' , '-1' , '1' , '800' , '655.73770491803' , '22' , '0' , '800.00' ) 30/05/2024 09:27: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 ( '92069' , '18239' , 'SERVIZIO MESSA - MARIANO M/L - 7051' , '1' , '-1' , '1' , '60.0000' , '49.1803' , '22' , '0' , '60.00' ) 30/05/2024 09:27: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 ( '92069' , '18237' , 'SERVIZIO MESSA VARI COLORI - 8047' , '1' , '-1' , '1' , '40' , '32.786885245902' , '22' , '0' , '40.00' ) 30/05/2024 09:28:39 am >> DELETE FROM ps_document WHERE id_document = '91998' 30/05/2024 09:28:39 am >> DELETE FROM ps_document_detail WHERE id_document = '91998' 30/05/2024 09:36:41 am >> SELECT document_num FROM ps_document WHERE document_num = '1807' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-30') 30/05/2024 09:36:42 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' , '1807' , '2024-05-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.13' , '5.13' , NOW() , NOW() ) 30/05/2024 09:36:42 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 = '92070' 30/05/2024 09:36:42 am >> DELETE FROM ps_document_detail WHERE id_document = '92070' 30/05/2024 09:36:42 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 ( '92070' , '22323' , 'INSIEME NELLA MESSA - GIU 2024' , '1' , '-1' , '4' , '1.80' , '1.8' , '0' , '5' , '1.71' ) 30/05/2024 09:36:42 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 ( '92070' , '22473' , 'INSIEME NELLA MESSA - LUG 2024' , '1' , '-1' , '4' , '1.80' , '1.8' , '0' , '5' , '1.71' ) 30/05/2024 09:36:42 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 ( '92070' , '22558' , 'INSIEME NELLA MESSA - AGO 2024' , '1' , '-1' , '4' , '1.80' , '1.8' , '0' , '5' , '1.71' ) 30/05/2024 09:51:47 am >> SELECT document_num FROM ps_document WHERE document_num = '1808' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-30') 30/05/2024 09:51:47 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' , '1808' , '2024-05-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.50' , '2.87' , NOW() , NOW() ) 30/05/2024 09:51:47 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 = '92071' 30/05/2024 09:51:47 am >> DELETE FROM ps_document_detail WHERE id_document = '92071' 30/05/2024 09:51:47 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 ( '92071' , '22498' , 'CROCE TRILOBATA - 603/8-0' , '1' , '-1' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '3.50' ) 30/05/2024 10:13:13 am >> SELECT document_num FROM ps_document WHERE document_num = '1809' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-30') 30/05/2024 10:13:13 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' , '1809' , '2024-05-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '42.75' , '42.75' , NOW() , NOW() ) 30/05/2024 10:13:13 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 = '92072' 30/05/2024 10:13:13 am >> DELETE FROM ps_document_detail WHERE id_document = '92072' 30/05/2024 10:13:13 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 ( '92072' , '1146' , 'BIBBIA DI GERUSALEMME X OCCASIONI ' , '1' , '-1' , '4' , '45.00' , '45' , '0' , '5' , '42.75' ) 30/05/2024 10:42:48 am >> SELECT ean13 FROM ps_product WHERE ean13 = '2530D' AND id_product != '22671' AND ean13 != '' 30/05/2024 10:42:48 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '2530D', date_upd = NOW() WHERE id_product = '22671' 30/05/2024 10:42:48 am >> UPDATE ps_product_lang SET name = 'ROSARIO IN METALLO', description = '' WHERE id_product = '22671' 30/05/2024 10:42:48 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '4' WHERE id_product = '22671' 30/05/2024 10:42:48 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '4', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '71', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22671' 30/05/2024 10:42:48 am >> DELETE FROM ps_specific_price WHERE id_product = '22671' 30/05/2024 10:42:54 am >> SELECT ean13 FROM ps_product WHERE ean13 = '2530D' AND id_product != '22671' AND ean13 != '' 30/05/2024 10:42:54 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '2530D', date_upd = NOW() WHERE id_product = '22671' 30/05/2024 10:42:54 am >> UPDATE ps_product_lang SET name = 'ROSARIO IN METALLO', description = '' WHERE id_product = '22671' 30/05/2024 10:42:54 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3.278688524590164' WHERE id_product = '22671' 30/05/2024 10:42:54 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3.278688524590164', id_tax_rules_group = '1', id_category_default = '106', id_argoment_default = '71', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22671' 30/05/2024 10:42:54 am >> DELETE FROM ps_specific_price WHERE id_product = '22671' 30/05/2024 10:44: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 ( '31' , 'A2421' , '2024-05-29' , '' , '0' , '28' , '2623' , 'VIA DEI MILLE 59 80121 NAPOLI' , '' , '' , '18' , '1' , '0' , '0' , '0' , '' , '9' , '0' , '461.68' , '378.43' , NOW() , NOW() ) 30/05/2024 10:44: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 = '92073' 30/05/2024 10:44:25 am >> DELETE FROM ps_document_detail WHERE id_document = '92073' 30/05/2024 10:44: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 ( '92073' , '13562' , 'CORONCINA IN STOFFA CON ROSE E FOGLIOLINE - 3311' , '20' , '20' , '1' , '2.1' , '1.7213114754098' , '22' , '0' , '51.2400' ) 30/05/2024 10:44:25 am >> DELETE FROM ps_product_supplier WHERE id_product = '13562' AND id_supplier = '28' 30/05/2024 10:44:25 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13562' , '28' , '1' ) 30/05/2024 10:44: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 ( '92073' , '8191' , 'PORTAPILLOLA OVALE GRANDE - 299/K52 - OGGETTI' , '60' , '60' , '1' , '2' , '1.6393442622951' , '22' , '0' , '146.4000' ) 30/05/2024 10:44:25 am >> DELETE FROM ps_product_supplier WHERE id_product = '8191' AND id_supplier = '28' 30/05/2024 10:44:25 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8191' , '28' , '1' ) 30/05/2024 10:44: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 ( '92073' , '22671' , 'ROSARIO IN METALLO' , '60' , '60' , '1' , '1.42' , '1.1639344262295' , '22' , '0' , '103.9440' ) 30/05/2024 10:44:25 am >> DELETE FROM ps_product_supplier WHERE id_product = '22671' AND id_supplier = '28' 30/05/2024 10:44:25 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22671' , '28' , '1' ) 30/05/2024 10:44: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 ( '92073' , '21096' , 'CROCE REMOVIBILE EFFETTO PIETRA - 3873' , '5' , '5' , '1' , '4.53' , '3.7131147540984' , '22' , '0' , '27.6330' ) 30/05/2024 10:44:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '21096' AND id_supplier = '28' 30/05/2024 10:44:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21096' , '28' , '1' ) 30/05/2024 10:44:26 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 ( '92073' , '15403' , 'CROCE IN RESINA CM 9 - 3806/G052' , '60' , '60' , '1' , '1.4' , '1.1475409836066' , '22' , '0' , '102.4800' ) 30/05/2024 10:44:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '15403' AND id_supplier = '28' 30/05/2024 10:44:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15403' , '28' , '1' ) 30/05/2024 10:44:26 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 ( '92073' , '22409' , 'PIASTRELLA COMUNIONE - 1302/K212' , '1' , '1' , '1' , '3.29' , '2.6967213114754' , '22' , '0' , '4.0138' ) 30/05/2024 10:44:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '22409' AND id_supplier = '28' 30/05/2024 10:44:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22409' , '28' , '1' ) 30/05/2024 10:44:26 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 ( '92073' , '22408' , 'PiASTRELLA CRESIMA - 1302/K178' , '1' , '1' , '1' , '3.29' , '2.6967213114754' , '22' , '0' , '4.0138' ) 30/05/2024 10:44:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '22408' AND id_supplier = '28' 30/05/2024 10:44:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22408' , '28' , '1' ) 30/05/2024 10:53:29 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 30/05/2024 10:53:29 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22672' , '1' , '' , 'nuovo-prodotto' ) 30/05/2024 10:53:29 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '22672' , '1' , '1' , '2' , NOW() , NOW() ) 30/05/2024 10:53:29 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '22672' , '0' , '1' , '0' , '0' ) 30/05/2024 10:54:34 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002283' AND id_product != '22672' AND ean13 != '' 30/05/2024 10:54:34 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002283', date_upd = NOW() WHERE id_product = '22672' 30/05/2024 10:54:34 am >> UPDATE ps_product_lang SET name = 'PORTATECA CAMOSCIO E TECA - A26', description = '' WHERE id_product = '22672' 30/05/2024 10:54:34 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '36.885245901639344' WHERE id_product = '22672' 30/05/2024 10:54:34 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '36.885245901639344', id_tax_rules_group = '1', id_category_default = '184', 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 = '22672' 30/05/2024 10:54:34 am >> DELETE FROM ps_specific_price WHERE id_product = '22672' 30/05/2024 10:54:40 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22672' 30/05/2024 10:54:40 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22673' , '1' , '' , 'nuovo-prodotto' ) 30/05/2024 10:54:41 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 '22673' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22672' 30/05/2024 10:54:41 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22673' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22672' 30/05/2024 10:55:25 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002284' AND id_product != '22673' AND ean13 != '' 30/05/2024 10:55:25 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002284', date_upd = NOW() WHERE id_product = '22673' 30/05/2024 10:55:25 am >> UPDATE ps_product_lang SET name = 'PORTA TECA PELLE E TECA', description = '' WHERE id_product = '22673' 30/05/2024 10:55:25 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '40.16393442622951' WHERE id_product = '22673' 30/05/2024 10:55:26 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '40.16393442622951', id_tax_rules_group = '1', id_category_default = '184', 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 = '22673' 30/05/2024 10:55:26 am >> DELETE FROM ps_specific_price WHERE id_product = '22673' 30/05/2024 10:55:44 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 30/05/2024 10:55:44 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22674' , '1' , '' , 'nuovo-prodotto' ) 30/05/2024 10:55:44 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '22674' , '1' , '1' , '2' , NOW() , NOW() ) 30/05/2024 10:55:44 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '22674' , '0' , '1' , '0' , '0' ) 30/05/2024 10:59:35 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002285' AND id_product != '22674' AND ean13 != '' 30/05/2024 10:59:35 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002285', date_upd = NOW() WHERE id_product = '22674' 30/05/2024 10:59:35 am >> UPDATE ps_product_lang SET name = 'BORSELLO CELEBRAZIONEPELLE - B2-01', description = '' WHERE id_product = '22674' 30/05/2024 10:59:35 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '299.1803278688525' WHERE id_product = '22674' 30/05/2024 10:59:35 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '299.1803278688525', id_tax_rules_group = '1', id_category_default = '184', 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 = '22674' 30/05/2024 10:59:35 am >> DELETE FROM ps_specific_price WHERE id_product = '22674' 30/05/2024 10:59:37 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 = '22674' 30/05/2024 10:59:37 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22675' , '1' , '' , 'nuovo-prodotto' ) 30/05/2024 10:59:37 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 '22675' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22674' 30/05/2024 10:59:37 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22675' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22674' 30/05/2024 11:00: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 ( '31' , '196/24' , '2024-05-29' , '24' , '0' , '71' , '2666' , 'VIA DEL SOLE, 6/A 40128 BOLOGNA' , '' , '' , '16' , '1' , '0' , '0' , '0' , '' , '10' , '0' , '471.80' , '386.72' , NOW() , NOW() ) 30/05/2024 11:00: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 = '92074' 30/05/2024 11:00:23 am >> DELETE FROM ps_document_detail WHERE id_document = '92074' 30/05/2024 11:00: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 ( '92074' , '14163' , 'PARACERA OTTONE LUCIDO - Q120' , '10' , '10' , '1' , '16.56' , '13.573770491803' , '22' , '0' , '202.0320' ) 30/05/2024 11:00:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '14163' AND id_supplier = '71' 30/05/2024 11:00:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14163' , '71' , '1' ) 30/05/2024 11:00: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 ( '92074' , '22672' , 'PORTATECA CAMOSCIO E TECA - A26' , '2' , '2' , '1' , '18.1' , '14.83606557377' , '22' , '0' , '44.1640' ) 30/05/2024 11:00:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '22672' AND id_supplier = '71' 30/05/2024 11:00:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22672' , '71' , '1' ) 30/05/2024 11:00: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 ( '92074' , '22673' , 'PORTA TECA PELLE E TECA' , '1' , '1' , '1' , '20.2' , '16.55737704918' , '22' , '0' , '24.6440' ) 30/05/2024 11:00:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '22673' AND id_supplier = '71' 30/05/2024 11:00:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22673' , '71' , '1' ) 30/05/2024 11:00: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 ( '92074' , '22674' , 'BORSELLO CELEBRAZIONEPELLE - B2-01' , '1' , '1' , '1' , '148.72' , '121.90163934426' , '22' , '0' , '181.4384' ) 30/05/2024 11:00:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '22674' AND id_supplier = '71' 30/05/2024 11:00:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22674' , '71' , '1' ) 30/05/2024 11:09:44 am >> SELECT document_num FROM ps_document WHERE document_num = '61/A' AND id_document != '91941' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-05-22') 30/05/2024 11:09:44 am >> UPDATE ps_document SET id_document_type = '24', document_num = '61/A', document_date = '2024-05-22', document_letter = 'A', id_customer = '2332', id_supplier = '', id_address = '4679092', address1 = 'P.ZZA S. ROCCO 84088 SIANO', 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 = '23.60', price_tax_excluded = '19.34', date_upd = NOW() WHERE id_document = '91941' 30/05/2024 11:09: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 = '91941' 30/05/2024 11:09:44 am >> DELETE FROM ps_document_detail WHERE id_document = '91941' 30/05/2024 11:09: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 ( '91941' , '1425' , 'BUSTA 100 FLAMBEAUX IN CARTA - FLAM' , '2' , '-2' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '20.00' ) 30/05/2024 11:09: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 ( '91941' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.6000' , '2.9508196721311' , '22' , '0' , '3.60' ) 30/05/2024 11:10:00 am >> SELECT document_num FROM ps_document WHERE document_num = '1810' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-30') 30/05/2024 11:10:00 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' , '1810' , '2024-05-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '70.00' , '57.38' , NOW() , NOW() ) 30/05/2024 11:10:00 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 = '92075' 30/05/2024 11:10:00 am >> DELETE FROM ps_document_detail WHERE id_document = '92075' 30/05/2024 11:10:00 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 ( '92075' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '1' , '-1' , '1' , '70.00' , '57.377049180328' , '22' , '0' , '70.00' ) 30/05/2024 11:26:21 am >> SELECT ean13 FROM ps_product WHERE ean13 = '001669' AND id_product != '14163' AND ean13 != '' 30/05/2024 11:26:22 am >> UPDATE ps_product SET id_supplier = '71', reference = '', ean13 = '001669', date_upd = NOW() WHERE id_product = '14163' 30/05/2024 11:26:22 am >> UPDATE ps_product_lang SET name = 'PARACERA OTTONE LUCIDO - Q120', description = '' WHERE id_product = '14163' 30/05/2024 11:26:22 am >> UPDATE ps_product SET wholesale_price = '15.27', on_sale = '0', price = '40.98360655737705' WHERE id_product = '14163' 30/05/2024 11:26:22 am >> UPDATE ps_product_shop SET wholesale_price = '15.27', price = '40.98360655737705', id_tax_rules_group = '1', id_category_default = '184', 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 = '14163' 30/05/2024 11:26:22 am >> DELETE FROM ps_specific_price WHERE id_product = '14163' 30/05/2024 11:39:22 am >> SELECT document_num FROM ps_document WHERE document_num = '1811' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-30') 30/05/2024 11:39:22 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1811' , '2024-05-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '65.00' , '56.25' , NOW() , NOW() ) 30/05/2024 11:39:22 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92076' 30/05/2024 11:39:22 am >> DELETE FROM ps_document_detail WHERE id_document = '92076' 30/05/2024 11:39:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92076' , '564' , 'GIGLER COMPLETO PER ART. 534/536/537 - 249' , '10' , '-10' , '1' , '4' , '3.2786885245902' , '22' , '0' , '40.00' ) 30/05/2024 11:39:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92076' , '20526' , 'MEDAGLIA SAN BENEDETTO 36MM - M275/A' , '2' , '-2' , '1' , '1' , '0.81967213114754' , '22' , '0' , '2.00' ) 30/05/2024 11:39:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92076' , '20220' , 'MEDAGLIA SAN BENEDETTO CM 2 - 400/n0217' , '5' , '-5' , '1' , '1.30' , '1.0655737704918' , '22' , '0' , '6.50' ) 30/05/2024 11:39:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92076' , '6313' , 'MEDAGLIA DI SAN BENEDETTO' , '1' , '-1' , '4' , '1.3' , '1.3' , '0' , '0' , '1.30' ) 30/05/2024 11:39:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92076' , '22481' , 'GIOIA DELLAMORE - C. ROCCHETTA' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '5' , '7.60' ) 30/05/2024 11:39:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92076' , '22173' , 'PERCHE SPOSARSI?' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '5' , '7.60' ) 30/05/2024 11:45:45 am >> SELECT document_num FROM ps_document WHERE document_num = '1812' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-30') 30/05/2024 11:45:45 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' , '1812' , '2024-05-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.00' , '2.46' , NOW() , NOW() ) 30/05/2024 11:45:45 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 = '92077' 30/05/2024 11:45:45 am >> DELETE FROM ps_document_detail WHERE id_document = '92077' 30/05/2024 11:45:45 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 ( '92077' , '9688' , 'SCAPOLARE 10X15 CUORE DI GESÙ - 2202 ' , '1' , '-1' , '1' , '3' , '2.4590163934426' , '22' , '0' , '3.00' ) 30/05/2024 11:55:01 am >> SELECT document_num FROM ps_document WHERE document_num = '61/A' AND id_document != '91941' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-05-22') 30/05/2024 11:55:01 am >> UPDATE ps_document SET id_document_type = '24', document_num = '61/A', document_date = '2024-05-22', document_letter = 'A', id_customer = '2332', id_supplier = '', id_address = '4679092', address1 = 'P.ZZA S. ROCCO 84088 SIANO', 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 = '84.50', price_tax_excluded = '78.56', date_upd = NOW() WHERE id_document = '91941' 30/05/2024 11:55: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 = '91941' 30/05/2024 11:55:02 am >> DELETE FROM ps_document_detail WHERE id_document = '91941' 30/05/2024 11:55: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 ( '91941' , '1425' , 'BUSTA 100 FLAMBEAUX IN CARTA - FLAM' , '2' , '-2' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '20.00' ) 30/05/2024 11:55: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 ( '91941' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.6000' , '2.9508196721311' , '22' , '0' , '3.60' ) 30/05/2024 11:55: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 ( '91941' , '17710' , 'OSTIA MAGNA 140 - OM 140' , '1' , '-1' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '4.50' ) 30/05/2024 11:55: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 ( '91941' , '22040' , 'LOTTANDO INSIEME A GIOBBE - P. RIBET' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '5' , '17.10' ) 30/05/2024 11:55: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 ( '91941' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '10' , '-10' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '35.00' ) 30/05/2024 11:55: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 ( '91941' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.30' , '4.1346153846154' , '4' , '0' , '4.30' ) 30/05/2024 11:58:21 am >> SELECT document_num FROM ps_document WHERE document_num = '61/A' AND id_document != '91941' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-05-22') 30/05/2024 11:58:21 am >> UPDATE ps_document SET id_document_type = '24', document_num = '61/A', document_date = '2024-05-22', document_letter = 'A', id_customer = '2332', id_supplier = '', id_address = '4679092', address1 = 'P.ZZA S. ROCCO 84088 SIANO', 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 = '114.50', price_tax_excluded = '103.15', date_upd = NOW() WHERE id_document = '91941' 30/05/2024 11:58:22 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91941' 30/05/2024 11:58:22 am >> DELETE FROM ps_document_detail WHERE id_document = '91941' 30/05/2024 11:58:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91941' , '1425' , 'BUSTA 100 FLAMBEAUX IN CARTA - FLAM' , '2' , '-2' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '20.00' ) 30/05/2024 11:58:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91941' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.6000' , '2.9508196721311' , '22' , '0' , '3.60' ) 30/05/2024 11:58:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91941' , '17710' , 'OSTIA MAGNA 140 - OM 140' , '1' , '-1' , '3' , '4.5000' , '4.3269230769231' , '4' , '0' , '4.50' ) 30/05/2024 11:58:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91941' , '22040' , 'LOTTANDO INSIEME A GIOBBE - P. RIBET' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '5' , '17.10' ) 30/05/2024 11:58:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91941' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '10' , '-10' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '35.00' ) 30/05/2024 11:58:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91941' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.3000' , '4.1346153846154' , '4' , '0' , '4.30' ) 30/05/2024 11:58:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91941' , '19107' , 'INCENSO GRANI 3A - BUSTA' , '1' , '-1' , '1' , '30.00' , '24.590163934426' , '22' , '0' , '30.00' ) 30/05/2024 12:11:51 pm >> SELECT document_num FROM ps_document WHERE document_num = '1813' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-30') 30/05/2024 12:11:51 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' , '1813' , '2024-05-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.50' , '2.50' , NOW() , NOW() ) 30/05/2024 12:11: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 = '92078' 30/05/2024 12:11:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '92078' 30/05/2024 12:11: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 ( '92078' , '19977' , 'MINISTRANTI IERI, OGGI, DOMANI' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '0' , '2.50' ) 30/05/2024 12:22:52 pm >> SELECT document_num FROM ps_document WHERE document_num = '17' AND id_document != '' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2024-05-30') 30/05/2024 12:22:52 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 ( '24' , '17' , '2024-05-30' , '' , '0' , '190' , '4679316' , '15TH KLM SPATE AVE 19002 PEANIA - ATENE - GRECIA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '77.56' , '77.56' , NOW() , NOW() ) 30/05/2024 12:22:52 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 = '92079' 30/05/2024 12:22:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '92079' 30/05/2024 12:22:52 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 ( '92079' , '22577' , 'CATENINA CON CIONDOLO - WKSS-0133G' , '3' , '-3' , '0' , '4.88' , '4.88' , '' , '10' , '13.18' ) 30/05/2024 12:22:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22577' AND id_supplier = '190' 30/05/2024 12:22:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22577' , '190' , '1' ) 30/05/2024 12:22:52 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 ( '92079' , '22578' , 'CATENINA CON CIONDOLO - WKSS-0138G' , '3' , '-3' , '0' , '3.9' , '3.9' , '' , '10' , '10.53' ) 30/05/2024 12:22:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22578' AND id_supplier = '190' 30/05/2024 12:22:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22578' , '190' , '1' ) 30/05/2024 12:22:52 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 ( '92079' , '22576' , 'CATENINA CON CIONDOLO' , '3' , '-3' , '0' , '4.88' , '4.88' , '' , '10' , '13.18' ) 30/05/2024 12:22:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22576' AND id_supplier = '190' 30/05/2024 12:22:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22576' , '190' , '1' ) 30/05/2024 12:22:52 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 ( '92079' , '22591' , 'BRACCIALE - BKSS-0097SI' , '1' , '-1' , '0' , '8' , '8' , '' , '10' , '7.20' ) 30/05/2024 12:22:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22591' AND id_supplier = '190' 30/05/2024 12:22:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22591' , '190' , '1' ) 30/05/2024 12:22:52 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 ( '92079' , '22592' , 'COPPIA CATENINA E CIONDOLO - BKSS-0073ROBK' , '1' , '-1' , '0' , '18.75' , '18.75' , '' , '10' , '16.88' ) 30/05/2024 12:22:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22592' AND id_supplier = '190' 30/05/2024 12:22:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22592' , '190' , '1' ) 30/05/2024 12:22:52 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 ( '92079' , '22582' , 'ROSARIO - BKSS-0074SI' , '1' , '-1' , '0' , '7.80' , '7.8' , '' , '10' , '7.02' ) 30/05/2024 12:22:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22582' AND id_supplier = '190' 30/05/2024 12:22:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22582' , '190' , '1' ) 30/05/2024 12:22:52 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 ( '92079' , '22590' , 'ROSARIO NERO - BKSS-0065B' , '1' , '-1' , '0' , '10.63' , '10.63' , '' , '10' , '9.57' ) 30/05/2024 12:22:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22590' AND id_supplier = '190' 30/05/2024 12:22:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22590' , '190' , '1' ) 30/05/2024 12:23:16 pm >> SELECT document_num FROM ps_document WHERE document_num = '1814' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-30') 30/05/2024 12:23: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' , '1814' , '2024-05-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.64' , '12.64' , NOW() , NOW() ) 30/05/2024 12:23: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 = '92080' 30/05/2024 12:23:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '92080' 30/05/2024 12:23: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 ( '92080' , '22148' , 'DICHIARAZIONE FIDUCIA SUPPLICANS' , '1' , '-1' , '4' , '2.80' , '2.8' , '0' , '5' , '2.66' ) 30/05/2024 12:23: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 ( '92080' , '9017' , 'RITO DELLA PENITENZA' , '1' , '-1' , '4' , '10.50' , '10.5' , '0' , '5' , '9.98' ) 30/05/2024 12:27:56 pm >> SELECT document_num FROM ps_document WHERE document_num = '17' AND id_document != '92079' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2024-05-30') 30/05/2024 12:27:56 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '17', document_date = '2024-05-30', document_letter = '', id_customer = '0', id_supplier = '', id_address = '4679316', address1 = '15TH KLM SPATE AVE 19002 PEANIA - ATENE - GRECIA', address2 = '', note = 'MERCE NON CONFORME ', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '10', price_tax_included = '107.59', price_tax_excluded = '107.59', date_upd = NOW() WHERE id_document = '92079' 30/05/2024 12:27: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 = '92079' 30/05/2024 12:27:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '92079' 30/05/2024 12:27: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 ( '92079' , '22577' , 'CATENINA CON CIONDOLO - WKSS-0133G' , '3' , '-3' , '0' , '4.8800' , '4.88' , '0' , '10' , '13.18' ) 30/05/2024 12:27: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 ( '92079' , '22578' , 'CATENINA CON CIONDOLO - WKSS-0138G' , '3' , '-3' , '0' , '3.9000' , '3.9' , '0' , '10' , '10.53' ) 30/05/2024 12:27: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 ( '92079' , '22576' , 'CATENINA CON CIONDOLO' , '3' , '-3' , '0' , '4.8800' , '4.88' , '0' , '10' , '13.18' ) 30/05/2024 12:27: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 ( '92079' , '22591' , 'BRACCIALE - BKSS-0097SI' , '1' , '-1' , '0' , '8.0000' , '8' , '0' , '10' , '7.20' ) 30/05/2024 12:27: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 ( '92079' , '22592' , 'COPPIA CATENINA E CIONDOLO - BKSS-0073ROBK' , '1' , '-1' , '0' , '18.7500' , '18.75' , '0' , '10' , '16.88' ) 30/05/2024 12:27: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 ( '92079' , '22582' , 'ROSARIO - BKSS-0074SI' , '1' , '-1' , '0' , '7.8000' , '7.8' , '0' , '10' , '7.02' ) 30/05/2024 12:27: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 ( '92079' , '22590' , 'ROSARIO NERO - BKSS-0065B' , '1' , '-1' , '0' , '10.6300' , '10.63' , '0' , '10' , '9.57' ) 30/05/2024 12:27: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 ( '92079' , '22589' , 'ROSARIO - BKSS-0238SI' , '1' , '-1' , '0' , '9.25' , '9.25' , '' , '10' , '8.32' ) 30/05/2024 12:27: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 ( '92079' , '22581' , 'ROSARIO UOMO - BKSS-0238BK' , '1' , '-1' , '0' , '9.25' , '9.25' , '' , '10' , '8.32' ) 30/05/2024 12:27: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 ( '92079' , '22579' , 'ROSARIO BICOLORE - BKSS-0236SIGO' , '1' , '-1' , '0' , '9.25' , '9.25' , '' , '10' , '8.32' ) 30/05/2024 12:27: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 ( '92079' , '22580' , 'ROSARIO - BKSS-0237SI' , '1' , '-1' , '0' , '5.63' , '5.63' , '' , '10' , '5.07' ) 30/05/2024 03:04:31 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788873577171' AND id_product != '22675' AND ean13 != '' 30/05/2024 03:04:31 pm >> UPDATE ps_product SET id_supplier = '', reference = '6/5', ean13 = '9788873577171', date_upd = NOW() WHERE id_product = '22675' 30/05/2024 03:04:31 pm >> UPDATE ps_product_lang SET name = 'OGNI GIORNO NELLA VERITA\' - O. DE BERTOLIS', description = '' WHERE id_product = '22675' 30/05/2024 03:04:31 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '17' WHERE id_product = '22675' 30/05/2024 03:04:31 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '17', id_tax_rules_group = '4', id_category_default = '178', id_argoment_default = '41', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22675' 30/05/2024 03:04:31 pm >> DELETE FROM ps_specific_price WHERE id_product = '22675' 30/05/2024 03:04:32 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22675' 30/05/2024 03:04:32 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22676' , '1' , '' , 'nuovo-prodotto' ) 30/05/2024 03:04:32 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22676' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22675' 30/05/2024 03:04:32 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22676' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22675' 30/05/2024 03:05:49 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788873577188' AND id_product != '22676' AND ean13 != '' 30/05/2024 03:05:49 pm >> UPDATE ps_product SET id_supplier = '', reference = '6/5', ean13 = '9788873577188', date_upd = NOW() WHERE id_product = '22676' 30/05/2024 03:05:49 pm >> UPDATE ps_product_lang SET name = 'MI STAI A CUORE - M. SEBASTIANI', description = '' WHERE id_product = '22676' 30/05/2024 03:05:49 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '18' WHERE id_product = '22676' 30/05/2024 03:05:49 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '18', id_tax_rules_group = '4', id_category_default = '178', id_argoment_default = '41', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22676' 30/05/2024 03:05:49 pm >> DELETE FROM ps_specific_price WHERE id_product = '22676' 30/05/2024 03:05:53 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 = '22676' 30/05/2024 03:05:53 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22677' , '1' , '' , 'nuovo-prodotto' ) 30/05/2024 03:05:53 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 '22677' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22676' 30/05/2024 03:05:53 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22677' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22676' 30/05/2024 03:06:47 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788873673262' AND id_product != '22677' AND ean13 != '' 30/05/2024 03:06:47 pm >> UPDATE ps_product SET id_supplier = '', reference = '7/2', ean13 = '9788873673262', date_upd = NOW() WHERE id_product = '22677' 30/05/2024 03:06:47 pm >> UPDATE ps_product_lang SET name = 'LITURGIA MANOMESSA ', description = '' WHERE id_product = '22677' 30/05/2024 03:06:47 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '30' WHERE id_product = '22677' 30/05/2024 03:06:47 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '30', id_tax_rules_group = '4', id_category_default = '380', 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 = '22677' 30/05/2024 03:06:47 pm >> DELETE FROM ps_specific_price WHERE id_product = '22677' 30/05/2024 03:06:48 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22677' 30/05/2024 03:06:48 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22678' , '1' , '' , 'nuovo-prodotto' ) 30/05/2024 03:06:48 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22678' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22677' 30/05/2024 03:06:48 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22678' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22677' 30/05/2024 03:07:53 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788830819283' AND id_product != '22678' AND ean13 != '' 30/05/2024 03:07:53 pm >> UPDATE ps_product SET id_supplier = '', reference = '13/6', ean13 = '9788830819283', date_upd = NOW() WHERE id_product = '22678' 30/05/2024 03:07:53 pm >> UPDATE ps_product_lang SET name = 'FORMA LITURGICA DELLE FEDE - D. GARGANESE', description = '' WHERE id_product = '22678' 30/05/2024 03:07:53 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '15.9' WHERE id_product = '22678' 30/05/2024 03:07:53 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '15.9', id_tax_rules_group = '4', id_category_default = '11', id_argoment_default = '65', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22678' 30/05/2024 03:07:53 pm >> DELETE FROM ps_specific_price WHERE id_product = '22678' 30/05/2024 03:07:56 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 = '22678' 30/05/2024 03:07:56 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22679' , '1' , '' , 'nuovo-prodotto' ) 30/05/2024 03:07:56 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 '22679' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22678' 30/05/2024 03:07:57 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22679' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22678' 30/05/2024 03:09:13 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788846508904' AND id_product != '22679' AND ean13 != '' 30/05/2024 03:09:13 pm >> UPDATE ps_product SET id_supplier = '', reference = '13/6', ean13 = '9788846508904', date_upd = NOW() WHERE id_product = '22679' 30/05/2024 03:09:13 pm >> UPDATE ps_product_lang SET name = 'ESISTE UN DIO? - R. SWINBURNE', description = '' WHERE id_product = '22679' 30/05/2024 03:09:13 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '20' WHERE id_product = '22679' 30/05/2024 03:09:13 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '20', id_tax_rules_group = '4', id_category_default = '129', id_argoment_default = '63', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22679' 30/05/2024 03:09:13 pm >> DELETE FROM ps_specific_price WHERE id_product = '22679' 30/05/2024 03:09:24 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 = '22679' 30/05/2024 03:09:24 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22680' , '1' , '' , 'nuovo-prodotto' ) 30/05/2024 03:09:24 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 '22680' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22679' 30/05/2024 03:09:24 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22680' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22679' 30/05/2024 03:10:40 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788898573622' AND id_product != '22680' AND ean13 != '' 30/05/2024 03:10:40 pm >> UPDATE ps_product SET id_supplier = '', reference = '7/5', ean13 = '9788898573622', date_upd = NOW() WHERE id_product = '22680' 30/05/2024 03:10:40 pm >> UPDATE ps_product_lang SET name = 'LUCE DI GRAZIA - M. DI LORENZO', description = '' WHERE id_product = '22680' 30/05/2024 03:10:40 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '10' WHERE id_product = '22680' 30/05/2024 03:10:40 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '10', id_tax_rules_group = '4', id_category_default = '419', id_argoment_default = '73', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22680' 30/05/2024 03:10:40 pm >> DELETE FROM ps_specific_price WHERE id_product = '22680' 30/05/2024 03:10:41 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 = '22680' 30/05/2024 03:10:41 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22681' , '1' , '' , 'nuovo-prodotto' ) 30/05/2024 03:10:41 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 '22681' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22680' 30/05/2024 03:10:41 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22681' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22680' 30/05/2024 03:11:47 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788873577195' AND id_product != '22681' AND ean13 != '' 30/05/2024 03:11:47 pm >> UPDATE ps_product SET id_supplier = '', reference = 'ESPOSITORE S. PAOLO', ean13 = '9788873577195', date_upd = NOW() WHERE id_product = '22681' 30/05/2024 03:11:47 pm >> UPDATE ps_product_lang SET name = 'OGNI GIORNO PREGHIAMO', description = '' WHERE id_product = '22681' 30/05/2024 03:11:47 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '2.5' WHERE id_product = '22681' 30/05/2024 03:11:47 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '2.5', id_tax_rules_group = '4', id_category_default = '178', id_argoment_default = '28', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22681' 30/05/2024 03:11:47 pm >> DELETE FROM ps_specific_price WHERE id_product = '22681' 30/05/2024 03:13:36 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788873577195' AND id_product != '22681' AND ean13 != '' 30/05/2024 03:13:36 pm >> UPDATE ps_product SET id_supplier = '', reference = 'ESPOSITORE S. PAOLO', ean13 = '9788873577195', date_upd = NOW() WHERE id_product = '22681' 30/05/2024 03:13:36 pm >> UPDATE ps_product_lang SET name = 'OGNI GIORNO PREGHIAMO', description = '' WHERE id_product = '22681' 30/05/2024 03:13:36 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '2.5' WHERE id_product = '22681' 30/05/2024 03:13:36 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '2.5', id_tax_rules_group = '4', id_category_default = '178', id_argoment_default = '28', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22681' 30/05/2024 03:13:36 pm >> DELETE FROM ps_specific_price WHERE id_product = '22681' 30/05/2024 03:14:54 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 30/05/2024 03:14:54 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22682' , '1' , '' , 'nuovo-prodotto' ) 30/05/2024 03:14:54 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '22682' , '1' , '1' , '2' , NOW() , NOW() ) 30/05/2024 03:14:54 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '22682' , '0' , '1' , '0' , '0' ) 30/05/2024 03:16:14 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788883331992' AND id_product != '22682' AND ean13 != '' 30/05/2024 03:16:14 pm >> UPDATE ps_product SET id_supplier = '', reference = '13/6', ean13 = '9788883331992', date_upd = NOW() WHERE id_product = '22682' 30/05/2024 03:16:14 pm >> UPDATE ps_product_lang SET name = 'GUIDATI DALLO SPIRITO - M. BELDA', description = '' WHERE id_product = '22682' 30/05/2024 03:16:14 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '25' WHERE id_product = '22682' 30/05/2024 03:16:14 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '25', id_tax_rules_group = '4', id_category_default = '272', id_argoment_default = '65', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22682' 30/05/2024 03:16:14 pm >> DELETE FROM ps_specific_price WHERE id_product = '22682' 30/05/2024 03:19:10 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '2024000003017' , '2024-05-29' , '' , '0' , '107' , '4669100' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '6' , '4' , '0' , '0' , '0' , '' , '12' , '0' , '143.71' , '143.71' , NOW() , NOW() ) 30/05/2024 03:19:10 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92081' 30/05/2024 03:19:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '92081' 30/05/2024 03:19:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92081' , '22675' , 'OGNI GIORNO NELLA VERITA - O. DE BERTOLIS' , '1' , '1' , '4' , '17.00' , '17' , '0' , '35' , '11.0500' ) 30/05/2024 03:19:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22675' AND id_supplier = '107' 30/05/2024 03:19:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22675' , '107' , '1' ) 30/05/2024 03:19:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92081' , '22682' , 'GUIDATI DALLO SPIRITO - M. BELDA' , '1' , '1' , '4' , '25.00' , '25' , '0' , '35' , '16.2500' ) 30/05/2024 03:19:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22682' AND id_supplier = '107' 30/05/2024 03:19:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22682' , '107' , '1' ) 30/05/2024 03:19:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92081' , '22676' , 'MI STAI A CUORE - M. SEBASTIANI' , '1' , '1' , '4' , '18.00' , '18' , '0' , '35' , '11.7000' ) 30/05/2024 03:19:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22676' AND id_supplier = '107' 30/05/2024 03:19:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22676' , '107' , '1' ) 30/05/2024 03:19:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92081' , '22681' , 'OGNI GIORNO PREGHIAMO' , '3' , '3' , '4' , '2.50' , '2.5' , '0' , '35' , '4.8750' ) 30/05/2024 03:19:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22681' AND id_supplier = '107' 30/05/2024 03:19:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22681' , '107' , '1' ) 30/05/2024 03:19:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92081' , '22680' , 'LUCE DI GRAZIA - M. DI LORENZO' , '2' , '2' , '4' , '10.00' , '10' , '0' , '35' , '13.0000' ) 30/05/2024 03:19:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22680' AND id_supplier = '107' 30/05/2024 03:19:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22680' , '107' , '1' ) 30/05/2024 03:19:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92081' , '4229' , 'FONTI FRANCESCANE - ED. MINOR' , '1' , '1' , '4' , '32.00' , '32' , '0' , '30' , '22.4000' ) 30/05/2024 03:19:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4229' AND id_supplier = '107' 30/05/2024 03:19:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4229' , '107' , '1' ) 30/05/2024 03:19:11 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 ( '92081' , '22679' , 'ESISTE UN DIO? - R. SWINBURNE' , '1' , '1' , '4' , '20.00' , '20' , '0' , '35' , '13.0000' ) 30/05/2024 03:19:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22679' AND id_supplier = '107' 30/05/2024 03:19:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22679' , '107' , '1' ) 30/05/2024 03:19:11 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 ( '92081' , '17385' , 'UNA STELLA DI NOME CARLO - B. BAFFETTI' , '1' , '1' , '4' , '12.00' , '12' , '0' , '35' , '7.8000' ) 30/05/2024 03:19:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17385' AND id_supplier = '107' 30/05/2024 03:19:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17385' , '107' , '1' ) 30/05/2024 03:19:11 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 ( '92081' , '21466' , 'UNA LUCE DI NOME CHIARA - B. BAFFETTI' , '1' , '1' , '4' , '12.00' , '12' , '0' , '35' , '7.8000' ) 30/05/2024 03:19:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21466' AND id_supplier = '107' 30/05/2024 03:19:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21466' , '107' , '1' ) 30/05/2024 03:19:11 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 ( '92081' , '22678' , 'FORMA LITURGICA DELLE FEDE - D. GARGANESE' , '1' , '1' , '4' , '15.90' , '15.9' , '0' , '35' , '10.3350' ) 30/05/2024 03:19:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22678' AND id_supplier = '107' 30/05/2024 03:19:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22678' , '107' , '1' ) 30/05/2024 03:19:11 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 ( '92081' , '22677' , 'LITURGIA MANOMESSA ' , '1' , '1' , '4' , '30.00' , '30' , '0' , '35' , '19.5000' ) 30/05/2024 03:19:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22677' AND id_supplier = '107' 30/05/2024 03:19:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22677' , '107' , '1' ) 30/05/2024 03:42:40 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892241558' AND id_product != '21117' AND ean13 != '' 30/05/2024 03:42:40 pm >> UPDATE ps_product SET id_supplier = '7', reference = '11/4', ean13 = '9788892241558', date_upd = NOW() WHERE id_product = '21117' 30/05/2024 03:42:40 pm >> UPDATE ps_product_lang SET name = 'VANGELO SECONDO GIOVANNI - P. DI LUCCIO', description = '' WHERE id_product = '21117' 30/05/2024 03:42:40 pm >> UPDATE ps_product SET wholesale_price = '18.76', on_sale = '0', price = '28.0000' WHERE id_product = '21117' 30/05/2024 03:42:40 pm >> UPDATE ps_product_shop SET wholesale_price = '18.76', price = '28.0000', id_tax_rules_group = '4', id_category_default = '30', 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 = '21117' 30/05/2024 03:42:40 pm >> DELETE FROM ps_specific_price WHERE id_product = '21117' 30/05/2024 03:43:04 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892241541' AND id_product != '20929' AND ean13 != '' 30/05/2024 03:43:04 pm >> UPDATE ps_product SET id_supplier = '7', reference = '11/4', ean13 = '9788892241541', date_upd = NOW() WHERE id_product = '20929' 30/05/2024 03:43:04 pm >> UPDATE ps_product_lang SET name = 'SULLE ORME DEI SAPIENTI - M. GILBERT', description = '' WHERE id_product = '20929' 30/05/2024 03:43:04 pm >> UPDATE ps_product SET wholesale_price = '18.76', on_sale = '0', price = '28.0000' WHERE id_product = '20929' 30/05/2024 03:43:04 pm >> UPDATE ps_product_shop SET wholesale_price = '18.76', price = '28.0000', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '65', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20929' 30/05/2024 03:43:04 pm >> DELETE FROM ps_specific_price WHERE id_product = '20929' 30/05/2024 03:44:12 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791281253148' AND id_product != '22236' AND ean13 != '' 30/05/2024 03:44:12 pm >> UPDATE ps_product SET id_supplier = '7', reference = '7/2', ean13 = '9791281253148', date_upd = NOW() WHERE id_product = '22236' 30/05/2024 03:44:12 pm >> UPDATE ps_product_lang SET name = 'CRISTO E\' RISORTO - PAPA FRANCESCO', description = '' WHERE id_product = '22236' 30/05/2024 03:44:12 pm >> UPDATE ps_product SET wholesale_price = '10.50', on_sale = '0', price = '15.0000' WHERE id_product = '22236' 30/05/2024 03:44:12 pm >> UPDATE ps_product_shop SET wholesale_price = '10.50', price = '15.0000', id_tax_rules_group = '4', id_category_default = '518', id_argoment_default = '64', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22236' 30/05/2024 03:44:12 pm >> DELETE FROM ps_specific_price WHERE id_product = '22236' 30/05/2024 03:45:51 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788832049657' AND id_product != '22062' AND ean13 != '' 30/05/2024 03:45:51 pm >> UPDATE ps_product SET id_supplier = '107', reference = '6/6', ean13 = '9788832049657', date_upd = NOW() WHERE id_product = '22062' 30/05/2024 03:45:51 pm >> UPDATE ps_product_lang SET name = 'SOSTENERE LE RAGIONI DELLA FEDE - S. GUSTAVSSON', description = '' WHERE id_product = '22062' 30/05/2024 03:45:51 pm >> UPDATE ps_product SET wholesale_price = '9.75', on_sale = '0', price = '15.0000' WHERE id_product = '22062' 30/05/2024 03:45:51 pm >> UPDATE ps_product_shop SET wholesale_price = '9.75', price = '15.0000', id_tax_rules_group = '4', id_category_default = '465', 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 = '22062' 30/05/2024 03:45:51 pm >> DELETE FROM ps_specific_price WHERE id_product = '22062' 30/05/2024 03:46:54 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791281253452' AND id_product != '20949' AND ean13 != '' 30/05/2024 03:46:54 pm >> UPDATE ps_product SET id_supplier = '7', reference = '7/2', ean13 = '9791281253452', date_upd = NOW() WHERE id_product = '20949' 30/05/2024 03:46:54 pm >> UPDATE ps_product_lang SET name = 'MARIA OMELIE E DISCORSI SCELTI - BENEDETTO XVI', description = '' WHERE id_product = '20949' 30/05/2024 03:46:54 pm >> UPDATE ps_product SET wholesale_price = '10.50', on_sale = '0', price = '15.0000' WHERE id_product = '20949' 30/05/2024 03:46:54 pm >> UPDATE ps_product_shop SET wholesale_price = '10.50', price = '15.0000', id_tax_rules_group = '4', id_category_default = '518', id_argoment_default = '78', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20949' 30/05/2024 03:46:54 pm >> DELETE FROM ps_specific_price WHERE id_product = '20949' 30/05/2024 03:51:49 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002262' AND id_product != '22368' AND ean13 != '' 30/05/2024 03:51:49 pm >> UPDATE ps_product SET id_supplier = '', reference = '5/4', ean13 = '002262', date_upd = NOW() WHERE id_product = '22368' 30/05/2024 03:51:49 pm >> UPDATE ps_product_lang SET name = 'UN FIORETTO PER MARIA', description = '' WHERE id_product = '22368' 30/05/2024 03:51:49 pm >> UPDATE ps_product SET wholesale_price = '1.00', on_sale = '0', price = '2.0000' WHERE id_product = '22368' 30/05/2024 03:51:49 pm >> UPDATE ps_product_shop SET wholesale_price = '1.00', price = '2.0000', id_tax_rules_group = '4', id_category_default = '517', id_argoment_default = '25', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22368' 30/05/2024 03:51:49 pm >> DELETE FROM ps_specific_price WHERE id_product = '22368' 30/05/2024 04:06:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '1815' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-30') 30/05/2024 04:06:19 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1815' , '2024-05-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '106.40' , '87.21' , NOW() , NOW() ) 30/05/2024 04:06:19 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92082' 30/05/2024 04:06:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '92082' 30/05/2024 04:06:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92082' , '9132' , 'DECINA LEGNO ACERO NATURALE - RG 021-10' , '80' , '-80' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '56.00' ) 30/05/2024 04:06:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92082' , '18223' , 'ROSARIO MISSIONARIO MM8 - R102' , '36' , '-36' , '1' , '1.40' , '1.1475409836066' , '22' , '0' , '50.40' ) 30/05/2024 04:19:23 pm >> SELECT document_num FROM ps_document WHERE document_num = '1816' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-30') 30/05/2024 04:19:23 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1816' , '2024-05-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.20' , '0.98' , NOW() , NOW() ) 30/05/2024 04:19:23 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92083' 30/05/2024 04:19:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '92083' 30/05/2024 04:19:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92083' , '20516' , 'CROCE COMUNIONE - 42/08' , '1' , '-1' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '1.20' ) 30/05/2024 04:50:41 pm >> SELECT document_num FROM ps_document WHERE document_num = '1705' AND id_document != '91940' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-22') 30/05/2024 04:50:41 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1705', document_date = '2024-05-22', 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 = '21.10', price_tax_excluded = '19.35', date_upd = NOW() WHERE id_document = '91940' 30/05/2024 04:50:41 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 = '91940' 30/05/2024 04:50:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '91940' 30/05/2024 04:50:41 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 ( '91940' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '4.00' ) 30/05/2024 04:50:41 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 ( '91940' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '3' , '-3' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '10.50' ) 30/05/2024 04:50:41 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 ( '91940' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.6000' , '2.9508196721311' , '22' , '0' , '3.60' ) 30/05/2024 04:50:41 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 ( '91940' , '15403' , 'CROCE IN RESINA CM 9 - 3806/G052' , '1' , '-1' , '1' , '3' , '2.4590163934426' , '22' , '0' , '3.00' ) 30/05/2024 05:06:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '1815' AND id_document != '92082' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-30') 30/05/2024 05:06:15 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1815', document_date = '2024-05-30', 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 = '3', id_causal = '0', price_tax_included = '106.40', price_tax_excluded = '87.21', date_upd = NOW() WHERE id_document = '92082' 30/05/2024 05:06:15 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92082' 30/05/2024 05:06:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '92082' 30/05/2024 05:06: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 ( '92082' , '9132' , 'DECINA LEGNO ACERO NATURALE - RG 021-10' , '80' , '-80' , '1' , '0.7000' , '0.57377049180328' , '22' , '0' , '56.00' ) 30/05/2024 05:06: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 ( '92082' , '18223' , 'ROSARIO MISSIONARIO MM8 - R102' , '36' , '-36' , '1' , '1.4000' , '1.1475409836066' , '22' , '0' , '50.40' ) 30/05/2024 05:16:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '1817' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-30') 30/05/2024 05:16:32 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' , '1817' , '2024-05-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.30' , '5.10' , NOW() , NOW() ) 30/05/2024 05:16:32 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 = '92084' 30/05/2024 05:16:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '92084' 30/05/2024 05:16:32 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 ( '92084' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 30/05/2024 05:16:32 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 ( '92084' , '20431' , 'PARTICOLA TAGLIO CHIUSO 35MM - W500' , '1' , '-1' , '3' , '3.30' , '3.1730769230769' , '4' , '0' , '3.30' ) 30/05/2024 06:21:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '1818' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-30') 30/05/2024 06:21:31 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' , '1818' , '2024-05-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.90' , '4.02' , NOW() , NOW() ) 30/05/2024 06:21:31 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 = '92085' 30/05/2024 06:21:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '92085' 30/05/2024 06:21:31 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 ( '92085' , '19560' , 'PERGAMENA COMUNIONE 17X25' , '7' , '-7' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '4.90' )