27/01/2025 09:20:48 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() )
27/01/2025 09:20:48 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23383' , '1' , '' , 'nuovo-prodotto' )
27/01/2025 09:20:48 am >> INSERT INTO ps_product_shop (
id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd`
) VALUES (
'23383' , '1' , '1' , '2' , NOW() , NOW()
)
27/01/2025 09:20:48 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '23383' , '0' , '1' , '0' , '0' )
27/01/2025 09:22:45 am >> SELECT ean13 FROM ps_product WHERE ean13 = '5902689301384' AND id_product != '15085' AND ean13 != ''
27/01/2025 09:22:45 am >> UPDATE ps_product SET
id_supplier = '123',
reference = '',
ean13 = '5902689301384',
date_upd = NOW()
WHERE id_product = '15085'
27/01/2025 09:22:45 am >> UPDATE ps_product_lang SET
name = 'BRACCIALE DECINA COLORATA - BC506',
description = ''
WHERE id_product = '15085'
27/01/2025 09:22:45 am >> UPDATE ps_product SET
wholesale_price = '0.57',
on_sale = '0',
price = '1.3114754098360657'
WHERE id_product = '15085'
27/01/2025 09:22:46 am >> UPDATE ps_product_shop SET
wholesale_price = '0.57',
price = '1.3114754098360657',
id_tax_rules_group = '1',
id_category_default = '443',
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 = '15085'
27/01/2025 09:22:46 am >> DELETE FROM ps_specific_price WHERE id_product = '15085'
27/01/2025 09:24:07 am >> SELECT ean13 FROM ps_product WHERE ean13 = '5902689301384' AND id_product != '15085' AND ean13 != ''
27/01/2025 09:24:07 am >> UPDATE ps_product SET
id_supplier = '123',
reference = '',
ean13 = '5902689301384',
date_upd = NOW()
WHERE id_product = '15085'
27/01/2025 09:24:07 am >> UPDATE ps_product_lang SET
name = 'BRACCIALE DECINA COLORATA - BC506',
description = ''
WHERE id_product = '15085'
27/01/2025 09:24:07 am >> UPDATE ps_product SET
wholesale_price = '0.57',
on_sale = '0',
price = '1.3114754098360657'
WHERE id_product = '15085'
27/01/2025 09:24:07 am >> UPDATE ps_product_shop SET
wholesale_price = '0.57',
price = '1.3114754098360657',
id_tax_rules_group = '1',
id_category_default = '443',
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 = '15085'
27/01/2025 09:24:07 am >> DELETE FROM ps_specific_price WHERE id_product = '15085'
27/01/2025 09:26:18 am >> SELECT ean13 FROM ps_product WHERE ean13 = '5902689316975' AND id_product != '18895' AND ean13 != ''
27/01/2025 09:26:18 am >> UPDATE ps_product SET
id_supplier = '123',
reference = '',
ean13 = '5902689316975',
date_upd = NOW()
WHERE id_product = '18895'
27/01/2025 09:26:18 am >> UPDATE ps_product_lang SET
name = 'BRACCIALE DECINA COLORATA - B1757N',
description = ''
WHERE id_product = '18895'
27/01/2025 09:26:18 am >> UPDATE ps_product SET
wholesale_price = '0.62',
on_sale = '0',
price = '1.6393'
WHERE id_product = '18895'
27/01/2025 09:26:18 am >> UPDATE ps_product_shop SET
wholesale_price = '0.62',
price = '1.6393',
id_tax_rules_group = '1',
id_category_default = '443',
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 = '18895'
27/01/2025 09:26:18 am >> DELETE FROM ps_specific_price WHERE id_product = '18895'
27/01/2025 09:33:36 am >> SELECT document_num FROM ps_document
WHERE document_num = '262' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-27')
27/01/2025 09:33:36 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' ,
'262' ,
'2025-01-27' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'20.81' ,
'20.81' ,
NOW() ,
NOW() )
27/01/2025 09:33: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 = '95438'
27/01/2025 09:33:36 am >> DELETE FROM ps_document_detail WHERE id_document = '95438'
27/01/2025 09:33: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
( '95438' , '1116' , 'BIBBIA DEI BAMBINI' , '1' , '-1' , '4' ,
'12.90' , '12.9' , '0' , '5' , '12.26' )
27/01/2025 09:33: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
( '95438' , '20948' , 'MIA PRIMA GRANDE BIBBIA' , '1' , '-1' , '4' ,
'9.00' , '9' , '0' , '5' , '8.55' )
27/01/2025 09:35:08 am >> SELECT document_num FROM ps_document
WHERE document_num = '262' AND id_document != '95438' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-27')
27/01/2025 09:35:08 am >> UPDATE ps_document SET
id_document_type = '11',
document_num = '262',
document_date = '2025-01-27',
document_letter = '',
id_customer = '0',
id_supplier = '',
id_address = '0',
address1 = '',
address2 = '',
note = '',
price_shipping = '0.00',
id_tax_shipping_rules = '4',
colli = '0',
peso = '0',
porto_e_imballo = '0',
mezzo_consegna = '',
id_payment = '0',
id_causal = '0',
price_tax_included = '20.81',
price_tax_excluded = '20.81',
date_upd = NOW()
WHERE id_document = '95438'
27/01/2025 09:35:08 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95438'
27/01/2025 09:35:08 am >> DELETE FROM ps_document_detail WHERE id_document = '95438'
27/01/2025 09:35:08 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95438' , '1116' , 'BIBBIA DEI BAMBINI' , '1' , '-1' , '4' ,
'12.9000' , '12.9' , '0' , '5' , '12.26' )
27/01/2025 09:35:08 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95438' , '20948' , 'MIA PRIMA GRANDE BIBBIA' , '1' , '-1' , '4' ,
'9.0000' , '9' , '0' , '5' , '8.55' )
27/01/2025 09:38:24 am >> SELECT ean13 FROM ps_product WHERE ean13 = '5902689316616' AND id_product != '23383' AND ean13 != ''
27/01/2025 09:38:24 am >> UPDATE ps_product SET
id_supplier = '',
reference = '',
ean13 = '5902689316616',
date_upd = NOW()
WHERE id_product = '23383'
27/01/2025 09:38:24 am >> UPDATE ps_product_lang SET
name = 'bracciale decina - bd020',
description = ''
WHERE id_product = '23383'
27/01/2025 09:38:24 am >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '1.639344262295082'
WHERE id_product = '23383'
27/01/2025 09:38:24 am >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '1.639344262295082',
id_tax_rules_group = '1',
id_category_default = '443',
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 = '23383'
27/01/2025 09:38:24 am >> DELETE FROM ps_specific_price WHERE id_product = '23383'
27/01/2025 09:38:28 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 = '23383'
27/01/2025 09:38:28 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23384' , '1' , '' , 'nuovo-prodotto' )
27/01/2025 09:38:28 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 '23384' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23383'
27/01/2025 09:38:28 am >> INSERT INTO `ps_stock_available` (
id_product , id_product_attribute , id_shop , id_shop_group , quantity
) SELECT '23384' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23383'
27/01/2025 09:38:47 am >> SELECT ean13 FROM ps_product WHERE ean13 = '5902689316616' AND id_product != '23383' AND ean13 != ''
27/01/2025 09:38:47 am >> UPDATE ps_product SET
id_supplier = '',
reference = '',
ean13 = '5902689316616',
date_upd = NOW()
WHERE id_product = '23383'
27/01/2025 09:38:47 am >> UPDATE ps_product_lang SET
name = 'BRACCIALE DECINA - BD020',
description = ''
WHERE id_product = '23383'
27/01/2025 09:38:47 am >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '1.6393'
WHERE id_product = '23383'
27/01/2025 09:38:47 am >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '1.6393',
id_tax_rules_group = '1',
id_category_default = '443',
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 = '23383'
27/01/2025 09:38:47 am >> DELETE FROM ps_specific_price WHERE id_product = '23383'
27/01/2025 09:40:08 am >> SELECT ean13 FROM ps_product WHERE ean13 = '5902689316616' AND id_product != '23383' AND ean13 != ''
27/01/2025 09:40:08 am >> UPDATE ps_product SET
id_supplier = '',
reference = '',
ean13 = '5902689316616',
date_upd = NOW()
WHERE id_product = '23383'
27/01/2025 09:40:08 am >> UPDATE ps_product_lang SET
name = 'BRACCIALE DECINA - BD020',
description = ''
WHERE id_product = '23383'
27/01/2025 09:40:08 am >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '1.8032786885245904'
WHERE id_product = '23383'
27/01/2025 09:40:08 am >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '1.8032786885245904',
id_tax_rules_group = '1',
id_category_default = '443',
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 = '23383'
27/01/2025 09:40:08 am >> DELETE FROM ps_specific_price WHERE id_product = '23383'
27/01/2025 09:40:46 am >> SELECT ean13 FROM ps_product WHERE ean13 = '5902689316616' AND id_product != '23383' AND ean13 != ''
27/01/2025 09:40:46 am >> UPDATE ps_product SET
id_supplier = '',
reference = '',
ean13 = '5902689316616',
date_upd = NOW()
WHERE id_product = '23383'
27/01/2025 09:40:46 am >> UPDATE ps_product_lang SET
name = 'BRACCIALE DECINA - BD020',
description = ''
WHERE id_product = '23383'
27/01/2025 09:40:46 am >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '1.8032786885245904'
WHERE id_product = '23383'
27/01/2025 09:40:46 am >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '1.8032786885245904',
id_tax_rules_group = '1',
id_category_default = '443',
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 = '23383'
27/01/2025 09:40:46 am >> DELETE FROM ps_specific_price WHERE id_product = '23383'
27/01/2025 09:41:05 am >> SELECT ean13 FROM ps_product WHERE ean13 = '5902689324048' AND id_product != '18898' AND ean13 != ''
27/01/2025 09:41:05 am >> UPDATE ps_product SET
id_supplier = '123',
reference = '',
ean13 = '5902689324048',
date_upd = NOW()
WHERE id_product = '18898'
27/01/2025 09:41:05 am >> UPDATE ps_product_lang SET
name = 'BRACCIALE DECINA LEGNO - BC1745',
description = ''
WHERE id_product = '18898'
27/01/2025 09:41:05 am >> UPDATE ps_product SET
wholesale_price = '0.76',
on_sale = '0',
price = '1.8032786885245904'
WHERE id_product = '18898'
27/01/2025 09:41:05 am >> UPDATE ps_product_shop SET
wholesale_price = '0.76',
price = '1.8032786885245904',
id_tax_rules_group = '1',
id_category_default = '443',
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 = '18898'
27/01/2025 09:41:05 am >> DELETE FROM ps_specific_price WHERE id_product = '18898'
27/01/2025 09:41:28 am >> SELECT ean13 FROM ps_product WHERE ean13 = '5902689324048' AND id_product != '18898' AND ean13 != ''
27/01/2025 09:41:28 am >> UPDATE ps_product SET
id_supplier = '123',
reference = '',
ean13 = '5902689324048',
date_upd = NOW()
WHERE id_product = '18898'
27/01/2025 09:41:28 am >> UPDATE ps_product_lang SET
name = 'BRACCIALE DECINA LEGNO - BC1745',
description = ''
WHERE id_product = '18898'
27/01/2025 09:41:28 am >> UPDATE ps_product SET
wholesale_price = '0.76',
on_sale = '0',
price = '1.8032786885245904'
WHERE id_product = '18898'
27/01/2025 09:41:28 am >> UPDATE ps_product_shop SET
wholesale_price = '0.76',
price = '1.8032786885245904',
id_tax_rules_group = '1',
id_category_default = '443',
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 = '18898'
27/01/2025 09:41:28 am >> DELETE FROM ps_specific_price WHERE id_product = '18898'
27/01/2025 09:49:51 am >> SELECT ean13 FROM ps_product WHERE ean13 = '001713' AND id_product != '18218' AND ean13 != ''
27/01/2025 09:49:51 am >> UPDATE ps_product SET
id_supplier = '123',
reference = '',
ean13 = '001713',
date_upd = NOW()
WHERE id_product = '18218'
27/01/2025 09:49:51 am >> UPDATE ps_product_lang SET
name = 'DECINA LEGNO CHIARO - FR52',
description = ''
WHERE id_product = '18218'
27/01/2025 09:49:51 am >> UPDATE ps_product SET
wholesale_price = '0.20',
on_sale = '0',
price = '0.6557377049180328'
WHERE id_product = '18218'
27/01/2025 09:49:51 am >> UPDATE ps_product_shop SET
wholesale_price = '0.20',
price = '0.6557377049180328',
id_tax_rules_group = '1',
id_category_default = '443',
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 = '18218'
27/01/2025 09:49:51 am >> DELETE FROM ps_specific_price WHERE id_product = '18218'
27/01/2025 09:56:38 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002339' AND id_product != '23384' AND ean13 != ''
27/01/2025 09:56:38 am >> UPDATE ps_product SET
id_supplier = '',
reference = '',
ean13 = '002339',
date_upd = NOW()
WHERE id_product = '23384'
27/01/2025 09:56:38 am >> UPDATE ps_product_lang SET
name = 'DECINA LEGNO - FR07',
description = ''
WHERE id_product = '23384'
27/01/2025 09:56:38 am >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '0.5737704918032787'
WHERE id_product = '23384'
27/01/2025 09:56:38 am >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '0.5737704918032787',
id_tax_rules_group = '1',
id_category_default = '443',
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 = '23384'
27/01/2025 09:56:38 am >> DELETE FROM ps_specific_price WHERE id_product = '23384'
27/01/2025 09:57:36 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 = '23384'
27/01/2025 09:57:36 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23385' , '1' , '' , 'nuovo-prodotto' )
27/01/2025 09:57:36 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 '23385' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23384'
27/01/2025 09:57:36 am >> INSERT INTO `ps_stock_available` (
id_product , id_product_attribute , id_shop , id_shop_group , quantity
) SELECT '23385' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23384'
27/01/2025 09:58:11 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002340' AND id_product != '23385' AND ean13 != ''
27/01/2025 09:58:11 am >> UPDATE ps_product SET
id_supplier = '',
reference = '',
ean13 = '002340',
date_upd = NOW()
WHERE id_product = '23385'
27/01/2025 09:58:12 am >> UPDATE ps_product_lang SET
name = 'DECINA LEGNO - FR18',
description = ''
WHERE id_product = '23385'
27/01/2025 09:58:12 am >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '0.4918032786885246'
WHERE id_product = '23385'
27/01/2025 09:58:12 am >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '0.4918032786885246',
id_tax_rules_group = '1',
id_category_default = '443',
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 = '23385'
27/01/2025 09:58:12 am >> DELETE FROM ps_specific_price WHERE id_product = '23385'
27/01/2025 10:00:29 am >> SELECT ean13 FROM ps_product WHERE ean13 = '001714' AND id_product != '18219' AND ean13 != ''
27/01/2025 10:00:29 am >> UPDATE ps_product SET
id_supplier = '123',
reference = '',
ean13 = '001714',
date_upd = NOW()
WHERE id_product = '18219'
27/01/2025 10:00:29 am >> UPDATE ps_product_lang SET
name = 'CROCE EMATITE CON LACCIO - N169-C',
description = ''
WHERE id_product = '18219'
27/01/2025 10:00:29 am >> UPDATE ps_product SET
wholesale_price = '0.31',
on_sale = '0',
price = '1.639344262295082'
WHERE id_product = '18219'
27/01/2025 10:00:29 am >> UPDATE ps_product_shop SET
wholesale_price = '0.31',
price = '1.639344262295082',
id_tax_rules_group = '1',
id_category_default = '443',
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 = '18219'
27/01/2025 10:00:29 am >> DELETE FROM ps_specific_price WHERE id_product = '18219'
27/01/2025 10:02:02 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 (
'31' ,
'75/01/2025' ,
'2025-01-21' ,
'01' ,
'0' ,
'123' ,
'4669610' ,
'RYNEK WIELUNSKI, 27 42202 CZESTOCHOWA' ,
'' ,
'' ,
'39' ,
'0' ,
'0' ,
'0' ,
'0' ,
'' ,
'9' ,
'0' ,
'891.84' ,
'891.84' ,
NOW() ,
NOW() )
27/01/2025 10:02:02 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 = '95439'
27/01/2025 10:02:02 am >> DELETE FROM ps_document_detail WHERE id_document = '95439'
27/01/2025 10:02:02 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
( '95439' , '15085' , 'BRACCIALE DECINA COLORATA - BC506' , '804' , '804' , '0' ,
'0.65' , '0.65' , '' , '0' , '522.6000' )
27/01/2025 10:02:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '15085' AND id_supplier = '123'
27/01/2025 10:02:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15085' , '123' , '1' )
27/01/2025 10:02:02 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
( '95439' , '18895' , 'BRACCIALE DECINA COLORATA - B1757N' , '48' , '48' , '0' ,
'0.65' , '0.65' , '' , '0' , '31.2000' )
27/01/2025 10:02:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '18895' AND id_supplier = '123'
27/01/2025 10:02:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18895' , '123' , '1' )
27/01/2025 10:02:02 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
( '95439' , '21099' , 'BRACCIALE DECINA - BD008' , '48' , '48' , '0' ,
'0.61' , '0.61' , '' , '0' , '29.2800' )
27/01/2025 10:02:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '21099' AND id_supplier = '123'
27/01/2025 10:02:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21099' , '123' , '1' )
27/01/2025 10:02:02 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
( '95439' , '23383' , 'BRACCIALE DECINA - BD020' , '24' , '24' , '0' ,
'0.7' , '0.7' , '' , '0' , '16.8000' )
27/01/2025 10:02:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '23383' AND id_supplier = '123'
27/01/2025 10:02:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23383' , '123' , '1' )
27/01/2025 10:02:02 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
( '95439' , '18898' , 'BRACCIALE DECINA LEGNO - BC1745' , '48' , '48' , '0' ,
'0.76' , '0.76' , '' , '0' , '36.4800' )
27/01/2025 10:02:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '18898' AND id_supplier = '123'
27/01/2025 10:02:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18898' , '123' , '1' )
27/01/2025 10:02:02 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
( '95439' , '18218' , 'DECINA LEGNO CHIARO - FR52' , '250' , '250' , '0' ,
'0.3' , '0.3' , '' , '0' , '75.0000' )
27/01/2025 10:02:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '18218' AND id_supplier = '123'
27/01/2025 10:02:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18218' , '123' , '1' )
27/01/2025 10:02:02 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
( '95439' , '23384' , 'DECINA LEGNO - FR07' , '300' , '300' , '0' ,
'0.24' , '0.24' , '' , '0' , '72.0000' )
27/01/2025 10:02:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '23384' AND id_supplier = '123'
27/01/2025 10:02:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23384' , '123' , '1' )
27/01/2025 10:02:02 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
( '95439' , '23385' , 'DECINA LEGNO - FR18' , '150' , '150' , '0' ,
'0.2' , '0.2' , '' , '0' , '30.0000' )
27/01/2025 10:02:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '23385' AND id_supplier = '123'
27/01/2025 10:02:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23385' , '123' , '1' )
27/01/2025 10:02:02 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
( '95439' , '20069' , 'SACCHETTO' , '300' , '300' , '0' ,
'0.09' , '0.09' , '' , '0' , '27.0000' )
27/01/2025 10:02:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '20069' AND id_supplier = '123'
27/01/2025 10:02:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20069' , '123' , '1' )
27/01/2025 10:02:03 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
( '95439' , '18219' , 'CROCE EMATITE CON LACCIO - N169-C' , '24' , '24' , '0' ,
'0.52' , '0.52' , '' , '0' , '12.4800' )
27/01/2025 10:02:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '18219' AND id_supplier = '123'
27/01/2025 10:02:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18219' , '123' , '1' )
27/01/2025 10:02:53 am >> SELECT document_num FROM ps_document
WHERE document_num = '263' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-27')
27/01/2025 10:02:53 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' ,
'263' ,
'2025-01-27' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'26.00' ,
'21.31' ,
NOW() ,
NOW() )
27/01/2025 10:02:53 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 = '95440'
27/01/2025 10:02:53 am >> DELETE FROM ps_document_detail WHERE id_document = '95440'
27/01/2025 10:02:53 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
( '95440' , '9716' , 'SCATOLA PORTA OSTIE INOX IHS - CM 9,5 X 12,5 - 682' , '1' , '-1' , '1' ,
'26' , '21.311475409836' , '22' , '0' , '26.00' )
27/01/2025 10:05:29 am >> SELECT document_num FROM ps_document
WHERE document_num = '264' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-27')
27/01/2025 10:05:30 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' ,
'264' ,
'2025-01-27' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'400.00' ,
'327.87' ,
NOW() ,
NOW() )
27/01/2025 10:05:30 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95441'
27/01/2025 10:05:30 am >> DELETE FROM ps_document_detail WHERE id_document = '95441'
27/01/2025 10:05:30 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95441' , '20263' , 'PIZZO IHS UVA - PIZ0M420' , '4' , '-4' , '1' ,
'100' , '81.967213114754' , '22' , '0' , '400.00' )
27/01/2025 10:06:29 am >> SELECT document_num FROM ps_document
WHERE document_num = '10/A' AND id_document != '94115' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-01-02')
27/01/2025 10:06:29 am >> UPDATE ps_document SET
id_document_type = '24',
document_num = '10/A',
document_date = '2025-01-02',
document_letter = 'A',
id_customer = '1213',
id_supplier = '',
id_address = '4679403',
address1 = 'VIA CONVENTO 83025 MONTORO',
address2 = '',
note = 'DDT 119/A DEL 07/11/2024',
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 = '348.00',
price_tax_excluded = '285.25',
date_upd = NOW()
WHERE id_document = '94115'
27/01/2025 10:06:29 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94115'
27/01/2025 10:06:29 am >> DELETE FROM ps_document_detail WHERE id_document = '94115'
27/01/2025 10:06:29 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94115' , '22739' , 'CASULA RIGHE - 65/002024CRO' , '1' , '-1' , '1' ,
'348.0000' , '285.24590163934' , '22' , '0' , '348.00' )
27/01/2025 10:26:23 am >> SELECT document_num FROM ps_document
WHERE document_num = '241' AND id_document != '95412' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-24')
27/01/2025 10:26:23 am >> UPDATE ps_document SET
id_document_type = '11',
document_num = '241',
document_date = '2025-01-24',
document_letter = '',
id_customer = '0',
id_supplier = '',
id_address = '0',
address1 = '',
address2 = '',
note = '',
price_shipping = '0.00',
id_tax_shipping_rules = '4',
colli = '0',
peso = '0',
porto_e_imballo = '0',
mezzo_consegna = '',
id_payment = '0',
id_causal = '0',
price_tax_included = '1.50',
price_tax_excluded = '1.23',
date_upd = NOW()
WHERE id_document = '95412'
27/01/2025 10:26:23 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 = '95412'
27/01/2025 10:26:23 am >> DELETE FROM ps_document_detail WHERE id_document = '95412'
27/01/2025 10:26:23 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
( '95412' , '18219' , 'CROCE EMATITE CON LACCIO - N169-C' , '1' , '-1' , '1' ,
'1.5' , '1.2295081967213' , '22' , '0' , '1.50' )
27/01/2025 10:26:43 am >> SELECT document_num FROM ps_document
WHERE document_num = '205' AND id_document != '95364' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-21')
27/01/2025 10:26:43 am >> UPDATE ps_document SET
id_document_type = '11',
document_num = '205',
document_date = '2025-01-21',
document_letter = '',
id_customer = '0',
id_supplier = '',
id_address = '0',
address1 = '',
address2 = '',
note = '',
price_shipping = '0.00',
id_tax_shipping_rules = '4',
colli = '0',
peso = '0',
porto_e_imballo = '0',
mezzo_consegna = '',
id_payment = '0',
id_causal = '0',
price_tax_included = '1.56',
price_tax_excluded = '1.28',
date_upd = NOW()
WHERE id_document = '95364'
27/01/2025 10:26:43 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95364'
27/01/2025 10:26:43 am >> DELETE FROM ps_document_detail WHERE id_document = '95364'
27/01/2025 10:26:43 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95364' , '23383' , 'BRACCIALE DECINA - BD020' , '1' , '-1' , '1' ,
'1.56' , '1.2786885245902' , '22' , '0' , '1.56' )
27/01/2025 10:48:11 am >> SELECT document_num FROM ps_document
WHERE document_num = '265' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-27')
27/01/2025 10:48:11 am >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'265' ,
'2025-01-27' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'2.00' ,
'2.00' ,
NOW() ,
NOW() )
27/01/2025 10:48:11 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95442'
27/01/2025 10:48:11 am >> DELETE FROM ps_document_detail WHERE id_document = '95442'
27/01/2025 10:48:11 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95442' , '8245' , 'PREGATE IL SANTO ROSARIO OGNI GIORNO - 8234' , '1' , '-1' , '4' ,
'2.00' , '2' , '0' , '0' , '2.00' )
27/01/2025 11:10:55 am >> SELECT document_num FROM ps_document
WHERE document_num = '266' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-27')
27/01/2025 11:10:55 am >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'266' ,
'2025-01-27' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'157.90' ,
'129.43' ,
NOW() ,
NOW() )
27/01/2025 11:10:55 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95443'
27/01/2025 11:10:55 am >> DELETE FROM ps_document_detail WHERE id_document = '95443'
27/01/2025 11:10:55 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95443' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '2' , '-2' , '1' ,
'70.00' , '57.377049180328' , '22' , '0' , '140.00' )
27/01/2025 11:10:55 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95443' , '19147' , 'CANDELINE NON GOCCIOLANTI GRECHE' , '1' , '-1' , '1' ,
'17.90' , '14.672131147541' , '22' , '0' , '17.90' )
27/01/2025 11:12:11 am >> SELECT document_num FROM ps_document
WHERE document_num = '28/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-01-27')
27/01/2025 11:12:11 am >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'24' ,
'28/A' ,
'2025-01-27' ,
'A' ,
'3351' ,
'0' ,
'4671704' ,
'VIA SERRACAPILLI 84025 EBOLI ' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'489.00' ,
'489.00' ,
NOW() ,
NOW() )
27/01/2025 11:12:11 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95444'
27/01/2025 11:12:11 am >> DELETE FROM ps_document_detail WHERE id_document = '95444'
27/01/2025 11:12: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
( '95444' , '18905' , 'PORTA TURIBOLO CM 147' , '1' , '-1' , '0' ,
'350' , '350' , '' , '0' , '350.00' )
27/01/2025 11:12: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
( '95444' , '' , 'CERO PASQUALE GIUBILEO' , '1' , '-1' , '0' ,
'139' , '139' , '' , '0' , '139.00' )
27/01/2025 11:19:56 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() )
27/01/2025 11:19:56 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23386' , '1' , '' , 'nuovo-prodotto' )
27/01/2025 11:19:56 am >> INSERT INTO ps_product_shop (
id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd`
) VALUES (
'23386' , '1' , '1' , '2' , NOW() , NOW()
)
27/01/2025 11:19:56 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '23386' , '0' , '1' , '0' , '0' )
27/01/2025 11:21:06 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788874025398' AND id_product != '23386' AND ean13 != ''
27/01/2025 11:21:06 am >> UPDATE ps_product SET
id_supplier = '',
reference = '7/3',
ean13 = '9788874025398',
date_upd = NOW()
WHERE id_product = '23386'
27/01/2025 11:21:06 am >> UPDATE ps_product_lang SET
name = 'SEMPRE IN VIA - A. BERGAMO',
description = ''
WHERE id_product = '23386'
27/01/2025 11:21:06 am >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '8'
WHERE id_product = '23386'
27/01/2025 11:21:06 am >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '8',
id_tax_rules_group = '4',
id_category_default = '45',
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 = '23386'
27/01/2025 11:21:06 am >> DELETE FROM ps_specific_price WHERE id_product = '23386'
27/01/2025 11:21:07 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 = '23386'
27/01/2025 11:21:07 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23387' , '1' , '' , 'nuovo-prodotto' )
27/01/2025 11:21:07 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 '23387' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23386'
27/01/2025 11:21:07 am >> INSERT INTO `ps_stock_available` (
id_product , id_product_attribute , id_shop , id_shop_group , quantity
) SELECT '23387' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23386'
27/01/2025 11:22:33 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788845913112' AND id_product != '23387' AND ean13 != ''
27/01/2025 11:22:33 am >> UPDATE ps_product SET
id_supplier = '',
reference = '',
ean13 = '9788845913112',
date_upd = NOW()
WHERE id_product = '23387'
27/01/2025 11:22:33 am >> UPDATE ps_product_lang SET
name = 'CRISTIANESIMO COSI\' COM\'E\' - LEWIS',
description = ''
WHERE id_product = '23387'
27/01/2025 11:22:33 am >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '15'
WHERE id_product = '23387'
27/01/2025 11:22:33 am >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '15',
id_tax_rules_group = '4',
id_category_default = '463',
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 = '23387'
27/01/2025 11:22:33 am >> DELETE FROM ps_specific_price WHERE id_product = '23387'
27/01/2025 11:22:34 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 = '23387'
27/01/2025 11:22:34 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23388' , '1' , '' , 'nuovo-prodotto' )
27/01/2025 11:22:34 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 '23388' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23387'
27/01/2025 11:22:34 am >> INSERT INTO `ps_stock_available` (
id_product , id_product_attribute , id_shop , id_shop_group , quantity
) SELECT '23388' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23387'
27/01/2025 11:23:45 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788810204726' AND id_product != '17865' AND ean13 != ''
27/01/2025 11:23:45 am >> UPDATE ps_product SET
id_supplier = '109',
reference = '7/4',
ean13 = '9788810204726',
date_upd = NOW()
WHERE id_product = '17865'
27/01/2025 11:23:45 am >> UPDATE ps_product_lang SET
name = 'MESSALE QUOTIDIANO - N. E.',
description = ''
WHERE id_product = '17865'
27/01/2025 11:23:45 am >> UPDATE ps_product SET
wholesale_price = '26.97',
on_sale = '0',
price = '41'
WHERE id_product = '17865'
27/01/2025 11:23:45 am >> UPDATE ps_product_shop SET
wholesale_price = '26.97',
price = '41',
id_tax_rules_group = '4',
id_category_default = '9',
id_argoment_default = '89',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '17865'
27/01/2025 11:23:45 am >> DELETE FROM ps_specific_price WHERE id_product = '17865'
27/01/2025 11:24:37 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788810521113' AND id_product != '23388' AND ean13 != ''
27/01/2025 11:24:37 am >> UPDATE ps_product SET
id_supplier = '',
reference = '',
ean13 = '9788810521113',
date_upd = NOW()
WHERE id_product = '23388'
27/01/2025 11:24:37 am >> UPDATE ps_product_lang SET
name = 'CRISTO GESU\' E\' VIVO - TARDIF/FLORES',
description = ''
WHERE id_product = '23388'
27/01/2025 11:24:37 am >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '16.5'
WHERE id_product = '23388'
27/01/2025 11:24:38 am >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '16.5',
id_tax_rules_group = '4',
id_category_default = '9',
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 = '23388'
27/01/2025 11:24:38 am >> DELETE FROM ps_specific_price WHERE id_product = '23388'
27/01/2025 11:24:38 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 = '23388'
27/01/2025 11:24:38 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23389' , '1' , '' , 'nuovo-prodotto' )
27/01/2025 11:24:39 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 '23389' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23388'
27/01/2025 11:24:39 am >> INSERT INTO `ps_stock_available` (
id_product , id_product_attribute , id_shop , id_shop_group , quantity
) SELECT '23389' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23388'
27/01/2025 11:25:46 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788888287027' AND id_product != '23389' AND ean13 != ''
27/01/2025 11:25:46 am >> UPDATE ps_product SET
id_supplier = '',
reference = '',
ean13 = '9788888287027',
date_upd = NOW()
WHERE id_product = '23389'
27/01/2025 11:25:47 am >> UPDATE ps_product_lang SET
name = 'MISTICA DELLA RIPARAZIONE - BARSOTTI',
description = ''
WHERE id_product = '23389'
27/01/2025 11:25:47 am >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '8'
WHERE id_product = '23389'
27/01/2025 11:25:47 am >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '8',
id_tax_rules_group = '4',
id_category_default = '160',
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 = '23389'
27/01/2025 11:25:47 am >> DELETE FROM ps_specific_price WHERE id_product = '23389'
27/01/2025 11:25:48 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 = '23389'
27/01/2025 11:25:48 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23390' , '1' , '' , 'nuovo-prodotto' )
27/01/2025 11:25:48 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 '23390' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23389'
27/01/2025 11:25:48 am >> INSERT INTO `ps_stock_available` (
id_product , id_product_attribute , id_shop , id_shop_group , quantity
) SELECT '23390' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23389'
27/01/2025 11:26: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 (
'33' ,
'00022706' ,
'2025-01-24' ,
'' ,
'0' ,
'109' ,
'4669106' ,
'VIA G. VERDI, 8 20090 ASSAGO' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'212.50' ,
'212.50' ,
NOW() ,
NOW() )
27/01/2025 11:26: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 = '95445'
27/01/2025 11:26:18 am >> DELETE FROM ps_document_detail WHERE id_document = '95445'
27/01/2025 11:26: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
( '95445' , '23386' , 'SEMPRE IN VIA - A. BERGAMO' , '1' , '1' , '4' ,
'8.00' , '8' , '0' , '' , '8.0000' )
27/01/2025 11:26:18 am >> DELETE FROM ps_product_supplier WHERE id_product = '23386' AND id_supplier = '109'
27/01/2025 11:26:18 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23386' , '109' , '1' )
27/01/2025 11:26: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
( '95445' , '23387' , 'CRISTIANESIMO COSI COME - LEWIS' , '1' , '1' , '4' ,
'15.00' , '15' , '0' , '' , '15.0000' )
27/01/2025 11:26:18 am >> DELETE FROM ps_product_supplier WHERE id_product = '23387' AND id_supplier = '109'
27/01/2025 11:26:18 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23387' , '109' , '1' )
27/01/2025 11:26:19 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
( '95445' , '23257' , 'CON UN PIEDE IN PARADISO' , '6' , '6' , '4' ,
'12.00' , '12' , '0' , '' , '72.0000' )
27/01/2025 11:26:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '23257' AND id_supplier = '109'
27/01/2025 11:26:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23257' , '109' , '1' )
27/01/2025 11:26:19 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
( '95445' , '17864' , 'MESSALE QUOTIDIANO GRANDE - N. E. ' , '1' , '1' , '4' ,
'52.00' , '52' , '0' , '' , '52.0000' )
27/01/2025 11:26:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '17864' AND id_supplier = '109'
27/01/2025 11:26:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17864' , '109' , '1' )
27/01/2025 11:26:19 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
( '95445' , '17865' , 'MESSALE QUOTIDIANO - N. E.' , '1' , '1' , '4' ,
'41.00' , '41' , '0' , '' , '41.0000' )
27/01/2025 11:26:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '17865' AND id_supplier = '109'
27/01/2025 11:26:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17865' , '109' , '1' )
27/01/2025 11:26:19 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
( '95445' , '23388' , 'CRISTO GESU E VIVO - TARDIF/FLORES' , '1' , '1' , '4' ,
'16.50' , '16.5' , '0' , '' , '16.5000' )
27/01/2025 11:26:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '23388' AND id_supplier = '109'
27/01/2025 11:26:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23388' , '109' , '1' )
27/01/2025 11:26:19 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
( '95445' , '23389' , 'MISTICA DELLA RIPARAZIONE - BARSOTTI' , '1' , '1' , '4' ,
'8.00' , '8' , '0' , '0' , '8.00' )
27/01/2025 11:26:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '23389' AND id_supplier = '109'
27/01/2025 11:26:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23389' , '109' , '1' )
27/01/2025 11:30:55 am >> SELECT document_num FROM ps_document
WHERE document_num = '188' AND id_document != '95343' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-18')
27/01/2025 11:30:55 am >> UPDATE ps_document SET
id_document_type = '11',
document_num = '188',
document_date = '2025-01-18',
document_letter = '',
id_customer = '0',
id_supplier = '',
id_address = '0',
address1 = '',
address2 = '',
note = '',
price_shipping = '0.00',
id_tax_shipping_rules = '4',
colli = '0',
peso = '0',
porto_e_imballo = '0',
mezzo_consegna = '',
id_payment = '0',
id_causal = '0',
price_tax_included = '55.00',
price_tax_excluded = '53.51',
date_upd = NOW()
WHERE id_document = '95343'
27/01/2025 11:30:55 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95343'
27/01/2025 11:30:55 am >> DELETE FROM ps_document_detail WHERE id_document = '95343'
27/01/2025 11:30:55 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95343' , '21614' , 'RITO DEL BATTESIMO DEI BAMBINI N.E.' , '1' , '-1' , '4' ,
'20.0000' , '20' , '0' , '5' , '19.00' )
27/01/2025 11:30: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
( '95343' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' ,
'2.0000' , '1.9230769230769' , '4' , '0' , '4.00' )
27/01/2025 11:30: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
( '95343' , '22199' , 'VINO LIQUOROSO ROSSO ' , '1' , '-1' , '1' ,
'7.3900' , '6.0573770491803' , '22' , '0' , '7.39' )
27/01/2025 11:30: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
( '95343' , '23239' , 'TU SEI AMATO - P. CURTAZ' , '1' , '-1' , '4' ,
'18.9000' , '18.9' , '0' , '5' , '17.96' )
27/01/2025 11:30: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
( '95343' , '23353' , 'VANGELO A CARETTERI GRANDI' , '1' , '-1' , '4' ,
'7.00' , '7' , '0' , '5' , '6.65' )
27/01/2025 11:38:37 am >> SELECT document_num FROM ps_document
WHERE document_num = '3/L' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-01-27')
27/01/2025 11:38:37 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' ,
'3/L' ,
'2025-01-27' ,
'L' ,
'949' ,
'0' ,
'4679327' ,
'VIA P. PALMIERI 39 10138 TORINO' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'3' ,
'0' ,
'112.80' ,
'92.46' ,
NOW() ,
NOW() )
27/01/2025 11:38:37 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 = '95446'
27/01/2025 11:38:37 am >> DELETE FROM ps_document_detail WHERE id_document = '95446'
27/01/2025 11:38:37 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
( '95446' , '1914' , 'CERA DELLA LITURGIA' , '24' , '-24' , '1' ,
'4.7' , '3.8524590163934' , '22' , '0' , '112.80' )
27/01/2025 12:03:47 pm >> SELECT document_num FROM ps_document
WHERE document_num = '267' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-27')
27/01/2025 12:03:47 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' ,
'267' ,
'2025-01-27' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'6.00' ,
'4.92' ,
NOW() ,
NOW() )
27/01/2025 12:03:47 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 = '95447'
27/01/2025 12:03:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '95447'
27/01/2025 12:03:47 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95447' , '14926' , 'VESTINA BATTESIMALE' , '1' , '-1' , '1' ,
'6.00' , '4.9180327868852' , '22' , '0' , '6.00' )
27/01/2025 12:26:44 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8002358005296' AND id_product != '17160' AND ean13 != ''
27/01/2025 12:26:44 pm >> UPDATE ps_product SET
id_supplier = '31',
reference = '',
ean13 = '8002358005296',
date_upd = NOW()
WHERE id_product = '17160'
27/01/2025 12:26:44 pm >> UPDATE ps_product_lang SET
name = 'CARBONCINI ROSSI - CARRO',
description = ''
WHERE id_product = '17160'
27/01/2025 12:26:44 pm >> UPDATE ps_product SET
wholesale_price = '4.32',
on_sale = '0',
price = '9.01639344262295'
WHERE id_product = '17160'
27/01/2025 12:26:44 pm >> UPDATE ps_product_shop SET
wholesale_price = '4.32',
price = '9.01639344262295',
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 = '17160'
27/01/2025 12:26:44 pm >> DELETE FROM ps_specific_price WHERE id_product = '17160'
27/01/2025 12:33:42 pm >> SELECT document_num FROM ps_document
WHERE document_num = '268' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-27')
27/01/2025 12:33: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' ,
'268' ,
'2025-01-27' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'34.76' ,
'29.35' ,
NOW() ,
NOW() )
27/01/2025 12:33: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 = '95448'
27/01/2025 12:33:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '95448'
27/01/2025 12:33: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
( '95448' , '1220' , 'BICCHIERI FLAMBEAUX - PZ. 50' , '2' , '-2' , '1' ,
'15.00' , '12.295081967213' , '22' , '0' , '30.00' )
27/01/2025 12:33: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
( '95448' , '20722' , 'SEMINATORI DI GIOIA' , '1' , '-1' , '4' ,
'2.50' , '2.5' , '0' , '5' , '2.38' )
27/01/2025 12:33: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
( '95448' , '23380' , 'DAL TUO CUORE TRAFITTO E GLORIOSO LA NOSTRA GIOIA E LA NOSTRA SPERANZA' , '1' , '-1' , '4' ,
'2.50' , '2.5' , '0' , '5' , '2.38' )
27/01/2025 12:39:30 pm >> SELECT document_num FROM ps_document
WHERE document_num = '269' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-27')
27/01/2025 12:39:30 pm >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'269' ,
'2025-01-27' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'2.00' ,
'2.00' ,
NOW() ,
NOW() )
27/01/2025 12:39:30 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95449'
27/01/2025 12:39:30 pm >> DELETE FROM ps_document_detail WHERE id_document = '95449'
27/01/2025 12:39:30 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95449' , '19157' , 'COMUNIONE AGLI INFERMI - N.E.' , '1' , '-1' , '4' ,
'2.00' , '2' , '0' , '0' , '2.00' )
27/01/2025 12:54:29 pm >> SELECT document_num FROM ps_document
WHERE document_num = '270' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-27')
27/01/2025 12:54:29 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' ,
'270' ,
'2025-01-27' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'36.80' ,
'30.31' ,
NOW() ,
NOW() )
27/01/2025 12:54:29 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 = '95450'
27/01/2025 12:54:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '95450'
27/01/2025 12:54:29 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95450' , '22105' , 'CANDELINE NON GOCCIOLANTI IN BUSTA - CHA25' , '2' , '-2' , '1' ,
'18.00' , '14.754098360656' , '22' , '0' , '36.00' )
27/01/2025 12:54:29 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95450' , '22698' , 'CALENDARIO LITURGICO 2025' , '1' , '-1' , '4' ,
'0.80' , '0.8' , '0' , '0' , '0.80' )
27/01/2025 02:25:23 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791280736468' AND id_product != '23347' AND ean13 != ''
27/01/2025 02:25:23 pm >> UPDATE ps_product SET
id_supplier = '125',
reference = '13/3',
ean13 = '9791280736468',
date_upd = NOW()
WHERE id_product = '23347'
27/01/2025 02:25:23 pm >> UPDATE ps_product_lang SET
name = 'PREGHIERA DEL ROSARIO',
description = 'il Rosario, da sempre considerato una preghiera popolare dedicata alla Vergine, è molto di più: è la celebrazione di Cristo e dei testi biblici, una preghiera di lode e di intercessione.
E\' una preghiera molto antica. essa deriva dal bisogno di esprimere la propria devozione alla Madonna e di interiorizzare ciò che viene espresso attraverso le parole.
'
WHERE id_product = '23347'
27/01/2025 02:25:23 pm >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '2.5000'
WHERE id_product = '23347'
27/01/2025 02:25:24 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '2.5000',
id_tax_rules_group = '4',
id_category_default = '395',
id_argoment_default = '28',
id_internal_category = '4',
on_sale = '0',
on_showcase = '1',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '23347'
27/01/2025 02:25:24 pm >> DELETE FROM ps_specific_price WHERE id_product = '23347'
27/01/2025 02:25:24 pm >> INSERT INTO ps_specific_price
( id_specific_price_rule , id_cart , id_product , id_shop , id_shop_group , id_currency , id_country , id_group , id_customer , id_product_attribute , price , from_quantity , reduction , reduction_tax , reduction_type , `from` , `to`)
VALUES
( '0' , '0' , '23347' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' )
27/01/2025 02:25:52 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791280736475' AND id_product != '22809' AND ean13 != ''
27/01/2025 02:25:52 pm >> UPDATE ps_product SET
id_supplier = '159',
reference = '13/5',
ean13 = '9791280736475',
date_upd = NOW()
WHERE id_product = '22809'
27/01/2025 02:25:52 pm >> UPDATE ps_product_lang SET
name = 'O LUCE BEATISSIMA',
description = ''
WHERE id_product = '22809'
27/01/2025 02:25:52 pm >> UPDATE ps_product SET
wholesale_price = '0.27',
on_sale = '0',
price = '2.5000'
WHERE id_product = '22809'
27/01/2025 02:25:52 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.27',
price = '2.5000',
id_tax_rules_group = '4',
id_category_default = '395',
id_argoment_default = '28',
id_internal_category = '4',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '22809'
27/01/2025 02:25:52 pm >> DELETE FROM ps_specific_price WHERE id_product = '22809'
27/01/2025 02:25:52 pm >> INSERT INTO ps_specific_price
( id_specific_price_rule , id_cart , id_product , id_shop , id_shop_group , id_currency , id_country , id_group , id_customer , id_product_attribute , price , from_quantity , reduction , reduction_tax , reduction_type , `from` , `to`)
VALUES
( '0' , '0' , '22809' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' )
27/01/2025 02:26:22 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791280736468' AND id_product != '23347' AND ean13 != ''
27/01/2025 02:26:22 pm >> UPDATE ps_product SET
id_supplier = '125',
reference = '13/4',
ean13 = '9791280736468',
date_upd = NOW()
WHERE id_product = '23347'
27/01/2025 02:26:22 pm >> UPDATE ps_product_lang SET
name = 'PREGHIERA DEL ROSARIO',
description = 'il Rosario, da sempre considerato una preghiera popolare dedicata alla Vergine, è molto di più: è la celebrazione di Cristo e dei testi biblici, una preghiera di lode e di intercessione.
E\' una preghiera molto antica. essa deriva dal bisogno di esprimere la propria devozione alla Madonna e di interiorizzare ciò che viene espresso attraverso le parole.
'
WHERE id_product = '23347'
27/01/2025 02:26:22 pm >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '2.5000'
WHERE id_product = '23347'
27/01/2025 02:26:22 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '2.5000',
id_tax_rules_group = '4',
id_category_default = '395',
id_argoment_default = '28',
id_internal_category = '4',
on_sale = '0',
on_showcase = '1',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '23347'
27/01/2025 02:26:22 pm >> DELETE FROM ps_specific_price WHERE id_product = '23347'
27/01/2025 02:26:22 pm >> INSERT INTO ps_specific_price
( id_specific_price_rule , id_cart , id_product , id_shop , id_shop_group , id_currency , id_country , id_group , id_customer , id_product_attribute , price , from_quantity , reduction , reduction_tax , reduction_type , `from` , `to`)
VALUES
( '0' , '0' , '23347' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' )
27/01/2025 02:27:53 pm >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'33' ,
'000022' ,
'2025-01-22' ,
'' ,
'0' ,
'145' ,
'4670978' ,
'VIA TORQUATO TASSO 10 24020 GORLE' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'0.00' ,
'0.00' ,
NOW() ,
NOW() )
27/01/2025 02:27:53 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95451'
27/01/2025 02:27:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '95451'
27/01/2025 02:27:53 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95451' , '23380' , 'DAL TUO CUORE TRAFITTO E GLORIOSO LA NOSTRA GIOIA E LA NOSTRA SPERANZA' , '150' , '150' , '4' ,
'0' , '0' , '0' , '0' , '0.0000' )
27/01/2025 02:27:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23380' AND id_supplier = '145'
27/01/2025 02:27:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23380' , '145' , '1' )
27/01/2025 02:28:52 pm >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'33' ,
'000023' ,
'2025-01-22' ,
'' ,
'0' ,
'145' ,
'4670978' ,
'VIA TORQUATO TASSO 10 24020 GORLE' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'0.00' ,
'0.00' ,
NOW() ,
NOW() )
27/01/2025 02:28:52 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95452'
27/01/2025 02:28:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '95452'
27/01/2025 02:28:52 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95452' , '23380' , 'DAL TUO CUORE TRAFITTO E GLORIOSO LA NOSTRA GIOIA E LA NOSTRA SPERANZA' , '350' , '350' , '4' ,
'0' , '0' , '0' , '0' , '0.0000' )
27/01/2025 02:28:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23380' AND id_supplier = '145'
27/01/2025 02:28:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23380' , '145' , '1' )
27/01/2025 02:32:10 pm >> INSERT INTO ps_customer
( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` )
VALUES
( '1' , '' , '' , '' , 'RObEpJWDow6Lvfxs' , NOW() , NOW() )
27/01/2025 02:32:10 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4158' , '1' )
27/01/2025 02:32:10 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4158' , '2' )
27/01/2025 02:32:10 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4158' , '3' )
27/01/2025 02:33:44 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4158'
27/01/2025 02:33:44 pm >> INSERT INTO ps_address
( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd )
VALUES (
'4158' ,
'10' ,
'208' ,
'ISTITUTO MATER CARMELI' ,
'MIRANDA' ,
'MARCO' ,
'VIA ANTONIO BENNICELLI 71' ,
'' ,
'000151' ,
'ROMA' ,
'' ,
'065370456' ,
'' ,
'' ,
'' ,
NOW() ,
NOW() )
27/01/2025 02:33:44 pm >> UPDATE ps_customer SET
email = 'amministrazione@matercarmeli.it',
sdi = '',
pec = '',
date_upd = NOW()
WHERE id_customer = '4158'
27/01/2025 02:34:29 pm >> SELECT document_num FROM ps_document
WHERE document_num = '15' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-01-27')
27/01/2025 02:34:29 pm >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'21' ,
'15' ,
'2025-01-27' ,
'' ,
'4158' ,
'0' ,
'4679457' ,
'VIA ANTONIO BENNICELLI 71 000151 ROMA' ,
'' ,
'' ,
'5' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'6' ,
'0' ,
'19.25' ,
'19.25' ,
NOW() ,
NOW() )
27/01/2025 02:34:29 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 = '95453'
27/01/2025 02:34:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '95453'
27/01/2025 02:34:29 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95453' , '13504' , 'SACRAMENTO DELLA RICONCILIAZIONE RAGAZZI' , '50' , '-50' , '0' ,
'0.30' , '0.3' , '' , '5' , '14.25' )
27/01/2025 02:40:42 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4158'
27/01/2025 02:40:42 pm >> INSERT INTO ps_address
( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd )
VALUES (
'4158' ,
'10' ,
'208' ,
'ISTITUTO MATER CARMELI' ,
'MIRANDA' ,
'MARCO' ,
'VIA ANTONIO BENNICELLI 71' ,
'' ,
'00151' ,
'ROMA' ,
'' ,
'065370456' ,
'' ,
'' ,
'' ,
NOW() ,
NOW() )
27/01/2025 02:40:42 pm >> UPDATE ps_customer SET
email = 'amministrazione@matercarmeli.it',
sdi = '',
pec = '',
date_upd = NOW()
WHERE id_customer = '4158'
27/01/2025 03:19:26 pm >> SELECT document_num FROM ps_document
WHERE document_num = '271' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-27')
27/01/2025 03:19:26 pm >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'271' ,
'2025-01-27' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'90.00' ,
'73.77' ,
NOW() ,
NOW() )
27/01/2025 03:19:26 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95454'
27/01/2025 03:19:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '95454'
27/01/2025 03:19:26 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95454' , '22105' , 'CANDELINE NON GOCCIOLANTI IN BUSTA - CHA25' , '5' , '-5' , '1' ,
'18.00' , '14.754098360656' , '22' , '0' , '90.00' )
27/01/2025 03:22:28 pm >> SELECT document_num FROM ps_document
WHERE document_num = '272' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-27')
27/01/2025 03:22:28 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' ,
'272' ,
'2025-01-27' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'18.00' ,
'14.75' ,
NOW() ,
NOW() )
27/01/2025 03:22:28 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95455'
27/01/2025 03:22:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '95455'
27/01/2025 03:22:28 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95455' , '22105' , 'CANDELINE NON GOCCIOLANTI IN BUSTA - CHA25' , '1' , '-1' , '1' ,
'18.00' , '14.754098360656' , '22' , '0' , '18.00' )
27/01/2025 03:39:38 pm >> DELETE FROM ps_product WHERE id_product = '10041'
27/01/2025 03:39:38 pm >> DELETE FROM ps_product_shop WHERE id_product = '10041'
27/01/2025 03:39:38 pm >> DELETE FROM ps_product_lang WHERE id_product = '10041'
27/01/2025 03:39:38 pm >> DELETE FROM ps_stock_available WHERE id_product = '10041'
27/01/2025 05:06:37 pm >> SELECT document_num FROM ps_document
WHERE document_num = '273' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-27')
27/01/2025 05:06:37 pm >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'273' ,
'2025-01-27' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'55.00' ,
'45.08' ,
NOW() ,
NOW() )
27/01/2025 05:06:37 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95456'
27/01/2025 05:06:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '95456'
27/01/2025 05:06:37 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95456' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' ,
'55' , '45.081967213115' , '22' , '0' , '55.00' )
27/01/2025 05:18:48 pm >> SELECT document_num FROM ps_document
WHERE document_num = '274' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-27')
27/01/2025 05:18: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' ,
'274' ,
'2025-01-27' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'100.00' ,
'81.97' ,
NOW() ,
NOW() )
27/01/2025 05:18: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 = '95457'
27/01/2025 05:18:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '95457'
27/01/2025 05:18: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
( '95457' , '19397' , 'CLERGY COTONE 100% ML - C02' , '1' , '-1' , '1' ,
'40.00' , '32.786885245902' , '22' , '0' , '40.00' )
27/01/2025 05:18: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
( '95457' , '22285' , 'CLERGY NO STIRO FANTASY 100% COT. - C34' , '1' , '-1' , '1' ,
'60' , '49.180327868852' , '22' , '0' , '60.00' )
27/01/2025 05:42:21 pm >> SELECT document_num FROM ps_document
WHERE document_num = '150' AND id_document != '95294' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-15')
27/01/2025 05:42:21 pm >> UPDATE ps_document SET
id_document_type = '11',
document_num = '150',
document_date = '2025-01-15',
document_letter = '',
id_customer = '0',
id_supplier = '',
id_address = '0',
address1 = '',
address2 = '',
note = '',
price_shipping = '0.00',
id_tax_shipping_rules = '4',
colli = '0',
peso = '0',
porto_e_imballo = '0',
mezzo_consegna = '',
id_payment = '0',
id_causal = '0',
price_tax_included = '100.00',
price_tax_excluded = '81.97',
date_upd = NOW()
WHERE id_document = '95294'
27/01/2025 05:42:21 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 = '95294'
27/01/2025 05:42:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '95294'
27/01/2025 05:42: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
( '95294' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' ,
'10' , '8.1967213114754' , '22' , '0' , '10.00' )
27/01/2025 05:42: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
( '95294' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' ,
'3' , '2.4590163934426' , '22' , '0' , '90.00' )
27/01/2025 05:42:45 pm >> SELECT document_num FROM ps_document
WHERE document_num = '88' AND id_document != '95214' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-09')
27/01/2025 05:42:45 pm >> UPDATE ps_document SET
id_document_type = '11',
document_num = '88',
document_date = '2025-01-09',
document_letter = '',
id_customer = '0',
id_supplier = '',
id_address = '0',
address1 = '',
address2 = '',
note = '',
price_shipping = '0.00',
id_tax_shipping_rules = '4',
colli = '0',
peso = '0',
porto_e_imballo = '0',
mezzo_consegna = '',
id_payment = '0',
id_causal = '0',
price_tax_included = '140.00',
price_tax_excluded = '114.75',
date_upd = NOW()
WHERE id_document = '95214'
27/01/2025 05:42:45 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95214'
27/01/2025 05:42:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '95214'
27/01/2025 05:42:45 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95214' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '2' , '-2' , '1' ,
'70.00' , '57.377049180328' , '22' , '0' , '140.00' )
27/01/2025 05:43:15 pm >> SELECT document_num FROM ps_document
WHERE document_num = '152' AND id_document != '95296' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-15')
27/01/2025 05:43:15 pm >> UPDATE ps_document SET
id_document_type = '11',
document_num = '152',
document_date = '2025-01-15',
document_letter = '',
id_customer = '0',
id_supplier = '',
id_address = '0',
address1 = '',
address2 = '',
note = '',
price_shipping = '0.00',
id_tax_shipping_rules = '4',
colli = '0',
peso = '0',
porto_e_imballo = '0',
mezzo_consegna = '',
id_payment = '0',
id_causal = '0',
price_tax_included = '56.40',
price_tax_excluded = '46.23',
date_upd = NOW()
WHERE id_document = '95296'
27/01/2025 05:43:15 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95296'
27/01/2025 05:43:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '95296'
27/01/2025 05:43:15 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95296' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '1' , '-1' , '1' ,
'56.4' , '46.229508196721' , '22' , '0' , '56.40' )
27/01/2025 05:43:40 pm >> SELECT document_num FROM ps_document
WHERE document_num = '106' AND id_document != '95236' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-10')
27/01/2025 05:43:40 pm >> UPDATE ps_document SET
id_document_type = '11',
document_num = '106',
document_date = '2025-01-10',
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 = '300.00',
price_tax_excluded = '245.90',
date_upd = NOW()
WHERE id_document = '95236'
27/01/2025 05:43:40 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95236'
27/01/2025 05:43:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '95236'
27/01/2025 05:43:40 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95236' , '15210' , 'CERO PASQUALE API 80X120' , '5' , '-5' , '1' ,
'60' , '49.180327868852' , '22' , '0' , '300.00' )
27/01/2025 05:44:55 pm >> SELECT document_num FROM ps_document
WHERE document_num = '12' AND id_document != '95125' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-02')
27/01/2025 05:44:55 pm >> UPDATE ps_document SET
id_document_type = '11',
document_num = '12',
document_date = '2025-01-02',
document_letter = '',
id_customer = '0',
id_supplier = '',
id_address = '0',
address1 = '',
address2 = '',
note = '',
price_shipping = '0.00',
id_tax_shipping_rules = '4',
colli = '0',
peso = '0',
porto_e_imballo = '0',
mezzo_consegna = '',
id_payment = '0',
id_causal = '0',
price_tax_included = '940.00',
price_tax_excluded = '775.46',
date_upd = NOW()
WHERE id_document = '95125'
27/01/2025 05:44:55 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95125'
27/01/2025 05:44:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '95125'
27/01/2025 05:44:55 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95125' , '1914' , 'CERA DELLA LITURGIA' , '2' , '-2' , '1' ,
'3' , '2.4590163934426' , '22' , '0' , '6.00' )
27/01/2025 05:44:55 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95125' , '1914' , 'CERA DELLA LITURGIA' , '11' , '-11' , '1' ,
'4.7000' , '3.8524590163934' , '22' , '0' , '51.70' )
27/01/2025 05:44:55 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95125' , '1914' , 'CERA DELLA LITURGIA' , '1' , '-1' , '1' ,
'3.3000' , '2.7049180327869' , '22' , '0' , '3.30' )
27/01/2025 05:44:55 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95125' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '10' , '-10' , '3' ,
'3.5000' , '3.3653846153846' , '4' , '0' , '35.00' )
27/01/2025 05:44:55 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95125' , '20227' , 'BAMBINELLO GESSO CM 40 STILE ANTICO - J202/40' , '1' , '-1' , '1' ,
'244.0000' , '200' , '22' , '0' , '244.00' )
27/01/2025 05:44:55 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95125' , '15210' , 'CERO PASQUALE API 80X120' , '10' , '-10' , '1' ,
'60' , '49.180327868852' , '22' , '0' , '600.00' )