11/04/2024 08:33:19 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 
11/04/2024 08:33:19 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22388' , '1' , '' , 'nuovo-prodotto' )
11/04/2024 08:33:19 am >> INSERT INTO ps_product_shop (
                      id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd`
                  ) VALUES (
                      '22388' , '1' , '1' , '2' , NOW() , NOW()
                  ) 
11/04/2024 08:33:19 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '22388' , '0' , '1' , '0' , '0' )
11/04/2024 08:34:08 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791281253438' AND id_product != '22388' AND ean13 != '' 
11/04/2024 08:34:08 am >> UPDATE ps_product SET
                  id_supplier = '',
                  reference = '',
                  ean13 = '9791281253438',
                  date_upd = NOW()
                WHERE id_product = '22388' 
11/04/2024 08:34:08 am >> UPDATE ps_product_lang SET
                  name = 'MESSALINO QUOTIDIANO - AGO SET OTT',
                  description = ''
                WHERE id_product = '22388' 
11/04/2024 08:34:08 am >> UPDATE ps_product SET
                  wholesale_price = '0.00',
                  on_sale = '0',
                  price = '6'
                WHERE id_product = '22388' 
11/04/2024 08:34:08 am >> UPDATE ps_product_shop SET
                  wholesale_price = '0.00',
                  price = '6',
                  id_tax_rules_group = '4',
                  id_category_default = '518',
                  id_argoment_default = '64',
                  id_internal_category = '7',
                  on_sale = '0',
                  on_showcase = '0',
                  on_offer = '00',
                  on_most = '00',
                  date_upd = NOW()
                WHERE id_product = '22388' 
11/04/2024 08:34:08 am >> DELETE FROM ps_specific_price WHERE id_product = '22388' 
11/04/2024 08:34:09 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 = '22388' 
11/04/2024 08:34:09 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22389' , '1' , '' , 'nuovo-prodotto' )
11/04/2024 08:34:09 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 '22389' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22388' 
11/04/2024 08:34:09 am >> INSERT INTO `ps_stock_available` (
                  id_product , id_product_attribute , id_shop , id_shop_group , quantity
                ) SELECT '22389' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22388' 
11/04/2024 08:35:20 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892243637' AND id_product != '22389' AND ean13 != '' 
11/04/2024 08:35:20 am >> UPDATE ps_product SET
                  id_supplier = '',
                  reference = '6/6',
                  ean13 = '9788892243637',
                  date_upd = NOW()
                WHERE id_product = '22389' 
11/04/2024 08:35:20 am >> UPDATE ps_product_lang SET
                  name = 'PREGHIERA NELL\'ANTICO TESTAMENTO - E. BUCCIONI',
                  description = ''
                WHERE id_product = '22389' 
11/04/2024 08:35:20 am >> UPDATE ps_product SET
                  wholesale_price = '0.00',
                  on_sale = '0',
                  price = '14'
                WHERE id_product = '22389' 
11/04/2024 08:35:20 am >> UPDATE ps_product_shop SET
                  wholesale_price = '0.00',
                  price = '14',
                  id_tax_rules_group = '4',
                  id_category_default = '30',
                  id_argoment_default = '188',
                  id_internal_category = '7',
                  on_sale = '0',
                  on_showcase = '0',
                  on_offer = '00',
                  on_most = '00',
                  date_upd = NOW()
                WHERE id_product = '22389' 
11/04/2024 08:35:20 am >> DELETE FROM ps_specific_price WHERE id_product = '22389' 
11/04/2024 08:35:21 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 = '22389' 
11/04/2024 08:35:21 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22390' , '1' , '' , 'nuovo-prodotto' )
11/04/2024 08:35:21 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 '22390' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22389' 
11/04/2024 08:35:21 am >> INSERT INTO `ps_stock_available` (
                  id_product , id_product_attribute , id_shop , id_shop_group , quantity
                ) SELECT '22390' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22389' 
11/04/2024 08:35:55 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788825058642' AND id_product != '22390' AND ean13 != '' 
11/04/2024 08:35:55 am >> UPDATE ps_product SET
                  id_supplier = '',
                  reference = '13/4',
                  ean13 = '9788825058642',
                  date_upd = NOW()
                WHERE id_product = '22390' 
11/04/2024 08:35:55 am >> UPDATE ps_product_lang SET
                  name = 'ROSARIO DELLA GUARIGIONE',
                  description = ''
                WHERE id_product = '22390' 
11/04/2024 08:35:55 am >> UPDATE ps_product SET
                  wholesale_price = '0.00',
                  on_sale = '0',
                  price = '3'
                WHERE id_product = '22390' 
11/04/2024 08:35:55 am >> UPDATE ps_product_shop SET
                  wholesale_price = '0.00',
                  price = '3',
                  id_tax_rules_group = '4',
                  id_category_default = '17',
                  id_argoment_default = '28',
                  id_internal_category = '7',
                  on_sale = '0',
                  on_showcase = '0',
                  on_offer = '00',
                  on_most = '00',
                  date_upd = NOW()
                WHERE id_product = '22390' 
11/04/2024 08:35:55 am >> DELETE FROM ps_specific_price WHERE id_product = '22390' 
11/04/2024 08:35:56 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 = '22390' 
11/04/2024 08:35:56 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22391' , '1' , '' , 'nuovo-prodotto' )
11/04/2024 08:35:56 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 '22391' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22390' 
11/04/2024 08:35:56 am >> INSERT INTO `ps_stock_available` (
                  id_product , id_product_attribute , id_shop , id_shop_group , quantity
                ) SELECT '22391' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22390' 
11/04/2024 08:36:55 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791281253704' AND id_product != '22391' AND ean13 != '' 
11/04/2024 08:36:55 am >> UPDATE ps_product SET
                  id_supplier = '',
                  reference = '7/5',
                  ean13 = '9791281253704',
                  date_upd = NOW()
                WHERE id_product = '22391' 
11/04/2024 08:36:55 am >> UPDATE ps_product_lang SET
                  name = 'UN ANNO CON MARIA - BENEDETTO XVI',
                  description = ''
                WHERE id_product = '22391' 
11/04/2024 08:36:55 am >> UPDATE ps_product SET
                  wholesale_price = '0.00',
                  on_sale = '0',
                  price = '10'
                WHERE id_product = '22391' 
11/04/2024 08:36:55 am >> UPDATE ps_product_shop SET
                  wholesale_price = '0.00',
                  price = '10',
                  id_tax_rules_group = '4',
                  id_category_default = '518',
                  id_argoment_default = '28',
                  id_internal_category = '7',
                  on_sale = '0',
                  on_showcase = '0',
                  on_offer = '00',
                  on_most = '00',
                  date_upd = NOW()
                WHERE id_product = '22391' 
11/04/2024 08:36:55 am >> DELETE FROM ps_specific_price WHERE id_product = '22391' 
11/04/2024 08:36:56 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 = '22391' 
11/04/2024 08:36:56 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22392' , '1' , '' , 'nuovo-prodotto' )
11/04/2024 08:36:56 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 '22392' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22391' 
11/04/2024 08:36:56 am >> INSERT INTO `ps_stock_available` (
                  id_product , id_product_attribute , id_shop , id_shop_group , quantity
                ) SELECT '22392' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22391' 
11/04/2024 08:37:42 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9787706240503' AND id_product != '22392' AND ean13 != '' 
11/04/2024 08:37:42 am >> UPDATE ps_product SET
                  id_supplier = '',
                  reference = '7/4',
                  ean13 = '9787706240503',
                  date_upd = NOW()
                WHERE id_product = '22392' 
11/04/2024 08:37:42 am >> UPDATE ps_product_lang SET
                  name = 'DALL\'ALBA AL TRAMONTO - MAG 2024',
                  description = ''
                WHERE id_product = '22392' 
11/04/2024 08:37:42 am >> UPDATE ps_product SET
                  wholesale_price = '0.00',
                  on_sale = '0',
                  price = '3.2'
                WHERE id_product = '22392' 
11/04/2024 08:37:42 am >> UPDATE ps_product_shop SET
                  wholesale_price = '0.00',
                  price = '3.2',
                  id_tax_rules_group = '4',
                  id_category_default = '280',
                  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 = '22392' 
11/04/2024 08:37:42 am >> DELETE FROM ps_specific_price WHERE id_product = '22392' 
11/04/2024 08:37:43 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 = '22392' 
11/04/2024 08:37:43 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22393' , '1' , '' , 'nuovo-prodotto' )
11/04/2024 08:37:43 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 '22393' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22392' 
11/04/2024 08:37:43 am >> INSERT INTO `ps_stock_available` (
                  id_product , id_product_attribute , id_shop , id_shop_group , quantity
                ) SELECT '22393' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22392' 
11/04/2024 08:38:27 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791281618084' AND id_product != '22393' AND ean13 != '' 
11/04/2024 08:38:27 am >> UPDATE ps_product SET
                  id_supplier = '',
                  reference = '1/3',
                  ean13 = '9791281618084',
                  date_upd = NOW()
                WHERE id_product = '22393' 
11/04/2024 08:38:27 am >> UPDATE ps_product_lang SET
                  name = 'BATTESIMO NELLO SPIRITO - R. CANTALAMESSA',
                  description = ''
                WHERE id_product = '22393' 
11/04/2024 08:38:27 am >> UPDATE ps_product SET
                  wholesale_price = '0.00',
                  on_sale = '0',
                  price = '12'
                WHERE id_product = '22393' 
11/04/2024 08:38:27 am >> UPDATE ps_product_shop SET
                  wholesale_price = '0.00',
                  price = '12',
                  id_tax_rules_group = '4',
                  id_category_default = '76',
                  id_argoment_default = '145',
                  id_internal_category = '7',
                  on_sale = '0',
                  on_showcase = '0',
                  on_offer = '00',
                  on_most = '00',
                  date_upd = NOW()
                WHERE id_product = '22393' 
11/04/2024 08:38:27 am >> DELETE FROM ps_specific_price WHERE id_product = '22393' 
11/04/2024 08: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 = '22393' 
11/04/2024 08:38:28 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22394' , '1' , '' , 'nuovo-prodotto' )
11/04/2024 08: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 '22394' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22393' 
11/04/2024 08:38:28 am >> INSERT INTO `ps_stock_available` (
                  id_product , id_product_attribute , id_shop , id_shop_group , quantity
                ) SELECT '22394' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22393' 
11/04/2024 08:39:17 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791281618008' AND id_product != '22394' AND ean13 != '' 
11/04/2024 08:39:17 am >> UPDATE ps_product SET
                  id_supplier = '',
                  reference = '7/7',
                  ean13 = '9791281618008',
                  date_upd = NOW()
                WHERE id_product = '22394' 
11/04/2024 08:39:17 am >> UPDATE ps_product_lang SET
                  name = 'NOVISSIMI ... O VECCHISSIMI? - L. ALESSANDRINI',
                  description = ''
                WHERE id_product = '22394' 
11/04/2024 08:39:17 am >> UPDATE ps_product SET
                  wholesale_price = '0.00',
                  on_sale = '0',
                  price = '12'
                WHERE id_product = '22394' 
11/04/2024 08:39:18 am >> UPDATE ps_product_shop SET
                  wholesale_price = '0.00',
                  price = '12',
                  id_tax_rules_group = '4',
                  id_category_default = '76',
                  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 = '22394' 
11/04/2024 08:39:18 am >> DELETE FROM ps_specific_price WHERE id_product = '22394' 
11/04/2024 08:39:18 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 = '22394' 
11/04/2024 08:39:18 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22395' , '1' , '' , 'nuovo-prodotto' )
11/04/2024 08:39:18 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 '22395' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22394' 
11/04/2024 08:39:18 am >> INSERT INTO `ps_stock_available` (
                  id_product , id_product_attribute , id_shop , id_shop_group , quantity
                ) SELECT '22395' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22394' 
11/04/2024 08:40:06 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892244191' AND id_product != '22395' AND ean13 != '' 
11/04/2024 08:40:06 am >> UPDATE ps_product SET
                  id_supplier = '',
                  reference = '11/7',
                  ean13 = '9788892244191',
                  date_upd = NOW()
                WHERE id_product = '22395' 
11/04/2024 08:40:06 am >> UPDATE ps_product_lang SET
                  name = 'DA GERUSALEMME A ROMA - M. SODI',
                  description = ''
                WHERE id_product = '22395' 
11/04/2024 08:40:06 am >> UPDATE ps_product SET
                  wholesale_price = '0.00',
                  on_sale = '0',
                  price = '18'
                WHERE id_product = '22395' 
11/04/2024 08:40:06 am >> UPDATE ps_product_shop SET
                  wholesale_price = '0.00',
                  price = '18',
                  id_tax_rules_group = '4',
                  id_category_default = '30',
                  id_argoment_default = '16',
                  id_internal_category = '7',
                  on_sale = '0',
                  on_showcase = '0',
                  on_offer = '00',
                  on_most = '00',
                  date_upd = NOW()
                WHERE id_product = '22395' 
11/04/2024 08:40:06 am >> DELETE FROM ps_specific_price WHERE id_product = '22395' 
11/04/2024 08:40:06 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 = '22395' 
11/04/2024 08:40:07 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22396' , '1' , '' , 'nuovo-prodotto' )
11/04/2024 08:40: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 '22396' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22395' 
11/04/2024 08:40:07 am >> INSERT INTO `ps_stock_available` (
                  id_product , id_product_attribute , id_shop , id_shop_group , quantity
                ) SELECT '22396' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22395' 
11/04/2024 08:40:56 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892244412' AND id_product != '22396' AND ean13 != '' 
11/04/2024 08:40:56 am >> UPDATE ps_product SET
                  id_supplier = '',
                  reference = '7/5',
                  ean13 = '9788892244412',
                  date_upd = NOW()
                WHERE id_product = '22396' 
11/04/2024 08:40:56 am >> UPDATE ps_product_lang SET
                  name = 'PREGARE E VIVERE - L. PACOMIO',
                  description = ''
                WHERE id_product = '22396' 
11/04/2024 08:40:56 am >> UPDATE ps_product SET
                  wholesale_price = '0.00',
                  on_sale = '0',
                  price = '16'
                WHERE id_product = '22396' 
11/04/2024 08:40:56 am >> UPDATE ps_product_shop SET
                  wholesale_price = '0.00',
                  price = '16',
                  id_tax_rules_group = '4',
                  id_category_default = '30',
                  id_argoment_default = '188',
                  id_internal_category = '7',
                  on_sale = '0',
                  on_showcase = '0',
                  on_offer = '00',
                  on_most = '00',
                  date_upd = NOW()
                WHERE id_product = '22396' 
11/04/2024 08:40:56 am >> DELETE FROM ps_specific_price WHERE id_product = '22396' 
11/04/2024 08:40:57 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 = '22396' 
11/04/2024 08:40:57 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22397' , '1' , '' , 'nuovo-prodotto' )
11/04/2024 08:40:57 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 '22397' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22396' 
11/04/2024 08:40:57 am >> INSERT INTO `ps_stock_available` (
                  id_product , id_product_attribute , id_shop , id_shop_group , quantity
                ) SELECT '22397' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22396' 
11/04/2024 08:41:35 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831556668' AND id_product != '22397' AND ean13 != '' 
11/04/2024 08:41:35 am >> UPDATE ps_product SET
                  id_supplier = '',
                  reference = '13/3',
                  ean13 = '9788831556668',
                  date_upd = NOW()
                WHERE id_product = '22397' 
11/04/2024 08:41:35 am >> UPDATE ps_product_lang SET
                  name = 'AFFERRATI DALL\'AMORE',
                  description = ''
                WHERE id_product = '22397' 
11/04/2024 08:41:35 am >> UPDATE ps_product SET
                  wholesale_price = '0.00',
                  on_sale = '0',
                  price = '4.9'
                WHERE id_product = '22397' 
11/04/2024 08:41:35 am >> UPDATE ps_product_shop SET
                  wholesale_price = '0.00',
                  price = '4.9',
                  id_tax_rules_group = '4',
                  id_category_default = '27',
                  id_argoment_default = '150',
                  id_internal_category = '7',
                  on_sale = '0',
                  on_showcase = '0',
                  on_offer = '00',
                  on_most = '00',
                  date_upd = NOW()
                WHERE id_product = '22397' 
11/04/2024 08:41:35 am >> DELETE FROM ps_specific_price WHERE id_product = '22397' 
11/04/2024 08:41: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 = '22397' 
11/04/2024 08:41:36 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22398' , '1' , '' , 'nuovo-prodotto' )
11/04/2024 08:41: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 '22398' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22397' 
11/04/2024 08:41:36 am >> INSERT INTO `ps_stock_available` (
                  id_product , id_product_attribute , id_shop , id_shop_group , quantity
                ) SELECT '22398' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22397' 
11/04/2024 08:42:27 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9728831222446' AND id_product != '22398' AND ean13 != '' 
11/04/2024 08:42:27 am >> UPDATE ps_product SET
                  id_supplier = '',
                  reference = '1/3',
                  ean13 = '9728831222446',
                  date_upd = NOW()
                WHERE id_product = '22398' 
11/04/2024 08:42:27 am >> UPDATE ps_product_lang SET
                  name = 'CREDERE - R. MAGGI',
                  description = ''
                WHERE id_product = '22398' 
11/04/2024 08:42:27 am >> UPDATE ps_product SET
                  wholesale_price = '0.00',
                  on_sale = '0',
                  price = '10'
                WHERE id_product = '22398' 
11/04/2024 08:42:27 am >> UPDATE ps_product_shop SET
                  wholesale_price = '0.00',
                  price = '10',
                  id_tax_rules_group = '4',
                  id_category_default = '302',
                  id_argoment_default = '22',
                  id_internal_category = '7',
                  on_sale = '0',
                  on_showcase = '0',
                  on_offer = '00',
                  on_most = '00',
                  date_upd = NOW()
                WHERE id_product = '22398' 
11/04/2024 08:42:27 am >> DELETE FROM ps_specific_price WHERE id_product = '22398' 
11/04/2024 08:42: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 = '22398' 
11/04/2024 08:42:28 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22399' , '1' , '' , 'nuovo-prodotto' )
11/04/2024 08:42: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 '22399' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22398' 
11/04/2024 08:42:28 am >> INSERT INTO `ps_stock_available` (
                  id_product , id_product_attribute , id_shop , id_shop_group , quantity
                ) SELECT '22399' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22398' 
11/04/2024 08:43:12 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791281465046' AND id_product != '22399' AND ean13 != '' 
11/04/2024 08:43:12 am >> UPDATE ps_product SET
                  id_supplier = '',
                  reference = '7/3',
                  ean13 = '9791281465046',
                  date_upd = NOW()
                WHERE id_product = '22399' 
11/04/2024 08:43:12 am >> UPDATE ps_product_lang SET
                  name = 'TUTTO IN UN FRAMMENTO - E. BOLIS',
                  description = ''
                WHERE id_product = '22399' 
11/04/2024 08:43:12 am >> UPDATE ps_product SET
                  wholesale_price = '0.00',
                  on_sale = '0',
                  price = '13'
                WHERE id_product = '22399' 
11/04/2024 08:43:12 am >> UPDATE ps_product_shop SET
                  wholesale_price = '0.00',
                  price = '13',
                  id_tax_rules_group = '4',
                  id_category_default = '97',
                  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 = '22399' 
11/04/2024 08:43:12 am >> DELETE FROM ps_specific_price WHERE id_product = '22399' 
11/04/2024 08:43:13 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 = '22399' 
11/04/2024 08:43:13 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22400' , '1' , '' , 'nuovo-prodotto' )
11/04/2024 08:43:13 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 '22400' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22399' 
11/04/2024 08:43:13 am >> INSERT INTO `ps_stock_available` (
                  id_product , id_product_attribute , id_shop , id_shop_group , quantity
                ) SELECT '22400' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22399' 
11/04/2024 08:44:02 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788839928054' AND id_product != '22400' AND ean13 != '' 
11/04/2024 08:44:02 am >> UPDATE ps_product SET
                  id_supplier = '',
                  reference = '1/2',
                  ean13 = '9788839928054',
                  date_upd = NOW()
                WHERE id_product = '22400' 
11/04/2024 08:44:02 am >> UPDATE ps_product_lang SET
                  name = 'ACCOMPAGNARE I CATECUMENI - R. LACROIX',
                  description = ''
                WHERE id_product = '22400' 
11/04/2024 08:44:02 am >> UPDATE ps_product SET
                  wholesale_price = '0.00',
                  on_sale = '0',
                  price = '16'
                WHERE id_product = '22400' 
11/04/2024 08:44:02 am >> UPDATE ps_product_shop SET
                  wholesale_price = '0.00',
                  price = '16',
                  id_tax_rules_group = '4',
                  id_category_default = '111',
                  id_argoment_default = '22',
                  id_internal_category = '7',
                  on_sale = '0',
                  on_showcase = '0',
                  on_offer = '00',
                  on_most = '00',
                  date_upd = NOW()
                WHERE id_product = '22400' 
11/04/2024 08:44:02 am >> DELETE FROM ps_specific_price WHERE id_product = '22400' 
11/04/2024 08:44:03 am >> INSERT INTO ps_product (
                  id_tax_rules_group , `date_add` , `date_upd`
                ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22400' 
11/04/2024 08:44:03 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22401' , '1' , '' , 'nuovo-prodotto' )
11/04/2024 08:44:03 am >> INSERT INTO ps_product_shop (
                    id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd`
                ) SELECT '22401' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22400' 
