31/03/2023 09:03:35 am >> SELECT document_num FROM ps_document
WHERE document_num = '1061' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-31')
31/03/2023 09:03: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 (
'11' ,
'1061' ,
'2023-03-31' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'0.70' ,
'0.70' ,
NOW() ,
NOW() )
31/03/2023 09:03: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 = '82567'
31/03/2023 09:03:35 am >> DELETE FROM ps_document_detail WHERE id_document = '82567'
31/03/2023 09:03: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
( '82567' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '1' , '-1' , '4' ,
'0.70' , '0.7' , '0' , '0' , '0.70' )
31/03/2023 09:24:37 am >> SELECT ean13 FROM ps_product WHERE ean13 = '03007-M' AND id_product != '7911' AND ean13 != ''
31/03/2023 09:24:37 am >> UPDATE ps_product SET
id_supplier = '',
reference = '',
ean13 = '03007-M',
date_upd = NOW()
WHERE id_product = '7911'
31/03/2023 09:24:37 am >> UPDATE ps_product_lang SET
name = 'PERGAMENE - 1A COMUNIONE MOD. B',
description = ''
WHERE id_product = '7911'
31/03/2023 09:24:37 am >> UPDATE ps_product SET
wholesale_price = '0.06',
on_sale = '0',
price = '0.4098'
WHERE id_product = '7911'
31/03/2023 09:24:37 am >> UPDATE ps_product_shop SET
wholesale_price = '0.06',
price = '0.4098',
id_tax_rules_group = '1',
id_category_default = '395',
id_argoment_default = '5',
id_internal_category = '4',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '7911'
31/03/2023 09:24:37 am >> DELETE FROM ps_specific_price WHERE id_product = '7911'
31/03/2023 09:24:37 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' , '7911' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' )
31/03/2023 09:24:48 am >> SELECT ean13 FROM ps_product WHERE ean13 = '03006-XP' AND id_product != '7910' AND ean13 != ''
31/03/2023 09:24:48 am >> UPDATE ps_product SET
id_supplier = '',
reference = '',
ean13 = '03006-XP',
date_upd = NOW()
WHERE id_product = '7910'
31/03/2023 09:24:48 am >> UPDATE ps_product_lang SET
name = 'PERGAMENE - 1A COMUNIONE MOD. A',
description = ''
WHERE id_product = '7910'
31/03/2023 09:24:48 am >> UPDATE ps_product SET
wholesale_price = '0.06',
on_sale = '0',
price = '0.1230'
WHERE id_product = '7910'
31/03/2023 09:24:48 am >> UPDATE ps_product_shop SET
wholesale_price = '0.06',
price = '0.1230',
id_tax_rules_group = '1',
id_category_default = '395',
id_argoment_default = '5',
id_internal_category = '4',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '7910'
31/03/2023 09:24:48 am >> DELETE FROM ps_specific_price WHERE id_product = '7910'
31/03/2023 09:25:05 am >> SELECT ean13 FROM ps_product WHERE ean13 = '03008-P' AND id_product != '7914' AND ean13 != ''
31/03/2023 09:25:05 am >> UPDATE ps_product SET
id_supplier = '',
reference = '',
ean13 = '03008-P',
date_upd = NOW()
WHERE id_product = '7914'
31/03/2023 09:25:05 am >> UPDATE ps_product_lang SET
name = 'PERGAMENE - 1A COMUNIONE MOD. C',
description = ''
WHERE id_product = '7914'
31/03/2023 09:25:05 am >> UPDATE ps_product SET
wholesale_price = '0.04',
on_sale = '0',
price = '0.2459'
WHERE id_product = '7914'
31/03/2023 09:25:05 am >> UPDATE ps_product_shop SET
wholesale_price = '0.04',
price = '0.2459',
id_tax_rules_group = '1',
id_category_default = '395',
id_argoment_default = '5',
id_internal_category = '4',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '7914'
31/03/2023 09:25:05 am >> DELETE FROM ps_specific_price WHERE id_product = '7914'
31/03/2023 09:25:14 am >> SELECT ean13 FROM ps_product WHERE ean13 = '03009-M' AND id_product != '7915' AND ean13 != ''
31/03/2023 09:25:14 am >> UPDATE ps_product SET
id_supplier = '',
reference = '',
ean13 = '03009-M',
date_upd = NOW()
WHERE id_product = '7915'
31/03/2023 09:25:14 am >> UPDATE ps_product_lang SET
name = 'PERGAMENE - 1A COMUNIONE MOD. D',
description = ''
WHERE id_product = '7915'
31/03/2023 09:25:14 am >> UPDATE ps_product SET
wholesale_price = '0.06',
on_sale = '0',
price = '0.4100'
WHERE id_product = '7915'
31/03/2023 09:25:14 am >> UPDATE ps_product_shop SET
wholesale_price = '0.06',
price = '0.4100',
id_tax_rules_group = '1',
id_category_default = '395',
id_argoment_default = '5',
id_internal_category = '4',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '7915'
31/03/2023 09:25:14 am >> DELETE FROM ps_specific_price WHERE id_product = '7915'
31/03/2023 09:25:28 am >> SELECT ean13 FROM ps_product WHERE ean13 = '030014-M' AND id_product != '7916' AND ean13 != ''
31/03/2023 09:25:28 am >> UPDATE ps_product SET
id_supplier = '',
reference = '',
ean13 = '030014-M',
date_upd = NOW()
WHERE id_product = '7916'
31/03/2023 09:25:28 am >> UPDATE ps_product_lang SET
name = 'PERGAMENE - 1A RICONCILIAZIONE MOD. A',
description = ''
WHERE id_product = '7916'
31/03/2023 09:25:29 am >> UPDATE ps_product SET
wholesale_price = '0.06',
on_sale = '0',
price = '0.4098'
WHERE id_product = '7916'
31/03/2023 09:25:29 am >> UPDATE ps_product_shop SET
wholesale_price = '0.06',
price = '0.4098',
id_tax_rules_group = '1',
id_category_default = '395',
id_argoment_default = '5',
id_internal_category = '4',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '7916'
31/03/2023 09:25:29 am >> DELETE FROM ps_specific_price WHERE id_product = '7916'
31/03/2023 09:25:54 am >> SELECT ean13 FROM ps_product WHERE ean13 = '030017-M' AND id_product != '7920' AND ean13 != ''
31/03/2023 09:25:54 am >> UPDATE ps_product SET
id_supplier = '',
reference = '',
ean13 = '030017-M',
date_upd = NOW()
WHERE id_product = '7920'
31/03/2023 09:25:54 am >> UPDATE ps_product_lang SET
name = 'PERGAMENE - ANNIVERSARIO MATRIM. MOD. A',
description = ''
WHERE id_product = '7920'
31/03/2023 09:25:54 am >> UPDATE ps_product SET
wholesale_price = '0.04',
on_sale = '0',
price = '0.4098'
WHERE id_product = '7920'
31/03/2023 09:25:54 am >> UPDATE ps_product_shop SET
wholesale_price = '0.04',
price = '0.4098',
id_tax_rules_group = '1',
id_category_default = '395',
id_argoment_default = '5',
id_internal_category = '4',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '7920'
31/03/2023 09:25:54 am >> DELETE FROM ps_specific_price WHERE id_product = '7920'
31/03/2023 09:26:04 am >> SELECT ean13 FROM ps_product WHERE ean13 = '030018-G' AND id_product != '7921' AND ean13 != ''
31/03/2023 09:26:04 am >> UPDATE ps_product SET
id_supplier = '',
reference = '',
ean13 = '030018-G',
date_upd = NOW()
WHERE id_product = '7921'
31/03/2023 09:26:05 am >> UPDATE ps_product_lang SET
name = 'PERGAMENE - ANNIVERSARIO MATRIM. MOD. B',
description = ''
WHERE id_product = '7921'
31/03/2023 09:26:05 am >> UPDATE ps_product SET
wholesale_price = '0.04',
on_sale = '0',
price = '0.5738'
WHERE id_product = '7921'
31/03/2023 09:26:05 am >> UPDATE ps_product_shop SET
wholesale_price = '0.04',
price = '0.5738',
id_tax_rules_group = '1',
id_category_default = '395',
id_argoment_default = '5',
id_internal_category = '4',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '7921'
31/03/2023 09:26:05 am >> DELETE FROM ps_specific_price WHERE id_product = '7921'
31/03/2023 09:26:14 am >> SELECT ean13 FROM ps_product WHERE ean13 = '030018-M' AND id_product != '7922' AND ean13 != ''
31/03/2023 09:26:14 am >> UPDATE ps_product SET
id_supplier = '',
reference = '',
ean13 = '030018-M',
date_upd = NOW()
WHERE id_product = '7922'
31/03/2023 09:26:14 am >> UPDATE ps_product_lang SET
name = 'PERGAMENE - ANNIVERSARIO MATRIM. MOD. B',
description = ''
WHERE id_product = '7922'
31/03/2023 09:26:14 am >> UPDATE ps_product SET
wholesale_price = '0.04',
on_sale = '0',
price = '0.4098'
WHERE id_product = '7922'
31/03/2023 09:26:14 am >> UPDATE ps_product_shop SET
wholesale_price = '0.04',
price = '0.4098',
id_tax_rules_group = '1',
id_category_default = '395',
id_argoment_default = '5',
id_internal_category = '4',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '7922'
31/03/2023 09:26:14 am >> DELETE FROM ps_specific_price WHERE id_product = '7922'
31/03/2023 09:26:22 am >> SELECT ean13 FROM ps_product WHERE ean13 = '030018-P' AND id_product != '7923' AND ean13 != ''
31/03/2023 09:26:22 am >> UPDATE ps_product SET
id_supplier = '',
reference = '',
ean13 = '030018-P',
date_upd = NOW()
WHERE id_product = '7923'
31/03/2023 09:26:22 am >> UPDATE ps_product_lang SET
name = 'PERGAMENE - ANNIVERSARIO MATRIM. MOD. B',
description = ''
WHERE id_product = '7923'
31/03/2023 09:26:22 am >> UPDATE ps_product SET
wholesale_price = '0.04',
on_sale = '0',
price = '0.2459'
WHERE id_product = '7923'
31/03/2023 09:26:22 am >> UPDATE ps_product_shop SET
wholesale_price = '0.04',
price = '0.2459',
id_tax_rules_group = '1',
id_category_default = '395',
id_argoment_default = '5',
id_internal_category = '4',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '7923'
31/03/2023 09:26:23 am >> DELETE FROM ps_specific_price WHERE id_product = '7923'
31/03/2023 09:26:31 am >> SELECT ean13 FROM ps_product WHERE ean13 = '03002-M' AND id_product != '7924' AND ean13 != ''
31/03/2023 09:26:31 am >> UPDATE ps_product SET
id_supplier = '',
reference = '',
ean13 = '03002-M',
date_upd = NOW()
WHERE id_product = '7924'
31/03/2023 09:26:31 am >> UPDATE ps_product_lang SET
name = 'PERGAMENE - BATTESIMO MOD. A',
description = ''
WHERE id_product = '7924'
31/03/2023 09:26:31 am >> UPDATE ps_product SET
wholesale_price = '0.06',
on_sale = '0',
price = '0.4098'
WHERE id_product = '7924'
31/03/2023 09:26:31 am >> UPDATE ps_product_shop SET
wholesale_price = '0.06',
price = '0.4098',
id_tax_rules_group = '1',
id_category_default = '395',
id_argoment_default = '5',
id_internal_category = '4',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '7924'
31/03/2023 09:26:31 am >> DELETE FROM ps_specific_price WHERE id_product = '7924'
31/03/2023 09:26:39 am >> SELECT ean13 FROM ps_product WHERE ean13 = '03002-XP' AND id_product != '7925' AND ean13 != ''
31/03/2023 09:26:39 am >> UPDATE ps_product SET
id_supplier = '',
reference = '',
ean13 = '03002-XP',
date_upd = NOW()
WHERE id_product = '7925'
31/03/2023 09:26:39 am >> UPDATE ps_product_lang SET
name = 'PERGAMENE - BATTESIMO MOD. A',
description = ''
WHERE id_product = '7925'
31/03/2023 09:26:39 am >> UPDATE ps_product SET
wholesale_price = '0.06',
on_sale = '0',
price = '0.1230'
WHERE id_product = '7925'
31/03/2023 09:26:39 am >> UPDATE ps_product_shop SET
wholesale_price = '0.06',
price = '0.1230',
id_tax_rules_group = '1',
id_category_default = '395',
id_argoment_default = '5',
id_internal_category = '4',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '7925'
31/03/2023 09:26:39 am >> DELETE FROM ps_specific_price WHERE id_product = '7925'
31/03/2023 09:26:47 am >> SELECT ean13 FROM ps_product WHERE ean13 = '03003-M' AND id_product != '7926' AND ean13 != ''
31/03/2023 09:26:47 am >> UPDATE ps_product SET
id_supplier = '',
reference = '',
ean13 = '03003-M',
date_upd = NOW()
WHERE id_product = '7926'
31/03/2023 09:26:47 am >> UPDATE ps_product_lang SET
name = 'PERGAMENE - BATTESIMO MOD. B',
description = ''
WHERE id_product = '7926'
31/03/2023 09:26:47 am >> UPDATE ps_product SET
wholesale_price = '0.04',
on_sale = '0',
price = '0.4098'
WHERE id_product = '7926'
31/03/2023 09:26:47 am >> UPDATE ps_product_shop SET
wholesale_price = '0.04',
price = '0.4098',
id_tax_rules_group = '1',
id_category_default = '395',
id_argoment_default = '5',
id_internal_category = '4',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '7926'
31/03/2023 09:26:47 am >> DELETE FROM ps_specific_price WHERE id_product = '7926'
31/03/2023 09:26:54 am >> SELECT ean13 FROM ps_product WHERE ean13 = '03004-G' AND id_product != '7927' AND ean13 != ''
31/03/2023 09:26:54 am >> UPDATE ps_product SET
id_supplier = '',
reference = '',
ean13 = '03004-G',
date_upd = NOW()
WHERE id_product = '7927'
31/03/2023 09:26:54 am >> UPDATE ps_product_lang SET
name = 'PERGAMENE - BATTESIMO MOD. C',
description = ''
WHERE id_product = '7927'
31/03/2023 09:26:54 am >> UPDATE ps_product SET
wholesale_price = '0.04',
on_sale = '0',
price = '0.5738'
WHERE id_product = '7927'
31/03/2023 09:26:54 am >> UPDATE ps_product_shop SET
wholesale_price = '0.04',
price = '0.5738',
id_tax_rules_group = '1',
id_category_default = '395',
id_argoment_default = '5',
id_internal_category = '4',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '7927'
31/03/2023 09:26:54 am >> DELETE FROM ps_specific_price WHERE id_product = '7927'
31/03/2023 09:27:01 am >> SELECT ean13 FROM ps_product WHERE ean13 = '03004-M' AND id_product != '7928' AND ean13 != ''
31/03/2023 09:27:01 am >> UPDATE ps_product SET
id_supplier = '107',
reference = '',
ean13 = '03004-M',
date_upd = NOW()
WHERE id_product = '7928'
31/03/2023 09:27:01 am >> UPDATE ps_product_lang SET
name = 'PERGAMENE - BATTESIMO MOD. C',
description = ''
WHERE id_product = '7928'
31/03/2023 09:27:01 am >> UPDATE ps_product SET
wholesale_price = '0.04',
on_sale = '0',
price = '0.4098'
WHERE id_product = '7928'
31/03/2023 09:27:01 am >> UPDATE ps_product_shop SET
wholesale_price = '0.04',
price = '0.4098',
id_tax_rules_group = '1',
id_category_default = '395',
id_argoment_default = '5',
id_internal_category = '4',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '7928'
31/03/2023 09:27:01 am >> DELETE FROM ps_specific_price WHERE id_product = '7928'
31/03/2023 09:27:08 am >> SELECT ean13 FROM ps_product WHERE ean13 = '03004-P' AND id_product != '7929' AND ean13 != ''
31/03/2023 09:27:08 am >> UPDATE ps_product SET
id_supplier = '',
reference = '',
ean13 = '03004-P',
date_upd = NOW()
WHERE id_product = '7929'
31/03/2023 09:27:08 am >> UPDATE ps_product_lang SET
name = 'PERGAMENE - BATTESIMO MOD. C',
description = ''
WHERE id_product = '7929'
31/03/2023 09:27:08 am >> UPDATE ps_product SET
wholesale_price = '0.04',
on_sale = '0',
price = '0.2459'
WHERE id_product = '7929'
31/03/2023 09:27:08 am >> UPDATE ps_product_shop SET
wholesale_price = '0.04',
price = '0.2459',
id_tax_rules_group = '1',
id_category_default = '395',
id_argoment_default = '5',
id_internal_category = '4',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '7929'
31/03/2023 09:27:08 am >> DELETE FROM ps_specific_price WHERE id_product = '7929'
31/03/2023 09:27:14 am >> SELECT ean13 FROM ps_product WHERE ean13 = '03005-M' AND id_product != '7930' AND ean13 != ''
31/03/2023 09:27:14 am >> UPDATE ps_product SET
id_supplier = '',
reference = '',
ean13 = '03005-M',
date_upd = NOW()
WHERE id_product = '7930'
31/03/2023 09:27:14 am >> UPDATE ps_product_lang SET
name = 'PERGAMENE - BATTESIMO MOD. D',
description = ''
WHERE id_product = '7930'
31/03/2023 09:27:14 am >> UPDATE ps_product SET
wholesale_price = '0.04',
on_sale = '0',
price = '0.4098'
WHERE id_product = '7930'
31/03/2023 09:27:14 am >> UPDATE ps_product_shop SET
wholesale_price = '0.04',
price = '0.4098',
id_tax_rules_group = '1',
id_category_default = '395',
id_argoment_default = '5',
id_internal_category = '4',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '7930'
31/03/2023 09:27:14 am >> DELETE FROM ps_specific_price WHERE id_product = '7930'
31/03/2023 09:27:22 am >> SELECT ean13 FROM ps_product WHERE ean13 = '030010-M' AND id_product != '7931' AND ean13 != ''
31/03/2023 09:27:22 am >> UPDATE ps_product SET
id_supplier = '',
reference = '',
ean13 = '030010-M',
date_upd = NOW()
WHERE id_product = '7931'
31/03/2023 09:27:22 am >> UPDATE ps_product_lang SET
name = 'PERGAMENE - CRESIMA MOD. A',
description = ''
WHERE id_product = '7931'
31/03/2023 09:27:22 am >> UPDATE ps_product SET
wholesale_price = '0.04',
on_sale = '0',
price = '0.4098'
WHERE id_product = '7931'
31/03/2023 09:27:22 am >> UPDATE ps_product_shop SET
wholesale_price = '0.04',
price = '0.4098',
id_tax_rules_group = '1',
id_category_default = '395',
id_argoment_default = '5',
id_internal_category = '4',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '7931'
31/03/2023 09:27:22 am >> DELETE FROM ps_specific_price WHERE id_product = '7931'
31/03/2023 09:27:34 am >> SELECT ean13 FROM ps_product WHERE ean13 = '030012-G' AND id_product != '7933' AND ean13 != ''
31/03/2023 09:27:34 am >> UPDATE ps_product SET
id_supplier = '',
reference = '',
ean13 = '030012-G',
date_upd = NOW()
WHERE id_product = '7933'
31/03/2023 09:27:34 am >> UPDATE ps_product_lang SET
name = 'PERGAMENE - CRESIMA MOD. B',
description = ''
WHERE id_product = '7933'
31/03/2023 09:27:34 am >> UPDATE ps_product SET
wholesale_price = '0.04',
on_sale = '0',
price = '0.5700'
WHERE id_product = '7933'
31/03/2023 09:27:34 am >> UPDATE ps_product_shop SET
wholesale_price = '0.04',
price = '0.5700',
id_tax_rules_group = '1',
id_category_default = '395',
id_argoment_default = '5',
id_internal_category = '4',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '7933'
31/03/2023 09:27:34 am >> DELETE FROM ps_specific_price WHERE id_product = '7933'
31/03/2023 09:27:45 am >> SELECT ean13 FROM ps_product WHERE ean13 = '030012-P' AND id_product != '7935' AND ean13 != ''
31/03/2023 09:27:45 am >> UPDATE ps_product SET
id_supplier = '',
reference = '',
ean13 = '030012-P',
date_upd = NOW()
WHERE id_product = '7935'
31/03/2023 09:27:45 am >> UPDATE ps_product_lang SET
name = 'PERGAMENE - CRESIMA MOD. B',
description = ''
WHERE id_product = '7935'
31/03/2023 09:27:45 am >> UPDATE ps_product SET
wholesale_price = '0.04',
on_sale = '0',
price = '0.2459016393442623'
WHERE id_product = '7935'
31/03/2023 09:27:45 am >> UPDATE ps_product_shop SET
wholesale_price = '0.04',
price = '0.2459016393442623',
id_tax_rules_group = '1',
id_category_default = '395',
id_argoment_default = '5',
id_internal_category = '4',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '7935'
31/03/2023 09:27:45 am >> DELETE FROM ps_specific_price WHERE id_product = '7935'
31/03/2023 09:27:59 am >> UPDATE ps_product_shop SET
minimal_quantity = '1',
multiple_quantity = '1',
available_date = '',
date_upd = NOW()
WHERE id_product = '7932'
31/03/2023 09:27:59 am >> UPDATE ps_stock_available SET quantity = quantity + '-260' WHERE id_product = '7932'
31/03/2023 09:28:27 am >> SELECT ean13 FROM ps_product WHERE ean13 = '030022-M' AND id_product != '7940' AND ean13 != ''
31/03/2023 09:28:27 am >> UPDATE ps_product SET
id_supplier = '',
reference = '',
ean13 = '030022-M',
date_upd = NOW()
WHERE id_product = '7940'
31/03/2023 09:28:27 am >> UPDATE ps_product_lang SET
name = 'PERGAMENE - OCCASIONI MOD. A',
description = ''
WHERE id_product = '7940'
31/03/2023 09:28:27 am >> UPDATE ps_product SET
wholesale_price = '0.06',
on_sale = '0',
price = '0.4098'
WHERE id_product = '7940'
31/03/2023 09:28:27 am >> UPDATE ps_product_shop SET
wholesale_price = '0.06',
price = '0.4098',
id_tax_rules_group = '1',
id_category_default = '395',
id_argoment_default = '5',
id_internal_category = '4',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '7940'
31/03/2023 09:28:27 am >> DELETE FROM ps_specific_price WHERE id_product = '7940'
31/03/2023 09:28:35 am >> SELECT ean13 FROM ps_product WHERE ean13 = '030022-XP' AND id_product != '7941' AND ean13 != ''
31/03/2023 09:28:35 am >> UPDATE ps_product SET
id_supplier = '',
reference = '',
ean13 = '030022-XP',
date_upd = NOW()
WHERE id_product = '7941'
31/03/2023 09:28:35 am >> UPDATE ps_product_lang SET
name = 'PERGAMENE - OCCASIONI MOD. A',
description = ''
WHERE id_product = '7941'
31/03/2023 09:28:35 am >> UPDATE ps_product SET
wholesale_price = '0.06',
on_sale = '0',
price = '0.1230'
WHERE id_product = '7941'
31/03/2023 09:28:35 am >> UPDATE ps_product_shop SET
wholesale_price = '0.06',
price = '0.1230',
id_tax_rules_group = '1',
id_category_default = '395',
id_argoment_default = '5',
id_internal_category = '4',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '7941'
31/03/2023 09:28:35 am >> DELETE FROM ps_specific_price WHERE id_product = '7941'
31/03/2023 09:28:41 am >> SELECT ean13 FROM ps_product WHERE ean13 = '030023-G' AND id_product != '7942' AND ean13 != ''
31/03/2023 09:28:41 am >> UPDATE ps_product SET
id_supplier = '',
reference = '',
ean13 = '030023-G',
date_upd = NOW()
WHERE id_product = '7942'
31/03/2023 09:28:41 am >> UPDATE ps_product_lang SET
name = 'PERGAMENE - OCCASIONI MOD. B',
description = ''
WHERE id_product = '7942'
31/03/2023 09:28:41 am >> UPDATE ps_product SET
wholesale_price = '0.06',
on_sale = '0',
price = '0.5738'
WHERE id_product = '7942'
31/03/2023 09:28:41 am >> UPDATE ps_product_shop SET
wholesale_price = '0.06',
price = '0.5738',
id_tax_rules_group = '1',
id_category_default = '395',
id_argoment_default = '5',
id_internal_category = '4',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '7942'
31/03/2023 09:28:41 am >> DELETE FROM ps_specific_price WHERE id_product = '7942'
31/03/2023 09:28:49 am >> SELECT ean13 FROM ps_product WHERE ean13 = '030023-M' AND id_product != '7943' AND ean13 != ''
31/03/2023 09:28:49 am >> UPDATE ps_product SET
id_supplier = '',
reference = '',
ean13 = '030023-M',
date_upd = NOW()
WHERE id_product = '7943'
31/03/2023 09:28:49 am >> UPDATE ps_product_lang SET
name = 'PERGAMENE - OCCASIONI MOD. B',
description = ''
WHERE id_product = '7943'
31/03/2023 09:28:49 am >> UPDATE ps_product SET
wholesale_price = '0.06',
on_sale = '0',
price = '0.4098'
WHERE id_product = '7943'
31/03/2023 09:28:49 am >> UPDATE ps_product_shop SET
wholesale_price = '0.06',
price = '0.4098',
id_tax_rules_group = '1',
id_category_default = '395',
id_argoment_default = '5',
id_internal_category = '4',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '7943'
31/03/2023 09:28:49 am >> DELETE FROM ps_specific_price WHERE id_product = '7943'
31/03/2023 09:30:41 am >> SELECT ean13 FROM ps_product WHERE ean13 = '030015-P' AND id_product != '7918' AND ean13 != ''
31/03/2023 09:30:41 am >> UPDATE ps_product SET
id_supplier = '',
reference = '',
ean13 = '030015-P',
date_upd = NOW()
WHERE id_product = '7918'
31/03/2023 09:30:41 am >> UPDATE ps_product_lang SET
name = 'PERGAMENE - 1A RICONCILIAZIONE MOD. B',
description = ''
WHERE id_product = '7918'
31/03/2023 09:30:41 am >> UPDATE ps_product SET
wholesale_price = '0.04',
on_sale = '0',
price = '0.2459'
WHERE id_product = '7918'
31/03/2023 09:30:41 am >> UPDATE ps_product_shop SET
wholesale_price = '0.04',
price = '0.2459',
id_tax_rules_group = '1',
id_category_default = '395',
id_argoment_default = '5',
id_internal_category = '4',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '7918'
31/03/2023 09:30:41 am >> DELETE FROM ps_specific_price WHERE id_product = '7918'
31/03/2023 09:30:48 am >> SELECT ean13 FROM ps_product WHERE ean13 = '03008-G' AND id_product != '7912' AND ean13 != ''
31/03/2023 09:30:48 am >> UPDATE ps_product SET
id_supplier = '',
reference = '',
ean13 = '03008-G',
date_upd = NOW()
WHERE id_product = '7912'
31/03/2023 09:30:48 am >> UPDATE ps_product_lang SET
name = 'PERGAMENE - 1A COMUNIONE MOD. C',
description = ''
WHERE id_product = '7912'
31/03/2023 09:30:48 am >> UPDATE ps_product SET
wholesale_price = '0.04',
on_sale = '0',
price = '0.5738'
WHERE id_product = '7912'
31/03/2023 09:30:48 am >> UPDATE ps_product_shop SET
wholesale_price = '0.04',
price = '0.5738',
id_tax_rules_group = '1',
id_category_default = '395',
id_argoment_default = '5',
id_internal_category = '4',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '7912'
31/03/2023 09:30:48 am >> DELETE FROM ps_specific_price WHERE id_product = '7912'
31/03/2023 09:31:05 am >> SELECT ean13 FROM ps_product WHERE ean13 = '030021' AND id_product != '7939' AND ean13 != ''
31/03/2023 09:31:05 am >> UPDATE ps_product SET
id_supplier = '',
reference = '',
ean13 = '030021',
date_upd = NOW()
WHERE id_product = '7939'
31/03/2023 09:31:05 am >> UPDATE ps_product_lang SET
name = 'PERGAMENE - MATRIMONIO-C',
description = ''
WHERE id_product = '7939'
31/03/2023 09:31:05 am >> UPDATE ps_product SET
wholesale_price = '0.04',
on_sale = '0',
price = '0.5738'
WHERE id_product = '7939'
31/03/2023 09:31:05 am >> UPDATE ps_product_shop SET
wholesale_price = '0.04',
price = '0.5738',
id_tax_rules_group = '1',
id_category_default = '395',
id_argoment_default = '5',
id_internal_category = '4',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '7939'
31/03/2023 09:31:05 am >> DELETE FROM ps_specific_price WHERE id_product = '7939'
31/03/2023 09:31:12 am >> SELECT ean13 FROM ps_product WHERE ean13 = '030020' AND id_product != '7938' AND ean13 != ''
31/03/2023 09:31:12 am >> UPDATE ps_product SET
id_supplier = '',
reference = '',
ean13 = '030020',
date_upd = NOW()
WHERE id_product = '7938'
31/03/2023 09:31:12 am >> UPDATE ps_product_lang SET
name = 'PERGAMENE - MATRIMONIO-B',
description = ''
WHERE id_product = '7938'
31/03/2023 09:31:12 am >> UPDATE ps_product SET
wholesale_price = '0.04',
on_sale = '0',
price = '0.6557'
WHERE id_product = '7938'
31/03/2023 09:31:13 am >> UPDATE ps_product_shop SET
wholesale_price = '0.04',
price = '0.6557',
id_tax_rules_group = '1',
id_category_default = '395',
id_argoment_default = '5',
id_internal_category = '4',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '7938'
31/03/2023 09:31:13 am >> DELETE FROM ps_specific_price WHERE id_product = '7938'
31/03/2023 09:31:21 am >> SELECT ean13 FROM ps_product WHERE ean13 = '030019' AND id_product != '7937' AND ean13 != ''
31/03/2023 09:31:21 am >> UPDATE ps_product SET
id_supplier = '',
reference = '',
ean13 = '030019',
date_upd = NOW()
WHERE id_product = '7937'
31/03/2023 09:31:21 am >> UPDATE ps_product_lang SET
name = 'PERGAMENE - MATRIMONIO-A',
description = ''
WHERE id_product = '7937'
31/03/2023 09:31:21 am >> UPDATE ps_product SET
wholesale_price = '0.06',
on_sale = '0',
price = '0.6557'
WHERE id_product = '7937'
31/03/2023 09:31:21 am >> UPDATE ps_product_shop SET
wholesale_price = '0.06',
price = '0.6557',
id_tax_rules_group = '1',
id_category_default = '395',
id_argoment_default = '5',
id_internal_category = '4',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '7937'
31/03/2023 09:31:21 am >> DELETE FROM ps_specific_price WHERE id_product = '7937'
31/03/2023 09:31:32 am >> SELECT ean13 FROM ps_product WHERE ean13 = '030013-M' AND id_product != '7936' AND ean13 != ''
31/03/2023 09:31:32 am >> UPDATE ps_product SET
id_supplier = '',
reference = '',
ean13 = '030013-M',
date_upd = NOW()
WHERE id_product = '7936'
31/03/2023 09:31:32 am >> UPDATE ps_product_lang SET
name = 'PERGAMENE - CRESIMA MOD. C',
description = ''
WHERE id_product = '7936'
31/03/2023 09:31:32 am >> UPDATE ps_product SET
wholesale_price = '0.06',
on_sale = '0',
price = '0.4100'
WHERE id_product = '7936'
31/03/2023 09:31:32 am >> UPDATE ps_product_shop SET
wholesale_price = '0.06',
price = '0.4100',
id_tax_rules_group = '1',
id_category_default = '395',
id_argoment_default = '5',
id_internal_category = '4',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '7936'
31/03/2023 09:31:32 am >> DELETE FROM ps_specific_price WHERE id_product = '7936'
31/03/2023 09:31:48 am >> UPDATE ps_product_shop SET active = '0' WHERE id_product = '7919'
31/03/2023 09:32:13 am >> SELECT ean13 FROM ps_product WHERE ean13 = '030015-M' AND id_product != '7917' AND ean13 != ''
31/03/2023 09:32:13 am >> UPDATE ps_product SET
id_supplier = '',
reference = '',
ean13 = '030015-M',
date_upd = NOW()
WHERE id_product = '7917'
31/03/2023 09:32:13 am >> UPDATE ps_product_lang SET
name = 'PERGAMENE - 1A RICONCILIAZIONE MOD. B',
description = ''
WHERE id_product = '7917'
31/03/2023 09:32:13 am >> UPDATE ps_product SET
wholesale_price = '0.04',
on_sale = '0',
price = '0.4098'
WHERE id_product = '7917'
31/03/2023 09:32:13 am >> UPDATE ps_product_shop SET
wholesale_price = '0.04',
price = '0.4098',
id_tax_rules_group = '1',
id_category_default = '395',
id_argoment_default = '5',
id_internal_category = '4',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '7917'
31/03/2023 09:32:14 am >> DELETE FROM ps_specific_price WHERE id_product = '7917'
31/03/2023 09:44:01 am >> SELECT document_num FROM ps_document
WHERE document_num = '36/A' AND id_document != '82448' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-03-24')
31/03/2023 09:44:01 am >> UPDATE ps_document SET
id_document_type = '24',
document_num = '36/A',
document_date = '2023-03-24',
document_letter = 'A',
id_customer = '3865',
id_supplier = '',
id_address = '4673708',
address1 = 'VIA CROCE 1 - FRAZ. SALITTO 84062 OLEVANO SUL TUSCIANO',
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 = '127.00',
price_tax_excluded = '108.90',
date_upd = NOW()
WHERE id_document = '82448'
31/03/2023 09:44:01 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82448'
31/03/2023 09:44:01 am >> DELETE FROM ps_document_detail WHERE id_document = '82448'
31/03/2023 09:44:02 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '82448' , '1041' , 'BENEDIZIONI' , '400' , '-400' , '1' ,
'0.1800' , '0.14754098360656' , '22' , '0' , '72.00' )
31/03/2023 09:44:02 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '82448' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '1' , '-1' , '1' ,
'22.0000' , '18.032786885246' , '22' , '0' , '22.00' )
31/03/2023 09:44:02 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '82448' , '20885' , 'BIGLIETTI SANTINI X 100 PZ' , '3' , '-3' , '3' ,
'10.00' , '9.6153846153846' , '4' , '0' , '30.00' )
31/03/2023 09:44:02 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '82448' , '11376' , 'VIENI SPIRITO SANTO' , '15' , '-15' , '4' ,
'0.2000' , '0.2' , '0' , '0' , '3.00' )
31/03/2023 09:44:50 am >> SELECT document_num FROM ps_document
WHERE document_num = '34/A' AND id_document != '82289' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-03-14')
31/03/2023 09:44:50 am >> UPDATE ps_document SET
id_document_type = '24',
document_num = '34/A',
document_date = '2023-03-14',
document_letter = 'A',
id_customer = '1656',
id_supplier = '',
id_address = '4677544',
address1 = 'VIA NAZIONALE 84060 OMIGNANO SCALO',
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 = '641.00',
price_tax_excluded = '526.04',
date_upd = NOW()
WHERE id_document = '82289'
31/03/2023 09:44:50 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82289'
31/03/2023 09:44:50 am >> DELETE FROM ps_document_detail WHERE id_document = '82289'
31/03/2023 09:44:50 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '82289' , '15529' , 'TUNICA 2 PIEGONI COLLO RISV. - PTA002B00' , '2' , '-2' , '1' ,
'45.0000' , '36.885245901639' , '22' , '0' , '90.00' )
31/03/2023 09:44:50 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '82289' , '16730' , 'TUNICA AVORIO BORDO ORO - AETA03B05' , '8' , '-8' , '1' ,
'55.0000' , '45.081967213115' , '22' , '0' , '440.00' )
31/03/2023 09:44:50 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '82289' , '15481' , 'CROCE IHS - 2389/CZ' , '27' , '-27' , '1' ,
'2.5000' , '2.0491803278689' , '22' , '0' , '67.50' )
31/03/2023 09:44:50 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '82289' , '18223' , 'CORONA MISSIONARIA - R102' , '40' , '-40' , '1' ,
'1.0000' , '0.81967213114754' , '22' , '0' , '40.00' )
31/03/2023 09:44: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
( '82289' , '20516' , 'CROCE COMUNIONE - 42/08' , '8' , '-8' , '1' ,
'1.2000' , '0.98360655737705' , '22' , '100' , '0.00' )
31/03/2023 09:44: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
( '82289' , '2679' , 'CONOSCERE GESU\'' , '1' , '-1' , '4' ,
'3.50' , '3.5' , '0' , '0' , '3.50' )
31/03/2023 10:05:41 am >> SELECT document_num FROM ps_document
WHERE document_num = '1062' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-31')
31/03/2023 10:05:41 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' ,
'1062' ,
'2023-03-31' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'1.40' ,
'1.40' ,
NOW() ,
NOW() )
31/03/2023 10:05:41 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 = '82568'
31/03/2023 10:05:41 am >> DELETE FROM ps_document_detail WHERE id_document = '82568'
31/03/2023 10:05:41 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '82568' , '19323' , 'PREGHIERE DI SANTA BRIGIDA' , '2' , '-2' , '4' ,
'0.70' , '0.7' , '0' , '0' , '1.40' )
31/03/2023 10:10:38 am >> SELECT document_num FROM ps_document
WHERE document_num = '34/A' AND id_document != '82289' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-03-14')
31/03/2023 10:10:38 am >> UPDATE ps_document SET
id_document_type = '24',
document_num = '34/A',
document_date = '2023-03-14',
document_letter = 'A',
id_customer = '1656',
id_supplier = '',
id_address = '4677544',
address1 = 'VIA NAZIONALE 84060 OMIGNANO SCALO',
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 = '641.00',
price_tax_excluded = '641.00',
date_upd = NOW()
WHERE id_document = '82289'
31/03/2023 10:10: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 = '82289'
31/03/2023 10:10:38 am >> DELETE FROM ps_document_detail WHERE id_document = '82289'
31/03/2023 10:10: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
( '82289' , '15529' , 'TUNICA 2 PIEGONI COLLO RISV. - PTA002B00' , '2' , '-2' , '0' ,
'45.0000' , '45' , '' , '0' , '90.00' )
31/03/2023 10:10: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
( '82289' , '16730' , 'TUNICA AVORIO BORDO ORO - AETA03B05' , '8' , '-8' , '0' ,
'55.0000' , '55' , '' , '0' , '440.00' )
31/03/2023 10:10: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
( '82289' , '15481' , 'CROCE IHS - 2389/CZ' , '27' , '-27' , '0' ,
'2.5000' , '2.5' , '' , '0' , '67.50' )
31/03/2023 10:10: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
( '82289' , '18223' , 'CORONA MISSIONARIA - R102' , '40' , '-40' , '0' ,
'1.0000' , '1' , '' , '0' , '40.00' )
31/03/2023 10:10: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
( '82289' , '20516' , 'CROCE COMUNIONE - 42/08' , '6' , '-6' , '0' ,
'1.2000' , '1.2' , '' , '100' , '0.00' )
31/03/2023 10:10: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
( '82289' , '2679' , 'CONOSCERE GESU\'' , '1' , '-1' , '4' ,
'3.5000' , '3.5' , '0' , '0' , '3.50' )
31/03/2023 10:13:21 am >> SELECT document_num FROM ps_document
WHERE document_num = '1063' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-31')
31/03/2023 10:13:21 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' ,
'1063' ,
'2023-03-31' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'74.00' ,
'60.66' ,
NOW() ,
NOW() )
31/03/2023 10:13:21 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 = '82569'
31/03/2023 10:13:21 am >> DELETE FROM ps_document_detail WHERE id_document = '82569'
31/03/2023 10:13:21 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
( '82569' , '12613' , 'TURIBOLO 10 CM' , '1' , '-1' , '1' ,
'15.00' , '12.295081967213' , '22' , '0' , '15.00' )
31/03/2023 10:13:21 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
( '82569' , '11683' , 'CROCE CON COLOMBA E LACCIO - 0872/09' , '30' , '-30' , '1' ,
'1.8' , '1.4754098360656' , '22' , '0' , '54.00' )
31/03/2023 10:13: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
( '82569' , '5473' , 'IOHANNES 25G - ROSA - EVE ' , '1' , '-1' , '1' ,
'1.50' , '1.2295081967213' , '22' , '0' , '1.50' )
31/03/2023 10:13: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
( '82569' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' ,
'2.5' , '2.0491803278689' , '22' , '0' , '2.50' )
31/03/2023 10:13: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
( '82569' , '18131' , 'TAU MEDIO CM3 - T6' , '1' , '-1' , '1' ,
'1.00' , '0.81967213114754' , '22' , '0' , '1.00' )
31/03/2023 10:21:01 am >> SELECT document_num FROM ps_document
WHERE document_num = '1064' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-31')
31/03/2023 10:21:01 am >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'1064' ,
'2023-03-31' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'19.95' ,
'19.95' ,
NOW() ,
NOW() )
31/03/2023 10:21:01 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82570'
31/03/2023 10:21:01 am >> DELETE FROM ps_document_detail WHERE id_document = '82570'
31/03/2023 10:21:01 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '82570' , '7704' , 'PASSIONE DI NOSTRO SIGNORE GESÙ CRISTO - 8671' , '3' , '-3' , '4' ,
'7.00' , '7' , '0' , '5' , '19.95' )
31/03/2023 10:29:34 am >> SELECT document_num FROM ps_document
WHERE document_num = '1065' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-31')
31/03/2023 10:29:34 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' ,
'1065' ,
'2023-03-31' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'22.00' ,
'18.03' ,
NOW() ,
NOW() )
31/03/2023 10:29:34 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 = '82571'
31/03/2023 10:29:34 am >> DELETE FROM ps_document_detail WHERE id_document = '82571'
31/03/2023 10:29:34 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
( '82571' , '13142' , 'CERETTI DIAM 26X350 - 2635' , '10' , '-10' , '1' ,
'2.20' , '1.8032786885246' , '22' , '0' , '22.00' )
31/03/2023 10:31:29 am >> SELECT document_num FROM ps_document
WHERE document_num = '1066' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-31')
31/03/2023 10:31:29 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' ,
'1066' ,
'2023-03-31' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'15.00' ,
'12.30' ,
NOW() ,
NOW() )
31/03/2023 10:31:29 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 = '82572'
31/03/2023 10:31:29 am >> DELETE FROM ps_document_detail WHERE id_document = '82572'
31/03/2023 10:31:29 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
( '82572' , '6812' , 'MOCCOLO 80X300 ' , '1' , '-1' , '1' ,
'15.00' , '12.295081967213' , '22' , '0' , '15.00' )
31/03/2023 11:04:50 am >> SELECT document_num FROM ps_document
WHERE document_num = '1067' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-31')
31/03/2023 11:04:50 am >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'1067' ,
'2023-03-31' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'36.00' ,
'29.51' ,
NOW() ,
NOW() )
31/03/2023 11:04:50 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82573'
31/03/2023 11:04:50 am >> DELETE FROM ps_document_detail WHERE id_document = '82573'
31/03/2023 11:04:50 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '82573' , '18068' , 'SACCO PORTA ELEMOSINA - 1751' , '1' , '-1' , '1' ,
'36.00' , '29.508196721311' , '22' , '0' , '36.00' )
31/03/2023 11:21:18 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' ,
'2023-FV000618' ,
'2023-03-31' ,
'' ,
'0' ,
'0' ,
'2686' ,
'CITTA\\\' DEL VATICANO 00120 CITTA\\\' DEL VATICANO' ,
'' ,
'' ,
'13' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'347.45' ,
'347.45' ,
NOW() ,
NOW() )
31/03/2023 11:21:18 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 = '82574'
31/03/2023 11:21:18 am >> DELETE FROM ps_document_detail WHERE id_document = '82574'
31/03/2023 11:21:18 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
( '82574' , '20797' , 'QUALCHE PAROLA PRIMA DELLAPOCALISSE - A. CANDIARD' , '1' , '0' , '4' ,
'11.0000' , '11' , '0' , '45' , '6.05' )
31/03/2023 11:21: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
( '82574' , '13380' , 'INTERPRETAZIONE DELLA BIBBIA NELLA CHIESA' , '1' , '0' , '4' ,
'6.0000' , '6' , '0' , '45' , '3.30' )
31/03/2023 11:21: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
( '82574' , '20798' , 'LEZIONARIO FESTIVO ANNO C' , '2' , '0' , '4' ,
'60.0000' , '60' , '0' , '35' , '78.00' )
31/03/2023 11:21: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
( '82574' , '17329' , 'MESSALE ROMANO DALTARE N.E' , '1' , '0' , '4' ,
'110.0000' , '110' , '0' , '30' , '77.00' )
31/03/2023 11:21: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
( '82574' , '5887' , 'LITURGIA DELLE ORE - VOL. I - PER SACERDOTI E RELIGIOSI' , '2' , '0' , '4' ,
'35.0000' , '35' , '0' , '30' , '49.00' )
31/03/2023 11:21: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
( '82574' , '5889' , 'LITURGIA DELLE ORE - VOL. III - PER SACERDOTI E RELIGIOSI' , '2' , '0' , '4' ,
'35.0000' , '35' , '0' , '30' , '49.00' )
31/03/2023 11:21: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
( '82574' , '5890' , 'LITURGIA DELLE ORE - VOL. IV - PER SACERDOTI E RELIGIOSI' , '2' , '0' , '4' ,
'35.0000' , '35' , '0' , '30' , '49.00' )
31/03/2023 11:21: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
( '82574' , '10119' , 'SPE SALVI' , '1' , '0' , '4' ,
'2.0000' , '2' , '0' , '45' , '1.10' )
31/03/2023 11:21: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
( '82574' , '3544' , 'DIRETTORIO OMILETICO' , '1' , '0' , '4' ,
'10.0000' , '10' , '0' , '45' , '5.50' )
31/03/2023 11:21: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
( '82574' , '20464' , 'TI RACCONTO IL VANGELO MATTEO - PAPA FRANCESCO' , '2' , '0' , '4' ,
'15.0000' , '15' , '0' , '45' , '16.50' )
31/03/2023 11:34:03 am >> SELECT document_num FROM ps_document
WHERE document_num = '1068' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-31')
31/03/2023 11:34:03 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' ,
'1068' ,
'2023-03-31' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'62.00' ,
'50.82' ,
NOW() ,
NOW() )
31/03/2023 11:34:03 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 = '82575'
31/03/2023 11:34:03 am >> DELETE FROM ps_document_detail WHERE id_document = '82575'
31/03/2023 11:34:03 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
( '82575' , '16731' , 'COPRILEGGIO CROCE ORO - AVCL01' , '1' , '-1' , '1' ,
'62.00' , '50.819672131148' , '22' , '0' , '62.00' )
31/03/2023 11:41:57 am >> SELECT ean13 FROM ps_product WHERE ean13 = '364/TP' AND id_product != '12744' AND ean13 != ''
31/03/2023 11:41:57 am >> UPDATE ps_product SET
id_supplier = '89',
reference = '',
ean13 = '364/TP',
date_upd = NOW()
WHERE id_product = '12744'
31/03/2023 11:41:57 am >> UPDATE ps_product_lang SET
name = 'COPRILEGGIO MARIANO - 364/TP',
description = ''
WHERE id_product = '12744'
31/03/2023 11:41:57 am >> UPDATE ps_product SET
wholesale_price = '25.80',
on_sale = '0',
price = '61.47540983606557'
WHERE id_product = '12744'
31/03/2023 11:41:57 am >> UPDATE ps_product_shop SET
wholesale_price = '25.80',
price = '61.47540983606557',
id_tax_rules_group = '1',
id_category_default = '396',
id_argoment_default = '42',
id_internal_category = '3',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '12744'
31/03/2023 11:41:57 am >> DELETE FROM ps_specific_price WHERE id_product = '12744'
31/03/2023 11:44:13 am >> SELECT ean13 FROM ps_product WHERE ean13 = '317/TP' AND id_product != '13929' AND ean13 != ''
31/03/2023 11:44:13 am >> UPDATE ps_product SET
id_supplier = '89',
reference = '',
ean13 = '317/TP',
date_upd = NOW()
WHERE id_product = '13929'
31/03/2023 11:44:13 am >> UPDATE ps_product_lang SET
name = 'COPRILEGGIO - 317/TP',
description = ''
WHERE id_product = '13929'
31/03/2023 11:44:13 am >> UPDATE ps_product SET
wholesale_price = '23.70',
on_sale = '0',
price = '57.37704918032787'
WHERE id_product = '13929'
31/03/2023 11:44:13 am >> UPDATE ps_product_shop SET
wholesale_price = '23.70',
price = '57.37704918032787',
id_tax_rules_group = '1',
id_category_default = '396',
id_argoment_default = '42',
id_internal_category = '3',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '13929'
31/03/2023 11:44:13 am >> DELETE FROM ps_specific_price WHERE id_product = '13929'
31/03/2023 11:46:25 am >> SELECT document_num FROM ps_document
WHERE document_num = '416' AND id_document != '81231' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-04')
31/03/2023 11:46:25 am >> UPDATE ps_document SET
id_document_type = '11',
document_num = '416',
document_date = '2023-02-04',
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 = '590.00',
price_tax_excluded = '510.30',
date_upd = NOW()
WHERE id_document = '81231'
31/03/2023 11:46:25 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81231'
31/03/2023 11:46:25 am >> DELETE FROM ps_document_detail WHERE id_document = '81231'
31/03/2023 11:46:25 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '81231' , '16686' , 'EVANGELIARIO' , '1' , '-1' , '4' ,
'140.0000' , '140' , '0' , '5' , '133.00' )
31/03/2023 11:46:25 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '81231' , '14000' , 'GALATEO IN CHIESA' , '15' , '-15' , '4' ,
'1.0000' , '1' , '0' , '0' , '15.00' )
31/03/2023 11:46:25 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '81231' , '1041' , 'BENEDIZIONI' , '200' , '-200' , '1' ,
'0.1800' , '0.14754098360656' , '22' , '0' , '36.00' )
31/03/2023 11:46:25 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '81231' , '2722' , 'COPRI AMBONE FIGLIOL PRODIGO' , '1' , '-1' , '1' ,
'120.0000' , '98.360655737705' , '22' , '0' , '120.00' )
31/03/2023 11:46:25 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '81231' , '14214' , 'CASULA IN POLIESTERE ' , '1' , '-1' , '1' ,
'70.0000' , '57.377049180328' , '22' , '0' , '70.00' )
31/03/2023 11:46: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
( '81231' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '10' , '-10' , '1' ,
'3.5000' , '2.8688524590164' , '22' , '0' , '35.00' )
31/03/2023 11:46: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
( '81231' , '19607' , 'CLERGY F/F COTONE ML ' , '1' , '-1' , '1' ,
'31.0000' , '25.409836065574' , '22' , '0' , '31.00' )
31/03/2023 11:46: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
( '81231' , '15210' , 'CERO PASQUALE API 80X120' , '1' , '-1' , '1' ,
'85.0000' , '69.672131147541' , '22' , '0' , '85.00' )
31/03/2023 11:46: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
( '81231' , '12744' , 'COPRILEGGIO MARIANO - 364/TP' , '1' , '-1' , '1' ,
'65' , '53.27868852459' , '22' , '0' , '65.00' )
31/03/2023 12:20:57 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788872296028' AND id_product != '17894' AND ean13 != ''
31/03/2023 12:20:57 pm >> UPDATE ps_product SET
id_supplier = '47',
reference = '6/3',
ean13 = '9788872296028',
date_upd = NOW()
WHERE id_product = '17894'
31/03/2023 12:20:57 pm >> UPDATE ps_product_lang SET
name = 'OPERE TERESA DI GESU\'',
description = ''
WHERE id_product = '17894'
31/03/2023 12:20:57 pm >> UPDATE ps_product SET
wholesale_price = '21.00',
on_sale = '0',
price = '30.0000'
WHERE id_product = '17894'
31/03/2023 12:20:57 pm >> UPDATE ps_product_shop SET
wholesale_price = '21.00',
price = '30.0000',
id_tax_rules_group = '4',
id_category_default = '128',
id_argoment_default = '74',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '17894'
31/03/2023 12:20:57 pm >> DELETE FROM ps_specific_price WHERE id_product = '17894'
31/03/2023 12:21:13 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788872297988' AND id_product != '17418' AND ean13 != ''
31/03/2023 12:21:13 pm >> UPDATE ps_product SET
id_supplier = '47',
reference = '6/3',
ean13 = '9788872297988',
date_upd = NOW()
WHERE id_product = '17418'
31/03/2023 12:21:13 pm >> UPDATE ps_product_lang SET
name = 'OPERE COMPLETE S. GIOVANNI DELLA CROCE',
description = ''
WHERE id_product = '17418'
31/03/2023 12:21:13 pm >> UPDATE ps_product SET
wholesale_price = '29.40',
on_sale = '0',
price = '42.0000'
WHERE id_product = '17418'
31/03/2023 12:21:13 pm >> UPDATE ps_product_shop SET
wholesale_price = '29.40',
price = '42.0000',
id_tax_rules_group = '4',
id_category_default = '128',
id_argoment_default = '74',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '17418'
31/03/2023 12:21:13 pm >> DELETE FROM ps_specific_price WHERE id_product = '17418'
31/03/2023 12:21:28 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788873576785' AND id_product != '19136' AND ean13 != ''
31/03/2023 12:21:29 pm >> UPDATE ps_product SET
id_supplier = '107',
reference = '6/3',
ean13 = '9788873576785',
date_upd = NOW()
WHERE id_product = '19136'
31/03/2023 12:21:29 pm >> UPDATE ps_product_lang SET
name = 'SCRITTI DI S. IGNAZIO',
description = ''
WHERE id_product = '19136'
31/03/2023 12:21:29 pm >> UPDATE ps_product SET
wholesale_price = '32.50',
on_sale = '0',
price = '50.0000'
WHERE id_product = '19136'
31/03/2023 12:21:29 pm >> UPDATE ps_product_shop SET
wholesale_price = '32.50',
price = '50.0000',
id_tax_rules_group = '4',
id_category_default = '178',
id_argoment_default = '74',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '19136'
31/03/2023 12:21:29 pm >> DELETE FROM ps_specific_price WHERE id_product = '19136'
31/03/2023 12:42:11 pm >> SELECT document_num FROM ps_document
WHERE document_num = '1069' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-31')
31/03/2023 12:42:11 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' ,
'1069' ,
'2023-03-31' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'160.00' ,
'131.15' ,
NOW() ,
NOW() )
31/03/2023 12:42:11 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 = '82576'
31/03/2023 12:42:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '82576'
31/03/2023 12:42:11 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
( '82576' , '15210' , 'CERO PASQUALE API 80X120' , '2' , '-2' , '1' ,
'80' , '65.573770491803' , '22' , '0' , '160.00' )
31/03/2023 12:42:40 pm >> SELECT document_num FROM ps_document
WHERE document_num = '1070' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-31')
31/03/2023 12:42:40 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' ,
'1070' ,
'2023-03-31' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'45.00' ,
'43.27' ,
NOW() ,
NOW() )
31/03/2023 12:42:40 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 = '82577'
31/03/2023 12:42:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '82577'
31/03/2023 12:42:40 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
( '82577' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '10' , '-10' , '3' ,
'3.50' , '3.3653846153846' , '4' , '0' , '35.00' )
31/03/2023 12:42:40 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
( '82577' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' ,
'2.00' , '1.9230769230769' , '4' , '0' , '10.00' )
31/03/2023 12:44:13 pm >> SELECT document_num FROM ps_document
WHERE document_num = '1071' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2023-03-31')
31/03/2023 12:44:13 pm >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'1071' ,
'2023-03-31' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'17.90' ,
'14.67' ,
NOW() ,
NOW() )
31/03/2023 12:44:13 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82578'
31/03/2023 12:44:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '82578'
31/03/2023 12:44:13 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '82578' , '19147' , 'CANDELINE NON GOCCIOLANTI GRECHE' , '1' , '-1' , '1' ,
'17.90' , '14.672131147541' , '22' , '0' , '17.90' )
31/03/2023 12:46:33 pm >> SELECT document_num FROM ps_document
WHERE document_num = '1072' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-31')
31/03/2023 12:46:33 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' ,
'1072' ,
'2023-03-31' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'19.00' ,
'16.85' ,
NOW() ,
NOW() )
31/03/2023 12:46:33 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 = '82579'
31/03/2023 12:46:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '82579'
31/03/2023 12:46:33 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
( '82579' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '2' , '-2' , '3' ,
'3.50' , '3.3653846153846' , '4' , '0' , '7.00' )
31/03/2023 12:46:33 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
( '82579' , '20429' , 'OSTIA SENZA TOSTATURA MORREALE - OS25' , '1' , '-1' , '3' ,
'2.00' , '1.9230769230769' , '4' , '0' , '2.00' )
31/03/2023 12:46:33 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
( '82579' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' ,
'10.00' , '8.1967213114754' , '22' , '0' , '10.00' )
31/03/2023 03:36:03 pm >> SELECT document_num FROM ps_document
WHERE document_num = '22/A' AND id_document != '81317' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-02-10')
31/03/2023 03:36:03 pm >> UPDATE ps_document SET
id_document_type = '24',
document_num = '22/A',
document_date = '2023-02-10',
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 = '141.60',
price_tax_excluded = '141.60',
date_upd = NOW()
WHERE id_document = '81317'
31/03/2023 03:36:03 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81317'
31/03/2023 03:36:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '81317'
31/03/2023 03:36:03 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '81317' , '16267' , 'DIO SI RACCONTA - P. DE MARTINO' , '1' , '-1' , '4' ,
'16.0000' , '16' , '0' , '0' , '16.00' )
31/03/2023 03:36:03 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '81317' , '16444' , 'VANGELO DI MARCO - 8998' , '1' , '-1' , '4' ,
'7.0000' , '7' , '0' , '0' , '7.00' )
31/03/2023 03:36:03 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '81317' , '20766' , 'AMEN - GIU 2023' , '1' , '-1' , '4' ,
'3.9000' , '3.9' , '0' , '0' , '3.90' )
31/03/2023 03:36:03 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '81317' , '20765' , 'AMEN - MAG 2023' , '1' , '-1' , '4' ,
'3.9000' , '3.9' , '0' , '0' , '3.90' )
31/03/2023 03:36:03 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '81317' , '20009' , 'E IL SIGNORE! - V. BATTAGLIA' , '1' , '-1' , '4' ,
'20.0000' , '20' , '0' , '0' , '20.00' )
31/03/2023 03:36:03 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '81317' , '20731' , 'PAROLA E PREGHIERA APR 23' , '1' , '-1' , '4' ,
'2.9000' , '2.9' , '0' , '0' , '2.90' )
31/03/2023 03:36:03 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '81317' , '20764' , 'PAROLA E PREGHIERA - MAG 2023' , '1' , '-1' , '4' ,
'2.9000' , '2.9' , '0' , '0' , '2.90' )
31/03/2023 03:36:03 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '81317' , '20756' , 'COMMENTARIO BIBLICO' , '1' , '-1' , '4' ,
'50.0000' , '50' , '0' , '0' , '50.00' )
31/03/2023 03:36:03 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '81317' , '20801' , 'PREGHIERA RESPIRO DELLANIMA - PAPA FRANCESCO' , '1' , '-1' , '4' ,
'20.0000' , '20' , '0' , '0' , '20.00' )
31/03/2023 03:36:03 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '81317' , '20795' , 'SULLA TUA PAROLA MAG/GIU 2023 - 516' , '1' , '-1' , '4' ,
'5.0000' , '5' , '0' , '0' , '5.00' )
31/03/2023 03:36:03 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '81317' , '20880' , 'UN TEMPO PER DIO - J. PHILIPPE' , '1' , '-1' , '4' ,
'10.00' , '10' , '0' , '0' , '10.00' )
31/03/2023 03:58:30 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788895983455' AND id_product != '13506' AND ean13 != ''
31/03/2023 03:58:30 pm >> UPDATE ps_product SET
id_supplier = '53',
reference = 'ESPOSITORE SAN PAOLO',
ean13 = '9788895983455',
date_upd = NOW()
WHERE id_product = '13506'
31/03/2023 03:58:30 pm >> UPDATE ps_product_lang SET
name = 'SANTO ROSARIO',
description = 'Pagellina tascabile con le indicazioni per la recita del S. Rosario. Contiene l\'esposizione dei misteri e le litanie lauretane e la preghiera finale
'
WHERE id_product = '13506'
31/03/2023 03:58:30 pm >> UPDATE ps_product SET
wholesale_price = '0.15',
on_sale = '0',
price = '0.2459'
WHERE id_product = '13506'
31/03/2023 03:58:31 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.15',
price = '0.2459',
id_tax_rules_group = '1',
id_category_default = '395',
id_argoment_default = '234',
id_internal_category = '4',
on_sale = '0',
on_showcase = '0',
on_offer = '1',
on_most = '00',
date_upd = NOW()
WHERE id_product = '13506'
31/03/2023 03:58:31 pm >> DELETE FROM ps_specific_price WHERE id_product = '13506'
31/03/2023 03:59:06 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788895983462' AND id_product != '13505' AND ean13 != ''
31/03/2023 03:59:06 pm >> UPDATE ps_product SET
id_supplier = '53',
reference = 'ESPOSITORE SAN PAOLO',
ean13 = '9788895983462',
date_upd = NOW()
WHERE id_product = '13505'
31/03/2023 03:59:06 pm >> UPDATE ps_product_lang SET
name = 'CELEBRIAMO IL SACRAMENTO DEL PERDONO',
description = 'Cartoncino pieghevole utile per aiutare giovani e adulti a prepararsi a ricevere il Sacramento della Confessione. L\'esame di coscienza proposto è tratto dai suggerimenti di Papa Francesco.
'
WHERE id_product = '13505'
31/03/2023 03:59:06 pm >> UPDATE ps_product SET
wholesale_price = '0.15',
on_sale = '0',
price = '0.4100'
WHERE id_product = '13505'
31/03/2023 03:59:06 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.15',
price = '0.4100',
id_tax_rules_group = '1',
id_category_default = '395',
id_argoment_default = '234',
id_internal_category = '4',
on_sale = '0',
on_showcase = '0',
on_offer = '1',
on_most = '00',
date_upd = NOW()
WHERE id_product = '13505'
31/03/2023 03:59:06 pm >> DELETE FROM ps_specific_price WHERE id_product = '13505'
31/03/2023 03:59:46 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788895983479' AND id_product != '13504' AND ean13 != ''
31/03/2023 03:59:46 pm >> UPDATE ps_product SET
id_supplier = '53',
reference = 'ESPOSITORE SAN PAOLO',
ean13 = '9788895983479',
date_upd = NOW()
WHERE id_product = '13504'
31/03/2023 03:59:46 pm >> UPDATE ps_product_lang SET
name = 'SACRAMENTO DELLA RICONCILIAZIONE RAGAZZI',
description = 'Un piccolo cartoncino pieghevole utile come sussidio per preparare i bambini alla prima Confessione e per continuare a celebrare il Sacramento del perdono con un esame di coscienza adatto alla loro età.
'
WHERE id_product = '13504'
31/03/2023 03:59:46 pm >> UPDATE ps_product SET
wholesale_price = '0.15',
on_sale = '0',
price = '0.2459'
WHERE id_product = '13504'
31/03/2023 03:59:47 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.15',
price = '0.2459',
id_tax_rules_group = '1',
id_category_default = '395',
id_argoment_default = '234',
id_internal_category = '4',
on_sale = '0',
on_showcase = '0',
on_offer = '1',
on_most = '00',
date_upd = NOW()
WHERE id_product = '13504'
31/03/2023 03:59:47 pm >> DELETE FROM ps_specific_price WHERE id_product = '13504'
31/03/2023 04:41:34 pm >> SELECT document_num FROM ps_document
WHERE document_num = '1073' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-31')
31/03/2023 04:41:35 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' ,
'1073' ,
'2023-03-31' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'13.50' ,
'11.07' ,
NOW() ,
NOW() )
31/03/2023 04:41:35 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 = '82580'
31/03/2023 04:41:35 pm >> DELETE FROM ps_document_detail WHERE id_document = '82580'
31/03/2023 04:41:35 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
( '82580' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' ,
'10.00' , '8.1967213114754' , '22' , '0' , '10.00' )
31/03/2023 04:41:35 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
( '82580' , '4962' , 'IMMAGINE ECCE HOMO - OGGETTI' , '1' , '-1' , '1' ,
'3.50' , '2.8688524590164' , '22' , '0' , '3.50' )
31/03/2023 04:46:50 pm >> SELECT document_num FROM ps_document
WHERE document_num = '1074' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-31')
31/03/2023 04:46:50 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' ,
'1074' ,
'2023-03-31' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'45.00' ,
'36.89' ,
NOW() ,
NOW() )
31/03/2023 04:46:50 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 = '82581'
31/03/2023 04:46:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '82581'
31/03/2023 04:46:50 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
( '82581' , '19150' , 'MOCCOLO 70X200' , '6' , '-6' , '1' ,
'7.50' , '6.1475409836066' , '22' , '0' , '45.00' )
31/03/2023 05:08:27 pm >> SELECT document_num FROM ps_document
WHERE document_num = '1075' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-31')
31/03/2023 05:08:27 pm >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'1075' ,
'2023-03-31' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'16.00' ,
'13.11' ,
NOW() ,
NOW() )
31/03/2023 05:08:27 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82582'
31/03/2023 05:08:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '82582'
31/03/2023 05:08:27 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '82582' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' ,
'16' , '13.114754098361' , '22' , '0' , '16.00' )
31/03/2023 05:10:23 pm >> SELECT document_num FROM ps_document
WHERE document_num = '22/A' AND id_document != '81317' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-02-10')
31/03/2023 05:10:23 pm >> UPDATE ps_document SET
id_document_type = '24',
document_num = '22/A',
document_date = '2023-02-10',
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 = '10.00',
price_tax_excluded = '10.00',
date_upd = NOW()
WHERE id_document = '81317'
31/03/2023 05:10:23 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81317'
31/03/2023 05:10:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '81317'
31/03/2023 05:10:23 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
( '81317' , '20880' , 'UN TEMPO PER DIO - J. PHILIPPE' , '1' , '-1' , '4' ,
'10.0000' , '10' , '0' , '0' , '10.00' )
31/03/2023 05:12:34 pm >> SELECT document_num FROM ps_document
WHERE document_num = '339' AND id_document != '81132' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-31')
31/03/2023 05:12:34 pm >> UPDATE ps_document SET
id_document_type = '11',
document_num = '339',
document_date = '2023-01-31',
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 = '13.60',
price_tax_excluded = '13.60',
date_upd = NOW()
WHERE id_document = '81132'
31/03/2023 05:12:34 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 = '81132'
31/03/2023 05:12:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '81132'
31/03/2023 05:12:34 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
( '81132' , '16444' , 'VANGELO DI MARCO - 8998' , '1' , '-1' , '4' ,
'7.00' , '7' , '0' , '' , '7.00' )
31/03/2023 05:12:34 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
( '81132' , '20766' , 'AMEN - GIU 23' , '1' , '-1' , '4' ,
'3.3' , '3.3' , '0' , '0' , '3.30' )
31/03/2023 05:12:34 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
( '81132' , '20765' , 'AMEN - MAG 23' , '1' , '-1' , '4' ,
'3.3' , '3.3' , '0' , '0' , '3.30' )
31/03/2023 05:14:22 pm >> SELECT document_num FROM ps_document
WHERE document_num = '333' AND id_document != '81122' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-31')
31/03/2023 05:14:22 pm >> UPDATE ps_document SET
id_document_type = '11',
document_num = '333',
document_date = '2023-01-31',
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 = '38.19',
date_upd = NOW()
WHERE id_document = '81122'
31/03/2023 05:14:22 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81122'
31/03/2023 05:14:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '81122'
31/03/2023 05:14:22 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '81122' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '6' , '-6' , '3' ,
'3.5000' , '3.3653846153846' , '4' , '0' , '21.00' )
31/03/2023 05:14:22 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '81122' , '3511' , 'DIO PARLA ALL\'UOMO' , '1' , '-1' , '4' ,
'8' , '8' , '0' , '0' , '8.00' )
31/03/2023 05:14:22 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '81122' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '6' , '-6' , '4' ,
'0.7000' , '0.7' , '0' , '0' , '4.20' )
31/03/2023 05:14:22 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '81122' , '20731' , 'PAROLA E PREGHIERA APR 23' , '1' , '-1' , '4' ,
'2.90' , '2.9' , '0' , '0' , '2.90' )
31/03/2023 05:14:22 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '81122' , '20764' , 'PAROLA E PREGHIERA - MAG 2023' , '1' , '-1' , '4' ,
'2.90' , '2.9' , '0' , '0' , '2.90' )
31/03/2023 05:15:17 pm >> SELECT document_num FROM ps_document
WHERE document_num = '371' AND id_document != '81170' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-02')
31/03/2023 05:15:17 pm >> UPDATE ps_document SET
id_document_type = '11',
document_num = '371',
document_date = '2023-02-02',
document_letter = '',
id_customer = '0',
id_supplier = '',
id_address = '0',
address1 = '',
address2 = '',
note = '',
price_shipping = '0.00',
id_tax_shipping_rules = '4',
colli = '0',
peso = '0',
porto_e_imballo = '0',
mezzo_consegna = '',
id_payment = '0',
id_causal = '0',
price_tax_included = '115.70',
price_tax_excluded = '100.25',
date_upd = NOW()
WHERE id_document = '81170'
31/03/2023 05:15:17 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81170'
31/03/2023 05:15:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '81170'
31/03/2023 05:15:17 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '81170' , '11384' , 'VINO BIANCO DOLCE - 102' , '2' , '-2' , '1' ,
'8.5000' , '6.9672131147541' , '22' , '0' , '17.00' )
31/03/2023 05:15:17 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '81170' , '1220' , 'BICCHIERI FLAMBEAUX - PZ. 50' , '1' , '-1' , '1' ,
'15.0000' , '12.295081967213' , '22' , '0' , '15.00' )
31/03/2023 05:15:17 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '81170' , '19147' , 'CANDELINE NON GOCCIOLANTI GRECHE' , '3' , '-3' , '1' ,
'17.9000' , '14.672131147541' , '22' , '0' , '53.70' )
31/03/2023 05:15:17 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '81170' , '3511' , 'DIO PARLA ALL\'UOMO' , '1' , '-1' , '4' ,
'8' , '8' , '0' , '0' , '8.00' )
31/03/2023 05:15:17 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '81170' , '20710' , 'VIA CRUCIS DELLA PACE' , '1' , '-1' , '4' ,
'2.0000' , '2' , '0' , '0' , '2.00' )
31/03/2023 05:15:17 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '81170' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '1' , '-1' , '4' ,
'1.0000' , '1' , '0' , '0' , '1.00' )
31/03/2023 05:15:17 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '81170' , '20009' , 'E IL SIGNORE! - V. BATTAGLIA' , '1' , '-1' , '4' ,
'20.00' , '20' , '0' , '5' , '19.00' )
31/03/2023 05:16:22 pm >> SELECT document_num FROM ps_document
WHERE document_num = '425' AND id_document != '81244' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-06')
31/03/2023 05:16:22 pm >> UPDATE ps_document SET
id_document_type = '11',
document_num = '425',
document_date = '2023-02-06',
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 = '109.00',
price_tax_excluded = '97.17',
date_upd = NOW()
WHERE id_document = '81244'
31/03/2023 05:16:22 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81244'
31/03/2023 05:16:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '81244'
31/03/2023 05:16:23 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
( '81244' , '5458' , 'IO SONO CON VOI 2 PARTE' , '3' , '-3' , '4' ,
'2.5000' , '2.5' , '0' , '5' , '7.14' )
31/03/2023 05:16:23 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
( '81244' , '15703' , 'CARTONCINO CRESIMA CON CROCETTA - 2370/K51' , '27' , '-27' , '1' ,
'2.3000' , '1.8852459016393' , '22' , '0' , '62.10' )
31/03/2023 05:16:23 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
( '81244' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' ,
'3.5000' , '2.8688524590164' , '22' , '0' , '3.50' )
31/03/2023 05:16:23 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
( '81244' , '5251' , 'INCONTRI EUCARISTICI' , '1' , '-1' , '4' ,
'3.71' , '3.71' , '0' , '0' , '3.71' )
31/03/2023 05:16:23 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
( '81244' , '20670' , 'CIO CHE CONTA E AMARE' , '1' , '-1' , '4' ,
'3.7000' , '3.7' , '0' , '5' , '3.52' )
31/03/2023 05:16:23 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
( '81244' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '1' , '-1' , '4' ,
'1.0000' , '1' , '0' , '0' , '1.00' )
31/03/2023 05:16:23 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
( '81244' , '20661' , 'LASCIATI AMARE - P. CURTAZ' , '1' , '-1' , '4' ,
'4.0000' , '4' , '0' , '5' , '3.80' )
31/03/2023 05:16:23 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
( '81244' , '20710' , 'VIA CRUCIS DELLA PACE' , '1' , '-1' , '4' ,
'2.0000' , '2' , '0' , '5' , '1.90' )
31/03/2023 05:16:23 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
( '81244' , '20711' , 'VIA CRUCIS IN CAMMINO CON LA CHIESA ' , '1' , '-1' , '4' ,
'2.0000' , '2' , '0' , '5' , '1.90' )
31/03/2023 05:16:23 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
( '81244' , '17696' , 'VIA CRUCIS CON SAN CESARE DE BUS' , '1' , '-1' , '4' ,
'2.5000' , '2.5' , '0' , '5' , '2.38' )
31/03/2023 05:16:23 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
( '81244' , '16667' , 'VIA CRUCIS' , '1' , '-1' , '4' ,
'3.0000' , '3' , '0' , '5' , '2.85' )
31/03/2023 05:16:23 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
( '81244' , '16267' , 'DIO SI RACCONTA - P. DE MARTINO' , '1' , '-1' , '4' ,
'16.00' , '16' , '0' , '5' , '15.20' )
31/03/2023 05:17:22 pm >> SELECT document_num FROM ps_document
WHERE document_num = '487' AND id_document != '81323' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-11')
31/03/2023 05:17:22 pm >> UPDATE ps_document SET
id_document_type = '11',
document_num = '487',
document_date = '2023-02-11',
document_letter = '',
id_customer = '0',
id_supplier = '',
id_address = '0',
address1 = '',
address2 = '',
note = '',
price_shipping = '0.00',
id_tax_shipping_rules = '4',
colli = '0',
peso = '0',
porto_e_imballo = '0',
mezzo_consegna = '',
id_payment = '0',
id_causal = '0',
price_tax_included = '35.00',
price_tax_excluded = '34.60',
date_upd = NOW()
WHERE id_document = '81323'
31/03/2023 05:17:22 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81323'
31/03/2023 05:17:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '81323'
31/03/2023 05:17:22 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '81323' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '2' , '-2' , '1' ,
'1.1000' , '0.9016393442623' , '22' , '0' , '2.20' )
31/03/2023 05:17:22 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '81323' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '1' , '-1' , '4' ,
'2.39' , '2.39' , '0' , '0' , '2.39' )
31/03/2023 05:17:22 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '81323' , '20578' , 'TOTUM AMORIS EST ' , '1' , '-1' , '4' ,
'2.0000' , '2' , '0' , '0' , '2.00' )
31/03/2023 05:17:22 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '81323' , '20722' , 'SEMINATORI DI GIOIA' , '1' , '-1' , '4' ,
'2.5000' , '2.5' , '0' , '5' , '2.38' )
31/03/2023 05:17:22 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '81323' , '20730' , 'INSIEME NELLA MESSA APR 23' , '1' , '-1' , '4' ,
'1.8000' , '1.8' , '0' , '5' , '1.71' )
31/03/2023 05:17:22 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '81323' , '20584' , 'INSIEME NELLA MESSA - MAR. 23' , '1' , '-1' , '4' ,
'1.8000' , '1.8' , '0' , '5' , '1.71' )
31/03/2023 05:17:22 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '81323' , '20719' , 'CORONA DELL’ADDOLORATA' , '1' , '-1' , '4' ,
'1.8000' , '1.8' , '0' , '5' , '1.71' )
31/03/2023 05:17:22 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '81323' , '8762' , 'QUINDICI GIOVEDÌ DI SANTA RITA - 8405' , '1' , '-1' , '4' ,
'2.0000' , '2' , '0' , '5' , '1.90' )
31/03/2023 05:17:22 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '81323' , '20801' , 'PREGHIERA RESPIRO DELLANIMA - PAPA FRANCESCO' , '1' , '-1' , '4' ,
'20.00' , '20' , '0' , '5' , '19.00' )
31/03/2023 05:17:52 pm >> SELECT document_num FROM ps_document
WHERE document_num = '690' AND id_document != '82089' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-01')
31/03/2023 05:17:52 pm >> UPDATE ps_document SET
id_document_type = '11',
document_num = '690',
document_date = '2023-03-01',
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 = '45.00',
price_tax_excluded = '45.00',
date_upd = NOW()
WHERE id_document = '82089'
31/03/2023 05:17:52 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 = '82089'
31/03/2023 05:17:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '82089'
31/03/2023 05:17:52 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
( '82089' , '20756' , 'COMMENTARIO BIBLICO' , '1' , '-1' , '4' ,
'45' , '45' , '0' , '0' , '45.00' )
31/03/2023 05:18:52 pm >> SELECT document_num FROM ps_document
WHERE document_num = '357' AND id_document != '81152' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-01')
31/03/2023 05:18:52 pm >> UPDATE ps_document SET
id_document_type = '11',
document_num = '357',
document_date = '2023-02-01',
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 = '11.50',
price_tax_excluded = '11.50',
date_upd = NOW()
WHERE id_document = '81152'
31/03/2023 05:18:52 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 = '81152'
31/03/2023 05:18:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '81152'
31/03/2023 05:18:52 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
( '81152' , '3511' , 'DIO PARLA ALL\'UOMO' , '1' , '-1' , '4' ,
'11.5' , '11.5' , '0' , '0' , '11.50' )
31/03/2023 05:19:08 pm >> SELECT document_num FROM ps_document
WHERE document_num = '453' AND id_document != '81278' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-08')
31/03/2023 05:19:08 pm >> UPDATE ps_document SET
id_document_type = '11',
document_num = '453',
document_date = '2023-02-08',
document_letter = '',
id_customer = '0',
id_supplier = '',
id_address = '0',
address1 = '',
address2 = '',
note = '',
price_shipping = '0.00',
id_tax_shipping_rules = '4',
colli = '0',
peso = '0',
porto_e_imballo = '0',
mezzo_consegna = '',
id_payment = '0',
id_causal = '0',
price_tax_included = '15.45',
price_tax_excluded = '15.45',
date_upd = NOW()
WHERE id_document = '81278'
31/03/2023 05:19:08 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81278'
31/03/2023 05:19:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '81278'
31/03/2023 05:19:08 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '81278' , '20592' , 'SULLA TUA PAROLA MAR/APR 23 - 515' , '1' , '-1' , '4' ,
'5.0000' , '5' , '0' , '5' , '4.75' )
31/03/2023 05:19:08 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '81278' , '5458' , 'IO SONO CON VOI 2 PARTE' , '1' , '-1' , '4' ,
'2.1' , '2.1' , '0' , '0' , '2.10' )
31/03/2023 05:19:08 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '81278' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '2' , '-2' , '4' ,
'1.0000' , '1' , '0' , '0' , '2.00' )
31/03/2023 05:19:08 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '81278' , '16667' , 'VIA CRUCIS' , '2' , '-2' , '4' ,
'3.0000' , '3' , '0' , '5' , '5.70' )
31/03/2023 05:19:08 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '81278' , '19532' , 'PREGHIAMO' , '1' , '-1' , '4' ,
'0.9000' , '0.9' , '0' , '0' , '0.90' )
31/03/2023 05:19:25 pm >> SELECT document_num FROM ps_document
WHERE document_num = '579' AND id_document != '81443' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-20')
31/03/2023 05:19:25 pm >> UPDATE ps_document SET
id_document_type = '11',
document_num = '579',
document_date = '2023-02-20',
document_letter = '',
id_customer = '0',
id_supplier = '',
id_address = '0',
address1 = '',
address2 = '',
note = '',
price_shipping = '0.00',
id_tax_shipping_rules = '4',
colli = '0',
peso = '0',
porto_e_imballo = '0',
mezzo_consegna = '',
id_payment = '0',
id_causal = '0',
price_tax_included = '2.40',
price_tax_excluded = '2.40',
date_upd = NOW()
WHERE id_document = '81443'
31/03/2023 05:19:25 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 = '81443'
31/03/2023 05:19:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '81443'
31/03/2023 05:19:25 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
( '81443' , '5457' , 'IO SONO CON VOI 1 PARTE' , '1' , '-1' , '4' ,
'2.4' , '2.4' , '0' , '0' , '2.40' )
31/03/2023 05:19:41 pm >> SELECT document_num FROM ps_document
WHERE document_num = '730' AND id_document != '82150' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-06')
31/03/2023 05:19:41 pm >> UPDATE ps_document SET
id_document_type = '11',
document_num = '730',
document_date = '2023-03-06',
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 = '1.00',
price_tax_excluded = '1.00',
date_upd = NOW()
WHERE id_document = '82150'
31/03/2023 05:19:41 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 = '82150'
31/03/2023 05:19:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '82150'
31/03/2023 05:19:41 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
( '82150' , '15020' , 'PREGARE OGNI GIORNO' , '1' , '-1' , '4' ,
'1.00' , '1' , '0' , '0' , '1.00' )
31/03/2023 05:19:55 pm >> SELECT document_num FROM ps_document
WHERE document_num = '774' AND id_document != '82212' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-09')
31/03/2023 05:19:55 pm >> UPDATE ps_document SET
id_document_type = '11',
document_num = '774',
document_date = '2023-03-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 = '92.37',
price_tax_excluded = '92.37',
date_upd = NOW()
WHERE id_document = '82212'
31/03/2023 05:19: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 = '82212'
31/03/2023 05:19:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '82212'
31/03/2023 05:19: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
( '82212' , '5457' , 'IO SONO CON VOI 1 PARTE' , '1' , '-1' , '4' ,
'2.50' , '2.5' , '0' , '0' , '2.50' )
31/03/2023 05:19: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
( '82212' , '16677' , 'INDAGINI SU GESU - P. CURTAZ' , '1' , '-1' , '4' ,
'10.0000' , '10' , '0' , '5' , '9.50' )
31/03/2023 05:19: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
( '82212' , '17734' , 'VANGELO E ATTI BAMBINI' , '17' , '-17' , '4' ,
'3.0000' , '3' , '0' , '5' , '48.45' )
31/03/2023 05:19: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
( '82212' , '12253' , 'MIO LIBRO DI PREGHIERE' , '12' , '-12' , '4' ,
'2.8000' , '2.8' , '0' , '5' , '31.92' )
31/03/2023 05:20:19 pm >> SELECT document_num FROM ps_document
WHERE document_num = '836' AND id_document != '82291' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-14')
31/03/2023 05:20:19 pm >> UPDATE ps_document SET
id_document_type = '11',
document_num = '836',
document_date = '2023-03-14',
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 = '4.75',
price_tax_excluded = '4.75',
date_upd = NOW()
WHERE id_document = '82291'
31/03/2023 05:20:19 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82291'
31/03/2023 05:20:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '82291'
31/03/2023 05:20:19 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '82291' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '1' , '-1' , '4' ,
'3.25' , '3.25' , '0' , '0' , '3.25' )
31/03/2023 05:20:19 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '82291' , '6663' , 'MIE PREGHIERE - 8783' , '1' , '-1' , '4' ,
'1.5000' , '1.5' , '0' , '0' , '1.50' )
31/03/2023 05:20:57 pm >> SELECT document_num FROM ps_document
WHERE document_num = '575' AND id_document != '81437' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-20')
31/03/2023 05:20:57 pm >> UPDATE ps_document SET
id_document_type = '11',
document_num = '575',
document_date = '2023-02-20',
document_letter = '',
id_customer = '0',
id_supplier = '',
id_address = '0',
address1 = '',
address2 = '',
note = '',
price_shipping = '0.00',
id_tax_shipping_rules = '4',
colli = '0',
peso = '0',
porto_e_imballo = '0',
mezzo_consegna = '',
id_payment = '0',
id_causal = '0',
price_tax_included = '145.50',
price_tax_excluded = '126.30',
date_upd = NOW()
WHERE id_document = '81437'
31/03/2023 05:20:57 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 = '81437'
31/03/2023 05:20:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '81437'
31/03/2023 05:20:57 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
( '81437' , '20433' , 'PARTICOLA SENZA TOSTATURA MORREALE 38MM - PTC38S' , '10' , '-10' , '3' ,
'3.5000' , '3.3653846153846' , '4' , '0' , '35.00' )
31/03/2023 05:20:57 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
( '81437' , '5458' , 'IO SONO CON VOI 2 PARTE' , '5' , '-5' , '4' ,
'2.3' , '2.3' , '0' , '0' , '11.50' )
31/03/2023 05:20:57 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
( '81437' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' ,
'3.3000' , '2.7049180327869' , '22' , '0' , '99.00' )
31/03/2023 05:21:14 pm >> SELECT document_num FROM ps_document
WHERE document_num = '660' AND id_document != '82054' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-28')
31/03/2023 05:21:14 pm >> UPDATE ps_document SET
id_document_type = '11',
document_num = '660',
document_date = '2023-02-28',
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 = '19.00',
price_tax_excluded = '19.00',
date_upd = NOW()
WHERE id_document = '82054'
31/03/2023 05:21:14 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82054'
31/03/2023 05:21:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '82054'
31/03/2023 05:21:14 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '82054' , '20592' , 'SULLA TUA PAROLA MAR/APR 23 - 515' , '2' , '-2' , '4' ,
'5.0000' , '5' , '0' , '5' , '9.50' )
31/03/2023 05:21:14 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '82054' , '3511' , 'DIO PARLA ALL\'UOMO' , '1' , '-1' , '4' ,
'9.5' , '9.5' , '0' , '0' , '9.50' )