08/05/2024 09:26:44 am >> SELECT document_num FROM ps_document
WHERE document_num = '1/A' AND id_document != '89846' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-01-08')
08/05/2024 09:26:44 am >> UPDATE ps_document SET
id_document_type = '24',
document_num = '1/A',
document_date = '2024-01-08',
document_letter = 'A',
id_customer = '206',
id_supplier = '',
id_address = '4671015',
address1 = 'VIA N. BUONSERVIZI, 25 84135 SALERNO',
address2 = '',
note = '',
price_shipping = '0.00',
id_tax_shipping_rules = '4',
colli = '0',
peso = '0',
porto_e_imballo = '0',
mezzo_consegna = '',
id_payment = '0',
id_causal = '0',
price_tax_included = '30.90',
price_tax_excluded = '30.90',
date_upd = NOW()
WHERE id_document = '89846'
08/05/2024 09:26: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 = '89846'
08/05/2024 09:26:44 am >> DELETE FROM ps_document_detail WHERE id_document = '89846'
08/05/2024 09:26: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
( '89846' , '22474' , 'PAROLA E PREGHIERA - LUG 2024' , '1' , '-1' , '4' ,
'2.9000' , '2.9' , '0' , '0' , '2.90' )
08/05/2024 09:26: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
( '89846' , '19892' , 'SALVE, REGINA - S. HAHN' , '1' , '-1' , '4' ,
'10.0000' , '10' , '0' , '0' , '10.00' )
08/05/2024 09:26: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
( '89846' , '22414' , 'SULLA TUA PAROLA - LUG/AGO 2024' , '1' , '-1' , '4' ,
'5.0000' , '5' , '0' , '0' , '5.00' )
08/05/2024 09:26: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
( '89846' , '22214' , 'VIE DI MARIA - F. DE CRISTOFARO' , '1' , '-1' , '4' ,
'13.00' , '13' , '0' , '0' , '13.00' )
08/05/2024 09:43:31 am >> SELECT document_num FROM ps_document
WHERE document_num = '1480' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2024-05-08')
08/05/2024 09:43:31 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' ,
'1480' ,
'2024-05-08' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'12.00' ,
'9.84' ,
NOW() ,
NOW() )
08/05/2024 09:43:31 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 = '91674'
08/05/2024 09:43:31 am >> DELETE FROM ps_document_detail WHERE id_document = '91674'
08/05/2024 09:43:31 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
( '91674' , '21558' , 'ANELLO DECINA ARG - M043' , '1' , '-1' , '1' ,
'12.00' , '9.8360655737705' , '22' , '0' , '12.00' )
08/05/2024 09:46:18 am >> SELECT document_num FROM ps_document
WHERE document_num = '9/L' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-05-08')
08/05/2024 09:46:18 am >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'23' ,
'9/L' ,
'2024-05-08' ,
'L' ,
'204' ,
'0' ,
'4671483' ,
'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO' ,
'' ,
'CAPPELLANIA UNIVERSITA\'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'3' ,
'0' ,
'68.50' ,
'58.63' ,
NOW() ,
NOW() )
08/05/2024 09:46:18 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91675'
08/05/2024 09:46:18 am >> DELETE FROM ps_document_detail WHERE id_document = '91675'
08/05/2024 09:46:18 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '91675' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '5' , '-5' , '3' ,
'3.50' , '3.3653846153846' , '4' , '0' , '17.50' )
08/05/2024 09:46:18 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '91675' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' ,
'8.5' , '6.9672131147541' , '22' , '0' , '51.00' )
08/05/2024 09:53:56 am >> SELECT document_num FROM ps_document
WHERE document_num = '1481' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-08')
08/05/2024 09:53:56 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' ,
'1481' ,
'2024-05-08' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'66.25' ,
'60.30' ,
NOW() ,
NOW() )
08/05/2024 09:53:56 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 = '91676'
08/05/2024 09:53:56 am >> DELETE FROM ps_document_detail WHERE id_document = '91676'
08/05/2024 09:53:56 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '91676' , '21509' , 'LITURGIA DELLE ORE VOL. IV N.E.' , '1' , '-1' , '4' ,
'35.00' , '35' , '0' , '5' , '33.25' )
08/05/2024 09:53:56 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '91676' , '21583' , 'CUSTODIA PELLE LITURGIA DELLE ORE - 731' , '1' , '-1' , '1' ,
'33.00' , '27.049180327869' , '22' , '0' , '33.00' )
08/05/2024 09:55:10 am >> SELECT document_num FROM ps_document
WHERE document_num = '1482' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2024-05-08')
08/05/2024 09:55: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' ,
'1482' ,
'2024-05-08' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'157.00' ,
'132.66' ,
NOW() ,
NOW() )
08/05/2024 09:55: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 = '91677'
08/05/2024 09:55:10 am >> DELETE FROM ps_document_detail WHERE id_document = '91677'
08/05/2024 09:55: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
( '91677' , '8247' , 'PREGATE, PREGATE, PREGATE - 8100' , '1' , '-1' , '4' ,
'10.00' , '10' , '0' , '5' , '9.50' )
08/05/2024 09:55: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
( '91677' , '11151' , 'LIBRI' , '1' , '-1' , '4' ,
'10' , '10' , '0' , '0' , '10.00' )
08/05/2024 09:55: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
( '91677' , '22506' , 'DIGNITAS INFINITA' , '1' , '-1' , '4' ,
'2.50' , '2.5' , '0' , '0' , '2.50' )
08/05/2024 09:55: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
( '91677' , '16864' , 'CROCIFISSO SAGOMATO 40X25 - 104062' , '1' , '-1' , '1' ,
'135.00' , '110.65573770492' , '22' , '0' , '135.00' )
08/05/2024 09:58:38 am >> SELECT document_num FROM ps_document
WHERE document_num = '1483' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-08')
08/05/2024 09:58:38 am >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'1483' ,
'2024-05-08' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'79.00' ,
'64.75' ,
NOW() ,
NOW() )
08/05/2024 09:58:38 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91678'
08/05/2024 09:58:38 am >> DELETE FROM ps_document_detail WHERE id_document = '91678'
08/05/2024 09:58:38 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '91678' , '16865' , 'CROCIFISSO SAGOMATO 28X20 - 102860' , '1' , '-1' , '1' ,
'79.00' , '64.754098360656' , '22' , '0' , '79.00' )
08/05/2024 10:07:36 am >> SELECT document_num FROM ps_document
WHERE document_num = '145/A' AND id_document != '89628' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-12-21')
08/05/2024 10:07:36 am >> UPDATE ps_document SET
id_document_type = '24',
document_num = '145/A',
document_date = '2023-12-21',
document_letter = 'A',
id_customer = '230',
id_supplier = '',
id_address = '4668969',
address1 = 'VIA G. NICOTERA, 66 84080 PELLEZZANO',
address2 = '',
note = 'ACCONTO € 150 + 100 per cero pasquale',
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 = '684.00',
price_tax_excluded = '623.77',
date_upd = NOW()
WHERE id_document = '89628'
08/05/2024 10:07:36 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89628'
08/05/2024 10:07:36 am >> DELETE FROM ps_document_detail WHERE id_document = '89628'
08/05/2024 10:07:36 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '89628' , '0' , 'PRESEPE ANTICO' , '1' , '-1' , '0' ,
'350.0000' , '350' , '0' , '0' , '350.00' )
08/05/2024 10:07:36 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '89628' , '19077' , 'GRUPPO NATIVITA STOFFA CM 30 - PB18552 ++ campana 25x40' , '1' , '-1' , '1' ,
'160.0000' , '131.14754098361' , '22' , '0' , '160.00' )
08/05/2024 10:07:36 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '89628' , '15210' , 'CERO PASQUALE API 80X120' , '1' , '-1' , '1' ,
'150.0000' , '122.95081967213' , '22' , '0' , '150.00' )
08/05/2024 10:07:36 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '89628' , '4991' , 'SAN PIO DA PIETRELCINA - 315' , '1' , '-1' , '1' ,
'3.5' , '2.8688524590164' , '22' , '0' , '3.50' )
08/05/2024 10:07:36 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '89628' , '14136' , 'MADONNA DEL ROSARIO DI POMPEI - 125' , '3' , '-3' , '1' ,
'3.5' , '2.8688524590164' , '22' , '0' , '10.50' )
08/05/2024 10:07:36 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '89628' , '' , 'SUPPLICA' , '1' , '-1' , '1' ,
'10' , '8.1967213114754' , '22' , '0' , '10.00' )
08/05/2024 10:16:54 am >> SELECT document_num FROM ps_document
WHERE document_num = '1484' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-08')
08/05/2024 10:16: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' ,
'1484' ,
'2024-05-08' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'1.80' ,
'1.48' ,
NOW() ,
NOW() )
08/05/2024 10:16: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 = '91679'
08/05/2024 10:16:54 am >> DELETE FROM ps_document_detail WHERE id_document = '91679'
08/05/2024 10:16: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
( '91679' , '17004' , 'BIGLIETTO AUGURALE PICCOLO' , '1' , '-1' , '1' ,
'0.80' , '0.65573770491803' , '22' , '0' , '0.80' )
08/05/2024 10:16: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
( '91679' , '17005' , 'BIGLIETTO AUGURALE medio' , '1' , '-1' , '1' ,
'1.00' , '0.81967213114754' , '22' , '0' , '1.00' )
08/05/2024 10:26:12 am >> SELECT document_num FROM ps_document
WHERE document_num = '1485' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-08')
08/05/2024 10:26:12 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' ,
'1485' ,
'2024-05-08' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'2.50' ,
'2.05' ,
NOW() ,
NOW() )
08/05/2024 10:26:12 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 = '91680'
08/05/2024 10:26:12 am >> DELETE FROM ps_document_detail WHERE id_document = '91680'
08/05/2024 10:26:12 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
( '91680' , '18135' , 'CROCE SAN BENEDETTO PICCOLA - CSB4' , '1' , '-1' , '1' ,
'2.50' , '2.0491803278689' , '22' , '0' , '2.50' )
08/05/2024 10:36:01 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892226104' AND id_product != '18609' AND ean13 != ''
08/05/2024 10:36:02 am >> UPDATE ps_product SET
id_supplier = '7',
reference = '6/6',
ean13 = '9788892226104',
date_upd = NOW()
WHERE id_product = '18609'
08/05/2024 10:36:02 am >> UPDATE ps_product_lang SET
name = 'BUSSOLA DI ABRAMO - G. MATARAZZO',
description = ''
WHERE id_product = '18609'
08/05/2024 10:36:02 am >> UPDATE ps_product SET
wholesale_price = '12.06',
on_sale = '0',
price = '18.0000'
WHERE id_product = '18609'
08/05/2024 10:36:02 am >> UPDATE ps_product_shop SET
wholesale_price = '12.06',
price = '18.0000',
id_tax_rules_group = '4',
id_category_default = '30',
id_argoment_default = '41',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '18609'
08/05/2024 10:36:02 am >> DELETE FROM ps_specific_price WHERE id_product = '18609'
08/05/2024 10:36:33 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788856664492' AND id_product != '15021' AND ean13 != ''
08/05/2024 10:36:33 am >> UPDATE ps_product SET
id_supplier = '114',
reference = '6/6',
ean13 = '9788856664492',
date_upd = NOW()
WHERE id_product = '15021'
08/05/2024 10:36:33 am >> UPDATE ps_product_lang SET
name = 'VIVERE PER SEMPRE - V. PAGLIA',
description = ''
WHERE id_product = '15021'
08/05/2024 10:36:33 am >> UPDATE ps_product SET
wholesale_price = '12.43',
on_sale = '0',
price = '17.5000'
WHERE id_product = '15021'
08/05/2024 10:36:33 am >> UPDATE ps_product_shop SET
wholesale_price = '12.43',
price = '17.5000',
id_tax_rules_group = '4',
id_category_default = '70',
id_argoment_default = '23',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '15021'
08/05/2024 10:36:33 am >> DELETE FROM ps_specific_price WHERE id_product = '15021'
08/05/2024 10:36:48 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791281253445' AND id_product != '21487' AND ean13 != ''
08/05/2024 10:36:48 am >> UPDATE ps_product SET
id_supplier = '7',
reference = '6/6',
ean13 = '9791281253445',
date_upd = NOW()
WHERE id_product = '21487'
08/05/2024 10:36:48 am >> UPDATE ps_product_lang SET
name = 'SEI UN MITO - L. GALBIATI',
description = ''
WHERE id_product = '21487'
08/05/2024 10:36:48 am >> UPDATE ps_product SET
wholesale_price = '8.40',
on_sale = '0',
price = '12.0000'
WHERE id_product = '21487'
08/05/2024 10:36:48 am >> UPDATE ps_product_shop SET
wholesale_price = '8.40',
price = '12.0000',
id_tax_rules_group = '4',
id_category_default = '518',
id_argoment_default = '10',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '21487'
08/05/2024 10:36:48 am >> DELETE FROM ps_specific_price WHERE id_product = '21487'
08/05/2024 10:37:03 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884248008' AND id_product != '21814' AND ean13 != ''
08/05/2024 10:37:03 am >> UPDATE ps_product SET
id_supplier = '7',
reference = '6/6',
ean13 = '9788884248008',
date_upd = NOW()
WHERE id_product = '21814'
08/05/2024 10:37:03 am >> UPDATE ps_product_lang SET
name = 'VIVERE IL LUTTO INSIEME A DIO - C. GALATOLO',
description = ''
WHERE id_product = '21814'
08/05/2024 10:37:03 am >> UPDATE ps_product SET
wholesale_price = '9.80',
on_sale = '0',
price = '14.0000'
WHERE id_product = '21814'
08/05/2024 10:37:03 am >> UPDATE ps_product_shop SET
wholesale_price = '9.80',
price = '14.0000',
id_tax_rules_group = '4',
id_category_default = '83',
id_argoment_default = '10',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '21814'
08/05/2024 10:37:03 am >> DELETE FROM ps_specific_price WHERE id_product = '21814'
08/05/2024 10:37:03 am >> INSERT INTO ps_product (
id_tax_rules_group , `date_add` , `date_upd`
) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '21814'
08/05/2024 10:37:03 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22509' , '1' , '' , 'nuovo-prodotto' )
08/05/2024 10:37:03 am >> INSERT INTO ps_product_shop (
id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd`
) SELECT '22509' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21814'
08/05/2024 10:37:04 am >> INSERT INTO `ps_stock_available` (
id_product , id_product_attribute , id_shop , id_shop_group , quantity
) SELECT '22509' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21814'
08/05/2024 10:37:20 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788873576150' AND id_product != '12600' AND ean13 != ''
08/05/2024 10:37:20 am >> UPDATE ps_product SET
id_supplier = '65',
reference = '6/6',
ean13 = '9788873576150',
date_upd = NOW()
WHERE id_product = '12600'
08/05/2024 10:37:20 am >> UPDATE ps_product_lang SET
name = 'SUL MALE - J. HERNANDEZ',
description = ''
WHERE id_product = '12600'
08/05/2024 10:37:20 am >> UPDATE ps_product SET
wholesale_price = '1.30',
on_sale = '0',
price = '2.0000'
WHERE id_product = '12600'
08/05/2024 10:37:20 am >> UPDATE ps_product_shop SET
wholesale_price = '1.30',
price = '2.0000',
id_tax_rules_group = '4',
id_category_default = '178',
id_argoment_default = '41',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '12600'
08/05/2024 10:37:20 am >> DELETE FROM ps_specific_price WHERE id_product = '12600'
08/05/2024 10:37:48 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892242845' AND id_product != '21628' AND ean13 != ''
08/05/2024 10:37:48 am >> UPDATE ps_product SET
id_supplier = '7',
reference = '6/6',
ean13 = '9788892242845',
date_upd = NOW()
WHERE id_product = '21628'
08/05/2024 10:37:48 am >> UPDATE ps_product_lang SET
name = 'DOVE VA LA CHIESA? - E. BIANCHI',
description = ''
WHERE id_product = '21628'
08/05/2024 10:37:48 am >> UPDATE ps_product SET
wholesale_price = '12.06',
on_sale = '0',
price = '18.0000'
WHERE id_product = '21628'
08/05/2024 10:37:48 am >> UPDATE ps_product_shop SET
wholesale_price = '12.06',
price = '18.0000',
id_tax_rules_group = '4',
id_category_default = '30',
id_argoment_default = '10',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '21628'
08/05/2024 10:37:48 am >> DELETE FROM ps_specific_price WHERE id_product = '21628'
08/05/2024 10:38:04 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788869299605' AND id_product != '21341' AND ean13 != ''
08/05/2024 10:38:04 am >> UPDATE ps_product SET
id_supplier = '109',
reference = '6/6',
ean13 = '9788869299605',
date_upd = NOW()
WHERE id_product = '21341'
08/05/2024 10:38:04 am >> UPDATE ps_product_lang SET
name = 'IMPARANDO DALLE DONNE - F. CERAGIOLI',
description = ''
WHERE id_product = '21341'
08/05/2024 10:38:04 am >> UPDATE ps_product SET
wholesale_price = '9.75',
on_sale = '0',
price = '15.0000'
WHERE id_product = '21341'
08/05/2024 10:38:04 am >> UPDATE ps_product_shop SET
wholesale_price = '9.75',
price = '15.0000',
id_tax_rules_group = '4',
id_category_default = '45',
id_argoment_default = '23',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '21341'
08/05/2024 10:38:04 am >> DELETE FROM ps_specific_price WHERE id_product = '21341'
08/05/2024 10:38:17 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788869299131' AND id_product != '21553' AND ean13 != ''
08/05/2024 10:38:17 am >> UPDATE ps_product SET
id_supplier = '109',
reference = '6/6',
ean13 = '9788869299131',
date_upd = NOW()
WHERE id_product = '21553'
08/05/2024 10:38:17 am >> UPDATE ps_product_lang SET
name = 'SCOPRIRE IL VANGELO IN UN WEEKEND - J. FABRE',
description = ''
WHERE id_product = '21553'
08/05/2024 10:38:17 am >> UPDATE ps_product SET
wholesale_price = '9.10',
on_sale = '0',
price = '14.0000'
WHERE id_product = '21553'
08/05/2024 10:38:17 am >> UPDATE ps_product_shop SET
wholesale_price = '9.10',
price = '14.0000',
id_tax_rules_group = '4',
id_category_default = '45',
id_argoment_default = '23',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '21553'
08/05/2024 10:38:17 am >> DELETE FROM ps_specific_price WHERE id_product = '21553'
08/05/2024 10:38:33 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788839929709' AND id_product != '21162' AND ean13 != ''
08/05/2024 10:38:33 am >> UPDATE ps_product SET
id_supplier = '7',
reference = '6/6',
ean13 = '9788839929709',
date_upd = NOW()
WHERE id_product = '21162'
08/05/2024 10:38:33 am >> UPDATE ps_product_lang SET
name = 'MARIA DI MAGDALA - C. REYNIER',
description = ''
WHERE id_product = '21162'
08/05/2024 10:38:33 am >> UPDATE ps_product SET
wholesale_price = '14.70',
on_sale = '0',
price = '21.0000'
WHERE id_product = '21162'
08/05/2024 10:38:33 am >> UPDATE ps_product_shop SET
wholesale_price = '14.70',
price = '21.0000',
id_tax_rules_group = '4',
id_category_default = '111',
id_argoment_default = '23',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '21162'
08/05/2024 10:38:33 am >> DELETE FROM ps_specific_price WHERE id_product = '21162'
08/05/2024 10:38:46 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788825056167' AND id_product != '21163' AND ean13 != ''
08/05/2024 10:38:46 am >> UPDATE ps_product SET
id_supplier = '7',
reference = '6/6',
ean13 = '9788825056167',
date_upd = NOW()
WHERE id_product = '21163'
08/05/2024 10:38:46 am >> UPDATE ps_product_lang SET
name = 'BRICIOLE POVERE DI UN PANE - F. FARRONATO',
description = ''
WHERE id_product = '21163'
08/05/2024 10:38:46 am >> UPDATE ps_product SET
wholesale_price = '9.10',
on_sale = '0',
price = '13.0000'
WHERE id_product = '21163'
08/05/2024 10:38:46 am >> UPDATE ps_product_shop SET
wholesale_price = '9.10',
price = '13.0000',
id_tax_rules_group = '4',
id_category_default = '17',
id_argoment_default = '41',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '21163'
08/05/2024 10:38:46 am >> DELETE FROM ps_specific_price WHERE id_product = '21163'
08/05/2024 10:38:59 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788827011348' AND id_product != '14982' AND ean13 != ''
08/05/2024 10:38:59 am >> UPDATE ps_product SET
id_supplier = '7',
reference = '6/6',
ean13 = '9788827011348',
date_upd = NOW()
WHERE id_product = '14982'
08/05/2024 10:38:59 am >> UPDATE ps_product_lang SET
name = 'NEL SILENZIO PARLAMI - F. DE LAZZARI',
description = ''
WHERE id_product = '14982'
08/05/2024 10:38:59 am >> UPDATE ps_product SET
wholesale_price = '8.40',
on_sale = '0',
price = '12.0000'
WHERE id_product = '14982'
08/05/2024 10:38:59 am >> UPDATE ps_product_shop SET
wholesale_price = '8.40',
price = '12.0000',
id_tax_rules_group = '4',
id_category_default = '186',
id_argoment_default = '41',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '14982'
08/05/2024 10:38:59 am >> DELETE FROM ps_specific_price WHERE id_product = '14982'
08/05/2024 10:39:11 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892242005' AND id_product != '21167' AND ean13 != ''
08/05/2024 10:39:11 am >> UPDATE ps_product SET
id_supplier = '7',
reference = '6/6',
ean13 = '9788892242005',
date_upd = NOW()
WHERE id_product = '21167'
08/05/2024 10:39:11 am >> UPDATE ps_product_lang SET
name = 'CARISMI PER TUTTI - FRA DANIEL M.',
description = ''
WHERE id_product = '21167'
08/05/2024 10:39:11 am >> UPDATE ps_product SET
wholesale_price = '12.06',
on_sale = '0',
price = '18.0000'
WHERE id_product = '21167'
08/05/2024 10:39:11 am >> UPDATE ps_product_shop SET
wholesale_price = '12.06',
price = '18.0000',
id_tax_rules_group = '4',
id_category_default = '30',
id_argoment_default = '41',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '21167'
08/05/2024 10:39:11 am >> DELETE FROM ps_specific_price WHERE id_product = '21167'
08/05/2024 10:39:25 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791280546456' AND id_product != '20844' AND ean13 != ''
08/05/2024 10:39:25 am >> UPDATE ps_product SET
id_supplier = '7',
reference = '6/6',
ean13 = '9791280546456',
date_upd = NOW()
WHERE id_product = '20844'
08/05/2024 10:39:25 am >> UPDATE ps_product_lang SET
name = 'SE LO DICE GESU\' - G. AGAGLIATI',
description = ''
WHERE id_product = '20844'
08/05/2024 10:39:25 am >> UPDATE ps_product SET
wholesale_price = '7.00',
on_sale = '0',
price = '10.0000'
WHERE id_product = '20844'
08/05/2024 10:39:25 am >> UPDATE ps_product_shop SET
wholesale_price = '7.00',
price = '10.0000',
id_tax_rules_group = '4',
id_category_default = '483',
id_argoment_default = '23',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '20844'
08/05/2024 10:39:25 am >> DELETE FROM ps_specific_price WHERE id_product = '20844'
08/05/2024 10:39:40 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831148764' AND id_product != '21451' AND ean13 != ''
08/05/2024 10:39:40 am >> UPDATE ps_product SET
id_supplier = '109',
reference = '6/6',
ean13 = '9788831148764',
date_upd = NOW()
WHERE id_product = '21451'
08/05/2024 10:39:40 am >> UPDATE ps_product_lang SET
name = 'UNA SPIRITUALITA\' ECCLESIALE - G. ROSSE\'',
description = ''
WHERE id_product = '21451'
08/05/2024 10:39:40 am >> UPDATE ps_product SET
wholesale_price = '11.64',
on_sale = '0',
price = '17.9000'
WHERE id_product = '21451'
08/05/2024 10:39:40 am >> UPDATE ps_product_shop SET
wholesale_price = '11.64',
price = '17.9000',
id_tax_rules_group = '4',
id_category_default = '13',
id_argoment_default = '41',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '21451'
08/05/2024 10:39:40 am >> DELETE FROM ps_specific_price WHERE id_product = '21451'
08/05/2024 10:39:56 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788895983776' AND id_product != '18052' AND ean13 != ''
08/05/2024 10:39:56 am >> UPDATE ps_product SET
id_supplier = '145',
reference = '6/6',
ean13 = '9788895983776',
date_upd = NOW()
WHERE id_product = '18052'
08/05/2024 10:39:56 am >> UPDATE ps_product_lang SET
name = 'CONVERSAZIONI CON MADRE TERESA - GJERGJI',
description = '
Nel 5° anniversario del Concistoro Ordinario Pubblico, convocato da papa Francesco il 15 marzo 2016, per la Canonizzazione di Agnese Gonxha Bojaxhiu. (Madre Teresa) pubblichiamo le interviste esclusive raccolte in diversi Paesi e circostanze, nonché quelle rilasciate durante le sue cinque visite in Kosovo e il discorso tenuto per l’accettazione del Premio Nobel per la Pace (1979), con fotografie, parole, messaggi, discorsi, orientamenti, definizioni, visioni lungimiranti e profetiche: una sorta di testamento spirituale per tutti noi.
'
WHERE id_product = '18052'
08/05/2024 10:39:56 am >> UPDATE ps_product SET
wholesale_price = '2.60',
on_sale = '0',
price = '12.0000'
WHERE id_product = '18052'
08/05/2024 10:39:56 am >> UPDATE ps_product_shop SET
wholesale_price = '2.60',
price = '12.0000',
id_tax_rules_group = '4',
id_category_default = '395',
id_argoment_default = '23',
id_internal_category = '4',
on_sale = '0',
on_showcase = '1',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '18052'
08/05/2024 10:39:56 am >> DELETE FROM ps_specific_price WHERE id_product = '18052'
08/05/2024 10:39:56 am >> INSERT INTO ps_specific_price
( id_specific_price_rule , id_cart , id_product , id_shop , id_shop_group , id_currency , id_country , id_group , id_customer , id_product_attribute , price , from_quantity , reduction , reduction_tax , reduction_type , `from` , `to`)
VALUES
( '0' , '0' , '18052' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' )
08/05/2024 10:40:09 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831554268' AND id_product != '18538' AND ean13 != ''
08/05/2024 10:40:09 am >> UPDATE ps_product SET
id_supplier = '7',
reference = '6/6',
ean13 = '9788831554268',
date_upd = NOW()
WHERE id_product = '18538'
08/05/2024 10:40:09 am >> UPDATE ps_product_lang SET
name = 'PRESBITERIO - M. D\'AGOSTINO',
description = ''
WHERE id_product = '18538'
08/05/2024 10:40:09 am >> UPDATE ps_product SET
wholesale_price = '7.37',
on_sale = '0',
price = '11.0000'
WHERE id_product = '18538'
08/05/2024 10:40:09 am >> UPDATE ps_product_shop SET
wholesale_price = '7.37',
price = '11.0000',
id_tax_rules_group = '4',
id_category_default = '27',
id_argoment_default = '41',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '18538'
08/05/2024 10:40:09 am >> DELETE FROM ps_specific_price WHERE id_product = '18538'
08/05/2024 11:10:40 am >> SELECT ean13 FROM ps_product WHERE ean13 = '000327' AND id_product != '8147' AND ean13 != ''
08/05/2024 11:10:40 am >> UPDATE ps_product SET
id_supplier = '77',
reference = '2013',
ean13 = '000327',
date_upd = NOW()
WHERE id_product = '8147'
08/05/2024 11:10:40 am >> UPDATE ps_product_lang SET
name = 'POLO BASIC',
description = ''
WHERE id_product = '8147'
08/05/2024 11:10:40 am >> UPDATE ps_product SET
wholesale_price = '10.50',
on_sale = '0',
price = '24.59016393442623'
WHERE id_product = '8147'
08/05/2024 11:10:40 am >> UPDATE ps_product_shop SET
wholesale_price = '10.50',
price = '24.59016393442623',
id_tax_rules_group = '1',
id_category_default = '253',
id_argoment_default = '42',
id_internal_category = '3',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '8147'
08/05/2024 11:10:40 am >> DELETE FROM ps_specific_price WHERE id_product = '8147'
08/05/2024 11:12:53 am >> SELECT ean13 FROM ps_product WHERE ean13 = '000851' AND id_product != '8082' AND ean13 != ''
08/05/2024 11:12:53 am >> UPDATE ps_product SET
id_supplier = '77',
reference = '2016',
ean13 = '000851',
date_upd = NOW()
WHERE id_product = '8082'
08/05/2024 11:12:53 am >> UPDATE ps_product_lang SET
name = 'POLO LIMITED ',
description = ''
WHERE id_product = '8082'
08/05/2024 11:12:53 am >> UPDATE ps_product SET
wholesale_price = '12.00',
on_sale = '0',
price = '27.049180327868854'
WHERE id_product = '8082'
08/05/2024 11:12:53 am >> UPDATE ps_product_shop SET
wholesale_price = '12.00',
price = '27.049180327868854',
id_tax_rules_group = '1',
id_category_default = '253',
id_argoment_default = '42',
id_internal_category = '3',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '8082'
08/05/2024 11:12:53 am >> DELETE FROM ps_specific_price WHERE id_product = '8082'
08/05/2024 11:13:13 am >> SELECT ean13 FROM ps_product WHERE ean13 = '000853' AND id_product != '8079' AND ean13 != ''
08/05/2024 11:13:13 am >> UPDATE ps_product SET
id_supplier = '',
reference = '2016',
ean13 = '000853',
date_upd = NOW()
WHERE id_product = '8079'
08/05/2024 11:13:13 am >> UPDATE ps_product_lang SET
name = 'POLO LIMITED EXTRA',
description = ''
WHERE id_product = '8079'
08/05/2024 11:13:13 am >> UPDATE ps_product SET
wholesale_price = '13.10',
on_sale = '0',
price = '28.688524590163937'
WHERE id_product = '8079'
08/05/2024 11:13:13 am >> UPDATE ps_product_shop SET
wholesale_price = '13.10',
price = '28.688524590163937',
id_tax_rules_group = '1',
id_category_default = '253',
id_argoment_default = '42',
id_internal_category = '3',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '8079'
08/05/2024 11:13:13 am >> DELETE FROM ps_specific_price WHERE id_product = '8079'
08/05/2024 11:42:24 am >> SELECT document_num FROM ps_document
WHERE document_num = '1486' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-08')
08/05/2024 11:42:24 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' ,
'1486' ,
'2024-05-08' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'22.30' ,
'21.44' ,
NOW() ,
NOW() )
08/05/2024 11:42:24 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 = '91681'
08/05/2024 11:42:24 am >> DELETE FROM ps_document_detail WHERE id_document = '91681'
08/05/2024 11:42:24 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
( '91681' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '4' , '-4' , '3' ,
'3.50' , '3.3653846153846' , '4' , '0' , '14.00' )
08/05/2024 11:42:24 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
( '91681' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' ,
'4.30' , '4.1346153846154' , '4' , '0' , '4.30' )
08/05/2024 11:42:24 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
( '91681' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' ,
'2.00' , '1.9230769230769' , '4' , '0' , '4.00' )
08/05/2024 11:42:46 am >> SELECT document_num FROM ps_document
WHERE document_num = '1487' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-08')
08/05/2024 11:42:46 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' ,
'1487' ,
'2024-05-08' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'54.00' ,
'44.26' ,
NOW() ,
NOW() )
08/05/2024 11:42:46 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 = '91682'
08/05/2024 11:42:46 am >> DELETE FROM ps_document_detail WHERE id_document = '91682'
08/05/2024 11:42:46 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
( '91682' , '22354' , 'CROCE SACRAMENTI VARI - 646' , '36' , '-36' , '1' ,
'1.5' , '1.2295081967213' , '22' , '0' , '54.00' )
08/05/2024 12:09:11 pm >> SELECT document_num FROM ps_document
WHERE document_num = '1488' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-08')
08/05/2024 12:09:11 pm >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'1488' ,
'2024-05-08' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'173.80' ,
'143.88' ,
NOW() ,
NOW() )
08/05/2024 12:09: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 = '91683'
08/05/2024 12:09:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '91683'
08/05/2024 12:09: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
( '91683' , '1914' , 'CERA DELLA LITURGIA' , '24' , '-24' , '1' ,
'4.7' , '3.8524590163934' , '22' , '0' , '112.80' )
08/05/2024 12:09: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
( '91683' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' ,
'8.5' , '6.9672131147541' , '22' , '0' , '51.00' )
08/05/2024 12:09: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
( '91683' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' ,
'2.00' , '1.9230769230769' , '4' , '0' , '10.00' )
08/05/2024 12:09:51 pm >> SELECT document_num FROM ps_document
WHERE document_num = '1489' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-08')
08/05/2024 12:09: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 (
'11' ,
'1489' ,
'2024-05-08' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'95.00' ,
'77.87' ,
NOW() ,
NOW() )
08/05/2024 12:09: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 = '91684'
08/05/2024 12:09:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '91684'
08/05/2024 12:09: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
( '91684' , '22199' , 'VINO LIQUOROSO ROSSO ' , '6' , '-6' , '1' ,
'7.5' , '6.1475409836066' , '22' , '0' , '45.00' )
08/05/2024 12:09: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
( '91684' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' ,
'50' , '40.983606557377' , '22' , '0' , '50.00' )
08/05/2024 12:14:10 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' ,
'351' ,
'2024-05-02' ,
'' ,
'0' ,
'163' ,
'4674530' ,
'VIA CORTI 29 24126 BERGAMO' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'3' ,
'0' ,
'384.30' ,
'315.00' ,
NOW() ,
NOW() )
08/05/2024 12:14:10 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91685'
08/05/2024 12:14:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '91685'
08/05/2024 12:14:10 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '91685' , '22470' , 'COTTA - 989P/ML/2' , '1' , '1' , '1' ,
'105' , '86.065573770492' , '22' , '0' , '128.1000' )
08/05/2024 12:14:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22470' AND id_supplier = '163'
08/05/2024 12:14:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22470' , '163' , '1' )
08/05/2024 12:14: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
( '91685' , '19791' , 'STOLA IN LANA BALZA CON RICAMO - 661' , '5' , '5' , '1' ,
'42' , '34.426229508197' , '22' , '0' , '256.2000' )
08/05/2024 12:14:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19791' AND id_supplier = '163'
08/05/2024 12:14:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19791' , '163' , '1' )
08/05/2024 12:20:43 pm >> SELECT document_num FROM ps_document
WHERE document_num = '1490' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-08')
08/05/2024 12:20: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' ,
'1490' ,
'2024-05-08' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'9.00' ,
'7.38' ,
NOW() ,
NOW() )
08/05/2024 12:20: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 = '91686'
08/05/2024 12:20:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '91686'
08/05/2024 12:20: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
( '91686' , '3144' , 'CROCE TRILOBATA ' , '2' , '-2' , '1' ,
'4.50' , '3.6885245901639' , '22' , '0' , '9.00' )
08/05/2024 12:25:46 pm >> SELECT document_num FROM ps_document
WHERE document_num = '1491' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-08')
08/05/2024 12:25:46 pm >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'1491' ,
'2024-05-08' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'78.00' ,
'63.93' ,
NOW() ,
NOW() )
08/05/2024 12:25:46 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91687'
08/05/2024 12:25:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '91687'
08/05/2024 12:25: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
( '91687' , '15387' , 'VESTINA BATTESIMALE ' , '20' , '-20' , '1' ,
'2.5' , '2.0491803278689' , '22' , '0' , '50.00' )
08/05/2024 12:25: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
( '91687' , '791' , 'ASSISI IN BUSTA BATTESIMO - 20X270 - BAAS' , '20' , '-20' , '1' ,
'1.40' , '1.1475409836066' , '22' , '0' , '28.00' )
08/05/2024 12:32:16 pm >> SELECT document_num FROM ps_document
WHERE document_num = '1492' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-08')
08/05/2024 12:32: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 (
'11' ,
'1492' ,
'2024-05-08' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'11.40' ,
'11.40' ,
NOW() ,
NOW() )
08/05/2024 12:32: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 = '91688'
08/05/2024 12:32:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '91688'
08/05/2024 12:32: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
( '91688' , '22181' , 'MESSALINO QUOTIDIANO - MAG/GIU/LUG 2024' , '1' , '-1' , '4' ,
'6.00' , '6' , '0' , '5' , '5.70' )
08/05/2024 12:32: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
( '91688' , '22388' , 'MESSALINO QUOTIDIANO - AGO SET OTT' , '1' , '-1' , '4' ,
'6.00' , '6' , '0' , '5' , '5.70' )
08/05/2024 12:57:38 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884049308' AND id_product != '22509' AND ean13 != ''
08/05/2024 12:57:38 pm >> UPDATE ps_product SET
id_supplier = '',
reference = 'espositore shalom',
ean13 = '9788884049308',
date_upd = NOW()
WHERE id_product = '22509'
08/05/2024 12:57:38 pm >> UPDATE ps_product_lang SET
name = 'SANTA GEMMA E IL DIAVOLO - 8607',
description = ''
WHERE id_product = '22509'
08/05/2024 12:57:38 pm >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '9'
WHERE id_product = '22509'
08/05/2024 12:57:38 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '9',
id_tax_rules_group = '4',
id_category_default = '106',
id_argoment_default = '10',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '22509'
08/05/2024 12:57:38 pm >> DELETE FROM ps_specific_price WHERE id_product = '22509'
08/05/2024 12:57:57 pm >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'31' ,
'7111/00/2024' ,
'2024-05-07' ,
'00' ,
'0' ,
'38' ,
'2633' ,
'VIA GALVANI, 1 60020 CAMERATA PICENA' ,
'' ,
'' ,
'7.75' ,
'1' ,
'0' ,
'0' ,
'0' ,
'' ,
'1' ,
'0' ,
'124.06' ,
'122.35' ,
NOW() ,
NOW() )
08/05/2024 12:57: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 = '91689'
08/05/2024 12:57:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '91689'
08/05/2024 12:57: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
( '91689' , '22341' , 'SULLA TUA PAROLA - MAG/GIU 2024' , '31' , '31' , '4' ,
'5.00' , '5' , '0' , '40' , '93.0000' )
08/05/2024 12:57:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22341' AND id_supplier = '38'
08/05/2024 12:57:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22341' , '38' , '1' )
08/05/2024 12:57: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
( '91689' , '6417' , 'MESE DI MAGGIO CON LE GLORIE DI MARIA - 8463' , '3' , '3' , '4' ,
'9.00' , '9' , '0' , '40' , '16.2000' )
08/05/2024 12:57:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6417' AND id_supplier = '38'
08/05/2024 12:57:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6417' , '38' , '1' )
08/05/2024 12:57: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
( '91689' , '22509' , 'SANTA GEMMA E IL DIAVOLO - 8607' , '1' , '1' , '4' ,
'9.00' , '9' , '0' , '40' , '5.4000' )
08/05/2024 12:57:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22509' AND id_supplier = '38'
08/05/2024 12:57:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22509' , '38' , '1' )
08/05/2024 03:15:09 pm >> SELECT document_num FROM ps_document
WHERE document_num = '1493' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-08')
08/05/2024 03:15:09 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' ,
'1493' ,
'2024-05-08' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'25.64' ,
'25.64' ,
NOW() ,
NOW() )
08/05/2024 03:15:09 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 = '91690'
08/05/2024 03:15:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '91690'
08/05/2024 03:15:09 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '91690' , '17257' , 'IO TI BATTEZZO ' , '3' , '-3' , '4' ,
'1.80' , '1.8' , '0' , '0' , '5.40' )
08/05/2024 03:15:09 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '91690' , '12253' , 'MIO LIBRO DI PREGHIERE' , '3' , '-3' , '4' ,
'2.80' , '2.8' , '0' , '5' , '7.98' )
08/05/2024 03:15:09 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '91690' , '17734' , 'VANGELO E ATTI BAMBINI' , '3' , '-3' , '4' ,
'3.00' , '3' , '0' , '5' , '8.55' )
08/05/2024 03:15:09 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '91690' , '22370' , 'DIGNITAS INFINITA' , '1' , '-1' , '4' ,
'3.90' , '3.9' , '0' , '5' , '3.71' )
08/05/2024 03:34:57 pm >> SELECT document_num FROM ps_document
WHERE document_num = '1494' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-08')
08/05/2024 03:34:57 pm >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'1494' ,
'2024-05-08' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'137.75' ,
'137.75' ,
NOW() ,
NOW() )
08/05/2024 03:34: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 = '91691'
08/05/2024 03:34:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '91691'
08/05/2024 03:34: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
( '91691' , '22341' , 'SULLA TUA PAROLA - MAG/GIU 2024' , '29' , '-29' , '4' ,
'5.00' , '5' , '0' , '5' , '137.75' )
08/05/2024 03:35:20 pm >> SELECT document_num FROM ps_document
WHERE document_num = '1495' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-08')
08/05/2024 03:35:20 pm >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'1495' ,
'2024-05-08' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'25.00' ,
'20.49' ,
NOW() ,
NOW() )
08/05/2024 03:35: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 = '91692'
08/05/2024 03:35:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '91692'
08/05/2024 03:35: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
( '91692' , '11805' , 'TECA IHS - 823' , '1' , '-1' , '1' ,
'25.00' , '20.491803278689' , '22' , '0' , '25.00' )
08/05/2024 03:37:57 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791281253438' AND id_product != '22388' AND ean13 != ''
08/05/2024 03:37:57 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '7/4',
ean13 = '9791281253438',
date_upd = NOW()
WHERE id_product = '22388'
08/05/2024 03:37:57 pm >> UPDATE ps_product_lang SET
name = 'MESSALINO QUOTIDIANO - AGO/SET/OTT 2024',
description = ''
WHERE id_product = '22388'
08/05/2024 03:37:57 pm >> UPDATE ps_product SET
wholesale_price = '4.20',
on_sale = '0',
price = '6.0000'
WHERE id_product = '22388'
08/05/2024 03:37:57 pm >> UPDATE ps_product_shop SET
wholesale_price = '4.20',
price = '6.0000',
id_tax_rules_group = '4',
id_category_default = '518',
id_argoment_default = '64',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '22388'
08/05/2024 03:37:57 pm >> DELETE FROM ps_specific_price WHERE id_product = '22388'
08/05/2024 03:39:31 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788817183789' AND id_product != '22214' AND ean13 != ''
08/05/2024 03:39:31 pm >> UPDATE ps_product SET
id_supplier = '47',
reference = '6/6',
ean13 = '9788817183789',
date_upd = NOW()
WHERE id_product = '22214'
08/05/2024 03:39:31 pm >> UPDATE ps_product_lang SET
name = 'VIE DI MARIA - F. DE CRISTOFARO',
description = ''
WHERE id_product = '22214'
08/05/2024 03:39:31 pm >> UPDATE ps_product SET
wholesale_price = '9.10',
on_sale = '0',
price = '13.0000'
WHERE id_product = '22214'
08/05/2024 03:39:31 pm >> UPDATE ps_product_shop SET
wholesale_price = '9.10',
price = '13.0000',
id_tax_rules_group = '4',
id_category_default = '239',
id_argoment_default = '10',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '22214'
08/05/2024 03:39:31 pm >> DELETE FROM ps_specific_price WHERE id_product = '22214'
08/05/2024 03:39:47 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791280546517' AND id_product != '20772' AND ean13 != ''
08/05/2024 03:39:47 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '6/6',
ean13 = '9791280546517',
date_upd = NOW()
WHERE id_product = '20772'
08/05/2024 03:39:47 pm >> UPDATE ps_product_lang SET
name = 'VADO E TORNERO\' DA VOI - L. VOZZA',
description = ''
WHERE id_product = '20772'
08/05/2024 03:39:47 pm >> UPDATE ps_product SET
wholesale_price = '7.00',
on_sale = '0',
price = '10.0000'
WHERE id_product = '20772'
08/05/2024 03:39:47 pm >> UPDATE ps_product_shop SET
wholesale_price = '7.00',
price = '10.0000',
id_tax_rules_group = '4',
id_category_default = '483',
id_argoment_default = '23',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '20772'
08/05/2024 03:39:47 pm >> DELETE FROM ps_specific_price WHERE id_product = '20772'
08/05/2024 03:39:57 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892243644' AND id_product != '22325' AND ean13 != ''
08/05/2024 03:39:57 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '6/6',
ean13 = '9788892243644',
date_upd = NOW()
WHERE id_product = '22325'
08/05/2024 03:39:57 pm >> UPDATE ps_product_lang SET
name = 'PREGHIERA DEI SALMI - R. VIRGILI',
description = ''
WHERE id_product = '22325'
08/05/2024 03:39:57 pm >> UPDATE ps_product SET
wholesale_price = '9.38',
on_sale = '0',
price = '14.0000'
WHERE id_product = '22325'
08/05/2024 03:39:58 pm >> UPDATE ps_product_shop SET
wholesale_price = '9.38',
price = '14.0000',
id_tax_rules_group = '4',
id_category_default = '30',
id_argoment_default = '20',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '22325'
08/05/2024 03:39:58 pm >> DELETE FROM ps_specific_price WHERE id_product = '22325'
08/05/2024 03:40:19 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892871397' AND id_product != '22321' AND ean13 != ''
08/05/2024 03:40:19 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '6/6',
ean13 = '9788892871397',
date_upd = NOW()
WHERE id_product = '22321'
08/05/2024 03:40:19 pm >> UPDATE ps_product_lang SET
name = 'PERDONO CHE GUARISCE - L. PASQUA',
description = ''
WHERE id_product = '22321'
08/05/2024 03:40:19 pm >> UPDATE ps_product SET
wholesale_price = '11.20',
on_sale = '0',
price = '16.0000'
WHERE id_product = '22321'
08/05/2024 03:40:19 pm >> UPDATE ps_product_shop SET
wholesale_price = '11.20',
price = '16.0000',
id_tax_rules_group = '4',
id_category_default = '26',
id_argoment_default = '78',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '22321'
08/05/2024 03:40:19 pm >> DELETE FROM ps_specific_price WHERE id_product = '22321'
08/05/2024 03:40:32 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831555593' AND id_product != '20728' AND ean13 != ''
08/05/2024 03:40:32 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '6/6',
ean13 = '9788831555593',
date_upd = NOW()
WHERE id_product = '20728'
08/05/2024 03:40:32 pm >> UPDATE ps_product_lang SET
name = 'OCCHI CHE SI APRONO',
description = ''
WHERE id_product = '20728'
08/05/2024 03:40:32 pm >> UPDATE ps_product SET
wholesale_price = '4.02',
on_sale = '0',
price = '6.0000'
WHERE id_product = '20728'
08/05/2024 03:40:32 pm >> UPDATE ps_product_shop SET
wholesale_price = '4.02',
price = '6.0000',
id_tax_rules_group = '4',
id_category_default = '27',
id_argoment_default = '50',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '20728'
08/05/2024 03:40:32 pm >> DELETE FROM ps_specific_price WHERE id_product = '20728'
08/05/2024 03:40:41 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892243804' AND id_product != '22172' AND ean13 != ''
08/05/2024 03:40:41 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '6/6',
ean13 = '9788892243804',
date_upd = NOW()
WHERE id_product = '22172'
08/05/2024 03:40:41 pm >> UPDATE ps_product_lang SET
name = 'NEL GREMBO DELLA PAROLA - R. MANGOLINI',
description = ''
WHERE id_product = '22172'
08/05/2024 03:40:41 pm >> UPDATE ps_product SET
wholesale_price = '12.06',
on_sale = '0',
price = '18.0000'
WHERE id_product = '22172'
08/05/2024 03:40:41 pm >> UPDATE ps_product_shop SET
wholesale_price = '12.06',
price = '18.0000',
id_tax_rules_group = '4',
id_category_default = '30',
id_argoment_default = '23',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '22172'
08/05/2024 03:40:41 pm >> DELETE FROM ps_specific_price WHERE id_product = '22172'
08/05/2024 03:40:53 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788881664535' AND id_product != '22195' AND ean13 != ''
08/05/2024 03:40:53 pm >> UPDATE ps_product SET
id_supplier = '107',
reference = '6/6',
ean13 = '9788881664535',
date_upd = NOW()
WHERE id_product = '22195'
08/05/2024 03:40:53 pm >> UPDATE ps_product_lang SET
name = 'MIE NOTTI CON QOHELET - D.M. TUROLDO',
description = ''
WHERE id_product = '22195'
08/05/2024 03:40:53 pm >> UPDATE ps_product SET
wholesale_price = '9.75',
on_sale = '0',
price = '15.0000'
WHERE id_product = '22195'
08/05/2024 03:40:53 pm >> UPDATE ps_product_shop SET
wholesale_price = '9.75',
price = '15.0000',
id_tax_rules_group = '4',
id_category_default = '225',
id_argoment_default = '23',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '22195'
08/05/2024 03:40:53 pm >> DELETE FROM ps_specific_price WHERE id_product = '22195'
08/05/2024 03:41:04 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892240117' AND id_product != '21816' AND ean13 != ''
08/05/2024 03:41:05 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '6/6',
ean13 = '9788892240117',
date_upd = NOW()
WHERE id_product = '21816'
08/05/2024 03:41:05 pm >> UPDATE ps_product_lang SET
name = 'MESSAGGIO AI GIOVANI - C.M. MARTINI',
description = ''
WHERE id_product = '21816'
08/05/2024 03:41:05 pm >> UPDATE ps_product SET
wholesale_price = '8.04',
on_sale = '0',
price = '12.0000'
WHERE id_product = '21816'
08/05/2024 03:41:05 pm >> UPDATE ps_product_shop SET
wholesale_price = '8.04',
price = '12.0000',
id_tax_rules_group = '4',
id_category_default = '30',
id_argoment_default = '72',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '21816'
08/05/2024 03:41:05 pm >> DELETE FROM ps_specific_price WHERE id_product = '21816'
08/05/2024 03:41:14 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791259623287' AND id_product != '21550' AND ean13 != ''
08/05/2024 03:41:14 pm >> UPDATE ps_product SET
id_supplier = '109',
reference = '6/6',
ean13 = '9791259623287',
date_upd = NOW()
WHERE id_product = '21550'
08/05/2024 03:41:14 pm >> UPDATE ps_product_lang SET
name = 'MANUALE DEL DIAVOLO - R. CAMILLERI',
description = ''
WHERE id_product = '21550'
08/05/2024 03:41:14 pm >> UPDATE ps_product SET
wholesale_price = '14.94',
on_sale = '0',
price = '23.0000'
WHERE id_product = '21550'
08/05/2024 03:41:14 pm >> UPDATE ps_product_shop SET
wholesale_price = '14.94',
price = '23.0000',
id_tax_rules_group = '4',
id_category_default = '143',
id_argoment_default = '10',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '21550'
08/05/2024 03:41:14 pm >> DELETE FROM ps_specific_price WHERE id_product = '21550'
08/05/2024 03:41:25 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788825057294' AND id_product != '22227' AND ean13 != ''
08/05/2024 03:41:25 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '6/6',
ean13 = '9788825057294',
date_upd = NOW()
WHERE id_product = '22227'
08/05/2024 03:41:25 pm >> UPDATE ps_product_lang SET
name = 'MALE NEGLI OCCHI DELL\'AMORE - G. BORGHI',
description = ''
WHERE id_product = '22227'
08/05/2024 03:41:25 pm >> UPDATE ps_product SET
wholesale_price = '9.80',
on_sale = '0',
price = '14.0000'
WHERE id_product = '22227'
08/05/2024 03:41:25 pm >> UPDATE ps_product_shop SET
wholesale_price = '9.80',
price = '14.0000',
id_tax_rules_group = '4',
id_category_default = '17',
id_argoment_default = '10',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '22227'
08/05/2024 03:41:25 pm >> DELETE FROM ps_specific_price WHERE id_product = '22227'
08/05/2024 03:41:36 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788868946616' AND id_product != '21827' AND ean13 != ''
08/05/2024 03:41:36 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '6/6',
ean13 = '9788868946616',
date_upd = NOW()
WHERE id_product = '21827'
08/05/2024 03:41:36 pm >> UPDATE ps_product_lang SET
name = 'GIOIA DEL CUORE - C. STERCAL',
description = ''
WHERE id_product = '21827'
08/05/2024 03:41:36 pm >> UPDATE ps_product SET
wholesale_price = '7.00',
on_sale = '0',
price = '10.0000'
WHERE id_product = '21827'
08/05/2024 03:41:36 pm >> UPDATE ps_product_shop SET
wholesale_price = '7.00',
price = '10.0000',
id_tax_rules_group = '4',
id_category_default = '103',
id_argoment_default = '23',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '21827'
08/05/2024 03:41:36 pm >> DELETE FROM ps_specific_price WHERE id_product = '21827'
08/05/2024 03:41:51 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892240100' AND id_product != '21815' AND ean13 != ''
08/05/2024 03:41:51 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '6/6',
ean13 = '9788892240100',
date_upd = NOW()
WHERE id_product = '21815'
08/05/2024 03:41:51 pm >> UPDATE ps_product_lang SET
name = 'FRUTTI DELLO SPIRITO - C.M. MARTINI',
description = ''
WHERE id_product = '21815'
08/05/2024 03:41:51 pm >> UPDATE ps_product SET
wholesale_price = '8.04',
on_sale = '0',
price = '12.0000'
WHERE id_product = '21815'
08/05/2024 03:41:51 pm >> UPDATE ps_product_shop SET
wholesale_price = '8.04',
price = '12.0000',
id_tax_rules_group = '4',
id_category_default = '30',
id_argoment_default = '72',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '21815'
08/05/2024 03:41:51 pm >> DELETE FROM ps_specific_price WHERE id_product = '21815'
08/05/2024 03:41:59 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788873577140' AND id_product != '22056' AND ean13 != ''
08/05/2024 03:41:59 pm >> UPDATE ps_product SET
id_supplier = '107',
reference = '6/6',
ean13 = '9788873577140',
date_upd = NOW()
WHERE id_product = '22056'
08/05/2024 03:41:59 pm >> UPDATE ps_product_lang SET
name = 'E IO VI RISTORERO\' - M. ZUPPI',
description = ''
WHERE id_product = '22056'
08/05/2024 03:41:59 pm >> UPDATE ps_product SET
wholesale_price = '6.50',
on_sale = '0',
price = '10.0000'
WHERE id_product = '22056'
08/05/2024 03:41:59 pm >> UPDATE ps_product_shop SET
wholesale_price = '6.50',
price = '10.0000',
id_tax_rules_group = '4',
id_category_default = '178',
id_argoment_default = '23',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '22056'
08/05/2024 03:41:59 pm >> DELETE FROM ps_specific_price WHERE id_product = '22056'
08/05/2024 03:42:07 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788873577089' AND id_product != '21462' AND ean13 != ''
08/05/2024 03:42:07 pm >> UPDATE ps_product SET
id_supplier = '107',
reference = '6/6',
ean13 = '9788873577089',
date_upd = NOW()
WHERE id_product = '21462'
08/05/2024 03:42:07 pm >> UPDATE ps_product_lang SET
name = 'DIO IN CUI CREDIAMO - M. LAVRA',
description = ''
WHERE id_product = '21462'
08/05/2024 03:42:07 pm >> UPDATE ps_product SET
wholesale_price = '9.10',
on_sale = '0',
price = '14.0000'
WHERE id_product = '21462'
08/05/2024 03:42:07 pm >> UPDATE ps_product_shop SET
wholesale_price = '9.10',
price = '14.0000',
id_tax_rules_group = '4',
id_category_default = '178',
id_argoment_default = '23',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '21462'
08/05/2024 03:42:07 pm >> DELETE FROM ps_specific_price WHERE id_product = '21462'
08/05/2024 03:42:16 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831557115' AND id_product != '22264' AND ean13 != ''
08/05/2024 03:42:16 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '6/6',
ean13 = '9788831557115',
date_upd = NOW()
WHERE id_product = '22264'
08/05/2024 03:42:16 pm >> UPDATE ps_product_lang SET
name = 'DIECI CAMMELLI INGINOCCHIATI - E. RONCHI',
description = ''
WHERE id_product = '22264'
08/05/2024 03:42:16 pm >> UPDATE ps_product SET
wholesale_price = '9.38',
on_sale = '0',
price = '14.0000'
WHERE id_product = '22264'
08/05/2024 03:42:16 pm >> UPDATE ps_product_shop SET
wholesale_price = '9.38',
price = '14.0000',
id_tax_rules_group = '4',
id_category_default = '27',
id_argoment_default = '188',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '22264'
08/05/2024 03:42:16 pm >> DELETE FROM ps_specific_price WHERE id_product = '22264'
08/05/2024 03:42:24 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892240605' AND id_product != '20663' AND ean13 != ''
08/05/2024 03:42:24 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '6/6',
ean13 = '9788892240605',
date_upd = NOW()
WHERE id_product = '20663'
08/05/2024 03:42:24 pm >> UPDATE ps_product_lang SET
name = 'CON MARIA SULLA STRADA DELLA PASQUA - L. FANZAGA',
description = ''
WHERE id_product = '20663'
08/05/2024 03:42:24 pm >> UPDATE ps_product SET
wholesale_price = '8.04',
on_sale = '0',
price = '12.0000'
WHERE id_product = '20663'
08/05/2024 03:42:24 pm >> UPDATE ps_product_shop SET
wholesale_price = '8.04',
price = '12.0000',
id_tax_rules_group = '4',
id_category_default = '30',
id_argoment_default = '23',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '20663'
08/05/2024 03:42:24 pm >> DELETE FROM ps_specific_price WHERE id_product = '20663'
08/05/2024 03:42:32 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892243606' AND id_product != '22079' AND ean13 != ''
08/05/2024 03:42:32 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '6/6',
ean13 = '9788892243606',
date_upd = NOW()
WHERE id_product = '22079'
08/05/2024 03:42:33 pm >> UPDATE ps_product_lang SET
name = 'CAMMINANDO VERSO LA PASQUA - E. FORTUNATO',
description = ''
WHERE id_product = '22079'
08/05/2024 03:42:33 pm >> UPDATE ps_product SET
wholesale_price = '8.04',
on_sale = '0',
price = '12.0000'
WHERE id_product = '22079'
08/05/2024 03:42:33 pm >> UPDATE ps_product_shop SET
wholesale_price = '8.04',
price = '12.0000',
id_tax_rules_group = '4',
id_category_default = '30',
id_argoment_default = '50',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '22079'
08/05/2024 03:42:33 pm >> DELETE FROM ps_specific_price WHERE id_product = '22079'
08/05/2024 03:42:39 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788873577096' AND id_product != '22022' AND ean13 != ''
08/05/2024 03:42:39 pm >> UPDATE ps_product SET
id_supplier = '107',
reference = '6/6',
ean13 = '9788873577096',
date_upd = NOW()
WHERE id_product = '22022'
08/05/2024 03:42:39 pm >> UPDATE ps_product_lang SET
name = 'ADAMO DOVE SEI? R. COLIZZI',
description = ''
WHERE id_product = '22022'
08/05/2024 03:42:40 pm >> UPDATE ps_product SET
wholesale_price = '6.50',
on_sale = '0',
price = '10.0000'
WHERE id_product = '22022'
08/05/2024 03:42:40 pm >> UPDATE ps_product_shop SET
wholesale_price = '6.50',
price = '10.0000',
id_tax_rules_group = '4',
id_category_default = '178',
id_argoment_default = '23',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '22022'
08/05/2024 03:42:40 pm >> DELETE FROM ps_specific_price WHERE id_product = '22022'
08/05/2024 03:42:52 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892240728' AND id_product != '20761' AND ean13 != ''
08/05/2024 03:42:52 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '6/6',
ean13 = '9788892240728',
date_upd = NOW()
WHERE id_product = '20761'
08/05/2024 03:42:53 pm >> UPDATE ps_product_lang SET
name = 'LUCE ATTRAVERSO IL TEMPO - M. CAMISASCA',
description = ''
WHERE id_product = '20761'
08/05/2024 03:42:53 pm >> UPDATE ps_product SET
wholesale_price = '14.74',
on_sale = '0',
price = '22.0000'
WHERE id_product = '20761'
08/05/2024 03:42:53 pm >> UPDATE ps_product_shop SET
wholesale_price = '14.74',
price = '22.0000',
id_tax_rules_group = '4',
id_category_default = '30',
id_argoment_default = '10',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '20761'
08/05/2024 03:42:53 pm >> DELETE FROM ps_specific_price WHERE id_product = '20761'
08/05/2024 03:43:02 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892243576' AND id_product != '22228' AND ean13 != ''
08/05/2024 03:43:02 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '6/6',
ean13 = '9788892243576',
date_upd = NOW()
WHERE id_product = '22228'
08/05/2024 03:43:02 pm >> UPDATE ps_product_lang SET
name = 'PAROLA MI RACCONTA - P. CURTAZ',
description = ''
WHERE id_product = '22228'
08/05/2024 03:43:02 pm >> UPDATE ps_product SET
wholesale_price = '10.05',
on_sale = '0',
price = '15.0000'
WHERE id_product = '22228'
08/05/2024 03:43:02 pm >> UPDATE ps_product_shop SET
wholesale_price = '10.05',
price = '15.0000',
id_tax_rules_group = '4',
id_category_default = '30',
id_argoment_default = '10',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '22228'
08/05/2024 03:43:02 pm >> DELETE FROM ps_specific_price WHERE id_product = '22228'
08/05/2024 03:53:33 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000163' AND id_product != '791' AND ean13 != ''
08/05/2024 03:53:33 pm >> UPDATE ps_product SET
id_supplier = '31',
reference = '2013',
ean13 = '000163',
date_upd = NOW()
WHERE id_product = '791'
08/05/2024 03:53:33 pm >> UPDATE ps_product_lang SET
name = 'ASSISI IN BUSTA BATTESIMO - 20X270 - BAAS',
description = ''
WHERE id_product = '791'
08/05/2024 03:53:33 pm >> UPDATE ps_product SET
wholesale_price = '0.69',
on_sale = '0',
price = '1.2295081967213115'
WHERE id_product = '791'
08/05/2024 03:53:33 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.69',
price = '1.2295081967213115',
id_tax_rules_group = '1',
id_category_default = '169',
id_argoment_default = '42',
id_internal_category = '3',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '791'
08/05/2024 03:53:33 pm >> DELETE FROM ps_specific_price WHERE id_product = '791'
08/05/2024 03:56:56 pm >> UPDATE ps_product_shop SET
minimal_quantity = '1',
multiple_quantity = '1',
available_date = '',
date_upd = NOW()
WHERE id_product = '13140'
08/05/2024 03:56:56 pm >> UPDATE ps_stock_available SET quantity = quantity + '-6' WHERE id_product = '13140'
08/05/2024 04:13:59 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000055' AND id_product != '13142' AND ean13 != ''
08/05/2024 04:13:59 pm >> UPDATE ps_product SET
id_supplier = '31',
reference = '',
ean13 = '000055',
date_upd = NOW()
WHERE id_product = '13142'
08/05/2024 04:13:59 pm >> UPDATE ps_product_lang SET
name = 'CERETTI DIAM 26X350 - 2635',
description = ''
WHERE id_product = '13142'
08/05/2024 04:13:59 pm >> UPDATE ps_product SET
wholesale_price = '1.05',
on_sale = '0',
price = '2.0491803278688523'
WHERE id_product = '13142'
08/05/2024 04:13:59 pm >> UPDATE ps_product_shop SET
wholesale_price = '1.05',
price = '2.0491803278688523',
id_tax_rules_group = '1',
id_category_default = '169',
id_argoment_default = '42',
id_internal_category = '3',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '13142'
08/05/2024 04:13:59 pm >> DELETE FROM ps_specific_price WHERE id_product = '13142'
08/05/2024 04:20:22 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000646' AND id_product != '1936' AND ean13 != ''
08/05/2024 04:20:22 pm >> UPDATE ps_product SET
id_supplier = '31',
reference = '2014',
ean13 = '000646',
date_upd = NOW()
WHERE id_product = '1936'
08/05/2024 04:20:22 pm >> UPDATE ps_product_lang SET
name = 'CERETTI DIAM 26X700 ART. 400',
description = ''
WHERE id_product = '1936'
08/05/2024 04:20:22 pm >> UPDATE ps_product SET
wholesale_price = '1.71',
on_sale = '0',
price = '3.19672131147541'
WHERE id_product = '1936'
08/05/2024 04:20:22 pm >> UPDATE ps_product_shop SET
wholesale_price = '1.71',
price = '3.19672131147541',
id_tax_rules_group = '1',
id_category_default = '169',
id_argoment_default = '42',
id_internal_category = '3',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '1936'
08/05/2024 04:20:22 pm >> DELETE FROM ps_specific_price WHERE id_product = '1936'
08/05/2024 05:02:34 pm >> SELECT document_num FROM ps_document
WHERE document_num = '1496' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-08')
08/05/2024 05:02:34 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' ,
'1496' ,
'2024-05-08' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'55.00' ,
'45.08' ,
NOW() ,
NOW() )
08/05/2024 05:02: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 = '91693'
08/05/2024 05:02:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '91693'
08/05/2024 05:02: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
( '91693' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' ,
'55' , '45.081967213115' , '22' , '0' , '55.00' )
08/05/2024 05:15:03 pm >> SELECT document_num FROM ps_document
WHERE document_num = '1497' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-08')
08/05/2024 05:15: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' ,
'1497' ,
'2024-05-08' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'27.90' ,
'24.93' ,
NOW() ,
NOW() )
08/05/2024 05:15: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 = '91694'
08/05/2024 05:15:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '91694'
08/05/2024 05:15: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
( '91694' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' ,
'8.90' , '7.2950819672131' , '22' , '0' , '8.90' )
08/05/2024 05:15: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
( '91694' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '3' , '-3' , '3' ,
'3.50' , '3.3653846153846' , '4' , '0' , '10.50' )
08/05/2024 05:15: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
( '91694' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' ,
'2.00' , '1.9230769230769' , '4' , '0' , '4.00' )
08/05/2024 05:15: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
( '91694' , '6809' , 'MOCCOLO 60X165' , '1' , '-1' , '1' ,
'4.50' , '3.6885245901639' , '22' , '0' , '4.50' )
08/05/2024 05:42:49 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400327519' AND id_product != '19601' AND ean13 != ''
08/05/2024 05:42:49 pm >> UPDATE ps_product SET
id_supplier = '28',
reference = '',
ean13 = '8058400327519',
date_upd = NOW()
WHERE id_product = '19601'
08/05/2024 05:42:49 pm >> UPDATE ps_product_lang SET
name = 'ANGELO ALI TORTORA - 4231',
description = ''
WHERE id_product = '19601'
08/05/2024 05:42:49 pm >> UPDATE ps_product SET
wholesale_price = '3.60',
on_sale = '0',
price = '8.19672131147541'
WHERE id_product = '19601'
08/05/2024 05:42:49 pm >> UPDATE ps_product_shop SET
wholesale_price = '3.60',
price = '8.19672131147541',
id_tax_rules_group = '1',
id_category_default = '95',
id_argoment_default = '42',
id_internal_category = '3',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '19601'
08/05/2024 05:42:49 pm >> DELETE FROM ps_specific_price WHERE id_product = '19601'
08/05/2024 05:42:56 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400303803' AND id_product != '15591' AND ean13 != ''
08/05/2024 05:42:56 pm >> UPDATE ps_product SET
id_supplier = '28',
reference = '',
ean13 = '8058400303803',
date_upd = NOW()
WHERE id_product = '15591'
08/05/2024 05:42:56 pm >> UPDATE ps_product_lang SET
name = 'ANGELO CON CAMPANA ARG. - 4216',
description = ''
WHERE id_product = '15591'
08/05/2024 05:42:56 pm >> UPDATE ps_product SET
wholesale_price = '3.20',
on_sale = '0',
price = '8.19672131147541'
WHERE id_product = '15591'
08/05/2024 05:42:56 pm >> UPDATE ps_product_shop SET
wholesale_price = '3.20',
price = '8.19672131147541',
id_tax_rules_group = '1',
id_category_default = '95',
id_argoment_default = '42',
id_internal_category = '3',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '15591'
08/05/2024 05:42:56 pm >> DELETE FROM ps_specific_price WHERE id_product = '15591'
08/05/2024 05:43:21 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400303803' AND id_product != '15591' AND ean13 != ''
08/05/2024 05:43:21 pm >> UPDATE ps_product SET
id_supplier = '28',
reference = '',
ean13 = '8058400303803',
date_upd = NOW()
WHERE id_product = '15591'
08/05/2024 05:43:21 pm >> UPDATE ps_product_lang SET
name = 'ANGELO CON CAMPANA ARG. - 4216',
description = ''
WHERE id_product = '15591'
08/05/2024 05:43:21 pm >> UPDATE ps_product SET
wholesale_price = '3.20',
on_sale = '0',
price = '7.786885245901639'
WHERE id_product = '15591'
08/05/2024 05:43:21 pm >> UPDATE ps_product_shop SET
wholesale_price = '3.20',
price = '7.786885245901639',
id_tax_rules_group = '1',
id_category_default = '95',
id_argoment_default = '42',
id_internal_category = '3',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '15591'
08/05/2024 05:43:21 pm >> DELETE FROM ps_specific_price WHERE id_product = '15591'
08/05/2024 05:48:04 pm >> SELECT document_num FROM ps_document
WHERE document_num = '1412' AND id_document != '91589' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-03')
08/05/2024 05:48:04 pm >> UPDATE ps_document SET
id_document_type = '11',
document_num = '1412',
document_date = '2024-05-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 = '24.50',
price_tax_excluded = '20.08',
date_upd = NOW()
WHERE id_document = '91589'
08/05/2024 05:48: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 = '91589'
08/05/2024 05:48:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '91589'
08/05/2024 05:48: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
( '91589' , '9150' , 'ROSARIO LEGNO SCURO E CORDA - 99999' , '4' , '-4' , '1' ,
'1.0000' , '0.81967213114754' , '22' , '0' , '4.00' )
08/05/2024 05:48: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
( '91589' , '18129' , 'TAU COLORATO - T56' , '1' , '-1' , '1' ,
'1.2000' , '0.98360655737705' , '22' , '0' , '1.20' )
08/05/2024 05:48: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
( '91589' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '16' , '-16' , '1' ,
'0.2500' , '0.20491803278689' , '22' , '0' , '4.00' )
08/05/2024 05:48: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
( '91589' , '9691' , 'SCAPOLARE DEL CARMELO - PICCOLO - 1215/ITA' , '2' , '-2' , '1' ,
'1.1000' , '0.9016393442623' , '22' , '0' , '2.20' )
08/05/2024 05:48: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
( '91589' , '22409' , 'PIASTRELLA COMUNIONE - 1302/K212' , '1' , '-1' , '1' ,
'8.5' , '6.9672131147541' , '22' , '0' , '8.50' )
08/05/2024 05:48: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
( '91589' , '20437' , 'LUMINO BIANCO 10BTS000' , '2' , '-2' , '1' ,
'0.5000' , '0.40983606557377' , '22' , '0' , '1.00' )
08/05/2024 05:48: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
( '91589' , '2766' , 'CORONA PLASTICA FLUO / BIANCO' , '12' , '-12' , '1' ,
'0.3000' , '0.24590163934426' , '22' , '0' , '3.60' )
08/05/2024 06:19:42 pm >> SELECT document_num FROM ps_document
WHERE document_num = '1498' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-08')
08/05/2024 06:19:42 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' ,
'1498' ,
'2024-05-08' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'255.00' ,
'209.02' ,
NOW() ,
NOW() )
08/05/2024 06:19:42 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 = '91695'
08/05/2024 06:19:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '91695'
08/05/2024 06:19:42 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '91695' , '22470' , 'COTTA - 989P/ML/2' , '1' , '-1' , '1' ,
'255.00' , '209.01639344262' , '22' , '0' , '255.00' )
08/05/2024 06:41:53 pm >> SELECT document_num FROM ps_document
WHERE document_num = '1499' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-08')
08/05/2024 06:41:54 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' ,
'1499' ,
'2024-05-08' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'6.10' ,
'5.47' ,
NOW() ,
NOW() )
08/05/2024 06:41:54 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 = '91696'
08/05/2024 06:41:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '91696'
08/05/2024 06:41:54 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '91696' , '20026' , 'CANDELA VOTIVA 20X40' , '5' , '-5' , '1' ,
'0.70' , '0.57377049180328' , '22' , '0' , '3.50' )
08/05/2024 06:41:54 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '91696' , '7134' , 'NOZIONI E PRECI' , '2' , '-2' , '4' ,
'1.30' , '1.3' , '0' , '0' , '2.60' )
08/05/2024 06:42:48 pm >> SELECT document_num FROM ps_document
WHERE document_num = '1500' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-08')
08/05/2024 06: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 (
'11' ,
'1500' ,
'2024-05-08' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'8.55' ,
'8.55' ,
NOW() ,
NOW() )
08/05/2024 06: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 = '91697'
08/05/2024 06:42:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '91697'
08/05/2024 06: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
( '91697' , '22509' , 'SANTA GEMMA E IL DIAVOLO - 8607' , '1' , '-1' , '4' ,
'9.00' , '9' , '0' , '5' , '8.55' )