11/04/2024 08:44:03 am >> INSERT INTO `ps_stock_available` (
                  id_product , id_product_attribute , id_shop , id_shop_group , quantity
                ) SELECT '22401' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22400' 
11/04/2024 08:44:45 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788839934604' AND id_product != '22401' AND ean13 != '' 
11/04/2024 08:44:45 am >> UPDATE ps_product SET
                  id_supplier = '',
                  reference = '13/6',
                  ean13 = '9788839934604',
                  date_upd = NOW()
                WHERE id_product = '22401' 
11/04/2024 08:44:45 am >> UPDATE ps_product_lang SET
                  name = 'CHRISTIAN DE CHERGE - C. SALENSON',
                  description = ''
                WHERE id_product = '22401' 
11/04/2024 08:44:45 am >> UPDATE ps_product SET
                  wholesale_price = '0.00',
                  on_sale = '0',
                  price = '32'
                WHERE id_product = '22401' 
11/04/2024 08:44:45 am >> UPDATE ps_product_shop SET
                  wholesale_price = '0.00',
                  price = '32',
                  id_tax_rules_group = '4',
                  id_category_default = '111',
                  id_argoment_default = '65',
                  id_internal_category = '7',
                  on_sale = '0',
                  on_showcase = '0',
                  on_offer = '00',
                  on_most = '00',
                  date_upd = NOW()
                WHERE id_product = '22401' 
11/04/2024 08:44:45 am >> DELETE FROM ps_specific_price WHERE id_product = '22401' 
11/04/2024 08:44:46 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 = '22401' 
11/04/2024 08:44:46 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22402' , '1' , '' , 'nuovo-prodotto' )
11/04/2024 08:44:46 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 '22402' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22401' 
11/04/2024 08:44:46 am >> INSERT INTO `ps_stock_available` (
                  id_product , id_product_attribute , id_shop , id_shop_group , quantity
                ) SELECT '22402' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22401' 
11/04/2024 08:45:44 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884248114' AND id_product != '22402' AND ean13 != '' 
11/04/2024 08:45:44 am >> UPDATE ps_product SET
                  id_supplier = '',
                  reference = '7/6',
                  ean13 = '9788884248114',
                  date_upd = NOW()
                WHERE id_product = '22402' 
11/04/2024 08:45:45 am >> UPDATE ps_product_lang SET
                  name = 'REGNO DI DIO E\' UNA SFIDA - F.J. SHEEN',
                  description = ''
                WHERE id_product = '22402' 
11/04/2024 08:45:45 am >> UPDATE ps_product SET
                  wholesale_price = '0.00',
                  on_sale = '0',
                  price = '16'
                WHERE id_product = '22402' 
11/04/2024 08:45:45 am >> UPDATE ps_product_shop SET
                  wholesale_price = '0.00',
                  price = '16',
                  id_tax_rules_group = '4',
                  id_category_default = '83',
                  id_argoment_default = '23',
                  id_internal_category = '7',
                  on_sale = '0',
                  on_showcase = '0',
                  on_offer = '00',
                  on_most = '00',
                  date_upd = NOW()
                WHERE id_product = '22402' 
