29/08/2022 08:55:48 am >> SELECT document_num FROM ps_document
WHERE document_num = '44' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-08-29')
29/08/2022 08:55: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 (
'21' ,
'44' ,
'2022-08-29' ,
'' ,
'3412' ,
'0' ,
'4670133' ,
'VIA PROVINCIALE, 776 41055 MONTESE' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'9' ,
'0' ,
'18.00' ,
'18.00' ,
NOW() ,
NOW() )
29/08/2022 08:55: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 = '5397'
29/08/2022 08:55:48 am >> DELETE FROM ps_document_detail WHERE id_document = '5397'
29/08/2022 08:55: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
( '5397' , '133' , 'LIBRO AGENDA CATTOLICO 2023' , '1' , '-1' , '4' ,
'18.00' , '18' , '0' , '0' , '18.00' )
29/08/2022 08:56:45 am >> SELECT document_num FROM ps_document
WHERE document_num = '45' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-08-29')
29/08/2022 08:56:45 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 (
'21' ,
'45' ,
'2022-08-29' ,
'' ,
'3449' ,
'0' ,
'4670097' ,
'VIA SIMEONE PARATICO, 46 25031 CAPRIOLO' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'9' ,
'0' ,
'18.00' ,
'18.00' ,
NOW() ,
NOW() )
29/08/2022 08:56:45 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 = '5398'
29/08/2022 08:56:45 am >> DELETE FROM ps_document_detail WHERE id_document = '5398'
29/08/2022 08:56: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
( '5398' , '133' , 'LIBRO AGENDA CATTOLICO 2023' , '1' , '-1' , '4' ,
'18.00' , '18' , '0' , '0' , '18.00' )
29/08/2022 09:14:44 am >> SELECT document_num FROM ps_document
WHERE document_num = '108' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-08-29')
29/08/2022 09:14: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 (
'21' ,
'108' ,
'2022-08-29' ,
'' ,
'3895' ,
'' ,
'4674649' ,
'Piazza Duomo , 1 84011 Amalfi ' ,
'' ,
'' ,
'' ,
'0' ,
'0' ,
'0' ,
'0' ,
'' ,
'1' ,
'0' ,
'75.10' ,
'75.10' ,
NOW() ,
NOW() )
29/08/2022 09:14: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 = '60520'
29/08/2022 09:14:44 am >> DELETE FROM ps_document_detail WHERE id_document = '60520'
29/08/2022 09:14:44 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '60520' , '12817' , 'LIBRO DEI MATRIMONI' , '2' , '-2' , '0' ,
'38.0030' , '38.003' , '' , '5' , '72.20' )
29/08/2022 09:14:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '12817' AND id_supplier = ''
29/08/2022 09:14:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12817' , '' , '1' )
29/08/2022 09:14:44 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '60520' , '' , 'CONTRASSEGNO' , '1' , '-1' , '4' ,
'2.90' , '2.90' , '' , '0' , '2.90' )
29/08/2022 09:14:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '' AND id_supplier = ''
29/08/2022 09:14:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '' , '' , '1' )
29/08/2022 09:14:59 am >> UPDATE ps_orders SET
current_state = '4',
delivery_date = '2022-08-20'
WHERE id_order = '368'
29/08/2022 09:15:00 am >> DELETE FROM ps_document WHERE document_num = '368' AND id_document_type = '28'
29/08/2022 09:15:29 am >> SELECT document_num FROM ps_document
WHERE document_num = '108' AND id_document != '60520' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-08-29')
29/08/2022 09:15:29 am >> UPDATE ps_document SET
id_document_type = '21',
document_num = '108',
document_date = '2022-08-29',
document_letter = '',
id_customer = '3895',
id_supplier = '',
id_address = '4674649',
address1 = 'Piazza Duomo , 1 84011 Amalfi ',
address2 = '',
note = '',
price_shipping = '0.00',
id_tax_shipping_rules = '0',
colli = '0',
peso = '0',
porto_e_imballo = '0',
mezzo_consegna = '',
id_payment = '6',
id_causal = '0',
price_tax_included = '75.10',
price_tax_excluded = '75.10',
date_upd = NOW()
WHERE id_document = '60520'
29/08/2022 09:15:29 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '60520'
29/08/2022 09:15:29 am >> DELETE FROM ps_document_detail WHERE id_document = '60520'
29/08/2022 09:15:29 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '60520' , '12817' , 'LIBRO DEI MATRIMONI' , '2' , '-2' , '0' ,
'38.0030' , '38.003' , '0' , '5' , '72.20' )
29/08/2022 09:15:29 am >> DELETE FROM ps_product_supplier WHERE id_product = '12817' AND id_supplier = ''
29/08/2022 09:15:29 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12817' , '' , '1' )
29/08/2022 09:15:29 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '60520' , '0' , 'CONTRASSEGNO' , '1' , '-1' , '4' ,
'2.9000' , '2.9' , '0' , '0' , '2.90' )
29/08/2022 09:15:29 am >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = ''
29/08/2022 09:15:29 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' )
29/08/2022 09:50:27 am >> SELECT document_num FROM ps_document
WHERE document_num = '2526' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-08-29')
29/08/2022 09:50:27 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' ,
'2526' ,
'2022-08-29' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'24.00' ,
'19.67' ,
NOW() ,
NOW() )
29/08/2022 09:50:27 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 = '60521'
29/08/2022 09:50:27 am >> DELETE FROM ps_document_detail WHERE id_document = '60521'
29/08/2022 09:50:27 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
( '60521' , '7202' , 'ARTICOLI RELIGIOSI' , '3' , '-3' , '1' ,
'8' , '6.5573770491803' , '22' , '0' , '24.00' )
29/08/2022 09:50:27 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = ''
29/08/2022 09:50:27 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' )
29/08/2022 10:04:25 am >> SELECT document_num FROM ps_document
WHERE document_num = '2527' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-08-29')
29/08/2022 10:04:25 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' ,
'2527' ,
'2022-08-29' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'132.00' ,
'108.20' ,
NOW() ,
NOW() )
29/08/2022 10:04:25 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '60522'
29/08/2022 10:04:25 am >> DELETE FROM ps_document_detail WHERE id_document = '60522'
29/08/2022 10:04:25 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '60522' , '18426' , 'CAMICE BENEDETTINO MISTO LINO - 378' , '1' , '-1' , '1' ,
'132' , '108.19672131148' , '22' , '0' , '132.00' )
29/08/2022 10:04:25 am >> DELETE FROM ps_product_supplier WHERE id_product = '18426' AND id_supplier = ''
29/08/2022 10:04:25 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18426' , '' , '1' )
29/08/2022 10:07:54 am >> SELECT document_num FROM ps_document
WHERE document_num = '2528' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-08-29')
29/08/2022 10:07:54 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' ,
'2528' ,
'2022-08-29' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'9.50' ,
'9.13' ,
NOW() ,
NOW() )
29/08/2022 10:07:54 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 = '60523'
29/08/2022 10:07:54 am >> DELETE FROM ps_document_detail WHERE id_document = '60523'
29/08/2022 10:07:54 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
( '60523' , '7311' , 'OSTIA SOTTILE 74MM' , '5' , '-5' , '3' ,
'1.90' , '1.8269230769231' , '4' , '0' , '9.50' )
29/08/2022 10:07:54 am >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = ''
29/08/2022 10:07:54 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' )
29/08/2022 10:26:22 am >> SELECT document_num FROM ps_document
WHERE document_num = '2529' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-08-29')
29/08/2022 10:26:22 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' ,
'2529' ,
'2022-08-29' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'11.00' ,
'9.02' ,
NOW() ,
NOW() )
29/08/2022 10:26:22 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '60524'
29/08/2022 10:26:22 am >> DELETE FROM ps_document_detail WHERE id_document = '60524'
29/08/2022 10:26:22 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '60524' , '14063' , 'STELLARIO PLEX CM 10 / 12' , '1' , '-1' , '1' ,
'11.00' , '9.016393442623' , '22' , '0' , '11.00' )
29/08/2022 10:26:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '14063' AND id_supplier = ''
29/08/2022 10:26:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14063' , '' , '1' )
29/08/2022 10:41:55 am >> SELECT document_num FROM ps_document
WHERE document_num = '54/A' AND id_document != '59768' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-07-23')
29/08/2022 10:41:55 am >> UPDATE ps_document SET
id_document_type = '24',
document_num = '54/A',
document_date = '2022-07-23',
document_letter = 'A',
id_customer = '230',
id_supplier = '',
id_address = '4668969',
address1 = 'VIA G. NICOTERA, 66 84080 PELLEZZANO',
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 = '320.00',
price_tax_excluded = '262.30',
date_upd = NOW()
WHERE id_document = '59768'
29/08/2022 10:41:55 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '59768'
29/08/2022 10:41:55 am >> DELETE FROM ps_document_detail WHERE id_document = '59768'
29/08/2022 10:41:55 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '59768' , '1914' , 'CERA DELLA LITURGIA' , '60' , '-60' , '1' ,
'4.5000' , '3.6885245901639' , '22' , '0' , '270.00' )
29/08/2022 10:41:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = ''
29/08/2022 10:41:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' )
29/08/2022 10:41:55 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '59768' , '15387' , 'VESTINA BATTESIMALE ' , '20' , '-20' , '1' ,
'2.5' , '2.0491803278689' , '22' , '0' , '50.00' )
29/08/2022 10:41:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '15387' AND id_supplier = ''
29/08/2022 10:41:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15387' , '' , '1' )
29/08/2022 10:46:21 am >> SELECT document_num FROM ps_document
WHERE document_num = '2530' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-08-29')
29/08/2022 10:46:21 am >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'2530' ,
'2022-08-29' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'19.00' ,
'19.00' ,
NOW() ,
NOW() )
29/08/2022 10:46:21 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '60525'
29/08/2022 10:46:21 am >> DELETE FROM ps_document_detail WHERE id_document = '60525'
29/08/2022 10:46:21 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '60525' , '19622' , 'SULLA TUA PAROLA - SETT/OTT 2022' , '4' , '-4' , '4' ,
'5.00' , '5' , '0' , '5' , '19.00' )
29/08/2022 10:46:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '19622' AND id_supplier = ''
29/08/2022 10:46:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19622' , '' , '1' )
29/08/2022 10:48:35 am >> SELECT document_num FROM ps_document
WHERE document_num = '2384' AND id_document != '59828' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-28')
29/08/2022 10:48:35 am >> UPDATE ps_document SET
id_document_type = '11',
document_num = '2384',
document_date = '2022-07-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 = '407.00',
price_tax_excluded = '339.02',
date_upd = NOW()
WHERE id_document = '59828'
29/08/2022 10:48: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 = '59828'
29/08/2022 10:48:35 am >> DELETE FROM ps_document_detail WHERE id_document = '59828'
29/08/2022 10:48: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
( '59828' , '795' , 'ASTUCCIO A 3 OLI SANTI IN ALLUMINIO - 1958' , '1' , '-1' , '1' ,
'67.0000' , '54.918032786885' , '22' , '0' , '67.00' )
29/08/2022 10:48:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '795' AND id_supplier = ''
29/08/2022 10:48:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '795' , '' , '1' )
29/08/2022 10:48: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
( '59828' , '17101' , 'CASULA POLIESTERE CROCE ORO - AECU04' , '4' , '-4' , '1' ,
'70.0000' , '57.377049180328' , '22' , '0' , '280.00' )
29/08/2022 10:48:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '17101' AND id_supplier = ''
29/08/2022 10:48:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17101' , '' , '1' )
29/08/2022 10:48: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
( '59828' , '19727' , 'LITURGIA IN FRAMMENTI - A. SORRENTINO' , '1' , '-1' , '4' ,
'30' , '30' , '0' , '0' , '30.00' )
29/08/2022 10:48:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '19727' AND id_supplier = ''
29/08/2022 10:48:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19727' , '' , '1' )
29/08/2022 10:48: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
( '59828' , '547' , 'AMPOLLINE E VASSOIO IN VETRO - 506' , '1' , '-1' , '1' ,
'30.0000' , '24.590163934426' , '22' , '0' , '30.00' )
29/08/2022 10:48:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '547' AND id_supplier = ''
29/08/2022 10:48:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '547' , '' , '1' )
29/08/2022 10:50:25 am >> SELECT document_num FROM ps_document
WHERE document_num = '2526' AND id_document != '60521' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-08-29')
29/08/2022 10:50:25 am >> UPDATE ps_document SET
id_document_type = '11',
document_num = '2526',
document_date = '2022-08-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 = '24.00',
price_tax_excluded = '19.67',
date_upd = NOW()
WHERE id_document = '60521'
29/08/2022 10:50:25 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '60521'
29/08/2022 10:50:25 am >> DELETE FROM ps_document_detail WHERE id_document = '60521'
29/08/2022 10:50:25 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '60521' , '12123' , 'MERLETTO CM 10,5 - CROCE E CALICE' , '5' , '-5' , '1' ,
'4.8' , '3.9344262295082' , '22' , '0' , '24.00' )
29/08/2022 10:50:25 am >> DELETE FROM ps_product_supplier WHERE id_product = '12123' AND id_supplier = ''
29/08/2022 10:50:25 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12123' , '' , '1' )
29/08/2022 10:58:27 am >> SELECT document_num FROM ps_document
WHERE document_num = '2531' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-08-29')
29/08/2022 10:58:27 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' ,
'2531' ,
'2022-08-29' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'4.75' ,
'4.75' ,
NOW() ,
NOW() )
29/08/2022 10:58:27 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 = '60526'
29/08/2022 10:58:27 am >> DELETE FROM ps_document_detail WHERE id_document = '60526'
29/08/2022 10:58:27 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
( '60526' , '19622' , 'SULLA TUA PAROLA - SETT/OTT 2022' , '1' , '-1' , '4' ,
'5.00' , '5' , '0' , '5' , '4.75' )
29/08/2022 10:58:27 am >> DELETE FROM ps_product_supplier WHERE id_product = '19622' AND id_supplier = ''
29/08/2022 10:58:28 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19622' , '' , '1' )
29/08/2022 11:11:10 am >> SELECT document_num FROM ps_document
WHERE document_num = '2532' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-08-29')
29/08/2022 11:11:10 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' ,
'2532' ,
'2022-08-29' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'100.00' ,
'81.97' ,
NOW() ,
NOW() )
29/08/2022 11:11:10 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 = '60527'
29/08/2022 11:11:10 am >> DELETE FROM ps_document_detail WHERE id_document = '60527'
29/08/2022 11:11:10 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
( '60527' , '19771' , 'ROSARIO ARGENTO/EMATITE' , '1' , '-1' , '1' ,
'30' , '24.590163934426' , '22' , '0' , '30.00' )
29/08/2022 11:11:10 am >> DELETE FROM ps_product_supplier WHERE id_product = '19771' AND id_supplier = ''
29/08/2022 11:11:10 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19771' , '' , '1' )
29/08/2022 11:11:10 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
( '60527' , '16070' , 'CASULA - PCA020' , '1' , '-1' , '1' ,
'70' , '57.377049180328' , '22' , '0' , '70.00' )
29/08/2022 11:11:10 am >> DELETE FROM ps_product_supplier WHERE id_product = '16070' AND id_supplier = ''
29/08/2022 11:11:10 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16070' , '' , '1' )
29/08/2022 11:32:17 am >> SELECT document_num FROM ps_document
WHERE document_num = '2533' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-08-29')
29/08/2022 11:32:17 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' ,
'2533' ,
'2022-08-29' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'12.20' ,
'11.57' ,
NOW() ,
NOW() )
29/08/2022 11:32: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 = '60528'
29/08/2022 11:32:17 am >> DELETE FROM ps_document_detail WHERE id_document = '60528'
29/08/2022 11:32: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
( '60528' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '1' , '-1' , '3' ,
'3.50' , '3.3653846153846' , '4' , '0' , '3.50' )
29/08/2022 11:32:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = ''
29/08/2022 11:32:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' )
29/08/2022 11:32: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
( '60528' , '7311' , 'OSTIA SOTTILE 74MM' , '4' , '-4' , '3' ,
'1.90' , '1.8269230769231' , '4' , '0' , '7.60' )
29/08/2022 11:32:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = ''
29/08/2022 11:32:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' )
29/08/2022 11:32: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
( '60528' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '1' , '-1' , '1' ,
'1.10' , '0.9016393442623' , '22' , '0' , '1.10' )
29/08/2022 11:32:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '18122' AND id_supplier = ''
29/08/2022 11:32:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18122' , '' , '1' )
29/08/2022 11:48:55 am >> SELECT document_num FROM ps_document
WHERE document_num = '2534' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-08-29')
29/08/2022 11:48:55 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' ,
'2534' ,
'2022-08-29' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'4.75' ,
'4.75' ,
NOW() ,
NOW() )
29/08/2022 11:48:55 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '60529'
29/08/2022 11:48:55 am >> DELETE FROM ps_document_detail WHERE id_document = '60529'
29/08/2022 11:48:55 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '60529' , '19622' , 'SULLA TUA PAROLA - SETT/OTT 2022' , '1' , '-1' , '4' ,
'5.00' , '5' , '0' , '5' , '4.75' )
29/08/2022 11:48:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '19622' AND id_supplier = ''
29/08/2022 11:48:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19622' , '' , '1' )
29/08/2022 12:30:33 pm >> SELECT document_num FROM ps_document
WHERE document_num = '2535' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-08-29')
29/08/2022 12:30:33 pm >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'2535' ,
'2022-08-29' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'7.42' ,
'7.42' ,
NOW() ,
NOW() )
29/08/2022 12:30:33 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '60530'
29/08/2022 12:30:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '60530'
29/08/2022 12:30:33 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '60530' , '19684' , 'AMEN - SET. 2022' , '1' , '-1' , '4' ,
'3.90' , '3.9' , '0' , '5' , '3.71' )
29/08/2022 12:30:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19684' AND id_supplier = ''
29/08/2022 12:30:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19684' , '' , '1' )
29/08/2022 12:30:34 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '60530' , '19685' , 'AMEN - OTT 2022' , '1' , '-1' , '4' ,
'3.90' , '3.9' , '0' , '5' , '3.71' )
29/08/2022 12:30:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19685' AND id_supplier = ''
29/08/2022 12:30:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19685' , '' , '1' )
29/08/2022 12:37:16 pm >> SELECT document_num FROM ps_document
WHERE document_num = '62/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-08-29')
29/08/2022 12:37:16 pm >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'24' ,
'62/A' ,
'2022-08-29' ,
'A' ,
'188' ,
'0' ,
'4668955' ,
'VIA ROMA 84121 SALERNO' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'171.60' ,
'143.72' ,
NOW() ,
NOW() )
29/08/2022 12:37:16 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 = '60531'
29/08/2022 12:37:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '60531'
29/08/2022 12:37:16 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
( '60531' , '15387' , 'VESTINA BATTESIMALE ' , '60' , '-60' , '1' ,
'2.5' , '2.0491803278689' , '22' , '0' , '150.00' )
29/08/2022 12:37:16 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
( '60531' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '4' , '-4' , '3' ,
'3.50' , '3.3653846153846' , '4' , '0' , '14.00' )
29/08/2022 12:37:16 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
( '60531' , '7311' , 'OSTIA SOTTILE 74MM' , '4' , '-4' , '3' ,
'1.90' , '1.8269230769231' , '4' , '0' , '7.60' )
29/08/2022 02:42:48 pm >> SELECT document_num FROM ps_document
WHERE document_num = '46' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-08-29')
29/08/2022 02:42:48 pm >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'21' ,
'46' ,
'2022-08-29' ,
'' ,
'3347' ,
'0' ,
'4669949' ,
'LARGO DELLA VITTORIA, 4 25065 LUMEZZANE' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'3' ,
'0' ,
'90.00' ,
'90.00' ,
NOW() ,
NOW() )
29/08/2022 02:42:48 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '5399'
29/08/2022 02:42:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '5399'
29/08/2022 02:42:48 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '5399' , '133' , 'LIBRO AGENDA CATTOLICO 2023' , '5' , '-5' , '4' ,
'18.00' , '18' , '0' , '0' , '90.00' )
29/08/2022 02:47:04 pm >> SELECT document_num FROM ps_document
WHERE document_num = '47' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-08-29')
29/08/2022 02:47:04 pm >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'21' ,
'47' ,
'2022-08-29' ,
'' ,
'3350' ,
'0' ,
'4669953' ,
'VIA RISORGIMENTO, 2 37068 VIGASIO ' ,
'' ,
'' ,
'4.9' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'6' ,
'0' ,
'22.00' ,
'22.00' ,
NOW() ,
NOW() )
29/08/2022 02:47:04 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '5400'
29/08/2022 02:47:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '5400'
29/08/2022 02:47:04 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '5400' , '133' , 'LIBRO AGENDA CATTOLICO 2023' , '1' , '-1' , '4' ,
'18.00' , '18' , '0' , '5' , '17.10' )
29/08/2022 02:48:35 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788887688412' AND id_product != '9' AND ean13 != ''
29/08/2022 02:48:35 pm >> UPDATE ps_product SET
id_supplier = '',
reference = '',
ean13 = '9788887688412',
date_upd = NOW()
WHERE id_product = '9'
29/08/2022 02:48:35 pm >> UPDATE ps_product_lang SET
name = 'PSICOLOGIA PRATICA PER EDUCATORI',
description = ''
WHERE id_product = '9'
29/08/2022 02:48:35 pm >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '10.50'
WHERE id_product = '9'
29/08/2022 02:48:35 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '10.50',
id_tax_rules_group = '4',
id_category_default = '2',
id_argoment_default = '',
id_internal_category = '',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '9'
29/08/2022 02:48:35 pm >> DELETE FROM ps_specific_price WHERE id_product = '9'
29/08/2022 02:48:52 pm >> SELECT document_num FROM ps_document
WHERE document_num = '48' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-08-29')
29/08/2022 02:48:52 pm >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'21' ,
'48' ,
'2022-08-29' ,
'' ,
'112' ,
'0' ,
'112' ,
'P.ZZA SACRO CUORE, 1 27053 LUNGAVILLA' ,
'' ,
'' ,
'6.9' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'6' ,
'0' ,
'16.87' ,
'16.87' ,
NOW() ,
NOW() )
29/08/2022 02:48:52 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '5401'
29/08/2022 02:48:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '5401'
29/08/2022 02:48:52 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '5401' , '9' , 'PSICOLOGIA PRATICA PER EDUCATORI' , '1' , '-1' , '4' ,
'10.50' , '10.5' , '0' , '5' , '9.97' )
29/08/2022 02:53:21 pm >> INSERT INTO ps_customer
( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` )
VALUES
( '1' , '' , '' , '' , 'LeQiHI2p47hxPhDy' , NOW() , NOW() )
29/08/2022 02:53:21 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '3897' , '1' )
29/08/2022 02:53:21 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '3897' , '2' )
29/08/2022 02:53:21 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '3897' , '3' )
29/08/2022 02:55:23 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3897'
29/08/2022 02:55:23 pm >> INSERT INTO ps_address
( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd )
VALUES (
'3897' ,
'10' ,
'162' ,
'PARROCCHIA SAN GIUSEPPE' ,
'' ,
'' ,
'PIAZZALE DON PINO DE LUISA 2' ,
'' ,
'34074' ,
'MONFALCONE' ,
'' ,
'' ,
'3287861173' ,
'' ,
'' ,
NOW() ,
NOW() )
29/08/2022 02:55:23 pm >> UPDATE ps_customer SET
email = '',
sdi = '',
pec = 'parr.sgiuseppe.monf@gmail.com',
date_upd = NOW()
WHERE id_customer = '3897'
29/08/2022 02:56:15 pm >> SELECT document_num FROM ps_document
WHERE document_num = '109' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-08-29')
29/08/2022 02:56:15 pm >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'21' ,
'109' ,
'2022-08-29' ,
'' ,
'3897' ,
'0' ,
'4674650' ,
'PIAZZALE DON PINO DE LUISA 2 34074 MONFALCONE' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'3' ,
'0' ,
'72.20' ,
'59.18' ,
NOW() ,
NOW() )
29/08/2022 02:56:15 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '60532'
29/08/2022 02:56:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '60532'
29/08/2022 02:56:16 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
( '60532' , '12814' , 'LIBRO DEI BATTEZZATI' , '1' , '-1' , '1' ,
'38.00' , '31.147540983607' , '22' , '5' , '36.10' )
29/08/2022 02:56:16 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
( '60532' , '12815' , 'LIBRO DEI CRESIMATI' , '1' , '-1' , '1' ,
'38.00' , '31.147540983607' , '22' , '5' , '36.10' )
29/08/2022 02:57:28 pm >> SELECT document_num FROM ps_document
WHERE document_num = '109' AND id_document != '60532' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-08-29')
29/08/2022 02:57:28 pm >> UPDATE ps_document SET
id_document_type = '21',
document_num = '109',
document_date = '2022-08-29',
document_letter = '',
id_customer = '3897',
id_supplier = '',
id_address = '4674650',
address1 = 'PIAZZALE DON PINO DE LUISA 2 34074 MONFALCONE',
address2 = '',
note = '',
price_shipping = '0.00',
id_tax_shipping_rules = '4',
colli = '0',
peso = '0',
porto_e_imballo = '0',
mezzo_consegna = '',
id_payment = '3',
id_causal = '0',
price_tax_included = '72.20',
price_tax_excluded = '72.20',
date_upd = NOW()
WHERE id_document = '60532'
29/08/2022 02:57:28 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '60532'
29/08/2022 02:57:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '60532'
29/08/2022 02:57:28 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '60532' , '12814' , 'LIBRO DEI BATTEZZATI' , '1' , '-1' , '0' ,
'38.0000' , '38' , '' , '5' , '36.10' )
29/08/2022 02:57:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12814' AND id_supplier = ''
29/08/2022 02:57:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12814' , '' , '1' )
29/08/2022 02:57:28 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '60532' , '12815' , 'LIBRO DEI CRESIMATI' , '1' , '-1' , '0' ,
'38.0000' , '38' , '' , '5' , '36.10' )
29/08/2022 02:57:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12815' AND id_supplier = ''
29/08/2022 02:57:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12815' , '' , '1' )
29/08/2022 03:11:19 pm >> UPDATE ps_address SET
id_state = '210',
lastname = 'ARGO STUDIO S.R.L.',
address1 = 'VIA TERRE RISAIE 13',
address2 = '',
postcode = '84131',
dni = '',
vat_number = '05580570652',
city = 'SALERNO',
phone = '089792757',
phone_mobile = '',
date_upd = NOW()
WHERE id_supplier = '53'
29/08/2022 03:11:19 pm >> UPDATE ps_supplier SET
email = 'info@argostudioadv.it',
name = 'ARGO STUDIO S.R.L.',
date_upd = NOW()
WHERE id_supplier = '53'
29/08/2022 03:11:19 pm >> UPDATE ps_supplier_lang SET
description = '',
meta_title = '',
meta_description = ''
WHERE id_supplier = '53'
29/08/2022 03:14:23 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788899571245' AND id_product != '111' AND ean13 != ''
29/08/2022 03:14:24 pm >> UPDATE ps_product SET
id_supplier = '',
reference = '',
ean13 = '9788899571245',
date_upd = NOW()
WHERE id_product = '111'
29/08/2022 03:14:24 pm >> UPDATE ps_product_lang SET
name = 'I NONNI SONO UN TESORO',
description = '
Il compito educativo dei nonni è molto importante quando i genitori non sono in grado di assicurare un\'adeguata educazione ai figli.
La festa dei nonni fissata da Papa Francesco e questo libretto vogliono essere un omaggio ai nonni e un dono per i nipoti
'
WHERE id_product = '111'
29/08/2022 03:14:24 pm >> UPDATE ps_product SET
wholesale_price = '0.33',
on_sale = '0',
price = '1.8'
WHERE id_product = '111'
29/08/2022 03:14:24 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.33',
price = '1.8',
id_tax_rules_group = '4',
id_category_default = '2',
id_argoment_default = '',
id_internal_category = '',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '1',
date_upd = NOW()
WHERE id_product = '111'
29/08/2022 03:14:24 pm >> DELETE FROM ps_specific_price WHERE id_product = '111'
29/08/2022 03:14:24 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' , '111' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' )
29/08/2022 03:14:32 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788899571238' AND id_product != '110' AND ean13 != ''
29/08/2022 03:14:32 pm >> UPDATE ps_product SET
id_supplier = '',
reference = '',
ean13 = '9788899571238',
date_upd = NOW()
WHERE id_product = '110'
29/08/2022 03:14:32 pm >> UPDATE ps_product_lang SET
name = 'SE MI AMI NON PIANGERE',
description = 'Perdere una persona\r\ncara genera uno dei dolori più grandi che si\r\npossano provare nella vita.
La morte sembra\r\nla fine di tutto, sembra il distacco totale da chi\r\nabbiamo amato e continuiamo ad amare.
Questo\r\nlibretto, in base alla visione di\r\napertura e di speranza legate alla Risurrezione, vuole dire, a chi ha\r\nperduto delle persone care, alcuni\r\npensieri e poche ma essenziali preghiere di conforto
\r\nspirituale.
'
WHERE id_product = '110'
29/08/2022 03:14:32 pm >> UPDATE ps_product SET
wholesale_price = '0.30',
on_sale = '0',
price = '1.8'
WHERE id_product = '110'
29/08/2022 03:14:32 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.30',
price = '1.8',
id_tax_rules_group = '4',
id_category_default = '2',
id_argoment_default = '',
id_internal_category = '',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '1',
date_upd = NOW()
WHERE id_product = '110'
29/08/2022 03:14:32 pm >> DELETE FROM ps_specific_price WHERE id_product = '110'
29/08/2022 03:14:32 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' , '110' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' )
29/08/2022 03:14:43 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788899571313' AND id_product != '117' AND ean13 != ''
29/08/2022 03:14:43 pm >> UPDATE ps_product SET
id_supplier = '',
reference = '',
ean13 = '9788899571313',
date_upd = NOW()
WHERE id_product = '117'
29/08/2022 03:14:43 pm >> UPDATE ps_product_lang SET
name = 'La preghiera delle cinque dita n.e.',
description = 'Un piccolo testo sulla preghiera \"delle cinque dita\"di Papa Francesco, per avvicinare i più piccoli alla\r\npreghiera.
Pregare, secondo le intenzioni che ci suggerisce Papa Francesco,\r\nti aiuterà a comprendere meglio l\'importanza degli altri nella\r\ntua vita, ad aiutare gli altri attraverso la preghiera.
'
WHERE id_product = '117'
29/08/2022 03:14:43 pm >> UPDATE ps_product SET
wholesale_price = '0.32',
on_sale = '0',
price = '1.8'
WHERE id_product = '117'
29/08/2022 03:14:43 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.32',
price = '1.8',
id_tax_rules_group = '4',
id_category_default = '2',
id_argoment_default = '',
id_internal_category = '',
on_sale = '0',
on_showcase = '1',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '117'
29/08/2022 03:14:43 pm >> DELETE FROM ps_specific_price WHERE id_product = '117'
29/08/2022 03:14:43 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' , '117' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' )
29/08/2022 03:14:51 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 (
'31' ,
'342' ,
'2022-08-11' ,
'' ,
'0' ,
'53' ,
'2648' ,
'VIA TERRE RISAIE 13 84131 SALERNO' ,
'' ,
'' ,
'0.36' ,
'3' ,
'0' ,
'0' ,
'0' ,
'' ,
'3' ,
'0' ,
'1497.60' ,
'1440.00' ,
NOW() ,
NOW() )
29/08/2022 03:14:51 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 = '5402'
29/08/2022 03:14:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '5402'
29/08/2022 03:14:51 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
( '5402' , '111' , 'I NONNI SONO UN TESORO' , '3000' , '3000' , '3' ,
'0.2116' , '0.20346153846154' , '4' , '10' , '594.1728' )
29/08/2022 03:14:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '111' AND id_supplier = '53'
29/08/2022 03:14:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '111' , '53' , '1' )
29/08/2022 03:14:51 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
( '5402' , '110' , 'SE MI AMI NON PIANGERE' , '3000' , '3000' , '3' ,
'0.2116' , '0.20346153846154' , '4' , '10' , '594.1728' )
29/08/2022 03:14:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '110' AND id_supplier = '53'
29/08/2022 03:14:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '110' , '53' , '1' )
29/08/2022 03:14:51 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
( '5402' , '117' , 'La preghiera delle cinque dita n.e.' , '1000' , '1000' , '3' ,
'0.33' , '0.31730769230769' , '4' , '10' , '308.8800' )
29/08/2022 03:14:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '117' AND id_supplier = '53'
29/08/2022 03:14:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '117' , '53' , '1' )
29/08/2022 03:18:55 pm >> SELECT document_num FROM ps_document
WHERE document_num = '1514' AND id_document != '57252' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-13')
29/08/2022 03:18:55 pm >> UPDATE ps_document SET
id_document_type = '11',
document_num = '1514',
document_date = '2022-05-13',
document_letter = '',
id_customer = '0',
id_supplier = '',
id_address = '0',
address1 = 'P.ZZA S. MICHELE 83029 SOLOFRA',
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 = '170.00',
price_tax_excluded = '139.34',
date_upd = NOW()
WHERE id_document = '57252'
29/08/2022 03:18:55 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '57252'
29/08/2022 03:18:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '57252'
29/08/2022 03:18:55 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '57252' , '15921' , 'SERVIZIO MESSA LINO 100% - 74301' , '1' , '-1' , '1' ,
'115.0000' , '94.262295081967' , '22' , '0' , '115.00' )
29/08/2022 03:18:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15921' AND id_supplier = ''
29/08/2022 03:18:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15921' , '' , '1' )
29/08/2022 03:18:55 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '57252' , '3098' , 'CROCE SAGOMATA BRINATO ARG. STRASS CM 21' , '1' , '-1' , '1' ,
'20' , '16.393442622951' , '22' , '0' , '20.00' )
29/08/2022 03:18:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '3098' AND id_supplier = ''
29/08/2022 03:18:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3098' , '' , '1' )
29/08/2022 03:18:55 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '57252' , '19594' , 'POLO JERSEY COTONE 100%' , '1' , '-1' , '1' ,
'35.0000' , '28.688524590164' , '22' , '0' , '35.00' )
29/08/2022 03:18:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19594' AND id_supplier = ''
29/08/2022 03:18:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19594' , '' , '1' )
29/08/2022 03:20:01 pm >> SELECT document_num FROM ps_document
WHERE document_num = '1235' AND id_document != '55891' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-04-23')
29/08/2022 03:20:01 pm >> UPDATE ps_document SET
id_document_type = '11',
document_num = '1235',
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 = '500.00',
price_tax_excluded = '409.84',
date_upd = NOW()
WHERE id_document = '55891'
29/08/2022 03:20:01 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 = '55891'
29/08/2022 03:20:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '55891'
29/08/2022 03:20:01 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
( '55891' , '17404' , 'CASULA RIGATA' , '1' , '-1' , '1' ,
'270.0000' , '221.31147540984' , '22' , '0' , '270.00' )
29/08/2022 03:20:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17404' AND id_supplier = ''
29/08/2022 03:20:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17404' , '' , '1' )
29/08/2022 03:20:01 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
( '55891' , '19147' , 'CANDELINE NON GOCCIOLANTI GRECHE' , '2' , '-2' , '1' ,
'15.9000' , '13.032786885246' , '22' , '0' , '31.80' )
29/08/2022 03:20:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19147' AND id_supplier = ''
29/08/2022 03:20:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19147' , '' , '1' )
29/08/2022 03:20:02 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '55891' , '11384' , 'VINO BIANCO DOLCE - 102' , '3' , '-3' , '1' ,
'7.5000' , '6.1475409836066' , '22' , '0' , '22.50' )
29/08/2022 03:20:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11384' AND id_supplier = ''
29/08/2022 03:20:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11384' , '' , '1' )
29/08/2022 03:20:02 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '55891' , '19107' , 'INCENSO GRANI 3A' , '1' , '-1' , '1' ,
'30.0000' , '24.590163934426' , '22' , '0' , '30.00' )
29/08/2022 03:20:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19107' AND id_supplier = ''
29/08/2022 03:20:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19107' , '' , '1' )
29/08/2022 03:20:02 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '55891' , '794' , 'ASTUCCIO 3 BOTTIGLIE CC125 - 964' , '1' , '-1' , '1' ,
'95.0000' , '77.868852459016' , '22' , '0' , '95.00' )
29/08/2022 03:20:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '794' AND id_supplier = ''
29/08/2022 03:20:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '794' , '' , '1' )
29/08/2022 03:20:02 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '55891' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' ,
'6.2' , '5.0819672131148' , '22' , '0' , '6.20' )
29/08/2022 03:20:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = ''
29/08/2022 03:20:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' )
29/08/2022 03:20:02 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '55891' , '18247' , 'CLERGY JEANS NIDO DAPE MM - M' , '1' , '-1' , '1' ,
'40.0000' , '32.786885245902' , '22' , '0' , '40.00' )
29/08/2022 03:20:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18247' AND id_supplier = ''
29/08/2022 03:20:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18247' , '' , '1' )
29/08/2022 03:20:02 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '55891' , '12689' , 'IMMAGINI 50X70' , '1' , '-1' , '1' ,
'4.50' , '3.6885245901639' , '22' , '0' , '4.50' )
29/08/2022 03:20:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12689' AND id_supplier = ''
29/08/2022 03:20:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12689' , '' , '1' )
29/08/2022 03:23:25 pm >> SELECT document_num FROM ps_document
WHERE document_num = '2478' AND id_document != '59959' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-08-09')
29/08/2022 03:23:25 pm >> UPDATE ps_document SET
id_document_type = '11',
document_num = '2478',
document_date = '2022-08-09',
document_letter = '',
id_customer = '0',
id_supplier = '',
id_address = '0',
address1 = '',
address2 = '',
note = '',
price_shipping = '0.00',
id_tax_shipping_rules = '4',
colli = '0',
peso = '0',
porto_e_imballo = '0',
mezzo_consegna = '',
id_payment = '0',
id_causal = '0',
price_tax_included = '37.00',
price_tax_excluded = '30.33',
date_upd = NOW()
WHERE id_document = '59959'
29/08/2022 03:23:25 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '59959'
29/08/2022 03:23:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '59959'
29/08/2022 03:23:25 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '59959' , '15208' , 'ANELLO DECINA CON CRISTALLI - ARG 925' , '1' , '-1' , '1' ,
'19.0000' , '15.573770491803' , '22' , '0' , '19.00' )
29/08/2022 03:23:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15208' AND id_supplier = ''
29/08/2022 03:23:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15208' , '' , '1' )
29/08/2022 03:23:25 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '59959' , '2963' , 'CROCE DA COLLO - CM 9 - OGGETTI' , '1' , '-1' , '1' ,
'18' , '14.754098360656' , '22' , '0' , '18.00' )
29/08/2022 03:23:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2963' AND id_supplier = ''
29/08/2022 03:23:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2963' , '' , '1' )
29/08/2022 03:24:34 pm >> SELECT document_num FROM ps_document
WHERE document_num = '1673' AND id_document != '58470' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-27')
29/08/2022 03:24:34 pm >> UPDATE ps_document SET
id_document_type = '11',
document_num = '1673',
document_date = '2022-05-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 = '148.50',
price_tax_excluded = '121.72',
date_upd = NOW()
WHERE id_document = '58470'
29/08/2022 03:24:34 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58470'
29/08/2022 03:24:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '58470'
29/08/2022 03:24:34 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58470' , '7924' , 'PERGAMENE - BATTESIMO MOD. A' , '65' , '-65' , '1' ,
'0.5000' , '0.40983606557377' , '22' , '0' , '32.50' )
29/08/2022 03:24:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7924' AND id_supplier = ''
29/08/2022 03:24:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7924' , '' , '1' )
29/08/2022 03:24:34 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58470' , '15774' , 'INCENSO NARJAN - 500G' , '2' , '-2' , '1' ,
'25.0000' , '20.491803278689' , '22' , '0' , '50.00' )
29/08/2022 03:24:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15774' AND id_supplier = ''
29/08/2022 03:24:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15774' , '' , '1' )
29/08/2022 03:24:34 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58470' , '3073' , 'CROCE PRIMA COMUNIONE - LEGNO SCURO - 713/15' , '5' , '-5' , '1' ,
'1.2000' , '0.98360655737705' , '22' , '0' , '6.00' )
29/08/2022 03:24:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '3073' AND id_supplier = ''
29/08/2022 03:24:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3073' , '' , '1' )
29/08/2022 03:24:34 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58470' , '13562' , 'CORONCINA IN STOFFA CON ROSE E FOGLIOLINE - 3311' , '3' , '-3' , '1' ,
'6.0000' , '4.9180327868852' , '22' , '0' , '18.00' )
29/08/2022 03:24:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13562' AND id_supplier = ''
29/08/2022 03:24:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13562' , '' , '1' )
29/08/2022 03:24:34 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58470' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' ,
'3.5' , '2.8688524590164' , '22' , '0' , '42.00' )
29/08/2022 03:24:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = ''
29/08/2022 03:24:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' )
29/08/2022 03:26:20 pm >> SELECT document_num FROM ps_document
WHERE document_num = '1235' AND id_document != '55891' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-04-23')
29/08/2022 03:26:20 pm >> UPDATE ps_document SET
id_document_type = '11',
document_num = '1235',
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 = '500.00',
price_tax_excluded = '409.84',
date_upd = NOW()
WHERE id_document = '55891'
29/08/2022 03:26:20 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '55891'
29/08/2022 03:26:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '55891'
29/08/2022 03:26:20 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '55891' , '17404' , 'CASULA RIGATA' , '1' , '-1' , '1' ,
'270.0000' , '221.31147540984' , '22' , '0' , '270.00' )
29/08/2022 03:26:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17404' AND id_supplier = ''
29/08/2022 03:26:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17404' , '' , '1' )
29/08/2022 03:26:20 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '55891' , '19147' , 'CANDELINE NON GOCCIOLANTI GRECHE' , '2' , '-2' , '1' ,
'15.9000' , '13.032786885246' , '22' , '0' , '31.80' )
29/08/2022 03:26:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19147' AND id_supplier = ''
29/08/2022 03:26:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19147' , '' , '1' )
29/08/2022 03:26:20 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '55891' , '11384' , 'VINO BIANCO DOLCE - 102' , '3' , '-3' , '1' ,
'7.5000' , '6.1475409836066' , '22' , '0' , '22.50' )
29/08/2022 03:26:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11384' AND id_supplier = ''
29/08/2022 03:26:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11384' , '' , '1' )
29/08/2022 03:26:21 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
( '55891' , '19107' , 'INCENSO GRANI 3A' , '1' , '-1' , '1' ,
'30.0000' , '24.590163934426' , '22' , '0' , '30.00' )
29/08/2022 03:26:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19107' AND id_supplier = ''
29/08/2022 03:26:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19107' , '' , '1' )
29/08/2022 03:26:21 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
( '55891' , '794' , 'ASTUCCIO 3 BOTTIGLIE CC125 - 964' , '1' , '-1' , '1' ,
'95.0000' , '77.868852459016' , '22' , '0' , '95.00' )
29/08/2022 03:26:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '794' AND id_supplier = ''
29/08/2022 03:26:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '794' , '' , '1' )
29/08/2022 03:26:21 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
( '55891' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' ,
'5.5' , '4.5081967213115' , '22' , '0' , '5.50' )
29/08/2022 03:26:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = ''
29/08/2022 03:26:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' )
29/08/2022 03:26:21 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
( '55891' , '18247' , 'CLERGY JEANS NIDO DAPE MM - M' , '1' , '-1' , '1' ,
'40.0000' , '32.786885245902' , '22' , '0' , '40.00' )
29/08/2022 03:26:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18247' AND id_supplier = ''
29/08/2022 03:26:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18247' , '' , '1' )
29/08/2022 03:26:21 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
( '55891' , '12689' , 'IMMAGINI 50X70' , '1' , '-1' , '1' ,
'4.5000' , '3.6885245901639' , '22' , '0' , '4.50' )
29/08/2022 03:26:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12689' AND id_supplier = ''
29/08/2022 03:26:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12689' , '' , '1' )
29/08/2022 03:26:21 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
( '55891' , '18222' , 'ROSARIO COLORATO - R316' , '1' , '-1' , '1' ,
'0.70' , '0.57377049180328' , '22' , '0' , '0.70' )
29/08/2022 03:26:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18222' AND id_supplier = ''
29/08/2022 03:26:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18222' , '' , '1' )
29/08/2022 03:26:49 pm >> SELECT document_num FROM ps_document
WHERE document_num = '1604' AND id_document != '57867' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-20')
29/08/2022 03:26:49 pm >> UPDATE ps_document SET
id_document_type = '11',
document_num = '1604',
document_date = '2022-05-20',
document_letter = '',
id_customer = '0',
id_supplier = '',
id_address = '0',
address1 = '',
address2 = '',
note = '',
price_shipping = '0.00',
id_tax_shipping_rules = '4',
colli = '0',
peso = '0',
porto_e_imballo = '0',
mezzo_consegna = '',
id_payment = '0',
id_causal = '0',
price_tax_included = '45.00',
price_tax_excluded = '36.89',
date_upd = NOW()
WHERE id_document = '57867'
29/08/2022 03:26:49 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '57867'
29/08/2022 03:26:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '57867'
29/08/2022 03:26:49 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '57867' , '19594' , 'POLO JERSEY COTONE 100%' , '1' , '-1' , '1' ,
'35.0000' , '28.688524590164' , '22' , '0' , '35.00' )
29/08/2022 03:26:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19594' AND id_supplier = ''
29/08/2022 03:26:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19594' , '' , '1' )
29/08/2022 03:26:49 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '57867' , '18554' , 'MADONNA ROSARIO BABY - 023 MDR/9 BB' , '1' , '-1' , '1' ,
'10.00' , '8.1967213114754' , '22' , '0' , '10.00' )
29/08/2022 03:26:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18554' AND id_supplier = ''
29/08/2022 03:26:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18554' , '' , '1' )
29/08/2022 03:27:23 pm >> SELECT document_num FROM ps_document
WHERE document_num = '1633' AND id_document != '57900' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-23')
29/08/2022 03:27:23 pm >> UPDATE ps_document SET
id_document_type = '11',
document_num = '1633',
document_date = '2022-05-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 = '217.00',
price_tax_excluded = '180.61',
date_upd = NOW()
WHERE id_document = '57900'
29/08/2022 03:27: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 = '57900'
29/08/2022 03:27:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '57900'
29/08/2022 03:27: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
( '57900' , '18426' , 'CAMICE BENEDETTINO MISTO LINO - 378' , '1' , '-1' , '1' ,
'130.0000' , '106.55737704918' , '22' , '0' , '130.00' )
29/08/2022 03:27:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18426' AND id_supplier = ''
29/08/2022 03:27:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18426' , '' , '1' )
29/08/2022 03:27: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
( '57900' , '12670' , 'CAMICE AVORIO - MISTO COT. 160' , '1' , '-1' , '1' ,
'55.0000' , '45.081967213115' , '22' , '0' , '55.00' )
29/08/2022 03:27:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12670' AND id_supplier = ''
29/08/2022 03:27:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12670' , '' , '1' )
29/08/2022 03:27: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
( '57900' , '15474' , 'CUORE A CUORE - M. RATTA' , '1' , '-1' , '4' ,
'4.0000' , '4' , '0' , '5' , '3.80' )
29/08/2022 03:27:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15474' AND id_supplier = ''
29/08/2022 03:27:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15474' , '' , '1' )
29/08/2022 03:27: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
( '57900' , '8383' , 'PREGHIERE PER LADORAZIONE EUCARISTICA - 8141' , '1' , '-1' , '4' ,
'12.0000' , '12' , '0' , '5' , '11.40' )
29/08/2022 03:27:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8383' AND id_supplier = ''
29/08/2022 03:27:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8383' , '' , '1' )
29/08/2022 03:27: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
( '57900' , '1350' , 'BRACCIALETTO CON CROCE - 29002 03' , '1' , '-1' , '1' ,
'3.0000' , '2.4590163934426' , '22' , '0' , '3.00' )
29/08/2022 03:27:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1350' AND id_supplier = ''
29/08/2022 03:27:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1350' , '' , '1' )
29/08/2022 03:27: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
( '57900' , '15097' , 'CORONA MATRIMONIO - ORO' , '2' , '-2' , '1' ,
'6.9' , '5.655737704918' , '22' , '0' , '13.80' )
29/08/2022 03:27:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15097' AND id_supplier = ''
29/08/2022 03:27:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15097' , '' , '1' )
29/08/2022 03:27:44 pm >> SELECT document_num FROM ps_document
WHERE document_num = '1576' AND id_document != '57834' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-18')
29/08/2022 03:27:44 pm >> UPDATE ps_document SET
id_document_type = '11',
document_num = '1576',
document_date = '2022-05-18',
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 = '48.40',
price_tax_excluded = '44.14',
date_upd = NOW()
WHERE id_document = '57834'
29/08/2022 03:27:44 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 = '57834'
29/08/2022 03:27:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '57834'
29/08/2022 03:27:44 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
( '57834' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '2' , '-2' , '3' ,
'3.5000' , '3.3653846153846' , '4' , '0' , '7.00' )
29/08/2022 03:27:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = ''
29/08/2022 03:27:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' )
29/08/2022 03:27:44 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
( '57834' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' ,
'2.0000' , '1.9230769230769' , '4' , '0' , '4.00' )
29/08/2022 03:27:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = ''
29/08/2022 03:27:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '' , '1' )
29/08/2022 03:27:44 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
( '57834' , '15924' , 'OSTIA 3MM - 03M-25' , '1' , '-1' , '3' ,
'6.0000' , '5.7692307692308' , '4' , '0' , '6.00' )
29/08/2022 03:27:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15924' AND id_supplier = ''
29/08/2022 03:27:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15924' , '' , '1' )
29/08/2022 03:27:44 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
( '57834' , '18920' , 'LUCE IN FONDO - L. EPICOCO' , '1' , '-1' , '4' ,
'12.0000' , '12' , '0' , '5' , '11.40' )
29/08/2022 03:27:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18920' AND id_supplier = ''
29/08/2022 03:27:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18920' , '' , '1' )
29/08/2022 03:27:44 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
( '57834' , '18390' , 'BRACCIALE 10 ESSENZE' , '1' , '-1' , '1' ,
'20' , '16.393442622951' , '22' , '0' , '20.00' )
29/08/2022 03:27:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18390' AND id_supplier = ''
29/08/2022 03:27:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18390' , '' , '1' )
29/08/2022 03:28:04 pm >> SELECT document_num FROM ps_document
WHERE document_num = '1591' AND id_document != '57852' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-19')
29/08/2022 03:28:04 pm >> UPDATE ps_document SET
id_document_type = '11',
document_num = '1591',
document_date = '2022-05-19',
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 = '79.00',
price_tax_excluded = '72.27',
date_upd = NOW()
WHERE id_document = '57852'
29/08/2022 03:28:04 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '57852'
29/08/2022 03:28:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '57852'
29/08/2022 03:28:04 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '57852' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '10' , '-10' , '3' ,
'3.5000' , '3.3653846153846' , '4' , '0' , '35.00' )
29/08/2022 03:28:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = ''
29/08/2022 03:28:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' )
29/08/2022 03:28:04 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '57852' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' ,
'2.0000' , '1.9230769230769' , '4' , '0' , '10.00' )
29/08/2022 03:28:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = ''
29/08/2022 03:28:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '' , '1' )
29/08/2022 03:28:04 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '57852' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '2' , '-2' , '3' ,
'4.0000' , '3.8461538461538' , '4' , '0' , '8.00' )
29/08/2022 03:28:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16691' AND id_supplier = ''
29/08/2022 03:28:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16691' , '' , '1' )
29/08/2022 03:28:04 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '57852' , '17277' , 'BRACCIALE PIETRE DURE - 4633' , '1' , '-1' , '1' ,
'4.5' , '3.6885245901639' , '22' , '0' , '4.50' )
29/08/2022 03:28:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17277' AND id_supplier = ''
29/08/2022 03:28:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17277' , '' , '1' )
29/08/2022 03:28:04 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '57852' , '5230' , 'INCENSO RAPHAEL ' , '1' , '-1' , '1' ,
'19.0000' , '15.573770491803' , '22' , '0' , '19.00' )
29/08/2022 03:28:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5230' AND id_supplier = ''
29/08/2022 03:28:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5230' , '' , '1' )
29/08/2022 03:28:04 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '57852' , '15481' , 'CROCE IHS - 2389/CZ' , '1' , '-1' , '1' ,
'2.5000' , '2.0491803278689' , '22' , '0' , '2.50' )
29/08/2022 03:28:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15481' AND id_supplier = ''
29/08/2022 03:28:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15481' , '' , '1' )
29/08/2022 03:28:58 pm >> SELECT document_num FROM ps_document
WHERE document_num = '1641' AND id_document != '58426' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-24')
29/08/2022 03:28:58 pm >> UPDATE ps_document SET
id_document_type = '11',
document_num = '1641',
document_date = '2022-05-24',
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 = '48.60',
price_tax_excluded = '40.49',
date_upd = NOW()
WHERE id_document = '58426'
29/08/2022 03:28:58 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 = '58426'
29/08/2022 03:28:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '58426'
29/08/2022 03:28: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
( '58426' , '12402' , 'TENERO ABBRACCIO - 16X9' , '1' , '-1' , '1' ,
'18.0000' , '14.754098360656' , '22' , '0' , '18.00' )
29/08/2022 03:28:59 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12402' AND id_supplier = ''
29/08/2022 03:28:59 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12402' , '' , '1' )
29/08/2022 03:28:59 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
( '58426' , '19413' , 'CARI SPOSI E SPOSE SCRIVO A VOI' , '2' , '-2' , '4' ,
'1.8000' , '1.8' , '0' , '0' , '3.60' )
29/08/2022 03:28:59 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19413' AND id_supplier = ''
29/08/2022 03:28:59 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19413' , '' , '1' )
29/08/2022 03:28:59 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
( '58426' , '18391' , 'CATENINA ACCIAIO 10 ESSENZE' , '1' , '-1' , '1' ,
'21.5' , '17.622950819672' , '22' , '0' , '21.50' )
29/08/2022 03:28:59 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18391' AND id_supplier = ''
29/08/2022 03:28:59 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18391' , '' , '1' )
29/08/2022 03:28:59 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
( '58426' , '17277' , 'BRACCIALE PIETRE DURE - 4633' , '1' , '-1' , '1' ,
'5.50' , '4.5081967213115' , '22' , '0' , '5.50' )
29/08/2022 03:28:59 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17277' AND id_supplier = ''
29/08/2022 03:28:59 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17277' , '' , '1' )
29/08/2022 03:29:18 pm >> SELECT document_num FROM ps_document
WHERE document_num = '1685' AND id_document != '58482' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-27')
29/08/2022 03:29:18 pm >> UPDATE ps_document SET
id_document_type = '11',
document_num = '1685',
document_date = '2022-05-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 = '60.00',
price_tax_excluded = '51.25',
date_upd = NOW()
WHERE id_document = '58482'
29/08/2022 03:29:18 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58482'
29/08/2022 03:29:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '58482'
29/08/2022 03:29:18 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58482' , '547' , 'AMPOLLINE E VASSOIO IN VETRO - 506' , '1' , '-1' , '1' ,
'29.5000' , '24.180327868852' , '22' , '0' , '29.50' )
29/08/2022 03:29:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '547' AND id_supplier = ''
29/08/2022 03:29:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '547' , '' , '1' )
29/08/2022 03:29:18 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58482' , '17277' , 'BRACCIALE PIETRE DURE - 4633' , '1' , '-1' , '1' ,
'4' , '3.2786885245902' , '22' , '0' , '4.00' )
29/08/2022 03:29:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17277' AND id_supplier = ''
29/08/2022 03:29:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17277' , '' , '1' )
29/08/2022 03:29:18 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58482' , '5251' , 'INCONTRI EUCARISTICI' , '5' , '-5' , '4' ,
'2.3000' , '2.3' , '0' , '0' , '11.50' )
29/08/2022 03:29:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5251' AND id_supplier = ''
29/08/2022 03:29:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5251' , '' , '1' )
29/08/2022 03:29:18 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58482' , '13733' , 'DECINA - 356/14' , '3' , '-3' , '1' ,
'1.7000' , '1.3934426229508' , '22' , '0' , '5.10' )
29/08/2022 03:29:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13733' AND id_supplier = ''
29/08/2022 03:29:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13733' , '' , '1' )
29/08/2022 03:29:18 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58482' , '13364' , 'CORONA MM 6 ' , '1' , '-1' , '1' ,
'2.7000' , '2.2131147540984' , '22' , '0' , '2.70' )
29/08/2022 03:29:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13364' AND id_supplier = ''
29/08/2022 03:29:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13364' , '' , '1' )
29/08/2022 03:29:19 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58482' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' ,
'7.2000' , '5.9016393442623' , '22' , '0' , '7.20' )
29/08/2022 03:29:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11384' AND id_supplier = ''
29/08/2022 03:29:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11384' , '' , '1' )
29/08/2022 03:30:10 pm >> SELECT document_num FROM ps_document
WHERE document_num = '1754' AND id_document != '58570' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-03')
29/08/2022 03:30:11 pm >> UPDATE ps_document SET
id_document_type = '11',
document_num = '1754',
document_date = '2022-06-03',
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 = '10.00',
price_tax_excluded = '8.20',
date_upd = NOW()
WHERE id_document = '58570'
29/08/2022 03:30:11 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58570'
29/08/2022 03:30:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '58570'
29/08/2022 03:30:11 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58570' , '7911' , 'PERGAMENE - 1A COMUNIONE MOD. B' , '4' , '-4' , '1' ,
'0.50' , '0.40983606557377' , '22' , '0' , '2.00' )
29/08/2022 03:30:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7911' AND id_supplier = ''
29/08/2022 03:30:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7911' , '' , '1' )
29/08/2022 03:30:11 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58570' , '7193' , 'NUPTIAE DECORO VETRATA ' , '1' , '-1' , '1' ,
'8.00' , '6.5573770491803' , '22' , '0' , '8.00' )
29/08/2022 03:30:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7193' AND id_supplier = ''
29/08/2022 03:30:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7193' , '' , '1' )
29/08/2022 03:30:59 pm >> SELECT document_num FROM ps_document
WHERE document_num = '2421' AND id_document != '59882' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-08-01')
29/08/2022 03:30:59 pm >> UPDATE ps_document SET
id_document_type = '11',
document_num = '2421',
document_date = '2022-08-01',
document_letter = '',
id_customer = '0',
id_supplier = '',
id_address = '0',
address1 = '',
address2 = '',
note = '',
price_shipping = '0.00',
id_tax_shipping_rules = '4',
colli = '0',
peso = '0',
porto_e_imballo = '0',
mezzo_consegna = '',
id_payment = '0',
id_causal = '0',
price_tax_included = '59.00',
price_tax_excluded = '49.17',
date_upd = NOW()
WHERE id_document = '59882'
29/08/2022 03:30:59 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 = '59882'
29/08/2022 03:30:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '59882'
29/08/2022 03:30:59 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
( '59882' , '6663' , 'MIE PREGHIERE' , '2' , '-2' , '4' ,
'1.5000' , '1.5' , '0' , '0' , '3.00' )
29/08/2022 03:30:59 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6663' AND id_supplier = ''
29/08/2022 03:30:59 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6663' , '' , '1' )
29/08/2022 03:30:59 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
( '59882' , '4129' , 'FELICE ANNIVERSARIO' , '1' , '-1' , '4' ,
'1.5000' , '1.5' , '0' , '0' , '1.50' )
29/08/2022 03:30:59 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4129' AND id_supplier = ''
29/08/2022 03:30:59 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4129' , '' , '1' )
29/08/2022 03:30:59 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
( '59882' , '16964' , 'PALLA IN S/MOIRE - 7885M' , '1' , '-1' , '1' ,
'54.5' , '44.672131147541' , '22' , '0' , '54.50' )
29/08/2022 03:30:59 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16964' AND id_supplier = ''
29/08/2022 03:30:59 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16964' , '' , '1' )
29/08/2022 03:32:43 pm >> SELECT document_num FROM ps_document
WHERE document_num = '2536' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-08-29')
29/08/2022 03:32:43 pm >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'2536' ,
'2022-08-29' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'13.20' ,
'10.82' ,
NOW() ,
NOW() )
29/08/2022 03:32:43 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '60533'
29/08/2022 03:32:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '60533'
29/08/2022 03:32:43 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '60533' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '2' , '-2' , '1' ,
'3.30' , '2.7049180327869' , '22' , '0' , '6.60' )
29/08/2022 03:32:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5903' AND id_supplier = ''
29/08/2022 03:32:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5903' , '' , '1' )
29/08/2022 03:32:43 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '60533' , '13049' , 'LITURGICO ART. 60LT BIANCO SUPER' , '2' , '-2' , '1' ,
'3.30' , '2.7049180327869' , '22' , '0' , '6.60' )
29/08/2022 03:32:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13049' AND id_supplier = ''
29/08/2022 03:32:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13049' , '' , '1' )
29/08/2022 03:34:19 pm >> SELECT document_num FROM ps_document
WHERE document_num = '2471' AND id_document != '59952' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-08-08')
29/08/2022 03:34:20 pm >> UPDATE ps_document SET
id_document_type = '11',
document_num = '2471',
document_date = '2022-08-08',
document_letter = '',
id_customer = '0',
id_supplier = '',
id_address = '0',
address1 = '',
address2 = '',
note = '',
price_shipping = '0.00',
id_tax_shipping_rules = '4',
colli = '0',
peso = '0',
porto_e_imballo = '0',
mezzo_consegna = '',
id_payment = '0',
id_causal = '0',
price_tax_included = '1.00',
price_tax_excluded = '1.00',
date_upd = NOW()
WHERE id_document = '59952'
29/08/2022 03:34:20 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '59952'
29/08/2022 03:34:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '59952'
29/08/2022 03:34:20 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '59952' , '19138' , 'ATTO DI ABBANDONO - D. D. RUOTOLO' , '1' , '-1' , '4' ,
'1.00' , '1' , '0' , '0' , '1.00' )
29/08/2022 03:34:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19138' AND id_supplier = ''
29/08/2022 03:34:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19138' , '' , '1' )
29/08/2022 03:34:34 pm >> SELECT document_num FROM ps_document
WHERE document_num = '2445' AND id_document != '59924' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-08-05')
29/08/2022 03:34:34 pm >> UPDATE ps_document SET
id_document_type = '11',
document_num = '2445',
document_date = '2022-08-05',
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 = '36.00',
price_tax_excluded = '36.00',
date_upd = NOW()
WHERE id_document = '59924'
29/08/2022 03:34:34 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '59924'
29/08/2022 03:34:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '59924'
29/08/2022 03:34:34 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '59924' , '5887' , 'LITURGIA DELLE ORE - VOL. I - PER SACERDOTI E RELIGIOSI' , '1' , '-1' , '4' ,
'35.0000' , '35' , '0' , '0' , '35.00' )
29/08/2022 03:34:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5887' AND id_supplier = ''
29/08/2022 03:34:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5887' , '' , '1' )
29/08/2022 03:34:34 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '59924' , '19138' , 'ATTO DI ABBANDONO - D. D. RUOTOLO' , '1' , '-1' , '4' ,
'1.00' , '1' , '0' , '0' , '1.00' )
29/08/2022 03:34:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19138' AND id_supplier = ''
29/08/2022 03:34:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19138' , '' , '1' )
29/08/2022 03:36:55 pm >> 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')
29/08/2022 03:36:55 pm >> 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'
29/08/2022 03:36:55 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58921'
29/08/2022 03:36:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '58921'
29/08/2022 03:36:55 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58921' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' ,
'4.7000' , '3.8524590163934' , '22' , '0' , '56.40' )
29/08/2022 03:36:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = ''
29/08/2022 03:36:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' )
29/08/2022 03:36: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
( '58921' , '9593' , 'SANTA MONICA - R.PICCOLOMINI' , '1' , '-1' , '4' ,
'4' , '4' , '0' , '0' , '4.00' )
29/08/2022 03:36:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9593' AND id_supplier = ''
29/08/2022 03:36:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9593' , '' , '1' )
29/08/2022 03:36: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
( '58921' , '15816' , 'CHI HA REDENTI CON IL TUO SANGUE - L. EPICOCO ' , '1' , '-1' , '4' ,
'8.7200' , '8.72' , '0' , '0' , '8.72' )
29/08/2022 03:36:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15816' AND id_supplier = ''
29/08/2022 03:36:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15816' , '' , '1' )
29/08/2022 03:36: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
( '58921' , '19805' , 'DESIDERIO DESIDERAVI' , '1' , '-1' , '4' ,
'2.00' , '2' , '0' , '0' , '2.00' )
29/08/2022 03:36:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19805' AND id_supplier = ''
29/08/2022 03:36:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19805' , '' , '1' )
29/08/2022 03:38:20 pm >> SELECT document_num FROM ps_document
WHERE document_num = '2103' AND id_document != '58970' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-30')
29/08/2022 03:38:20 pm >> UPDATE ps_document SET
id_document_type = '11',
document_num = '2103',
document_date = '2022-06-30',
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 = '116.20',
price_tax_excluded = '101.19',
date_upd = NOW()
WHERE id_document = '58970'
29/08/2022 03:38:20 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58970'
29/08/2022 03:38:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '58970'
29/08/2022 03:38:21 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
( '58970' , '18321' , 'IO ROSA - 8022' , '1' , '-1' , '4' ,
'2' , '2' , '0' , '0' , '2.00' )
29/08/2022 03:38:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18321' AND id_supplier = ''
29/08/2022 03:38:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18321' , '' , '1' )
29/08/2022 03:38:21 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
( '58970' , '7311' , 'OSTIA SOTTILE 74MM' , '8' , '-8' , '3' ,
'1.9000' , '1.8269230769231' , '4' , '0' , '15.20' )
29/08/2022 03:38:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = ''
29/08/2022 03:38:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' )
29/08/2022 03:38:21 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
( '58970' , '15387' , 'VESTINA BATTESIMALE ' , '20' , '-20' , '1' ,
'2.5000' , '2.0491803278689' , '22' , '0' , '50.00' )
29/08/2022 03:38:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15387' AND id_supplier = ''
29/08/2022 03:38:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15387' , '' , '1' )
29/08/2022 03:38:21 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
( '58970' , '19107' , 'INCENSO GRANI 3A' , '1' , '-1' , '1' ,
'30.0000' , '24.590163934426' , '22' , '0' , '30.00' )
29/08/2022 03:38:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19107' AND id_supplier = ''
29/08/2022 03:38:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19107' , '' , '1' )
29/08/2022 03:38:21 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
( '58970' , '19622' , 'SULLA TUA PAROLA - SETT/OTT 2022' , '4' , '-4' , '4' ,
'5.00' , '5' , '0' , '5' , '19.00' )
29/08/2022 03:38:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19622' AND id_supplier = ''
29/08/2022 03:38:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19622' , '' , '1' )
29/08/2022 03:39:38 pm >> SELECT document_num FROM ps_document
WHERE document_num = '2537' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-08-29')
29/08/2022 03:39:38 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' ,
'2537' ,
'2022-08-29' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'57.00' ,
'47.08' ,
NOW() ,
NOW() )
29/08/2022 03:39:38 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 = '60534'
29/08/2022 03:39:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '60534'
29/08/2022 03:39:38 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
( '60534' , '16461' , 'CLERGY NIDO D\'APE ML - C 22' , '1' , '-1' , '1' ,
'55.00' , '45.081967213115' , '22' , '0' , '55.00' )
29/08/2022 03:39:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16461' AND id_supplier = ''
29/08/2022 03:39:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16461' , '' , '1' )
29/08/2022 03:39:38 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
( '60534' , '19805' , 'DESIDERIO DESIDERAVI' , '1' , '-1' , '4' ,
'2.00' , '2' , '0' , '0' , '2.00' )
29/08/2022 03:39:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19805' AND id_supplier = ''
29/08/2022 03:39:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19805' , '' , '1' )
29/08/2022 03:40:15 pm >> SELECT document_num FROM ps_document
WHERE document_num = '2336' AND id_document != '59770' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-23')
29/08/2022 03:40:15 pm >> UPDATE ps_document SET
id_document_type = '11',
document_num = '2336',
document_date = '2022-07-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 = '77.60',
price_tax_excluded = '76.37',
date_upd = NOW()
WHERE id_document = '59770'
29/08/2022 03:40:15 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '59770'
29/08/2022 03:40:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '59770'
29/08/2022 03:40:15 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '59770' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '3' , '-3' , '3' ,
'4.0000' , '3.8461538461538' , '4' , '0' , '12.00' )
29/08/2022 03:40:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16691' AND id_supplier = ''
29/08/2022 03:40:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16691' , '' , '1' )
29/08/2022 03:40:15 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '59770' , '16689' , 'OSTIA PAN DI CENA mm80' , '10' , '-10' , '3' ,
'2.0000' , '1.9230769230769' , '4' , '0' , '20.00' )
29/08/2022 03:40:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = ''
29/08/2022 03:40:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '' , '1' )
29/08/2022 03:40:15 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '59770' , '19622' , 'SULLA TUA PAROLA - SETT/OTT 2022' , '12' , '-12' , '4' ,
'3.8' , '3.8' , '0' , '0' , '45.60' )
29/08/2022 03:40:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19622' AND id_supplier = ''
29/08/2022 03:40:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19622' , '' , '1' )
29/08/2022 03:41:45 pm >> SELECT document_num FROM ps_document
WHERE document_num = '2289' AND id_document != '59711' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-16')
29/08/2022 03:41:45 pm >> UPDATE ps_document SET
id_document_type = '11',
document_num = '2289',
document_date = '2022-07-16',
document_letter = '',
id_customer = '0',
id_supplier = '',
id_address = '0',
address1 = '',
address2 = '',
note = '',
price_shipping = '0.00',
id_tax_shipping_rules = '4',
colli = '0',
peso = '0',
porto_e_imballo = '0',
mezzo_consegna = '',
id_payment = '0',
id_causal = '0',
price_tax_included = '18.00',
price_tax_excluded = '18.00',
date_upd = NOW()
WHERE id_document = '59711'
29/08/2022 03:41: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 = '59711'
29/08/2022 03:41:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '59711'
29/08/2022 03:41: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
( '59711' , '11151' , 'LIBRI' , '1' , '-1' , '4' ,
'3.75' , '3.75' , '0' , '0' , '3.75' )
29/08/2022 03:41:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = ''
29/08/2022 03:41:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' )
29/08/2022 03:41: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
( '59711' , '19622' , 'SULLA TUA PAROLA - SETT/OTT 2022' , '3' , '-3' , '4' ,
'5.00' , '5' , '0' , '5' , '14.25' )
29/08/2022 03:41:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19622' AND id_supplier = ''
29/08/2022 03:41:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19622' , '' , '1' )
29/08/2022 03:42:12 pm >> SELECT document_num FROM ps_document
WHERE document_num = '2289' AND id_document != '59711' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-16')
29/08/2022 03:42:12 pm >> UPDATE ps_document SET
id_document_type = '11',
document_num = '2289',
document_date = '2022-07-16',
document_letter = '',
id_customer = '0',
id_supplier = '',
id_address = '0',
address1 = '',
address2 = '',
note = '',
price_shipping = '0.00',
id_tax_shipping_rules = '4',
colli = '0',
peso = '0',
porto_e_imballo = '0',
mezzo_consegna = '',
id_payment = '0',
id_causal = '0',
price_tax_included = '18.00',
price_tax_excluded = '18.00',
date_upd = NOW()
WHERE id_document = '59711'
29/08/2022 03:42:12 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 = '59711'
29/08/2022 03:42:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '59711'
29/08/2022 03:42:12 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
( '59711' , '11151' , 'LIBRI' , '1' , '-1' , '4' ,
'1.95' , '1.95' , '0' , '0' , '1.95' )
29/08/2022 03:42:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = ''
29/08/2022 03:42:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' )
29/08/2022 03:42:12 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
( '59711' , '19622' , 'SULLA TUA PAROLA - SETT/OTT 2022' , '3' , '-3' , '4' ,
'5.0000' , '5' , '0' , '5' , '14.25' )
29/08/2022 03:42:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19622' AND id_supplier = ''
29/08/2022 03:42:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19622' , '' , '1' )
29/08/2022 03:42:12 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
( '59711' , '19413' , 'CARI SPOSI E SPOSE SCRIVO A VOI' , '1' , '-1' , '4' ,
'1.80' , '1.8' , '0' , '0' , '1.80' )
29/08/2022 03:42:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19413' AND id_supplier = ''
29/08/2022 03:42:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19413' , '' , '1' )
29/08/2022 03:44:16 pm >> SELECT document_num FROM ps_document
WHERE document_num = '107' AND id_document != '59992' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-08-11')
29/08/2022 03:44:16 pm >> UPDATE ps_document SET
id_document_type = '21',
document_num = '107',
document_date = '2022-08-11',
document_letter = '',
id_customer = '618',
id_supplier = '',
id_address = '4671023',
address1 = 'S. ANGELO 84085 MERCATO S. SEVERINO',
address2 = '',
note = 'COPIE OMAGGIO AUTORE',
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 = '0.00',
price_tax_excluded = '0.00',
date_upd = NOW()
WHERE id_document = '59992'
29/08/2022 03:44:16 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 = '59992'
29/08/2022 03:44:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '59992'
29/08/2022 03:44:16 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
( '59992' , '19727' , 'LITURGIA IN FRAMMENTI - A. SORRENTINO' , '100' , '-100' , '4' ,
'35.0000' , '35' , '0' , '100' , '0.00' )
29/08/2022 03:44:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19727' AND id_supplier = ''
29/08/2022 03:44:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19727' , '' , '1' )
29/08/2022 04:35:06 pm >> SELECT document_num FROM ps_document
WHERE document_num = '2538' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-08-29')
29/08/2022 04:35:06 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' ,
'2538' ,
'2022-08-29' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'14.25' ,
'14.25' ,
NOW() ,
NOW() )
29/08/2022 04:35:06 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 = '60535'
29/08/2022 04:35:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '60535'
29/08/2022 04:35:06 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
( '60535' , '19622' , 'SULLA TUA PAROLA - SETT/OTT 2022' , '3' , '-3' , '4' ,
'5.00' , '5' , '0' , '5' , '14.25' )
29/08/2022 04:35:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19622' AND id_supplier = ''
29/08/2022 04:35:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19622' , '' , '1' )
29/08/2022 04:35:43 pm >> SELECT document_num FROM ps_document
WHERE document_num = '2539' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-08-29')
29/08/2022 04:35:43 pm >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'2539' ,
'2022-08-29' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'123.50' ,
'101.23' ,
NOW() ,
NOW() )
29/08/2022 04:35:43 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '60536'
29/08/2022 04:35:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '60536'
29/08/2022 04:35:43 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '60536' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' ,
'123.5' , '101.22950819672' , '22' , '0' , '123.50' )
29/08/2022 04:35:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = ''
29/08/2022 04:35:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' )
29/08/2022 04:40:57 pm >> SELECT document_num FROM ps_document
WHERE document_num = '2539' AND id_document != '60536' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-08-29')
29/08/2022 04:40:57 pm >> UPDATE ps_document SET
id_document_type = '11',
document_num = '2539',
document_date = '2022-08-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 = '123.50',
price_tax_excluded = '101.23',
date_upd = NOW()
WHERE id_document = '60536'
29/08/2022 04:40: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 = '60536'
29/08/2022 04:40:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '60536'
29/08/2022 04:40: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
( '60536' , '16118' , 'CLERGY GRIGIO JEANS - M' , '1' , '-1' , '1' ,
'42.00' , '34.426229508197' , '22' , '0' , '42.00' )
29/08/2022 04:40:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16118' AND id_supplier = ''
29/08/2022 04:40:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16118' , '' , '1' )
29/08/2022 04:40: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
( '60536' , '18252' , 'CLERGY BLU NIDO DAPE MM - M' , '1' , '-1' , '1' ,
'40.00' , '32.786885245902' , '22' , '0' , '40.00' )
29/08/2022 04:40:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18252' AND id_supplier = ''
29/08/2022 04:40:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18252' , '' , '1' )
29/08/2022 04:40: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
( '60536' , '2168' , 'CLERGY BASIC - ML - B&P' , '1' , '-1' , '1' ,
'34.00' , '27.868852459016' , '22' , '0' , '34.00' )
29/08/2022 04:40:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2168' AND id_supplier = ''
29/08/2022 04:40:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2168' , '' , '1' )
29/08/2022 04:40: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
( '60536' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' ,
'7.5' , '6.1475409836066' , '22' , '0' , '7.50' )
29/08/2022 04:40:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = ''
29/08/2022 04:40:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' )
29/08/2022 05:33:50 pm >> SELECT document_num FROM ps_document
WHERE document_num = '2540' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-08-29')
29/08/2022 05:33:50 pm >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'2540' ,
'2022-08-29' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'31.35' ,
'31.35' ,
NOW() ,
NOW() )
29/08/2022 05:33: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 = '61048'
29/08/2022 05:33:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '61048'
29/08/2022 05:33: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
( '61048' , '9255' , 'SACRA BIBBIA SIMILP BIANCA - 8642' , '1' , '-1' , '4' ,
'33.00' , '33' , '0' , '5' , '31.35' )
29/08/2022 05:33:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9255' AND id_supplier = ''
29/08/2022 05:33:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9255' , '' , '1' )
29/08/2022 05:37:56 pm >> SELECT document_num FROM ps_document
WHERE document_num = '110' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-08-29')
29/08/2022 05:37:56 pm >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'21' ,
'110' ,
'2022-08-29' ,
'' ,
'3898' ,
'' ,
'4674767' ,
'Via Ilario Paglierani , 1A 47922 Rimini Lasciare pacco in giardino, dietro al cancello grazie!' ,
'' ,
'' ,
'' ,
'0' ,
'0' ,
'0' ,
'0' ,
'' ,
'1' ,
'0' ,
'91.39' ,
'91.39' ,
NOW() ,
NOW() )
29/08/2022 05:37: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 = '61049'
29/08/2022 05:37:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '61049'
29/08/2022 05:37: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
( '61049' , '1882' , 'CELEBRAZIONI PER L\'ANNO CATECHISTICO' , '1' , '-1' , '4' ,
'10.0000' , '10' , '0' , '5' , '9.50' )
29/08/2022 05:37:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1882' AND id_supplier = ''
29/08/2022 05:37:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1882' , '' , '1' )
29/08/2022 05:37: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
( '61049' , '1883' , 'CELEBRAZIONI PER L\'ANNO PASTORALE' , '1' , '-1' , '4' ,
'11.0000' , '11' , '0' , '5' , '10.45' )
29/08/2022 05:37:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1883' AND id_supplier = ''
29/08/2022 05:37:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1883' , '' , '1' )
29/08/2022 05:37: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
( '61049' , '4494' , 'GESÙ RESTA CON NOI 3 - GUIDA' , '1' , '-1' , '4' ,
'10.0000' , '10' , '0' , '5' , '9.50' )
29/08/2022 05:37:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4494' AND id_supplier = ''
29/08/2022 05:37:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4494' , '' , '1' )
29/08/2022 05:37: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
( '61049' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '1' , '-1' , '4' ,
'3.5000' , '3.5' , '0' , '5' , '3.33' )
29/08/2022 05:37:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4495' AND id_supplier = ''
29/08/2022 05:37:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4495' , '' , '1' )
29/08/2022 05:37: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
( '61049' , '5643' , 'LEGGERE,... LA PAROLA - ANNO A' , '1' , '-1' , '4' ,
'10.0000' , '10' , '0' , '5' , '9.50' )
29/08/2022 05:37:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5643' AND id_supplier = ''
29/08/2022 05:37:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5643' , '' , '1' )
29/08/2022 05:37: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
( '61049' , '5644' , 'LEGGERE,... LA PAROLA - ANNO B' , '1' , '-1' , '4' ,
'10.0000' , '10' , '0' , '5' , '9.50' )
29/08/2022 05:37:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5644' AND id_supplier = ''
29/08/2022 05:37:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5644' , '' , '1' )
29/08/2022 05:37: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
( '61049' , '5645' , 'LEGGERE,... LA PAROLA - ANNO C' , '1' , '-1' , '4' ,
'10.0000' , '10' , '0' , '5' , '9.50' )
29/08/2022 05:37:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5645' AND id_supplier = ''
29/08/2022 05:37:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5645' , '' , '1' )
29/08/2022 05:37: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
( '61049' , '12253' , 'MIO LIBRO DI PREGHIERE' , '1' , '-1' , '4' ,
'2.8000' , '2.8' , '0' , '5' , '2.66' )
29/08/2022 05:37:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12253' AND id_supplier = ''
29/08/2022 05:37:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12253' , '' , '1' )
29/08/2022 05:37: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
( '61049' , '17580' , 'NUOVO MESSALINO PER RAGAZZI' , '1' , '-1' , '4' ,
'1.9' , '1.9' , '0' , '5' , '1.80' )
29/08/2022 05:37:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17580' AND id_supplier = ''
29/08/2022 05:37:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17580' , '' , '1' )
29/08/2022 05:37: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
( '61049' , '18491' , 'UNA STORIA CHE SALVA VOL. 1' , '1' , '-1' , '4' ,
'9' , '9' , '0' , '5' , '8.55' )
29/08/2022 05:37:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18491' AND id_supplier = ''
29/08/2022 05:37:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18491' , '' , '1' )
29/08/2022 05:37: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
( '61049' , '18492' , 'UNA STORIA CHE SALVA VOL. 2' , '1' , '-1' , '4' ,
'9' , '9' , '0' , '5' , '8.55' )
29/08/2022 05:37:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18492' AND id_supplier = ''
29/08/2022 05:37:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18492' , '' , '1' )
29/08/2022 05:37: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
( '61049' , '18493' , 'UNA STORIA CHE SALVA VOL. 3' , '1' , '-1' , '4' ,
'9' , '9' , '0' , '5' , '8.55' )
29/08/2022 05:37:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18493' AND id_supplier = ''
29/08/2022 05:37:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18493' , '' , '1' )
29/08/2022 05:40:33 pm >> SELECT document_num FROM ps_document
WHERE document_num = '111' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-08-29')
29/08/2022 05:40:33 pm >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'21' ,
'111' ,
'2022-08-29' ,
'' ,
'3898' ,
'' ,
'4674767' ,
'Via Ilario Paglierani , 1A 47922 Rimini Lasciare pacco in giardino, dietro al cancello grazie!' ,
'' ,
'' ,
'5.00' ,
'0' ,
'0' ,
'0' ,
'0' ,
'' ,
'1' ,
'0' ,
'105.33' ,
'105.33' ,
NOW() ,
NOW() )
29/08/2022 05:40:33 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61050'
29/08/2022 05:40:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '61050'
29/08/2022 05:40:33 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '61050' , '1882' , 'CELEBRAZIONI PER L\'ANNO CATECHISTICO' , '1' , '-1' , '4' ,
'10.0000' , '10' , '0' , '5' , '9.50' )
29/08/2022 05:40:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1882' AND id_supplier = ''
29/08/2022 05:40:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1882' , '' , '1' )
29/08/2022 05:40:33 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '61050' , '1883' , 'CELEBRAZIONI PER L\'ANNO PASTORALE' , '1' , '-1' , '4' ,
'11.0000' , '11' , '0' , '5' , '10.45' )
29/08/2022 05:40:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1883' AND id_supplier = ''
29/08/2022 05:40:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1883' , '' , '1' )
29/08/2022 05:40:33 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '61050' , '4494' , 'GESÙ RESTA CON NOI 3 - GUIDA' , '1' , '-1' , '4' ,
'10.0000' , '10' , '0' , '5' , '9.50' )
29/08/2022 05:40:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4494' AND id_supplier = ''
29/08/2022 05:40:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4494' , '' , '1' )
29/08/2022 05:40:33 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '61050' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '1' , '-1' , '4' ,
'3.5000' , '3.5' , '0' , '5' , '3.33' )
29/08/2022 05:40:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4495' AND id_supplier = ''
29/08/2022 05:40:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4495' , '' , '1' )
29/08/2022 05:40:33 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '61050' , '5643' , 'LEGGERE,... LA PAROLA - ANNO A' , '1' , '-1' , '4' ,
'10.0000' , '10' , '0' , '5' , '9.50' )
29/08/2022 05:40:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5643' AND id_supplier = ''
29/08/2022 05:40:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5643' , '' , '1' )
29/08/2022 05:40:33 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '61050' , '5644' , 'LEGGERE,... LA PAROLA - ANNO B' , '1' , '-1' , '4' ,
'10.0000' , '10' , '0' , '5' , '9.50' )
29/08/2022 05:40:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5644' AND id_supplier = ''
29/08/2022 05:40:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5644' , '' , '1' )
29/08/2022 05:40:33 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '61050' , '5645' , 'LEGGERE,... LA PAROLA - ANNO C' , '1' , '-1' , '4' ,
'10.0000' , '10' , '0' , '5' , '9.50' )
29/08/2022 05:40:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5645' AND id_supplier = ''
29/08/2022 05:40:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5645' , '' , '1' )
29/08/2022 05:40:33 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '61050' , '12253' , 'MIO LIBRO DI PREGHIERE' , '1' , '-1' , '4' ,
'2.8000' , '2.8' , '0' , '5' , '2.66' )
29/08/2022 05:40:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12253' AND id_supplier = ''
29/08/2022 05:40:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12253' , '' , '1' )
29/08/2022 05:40:34 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '61050' , '17580' , 'NUOVO MESSALINO PER RAGAZZI' , '1' , '-1' , '1' ,
'2.3180' , '1.9' , '22' , '5' , '2.20' )
29/08/2022 05:40:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17580' AND id_supplier = ''
29/08/2022 05:40:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17580' , '' , '1' )
29/08/2022 05:40:34 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '61050' , '18491' , 'UNA STORIA CHE SALVA VOL. 1' , '1' , '-1' , '1' ,
'10.9800' , '9' , '22' , '5' , '10.43' )
29/08/2022 05:40:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18491' AND id_supplier = ''
29/08/2022 05:40:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18491' , '' , '1' )
29/08/2022 05:40:34 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '61050' , '18492' , 'UNA STORIA CHE SALVA VOL. 2' , '1' , '-1' , '1' ,
'10.9800' , '9' , '22' , '5' , '10.43' )
29/08/2022 05:40:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18492' AND id_supplier = ''
29/08/2022 05:40:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18492' , '' , '1' )
29/08/2022 05:40:34 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '61050' , '18493' , 'UNA STORIA CHE SALVA VOL. 3' , '1' , '-1' , '1' ,
'10.9800' , '9' , '22' , '5' , '10.43' )
29/08/2022 05:40:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18493' AND id_supplier = ''
29/08/2022 05:40:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18493' , '' , '1' )
29/08/2022 05:40:34 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '61050' , '' , 'CONTRASSEGNO' , '1' , '-1' , '4' ,
'2.90' , '2.90' , '' , '0' , '2.90' )
29/08/2022 05:40:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '' AND id_supplier = ''
29/08/2022 05:40:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '' , '' , '1' )
29/08/2022 05:40:49 pm >> DELETE FROM ps_document WHERE id_document = '61050'
29/08/2022 05:40:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '61050'
29/08/2022 05:44:03 pm >> SELECT document_num FROM ps_document
WHERE document_num = '111' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-08-29')
29/08/2022 05:44: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 (
'21' ,
'111' ,
'2022-08-29' ,
'' ,
'3898' ,
'' ,
'4674767' ,
'Via Ilario Paglierani , 1A 47922 Rimini Lasciare pacco in giardino, dietro al cancello grazie!' ,
'' ,
'' ,
'5.00' ,
'0' ,
'0' ,
'0' ,
'0' ,
'' ,
'1' ,
'0' ,
'105.33' ,
'105.33' ,
NOW() ,
NOW() )
29/08/2022 05:44: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 = '61051'
29/08/2022 05:44:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '61051'
29/08/2022 05:44: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
( '61051' , '1882' , 'CELEBRAZIONI PER L\'ANNO CATECHISTICO' , '1' , '-1' , '4' ,
'10.0000' , '10' , '0' , '5' , '9.50' )
29/08/2022 05:44:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1882' AND id_supplier = ''
29/08/2022 05:44:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1882' , '' , '1' )
29/08/2022 05:44: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
( '61051' , '1883' , 'CELEBRAZIONI PER L\'ANNO PASTORALE' , '1' , '-1' , '4' ,
'11.0000' , '11' , '0' , '5' , '10.45' )
29/08/2022 05:44:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1883' AND id_supplier = ''
29/08/2022 05:44:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1883' , '' , '1' )
29/08/2022 05:44: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
( '61051' , '4494' , 'GESÙ RESTA CON NOI 3 - GUIDA' , '1' , '-1' , '4' ,
'10.0000' , '10' , '0' , '5' , '9.50' )
29/08/2022 05:44:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4494' AND id_supplier = ''
29/08/2022 05:44:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4494' , '' , '1' )
29/08/2022 05:44: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
( '61051' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '1' , '-1' , '4' ,
'3.5000' , '3.5' , '0' , '5' , '3.33' )
29/08/2022 05:44:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4495' AND id_supplier = ''
29/08/2022 05:44:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4495' , '' , '1' )
29/08/2022 05:44: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
( '61051' , '5643' , 'LEGGERE,... LA PAROLA - ANNO A' , '1' , '-1' , '4' ,
'10.0000' , '10' , '0' , '5' , '9.50' )
29/08/2022 05:44:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5643' AND id_supplier = ''
29/08/2022 05:44:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5643' , '' , '1' )
29/08/2022 05:44: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
( '61051' , '5644' , 'LEGGERE,... LA PAROLA - ANNO B' , '1' , '-1' , '4' ,
'10.0000' , '10' , '0' , '5' , '9.50' )
29/08/2022 05:44:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5644' AND id_supplier = ''
29/08/2022 05:44:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5644' , '' , '1' )
29/08/2022 05:44: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
( '61051' , '5645' , 'LEGGERE,... LA PAROLA - ANNO C' , '1' , '-1' , '4' ,
'10.0000' , '10' , '0' , '5' , '9.50' )
29/08/2022 05:44:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5645' AND id_supplier = ''
29/08/2022 05:44:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5645' , '' , '1' )
29/08/2022 05:44: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
( '61051' , '12253' , 'MIO LIBRO DI PREGHIERE' , '1' , '-1' , '4' ,
'2.8000' , '2.8' , '0' , '5' , '2.66' )
29/08/2022 05:44:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12253' AND id_supplier = ''
29/08/2022 05:44:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12253' , '' , '1' )
29/08/2022 05:44: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
( '61051' , '17580' , 'NUOVO MESSALINO PER RAGAZZI' , '1' , '-1' , '1' ,
'2.3180' , '1.9' , '22' , '5' , '2.20' )
29/08/2022 05:44:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17580' AND id_supplier = ''
29/08/2022 05:44:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17580' , '' , '1' )
29/08/2022 05:44:04 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '61051' , '18491' , 'UNA STORIA CHE SALVA VOL. 1' , '1' , '-1' , '1' ,
'10.9800' , '9' , '22' , '5' , '10.43' )
29/08/2022 05:44:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18491' AND id_supplier = ''
29/08/2022 05:44:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18491' , '' , '1' )
29/08/2022 05:44:04 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '61051' , '18492' , 'UNA STORIA CHE SALVA VOL. 2' , '1' , '-1' , '1' ,
'10.9800' , '9' , '22' , '5' , '10.43' )
29/08/2022 05:44:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18492' AND id_supplier = ''
29/08/2022 05:44:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18492' , '' , '1' )
29/08/2022 05:44:04 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '61051' , '18493' , 'UNA STORIA CHE SALVA VOL. 3' , '1' , '-1' , '1' ,
'10.9800' , '9' , '22' , '5' , '10.43' )
29/08/2022 05:44:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18493' AND id_supplier = ''
29/08/2022 05:44:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18493' , '' , '1' )
29/08/2022 05:44:04 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '61051' , '' , 'CONTRASSEGNO' , '1' , '-1' , '4' ,
'2.90' , '2.90' , '' , '0' , '2.90' )
29/08/2022 05:44:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '' AND id_supplier = ''
29/08/2022 05:44:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '' , '' , '1' )
29/08/2022 05:53:52 pm >> SELECT document_num FROM ps_document
WHERE document_num = '1818' AND id_document != '58645' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-07')
29/08/2022 05:53:52 pm >> UPDATE ps_document SET
id_document_type = '11',
document_num = '1818',
document_date = '2022-06-07',
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 = '25.00',
price_tax_excluded = '20.49',
date_upd = NOW()
WHERE id_document = '58645'
29/08/2022 05:53:52 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58645'
29/08/2022 05:53:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '58645'
29/08/2022 05:53: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
( '58645' , '5655' , 'LEGGIO IN PLEXIGLASS - 40986' , '1' , '-1' , '1' ,
'25' , '20.491803278689' , '22' , '0' , '25.00' )
29/08/2022 05:53:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5655' AND id_supplier = ''
29/08/2022 05:53:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5655' , '' , '1' )
29/08/2022 06:01:06 pm >> SELECT document_num FROM ps_document
WHERE document_num = '2541' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-08-29')
29/08/2022 06:01:07 pm >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'2541' ,
'2022-08-29' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'45.00' ,
'36.89' ,
NOW() ,
NOW() )
29/08/2022 06:01: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 = '61052'
29/08/2022 06:01:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '61052'
29/08/2022 06:01:07 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '61052' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' ,
'45' , '36.885245901639' , '22' , '0' , '45.00' )
29/08/2022 06:01:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = ''
29/08/2022 06:01:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' )
29/08/2022 06:15:48 pm >> SELECT document_num FROM ps_document
WHERE document_num = '63/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-08-29')
29/08/2022 06:15:48 pm >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'24' ,
'63/A' ,
'2022-08-29' ,
'A' ,
'1156' ,
'0' ,
'4671056' ,
'VIA BANZANO DI MONTORO 83020 BANZANO' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'150.00' ,
'150.00' ,
NOW() ,
NOW() )
29/08/2022 06:15:48 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61053'
29/08/2022 06:15:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '61053'
29/08/2022 06:15:48 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '61053' , '' , 'completo calice +pisside' , '1' , '-1' , '0' ,
'150' , '150' , '' , '0' , '150.00' )
29/08/2022 06:26:03 pm >> SELECT document_num FROM ps_document
WHERE document_num = '2542' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-08-29')
29/08/2022 06:26: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' ,
'2542' ,
'2022-08-29' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'7.60' ,
'7.60' ,
NOW() ,
NOW() )
29/08/2022 06:26: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 = '61054'
29/08/2022 06:26:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '61054'
29/08/2022 06:26: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
( '61054' , '19788' , 'MESSA MEDITAZIONE - SET. 2022' , '1' , '-1' , '4' ,
'4.00' , '4' , '0' , '5' , '3.80' )
29/08/2022 06:26:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19788' AND id_supplier = ''
29/08/2022 06:26:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19788' , '' , '1' )
29/08/2022 06:26: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
( '61054' , '19789' , 'MESSA MEDITAZIONE - OTT. 2022' , '1' , '-1' , '4' ,
'4.00' , '4' , '0' , '5' , '3.80' )
29/08/2022 06:26:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19789' AND id_supplier = ''
29/08/2022 06:26:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19789' , '' , '1' )
29/08/2022 07:18:21 pm >> DELETE FROM ps_product WHERE id_product = '9250'
29/08/2022 07:18:21 pm >> DELETE FROM ps_product_shop WHERE id_product = '9250'
29/08/2022 07:18:21 pm >> DELETE FROM ps_product_lang WHERE id_product = '9250'
29/08/2022 07:18:21 pm >> DELETE FROM ps_stock_available WHERE id_product = '9250'
29/08/2022 07:18:26 pm >> DELETE FROM ps_product WHERE id_product = '9251'
29/08/2022 07:18:26 pm >> DELETE FROM ps_product_shop WHERE id_product = '9251'
29/08/2022 07:18:26 pm >> DELETE FROM ps_product_lang WHERE id_product = '9251'
29/08/2022 07:18:26 pm >> DELETE FROM ps_stock_available WHERE id_product = '9251'
29/08/2022 07:18:36 pm >> DELETE FROM ps_product WHERE id_product = '9254'
29/08/2022 07:18:36 pm >> DELETE FROM ps_product_shop WHERE id_product = '9254'
29/08/2022 07:18:36 pm >> DELETE FROM ps_product_lang WHERE id_product = '9254'
29/08/2022 07:18:36 pm >> DELETE FROM ps_stock_available WHERE id_product = '9254'
29/08/2022 07:18:53 pm >> DELETE FROM ps_product WHERE id_product = '9256'
29/08/2022 07:18:53 pm >> DELETE FROM ps_product_shop WHERE id_product = '9256'
29/08/2022 07:18:53 pm >> DELETE FROM ps_product_lang WHERE id_product = '9256'
29/08/2022 07:18:53 pm >> DELETE FROM ps_stock_available WHERE id_product = '9256'
29/08/2022 09:01:04 pm >> SELECT document_num FROM ps_document
WHERE document_num = '2543' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-08-29')
29/08/2022 09:01:04 pm >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'2543' ,
'2022-08-29' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'130.00' ,
'106.56' ,
NOW() ,
NOW() )
29/08/2022 09:01:04 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61055'
29/08/2022 09:01:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '61055'
29/08/2022 09:01:04 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '61055' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '10' , '-10' , '1' ,
'3' , '2.4590163934426' , '22' , '0' , '30.00' )
29/08/2022 09:01:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5903' AND id_supplier = ''
29/08/2022 09:01:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5903' , '' , '1' )
29/08/2022 09:01:04 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '61055' , '13049' , 'LITURGICO ART. 60LT BIANCO SUPER' , '20' , '-20' , '1' ,
'3' , '2.4590163934426' , '22' , '0' , '60.00' )
29/08/2022 09:01:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13049' AND id_supplier = ''
29/08/2022 09:01:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13049' , '' , '1' )
29/08/2022 09:01:04 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '61055' , '18020' , 'PORTACANDELA ' , '2' , '-2' , '1' ,
'20.00' , '16.393442622951' , '22' , '0' , '40.00' )
29/08/2022 09:01:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18020' AND id_supplier = ''
29/08/2022 09:01:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18020' , '' , '1' )