14/04/2025 09:12:12 am >> SELECT document_num FROM ps_document
WHERE document_num = '1222' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-14')
14/04/2025 09:12:12 am >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'1222' ,
'2025-04-14' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'52.25' ,
'52.25' ,
NOW() ,
NOW() )
14/04/2025 09:12:12 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96662'
14/04/2025 09:12:12 am >> DELETE FROM ps_document_detail WHERE id_document = '96662'
14/04/2025 09:12:12 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96662' , '23536' , 'SULLA TUA PAROLA - MAG/GIU 25' , '11' , '-11' , '4' ,
'5.00' , '5' , '0' , '5' , '52.25' )
14/04/2025 09:17:15 am >> SELECT document_num FROM ps_document
WHERE document_num = '1223' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-14')
14/04/2025 09:17:15 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' ,
'1223' ,
'2025-04-14' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'33.25' ,
'33.25' ,
NOW() ,
NOW() )
14/04/2025 09:17:15 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96663'
14/04/2025 09:17:15 am >> DELETE FROM ps_document_detail WHERE id_document = '96663'
14/04/2025 09:17:15 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96663' , '22331' , 'BIBBIA DI GERUSALEMME - BOTTONE' , '1' , '-1' , '4' ,
'35.00' , '35' , '0' , '5' , '33.25' )
14/04/2025 09:25:03 am >> SELECT ean13 FROM ps_product WHERE ean13 = '000793' AND id_product != '1371' AND ean13 != ''
14/04/2025 09:25:03 am >> UPDATE ps_product SET
id_supplier = '12',
reference = '2016',
ean13 = '000793',
date_upd = NOW()
WHERE id_product = '1371'
14/04/2025 09:25:03 am >> UPDATE ps_product_lang SET
name = 'BRONZINA RIGHE VERT. CM 9 - 619',
description = ''
WHERE id_product = '1371'
14/04/2025 09:25:03 am >> UPDATE ps_product SET
wholesale_price = '3.33',
on_sale = '0',
price = '9.836065573770492'
WHERE id_product = '1371'
14/04/2025 09:25:03 am >> UPDATE ps_product_shop SET
wholesale_price = '3.33',
price = '9.836065573770492',
id_tax_rules_group = '1',
id_category_default = '147',
id_argoment_default = '42',
id_internal_category = '3',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '1371'
14/04/2025 09:25:03 am >> DELETE FROM ps_specific_price WHERE id_product = '1371'
14/04/2025 09:28:24 am >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'31' ,
'1207' ,
'2025-04-10' ,
'' ,
'0' ,
'12' ,
'2607' ,
'VIA NAZIONALE NORD, 4 - LAGARO 40035 CASTIGLIONE DEI PEPOLI' ,
'' ,
'' ,
'12' ,
'1' ,
'0' ,
'0' ,
'0' ,
'' ,
'9' ,
'0' ,
'572.12' ,
'468.95' ,
NOW() ,
NOW() )
14/04/2025 09:28:24 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96664'
14/04/2025 09:28:24 am >> DELETE FROM ps_document_detail WHERE id_document = '96664'
14/04/2025 09:28:24 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96664' , '539' , 'AMPOLLA RICAMBIO PER ART. 506 - 17' , '2' , '2' , '1' ,
'3' , '2.4590163934426' , '22' , '5' , '6.9540' )
14/04/2025 09:28:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '539' AND id_supplier = '12'
14/04/2025 09:28:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '539' , '12' , '1' )
14/04/2025 09:28:24 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96664' , '23605' , 'CALICE BAROCCO - 1887' , '2' , '2' , '1' ,
'139' , '113.93442622951' , '22' , '5' , '322.2020' )
14/04/2025 09:28:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '23605' AND id_supplier = '12'
14/04/2025 09:28:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23605' , '12' , '1' )
14/04/2025 09:28:24 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96664' , '16408' , 'AMPOLLE DORATE CON BECCUCCIO - 1503' , '1' , '1' , '1' ,
'34' , '27.868852459016' , '22' , '5' , '39.4060' )
14/04/2025 09:28:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '16408' AND id_supplier = '12'
14/04/2025 09:28:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16408' , '12' , '1' )
14/04/2025 09:28:24 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96664' , '18799' , 'PARAFIAMMA PIREX PER CARTUCCIA 4 CM - 474/30' , '4' , '4' , '1' ,
'5' , '4.0983606557377' , '22' , '5' , '23.1800' )
14/04/2025 09:28:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '18799' AND id_supplier = '12'
14/04/2025 09:28:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18799' , '12' , '1' )
14/04/2025 09:28:24 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96664' , '1371' , 'BRONZINA RIGHE VERT. CM 9 - 619' , '1' , '1' , '1' ,
'5' , '4.0983606557377' , '22' , '5' , '5.7950' )
14/04/2025 09:28:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '1371' AND id_supplier = '12'
14/04/2025 09:28:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1371' , '12' , '1' )
14/04/2025 09:28:24 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96664' , '538' , 'AMPOLLA RICAMBIO PER ART. 501/5 - 70' , '2' , '2' , '1' ,
'3' , '2.4590163934426' , '22' , '5' , '6.9540' )
14/04/2025 09:28:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '538' AND id_supplier = '12'
14/04/2025 09:28:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '538' , '12' , '1' )
14/04/2025 09:28:24 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96664' , '1370' , 'BROCCHETTE RICAMBIO PER ART. 523 - 500' , '1' , '1' , '1' ,
'6' , '4.9180327868852' , '22' , '5' , '6.9540' )
14/04/2025 09:28:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '1370' AND id_supplier = '12'
14/04/2025 09:28:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1370' , '12' , '1' )
14/04/2025 09:28:24 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96664' , '12578' , 'RICAMBIO VETRO PER ART. 486 - 65' , '4' , '4' , '1' ,
'7' , '5.7377049180328' , '22' , '5' , '32.4520' )
14/04/2025 09:28:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '12578' AND id_supplier = '12'
14/04/2025 09:28:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12578' , '12' , '1' )
14/04/2025 09:28:24 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96664' , '15000' , 'TECA ALTA IHS - 825' , '2' , '2' , '1' ,
'14' , '11.475409836066' , '22' , '5' , '32.4520' )
14/04/2025 09:28:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '15000' AND id_supplier = '12'
14/04/2025 09:28:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15000' , '12' , '1' )
14/04/2025 09:28:25 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96664' , '4696' , 'GLOBO PIREX DIAM. 3,5 COMPLETO - 89 ' , '10' , '10' , '1' ,
'3' , '2.4590163934426' , '22' , '5' , '34.7700' )
14/04/2025 09:28:25 am >> DELETE FROM ps_product_supplier WHERE id_product = '4696' AND id_supplier = '12'
14/04/2025 09:28:25 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4696' , '12' , '1' )
14/04/2025 09:28:25 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96664' , '23216' , 'CANDELA ELETTRICA - 326' , '10' , '10' , '1' ,
'4' , '3.2786885245902' , '22' , '5' , '46.3600' )
14/04/2025 09:28:25 am >> DELETE FROM ps_product_supplier WHERE id_product = '23216' AND id_supplier = '12'
14/04/2025 09:28:25 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23216' , '12' , '1' )
14/04/2025 09:49:17 am >> SELECT document_num FROM ps_document
WHERE document_num = '1224' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-14')
14/04/2025 09:49:17 am >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'1224' ,
'2025-04-14' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'5.00' ,
'4.10' ,
NOW() ,
NOW() )
14/04/2025 09:49:17 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96665'
14/04/2025 09:49:17 am >> DELETE FROM ps_document_detail WHERE id_document = '96665'
14/04/2025 09:49:17 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96665' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '20' , '-20' , '1' ,
'0.25' , '0.20491803278689' , '22' , '0' , '5.00' )
14/04/2025 09:59:08 am >> SELECT document_num FROM ps_document
WHERE document_num = '1225' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-14')
14/04/2025 09:59:08 am >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'1225' ,
'2025-04-14' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'16.00' ,
'13.11' ,
NOW() ,
NOW() )
14/04/2025 09:59:08 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96666'
14/04/2025 09:59:08 am >> DELETE FROM ps_document_detail WHERE id_document = '96666'
14/04/2025 09:59:08 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96666' , '19106' , 'FRAGRANZA NARDO' , '1' , '-1' , '1' ,
'16.00' , '13.114754098361' , '22' , '0' , '16.00' )
14/04/2025 10:06:34 am >> SELECT document_num FROM ps_document
WHERE document_num = '1226' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-14')
14/04/2025 10:06:34 am >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'1226' ,
'2025-04-14' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'123.41' ,
'104.48' ,
NOW() ,
NOW() )
14/04/2025 10:06:34 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96667'
14/04/2025 10:06:34 am >> DELETE FROM ps_document_detail WHERE id_document = '96667'
14/04/2025 10:06:34 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96667' , '19363' , 'CERO MINIATO 80X100' , '1' , '-1' , '1' ,
'105.00' , '86.065573770492' , '22' , '0' , '105.00' )
14/04/2025 10:06:34 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96667' , '23590' , 'SAN CARLO ACUTIS - U. DE VANNA' , '1' , '-1' , '4' ,
'9.90' , '9.9' , '0' , '5' , '9.41' )
14/04/2025 10:06:34 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96667' , '23666' , 'CARLO ACUTIS SENZA DI LUI' , '5' , '-5' , '4' ,
'1.80' , '1.8' , '0' , '0' , '9.00' )
14/04/2025 10:32:12 am >> SELECT document_num FROM ps_document
WHERE document_num = '1227' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-14')
14/04/2025 10:32:13 am >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'1227' ,
'2025-04-14' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'375.07' ,
'310.33' ,
NOW() ,
NOW() )
14/04/2025 10:32:13 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96668'
14/04/2025 10:32:13 am >> DELETE FROM ps_document_detail WHERE id_document = '96668'
14/04/2025 10:32:13 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96668' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '3' , '-3' , '1' ,
'28.00' , '22.950819672131' , '22' , '0' , '84.00' )
14/04/2025 10:32:13 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96668' , '1631' , 'CANDELINE NON GOCCIOLANTI ' , '2' , '-2' , '1' ,
'27.5' , '22.540983606557' , '22' , '0' , '55.00' )
14/04/2025 10:32:13 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96668' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' ,
'2.00' , '1.9230769230769' , '4' , '0' , '4.00' )
14/04/2025 10:32:13 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96668' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' , '-2' , '3' ,
'3.50' , '3.3653846153846' , '4' , '0' , '7.00' )
14/04/2025 10:32:13 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96668' , '8728' , 'QUARESIMA SPIEGATA AI BAMBINI' , '1' , '-1' , '4' ,
'3.90' , '3.9' , '0' , '5' , '3.71' )
14/04/2025 10:32:13 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96668' , '7682' , 'PASQUA SPIEGATA AI BAMBINI ' , '1' , '-1' , '4' ,
'3.90' , '3.9' , '0' , '5' , '3.71' )
14/04/2025 10:32:13 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96668' , '19107' , 'INCENSO GRANI 3A - BUSTA' , '1' , '-1' , '1' ,
'30.00' , '24.590163934426' , '22' , '0' , '30.00' )
14/04/2025 10:32:13 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96668' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '1' , '-1' , '1' ,
'13.00' , '10.655737704918' , '22' , '0' , '13.00' )
14/04/2025 10:32:13 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96668' , '19102' , 'CARBONCINI MM 40' , '1' , '-1' , '1' ,
'13.00' , '10.655737704918' , '22' , '0' , '13.00' )
14/04/2025 10:32:13 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96668' , '17617' , 'IMMAGINI ISONZO X 100' , '5' , '-5' , '1' ,
'3.33' , '2.7295081967213' , '22' , '0' , '16.65' )
14/04/2025 10:32:13 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96668' , '23262' , 'COPRI LEGGIO AGNELLO - 61AGN' , '1' , '-1' , '1' ,
'145.00' , '118.85245901639' , '22' , '0' , '145.00' )
14/04/2025 10:32:47 am >> SELECT document_num FROM ps_document
WHERE document_num = '1228' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-14')
14/04/2025 10:32:47 am >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'1228' ,
'2025-04-14' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'98.00' ,
'80.33' ,
NOW() ,
NOW() )
14/04/2025 10:32:47 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96669'
14/04/2025 10:32:47 am >> DELETE FROM ps_document_detail WHERE id_document = '96669'
14/04/2025 10:32:47 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96669' , '23216' , 'CANDELA ELETTRICA - 326' , '10' , '-10' , '1' ,
'9.8' , '8.0327868852459' , '22' , '0' , '98.00' )
14/04/2025 10:35:23 am >> SELECT document_num FROM ps_document
WHERE document_num = '1229' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-14')
14/04/2025 10:35:23 am >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'1229' ,
'2025-04-14' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'53.50' ,
'43.85' ,
NOW() ,
NOW() )
14/04/2025 10:35:23 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96670'
14/04/2025 10:35:23 am >> DELETE FROM ps_document_detail WHERE id_document = '96670'
14/04/2025 10:35:23 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96670' , '19771' , 'ROSARIO ARGENTO/EMATITE - 1931CAV' , '1' , '-1' , '1' ,
'37.50' , '30.737704918033' , '22' , '0' , '37.50' )
14/04/2025 10:35:23 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96670' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' ,
'16' , '13.114754098361' , '22' , '0' , '16.00' )
14/04/2025 10:40:55 am >> SELECT document_num FROM ps_document
WHERE document_num = '1230' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-14')
14/04/2025 10:40:55 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' ,
'1230' ,
'2025-04-14' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'215.00' ,
'177.44' ,
NOW() ,
NOW() )
14/04/2025 10:40:55 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96671'
14/04/2025 10:40:55 am >> DELETE FROM ps_document_detail WHERE id_document = '96671'
14/04/2025 10:40:55 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96671' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' ,
'3.60' , '2.9508196721311' , '22' , '0' , '3.60' )
14/04/2025 10:40:55 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96671' , '19147' , 'CANDELINE NON GOCCIOLANTI GRECHE' , '1' , '-1' , '1' ,
'17.90' , '14.672131147541' , '22' , '0' , '17.90' )
14/04/2025 10:40:55 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96671' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' ,
'2.00' , '1.9230769230769' , '4' , '0' , '4.00' )
14/04/2025 10:40:55 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96671' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' ,
'4.50' , '4.3269230769231' , '4' , '0' , '4.50' )
14/04/2025 10:40:55 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96671' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '1' , '-1' , '1' ,
'28.00' , '22.950819672131' , '22' , '0' , '28.00' )
14/04/2025 10:40:55 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96671' , '11756' , 'VINO BIANCO SECCO - 14%' , '6' , '-6' , '1' ,
'6.5' , '5.327868852459' , '22' , '0' , '39.00' )
14/04/2025 10:40:55 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96671' , '15210' , 'CERO PASQUALE API 80X120' , '1' , '-1' , '1' ,
'90' , '73.770491803279' , '22' , '0' , '90.00' )
14/04/2025 10:40:55 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96671' , '19107' , 'INCENSO GRANI 3A - BUSTA' , '1' , '-1' , '1' ,
'28' , '22.950819672131' , '22' , '0' , '28.00' )
14/04/2025 10:42:48 am >> SELECT document_num FROM ps_document
WHERE document_num = '62/A' AND id_document != '96479' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-04-02')
14/04/2025 10:42:48 am >> UPDATE ps_document SET
id_document_type = '24',
document_num = '62/A',
document_date = '2025-04-02',
document_letter = 'A',
id_customer = '1213',
id_supplier = '',
id_address = '4679403',
address1 = 'VIA MARCONI 115 83025 MONTORO INFERIORE',
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 = '605.20',
price_tax_excluded = '591.64',
date_upd = NOW()
WHERE id_document = '96479'
14/04/2025 10:42:48 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96479'
14/04/2025 10:42:48 am >> DELETE FROM ps_document_detail WHERE id_document = '96479'
14/04/2025 10:42:48 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96479' , '0' , 'OSTENSORIO' , '1' , '-1' , '0' ,
'530.0000' , '530' , '0' , '0' , '530.00' )
14/04/2025 10:42:48 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96479' , '' , '14/04' , '1' , '-1' , '0' ,
'0' , '0' , '' , '0' , '0' )
14/04/2025 10:42:48 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96479' , '10687' , 'TORCIA A VENTO ' , '4' , '-4' , '1' ,
'4.30' , '3.5245901639344' , '22' , '0' , '17.20' )
14/04/2025 10:42:48 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96479' , '20757' , 'VIA CRUCIS - IMMAGINI 35X50' , '1' , '-1' , '1' ,
'30.00' , '24.590163934426' , '22' , '0' , '30.00' )
14/04/2025 10:42:48 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96479' , '' , 'GRANI INCENSO' , '1' , '-1' , '1' ,
'13' , '10.655737704918' , '22' , '0' , '13.00' )
14/04/2025 10:42:48 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96479' , '' , 'GRANI INCENSO' , '1' , '-1' , '1' ,
'15' , '12.295081967213' , '22' , '0' , '15.00' )
14/04/2025 10:46:23 am >> SELECT document_num FROM ps_document
WHERE document_num = '62/A' AND id_document != '96479' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-04-02')
14/04/2025 10:46:23 am >> UPDATE ps_document SET
id_document_type = '24',
document_num = '62/A',
document_date = '2025-04-02',
document_letter = 'A',
id_customer = '1213',
id_supplier = '',
id_address = '4679403',
address1 = 'VIA MARCONI 115 83025 MONTORO INFERIORE',
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 = '600.20',
price_tax_excluded = '587.54',
date_upd = NOW()
WHERE id_document = '96479'
14/04/2025 10:46:23 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96479'
14/04/2025 10:46:23 am >> DELETE FROM ps_document_detail WHERE id_document = '96479'
14/04/2025 10:46:23 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96479' , '0' , 'OSTENSORIO' , '1' , '-1' , '0' ,
'530.0000' , '530' , '0' , '0' , '530.00' )
14/04/2025 10:46:23 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96479' , '0' , '14/04' , '1' , '-1' , '0' ,
'0.0000' , '0' , '0' , '0' , '0.00' )
14/04/2025 10:46:23 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96479' , '10687' , 'TORCIA A VENTO ' , '4' , '-4' , '1' ,
'4.3000' , '3.5245901639344' , '22' , '0' , '17.20' )
14/04/2025 10:46:23 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96479' , '20757' , 'VIA CRUCIS - IMMAGINI 35X50' , '1' , '-1' , '1' ,
'25' , '20.491803278689' , '22' , '0' , '25.00' )
14/04/2025 10:46:23 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96479' , '0' , 'GRANI INCENSO' , '1' , '-1' , '1' ,
'13.0000' , '10.655737704918' , '22' , '0' , '13.00' )
14/04/2025 10:46:23 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96479' , '0' , 'GRANI INCENSO' , '1' , '-1' , '1' ,
'15.0000' , '12.295081967213' , '22' , '0' , '15.00' )
14/04/2025 11:09:46 am >> SELECT document_num FROM ps_document
WHERE document_num = '11' AND id_document != '96070' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2025-03-06')
14/04/2025 11:09:46 am >> UPDATE ps_document SET
id_document_type = '24',
document_num = '11',
document_date = '2025-03-06',
document_letter = '',
id_customer = '0',
id_supplier = '',
id_address = '2602',
address1 = 'P. ZZA SAN PAOLO, 14 12051 ALBA',
address2 = '',
note = 'RESA - n. c. ricevuta',
price_shipping = '0.00',
id_tax_shipping_rules = '4',
colli = '0',
peso = '0',
porto_e_imballo = '0',
mezzo_consegna = '',
id_payment = '0',
id_causal = '9',
price_tax_included = '2435.10',
price_tax_excluded = '2399.74',
date_upd = NOW()
WHERE id_document = '96070'
14/04/2025 11:09:46 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96070'
14/04/2025 11:09:46 am >> DELETE FROM ps_document_detail WHERE id_document = '96070'
14/04/2025 11:09:46 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '8480' , 'PRIMA COMUNIONE' , '9' , '-9' , '4' ,
'5.0000' , '5' , '0' , '0' , '45.00' )
14/04/2025 11:09:46 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '8502' , 'PRIMA RICONCILIAZIONE - GUIDA ' , '1' , '-1' , '4' ,
'7.0000' , '7' , '0' , '0' , '7.00' )
14/04/2025 11:09:46 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '5158' , 'IN CAMMINO VERSO LA CONFERMAZIONE - SUSS.' , '1' , '-1' , '4' ,
'4.5000' , '4.5' , '0' , '0' , '4.50' )
14/04/2025 11:09:46 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '5161' , 'IN CAMMINO VERSO LEUCARISTIA' , '2' , '-2' , '4' ,
'3.5000' , '3.5' , '0' , '0' , '7.00' )
14/04/2025 11:09:46 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '5165' , 'IN CAMMINO VERSO LA FESTA DEL PERDONO' , '4' , '-4' , '4' ,
'3.0000' , '3' , '0' , '0' , '12.00' )
14/04/2025 11:09:46 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '5166' , 'IN CAMMINO VERSO LA FESTA DEL PERDONO - GUIDA' , '1' , '-1' , '4' ,
'8.0000' , '8' , '0' , '0' , '8.00' )
14/04/2025 11:09:46 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '5163' , 'IN CAMMINO VERSO LEUCARISTIA - GUIDA' , '1' , '-1' , '4' ,
'15.0000' , '15' , '0' , '0' , '15.00' )
14/04/2025 11:09:46 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '4253' , 'FORZA PIÙ GRANDE - GUGLIELMONI/NEGRI' , '1' , '-1' , '4' ,
'8.5000' , '8.5' , '0' , '0' , '8.50' )
14/04/2025 11:09:46 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '1976' , 'CHE SVOLTA - DON A. CATTANEO - FRA E. COVIELLO' , '2' , '-2' , '4' ,
'4.9000' , '4.9' , '0' , '0' , '9.80' )
14/04/2025 11:09:46 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '5249' , 'INCONTRI DI GIOIA - GUIDA' , '1' , '-1' , '4' ,
'10.0000' , '10' , '0' , '0' , '10.00' )
14/04/2025 11:09:46 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '8484' , 'PRIMA COMUNIONE - GUIDA -' , '2' , '-2' , '4' ,
'7.0000' , '7' , '0' , '0' , '14.00' )
14/04/2025 11:09:46 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '12625' , 'COLORIAMO LA NOSTRA MESSA' , '12' , '-12' , '4' ,
'3.9000' , '3.9' , '0' , '0' , '46.80' )
14/04/2025 11:09:46 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '23202' , 'CHIAMATA - C. DALESIO' , '1' , '-1' , '4' ,
'12.0000' , '12' , '0' , '0' , '12.00' )
14/04/2025 11:09:46 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '21710' , 'LI UDIAMO PARLARE NELLE NOSTRE LINGUE ' , '1' , '-1' , '4' ,
'12.9000' , '12.9' , '0' , '0' , '12.90' )
14/04/2025 11:09:46 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '423' , 'ALTRE STORIE - B. FERRERO' , '1' , '-1' , '4' ,
'9.9000' , '9.9' , '0' , '0' , '9.90' )
14/04/2025 11:09:46 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '16975' , 'CATECHESI OGGI' , '1' , '-1' , '4' ,
'13.0000' , '13' , '0' , '0' , '13.00' )
14/04/2025 11:09:46 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '16701' , 'NELLA VIGNETTA DEL SIGNORE - BERTI/GALLIANI' , '1' , '-1' , '4' ,
'15.0000' , '15' , '0' , '0' , '15.00' )
14/04/2025 11:09:46 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '16945' , 'NELLA VIGNETTA DEL SIGNORE' , '1' , '-1' , '4' ,
'16.0000' , '16' , '0' , '0' , '16.00' )
14/04/2025 11:09:46 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '14764' , 'MIO PRIMO LIBRO DEI SANTI' , '1' , '-1' , '4' ,
'10.0000' , '10' , '0' , '0' , '10.00' )
14/04/2025 11:09:46 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '13375' , 'MESSA PRONTI? VIA! - C. PELLEGRINO' , '1' , '-1' , '4' ,
'10.9000' , '10.9' , '0' , '0' , '10.90' )
14/04/2025 11:09:46 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '19699' , 'NOI CI STIAMO - R. SALA' , '1' , '-1' , '4' ,
'8.0000' , '8' , '0' , '0' , '8.00' )
14/04/2025 11:09:46 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '13854' , 'QUELLO CHE I GENITORI NON DICONO - G. MICHELINI' , '1' , '-1' , '4' ,
'9.0000' , '9' , '0' , '0' , '9.00' )
14/04/2025 11:09:46 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '13879' , 'FORTISSIMI GIOVANI - P. PELLEGRINO' , '2' , '-2' , '4' ,
'2.9000' , '2.9' , '0' , '0' , '5.80' )
14/04/2025 11:09:46 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '18268' , 'RELIGIONI - FABRIS/MANTOVANI' , '1' , '-1' , '4' ,
'4.5000' , '4.5' , '0' , '0' , '4.50' )
14/04/2025 11:09:47 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '22877' , 'OH, MAMMA CELESTE! - F. CRISTOFARO' , '21' , '-21' , '4' ,
'15.0000' , '15' , '0' , '0' , '315.00' )
14/04/2025 11:09:47 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '16011' , 'SACRAMENTI' , '2' , '-2' , '4' ,
'4.9000' , '4.9' , '0' , '0' , '9.80' )
14/04/2025 11:09:47 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '8953' , 'RICONCILIAZIONE RACCONTATA AI BAMBINI' , '2' , '-2' , '4' ,
'5.0000' , '5' , '0' , '0' , '10.00' )
14/04/2025 11:09:47 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '14905' , 'TI DONO IL PANE CHE NUTRE IL CUORE' , '1' , '-1' , '4' ,
'7.0000' , '7' , '0' , '0' , '7.00' )
14/04/2025 11:09:47 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '13827' , 'GIOIA DI DIO - PRIMA CONFESSIONE' , '1' , '-1' , '4' ,
'6.0000' , '6' , '0' , '0' , '6.00' )
14/04/2025 11:09:47 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '14904' , 'TI DONO UN CUORE NUOVO' , '1' , '-1' , '4' ,
'7.0000' , '7' , '0' , '0' , '7.00' )
14/04/2025 11:09:47 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '14805' , 'BATTESIMO - POSTER' , '1' , '-1' , '4' ,
'3.0000' , '3' , '0' , '0' , '3.00' )
14/04/2025 11:09:47 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '10623' , 'TESTIMONI DI GEOVA - POSTER' , '1' , '-1' , '4' ,
'2.0000' , '2' , '0' , '0' , '2.00' )
14/04/2025 11:09:47 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '4411' , 'GESÙ CRISTO FIGLIO DI DIO - POSTER' , '2' , '-2' , '4' ,
'1.8000' , '1.8' , '0' , '0' , '3.60' )
14/04/2025 11:09:47 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '18116' , 'HO INCONTRATO GESU - POSTER' , '1' , '-1' , '4' ,
'1.9000' , '1.9' , '0' , '0' , '1.90' )
14/04/2025 11:09:47 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '19421' , 'DIO CON NOI - POSTER' , '1' , '-1' , '4' ,
'1.9000' , '1.9' , '0' , '0' , '1.90' )
14/04/2025 11:09:47 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '11440' , 'VITA DI GESÙ DA COLORARE' , '1' , '-1' , '4' ,
'4.9000' , '4.9' , '0' , '0' , '4.90' )
14/04/2025 11:09:47 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '13965' , 'QUESTI SONO I NOMI... - BENZI/ROSSI' , '1' , '-1' , '4' ,
'13.0000' , '13' , '0' , '0' , '13.00' )
14/04/2025 11:09:47 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '14186' , 'E AMORE - AAVV' , '1' , '-1' , '4' ,
'13.0000' , '13' , '0' , '0' , '13.00' )
14/04/2025 11:09:47 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '22524' , 'SCONOSCIUTE 50 DONNE DELLA BIBBIA - A. BIANCHI' , '1' , '-1' , '4' ,
'13.0000' , '13' , '0' , '0' , '13.00' )
14/04/2025 11:09:47 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '16016' , 'UNA GIOIA PROVATA - E. BORSOTTI' , '1' , '-1' , '4' ,
'25.0000' , '25' , '0' , '0' , '25.00' )
14/04/2025 11:09:47 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '12886' , 'DIO NESSUNO LO HA MAI VISTO - TRAGAN/PERRONI' , '1' , '-1' , '4' ,
'35.0000' , '35' , '0' , '0' , '35.00' )
14/04/2025 11:09:47 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '16021' , 'BUONA BATTAGLIA - P. MOROCUTTI' , '1' , '-1' , '4' ,
'12.0000' , '12' , '0' , '0' , '12.00' )
14/04/2025 11:09:47 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '18645' , 'AMICO DEI PECCATORI - ZAMPAGLIONE/MALODIA' , '1' , '-1' , '4' ,
'10.0000' , '10' , '0' , '0' , '10.00' )
14/04/2025 11:09:47 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '23105' , 'VIAGGIO IN UNA NOTTE STELLATA - E. DREONI' , '1' , '-1' , '4' ,
'12.0000' , '12' , '0' , '0' , '12.00' )
14/04/2025 11:09:47 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '20198' , 'CON MARIA VERSO LA GROTTA DI BETLEMME - L. FANZAGA' , '1' , '-1' , '4' ,
'12.0000' , '12' , '0' , '0' , '12.00' )
14/04/2025 11:09:47 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '21743' , 'CAMMINANDO VERSO IL PRESEPE - E. FORTUNATO' , '1' , '-1' , '4' ,
'12.0000' , '12' , '0' , '0' , '12.00' )
14/04/2025 11:09:47 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '21005' , 'ARCA DI NOE' , '3' , '-3' , '4' ,
'1.5000' , '1.5' , '0' , '0' , '4.50' )
14/04/2025 11:09:47 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '21006' , 'MOSE E MIRIAM' , '9' , '-9' , '4' ,
'1.5000' , '1.5' , '0' , '0' , '13.50' )
14/04/2025 11:09:47 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '21004' , 'CREAZIONE' , '4' , '-4' , '4' ,
'1.5000' , '1.5' , '0' , '0' , '6.00' )
14/04/2025 11:09:47 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '21016' , 'DAVIDE E GOLIA' , '7' , '-7' , '4' ,
'1.5000' , '1.5' , '0' , '0' , '10.50' )
14/04/2025 11:09:47 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '21009' , 'DANIELE E I LEONI' , '7' , '-7' , '4' ,
'1.5000' , '1.5' , '0' , '0' , '10.50' )
14/04/2025 11:09:47 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '21008' , 'GIONA E LA BALENA' , '6' , '-6' , '4' ,
'1.5000' , '1.5' , '0' , '0' , '9.00' )
14/04/2025 11:09:47 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '21010' , 'NATALE' , '8' , '-8' , '4' ,
'1.5000' , '1.5' , '0' , '0' , '12.00' )
14/04/2025 11:09:47 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '21011' , 'BUON SAMARITANO' , '7' , '-7' , '4' ,
'1.5000' , '1.5' , '0' , '0' , '10.50' )
14/04/2025 11:09:47 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '21012' , 'PECORELLA SMARRITA' , '2' , '-2' , '4' ,
'1.5000' , '1.5' , '0' , '0' , '3.00' )
14/04/2025 11:09:47 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '21014' , 'GESU E LA TEMPESTA' , '10' , '-10' , '4' ,
'1.5000' , '1.5' , '0' , '0' , '15.00' )
14/04/2025 11:09:47 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '21015' , 'PASQUA' , '7' , '-7' , '4' ,
'1.5000' , '1.5' , '0' , '0' , '10.50' )
14/04/2025 11:09:47 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '21013' , 'PADRE NOSTRO' , '8' , '-8' , '4' ,
'1.5000' , '1.5' , '0' , '0' , '12.00' )
14/04/2025 11:09:47 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '16005' , 'DOMANDE DI GESU - L. MONTI' , '1' , '-1' , '4' ,
'19.0000' , '19' , '0' , '0' , '19.00' )
14/04/2025 11:09:47 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '21783' , 'NATALE DEL CUORE - A.M. CANOPI' , '1' , '-1' , '4' ,
'15.0000' , '15' , '0' , '0' , '15.00' )
14/04/2025 11:09:47 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '20421' , 'DECORAZIONI DI NATALE' , '1' , '-1' , '4' ,
'4.5000' , '4.5' , '0' , '0' , '4.50' )
14/04/2025 11:09:48 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '23203' , 'STO ALLA PORTA E BUSSO' , '1' , '-1' , '4' ,
'6.9000' , '6.9' , '0' , '0' , '6.90' )
14/04/2025 11:09:48 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '23243' , 'NATALE PER SPERARE' , '2' , '-2' , '4' ,
'4.5000' , '4.5' , '0' , '0' , '9.00' )
14/04/2025 11:09:48 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '20100' , 'RE BAMBINO - S. FORNASARI' , '1' , '-1' , '4' ,
'14.0000' , '14' , '0' , '0' , '14.00' )
14/04/2025 11:09:48 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '1169' , 'BIBBIA LDC- ABU / CARTONATA' , '3' , '-3' , '4' ,
'19.0000' , '19' , '0' , '0' , '57.00' )
14/04/2025 11:09:48 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '1170' , 'BIBBIA LDC/ABU - MEDIA CON INSERTO' , '1' , '-1' , '4' ,
'14.9000' , '14.9' , '0' , '0' , '14.90' )
14/04/2025 11:09:48 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '11173' , 'VENERABILE FRANCESCO CHIESA' , '1' , '-1' , '4' ,
'3.5000' , '3.5' , '0' , '0' , '3.50' )
14/04/2025 11:09:48 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '23303' , 'PINO DANIELE - P. PERONA' , '1' , '-1' , '4' ,
'18.0000' , '18' , '0' , '0' , '18.00' )
14/04/2025 11:09:48 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '15546' , 'IN ASCOLTO DEL MAESTRO - M. ARAMINI' , '1' , '-1' , '4' ,
'14.0000' , '14' , '0' , '0' , '14.00' )
14/04/2025 11:09:48 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '20531' , 'MADRE DI DIO - AAVV' , '1' , '-1' , '4' ,
'22.0000' , '22' , '0' , '0' , '22.00' )
14/04/2025 11:09:48 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '18480' , 'LIBERATEVI! - P. PELLEGRINO ' , '1' , '-1' , '4' ,
'9.5000' , '9.5' , '0' , '0' , '9.50' )
14/04/2025 11:09:48 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '20040' , 'NONNA DARIA E NONNO PIENO ' , '1' , '-1' , '4' ,
'7.9000' , '7.9' , '0' , '0' , '7.90' )
14/04/2025 11:09:48 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '14662' , 'GRANDE LIBRO DEI NONNI' , '1' , '-1' , '4' ,
'25.0000' , '25' , '0' , '0' , '25.00' )
14/04/2025 11:09:48 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '2512' , 'COMMENTARIO AL NUOVO TESTAMENTO VOL. I - K. BERGER' , '1' , '-1' , '4' ,
'73.0000' , '73' , '0' , '0' , '73.00' )
14/04/2025 11:09:48 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '21828' , 'VANGELO DI GESU ' , '1' , '-1' , '4' ,
'3.1000' , '3.1' , '0' , '0' , '3.10' )
14/04/2025 11:09:48 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '1179' , 'BIBBIA PER IL CATECHISMO' , '2' , '-2' , '4' ,
'3.9000' , '3.9' , '0' , '0' , '7.80' )
14/04/2025 11:09:48 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '23255' , 'MARIA DONNA DI SPERANZA - GALIAZZO/RAMINA' , '1' , '-1' , '4' ,
'20.0000' , '20' , '0' , '0' , '20.00' )
14/04/2025 11:09:48 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '23254' , 'UN NATALE INCONTENIBILE - A. SCHWARZ' , '1' , '-1' , '4' ,
'12.0000' , '12' , '0' , '0' , '12.00' )
14/04/2025 11:09:48 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '20533' , 'TORNIAMO ALLE SORGENTI - D. BATTAGLIA' , '1' , '-1' , '4' ,
'10.0000' , '10' , '0' , '0' , '10.00' )
14/04/2025 11:09:48 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '20252' , 'VANGELO DELLE BEATITUDINI - AAVV' , '1' , '-1' , '4' ,
'15.0000' , '15' , '0' , '0' , '15.00' )
14/04/2025 11:09:48 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '21536' , 'AIUTO! NEL MONDO STA SCOMPARENDO LAMORE - A. COMASTRI' , '1' , '-1' , '4' ,
'16.0000' , '16' , '0' , '0' , '16.00' )
14/04/2025 11:09:48 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '21396' , 'CRISTO NOSTRA VITA - A. BASILE' , '1' , '-1' , '4' ,
'20.0000' , '20' , '0' , '0' , '20.00' )
14/04/2025 11:09:48 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '22744' , 'LODE GUARISCE OGNI NOSTRO PATIRE - M. TEDOLDI' , '1' , '-1' , '4' ,
'10.0000' , '10' , '0' , '0' , '10.00' )
14/04/2025 11:09:48 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '20738' , 'PADRE PIO E RAFFAELINA CERASE' , '1' , '-1' , '4' ,
'10.0000' , '10' , '0' , '0' , '10.00' )
14/04/2025 11:09:48 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '8035' , 'PINO PUGLISI - PINO PUGLISI' , '1' , '-1' , '4' ,
'10.0000' , '10' , '0' , '0' , '10.00' )
14/04/2025 11:09:48 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '22131' , 'SAN FRANCESCO DI PAOLA - A. DE LORENZI' , '1' , '-1' , '4' ,
'16.0000' , '16' , '0' , '0' , '16.00' )
14/04/2025 11:09:48 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '17757' , 'AGATA STORIA DI UNA SANTA - F. MUSTICA' , '1' , '-1' , '4' ,
'15.0000' , '15' , '0' , '0' , '15.00' )
14/04/2025 11:09:48 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '20930' , 'LITURGIA FESTIVA DELLA PAROLA' , '1' , '-1' , '4' ,
'19.0000' , '19' , '0' , '0' , '19.00' )
14/04/2025 11:09:48 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '19236' , 'CATECHESI BIBLICHE SUI MISTERI DEL SANTO ROSARIO - M. ROMANO' , '1' , '-1' , '4' ,
'12.0000' , '12' , '0' , '0' , '12.00' )
14/04/2025 11:09:48 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '17367' , 'PRIMA SCUOLA DELLA VITA SPIRITUALE - G. MILITELLO' , '1' , '-1' , '4' ,
'15.0000' , '15' , '0' , '0' , '15.00' )
14/04/2025 11:09:48 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '22689' , 'UN GIOCO DAMORE - D. DE CAROLIS' , '1' , '-1' , '4' ,
'13.0000' , '13' , '0' , '0' , '13.00' )
14/04/2025 11:09:48 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '18923' , 'CI SARANNO SANTI TRA I BAMBINI' , '1' , '-1' , '4' ,
'11.0000' , '11' , '0' , '0' , '11.00' )
14/04/2025 11:09:48 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '22894' , 'PERCHE TU SIA FELICE... - S. CHIALA' , '1' , '-1' , '4' ,
'3.0000' , '3' , '0' , '0' , '3.00' )
14/04/2025 11:09:48 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '23127' , 'NASCE LA SPERANZA' , '1' , '-1' , '4' ,
'2.8000' , '2.8' , '0' , '0' , '2.80' )
14/04/2025 11:09:48 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '21836' , 'DONO PER TUTTI' , '4' , '-4' , '4' ,
'2.7000' , '2.7' , '0' , '0' , '10.80' )
14/04/2025 11:09:48 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '23156' , 'ACCOGLIAMO GESU' , '1' , '-1' , '4' ,
'2.5000' , '2.5' , '0' , '0' , '2.50' )
14/04/2025 11:09:48 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '23135' , 'SUSSIDIO AVVENTO E NATALE 2024/25 RAGAZZI' , '4' , '-4' , '4' ,
'2.5000' , '2.5' , '0' , '0' , '10.00' )
14/04/2025 11:09:48 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '23048' , 'DALLALBA AL TRAMONTO NOV 24' , '1' , '-1' , '4' ,
'3.2000' , '3.2' , '0' , '0' , '3.20' )
14/04/2025 11:09:48 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '22944' , 'SUI TUOI PASSI - ADORAZIONE' , '1' , '-1' , '4' ,
'3.8000' , '3.8' , '0' , '0' , '3.80' )
14/04/2025 11:09:48 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '23199' , 'VERBUM CARO FACTUM EST' , '9' , '-9' , '4' ,
'3.0000' , '3' , '0' , '0' , '27.00' )
14/04/2025 11:09:49 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
( '96070' , '22943' , 'AVVENTO 2024' , '6' , '-6' , '4' ,
'3.5000' , '3.5' , '0' , '0' , '21.00' )
14/04/2025 11:09:49 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
( '96070' , '23263' , 'SEI SPECIALE DI GESU - M. DE SANCTIS' , '1' , '-1' , '4' ,
'8.0000' , '8' , '0' , '0' , '8.00' )
14/04/2025 11:09:49 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
( '96070' , '8886' , 'RELIGIONI SPIEGATE AI BAMBINI' , '3' , '-3' , '4' ,
'3.5000' , '3.5' , '0' , '0' , '10.50' )
14/04/2025 11:09:49 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
( '96070' , '22816' , 'COMPAGNI DI VIAGGIO - M.R. MANALI' , '1' , '-1' , '4' ,
'16.0000' , '16' , '0' , '0' , '16.00' )
14/04/2025 11:09:49 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
( '96070' , '18205' , 'DIARIO DELLA FELICITA - 2' , '1' , '-1' , '4' ,
'10.0000' , '10' , '0' , '0' , '10.00' )
14/04/2025 11:09:49 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
( '96070' , '19697' , 'DIARIO DELLA FELICITA 3 ' , '1' , '-1' , '4' ,
'10.0000' , '10' , '0' , '0' , '10.00' )
14/04/2025 11:09:49 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
( '96070' , '22101' , 'DIARIO DELLA FELICITA 4' , '1' , '-1' , '4' ,
'12.0000' , '12' , '0' , '0' , '12.00' )
14/04/2025 11:09:49 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
( '96070' , '22771' , 'SUPERPOTERI DEGLI ANIMALI - DIARIO 2024/25' , '1' , '-1' , '4' ,
'8.9000' , '8.9' , '0' , '0' , '8.90' )
14/04/2025 11:09:49 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
( '96070' , '23065' , 'TU SEI SPECIALE - M. LUCADO' , '1' , '-1' , '4' ,
'16.0000' , '16' , '0' , '0' , '16.00' )
14/04/2025 11:09:49 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
( '96070' , '22209' , 'CANTO DEL PANE - E. RONCHI' , '1' , '-1' , '4' ,
'25.0000' , '25' , '0' , '0' , '25.00' )
14/04/2025 11:09:49 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
( '96070' , '21205' , 'MI AMI TU? - CD' , '1' , '-1' , '4' ,
'16.8000' , '16.8' , '0' , '0' , '16.80' )
14/04/2025 11:09:49 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
( '96070' , '11374' , 'VIENI SPIRITO DAMORE' , '1' , '-1' , '1' ,
'12.5000' , '10.245901639344' , '22' , '0' , '12.50' )
14/04/2025 11:09:49 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
( '96070' , '15143' , 'REGOLIAMOCI' , '1' , '-1' , '1' ,
'10.0000' , '8.1967213114754' , '22' , '0' , '10.00' )
14/04/2025 11:09:49 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
( '96070' , '16807' , 'AMICI A TEMPO DI MUSICA - G. LOCURATOLO' , '1' , '-1' , '1' ,
'12.5000' , '10.245901639344' , '22' , '0' , '12.50' )
14/04/2025 11:09:49 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
( '96070' , '15232' , 'CIURMA DEI BULLI' , '1' , '-1' , '1' ,
'12.5000' , '10.245901639344' , '22' , '0' , '12.50' )
14/04/2025 11:09:49 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
( '96070' , '13829' , 'ALLA TUA FESTA - F. BUTTAZZO' , '1' , '-1' , '1' ,
'13.0000' , '10.655737704918' , '22' , '0' , '13.00' )
14/04/2025 11:09:49 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
( '96070' , '22947' , 'MADRE SOLEDAD - DVD' , '1' , '-1' , '1' ,
'9.9000' , '8.1147540983607' , '22' , '0' , '9.90' )
14/04/2025 11:09:49 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
( '96070' , '16381' , 'EVVIVA IL NATALE' , '1' , '-1' , '1' ,
'8.0000' , '6.5573770491803' , '22' , '0' , '8.00' )
14/04/2025 11:09:49 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
( '96070' , '14761' , 'CANZONI SOTTO LALBERO' , '1' , '-1' , '1' ,
'8.0000' , '6.5573770491803' , '22' , '0' , '8.00' )
14/04/2025 11:09:49 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
( '96070' , '21749' , 'NINNA NANNA SOGNI DORO - CD' , '1' , '-1' , '1' ,
'13.5000' , '11.065573770492' , '22' , '0' , '13.50' )
14/04/2025 11:09:49 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
( '96070' , '15903' , 'CULLA DEL PICCOLO RE' , '1' , '-1' , '1' ,
'12.5000' , '10.245901639344' , '22' , '0' , '12.50' )
14/04/2025 11:09:49 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
( '96070' , '4157' , 'FESTA DI NATALE' , '1' , '-1' , '1' ,
'8.0000' , '6.5573770491803' , '22' , '0' , '8.00' )
14/04/2025 11:09:49 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
( '96070' , '14760' , 'CANTA NATALE' , '1' , '-1' , '1' ,
'8.0000' , '6.5573770491803' , '22' , '0' , '8.00' )
14/04/2025 11:09:49 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
( '96070' , '10312' , 'STORIE DELLA BIBBIA - COFANETTO 5 DVD' , '1' , '-1' , '1' ,
'40.0000' , '32.786885245902' , '22' , '0' , '40.00' )
14/04/2025 11:09:49 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
( '96070' , '16808' , 'AMICI A TEMPO DI MUSICA - G. LOCURATOLO' , '1' , '-1' , '3' ,
'8.0000' , '7.6923076923077' , '4' , '0' , '8.00' )
14/04/2025 11:09:49 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
( '96070' , '15233' , 'CIURMA DEI BULLI' , '1' , '-1' , '3' ,
'8.5000' , '8.1730769230769' , '4' , '0' , '8.50' )
14/04/2025 11:09:49 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
( '96070' , '16359' , 'BANDA SBANDA' , '1' , '-1' , '1' ,
'19.5000' , '15.983606557377' , '22' , '0' , '19.50' )
14/04/2025 11:09:49 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
( '96070' , '22513' , 'VIVE - SPARTITO' , '1' , '-1' , '3' ,
'12.0000' , '11.538461538462' , '4' , '0' , '12.00' )
14/04/2025 11:09:49 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
( '96070' , '22514' , 'VIVE - AGGIUNTA SPARTITI' , '1' , '-1' , '3' ,
'10.0000' , '9.6153846153846' , '4' , '0' , '10.00' )
14/04/2025 11:09:49 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
( '96070' , '22512' , 'VIVE - AGGIUNTA CANTI' , '6' , '-6' , '4' ,
'4.5000' , '4.5' , '0' , '0' , '27.00' )
14/04/2025 11:09:49 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
( '96070' , '19810' , 'QUELLA STANA COPPIA ' , '1' , '-1' , '4' ,
'10.0000' , '10' , '0' , '0' , '10.00' )
14/04/2025 11:09:49 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
( '96070' , '23109' , 'PIETRO IL PESCATORE' , '1' , '-1' , '4' ,
'10.0000' , '10' , '0' , '0' , '10.00' )
14/04/2025 11:09:49 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
( '96070' , '23124' , 'AFORISMI, ANEDDOTI E PROVOCAZIONI - DON O. BENZI' , '1' , '-1' , '4' ,
'12.0000' , '12' , '0' , '0' , '12.00' )
14/04/2025 11:09:49 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
( '96070' , '22774' , 'IGNIAZIO, BENEDETTO, FRANCESCO E TERESA' , '1' , '-1' , '4' ,
'13.0000' , '13' , '0' , '0' , '13.00' )
14/04/2025 11:09:49 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
( '96070' , '20654' , 'CONQUISTA LA PACE - PAPA FRANCESCO' , '2' , '-2' , '4' ,
'17.0000' , '17' , '0' , '0' , '34.00' )
14/04/2025 11:09:49 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
( '96070' , '22006' , 'BENEDETTO E FRANCESCO - R. VIRGILI' , '1' , '-1' , '4' ,
'16.0000' , '16' , '0' , '0' , '16.00' )
14/04/2025 11:09:49 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
( '96070' , '22698' , 'CALENDARIO LITURGICO 2025' , '18' , '-18' , '4' ,
'0.8000' , '0.8' , '0' , '0' , '14.40' )
14/04/2025 11:09:50 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '22749' , 'PAROLA E I GIORNI 2025' , '1' , '-1' , '4' ,
'9.0000' , '9' , '0' , '0' , '9.00' )
14/04/2025 11:09:50 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '23344' , 'MESSALINO QUOTIDIANO - FEB/MAR/APR 2025' , '3' , '-3' , '4' ,
'6.0000' , '6' , '0' , '0' , '18.00' )
14/04/2025 11:09:50 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '18067' , 'ROSARIO BIBLICO - V. SPAGNOLO' , '1' , '-1' , '4' ,
'3.9000' , '3.9' , '0' , '0' , '3.90' )
14/04/2025 11:09:50 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '6168' , 'MAMMA COME MARIA' , '3' , '-3' , '4' ,
'1.5000' , '1.5' , '0' , '0' , '4.50' )
14/04/2025 11:09:50 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '14241' , 'BATTESIMO' , '2' , '-2' , '4' ,
'2.0000' , '2' , '0' , '0' , '4.00' )
14/04/2025 11:09:50 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '11837' , 'MIA PRIMA COMUNIONE' , '1' , '-1' , '4' ,
'1.5000' , '1.5' , '0' , '0' , '1.50' )
14/04/2025 11:09:50 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '17512' , 'SAN DOMENICO ABATE - VITA BREVIS' , '1' , '-1' , '4' ,
'2.0000' , '2' , '0' , '0' , '2.00' )
14/04/2025 11:09:50 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '17366' , 'SANTA TERESA DI LISIEUX ' , '1' , '-1' , '4' ,
'3.5000' , '3.5' , '0' , '0' , '3.50' )
14/04/2025 11:09:50 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '20932' , 'SOSTARE CON DIO' , '1' , '-1' , '4' ,
'3.0000' , '3' , '0' , '0' , '3.00' )
14/04/2025 11:09:50 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '7115' , 'NOVENA DEGLI ANGELI - ANGELI' , '1' , '-1' , '4' ,
'2.0000' , '2' , '0' , '0' , '2.00' )
14/04/2025 11:09:50 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '2765' , 'CORONA FRANCESCANA' , '3' , '-3' , '4' ,
'2.0000' , '2' , '0' , '0' , '6.00' )
14/04/2025 11:09:50 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '15805' , 'TREDICINA A SANTANTONIO DI PADOVA' , '30' , '-30' , '4' ,
'1.0000' , '1' , '0' , '0' , '30.00' )
14/04/2025 11:09:50 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '22854' , 'MESSALE FESTIVO 2025' , '1' , '-1' , '4' ,
'10.0000' , '10' , '0' , '0' , '10.00' )
14/04/2025 11:09:50 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '10895' , 'UN SENSO AL SOFFRIRE - V. SALVOLDI' , '1' , '-1' , '4' ,
'2.9000' , '2.9' , '0' , '0' , '2.90' )
14/04/2025 11:09:50 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '23027' , 'PREGHIAMO IL ROSARIO CON PADRE PIO - STANZIONE/GUARINO' , '1' , '-1' , '4' ,
'14.0000' , '14' , '0' , '0' , '14.00' )
14/04/2025 11:09:50 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '15819' , 'PREGHIAMO CON SANTANTONIO - G. PARIS' , '1' , '-1' , '4' ,
'14.0000' , '14' , '0' , '0' , '14.00' )
14/04/2025 11:09:50 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '18728' , 'PREGHIERA RESPIRO DELLANIMA - G. GULLOTTA' , '1' , '-1' , '4' ,
'5.0000' , '5' , '0' , '0' , '5.00' )
14/04/2025 11:09:50 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '12707' , 'AMORIS LAETITIA, UN PUNTO DI SVOLTA' , '1' , '-1' , '4' ,
'25.0000' , '25' , '0' , '0' , '25.00' )
14/04/2025 11:09:50 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '16973' , 'OMELIA COME ABBRACCIO DI DIO CON IL POPOLO' , '1' , '-1' , '4' ,
'16.0000' , '16' , '0' , '0' , '16.00' )
14/04/2025 11:09:50 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '14666' , 'PAOLO - S. ROMANELLO' , '1' , '-1' , '4' ,
'35.0000' , '35' , '0' , '0' , '35.00' )
14/04/2025 11:09:50 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '16286' , 'ECOCRISTOLOGIA - A. AGNELLI' , '1' , '-1' , '4' ,
'15.0000' , '15' , '0' , '0' , '15.00' )
14/04/2025 11:09:50 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '23196' , 'DILEXIT NOS' , '1' , '-1' , '4' ,
'2.9000' , '2.9' , '0' , '0' , '2.90' )
14/04/2025 11:09:50 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '23353' , 'VANGELO A CARETTERI GRANDI' , '1' , '-1' , '4' ,
'7.0000' , '7' , '0' , '0' , '7.00' )
14/04/2025 11:09:50 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '23067' , 'PINOCCHIO' , '1' , '-1' , '4' ,
'16.0000' , '16' , '0' , '0' , '16.00' )
14/04/2025 11:09:50 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96070' , '15763' , 'YOUCAT FOR KIDS' , '6' , '-6' , '4' ,
'16.0000' , '16' , '0' , '0' , '96.00' )
14/04/2025 11:11:01 am >> SELECT document_num FROM ps_document
WHERE document_num = '1141' AND id_document != '96571' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-08')
14/04/2025 11:11:01 am >> UPDATE ps_document SET
id_document_type = '11',
document_num = '1141',
document_date = '2025-04-08',
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 = '1.60',
price_tax_excluded = '1.31',
date_upd = NOW()
WHERE id_document = '96571'
14/04/2025 11:11: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 = '96571'
14/04/2025 11:11:01 am >> DELETE FROM ps_document_detail WHERE id_document = '96571'
14/04/2025 11:11: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
( '96571' , '7930' , 'PERGAMENE - BATTESIMO MOD. D' , '3' , '-3' , '1' ,
'0.50' , '0.40983606557377' , '22' , '0' , '1.50' )
14/04/2025 11:11: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
( '96571' , '5538' , 'LACCIO MARRONE' , '2' , '-2' , '1' ,
'0.05' , '0.040983606557377' , '22' , '0' , '0.10' )
14/04/2025 11:21:13 am >> SELECT document_num FROM ps_document
WHERE document_num = '1231' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-14')
14/04/2025 11:21:13 am >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'1231' ,
'2025-04-14' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'42.50' ,
'34.84' ,
NOW() ,
NOW() )
14/04/2025 11:21:13 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96672'
14/04/2025 11:21:13 am >> DELETE FROM ps_document_detail WHERE id_document = '96672'
14/04/2025 11:21:13 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96672' , '19606' , 'CAMICIA SOTTOTALARE MISTO COTONE- C15' , '1' , '-1' , '1' ,
'42.5' , '34.83606557377' , '22' , '0' , '42.50' )
14/04/2025 11:21:52 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() )
14/04/2025 11:21:52 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23677' , '1' , '' , 'nuovo-prodotto' )
14/04/2025 11:21:52 am >> INSERT INTO ps_product_shop (
id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd`
) VALUES (
'23677' , '1' , '1' , '2' , NOW() , NOW()
)
14/04/2025 11:21:52 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '23677' , '0' , '1' , '0' , '0' )
14/04/2025 11:26:26 am >> SELECT document_num FROM ps_document
WHERE document_num = '65/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-04-14')
14/04/2025 11:26: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 (
'24' ,
'65/A' ,
'2025-04-14' ,
'A' ,
'2877' ,
'0' ,
'2487803' ,
'VIA NEGRI 84084 FISCIANO' ,
'' ,
'causale: ACQUISTO MATERIALE LITURGICO' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'144.00' ,
'144.00' ,
NOW() ,
NOW() )
14/04/2025 11:26: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 = '96673'
14/04/2025 11:26:26 am >> DELETE FROM ps_document_detail WHERE id_document = '96673'
14/04/2025 11:26: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
( '96673' , '19363' , 'CERO MINIATO 80X100' , '1' , '-1' , '0' ,
'105.00' , '105' , '' , '0' , '105.00' )
14/04/2025 11:26: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
( '96673' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '1' , '-1' , '0' ,
'28.00' , '28' , '' , '0' , '28.00' )
14/04/2025 11:26: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
( '96673' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '0' ,
'11.00' , '11' , '' , '0' , '11.00' )
14/04/2025 11:32:04 am >> SELECT document_num FROM ps_document
WHERE document_num = '65/A' AND id_document != '96673' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-04-14')
14/04/2025 11:32:04 am >> UPDATE ps_document SET
id_document_type = '24',
document_num = '65/A',
document_date = '2025-04-14',
document_letter = 'A',
id_customer = '2877',
id_supplier = '',
id_address = '2487803',
address1 = 'VIA NEGRI 84084 FISCIANO',
address2 = '',
note = 'causale: ACQUISTO MATERIALE LITURGICO',
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 = '149.50',
price_tax_excluded = '149.50',
date_upd = NOW()
WHERE id_document = '96673'
14/04/2025 11:32: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 = '96673'
14/04/2025 11:32:05 am >> DELETE FROM ps_document_detail WHERE id_document = '96673'
14/04/2025 11:32: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
( '96673' , '19363' , 'CERO MINIATO 80X100' , '1' , '-1' , '0' ,
'105.0000' , '105' , '0' , '0' , '105.00' )
14/04/2025 11:32: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
( '96673' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '1' , '-1' , '0' ,
'28.0000' , '28' , '0' , '0' , '28.00' )
14/04/2025 11:32: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
( '96673' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '0' ,
'11.0000' , '11' , '0' , '0' , '11.00' )
14/04/2025 11:32: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
( '96673' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '0' ,
'3.50' , '3.5' , '' , '0' , '3.50' )
14/04/2025 11:32: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
( '96673' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '0' ,
'2.00' , '2' , '' , '0' , '2.00' )
14/04/2025 11:41:21 am >> SELECT document_num FROM ps_document
WHERE document_num = '1232' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-14')
14/04/2025 11:41: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' ,
'1232' ,
'2025-04-14' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'4.75' ,
'4.75' ,
NOW() ,
NOW() )
14/04/2025 11:41: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 = '96674'
14/04/2025 11:41:21 am >> DELETE FROM ps_document_detail WHERE id_document = '96674'
14/04/2025 11:41: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
( '96674' , '23536' , 'SULLA TUA PAROLA - MAG/GIU 25' , '1' , '-1' , '4' ,
'5.00' , '5' , '0' , '5' , '4.75' )
14/04/2025 11:52:23 am >> SELECT document_num FROM ps_document
WHERE document_num = '1233' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-14')
14/04/2025 11:52:23 am >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'1233' ,
'2025-04-14' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'430.00' ,
'352.46' ,
NOW() ,
NOW() )
14/04/2025 11:52:23 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96675'
14/04/2025 11:52:23 am >> DELETE FROM ps_document_detail WHERE id_document = '96675'
14/04/2025 11:52:23 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96675' , '17408' , 'CAMICE MISTO COT. 70/001035' , '1' , '-1' , '1' ,
'175.00' , '143.44262295082' , '22' , '0' , '175.00' )
14/04/2025 11:52:23 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96675' , '19594' , 'POLO JERSEY COTONE 100%' , '1' , '-1' , '1' ,
'41.00' , '33.606557377049' , '22' , '0' , '41.00' )
14/04/2025 11:52:23 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96675' , '8082' , 'POLO LIMITED ' , '1' , '-1' , '1' ,
'33.00' , '27.049180327869' , '22' , '0' , '33.00' )
14/04/2025 11:52:23 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96675' , '23226' , 'STOLA GIUBILEO RICAMATA - ST15GBR' , '1' , '-1' , '1' ,
'35.00' , '28.688524590164' , '22' , '0' , '35.00' )
14/04/2025 11:52:23 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96675' , '20273' , 'CASULA IHS - 220' , '1' , '-1' , '1' ,
'70.00' , '57.377049180328' , '22' , '0' , '70.00' )
14/04/2025 11:52:23 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96675' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' ,
'60.5' , '49.590163934426' , '22' , '0' , '60.50' )
14/04/2025 11:52:23 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96675' , '19752' , 'INCENSO MARCUS' , '1' , '-1' , '1' ,
'15.50' , '12.704918032787' , '22' , '0' , '15.50' )
14/04/2025 11:57:05 am >> SELECT document_num FROM ps_document
WHERE document_num = '1234' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-14')
14/04/2025 11:57: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' ,
'1234' ,
'2025-04-14' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'21.21' ,
'21.21' ,
NOW() ,
NOW() )
14/04/2025 11:57: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 = '96676'
14/04/2025 11:57:05 am >> DELETE FROM ps_document_detail WHERE id_document = '96676'
14/04/2025 11:57: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
( '96676' , '23667' , 'CARLO ACUTIS - MEYLAENDER/CARRERES' , '1' , '-1' , '4' ,
'13.90' , '13.9' , '0' , '5' , '13.21' )
14/04/2025 11:57: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
( '96676' , '23661' , 'NOVENA A SAN CARLO ACUTIS' , '1' , '-1' , '4' ,
'4.00' , '4' , '0' , '0' , '4.00' )
14/04/2025 11:57: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
( '96676' , '23650' , 'PREGHIAMO IL ROSARIO CON CARLO ACUTIS' , '1' , '-1' , '4' ,
'4.00' , '4' , '0' , '0' , '4.00' )
14/04/2025 12:18:34 pm >> SELECT document_num FROM ps_document
WHERE document_num = '65/A' AND id_document != '96673' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-04-14')
14/04/2025 12:18:34 pm >> UPDATE ps_document SET
id_document_type = '24',
document_num = '65/A',
document_date = '2025-04-14',
document_letter = 'A',
id_customer = '2877',
id_supplier = '',
id_address = '2487803',
address1 = 'VIA NEGRI 84084 FISCIANO',
address2 = '',
note = 'causale: ACQUISTO MATERIALE LITURGICO',
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 = '149.50',
price_tax_excluded = '123.32',
date_upd = NOW()
WHERE id_document = '96673'
14/04/2025 12:18:34 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 = '96673'
14/04/2025 12:18:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '96673'
14/04/2025 12:18:34 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96673' , '19363' , 'CERO MINIATO 80X100' , '1' , '-1' , '1' ,
'105.00' , '86.065573770492' , '22' , '0' , '105.00' )
14/04/2025 12:18:34 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96673' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '1' , '-1' , '1' ,
'28.00' , '22.950819672131' , '22' , '0' , '28.00' )
14/04/2025 12:18:34 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96673' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' ,
'11.00' , '9.016393442623' , '22' , '0' , '11.00' )
14/04/2025 12:18:34 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96673' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' ,
'3.50' , '3.3653846153846' , '4' , '0' , '3.50' )
14/04/2025 12:18:34 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96673' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' ,
'2.00' , '1.9230769230769' , '4' , '0' , '2.00' )
14/04/2025 12:48:15 pm >> SELECT document_num FROM ps_document
WHERE document_num = '1227' AND id_document != '96668' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-14')
14/04/2025 12:48:15 pm >> UPDATE ps_document SET
id_document_type = '11',
document_num = '1227',
document_date = '2025-04-14',
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 = '375.07',
price_tax_excluded = '310.33',
date_upd = NOW()
WHERE id_document = '96668'
14/04/2025 12:48: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 = '96668'
14/04/2025 12:48:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '96668'
14/04/2025 12:48: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
( '96668' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '3' , '-3' , '1' ,
'28.0000' , '22.950819672131' , '22' , '0' , '84.00' )
14/04/2025 12:48: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
( '96668' , '1631' , 'CANDELINE NON GOCCIOLANTI ' , '2' , '-2' , '1' ,
'27.5000' , '22.540983606557' , '22' , '0' , '55.00' )
14/04/2025 12:48: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
( '96668' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' ,
'2.0000' , '1.9230769230769' , '4' , '0' , '4.00' )
14/04/2025 12:48: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
( '96668' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' , '-2' , '3' ,
'3.5000' , '3.3653846153846' , '4' , '0' , '7.00' )
14/04/2025 12:48: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
( '96668' , '8728' , 'QUARESIMA SPIEGATA AI BAMBINI' , '1' , '-1' , '4' ,
'3.9000' , '3.9' , '0' , '5' , '3.71' )
14/04/2025 12:48: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
( '96668' , '11151' , 'LIBRI' , '1' , '-1' , '4' ,
'3.71' , '3.71' , '0' , '0' , '3.71' )
14/04/2025 12:48: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
( '96668' , '19107' , 'INCENSO GRANI 3A - BUSTA' , '1' , '-1' , '1' ,
'30.0000' , '24.590163934426' , '22' , '0' , '30.00' )
14/04/2025 12:48: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
( '96668' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '1' , '-1' , '1' ,
'13.0000' , '10.655737704918' , '22' , '0' , '13.00' )
14/04/2025 12:48: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
( '96668' , '19102' , 'CARBONCINI MM 40' , '1' , '-1' , '1' ,
'13.0000' , '10.655737704918' , '22' , '0' , '13.00' )
14/04/2025 12:48: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
( '96668' , '17617' , 'IMMAGINI ISONZO X 100' , '5' , '-5' , '1' ,
'3.3300' , '2.7295081967213' , '22' , '0' , '16.65' )
14/04/2025 12:48: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
( '96668' , '23262' , 'COPRI LEGGIO AGNELLO - 61AGN' , '1' , '-1' , '1' ,
'145.0000' , '118.85245901639' , '22' , '0' , '145.00' )
14/04/2025 03:38:17 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791280736581' AND id_product != '23674' AND ean13 != ''
14/04/2025 03:38:17 pm >> UPDATE ps_product SET
id_supplier = '125',
reference = '',
ean13 = '9791280736581',
date_upd = NOW()
WHERE id_product = '23674'
14/04/2025 03:38:17 pm >> UPDATE ps_product_lang SET
name = 'DONO DI GRAZIA - V. SIRACUSA',
description = 'Un piccolo testo di preghiere a ricordo perenne e incancellabile dei nostri cari nonni che con la loro presenza, sempre vicino a noi, ci riportano all’abbraccio d’amore che Dio costantemente ci dona.
Dedicato di cuore a tutti i nipoti che hanno, o hanno avuto, accanto e nel cuore, dei nonni unici e rari come lo sono i miei.
'
WHERE id_product = '23674'
14/04/2025 03:38:17 pm >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '5.0000'
WHERE id_product = '23674'
14/04/2025 03:38:17 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '5.0000',
id_tax_rules_group = '4',
id_category_default = '395',
id_argoment_default = '28',
id_internal_category = '4',
on_sale = '0',
on_showcase = '1',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '23674'
14/04/2025 03:38:17 pm >> DELETE FROM ps_specific_price WHERE id_product = '23674'
14/04/2025 03:38:17 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' , '23674' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' )
14/04/2025 03:39:52 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791280736598' AND id_product != '23673' AND ean13 != ''
14/04/2025 03:39:52 pm >> UPDATE ps_product SET
id_supplier = '125',
reference = '',
ean13 = '9791280736598',
date_upd = NOW()
WHERE id_product = '23673'
14/04/2025 03:39:52 pm >> UPDATE ps_product_lang SET
name = 'RIVESTITI DI SPERANZA! - V. SIRACUSA',
description = 'Queste preghiere che con semplicità l\'Autore ha composto, sono una sorgente profonda di fede capace di farci conoscere i tratti umani e spirituali della santità di questi due giovani: Carlo Acutis e Pier Giorgio Frassati che ci insegnano la strada da seguire per entrare in contatto con l’amore di Dio.
'
WHERE id_product = '23673'
14/04/2025 03:39:52 pm >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '5.0000'
WHERE id_product = '23673'
14/04/2025 03:39:52 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '5.0000',
id_tax_rules_group = '4',
id_category_default = '395',
id_argoment_default = '28',
id_internal_category = '4',
on_sale = '0',
on_showcase = '1',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '23673'
14/04/2025 03:39:52 pm >> DELETE FROM ps_specific_price WHERE id_product = '23673'
14/04/2025 03:39:52 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' , '23673' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' )
14/04/2025 03:39:59 pm >> UPDATE ps_product_shop SET active = '1' WHERE id_product = '23673'
14/04/2025 03:40:13 pm >> UPDATE ps_product_shop SET active = '1' WHERE id_product = '23674'
14/04/2025 03:48:43 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791280736567' AND id_product != '23677' AND ean13 != ''
14/04/2025 03:48:43 pm >> UPDATE ps_product SET
id_supplier = '',
reference = '6/7',
ean13 = '9791280736567',
date_upd = NOW()
WHERE id_product = '23677'
14/04/2025 03:48:43 pm >> UPDATE ps_product_lang SET
name = 'RICETTE DI MAMMA ROSA',
description = ''
WHERE id_product = '23677'
14/04/2025 03:48:43 pm >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '20'
WHERE id_product = '23677'
14/04/2025 03:48:43 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '20',
id_tax_rules_group = '4',
id_category_default = '395',
id_argoment_default = '10',
id_internal_category = '4',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '23677'
14/04/2025 03:48:43 pm >> DELETE FROM ps_specific_price WHERE id_product = '23677'
14/04/2025 03:49:18 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791280736567' AND id_product != '23677' AND ean13 != ''
14/04/2025 03:49:18 pm >> UPDATE ps_product SET
id_supplier = '',
reference = '6/7',
ean13 = '9791280736567',
date_upd = NOW()
WHERE id_product = '23677'
14/04/2025 03:49:18 pm >> UPDATE ps_product_lang SET
name = 'RICETTE DI MAMMA ROSA',
description = ''
WHERE id_product = '23677'
14/04/2025 03:49:18 pm >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '20.0000'
WHERE id_product = '23677'
14/04/2025 03:49:18 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '20.0000',
id_tax_rules_group = '4',
id_category_default = '395',
id_argoment_default = '10',
id_internal_category = '4',
on_sale = '0',
on_showcase = '1',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '23677'
14/04/2025 03:49:18 pm >> DELETE FROM ps_specific_price WHERE id_product = '23677'
14/04/2025 03:49:30 pm >> UPDATE ps_product_shop SET active = '1' WHERE id_product = '23677'
14/04/2025 03:49:35 pm >> DELETE FROM ps_product WHERE id_product = '7156'
14/04/2025 03:49:35 pm >> DELETE FROM ps_product_shop WHERE id_product = '7156'
14/04/2025 03:49:35 pm >> DELETE FROM ps_product_lang WHERE id_product = '7156'
14/04/2025 03:49:36 pm >> DELETE FROM ps_stock_available WHERE id_product = '7156'
14/04/2025 03:50:27 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791280736567' AND id_product != '23677' AND ean13 != ''
14/04/2025 03:50:27 pm >> UPDATE ps_product SET
id_supplier = '',
reference = '6/7',
ean13 = '9791280736567',
date_upd = NOW()
WHERE id_product = '23677'
14/04/2025 03:50:27 pm >> UPDATE ps_product_lang SET
name = 'RICETTE DI MAMMA ROSA',
description = ''
WHERE id_product = '23677'
14/04/2025 03:50:27 pm >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '20.0000'
WHERE id_product = '23677'
14/04/2025 03:50:27 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '20.0000',
id_tax_rules_group = '4',
id_category_default = '395',
id_argoment_default = '10',
id_internal_category = '4',
on_sale = '0',
on_showcase = '1',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '23677'
14/04/2025 03:50:27 pm >> DELETE FROM ps_specific_price WHERE id_product = '23677'
14/04/2025 03:50:27 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' , '23677' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' )
14/04/2025 03:53:47 pm >> SELECT document_num FROM ps_document
WHERE document_num = '10' AND id_document != '96018' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2025-03-03')
14/04/2025 03:53:47 pm >> UPDATE ps_document SET
id_document_type = '24',
document_num = '10',
document_date = '2025-03-03',
document_letter = '',
id_customer = '0',
id_supplier = '',
id_address = '4669100',
address1 = 'VIA DEI CASTANI, 116 00172 ROMA',
address2 = '',
note = 'RESA - N. C. RICEVUTA',
price_shipping = '0.00',
id_tax_shipping_rules = '4',
colli = '0',
peso = '0',
porto_e_imballo = '0',
mezzo_consegna = '',
id_payment = '0',
id_causal = '9',
price_tax_included = '524.40',
price_tax_excluded = '524.40',
date_upd = NOW()
WHERE id_document = '96018'
14/04/2025 03:53: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 = '96018'
14/04/2025 03:53:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '96018'
14/04/2025 03:53: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
( '96018' , '18806' , 'SANTORALE FRANCESCANO MISSARUM' , '1' , '-1' , '4' ,
'120.0000' , '120' , '0' , '0' , '120.00' )
14/04/2025 03:53: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
( '96018' , '18807' , 'SANTORALE FRANCESCANO LETTURE' , '1' , '-1' , '4' ,
'60.0000' , '60' , '0' , '0' , '60.00' )
14/04/2025 03:53: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
( '96018' , '19117' , 'NON PERDIAMO LA PAROLA - ANNO C - L. SAPIENZA' , '1' , '-1' , '4' ,
'14.0000' , '14' , '0' , '0' , '14.00' )
14/04/2025 03:53: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
( '96018' , '20397' , 'FRATERNITà IMPOSSIBILE? - G. CUCCI' , '1' , '-1' , '4' ,
'13.5000' , '13.5' , '0' , '0' , '13.50' )
14/04/2025 03:53: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
( '96018' , '18821' , 'CONFESSIONI FRATERNE - E. CASTELLUCCI' , '1' , '-1' , '4' ,
'15.5000' , '15.5' , '0' , '0' , '15.50' )
14/04/2025 03:53: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
( '96018' , '18178' , 'FRANCESCO FRATELLO DI TUTTI - P. MARANESI' , '1' , '-1' , '4' ,
'14.9000' , '14.9' , '0' , '0' , '14.90' )
14/04/2025 03:53: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
( '96018' , '18177' , 'UOMINI FRATELLI TUTTI? - A. GRILLO' , '1' , '-1' , '4' ,
'12.5000' , '12.5' , '0' , '0' , '12.50' )
14/04/2025 03:53: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
( '96018' , '12520' , 'TUTTA LA GIOIA CHE MI HAI MESSO IN CUORE - AAVV' , '1' , '-1' , '4' ,
'22.0000' , '22' , '0' , '0' , '22.00' )
14/04/2025 03:53: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
( '96018' , '22275' , 'THE CHOSEN. TI HO CHIAMATO PER NOME' , '2' , '-2' , '4' ,
'20.0000' , '20' , '0' , '0' , '40.00' )
14/04/2025 03:53: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
( '96018' , '17681' , 'SACRAMENTO DEL PERDONO E DELLA RICONCILIAZIONE - M. ROSSINO' , '1' , '-1' , '4' ,
'30.0000' , '30' , '0' , '0' , '30.00' )
14/04/2025 03:53: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
( '96018' , '12596' , 'BUONA NOTIZIA PORTATA DA MARIA - K. STOCK' , '2' , '-2' , '4' ,
'3.0000' , '3' , '0' , '0' , '6.00' )
14/04/2025 03:53: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
( '96018' , '22850' , 'UPPO 2025 - CALENDARIO' , '1' , '-1' , '4' ,
'3.0000' , '3' , '0' , '0' , '3.00' )
14/04/2025 03:53: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
( '96018' , '20395' , 'SANTA FAMIGLIA ' , '4' , '-4' , '4' ,
'5.0000' , '5' , '0' , '0' , '20.00' )
14/04/2025 03:53: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
( '96018' , '19498' , 'VANGELI' , '1' , '-1' , '4' ,
'69.0000' , '69' , '0' , '0' , '69.00' )
14/04/2025 03:53: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
( '96018' , '18181' , 'MARCELLINO PANE E VINO' , '2' , '-2' , '4' ,
'10.0000' , '10' , '0' , '0' , '20.00' )
14/04/2025 03:53: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
( '96018' , '22999' , 'PREGHIERA GRATUITA' , '1' , '-1' , '4' ,
'16.0000' , '16' , '0' , '0' , '16.00' )
14/04/2025 03:53: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
( '96018' , '21623' , 'VIDE CHE TUTTO ERA BUONO - R. COLIZZI' , '1' , '-1' , '4' ,
'10.0000' , '10' , '0' , '0' , '10.00' )
14/04/2025 03:53: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
( '96018' , '19494' , 'POVERI CRISTI - O. DE BERTOLIS' , '1' , '-1' , '4' ,
'7.0000' , '7' , '0' , '0' , '7.00' )
14/04/2025 03:53: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
( '96018' , '19576' , 'ABBRACCIATI A MARIA - M.G. DARCO' , '1' , '-1' , '4' ,
'15.0000' , '15' , '0' , '0' , '15.00' )
14/04/2025 03:53: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
( '96018' , '19084' , 'OMELIE E PREDICAZIONE - CAVOLO/SODI' , '1' , '-1' , '4' ,
'16.0000' , '16' , '0' , '0' , '16.00' )
14/04/2025 04:04:40 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791280736567' AND id_product != '23677' AND ean13 != ''
14/04/2025 04:04:40 pm >> UPDATE ps_product SET
id_supplier = '',
reference = '6/7',
ean13 = '9791280736567',
date_upd = NOW()
WHERE id_product = '23677'
14/04/2025 04:04:40 pm >> UPDATE ps_product_lang SET
name = 'RICETTE DI MAMMA ROSA',
description = 'Mamma Rosa è il nome del ristorante da lei gestito nel centro di Salerno. Questo libro di ricette vuole essere un omaggio dei figli alla mamma per l’amore e la dedizione che continua a dimostrare sia nella vita familiare che in quella della gestione del locale. Mamma Rosa dice: “La passione perla mia cucina è paragonabile solo all’amore che ho per i miei figli”.
'
WHERE id_product = '23677'
14/04/2025 04:04:41 pm >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '20.0000'
WHERE id_product = '23677'
14/04/2025 04:04:41 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '20.0000',
id_tax_rules_group = '4',
id_category_default = '395',
id_argoment_default = '10',
id_internal_category = '4',
on_sale = '0',
on_showcase = '1',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '23677'
14/04/2025 04:04:41 pm >> DELETE FROM ps_specific_price WHERE id_product = '23677'
14/04/2025 04:04:41 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' , '23677' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' )
14/04/2025 04:05:19 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791280736567' AND id_product != '23677' AND ean13 != ''
14/04/2025 04:05:19 pm >> UPDATE ps_product SET
id_supplier = '',
reference = '6/7',
ean13 = '9791280736567',
date_upd = NOW()
WHERE id_product = '23677'
14/04/2025 04:05:19 pm >> UPDATE ps_product_lang SET
name = 'RICETTE DI MAMMA ROSA',
description = 'Mamma Rosa è il nome del ristorante da lei gestito nel centro di Salerno. Questo libro di ricette vuole essere un omaggio dei figli alla mamma per l’amore e la dedizione che continua a dimostrare sia nella vita familiare che in quella della gestione del locale. Mamma Rosa dice: “La passione perla mia cucina è paragonabile solo all’amore che ho per i miei figli”.
'
WHERE id_product = '23677'
14/04/2025 04:05:20 pm >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '20.0000'
WHERE id_product = '23677'
14/04/2025 04:05:20 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '20.0000',
id_tax_rules_group = '4',
id_category_default = '395',
id_argoment_default = '10',
id_internal_category = '4',
on_sale = '0',
on_showcase = '1',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '23677'
14/04/2025 04:05:20 pm >> DELETE FROM ps_specific_price WHERE id_product = '23677'
14/04/2025 04:05:20 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' , '23677' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' )
14/04/2025 04:13:23 pm >> SELECT document_num FROM ps_document
WHERE document_num = '1235' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-14')
14/04/2025 04:13:23 pm >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'1235' ,
'2025-04-14' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'80.00' ,
'72.67' ,
NOW() ,
NOW() )
14/04/2025 04:13:23 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96677'
14/04/2025 04:13:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '96677'
14/04/2025 04:13:23 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96677' , '1912' , 'CERA DELL\'EREMO - 415/B ' , '3' , '-3' , '1' ,
'6.50' , '5.327868852459' , '22' , '0' , '19.50' )
14/04/2025 04:13:23 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96677' , '13049' , 'LITURGICO ART. 60LT BIANCO SUPER' , '3' , '-3' , '1' ,
'3.50' , '2.8688524590164' , '22' , '0' , '10.50' )
14/04/2025 04:13:23 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96677' , '11152' , 'VARIE - OSTIE - PARTICOLE' , '2' , '-2' , '3' ,
'25' , '24.038461538462' , '4' , '0' , '50.00' )
14/04/2025 04:20:41 pm >> SELECT document_num FROM ps_document
WHERE document_num = '1236' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-14')
14/04/2025 04:20:41 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' ,
'1236' ,
'2025-04-14' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'4.50' ,
'3.69' ,
NOW() ,
NOW() )
14/04/2025 04:20: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 = '96678'
14/04/2025 04:20:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '96678'
14/04/2025 04:20: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
( '96678' , '3144' , 'CROCE TRILOBATA ' , '1' , '-1' , '1' ,
'4.50' , '3.6885245901639' , '22' , '0' , '4.50' )
14/04/2025 04:29:47 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791280736567' AND id_product != '23677' AND ean13 != ''
14/04/2025 04:29:47 pm >> UPDATE ps_product SET
id_supplier = '',
reference = '6/7',
ean13 = '9791280736567',
date_upd = NOW()
WHERE id_product = '23677'
14/04/2025 04:29:47 pm >> UPDATE ps_product_lang SET
name = 'RICETTE DI MAMMA ROSA',
description = 'Mamma Rosa è il nome del ristorante da lei gestito nel centro di Salerno. Questo libro di ricette vuole essere un omaggio dei figli alla mamma per l’amore e la dedizione che continua a dimostrare sia nella vita familiare che in quella della gestione del locale. Mamma Rosa dice: “La passione perla mia cucina è paragonabile solo all’amore che ho per i miei figli”.
'
WHERE id_product = '23677'
14/04/2025 04:29:47 pm >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '20.0000'
WHERE id_product = '23677'
14/04/2025 04:29:47 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '20.0000',
id_tax_rules_group = '4',
id_category_default = '395',
id_argoment_default = '10',
id_internal_category = '4',
on_sale = '0',
on_showcase = '1',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '23677'
14/04/2025 04:29:47 pm >> DELETE FROM ps_specific_price WHERE id_product = '23677'
14/04/2025 04:29:47 pm >> INSERT INTO ps_specific_price
( id_specific_price_rule , id_cart , id_product , id_shop , id_shop_group , id_currency , id_country , id_group , id_customer , id_product_attribute , price , from_quantity , reduction , reduction_tax , reduction_type , `from` , `to`)
VALUES
( '0' , '0' , '23677' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' )
14/04/2025 04:31:18 pm >> SELECT document_num FROM ps_document
WHERE document_num = '1235' AND id_document != '96677' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-14')
14/04/2025 04:31:18 pm >> UPDATE ps_document SET
id_document_type = '11',
document_num = '1235',
document_date = '2025-04-14',
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 = '72.67',
date_upd = NOW()
WHERE id_document = '96677'
14/04/2025 04:31:18 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96677'
14/04/2025 04:31:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '96677'
14/04/2025 04:31:18 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96677' , '1912' , 'CERA DELL\'EREMO - 415/B ' , '3' , '-3' , '1' ,
'6.5000' , '5.327868852459' , '22' , '0' , '19.50' )
14/04/2025 04:31:18 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96677' , '13049' , 'LITURGICO ART. 60LT BIANCO SUPER' , '3' , '-3' , '1' ,
'3.5000' , '2.8688524590164' , '22' , '0' , '10.50' )
14/04/2025 04:31:18 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96677' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '3' , '-3' , '3' ,
'4.50' , '4.3269230769231' , '4' , '0' , '13.50' )
14/04/2025 04:31:18 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96677' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '10' , '-10' , '3' ,
'3.50' , '3.3653846153846' , '4' , '0' , '35.00' )
14/04/2025 04:31:18 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96677' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' ,
'1.5' , '1.4423076923077' , '4' , '0' , '1.50' )
14/04/2025 04:36:18 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831558464' AND id_product != '23667' AND ean13 != ''
14/04/2025 04:36:18 pm >> UPDATE ps_product SET
id_supplier = '',
reference = 'GONDOLA 1',
ean13 = '9788831558464',
date_upd = NOW()
WHERE id_product = '23667'
14/04/2025 04:36:18 pm >> UPDATE ps_product_lang SET
name = 'CARLO ACUTIS - MEYLAENDER/CARRERES',
description = ''
WHERE id_product = '23667'
14/04/2025 04:36:18 pm >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '13.9000'
WHERE id_product = '23667'
14/04/2025 04:36:18 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '13.9000',
id_tax_rules_group = '4',
id_category_default = '27',
id_argoment_default = '10',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '23667'
14/04/2025 04:36:18 pm >> DELETE FROM ps_specific_price WHERE id_product = '23667'
14/04/2025 04:50:50 pm >> SELECT document_num FROM ps_document
WHERE document_num = '1237' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-14')
14/04/2025 04:50:50 pm >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'1237' ,
'2025-04-14' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'249.00' ,
'210.05' ,
NOW() ,
NOW() )
14/04/2025 04:50:50 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96679'
14/04/2025 04:50:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '96679'
14/04/2025 04:50:50 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96679' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '9' , '-9' , '1' ,
'24' , '19.672131147541' , '22' , '0' , '216.00' )
14/04/2025 04:50:50 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96679' , '19158' , 'SETTIMANA SANTA - N.E.' , '1' , '-1' , '4' ,
'5.00' , '5' , '0' , '0' , '5.00' )
14/04/2025 04:50:50 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96679' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '40' , '-40' , '4' ,
'0.70' , '0.7' , '0' , '0' , '28.00' )
14/04/2025 05:10:25 pm >> SELECT document_num FROM ps_document
WHERE document_num = '1238' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-14')
14/04/2025 05:10:25 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' ,
'1238' ,
'2025-04-14' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'42.00' ,
'34.43' ,
NOW() ,
NOW() )
14/04/2025 05:10:25 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 = '96680'
14/04/2025 05:10:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '96680'
14/04/2025 05:10:25 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96680' , '1750' , 'CARTUCCIA TRASPARENTE DIAM. 3,2 - 454' , '3' , '-3' , '1' ,
'14.00' , '11.475409836066' , '22' , '0' , '42.00' )
14/04/2025 05:15:49 pm >> SELECT document_num FROM ps_document
WHERE document_num = '1239' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-14')
14/04/2025 05:15:49 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' ,
'1239' ,
'2025-04-14' ,
'' ,
'0' ,
'0' ,
'0' ,
'VIA NEGRI 84084 FISCIANO' ,
'' ,
'' ,
'0.00' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'3' ,
'0' ,
'149.50' ,
'123.32' ,
NOW() ,
NOW() )
14/04/2025 05:15:49 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 = '96681'
14/04/2025 05:15:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '96681'
14/04/2025 05:15:49 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96681' , '19363' , 'CERO MINIATO 80X100' , '1' , '-1' , '1' ,
'105.0000' , '86.0656' , '22' , '0' , '105.00' )
14/04/2025 05:15:49 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96681' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '1' , '-1' , '1' ,
'28.0000' , '22.9508' , '22' , '0' , '28.00' )
14/04/2025 05:15:49 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96681' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' ,
'11.0000' , '9.0164' , '22' , '0' , '11.00' )
14/04/2025 05:15:49 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96681' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' ,
'3.5000' , '3.3654' , '4' , '0' , '3.50' )
14/04/2025 05:15:49 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96681' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' ,
'2.0000' , '1.9231' , '4' , '0' , '2.00' )
14/04/2025 05:24:52 pm >> SELECT document_num FROM ps_document
WHERE document_num = '1240' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-14')
14/04/2025 05:24:52 pm >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'1240' ,
'2025-04-14' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'300.00' ,
'245.90' ,
NOW() ,
NOW() )
14/04/2025 05:24:52 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96682'
14/04/2025 05:24:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '96682'
14/04/2025 05:24:52 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96682' , '15210' , 'CERO PASQUALE API 80X120' , '1' , '-1' , '1' ,
'145' , '118.85245901639' , '22' , '0' , '145.00' )
14/04/2025 05:24:52 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96682' , '19364' , 'CERO MINIATO 80X120' , '1' , '-1' , '1' ,
'125.00' , '102.45901639344' , '22' , '0' , '125.00' )
14/04/2025 05:24:52 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96682' , '7202' , 'ARTICOLI RELIGIOSI' , '2' , '-2' , '1' ,
'15' , '12.295081967213' , '22' , '0' , '30.00' )
14/04/2025 05:30:35 pm >> SELECT document_num FROM ps_document
WHERE document_num = '1241' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-14')
14/04/2025 05:30:35 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' ,
'1241' ,
'2025-04-14' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'35.80' ,
'29.34' ,
NOW() ,
NOW() )
14/04/2025 05:30:35 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 = '96683'
14/04/2025 05:30:35 pm >> DELETE FROM ps_document_detail WHERE id_document = '96683'
14/04/2025 05:30:35 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96683' , '19147' , 'CANDELINE NON GOCCIOLANTI GRECHE' , '2' , '-2' , '1' ,
'17.90' , '14.672131147541' , '22' , '0' , '35.80' )
14/04/2025 05:30:45 pm >> SELECT document_num FROM ps_document
WHERE document_num = '1242' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-14')
14/04/2025 05:30: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' ,
'1242' ,
'2025-04-14' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'35.80' ,
'29.34' ,
NOW() ,
NOW() )
14/04/2025 05:30: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 = '96684'
14/04/2025 05:30:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '96684'
14/04/2025 05:30: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
( '96684' , '19147' , 'CANDELINE NON GOCCIOLANTI GRECHE' , '2' , '-2' , '1' ,
'17.90' , '14.672131147541' , '22' , '0' , '35.80' )
14/04/2025 05:30:55 pm >> SELECT document_num FROM ps_document
WHERE document_num = '1243' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-14')
14/04/2025 05:30:55 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' ,
'1243' ,
'2025-04-14' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'35.80' ,
'29.34' ,
NOW() ,
NOW() )
14/04/2025 05:30:55 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96685'
14/04/2025 05:30:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '96685'
14/04/2025 05:30:55 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96685' , '19147' , 'CANDELINE NON GOCCIOLANTI GRECHE' , '2' , '-2' , '1' ,
'17.90' , '14.672131147541' , '22' , '0' , '35.80' )
14/04/2025 05:37:06 pm >> SELECT document_num FROM ps_document
WHERE document_num = '1244' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-14')
14/04/2025 05:37:06 pm >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'1244' ,
'2025-04-14' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'5.00' ,
'5.00' ,
NOW() ,
NOW() )
14/04/2025 05:37:06 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96686'
14/04/2025 05:37:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '96686'
14/04/2025 05:37:06 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96686' , '19158' , 'SETTIMANA SANTA - N.E.' , '1' , '-1' , '4' ,
'5.00' , '5' , '0' , '0' , '5.00' )
14/04/2025 05:53:12 pm >> SELECT document_num FROM ps_document
WHERE document_num = '1245' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-14')
14/04/2025 05:53:12 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' ,
'1245' ,
'2025-04-14' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'108.00' ,
'108.00' ,
NOW() ,
NOW() )
14/04/2025 05:53:12 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96687'
14/04/2025 05:53:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '96687'
14/04/2025 05:53:12 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96687' , '23536' , 'SULLA TUA PAROLA - MAG/GIU 25' , '24' , '-24' , '4' ,
'4.5' , '4.5' , '0' , '0' , '108.00' )
14/04/2025 06:18:57 pm >> SELECT document_num FROM ps_document
WHERE document_num = '1246' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-14')
14/04/2025 06:18:58 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' ,
'1246' ,
'2025-04-14' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'55.00' ,
'46.34' ,
NOW() ,
NOW() )
14/04/2025 06:18:58 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 = '96688'
14/04/2025 06:18:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '96688'
14/04/2025 06:18:58 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96688' , '22995' , 'MINISTRO STRAORDINARIO DELLA COMUNIONE' , '1' , '-1' , '4' ,
'7.00' , '7' , '0' , '0' , '7.00' )
14/04/2025 06:18:58 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96688' , '19108' , 'PORTATECA COMPLETA - 947' , '1' , '-1' , '1' ,
'48' , '39.344262295082' , '22' , '0' , '48.00' )
14/04/2025 06:20:43 pm >> SELECT document_num FROM ps_document
WHERE document_num = '1247' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-14')
14/04/2025 06:20:43 pm >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'1247' ,
'2025-04-14' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'8.50' ,
'7.69' ,
NOW() ,
NOW() )
14/04/2025 06:20:43 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96689'
14/04/2025 06:20:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '96689'
14/04/2025 06:20:43 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96689' , '23647' , 'CONFESSIONE - 8387' , '2' , '-2' , '4' ,
'2.00' , '2' , '0' , '0' , '4.00' )
14/04/2025 06:20:43 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '96689' , '18134' , 'CROCE SAN BENEDETTO CM 7 - CSB3' , '1' , '-1' , '1' ,
'4.50' , '3.6885245901639' , '22' , '0' , '4.50' )
14/04/2025 06:32:40 pm >> SELECT document_num FROM ps_document
WHERE document_num = '1248' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-14')
14/04/2025 06:32:40 pm >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'1248' ,
'2025-04-14' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'160.00' ,
'131.15' ,
NOW() ,
NOW() )
14/04/2025 06:32:40 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96690'
14/04/2025 06:32:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '96690'
14/04/2025 06:32: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
( '96690' , '21040' , 'PALLA IN SETA CON CROCE - 50/63123' , '1' , '-1' , '1' ,
'160.00' , '131.14754098361' , '22' , '0' , '160.00' )
14/04/2025 06:34:39 pm >> SELECT document_num FROM ps_document
WHERE document_num = '1249' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-14')
14/04/2025 06:34:39 pm >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'1249' ,
'2025-04-14' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'350.00' ,
'286.89' ,
NOW() ,
NOW() )
14/04/2025 06:34:39 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96691'
14/04/2025 06:34:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '96691'
14/04/2025 06:34: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
( '96691' , '16728' , 'PISSIDE NODO EVANGELISTI 25 CM - 220' , '1' , '-1' , '1' ,
'350.00' , '286.88524590164' , '22' , '0' , '350.00' )
14/04/2025 07:23:46 pm >> SELECT document_num FROM ps_document
WHERE document_num = '1250' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-14')
14/04/2025 07:23: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' ,
'1250' ,
'2025-04-14' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'21.50' ,
'17.62' ,
NOW() ,
NOW() )
14/04/2025 07:23: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 = '96692'
14/04/2025 07:23:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '96692'
14/04/2025 07:23: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
( '96692' , '10687' , 'TORCIA A VENTO ' , '5' , '-5' , '1' ,
'4.30' , '3.5245901639344' , '22' , '0' , '21.50' )
14/04/2025 07:37:18 pm >> DELETE FROM ps_document WHERE id_document = '96673'
14/04/2025 07:37:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '96673'
14/04/2025 07:37:25 pm >> DELETE FROM ps_document WHERE id_document = '96552'
14/04/2025 07:37:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '96552'
14/04/2025 11:05:48 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() )
14/04/2025 11:05:48 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23678' , '1' , '' , 'nuovo-prodotto' )
14/04/2025 11:05:48 pm >> INSERT INTO ps_product_shop (
id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd`
) VALUES (
'23678' , '1' , '1' , '2' , NOW() , NOW()
)
14/04/2025 11:05:48 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '23678' , '0' , '1' , '0' , '0' )