Mass Update Module

[kilapanga]

Has anyone been able to add pagination to this module? if yes, could you share it?

[SmartiesKiller]

nice idea kilapanga

in a feature version why not make a catagorie massupdate ? i think that could free some cpu time for people who have 1000 product like me.

[Guest]

Hi,

No problem.
The same module.
But now update the category

www.eurocomputers.info/augmentationprix2.zip

But look the readme!!

I use this module for import, i have now about 35000 products add.

[intenso]

Hi,

No problem.
The same module.
But now update the category

www.eurocomputers.info/augmentationprix2.zip

But look the readme!!

I use this module for import, i have now about 35000 products add.

Could you update the link please

[alvanov]

Hi,

No problem.
The same module.
But now update the category

www.eurocomputers.info/augmentationprix2.zip

But look the readme!!

I use this module for import, i have now about 35000 products add.

Could you update the link please

Yes.. Please update the link.. because http://www.eurocomputers.info/augmentation-prix.zip doesn't work anymore.. the page not found.. thanks..

[Alexandru Trandafir]

I´m like 2 others here got this error:

Parse error: syntax error, unexpected $end in C:\xampp\htdocs\classes\Module.php(325) : eval()'d code on line 256

Parse error(s) in module(s)
massupdate


Please please help us out here !!

If nobody can help me in this is someone that can tell me how I can delete this module again ?

Hi, that's because the one who made that module was a little lazy and wrote it with php short tags <? instead of <?php, to fix it replace all <? with <?php, and <?= with <?php echo, the other solution is to enable php short tags on your webserver, in php.ini.

Good luck!

[2thepoint]

i'm using ps 1.2.5, product dont appear.
kind regards

[2thepoint]

It will not preview the products with me i'm using 1.2.5 prestashop.

kind regards

[Artizzz]

it don't work on prestashop 1.3, maybe someone has fixed this module for prestashop 1.3?

[mauriello72]

Hello

