28/02/2023 09:19:57 am >> SELECT document_num FROM ps_document
WHERE document_num = '39' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-02-28')
28/02/2023 09:19:57 am >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'21' ,
'39' ,
'2023-02-28' ,
'' ,
'3430' ,
'0' ,
'4670681' ,
'VIA S. MARIA IN MONTICELLI, 28 00186 ROMA' ,
'' ,
'omaggio autore' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'0.00' ,
'0.00' ,
NOW() ,
NOW() )
28/02/2023 09:19:57 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82049'
28/02/2023 09:19:57 am >> DELETE FROM ps_document_detail WHERE id_document = '82049'
28/02/2023 09:19:57 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '82049' , '20719' , 'CORONA DELL’ADDOLORATA' , '100' , '-100' , '4' ,
'1.80' , '1.8' , '0' , '100' , '0.00' )
28/02/2023 09:19:57 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '82049' , '20722' , 'SEMINATORI DI GIOIA' , '100' , '-100' , '4' ,
'2.50' , '2.5' , '0' , '100' , '0.00' )
28/02/2023 09:20:42 am >> SELECT document_num FROM ps_document
WHERE document_num = '38' AND id_document != '82014' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-02-24')
28/02/2023 09:20:43 am >> UPDATE ps_document SET
id_document_type = '21',
document_num = '38',
document_date = '2023-02-24',
document_letter = '',
id_customer = '3945',
id_supplier = '',
id_address = '4676041',
address1 = 'PIAZZA M. BARILARI 1 89822 SERRA SAN BRUNO',
address2 = '',
note = 'copie omaggio autore',
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 = '0.00',
price_tax_excluded = '0.00',
date_upd = NOW()
WHERE id_document = '82014'
28/02/2023 09:20: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 = '82014'
28/02/2023 09:20:43 am >> DELETE FROM ps_document_detail WHERE id_document = '82014'
28/02/2023 09:20: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
( '82014' , '20720' , 'PADRE NOSTRO - L. CALABRETTA' , '50' , '-50' , '4' ,
'4.5000' , '4.5' , '0' , '100' , '0.00' )
28/02/2023 09:20: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
( '82014' , '20721' , 'AVE MARIA - L. CALABRETTA' , '50' , '-50' , '4' ,
'4.5000' , '4.5' , '0' , '100' , '0.00' )
28/02/2023 09:34:54 am >> SELECT document_num FROM ps_document
WHERE document_num = '656' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-28')
28/02/2023 09:34: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' ,
'656' ,
'2023-02-28' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'44.52' ,
'44.52' ,
NOW() ,
NOW() )
28/02/2023 09:34: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 = '82050'
28/02/2023 09:34:54 am >> DELETE FROM ps_document_detail WHERE id_document = '82050'
28/02/2023 09:34: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
( '82050' , '20528' , 'AMEN - MAR 23' , '6' , '-6' , '4' ,
'3.90' , '3.9' , '0' , '5' , '22.26' )
28/02/2023 09:34: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
( '82050' , '20527' , 'AMEN - APR 23' , '6' , '-6' , '4' ,
'3.90' , '3.9' , '0' , '5' , '22.26' )
28/02/2023 09:50:35 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() )
28/02/2023 09:50:35 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20785' , '1' , '' , 'nuovo-prodotto' )
28/02/2023 09:50:35 am >> INSERT INTO ps_product_shop (
id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd`
) VALUES (
'20785' , '1' , '1' , '2' , NOW() , NOW()
)
28/02/2023 09:50:35 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '20785' , '0' , '1' , '0' , '0' )
28/02/2023 09:52:36 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791280736185' AND id_product != '20785' AND ean13 != ''
28/02/2023 09:52:36 am >> UPDATE ps_product SET
id_supplier = '',
reference = '1/3',
ean13 = '9791280736185',
date_upd = NOW()
WHERE id_product = '20785'
28/02/2023 09:52:36 am >> UPDATE ps_product_lang SET
name = 'CARTA D\'IDENTITA\' DEL CREATO - R. LUPI',
description = ''
WHERE id_product = '20785'
28/02/2023 09:52:36 am >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = 'NaN'
WHERE id_product = '20785'
28/02/2023 09:52:36 am >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = 'NaN',
id_tax_rules_group = '4',
id_category_default = '395',
id_argoment_default = '41',
id_internal_category = '4',
on_sale = '0',
on_showcase = '1',
on_offer = '00',
on_most = '1',
date_upd = NOW()
WHERE id_product = '20785'
28/02/2023 09:52:36 am >> DELETE FROM ps_specific_price WHERE id_product = '20785'
28/02/2023 09:52:36 am >> 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' , '20785' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' )
28/02/2023 09:53:01 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791280736185' AND id_product != '20785' AND ean13 != ''
28/02/2023 09:53:01 am >> UPDATE ps_product SET
id_supplier = '',
reference = '1/3',
ean13 = '9791280736185',
date_upd = NOW()
WHERE id_product = '20785'
28/02/2023 09:53:01 am >> UPDATE ps_product_lang SET
name = 'CARTA D\'IDENTITA\' DEL CREATO - R. LUPI',
description = '
Questo sussidio, sullo stile della “Carta d’identità”, ci aiuta, in modo semplice e sintetico, a conoscere il Creato: la nostra casa in cui viviamo e ci muoviamo. È anche uno strumento divulgativo per conoscere alcuni termini scientifici che riguardano il nostro pianeta Terra, affinché lo apprezziamo sempre di più e ci rendiamo conto di quanto siano importanti per noi la sua cura e il suo rispetto. Queste pagine quindi desiderano stimolarci a guardare intorno a noi e a farci cogliere dalla meraviglia e dallo stupore per la bellezza e per la perfezione che ci circondano; sono soprattutto un invito a scoprire la firma di Dio nella creazione per ringraziarlo e per lodarlo di questo grande dono.
'
WHERE id_product = '20785'
28/02/2023 09:53:01 am >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = 'NaN'
WHERE id_product = '20785'
28/02/2023 09:53:01 am >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = 'NaN',
id_tax_rules_group = '4',
id_category_default = '395',
id_argoment_default = '41',
id_internal_category = '4',
on_sale = '0',
on_showcase = '1',
on_offer = '00',
on_most = '1',
date_upd = NOW()
WHERE id_product = '20785'
28/02/2023 09:53:01 am >> DELETE FROM ps_specific_price WHERE id_product = '20785'
28/02/2023 09:53:01 am >> 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' , '20785' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' )
28/02/2023 09:55:09 am >> UPDATE ps_product_shop SET active = '1' WHERE id_product = '20785'
28/02/2023 10:07:28 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() )
28/02/2023 10:07:28 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20786' , '1' , '' , 'nuovo-prodotto' )
28/02/2023 10:07:28 am >> INSERT INTO ps_product_shop (
id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd`
) VALUES (
'20786' , '1' , '1' , '2' , NOW() , NOW()
)
28/02/2023 10:07:28 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '20786' , '0' , '1' , '0' , '0' )
28/02/2023 10:10:40 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791280736192' AND id_product != '20786' AND ean13 != ''
28/02/2023 10:10:40 am >> UPDATE ps_product SET
id_supplier = '',
reference = '6/2',
ean13 = '9791280736192',
date_upd = NOW()
WHERE id_product = '20786'
28/02/2023 10:10:40 am >> UPDATE ps_product_lang SET
name = 'GIUSEPPE DI NAZARET - M. VIANI',
description = 'L’autore invita a scoprire la vita del carpentiere di Nazaret in un avventuroso viaggio di ricerca. Quello che si legge, infatti, è frutto di un serio lavoro sulle scarse fonti dirette, anche apocrife e patristiche, e di una buona documentazione relativa all’ambiente in cui Giuseppe si trova a vivere: la Galilea del I secolo. Accanto ad esso, c’è un percorso interiore, in cui spiritualità, fantasia e narrativa si incrociano, per proporre un ritratto che dimora nell’animo dell’autore. Lo dimostrano anche gli “inserti” di attualità che l’autore dissemina lungo la narrazione: l’amore, i figli, la vita familiare, i dubbi… sono temi in cui l’esperienza antica dell’uomo di Nazaret incrocia le difficoltà e i dilemmi di persone concrete del XXI secolo.
Mons. Mauro Viani, presbitero dell’Arcidiocesi di Lucca, per lunghi anni parroco e insegnate di Teologia morale sociale, attualmente è Vicario Giudiziale e Canonico Penitenziere della chiesa cattedrale di Lucca.
'
WHERE id_product = '20786'
28/02/2023 10:10:40 am >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '10'
WHERE id_product = '20786'
28/02/2023 10:10:40 am >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '10',
id_tax_rules_group = '4',
id_category_default = '395',
id_argoment_default = '71',
id_internal_category = '4',
on_sale = '0',
on_showcase = '1',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '20786'
28/02/2023 10:10:40 am >> DELETE FROM ps_specific_price WHERE id_product = '20786'
28/02/2023 10:10:40 am >> 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' , '20786' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' )
28/02/2023 10:11:10 am >> UPDATE ps_product_shop SET active = '1' WHERE id_product = '20786'
28/02/2023 10:29:10 am >> SELECT document_num FROM ps_document
WHERE document_num = '657' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-28')
28/02/2023 10:29:10 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' ,
'657' ,
'2023-02-28' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'44.50' ,
'42.79' ,
NOW() ,
NOW() )
28/02/2023 10:29:10 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 = '82051'
28/02/2023 10:29:10 am >> DELETE FROM ps_document_detail WHERE id_document = '82051'
28/02/2023 10:29:10 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '82051' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '10' , '-10' , '3' ,
'3.50' , '3.3653846153846' , '4' , '0' , '35.00' )
28/02/2023 10:29:10 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '82051' , '7311' , 'OSTIA SOTTILE 74MM' , '5' , '-5' , '3' ,
'1.90' , '1.8269230769231' , '4' , '0' , '9.50' )
28/02/2023 10:38:59 am >> SELECT document_num FROM ps_document
WHERE document_num = '658' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-28')
28/02/2023 10:38:59 am >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'658' ,
'2023-02-28' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'4.75' ,
'4.75' ,
NOW() ,
NOW() )
28/02/2023 10:38:59 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82052'
28/02/2023 10:38:59 am >> DELETE FROM ps_document_detail WHERE id_document = '82052'
28/02/2023 10:38:59 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '82052' , '20592' , 'SULLA TUA PAROLA MAR/APR 23 - 515' , '1' , '-1' , '4' ,
'5.00' , '5' , '0' , '5' , '4.75' )
28/02/2023 10:48:45 am >> SELECT document_num FROM ps_document
WHERE document_num = '659' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-28')
28/02/2023 10:48:45 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' ,
'659' ,
'2023-02-28' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'22.00' ,
'18.03' ,
NOW() ,
NOW() )
28/02/2023 10:48:45 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 = '82053'
28/02/2023 10:48:45 am >> DELETE FROM ps_document_detail WHERE id_document = '82053'
28/02/2023 10:48:45 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '82053' , '13142' , 'CERETTI DIAM 26X350 - 2635' , '10' , '-10' , '1' ,
'2.20' , '1.8032786885246' , '22' , '0' , '22.00' )
28/02/2023 10:56:25 am >> SELECT document_num FROM ps_document
WHERE document_num = '660' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-28')
28/02/2023 10:56:25 am >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'660' ,
'2023-02-28' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'19.00' ,
'19.00' ,
NOW() ,
NOW() )
28/02/2023 10:56:25 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82054'
28/02/2023 10:56:25 am >> DELETE FROM ps_document_detail WHERE id_document = '82054'
28/02/2023 10:56:25 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '82054' , '20592' , 'SULLA TUA PAROLA MAR/APR 23 - 515' , '2' , '-2' , '4' ,
'5.00' , '5' , '0' , '5' , '9.50' )
28/02/2023 10:56:25 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '82054' , '11151' , 'LIBRI' , '1' , '-1' , '4' ,
'9.5' , '9.5' , '0' , '0' , '9.50' )
28/02/2023 11:37:42 am >> DELETE FROM ps_document WHERE id_document = '81433'
28/02/2023 11:37:42 am >> DELETE FROM ps_document_detail WHERE id_document = '81433'
28/02/2023 11:37:44 am >> DELETE FROM ps_document WHERE id_document = '81368'
28/02/2023 11:37:44 am >> DELETE FROM ps_document_detail WHERE id_document = '81368'
28/02/2023 11:44:12 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() )
28/02/2023 11:44:12 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20787' , '1' , '' , 'nuovo-prodotto' )
28/02/2023 11:44:12 am >> INSERT INTO ps_product_shop (
id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd`
) VALUES (
'20787' , '1' , '1' , '2' , NOW() , NOW()
)
28/02/2023 11:44:12 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '20787' , '0' , '1' , '0' , '0' )
28/02/2023 11:45:48 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400228328' AND id_product != '20787' AND ean13 != ''
28/02/2023 11:45:48 am >> UPDATE ps_product SET
id_supplier = '',
reference = '',
ean13 = '8058400228328',
date_upd = NOW()
WHERE id_product = '20787'
28/02/2023 11:45:48 am >> UPDATE ps_product_lang SET
name = 'BAMBINO GESU\' - P498',
description = ''
WHERE id_product = '20787'
28/02/2023 11:45:48 am >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '28.688524590163937'
WHERE id_product = '20787'
28/02/2023 11:45:48 am >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '28.688524590163937',
id_tax_rules_group = '1',
id_category_default = '95',
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 = '20787'
28/02/2023 11:45:48 am >> DELETE FROM ps_specific_price WHERE id_product = '20787'
28/02/2023 11:51:11 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() )
28/02/2023 11:51:11 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20788' , '1' , '' , 'nuovo-prodotto' )
28/02/2023 11:51:11 am >> INSERT INTO ps_product_shop (
id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd`
) VALUES (
'20788' , '1' , '1' , '2' , NOW() , NOW()
)
28/02/2023 11:51:12 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '20788' , '0' , '1' , '0' , '0' )
28/02/2023 11:51:58 am >> SELECT ean13 FROM ps_product WHERE ean13 = '1712D' AND id_product != '20788' AND ean13 != ''
28/02/2023 11:51:58 am >> UPDATE ps_product SET
id_supplier = '',
reference = '',
ean13 = '1712D',
date_upd = NOW()
WHERE id_product = '20788'
28/02/2023 11:51:58 am >> UPDATE ps_product_lang SET
name = 'DECINA MISSIOMARIA - 1712D',
description = ''
WHERE id_product = '20788'
28/02/2023 11:51:58 am >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '1.3114754098360657'
WHERE id_product = '20788'
28/02/2023 11:51:58 am >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '1.3114754098360657',
id_tax_rules_group = '1',
id_category_default = '95',
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 = '20788'
28/02/2023 11:51:58 am >> DELETE FROM ps_specific_price WHERE id_product = '20788'
28/02/2023 11:52:00 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 = '20788'
28/02/2023 11:52:00 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20789' , '1' , '' , 'nuovo-prodotto' )
28/02/2023 11:52:00 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 '20789' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20788'
28/02/2023 11:52:00 am >> INSERT INTO `ps_stock_available` (
id_product , id_product_attribute , id_shop , id_shop_group , quantity
) SELECT '20789' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20788'
28/02/2023 11:52:44 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' ,
'A534' ,
'2023-02-28' ,
'' ,
'0' ,
'28' ,
'2623' ,
'VIA DEI MILLE 59 80121 NAPOLI' ,
'' ,
'' ,
'0.05' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'1' ,
'0' ,
'101.80' ,
'83.45' ,
NOW() ,
NOW() )
28/02/2023 11:52:44 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82055'
28/02/2023 11:52:44 am >> DELETE FROM ps_document_detail WHERE id_document = '82055'
28/02/2023 11:52: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
( '82055' , '20787' , 'BAMBINO GESU\' - P498' , '1' , '1' , '1' ,
'14.4' , '11.803278688525' , '22' , '0' , '17.5680' )
28/02/2023 11:52:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '20787' AND id_supplier = '28'
28/02/2023 11:52:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20787' , '28' , '1' )
28/02/2023 11:52: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
( '82055' , '20788' , 'DECINA MISSIOMARIA - 1712D' , '60' , '60' , '1' ,
'0.9' , '0.73770491803279' , '22' , '0' , '65.8800' )
28/02/2023 11:52:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '20788' AND id_supplier = '28'
28/02/2023 11:52:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20788' , '28' , '1' )
28/02/2023 11:52: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
( '82055' , '17277' , 'BRACCIALE PIETRE DURE - 4633' , '6' , '6' , '1' ,
'2.5' , '2.0491803278689' , '22' , '0' , '18.3000' )
28/02/2023 11:52:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '17277' AND id_supplier = '28'
28/02/2023 11:52:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17277' , '28' , '1' )
28/02/2023 12:30:37 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 (
'32' ,
'2023-FV000270' ,
'2023-02-28' ,
'' ,
'0' ,
'79' ,
'2686' ,
'CITTA\\\' DEL VATICANO 00120 CITTA\\\' DEL VATICANO' ,
'' ,
'' ,
'6.5' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'70.10' ,
'70.10' ,
NOW() ,
NOW() )
28/02/2023 12:30:37 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82056'
28/02/2023 12:30:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '82056'
28/02/2023 12:30:37 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '82056' , '3419' , 'DIARIO LA MISERICORDIA DIVINA - S. FAUSTINA K.' , '1' , '0' , '4' ,
'13.0000' , '13' , '0' , '30' , '9.10' )
28/02/2023 12:30:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '3419' AND id_supplier = '79'
28/02/2023 12:30:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3419' , '79' , '1' )
28/02/2023 12:30:37 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '82056' , '5889' , 'LITURGIA DELLE ORE - VOL. III - PER SACERDOTI E RELIGIOSI' , '1' , '0' , '4' ,
'35.0000' , '35' , '0' , '30' , '24.50' )
28/02/2023 12:30:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5889' AND id_supplier = '79'
28/02/2023 12:30:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5889' , '79' , '1' )
28/02/2023 12:30:37 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '82056' , '5888' , 'LITURGIA DELLE ORE - VOL. II - PER SACERDOTI E RELIGIOSI' , '1' , '0' , '4' ,
'35.0000' , '35' , '0' , '30' , '24.50' )
28/02/2023 12:30:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5888' AND id_supplier = '79'
28/02/2023 12:30:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5888' , '79' , '1' )
28/02/2023 12:30:37 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '82056' , '20774' , 'messaggio per la quaresima 2023' , '10' , '0' , '4' ,
'1.0000' , '1' , '0' , '45' , '5.50' )
28/02/2023 12:30:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20774' AND id_supplier = '79'
28/02/2023 12:30:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20774' , '79' , '1' )
28/02/2023 12:30:56 pm >> SELECT document_num FROM ps_document
WHERE document_num = '661' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-28')
28/02/2023 12:30:56 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' ,
'661' ,
'2023-02-28' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'4.75' ,
'4.75' ,
NOW() ,
NOW() )
28/02/2023 12:30:56 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82057'
28/02/2023 12:30:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '82057'
28/02/2023 12:30:56 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '82057' , '20592' , 'SULLA TUA PAROLA MAR/APR 23 - 515' , '1' , '-1' , '4' ,
'5.00' , '5' , '0' , '5' , '4.75' )
28/02/2023 02:16:01 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791280736185' AND id_product != '20785' AND ean13 != ''
28/02/2023 02:16:01 pm >> UPDATE ps_product SET
id_supplier = '',
reference = '1/3',
ean13 = '9791280736185',
date_upd = NOW()
WHERE id_product = '20785'
28/02/2023 02:16:01 pm >> UPDATE ps_product_lang SET
name = 'CARTA D\'IDENTITA\' DEL CREATO - R. LUPI',
description = 'Questo sussidio, sullo stile della “Carta d’identità”, ci aiuta, in modo semplice e sintetico, a conoscere il Creato: la nostra casa in cui viviamo e ci muoviamo. È anche uno strumento divulgativo per conoscere alcuni termini scientifici che riguardano il nostro pianeta Terra, affinché lo apprezziamo sempre di più e ci rendiamo conto di quanto siano importanti per noi la sua cura e il suo rispetto. Queste pagine quindi desiderano stimolarci a guardare intorno a noi e a farci cogliere dalla meraviglia e dallo stupore per la bellezza e per la perfezione che ci circondano; sono soprattutto un invito a scoprire la firma di Dio nella creazione per ringraziarlo e per lodarlo di questo grande dono.
'
WHERE id_product = '20785'
28/02/2023 02:16:01 pm >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '2.5'
WHERE id_product = '20785'
28/02/2023 02:16:01 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 = '41',
id_internal_category = '4',
on_sale = '0',
on_showcase = '1',
on_offer = '00',
on_most = '1',
date_upd = NOW()
WHERE id_product = '20785'
28/02/2023 02:16:01 pm >> DELETE FROM ps_specific_price WHERE id_product = '20785'
28/02/2023 02:16:01 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' , '20785' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' )
28/02/2023 02:41:41 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801029888' AND id_product != '2699' AND ean13 != ''
28/02/2023 02:41:41 pm >> UPDATE ps_product SET
id_supplier = '',
reference = '13/3',
ean13 = '9788801029888',
date_upd = NOW()
WHERE id_product = '2699'
28/02/2023 02:41:41 pm >> UPDATE ps_product_lang SET
name = 'CONTEMPLIAMO GESÙ RISORTO - VIA LUCIS',
description = ''
WHERE id_product = '2699'
28/02/2023 02:41:41 pm >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '1.2000'
WHERE id_product = '2699'
28/02/2023 02:41:41 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '1.2000',
id_tax_rules_group = '4',
id_category_default = '19',
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 = '2699'
28/02/2023 02:41:41 pm >> DELETE FROM ps_specific_price WHERE id_product = '2699'
28/02/2023 02:42:48 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788895983646' AND id_product != '16666' AND ean13 != ''
28/02/2023 02:42:48 pm >> UPDATE ps_product SET
id_supplier = '53',
reference = '13/3',
ean13 = '9788895983646',
date_upd = NOW()
WHERE id_product = '16666'
28/02/2023 02:42:48 pm >> UPDATE ps_product_lang SET
name = 'VIA LUCIS Dialogata per comunità parrocchiali',
description = 'La Via\r\nLucis è una celebrazione incentrata\r\nsulla risurrezione di Cristo e si presenta simmetrica alla Via crucis: quattordici stazioni, che vanno dal sepolcro vuoto\r\nalla discesa dello Spirito Santo. È un modo di esprimere nella preghiera\r\nla gioia\r\npasquale, mettendosi in cammino con Gesù Risorto. Questa Via\r\nLucis è molto breve ed essenziale. Ogni singola stazione è\r\nillustrata da una lettura biblica, dopo un momento di silenzio,\r\nfa seguito una preghiera litanica e il Gloria.
\r\n\r\n
Può\r\nessere utilizzata anche da persone singole,\r\nsoprattutto da malati e anziani che pregano.
'
WHERE id_product = '16666'
28/02/2023 02:42:48 pm >> UPDATE ps_product SET
wholesale_price = '0.32',
on_sale = '0',
price = '2.0000'
WHERE id_product = '16666'
28/02/2023 02:42:48 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.32',
price = '2.0000',
id_tax_rules_group = '4',
id_category_default = '395',
id_argoment_default = '28',
id_internal_category = '4',
on_sale = '0',
on_showcase = '1',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '16666'
28/02/2023 02:42:48 pm >> DELETE FROM ps_specific_price WHERE id_product = '16666'
28/02/2023 02:42:48 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' , '16666' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' )
28/02/2023 02:43:28 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788881661442' AND id_product != '17911' AND ean13 != ''
28/02/2023 02:43:28 pm >> UPDATE ps_product SET
id_supplier = '107',
reference = '13/3',
ean13 = '9788881661442',
date_upd = NOW()
WHERE id_product = '17911'
28/02/2023 02:43:28 pm >> UPDATE ps_product_lang SET
name = 'VIA LUCIS - E. D\'AGOSTINO',
description = ''
WHERE id_product = '17911'
28/02/2023 02:43:28 pm >> UPDATE ps_product SET
wholesale_price = '9.75',
on_sale = '0',
price = '15.0000'
WHERE id_product = '17911'
28/02/2023 02:43:28 pm >> UPDATE ps_product_shop SET
wholesale_price = '9.75',
price = '15.0000',
id_tax_rules_group = '4',
id_category_default = '225',
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 = '17911'
28/02/2023 02:43:28 pm >> DELETE FROM ps_specific_price WHERE id_product = '17911'
28/02/2023 02:45:39 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788810714270' AND id_product != '16177' AND ean13 != ''
28/02/2023 02:45:39 pm >> UPDATE ps_product SET
id_supplier = '109',
reference = '13/3',
ean13 = '9788810714270',
date_upd = NOW()
WHERE id_product = '16177'
28/02/2023 02:45:39 pm >> UPDATE ps_product_lang SET
name = 'ROSARIO PER I DEFUNTI',
description = ''
WHERE id_product = '16177'
28/02/2023 02:45:39 pm >> UPDATE ps_product SET
wholesale_price = '3.07',
on_sale = '0',
price = '4.5000'
WHERE id_product = '16177'
28/02/2023 02:45:39 pm >> UPDATE ps_product_shop SET
wholesale_price = '3.07',
price = '4.5000',
id_tax_rules_group = '4',
id_category_default = '9',
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 = '16177'
28/02/2023 02:45:39 pm >> DELETE FROM ps_specific_price WHERE id_product = '16177'
28/02/2023 02:48:36 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8032727872754' AND id_product != '7106' AND ean13 != ''
28/02/2023 02:48:36 pm >> UPDATE ps_product SET
id_supplier = '',
reference = '13/3',
ean13 = '8032727872754',
date_upd = NOW()
WHERE id_product = '7106'
28/02/2023 02:48:36 pm >> UPDATE ps_product_lang SET
name = 'NOVENA A SANT\'ANTONIO ',
description = ''
WHERE id_product = '7106'
28/02/2023 02:48:36 pm >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '1.7308'
WHERE id_product = '7106'
28/02/2023 02:48:36 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '1.7308',
id_tax_rules_group = '3',
id_category_default = '142',
id_argoment_default = '150',
id_internal_category = '',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '7106'
28/02/2023 02:48:36 pm >> DELETE FROM ps_specific_price WHERE id_product = '7106'
28/02/2023 02:50:47 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788872982907' AND id_product != '17440' AND ean13 != ''
28/02/2023 02:50:47 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '13/4',
ean13 = '9788872982907',
date_upd = NOW()
WHERE id_product = '17440'
28/02/2023 02:50:47 pm >> UPDATE ps_product_lang SET
name = 'ROSARIO CON I SERMONI DI SAN VINCENZO FERRER',
description = ''
WHERE id_product = '17440'
28/02/2023 02:50:47 pm >> UPDATE ps_product SET
wholesale_price = '3.50',
on_sale = '0',
price = '5.0000'
WHERE id_product = '17440'
28/02/2023 02:50:47 pm >> UPDATE ps_product_shop SET
wholesale_price = '3.50',
price = '5.0000',
id_tax_rules_group = '4',
id_category_default = '29',
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 = '17440'
28/02/2023 02:50:47 pm >> DELETE FROM ps_specific_price WHERE id_product = '17440'
28/02/2023 02:51:40 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831544740' AND id_product != '10757' AND ean13 != ''
28/02/2023 02:51:40 pm >> UPDATE ps_product SET
id_supplier = '',
reference = '13/3',
ean13 = '9788831544740',
date_upd = NOW()
WHERE id_product = '10757'
28/02/2023 02:51:40 pm >> UPDATE ps_product_lang SET
name = 'TU SEI AMORE E VITA - R. LUPI',
description = ''
WHERE id_product = '10757'
28/02/2023 02:51:40 pm >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '4.5000'
WHERE id_product = '10757'
28/02/2023 02:51:40 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '4.5000',
id_tax_rules_group = '4',
id_category_default = '27',
id_argoment_default = '150',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '10757'
28/02/2023 02:51:40 pm >> DELETE FROM ps_specific_price WHERE id_product = '10757'
28/02/2023 02:52:55 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788864096551' AND id_product != '17775' AND ean13 != ''
28/02/2023 02:52:55 pm >> UPDATE ps_product SET
id_supplier = '109',
reference = '13/3',
ean13 = '9788864096551',
date_upd = NOW()
WHERE id_product = '17775'
28/02/2023 02:52:55 pm >> UPDATE ps_product_lang SET
name = 'PREGARE IN LATINO E ITALIANO',
description = ''
WHERE id_product = '17775'
28/02/2023 02:52:55 pm >> UPDATE ps_product SET
wholesale_price = '9.80',
on_sale = '0',
price = '14.0000'
WHERE id_product = '17775'
28/02/2023 02:52:55 pm >> UPDATE ps_product_shop SET
wholesale_price = '9.80',
price = '14.0000',
id_tax_rules_group = '4',
id_category_default = '100',
id_argoment_default = '10',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '17775'
28/02/2023 02:52:55 pm >> DELETE FROM ps_specific_price WHERE id_product = '17775'
28/02/2023 02:58:23 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788894876918' AND id_product != '18180' AND ean13 != ''
28/02/2023 02:58:23 pm >> UPDATE ps_product SET
id_supplier = '107',
reference = '13/3',
ean13 = '9788894876918',
date_upd = NOW()
WHERE id_product = '18180'
28/02/2023 02:58:23 pm >> UPDATE ps_product_lang SET
name = 'LITANIE DI SAN GIUSEPPE - PIO DELLA VALENTINA',
description = ''
WHERE id_product = '18180'
28/02/2023 02:58:23 pm >> UPDATE ps_product SET
wholesale_price = '6.50',
on_sale = '0',
price = '10.0000'
WHERE id_product = '18180'
28/02/2023 02:58:23 pm >> UPDATE ps_product_shop SET
wholesale_price = '6.50',
price = '10.0000',
id_tax_rules_group = '4',
id_category_default = '174',
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 = '18180'
28/02/2023 02:58:23 pm >> DELETE FROM ps_specific_price WHERE id_product = '18180'
28/02/2023 02:58:46 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884244239' AND id_product != '12601' AND ean13 != ''
28/02/2023 02:58:46 pm >> UPDATE ps_product SET
id_supplier = '65',
reference = '13/3',
ean13 = '9788884244239',
date_upd = NOW()
WHERE id_product = '12601'
28/02/2023 02:58:46 pm >> UPDATE ps_product_lang SET
name = 'CONSACRAZIONE A MARIA ',
description = ''
WHERE id_product = '12601'
28/02/2023 02:58:46 pm >> UPDATE ps_product SET
wholesale_price = '4.55',
on_sale = '0',
price = '7.0000'
WHERE id_product = '12601'
28/02/2023 02:58:46 pm >> UPDATE ps_product_shop SET
wholesale_price = '4.55',
price = '7.0000',
id_tax_rules_group = '4',
id_category_default = '83',
id_argoment_default = '23',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '12601'
28/02/2023 02:58:46 pm >> DELETE FROM ps_specific_price WHERE id_product = '12601'
28/02/2023 02:59:08 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791280210180' AND id_product != '19166' AND ean13 != ''
28/02/2023 02:59:08 pm >> UPDATE ps_product SET
id_supplier = '47',
reference = '13/3',
ean13 = '9791280210180',
date_upd = NOW()
WHERE id_product = '19166'
28/02/2023 02:59:09 pm >> UPDATE ps_product_lang SET
name = 'SANTO ANGELO CUSTODE - B. DENTE',
description = ''
WHERE id_product = '19166'
28/02/2023 02:59:09 pm >> UPDATE ps_product SET
wholesale_price = '4.90',
on_sale = '0',
price = '7.0000'
WHERE id_product = '19166'
28/02/2023 02:59:09 pm >> UPDATE ps_product_shop SET
wholesale_price = '4.90',
price = '7.0000',
id_tax_rules_group = '4',
id_category_default = '99',
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 = '19166'
28/02/2023 02:59:09 pm >> DELETE FROM ps_specific_price WHERE id_product = '19166'
28/02/2023 03:00:36 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831552776' AND id_product != '18712' AND ean13 != ''
28/02/2023 03:00:36 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = 'ESPOSITORE s. paolo',
ean13 = '9788831552776',
date_upd = NOW()
WHERE id_product = '18712'
28/02/2023 03:00:36 pm >> UPDATE ps_product_lang SET
name = 'NELLA FEDE IO VIVRO\'',
description = ''
WHERE id_product = '18712'
28/02/2023 03:00:36 pm >> UPDATE ps_product SET
wholesale_price = '2.01',
on_sale = '0',
price = '3.0000'
WHERE id_product = '18712'
28/02/2023 03:00:36 pm >> UPDATE ps_product_shop SET
wholesale_price = '2.01',
price = '3.0000',
id_tax_rules_group = '4',
id_category_default = '27',
id_argoment_default = '23',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '18712'
28/02/2023 03:00:36 pm >> DELETE FROM ps_specific_price WHERE id_product = '18712'
28/02/2023 03:00:55 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801058123' AND id_product != '9157' AND ean13 != ''
28/02/2023 03:00:55 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '13/3',
ean13 = '9788801058123',
date_upd = NOW()
WHERE id_product = '9157'
28/02/2023 03:00:55 pm >> UPDATE ps_product_lang SET
name = 'ROSARIO MEDITATO SUL S. CUORE DI GESÙ - M. RATTA',
description = ''
WHERE id_product = '9157'
28/02/2023 03:00:55 pm >> UPDATE ps_product SET
wholesale_price = '1.24',
on_sale = '0',
price = '1.9000'
WHERE id_product = '9157'
28/02/2023 03:00:55 pm >> UPDATE ps_product_shop SET
wholesale_price = '1.24',
price = '1.9000',
id_tax_rules_group = '4',
id_category_default = '19',
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 = '9157'
28/02/2023 03:00:55 pm >> DELETE FROM ps_specific_price WHERE id_product = '9157'
28/02/2023 03:04:17 pm >> SELECT document_num FROM ps_document
WHERE document_num = '662' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-28')
28/02/2023 03:04:17 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' ,
'662' ,
'2023-02-28' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'4.75' ,
'4.75' ,
NOW() ,
NOW() )
28/02/2023 03:04:17 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 = '82058'
28/02/2023 03:04:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '82058'
28/02/2023 03:04:17 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '82058' , '20592' , 'SULLA TUA PAROLA MAR/APR 23 - 515' , '1' , '-1' , '4' ,
'5.00' , '5' , '0' , '5' , '4.75' )
28/02/2023 03:05:52 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892217355' AND id_product != '16898' AND ean13 != ''
28/02/2023 03:05:52 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '13/3',
ean13 = '9788892217355',
date_upd = NOW()
WHERE id_product = '16898'
28/02/2023 03:05:52 pm >> UPDATE ps_product_lang SET
name = 'PREGHIERE E DEVOZIONI - FATIMA',
description = ''
WHERE id_product = '16898'
28/02/2023 03:05:52 pm >> UPDATE ps_product SET
wholesale_price = '1.34',
on_sale = '0',
price = '2.0000'
WHERE id_product = '16898'
28/02/2023 03:05:52 pm >> UPDATE ps_product_shop SET
wholesale_price = '1.34',
price = '2.0000',
id_tax_rules_group = '4',
id_category_default = '30',
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 = '16898'
28/02/2023 03:05:52 pm >> DELETE FROM ps_specific_price WHERE id_product = '16898'
28/02/2023 03:06:37 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788867571949' AND id_product != '20317' AND ean13 != ''
28/02/2023 03:06:37 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '13/3',
ean13 = '9788867571949',
date_upd = NOW()
WHERE id_product = '20317'
28/02/2023 03:06:37 pm >> UPDATE ps_product_lang SET
name = 'PREGHIERE TRADIZIONALI',
description = ''
WHERE id_product = '20317'
28/02/2023 03:06:37 pm >> UPDATE ps_product SET
wholesale_price = '2.45',
on_sale = '0',
price = '3.5000'
WHERE id_product = '20317'
28/02/2023 03:06:37 pm >> UPDATE ps_product_shop SET
wholesale_price = '2.45',
price = '3.5000',
id_tax_rules_group = '4',
id_category_default = '51',
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 = '20317'
28/02/2023 03:06:37 pm >> DELETE FROM ps_specific_price WHERE id_product = '20317'
28/02/2023 03:08:12 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892214347' AND id_product != '13672' AND ean13 != ''
28/02/2023 03:08:12 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '13/3',
ean13 = '9788892214347',
date_upd = NOW()
WHERE id_product = '13672'
28/02/2023 03:08:12 pm >> UPDATE ps_product_lang SET
name = '100 PREGHIERE AI SANTI PROTETTORI',
description = ''
WHERE id_product = '13672'
28/02/2023 03:08:12 pm >> UPDATE ps_product SET
wholesale_price = '6.70',
on_sale = '0',
price = '10.0000'
WHERE id_product = '13672'
28/02/2023 03:08:12 pm >> UPDATE ps_product_shop SET
wholesale_price = '6.70',
price = '10.0000',
id_tax_rules_group = '4',
id_category_default = '30',
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 = '13672'
28/02/2023 03:08:12 pm >> DELETE FROM ps_specific_price WHERE id_product = '13672'
28/02/2023 03:09:07 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791280210272' AND id_product != '20580' AND ean13 != ''
28/02/2023 03:09:07 pm >> UPDATE ps_product SET
id_supplier = '47',
reference = '13/3',
ean13 = '9791280210272',
date_upd = NOW()
WHERE id_product = '20580'
28/02/2023 03:09:07 pm >> UPDATE ps_product_lang SET
name = 'PREGHIERE DI GUARIGIONE NELLA MALATTIA',
description = ''
WHERE id_product = '20580'
28/02/2023 03:09:07 pm >> UPDATE ps_product SET
wholesale_price = '9.10',
on_sale = '0',
price = '13.0000'
WHERE id_product = '20580'
28/02/2023 03:09:07 pm >> UPDATE ps_product_shop SET
wholesale_price = '9.10',
price = '13.0000',
id_tax_rules_group = '4',
id_category_default = '99',
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 = '20580'
28/02/2023 03:09:07 pm >> DELETE FROM ps_specific_price WHERE id_product = '20580'
28/02/2023 03:09:36 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791280210197' AND id_product != '19384' AND ean13 != ''
28/02/2023 03:09:36 pm >> UPDATE ps_product SET
id_supplier = '47',
reference = '13/3',
ean13 = '9791280210197',
date_upd = NOW()
WHERE id_product = '19384'
28/02/2023 03:09:36 pm >> UPDATE ps_product_lang SET
name = 'PREGHIERE DI GUARiGIONE',
description = ''
WHERE id_product = '19384'
28/02/2023 03:09:36 pm >> UPDATE ps_product SET
wholesale_price = '8.40',
on_sale = '0',
price = '12.0000'
WHERE id_product = '19384'
28/02/2023 03:09:36 pm >> UPDATE ps_product_shop SET
wholesale_price = '8.40',
price = '12.0000',
id_tax_rules_group = '4',
id_category_default = '99',
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 = '19384'
28/02/2023 03:09:36 pm >> DELETE FROM ps_specific_price WHERE id_product = '19384'
28/02/2023 03:10:23 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788873576228' AND id_product != '13519' AND ean13 != ''
28/02/2023 03:10:23 pm >> UPDATE ps_product SET
id_supplier = '65',
reference = '13/3',
ean13 = '9788873576228',
date_upd = NOW()
WHERE id_product = '13519'
28/02/2023 03:10:23 pm >> UPDATE ps_product_lang SET
name = 'A.B.C. DELLA PREGHIERA - F. FORNOS',
description = ''
WHERE id_product = '13519'
28/02/2023 03:10:23 pm >> UPDATE ps_product SET
wholesale_price = '9.10',
on_sale = '0',
price = '14.0000'
WHERE id_product = '13519'
28/02/2023 03:10:23 pm >> UPDATE ps_product_shop SET
wholesale_price = '9.10',
price = '14.0000',
id_tax_rules_group = '4',
id_category_default = '178',
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 = '13519'
28/02/2023 03:10:23 pm >> DELETE FROM ps_specific_price WHERE id_product = '13519'
28/02/2023 03:10:37 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788872636039' AND id_product != '16146' AND ean13 != ''
28/02/2023 03:10:37 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '13/3',
ean13 = '9788872636039',
date_upd = NOW()
WHERE id_product = '16146'
28/02/2023 03:10:37 pm >> UPDATE ps_product_lang SET
name = 'MISTERIOSO INCANTO - N. GIORDANO',
description = ''
WHERE id_product = '16146'
28/02/2023 03:10:37 pm >> UPDATE ps_product SET
wholesale_price = '4.20',
on_sale = '0',
price = '6.0000'
WHERE id_product = '16146'
28/02/2023 03:10:37 pm >> UPDATE ps_product_shop SET
wholesale_price = '4.20',
price = '6.0000',
id_tax_rules_group = '4',
id_category_default = '279',
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 = '16146'
28/02/2023 03:10:37 pm >> DELETE FROM ps_specific_price WHERE id_product = '16146'
28/02/2023 03:11:22 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788897420910' AND id_product != '8368' AND ean13 != ''
28/02/2023 03:11:22 pm >> UPDATE ps_product SET
id_supplier = '47',
reference = '13/3',
ean13 = '9788897420910',
date_upd = NOW()
WHERE id_product = '8368'
28/02/2023 03:11:22 pm >> UPDATE ps_product_lang SET
name = 'PREGHIERE DI LIBERAZIONE - DIVINA MISERICORDIA',
description = ''
WHERE id_product = '8368'
28/02/2023 03:11:22 pm >> UPDATE ps_product SET
wholesale_price = '1.05',
on_sale = '0',
price = '1.5000'
WHERE id_product = '8368'
28/02/2023 03:11:22 pm >> UPDATE ps_product_shop SET
wholesale_price = '1.05',
price = '1.5000',
id_tax_rules_group = '4',
id_category_default = '99',
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 = '8368'
28/02/2023 03:11:22 pm >> DELETE FROM ps_specific_price WHERE id_product = '8368'
28/02/2023 03:12:04 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788897420941' AND id_product != '9586' AND ean13 != ''
28/02/2023 03:12:04 pm >> UPDATE ps_product SET
id_supplier = '47',
reference = '13/3',
ean13 = '9788897420941',
date_upd = NOW()
WHERE id_product = '9586'
28/02/2023 03:12:04 pm >> UPDATE ps_product_lang SET
name = 'SANTA MESSA - CATALINA RIVAS',
description = ''
WHERE id_product = '9586'
28/02/2023 03:12:04 pm >> UPDATE ps_product SET
wholesale_price = '0.98',
on_sale = '0',
price = '1.4000'
WHERE id_product = '9586'
28/02/2023 03:12:04 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.98',
price = '1.4000',
id_tax_rules_group = '4',
id_category_default = '99',
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 = '9586'
28/02/2023 03:12:04 pm >> DELETE FROM ps_specific_price WHERE id_product = '9586'
28/02/2023 03:12:15 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791280210159' AND id_product != '19323' AND ean13 != ''
28/02/2023 03:12:15 pm >> UPDATE ps_product SET
id_supplier = '47',
reference = '13/3',
ean13 = '9791280210159',
date_upd = NOW()
WHERE id_product = '19323'
28/02/2023 03:12:15 pm >> UPDATE ps_product_lang SET
name = 'PREGHIERE DI SANTA BRIGIDA',
description = ''
WHERE id_product = '19323'
28/02/2023 03:12:15 pm >> UPDATE ps_product SET
wholesale_price = '0.49',
on_sale = '0',
price = '0.7000'
WHERE id_product = '19323'
28/02/2023 03:12:15 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.49',
price = '0.7000',
id_tax_rules_group = '4',
id_category_default = '99',
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 = '19323'
28/02/2023 03:12:15 pm >> DELETE FROM ps_specific_price WHERE id_product = '19323'
28/02/2023 03:12:50 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884246615' AND id_product != '18812' AND ean13 != ''
28/02/2023 03:12:50 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '13/3',
ean13 = '9788884246615',
date_upd = NOW()
WHERE id_product = '18812'
28/02/2023 03:12:50 pm >> UPDATE ps_product_lang SET
name = 'ANGELI NELLA BIBBIA',
description = ''
WHERE id_product = '18812'
28/02/2023 03:12:50 pm >> UPDATE ps_product SET
wholesale_price = '4.90',
on_sale = '0',
price = '7.0000'
WHERE id_product = '18812'
28/02/2023 03:12:50 pm >> UPDATE ps_product_shop SET
wholesale_price = '4.90',
price = '7.0000',
id_tax_rules_group = '4',
id_category_default = '83',
id_argoment_default = '188',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '18812'
28/02/2023 03:12:50 pm >> DELETE FROM ps_specific_price WHERE id_product = '18812'
28/02/2023 03:13:54 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884244062' AND id_product != '10794' AND ean13 != ''
28/02/2023 03:13:54 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '13/3',
ean13 = '9788884244062',
date_upd = NOW()
WHERE id_product = '10794'
28/02/2023 03:13:54 pm >> UPDATE ps_product_lang SET
name = 'TUTTI I SALMI A CARATTERI GRANDI',
description = ''
WHERE id_product = '10794'
28/02/2023 03:13:54 pm >> UPDATE ps_product SET
wholesale_price = '4.90',
on_sale = '0',
price = '7.0000'
WHERE id_product = '10794'
28/02/2023 03:13:54 pm >> UPDATE ps_product_shop SET
wholesale_price = '4.90',
price = '7.0000',
id_tax_rules_group = '4',
id_category_default = '83',
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 = '10794'
28/02/2023 03:13:54 pm >> DELETE FROM ps_specific_price WHERE id_product = '10794'
28/02/2023 03:14:04 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884245861' AND id_product != '16846' AND ean13 != ''
28/02/2023 03:14:04 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '13/3',
ean13 = '9788884245861',
date_upd = NOW()
WHERE id_product = '16846'
28/02/2023 03:14:04 pm >> UPDATE ps_product_lang SET
name = 'PASSIONE DI GESU\' - DA ISAIA AI VANGELI',
description = ''
WHERE id_product = '16846'
28/02/2023 03:14:04 pm >> UPDATE ps_product SET
wholesale_price = '4.90',
on_sale = '0',
price = '7.0000'
WHERE id_product = '16846'
28/02/2023 03:14:04 pm >> UPDATE ps_product_shop SET
wholesale_price = '4.90',
price = '7.0000',
id_tax_rules_group = '4',
id_category_default = '83',
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 = '16846'
28/02/2023 03:14:04 pm >> DELETE FROM ps_specific_price WHERE id_product = '16846'
28/02/2023 03:14:18 pm >> UPDATE ps_product_shop SET
minimal_quantity = '1',
multiple_quantity = '1',
available_date = '',
date_upd = NOW()
WHERE id_product = '12601'
28/02/2023 03:14:18 pm >> UPDATE ps_stock_available SET quantity = quantity + '-1' WHERE id_product = '12601'
28/02/2023 03:14:41 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788888609881' AND id_product != '10525' AND ean13 != ''
28/02/2023 03:14:41 pm >> UPDATE ps_product SET
id_supplier = '47',
reference = '13/3',
ean13 = '9788888609881',
date_upd = NOW()
WHERE id_product = '10525'
28/02/2023 03:14:41 pm >> UPDATE ps_product_lang SET
name = 'TEMPO DI LIBERAZIONE',
description = ''
WHERE id_product = '10525'
28/02/2023 03:14:41 pm >> UPDATE ps_product SET
wholesale_price = '8.40',
on_sale = '0',
price = '12.0000'
WHERE id_product = '10525'
28/02/2023 03:14:41 pm >> UPDATE ps_product_shop SET
wholesale_price = '8.40',
price = '12.0000',
id_tax_rules_group = '4',
id_category_default = '99',
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 = '10525'
28/02/2023 03:14:41 pm >> DELETE FROM ps_specific_price WHERE id_product = '10525'
28/02/2023 03:15:13 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788863662573' AND id_product != '12564' AND ean13 != ''
28/02/2023 03:15:13 pm >> UPDATE ps_product SET
id_supplier = '47',
reference = '13/3',
ean13 = '9788863662573',
date_upd = NOW()
WHERE id_product = '12564'
28/02/2023 03:15:13 pm >> UPDATE ps_product_lang SET
name = 'PIU\' BELLE PREGHIERE IN LATINO',
description = ''
WHERE id_product = '12564'
28/02/2023 03:15:13 pm >> UPDATE ps_product SET
wholesale_price = '11.20',
on_sale = '0',
price = '16.0000'
WHERE id_product = '12564'
28/02/2023 03:15:13 pm >> UPDATE ps_product_shop SET
wholesale_price = '11.20',
price = '16.0000',
id_tax_rules_group = '4',
id_category_default = '24',
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 = '12564'
28/02/2023 03:15:13 pm >> DELETE FROM ps_specific_price WHERE id_product = '12564'
28/02/2023 03:16:30 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788861385221' AND id_product != '8271' AND ean13 != ''
28/02/2023 03:16:30 pm >> UPDATE ps_product SET
id_supplier = '',
reference = '13/3',
ean13 = '9788861385221',
date_upd = NOW()
WHERE id_product = '8271'
28/02/2023 03:16:30 pm >> UPDATE ps_product_lang SET
name = 'PREGHIERA DEI CRISTIANI AI SANTI ANGELI - STANZIONE MARCELLO',
description = ''
WHERE id_product = '8271'
28/02/2023 03:16:30 pm >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '25.0000'
WHERE id_product = '8271'
28/02/2023 03:16:30 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '25.0000',
id_tax_rules_group = '4',
id_category_default = '47',
id_argoment_default = '28',
id_internal_category = '',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '8271'
28/02/2023 03:16:30 pm >> DELETE FROM ps_specific_price WHERE id_product = '8271'
28/02/2023 03:16:42 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788862407748' AND id_product != '17116' AND ean13 != ''
28/02/2023 03:16:42 pm >> UPDATE ps_product SET
id_supplier = '109',
reference = '13/3',
ean13 = '9788862407748',
date_upd = NOW()
WHERE id_product = '17116'
28/02/2023 03:16:42 pm >> UPDATE ps_product_lang SET
name = 'LIBRO DELLE PREGHIERE CHE GUARISCONO',
description = ''
WHERE id_product = '17116'
28/02/2023 03:16:42 pm >> UPDATE ps_product SET
wholesale_price = '12.29',
on_sale = '0',
price = '18.9000'
WHERE id_product = '17116'
28/02/2023 03:16:42 pm >> UPDATE ps_product_shop SET
wholesale_price = '12.29',
price = '18.9000',
id_tax_rules_group = '4',
id_category_default = '259',
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 = '17116'
28/02/2023 03:16:42 pm >> DELETE FROM ps_specific_price WHERE id_product = '17116'
28/02/2023 03:21:47 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788810714195' AND id_product != '6086' AND ean13 != ''
28/02/2023 03:21:47 pm >> UPDATE ps_product SET
id_supplier = '109',
reference = '13/4',
ean13 = '9788810714195',
date_upd = NOW()
WHERE id_product = '6086'
28/02/2023 03:21:48 pm >> UPDATE ps_product_lang SET
name = 'MADRE DI MISERICORDIA - M.PAPPALARDO',
description = ''
WHERE id_product = '6086'
28/02/2023 03:21:48 pm >> UPDATE ps_product SET
wholesale_price = '2.30',
on_sale = '0',
price = '3.5000'
WHERE id_product = '6086'
28/02/2023 03:21:48 pm >> UPDATE ps_product_shop SET
wholesale_price = '2.30',
price = '3.5000',
id_tax_rules_group = '4',
id_category_default = '9',
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 = '6086'
28/02/2023 03:21:48 pm >> DELETE FROM ps_specific_price WHERE id_product = '6086'
28/02/2023 03:22:11 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788895983660' AND id_product != '16997' AND ean13 != ''
28/02/2023 03:22:11 pm >> UPDATE ps_product SET
id_supplier = '53',
reference = '13/4',
ean13 = '9788895983660',
date_upd = NOW()
WHERE id_product = '16997'
28/02/2023 03:22:11 pm >> UPDATE ps_product_lang SET
name = 'PREGHIAMO IL PADRONE DELLA MESSE ',
description = 'Questo opuscolo offre uno schema per pregare i misteri del rosario chiedendo al Signore il dono delle vocazioni sacerdotali e religiose, è un sussidio semplice che può essere usato da parrocchie, gruppi di preghiera e comunità religiose. Ogni vocazione è un dono che viene dall\'alto e pertanto va invocato umilmente e incessantemente.
Formato 17X11
pagine 34
'
WHERE id_product = '16997'
28/02/2023 03:22:11 pm >> UPDATE ps_product SET
wholesale_price = '1.00',
on_sale = '0',
price = '2.5000'
WHERE id_product = '16997'
28/02/2023 03:22:11 pm >> UPDATE ps_product_shop SET
wholesale_price = '1.00',
price = '2.5000',
id_tax_rules_group = '4',
id_category_default = '395',
id_argoment_default = '28',
id_internal_category = '4',
on_sale = '0',
on_showcase = '1',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '16997'
28/02/2023 03:22:11 pm >> DELETE FROM ps_specific_price WHERE id_product = '16997'
28/02/2023 03:22:11 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' , '16997' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' )
28/02/2023 03:23:26 pm >> UPDATE ps_product_shop SET
minimal_quantity = '1',
multiple_quantity = '1',
available_date = '',
date_upd = NOW()
WHERE id_product = '15344'
28/02/2023 03:23:26 pm >> UPDATE ps_stock_available SET quantity = quantity + '-1' WHERE id_product = '15344'
28/02/2023 03:27:01 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788896199169' AND id_product != '978' AND ean13 != ''
28/02/2023 03:27:02 pm >> UPDATE ps_product SET
id_supplier = '47',
reference = '13/4',
ean13 = '9788896199169',
date_upd = NOW()
WHERE id_product = '978'
28/02/2023 03:27:02 pm >> UPDATE ps_product_lang SET
name = 'BEATA VERGINE MARIA CHE SCIOGLIE I NODI - ALBERO GENEALOGICO',
description = ''
WHERE id_product = '978'
28/02/2023 03:27:02 pm >> UPDATE ps_product SET
wholesale_price = '1.54',
on_sale = '0',
price = '2.2000'
WHERE id_product = '978'
28/02/2023 03:27:02 pm >> UPDATE ps_product_shop SET
wholesale_price = '1.54',
price = '2.2000',
id_tax_rules_group = '4',
id_category_default = '197',
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 = '978'
28/02/2023 03:27:02 pm >> DELETE FROM ps_specific_price WHERE id_product = '978'
28/02/2023 03:28:59 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788873672685' AND id_product != '17670' AND ean13 != ''
28/02/2023 03:28:59 pm >> UPDATE ps_product SET
id_supplier = '107',
reference = '13/4',
ean13 = '9788873672685',
date_upd = NOW()
WHERE id_product = '17670'
28/02/2023 03:28:59 pm >> UPDATE ps_product_lang SET
name = 'NOVENA ALLA BEATA VERGINE ',
description = ''
WHERE id_product = '17670'
28/02/2023 03:28:59 pm >> UPDATE ps_product SET
wholesale_price = '1.95',
on_sale = '0',
price = '3.0000'
WHERE id_product = '17670'
28/02/2023 03:28:59 pm >> UPDATE ps_product_shop SET
wholesale_price = '1.95',
price = '3.0000',
id_tax_rules_group = '4',
id_category_default = '380',
id_argoment_default = '150',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '17670'
28/02/2023 03:28:59 pm >> DELETE FROM ps_specific_price WHERE id_product = '17670'
28/02/2023 03:30:13 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831555647' AND id_product != '20760' AND ean13 != ''
28/02/2023 03:30:13 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '13/4',
ean13 = '9788831555647',
date_upd = NOW()
WHERE id_product = '20760'
28/02/2023 03:30:13 pm >> UPDATE ps_product_lang SET
name = 'SAPEVO SOLO IL ROSARIO',
description = ''
WHERE id_product = '20760'
28/02/2023 03:30:13 pm >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '6.0000'
WHERE id_product = '20760'
28/02/2023 03:30:13 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '6.0000',
id_tax_rules_group = '4',
id_category_default = '27',
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 = '20760'
28/02/2023 03:30:13 pm >> DELETE FROM ps_specific_price WHERE id_product = '20760'
28/02/2023 03:30:25 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791280736086' AND id_product != '19728' AND ean13 != ''
28/02/2023 03:30:25 pm >> UPDATE ps_product SET
id_supplier = '145',
reference = '13/4',
ean13 = '9791280736086',
date_upd = NOW()
WHERE id_product = '19728'
28/02/2023 03:30:25 pm >> UPDATE ps_product_lang SET
name = 'MOSTRATI MADRE - V. SALVOLDI',
description = 'Il libretto, insieme ad una guida per pregare il Rosario, propone per ogni mistero un’interessante e profonda meditazione di DonValentino Salvoldi che si trasforma in dialogo-preghiera intimo e fiducioso con Maria, nostra Madre.
'
WHERE id_product = '19728'
28/02/2023 03:30:25 pm >> UPDATE ps_product SET
wholesale_price = '1.10',
on_sale = '0',
price = '4.5000'
WHERE id_product = '19728'
28/02/2023 03:30:25 pm >> UPDATE ps_product_shop SET
wholesale_price = '1.10',
price = '4.5000',
id_tax_rules_group = '4',
id_category_default = '395',
id_argoment_default = '28',
id_internal_category = '4',
on_sale = '0',
on_showcase = '1',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '19728'
28/02/2023 03:30:25 pm >> DELETE FROM ps_specific_price WHERE id_product = '19728'
28/02/2023 03:30:25 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' , '19728' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' )
28/02/2023 03:31:04 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892220829' AND id_product != '16620' AND ean13 != ''
28/02/2023 03:31:04 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '13/4',
ean13 = '9788892220829',
date_upd = NOW()
WHERE id_product = '16620'
28/02/2023 03:31:04 pm >> UPDATE ps_product_lang SET
name = 'ROSARIO DI LOURDES',
description = ''
WHERE id_product = '16620'
28/02/2023 03:31:04 pm >> UPDATE ps_product SET
wholesale_price = '3.28',
on_sale = '0',
price = '4.9000'
WHERE id_product = '16620'
28/02/2023 03:31:04 pm >> UPDATE ps_product_shop SET
wholesale_price = '3.28',
price = '4.9000',
id_tax_rules_group = '4',
id_category_default = '30',
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 = '16620'
28/02/2023 03:31:04 pm >> DELETE FROM ps_specific_price WHERE id_product = '16620'
28/02/2023 03:31:53 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892226012' AND id_product != '18488' AND ean13 != ''
28/02/2023 03:31:54 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '13/4',
ean13 = '9788892226012',
date_upd = NOW()
WHERE id_product = '18488'
28/02/2023 03:31:54 pm >> UPDATE ps_product_lang SET
name = 'O VERGINE IMMACOLATA - P. N. VENTRIGLIA',
description = ''
WHERE id_product = '18488'
28/02/2023 03:31:54 pm >> UPDATE ps_product SET
wholesale_price = '4.62',
on_sale = '0',
price = '6.9000'
WHERE id_product = '18488'
28/02/2023 03:31:54 pm >> UPDATE ps_product_shop SET
wholesale_price = '4.62',
price = '6.9000',
id_tax_rules_group = '4',
id_category_default = '30',
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 = '18488'
28/02/2023 03:31:54 pm >> DELETE FROM ps_specific_price WHERE id_product = '18488'
28/02/2023 03:32:31 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788869293634' AND id_product != '15522' AND ean13 != ''
28/02/2023 03:32:31 pm >> UPDATE ps_product SET
id_supplier = '109',
reference = '13/4',
ean13 = '9788869293634',
date_upd = NOW()
WHERE id_product = '15522'
28/02/2023 03:32:31 pm >> UPDATE ps_product_lang SET
name = 'ROSARIO MEDITATO - G. MARINI',
description = ''
WHERE id_product = '15522'
28/02/2023 03:32:31 pm >> UPDATE ps_product SET
wholesale_price = '1.95',
on_sale = '0',
price = '3.0000'
WHERE id_product = '15522'
28/02/2023 03:32:31 pm >> UPDATE ps_product_shop SET
wholesale_price = '1.95',
price = '3.0000',
id_tax_rules_group = '4',
id_category_default = '45',
id_argoment_default = '10',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '15522'
28/02/2023 03:32:31 pm >> DELETE FROM ps_specific_price WHERE id_product = '15522'
28/02/2023 03:33:33 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892224896' AND id_product != '18057' AND ean13 != ''
28/02/2023 03:33:33 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '13/4',
ean13 = '9788892224896',
date_upd = NOW()
WHERE id_product = '18057'
28/02/2023 03:33:33 pm >> UPDATE ps_product_lang SET
name = 'ROSARIO CON PAPA FRANCESCO',
description = ''
WHERE id_product = '18057'
28/02/2023 03:33:33 pm >> UPDATE ps_product SET
wholesale_price = '3.28',
on_sale = '0',
price = '4.9000'
WHERE id_product = '18057'
28/02/2023 03:33:33 pm >> UPDATE ps_product_shop SET
wholesale_price = '3.28',
price = '4.9000',
id_tax_rules_group = '4',
id_category_default = '30',
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 = '18057'
28/02/2023 03:33:33 pm >> DELETE FROM ps_specific_price WHERE id_product = '18057'
28/02/2023 03:34:05 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831554831' AND id_product != '19487' AND ean13 != ''
28/02/2023 03:34:05 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '13/4',
ean13 = '9788831554831',
date_upd = NOW()
WHERE id_product = '19487'
28/02/2023 03:34:05 pm >> UPDATE ps_product_lang SET
name = 'ROSARIO - R. LUPI',
description = ''
WHERE id_product = '19487'
28/02/2023 03:34:05 pm >> UPDATE ps_product SET
wholesale_price = '2.01',
on_sale = '0',
price = '3.0000'
WHERE id_product = '19487'
28/02/2023 03:34:05 pm >> UPDATE ps_product_shop SET
wholesale_price = '2.01',
price = '3.0000',
id_tax_rules_group = '4',
id_category_default = '27',
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 = '19487'
28/02/2023 03:34:05 pm >> DELETE FROM ps_specific_price WHERE id_product = '19487'
28/02/2023 03:34:22 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788870948912' AND id_product != '9067' AND ean13 != ''
28/02/2023 03:34:22 pm >> UPDATE ps_product SET
id_supplier = '',
reference = '13/4',
ean13 = '9788870948912',
date_upd = NOW()
WHERE id_product = '9067'
28/02/2023 03:34:22 pm >> UPDATE ps_product_lang SET
name = 'ROSARIO - R.BARILE',
description = ''
WHERE id_product = '9067'
28/02/2023 03:34:22 pm >> UPDATE ps_product SET
wholesale_price = '3.90',
on_sale = '0',
price = '6.0000'
WHERE id_product = '9067'
28/02/2023 03:34:22 pm >> UPDATE ps_product_shop SET
wholesale_price = '3.90',
price = '6.0000',
id_tax_rules_group = '4',
id_category_default = '77',
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 = '9067'
28/02/2023 03:34:22 pm >> DELETE FROM ps_specific_price WHERE id_product = '9067'
28/02/2023 03:34:45 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788885589766' AND id_product != '19477' AND ean13 != ''
28/02/2023 03:34:45 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '13/4',
ean13 = '9788885589766',
date_upd = NOW()
WHERE id_product = '19477'
28/02/2023 03:34:46 pm >> UPDATE ps_product_lang SET
name = 'ROSARIO CON DON ORESTE BENZI',
description = ''
WHERE id_product = '19477'
28/02/2023 03:34:46 pm >> UPDATE ps_product SET
wholesale_price = '3.50',
on_sale = '0',
price = '5.0000'
WHERE id_product = '19477'
28/02/2023 03:34:46 pm >> UPDATE ps_product_shop SET
wholesale_price = '3.50',
price = '5.0000',
id_tax_rules_group = '4',
id_category_default = '343',
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 = '19477'
28/02/2023 03:34:46 pm >> DELETE FROM ps_specific_price WHERE id_product = '19477'
28/02/2023 03:35:07 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788872985335' AND id_product != '19486' AND ean13 != ''
28/02/2023 03:35:07 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '13/4',
ean13 = '9788872985335',
date_upd = NOW()
WHERE id_product = '19486'
28/02/2023 03:35:07 pm >> UPDATE ps_product_lang SET
name = 'ROSARIO PER LA PACE - N. SANTILLI',
description = ''
WHERE id_product = '19486'
28/02/2023 03:35:07 pm >> UPDATE ps_product SET
wholesale_price = '1.75',
on_sale = '0',
price = '2.5000'
WHERE id_product = '19486'
28/02/2023 03:35:07 pm >> UPDATE ps_product_shop SET
wholesale_price = '1.75',
price = '2.5000',
id_tax_rules_group = '4',
id_category_default = '29',
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 = '19486'
28/02/2023 03:35:07 pm >> DELETE FROM ps_specific_price WHERE id_product = '19486'
28/02/2023 03:39:56 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788895983592' AND id_product != '15020' AND ean13 != ''
28/02/2023 03:39:56 pm >> UPDATE ps_product SET
id_supplier = '53',
reference = '13/5',
ean13 = '9788895983592',
date_upd = NOW()
WHERE id_product = '15020'
28/02/2023 03:39:56 pm >> UPDATE ps_product_lang SET
name = 'PREGARE OGNI GIORNO',
description = 'Raccolta di preghiere per i vari momenti della giornata e nelle varie occasioni della vita. Utile per fanciulli e adulti che sono alla ricerca di un libretto di preghiere facile e maneggevole.
'
WHERE id_product = '15020'
28/02/2023 03:39:56 pm >> UPDATE ps_product SET
wholesale_price = '0.22',
on_sale = '0',
price = '1.0000'
WHERE id_product = '15020'
28/02/2023 03:39:56 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.22',
price = '1.0000',
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 = '1',
on_most = '00',
date_upd = NOW()
WHERE id_product = '15020'
28/02/2023 03:39:56 pm >> DELETE FROM ps_specific_price WHERE id_product = '15020'
28/02/2023 03:39:56 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' , '15020' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' )
28/02/2023 03:40:55 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788872983843' AND id_product != '18774' AND ean13 != ''
28/02/2023 03:40:55 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '13/3',
ean13 = '9788872983843',
date_upd = NOW()
WHERE id_product = '18774'
28/02/2023 03:40:55 pm >> UPDATE ps_product_lang SET
name = 'SETE DI DIO . V. TOMA',
description = ''
WHERE id_product = '18774'
28/02/2023 03:40:55 pm >> UPDATE ps_product SET
wholesale_price = '7.00',
on_sale = '0',
price = '10.0000'
WHERE id_product = '18774'
28/02/2023 03:40:55 pm >> UPDATE ps_product_shop SET
wholesale_price = '7.00',
price = '10.0000',
id_tax_rules_group = '4',
id_category_default = '29',
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 = '18774'
28/02/2023 03:40:55 pm >> DELETE FROM ps_specific_price WHERE id_product = '18774'
28/02/2023 03:42:57 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884243195' AND id_product != '8327' AND ean13 != ''
28/02/2023 03:42:57 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '13/5',
ean13 = '9788884243195',
date_upd = NOW()
WHERE id_product = '8327'
28/02/2023 03:42:57 pm >> UPDATE ps_product_lang SET
name = 'PREGHIERE A CARATTERI GRANDI',
description = ''
WHERE id_product = '8327'
28/02/2023 03:42:57 pm >> UPDATE ps_product SET
wholesale_price = '3.49',
on_sale = '0',
price = '4.9900'
WHERE id_product = '8327'
28/02/2023 03:42:57 pm >> UPDATE ps_product_shop SET
wholesale_price = '3.49',
price = '4.9900',
id_tax_rules_group = '4',
id_category_default = '83',
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 = '8327'
28/02/2023 03:42:57 pm >> DELETE FROM ps_specific_price WHERE id_product = '8327'
28/02/2023 03:44:55 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788810714270' AND id_product != '16177' AND ean13 != ''
28/02/2023 03:44:55 pm >> UPDATE ps_product SET
id_supplier = '109',
reference = '13/5',
ean13 = '9788810714270',
date_upd = NOW()
WHERE id_product = '16177'
28/02/2023 03:44:55 pm >> UPDATE ps_product_lang SET
name = 'ROSARIO PER I DEFUNTI',
description = ''
WHERE id_product = '16177'
28/02/2023 03:44:55 pm >> UPDATE ps_product SET
wholesale_price = '3.07',
on_sale = '0',
price = '4.5000'
WHERE id_product = '16177'
28/02/2023 03:44:55 pm >> UPDATE ps_product_shop SET
wholesale_price = '3.07',
price = '4.5000',
id_tax_rules_group = '4',
id_category_default = '9',
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 = '16177'
28/02/2023 03:44:55 pm >> DELETE FROM ps_specific_price WHERE id_product = '16177'
28/02/2023 03:45:07 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788895983691' AND id_product != '17274' AND ean13 != ''
28/02/2023 03:45:07 pm >> UPDATE ps_product SET
id_supplier = '142',
reference = '13/5',
ean13 = '9788895983691',
date_upd = NOW()
WHERE id_product = '17274'
28/02/2023 03:45:07 pm >> UPDATE ps_product_lang SET
name = 'VENITE BENEDETTI DEL PADRE MIO',
description = 'Questo opuscolo offre gli schemi per\r\nun triduo di preghiera e di riflessione, incentrato\r\nsul ricordo dei defunti sotto\r\nforma di liturgia della Parola; può essere utilizzato da parrocchie, da\r\ngruppi di preghiera, da famiglie e da singoli fedeli.
Formato 11 x 16,5
\r\n\r\n
Pagine 40
'
WHERE id_product = '17274'
28/02/2023 03:45:07 pm >> UPDATE ps_product SET
wholesale_price = '1.00',
on_sale = '0',
price = '3.0000'
WHERE id_product = '17274'
28/02/2023 03:45:07 pm >> UPDATE ps_product_shop SET
wholesale_price = '1.00',
price = '3.0000',
id_tax_rules_group = '4',
id_category_default = '395',
id_argoment_default = '28',
id_internal_category = '4',
on_sale = '0',
on_showcase = '1',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '17274'
28/02/2023 03:45:07 pm >> DELETE FROM ps_specific_price WHERE id_product = '17274'
28/02/2023 03:45:07 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' , '17274' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' )
28/02/2023 03:45:24 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788885291980' AND id_product != '13083' AND ean13 != ''
28/02/2023 03:45:24 pm >> UPDATE ps_product SET
id_supplier = '99',
reference = '13/5',
ean13 = '9788885291980',
date_upd = NOW()
WHERE id_product = '13083'
28/02/2023 03:45:24 pm >> UPDATE ps_product_lang SET
name = 'PREGHIERA PER I DEFUNTI',
description = ''
WHERE id_product = '13083'
28/02/2023 03:45:24 pm >> UPDATE ps_product SET
wholesale_price = '1.30',
on_sale = '0',
price = '2.0000'
WHERE id_product = '13083'
28/02/2023 03:45:24 pm >> UPDATE ps_product_shop SET
wholesale_price = '1.30',
price = '2.0000',
id_tax_rules_group = '4',
id_category_default = '413',
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 = '13083'
28/02/2023 03:45:24 pm >> DELETE FROM ps_specific_price WHERE id_product = '13083'
28/02/2023 03:46:17 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788885291171' AND id_product != '13084' AND ean13 != ''
28/02/2023 03:46:17 pm >> UPDATE ps_product SET
id_supplier = '99',
reference = '13/3',
ean13 = '9788885291171',
date_upd = NOW()
WHERE id_product = '13084'
28/02/2023 03:46:17 pm >> UPDATE ps_product_lang SET
name = 'PRIMI VENERDI\'',
description = ''
WHERE id_product = '13084'
28/02/2023 03:46:17 pm >> UPDATE ps_product SET
wholesale_price = '1.63',
on_sale = '0',
price = '2.5000'
WHERE id_product = '13084'
28/02/2023 03:46:17 pm >> UPDATE ps_product_shop SET
wholesale_price = '1.63',
price = '2.5000',
id_tax_rules_group = '4',
id_category_default = '413',
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 = '13084'
28/02/2023 03:46:17 pm >> DELETE FROM ps_specific_price WHERE id_product = '13084'
28/02/2023 03:46:39 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788873575467' AND id_product != '7844' AND ean13 != ''
28/02/2023 03:46:39 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '13/3',
ean13 = '9788873575467',
date_upd = NOW()
WHERE id_product = '7844'
28/02/2023 03:46:39 pm >> UPDATE ps_product_lang SET
name = 'PER UNA NUOVA NASCITA',
description = ''
WHERE id_product = '7844'
28/02/2023 03:46:39 pm >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '3.0000'
WHERE id_product = '7844'
28/02/2023 03:46:39 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '3.0000',
id_tax_rules_group = '4',
id_category_default = '178',
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 = '7844'
28/02/2023 03:46:39 pm >> DELETE FROM ps_specific_price WHERE id_product = '7844'
28/02/2023 03:47:32 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788825043099' AND id_product != '4507' AND ean13 != ''
28/02/2023 03:47:32 pm >> UPDATE ps_product SET
id_supplier = '',
reference = '13/3',
ean13 = '9788825043099',
date_upd = NOW()
WHERE id_product = '4507'
28/02/2023 03:47:32 pm >> UPDATE ps_product_lang SET
name = 'GESÙ, CONFIDO IN TE!',
description = ''
WHERE id_product = '4507'
28/02/2023 03:47:32 pm >> UPDATE ps_product SET
wholesale_price = '3.90',
on_sale = '0',
price = '6.0000'
WHERE id_product = '4507'
28/02/2023 03:47:32 pm >> UPDATE ps_product_shop SET
wholesale_price = '3.90',
price = '6.0000',
id_tax_rules_group = '4',
id_category_default = '17',
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 = '4507'
28/02/2023 03:47:32 pm >> DELETE FROM ps_specific_price WHERE id_product = '4507'
28/02/2023 03:48:34 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788868799847' AND id_product != '18465' AND ean13 != ''
28/02/2023 03:48:34 pm >> UPDATE ps_product SET
id_supplier = '109',
reference = '13/3',
ean13 = '9788868799847',
date_upd = NOW()
WHERE id_product = '18465'
28/02/2023 03:48:34 pm >> UPDATE ps_product_lang SET
name = 'GESU\' CONFIDO IN TE',
description = ''
WHERE id_product = '18465'
28/02/2023 03:48:34 pm >> UPDATE ps_product SET
wholesale_price = '9.10',
on_sale = '0',
price = '14.0000'
WHERE id_product = '18465'
28/02/2023 03:48:34 pm >> UPDATE ps_product_shop SET
wholesale_price = '9.10',
price = '14.0000',
id_tax_rules_group = '4',
id_category_default = '143',
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 = '18465'
28/02/2023 03:48:34 pm >> DELETE FROM ps_specific_price WHERE id_product = '18465'
28/02/2023 03:48:58 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788825035292' AND id_product != '2774' AND ean13 != ''
28/02/2023 03:48:58 pm >> UPDATE ps_product SET
id_supplier = '',
reference = '13/3',
ean13 = '9788825035292',
date_upd = NOW()
WHERE id_product = '2774'
28/02/2023 03:48:58 pm >> UPDATE ps_product_lang SET
name = 'CORONCINA DELLA DIVINA MISERICORDIA - C. KOLL',
description = ''
WHERE id_product = '2774'
28/02/2023 03:48:58 pm >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '5.0000'
WHERE id_product = '2774'
28/02/2023 03:48:58 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '5.0000',
id_tax_rules_group = '4',
id_category_default = '17',
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 = '2774'
28/02/2023 03:48:58 pm >> DELETE FROM ps_specific_price WHERE id_product = '2774'
28/02/2023 03:50:37 pm >> SELECT document_num FROM ps_document
WHERE document_num = '663' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-28')
28/02/2023 03:50:37 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' ,
'663' ,
'2023-02-28' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'6.95' ,
'6.95' ,
NOW() ,
NOW() )
28/02/2023 03:50:37 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82059'
28/02/2023 03:50:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '82059'
28/02/2023 03:50:37 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '82059' , '20592' , 'SULLA TUA PAROLA MAR/APR 23 - 515' , '1' , '-1' , '4' ,
'5.00' , '5' , '0' , '5' , '4.75' )
28/02/2023 03:50:37 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '82059' , '978' , 'BEATA VERGINE MARIA CHE SCIOGLIE I NODI - ALBERO GENEALOGICO' , '1' , '-1' , '4' ,
'2.20' , '2.2' , '0' , '0' , '2.20' )
28/02/2023 03:52:19 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788810714157' AND id_product != '10071' AND ean13 != ''
28/02/2023 03:52:19 pm >> UPDATE ps_product SET
id_supplier = '',
reference = '13/5',
ean13 = '9788810714157',
date_upd = NOW()
WHERE id_product = '10071'
28/02/2023 03:52:19 pm >> UPDATE ps_product_lang SET
name = 'SONO ANZIANO SIGNORE, AIUTAMI A PREGARE',
description = ''
WHERE id_product = '10071'
28/02/2023 03:52:19 pm >> UPDATE ps_product SET
wholesale_price = '1.78',
on_sale = '0',
price = '2.5000'
WHERE id_product = '10071'
28/02/2023 03:52:19 pm >> UPDATE ps_product_shop SET
wholesale_price = '1.78',
price = '2.5000',
id_tax_rules_group = '4',
id_category_default = '9',
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 = '10071'
28/02/2023 03:52:19 pm >> DELETE FROM ps_specific_price WHERE id_product = '10071'
28/02/2023 03:52:30 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788810714140' AND id_product != '11370' AND ean13 != ''
28/02/2023 03:52:30 pm >> UPDATE ps_product SET
id_supplier = '',
reference = '13/5',
ean13 = '9788810714140',
date_upd = NOW()
WHERE id_product = '11370'
28/02/2023 03:52:30 pm >> UPDATE ps_product_lang SET
name = 'VIENI IN MIO AIUTO, SIGNORE',
description = ''
WHERE id_product = '11370'
28/02/2023 03:52:30 pm >> UPDATE ps_product SET
wholesale_price = '1.78',
on_sale = '0',
price = '2.5000'
WHERE id_product = '11370'
28/02/2023 03:52:30 pm >> UPDATE ps_product_shop SET
wholesale_price = '1.78',
price = '2.5000',
id_tax_rules_group = '4',
id_category_default = '9',
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 = '11370'
28/02/2023 03:52:30 pm >> DELETE FROM ps_specific_price WHERE id_product = '11370'
28/02/2023 03:53:47 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884072177' AND id_product != '6977' AND ean13 != ''
28/02/2023 03:53:47 pm >> UPDATE ps_product SET
id_supplier = '',
reference = '13/5',
ean13 = '9788884072177',
date_upd = NOW()
WHERE id_product = '6977'
28/02/2023 03:53:47 pm >> UPDATE ps_product_lang SET
name = 'NELLA SOFFERENZA LA CAREZZA DI GESÙ - CATACCHIO/DI GIANDOMENICO',
description = ''
WHERE id_product = '6977'
28/02/2023 03:53:47 pm >> UPDATE ps_product SET
wholesale_price = '3.90',
on_sale = '0',
price = '6.0000'
WHERE id_product = '6977'
28/02/2023 03:53:47 pm >> UPDATE ps_product_shop SET
wholesale_price = '3.90',
price = '6.0000',
id_tax_rules_group = '4',
id_category_default = '263',
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 = '6977'
28/02/2023 03:53:47 pm >> DELETE FROM ps_specific_price WHERE id_product = '6977'
28/02/2023 03:54:15 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788821597572' AND id_product != '9879' AND ean13 != ''
28/02/2023 03:54:15 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '13/5',
ean13 = '9788821597572',
date_upd = NOW()
WHERE id_product = '9879'
28/02/2023 03:54:15 pm >> UPDATE ps_product_lang SET
name = 'SEPPELLIRE I MORTI, PREGARE DIO PER I VIVI E I DEFUNTI - N. BENAZZI',
description = ''
WHERE id_product = '9879'
28/02/2023 03:54:15 pm >> UPDATE ps_product SET
wholesale_price = '3.28',
on_sale = '0',
price = '4.9000'
WHERE id_product = '9879'
28/02/2023 03:54:15 pm >> UPDATE ps_product_shop SET
wholesale_price = '3.28',
price = '4.9000',
id_tax_rules_group = '4',
id_category_default = '30',
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 = '9879'
28/02/2023 03:54:15 pm >> DELETE FROM ps_specific_price WHERE id_product = '9879'
28/02/2023 03:54:32 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831550284' AND id_product != '16006' AND ean13 != ''
28/02/2023 03:54:32 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '13/5',
ean13 = '9788831550284',
date_upd = NOW()
WHERE id_product = '16006'
28/02/2023 03:54:32 pm >> UPDATE ps_product_lang SET
name = 'CONTEMPLERO\' IL TUO VOLTO - GUGLIELMONI/NEGRI',
description = ''
WHERE id_product = '16006'
28/02/2023 03:54:32 pm >> UPDATE ps_product SET
wholesale_price = '7.37',
on_sale = '0',
price = '11.0000'
WHERE id_product = '16006'
28/02/2023 03:54:33 pm >> UPDATE ps_product_shop SET
wholesale_price = '7.37',
price = '11.0000',
id_tax_rules_group = '4',
id_category_default = '30',
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 = '16006'
28/02/2023 03:54:33 pm >> DELETE FROM ps_specific_price WHERE id_product = '16006'
28/02/2023 03:54:48 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831551427' AND id_product != '16220' AND ean13 != ''
28/02/2023 03:54:48 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '13/5',
ean13 = '9788831551427',
date_upd = NOW()
WHERE id_product = '16220'
28/02/2023 03:54:48 pm >> UPDATE ps_product_lang SET
name = 'GUARISCIMI LIBERAMI CONSOLAMI',
description = ''
WHERE id_product = '16220'
28/02/2023 03:54:49 pm >> UPDATE ps_product SET
wholesale_price = '3.35',
on_sale = '0',
price = '5.0000'
WHERE id_product = '16220'
28/02/2023 03:54:49 pm >> UPDATE ps_product_shop SET
wholesale_price = '3.35',
price = '5.0000',
id_tax_rules_group = '4',
id_category_default = '27',
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 = '16220'
28/02/2023 03:54:49 pm >> DELETE FROM ps_specific_price WHERE id_product = '16220'
28/02/2023 03:55:14 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788825039979' AND id_product != '10473' AND ean13 != ''
28/02/2023 03:55:14 pm >> UPDATE ps_product SET
id_supplier = '',
reference = '13/5',
ean13 = '9788825039979',
date_upd = NOW()
WHERE id_product = '10473'
28/02/2023 03:55:14 pm >> UPDATE ps_product_lang SET
name = 'TE DEUM - V. SALVOLDI',
description = ''
WHERE id_product = '10473'
28/02/2023 03:55:14 pm >> UPDATE ps_product SET
wholesale_price = '3.25',
on_sale = '0',
price = '5.0000'
WHERE id_product = '10473'
28/02/2023 03:55:14 pm >> UPDATE ps_product_shop SET
wholesale_price = '3.25',
price = '5.0000',
id_tax_rules_group = '4',
id_category_default = '17',
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 = '10473'
28/02/2023 03:55:14 pm >> DELETE FROM ps_specific_price WHERE id_product = '10473'
28/02/2023 03:58:05 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801065008' AND id_product != '14953' AND ean13 != ''
28/02/2023 03:58:05 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '13/5',
ean13 = '9788801065008',
date_upd = NOW()
WHERE id_product = '14953'
28/02/2023 03:58:05 pm >> UPDATE ps_product_lang SET
name = 'FAMIGLIA DI GESU\' - NOVENA - P. MANCA',
description = ''
WHERE id_product = '14953'
28/02/2023 03:58:05 pm >> UPDATE ps_product SET
wholesale_price = '1.95',
on_sale = '0',
price = '3.0000'
WHERE id_product = '14953'
28/02/2023 03:58:05 pm >> UPDATE ps_product_shop SET
wholesale_price = '1.95',
price = '3.0000',
id_tax_rules_group = '4',
id_category_default = '19',
id_argoment_default = '39',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '14953'
28/02/2023 03:58:05 pm >> DELETE FROM ps_specific_price WHERE id_product = '14953'
28/02/2023 03:58:22 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788873576990' AND id_product != '20395' AND ean13 != ''
28/02/2023 03:58:22 pm >> UPDATE ps_product SET
id_supplier = '107',
reference = '13/5',
ean13 = '9788873576990',
date_upd = NOW()
WHERE id_product = '20395'
28/02/2023 03:58:22 pm >> UPDATE ps_product_lang SET
name = 'SANTA FAMIGLIA ',
description = ''
WHERE id_product = '20395'
28/02/2023 03:58:22 pm >> UPDATE ps_product SET
wholesale_price = '3.25',
on_sale = '0',
price = '5.0000'
WHERE id_product = '20395'
28/02/2023 03:58:22 pm >> UPDATE ps_product_shop SET
wholesale_price = '3.25',
price = '5.0000',
id_tax_rules_group = '4',
id_category_default = '178',
id_argoment_default = '39',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '20395'
28/02/2023 03:58:22 pm >> DELETE FROM ps_specific_price WHERE id_product = '20395'
28/02/2023 03:58:59 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788825032437' AND id_product != '7100' AND ean13 != ''
28/02/2023 03:58:59 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '13/5',
ean13 = '9788825032437',
date_upd = NOW()
WHERE id_product = '7100'
28/02/2023 03:58:59 pm >> UPDATE ps_product_lang SET
name = 'NOVENA A MARIA PER I MALATI - TERESA DI LISIEUX',
description = ''
WHERE id_product = '7100'
28/02/2023 03:58:59 pm >> UPDATE ps_product SET
wholesale_price = '2.45',
on_sale = '0',
price = '3.5000'
WHERE id_product = '7100'
28/02/2023 03:58:59 pm >> UPDATE ps_product_shop SET
wholesale_price = '2.45',
price = '3.5000',
id_tax_rules_group = '4',
id_category_default = '17',
id_argoment_default = '150',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '7100'
28/02/2023 03:58:59 pm >> DELETE FROM ps_specific_price WHERE id_product = '7100'
28/02/2023 03:59:19 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831549851' AND id_product != '13866' AND ean13 != ''
28/02/2023 03:59:19 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '13/3',
ean13 = '9788831549851',
date_upd = NOW()
WHERE id_product = '13866'
28/02/2023 03:59:19 pm >> UPDATE ps_product_lang SET
name = 'IN PREGHIERA CON SANTA RITA ',
description = ''
WHERE id_product = '13866'
28/02/2023 03:59:19 pm >> UPDATE ps_product SET
wholesale_price = '4.69',
on_sale = '0',
price = '7.0000'
WHERE id_product = '13866'
28/02/2023 03:59:19 pm >> UPDATE ps_product_shop SET
wholesale_price = '4.69',
price = '7.0000',
id_tax_rules_group = '4',
id_category_default = '27',
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 = '13866'
28/02/2023 03:59:19 pm >> DELETE FROM ps_specific_price WHERE id_product = '13866'
28/02/2023 03:59:50 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788832047387' AND id_product != '17359' AND ean13 != ''
28/02/2023 03:59:50 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '13/5',
ean13 = '9788832047387',
date_upd = NOW()
WHERE id_product = '17359'
28/02/2023 03:59:50 pm >> UPDATE ps_product_lang SET
name = 'SGUARDO DI UN AMORE CHE E\' DONO',
description = ''
WHERE id_product = '17359'
28/02/2023 03:59:50 pm >> UPDATE ps_product SET
wholesale_price = '5.25',
on_sale = '0',
price = '7.5000'
WHERE id_product = '17359'
28/02/2023 03:59:51 pm >> UPDATE ps_product_shop SET
wholesale_price = '5.25',
price = '7.5000',
id_tax_rules_group = '4',
id_category_default = '57',
id_argoment_default = '39',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '17359'
28/02/2023 03:59:51 pm >> DELETE FROM ps_specific_price WHERE id_product = '17359'
28/02/2023 04:00:07 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788861248199' AND id_product != '16144' AND ean13 != ''
28/02/2023 04:00:07 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '13/5',
ean13 = '9788861248199',
date_upd = NOW()
WHERE id_product = '16144'
28/02/2023 04:00:07 pm >> UPDATE ps_product_lang SET
name = 'NATO ... IN PERIFERIA - RUCCIA/SCALERA',
description = ''
WHERE id_product = '16144'
28/02/2023 04:00:07 pm >> UPDATE ps_product SET
wholesale_price = '1.75',
on_sale = '0',
price = '2.5000'
WHERE id_product = '16144'
28/02/2023 04:00:07 pm >> UPDATE ps_product_shop SET
wholesale_price = '1.75',
price = '2.5000',
id_tax_rules_group = '4',
id_category_default = '26',
id_argoment_default = '150',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '16144'
28/02/2023 04:00:07 pm >> DELETE FROM ps_specific_price WHERE id_product = '16144'
28/02/2023 04:00:45 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831555500' AND id_product != '20308' AND ean13 != ''
28/02/2023 04:00:45 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '13/5',
ean13 = '9788831555500',
date_upd = NOW()
WHERE id_product = '20308'
28/02/2023 04:00:45 pm >> UPDATE ps_product_lang SET
name = 'ATTENDERE E SPERARE - PAPA FRANCESCO',
description = ''
WHERE id_product = '20308'
28/02/2023 04:00:45 pm >> UPDATE ps_product SET
wholesale_price = '2.01',
on_sale = '0',
price = '3.0000'
WHERE id_product = '20308'
28/02/2023 04:00:45 pm >> UPDATE ps_product_shop SET
wholesale_price = '2.01',
price = '3.0000',
id_tax_rules_group = '4',
id_category_default = '27',
id_argoment_default = '39',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '20308'
28/02/2023 04:00:45 pm >> DELETE FROM ps_specific_price WHERE id_product = '20308'
28/02/2023 04:01:01 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788810710975' AND id_product != '16206' AND ean13 != ''
28/02/2023 04:01:01 pm >> UPDATE ps_product SET
id_supplier = '109',
reference = '13/5',
ean13 = '9788810710975',
date_upd = NOW()
WHERE id_product = '16206'
28/02/2023 04:01:01 pm >> UPDATE ps_product_lang SET
name = 'INCONTRARE DIO NEL SILENZIO DEL CUORE - A. CANOPI',
description = ''
WHERE id_product = '16206'
28/02/2023 04:01:01 pm >> UPDATE ps_product SET
wholesale_price = '2.05',
on_sale = '0',
price = '3.0000'
WHERE id_product = '16206'
28/02/2023 04:01:01 pm >> UPDATE ps_product_shop SET
wholesale_price = '2.05',
price = '3.0000',
id_tax_rules_group = '4',
id_category_default = '9',
id_argoment_default = '39',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '16206'
28/02/2023 04:01:01 pm >> DELETE FROM ps_specific_price WHERE id_product = '16206'
28/02/2023 04:01:14 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788826604886' AND id_product != '17499' AND ean13 != ''
28/02/2023 04:01:14 pm >> UPDATE ps_product SET
id_supplier = '79',
reference = '13/5',
ean13 = '9788826604886',
date_upd = NOW()
WHERE id_product = '17499'
28/02/2023 04:01:14 pm >> UPDATE ps_product_lang SET
name = 'E\' NATO PER NOI - PAPA FRANCESCO',
description = ''
WHERE id_product = '17499'
28/02/2023 04:01:14 pm >> UPDATE ps_product SET
wholesale_price = '2.75',
on_sale = '0',
price = '5.0000'
WHERE id_product = '17499'
28/02/2023 04:01:14 pm >> UPDATE ps_product_shop SET
wholesale_price = '2.75',
price = '5.0000',
id_tax_rules_group = '4',
id_category_default = '104',
id_argoment_default = '39',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '17499'
28/02/2023 04:01:14 pm >> DELETE FROM ps_specific_price WHERE id_product = '17499'
28/02/2023 04:01:46 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788895783543' AND id_product != '15012' AND ean13 != ''
28/02/2023 04:01:46 pm >> UPDATE ps_product SET
id_supplier = '127',
reference = '13/5',
ean13 = '9788895783543',
date_upd = NOW()
WHERE id_product = '15012'
28/02/2023 04:01:46 pm >> UPDATE ps_product_lang SET
name = 'SALMI ANATOMIA DELL\'ANIMA',
description = ''
WHERE id_product = '15012'
28/02/2023 04:01:46 pm >> UPDATE ps_product SET
wholesale_price = '1.63',
on_sale = '0',
price = '2.5000'
WHERE id_product = '15012'
28/02/2023 04:01:46 pm >> UPDATE ps_product_shop SET
wholesale_price = '1.63',
price = '2.5000',
id_tax_rules_group = '4',
id_category_default = '37',
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 = '15012'
28/02/2023 04:01:46 pm >> DELETE FROM ps_specific_price WHERE id_product = '15012'
28/02/2023 04:02:30 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801056006' AND id_product != '4443' AND ean13 != ''
28/02/2023 04:02:30 pm >> UPDATE ps_product SET
id_supplier = '',
reference = '13/5',
ean13 = '9788801056006',
date_upd = NOW()
WHERE id_product = '4443'
28/02/2023 04:02:30 pm >> UPDATE ps_product_lang SET
name = 'GESÙ ENTRÒ PER RIMANERE CON LORO - A. FONTANA',
description = ''
WHERE id_product = '4443'
28/02/2023 04:02:30 pm >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '2.5000'
WHERE id_product = '4443'
28/02/2023 04:02:30 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '2.5000',
id_tax_rules_group = '4',
id_category_default = '19',
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 = '4443'
28/02/2023 04:02:30 pm >> DELETE FROM ps_specific_price WHERE id_product = '4443'
28/02/2023 04:02:51 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788898573325' AND id_product != '20011' AND ean13 != ''
28/02/2023 04:02:51 pm >> UPDATE ps_product SET
id_supplier = '107',
reference = '13/5',
ean13 = '9788898573325',
date_upd = NOW()
WHERE id_product = '20011'
28/02/2023 04:02:51 pm >> UPDATE ps_product_lang SET
name = 'UOMO PER L\'UOMO - NOVENA A S. MASSIMILIANO KOLBE - A. CALZORARO',
description = ''
WHERE id_product = '20011'
28/02/2023 04:02:51 pm >> UPDATE ps_product SET
wholesale_price = '2.60',
on_sale = '0',
price = '4.0000'
WHERE id_product = '20011'
28/02/2023 04:02:51 pm >> UPDATE ps_product_shop SET
wholesale_price = '2.60',
price = '4.0000',
id_tax_rules_group = '4',
id_category_default = '419',
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 = '20011'
28/02/2023 04:02:51 pm >> DELETE FROM ps_specific_price WHERE id_product = '20011'
28/02/2023 04:03:16 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801057485' AND id_product != '8267' AND ean13 != ''
28/02/2023 04:03:16 pm >> UPDATE ps_product SET
id_supplier = '',
reference = '13/5',
ean13 = '9788801057485',
date_upd = NOW()
WHERE id_product = '8267'
28/02/2023 04:03:16 pm >> UPDATE ps_product_lang SET
name = 'PREGHIERA CHE È IN TE - A.M. VISSANI',
description = ''
WHERE id_product = '8267'
28/02/2023 04:03:16 pm >> UPDATE ps_product SET
wholesale_price = '3.32',
on_sale = '0',
price = '5.0000'
WHERE id_product = '8267'
28/02/2023 04:03:16 pm >> UPDATE ps_product_shop SET
wholesale_price = '3.32',
price = '5.0000',
id_tax_rules_group = '4',
id_category_default = '19',
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 = '8267'
28/02/2023 04:03:16 pm >> DELETE FROM ps_specific_price WHERE id_product = '8267'
28/02/2023 04:03:45 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788825042733' AND id_product != '6982' AND ean13 != ''
28/02/2023 04:03:45 pm >> UPDATE ps_product SET
id_supplier = '',
reference = '13/5',
ean13 = '9788825042733',
date_upd = NOW()
WHERE id_product = '6982'
28/02/2023 04:03:45 pm >> UPDATE ps_product_lang SET
name = 'NELLE FERITE UMANE LA DIVINA MISERICORDIA - V. SALVOLDI',
description = ''
WHERE id_product = '6982'
28/02/2023 04:03:45 pm >> UPDATE ps_product SET
wholesale_price = '1.50',
on_sale = '0',
price = '2.5000'
WHERE id_product = '6982'
28/02/2023 04:03:45 pm >> UPDATE ps_product_shop SET
wholesale_price = '1.50',
price = '2.5000',
id_tax_rules_group = '4',
id_category_default = '17',
id_argoment_default = '84',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '6982'
28/02/2023 04:03:45 pm >> DELETE FROM ps_specific_price WHERE id_product = '6982'
28/02/2023 04:07:18 pm >> UPDATE ps_product_shop SET
minimal_quantity = '1',
multiple_quantity = '1',
available_date = '',
date_upd = NOW()
WHERE id_product = '13074'
28/02/2023 04:07:18 pm >> UPDATE ps_stock_available SET quantity = quantity + '-1' WHERE id_product = '13074'
28/02/2023 04:08:46 pm >> UPDATE ps_product_shop SET
minimal_quantity = '1',
multiple_quantity = '1',
available_date = '',
date_upd = NOW()
WHERE id_product = '7122'
28/02/2023 04:08:46 pm >> UPDATE ps_stock_available SET quantity = quantity + '-1' WHERE id_product = '7122'
28/02/2023 04:09:13 pm >> UPDATE ps_product_shop SET
minimal_quantity = '1',
multiple_quantity = '1',
available_date = '',
date_upd = NOW()
WHERE id_product = '7254'
28/02/2023 04:09:13 pm >> UPDATE ps_stock_available SET quantity = quantity + '-1' WHERE id_product = '7254'
28/02/2023 04:10:17 pm >> SELECT document_num FROM ps_document
WHERE document_num = '453' AND id_document != '81278' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-08')
28/02/2023 04:10:17 pm >> UPDATE ps_document SET
id_document_type = '11',
document_num = '453',
document_date = '2023-02-08',
document_letter = '',
id_customer = '0',
id_supplier = '',
id_address = '0',
address1 = '',
address2 = '',
note = '',
price_shipping = '0.00',
id_tax_shipping_rules = '4',
colli = '0',
peso = '0',
porto_e_imballo = '0',
mezzo_consegna = '',
id_payment = '0',
id_causal = '0',
price_tax_included = '15.45',
price_tax_excluded = '15.45',
date_upd = NOW()
WHERE id_document = '81278'
28/02/2023 04:10:17 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 = '81278'
28/02/2023 04:10:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '81278'
28/02/2023 04:10:17 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '81278' , '20592' , 'SULLA TUA PAROLA MAR/APR 23 - 515' , '1' , '-1' , '4' ,
'5.0000' , '5' , '0' , '5' , '4.75' )
28/02/2023 04:10:17 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '81278' , '11151' , 'LIBRI' , '1' , '-1' , '4' ,
'2.1' , '2.1' , '0' , '0' , '2.10' )
28/02/2023 04:10:17 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '81278' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '2' , '-2' , '4' ,
'1.0000' , '1' , '0' , '0' , '2.00' )
28/02/2023 04:10:17 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '81278' , '16667' , 'VIA CRUCIS' , '2' , '-2' , '4' ,
'3.0000' , '3' , '0' , '5' , '5.70' )
28/02/2023 04:10:17 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '81278' , '19532' , 'PREGHIAMO' , '1' , '-1' , '4' ,
'0.90' , '0.9' , '0' , '0' , '0.90' )
28/02/2023 04:11:41 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788872985083' AND id_product != '19641' AND ean13 != ''
28/02/2023 04:11:41 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = 'ESPOSITORE S. PAOLO',
ean13 = '9788872985083',
date_upd = NOW()
WHERE id_product = '19641'
28/02/2023 04:11:41 pm >> UPDATE ps_product_lang SET
name = 'PREGHIERA SEMINA VITA - O. MARRAFFA',
description = ''
WHERE id_product = '19641'
28/02/2023 04:11:41 pm >> UPDATE ps_product SET
wholesale_price = '1.75',
on_sale = '0',
price = '2.5000'
WHERE id_product = '19641'
28/02/2023 04:11:41 pm >> UPDATE ps_product_shop SET
wholesale_price = '1.75',
price = '2.5000',
id_tax_rules_group = '4',
id_category_default = '29',
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 = '19641'
28/02/2023 04:11:41 pm >> DELETE FROM ps_specific_price WHERE id_product = '19641'
28/02/2023 04:12:31 pm >> DELETE FROM ps_product WHERE id_product = '11290'
28/02/2023 04:12:31 pm >> DELETE FROM ps_product_shop WHERE id_product = '11290'
28/02/2023 04:12:31 pm >> DELETE FROM ps_product_lang WHERE id_product = '11290'
28/02/2023 04:12:31 pm >> DELETE FROM ps_stock_available WHERE id_product = '11290'
28/02/2023 04:13:26 pm >> UPDATE ps_product_shop SET
minimal_quantity = '1',
multiple_quantity = '1',
available_date = '',
date_upd = NOW()
WHERE id_product = '11832'
28/02/2023 04:13:26 pm >> UPDATE ps_stock_available SET quantity = quantity + '-1' WHERE id_product = '11832'
28/02/2023 04:14:28 pm >> UPDATE ps_product_shop SET
minimal_quantity = '1',
multiple_quantity = '1',
available_date = '',
date_upd = NOW()
WHERE id_product = '9104'
28/02/2023 04:14:28 pm >> UPDATE ps_stock_available SET quantity = quantity + '-1' WHERE id_product = '9104'
28/02/2023 04:16:10 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788868685720' AND id_product != '18834' AND ean13 != ''
28/02/2023 04:16:10 pm >> UPDATE ps_product SET
id_supplier = '109',
reference = '7/1',
ean13 = '9788868685720',
date_upd = NOW()
WHERE id_product = '18834'
28/02/2023 04:16:10 pm >> UPDATE ps_product_lang SET
name = 'BENEDETTO XVI - T. STENICO',
description = ''
WHERE id_product = '18834'
28/02/2023 04:16:10 pm >> UPDATE ps_product SET
wholesale_price = '10.40',
on_sale = '0',
price = '16.0000'
WHERE id_product = '18834'
28/02/2023 04:16:10 pm >> UPDATE ps_product_shop SET
wholesale_price = '10.40',
price = '16.0000',
id_tax_rules_group = '4',
id_category_default = '200',
id_argoment_default = '23',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '18834'
28/02/2023 04:16:10 pm >> DELETE FROM ps_specific_price WHERE id_product = '18834'
28/02/2023 04:16:54 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884043313' AND id_product != '3513' AND ean13 != ''
28/02/2023 04:16:54 pm >> UPDATE ps_product SET
id_supplier = '',
reference = 'ESPOSITORE SHALOM',
ean13 = '9788884043313',
date_upd = NOW()
WHERE id_product = '3513'
28/02/2023 04:16:54 pm >> UPDATE ps_product_lang SET
name = 'DIO PERDONA SEMPRE - 8629 - S. TOGNETTI',
description = ''
WHERE id_product = '3513'
28/02/2023 04:16:54 pm >> UPDATE ps_product SET
wholesale_price = '3.00',
on_sale = '0',
price = '7.0000'
WHERE id_product = '3513'
28/02/2023 04:16:54 pm >> UPDATE ps_product_shop SET
wholesale_price = '3.00',
price = '7.0000',
id_tax_rules_group = '4',
id_category_default = '106',
id_argoment_default = '22',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '3513'
28/02/2023 04:16:54 pm >> DELETE FROM ps_specific_price WHERE id_product = '3513'
28/02/2023 04:17:54 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801059809' AND id_product != '5429' AND ean13 != ''
28/02/2023 04:17:54 pm >> UPDATE ps_product SET
id_supplier = '',
reference = 'ESPOSITORE GIREVOLE',
ean13 = '9788801059809',
date_upd = NOW()
WHERE id_product = '5429'
28/02/2023 04:17:54 pm >> UPDATE ps_product_lang SET
name = 'IO CREDO RISORGERÒ - VISSANI/PICCOTTI',
description = ''
WHERE id_product = '5429'
28/02/2023 04:17:54 pm >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '2.0000'
WHERE id_product = '5429'
28/02/2023 04:17:54 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '2.0000',
id_tax_rules_group = '4',
id_category_default = '19',
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 = '5429'
28/02/2023 04:17:54 pm >> DELETE FROM ps_specific_price WHERE id_product = '5429'
28/02/2023 04:18:48 pm >> UPDATE ps_product_shop SET
minimal_quantity = '1',
multiple_quantity = '1',
available_date = '',
date_upd = NOW()
WHERE id_product = '16140'
28/02/2023 04:18:48 pm >> UPDATE ps_stock_available SET quantity = quantity + '-1' WHERE id_product = '16140'
28/02/2023 04:19:09 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788885291874' AND id_product != '7134' AND ean13 != ''
28/02/2023 04:19:09 pm >> UPDATE ps_product SET
id_supplier = '99',
reference = '13/3',
ean13 = '9788885291874',
date_upd = NOW()
WHERE id_product = '7134'
28/02/2023 04:19:09 pm >> UPDATE ps_product_lang SET
name = 'NOZIONI E PRECI',
description = ''
WHERE id_product = '7134'
28/02/2023 04:19:09 pm >> UPDATE ps_product SET
wholesale_price = '0.85',
on_sale = '0',
price = '1.3000'
WHERE id_product = '7134'
28/02/2023 04:19:09 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.85',
price = '1.3000',
id_tax_rules_group = '4',
id_category_default = '340',
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 = '7134'
28/02/2023 04:19:09 pm >> DELETE FROM ps_specific_price WHERE id_product = '7134'
28/02/2023 04:20:05 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788872983560' AND id_product != '18124' AND ean13 != ''
28/02/2023 04:20:05 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = 'ESPOSITORE GIREVOLE',
ean13 = '9788872983560',
date_upd = NOW()
WHERE id_product = '18124'
28/02/2023 04:20:05 pm >> UPDATE ps_product_lang SET
name = 'PREGHIERE A MARIA',
description = ''
WHERE id_product = '18124'
28/02/2023 04:20:05 pm >> UPDATE ps_product SET
wholesale_price = '3.50',
on_sale = '0',
price = '5.0000'
WHERE id_product = '18124'
28/02/2023 04:20:05 pm >> UPDATE ps_product_shop SET
wholesale_price = '3.50',
price = '5.0000',
id_tax_rules_group = '4',
id_category_default = '29',
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 = '18124'
28/02/2023 04:20:05 pm >> DELETE FROM ps_specific_price WHERE id_product = '18124'
28/02/2023 04:20:41 pm >> DELETE FROM ps_product WHERE id_product = '10765'
28/02/2023 04:20:41 pm >> DELETE FROM ps_product_shop WHERE id_product = '10765'
28/02/2023 04:20:41 pm >> DELETE FROM ps_product_lang WHERE id_product = '10765'
28/02/2023 04:20:41 pm >> DELETE FROM ps_stock_available WHERE id_product = '10765'
28/02/2023 04:21:27 pm >> UPDATE ps_product_shop SET
minimal_quantity = '1',
multiple_quantity = '1',
available_date = '',
date_upd = NOW()
WHERE id_product = '8331'
28/02/2023 04:21:27 pm >> UPDATE ps_stock_available SET quantity = quantity + '-1' WHERE id_product = '8331'
28/02/2023 04:22:00 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788895983561' AND id_product != '15030' AND ean13 != ''
28/02/2023 04:22:00 pm >> UPDATE ps_product SET
id_supplier = '115',
reference = '13/5',
ean13 = '9788895983561',
date_upd = NOW()
WHERE id_product = '15030'
28/02/2023 04:22:00 pm >> UPDATE ps_product_lang SET
name = 'PREGHIERE A SAN MICHELE ARCANGELO',
description = 'Libretto tascabile con le preghiere più significative rivolte a San Michele Arcangelo: corona angelica, novena, litanie, atto di affidamento, consacrazione a s. Michele, a difesa della famiglia, ecc.
'
WHERE id_product = '15030'
28/02/2023 04:22:00 pm >> UPDATE ps_product SET
wholesale_price = '0.18',
on_sale = '0',
price = '1.0000'
WHERE id_product = '15030'
28/02/2023 04:22:00 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.18',
price = '1.0000',
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 = '1',
on_most = '00',
date_upd = NOW()
WHERE id_product = '15030'
28/02/2023 04:22:00 pm >> DELETE FROM ps_specific_price WHERE id_product = '15030'
28/02/2023 04:22:00 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' , '15030' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' )
28/02/2023 04:24:26 pm >> UPDATE ps_product_shop SET
minimal_quantity = '1',
multiple_quantity = '1',
available_date = '',
date_upd = NOW()
WHERE id_product = '16927'
28/02/2023 04:24:26 pm >> UPDATE ps_stock_available SET quantity = quantity + '-1' WHERE id_product = '16927'
28/02/2023 05:01:03 pm >> SELECT document_num FROM ps_document
WHERE document_num = '664' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2023-02-28')
28/02/2023 05:01:03 pm >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'664' ,
'2023-02-28' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'4.75' ,
'4.75' ,
NOW() ,
NOW() )
28/02/2023 05:01: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 = '82060'
28/02/2023 05:01:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '82060'
28/02/2023 05:01: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
( '82060' , '20592' , 'SULLA TUA PAROLA MAR/APR 23 - 515' , '1' , '-1' , '4' ,
'5.00' , '5' , '0' , '5' , '4.75' )
28/02/2023 05:02:31 pm >> SELECT document_num FROM ps_document
WHERE document_num = '665' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-28')
28/02/2023 05:02:31 pm >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'665' ,
'2023-02-28' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'112.80' ,
'96.57' ,
NOW() ,
NOW() )
28/02/2023 05:02:31 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82061'
28/02/2023 05:02:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '82061'
28/02/2023 05:02:31 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '82061' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' ,
'35' , '28.688524590164' , '22' , '0' , '35.00' )
28/02/2023 05:02:31 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '82061' , '16657' , 'CLERGY JEANS - ML ' , '1' , '-1' , '1' ,
'55.00' , '45.081967213115' , '22' , '0' , '55.00' )
28/02/2023 05:02:31 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '82061' , '19366' , 'DAL CENACOLO AL GIARDINO .. - E. DELLA CORTE' , '1' , '-1' , '4' ,
'10.00' , '10' , '0' , '5' , '9.50' )
28/02/2023 05:02:31 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '82061' , '20745' , 'SPERANZA CHE CERCHI - F. CRISTOFARO' , '1' , '-1' , '4' ,
'14.00' , '14' , '0' , '5' , '13.30' )
28/02/2023 05:06: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 (
'32' ,
'2023010000382' ,
'2023-02-28' ,
'' ,
'0' ,
'107' ,
'4669100' ,
'VIA DEI CASTANI, 116 00172 ROMA' ,
'' ,
'' ,
'12' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'12' ,
'0' ,
'200.57' ,
'200.57' ,
NOW() ,
NOW() )
28/02/2023 05:06: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 = '82062'
28/02/2023 05:06:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '82062'
28/02/2023 05:06: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
( '82062' , '20150' , 'MANUALE PER APPRENDISTI GENITORI - P. PELLEGRINO' , '1' , '0' , '4' ,
'14.8000' , '14.8' , '0' , '35' , '9.62' )
28/02/2023 05:06:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20150' AND id_supplier = '107'
28/02/2023 05:06:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20150' , '107' , '1' )
28/02/2023 05:06: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
( '82062' , '20617' , 'PASQUA - BENEDETTO XVI' , '1' , '0' , '4' ,
'28.0000' , '28' , '0' , '35' , '18.20' )
28/02/2023 05:06:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20617' AND id_supplier = '107'
28/02/2023 05:06:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20617' , '107' , '1' )
28/02/2023 05:06: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
( '82062' , '19135' , 'ESERCIZI SPIRITUALI S. IGNAZIO' , '1' , '0' , '4' ,
'10.0000' , '10' , '0' , '35' , '6.50' )
28/02/2023 05:06:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19135' AND id_supplier = '107'
28/02/2023 05:06:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19135' , '107' , '1' )
28/02/2023 05:06:37 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '82062' , '20753' , 'VOCAZIONE UNIVERSALE DELLA CHIESA - E. PALMA' , '1' , '0' , '4' ,
'19.5000' , '19.5' , '0' , '35' , '12.68' )
28/02/2023 05:06:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20753' AND id_supplier = '107'
28/02/2023 05:06:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20753' , '107' , '1' )
28/02/2023 05:06:37 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '82062' , '20754' , 'QUARESIMA - PASQUA - G. SACINO' , '1' , '0' , '4' ,
'16.0000' , '16' , '0' , '35' , '10.40' )
28/02/2023 05:06:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20754' AND id_supplier = '107'
28/02/2023 05:06:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20754' , '107' , '1' )
28/02/2023 05:06:37 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '82062' , '19366' , 'DAL CENACOLO AL GIARDINO .. - E. DELLA CORTE' , '1' , '0' , '4' ,
'10.0000' , '10' , '0' , '35' , '6.50' )
28/02/2023 05:06:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19366' AND id_supplier = '107'
28/02/2023 05:06:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19366' , '107' , '1' )
28/02/2023 05:06:37 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '82062' , '20755' , 'SANTITA MATRIMONIO FAMIGLIA ' , '1' , '0' , '4' ,
'10.0000' , '10' , '0' , '35' , '6.50' )
28/02/2023 05:06:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20755' AND id_supplier = '107'
28/02/2023 05:06:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20755' , '107' , '1' )
28/02/2023 05:06:37 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '82062' , '20756' , 'COMMENTARIO BIBLICO' , '1' , '0' , '4' ,
'50.0000' , '50' , '0' , '35' , '32.50' )
28/02/2023 05:06:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20756' AND id_supplier = '107'
28/02/2023 05:06:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20756' , '107' , '1' )
28/02/2023 05:06:37 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '82062' , '5189' , 'IN NOVITÀ DI VITA - VOL III' , '1' , '0' , '4' ,
'37.8000' , '37.8' , '0' , '35' , '24.57' )
28/02/2023 05:06:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5189' AND id_supplier = '107'
28/02/2023 05:06:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5189' , '107' , '1' )
28/02/2023 05:06:37 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '82062' , '20776' , 'PREGARE I SALMI CON FRANCESCO DASSISI - L. BERGAMASCHI' , '1' , '0' , '4' ,
'14.0000' , '14' , '0' , '35' , '9.10' )
28/02/2023 05:06:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20776' AND id_supplier = '107'
28/02/2023 05:06:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20776' , '107' , '1' )
28/02/2023 05:06:37 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '82062' , '20396' , 'MINISTERO DI GESù NEL VANGELO SECONDO MATTEO - N. DI BIANCO' , '5' , '0' , '4' ,
'16.0000' , '16' , '0' , '35' , '52.00' )
28/02/2023 05:06:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20396' AND id_supplier = '107'
28/02/2023 05:06:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20396' , '107' , '1' )
28/02/2023 05:11:19 pm >> SELECT document_num FROM ps_document
WHERE document_num = '666' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-28')
28/02/2023 05:11:19 pm >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'666' ,
'2023-02-28' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'42.00' ,
'34.43' ,
NOW() ,
NOW() )
28/02/2023 05:11:19 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82063'
28/02/2023 05:11:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '82063'
28/02/2023 05:11:19 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '82063' , '19101' , 'INCENSO C' , '1' , '-1' , '1' ,
'30.00' , '24.590163934426' , '22' , '0' , '30.00' )
28/02/2023 05:11:19 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '82063' , '17161' , 'CARBONCINI NERI - CARNE' , '1' , '-1' , '1' ,
'12.00' , '9.8360655737705' , '22' , '0' , '12.00' )
28/02/2023 05:12:59 pm >> SELECT document_num FROM ps_document
WHERE document_num = '667' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-28')
28/02/2023 05:12:59 pm >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'667' ,
'2023-02-28' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'24.00' ,
'22.11' ,
NOW() ,
NOW() )
28/02/2023 05:12:59 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82064'
28/02/2023 05:12:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '82064'
28/02/2023 05:12:59 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '82064' , '18289' , 'SANTA MESSA DEGLI SPOSI - N.E.' , '1' , '-1' , '4' ,
'1.50' , '1.5' , '0' , '0' , '1.50' )
28/02/2023 05:12:59 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '82064' , '10965' , 'UNZIONE DEGLI INFERMI E IL VIATICO' , '1' , '-1' , '4' ,
'2.50' , '2.5' , '0' , '0' , '2.50' )
28/02/2023 05:12:59 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '82064' , '19540' , 'CRESIMA N.E.' , '1' , '-1' , '4' ,
'3.00' , '3' , '0' , '0' , '3.00' )
28/02/2023 05:12:59 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '82064' , '18290' , 'BATTESIMO - N.E. ' , '1' , '-1' , '4' ,
'1.50' , '1.5' , '0' , '0' , '1.50' )
28/02/2023 05:12:59 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '82064' , '19538' , 'MESSA DEI FANCIULLI - N.E.' , '1' , '-1' , '4' ,
'2.00' , '2' , '0' , '0' , '2.00' )
28/02/2023 05:12:59 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '82064' , '19539' , 'PRESBITERI DIACONI - N.E.' , '1' , '-1' , '4' ,
'3.00' , '3' , '0' , '0' , '3.00' )
28/02/2023 05:12:59 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '82064' , '19754' , 'BRUCIA INCENSI CAMPANA' , '1' , '-1' , '1' ,
'10.5' , '8.6065573770492' , '22' , '0' , '10.50' )
28/02/2023 05:21:50 pm >> UPDATE ps_product_shop SET
minimal_quantity = '1',
multiple_quantity = '1',
available_date = '',
date_upd = NOW()
WHERE id_product = '6660'
28/02/2023 05:21:50 pm >> UPDATE ps_stock_available SET quantity = quantity + '-1' WHERE id_product = '6660'
28/02/2023 05:22:24 pm >> UPDATE ps_product_shop SET
minimal_quantity = '1',
multiple_quantity = '1',
available_date = '',
date_upd = NOW()
WHERE id_product = '17764'
28/02/2023 05:22:24 pm >> UPDATE ps_stock_available SET quantity = quantity + '-1' WHERE id_product = '17764'
28/02/2023 05:22:42 pm >> DELETE FROM ps_product WHERE id_product = '561'
28/02/2023 05:22:42 pm >> DELETE FROM ps_product_shop WHERE id_product = '561'
28/02/2023 05:22:42 pm >> DELETE FROM ps_product_lang WHERE id_product = '561'
28/02/2023 05:22:42 pm >> DELETE FROM ps_stock_available WHERE id_product = '561'
28/02/2023 05:24:33 pm >> DELETE FROM ps_product WHERE id_product = '5807'
28/02/2023 05:24:33 pm >> DELETE FROM ps_product_shop WHERE id_product = '5807'
28/02/2023 05:24:33 pm >> DELETE FROM ps_product_lang WHERE id_product = '5807'
28/02/2023 05:24:33 pm >> DELETE FROM ps_stock_available WHERE id_product = '5807'
28/02/2023 05:25:02 pm >> UPDATE ps_product_shop SET
minimal_quantity = '1',
multiple_quantity = '1',
available_date = '',
date_upd = NOW()
WHERE id_product = '15604'
28/02/2023 05:25:02 pm >> UPDATE ps_stock_available SET quantity = quantity + '-1' WHERE id_product = '15604'
28/02/2023 05:25:23 pm >> UPDATE ps_product_shop SET
minimal_quantity = '1',
multiple_quantity = '1',
available_date = '',
date_upd = NOW()
WHERE id_product = '15604'
28/02/2023 05:25:23 pm >> UPDATE ps_stock_available SET quantity = quantity + '0' WHERE id_product = '15604'
28/02/2023 05:25:38 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801031768' AND id_product != '15604' AND ean13 != ''
28/02/2023 05:25:38 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = 'ESPOSITORE VELAR',
ean13 = '9788801031768',
date_upd = NOW()
WHERE id_product = '15604'
28/02/2023 05:25:38 pm >> UPDATE ps_product_lang SET
name = 'LUIGI MARIA DA MONTFORT',
description = ''
WHERE id_product = '15604'
28/02/2023 05:25:38 pm >> UPDATE ps_product SET
wholesale_price = '2.50',
on_sale = '0',
price = '5.0000'
WHERE id_product = '15604'
28/02/2023 05:25:38 pm >> UPDATE ps_product_shop SET
wholesale_price = '2.50',
price = '5.0000',
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 = '15604'
28/02/2023 05:25:38 pm >> DELETE FROM ps_specific_price WHERE id_product = '15604'
28/02/2023 05:26:44 pm >> UPDATE ps_product_shop SET
minimal_quantity = '1',
multiple_quantity = '1',
available_date = '',
date_upd = NOW()
WHERE id_product = '18112'
28/02/2023 05:26:44 pm >> UPDATE ps_stock_available SET quantity = quantity + '-1' WHERE id_product = '18112'
28/02/2023 05:27:16 pm >> DELETE FROM ps_product WHERE id_product = '7325'
28/02/2023 05:27:16 pm >> DELETE FROM ps_product_shop WHERE id_product = '7325'
28/02/2023 05:27:16 pm >> DELETE FROM ps_product_lang WHERE id_product = '7325'
28/02/2023 05:27:16 pm >> DELETE FROM ps_stock_available WHERE id_product = '7325'
28/02/2023 05:27:46 pm >> DELETE FROM ps_product WHERE id_product = '12706'
28/02/2023 05:27:46 pm >> DELETE FROM ps_product_shop WHERE id_product = '12706'
28/02/2023 05:27:46 pm >> DELETE FROM ps_product_lang WHERE id_product = '12706'
28/02/2023 05:27:46 pm >> DELETE FROM ps_stock_available WHERE id_product = '12706'
28/02/2023 05:28:28 pm >> UPDATE ps_product_shop SET
minimal_quantity = '1',
multiple_quantity = '1',
available_date = '',
date_upd = NOW()
WHERE id_product = '9422'
28/02/2023 05:28:28 pm >> UPDATE ps_stock_available SET quantity = quantity + '-1' WHERE id_product = '9422'
28/02/2023 05:29:13 pm >> UPDATE ps_product_shop SET
minimal_quantity = '1',
multiple_quantity = '1',
available_date = '',
date_upd = NOW()
WHERE id_product = '16366'
28/02/2023 05:29:13 pm >> UPDATE ps_stock_available SET quantity = quantity + '-2' WHERE id_product = '16366'
28/02/2023 05:29:28 pm >> UPDATE ps_product_shop SET
minimal_quantity = '1',
multiple_quantity = '1',
available_date = '',
date_upd = NOW()
WHERE id_product = '16369'
28/02/2023 05:29:28 pm >> UPDATE ps_stock_available SET quantity = quantity + '-2' WHERE id_product = '16369'
28/02/2023 05:29:47 pm >> UPDATE ps_product_shop SET
minimal_quantity = '1',
multiple_quantity = '1',
available_date = '',
date_upd = NOW()
WHERE id_product = '16361'
28/02/2023 05:29:47 pm >> UPDATE ps_stock_available SET quantity = quantity + '-2' WHERE id_product = '16361'
28/02/2023 05:30:03 pm >> UPDATE ps_product_shop SET
minimal_quantity = '1',
multiple_quantity = '1',
available_date = '',
date_upd = NOW()
WHERE id_product = '16370'
28/02/2023 05:30:03 pm >> UPDATE ps_stock_available SET quantity = quantity + '-2' WHERE id_product = '16370'
28/02/2023 05:30:21 pm >> UPDATE ps_product_shop SET
minimal_quantity = '1',
multiple_quantity = '1',
available_date = '',
date_upd = NOW()
WHERE id_product = '16372'
28/02/2023 05:30:21 pm >> UPDATE ps_stock_available SET quantity = quantity + '-2' WHERE id_product = '16372'
28/02/2023 05:31:09 pm >> UPDATE ps_product_shop SET
minimal_quantity = '1',
multiple_quantity = '1',
available_date = '',
date_upd = NOW()
WHERE id_product = '16365'
28/02/2023 05:31:09 pm >> UPDATE ps_stock_available SET quantity = quantity + '-2' WHERE id_product = '16365'
28/02/2023 05:31:31 pm >> UPDATE ps_product_shop SET
minimal_quantity = '1',
multiple_quantity = '1',
available_date = '',
date_upd = NOW()
WHERE id_product = '5421'
28/02/2023 05:31:31 pm >> UPDATE ps_stock_available SET quantity = quantity + '-1' WHERE id_product = '5421'
28/02/2023 05:31:53 pm >> UPDATE ps_product_shop SET
minimal_quantity = '1',
multiple_quantity = '1',
available_date = '',
date_upd = NOW()
WHERE id_product = '16363'
28/02/2023 05:31:53 pm >> UPDATE ps_stock_available SET quantity = quantity + '-2' WHERE id_product = '16363'
28/02/2023 05:33:23 pm >> SELECT document_num FROM ps_document
WHERE document_num = '491' AND id_document != '81327' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-11')
28/02/2023 05:33:23 pm >> UPDATE ps_document SET
id_document_type = '11',
document_num = '491',
document_date = '2023-02-11',
document_letter = '',
id_customer = '0',
id_supplier = '',
id_address = '0',
address1 = '',
address2 = '',
note = '',
price_shipping = '0.00',
id_tax_shipping_rules = '4',
colli = '0',
peso = '0',
porto_e_imballo = '0',
mezzo_consegna = '',
id_payment = '0',
id_causal = '0',
price_tax_included = '35.21',
price_tax_excluded = '33.10',
date_upd = NOW()
WHERE id_document = '81327'
28/02/2023 05:33:23 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81327'
28/02/2023 05:33:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '81327'
28/02/2023 05:33:24 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '81327' , '1425' , 'BUSTA 100 FLAMBEAUX IN CARTA - FLAM' , '1' , '-1' , '1' ,
'7.0000' , '5.7377049180328' , '22' , '0' , '7.00' )
28/02/2023 05:33:24 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '81327' , '17941' , 'LOURDES - ISONZO 119 bis' , '1' , '-1' , '1' ,
'3.5000' , '2.8688524590164' , '22' , '0' , '3.50' )
28/02/2023 05:33:24 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '81327' , '20446' , 'PREFAZI E PREGHIERE EUCARISTICHE' , '1' , '-1' , '4' ,
'1.5000' , '1.5' , '0' , '0' , '1.50' )
28/02/2023 05:33:24 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '81327' , '19571' , 'MIEI PRIMI NUMERI' , '1' , '-1' , '4' ,
'4.9' , '4.9' , '0' , '0' , '4.90' )
28/02/2023 05:33:24 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '81327' , '20587' , 'CATECHESI CREATIVA - A. QUEIROLO' , '1' , '-1' , '4' ,
'14.0000' , '14' , '0' , '5' , '13.30' )
28/02/2023 05:33:24 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '81327' , '15601' , 'RITO DEL BATTESIMO' , '1' , '-1' , '4' ,
'2.5000' , '2.5' , '0' , '5' , '2.38' )
28/02/2023 05:33:24 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '81327' , '18289' , 'SANTA MESSA DEGLI SPOSI - N.E.' , '1' , '-1' , '4' ,
'1.5000' , '1.5' , '0' , '5' , '1.43' )
28/02/2023 05:33:24 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '81327' , '19988' , 'AGENDINA 2023' , '1' , '-1' , '1' ,
'1.2000' , '0.98360655737705' , '22' , '0' , '1.20' )
28/02/2023 05:34:06 pm >> SELECT document_num FROM ps_document
WHERE document_num = '600' AND id_document != '81470' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-23')
28/02/2023 05:34:06 pm >> UPDATE ps_document SET
id_document_type = '11',
document_num = '600',
document_date = '2023-02-23',
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 = '5.00',
price_tax_excluded = '5.00',
date_upd = NOW()
WHERE id_document = '81470'
28/02/2023 05:34:06 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81470'
28/02/2023 05:34:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '81470'
28/02/2023 05:34:06 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '81470' , '19570' , 'MIO PRIMO ALFABETIERE' , '1' , '-1' , '4' ,
'5' , '5' , '0' , '0' , '5.00' )
28/02/2023 05:35:15 pm >> UPDATE ps_product_shop SET
minimal_quantity = '1',
multiple_quantity = '1',
available_date = '',
date_upd = NOW()
WHERE id_product = '16364'
28/02/2023 05:35:15 pm >> UPDATE ps_stock_available SET quantity = quantity + '-2' WHERE id_product = '16364'
28/02/2023 05:35:43 pm >> UPDATE ps_product_shop SET
minimal_quantity = '1',
multiple_quantity = '1',
available_date = '',
date_upd = NOW()
WHERE id_product = '16368'
28/02/2023 05:35:43 pm >> UPDATE ps_stock_available SET quantity = quantity + '-2' WHERE id_product = '16368'
28/02/2023 05:36:12 pm >> UPDATE ps_product_shop SET
minimal_quantity = '1',
multiple_quantity = '1',
available_date = '',
date_upd = NOW()
WHERE id_product = '16367'
28/02/2023 05:36:12 pm >> UPDATE ps_stock_available SET quantity = quantity + '-2' WHERE id_product = '16367'
28/02/2023 05:37:14 pm >> UPDATE ps_product_shop SET
minimal_quantity = '1',
multiple_quantity = '1',
available_date = '',
date_upd = NOW()
WHERE id_product = '11372'
28/02/2023 05:37:14 pm >> UPDATE ps_stock_available SET quantity = quantity + '-5' WHERE id_product = '11372'
28/02/2023 06:26:02 pm >> SELECT document_num FROM ps_document
WHERE document_num = '668' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-28')
28/02/2023 06:26: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' ,
'668' ,
'2023-02-28' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'4.75' ,
'4.75' ,
NOW() ,
NOW() )
28/02/2023 06:26: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 = '82065'
28/02/2023 06:26:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '82065'
28/02/2023 06:26: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
( '82065' , '20592' , 'SULLA TUA PAROLA MAR/APR 23 - 515' , '1' , '-1' , '4' ,
'5.00' , '5' , '0' , '5' , '4.75' )
28/02/2023 06:27:37 pm >> SELECT document_num FROM ps_document
WHERE document_num = '669' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-28')
28/02/2023 06:27:37 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' ,
'669' ,
'2023-02-28' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'184.50' ,
'151.50' ,
NOW() ,
NOW() )
28/02/2023 06:27:37 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82066'
28/02/2023 06:27:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '82066'
28/02/2023 06:27:37 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '82066' , '12659' , 'CAMICE BIANCO - MISTO COT. 140' , '1' , '-1' , '1' ,
'55.00' , '45.081967213115' , '22' , '0' , '55.00' )
28/02/2023 06:27:37 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '82066' , '18399' , 'CAMICE DUE PIEGONI POL. CERNIERA DAVANTI - 405TPAD' , '1' , '-1' , '1' ,
'68.00' , '55.737704918033' , '22' , '0' , '68.00' )
28/02/2023 06:27:37 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '82066' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' ,
'60' , '49.180327868852' , '22' , '0' , '60.00' )
28/02/2023 06:27:37 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '82066' , '6962' , 'NELLA CASA DEL DEFUNTO' , '1' , '-1' , '4' ,
'1.50' , '1.5' , '0' , '0' , '1.50' )
28/02/2023 06:37:51 pm >> SELECT document_num FROM ps_document
WHERE document_num = '670' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-28')
28/02/2023 06:37:51 pm >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'670' ,
'2023-02-28' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'1.80' ,
'1.48' ,
NOW() ,
NOW() )
28/02/2023 06:37:51 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82067'
28/02/2023 06:37:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '82067'
28/02/2023 06:37:51 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '82067' , '9129' , 'ROSARIO LEGNO - T/2' , '1' , '-1' , '1' ,
'1.80' , '1.4754098360656' , '22' , '0' , '1.80' )
28/02/2023 07:16:59 pm >> SELECT document_num FROM ps_document
WHERE document_num = '671' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-28')
28/02/2023 07:16:59 pm >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'671' ,
'2023-02-28' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'48.00' ,
'39.34' ,
NOW() ,
NOW() )
28/02/2023 07:16:59 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82068'
28/02/2023 07:16:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '82068'
28/02/2023 07:16:59 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '82068' , '11389' , 'VINO ROSSO DOLCE - 103' , '6' , '-6' , '1' ,
'8' , '6.5573770491803' , '22' , '0' , '48.00' )
28/02/2023 07:25:13 pm >> SELECT document_num FROM ps_document
WHERE document_num = '672' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-28')
28/02/2023 07:25:13 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' ,
'672' ,
'2023-02-28' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'5.50' ,
'4.51' ,
NOW() ,
NOW() )
28/02/2023 07:25:13 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 = '82069'
28/02/2023 07:25:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '82069'
28/02/2023 07:25: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
( '82069' , '14247' , 'ROSARIO ULIVO OVALE CON SETA E CROCE SAN DAMIANO' , '3' , '-3' , '1' ,
'1.50' , '1.2295081967213' , '22' , '0' , '4.50' )
28/02/2023 07:25: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
( '82069' , '20437' , 'LUMINO BIANCO 10BTS000' , '2' , '-2' , '1' ,
'0.50' , '0.40983606557377' , '22' , '0' , '1.00' )
28/02/2023 07:26:26 pm >> SELECT document_num FROM ps_document
WHERE document_num = '673' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-28')
28/02/2023 07:26:26 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' ,
'673' ,
'2023-02-28' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'3.00' ,
'3.00' ,
NOW() ,
NOW() )
28/02/2023 07:26:26 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82070'
28/02/2023 07:26:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '82070'
28/02/2023 07:26:26 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '82070' , '19115' , 'NOTTE DI PASSIONE - 8051' , '1' , '-1' , '4' ,
'3.00' , '3' , '0' , '0' , '3.00' )
28/02/2023 07:44:22 pm >> SELECT document_num FROM ps_document
WHERE document_num = '674' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-28')
28/02/2023 07:44:22 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' ,
'674' ,
'2023-02-28' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'1.50' ,
'1.23' ,
NOW() ,
NOW() )
28/02/2023 07:44:22 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 = '82071'
28/02/2023 07:44:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '82071'
28/02/2023 07:44:22 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '82071' , '4697' , 'GLORIA MISCELA 25G - GLORE' , '1' , '-1' , '1' ,
'1.50' , '1.2295081967213' , '22' , '0' , '1.50' )