29/10/2025 08:44:56 am >> INSERT INTO ps_customer
( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` )
VALUES
( '1' , '' , '' , '' , 'hRu7eCT6QO7oqvWd' , NOW() , NOW() )
29/10/2025 08:44:56 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4269' , '1' )
29/10/2025 08:44:56 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4269' , '2' )
29/10/2025 08:44:56 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4269' , '3' )
29/10/2025 08:45:58 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4269'
29/10/2025 08:45:58 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 (
'4269' ,
'10' ,
'160' ,
'' ,
'PERNASILICI' ,
'RITA' ,
'VIA MORICINO 9' ,
'' ,
'03024' ,
'CEPRANO' ,
'' ,
'' ,
'3381259121' ,
'' ,
'' ,
NOW() ,
NOW() )
29/10/2025 08:45:58 am >> UPDATE ps_customer SET
email = 'rita.pernasilici@gmail.com',
sdi = '',
pec = '',
date_upd = NOW()
WHERE id_customer = '4269'
29/10/2025 08:46:26 am >> SELECT document_num FROM ps_document
WHERE document_num = '173' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-10-29')
29/10/2025 08:46:26 am >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'21' ,
'173' ,
'2025-10-29' ,
'' ,
'4269' ,
'0' ,
'4679602' ,
'VIA MORICINO 9 03024 CEPRANO' ,
'' ,
'' ,
'5' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'9' ,
'0' ,
'12.98' ,
'12.98' ,
NOW() ,
NOW() )
29/10/2025 08:46:26 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 = '99542'
29/10/2025 08:46:26 am >> DELETE FROM ps_document_detail WHERE id_document = '99542'
29/10/2025 08:46:26 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99542' , '23032' , 'MIO LIBRO DI PREGHIERE - N. E. ' , '3' , '-3' , '4' ,
'2.80' , '2.8' , '0' , '5' , '7.98' )
29/10/2025 09:18:54 am >> SELECT document_num FROM ps_document
WHERE document_num = '3562' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-29')
29/10/2025 09:18:54 am >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'3562' ,
'2025-10-29' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'41.55' ,
'37.40' ,
NOW() ,
NOW() )
29/10/2025 09:18:54 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99543'
29/10/2025 09:18:54 am >> DELETE FROM ps_document_detail WHERE id_document = '99543'
29/10/2025 09:18:54 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99543' , '23954' , 'SAN BARTOLO LONGO ' , '1' , '-1' , '4' ,
'10.00' , '10' , '0' , '5' , '9.50' )
29/10/2025 09:18:54 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99543' , '24186' , 'DILEXI TE ' , '2' , '-2' , '4' ,
'2.00' , '2' , '0' , '0' , '4.00' )
29/10/2025 09:18:54 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99543' , '23169' , 'DILEXIT NOS ' , '1' , '-1' , '4' ,
'2.20' , '2.2' , '0' , '0' , '2.20' )
29/10/2025 09:18:54 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99543' , '5978' , 'LUCERNA TONDA COL. LIT. + KIT - CM 15 - OGGETTI' , '1' , '-1' , '1' ,
'23.00' , '18.852459016393' , '22' , '0' , '23.00' )
29/10/2025 09:18:54 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99543' , '23962' , 'CARLO ACUTIS - 8288' , '1' , '-1' , '4' ,
'3.00' , '3' , '0' , '5' , '2.85' )
29/10/2025 10:37:57 am >> SELECT document_num FROM ps_document
WHERE document_num = '174' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-10-29')
29/10/2025 10:37:57 am >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'21' ,
'174' ,
'2025-10-29' ,
'' ,
'333' ,
'0' ,
'4679537' ,
'P.ZZA S. MICHELE 84135 RUFOLI' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'1' ,
'0' ,
'60.86' ,
'60.86' ,
NOW() ,
NOW() )
29/10/2025 10:37:57 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99544'
29/10/2025 10:37:57 am >> DELETE FROM ps_document_detail WHERE id_document = '99544'
29/10/2025 10:37:58 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99544' , '5458' , 'IO SONO CON VOI 2 PARTE' , '12' , '-12' , '4' ,
'2.80' , '2.8' , '0' , '15' , '28.56' )
29/10/2025 10:37:58 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99544' , '22033' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - GUIDA N.E.' , '1' , '-1' , '4' ,
'8.00' , '8' , '0' , '15' , '6.80' )
29/10/2025 10:37:58 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99544' , '22028' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - N.E.' , '10' , '-10' , '4' ,
'3.00' , '3' , '0' , '15' , '25.50' )
29/10/2025 10:42:44 am >> SELECT document_num FROM ps_document
WHERE document_num = '174' AND id_document != '99544' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-10-29')
29/10/2025 10:42:44 am >> UPDATE ps_document SET
id_document_type = '21',
document_num = '174',
document_date = '2025-10-29',
document_letter = '',
id_customer = '333',
id_supplier = '',
id_address = '4679537',
address1 = 'P.ZZA S. MICHELE 84135 RUFOLI',
address2 = '',
note = '',
price_shipping = '0.00',
id_tax_shipping_rules = '4',
colli = '0',
peso = '0',
porto_e_imballo = '0',
mezzo_consegna = '',
id_payment = '1',
id_causal = '0',
price_tax_included = '79.39',
price_tax_excluded = '79.39',
date_upd = NOW()
WHERE id_document = '99544'
29/10/2025 10:42: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 = '99544'
29/10/2025 10:42:44 am >> DELETE FROM ps_document_detail WHERE id_document = '99544'
29/10/2025 10:42: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
( '99544' , '5458' , 'IO SONO CON VOI 2 PARTE' , '13' , '-13' , '4' ,
'2.8000' , '2.8' , '0' , '15' , '30.94' )
29/10/2025 10:42: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
( '99544' , '22033' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - GUIDA N.E.' , '2' , '-2' , '4' ,
'8.0000' , '8' , '0' , '15' , '13.60' )
29/10/2025 10:42: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
( '99544' , '22028' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - N.E.' , '11' , '-11' , '4' ,
'3.0000' , '3' , '0' , '15' , '28.05' )
29/10/2025 10:42: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
( '99544' , '5446' , 'IO SONO CON VOI - GUIDA' , '1' , '-1' , '4' ,
'8.00' , '8' , '0' , '15' , '6.80' )
29/10/2025 10:43:02 am >> DELETE FROM ps_document WHERE id_document = '99386'
29/10/2025 10:43:02 am >> DELETE FROM ps_document_detail WHERE id_document = '99386'
29/10/2025 10:43:20 am >> SELECT document_num FROM ps_document
WHERE document_num = '3563' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-29')
29/10/2025 10:43:21 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' ,
'3563' ,
'2025-10-29' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'4.75' ,
'4.75' ,
NOW() ,
NOW() )
29/10/2025 10:43:21 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 = '99545'
29/10/2025 10:43:21 am >> DELETE FROM ps_document_detail WHERE id_document = '99545'
29/10/2025 10:43:21 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
( '99545' , '24022' , 'SULLA TUA PAROLA NOV/DIC 2025 - 531' , '1' , '-1' , '4' ,
'5.00' , '5' , '0' , '5' , '4.75' )
29/10/2025 10:48:26 am >> SELECT document_num FROM ps_document
WHERE document_num = '3564' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-29')
29/10/2025 10:48:26 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' ,
'3564' ,
'2025-10-29' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'79.90' ,
'74.51' ,
NOW() ,
NOW() )
29/10/2025 10:48:26 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 = '99546'
29/10/2025 10:48:26 am >> DELETE FROM ps_document_detail WHERE id_document = '99546'
29/10/2025 10:48:26 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99546' , '21612' , 'RITO ESEQUIE - ED. MIN.- N.E.' , '1' , '-1' , '4' ,
'30.00' , '30' , '0' , '0' , '30.00' )
29/10/2025 10:48:26 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99546' , '21656' , 'SACRAMENTO DELLUNZIONE E CURA PASTORALE N.E.' , '1' , '-1' , '4' ,
'20.00' , '20' , '0' , '0' , '20.00' )
29/10/2025 10:48:26 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99546' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' ,
'8.90' , '7.2950819672131' , '22' , '0' , '8.90' )
29/10/2025 10:48:26 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99546' , '16834' , 'LITURGICO CARTA 8GG' , '6' , '-6' , '1' ,
'3.50' , '2.8688524590164' , '22' , '0' , '21.00' )
29/10/2025 10:58:01 am >> SELECT document_num FROM ps_document
WHERE document_num = '3565' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-29')
29/10/2025 10:58: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' ,
'3565' ,
'2025-10-29' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'23.75' ,
'23.75' ,
NOW() ,
NOW() )
29/10/2025 10:58: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 = '99547'
29/10/2025 10:58:01 am >> DELETE FROM ps_document_detail WHERE id_document = '99547'
29/10/2025 10:58: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
( '99547' , '24022' , 'SULLA TUA PAROLA NOV/DIC 2025 - 531' , '5' , '-5' , '4' ,
'5.00' , '5' , '0' , '5' , '23.75' )
29/10/2025 11:14:09 am >> SELECT document_num FROM ps_document
WHERE document_num = '3566' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-29')
29/10/2025 11:14: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' ,
'3566' ,
'2025-10-29' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'50.00' ,
'40.98' ,
NOW() ,
NOW() )
29/10/2025 11:14: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 = '99548'
29/10/2025 11:14:09 am >> DELETE FROM ps_document_detail WHERE id_document = '99548'
29/10/2025 11:14: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
( '99548' , '6014' , 'LUMINO BIANCO - 10B' , '50' , '-50' , '1' ,
'0.50' , '0.40983606557377' , '22' , '0' , '25.00' )
29/10/2025 11:14: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
( '99548' , '6019' , 'LUMINO ROSSO - 10B' , '50' , '-50' , '1' ,
'0.50' , '0.40983606557377' , '22' , '0' , '25.00' )
29/10/2025 11:23:05 am >> SELECT document_num FROM ps_document
WHERE document_num = '125' AND id_document != '99246' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-10-15')
29/10/2025 11:23:06 am >> UPDATE ps_document SET
id_document_type = '21',
document_num = '125',
document_date = '2025-10-15',
document_letter = '',
id_customer = '333',
id_supplier = '',
id_address = '4679537',
address1 = 'VIA DEL DUCA 89 52045 FOIANO DELLA CHIANA',
address2 = '',
note = '',
price_shipping = '0.00',
id_tax_shipping_rules = '4',
colli = '0',
peso = '0',
porto_e_imballo = '0',
mezzo_consegna = '',
id_payment = '1',
id_causal = '0',
price_tax_included = '79.39',
price_tax_excluded = '79.39',
date_upd = NOW()
WHERE id_document = '99246'
29/10/2025 11:23:06 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 = '99246'
29/10/2025 11:23:06 am >> DELETE FROM ps_document_detail WHERE id_document = '99246'
29/10/2025 11:23:06 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
( '99246' , '5458' , 'IO SONO CON VOI 2 PARTE' , '13' , '-13' , '4' ,
'2.8000' , '2.8' , '0' , '15' , '30.94' )
29/10/2025 11:23:06 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
( '99246' , '22033' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - GUIDA N.E.' , '2' , '-2' , '4' ,
'8.0000' , '8' , '0' , '15' , '13.60' )
29/10/2025 11:23:06 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
( '99246' , '22028' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - N.E.' , '11' , '-11' , '4' ,
'3.0000' , '3' , '0' , '15' , '28.05' )
29/10/2025 11:23:06 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
( '99246' , '5446' , 'IO SONO CON VOI - GUIDA' , '1' , '-1' , '4' ,
'8.0000' , '8' , '0' , '15' , '6.80' )
29/10/2025 11:23:20 am >> DELETE FROM ps_document WHERE id_document = '99544'
29/10/2025 11:23:20 am >> DELETE FROM ps_document_detail WHERE id_document = '99544'
29/10/2025 11:38:00 am >> SELECT document_num FROM ps_document
WHERE document_num = '174' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-10-29')
29/10/2025 11:38: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 (
'21' ,
'174' ,
'2025-10-29' ,
'' ,
'541' ,
'0' ,
'4671522' ,
'VIA GALLIANO 84126 SALERNO' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'15' ,
'0' ,
'47.60' ,
'47.60' ,
NOW() ,
NOW() )
29/10/2025 11:38: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 = '99549'
29/10/2025 11:38:00 am >> DELETE FROM ps_document_detail WHERE id_document = '99549'
29/10/2025 11:38: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
( '99549' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '20' , '-20' , '4' ,
'2.80' , '2.8' , '0' , '15' , '47.60' )
29/10/2025 11:39:05 am >> SELECT document_num FROM ps_document
WHERE document_num = '3567' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-29')
29/10/2025 11:39:05 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' ,
'3567' ,
'2025-10-29' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'4.75' ,
'4.75' ,
NOW() ,
NOW() )
29/10/2025 11:39:05 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 = '99550'
29/10/2025 11:39:05 am >> DELETE FROM ps_document_detail WHERE id_document = '99550'
29/10/2025 11:39:05 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
( '99550' , '24022' , 'SULLA TUA PAROLA NOV/DIC 2025 - 531' , '1' , '-1' , '4' ,
'5.00' , '5' , '0' , '5' , '4.75' )
29/10/2025 11:40:42 am >> SELECT document_num FROM ps_document
WHERE document_num = '3568' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-29')
29/10/2025 11:40:43 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' ,
'3568' ,
'2025-10-29' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'140.00' ,
'138.20' ,
NOW() ,
NOW() )
29/10/2025 11:40:43 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 = '99551'
29/10/2025 11:40:43 am >> DELETE FROM ps_document_detail WHERE id_document = '99551'
29/10/2025 11:40:43 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
( '99551' , '23984' , 'AGENDA 2026' , '1' , '-1' , '1' ,
'10.00' , '8.1967213114754' , '22' , '0' , '10.00' )
29/10/2025 11:40:43 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
( '99551' , '17330' , 'MESSALE ROMANO D\'ALTARE N. E. TAGLIO ORO' , '1' , '-1' , '4' ,
'130.00' , '130' , '0' , '0' , '130.00' )
29/10/2025 11:45:26 am >> SELECT document_num FROM ps_document
WHERE document_num = '174' AND id_document != '99549' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-10-29')
29/10/2025 11:45:26 am >> UPDATE ps_document SET
id_document_type = '21',
document_num = '174',
document_date = '2025-10-29',
document_letter = '',
id_customer = '541',
id_supplier = '',
id_address = '4671522',
address1 = 'VIA GALLIANO 84126 SALERNO',
address2 = '',
note = '',
price_shipping = '0.00',
id_tax_shipping_rules = '4',
colli = '0',
peso = '0',
porto_e_imballo = '0',
mezzo_consegna = '',
id_payment = '15',
id_causal = '0',
price_tax_included = '71.40',
price_tax_excluded = '71.40',
date_upd = NOW()
WHERE id_document = '99549'
29/10/2025 11:45:26 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 = '99549'
29/10/2025 11:45:26 am >> DELETE FROM ps_document_detail WHERE id_document = '99549'
29/10/2025 11:45:26 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99549' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '30' , '-30' , '4' ,
'2.8000' , '2.8' , '0' , '15' , '71.40' )
29/10/2025 11:46:32 am >> SELECT document_num FROM ps_document
WHERE document_num = '3569' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-29')
29/10/2025 11:46:32 am >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'3569' ,
'2025-10-29' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'4.00' ,
'3.28' ,
NOW() ,
NOW() )
29/10/2025 11:46:32 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99552'
29/10/2025 11:46:32 am >> DELETE FROM ps_document_detail WHERE id_document = '99552'
29/10/2025 11:46:32 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99552' , '2436' , 'COLORANTE PER CERA LIQUIDA - 1002' , '2' , '-2' , '1' ,
'2.00' , '1.6393442622951' , '22' , '0' , '4.00' )
29/10/2025 11:58:39 am >> SELECT document_num FROM ps_document
WHERE document_num = '3570' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-29')
29/10/2025 11:58:39 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' ,
'3570' ,
'2025-10-29' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'27.58' ,
'24.15' ,
NOW() ,
NOW() )
29/10/2025 11:58:39 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 = '99553'
29/10/2025 11:58:39 am >> DELETE FROM ps_document_detail WHERE id_document = '99553'
29/10/2025 11:58:39 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
( '99553' , '7442' , 'PANE QUOTIDIANO' , '1' , '-1' , '4' ,
'4.50' , '4.5' , '0' , '5' , '4.28' )
29/10/2025 11:58:39 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
( '99553' , '11151' , 'LIBRI' , '1' , '-1' , '4' ,
'1.8' , '1.8' , '0' , '0' , '1.80' )
29/10/2025 11:58:39 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
( '99553' , '23485' , 'CONFESSIONE' , '1' , '-1' , '4' ,
'2.50' , '2.5' , '0' , '0' , '2.50' )
29/10/2025 11:58:39 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
( '99553' , '16985' , 'SAN GIUSEPPE DORMIENTE - 4040' , '1' , '-1' , '1' ,
'19.00' , '15.573770491803' , '22' , '0' , '19.00' )
29/10/2025 12:00:20 pm >> SELECT document_num FROM ps_document
WHERE document_num = '3570' AND id_document != '99553' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-29')
29/10/2025 12:00:20 pm >> UPDATE ps_document SET
id_document_type = '11',
document_num = '3570',
document_date = '2025-10-29',
document_letter = '',
id_customer = '0',
id_supplier = '',
id_address = '0',
address1 = '',
address2 = '',
note = '',
price_shipping = '0.00',
id_tax_shipping_rules = '4',
colli = '0',
peso = '0',
porto_e_imballo = '0',
mezzo_consegna = '',
id_payment = '0',
id_causal = '0',
price_tax_included = '27.58',
price_tax_excluded = '24.15',
date_upd = NOW()
WHERE id_document = '99553'
29/10/2025 12:00:20 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 = '99553'
29/10/2025 12:00:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '99553'
29/10/2025 12:00:20 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99553' , '7442' , 'PANE QUOTIDIANO' , '1' , '-1' , '4' ,
'4.5000' , '4.5' , '0' , '5' , '4.28' )
29/10/2025 12:00:20 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99553' , '15317' , 'LA COMUNIONE SPIEGATA AI RAGAZZI' , '1' , '-1' , '4' ,
'1.80' , '1.8' , '0' , '0' , '1.80' )
29/10/2025 12:00:20 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99553' , '23485' , 'CONFESSIONE' , '1' , '-1' , '4' ,
'2.5000' , '2.5' , '0' , '0' , '2.50' )
29/10/2025 12:00:20 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99553' , '16985' , 'SAN GIUSEPPE DORMIENTE - 4040' , '1' , '-1' , '1' ,
'19.0000' , '15.573770491803' , '22' , '0' , '19.00' )
29/10/2025 02:30:12 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() )
29/10/2025 02:30:12 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24196' , '1' , '' , 'nuovo-prodotto' )
29/10/2025 02:30:12 pm >> INSERT INTO ps_product_shop (
id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd`
) VALUES (
'24196' , '1' , '1' , '2' , NOW() , NOW()
)
29/10/2025 02:30:13 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '24196' , '0' , '1' , '0' , '0' )
29/10/2025 02:31:04 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892248724' AND id_product != '24196' AND ean13 != ''
29/10/2025 02:31:04 pm >> UPDATE ps_product SET
id_supplier = '',
reference = '5/2',
ean13 = '9788892248724',
date_upd = NOW()
WHERE id_product = '24196'
29/10/2025 02:31:04 pm >> UPDATE ps_product_lang SET
name = 'VANGELO A FUMETTI',
description = ''
WHERE id_product = '24196'
29/10/2025 02:31:04 pm >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '25'
WHERE id_product = '24196'
29/10/2025 02:31:04 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '25',
id_tax_rules_group = '4',
id_category_default = '30',
id_argoment_default = '40',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '24196'
29/10/2025 02:31:04 pm >> DELETE FROM ps_specific_price WHERE id_product = '24196'
29/10/2025 02:31:05 pm >> INSERT INTO ps_product (
id_tax_rules_group , `date_add` , `date_upd`
) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '24196'
29/10/2025 02:31:05 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24197' , '1' , '' , 'nuovo-prodotto' )
29/10/2025 02:31:05 pm >> INSERT INTO ps_product_shop (
id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd`
) SELECT '24197' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '24196'
29/10/2025 02:31:05 pm >> INSERT INTO `ps_stock_available` (
id_product , id_product_attribute , id_shop , id_shop_group , quantity
) SELECT '24197' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '24196'
29/10/2025 02:32:36 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892248793' AND id_product != '24197' AND ean13 != ''
29/10/2025 02:32:36 pm >> UPDATE ps_product SET
id_supplier = '',
reference = '',
ean13 = '9788892248793',
date_upd = NOW()
WHERE id_product = '24197'
29/10/2025 02:32:36 pm >> UPDATE ps_product_lang SET
name = 'PAROLA DI DIO OGNI GIORNO 2026 - V. PAGLIA',
description = ''
WHERE id_product = '24197'
29/10/2025 02:32:36 pm >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '24'
WHERE id_product = '24197'
29/10/2025 02:32:36 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '24',
id_tax_rules_group = '4',
id_category_default = '30',
id_argoment_default = '41',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '24197'
29/10/2025 02:32:36 pm >> DELETE FROM ps_specific_price WHERE id_product = '24197'
29/10/2025 02:32:46 pm >> INSERT INTO ps_product (
id_tax_rules_group , `date_add` , `date_upd`
) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '24197'
29/10/2025 02:32:46 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24198' , '1' , '' , 'nuovo-prodotto' )
29/10/2025 02:32:46 pm >> INSERT INTO ps_product_shop (
id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd`
) SELECT '24198' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '24197'
29/10/2025 02:32:46 pm >> INSERT INTO `ps_stock_available` (
id_product , id_product_attribute , id_shop , id_shop_group , quantity
) SELECT '24198' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '24197'
29/10/2025 02:33:39 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892872684' AND id_product != '24198' AND ean13 != ''
29/10/2025 02:33:39 pm >> UPDATE ps_product SET
id_supplier = '',
reference = '5/3',
ean13 = '9788892872684',
date_upd = NOW()
WHERE id_product = '24198'
29/10/2025 02:33:39 pm >> UPDATE ps_product_lang SET
name = 'NATALE SCOPRIAMOLO INSIEME - E. GIORDANO',
description = ''
WHERE id_product = '24198'
29/10/2025 02:33:39 pm >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '4.9'
WHERE id_product = '24198'
29/10/2025 02:33:39 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '4.9',
id_tax_rules_group = '4',
id_category_default = '26',
id_argoment_default = '39',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '24198'
29/10/2025 02:33:39 pm >> DELETE FROM ps_specific_price WHERE id_product = '24198'
29/10/2025 02:33:41 pm >> INSERT INTO ps_product (
id_tax_rules_group , `date_add` , `date_upd`
) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '24198'
29/10/2025 02:33:41 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24199' , '1' , '' , 'nuovo-prodotto' )
29/10/2025 02:33:41 pm >> INSERT INTO ps_product_shop (
id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd`
) SELECT '24199' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '24198'
29/10/2025 02:33:41 pm >> INSERT INTO `ps_stock_available` (
id_product , id_product_attribute , id_shop , id_shop_group , quantity
) SELECT '24199' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '24198'
29/10/2025 02:34:30 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791256451005' AND id_product != '24199' AND ean13 != ''
29/10/2025 02:34:30 pm >> UPDATE ps_product SET
id_supplier = '',
reference = 'GONDOLA 2',
ean13 = '9791256451005',
date_upd = NOW()
WHERE id_product = '24199'
29/10/2025 02:34:30 pm >> UPDATE ps_product_lang SET
name = 'NATALE DEI SANTI E DEGLI ATEI - A. COMASTRI',
description = ''
WHERE id_product = '24199'
29/10/2025 02:34:30 pm >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '12'
WHERE id_product = '24199'
29/10/2025 02:34:30 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '12',
id_tax_rules_group = '4',
id_category_default = '518',
id_argoment_default = '39',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '24199'
29/10/2025 02:34:30 pm >> DELETE FROM ps_specific_price WHERE id_product = '24199'
29/10/2025 02:34:32 pm >> INSERT INTO ps_product (
id_tax_rules_group , `date_add` , `date_upd`
) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '24199'
29/10/2025 02:34:32 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24200' , '1' , '' , 'nuovo-prodotto' )
29/10/2025 02:34:32 pm >> INSERT INTO ps_product_shop (
id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd`
) SELECT '24200' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '24199'
29/10/2025 02:34:32 pm >> INSERT INTO `ps_stock_available` (
id_product , id_product_attribute , id_shop , id_shop_group , quantity
) SELECT '24200' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '24199'
29/10/2025 02:35:17 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791255950486' AND id_product != '24200' AND ean13 != ''
29/10/2025 02:35:17 pm >> UPDATE ps_product SET
id_supplier = '',
reference = '',
ean13 = '9791255950486',
date_upd = NOW()
WHERE id_product = '24200'
29/10/2025 02:35:17 pm >> UPDATE ps_product_lang SET
name = 'AVVENTURE SPAZIALI',
description = ''
WHERE id_product = '24200'
29/10/2025 02:35:17 pm >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '3.5'
WHERE id_product = '24200'
29/10/2025 02:35:17 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '3.5',
id_tax_rules_group = '4',
id_category_default = '57',
id_argoment_default = '39',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '24200'
29/10/2025 02:35:17 pm >> DELETE FROM ps_specific_price WHERE id_product = '24200'
29/10/2025 02:35:24 pm >> INSERT INTO ps_product (
id_tax_rules_group , `date_add` , `date_upd`
) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '24200'
29/10/2025 02:35:24 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24201' , '1' , '' , 'nuovo-prodotto' )
29/10/2025 02:35:24 pm >> INSERT INTO ps_product_shop (
id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd`
) SELECT '24201' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '24200'
29/10/2025 02:35:24 pm >> INSERT INTO `ps_stock_available` (
id_product , id_product_attribute , id_shop , id_shop_group , quantity
) SELECT '24201' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '24200'
29/10/2025 02:35:56 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788868948252' AND id_product != '24201' AND ean13 != ''
29/10/2025 02:35:56 pm >> UPDATE ps_product SET
id_supplier = '',
reference = '',
ean13 = '9788868948252',
date_upd = NOW()
WHERE id_product = '24201'
29/10/2025 02:35:56 pm >> UPDATE ps_product_lang SET
name = 'PORTA IL DONO',
description = ''
WHERE id_product = '24201'
29/10/2025 02:35:56 pm >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '2.8'
WHERE id_product = '24201'
29/10/2025 02:35:56 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '2.8',
id_tax_rules_group = '4',
id_category_default = '103',
id_argoment_default = '39',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '24201'
29/10/2025 02:35:56 pm >> DELETE FROM ps_specific_price WHERE id_product = '24201'
29/10/2025 02:47:59 pm >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'33' ,
'713807' ,
'2025-10-28' ,
'' ,
'0' ,
'7' ,
'2602' ,
'P. ZZA SAN PAOLO, 14 12051 ALBA' ,
'' ,
'' ,
'2.18' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'75.65' ,
'75.65' ,
NOW() ,
NOW() )
29/10/2025 02:47:59 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99554'
29/10/2025 02:47:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '99554'
29/10/2025 02:47:59 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99554' , '24196' , 'VANGELO A FUMETTI' , '1' , '1' , '4' ,
'25.00' , '25' , '0' , '35' , '16.2500' )
29/10/2025 02:47:59 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24196' AND id_supplier = '7'
29/10/2025 02:47:59 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24196' , '7' , '1' )
29/10/2025 02:47:59 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99554' , '24198' , 'NATALE SCOPRIAMOLO INSIEME - E. GIORDANO' , '1' , '1' , '4' ,
'4.90' , '4.9' , '0' , '30' , '3.4300' )
29/10/2025 02:47:59 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24198' AND id_supplier = '7'
29/10/2025 02:47:59 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24198' , '7' , '1' )
29/10/2025 02:47:59 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99554' , '24197' , 'PAROLA DI DIO OGNI GIORNO 2026 - V. PAGLIA' , '2' , '2' , '4' ,
'24.00' , '24' , '0' , '33' , '32.1600' )
29/10/2025 02:47:59 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24197' AND id_supplier = '7'
29/10/2025 02:47:59 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24197' , '7' , '1' )
29/10/2025 02:47:59 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99554' , '24201' , 'PORTA IL DONO' , '3' , '3' , '4' ,
'2.80' , '2.8' , '0' , '30' , '5.8800' )
29/10/2025 02:47:59 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24201' AND id_supplier = '7'
29/10/2025 02:47:59 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24201' , '7' , '1' )
29/10/2025 02:47:59 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99554' , '24200' , 'AVVENTURE SPAZIALI' , '3' , '3' , '4' ,
'3.50' , '3.5' , '0' , '30' , '7.3500' )
29/10/2025 02:47:59 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24200' AND id_supplier = '7'
29/10/2025 02:47:59 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24200' , '7' , '1' )
29/10/2025 02:47:59 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99554' , '24199' , 'NATALE DEI SANTI E DEGLI ATEI - A. COMASTRI' , '1' , '1' , '4' ,
'12.00' , '12' , '0' , '30' , '8.4000' )
29/10/2025 02:47:59 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24199' AND id_supplier = '7'
29/10/2025 02:47:59 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24199' , '7' , '1' )
29/10/2025 02:51:28 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884248695' AND id_product != '23737' AND ean13 != ''
29/10/2025 02:51:28 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '1/5',
ean13 = '9788884248695',
date_upd = NOW()
WHERE id_product = '23737'
29/10/2025 02:51:28 pm >> UPDATE ps_product_lang SET
name = 'CANTI LATINI DELLA CHIESA',
description = ''
WHERE id_product = '23737'
29/10/2025 02:51:28 pm >> UPDATE ps_product SET
wholesale_price = '7.00',
on_sale = '0',
price = '10.0000'
WHERE id_product = '23737'
29/10/2025 02:51:28 pm >> UPDATE ps_product_shop SET
wholesale_price = '7.00',
price = '10.0000',
id_tax_rules_group = '4',
id_category_default = '83',
id_argoment_default = '66',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '23737'
29/10/2025 02:51:28 pm >> DELETE FROM ps_specific_price WHERE id_product = '23737'
29/10/2025 03:00:47 pm >> SELECT document_num FROM ps_document
WHERE document_num = '3571' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-29')
29/10/2025 03:00:47 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' ,
'3571' ,
'2025-10-29' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'33.53' ,
'33.53' ,
NOW() ,
NOW() )
29/10/2025 03:00:47 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 = '99555'
29/10/2025 03:00:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '99555'
29/10/2025 03:00:47 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99555' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '35' , '-35' , '4' ,
'0.70' , '0.7' , '0' , '0' , '24.50' )
29/10/2025 03:00:47 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99555' , '24129' , 'DIECI COMANDAMENTI - M. DE ROSA' , '1' , '-1' , '4' ,
'6.00' , '6' , '0' , '5' , '5.70' )
29/10/2025 03:00:47 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99555' , '24057' , 'AVVENTO 2025' , '1' , '-1' , '4' ,
'3.5' , '3.5' , '0' , '5' , '3.33' )
29/10/2025 03:14:45 pm >> SELECT document_num FROM ps_document
WHERE document_num = '3572' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-29')
29/10/2025 03:14:46 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' ,
'3572' ,
'2025-10-29' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'4.75' ,
'4.75' ,
NOW() ,
NOW() )
29/10/2025 03:14:46 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 = '99556'
29/10/2025 03:14:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '99556'
29/10/2025 03:14:46 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99556' , '24022' , 'SULLA TUA PAROLA NOV/DIC 2025 - 531' , '1' , '-1' , '4' ,
'5.00' , '5' , '0' , '5' , '4.75' )
29/10/2025 03:59:45 pm >> SELECT document_num FROM ps_document
WHERE document_num = '3573' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-29')
29/10/2025 03:59:45 pm >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'3573' ,
'2025-10-29' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'15.40' ,
'13.69' ,
NOW() ,
NOW() )
29/10/2025 03:59:45 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99557'
29/10/2025 03:59:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '99557'
29/10/2025 03:59:45 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99557' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '1' , '-1' , '1' ,
'7.90' , '6.4754098360656' , '22' , '0' , '7.90' )
29/10/2025 03:59:45 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99557' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' ,
'3.50' , '3.3653846153846' , '4' , '0' , '3.50' )
29/10/2025 03:59:45 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99557' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' ,
'2.00' , '1.9230769230769' , '4' , '0' , '4.00' )
29/10/2025 04:24:16 pm >> SELECT document_num FROM ps_document
WHERE document_num = '3574' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-29')
29/10/2025 04:24:16 pm >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'3574' ,
'2025-10-29' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'14.35' ,
'14.35' ,
NOW() ,
NOW() )
29/10/2025 04:24:16 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99558'
29/10/2025 04:24:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '99558'
29/10/2025 04:24:16 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99558' , '24068' , 'MESSA MEDITAZIONE - NOV/DIC 25' , '1' , '-1' , '4' ,
'8.00' , '8' , '0' , '5' , '7.60' )
29/10/2025 04:24:16 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99558' , '24186' , 'DILEXI TE ' , '1' , '-1' , '4' ,
'2.00' , '2' , '0' , '0' , '2.00' )
29/10/2025 04:24:16 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99558' , '24022' , 'SULLA TUA PAROLA NOV/DIC 2025 - 531' , '1' , '-1' , '4' ,
'5.00' , '5' , '0' , '5' , '4.75' )
29/10/2025 04:40:48 pm >> SELECT document_num FROM ps_document
WHERE document_num = '175' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-10-29')
29/10/2025 04:40:48 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' ,
'175' ,
'2025-10-29' ,
'' ,
'540' ,
'0' ,
'4673023' ,
'CORSO GARIBALDI, 6 84025 EBOLI' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'1' ,
'0' ,
'40.00' ,
'40.00' ,
NOW() ,
NOW() )
29/10/2025 04:40:48 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 = '99559'
29/10/2025 04:40:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '99559'
29/10/2025 04:40:48 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99559' , '11097' , 'VANGELO E ATTI DEGLI APOSTOLI' , '10' , '-10' , '4' ,
'4' , '4' , '0' , '0' , '40.00' )
29/10/2025 04:52:05 pm >> SELECT document_num FROM ps_document
WHERE document_num = '3575' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-29')
29/10/2025 04:52:05 pm >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'3575' ,
'2025-10-29' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'90.00' ,
'73.77' ,
NOW() ,
NOW() )
29/10/2025 04:52: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 = '99560'
29/10/2025 04:52:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '99560'
29/10/2025 04:52: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
( '99560' , '15210' , 'CERO PASQUALE API 80X120' , '1' , '-1' , '1' ,
'90' , '73.770491803279' , '22' , '0' , '90.00' )
29/10/2025 05:08:20 pm >> SELECT document_num FROM ps_document
WHERE document_num = '3442' AND id_document != '99374' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-21')
29/10/2025 05:08:20 pm >> UPDATE ps_document SET
id_document_type = '11',
document_num = '3442',
document_date = '2025-10-21',
document_letter = '',
id_customer = '0',
id_supplier = '',
id_address = '0',
address1 = '',
address2 = '',
note = '',
price_shipping = '0.00',
id_tax_shipping_rules = '4',
colli = '0',
peso = '0',
porto_e_imballo = '0',
mezzo_consegna = '',
id_payment = '0',
id_causal = '0',
price_tax_included = '74.00',
price_tax_excluded = '60.66',
date_upd = NOW()
WHERE id_document = '99374'
29/10/2025 05:08:20 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 = '99374'
29/10/2025 05:08:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '99374'
29/10/2025 05:08:20 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99374' , '15387' , 'VESTINA BATTESIMALE ' , '1' , '-1' , '1' ,
'3.0000' , '2.4590163934426' , '22' , '0' , '3.00' )
29/10/2025 05:08:20 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99374' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '1' , '-1' , '1' ,
'13.0000' , '10.655737704918' , '22' , '0' , '13.00' )
29/10/2025 05:08:20 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99374' , '19748' , 'CORONA D\'AVVENTO STELLE' , '1' , '-1' , '1' ,
'23' , '18.852459016393' , '22' , '0' , '23.00' )
29/10/2025 05:08:20 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99374' , '11384' , 'VINO BIANCO DOLCE - 102' , '5' , '-5' , '1' ,
'7' , '5.7377049180328' , '22' , '0' , '35.00' )
29/10/2025 05:09:30 pm >> SELECT document_num FROM ps_document
WHERE document_num = '3440' AND id_document != '99372' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-21')
29/10/2025 05:09:30 pm >> UPDATE ps_document SET
id_document_type = '11',
document_num = '3440',
document_date = '2025-10-21',
document_letter = '',
id_customer = '0',
id_supplier = '',
id_address = '0',
address1 = '',
address2 = '',
note = '',
price_shipping = '0.00',
id_tax_shipping_rules = '4',
colli = '0',
peso = '0',
porto_e_imballo = '0',
mezzo_consegna = '',
id_payment = '0',
id_causal = '0',
price_tax_included = '58.00',
price_tax_excluded = '47.54',
date_upd = NOW()
WHERE id_document = '99372'
29/10/2025 05:09: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 = '99372'
29/10/2025 05:09:30 pm >> DELETE FROM ps_document_detail WHERE id_document = '99372'
29/10/2025 05:09: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
( '99372' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' ,
'2' , '1.6393442622951' , '22' , '0' , '2.00' )
29/10/2025 05:09: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
( '99372' , '11384' , 'VINO BIANCO DOLCE - 102' , '7' , '-7' , '1' ,
'8' , '6.5573770491803' , '22' , '0' , '56.00' )
29/10/2025 05:11:56 pm >> SELECT document_num FROM ps_document
WHERE document_num = '3013' AND id_document != '98785' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-09-17')
29/10/2025 05:11:56 pm >> UPDATE ps_document SET
id_document_type = '11',
document_num = '3013',
document_date = '2025-09-17',
document_letter = '',
id_customer = '0',
id_supplier = '',
id_address = '0',
address1 = '',
address2 = '',
note = '',
price_shipping = '0.00',
id_tax_shipping_rules = '4',
colli = '0',
peso = '0',
porto_e_imballo = '0',
mezzo_consegna = '',
id_payment = '0',
id_causal = '0',
price_tax_included = '74.00',
price_tax_excluded = '60.66',
date_upd = NOW()
WHERE id_document = '98785'
29/10/2025 05:11: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 = '98785'
29/10/2025 05:11:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '98785'
29/10/2025 05:11: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
( '98785' , '12815' , 'LIBRO DEI CRESIMATI' , '1' , '-1' , '1' ,
'40.0000' , '32.786885245902' , '22' , '0' , '40.00' )
29/10/2025 05:11: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
( '98785' , '13338' , 'CORONA MM 6 VETRO CON SCATOLA - 0522' , '1' , '-1' , '1' ,
'3.0000' , '2.4590163934426' , '22' , '0' , '3.00' )
29/10/2025 05:11: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
( '98785' , '19150' , 'MOCCOLO 70X200' , '4' , '-4' , '1' ,
'7.75' , '6.3524590163934' , '22' , '0' , '31.00' )
29/10/2025 05:12:48 pm >> SELECT document_num FROM ps_document
WHERE document_num = '3320' AND id_document != '99190' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-11')
29/10/2025 05:12:48 pm >> UPDATE ps_document SET
id_document_type = '11',
document_num = '3320',
document_date = '2025-10-11',
document_letter = '',
id_customer = '0',
id_supplier = '',
id_address = '0',
address1 = '',
address2 = '',
note = '',
price_shipping = '0.00',
id_tax_shipping_rules = '4',
colli = '0',
peso = '0',
porto_e_imballo = '0',
mezzo_consegna = '',
id_payment = '0',
id_causal = '0',
price_tax_included = '186.00',
price_tax_excluded = '152.98',
date_upd = NOW()
WHERE id_document = '99190'
29/10/2025 05:12:48 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 = '99190'
29/10/2025 05:12:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '99190'
29/10/2025 05:12:48 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99190' , '16795' , 'LUMINO 5F ROSSO' , '336' , '-336' , '1' ,
'0.3000' , '0.24590163934426' , '22' , '0' , '100.80' )
29/10/2025 05:12:48 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99190' , '24126' , 'AGENDA DEVOZIONALE 2026 PREGAGENDA - 40829' , '1' , '-1' , '1' ,
'14.0000' , '11.475409836066' , '22' , '5' , '13.30' )
29/10/2025 05:12:48 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99190' , '24142' , 'DILEXI TE' , '1' , '-1' , '4' ,
'2.9000' , '2.9' , '0' , '0' , '2.90' )
29/10/2025 05:12:48 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99190' , '17617' , 'IMMAGINI ISONZO X 100' , '2' , '-2' , '1' ,
'3.5000' , '2.8688524590164' , '22' , '0' , '7.00' )
29/10/2025 05:12:48 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99190' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' ,
'3.0000' , '2.4590163934426' , '22' , '0' , '3.00' )
29/10/2025 05:12:48 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99190' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' ,
'10' , '8.1967213114754' , '22' , '0' , '10.00' )
29/10/2025 05:12:48 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99190' , '19099' , 'INCENSO A' , '1' , '-1' , '1' ,
'49.00' , '40.16393442623' , '22' , '0' , '49.00' )
29/10/2025 05:13:41 pm >> SELECT document_num FROM ps_document
WHERE document_num = '3403' AND id_document != '99318' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-17')
29/10/2025 05:13:41 pm >> UPDATE ps_document SET
id_document_type = '11',
document_num = '3403',
document_date = '2025-10-17',
document_letter = '',
id_customer = '0',
id_supplier = '',
id_address = '0',
address1 = '',
address2 = '',
note = '',
price_shipping = '0.00',
id_tax_shipping_rules = '4',
colli = '0',
peso = '0',
porto_e_imballo = '0',
mezzo_consegna = '',
id_payment = '0',
id_causal = '0',
price_tax_included = '80.00',
price_tax_excluded = '67.38',
date_upd = NOW()
WHERE id_document = '99318'
29/10/2025 05:13:41 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99318'
29/10/2025 05:13:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '99318'
29/10/2025 05:13:41 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99318' , '18603' , 'SANTA TERESA DAVILA - G. MAZZOTTA' , '1' , '-1' , '4' ,
'10.0000' , '10' , '0' , '0' , '10.00' )
29/10/2025 05:13:41 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99318' , '22968' , 'TURIBOLO H10' , '2' , '-2' , '1' ,
'16.0000' , '13.114754098361' , '22' , '0' , '32.00' )
29/10/2025 05:13:41 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99318' , '2164' , 'CLERGY BASIC EXTRA - ML - B&P' , '1' , '-1' , '1' ,
'38' , '31.147540983607' , '22' , '0' , '38.00' )
29/10/2025 05:14:38 pm >> SELECT document_num FROM ps_document
WHERE document_num = '51' AND id_document != '89370' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2023-12-06')
29/10/2025 05:14:38 pm >> UPDATE ps_document SET
id_document_type = '24',
document_num = '51',
document_date = '2023-12-06',
document_letter = '',
id_customer = '4068',
id_supplier = '',
id_address = '4679214',
address1 = 'VIA DEI TRIBUNALI 316 80138 NAPOLI',
address2 = 'Biblioteca prof. Giuseppe Lazzaro in Santa Maria ad Martyres\r\nv. Adriano Falvo - 84127 Salerno\r\n',
note = '',
price_shipping = '0.00',
id_tax_shipping_rules = '4',
colli = '0',
peso = '0',
porto_e_imballo = '0',
mezzo_consegna = '',
id_payment = '0',
id_causal = '0',
price_tax_included = '2596.00',
price_tax_excluded = '2596.00',
date_upd = NOW()
WHERE id_document = '89370'
29/10/2025 05:14:38 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 = '89370'
29/10/2025 05:14:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '89370'
29/10/2025 05:14:38 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '89370' , '1886' , 'CELEBRIAMO CON GIOIA 3A EDIZ. - A. SORRENTINO' , '1' , '-1' , '4' ,
'25.0000' , '25' , '0' , '0' , '25.00' )
29/10/2025 05:14:38 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '89370' , '19727' , 'LITURGIA IN FRAMMENTI - A. SORRENTINO' , '1' , '-1' , '4' ,
'35.0000' , '35' , '0' , '0' , '35.00' )
29/10/2025 05:14:38 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '89370' , '18950' , 'DOV\'E\' FINITO IL CONCILIO? - F. CERRI' , '1' , '-1' , '4' ,
'18.0000' , '18' , '0' , '0' , '18.00' )
29/10/2025 05:14:38 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '89370' , '20876' , 'HO DATO LORO LA TUA PAROLA - A/B/C - G. VALSECCHI' , '1' , '-1' , '4' ,
'20.0000' , '20' , '0' , '0' , '20.00' )
29/10/2025 05:14:38 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '89370' , '18657' , 'HO DATO LORO LA TUA PAROLA - TEMPI FORTI- G. VALSECCHI' , '1' , '-1' , '4' ,
'16.0000' , '16' , '0' , '0' , '16.00' )
29/10/2025 05:14:38 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '89370' , '18906' , 'MI CHIAMERANNO BEATA - G. VALSECCHI' , '1' , '-1' , '4' ,
'10.0000' , '10' , '0' , '0' , '10.00' )
29/10/2025 05:14:38 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '89370' , '19088' , 'TU SOLO IL SANTO - G. VALSECCHI' , '1' , '-1' , '4' ,
'10.0000' , '10' , '0' , '0' , '10.00' )
29/10/2025 05:14:38 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '89370' , '19361' , 'LITANIE LAURETANE - M. DE ROSA' , '1' , '-1' , '4' ,
'12.0000' , '12' , '0' , '0' , '12.00' )
29/10/2025 05:14:38 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '89370' , '17827' , 'ISTRUZIONI FAMILIARI VOL. I - IL CREDO ' , '1' , '-1' , '4' ,
'20.0000' , '20' , '0' , '0' , '20.00' )
29/10/2025 05:14:38 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '89370' , '18717' , 'ISTRUZIONI FAMILIARI VOL. II - I DIECI COMANDAMENTI ' , '1' , '-1' , '4' ,
'20.0000' , '20' , '0' , '0' , '20.00' )
29/10/2025 05:14:38 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '89370' , '19391' , 'ISTRUZIONI FAMILIARI VOL. III - I PRECETTI...' , '1' , '-1' , '4' ,
'20.0000' , '20' , '0' , '0' , '20.00' )
29/10/2025 05:14:38 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '89370' , '21799' , 'ISTRUZIONI FAMILIARI VOL. IV - I VIZI E I SCARAMENTI' , '1' , '-1' , '4' ,
'25.0000' , '25' , '0' , '0' , '25.00' )
29/10/2025 05:14:38 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '89370' , '19562' , 'SAN CESARE DE BUS. UNA VITA PER LA CATECHESI ' , '1' , '-1' , '4' ,
'20.0000' , '20' , '0' , '0' , '20.00' )
29/10/2025 05:14:38 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '89370' , '18491' , 'UNA STORIA CHE SALVA VOL. 1' , '1' , '-1' , '4' ,
'9.0000' , '9' , '0' , '0' , '9.00' )
29/10/2025 05:14:38 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '89370' , '18492' , 'UNA STORIA CHE SALVA VOL. 2' , '1' , '-1' , '4' ,
'9.0000' , '9' , '0' , '0' , '9.00' )
29/10/2025 05:14:38 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '89370' , '18493' , 'UNA STORIA CHE SALVA VOL. 3' , '1' , '-1' , '4' ,
'9.0000' , '9' , '0' , '0' , '9.00' )
29/10/2025 05:14:38 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '89370' , '10645' , 'TI AMO PER SEMPRE' , '1' , '-1' , '4' ,
'12.0000' , '12' , '0' , '0' , '12.00' )
29/10/2025 05:14: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
( '89370' , '3978' , 'EUCARISTIA: RITO E VITA' , '1' , '-1' , '4' ,
'10.0000' , '10' , '0' , '0' , '10.00' )
29/10/2025 05:14: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
( '89370' , '1883' , 'CELEBRAZIONI PER L\'ANNO PASTORALE' , '1' , '-1' , '4' ,
'11.0000' , '11' , '0' , '0' , '11.00' )
29/10/2025 05:14: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
( '89370' , '1882' , 'CELEBRAZIONI PER L\'ANNO CATECHISTICO' , '1' , '-1' , '4' ,
'10.0000' , '10' , '0' , '0' , '10.00' )
29/10/2025 05:14: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
( '89370' , '14223' , 'PRONTUARIO BIBLICO - LITURGICO - F. GIGLIO' , '1' , '-1' , '4' ,
'9.0000' , '9' , '0' , '0' , '9.00' )
29/10/2025 05:14: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
( '89370' , '14260' , 'CUORE CHE BATTE - TORNARE AD AMARE IL CREATO' , '1' , '-1' , '4' ,
'8.0000' , '8' , '0' , '0' , '8.00' )
29/10/2025 05:14: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
( '89370' , '10364' , 'SULLA STRADA DEL MAESTRO' , '1' , '-1' , '4' ,
'14.0000' , '14' , '0' , '0' , '14.00' )
29/10/2025 05:14: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
( '89370' , '3511' , 'DIO PARLA ALL\'UOMO' , '1' , '-1' , '4' ,
'12.0000' , '12' , '0' , '0' , '12.00' )
29/10/2025 05:14: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
( '89370' , '17117' , 'MADRE DEL SIGNORE - M. VIANI' , '1' , '-1' , '4' ,
'15.0000' , '15' , '0' , '0' , '15.00' )
29/10/2025 05:14: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
( '89370' , '20951' , 'STORIE DEL NOSTRO TEMPO - F. CERRI' , '1' , '-1' , '4' ,
'15.0000' , '15' , '0' , '0' , '15.00' )
29/10/2025 05:14: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
( '89370' , '20954' , 'TEMPO DELL’APOCALISSE ' , '1' , '-1' , '4' ,
'15.0000' , '15' , '0' , '0' , '15.00' )
29/10/2025 05:14: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
( '89370' , '5643' , 'LEGGERE,... LA PAROLA - ANNO A' , '1' , '-1' , '4' ,
'10.0000' , '10' , '0' , '0' , '10.00' )
29/10/2025 05:14: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
( '89370' , '5644' , 'LEGGERE,... LA PAROLA - ANNO B' , '1' , '-1' , '4' ,
'10.0000' , '10' , '0' , '0' , '10.00' )
29/10/2025 05:14: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
( '89370' , '5645' , 'LEGGERE,... LA PAROLA - ANNO C' , '1' , '-1' , '4' ,
'10.0000' , '10' , '0' , '0' , '10.00' )
29/10/2025 05:14: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
( '89370' , '1001' , 'BEATO CHI ASCOLTA... - ANNO A - B. PREVITALI' , '1' , '-1' , '4' ,
'12.0000' , '12' , '0' , '0' , '12.00' )
29/10/2025 05:14: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
( '89370' , '1002' , 'BEATO CHI ASCOLTA... - ANNO B - B. PREVITALI' , '1' , '-1' , '4' ,
'12.0000' , '12' , '0' , '0' , '12.00' )
29/10/2025 05:14: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
( '89370' , '1003' , 'BEATO CHI ASCOLTA... - ANNO C - B. PREVITALI ' , '1' , '-1' , '4' ,
'12.0000' , '12' , '0' , '0' , '12.00' )
29/10/2025 05:14: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
( '89370' , '18497' , 'BUONA DOMENICA - ANNO A - G. BAGET BOZZO' , '1' , '-1' , '4' ,
'16.0000' , '16' , '0' , '0' , '16.00' )
29/10/2025 05:14: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
( '89370' , '18498' , 'BUONA DOMENICA - ANNO B - G. BAGET BOZZO' , '1' , '-1' , '4' ,
'16.0000' , '16' , '0' , '0' , '16.00' )
29/10/2025 05:14: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
( '89370' , '18499' , 'BUONA DOMENICA - ANNO C - G. BAGET BOZZO' , '1' , '-1' , '4' ,
'16.0000' , '16' , '0' , '0' , '16.00' )
29/10/2025 05:14: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
( '89370' , '8974' , 'RIFORMA DELLA RIFORMA - A. SORRENTINO' , '1' , '-1' , '4' ,
'15.0000' , '15' , '0' , '0' , '15.00' )
29/10/2025 05:14: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
( '89370' , '1873' , 'CELEBRARE LA PAROLA - ANNO B' , '1' , '-1' , '4' ,
'10.0000' , '10' , '0' , '0' , '10.00' )
29/10/2025 05:14: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
( '89370' , '18052' , 'CONVERSAZIONI CON MADRE TERESA - GJERGJI' , '1' , '-1' , '4' ,
'12.0000' , '12' , '0' , '0' , '12.00' )
29/10/2025 05:14: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
( '89370' , '15115' , 'CONVERSIONE - G. CELENTANO' , '1' , '-1' , '4' ,
'15.0000' , '15' , '0' , '0' , '15.00' )
29/10/2025 05:14: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
( '89370' , '17630' , 'RACCONTI SOTTO L\'ALBERO - G. CELENTANO' , '1' , '-1' , '4' ,
'15.0000' , '15' , '0' , '0' , '15.00' )
29/10/2025 05:14: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
( '89370' , '18291' , 'DALLA DISPERAZIONE ALLA SPERANZA - N. SENATORE' , '1' , '-1' , '4' ,
'15.0000' , '15' , '0' , '0' , '15.00' )
29/10/2025 05:14: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
( '89370' , '18718' , 'TUA VOCE IN ME - FRA F. MARIA REA' , '1' , '-1' , '4' ,
'15.0000' , '15' , '0' , '0' , '15.00' )
29/10/2025 05:14: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
( '89370' , '15271' , 'TRAMONTO DI SETTEMBRE - V. FRANCIA' , '1' , '-1' , '4' ,
'10.0000' , '10' , '0' , '0' , '10.00' )
29/10/2025 05:14: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
( '89370' , '18036' , 'FERITE FERITOIE ' , '1' , '-1' , '4' ,
'8.0000' , '8' , '0' , '0' , '8.00' )
29/10/2025 05:14: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
( '89370' , '13137' , 'CON LA BIBBIA E IL CATECHISMO - S. LA PEGNA' , '1' , '-1' , '4' ,
'10.0000' , '10' , '0' , '0' , '10.00' )
29/10/2025 05:14: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
( '89370' , '17828' , 'ANGELO STRUFFOLINI - A.G. DIBISCEGLIA' , '1' , '-1' , '4' ,
'26.0000' , '26' , '0' , '0' , '26.00' )
29/10/2025 05:14: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
( '89370' , '1379' , 'BRUGNOLI MUSICISTA E COMPOSITORE' , '1' , '-1' , '4' ,
'9.0000' , '9' , '0' , '0' , '9.00' )
29/10/2025 05:14: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
( '89370' , '20721' , 'AVE MARIA - L. CALABRETTA' , '1' , '-1' , '4' ,
'4.5000' , '4.5' , '0' , '0' , '4.50' )
29/10/2025 05:14: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
( '89370' , '20720' , 'PADRE NOSTRO - L. CALABRETTA' , '1' , '-1' , '4' ,
'4.5000' , '4.5' , '0' , '0' , '4.50' )
29/10/2025 05:14: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
( '89370' , '21644' , 'INCONTRO AL DIO CHE VIENE' , '1' , '-1' , '4' ,
'8.0000' , '8' , '0' , '0' , '8.00' )
29/10/2025 05:14: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
( '89370' , '20786' , 'GIUSEPPE DI NAZARET - M. VIANI' , '1' , '-1' , '4' ,
'10.0000' , '10' , '0' , '0' , '10.00' )
29/10/2025 05:14: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
( '89370' , '19050' , 'VENITE ADORIAMO - G. D\'AMORE' , '1' , '-1' , '4' ,
'7.0000' , '7' , '0' , '0' , '7.00' )
29/10/2025 05:14: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
( '89370' , '20231' , 'PREGANDO NON SPRECATE PAROLE - G. D\'AMORE' , '1' , '-1' , '4' ,
'10.0000' , '10' , '0' , '0' , '10.00' )
29/10/2025 05:14:40 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '89370' , '19119' , 'PSICOLOGIA PRATICA PER EDUCATORI' , '1' , '-1' , '4' ,
'10.5000' , '10.5' , '0' , '0' , '10.50' )
29/10/2025 05:14:40 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '89370' , '14330' , '100 GIORNI CON LO SPIRITO' , '1' , '-1' , '4' ,
'7.5000' , '7.5' , '0' , '0' , '7.50' )
29/10/2025 05:14:40 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '89370' , '9253' , 'SACRA BIBBIA CEI - UELCI' , '1' , '-1' , '4' ,
'18.5000' , '18.5' , '0' , '0' , '18.50' )
29/10/2025 05:14:40 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '89370' , '9996' , 'SIGNORE, TI PREGO' , '1' , '-1' , '4' ,
'6.0000' , '6' , '0' , '0' , '6.00' )
29/10/2025 05:14:40 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '89370' , '8562' , 'PROMESSE DEL SACRO CUORE DI GESÙ' , '1' , '-1' , '4' ,
'6.5000' , '6.5' , '0' , '0' , '6.50' )
29/10/2025 05:14:40 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '89370' , '17488' , 'STELLA IL CAMMINO IL BAMBINO - L. EPICOCO' , '1' , '-1' , '4' ,
'15.0000' , '15' , '0' , '0' , '15.00' )
29/10/2025 05:14:40 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '89370' , '10299' , 'STORIA DI UN\'ANIMA - 8203' , '1' , '-1' , '4' ,
'10.0000' , '10' , '0' , '0' , '10.00' )
29/10/2025 05:14:40 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '89370' , '10060' , 'SOLO I MALATI GUARISCONO - L. EPICOCO' , '1' , '-1' , '4' ,
'10.0000' , '10' , '0' , '0' , '10.00' )
29/10/2025 05:14:40 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '89370' , '21512' , 'VANGELO DI OGNI DOMENICA - MARCO - PAPA FRANCESCO' , '1' , '-1' , '4' ,
'15.0000' , '15' , '0' , '0' , '15.00' )
29/10/2025 05:14:40 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '89370' , '22004' , 'PREGHIERA DEL CRISTIANO - C.M. MARTINI' , '1' , '-1' , '4' ,
'12.0000' , '12' , '0' , '0' , '12.00' )
29/10/2025 05:14:40 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '89370' , '16019' , 'MARTA, MARIA E LAZZARO - L. EPICOCO' , '1' , '-1' , '4' ,
'10.0000' , '10' , '0' , '0' , '10.00' )
29/10/2025 05:14:40 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '89370' , '20804' , 'AFFIDABILI STORIE DI DONNE - L. EPICOCO' , '1' , '-1' , '4' ,
'12.0000' , '12' , '0' , '0' , '12.00' )
29/10/2025 05:14:40 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '89370' , '21116' , 'LIBERTA\' DI ANTONIO - L. EPICOCO' , '1' , '-1' , '4' ,
'11.0000' , '11' , '0' , '0' , '11.00' )
29/10/2025 05:14:40 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '89370' , '17001' , 'SPERANZA NON E\' MORTA - L. EPICOCO' , '1' , '-1' , '4' ,
'12.0000' , '12' , '0' , '0' , '12.00' )
29/10/2025 05:14:40 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '89370' , '18261' , 'PIETRA SCARTATA - L. EPICOCO' , '1' , '-1' , '4' ,
'16.0000' , '16' , '0' , '0' , '16.00' )
29/10/2025 05:14:40 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '89370' , '21466' , 'UNA LUCE DI NOME CHIARA - B. BAFFETTI' , '1' , '-1' , '4' ,
'12.0000' , '12' , '0' , '0' , '12.00' )
29/10/2025 05:14:40 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '89370' , '15723' , 'TUTTI INSIEME SULLARCA' , '1' , '-1' , '4' ,
'10.0000' , '10' , '0' , '0' , '10.00' )
29/10/2025 05:14:40 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '89370' , '19513' , 'CARLO ACUTIS -DALLA PISTA .... - M. MUSOLINO' , '1' , '-1' , '4' ,
'12.9000' , '12.9' , '0' , '0' , '12.90' )
29/10/2025 05:14:40 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '89370' , '14728' , 'LIBRO DELLA GIUNGLA - R. KIPLING' , '1' , '-1' , '4' ,
'17.9000' , '17.9' , '0' , '0' , '17.90' )
29/10/2025 05:14:40 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '89370' , '14830' , 'PICCOLA RENNA' , '1' , '-1' , '4' ,
'8.0000' , '8' , '0' , '0' , '8.00' )
29/10/2025 05:14:40 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '89370' , '16442' , 'CARLO ACUTIS L\'AMICO DI GESU\' - 8865' , '1' , '-1' , '4' ,
'7.0000' , '7' , '0' , '0' , '7.00' )
29/10/2025 05:14:40 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '89370' , '22016' , 'COMANDANTE ALFA' , '1' , '-1' , '4' ,
'12.0000' , '12' , '0' , '0' , '12.00' )
29/10/2025 05:14:40 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '89370' , '22036' , 'VANGELO DI GIOVANNI COMM. ESEGETICO' , '1' , '-1' , '4' ,
'65.0000' , '65' , '0' , '0' , '65.00' )
29/10/2025 05:14:40 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '89370' , '22039' , 'VANGELO DI LUCA - G. ROSSE' , '1' , '-1' , '4' ,
'69.5000' , '69.5' , '0' , '0' , '69.50' )
29/10/2025 05:14:40 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '89370' , '4229' , 'FONTI FRANCESCANE - ED. MINOR' , '1' , '-1' , '4' ,
'32.0000' , '32' , '0' , '0' , '32.00' )
29/10/2025 05:14:40 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '89370' , '22044' , 'GIOVANNI - R.E. BROWN' , '1' , '-1' , '4' ,
'66.5000' , '66.5' , '0' , '0' , '66.50' )
29/10/2025 05:14:40 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '89370' , '22043' , 'MATTEO - R. FABRIS' , '1' , '-1' , '4' ,
'48.0000' , '48' , '0' , '0' , '48.00' )
29/10/2025 05:14:40 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '89370' , '22017' , 'UOMO DI DIO - A. SCHNEIDER' , '1' , '-1' , '4' ,
'19.0000' , '19' , '0' , '0' , '19.00' )
29/10/2025 05:14:40 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '89370' , '16884' , 'ARTE DI GUARIRE - F. ROSINI' , '1' , '-1' , '4' ,
'18.0000' , '18' , '0' , '0' , '18.00' )
29/10/2025 05:14:40 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '89370' , '22057' , 'SEQUELA CHRISTI - C.M. MARTINI' , '1' , '-1' , '4' ,
'10.0000' , '10' , '0' , '0' , '10.00' )
29/10/2025 05:14:40 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '89370' , '19737' , 'CARLO MARIA MARTINI - L. PACOMIO' , '1' , '-1' , '4' ,
'15.0000' , '15' , '0' , '0' , '15.00' )
29/10/2025 05:14:40 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '89370' , '13917' , 'VANGELO DI MARCO - S. FAUSTI' , '1' , '-1' , '4' ,
'32.0000' , '32' , '0' , '0' , '32.00' )
29/10/2025 05:14:40 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '89370' , '17864' , 'MESSALE QUOTIDIANO GRANDE - N. E. ' , '1' , '-1' , '4' ,
'52.0000' , '52' , '0' , '0' , '52.00' )
29/10/2025 05:14:40 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '89370' , '22126' , 'CANTARE LA LITURGIA VOL 2' , '1' , '-1' , '4' ,
'8.5000' , '8.5' , '0' , '0' , '8.50' )
29/10/2025 05:14:41 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '89370' , '22125' , 'CANTARE LA LITURGIA VOL 1' , '1' , '-1' , '4' ,
'8.5000' , '8.5' , '0' , '0' , '8.50' )
29/10/2025 05:14:41 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '89370' , '21660' , 'PREGHIERA SEMINA GIOIA' , '1' , '-1' , '4' ,
'15.0000' , '15' , '0' , '0' , '15.00' )
29/10/2025 05:14:41 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '89370' , '20151' , 'CODICE DI DIRITTO CANONICO - 8 EDIZ.' , '1' , '-1' , '4' ,
'99.0000' , '99' , '0' , '0' , '99.00' )
29/10/2025 05:14:41 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '89370' , '22274' , 'CANTO DEL TRIDUO PASQUALE - S. MILITELLO' , '1' , '-1' , '4' ,
'20.0000' , '20' , '0' , '0' , '20.00' )
29/10/2025 05:14:41 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '89370' , '22128' , 'ORGANISTA NELLA LITURGIA - V. DI GRIGOLI' , '1' , '-1' , '4' ,
'14.0000' , '14' , '0' , '0' , '14.00' )
29/10/2025 05:14:41 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '89370' , '22272' , 'MUSICA E LA BELLEZZA DI DIO - B. FORTE' , '1' , '-1' , '4' ,
'10.0000' , '10' , '0' , '0' , '10.00' )
29/10/2025 05:14:41 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '89370' , '10064' , 'SOLO L\'AMORE CREA - F. ROSINI' , '1' , '-1' , '4' ,
'14.0000' , '14' , '0' , '0' , '14.00' )
29/10/2025 05:14:41 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '89370' , '22186' , 'VANGELO DI MARCO - MASCILONGO' , '1' , '-1' , '4' ,
'65.0000' , '65' , '0' , '0' , '65.00' )
29/10/2025 05:14:41 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '89370' , '20621' , 'ANNUNCIATORI DELLA PAROLA... - OPERA OMNIA - RATZINGER' , '1' , '-1' , '4' ,
'55.0000' , '55' , '0' , '0' , '55.00' )
29/10/2025 05:14:41 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '89370' , '22329' , 'DOGMI - M. FEDOU' , '1' , '-1' , '4' ,
'15.0000' , '15' , '0' , '0' , '15.00' )
29/10/2025 05:14:41 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '89370' , '18196' , 'LO HOBBIT' , '1' , '-1' , '4' ,
'13.0000' , '13' , '0' , '0' , '13.00' )
29/10/2025 05:14:41 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '89370' , '21668' , 'ALFABETO DI DIO - G. RAVASI' , '1' , '-1' , '4' ,
'20.0000' , '20' , '0' , '0' , '20.00' )
29/10/2025 05:14:41 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '89370' , '22058' , 'TEOLOGIA LITURGICA DEI SACRAMENTI - A. MIRALLES' , '1' , '-1' , '4' ,
'30.0000' , '30' , '0' , '0' , '30.00' )
29/10/2025 05:14:41 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '89370' , '22334' , 'DIO LA SCIENZA DELLE PROVE' , '1' , '-1' , '4' ,
'24.9000' , '24.9' , '0' , '0' , '24.90' )
29/10/2025 05:14:41 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '89370' , '17862' , 'DALL\'INFORMATICA AL CIELO C. ACUTIS - N. GORI' , '1' , '-1' , '4' ,
'12.0000' , '12' , '0' , '0' , '12.00' )
29/10/2025 05:14:41 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '89370' , '3419' , 'DIARIO LA MISERICORDIA DIVINA - S. FAUSTINA K.' , '1' , '-1' , '4' ,
'13.0000' , '13' , '0' , '0' , '13.00' )
29/10/2025 05:14:41 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '89370' , '20889' , 'GABRIELE PIETRO AMORTH - M. LANZA' , '1' , '-1' , '4' ,
'14.0000' , '14' , '0' , '0' , '14.00' )
29/10/2025 05:14:41 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '89370' , '22668' , 'DIAVOLO RICONOSCERLO E VINCERLO - G. AMORT' , '1' , '-1' , '4' ,
'12.0000' , '12' , '0' , '0' , '12.00' )
29/10/2025 05:14:41 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '89370' , '22773' , 'DONO E IL COMPITO DEL CULTO - A. GRILLO' , '1' , '-1' , '4' ,
'22.0000' , '22' , '0' , '0' , '22.00' )
29/10/2025 05:14:41 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '89370' , '19412' , 'FRANCESCO - COMMENTO AI VANGELI' , '1' , '-1' , '4' ,
'25.0000' , '25' , '0' , '0' , '25.00' )
29/10/2025 05:14:41 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '89370' , '11740' , 'BIBBIA DI GERUSALEMME - GIGANTE DA ALTARE' , '1' , '-1' , '4' ,
'115.0000' , '115' , '0' , '0' , '115.00' )
29/10/2025 05:14:41 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '89370' , '22564' , 'PAOLO E LEVANGELO DELLA SPERANZA' , '1' , '-1' , '4' ,
'22.0000' , '22' , '0' , '0' , '22.00' )
29/10/2025 05:14:41 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '89370' , '22395' , 'DA GERUSALEMME A ROMA - M. SODI' , '1' , '-1' , '4' ,
'18.0000' , '18' , '0' , '0' , '18.00' )
29/10/2025 05:14:41 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '89370' , '23174' , 'SERIAL KILLER' , '1' , '-1' , '4' ,
'12.5000' , '12.5' , '0' , '0' , '12.50' )
29/10/2025 05:14:41 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '89370' , '23173' , 'NOSTALGIA DEL SANGUE' , '1' , '-1' , '4' ,
'9.9000' , '9.9' , '0' , '0' , '9.90' )
29/10/2025 05:14:41 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '89370' , '17311' , 'CAMMINO DEL SILENZIO - A. GRUN' , '1' , '-1' , '4' ,
'5.0000' , '5' , '0' , '0' , '5.00' )
29/10/2025 05:14:41 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '89370' , '17310' , 'FORZA DI OGNI GIORNO - A. GRUN' , '1' , '-1' , '4' ,
'5.0000' , '5' , '0' , '0' , '5.00' )
29/10/2025 05:14:41 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '89370' , '17312' , 'UN TEMPO PER LANIMA - A GRUN' , '1' , '-1' , '4' ,
'5.0000' , '5' , '0' , '0' , '5.00' )
29/10/2025 05:14:41 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '89370' , '4229' , 'FONTI FRANCESCANE - ED. MINOR' , '1' , '-1' , '4' ,
'35.0000' , '35' , '0' , '0' , '35.00' )
29/10/2025 05:14:41 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '89370' , '17865' , 'MESSALE QUOTIDIANO - N. E.' , '1' , '-1' , '4' ,
'41.0000' , '41' , '0' , '0' , '41.00' )
29/10/2025 05:14:41 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '89370' , '1146' , 'BIBBIA DI GERUSALEMME X OCCASIONI ' , '1' , '-1' , '4' ,
'45.0000' , '45' , '0' , '0' , '45.00' )
29/10/2025 05:14:41 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '89370' , '5764' , 'LEZIONARIO FERIALE ANNO PARI - TEMPO ORDINARIO' , '1' , '-1' , '4' ,
'60.0000' , '60' , '0' , '0' , '60.00' )
29/10/2025 05:14:41 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '89370' , '7129' , 'NOVENE, OTTAVARI E UN SETTENARIO' , '1' , '-1' , '4' ,
'9.0000' , '9' , '0' , '0' , '9.00' )
29/10/2025 05:14:41 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '89370' , '21483' , 'BIBBIA - SCRUTATE - TELATA' , '1' , '-1' , '4' ,
'35.0000' , '35' , '0' , '0' , '35.00' )
29/10/2025 05:14:41 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '89370' , '22682' , 'GUIDATI DALLO SPIRITO - M. BELDA' , '1' , '-1' , '4' ,
'25.0000' , '25' , '0' , '0' , '25.00' )
29/10/2025 05:14:41 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '89370' , '7186' , 'NUOVO TESTAMENTO INTERLINEARE' , '1' , '-1' , '4' ,
'79.0000' , '79' , '0' , '0' , '79.00' )
29/10/2025 05:14:41 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '89370' , '11151' , 'LIBRI' , '1' , '-1' , '4' ,
'144.9' , '144.9' , '0' , '0' , '144.90' )
29/10/2025 05:14: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
( '89370' , '19179' , 'QOELET - S. CAROTTA' , '1' , '-1' , '4' ,
'14.00' , '14' , '0' , '0' , '14.00' )
29/10/2025 05:15:12 pm >> DELETE FROM ps_document WHERE id_document = '99472'
29/10/2025 05:15:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '99472'
29/10/2025 05:15:15 pm >> DELETE FROM ps_document WHERE id_document = '99455'
29/10/2025 05:15:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '99455'
29/10/2025 05:16:27 pm >> SELECT document_num FROM ps_document
WHERE document_num = '3300' AND id_document != '99164' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-10')
29/10/2025 05:16:27 pm >> UPDATE ps_document SET
id_document_type = '11',
document_num = '3300',
document_date = '2025-10-10',
document_letter = '',
id_customer = '0',
id_supplier = '',
id_address = '0',
address1 = '',
address2 = '',
note = '',
price_shipping = '0.00',
id_tax_shipping_rules = '4',
colli = '0',
peso = '0',
porto_e_imballo = '0',
mezzo_consegna = '',
id_payment = '0',
id_causal = '0',
price_tax_included = '299.10',
price_tax_excluded = '247.89',
date_upd = NOW()
WHERE id_document = '99164'
29/10/2025 05:16:27 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 = '99164'
29/10/2025 05:16:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '99164'
29/10/2025 05:16:27 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99164' , '16456' , 'CINGOLO - CING03' , '1' , '-1' , '1' ,
'15.0000' , '12.295081967213' , '22' , '0' , '15.00' )
29/10/2025 05:16:27 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99164' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' ,
'150' , '122.95081967213' , '22' , '0' , '150.00' )
29/10/2025 05:16:27 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99164' , '14088' , 'CAMICE IN MICROFIBRA - 429/PMA' , '1' , '-1' , '1' ,
'59.0000' , '48.360655737705' , '22' , '0' , '59.00' )
29/10/2025 05:16:27 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99164' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '15' , '-15' , '1' ,
'1.0000' , '0.81967213114754' , '22' , '0' , '15.00' )
29/10/2025 05:16:27 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99164' , '1749' , 'CARTUCCIA TRASPARENTE DIAM. 5 - 456 ' , '3' , '-3' , '1' ,
'15.0000' , '12.295081967213' , '22' , '0' , '45.00' )
29/10/2025 05:16:27 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99164' , '24142' , 'DILEXI TE' , '1' , '-1' , '4' ,
'2.9000' , '2.9' , '0' , '0' , '2.90' )
29/10/2025 05:16:27 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99164' , '11281' , 'VI PARLO DI ME - S. GEMMA GALGANI - 8581' , '1' , '-1' , '4' ,
'12.0000' , '12' , '0' , '5' , '11.40' )
29/10/2025 05:16:27 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99164' , '23807' , 'CALENDARIO LITURGICO 2026' , '1' , '-1' , '4' ,
'0.8000' , '0.8' , '0' , '0' , '0.80' )
29/10/2025 05:17:26 pm >> SELECT document_num FROM ps_document
WHERE document_num = '3340' AND id_document != '99214' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-13')
29/10/2025 05:17:26 pm >> UPDATE ps_document SET
id_document_type = '11',
document_num = '3340',
document_date = '2025-10-13',
document_letter = '',
id_customer = '0',
id_supplier = '',
id_address = '0',
address1 = '',
address2 = '',
note = '',
price_shipping = '0.00',
id_tax_shipping_rules = '4',
colli = '0',
peso = '0',
porto_e_imballo = '0',
mezzo_consegna = '',
id_payment = '0',
id_causal = '0',
price_tax_included = '386.30',
price_tax_excluded = '324.73',
date_upd = NOW()
WHERE id_document = '99214'
29/10/2025 05:17: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 = '99214'
29/10/2025 05:17:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '99214'
29/10/2025 05:17: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
( '99214' , '19716' , 'MEDAGLIA SAN BENEDETTO - Q1001-OX' , '97' , '-97' , '1' ,
'0.3000' , '0.24590163934426' , '22' , '0' , '29.10' )
29/10/2025 05:17: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
( '99214' , '19102' , 'CARBONCINI MM 40' , '2' , '-2' , '1' ,
'13.0000' , '10.655737704918' , '22' , '0' , '26.00' )
29/10/2025 05:17: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
( '99214' , '20220' , 'MEDAGLIA SAN BENEDETTO CM 2 - 400/n0217' , '1' , '-1' , '1' ,
'1.3000' , '1.0655737704918' , '22' , '0' , '1.30' )
29/10/2025 05:17: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
( '99214' , '23757' , 'MEDAGLIA SAN BENEDETTO - M244/A SM' , '10' , '-10' , '1' ,
'2.0000' , '1.6393442622951' , '22' , '0' , '20.00' )
29/10/2025 05:17: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
( '99214' , '7311' , 'OSTIA SOTTILE 74MM' , '20' , '-20' , '3' ,
'2.0000' , '1.9230769230769' , '4' , '0' , '40.00' )
29/10/2025 05:17: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
( '99214' , '24142' , 'DILEXI TE' , '2' , '-2' , '4' ,
'2.9000' , '2.9' , '0' , '0' , '5.80' )
29/10/2025 05:17: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
( '99214' , '23262' , 'COPRI LEGGIO AGNELLO - 61AGN' , '1' , '-1' , '1' ,
'150.0000' , '122.95081967213' , '22' , '0' , '150.00' )
29/10/2025 05:17: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
( '99214' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' ,
'100.0000' , '81.967213114754' , '22' , '0' , '100.00' )
29/10/2025 05:17: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
( '99214' , '23721' , 'BEATITUDINI - M. DE ROSA' , '1' , '-1' , '4' ,
'8.0000' , '8' , '0' , '5' , '7.60' )
29/10/2025 05:17: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
( '99214' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '6' , '-6' , '1' ,
'1' , '0.81967213114754' , '22' , '0' , '6.00' )
29/10/2025 05:17: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
( '99214' , '7940' , 'PERGAMENE - OCCASIONI MOD. A' , '1' , '-1' , '1' ,
'0.50' , '0.40983606557377' , '22' , '0' , '0.50' )
29/10/2025 05:18:09 pm >> SELECT document_num FROM ps_document
WHERE document_num = '3487' AND id_document != '99441' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-24')
29/10/2025 05:18:09 pm >> UPDATE ps_document SET
id_document_type = '11',
document_num = '3487',
document_date = '2025-10-24',
document_letter = '',
id_customer = '0',
id_supplier = '',
id_address = '0',
address1 = '',
address2 = '',
note = '',
price_shipping = '0.00',
id_tax_shipping_rules = '4',
colli = '0',
peso = '0',
porto_e_imballo = '0',
mezzo_consegna = '',
id_payment = '0',
id_causal = '0',
price_tax_included = '200.00',
price_tax_excluded = '189.68',
date_upd = NOW()
WHERE id_document = '99441'
29/10/2025 05:18:09 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99441'
29/10/2025 05:18:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '99441'
29/10/2025 05:18:09 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99441' , '5929' , 'LODI E VESPRI' , '20' , '-20' , '4' ,
'4.5000' , '4.5' , '0' , '5' , '85.60' )
29/10/2025 05:18:09 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99441' , '23916' , 'CE SPAZIO PER TE 2026 - 3-5 ANNI' , '1' , '-1' , '4' ,
'16.5000' , '16.5' , '0' , '0' , '16.50' )
29/10/2025 05:18:09 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99441' , '24076' , 'SAN CARLO ACUTIS - ARS 490' , '100' , '-100' , '1' ,
'0.1500' , '0.12295081967213' , '22' , '0' , '15.00' )
29/10/2025 05:18:09 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99441' , '23800' , 'MIA SPERANZA E IN TE- CD' , '1' , '-1' , '4' ,
'16.9000' , '16.9' , '0' , '0' , '16.90' )
29/10/2025 05:18:09 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99441' , '16603' , 'LIBRO INTENZIONI SANTE MESSE' , '1' , '-1' , '1' ,
'12.0000' , '9.8360655737705' , '22' , '5' , '11.40' )
29/10/2025 05:18:09 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99441' , '12849' , 'LIBRO DELLE SS. MESSE' , '1' , '-1' , '1' ,
'20.0000' , '16.393442622951' , '22' , '5' , '19.00' )
29/10/2025 05:18:09 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99441' , '24016' , 'UN ANNO CON GESU - DA TAVOLO' , '1' , '-1' , '1' ,
'3.0000' , '2.4590163934426' , '22' , '0' , '3.00' )
29/10/2025 05:18:10 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99441' , '23802' , 'MIA SPERANZA E IN TE - AGGIUNTA LIBRETTO' , '1' , '-1' , '4' ,
'4.5000' , '4.5' , '0' , '0' , '4.50' )
29/10/2025 05:18:10 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99441' , '23803' , 'MIA SPERANZA E IN TE - AGGIUNTA SPARTITI' , '1' , '-1' , '3' ,
'10.0000' , '9.6153846153846' , '4' , '0' , '10.00' )
29/10/2025 05:18:10 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99441' , '23931' , 'IO HO FATTO LA MIA PARTE 2026' , '1' , '-1' , '1' ,
'6.0000' , '4.9180327868852' , '22' , '5' , '5.70' )
29/10/2025 05:18:10 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99441' , '24096' , 'AVVENTO E NATALE 2025/26' , '1' , '-1' , '4' ,
'2.9000' , '2.9' , '0' , '5' , '2.76' )
29/10/2025 05:18:10 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99441' , '11151' , 'LIBRI' , '1' , '-1' , '4' ,
'2' , '2' , '0' , '0' , '2.00' )
29/10/2025 05:18:10 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99441' , '23920' , 'WORK IN PROGRESS ANNO A - EDUCATORI' , '1' , '-1' , '4' ,
'7.0000' , '7' , '0' , '5' , '6.65' )
29/10/2025 05:18:10 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99441' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' ,
'0.9900' , '0.81147540983607' , '22' , '0' , '0.99' )
29/10/2025 05:18:37 pm >> SELECT document_num FROM ps_document
WHERE document_num = '158' AND id_document != '99433' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-10-23')
29/10/2025 05:18:37 pm >> UPDATE ps_document SET
id_document_type = '21',
document_num = '158',
document_date = '2025-10-23',
document_letter = '',
id_customer = '65',
id_supplier = '',
id_address = '4679517',
address1 = 'VIA SAN MARCO 1 81016 CASTELLO DEL MATESE',
address2 = '',
note = '',
price_shipping = '3.23',
id_tax_shipping_rules = '4',
colli = '0',
peso = '0',
porto_e_imballo = '0',
mezzo_consegna = '',
id_payment = '6',
id_causal = '0',
price_tax_included = '80.00',
price_tax_excluded = '80.00',
date_upd = NOW()
WHERE id_document = '99433'
29/10/2025 05:18:37 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 = '99433'
29/10/2025 05:18:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '99433'
29/10/2025 05:18:37 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99433' , '24144' , 'LIBERI NELLA VERITA - M. DE MAIO' , '1' , '-1' , '4' ,
'36.0000' , '36' , '0' , '0' , '36.00' )
29/10/2025 05:18:37 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99433' , '13083' , 'LIBRI PREGHIERA PER I DEFUNTI' , '1' , '-1' , '4' ,
'2.0000' , '2' , '0' , '0' , '2.00' )
29/10/2025 05:18:37 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99433' , '23954' , 'SAN BARTOLO LONGO ' , '1' , '-1' , '4' ,
'10.0000' , '10' , '0' , '5' , '9.50' )
29/10/2025 05:18:37 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99433' , '17670' , 'NOVENA ALLA BEATA VERGINE ' , '1' , '-1' , '4' ,
'3.0000' , '3' , '0' , '5' , '2.85' )
29/10/2025 05:18:37 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99433' , '0' , 'IMMAGINI' , '1' , '-1' , '4' ,
'10.0000' , '10' , '0' , '0' , '10.00' )
29/10/2025 05:18:37 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99433' , '0' , 'IMMAGINI' , '1' , '-1' , '4' ,
'3.6000' , '3.6' , '0' , '0' , '3.60' )
29/10/2025 05:18:37 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99433' , '22805' , 'RESPIRO DELLA LODE - A. VENA' , '1' , '-1' , '4' ,
'13.5000' , '13.5' , '0' , '5' , '12.82' )
29/10/2025 06:00:35 pm >> INSERT INTO ps_customer
( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` )
VALUES
( '1' , '' , '' , '' , 'q81UjCaudr1Zracn' , NOW() , NOW() )
29/10/2025 06:00:35 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4270' , '1' )
29/10/2025 06:00:35 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4270' , '2' )
29/10/2025 06:00:35 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4270' , '3' )
29/10/2025 06:02:27 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4270'
29/10/2025 06:02:27 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 (
'4270' ,
'10' ,
'160' ,
'' ,
'MURRO' ,
'GIORGIA' ,
'VIA ROMA 17' ,
'' ,
'03040' ,
'PIGNATARO INTERAMNA' ,
'' ,
'' ,
'3932934491' ,
'' ,
'' ,
NOW() ,
NOW() )
29/10/2025 06:02:28 pm >> UPDATE ps_customer SET
email = 'giorgiamurro@gmail.com',
sdi = '',
pec = '',
date_upd = NOW()
WHERE id_customer = '4270'
29/10/2025 06:03:31 pm >> SELECT document_num FROM ps_document
WHERE document_num = '176' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-10-29')
29/10/2025 06:03:31 pm >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'21' ,
'176' ,
'2025-10-29' ,
'' ,
'4270' ,
'0' ,
'4679603' ,
'VIA ROMA 17 03040 PIGNATARO INTERAMNA' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'6' ,
'0' ,
'119.56' ,
'119.56' ,
NOW() ,
NOW() )
29/10/2025 06:03:31 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99561'
29/10/2025 06:03:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '99561'
29/10/2025 06:03:31 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99561' , '5444' , 'IO SONO CON VOI - CAT.' , '13' , '-13' , '4' ,
'5.50' , '5.5' , '0' , '0' , '71.50' )
29/10/2025 06:03:31 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99561' , '5457' , 'IO SONO CON VOI 1 PARTE' , '16' , '-16' , '4' ,
'2.80' , '2.8' , '0' , '5' , '42.56' )
29/10/2025 06:03:31 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99561' , '9676' , 'SARETE MIEI TESTIMONI - CAT.' , '1' , '-1' , '4' ,
'5.50' , '5.5' , '0' , '0' , '5.50' )
29/10/2025 06:47:04 pm >> SELECT document_num FROM ps_document
WHERE document_num = '3576' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-29')
29/10/2025 06:47:04 pm >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'3576' ,
'2025-10-29' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'20.00' ,
'20.00' ,
NOW() ,
NOW() )
29/10/2025 06:47:04 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99562'
29/10/2025 06:47:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '99562'
29/10/2025 06:47: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
( '99562' , '24186' , 'DILEXI TE ' , '10' , '-10' , '4' ,
'2.00' , '2' , '0' , '0' , '20.00' )
29/10/2025 06:47:37 pm >> SELECT document_num FROM ps_document
WHERE document_num = '3577' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-29')
29/10/2025 06:47:38 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' ,
'3577' ,
'2025-10-29' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'2.00' ,
'2.00' ,
NOW() ,
NOW() )
29/10/2025 06:47:38 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 = '99563'
29/10/2025 06:47:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '99563'
29/10/2025 06:47:38 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99563' , '19805' , 'DESIDERIO DESIDERAVI' , '1' , '-1' , '4' ,
'2.00' , '2' , '0' , '0' , '2.00' )
29/10/2025 06:50:41 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() )
29/10/2025 06:50:41 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24202' , '1' , '' , 'nuovo-prodotto' )
29/10/2025 06:50:41 pm >> INSERT INTO ps_product_shop (
id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd`
) VALUES (
'24202' , '1' , '1' , '2' , NOW() , NOW()
)
29/10/2025 06:50:41 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '24202' , '0' , '1' , '0' , '0' )
29/10/2025 06:53:07 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791280736628' AND id_product != '24202' AND ean13 != ''
29/10/2025 06:53:08 pm >> UPDATE ps_product SET
id_supplier = '',
reference = '6/2',
ean13 = '9791280736628',
date_upd = NOW()
WHERE id_product = '24202'
29/10/2025 06:53:08 pm >> UPDATE ps_product_lang SET
name = 'GRANDI DONNE E GRANDI SANTE',
description = 'Questo testo breve, agile, ma volutamente completo ripercorre la vicenda storica e di spiritualità sociale delle sorelle Cittadini: figure che hanno arricchito di santità la Chiesa bergamasca nella prima metà del secolo XIX. Lo Spirito Santo si è servito di due povere orfanelle, abbandonate dal padre e private della mamma - cresciute alla “scuola” di san Girolamo Emiliani - per farne due educatrici e maestre ricche di un autentico amore di madri, tanto da diventare “mamme” e guide alla vita per tante bambine e fanciulle della loro epoca, che non avrebbero avuto occasione di miglioria sociale e possibilità lavorativa.
'
WHERE id_product = '24202'
29/10/2025 06:53:08 pm >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '6'
WHERE id_product = '24202'
29/10/2025 06:53:08 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '6',
id_tax_rules_group = '4',
id_category_default = '395',
id_argoment_default = '71',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '24202'
29/10/2025 06:53:08 pm >> DELETE FROM ps_specific_price WHERE id_product = '24202'
29/10/2025 06:53:08 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' , '24202' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' )
29/10/2025 06:53:16 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791280736628' AND id_product != '24202' AND ean13 != ''
29/10/2025 06:53:16 pm >> UPDATE ps_product SET
id_supplier = '',
reference = '6/2',
ean13 = '9791280736628',
date_upd = NOW()
WHERE id_product = '24202'
29/10/2025 06:53:16 pm >> UPDATE ps_product_lang SET
name = 'GRANDI DONNE E GRANDI SANTE',
description = 'Questo testo breve, agile, ma volutamente completo ripercorre la vicenda storica e di spiritualità sociale delle sorelle Cittadini: figure che hanno arricchito di santità la Chiesa bergamasca nella prima metà del secolo XIX. Lo Spirito Santo si è servito di due povere orfanelle, abbandonate dal padre e private della mamma - cresciute alla “scuola” di san Girolamo Emiliani - per farne due educatrici e maestre ricche di un autentico amore di madri, tanto da diventare “mamme” e guide alla vita per tante bambine e fanciulle della loro epoca, che non avrebbero avuto occasione di miglioria sociale e possibilità lavorativa.
'
WHERE id_product = '24202'
29/10/2025 06:53:16 pm >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '6'
WHERE id_product = '24202'
29/10/2025 06:53:16 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '6',
id_tax_rules_group = '4',
id_category_default = '395',
id_argoment_default = '71',
id_internal_category = '4',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '24202'
29/10/2025 06:53:16 pm >> DELETE FROM ps_specific_price WHERE id_product = '24202'
29/10/2025 06:53:16 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' , '24202' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' )
29/10/2025 06:53:35 pm >> UPDATE ps_product_shop SET active = '1' WHERE id_product = '24202'
29/10/2025 07:33:59 pm >> SELECT document_num FROM ps_document
WHERE document_num = '3578' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-29')
29/10/2025 07:33:59 pm >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'3578' ,
'2025-10-29' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'4.75' ,
'4.75' ,
NOW() ,
NOW() )
29/10/2025 07:33:59 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99564'
29/10/2025 07:33:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '99564'
29/10/2025 07:33:59 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99564' , '24022' , 'SULLA TUA PAROLA NOV/DIC 2025 - 531' , '1' , '-1' , '4' ,
'5.00' , '5' , '0' , '5' , '4.75' )