i do modified the original massupdate and i am using it for change the Reduction amount percentage in all products (similar to http://www.eurocomputers.info/augmentation-prix.zip , which one i cannot download for free) .
You can download here:
http://www.inciampa.com/alldiscount.tar

there is only one problem : i am using 1.3 and in product.php there is no getProductsProperties ,so i do commented the line 212 in alldiscount.php , otherwise i have system error message.
any suggestion?


M

[mauriello72]

Artizzz, for the moment just comment the line:

$all_products = Product::getProductsProperties($language_id,$all_products);

[RhythmsOfSilence]

Take this module:

http://www.prestastore.com/bulk-update/168-quick--bulk-update-augmentation-prix.html

I have it for FREE:

www.eurocomputers.info/augmentation-prix.zip

Hi
Can any one give me link of the Bulk Update Module that works for 1.3.

Thanks.

[XAMelleOH]

I want Bulk Update Module too...

[Gilles10]

no run this module
message : "tentative de piratage"

Ce module ne fonctionne pas
Affiche "tentative de piratage"

thanks

[knoopix]

Hi,

I have the same problem; when I click on "Configure", I have the message : "Tentative de piratage" (Hacking)

Can anybody help me ?

Regards

[rustykalni]

http://prestaportal.com/thread-98.html
It helps with hack attempt but module doesn't work.

[Kebbe]

I also got "Hack Attempt" when i choosing my language id.
Any idea? I did not find any good info on the link rustykalni wrote.

Anyone have a clue? I really want this to work!

[dixie]

I just downloaded this module, then received "Hack Attempt" response from Prestashop. Did I do something wrong? The module was installed, but when I went to configure it, I received the message "Hack Attempt".

[rustykalni]

You can use this:
http://prestadesign.pl/moduly-f13/quick-edit-modul-do-aktualizacji-cen-i-ilosci-prod-t106.html

[jnktaylor]

Got it to work with 1.3.1 by changing the following.

modules/massupdate/massupdate.php
from

$all_products = Product::getProductsProperties(1,$all_products);

to

$all_products = Product::getProducts(1);

Jack

[ugur onur]

Here's a modified version for those who have the PARSE ERROR problem. :exclaim:

Works fine on 1.2.5

Cheers!

what about the small pictures of products. Possible to add the list, admin can see it... Some times really need it...

[Prinfor]

Got it to work with 1.3.1 by changing the following.

modules/massupdate/massupdate.php
from

$all_products = Product::getProductsProperties(1,$all_products);

to

$all_products = Product::getProducts(1);

Jack

Made this change but appears is not working appear to me this errors:
Warning: Missing argument 2 for Product::getProducts(), called in /public_html/publico/modules/massupdate/massupdate.php on line 195 and defined in /public_html/publico/classes/Product.php on line 576

Warning: Missing argument 3 for Product::getProducts(), called in public_html/publico/modules/massupdate/massupdate.php on line 195 and defined in public_html/publico/classes/Product.php on line 576

Warning: Missing argument 4 for Product::getProducts(), called in public_html/publico/modules/massupdate/massupdate.php on line 195 and defined in public_html/publico/classes/Product.php on line 576

Warning: Missing argument 5 for Product::getProducts(), called in public_html/publico/modules/massupdate/massupdate.php on line 195 and defined in public_html/publico/classes/Product.php on line 576
Hack attempt


Have any ideas? Thanks in advance

[jnktaylor]

Made this change but appears is not working appear to me this errors:
Warning: Missing argument 2 for Product::getProducts(), called in /public_html/publico/modules/massupdate/massupdate.php on line 195 and defined in /public_html/publico/classes/Product.php on line 576

Warning: Missing argument 3 for Product::getProducts(), called in public_html/publico/modules/massupdate/massupdate.php on line 195 and defined in public_html/publico/classes/Product.php on line 576

Warning: Missing argument 4 for Product::getProducts(), called in public_html/publico/modules/massupdate/massupdate.php on line 195 and defined in public_html/publico/classes/Product.php on line 576

Warning: Missing argument 5 for Product::getProducts(), called in public_html/publico/modules/massupdate/massupdate.php on line 195 and defined in public_html/publico/classes/Product.php on line 576
Hack attempt


Have any ideas? Thanks in advance

Went back and looked at my modification and see that I commented out that line of code instead of changing it.
Sorry for the mix up.

modules/massupdate/massupdate.php
from

$all_products = Product::getProductsProperties(1,$all_products);

to

// $all_products = Product::getProductsProperties(1,$all_products);

Jack

[shimony]

Yep!!!
After commenting this line - it works perfectly!

Thank you !!

[lwdmall]

Hello
I installed the mass update module and when I click on the configure and I get the Hack attempt message and it wont let me configure it. Please help, what am I doing wrong? do I need to set permissions on something, I set the mass update folder to 777 but still wont let me configure. I am using Version 1.3.1.1 - 0.172s

Thanks for your help.

I got it working, viewed thread above and commented out the line and it worked. I have another question. most of my products use Combinations rather than a single product, is there a way to alter this mod to be able to change stock on each combinations? The current mod works fine to pricing since the price does not change for my combinations. If not does anyone know of a mod that will do this?
Thanks

[zzappo]

Power module to easily edit the characteristics of products in different languages.
Fields:
Active, Name, Quantity, Price, Wholesale Price, Amount of reduction, reduction percentage, weight, META Title, META Description, META Keywords, Link Rewrite, manufacturer ID, vendor ID


Attention, so that the module works correctly none of the fields may have the character " (parentheses) otherwise gives error and may lose some information.

massupdate_1.2.zip

[zzappo]

Does anyone know how to implement the fields description_short and description?

The following code does not work because it removes the formatting:


"description_short"=>array(
"db_field"=>"description_short",
"friendly"=>"Descricao Curta",
"isLang" => 1,
"input_size" => 40,
),
"description"=>array(
"db_field"=>"description",
"friendly"=>"Descricao",
"isLang" => 1,
"input_size" => 100,
),

[Martin]

Is there any way to be able to edit the parent categori of a product though this and if yes plz share !!

best regards Martin

Made it my self so if anyone intrested then add this


"categori"=>array(
"db_field"=>"id_category_default",
"friendly"=>"cat",
"isLang" => 0,
"input_size" => 1,
),


after $main_product_fields = array(

line 70



could be made better but im only a copy paste programmer

[Aaron Healey]

Yes has any one worked how to add this fields to the Module,

Short Description
Description
Image URL
Categories
Sub Categories
Products

This is a great module, but if it had the short description included that would be great and also if the IMAGE URL was included + categories + sub categories and if we could have

Categories then next to that have ADD so lets you add a category and same for the sub category and products?

This will be a great.

Regards,
Aaron Healey

[jimbojetson]

:-) great module. got the 1.2 version to work for PS 1.3 after modding
managed to add column for Recomended Retail Price, which I've added to my version.
I like the way this module is built - made to be easy to change. cool
one question - why does the module display two unused columns at the end - weight and size? could it be anything to do with attributes I've added to products? mmm....

[jimbojetson]

one more question. is there any way this tool could be added to the 'Tools' admin tab, instead of using the 'configure' option in modules?

[alchemisto]

one more question. is there any way this tool could be added to the 'Tools' admin tab, instead of using the 'configure' option in modules?

Yes there is.

Check it here:

http://www.prestashop.com/forums/viewthread/35089/P30/#176707

But I have a question with those module. How to remove the currency formatting in the “Wholesale Price” and the “Price Exc. Tax”? I just want it to be as plain as product price in original product info.

I hope someone could help me.

[guest*]

Hi, I tried to install this modul, but it seems that this module cannot be hooked in my presta-version I receive syntax-error in file module.php. As I'm not a coder, what shall I change and where ?

Parse error: syntax error, unexpected $end in C:\inetpub\wwwroot\my-domain.at\shop\classes\Module.php(323) : eval()'d code on line 256

[guest*]

definitely it does not work with 1.3.1.1.

[Christophe Klein]

Got it working in 1.3.1.1 after commenting this line (around line 197) in massupdate.php

$all_products = Product::getProductsProperties(1,$all_products);

[guest*]

Got it working in 1.3.1.1 after commenting this line (around line 197) in massupdate.php

$all_products = Product::getProductsProperties(1,$all_products);

I've changed the line. Modul does not work and error is the same:

Parse error: syntax error, unexpected ';', expecting T_FUNCTION in \classes\Module.php(323) : eval()'d code on line 238

[rnrd001]

Would this module be helpful for modifying the product list display? I am desperately looking for a solution to add attributes to my products without having to go into the product description page. I'd like to bring my colour attribute scrol-down selection box into the product list page, like this:

How would that be possible?

Many thanks in advance for your help

[KTech]

Presta 1.2.5, MassUpdate 1.2
I have the message "Parse error: syntax error, unexpected $end in D:\inetpub\wwwroot\skripta.fr\classes\Module.php(325) : eval()'d code on line 379"


OK, this is due to use of short tag.

[Global Attribute AB]

Got it to work with 1.3.1 by changing the following.

modules/massupdate/massupdate.php
from

$all_products = Product::getProductsProperties(1,$all_products);

to

$all_products = Product::getProducts(1);

Jack

Thanks!

Works perfectly with this change! (I have version 1.3.2.3).

[gs]

why i can´t see shop´s products.?
helpppppppppppppppp

[frosticek]

Is there any way and change code to sort products not by NAME, but i.e. by REFERENCE or by PRICE ?
I really need this think.

[thisbox]

It does not work on V1.3.2.3

[BWT]

I got a fatal error message on version 132 any updates for module? I would love to use it! I got it to work well! I had to go to my server and delete an extra folder that was blocking this module and then i tried it again and it worked great! Thanks =)

