04/03/2026 08:10:08 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 (
'32' ,
'6026206605' ,
'2026-02-28' ,
'' ,
'0' ,
'109' ,
'4669106' ,
'VIA G. VERDI, 8 20090 ASSAGO' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'17' ,
'0' ,
'206.86' ,
'206.86' ,
NOW() ,
NOW() )
04/03/2026 08:10:08 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 = '101592'
04/03/2026 08:10:08 am >> DELETE FROM ps_document_detail WHERE id_document = '101592'
04/03/2026 08:10:08 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
( '101592' , '24538' , 'BIBBIA DI GERUSALEMME - STUDIO' , '2' , '0' , '4' ,
'28.775' , '28.775' , '0' , '0' , '57.5500' )
04/03/2026 08:10:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '24538' AND id_supplier = '109'
04/03/2026 08:10:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24538' , '109' , '1' )
04/03/2026 08:10:08 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
( '101592' , '18521' , 'DIZIONARIO DI TEOLOGIA BIBLICA - DUFOUR' , '3' , '0' , '4' ,
'41.296' , '41.296' , '0' , '0' , '123.8880' )
04/03/2026 08:10:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '18521' AND id_supplier = '109'
04/03/2026 08:10:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18521' , '109' , '1' )
04/03/2026 08:10:08 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
( '101592' , '7703' , 'PASSIONE DI NOSTRO SIGNORE' , '5' , '0' , '4' ,
'5.084' , '5.084' , '0' , '0' , '25.4200' )
04/03/2026 08:10:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '7703' AND id_supplier = '109'
04/03/2026 08:10:09 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7703' , '109' , '1' )
04/03/2026 08:12:17 am >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'32' ,
'6026206607' ,
'2026-02-28' ,
'' ,
'0' ,
'109' ,
'4669106' ,
'VIA G. VERDI, 8 20090 ASSAGO' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'17' ,
'0' ,
'51.88' ,
'51.88' ,
NOW() ,
NOW() )
04/03/2026 08:12:17 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '101593'
04/03/2026 08:12:17 am >> DELETE FROM ps_document_detail WHERE id_document = '101593'
04/03/2026 08:12:17 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '101593' , '16236' , 'AD UNO A UNO - E. APPELLA' , '1' , '0' , '4' ,
'14.4' , '14.4' , '0' , '0' , '14.4000' )
04/03/2026 08:12:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '16236' AND id_supplier = '109'
04/03/2026 08:12:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16236' , '109' , '1' )
04/03/2026 08:12:17 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '101593' , '24655' , 'FILOSOFIE MEDIEVALI - G. CATAPANO' , '1' , '0' , '4' ,
'24.95' , '24.95' , '0' , '0' , '24.9500' )
04/03/2026 08:12:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '24655' AND id_supplier = '109'
04/03/2026 08:12:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24655' , '109' , '1' )
04/03/2026 08:12:17 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '101593' , '3872' , 'ENTE E LESSENZA - TOMMASO DAQUINO' , '1' , '0' , '4' ,
'7.13' , '7.13' , '0' , '0' , '7.1300' )
04/03/2026 08:12:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '3872' AND id_supplier = '109'
04/03/2026 08:12:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3872' , '109' , '1' )
04/03/2026 08:12:17 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '101593' , '24654' , 'VITA COMUNITARIA DEI CRISTIANI - D. BONHOEFFER' , '1' , '0' , '4' ,
'5.4' , '5.4' , '0' , '0' , '5.4000' )
04/03/2026 08:12:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '24654' AND id_supplier = '109'
04/03/2026 08:12:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24654' , '109' , '1' )
04/03/2026 08:13:19 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 (
'32' ,
'6026206604' ,
'2026-02-28' ,
'' ,
'0' ,
'109' ,
'4669106' ,
'VIA G. VERDI, 8 20090 ASSAGO' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'17' ,
'0' ,
'6.04' ,
'6.04' ,
NOW() ,
NOW() )
04/03/2026 08:13:19 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 = '101594'
04/03/2026 08:13:19 am >> DELETE FROM ps_document_detail WHERE id_document = '101594'
04/03/2026 08:13:19 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
( '101594' , '24331' , 'DIO RICALCOLA IL PERCORSO - CURTAZ/RONCHI' , '1' , '0' , '4' ,
'6.04' , '6.04' , '0' , '0' , '6.0400' )
04/03/2026 08:13:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '24331' AND id_supplier = '109'
04/03/2026 08:13:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24331' , '109' , '1' )
04/03/2026 08:14:37 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 (
'32' ,
'6026206606' ,
'2026-02-28' ,
'' ,
'0' ,
'109' ,
'4669106' ,
'VIA G. VERDI, 8 20090 ASSAGO' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'17' ,
'0' ,
'42.02' ,
'42.02' ,
NOW() ,
NOW() )
04/03/2026 08:14:37 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '101595'
04/03/2026 08:14:37 am >> DELETE FROM ps_document_detail WHERE id_document = '101595'
04/03/2026 08:14:37 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '101595' , '22189' , 'VIA CRUCIS VIA DI SPERANZA - R. LUPI' , '2' , '0' , '4' ,
'2.74' , '2.74' , '0' , '0' , '5.4800' )
04/03/2026 08:14:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '22189' AND id_supplier = '109'
04/03/2026 08:14:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22189' , '109' , '1' )
04/03/2026 08:14:38 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
( '101595' , '17864' , 'MESSALE QUOTIDIANO GRANDE - N. E. ' , '1' , '0' , '4' ,
'36.54' , '36.54' , '0' , '0' , '36.5400' )
04/03/2026 08:14:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '17864' AND id_supplier = '109'
04/03/2026 08:14:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17864' , '109' , '1' )
04/03/2026 08:16:44 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() )
04/03/2026 08:16:44 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24663' , '1' , '' , 'nuovo-prodotto' )
04/03/2026 08:16:44 am >> INSERT INTO ps_product_shop (
id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd`
) VALUES (
'24663' , '1' , '1' , '2' , NOW() , NOW()
)
04/03/2026 08:16:44 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '24663' , '0' , '1' , '0' , '0' )
04/03/2026 08:17:15 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8027846423802' AND id_product != '24663' AND ean13 != ''
04/03/2026 08:17:15 am >> UPDATE ps_product SET
id_supplier = '',
reference = '',
ean13 = '8027846423802',
date_upd = NOW()
WHERE id_product = '24663'
04/03/2026 08:17:15 am >> UPDATE ps_product_lang SET
name = 'CROCE FRASSINO ',
description = ''
WHERE id_product = '24663'
04/03/2026 08:17:15 am >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '0.0000'
WHERE id_product = '24663'
04/03/2026 08:17:15 am >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '0.0000',
id_tax_rules_group = '1',
id_category_default = '151',
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 = '24663'
04/03/2026 08:17:15 am >> DELETE FROM ps_specific_price WHERE id_product = '24663'
04/03/2026 08:17: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 = '24663'
04/03/2026 08:17:16 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24664' , '1' , '' , 'nuovo-prodotto' )
04/03/2026 08:17: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 '24664' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '24663'
04/03/2026 08:17:16 am >> INSERT INTO `ps_stock_available` (
id_product , id_product_attribute , id_shop , id_shop_group , quantity
) SELECT '24664' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '24663'
04/03/2026 08:22:40 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' ,
'59/O' ,
'2026-02-26' ,
'O' ,
'0' ,
'43' ,
'2638' ,
'VIA COSTABIANCA, 43 60025 LORETO' ,
'' ,
'' ,
'18' ,
'1' ,
'0' ,
'0' ,
'0' ,
'' ,
'9' ,
'0' ,
'808.87' ,
'663.01' ,
NOW() ,
NOW() )
04/03/2026 08:22:40 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 = '101596'
04/03/2026 08:22:40 am >> DELETE FROM ps_document_detail WHERE id_document = '101596'
04/03/2026 08:22:40 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
( '101596' , '24663' , 'CROCE FRASSINO ' , '1' , '1' , '1' ,
'321.98' , '263.91803278689' , '22' , '0' , '392.8156' )
04/03/2026 08:22:40 am >> DELETE FROM ps_product_supplier WHERE id_product = '24663' AND id_supplier = '43'
04/03/2026 08:22:40 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24663' , '43' , '1' )
04/03/2026 08:22:40 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
( '101596' , '24609' , 'MEDAGLIA S. MICHELE ARG - RA850' , '1' , '1' , '1' ,
'10.46' , '8.5737704918033' , '22' , '0' , '12.7612' )
04/03/2026 08:22:40 am >> DELETE FROM ps_product_supplier WHERE id_product = '24609' AND id_supplier = '43'
04/03/2026 08:22:40 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24609' , '43' , '1' )
04/03/2026 08:22:40 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
( '101596' , '20964' , 'STATUA SAN MICHELE - ST322-SM' , '1' , '1' , '1' ,
'5.57' , '4.5655737704918' , '22' , '0' , '6.7954' )
04/03/2026 08:22:40 am >> DELETE FROM ps_product_supplier WHERE id_product = '20964' AND id_supplier = '43'
04/03/2026 08:22:40 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20964' , '43' , '1' )
04/03/2026 08:22:40 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
( '101596' , '24610' , 'CROCE CM 68 - CL254' , '1' , '1' , '1' ,
'143.75' , '117.82786885246' , '22' , '0' , '175.3750' )
04/03/2026 08:22:40 am >> DELETE FROM ps_product_supplier WHERE id_product = '24610' AND id_supplier = '43'
04/03/2026 08:22:40 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24610' , '43' , '1' )
04/03/2026 08:22:40 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
( '101596' , '24608' , 'CROCE SAN BENEDETTO - CM 25 - PG647' , '1' , '1' , '1' ,
'18.74' , '15.360655737705' , '22' , '0' , '22.8628' )
04/03/2026 08:22:40 am >> DELETE FROM ps_product_supplier WHERE id_product = '24608' AND id_supplier = '43'
04/03/2026 08:22:40 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24608' , '43' , '1' )
04/03/2026 08:22:40 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
( '101596' , '24089' , 'ICONA GRECA SERIGRAFATA 14X11 - K094.A' , '1' , '1' , '1' ,
'10.69' , '8.7622950819672' , '22' , '0' , '13.0418' )
04/03/2026 08:22:40 am >> DELETE FROM ps_product_supplier WHERE id_product = '24089' AND id_supplier = '43'
04/03/2026 08:22:40 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24089' , '43' , '1' )
04/03/2026 08:22:40 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
( '101596' , '20970' , 'CROCE LEGNO S. BENEDETTO - PG681' , '1' , '1' , '1' ,
'14.85' , '12.172131147541' , '22' , '0' , '18.1170' )
04/03/2026 08:22:40 am >> DELETE FROM ps_product_supplier WHERE id_product = '20970' AND id_supplier = '43'
04/03/2026 08:22:40 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20970' , '43' , '1' )
04/03/2026 08:22:40 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
( '101596' , '20965' , 'STATUA SAN MICHELE - ST332-SM' , '1' , '1' , '1' ,
'7.88' , '6.4590163934426' , '22' , '0' , '9.6136' )
04/03/2026 08:22:40 am >> DELETE FROM ps_product_supplier WHERE id_product = '20965' AND id_supplier = '43'
04/03/2026 08:22:40 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20965' , '43' , '1' )
04/03/2026 08:22:40 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
( '101596' , '9886' , 'SERIE VIA CRUCIS LEGNO 15PZ - CM 20,5X13,5 - 933' , '1' , '1' , '1' ,
'111.09' , '91.05737704918' , '22' , '0' , '135.5298' )
04/03/2026 08:22:40 am >> DELETE FROM ps_product_supplier WHERE id_product = '9886' AND id_supplier = '43'
04/03/2026 08:22:40 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9886' , '43' , '1' )
04/03/2026 09:04:44 am >> SELECT document_num FROM ps_document
WHERE document_num = '664' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-03-04')
04/03/2026 09:04:44 am >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'664' ,
'2026-03-04' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'1' ,
'0' ,
'4.00' ,
'3.28' ,
NOW() ,
NOW() )
04/03/2026 09:04:44 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '101597'
04/03/2026 09:04:44 am >> DELETE FROM ps_document_detail WHERE id_document = '101597'
04/03/2026 09:04:44 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '101597' , '24619' , 'CONFEZIONE TAU CON CARTONCINO - 1242' , '1' , '-1' , '1' ,
'4.00' , '3.2786885245902' , '22' , '0' , '4.00' )
04/03/2026 09:32:59 am >> SELECT document_num FROM ps_document
WHERE document_num = '7' AND id_document != '' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2026-02-24')
04/03/2026 09:32:59 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 (
'24' ,
'7' ,
'2026-02-24' ,
'' ,
'0' ,
'43' ,
'2638' ,
'VIA COSTABIANCA, 43 60025 LORETO' ,
'' ,
'RESO A FORNITORE - ' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'17' ,
'0' ,
'0.00' ,
'0.00' ,
NOW() ,
NOW() )
04/03/2026 09:32:59 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 = '101598'
04/03/2026 09:32:59 am >> DELETE FROM ps_document_detail WHERE id_document = '101598'
04/03/2026 09:32:59 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
( '101598' , '24663' , 'CROCE FRASSINO ' , '1' , '-1' , '1' ,
'0.00' , '0' , '22' , '0' , '0.00' )
04/03/2026 09:32:59 am >> DELETE FROM ps_product_supplier WHERE id_product = '24663' AND id_supplier = '43'
04/03/2026 09:32:59 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24663' , '43' , '1' )
04/03/2026 09:40:19 am >> SELECT document_num FROM ps_document
WHERE document_num = '665' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-03-04')
04/03/2026 09:40:19 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' ,
'665' ,
'2026-03-04' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'1' ,
'0' ,
'90.00' ,
'73.77' ,
NOW() ,
NOW() )
04/03/2026 09:40:19 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 = '101599'
04/03/2026 09:40:19 am >> DELETE FROM ps_document_detail WHERE id_document = '101599'
04/03/2026 09:40:19 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
( '101599' , '13627' , 'PARACERA 167/S' , '1' , '-1' , '1' ,
'75.00' , '61.475409836066' , '22' , '0' , '75.00' )
04/03/2026 09:40:19 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
( '101599' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' ,
'15' , '12.295081967213' , '22' , '0' , '15.00' )
04/03/2026 09:51:14 am >> SELECT document_num FROM ps_document
WHERE document_num = '666' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-03-04')
04/03/2026 09:51:14 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' ,
'666' ,
'2026-03-04' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'1' ,
'0' ,
'16.00' ,
'13.11' ,
NOW() ,
NOW() )
04/03/2026 09:51:14 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 = '101600'
04/03/2026 09:51:14 am >> DELETE FROM ps_document_detail WHERE id_document = '101600'
04/03/2026 09:51:14 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
( '101600' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' ,
'16' , '13.114754098361' , '22' , '0' , '16.00' )
04/03/2026 09:56:27 am >> SELECT document_num FROM ps_document
WHERE document_num = '667' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-03-04')
04/03/2026 09:56:27 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' ,
'667' ,
'2026-03-04' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'1' ,
'0' ,
'79.70' ,
'68.63' ,
NOW() ,
NOW() )
04/03/2026 09:56:27 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 = '101601'
04/03/2026 09:56:27 am >> DELETE FROM ps_document_detail WHERE id_document = '101601'
04/03/2026 09:56:27 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
( '101601' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '4' , '-4' , '3' ,
'3.70' , '3.5576923076923' , '4' , '0' , '14.80' )
04/03/2026 09:56:27 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
( '101601' , '20429' , 'OSTIA SENZA TOSTATURA MORREALE - OS25' , '2' , '-2' , '3' ,
'2.00' , '1.9230769230769' , '4' , '0' , '4.00' )
04/03/2026 09:56:27 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
( '101601' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' ,
'4.50' , '4.3269230769231' , '4' , '0' , '4.50' )
04/03/2026 09:56:27 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
( '101601' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' ,
'4.7' , '3.8524590163934' , '22' , '0' , '56.40' )
04/03/2026 10:03:37 am >> SELECT document_num FROM ps_document
WHERE document_num = '668' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-03-04')
04/03/2026 10:03:37 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' ,
'668' ,
'2026-03-04' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'1' ,
'0' ,
'60.00' ,
'49.18' ,
NOW() ,
NOW() )
04/03/2026 10:03:37 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '101602'
04/03/2026 10:03:37 am >> DELETE FROM ps_document_detail WHERE id_document = '101602'
04/03/2026 10:03:37 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '101602' , '21786' , 'MADONNA DEL CARMINE CM 30 - 621' , '1' , '-1' , '1' ,
'60.00' , '49.180327868852' , '22' , '0' , '60.00' )
04/03/2026 10:24:17 am >> SELECT document_num FROM ps_document
WHERE document_num = '669' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-03-04')
04/03/2026 10:24:17 am >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'669' ,
'2026-03-04' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'15' ,
'0' ,
'9.50' ,
'9.50' ,
NOW() ,
NOW() )
04/03/2026 10:24:17 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '101603'
04/03/2026 10:24:17 am >> DELETE FROM ps_document_detail WHERE id_document = '101603'
04/03/2026 10:24:17 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '101603' , '24623' , 'SULLA TUA PAROLA - MAG/GIU 2026' , '1' , '-1' , '4' ,
'5.00' , '5' , '0' , '5' , '4.75' )
04/03/2026 10:24:17 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '101603' , '24467' , 'SULLA TUA PAROLA - MAR/APR 2026' , '1' , '-1' , '4' ,
'5.00' , '5' , '0' , '5' , '4.75' )
04/03/2026 10:33:50 am >> SELECT document_num FROM ps_document
WHERE document_num = '670' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-03-04')
04/03/2026 10:33:50 am >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'670' ,
'2026-03-04' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'1' ,
'0' ,
'91.60' ,
'84.66' ,
NOW() ,
NOW() )
04/03/2026 10:33:50 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '101604'
04/03/2026 10:33:50 am >> DELETE FROM ps_document_detail WHERE id_document = '101604'
04/03/2026 10:33:50 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '101604' , '11151' , 'LIBRI' , '2' , '-2' , '4' ,
'10' , '10' , '0' , '0' , '20.00' )
04/03/2026 10:33:50 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '101604' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '8' , '-8' , '3' ,
'3.70' , '3.5576923076923' , '4' , '0' , '29.60' )
04/03/2026 10:33:50 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '101604' , '16689' , 'OSTIA PAN DI CENA mm80' , '4' , '-4' , '3' ,
'2.00' , '1.9230769230769' , '4' , '0' , '8.00' )
04/03/2026 10:33:50 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '101604' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' ,
'4.50' , '4.3269230769231' , '4' , '0' , '4.50' )
04/03/2026 10:33:50 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '101604' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' ,
'15' , '12.295081967213' , '22' , '0' , '15.00' )
04/03/2026 10:33:50 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '101604' , '1751' , 'CARTUCCIA TRASPARENTE DIAM. 4 - 455' , '1' , '-1' , '1' ,
'14.50' , '11.885245901639' , '22' , '0' , '14.50' )
04/03/2026 10:46:00 am >> SELECT document_num FROM ps_document
WHERE document_num = '671' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-03-04')
04/03/2026 10:46:00 am >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'671' ,
'2026-03-04' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'15' ,
'0' ,
'300.00' ,
'245.90' ,
NOW() ,
NOW() )
04/03/2026 10:46:00 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '101605'
04/03/2026 10:46:00 am >> DELETE FROM ps_document_detail WHERE id_document = '101605'
04/03/2026 10:46:00 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '101605' , '24526' , 'MENSA API 80X300 - M80300A' , '2' , '-2' , '1' ,
'32' , '26.229508196721' , '22' , '0' , '64.00' )
04/03/2026 10:46:00 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '101605' , '24526' , 'MENSA API 80X300 - M80300A' , '4' , '-4' , '1' ,
'18' , '14.754098360656' , '22' , '0' , '72.00' )
04/03/2026 10:46:00 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '101605' , '15210' , 'CERO PASQUALE API 80X120' , '1' , '-1' , '1' ,
'164' , '134.4262295082' , '22' , '0' , '164.00' )
04/03/2026 11:09:44 am >> SELECT ean13 FROM ps_product WHERE ean13 = '671MS' AND id_product != '24664' AND ean13 != ''
04/03/2026 11:09:45 am >> UPDATE ps_product SET
id_supplier = '',
reference = '',
ean13 = '671MS',
date_upd = NOW()
WHERE id_product = '24664'
04/03/2026 11:09:45 am >> UPDATE ps_product_lang SET
name = 'CASULA MARIANA - 671MS',
description = ''
WHERE id_product = '24664'
04/03/2026 11:09:45 am >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '0.0000'
WHERE id_product = '24664'
04/03/2026 11:09:45 am >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '0.0000',
id_tax_rules_group = '1',
id_category_default = '432',
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 = '24664'
04/03/2026 11:09:45 am >> DELETE FROM ps_specific_price WHERE id_product = '24664'
04/03/2026 11:09:50 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 = '24664'
04/03/2026 11:09:50 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24665' , '1' , '' , 'nuovo-prodotto' )
04/03/2026 11:09:50 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 '24665' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '24664'
04/03/2026 11:09:50 am >> INSERT INTO `ps_stock_available` (
id_product , id_product_attribute , id_shop , id_shop_group , quantity
) SELECT '24665' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '24664'
04/03/2026 11:10:59 am >> SELECT ean13 FROM ps_product WHERE ean13 = '31TAU' AND id_product != '24665' AND ean13 != ''
04/03/2026 11:10:59 am >> UPDATE ps_product SET
id_supplier = '',
reference = '',
ean13 = '31TAU',
date_upd = NOW()
WHERE id_product = '24665'
04/03/2026 11:10:59 am >> UPDATE ps_product_lang SET
name = 'STOLA TAU - 31 TAU',
description = ''
WHERE id_product = '24665'
04/03/2026 11:10:59 am >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '0.0000'
WHERE id_product = '24665'
04/03/2026 11:10:59 am >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '0.0000',
id_tax_rules_group = '1',
id_category_default = '432',
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 = '24665'
04/03/2026 11:10:59 am >> DELETE FROM ps_specific_price WHERE id_product = '24665'
04/03/2026 11:11: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 (
'33' ,
'164' ,
'2026-03-02' ,
'' ,
'0' ,
'118' ,
'4669176' ,
'VIALE EUROPA, 102 36075 MONTECCHIO MAGGIORE' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'17' ,
'0' ,
'0.00' ,
'0.00' ,
NOW() ,
NOW() )
04/03/2026 11:11: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 = '101606'
04/03/2026 11:11:12 am >> DELETE FROM ps_document_detail WHERE id_document = '101606'
04/03/2026 11:11: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
( '101606' , '24664' , 'CASULA MARIANA - 671MS' , '1' , '1' , '1' ,
'0.00' , '0' , '22' , '0' , '0.00' )
04/03/2026 11:11:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '24664' AND id_supplier = '118'
04/03/2026 11:11:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24664' , '118' , '1' )
04/03/2026 11:11: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
( '101606' , '14577' , 'CAMICE BENEDETTINO COCOLLE - MISTO LANA 328' , '2' , '2' , '1' ,
'0' , '0' , '22' , '0' , '0.0000' )
04/03/2026 11:11:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '14577' AND id_supplier = '118'
04/03/2026 11:11:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14577' , '118' , '1' )
04/03/2026 11:11: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
( '101606' , '14354' , 'CAMICE BENEDETTINO LINO - 3010' , '2' , '2' , '1' ,
'0' , '0' , '22' , '0' , '0.0000' )
04/03/2026 11:11:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '14354' AND id_supplier = '118'
04/03/2026 11:11:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14354' , '118' , '1' )
04/03/2026 11:11: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
( '101606' , '24665' , 'STOLA TAU - 31 TAU' , '1' , '1' , '1' ,
'0.00' , '0' , '22' , '0' , '0.00' )
04/03/2026 11:11:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '24665' AND id_supplier = '118'
04/03/2026 11:11:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24665' , '118' , '1' )
04/03/2026 11:15:23 am >> SELECT document_num FROM ps_document
WHERE document_num = '30/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2026-03-04')
04/03/2026 11:15:23 am >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'24' ,
'30/A' ,
'2026-03-04' ,
'A' ,
'204' ,
'0' ,
'4671483' ,
'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO' ,
'' ,
'CAPPELLANIA OSPEDALE CURTERI' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'17' ,
'0' ,
'95.50' ,
'79.06' ,
NOW() ,
NOW() )
04/03/2026 11:15:23 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '101607'
04/03/2026 11:15:23 am >> DELETE FROM ps_document_detail WHERE id_document = '101607'
04/03/2026 11:15:23 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '101607' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' ,
'3' , '2.4590163934426' , '22' , '0' , '90.00' )
04/03/2026 11:15:23 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '101607' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '1' , '-1' , '3' ,
'3.50' , '3.3653846153846' , '4' , '0' , '3.50' )
04/03/2026 11:15:23 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '101607' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' ,
'2.00' , '1.9230769230769' , '4' , '0' , '2.00' )
04/03/2026 11:19:08 am >> SELECT document_num FROM ps_document
WHERE document_num = '30/A' AND id_document != '101607' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2026-03-04')
04/03/2026 11:19:08 am >> UPDATE ps_document SET
id_document_type = '24',
document_num = '30/A',
document_date = '2026-03-04',
document_letter = 'A',
id_customer = '204',
id_supplier = '',
id_address = '4671483',
address1 = 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO',
address2 = '',
note = 'CAPPELLANIA OSPEDALE CURTERI',
price_shipping = '0.00',
id_tax_shipping_rules = '4',
colli = '0',
peso = '0',
porto_e_imballo = '0',
mezzo_consegna = '',
id_payment = '17',
id_causal = '0',
price_tax_included = '97.50',
price_tax_excluded = '81.06',
date_upd = NOW()
WHERE id_document = '101607'
04/03/2026 11:19:08 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 = '101607'
04/03/2026 11:19:08 am >> DELETE FROM ps_document_detail WHERE id_document = '101607'
04/03/2026 11:19:08 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
( '101607' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' ,
'3.0000' , '2.4590163934426' , '22' , '0' , '90.00' )
04/03/2026 11:19:08 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
( '101607' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '1' , '-1' , '3' ,
'3.5000' , '3.3653846153846' , '4' , '0' , '3.50' )
04/03/2026 11:19:08 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
( '101607' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' ,
'2.0000' , '1.9230769230769' , '4' , '0' , '2.00' )
04/03/2026 11:19:08 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
( '101607' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '2' , '-2' , '4' ,
'1.00' , '1' , '0' , '0' , '2.00' )
04/03/2026 11:20:22 am >> SELECT document_num FROM ps_document
WHERE document_num = '672' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-03-04')
04/03/2026 11:20:22 am >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'672' ,
'2026-03-04' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'1' ,
'0' ,
'195.00' ,
'159.84' ,
NOW() ,
NOW() )
04/03/2026 11:20:22 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '101608'
04/03/2026 11:20:22 am >> DELETE FROM ps_document_detail WHERE id_document = '101608'
04/03/2026 11:20:22 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '101608' , '19190' , 'STOLA MARIANA - 7335' , '1' , '-1' , '1' ,
'195.00' , '159.83606557377' , '22' , '0' , '195.00' )
04/03/2026 11:23:01 am >> SELECT document_num FROM ps_document
WHERE document_num = '673' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-03-04')
04/03/2026 11:23:01 am >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'673' ,
'2026-03-04' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'1' ,
'0' ,
'6.50' ,
'5.33' ,
NOW() ,
NOW() )
04/03/2026 11:23:01 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '101609'
04/03/2026 11:23:01 am >> DELETE FROM ps_document_detail WHERE id_document = '101609'
04/03/2026 11:23:01 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '101609' , '1912' , 'CERA DELL\'EREMO - 415/B ' , '1' , '-1' , '1' ,
'6.50' , '5.327868852459' , '22' , '0' , '6.50' )
04/03/2026 11:41:09 am >> SELECT document_num FROM ps_document
WHERE document_num = '674' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-03-04')
04/03/2026 11:41:09 am >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'674' ,
'2026-03-04' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'15' ,
'0' ,
'39.50' ,
'33.01' ,
NOW() ,
NOW() )
04/03/2026 11:41: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 = '101610'
04/03/2026 11:41:09 am >> DELETE FROM ps_document_detail WHERE id_document = '101610'
04/03/2026 11:41: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
( '101610' , '18223' , 'ROSARIO MISSIONARIO MM8 - R102' , '20' , '-20' , '1' ,
'1.50' , '1.2295081967213' , '22' , '0' , '30.00' )
04/03/2026 11:41: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
( '101610' , '13506' , 'SANTO ROSARIO' , '20' , '-20' , '1' ,
'0.30' , '0.24590163934426' , '22' , '0' , '6.00' )
04/03/2026 11:41: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
( '101610' , '17034' , 'SACRAMENTO DEL PERDONO' , '1' , '-1' , '4' ,
'2.00' , '2' , '0' , '0' , '2.00' )
04/03/2026 11:41: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
( '101610' , '15316' , 'COME PREPARARSI ALLA CONFESSIONE' , '1' , '-1' , '4' ,
'1.50' , '1.5' , '0' , '0' , '1.50' )
04/03/2026 11:49:57 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '2755'
04/03/2026 11:49:57 am >> INSERT INTO ps_address
( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd )
VALUES (
'2755' ,
'10' ,
'168' ,
'' ,
'ALICANDRO' ,
'FERNANDA ' ,
'VIA APPIA 1231' ,
'' ,
'04026' ,
'MINTURNO' ,
'' ,
'' ,
'3711617041' ,
'' ,
'' ,
NOW() ,
NOW() )
04/03/2026 11:49:57 am >> UPDATE ps_customer SET
email = 'fernanda.alicandro@gmail.com',
sdi = '',
pec = '',
date_upd = NOW()
WHERE id_customer = '2755'
04/03/2026 11:55:12 am >> SELECT document_num FROM ps_document
WHERE document_num = '675' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-03-04')
04/03/2026 11:55: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 (
'11' ,
'675' ,
'2026-03-04' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'1' ,
'0' ,
'1.20' ,
'0.98' ,
NOW() ,
NOW() )
04/03/2026 11:55: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 = '101611'
04/03/2026 11:55:12 am >> DELETE FROM ps_document_detail WHERE id_document = '101611'
04/03/2026 11:55: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
( '101611' , '22549' , 'ROSARIO LEGNO MM8 - R282' , '1' , '-1' , '1' ,
'1.20' , '0.98360655737705' , '22' , '0' , '1.20' )
04/03/2026 12:05:32 pm >> SELECT document_num FROM ps_document
WHERE document_num = '676' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-03-04')
04/03/2026 12:05:32 pm >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'676' ,
'2026-03-04' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'1' ,
'0' ,
'21.50' ,
'20.67' ,
NOW() ,
NOW() )
04/03/2026 12:05:32 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '101612'
04/03/2026 12:05:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '101612'
04/03/2026 12:05:32 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '101612' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '5' , '-5' , '3' ,
'3.50' , '3.3653846153846' , '4' , '0' , '17.50' )
04/03/2026 12:05:32 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '101612' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' ,
'2.00' , '1.9230769230769' , '4' , '0' , '4.00' )
04/03/2026 12:06:57 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 (
'32' ,
'453' ,
'2026-02-27' ,
'' ,
'0' ,
'47' ,
'2642' ,
'V.LE BACCHIGLIONE, 20 20139 MILANO' ,
'' ,
'' ,
'5.35' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'3' ,
'0' ,
'75.35' ,
'75.35' ,
NOW() ,
NOW() )
04/03/2026 12:06:57 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 = '101613'
04/03/2026 12:06:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '101613'
04/03/2026 12:06:57 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
( '101613' , '22432' , 'IN SINU JESU' , '4' , '0' , '4' ,
'20.0000' , '20' , '0' , '30' , '56.00' )
04/03/2026 12:06:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22432' AND id_supplier = '47'
04/03/2026 12:06:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22432' , '47' , '1' )
04/03/2026 12:06:57 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
( '101613' , '24573' , 'PADRE PIO DA PIETRELCINA - GUARINO/STANZIONE' , '1' , '0' , '4' ,
'10.0000' , '10' , '0' , '30' , '7.00' )
04/03/2026 12:06:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24573' AND id_supplier = '47'
04/03/2026 12:06:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24573' , '47' , '1' )
04/03/2026 12:06:57 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
( '101613' , '24574' , 'DON DOLINDO RUOTOLO - STANZIONE' , '1' , '0' , '4' ,
'10.0000' , '10' , '0' , '30' , '7.00' )
04/03/2026 12:06:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24574' AND id_supplier = '47'
04/03/2026 12:06:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24574' , '47' , '1' )
04/03/2026 12:17:22 pm >> SELECT document_num FROM ps_document
WHERE document_num = '677' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-03-04')
04/03/2026 12:17:22 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' ,
'677' ,
'2026-03-04' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'1' ,
'0' ,
'28.50' ,
'27.40' ,
NOW() ,
NOW() )
04/03/2026 12:17:22 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 = '101614'
04/03/2026 12:17:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '101614'
04/03/2026 12:17:22 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
( '101614' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '5' , '-5' , '3' ,
'3.70' , '3.5576923076923' , '4' , '0' , '18.50' )
04/03/2026 12:17:22 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
( '101614' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' ,
'2.00' , '1.9230769230769' , '4' , '0' , '10.00' )
04/03/2026 12:31:22 pm >> SELECT document_num FROM ps_document
WHERE document_num = '22/A' AND id_document != '101121' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2026-01-27')
04/03/2026 12:31:22 pm >> UPDATE ps_document SET
id_document_type = '24',
document_num = '22/A',
document_date = '2026-01-27',
document_letter = 'A',
id_customer = '2332',
id_supplier = '',
id_address = '4679092',
address1 = 'P.ZZA S. ROCCO 84088 SIANO',
address2 = '',
note = '',
price_shipping = '0.00',
id_tax_shipping_rules = '4',
colli = '0',
peso = '0',
porto_e_imballo = '0',
mezzo_consegna = '',
id_payment = '17',
id_causal = '0',
price_tax_included = '226.39',
price_tax_excluded = '198.08',
date_upd = NOW()
WHERE id_document = '101121'
04/03/2026 12:31:22 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 = '101121'
04/03/2026 12:31:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '101121'
04/03/2026 12:31:22 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
( '101121' , '12816' , 'LIBRO DEI DEFUNTI' , '1' , '-1' , '1' ,
'40.0000' , '32.786885245902' , '22' , '5' , '38.00' )
04/03/2026 12:31:22 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
( '101121' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '1' , '-1' , '1' ,
'70.0000' , '57.377049180328' , '22' , '0' , '70.00' )
04/03/2026 12:31:22 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
( '101121' , '1090' , 'BIBBIA' , '1' , '-1' , '4' ,
'9.9000' , '9.9' , '0' , '0' , '9.90' )
04/03/2026 12:31:22 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
( '101121' , '2679' , 'CONOSCERE GESU\'' , '10' , '-10' , '4' ,
'3.5000' , '3.5' , '0' , '15' , '29.75' )
04/03/2026 12:31:22 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
( '101121' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '10' , '-10' , '4' ,
'3.5000' , '3.5' , '0' , '15' , '29.75' )
04/03/2026 12:31:22 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
( '101121' , '17617' , 'IMMAGINI ISONZO X 100' , '3' , '-3' , '1' ,
'3.3300' , '2.7295081967213' , '22' , '0' , '9.99' )
04/03/2026 12:31:22 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
( '101121' , '' , '04/02' , '1' , '-1' , '0' ,
'0' , '0' , '' , '0' , '0' )
04/03/2026 12:31:22 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
( '101121' , '1710' , 'CARBONCINI PER TURIBOLO - PZ 120' , '3' , '-3' , '1' ,
'13.00' , '10.655737704918' , '22' , '0' , '39.00' )
04/03/2026 12:35:05 pm >> SELECT document_num FROM ps_document
WHERE document_num = '5/E' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2026-03-04')
04/03/2026 12:35:05 pm >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'23' ,
'5/E' ,
'2026-03-04' ,
'E' ,
'189' ,
'0' ,
'4679063' ,
'VIA NAZIONALE APPIA, 128 81022 CASAGIOVE' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'3' ,
'0' ,
'150.00' ,
'150.00' ,
NOW() ,
NOW() )
04/03/2026 12:35:05 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '101615'
04/03/2026 12:35:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '101615'
04/03/2026 12:35:05 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '101615' , '15020' , 'PREGARE OGNI GIORNO' , '230' , '-230' , '4' ,
'1.00' , '1' , '0' , '38' , '142.60' )
04/03/2026 12:35:05 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '101615' , '10133' , 'SPESE DI TRASPORTO' , '1' , '-1' , '0' ,
'7.4' , '7.4' , '' , '0' , '7.40' )
04/03/2026 12:58:33 pm >> SELECT document_num FROM ps_document
WHERE document_num = '8' AND id_document != '' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2026-03-04')
04/03/2026 12:58:33 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' ,
'8' ,
'2026-03-04' ,
'' ,
'0' ,
'118' ,
'4669176' ,
'VIALE EUROPA, 102 36075 MONTECCHIO MAGGIORE' ,
'' ,
'reso a fornitore - merce non conforme all\'ordine effettuato' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'17' ,
'0' ,
'0.00' ,
'0.00' ,
NOW() ,
NOW() )
04/03/2026 12:58:33 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 = '101616'
04/03/2026 12:58:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '101616'
04/03/2026 12:58:33 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
( '101616' , '24664' , 'CASULA MARIANA - 671MS' , '1' , '-1' , '1' ,
'0.00' , '0' , '22' , '0' , '0.00' )
04/03/2026 12:58:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24664' AND id_supplier = '118'
04/03/2026 12:58:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24664' , '118' , '1' )
04/03/2026 02:33:56 pm >> DELETE FROM ps_product WHERE id_product = '24665'
04/03/2026 02:33:56 pm >> DELETE FROM ps_product_shop WHERE id_product = '24665'
04/03/2026 02:33:56 pm >> DELETE FROM ps_product_lang WHERE id_product = '24665'
04/03/2026 02:33:56 pm >> DELETE FROM ps_stock_available WHERE id_product = '24665'
04/03/2026 02:35:55 pm >> DELETE FROM ps_document WHERE id_document = '101606'
04/03/2026 02:35:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '101606'
04/03/2026 02:38:15 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '671MS' AND id_product != '24664' AND ean13 != ''
04/03/2026 02:38:15 pm >> UPDATE ps_product SET
id_supplier = '118',
reference = '',
ean13 = '671MS',
date_upd = NOW()
WHERE id_product = '24664'
04/03/2026 02:38:15 pm >> UPDATE ps_product_lang SET
name = 'CASULA MARIANA - 671MS',
description = ''
WHERE id_product = '24664'
04/03/2026 02:38:15 pm >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '565.5737704918033'
WHERE id_product = '24664'
04/03/2026 02:38:15 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '565.5737704918033',
id_tax_rules_group = '1',
id_category_default = '432',
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 = '24664'
04/03/2026 02:38:15 pm >> DELETE FROM ps_specific_price WHERE id_product = '24664'
04/03/2026 02:41:05 pm >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'31' ,
'100' ,
'2026-03-03' ,
'' ,
'0' ,
'118' ,
'4669176' ,
'VIALE EUROPA, 102 36075 MONTECCHIO MAGGIORE' ,
'' ,
'' ,
'13.5' ,
'1' ,
'0' ,
'0' ,
'0' ,
'' ,
'9' ,
'0' ,
'687.46' ,
'563.49' ,
NOW() ,
NOW() )
04/03/2026 02:41:05 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '101617'
04/03/2026 02:41:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '101617'
04/03/2026 02:41:05 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '101617' , '24664' , 'CASULA MARIANA - 671MS' , '1' , '1' , '1' ,
'310' , '254.09836065574' , '22' , '3' , '366.8540' )
04/03/2026 02:41:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24664' AND id_supplier = '118'
04/03/2026 02:41:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24664' , '118' , '1' )
04/03/2026 02:41:05 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '101617' , '14577' , 'CAMICE BENEDETTINO COCOLLE - MISTO LANA 328' , '2' , '2' , '1' ,
'56' , '45.901639344262' , '22' , '3' , '132.5408' )
04/03/2026 02:41:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14577' AND id_supplier = '118'
04/03/2026 02:41:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14577' , '118' , '1' )
04/03/2026 02:41:05 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '101617' , '14354' , 'CAMICE BENEDETTINO LINO - 3010' , '2' , '2' , '1' ,
'61' , '50' , '22' , '3' , '144.3748' )
04/03/2026 02:41:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14354' AND id_supplier = '118'
04/03/2026 02:41:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14354' , '118' , '1' )
04/03/2026 02:41:05 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '101617' , '18118' , 'STOLA TAU - 31TAU' , '1' , '1' , '1' ,
'23' , '18.852459016393' , '22' , '3' , '27.2182' )
04/03/2026 02:41:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18118' AND id_supplier = '118'
04/03/2026 02:41:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18118' , '118' , '1' )
04/03/2026 02:41:42 pm >> SELECT document_num FROM ps_document
WHERE document_num = '23/A' AND id_document != '101275' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2026-02-09')
04/03/2026 02:41:42 pm >> UPDATE ps_document SET
id_document_type = '24',
document_num = '23/A',
document_date = '2026-02-09',
document_letter = 'A',
id_customer = '302',
id_supplier = '',
id_address = '4679587',
address1 = 'VIA F. LLI ROSSELLI 84096 MONTECORVINO ROVELLA',
address2 = '',
note = '',
price_shipping = '0.00',
id_tax_shipping_rules = '4',
colli = '0',
peso = '0',
porto_e_imballo = '0',
mezzo_consegna = '',
id_payment = '17',
id_causal = '0',
price_tax_included = '964.50',
price_tax_excluded = '963.08',
date_upd = NOW()
WHERE id_document = '101275'
04/03/2026 02:41: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 = '101275'
04/03/2026 02:41:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '101275'
04/03/2026 02:41: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
( '101275' , '24486' , 'SOFFERENZE DI CRISTO - A. RAGONE' , '265' , '-265' , '4' ,
'3.5000' , '3.5' , '0' , '0' , '927.50' )
04/03/2026 02:41: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
( '101275' , '24486' , 'SOFFERENZE DI CRISTO - A. RAGONE' , '10' , '-10' , '4' ,
'9.0000' , '9' , '0' , '100' , '0.00' )
04/03/2026 02:41: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
( '101275' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '10' , '-10' , '3' ,
'3.70' , '3.5576923076923' , '4' , '0' , '37.00' )
04/03/2026 03:10:30 pm >> SELECT document_num FROM ps_document
WHERE document_num = '678' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-03-04')
04/03/2026 03:10:30 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' ,
'678' ,
'2026-03-04' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'15' ,
'0' ,
'56.60' ,
'46.39' ,
NOW() ,
NOW() )
04/03/2026 03:10:30 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 = '101618'
04/03/2026 03:10:30 pm >> DELETE FROM ps_document_detail WHERE id_document = '101618'
04/03/2026 03:10:30 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
( '101618' , '24608' , 'CROCE SAN BENEDETTO - CM 25 - PG647' , '1' , '-1' , '1' ,
'44.00' , '36.065573770492' , '22' , '0' , '44.00' )
04/03/2026 03:10:30 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
( '101618' , '23385' , 'DECINA LEGNO - FR18' , '1' , '-1' , '1' ,
'0.60' , '0.49180327868852' , '22' , '0' , '0.60' )
04/03/2026 03:10:30 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
( '101618' , '19105' , 'FRAGRANZA MIRRA' , '1' , '-1' , '1' ,
'12.00' , '9.8360655737705' , '22' , '0' , '12.00' )
04/03/2026 04:08:02 pm >> SELECT document_num FROM ps_document
WHERE document_num = '6/L' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2026-03-04')
04/03/2026 04:08:02 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 (
'23' ,
'6/L' ,
'2026-03-04' ,
'L' ,
'204' ,
'0' ,
'4671483' ,
'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO' ,
'CAPPELLANIA OSP. MERCATO S. SEVERINO' ,
'CAPPELLANIA OSP. MERCATO S. SEVERINO' ,
'0.00' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'3' ,
'0' ,
'97.50' ,
'81.06' ,
NOW() ,
NOW() )
04/03/2026 04:08:02 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 = '101619'
04/03/2026 04:08:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '101619'
04/03/2026 04:08: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
( '101619' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' ,
'3.0000' , '2.459' , '22' , '0' , '90.00' )
04/03/2026 04:08: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
( '101619' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '1' , '-1' , '3' ,
'3.5000' , '3.3654' , '4' , '0' , '3.50' )
04/03/2026 04:08: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
( '101619' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' ,
'2.0000' , '1.9231' , '4' , '0' , '2.00' )
04/03/2026 04:08: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
( '101619' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '2' , '-2' , '4' ,
'1.0000' , '1' , '0' , '0' , '2.00' )
04/03/2026 04:08:27 pm >> DELETE FROM ps_document WHERE id_document = '101607'
04/03/2026 04:08:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '101607'
04/03/2026 04:16:30 pm >> SELECT document_num FROM ps_document
WHERE document_num = '6/E' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2026-03-04')
04/03/2026 04:16:30 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 (
'22' ,
'6/E' ,
'2026-03-04' ,
'E' ,
'3546' ,
'0' ,
'4679271' ,
'VIA TORQUATO TASSO 14 24020 GORLE ' ,
'' ,
'' ,
'0.00' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'17' ,
'0' ,
'2000.00' ,
'2000.00' ,
NOW() ,
NOW() )
04/03/2026 04:16:30 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 = '101620'
04/03/2026 04:16:30 pm >> DELETE FROM ps_document_detail WHERE id_document = '101620'
04/03/2026 04:16:30 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
( '101620' , '14143' , 'SAN FRANCESCO D\'ASSISI - RACCONTATO AI RAGAZZI' , '1000' , '0' , '4' ,
'4.0000' , '4' , '0' , '50' , '2000.00' )
04/03/2026 04:16:55 pm >> SELECT document_num FROM ps_document
WHERE document_num = '6/E' AND id_document != '101620' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2026-03-04')
04/03/2026 04:16:55 pm >> UPDATE ps_document SET
id_document_type = '22',
document_num = '6/E',
document_date = '2026-03-04',
document_letter = 'E',
id_customer = '3546',
id_supplier = '',
id_address = '4679271',
address1 = 'VIA TORQUATO TASSO 14 24020 GORLE ',
address2 = '',
note = '',
price_shipping = '0.00',
id_tax_shipping_rules = '4',
colli = '0',
peso = '0',
porto_e_imballo = '0',
mezzo_consegna = '',
id_payment = '3',
id_causal = '0',
price_tax_included = '2000.00',
price_tax_excluded = '2000.00',
date_upd = NOW()
WHERE id_document = '101620'
04/03/2026 04:16:55 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 = '101620'
04/03/2026 04:16:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '101620'
04/03/2026 04:16:55 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
( '101620' , '14143' , 'SAN FRANCESCO D\'ASSISI - RACCONTATO AI RAGAZZI' , '1000' , '0' , '4' ,
'4.0000' , '4' , '0' , '50' , '2000.00' )
04/03/2026 04:36:25 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3546'
04/03/2026 04:36:25 pm >> INSERT INTO ps_address
( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd )
VALUES (
'3546' ,
'10' ,
'135' ,
'CENTRO CULTURALE CATTOLICO' ,
'' ,
'' ,
'VIA RIGLA 44' ,
'' ,
'24010' ,
'PONTERANICA' ,
'' ,
'035665606' ,
'' ,
'01714310164' ,
'01714310164' ,
NOW() ,
NOW() )
04/03/2026 04:36:25 pm >> UPDATE ps_customer SET
email = 'arcangela@velar.it',
sdi = 'SUBM70N',
pec = '',
date_upd = NOW()
WHERE id_customer = '3546'
04/03/2026 04:38:05 pm >> SELECT document_num FROM ps_document
WHERE document_num = '6/E' AND id_document != '101620' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2026-03-04')
04/03/2026 04:38:05 pm >> UPDATE ps_document SET
id_document_type = '22',
document_num = '6/E',
document_date = '2026-03-04',
document_letter = 'E',
id_customer = '3546',
id_supplier = '0',
id_address = '4679735',
address1 = 'VIA TORQUATO TASSO 14 24020 GORLE ',
address2 = '',
note = '',
price_shipping = '0.00',
id_tax_shipping_rules = '4',
colli = '0',
peso = '0',
porto_e_imballo = '0',
mezzo_consegna = '',
id_payment = '3',
id_causal = '0',
price_tax_included = '2000.00',
price_tax_excluded = '2000.00',
date_upd = NOW()
WHERE id_document = '101620'
04/03/2026 04:38:05 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '101620'
04/03/2026 04:38:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '101620'
04/03/2026 04:38:06 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '101620' , '14143' , 'SAN FRANCESCO D\'ASSISI - RACCONTATO AI RAGAZZI' , '1000' , '0' , '4' ,
'4.0000' , '4' , '0' , '50' , '2000.00' )
04/03/2026 04:50:26 pm >> SELECT document_num FROM ps_document
WHERE document_num = '46' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2026-03-04')
04/03/2026 04:50:26 pm >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'21' ,
'46' ,
'2026-03-04' ,
'' ,
'4273' ,
'0' ,
'4679614' ,
'P. ZZA VITTORIO VENETO 60020 SIROLO' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'3' ,
'0' ,
'233.75' ,
'233.75' ,
NOW() ,
NOW() )
04/03/2026 04:50:26 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '101621'
04/03/2026 04:50:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '101621'
04/03/2026 04:50:26 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '101621' , '15602' , 'AMICO GESU\' ALBUM' , '10' , '-10' , '4' ,
'2.00' , '2' , '0' , '15' , '17.00' )
04/03/2026 04:50:26 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '101621' , '24147' , 'AMICO GESU\' - SCATOLA 60 PZ' , '2' , '-2' , '4' ,
'30.00' , '30' , '0' , '15' , '51.00' )
04/03/2026 04:50:26 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '101621' , '' , 'BIBBIA: GENESI ALBUM+FIGURINE' , '13' , '-13' , '0' ,
'15' , '15' , '' , '15' , '165.75' )
04/03/2026 05:03:22 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() )
04/03/2026 05:03:22 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24666' , '1' , '' , 'nuovo-prodotto' )
04/03/2026 05:03:22 pm >> INSERT INTO ps_product_shop (
id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd`
) VALUES (
'24666' , '1' , '1' , '2' , NOW() , NOW()
)
04/03/2026 05:03:22 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '24666' , '0' , '1' , '0' , '0' )
04/03/2026 05:14:05 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791280736741' AND id_product != '24666' AND ean13 != ''
04/03/2026 05:14:05 pm >> UPDATE ps_product SET
id_supplier = '',
reference = '13/3',
ean13 = '9791280736741',
date_upd = NOW()
WHERE id_product = '24666'
04/03/2026 05:14:05 pm >> UPDATE ps_product_lang SET
name = 'VIA MATRIS - G. VALSECCHI',
description = 'La Via Matris è un esercizio devozionale cristiano che ripercorre i sette dolori della Vergine Maria, madre di Gesù. Essa nasce sul modello della Via Crucis, ma si concentra sui dolori di Maria, associata alla Passione di Cristo come madre e partecipe della sofferenza del Figlio. “Nella sua essenza, non è altro che un modo di partecipare, attraverso la contemplazione del dolore della Madre, alla passione di Cristo, che si prolunga nel dolore dell’uomo e induce a comprendere e a sollevare le umane sofferenze”
'
WHERE id_product = '24666'
04/03/2026 05:14:05 pm >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '4.5'
WHERE id_product = '24666'
04/03/2026 05:14:05 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '4.5',
id_tax_rules_group = '4',
id_category_default = '395',
id_argoment_default = '28',
id_internal_category = '4',
on_sale = '0',
on_showcase = '1',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '24666'
04/03/2026 05:14:05 pm >> DELETE FROM ps_specific_price WHERE id_product = '24666'
04/03/2026 05:14:05 pm >> INSERT INTO ps_specific_price
( id_specific_price_rule , id_cart , id_product , id_shop , id_shop_group , id_currency , id_country , id_group , id_customer , id_product_attribute , price , from_quantity , reduction , reduction_tax , reduction_type , `from` , `to`)
VALUES
( '0' , '0' , '24666' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' )
04/03/2026 05:14:44 pm >> UPDATE ps_product_shop SET active = '1' WHERE id_product = '24666'
04/03/2026 05:16:07 pm >> SELECT document_num FROM ps_document
WHERE document_num = '47' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2026-03-04')
04/03/2026 05:16: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 (
'21' ,
'47' ,
'2026-03-04' ,
'' ,
'3496' ,
'0' ,
'4679247' ,
'VIA ALLA BASILICA 1 23808 VERCURAGO' ,
'' ,
'OMAGGIO AUTORE' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'17' ,
'0' ,
'0.00' ,
'0.00' ,
NOW() ,
NOW() )
04/03/2026 05:16: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 = '101622'
04/03/2026 05:16:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '101622'
04/03/2026 05:16: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
( '101622' , '24666' , 'VIA MATRIS - G. VALSECCHI' , '40' , '-40' , '4' ,
'4.50' , '4.5' , '0' , '100' , '0.00' )
04/03/2026 05:16:57 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() )
04/03/2026 05:16:57 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24667' , '1' , '' , 'nuovo-prodotto' )
04/03/2026 05:16:57 pm >> INSERT INTO ps_product_shop (
id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd`
) VALUES (
'24667' , '1' , '1' , '2' , NOW() , NOW()
)
04/03/2026 05:16:57 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '24667' , '0' , '1' , '0' , '0' )
04/03/2026 05:19:46 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791280736727' AND id_product != '24667' AND ean13 != ''
04/03/2026 05:19:46 pm >> UPDATE ps_product SET
id_supplier = '',
reference = '6/4',
ean13 = '9791280736727',
date_upd = NOW()
WHERE id_product = '24667'
04/03/2026 05:19:46 pm >> UPDATE ps_product_lang SET
name = 'I DOTTRINARI E LA RIVOLUZIONE FRANCESE',
description = 'Il 17 ottobre 1926, Pio XI proclamava beati i dottrinari Claudio Bochot ed Eustachio Félix, insieme ad altri 189 martiri della Rivoluzione francese. In occasione del centenario della loro beatificazione, questo opuscolo desidera far conoscere non solo il martirio di questi discepoli di san Cesare de Bus ma anche le vicende vissute da altri dottrinari, di cui è in corso il processo di beatificazione, come anche l’enorme prezzo che la Congregazione pagò durante la Rivoluzione Francese
'
WHERE id_product = '24667'
04/03/2026 05:19:46 pm >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '5'
WHERE id_product = '24667'
04/03/2026 05:19:47 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '5',
id_tax_rules_group = '4',
id_category_default = '395',
id_argoment_default = '226',
id_internal_category = '4',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '24667'
04/03/2026 05:19:47 pm >> DELETE FROM ps_specific_price WHERE id_product = '24667'
04/03/2026 05:19:47 pm >> INSERT INTO ps_specific_price
( id_specific_price_rule , id_cart , id_product , id_shop , id_shop_group , id_currency , id_country , id_group , id_customer , id_product_attribute , price , from_quantity , reduction , reduction_tax , reduction_type , `from` , `to`)
VALUES
( '0' , '0' , '24667' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' )
04/03/2026 05:20:14 pm >> UPDATE ps_product_shop SET active = '1' WHERE id_product = '24667'
04/03/2026 06:00:15 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4327'
04/03/2026 06:00:15 pm >> INSERT INTO ps_address
( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd )
VALUES (
'4327' ,
'10' ,
'222' ,
'' ,
'GENOVESE' ,
'DON ANTONIO ' ,
'PIAZZA MONS. FURLAN 1' ,
'' ,
'31044' ,
'MONTEBELLUNA' ,
'' ,
'042322188' ,
'' ,
'' ,
'' ,
NOW() ,
NOW() )
04/03/2026 06:00:15 pm >> UPDATE ps_customer SET
email = 'genovese.donantonio@virgilio.it',
sdi = '',
pec = '',
date_upd = NOW()
WHERE id_customer = '4327'
04/03/2026 06:28:18 pm >> SELECT document_num FROM ps_document
WHERE document_num = '679' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-03-04')
04/03/2026 06:28:18 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' ,
'679' ,
'2026-03-04' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'1' ,
'0' ,
'100.00' ,
'81.97' ,
NOW() ,
NOW() )
04/03/2026 06:28:18 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 = '101623'
04/03/2026 06:28:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '101623'
04/03/2026 06:28:18 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
( '101623' , '19357' , 'DALMATICA ROSA - AEDA01' , '1' , '-1' , '1' ,
'100.00' , '81.967213114754' , '22' , '0' , '100.00' )
04/03/2026 06:48:02 pm >> SELECT document_num FROM ps_document
WHERE document_num = '9' AND id_document != '' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2026-03-04')
04/03/2026 06:48:02 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' ,
'9' ,
'2026-03-04' ,
'' ,
'0' ,
'107' ,
'4669100' ,
'VIA DEI CASTANI, 116 00172 ROMA' ,
'' ,
'RESA' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'17' ,
'0' ,
'248.90' ,
'248.90' ,
NOW() ,
NOW() )
04/03/2026 06:48:02 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 = '101624'
04/03/2026 06:48:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '101624'
04/03/2026 06:48: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
( '101624' , '22807' , 'SPIRITO SANTO BELLA VITA DI S. LUISA DE MARILLAC - E. PROFICO' , '1' , '-1' , '4' ,
'12.00' , '12' , '0' , '0' , '12.00' )
04/03/2026 06:48:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22807' AND id_supplier = '107'
04/03/2026 06:48:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22807' , '107' , '1' )
04/03/2026 06:48: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
( '101624' , '21466' , 'UNA LUCE DI NOME CHIARA - B. BAFFETTI' , '1' , '-1' , '4' ,
'12.00' , '12' , '0' , '0' , '12.00' )
04/03/2026 06:48:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21466' AND id_supplier = '107'
04/03/2026 06:48:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21466' , '107' , '1' )
04/03/2026 06:48: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
( '101624' , '23745' , 'DIAVOLO, PATOLOGIE E POSSESIONI' , '1' , '-1' , '4' ,
'16.00' , '16' , '0' , '0' , '16.00' )
04/03/2026 06:48:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23745' AND id_supplier = '107'
04/03/2026 06:48:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23745' , '107' , '1' )
04/03/2026 06:48: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
( '101624' , '22061' , 'FEDE DI ABRAMO E FEDE CRISTIANA - F. MOSETTO' , '1' , '-1' , '4' ,
'10.00' , '10' , '0' , '0' , '10.00' )
04/03/2026 06:48:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22061' AND id_supplier = '107'
04/03/2026 06:48:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22061' , '107' , '1' )
04/03/2026 06:48: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
( '101624' , '21673' , 'PARTECIPARE LA BIBBIA - AAVV' , '1' , '-1' , '4' ,
'10.00' , '10' , '0' , '0' , '10.00' )
04/03/2026 06:48:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21673' AND id_supplier = '107'
04/03/2026 06:48:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21673' , '107' , '1' )
04/03/2026 06:48: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
( '101624' , '19495' , 'DIRETTORIO PER LA CATECHESI - C. BISSOLI' , '1' , '-1' , '4' ,
'8.00' , '8' , '0' , '0' , '8.00' )
04/03/2026 06:48:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19495' AND id_supplier = '107'
04/03/2026 06:48:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19495' , '107' , '1' )
04/03/2026 06:48: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
( '101624' , '22279' , 'CARISMA SALESIANO E BUONE PRATICHE - S. FERNANDO' , '1' , '-1' , '4' ,
'15.00' , '15' , '0' , '0' , '15.00' )
04/03/2026 06:48:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22279' AND id_supplier = '107'
04/03/2026 06:48:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22279' , '107' , '1' )
04/03/2026 06:48: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
( '101624' , '21823' , 'DI MARIA UNA VERA IMMAGINE' , '1' , '-1' , '4' ,
'8.00' , '8' , '0' , '0' , '8.00' )
04/03/2026 06:48:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21823' AND id_supplier = '107'
04/03/2026 06:48:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21823' , '107' , '1' )
04/03/2026 06:48: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
( '101624' , '19577' , 'AUTOBIOGRAFIA S. IGNAZIO DI LOYOLA' , '1' , '-1' , '4' ,
'24.00' , '24' , '0' , '0' , '24.00' )
04/03/2026 06:48:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19577' AND id_supplier = '107'
04/03/2026 06:48:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19577' , '107' , '1' )
04/03/2026 06:48: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
( '101624' , '21071' , 'SANTIGNAZIO DI LOYOLA AUTOBIOGRAFIA' , '1' , '-1' , '4' ,
'5.00' , '5' , '0' , '0' , '5.00' )
04/03/2026 06:48:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21071' AND id_supplier = '107'
04/03/2026 06:48:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21071' , '107' , '1' )
04/03/2026 06:48: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
( '101624' , '22681' , 'OGNI GIORNO PREGHIAMO' , '1' , '-1' , '4' ,
'2.50' , '2.5' , '0' , '0' , '2.50' )
04/03/2026 06:48:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22681' AND id_supplier = '107'
04/03/2026 06:48:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22681' , '107' , '1' )
04/03/2026 06:48: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
( '101624' , '9759' , 'SCRITTI SPIRITUALI - S. MARGHERITA M. ALACOQUE' , '1' , '-1' , '4' ,
'15.00' , '15' , '0' , '0' , '15.00' )
04/03/2026 06:48:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9759' AND id_supplier = '107'
04/03/2026 06:48:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9759' , '107' , '1' )
04/03/2026 06:48: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
( '101624' , '841' , 'AUTOBIOGRAFIA S. M. M. ALACOQUE' , '1' , '-1' , '4' ,
'12.00' , '12' , '0' , '0' , '12.00' )
04/03/2026 06:48:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '841' AND id_supplier = '107'
04/03/2026 06:48:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '841' , '107' , '1' )
04/03/2026 06:48: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
( '101624' , '21622' , 'INVITO ALLA PREGHIERA - O. DE BERTOLIS' , '1' , '-1' , '4' ,
'14.00' , '14' , '0' , '0' , '14.00' )
04/03/2026 06:48:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21622' AND id_supplier = '107'
04/03/2026 06:48:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21622' , '107' , '1' )
04/03/2026 06:48: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
( '101624' , '15954' , 'MIO BUON MOSCATI - A. PIAZZESI' , '1' , '-1' , '4' ,
'10.00' , '10' , '0' , '0' , '10.00' )
04/03/2026 06:48:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15954' AND id_supplier = '107'
04/03/2026 06:48:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15954' , '107' , '1' )
04/03/2026 06:48: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
( '101624' , '20857' , 'CUORE DI GESU NELLE PAROLE DEI SALMI' , '1' , '-1' , '4' ,
'15.00' , '15' , '0' , '0' , '15.00' )
04/03/2026 06:48:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20857' AND id_supplier = '107'
04/03/2026 06:48:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20857' , '107' , '1' )
04/03/2026 06:48: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
( '101624' , '23744' , 'DIACONI IL DONO DI SERVIRE ' , '1' , '-1' , '4' ,
'10.00' , '10' , '0' , '0' , '10.00' )
04/03/2026 06:48:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23744' AND id_supplier = '107'
04/03/2026 06:48:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23744' , '107' , '1' )
04/03/2026 06:48: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
( '101624' , '17814' , 'TEOLOGIA SACRAMENTARIA - M. FLORIO' , '1' , '-1' , '4' ,
'21.90' , '21.9' , '0' , '0' , '21.90' )
04/03/2026 06:48:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17814' AND id_supplier = '107'
04/03/2026 06:48:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17814' , '107' , '1' )
04/03/2026 06:48: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
( '101624' , '22680' , 'LUCE DI GRAZIA - M. DI LORENZO' , '1' , '-1' , '4' ,
'10.00' , '10' , '0' , '0' , '10.00' )
04/03/2026 06:48:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22680' AND id_supplier = '107'
04/03/2026 06:48:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22680' , '107' , '1' )
04/03/2026 06:48: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
( '101624' , '21465' , 'AGIRE SACRAMENTALE - P. CASPANI' , '1' , '-1' , '4' ,
'18.50' , '18.5' , '0' , '0' , '18.50' )
04/03/2026 06:48:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21465' AND id_supplier = '107'
04/03/2026 06:48:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21465' , '107' , '1' )
04/03/2026 07:11:39 pm >> SELECT document_num FROM ps_document
WHERE document_num = '10' AND id_document != '' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2026-03-04')
04/03/2026 07:11: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 (
'24' ,
'10' ,
'2026-03-04' ,
'' ,
'3000' ,
'0' ,
'4669629' ,
'VIA DEI CASTANI, 116 00172 ROMA' ,
'' ,
'EDIZIONI' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'17' ,
'0' ,
'3756.00' ,
'3756.00' ,
NOW() ,
NOW() )
04/03/2026 07:11: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 = '101625'
04/03/2026 07:11:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '101625'
04/03/2026 07:11: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
( '101625' , '19050' , 'VENITE ADORIAMO - G. DAMORE' , '20' , '-20' , '4' ,
'7.00' , '7' , '0' , '0' , '140.00' )
04/03/2026 07:11: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
( '101625' , '24437' , 'PADRE NOSTRO POSTER - R. LUPI' , '200' , '-200' , '4' ,
'3.00' , '3' , '0' , '0' , '600.00' )
04/03/2026 07:11: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
( '101625' , '24542' , 'MESSAGGIO DI SAN FRANCESCO DASSISI - POSTER' , '200' , '-200' , '4' ,
'3.00' , '3' , '0' , '0' , '600.00' )
04/03/2026 07:11: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
( '101625' , '18049' , 'PADRE NOSTRO SPIEGATO AI BAMBINI' , '200' , '-200' , '4' ,
'2.50' , '2.5' , '0' , '0' , '500.00' )
04/03/2026 07:11: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
( '101625' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '120' , '-120' , '4' ,
'2.40' , '2.4' , '0' , '0' , '288.00' )
04/03/2026 07:11: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
( '101625' , '24666' , 'VIA MATRIS - G. VALSECCHI' , '120' , '-120' , '4' ,
'4.50' , '4.5' , '0' , '0' , '540.00' )
04/03/2026 07:11: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
( '101625' , '24540' , 'DONNE INDISPENSABILI NELLA STORIA DELLA CHIESA' , '68' , '-68' , '4' ,
'16.00' , '16' , '0' , '0' , '1088.00' )
04/03/2026 07:12:56 pm >> SELECT document_num FROM ps_document
WHERE document_num = '10' AND id_document != '101625' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2026-03-04')
04/03/2026 07:12:56 pm >> UPDATE ps_document SET
id_document_type = '24',
document_num = '10',
document_date = '2026-03-04',
document_letter = '',
id_customer = '3000',
id_supplier = '',
id_address = '4669629',
address1 = 'VIA DEI CASTANI, 116 00172 ROMA',
address2 = '',
note = 'EDIZIONI',
price_shipping = '0.00',
id_tax_shipping_rules = '4',
colli = '0',
peso = '0',
porto_e_imballo = '0',
mezzo_consegna = '',
id_payment = '17',
id_causal = '0',
price_tax_included = '4256.00',
price_tax_excluded = '4256.00',
date_upd = NOW()
WHERE id_document = '101625'
04/03/2026 07:12:56 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '101625'
04/03/2026 07:12:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '101625'
04/03/2026 07:12:56 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '101625' , '19050' , 'VENITE ADORIAMO - G. DAMORE' , '20' , '-20' , '4' ,
'7.0000' , '7' , '0' , '0' , '140.00' )
04/03/2026 07:12:56 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '101625' , '24437' , 'PADRE NOSTRO POSTER - R. LUPI' , '200' , '-200' , '4' ,
'3.0000' , '3' , '0' , '0' , '600.00' )
04/03/2026 07:12:56 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '101625' , '24542' , 'MESSAGGIO DI SAN FRANCESCO DASSISI - POSTER' , '200' , '-200' , '4' ,
'3.0000' , '3' , '0' , '0' , '600.00' )
04/03/2026 07:12:56 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '101625' , '18049' , 'PADRE NOSTRO SPIEGATO AI BAMBINI' , '200' , '-200' , '4' ,
'2.5000' , '2.5' , '0' , '0' , '500.00' )
04/03/2026 07:12:56 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '101625' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '120' , '-120' , '4' ,
'2.4000' , '2.4' , '0' , '0' , '288.00' )
04/03/2026 07:12:56 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '101625' , '24666' , 'VIA MATRIS - G. VALSECCHI' , '120' , '-120' , '4' ,
'4.5000' , '4.5' , '0' , '0' , '540.00' )
04/03/2026 07:12:56 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '101625' , '24540' , 'DONNE INDISPENSABILI NELLA STORIA DELLA CHIESA' , '68' , '-68' , '4' ,
'16.0000' , '16' , '0' , '0' , '1088.00' )
04/03/2026 07:12:56 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '101625' , '24667' , 'I DOTTRINARI E LA RIVOLUZIONE FRANCESE' , '100' , '-100' , '4' ,
'5.00' , '5' , '0' , '0' , '500.00' )
04/03/2026 07:41:36 pm >> SELECT document_num FROM ps_document
WHERE document_num = '680' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-03-04')
04/03/2026 07:41:36 pm >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'680' ,
'2026-03-04' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'1' ,
'0' ,
'11.00' ,
'9.02' ,
NOW() ,
NOW() )
04/03/2026 07:41:36 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '101626'
04/03/2026 07:41:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '101626'
04/03/2026 07:41:36 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '101626' , '20123' , 'FATIMA CM 17 - 1012' , '1' , '-1' , '1' ,
'7.00' , '5.7377049180328' , '22' , '0' , '7.00' )
04/03/2026 07:41:36 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '101626' , '24619' , 'CONFEZIONE TAU CON CARTONCINO - 1242' , '1' , '-1' , '1' ,
'4.00' , '3.2786885245902' , '22' , '0' , '4.00' )