20/01/2023 09:02:20 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() )
20/01/2023 09:02:20 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20632' , '1' , '' , 'nuovo-prodotto' )
20/01/2023 09:02:20 am >> INSERT INTO ps_product_shop (
id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd`
) VALUES (
'20632' , '1' , '1' , '2' , NOW() , NOW()
)
20/01/2023 09:02:20 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '20632' , '0' , '1' , '0' , '0' )
20/01/2023 09:03:34 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788878793002' AND id_product != '20632' AND ean13 != ''
20/01/2023 09:03:34 am >> UPDATE ps_product SET
id_supplier = '',
reference = '7/4',
ean13 = '9788878793002',
date_upd = NOW()
WHERE id_product = '20632'
20/01/2023 09:03:35 am >> UPDATE ps_product_lang SET
name = 'MESSA MEDITAZIONE - MAR/APR 2023',
description = ''
WHERE id_product = '20632'
20/01/2023 09:03:35 am >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '8'
WHERE id_product = '20632'
20/01/2023 09:03:35 am >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '8',
id_tax_rules_group = '4',
id_category_default = '271',
id_argoment_default = '64',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '20632'
20/01/2023 09:03:35 am >> DELETE FROM ps_specific_price WHERE id_product = '20632'
20/01/2023 09:06:28 am >> SELECT document_num FROM ps_document
WHERE document_num = '202' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-20')
20/01/2023 09:06:28 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' ,
'202' ,
'2023-01-20' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'4.75' ,
'4.75' ,
NOW() ,
NOW() )
20/01/2023 09:06:28 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 = '80434'
20/01/2023 09:06:28 am >> DELETE FROM ps_document_detail WHERE id_document = '80434'
20/01/2023 09:06:28 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '80434' , '20275' , 'SULLA TUA PAROLA GEN/FEB 23' , '1' , '-1' , '4' ,
'5.00' , '5' , '0' , '5' , '4.75' )
20/01/2023 09:09:50 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' ,
'110/23' ,
'2023-01-17' ,
'23' ,
'0' ,
'40' ,
'2635' ,
'VIA VIRGINIA AGNELLI, 100 00151 ROMA' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'11' ,
'0' ,
'43.20' ,
'43.20' ,
NOW() ,
NOW() )
20/01/2023 09:09:50 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 = '80435'
20/01/2023 09:09:50 am >> DELETE FROM ps_document_detail WHERE id_document = '80435'
20/01/2023 09:09:50 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '80435' , '20632' , 'MESSA MEDITAZIONE - MAR/APR 2023' , '9' , '9' , '4' ,
'8.00' , '8' , '0' , '40' , '43.2000' )
20/01/2023 09:09:50 am >> DELETE FROM ps_product_supplier WHERE id_product = '20632' AND id_supplier = '40'
20/01/2023 09:09:50 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20632' , '40' , '1' )
20/01/2023 09:31:02 am >> SELECT document_num FROM ps_document
WHERE document_num = '203' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-20')
20/01/2023 09:31:02 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' ,
'203' ,
'2023-01-20' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'3.50' ,
'2.87' ,
NOW() ,
NOW() )
20/01/2023 09:31:02 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 = '80436'
20/01/2023 09:31:02 am >> DELETE FROM ps_document_detail WHERE id_document = '80436'
20/01/2023 09:31:02 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '80436' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '1' , '-1' , '1' ,
'3.50' , '2.8688524590164' , '22' , '0' , '3.50' )
20/01/2023 10:10:47 am >> SELECT document_num FROM ps_document
WHERE document_num = '15' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-01-20')
20/01/2023 10:10:47 am >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'21' ,
'15' ,
'2023-01-20' ,
'' ,
'618' ,
'0' ,
'4671023' ,
'S. ANGELO 84085 MERCATO S. SEVERINO' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'1' ,
'0' ,
'105.00' ,
'105.00' ,
NOW() ,
NOW() )
20/01/2023 10:10:47 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '80437'
20/01/2023 10:10:47 am >> DELETE FROM ps_document_detail WHERE id_document = '80437'
20/01/2023 10:10:47 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '80437' , '19727' , 'LITURGIA IN FRAMMENTI - A. SORRENTINO' , '5' , '-5' , '4' ,
'35.00' , '35' , '0' , '40' , '105.00' )
20/01/2023 10:12:36 am >> SELECT document_num FROM ps_document
WHERE document_num = '204' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-20')
20/01/2023 10:12:36 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' ,
'204' ,
'2023-01-20' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'45.17' ,
'41.94' ,
NOW() ,
NOW() )
20/01/2023 10:12:36 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 = '80438'
20/01/2023 10:12:36 am >> DELETE FROM ps_document_detail WHERE id_document = '80438'
20/01/2023 10:12:36 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '80438' , '19147' , 'CANDELINE NON GOCCIOLANTI GRECHE' , '1' , '-1' , '1' ,
'17.90' , '14.672131147541' , '22' , '0' , '17.90' )
20/01/2023 10:12:36 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '80438' , '14001' , 'PAROLE GESTI SILENZI DELLA MESSA - C. MAGNOLI' , '1' , '-1' , '4' ,
'2.80' , '2.8' , '0' , '5' , '2.66' )
20/01/2023 10:12:36 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '80438' , '5121' , 'IMPARARE A CREDERE ' , '1' , '-1' , '4' ,
'5.90' , '5.9' , '0' , '5' , '5.61' )
20/01/2023 10:12:36 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '80438' , '20630' , 'NIENTALTRO CHE LA VERITA - G. GANSWEIN' , '1' , '-1' , '4' ,
'20.00' , '20' , '0' , '5' , '19.00' )
20/01/2023 10:16:19 am >> SELECT document_num FROM ps_document
WHERE document_num = '15' AND id_document != '80437' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-01-20')
20/01/2023 10:16:19 am >> UPDATE ps_document SET
id_document_type = '21',
document_num = '15',
document_date = '2023-01-20',
document_letter = '',
id_customer = '618',
id_supplier = '',
id_address = '4671023',
address1 = 'S. ANGELO 84085 MERCATO S. SEVERINO',
address2 = '',
note = '',
price_shipping = '0.00',
id_tax_shipping_rules = '4',
colli = '0',
peso = '0',
porto_e_imballo = '0',
mezzo_consegna = '',
id_payment = '1',
id_causal = '0',
price_tax_included = '105.00',
price_tax_excluded = '105.00',
date_upd = NOW()
WHERE id_document = '80437'
20/01/2023 10:16:19 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '80437'
20/01/2023 10:16:19 am >> DELETE FROM ps_document_detail WHERE id_document = '80437'
20/01/2023 10:16:19 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '80437' , '19727' , 'LITURGIA IN FRAMMENTI - A. SORRENTINO' , '5' , '-5' , '4' ,
'35.0000' , '35' , '0' , '40' , '105.00' )
20/01/2023 10:16:19 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '80437' , '' , 'SCONTO AUTORE' , '1' , '-1' , '0' ,
'0' , '0' , '' , '0' , '0' )
20/01/2023 10:34:28 am >> SELECT document_num FROM ps_document
WHERE document_num = '205' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-20')
20/01/2023 10:34:28 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' ,
'205' ,
'2023-01-20' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'60.00' ,
'60.00' ,
NOW() ,
NOW() )
20/01/2023 10:34:28 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 = '80439'
20/01/2023 10:34:28 am >> DELETE FROM ps_document_detail WHERE id_document = '80439'
20/01/2023 10:34:28 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '80439' , '11151' , 'LIBRI' , '1' , '-1' , '4' ,
'60' , '60' , '0' , '0' , '60.00' )
20/01/2023 10:38:39 am >> SELECT document_num FROM ps_document
WHERE document_num = '206' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-20')
20/01/2023 10:38:39 am >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'206' ,
'2023-01-20' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'73.71' ,
'73.71' ,
NOW() ,
NOW() )
20/01/2023 10:38:39 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '80440'
20/01/2023 10:38:39 am >> DELETE FROM ps_document_detail WHERE id_document = '80440'
20/01/2023 10:38:39 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '80440' , '20628' , 'VITA CONSACRATA ' , '2' , '-2' , '4' ,
'3.50' , '3.5' , '0' , '5' , '6.66' )
20/01/2023 10:38:39 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '80440' , '20629' , 'VITA FRATERNA IN COMUNITA' , '2' , '-2' , '4' ,
'3.00' , '3' , '0' , '5' , '5.70' )
20/01/2023 10:38:39 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '80440' , '15970' , 'DIALOGO DELLA DIVINA PROVVIDENZA - S. CATERINA DA SIENA' , '1' , '-1' , '4' ,
'17.00' , '17' , '0' , '5' , '16.15' )
20/01/2023 10:38:39 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '80440' , '20625' , 'DIO E SEMPRE NUOVO - RATZINGER' , '2' , '-2' , '4' ,
'13.00' , '13' , '0' , '5' , '24.70' )
20/01/2023 10:38:39 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '80440' , '20630' , 'NIENTALTRO CHE LA VERITA - G. GANSWEIN' , '1' , '-1' , '4' ,
'20.00' , '20' , '0' , '5' , '19.00' )
20/01/2023 10:38:39 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '80440' , '3663' , 'DONI DELLO SPIRITO SANTO' , '1' , '-1' , '4' ,
'1.50' , '1.5' , '0' , '0' , '1.50' )
20/01/2023 10:39:11 am >> SELECT document_num FROM ps_document
WHERE document_num = '10/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-01-20')
20/01/2023 10:39:11 am >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'24' ,
'10/A' ,
'2023-01-20' ,
'A' ,
'357' ,
'0' ,
'4676034' ,
'VIA TORRIONE 84100 SALERNO' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'19.00' ,
'19.00' ,
NOW() ,
NOW() )
20/01/2023 10:39:11 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 = '80441'
20/01/2023 10:39:11 am >> DELETE FROM ps_document_detail WHERE id_document = '80441'
20/01/2023 10:39:11 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '80441' , '20630' , 'NIENT\'ALTRO CHE LA VERITA\' - G. GANSWEIN' , '1' , '-1' , '4' ,
'20.00' , '20' , '0' , '5' , '19.00' )
20/01/2023 10:50:35 am >> UPDATE ps_document SET
id_document_type = '31',
document_num = '143',
document_date = '2021-06-16',
document_letter = '',
id_customer = '0',
id_supplier = '',
id_address = '2648',
address1 = 'VIA SAN LEONARDO, 120 84100 SALERNO',
address2 = '',
note = '',
price_shipping = '0.00',
id_tax_shipping_rules = '4',
colli = '0',
peso = '0',
porto_e_imballo = '0',
mezzo_consegna = '',
id_payment = '3',
id_causal = '0',
price_tax_included = '3484.00',
price_tax_excluded = '3350.00',
date_upd = NOW()
WHERE id_document = '29312'
20/01/2023 10:50:35 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '29312'
20/01/2023 10:50:35 am >> DELETE FROM ps_document_detail WHERE id_document = '29312'
20/01/2023 10:50:35 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '29312' , '18291' , 'DALLA DISPERAZIONE ALLA SPERANZA - N. SENATORE' , '500' , '500' , '3' ,
'6.7' , '6.4423076923077' , '4' , '0' , '3484.0000' )
20/01/2023 10:52:39 am >> SELECT document_num FROM ps_document
WHERE document_num = '55' AND id_document != '78190' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-05')
20/01/2023 10:52:39 am >> UPDATE ps_document SET
id_document_type = '11',
document_num = '55',
document_date = '2023-01-05',
document_letter = '',
id_customer = '0',
id_supplier = '',
id_address = '0',
address1 = '',
address2 = '',
note = '',
price_shipping = '0.00',
id_tax_shipping_rules = '4',
colli = '0',
peso = '0',
porto_e_imballo = '0',
mezzo_consegna = '',
id_payment = '0',
id_causal = '0',
price_tax_included = '8.08',
price_tax_excluded = '8.08',
date_upd = NOW()
WHERE id_document = '78190'
20/01/2023 10:52:39 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '78190'
20/01/2023 10:52:39 am >> DELETE FROM ps_document_detail WHERE id_document = '78190'
20/01/2023 10:52:39 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '78190' , '13397' , 'MIO GESU' , '1' , '-1' , '4' ,
'3.5000' , '3.5' , '0' , '5' , '3.33' )
20/01/2023 10:52:39 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '78190' , '12813' , 'MARIA MADRE NOSTRA' , '1' , '-1' , '4' ,
'3.0000' , '3' , '0' , '5' , '2.85' )
20/01/2023 10:52:39 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '78190' , '20534' , 'DOMENICA DELLA PAROLA 2023' , '1' , '-1' , '4' ,
'1.9' , '1.9' , '0' , '0' , '1.90' )
20/01/2023 11:02:58 am >> SELECT document_num FROM ps_document
WHERE document_num = '207' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-20')
20/01/2023 11:02:58 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' ,
'207' ,
'2023-01-20' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'18.10' ,
'17.88' ,
NOW() ,
NOW() )
20/01/2023 11:02:58 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 = '80442'
20/01/2023 11:02:58 am >> DELETE FROM ps_document_detail WHERE id_document = '80442'
20/01/2023 11:02:58 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '80442' , '20494' , 'TI VOGLIO FELICE - PAPA FRANCESCO' , '1' , '-1' , '4' ,
'16.90' , '16.9' , '0' , '0' , '16.90' )
20/01/2023 11:02:58 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '80442' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' ,
'1.2' , '0.98360655737705' , '22' , '0' , '1.20' )
20/01/2023 12:15:27 pm >> SELECT document_num FROM ps_document
WHERE document_num = '208' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-20')
20/01/2023 12:15:27 pm >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'208' ,
'2023-01-20' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'14.00' ,
'11.48' ,
NOW() ,
NOW() )
20/01/2023 12:15:27 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '80443'
20/01/2023 12:15:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '80443'
20/01/2023 12:15:27 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '80443' , '9452' , 'SAN GIOVANNI BOSCO - 50' , '4' , '-4' , '1' ,
'3.50' , '2.8688524590164' , '22' , '0' , '14.00' )
20/01/2023 12:20:58 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892222403' AND id_product != '17504' AND ean13 != ''
20/01/2023 12:20:58 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '7/5',
ean13 = '9788892222403',
date_upd = NOW()
WHERE id_product = '17504'
20/01/2023 12:20:58 pm >> UPDATE ps_product_lang SET
name = 'O MARIA MAMMA DOLCISSIMA P. PIO - L. REGOLO',
description = ''
WHERE id_product = '17504'
20/01/2023 12:20:58 pm >> UPDATE ps_product SET
wholesale_price = '5.29',
on_sale = '0',
price = '7.9000'
WHERE id_product = '17504'
20/01/2023 12:20:58 pm >> UPDATE ps_product_shop SET
wholesale_price = '5.29',
price = '7.9000',
id_tax_rules_group = '4',
id_category_default = '30',
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 = '17504'
20/01/2023 12:20:58 pm >> DELETE FROM ps_specific_price WHERE id_product = '17504'
20/01/2023 12:29:35 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831546133' AND id_product != '11225' AND ean13 != ''
20/01/2023 12:29:35 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '6/3',
ean13 = '9788831546133',
date_upd = NOW()
WHERE id_product = '11225'
20/01/2023 12:29:35 pm >> UPDATE ps_product_lang SET
name = 'VERGINE MARIA - A. D\'IPPONA',
description = ''
WHERE id_product = '11225'
20/01/2023 12:29:35 pm >> UPDATE ps_product SET
wholesale_price = '6.03',
on_sale = '0',
price = '9.0000'
WHERE id_product = '11225'
20/01/2023 12:29:35 pm >> UPDATE ps_product_shop SET
wholesale_price = '6.03',
price = '9.0000',
id_tax_rules_group = '4',
id_category_default = '27',
id_argoment_default = '74',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '11225'
20/01/2023 12:29:35 pm >> DELETE FROM ps_specific_price WHERE id_product = '11225'
20/01/2023 12:41:53 pm >> UPDATE ps_product_shop SET
minimal_quantity = '1',
multiple_quantity = '1',
available_date = '',
date_upd = NOW()
WHERE id_product = '841'
20/01/2023 12:41:53 pm >> UPDATE ps_stock_available SET quantity = quantity + '-1' WHERE id_product = '841'
20/01/2023 12:43:36 pm >> UPDATE ps_product_shop SET
minimal_quantity = '1',
multiple_quantity = '1',
available_date = '',
date_upd = NOW()
WHERE id_product = '956'
20/01/2023 12:43:36 pm >> UPDATE ps_stock_available SET quantity = quantity + '-1' WHERE id_product = '956'
20/01/2023 12:44:12 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788821560385' AND id_product != '3977' AND ean13 != ''
20/01/2023 12:44:12 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = 'GONDOLA 1',
ean13 = '9788821560385',
date_upd = NOW()
WHERE id_product = '3977'
20/01/2023 12:44:12 pm >> UPDATE ps_product_lang SET
name = 'EUCARISTIA: LA MIA AUTOSTRADA...',
description = ''
WHERE id_product = '3977'
20/01/2023 12:44:12 pm >> UPDATE ps_product SET
wholesale_price = '10.05',
on_sale = '0',
price = '15.0000'
WHERE id_product = '3977'
20/01/2023 12:44:12 pm >> UPDATE ps_product_shop SET
wholesale_price = '10.05',
price = '15.0000',
id_tax_rules_group = '4',
id_category_default = '30',
id_argoment_default = '53',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '3977'
20/01/2023 12:44:12 pm >> DELETE FROM ps_specific_price WHERE id_product = '3977'
20/01/2023 12:45:51 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788837234805' AND id_product != '20611' AND ean13 != ''
20/01/2023 12:45:51 pm >> UPDATE ps_product SET
id_supplier = '109',
reference = '7/1',
ean13 = '9788837234805',
date_upd = NOW()
WHERE id_product = '20611'
20/01/2023 12:45:51 pm >> UPDATE ps_product_lang SET
name = 'JOSEPH RATZINGER - R. RUSCONI',
description = ''
WHERE id_product = '20611'
20/01/2023 12:45:51 pm >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '17.0000'
WHERE id_product = '20611'
20/01/2023 12:45:51 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '17.0000',
id_tax_rules_group = '4',
id_category_default = '161',
id_argoment_default = '72',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '20611'
20/01/2023 12:45:51 pm >> DELETE FROM ps_specific_price WHERE id_product = '20611'
20/01/2023 12:46:55 pm >> UPDATE ps_product_shop SET
minimal_quantity = '1',
multiple_quantity = '1',
available_date = '',
date_upd = NOW()
WHERE id_product = '6103'
20/01/2023 12:46:55 pm >> UPDATE ps_stock_available SET quantity = quantity + '-1' WHERE id_product = '6103'
20/01/2023 12:52:54 pm >> SELECT document_num FROM ps_document
WHERE document_num = '209' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-20')
20/01/2023 12:52:54 pm >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'209' ,
'2023-01-20' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'9.00' ,
'8.64' ,
NOW() ,
NOW() )
20/01/2023 12:52:54 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '80444'
20/01/2023 12:52:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '80444'
20/01/2023 12:52:54 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '80444' , '10712' , 'TRATTATO DELLA VERA DEVOZIONE A MARIA - 8113' , '1' , '-1' , '4' ,
'7' , '7' , '0' , '0' , '7.00' )
20/01/2023 12:52:54 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '80444' , '18215' , 'BRACCIALE DECINA VARI COL. - BC752' , '2' , '-2' , '1' ,
'1.00' , '0.81967213114754' , '22' , '0' , '2.00' )
20/01/2023 12:55:54 pm >> SELECT document_num FROM ps_document
WHERE document_num = '3994' AND id_document != '77424' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-20')
20/01/2023 12:55:54 pm >> UPDATE ps_document SET
id_document_type = '11',
document_num = '3994',
document_date = '2022-12-20',
document_letter = '',
id_customer = '0',
id_supplier = '',
id_address = '0',
address1 = '',
address2 = '',
note = '',
price_shipping = '0.00',
id_tax_shipping_rules = '4',
colli = '0',
peso = '0',
porto_e_imballo = '0',
mezzo_consegna = '',
id_payment = '0',
id_causal = '0',
price_tax_included = '2.50',
price_tax_excluded = '2.05',
date_upd = NOW()
WHERE id_document = '77424'
20/01/2023 12:55:54 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '77424'
20/01/2023 12:55:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '77424'
20/01/2023 12:55:54 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '77424' , '4697' , 'GLORIA MISCELA 25G - GLORE' , '1' , '-1' , '1' ,
'1.5000' , '1.2295081967213' , '22' , '0' , '1.50' )
20/01/2023 12:55:54 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '77424' , '18215' , 'BRACCIALE DECINA VARI COL. - BC752' , '1' , '-1' , '1' ,
'1.00' , '0.81967213114754' , '22' , '0' , '1.00' )
20/01/2023 02:44:01 pm >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'33' ,
'161' ,
'2023-01-19' ,
'' ,
'0' ,
'79' ,
'2686' ,
'CITTA\\\' DEL VATICANO 00120 CITTA\\\' DEL VATICANO' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'11' ,
'0' ,
'278.05' ,
'278.05' ,
NOW() ,
NOW() )
20/01/2023 02:44:01 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 = '80445'
20/01/2023 02:44:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '80445'
20/01/2023 02:44:01 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '80445' , '9514' , 'SAN TARCISIO' , '1' , '1' , '4' ,
'6.00' , '6' , '0' , '45' , '3.3000' )
20/01/2023 02:44:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9514' AND id_supplier = '79'
20/01/2023 02:44:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9514' , '79' , '1' )
20/01/2023 02:44: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
( '80445' , '2549' , 'COMUNICAZIONE E MISSIONE' , '1' , '1' , '4' ,
'10.00' , '10' , '0' , '35' , '6.5000' )
20/01/2023 02:44:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2549' AND id_supplier = '79'
20/01/2023 02:44:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2549' , '79' , '1' )
20/01/2023 02:44: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
( '80445' , '17329' , 'MESSALE ROMANO DALTARE N.E' , '2' , '2' , '4' ,
'110.00' , '110' , '0' , '30' , '154.0000' )
20/01/2023 02:44:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17329' AND id_supplier = '79'
20/01/2023 02:44:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17329' , '79' , '1' )
20/01/2023 02:44: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
( '80445' , '5759' , 'LEZIONARIO DOMENICALE E FESTIVO - ANNO A' , '2' , '2' , '4' ,
'60' , '60' , '0' , '30' , '84.0000' )
20/01/2023 02:44:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5759' AND id_supplier = '79'
20/01/2023 02:44:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5759' , '79' , '1' )
20/01/2023 02:44: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
( '80445' , '4427' , 'GESÙ DI NAZARET LA FIGURA E IL MESSAGGIO - J. RATZINGER - BENEDETTO XV' , '1' , '1' , '4' ,
'55.00' , '55' , '0' , '45' , '30.2500' )
20/01/2023 02:44:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4427' AND id_supplier = '79'
20/01/2023 02:44:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4427' , '79' , '1' )
20/01/2023 02:44:49 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788820991845' AND id_product != '4427' AND ean13 != ''
20/01/2023 02:44:49 pm >> UPDATE ps_product SET
id_supplier = '79',
reference = '7/1',
ean13 = '9788820991845',
date_upd = NOW()
WHERE id_product = '4427'
20/01/2023 02:44:49 pm >> UPDATE ps_product_lang SET
name = 'GESÙ DI NAZARET LA FIGURA E IL MESSAGGIO - opera omnia - RATZINGER',
description = ''
WHERE id_product = '4427'
20/01/2023 02:44:49 pm >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '55.0000'
WHERE id_product = '4427'
20/01/2023 02:44:49 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '55.0000',
id_tax_rules_group = '4',
id_category_default = '104',
id_argoment_default = '168',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '4427'
20/01/2023 02:44:49 pm >> DELETE FROM ps_specific_price WHERE id_product = '4427'
20/01/2023 02:45:24 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788820991845' AND id_product != '4427' AND ean13 != ''
20/01/2023 02:45:24 pm >> UPDATE ps_product SET
id_supplier = '79',
reference = '13/2',
ean13 = '9788820991845',
date_upd = NOW()
WHERE id_product = '4427'
20/01/2023 02:45:24 pm >> UPDATE ps_product_lang SET
name = 'GESÙ DI NAZARET LA FIGURA E IL MESSAGGIO - opera omnia - RATZINGER',
description = ''
WHERE id_product = '4427'
20/01/2023 02:45:24 pm >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '55.0000'
WHERE id_product = '4427'
20/01/2023 02:45:24 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '55.0000',
id_tax_rules_group = '4',
id_category_default = '104',
id_argoment_default = '168',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '4427'
20/01/2023 02:45:24 pm >> DELETE FROM ps_specific_price WHERE id_product = '4427'
20/01/2023 02:55:07 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788862444606' AND id_product != '8433' AND ean13 != ''
20/01/2023 02:55:07 pm >> UPDATE ps_product SET
id_supplier = '',
reference = '6/1',
ean13 = '9788862444606',
date_upd = NOW()
WHERE id_product = '8433'
20/01/2023 02:55:07 pm >> UPDATE ps_product_lang SET
name = 'PRESENZA VIVA DI SANTA RITA - M. PATRIZI',
description = ''
WHERE id_product = '8433'
20/01/2023 02:55:07 pm >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '25.0000'
WHERE id_product = '8433'
20/01/2023 02:55:07 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '25.0000',
id_tax_rules_group = '4',
id_category_default = '267',
id_argoment_default = '41',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '8433'
20/01/2023 02:55:07 pm >> DELETE FROM ps_specific_price WHERE id_product = '8433'
20/01/2023 02:57:43 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791259750808' AND id_product != '19038' AND ean13 != ''
20/01/2023 02:57:43 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '6/1',
ean13 = '9791259750808',
date_upd = NOW()
WHERE id_product = '19038'
20/01/2023 02:57:43 pm >> UPDATE ps_product_lang SET
name = 'MARIA GORETTI - C. AVOCAN',
description = ''
WHERE id_product = '19038'
20/01/2023 02:57:43 pm >> UPDATE ps_product SET
wholesale_price = '7.00',
on_sale = '0',
price = '10.0000'
WHERE id_product = '19038'
20/01/2023 02:57:43 pm >> UPDATE ps_product_shop SET
wholesale_price = '7.00',
price = '10.0000',
id_tax_rules_group = '4',
id_category_default = '267',
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 = '19038'
20/01/2023 02:57:43 pm >> DELETE FROM ps_specific_price WHERE id_product = '19038'
20/01/2023 03:01:13 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788821597664' AND id_product != '4522' AND ean13 != ''
20/01/2023 03:01:13 pm >> UPDATE ps_product SET
id_supplier = '',
reference = '6/1',
ean13 = '9788821597664',
date_upd = NOW()
WHERE id_product = '4522'
20/01/2023 03:01:13 pm >> UPDATE ps_product_lang SET
name = 'GIANNA BERETTA MOLLA - T. SANGALLI',
description = ''
WHERE id_product = '4522'
20/01/2023 03:01:13 pm >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '14.5000'
WHERE id_product = '4522'
20/01/2023 03:01:13 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '14.5000',
id_tax_rules_group = '4',
id_category_default = '30',
id_argoment_default = '71',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '4522'
20/01/2023 03:01:13 pm >> DELETE FROM ps_specific_price WHERE id_product = '4522'
20/01/2023 03:03:08 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801059175' AND id_product != '8023' AND ean13 != ''
20/01/2023 03:03:08 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '6/1',
ean13 = '9788801059175',
date_upd = NOW()
WHERE id_product = '8023'
20/01/2023 03:03:08 pm >> UPDATE ps_product_lang SET
name = 'PIER GIORGIO FRASSATI',
description = ''
WHERE id_product = '8023'
20/01/2023 03:03:08 pm >> UPDATE ps_product SET
wholesale_price = '6.44',
on_sale = '0',
price = '9.9000'
WHERE id_product = '8023'
20/01/2023 03:03:08 pm >> UPDATE ps_product_shop SET
wholesale_price = '6.44',
price = '9.9000',
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 = '8023'
20/01/2023 03:03:08 pm >> DELETE FROM ps_specific_price WHERE id_product = '8023'
20/01/2023 03:07:08 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791254711439' AND id_product != '20610' AND ean13 != ''
20/01/2023 03:07:08 pm >> UPDATE ps_product SET
id_supplier = '109',
reference = '6/4',
ean13 = '9791254711439',
date_upd = NOW()
WHERE id_product = '20610'
20/01/2023 03:07:08 pm >> UPDATE ps_product_lang SET
name = 'SOLE ANCHE DI NOTTE - D. BLAIN',
description = ''
WHERE id_product = '20610'
20/01/2023 03:07:08 pm >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '16.0000'
WHERE id_product = '20610'
20/01/2023 03:07:08 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '16.0000',
id_tax_rules_group = '4',
id_category_default = '259',
id_argoment_default = '41',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '20610'
20/01/2023 03:07:08 pm >> DELETE FROM ps_specific_price WHERE id_product = '20610'
20/01/2023 03:30:29 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831546775' AND id_product != '9524' AND ean13 != ''
20/01/2023 03:30:29 pm >> UPDATE ps_product SET
id_supplier = '',
reference = '6/1',
ean13 = '9788831546775',
date_upd = NOW()
WHERE id_product = '9524'
20/01/2023 03:30:29 pm >> UPDATE ps_product_lang SET
name = 'SANT\'AGATA - B. IMMEDIATA',
description = ''
WHERE id_product = '9524'
20/01/2023 03:30:29 pm >> UPDATE ps_product SET
wholesale_price = '9.72',
on_sale = '0',
price = '14.5000'
WHERE id_product = '9524'
20/01/2023 03:30:29 pm >> UPDATE ps_product_shop SET
wholesale_price = '9.72',
price = '14.5000',
id_tax_rules_group = '4',
id_category_default = '27',
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 = '9524'
20/01/2023 03:30:29 pm >> DELETE FROM ps_specific_price WHERE id_product = '9524'
20/01/2023 03:32:33 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788879623148' AND id_product != '15911' AND ean13 != ''
20/01/2023 03:32:33 pm >> UPDATE ps_product SET
id_supplier = '107',
reference = '6/4',
ean13 = '9788879623148',
date_upd = NOW()
WHERE id_product = '15911'
20/01/2023 03:32:33 pm >> UPDATE ps_product_lang SET
name = 'SAN FRANCESCO SI RACCONTA - F. MARCHESI',
description = ''
WHERE id_product = '15911'
20/01/2023 03:32:33 pm >> UPDATE ps_product SET
wholesale_price = '7.80',
on_sale = '0',
price = '12.0000'
WHERE id_product = '15911'
20/01/2023 03:32:33 pm >> UPDATE ps_product_shop SET
wholesale_price = '7.80',
price = '12.0000',
id_tax_rules_group = '4',
id_category_default = '110',
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 = '15911'
20/01/2023 03:32:33 pm >> DELETE FROM ps_specific_price WHERE id_product = '15911'
20/01/2023 03:33:50 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788826605722' AND id_product != '17862' AND ean13 != ''
20/01/2023 03:33:50 pm >> UPDATE ps_product SET
id_supplier = '79',
reference = 'GONDOLA 1',
ean13 = '9788826605722',
date_upd = NOW()
WHERE id_product = '17862'
20/01/2023 03:33:50 pm >> UPDATE ps_product_lang SET
name = 'DALL\'INFORMATICA AL CIELO C. ACUTIS - N. GORI',
description = ''
WHERE id_product = '17862'
20/01/2023 03:33:50 pm >> UPDATE ps_product SET
wholesale_price = '6.60',
on_sale = '0',
price = '12.0000'
WHERE id_product = '17862'
20/01/2023 03:33:50 pm >> UPDATE ps_product_shop SET
wholesale_price = '6.60',
price = '12.0000',
id_tax_rules_group = '4',
id_category_default = '104',
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 = '17862'
20/01/2023 03:33:50 pm >> DELETE FROM ps_specific_price WHERE id_product = '17862'
20/01/2023 03:37:41 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788897420989' AND id_product != '17494' AND ean13 != ''
20/01/2023 03:37:41 pm >> UPDATE ps_product SET
id_supplier = '47',
reference = '6/2',
ean13 = '9788897420989',
date_upd = NOW()
WHERE id_product = '17494'
20/01/2023 03:37:41 pm >> UPDATE ps_product_lang SET
name = 'SAN PADRE PIO MIRACOLO EUCARISTICO',
description = ''
WHERE id_product = '17494'
20/01/2023 03:37:41 pm >> UPDATE ps_product SET
wholesale_price = '7.00',
on_sale = '0',
price = '10.0000'
WHERE id_product = '17494'
20/01/2023 03:37:41 pm >> UPDATE ps_product_shop SET
wholesale_price = '7.00',
price = '10.0000',
id_tax_rules_group = '4',
id_category_default = '99',
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 = '17494'
20/01/2023 03:37:41 pm >> DELETE FROM ps_specific_price WHERE id_product = '17494'
20/01/2023 03:37:57 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791280210227' AND id_product != '19833' AND ean13 != ''
20/01/2023 03:37:57 pm >> UPDATE ps_product SET
id_supplier = '47',
reference = '6/2',
ean13 = '9791280210227',
date_upd = NOW()
WHERE id_product = '19833'
20/01/2023 03:37:57 pm >> UPDATE ps_product_lang SET
name = 'PADRE PIO MODELLO DI SANTITA\' - GUARINO/STANZIONE',
description = ''
WHERE id_product = '19833'
20/01/2023 03:37:57 pm >> UPDATE ps_product SET
wholesale_price = '9.10',
on_sale = '0',
price = '13.0000'
WHERE id_product = '19833'
20/01/2023 03:37:57 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 = '71',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '19833'
20/01/2023 03:37:57 pm >> DELETE FROM ps_specific_price WHERE id_product = '19833'
20/01/2023 03:38:11 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884247148' AND id_product != '19619' AND ean13 != ''
20/01/2023 03:38:11 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '6/2',
ean13 = '9788884247148',
date_upd = NOW()
WHERE id_product = '19619'
20/01/2023 03:38:11 pm >> UPDATE ps_product_lang SET
name = 'EMOGRAFIE DI NATUZZA EVOLO - V. MARINELLI',
description = ''
WHERE id_product = '19619'
20/01/2023 03:38:11 pm >> UPDATE ps_product SET
wholesale_price = '9.80',
on_sale = '0',
price = '14.0000'
WHERE id_product = '19619'
20/01/2023 03:38:11 pm >> UPDATE ps_product_shop SET
wholesale_price = '9.80',
price = '14.0000',
id_tax_rules_group = '4',
id_category_default = '83',
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 = '19619'
20/01/2023 03:38:11 pm >> DELETE FROM ps_specific_price WHERE id_product = '19619'
20/01/2023 03:38:25 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788869298547' AND id_product != '19838' AND ean13 != ''
20/01/2023 03:38:25 pm >> UPDATE ps_product SET
id_supplier = '109',
reference = '6/2',
ean13 = '9788869298547',
date_upd = NOW()
WHERE id_product = '19838'
20/01/2023 03:38:25 pm >> UPDATE ps_product_lang SET
name = 'NATUZZA EVOLO E L\'ALDILA\' - V. MARINELLI',
description = ''
WHERE id_product = '19838'
20/01/2023 03:38:25 pm >> UPDATE ps_product SET
wholesale_price = '12.06',
on_sale = '0',
price = '18.0000'
WHERE id_product = '19838'
20/01/2023 03:38:25 pm >> UPDATE ps_product_shop SET
wholesale_price = '12.06',
price = '18.0000',
id_tax_rules_group = '4',
id_category_default = '45',
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 = '19838'
20/01/2023 03:38:25 pm >> DELETE FROM ps_specific_price WHERE id_product = '19838'
20/01/2023 03:38:41 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788821576935' AND id_product != '1731' AND ean13 != ''
20/01/2023 03:38:41 pm >> UPDATE ps_product SET
id_supplier = '',
reference = '6/2',
ean13 = '9788821576935',
date_upd = NOW()
WHERE id_product = '1731'
20/01/2023 03:38:41 pm >> UPDATE ps_product_lang SET
name = 'CARO AMICO SANTO TI SCRIVO ...',
description = ''
WHERE id_product = '1731'
20/01/2023 03:38:41 pm >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '12.0000'
WHERE id_product = '1731'
20/01/2023 03:38:41 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '12.0000',
id_tax_rules_group = '4',
id_category_default = '30',
id_argoment_default = '53',
id_internal_category = '',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '1731'
20/01/2023 03:38:41 pm >> DELETE FROM ps_specific_price WHERE id_product = '1731'
20/01/2023 03:38:55 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788873672999' AND id_product != '20008' AND ean13 != ''
20/01/2023 03:38:55 pm >> UPDATE ps_product SET
id_supplier = '107',
reference = '6/2',
ean13 = '9788873672999',
date_upd = NOW()
WHERE id_product = '20008'
20/01/2023 03:38:55 pm >> UPDATE ps_product_lang SET
name = 'FRANCESCO DI SALES - L. NUOVO',
description = ''
WHERE id_product = '20008'
20/01/2023 03:38:55 pm >> UPDATE ps_product SET
wholesale_price = '6.50',
on_sale = '0',
price = '10.0000'
WHERE id_product = '20008'
20/01/2023 03:38:55 pm >> UPDATE ps_product_shop SET
wholesale_price = '6.50',
price = '10.0000',
id_tax_rules_group = '4',
id_category_default = '380',
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 = '20008'
20/01/2023 03:38:55 pm >> DELETE FROM ps_specific_price WHERE id_product = '20008'
20/01/2023 03:39:10 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788821597527' AND id_product != '4273' AND ean13 != ''
20/01/2023 03:39:10 pm >> UPDATE ps_product SET
id_supplier = '',
reference = '6/2',
ean13 = '9788821597527',
date_upd = NOW()
WHERE id_product = '4273'
20/01/2023 03:39:10 pm >> UPDATE ps_product_lang SET
name = 'FRANCESCO D\'ASSISI - A. DE SIMONE',
description = ''
WHERE id_product = '4273'
20/01/2023 03:39:10 pm >> UPDATE ps_product SET
wholesale_price = '6.63',
on_sale = '0',
price = '9.9000'
WHERE id_product = '4273'
20/01/2023 03:39:10 pm >> UPDATE ps_product_shop SET
wholesale_price = '6.63',
price = '9.9000',
id_tax_rules_group = '4',
id_category_default = '30',
id_argoment_default = '41',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '4273'
20/01/2023 03:39:10 pm >> DELETE FROM ps_specific_price WHERE id_product = '4273'
20/01/2023 03:39:22 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788821597527' AND id_product != '4273' AND ean13 != ''
20/01/2023 03:39:22 pm >> UPDATE ps_product SET
id_supplier = '',
reference = '6/2',
ean13 = '9788821597527',
date_upd = NOW()
WHERE id_product = '4273'
20/01/2023 03:39:22 pm >> UPDATE ps_product_lang SET
name = 'FRANCESCO D\'ASSISI - A. DE SIMONE',
description = ''
WHERE id_product = '4273'
20/01/2023 03:39:22 pm >> UPDATE ps_product SET
wholesale_price = '6.63',
on_sale = '0',
price = '9.9000'
WHERE id_product = '4273'
20/01/2023 03:39:22 pm >> UPDATE ps_product_shop SET
wholesale_price = '6.63',
price = '9.9000',
id_tax_rules_group = '4',
id_category_default = '30',
id_argoment_default = '41',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '4273'
20/01/2023 03:39:22 pm >> DELETE FROM ps_specific_price WHERE id_product = '4273'
20/01/2023 03:39:33 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788861244412' AND id_product != '8035' AND ean13 != ''
20/01/2023 03:39:33 pm >> UPDATE ps_product SET
id_supplier = '',
reference = '6/2',
ean13 = '9788861244412',
date_upd = NOW()
WHERE id_product = '8035'
20/01/2023 03:39:33 pm >> UPDATE ps_product_lang SET
name = 'PINO PUGLISI - PINO PUGLISI',
description = ''
WHERE id_product = '8035'
20/01/2023 03:39:33 pm >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '10.0000'
WHERE id_product = '8035'
20/01/2023 03:39:33 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '10.0000',
id_tax_rules_group = '4',
id_category_default = '26',
id_argoment_default = '53',
id_internal_category = '',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '8035'
20/01/2023 03:39:33 pm >> DELETE FROM ps_specific_price WHERE id_product = '8035'
20/01/2023 03:39:49 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788872983348' AND id_product != '19058' AND ean13 != ''
20/01/2023 03:39:49 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '6/2',
ean13 = '9788872983348',
date_upd = NOW()
WHERE id_product = '19058'
20/01/2023 03:39:49 pm >> UPDATE ps_product_lang SET
name = 'ROSARIO LIVATINO, IL GIUDICE GIUSTO - D. MARIA',
description = ''
WHERE id_product = '19058'
20/01/2023 03:39:49 pm >> UPDATE ps_product SET
wholesale_price = '4.90',
on_sale = '0',
price = '7.0000'
WHERE id_product = '19058'
20/01/2023 03:39:49 pm >> UPDATE ps_product_shop SET
wholesale_price = '4.90',
price = '7.0000',
id_tax_rules_group = '4',
id_category_default = '29',
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 = '19058'
20/01/2023 03:39:49 pm >> DELETE FROM ps_specific_price WHERE id_product = '19058'
20/01/2023 03:40:00 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831554091' AND id_product != '18125' AND ean13 != ''
20/01/2023 03:40:00 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '6/2',
ean13 = '9788831554091',
date_upd = NOW()
WHERE id_product = '18125'
20/01/2023 03:40:00 pm >> UPDATE ps_product_lang SET
name = 'RESISTENZA SENZ\'ARMI - V. BERTOLONE',
description = ''
WHERE id_product = '18125'
20/01/2023 03:40:00 pm >> UPDATE ps_product SET
wholesale_price = '8.04',
on_sale = '0',
price = '12.0000'
WHERE id_product = '18125'
20/01/2023 03:40:00 pm >> UPDATE ps_product_shop SET
wholesale_price = '8.04',
price = '12.0000',
id_tax_rules_group = '4',
id_category_default = '27',
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 = '18125'
20/01/2023 03:40:00 pm >> DELETE FROM ps_specific_price WHERE id_product = '18125'
20/01/2023 03:40:11 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892225893' AND id_product != '18126' AND ean13 != ''
20/01/2023 03:40:11 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '6/2',
ean13 = '9788892225893',
date_upd = NOW()
WHERE id_product = '18126'
20/01/2023 03:40:11 pm >> UPDATE ps_product_lang SET
name = 'ROSARIO LIVATINO - IL GIUDICE GIUSTO',
description = ''
WHERE id_product = '18126'
20/01/2023 03:40:11 pm >> UPDATE ps_product SET
wholesale_price = '12.06',
on_sale = '0',
price = '18.0000'
WHERE id_product = '18126'
20/01/2023 03:40:11 pm >> UPDATE ps_product_shop SET
wholesale_price = '12.06',
price = '18.0000',
id_tax_rules_group = '4',
id_category_default = '30',
id_argoment_default = '71',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '18126'
20/01/2023 03:40:11 pm >> DELETE FROM ps_specific_price WHERE id_product = '18126'
20/01/2023 03:40:25 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788820997519' AND id_product != '6285' AND ean13 != ''
20/01/2023 03:40:25 pm >> UPDATE ps_product SET
id_supplier = '',
reference = '6/2',
ean13 = '9788820997519',
date_upd = NOW()
WHERE id_product = '6285'
20/01/2023 03:40:25 pm >> UPDATE ps_product_lang SET
name = 'MASSIMILIANO KOLBE IL TRIONFO DELL\'AMORE - R. DI MURO',
description = ''
WHERE id_product = '6285'
20/01/2023 03:40:25 pm >> UPDATE ps_product SET
wholesale_price = '6.70',
on_sale = '0',
price = '10.0000'
WHERE id_product = '6285'
20/01/2023 03:40:25 pm >> UPDATE ps_product_shop SET
wholesale_price = '6.70',
price = '10.0000',
id_tax_rules_group = '4',
id_category_default = '104',
id_argoment_default = '53',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '6285'
20/01/2023 03:40:25 pm >> DELETE FROM ps_specific_price WHERE id_product = '6285'
20/01/2023 03:40:38 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801058130' AND id_product != '9519' AND ean13 != ''
20/01/2023 03:40:38 pm >> UPDATE ps_product SET
id_supplier = '',
reference = '6/2',
ean13 = '9788801058130',
date_upd = NOW()
WHERE id_product = '9519'
20/01/2023 03:40:38 pm >> UPDATE ps_product_lang SET
name = 'SAN VINCENZO DE PAOLI - PADRE ITALO ZEDDE C.M.',
description = ''
WHERE id_product = '9519'
20/01/2023 03:40:38 pm >> UPDATE ps_product SET
wholesale_price = '9.95',
on_sale = '0',
price = '15.0000'
WHERE id_product = '9519'
20/01/2023 03:40:38 pm >> UPDATE ps_product_shop SET
wholesale_price = '9.95',
price = '15.0000',
id_tax_rules_group = '4',
id_category_default = '19',
id_argoment_default = '53',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '9519'
20/01/2023 03:40:38 pm >> DELETE FROM ps_specific_price WHERE id_product = '9519'
20/01/2023 03:40:51 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788872981139' AND id_product != '14813' AND ean13 != ''
20/01/2023 03:40:51 pm >> UPDATE ps_product SET
id_supplier = '65',
reference = '6/2',
ean13 = '9788872981139',
date_upd = NOW()
WHERE id_product = '14813'
20/01/2023 03:40:51 pm >> UPDATE ps_product_lang SET
name = 'GABRIELE DELL\'ADDOLORATA - G. CINGOLANI',
description = ''
WHERE id_product = '14813'
20/01/2023 03:40:51 pm >> UPDATE ps_product SET
wholesale_price = '6.00',
on_sale = '0',
price = '10.0000'
WHERE id_product = '14813'
20/01/2023 03:40:51 pm >> UPDATE ps_product_shop SET
wholesale_price = '6.00',
price = '10.0000',
id_tax_rules_group = '4',
id_category_default = '29',
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 = '14813'
20/01/2023 03:40:51 pm >> DELETE FROM ps_specific_price WHERE id_product = '14813'
20/01/2023 03:41:03 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788872981429' AND id_product != '14812' AND ean13 != ''
20/01/2023 03:41:03 pm >> UPDATE ps_product SET
id_supplier = '65',
reference = '6/1',
ean13 = '9788872981429',
date_upd = NOW()
WHERE id_product = '14812'
20/01/2023 03:41:03 pm >> UPDATE ps_product_lang SET
name = 'MARIETTA - G. ALBERTI',
description = ''
WHERE id_product = '14812'
20/01/2023 03:41:03 pm >> UPDATE ps_product SET
wholesale_price = '6.00',
on_sale = '0',
price = '10.0000'
WHERE id_product = '14812'
20/01/2023 03:41:03 pm >> UPDATE ps_product_shop SET
wholesale_price = '6.00',
price = '10.0000',
id_tax_rules_group = '4',
id_category_default = '29',
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 = '14812'
20/01/2023 03:41:03 pm >> DELETE FROM ps_specific_price WHERE id_product = '14812'
20/01/2023 03:41:22 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788895983776' AND id_product != '18052' AND ean13 != ''
20/01/2023 03:41:22 pm >> UPDATE ps_product SET
id_supplier = '145',
reference = '7/5',
ean13 = '9788895983776',
date_upd = NOW()
WHERE id_product = '18052'
20/01/2023 03:41:22 pm >> UPDATE ps_product_lang SET
name = 'CONVERSAZIONI CON MADRE TERESA - GJERGJI',
description = 'Nel 5° anniversario del Concistoro Ordinario Pubblico, convocato da papa Francesco il 15 marzo 2016, per la Canonizzazione di Agnese Gonxha Bojaxhiu. (Madre Teresa) pubblichiamo le interviste esclusive raccolte in diversi Paesi e circostanze, nonché quelle rilasciate durante le sue cinque visite in Kosovo e il discorso tenuto per l’accettazione del Premio Nobel per la Pace (1979), con fotografie, parole, messaggi, discorsi, orientamenti, definizioni, visioni lungimiranti e profetiche: una sorta di testamento spirituale per tutti noi.
'
WHERE id_product = '18052'
20/01/2023 03:41:22 pm >> UPDATE ps_product SET
wholesale_price = '2.60',
on_sale = '0',
price = '12.0000'
WHERE id_product = '18052'
20/01/2023 03:41:22 pm >> UPDATE ps_product_shop SET
wholesale_price = '2.60',
price = '12.0000',
id_tax_rules_group = '4',
id_category_default = '395',
id_argoment_default = '23',
id_internal_category = '4',
on_sale = '0',
on_showcase = '1',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '18052'
20/01/2023 03:41:22 pm >> DELETE FROM ps_specific_price WHERE id_product = '18052'
20/01/2023 03:41:22 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' , '18052' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' )
20/01/2023 03:42:15 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788869298547' AND id_product != '19838' AND ean13 != ''
20/01/2023 03:42:15 pm >> UPDATE ps_product SET
id_supplier = '109',
reference = '6/3',
ean13 = '9788869298547',
date_upd = NOW()
WHERE id_product = '19838'
20/01/2023 03:42:15 pm >> UPDATE ps_product_lang SET
name = 'NATUZZA EVOLO E L\'ALDILA\' - V. MARINELLI',
description = ''
WHERE id_product = '19838'
20/01/2023 03:42:15 pm >> UPDATE ps_product SET
wholesale_price = '12.06',
on_sale = '0',
price = '18.0000'
WHERE id_product = '19838'
20/01/2023 03:42:15 pm >> UPDATE ps_product_shop SET
wholesale_price = '12.06',
price = '18.0000',
id_tax_rules_group = '4',
id_category_default = '45',
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 = '19838'
20/01/2023 03:42:15 pm >> DELETE FROM ps_specific_price WHERE id_product = '19838'
20/01/2023 03:42:30 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884247148' AND id_product != '19619' AND ean13 != ''
20/01/2023 03:42:30 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '6/3',
ean13 = '9788884247148',
date_upd = NOW()
WHERE id_product = '19619'
20/01/2023 03:42:30 pm >> UPDATE ps_product_lang SET
name = 'EMOGRAFIE DI NATUZZA EVOLO - V. MARINELLI',
description = ''
WHERE id_product = '19619'
20/01/2023 03:42:30 pm >> UPDATE ps_product SET
wholesale_price = '9.80',
on_sale = '0',
price = '14.0000'
WHERE id_product = '19619'
20/01/2023 03:42:30 pm >> UPDATE ps_product_shop SET
wholesale_price = '9.80',
price = '14.0000',
id_tax_rules_group = '4',
id_category_default = '83',
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 = '19619'
20/01/2023 03:42:30 pm >> DELETE FROM ps_specific_price WHERE id_product = '19619'
20/01/2023 03:42:43 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831554091' AND id_product != '18125' AND ean13 != ''
20/01/2023 03:42:43 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '6/3',
ean13 = '9788831554091',
date_upd = NOW()
WHERE id_product = '18125'
20/01/2023 03:42:43 pm >> UPDATE ps_product_lang SET
name = 'RESISTENZA SENZ\'ARMI - V. BERTOLONE',
description = ''
WHERE id_product = '18125'
20/01/2023 03:42:43 pm >> UPDATE ps_product SET
wholesale_price = '8.04',
on_sale = '0',
price = '12.0000'
WHERE id_product = '18125'
20/01/2023 03:42:43 pm >> UPDATE ps_product_shop SET
wholesale_price = '8.04',
price = '12.0000',
id_tax_rules_group = '4',
id_category_default = '27',
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 = '18125'
20/01/2023 03:42:43 pm >> DELETE FROM ps_specific_price WHERE id_product = '18125'
20/01/2023 03:42:55 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788872983348' AND id_product != '19058' AND ean13 != ''
20/01/2023 03:42:55 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '6/3',
ean13 = '9788872983348',
date_upd = NOW()
WHERE id_product = '19058'
20/01/2023 03:42:55 pm >> UPDATE ps_product_lang SET
name = 'ROSARIO LIVATINO, IL GIUDICE GIUSTO - D. MARIA',
description = ''
WHERE id_product = '19058'
20/01/2023 03:42:55 pm >> UPDATE ps_product SET
wholesale_price = '4.90',
on_sale = '0',
price = '7.0000'
WHERE id_product = '19058'
20/01/2023 03:42:55 pm >> UPDATE ps_product_shop SET
wholesale_price = '4.90',
price = '7.0000',
id_tax_rules_group = '4',
id_category_default = '29',
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 = '19058'
20/01/2023 03:42:55 pm >> DELETE FROM ps_specific_price WHERE id_product = '19058'
20/01/2023 03:43:07 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892225893' AND id_product != '18126' AND ean13 != ''
20/01/2023 03:43:07 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '6/3',
ean13 = '9788892225893',
date_upd = NOW()
WHERE id_product = '18126'
20/01/2023 03:43:07 pm >> UPDATE ps_product_lang SET
name = 'ROSARIO LIVATINO - IL GIUDICE GIUSTO',
description = ''
WHERE id_product = '18126'
20/01/2023 03:43:07 pm >> UPDATE ps_product SET
wholesale_price = '12.06',
on_sale = '0',
price = '18.0000'
WHERE id_product = '18126'
20/01/2023 03:43:07 pm >> UPDATE ps_product_shop SET
wholesale_price = '12.06',
price = '18.0000',
id_tax_rules_group = '4',
id_category_default = '30',
id_argoment_default = '71',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '18126'
20/01/2023 03:43:07 pm >> DELETE FROM ps_specific_price WHERE id_product = '18126'
20/01/2023 03:44:06 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788821574412' AND id_product != '5509' AND ean13 != ''
20/01/2023 03:44:06 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '6/2',
ean13 = '9788821574412',
date_upd = NOW()
WHERE id_product = '5509'
20/01/2023 03:44:06 pm >> UPDATE ps_product_lang SET
name = 'JOHN HENRY NEWMAN',
description = ''
WHERE id_product = '5509'
20/01/2023 03:44:06 pm >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '6.0000'
WHERE id_product = '5509'
20/01/2023 03:44:06 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '6.0000',
id_tax_rules_group = '4',
id_category_default = '30',
id_argoment_default = '53',
id_internal_category = '',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '5509'
20/01/2023 03:44:06 pm >> DELETE FROM ps_specific_price WHERE id_product = '5509'
20/01/2023 03:44:17 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788867882458' AND id_product != '18410' AND ean13 != ''
20/01/2023 03:44:17 pm >> UPDATE ps_product SET
id_supplier = '107',
reference = '6/2',
ean13 = '9788867882458',
date_upd = NOW()
WHERE id_product = '18410'
20/01/2023 03:44:17 pm >> UPDATE ps_product_lang SET
name = 'SAN GIUSEPPE IL CUSTODE DELL\'AMORE - D. DEL GAUDIO',
description = ''
WHERE id_product = '18410'
20/01/2023 03:44:17 pm >> UPDATE ps_product SET
wholesale_price = '7.80',
on_sale = '0',
price = '12.0000'
WHERE id_product = '18410'
20/01/2023 03:44:17 pm >> UPDATE ps_product_shop SET
wholesale_price = '7.80',
price = '12.0000',
id_tax_rules_group = '4',
id_category_default = '344',
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 = '18410'
20/01/2023 03:44:17 pm >> DELETE FROM ps_specific_price WHERE id_product = '18410'
20/01/2023 03:44:31 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788873573241' AND id_product != '19132' AND ean13 != ''
20/01/2023 03:44:31 pm >> UPDATE ps_product SET
id_supplier = '107',
reference = '6/2',
ean13 = '9788873573241',
date_upd = NOW()
WHERE id_product = '19132'
20/01/2023 03:44:31 pm >> UPDATE ps_product_lang SET
name = 'GIUSEPPE MOSCATI MODELLO ... - A. MARRAZINI',
description = ''
WHERE id_product = '19132'
20/01/2023 03:44:31 pm >> UPDATE ps_product SET
wholesale_price = '13.00',
on_sale = '0',
price = '20.0000'
WHERE id_product = '19132'
20/01/2023 03:44:31 pm >> UPDATE ps_product_shop SET
wholesale_price = '13.00',
price = '20.0000',
id_tax_rules_group = '4',
id_category_default = '178',
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 = '19132'
20/01/2023 03:44:31 pm >> DELETE FROM ps_specific_price WHERE id_product = '19132'
20/01/2023 03:44:43 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788873573302' AND id_product != '19133' AND ean13 != ''
20/01/2023 03:44:43 pm >> UPDATE ps_product SET
id_supplier = '107',
reference = '6/2',
ean13 = '9788873573302',
date_upd = NOW()
WHERE id_product = '19133'
20/01/2023 03:44:44 pm >> UPDATE ps_product_lang SET
name = 'GIUSEPPE MOSCATI UN ESPONENTE ... - A. MARRANZINI',
description = ''
WHERE id_product = '19133'
20/01/2023 03:44:44 pm >> UPDATE ps_product SET
wholesale_price = '9.10',
on_sale = '0',
price = '14.0000'
WHERE id_product = '19133'
20/01/2023 03:44:44 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 = '71',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '19133'
20/01/2023 03:44:44 pm >> DELETE FROM ps_specific_price WHERE id_product = '19133'
20/01/2023 03:44:56 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788873576426' AND id_product != '15954' AND ean13 != ''
20/01/2023 03:44:56 pm >> UPDATE ps_product SET
id_supplier = '109',
reference = '6/2',
ean13 = '9788873576426',
date_upd = NOW()
WHERE id_product = '15954'
20/01/2023 03:44:56 pm >> UPDATE ps_product_lang SET
name = 'MIO BUON MOSCATI - A. PIAZZESI',
description = ''
WHERE id_product = '15954'
20/01/2023 03:44:56 pm >> UPDATE ps_product SET
wholesale_price = '6.50',
on_sale = '0',
price = '10.0000'
WHERE id_product = '15954'
20/01/2023 03:44:56 pm >> UPDATE ps_product_shop SET
wholesale_price = '6.50',
price = '10.0000',
id_tax_rules_group = '4',
id_category_default = '178',
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 = '15954'
20/01/2023 03:44:56 pm >> DELETE FROM ps_specific_price WHERE id_product = '15954'
20/01/2023 03:45:12 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788825049848' AND id_product != '16908' AND ean13 != ''
20/01/2023 03:45:12 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '6/2',
ean13 = '9788825049848',
date_upd = NOW()
WHERE id_product = '16908'
20/01/2023 03:45:12 pm >> UPDATE ps_product_lang SET
name = 'SUI PASSI DI SANT\'ANTONIO - G. CADILHE',
description = ''
WHERE id_product = '16908'
20/01/2023 03:45:12 pm >> UPDATE ps_product SET
wholesale_price = '10.50',
on_sale = '0',
price = '15.0000'
WHERE id_product = '16908'
20/01/2023 03:45:12 pm >> UPDATE ps_product_shop SET
wholesale_price = '10.50',
price = '15.0000',
id_tax_rules_group = '4',
id_category_default = '17',
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 = '16908'
20/01/2023 03:45:12 pm >> DELETE FROM ps_specific_price WHERE id_product = '16908'
20/01/2023 03:49:18 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884244741' AND id_product != '15283' AND ean13 != ''
20/01/2023 03:49:18 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = 'GONDOLA 1',
ean13 = '9788884244741',
date_upd = NOW()
WHERE id_product = '15283'
20/01/2023 03:49:18 pm >> UPDATE ps_product_lang SET
name = 'DIARIO DELLA FELICITA\' ',
description = ''
WHERE id_product = '15283'
20/01/2023 03:49:18 pm >> UPDATE ps_product SET
wholesale_price = '5.60',
on_sale = '0',
price = '8.0000'
WHERE id_product = '15283'
20/01/2023 03:49:18 pm >> UPDATE ps_product_shop SET
wholesale_price = '5.60',
price = '8.0000',
id_tax_rules_group = '4',
id_category_default = '83',
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 = '15283'
20/01/2023 03:49:18 pm >> DELETE FROM ps_specific_price WHERE id_product = '15283'
20/01/2023 03:49:29 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884246738' AND id_product != '18205' AND ean13 != ''
20/01/2023 03:49:29 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = 'GONDOLA 1',
ean13 = '9788884246738',
date_upd = NOW()
WHERE id_product = '18205'
20/01/2023 03:49:29 pm >> UPDATE ps_product_lang SET
name = 'DIARIO DELLA FELICITA\' - 2',
description = ''
WHERE id_product = '18205'
20/01/2023 03:49:29 pm >> UPDATE ps_product SET
wholesale_price = '7.00',
on_sale = '0',
price = '10.0000'
WHERE id_product = '18205'
20/01/2023 03:49:29 pm >> UPDATE ps_product_shop SET
wholesale_price = '7.00',
price = '10.0000',
id_tax_rules_group = '4',
id_category_default = '83',
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 = '18205'
20/01/2023 03:49:29 pm >> DELETE FROM ps_specific_price WHERE id_product = '18205'
20/01/2023 03:51:07 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831540391' AND id_product != '10582' AND ean13 != ''
20/01/2023 03:51:07 pm >> UPDATE ps_product SET
id_supplier = '',
reference = '6/1',
ean13 = '9788831540391',
date_upd = NOW()
WHERE id_product = '10582'
20/01/2023 03:51:07 pm >> UPDATE ps_product_lang SET
name = 'TERESA D\'AVILA - CORAGGIO AL FEMMINILE - TERESA D\'AVILA',
description = ''
WHERE id_product = '10582'
20/01/2023 03:51:07 pm >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '40.0000'
WHERE id_product = '10582'
20/01/2023 03:51:07 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '40.0000',
id_tax_rules_group = '4',
id_category_default = '27',
id_argoment_default = '53',
id_internal_category = '',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '10582'
20/01/2023 03:51:07 pm >> DELETE FROM ps_specific_price WHERE id_product = '10582'
20/01/2023 03:51:20 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788863663365' AND id_product != '17153' AND ean13 != ''
20/01/2023 03:51:20 pm >> UPDATE ps_product SET
id_supplier = '47',
reference = '6/2',
ean13 = '9788863663365',
date_upd = NOW()
WHERE id_product = '17153'
20/01/2023 03:51:20 pm >> UPDATE ps_product_lang SET
name = 'SAN CHARBEL',
description = ''
WHERE id_product = '17153'
20/01/2023 03:51:20 pm >> UPDATE ps_product SET
wholesale_price = '5.25',
on_sale = '0',
price = '7.5000'
WHERE id_product = '17153'
20/01/2023 03:51:20 pm >> UPDATE ps_product_shop SET
wholesale_price = '5.25',
price = '7.5000',
id_tax_rules_group = '4',
id_category_default = '24',
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 = '17153'
20/01/2023 03:51:20 pm >> DELETE FROM ps_specific_price WHERE id_product = '17153'
20/01/2023 03:51:33 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788869298608' AND id_product != '19839' AND ean13 != ''
20/01/2023 03:51:33 pm >> UPDATE ps_product SET
id_supplier = '109',
reference = '6/1',
ean13 = '9788869298608',
date_upd = NOW()
WHERE id_product = '19839'
20/01/2023 03:51:33 pm >> UPDATE ps_product_lang SET
name = 'SAN GIOVANNI DELLA CROCE - M. TONDO',
description = ''
WHERE id_product = '19839'
20/01/2023 03:51:33 pm >> UPDATE ps_product SET
wholesale_price = '10.72',
on_sale = '0',
price = '16.0000'
WHERE id_product = '19839'
20/01/2023 03:51:33 pm >> UPDATE ps_product_shop SET
wholesale_price = '10.72',
price = '16.0000',
id_tax_rules_group = '4',
id_category_default = '45',
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 = '19839'
20/01/2023 03:51:33 pm >> DELETE FROM ps_specific_price WHERE id_product = '19839'
20/01/2023 03:52:58 pm >> SELECT document_num FROM ps_document
WHERE document_num = '7/A' AND id_document != '79381' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-01-18')
20/01/2023 03:52:58 pm >> UPDATE ps_document SET
id_document_type = '24',
document_num = '7/A',
document_date = '2023-01-18',
document_letter = 'A',
id_customer = '206',
id_supplier = '',
id_address = '4671015',
address1 = 'VIA N. BUONSERVIZI, 25 84135 SALERNO',
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 = '62.00',
price_tax_excluded = '62.00',
date_upd = NOW()
WHERE id_document = '79381'
20/01/2023 03:52:58 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '79381'
20/01/2023 03:52:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '79381'
20/01/2023 03:52:58 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '79381' , '20625' , 'DIO E SEMPRE NUOVO - RATZINGER' , '1' , '-1' , '4' ,
'13.0000' , '13' , '0' , '0' , '13.00' )
20/01/2023 03:52:58 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '79381' , '6223' , 'MARIA CON I PIEDI PER TERRA - P. CURTAZ' , '1' , '-1' , '4' ,
'16.5000' , '16.5' , '0' , '0' , '16.50' )
20/01/2023 03:52:58 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '79381' , '20626' , 'IN CAMMINO VERSO GESU CRISTO - J. RATZINGER' , '1' , '-1' , '4' ,
'12.5000' , '12.5' , '0' , '0' , '12.50' )
20/01/2023 03:52:58 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '79381' , '20592' , 'SULLA TUA PAROLA MAR/APR 23 - 515' , '1' , '-1' , '4' ,
'5.0000' , '5' , '0' , '0' , '5.00' )
20/01/2023 03:52:58 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '79381' , '15238' , 'VERONICA GIULIANI - A. CLEMENTI' , '1' , '-1' , '4' ,
'15.00' , '15' , '0' , '0' , '15.00' )
20/01/2023 03:55:27 pm >> SELECT document_num FROM ps_document
WHERE document_num = '210' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-20')
20/01/2023 03:55:27 pm >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'210' ,
'2023-01-20' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'6.56' ,
'6.56' ,
NOW() ,
NOW() )
20/01/2023 03:55:27 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '80446'
20/01/2023 03:55:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '80446'
20/01/2023 03:55:27 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '80446' , '20057' , 'CINQUE PANI DORZO 2023' , '1' , '-1' , '4' ,
'6.90' , '6.9' , '0' , '5' , '6.56' )
20/01/2023 04:09:10 pm >> SELECT document_num FROM ps_document
WHERE document_num = '211' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-20')
20/01/2023 04:09:10 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' ,
'211' ,
'2023-01-20' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'57.00' ,
'57.00' ,
NOW() ,
NOW() )
20/01/2023 04:09:10 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 = '80447'
20/01/2023 04:09:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '80447'
20/01/2023 04:09:10 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '80447' , '5759' , 'LEZIONARIO DOMENICALE E FESTIVO - ANNO A' , '1' , '-1' , '4' ,
'60.00' , '60' , '0' , '5' , '57.00' )
20/01/2023 04:12:24 pm >> SELECT document_num FROM ps_document
WHERE document_num = '212' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-20')
20/01/2023 04:12:24 pm >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'212' ,
'2023-01-20' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'25.00' ,
'20.49' ,
NOW() ,
NOW() )
20/01/2023 04:12:24 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '80448'
20/01/2023 04:12:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '80448'
20/01/2023 04:12: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
( '80448' , '18615' , 'SAN ROCCO CM 20 - 340' , '1' , '-1' , '1' ,
'25' , '20.491803278689' , '22' , '0' , '25.00' )
20/01/2023 04:19:54 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788860892027' AND id_product != '13520' AND ean13 != ''
20/01/2023 04:19:55 pm >> UPDATE ps_product SET
id_supplier = '65',
reference = '6/4',
ean13 = '9788860892027',
date_upd = NOW()
WHERE id_product = '13520'
20/01/2023 04:19:55 pm >> UPDATE ps_product_lang SET
name = 'LIBERA CHIARA',
description = ''
WHERE id_product = '13520'
20/01/2023 04:19:55 pm >> UPDATE ps_product SET
wholesale_price = '9.10',
on_sale = '0',
price = '13.0000'
WHERE id_product = '13520'
20/01/2023 04:19:55 pm >> UPDATE ps_product_shop SET
wholesale_price = '9.10',
price = '13.0000',
id_tax_rules_group = '4',
id_category_default = '115',
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 = '13520'
20/01/2023 04:19:55 pm >> DELETE FROM ps_specific_price WHERE id_product = '13520'
20/01/2023 04:20:06 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788869298547' AND id_product != '19838' AND ean13 != ''
20/01/2023 04:20:07 pm >> UPDATE ps_product SET
id_supplier = '109',
reference = '6/4',
ean13 = '9788869298547',
date_upd = NOW()
WHERE id_product = '19838'
20/01/2023 04:20:07 pm >> UPDATE ps_product_lang SET
name = 'NATUZZA EVOLO E L\'ALDILA\' - V. MARINELLI',
description = ''
WHERE id_product = '19838'
20/01/2023 04:20:07 pm >> UPDATE ps_product SET
wholesale_price = '12.06',
on_sale = '0',
price = '18.0000'
WHERE id_product = '19838'
20/01/2023 04:20:07 pm >> UPDATE ps_product_shop SET
wholesale_price = '12.06',
price = '18.0000',
id_tax_rules_group = '4',
id_category_default = '45',
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 = '19838'
20/01/2023 04:20:07 pm >> DELETE FROM ps_specific_price WHERE id_product = '19838'
20/01/2023 04:20:24 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831554091' AND id_product != '18125' AND ean13 != ''
20/01/2023 04:20:24 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '6/4',
ean13 = '9788831554091',
date_upd = NOW()
WHERE id_product = '18125'
20/01/2023 04:20:24 pm >> UPDATE ps_product_lang SET
name = 'RESISTENZA SENZ\'ARMI - V. BERTOLONE',
description = ''
WHERE id_product = '18125'
20/01/2023 04:20:24 pm >> UPDATE ps_product SET
wholesale_price = '8.04',
on_sale = '0',
price = '12.0000'
WHERE id_product = '18125'
20/01/2023 04:20:24 pm >> UPDATE ps_product_shop SET
wholesale_price = '8.04',
price = '12.0000',
id_tax_rules_group = '4',
id_category_default = '27',
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 = '18125'
20/01/2023 04:20:24 pm >> DELETE FROM ps_specific_price WHERE id_product = '18125'
20/01/2023 04:20:35 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892225893' AND id_product != '18126' AND ean13 != ''
20/01/2023 04:20:35 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '6/4',
ean13 = '9788892225893',
date_upd = NOW()
WHERE id_product = '18126'
20/01/2023 04:20:35 pm >> UPDATE ps_product_lang SET
name = 'ROSARIO LIVATINO - IL GIUDICE GIUSTO',
description = ''
WHERE id_product = '18126'
20/01/2023 04:20:35 pm >> UPDATE ps_product SET
wholesale_price = '12.06',
on_sale = '0',
price = '18.0000'
WHERE id_product = '18126'
20/01/2023 04:20:35 pm >> UPDATE ps_product_shop SET
wholesale_price = '12.06',
price = '18.0000',
id_tax_rules_group = '4',
id_category_default = '30',
id_argoment_default = '71',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '18126'
20/01/2023 04:20:35 pm >> DELETE FROM ps_specific_price WHERE id_product = '18126'
20/01/2023 04:20:50 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788872983003' AND id_product != '18236' AND ean13 != ''
20/01/2023 04:20:50 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '6/2',
ean13 = '9788872983003',
date_upd = NOW()
WHERE id_product = '18236'
20/01/2023 04:20:50 pm >> UPDATE ps_product_lang SET
name = 'SANT\'ANTONIO DI PADOVA - G. SACINO',
description = ''
WHERE id_product = '18236'
20/01/2023 04:20:50 pm >> UPDATE ps_product SET
wholesale_price = '6.30',
on_sale = '0',
price = '9.0000'
WHERE id_product = '18236'
20/01/2023 04:20:50 pm >> UPDATE ps_product_shop SET
wholesale_price = '6.30',
price = '9.0000',
id_tax_rules_group = '4',
id_category_default = '29',
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 = '18236'
20/01/2023 04:20:50 pm >> DELETE FROM ps_specific_price WHERE id_product = '18236'
20/01/2023 04:21:03 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892229198' AND id_product != '19901' AND ean13 != ''
20/01/2023 04:21:03 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '6/2',
ean13 = '9788892229198',
date_upd = NOW()
WHERE id_product = '19901'
20/01/2023 04:21:03 pm >> UPDATE ps_product_lang SET
name = 'CHIARA - M. BARTOLI',
description = ''
WHERE id_product = '19901'
20/01/2023 04:21:03 pm >> UPDATE ps_product SET
wholesale_price = '12.06',
on_sale = '0',
price = '18.0000'
WHERE id_product = '19901'
20/01/2023 04:21:03 pm >> UPDATE ps_product_shop SET
wholesale_price = '12.06',
price = '18.0000',
id_tax_rules_group = '4',
id_category_default = '30',
id_argoment_default = '71',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '19901'
20/01/2023 04:21:03 pm >> DELETE FROM ps_specific_price WHERE id_product = '19901'
20/01/2023 04:21:16 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788825054408' AND id_product != '19499' AND ean13 != ''
20/01/2023 04:21:16 pm >> UPDATE ps_product SET
id_supplier = '17',
reference = '6/4',
ean13 = '9788825054408',
date_upd = NOW()
WHERE id_product = '19499'
20/01/2023 04:21:16 pm >> UPDATE ps_product_lang SET
name = 'ROSARIA, GIASTIN E COSIMO GRAVINA',
description = ''
WHERE id_product = '19499'
20/01/2023 04:21:16 pm >> UPDATE ps_product SET
wholesale_price = '7.50',
on_sale = '0',
price = '15.0000'
WHERE id_product = '19499'
20/01/2023 04:21:16 pm >> UPDATE ps_product_shop SET
wholesale_price = '7.50',
price = '15.0000',
id_tax_rules_group = '4',
id_category_default = '17',
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 = '19499'
20/01/2023 04:21:16 pm >> DELETE FROM ps_specific_price WHERE id_product = '19499'
20/01/2023 04:26:06 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831554879' AND id_product != '19683' AND ean13 != ''
20/01/2023 04:26:06 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '6/3',
ean13 = '9788831554879',
date_upd = NOW()
WHERE id_product = '19683'
20/01/2023 04:26:06 pm >> UPDATE ps_product_lang SET
name = 'MASSIME ETERNE',
description = ''
WHERE id_product = '19683'
20/01/2023 04:26:06 pm >> UPDATE ps_product SET
wholesale_price = '5.03',
on_sale = '0',
price = '7.5000'
WHERE id_product = '19683'
20/01/2023 04:26:06 pm >> UPDATE ps_product_shop SET
wholesale_price = '5.03',
price = '7.5000',
id_tax_rules_group = '4',
id_category_default = '27',
id_argoment_default = '74',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '19683'
20/01/2023 04:26:06 pm >> DELETE FROM ps_specific_price WHERE id_product = '19683'
20/01/2023 04:26:37 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788873672692' AND id_product != '17671' AND ean13 != ''
20/01/2023 04:26:37 pm >> UPDATE ps_product SET
id_supplier = '107',
reference = '6/3',
ean13 = '9788873672692',
date_upd = NOW()
WHERE id_product = '17671'
20/01/2023 04:26:37 pm >> UPDATE ps_product_lang SET
name = 'MESSAGGIO DELLA MED. MIRACOLOSA - G. BURDESE',
description = ''
WHERE id_product = '17671'
20/01/2023 04:26:37 pm >> UPDATE ps_product SET
wholesale_price = '3.25',
on_sale = '0',
price = '5.0000'
WHERE id_product = '17671'
20/01/2023 04:26:37 pm >> UPDATE ps_product_shop SET
wholesale_price = '3.25',
price = '5.0000',
id_tax_rules_group = '4',
id_category_default = '380',
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 = '17671'
20/01/2023 04:26:37 pm >> DELETE FROM ps_specific_price WHERE id_product = '17671'
20/01/2023 04:27:36 pm >> UPDATE ps_product_shop SET
minimal_quantity = '1',
multiple_quantity = '1',
available_date = '',
date_upd = NOW()
WHERE id_product = '8786'
20/01/2023 04:27:36 pm >> UPDATE ps_stock_available SET quantity = quantity + '-1' WHERE id_product = '8786'
20/01/2023 04:27:45 pm >> UPDATE ps_product_shop SET
minimal_quantity = '1',
multiple_quantity = '1',
available_date = '',
date_upd = NOW()
WHERE id_product = '8786'
20/01/2023 04:27:45 pm >> UPDATE ps_stock_available SET quantity = quantity + '1' WHERE id_product = '8786'
20/01/2023 04:28:49 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788821596315' AND id_product != '3910' AND ean13 != ''
20/01/2023 04:28:49 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '6/3',
ean13 = '9788821596315',
date_upd = NOW()
WHERE id_product = '3910'
20/01/2023 04:28:49 pm >> UPDATE ps_product_lang SET
name = 'ESERCIZI SPIRITUALI DI SANT\'IGNAZIO',
description = ''
WHERE id_product = '3910'
20/01/2023 04:28:49 pm >> UPDATE ps_product SET
wholesale_price = '5.29',
on_sale = '0',
price = '7.9000'
WHERE id_product = '3910'
20/01/2023 04:28:49 pm >> UPDATE ps_product_shop SET
wholesale_price = '5.29',
price = '7.9000',
id_tax_rules_group = '4',
id_category_default = '30',
id_argoment_default = '',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '3910'
20/01/2023 04:28:49 pm >> DELETE FROM ps_specific_price WHERE id_product = '3910'
20/01/2023 04:29:27 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788862447898' AND id_product != '15896' AND ean13 != ''
20/01/2023 04:29:27 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '6/3',
ean13 = '9788862447898',
date_upd = NOW()
WHERE id_product = '15896'
20/01/2023 04:29:27 pm >> UPDATE ps_product_lang SET
name = 'SEGUIRE GESU\' INSIEME A SAN PIETRO - O. DE BERTOLIS',
description = ''
WHERE id_product = '15896'
20/01/2023 04:29:27 pm >> UPDATE ps_product SET
wholesale_price = '8.40',
on_sale = '0',
price = '12.0000'
WHERE id_product = '15896'
20/01/2023 04:29:27 pm >> UPDATE ps_product_shop SET
wholesale_price = '8.40',
price = '12.0000',
id_tax_rules_group = '4',
id_category_default = '267',
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 = '15896'
20/01/2023 04:29:27 pm >> DELETE FROM ps_specific_price WHERE id_product = '15896'
20/01/2023 04:30:26 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788827011348' AND id_product != '14982' AND ean13 != ''
20/01/2023 04:30:26 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '7/5',
ean13 = '9788827011348',
date_upd = NOW()
WHERE id_product = '14982'
20/01/2023 04:30:26 pm >> UPDATE ps_product_lang SET
name = 'NEL SILENZIO PARLAMI - F. DE LAZZARI',
description = ''
WHERE id_product = '14982'
20/01/2023 04:30:26 pm >> UPDATE ps_product SET
wholesale_price = '8.40',
on_sale = '0',
price = '12.0000'
WHERE id_product = '14982'
20/01/2023 04:30:26 pm >> UPDATE ps_product_shop SET
wholesale_price = '8.40',
price = '12.0000',
id_tax_rules_group = '4',
id_category_default = '186',
id_argoment_default = '41',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '14982'
20/01/2023 04:30:26 pm >> DELETE FROM ps_specific_price WHERE id_product = '14982'
20/01/2023 04:30:54 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788881350261' AND id_product != '4229' AND ean13 != ''
20/01/2023 04:30:54 pm >> UPDATE ps_product SET
id_supplier = '107',
reference = '6/3',
ean13 = '9788881350261',
date_upd = NOW()
WHERE id_product = '4229'
20/01/2023 04:30:54 pm >> UPDATE ps_product_lang SET
name = 'FONTI FRANCESCANE - ED. MINOR',
description = ''
WHERE id_product = '4229'
20/01/2023 04:30:54 pm >> UPDATE ps_product SET
wholesale_price = '22.40',
on_sale = '0',
price = '32.0000'
WHERE id_product = '4229'
20/01/2023 04:30:54 pm >> UPDATE ps_product_shop SET
wholesale_price = '22.40',
price = '32.0000',
id_tax_rules_group = '4',
id_category_default = '110',
id_argoment_default = '74',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '4229'
20/01/2023 04:30:54 pm >> DELETE FROM ps_specific_price WHERE id_product = '4229'
20/01/2023 04:33:16 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788886242646' AND id_product != '6657' AND ean13 != ''
20/01/2023 04:33:16 pm >> UPDATE ps_product SET
id_supplier = '',
reference = '6/3',
ean13 = '9788886242646',
date_upd = NOW()
WHERE id_product = '6657'
20/01/2023 04:33:16 pm >> UPDATE ps_product_lang SET
name = 'MIE LETTERE N.E. TERESA DI LISIEUX',
description = ''
WHERE id_product = '6657'
20/01/2023 04:33:16 pm >> UPDATE ps_product SET
wholesale_price = '5.20',
on_sale = '0',
price = '8.0000'
WHERE id_product = '6657'
20/01/2023 04:33:16 pm >> UPDATE ps_product_shop SET
wholesale_price = '5.20',
price = '8.0000',
id_tax_rules_group = '4',
id_category_default = '83',
id_argoment_default = '74',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '6657'
20/01/2023 04:33:16 pm >> DELETE FROM ps_specific_price WHERE id_product = '6657'
20/01/2023 04:34:24 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788873576143' AND id_product != '12588' AND ean13 != ''
20/01/2023 04:34:24 pm >> UPDATE ps_product SET
id_supplier = '65',
reference = '6/3',
ean13 = '9788873576143',
date_upd = NOW()
WHERE id_product = '12588'
20/01/2023 04:34:24 pm >> UPDATE ps_product_lang SET
name = 'QUANDO DIO NON PERDONA - S. SESSA',
description = ''
WHERE id_product = '12588'
20/01/2023 04:34:24 pm >> UPDATE ps_product SET
wholesale_price = '2.60',
on_sale = '0',
price = '4.0000'
WHERE id_product = '12588'
20/01/2023 04:34:24 pm >> UPDATE ps_product_shop SET
wholesale_price = '2.60',
price = '4.0000',
id_tax_rules_group = '4',
id_category_default = '178',
id_argoment_default = '41',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '12588'
20/01/2023 04:34:24 pm >> DELETE FROM ps_specific_price WHERE id_product = '12588'
20/01/2023 04:35:33 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788873672708' AND id_product != '17672' AND ean13 != ''
20/01/2023 04:35:33 pm >> UPDATE ps_product SET
id_supplier = '107',
reference = '6/3',
ean13 = '9788873672708',
date_upd = NOW()
WHERE id_product = '17672'
20/01/2023 04:35:33 pm >> UPDATE ps_product_lang SET
name = 'CATERINA LABOURE - E. ANTONELLO',
description = ''
WHERE id_product = '17672'
20/01/2023 04:35:33 pm >> UPDATE ps_product SET
wholesale_price = '3.25',
on_sale = '0',
price = '5.0000'
WHERE id_product = '17672'
20/01/2023 04:35:33 pm >> UPDATE ps_product_shop SET
wholesale_price = '3.25',
price = '5.0000',
id_tax_rules_group = '4',
id_category_default = '380',
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 = '17672'
20/01/2023 04:35:33 pm >> DELETE FROM ps_specific_price WHERE id_product = '17672'
20/01/2023 04:37:54 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788821574986' AND id_product != '8702' AND ean13 != ''
20/01/2023 04:37:54 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '6/3',
ean13 = '9788821574986',
date_upd = NOW()
WHERE id_product = '8702'
20/01/2023 04:37:54 pm >> UPDATE ps_product_lang SET
name = 'QUANDO IL MAESTRO PARLA AL CUORE - G. COURTOIS',
description = ''
WHERE id_product = '8702'
20/01/2023 04:37:54 pm >> UPDATE ps_product SET
wholesale_price = '9.38',
on_sale = '0',
price = '14.0000'
WHERE id_product = '8702'
20/01/2023 04:37:54 pm >> UPDATE ps_product_shop SET
wholesale_price = '9.38',
price = '14.0000',
id_tax_rules_group = '4',
id_category_default = '82',
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 = '8702'
20/01/2023 04:37:54 pm >> DELETE FROM ps_specific_price WHERE id_product = '8702'
20/01/2023 04:38:27 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788820927264' AND id_product != '3225' AND ean13 != ''
20/01/2023 04:38:27 pm >> UPDATE ps_product SET
id_supplier = '79',
reference = '6/3',
ean13 = '9788820927264',
date_upd = NOW()
WHERE id_product = '3225'
20/01/2023 04:38:27 pm >> UPDATE ps_product_lang SET
name = 'CUORE DI GESÙ AL MONDO',
description = ''
WHERE id_product = '3225'
20/01/2023 04:38:27 pm >> UPDATE ps_product SET
wholesale_price = '6.05',
on_sale = '0',
price = '11.0000'
WHERE id_product = '3225'
20/01/2023 04:38:27 pm >> UPDATE ps_product_shop SET
wholesale_price = '6.05',
price = '11.0000',
id_tax_rules_group = '4',
id_category_default = '104',
id_argoment_default = '74',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '3225'
20/01/2023 04:38:27 pm >> DELETE FROM ps_specific_price WHERE id_product = '3225'
20/01/2023 04:39:16 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788872983348' AND id_product != '19058' AND ean13 != ''
20/01/2023 04:39:16 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '6/4',
ean13 = '9788872983348',
date_upd = NOW()
WHERE id_product = '19058'
20/01/2023 04:39:16 pm >> UPDATE ps_product_lang SET
name = 'ROSARIO LIVATINO, IL GIUDICE GIUSTO - D. MARIA',
description = ''
WHERE id_product = '19058'
20/01/2023 04:39:16 pm >> UPDATE ps_product SET
wholesale_price = '4.90',
on_sale = '0',
price = '7.0000'
WHERE id_product = '19058'
20/01/2023 04:39:16 pm >> UPDATE ps_product_shop SET
wholesale_price = '4.90',
price = '7.0000',
id_tax_rules_group = '4',
id_category_default = '29',
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 = '19058'
20/01/2023 04:39:16 pm >> DELETE FROM ps_specific_price WHERE id_product = '19058'
20/01/2023 04:41:23 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831554473' AND id_product != '18923' AND ean13 != ''
20/01/2023 04:41:23 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '6/3',
ean13 = '9788831554473',
date_upd = NOW()
WHERE id_product = '18923'
20/01/2023 04:41:23 pm >> UPDATE ps_product_lang SET
name = 'CI SARANNO SANTI TRA I BAMBINI',
description = ''
WHERE id_product = '18923'
20/01/2023 04:41:23 pm >> UPDATE ps_product SET
wholesale_price = '7.37',
on_sale = '0',
price = '11.0000'
WHERE id_product = '18923'
20/01/2023 04:41:23 pm >> UPDATE ps_product_shop SET
wholesale_price = '7.37',
price = '11.0000',
id_tax_rules_group = '4',
id_category_default = '27',
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 = '18923'
20/01/2023 04:41:23 pm >> DELETE FROM ps_specific_price WHERE id_product = '18923'
20/01/2023 04:41:39 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788873575979' AND id_product != '9759' AND ean13 != ''
20/01/2023 04:41:39 pm >> UPDATE ps_product SET
id_supplier = '109',
reference = '6/3',
ean13 = '9788873575979',
date_upd = NOW()
WHERE id_product = '9759'
20/01/2023 04:41:39 pm >> UPDATE ps_product_lang SET
name = 'SCRITTI SPIRITUALI - S. MARGHERITA M. ALACOQUE',
description = ''
WHERE id_product = '9759'
20/01/2023 04:41:39 pm >> UPDATE ps_product SET
wholesale_price = '10.50',
on_sale = '0',
price = '15.0000'
WHERE id_product = '9759'
20/01/2023 04:41:39 pm >> UPDATE ps_product_shop SET
wholesale_price = '10.50',
price = '15.0000',
id_tax_rules_group = '4',
id_category_default = '178',
id_argoment_default = '41',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '9759'
20/01/2023 04:41:39 pm >> DELETE FROM ps_specific_price WHERE id_product = '9759'
20/01/2023 04:41:52 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788821595271' AND id_product != '8864' AND ean13 != ''
20/01/2023 04:41:52 pm >> UPDATE ps_product SET
id_supplier = '',
reference = '6/3',
ean13 = '9788821595271',
date_upd = NOW()
WHERE id_product = '8864'
20/01/2023 04:41:52 pm >> UPDATE ps_product_lang SET
name = 'REGOLA - B.DA NORCIA',
description = ''
WHERE id_product = '8864'
20/01/2023 04:41:52 pm >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '7.9000'
WHERE id_product = '8864'
20/01/2023 04:41:52 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '7.9000',
id_tax_rules_group = '4',
id_category_default = '30',
id_argoment_default = '74',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '8864'
20/01/2023 04:41:52 pm >> DELETE FROM ps_specific_price WHERE id_product = '8864'
20/01/2023 04:42:59 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831552196' AND id_product != '17449' AND ean13 != ''
20/01/2023 04:42:59 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '6/3',
ean13 = '9788831552196',
date_upd = NOW()
WHERE id_product = '17449'
20/01/2023 04:42:59 pm >> UPDATE ps_product_lang SET
name = 'GESU\' FIGLIO DELL\'UOMO - K. GIBRAN',
description = ''
WHERE id_product = '17449'
20/01/2023 04:42:59 pm >> UPDATE ps_product SET
wholesale_price = '9.38',
on_sale = '0',
price = '14.0000'
WHERE id_product = '17449'
20/01/2023 04:42:59 pm >> UPDATE ps_product_shop SET
wholesale_price = '9.38',
price = '14.0000',
id_tax_rules_group = '4',
id_category_default = '27',
id_argoment_default = '41',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '17449'
20/01/2023 04:42:59 pm >> DELETE FROM ps_specific_price WHERE id_product = '17449'
20/01/2023 04:43:39 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831552196' AND id_product != '17449' AND ean13 != ''
20/01/2023 04:43:39 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '7/5',
ean13 = '9788831552196',
date_upd = NOW()
WHERE id_product = '17449'
20/01/2023 04:43:39 pm >> UPDATE ps_product_lang SET
name = 'GESU\' FIGLIO DELL\'UOMO - K. GIBRAN',
description = ''
WHERE id_product = '17449'
20/01/2023 04:43:40 pm >> UPDATE ps_product SET
wholesale_price = '9.38',
on_sale = '0',
price = '14.0000'
WHERE id_product = '17449'
20/01/2023 04:43:40 pm >> UPDATE ps_product_shop SET
wholesale_price = '9.38',
price = '14.0000',
id_tax_rules_group = '4',
id_category_default = '27',
id_argoment_default = '41',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '17449'
20/01/2023 04:43:40 pm >> DELETE FROM ps_specific_price WHERE id_product = '17449'
20/01/2023 04:47:37 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788872982495' AND id_product != '17512' AND ean13 != ''
20/01/2023 04:47:37 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '6/2',
ean13 = '9788872982495',
date_upd = NOW()
WHERE id_product = '17512'
20/01/2023 04:47:37 pm >> UPDATE ps_product_lang SET
name = 'SAN DOMENICO ABATE - VITA BREVIS',
description = ''
WHERE id_product = '17512'
20/01/2023 04:47:37 pm >> UPDATE ps_product SET
wholesale_price = '1.40',
on_sale = '0',
price = '2.0000'
WHERE id_product = '17512'
20/01/2023 04:47:37 pm >> UPDATE ps_product_shop SET
wholesale_price = '1.40',
price = '2.0000',
id_tax_rules_group = '4',
id_category_default = '29',
id_argoment_default = '53',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '17512'
20/01/2023 04:47:37 pm >> DELETE FROM ps_specific_price WHERE id_product = '17512'
20/01/2023 04:47:49 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788872982587' AND id_product != '17366' AND ean13 != ''
20/01/2023 04:47:49 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '6/2',
ean13 = '9788872982587',
date_upd = NOW()
WHERE id_product = '17366'
20/01/2023 04:47:49 pm >> UPDATE ps_product_lang SET
name = 'SANTA TERESA DI LISIEUX ',
description = ''
WHERE id_product = '17366'
20/01/2023 04:47:49 pm >> UPDATE ps_product SET
wholesale_price = '2.45',
on_sale = '0',
price = '3.5000'
WHERE id_product = '17366'
20/01/2023 04:47:49 pm >> UPDATE ps_product_shop SET
wholesale_price = '2.45',
price = '3.5000',
id_tax_rules_group = '4',
id_category_default = '29',
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 = '17366'
20/01/2023 04:47:49 pm >> DELETE FROM ps_specific_price WHERE id_product = '17366'
20/01/2023 04:48:01 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791259750389' AND id_product != '18603' AND ean13 != ''
20/01/2023 04:48:01 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '6/2',
ean13 = '9791259750389',
date_upd = NOW()
WHERE id_product = '18603'
20/01/2023 04:48:01 pm >> UPDATE ps_product_lang SET
name = 'SANTA TERESA D\'AVILA - G. MAZZOTTA',
description = ''
WHERE id_product = '18603'
20/01/2023 04:48:01 pm >> UPDATE ps_product SET
wholesale_price = '7.00',
on_sale = '0',
price = '10.0000'
WHERE id_product = '18603'
20/01/2023 04:48:01 pm >> UPDATE ps_product_shop SET
wholesale_price = '7.00',
price = '10.0000',
id_tax_rules_group = '4',
id_category_default = '267',
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 = '18603'
20/01/2023 04:48:01 pm >> DELETE FROM ps_specific_price WHERE id_product = '18603'
20/01/2023 04:48:42 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884045713' AND id_product != '15802' AND ean13 != ''
20/01/2023 04:48:42 pm >> UPDATE ps_product SET
id_supplier = '38',
reference = '11/6',
ean13 = '9788884045713',
date_upd = NOW()
WHERE id_product = '15802'
20/01/2023 04:48:42 pm >> UPDATE ps_product_lang SET
name = 'VITA DI GESU\' CRISTO - MEDITAZIONI VANGELI - COF. 2 VOL. - 8937',
description = ''
WHERE id_product = '15802'
20/01/2023 04:48:42 pm >> UPDATE ps_product SET
wholesale_price = '14.40',
on_sale = '0',
price = '24.0000'
WHERE id_product = '15802'
20/01/2023 04:48:42 pm >> UPDATE ps_product_shop SET
wholesale_price = '14.40',
price = '24.0000',
id_tax_rules_group = '4',
id_category_default = '106',
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 = '15802'
20/01/2023 04:48:42 pm >> DELETE FROM ps_specific_price WHERE id_product = '15802'
20/01/2023 04:49:09 pm >> UPDATE ps_product_shop SET
minimal_quantity = '1',
multiple_quantity = '1',
available_date = '',
date_upd = NOW()
WHERE id_product = '15064'
20/01/2023 04:49:09 pm >> UPDATE ps_stock_available SET quantity = quantity + '1' WHERE id_product = '15064'
20/01/2023 04:50:10 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788895983783' AND id_product != '18175' AND ean13 != ''
20/01/2023 04:50:10 pm >> UPDATE ps_product SET
id_supplier = '145',
reference = '6/3',
ean13 = '9788895983783',
date_upd = NOW()
WHERE id_product = '18175'
20/01/2023 04:50:10 pm >> UPDATE ps_product_lang SET
name = 'VIA DI SAN GIUSEPPE - G. POLIDORO',
description = 'Collana: CAMMINO VERSO LA SANTITA\'.
Il testo è costituito da due parti: la prima, intende supplire ad una carenza di informazioni storiche sulla vita di San Giuseppe.
La seconda, segue le indicazioni evangeliche con considerazioni che potranno offrire una maggiore comprensione della missione del santo.
'
WHERE id_product = '18175'
20/01/2023 04:50:10 pm >> UPDATE ps_product SET
wholesale_price = '1.20',
on_sale = '0',
price = '4.8000'
WHERE id_product = '18175'
20/01/2023 04:50:10 pm >> UPDATE ps_product_shop SET
wholesale_price = '1.20',
price = '4.8000',
id_tax_rules_group = '4',
id_category_default = '395',
id_argoment_default = '23',
id_internal_category = '4',
on_sale = '0',
on_showcase = '1',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '18175'
20/01/2023 04:50:10 pm >> DELETE FROM ps_specific_price WHERE id_product = '18175'
20/01/2023 04:50:10 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' , '18175' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' )
20/01/2023 06:48:00 pm >> SELECT document_num FROM ps_document
WHERE document_num = '213' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-20')
20/01/2023 06:48:00 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' ,
'213' ,
'2023-01-20' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'15.00' ,
'12.30' ,
NOW() ,
NOW() )
20/01/2023 06:48:00 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 = '80449'
20/01/2023 06:48:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '80449'
20/01/2023 06:48:00 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '80449' , '6403' , 'MENSA BIANCA 80X150 ' , '2' , '-2' , '1' ,
'7.50' , '6.1475409836066' , '22' , '0' , '15.00' )
20/01/2023 06:55:54 pm >> SELECT document_num FROM ps_document
WHERE document_num = '2' AND id_document != '78129' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-02')
20/01/2023 06:55:54 pm >> UPDATE ps_document SET
id_document_type = '11',
document_num = '2',
document_date = '2023-01-02',
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 = '170.00',
price_tax_excluded = '143.32',
date_upd = NOW()
WHERE id_document = '78129'
20/01/2023 06:55:54 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '78129'
20/01/2023 06:55:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '78129'
20/01/2023 06:55:54 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '78129' , '2164' , 'CLERGY BASIC EXTRA - ML - B&P' , '1' , '-1' , '1' ,
'19.0000' , '15.573770491803' , '22' , '0' , '19.00' )
20/01/2023 06:55:54 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '78129' , '20578' , 'TOTUM AMORIS EST ' , '2' , '-2' , '4' ,
'2.0000' , '2' , '0' , '0' , '4.00' )
20/01/2023 06:55:54 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '78129' , '18809' , 'TEMPO DI NATALE - G. SACINO' , '1' , '-1' , '4' ,
'10.0000' , '10' , '0' , '5' , '9.50' )
20/01/2023 06:55:54 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '78129' , '20488' , 'CHIESA E VIVA - J. RATZINGER' , '1' , '-1' , '4' ,
'9.0000' , '9' , '0' , '5' , '8.55' )
20/01/2023 06:55:54 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '78129' , '20000' , 'GESU BAMBINO CM 15 - BJ140-15E' , '1' , '-1' , '1' ,
'12.0000' , '9.8360655737705' , '22' , '0' , '12.00' )
20/01/2023 06:55:54 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '78129' , '19999' , 'GESU BAMBINO CON AUREOLA CM 15 - BJ148-15' , '1' , '-1' , '1' ,
'12.0000' , '9.8360655737705' , '22' , '0' , '12.00' )
20/01/2023 06:55:54 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '78129' , '13134' , 'BAMBINO GESU BETLEMME - OCCHI DI VETRO - P514' , '1' , '-1' , '1' ,
'14.0000' , '11.475409836066' , '22' , '0' , '14.00' )
20/01/2023 06:55:54 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '78129' , '16328' , 'GRUPPO NATIVITA CM 20 - PB14890' , '1' , '-1' , '1' ,
'19.0000' , '15.573770491803' , '22' , '0' , '19.00' )
20/01/2023 06:55:54 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '78129' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' ,
'40' , '32.786885245902' , '22' , '0' , '40.00' )
20/01/2023 06:55:54 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '78129' , '18046' , 'TECA PLACCA SMALTATA - 504' , '1' , '-1' , '1' ,
'31.95' , '26.188524590164' , '22' , '0' , '31.95' )