23/01/2023 09:03:29 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() )
23/01/2023 09:03:29 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20633' , '1' , '' , 'nuovo-prodotto' )
23/01/2023 09:03:29 am >> INSERT INTO ps_product_shop (
id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd`
) VALUES (
'20633' , '1' , '1' , '2' , NOW() , NOW()
)
23/01/2023 09:03:29 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '20633' , '0' , '1' , '0' , '0' )
23/01/2023 09:08:19 am >> SELECT document_num FROM ps_document
WHERE document_num = '177' AND id_document != '79370' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-17')
23/01/2023 09:08:19 am >> UPDATE ps_document SET
id_document_type = '11',
document_num = '177',
document_date = '2023-01-17',
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 = '50.80',
price_tax_excluded = '47.30',
date_upd = NOW()
WHERE id_document = '79370'
23/01/2023 09:08: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 = '79370'
23/01/2023 09:08:19 am >> DELETE FROM ps_document_detail WHERE id_document = '79370'
23/01/2023 09:08: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
( '79370' , '20620' , 'OMELIE DI PENTLING' , '1' , '-1' , '4' ,
'12.0000' , '12' , '0' , '5' , '11.40' )
23/01/2023 09:08: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
( '79370' , '11151' , 'LIBRI' , '1' , '-1' , '4' ,
'5.75' , '5.75' , '0' , '0' , '5.75' )
23/01/2023 09:08: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
( '79370' , '17784' , 'MEDAGLIA S. BENEDETTO MET. OX - Q 1010-OX' , '1' , '-1' , '1' ,
'16.9000' , '13.852459016393' , '22' , '0' , '16.90' )
23/01/2023 09:08: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
( '79370' , '7924' , 'PERGAMENE - BATTESIMO MOD. A' , '5' , '-5' , '1' ,
'0.5000' , '0.40983606557377' , '22' , '0' , '2.50' )
23/01/2023 09:08: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
( '79370' , '18942' , 'DI DOMENICA, UNA PAROLA - ANNO C - E. ABBATTISTA' , '1' , '-1' , '4' ,
'15.00' , '15' , '0' , '5' , '14.25' )
23/01/2023 09:13:49 am >> SELECT document_num FROM ps_document
WHERE document_num = '170' AND id_document != '79361' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-16')
23/01/2023 09:13:49 am >> UPDATE ps_document SET
id_document_type = '11',
document_num = '170',
document_date = '2023-01-16',
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 = '39.00',
price_tax_excluded = '39.00',
date_upd = NOW()
WHERE id_document = '79361'
23/01/2023 09:13:49 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 = '79361'
23/01/2023 09:13:49 am >> DELETE FROM ps_document_detail WHERE id_document = '79361'
23/01/2023 09:13:49 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
( '79361' , '17488' , 'STELLA IL CAMMINO IL BAMBINO - L. EPICOCO' , '1' , '-1' , '4' ,
'15.0000' , '15' , '0' , '5' , '14.25' )
23/01/2023 09:13:49 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
( '79361' , '17966' , 'DEI VIZI E DELLE VIRTU - PAPA FRANCESCO' , '1' , '-1' , '4' ,
'16.0000' , '16' , '0' , '5' , '15.20' )
23/01/2023 09:13:49 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
( '79361' , '19138' , 'ATTO DI ABBANDONO - D. D. RUOTOLO' , '1' , '-1' , '4' ,
'1.0000' , '1' , '0' , '5' , '0.95' )
23/01/2023 09:13:49 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
( '79361' , '15032' , 'ABBRACCIO BENEDICENTE - H. NOUWEN' , '1' , '-1' , '4' ,
'8.60' , '8.6' , '0' , '0' , '8.60' )
23/01/2023 09:15:31 am >> DELETE FROM ps_product WHERE id_product = '330'
23/01/2023 09:15:31 am >> DELETE FROM ps_product_shop WHERE id_product = '330'
23/01/2023 09:15:31 am >> DELETE FROM ps_product_lang WHERE id_product = '330'
23/01/2023 09:15:31 am >> DELETE FROM ps_stock_available WHERE id_product = '330'
23/01/2023 09:23:08 am >> UPDATE ps_product_shop SET
minimal_quantity = '1',
multiple_quantity = '1',
available_date = '',
date_upd = NOW()
WHERE id_product = '657'
23/01/2023 09:23:08 am >> UPDATE ps_stock_available SET quantity = quantity + '-1' WHERE id_product = '657'
23/01/2023 09:23:13 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788821576812' AND id_product != '657' AND ean13 != ''
23/01/2023 09:23:13 am >> UPDATE ps_product SET
id_supplier = '',
reference = '1/1',
ean13 = '9788821576812',
date_upd = NOW()
WHERE id_product = '657'
23/01/2023 09:23:13 am >> UPDATE ps_product_lang SET
name = 'ANNO DELLA FEDE - ANNO DELLA FEDE',
description = ''
WHERE id_product = '657'
23/01/2023 09:23:13 am >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '4.9000'
WHERE id_product = '657'
23/01/2023 09:23:13 am >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '4.9000',
id_tax_rules_group = '4',
id_category_default = '30',
id_argoment_default = '22',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '657'
23/01/2023 09:23:13 am >> DELETE FROM ps_specific_price WHERE id_product = '657'
23/01/2023 09:27:26 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788820988692' AND id_product != '1820' AND ean13 != ''
23/01/2023 09:27:26 am >> UPDATE ps_product SET
id_supplier = '',
reference = '1/1',
ean13 = '9788820988692',
date_upd = NOW()
WHERE id_product = '1820'
23/01/2023 09:27:26 am >> UPDATE ps_product_lang SET
name = 'CATECHISMO DELLA CHIESA CATTOLICA',
description = ''
WHERE id_product = '1820'
23/01/2023 09:27:26 am >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '10.0000'
WHERE id_product = '1820'
23/01/2023 09:27:26 am >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '10.0000',
id_tax_rules_group = '4',
id_category_default = '104',
id_argoment_default = '22',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '1820'
23/01/2023 09:27:26 am >> DELETE FROM ps_specific_price WHERE id_product = '1820'
23/01/2023 09:27:26 am >> INSERT INTO ps_specific_price
( id_specific_price_rule , id_cart , id_product , id_shop , id_shop_group , id_currency , id_country , id_group , id_customer , id_product_attribute , price , from_quantity , reduction , reduction_tax , reduction_type , `from` , `to`)
VALUES
( '0' , '0' , '1820' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.1' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' )
23/01/2023 09:27:35 am >> UPDATE ps_product_shop SET
minimal_quantity = '1',
multiple_quantity = '1',
available_date = '',
date_upd = NOW()
WHERE id_product = '1820'
23/01/2023 09:27:35 am >> UPDATE ps_stock_available SET quantity = quantity + '-5' WHERE id_product = '1820'
23/01/2023 09:29:22 am >> SELECT document_num FROM ps_document
WHERE document_num = '83' AND id_document != '78221' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-09')
23/01/2023 09:29:22 am >> UPDATE ps_document SET
id_document_type = '11',
document_num = '83',
document_date = '2023-01-09',
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 = '69.50',
price_tax_excluded = '61.39',
date_upd = NOW()
WHERE id_document = '78221'
23/01/2023 09:29:22 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 = '78221'
23/01/2023 09:29:22 am >> DELETE FROM ps_document_detail WHERE id_document = '78221'
23/01/2023 09:29:22 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
( '78221' , '19996' , 'GESU BAMBINO CM 34 - BJ142-34E' , '1' , '-1' , '1' ,
'45.0000' , '36.885245901639' , '22' , '0' , '45.00' )
23/01/2023 09:29:22 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
( '78221' , '7098' , 'NOVENA A MARIA CHE SCIOGLIE I NODI - 8558' , '2' , '-2' , '4' ,
'2.5000' , '2.5' , '0' , '0' , '5.00' )
23/01/2023 09:29:22 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
( '78221' , '15996' , 'TELEMACO NON SI SBAGLIAVA - L. EPICOCO' , '1' , '-1' , '4' ,
'16.0000' , '16' , '0' , '5' , '15.20' )
23/01/2023 09:29:22 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
( '78221' , '14649' , 'COMPENDIO AL CATECHISMO DI PIO X' , '1' , '-1' , '4' ,
'1.5' , '1.5' , '0' , '0' , '1.50' )
23/01/2023 09:29:22 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
( '78221' , '15746' , 'ADORIAMO IL SS SACRAMENTO - VOL 1 - 8958' , '1' , '-1' , '4' ,
'2.8000' , '2.8' , '0' , '' , '2.80' )
23/01/2023 09:31:04 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892222632' AND id_product != '17073' AND ean13 != ''
23/01/2023 09:31:04 am >> UPDATE ps_product SET
id_supplier = '7',
reference = '1/1',
ean13 = '9788892222632',
date_upd = NOW()
WHERE id_product = '17073'
23/01/2023 09:31:04 am >> UPDATE ps_product_lang SET
name = 'DIRETTORIO PER LA CATECHESI',
description = ''
WHERE id_product = '17073'
23/01/2023 09:31:04 am >> UPDATE ps_product SET
wholesale_price = '10.72',
on_sale = '0',
price = '16.0000'
WHERE id_product = '17073'
23/01/2023 09:31:04 am >> UPDATE ps_product_shop SET
wholesale_price = '10.72',
price = '16.0000',
id_tax_rules_group = '4',
id_category_default = '30',
id_argoment_default = '22',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '17073'
23/01/2023 09:31:04 am >> DELETE FROM ps_specific_price WHERE id_product = '17073'
23/01/2023 09:35:27 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788870947175' AND id_product != '9314' AND ean13 != ''
23/01/2023 09:35:27 am >> UPDATE ps_product SET
id_supplier = '',
reference = '1/1',
ean13 = '9788870947175',
date_upd = NOW()
WHERE id_product = '9314'
23/01/2023 09:35:27 am >> UPDATE ps_product_lang SET
name = 'SACRAMENTO DELLA CONFERMAZIONE',
description = ''
WHERE id_product = '9314'
23/01/2023 09:35:27 am >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '9.0000'
WHERE id_product = '9314'
23/01/2023 09:35:27 am >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '9.0000',
id_tax_rules_group = '4',
id_category_default = '77',
id_argoment_default = '22',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '9314'
23/01/2023 09:35:27 am >> DELETE FROM ps_specific_price WHERE id_product = '9314'
23/01/2023 09:35:41 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788870947342' AND id_product != '7999' AND ean13 != ''
23/01/2023 09:35:41 am >> UPDATE ps_product SET
id_supplier = '',
reference = '1/1',
ean13 = '9788870947342',
date_upd = NOW()
WHERE id_product = '7999'
23/01/2023 09:35:41 am >> UPDATE ps_product_lang SET
name = 'PICCOLO CATECHISMO SUL SACRAMENTO DELLA PENITENZA',
description = ''
WHERE id_product = '7999'
23/01/2023 09:35:41 am >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '9.0000'
WHERE id_product = '7999'
23/01/2023 09:35:41 am >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '9.0000',
id_tax_rules_group = '4',
id_category_default = '77',
id_argoment_default = '22',
id_internal_category = '',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '7999'
23/01/2023 09:35:41 am >> DELETE FROM ps_specific_price WHERE id_product = '7999'
23/01/2023 09:35:45 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788870947342' AND id_product != '7999' AND ean13 != ''
23/01/2023 09:35:45 am >> UPDATE ps_product SET
id_supplier = '',
reference = '1/1',
ean13 = '9788870947342',
date_upd = NOW()
WHERE id_product = '7999'
23/01/2023 09:35:45 am >> UPDATE ps_product_lang SET
name = 'PICCOLO CATECHISMO SUL SACRAMENTO DELLA PENITENZA',
description = ''
WHERE id_product = '7999'
23/01/2023 09:35:45 am >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '9.0000'
WHERE id_product = '7999'
23/01/2023 09:35:45 am >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '9.0000',
id_tax_rules_group = '4',
id_category_default = '77',
id_argoment_default = '22',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '7999'
23/01/2023 09:35:45 am >> DELETE FROM ps_specific_price WHERE id_product = '7999'
23/01/2023 09:51:26 am >> SELECT document_num FROM ps_document
WHERE document_num = '181' AND id_document != '79375' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-17')
23/01/2023 09:51:26 am >> UPDATE ps_document SET
id_document_type = '11',
document_num = '181',
document_date = '2023-01-17',
document_letter = '',
id_customer = '0',
id_supplier = '',
id_address = '0',
address1 = '',
address2 = '',
note = '',
price_shipping = '0.00',
id_tax_shipping_rules = '4',
colli = '0',
peso = '0',
porto_e_imballo = '0',
mezzo_consegna = '',
id_payment = '0',
id_causal = '0',
price_tax_included = '35.00',
price_tax_excluded = '35.00',
date_upd = NOW()
WHERE id_document = '79375'
23/01/2023 09:51:26 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '79375'
23/01/2023 09:51:26 am >> DELETE FROM ps_document_detail WHERE id_document = '79375'
23/01/2023 09:51:26 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '79375' , '11151' , 'LIBRI' , '1' , '-1' , '4' ,
'19.8' , '19.8' , '0' , '0' , '19.80' )
23/01/2023 09:51:26 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '79375' , '20475' , '50 DOMANDE A DIO - G. BIADER' , '1' , '-1' , '4' ,
'16.00' , '16' , '0' , '5' , '15.20' )
23/01/2023 09:56:40 am >> SELECT document_num FROM ps_document
WHERE document_num = '77' AND id_document != '78215' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-09')
23/01/2023 09:56:40 am >> UPDATE ps_document SET
id_document_type = '11',
document_num = '77',
document_date = '2023-01-09',
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 = '6.03',
price_tax_excluded = '5.54',
date_upd = NOW()
WHERE id_document = '78215'
23/01/2023 09:56:40 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '78215'
23/01/2023 09:56:40 am >> DELETE FROM ps_document_detail WHERE id_document = '78215'
23/01/2023 09:56:40 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '78215' , '14111' , 'BATTESIMO SPIEGATO AI BAMBINI' , '1' , '-1' , '4' ,
'3.5000' , '3.5' , '0' , '5' , '3.33' )
23/01/2023 09:56:40 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '78215' , '4697' , 'GLORIA MISCELA 25G - GLORE' , '1' , '-1' , '1' ,
'1.5000' , '1.2295081967213' , '22' , '0' , '1.50' )
23/01/2023 09:56:40 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '78215' , '15483' , 'CROCE - 075 ALV' , '1' , '-1' , '1' ,
'1.20' , '0.98360655737705' , '22' , '0' , '1.20' )
23/01/2023 09:59:57 am >> DELETE FROM ps_product WHERE id_product = '237'
23/01/2023 09:59:57 am >> DELETE FROM ps_product_shop WHERE id_product = '237'
23/01/2023 09:59:57 am >> DELETE FROM ps_product_lang WHERE id_product = '237'
23/01/2023 09:59:57 am >> DELETE FROM ps_stock_available WHERE id_product = '237'
23/01/2023 10:04:49 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 (
'32' ,
'6022270617' ,
'2022-06-30' ,
'' ,
'0' ,
'109' ,
'4669106' ,
'VIA G. VERDI, 8 20090 ASSAGO' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'17.57' ,
'17.57' ,
NOW() ,
NOW() )
23/01/2023 10:04:49 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 = '80463'
23/01/2023 10:04:49 am >> DELETE FROM ps_document_detail WHERE id_document = '80463'
23/01/2023 10:04:49 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
( '80463' , '19632' , 'CATECHETICA - L. MEDDI' , '1' , '0' , '4' ,
'17.57' , '17.57' , '0' , '0' , '17.5700' )
23/01/2023 10:04:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '19632' AND id_supplier = '109'
23/01/2023 10:04:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19632' , '109' , '1' )
23/01/2023 10:05:18 am >> DELETE FROM ps_document WHERE id_document = '59089'
23/01/2023 10:05:18 am >> DELETE FROM ps_document_detail WHERE id_document = '59089'
23/01/2023 10:06:35 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 (
'32' ,
'6022270615' ,
'2023-01-23' ,
'' ,
'0' ,
'109' ,
'4669106' ,
'VIA G. VERDI, 8 20090 ASSAGO' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'23.93' ,
'23.93' ,
NOW() ,
NOW() )
23/01/2023 10:06: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 = '80464'
23/01/2023 10:06:35 am >> DELETE FROM ps_document_detail WHERE id_document = '80464'
23/01/2023 10:06: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
( '80464' , '19633' , 'CANTICO DEI CANTICI - G. RAVASI' , '1' , '0' , '4' ,
'23.93' , '23.93' , '0' , '0' , '23.9300' )
23/01/2023 10:06:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '19633' AND id_supplier = '109'
23/01/2023 10:06:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19633' , '109' , '1' )
23/01/2023 10:06:45 am >> DELETE FROM ps_document WHERE id_document = '59090'
23/01/2023 10:06:45 am >> DELETE FROM ps_document_detail WHERE id_document = '59090'
23/01/2023 10:07:57 am >> DELETE FROM ps_document WHERE id_document = '51047'
23/01/2023 10:07:57 am >> DELETE FROM ps_document_detail WHERE id_document = '51047'
23/01/2023 10:08:24 am >> DELETE FROM ps_document WHERE id_document = '32522'
23/01/2023 10:08:24 am >> DELETE FROM ps_document_detail WHERE id_document = '32522'
23/01/2023 10:10:44 am >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'33' ,
'7976' ,
'2021-01-13' ,
'' ,
'0' ,
'109' ,
'4669106' ,
'VIA G. VERDI, 8 20090 ASSAGO' ,
'' ,
'' ,
'0.00' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'184.80' ,
'184.80' ,
NOW() ,
NOW() )
23/01/2023 10:10:44 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '80465'
23/01/2023 10:10:44 am >> DELETE FROM ps_document_detail WHERE id_document = '80465'
23/01/2023 10:10:44 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '80465' , '17702' , 'BENEDETTO XVI - P. SEEWALD' , '2' , '2' , '4' ,
'40.0000' , '40' , '0' , '0' , '80.00' )
23/01/2023 10:10:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '17702' AND id_supplier = '109'
23/01/2023 10:10:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17702' , '109' , '1' )
23/01/2023 10:10:44 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '80465' , '17722' , 'CHIARA LUBICH, LAMORE VINCE TUTTO - A. GAGLIARDUCCI' , '2' , '2' , '4' ,
'13.9000' , '13.9' , '0' , '0' , '27.80' )
23/01/2023 10:10:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '17722' AND id_supplier = '109'
23/01/2023 10:10:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17722' , '109' , '1' )
23/01/2023 10:10:44 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '80465' , '16520' , 'CHIARA LUBICH' , '1' , '1' , '4' ,
'19.0000' , '19' , '0' , '0' , '19.00' )
23/01/2023 10:10:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '16520' AND id_supplier = '109'
23/01/2023 10:10:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16520' , '109' , '1' )
23/01/2023 10:10:44 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '80465' , '17721' , 'IPOTESI SU DIO - R.G. TIMOSSI' , '1' , '1' , '4' ,
'16.0000' , '16' , '0' , '0' , '16.00' )
23/01/2023 10:10:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '17721' AND id_supplier = '109'
23/01/2023 10:10:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17721' , '109' , '1' )
23/01/2023 10:10:44 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '80465' , '17723' , 'STORIA E NARRATIVA - AAVV' , '1' , '1' , '4' ,
'42.0000' , '42' , '0' , '0' , '42.00' )
23/01/2023 10:10:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '17723' AND id_supplier = '109'
23/01/2023 10:10:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17723' , '109' , '1' )
23/01/2023 10:10:56 am >> DELETE FROM ps_document WHERE id_document = '26944'
23/01/2023 10:10:56 am >> DELETE FROM ps_document_detail WHERE id_document = '26944'
23/01/2023 10:12:26 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788861247925' AND id_product != '16077' AND ean13 != ''
23/01/2023 10:12:26 am >> UPDATE ps_product SET
id_supplier = '7',
reference = '2/3',
ean13 = '9788861247925',
date_upd = NOW()
WHERE id_product = '16077'
23/01/2023 10:12:26 am >> UPDATE ps_product_lang SET
name = 'CELEBRAZIONI PER IL CATECHISMO',
description = ''
WHERE id_product = '16077'
23/01/2023 10:12:26 am >> UPDATE ps_product SET
wholesale_price = '4.83',
on_sale = '0',
price = '6.9000'
WHERE id_product = '16077'
23/01/2023 10:12:26 am >> UPDATE ps_product_shop SET
wholesale_price = '4.83',
price = '6.9000',
id_tax_rules_group = '4',
id_category_default = '26',
id_argoment_default = '22',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '16077'
23/01/2023 10:12:26 am >> DELETE FROM ps_specific_price WHERE id_product = '16077'
23/01/2023 10:14:26 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788869294341' AND id_product != '15952' AND ean13 != ''
23/01/2023 10:14:26 am >> UPDATE ps_product SET
id_supplier = '109',
reference = '1/2',
ean13 = '9788869294341',
date_upd = NOW()
WHERE id_product = '15952'
23/01/2023 10:14:26 am >> UPDATE ps_product_lang SET
name = 'A CENTRO TAVOLA - G. COTICHELLA',
description = ''
WHERE id_product = '15952'
23/01/2023 10:14:26 am >> UPDATE ps_product SET
wholesale_price = '5.85',
on_sale = '0',
price = '9.0000'
WHERE id_product = '15952'
23/01/2023 10:14:26 am >> UPDATE ps_product_shop SET
wholesale_price = '5.85',
price = '9.0000',
id_tax_rules_group = '4',
id_category_default = '45',
id_argoment_default = '86',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '15952'
23/01/2023 10:14:26 am >> DELETE FROM ps_specific_price WHERE id_product = '15952'
23/01/2023 10:16:11 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791259750761' AND id_product != '19235' AND ean13 != ''
23/01/2023 10:16:11 am >> UPDATE ps_product SET
id_supplier = '7',
reference = '1/2',
ean13 = '9791259750761',
date_upd = NOW()
WHERE id_product = '19235'
23/01/2023 10:16:11 am >> UPDATE ps_product_lang SET
name = 'FORMAZIONE DEI CATECHISTI - F. CENTRELLA',
description = ''
WHERE id_product = '19235'
23/01/2023 10:16:11 am >> UPDATE ps_product SET
wholesale_price = '11.20',
on_sale = '0',
price = '16.0000'
WHERE id_product = '19235'
23/01/2023 10:16:11 am >> UPDATE ps_product_shop SET
wholesale_price = '11.20',
price = '16.0000',
id_tax_rules_group = '4',
id_category_default = '267',
id_argoment_default = '35',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '19235'
23/01/2023 10:16:11 am >> DELETE FROM ps_specific_price WHERE id_product = '19235'
23/01/2023 10:17:50 am >> DELETE FROM ps_product WHERE id_product = '5192'
23/01/2023 10:17:50 am >> DELETE FROM ps_product_shop WHERE id_product = '5192'
23/01/2023 10:17:50 am >> DELETE FROM ps_product_lang WHERE id_product = '5192'
23/01/2023 10:17:50 am >> DELETE FROM ps_stock_available WHERE id_product = '5192'
23/01/2023 10:20:57 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831551779' AND id_product != '16680' AND ean13 != ''
23/01/2023 10:20:57 am >> UPDATE ps_product SET
id_supplier = '7',
reference = '1/2',
ean13 = '9788831551779',
date_upd = NOW()
WHERE id_product = '16680'
23/01/2023 10:20:57 am >> UPDATE ps_product_lang SET
name = 'CHIESA DI TALENTI - f. carletti',
description = ''
WHERE id_product = '16680'
23/01/2023 10:20:57 am >> UPDATE ps_product SET
wholesale_price = '4.62',
on_sale = '0',
price = '6.9000'
WHERE id_product = '16680'
23/01/2023 10:20:57 am >> UPDATE ps_product_shop SET
wholesale_price = '4.62',
price = '6.9000',
id_tax_rules_group = '4',
id_category_default = '27',
id_argoment_default = '10',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '16680'
23/01/2023 10:20:57 am >> DELETE FROM ps_specific_price WHERE id_product = '16680'
23/01/2023 10:26:57 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788810511589' AND id_product != '17439' AND ean13 != ''
23/01/2023 10:26:57 am >> UPDATE ps_product SET
id_supplier = '109',
reference = '1/3',
ean13 = '9788810511589',
date_upd = NOW()
WHERE id_product = '17439'
23/01/2023 10:26:57 am >> UPDATE ps_product_lang SET
name = 'MATRIMONIO, UNA BUONA NOTIZIA - W. RUSPI',
description = ''
WHERE id_product = '17439'
23/01/2023 10:26:57 am >> UPDATE ps_product SET
wholesale_price = '8.62',
on_sale = '0',
price = '13.0000'
WHERE id_product = '17439'
23/01/2023 10:26:57 am >> UPDATE ps_product_shop SET
wholesale_price = '8.62',
price = '13.0000',
id_tax_rules_group = '4',
id_category_default = '9',
id_argoment_default = '134',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '17439'
23/01/2023 10:26:57 am >> DELETE FROM ps_specific_price WHERE id_product = '17439'
23/01/2023 10:27:11 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801033960' AND id_product != '6691' AND ean13 != ''
23/01/2023 10:27:11 am >> UPDATE ps_product SET
id_supplier = '7',
reference = '5/1',
ean13 = '9788801033960',
date_upd = NOW()
WHERE id_product = '6691'
23/01/2023 10:27:11 am >> UPDATE ps_product_lang SET
name = 'MIO BATTESIMO',
description = ''
WHERE id_product = '6691'
23/01/2023 10:27:11 am >> UPDATE ps_product SET
wholesale_price = '1.24',
on_sale = '0',
price = '1.9000'
WHERE id_product = '6691'
23/01/2023 10:27:11 am >> UPDATE ps_product_shop SET
wholesale_price = '1.24',
price = '1.9000',
id_tax_rules_group = '4',
id_category_default = '19',
id_argoment_default = '22',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '6691'
23/01/2023 10:27:11 am >> DELETE FROM ps_specific_price WHERE id_product = '6691'
23/01/2023 10:28:39 am >> DELETE FROM ps_product WHERE id_product = '7668'
23/01/2023 10:28:40 am >> DELETE FROM ps_product_shop WHERE id_product = '7668'
23/01/2023 10:28:40 am >> DELETE FROM ps_product_lang WHERE id_product = '7668'
23/01/2023 10:28:40 am >> DELETE FROM ps_stock_available WHERE id_product = '7668'
23/01/2023 10:29:10 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788827012178' AND id_product != '19419' AND ean13 != ''
23/01/2023 10:29:10 am >> UPDATE ps_product SET
id_supplier = '7',
reference = '1/3',
ean13 = '9788827012178',
date_upd = NOW()
WHERE id_product = '19419'
23/01/2023 10:29:10 am >> UPDATE ps_product_lang SET
name = 'PO DI TEMPO PER DIO E PER NOI - R. BONETTI',
description = ''
WHERE id_product = '19419'
23/01/2023 10:29:10 am >> UPDATE ps_product SET
wholesale_price = '8.40',
on_sale = '0',
price = '12.0000'
WHERE id_product = '19419'
23/01/2023 10:29:10 am >> UPDATE ps_product_shop SET
wholesale_price = '8.40',
price = '12.0000',
id_tax_rules_group = '4',
id_category_default = '186',
id_argoment_default = '243',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '19419'
23/01/2023 10:29:10 am >> DELETE FROM ps_specific_price WHERE id_product = '19419'
23/01/2023 10:29:26 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892229228' AND id_product != '19810' AND ean13 != ''
23/01/2023 10:29:27 am >> UPDATE ps_product SET
id_supplier = '7',
reference = '1/3',
ean13 = '9788892229228',
date_upd = NOW()
WHERE id_product = '19810'
23/01/2023 10:29:27 am >> UPDATE ps_product_lang SET
name = 'QUELLA STANA COPPIA ',
description = ''
WHERE id_product = '19810'
23/01/2023 10:29:27 am >> UPDATE ps_product SET
wholesale_price = '6.70',
on_sale = '0',
price = '10.0000'
WHERE id_product = '19810'
23/01/2023 10:29:27 am >> UPDATE ps_product_shop SET
wholesale_price = '6.70',
price = '10.0000',
id_tax_rules_group = '4',
id_category_default = '30',
id_argoment_default = '134',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '19810'
23/01/2023 10:29:27 am >> DELETE FROM ps_specific_price WHERE id_product = '19810'
23/01/2023 10:32:07 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788868797201' AND id_product != '15576' AND ean13 != ''
23/01/2023 10:32:07 am >> UPDATE ps_product SET
id_supplier = '109',
reference = '1/3',
ean13 = '9788868797201',
date_upd = NOW()
WHERE id_product = '15576'
23/01/2023 10:32:07 am >> UPDATE ps_product_lang SET
name = 'RICOMINCIAMO DA PER SEMPRE - R. CASTILLO',
description = ''
WHERE id_product = '15576'
23/01/2023 10:32:07 am >> UPDATE ps_product SET
wholesale_price = '9.75',
on_sale = '0',
price = '15.0000'
WHERE id_product = '15576'
23/01/2023 10:32:07 am >> UPDATE ps_product_shop SET
wholesale_price = '9.75',
price = '15.0000',
id_tax_rules_group = '4',
id_category_default = '143',
id_argoment_default = '182',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '15576'
23/01/2023 10:32:07 am >> DELETE FROM ps_specific_price WHERE id_product = '15576'
23/01/2023 10:35:41 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788825055344' AND id_product != '19700' AND ean13 != ''
23/01/2023 10:35:41 am >> UPDATE ps_product SET
id_supplier = '7',
reference = '1/3',
ean13 = '9788825055344',
date_upd = NOW()
WHERE id_product = '19700'
23/01/2023 10:35:41 am >> UPDATE ps_product_lang SET
name = 'SONO VENUTO A PORTARE IL FUOCO - W. RUSPI',
description = ''
WHERE id_product = '19700'
23/01/2023 10:35:41 am >> UPDATE ps_product SET
wholesale_price = '6.30',
on_sale = '0',
price = '9.0000'
WHERE id_product = '19700'
23/01/2023 10:35:41 am >> UPDATE ps_product_shop SET
wholesale_price = '6.30',
price = '9.0000',
id_tax_rules_group = '4',
id_category_default = '17',
id_argoment_default = '145',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '19700'
23/01/2023 10:35:41 am >> DELETE FROM ps_specific_price WHERE id_product = '19700'
23/01/2023 10:37:52 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788851420352' AND id_product != '14818' AND ean13 != ''
23/01/2023 10:37:52 am >> UPDATE ps_product SET
id_supplier = '114',
reference = '1/4',
ean13 = '9788851420352',
date_upd = NOW()
WHERE id_product = '14818'
23/01/2023 10:37:52 am >> UPDATE ps_product_lang SET
name = 'VITA DI COPPIA: SERVE AIUTO? - A. MANENTI',
description = ''
WHERE id_product = '14818'
23/01/2023 10:37:52 am >> UPDATE ps_product SET
wholesale_price = '9.49',
on_sale = '0',
price = '15.0000'
WHERE id_product = '14818'
23/01/2023 10:37:52 am >> UPDATE ps_product_shop SET
wholesale_price = '9.49',
price = '15.0000',
id_tax_rules_group = '4',
id_category_default = '98',
id_argoment_default = '243',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '14818'
23/01/2023 10:37:52 am >> DELETE FROM ps_specific_price WHERE id_product = '14818'
23/01/2023 10:41:55 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788895983547' AND id_product != '14260' AND ean13 != ''
23/01/2023 10:41:55 am >> UPDATE ps_product SET
id_supplier = '53',
reference = '1/2',
ean13 = '9788895983547',
date_upd = NOW()
WHERE id_product = '14260'
23/01/2023 10:41:55 am >> UPDATE ps_product_lang SET
name = 'CUORE CHE BATTE - TORNARE AD AMARE IL CREATO',
description = '
Questo sussidio propone un percorso educativo per ragazzi\r\nfacendo tesoro degli insegnamenti che Papa Francesco ci ha dato nell’Enciclica Laudato\r\nsi’, mettendo al centro dell’interesse degli uomini la casa comune.
Questo stile nuovo di vita si può acquisire formando le coscienze,\r\na partire dai bambini e dai ragazzi. Crescere amando la terra che è nostra\r\nmadre e custodire il Creato intero.
\r\n\r\n\r\n\r\n
Ciascuno\r\ndi noi può prendere dalla terra ciò di cui ha bisogno per la propria sopravvivenza ma ha, anche, il dovere di tutelarla.
'
WHERE id_product = '14260'
23/01/2023 10:41:55 am >> UPDATE ps_product SET
wholesale_price = '1.38',
on_sale = '0',
price = '8.0000'
WHERE id_product = '14260'
23/01/2023 10:41:55 am >> UPDATE ps_product_shop SET
wholesale_price = '1.38',
price = '8.0000',
id_tax_rules_group = '4',
id_category_default = '395',
id_argoment_default = '21',
id_internal_category = '4',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '1',
date_upd = NOW()
WHERE id_product = '14260'
23/01/2023 10:41:55 am >> DELETE FROM ps_specific_price WHERE id_product = '14260'
23/01/2023 10:41:55 am >> INSERT INTO ps_specific_price
( id_specific_price_rule , id_cart , id_product , id_shop , id_shop_group , id_currency , id_country , id_group , id_customer , id_product_attribute , price , from_quantity , reduction , reduction_tax , reduction_type , `from` , `to`)
VALUES
( '0' , '0' , '14260' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' )
23/01/2023 10:45:13 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788868797201' AND id_product != '15576' AND ean13 != ''
23/01/2023 10:45:13 am >> UPDATE ps_product SET
id_supplier = '109',
reference = '1/4',
ean13 = '9788868797201',
date_upd = NOW()
WHERE id_product = '15576'
23/01/2023 10:45:13 am >> UPDATE ps_product_lang SET
name = 'RICOMINCIAMO DA PER SEMPRE - R. CASTILLO',
description = ''
WHERE id_product = '15576'
23/01/2023 10:45:13 am >> UPDATE ps_product SET
wholesale_price = '9.75',
on_sale = '0',
price = '15.0000'
WHERE id_product = '15576'
23/01/2023 10:45:13 am >> UPDATE ps_product_shop SET
wholesale_price = '9.75',
price = '15.0000',
id_tax_rules_group = '4',
id_category_default = '143',
id_argoment_default = '182',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '15576'
23/01/2023 10:45:13 am >> DELETE FROM ps_specific_price WHERE id_product = '15576'
23/01/2023 10:45:27 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892229228' AND id_product != '19810' AND ean13 != ''
23/01/2023 10:45:27 am >> UPDATE ps_product SET
id_supplier = '7',
reference = '1/4',
ean13 = '9788892229228',
date_upd = NOW()
WHERE id_product = '19810'
23/01/2023 10:45:27 am >> UPDATE ps_product_lang SET
name = 'QUELLA STANA COPPIA ',
description = ''
WHERE id_product = '19810'
23/01/2023 10:45:27 am >> UPDATE ps_product SET
wholesale_price = '6.70',
on_sale = '0',
price = '10.0000'
WHERE id_product = '19810'
23/01/2023 10:45:28 am >> UPDATE ps_product_shop SET
wholesale_price = '6.70',
price = '10.0000',
id_tax_rules_group = '4',
id_category_default = '30',
id_argoment_default = '134',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '19810'
23/01/2023 10:45:28 am >> DELETE FROM ps_specific_price WHERE id_product = '19810'
23/01/2023 10:45:40 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788827012178' AND id_product != '19419' AND ean13 != ''
23/01/2023 10:45:40 am >> UPDATE ps_product SET
id_supplier = '7',
reference = '1/4',
ean13 = '9788827012178',
date_upd = NOW()
WHERE id_product = '19419'
23/01/2023 10:45:40 am >> UPDATE ps_product_lang SET
name = 'PO DI TEMPO PER DIO E PER NOI - R. BONETTI',
description = ''
WHERE id_product = '19419'
23/01/2023 10:45:40 am >> UPDATE ps_product SET
wholesale_price = '8.40',
on_sale = '0',
price = '12.0000'
WHERE id_product = '19419'
23/01/2023 10:45:40 am >> UPDATE ps_product_shop SET
wholesale_price = '8.40',
price = '12.0000',
id_tax_rules_group = '4',
id_category_default = '186',
id_argoment_default = '243',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '19419'
23/01/2023 10:45:40 am >> DELETE FROM ps_specific_price WHERE id_product = '19419'
23/01/2023 10:45:50 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788810511589' AND id_product != '17439' AND ean13 != ''
23/01/2023 10:45:50 am >> UPDATE ps_product SET
id_supplier = '109',
reference = '1/4',
ean13 = '9788810511589',
date_upd = NOW()
WHERE id_product = '17439'
23/01/2023 10:45:50 am >> UPDATE ps_product_lang SET
name = 'MATRIMONIO, UNA BUONA NOTIZIA - W. RUSPI',
description = ''
WHERE id_product = '17439'
23/01/2023 10:45:51 am >> UPDATE ps_product SET
wholesale_price = '8.62',
on_sale = '0',
price = '13.0000'
WHERE id_product = '17439'
23/01/2023 10:45:51 am >> UPDATE ps_product_shop SET
wholesale_price = '8.62',
price = '13.0000',
id_tax_rules_group = '4',
id_category_default = '9',
id_argoment_default = '134',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '17439'
23/01/2023 10:45:51 am >> DELETE FROM ps_specific_price WHERE id_product = '17439'
23/01/2023 10:46:01 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788839932754' AND id_product != '19546' AND ean13 != ''
23/01/2023 10:46:01 am >> UPDATE ps_product SET
id_supplier = '7',
reference = '1/4',
ean13 = '9788839932754',
date_upd = NOW()
WHERE id_product = '19546'
23/01/2023 10:46:01 am >> UPDATE ps_product_lang SET
name = 'AMORIS LAETITIA - UN AMORE CONCRETO - F. BRAMBILLA',
description = ''
WHERE id_product = '19546'
23/01/2023 10:46:01 am >> UPDATE ps_product SET
wholesale_price = '9.10',
on_sale = '0',
price = '13.0000'
WHERE id_product = '19546'
23/01/2023 10:46:02 am >> UPDATE ps_product_shop SET
wholesale_price = '9.10',
price = '13.0000',
id_tax_rules_group = '4',
id_category_default = '111',
id_argoment_default = '59',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '19546'
23/01/2023 10:46:02 am >> DELETE FROM ps_specific_price WHERE id_product = '19546'
23/01/2023 10:46:34 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788810512203' AND id_product != '1758' AND ean13 != ''
23/01/2023 10:46:34 am >> UPDATE ps_product SET
id_supplier = '',
reference = '1/4',
ean13 = '9788810512203',
date_upd = NOW()
WHERE id_product = '1758'
23/01/2023 10:46:34 am >> UPDATE ps_product_lang SET
name = 'CASA PER TUTTI',
description = ''
WHERE id_product = '1758'
23/01/2023 10:46:34 am >> UPDATE ps_product SET
wholesale_price = '3.91',
on_sale = '0',
price = '5.5000'
WHERE id_product = '1758'
23/01/2023 10:46:34 am >> UPDATE ps_product_shop SET
wholesale_price = '3.91',
price = '5.5000',
id_tax_rules_group = '4',
id_category_default = '9',
id_argoment_default = '86',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '1758'
23/01/2023 10:46:34 am >> DELETE FROM ps_specific_price WHERE id_product = '1758'
23/01/2023 10:46:45 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831125796' AND id_product != '18467' AND ean13 != ''
23/01/2023 10:46:45 am >> UPDATE ps_product SET
id_supplier = '109',
reference = '1/4',
ean13 = '9788831125796',
date_upd = NOW()
WHERE id_product = '18467'
23/01/2023 10:46:45 am >> UPDATE ps_product_lang SET
name = 'INNAMORARSI OGNI GIORNO',
description = ''
WHERE id_product = '18467'
23/01/2023 10:46:45 am >> UPDATE ps_product SET
wholesale_price = '9.10',
on_sale = '0',
price = '14.0000'
WHERE id_product = '18467'
23/01/2023 10:46:45 am >> UPDATE ps_product_shop SET
wholesale_price = '9.10',
price = '14.0000',
id_tax_rules_group = '4',
id_category_default = '13',
id_argoment_default = '243',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '18467'
23/01/2023 10:46:45 am >> DELETE FROM ps_specific_price WHERE id_product = '18467'
23/01/2023 10:47:01 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892220782' AND id_product != '16621' AND ean13 != ''
23/01/2023 10:47:02 am >> UPDATE ps_product SET
id_supplier = '7',
reference = '1/4',
ean13 = '9788892220782',
date_upd = NOW()
WHERE id_product = '16621'
23/01/2023 10:47:02 am >> UPDATE ps_product_lang SET
name = 'HANNO UNA STORIA - F. PESCE',
description = ''
WHERE id_product = '16621'
23/01/2023 10:47:02 am >> UPDATE ps_product SET
wholesale_price = '10.72',
on_sale = '0',
price = '16.0000'
WHERE id_product = '16621'
23/01/2023 10:47:02 am >> UPDATE ps_product_shop SET
wholesale_price = '10.72',
price = '16.0000',
id_tax_rules_group = '4',
id_category_default = '30',
id_argoment_default = '243',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '16621'
23/01/2023 10:47:02 am >> DELETE FROM ps_specific_price WHERE id_product = '16621'
23/01/2023 10:47:13 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791259620194' AND id_product != '18464' AND ean13 != ''
23/01/2023 10:47:13 am >> UPDATE ps_product SET
id_supplier = '109',
reference = '1/4',
ean13 = '9791259620194',
date_upd = NOW()
WHERE id_product = '18464'
23/01/2023 10:47:13 am >> UPDATE ps_product_lang SET
name = 'AMORE SPONSALE - K WOJTYLA',
description = ''
WHERE id_product = '18464'
23/01/2023 10:47:13 am >> UPDATE ps_product SET
wholesale_price = '11.70',
on_sale = '0',
price = '18.0000'
WHERE id_product = '18464'
23/01/2023 10:47:13 am >> UPDATE ps_product_shop SET
wholesale_price = '11.70',
price = '18.0000',
id_tax_rules_group = '4',
id_category_default = '143',
id_argoment_default = '243',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '18464'
23/01/2023 10:47:13 am >> DELETE FROM ps_specific_price WHERE id_product = '18464'
23/01/2023 10:47:25 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788827012024' AND id_product != '17951' AND ean13 != ''
23/01/2023 10:47:25 am >> UPDATE ps_product SET
id_supplier = '7',
reference = '1/4',
ean13 = '9788827012024',
date_upd = NOW()
WHERE id_product = '17951'
23/01/2023 10:47:25 am >> UPDATE ps_product_lang SET
name = 'CRISTO E GLI SPOSI - S. BUCOLO',
description = ''
WHERE id_product = '17951'
23/01/2023 10:47:25 am >> UPDATE ps_product SET
wholesale_price = '7.00',
on_sale = '0',
price = '10.0000'
WHERE id_product = '17951'
23/01/2023 10:47:25 am >> UPDATE ps_product_shop SET
wholesale_price = '7.00',
price = '10.0000',
id_tax_rules_group = '4',
id_category_default = '186',
id_argoment_default = '134',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '17951'
23/01/2023 10:47:25 am >> DELETE FROM ps_specific_price WHERE id_product = '17951'
23/01/2023 10:52:51 am >> 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')
23/01/2023 10:52:51 am >> 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 = '63.90',
price_tax_excluded = '63.90',
date_upd = NOW()
WHERE id_document = '79381'
23/01/2023 10:52:51 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '79381'
23/01/2023 10:52:51 am >> DELETE FROM ps_document_detail WHERE id_document = '79381'
23/01/2023 10:52:51 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '79381' , '20625' , 'DIO E SEMPRE NUOVO - RATZINGER' , '1' , '-1' , '4' ,
'13.0000' , '13' , '0' , '0' , '13.00' )
23/01/2023 10:52:51 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '79381' , '6223' , 'MARIA CON I PIEDI PER TERRA - P. CURTAZ' , '1' , '-1' , '4' ,
'16.5000' , '16.5' , '0' , '0' , '16.50' )
23/01/2023 10:52:51 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '79381' , '20626' , 'IN CAMMINO VERSO GESU CRISTO - J. RATZINGER' , '1' , '-1' , '4' ,
'12.5000' , '12.5' , '0' , '0' , '12.50' )
23/01/2023 10:52:51 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '79381' , '20592' , 'SULLA TUA PAROLA MAR/APR 23 - 515' , '1' , '-1' , '4' ,
'5.0000' , '5' , '0' , '0' , '5.00' )
23/01/2023 10:52:51 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '79381' , '20494' , 'TI VOGLIO FELICE - PAPA FRANCESCO' , '1' , '-1' , '4' ,
'16.90' , '16.9' , '0' , '0' , '16.90' )
23/01/2023 10:54:15 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 (
'33' ,
'414' ,
'2023-01-20' ,
'' ,
'3000' ,
'0' ,
'4669629' ,
'VIA DEI CASTANI, 116 00172 ROMA' ,
'' ,
'RESA ' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'14.00' ,
'14.00' ,
NOW() ,
NOW() )
23/01/2023 10:54:15 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 = '80466'
23/01/2023 10:54:15 am >> DELETE FROM ps_document_detail WHERE id_document = '80466'
23/01/2023 10:54:15 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
( '80466' , '19160' , 'PERCHE IL DESERTO TORNI A FIORIRE - A. SALVOLDI' , '7' , '7' , '4' ,
'2.00' , '2' , '0' , '0' , '14.0000' )
23/01/2023 10:55:20 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 (
'33' ,
'413' ,
'2023-01-20' ,
'' ,
'3000' ,
'0' ,
'4669629' ,
'VIA DEI CASTANI, 116 00172 ROMA' ,
'' ,
'RESA V. E. ' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'249.00' ,
'249.00' ,
NOW() ,
NOW() )
23/01/2023 10:55:20 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 = '9508'
23/01/2023 10:55:20 am >> DELETE FROM ps_document_detail WHERE id_document = '9508'
23/01/2023 10:55:20 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '9508' , '104' , 'TEMPO DI QUARESIMA' , '249' , '249' , '4' ,
'1' , '1' , '0' , '0' , '249.0000' )
23/01/2023 11:00:20 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3832'
23/01/2023 11:00:20 am >> INSERT INTO ps_address
( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd )
VALUES (
'3832' ,
'10' ,
'210' ,
'ENTE PROV. NAPOLETANA CONG. SS. REDENTORE - BIBLIOTECA S. ALFONSO' ,
'' ,
'' ,
'PIAZZA S. ALFONSO 1' ,
'' ,
'84016' ,
'PAGANI' ,
'Apollonia Califano - 3476032052\r\nBIBLIOTECA S. ALFONSO' ,
'' ,
'' ,
'' ,
'80044080630' ,
NOW() ,
NOW() )
23/01/2023 11:00:20 am >> UPDATE ps_customer SET
email = 'bibliotecasantalfonso.pagani@redentoristi.it',
sdi = '0000000',
pec = 'bibliotecasantalfonso.pagani@pec.it',
date_upd = NOW()
WHERE id_customer = '3832'
23/01/2023 11:20:08 am >> SELECT document_num FROM ps_document
WHERE document_num = '224' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-23')
23/01/2023 11:20:08 am >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'224' ,
'2023-01-23' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'3.00' ,
'2.46' ,
NOW() ,
NOW() )
23/01/2023 11:20:08 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 = '80467'
23/01/2023 11:20:08 am >> DELETE FROM ps_document_detail WHERE id_document = '80467'
23/01/2023 11:20:08 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
( '80467' , '16056' , 'CROCE TRINITA - G451' , '6' , '-6' , '1' ,
'0.50' , '0.40983606557377' , '22' , '0' , '3.00' )
23/01/2023 11:24:07 am >> SELECT document_num FROM ps_document
WHERE document_num = '1' AND id_document != '9507' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2023-01-19')
23/01/2023 11:24:07 am >> UPDATE ps_document SET
id_document_type = '24',
document_num = '1',
document_date = '2023-01-19',
document_letter = '',
id_customer = '3000',
id_supplier = '',
id_address = '4669629',
address1 = 'VIA DEI CASTANI, 116 00172 ROMA',
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 = '3075.00',
price_tax_excluded = '3075.00',
date_upd = NOW()
WHERE id_document = '9507'
23/01/2023 11:24:07 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 = '9507'
23/01/2023 11:24:07 am >> DELETE FROM ps_document_detail WHERE id_document = '9507'
23/01/2023 11:24:07 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
( '9507' , '130' , 'ROSARIO SPIEGATO AI BAMBINI - N.E.' , '480' , '-480' , '4' ,
'2.5000' , '2.5' , '0' , '0' , '1200.00' )
23/01/2023 11:24:07 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
( '9507' , '132' , 'MINISTRANTI IERI, OGGI, DOMANI' , '450' , '-450' , '4' ,
'2.5000' , '2.5' , '0' , '0' , '1125.00' )
23/01/2023 11:24:07 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
( '9507' , '104' , 'TEMPO DI QUARESIMA' , '300' , '-300' , '4' ,
'2.5000' , '2.5' , '0' , '0' , '750.00' )
23/01/2023 11:43:20 am >> SELECT document_num FROM ps_document
WHERE document_num = '225' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-23')
23/01/2023 11:43:20 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' ,
'225' ,
'2023-01-23' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'5.65' ,
'5.65' ,
NOW() ,
NOW() )
23/01/2023 11:43:20 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 = '80468'
23/01/2023 11:43:20 am >> DELETE FROM ps_document_detail WHERE id_document = '80468'
23/01/2023 11:43:20 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '80468' , '7824' , 'PER ILLUMINARE IL CAMMINO' , '1' , '-1' , '4' ,
'0.90' , '0.9' , '0' , '0' , '0.90' )
23/01/2023 11:43:20 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '80468' , '4120' , 'FEDE NELLO ZAINETTO' , '1' , '-1' , '4' ,
'5.00' , '5' , '0' , '5' , '4.75' )
23/01/2023 11:43:38 am >> SELECT document_num FROM ps_document
WHERE document_num = '226' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-23')
23/01/2023 11:43:38 am >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'226' ,
'2023-01-23' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'4.75' ,
'4.75' ,
NOW() ,
NOW() )
23/01/2023 11:43:38 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '80469'
23/01/2023 11:43:38 am >> DELETE FROM ps_document_detail WHERE id_document = '80469'
23/01/2023 11:43:38 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '80469' , '20592' , 'SULLA TUA PAROLA MAR/APR 23 - 515' , '1' , '-1' , '4' ,
'5.00' , '5' , '0' , '5' , '4.75' )
23/01/2023 03:42:55 pm >> SELECT document_num FROM ps_document
WHERE document_num = '227' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-23')
23/01/2023 03:42:55 pm >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'227' ,
'2023-01-23' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'23.00' ,
'18.85' ,
NOW() ,
NOW() )
23/01/2023 03:42:55 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '80470'
23/01/2023 03:42:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '80470'
23/01/2023 03:42:55 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '80470' , '16057' , 'ANELLO ARG. CON CROCE/STRASS - RA343' , '1' , '-1' , '1' ,
'23.00' , '18.852459016393' , '22' , '0' , '23.00' )
23/01/2023 04:29:18 pm >> SELECT document_num FROM ps_document
WHERE document_num = '228' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-23')
23/01/2023 04:29:18 pm >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'228' ,
'2023-01-23' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'15.00' ,
'12.30' ,
NOW() ,
NOW() )
23/01/2023 04:29:18 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '80471'
23/01/2023 04:29:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '80471'
23/01/2023 04:29:18 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '80471' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '2' , '-2' , '1' ,
'7.50' , '6.1475409836066' , '22' , '0' , '15.00' )
23/01/2023 04:49:46 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8032685842868' AND id_product != '6138' AND ean13 != ''
23/01/2023 04:49:46 pm >> UPDATE ps_product SET
id_supplier = '',
reference = '',
ean13 = '8032685842868',
date_upd = NOW()
WHERE id_product = '6138'
23/01/2023 04:49:46 pm >> UPDATE ps_product_lang SET
name = 'MAGNETE L\'AMICIZIA- 792/1',
description = ''
WHERE id_product = '6138'
23/01/2023 04:49:46 pm >> UPDATE ps_product SET
wholesale_price = '0.41',
on_sale = '0',
price = '0.8197'
WHERE id_product = '6138'
23/01/2023 04:49:46 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.41',
price = '0.8197',
id_tax_rules_group = '1',
id_category_default = '175',
id_argoment_default = '42',
id_internal_category = '3',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '6138'
23/01/2023 04:49:46 pm >> DELETE FROM ps_specific_price WHERE id_product = '6138'
23/01/2023 04:49:53 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8032685842950' AND id_product != '6153' AND ean13 != ''
23/01/2023 04:49:53 pm >> UPDATE ps_product SET
id_supplier = '',
reference = '',
ean13 = '8032685842950',
date_upd = NOW()
WHERE id_product = '6153'
23/01/2023 04:49:53 pm >> UPDATE ps_product_lang SET
name = 'MAGNETE VIVI LA VITA - 792/10',
description = ''
WHERE id_product = '6153'
23/01/2023 04:49:53 pm >> UPDATE ps_product SET
wholesale_price = '0.41',
on_sale = '0',
price = '0.8197'
WHERE id_product = '6153'
23/01/2023 04:49:53 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.41',
price = '0.8197',
id_tax_rules_group = '1',
id_category_default = '175',
id_argoment_default = '42',
id_internal_category = '3',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '6153'
23/01/2023 04:49:53 pm >> DELETE FROM ps_specific_price WHERE id_product = '6153'
23/01/2023 04:59:51 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801064995' AND id_product != '14952' AND ean13 != ''
23/01/2023 04:59:51 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '2/4',
ean13 = '9788801064995',
date_upd = NOW()
WHERE id_product = '14952'
23/01/2023 04:59:51 pm >> UPDATE ps_product_lang SET
name = 'MESSA PRONTI? VIA! - ANNO C - C. PELLEGRINO',
description = ''
WHERE id_product = '14952'
23/01/2023 04:59:51 pm >> UPDATE ps_product SET
wholesale_price = '7.09',
on_sale = '0',
price = '10.9000'
WHERE id_product = '14952'
23/01/2023 04:59:51 pm >> UPDATE ps_product_shop SET
wholesale_price = '7.09',
price = '10.9000',
id_tax_rules_group = '4',
id_category_default = '19',
id_argoment_default = '22',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '14952'
23/01/2023 04:59:51 pm >> DELETE FROM ps_specific_price WHERE id_product = '14952'
23/01/2023 05:00:31 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831165716' AND id_product != '14338' AND ean13 != ''
23/01/2023 05:00:31 pm >> UPDATE ps_product SET
id_supplier = '109',
reference = '2/1',
ean13 = '9788831165716',
date_upd = NOW()
WHERE id_product = '14338'
23/01/2023 05:00:31 pm >> UPDATE ps_product_lang SET
name = 'VIVIAMO INSIEME IL VANGELO - ANNO 2 SCHEDE',
description = ''
WHERE id_product = '14338'
23/01/2023 05:00:31 pm >> UPDATE ps_product SET
wholesale_price = '3.25',
on_sale = '0',
price = '5.0000'
WHERE id_product = '14338'
23/01/2023 05:00:31 pm >> UPDATE ps_product_shop SET
wholesale_price = '3.25',
price = '5.0000',
id_tax_rules_group = '4',
id_category_default = '13',
id_argoment_default = '22',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '14338'
23/01/2023 05:00:31 pm >> DELETE FROM ps_specific_price WHERE id_product = '14338'
23/01/2023 05:00:49 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831165679' AND id_product != '14336' AND ean13 != ''
23/01/2023 05:00:49 pm >> UPDATE ps_product SET
id_supplier = '109',
reference = '2/1',
ean13 = '9788831165679',
date_upd = NOW()
WHERE id_product = '14336'
23/01/2023 05:00:49 pm >> UPDATE ps_product_lang SET
name = 'VIVIAMO INSIEME IL VANGELO - ANNO 1 GUIDA',
description = ''
WHERE id_product = '14336'
23/01/2023 05:00:49 pm >> UPDATE ps_product SET
wholesale_price = '3.85',
on_sale = '0',
price = '5.5000'
WHERE id_product = '14336'
23/01/2023 05:00:49 pm >> UPDATE ps_product_shop SET
wholesale_price = '3.85',
price = '5.5000',
id_tax_rules_group = '4',
id_category_default = '13',
id_argoment_default = '22',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '14336'
23/01/2023 05:00:49 pm >> DELETE FROM ps_specific_price WHERE id_product = '14336'
23/01/2023 05:01:36 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831165730' AND id_product != '14335' AND ean13 != ''
23/01/2023 05:01:36 pm >> UPDATE ps_product SET
id_supplier = '109',
reference = '2/1',
ean13 = '9788831165730',
date_upd = NOW()
WHERE id_product = '14335'
23/01/2023 05:01:36 pm >> UPDATE ps_product_lang SET
name = 'VIVIAMO INSIEME IL VANGELO - ANNO 2',
description = ''
WHERE id_product = '14335'
23/01/2023 05:01:36 pm >> UPDATE ps_product SET
wholesale_price = '3.25',
on_sale = '0',
price = '5.0000'
WHERE id_product = '14335'
23/01/2023 05:01:36 pm >> UPDATE ps_product_shop SET
wholesale_price = '3.25',
price = '5.0000',
id_tax_rules_group = '4',
id_category_default = '13',
id_argoment_default = '22',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '14335'
23/01/2023 05:01:36 pm >> DELETE FROM ps_specific_price WHERE id_product = '14335'
23/01/2023 05:02:45 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831531528' AND id_product != '6860' AND ean13 != ''
23/01/2023 05:02:45 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '2/1',
ean13 = '9788831531528',
date_upd = NOW()
WHERE id_product = '6860'
23/01/2023 05:02:45 pm >> UPDATE ps_product_lang SET
name = 'NARRARE LA FEDE AI FIGLI - LUCA ',
description = ''
WHERE id_product = '6860'
23/01/2023 05:02:45 pm >> UPDATE ps_product SET
wholesale_price = '7.80',
on_sale = '0',
price = '12.0000'
WHERE id_product = '6860'
23/01/2023 05:02:45 pm >> UPDATE ps_product_shop SET
wholesale_price = '7.80',
price = '12.0000',
id_tax_rules_group = '4',
id_category_default = '27',
id_argoment_default = '182',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '6860'
23/01/2023 05:02:45 pm >> DELETE FROM ps_specific_price WHERE id_product = '6860'
23/01/2023 05:03:09 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831533065' AND id_product != '13646' AND ean13 != ''
23/01/2023 05:03:09 pm >> UPDATE ps_product SET
id_supplier = '',
reference = '2/1',
ean13 = '9788831533065',
date_upd = NOW()
WHERE id_product = '13646'
23/01/2023 05:03:09 pm >> UPDATE ps_product_lang SET
name = 'GESÙ IL LIBERATORE - QUADERNO ANNO A ',
description = ''
WHERE id_product = '13646'
23/01/2023 05:03:09 pm >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '5.0000'
WHERE id_product = '13646'
23/01/2023 05:03:09 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '5.0000',
id_tax_rules_group = '4',
id_category_default = '27',
id_argoment_default = '22',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '13646'
23/01/2023 05:03:09 pm >> DELETE FROM ps_specific_price WHERE id_product = '13646'
23/01/2023 05:03:24 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831531535' AND id_product != '4464' AND ean13 != ''
23/01/2023 05:03:24 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '2/1',
ean13 = '9788831531535',
date_upd = NOW()
WHERE id_product = '4464'
23/01/2023 05:03:24 pm >> UPDATE ps_product_lang SET
name = 'GESÙ IL VOLTO DELL\'AMORE - ANNO C ',
description = ''
WHERE id_product = '4464'
23/01/2023 05:03:24 pm >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '4.5000'
WHERE id_product = '4464'
23/01/2023 05:03:24 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '4.5000',
id_tax_rules_group = '4',
id_category_default = '27',
id_argoment_default = '182',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '4464'
23/01/2023 05:03:24 pm >> DELETE FROM ps_specific_price WHERE id_product = '4464'
23/01/2023 05:03:37 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788810613320' AND id_product != '5300' AND ean13 != ''
23/01/2023 05:03:37 pm >> UPDATE ps_product SET
id_supplier = '65',
reference = '2/1',
ean13 = '9788810613320',
date_upd = NOW()
WHERE id_product = '5300'
23/01/2023 05:03:37 pm >> UPDATE ps_product_lang SET
name = 'INIZIAZIONE CRISTIANA DEI FANCIULLI IN FAMIGLIA - GUIDA IV',
description = ''
WHERE id_product = '5300'
23/01/2023 05:03:37 pm >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '5.3000'
WHERE id_product = '5300'
23/01/2023 05:03:37 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '5.3000',
id_tax_rules_group = '4',
id_category_default = '9',
id_argoment_default = '182',
id_internal_category = '',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '5300'
23/01/2023 05:03:37 pm >> DELETE FROM ps_specific_price WHERE id_product = '5300'
23/01/2023 05:03:51 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788810613276' AND id_product != '5301' AND ean13 != ''
23/01/2023 05:03:51 pm >> UPDATE ps_product SET
id_supplier = '65',
reference = '2/1',
ean13 = '9788810613276',
date_upd = NOW()
WHERE id_product = '5301'
23/01/2023 05:03:51 pm >> UPDATE ps_product_lang SET
name = 'INIZIAZIONE CRISTIANA DEI FANCIULLI IN FAMIGLIA - SCHEDE 3°',
description = ''
WHERE id_product = '5301'
23/01/2023 05:03:52 pm >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '4.4000'
WHERE id_product = '5301'
23/01/2023 05:03:52 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '4.4000',
id_tax_rules_group = '4',
id_category_default = '9',
id_argoment_default = '182',
id_internal_category = '',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '5301'
23/01/2023 05:03:52 pm >> DELETE FROM ps_specific_price WHERE id_product = '5301'
23/01/2023 05:04:04 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788810613177' AND id_product != '5299' AND ean13 != ''
23/01/2023 05:04:04 pm >> UPDATE ps_product SET
id_supplier = '65',
reference = '2/1',
ean13 = '9788810613177',
date_upd = NOW()
WHERE id_product = '5299'
23/01/2023 05:04:04 pm >> UPDATE ps_product_lang SET
name = 'INIZIAZIONE CRISTIANA DEI FANCIULLI IN FAMIGLIA - GUIDA',
description = ''
WHERE id_product = '5299'
23/01/2023 05:04:04 pm >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '25.2000'
WHERE id_product = '5299'
23/01/2023 05:04:04 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '25.2000',
id_tax_rules_group = '4',
id_category_default = '9',
id_argoment_default = '182',
id_internal_category = '',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '5299'
23/01/2023 05:04:04 pm >> DELETE FROM ps_specific_price WHERE id_product = '5299'
23/01/2023 05:04:17 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788810613115' AND id_product != '5298' AND ean13 != ''
23/01/2023 05:04:17 pm >> UPDATE ps_product SET
id_supplier = '65',
reference = '2/1',
ean13 = '9788810613115',
date_upd = NOW()
WHERE id_product = '5298'
23/01/2023 05:04:17 pm >> UPDATE ps_product_lang SET
name = 'INIZIAZIONE CRISTIANA DEI FANCIULLI IN FAMIGLIA - 1',
description = ''
WHERE id_product = '5298'
23/01/2023 05:04:17 pm >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '24.2000'
WHERE id_product = '5298'
23/01/2023 05:04:17 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '24.2000',
id_tax_rules_group = '4',
id_category_default = '9',
id_argoment_default = '10',
id_internal_category = '',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '5298'
23/01/2023 05:04:17 pm >> DELETE FROM ps_specific_price WHERE id_product = '5298'
23/01/2023 05:04:30 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788868941406' AND id_product != '16033' AND ean13 != ''
23/01/2023 05:04:30 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '2/1',
ean13 = '9788868941406',
date_upd = NOW()
WHERE id_product = '16033'
23/01/2023 05:04:30 pm >> UPDATE ps_product_lang SET
name = 'CON TE DISCEPOLI',
description = ''
WHERE id_product = '16033'
23/01/2023 05:04:30 pm >> UPDATE ps_product SET
wholesale_price = '3.85',
on_sale = '0',
price = '5.5000'
WHERE id_product = '16033'
23/01/2023 05:04:30 pm >> UPDATE ps_product_shop SET
wholesale_price = '3.85',
price = '5.5000',
id_tax_rules_group = '4',
id_category_default = '103',
id_argoment_default = '21',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '16033'
23/01/2023 05:04:30 pm >> DELETE FROM ps_specific_price WHERE id_product = '16033'
23/01/2023 05:04:43 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788868942557' AND id_product != '16036' AND ean13 != ''
23/01/2023 05:04:43 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '2/1',
ean13 = '9788868942557',
date_upd = NOW()
WHERE id_product = '16036'
23/01/2023 05:04:43 pm >> UPDATE ps_product_lang SET
name = 'CON TE CRISTIANI - GUIDA',
description = ''
WHERE id_product = '16036'
23/01/2023 05:04:43 pm >> UPDATE ps_product SET
wholesale_price = '6.93',
on_sale = '0',
price = '9.9000'
WHERE id_product = '16036'
23/01/2023 05:04:43 pm >> UPDATE ps_product_shop SET
wholesale_price = '6.93',
price = '9.9000',
id_tax_rules_group = '4',
id_category_default = '103',
id_argoment_default = '21',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '16036'
23/01/2023 05:04:43 pm >> DELETE FROM ps_specific_price WHERE id_product = '16036'
23/01/2023 05:04:55 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788868942540' AND id_product != '16035' AND ean13 != ''
23/01/2023 05:04:55 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '2/1',
ean13 = '9788868942540',
date_upd = NOW()
WHERE id_product = '16035'
23/01/2023 05:04:55 pm >> UPDATE ps_product_lang SET
name = 'CON TE CRISTIANI',
description = ''
WHERE id_product = '16035'
23/01/2023 05:04:55 pm >> UPDATE ps_product SET
wholesale_price = '3.85',
on_sale = '0',
price = '5.5000'
WHERE id_product = '16035'
23/01/2023 05:04:55 pm >> UPDATE ps_product_shop SET
wholesale_price = '3.85',
price = '5.5000',
id_tax_rules_group = '4',
id_category_default = '103',
id_argoment_default = '21',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '16035'
23/01/2023 05:04:55 pm >> DELETE FROM ps_specific_price WHERE id_product = '16035'
23/01/2023 05:05:06 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788868941826' AND id_product != '16037' AND ean13 != ''
23/01/2023 05:05:06 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '2/1',
ean13 = '9788868941826',
date_upd = NOW()
WHERE id_product = '16037'
23/01/2023 05:05:06 pm >> UPDATE ps_product_lang SET
name = 'CON TE AMICI - GUIDA',
description = ''
WHERE id_product = '16037'
23/01/2023 05:05:06 pm >> UPDATE ps_product SET
wholesale_price = '6.93',
on_sale = '0',
price = '9.9000'
WHERE id_product = '16037'
23/01/2023 05:05:06 pm >> UPDATE ps_product_shop SET
wholesale_price = '6.93',
price = '9.9000',
id_tax_rules_group = '4',
id_category_default = '103',
id_argoment_default = '21',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '16037'
23/01/2023 05:05:06 pm >> DELETE FROM ps_specific_price WHERE id_product = '16037'
23/01/2023 05:05:19 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788868941413' AND id_product != '16038' AND ean13 != ''
23/01/2023 05:05:19 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '2/1',
ean13 = '9788868941413',
date_upd = NOW()
WHERE id_product = '16038'
23/01/2023 05:05:19 pm >> UPDATE ps_product_lang SET
name = 'CON TE DISCEPOLI - GUIDA',
description = ''
WHERE id_product = '16038'
23/01/2023 05:05:19 pm >> UPDATE ps_product SET
wholesale_price = '6.93',
on_sale = '0',
price = '9.9000'
WHERE id_product = '16038'
23/01/2023 05:05:19 pm >> UPDATE ps_product_shop SET
wholesale_price = '6.93',
price = '9.9000',
id_tax_rules_group = '4',
id_category_default = '103',
id_argoment_default = '21',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '16038'
23/01/2023 05:05:19 pm >> DELETE FROM ps_specific_price WHERE id_product = '16038'
23/01/2023 05:05:31 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788868940485' AND id_product != '16039' AND ean13 != ''
23/01/2023 05:05:31 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '2/1',
ean13 = '9788868940485',
date_upd = NOW()
WHERE id_product = '16039'
23/01/2023 05:05:31 pm >> UPDATE ps_product_lang SET
name = 'CON TE FIGLI - GUIDA',
description = ''
WHERE id_product = '16039'
23/01/2023 05:05:31 pm >> UPDATE ps_product SET
wholesale_price = '6.93',
on_sale = '0',
price = '9.9000'
WHERE id_product = '16039'
23/01/2023 05:05:31 pm >> UPDATE ps_product_shop SET
wholesale_price = '6.93',
price = '9.9000',
id_tax_rules_group = '4',
id_category_default = '103',
id_argoment_default = '21',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '16039'
23/01/2023 05:05:31 pm >> DELETE FROM ps_specific_price WHERE id_product = '16039'
23/01/2023 05:05:46 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788868940478' AND id_product != '2599' AND ean13 != ''
23/01/2023 05:05:46 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '2/1',
ean13 = '9788868940478',
date_upd = NOW()
WHERE id_product = '2599'
23/01/2023 05:05:46 pm >> UPDATE ps_product_lang SET
name = 'CON TE! - FIGLI',
description = ''
WHERE id_product = '2599'
23/01/2023 05:05:46 pm >> UPDATE ps_product SET
wholesale_price = '3.85',
on_sale = '0',
price = '5.5000'
WHERE id_product = '2599'
23/01/2023 05:05:46 pm >> UPDATE ps_product_shop SET
wholesale_price = '3.85',
price = '5.5000',
id_tax_rules_group = '4',
id_category_default = '103',
id_argoment_default = '56',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '2599'
23/01/2023 05:05:46 pm >> DELETE FROM ps_specific_price WHERE id_product = '2599'
23/01/2023 05:05:59 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788868943158' AND id_product != '15197' AND ean13 != ''
23/01/2023 05:05:59 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '2/1',
ean13 = '9788868943158',
date_upd = NOW()
WHERE id_product = '15197'
23/01/2023 05:05:59 pm >> UPDATE ps_product_lang SET
name = 'PER VIVERE CON TE ',
description = ''
WHERE id_product = '15197'
23/01/2023 05:05:59 pm >> UPDATE ps_product SET
wholesale_price = '3.85',
on_sale = '0',
price = '5.5000'
WHERE id_product = '15197'
23/01/2023 05:05:59 pm >> UPDATE ps_product_shop SET
wholesale_price = '3.85',
price = '5.5000',
id_tax_rules_group = '4',
id_category_default = '103',
id_argoment_default = '28',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '15197'
23/01/2023 05:05:59 pm >> DELETE FROM ps_specific_price WHERE id_product = '15197'
23/01/2023 05:07:36 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801059779' AND id_product != '7974' AND ean13 != ''
23/01/2023 05:07:36 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '2/1',
ean13 = '9788801059779',
date_upd = NOW()
WHERE id_product = '7974'
23/01/2023 05:07:36 pm >> UPDATE ps_product_lang SET
name = 'PIACERE, DIO! 5 - QUADERNO',
description = ''
WHERE id_product = '7974'
23/01/2023 05:07:36 pm >> UPDATE ps_product SET
wholesale_price = '3.25',
on_sale = '0',
price = '5.0000'
WHERE id_product = '7974'
23/01/2023 05:07:36 pm >> UPDATE ps_product_shop SET
wholesale_price = '3.25',
price = '5.0000',
id_tax_rules_group = '4',
id_category_default = '19',
id_argoment_default = '12',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '7974'
23/01/2023 05:07:36 pm >> DELETE FROM ps_specific_price WHERE id_product = '7974'
23/01/2023 05:07:49 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801058284' AND id_product != '7966' AND ean13 != ''
23/01/2023 05:07:50 pm >> UPDATE ps_product SET
id_supplier = '',
reference = '2/1',
ean13 = '9788801058284',
date_upd = NOW()
WHERE id_product = '7966'
23/01/2023 05:07:50 pm >> UPDATE ps_product_lang SET
name = 'PIACERE DIO 4 - SUSSIDIO - A. PEIRETTI',
description = ''
WHERE id_product = '7966'
23/01/2023 05:07:50 pm >> UPDATE ps_product SET
wholesale_price = '3.25',
on_sale = '0',
price = '5.0000'
WHERE id_product = '7966'
23/01/2023 05:07:50 pm >> UPDATE ps_product_shop SET
wholesale_price = '3.25',
price = '5.0000',
id_tax_rules_group = '4',
id_category_default = '19',
id_argoment_default = '12',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '7966'
23/01/2023 05:07:50 pm >> DELETE FROM ps_specific_price WHERE id_product = '7966'
23/01/2023 05:08:02 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801056631' AND id_product != '7972' AND ean13 != ''
23/01/2023 05:08:02 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '2/1',
ean13 = '9788801056631',
date_upd = NOW()
WHERE id_product = '7972'
23/01/2023 05:08:02 pm >> UPDATE ps_product_lang SET
name = 'PIACERE DIO! 3 QUADERNO - A. PAIRETTI',
description = ''
WHERE id_product = '7972'
23/01/2023 05:08:02 pm >> UPDATE ps_product SET
wholesale_price = '3.31',
on_sale = '0',
price = '5.0000'
WHERE id_product = '7972'
23/01/2023 05:08:02 pm >> UPDATE ps_product_shop SET
wholesale_price = '3.31',
price = '5.0000',
id_tax_rules_group = '4',
id_category_default = '19',
id_argoment_default = '21',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '7972'
23/01/2023 05:08:02 pm >> DELETE FROM ps_specific_price WHERE id_product = '7972'
23/01/2023 05:08:15 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801050127' AND id_product != '7968' AND ean13 != ''
23/01/2023 05:08:15 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '2/1',
ean13 = '9788801050127',
date_upd = NOW()
WHERE id_product = '7968'
23/01/2023 05:08:15 pm >> UPDATE ps_product_lang SET
name = 'PIACERE DIO! 1 QUADERNO - A. PEIRETTI',
description = ''
WHERE id_product = '7968'
23/01/2023 05:08:15 pm >> UPDATE ps_product SET
wholesale_price = '3.25',
on_sale = '0',
price = '5.0000'
WHERE id_product = '7968'
23/01/2023 05:08:15 pm >> UPDATE ps_product_shop SET
wholesale_price = '3.25',
price = '5.0000',
id_tax_rules_group = '4',
id_category_default = '19',
id_argoment_default = '12',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '7968'
23/01/2023 05:08:15 pm >> DELETE FROM ps_specific_price WHERE id_product = '7968'
23/01/2023 05:08:28 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801054163' AND id_product != '7970' AND ean13 != ''
23/01/2023 05:08:28 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '2/1',
ean13 = '9788801054163',
date_upd = NOW()
WHERE id_product = '7970'
23/01/2023 05:08:28 pm >> UPDATE ps_product_lang SET
name = 'PIACERE DIO! 2 QUADERNO - A. PAIRETTI',
description = ''
WHERE id_product = '7970'
23/01/2023 05:08:28 pm >> UPDATE ps_product SET
wholesale_price = '3.25',
on_sale = '0',
price = '5.0000'
WHERE id_product = '7970'
23/01/2023 05:08:28 pm >> UPDATE ps_product_shop SET
wholesale_price = '3.25',
price = '5.0000',
id_tax_rules_group = '4',
id_category_default = '19',
id_argoment_default = '12',
id_internal_category = '',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '7970'
23/01/2023 05:08:28 pm >> DELETE FROM ps_specific_price WHERE id_product = '7970'
23/01/2023 05:08:43 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801058291' AND id_product != '7965' AND ean13 != ''
23/01/2023 05:08:43 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '2/1',
ean13 = '9788801058291',
date_upd = NOW()
WHERE id_product = '7965'
23/01/2023 05:08:43 pm >> UPDATE ps_product_lang SET
name = 'PIACERE DIO 4 - GUIDA - PEIRETTI/FERRERO',
description = ''
WHERE id_product = '7965'
23/01/2023 05:08:43 pm >> UPDATE ps_product SET
wholesale_price = '10.73',
on_sale = '0',
price = '16.5000'
WHERE id_product = '7965'
23/01/2023 05:08:43 pm >> UPDATE ps_product_shop SET
wholesale_price = '10.73',
price = '16.5000',
id_tax_rules_group = '4',
id_category_default = '19',
id_argoment_default = '12',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '7965'
23/01/2023 05:08:43 pm >> DELETE FROM ps_specific_price WHERE id_product = '7965'
23/01/2023 05:08:56 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801054170' AND id_product != '7969' AND ean13 != ''
23/01/2023 05:08:56 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '2/1',
ean13 = '9788801054170',
date_upd = NOW()
WHERE id_product = '7969'
23/01/2023 05:08:56 pm >> UPDATE ps_product_lang SET
name = 'PIACERE DIO! 2 GUIDA - FERRERO/PAIRETTI',
description = ''
WHERE id_product = '7969'
23/01/2023 05:08:56 pm >> UPDATE ps_product SET
wholesale_price = '10.40',
on_sale = '0',
price = '16.0000'
WHERE id_product = '7969'
23/01/2023 05:08:56 pm >> UPDATE ps_product_shop SET
wholesale_price = '10.40',
price = '16.0000',
id_tax_rules_group = '4',
id_category_default = '19',
id_argoment_default = '12',
id_internal_category = '',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '7969'
23/01/2023 05:08:56 pm >> DELETE FROM ps_specific_price WHERE id_product = '7969'
23/01/2023 05:09:10 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801056648' AND id_product != '7971' AND ean13 != ''
23/01/2023 05:09:10 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '2/1',
ean13 = '9788801056648',
date_upd = NOW()
WHERE id_product = '7971'
23/01/2023 05:09:10 pm >> UPDATE ps_product_lang SET
name = 'PIACERE DIO! 3 GUIDA - PEIRETTI/FERRERO',
description = ''
WHERE id_product = '7971'
23/01/2023 05:09:10 pm >> UPDATE ps_product SET
wholesale_price = '10.73',
on_sale = '0',
price = '16.5000'
WHERE id_product = '7971'
23/01/2023 05:09:10 pm >> UPDATE ps_product_shop SET
wholesale_price = '10.73',
price = '16.5000',
id_tax_rules_group = '4',
id_category_default = '19',
id_argoment_default = '21',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '7971'
23/01/2023 05:09:10 pm >> DELETE FROM ps_specific_price WHERE id_product = '7971'
23/01/2023 05:09:23 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801059786' AND id_product != '7973' AND ean13 != ''
23/01/2023 05:09:23 pm >> UPDATE ps_product SET
id_supplier = '',
reference = '2/1',
ean13 = '9788801059786',
date_upd = NOW()
WHERE id_product = '7973'
23/01/2023 05:09:23 pm >> UPDATE ps_product_lang SET
name = 'PIACERE, DIO! 5 - GUIDA',
description = ''
WHERE id_product = '7973'
23/01/2023 05:09:23 pm >> UPDATE ps_product SET
wholesale_price = '12.03',
on_sale = '0',
price = '18.5000'
WHERE id_product = '7973'
23/01/2023 05:09:23 pm >> UPDATE ps_product_shop SET
wholesale_price = '12.03',
price = '18.5000',
id_tax_rules_group = '4',
id_category_default = '19',
id_argoment_default = '12',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '7973'
23/01/2023 05:09:23 pm >> DELETE FROM ps_specific_price WHERE id_product = '7973'
23/01/2023 05:09:34 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801052190' AND id_product != '7967' AND ean13 != ''
23/01/2023 05:09:34 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '2/1',
ean13 = '9788801052190',
date_upd = NOW()
WHERE id_product = '7967'
23/01/2023 05:09:34 pm >> UPDATE ps_product_lang SET
name = 'PIACERE DIO! 1 GUIDA - PEIRETTI/FERRERO',
description = ''
WHERE id_product = '7967'
23/01/2023 05:09:34 pm >> UPDATE ps_product SET
wholesale_price = '9.75',
on_sale = '0',
price = '15.0000'
WHERE id_product = '7967'
23/01/2023 05:09:34 pm >> UPDATE ps_product_shop SET
wholesale_price = '9.75',
price = '15.0000',
id_tax_rules_group = '4',
id_category_default = '19',
id_argoment_default = '12',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '7967'
23/01/2023 05:09:34 pm >> DELETE FROM ps_specific_price WHERE id_product = '7967'
23/01/2023 05:12:00 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801067606' AND id_product != '18565' AND ean13 != ''
23/01/2023 05:12:00 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '2/2',
ean13 = '9788801067606',
date_upd = NOW()
WHERE id_product = '18565'
23/01/2023 05:12:00 pm >> UPDATE ps_product_lang SET
name = 'CONNESSI CON GESU\' - GUIDA 6',
description = ''
WHERE id_product = '18565'
23/01/2023 05:12:00 pm >> UPDATE ps_product SET
wholesale_price = '9.75',
on_sale = '0',
price = '15.0000'
WHERE id_product = '18565'
23/01/2023 05:12:00 pm >> UPDATE ps_product_shop SET
wholesale_price = '9.75',
price = '15.0000',
id_tax_rules_group = '4',
id_category_default = '19',
id_argoment_default = '21',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '18565'
23/01/2023 05:12:00 pm >> DELETE FROM ps_specific_price WHERE id_product = '18565'
23/01/2023 05:12:28 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801062885' AND id_product != '12922' AND ean13 != ''
23/01/2023 05:12:28 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '2/2',
ean13 = '9788801062885',
date_upd = NOW()
WHERE id_product = '12922'
23/01/2023 05:12:28 pm >> UPDATE ps_product_lang SET
name = 'IMPRONTE DI MISERICORDIA - GUIDA 2',
description = ''
WHERE id_product = '12922'
23/01/2023 05:12:28 pm >> UPDATE ps_product SET
wholesale_price = '9.75',
on_sale = '0',
price = '15.0000'
WHERE id_product = '12922'
23/01/2023 05:12:28 pm >> UPDATE ps_product_shop SET
wholesale_price = '9.75',
price = '15.0000',
id_tax_rules_group = '4',
id_category_default = '19',
id_argoment_default = '12',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '12922'
23/01/2023 05:12:28 pm >> DELETE FROM ps_specific_price WHERE id_product = '12922'
23/01/2023 05:12:55 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801062878' AND id_product != '12864' AND ean13 != ''
23/01/2023 05:12:55 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '2/2',
ean13 = '9788801062878',
date_upd = NOW()
WHERE id_product = '12864'
23/01/2023 05:12:55 pm >> UPDATE ps_product_lang SET
name = 'IMPRONTE DI MISERICORDIA E DI PERDONO - SUSSIDIO',
description = ''
WHERE id_product = '12864'
23/01/2023 05:12:55 pm >> UPDATE ps_product SET
wholesale_price = '3.25',
on_sale = '0',
price = '5.0000'
WHERE id_product = '12864'
23/01/2023 05:12:55 pm >> UPDATE ps_product_shop SET
wholesale_price = '3.25',
price = '5.0000',
id_tax_rules_group = '4',
id_category_default = '19',
id_argoment_default = '12',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '12864'
23/01/2023 05:12:55 pm >> DELETE FROM ps_specific_price WHERE id_product = '12864'
23/01/2023 05:13:13 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801067590' AND id_product != '18564' AND ean13 != ''
23/01/2023 05:13:13 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '2/2',
ean13 = '9788801067590',
date_upd = NOW()
WHERE id_product = '18564'
23/01/2023 05:13:13 pm >> UPDATE ps_product_lang SET
name = 'CONNESSI CON GESU’ - AGENDUM 2',
description = ''
WHERE id_product = '18564'
23/01/2023 05:13:13 pm >> UPDATE ps_product SET
wholesale_price = '3.25',
on_sale = '0',
price = '5.0000'
WHERE id_product = '18564'
23/01/2023 05:13:13 pm >> UPDATE ps_product_shop SET
wholesale_price = '3.25',
price = '5.0000',
id_tax_rules_group = '4',
id_category_default = '19',
id_argoment_default = '21',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '18564'
23/01/2023 05:13:13 pm >> DELETE FROM ps_specific_price WHERE id_product = '18564'
23/01/2023 05:20:04 pm >> SELECT document_num FROM ps_document
WHERE document_num = '229' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-23')
23/01/2023 05:20:04 pm >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'229' ,
'2023-01-23' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'13.00' ,
'10.66' ,
NOW() ,
NOW() )
23/01/2023 05:20:04 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '80472'
23/01/2023 05:20:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '80472'
23/01/2023 05:20:04 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
( '80472' , '19102' , 'CARBONCINI MM 40' , '1' , '-1' , '1' ,
'13.00' , '10.655737704918' , '22' , '0' , '13.00' )
23/01/2023 05:22:51 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788861245884' AND id_product != '14719' AND ean13 != ''
23/01/2023 05:22:51 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '2/2',
ean13 = '9788861245884',
date_upd = NOW()
WHERE id_product = '14719'
23/01/2023 05:22:51 pm >> UPDATE ps_product_lang SET
name = 'TU MI AMI DAVVERO',
description = ''
WHERE id_product = '14719'
23/01/2023 05:22:51 pm >> UPDATE ps_product SET
wholesale_price = '4.13',
on_sale = '0',
price = '5.9000'
WHERE id_product = '14719'
23/01/2023 05:22:51 pm >> UPDATE ps_product_shop SET
wholesale_price = '4.13',
price = '5.9000',
id_tax_rules_group = '4',
id_category_default = '26',
id_argoment_default = '108',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '14719'
23/01/2023 05:22:51 pm >> DELETE FROM ps_specific_price WHERE id_product = '14719'
23/01/2023 05:25:14 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831555364' AND id_product != '20455' AND ean13 != ''
23/01/2023 05:25:14 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '2/1',
ean13 = '9788831555364',
date_upd = NOW()
WHERE id_product = '20455'
23/01/2023 05:25:14 pm >> UPDATE ps_product_lang SET
name = 'GRANDI INSIEME GENITORI E FIGLI 12-18',
description = ''
WHERE id_product = '20455'
23/01/2023 05:25:14 pm >> UPDATE ps_product SET
wholesale_price = '6.70',
on_sale = '0',
price = '10.0000'
WHERE id_product = '20455'
23/01/2023 05:25:14 pm >> UPDATE ps_product_shop SET
wholesale_price = '6.70',
price = '10.0000',
id_tax_rules_group = '4',
id_category_default = '27',
id_argoment_default = '22',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '20455'
23/01/2023 05:25:14 pm >> DELETE FROM ps_specific_price WHERE id_product = '20455'
23/01/2023 05:25:27 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831555357' AND id_product != '20456' AND ean13 != ''
23/01/2023 05:25:28 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '2/1',
ean13 = '9788831555357',
date_upd = NOW()
WHERE id_product = '20456'
23/01/2023 05:25:28 pm >> UPDATE ps_product_lang SET
name = 'GRANDI INSIEME GENITORI E FIGLI 6-12',
description = ''
WHERE id_product = '20456'
23/01/2023 05:25:28 pm >> UPDATE ps_product SET
wholesale_price = '6.70',
on_sale = '0',
price = '10.0000'
WHERE id_product = '20456'
23/01/2023 05:25:28 pm >> UPDATE ps_product_shop SET
wholesale_price = '6.70',
price = '10.0000',
id_tax_rules_group = '4',
id_category_default = '27',
id_argoment_default = '22',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '20456'
23/01/2023 05:25:28 pm >> DELETE FROM ps_specific_price WHERE id_product = '20456'
23/01/2023 05:25:40 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831555340' AND id_product != '20454' AND ean13 != ''
23/01/2023 05:25:40 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '2/1',
ean13 = '9788831555340',
date_upd = NOW()
WHERE id_product = '20454'
23/01/2023 05:25:40 pm >> UPDATE ps_product_lang SET
name = 'GRANDI INSIEME GENITORI E FIGLI 0-6',
description = ''
WHERE id_product = '20454'
23/01/2023 05:25:40 pm >> UPDATE ps_product SET
wholesale_price = '6.70',
on_sale = '0',
price = '10.0000'
WHERE id_product = '20454'
23/01/2023 05:25:40 pm >> UPDATE ps_product_shop SET
wholesale_price = '6.70',
price = '10.0000',
id_tax_rules_group = '4',
id_category_default = '27',
id_argoment_default = '22',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '20454'
23/01/2023 05:25:40 pm >> DELETE FROM ps_specific_price WHERE id_product = '20454'
23/01/2023 05:26:29 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831554176' AND id_product != '20042' AND ean13 != ''
23/01/2023 05:26:29 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '2/2',
ean13 = '9788831554176',
date_upd = NOW()
WHERE id_product = '20042'
23/01/2023 05:26:29 pm >> UPDATE ps_product_lang SET
name = 'FOLLOWERS DIARIO FAMIGLIE 2',
description = ''
WHERE id_product = '20042'
23/01/2023 05:26:29 pm >> UPDATE ps_product SET
wholesale_price = '4.36',
on_sale = '0',
price = '6.5000'
WHERE id_product = '20042'
23/01/2023 05:26:29 pm >> UPDATE ps_product_shop SET
wholesale_price = '4.36',
price = '6.5000',
id_tax_rules_group = '4',
id_category_default = '27',
id_argoment_default = '22',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '20042'
23/01/2023 05:26:29 pm >> DELETE FROM ps_specific_price WHERE id_product = '20042'
23/01/2023 05:26:41 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831553902' AND id_product != '20041' AND ean13 != ''
23/01/2023 05:26:41 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '2/2',
ean13 = '9788831553902',
date_upd = NOW()
WHERE id_product = '20041'
23/01/2023 05:26:41 pm >> UPDATE ps_product_lang SET
name = 'FOLLOWERS DIARIO FAMIGLIE 1',
description = ''
WHERE id_product = '20041'
23/01/2023 05:26:41 pm >> UPDATE ps_product SET
wholesale_price = '4.36',
on_sale = '0',
price = '6.5000'
WHERE id_product = '20041'
23/01/2023 05:26:41 pm >> UPDATE ps_product_shop SET
wholesale_price = '4.36',
price = '6.5000',
id_tax_rules_group = '4',
id_category_default = '27',
id_argoment_default = '22',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '20041'
23/01/2023 05:26:41 pm >> DELETE FROM ps_specific_price WHERE id_product = '20041'
23/01/2023 05:26:52 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831554183' AND id_product != '20097' AND ean13 != ''
23/01/2023 05:26:52 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '2/2',
ean13 = '9788831554183',
date_upd = NOW()
WHERE id_product = '20097'
23/01/2023 05:26:52 pm >> UPDATE ps_product_lang SET
name = 'FOLLOWERS DIARIO FAMIGLIA 3',
description = ''
WHERE id_product = '20097'
23/01/2023 05:26:52 pm >> UPDATE ps_product SET
wholesale_price = '4.36',
on_sale = '0',
price = '6.5000'
WHERE id_product = '20097'
23/01/2023 05:26:53 pm >> UPDATE ps_product_shop SET
wholesale_price = '4.36',
price = '6.5000',
id_tax_rules_group = '4',
id_category_default = '27',
id_argoment_default = '22',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '20097'
23/01/2023 05:26:53 pm >> DELETE FROM ps_specific_price WHERE id_product = '20097'
23/01/2023 05:27:26 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831553728' AND id_product != '18703' AND ean13 != ''
23/01/2023 05:27:26 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '2/2',
ean13 = '9788831553728',
date_upd = NOW()
WHERE id_product = '18703'
23/01/2023 05:27:26 pm >> UPDATE ps_product_lang SET
name = 'IN_SEGUENDO GESU\' A CAFARNAO',
description = ''
WHERE id_product = '18703'
23/01/2023 05:27:26 pm >> UPDATE ps_product SET
wholesale_price = '3.35',
on_sale = '0',
price = '5.0000'
WHERE id_product = '18703'
23/01/2023 05:27:26 pm >> UPDATE ps_product_shop SET
wholesale_price = '3.35',
price = '5.0000',
id_tax_rules_group = '4',
id_category_default = '27',
id_argoment_default = '12',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '18703'
23/01/2023 05:27:26 pm >> DELETE FROM ps_specific_price WHERE id_product = '18703'
23/01/2023 05:27:41 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831553889' AND id_product != '18704' AND ean13 != ''
23/01/2023 05:27:42 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '2/2',
ean13 = '9788831553889',
date_upd = NOW()
WHERE id_product = '18704'
23/01/2023 05:27:42 pm >> UPDATE ps_product_lang SET
name = 'IN_SEGUENDO GESU\' A NAZARET',
description = ''
WHERE id_product = '18704'
23/01/2023 05:27:42 pm >> UPDATE ps_product SET
wholesale_price = '3.35',
on_sale = '0',
price = '5.0000'
WHERE id_product = '18704'
23/01/2023 05:27:42 pm >> UPDATE ps_product_shop SET
wholesale_price = '3.35',
price = '5.0000',
id_tax_rules_group = '4',
id_category_default = '27',
id_argoment_default = '12',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '18704'
23/01/2023 05:27:42 pm >> DELETE FROM ps_specific_price WHERE id_product = '18704'
23/01/2023 05:27:59 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831553896' AND id_product != '18691' AND ean13 != ''
23/01/2023 05:27:59 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '2/2',
ean13 = '9788831553896',
date_upd = NOW()
WHERE id_product = '18691'
23/01/2023 05:27:59 pm >> UPDATE ps_product_lang SET
name = 'IN_SEGUENDO GESU\' a emmaus - QUADERNO',
description = ''
WHERE id_product = '18691'
23/01/2023 05:27:59 pm >> UPDATE ps_product SET
wholesale_price = '3.35',
on_sale = '0',
price = '5.0000'
WHERE id_product = '18691'
23/01/2023 05:27:59 pm >> UPDATE ps_product_shop SET
wholesale_price = '3.35',
price = '5.0000',
id_tax_rules_group = '4',
id_category_default = '27',
id_argoment_default = '21',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '18691'
23/01/2023 05:27:59 pm >> DELETE FROM ps_specific_price WHERE id_product = '18691'
23/01/2023 05:28:12 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831555241' AND id_product != '20137' AND ean13 != ''
23/01/2023 05:28:12 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '2/2',
ean13 = '9788831555241',
date_upd = NOW()
WHERE id_product = '20137'
23/01/2023 05:28:12 pm >> UPDATE ps_product_lang SET
name = 'FOLLOWERS 2.0 - QUADERNO',
description = ''
WHERE id_product = '20137'
23/01/2023 05:28:12 pm >> UPDATE ps_product SET
wholesale_price = '5.36',
on_sale = '0',
price = '8.0000'
WHERE id_product = '20137'
23/01/2023 05:28:12 pm >> UPDATE ps_product_shop SET
wholesale_price = '5.36',
price = '8.0000',
id_tax_rules_group = '4',
id_category_default = '27',
id_argoment_default = '58',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '20137'
23/01/2023 05:28:12 pm >> DELETE FROM ps_specific_price WHERE id_product = '20137'
23/01/2023 05:28:27 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831555234' AND id_product != '20043' AND ean13 != ''
23/01/2023 05:28:27 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '2/2',
ean13 = '9788831555234',
date_upd = NOW()
WHERE id_product = '20043'
23/01/2023 05:28:27 pm >> UPDATE ps_product_lang SET
name = 'FOLLOWERS 2.0 - GUIDA',
description = ''
WHERE id_product = '20043'
23/01/2023 05:28:27 pm >> UPDATE ps_product SET
wholesale_price = '9.38',
on_sale = '0',
price = '14.0000'
WHERE id_product = '20043'
23/01/2023 05:28:27 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 = '22',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '20043'
23/01/2023 05:28:27 pm >> DELETE FROM ps_specific_price WHERE id_product = '20043'
23/01/2023 05:28:48 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831553711' AND id_product != '18692' AND ean13 != ''
23/01/2023 05:28:48 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '2/2',
ean13 = '9788831553711',
date_upd = NOW()
WHERE id_product = '18692'
23/01/2023 05:28:48 pm >> UPDATE ps_product_lang SET
name = 'IN_SEGUENDO GESU\' - GUIDA',
description = ''
WHERE id_product = '18692'
23/01/2023 05:28:49 pm >> UPDATE ps_product SET
wholesale_price = '8.04',
on_sale = '0',
price = '12.0000'
WHERE id_product = '18692'
23/01/2023 05:28:49 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 = '21',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '18692'
23/01/2023 05:28:49 pm >> DELETE FROM ps_specific_price WHERE id_product = '18692'
23/01/2023 05:33:47 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788825049756' AND id_product != '15634' AND ean13 != ''
23/01/2023 05:33:47 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '2/3',
ean13 = '9788825049756',
date_upd = NOW()
WHERE id_product = '15634'
23/01/2023 05:33:47 pm >> UPDATE ps_product_lang SET
name = 'GESU\' E\' MIO AMICO - 2-5 ANNI',
description = ''
WHERE id_product = '15634'
23/01/2023 05:33:47 pm >> UPDATE ps_product SET
wholesale_price = '1.54',
on_sale = '0',
price = '2.2000'
WHERE id_product = '15634'
23/01/2023 05:33:48 pm >> UPDATE ps_product_shop SET
wholesale_price = '1.54',
price = '2.2000',
id_tax_rules_group = '4',
id_category_default = '17',
id_argoment_default = '12',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '15634'
23/01/2023 05:33:48 pm >> DELETE FROM ps_specific_price WHERE id_product = '15634'
23/01/2023 05:37:11 pm >> INSERT INTO ps_customer
( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` )
VALUES
( '1' , '' , '' , '' , 'B9N0Rmhhb0xhkWxE' , NOW() , NOW() )
23/01/2023 05:37:11 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4002' , '1' )
23/01/2023 05:37:11 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4002' , '2' )
23/01/2023 05:37:11 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4002' , '3' )
23/01/2023 05:40:04 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4002'
23/01/2023 05:40:04 pm >> INSERT INTO ps_address
( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd )
VALUES (
'4002' ,
'10' ,
'133' ,
'PARROCCHIA SANTA LUCIA' ,
'RECH' ,
'DON GIANNI' ,
'VIA RAMO 3' ,
'' ,
'32040' ,
'VODO DI CADORE' ,
'' ,
'' ,
'3382147471' ,
'' ,
'83000930251' ,
NOW() ,
NOW() )
23/01/2023 05:40:04 pm >> UPDATE ps_customer SET
email = 'rg142005@libero.it',
sdi = '',
pec = '',
date_upd = NOW()
WHERE id_customer = '4002'
23/01/2023 05:43:28 pm >> SELECT document_num FROM ps_document
WHERE document_num = '16' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-01-23')
23/01/2023 05:43:28 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 (
'21' ,
'16' ,
'2023-01-23' ,
'' ,
'4002' ,
'0' ,
'4678462' ,
'VIA RAMO 3 32040 VODO DI CADORE' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'66.75' ,
'66.75' ,
NOW() ,
NOW() )
23/01/2023 05:43:28 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 = '80473'
23/01/2023 05:43:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '80473'
23/01/2023 05:43:28 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
( '80473' , '16603' , 'LIBRO INTENZIONI SANTE MESSE' , '2' , '-2' , '4' ,
'12.00' , '12' , '0' , '10' , '21.60' )
23/01/2023 05:43:28 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
( '80473' , '1041' , 'BENEDIZIONI' , '200' , '-200' , '0' ,
'0.18' , '0.18' , '' , '10' , '32.40' )
23/01/2023 05:43:28 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
( '80473' , '15020' , 'PREGARE OGNI GIORNO' , '15' , '-15' , '4' ,
'1.00' , '1' , '0' , '15' , '12.75' )
23/01/2023 05:44:10 pm >> SELECT document_num FROM ps_document
WHERE document_num = '16' AND id_document != '80473' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-01-23')
23/01/2023 05:44:10 pm >> UPDATE ps_document SET
id_document_type = '21',
document_num = '16',
document_date = '2023-01-23',
document_letter = '',
id_customer = '4002',
id_supplier = '',
id_address = '4678462',
address1 = 'VIA RAMO 3 32040 VODO DI CADORE',
address2 = '',
note = '',
price_shipping = '0.00',
id_tax_shipping_rules = '4',
colli = '0',
peso = '0',
porto_e_imballo = '0',
mezzo_consegna = '',
id_payment = '9',
id_causal = '0',
price_tax_included = '66.75',
price_tax_excluded = '66.75',
date_upd = NOW()
WHERE id_document = '80473'
23/01/2023 05:44: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 = '80473'
23/01/2023 05:44:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '80473'
23/01/2023 05:44: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
( '80473' , '16603' , 'LIBRO INTENZIONI SANTE MESSE' , '2' , '-2' , '4' ,
'12.0000' , '12' , '0' , '10' , '21.60' )
23/01/2023 05:44: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
( '80473' , '1041' , 'BENEDIZIONI' , '200' , '-200' , '0' ,
'0.1800' , '0.18' , '0' , '10' , '32.40' )
23/01/2023 05:44: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
( '80473' , '15020' , 'PREGARE OGNI GIORNO' , '15' , '-15' , '4' ,
'1.0000' , '1' , '0' , '15' , '12.75' )
23/01/2023 06:05:49 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788861081086' AND id_product != '14322' AND ean13 != ''
23/01/2023 06:05:49 pm >> UPDATE ps_product SET
id_supplier = '107',
reference = '2/3',
ean13 = '9788861081086',
date_upd = NOW()
WHERE id_product = '14322'
23/01/2023 06:05:49 pm >> UPDATE ps_product_lang SET
name = 'RELIGIOCANDO - SACRAMENTI E MIRACOLI',
description = ''
WHERE id_product = '14322'
23/01/2023 06:05:49 pm >> UPDATE ps_product SET
wholesale_price = '5.59',
on_sale = '0',
price = '8.6000'
WHERE id_product = '14322'
23/01/2023 06:05:50 pm >> UPDATE ps_product_shop SET
wholesale_price = '5.59',
price = '8.6000',
id_tax_rules_group = '4',
id_category_default = '15',
id_argoment_default = '12',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '14322'
23/01/2023 06:05:50 pm >> DELETE FROM ps_specific_price WHERE id_product = '14322'
23/01/2023 06:06:05 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788861080539' AND id_product != '14323' AND ean13 != ''
23/01/2023 06:06:05 pm >> UPDATE ps_product SET
id_supplier = '107',
reference = '2/3',
ean13 = '9788861080539',
date_upd = NOW()
WHERE id_product = '14323'
23/01/2023 06:06:05 pm >> UPDATE ps_product_lang SET
name = 'RELIGIOCANDO - ANTICO TESTAMENTO',
description = ''
WHERE id_product = '14323'
23/01/2023 06:06:05 pm >> UPDATE ps_product SET
wholesale_price = '1.63',
on_sale = '0',
price = '2.5000'
WHERE id_product = '14323'
23/01/2023 06:06:05 pm >> UPDATE ps_product_shop SET
wholesale_price = '1.63',
price = '2.5000',
id_tax_rules_group = '4',
id_category_default = '15',
id_argoment_default = '12',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '14323'
23/01/2023 06:06:05 pm >> DELETE FROM ps_specific_price WHERE id_product = '14323'
23/01/2023 06:06:23 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788861247215' AND id_product != '14558' AND ean13 != ''
23/01/2023 06:06:23 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '2/3',
ean13 = '9788861247215',
date_upd = NOW()
WHERE id_product = '14558'
23/01/2023 06:06:23 pm >> UPDATE ps_product_lang SET
name = 'CONOSCI LA STORIA DELLA SALVEZZA - GUIDA',
description = ''
WHERE id_product = '14558'
23/01/2023 06:06:23 pm >> UPDATE ps_product SET
wholesale_price = '3.43',
on_sale = '0',
price = '4.9000'
WHERE id_product = '14558'
23/01/2023 06:06:23 pm >> UPDATE ps_product_shop SET
wholesale_price = '3.43',
price = '4.9000',
id_tax_rules_group = '4',
id_category_default = '26',
id_argoment_default = '12',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '14558'
23/01/2023 06:06:23 pm >> DELETE FROM ps_specific_price WHERE id_product = '14558'
23/01/2023 06:06:35 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788861247178' AND id_product != '14559' AND ean13 != ''
23/01/2023 06:06:36 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '2/3',
ean13 = '9788861247178',
date_upd = NOW()
WHERE id_product = '14559'
23/01/2023 06:06:36 pm >> UPDATE ps_product_lang SET
name = 'CONOSCI LA STORIA DELLA SALVEZZA - QUADERNO',
description = ''
WHERE id_product = '14559'
23/01/2023 06:06:36 pm >> UPDATE ps_product SET
wholesale_price = '4.13',
on_sale = '0',
price = '5.9000'
WHERE id_product = '14559'
23/01/2023 06:06:36 pm >> UPDATE ps_product_shop SET
wholesale_price = '4.13',
price = '5.9000',
id_tax_rules_group = '4',
id_category_default = '26',
id_argoment_default = '12',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '14559'
23/01/2023 06:06:36 pm >> DELETE FROM ps_specific_price WHERE id_product = '14559'
23/01/2023 06:06:52 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788861248120' AND id_product != '17318' AND ean13 != ''
23/01/2023 06:06:52 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '2/3',
ean13 = '9788861248120',
date_upd = NOW()
WHERE id_product = '17318'
23/01/2023 06:06:52 pm >> UPDATE ps_product_lang SET
name = 'CONOSCI LO SPIRITO SANTO - GUIDA',
description = ''
WHERE id_product = '17318'
23/01/2023 06:06:52 pm >> UPDATE ps_product SET
wholesale_price = '3.43',
on_sale = '0',
price = '4.9000'
WHERE id_product = '17318'
23/01/2023 06:06:52 pm >> UPDATE ps_product_shop SET
wholesale_price = '3.43',
price = '4.9000',
id_tax_rules_group = '4',
id_category_default = '26',
id_argoment_default = '108',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '17318'
23/01/2023 06:06:52 pm >> DELETE FROM ps_specific_price WHERE id_product = '17318'
23/01/2023 06:07:19 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788861247222' AND id_product != '14646' AND ean13 != ''
23/01/2023 06:07:19 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '2/3',
ean13 = '9788861247222',
date_upd = NOW()
WHERE id_product = '14646'
23/01/2023 06:07:19 pm >> UPDATE ps_product_lang SET
name = 'CONOSCI LA CENA DEL SIGNORE - GUIDA',
description = ''
WHERE id_product = '14646'
23/01/2023 06:07:19 pm >> UPDATE ps_product SET
wholesale_price = '3.43',
on_sale = '0',
price = '4.9000'
WHERE id_product = '14646'
23/01/2023 06:07:19 pm >> UPDATE ps_product_shop SET
wholesale_price = '3.43',
price = '4.9000',
id_tax_rules_group = '4',
id_category_default = '26',
id_argoment_default = '108',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '14646'
23/01/2023 06:07:19 pm >> DELETE FROM ps_specific_price WHERE id_product = '14646'
23/01/2023 06:07:38 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801058567' AND id_product != '2440' AND ean13 != ''
23/01/2023 06:07:38 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '2/3',
ean13 = '9788801058567',
date_upd = NOW()
WHERE id_product = '2440'
23/01/2023 06:07:38 pm >> UPDATE ps_product_lang SET
name = 'COLORO IL MIO GESÙ',
description = ''
WHERE id_product = '2440'
23/01/2023 06:07:38 pm >> UPDATE ps_product SET
wholesale_price = '3.19',
on_sale = '0',
price = '4.9000'
WHERE id_product = '2440'
23/01/2023 06:07:38 pm >> UPDATE ps_product_shop SET
wholesale_price = '3.19',
price = '4.9000',
id_tax_rules_group = '4',
id_category_default = '19',
id_argoment_default = '25',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '2440'
23/01/2023 06:07:38 pm >> DELETE FROM ps_specific_price WHERE id_product = '2440'
23/01/2023 06:07:52 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788861248656' AND id_product != '18432' AND ean13 != ''
23/01/2023 06:07:52 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '2/3',
ean13 = '9788861248656',
date_upd = NOW()
WHERE id_product = '18432'
23/01/2023 06:07:52 pm >> UPDATE ps_product_lang SET
name = 'SETTE SACRAMENTI ',
description = ''
WHERE id_product = '18432'
23/01/2023 06:07:52 pm >> UPDATE ps_product SET
wholesale_price = '4.55',
on_sale = '0',
price = '6.5000'
WHERE id_product = '18432'
23/01/2023 06:07:52 pm >> UPDATE ps_product_shop SET
wholesale_price = '4.55',
price = '6.5000',
id_tax_rules_group = '4',
id_category_default = '26',
id_argoment_default = '12',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '18432'
23/01/2023 06:07:52 pm >> DELETE FROM ps_specific_price WHERE id_product = '18432'
23/01/2023 06:08:36 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788867571079' AND id_product != '18268' AND ean13 != ''
23/01/2023 06:08:36 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '2/3',
ean13 = '9788867571079',
date_upd = NOW()
WHERE id_product = '18268'
23/01/2023 06:08:36 pm >> UPDATE ps_product_lang SET
name = 'RELIGIONI - FABRIS/MANTOVANI',
description = ''
WHERE id_product = '18268'
23/01/2023 06:08:36 pm >> UPDATE ps_product SET
wholesale_price = '3.15',
on_sale = '0',
price = '4.5000'
WHERE id_product = '18268'
23/01/2023 06:08:36 pm >> UPDATE ps_product_shop SET
wholesale_price = '3.15',
price = '4.5000',
id_tax_rules_group = '4',
id_category_default = '51',
id_argoment_default = '25',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '18268'
23/01/2023 06:08:36 pm >> DELETE FROM ps_specific_price WHERE id_product = '18268'
23/01/2023 06:08:50 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788861248052' AND id_product != '15982' AND ean13 != ''
23/01/2023 06:08:50 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '2/3',
ean13 = '9788861248052',
date_upd = NOW()
WHERE id_product = '15982'
23/01/2023 06:08:50 pm >> UPDATE ps_product_lang SET
name = 'ANTICO TESTAMENTO - 1° ANNO',
description = ''
WHERE id_product = '15982'
23/01/2023 06:08:50 pm >> UPDATE ps_product SET
wholesale_price = '4.55',
on_sale = '0',
price = '6.5000'
WHERE id_product = '15982'
23/01/2023 06:08:50 pm >> UPDATE ps_product_shop SET
wholesale_price = '4.55',
price = '6.5000',
id_tax_rules_group = '4',
id_category_default = '26',
id_argoment_default = '12',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '15982'
23/01/2023 06:08:50 pm >> DELETE FROM ps_specific_price WHERE id_product = '15982'
23/01/2023 06:09:08 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788867571352' AND id_product != '15386' AND ean13 != ''
23/01/2023 06:09:08 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '2/3',
ean13 = '9788867571352',
date_upd = NOW()
WHERE id_product = '15386'
23/01/2023 06:09:08 pm >> UPDATE ps_product_lang SET
name = 'MESSA - LE PAROLE DI PAPA FRANCESCO',
description = ''
WHERE id_product = '15386'
23/01/2023 06:09:08 pm >> UPDATE ps_product SET
wholesale_price = '3.43',
on_sale = '0',
price = '4.9000'
WHERE id_product = '15386'
23/01/2023 06:09:08 pm >> UPDATE ps_product_shop SET
wholesale_price = '3.43',
price = '4.9000',
id_tax_rules_group = '4',
id_category_default = '51',
id_argoment_default = '12',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '15386'
23/01/2023 06:09:08 pm >> DELETE FROM ps_specific_price WHERE id_product = '15386'
23/01/2023 06:09:26 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788867571451' AND id_product != '16011' AND ean13 != ''
23/01/2023 06:09:26 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '2/3',
ean13 = '9788867571451',
date_upd = NOW()
WHERE id_product = '16011'
23/01/2023 06:09:26 pm >> UPDATE ps_product_lang SET
name = 'SACRAMENTI',
description = ''
WHERE id_product = '16011'
23/01/2023 06:09:26 pm >> UPDATE ps_product SET
wholesale_price = '3.43',
on_sale = '0',
price = '4.9000'
WHERE id_product = '16011'
23/01/2023 06:09:26 pm >> UPDATE ps_product_shop SET
wholesale_price = '3.43',
price = '4.9000',
id_tax_rules_group = '4',
id_category_default = '51',
id_argoment_default = '108',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '16011'
23/01/2023 06:09:26 pm >> DELETE FROM ps_specific_price WHERE id_product = '16011'
23/01/2023 06:09:47 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788867570140' AND id_product != '2635' AND ean13 != ''
23/01/2023 06:09:47 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '2/3',
ean13 = '9788867570140',
date_upd = NOW()
WHERE id_product = '2635'
23/01/2023 06:09:47 pm >> UPDATE ps_product_lang SET
name = 'CONFESSIONE E IL TESORO DEL PERDONO - FABRIS/MANTOVANI',
description = ''
WHERE id_product = '2635'
23/01/2023 06:09:47 pm >> UPDATE ps_product SET
wholesale_price = '3.15',
on_sale = '0',
price = '4.5000'
WHERE id_product = '2635'
23/01/2023 06:09:47 pm >> UPDATE ps_product_shop SET
wholesale_price = '3.15',
price = '4.5000',
id_tax_rules_group = '4',
id_category_default = '51',
id_argoment_default = '108',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '2635'
23/01/2023 06:09:47 pm >> DELETE FROM ps_specific_price WHERE id_product = '2635'
23/01/2023 06:10:20 pm >> SELECT document_num FROM ps_document
WHERE document_num = '230' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-23')
23/01/2023 06:10:20 pm >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'230' ,
'2023-01-23' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'8.55' ,
'8.55' ,
NOW() ,
NOW() )
23/01/2023 06:10:20 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 = '80474'
23/01/2023 06:10:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '80474'
23/01/2023 06:10:20 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
( '80474' , '20088' , 'VIVIAMO LA SPERANZA - CALENDARIO 2023' , '1' , '-1' , '4' ,
'9.00' , '9' , '0' , '5' , '8.55' )
23/01/2023 06:12:25 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801052084' AND id_product != '4537' AND ean13 != ''
23/01/2023 06:12:25 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '2/3',
ean13 = '9788801052084',
date_upd = NOW()
WHERE id_product = '4537'
23/01/2023 06:12:25 pm >> UPDATE ps_product_lang SET
name = 'GIOCA E COLORA - VENITE II',
description = ''
WHERE id_product = '4537'
23/01/2023 06:12:25 pm >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '4.0000'
WHERE id_product = '4537'
23/01/2023 06:12:25 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '4.0000',
id_tax_rules_group = '4',
id_category_default = '19',
id_argoment_default = '56',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '4537'
23/01/2023 06:12:25 pm >> DELETE FROM ps_specific_price WHERE id_product = '4537'
23/01/2023 06:12:39 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801052077' AND id_product != '4536' AND ean13 != ''
23/01/2023 06:12:39 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '2/3',
ean13 = '9788801052077',
date_upd = NOW()
WHERE id_product = '4536'
23/01/2023 06:12:39 pm >> UPDATE ps_product_lang SET
name = 'GIOCA E COLORA - VENITE I',
description = ''
WHERE id_product = '4536'
23/01/2023 06:12:39 pm >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '4.0000'
WHERE id_product = '4536'
23/01/2023 06:12:39 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '4.0000',
id_tax_rules_group = '4',
id_category_default = '19',
id_argoment_default = '56',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '4536'
23/01/2023 06:12:39 pm >> DELETE FROM ps_specific_price WHERE id_product = '4536'
23/01/2023 06:12:53 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801048810' AND id_product != '4534' AND ean13 != ''
23/01/2023 06:12:53 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '2/3',
ean13 = '9788801048810',
date_upd = NOW()
WHERE id_product = '4534'
23/01/2023 06:12:53 pm >> UPDATE ps_product_lang SET
name = 'GIOCA E COLORA - IO SONO I',
description = ''
WHERE id_product = '4534'
23/01/2023 06:12:53 pm >> UPDATE ps_product SET
wholesale_price = '2.60',
on_sale = '0',
price = '4.0000'
WHERE id_product = '4534'
23/01/2023 06:12:53 pm >> UPDATE ps_product_shop SET
wholesale_price = '2.60',
price = '4.0000',
id_tax_rules_group = '4',
id_category_default = '19',
id_argoment_default = '56',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '4534'
23/01/2023 06:12:53 pm >> DELETE FROM ps_specific_price WHERE id_product = '4534'
23/01/2023 06:13:10 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801063998' AND id_product != '13782' AND ean13 != ''
23/01/2023 06:13:10 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '2/3',
ean13 = '9788801063998',
date_upd = NOW()
WHERE id_product = '13782'
23/01/2023 06:13:10 pm >> UPDATE ps_product_lang SET
name = 'TI RACCONTO LA VITA DI GESU\' - A. MAINARDI',
description = ''
WHERE id_product = '13782'
23/01/2023 06:13:10 pm >> UPDATE ps_product SET
wholesale_price = '3.19',
on_sale = '0',
price = '4.9000'
WHERE id_product = '13782'
23/01/2023 06:13:10 pm >> UPDATE ps_product_shop SET
wholesale_price = '3.19',
price = '4.9000',
id_tax_rules_group = '4',
id_category_default = '19',
id_argoment_default = '12',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '13782'
23/01/2023 06:13:10 pm >> DELETE FROM ps_specific_price WHERE id_product = '13782'
23/01/2023 06:15:18 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788861247925' AND id_product != '16077' AND ean13 != ''
23/01/2023 06:15:18 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '2/1',
ean13 = '9788861247925',
date_upd = NOW()
WHERE id_product = '16077'
23/01/2023 06:15:18 pm >> UPDATE ps_product_lang SET
name = 'CELEBRAZIONI PER IL CATECHISMO',
description = ''
WHERE id_product = '16077'
23/01/2023 06:15:19 pm >> UPDATE ps_product SET
wholesale_price = '4.83',
on_sale = '0',
price = '6.9000'
WHERE id_product = '16077'
23/01/2023 06:15:19 pm >> UPDATE ps_product_shop SET
wholesale_price = '4.83',
price = '6.9000',
id_tax_rules_group = '4',
id_category_default = '26',
id_argoment_default = '22',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '16077'
23/01/2023 06:15:19 pm >> DELETE FROM ps_specific_price WHERE id_product = '16077'
23/01/2023 06:15:30 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788861249813' AND id_product != '19936' AND ean13 != ''
23/01/2023 06:15:30 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '2/1',
ean13 = '9788861249813',
date_upd = NOW()
WHERE id_product = '19936'
23/01/2023 06:15:30 pm >> UPDATE ps_product_lang SET
name = 'SANTI PER IL CATECHISMO',
description = ''
WHERE id_product = '19936'
23/01/2023 06:15:30 pm >> UPDATE ps_product SET
wholesale_price = '6.93',
on_sale = '0',
price = '9.9000'
WHERE id_product = '19936'
23/01/2023 06:15:30 pm >> UPDATE ps_product_shop SET
wholesale_price = '6.93',
price = '9.9000',
id_tax_rules_group = '4',
id_category_default = '26',
id_argoment_default = '10',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '19936'
23/01/2023 06:15:30 pm >> DELETE FROM ps_specific_price WHERE id_product = '19936'
23/01/2023 06:15:44 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788861245907' AND id_product != '8381' AND ean13 != ''
23/01/2023 06:15:44 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '2/1',
ean13 = '9788861245907',
date_upd = NOW()
WHERE id_product = '8381'
23/01/2023 06:15:44 pm >> UPDATE ps_product_lang SET
name = 'PREGHIERE PER IL CATECHISMO',
description = ''
WHERE id_product = '8381'
23/01/2023 06:15:44 pm >> UPDATE ps_product SET
wholesale_price = '2.73',
on_sale = '0',
price = '3.9000'
WHERE id_product = '8381'
23/01/2023 06:15:44 pm >> UPDATE ps_product_shop SET
wholesale_price = '2.73',
price = '3.9000',
id_tax_rules_group = '4',
id_category_default = '26',
id_argoment_default = '25',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '8381'
23/01/2023 06:15:44 pm >> DELETE FROM ps_specific_price WHERE id_product = '8381'
23/01/2023 06:16:01 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788861247918' AND id_product != '18110' AND ean13 != ''
23/01/2023 06:16:01 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '2/1',
ean13 = '9788861247918',
date_upd = NOW()
WHERE id_product = '18110'
23/01/2023 06:16:01 pm >> UPDATE ps_product_lang SET
name = 'ATLANTE STORICO GEOGRAFICO DELLA BIBBIA',
description = ''
WHERE id_product = '18110'
23/01/2023 06:16:01 pm >> UPDATE ps_product SET
wholesale_price = '6.93',
on_sale = '0',
price = '9.9000'
WHERE id_product = '18110'
23/01/2023 06:16:01 pm >> UPDATE ps_product_shop SET
wholesale_price = '6.93',
price = '9.9000',
id_tax_rules_group = '4',
id_category_default = '26',
id_argoment_default = '25',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '18110'
23/01/2023 06:16:01 pm >> DELETE FROM ps_specific_price WHERE id_product = '18110'
23/01/2023 06:16:15 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788861248410' AND id_product != '17188' AND ean13 != ''
23/01/2023 06:16:15 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '2/1',
ean13 = '9788861248410',
date_upd = NOW()
WHERE id_product = '17188'
23/01/2023 06:16:15 pm >> UPDATE ps_product_lang SET
name = 'INTRODUZIONE ALLA BIBBIA PER IL CATCHISMO',
description = ''
WHERE id_product = '17188'
23/01/2023 06:16:15 pm >> UPDATE ps_product SET
wholesale_price = '6.23',
on_sale = '0',
price = '8.9000'
WHERE id_product = '17188'
23/01/2023 06:16:15 pm >> UPDATE ps_product_shop SET
wholesale_price = '6.23',
price = '8.9000',
id_tax_rules_group = '4',
id_category_default = '26',
id_argoment_default = '25',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '17188'
23/01/2023 06:16:15 pm >> DELETE FROM ps_specific_price WHERE id_product = '17188'
23/01/2023 06:16:30 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788861245426' AND id_product != '1179' AND ean13 != ''
23/01/2023 06:16:30 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '2/1',
ean13 = '9788861245426',
date_upd = NOW()
WHERE id_product = '1179'
23/01/2023 06:16:30 pm >> UPDATE ps_product_lang SET
name = 'BIBBIA PER IL CATECHISMO',
description = ''
WHERE id_product = '1179'
23/01/2023 06:16:30 pm >> UPDATE ps_product SET
wholesale_price = '2.73',
on_sale = '0',
price = '3.9000'
WHERE id_product = '1179'
23/01/2023 06:16:30 pm >> UPDATE ps_product_shop SET
wholesale_price = '2.73',
price = '3.9000',
id_tax_rules_group = '4',
id_category_default = '26',
id_argoment_default = '25',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '1179'
23/01/2023 06:16:30 pm >> DELETE FROM ps_specific_price WHERE id_product = '1179'
23/01/2023 06:16:44 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788861247833' AND id_product != '15815' AND ean13 != ''
23/01/2023 06:16:44 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '2/1',
ean13 = '9788861247833',
date_upd = NOW()
WHERE id_product = '15815'
23/01/2023 06:16:44 pm >> UPDATE ps_product_lang SET
name = 'GLOSSARIO PER IL CATECHISMO',
description = ''
WHERE id_product = '15815'
23/01/2023 06:16:44 pm >> UPDATE ps_product SET
wholesale_price = '4.83',
on_sale = '0',
price = '6.9000'
WHERE id_product = '15815'
23/01/2023 06:16:44 pm >> UPDATE ps_product_shop SET
wholesale_price = '4.83',
price = '6.9000',
id_tax_rules_group = '4',
id_category_default = '26',
id_argoment_default = '22',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '15815'
23/01/2023 06:16:44 pm >> DELETE FROM ps_specific_price WHERE id_product = '15815'
23/01/2023 06:16:59 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788861246300' AND id_product != '16326' AND ean13 != ''
23/01/2023 06:16:59 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '2/1',
ean13 = '9788861246300',
date_upd = NOW()
WHERE id_product = '16326'
23/01/2023 06:16:59 pm >> UPDATE ps_product_lang SET
name = 'ESSENZIALE PER IL CATECHISMO',
description = ''
WHERE id_product = '16326'
23/01/2023 06:16:59 pm >> UPDATE ps_product SET
wholesale_price = '2.73',
on_sale = '0',
price = '3.9000'
WHERE id_product = '16326'
23/01/2023 06:16:59 pm >> UPDATE ps_product_shop SET
wholesale_price = '2.73',
price = '3.9000',
id_tax_rules_group = '4',
id_category_default = '26',
id_argoment_default = '22',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '16326'
23/01/2023 06:16:59 pm >> DELETE FROM ps_specific_price WHERE id_product = '16326'
23/01/2023 06:21:20 pm >> SELECT document_num FROM ps_document
WHERE document_num = '231' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-23')
23/01/2023 06:21:20 pm >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'231' ,
'2023-01-23' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'12.35' ,
'12.35' ,
NOW() ,
NOW() )
23/01/2023 06:21:20 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 = '80475'
23/01/2023 06:21:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '80475'
23/01/2023 06:21:20 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
( '80475' , '20625' , 'DIO E SEMPRE NUOVO - RATZINGER' , '1' , '-1' , '4' ,
'13.00' , '13' , '0' , '5' , '12.35' )
23/01/2023 07:02:56 pm >> SELECT document_num FROM ps_document
WHERE document_num = '232' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-23')
23/01/2023 07:02:56 pm >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'232' ,
'2023-01-23' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'0.70' ,
'0.70' ,
NOW() ,
NOW() )
23/01/2023 07:02:56 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '80476'
23/01/2023 07:02:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '80476'
23/01/2023 07:02:56 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '80476' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '1' , '-1' , '4' ,
'0.70' , '0.7' , '0' , '0' , '0.70' )
23/01/2023 07:03:29 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801037333' AND id_product != '10742' AND ean13 != ''
23/01/2023 07:03:29 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '2/2',
ean13 = '9788801037333',
date_upd = NOW()
WHERE id_product = '10742'
23/01/2023 07:03:29 pm >> UPDATE ps_product_lang SET
name = 'TROPPO FORTE - 3/ IL VOLO + CD',
description = ''
WHERE id_product = '10742'
23/01/2023 07:03:29 pm >> UPDATE ps_product SET
wholesale_price = '4.88',
on_sale = '0',
price = '7.5000'
WHERE id_product = '10742'
23/01/2023 07:03:29 pm >> UPDATE ps_product_shop SET
wholesale_price = '4.88',
price = '7.5000',
id_tax_rules_group = '4',
id_category_default = '19',
id_argoment_default = '108',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '10742'
23/01/2023 07:03:29 pm >> DELETE FROM ps_specific_price WHERE id_product = '10742'
23/01/2023 07:03:44 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801036824' AND id_product != '10740' AND ean13 != ''
23/01/2023 07:03:44 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '2/2',
ean13 = '9788801036824',
date_upd = NOW()
WHERE id_product = '10740'
23/01/2023 07:03:44 pm >> UPDATE ps_product_lang SET
name = 'TROPPO FORTE - 1/ IL DECOLLO',
description = ''
WHERE id_product = '10740'
23/01/2023 07:03:44 pm >> UPDATE ps_product SET
wholesale_price = '3.25',
on_sale = '0',
price = '5.0000'
WHERE id_product = '10740'
23/01/2023 07:03:44 pm >> UPDATE ps_product_shop SET
wholesale_price = '3.25',
price = '5.0000',
id_tax_rules_group = '4',
id_category_default = '19',
id_argoment_default = '108',
id_internal_category = '',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '10740'
23/01/2023 07:03:44 pm >> DELETE FROM ps_specific_price WHERE id_product = '10740'
23/01/2023 07:03:59 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801036824' AND id_product != '10740' AND ean13 != ''
23/01/2023 07:03:59 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '2/3',
ean13 = '9788801036824',
date_upd = NOW()
WHERE id_product = '10740'
23/01/2023 07:03:59 pm >> UPDATE ps_product_lang SET
name = 'TROPPO FORTE - 1/ IL DECOLLO',
description = ''
WHERE id_product = '10740'
23/01/2023 07:03:59 pm >> UPDATE ps_product SET
wholesale_price = '3.25',
on_sale = '0',
price = '5.0000'
WHERE id_product = '10740'
23/01/2023 07:03:59 pm >> UPDATE ps_product_shop SET
wholesale_price = '3.25',
price = '5.0000',
id_tax_rules_group = '4',
id_category_default = '19',
id_argoment_default = '108',
id_internal_category = '',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '10740'
23/01/2023 07:03:59 pm >> DELETE FROM ps_specific_price WHERE id_product = '10740'
23/01/2023 07:04:05 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801037326' AND id_product != '10741' AND ean13 != ''
23/01/2023 07:04:06 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '2/3',
ean13 = '9788801037326',
date_upd = NOW()
WHERE id_product = '10741'
23/01/2023 07:04:06 pm >> UPDATE ps_product_lang SET
name = 'TROPPO FORTE - 2/ LA DIREZIONE',
description = ''
WHERE id_product = '10741'
23/01/2023 07:04:06 pm >> UPDATE ps_product SET
wholesale_price = '3.25',
on_sale = '0',
price = '5.0000'
WHERE id_product = '10741'
23/01/2023 07:04:06 pm >> UPDATE ps_product_shop SET
wholesale_price = '3.25',
price = '5.0000',
id_tax_rules_group = '4',
id_category_default = '19',
id_argoment_default = '108',
id_internal_category = '',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '10741'
23/01/2023 07:04:06 pm >> DELETE FROM ps_specific_price WHERE id_product = '10741'
23/01/2023 07:04:19 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801037333' AND id_product != '10742' AND ean13 != ''
23/01/2023 07:04:19 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '2/3',
ean13 = '9788801037333',
date_upd = NOW()
WHERE id_product = '10742'
23/01/2023 07:04:19 pm >> UPDATE ps_product_lang SET
name = 'TROPPO FORTE - 3/ IL VOLO + CD',
description = ''
WHERE id_product = '10742'
23/01/2023 07:04:19 pm >> UPDATE ps_product SET
wholesale_price = '4.88',
on_sale = '0',
price = '7.5000'
WHERE id_product = '10742'
23/01/2023 07:04:19 pm >> UPDATE ps_product_shop SET
wholesale_price = '4.88',
price = '7.5000',
id_tax_rules_group = '4',
id_category_default = '19',
id_argoment_default = '108',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '10742'
23/01/2023 07:04:19 pm >> DELETE FROM ps_specific_price WHERE id_product = '10742'
23/01/2023 07:05:44 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801056532' AND id_product != '1970' AND ean13 != ''
23/01/2023 07:05:44 pm >> UPDATE ps_product SET
id_supplier = '',
reference = '2/3',
ean13 = '9788801056532',
date_upd = NOW()
WHERE id_product = '1970'
23/01/2023 07:05:44 pm >> UPDATE ps_product_lang SET
name = 'CHE COSA SÌ... CHE COSA NO - L. FERRARESSO',
description = ''
WHERE id_product = '1970'
23/01/2023 07:05:44 pm >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '10.0000'
WHERE id_product = '1970'
23/01/2023 07:05:44 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '10.0000',
id_tax_rules_group = '4',
id_category_default = '19',
id_argoment_default = '22',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '1970'
23/01/2023 07:05:44 pm >> DELETE FROM ps_specific_price WHERE id_product = '1970'
23/01/2023 07:07:50 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801036824' AND id_product != '10740' AND ean13 != ''
23/01/2023 07:07:50 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '2/4',
ean13 = '9788801036824',
date_upd = NOW()
WHERE id_product = '10740'
23/01/2023 07:07:50 pm >> UPDATE ps_product_lang SET
name = 'TROPPO FORTE - 1/ IL DECOLLO',
description = ''
WHERE id_product = '10740'
23/01/2023 07:07:50 pm >> UPDATE ps_product SET
wholesale_price = '3.25',
on_sale = '0',
price = '5.0000'
WHERE id_product = '10740'
23/01/2023 07:07:50 pm >> UPDATE ps_product_shop SET
wholesale_price = '3.25',
price = '5.0000',
id_tax_rules_group = '4',
id_category_default = '19',
id_argoment_default = '108',
id_internal_category = '',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '10740'
23/01/2023 07:07:50 pm >> DELETE FROM ps_specific_price WHERE id_product = '10740'
23/01/2023 07:07:59 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801037326' AND id_product != '10741' AND ean13 != ''
23/01/2023 07:07:59 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '2/4',
ean13 = '9788801037326',
date_upd = NOW()
WHERE id_product = '10741'
23/01/2023 07:07:59 pm >> UPDATE ps_product_lang SET
name = 'TROPPO FORTE - 2/ LA DIREZIONE',
description = ''
WHERE id_product = '10741'
23/01/2023 07:07:59 pm >> UPDATE ps_product SET
wholesale_price = '3.25',
on_sale = '0',
price = '5.0000'
WHERE id_product = '10741'
23/01/2023 07:07:59 pm >> UPDATE ps_product_shop SET
wholesale_price = '3.25',
price = '5.0000',
id_tax_rules_group = '4',
id_category_default = '19',
id_argoment_default = '108',
id_internal_category = '',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '10741'
23/01/2023 07:07:59 pm >> DELETE FROM ps_specific_price WHERE id_product = '10741'
23/01/2023 07:08:07 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801037333' AND id_product != '10742' AND ean13 != ''
23/01/2023 07:08:07 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '2/4',
ean13 = '9788801037333',
date_upd = NOW()
WHERE id_product = '10742'
23/01/2023 07:08:07 pm >> UPDATE ps_product_lang SET
name = 'TROPPO FORTE - 3/ IL VOLO + CD',
description = ''
WHERE id_product = '10742'
23/01/2023 07:08:07 pm >> UPDATE ps_product SET
wholesale_price = '4.88',
on_sale = '0',
price = '7.5000'
WHERE id_product = '10742'
23/01/2023 07:08:07 pm >> UPDATE ps_product_shop SET
wholesale_price = '4.88',
price = '7.5000',
id_tax_rules_group = '4',
id_category_default = '19',
id_argoment_default = '108',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '10742'
23/01/2023 07:08:07 pm >> DELETE FROM ps_specific_price WHERE id_product = '10742'
23/01/2023 07:11:13 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788861248090' AND id_product != '17246' AND ean13 != ''
23/01/2023 07:11:13 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '2/3',
ean13 = '9788861248090',
date_upd = NOW()
WHERE id_product = '17246'
23/01/2023 07:11:13 pm >> UPDATE ps_product_lang SET
name = 'CONOSCI LO SPIRITO SANTO',
description = ''
WHERE id_product = '17246'
23/01/2023 07:11:13 pm >> UPDATE ps_product SET
wholesale_price = '4.83',
on_sale = '0',
price = '6.9000'
WHERE id_product = '17246'
23/01/2023 07:11:13 pm >> UPDATE ps_product_shop SET
wholesale_price = '4.83',
price = '6.9000',
id_tax_rules_group = '4',
id_category_default = '26',
id_argoment_default = '108',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '17246'
23/01/2023 07:11:13 pm >> DELETE FROM ps_specific_price WHERE id_product = '17246'
23/01/2023 07:12:01 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788861248670' AND id_product != '17245' AND ean13 != ''
23/01/2023 07:12:01 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '2/3',
ean13 = '9788861248670',
date_upd = NOW()
WHERE id_product = '17245'
23/01/2023 07:12:01 pm >> UPDATE ps_product_lang SET
name = 'DIARIO DELLA MIA PRIMA COMUNIONE',
description = ''
WHERE id_product = '17245'
23/01/2023 07:12:01 pm >> UPDATE ps_product SET
wholesale_price = '4.13',
on_sale = '0',
price = '5.9000'
WHERE id_product = '17245'
23/01/2023 07:12:01 pm >> UPDATE ps_product_shop SET
wholesale_price = '4.13',
price = '5.9000',
id_tax_rules_group = '4',
id_category_default = '26',
id_argoment_default = '108',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '17245'
23/01/2023 07:12:01 pm >> DELETE FROM ps_specific_price WHERE id_product = '17245'
23/01/2023 07:12:16 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788861248687' AND id_product != '17243' AND ean13 != ''
23/01/2023 07:12:16 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '2/3',
ean13 = '9788861248687',
date_upd = NOW()
WHERE id_product = '17243'
23/01/2023 07:12:16 pm >> UPDATE ps_product_lang SET
name = 'DIARIO DELLA MIA CRESIMA',
description = ''
WHERE id_product = '17243'
23/01/2023 07:12:16 pm >> UPDATE ps_product SET
wholesale_price = '4.13',
on_sale = '0',
price = '5.9000'
WHERE id_product = '17243'
23/01/2023 07:12:16 pm >> UPDATE ps_product_shop SET
wholesale_price = '4.13',
price = '5.9000',
id_tax_rules_group = '4',
id_category_default = '26',
id_argoment_default = '108',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '17243'
23/01/2023 07:12:16 pm >> DELETE FROM ps_specific_price WHERE id_product = '17243'
23/01/2023 07:12:29 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788861248632' AND id_product != '17244' AND ean13 != ''
23/01/2023 07:12:29 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '2/3',
ean13 = '9788861248632',
date_upd = NOW()
WHERE id_product = '17244'
23/01/2023 07:12:29 pm >> UPDATE ps_product_lang SET
name = 'DIARIO DELLA MIA PRIMA CONFESSIONE',
description = ''
WHERE id_product = '17244'
23/01/2023 07:12:29 pm >> UPDATE ps_product SET
wholesale_price = '4.13',
on_sale = '0',
price = '5.9000'
WHERE id_product = '17244'
23/01/2023 07:12:29 pm >> UPDATE ps_product_shop SET
wholesale_price = '4.13',
price = '5.9000',
id_tax_rules_group = '4',
id_category_default = '26',
id_argoment_default = '108',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '17244'
23/01/2023 07:12:29 pm >> DELETE FROM ps_specific_price WHERE id_product = '17244'
23/01/2023 07:15:04 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788810703342' AND id_product != '13914' AND ean13 != ''
23/01/2023 07:15:04 pm >> UPDATE ps_product SET
id_supplier = '109',
reference = '2/3',
ean13 = '9788810703342',
date_upd = NOW()
WHERE id_product = '13914'
23/01/2023 07:15:04 pm >> UPDATE ps_product_lang SET
name = 'BAMBINI A MESSA ANNO C - AAVV',
description = ''
WHERE id_product = '13914'
23/01/2023 07:15:04 pm >> UPDATE ps_product SET
wholesale_price = '5.46',
on_sale = '0',
price = '8.0000'
WHERE id_product = '13914'
23/01/2023 07:15:04 pm >> UPDATE ps_product_shop SET
wholesale_price = '5.46',
price = '8.0000',
id_tax_rules_group = '4',
id_category_default = '9',
id_argoment_default = '89',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '13914'
23/01/2023 07:15:04 pm >> DELETE FROM ps_specific_price WHERE id_product = '13914'
23/01/2023 07:15:28 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831165587' AND id_product != '6642' AND ean13 != ''
23/01/2023 07:15:28 pm >> UPDATE ps_product SET
id_supplier = '109',
reference = '2/3',
ean13 = '9788831165587',
date_upd = NOW()
WHERE id_product = '6642'
23/01/2023 07:15:28 pm >> UPDATE ps_product_lang SET
name = 'MIA PRIMA COMUNIONE - M. IASEVOLI',
description = ''
WHERE id_product = '6642'
23/01/2023 07:15:28 pm >> UPDATE ps_product SET
wholesale_price = '1.95',
on_sale = '0',
price = '3.0000'
WHERE id_product = '6642'
23/01/2023 07:15:28 pm >> UPDATE ps_product_shop SET
wholesale_price = '1.95',
price = '3.0000',
id_tax_rules_group = '4',
id_category_default = '13',
id_argoment_default = '108',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '6642'
23/01/2023 07:15:28 pm >> DELETE FROM ps_specific_price WHERE id_product = '6642'
23/01/2023 07:15:39 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831165464' AND id_product != '3720' AND ean13 != ''
23/01/2023 07:15:39 pm >> UPDATE ps_product SET
id_supplier = '109',
reference = '2/3',
ean13 = '9788831165464',
date_upd = NOW()
WHERE id_product = '3720'
23/01/2023 07:15:39 pm >> UPDATE ps_product_lang SET
name = 'DOVE SEI GESÙ? - M. GENISIO',
description = ''
WHERE id_product = '3720'
23/01/2023 07:15:39 pm >> UPDATE ps_product SET
wholesale_price = '2.28',
on_sale = '0',
price = '3.5000'
WHERE id_product = '3720'
23/01/2023 07:15:39 pm >> UPDATE ps_product_shop SET
wholesale_price = '2.28',
price = '3.5000',
id_tax_rules_group = '4',
id_category_default = '13',
id_argoment_default = '63',
id_internal_category = '',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '3720'
23/01/2023 07:15:39 pm >> DELETE FROM ps_specific_price WHERE id_product = '3720'
23/01/2023 07:21:42 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801053968' AND id_product != '2443' AND ean13 != ''
23/01/2023 07:21:42 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '2/3',
ean13 = '9788801053968',
date_upd = NOW()
WHERE id_product = '2443'
23/01/2023 07:21:42 pm >> UPDATE ps_product_lang SET
name = 'COLORO LA MESSA',
description = ''
WHERE id_product = '2443'
23/01/2023 07:21:42 pm >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '4.5000'
WHERE id_product = '2443'
23/01/2023 07:21:42 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '4.5000',
id_tax_rules_group = '4',
id_category_default = '19',
id_argoment_default = '25',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '2443'
23/01/2023 07:21:42 pm >> DELETE FROM ps_specific_price WHERE id_product = '2443'
23/01/2023 07:21:56 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801049992' AND id_product != '401' AND ean13 != ''
23/01/2023 07:21:56 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '2/3',
ean13 = '9788801049992',
date_upd = NOW()
WHERE id_product = '401'
23/01/2023 07:21:56 pm >> UPDATE ps_product_lang SET
name = 'ALLA SCOPERTA DELLA MESSA',
description = ''
WHERE id_product = '401'
23/01/2023 07:21:56 pm >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '3.0000'
WHERE id_product = '401'
23/01/2023 07:21:56 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '3.0000',
id_tax_rules_group = '4',
id_category_default = '19',
id_argoment_default = '89',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '401'
23/01/2023 07:21:56 pm >> DELETE FROM ps_specific_price WHERE id_product = '401'
23/01/2023 07:22:09 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801054804' AND id_product != '11182' AND ean13 != ''
23/01/2023 07:22:09 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '2/3',
ean13 = '9788801054804',
date_upd = NOW()
WHERE id_product = '11182'
23/01/2023 07:22:09 pm >> UPDATE ps_product_lang SET
name = 'VENITE ALLA FESTA',
description = ''
WHERE id_product = '11182'
23/01/2023 07:22:09 pm >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '2.5000'
WHERE id_product = '11182'
23/01/2023 07:22:09 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '2.5000',
id_tax_rules_group = '4',
id_category_default = '19',
id_argoment_default = '22',
id_internal_category = '',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '11182'
23/01/2023 07:22:09 pm >> DELETE FROM ps_specific_price WHERE id_product = '11182'
23/01/2023 07:22:34 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788852606489' AND id_product != '17481' AND ean13 != ''
23/01/2023 07:22:34 pm >> UPDATE ps_product SET
id_supplier = '107',
reference = '2/1',
ean13 = '9788852606489',
date_upd = NOW()
WHERE id_product = '17481'
23/01/2023 07:22:34 pm >> UPDATE ps_product_lang SET
name = 'DOMANDE GRANDI DEI BAMBINI N.E. - 2',
description = ''
WHERE id_product = '17481'
23/01/2023 07:22:34 pm >> UPDATE ps_product SET
wholesale_price = '6.50',
on_sale = '0',
price = '10.0000'
WHERE id_product = '17481'
23/01/2023 07:22:34 pm >> UPDATE ps_product_shop SET
wholesale_price = '6.50',
price = '10.0000',
id_tax_rules_group = '4',
id_category_default = '285',
id_argoment_default = '108',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '17481'
23/01/2023 07:22:34 pm >> DELETE FROM ps_specific_price WHERE id_product = '17481'
23/01/2023 07:22:45 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788852606472' AND id_product != '17482' AND ean13 != ''
23/01/2023 07:22:45 pm >> UPDATE ps_product SET
id_supplier = '107',
reference = '2/1',
ean13 = '9788852606472',
date_upd = NOW()
WHERE id_product = '17482'
23/01/2023 07:22:45 pm >> UPDATE ps_product_lang SET
name = 'DOMANDE GRANDI DEI BAMBINI N.E. - 1',
description = ''
WHERE id_product = '17482'
23/01/2023 07:22:45 pm >> UPDATE ps_product SET
wholesale_price = '6.50',
on_sale = '0',
price = '10.0000'
WHERE id_product = '17482'
23/01/2023 07:22:45 pm >> UPDATE ps_product_shop SET
wholesale_price = '6.50',
price = '10.0000',
id_tax_rules_group = '4',
id_category_default = '285',
id_argoment_default = '108',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '17482'
23/01/2023 07:22:45 pm >> DELETE FROM ps_specific_price WHERE id_product = '17482'
23/01/2023 07:23:02 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788852605314' AND id_product != '12852' AND ean13 != ''
23/01/2023 07:23:02 pm >> UPDATE ps_product SET
id_supplier = '107',
reference = '2/1',
ean13 = '9788852605314',
date_upd = NOW()
WHERE id_product = '12852'
23/01/2023 07:23:02 pm >> UPDATE ps_product_lang SET
name = 'DOMANDE GRANDI DEI BAMBINI - 3',
description = ''
WHERE id_product = '12852'
23/01/2023 07:23:03 pm >> UPDATE ps_product SET
wholesale_price = '6.50',
on_sale = '0',
price = '10.0000'
WHERE id_product = '12852'
23/01/2023 07:23:03 pm >> UPDATE ps_product_shop SET
wholesale_price = '6.50',
price = '10.0000',
id_tax_rules_group = '4',
id_category_default = '285',
id_argoment_default = '12',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '12852'
23/01/2023 07:23:03 pm >> DELETE FROM ps_specific_price WHERE id_product = '12852'
23/01/2023 07:23:20 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788852605307' AND id_product != '12851' AND ean13 != ''
23/01/2023 07:23:20 pm >> UPDATE ps_product SET
id_supplier = '107',
reference = '2/1',
ean13 = '9788852605307',
date_upd = NOW()
WHERE id_product = '12851'
23/01/2023 07:23:20 pm >> UPDATE ps_product_lang SET
name = 'DOMANDE GRANDI DEI BAMBINI - 2',
description = ''
WHERE id_product = '12851'
23/01/2023 07:23:20 pm >> UPDATE ps_product SET
wholesale_price = '6.50',
on_sale = '0',
price = '10.0000'
WHERE id_product = '12851'
23/01/2023 07:23:20 pm >> UPDATE ps_product_shop SET
wholesale_price = '6.50',
price = '10.0000',
id_tax_rules_group = '4',
id_category_default = '285',
id_argoment_default = '12',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '12851'
23/01/2023 07:23:20 pm >> DELETE FROM ps_specific_price WHERE id_product = '12851'
23/01/2023 07:23:28 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788852604997' AND id_product != '3618' AND ean13 != ''
23/01/2023 07:23:28 pm >> UPDATE ps_product SET
id_supplier = '107',
reference = '2/1',
ean13 = '9788852604997',
date_upd = NOW()
WHERE id_product = '3618'
23/01/2023 07:23:29 pm >> UPDATE ps_product_lang SET
name = 'DOMANDE GRANDI DEI BAMBINI - 1',
description = ''
WHERE id_product = '3618'
23/01/2023 07:23:29 pm >> UPDATE ps_product SET
wholesale_price = '6.50',
on_sale = '0',
price = '10.0000'
WHERE id_product = '3618'
23/01/2023 07:23:29 pm >> UPDATE ps_product_shop SET
wholesale_price = '6.50',
price = '10.0000',
id_tax_rules_group = '4',
id_category_default = '285',
id_argoment_default = '12',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '3618'
23/01/2023 07:23:29 pm >> DELETE FROM ps_specific_price WHERE id_product = '3618'
23/01/2023 07:23:48 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788852606298' AND id_product != '17201' AND ean13 != ''
23/01/2023 07:23:48 pm >> UPDATE ps_product SET
id_supplier = '107',
reference = '2/1',
ean13 = '9788852606298',
date_upd = NOW()
WHERE id_product = '17201'
23/01/2023 07:23:49 pm >> UPDATE ps_product_lang SET
name = 'DOMANDE GRANDI DEI BAMBINI - COFANETTO',
description = ''
WHERE id_product = '17201'
23/01/2023 07:23:49 pm >> UPDATE ps_product SET
wholesale_price = '16.19',
on_sale = '0',
price = '24.9000'
WHERE id_product = '17201'
23/01/2023 07:23:49 pm >> UPDATE ps_product_shop SET
wholesale_price = '16.19',
price = '24.9000',
id_tax_rules_group = '4',
id_category_default = '285',
id_argoment_default = '22',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '17201'
23/01/2023 07:23:49 pm >> DELETE FROM ps_specific_price WHERE id_product = '17201'
23/01/2023 07:24:49 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788862446211' AND id_product != '13827' AND ean13 != ''
23/01/2023 07:24:49 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '2/3',
ean13 = '9788862446211',
date_upd = NOW()
WHERE id_product = '13827'
23/01/2023 07:24:49 pm >> UPDATE ps_product_lang SET
name = 'GIOIA DI DIO - PRIMA CONFESSIONE',
description = ''
WHERE id_product = '13827'
23/01/2023 07:24:49 pm >> UPDATE ps_product SET
wholesale_price = '4.20',
on_sale = '0',
price = '6.0000'
WHERE id_product = '13827'
23/01/2023 07:24:49 pm >> UPDATE ps_product_shop SET
wholesale_price = '4.20',
price = '6.0000',
id_tax_rules_group = '4',
id_category_default = '267',
id_argoment_default = '108',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '13827'
23/01/2023 07:24:49 pm >> DELETE FROM ps_specific_price WHERE id_product = '13827'
23/01/2023 07:25:08 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788862446921' AND id_product != '14905' AND ean13 != ''
23/01/2023 07:25:08 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '2/3',
ean13 = '9788862446921',
date_upd = NOW()
WHERE id_product = '14905'
23/01/2023 07:25:08 pm >> UPDATE ps_product_lang SET
name = 'TI DONO IL PANE CHE NUTRE IL CUORE',
description = ''
WHERE id_product = '14905'
23/01/2023 07:25:08 pm >> UPDATE ps_product SET
wholesale_price = '4.90',
on_sale = '0',
price = '7.0000'
WHERE id_product = '14905'
23/01/2023 07:25:08 pm >> UPDATE ps_product_shop SET
wholesale_price = '4.90',
price = '7.0000',
id_tax_rules_group = '4',
id_category_default = '267',
id_argoment_default = '108',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '14905'
23/01/2023 07:25:08 pm >> DELETE FROM ps_specific_price WHERE id_product = '14905'
23/01/2023 07:25:23 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788862446914' AND id_product != '14904' AND ean13 != ''
23/01/2023 07:25:23 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '2/3',
ean13 = '9788862446914',
date_upd = NOW()
WHERE id_product = '14904'
23/01/2023 07:25:23 pm >> UPDATE ps_product_lang SET
name = 'TI DONO UN CUORE NUOVO',
description = ''
WHERE id_product = '14904'
23/01/2023 07:25:23 pm >> UPDATE ps_product SET
wholesale_price = '4.90',
on_sale = '0',
price = '7.0000'
WHERE id_product = '14904'
23/01/2023 07:25:23 pm >> UPDATE ps_product_shop SET
wholesale_price = '4.90',
price = '7.0000',
id_tax_rules_group = '4',
id_category_default = '267',
id_argoment_default = '108',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '14904'
23/01/2023 07:25:23 pm >> DELETE FROM ps_specific_price WHERE id_product = '14904'
23/01/2023 07:25:38 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801040043' AND id_product != '6540' AND ean13 != ''
23/01/2023 07:25:38 pm >> UPDATE ps_product SET
id_supplier = '',
reference = '2/3',
ean13 = '9788801040043',
date_upd = NOW()
WHERE id_product = '6540'
23/01/2023 07:25:38 pm >> UPDATE ps_product_lang SET
name = 'MESSA UNA FESTA',
description = ''
WHERE id_product = '6540'
23/01/2023 07:25:38 pm >> UPDATE ps_product SET
wholesale_price = '2.28',
on_sale = '0',
price = '3.5000'
WHERE id_product = '6540'
23/01/2023 07:25:38 pm >> UPDATE ps_product_shop SET
wholesale_price = '2.28',
price = '3.5000',
id_tax_rules_group = '4',
id_category_default = '19',
id_argoment_default = '22',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '6540'
23/01/2023 07:25:38 pm >> DELETE FROM ps_specific_price WHERE id_product = '6540'
23/01/2023 07:27:30 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801009736' AND id_product != '4524' AND ean13 != ''
23/01/2023 07:27:30 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '2/4',
ean13 = '9788801009736',
date_upd = NOW()
WHERE id_product = '4524'
23/01/2023 07:27:30 pm >> UPDATE ps_product_lang SET
name = 'GIGANTE INVISIBILE - P. PELLEGRINO',
description = ''
WHERE id_product = '4524'
23/01/2023 07:27:30 pm >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '3.6000'
WHERE id_product = '4524'
23/01/2023 07:27:30 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '3.6000',
id_tax_rules_group = '4',
id_category_default = '19',
id_argoment_default = '108',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '4524'
23/01/2023 07:27:30 pm >> DELETE FROM ps_specific_price WHERE id_product = '4524'
23/01/2023 07:27:42 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801057911' AND id_product != '1976' AND ean13 != ''
23/01/2023 07:27:42 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '2/4',
ean13 = '9788801057911',
date_upd = NOW()
WHERE id_product = '1976'
23/01/2023 07:27:42 pm >> UPDATE ps_product_lang SET
name = 'CHE SVOLTA - DON A. CATTANEO - FRA E. COVIELLO',
description = ''
WHERE id_product = '1976'
23/01/2023 07:27:42 pm >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '4.9000'
WHERE id_product = '1976'
23/01/2023 07:27:42 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '4.9000',
id_tax_rules_group = '4',
id_category_default = '19',
id_argoment_default = '40',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '1976'
23/01/2023 07:27:42 pm >> DELETE FROM ps_specific_price WHERE id_product = '1976'
23/01/2023 07:27:55 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788865126844' AND id_product != '16173' AND ean13 != ''
23/01/2023 07:27:55 pm >> UPDATE ps_product SET
id_supplier = '109',
reference = '2/4',
ean13 = '9788865126844',
date_upd = NOW()
WHERE id_product = '16173'
23/01/2023 07:27:55 pm >> UPDATE ps_product_lang SET
name = 'FORTI NELLA FEDE - M. MARGAGLIOTTI',
description = ''
WHERE id_product = '16173'
23/01/2023 07:27:55 pm >> UPDATE ps_product SET
wholesale_price = '6.63',
on_sale = '0',
price = '10.0000'
WHERE id_product = '16173'
23/01/2023 07:27:55 pm >> UPDATE ps_product_shop SET
wholesale_price = '6.63',
price = '10.0000',
id_tax_rules_group = '4',
id_category_default = '137',
id_argoment_default = '21',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '16173'
23/01/2023 07:27:55 pm >> DELETE FROM ps_specific_price WHERE id_product = '16173'
23/01/2023 07:28:09 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801067972' AND id_product != '19699' AND ean13 != ''
23/01/2023 07:28:09 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '2/4',
ean13 = '9788801067972',
date_upd = NOW()
WHERE id_product = '19699'
23/01/2023 07:28:09 pm >> UPDATE ps_product_lang SET
name = 'NOI CI STIAMO - R. SALA',
description = ''
WHERE id_product = '19699'
23/01/2023 07:28:09 pm >> UPDATE ps_product SET
wholesale_price = '5.20',
on_sale = '0',
price = '8.0000'
WHERE id_product = '19699'
23/01/2023 07:28:09 pm >> UPDATE ps_product_shop SET
wholesale_price = '5.20',
price = '8.0000',
id_tax_rules_group = '4',
id_category_default = '19',
id_argoment_default = '58',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '19699'
23/01/2023 07:28:09 pm >> DELETE FROM ps_specific_price WHERE id_product = '19699'
23/01/2023 07:30:15 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788861242821' AND id_product != '1815' AND ean13 != ''
23/01/2023 07:30:15 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '2/1',
ean13 = '9788861242821',
date_upd = NOW()
WHERE id_product = '1815'
23/01/2023 07:30:15 pm >> UPDATE ps_product_lang SET
name = 'CATECHISMO A DOMANDE E RISPOSTE - GUIDA',
description = ''
WHERE id_product = '1815'
23/01/2023 07:30:15 pm >> UPDATE ps_product SET
wholesale_price = '3.43',
on_sale = '0',
price = '4.9000'
WHERE id_product = '1815'
23/01/2023 07:30:15 pm >> UPDATE ps_product_shop SET
wholesale_price = '3.43',
price = '4.9000',
id_tax_rules_group = '4',
id_category_default = '26',
id_argoment_default = '56',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '1815'
23/01/2023 07:30:15 pm >> DELETE FROM ps_specific_price WHERE id_product = '1815'
23/01/2023 07:30:23 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788861242838' AND id_product != '1816' AND ean13 != ''
23/01/2023 07:30:23 pm >> UPDATE ps_product SET
id_supplier = '',
reference = '2/1',
ean13 = '9788861242838',
date_upd = NOW()
WHERE id_product = '1816'
23/01/2023 07:30:23 pm >> UPDATE ps_product_lang SET
name = 'CATECHISMO A DOMANDE E RISPOSTE 1',
description = ''
WHERE id_product = '1816'
23/01/2023 07:30:23 pm >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '4.9000'
WHERE id_product = '1816'
23/01/2023 07:30:23 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '4.9000',
id_tax_rules_group = '4',
id_category_default = '26',
id_argoment_default = '56',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '1816'
23/01/2023 07:30:23 pm >> DELETE FROM ps_specific_price WHERE id_product = '1816'
23/01/2023 07:30:29 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788861242845' AND id_product != '1817' AND ean13 != ''
23/01/2023 07:30:29 pm >> UPDATE ps_product SET
id_supplier = '',
reference = '2/1',
ean13 = '9788861242845',
date_upd = NOW()
WHERE id_product = '1817'
23/01/2023 07:30:30 pm >> UPDATE ps_product_lang SET
name = 'CATECHISMO A DOMANDE E RISPOSTE 2',
description = ''
WHERE id_product = '1817'
23/01/2023 07:30:30 pm >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '4.9000'
WHERE id_product = '1817'
23/01/2023 07:30:30 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '4.9000',
id_tax_rules_group = '4',
id_category_default = '26',
id_argoment_default = '56',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '1817'
23/01/2023 07:30:30 pm >> DELETE FROM ps_specific_price WHERE id_product = '1817'
23/01/2023 07:30:36 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788861242852' AND id_product != '1818' AND ean13 != ''
23/01/2023 07:30:36 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '2/1',
ean13 = '9788861242852',
date_upd = NOW()
WHERE id_product = '1818'
23/01/2023 07:30:36 pm >> UPDATE ps_product_lang SET
name = 'CATECHISMO A DOMANDE E RISPOSTE 3',
description = ''
WHERE id_product = '1818'
23/01/2023 07:30:36 pm >> UPDATE ps_product SET
wholesale_price = '3.43',
on_sale = '0',
price = '4.9000'
WHERE id_product = '1818'
23/01/2023 07:30:36 pm >> UPDATE ps_product_shop SET
wholesale_price = '3.43',
price = '4.9000',
id_tax_rules_group = '4',
id_category_default = '26',
id_argoment_default = '56',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '1818'
23/01/2023 07:30:36 pm >> DELETE FROM ps_specific_price WHERE id_product = '1818'
23/01/2023 07:44:25 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892240278' AND id_product != '20211' AND ean13 != ''
23/01/2023 07:44:25 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '2/3',
ean13 = '9788892240278',
date_upd = NOW()
WHERE id_product = '20211'
23/01/2023 07:44:25 pm >> UPDATE ps_product_lang SET
name = 'COME E\' FATTA UNA CHIESA',
description = ''
WHERE id_product = '20211'
23/01/2023 07:44:25 pm >> UPDATE ps_product SET
wholesale_price = '3.19',
on_sale = '0',
price = '4.9000'
WHERE id_product = '20211'
23/01/2023 07:44:25 pm >> UPDATE ps_product_shop SET
wholesale_price = '3.19',
price = '4.9000',
id_tax_rules_group = '4',
id_category_default = '30',
id_argoment_default = '108',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '20211'
23/01/2023 07:44:25 pm >> DELETE FROM ps_specific_price WHERE id_product = '20211'
23/01/2023 07:44:38 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892240261' AND id_product != '20208' AND ean13 != ''
23/01/2023 07:44:39 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '2/3',
ean13 = '9788892240261',
date_upd = NOW()
WHERE id_product = '20208'
23/01/2023 07:44:39 pm >> UPDATE ps_product_lang SET
name = 'SEGNI DELLA MESSA',
description = ''
WHERE id_product = '20208'
23/01/2023 07:44:39 pm >> UPDATE ps_product SET
wholesale_price = '3.19',
on_sale = '0',
price = '4.9000'
WHERE id_product = '20208'
23/01/2023 07:44:39 pm >> UPDATE ps_product_shop SET
wholesale_price = '3.19',
price = '4.9000',
id_tax_rules_group = '4',
id_category_default = '30',
id_argoment_default = '108',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '20208'
23/01/2023 07:44:39 pm >> DELETE FROM ps_specific_price WHERE id_product = '20208'