Mass Update Module

[PEPPE83 8]

I have a question, it is possible to order the products page in alphabetical order?

[CE Custom Designs 4]

Thank you very much for this great MOD. I am running massupdate 1.6 on Prestashop 1.4.7.3. I have, what I feel, is a simple and somewhat stupid question. Are you supposed to be able to load and run the /modules/massupdate/AdminMassUpdate.php.

 

 

If so, I am getting the following errors....

 

 

Warning: include_once(PS_ADMIN_DIR/../classes/AdminTab.php) [function.include-once]: failed to open stream: No such file or directory in/home/content/94/7639894/html/modules/massupdate/AdminMassUpdate.php on line 17

 

Warning: include_once() [function.include]: Failed opening 'PS_ADMIN_DIR/../classes/AdminTab.php' for inclusion (include_path='.:/usr/local/php5/lib/php') in/home/content/94/7639894/html/modules/massupdate/AdminMassUpdate.php on line 17

 

Fatal error: Class 'AdminTab' not found in /home/content/94/7639894/html/modules/massupdate/AdminMassUpdate.php on line 19

[tdr170 679]

Not sure what you mean by load and run the php file, you install as a module in the back office modules section.

Just click on modules, then upload a module from my computer and browse to where you saved the zip file and upload that.

Then go to administration area under modules find the Mass Update 1.6 and install

Then you can update products using the Mass update link under the Categories tab.

[CE Custom Designs 4]

Yeah I did all that and it works like it should...I think. But before installing it i was reading the posts and it talked about being able to choose what fields you displayed, and being able to edit some of the features. I just wanted to make sure that I was not missing a place to edit these options.

 

 

Thanks for getting back to me.

[tdr170 679]

You can edit the fields in the AdminMassUpdate.php at lines from around line 264 - 358 fields with // in front are disabled.

[PEPPE83 8]

I have a question, it is possible to order the products page in alphabetical order?

 

anu suggestions?

[yugal 0]

thanks

[enrique2011 0]

Muy buen módulo. Me ha servido mucho.

 

Gracias!

[Prestagreedo 2]

fantastic module, thank you very much

i've managed to make changes to the code with the very clear instructions

also.. I managed to download the old version and spend ages looking for the admin file that wasn't there before I realised there was a new version...

[intro 3]

Take a look at my Bulk Products Edit module for Prestashop 1.4.9

[Mahdi Shad 40]

Is there a way to export the "price list" of the massupdate1.6 module?

[Prestagreedo 2]

Take a look at my Bulk Products Edit module for Prestashop 1.4.9

 

I'm a bit confused, you advertise it both in the free and paid module sections...

[rebirth 0]

I installed this module, and all was ok. But when I click the configure link, I get a "Tab cannot be found." message.

I use Prestashop 1.4.7.3.

[tdr170 679]

I had this module installed and working perfectly in a 1.4.7 install try to uninstall/ delete and re-install the module and see if that helps.

If not please post and I will help.

[TheWayside 0]

Yeah I'm getting tab cannot be found as well. Tried deleting - reinstalling. On prestashop 1.4.5.1.

[tdr170 679]

rebirth & TheWayside:

 

Did you install the 1.6 version from post 394 as this is the latest version of this module.

I just downloaded and installed on a 1.4.7.0 version without any issues.

I downloaded the one posted in post 394 just to make sure there was not an issue with the file.

[TheWayside 0]

Yeah it was the 1.6 version. Just unzipped it and installed the directory into the modules/ftp and that's what I'm getting. Frustrating as can't find any mass edit module for prestashop, you'd think it was a basic thing they'd have!

[tdr170 679]

Have you tried to install using the upload a module from my computer, select the zip you downloaded and click on upload, go to administration and install, this is how I did it and had no issues.

 

And I agree you would think.

[TheWayside 0]

Yes I tried that too, but it just says The following module(s) were not installed successfully:

And that is after I deleted it from the ftp. I was able to install the version on page 1, but when I pressed configure nothing happened either so I wanted to try the new version. Thanks for the reply, but still need it to work other wise I'm going to have to do it the slow way!