11/04/2024 08:45:45 am >> DELETE FROM ps_specific_price WHERE id_product = '22402' 
11/04/2024 08:45:45 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 = '22402' 
11/04/2024 08:45:45 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22403' , '1' , '' , 'nuovo-prodotto' )
11/04/2024 08:45:45 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 '22403' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22402' 
11/04/2024 08:45:45 am >> INSERT INTO `ps_stock_available` (
                  id_product , id_product_attribute , id_shop , id_shop_group , quantity
                ) SELECT '22403' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22402' 
11/04/2024 08:46:23 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892244375' AND id_product != '22403' AND ean13 != '' 
11/04/2024 08:46:23 am >> UPDATE ps_product SET
                  id_supplier = '',
                  reference = '13/3',
                  ean13 = '9788892244375',
                  date_upd = NOW()
                WHERE id_product = '22403' 
11/04/2024 08:46:23 am >> UPDATE ps_product_lang SET
                  name = 'MIO LIBRO DI PREGHIERE - A. COMASTRI',
                  description = ''
                WHERE id_product = '22403' 
11/04/2024 08:46:23 am >> UPDATE ps_product SET
                  wholesale_price = '0.00',
                  on_sale = '0',
                  price = '12'
                WHERE id_product = '22403' 
11/04/2024 08:46:23 am >> UPDATE ps_product_shop SET
                  wholesale_price = '0.00',
                  price = '12',
                  id_tax_rules_group = '4',
                  id_category_default = '30',
                  id_argoment_default = '28',
                  id_internal_category = '7',
                  on_sale = '0',
                  on_showcase = '0',
                  on_offer = '00',
                  on_most = '00',
                  date_upd = NOW()
                WHERE id_product = '22403' 
11/04/2024 08:46:23 am >> DELETE FROM ps_specific_price WHERE id_product = '22403' 
11/04/2024 08:46:23 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 = '22403' 
11/04/2024 08:46:23 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22404' , '1' , '' , 'nuovo-prodotto' )
11/04/2024 08:46:23 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 '22404' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22403' 
11/04/2024 08:46:23 am >> INSERT INTO `ps_stock_available` (
                  id_product , id_product_attribute , id_shop , id_shop_group , quantity
                ) SELECT '22404' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22403' 
11/04/2024 08:47:58 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9728831222446' AND id_product != '22398' AND ean13 != '' 
11/04/2024 08:47:58 am >> UPDATE ps_product SET
                  id_supplier = '',
                  reference = '1/3',
                  ean13 = '9728831222446',
                  date_upd = NOW()
                WHERE id_product = '22398' 
11/04/2024 08:47:58 am >> UPDATE ps_product_lang SET
                  name = 'CREDERE - R. MAGGI',
                  description = ''
                WHERE id_product = '22398' 
11/04/2024 08:47:58 am >> UPDATE ps_product SET
                  wholesale_price = '0.00',
                  on_sale = '0',
                  price = '10.0000'
                WHERE id_product = '22398' 
11/04/2024 08:47:58 am >> UPDATE ps_product_shop SET
                  wholesale_price = '0.00',
                  price = '10.0000',
                  id_tax_rules_group = '4',
                  id_category_default = '302',
                  id_argoment_default = '22',
                  id_internal_category = '7',
                  on_sale = '0',
                  on_showcase = '0',
                  on_offer = '00',
                  on_most = '00',
                  date_upd = NOW()
                WHERE id_product = '22398' 
11/04/2024 08:47:58 am >> DELETE FROM ps_specific_price WHERE id_product = '22398' 
11/04/2024 08:52:32 am >> INSERT INTO ps_document (
                                id_document_type ,
                                document_num ,
                                document_date ,
                                document_letter ,
                                id_customer ,
                                id_supplier ,
                                id_address ,
                                address1 ,
                                address2 ,
                                note ,
                                price_shipping ,
                                id_tax_shipping_rules ,
                                colli ,
                                peso ,
                                porto_e_imballo ,
                                mezzo_consegna ,
                                id_payment ,
                                id_causal ,
                                price_tax_included ,
                                price_tax_excluded ,
                                date_add ,
                                date_upd
                )  VALUES  (
                          '33' ,
                          '661179' ,
                          '2024-04-05' ,
                          '' ,
                          '0' ,
                          '7' ,
                          '2602' ,
                          'P. ZZA SAN PAOLO, 14 12051 ALBA' ,
                          '' ,
                          '' ,
                          '5.68' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '202.03' ,
                          '202.03' ,
                          NOW() ,
                          NOW() ) 
11/04/2024 08:52:32 am >>  INSERT INTO ps_document_detail_backup
                                ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
                            SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91205' 
11/04/2024 08:52:32 am >>  DELETE FROM ps_document_detail WHERE id_document = '91205' 
11/04/2024 08:52:32 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '91205' , '22398' , 'CREDERE - R. MAGGI' , '1' ,  '1' , '4' ,
                               '10.00' , '10' , '0' , '30' , '7.0000' ) 
11/04/2024 08:52:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '22398' AND id_supplier = '7' 
11/04/2024 08:52:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22398' , '7' , '1' ) 
11/04/2024 08:52:32 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '91205' , '22395' , 'DA GERUSALEMME A ROMA - M. SODI' , '1' ,  '1' , '4' ,
                               '18.00' , '18' , '0' , '33' , '12.0600' ) 
11/04/2024 08:52:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '22395' AND id_supplier = '7' 
11/04/2024 08:52:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22395' , '7' , '1' ) 
11/04/2024 08:52:32 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '91205' , '22397' , 'AFFERRATI DALLAMORE' , '2' ,  '2' , '4' ,
                               '4.90' , '4.9' , '0' , '33' , '6.5660' ) 
11/04/2024 08:52:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '22397' AND id_supplier = '7' 
11/04/2024 08:52:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22397' , '7' , '1' ) 
11/04/2024 08:52:33 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
                            ( '91205' , '22390' , 'ROSARIO DELLA GUARIGIONE' , '2' ,  '2' , '4' ,
                               '3.00' , '3' , '0' , '30' , '4.2000' ) 
11/04/2024 08:52:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '22390' AND id_supplier = '7' 
11/04/2024 08:52:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22390' , '7' , '1' ) 
11/04/2024 08:52:33 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
                            ( '91205' , '22399' , 'TUTTO IN UN FRAMMENTO - E. BOLIS' , '1' ,  '1' , '4' ,
                               '13.00' , '13' , '0' , '30' , '9.1000' ) 
11/04/2024 08:52:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '22399' AND id_supplier = '7' 
11/04/2024 08:52:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22399' , '7' , '1' ) 
11/04/2024 08:52:33 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
                            ( '91205' , '22402' , 'REGNO DI DIO E UNA SFIDA - F.J. SHEEN' , '1' ,  '1' , '4' ,
                               '16.00' , '16' , '0' , '30' , '11.2000' ) 
11/04/2024 08:52:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '22402' AND id_supplier = '7' 
11/04/2024 08:52:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22402' , '7' , '1' ) 
11/04/2024 08:52:33 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
                            ( '91205' , '22391' , 'UN ANNO CON MARIA - BENEDETTO XVI' , '1' ,  '1' , '4' ,
                               '10.00' , '10' , '0' , '30' , '7.0000' ) 
11/04/2024 08:52:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '22391' AND id_supplier = '7' 
11/04/2024 08:52:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22391' , '7' , '1' ) 
11/04/2024 08:52:33 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
                            ( '91205' , '22400' , 'ACCOMPAGNARE I CATECUMENI - R. LACROIX' , '1' ,  '1' , '4' ,
                               '16.00' , '16' , '0' , '30' , '11.2000' ) 
11/04/2024 08:52:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '22400' AND id_supplier = '7' 
11/04/2024 08:52:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22400' , '7' , '1' ) 
11/04/2024 08:52:33 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
                            ( '91205' , '22401' , 'CHRISTIAN DE CHERGE - C. SALENSON' , '1' ,  '1' , '4' ,
                               '32.00' , '32' , '0' , '30' , '22.4000' ) 
11/04/2024 08:52:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '22401' AND id_supplier = '7' 
11/04/2024 08:52:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22401' , '7' , '1' ) 
11/04/2024 08:52:33 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
                            ( '91205' , '22394' , 'NOVISSIMI ... O VECCHISSIMI? - L. ALESSANDRINI' , '1' ,  '1' , '4' ,
                               '12.00' , '12' , '0' , '30' , '8.4000' ) 
11/04/2024 08:52:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '22394' AND id_supplier = '7' 
11/04/2024 08:52:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22394' , '7' , '1' ) 
11/04/2024 08:52:33 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
                            ( '91205' , '22393' , 'BATTESIMO NELLO SPIRITO - R. CANTALAMESSA' , '1' ,  '1' , '4' ,
                               '12.00' , '12' , '0' , '30' , '8.4000' ) 
11/04/2024 08:52:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '22393' AND id_supplier = '7' 
11/04/2024 08:52:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22393' , '7' , '1' ) 
11/04/2024 08:52:33 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
                            ( '91205' , '22403' , 'MIO LIBRO DI PREGHIERE - A. COMASTRI' , '2' ,  '2' , '4' ,
                               '12.00' , '12' , '0' , '33' , '16.0800' ) 
11/04/2024 08:52:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '22403' AND id_supplier = '7' 
11/04/2024 08:52:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22403' , '7' , '1' ) 
11/04/2024 08:52:33 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
                            ( '91205' , '22396' , 'PREGARE E VIVERE - L. PACOMIO' , '1' ,  '1' , '4' ,
                               '16.00' , '16' , '0' , '33' , '10.7200' ) 
11/04/2024 08:52:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '22396' AND id_supplier = '7' 
11/04/2024 08:52:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22396' , '7' , '1' ) 
11/04/2024 08:52:33 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
                            ( '91205' , '22389' , 'PREGHIERA NELLANTICO TESTAMENTO - E. BUCCIONI' , '1' ,  '1' , '4' ,
                               '14.00' , '14' , '0' , '33' , '9.3800' ) 
11/04/2024 08:52:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '22389' AND id_supplier = '7' 
11/04/2024 08:52:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22389' , '7' , '1' ) 
11/04/2024 08:52:33 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
                            ( '91205' , '22388' , 'MESSALINO QUOTIDIANO - AGO SET OTT' , '12' ,  '12' , '4' ,
                               '6.00' , '6' , '0' , '30' , '50.4000' ) 
11/04/2024 08:52:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '22388' AND id_supplier = '7' 
11/04/2024 08:52:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22388' , '7' , '1' ) 
11/04/2024 08:52:33 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
                            ( '91205' , '22388' , 'MESSALINO QUOTIDIANO - AGO SET OTT' , '1' ,  '1' , '4' ,
                               '6.00' , '6' , '0' , '100' , '0.0000' ) 
11/04/2024 08:52:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '22388' AND id_supplier = '7' 
11/04/2024 08:52:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22388' , '7' , '1' ) 
11/04/2024 08:52:33 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
                            ( '91205' , '22392' , 'DALLALBA AL TRAMONTO - MAG 2024' , '1' ,  '1' , '4' ,
                               '3.20' , '3.2' , '0' , '30' , '2.2400' ) 
11/04/2024 08:52:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '22392' AND id_supplier = '7' 
11/04/2024 08:52:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22392' , '7' , '1' ) 
11/04/2024 09:27:12 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '1100' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-11') 
11/04/2024 09:27:12 am >> INSERT INTO ps_document (
                                id_document_type ,
                                document_num ,
                                document_date ,
                                document_letter ,
                                id_customer ,
                                id_supplier ,
                                id_address ,
                                address1 ,
                                address2 ,
                                note ,
                                price_shipping ,
                                id_tax_shipping_rules ,
                                colli ,
                                peso ,
                                porto_e_imballo ,
                                mezzo_consegna ,
                                id_payment ,
                                id_causal ,
                                price_tax_included ,
                                price_tax_excluded ,
                                date_add ,
                                date_upd
                )  VALUES  (
                          '11' ,
                          '1100' ,
                          '2024-04-11' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '154.80' ,
                          '129.63' ,
                          NOW() ,
                          NOW() ) 