[tokobukutaro]

I got a fatal error message on version 132 any updates for module? I would love to use it!

me to, got FATAL EROR using 1.3.3.0

I found solution for Presta ver. 1.3 up
go to this : http://www.prestashop.com/forums/viewthread/65839/third_party_modules/mass_update_module_modified

[letsbeonline]

I have Version 1.3.2.3

I installed the module with almost all updates but still have this error when i add the module "Parse error(s) in module(s) 1. massupdate"

any solution?

thanks

[Dustin]

yeah i have the same error in version 1.3.4

[saikat]

My product list is not displaying. Please see the attach image.
Please help me.
I have also attached my massupdate.php file

massupdate.php

[jamieshankland]

Hi i am getting a fatal error after trying to configure?

also would it be possible to edit the meta tags in future?

[SonnyBoyII]

Im getting "Parse error(s) in module(s) " prestashop ver 1.3.6
Any ideas how to fix it?

[Comshop]

Hello
after installing the module appears in the Back Office "Fatal error"

www.comshop.com.pt

[stephaneg50@hotmail.com]

bonjour
j'ai teste votre module version 1.2 sur prestashop 1.4015, il demare mais je souhaite faire une modif sur le retour d'info , qu sera adapter au textil, j'ai voulu modifier la requete sql en ceci
SELECT *
FROM `'._DB_PREFIX_.'product` p
LEFT JOIN `'._DB_PREFIX_.'product_attribute` f ON ( f. `id_product` = p.`id_product` )
LEFT JOIN `'._DB_PREFIX_.'product_attribute_combination` g ON ( f. `id_product_attribute` = g.`id_product_attribute` )
LEFT JOIN `'._DB_PREFIX_.'attribute` h ON ( g. `id_attribute` = h.`id_attribute` )
LEFT JOIN `'._DB_PREFIX_.'attribute_group_lang` i ON ( h. `id_attribute_group` = i.`id_attribute_group` and i. `id_lang` = '.intval($cookie->id_lang).' )
LEFT JOIN `'._DB_PREFIX_.'attribute_lang` j ON ( j.`id_attribute` = h.`id_attribute` and j. `id_lang` = '.intval($cookie->id_lang).' )
LEFT JOIN `'._DB_PREFIX_.'product_lang` pl ON (p.`id_product` = pl.`id_product`) WHERE pl.`id_lang` = '.intval($cookie->id_lang).' limit 0 , 30 ';


