13/07/2022 08:27:30 am >> SELECT document_num FROM ps_document
WHERE document_num = '1938' AND id_document != '58782' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-15')
13/07/2022 08:27:30 am >> UPDATE ps_document SET
id_document_type = '11',
document_num = '1938',
document_date = '2022-06-15',
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 = '20.69',
price_tax_excluded = '20.69',
date_upd = NOW()
WHERE id_document = '58782'
13/07/2022 08:27:30 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 = '58782'
13/07/2022 08:27:30 am >> DELETE FROM ps_document_detail WHERE id_document = '58782'
13/07/2022 08:27:30 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
( '58782' , '16050' , 'BELLEZZA DELLA CELEBRAZIONE EUCARISTICA ' , '1' , '-1' , '4' ,
'3.5000' , '3.5' , '0' , '5' , '3.33' )
13/07/2022 08:27:30 am >> DELETE FROM ps_product_supplier WHERE id_product = '16050' AND id_supplier = ''
13/07/2022 08:27:30 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16050' , '' , '1' )
13/07/2022 08:27:30 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
( '58782' , '15251' , 'FATE QUESTO IN MEMORIA DI ME' , '1' , '-1' , '4' ,
'2.5000' , '2.5' , '0' , '5' , '2.38' )
13/07/2022 08:27:30 am >> DELETE FROM ps_product_supplier WHERE id_product = '15251' AND id_supplier = ''
13/07/2022 08:27:30 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15251' , '' , '1' )
13/07/2022 08:27:30 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
( '58782' , '11202' , 'VENITE E VEDRETE CAT.' , '1' , '-1' , '4' ,
'9.3000' , '9.3' , '0' , '5' , '8.84' )
13/07/2022 08:27:30 am >> DELETE FROM ps_product_supplier WHERE id_product = '11202' AND id_supplier = ''
13/07/2022 08:27:30 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11202' , '' , '1' )
13/07/2022 08:27:30 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
( '58782' , '8340' , 'PREGHIERE AL PREZIOSISSIMO SANGUE - 8158' , '1' , '-1' , '4' ,
'6.14' , '6.14' , '0' , '0' , '6.14' )
13/07/2022 08:27:30 am >> DELETE FROM ps_product_supplier WHERE id_product = '8340' AND id_supplier = ''
13/07/2022 08:27:30 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8340' , '' , '1' )
13/07/2022 08:28:36 am >> SELECT document_num FROM ps_document
WHERE document_num = '2061' AND id_document != '58921' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-27')
13/07/2022 08:28:36 am >> UPDATE ps_document SET
id_document_type = '11',
document_num = '2061',
document_date = '2022-06-27',
document_letter = '',
id_customer = '0',
id_supplier = '',
id_address = '0',
address1 = 'VIA DALMAZIA 6 84121 SALERNO',
address2 = '',
note = '',
price_shipping = '0.00',
id_tax_shipping_rules = '4',
colli = '0',
peso = '0',
porto_e_imballo = '0',
mezzo_consegna = '',
id_payment = '0',
id_causal = '0',
price_tax_included = '71.12',
price_tax_excluded = '60.95',
date_upd = NOW()
WHERE id_document = '58921'
13/07/2022 08:28:36 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58921'
13/07/2022 08:28:36 am >> DELETE FROM ps_document_detail WHERE id_document = '58921'
13/07/2022 08:28:36 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58921' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' ,
'4.7000' , '3.8524590163934' , '22' , '0' , '56.40' )
13/07/2022 08:28:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = ''
13/07/2022 08:28:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' )
13/07/2022 08:28:36 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58921' , '11151' , 'LIBRI' , '1' , '-1' , '4' ,
'6' , '6' , '0' , '0' , '6.00' )
13/07/2022 08:28:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = ''
13/07/2022 08:28:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' )
13/07/2022 08:28:36 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58921' , '15816' , 'CHI HA REDENTI CON IL TUO SANGUE - L. EPICOCO ' , '1' , '-1' , '4' ,
'8.72' , '8.72' , '0' , '0' , '8.72' )
13/07/2022 08:28:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '15816' AND id_supplier = ''
13/07/2022 08:28:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15816' , '' , '1' )
13/07/2022 08:29:06 am >> SELECT document_num FROM ps_document
WHERE document_num = '2042' AND id_document != '58899' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-25')
13/07/2022 08:29:06 am >> UPDATE ps_document SET
id_document_type = '11',
document_num = '2042',
document_date = '2022-06-25',
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 = '20.00',
price_tax_excluded = '20.00',
date_upd = NOW()
WHERE id_document = '58899'
13/07/2022 08:29:06 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 = '58899'
13/07/2022 08:29:06 am >> DELETE FROM ps_document_detail WHERE id_document = '58899'
13/07/2022 08:29:06 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
( '58899' , '19377' , 'VANGELO SECONDO MARCO - L. BRUNI' , '1' , '-1' , '4' ,
'20' , '20' , '0' , '0' , '20.00' )
13/07/2022 08:29:06 am >> DELETE FROM ps_product_supplier WHERE id_product = '19377' AND id_supplier = ''
13/07/2022 08:29:06 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19377' , '' , '1' )
13/07/2022 08:29:30 am >> DELETE FROM ps_document WHERE id_document = '59132'
13/07/2022 08:29:30 am >> DELETE FROM ps_document_detail WHERE id_document = '59132'
13/07/2022 09:20:39 am >> SELECT document_num FROM ps_document
WHERE document_num = '2250' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-13')
13/07/2022 09:20:39 am >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'2250' ,
'2022-07-13' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'72.00' ,
'59.02' ,
NOW() ,
NOW() )
13/07/2022 09:20:39 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '59152'
13/07/2022 09:20:39 am >> DELETE FROM ps_document_detail WHERE id_document = '59152'
13/07/2022 09:20:39 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '59152' , '19594' , 'POLO JERSEY COTONE 100%' , '2' , '-2' , '1' ,
'36' , '29.508196721311' , '22' , '0' , '72.00' )
13/07/2022 09:20:40 am >> DELETE FROM ps_product_supplier WHERE id_product = '19594' AND id_supplier = ''
13/07/2022 09:20:40 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19594' , '' , '1' )
13/07/2022 09:39:58 am >> SELECT document_num FROM ps_document
WHERE document_num = '1279' AND id_document != '56455' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-04-27')
13/07/2022 09:39:58 am >> UPDATE ps_document SET
id_document_type = '11',
document_num = '1279',
document_date = '2022-04-27',
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 = '78.00',
price_tax_excluded = '63.93',
date_upd = NOW()
WHERE id_document = '56455'
13/07/2022 09:39: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 = '56455'
13/07/2022 09:39:58 am >> DELETE FROM ps_document_detail WHERE id_document = '56455'
13/07/2022 09:39: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
( '56455' , '18259' , 'CLERGY GRIGIO NIDO DAPE MM - L' , '1' , '-1' , '1' ,
'40.0000' , '32.786885245902' , '22' , '0' , '40.00' )
13/07/2022 09:39:58 am >> DELETE FROM ps_product_supplier WHERE id_product = '18259' AND id_supplier = ''
13/07/2022 09:39:58 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18259' , '' , '1' )
13/07/2022 09:39: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
( '56455' , '6356' , 'MEDAGLIA S.CUORE- MAD. CARMINE' , '15' , '-15' , '1' ,
'0.20' , '0.16393442622951' , '22' , '0' , '3.00' )
13/07/2022 09:39:58 am >> DELETE FROM ps_product_supplier WHERE id_product = '6356' AND id_supplier = ''
13/07/2022 09:39:58 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6356' , '' , '1' )
13/07/2022 09:39: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
( '56455' , '11756' , 'VINO BIANCO SECCO - 14%' , '7' , '-7' , '1' ,
'5' , '4.0983606557377' , '22' , '0' , '35.00' )
13/07/2022 09:39:58 am >> DELETE FROM ps_product_supplier WHERE id_product = '11756' AND id_supplier = ''
13/07/2022 09:39:58 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11756' , '' , '1' )
13/07/2022 09:40:35 am >> SELECT document_num FROM ps_document
WHERE document_num = '1230' AND id_document != '55886' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-04-23')
13/07/2022 09:40:35 am >> UPDATE ps_document SET
id_document_type = '11',
document_num = '1230',
document_date = '2022-04-23',
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 = '46.00',
price_tax_excluded = '37.70',
date_upd = NOW()
WHERE id_document = '55886'
13/07/2022 09:40:35 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '55886'
13/07/2022 09:40:35 am >> DELETE FROM ps_document_detail WHERE id_document = '55886'
13/07/2022 09:40:35 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '55886' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '5' , '-5' , '1' ,
'0.20' , '0.16393442622951' , '22' , '0' , '1.00' )
13/07/2022 09:40:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '18617' AND id_supplier = ''
13/07/2022 09:40:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18617' , '' , '1' )
13/07/2022 09:40:36 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '55886' , '11756' , 'VINO BIANCO SECCO - 14%' , '9' , '-9' , '1' ,
'5' , '4.0983606557377' , '22' , '0' , '45.00' )
13/07/2022 09:40:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '11756' AND id_supplier = ''
13/07/2022 09:40:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11756' , '' , '1' )
13/07/2022 09:41:17 am >> SELECT document_num FROM ps_document
WHERE document_num = '1201' AND id_document != '55339' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-04-21')
13/07/2022 09:41:17 am >> UPDATE ps_document SET
id_document_type = '11',
document_num = '1201',
document_date = '2022-04-21',
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.00',
price_tax_excluded = '34.43',
date_upd = NOW()
WHERE id_document = '55339'
13/07/2022 09:41:17 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 = '55339'
13/07/2022 09:41:17 am >> DELETE FROM ps_document_detail WHERE id_document = '55339'
13/07/2022 09:41:17 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
( '55339' , '11756' , 'VINO BIANCO SECCO - 14%' , '4' , '-4' , '1' ,
'5.50' , '4.5081967213115' , '22' , '0' , '22.00' )
13/07/2022 09:41:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '11756' AND id_supplier = ''
13/07/2022 09:41:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11756' , '' , '1' )
13/07/2022 09:41:17 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
( '55339' , '791' , 'ASSISI IN BUSTA BATTESIMO - 20X270 - BAAS' , '5' , '-5' , '1' ,
'1.4000' , '1.1475409836066' , '22' , '0' , '7.00' )
13/07/2022 09:41:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '791' AND id_supplier = ''
13/07/2022 09:41:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '791' , '' , '1' )
13/07/2022 09:41:17 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
( '55339' , '11264' , 'VESTINA BATTESIMALE' , '5' , '-5' , '1' ,
'2.5000' , '2.0491803278689' , '22' , '0' , '12.50' )
13/07/2022 09:41:18 am >> DELETE FROM ps_product_supplier WHERE id_product = '11264' AND id_supplier = ''
13/07/2022 09:41:18 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11264' , '' , '1' )
13/07/2022 09:41: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
( '55339' , '9125' , 'ROSARIO IN PLASTICA - NERO' , '2' , '-2' , '1' ,
'0.25' , '0.20491803278689' , '22' , '0' , '0.50' )
13/07/2022 09:41:18 am >> DELETE FROM ps_product_supplier WHERE id_product = '9125' AND id_supplier = ''
13/07/2022 09:41:18 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9125' , '' , '1' )
13/07/2022 09:41:43 am >> SELECT document_num FROM ps_document
WHERE document_num = '1356' AND id_document != '56543' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-02')
13/07/2022 09:41:43 am >> UPDATE ps_document SET
id_document_type = '11',
document_num = '1356',
document_date = '2022-05-02',
document_letter = '',
id_customer = '0',
id_supplier = '',
id_address = '0',
address1 = '',
address2 = '',
note = '',
price_shipping = '0.00',
id_tax_shipping_rules = '4',
colli = '0',
peso = '0',
porto_e_imballo = '0',
mezzo_consegna = '',
id_payment = '0',
id_causal = '0',
price_tax_included = '20.00',
price_tax_excluded = '16.39',
date_upd = NOW()
WHERE id_document = '56543'
13/07/2022 09:41: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 = '56543'
13/07/2022 09:41:43 am >> DELETE FROM ps_document_detail WHERE id_document = '56543'
13/07/2022 09:41: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
( '56543' , '11756' , 'VINO BIANCO SECCO - 14%' , '4' , '-4' , '1' ,
'5' , '4.0983606557377' , '22' , '0' , '20.00' )
13/07/2022 09:41:43 am >> DELETE FROM ps_product_supplier WHERE id_product = '11756' AND id_supplier = ''
13/07/2022 09:41:43 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11756' , '' , '1' )
13/07/2022 09:54:34 am >> SELECT document_num FROM ps_document
WHERE document_num = '20' AND id_document != '' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2022-07-13')
13/07/2022 09:54:34 am >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'24' ,
'20' ,
'2022-07-13' ,
'' ,
'3550' ,
'0' ,
'4671016' ,
'VIA S. MARIA IN MONTICELLI, 28 00186 ROMA' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'108.00' ,
'88.52' ,
NOW() ,
NOW() )
13/07/2022 09:54:34 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '59153'
13/07/2022 09:54:34 am >> DELETE FROM ps_document_detail WHERE id_document = '59153'
13/07/2022 09:54:34 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '59153' , '11756' , 'VINO BIANCO SECCO - 14%' , '12' , '-12' , '1' ,
'6' , '4.9180327868852' , '22' , '0' , '72.00' )
13/07/2022 09:54:34 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '59153' , '19396' , 'CLERGY MISTO COTONE MM - C01' , '1' , '-1' , '1' ,
'36.00' , '29.508196721311' , '22' , '0' , '36.00' )
13/07/2022 09:54:47 am >> DELETE FROM ps_document WHERE id_document = '59153'
13/07/2022 09:54:47 am >> DELETE FROM ps_document_detail WHERE id_document = '59153'
13/07/2022 11:00:18 am >> SELECT document_num FROM ps_document
WHERE document_num = '2251' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-13')
13/07/2022 11:00: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' ,
'2251' ,
'2022-07-13' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'9.50' ,
'9.50' ,
NOW() ,
NOW() )
13/07/2022 11:00: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 = '59154'
13/07/2022 11:00:18 am >> DELETE FROM ps_document_detail WHERE id_document = '59154'
13/07/2022 11:00: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
( '59154' , '19622' , 'SULLA TUA PAROLA - SETT/OTT 2022' , '2' , '-2' , '4' ,
'5.00' , '5' , '0' , '5' , '9.50' )
13/07/2022 11:00:18 am >> DELETE FROM ps_product_supplier WHERE id_product = '19622' AND id_supplier = ''
13/07/2022 11:00:18 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19622' , '' , '1' )
13/07/2022 11:08:44 am >> SELECT document_num FROM ps_document
WHERE document_num = '2252' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-13')
13/07/2022 11:08:44 am >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'2252' ,
'2022-07-13' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'14.40' ,
'12.57' ,
NOW() ,
NOW() )
13/07/2022 11:08:44 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '59155'
13/07/2022 11:08:44 am >> DELETE FROM ps_document_detail WHERE id_document = '59155'
13/07/2022 11:08:45 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
( '59155' , '15335' , 'CANDELA VOTIVA 20X40 DECORATA' , '1' , '-1' , '1' ,
'2.50' , '2.0491803278689' , '22' , '0' , '2.50' )
13/07/2022 11:08:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '15335' AND id_supplier = ''
13/07/2022 11:08:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15335' , '' , '1' )
13/07/2022 11:08:45 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
( '59155' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '1' , '-1' , '1' ,
'6.50' , '5.327868852459' , '22' , '0' , '6.50' )
13/07/2022 11:08:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '11757' AND id_supplier = ''
13/07/2022 11:08:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11757' , '' , '1' )
13/07/2022 11:08:45 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
( '59155' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' ,
'1.90' , '1.8269230769231' , '4' , '0' , '1.90' )
13/07/2022 11:08:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = ''
13/07/2022 11:08:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' )
13/07/2022 11:08:45 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
( '59155' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '1' , '-1' , '3' ,
'3.50' , '3.3653846153846' , '4' , '0' , '3.50' )
13/07/2022 11:08:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = ''
13/07/2022 11:08:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' )
13/07/2022 11:17:48 am >> SELECT document_num FROM ps_document
WHERE document_num = '2253' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-13')
13/07/2022 11:17:48 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' ,
'2253' ,
'2022-07-13' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'31.70' ,
'25.98' ,
NOW() ,
NOW() )
13/07/2022 11:17:48 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 = '59156'
13/07/2022 11:17:48 am >> DELETE FROM ps_document_detail WHERE id_document = '59156'
13/07/2022 11:17:48 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
( '59156' , '547' , 'AMPOLLINE E VASSOIO IN VETRO - 506' , '1' , '-1' , '1' ,
'31.70' , '25.983606557377' , '22' , '0' , '31.70' )
13/07/2022 11:17:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '547' AND id_supplier = ''
13/07/2022 11:17:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '547' , '' , '1' )
13/07/2022 11:27:00 am >> SELECT document_num FROM ps_document
WHERE document_num = '2254' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-13')
13/07/2022 11:27:00 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' ,
'2254' ,
'2022-07-13' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'5.00' ,
'4.10' ,
NOW() ,
NOW() )
13/07/2022 11:27:00 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 = '59157'
13/07/2022 11:27:00 am >> DELETE FROM ps_document_detail WHERE id_document = '59157'
13/07/2022 11:27:00 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
( '59157' , '14926' , 'VESTINA BATTESIMALE' , '1' , '-1' , '1' ,
'5.00' , '4.0983606557377' , '22' , '0' , '5.00' )
13/07/2022 11:27:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '14926' AND id_supplier = ''
13/07/2022 11:27:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14926' , '' , '1' )
13/07/2022 11:33:32 am >> SELECT document_num FROM ps_document
WHERE document_num = '2255' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-13')
13/07/2022 11:33:32 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' ,
'2255' ,
'2022-07-13' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'3.00' ,
'2.46' ,
NOW() ,
NOW() )
13/07/2022 11:33:32 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 = '59158'
13/07/2022 11:33:32 am >> DELETE FROM ps_document_detail WHERE id_document = '59158'
13/07/2022 11:33:32 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
( '59158' , '4697' , 'GLORIA MISCELA 25G - GLORE' , '2' , '-2' , '1' ,
'1.50' , '1.2295081967213' , '22' , '0' , '3.00' )
13/07/2022 11:33:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '4697' AND id_supplier = ''
13/07/2022 11:33:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4697' , '' , '1' )
13/07/2022 11:57:44 am >> SELECT document_num FROM ps_document
WHERE document_num = '12/A' AND id_document != '51968' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-02-28')
13/07/2022 11:57:44 am >> UPDATE ps_document SET
id_document_type = '24',
document_num = '12/A',
document_date = '2022-02-28',
document_letter = 'A',
id_customer = '204',
id_supplier = '',
id_address = '4671483',
address1 = 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO',
address2 = '',
note = 'cappellania 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 = '86.74',
price_tax_excluded = '74.25',
date_upd = NOW()
WHERE id_document = '51968'
13/07/2022 11:57:44 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '51968'
13/07/2022 11:57:45 am >> DELETE FROM ps_document_detail WHERE id_document = '51968'
13/07/2022 11:57:45 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
( '51968' , '14247' , 'ROSARIO ULIVO OVALE CON SETA E CROCE SAN DAMIANO' , '36' , '-36' , '1' ,
'1.3000' , '1.0655737704918' , '22' , '0' , '46.80' )
13/07/2022 11:57:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '14247' AND id_supplier = ''
13/07/2022 11:57:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14247' , '' , '1' )
13/07/2022 11:57:45 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
( '51968' , '16689' , 'OSTIA PAN DI CENA mm80' , '7' , '-7' , '3' ,
'2.0000' , '1.9230769230769' , '4' , '0' , '14.00' )
13/07/2022 11:57:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = ''
13/07/2022 11:57:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '' , '1' )
13/07/2022 11:57:45 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
( '51968' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '2' , '-2' , '3' ,
'3.5000' , '3.3653846153846' , '4' , '0' , '7.00' )
13/07/2022 11:57:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = ''
13/07/2022 11:57:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' )
13/07/2022 11:57:45 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
( '51968' , '14247' , 'ROSARIO ULIVO OVALE CON SETA E CROCE SAN DAMIANO' , '12' , '-12' , '1' ,
'1.5000' , '1.2295081967213' , '22' , '0' , '18.00' )
13/07/2022 11:57:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '14247' AND id_supplier = ''
13/07/2022 11:57:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14247' , '' , '1' )
13/07/2022 11:57:45 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
( '51968' , '0' , 'SOMMA PER ARRIVARE AL RESIDUO' , '1' , '-1' , '0' ,
'0.9400' , '0.94' , '0' , '0' , '0.94' )
13/07/2022 11:57:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = ''
13/07/2022 11:57:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' )
13/07/2022 11:57:45 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
( '51968' , '0' , 'ACCONTO scontrinato € 218 SCALATI, RESIDUO AL 27/06/2022 ' , '1' , '-1' , '0' ,
'0.0000' , '0' , '0' , '0' , '0.00' )
13/07/2022 11:57:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = ''
13/07/2022 11:57:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' )
13/07/2022 12:02:40 pm >> SELECT document_num FROM ps_document
WHERE document_num = '12/A' AND id_document != '51968' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-02-28')
13/07/2022 12:02:40 pm >> UPDATE ps_document SET
id_document_type = '24',
document_num = '12/A',
document_date = '2022-02-28',
document_letter = 'A',
id_customer = '204',
id_supplier = '',
id_address = '4671483',
address1 = 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO',
address2 = '',
note = 'cappellania 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 = '28.00',
price_tax_excluded = '28.00',
date_upd = NOW()
WHERE id_document = '51968'
13/07/2022 12:02:40 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '51968'
13/07/2022 12:02:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '51968'
13/07/2022 12:02:40 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '51968' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '50' , '-50' , '4' ,
'0.56' , '0.56' , '0' , '0' , '28.00' )
13/07/2022 12:02:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4223' AND id_supplier = ''
13/07/2022 12:02:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4223' , '' , '1' )
13/07/2022 12:04:10 pm >> SELECT document_num FROM ps_document
WHERE document_num = '12/A' AND id_document != '51968' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-02-28')
13/07/2022 12:04:10 pm >> UPDATE ps_document SET
id_document_type = '24',
document_num = '12/A',
document_date = '2022-02-28',
document_letter = 'A',
id_customer = '204',
id_supplier = '',
id_address = '4671483',
address1 = 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO',
address2 = '',
note = 'cappellania 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 = '65.04',
price_tax_excluded = '65.04',
date_upd = NOW()
WHERE id_document = '51968'
13/07/2022 12:04:10 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '51968'
13/07/2022 12:04:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '51968'
13/07/2022 12:04:10 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '51968' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '50' , '-50' , '4' ,
'0.5600' , '0.56' , '0' , '0' , '28.00' )
13/07/2022 12:04:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4223' AND id_supplier = ''
13/07/2022 12:04:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4223' , '' , '1' )
13/07/2022 12:04:10 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '51968' , '19685' , 'AMEN - OTT 2022' , '5' , '-5' , '4' ,
'3.90' , '3.9' , '0' , '5' , '18.52' )
13/07/2022 12:04:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19685' AND id_supplier = ''
13/07/2022 12:04:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19685' , '' , '1' )
13/07/2022 12:04:10 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '51968' , '19684' , 'AMEN - SETT. 2022' , '5' , '-5' , '4' ,
'3.90' , '3.9' , '0' , '5' , '18.52' )
13/07/2022 12:04:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19684' AND id_supplier = ''
13/07/2022 12:04:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19684' , '' , '1' )
13/07/2022 12:05:57 pm >> SELECT document_num FROM ps_document
WHERE document_num = '2256' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-13')
13/07/2022 12:05:57 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' ,
'2256' ,
'2022-07-13' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'2.50' ,
'2.23' ,
NOW() ,
NOW() )
13/07/2022 12:05:57 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '59159'
13/07/2022 12:05:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '59159'
13/07/2022 12:05:57 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '59159' , '11151' , 'LIBRI' , '1' , '-1' , '4' ,
'1' , '1' , '0' , '0' , '1.00' )
13/07/2022 12:05:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = ''
13/07/2022 12:05:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' )
13/07/2022 12:05:57 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '59159' , '4697' , 'GLORIA MISCELA 25G - GLORE' , '1' , '-1' , '1' ,
'1.50' , '1.2295081967213' , '22' , '0' , '1.50' )
13/07/2022 12:05:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4697' AND id_supplier = ''
13/07/2022 12:05:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4697' , '' , '1' )
13/07/2022 12:07:56 pm >> SELECT document_num FROM ps_document
WHERE document_num = '1311' AND id_document != '56492' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-04-29')
13/07/2022 12:07:56 pm >> UPDATE ps_document SET
id_document_type = '11',
document_num = '1311',
document_date = '2022-04-29',
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 = '201.19',
price_tax_excluded = '174.27',
date_upd = NOW()
WHERE id_document = '56492'
13/07/2022 12:07:56 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '56492'
13/07/2022 12:07:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '56492'
13/07/2022 12:07:56 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '56492' , '9436' , 'SAN GABRIELE DELLADDOLORATA - V.SALVOLDI' , '2' , '-2' , '4' ,
'4.0000' , '4' , '0' , '5' , '7.60' )
13/07/2022 12:07:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9436' AND id_supplier = ''
13/07/2022 12:07:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9436' , '' , '1' )
13/07/2022 12:07:56 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '56492' , '19299' , 'SULLA TUA PAROLA - MAG/GIU 2022' , '2' , '-2' , '4' ,
'5.0000' , '5' , '0' , '5' , '9.50' )
13/07/2022 12:07:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19299' AND id_supplier = ''
13/07/2022 12:07:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19299' , '' , '1' )
13/07/2022 12:07:56 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '56492' , '9613' , 'SANTA TERESA DI LISIEUX' , '2' , '-2' , '4' ,
'5.0000' , '5' , '0' , '5' , '9.50' )
13/07/2022 12:07:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9613' AND id_supplier = ''
13/07/2022 12:07:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9613' , '' , '1' )
13/07/2022 12:07:56 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '56492' , '15846' , 'CARLO ACUTIS - F. OCCHETTA' , '2' , '-2' , '4' ,
'5.0000' , '5' , '0' , '5' , '9.50' )
13/07/2022 12:07:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15846' AND id_supplier = ''
13/07/2022 12:07:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15846' , '' , '1' )
13/07/2022 12:07:56 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '56492' , '3625' , 'DOMENICO SAVIO - T.BOSCO' , '1' , '-1' , '4' ,
'4.0000' , '4' , '0' , '5' , '3.80' )
13/07/2022 12:07:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '3625' AND id_supplier = ''
13/07/2022 12:07:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3625' , '' , '1' )
13/07/2022 12:07:57 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '56492' , '19316' , 'SCATOLINA METALLO CON CORONCINA CONFESSIONE - 1016/K159' , '15' , '-15' , '1' ,
'2.8000' , '2.2950819672131' , '22' , '0' , '42.00' )
13/07/2022 12:07:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19316' AND id_supplier = ''
13/07/2022 12:07:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19316' , '' , '1' )
13/07/2022 12:07:57 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '56492' , '2663' , 'CONFEZIONE CON LIBRETTO E CROCE - 2324/K04' , '4' , '-4' , '1' ,
'2.2000' , '1.8032786885246' , '22' , '0' , '8.80' )
13/07/2022 12:07:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2663' AND id_supplier = ''
13/07/2022 12:07:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2663' , '' , '1' )
13/07/2022 12:07:57 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '56492' , '11644' , 'PICCOLA GUIDA ALLA CONFESSIONE' , '4' , '-4' , '4' ,
'1.9000' , '1.9' , '0' , '5' , '7.24' )
13/07/2022 12:07:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11644' AND id_supplier = ''
13/07/2022 12:07:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11644' , '' , '1' )
13/07/2022 12:07:57 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '56492' , '7928' , 'PERGAMENE - BATTESIMO MOD. C' , '10' , '-10' , '1' ,
'0.5000' , '0.40983606557377' , '22' , '5' , '4.80' )
13/07/2022 12:07:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7928' AND id_supplier = ''
13/07/2022 12:07:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7928' , '' , '1' )
13/07/2022 12:07:57 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '56492' , '7915' , 'PERGAMENE - 1A COMUNIONE MOD. D' , '50' , '-50' , '1' ,
'0.5000' , '0.40983606557377' , '22' , '5' , '24.00' )
13/07/2022 12:07:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7915' AND id_supplier = ''
13/07/2022 12:07:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7915' , '' , '1' )
13/07/2022 12:07:57 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '56492' , '7916' , 'PERGAMENE - 1A RICONCILIAZIONE MOD. A' , '15' , '-15' , '1' ,
'0.5000' , '0.40983606557377' , '22' , '0' , '7.50' )
13/07/2022 12:07:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7916' AND id_supplier = ''
13/07/2022 12:07:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7916' , '' , '1' )
13/07/2022 12:07:57 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '56492' , '1312' , 'BRACCIALE DECINA' , '5' , '-5' , '1' ,
'1.30' , '1.0655737704918' , '22' , '0' , '6.50' )
13/07/2022 12:07:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1312' AND id_supplier = ''
13/07/2022 12:07:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1312' , '' , '1' )
13/07/2022 12:07:57 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '56492' , '9150' , 'ROSARIO LEGNO SCURO E CORDA - 99999' , '2' , '-2' , '1' ,
'1.1000' , '0.9016393442623' , '22' , '0' , '2.20' )
13/07/2022 12:07:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9150' AND id_supplier = ''
13/07/2022 12:07:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9150' , '' , '1' )
13/07/2022 12:07:57 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '56492' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' ,
'7.0000' , '5.7377049180328' , '22' , '0' , '42.00' )
13/07/2022 12:07:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11384' AND id_supplier = ''
13/07/2022 12:07:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11384' , '' , '1' )
13/07/2022 12:07:57 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '56492' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' ,
'10.0000' , '8.1967213114754' , '22' , '0' , '10.00' )
13/07/2022 12:07:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17160' AND id_supplier = ''
13/07/2022 12:07:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17160' , '' , '1' )
13/07/2022 12:07:57 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '56492' , '9647' , 'SANTO ROSARIO - A. COMASTRI - 8627' , '1' , '-1' , '4' ,
'4.7500' , '4.75' , '0' , '0' , '4.75' )
13/07/2022 12:07:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9647' AND id_supplier = ''
13/07/2022 12:07:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9647' , '' , '1' )
13/07/2022 12:07:58 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '56492' , '9129' , 'ROSARIO LEGNO - T/2' , '1' , '-1' , '1' ,
'1.5' , '1.2295081967213' , '22' , '0' , '1.50' )
13/07/2022 12:07:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9129' AND id_supplier = ''
13/07/2022 12:07:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9129' , '' , '1' )
13/07/2022 12:11:36 pm >> SELECT document_num FROM ps_document
WHERE document_num = '1344' AND id_document != '56530' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-02')
13/07/2022 12:11:36 pm >> UPDATE ps_document SET
id_document_type = '11',
document_num = '1344',
document_date = '2022-05-02',
document_letter = '',
id_customer = '0',
id_supplier = '',
id_address = '0',
address1 = '',
address2 = '',
note = '',
price_shipping = '0.00',
id_tax_shipping_rules = '4',
colli = '0',
peso = '0',
porto_e_imballo = '0',
mezzo_consegna = '',
id_payment = '0',
id_causal = '0',
price_tax_included = '54.50',
price_tax_excluded = '45.88',
date_upd = NOW()
WHERE id_document = '56530'
13/07/2022 12:11: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 = '56530'
13/07/2022 12:11:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '56530'
13/07/2022 12:11: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
( '56530' , '17160' , 'CARBONCINI ROSSI - CARRO' , '3' , '-3' , '1' ,
'10.0000' , '8.1967213114754' , '22' , '0' , '30.00' )
13/07/2022 12:11:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17160' AND id_supplier = ''
13/07/2022 12:11:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17160' , '' , '1' )
13/07/2022 12:11: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
( '56530' , '7311' , 'OSTIA SOTTILE 74MM' , '5' , '-5' , '3' ,
'1.7000' , '1.6346153846154' , '4' , '0' , '8.50' )
13/07/2022 12:11:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = ''
13/07/2022 12:11:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' )
13/07/2022 12:11: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
( '56530' , '14247' , 'ROSARIO ULIVO OVALE CON SETA E CROCE SAN DAMIANO' , '1' , '-1' , '1' ,
'1' , '0.81967213114754' , '22' , '0' , '1.00' )
13/07/2022 12:11:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14247' AND id_supplier = ''
13/07/2022 12:11:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14247' , '' , '1' )
13/07/2022 12:11: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
( '56530' , '9129' , 'ROSARIO LEGNO - T/2' , '5' , '-5' , '1' ,
'1.5' , '1.2295081967213' , '22' , '0' , '7.50' )
13/07/2022 12:11:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9129' AND id_supplier = ''
13/07/2022 12:11:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9129' , '' , '1' )
13/07/2022 12:11: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
( '56530' , '14247' , 'ROSARIO ULIVO OVALE CON SETA E CROCE SAN DAMIANO' , '5' , '-5' , '1' ,
'1.50' , '1.2295081967213' , '22' , '0' , '7.50' )
13/07/2022 12:11:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14247' AND id_supplier = ''
13/07/2022 12:11:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14247' , '' , '1' )
13/07/2022 12:11:57 pm >> SELECT document_num FROM ps_document
WHERE document_num = '1361' AND id_document != '56548' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-02')
13/07/2022 12:11:57 pm >> UPDATE ps_document SET
id_document_type = '11',
document_num = '1361',
document_date = '2022-05-02',
document_letter = '',
id_customer = '0',
id_supplier = '',
id_address = '0',
address1 = '',
address2 = '',
note = '',
price_shipping = '0.00',
id_tax_shipping_rules = '4',
colli = '0',
peso = '0',
porto_e_imballo = '0',
mezzo_consegna = '',
id_payment = '0',
id_causal = '0',
price_tax_included = '16.00',
price_tax_excluded = '13.11',
date_upd = NOW()
WHERE id_document = '56548'
13/07/2022 12:11:57 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '56548'
13/07/2022 12:11:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '56548'
13/07/2022 12:11:57 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '56548' , '14247' , 'ROSARIO ULIVO OVALE CON SETA E CROCE SAN DAMIANO' , '16' , '-16' , '1' ,
'1' , '0.81967213114754' , '22' , '0' , '16.00' )
13/07/2022 12:11:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14247' AND id_supplier = ''
13/07/2022 12:11:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14247' , '' , '1' )
13/07/2022 12:12:29 pm >> SELECT document_num FROM ps_document
WHERE document_num = '1363' AND id_document != '56550' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-02')
13/07/2022 12:12:29 pm >> UPDATE ps_document SET
id_document_type = '11',
document_num = '1363',
document_date = '2022-05-02',
document_letter = '',
id_customer = '0',
id_supplier = '',
id_address = '0',
address1 = '',
address2 = '',
note = '',
price_shipping = '0.00',
id_tax_shipping_rules = '4',
colli = '0',
peso = '0',
porto_e_imballo = '0',
mezzo_consegna = '',
id_payment = '0',
id_causal = '0',
price_tax_included = '158.74',
price_tax_excluded = '137.77',
date_upd = NOW()
WHERE id_document = '56550'
13/07/2022 12:12: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 = '56550'
13/07/2022 12:12:30 pm >> DELETE FROM ps_document_detail WHERE id_document = '56550'
13/07/2022 12:12: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
( '56550' , '1886' , 'CELEBRIAMO CON GIOIA 3A EDIZ. - A. SORRENTINO' , '1' , '-1' , '4' ,
'20.0000' , '20' , '0' , '0' , '20.00' )
13/07/2022 12:12:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1886' AND id_supplier = ''
13/07/2022 12:12:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1886' , '' , '1' )
13/07/2022 12:12: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
( '56550' , '13506' , 'SANTO ROSARIO' , '100' , '-100' , '1' ,
'0.3000' , '0.24590163934426' , '22' , '10' , '27.00' )
13/07/2022 12:12:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13506' AND id_supplier = ''
13/07/2022 12:12:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13506' , '' , '1' )
13/07/2022 12:12: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
( '56550' , '18377' , 'CHI RESTA SALDO? - E. BIANCHI' , '1' , '-1' , '4' ,
'2.9000' , '2.9' , '0' , '0' , '2.90' )
13/07/2022 12:12:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18377' AND id_supplier = ''
13/07/2022 12:12:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18377' , '' , '1' )
13/07/2022 12:12: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
( '56550' , '19328' , 'AMEN - GIU. 2022' , '1' , '-1' , '4' ,
'3.9000' , '3.9' , '0' , '5' , '3.71' )
13/07/2022 12:12:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19328' AND id_supplier = ''
13/07/2022 12:12:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19328' , '' , '1' )
13/07/2022 12:12: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
( '56550' , '19516' , 'AMEN - AGO 2022' , '1' , '-1' , '4' ,
'3.9000' , '3.9' , '0' , '5' , '3.71' )
13/07/2022 12:12:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19516' AND id_supplier = ''
13/07/2022 12:12:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19516' , '' , '1' )
13/07/2022 12:12: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
( '56550' , '19515' , 'AMEN - LUG 2022' , '1' , '-1' , '4' ,
'3.9000' , '3.9' , '0' , '5' , '3.71' )
13/07/2022 12:12:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19515' AND id_supplier = ''
13/07/2022 12:12:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19515' , '' , '1' )
13/07/2022 12:12: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
( '56550' , '19275' , 'AMEN - MAG. 2022' , '1' , '-1' , '4' ,
'3.9000' , '3.9' , '0' , '5' , '3.71' )
13/07/2022 12:12:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19275' AND id_supplier = ''
13/07/2022 12:12:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19275' , '' , '1' )
13/07/2022 12:12: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
( '56550' , '16689' , 'OSTIA PAN DI CENA mm80' , '3' , '-3' , '3' ,
'2.0000' , '1.9230769230769' , '4' , '0' , '6.00' )
13/07/2022 12:12:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = ''
13/07/2022 12:12:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '' , '1' )
13/07/2022 12:12: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
( '56550' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' ,
'10.0000' , '8.1967213114754' , '22' , '0' , '10.00' )
13/07/2022 12:12:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17160' AND id_supplier = ''
13/07/2022 12:12:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17160' , '' , '1' )
13/07/2022 12:12: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
( '56550' , '14247' , 'ROSARIO ULIVO OVALE CON SETA E CROCE SAN DAMIANO' , '36' , '-36' , '1' ,
'1' , '0.81967213114754' , '22' , '0' , '36.00' )
13/07/2022 12:12:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14247' AND id_supplier = ''
13/07/2022 12:12:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14247' , '' , '1' )
13/07/2022 12:12: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
( '56550' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' ,
'7.0000' , '5.7377049180328' , '22' , '0' , '42.00' )
13/07/2022 12:12:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11384' AND id_supplier = ''
13/07/2022 12:12:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11384' , '' , '1' )
13/07/2022 12:13:45 pm >> SELECT document_num FROM ps_document
WHERE document_num = '2067' AND id_document != '58931' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-28')
13/07/2022 12:13:45 pm >> UPDATE ps_document SET
id_document_type = '11',
document_num = '2067',
document_date = '2022-06-28',
document_letter = '',
id_customer = '0',
id_supplier = '',
id_address = '0',
address1 = '',
address2 = '',
note = '',
price_shipping = '0.00',
id_tax_shipping_rules = '4',
colli = '0',
peso = '0',
porto_e_imballo = '0',
mezzo_consegna = '',
id_payment = '0',
id_causal = '0',
price_tax_included = '16.50',
price_tax_excluded = '15.87',
date_upd = NOW()
WHERE id_document = '58931'
13/07/2022 12:13:45 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 = '58931'
13/07/2022 12:13:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '58931'
13/07/2022 12:13:45 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
( '58931' , '16689' , 'OSTIA PAN DI CENA mm80' , '3' , '-3' , '3' ,
'2.0000' , '1.9230769230769' , '4' , '0' , '6.00' )
13/07/2022 12:13:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = ''
13/07/2022 12:13:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '' , '1' )
13/07/2022 12:13:45 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
( '58931' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' ,
'1.75' , '1.6826923076923' , '4' , '0' , '3.50' )
13/07/2022 12:13:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = ''
13/07/2022 12:13:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '' , '1' )
13/07/2022 12:13:45 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
( '58931' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '2' , '-2' , '3' ,
'3.50' , '3.3653846153846' , '4' , '0' , '7.00' )
13/07/2022 12:13:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = ''
13/07/2022 12:13:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' )
13/07/2022 12:16:07 pm >> SELECT document_num FROM ps_document
WHERE document_num = '2159' AND id_document != '59036' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-04')
13/07/2022 12:16:07 pm >> UPDATE ps_document SET
id_document_type = '11',
document_num = '2159',
document_date = '2022-07-04',
document_letter = '',
id_customer = '0',
id_supplier = '',
id_address = '0',
address1 = 'P.ZZA DUOMO, 1 84096 MONTECORVINO ROVELLA',
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 = '314.00',
price_tax_excluded = '276.82',
date_upd = NOW()
WHERE id_document = '59036'
13/07/2022 12:16: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 = '59036'
13/07/2022 12:16:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '59036'
13/07/2022 12:16:08 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '59036' , '2777' , 'CORONCINA E NOVENA ALLA DIVINA MISERICORDIA' , '10' , '-10' , '4' ,
'2.0000' , '2' , '0' , '5' , '19.00' )
13/07/2022 12:16:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2777' AND id_supplier = ''
13/07/2022 12:16:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2777' , '' , '1' )
13/07/2022 12:16:08 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '59036' , '17526' , 'PREGHIERE EUCARISTICHE PER CONCELEBRAZIONE N.E.' , '4' , '-4' , '4' ,
'6.0000' , '6' , '0' , '5' , '22.80' )
13/07/2022 12:16:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17526' AND id_supplier = ''
13/07/2022 12:16:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17526' , '' , '1' )
13/07/2022 12:16:08 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '59036' , '7311' , 'OSTIA SOTTILE 74MM' , '14' , '-14' , '3' ,
'1.9000' , '1.8269230769231' , '4' , '0' , '26.60' )
13/07/2022 12:16:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = ''
13/07/2022 12:16:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' )
13/07/2022 12:16:08 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '59036' , '7673' , 'PARTICOLE MM38' , '7' , '-7' , '3' ,
'3.0000' , '2.8846153846154' , '4' , '0' , '21.00' )
13/07/2022 12:16:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7673' AND id_supplier = ''
13/07/2022 12:16:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7673' , '' , '1' )
13/07/2022 12:16:08 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '59036' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '2' , '-2' , '3' ,
'3.5000' , '3.3653846153846' , '4' , '0' , '7.00' )
13/07/2022 12:16:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16691' AND id_supplier = ''
13/07/2022 12:16:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16691' , '' , '1' )
13/07/2022 12:16:08 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '59036' , '15666' , 'MIRACOLOSA CM 60' , '1' , '-1' , '1' ,
'180.0000' , '147.54098360656' , '22' , '0' , '180.00' )
13/07/2022 12:16:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15666' AND id_supplier = ''
13/07/2022 12:16:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15666' , '' , '1' )
13/07/2022 12:16:08 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '59036' , '3073' , 'CROCE PRIMA COMUNIONE - LEGNO SCURO - 713/15' , '10' , '-10' , '1' ,
'1.2000' , '0.98360655737705' , '22' , '0' , '12.00' )
13/07/2022 12:16:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '3073' AND id_supplier = ''
13/07/2022 12:16:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3073' , '' , '1' )
13/07/2022 12:16:08 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '59036' , '11151' , 'LIBRI' , '1' , '-1' , '4' ,
'13.6000' , '13.6' , '0' , '0' , '13.60' )
13/07/2022 12:16:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = ''
13/07/2022 12:16:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' )
13/07/2022 12:16:08 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '59036' , '16689' , 'OSTIA PAN DI CENA mm80' , '6' , '-6' , '3' ,
'2.00' , '1.9230769230769' , '4' , '0' , '12.00' )
13/07/2022 12:16:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = ''
13/07/2022 12:16:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '' , '1' )
13/07/2022 12:22:17 pm >> SELECT document_num FROM ps_document
WHERE document_num = '2257' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-13')
13/07/2022 12:22:17 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' ,
'2257' ,
'2022-07-13' ,
'' ,
'' ,
'' ,
'' ,
'VIA CIRILLO 84085 MERCATO SAN SEVERINO' ,
'' ,
'' ,
'0.00' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'3' ,
'0' ,
'188.60' ,
'154.59' ,
NOW() ,
NOW() )
13/07/2022 12:22:17 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '59160'
13/07/2022 12:22:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '59160'
13/07/2022 12:22:17 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '59160' , '6405' , 'MENSA DIAM 40X250 - M4025' , '25' , '-25' , '1' ,
'3.4000' , '2.7869' , '22' , '0' , '85.00' )
13/07/2022 12:22:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6405' AND id_supplier = ''
13/07/2022 12:22:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6405' , '' , '1' )
13/07/2022 12:22:17 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '59160' , '1621' , 'CANDELE CONICHE 10 PZ' , '2' , '-2' , '1' ,
'6.8000' , '5.5738' , '22' , '0' , '13.60' )
13/07/2022 12:22:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1621' AND id_supplier = ''
13/07/2022 12:22:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1621' , '' , '1' )
13/07/2022 12:22:17 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '59160' , '17161' , 'CARBONCINI NERI - CARNE' , '5' , '-5' , '1' ,
'12.0000' , '9.8361' , '22' , '0' , '60.00' )
13/07/2022 12:22:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17161' AND id_supplier = ''
13/07/2022 12:22:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17161' , '' , '1' )
13/07/2022 12:22:17 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '59160' , '19107' , 'INCENSO GRANI 3A' , '1' , '-1' , '1' ,
'30.0000' , '24.5902' , '22' , '0' , '30.00' )
13/07/2022 12:22:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19107' AND id_supplier = ''
13/07/2022 12:22:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19107' , '' , '1' )
13/07/2022 12:22:25 pm >> DELETE FROM ps_document WHERE id_document = '59083'
13/07/2022 12:22:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '59083'
13/07/2022 12:52:14 pm >> SELECT document_num FROM ps_document
WHERE document_num = '2258' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-13')
13/07/2022 12:52:14 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' ,
'2258' ,
'2022-07-13' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'35.00' ,
'35.00' ,
NOW() ,
NOW() )
13/07/2022 12:52:14 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '59161'
13/07/2022 12:52:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '59161'
13/07/2022 12:52:14 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '59161' , '11151' , 'LIBRI' , '1' , '-1' , '4' ,
'35' , '35' , '0' , '0' , '35.00' )
13/07/2022 12:52:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = ''
13/07/2022 12:52:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' )
13/07/2022 04:22:03 pm >> SELECT document_num FROM ps_document
WHERE document_num = '2259' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-13')
13/07/2022 04:22:03 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' ,
'2259' ,
'2022-07-13' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'5.00' ,
'4.10' ,
NOW() ,
NOW() )
13/07/2022 04:22:03 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '59162'
13/07/2022 04:22:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '59162'
13/07/2022 04:22: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
( '59162' , '1328' , 'BRACCIALE IN ECO PELLE CON PREGHIERE - 3163' , '1' , '-1' , '1' ,
'5' , '4.0983606557377' , '22' , '0' , '5.00' )
13/07/2022 04:22:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1328' AND id_supplier = ''
13/07/2022 04:22:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1328' , '' , '1' )
13/07/2022 05:51:42 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788895983400' AND id_product != '12849' AND ean13 != ''
13/07/2022 05:51:42 pm >> UPDATE ps_product SET
id_supplier = '53',
reference = '',
ean13 = '9788895983400',
date_upd = NOW()
WHERE id_product = '12849'
13/07/2022 05:51:42 pm >> UPDATE ps_product_lang SET
name = 'LIBRO DELLE SS. MESSE',
description = 'Registri parrocchiali
Per la firma del celebrante, 2400 registrazioni.
'
WHERE id_product = '12849'
13/07/2022 05:51:42 pm >> UPDATE ps_product SET
wholesale_price = '1.40',
on_sale = '0',
price = '16.3900'
WHERE id_product = '12849'
13/07/2022 05:51:42 pm >> UPDATE ps_product_shop SET
wholesale_price = '1.40',
price = '16.3900',
id_tax_rules_group = '1',
id_category_default = '395',
id_argoment_default = '433',
id_internal_category = '4',
on_sale = '0',
on_showcase = '0',
on_offer = '1',
on_most = '00',
date_upd = NOW()
WHERE id_product = '12849'
13/07/2022 05:51:42 pm >> DELETE FROM ps_specific_price WHERE id_product = '12849'
13/07/2022 05:51:42 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' , '12849' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' )
13/07/2022 06:06:22 pm >> SELECT document_num FROM ps_document
WHERE document_num = '2260' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-13')
13/07/2022 06:06:23 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' ,
'2260' ,
'2022-07-13' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'199.80' ,
'172.71' ,
NOW() ,
NOW() )
13/07/2022 06:06:23 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '59163'
13/07/2022 06:06:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '59163'
13/07/2022 06:06:23 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '59163' , '17544' , 'CAMICE BAMBOO' , '1' , '-1' , '1' ,
'143.00' , '117.2131147541' , '22' , '0' , '143.00' )
13/07/2022 06:06:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17544' AND id_supplier = ''
13/07/2022 06:06:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17544' , '' , '1' )
13/07/2022 06:06:23 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '59163' , '18005' , 'MEDAGLIETTA CARLO ACUTIS' , '6' , '-6' , '1' ,
'1.20' , '0.98360655737705' , '22' , '0' , '7.20' )
13/07/2022 06:06:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18005' AND id_supplier = ''
13/07/2022 06:06:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18005' , '' , '1' )
13/07/2022 06:06:23 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '59163' , '2528' , 'COMPIETA' , '40' , '-40' , '4' ,
'1.30' , '1.3' , '0' , '5' , '49.60' )
13/07/2022 06:06:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2528' AND id_supplier = ''
13/07/2022 06:06:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2528' , '' , '1' )
13/07/2022 06:22:46 pm >> SELECT document_num FROM ps_document
WHERE document_num = '2261' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-13')
13/07/2022 06:22:46 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' ,
'2261' ,
'2022-07-13' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'75.00' ,
'61.48' ,
NOW() ,
NOW() )
13/07/2022 06:22:46 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 = '59164'
13/07/2022 06:22:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '59164'
13/07/2022 06:22:46 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
( '59164' , '18218' , 'DECINA LEGNO CHIARO - FR52' , '50' , '-50' , '1' ,
'0.5' , '0.40983606557377' , '22' , '0' , '25.00' )
13/07/2022 06:22:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18218' AND id_supplier = ''
13/07/2022 06:22:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18218' , '' , '1' )
13/07/2022 06:22:46 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
( '59164' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' ,
'50' , '40.983606557377' , '22' , '0' , '50.00' )
13/07/2022 06:22:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = ''
13/07/2022 06:22:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' )
13/07/2022 06:28:53 pm >> SELECT document_num FROM ps_document
WHERE document_num = '2262' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-13')
13/07/2022 06:28:53 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' ,
'2262' ,
'2022-07-13' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'24.00' ,
'19.67' ,
NOW() ,
NOW() )
13/07/2022 06:28:53 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 = '59165'
13/07/2022 06:28:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '59165'
13/07/2022 06:28: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
( '59165' , '6359' , 'MEDAGLIA SCAPOLARE ARGENTO - MM12 ' , '1' , '-1' , '1' ,
'11.00' , '9.016393442623' , '22' , '0' , '11.00' )
13/07/2022 06:28:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6359' AND id_supplier = ''
13/07/2022 06:28:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6359' , '' , '1' )
13/07/2022 06:28: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
( '59165' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' ,
'13' , '10.655737704918' , '22' , '0' , '13.00' )
13/07/2022 06:28:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = ''
13/07/2022 06:28:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' )
13/07/2022 06:29:26 pm >> SELECT document_num FROM ps_document
WHERE document_num = '2263' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-13')
13/07/2022 06:29:26 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' ,
'2263' ,
'2022-07-13' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'2.00' ,
'1.64' ,
NOW() ,
NOW() )
13/07/2022 06:29:26 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 = '59166'
13/07/2022 06:29:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '59166'
13/07/2022 06:29:26 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
( '59166' , '18896' , 'BRACCIALE DECINA CROMO - BC1759' , '1' , '-1' , '1' ,
'2.00' , '1.6393442622951' , '22' , '0' , '2.00' )
13/07/2022 06:29:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18896' AND id_supplier = ''
13/07/2022 06:29:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18896' , '' , '1' )
13/07/2022 06:32:50 pm >> SELECT document_num FROM ps_document
WHERE document_num = '1803' AND id_document != '58627' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-06')
13/07/2022 06:32:50 pm >> UPDATE ps_document SET
id_document_type = '11',
document_num = '1803',
document_date = '2022-06-06',
document_letter = '',
id_customer = '0',
id_supplier = '',
id_address = '0',
address1 = '',
address2 = '',
note = '',
price_shipping = '0.00',
id_tax_shipping_rules = '4',
colli = '0',
peso = '0',
porto_e_imballo = '0',
mezzo_consegna = '',
id_payment = '0',
id_causal = '0',
price_tax_included = '14.70',
price_tax_excluded = '14.10',
date_upd = NOW()
WHERE id_document = '58627'
13/07/2022 06:32: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 = '58627'
13/07/2022 06:32:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '58627'
13/07/2022 06:32: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
( '58627' , '18920' , 'LUCE IN FONDO - L. EPICOCO' , '1' , '-1' , '4' ,
'12.0000' , '12' , '0' , '5' , '11.40' )
13/07/2022 06:32:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18920' AND id_supplier = ''
13/07/2022 06:32:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18920' , '' , '1' )
13/07/2022 06:32: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
( '58627' , '18353' , 'PORTA ROSARIO IN VELLUTO PICCOLO - 313-NT 4' , '1' , '-1' , '1' ,
'0.8000' , '0.65573770491803' , '22' , '0' , '0.80' )
13/07/2022 06:32:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18353' AND id_supplier = ''
13/07/2022 06:32:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18353' , '' , '1' )
13/07/2022 06:32: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
( '58627' , '18218' , 'DECINA LEGNO CHIARO - FR52' , '3' , '-3' , '1' ,
'0.5' , '0.40983606557377' , '22' , '0' , '1.50' )
13/07/2022 06:32:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18218' AND id_supplier = ''
13/07/2022 06:32:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18218' , '' , '1' )
13/07/2022 06:32: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
( '58627' , '18213' , 'BRACCIALE CROCI COLORATO - BC569' , '1' , '-1' , '1' ,
'1.00' , '0.81967213114754' , '22' , '0' , '1.00' )
13/07/2022 06:32:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18213' AND id_supplier = ''
13/07/2022 06:32:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18213' , '' , '1' )