11/04/2024 09:27:12 am >>  INSERT INTO ps_document_detail_backup
                                ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
                            SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91206' 
11/04/2024 09:27:12 am >>  DELETE FROM ps_document_detail WHERE id_document = '91206' 
11/04/2024 09:27: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
                            ( '91206' , '22336' , 'CALAMITE ' , '14' ,  '-14' , '1' ,
                               '4.90' , '4.016393442623' , '22' , '0' , '68.60' ) 
11/04/2024 09:27: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
                            ( '91206' , '19108' , 'PORTATECA COMPLETA - 947' , '1' ,  '-1' , '1' ,
                               '51.00' , '41.803278688525' , '22' , '0' , '51.00' ) 
11/04/2024 09:27: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
                            ( '91206' , '7202' , 'ARTICOLI RELIGIOSI' , '1' ,  '-1' , '1' ,
                               '20' , '16.393442622951' , '22' , '0' , '20.00' ) 
11/04/2024 09:27: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
                            ( '91206' , '22131' , 'SAN FRANCESCO DI PAOLA - A. DE LORENZI' , '1' ,  '-1' , '4' ,
                               '16.00' , '16' , '0' , '5' , '15.20' ) 
11/04/2024 09:30:19 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '1101' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-11') 
11/04/2024 09:30:19 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' ,
                          '1101' ,
                          '2024-04-11' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '11.40' ,
                          '11.40' ,
                          NOW() ,
                          NOW() ) 
11/04/2024 09:30:19 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 = '91207' 
11/04/2024 09:30:19 am >>  DELETE FROM ps_document_detail WHERE id_document = '91207' 
11/04/2024 09:30: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
                            ( '91207' , '22403' , 'MIO LIBRO DI PREGHIERE - A. COMASTRI' , '1' ,  '-1' , '4' ,
                               '12.00' , '12' , '0' , '5' , '11.40' ) 
11/04/2024 09:33:06 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '1102' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-11') 
11/04/2024 09:33:06 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' ,
                          '1102' ,
                          '2024-04-11' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '21.76' ,
                          '21.76' ,
                          NOW() ,
                          NOW() ) 
11/04/2024 09:33:06 am >>  INSERT INTO ps_document_detail_backup
                                ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
                            SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91208' 
11/04/2024 09:33:06 am >>  DELETE FROM ps_document_detail WHERE id_document = '91208' 
11/04/2024 09:33:06 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '91208' , '22330' , 'LIFE - LA MIA STORIA - PAPA FRANCESCO' , '1' ,  '-1' , '4' ,
                               '19.00' , '19' , '0' , '5' , '18.05' ) 
11/04/2024 09:33:06 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '91208' , '22370' , 'DIGNITAS INFINITA' , '1' ,  '-1' , '4' ,
                               '3.90' , '3.9' , '0' , '5' , '3.71' ) 
11/04/2024 09:49:43 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '1103' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-11') 
11/04/2024 09:49:43 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' ,
                          '1103' ,
                          '2024-04-11' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '55.00' ,
                          '45.08' ,
                          NOW() ,
                          NOW() ) 
11/04/2024 09:49: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 = '91209' 
11/04/2024 09:49:43 am >>  DELETE FROM ps_document_detail WHERE id_document = '91209' 
11/04/2024 09:49: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
                            ( '91209' , '7202' , 'ARTICOLI RELIGIOSI' , '1' ,  '-1' , '1' ,
                               '55' , '45.081967213115' , '22' , '0' , '55.00' ) 
11/04/2024 10:48:39 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '1104' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-11') 
11/04/2024 10:48:39 am >> INSERT INTO ps_document (
                                id_document_type ,
                                document_num ,
                                document_date ,
                                document_letter ,
                                id_customer ,
                                id_supplier ,
                                id_address ,
                                address1 ,
                                address2 ,
                                note ,
                                price_shipping ,
                                id_tax_shipping_rules ,
                                colli ,
                                peso ,
                                porto_e_imballo ,
                                mezzo_consegna ,
                                id_payment ,
                                id_causal ,
                                price_tax_included ,
                                price_tax_excluded ,
                                date_add ,
                                date_upd
                )  VALUES  (
                          '11' ,
                          '1104' ,
                          '2024-04-11' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '57.00' ,
                          '57.00' ,
                          NOW() ,
                          NOW() ) 
11/04/2024 10:48:39 am >>  INSERT INTO ps_document_detail_backup
                                ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
                            SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91210' 
11/04/2024 10:48:39 am >>  DELETE FROM ps_document_detail WHERE id_document = '91210' 
11/04/2024 10:48:39 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '91210' , '22341' , 'SULLA TUA PAROLA - MAG/GIU 2024' , '12' ,  '-12' , '4' ,
                               '5.00' , '5' , '0' , '5' , '57.00' ) 
11/04/2024 10:51:32 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '1105' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-11') 
11/04/2024 10:51:32 am >> INSERT INTO ps_document (
                                id_document_type ,
                                document_num ,
                                document_date ,
                                document_letter ,
                                id_customer ,
                                id_supplier ,
                                id_address ,
                                address1 ,
                                address2 ,
                                note ,
                                price_shipping ,
                                id_tax_shipping_rules ,
                                colli ,
                                peso ,
                                porto_e_imballo ,
                                mezzo_consegna ,
                                id_payment ,
                                id_causal ,
                                price_tax_included ,
                                price_tax_excluded ,
                                date_add ,
                                date_upd
                )  VALUES  (
                          '11' ,
                          '1105' ,
                          '2024-04-11' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '17.10' ,
                          '17.10' ,
                          NOW() ,
                          NOW() ) 
11/04/2024 10:51:32 am >>  INSERT INTO ps_document_detail_backup
                                ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
                            SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91211' 
11/04/2024 10:51:32 am >>  DELETE FROM ps_document_detail WHERE id_document = '91211' 
11/04/2024 10:51:32 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '91211' , '22075' , 'CRISTO TOTALE - G. MUSICO' , '1' ,  '-1' , '4' ,
                               '18.00' , '18' , '0' , '5' , '17.10' ) 
11/04/2024 11:06:08 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '1106' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-11') 
11/04/2024 11:06:08 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' ,
                          '1106' ,
                          '2024-04-11' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '140.35' ,
                          '135.89' ,
                          NOW() ,
                          NOW() ) 
11/04/2024 11:06: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 = '91212' 
11/04/2024 11:06:08 am >>  DELETE FROM ps_document_detail WHERE id_document = '91212' 
11/04/2024 11:06: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
                            ( '91212' , '11151' , 'LIBRI' , '6' ,  '-6' , '4' ,
                               '10' , '10' , '0' , '0' , '60.00' ) 
11/04/2024 11:06: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
                            ( '91212' , '3073' , 'CROCE PRIMA COMUNIONE - LEGNO SCURO - 713/15' , '10' ,  '-10' , '1' ,
                               '1.30' , '1.0655737704918' , '22' , '0' , '13.00' ) 
11/04/2024 11:06: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
                            ( '91212' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '10' ,  '-10' , '3' ,
                               '3.50' , '3.3653846153846' , '4' , '0' , '35.00' ) 
11/04/2024 11:06: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
                            ( '91212' , '16689' , 'OSTIA PAN DI CENA mm80' , '10' ,  '-10' , '3' ,
                               '2.00' , '1.9230769230769' , '4' , '0' , '20.00' ) 
11/04/2024 11:06: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
                            ( '91212' , '22023' , 'SULLA TUA PAROLA - MAR/APR 2024 - 521' , '1' ,  '-1' , '4' ,
                               '5.00' , '5' , '0' , '5' , '4.75' ) 
11/04/2024 11:06: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
                            ( '91212' , '22308' , 'MESSA MEDITAZIONE - MAG/GIU 2024' , '1' ,  '-1' , '4' ,
                               '8.00' , '8' , '0' , '5' , '7.60' ) 
11/04/2024 11:10:16 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '1107' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-11') 
11/04/2024 11:10:16 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' ,
                          '1107' ,
                          '2024-04-11' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '50.00' ,
                          '40.98' ,
                          NOW() ,
                          NOW() ) 
11/04/2024 11:10:16 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 = '91213' 
11/04/2024 11:10:16 am >>  DELETE FROM ps_document_detail WHERE id_document = '91213' 
11/04/2024 11:10:16 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
                            ( '91213' , '19108' , 'PORTATECA COMPLETA - 947' , '1' ,  '-1' , '1' ,
                               '50' , '40.983606557377' , '22' , '0' , '50.00' ) 
11/04/2024 11:39:35 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '1108' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-11') 
11/04/2024 11:39:35 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' ,
                          '1108' ,
                          '2024-04-11' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '105.00' ,
                          '86.07' ,
                          NOW() ,
                          NOW() ) 
11/04/2024 11:39:35 am >>  INSERT INTO ps_document_detail_backup
                                ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
                            SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91214' 
11/04/2024 11:39:35 am >>  DELETE FROM ps_document_detail WHERE id_document = '91214' 
11/04/2024 11:39:35 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '91214' , '22199' , 'VINO LIQUOROSO ROSSO ' , '12' ,  '-12' , '1' ,
                               '7.5' , '6.1475409836066' , '22' , '0' , '90.00' ) 
11/04/2024 11:39:35 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '91214' , '11626' , 'PURIFICATOIO 28X48 - SERV 1' , '2' ,  '-2' , '1' ,
                               '7.5' , '6.1475409836066' , '22' , '0' , '15.00' ) 
11/04/2024 11:49:23 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' ,
                          '1338654' ,
                          '2024-04-09' ,
                          '' ,
                          '0' ,
                          '177' ,
                          '4679057' ,
                          'VIA G. VERDI 8 20057 ASSAGO' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '72.10' ,
                          '72.10' ,
                          NOW() ,
                          NOW() ) 
11/04/2024 11:49: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 = '91215' 
11/04/2024 11:49:23 am >>  DELETE FROM ps_document_detail WHERE id_document = '91215' 
11/04/2024 11:49: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
                            ( '91215' , '21780' , 'FRATELLINO' , '2' ,  '2' , '4' ,
                               '12.00' , '12' , '0' , '30' , '16.8000' ) 
11/04/2024 11:49:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '21780' AND id_supplier = '177' 
11/04/2024 11:49:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21780' , '177' , '1' ) 
11/04/2024 11:49: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
                            ( '91215' , '22330' , 'LIFE - LA MIA STORIA - PAPA FRANCESCO' , '1' ,  '1' , '4' ,
                               '19.00' , '19' , '0' , '30' , '13.3000' ) 
11/04/2024 11:49:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '22330' AND id_supplier = '177' 
11/04/2024 11:49:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22330' , '177' , '1' ) 
11/04/2024 11:49: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
                            ( '91215' , '21697' , 'ORME SUL CUORE - A. ROMANO' , '5' ,  '5' , '4' ,
                               '12.00' , '12' , '0' , '30' , '42.0000' ) 
11/04/2024 11:49:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '21697' AND id_supplier = '177' 
11/04/2024 11:49:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21697' , '177' , '1' ) 
11/04/2024 11:50:04 am >> UPDATE ps_document SET
                          id_document_type = '33',
                          document_num = '1338654',
                          document_date = '2024-04-09',
                          document_letter = '',
                          id_customer = '0',
                          id_supplier = '',
                          id_address = '4679057',
                          address1 = 'VIA G. VERDI 8 20057 ASSAGO',
                          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 = '103.00',
                          price_tax_excluded = '103.00',
                          date_upd = NOW()
                        WHERE id_document = '91215' 
11/04/2024 11:50:04 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 = '91215' 
11/04/2024 11:50:04 am >>  DELETE FROM ps_document_detail WHERE id_document = '91215' 
11/04/2024 11:50:04 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
                            ( '91215' , '21780' , 'FRATELLINO' , '2' ,  '2' , '4' ,
                               '12.0000' , '12' , '0' , '' , '24.0000' ) 
11/04/2024 11:50:04 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
                            ( '91215' , '22330' , 'LIFE - LA MIA STORIA - PAPA FRANCESCO' , '1' ,  '1' , '4' ,
                               '19.0000' , '19' , '0' , '' , '19.0000' ) 
11/04/2024 11:50:04 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
                            ( '91215' , '21697' , 'ORME SUL CUORE - A. ROMANO' , '5' ,  '5' , '4' ,
                               '12.0000' , '12' , '0' , '' , '60.0000' ) 