celle ci fonction parfaitement sous mysql, et quant j'ajoute une selection de colonne
SELECT p.`reference`, pl.`name` ,f.`ean13` , p.`price`, p.`weight`, f.`quantity` FROM `'._DB_PREFIX_.'product` p
LEFT JOIN `'._DB_PREFIX_.'product_attribute` f ON ( f. `id_product` = p.`id_product` )
LEFT JOIN `'._DB_PREFIX_.'product_attribute_combination` g ON ( f. `id_product_attribute` = g.`id_product_attribute` )
LEFT JOIN `'._DB_PREFIX_.'attribute` h ON ( g. `id_attribute` = h.`id_attribute` )
LEFT JOIN `'._DB_PREFIX_.'attribute_group_lang` i ON ( h. `id_attribute_group` = i.`id_attribute_group` and i. `id_lang` = '.intval($cookie->id_lang).' )
LEFT JOIN `'._DB_PREFIX_.'attribute_lang` j ON ( j.`id_attribute` = h.`id_attribute` and j. `id_lang` = '.intval($cookie->id_lang).' )
LEFT JOIN `'._DB_PREFIX_.'product_lang` pl ON (p.`id_product` = pl.`id_product`) WHERE pl.`id_lang` = '.intval($cookie->id_lang).' limit 0 , 30 ';

la ca ne marche plus qu'elle est la bonne facon d'ecrire cette requette sous php?


merci cordialement stephane

[stephaneg50@hotmail.com]

bonjour
pour la requete sql pour le textil il faut juste ajoute
SELECT p.`id_product` , p.`reference` , pl.`name` AS nom, f.`ean13` , p.`price` , p.`weight` , i.`public_name` , j.`name` , f.`quantity`


donc la j'ai une prise compte des tailles et couleurs

mais comment affiche cela correstement? sur l'image on ne voie pas taille et couleur sur une même ligne, et même on ne voie pas la couleur?

