23/04/2024 08:52:14 am >> SELECT document_num FROM ps_document WHERE document_num = '1/A' AND id_document != '89846' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-01-08') 23/04/2024 08:52:14 am >> UPDATE ps_document SET id_document_type = '24', document_num = '1/A', document_date = '2024-01-08', document_letter = 'A', id_customer = '206', id_supplier = '', id_address = '4671015', address1 = 'VIA N. BUONSERVIZI, 25 84135 SALERNO', 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 = '85.30', price_tax_excluded = '85.30', date_upd = NOW() WHERE id_document = '89846' 23/04/2024 08:52:15 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89846' 23/04/2024 08:52:15 am >> DELETE FROM ps_document_detail WHERE id_document = '89846' 23/04/2024 08:52:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89846' , '22341' , 'SULLA TUA PAROLA - MAG/GIU 2024' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '0' , '5.00' ) 23/04/2024 08:52:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89846' , '22370' , 'DIGNITAS INFINITA' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 23/04/2024 08:52:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89846' , '13499' , 'VITA CRISTIANA - SANTAGOSTINO - 8742' , '1' , '-1' , '4' , '11.0000' , '11' , '0' , '0' , '11.00' ) 23/04/2024 08:52:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89846' , '22386' , 'CREDO SPIEGATO AI CRISTIANI UN PO SCETTICI ' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 23/04/2024 08:52:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89846' , '22402' , 'REGNO DI DIO E UNA SFIDA - F.J. SHEEN' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 23/04/2024 08:52:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89846' , '22084' , 'DALLA CENERE LA VITA - P. SCQUIZZATO' , '1' , '-1' , '4' , '8.9000' , '8.9' , '0' , '0' , '8.90' ) 23/04/2024 08:52:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89846' , '22427' , 'ALLASCOLTO DELLA PAROLA - M. DELBREL' , '1' , '-1' , '4' , '9.50' , '9.5' , '0' , '0' , '9.50' ) 23/04/2024 08:52:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89846' , '22430' , 'MADONNA DI FATIMA - W. WALSH' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '0' , '16.00' ) 23/04/2024 09:00:35 am >> SELECT document_num FROM ps_document WHERE document_num = '1240' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-23') 23/04/2024 09:00:35 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' , '1240' , '2024-04-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.50' , '3.69' , NOW() , NOW() ) 23/04/2024 09:00:35 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 = '91375' 23/04/2024 09:00:35 am >> DELETE FROM ps_document_detail WHERE id_document = '91375' 23/04/2024 09:00:35 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 ( '91375' , '3144' , 'CROCE TRILOBATA ' , '1' , '-1' , '1' , '4.50' , '3.6885245901639' , '22' , '0' , '4.50' ) 23/04/2024 09:10:54 am >> SELECT document_num FROM ps_document WHERE document_num = '1241' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-23') 23/04/2024 09:10:54 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' , '1241' , '2024-04-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '39.90' , '39.90' , NOW() , NOW() ) 23/04/2024 09:10:54 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 = '91376' 23/04/2024 09:10:54 am >> DELETE FROM ps_document_detail WHERE id_document = '91376' 23/04/2024 09:10:54 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 ( '91376' , '19291' , 'VANGELO DELLA PRIMA COMUNIONE' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 23/04/2024 09:10:54 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 ( '91376' , '21074' , 'SACERDOZIO MINISTERO E VITA ' , '1' , '-1' , '4' , '30.00' , '30' , '0' , '5' , '28.50' ) 23/04/2024 09:12:57 am >> SELECT document_num FROM ps_document WHERE document_num = '1242' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-23') 23/04/2024 09:12:57 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1242' , '2024-04-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '68.80' , '56.39' , NOW() , NOW() ) 23/04/2024 09:12:57 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91377' 23/04/2024 09:12:57 am >> DELETE FROM ps_document_detail WHERE id_document = '91377' 23/04/2024 09:12:57 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 ( '91377' , '16489' , 'CLERGY DIAMANTINO ML - C19' , '1' , '-1' , '1' , '68.80' , '56.393442622951' , '22' , '0' , '68.80' ) 23/04/2024 09:13:32 am >> SELECT document_num FROM ps_document WHERE document_num = '1243' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-23') 23/04/2024 09:13:32 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' , '1243' , '2024-04-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '37.00' , '30.33' , NOW() , NOW() ) 23/04/2024 09:13:32 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 = '91378' 23/04/2024 09:13:32 am >> DELETE FROM ps_document_detail WHERE id_document = '91378' 23/04/2024 09:13:32 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 ( '91378' , '19395' , 'CLERGY MISTO COTONE ML - C01' , '1' , '-1' , '1' , '37.00' , '30.327868852459' , '22' , '0' , '37.00' ) 23/04/2024 09:33:36 am >> SELECT document_num FROM ps_document WHERE document_num = '1244' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-23') 23/04/2024 09:33:36 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' , '1244' , '2024-04-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '60.00' , '49.18' , NOW() , NOW() ) 23/04/2024 09:33:36 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91379' 23/04/2024 09:33:36 am >> DELETE FROM ps_document_detail WHERE id_document = '91379' 23/04/2024 09:33:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91379' , '18222' , 'ROSARIO COLORATO - R316' , '25' , '-25' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '17.50' ) 23/04/2024 09:33:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91379' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '42.5' , '34.83606557377' , '22' , '0' , '42.50' ) 23/04/2024 09:37:41 am >> SELECT document_num FROM ps_document WHERE document_num = '1245' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-23') 23/04/2024 09:37:41 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' , '1245' , '2024-04-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '32.80' , '26.89' , NOW() , NOW() ) 23/04/2024 09:37:41 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 = '91380' 23/04/2024 09:37:41 am >> DELETE FROM ps_document_detail WHERE id_document = '91380' 23/04/2024 09:37:41 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 ( '91380' , '1914' , 'CERA DELLA LITURGIA' , '2' , '-2' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '9.80' ) 23/04/2024 09:37:41 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 ( '91380' , '19818' , 'INCENSO NATURALE 3A KG 1' , '1' , '-1' , '1' , '23.00' , '18.852459016393' , '22' , '0' , '23.00' ) 23/04/2024 09:42:09 am >> SELECT document_num FROM ps_document WHERE document_num = '1244' AND id_document != '91379' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-23') 23/04/2024 09:42:09 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1244', document_date = '2024-04-23', 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 = '60.00', price_tax_excluded = '49.18', date_upd = NOW() WHERE id_document = '91379' 23/04/2024 09:42:09 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91379' 23/04/2024 09:42:09 am >> DELETE FROM ps_document_detail WHERE id_document = '91379' 23/04/2024 09:42:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91379' , '18222' , 'ROSARIO COLORATO - R316' , '25' , '-25' , '1' , '0.7000' , '0.57377049180328' , '22' , '0' , '17.50' ) 23/04/2024 09:42:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91379' , '7924' , 'PERGAMENE - BATTESIMO MOD. A' , '5' , '-5' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '2.50' ) 23/04/2024 09:42:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91379' , '18137' , 'CROCE RILIEVO MARRONE - CR197' , '40' , '-40' , '1' , '1' , '0.81967213114754' , '22' , '0' , '40.00' ) 23/04/2024 10:10:46 am >> SELECT document_num FROM ps_document WHERE document_num = '1246' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-23') 23/04/2024 10:10:46 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' , '1246' , '2024-04-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '40.00' , '32.79' , NOW() , NOW() ) 23/04/2024 10:10:46 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 = '91381' 23/04/2024 10:10:46 am >> DELETE FROM ps_document_detail WHERE id_document = '91381' 23/04/2024 10:10:46 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 ( '91381' , '19594' , 'POLO JERSEY COTONE 100%' , '1' , '-1' , '1' , '40' , '32.786885245902' , '22' , '0' , '40.00' ) 23/04/2024 10:13:55 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 23/04/2024 10:13:55 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22437' , '1' , '' , 'nuovo-prodotto' ) 23/04/2024 10:13:55 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '22437' , '1' , '1' , '2' , NOW() , NOW() ) 23/04/2024 10:13:55 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '22437' , '0' , '1' , '0' , '0' ) 23/04/2024 10:15:00 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002264' AND id_product != '22437' AND ean13 != '' 23/04/2024 10:15:00 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002264', date_upd = NOW() WHERE id_product = '22437' 23/04/2024 10:15:00 am >> UPDATE ps_product_lang SET name = 'BRACCIALE ELASTICO S. BENEDETTO - 434M79', description = '' WHERE id_product = '22437' 23/04/2024 10:15:00 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '6.147540983606557' WHERE id_product = '22437' 23/04/2024 10:15:00 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '6.147540983606557', id_tax_rules_group = '1', id_category_default = '421', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22437' 23/04/2024 10:15:00 am >> DELETE FROM ps_specific_price WHERE id_product = '22437' 23/04/2024 10:16:47 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002264' AND id_product != '22437' AND ean13 != '' 23/04/2024 10:16:47 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002264', date_upd = NOW() WHERE id_product = '22437' 23/04/2024 10:16:47 am >> UPDATE ps_product_lang SET name = 'BRACCIALE ELASTICO S. BENEDETTO - 434M79', description = '' WHERE id_product = '22437' 23/04/2024 10:16:47 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '6.147540983606557' WHERE id_product = '22437' 23/04/2024 10:16:47 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '6.147540983606557', id_tax_rules_group = '1', id_category_default = '421', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22437' 23/04/2024 10:16:47 am >> DELETE FROM ps_specific_price WHERE id_product = '22437' 23/04/2024 10:18:53 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 = '22437' 23/04/2024 10:18:53 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22438' , '1' , '' , 'nuovo-prodotto' ) 23/04/2024 10:18:53 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 '22438' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22437' 23/04/2024 10:18:53 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22438' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22437' 23/04/2024 10:19:40 am >> SELECT ean13 FROM ps_product WHERE ean13 = '1345/CAV' AND id_product != '22438' AND ean13 != '' 23/04/2024 10:19:40 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '1345/CAV', date_upd = NOW() WHERE id_product = '22438' 23/04/2024 10:19:40 am >> UPDATE ps_product_lang SET name = 'BRACCIALE ARG. CRISTALLO - 1345/CAV', description = '' WHERE id_product = '22438' 23/04/2024 10:19:40 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '18.442622950819672' WHERE id_product = '22438' 23/04/2024 10:19:40 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '18.442622950819672', id_tax_rules_group = '1', id_category_default = '421', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22438' 23/04/2024 10:19:40 am >> DELETE FROM ps_specific_price WHERE id_product = '22438' 23/04/2024 10:20:19 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 = '22438' 23/04/2024 10:20:19 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22439' , '1' , '' , 'nuovo-prodotto' ) 23/04/2024 10:20:19 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 '22439' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22438' 23/04/2024 10:20:19 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22439' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22438' 23/04/2024 10:21:35 am >> SELECT ean13 FROM ps_product WHERE ean13 = '7678/50' AND id_product != '22439' AND ean13 != '' 23/04/2024 10:21:35 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '7678/50', date_upd = NOW() WHERE id_product = '22439' 23/04/2024 10:21:35 am >> UPDATE ps_product_lang SET name = 'ROSARIO ARGENTO/EMATITE - 7678/50', description = '' WHERE id_product = '22439' 23/04/2024 10:21:35 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '27.78688524590164' WHERE id_product = '22439' 23/04/2024 10:21:35 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '27.78688524590164', id_tax_rules_group = '1', id_category_default = '421', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22439' 23/04/2024 10:21:35 am >> DELETE FROM ps_specific_price WHERE id_product = '22439' 23/04/2024 10:30:34 am >> SELECT document_num FROM ps_document WHERE document_num = '1247' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-23') 23/04/2024 10:30:34 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' , '1247' , '2024-04-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.75' , '5.57' , NOW() , NOW() ) 23/04/2024 10:30:34 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 = '91382' 23/04/2024 10:30:34 am >> DELETE FROM ps_document_detail WHERE id_document = '91382' 23/04/2024 10:30:34 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 ( '91382' , '22341' , 'SULLA TUA PAROLA - MAG/GIU 2024' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 23/04/2024 10:30:34 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 ( '91382' , '17005' , 'BIGLIETTO AUGURALE medio' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 23/04/2024 10:33:45 am >> SELECT document_num FROM ps_document WHERE document_num = '1248' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-23') 23/04/2024 10:33: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' , '1248' , '2024-04-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.20' , '14.02' , NOW() , NOW() ) 23/04/2024 10:33: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 = '91383' 23/04/2024 10:33:45 am >> DELETE FROM ps_document_detail WHERE id_document = '91383' 23/04/2024 10:33: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 ( '91383' , '16294' , 'ALBUM DEL MIO BATTESIMO CELESTE' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 23/04/2024 10:33: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 ( '91383' , '17257' , 'IO TI BATTEZZO ' , '1' , '-1' , '4' , '1.80' , '1.8' , '0' , '0' , '1.80' ) 23/04/2024 10:33: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 ( '91383' , '17005' , 'BIGLIETTO AUGURALE medio' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 23/04/2024 10:34:04 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 = '22439' 23/04/2024 10:34:04 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22440' , '1' , '' , 'nuovo-prodotto' ) 23/04/2024 10:34:04 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 '22440' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22439' 23/04/2024 10:34:04 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22440' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22439' 23/04/2024 10:34:29 am >> SELECT ean13 FROM ps_product WHERE ean13 = '7692/50' AND id_product != '22440' AND ean13 != '' 23/04/2024 10:34:29 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '7692/50', date_upd = NOW() WHERE id_product = '22440' 23/04/2024 10:34:29 am >> UPDATE ps_product_lang SET name = 'ROSARIO ARGENTO/EMATITE - 7692/50', description = '' WHERE id_product = '22440' 23/04/2024 10:34:29 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '27.78688524590164' WHERE id_product = '22440' 23/04/2024 10:34:29 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '27.78688524590164', id_tax_rules_group = '1', id_category_default = '421', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22440' 23/04/2024 10:34:29 am >> DELETE FROM ps_specific_price WHERE id_product = '22440' 23/04/2024 10:40:42 am >> SELECT document_num FROM ps_document WHERE document_num = '1249' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-23') 23/04/2024 10:40: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' , '1249' , '2024-04-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '27.00' , '22.13' , NOW() , NOW() ) 23/04/2024 10:40: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 = '91384' 23/04/2024 10:40:42 am >> DELETE FROM ps_document_detail WHERE id_document = '91384' 23/04/2024 10:40: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 ( '91384' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '27' , '22.131147540984' , '22' , '0' , '27.00' ) 23/04/2024 10:42:08 am >> SELECT ean13 FROM ps_product WHERE ean13 = '7692/50' AND id_product != '22440' AND ean13 != '' 23/04/2024 10:42:08 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '7692/50', date_upd = NOW() WHERE id_product = '22440' 23/04/2024 10:42:08 am >> UPDATE ps_product_lang SET name = 'ROSARIO ARGENTO/EMATITE - 7692/50', description = '' WHERE id_product = '22440' 23/04/2024 10:42:08 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '27.78688524590164' WHERE id_product = '22440' 23/04/2024 10:42:08 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '27.78688524590164', id_tax_rules_group = '1', id_category_default = '421', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22440' 23/04/2024 10:42:08 am >> DELETE FROM ps_specific_price WHERE id_product = '22440' 23/04/2024 10:43:28 am >> SELECT document_num FROM ps_document WHERE document_num = '1250' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-23') 23/04/2024 10:43:28 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' , '1250' , '2024-04-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 23/04/2024 10:43:28 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 = '91385' 23/04/2024 10:43:28 am >> DELETE FROM ps_document_detail WHERE id_document = '91385' 23/04/2024 10:43:28 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 ( '91385' , '22341' , 'SULLA TUA PAROLA - MAG/GIU 2024' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 23/04/2024 10:43:59 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22440' 23/04/2024 10:43:59 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22441' , '1' , '' , 'nuovo-prodotto' ) 23/04/2024 10:43:59 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22441' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22440' 23/04/2024 10:44:00 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22441' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22440' 23/04/2024 10:45:08 am >> SELECT ean13 FROM ps_product WHERE ean13 = '7693/50' AND id_product != '22441' AND ean13 != '' 23/04/2024 10:45:08 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '7693/50', date_upd = NOW() WHERE id_product = '22441' 23/04/2024 10:45:08 am >> UPDATE ps_product_lang SET name = 'ROSARIO ARGENTO/CRISTALLO - 7693/50', description = '' WHERE id_product = '22441' 23/04/2024 10:45:08 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '29.42622950819672' WHERE id_product = '22441' 23/04/2024 10:45:08 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '29.42622950819672', id_tax_rules_group = '1', id_category_default = '421', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22441' 23/04/2024 10:45:08 am >> DELETE FROM ps_specific_price WHERE id_product = '22441' 23/04/2024 10:45:33 am >> SELECT ean13 FROM ps_product WHERE ean13 = '7692/50' AND id_product != '22440' AND ean13 != '' 23/04/2024 10:45:33 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '7692/50', date_upd = NOW() WHERE id_product = '22440' 23/04/2024 10:45:33 am >> UPDATE ps_product_lang SET name = 'ROSARIO ARGENTO/LAVA - 7692/50', description = '' WHERE id_product = '22440' 23/04/2024 10:45:33 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '27.7869' WHERE id_product = '22440' 23/04/2024 10:45:33 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '27.7869', id_tax_rules_group = '1', id_category_default = '421', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22440' 23/04/2024 10:45:33 am >> DELETE FROM ps_specific_price WHERE id_product = '22440' 23/04/2024 10:45:38 am >> SELECT ean13 FROM ps_product WHERE ean13 = '7693/50' AND id_product != '22441' AND ean13 != '' 23/04/2024 10:45:38 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '7693/50', date_upd = NOW() WHERE id_product = '22441' 23/04/2024 10:45:39 am >> UPDATE ps_product_lang SET name = 'ROSARIO ARGENTO/CRISTALLO - 7693/50', description = '' WHERE id_product = '22441' 23/04/2024 10:45:39 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '29.42622950819672' WHERE id_product = '22441' 23/04/2024 10:45:39 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '29.42622950819672', id_tax_rules_group = '1', id_category_default = '421', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22441' 23/04/2024 10:45:39 am >> DELETE FROM ps_specific_price WHERE id_product = '22441' 23/04/2024 10:47:25 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 = '22441' 23/04/2024 10:47:25 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22442' , '1' , '' , 'nuovo-prodotto' ) 23/04/2024 10:47:25 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 '22442' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22441' 23/04/2024 10:47:25 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22442' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22441' 23/04/2024 10:48:28 am >> SELECT ean13 FROM ps_product WHERE ean13 = '1347/CAV' AND id_product != '22442' AND ean13 != '' 23/04/2024 10:48:28 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '1347/CAV', date_upd = NOW() WHERE id_product = '22442' 23/04/2024 10:48:28 am >> UPDATE ps_product_lang SET name = 'ROSARIO ARG. CRISTALLO - 1347/CAV', description = '' WHERE id_product = '22442' 23/04/2024 10:48:28 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '44.18032786885246' WHERE id_product = '22442' 23/04/2024 10:48:28 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '44.18032786885246', id_tax_rules_group = '1', id_category_default = '421', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22442' 23/04/2024 10:48:28 am >> DELETE FROM ps_specific_price WHERE id_product = '22442' 23/04/2024 10:49:24 am >> SELECT document_num FROM ps_document WHERE document_num = '1251' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-23') 23/04/2024 10:49:24 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' , '1251' , '2024-04-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.50' , '9.50' , NOW() , NOW() ) 23/04/2024 10:49:24 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 = '91386' 23/04/2024 10:49:24 am >> DELETE FROM ps_document_detail WHERE id_document = '91386' 23/04/2024 10:49:24 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 ( '91386' , '22341' , 'SULLA TUA PAROLA - MAG/GIU 2024' , '2' , '-2' , '4' , '5.00' , '5' , '0' , '5' , '9.50' ) 23/04/2024 10:51:42 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002142' AND id_product != '21089' AND ean13 != '' 23/04/2024 10:51:42 am >> UPDATE ps_product SET id_supplier = '113', reference = '', ean13 = '002142', date_upd = NOW() WHERE id_product = '21089' 23/04/2024 10:51:42 am >> UPDATE ps_product_lang SET name = 'ANELLO ROSARIO ARG. - 6450', description = '' WHERE id_product = '21089' 23/04/2024 10:51:42 am >> UPDATE ps_product SET wholesale_price = '11.02', on_sale = '0', price = '27.049180327868854' WHERE id_product = '21089' 23/04/2024 10:51:42 am >> UPDATE ps_product_shop SET wholesale_price = '11.02', price = '27.049180327868854', id_tax_rules_group = '1', id_category_default = '421', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21089' 23/04/2024 10:51:42 am >> DELETE FROM ps_specific_price WHERE id_product = '21089' 23/04/2024 10:52:23 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002142' AND id_product != '21089' AND ean13 != '' 23/04/2024 10:52:23 am >> UPDATE ps_product SET id_supplier = '113', reference = '', ean13 = '002142', date_upd = NOW() WHERE id_product = '21089' 23/04/2024 10:52:23 am >> UPDATE ps_product_lang SET name = 'ANELLO ROSARIO ARG. - 6450', description = '' WHERE id_product = '21089' 23/04/2024 10:52:23 am >> UPDATE ps_product SET wholesale_price = '11.02', on_sale = '0', price = '27.049180327868854' WHERE id_product = '21089' 23/04/2024 10:52:23 am >> UPDATE ps_product_shop SET wholesale_price = '11.02', price = '27.049180327868854', id_tax_rules_group = '1', id_category_default = '421', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21089' 23/04/2024 10:52:23 am >> DELETE FROM ps_specific_price WHERE id_product = '21089' 23/04/2024 10:52:48 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 = '22442' 23/04/2024 10:52:48 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22443' , '1' , '' , 'nuovo-prodotto' ) 23/04/2024 10:52:48 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 '22443' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22442' 23/04/2024 10:52:48 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22443' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22442' 23/04/2024 10:53:22 am >> SELECT ean13 FROM ps_product WHERE ean13 = '6451' AND id_product != '22443' AND ean13 != '' 23/04/2024 10:53:22 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '6451', date_upd = NOW() WHERE id_product = '22443' 23/04/2024 10:53:22 am >> UPDATE ps_product_lang SET name = 'ANELLO ROSARIO ARG. - 6451', description = '' WHERE id_product = '22443' 23/04/2024 10:53:22 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '30.327868852459016' WHERE id_product = '22443' 23/04/2024 10:53:22 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '30.327868852459016', id_tax_rules_group = '1', id_category_default = '421', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22443' 23/04/2024 10:53:22 am >> DELETE FROM ps_specific_price WHERE id_product = '22443' 23/04/2024 10:54:16 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 = '22443' 23/04/2024 10:54:16 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22444' , '1' , '' , 'nuovo-prodotto' ) 23/04/2024 10:54:16 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 '22444' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22443' 23/04/2024 10:54:16 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22444' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22443' 23/04/2024 10:54:37 am >> SELECT ean13 FROM ps_product WHERE ean13 = '6712' AND id_product != '22444' AND ean13 != '' 23/04/2024 10:54:37 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '6712', date_upd = NOW() WHERE id_product = '22444' 23/04/2024 10:54:37 am >> UPDATE ps_product_lang SET name = 'ANELLO ARGENTO - 6712', description = '' WHERE id_product = '22444' 23/04/2024 10:54:37 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '66.80327868852459' WHERE id_product = '22444' 23/04/2024 10:54:37 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '66.80327868852459', id_tax_rules_group = '1', id_category_default = '421', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22444' 23/04/2024 10:54:37 am >> DELETE FROM ps_specific_price WHERE id_product = '22444' 23/04/2024 11:25:01 am >> SELECT ean13 FROM ps_product WHERE ean13 = '1452/CAV' AND id_product != '21175' AND ean13 != '' 23/04/2024 11:25:01 am >> UPDATE ps_product SET id_supplier = '113', reference = '', ean13 = '1452/CAV', date_upd = NOW() WHERE id_product = '21175' 23/04/2024 11:25:01 am >> UPDATE ps_product_lang SET name = 'BRACCIALE ARG. MM6 - 1452/CAV', description = '' WHERE id_product = '21175' 23/04/2024 11:25:01 am >> UPDATE ps_product SET wholesale_price = '7.03', on_sale = '0', price = '15.491803278688524' WHERE id_product = '21175' 23/04/2024 11:25:01 am >> UPDATE ps_product_shop SET wholesale_price = '7.03', price = '15.491803278688524', id_tax_rules_group = '1', id_category_default = '421', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21175' 23/04/2024 11:25:01 am >> DELETE FROM ps_specific_price WHERE id_product = '21175' 23/04/2024 11:27:00 am >> SELECT ean13 FROM ps_product WHERE ean13 = '1793/CAV' AND id_product != '19781' AND ean13 != '' 23/04/2024 11:27:00 am >> UPDATE ps_product SET id_supplier = '113', reference = '', ean13 = '1793/CAV', date_upd = NOW() WHERE id_product = '19781' 23/04/2024 11:27:00 am >> UPDATE ps_product_lang SET name = 'BRACCIALE ARGENTO/EMATITE - 1793/CAV', description = '' WHERE id_product = '19781' 23/04/2024 11:27:01 am >> UPDATE ps_product SET wholesale_price = '7.13', on_sale = '0', price = '15.1639' WHERE id_product = '19781' 23/04/2024 11:27:01 am >> UPDATE ps_product_shop SET wholesale_price = '7.13', price = '15.1639', id_tax_rules_group = '1', id_category_default = '421', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19781' 23/04/2024 11:27:01 am >> DELETE FROM ps_specific_price WHERE id_product = '19781' 23/04/2024 11:30:38 am >> SELECT ean13 FROM ps_product WHERE ean13 = '1965/CAV' AND id_product != '20074' AND ean13 != '' 23/04/2024 11:30:38 am >> UPDATE ps_product SET id_supplier = '113', reference = '', ean13 = '1965/CAV', date_upd = NOW() WHERE id_product = '20074' 23/04/2024 11:30:38 am >> UPDATE ps_product_lang SET name = 'ROSARIO ARG/PERLA/EMATITE ', description = '' WHERE id_product = '20074' 23/04/2024 11:30:38 am >> UPDATE ps_product SET wholesale_price = '18.62', on_sale = '0', price = '40.08196721311475' WHERE id_product = '20074' 23/04/2024 11:30:38 am >> UPDATE ps_product_shop SET wholesale_price = '18.62', price = '40.08196721311475', id_tax_rules_group = '1', id_category_default = '421', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20074' 23/04/2024 11:30:38 am >> DELETE FROM ps_specific_price WHERE id_product = '20074' 23/04/2024 11:54:12 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' , '377/2024' , '2024-04-17' , '2024' , '0' , '113' , '4669149' , 'VIA VALLE CALDA, 7 16013 CAMPO LIGURE' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '421.18' , '345.23' , NOW() , NOW() ) 23/04/2024 11:54:12 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91387' 23/04/2024 11:54:12 am >> DELETE FROM ps_document_detail WHERE id_document = '91387' 23/04/2024 11:54:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91387' , '22438' , 'BRACCIALE ARG. CRISTALLO - 1345/CAV' , '1' , '1' , '1' , '9.2' , '7.5409836065574' , '22' , '5' , '10.6628' ) 23/04/2024 11:54:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '22438' AND id_supplier = '113' 23/04/2024 11:54:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22438' , '113' , '1' ) 23/04/2024 11:54:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91387' , '22439' , 'ROSARIO ARGENTO/EMATITE - 7678/50' , '1' , '1' , '1' , '13.7' , '11.229508196721' , '22' , '5' , '15.8783' ) 23/04/2024 11:54:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '22439' AND id_supplier = '113' 23/04/2024 11:54:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22439' , '113' , '1' ) 23/04/2024 11:54:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91387' , '22440' , 'ROSARIO ARGENTO/LAVA - 7692/50' , '1' , '1' , '1' , '13.6' , '11.147540983607' , '22' , '5' , '15.7624' ) 23/04/2024 11:54:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '22440' AND id_supplier = '113' 23/04/2024 11:54:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22440' , '113' , '1' ) 23/04/2024 11:54:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91387' , '22441' , 'ROSARIO ARGENTO/CRISTALLO - 7693/50' , '2' , '2' , '1' , '14.6' , '11.967213114754' , '22' , '5' , '33.8428' ) 23/04/2024 11:54:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '22441' AND id_supplier = '113' 23/04/2024 11:54:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22441' , '113' , '1' ) 23/04/2024 11:54:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91387' , '22442' , 'ROSARIO ARG. CRISTALLO - 1347/CAV' , '1' , '1' , '1' , '22.1' , '18.114754098361' , '22' , '5' , '25.6139' ) 23/04/2024 11:54:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '22442' AND id_supplier = '113' 23/04/2024 11:54:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22442' , '113' , '1' ) 23/04/2024 11:54:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91387' , '21767' , 'CROCE PETTORALE IN FILIGRANA - 3467' , '1' , '1' , '1' , '92.6' , '75.901639344262' , '22' , '5' , '107.3234' ) 23/04/2024 11:54:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '21767' AND id_supplier = '113' 23/04/2024 11:54:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21767' , '113' , '1' ) 23/04/2024 11:54: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 ( '91387' , '22444' , 'ANELLO ARGENTO - 6712' , '1' , '1' , '1' , '33.4' , '27.377049180328' , '22' , '5' , '38.7106' ) 23/04/2024 11:54:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '22444' AND id_supplier = '113' 23/04/2024 11:54:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22444' , '113' , '1' ) 23/04/2024 11:54: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 ( '91387' , '21089' , 'ANELLO ROSARIO ARG. - 6450' , '1' , '1' , '1' , '13.5' , '11.065573770492' , '22' , '5' , '15.6465' ) 23/04/2024 11:54:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '21089' AND id_supplier = '113' 23/04/2024 11:54:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21089' , '113' , '1' ) 23/04/2024 11:54: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 ( '91387' , '22443' , 'ANELLO ROSARIO ARG. - 6451' , '1' , '1' , '1' , '15.2' , '12.459016393443' , '22' , '5' , '17.6168' ) 23/04/2024 11:54:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '22443' AND id_supplier = '113' 23/04/2024 11:54:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22443' , '113' , '1' ) 23/04/2024 11:54: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 ( '91387' , '20078' , 'ROSARIO ARGENTO' , '1' , '1' , '1' , '21.8' , '17.868852459016' , '22' , '5' , '25.2662' ) 23/04/2024 11:54:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '20078' AND id_supplier = '113' 23/04/2024 11:54:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20078' , '113' , '1' ) 23/04/2024 11:54: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 ( '91387' , '21177' , 'BRACCIALE ARG. EMATITE - 1623CAV' , '1' , '1' , '1' , '8.6' , '7.0491803278689' , '22' , '5' , '9.9674' ) 23/04/2024 11:54:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '21177' AND id_supplier = '113' 23/04/2024 11:54:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21177' , '113' , '1' ) 23/04/2024 11:54: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 ( '91387' , '21175' , 'BRACCIALE ARG. MM6 - 1452/CAV' , '1' , '1' , '1' , '7.6' , '6.2295081967213' , '22' , '5' , '8.8084' ) 23/04/2024 11:54:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '21175' AND id_supplier = '113' 23/04/2024 11:54:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21175' , '113' , '1' ) 23/04/2024 11:54: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 ( '91387' , '21084' , 'BRACCIALE ARG. DIAMANTATO - 1835' , '1' , '1' , '1' , '10.1' , '8.2786885245902' , '22' , '5' , '11.7059' ) 23/04/2024 11:54:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '21084' AND id_supplier = '113' 23/04/2024 11:54:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21084' , '113' , '1' ) 23/04/2024 11:54: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 ( '91387' , '19781' , 'BRACCIALE ARGENTO/EMATITE - 1793/CAV' , '1' , '1' , '1' , '7.5' , '6.1475409836066' , '22' , '5' , '8.6925' ) 23/04/2024 11:54:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '19781' AND id_supplier = '113' 23/04/2024 11:54:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19781' , '113' , '1' ) 23/04/2024 11:54: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 ( '91387' , '19772' , 'BRACCIALE ARGENTO/EMATITE - 1374CAV' , '1' , '1' , '1' , '8.3' , '6.8032786885246' , '22' , '5' , '9.6197' ) 23/04/2024 11:54:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '19772' AND id_supplier = '113' 23/04/2024 11:54:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19772' , '113' , '1' ) 23/04/2024 11:54: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 ( '91387' , '20074' , 'ROSARIO ARG/PERLA/EMATITE ' , '1' , '1' , '1' , '19.8' , '16.229508196721' , '22' , '5' , '22.9482' ) 23/04/2024 11:54:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '20074' AND id_supplier = '113' 23/04/2024 11:54:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20074' , '113' , '1' ) 23/04/2024 11:54: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 ( '91387' , '22437' , 'BRACCIALE ELASTICO S. BENEDETTO - 434M79' , '12' , '12' , '1' , '3.1' , '2.5409836065574' , '22' , '5' , '43.1148' ) 23/04/2024 11:54:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '22437' AND id_supplier = '113' 23/04/2024 11:54:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22437' , '113' , '1' ) 23/04/2024 12:02:24 pm >> SELECT document_num FROM ps_document WHERE document_num = '1252' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-23') 23/04/2024 12:02:24 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1252' , '2024-04-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '23.00' , '18.85' , NOW() , NOW() ) 23/04/2024 12:02:24 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91388' 23/04/2024 12:02:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '91388' 23/04/2024 12:02:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91388' , '19861' , 'FERMAGLIO - B225/CA' , '1' , '-1' , '1' , '23.00' , '18.852459016393' , '22' , '0' , '23.00' ) 23/04/2024 12:04:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '1253' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-23') 23/04/2024 12:04:42 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1253' , '2024-04-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.40' , '1.40' , NOW() , NOW() ) 23/04/2024 12:04:42 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91389' 23/04/2024 12:04:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '91389' 23/04/2024 12:04:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91389' , '9586' , 'SANTA MESSA - CATALINA RIVAS' , '1' , '-1' , '4' , '1.40' , '1.4' , '0' , '0' , '1.40' ) 23/04/2024 12:23:29 pm >> SELECT document_num FROM ps_document WHERE document_num = '1254' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-23') 23/04/2024 12:23:29 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1254' , '2024-04-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '119.00' , '97.54' , NOW() , NOW() ) 23/04/2024 12:23:29 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91390' 23/04/2024 12:23:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '91390' 23/04/2024 12:23:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91390' , '13805' , 'QUADRETTO 10X10 ALBERO DELLA VITA - 2974/F0024' , '5' , '-5' , '1' , '11.90' , '9.7540983606557' , '22' , '0' , '59.50' ) 23/04/2024 12:23:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91390' , '13803' , 'QUADRETTO 10X10 COMUNIONE- 2974/K0142' , '5' , '-5' , '1' , '11.9' , '9.7540983606557' , '22' , '0' , '59.50' ) 23/04/2024 12:31:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '53/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-04-23') 23/04/2024 12:31: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 ( '24' , '53/A' , '2024-04-23' , 'A' , '0' , '113' , '4669149' , 'VIA VALLE CALDA, 7 16013 CAMPO LIGURE' , '' , 'RESO AL FORNITORE' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '0.00' , '0.00' , NOW() , NOW() ) 23/04/2024 12:31: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 = '91391' 23/04/2024 12:31:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '91391' 23/04/2024 12:31: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 ( '91391' , '22437' , 'BRACCIALE ELASTICO S. BENEDETTO - 434M79' , '12' , '-12' , '1' , '0' , '0' , '22' , '0' , '0.00' ) 23/04/2024 12:31:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22437' AND id_supplier = '113' 23/04/2024 12:31:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22437' , '113' , '1' ) 23/04/2024 12:38:07 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '6136/00/2024' , '2024-04-19' , '00' , '0' , '38' , '2633' , 'VIA GALVANI, 1 60020 CAMERATA PICENA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '204.00' , '204.00' , NOW() , NOW() ) 23/04/2024 12:38:07 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91392' 23/04/2024 12:38:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '91392' 23/04/2024 12:38:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91392' , '22341' , 'SULLA TUA PAROLA - MAG/GIU 2024' , '60' , '60' , '4' , '5.00' , '5' , '0' , '40' , '180.0000' ) 23/04/2024 12:38:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22341' AND id_supplier = '38' 23/04/2024 12:38:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22341' , '38' , '1' ) 23/04/2024 12:38:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91392' , '8244' , 'PREGATE IL SANTO ROSARIO OGNI GIORNO... - 8102' , '1' , '1' , '4' , '9.00' , '9' , '0' , '40' , '5.4000' ) 23/04/2024 12:38:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8244' AND id_supplier = '38' 23/04/2024 12:38:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8244' , '38' , '1' ) 23/04/2024 12:38:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91392' , '8383' , 'PREGHIERE PER LADORAZIONE EUCARISTICA - 8141' , '1' , '1' , '4' , '12.00' , '12' , '0' , '40' , '7.2000' ) 23/04/2024 12:38:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8383' AND id_supplier = '38' 23/04/2024 12:38:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8383' , '38' , '1' ) 23/04/2024 12:38:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91392' , '7127' , 'NOVENE IN ONORE DELLO SPIRITO SANTO - 8237' , '1' , '1' , '4' , '7.00' , '7' , '0' , '40' , '4.2000' ) 23/04/2024 12:38:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7127' AND id_supplier = '38' 23/04/2024 12:38:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7127' , '38' , '1' ) 23/04/2024 12:38:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91392' , '5461' , 'IO SONO IL PANE DELLA VITA - 8391' , '3' , '3' , '4' , '2.00' , '2' , '0' , '40' , '3.6000' ) 23/04/2024 12:38:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5461' AND id_supplier = '38' 23/04/2024 12:38:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5461' , '38' , '1' ) 23/04/2024 12:38:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91392' , '15746' , 'ADORIAMO IL SS SACRAMENTO - VOL 1 - 8958' , '2' , '2' , '4' , '3.00' , '3' , '0' , '40' , '3.6000' ) 23/04/2024 12:38:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15746' AND id_supplier = '38' 23/04/2024 12:38:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15746' , '38' , '1' ) 23/04/2024 12:51:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '1255' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-23') 23/04/2024 12:51:59 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1255' , '2024-04-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '18.00' , '18.00' , NOW() , NOW() ) 23/04/2024 12:51:59 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91393' 23/04/2024 12:51:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '91393' 23/04/2024 12:51:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91393' , '22266' , 'ARTE DI STARE SOLI - A. GRUN' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '0' , '18.00' ) 23/04/2024 02:21:07 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '32412776' , '2024-04-18' , '' , '0' , '184' , '4679196' , 'VIALE NAVIGAZIONE INTERNA 89 35027 NOVENTA PADOVANA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '0.00' , '0.00' , NOW() , NOW() ) 23/04/2024 02:21:07 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91394' 23/04/2024 02:21:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '91394' 23/04/2024 02:21:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91394' , '21899' , 'SACRA BIBBIA cei/uelci ' , '480' , '480' , '4' , '0' , '0' , '0' , '0' , '0.0000' ) 23/04/2024 02:21:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21899' AND id_supplier = '184' 23/04/2024 02:21:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21899' , '184' , '1' ) 23/04/2024 02:54:56 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 23/04/2024 02:54:56 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22445' , '1' , '' , 'nuovo-prodotto' ) 23/04/2024 02:54:56 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '22445' , '1' , '1' , '2' , NOW() , NOW() ) 23/04/2024 02:54:56 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '22445' , '0' , '1' , '0' , '0' ) 23/04/2024 02:55:27 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788826608693' AND id_product != '22445' AND ean13 != '' 23/04/2024 02:55:27 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788826608693', date_upd = NOW() WHERE id_product = '22445' 23/04/2024 02:55:27 pm >> UPDATE ps_product_lang SET name = 'PARABOLE DELLA PREGHIERA - 5', description = '' WHERE id_product = '22445' 23/04/2024 02:55:27 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '8.5' WHERE id_product = '22445' 23/04/2024 02:55:27 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '8.5', id_tax_rules_group = '4', id_category_default = '104', 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 = '22445' 23/04/2024 02:55:27 pm >> DELETE FROM ps_specific_price WHERE id_product = '22445' 23/04/2024 02:55:28 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22445' 23/04/2024 02:55:28 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22446' , '1' , '' , 'nuovo-prodotto' ) 23/04/2024 02:55:28 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22446' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22445' 23/04/2024 02:55:28 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22446' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22445' 23/04/2024 02:55:49 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9722826602626' AND id_product != '22446' AND ean13 != '' 23/04/2024 02:55:49 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9722826602626', date_upd = NOW() WHERE id_product = '22446' 23/04/2024 02:55:49 pm >> UPDATE ps_product_lang SET name = 'PREGARE CON SANTI E PECCATORI - 4', description = '' WHERE id_product = '22446' 23/04/2024 02:55:49 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '8.5' WHERE id_product = '22446' 23/04/2024 02:55:49 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '8.5', id_tax_rules_group = '4', id_category_default = '104', 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 = '22446' 23/04/2024 02:55:49 pm >> DELETE FROM ps_specific_price WHERE id_product = '22446' 23/04/2024 02:55:50 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22446' 23/04/2024 02:55:50 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22447' , '1' , '' , 'nuovo-prodotto' ) 23/04/2024 02:55:50 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22447' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22446' 23/04/2024 02:55:50 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22447' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22446' 23/04/2024 02:56:19 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788826608686' AND id_product != '22446' AND ean13 != '' 23/04/2024 02:56:19 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788826608686', date_upd = NOW() WHERE id_product = '22446' 23/04/2024 02:56:19 pm >> UPDATE ps_product_lang SET name = 'PREGARE CON SANTI E PECCATORI - 4', description = '' WHERE id_product = '22446' 23/04/2024 02:56:19 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '8.5000' WHERE id_product = '22446' 23/04/2024 02:56:19 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '8.5000', id_tax_rules_group = '4', id_category_default = '104', 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 = '22446' 23/04/2024 02:56:19 pm >> DELETE FROM ps_specific_price WHERE id_product = '22446' 23/04/2024 02:58:28 pm >> SELECT document_num FROM ps_document WHERE document_num = '76' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-04-23') 23/04/2024 02:58:28 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 ( '21' , '76' , '2024-04-23' , '' , '4081' , '0' , '4679276' , 'VIA PAZZIGNO 6 80146 NAPOLI' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '66.10' , '66.10' , NOW() , NOW() ) 23/04/2024 02:58:28 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 = '91395' 23/04/2024 02:58:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '91395' 23/04/2024 02:58:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91395' , '22446' , 'PREGARE CON SANTI E PECCATORI - 4' , '1' , '-1' , '4' , '8.50' , '8.5' , '0' , '5' , '8.07' ) 23/04/2024 02:58:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91395' , '22445' , 'PARABOLE DELLA PREGHIERA - 5' , '1' , '-1' , '4' , '8.50' , '8.5' , '0' , '5' , '8.07' ) 23/04/2024 02:58:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91395' , '22431' , 'TANTO LAMORE SI E CHINATO' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 23/04/2024 02:58:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91395' , '22109' , 'QUINDICI MINUTI S. ANTONIO MARIA CLARET' , '5' , '-5' , '4' , '0.50' , '0.5' , '0' , '0' , '2.50' ) 23/04/2024 02:58:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91395' , '22390' , 'ROSARIO DELLA GUARIGIONE' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 23/04/2024 02:58:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91395' , '22397' , 'AFFERRATI DALLAMORE' , '1' , '-1' , '4' , '4.90' , '4.9' , '0' , '5' , '4.66' ) 23/04/2024 02:58:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91395' , '22403' , 'MIO LIBRO DI PREGHIERE - A. COMASTRI' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 23/04/2024 02:58:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91395' , '22413' , 'VITA DI SAN GIUSEPPE - 8653' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 23/04/2024 02:58:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91395' , '8244' , 'PREGATE IL SANTO ROSARIO OGNI GIORNO... - 8102' , '1' , '-1' , '4' , '9.00' , '9' , '0' , '5' , '8.55' ) 23/04/2024 02:58:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91395' , '' , 'CONTRASSEGNO' , '1' , '-1' , '4' , '2.9' , '2.9' , '0' , '0' , '2.90' ) 23/04/2024 03:14:33 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788826608594' AND id_product != '22111' AND ean13 != '' 23/04/2024 03:14:33 pm >> UPDATE ps_product SET id_supplier = '79', reference = 'GONDOLA 1', ean13 = '9788826608594', date_upd = NOW() WHERE id_product = '22111' 23/04/2024 03:14:34 pm >> UPDATE ps_product_lang SET name = 'PREGARE OGGI - 1', description = '' WHERE id_product = '22111' 23/04/2024 03:14:34 pm >> UPDATE ps_product SET wholesale_price = '4.68', on_sale = '0', price = '8.5000' WHERE id_product = '22111' 23/04/2024 03:14:34 pm >> UPDATE ps_product_shop SET wholesale_price = '4.68', price = '8.5000', id_tax_rules_group = '4', id_category_default = '104', 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 = '22111' 23/04/2024 03:14:34 pm >> DELETE FROM ps_specific_price WHERE id_product = '22111' 23/04/2024 03:14:44 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788826608662' AND id_product != '22191' AND ean13 != '' 23/04/2024 03:14:44 pm >> UPDATE ps_product SET id_supplier = '79', reference = '', ean13 = '9788826608662', date_upd = NOW() WHERE id_product = '22191' 23/04/2024 03:14:44 pm >> UPDATE ps_product_lang SET name = 'PREGARE CON I SALMI - 2', description = '' WHERE id_product = '22191' 23/04/2024 03:14:44 pm >> UPDATE ps_product SET wholesale_price = '4.68', on_sale = '0', price = '8.5000' WHERE id_product = '22191' 23/04/2024 03:14:44 pm >> UPDATE ps_product_shop SET wholesale_price = '4.68', price = '8.5000', id_tax_rules_group = '4', id_category_default = '104', 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 = '22191' 23/04/2024 03:14:44 pm >> DELETE FROM ps_specific_price WHERE id_product = '22191' 23/04/2024 03:14:53 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788826608679' AND id_product != '22192' AND ean13 != '' 23/04/2024 03:14:53 pm >> UPDATE ps_product SET id_supplier = '79', reference = '', ean13 = '9788826608679', date_upd = NOW() WHERE id_product = '22192' 23/04/2024 03:14:53 pm >> UPDATE ps_product_lang SET name = 'PREGHIERA DI GESU\' - 3', description = '' WHERE id_product = '22192' 23/04/2024 03:14:53 pm >> UPDATE ps_product SET wholesale_price = '4.68', on_sale = '0', price = '8.5000' WHERE id_product = '22192' 23/04/2024 03:14:53 pm >> UPDATE ps_product_shop SET wholesale_price = '4.68', price = '8.5000', id_tax_rules_group = '4', id_category_default = '104', 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 = '22192' 23/04/2024 03:14:53 pm >> DELETE FROM ps_specific_price WHERE id_product = '22192' 23/04/2024 03:15:35 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788826608709' AND id_product != '22290' AND ean13 != '' 23/04/2024 03:15:35 pm >> UPDATE ps_product SET id_supplier = '79', reference = '', ean13 = '9788826608709', date_upd = NOW() WHERE id_product = '22290' 23/04/2024 03:15:35 pm >> UPDATE ps_product_lang SET name = 'CHIESA IN PREGHIERA - 6', description = '' WHERE id_product = '22290' 23/04/2024 03:15:35 pm >> UPDATE ps_product SET wholesale_price = '4.68', on_sale = '0', price = '8.5000' WHERE id_product = '22290' 23/04/2024 03:15:35 pm >> UPDATE ps_product_shop SET wholesale_price = '4.68', price = '8.5000', id_tax_rules_group = '4', id_category_default = '104', id_argoment_default = '188', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22290' 23/04/2024 03:15:35 pm >> DELETE FROM ps_specific_price WHERE id_product = '22290' 23/04/2024 03:15:38 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 = '22290' 23/04/2024 03:15:38 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22448' , '1' , '' , 'nuovo-prodotto' ) 23/04/2024 03:15:38 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 '22448' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22290' 23/04/2024 03:15:39 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22448' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22290' 23/04/2024 03:16:19 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788826608723' AND id_product != '22448' AND ean13 != '' 23/04/2024 03:16:20 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788826608723', date_upd = NOW() WHERE id_product = '22448' 23/04/2024 03:16:20 pm >> UPDATE ps_product_lang SET name = 'PREGHIERA DI MARIA - 7', description = '' WHERE id_product = '22448' 23/04/2024 03:16:20 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '8.5' WHERE id_product = '22448' 23/04/2024 03:16:20 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '8.5', id_tax_rules_group = '4', id_category_default = '104', id_argoment_default = '188', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22448' 23/04/2024 03:16:20 pm >> DELETE FROM ps_specific_price WHERE id_product = '22448' 23/04/2024 03:16:21 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 = '22448' 23/04/2024 03:16:21 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22449' , '1' , '' , 'nuovo-prodotto' ) 23/04/2024 03:16:21 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 '22449' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22448' 23/04/2024 03:16:21 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22449' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22448' 23/04/2024 03:16:47 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788826608716' AND id_product != '22449' AND ean13 != '' 23/04/2024 03:16:47 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788826608716', date_upd = NOW() WHERE id_product = '22449' 23/04/2024 03:16:47 pm >> UPDATE ps_product_lang SET name = 'PREGHIERA CHE GESU\' CI HA INSEGNATO - 8', description = '' WHERE id_product = '22449' 23/04/2024 03:16:47 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '8.5' WHERE id_product = '22449' 23/04/2024 03:16:47 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '8.5', id_tax_rules_group = '4', id_category_default = '104', id_argoment_default = '188', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22449' 23/04/2024 03:16:47 pm >> DELETE FROM ps_specific_price WHERE id_product = '22449' 23/04/2024 03:16: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 = '22449' 23/04/2024 03:16:48 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22450' , '1' , '' , 'nuovo-prodotto' ) 23/04/2024 03:16: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 '22450' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22449' 23/04/2024 03:16:48 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22450' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22449' 23/04/2024 03:17:06 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '2024-DL001442' , '2024-04-19' , '' , '0' , '79' , '2686' , 'CITTA\\\' DEL VATICANO 00120 CITTA\\\' DEL VATICANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '238.43' , '238.43' , NOW() , NOW() ) 23/04/2024 03:17:06 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91396' 23/04/2024 03:17:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '91396' 23/04/2024 03:17:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91396' , '22111' , 'PREGARE OGGI' , '3' , '3' , '4' , '8.50' , '8.5' , '0' , '45' , '14.0250' ) 23/04/2024 03:17:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22111' AND id_supplier = '79' 23/04/2024 03:17:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22111' , '79' , '1' ) 23/04/2024 03:17:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91396' , '22191' , 'PREGARE CON I SALMI' , '2' , '2' , '4' , '8.50' , '8.5' , '0' , '45' , '9.3500' ) 23/04/2024 03:17:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22191' AND id_supplier = '79' 23/04/2024 03:17:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22191' , '79' , '1' ) 23/04/2024 03:17:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91396' , '22192' , 'PREGHIERA DI GESU' , '2' , '2' , '4' , '8.50' , '8.5' , '0' , '45' , '9.3500' ) 23/04/2024 03:17:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22192' AND id_supplier = '79' 23/04/2024 03:17:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22192' , '79' , '1' ) 23/04/2024 03:17:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91396' , '22446' , 'PREGARE CON SANTI E PECCATORI - 4' , '10' , '10' , '4' , '8.50' , '8.5' , '0' , '45' , '46.7500' ) 23/04/2024 03:17:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22446' AND id_supplier = '79' 23/04/2024 03:17:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22446' , '79' , '1' ) 23/04/2024 03:17:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91396' , '22445' , 'PARABOLE DELLA PREGHIERA - 5' , '10' , '10' , '4' , '8.50' , '8.5' , '0' , '45' , '46.7500' ) 23/04/2024 03:17:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22445' AND id_supplier = '79' 23/04/2024 03:17:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22445' , '79' , '1' ) 23/04/2024 03:17:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91396' , '22290' , 'CHIESA IN PREGHIERA - 6' , '4' , '4' , '4' , '8.50' , '8.5' , '0' , '45' , '18.7000' ) 23/04/2024 03:17:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22290' AND id_supplier = '79' 23/04/2024 03:17:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22290' , '79' , '1' ) 23/04/2024 03:17:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91396' , '22448' , 'PREGHIERA DI MARIA - 7' , '10' , '10' , '4' , '8.50' , '8.5' , '0' , '45' , '46.7500' ) 23/04/2024 03:17:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22448' AND id_supplier = '79' 23/04/2024 03:17:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22448' , '79' , '1' ) 23/04/2024 03:17:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91396' , '22449' , 'PREGHIERA CHE GESU CI HA INSEGNATO - 8' , '10' , '10' , '4' , '8.50' , '8.5' , '0' , '45' , '46.7500' ) 23/04/2024 03:17:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22449' AND id_supplier = '79' 23/04/2024 03:17:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22449' , '79' , '1' ) 23/04/2024 03:25:31 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801069136' AND id_product != '22450' AND ean13 != '' 23/04/2024 03:25:31 pm >> UPDATE ps_product SET id_supplier = '', reference = '2/4', ean13 = '9788801069136', date_upd = NOW() WHERE id_product = '22450' 23/04/2024 03:25:31 pm >> UPDATE ps_product_lang SET name = 'DIO E\' SEMPRE CON NOI', description = '' WHERE id_product = '22450' 23/04/2024 03:25:31 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '1.9' WHERE id_product = '22450' 23/04/2024 03:25:31 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '1.9', id_tax_rules_group = '4', id_category_default = '19', id_argoment_default = '22', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22450' 23/04/2024 03:25:31 pm >> DELETE FROM ps_specific_price WHERE id_product = '22450' 23/04/2024 03:26:08 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801069136' AND id_product != '22450' AND ean13 != '' 23/04/2024 03:26:08 pm >> UPDATE ps_product SET id_supplier = '', reference = '2/4', ean13 = '9788801069136', date_upd = NOW() WHERE id_product = '22450' 23/04/2024 03:26:08 pm >> UPDATE ps_product_lang SET name = 'DIO E\' SEMPRE CON NOI', description = '' WHERE id_product = '22450' 23/04/2024 03:26:08 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '1.9' WHERE id_product = '22450' 23/04/2024 03:26:08 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '1.9', id_tax_rules_group = '4', id_category_default = '19', id_argoment_default = '22', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22450' 23/04/2024 03:26:08 pm >> DELETE FROM ps_specific_price WHERE id_product = '22450' 23/04/2024 03:26:09 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 = '22450' 23/04/2024 03:26:09 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22451' , '1' , '' , 'nuovo-prodotto' ) 23/04/2024 03:26:09 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 '22451' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22450' 23/04/2024 03:26:09 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22451' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22450' 23/04/2024 03:26:43 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788867570898' AND id_product != '22451' AND ean13 != '' 23/04/2024 03:26:43 pm >> UPDATE ps_product SET id_supplier = '', reference = '5/4', ean13 = '9788867570898', date_upd = NOW() WHERE id_product = '22451' 23/04/2024 03:26:43 pm >> UPDATE ps_product_lang SET name = 'STORIA DI SANTA CHIARA', description = '' WHERE id_product = '22451' 23/04/2024 03:26:43 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '1.9' WHERE id_product = '22451' 23/04/2024 03:26:43 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '1.9', id_tax_rules_group = '4', id_category_default = '51', 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 = '22451' 23/04/2024 03:26:43 pm >> DELETE FROM ps_specific_price WHERE id_product = '22451' 23/04/2024 03:26:44 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22451' 23/04/2024 03:26:44 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22452' , '1' , '' , 'nuovo-prodotto' ) 23/04/2024 03:26:44 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22452' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22451' 23/04/2024 03:26:44 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22452' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22451' 23/04/2024 03:27:46 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788867570614' AND id_product != '22452' AND ean13 != '' 23/04/2024 03:27:46 pm >> UPDATE ps_product SET id_supplier = '', reference = '5/4', ean13 = '9788867570614', date_upd = NOW() WHERE id_product = '22452' 23/04/2024 03:27:46 pm >> UPDATE ps_product_lang SET name = 'STORIA DI SANTA RITA DA CASCIA', description = '' WHERE id_product = '22452' 23/04/2024 03:27:47 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '1.9' WHERE id_product = '22452' 23/04/2024 03:27:47 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '1.9', id_tax_rules_group = '4', id_category_default = '51', 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 = '22452' 23/04/2024 03:27:47 pm >> DELETE FROM ps_specific_price WHERE id_product = '22452' 23/04/2024 03:27:47 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 = '22452' 23/04/2024 03:27:47 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22453' , '1' , '' , 'nuovo-prodotto' ) 23/04/2024 03:27:47 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 '22453' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22452' 23/04/2024 03:27:47 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22453' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22452' 23/04/2024 03:28:41 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788867570560' AND id_product != '22453' AND ean13 != '' 23/04/2024 03:28:41 pm >> UPDATE ps_product SET id_supplier = '', reference = '5/4', ean13 = '9788867570560', date_upd = NOW() WHERE id_product = '22453' 23/04/2024 03:28:41 pm >> UPDATE ps_product_lang SET name = 'STORIA DI SAN GIOVANNI BOSCO', description = '' WHERE id_product = '22453' 23/04/2024 03:28:41 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '1.9' WHERE id_product = '22453' 23/04/2024 03:28:41 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '1.9', id_tax_rules_group = '4', id_category_default = '51', 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 = '22453' 23/04/2024 03:28:41 pm >> DELETE FROM ps_specific_price WHERE id_product = '22453' 23/04/2024 03:28: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 = '22453' 23/04/2024 03:28:41 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22454' , '1' , '' , 'nuovo-prodotto' ) 23/04/2024 03:28: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 '22454' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22453' 23/04/2024 03:28:41 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22454' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22453' 23/04/2024 03:30:01 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '662794' , '2024-04-22' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '3.77' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '132.92' , '132.92' , NOW() , NOW() ) 23/04/2024 03:30:01 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91397' 23/04/2024 03:30:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '91397' 23/04/2024 03:30:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91397' , '22450' , 'DIO E SEMPRE CON NOI' , '3' , '3' , '4' , '1.90' , '1.9' , '0' , '35' , '3.7050' ) 23/04/2024 03:30:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22450' AND id_supplier = '7' 23/04/2024 03:30:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22450' , '7' , '1' ) 23/04/2024 03:30:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91397' , '22310' , 'VIA VAI ORATORIO ESTIVO' , '1' , '1' , '4' , '18.00' , '18' , '0' , '30' , '12.6000' ) 23/04/2024 03:30:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22310' AND id_supplier = '7' 23/04/2024 03:30:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22310' , '7' , '1' ) 23/04/2024 03:30:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91397' , '22451' , 'STORIA DI SANTA CHIARA' , '3' , '3' , '4' , '1.90' , '1.9' , '0' , '30' , '3.9900' ) 23/04/2024 03:30:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22451' AND id_supplier = '7' 23/04/2024 03:30:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22451' , '7' , '1' ) 23/04/2024 03:30:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91397' , '12258' , 'STORIA DI SAN DOMENICO SAVIO' , '3' , '3' , '4' , '1.90' , '1.9' , '0' , '30' , '3.9900' ) 23/04/2024 03:30:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12258' AND id_supplier = '7' 23/04/2024 03:30:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12258' , '7' , '1' ) 23/04/2024 03:30:02 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 ( '91397' , '10288' , 'STORIA DI MARIA' , '2' , '2' , '4' , '1.90' , '1.9' , '0' , '30' , '2.6600' ) 23/04/2024 03:30:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '10288' AND id_supplier = '7' 23/04/2024 03:30:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10288' , '7' , '1' ) 23/04/2024 03:30:02 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 ( '91397' , '22452' , 'STORIA DI SANTA RITA DA CASCIA' , '2' , '2' , '4' , '1.90' , '1.9' , '0' , '30' , '2.6600' ) 23/04/2024 03:30:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22452' AND id_supplier = '7' 23/04/2024 03:30:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22452' , '7' , '1' ) 23/04/2024 03:30:02 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 ( '91397' , '22453' , 'STORIA DI SAN GIOVANNI BOSCO' , '2' , '2' , '4' , '1.90' , '1.9' , '0' , '30' , '2.6600' ) 23/04/2024 03:30:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22453' AND id_supplier = '7' 23/04/2024 03:30:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22453' , '7' , '1' ) 23/04/2024 03:30:02 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 ( '91397' , '22181' , 'MESSALINO QUOTIDIANO - MAG/GIU/LUG 2024' , '7' , '7' , '4' , '6.00' , '6' , '0' , '30' , '29.4000' ) 23/04/2024 03:30:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22181' AND id_supplier = '7' 23/04/2024 03:30:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22181' , '7' , '1' ) 23/04/2024 03:30:02 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 ( '91397' , '20655' , 'ARTE DELLA BUONA BATTAGLIA - F. ROSINI' , '1' , '1' , '4' , '18.00' , '18' , '0' , '33' , '12.0600' ) 23/04/2024 03:30:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20655' AND id_supplier = '7' 23/04/2024 03:30:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20655' , '7' , '1' ) 23/04/2024 03:30:02 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 ( '91397' , '16884' , 'ARTE DI GUARIRE - F. ROSINI' , '1' , '1' , '4' , '18.00' , '18' , '0' , '33' , '12.0600' ) 23/04/2024 03:30:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16884' AND id_supplier = '7' 23/04/2024 03:30:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16884' , '7' , '1' ) 23/04/2024 03:30:02 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 ( '91397' , '13432' , 'ARTE DI RICOMINCIARE - F. ROSINI' , '1' , '1' , '4' , '18.00' , '18' , '0' , '33' , '12.0600' ) 23/04/2024 03:30:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13432' AND id_supplier = '7' 23/04/2024 03:30:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13432' , '7' , '1' ) 23/04/2024 03:30:02 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 ( '91397' , '22131' , 'SAN FRANCESCO DI PAOLA - A. DE LORENZI' , '1' , '1' , '4' , '16.00' , '16' , '0' , '30' , '11.2000' ) 23/04/2024 03:30:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22131' AND id_supplier = '7' 23/04/2024 03:30:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22131' , '7' , '1' ) 23/04/2024 03:30:02 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 ( '91397' , '21023' , 'SALVE REGINA - G. SACINO' , '5' , '5' , '4' , '6.00' , '6' , '0' , '33' , '20.1000' ) 23/04/2024 03:30:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21023' AND id_supplier = '7' 23/04/2024 03:30:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21023' , '7' , '1' ) 23/04/2024 04:06:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '1256' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-23') 23/04/2024 04:06:04 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1256' , '2024-04-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.00' , '19.00' , NOW() , NOW() ) 23/04/2024 04:06:04 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91398' 23/04/2024 04:06:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '91398' 23/04/2024 04:06:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91398' , '22341' , 'SULLA TUA PAROLA - MAG/GIU 2024' , '4' , '-4' , '4' , '5.00' , '5' , '0' , '5' , '19.00' ) 23/04/2024 04:20:50 pm >> SELECT document_num FROM ps_document WHERE document_num = '1257' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-23') 23/04/2024 04:20:50 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1257' , '2024-04-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '319.00' , '270.84' , NOW() , NOW() ) 23/04/2024 04:20:50 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91399' 23/04/2024 04:20:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '91399' 23/04/2024 04:20:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91399' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '60' , '-60' , '1' , '3' , '2.4590163934426' , '22' , '0' , '180.00' ) 23/04/2024 04:20:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91399' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '2' , '-2' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '26.00' ) 23/04/2024 04:20:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91399' , '19107' , 'INCENSO GRANI 3A - BUSTA' , '1' , '-1' , '1' , '30.00' , '24.590163934426' , '22' , '0' , '30.00' ) 23/04/2024 04:20:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91399' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '12' , '-12' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '42.00' ) 23/04/2024 04:20:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91399' , '7311' , 'OSTIA SOTTILE 74MM' , '12' , '-12' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '24.00' ) 23/04/2024 04:20:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91399' , '13639' , 'VASETTO OLIO CON CUSTODIA' , '1' , '-1' , '1' , '17.00' , '13.934426229508' , '22' , '0' , '17.00' ) 23/04/2024 04:33:03 pm >> SELECT document_num FROM ps_document WHERE document_num = '1258' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-23') 23/04/2024 04:33:03 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' , '1258' , '2024-04-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.00' , '7.38' , NOW() , NOW() ) 23/04/2024 04:33:03 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 = '91400' 23/04/2024 04:33:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '91400' 23/04/2024 04:33:03 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 ( '91400' , '18134' , 'CROCE SAN BENEDETTO CM 7 - CSB3' , '2' , '-2' , '1' , '4.50' , '3.6885245901639' , '22' , '0' , '9.00' ) 23/04/2024 04:44:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '1259' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-23') 23/04/2024 04:44:39 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1259' , '2024-04-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '140.00' , '114.75' , NOW() , NOW() ) 23/04/2024 04:44:39 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91401' 23/04/2024 04:44:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '91401' 23/04/2024 04:44:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91401' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '140' , '114.75409836066' , '22' , '0' , '140.00' ) 23/04/2024 05:14:40 pm >> SELECT document_num FROM ps_document WHERE document_num = '1260' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-23') 23/04/2024 05:14:40 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' , '1260' , '2024-04-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '185.00' , '157.43' , NOW() , NOW() ) 23/04/2024 05:14:40 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 = '91402' 23/04/2024 05:14:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '91402' 23/04/2024 05:14:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91402' , '9205' , 'S. ANTONIO BABY 023 SAT/9 BB' , '1' , '-1' , '1' , '9.00' , '7.3770491803279' , '22' , '0' , '9.00' ) 23/04/2024 05:14:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91402' , '18557' , 'MADRE TERESA BABY - 023 MT/ 9 BB' , '1' , '-1' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '12.00' ) 23/04/2024 05:14:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91402' , '19733' , 'S. GIUDA TADDEO BABY - 023SDT9' , '1' , '-1' , '1' , '9.00' , '7.3770491803279' , '22' , '0' , '9.00' ) 23/04/2024 05:14:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91402' , '18555' , 'BUON PASTORE BABY - 023 BP/9 BB' , '2' , '-2' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '24.00' ) 23/04/2024 05:14:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91402' , '9464' , 'S. GIUSEPPE BABY - SJ/9BB' , '1' , '-1' , '1' , '9.00' , '7.3770491803279' , '22' , '0' , '9.00' ) 23/04/2024 05:14:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91402' , '22341' , 'SULLA TUA PAROLA - MAG/GIU 2024' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 23/04/2024 05:14:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91402' , '22167' , 'AMEN - MAG. 2024' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 23/04/2024 05:14:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91402' , '22168' , 'AMEN - GIU. 2024' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 23/04/2024 05:14:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91402' , '15995' , 'CATE CARD - GIOCO' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 23/04/2024 05:14:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91402' , '22218' , 'PISSIDE MINI - 896' , '1' , '-1' , '1' , '78.48' , '64.327868852459' , '22' , '0' , '78.48' ) 23/04/2024 05:14:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91402' , '1290' , 'BRACCIALE 7 DONI - 820/07' , '3' , '-3' , '1' , '3.80' , '3.1147540983607' , '22' , '0' , '11.40' ) 23/04/2024 05:14:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91402' , '6417' , 'MESE DI MAGGIO CON LE GLORIE DI MARIA - 8463' , '1' , '-1' , '4' , '9.00' , '9' , '0' , '5' , '8.55' ) 23/04/2024 05:21:13 pm >> SELECT document_num FROM ps_document WHERE document_num = '1261' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-23') 23/04/2024 05:21:13 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1261' , '2024-04-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.40' , '6.89' , NOW() , NOW() ) 23/04/2024 05:21:13 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91403' 23/04/2024 05:21:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '91403' 23/04/2024 05:21:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91403' , '13562' , 'CORONCINA IN STOFFA CON ROSE E FOGLIOLINE - 3311' , '1' , '-1' , '1' , '6.00' , '4.9180327868852' , '22' , '0' , '6.00' ) 23/04/2024 05:21:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91403' , '20516' , 'CROCE COMUNIONE - 42/08' , '2' , '-2' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '2.40' ) 23/04/2024 05:25:51 pm >> SELECT document_num FROM ps_document WHERE document_num = '77' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-04-23') 23/04/2024 05:25: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 ( '21' , '77' , '2024-04-23' , '' , '2755' , '0' , '4677545' , 'VIA PRINCIPE DI PIEMONTE 04026 MINTURNO' , '' , '' , '5' , '4' , '0' , '0' , '0' , '' , '7' , '0' , '33.50' , '33.50' , NOW() , NOW() ) 23/04/2024 05:25:51 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91404' 23/04/2024 05:25:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '91404' 23/04/2024 05:25:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91404' , '21023' , 'SALVE REGINA - G. SACINO' , '5' , '-5' , '4' , '6.00' , '6' , '0' , '5' , '28.50' ) 23/04/2024 05:55:01 pm >> SELECT document_num FROM ps_document WHERE document_num = '1262' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-23') 23/04/2024 05:55:01 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1262' , '2024-04-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '55.00' , '45.08' , NOW() , NOW() ) 23/04/2024 05:55:01 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91405' 23/04/2024 05:55:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '91405' 23/04/2024 05:55:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91405' , '16461' , 'CLERGY NIDO D\'APE ML - C 22' , '1' , '-1' , '1' , '55' , '45.081967213115' , '22' , '0' , '55.00' ) 23/04/2024 06:21:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '78' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-04-23') 23/04/2024 06:21:39 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '78' , '2024-04-23' , '' , '3931' , '0' , '4677720' , 'VIALE DELLA LIBERA 11 80079 PROCIDA' , '' , '' , '13' , '4' , '0' , '0' , '0' , '' , '7' , '0' , '286.71' , '286.71' , NOW() , NOW() ) 23/04/2024 06:21:39 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91406' 23/04/2024 06:21:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '91406' 23/04/2024 06:21:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91406' , '15317' , 'SACRAMENTI SPIEGATI AI RAGAZZI - LA COMUNIONE' , '15' , '-15' , '4' , '1.80' , '1.8' , '0' , '15' , '22.95' ) 23/04/2024 06:21:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91406' , '19977' , 'MINISTRANTI IERI, OGGI, DOMANI' , '10' , '-10' , '4' , '2.50' , '2.5' , '0' , '15' , '21.25' ) 23/04/2024 06:21:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91406' , '17163' , 'SPIRITO SANTO SPIEGATO AI RAGAZZI' , '15' , '-15' , '4' , '2.50' , '2.5' , '0' , '15' , '31.88' ) 23/04/2024 06:21:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91406' , '16065' , 'DIZIONARIO DEI SIMBOLI DEL CRISTIANO' , '15' , '-15' , '4' , '2.50' , '2.5' , '0' , '15' , '31.88' ) 23/04/2024 06:21:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91406' , '4120' , 'FEDE NELLO ZAINETTO' , '10' , '-10' , '4' , '6.00' , '6' , '0' , '15' , '51.00' ) 23/04/2024 06:21:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91406' , '12842' , 'RICEVI IL SIGILLO DELLO SPIRITO SANTO' , '10' , '-10' , '4' , '6.00' , '6' , '0' , '15' , '51.00' ) 23/04/2024 06:21:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91406' , '11097' , 'VANGELO E ATTI DEGLI APOSTOLI' , '15' , '-15' , '4' , '5.00' , '5' , '0' , '15' , '63.75' ) 23/04/2024 06:36:53 pm >> SELECT document_num FROM ps_document WHERE document_num = '1263' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-23') 23/04/2024 06:36:53 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' , '1263' , '2024-04-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 23/04/2024 06:36:53 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 = '91407' 23/04/2024 06:36:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '91407' 23/04/2024 06:36:53 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 ( '91407' , '22341' , 'SULLA TUA PAROLA - MAG/GIU 2024' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 23/04/2024 07:32:01 pm >> SELECT document_num FROM ps_document WHERE document_num = '1264' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-23') 23/04/2024 07:32:01 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1264' , '2024-04-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '280.00' , '229.51' , NOW() , NOW() ) 23/04/2024 07:32:01 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91408' 23/04/2024 07:32:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '91408' 23/04/2024 07:32:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91408' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '280' , '229.50819672131' , '22' , '0' , '280.00' ) 23/04/2024 07:58:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '1265' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-23') 23/04/2024 07:58:09 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' , '1265' , '2024-04-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.80' , '3.11' , NOW() , NOW() ) 23/04/2024 07:58:09 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 = '91409' 23/04/2024 07:58:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '91409' 23/04/2024 07:58:09 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 ( '91409' , '13845' , 'COLLANINA IN ACCIAIO ANGELO - 1984/A48' , '1' , '-1' , '1' , '3.80' , '3.1147540983607' , '22' , '0' , '3.80' )