11/04/2024 12:02:32 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '1/A' AND id_document != '89846' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-01-08') 
11/04/2024 12:02:32 pm >> UPDATE ps_document SET
                          id_document_type = '24',
                          document_num = '1/A',
                          document_date = '2024-01-08',
                          document_letter = 'A',
                          id_customer = '206',
                          id_supplier = '',
                          id_address = '4671015',
                          address1 = 'VIA N. BUONSERVIZI, 25 84135 SALERNO',
                          address2 = '',
                          note = '',
                          price_shipping = '0.00',
                          id_tax_shipping_rules = '4',
                          colli = '0',
                          peso = '0',
                          porto_e_imballo = '0',
                          mezzo_consegna = '',
                          id_payment = '0',
                          id_causal = '0',
                          price_tax_included = '50.90',
                          price_tax_excluded = '50.90',
                          date_upd = NOW()
                        WHERE id_document = '89846' 
11/04/2024 12:02:32 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 = '89846' 
11/04/2024 12:02:32 pm >>  DELETE FROM ps_document_detail WHERE id_document = '89846' 
11/04/2024 12:02:32 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '89846' , '22341' , 'SULLA TUA PAROLA - MAG/GIU 2024' , '1' ,  '-1' , '4' ,
                               '5.0000' , '5' , '0' , '0' , '5.00' ) 
11/04/2024 12:02:32 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '89846' , '22370' , 'DIGNITAS INFINITA' , '1' ,  '-1' , '4' ,
                               '3.9000' , '3.9' , '0' , '0' , '3.90' ) 
11/04/2024 12:02:32 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '89846' , '13499' , 'VITA CRISTIANA - SANTAGOSTINO - 8742' , '1' ,  '-1' , '4' ,
                               '11.0000' , '11' , '0' , '0' , '11.00' ) 
11/04/2024 12:02:32 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '89846' , '22386' , 'CREDO SPIEGATO AI CRISTIANI UN PO SCETTICI ' , '1' ,  '-1' , '4' ,
                               '15.0000' , '15' , '0' , '0' , '15.00' ) 
11/04/2024 12:02:32 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '89846' , '22402' , 'REGNO DI DIO E UNA SFIDA - F.J. SHEEN' , '1' ,  '-1' , '4' ,
                               '16.00' , '16' , '0' , '0' , '16.00' ) 
11/04/2024 12:04:50 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892243064' AND id_product != '22404' AND ean13 != '' 
11/04/2024 12:04:50 pm >> UPDATE ps_product SET
                  id_supplier = '',
                  reference = '7/7',
                  ean13 = '9788892243064',
                  date_upd = NOW()
                WHERE id_product = '22404' 
11/04/2024 12:04:50 pm >> UPDATE ps_product_lang SET
                  name = 'CINQUE DOMANDE CHE AGITANO LA CHIESA - I. INGRAO',
                  description = ''
                WHERE id_product = '22404' 
11/04/2024 12:04:50 pm >> UPDATE ps_product SET
                  wholesale_price = '0.00',
                  on_sale = '0',
                  price = '16'
                WHERE id_product = '22404' 
11/04/2024 12:04:50 pm >> UPDATE ps_product_shop SET
                  wholesale_price = '0.00',
                  price = '16',
                  id_tax_rules_group = '4',
                  id_category_default = '30',
                  id_argoment_default = '10',
                  id_internal_category = '7',
                  on_sale = '0',
                  on_showcase = '0',
                  on_offer = '00',
                  on_most = '00',
                  date_upd = NOW()
                WHERE id_product = '22404' 
11/04/2024 12:04:50 pm >> DELETE FROM ps_specific_price WHERE id_product = '22404' 
11/04/2024 12:04:52 pm >> 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 = '22404' 
11/04/2024 12:04:52 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22405' , '1' , '' , 'nuovo-prodotto' )
11/04/2024 12:04:52 pm >> 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 '22405' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22404' 
11/04/2024 12:04:52 pm >> INSERT INTO `ps_stock_available` (
                  id_product , id_product_attribute , id_shop , id_shop_group , quantity
                ) SELECT '22405' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22404' 
11/04/2024 12:05:56 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831505383' AND id_product != '22405' AND ean13 != '' 
11/04/2024 12:05:56 pm >> UPDATE ps_product SET
                  id_supplier = '',
                  reference = '14',
                  ean13 = '9788831505383',
                  date_upd = NOW()
                WHERE id_product = '22405' 
11/04/2024 12:05:56 pm >> UPDATE ps_product_lang SET
                  name = 'REDEMPTORIS MATER',
                  description = ''
                WHERE id_product = '22405' 
11/04/2024 12:05:56 pm >> UPDATE ps_product SET
                  wholesale_price = '0.00',
                  on_sale = '0',
                  price = '3.5'
                WHERE id_product = '22405' 
11/04/2024 12:05:56 pm >> UPDATE ps_product_shop SET
                  wholesale_price = '0.00',
                  price = '3.5',
                  id_tax_rules_group = '4',
                  id_category_default = '27',
                  id_argoment_default = '69',
                  id_internal_category = '7',
                  on_sale = '0',
                  on_showcase = '0',
                  on_offer = '00',
                  on_most = '00',
                  date_upd = NOW()
                WHERE id_product = '22405' 
11/04/2024 12:05:56 pm >> DELETE FROM ps_specific_price WHERE id_product = '22405' 
11/04/2024 12:05:57 pm >> 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 = '22405' 
11/04/2024 12:05:57 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22406' , '1' , '' , 'nuovo-prodotto' )
11/04/2024 12:05:57 pm >> 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 '22406' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22405' 
11/04/2024 12:05:57 pm >> INSERT INTO `ps_stock_available` (
                  id_product , id_product_attribute , id_shop , id_shop_group , quantity
                ) SELECT '22406' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22405' 
11/04/2024 12:06:33 pm >> INSERT INTO ps_document (
                                id_document_type ,
                                document_num ,
                                document_date ,
                                document_letter ,
                                id_customer ,
                                id_supplier ,
                                id_address ,
                                address1 ,
                                address2 ,
                                note ,
                                price_shipping ,
                                id_tax_shipping_rules ,
                                colli ,
                                peso ,
                                porto_e_imballo ,
                                mezzo_consegna ,
                                id_payment ,
                                id_causal ,
                                price_tax_included ,
                                price_tax_excluded ,
                                date_add ,
                                date_upd
                )  VALUES  (
                          '33' ,
                          '661579' ,
                          '2024-04-10' ,
                          '' ,
                          '0' ,
                          '7' ,
                          '2602' ,
                          'P. ZZA SAN PAOLO, 14 12051 ALBA' ,
                          '' ,
                          '' ,
                          '4.5' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '109.69' ,
                          '109.69' ,
                          NOW() ,
                          NOW() ) 
11/04/2024 12:06:33 pm >>  INSERT INTO ps_document_detail_backup
                                ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
                            SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91216' 
11/04/2024 12:06:33 pm >>  DELETE FROM ps_document_detail WHERE id_document = '91216' 
11/04/2024 12:06:33 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '91216' , '22403' , 'MIO LIBRO DI PREGHIERE - A. COMASTRI' , '2' ,  '2' , '4' ,
                               '12.00' , '12' , '0' , '33' , '16.0800' ) 
11/04/2024 12:06:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22403' AND id_supplier = '7' 
11/04/2024 12:06:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22403' , '7' , '1' ) 
11/04/2024 12:06:33 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '91216' , '22404' , 'CINQUE DOMANDE CHE AGITANO LA CHIESA - I. INGRAO' , '1' ,  '1' , '4' ,
                               '16.00' , '16' , '0' , '33' , '10.7200' ) 
11/04/2024 12:06:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22404' AND id_supplier = '7' 
11/04/2024 12:06:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22404' , '7' , '1' ) 
11/04/2024 12:06:33 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '91216' , '17529' , 'NUOVO RITO DELLA MESSA' , '2' ,  '2' , '4' ,
                               '1.50' , '1.5' , '0' , '33' , '2.0100' ) 
11/04/2024 12:06:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17529' AND id_supplier = '7' 
11/04/2024 12:06:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17529' , '7' , '1' ) 
11/04/2024 12:06:33 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '91216' , '22405' , 'REDEMPTORIS MATER' , '10' ,  '10' , '4' ,
                               '3.50' , '3.5' , '0' , '33' , '23.4500' ) 
11/04/2024 12:06:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22405' AND id_supplier = '7' 
11/04/2024 12:06:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22405' , '7' , '1' ) 
11/04/2024 12:06:33 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '91216' , '7186' , 'NUOVO TESTAMENTO INTERLINEARE' , '1' ,  '1' , '4' ,
                               '79.00' , '79' , '0' , '33' , '52.9300' ) 
11/04/2024 12:06:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7186' AND id_supplier = '7' 
11/04/2024 12:06:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7186' , '7' , '1' ) 
11/04/2024 12:10:10 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '1109' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-11') 
11/04/2024 12:10:10 pm >> INSERT INTO ps_document (
                                id_document_type ,
                                document_num ,
                                document_date ,
                                document_letter ,
                                id_customer ,
                                id_supplier ,
                                id_address ,
                                address1 ,
                                address2 ,
                                note ,
                                price_shipping ,
                                id_tax_shipping_rules ,
                                colli ,
                                peso ,
                                porto_e_imballo ,
                                mezzo_consegna ,
                                id_payment ,
                                id_causal ,
                                price_tax_included ,
                                price_tax_excluded ,
                                date_add ,
                                date_upd
                )  VALUES  (
                          '11' ,
                          '1109' ,
                          '2024-04-11' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '11.40' ,
                          '11.40' ,
                          NOW() ,
                          NOW() ) 
11/04/2024 12:10:10 pm >>  INSERT INTO ps_document_detail_backup
                                ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
                            SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91217' 
11/04/2024 12:10:10 pm >>  DELETE FROM ps_document_detail WHERE id_document = '91217' 
11/04/2024 12:10:10 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '91217' , '21780' , 'FRATELLINO' , '1' ,  '-1' , '4' ,
                               '12.00' , '12' , '0' , '5' , '11.40' ) 
11/04/2024 12:23:04 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788826608921' AND id_product != '22406' AND ean13 != '' 
11/04/2024 12:23:04 pm >> UPDATE ps_product SET
                  id_supplier = '',
                  reference = '13/3',
                  ean13 = '9788826608921',
                  date_upd = NOW()
                WHERE id_product = '22406' 
11/04/2024 12:23:04 pm >> UPDATE ps_product_lang SET
                  name = 'GESU\' CONFIDO IN TE',
                  description = ''
                WHERE id_product = '22406' 
11/04/2024 12:23:04 pm >> UPDATE ps_product SET
                  wholesale_price = '0.00',
                  on_sale = '0',
                  price = '3'
                WHERE id_product = '22406' 
11/04/2024 12:23:04 pm >> UPDATE ps_product_shop SET
                  wholesale_price = '0.00',
                  price = '3',
                  id_tax_rules_group = '4',
                  id_category_default = '104',
                  id_argoment_default = '28',
                  id_internal_category = '7',
                  on_sale = '0',
                  on_showcase = '0',
                  on_offer = '00',
                  on_most = '00',
                  date_upd = NOW()
                WHERE id_product = '22406' 
11/04/2024 12:23:04 pm >> DELETE FROM ps_specific_price WHERE id_product = '22406' 
11/04/2024 12:23:05 pm >> 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 = '22406' 
11/04/2024 12:23:05 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22407' , '1' , '' , 'nuovo-prodotto' )
11/04/2024 12:23:05 pm >> 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 '22407' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22406' 
11/04/2024 12:23:05 pm >> INSERT INTO `ps_stock_available` (
                  id_product , id_product_attribute , id_shop , id_shop_group , quantity
                ) SELECT '22407' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22406' 
11/04/2024 12:23:39 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '1110' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-11') 
11/04/2024 12:23:39 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' ,
                          '1110' ,
                          '2024-04-11' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '3.00' ,
                          '3.00' ,
                          NOW() ,
                          NOW() ) 
