22/01/2025 08:32:35 am >> SELECT document_num FROM ps_document
WHERE document_num = '212' AND id_document != '95371' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-21')
22/01/2025 08:32:35 am >> UPDATE ps_document SET
id_document_type = '11',
document_num = '212',
document_date = '2025-01-21',
document_letter = '',
id_customer = '0',
id_supplier = '',
id_address = '0',
address1 = '',
address2 = '',
note = '',
price_shipping = '0.00',
id_tax_shipping_rules = '4',
colli = '0',
peso = '0',
porto_e_imballo = '0',
mezzo_consegna = '',
id_payment = '0',
id_causal = '0',
price_tax_included = '8.20',
price_tax_excluded = '8.20',
date_upd = NOW()
WHERE id_document = '95371'
22/01/2025 08:32:35 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 = '95371'
22/01/2025 08:32:35 am >> DELETE FROM ps_document_detail WHERE id_document = '95371'
22/01/2025 08:32:35 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95371' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '1' , '-1' , '4' ,
'1.00' , '1' , '0' , '0' , '1.00' )
22/01/2025 08:32:35 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95371' , '14684' , 'RITI E PREGHIERE DELLA MESSA - C. MAGNOLI' , '1' , '-1' , '4' ,
'3.2000' , '3.2' , '0' , '0' , '3.20' )
22/01/2025 08:32:35 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95371' , '22698' , 'CALENDARIO LITURGICO 2025' , '5' , '-5' , '4' ,
'0.8000' , '0.8' , '0' , '0' , '4.00' )
22/01/2025 08:33:23 am >> SELECT document_num FROM ps_document
WHERE document_num = '209' AND id_document != '95368' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-21')
22/01/2025 08:33:23 am >> UPDATE ps_document SET
id_document_type = '11',
document_num = '209',
document_date = '2025-01-21',
document_letter = '',
id_customer = '0',
id_supplier = '',
id_address = '0',
address1 = '',
address2 = '',
note = '',
price_shipping = '0.00',
id_tax_shipping_rules = '4',
colli = '0',
peso = '0',
porto_e_imballo = '0',
mezzo_consegna = '',
id_payment = '0',
id_causal = '0',
price_tax_included = '16.00',
price_tax_excluded = '13.11',
date_upd = NOW()
WHERE id_document = '95368'
22/01/2025 08:33: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 = '95368'
22/01/2025 08:33:23 am >> DELETE FROM ps_document_detail WHERE id_document = '95368'
22/01/2025 08:33: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
( '95368' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' ,
'16' , '13.114754098361' , '22' , '0' , '16.00' )
22/01/2025 09:17:57 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884041197' AND id_product != '8336' AND ean13 != ''
22/01/2025 09:17:57 am >> UPDATE ps_product SET
id_supplier = '38',
reference = 'ESPOSITORE SHALOM',
ean13 = '9788884041197',
date_upd = NOW()
WHERE id_product = '8336'
22/01/2025 09:17:57 am >> UPDATE ps_product_lang SET
name = 'PREGHIERE A SANTA RITA DA CASCIA - 8352',
description = ''
WHERE id_product = '8336'
22/01/2025 09:17:57 am >> UPDATE ps_product SET
wholesale_price = '4.80',
on_sale = '0',
price = '7'
WHERE id_product = '8336'
22/01/2025 09:17:57 am >> UPDATE ps_product_shop SET
wholesale_price = '4.80',
price = '7',
id_tax_rules_group = '4',
id_category_default = '106',
id_argoment_default = '28',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '8336'
22/01/2025 09:17:57 am >> DELETE FROM ps_specific_price WHERE id_product = '8336'
22/01/2025 09:19:40 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() )
22/01/2025 09:19:40 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23354' , '1' , '' , 'nuovo-prodotto' )
22/01/2025 09:19:40 am >> INSERT INTO ps_product_shop (
id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd`
) VALUES (
'23354' , '1' , '1' , '2' , NOW() , NOW()
)
22/01/2025 09:19:40 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '23354' , '0' , '1' , '0' , '0' )
22/01/2025 09:21:43 am >> SELECT ean13 FROM ps_product WHERE ean13 = '11612' AND id_product != '23354' AND ean13 != ''
22/01/2025 09:21:43 am >> UPDATE ps_product SET
id_supplier = '',
reference = '',
ean13 = '11612',
date_upd = NOW()
WHERE id_product = '23354'
22/01/2025 09:21:43 am >> UPDATE ps_product_lang SET
name = 'medaglia loreto - 11612',
description = ''
WHERE id_product = '23354'
22/01/2025 09:21:43 am >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '0.3278688524590164'
WHERE id_product = '23354'
22/01/2025 09:21:43 am >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '0.3278688524590164',
id_tax_rules_group = '1',
id_category_default = '106',
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 = '23354'
22/01/2025 09:21:43 am >> DELETE FROM ps_specific_price WHERE id_product = '23354'
22/01/2025 09:22:02 am >> SELECT ean13 FROM ps_product WHERE ean13 = '11612' AND id_product != '23354' AND ean13 != ''
22/01/2025 09:22:02 am >> UPDATE ps_product SET
id_supplier = '',
reference = '',
ean13 = '11612',
date_upd = NOW()
WHERE id_product = '23354'
22/01/2025 09:22:02 am >> UPDATE ps_product_lang SET
name = 'MEDAGLIA LORETO - 11612',
description = ''
WHERE id_product = '23354'
22/01/2025 09:22:02 am >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '0.3279'
WHERE id_product = '23354'
22/01/2025 09:22:02 am >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '0.3279',
id_tax_rules_group = '1',
id_category_default = '106',
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 = '23354'
22/01/2025 09:22:02 am >> DELETE FROM ps_specific_price WHERE id_product = '23354'
22/01/2025 09:22: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 (
'31' ,
'1001/00/2025' ,
'2025-01-20' ,
'00' ,
'0' ,
'38' ,
'2633' ,
'VIA GALVANI, 1 60020 CAMERATA PICENA' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'6' ,
'0' ,
'130.44' ,
'129.43' ,
NOW() ,
NOW() )
22/01/2025 09:22: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 = '95378'
22/01/2025 09:22:39 am >> DELETE FROM ps_document_detail WHERE id_document = '95378'
22/01/2025 09:22: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
( '95378' , '18496' , 'MAZZO DI ROSE A SANTA RITA - 8029' , '3' , '3' , '4' ,
'3.00' , '3' , '0' , '40' , '5.4000' )
22/01/2025 09:22:39 am >> DELETE FROM ps_product_supplier WHERE id_product = '18496' AND id_supplier = '38'
22/01/2025 09:22:39 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18496' , '38' , '1' )
22/01/2025 09:22:40 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95378' , '19300' , 'DALLA QUARESIMA ALLA PASQUA - 8052' , '1' , '1' , '4' ,
'7.00' , '7' , '0' , '40' , '4.2000' )
22/01/2025 09:22:40 am >> DELETE FROM ps_product_supplier WHERE id_product = '19300' AND id_supplier = '38'
22/01/2025 09:22:40 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19300' , '38' , '1' )
22/01/2025 09:22:40 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95378' , '19924' , 'SACRA BIBBIA BIANCA - 8056' , '1' , '1' , '4' ,
'38.00' , '38' , '0' , '40' , '22.8000' )
22/01/2025 09:22:40 am >> DELETE FROM ps_product_supplier WHERE id_product = '19924' AND id_supplier = '38'
22/01/2025 09:22:40 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19924' , '38' , '1' )
22/01/2025 09:22:40 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95378' , '8383' , 'PREGHIERE PER LADORAZIONE EUCARISTICA - 8141' , '2' , '2' , '4' ,
'12.00' , '12' , '0' , '40' , '14.4000' )
22/01/2025 09:22:40 am >> DELETE FROM ps_product_supplier WHERE id_product = '8383' AND id_supplier = '38'
22/01/2025 09:22:40 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8383' , '38' , '1' )
22/01/2025 09:22:40 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95378' , '5190' , 'IN ONORE DI SAN GIUSEPPE - 8190' , '5' , '5' , '4' ,
'2.00' , '2' , '0' , '40' , '6.0000' )
22/01/2025 09:22:40 am >> DELETE FROM ps_product_supplier WHERE id_product = '5190' AND id_supplier = '38'
22/01/2025 09:22:40 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5190' , '38' , '1' )
22/01/2025 09:22:40 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95378' , '17626' , 'ADORIAMO IL SS SACRAMENTO - QUARESIMA - 8202' , '2' , '2' , '4' ,
'3.00' , '3' , '0' , '40' , '3.6000' )
22/01/2025 09:22:40 am >> DELETE FROM ps_product_supplier WHERE id_product = '17626' AND id_supplier = '38'
22/01/2025 09:22:40 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17626' , '38' , '1' )
22/01/2025 09:22:40 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95378' , '17629' , 'ADORIAMO IL SS SACRAMENTO - PASQUA - 8207' , '1' , '1' , '4' ,
'3.00' , '3' , '0' , '40' , '1.8000' )
22/01/2025 09:22:40 am >> DELETE FROM ps_product_supplier WHERE id_product = '17629' AND id_supplier = '38'
22/01/2025 09:22:40 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17629' , '38' , '1' )
22/01/2025 09:22:40 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95378' , '8245' , 'PREGATE IL SANTO ROSARIO OGNI GIORNO - 8234' , '5' , '5' , '4' ,
'2.00' , '2' , '0' , '40' , '6.0000' )
22/01/2025 09:22:40 am >> DELETE FROM ps_product_supplier WHERE id_product = '8245' AND id_supplier = '38'
22/01/2025 09:22:40 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8245' , '38' , '1' )
22/01/2025 09:22:40 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95378' , '4699' , 'GLORIE DI MARIA - 8243' , '1' , '1' , '4' ,
'12.00' , '12' , '0' , '40' , '7.2000' )
22/01/2025 09:22:40 am >> DELETE FROM ps_product_supplier WHERE id_product = '4699' AND id_supplier = '38'
22/01/2025 09:22:40 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4699' , '38' , '1' )
22/01/2025 09:22:40 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95378' , '9070' , 'ROSARIO E CORONCINA ALLO SPIRITO SANTO - 8250' , '4' , '4' , '4' ,
'2.00' , '2' , '0' , '40' , '4.8000' )
22/01/2025 09:22:40 am >> DELETE FROM ps_product_supplier WHERE id_product = '9070' AND id_supplier = '38'
22/01/2025 09:22:40 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9070' , '38' , '1' )
22/01/2025 09:22:40 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95378' , '6317' , 'MEDAGLIA MIRACOLOSA - 8332' , '2' , '2' , '4' ,
'5.00' , '5' , '0' , '40' , '6.0000' )
22/01/2025 09:22:40 am >> DELETE FROM ps_product_supplier WHERE id_product = '6317' AND id_supplier = '38'
22/01/2025 09:22:40 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6317' , '38' , '1' )
22/01/2025 09:22:40 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95378' , '8336' , 'PREGHIERE A SANTA RITA DA CASCIA - 8352' , '1' , '1' , '4' ,
'7.00' , '7' , '0' , '40' , '4.2000' )
22/01/2025 09:22:40 am >> DELETE FROM ps_product_supplier WHERE id_product = '8336' AND id_supplier = '38'
22/01/2025 09:22:40 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8336' , '38' , '1' )
22/01/2025 09:22:40 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95378' , '6283' , 'MASSIME ETERNE - 8362' , '1' , '1' , '4' ,
'7.00' , '7' , '0' , '40' , '4.2000' )
22/01/2025 09:22:40 am >> DELETE FROM ps_product_supplier WHERE id_product = '6283' AND id_supplier = '38'
22/01/2025 09:22:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6283' , '38' , '1' )
22/01/2025 09:22:41 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95378' , '22024' , 'TRATTATO DELLA VERA DEVOZIONE - MONTFORT - 8576' , '1' , '1' , '4' ,
'7.00' , '7' , '0' , '40' , '4.2000' )
22/01/2025 09:22:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '22024' AND id_supplier = '38'
22/01/2025 09:22:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22024' , '38' , '1' )
22/01/2025 09:22:41 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95378' , '22412' , 'SACRA BIBBIA - 8602' , '1' , '1' , '4' ,
'30.00' , '30' , '0' , '40' , '18.0000' )
22/01/2025 09:22:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '22412' AND id_supplier = '38'
22/01/2025 09:22:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22412' , '38' , '1' )
22/01/2025 09:22:41 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95378' , '11881' , 'IO E TE - BIBBIA DEI PICCOLI - 8828' , '1' , '1' , '4' ,
'10.00' , '10' , '0' , '40' , '6.0000' )
22/01/2025 09:22:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '11881' AND id_supplier = '38'
22/01/2025 09:22:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11881' , '38' , '1' )
22/01/2025 09:22:41 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95378' , '16024' , 'IL MESE DI FEBBRAIO CON MARIA - 8979' , '2' , '2' , '4' ,
'5.00' , '5' , '0' , '40' , '6.0000' )
22/01/2025 09:22:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '16024' AND id_supplier = '38'
22/01/2025 09:22:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16024' , '38' , '1' )
22/01/2025 09:22:41 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95378' , '16969' , 'CORONA DELLE ROSE - 10974' , '1' , '1' , '1' ,
'4.43' , '3.6311475409836' , '22' , '40' , '3.2428' )
22/01/2025 09:22:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '16969' AND id_supplier = '38'
22/01/2025 09:22:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16969' , '38' , '1' )
22/01/2025 09:22:41 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95378' , '23354' , 'MEDAGLIA LORETO - 11612' , '10' , '10' , '1' ,
'0.32787' , '0.26874590163934' , '22' , '40' , '2.4000' )
22/01/2025 09:22:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '23354' AND id_supplier = '38'
22/01/2025 09:22:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23354' , '38' , '1' )
22/01/2025 10:18:43 am >> SELECT document_num FROM ps_document
WHERE document_num = '218' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-22')
22/01/2025 10:18:43 am >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'218' ,
'2025-01-22' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'295.00' ,
'248.19' ,
NOW() ,
NOW() )
22/01/2025 10:18:43 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95379'
22/01/2025 10:18:43 am >> DELETE FROM ps_document_detail WHERE id_document = '95379'
22/01/2025 10:18:43 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95379' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '15' , '-15' , '1' ,
'1.10' , '0.9016393442623' , '22' , '0' , '16.50' )
22/01/2025 10:18:43 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95379' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '10' , '-10' , '3' ,
'3.50' , '3.3653846153846' , '4' , '0' , '35.00' )
22/01/2025 10:18:43 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95379' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' ,
'2.00' , '1.9230769230769' , '4' , '0' , '10.00' )
22/01/2025 10:18:43 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95379' , '1914' , 'CERA DELLA LITURGIA' , '24' , '-24' , '1' ,
'4.7' , '3.8524590163934' , '22' , '0' , '112.80' )
22/01/2025 10:18:43 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95379' , '19099' , 'INCENSO A' , '1' , '-1' , '1' ,
'45.7' , '37.459016393443' , '22' , '0' , '45.70' )
22/01/2025 10:18:43 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95379' , '19100' , 'INCENSO B' , '1' , '-1' , '1' ,
'35.00' , '28.688524590164' , '22' , '0' , '35.00' )
22/01/2025 10:18:43 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95379' , '17160' , 'CARBONCINI ROSSI - CARRO' , '4' , '-4' , '1' ,
'10.00' , '8.1967213114754' , '22' , '0' , '40.00' )
22/01/2025 10:22:53 am >> SELECT document_num FROM ps_document
WHERE document_num = '219' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-22')
22/01/2025 10:22: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' ,
'219' ,
'2025-01-22' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'45.00' ,
'36.89' ,
NOW() ,
NOW() )
22/01/2025 10:22: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 = '95380'
22/01/2025 10:22:53 am >> DELETE FROM ps_document_detail WHERE id_document = '95380'
22/01/2025 10:22: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
( '95380' , '22199' , 'VINO LIQUOROSO ROSSO ' , '6' , '-6' , '1' ,
'7.5' , '6.1475409836066' , '22' , '0' , '45.00' )
22/01/2025 10:32:43 am >> SELECT document_num FROM ps_document
WHERE document_num = '13/A' AND id_document != '94912' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-01-02')
22/01/2025 10:32:43 am >> UPDATE ps_document SET
id_document_type = '24',
document_num = '13/A',
document_date = '2025-01-02',
document_letter = 'A',
id_customer = '2739',
id_supplier = '',
id_address = '4671014',
address1 = 'VIA F. WENNER, 37 84080 PELLEZZANO',
address2 = '',
note = '**** già scaricati',
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 = '190.10',
price_tax_excluded = '164.36',
date_upd = NOW()
WHERE id_document = '94912'
22/01/2025 10:32:43 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94912'
22/01/2025 10:32:43 am >> DELETE FROM ps_document_detail WHERE id_document = '94912'
22/01/2025 10:32:43 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94912' , '22907' , 'AGENDINA 2025 - 40827' , '2' , '-2' , '1' ,
'7.0000' , '5.7377049180328' , '22' , '0' , '14.00' )
22/01/2025 10:32:43 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94912' , '20156' , 'PALLA E STELLE CON CARTONCINO - 23' , '60' , '-60' , '1' ,
'2.0000' , '1.6393442622951' , '22' , '0' , '120.00' )
22/01/2025 10:32:43 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94912' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' ,
'2.0000' , '1.9230769230769' , '4' , '0' , '2.00' )
22/01/2025 10:32:43 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94912' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '1' , '-1' , '1' ,
'7.9000' , '6.4754098360656' , '22' , '0' , '7.90' )
22/01/2025 10:32:43 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94912' , '23104' , 'SULLA TUA PAROLA - GEN/FEB 25' , '4' , '-4' , '4' ,
'5.0000' , '5' , '0' , '0' , '20.00' )
22/01/2025 10:32:43 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94912' , '23169' , 'DILEXIT NOS ****' , '1' , '-1' , '4' ,
'2.2000' , '2.2' , '0' , '0' , '2.20' )
22/01/2025 10:32:43 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94912' , '23341' , 'SPERA - PAPA FRANCESCO' , '1' , '-1' , '4' ,
'22.0000' , '22' , '0' , '0' , '22.00' )
22/01/2025 10:32:43 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94912' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' ,
'2.00' , '1.9230769230769' , '4' , '0' , '2.00' )
22/01/2025 10:34:19 am >> SELECT document_num FROM ps_document
WHERE document_num = '24/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-01-22')
22/01/2025 10:34:19 am >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'24' ,
'24/A' ,
'2025-01-22' ,
'A' ,
'1148' ,
'0' ,
'1148' ,
'P.ZZA GIOVANNI PAOLO II, 4 84080 COPERCHIA' ,
'' ,
'SANTUARIO CARMINE' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'7.00' ,
'6.73' ,
NOW() ,
NOW() )
22/01/2025 10:34:19 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95381'
22/01/2025 10:34:19 am >> DELETE FROM ps_document_detail WHERE id_document = '95381'
22/01/2025 10:34:20 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95381' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' , '-2' , '3' ,
'3.50' , '3.3653846153846' , '4' , '0' , '7.00' )
22/01/2025 10:45:30 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() )
22/01/2025 10:45:30 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23355' , '1' , '' , 'nuovo-prodotto' )
22/01/2025 10:45:30 am >> INSERT INTO ps_product_shop (
id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd`
) VALUES (
'23355' , '1' , '1' , '2' , NOW() , NOW()
)
22/01/2025 10:45:30 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '23355' , '0' , '1' , '0' , '0' )
22/01/2025 10:46:09 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8051739458022' AND id_product != '23355' AND ean13 != ''
22/01/2025 10:46:09 am >> UPDATE ps_product SET
id_supplier = '',
reference = '',
ean13 = '8051739458022',
date_upd = NOW()
WHERE id_product = '23355'
22/01/2025 10:46:09 am >> UPDATE ps_product_lang SET
name = 'INSIEME NELLA MESSA - MAR 25',
description = ''
WHERE id_product = '23355'
22/01/2025 10:46:09 am >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '1.8'
WHERE id_product = '23355'
22/01/2025 10:46:09 am >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '1.8',
id_tax_rules_group = '4',
id_category_default = '30',
id_argoment_default = '64',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '23355'
22/01/2025 10:46:09 am >> DELETE FROM ps_specific_price WHERE id_product = '23355'
22/01/2025 10:46:10 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 = '23355'
22/01/2025 10:46:10 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23356' , '1' , '' , 'nuovo-prodotto' )
22/01/2025 10:46:10 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 '23356' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23355'
22/01/2025 10:46:10 am >> INSERT INTO `ps_stock_available` (
id_product , id_product_attribute , id_shop , id_shop_group , quantity
) SELECT '23356' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23355'
22/01/2025 10:46:46 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8051739457902' AND id_product != '23356' AND ean13 != ''
22/01/2025 10:46:47 am >> UPDATE ps_product SET
id_supplier = '',
reference = '7/4',
ean13 = '8051739457902',
date_upd = NOW()
WHERE id_product = '23356'
22/01/2025 10:46:47 am >> UPDATE ps_product_lang SET
name = 'PAROLA E PREGHIERA - MAR 25',
description = ''
WHERE id_product = '23356'
22/01/2025 10:46:47 am >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '2.9'
WHERE id_product = '23356'
22/01/2025 10:46:47 am >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '2.9',
id_tax_rules_group = '4',
id_category_default = '30',
id_argoment_default = '64',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '23356'
22/01/2025 10:46:47 am >> DELETE FROM ps_specific_price WHERE id_product = '23356'
22/01/2025 10:46: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 = '23356'
22/01/2025 10:46:48 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23357' , '1' , '' , 'nuovo-prodotto' )
22/01/2025 10:46: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 '23357' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23356'
22/01/2025 10:46:48 am >> INSERT INTO `ps_stock_available` (
id_product , id_product_attribute , id_shop , id_shop_group , quantity
) SELECT '23357' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23356'
22/01/2025 10:50:24 am >> SELECT document_num FROM ps_document
WHERE document_num = '220' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-22')
22/01/2025 10:50: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 (
'11' ,
'220' ,
'2025-01-22' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'90.00' ,
'73.77' ,
NOW() ,
NOW() )
22/01/2025 10:50: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 = '95382'
22/01/2025 10:50:24 am >> DELETE FROM ps_document_detail WHERE id_document = '95382'
22/01/2025 10:50: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
( '95382' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '1' , '-1' , '1' ,
'70.00' , '57.377049180328' , '22' , '0' , '70.00' )
22/01/2025 10:50: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
( '95382' , '1425' , 'BUSTA 100 FLAMBEAUX IN CARTA - FLAM' , '2' , '-2' , '1' ,
'10.00' , '8.1967213114754' , '22' , '0' , '20.00' )
22/01/2025 10:56:40 am >> SELECT document_num FROM ps_document
WHERE document_num = '221' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-22')
22/01/2025 10:56:40 am >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'221' ,
'2025-01-22' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'50.00' ,
'40.98' ,
NOW() ,
NOW() )
22/01/2025 10:56:40 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95383'
22/01/2025 10:56:40 am >> DELETE FROM ps_document_detail WHERE id_document = '95383'
22/01/2025 10:56:40 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95383' , '20074' , 'ROSARIO ARG/PERLA/EMATITE - 1965/cav' , '1' , '-1' , '1' ,
'50.00' , '40.983606557377' , '22' , '0' , '50.00' )
22/01/2025 11:06:54 am >> SELECT document_num FROM ps_document
WHERE document_num = '222' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-22')
22/01/2025 11:06:54 am >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'222' ,
'2025-01-22' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'27.46' ,
'25.76' ,
NOW() ,
NOW() )
22/01/2025 11:06:54 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95384'
22/01/2025 11:06:54 am >> DELETE FROM ps_document_detail WHERE id_document = '95384'
22/01/2025 11:06:54 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95384' , '12904' , 'NOVENA DELLE ROSE A S. TERESA LISIEUX' , '1' , '-1' , '4' ,
'1.50' , '1.5' , '0' , '5' , '1.43' )
22/01/2025 11:06:54 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95384' , '9070' , 'ROSARIO E CORONCINA ALLO SPIRITO SANTO - 8250' , '1' , '-1' , '4' ,
'2.00' , '2' , '0' , '5' , '1.90' )
22/01/2025 11:06:54 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95384' , '8245' , 'PREGATE IL SANTO ROSARIO OGNI GIORNO - 8234' , '2' , '-2' , '4' ,
'2.00' , '2' , '0' , '5' , '3.80' )
22/01/2025 11:06:54 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95384' , '18496' , 'MAZZO DI ROSE A SANTA RITA - 8029' , '1' , '-1' , '4' ,
'3.00' , '3' , '0' , '5' , '2.85' )
22/01/2025 11:06:54 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95384' , '19300' , 'DALLA QUARESIMA ALLA PASQUA - 8052' , '1' , '-1' , '4' ,
'7.00' , '7' , '0' , '5' , '6.65' )
22/01/2025 11:06:54 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95384' , '8368' , 'PREGHIERE DI LIBERAZIONE - DIVINA MISERICORDIA' , '1' , '-1' , '4' ,
'1.50' , '1.5' , '0' , '5' , '1.43' )
22/01/2025 11:06:54 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95384' , '16969' , 'CORONA DELLE ROSE - 10974' , '1' , '-1' , '1' ,
'5.40' , '4.4262295081967' , '22' , '0' , '5.40' )
22/01/2025 11:06:54 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95384' , '23354' , 'MEDAGLIA LORETO - 11612' , '10' , '-10' , '1' ,
'0.40' , '0.32786885245902' , '22' , '0' , '4.00' )
22/01/2025 11:28:43 am >> SELECT document_num FROM ps_document
WHERE document_num = '223' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-22')
22/01/2025 11:28:43 am >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'223' ,
'2025-01-22' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'264.60' ,
'228.53' ,
NOW() ,
NOW() )
22/01/2025 11:28:43 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95385'
22/01/2025 11:28:43 am >> DELETE FROM ps_document_detail WHERE id_document = '95385'
22/01/2025 11:28:43 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95385' , '23052' , 'DALMATICA MORELLO - PDA004' , '2' , '-2' , '1' ,
'100.00' , '81.967213114754' , '22' , '0' , '200.00' )
22/01/2025 11:28:43 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95385' , '21615' , 'RITO DELLA COMUNIONE FUORI DELLA MESSA N.E.' , '1' , '-1' , '4' ,
'20.00' , '20' , '0' , '5' , '19.00' )
22/01/2025 11:28:43 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95385' , '21748' , 'DI PASQUA IN PASQUA - ANNO B - F. ROSINI' , '1' , '-1' , '4' ,
'16.00' , '16' , '0' , '5' , '15.20' )
22/01/2025 11:28:43 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95385' , '20247' , 'DI PASQUA IN PASQUA - ANNO A - F. ROSINI' , '1' , '-1' , '4' ,
'16.00' , '16' , '0' , '5' , '15.20' )
22/01/2025 11:28:44 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95385' , '23126' , 'DI PASQUA IN PASQUA ANNO C - F. ROSINI' , '1' , '-1' , '4' ,
'16.00' , '16' , '0' , '5' , '15.20' )
22/01/2025 11:49:51 am >> SELECT document_num FROM ps_document
WHERE document_num = '224' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-22')
22/01/2025 11:49:51 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' ,
'224' ,
'2025-01-22' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'200.00' ,
'187.71' ,
NOW() ,
NOW() )
22/01/2025 11:49:51 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 = '95386'
22/01/2025 11:49:51 am >> DELETE FROM ps_document_detail WHERE id_document = '95386'
22/01/2025 11:49:51 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95386' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '6' , '-6' , '1' ,
'7.5' , '6.1475409836066' , '22' , '0' , '45.00' )
22/01/2025 11:49:51 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95386' , '23126' , 'DI PASQUA IN PASQUA ANNO C - F. ROSINI' , '1' , '-1' , '4' ,
'16.00' , '16' , '0' , '5' , '15.20' )
22/01/2025 11:49:51 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95386' , '11151' , 'LIBRI' , '1' , '-1' , '4' ,
'32.9' , '32.9' , '0' , '5' , '31.26' )
22/01/2025 11:49:51 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95386' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '20' , '-20' , '3' ,
'3.50' , '3.3653846153846' , '4' , '0' , '70.00' )
22/01/2025 11:49:51 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95386' , '16689' , 'OSTIA PAN DI CENA mm80' , '19' , '-19' , '3' ,
'2.00' , '1.9230769230769' , '4' , '0' , '38.00' )
22/01/2025 11:49:51 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95386' , '16689' , 'OSTIA PAN DI CENA mm80' , '1' , '-1' , '3' ,
'0.54' , '0.51923076923077' , '4' , '0' , '0.54' )
22/01/2025 11:53:25 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791281465183' AND id_product != '23357' AND ean13 != ''
22/01/2025 11:53:25 am >> UPDATE ps_product SET
id_supplier = '',
reference = 'GONDOLA 2',
ean13 = '9791281465183',
date_upd = NOW()
WHERE id_product = '23357'
22/01/2025 11:53:25 am >> UPDATE ps_product_lang SET
name = 'QUARESIMA 2025 - ALLE SORGENTI DELLA SPERANZA',
description = ''
WHERE id_product = '23357'
22/01/2025 11:53:25 am >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '3.6'
WHERE id_product = '23357'
22/01/2025 11:53:25 am >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '3.6',
id_tax_rules_group = '4',
id_category_default = '97',
id_argoment_default = '50',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '23357'
22/01/2025 11:53:25 am >> DELETE FROM ps_specific_price WHERE id_product = '23357'
22/01/2025 11:53:26 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 = '23357'
22/01/2025 11:53:26 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23358' , '1' , '' , 'nuovo-prodotto' )
22/01/2025 11:53:26 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 '23358' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23357'
22/01/2025 11:53:26 am >> INSERT INTO `ps_stock_available` (
id_product , id_product_attribute , id_shop , id_shop_group , quantity
) SELECT '23358' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23357'
22/01/2025 11:53:59 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791281465190' AND id_product != '23358' AND ean13 != ''
22/01/2025 11:53:59 am >> UPDATE ps_product SET
id_supplier = '',
reference = 'GONDOLA 1',
ean13 = '9791281465190',
date_upd = NOW()
WHERE id_product = '23358'
22/01/2025 11:53:59 am >> UPDATE ps_product_lang SET
name = 'MIO FIGLIO E\' TORNATO',
description = ''
WHERE id_product = '23358'
22/01/2025 11:53:59 am >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '3.8'
WHERE id_product = '23358'
22/01/2025 11:53:59 am >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '3.8',
id_tax_rules_group = '4',
id_category_default = '97',
id_argoment_default = '50',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '23358'
22/01/2025 11:53:59 am >> DELETE FROM ps_specific_price WHERE id_product = '23358'
22/01/2025 11:54:36 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 = '23358'
22/01/2025 11:54:36 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23359' , '1' , '' , 'nuovo-prodotto' )
22/01/2025 11:54:36 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 '23359' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23358'
22/01/2025 11:54:36 am >> INSERT INTO `ps_stock_available` (
id_product , id_product_attribute , id_shop , id_shop_group , quantity
) SELECT '23359' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23358'
22/01/2025 11:55:52 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892246393' AND id_product != '23359' AND ean13 != ''
22/01/2025 11:55:52 am >> UPDATE ps_product SET
id_supplier = '',
reference = 'GONDOLA 1',
ean13 = '9788892246393',
date_upd = NOW()
WHERE id_product = '23359'
22/01/2025 11:55:52 am >> UPDATE ps_product_lang SET
name = 'SUSSIDIO DI QUARESIMA E PASQUA 2025',
description = ''
WHERE id_product = '23359'
22/01/2025 11:55:52 am >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '2.5'
WHERE id_product = '23359'
22/01/2025 11:55:52 am >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '2.5',
id_tax_rules_group = '4',
id_category_default = '30',
id_argoment_default = '50',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '23359'
22/01/2025 11:55:52 am >> DELETE FROM ps_specific_price WHERE id_product = '23359'
22/01/2025 11:55:53 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 = '23359'
22/01/2025 11:55:53 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23360' , '1' , '' , 'nuovo-prodotto' )
22/01/2025 11:55:53 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 '23360' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23359'
22/01/2025 11:55:53 am >> INSERT INTO `ps_stock_available` (
id_product , id_product_attribute , id_shop , id_shop_group , quantity
) SELECT '23360' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23359'
22/01/2025 11:56:12 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892246423' AND id_product != '23360' AND ean13 != ''
22/01/2025 11:56:12 am >> UPDATE ps_product SET
id_supplier = '',
reference = 'GONDOLA 1',
ean13 = '9788892246423',
date_upd = NOW()
WHERE id_product = '23360'
22/01/2025 11:56:12 am >> UPDATE ps_product_lang SET
name = 'QUARESIMA E PASQUA 2025',
description = ''
WHERE id_product = '23360'
22/01/2025 11:56:12 am >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '2.9'
WHERE id_product = '23360'
22/01/2025 11:56:12 am >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '2.9',
id_tax_rules_group = '4',
id_category_default = '30',
id_argoment_default = '50',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '23360'
22/01/2025 11:56:12 am >> DELETE FROM ps_specific_price WHERE id_product = '23360'
22/01/2025 11:56:13 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 = '23360'
22/01/2025 11:56:13 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23361' , '1' , '' , 'nuovo-prodotto' )
22/01/2025 11:56:13 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 '23361' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23360'
22/01/2025 11:56:13 am >> INSERT INTO `ps_stock_available` (
id_product , id_product_attribute , id_shop , id_shop_group , quantity
) SELECT '23361' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23360'
22/01/2025 12:00:23 pm >> INSERT INTO ps_category ( id_parent , `date_add` , `date_upd` , level_depth ) VALUES ( '3' , NOW() , NOW() , '3' )
22/01/2025 12:00:24 pm >> INSERT INTO ps_category_group ( id_category , id_group ) VALUES ( '549' , '1' )
22/01/2025 12:00:24 pm >> INSERT INTO ps_category_group ( id_category , id_group ) VALUES ( '549' , '2' )
22/01/2025 12:00:24 pm >> INSERT INTO ps_category_group ( id_category , id_group ) VALUES ( '549' , '3' )
22/01/2025 12:00:24 pm >> INSERT INTO ps_category_lang ( id_category , id_lang , name , link_rewrite ) VALUES ( '549' , '1' , 'GIUBILEO' , LOWER('GIUBILEO') )
22/01/2025 12:00:24 pm >> INSERT INTO ps_category_shop ( id_category , id_shop , position ) VALUES ( '549' , '1' , '0' )
22/01/2025 12:01:14 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892245730' AND id_product != '23361' AND ean13 != ''
22/01/2025 12:01:14 pm >> UPDATE ps_product SET
id_supplier = '',
reference = 'GONDOLA 1',
ean13 = '9788892245730',
date_upd = NOW()
WHERE id_product = '23361'
22/01/2025 12:01:14 pm >> UPDATE ps_product_lang SET
name = 'PERCORSI DEL GIUBILEO - L. FERRAIUOLO',
description = ''
WHERE id_product = '23361'
22/01/2025 12:01:14 pm >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '20'
WHERE id_product = '23361'
22/01/2025 12:01:14 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '20',
id_tax_rules_group = '4',
id_category_default = '30',
id_argoment_default = '549',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '23361'
22/01/2025 12:01:14 pm >> DELETE FROM ps_specific_price WHERE id_product = '23361'
22/01/2025 12:01:15 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 = '23361'
22/01/2025 12:01:15 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23362' , '1' , '' , 'nuovo-prodotto' )
22/01/2025 12:01:15 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 '23362' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23361'
22/01/2025 12:01:15 pm >> INSERT INTO `ps_stock_available` (
id_product , id_product_attribute , id_shop , id_shop_group , quantity
) SELECT '23362' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23361'
22/01/2025 12:02:50 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892246348' AND id_product != '23362' AND ean13 != ''
22/01/2025 12:02:50 pm >> UPDATE ps_product SET
id_supplier = '',
reference = '7/5',
ean13 = '9788892246348',
date_upd = NOW()
WHERE id_product = '23362'
22/01/2025 12:02:50 pm >> UPDATE ps_product_lang SET
name = 'ALFABETO DELL\'UOMO - G. RAVASI',
description = ''
WHERE id_product = '23362'
22/01/2025 12:02:50 pm >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '18'
WHERE id_product = '23362'
22/01/2025 12:02:50 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '18',
id_tax_rules_group = '4',
id_category_default = '30',
id_argoment_default = '41',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '23362'
22/01/2025 12:02:50 pm >> DELETE FROM ps_specific_price WHERE id_product = '23362'
22/01/2025 12:02:51 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 = '23362'
22/01/2025 12:02:51 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23363' , '1' , '' , 'nuovo-prodotto' )
22/01/2025 12:02:51 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 '23363' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23362'
22/01/2025 12:02:51 pm >> INSERT INTO `ps_stock_available` (
id_product , id_product_attribute , id_shop , id_shop_group , quantity
) SELECT '23363' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23362'
22/01/2025 12:03:43 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892246386' AND id_product != '23363' AND ean13 != ''
22/01/2025 12:03:43 pm >> UPDATE ps_product SET
id_supplier = '',
reference = '7/5',
ean13 = '9788892246386',
date_upd = NOW()
WHERE id_product = '23363'
22/01/2025 12:03:43 pm >> UPDATE ps_product_lang SET
name = 'SPERANZA TRASFORMA LA VITA - R. FISICHELLA',
description = ''
WHERE id_product = '23363'
22/01/2025 12:03:43 pm >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '12'
WHERE id_product = '23363'
22/01/2025 12:03:43 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '12',
id_tax_rules_group = '4',
id_category_default = '30',
id_argoment_default = '41',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '23363'
22/01/2025 12:03:43 pm >> DELETE FROM ps_specific_price WHERE id_product = '23363'
22/01/2025 12:03:44 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 = '23363'
22/01/2025 12:03:44 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23364' , '1' , '' , 'nuovo-prodotto' )
22/01/2025 12:03:44 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 '23364' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23363'
22/01/2025 12:03:44 pm >> INSERT INTO `ps_stock_available` (
id_product , id_product_attribute , id_shop , id_shop_group , quantity
) SELECT '23364' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23363'
22/01/2025 12:04:18 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892246454' AND id_product != '23364' AND ean13 != ''
22/01/2025 12:04:18 pm >> UPDATE ps_product SET
id_supplier = '',
reference = '7/2',
ean13 = '9788892246454',
date_upd = NOW()
WHERE id_product = '23364'
22/01/2025 12:04:18 pm >> UPDATE ps_product_lang SET
name = 'PADRE PIO - S. GAETA',
description = ''
WHERE id_product = '23364'
22/01/2025 12:04:18 pm >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '14'
WHERE id_product = '23364'
22/01/2025 12:04:18 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '14',
id_tax_rules_group = '4',
id_category_default = '30',
id_argoment_default = '71',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '23364'
22/01/2025 12:04:18 pm >> DELETE FROM ps_specific_price WHERE id_product = '23364'
22/01/2025 12:04:19 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 = '23364'
22/01/2025 12:04:19 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23365' , '1' , '' , 'nuovo-prodotto' )
22/01/2025 12:04:19 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 '23365' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23364'
22/01/2025 12:04:19 pm >> INSERT INTO `ps_stock_available` (
id_product , id_product_attribute , id_shop , id_shop_group , quantity
) SELECT '23365' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23364'
22/01/2025 12:05:19 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788851429461' AND id_product != '23365' AND ean13 != ''
22/01/2025 12:05:19 pm >> UPDATE ps_product SET
id_supplier = '',
reference = '13/3',
ean13 = '9788851429461',
date_upd = NOW()
WHERE id_product = '23365'
22/01/2025 12:05:19 pm >> UPDATE ps_product_lang SET
name = 'VIA CRUCIS DEL PELLEGRINO ',
description = ''
WHERE id_product = '23365'
22/01/2025 12:05:19 pm >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '2'
WHERE id_product = '23365'
22/01/2025 12:05:19 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '2',
id_tax_rules_group = '4',
id_category_default = '98',
id_argoment_default = '50',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '23365'
22/01/2025 12:05:20 pm >> DELETE FROM ps_specific_price WHERE id_product = '23365'
22/01/2025 12:05:21 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 = '23365'
22/01/2025 12:05:21 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23366' , '1' , '' , 'nuovo-prodotto' )
22/01/2025 12:05:21 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 '23366' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23365'
22/01/2025 12:05:21 pm >> INSERT INTO `ps_stock_available` (
id_product , id_product_attribute , id_shop , id_shop_group , quantity
) SELECT '23366' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23365'
22/01/2025 12:05:54 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791281253995' AND id_product != '23366' AND ean13 != ''
22/01/2025 12:05:54 pm >> UPDATE ps_product SET
id_supplier = '',
reference = '13/3',
ean13 = '9791281253995',
date_upd = NOW()
WHERE id_product = '23366'
22/01/2025 12:05:54 pm >> UPDATE ps_product_lang SET
name = 'VIA CRUCIS CON MARIA - A. COMASTRI',
description = ''
WHERE id_product = '23366'
22/01/2025 12:05:54 pm >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '2'
WHERE id_product = '23366'
22/01/2025 12:05:54 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '2',
id_tax_rules_group = '4',
id_category_default = '518',
id_argoment_default = '50',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '23366'
22/01/2025 12:05:54 pm >> DELETE FROM ps_specific_price WHERE id_product = '23366'
22/01/2025 12:07:37 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 = '23366'
22/01/2025 12:07:37 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23367' , '1' , '' , 'nuovo-prodotto' )
22/01/2025 12:07:37 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 '23367' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23366'
22/01/2025 12:07:37 pm >> INSERT INTO `ps_stock_available` (
id_product , id_product_attribute , id_shop , id_shop_group , quantity
) SELECT '23367' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23366'
22/01/2025 12:08:49 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791259754431' AND id_product != '23367' AND ean13 != ''
22/01/2025 12:08:49 pm >> UPDATE ps_product SET
id_supplier = '',
reference = '6/5',
ean13 = '9791259754431',
date_upd = NOW()
WHERE id_product = '23367'
22/01/2025 12:08:49 pm >> UPDATE ps_product_lang SET
name = 'COMPASSIONE E RIPARAZIONE - O. DE BERTOLIS',
description = ''
WHERE id_product = '23367'
22/01/2025 12:08:49 pm >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '12'
WHERE id_product = '23367'
22/01/2025 12:08:49 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '12',
id_tax_rules_group = '4',
id_category_default = '267',
id_argoment_default = '41',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '23367'
22/01/2025 12:08:49 pm >> DELETE FROM ps_specific_price WHERE id_product = '23367'
22/01/2025 12:08:50 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 = '23367'
22/01/2025 12:08:50 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23368' , '1' , '' , 'nuovo-prodotto' )
22/01/2025 12:08:50 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 '23368' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23367'
22/01/2025 12:08:50 pm >> INSERT INTO `ps_stock_available` (
id_product , id_product_attribute , id_shop , id_shop_group , quantity
) SELECT '23368' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23367'
22/01/2025 12:10:10 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892871854' AND id_product != '23368' AND ean13 != ''
22/01/2025 12:10:10 pm >> UPDATE ps_product SET
id_supplier = '',
reference = '7/2',
ean13 = '9788892871854',
date_upd = NOW()
WHERE id_product = '23368'
22/01/2025 12:10:10 pm >> UPDATE ps_product_lang SET
name = 'VANGELO SPIEGATO A MIO FIGLIO - V. LOMBARDO',
description = ''
WHERE id_product = '23368'
22/01/2025 12:10:10 pm >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '15'
WHERE id_product = '23368'
22/01/2025 12:10:10 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '15',
id_tax_rules_group = '4',
id_category_default = '26',
id_argoment_default = '64',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '23368'
22/01/2025 12:10:10 pm >> DELETE FROM ps_specific_price WHERE id_product = '23368'
22/01/2025 12:10:12 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 = '23368'
22/01/2025 12:10:12 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23369' , '1' , '' , 'nuovo-prodotto' )
22/01/2025 12:10:12 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 '23369' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23368'
22/01/2025 12:10:12 pm >> INSERT INTO `ps_stock_available` (
id_product , id_product_attribute , id_shop , id_shop_group , quantity
) SELECT '23369' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23368'
22/01/2025 12:11:00 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791281618190' AND id_product != '23369' AND ean13 != ''
22/01/2025 12:11:00 pm >> UPDATE ps_product SET
id_supplier = '',
reference = '6/5',
ean13 = '9791281618190',
date_upd = NOW()
WHERE id_product = '23369'
22/01/2025 12:11:00 pm >> UPDATE ps_product_lang SET
name = 'PREGHIERA DI INTERCESSIONE - G. SACINO',
description = ''
WHERE id_product = '23369'
22/01/2025 12:11:00 pm >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '15'
WHERE id_product = '23369'
22/01/2025 12:11:00 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '15',
id_tax_rules_group = '4',
id_category_default = '76',
id_argoment_default = '41',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '23369'
22/01/2025 12:11:00 pm >> DELETE FROM ps_specific_price WHERE id_product = '23369'
22/01/2025 12:11:01 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 = '23369'
22/01/2025 12:11:01 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23370' , '1' , '' , 'nuovo-prodotto' )
22/01/2025 12:11:01 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 '23370' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23369'
22/01/2025 12:11:01 pm >> INSERT INTO `ps_stock_available` (
id_product , id_product_attribute , id_shop , id_shop_group , quantity
) SELECT '23370' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23369'
22/01/2025 12:12:01 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884248589' AND id_product != '23370' AND ean13 != ''
22/01/2025 12:12:01 pm >> UPDATE ps_product SET
id_supplier = '',
reference = '7/7',
ean13 = '9788884248589',
date_upd = NOW()
WHERE id_product = '23370'
22/01/2025 12:12:01 pm >> UPDATE ps_product_lang SET
name = 'CODICE CUORE - C. GALATOLO',
description = ''
WHERE id_product = '23370'
22/01/2025 12:12:01 pm >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '12'
WHERE id_product = '23370'
22/01/2025 12:12:01 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '12',
id_tax_rules_group = '4',
id_category_default = '83',
id_argoment_default = '8',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '23370'
22/01/2025 12:12:01 pm >> DELETE FROM ps_specific_price WHERE id_product = '23370'
22/01/2025 12:12:02 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 = '23370'
22/01/2025 12:12:02 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23371' , '1' , '' , 'nuovo-prodotto' )
22/01/2025 12:12:02 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 '23371' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23370'
22/01/2025 12:12:02 pm >> INSERT INTO `ps_stock_available` (
id_product , id_product_attribute , id_shop , id_shop_group , quantity
) SELECT '23371' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23370'
22/01/2025 12:13:38 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831557863' AND id_product != '23371' AND ean13 != ''
22/01/2025 12:13:38 pm >> UPDATE ps_product SET
id_supplier = '',
reference = 'ESPOSITORE S. PAOLO',
ean13 = '9788831557863',
date_upd = NOW()
WHERE id_product = '23371'
22/01/2025 12:13:38 pm >> UPDATE ps_product_lang SET
name = 'ULTIMA CENA - J. RODRIGUEZ',
description = ''
WHERE id_product = '23371'
22/01/2025 12:13:38 pm >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '2.5'
WHERE id_product = '23371'
22/01/2025 12:13:38 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '2.5',
id_tax_rules_group = '4',
id_category_default = '27',
id_argoment_default = '41',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '23371'
22/01/2025 12:13:38 pm >> DELETE FROM ps_specific_price WHERE id_product = '23371'
22/01/2025 12:13:39 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 = '23371'
22/01/2025 12:13:39 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23372' , '1' , '' , 'nuovo-prodotto' )
22/01/2025 12:13:39 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 '23372' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23371'
22/01/2025 12:13:39 pm >> INSERT INTO `ps_stock_available` (
id_product , id_product_attribute , id_shop , id_shop_group , quantity
) SELECT '23372' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23371'
22/01/2025 12:13:57 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831557900' AND id_product != '23372' AND ean13 != ''
22/01/2025 12:13:57 pm >> UPDATE ps_product SET
id_supplier = '',
reference = 'ESPOSITORE S. PAOLO',
ean13 = '9788831557900',
date_upd = NOW()
WHERE id_product = '23372'
22/01/2025 12:13:57 pm >> UPDATE ps_product_lang SET
name = 'LAVANDA DEI PIEDI',
description = ''
WHERE id_product = '23372'
22/01/2025 12:13:57 pm >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '2.5'
WHERE id_product = '23372'
22/01/2025 12:13:57 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '2.5',
id_tax_rules_group = '4',
id_category_default = '27',
id_argoment_default = '41',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '23372'
22/01/2025 12:13:57 pm >> DELETE FROM ps_specific_price WHERE id_product = '23372'
22/01/2025 12:14:00 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 = '23372'
22/01/2025 12:14:00 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23373' , '1' , '' , 'nuovo-prodotto' )
22/01/2025 12:14:00 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 '23373' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23372'
22/01/2025 12:14:00 pm >> INSERT INTO `ps_stock_available` (
id_product , id_product_attribute , id_shop , id_shop_group , quantity
) SELECT '23373' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23372'
22/01/2025 12:14:28 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831557856' AND id_product != '23373' AND ean13 != ''
22/01/2025 12:14:28 pm >> UPDATE ps_product SET
id_supplier = '',
reference = 'ESPOSITORE S. PAOLO',
ean13 = '9788831557856',
date_upd = NOW()
WHERE id_product = '23373'
22/01/2025 12:14:28 pm >> UPDATE ps_product_lang SET
name = 'SPERANZA NEI PADRI',
description = ''
WHERE id_product = '23373'
22/01/2025 12:14:28 pm >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '2.5'
WHERE id_product = '23373'
22/01/2025 12:14:28 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '2.5',
id_tax_rules_group = '4',
id_category_default = '27',
id_argoment_default = '41',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '23373'
22/01/2025 12:14:28 pm >> DELETE FROM ps_specific_price WHERE id_product = '23373'
22/01/2025 12:14:34 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 = '23373'
22/01/2025 12:14:34 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23374' , '1' , '' , 'nuovo-prodotto' )
22/01/2025 12:14:34 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 '23374' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23373'
22/01/2025 12:14:34 pm >> INSERT INTO `ps_stock_available` (
id_product , id_product_attribute , id_shop , id_shop_group , quantity
) SELECT '23374' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23373'
22/01/2025 12:15:13 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831557856' AND id_product != '23373' AND ean13 != ''
22/01/2025 12:15:13 pm >> UPDATE ps_product SET
id_supplier = '',
reference = 'ESPOSITORE S. PAOLO',
ean13 = '9788831557856',
date_upd = NOW()
WHERE id_product = '23373'
22/01/2025 12:15:13 pm >> UPDATE ps_product_lang SET
name = 'SPERANZA NEI PADRI',
description = ''
WHERE id_product = '23373'
22/01/2025 12:15:13 pm >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '2.9'
WHERE id_product = '23373'
22/01/2025 12:15:13 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '2.9',
id_tax_rules_group = '4',
id_category_default = '27',
id_argoment_default = '41',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '23373'
22/01/2025 12:15:13 pm >> DELETE FROM ps_specific_price WHERE id_product = '23373'
22/01/2025 12:15:58 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831557849' AND id_product != '23374' AND ean13 != ''
22/01/2025 12:15:59 pm >> UPDATE ps_product SET
id_supplier = '',
reference = 'ESPOSITORE S. PAOLO',
ean13 = '9788831557849',
date_upd = NOW()
WHERE id_product = '23374'
22/01/2025 12:15:59 pm >> UPDATE ps_product_lang SET
name = 'VEDERE LA BELLA NOTIZIA - J. HERNANDEZ',
description = ''
WHERE id_product = '23374'
22/01/2025 12:15:59 pm >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '2.9'
WHERE id_product = '23374'
22/01/2025 12:15:59 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '2.9',
id_tax_rules_group = '4',
id_category_default = '27',
id_argoment_default = '41',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '23374'
22/01/2025 12:15:59 pm >> DELETE FROM ps_specific_price WHERE id_product = '23374'
22/01/2025 12:15:59 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 = '23374'
22/01/2025 12:15:59 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23375' , '1' , '' , 'nuovo-prodotto' )
22/01/2025 12:15:59 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 '23375' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23374'
22/01/2025 12:15:59 pm >> INSERT INTO `ps_stock_available` (
id_product , id_product_attribute , id_shop , id_shop_group , quantity
) SELECT '23375' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23374'
22/01/2025 12:16:20 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831557917' AND id_product != '23375' AND ean13 != ''
22/01/2025 12:16:20 pm >> UPDATE ps_product SET
id_supplier = '',
reference = 'ESPOSITORE S. PAOLO',
ean13 = '9788831557917',
date_upd = NOW()
WHERE id_product = '23375'
22/01/2025 12:16:21 pm >> UPDATE ps_product_lang SET
name = 'RISURREZZIONE',
description = ''
WHERE id_product = '23375'
22/01/2025 12:16:21 pm >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '2.5'
WHERE id_product = '23375'
22/01/2025 12:16:21 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '2.5',
id_tax_rules_group = '4',
id_category_default = '27',
id_argoment_default = '41',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '23375'
22/01/2025 12:16:21 pm >> DELETE FROM ps_specific_price WHERE id_product = '23375'
22/01/2025 12:16:24 pm >> INSERT INTO ps_product (
id_tax_rules_group , `date_add` , `date_upd`
) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '23375'
22/01/2025 12:16:24 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23376' , '1' , '' , 'nuovo-prodotto' )
22/01/2025 12:16:24 pm >> INSERT INTO ps_product_shop (
id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd`
) SELECT '23376' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23375'
22/01/2025 12:16:24 pm >> INSERT INTO `ps_stock_available` (
id_product , id_product_attribute , id_shop , id_shop_group , quantity
) SELECT '23376' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23375'
22/01/2025 12:17:23 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8019118310293' AND id_product != '23376' AND ean13 != ''
22/01/2025 12:17:23 pm >> UPDATE ps_product SET
id_supplier = '',
reference = '1/5',
ean13 = '8019118310293',
date_upd = NOW()
WHERE id_product = '23376'
22/01/2025 12:17:23 pm >> UPDATE ps_product_lang SET
name = 'CANTUS MARIALES',
description = ''
WHERE id_product = '23376'
22/01/2025 12:17:23 pm >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '12.295081967213115'
WHERE id_product = '23376'
22/01/2025 12:17:23 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '12.295081967213115',
id_tax_rules_group = '1',
id_category_default = '27',
id_argoment_default = '66',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '23376'
22/01/2025 12:17:23 pm >> DELETE FROM ps_specific_price WHERE id_product = '23376'
22/01/2025 12:17:47 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8019118310293' AND id_product != '23376' AND ean13 != ''
22/01/2025 12:17:47 pm >> UPDATE ps_product SET
id_supplier = '',
reference = '1/5',
ean13 = '8019118310293',
date_upd = NOW()
WHERE id_product = '23376'
22/01/2025 12:17:47 pm >> UPDATE ps_product_lang SET
name = 'CANTUS MARIALES',
description = ''
WHERE id_product = '23376'
22/01/2025 12:17:47 pm >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '12.295081967213115'
WHERE id_product = '23376'
22/01/2025 12:17:47 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '12.295081967213115',
id_tax_rules_group = '1',
id_category_default = '27',
id_argoment_default = '66',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '23376'
22/01/2025 12:17:47 pm >> DELETE FROM ps_specific_price WHERE id_product = '23376'
22/01/2025 12:20:11 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() )
22/01/2025 12:20:11 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23377' , '1' , '' , 'nuovo-prodotto' )
22/01/2025 12:20:11 pm >> INSERT INTO ps_product_shop (
id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd`
) VALUES (
'23377' , '1' , '1' , '2' , NOW() , NOW()
)
22/01/2025 12:20:11 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '23377' , '0' , '1' , '0' , '0' )
22/01/2025 12:21:15 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801069389' AND id_product != '23377' AND ean13 != ''
22/01/2025 12:21:15 pm >> UPDATE ps_product SET
id_supplier = '',
reference = '5/5',
ean13 = '9788801069389',
date_upd = NOW()
WHERE id_product = '23377'
22/01/2025 12:21:15 pm >> UPDATE ps_product_lang SET
name = 'DON BOSCO UNA VITA UN GIOCO',
description = ''
WHERE id_product = '23377'
22/01/2025 12:21:15 pm >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '5.9'
WHERE id_product = '23377'
22/01/2025 12:21:15 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '5.9',
id_tax_rules_group = '4',
id_category_default = '19',
id_argoment_default = '71',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '23377'
22/01/2025 12:21:15 pm >> DELETE FROM ps_specific_price WHERE id_product = '23377'
22/01/2025 12:25:02 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() )
22/01/2025 12:25:02 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23378' , '1' , '' , 'nuovo-prodotto' )
22/01/2025 12:25:02 pm >> INSERT INTO ps_product_shop (
id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd`
) VALUES (
'23378' , '1' , '1' , '2' , NOW() , NOW()
)
22/01/2025 12:25:02 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '23378' , '0' , '1' , '0' , '0' )
22/01/2025 12:25:05 pm >> INSERT INTO ps_product (
id_tax_rules_group , `date_add` , `date_upd`
) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '23377'
22/01/2025 12:25:05 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23379' , '1' , '' , 'nuovo-prodotto' )
22/01/2025 12:25:05 pm >> INSERT INTO ps_product_shop (
id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd`
) SELECT '23379' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23377'
22/01/2025 12:25:05 pm >> INSERT INTO `ps_stock_available` (
id_product , id_product_attribute , id_shop , id_shop_group , quantity
) SELECT '23379' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23377'
22/01/2025 12:25:38 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801069273' AND id_product != '23379' AND ean13 != ''
22/01/2025 12:25:38 pm >> UPDATE ps_product SET
id_supplier = '',
reference = '5/5',
ean13 = '9788801069273',
date_upd = NOW()
WHERE id_product = '23379'
22/01/2025 12:25:38 pm >> UPDATE ps_product_lang SET
name = 'NOTTI DI PINOCCHIO',
description = ''
WHERE id_product = '23379'
22/01/2025 12:25:38 pm >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '14'
WHERE id_product = '23379'
22/01/2025 12:25:38 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '14',
id_tax_rules_group = '4',
id_category_default = '19',
id_argoment_default = '25',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '23379'
22/01/2025 12:25:38 pm >> DELETE FROM ps_specific_price WHERE id_product = '23379'
22/01/2025 12:27:43 pm >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'33' ,
'687247' ,
'2025-01-17' ,
'' ,
'0' ,
'7' ,
'2602' ,
'P. ZZA SAN PAOLO, 14 12051 ALBA' ,
'' ,
'' ,
'6.88' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'11' ,
'0' ,
'240.33' ,
'238.44' ,
NOW() ,
NOW() )
22/01/2025 12:27:43 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95387'
22/01/2025 12:27:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '95387'
22/01/2025 12:27:43 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95387' , '23365' , 'VIA CRUCIS DEL PELLEGRINO ' , '12' , '12' , '4' ,
'2.00' , '2' , '0' , '33' , '16.0800' )
22/01/2025 12:27:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23365' AND id_supplier = '7'
22/01/2025 12:27:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23365' , '7' , '1' )
22/01/2025 12:27:43 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95387' , '23365' , 'VIA CRUCIS DEL PELLEGRINO ' , '1' , '1' , '4' ,
'2.00' , '2' , '0' , '100' , '0.0000' )
22/01/2025 12:27:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23365' AND id_supplier = '7'
22/01/2025 12:27:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23365' , '7' , '1' )
22/01/2025 12:27:43 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95387' , '23362' , 'ALFABETO DELLUOMO - G. RAVASI' , '1' , '1' , '4' ,
'18.00' , '18' , '0' , '33' , '12.0600' )
22/01/2025 12:27:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23362' AND id_supplier = '7'
22/01/2025 12:27:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23362' , '7' , '1' )
22/01/2025 12:27:43 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95387' , '23363' , 'SPERANZA TRASFORMA LA VITA - R. FISICHELLA' , '1' , '1' , '4' ,
'12.00' , '12' , '0' , '33' , '8.0400' )
22/01/2025 12:27:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23363' AND id_supplier = '7'
22/01/2025 12:27:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23363' , '7' , '1' )
22/01/2025 12:27:43 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95387' , '23364' , 'PADRE PIO - S. GAETA' , '1' , '1' , '4' ,
'14.00' , '14' , '0' , '33' , '9.3800' )
22/01/2025 12:27:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23364' AND id_supplier = '7'
22/01/2025 12:27:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23364' , '7' , '1' )
22/01/2025 12:27:43 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95387' , '23360' , 'QUARESIMA E PASQUA 2025' , '12' , '12' , '4' ,
'2.90' , '2.9' , '0' , '33' , '23.3160' )
22/01/2025 12:27:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23360' AND id_supplier = '7'
22/01/2025 12:27:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23360' , '7' , '1' )
22/01/2025 12:27:43 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95387' , '23360' , 'QUARESIMA E PASQUA 2025' , '1' , '1' , '4' ,
'2.90' , '2.9' , '0' , '100' , '0.0000' )
22/01/2025 12:27:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23360' AND id_supplier = '7'
22/01/2025 12:27:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23360' , '7' , '1' )
22/01/2025 12:27:43 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95387' , '23359' , 'SUSSIDIO DI QUARESIMA E PASQUA 2025' , '5' , '5' , '4' ,
'2.50' , '2.5' , '0' , '35' , '8.1250' )
22/01/2025 12:27:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23359' AND id_supplier = '7'
22/01/2025 12:27:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23359' , '7' , '1' )
22/01/2025 12:27:43 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95387' , '23377' , 'DON BOSCO UNA VITA UN GIOCO' , '1' , '1' , '4' ,
'5.90' , '5.9' , '0' , '35' , '3.8350' )
22/01/2025 12:27:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23377' AND id_supplier = '7'
22/01/2025 12:27:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23377' , '7' , '1' )
22/01/2025 12:27:43 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95387' , '23374' , 'VEDERE LA BELLA NOTIZIA - J. HERNANDEZ' , '2' , '2' , '4' ,
'2.90' , '2.9' , '0' , '33' , '3.8860' )
22/01/2025 12:27:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23374' AND id_supplier = '7'
22/01/2025 12:27:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23374' , '7' , '1' )
22/01/2025 12:27:43 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95387' , '23373' , 'SPERANZA NEI PADRI' , '2' , '2' , '4' ,
'2.90' , '2.9' , '0' , '33' , '3.8860' )
22/01/2025 12:27:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23373' AND id_supplier = '7'
22/01/2025 12:27:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23373' , '7' , '1' )
22/01/2025 12:27:43 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95387' , '23372' , 'LAVANDA DEI PIEDI' , '2' , '2' , '4' ,
'2.50' , '2.5' , '0' , '33' , '3.3500' )
22/01/2025 12:27:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23372' AND id_supplier = '7'
22/01/2025 12:27:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23372' , '7' , '1' )
22/01/2025 12:27:43 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95387' , '23371' , 'ULTIMA CENA - J. RODRIGUEZ' , '2' , '2' , '4' ,
'2.50' , '2.5' , '0' , '33' , '3.3500' )
22/01/2025 12:27:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23371' AND id_supplier = '7'
22/01/2025 12:27:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23371' , '7' , '1' )
22/01/2025 12:27:43 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95387' , '23375' , 'RISURREZZIONE' , '2' , '2' , '4' ,
'2.50' , '2.5' , '0' , '33' , '3.3500' )
22/01/2025 12:27:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23375' AND id_supplier = '7'
22/01/2025 12:27:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23375' , '7' , '1' )
22/01/2025 12:27:43 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95387' , '23357' , 'QUARESIMA 2025 - ALLE SORGENTI DELLA SPERANZA' , '12' , '12' , '4' ,
'3.60' , '3.6' , '0' , '30' , '30.2400' )
22/01/2025 12:27:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23357' AND id_supplier = '7'
22/01/2025 12:27:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23357' , '7' , '1' )
22/01/2025 12:27:43 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95387' , '23357' , 'QUARESIMA 2025 - ALLE SORGENTI DELLA SPERANZA' , '1' , '1' , '4' ,
'3.60' , '3.6' , '0' , '100' , '0.0000' )
22/01/2025 12:27:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23357' AND id_supplier = '7'
22/01/2025 12:27:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23357' , '7' , '1' )
22/01/2025 12:27:43 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95387' , '23358' , 'MIO FIGLIO E TORNATO' , '3' , '3' , '4' ,
'3.80' , '3.8' , '0' , '30' , '7.9800' )
22/01/2025 12:27:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23358' AND id_supplier = '7'
22/01/2025 12:27:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23358' , '7' , '1' )
22/01/2025 12:27:43 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95387' , '23366' , 'VIA CRUCIS CON MARIA - A. COMASTRI' , '12' , '12' , '4' ,
'2.00' , '2' , '0' , '30' , '16.8000' )
22/01/2025 12:27:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23366' AND id_supplier = '7'
22/01/2025 12:27:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23366' , '7' , '1' )
22/01/2025 12:27:43 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95387' , '23366' , 'VIA CRUCIS CON MARIA - A. COMASTRI' , '1' , '1' , '4' ,
'2.00' , '2' , '0' , '100' , '0.0000' )
22/01/2025 12:27:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23366' AND id_supplier = '7'
22/01/2025 12:27:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23366' , '7' , '1' )
22/01/2025 12:27:44 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95387' , '23376' , 'CANTUS MARIALES' , '1' , '1' , '1' ,
'12.29' , '10.073770491803' , '22' , '30' , '10.4957' )
22/01/2025 12:27:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23376' AND id_supplier = '7'
22/01/2025 12:27:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23376' , '7' , '1' )
22/01/2025 12:27:44 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95387' , '23355' , 'INSIEME NELLA MESSA - MAR 25' , '1' , '1' , '4' ,
'1.80' , '1.8' , '0' , '33' , '1.2060' )
22/01/2025 12:27:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23355' AND id_supplier = '7'
22/01/2025 12:27:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23355' , '7' , '1' )
22/01/2025 12:27:44 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95387' , '23356' , 'PAROLA E PREGHIERA - MAR 25' , '4' , '4' , '4' ,
'2.90' , '2.9' , '0' , '33' , '7.7720' )
22/01/2025 12:27:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23356' AND id_supplier = '7'
22/01/2025 12:27:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23356' , '7' , '1' )
22/01/2025 12:27:44 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95387' , '23368' , 'VANGELO SPIEGATO A MIO FIGLIO - V. LOMBARDO' , '1' , '1' , '4' ,
'15.00' , '15' , '0' , '30' , '10.5000' )
22/01/2025 12:27:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23368' AND id_supplier = '7'
22/01/2025 12:27:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23368' , '7' , '1' )
22/01/2025 12:27:44 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95387' , '23367' , 'COMPASSIONE E RIPARAZIONE - O. DE BERTOLIS' , '1' , '1' , '4' ,
'12.00' , '12' , '0' , '30' , '8.4000' )
22/01/2025 12:27:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23367' AND id_supplier = '7'
22/01/2025 12:27:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23367' , '7' , '1' )
22/01/2025 12:27:44 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95387' , '23379' , 'NOTTI DI PINOCCHIO' , '1' , '1' , '4' ,
'14.00' , '14' , '0' , '35' , '9.1000' )
22/01/2025 12:27:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23379' AND id_supplier = '7'
22/01/2025 12:27:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23379' , '7' , '1' )
22/01/2025 12:27:44 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95387' , '23369' , 'PREGHIERA DI INTERCESSIONE - G. SACINO' , '1' , '1' , '4' ,
'15.00' , '15' , '0' , '30' , '10.5000' )
22/01/2025 12:27:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23369' AND id_supplier = '7'
22/01/2025 12:27:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23369' , '7' , '1' )
22/01/2025 12:27:44 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95387' , '23370' , 'CODICE CUORE - C. GALATOLO' , '1' , '1' , '4' ,
'12.00' , '12' , '0' , '30' , '8.4000' )
22/01/2025 12:27:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23370' AND id_supplier = '7'
22/01/2025 12:27:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23370' , '7' , '1' )
22/01/2025 12:27:44 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95387' , '23361' , 'PERCORSI DEL GIUBILEO - L. FERRAIUOLO' , '1' , '1' , '4' ,
'20.00' , '20' , '0' , '33' , '13.4000' )
22/01/2025 12:27:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23361' AND id_supplier = '7'
22/01/2025 12:27:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23361' , '7' , '1' )
22/01/2025 12:36:09 pm >> SELECT document_num FROM ps_document
WHERE document_num = '224' AND id_document != '95386' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-22')
22/01/2025 12:36:09 pm >> UPDATE ps_document SET
id_document_type = '11',
document_num = '224',
document_date = '2025-01-22',
document_letter = '',
id_customer = '0',
id_supplier = '',
id_address = '0',
address1 = '',
address2 = '',
note = '',
price_shipping = '0.00',
id_tax_shipping_rules = '4',
colli = '0',
peso = '0',
porto_e_imballo = '0',
mezzo_consegna = '',
id_payment = '0',
id_causal = '0',
price_tax_included = '200.00',
price_tax_excluded = '187.71',
date_upd = NOW()
WHERE id_document = '95386'
22/01/2025 12:36:09 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95386'
22/01/2025 12:36:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '95386'
22/01/2025 12:36:09 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95386' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '6' , '-6' , '1' ,
'7.5000' , '6.1475409836066' , '22' , '0' , '45.00' )
22/01/2025 12:36:09 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95386' , '23126' , 'DI PASQUA IN PASQUA ANNO C - F. ROSINI' , '1' , '-1' , '4' ,
'16.0000' , '16' , '0' , '5' , '15.20' )
22/01/2025 12:36:09 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95386' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '20' , '-20' , '3' ,
'3.5000' , '3.3653846153846' , '4' , '0' , '70.00' )
22/01/2025 12:36:09 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95386' , '16689' , 'OSTIA PAN DI CENA mm80' , '19' , '-19' , '3' ,
'2.0000' , '1.9230769230769' , '4' , '0' , '38.00' )
22/01/2025 12:36:09 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95386' , '16689' , 'OSTIA PAN DI CENA mm80' , '1' , '-1' , '3' ,
'0.5400' , '0.51923076923077' , '4' , '0' , '0.54' )
22/01/2025 12:36:09 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95386' , '23371' , 'ULTIMA CENA - J. RODRIGUEZ' , '1' , '-1' , '4' ,
'2.50' , '2.5' , '0' , '5' , '2.38' )
22/01/2025 12:36:09 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95386' , '23366' , 'VIA CRUCIS CON MARIA - A. COMASTRI' , '1' , '-1' , '4' ,
'2.00' , '2' , '0' , '5' , '1.90' )
22/01/2025 12:36:09 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95386' , '23377' , 'DON BOSCO UNA VITA UN GIOCO' , '1' , '-1' , '4' ,
'5.6' , '5.6' , '0' , '0' , '5.60' )
22/01/2025 12:36:09 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95386' , '23379' , 'NOTTI DI PINOCCHIO' , '1' , '-1' , '4' ,
'14.00' , '14' , '0' , '5' , '13.30' )
22/01/2025 12:36:09 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95386' , '23357' , 'QUARESIMA 2025 - ALLE SORGENTI DELLA SPERANZA' , '1' , '-1' , '4' ,
'3.60' , '3.6' , '0' , '5' , '3.42' )
22/01/2025 12:36:09 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95386' , '23360' , 'QUARESIMA E PASQUA 2025' , '1' , '-1' , '4' ,
'2.90' , '2.9' , '0' , '5' , '2.76' )
22/01/2025 12:36:09 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95386' , '23365' , 'VIA CRUCIS DEL PELLEGRINO ' , '1' , '-1' , '4' ,
'2.00' , '2' , '0' , '5' , '1.90' )
22/01/2025 12:38:15 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884044822' AND id_product != '12904' AND ean13 != ''
22/01/2025 12:38:16 pm >> UPDATE ps_product SET
id_supplier = '38',
reference = 'ESPOSITORE SHALOM',
ean13 = '9788884044822',
date_upd = NOW()
WHERE id_product = '12904'
22/01/2025 12:38:16 pm >> UPDATE ps_product_lang SET
name = 'NOVENA DELLE ROSE A S. TERESA LISIEUX - 8848',
description = ''
WHERE id_product = '12904'
22/01/2025 12:38:16 pm >> UPDATE ps_product SET
wholesale_price = '0.90',
on_sale = '0',
price = '1.5000'
WHERE id_product = '12904'
22/01/2025 12:38:16 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.90',
price = '1.5000',
id_tax_rules_group = '4',
id_category_default = '106',
id_argoment_default = '28',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '12904'
22/01/2025 12:38:16 pm >> DELETE FROM ps_specific_price WHERE id_product = '12904'
22/01/2025 02:54:50 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() )
22/01/2025 02:54:50 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23380' , '1' , '' , 'nuovo-prodotto' )
22/01/2025 02:54:50 pm >> INSERT INTO ps_product_shop (
id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd`
) VALUES (
'23380' , '1' , '1' , '2' , NOW() , NOW()
)
22/01/2025 02:54:50 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '23380' , '0' , '1' , '0' , '0' )
22/01/2025 02:56:58 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791280736536' AND id_product != '23380' AND ean13 != ''
22/01/2025 02:56:58 pm >> UPDATE ps_product SET
id_supplier = '',
reference = '13/3',
ean13 = '9791280736536',
date_upd = NOW()
WHERE id_product = '23380'
22/01/2025 02:56:58 pm >> UPDATE ps_product_lang SET
name = 'DAL TUO CUORE TRAFITTO E GLORIOSO LA NOSTRA GIOIA E LA NOSTRA SPERANZA',
description = ''
WHERE id_product = '23380'
22/01/2025 02:56:58 pm >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '2.5'
WHERE id_product = '23380'
22/01/2025 02:56:59 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '2.5',
id_tax_rules_group = '4',
id_category_default = '395',
id_argoment_default = '28',
id_internal_category = '4',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '23380'
22/01/2025 02:56:59 pm >> DELETE FROM ps_specific_price WHERE id_product = '23380'
22/01/2025 02:56:59 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' , '23380' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' )
22/01/2025 02:59:55 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791280736536' AND id_product != '23380' AND ean13 != ''
22/01/2025 02:59:55 pm >> UPDATE ps_product SET
id_supplier = '',
reference = '13/3',
ean13 = '9791280736536',
date_upd = NOW()
WHERE id_product = '23380'
22/01/2025 02:59:55 pm >> UPDATE ps_product_lang SET
name = 'DAL TUO CUORE TRAFITTO E GLORIOSO LA NOSTRA GIOIA E LA NOSTRA SPERANZA',
description = 'Dal tuo cuore trafitto e glorioso la nostra gioia e la nostra speranza. Per vivere in profondità il tempo di Quaresima.
In un anno già caratterizzato dall’atmosfera del Giubileo dedicato alla Speranza, questo sussidio per il cammino quaresimale segue come tema fondamentale la spiritualità del Cuore del Signore, prendendo spunto dalla straordinaria sensibilità di Papa Francesco, di cui è impregnata la sua recente Enciclica Dilexit nos, dedicata proprio all’amore umano e divino del cuore di Gesù Cristo. Ci guideranno in questo percorso le meditazioni e le preghiere di grandi testimoni e propagatori di questa devozione, teologicamente ricca e profonda, come Santa Margherita Maria Alacoque e San Claudio de la Colombière, San Charles de Foucauld, Santa Teresa di Lisieux, Santa Faustina Kowalska (indicati anche dal Santo Padre nel suo interessante excursus storico) e altri.
'
WHERE id_product = '23380'
22/01/2025 02:59:55 pm >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '2.5'
WHERE id_product = '23380'
22/01/2025 02:59:55 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '2.5',
id_tax_rules_group = '4',
id_category_default = '395',
id_argoment_default = '28',
id_internal_category = '4',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '23380'
22/01/2025 02:59:55 pm >> DELETE FROM ps_specific_price WHERE id_product = '23380'
22/01/2025 02:59:55 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' , '23380' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' )
22/01/2025 03:00:23 pm >> UPDATE ps_product_shop SET active = '1' WHERE id_product = '23380'
22/01/2025 04:40:12 pm >> SELECT document_num FROM ps_document
WHERE document_num = '225' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-22')
22/01/2025 04:40:12 pm >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'225' ,
'2025-01-22' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'124.00' ,
'101.64' ,
NOW() ,
NOW() )
22/01/2025 04:40:12 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95388'
22/01/2025 04:40:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '95388'
22/01/2025 04:40:13 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95388' , '22105' , 'CANDELINE NON GOCCIOLANTI IN BUSTA - CHA25' , '4' , '-4' , '1' ,
'18.00' , '14.754098360656' , '22' , '0' , '72.00' )
22/01/2025 04:40:13 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95388' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '4' , '-4' , '1' ,
'13.00' , '10.655737704918' , '22' , '0' , '52.00' )
22/01/2025 04:40:42 pm >> SELECT document_num FROM ps_document
WHERE document_num = '226' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-22')
22/01/2025 04:40: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' ,
'226' ,
'2025-01-22' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'150.00' ,
'122.95' ,
NOW() ,
NOW() )
22/01/2025 04:40: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 = '95389'
22/01/2025 04:40:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '95389'
22/01/2025 04:40: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
( '95389' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' ,
'150' , '122.95081967213' , '22' , '0' , '150.00' )
22/01/2025 04:46:42 pm >> SELECT document_num FROM ps_document
WHERE document_num = '227' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-22')
22/01/2025 04:46: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' ,
'227' ,
'2025-01-22' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'8.60' ,
'8.27' ,
NOW() ,
NOW() )
22/01/2025 04:46: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 = '95390'
22/01/2025 04:46:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '95390'
22/01/2025 04:46: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
( '95390' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '2' , '-2' , '3' ,
'4.30' , '4.1346153846154' , '4' , '0' , '8.60' )
22/01/2025 05:05:08 pm >> SELECT document_num FROM ps_document
WHERE document_num = '228' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-22')
22/01/2025 05:05:08 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' ,
'228' ,
'2025-01-22' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'9.20' ,
'7.54' ,
NOW() ,
NOW() )
22/01/2025 05:05:08 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 = '95391'
22/01/2025 05:05:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '95391'
22/01/2025 05:05:08 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95391' , '20062' , 'BRACCIALE DECINA - BD018' , '1' , '-1' , '1' ,
'2.00' , '1.6393442622951' , '22' , '0' , '2.00' )
22/01/2025 05:05:08 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95391' , '16310' , 'PORTACHIAVI COLOMBA - KP027' , '4' , '-4' , '1' ,
'1.20' , '0.98360655737705' , '22' , '0' , '4.80' )
22/01/2025 05:05:08 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95391' , '18218' , 'DECINA LEGNO CHIARO - FR52' , '2' , '-2' , '1' ,
'0.60' , '0.49180327868852' , '22' , '0' , '1.20' )
22/01/2025 05:05:08 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95391' , '13334' , 'CROCE IN ULIVO CON LACCIO' , '1' , '-1' , '1' ,
'1.20' , '0.98360655737705' , '22' , '0' , '1.20' )
22/01/2025 05:16:36 pm >> SELECT document_num FROM ps_document
WHERE document_num = '229' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-22')
22/01/2025 05:16:36 pm >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'229' ,
'2025-01-22' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'72.00' ,
'59.02' ,
NOW() ,
NOW() )
22/01/2025 05:16:36 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95392'
22/01/2025 05:16:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '95392'
22/01/2025 05:16:36 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95392' , '23349' , 'DECINA IMITAZIONE PERLA 5MM - 1708' , '30' , '-30' , '1' ,
'2' , '1.6393442622951' , '22' , '0' , '60.00' )
22/01/2025 05:16:36 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95392' , '12936' , 'SCATOLA 4X4' , '30' , '-30' , '1' ,
'0.4' , '0.32786885245902' , '22' , '0' , '12.00' )
22/01/2025 05:54:41 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001900' AND id_product != '19099' AND ean13 != ''
22/01/2025 05:54:41 pm >> UPDATE ps_product SET
id_supplier = '157',
reference = '',
ean13 = '001900',
date_upd = NOW()
WHERE id_product = '19099'
22/01/2025 05:54:41 pm >> UPDATE ps_product_lang SET
name = 'INCENSO A',
description = ''
WHERE id_product = '19099'
22/01/2025 05:54:41 pm >> UPDATE ps_product SET
wholesale_price = '19.00',
on_sale = '0',
price = '40.16393442622951'
WHERE id_product = '19099'
22/01/2025 05:54:41 pm >> UPDATE ps_product_shop SET
wholesale_price = '19.00',
price = '40.16393442622951',
id_tax_rules_group = '1',
id_category_default = '489',
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 = '19099'
22/01/2025 05:54:41 pm >> DELETE FROM ps_specific_price WHERE id_product = '19099'
22/01/2025 06:00:12 pm >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'31' ,
'1865' ,
'2025-01-16' ,
'' ,
'0' ,
'157' ,
'4673300' ,
'10 AGIAS ANNIS STR 17778 ATHENS - GRECIA' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'9' ,
'0' ,
'2474.00' ,
'2474.00' ,
NOW() ,
NOW() )
22/01/2025 06:00:12 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95393'
22/01/2025 06:00:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '95393'
22/01/2025 06:00:12 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95393' , '19099' , 'INCENSO A' , '13' , '13' , '0' ,
'20' , '20' , '' , '0' , '260.0000' )
22/01/2025 06:00:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19099' AND id_supplier = '157'
22/01/2025 06:00:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19099' , '157' , '1' )
22/01/2025 06:00:12 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95393' , '19100' , 'INCENSO B' , '17' , '17' , '0' ,
'9.5' , '9.5' , '' , '0' , '161.5000' )
22/01/2025 06:00:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19100' AND id_supplier = '157'
22/01/2025 06:00:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19100' , '157' , '1' )
22/01/2025 06:00:12 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95393' , '19102' , 'CARBONCINI MM 40' , '60' , '60' , '0' ,
'4' , '4' , '' , '0' , '240.0000' )
22/01/2025 06:00:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19102' AND id_supplier = '157'
22/01/2025 06:00:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19102' , '157' , '1' )
22/01/2025 06:00:12 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95393' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '100' , '100' , '0' ,
'3' , '3' , '' , '0' , '300.0000' )
22/01/2025 06:00:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1710' AND id_supplier = '157'
22/01/2025 06:00:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1710' , '157' , '1' )
22/01/2025 06:00:12 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95393' , '19107' , 'INCENSO GRANI 3A - BUSTA' , '75' , '75' , '0' ,
'10' , '10' , '' , '0' , '750.0000' )
22/01/2025 06:00:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19107' AND id_supplier = '157'
22/01/2025 06:00:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19107' , '157' , '1' )
22/01/2025 06:00:12 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95393' , '19818' , 'INCENSO NATURALE 3A KG 1' , '75' , '75' , '0' ,
'7.9' , '7.9' , '' , '0' , '592.5000' )
22/01/2025 06:00:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19818' AND id_supplier = '157'
22/01/2025 06:00:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19818' , '157' , '1' )
22/01/2025 06:00:12 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95393' , '10133' , 'SPESE DI TRASPORTO' , '1' , '1' , '0' ,
'170' , '170' , '' , '0' , '170.0000' )
22/01/2025 06:00:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '10133' AND id_supplier = '157'
22/01/2025 06:00:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10133' , '157' , '1' )
22/01/2025 06:00:53 pm >> SELECT document_num FROM ps_document
WHERE document_num = '143' AND id_document != '95285' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-15')
22/01/2025 06:00:53 pm >> UPDATE ps_document SET
id_document_type = '11',
document_num = '143',
document_date = '2025-01-15',
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 = '16.70',
price_tax_excluded = '13.69',
date_upd = NOW()
WHERE id_document = '95285'
22/01/2025 06:00:53 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 = '95285'
22/01/2025 06:00:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '95285'
22/01/2025 06:00:53 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95285' , '19818' , 'INCENSO NATURALE 3A KG 1' , '1' , '-1' , '1' ,
'16' , '13.114754098361' , '22' , '0' , '16.00' )
22/01/2025 06:00:53 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95285' , '18222' , 'ROSARIO COLORATO - R316' , '1' , '-1' , '1' ,
'0.7000' , '0.57377049180328' , '22' , '0' , '0.70' )
22/01/2025 06:30:03 pm >> SELECT document_num FROM ps_document
WHERE document_num = '226' AND id_document != '95389' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-22')
22/01/2025 06:30:03 pm >> UPDATE ps_document SET
id_document_type = '11',
document_num = '226',
document_date = '2025-01-22',
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 = '150.00',
price_tax_excluded = '122.95',
date_upd = NOW()
WHERE id_document = '95389'
22/01/2025 06:30: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 = '95389'
22/01/2025 06:30:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '95389'
22/01/2025 06:30: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
( '95389' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '1' , '-1' , '1' ,
'7.5' , '6.1475409836066' , '22' , '0' , '7.50' )
22/01/2025 06:30: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
( '95389' , '11756' , 'VINO BIANCO SECCO - 14%' , '18' , '-18' , '1' ,
'6' , '4.9180327868852' , '22' , '0' , '108.00' )
22/01/2025 06:30: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
( '95389' , '11756' , 'VINO BIANCO SECCO - 14%' , '5' , '-5' , '1' ,
'6.9' , '5.655737704918' , '22' , '0' , '34.50' )
22/01/2025 07:01:18 pm >> SELECT document_num FROM ps_document
WHERE document_num = '230' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-22')
22/01/2025 07:01:18 pm >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'230' ,
'2025-01-22' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'50.00' ,
'40.98' ,
NOW() ,
NOW() )
22/01/2025 07:01:18 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95394'
22/01/2025 07:01:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '95394'
22/01/2025 07:01:18 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95394' , '23082' , 'CAMICE RAGLAN CERNIERA DAVANTI - CA01' , '1' , '-1' , '1' ,
'50' , '40.983606557377' , '22' , '0' , '50.00' )
22/01/2025 07:01:55 pm >> SELECT document_num FROM ps_document
WHERE document_num = '231' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-22')
22/01/2025 07:01:55 pm >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'231' ,
'2025-01-22' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'20.90' ,
'20.90' ,
NOW() ,
NOW() )
22/01/2025 07:01:55 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95395'
22/01/2025 07:01:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '95395'
22/01/2025 07:01: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
( '95395' , '23341' , 'SPERA - PAPA FRANCESCO' , '1' , '-1' , '4' ,
'22.00' , '22' , '0' , '5' , '20.90' )
22/01/2025 07:04:02 pm >> SELECT document_num FROM ps_document
WHERE document_num = '232' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-22')
22/01/2025 07:04:02 pm >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'232' ,
'2025-01-22' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'4.00' ,
'4.00' ,
NOW() ,
NOW() )
22/01/2025 07:04:02 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95396'
22/01/2025 07:04:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '95396'
22/01/2025 07:04:02 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95396' , '9438' , 'SAN GENNARO VESCOVO' , '1' , '-1' , '4' ,
'4.00' , '4' , '0' , '0' , '4.00' )
22/01/2025 07:19:32 pm >> SELECT document_num FROM ps_document
WHERE document_num = '233' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-22')
22/01/2025 07:19:32 pm >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'233' ,
'2025-01-22' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'76.95' ,
'76.95' ,
NOW() ,
NOW() )
22/01/2025 07:19:32 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95397'
22/01/2025 07:19:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '95397'
22/01/2025 07:19:32 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95397' , '23256' , 'CELEBRIAMO MARIA - MESSALE MARIANO' , '1' , '-1' , '4' ,
'42.00' , '42' , '0' , '5' , '39.90' )
22/01/2025 07:19:32 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95397' , '17581' , 'MESSALE QUOTIDIANO N.E. ' , '1' , '-1' , '4' ,
'39.00' , '39' , '0' , '5' , '37.05' )