22/02/2023 08:27:57 am >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'33' ,
'623644' ,
'2023-02-20' ,
'' ,
'0' ,
'7' ,
'2602' ,
'P. ZZA SAN PAOLO, 14 12051 ALBA' ,
'' ,
'' ,
'2.57' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'90.79' ,
'88.41' ,
NOW() ,
NOW() )
22/02/2023 08:27:57 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81450'
22/02/2023 08:27:57 am >> DELETE FROM ps_document_detail WHERE id_document = '81450'
22/02/2023 08:27:57 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '81450' , '20762' , 'ABBIAMO VISTO IL SIGNORE - CD' , '1' , '1' , '1' ,
'12.29' , '10.073770491803' , '22' , '30' , '10.4957' )
22/02/2023 08:27:57 am >> DELETE FROM ps_product_supplier WHERE id_product = '20762' AND id_supplier = '7'
22/02/2023 08:27:57 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20762' , '7' , '1' )
22/02/2023 08:27:57 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '81450' , '20763' , 'ABBIAMO VISTO IL SIGNORE - SPARTITO' , '1' , '1' , '3' ,
'17.3' , '16.634615384615' , '4' , '30' , '12.5944' )
22/02/2023 08:27:57 am >> DELETE FROM ps_product_supplier WHERE id_product = '20763' AND id_supplier = '7'
22/02/2023 08:27:57 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20763' , '7' , '1' )
22/02/2023 08:27:57 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '81450' , '14643' , 'ISAIA - G.DELLORTO' , '1' , '1' , '4' ,
'29.00' , '29' , '0' , '30' , '20.3000' )
22/02/2023 08:27:57 am >> DELETE FROM ps_product_supplier WHERE id_product = '14643' AND id_supplier = '7'
22/02/2023 08:27:57 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14643' , '7' , '1' )
22/02/2023 08:27:58 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '81450' , '12809' , 'SEDOTTI DALLA PAROLA - P. SCALABRINI' , '1' , '1' , '4' ,
'24.00' , '24' , '0' , '35' , '15.6000' )
22/02/2023 08:27:58 am >> DELETE FROM ps_product_supplier WHERE id_product = '12809' AND id_supplier = '7'
22/02/2023 08:27:58 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12809' , '7' , '1' )
22/02/2023 08:27:58 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '81450' , '13039' , 'LIBRO DEL BEBE - ROSA' , '1' , '1' , '4' ,
'8.50' , '8.5' , '0' , '35' , '5.5250' )
22/02/2023 08:27:58 am >> DELETE FROM ps_product_supplier WHERE id_product = '13039' AND id_supplier = '7'
22/02/2023 08:27:58 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13039' , '7' , '1' )
22/02/2023 08:27:58 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '81450' , '20237' , 'SIATE FELICI - PAPA FRANCESCO' , '1' , '1' , '4' ,
'17.00' , '17' , '0' , '30' , '11.9000' )
22/02/2023 08:27:58 am >> DELETE FROM ps_product_supplier WHERE id_product = '20237' AND id_supplier = '7'
22/02/2023 08:27:58 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20237' , '7' , '1' )
22/02/2023 08:27:58 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '81450' , '20751' , 'QUARESIMA OMELIE BENEDETTO XVI' , '1' , '1' , '4' ,
'15.00' , '15' , '0' , '30' , '10.5000' )
22/02/2023 08:27:58 am >> DELETE FROM ps_product_supplier WHERE id_product = '20751' AND id_supplier = '7'
22/02/2023 08:27:58 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20751' , '7' , '1' )
22/02/2023 08:27:58 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '81450' , '13882' , 'GAUDETE ET EXSULTATE' , '1' , '1' , '4' ,
'2.00' , '2' , '0' , '35' , '1.3000' )
22/02/2023 08:27:58 am >> DELETE FROM ps_product_supplier WHERE id_product = '13882' AND id_supplier = '7'
22/02/2023 08:27:58 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13882' , '7' , '1' )
22/02/2023 08:53:09 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801048827' AND id_product != '4535' AND ean13 != ''
22/02/2023 08:53:09 am >> UPDATE ps_product SET
id_supplier = '7',
reference = '2/3',
ean13 = '9788801048827',
date_upd = NOW()
WHERE id_product = '4535'
22/02/2023 08:53:09 am >> UPDATE ps_product_lang SET
name = 'GIOCA E COLORA - IO SONO II',
description = ''
WHERE id_product = '4535'
22/02/2023 08:53:09 am >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '4.0000'
WHERE id_product = '4535'
22/02/2023 08:53:09 am >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '4.0000',
id_tax_rules_group = '4',
id_category_default = '19',
id_argoment_default = '56',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '4535'
22/02/2023 08:53:09 am >> DELETE FROM ps_specific_price WHERE id_product = '4535'
22/02/2023 08:53:34 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788861080379' AND id_product != '14326' AND ean13 != ''
22/02/2023 08:53:34 am >> UPDATE ps_product SET
id_supplier = '107',
reference = '2/3',
ean13 = '9788861080379',
date_upd = NOW()
WHERE id_product = '14326'
22/02/2023 08:53:34 am >> UPDATE ps_product_lang SET
name = 'RELIGIOCANDO - GESU\' BAMBINO',
description = ''
WHERE id_product = '14326'
22/02/2023 08:53:34 am >> UPDATE ps_product SET
wholesale_price = '1.63',
on_sale = '0',
price = '2.5000'
WHERE id_product = '14326'
22/02/2023 08:53:34 am >> UPDATE ps_product_shop SET
wholesale_price = '1.63',
price = '2.5000',
id_tax_rules_group = '4',
id_category_default = '15',
id_argoment_default = '12',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '14326'
22/02/2023 08:53:34 am >> DELETE FROM ps_specific_price WHERE id_product = '14326'
22/02/2023 09:19:21 am >> SELECT document_num FROM ps_document
WHERE document_num = '21/A' AND id_document != '81297' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-02-09')
22/02/2023 09:19:21 am >> UPDATE ps_document SET
id_document_type = '24',
document_num = '21/A',
document_date = '2023-02-09',
document_letter = 'A',
id_customer = '204',
id_supplier = '',
id_address = '4671483',
address1 = 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO',
address2 = 'OSP. S. LEONARDO',
note = 'OSP. S. LEONARDO',
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 = '47.00',
price_tax_excluded = '42.13',
date_upd = NOW()
WHERE id_document = '81297'
22/02/2023 09:19: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 = '81297'
22/02/2023 09:19:21 am >> DELETE FROM ps_document_detail WHERE id_document = '81297'
22/02/2023 09:19: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
( '81297' , '13103' , 'BRACCIALE BAMBOO - CY B 774' , '10' , '-10' , '1' ,
'1.0000' , '0.81967213114754' , '22' , '0' , '10.00' )
22/02/2023 09:19: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
( '81297' , '' , '22/02' , '1' , '-1' , '0' ,
'0' , '0' , '' , '0' , '0' )
22/02/2023 09:19: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
( '81297' , '18223' , 'CORONA MISSIONARIA - R102' , '12' , '-12' , '1' ,
'1.00' , '0.81967213114754' , '22' , '0' , '12.00' )
22/02/2023 09:19: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
( '81297' , '20652' , 'VIA CRUCIS CON GLI SCRITTI DI C. LUBICH - PADRE G. VALSECCHI' , '10' , '-10' , '4' ,
'2.00' , '2' , '0' , '0' , '20.00' )
22/02/2023 09:19: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
( '81297' , '1331' , 'BRACCIALE LEGNO BICOLORE - 034CYB499' , '5' , '-5' , '1' ,
'1.00' , '0.81967213114754' , '22' , '0' , '5.00' )
22/02/2023 09:41:11 am >> UPDATE ps_product_shop SET
minimal_quantity = '1',
multiple_quantity = '1',
available_date = '',
date_upd = NOW()
WHERE id_product = '3975'
22/02/2023 09:41:11 am >> UPDATE ps_stock_available SET quantity = quantity + '-1' WHERE id_product = '3975'
22/02/2023 09:47:47 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788899571047' AND id_product != '14492' AND ean13 != ''
22/02/2023 09:47:47 am >> UPDATE ps_product SET
id_supplier = '127',
reference = 'ESPOSITORE',
ean13 = '9788899571047',
date_upd = NOW()
WHERE id_product = '14492'
22/02/2023 09:47:47 am >> UPDATE ps_product_lang SET
name = 'SACRAMENTI SPIEGATI AI RAGAZZI - BATTESIMO',
description = ''
WHERE id_product = '14492'
22/02/2023 09:47:47 am >> UPDATE ps_product SET
wholesale_price = '0.98',
on_sale = '0',
price = '1.5000'
WHERE id_product = '14492'
22/02/2023 09:47:47 am >> UPDATE ps_product_shop SET
wholesale_price = '0.98',
price = '1.5000',
id_tax_rules_group = '4',
id_category_default = '37',
id_argoment_default = '21',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '14492'
22/02/2023 09:47:47 am >> DELETE FROM ps_specific_price WHERE id_product = '14492'
22/02/2023 09:55:28 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788887688948' AND id_product != '15251' AND ean13 != ''
22/02/2023 09:55:28 am >> UPDATE ps_product SET
id_supplier = '127',
reference = '2/3',
ean13 = '9788887688948',
date_upd = NOW()
WHERE id_product = '15251'
22/02/2023 09:55:28 am >> UPDATE ps_product_lang SET
name = 'FATE QUESTO IN MEMORIA DI ME',
description = ''
WHERE id_product = '15251'
22/02/2023 09:55:28 am >> UPDATE ps_product SET
wholesale_price = '1.63',
on_sale = '0',
price = '2.5000'
WHERE id_product = '15251'
22/02/2023 09:55:28 am >> UPDATE ps_product_shop SET
wholesale_price = '1.63',
price = '2.5000',
id_tax_rules_group = '4',
id_category_default = '37',
id_argoment_default = '12',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '15251'
22/02/2023 09:55:28 am >> DELETE FROM ps_specific_price WHERE id_product = '15251'
22/02/2023 10:01:26 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801052305' AND id_product != '4253' AND ean13 != ''
22/02/2023 10:01:26 am >> UPDATE ps_product SET
id_supplier = '',
reference = '2/4',
ean13 = '9788801052305',
date_upd = NOW()
WHERE id_product = '4253'
22/02/2023 10:01:26 am >> UPDATE ps_product_lang SET
name = 'FORZA PIÙ GRANDE - GUGLIELMONI/NEGRI',
description = ''
WHERE id_product = '4253'
22/02/2023 10:01:26 am >> UPDATE ps_product SET
wholesale_price = '5.53',
on_sale = '0',
price = '8.5000'
WHERE id_product = '4253'
22/02/2023 10:01:26 am >> UPDATE ps_product_shop SET
wholesale_price = '5.53',
price = '8.5000',
id_tax_rules_group = '4',
id_category_default = '19',
id_argoment_default = '58',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '4253'
22/02/2023 10:01:26 am >> DELETE FROM ps_specific_price WHERE id_product = '4253'
22/02/2023 10:04:33 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8019118023742' AND id_product != '9844' AND ean13 != ''
22/02/2023 10:04:33 am >> UPDATE ps_product SET
id_supplier = '',
reference = '2/4',
ean13 = '8019118023742',
date_upd = NOW()
WHERE id_product = '9844'
22/02/2023 10:04:33 am >> UPDATE ps_product_lang SET
name = 'SEI L\'AMICO CHE PERDONA',
description = ''
WHERE id_product = '9844'
22/02/2023 10:04:33 am >> UPDATE ps_product SET
wholesale_price = '6.59',
on_sale = '0',
price = '9.4262'
WHERE id_product = '9844'
22/02/2023 10:04:33 am >> UPDATE ps_product_shop SET
wholesale_price = '6.59',
price = '9.4262',
id_tax_rules_group = '1',
id_category_default = '27',
id_argoment_default = '66',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '9844'
22/02/2023 10:04:33 am >> DELETE FROM ps_specific_price WHERE id_product = '9844'
22/02/2023 10:04:48 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788868944094' AND id_product != '19025' AND ean13 != ''
22/02/2023 10:04:48 am >> UPDATE ps_product SET
id_supplier = '7',
reference = '2/4',
ean13 = '9788868944094',
date_upd = NOW()
WHERE id_product = '19025'
22/02/2023 10:04:48 am >> UPDATE ps_product_lang SET
name = 'ORA ANDIAMO!',
description = ''
WHERE id_product = '19025'
22/02/2023 10:04:48 am >> UPDATE ps_product SET
wholesale_price = '5.60',
on_sale = '0',
price = '8.0000'
WHERE id_product = '19025'
22/02/2023 10:04:48 am >> UPDATE ps_product_shop SET
wholesale_price = '5.60',
price = '8.0000',
id_tax_rules_group = '4',
id_category_default = '103',
id_argoment_default = '244',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '19025'
22/02/2023 10:04:48 am >> DELETE FROM ps_specific_price WHERE id_product = '19025'
22/02/2023 10:05:00 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788868944629' AND id_product != '19026' AND ean13 != ''
22/02/2023 10:05:00 am >> UPDATE ps_product SET
id_supplier = '7',
reference = '2/4',
ean13 = '9788868944629',
date_upd = NOW()
WHERE id_product = '19026'
22/02/2023 10:05:00 am >> UPDATE ps_product_lang SET
name = 'BELLEZZA INVISIBILE AGLI OCCHI',
description = ''
WHERE id_product = '19026'
22/02/2023 10:05:00 am >> UPDATE ps_product SET
wholesale_price = '6.30',
on_sale = '0',
price = '9.0000'
WHERE id_product = '19026'
22/02/2023 10:05:00 am >> UPDATE ps_product_shop SET
wholesale_price = '6.30',
price = '9.0000',
id_tax_rules_group = '4',
id_category_default = '103',
id_argoment_default = '244',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '19026'
22/02/2023 10:05:00 am >> DELETE FROM ps_specific_price WHERE id_product = '19026'
22/02/2023 10:07:38 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801063158' AND id_product != '12625' AND ean13 != ''
22/02/2023 10:07:38 am >> UPDATE ps_product SET
id_supplier = '',
reference = '2/3',
ean13 = '9788801063158',
date_upd = NOW()
WHERE id_product = '12625'
22/02/2023 10:07:38 am >> UPDATE ps_product_lang SET
name = 'COLORIAMO LA NOSTRA MESSA',
description = ''
WHERE id_product = '12625'
22/02/2023 10:07:38 am >> UPDATE ps_product SET
wholesale_price = '2.54',
on_sale = '0',
price = '3.9000'
WHERE id_product = '12625'
22/02/2023 10:07:38 am >> UPDATE ps_product_shop SET
wholesale_price = '2.54',
price = '3.9000',
id_tax_rules_group = '4',
id_category_default = '19',
id_argoment_default = '25',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '12625'
22/02/2023 10:07:38 am >> DELETE FROM ps_specific_price WHERE id_product = '12625'
22/02/2023 10:08:12 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801049954' AND id_product != '5249' AND ean13 != ''
22/02/2023 10:08:12 am >> UPDATE ps_product SET
id_supplier = '7',
reference = '2/4',
ean13 = '9788801049954',
date_upd = NOW()
WHERE id_product = '5249'
22/02/2023 10:08:12 am >> UPDATE ps_product_lang SET
name = 'INCONTRI DI GIOIA - GUIDA',
description = ''
WHERE id_product = '5249'
22/02/2023 10:08:12 am >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '10.0000'
WHERE id_product = '5249'
22/02/2023 10:08:12 am >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '10.0000',
id_tax_rules_group = '4',
id_category_default = '19',
id_argoment_default = '56',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '5249'
22/02/2023 10:08:12 am >> DELETE FROM ps_specific_price WHERE id_product = '5249'
22/02/2023 10:37:18 am >> SELECT document_num FROM ps_document
WHERE document_num = '583' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-22')
22/02/2023 10:37: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 (
'11' ,
'583' ,
'2023-02-22' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'140.02' ,
'114.77' ,
NOW() ,
NOW() )
22/02/2023 10:37: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 = '81451'
22/02/2023 10:37:18 am >> DELETE FROM ps_document_detail WHERE id_document = '81451'
22/02/2023 10:37: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
( '81451' , '14020' , 'BALZA CON RICAMO IN ORO' , '3.3' , '-3.3' , '1' ,
'42.43' , '34.77868852459' , '22' , '0' , '140.02' )
22/02/2023 10:54:05 am >> SELECT document_num FROM ps_document
WHERE document_num = '584' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-22')
22/02/2023 10:54:05 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' ,
'584' ,
'2023-02-22' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'4.75' ,
'4.75' ,
NOW() ,
NOW() )
22/02/2023 10:54:05 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 = '81452'
22/02/2023 10:54:05 am >> DELETE FROM ps_document_detail WHERE id_document = '81452'
22/02/2023 10:54:05 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
( '81452' , '20592' , 'SULLA TUA PAROLA MAR/APR 23 - 515' , '1' , '-1' , '4' ,
'5.00' , '5' , '0' , '5' , '4.75' )
22/02/2023 10:57:59 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801058345' AND id_product != '4850' AND ean13 != ''
22/02/2023 10:58:00 am >> UPDATE ps_product SET
id_supplier = '7',
reference = '5/5',
ean13 = '9788801058345',
date_upd = NOW()
WHERE id_product = '4850'
22/02/2023 10:58:00 am >> UPDATE ps_product_lang SET
name = 'ICEBERG E LA DUNA - B. FERRERO',
description = ''
WHERE id_product = '4850'
22/02/2023 10:58:00 am >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '5.0000'
WHERE id_product = '4850'
22/02/2023 10:58:00 am >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '5.0000',
id_tax_rules_group = '4',
id_category_default = '19',
id_argoment_default = '23',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '4850'
22/02/2023 10:58:00 am >> DELETE FROM ps_specific_price WHERE id_product = '4850'
22/02/2023 10:58:48 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788869295652' AND id_product != '17597' AND ean13 != ''
22/02/2023 10:58:48 am >> UPDATE ps_product SET
id_supplier = '109',
reference = '1/5',
ean13 = '9788869295652',
date_upd = NOW()
WHERE id_product = '17597'
22/02/2023 10:58:48 am >> UPDATE ps_product_lang SET
name = 'SALMI NEL CANTO DELL\'AMORE - SPARTITO',
description = ''
WHERE id_product = '17597'
22/02/2023 10:58:48 am >> UPDATE ps_product SET
wholesale_price = '6.50',
on_sale = '0',
price = '10.0000'
WHERE id_product = '17597'
22/02/2023 10:58:48 am >> UPDATE ps_product_shop SET
wholesale_price = '6.50',
price = '10.0000',
id_tax_rules_group = '4',
id_category_default = '45',
id_argoment_default = '66',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '17597'
22/02/2023 10:58:48 am >> DELETE FROM ps_specific_price WHERE id_product = '17597'
22/02/2023 10:59:12 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788869298776' AND id_product != '20489' AND ean13 != ''
22/02/2023 10:59:12 am >> UPDATE ps_product SET
id_supplier = '109',
reference = '1/5',
ean13 = '9788869298776',
date_upd = NOW()
WHERE id_product = '20489'
22/02/2023 10:59:12 am >> UPDATE ps_product_lang SET
name = 'SALMI NEL CANTO L\'AMORE - M. VERSACI',
description = ''
WHERE id_product = '20489'
22/02/2023 10:59:12 am >> UPDATE ps_product SET
wholesale_price = '9.10',
on_sale = '0',
price = '14.0000'
WHERE id_product = '20489'
22/02/2023 10:59:12 am >> UPDATE ps_product_shop SET
wholesale_price = '9.10',
price = '14.0000',
id_tax_rules_group = '4',
id_category_default = '45',
id_argoment_default = '66',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '20489'
22/02/2023 10:59:12 am >> DELETE FROM ps_specific_price WHERE id_product = '20489'
22/02/2023 10:59:22 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788869298776' AND id_product != '20489' AND ean13 != ''
22/02/2023 10:59:22 am >> UPDATE ps_product SET
id_supplier = '109',
reference = '1/5',
ean13 = '9788869298776',
date_upd = NOW()
WHERE id_product = '20489'
22/02/2023 10:59:22 am >> UPDATE ps_product_lang SET
name = 'SALMI NEL CANTO L\'AMORE - M. VERSACI',
description = ''
WHERE id_product = '20489'
22/02/2023 10:59:22 am >> UPDATE ps_product SET
wholesale_price = '9.10',
on_sale = '0',
price = '14.0000'
WHERE id_product = '20489'
22/02/2023 10:59:22 am >> UPDATE ps_product_shop SET
wholesale_price = '9.10',
price = '14.0000',
id_tax_rules_group = '4',
id_category_default = '45',
id_argoment_default = '66',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '20489'
22/02/2023 10:59:22 am >> DELETE FROM ps_specific_price WHERE id_product = '20489'
22/02/2023 11:00:06 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788895983929' AND id_product != '18718' AND ean13 != ''
22/02/2023 11:00:06 am >> UPDATE ps_product SET
id_supplier = '53',
reference = '1/5',
ean13 = '9788895983929',
date_upd = NOW()
WHERE id_product = '18718'
22/02/2023 11:00:06 am >> UPDATE ps_product_lang SET
name = 'TUA VOCE IN ME + CD - FRA F. MARIA REA',
description = ''
WHERE id_product = '18718'
22/02/2023 11:00:06 am >> UPDATE ps_product SET
wholesale_price = '3.60',
on_sale = '0',
price = '15.0000'
WHERE id_product = '18718'
22/02/2023 11:00:06 am >> UPDATE ps_product_shop SET
wholesale_price = '3.60',
price = '15.0000',
id_tax_rules_group = '4',
id_category_default = '395',
id_argoment_default = '66',
id_internal_category = '4',
on_sale = '0',
on_showcase = '1',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '18718'
22/02/2023 11:00:06 am >> DELETE FROM ps_specific_price WHERE id_product = '18718'
22/02/2023 11:00:06 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' , '18718' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' )
22/02/2023 11:01:04 am >> UPDATE ps_product_shop SET
minimal_quantity = '1',
multiple_quantity = '1',
available_date = '',
date_upd = NOW()
WHERE id_product = '990'
22/02/2023 11:01:04 am >> UPDATE ps_stock_available SET quantity = quantity + '-1' WHERE id_product = '990'
22/02/2023 11:02:08 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791280736062' AND id_product != '19562' AND ean13 != ''
22/02/2023 11:02:08 am >> UPDATE ps_product SET
id_supplier = '53',
reference = 'GONDOLA 1',
ean13 = '9791280736062',
date_upd = NOW()
WHERE id_product = '19562'
22/02/2023 11:02:08 am >> UPDATE ps_product_lang SET
name = 'SAN CESARE DE BUS. UNA VITA PER LA CATECHESI ',
description = '
\"Dalla testimonianza di Cesare de Bus Paolo VI ricavò i tratti essenziali del vero catechista: essere l\'uomo della Bibbia e l\'uomo della Chiesa, ansioso di trasmettere la vera dottrina di Cristo. Sullo stile e sul metodo particolare di fare catechesi di san Cesare de Bus in questo libro ci si sofferma doverosamente, nel quadro generale della sua figura e del suo tempo, nonché del suo cammino spirituale. Questo libro ci aiuta a conoscerlo e ad amarlo e c\'incoraggia a imitarlo.\" Marcello Card. Semeraro
'
WHERE id_product = '19562'
22/02/2023 11:02:08 am >> UPDATE ps_product SET
wholesale_price = '2.67',
on_sale = '0',
price = '20.0000'
WHERE id_product = '19562'
22/02/2023 11:02:08 am >> UPDATE ps_product_shop SET
wholesale_price = '2.67',
price = '20.0000',
id_tax_rules_group = '4',
id_category_default = '395',
id_argoment_default = '226',
id_internal_category = '4',
on_sale = '0',
on_showcase = '1',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '19562'
22/02/2023 11:02:08 am >> DELETE FROM ps_specific_price WHERE id_product = '19562'
22/02/2023 11:02:08 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' , '19562' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' )
22/02/2023 11:02:17 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791280736062' AND id_product != '19562' AND ean13 != ''
22/02/2023 11:02:17 am >> UPDATE ps_product SET
id_supplier = '53',
reference = 'GONDOLA 1',
ean13 = '9791280736062',
date_upd = NOW()
WHERE id_product = '19562'
22/02/2023 11:02:17 am >> UPDATE ps_product_lang SET
name = 'SAN CESARE DE BUS. UNA VITA PER LA CATECHESI ',
description = '\"Dalla testimonianza di Cesare de Bus Paolo VI ricavò i tratti essenziali del vero catechista: essere l\'uomo della Bibbia e l\'uomo della Chiesa, ansioso di trasmettere la vera dottrina di Cristo. Sullo stile e sul metodo particolare di fare catechesi di san Cesare de Bus in questo libro ci si sofferma doverosamente, nel quadro generale della sua figura e del suo tempo, nonché del suo cammino spirituale. Questo libro ci aiuta a conoscerlo e ad amarlo e c\'incoraggia a imitarlo.\" Marcello Card. Semeraro
'
WHERE id_product = '19562'
22/02/2023 11:02:17 am >> UPDATE ps_product SET
wholesale_price = '2.67',
on_sale = '0',
price = '20.0000'
WHERE id_product = '19562'
22/02/2023 11:02:17 am >> UPDATE ps_product_shop SET
wholesale_price = '2.67',
price = '20.0000',
id_tax_rules_group = '4',
id_category_default = '395',
id_argoment_default = '226',
id_internal_category = '4',
on_sale = '0',
on_showcase = '1',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '19562'
22/02/2023 11:02:17 am >> DELETE FROM ps_specific_price WHERE id_product = '19562'
22/02/2023 11:02:17 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' , '19562' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' )
22/02/2023 11:07:38 am >> SELECT document_num FROM ps_document
WHERE document_num = '585' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-22')
22/02/2023 11:07:38 am >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'585' ,
'2023-02-22' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'90.00' ,
'86.54' ,
NOW() ,
NOW() )
22/02/2023 11:07: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 = '81453'
22/02/2023 11:07:38 am >> DELETE FROM ps_document_detail WHERE id_document = '81453'
22/02/2023 11:07: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
( '81453' , '16689' , 'OSTIA PAN DI CENA mm80' , '10' , '-10' , '3' ,
'2.00' , '1.9230769230769' , '4' , '0' , '20.00' )
22/02/2023 11:07: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
( '81453' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '20' , '-20' , '3' ,
'3.50' , '3.3653846153846' , '4' , '0' , '70.00' )
22/02/2023 11:09:11 am >> SELECT document_num FROM ps_document
WHERE document_num = '586' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-22')
22/02/2023 11:09:11 am >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'586' ,
'2023-02-22' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'9.00' ,
'7.38' ,
NOW() ,
NOW() )
22/02/2023 11:09:11 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81454'
22/02/2023 11:09:11 am >> DELETE FROM ps_document_detail WHERE id_document = '81454'
22/02/2023 11:09:11 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '81454' , '6809' , 'MOCCOLO 60X165' , '2' , '-2' , '1' ,
'4.50' , '3.6885245901639' , '22' , '0' , '9.00' )
22/02/2023 11:19:08 am >> SELECT document_num FROM ps_document
WHERE document_num = '587' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-22')
22/02/2023 11:19:08 am >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'587' ,
'2023-02-22' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'14.00' ,
'13.63' ,
NOW() ,
NOW() )
22/02/2023 11:19:08 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81455'
22/02/2023 11:19:08 am >> DELETE FROM ps_document_detail WHERE id_document = '81455'
22/02/2023 11:19:08 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '81455' , '7311' , 'OSTIA SOTTILE 74MM' , '5' , '-5' , '3' ,
'1.90' , '1.8269230769231' , '4' , '0' , '9.50' )
22/02/2023 11:19:08 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '81455' , '6962' , 'NELLA CASA DEL DEFUNTO' , '3' , '-3' , '4' ,
'1.50' , '1.5' , '0' , '0' , '4.50' )
22/02/2023 11:25:51 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801066630' AND id_product != '17632' AND ean13 != ''
22/02/2023 11:25:51 am >> UPDATE ps_product SET
id_supplier = '7',
reference = '5/5',
ean13 = '9788801066630',
date_upd = NOW()
WHERE id_product = '17632'
22/02/2023 11:25:51 am >> UPDATE ps_product_lang SET
name = 'FUORI DAL CORO - P. PELLEGRINO',
description = ''
WHERE id_product = '17632'
22/02/2023 11:25:51 am >> UPDATE ps_product SET
wholesale_price = '2.60',
on_sale = '0',
price = '4.0000'
WHERE id_product = '17632'
22/02/2023 11:25:51 am >> UPDATE ps_product_shop SET
wholesale_price = '2.60',
price = '4.0000',
id_tax_rules_group = '4',
id_category_default = '19',
id_argoment_default = '10',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '17632'
22/02/2023 11:25:51 am >> DELETE FROM ps_specific_price WHERE id_product = '17632'
22/02/2023 11:26:15 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801066630' AND id_product != '17632' AND ean13 != ''
22/02/2023 11:26:15 am >> UPDATE ps_product SET
id_supplier = '7',
reference = '5/5',
ean13 = '9788801066630',
date_upd = NOW()
WHERE id_product = '17632'
22/02/2023 11:26:15 am >> UPDATE ps_product_lang SET
name = 'FUORI DAL CORO - P. PELLEGRINO',
description = ''
WHERE id_product = '17632'
22/02/2023 11:26:15 am >> UPDATE ps_product SET
wholesale_price = '2.60',
on_sale = '0',
price = '4.0000'
WHERE id_product = '17632'
22/02/2023 11:26:15 am >> UPDATE ps_product_shop SET
wholesale_price = '2.60',
price = '4.0000',
id_tax_rules_group = '4',
id_category_default = '19',
id_argoment_default = '10',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '17632'
22/02/2023 11:26:15 am >> DELETE FROM ps_specific_price WHERE id_product = '17632'
22/02/2023 11:26:32 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788882275365' AND id_product != '16530' AND ean13 != ''
22/02/2023 11:26:32 am >> UPDATE ps_product SET
id_supplier = '7',
reference = '1/5',
ean13 = '9788882275365',
date_upd = NOW()
WHERE id_product = '16530'
22/02/2023 11:26:32 am >> UPDATE ps_product_lang SET
name = 'MESSA DI BOSE',
description = ''
WHERE id_product = '16530'
22/02/2023 11:26:32 am >> UPDATE ps_product SET
wholesale_price = '7.00',
on_sale = '0',
price = '10.0000'
WHERE id_product = '16530'
22/02/2023 11:26:32 am >> UPDATE ps_product_shop SET
wholesale_price = '7.00',
price = '10.0000',
id_tax_rules_group = '4',
id_category_default = '248',
id_argoment_default = '66',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '16530'
22/02/2023 11:26:32 am >> DELETE FROM ps_specific_price WHERE id_product = '16530'
22/02/2023 11:26:43 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788882275365' AND id_product != '16530' AND ean13 != ''
22/02/2023 11:26:43 am >> UPDATE ps_product SET
id_supplier = '7',
reference = '1/5',
ean13 = '9788882275365',
date_upd = NOW()
WHERE id_product = '16530'
22/02/2023 11:26:43 am >> UPDATE ps_product_lang SET
name = 'MESSA DI BOSE',
description = ''
WHERE id_product = '16530'
22/02/2023 11:26:43 am >> UPDATE ps_product SET
wholesale_price = '7.00',
on_sale = '0',
price = '10.0000'
WHERE id_product = '16530'
22/02/2023 11:26:43 am >> UPDATE ps_product_shop SET
wholesale_price = '7.00',
price = '10.0000',
id_tax_rules_group = '4',
id_category_default = '248',
id_argoment_default = '66',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '16530'
22/02/2023 11:26:43 am >> DELETE FROM ps_specific_price WHERE id_product = '16530'
22/02/2023 11:49:43 am >> SELECT document_num FROM ps_document
WHERE document_num = '588' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-22')
22/02/2023 11:49:43 am >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'588' ,
'2023-02-22' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'28.50' ,
'28.50' ,
NOW() ,
NOW() )
22/02/2023 11:49:43 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81456'
22/02/2023 11:49:43 am >> DELETE FROM ps_document_detail WHERE id_document = '81456'
22/02/2023 11:49:43 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '81456' , '20592' , 'SULLA TUA PAROLA MAR/APR 23 - 515' , '6' , '-6' , '4' ,
'5.00' , '5' , '0' , '5' , '28.50' )
22/02/2023 11:54:09 am >> SELECT document_num FROM ps_document
WHERE document_num = '589' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-22')
22/02/2023 11:54:09 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' ,
'589' ,
'2023-02-22' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'42.75' ,
'42.75' ,
NOW() ,
NOW() )
22/02/2023 11:54:09 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 = '81457'
22/02/2023 11:54:09 am >> DELETE FROM ps_document_detail WHERE id_document = '81457'
22/02/2023 11:54:09 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
( '81457' , '11151' , 'LIBRI' , '1' , '-1' , '4' ,
'45' , '45' , '0' , '5' , '42.75' )
22/02/2023 11:57:11 am >> SELECT document_num FROM ps_document
WHERE document_num = '590' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-22')
22/02/2023 11:57:11 am >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'590' ,
'2023-02-22' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'9.50' ,
'9.50' ,
NOW() ,
NOW() )
22/02/2023 11:57:11 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81458'
22/02/2023 11:57:11 am >> DELETE FROM ps_document_detail WHERE id_document = '81458'
22/02/2023 11:57:11 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '81458' , '20592' , 'SULLA TUA PAROLA MAR/APR 23 - 515' , '2' , '-2' , '4' ,
'5.00' , '5' , '0' , '5' , '9.50' )
22/02/2023 12:27:13 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788810820650' AND id_product != '1146' AND ean13 != ''
22/02/2023 12:27:13 pm >> UPDATE ps_product SET
id_supplier = '109',
reference = '11/1',
ean13 = '9788810820650',
date_upd = NOW()
WHERE id_product = '1146'
22/02/2023 12:27:13 pm >> UPDATE ps_product_lang SET
name = 'BIBBIA DI GERUSALEMME X OCCASIONI ',
description = ''
WHERE id_product = '1146'
22/02/2023 12:27:13 pm >> UPDATE ps_product SET
wholesale_price = '24.64',
on_sale = '0',
price = '45'
WHERE id_product = '1146'
22/02/2023 12:27:13 pm >> UPDATE ps_product_shop SET
wholesale_price = '24.64',
price = '45',
id_tax_rules_group = '4',
id_category_default = '9',
id_argoment_default = '170',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '1146'
22/02/2023 12:27:13 pm >> DELETE FROM ps_specific_price WHERE id_product = '1146'
22/02/2023 12:27:36 pm >> SELECT document_num FROM ps_document
WHERE document_num = '589' AND id_document != '81457' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-22')
22/02/2023 12:27:36 pm >> UPDATE ps_document SET
id_document_type = '11',
document_num = '589',
document_date = '2023-02-22',
document_letter = '',
id_customer = '0',
id_supplier = '',
id_address = '0',
address1 = '',
address2 = '',
note = '',
price_shipping = '0.00',
id_tax_shipping_rules = '4',
colli = '0',
peso = '0',
porto_e_imballo = '0',
mezzo_consegna = '',
id_payment = '0',
id_causal = '0',
price_tax_included = '42.75',
price_tax_excluded = '42.75',
date_upd = NOW()
WHERE id_document = '81457'
22/02/2023 12:27:36 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81457'
22/02/2023 12:27:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '81457'
22/02/2023 12:27:36 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '81457' , '1146' , 'BIBBIA DI GERUSALEMME X OCCASIONI ' , '1' , '-1' , '4' ,
'45.00' , '45' , '0' , '5' , '42.75' )
22/02/2023 12:36:07 pm >> SELECT document_num FROM ps_document
WHERE document_num = '591' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-22')
22/02/2023 12:36:07 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' ,
'591' ,
'2023-02-22' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'4.50' ,
'4.50' ,
NOW() ,
NOW() )
22/02/2023 12:36:07 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 = '81459'
22/02/2023 12:36:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '81459'
22/02/2023 12:36:07 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
( '81459' , '11151' , 'LIBRI' , '1' , '-1' , '4' ,
'4.5' , '4.5' , '0' , '0' , '4.50' )
22/02/2023 12:55:30 pm >> SELECT document_num FROM ps_document
WHERE document_num = '592' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-22')
22/02/2023 12:55:30 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' ,
'592' ,
'2023-02-22' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'4.75' ,
'4.75' ,
NOW() ,
NOW() )
22/02/2023 12:55:30 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 = '81460'
22/02/2023 12:55:30 pm >> DELETE FROM ps_document_detail WHERE id_document = '81460'
22/02/2023 12:55:30 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
( '81460' , '20592' , 'SULLA TUA PAROLA MAR/APR 23 - 515' , '1' , '-1' , '4' ,
'5.00' , '5' , '0' , '5' , '4.75' )
22/02/2023 02:32:15 pm >> SELECT document_num FROM ps_document
WHERE document_num = '586' AND id_document != '81454' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-22')
22/02/2023 02:32:15 pm >> UPDATE ps_document SET
id_document_type = '11',
document_num = '586',
document_date = '2023-02-22',
document_letter = '',
id_customer = '0',
id_supplier = '',
id_address = '0',
address1 = '',
address2 = '',
note = '',
price_shipping = '0.00',
id_tax_shipping_rules = '4',
colli = '0',
peso = '0',
porto_e_imballo = '0',
mezzo_consegna = '',
id_payment = '0',
id_causal = '0',
price_tax_included = '9.00',
price_tax_excluded = '7.38',
date_upd = NOW()
WHERE id_document = '81454'
22/02/2023 02:32:15 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 = '81454'
22/02/2023 02:32:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '81454'
22/02/2023 02:32:15 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
( '81454' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' ,
'9' , '7.3770491803279' , '22' , '0' , '9.00' )
22/02/2023 03:57:49 pm >> SELECT document_num FROM ps_document
WHERE document_num = '593' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-22')
22/02/2023 03:57:49 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' ,
'593' ,
'2023-02-22' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'13.40' ,
'13.40' ,
NOW() ,
NOW() )
22/02/2023 03:57:49 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 = '81461'
22/02/2023 03:57:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '81461'
22/02/2023 03:57:49 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
( '81461' , '20592' , 'SULLA TUA PAROLA MAR/APR 23 - 515' , '2' , '-2' , '4' ,
'5.00' , '5' , '0' , '5' , '9.50' )
22/02/2023 03:57:49 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
( '81461' , '20660' , 'QUARESIMA E PASQUA ' , '1' , '-1' , '4' ,
'2.90' , '2.9' , '0' , '0' , '2.90' )
22/02/2023 03:57:49 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
( '81461' , '20774' , 'messaggio per la quaresima 2023' , '1' , '-1' , '4' ,
'1.00' , '1' , '0' , '0' , '1.00' )
22/02/2023 04:27:43 pm >> SELECT document_num FROM ps_document
WHERE document_num = '594' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-22')
22/02/2023 04:27:43 pm >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'594' ,
'2023-02-22' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'80.00' ,
'65.57' ,
NOW() ,
NOW() )
22/02/2023 04:27:43 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81462'
22/02/2023 04:27:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '81462'
22/02/2023 04:27:43 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '81462' , '12527' , 'LAMPADA A SFERA VIOLA' , '2' , '-2' , '1' ,
'25.00' , '20.491803278689' , '22' , '0' , '50.00' )
22/02/2023 04:27:43 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '81462' , '19107' , 'INCENSO GRANI 3A' , '1' , '-1' , '1' ,
'30.00' , '24.590163934426' , '22' , '0' , '30.00' )
22/02/2023 05:58:23 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788826608037' AND id_product != '20774' AND ean13 != ''
22/02/2023 05:58:23 pm >> UPDATE ps_product SET
id_supplier = '79',
reference = '',
ean13 = '9788826608037',
date_upd = NOW()
WHERE id_product = '20774'
22/02/2023 05:58:23 pm >> UPDATE ps_product_lang SET
name = 'MESSAGGIO PER LA QUARESIMA 2023',
description = ''
WHERE id_product = '20774'
22/02/2023 05:58:23 pm >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '1.0000'
WHERE id_product = '20774'
22/02/2023 05:58:23 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '1.0000',
id_tax_rules_group = '4',
id_category_default = '104',
id_argoment_default = '50',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '20774'
22/02/2023 05:58:23 pm >> DELETE FROM ps_specific_price WHERE id_product = '20774'
22/02/2023 06:49:20 pm >> SELECT document_num FROM ps_document
WHERE document_num = '595' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-22')
22/02/2023 06:49:20 pm >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'595' ,
'2023-02-22' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'16.41' ,
'16.35' ,
NOW() ,
NOW() )
22/02/2023 06:49:20 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81463'
22/02/2023 06:49:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '81463'
22/02/2023 06:49:20 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '81463' , '20494' , 'TI VOGLIO FELICE - PAPA FRANCESCO' , '1' , '-1' , '4' ,
'16.90' , '16.9' , '0' , '5' , '16.06' )
22/02/2023 06:49:20 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '81463' , '17748' , 'SEGNALIBRO - PR 349' , '1' , '-1' , '1' ,
'0.35' , '0.28688524590164' , '22' , '0' , '0.35' )