11/04/2024 12:23:39 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 = '91218' 
11/04/2024 12:23:39 pm >>  DELETE FROM ps_document_detail WHERE id_document = '91218' 
11/04/2024 12:23:39 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '91218' , '22406' , 'GESU CONFIDO IN TE' , '1' ,  '-1' , '4' ,
                               '3.00' , '3' , '0' , '0' , '3.00' ) 
11/04/2024 12:25:42 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788820980306' AND id_product != '22407' AND ean13 != '' 
11/04/2024 12:25:42 pm >> UPDATE ps_product SET
                  id_supplier = '',
                  reference = '',
                  ean13 = '9788820980306',
                  date_upd = NOW()
                WHERE id_product = '22407' 
11/04/2024 12:25:42 pm >> UPDATE ps_product_lang SET
                  name = 'CAMMINO DI SANTITA\' DI DON M. SOLOCKO',
                  description = ''
                WHERE id_product = '22407' 
11/04/2024 12:25:42 pm >> UPDATE ps_product SET
                  wholesale_price = '0.00',
                  on_sale = '0',
                  price = '6'
                WHERE id_product = '22407' 
11/04/2024 12:25:42 pm >> UPDATE ps_product_shop SET
                  wholesale_price = '0.00',
                  price = '6',
                  id_tax_rules_group = '4',
                  id_category_default = '104',
                  id_argoment_default = '28',
                  id_internal_category = '7',
                  on_sale = '0',
                  on_showcase = '0',
                  on_offer = '00',
                  on_most = '00',
                  date_upd = NOW()
                WHERE id_product = '22407' 
11/04/2024 12:25:42 pm >> DELETE FROM ps_specific_price WHERE id_product = '22407' 
11/04/2024 12:25:44 pm >> 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 = '22407' 
11/04/2024 12:25:44 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22408' , '1' , '' , 'nuovo-prodotto' )
11/04/2024 12:25:44 pm >> 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 '22408' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22407' 
11/04/2024 12:25:44 pm >> INSERT INTO `ps_stock_available` (
                  id_product , id_product_attribute , id_shop , id_shop_group , quantity
                ) SELECT '22408' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22407' 
11/04/2024 12:26:05 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' ,
                          '2024-DL001228' ,
                          '2024-04-10' ,
                          '' ,
                          '0' ,
                          '79' ,
                          '2686' ,
                          'CITTA\\\' DEL VATICANO 00120 CITTA\\\' DEL VATICANO' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '98.08' ,
                          '98.08' ,
                          NOW() ,
                          NOW() ) 
11/04/2024 12:26:05 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 = '91219' 
11/04/2024 12:26:05 pm >>  DELETE FROM ps_document_detail WHERE id_document = '91219' 
11/04/2024 12:26:05 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '91219' , '22406' , 'GESU CONFIDO IN TE' , '5' ,  '5' , '4' ,
                               '3.00' , '3' , '0' , '45' , '8.2500' ) 
11/04/2024 12:26:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22406' AND id_supplier = '79' 
11/04/2024 12:26:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22406' , '79' , '1' ) 
11/04/2024 12:26:05 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '91219' , '22111' , 'PREGARE OGGI' , '3' ,  '3' , '4' ,
                               '8.50' , '8.5' , '0' , '45' , '14.0250' ) 
11/04/2024 12:26:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22111' AND id_supplier = '79' 
11/04/2024 12:26:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22111' , '79' , '1' ) 
11/04/2024 12:26:05 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '91219' , '22191' , 'PREGARE CON I SALMI' , '3' ,  '3' , '4' ,
                               '8.50' , '8.5' , '0' , '45' , '14.0250' ) 
11/04/2024 12:26:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22191' AND id_supplier = '79' 
11/04/2024 12:26:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22191' , '79' , '1' ) 
11/04/2024 12:26:05 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '91219' , '22370' , 'DIGNITAS INFINITA' , '5' ,  '5' , '4' ,
                               '3.90' , '3.9' , '0' , '45' , '10.7250' ) 
11/04/2024 12:26:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22370' AND id_supplier = '79' 
11/04/2024 12:26:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22370' , '79' , '1' ) 
11/04/2024 12:26:05 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '91219' , '3544' , 'DIRETTORIO OMILETICO' , '1' ,  '1' , '4' ,
                               '10.00' , '10' , '0' , '45' , '5.5000' ) 
11/04/2024 12:26:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '3544' AND id_supplier = '79' 
11/04/2024 12:26:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3544' , '79' , '1' ) 
11/04/2024 12:26:05 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '91219' , '22407' , 'CAMMINO DI SANTITA DI DON M. SOLOCKO' , '1' ,  '1' , '4' ,
                               '6.00' , '6' , '0' , '45' , '3.3000' ) 
11/04/2024 12:26:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22407' AND id_supplier = '79' 
11/04/2024 12:26:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22407' , '79' , '1' ) 
11/04/2024 12:26:05 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '91219' , '22149' , 'LEZIONARIO FERIALE TEMPI FORTI - N.E.' , '1' ,  '1' , '4' ,
                               '65.00' , '65' , '0' , '35' , '42.2500' ) 
11/04/2024 12:26:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22149' AND id_supplier = '79' 
11/04/2024 12:26:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22149' , '79' , '1' ) 
11/04/2024 12:40:29 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '71' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-04-11') 
11/04/2024 12:40: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' ,
                          '71' ,
                          '2024-04-11' ,
                          '' ,
                          '3980' ,
                          '0' ,
                          '4677356' ,
                          'P. ZZA RISORGIMENTO 1 80047 S. GIUSEPPE VESUVIANO' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '9' ,
                          '0' ,
                          '114.00' ,
                          '93.44' ,
                          NOW() ,
                          NOW() ) 
11/04/2024 12:40: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 = '91220' 
11/04/2024 12:40:29 pm >>  DELETE FROM ps_document_detail WHERE id_document = '91220' 
11/04/2024 12:40: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
                            ( '91220' , '12815' , 'LIBRO DEI CRESIMATI' , '3' ,  '-3' , '1' ,
                               '40.00' , '32.786885245902' , '22' , '5' , '114.00' ) 
11/04/2024 12:51:51 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400236408' AND id_product != '17275' AND ean13 != '' 
11/04/2024 12:51:51 pm >> UPDATE ps_product SET
                  id_supplier = '28',
                  reference = '',
                  ean13 = '8058400236408',
                  date_upd = NOW()
                WHERE id_product = '17275' 
11/04/2024 12:51:51 pm >> UPDATE ps_product_lang SET
                  name = 'TELA 18X25- 2963',
                  description = ''
                WHERE id_product = '17275' 
11/04/2024 12:51:51 pm >> UPDATE ps_product SET
                  wholesale_price = '3.41',
                  on_sale = '0',
                  price = '8.19672131147541'
                WHERE id_product = '17275' 
11/04/2024 12:51:51 pm >> UPDATE ps_product_shop SET
                  wholesale_price = '3.41',
                  price = '8.19672131147541',
                  id_tax_rules_group = '1',
                  id_category_default = '95',
                  id_argoment_default = '42',
                  id_internal_category = '3',
                  on_sale = '0',
                  on_showcase = '0',
                  on_offer = '00',
                  on_most = '00',
                  date_upd = NOW()
                WHERE id_product = '17275' 
11/04/2024 12:51:51 pm >> DELETE FROM ps_specific_price WHERE id_product = '17275' 
11/04/2024 12:52:50 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400276565' AND id_product != '16983' AND ean13 != '' 
11/04/2024 12:52:50 pm >> UPDATE ps_product SET
                  id_supplier = '28',
                  reference = '',
                  ean13 = '8058400276565',
                  date_upd = NOW()
                WHERE id_product = '16983' 
11/04/2024 12:52:50 pm >> UPDATE ps_product_lang SET
                  name = 'TELA 18X25 - SACRO CUORE',
                  description = ''
                WHERE id_product = '16983' 
11/04/2024 12:52:50 pm >> UPDATE ps_product SET
                  wholesale_price = '3.00',
                  on_sale = '0',
                  price = '8.19672131147541'
                WHERE id_product = '16983' 
11/04/2024 12:52:50 pm >> UPDATE ps_product_shop SET
                  wholesale_price = '3.00',
                  price = '8.19672131147541',
                  id_tax_rules_group = '1',
                  id_category_default = '95',
                  id_argoment_default = '42',
                  id_internal_category = '3',
                  on_sale = '0',
                  on_showcase = '0',
                  on_offer = '00',
                  on_most = '00',
                  date_upd = NOW()
                WHERE id_product = '16983' 
11/04/2024 12:52:50 pm >> DELETE FROM ps_specific_price WHERE id_product = '16983' 
11/04/2024 12:53:09 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400276565' AND id_product != '16983' AND ean13 != '' 
11/04/2024 12:53:09 pm >> UPDATE ps_product SET
                  id_supplier = '28',
                  reference = '',
                  ean13 = '8058400276565',
                  date_upd = NOW()
                WHERE id_product = '16983' 
11/04/2024 12:53:10 pm >> UPDATE ps_product_lang SET
                  name = 'TELA 18X25 - SACRO CUORE',
                  description = ''
                WHERE id_product = '16983' 
11/04/2024 12:53:10 pm >> UPDATE ps_product SET
                  wholesale_price = '3.00',
                  on_sale = '0',
                  price = '7.786885245901639'
                WHERE id_product = '16983' 
11/04/2024 12:53:10 pm >> UPDATE ps_product_shop SET
                  wholesale_price = '3.00',
                  price = '7.786885245901639',
                  id_tax_rules_group = '1',
                  id_category_default = '95',
                  id_argoment_default = '42',
                  id_internal_category = '3',
                  on_sale = '0',
                  on_showcase = '0',
                  on_offer = '00',
                  on_most = '00',
                  date_upd = NOW()
                WHERE id_product = '16983' 
11/04/2024 12:53:10 pm >> DELETE FROM ps_specific_price WHERE id_product = '16983' 
11/04/2024 12:54:24 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000173' AND id_product != '3144' AND ean13 != '' 
11/04/2024 12:54:24 pm >> UPDATE ps_product SET
                  id_supplier = '',
                  reference = '2013',
                  ean13 = '000173',
                  date_upd = NOW()
                WHERE id_product = '3144' 
11/04/2024 12:54:24 pm >> UPDATE ps_product_lang SET
                  name = 'CROCE TRILOBATA ',
                  description = ''
                WHERE id_product = '3144' 
11/04/2024 12:54:24 pm >> UPDATE ps_product SET
                  wholesale_price = '0.95',
                  on_sale = '0',
                  price = '3.6885245901639343'
                WHERE id_product = '3144' 
11/04/2024 12:54:24 pm >> UPDATE ps_product_shop SET
                  wholesale_price = '0.95',
                  price = '3.6885245901639343',
                  id_tax_rules_group = '1',
                  id_category_default = '95',
                  id_argoment_default = '42',
                  id_internal_category = '3',
                  on_sale = '0',
                  on_showcase = '0',
                  on_offer = '00',
                  on_most = '00',
                  date_upd = NOW()
                WHERE id_product = '3144' 
11/04/2024 12:54:24 pm >> DELETE FROM ps_specific_price WHERE id_product = '3144' 
11/04/2024 12:58:44 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400312232' AND id_product != '19315' AND ean13 != '' 
11/04/2024 12:58:44 pm >> UPDATE ps_product SET
                  id_supplier = '28',
                  reference = '',
                  ean13 = '8058400312232',
                  date_upd = NOW()
                WHERE id_product = '19315' 
11/04/2024 12:58:44 pm >> UPDATE ps_product_lang SET
                  name = 'SCATOLINA METALLO CON CORONCINA COMUNIONE - 1016/K209',
                  description = ''
                WHERE id_product = '19315' 
11/04/2024 12:58:44 pm >> UPDATE ps_product SET
                  wholesale_price = '1.13',
                  on_sale = '0',
                  price = '2.6229508196721314'
                WHERE id_product = '19315' 
11/04/2024 12:58:44 pm >> UPDATE ps_product_shop SET
                  wholesale_price = '1.13',
                  price = '2.6229508196721314',
                  id_tax_rules_group = '1',
                  id_category_default = '95',
                  id_argoment_default = '42',
                  id_internal_category = '3',
                  on_sale = '0',
                  on_showcase = '0',
                  on_offer = '00',
                  on_most = '00',
                  date_upd = NOW()
                WHERE id_product = '19315' 