[bkraus 0]

Install someone this modul in the latest version of Presta shop 1.5? We can change the prices, but in product detail remains still old price.

In db in ps_product table is new price...

Can you help me?

[Guy Scharf 3]

If Configure button gives "tab not found" message, try pressing the Delete button for the massupdate module and then reinstalling by using the "add module from your computer" option. I just had the "tab not found" message and this procedure fixed the problem.

[Martin nl 1]

when used in PS 1.5.0.17 both the mass price module and mass update module change the price in the -base price- . But in the front office prices are not changing. In fact the -base price- under catalog > products has no effect on the final prices whatsoever ??

anyone got ideas? adjusting ther module? and what is the -base price- ?

[PEPPE83 8]

Please!!!

nobody knows a way to sort products by name and not by ID?

I had a look at the code but it is too complicated for my skills ...

[Guy Scharf 3]

nobody knows a way to sort products by name and not by ID?

With massupdate v1.6, in module AdminMassUpdate.php, around line 97, find this:

  // all products
  $sql = 'SELECT *
FROM `'._DB_PREFIX_.'product` p
LEFT JOIN `'._DB_PREFIX_.'product_lang` pl ON (p.`id_product` = pl.`id_product`) WHERE pl.`id_lang` = '.$this->_id_lang;

Replace that SELECT statement with one that includes an ORDER BY clause:

  // all products
  $sql = 'SELECT *
FROM `'._DB_PREFIX_.'product` p
LEFT JOIN `'._DB_PREFIX_.'product_lang` pl ON (p.`id_product` = pl.`id_product`) WHERE pl.`id_lang` = '.$this->_id_lang.'
ORDER BY pl.`name`';

This works for us with English language. I don't know if there are any problems with other languages.

[tdr170 679]

when used in PS 1.5.0.17 both the mass price module and mass update module change the price in the -base price- . But in the front office prices are not changing. In fact the -base price- under catalog > products has no effect on the final prices whatsoever ??

anyone got ideas? adjusting ther module? and what is the -base price- ?

 

The module has not been updated to work with 1.5 will try myself when all testing on a good working 1.5 is available.

Right now I have so many issues with 1.5 just don't have the time to tackle this.

[PEPPE83 8]

With massupdate v1.6, in module AdminMassUpdate.php, around line 97, find this:

  // all products
  $sql = 'SELECT *
FROM `'._DB_PREFIX_.'product` p
LEFT JOIN `'._DB_PREFIX_.'product_lang` pl ON (p.`id_product` = pl.`id_product`) WHERE pl.`id_lang` = '.$this->_id_lang;

Replace that SELECT statement with one that includes an ORDER BY clause:

  // all products
  $sql = 'SELECT *
FROM `'._DB_PREFIX_.'product` p
LEFT JOIN `'._DB_PREFIX_.'product_lang` pl ON (p.`id_product` = pl.`id_product`) WHERE pl.`id_lang` = '.$this->_id_lang.'
ORDER BY pl.`name`';

This works for us with English language. I don't know if there are any problems with other languages.

 

This mod works great on PS 1.4.8.2 and Mass Update 1.6 in italian language!!!!

TY very much!!!!!!!!!!!!!!

[Mitico 0]

Hello,

 

Wanted to thank for this wonderful module!

 

I have just one question: there's one product listed that is not in my shop - "Shure SE210 Sound-Isolating Earphones for iPod and iPhone". It's the default example of a product when installing a fresh copy of prestashop, but i've deleted it ages ago, yet it may be seen in the list. Any suggestions how to get rid of it?

[PEPPE83 8]

Hi TDR170, i have found a problem:

I have set the module to show 1000 products, when i change quantity or price and click on save all my product the message is: Your products have been successfully updated!

But this message is not real!!!!

The module change price and quantity only for the first 100 product (approximately)!

Any suggestions?

 

 

EDIT: i'm sure, the module change only the first 150 products!

 

EDIT 2: if i set page limit to 150 products all works great, but if i set page limit to 151 the product #151 dont change! same for all pages.