merci pour une aide

[ScubaLessonsInc]

Any response on the FATAL ERROR THING?

[ruppon]

My product list is not displaying.

Any response on the FATAL ERROR THING?

I attach fixed massupdate.php
It also fixes the bug with duplicate product at the bottom of the list and the bug with not displaying list (cheers saikat ).
Tested on 1.3.7 final.

massupdate.php

[screentekdesignsltd]

Excellent Mod, Just What we were looking for.

Well done. Keep up the excellent work.

[Ovi]

My product list is not displaying.

Any response on the FATAL ERROR THING?

I attach fixed massupdate.php
It also fixes the bug with duplicate product at the bottom of the list and the bug with not displaying list (cheers saikat ).
Tested on 1.3.7 final.

Still getting PARSE ERROR on 1.3.7 final

edit: sorry just read the tags post, will update the tags

[ruppon]

I've just tested it again and I can guarantee it's working fine on 1.3.7 final (with the massupdate.php updated file attached to my previous post).
Try to turn on debugging to find out what's wrong.

[Ovi]

Okay now this is weird. On my local copy running on XAMPP, module is working just fine, changing prices. The exact files on my online version leave the prices unchanged, although no errors are reported.

Do you have any idea? Thanks a lot in advance!

[Sticki]

hallo
does it work with PS V1.4.1?

[Sticki]

somebody try it in version 1.4.1 ?????

[ScubaLessonsInc]

Yes it works in 1.4.17 I tested it allot.. all good now.

[Sticki]

Yes it works in 1.4.17 I tested it allot.. all good now.

thanks for your answer. I have install the module, but, when I want to change the reduction price and want to save it, came the follow error message:

FAILED TO UPDATE: UPDATE ps_product SET date_upd = NOW() , `price` = '52.500000' , `quantity` = '4' , `reduction_price` = '20' WHERE `id_product` = '10' LIMIT 1 Unknown column 'reduction_price' in 'field list'

could anyone helpme please?

[sabsworld]

Thanks for this module ! Great Job.

[ivoscz@gmail.com]

Hi
very good module. I have one problem. We have in shop circa 20.000 items. very very long work in one table all products. How make listing sample :
Page 1 / 403 > >> | Display 50 / 20.114 result(s)

Thank you

[Sticki]

Yes it works in 1.4.17 I tested it allot.. all good now.

thanks for your answer. I have install the module, but, when I want to change the reduction price and want to save it, came the follow error message:

FAILED TO UPDATE: UPDATE ps_product SET date_upd = NOW() , `price` = '52.500000' , `quantity` = '4' , `reduction_price` = '20' WHERE `id_product` = '10' LIMIT 1 Unknown column 'reduction_price' in 'field list'

could anyone helpme please?

could anyone helpme please?

[mecollectibles]

It is really a long discussion title.
I uploaded the module but as I installed it & wanted to configure it, the fatal error was the message I got all time.
What should I do?

[ruppon]

http://www.prestashop.com/forums/viewthread/14679/P240/#408641

[mecollectibles]

Thanks a lot ruppon. I am to the page now.
Just as I have many items & many have same title, I wonder if there is a way to add the Reference number to the list that items could be sorted by Reference numbers or other way as it is the method in Prestashop to sort items?
Otherwise, I may change some items prices by mistake.
Any help?

[Antares88]

Est ce possible de l'avoir en version 1.4 de prestashop?

[juanv]

Thanx for the module!

Iam using the massupdate ver 1.2 and i just tested it on my shop, all worked fine but i noticed that some of my products are not listed for update.....

Can someone help me to add a number before each product so that i can compare the total products in the massupdate with my total products in my shop to confirm if there's any products missing?

massupdate.php

[Spidy]

Thanks for this great module!

...but...I have much attributes...

This is the solution for ATTRIBUTES!

BUT!!! Its handle only the product_attributes table, so if your product dont have attributes, it will not shown in the mass update module. (sorry Iam not a php programmer)

Take this and enjoy: (tested on v. 1.4 Final)

massupdate.php