11/04/2024 12:58:44 pm >> DELETE FROM ps_specific_price WHERE id_product = '19315' 
11/04/2024 01:02:01 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400318128' AND id_product != '22408' AND ean13 != '' 
11/04/2024 01:02:02 pm >> UPDATE ps_product SET
                  id_supplier = '',
                  reference = '',
                  ean13 = '8058400318128',
                  date_upd = NOW()
                WHERE id_product = '22408' 
11/04/2024 01:02:02 pm >> UPDATE ps_product_lang SET
                  name = 'PASTRELLA CRESIMA',
                  description = ''
                WHERE id_product = '22408' 
11/04/2024 01:02:02 pm >> UPDATE ps_product SET
                  wholesale_price = '0.00',
                  on_sale = '0',
                  price = '7.377049180327869'
                WHERE id_product = '22408' 
11/04/2024 01:02:02 pm >> UPDATE ps_product_shop SET
                  wholesale_price = '0.00',
                  price = '7.377049180327869',
                  id_tax_rules_group = '1',
                  id_category_default = '95',
                  id_argoment_default = '42',
                  id_internal_category = '3',
                  on_sale = '0',
                  on_showcase = '0',
                  on_offer = '00',
                  on_most = '00',
                  date_upd = NOW()
                WHERE id_product = '22408' 
11/04/2024 01:02:02 pm >> DELETE FROM ps_specific_price WHERE id_product = '22408' 
11/04/2024 01:02:02 pm >> 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 = '22408' 
11/04/2024 01:02:03 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22409' , '1' , '' , 'nuovo-prodotto' )
11/04/2024 01:02:03 pm >> 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 '22409' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22408' 
11/04/2024 01:02:03 pm >> INSERT INTO `ps_stock_available` (
                  id_product , id_product_attribute , id_shop , id_shop_group , quantity
                ) SELECT '22409' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22408' 
11/04/2024 01:03:04 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400318128' AND id_product != '22408' AND ean13 != '' 
11/04/2024 01:03:04 pm >> UPDATE ps_product SET
                  id_supplier = '',
                  reference = '',
                  ean13 = '8058400318128',
                  date_upd = NOW()
                WHERE id_product = '22408' 
11/04/2024 01:03:04 pm >> UPDATE ps_product_lang SET
                  name = 'PASTRELLA CRESIMA - 1302/K178',
                  description = ''
                WHERE id_product = '22408' 
11/04/2024 01:03:04 pm >> UPDATE ps_product SET
                  wholesale_price = '0.00',
                  on_sale = '0',
                  price = '7.3770'
                WHERE id_product = '22408' 
11/04/2024 01:03:04 pm >> UPDATE ps_product_shop SET
                  wholesale_price = '0.00',
                  price = '7.3770',
                  id_tax_rules_group = '1',
                  id_category_default = '95',
                  id_argoment_default = '42',
                  id_internal_category = '3',
                  on_sale = '0',
                  on_showcase = '0',
                  on_offer = '00',
                  on_most = '00',
                  date_upd = NOW()
                WHERE id_product = '22408' 
11/04/2024 01:03:04 pm >> DELETE FROM ps_specific_price WHERE id_product = '22408' 
11/04/2024 01:03:48 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400318111' AND id_product != '22409' AND ean13 != '' 
11/04/2024 01:03:48 pm >> UPDATE ps_product SET
                  id_supplier = '',
                  reference = '',
                  ean13 = '8058400318111',
                  date_upd = NOW()
                WHERE id_product = '22409' 
11/04/2024 01:03:48 pm >> UPDATE ps_product_lang SET
                  name = 'PIASTRELLA COMUNIONE - 1302/K212',
                  description = ''
                WHERE id_product = '22409' 
11/04/2024 01:03:48 pm >> UPDATE ps_product SET
                  wholesale_price = '0.00',
                  on_sale = '0',
                  price = '7.377049180327869'
                WHERE id_product = '22409' 
11/04/2024 01:03:48 pm >> UPDATE ps_product_shop SET
                  wholesale_price = '0.00',
                  price = '7.377049180327869',
                  id_tax_rules_group = '1',
                  id_category_default = '95',
                  id_argoment_default = '42',
                  id_internal_category = '3',
                  on_sale = '0',
                  on_showcase = '0',
                  on_offer = '00',
                  on_most = '00',
                  date_upd = NOW()
                WHERE id_product = '22409' 
11/04/2024 01:03:48 pm >> DELETE FROM ps_specific_price WHERE id_product = '22409' 
11/04/2024 01:03:49 pm >> 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 = '22409' 
11/04/2024 01:03:49 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22410' , '1' , '' , 'nuovo-prodotto' )
11/04/2024 01:03:49 pm >> 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 '22410' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22409' 
11/04/2024 01:03:49 pm >> INSERT INTO `ps_stock_available` (
                  id_product , id_product_attribute , id_shop , id_shop_group , quantity
                ) SELECT '22410' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22409' 
11/04/2024 01:05:09 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400291230' AND id_product != '22410' AND ean13 != '' 
11/04/2024 01:05:09 pm >> UPDATE ps_product SET
                  id_supplier = '',
                  reference = '',
                  ean13 = '8058400291230',
                  date_upd = NOW()
                WHERE id_product = '22410' 
11/04/2024 01:05:09 pm >> UPDATE ps_product_lang SET
                  name = 'CONFEZIONE COLLANINA PADRE NOSTRO - 4300-T07',
                  description = ''
                WHERE id_product = '22410' 
11/04/2024 01:05:09 pm >> UPDATE ps_product SET
                  wholesale_price = '0.00',
                  on_sale = '0',
                  price = '2.1311475409836067'
                WHERE id_product = '22410' 
11/04/2024 01:05:09 pm >> UPDATE ps_product_shop SET
                  wholesale_price = '0.00',
                  price = '2.1311475409836067',
                  id_tax_rules_group = '1',
                  id_category_default = '95',
                  id_argoment_default = '42',
                  id_internal_category = '3',
                  on_sale = '0',
                  on_showcase = '0',
                  on_offer = '00',
                  on_most = '00',
                  date_upd = NOW()
                WHERE id_product = '22410' 
11/04/2024 01:05:09 pm >> DELETE FROM ps_specific_price WHERE id_product = '22410' 
11/04/2024 01:05:10 pm >> 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 = '22410' 
11/04/2024 01:05:10 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22411' , '1' , '' , 'nuovo-prodotto' )
11/04/2024 01:05:10 pm >> 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 '22411' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22410' 
11/04/2024 01:05:10 pm >> INSERT INTO `ps_stock_available` (
                  id_product , id_product_attribute , id_shop , id_shop_group , quantity
                ) SELECT '22411' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22410' 
11/04/2024 01:10: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  (
                          '31' ,
                          'A1523' ,
                          '2024-04-10' ,
                          '' ,
                          '0' ,
                          '28' ,
                          '2623' ,
                          'VIA DEI MILLE 59 80121 NAPOLI' ,
                          '' ,
                          '' ,
                          '12' ,
                          '1' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '9' ,
                          '0' ,
                          '460.49' ,
                          '377.45' ,
                          NOW() ,
                          NOW() ) 
11/04/2024 01:10: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 = '91221' 
11/04/2024 01:10:26 pm >>  DELETE FROM ps_document_detail WHERE id_document = '91221' 
11/04/2024 01:10: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
                            ( '91221' , '16983' , 'TELA 18X25 - SACRO CUORE' , '1' ,  '1' , '1' ,
                               '3.75' , '3.0737704918033' , '22' , '0' , '4.5750' ) 
11/04/2024 01:10:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16983' AND id_supplier = '28' 
11/04/2024 01:10:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16983' , '28' , '1' ) 
11/04/2024 01:10: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
                            ( '91221' , '3144' , 'CROCE TRILOBATA ' , '50' ,  '50' , '1' ,
                               '1.79' , '1.4672131147541' , '22' , '0' , '109.1900' ) 
11/04/2024 01:10:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '3144' AND id_supplier = '28' 
11/04/2024 01:10:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3144' , '28' , '1' ) 
11/04/2024 01:10: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
                            ( '91221' , '17277' , 'BRACCIALE PIETRE DURE - 4633' , '30' ,  '30' , '1' ,
                               '2.5' , '2.0491803278689' , '22' , '0' , '91.5000' ) 
11/04/2024 01:10:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17277' AND id_supplier = '28' 
11/04/2024 01:10:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17277' , '28' , '1' ) 
11/04/2024 01:10: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
                            ( '91221' , '21096' , 'CROCE REMOVIBILE EFFETTO PIETRA - 3873' , '4' ,  '4' , '1' ,
                               '4.53' , '3.7131147540984' , '22' , '0' , '22.1064' ) 
11/04/2024 01:10:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21096' AND id_supplier = '28' 
11/04/2024 01:10:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21096' , '28' , '1' ) 
11/04/2024 01:10:27 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '91221' , '19315' , 'SCATOLINA METALLO CON CORONCINA COMUNIONE - 1016/K209' , '50' ,  '50' , '1' ,
                               '1.19' , '0.97540983606557' , '22' , '0' , '72.5900' ) 
11/04/2024 01:10:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19315' AND id_supplier = '28' 
11/04/2024 01:10:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19315' , '28' , '1' ) 
11/04/2024 01:10:27 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '91221' , '22408' , 'PASTRELLA CRESIMA' , '1' ,  '1' , '1' ,
                               '3.29' , '2.6967213114754' , '22' , '0' , '4.0138' ) 
11/04/2024 01:10:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22408' AND id_supplier = '28' 
11/04/2024 01:10:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22408' , '28' , '1' ) 
11/04/2024 01:10:27 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '91221' , '22409' , 'PIASTRELLA COMUNIONE - 1302/K212' , '1' ,  '1' , '1' ,
                               '3.29' , '2.6967213114754' , '22' , '0' , '4.0138' ) 
11/04/2024 01:10:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22409' AND id_supplier = '28' 
11/04/2024 01:10:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22409' , '28' , '1' ) 
11/04/2024 01:10:27 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '91221' , '22410' , 'CONFEZIONE COLLANINA PADRE NOSTRO - 4300-T07' , '50' ,  '50' , '1' ,
                               '1' , '0.81967213114754' , '22' , '0' , '61.0000' ) 
11/04/2024 01:10:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22410' AND id_supplier = '28' 
11/04/2024 01:10:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22410' , '28' , '1' ) 
11/04/2024 01:10:27 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '91221' , '22198' , 'CORONCINA PRIMA COMUNIONE - 3313' , '20' ,  '20' , '1' ,
                               '3.15' , '2.5819672131148' , '22' , '0' , '76.8600' ) 
11/04/2024 01:10:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22198' AND id_supplier = '28' 
11/04/2024 01:10:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22198' , '28' , '1' ) 
11/04/2024 03:21:40 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '1111' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-11') 
11/04/2024 03:21:40 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' ,
                          '1111' ,
                          '2024-04-11' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '89.00' ,
                          '72.95' ,
                          NOW() ,
                          NOW() ) 
11/04/2024 03:21: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 = '91222' 
11/04/2024 03:21:40 pm >>  DELETE FROM ps_document_detail WHERE id_document = '91222' 
11/04/2024 03:21: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
                            ( '91222' , '7202' , 'ARTICOLI RELIGIOSI' , '1' ,  '-1' , '1' ,
                               '45' , '36.885245901639' , '22' , '0' , '45.00' ) 
11/04/2024 03:21: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
                            ( '91222' , '17533' , 'CINGOLO ORO/COL - CING06' , '1' ,  '-1' , '1' ,
                               '19.00' , '15.573770491803' , '22' , '0' , '19.00' ) 
11/04/2024 03:21: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
                            ( '91222' , '7202' , 'ARTICOLI RELIGIOSI' , '1' ,  '-1' , '1' ,
                               '19' , '15.573770491803' , '22' , '0' , '19.00' ) 
11/04/2024 03:21: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
                            ( '91222' , '7202' , 'ARTICOLI RELIGIOSI' , '1' ,  '-1' , '1' ,
                               '6' , '4.9180327868852' , '22' , '0' , '6.00' ) 