Edited October 16, 2012 by PEPPE83 (see edit history)

[Cintia 2]

Hi,

 

I have problems when installing this module. May it be because I'm working on a local server?

 

Once installed, both with the module installer or manually, nothing shows in the modules list :S

[tdr170 679]

Hi TDR170, i have found a problem:

I have set the module to show 1000 products, when i change quantity or price and click on save all my product the message is: Your products have been successfully updated!

But this message is not real!!!!

The module change price and quantity only for the first 100 product (approximately)!

Any suggestions?

 

 

EDIT: i'm sure, the module change only the first 150 products!

 

EDIT 2: if i set page limit to 150 products all works great, but if i set page limit to 151 the product #151 dont change! same for all pages.

 

Peppe83:

 

I have heard of this issue before , however I have never been able to reproduce as in my shops it has always worked fine, I updated quantities for 800 products without any issues. I just updated the quantity and weight for product #801 without any problems. Have you tried to uninstall and re-install, have you made any personnel mods to the code, what version of Presta.

[geniusoo 0]

I have a problem I need an employee to change prices with this fantastic module but can not and giving all available permissions.

What I can do?

 

translation of google translate

My language is Spanish

[DistribucionesPapiro 0]

Hi there!

I am using prestashop 1.4.9, I installed the module without problems but when I try to load the tab nothing appears. Making it work would end my headaches with stock ^^

 

Edit:

 

Screenshot: http://imgur.com/u5Xmu

Edited December 13, 2012 by DistribucionesPapiro (see edit history)

[Mahdi Shad 40]

hi

i installed this module in both host & local and it working correctly (1.4.9)

and also i solved its problem with features

[tdr170 679]

hi

i installed this module in both host & local and it working correctly (1.4.9)

and also i solved its problem with features

 

How about posting what your fix was so that others can benifit from your knowledge.

 

Hi there!

I am using prestashop 1.4.9, I installed the module without problems but when I try to load the tab nothing appears. Making it work would end my headaches with stock ^^

 

Edit:

 

Screenshot: http://imgur.com/u5Xmu

 

 

Have you tried to uninstall and re-install the module.

[Marco9011 1]

you can make prices including taxes?

[tohumu 0]

ps. 1.5.2, unfortunately, does not work. seems to be working, but the result does not update.

Edited December 21, 2012 by tohumu (see edit history)

[tdr170 679]

you can make prices including taxes?

 

Sorry but not possible as the taxes are added by Prestashop code and not part of database prices.

This module draws information from the database to populate the fields.

[Kil0w0g 1]

Hello,

 

Someone has a compatible 1.5.3 version?

Does it exist?

And does a version with declination management exist?

Edited February 27, 2013 by Kil0w0g (see edit history)

[BoKr 28]

Thank you very much for this great MOD. I am running massupdate 1.6 on Prestashop 1.4.7.3. I have, what I feel, is a simple and somewhat stupid question. Are you supposed to be able to load and run the /modules/massupdate/AdminMassUpdate.php.

 

 

If so, I am getting the following errors....

 

 

Warning: include_once(PS_ADMIN_DIR/../classes/AdminTab.php) [function.include-once]: failed to open stream: No such file or directory in/home/content/94/7639894/html/modules/massupdate/AdminMassUpdate.php on line 17

 

Warning: include_once() [function.include]: Failed opening 'PS_ADMIN_DIR/../classes/AdminTab.php' for inclusion (include_path='.:/usr/local/php5/lib/php') in/home/content/94/7639894/html/modules/massupdate/AdminMassUpdate.php on line 17

 

Fatal error: Class 'AdminTab' not found in /home/content/94/7639894/html/modules/massupdate/AdminMassUpdate.php on line 19

 

 

Sir,

 

I got also an issue

 

PS 1.4.9 and MU V1.6. I installed it the proper way by uploading the zip via gui as I always do... But this module gives me the error:

Warning: Invalid argument supplied for foreach() in /usr/www/users ....
[b]/modules/massupdate/AdminMassUpdate.php[/b] on line [b]203[/b]