[Choy Gonzalez]

My product list is not displaying.

Any response on the FATAL ERROR THING?

I attach fixed massupdate.php
It also fixes the bug with duplicate product at the bottom of the list and the bug with not displaying list (cheers saikat ).
Tested on 1.3.7 final.

Ruppon, your fixed attachment works for me in 1.4, thanks!

What about ig I want to add whosale_price column? Is it so simple as adding this code to massupdate.php?

"wholesale_price"=>array(
            "db_field"=>"wholesale_price",
            "friendly"=>$this->l('Wholesale_Price'),
             "prefix"=> '(' . $sign . ')',

[mecollectibles]

I list every item & sell them in my shop with Reference numbers & wonder how a row for REFERENCE # can be added to this module?
Can anybody help please?

[Choy Gonzalez]

My product list is not displaying.

Any response on the FATAL ERROR THING?

I attach fixed massupdate.php
It also fixes the bug with duplicate product at the bottom of the list and the bug with not displaying list (cheers saikat ).
Tested on 1.3.7 final.

Ruppon, your fixed attachment works for me in 1.4, thanks!

What about ig I want to add whosale_price column? Is it so simple as adding this code to massupdate.php?

"wholesale_price"=>array(
            "db_field"=>"wholesale_price",
            "friendly"=>$this->l('Wholesale_Price'),
             "prefix"=> '(' . $sign . ')',

ok ruppon seems to be unavailable.... anybody else out there???
thanks in advance

[Spidy]

Yes Choy, just add these rows to the $main_product_fields section:

             "wholesale_price"=>array(
               "db_field"=>"wholesale_price",
               "friendly"=>$this->l('Wholesale price'),
               "isLang"  => 1,
               "prefix"=> '(' . $sign . ')',
               "input_size" => 10, 
        ),

[_vg_]

Hey! Where to download de latest version of this module?

Need for v1.4.

Thanks!

[Hashishim]

Can anyone assist me? I want to add another table to this, Its for version 1,4 . Table is called specific_price (its for the fields reduction_price etc) Please can you tell me what code do i put and where i Put it. If i replicate the code for the product_lang. with that it would be the same isnt?

[geomagi]

 

thanks for your answer. I have install the module, but, when I want to change the reduction price and want to save it, came the follow error message:

FAILED TO UPDATE: UPDATE ps_product SET date_upd = NOW() , `price` = '52.500000' , `quantity` = '4' , `reduction_price` = '20' WHERE `id_product` = '10' LIMIT 1 Unknown column 'reduction_price' in 'field list'

could anyone helpme please?

[fendytan]

I am running PS 1.4.0.17. I have succesfully installed the module. I also can see the tables/products, but when I clicked on "save all my products", it didn't do anything. Please help.

 

Can anybody post massupdate.php that works with PS 1.4.0.17 ????

 

Thank you

 

 

nevermind, a very kind forum member helped me with another solution (which is not related to this module)

[medfordite]

When I click on the configure, I get a blank module, so it isn't loading properly on my end. Using the version from the first post which I assume is updated.

 

Prestashop V. 1.4.5.1

[bclaassen]

I've updated the module to version 1.3 were i splitted the module and made an admin tab.

Also made other changes like

• Added a tab under products.
  
• Added number and product image
  
• Removed bugs & notifictions
  
• Various other small changes
  

I'm planning to make an "real" config screen where u can edit which fields to display, size etc.

 

 

Also planning to make other changes like edit mass images upload, product delete etc.

 

For modifiing the module which fields to show just simply uncomment or comment in file: AdminMassUpdate function: _getConfig function

 

massupdate_v1.3.zip

Edited December 30, 2011 by bclaassen (see edit history)

[nepaholic]

How to update if i have attributes?

[izzy058]

Not working for me, first version I try to instal says " HACK ATTEMPT " and the 1,3 version if I try to install is ok, but I when I click MASS UPDATE link it`s show a big Question Sighn ? ... cannot edit anything.

[outblast]

Works, but not recomended if u have 3000-5000 products.. Needs some filters