11/04/2024 03:30:43 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '1112' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-11') 
11/04/2024 03:30:43 pm >> INSERT INTO ps_document (
                                id_document_type ,
                                document_num ,
                                document_date ,
                                document_letter ,
                                id_customer ,
                                id_supplier ,
                                id_address ,
                                address1 ,
                                address2 ,
                                note ,
                                price_shipping ,
                                id_tax_shipping_rules ,
                                colli ,
                                peso ,
                                porto_e_imballo ,
                                mezzo_consegna ,
                                id_payment ,
                                id_causal ,
                                price_tax_included ,
                                price_tax_excluded ,
                                date_add ,
                                date_upd
                )  VALUES  (
                          '11' ,
                          '1112' ,
                          '2024-04-11' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '2.10' ,
                          '2.10' ,
                          NOW() ,
                          NOW() ) 
11/04/2024 03:30:43 pm >>  INSERT INTO ps_document_detail_backup
                                ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
                            SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91223' 
11/04/2024 03:30:43 pm >>  DELETE FROM ps_document_detail WHERE id_document = '91223' 
11/04/2024 03:30:43 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '91223' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '3' ,  '-3' , '4' ,
                               '0.70' , '0.7' , '0' , '0' , '2.10' ) 
11/04/2024 03:37:28 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '1113' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-11') 
11/04/2024 03:37: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' ,
                          '1113' ,
                          '2024-04-11' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '3.90' ,
                          '3.90' ,
                          NOW() ,
                          NOW() ) 
11/04/2024 03:37: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 = '91224' 
11/04/2024 03:37:28 pm >>  DELETE FROM ps_document_detail WHERE id_document = '91224' 
11/04/2024 03:37: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
                            ( '91224' , '22370' , 'DIGNITAS INFINITA' , '1' ,  '-1' , '4' ,
                               '3.90' , '3.9' , '0' , '0' , '3.90' ) 
11/04/2024 04:17:21 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '1106' AND id_document != '91212' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-11') 
11/04/2024 04:17:21 pm >> UPDATE ps_document SET
                          id_document_type = '11',
                          document_num = '1106',
                          document_date = '2024-04-11',
                          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.35',
                          price_tax_excluded = '135.89',
                          date_upd = NOW()
                        WHERE id_document = '91212' 
11/04/2024 04:17: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 = '91212' 
11/04/2024 04:17:21 pm >>  DELETE FROM ps_document_detail WHERE id_document = '91212' 
11/04/2024 04:17: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
                            ( '91212' , '11151' , 'LIBRI' , '6' ,  '-6' , '4' ,
                               '10.0000' , '10' , '0' , '0' , '60.00' ) 
11/04/2024 04:17: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
                            ( '91212' , '20516' , 'CROCE COMUNIONE - 42/08' , '10' ,  '-10' , '1' ,
                               '1.3' , '1.0655737704918' , '22' , '0' , '13.00' ) 
11/04/2024 04:17: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
                            ( '91212' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '10' ,  '-10' , '3' ,
                               '3.5000' , '3.3653846153846' , '4' , '0' , '35.00' ) 
11/04/2024 04:17: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
                            ( '91212' , '16689' , 'OSTIA PAN DI CENA mm80' , '10' ,  '-10' , '3' ,
                               '2.0000' , '1.9230769230769' , '4' , '0' , '20.00' ) 
11/04/2024 04:17: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
                            ( '91212' , '22023' , 'SULLA TUA PAROLA - MAR/APR 2024 - 521' , '1' ,  '-1' , '4' ,
                               '5.0000' , '5' , '0' , '5' , '4.75' ) 
11/04/2024 04:17: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
                            ( '91212' , '22308' , 'MESSA MEDITAZIONE - MAG/GIU 2024' , '1' ,  '-1' , '4' ,
                               '8.0000' , '8' , '0' , '5' , '7.60' ) 
11/04/2024 04:32:59 pm >> DELETE FROM ps_document WHERE id_document = '89735' 
11/04/2024 04:32:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '89735' 
11/04/2024 04:33:54 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '72' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-04-11') 
11/04/2024 04:33:54 pm >> INSERT INTO ps_document (
                                id_document_type ,
                                document_num ,
                                document_date ,
                                document_letter ,
                                id_customer ,
                                id_supplier ,
                                id_address ,
                                address1 ,
                                address2 ,
                                note ,
                                price_shipping ,
                                id_tax_shipping_rules ,
                                colli ,
                                peso ,
                                porto_e_imballo ,
                                mezzo_consegna ,
                                id_payment ,
                                id_causal ,
                                price_tax_included ,
                                price_tax_excluded ,
                                date_add ,
                                date_upd
                )  VALUES  (
                          '21' ,
                          '72' ,
                          '2024-04-11' ,
                          '' ,
                          '161' ,
                          '0' ,
                          '4679291' ,
                          'VIA G. MAZZINI VICO III, 8 81047 MACERATA CAMPANIA' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '3' ,
                          '0' ,
                          '184.30' ,
                          '184.30' ,
                          NOW() ,
                          NOW() ) 
11/04/2024 04:33:54 pm >>  INSERT INTO ps_document_detail_backup
                                ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
                            SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91225' 
11/04/2024 04:33:54 pm >>  DELETE FROM ps_document_detail WHERE id_document = '91225' 
11/04/2024 04:33:54 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '91225' , '21697' , 'ORME SUL CUORE - A. ROMANO' , '7' ,  '-7' , '4' ,
                               '12.00' , '12' , '0' , '5' , '79.80' ) 
11/04/2024 04:33:54 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '91225' , '22374' , 'MOGOL' , '1' ,  '-1' , '4' ,
                               '20.00' , '20' , '0' , '5' , '19.00' ) 
11/04/2024 04:33:54 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '91225' , '21847' , 'UNDICESIMO: SALVA LA TESTA! - P. PELLEGRINO' , '30' ,  '-30' , '4' ,
                               '3.00' , '3' , '0' , '5' , '85.50' ) 
11/04/2024 05:05:07 pm >> DELETE FROM ps_document WHERE id_document = '91225' 
11/04/2024 05:05:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '91225' 
11/04/2024 06:17:12 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '1114' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-11') 
11/04/2024 06:17:12 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' ,
                          '1114' ,
                          '2024-04-11' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '45.00' ,
                          '45.00' ,
                          NOW() ,
                          NOW() ) 
11/04/2024 06:17:12 pm >>  INSERT INTO ps_document_detail_backup
                                ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
                            SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91226' 
11/04/2024 06:17:12 pm >>  DELETE FROM ps_document_detail WHERE id_document = '91226' 
11/04/2024 06:17:12 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '91226' , '11151' , 'LIBRI' , '1' ,  '-1' , '4' ,
                               '45' , '45' , '0' , '0' , '45.00' ) 
11/04/2024 06:36:30 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '1115' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-11') 
11/04/2024 06:36: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' ,
                          '1115' ,
                          '2024-04-11' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '10.90' ,
                          '9.22' ,
                          NOW() ,
                          NOW() ) 
11/04/2024 06:36: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 = '91227' 
11/04/2024 06:36:30 pm >>  DELETE FROM ps_document_detail WHERE id_document = '91227' 
11/04/2024 06:36: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
                            ( '91227' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' ,  '-1' , '1' ,
                               '8.90' , '7.2950819672131' , '22' , '0' , '8.90' ) 
11/04/2024 06:36: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
                            ( '91227' , '7311' , 'OSTIA SOTTILE 74MM' , '1' ,  '-1' , '3' ,
                               '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 
11/04/2024 06:41:51 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '1116' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-11') 
11/04/2024 06:41:51 pm >> INSERT INTO ps_document (
                                id_document_type ,
                                document_num ,
                                document_date ,
                                document_letter ,
                                id_customer ,
                                id_supplier ,
                                id_address ,
                                address1 ,
                                address2 ,
                                note ,
                                price_shipping ,
                                id_tax_shipping_rules ,
                                colli ,
                                peso ,
                                porto_e_imballo ,
                                mezzo_consegna ,
                                id_payment ,
                                id_causal ,
                                price_tax_included ,
                                price_tax_excluded ,
                                date_add ,
                                date_upd
                )  VALUES  (
                          '11' ,
                          '1116' ,
                          '2024-04-11' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '1.20' ,
                          '0.98' ,
                          NOW() ,
                          NOW() ) 
11/04/2024 06:41:51 pm >>  INSERT INTO ps_document_detail_backup
                                ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
                            SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91228' 
11/04/2024 06:41:51 pm >>  DELETE FROM ps_document_detail WHERE id_document = '91228' 
11/04/2024 06:41:51 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '91228' , '20516' , 'CROCE COMUNIONE - 42/08' , '1' ,  '-1' , '1' ,
                               '1.20' , '0.98360655737705' , '22' , '0' , '1.20' ) 
11/04/2024 07:15:05 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '1117' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-11') 
11/04/2024 07:15:05 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' ,
                          '1117' ,
                          '2024-04-11' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '15.80' ,
                          '12.95' ,
                          NOW() ,
                          NOW() ) 
11/04/2024 07:15:05 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 = '91229' 
11/04/2024 07:15:05 pm >>  DELETE FROM ps_document_detail WHERE id_document = '91229' 
11/04/2024 07:15:05 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '91229' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '2' ,  '-2' , '1' ,
                               '7.90' , '6.4754098360656' , '22' , '0' , '15.80' ) 
11/04/2024 07:23:45 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '1118' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-11') 
11/04/2024 07:23:45 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' ,
                          '1118' ,
                          '2024-04-11' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '5.70' ,
                          '5.70' ,
                          NOW() ,
                          NOW() ) 
11/04/2024 07:23: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 = '91230' 
11/04/2024 07:23:45 pm >>  DELETE FROM ps_document_detail WHERE id_document = '91230' 
11/04/2024 07:23: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
                            ( '91230' , '22181' , 'MESSALINO QUOTIDIANO - MAG/GIU/LUG 2024' , '1' ,  '-1' , '4' ,
                               '6.00' , '6' , '0' , '5' , '5.70' ) 
11/04/2024 07:32:22 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '46/A' AND id_document != '91065' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-04-03') 
11/04/2024 07:32:22 pm >> UPDATE ps_document SET
                          id_document_type = '24',
                          document_num = '46/A',
                          document_date = '2024-04-03',
                          document_letter = 'A',
                          id_customer = '2912',
                          id_supplier = '',
                          id_address = '4672779',
                          address1 = 'P. ZZA CARMINE PASTORE, 10 84080 CAPRIGLIA - PELLEZZANO',
                          address2 = '',
                          note = '',
                          price_shipping = '0.00',
                          id_tax_shipping_rules = '4',
                          colli = '0',
                          peso = '0',
                          porto_e_imballo = '0',
                          mezzo_consegna = '',
                          id_payment = '0',
                          id_causal = '0',
                          price_tax_included = '55.00',
                          price_tax_excluded = '55.00',
                          date_upd = NOW()
                        WHERE id_document = '91065' 
11/04/2024 07:32:22 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 = '91065' 
11/04/2024 07:32:22 pm >>  DELETE FROM ps_document_detail WHERE id_document = '91065' 
11/04/2024 07:32:22 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '91065' , '0' , 'tunica bordo oro' , '1' ,  '-1' , '0' ,
                               '55.0000' , '55' , '0' , '0' , '55.00' ) 
11/04/2024 07:32:22 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '91065' , '0' , '100 n 1' , '1' ,  '-1' , '0' ,
                               '0.0000' , '0' , '0' , '0' , '0.00' ) 
11/04/2024 07:32:22 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '91065' , '0' , '105 - n 2' , '1' ,  '-1' , '0' ,
                               '0.0000' , '0' , '0' , '0' , '0.00' ) 
11/04/2024 07:32:22 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '91065' , '0' , '110 - n. 5' , '1' ,  '-1' , '0' ,
                               '0.0000' , '0' , '0' , '0' , '0.00' ) 
11/04/2024 07:32:22 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '91065' , '0' , '115 - n 6' , '1' ,  '-1' , '0' ,
                               '0.0000' , '0' , '' , '0' , '0.00' ) 
11/04/2024 07:32:22 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '91065' , '0' , '120 - n 1' , '1' ,  '-1' , '0' ,
                               '0.0000' , '0' , '0' , '0' , '0.00' ) 
11/04/2024 07:32:22 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '91065' , '0' , '125 - n 1' , '1' ,  '-1' , '0' ,
                               '0.0000' , '0' , '0' , '0' , '0.00' )