Edited February 27, 2013 by B.Köring (see edit history)

[tdr170 679]

Sir,

 

I got also an issue

 

PS 1.4.9 and MU V1.6. I installed it the proper way by uploading the zip via gui as I always do... But this module gives me the error:

Warning: Invalid argument supplied for foreach() in /usr/www/users ....
[b]/modules/massupdate/AdminMassUpdate.php[/b] on line [b]203[/b]

 

Use add a module from my computer in the BO modules section, browse to the location of the module on your computer, upload then install.

[BoKr 28]

Use add a module from my computer in the BO modules section, browse to the location of the module on your computer, upload then install.

 

Ezm, that's excactly what I did.

 

[Aldeag 20]

This is a total pain but I was asked to modify this module to show prices inclusive of TAX, after reading all 15 pages in this thread I noticed it's not been done... yay. I have it working but on a single fixed tax rate, I've made the code flexable so if you wanted to load the tax rate from the database and assign it to the value you can, however I'm working on 19% so adapt as needed. It's worth noting when you submit prices with TAX you must save WITHOUT tax, also it will not always update the mass update form when reloaded keeping the old price in place, I over come this by forcing a page reload after SQL has been updated.

 

massupdate.php fixes to have prices inclusive of tax (on fixed rate NOT per country)

 

 

REPLACE / COMMENT OUT TO KEEP ORIGINAL TAX PRICE:

---

#$product['price'] = $product['db_price']; // price hack

--

 

WITH | Note ps_round to keep 2 decimal places:

---

$product['price'] = Tools::ps_round($product['price'],2); #Round off TAX price to 2 decimal places

----

This first give the actual form your price inclusive of TAX (whatever you TAX rate in use is)

 

 

REPLACE:

---

$this->_html .= $this->displayConfirmation($this->l('Your products have been successfully updated!'));

---

WITH:

---

$this->_html .= $this->displayConfirmation($this->l('Your products have been successfully updated!<hr><a href=\'?tab=AdminModules&configure=massupdate&token='.Tools::getAdminTokenLite('AdminModules').'&tab_module=Products&module_name=massupdate\'>Click here to continue</a>'));

 

return $this->_html; #SKIP OUT HERE

---

This stops the form from showing after you submitted changes and makes you click a link to continue, this forces a form reload including new price values (weird bug but whatever)

 

 

Now you form is showing prices including TAX and will do again properly after updating. So last is the actual update itself

 

you want to replace

----

if($update_value){

// we've found a main field to update!

$do_update = true;

$sql .= ", `".$field['db_field']."` = '$update_value' ";

}

----

 

With:

----

if($update_value){

 

if($field['db_field']=="price"){#IF price column then we need to remove BTW/TAX from input

$Oprice=Tools::ps_round(Product::getPriceStatic($product_id, true, NULL, 6),2); #Get original price WITH TAX/BTW

 

if($update_value!=$Oprice){# Only alter IF price has changed if NOT then do not update SQL field negating need to calculate each item

 

$NewPrice=($update_value/(100+$OurTAX))*100; #New price with TAX - (100%+TAX%) =1% without TAX * 100 = Full new price - TAX/BTW

#$NewPrice=Tools::ps_round($NewPrice,2);

 

#echo "<hr>Received ".$update_value." (Originally ".$Oprice.") inc TAX/BTW | Rate%: ".$OurTAX. " | Without TAX/BTW: ".$NewPrice. " + ".$OurTAX."% =

 

".Tools::ps_round(($NewPrice+(($NewPrice/100)*$OurTAX)),2)." (should match Received)"; #DEBUG OUT TEST

 

$do_update = true;

$update_value=$NewPrice;

$sql .= ", `".$field['db_field']."` = '$update_value' ";

 

} #No else, not needed. No change => No update

 

}else{ # Some other field value, let it run as normal

 

// we've found a main field to update!

$do_update = true;

$sql .= ", `".$field['db_field']."` = '$update_value' ";

 

}

 

}

----

 

 

First this statment checks if it's actually the price value being updated or not, if not continue as normal. If it is then:

 

