26/11/2025 08:43:09 am >> INSERT INTO ps_customer
( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` )
VALUES
( '1' , '' , '' , '' , 'cby1nbYkDDyz24Ty' , NOW() , NOW() )
26/11/2025 08:43:09 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4290' , '1' )
26/11/2025 08:43:09 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4290' , '2' )
26/11/2025 08:43:09 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4290' , '3' )
26/11/2025 08:44:18 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4290'
26/11/2025 08:44:19 am >> INSERT INTO ps_address
( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd )
VALUES (
'4290' ,
'10' ,
'208' ,
'' ,
'PONZI' ,
'MARIA' ,
'VIA GIOVANNI BETTOLO 4' ,
'' ,
'00195' ,
'ROMA' ,
'' ,
'' ,
'335 8391074' ,
'' ,
'' ,
NOW() ,
NOW() )
26/11/2025 08:44:19 am >> UPDATE ps_customer SET
email = 'mp.mariaponzi@gmail.com',
sdi = '',
pec = '',
date_upd = NOW()
WHERE id_customer = '4290'
26/11/2025 08:49:48 am >> SELECT document_num FROM ps_document
WHERE document_num = '258' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-11-26')
26/11/2025 08:49: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 (
'21' ,
'258' ,
'2025-11-26' ,
'' ,
'4290' ,
'0' ,
'4679660' ,
'VIA GIOVANNI BETTOLO 4 00195 ROMA' ,
'' ,
'' ,
'5' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'9' ,
'0' ,
'12.98' ,
'12.98' ,
NOW() ,
NOW() )
26/11/2025 08:49: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 = '100084'
26/11/2025 08:49:48 am >> DELETE FROM ps_document_detail WHERE id_document = '100084'
26/11/2025 08:49: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
( '100084' , '20953' , 'VANGELO E ATTI DEGLI APOSTOLI' , '3' , '-3' , '4' ,
'2.80' , '2.8' , '0' , '5' , '7.98' )
26/11/2025 08:50:39 am >> INSERT INTO ps_customer
( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` )
VALUES
( '1' , '' , '' , '' , 'edg8YMefTn8MfMjM' , NOW() , NOW() )
26/11/2025 08:50:39 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4291' , '1' )
26/11/2025 08:50:39 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4291' , '2' )
26/11/2025 08:50:39 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4291' , '3' )
26/11/2025 08:52:25 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4291'
26/11/2025 08:52:25 am >> INSERT INTO ps_address
( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd )
VALUES (
'4291' ,
'10' ,
'201' ,
'' ,
'POLI' ,
'LORENA ' ,
'VIA DELL\'ALLORO 2B' ,
'' ,
'59100' ,
'PRATO' ,
'ORDINA MASSIMO MARIOTTI\r\navvocatomassimomariotti@gmail.com\r\n0574.1747158' ,
'' ,
'' ,
'' ,
'' ,
NOW() ,
NOW() )
26/11/2025 08:52:25 am >> UPDATE ps_customer SET
email = '',
sdi = '',
pec = '',
date_upd = NOW()
WHERE id_customer = '4291'
26/11/2025 08:53:24 am >> SELECT document_num FROM ps_document
WHERE document_num = '259' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-11-26')
26/11/2025 08:53: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 (
'21' ,
'259' ,
'2025-11-26' ,
'' ,
'4291' ,
'0' ,
'4679661' ,
'VIA DELL\\\'ALLORO 2B 59100 PRATO' ,
'' ,
'' ,
'5' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'9' ,
'0' ,
'48.23' ,
'48.23' ,
NOW() ,
NOW() )
26/11/2025 08:53: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 = '100085'
26/11/2025 08:53:24 am >> DELETE FROM ps_document_detail WHERE id_document = '100085'
26/11/2025 08:53: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
( '100085' , '2679' , 'CONOSCERE GESU\'' , '13' , '-13' , '4' ,
'3.50' , '3.5' , '0' , '5' , '43.23' )
26/11/2025 09:14:56 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() )
26/11/2025 09:14:56 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24323' , '1' , '' , 'nuovo-prodotto' )
26/11/2025 09:14:56 am >> INSERT INTO ps_product_shop (
id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd`
) VALUES (
'24323' , '1' , '1' , '2' , NOW() , NOW()
)
26/11/2025 09:14:56 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '24323' , '0' , '1' , '0' , '0' )
26/11/2025 09:15:46 am >> SELECT ean13 FROM ps_product WHERE ean13 = '000205' AND id_product != '24323' AND ean13 != ''
26/11/2025 09:15:46 am >> UPDATE ps_product SET
id_supplier = '',
reference = '',
ean13 = '000205',
date_upd = NOW()
WHERE id_product = '24323'
26/11/2025 09:15:46 am >> UPDATE ps_product_lang SET
name = 'casula rosa - 529tp',
description = ''
WHERE id_product = '24323'
26/11/2025 09:15:46 am >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '61.47540983606557'
WHERE id_product = '24323'
26/11/2025 09:15:46 am >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '61.47540983606557',
id_tax_rules_group = '1',
id_category_default = '396',
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 = '24323'
26/11/2025 09:15:46 am >> DELETE FROM ps_specific_price WHERE id_product = '24323'
26/11/2025 09:15:48 am >> INSERT INTO ps_product (
id_tax_rules_group , `date_add` , `date_upd`
) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '24323'
26/11/2025 09:15:48 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24324' , '1' , '' , 'nuovo-prodotto' )
26/11/2025 09:15:48 am >> INSERT INTO ps_product_shop (
id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd`
) SELECT '24324' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '24323'
26/11/2025 09:15:48 am >> INSERT INTO `ps_stock_available` (
id_product , id_product_attribute , id_shop , id_shop_group , quantity
) SELECT '24324' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '24323'
26/11/2025 09:16:14 am >> SELECT ean13 FROM ps_product WHERE ean13 = '000205' AND id_product != '24323' AND ean13 != ''
26/11/2025 09:16:14 am >> UPDATE ps_product SET
id_supplier = '',
reference = '',
ean13 = '000205',
date_upd = NOW()
WHERE id_product = '24323'
26/11/2025 09:16:14 am >> UPDATE ps_product_lang SET
name = 'CASULA ROSA - 529TP',
description = ''
WHERE id_product = '24323'
26/11/2025 09:16:14 am >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '61.4754'
WHERE id_product = '24323'
26/11/2025 09:16:14 am >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '61.4754',
id_tax_rules_group = '1',
id_category_default = '396',
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 = '24323'
26/11/2025 09:16:14 am >> DELETE FROM ps_specific_price WHERE id_product = '24323'
26/11/2025 09:19:20 am >> SELECT ean13 FROM ps_product WHERE ean13 = '000264' AND id_product != '23168' AND ean13 != ''
26/11/2025 09:19:20 am >> UPDATE ps_product SET
id_supplier = '89',
reference = '',
ean13 = '000264',
date_upd = NOW()
WHERE id_product = '23168'
26/11/2025 09:19:20 am >> UPDATE ps_product_lang SET
name = 'CAMICE IN MICROFIBRA COCOLLE - 434/PMA',
description = ''
WHERE id_product = '23168'
26/11/2025 09:19:20 am >> UPDATE ps_product SET
wholesale_price = '30.50',
on_sale = '0',
price = '61.47540983606557'
WHERE id_product = '23168'
26/11/2025 09:19:20 am >> UPDATE ps_product_shop SET
wholesale_price = '30.50',
price = '61.47540983606557',
id_tax_rules_group = '1',
id_category_default = '396',
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 = '23168'
26/11/2025 09:19:20 am >> DELETE FROM ps_specific_price WHERE id_product = '23168'
26/11/2025 09:19: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 (
'31' ,
'645' ,
'2025-11-20' ,
'' ,
'0' ,
'89' ,
'2729' ,
'VIA COLLE DI NAVA, 127D 12060 MAGLIANO ALPI' ,
'' ,
'' ,
'15' ,
'1' ,
'0' ,
'0' ,
'0' ,
'' ,
'10' ,
'0' ,
'518.50' ,
'425.00' ,
NOW() ,
NOW() )
26/11/2025 09:19: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 = '100086'
26/11/2025 09:19:55 am >> DELETE FROM ps_document_detail WHERE id_document = '100086'
26/11/2025 09:19: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
( '100086' , '24323' , 'CASULA ROSA - 529TP' , '1' , '1' , '1' ,
'30.6' , '25.081967213115' , '22' , '0' , '37.3320' )
26/11/2025 09:19:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '24323' AND id_supplier = '89'
26/11/2025 09:19:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24323' , '89' , '1' )
26/11/2025 09:19: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
( '100086' , '14088' , 'CAMICE IN MICROFIBRA - 429/PMA' , '4' , '4' , '1' ,
'24.1' , '19.754098360656' , '22' , '0' , '117.6080' )
26/11/2025 09:19:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '14088' AND id_supplier = '89'
26/11/2025 09:19:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14088' , '89' , '1' )
26/11/2025 09:19: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
( '100086' , '23717' , 'CASULA - 60530 TP' , '1' , '1' , '1' ,
'46' , '37.704918032787' , '22' , '0' , '56.1200' )
26/11/2025 09:19:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '23717' AND id_supplier = '89'
26/11/2025 09:19:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23717' , '89' , '1' )
26/11/2025 09:19: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
( '100086' , '14362' , 'CAMICE SVASATO - 434/TPA' , '5' , '5' , '1' ,
'29.1' , '23.852459016393' , '22' , '0' , '177.5100' )
26/11/2025 09:19:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '14362' AND id_supplier = '89'
26/11/2025 09:19:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14362' , '89' , '1' )
26/11/2025 09:19: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
( '100086' , '23168' , 'CAMICE IN MICROFIBRA COCOLLE - 434/PMA' , '3' , '3' , '1' ,
'30.5' , '25' , '22' , '0' , '111.6300' )
26/11/2025 09:19:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '23168' AND id_supplier = '89'
26/11/2025 09:19:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23168' , '89' , '1' )
26/11/2025 10:13:59 am >> SELECT document_num FROM ps_document
WHERE document_num = '144/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-11-26')
26/11/2025 10:13:59 am >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'24' ,
'144/A' ,
'2025-11-26' ,
'A' ,
'333' ,
'0' ,
'4679537' ,
'P.ZZA S. MICHELE 84135 RUFOLI' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'104.00' ,
'85.81' ,
NOW() ,
NOW() )
26/11/2025 10:13:59 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100087'
26/11/2025 10:13:59 am >> DELETE FROM ps_document_detail WHERE id_document = '100087'
26/11/2025 10:13:59 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '100087' , '12531' , 'LAMPADA A SFERA ROSSA' , '4' , '-4' , '1' ,
'25.00' , '20.491803278689' , '22' , '0' , '100.00' )
26/11/2025 10:13:59 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '100087' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' ,
'2.00' , '1.9230769230769' , '4' , '0' , '4.00' )
26/11/2025 10:17:39 am >> SELECT document_num FROM ps_document
WHERE document_num = '3921' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-26')
26/11/2025 10:17:39 am >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'3921' ,
'2025-11-26' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'1.00' ,
'0.82' ,
NOW() ,
NOW() )
26/11/2025 10:17:39 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100088'
26/11/2025 10:17:39 am >> DELETE FROM ps_document_detail WHERE id_document = '100088'
26/11/2025 10:17:39 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '100088' , '17005' , 'BIGLIETTO AUGURALE medio' , '1' , '-1' , '1' ,
'1.00' , '0.81967213114754' , '22' , '0' , '1.00' )
26/11/2025 10:32:30 am >> SELECT document_num FROM ps_document
WHERE document_num = '3922' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-26')
26/11/2025 10:32:30 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' ,
'3922' ,
'2025-11-26' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'35.00' ,
'28.69' ,
NOW() ,
NOW() )
26/11/2025 10:32:30 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 = '100089'
26/11/2025 10:32:30 am >> DELETE FROM ps_document_detail WHERE id_document = '100089'
26/11/2025 10:32:30 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '100089' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' ,
'35' , '28.688524590164' , '22' , '0' , '35.00' )
26/11/2025 10:33:25 am >> SELECT document_num FROM ps_document
WHERE document_num = '3923' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-26')
26/11/2025 10:33:25 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' ,
'3923' ,
'2025-11-26' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'28.50' ,
'28.50' ,
NOW() ,
NOW() )
26/11/2025 10:33:25 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 = '100090'
26/11/2025 10:33:25 am >> DELETE FROM ps_document_detail WHERE id_document = '100090'
26/11/2025 10:33: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
( '100090' , '17393' , 'BREVE STORIA DELLA CHIESA - A. FRANZEN' , '1' , '-1' , '4' ,
'30.00' , '30' , '0' , '5' , '28.50' )
26/11/2025 11:13:32 am >> SELECT document_num FROM ps_document
WHERE document_num = '260' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-11-26')
26/11/2025 11:13:32 am >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'21' ,
'260' ,
'2025-11-26' ,
'' ,
'132' ,
'0' ,
'4679425' ,
'L. GO S. MICHELE 84085 ACQUAROLA - MERCATO S. SEVERINO' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'1' ,
'0' ,
'98.77' ,
'98.77' ,
NOW() ,
NOW() )
26/11/2025 11:13:32 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100091'
26/11/2025 11:13:32 am >> DELETE FROM ps_document_detail WHERE id_document = '100091'
26/11/2025 11:13:32 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '100091' , '2679' , 'CONOSCERE GESU\'' , '6' , '-6' , '4' ,
'3.50' , '3.5' , '0' , '15' , '17.85' )
26/11/2025 11:13:32 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '100091' , '5457' , 'IO SONO CON VOI 1 PARTE' , '6' , '-6' , '4' ,
'2.80' , '2.8' , '0' , '15' , '14.28' )
26/11/2025 11:13:32 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '100091' , '5458' , 'IO SONO CON VOI 2 PARTE' , '10' , '-10' , '4' ,
'2.80' , '2.8' , '0' , '15' , '23.80' )
26/11/2025 11:13:32 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '100091' , '11191' , 'VENITE CON ME 1 PARTE' , '8' , '-8' , '4' ,
'2.80' , '2.8' , '0' , '15' , '19.04' )
26/11/2025 11:13:32 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '100091' , '11192' , 'VENITE CON ME 2 PARTE' , '10' , '-10' , '4' ,
'2.80' , '2.8' , '0' , '15' , '23.80' )
26/11/2025 11:15:52 am >> SELECT document_num FROM ps_document
WHERE document_num = '3924' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-26')
26/11/2025 11:15:52 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' ,
'3924' ,
'2025-11-26' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'26.36' ,
'26.36' ,
NOW() ,
NOW() )
26/11/2025 11:15:52 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 = '100092'
26/11/2025 11:15:52 am >> DELETE FROM ps_document_detail WHERE id_document = '100092'
26/11/2025 11:15:52 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '100092' , '24201' , 'PORTA IL DONO' , '1' , '-1' , '4' ,
'2.80' , '2.8' , '0' , '5' , '2.66' )
26/11/2025 11:15:52 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '100092' , '21418' , 'CRISTO NOSTRA PACE - V. SALVORDI' , '1' , '-1' , '4' ,
'2.50' , '2.5' , '0' , '0' , '2.50' )
26/11/2025 11:15:52 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '100092' , '21417' , 'VIENI, NON TARDARE SIGNORE, NOSTRA PACE!' , '1' , '-1' , '4' ,
'2.50' , '2.5' , '0' , '0' , '2.50' )
26/11/2025 11:15:52 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '100092' , '24188' , 'MA ANCHE NO - F. ROSINI' , '1' , '-1' , '4' ,
'18.00' , '18' , '0' , '5' , '17.10' )
26/11/2025 11:15:52 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '100092' , '23807' , 'CALENDARIO LITURGICO 2026' , '2' , '-2' , '4' ,
'0.80' , '0.8' , '0' , '0' , '1.60' )
26/11/2025 11:25:00 am >> SELECT document_num FROM ps_document
WHERE document_num = '261' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-11-26')
26/11/2025 11:25:01 am >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'21' ,
'261' ,
'2025-11-26' ,
'' ,
'27' ,
'0' ,
'4677541' ,
'P.ZZA PIRONTI 83025 PIANO DI MONTORO' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'1' ,
'0' ,
'37.66' ,
'37.66' ,
NOW() ,
NOW() )
26/11/2025 11:25: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 = '100093'
26/11/2025 11:25:01 am >> DELETE FROM ps_document_detail WHERE id_document = '100093'
26/11/2025 11:25: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
( '100093' , '19977' , 'MINISTRANTI IERI, OGGI, DOMANI' , '16' , '-16' , '4' ,
'2.50' , '2.5' , '0' , '15' , '34.00' )
26/11/2025 11:25: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
( '100093' , '17257' , 'IO TI BATTEZZO ' , '1' , '-1' , '4' ,
'1.80' , '1.8' , '0' , '15' , '1.53' )
26/11/2025 11:25: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
( '100093' , '17163' , 'SPIRITO SANTO SPIEGATO AI RAGAZZI' , '1' , '-1' , '4' ,
'2.50' , '2.5' , '0' , '15' , '2.13' )
26/11/2025 11:34:01 am >> SELECT document_num FROM ps_document
WHERE document_num = '3925' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-26')
26/11/2025 11:34:01 am >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'3925' ,
'2025-11-26' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'147.75' ,
'126.11' ,
NOW() ,
NOW() )
26/11/2025 11:34: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 = '100094'
26/11/2025 11:34:01 am >> DELETE FROM ps_document_detail WHERE id_document = '100094'
26/11/2025 11:34: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
( '100094' , '24050' , 'GRIDIAMO IL VANGELO ANNO A - A. COMASTRI' , '1' , '-1' , '4' ,
'25.00' , '25' , '0' , '5' , '23.75' )
26/11/2025 11:34: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
( '100094' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '2' , '-2' , '4' ,
'2' , '2' , '0' , '0' , '4.00' )
26/11/2025 11:34:02 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '100094' , '19072' , 'BAMBINELLO CON AUREOLA CM 37 - PB9257' , '1' , '-1' , '1' ,
'85' , '69.672131147541' , '22' , '0' , '85.00' )
26/11/2025 11:34:02 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '100094' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' ,
'35' , '28.688524590164' , '22' , '0' , '35.00' )
26/11/2025 11:36:33 am >> SELECT document_num FROM ps_document
WHERE document_num = '3926' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-26')
26/11/2025 11:36:33 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' ,
'3926' ,
'2025-11-26' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'64.00' ,
'52.46' ,
NOW() ,
NOW() )
26/11/2025 11:36:33 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 = '100095'
26/11/2025 11:36:33 am >> DELETE FROM ps_document_detail WHERE id_document = '100095'
26/11/2025 11:36:33 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '100095' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '2' , '-2' , '1' ,
'13.00' , '10.655737704918' , '22' , '0' , '26.00' )
26/11/2025 11:36:33 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '100095' , '12849' , 'LIBRO DELLE SS. MESSE' , '2' , '-2' , '1' ,
'20.00' , '16.393442622951' , '22' , '5' , '38.00' )
26/11/2025 11:43:13 am >> SELECT document_num FROM ps_document
WHERE document_num = '3927' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-26')
26/11/2025 11:43: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' ,
'3927' ,
'2025-11-26' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'10.00' ,
'8.20' ,
NOW() ,
NOW() )
26/11/2025 11:43: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 = '100096'
26/11/2025 11:43:13 am >> DELETE FROM ps_document_detail WHERE id_document = '100096'
26/11/2025 11:43: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
( '100096' , '23984' , 'AGENDA 2026' , '1' , '-1' , '1' ,
'10.00' , '8.1967213114754' , '22' , '0' , '10.00' )
26/11/2025 12:07:14 pm >> SELECT document_num FROM ps_document
WHERE document_num = '3928' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-26')
26/11/2025 12:07:14 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' ,
'3928' ,
'2025-11-26' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'99.20' ,
'81.76' ,
NOW() ,
NOW() )
26/11/2025 12:07:14 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 = '100097'
26/11/2025 12:07:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '100097'
26/11/2025 12:07:14 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '100097' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' ,
'16' , '13.114754098361' , '22' , '0' , '16.00' )
26/11/2025 12:07:14 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '100097' , '17872' , 'GIGLER PER LUMINELLO - 474/G' , '1' , '-1' , '1' ,
'3.90' , '3.1967213114754' , '22' , '0' , '3.90' )
26/11/2025 12:07:14 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '100097' , '7553' , 'PARAFIAMMA PIREX PER CARTUCCIA 3.2 - 474/25' , '1' , '-1' , '1' ,
'11.50' , '9.4262295081967' , '22' , '0' , '11.50' )
26/11/2025 12:07:14 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '100097' , '19102' , 'CARBONCINI MM 40' , '1' , '-1' , '1' ,
'13.00' , '10.655737704918' , '22' , '0' , '13.00' )
26/11/2025 12:07:14 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '100097' , '1914' , 'CERA DELLA LITURGIA' , '2' , '-2' , '1' ,
'4.90' , '4.016393442623' , '22' , '0' , '9.80' )
26/11/2025 12:07:14 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '100097' , '24097' , 'AVVENTO E NATALE 2025 - BAMBINI' , '1' , '-1' , '4' ,
'2.50' , '2.5' , '0' , '0' , '2.50' )
26/11/2025 12:07:14 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '100097' , '6811' , 'MOCCOLO 80X200' , '5' , '-5' , '1' ,
'8.5' , '6.9672131147541' , '22' , '0' , '42.50' )
26/11/2025 12:07:47 pm >> SELECT document_num FROM ps_document
WHERE document_num = '3929' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-26')
26/11/2025 12:07:47 pm >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'3929' ,
'2025-11-26' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'0.80' ,
'0.80' ,
NOW() ,
NOW() )
26/11/2025 12:07: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 = '100098'
26/11/2025 12:07:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '100098'
26/11/2025 12:07: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
( '100098' , '23807' , 'CALENDARIO LITURGICO 2026' , '1' , '-1' , '4' ,
'0.80' , '0.8' , '0' , '0' , '0.80' )
26/11/2025 12:13:27 pm >> SELECT document_num FROM ps_document
WHERE document_num = '3863' AND id_document != '100007' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-20')
26/11/2025 12:13:27 pm >> UPDATE ps_document SET
id_document_type = '11',
document_num = '3863',
document_date = '2025-11-20',
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 = '24.50',
price_tax_excluded = '20.08',
date_upd = NOW()
WHERE id_document = '100007'
26/11/2025 12:13:27 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100007'
26/11/2025 12:13:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '100007'
26/11/2025 12:13:27 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '100007' , '6325' , 'MEDAGLIA MIRACOLOSA MM 22 - METALLO OX' , '62' , '-62' , '1' ,
'0.2500' , '0.20491803278689' , '22' , '0' , '15.50' )
26/11/2025 12:13:27 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '100007' , '23984' , 'AGENDA 2026' , '1' , '-1' , '1' ,
'9' , '7.3770491803279' , '22' , '0' , '9.00' )
26/11/2025 12:21:19 pm >> SELECT document_num FROM ps_document
WHERE document_num = '3930' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-26')
26/11/2025 12:21:19 pm >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'3930' ,
'2025-11-26' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'34.00' ,
'27.87' ,
NOW() ,
NOW() )
26/11/2025 12:21:19 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100099'
26/11/2025 12:21:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '100099'
26/11/2025 12:21:19 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '100099' , '19150' , 'MOCCOLO 70X200' , '3' , '-3' , '1' ,
'8.50' , '6.9672131147541' , '22' , '0' , '25.50' )
26/11/2025 12:21:19 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '100099' , '6811' , 'MOCCOLO 80X200' , '1' , '-1' , '1' ,
'8.5' , '6.9672131147541' , '22' , '0' , '8.50' )
26/11/2025 12:21:29 pm >> SELECT document_num FROM ps_document
WHERE document_num = '3931' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-26')
26/11/2025 12:21:29 pm >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'3931' ,
'2025-11-26' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'0.80' ,
'0.80' ,
NOW() ,
NOW() )
26/11/2025 12:21:29 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100100'
26/11/2025 12:21:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '100100'
26/11/2025 12:21:29 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '100100' , '23807' , 'CALENDARIO LITURGICO 2026' , '1' , '-1' , '4' ,
'0.80' , '0.8' , '0' , '0' , '0.80' )
26/11/2025 12:27:42 pm >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'31' ,
'3631' ,
'2025-11-24' ,
'' ,
'0' ,
'12' ,
'2607' ,
'VIA NAZIONALE NORD, 4 - LAGARO 40035 CASTIGLIONE DEI PEPOLI' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'9' ,
'0' ,
'148.23' ,
'121.50' ,
NOW() ,
NOW() )
26/11/2025 12:27:42 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100101'
26/11/2025 12:27:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '100101'
26/11/2025 12:27:42 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '100101' , '1749' , 'CARTUCCIA TRASPARENTE DIAM. 5 - 456 ' , '9' , '9' , '1' ,
'15.00' , '12.295081967213' , '22' , '10' , '148.2300' )
26/11/2025 12:27:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1749' AND id_supplier = '12'
26/11/2025 12:27:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1749' , '12' , '1' )
26/11/2025 12:36:26 pm >> SELECT document_num FROM ps_document
WHERE document_num = '3932' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-26')
26/11/2025 12:36:27 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' ,
'3932' ,
'2025-11-26' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'74.00' ,
'61.93' ,
NOW() ,
NOW() )
26/11/2025 12:36:27 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100102'
26/11/2025 12:36:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '100102'
26/11/2025 12:36:27 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '100102' , '22962' , 'VINO BIANCO DOLCE MIGNON' , '5' , '-5' , '1' ,
'3.30' , '2.7049180327869' , '22' , '0' , '16.50' )
26/11/2025 12:36:27 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '100102' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' ,
'2.00' , '1.9230769230769' , '4' , '0' , '2.00' )
26/11/2025 12:36:27 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '100102' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '2' , '-2' , '3' ,
'3.50' , '3.3653846153846' , '4' , '0' , '7.00' )
26/11/2025 12:36:27 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '100102' , '11623' , 'MANUTERGIO 28X48 - SERV 2' , '2' , '-2' , '1' ,
'6.70' , '5.4918032786885' , '22' , '0' , '13.40' )
26/11/2025 12:36:27 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '100102' , '11626' , 'PURIFICATOIO 28X48 - SERV 1' , '2' , '-2' , '1' ,
'7.80' , '6.3934426229508' , '22' , '0' , '15.60' )
26/11/2025 12:36:27 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '100102' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' ,
'19.5' , '15.983606557377' , '22' , '0' , '19.50' )
26/11/2025 12:45:21 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '1000000007763' AND id_product != '17986' AND ean13 != ''
26/11/2025 12:45:21 pm >> UPDATE ps_product SET
id_supplier = '12',
reference = '',
ean13 = '1000000007763',
date_upd = NOW()
WHERE id_product = '17986'
26/11/2025 12:45:21 pm >> UPDATE ps_product_lang SET
name = 'PATENA 15,5 - 1900',
description = ''
WHERE id_product = '17986'
26/11/2025 12:45:21 pm >> UPDATE ps_product SET
wholesale_price = '20.90',
on_sale = '0',
price = '43.442622950819676'
WHERE id_product = '17986'
26/11/2025 12:45:21 pm >> UPDATE ps_product_shop SET
wholesale_price = '20.90',
price = '43.442622950819676',
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 = '17986'
26/11/2025 12:45:21 pm >> DELETE FROM ps_specific_price WHERE id_product = '17986'
26/11/2025 12:47:07 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '1000000014570' AND id_product != '24324' AND ean13 != ''
26/11/2025 12:47:07 pm >> UPDATE ps_product SET
id_supplier = '',
reference = '',
ean13 = '1000000014570',
date_upd = NOW()
WHERE id_product = '24324'
26/11/2025 12:47:07 pm >> UPDATE ps_product_lang SET
name = 'PORTAVETRO DA APPOGGIO - 584',
description = ''
WHERE id_product = '24324'
26/11/2025 12:47:07 pm >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '48.36065573770492'
WHERE id_product = '24324'
26/11/2025 12:47:07 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '48.36065573770492',
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 = '24324'
26/11/2025 12:47:07 pm >> DELETE FROM ps_specific_price WHERE id_product = '24324'
26/11/2025 12:47:13 pm >> INSERT INTO ps_product (
id_tax_rules_group , `date_add` , `date_upd`
) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '24324'
26/11/2025 12:47:13 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24325' , '1' , '' , 'nuovo-prodotto' )
26/11/2025 12:47:13 pm >> INSERT INTO ps_product_shop (
id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd`
) SELECT '24325' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '24324'
26/11/2025 12:47:13 pm >> INSERT INTO `ps_stock_available` (
id_product , id_product_attribute , id_shop , id_shop_group , quantity
) SELECT '24325' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '24324'
26/11/2025 12:47:54 pm >> UPDATE ps_document SET
id_document_type = '31',
document_num = '3631',
document_date = '2025-11-24',
document_letter = '',
id_customer = '0',
id_supplier = '',
id_address = '2607',
address1 = 'VIA NAZIONALE NORD, 4 - LAGARO 40035 CASTIGLIONE DEI PEPOLI',
address2 = '',
note = '',
price_shipping = '12',
id_tax_shipping_rules = '1',
colli = '0',
peso = '0',
porto_e_imballo = '0',
mezzo_consegna = '',
id_payment = '9',
id_causal = '0',
price_tax_included = '654.23',
price_tax_excluded = '536.25',
date_upd = NOW()
WHERE id_document = '100101'
26/11/2025 12:47:54 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 = '100101'
26/11/2025 12:47:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '100101'
26/11/2025 12:47:54 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '100101' , '1749' , 'CARTUCCIA TRASPARENTE DIAM. 5 - 456 ' , '9' , '9' , '1' ,
'6.5' , '5.327868852459' , '22' , '10' , '64.2330' )
26/11/2025 12:47:54 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '100101' , '1750' , 'CARTUCCIA TRASPARENTE DIAM. 3,2 - 454' , '10' , '10' , '1' ,
'6' , '4.9180327868852' , '22' , '10' , '65.8800' )
26/11/2025 12:47:54 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '100101' , '1751' , 'CARTUCCIA TRASPARENTE DIAM. 4 - 455' , '5' , '5' , '1' ,
'6' , '4.9180327868852' , '22' , '10' , '32.9400' )
26/11/2025 12:47:54 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '100101' , '12203' , 'VETRO ANTIVENTO PER F. CAND. DIAM. 5 - 73/50' , '2' , '2' , '1' ,
'9.5' , '7.7868852459016' , '22' , '10' , '20.8620' )
26/11/2025 12:47:54 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '100101' , '546' , 'AMPOLLE SU VASSOIO VETRO - 1500' , '1' , '1' , '1' ,
'23' , '18.852459016393' , '22' , '10' , '25.2540' )
26/11/2025 12:47:54 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '100101' , '17872' , 'GIGLER PER LUMINELLO - 474/G' , '2' , '2' , '1' ,
'2.5' , '2.0491803278689' , '22' , '10' , '5.4900' )
26/11/2025 12:47:54 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '100101' , '7553' , 'PARAFIAMMA PIREX PER CARTUCCIA 3.2 - 474/25' , '4' , '4' , '1' ,
'5' , '4.0983606557377' , '22' , '10' , '21.9600' )
26/11/2025 12:47:54 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '100101' , '18799' , 'PARAFIAMMA PIREX PER CARTUCCIA 4 CM - 474/30' , '4' , '4' , '1' ,
'5' , '4.0983606557377' , '22' , '10' , '21.9600' )
26/11/2025 12:47:54 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '100101' , '16767' , 'COPPIA CANDELIERI DA PROCESSIONE - 2591' , '1' , '1' , '1' ,
'91' , '74.590163934426' , '22' , '10' , '99.9180' )
26/11/2025 12:47: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
( '100101' , '15356' , 'AMPOLLE ABBRACCIO DORATE - 1511' , '1' , '1' , '1' ,
'42.5' , '34.83606557377' , '22' , '10' , '46.6650' )
26/11/2025 12:47: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
( '100101' , '7736' , 'PATENA OTTONE DECORATA - 900/S' , '1' , '1' , '1' ,
'22' , '18.032786885246' , '22' , '10' , '24.1560' )
26/11/2025 12:47: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
( '100101' , '8936' , 'ANTIVENTO PER TORCIA ORO DIAM. 4 - 33' , '3' , '3' , '1' ,
'21' , '17.213114754098' , '22' , '10' , '69.1740' )
26/11/2025 12:47: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
( '100101' , '15768' , 'ANTIVENTO PER TORCIA ORO DIAM. 5 - 35' , '1' , '1' , '1' ,
'21.5' , '17.622950819672' , '22' , '10' , '23.6070' )
26/11/2025 12:47: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
( '100101' , '15000' , 'TECA ALTA IHS - 825' , '1' , '1' , '1' ,
'14' , '11.475409836066' , '22' , '10' , '15.3720' )
26/11/2025 12:47: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
( '100101' , '12200' , 'CANDELIERE FUSO - 643' , '2' , '2' , '1' ,
'9.5' , '7.7868852459016' , '22' , '10' , '20.8620' )
26/11/2025 12:47: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
( '100101' , '12578' , 'RICAMBIO VETRO PER ART. 486 - 65' , '4' , '4' , '1' ,
'7' , '5.7377049180328' , '22' , '10' , '30.7440' )
26/11/2025 12:47: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
( '100101' , '17986' , 'PATENA 15,5 - 1900' , '1' , '1' , '1' ,
'22' , '18.032786885246' , '22' , '10' , '24.1560' )
26/11/2025 12:47: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
( '100101' , '24324' , 'PORTAVETRO DA APPOGGIO - 584' , '1' , '1' , '1' ,
'24' , '19.672131147541' , '22' , '10' , '26.3520' )
26/11/2025 03:06:42 pm >> SELECT document_num FROM ps_document
WHERE document_num = '133/A' AND id_document != '99700' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-11-05')
26/11/2025 03:06:42 pm >> UPDATE ps_document SET
id_document_type = '24',
document_num = '133/A',
document_date = '2025-11-05',
document_letter = 'A',
id_customer = '2757',
id_supplier = '',
id_address = '4679344',
address1 = 'VIA CIRILLO 84085 MERCATO SAN SEVERINO',
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 = '204.09',
price_tax_excluded = '204.09',
date_upd = NOW()
WHERE id_document = '99700'
26/11/2025 03:06:42 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99700'
26/11/2025 03:06:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '99700'
26/11/2025 03:06:42 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99700' , '13397' , 'MIO GESU\'' , '15' , '-15' , '4' ,
'3.5000' , '3.5' , '0' , '15' , '44.63' )
26/11/2025 03:06:42 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99700' , '5457' , 'IO SONO CON VOI 1 PARTE' , '17' , '-17' , '4' ,
'2.8000' , '2.8' , '0' , '15' , '40.46' )
26/11/2025 03:06:42 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99700' , '5458' , 'IO SONO CON VOI 2 PARTE' , '23' , '-23' , '4' ,
'2.8000' , '2.8' , '0' , '15' , '54.74' )
26/11/2025 03:06:42 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99700' , '11191' , 'VENITE CON ME 1 PARTE' , '19' , '-19' , '4' ,
'2.8000' , '2.8' , '0' , '15' , '45.22' )
26/11/2025 03:06:42 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99700' , '11192' , 'VENITE CON ME 2 PARTE' , '8' , '-8' , '4' ,
'2.8000' , '2.8' , '0' , '15' , '19.04' )
26/11/2025 03:27:25 pm >> DELETE FROM ps_product WHERE id_product = '15003'
26/11/2025 03:27:25 pm >> DELETE FROM ps_product_shop WHERE id_product = '15003'
26/11/2025 03:27:25 pm >> DELETE FROM ps_product_lang WHERE id_product = '15003'
26/11/2025 03:27:25 pm >> DELETE FROM ps_stock_available WHERE id_product = '15003'
26/11/2025 03:31:38 pm >> SELECT document_num FROM ps_document
WHERE document_num = '3933' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-26')
26/11/2025 03:31:38 pm >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'3933' ,
'2025-11-26' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'22.00' ,
'18.03' ,
NOW() ,
NOW() )
26/11/2025 03:31:38 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100103'
26/11/2025 03:31:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '100103'
26/11/2025 03:31:38 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '100103' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' ,
'22' , '18.032786885246' , '22' , '0' , '22.00' )
26/11/2025 05:48:21 pm >> SELECT document_num FROM ps_document
WHERE document_num = '3934' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-26')
26/11/2025 05:48:21 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' ,
'3934' ,
'2025-11-26' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'9.50' ,
'9.50' ,
NOW() ,
NOW() )
26/11/2025 05:48:21 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 = '100104'
26/11/2025 05:48:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '100104'
26/11/2025 05:48:21 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '100104' , '24022' , 'SULLA TUA PAROLA NOV/DIC 2025 - 531' , '1' , '-1' , '4' ,
'5.00' , '5' , '0' , '5' , '4.75' )
26/11/2025 05:48:21 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '100104' , '24214' , 'SULLA TUA PAROLA GEN/FEB 2026 - 532' , '1' , '-1' , '4' ,
'5.00' , '5' , '0' , '5' , '4.75' )
26/11/2025 05:50:06 pm >> SELECT document_num FROM ps_document
WHERE document_num = '3935' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-26')
26/11/2025 05:50: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' ,
'3935' ,
'2025-11-26' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'16.50' ,
'13.52' ,
NOW() ,
NOW() )
26/11/2025 05:50: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 = '100105'
26/11/2025 05:50:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '100105'
26/11/2025 05:50: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
( '100105' , '1912' , 'CERA DELL\'EREMO - 415/B ' , '2' , '-2' , '1' ,
'6.50' , '5.327868852459' , '22' , '0' , '13.00' )
26/11/2025 05:50: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
( '100105' , '13049' , 'LITURGICO ART. 60LT BIANCO SUPER' , '1' , '-1' , '1' ,
'3.50' , '2.8688524590164' , '22' , '0' , '3.50' )
26/11/2025 06:20:54 pm >> SELECT document_num FROM ps_document
WHERE document_num = '3936' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-26')
26/11/2025 06:20:54 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' ,
'3936' ,
'2025-11-26' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'4.75' ,
'4.75' ,
NOW() ,
NOW() )
26/11/2025 06:20:54 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 = '100106'
26/11/2025 06:20:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '100106'
26/11/2025 06:20:54 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '100106' , '24214' , 'SULLA TUA PAROLA GEN/FEB 2026 - 532' , '1' , '-1' , '4' ,
'5.00' , '5' , '0' , '5' , '4.75' )
26/11/2025 06:37:03 pm >> SELECT document_num FROM ps_document
WHERE document_num = '3937' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-26')
26/11/2025 06:37: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' ,
'3937' ,
'2025-11-26' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'19.40' ,
'15.90' ,
NOW() ,
NOW() )
26/11/2025 06:37: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 = '100107'
26/11/2025 06:37:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '100107'
26/11/2025 06:37: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
( '100107' , '24124' , 'CALENDARIO DAVVENTO 2025' , '1' , '-1' , '1' ,
'10.00' , '8.1967213114754' , '22' , '5' , '9.50' )
26/11/2025 06:37: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
( '100107' , '24113' , 'NATIVITA CM 6 - ST291-NTD' , '1' , '-1' , '1' ,
'9.90' , '8.1147540983607' , '22' , '0' , '9.90' )
26/11/2025 06:39:04 pm >> UPDATE ps_document SET
id_document_type = '32',
document_num = '2032/2025',
document_date = '2025-09-30',
document_letter = '2025',
id_customer = '0',
id_supplier = '',
id_address = '2638',
address1 = 'VIA COSTABIANCA, 43 60025 LORETO',
address2 = '',
note = '',
price_shipping = '30.00',
id_tax_shipping_rules = '1',
colli = '0',
peso = '0',
porto_e_imballo = '0',
mezzo_consegna = '',
id_payment = '0',
id_causal = '0',
price_tax_included = '970.15',
price_tax_excluded = '795.20',
date_upd = NOW()
WHERE id_document = '99013'
26/11/2025 06:39:04 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99013'
26/11/2025 06:39:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '99013'
26/11/2025 06:39:05 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99013' , '24090' , 'PORTAOSTIE - SC 291-CAL' , '6' , '0' , '1' ,
'5.6000' , '4.5901639344262' , '22' , '10' , '36.89' )
26/11/2025 06:39:05 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99013' , '24091' , 'PORTAOSTIE - SC 291-COM1' , '6' , '0' , '1' ,
'5.6000' , '4.5901639344262' , '22' , '10' , '36.89' )
26/11/2025 06:39:05 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99013' , '24092' , 'PORTAOSTIE - SC 291-COM' , '6' , '0' , '1' ,
'5.6000' , '4.5901639344262' , '22' , '10' , '36.89' )
26/11/2025 06:39:05 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99013' , '24093' , 'ROSARIO ACUTIS - RE 1959-254' , '12' , '0' , '1' ,
'2.3000' , '1.8852459016393' , '22' , '10' , '30.30' )
26/11/2025 06:39:05 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99013' , '22012' , 'CROCE SAN DAMIANO MOGANO 26X19 - PG092' , '2' , '0' , '1' ,
'11.5800' , '9.4918032786885' , '22' , '10' , '25.43' )
26/11/2025 06:39:05 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99013' , '22734' , 'CROCE SAN BENEDETTO - PG680BR' , '2' , '0' , '1' ,
'6.9000' , '5.655737704918' , '22' , '10' , '15.15' )
26/11/2025 06:39:05 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99013' , '20970' , 'CROCE LEGNO S. BENEDETTO - PG681' , '2' , '0' , '1' ,
'13.5000' , '11.065573770492' , '22' , '10' , '29.65' )
26/11/2025 06:39:05 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99013' , '19596' , 'MEDAGLIA SAN BENEDETTO ARG. RA810' , '1' , '0' , '1' ,
'5.9000' , '4.8360655737705' , '22' , '10' , '6.48' )
26/11/2025 06:39:05 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99013' , '24094' , 'BRACCIALE SAN BENEDETTO - CC 111-SB' , '24' , '0' , '1' ,
'1.8500' , '1.516393442623' , '22' , '10' , '48.75' )
26/11/2025 06:39:05 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99013' , '23557' , 'STATUA S. MICHELE BIANCA - ST203-BSM' , '1' , '0' , '1' ,
'14.0000' , '11.475409836066' , '22' , '10' , '15.37' )
26/11/2025 06:39:05 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99013' , '23601' , 'STATUA SAN CARLO ACUTIS - ST213AC' , '1' , '0' , '1' ,
'13.1300' , '10.762295081967' , '22' , '10' , '14.42' )
26/11/2025 06:39:05 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99013' , '6332' , 'MEDAGLIA OVALE DECORATA - MISERICORDIOSO - G291-D' , '100' , '0' , '1' ,
'0.3700' , '0.30327868852459' , '22' , '10' , '40.63' )
26/11/2025 06:39:05 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99013' , '24087' , 'ICONA GRECA SERIGRAFATA 23X18 - K096.A' , '1' , '0' , '1' ,
'20.7000' , '16.967213114754' , '22' , '10' , '22.73' )
26/11/2025 06:39:05 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99013' , '24089' , 'ICONA GRECA SERIGRAFATA 14X11 - K094.A' , '1' , '0' , '1' ,
'9.9000' , '8.1147540983607' , '22' , '10' , '10.87' )
26/11/2025 06:39:05 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99013' , '24088' , 'ICONA GRECA SERIGRAFATA 18X14 - K095.A' , '1' , '0' , '1' ,
'15.3000' , '12.540983606557' , '22' , '10' , '16.80' )
26/11/2025 06:39:05 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99013' , '6337' , 'MEDAGLIA OVALE DECORATA - SACRO CUORE - G291-D' , '100' , '0' , '1' ,
'0.3700' , '0.30327868852459' , '22' , '10' , '40.63' )
26/11/2025 06:39:05 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99013' , '19716' , 'MEDAGLIA SAN BENEDETTO - Q1001-OX' , '100' , '0' , '1' ,
'0.1273' , '0.10434426229508' , '22' , '10' , '13.98' )
26/11/2025 06:39:05 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99013' , '19720' , 'CROCE LEGNO MET. - CL247' , '1' , '0' , '1' ,
'10.0100' , '8.2049180327869' , '22' , '10' , '10.99' )
26/11/2025 06:39:05 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99013' , '20965' , 'STATUA SAN MICHELE - ST332-SM' , '1' , '0' , '1' ,
'7.8800' , '6.4590163934426' , '22' , '10' , '8.65' )
26/11/2025 06:39:05 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99013' , '24110' , 'NATIVITA CM 8 - ST292-NTD' , '1' , '0' , '1' ,
'6.3600' , '5.2131147540984' , '22' , '10' , '6.98' )
26/11/2025 06:39:05 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99013' , '24111' , 'NATIVITA CM 13 - ST292-NTI' , '1' , '0' , '1' ,
'6.2000' , '5.0819672131148' , '22' , '10' , '6.81' )
26/11/2025 06:39:05 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99013' , '24112' , 'NATIVITA CM 13 - ST292-NTS' , '1' , '0' , '1' ,
'6.2000' , '5.0819672131148' , '22' , '10' , '6.81' )
26/11/2025 06:39:05 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99013' , '24113' , 'NATIVITA CM 6 - ST291-NTD' , '1' , '0' , '1' ,
'3.9600' , '3.2459016393443' , '22' , '10' , '4.35' )
26/11/2025 06:39:05 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99013' , '24114' , 'NATIVITA CM 10 - ST291-NTI' , '1' , '0' , '1' ,
'3.6000' , '2.9508196721311' , '22' , '10' , '3.95' )
26/11/2025 06:39:05 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99013' , '24115' , 'NATIVITA CM 10 - ST291-NTS' , '1' , '0' , '1' ,
'3.6000' , '2.9508196721311' , '22' , '10' , '3.95' )
26/11/2025 06:39:05 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99013' , '24116' , 'CROCE ASTILE - CL285-D-AST' , '1' , '0' , '1' ,
'360.0000' , '295.08196721311' , '22' , '10' , '395.28' )
26/11/2025 06:39:05 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '99013' , '24095' , 'MEDAGLIA ACUTIS DORATA - G474-D.254' , '100' , '0' , '1' ,
'0.4000' , '0.32786885245902' , '22' , '10' , '43.92' )
26/11/2025 06:53:42 pm >> SELECT document_num FROM ps_document
WHERE document_num = '3938' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-26')
26/11/2025 06:53:42 pm >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'3938' ,
'2025-11-26' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'2.30' ,
'1.89' ,
NOW() ,
NOW() )
26/11/2025 06:53:42 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100108'
26/11/2025 06:53:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '100108'
26/11/2025 06:53:42 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '100108' , '9132' , 'DECINA LEGNO ACERO NATURALE - RG 021-10' , '1' , '-1' , '1' ,
'0.70' , '0.57377049180328' , '22' , '0' , '0.70' )
26/11/2025 06:53:42 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '100108' , '15085' , 'BRACCIALE DECINA COLORATA - BC506' , '1' , '-1' , '1' ,
'1.60' , '1.3114754098361' , '22' , '0' , '1.60' )
26/11/2025 07:36:49 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791280736642' AND id_product != '24325' AND ean13 != ''
26/11/2025 07:36:49 pm >> UPDATE ps_product SET
id_supplier = '',
reference = '13/3',
ean13 = '9791280736642',
date_upd = NOW()
WHERE id_product = '24325'
26/11/2025 07:36:49 pm >> UPDATE ps_product_lang SET
name = 'EUCARISTIA',
description = ''
WHERE id_product = '24325'
26/11/2025 07:36:49 pm >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = 'NaN'
WHERE id_product = '24325'
26/11/2025 07:36:49 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = 'NaN',
id_tax_rules_group = '4',
id_category_default = '395',
id_argoment_default = '64',
id_internal_category = '4',
on_sale = '0',
on_showcase = '1',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '24325'
26/11/2025 07:36:49 pm >> DELETE FROM ps_specific_price WHERE id_product = '24325'
26/11/2025 07:36:49 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' , '24325' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' )
26/11/2025 07:39:17 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791280736642' AND id_product != '24325' AND ean13 != ''
26/11/2025 07:39:17 pm >> UPDATE ps_product SET
id_supplier = '',
reference = '13/3',
ean13 = '9791280736642',
date_upd = NOW()
WHERE id_product = '24325'
26/11/2025 07:39:17 pm >> UPDATE ps_product_lang SET
name = 'EUCARISTIA',
description = 'Oggi siamo alla costante ricerca del farmaco che risolva i nostri malanni. Anche la nostra società è in attesa di un farmaco che la guarisca dalla profonda crisi spirituale che sta attraversando. La medicina per guarire la nostra società c’è! È l’Eucaristia! È un farmaco particolare e unico, perché fa sempre bene a tutti e non ha effetti collaterali. Gesù Eucaristia è l’unica medicina che davvero ci salva la vita. Come ricorda sant’Ignazio d’Antiochia: «Spezzando un solo pane, che è farmaco d’immortalità, antidoto per non morire ma vivere in Gesù Cristo per sempre»
'
WHERE id_product = '24325'
26/11/2025 07:39:17 pm >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = 'NaN'
WHERE id_product = '24325'
26/11/2025 07:39:17 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = 'NaN',
id_tax_rules_group = '4',
id_category_default = '395',
id_argoment_default = '64',
id_internal_category = '4',
on_sale = '0',
on_showcase = '1',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '24325'
26/11/2025 07:39:18 pm >> DELETE FROM ps_specific_price WHERE id_product = '24325'
26/11/2025 07:39:18 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' , '24325' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' )
26/11/2025 07:39:30 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791280736642' AND id_product != '24325' AND ean13 != ''
26/11/2025 07:39:30 pm >> UPDATE ps_product SET
id_supplier = '',
reference = '13/3',
ean13 = '9791280736642',
date_upd = NOW()
WHERE id_product = '24325'
26/11/2025 07:39:30 pm >> UPDATE ps_product_lang SET
name = 'EUCARISTIA',
description = 'Oggi siamo alla costante ricerca del farmaco che risolva i nostri malanni. Anche la nostra società è in attesa di un farmaco che la guarisca dalla profonda crisi spirituale che sta attraversando. La medicina per guarire la nostra società c’è! È l’Eucaristia! È un farmaco particolare e unico, perché fa sempre bene a tutti e non ha effetti collaterali. Gesù Eucaristia è l’unica medicina che davvero ci salva la vita. Come ricorda sant’Ignazio d’Antiochia: «Spezzando un solo pane, che è farmaco d’immortalità, antidoto per non morire ma vivere in Gesù Cristo per sempre»
'
WHERE id_product = '24325'
26/11/2025 07:39:30 pm >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = 'NaN'
WHERE id_product = '24325'
26/11/2025 07:39:30 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = 'NaN',
id_tax_rules_group = '4',
id_category_default = '395',
id_argoment_default = '64',
id_internal_category = '4',
on_sale = '0',
on_showcase = '1',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '24325'
26/11/2025 07:39:30 pm >> DELETE FROM ps_specific_price WHERE id_product = '24325'
26/11/2025 07:39:30 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' , '24325' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' )
26/11/2025 07:39:49 pm >> UPDATE ps_product_shop SET active = '1' WHERE id_product = '24325'