08/02/2023 09:24:31 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791259751300' AND id_product != '19512' AND ean13 != ''
08/02/2023 09:24:31 am >> UPDATE ps_product SET
id_supplier = '7',
reference = '6/5',
ean13 = '9791259751300',
date_upd = NOW()
WHERE id_product = '19512'
08/02/2023 09:24:31 am >> UPDATE ps_product_lang SET
name = 'SGUARDO DI GESU - F. CRISTOFARO',
description = ''
WHERE id_product = '19512'
08/02/2023 09:24:31 am >> UPDATE ps_product SET
wholesale_price = '11.20',
on_sale = '0',
price = '16.0000'
WHERE id_product = '19512'
08/02/2023 09:24:31 am >> UPDATE ps_product_shop SET
wholesale_price = '11.20',
price = '16.0000',
id_tax_rules_group = '4',
id_category_default = '267',
id_argoment_default = '23',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '19512'
08/02/2023 09:24:31 am >> DELETE FROM ps_specific_price WHERE id_product = '19512'
08/02/2023 09:29:54 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788832713619' AND id_product != '20244' AND ean13 != ''
08/02/2023 09:29:54 am >> UPDATE ps_product SET
id_supplier = '109',
reference = '6/5',
ean13 = '9788832713619',
date_upd = NOW()
WHERE id_product = '20244'
08/02/2023 09:29:54 am >> UPDATE ps_product_lang SET
name = 'PERCHE\' MI CERCHI? - S. MISCIO',
description = ''
WHERE id_product = '20244'
08/02/2023 09:29:54 am >> UPDATE ps_product SET
wholesale_price = '7.80',
on_sale = '0',
price = '12.0000'
WHERE id_product = '20244'
08/02/2023 09:29:54 am >> UPDATE ps_product_shop SET
wholesale_price = '7.80',
price = '12.0000',
id_tax_rules_group = '4',
id_category_default = '80',
id_argoment_default = '41',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '20244'
08/02/2023 09:29:54 am >> DELETE FROM ps_specific_price WHERE id_product = '20244'
08/02/2023 09:48:58 am >> SELECT document_num FROM ps_document
WHERE document_num = '449' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-08')
08/02/2023 09:48:58 am >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'449' ,
'2023-02-08' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'89.85' ,
'80.92' ,
NOW() ,
NOW() )
08/02/2023 09:48:58 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81274'
08/02/2023 09:48:58 am >> DELETE FROM ps_document_detail WHERE id_document = '81274'
08/02/2023 09:48: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
( '81274' , '5976' , 'LUCERNA VETRO - 1493' , '2' , '-2' , '1' ,
'19.50' , '15.983606557377' , '22' , '0' , '39.00' )
08/02/2023 09:48: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
( '81274' , '19727' , 'LITURGIA IN FRAMMENTI - A. SORRENTINO' , '1' , '-1' , '4' ,
'35.00' , '35' , '0' , '0' , '35.00' )
08/02/2023 09:48: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
( '81274' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '2' , '-2' , '4' ,
'1.00' , '1' , '0' , '0' , '2.00' )
08/02/2023 09:48: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
( '81274' , '20671' , 'QUARESIMA 2023' , '1' , '-1' , '4' ,
'3.35' , '3.35' , '0' , '0' , '3.35' )
08/02/2023 09:48: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
( '81274' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' ,
'9.5' , '7.7868852459016' , '22' , '0' , '9.50' )
08/02/2023 09:48: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
( '81274' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '1' , '-1' , '1' ,
'1' , '0.81967213114754' , '22' , '0' , '1.00' )
08/02/2023 09:49:40 am >> SELECT document_num FROM ps_document
WHERE document_num = '449' AND id_document != '81274' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-08')
08/02/2023 09:49:40 am >> UPDATE ps_document SET
id_document_type = '11',
document_num = '449',
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 = '89.85',
price_tax_excluded = '80.92',
date_upd = NOW()
WHERE id_document = '81274'
08/02/2023 09:49:40 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81274'
08/02/2023 09:49:40 am >> DELETE FROM ps_document_detail WHERE id_document = '81274'
08/02/2023 09:49:40 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '81274' , '5976' , 'LUCERNA VETRO - 1493' , '2' , '-2' , '1' ,
'19.5000' , '15.983606557377' , '22' , '0' , '39.00' )
08/02/2023 09:49:40 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '81274' , '19727' , 'LITURGIA IN FRAMMENTI - A. SORRENTINO' , '1' , '-1' , '4' ,
'35.0000' , '35' , '0' , '0' , '35.00' )
08/02/2023 09:49:40 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '81274' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '2' , '-2' , '4' ,
'1.0000' , '1' , '0' , '0' , '2.00' )
08/02/2023 09:49:40 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '81274' , '20671' , 'QUARESIMA 2023' , '1' , '-1' , '4' ,
'3.3500' , '3.35' , '0' , '0' , '3.35' )
08/02/2023 09:49:40 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '81274' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' ,
'9.5000' , '7.7868852459016' , '22' , '0' , '9.50' )
08/02/2023 09:49:40 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '81274' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '1' , '-1' , '1' ,
'1.0000' , '0.81967213114754' , '22' , '0' , '1.00' )
08/02/2023 09:49:55 am >> SELECT document_num FROM ps_document
WHERE document_num = '449' AND id_document != '81274' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-08')
08/02/2023 09:49:55 am >> UPDATE ps_document SET
id_document_type = '11',
document_num = '449',
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 = '89.85',
price_tax_excluded = '80.92',
date_upd = NOW()
WHERE id_document = '81274'
08/02/2023 09:49:55 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 = '81274'
08/02/2023 09:49:55 am >> DELETE FROM ps_document_detail WHERE id_document = '81274'
08/02/2023 09:49:55 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
( '81274' , '5976' , 'LUCERNA VETRO - 1493' , '2' , '-2' , '1' ,
'19.5000' , '15.983606557377' , '22' , '0' , '39.00' )
08/02/2023 09:49:55 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
( '81274' , '19727' , 'LITURGIA IN FRAMMENTI - A. SORRENTINO' , '1' , '-1' , '4' ,
'35.0000' , '35' , '0' , '0' , '35.00' )
08/02/2023 09:49:55 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
( '81274' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '2' , '-2' , '4' ,
'1.0000' , '1' , '0' , '0' , '2.00' )
08/02/2023 09:49:56 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
( '81274' , '20671' , 'QUARESIMA 2023' , '1' , '-1' , '4' ,
'3.3500' , '3.35' , '0' , '0' , '3.35' )
08/02/2023 09:49:56 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
( '81274' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' ,
'9.5000' , '7.7868852459016' , '22' , '0' , '9.50' )
08/02/2023 09:49:56 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
( '81274' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '1' , '-1' , '1' ,
'1.0000' , '0.81967213114754' , '22' , '0' , '1.00' )
08/02/2023 10:00:57 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884042163' AND id_product != '4699' AND ean13 != ''
08/02/2023 10:00:57 am >> UPDATE ps_product SET
id_supplier = '38',
reference = 'ESPOSITORE SHALOM',
ean13 = '9788884042163',
date_upd = NOW()
WHERE id_product = '4699'
08/02/2023 10:00:57 am >> UPDATE ps_product_lang SET
name = 'GLORIE DI MARIA - 8243',
description = ''
WHERE id_product = '4699'
08/02/2023 10:00:57 am >> UPDATE ps_product SET
wholesale_price = '6.00',
on_sale = '0',
price = '12'
WHERE id_product = '4699'
08/02/2023 10:00:57 am >> UPDATE ps_product_shop SET
wholesale_price = '6.00',
price = '12',
id_tax_rules_group = '4',
id_category_default = '106',
id_argoment_default = '28',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '4699'
08/02/2023 10:00:57 am >> DELETE FROM ps_specific_price WHERE id_product = '4699'
08/02/2023 10:38:51 am >> SELECT document_num FROM ps_document
WHERE document_num = '450' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2023-02-08')
08/02/2023 10:38:51 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' ,
'450' ,
'2023-02-08' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'14.00' ,
'11.48' ,
NOW() ,
NOW() )
08/02/2023 10:38:51 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81275'
08/02/2023 10:38:51 am >> DELETE FROM ps_document_detail WHERE id_document = '81275'
08/02/2023 10:38: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
( '81275' , '18661' , 'MANO IN METALLO - 1803MET' , '1' , '-1' , '1' ,
'14.00' , '11.475409836066' , '22' , '0' , '14.00' )
08/02/2023 10:49:41 am >> SELECT document_num FROM ps_document
WHERE document_num = '451' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-08')
08/02/2023 10:49: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' ,
'451' ,
'2023-02-08' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'119.95' ,
'117.79' ,
NOW() ,
NOW() )
08/02/2023 10:49: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 = '81276'
08/02/2023 10:49:41 am >> DELETE FROM ps_document_detail WHERE id_document = '81276'
08/02/2023 10:49: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
( '81276' , '20250' , 'PREGA MANGIA AMA - L. EPICOCO' , '1' , '-1' , '4' ,
'16.00' , '16' , '0' , '5' , '15.20' )
08/02/2023 10:49: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
( '81276' , '13438' , 'GIOVANNI IL DISCEPOLO AMATO - A TU PER TU CON LAMORE' , '2' , '-2' , '4' ,
'4.50' , '4.5' , '0' , '5' , '8.56' )
08/02/2023 10:49: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
( '81276' , '20033' , 'CAMMINO DEL DESIDERIO - G. PICCOLO' , '1' , '-1' , '4' ,
'16.00' , '16' , '0' , '5' , '15.20' )
08/02/2023 10:49: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
( '81276' , '13896' , 'RISANARE LE FERITE DELLANIMA - A. GRUN' , '1' , '-1' , '4' ,
'18.00' , '18' , '0' , '5' , '17.10' )
08/02/2023 10:49: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
( '81276' , '20494' , 'TI VOGLIO FELICE - PAPA FRANCESCO' , '1' , '-1' , '4' ,
'16.90' , '16.9' , '0' , '5' , '16.06' )
08/02/2023 10:49: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
( '81276' , '14000' , 'GALATEO IN CHIESA' , '1' , '-1' , '4' ,
'1.00' , '1' , '0' , '0' , '1.00' )
08/02/2023 10:49: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
( '81276' , '20661' , 'LASCIATI AMARE - P. CURTAZ' , '1' , '-1' , '4' ,
'4.00' , '4' , '0' , '5' , '3.80' )
08/02/2023 10:49: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
( '81276' , '20670' , 'CIO CHE CONTA E AMARE' , '1' , '-1' , '4' ,
'3.70' , '3.7' , '0' , '5' , '3.52' )
08/02/2023 10:49: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
( '81276' , '20675' , 'SULLA VIA DELLA CROCE CON PAPA FRANCESCO' , '1' , '-1' , '4' ,
'3.00' , '3' , '0' , '5' , '2.85' )
08/02/2023 10:49: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
( '81276' , '20660' , 'QUARESIMA E PASQUA ' , '1' , '-1' , '4' ,
'2.90' , '2.9' , '0' , '5' , '2.76' )
08/02/2023 10:49: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
( '81276' , '20655' , 'ARTE DELLA BUONA BATTAGLIA - F. ROSINI' , '1' , '-1' , '4' ,
'18.00' , '18' , '0' , '5' , '17.10' )
08/02/2023 10:49: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
( '81276' , '17585' , 'RUOTA DELLA S. MESSA - POSTER' , '1' , '-1' , '4' ,
'1.00' , '1' , '0' , '0' , '1.00' )
08/02/2023 10:49:42 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
( '81276' , '15318' , 'PERDONAMI SIGNORE ' , '1' , '-1' , '4' ,
'2.00' , '2' , '0' , '0' , '2.00' )
08/02/2023 10:49:42 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
( '81276' , '3510' , 'DIO PADRE - POSTER' , '1' , '-1' , '4' ,
'1.80' , '1.8' , '0' , '0' , '1.80' )
08/02/2023 10:49:42 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
( '81276' , '18782' , 'PADRE NOSTRO - POSTER' , '1' , '-1' , '1' ,
'2.00' , '1.6393442622951' , '22' , '0' , '2.00' )
08/02/2023 10:49:42 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
( '81276' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' ,
'10.00' , '8.1967213114754' , '22' , '0' , '10.00' )
08/02/2023 12:17:48 pm >> SELECT document_num FROM ps_document
WHERE document_num = '452' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-08')
08/02/2023 12:17:48 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' ,
'452' ,
'2023-02-08' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'75.00' ,
'61.48' ,
NOW() ,
NOW() )
08/02/2023 12:17:48 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 = '81277'
08/02/2023 12:17:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '81277'
08/02/2023 12:17:48 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
( '81277' , '20646' , 'STOLA DIACONALE - 881' , '1' , '-1' , '1' ,
'75.00' , '61.475409836066' , '22' , '0' , '75.00' )
08/02/2023 12:41:37 pm >> SELECT document_num FROM ps_document
WHERE document_num = '453' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-08')
08/02/2023 12:41:37 pm >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'453' ,
'2023-02-08' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'15.45' ,
'15.45' ,
NOW() ,
NOW() )
08/02/2023 12:41:37 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81278'
08/02/2023 12:41:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '81278'
08/02/2023 12:41:37 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '81278' , '20592' , 'SULLA TUA PAROLA MAR/APR 23 - 515' , '1' , '-1' , '4' ,
'5.00' , '5' , '0' , '5' , '4.75' )
08/02/2023 12:41:37 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '81278' , '11151' , 'LIBRI' , '2' , '-2' , '4' ,
'1.5' , '1.5' , '0' , '0' , '3.00' )
08/02/2023 12:41:37 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '81278' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '2' , '-2' , '4' ,
'1.00' , '1' , '0' , '0' , '2.00' )
08/02/2023 12:41:37 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '81278' , '16667' , 'VIA CRUCIS' , '2' , '-2' , '4' ,
'3.00' , '3' , '0' , '5' , '5.70' )
08/02/2023 03:50:02 pm >> SELECT document_num FROM ps_document
WHERE document_num = '6' AND id_document != '' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2023-02-08')
08/02/2023 03:50:02 pm >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'24' ,
'6' ,
'2023-02-08' ,
'' ,
'3000' ,
'0' ,
'4669629' ,
'VIA DEI CASTANI, 116 00172 ROMA' ,
'' ,
'EDIZIONI' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'2740.00' ,
'2740.00' ,
NOW() ,
NOW() )
08/02/2023 03:50:02 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81279'
08/02/2023 03:50:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '81279'
08/02/2023 03:50:02 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '81279' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '600' , '-600' , '4' ,
'2.40' , '2.4' , '0' , '0' , '1440.00' )
08/02/2023 03:50:02 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '81279' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '720' , '-720' , '4' ,
'1.00' , '1' , '0' , '0' , '720.00' )
08/02/2023 03:50:02 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '81279' , '19050' , 'VENITE ADORIAMO - G. D\'AMORE' , '40' , '-40' , '4' ,
'7.00' , '7' , '0' , '0' , '280.00' )
08/02/2023 03:50: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
( '81279' , '16667' , 'VIA CRUCIS' , '100' , '-100' , '4' ,
'3.00' , '3' , '0' , '0' , '300.00' )
08/02/2023 03:58:52 pm >> SELECT document_num FROM ps_document
WHERE document_num = '6' AND id_document != '81279' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2023-02-08')
08/02/2023 03:58:52 pm >> UPDATE ps_document SET
id_document_type = '24',
document_num = '6',
document_date = '2023-02-08',
document_letter = '',
id_customer = '3000',
id_supplier = '',
id_address = '4669629',
address1 = 'VIA DEI CASTANI, 116 00172 ROMA',
address2 = '',
note = 'EDIZIONI',
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 = '2865.00',
price_tax_excluded = '2865.00',
date_upd = NOW()
WHERE id_document = '81279'
08/02/2023 03:58: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 = '81279'
08/02/2023 03:58:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '81279'
08/02/2023 03:58:53 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
( '81279' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '600' , '-600' , '4' ,
'2.4000' , '2.4' , '0' , '0' , '1440.00' )
08/02/2023 03:58:53 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
( '81279' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '720' , '-720' , '4' ,
'1.0000' , '1' , '0' , '0' , '720.00' )
08/02/2023 03:58:53 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
( '81279' , '19050' , 'VENITE ADORIAMO - G. D\'AMORE' , '40' , '-40' , '4' ,
'7.0000' , '7' , '0' , '0' , '280.00' )
08/02/2023 03:58:53 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
( '81279' , '16667' , 'VIA CRUCIS' , '100' , '-100' , '4' ,
'3.0000' , '3' , '0' , '0' , '300.00' )
08/02/2023 03:58:53 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
( '81279' , '20640' , 'GESU\', MOSSO A COMPASSIONE V. SALVOLDI' , '50' , '-50' , '4' ,
'2.50' , '2.5' , '0' , '0' , '125.00' )
08/02/2023 04:01:33 pm >> SELECT document_num FROM ps_document
WHERE document_num = '5/E' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-02-08')
08/02/2023 04:01: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 (
'23' ,
'5/E' ,
'2023-02-08' ,
'E' ,
'3000' ,
'0' ,
'4669629' ,
'VIA DEI CASTANI, 116 00172 ROMA' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'13' ,
'0' ,
'306.00' ,
'250.82' ,
NOW() ,
NOW() )
08/02/2023 04:01: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 = '81280'
08/02/2023 04:01:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '81280'
08/02/2023 04:01: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
( '81280' , '13506' , 'SANTO ROSARIO - CONF. 10 DA 50 PZ' , '500' , '-500' , '1' ,
'0.30' , '0.24590163934426' , '22' , '40' , '90.00' )
08/02/2023 04:01: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
( '81280' , '1041' , 'BENEDIZIONI - ICONA CRISTO' , '1000' , '-1000' , '1' ,
'0.18' , '0.14754098360656' , '22' , '40' , '108.00' )
08/02/2023 04:01: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
( '81280' , '1041' , 'BENEDIZIONI - SACRA FAMIGLIA A' , '1000' , '-1000' , '1' ,
'0.18' , '0.14754098360656' , '22' , '40' , '108.00' )
08/02/2023 04:02:50 pm >> SELECT document_num FROM ps_document
WHERE document_num = '3' AND id_document != '' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2023-02-08')
08/02/2023 04:02: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 (
'24' ,
'3' ,
'2023-02-08' ,
'' ,
'3000' ,
'0' ,
'4669629' ,
'VIA DEI CASTANI, 116 00172 ROMA' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'1840.00' ,
'1840.00' ,
NOW() ,
NOW() )
08/02/2023 04:02: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 = '9514'
08/02/2023 04:02:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '9514'
08/02/2023 04:02: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
( '9514' , '110' , 'SE MI AMI NON PIANGERE' , '400' , '-400' , '4' ,
'1.80' , '1.8' , '0' , '0' , '720.00' )
08/02/2023 04:02: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
( '9514' , '67' , 'CON GESU\' SULLA VIA DELLA CROCE - VIA CRUCIS ' , '560' , '-560' , '4' ,
'2.00' , '2' , '0' , '0' , '1120.00' )
08/02/2023 04:12:31 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788895983943' AND id_product != '19050' AND ean13 != ''
08/02/2023 04:12:31 pm >> UPDATE ps_product SET
id_supplier = '53',
reference = '13/4',
ean13 = '9788895983943',
date_upd = NOW()
WHERE id_product = '19050'
08/02/2023 04:12:31 pm >> UPDATE ps_product_lang SET
name = 'VENITE ADORIAMO - G. D\'AMORE',
description = 'L\'Eucaristia non è fatta solo per essere \"mangiata\", ma anche per essere adorata.
e\' un incontro personale e, in qualche modo comunitario, con il Signore.
Questo libretto vuole alimentare la devozione eucaristica in modo che il centro delle comunità sia sempre l\'eucaristia.
'
WHERE id_product = '19050'
08/02/2023 04:12:31 pm >> UPDATE ps_product SET
wholesale_price = '0.85',
on_sale = '0',
price = '7.0000'
WHERE id_product = '19050'
08/02/2023 04:12:31 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.85',
price = '7.0000',
id_tax_rules_group = '4',
id_category_default = '395',
id_argoment_default = '28',
id_internal_category = '4',
on_sale = '0',
on_showcase = '1',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '19050'
08/02/2023 04:12:31 pm >> DELETE FROM ps_specific_price WHERE id_product = '19050'
08/02/2023 04:12:31 pm >> INSERT INTO ps_specific_price
( id_specific_price_rule , id_cart , id_product , id_shop , id_shop_group , id_currency , id_country , id_group , id_customer , id_product_attribute , price , from_quantity , reduction , reduction_tax , reduction_type , `from` , `to`)
VALUES
( '0' , '0' , '19050' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' )
08/02/2023 05:03:25 pm >> SELECT document_num FROM ps_document
WHERE document_num = '454' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-08')
08/02/2023 05:03:25 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' ,
'454' ,
'2023-02-08' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'12.80' ,
'11.93' ,
NOW() ,
NOW() )
08/02/2023 05:03: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 = '81281'
08/02/2023 05:03:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '81281'
08/02/2023 05:03: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
( '81281' , '2678' , 'CONOSCERE E ADORARE IL VOLTO SANTO' , '1' , '-1' , '4' ,
'8.00' , '8' , '0' , '0' , '8.00' )
08/02/2023 05:03: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
( '81281' , '15261' , 'MEDAGLIA SAN BENEDETTO' , '2' , '-2' , '1' ,
'1.50' , '1.2295081967213' , '22' , '0' , '3.00' )
08/02/2023 05:03: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
( '81281' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' ,
'1.8' , '1.4754098360656' , '22' , '0' , '1.80' )
08/02/2023 05:13:12 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892219977' AND id_product != '16143' AND ean13 != ''
08/02/2023 05:13:12 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '6/4',
ean13 = '9788892219977',
date_upd = NOW()
WHERE id_product = '16143'
08/02/2023 05:13:12 pm >> UPDATE ps_product_lang SET
name = 'NEL MIO STARE IL VOSTRO ANDARE - CHIARA BADANO',
description = ''
WHERE id_product = '16143'
08/02/2023 05:13:12 pm >> UPDATE ps_product SET
wholesale_price = '6.70',
on_sale = '0',
price = '10.0000'
WHERE id_product = '16143'
08/02/2023 05:13:12 pm >> UPDATE ps_product_shop SET
wholesale_price = '6.70',
price = '10.0000',
id_tax_rules_group = '4',
id_category_default = '30',
id_argoment_default = '71',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '16143'
08/02/2023 05:13:12 pm >> DELETE FROM ps_specific_price WHERE id_product = '16143'
08/02/2023 05:15:01 pm >> UPDATE ps_product_shop SET
minimal_quantity = '1',
multiple_quantity = '1',
available_date = '',
date_upd = NOW()
WHERE id_product = '16143'
08/02/2023 05:15:01 pm >> UPDATE ps_stock_available SET quantity = quantity + '-1' WHERE id_product = '16143'
08/02/2023 05:32:43 pm >> SELECT document_num FROM ps_document
WHERE document_num = '5/E' AND id_document != '81280' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-02-08')
08/02/2023 05:32:43 pm >> UPDATE ps_document SET
id_document_type = '23',
document_num = '5/E',
document_date = '2023-02-08',
document_letter = 'E',
id_customer = '3000',
id_supplier = '',
id_address = '4669629',
address1 = 'VIA DEI CASTANI, 116 00172 ROMA',
address2 = '',
note = '',
price_shipping = '0.00',
id_tax_shipping_rules = '4',
colli = '0',
peso = '0',
porto_e_imballo = '0',
mezzo_consegna = '',
id_payment = '13',
id_causal = '0',
price_tax_included = '306.00',
price_tax_excluded = '250.82',
date_upd = NOW()
WHERE id_document = '81280'
08/02/2023 05:32: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 = '81280'
08/02/2023 05:32:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '81280'
08/02/2023 05:32: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
( '81280' , '13506' , 'SANTO ROSARIO - CONF. 10 DA 50 PZ' , '500' , '-500' , '1' ,
'0.3000' , '0.24590163934426' , '22' , '40' , '90.00' )
08/02/2023 05:32: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
( '81280' , '1041' , 'BENEDIZIONI - ICONA CRISTO' , '1000' , '-1000' , '1' ,
'0.1800' , '0.14754098360656' , '22' , '40' , '108.00' )
08/02/2023 05:32: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
( '81280' , '1041' , 'BENEDIZIONI - SACRA FAMIGLIA A' , '1000' , '-1000' , '1' ,
'0.1800' , '0.14754098360656' , '22' , '40' , '108.00' )