Get the original price with tax and compare it again what was received, if it's the same then its not changed ignore it and don't update anything. IF it has changed:

 

Then take submitted amount and devide by 100% + $OurTAX (19). This gives 1% of the price WITHOUT tax.F

So then simply 1% value * 100 = Total price without TAX that needs updated in SQL

 

I declade $OurTAX outside the foreach statment, this way you can do a SQL call and get your TAX% automatically if yu wanted and just assign the value to $OurTAX for the rest to work, if your lazy then just declare $OurTAX=19; or whatever value before the foreach.

Does this work to work with prices "Tax included"?

I would agree that if I sell with tax included I have to be able to change prices Tax included.

[Matt80 0]

Does it work on 1.5.3?

[Kil0w0g 1]

Tested on 1.5.3 and doesn't work.But maybe it have been corrected since my last post.

(I'm sorry for my bad english)

[Mahdi Shad 40]

hi

database tables are different in 1.4.x with 1.5.x

so its not compatible with new version

(I'm sorry for my bad english)

[BoKr 28]

Mh

 

I am so sad. I need this mass module more than ever and I can not get it working. Locally in XAMPP it does run issueless but installed on the live copy of the local Prestashop1.4.9 it does not!?

 

This time after cleanly deinstalling it first and then reinstalling:

 

 

[leomazz 4]

I will buy a beer to anybody who make this module works on 1.5.2!!!!!

[Pressed0024 36]

I hope someone takes the code and make it compatible with 1.5.4. It's ridiculous to update 100 orders to ship everyday one by one

[BoKr 28]

Hello and dear developer,

 

 

I could make out the trouble maker that impeded a successul use of your modul. I had debug mode on in my Prestashop config and since I turned that one off your module works and two other quirks I had are vanished, too.

[Docjoba 1]

Hello and dear developer,

 

 

I could make out the trouble maker that impeded a successul use of your modul. I had debug mode on in my Prestashop config and since I turned that one off your module works and two other quirks I had are vanished, too.

I hope someone takes the code and make it compatible with 1.5.4. It's ridiculous to update 100 orders to ship everyday one by one

 

up

[Liofey 3]

I feel this module is too dangerous haha lol

[musicmaster 705]

Instead of this module you can use:

 

Mass price Update: http://www.prestashop.com/forums/topic/121053-modulemass-price-update-v16-ps-1215/

or

Order Edit, Category Edit, Product Edit: http://www.prestashop.com/forums/topic/185401-free-script-order-edit-category-edit-product-edit/

 

The latter has some mass update features in its product_edit program.

[yokang87 0]

• 
  
• Members
  
• 
  
• 618 posts
  

After I changed the data, it seems like the data could not be saved.....

 

 

I do feel the same.. How can you people use it? My products setting use this option,

"Available quantities for current product and its combinations are based on stock in the warehouses."

Does it option affect to the result?

[Liofey 3]

• 
• Members
• 
• 618 posts

After I changed the data, it seems like the data could not be saved..... I do feel the same.. How can you people use it? My products setting use this option, "Available quantities for current product and its combinations are based on stock in the warehouses." Does it option affect to the result?

 

Really? What's your version?

[yokang87 0]

Prestashop 1.5.2.0.. Does it affect to the result?

[Julia`s 0]

This version works perfect on 1.5.3.1 , also updates features

massupdate.php

[sdracer77 0]

This is exactly what I need. Thank you very much........works on ver 1.4.4.0

 

The only problem i had with it .. it deleted any text after " character in the main titlie heading ...ended up changing " to the word inch to over come

[tomminoker 0]

* Copy & Paste this url: http://dtbaker.com.a.../massupdate.tar

 

i cant open =(

Can u share at http://dropmefiles.com? or other sait?

[babyewok 17]

Yes, the links do not work - is this still available?  Does it work on 1.4.11?

[pashakiz 1]

Hi!

 

I cant download module. Please give me a new (work) link!!

..or Where else I can download this module?

[tdr170 679]

The latest update to this module can be found in post #394, this however still only works with 1.4xx.

 

use this link then scroll down to post 394.

http://www.prestashop.com/forums/topic/14679-mass-update-module/page-20

[femo 2]

Update to 1.5.6.0?? 

Anyone?

Anything similar?

[BoKr 28]

Femo

 

you could look at demos of storecommander or prestashop store manager or the fabulous and free piece of code developed by Musicmaker I think is his name in this forum:

tripleedit

tripleedit is the script! not module called you  should have a look at.

[dbeezer99 3]

does anyone want to go in on half on this?

[peanut 14]

does anyone have a PS 1.6 compatible solution?

[peanut 14]

does anyone have a PS 1.6 compatible solution?

[wdld 2]

I am getting  error:  For massupdatev1.6, PrestaShop version: PrestaShop™ 1.4.0.17

 

[  Forbidden

You don't have permission to access /admin123/index.php on this server.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.  ]

 

I have change permission to 777 for both 'Admin folder' and 'Index.php' page, but no result.

 

Where I have to change the permission?

Edited April 16, 2014 by wdld (see edit history)

[CarlesCM 2]

Great module, thanks.

Little change to show or hide inactive products.

Bye

Tested on Prestashop v1.4.3.6

AdminMassUpdate.php

Edited May 12, 2014 by CarlesCM (see edit history)

[Alexgaw 29]

+1 needing help to make it work on ps1.6

[mariovm12 0]

Hi I have installed version 1.6 of prestashop. and I installed the V1.6 of MassUpdate, I have the Spanish language so I tried changing $ this-> _id_lang = $ cookie-> id_lang; for $ this-> _id_lang = 1; as I had read in previous reviews and still does not work I just load a blank page anyone can help me I'm new to prestashop

[m0ld 2]

file down?

[catochan 4]

Sorry if my English is bad

 

I try to combine original code with julia's code and adding some new code. It work at Prestashop 1.6.0.9.

But still has a bug like if you want to zero-ing  qty, it not changed at all =__=".

 

 

============

Edited:

• Product Weight, Product height, Product Width, and Product Depth changed into Shipping Weight, Shipping Height, Shipping Width, and Shipping Depth
• Use massupdate.php to update your module
• Where can i download this module? See the attachment  

============

massupdate.php

massupdate.zip

Edited September 17, 2014 by catochan (see edit history)

[aldoscully 2]

Installed in Prestashop 1.5.6.0 but does not change in any products. 

Still appears the symbol and use the $ R$, you must change this to work?

[chaitu 3]

hai guys how to download that module.

pls, help me out as iam new to prestashop.....

[chaitu 3]

hai i have downloaded tjhe zip file ...but the errror is

[PrestaShop] Fatal error in module massupdate:

syntax error, unexpected end of file

could you pls help me out

[Soyons Solidaire 249]

Bonjour à tous

@Catochan , Merci pour ce partage, ça fonctionne pour moi pour l’instant   sur version 1.6.0.9

Amitiés

Edited September 26, 2014 by G.Solidarité (see edit history)

[catochan 4]

@G.Solidarite: Je vous en prie 

 

 

i have found how to zero the value... just input 0.00 to make zero (OMG just that? LoL)

i make little update for massupdate.php (see the attachment to download)

 

=====================

Edit 23 Sept 2014:

• Now the product link can go directly to product, if there is INVALID SECURITY TOKEN just click I understand the risks and I really want to display this page

=====================

massupdate.php

Edited September 23, 2014 by catochan (see edit history)

[omar2886 48]

Great!! It would be wonderful if it can also show the Reference of the products, purchase price and omit those products disabled. Any easy code trick for this changes?

Edited December 22, 2014 by omar2886 (see edit history)

[AdrianPa 0]

Hi everyone

 

Is there any chance to add 'specific price' column to this module?

 

It would save me A LOT of time and work

 

Thank you in advance

[topbeanbags 1]

Can it be made to update reference number of attribute combinations??

[testuser0001 0]

Deleted because I fixed it with the search function.    

Edited January 3, 2016 by testuser0001 (see edit history)

[testuser0001 0]

Good work! I have some minor fixes though.

Currency fix (shows default currency sign):

function getConfig(){    $currencies = Currency::getCurrencies();    $default_currency = Configuration::get('PS_CURRENCY_DEFAULT');    foreach ($currencies as $currency) {        if ($currency['id_currency'] == $default_currency)            $sign = $currency['sign'];    }    $weight_units = strtolower(Configuration::get('PS_WEIGHT_UNIT'));     $main_product_fields = array(         "price"=>array(             "db_field"=>"price",             "friendly"=>$this->l('Price'),             "prefix"=> '(' . $sign . ')',         ),         "weight"=>array(             "db_field"=>"weight",             "friendly"=>$this->l('Weight') . " ($weight_units)",         ),         "quantity"=>array(             "db_field"=>"quantity",             "friendly"=>$this->l('Quantity'),         ),         //add more, eg: quantity, here.     );     return $main_product_fields;}

Language fix (Note that it will still work for one language only):

At the very to of updateProducts() function:

$language_id = Configuration::get('PS_LANG_DEFAULT');

Do the same for getContent() function.

Then near the end of updateProducts() function remove the

$language_id = 1;

getContent() function:

There are 2 SQL statements in it. Look for:

fl.`id_lang` = 1

Change it to:

fl.`id_lang` = '.$language_id.'

Then in the second SQL statement look for:

pl.`id_lang` = 1

Change to:

pl.`id_lang` = '.$language_id.'

Then look for this line:

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

Change it to:

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

That should do it.

Also, if you have a lot of product attributes, table stretches too much, you can do this to fix this issue:

Look for <table cellspacing="0" cellpadding="0" class="table space" width="98%" align="center">

Select whole table (everything betweentags) and replace it with this code:

<table cellspacing="0" cellpadding="0" class="table space" width="98%" align="center">    <tbody>        <tr>            <?php $product_rowspan = sizeof($main_fields) + sizeof($feature_results) + 1; ?>            <th width="1%"><?= $this->l('Product');?></th>            <th colspan="2"><?= $this->l('Accessories');?></th>        </tr>            <?php foreach($all_products as $product){                $product['price'] = $product['db_price']; // price hack            ?>          <tr>            <td rowspan="<?=$product_rowspan?>" width="1%" valign="top" nowrap>                <a href="?tab=AdminCatalog&id;_product=<?=$product['id_product'];?>&updateproduct;&token;=<?=Tools::getAdminToken('AdminCatalog11');?>"><?=$product['name'];?></a>            </td>       </tr>       <? foreach($main_fields as $m=>$f){ ?>       <tr>           <td><?=$f['friendly']?> <?=$f['prefix'];?></td>           <td>               <input type="text" style="width: 90%;" value="<?=$product[$f['db_field']];?>" name="mup[<?=$product['id_product'];?>][<?=$f['db_field'];?>]"/><?=$f['suffix'];?>           </td>      </tr>       <? }      foreach($feature_results as $k=>$v){           // what value is in this feature?      $feature_value = '';      foreach($product['features'] as $f){          if($f['id_feature']==$v['id_feature']){           $feature_value = $f['value'];          }     }       ?>        <tr>           <td><?=$v['name']?></td>           <td>               <input type="text" style="width: 90%;" value="<?=$feature_value;?>" name="mup[<?=$product['id_product'];?>][ff][<?=$v['id_feature'];?>]"/>           </td>       </tr>        <?php         }     }        ?>         </tbody></table>

The last one will make your table longer (or higher, if you wish).

Please test this on your local machine first, I'm a human, so I might have forgotten something

 

 

I have done all these steps and still I see no products displayed. I am using PS 1.6.1.0 with language id 6.

 

What could I be doing wrong? The search function didn't help me here

[emhava 1]

Nice script, thank you.

i try to add this:

			"unit_price_ratio"=>array(
	 			"db_field"=>"unit_price_ratio",
	 			"friendly"=>"Unit Price Ratio",
	 		),

but my Unit price ratio doesn't change.

 

How to do this? i work on PS 1.6.1.4