20/03/2026 09:22:48 am >> SELECT document_num FROM ps_document
WHERE document_num = '823' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-03-20')
20/03/2026 09:22:48 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' ,
'823' ,
'2026-03-20' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'1' ,
'0' ,
'16.00' ,
'13.11' ,
NOW() ,
NOW() )
20/03/2026 09:22: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 = '101825'
20/03/2026 09:22:48 am >> DELETE FROM ps_document_detail WHERE id_document = '101825'
20/03/2026 09:22: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
( '101825' , '17883' , 'CROCE MOGANO CORPO MET CM 28- 169M' , '1' , '-1' , '1' ,
'16.00' , '13.114754098361' , '22' , '0' , '16.00' )
20/03/2026 11:02:14 am >> SELECT document_num FROM ps_document
WHERE document_num = '824' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-03-20')
20/03/2026 11:02:14 am >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'824' ,
'2026-03-20' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'1' ,
'0' ,
'24.70' ,
'24.70' ,
NOW() ,
NOW() )
20/03/2026 11:02:14 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '101826'
20/03/2026 11:02:14 am >> DELETE FROM ps_document_detail WHERE id_document = '101826'
20/03/2026 11:02:14 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '101826' , '20096' , 'VISIONI BIBLICHE E CONTEMPLAZIONI MISTICHE - A.K. EMMERICK' , '1' , '-1' , '4' ,
'15.00' , '15' , '0' , '5' , '14.25' )
20/03/2026 11:02:14 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '101826' , '20752' , 'SANTA RITA DA CASCIA - C. TESSARO' , '1' , '-1' , '4' ,
'11.00' , '11' , '0' , '5' , '10.45' )
20/03/2026 11:11:38 am >> SELECT document_num FROM ps_document
WHERE document_num = '825' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-03-20')
20/03/2026 11:11:38 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' ,
'825' ,
'2026-03-20' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'1' ,
'0' ,
'196.30' ,
'164.09' ,
NOW() ,
NOW() )
20/03/2026 11:11:38 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 = '101827'
20/03/2026 11:11:38 am >> DELETE FROM ps_document_detail WHERE id_document = '101827'
20/03/2026 11:11:38 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '101827' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' ,
'2.00' , '1.9230769230769' , '4' , '0' , '4.00' )
20/03/2026 11:11:38 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '101827' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '5' , '-5' , '3' ,
'3.70' , '3.5576923076923' , '4' , '0' , '18.50' )
20/03/2026 11:11:38 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '101827' , '19102' , 'CARBONCINI MM 40' , '2' , '-2' , '1' ,
'13.00' , '10.655737704918' , '22' , '0' , '26.00' )
20/03/2026 11:11:38 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '101827' , '19107' , 'INCENSO GRANI 3A - BUSTA' , '1' , '-1' , '1' ,
'35.00' , '28.688524590164' , '22' , '0' , '35.00' )
20/03/2026 11:11:38 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '101827' , '1914' , 'CERA DELLA LITURGIA' , '24' , '-24' , '1' ,
'4.7' , '3.8524590163934' , '22' , '0' , '112.80' )
20/03/2026 11:20:13 am >> SELECT document_num FROM ps_document
WHERE document_num = '826' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-03-20')
20/03/2026 11:20: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' ,
'826' ,
'2026-03-20' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'15' ,
'0' ,
'102.00' ,
'83.61' ,
NOW() ,
NOW() )
20/03/2026 11:20: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 = '101828'
20/03/2026 11:20:13 am >> DELETE FROM ps_document_detail WHERE id_document = '101828'
20/03/2026 11:20: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
( '101828' , '15357' , 'AMPOLLE ABBRACCIO NIKEL - 1512' , '1' , '-1' , '1' ,
'102.00' , '83.606557377049' , '22' , '0' , '102.00' )
20/03/2026 11:36:23 am >> SELECT document_num FROM ps_document
WHERE document_num = '827' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-03-20')
20/03/2026 11:36: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' ,
'827' ,
'2026-03-20' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'1' ,
'0' ,
'27.75' ,
'23.60' ,
NOW() ,
NOW() )
20/03/2026 11:36: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 = '101829'
20/03/2026 11:36:23 am >> DELETE FROM ps_document_detail WHERE id_document = '101829'
20/03/2026 11:36: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
( '101829' , '1427' , 'BUSTE PER PALMA BENEDETTA - PZ 200 ' , '2' , '-2' , '1' ,
'11.5' , '9.4262295081967' , '22' , '0' , '23.00' )
20/03/2026 11:36: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
( '101829' , '19158' , 'SETTIMANA SANTA - N.E.' , '1' , '-1' , '4' ,
'5.00' , '5' , '0' , '5' , '4.75' )
20/03/2026 11:48:26 am >> SELECT document_num FROM ps_document
WHERE document_num = '828' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-03-20')
20/03/2026 11:48:26 am >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'828' ,
'2026-03-20' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'1' ,
'0' ,
'75.00' ,
'61.48' ,
NOW() ,
NOW() )
20/03/2026 11:48:26 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '101830'
20/03/2026 11:48:26 am >> DELETE FROM ps_document_detail WHERE id_document = '101830'
20/03/2026 11:48:26 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '101830' , '24865' , 'LAMPADA SANTISSIMO - 303' , '1' , '-1' , '1' ,
'75' , '61.475409836066' , '22' , '0' , '75.00' )
20/03/2026 11:56:53 am >> SELECT document_num FROM ps_document
WHERE document_num = '829' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-03-20')
20/03/2026 11:56:53 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' ,
'829' ,
'2026-03-20' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'1' ,
'0' ,
'120.00' ,
'98.36' ,
NOW() ,
NOW() )
20/03/2026 11:56:53 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 = '101831'
20/03/2026 11:56:53 am >> DELETE FROM ps_document_detail WHERE id_document = '101831'
20/03/2026 11:56:53 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '101831' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '5' , '-5' , '1' ,
'24' , '19.672131147541' , '22' , '0' , '120.00' )
20/03/2026 12:00:31 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '1000000010237' AND id_product != '24865' AND ean13 != ''
20/03/2026 12:00:31 pm >> UPDATE ps_product SET
id_supplier = '12',
reference = '',
ean13 = '1000000010237',
date_upd = NOW()
WHERE id_product = '24865'
20/03/2026 12:00:31 pm >> UPDATE ps_product_lang SET
name = 'LAMPADA SANTISSIMO - 303',
description = ''
WHERE id_product = '24865'
20/03/2026 12:00:31 pm >> UPDATE ps_product SET
wholesale_price = '32.78',
on_sale = '0',
price = '69.67213114754098'
WHERE id_product = '24865'
20/03/2026 12:00:31 pm >> UPDATE ps_product_shop SET
wholesale_price = '32.78',
price = '69.67213114754098',
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 = '24865'
20/03/2026 12:00:31 pm >> DELETE FROM ps_specific_price WHERE id_product = '24865'
20/03/2026 12:12:51 pm >> SELECT document_num FROM ps_document
WHERE document_num = '830' AND id_document != '' AND id_document_type LIKE '13' AND YEAR(document_date) = YEAR('2026-03-20')
20/03/2026 12:12:51 pm >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'830' ,
'2026-03-20' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'1' ,
'0' ,
'28.50' ,
'28.50' ,
NOW() ,
NOW() )
20/03/2026 12:12:51 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '101832'
20/03/2026 12:12:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '101832'
20/03/2026 12:12:51 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '101832' , '22803' , 'PANE E VINO - N.E. - GUIDA 3' , '1' , '-1' , '4' ,
'15.00' , '15' , '0' , '5' , '14.25' )
20/03/2026 12:12:51 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '101832' , '21735' , 'IMPRONTE DI MISERICORDIA - GUIDA 2 - N.E.' , '1' , '-1' , '4' ,
'15.00' , '15' , '0' , '5' , '14.25' )
20/03/2026 12:16:03 pm >> SELECT document_num FROM ps_document
WHERE document_num = '831' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-03-20')
20/03/2026 12:16:03 pm >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'831' ,
'2026-03-20' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'1' ,
'0' ,
'210.00' ,
'180.73' ,
NOW() ,
NOW() )
20/03/2026 12:16:03 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '101833'
20/03/2026 12:16:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '101833'
20/03/2026 12:16:03 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '101833' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '6' , '-6' , '1' ,
'24' , '19.672131147541' , '22' , '0' , '144.00' )
20/03/2026 12:16:03 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '101833' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' ,
'11.00' , '9.016393442623' , '22' , '0' , '11.00' )
20/03/2026 12:16:03 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '101833' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '6' , '-6' , '3' ,
'3.70' , '3.5576923076923' , '4' , '0' , '22.20' )
20/03/2026 12:16:03 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '101833' , '20429' , 'OSTIA SENZA TOSTATURA MORREALE - OS25' , '6' , '-6' , '3' ,
'2.00' , '1.9230769230769' , '4' , '0' , '12.00' )
20/03/2026 12:16:03 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '101833' , '11151' , 'LIBRI' , '1' , '-1' , '4' ,
'20.8' , '20.8' , '0' , '0' , '20.80' )
20/03/2026 01:00: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 (
'31' ,
'1161' ,
'2025-11-28' ,
'' ,
'0' ,
'175' ,
'4678840' ,
'VIA CALENDONE 22/24 23887 OLGIATE MOLGORA' ,
'' ,
'' ,
'2.54' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'9' ,
'0' ,
'5451.84' ,
'4469.18' ,
NOW() ,
NOW() )
20/03/2026 01:00: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 = '101834'
20/03/2026 01:00:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '101834'
20/03/2026 01:00: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
( '101834' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '503' , '503' , '1' ,
'8.88' , '7.2786885245902' , '22' , '0' , '5449.3008' )
20/03/2026 01:00:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20791' AND id_supplier = '175'
20/03/2026 01:00:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20791' , '175' , '1' )
20/03/2026 04:38:48 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() )
20/03/2026 04:38:48 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24881' , '1' , '' , 'nuovo-prodotto' )
20/03/2026 04:38:48 pm >> INSERT INTO ps_product_shop (
id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd`
) VALUES (
'24881' , '1' , '1' , '2' , NOW() , NOW()
)
20/03/2026 04:38:48 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '24881' , '0' , '1' , '0' , '0' )
20/03/2026 04:43:08 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791280736734' AND id_product != '24881' AND ean13 != ''
20/03/2026 04:43:08 pm >> UPDATE ps_product SET
id_supplier = '',
reference = '1/3',
ean13 = '9791280736734',
date_upd = NOW()
WHERE id_product = '24881'
20/03/2026 04:43:08 pm >> UPDATE ps_product_lang SET
name = 'CARTA D’IDENTITA’ DI MARIA DI NAZARET - R. LUPI',
description = 'Questo sussidio vuole aiutarci, in modo semplice e sintetico, a conoscere Maria di Nazaret, la donna più illustre e più celebrata al mondo. Maria era una semplice e umile fanciulla di un paese sconosciuto della Palestina, la sua fama e la sua notorietà le vengono dall’aver pronunciato un “sì” convinto e totale alla richiesta dell’angelo di accogliere la volontà di Dio su di lei e diventare la Madre di Gesù, il Figlio di Dio. Attraverso Maria, Dio è entrato nella storia ed è diventato uno di noi per presentarci e realizzare il progetto di salvezza verso l’umanità. Per questo, la Vergine Maria, con la sua vita, ci insegna a dire un “sì” deciso, senza dubbi o paure, alla volontà di Dio. Siamone certi, Maria non ci lascia soli, intercede per noi presso il suo Figlio Gesù, affinché possiamo essere dei buoni cristiani, realizzando il progetto di Dio sulla nostra vita, perché lei è Madre della Chiesa e aiuto dei cristiani.
'
WHERE id_product = '24881'
20/03/2026 04:43:08 pm >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '5'
WHERE id_product = '24881'
20/03/2026 04:43:08 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '5',
id_tax_rules_group = '4',
id_category_default = '395',
id_argoment_default = '41',
id_internal_category = '4',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '24881'
20/03/2026 04:43:08 pm >> DELETE FROM ps_specific_price WHERE id_product = '24881'
20/03/2026 04:45:09 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791280736734' AND id_product != '24881' AND ean13 != ''
20/03/2026 04:45:09 pm >> UPDATE ps_product SET
id_supplier = '',
reference = '1/3',
ean13 = '9791280736734',
date_upd = NOW()
WHERE id_product = '24881'
20/03/2026 04:45:09 pm >> UPDATE ps_product_lang SET
name = 'CARTA D’IDENTITA’ DI MARIA DI NAZARET - R. LUPI',
description = 'Questo sussidio vuole aiutarci, in modo semplice e sintetico, a conoscere Maria di Nazaret, la donna più illustre e più celebrata al mondo. Maria era una semplice e umile fanciulla di un paese sconosciuto della Palestina, la sua fama e la sua notorietà le vengono dall’aver pronunciato un “sì” convinto e totale alla richiesta dell’angelo di accogliere la volontà di Dio su di lei e diventare la Madre di Gesù, il Figlio di Dio. Attraverso Maria, Dio è entrato nella storia ed è diventato uno di noi per presentarci e realizzare il progetto di salvezza verso l’umanità. Per questo, la Vergine Maria, con la sua vita, ci insegna a dire un “sì” deciso, senza dubbi o paure, alla volontà di Dio. Siamone certi, Maria non ci lascia soli, intercede per noi presso il suo Figlio Gesù, affinché possiamo essere dei buoni cristiani, realizzando il progetto di Dio sulla nostra vita, perché lei è Madre della Chiesa e aiuto dei cristiani.
'
WHERE id_product = '24881'
20/03/2026 04:45:09 pm >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '5'
WHERE id_product = '24881'
20/03/2026 04:45:09 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '5',
id_tax_rules_group = '4',
id_category_default = '395',
id_argoment_default = '41',
id_internal_category = '4',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '24881'
20/03/2026 04:45:09 pm >> DELETE FROM ps_specific_price WHERE id_product = '24881'
20/03/2026 04:46:13 pm >> UPDATE ps_product_shop SET active = '1' WHERE id_product = '24881'
20/03/2026 05:23:58 pm >> SELECT document_num FROM ps_document
WHERE document_num = '832' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-03-20')
20/03/2026 05:23: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' ,
'832' ,
'2026-03-20' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'15' ,
'0' ,
'28.50' ,
'28.50' ,
NOW() ,
NOW() )
20/03/2026 05:23: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 = '101835'
20/03/2026 05:23:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '101835'
20/03/2026 05:23: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
( '101835' , '11309' , 'VIA CRUCIS PER LUOMO D/ NOSTRO TEMPO - VIA CRUCIS' , '15' , '-15' , '4' ,
'2.00' , '2' , '0' , '5' , '28.50' )
20/03/2026 06:55:35 pm >> SELECT document_num FROM ps_document
WHERE document_num = '833' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-03-20')
20/03/2026 06:55: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' ,
'833' ,
'2026-03-20' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'1' ,
'0' ,
'108.50' ,
'89.98' ,
NOW() ,
NOW() )
20/03/2026 06:55: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 = '101836'
20/03/2026 06:55:35 pm >> DELETE FROM ps_document_detail WHERE id_document = '101836'
20/03/2026 06:55: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
( '101836' , '11626' , 'PURIFICATOIO 28X48 - SERV 1' , '3' , '-3' , '1' ,
'7.80' , '6.3934426229508' , '22' , '0' , '23.40' )
20/03/2026 06:55: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
( '101836' , '11626' , 'PURIFICATOIO 28X48 - SERV 1' , '3' , '-3' , '1' ,
'7.80' , '6.3934426229508' , '22' , '0' , '23.40' )
20/03/2026 06:55: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
( '101836' , '11625' , 'CORPORALE - 47X47 - SERV 4' , '3' , '-3' , '1' ,
'12.20' , '10' , '22' , '0' , '36.60' )
20/03/2026 06:55: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
( '101836' , '11624' , 'PALLA 16X16 - SERV 3 ' , '3' , '-3' , '1' ,
'5.90' , '4.8360655737705' , '22' , '0' , '17.70' )
20/03/2026 06:55: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
( '101836' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' , '-2' , '3' ,
'3.70' , '3.5576923076923' , '4' , '0' , '7.40' )
20/03/2026 07:04:24 pm >> SELECT document_num FROM ps_document
WHERE document_num = '834' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-03-20')
20/03/2026 07:04:24 pm >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'834' ,
'2026-03-20' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'15' ,
'0' ,
'149.00' ,
'122.13' ,
NOW() ,
NOW() )
20/03/2026 07:04:24 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '101837'
20/03/2026 07:04:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '101837'
20/03/2026 07:04:24 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '101837' , '15210' , 'CERO PASQUALE API 80X120' , '1' , '-1' , '1' ,
'149' , '122.13114754098' , '22' , '0' , '149.00' )
20/03/2026 07:07:59 pm >> SELECT document_num FROM ps_document
WHERE document_num = '835' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-03-20')
20/03/2026 07:07:59 pm >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'835' ,
'2026-03-20' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'15' ,
'0' ,
'15.00' ,
'15.00' ,
NOW() ,
NOW() )
20/03/2026 07:07:59 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '101838'
20/03/2026 07:07:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '101838'
20/03/2026 07:07:59 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '101838' , '11151' , 'LIBRI' , '1' , '-1' , '4' ,
'15' , '15' , '0' , '0' , '15.00' )