Jump to content

Mass Update Module


dtbaker
 Share

Recommended Posts

Well, I installed this module and now I can't delet it. Do anyone knows how can it be deleted?
Oh...and of course I know how to delet a module, done it a "thousand" times, but can't seem to delete this one...:-S

If someone can help me, it will be highly apreciated.

Thank's

Share this post


Link to post
Share on other sites

And do you think I haven't tried that already? I've deleted it directly, trough ftp, trough the back office, trough the control panel, but nothing. And this after I tried to edit the files so that I could make the corrections, and as I saved them, it would appear an error. I've changed de CHMOD and still nothing.
Yes, I know, this is very strange, first time happening to me too, I've done this procidure with several modules but this one seems to have glue!

Share this post


Link to post
Share on other sites

Hi Everyone,

I would like to add others fields, but I don't know how I can find the db_field & the friendly of the field I would like to add :
- buying price wo VAT
- selling price wo VAT
- Rebate

Furthermore, do you think it's possible to install the module 2 times ? One to manage the stock, one for the price. The objective is to avoid to have to much fields for each items...

Tks

AP

Share this post


Link to post
Share on other sites

And do you think I haven't tried that already? I've deleted it directly, trough ftp, trough the back office, trough the control panel, but nothing. And this after I tried to edit the files so that I could make the corrections, and as I saved them, it would appear an error. I've changed de CHMOD and still nothing.
Yes, I know, this is very strange, first time happening to me too, I've done this procidure with several modules but this one seems to have glue!


Uhm... sorry than i dont know how to help you then... this is probably some database error...

PS: try rename?

Share this post


Link to post
Share on other sites

Hi,

I have a BIG issue with this plugin.
I updated all my price good everything look OK.
But after browsing my site all my features on each products had disappear !!!
Back to my BO I can still see all my feature listed in the Mass Update module but not in the feature tabs of my products :( :( :(

Any idea of what happened ?

Julien

Share this post


Link to post
Share on other sites

It seems that for some people this module works wonders, and for others, it ruins a lot of work.
In my case, I'm still waiting for some miracle to be able to delete this module from my database. Tried everything, it stik's with you, litteraly...

Share this post


Link to post
Share on other sites

Great work, it's working perfect for me.
Any way to have the option of selection or sorting by name, reference?
Because I have a big list of products and and to find them is very complicated for me and the customer without much knowledge.

Share this post


Link to post
Share on other sites

If you cannot delete it from your server or change permisssions I suggest raising a support ticket with your webhost. Maybe you have either ftp and web running as two distinct users. I am just a user, not a techie but my understanding from having solved similar issues is that here are two possible solutions:

1) Get your host to change the file permissions so that ftp and php share the same group even though the user is different.
2) (better) Run it on a server equipped with suPHP so that you run php as the owner. This solves most permissions problems. The link is: http://www.suphp.org

hth
David

Share this post


Link to post
Share on other sites

  • 3 weeks later...

Hi all,

I have just installed this module and tried to use it but - after pressing SAVE button - no amendments take place and all changed values return to the former ones I had before the change....

Any idea how to fix that?

Many thanks!

EDIT: What I meant was the QUANTITY value, all the rest is changed successfully.

Share this post


Link to post
Share on other sites

  • 2 weeks later...

If you are looking for a way to do mass upload and download etc etc There is a great module for sale at the prestashop HOWEVER if you are looking for a free way of doing it then read on (Try and donate to the prestashop team and they will no doubt develop it)

Install Navicatpremium – 30 day free trial but can purchase if you like. You can edit tables in real time so ne need for running SQL Queries (This is by far the easiest and cheapest way for 30 days ;O)

Navicat is here – http://www.navicat.com/en/products/navicat_premium/premium_overview.html

Share this post


Link to post
Share on other sites

Ok so here we go....

1. Download the software and save to desktop or another folder of your choice.
2. Install the software (Double click what you have just downloaded and it will guide you through.
3 Once installed open software and click on "connection" Choose the type of database you are using. I am assuming that most will be MYSQL
4. Input details

Connection Name - your choice
Host name/IP address - something like 213.171.200.59 (Your hosting company should give you this if you need it)
Port - 3306
Username - Your username that you set up for the database
Password - Your username that you set up for the database

Ok so you should be connected to the database by now.

NEXT........

double click the database you want to show tables of, you will see all the table appear.

Next step is as simple as ABC choose the table you want to see ie for product descriptions you need ps_product_lang

The rest is just like using EXCEL

Is this usefull?

Share this post


Link to post
Share on other sites

many thanks for your prompt answer!

wow, that really seems to be extremely useful tool, speeding up your laborious work! and it appears to be simple as well...

one question though.
let's say I have 10 categories, each containing 100 products that vary only according to their dimensions. i have an attribute called SIZE (a choice of 3 is available: medium, large & extra large), however all my products have different dimensions which means "medium" size of one is always different from another's article size "medium".

do you think the Navicat would allow me to ADD products in the application itself first and then upload them to my prestashop database?
for example - i create all my categories, define attributes and add only ONE product through Presta but would then like to do the rest (adding few hundred more products, setting their price [for all available sizes] etc) within the app and then just import all to database when ready.
i have a "colour" and "orientation" attributes as well but these refer to all my products the same way and do not affect the price.

so it would be fantastic if i could, like you say - edit/add my products through this excel-like software, define all their attributes and features, then import to my database and finally only upload pictures for each separate product.

would it work that way?!? :)

Share this post


Link to post
Share on other sites

Hi, Yes you can do this and probably the best way is and this is the beauty of this bit of software you can exort as CSV then upload the CSV file vie admin back end on your website via the import facility.

To export a CSV file
1. Choose tables you require (You may need to open a few just see whats in them and then if you need to select that file)
2. Right click and then export (make your choices ie Export as Excel)
3. it will then start the export wizard.
4, Your done edit the tables then upload via admin back end of your website.

The other way is as you say edit them through Navicat.

To edit/ADD new products etc.
1. click the table you want to edit/add items to.
2. Go to bottom of the table (ie ps_product) you can go to bottom left click once in the far bottom left box and press the down arrow (You will see this has added another line (Edit as you want.

BE CAREFULL DOING IT THIS WAY!!!! I in no way take responsability if you do something wrong. 1st way is def the best. however not the easiest.

Share this post


Link to post
Share on other sites

sorry but i'm not sure i can see the difference... so you don't edit your tables through Navicatpremium using the first way? you still need to export your changed table using second method, right? i'm confused now :|
and yeah, i will back-up my database before going for that experimental 'brain surgery' ;)

Share this post


Link to post
Share on other sites

The difference is as follows:

First Way
This is exporting the individual table out of navicat and allowing you to change things using Excel away from the database (so you are not real time uploading)

Second Way
This is ding it within Navicat and is changing the data as you change it (Real time)

Share this post


Link to post
Share on other sites

Question:

Is there a problem with this module when using PS Beta 1.2 ?

Error in massupdate.php line 256

<?php

$this->_html .= ob_get_clean();


Then the module starts, but I get lots of strange errors.

???????????

Share this post


Link to post
Share on other sites

The "Mass Update" spreadsheet style update plugin has been created, you are more than welcome to test it.

!http://dtbaker.com.au/code/prestashop/mass_update.jpg!

Install instructions:
* Go the PrestaShop Modules page
* Click Add New Module
* Copy & Paste this url: http://dtbaker.com.au/code/prestashop/massupdate.tar
* Enter your admin password
* Click "Install this module"
* Click install again next to "Mass Update" (in the Products section)
* Then click "Configure" to see the spreadsheet style product editor.


Note: price bug has been fixed


Question: I don't see where to click install again (in the Products section). Please help. Module install said sucessful, but don't know where to proceed.

thank you!

Share this post


Link to post
Share on other sites

Gadgetgal,

You have now installed the module (sucessful) so now it's placed in the list below as among all the other modules you have. Find the module in the list and click on the install botton on the right side to install (aka activate) Now the word "configure" will appear. click on the word and you will get into the mass-update section.

Hope you get this, if not post your errors.

/Henrik

Share this post


Link to post
Share on other sites

Well it should be there (;O) but like all other software, it is not perfect..

It should be placed under "Products" like in my enclosed picture. If not try to find it via FTP the the modules folder.
Then delete it, reboot your backweb, unpack the *tar file and upload the massupdate map to the module folder.


/Henrik

10096_kGrsz3ZqdJt9v6YNtX00_t

Share this post


Link to post
Share on other sites

Well, I don't even have a "Products" module category. Could this be part of the problem? I'll do the ftp delete and see what happens, but was wondering on the module area. I have never been able to get the "install" button on anything. : (.

thanks!

Share this post


Link to post
Share on other sites

  • 2 weeks later...
  • 2 weeks later...
Hello and thanks for this module
But i have a big problem
I put a quantity to 1 or 2 or 999 : Very nice
If i put a quantity = 0 : the update is not OK, the quantity is not update

So it seems if you try to update with a quantity = 0 : the update is wrong

Is there someone have a solution ?
---------------------------------------------------------------------------------------
Merci d'excuser mon trres mauvais anglais, i'm French :)
Donc si j'essaie de mettre des quantités à 0, ma modification n'est pas prise en compte lors de l'enregistrement
alors que je n'ai aucun problème avec d'autres valeurs
Est ce que quelqu'un aurait une solution ?
Alors que si je vais mettre à 0 dans la fiche produit .... massupdate me restitue bien ce 0 dans la quantité ......

Merci de votre aide


Hi Alexguerrin

If you want to put "0" use "-"
The quantity will be updated !

----------

Salut si tu veux mettre zéro dans la quand utilise "-" (tiret du 6)
Ca marche chez moi :)

Share this post


Link to post
Share on other sites

Currently I try to find a way to put a link to the catalog tab for example instead of the module tab.
Because I don't really want give access to the module tab.

I wil tell you asap

Share this post


Link to post
Share on other sites

  • 2 weeks later...
No it works perfectly in V1.2


Hello folks, i got a few questions: poeople who installed this module on 1.2.2, what kind of server has?Win or Linux?Because on FC 10 (linux) does not displaying nothing, only configure and not querry DB....In windows it querry DB but it hangs on please wait.....updating..."Any help would apreciated!

Share this post


Link to post
Share on other sites

Hi everybody and many thanks for this loveless module. It's sounds pretty good but i have an error (repeat and repeat) when i try to configure it

NB i'm on 1.2 SVN 667

Notice: Undefined index: rate in /var/www/vhosts/mysite/httpdocs/mydir/classes/Product.php on line 1135

Notice: Undefined index: id_image in /var/www/vhosts/mysite/httpdocsmydir/classes/Product.php on line 1779



An idea ?



That is a notice, not an error!
Disable warning display from php.ini and will work fine

Share this post


Link to post
Share on other sites

I have been fiddling around with the code and managed to sort this out... i think... please please please make sure you back up your database... I would hate that my changes end up messing up someone prices....

This worked ok for me

massupdate.php

find all instances where the php short tag has been used

<?

replace with

<?php



where you find

<?=

replace with

<?php echo

Share this post


Link to post
Share on other sites

I have been fiddling around with the code and managed to sort this out... i think... please please please make sure you back up your database... I would hate that my changes end up messing up someone prices....

This worked ok for me

massupdate.php

find all instances where the php short tag has been used
<?

replace with

replace with

<?php echo



where you find[code]<?=

Thanks for your fixed

but find
<?

replace with

<?php


Thanks again it work with 1.2.4

Share this post


Link to post
Share on other sites

  • 2 weeks later...

Dear all,

I have an issue with the stock update :
When I change from 5 to 2 for exemple, it's ok, it works well, but if I want to switch to 0 (null), the update is not integrated. It's only the case with 0, and for stock.

Are you aware about this issue ?

Tks !!

AP

Share this post


Link to post
Share on other sites

  • 2 weeks later...

Hi, for everyone who want to add reduction price and reduction %

add after:
//add more, eg: quantity, here.

following code:

    "reduction_price"=>array(
                "db_field"=>"reduction_price",
                "friendly"=>"Reduction price",
            ), 
               "reduction_percent"=>array(
                "db_field"=>"reduction_percent",
                "friendly"=>"Reduction percantage",
            ), 



This was quite easy as field are in the same DB table (product). But I would like to add also price with tax. This was required by another users. If someone figured it out, can you please share?

Share this post


Link to post
Share on other sites

Hi, for everyone who want to add reduction price and reduction %

add after:
//add more, eg: quantity, here.

following code:

    "reduction_price"=>array(
                "db_field"=>"reduction_price",
                "friendly"=>"Reduction price",
            ), 
               "reduction_percent"=>array(
                "db_field"=>"reduction_percent",
                "friendly"=>"Reduction percantage",
            ), 



This was quite easy as field are in the same DB table (product). But I would like to add also price with tax. This was required by another users. If someone figured it out, can you please share?


Thanks for share,

Share this post


Link to post
Share on other sites

  • 2 weeks later...

I'm getting this error:

Notice: Undefined index: rate in /srv/www/vhosts/javimedia.nl/httpdocs/shop/classes/Product.php on line 1940 Notice: Undefined index: rate in /srv/www/vhosts/javimedia.nl/httpdocs/shop/classes/Product.php on line 1955 Notice: Undefined index: id_image in /srv/www/vhosts/javimedia.nl/httpdocs/shop/classes/Product.php on line 1915 Notice: Undefined index: rate in /srv/www/vhosts/javimedia.nl/httpdocs/shop/classes/Product.php on line 1940 Notice: Undefined index: rate in /srv/www/vhosts/javimedia.nl/httpdocs/shop/classes/Product.php on line 1955 Notice: Undefined index: id_image in /srv/www/vhosts/javimedia.nl/httpdocs/shop/classes/Product.php on line 1915 Notice: Undefined index: rate in /srv/www/vhosts/javimedia.nl/httpdocs/shop/classes/Product.php on line 1940 Notice: Undefined index: rate in /srv/www/vhosts/javimedia.nl/httpdocs/shop/classes/Product.php on line 1955 Notice: Undefined index: id_image in /srv/www/vhosts/javimedia.nl/httpdocs/shop/classes/Product.php on line 1915 Notice: Undefined index: rate in /srv/www/vhosts/javimedia.nl/httpdocs/shop/classes/Product.php on line 1940 Notice: Undefined index: rate in /srv/www/vhosts/javimedia.nl/httpdocs/shop/classes/Product.php on line 1955 Notice: Undefined index: id_image


Please help!

pretorian83@gmail.com
http://www.javimedia.nl

Share this post


Link to post
Share on other sites

Not displaying combination's price
Hi,

I've different combinations for my products but when i use Mass update module, the combinations are not shown. Can someone please add this functionality??
Alternately can someone advise me how to be able to update the "impact on price" for a combination in terms of percentage of original product price so that when i update the price of a product, the price of the combination changes accordingly.

Regards
Pankaj

Share this post


Link to post
Share on other sites

Is there someone who can help me ???

I'm getting this error:

Notice: Undefined index: rate in /srv/www/vhosts/javimedia.nl/httpdocs/shop/classes/Product.php on line 1940 Notice: Undefined index: rate in /srv/www/vhosts/javimedia.nl/httpdocs/shop/classes/Product.php on line 1955 Notice: Undefined index: id_image in /srv/www/vhosts/javimedia.nl/httpdocs/shop/classes/Product.php on line 1915 Notice: Undefined index: rate in /srv/www/vhosts/javimedia.nl/httpdocs/shop/classes/Product.php on line 1940 Notice: Undefined index: rate in /srv/www/vhosts/javimedia.nl/httpdocs/shop/classes/Product.php on line 1955 Notice: Undefined index: id_image in /srv/www/vhosts/javimedia.nl/httpdocs/shop/classes/Product.php on line 1915 Notice: Undefined index: rate in /srv/www/vhosts/javimedia.nl/httpdocs/shop/classes/Product.php on line 1940 Notice: Undefined index: rate in /srv/www/vhosts/javimedia.nl/httpdocs/shop/classes/Product.php on line 1955 Notice: Undefined index: id_image in /srv/www/vhosts/javimedia.nl/httpdocs/shop/classes/Product.php on line 1915 Notice: Undefined index: rate in /srv/www/vhosts/javimedia.nl/httpdocs/shop/classes/Product.php on line 1940 Notice: Undefined index: rate in /srv/www/vhosts/javimedia.nl/httpdocs/shop/classes/Product.php on line 1955 Notice: Undefined index: id_image


Please help!

pretorian83@gmail.com
http://www.javimedia.nl

Share this post


Link to post
Share on other sites

Which other columns?? Were u able to see the combinations' prices?? If yes, can u please send me the code?


for example:

$main_product_fields = array(
            "price"=>array(
                "db_field"=>"price",
                "friendly"=>"Price",
                "prefix"=>'$',
            ),
            "weight"=>array(
                "db_field"=>"weight",
                "friendly"=>"Weight ($weight_units)",
            ),
            "link_rewrite"=>array(
                "db_field"=>"link_rewrite",
                "friendly"=>"link_rewrite",
            ), 

Share this post


Link to post
Share on other sites

I don't understand....How to update combination prices? Do you think it? ...

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



I know, prices, id and other number is not problem. But I have problem with add column with text (name, destription, ...)
I added column "name"...it's all right, but is not possible save changes

Share this post


Link to post
Share on other sites

I don't understand....How to update combination prices? Do you think it? ...

I know, prices, id and other number is not problem. But I have problem with add column with text (name, destription, ...)
I added column "name"...it's all right, but is not possible save changes


Name, description etc are stored in product_lang table, but mass update module updates product table only.

Share this post


Link to post
Share on other sites

Attached please find massupdate.zip, which contains updated version from post #67.

Changes:
1) new key in main_product_fields array - isLang - allowed values are 0/1. If isLang=0, field will be updated in product table. If isLang=1, field will be updated in product_lang table. Updater updates records in the current language only (according to id_lang cookie)!
2) another new key in main_product_fields - input_size - this alters "size" attribute of the <input> tag.

Example of main_product_fields:

            ...
            "name"=>array(
                "db_field"=>"name",
                "friendly"=>"Name",
                "isLang"  => 1,
                "input_size" => 20,
            ),
            "weight"=>array(
                "db_field"=>"weight",
                "friendly"=>"Weight ($weight_units)",
                "isLang"  => 0,
                "input_size" => 3,
            ),



Code is not thoroughly tested. I've tested it on few products only. Please backup before use.

massupdate.zip

Share this post


Link to post
Share on other sites

Is this last ZIP posted a complete working update based on this entire thread?

i only need to update prices (inc tax) and active/inactive. But have about 3600 products. Has the pagination been added? has the filter by category been added?

Thanks Rob

//// ************** \\\\

Okay so I installed it and went to configure it and there is no possible way this will work for carts that have thousands of products without pagination or categorical selection. I started loading and then just crapped out. Locked up my browser and slowed my already slow internet down to the days of dial up. I forced closed the browser after 10 minutes of waiting.

Can the pagination be added? I do not have the know how to do it, but I believe we would all benefit from this if it could be accomplished. I would venture to say that it would solve the problem of not saving changes at the end of the list (read in earlier thread that after 150 it does not save). I might be out of line, but surely it is possible to copy the sort, and page/results size from other areas of presta shop (Orders, Carts, Catalog) without much modification?

In the same way using a drop down list of all categories and sub categories to select which one you want to display and edit would be a simple copy from other admin areas that have this feature.

Would be really great if this could be added and a new package with all the fixes and suggestions of this thread be added.

Thanks

\\\\ **************** ////

Share this post


Link to post
Share on other sites

Hi,

Have anyone tried to ad a "Price with Tax"field in mass update module? That would be very handy. I guess it would take more complex programing to achieve this than only adding some standard field such as "reference" or "product name".

Share this post


Link to post
Share on other sites

Hi,
I'm triyng to install it on v1.2.5
but I get following error :
Parse error: parse error in D:\wamp\www\prestashop\classes\Module.php(325) : eval()'d code on line 295
Erreur(s) de parsing dans le(s) module(s)

1. massupdate

any solution ?

Share this post


Link to post
Share on other sites

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 !!

Share this post


Link to post
Share on other sites

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 ?

Share this post


Link to post
Share on other sites

Hi,

Have anyone tried to ad a "Price with Tax"field in mass update module? That would be very handy. I guess it would take more complex programing to achieve this than only adding some standard field such as "reference" or "product name".


Haven't anyone tried to find a solution? Even in paid modules (such as "Bulk product updater") there is no possibility to mass update product prices with taxes.... I've tried to adjust the massupdate module code to have this function, but my PHP knowledge is really basic so no luck there :(

Share this post


Link to post
Share on other sites

  • 3 weeks later...
Not displaying combination's price
Hi,

I've different combinations for my products but when i use Mass update module, the combinations are not shown. Can someone please add this functionality??
Alternately can someone advise me how to be able to update the "impact on price" for a combination in terms of percentage of original product price so that when i update the price of a product, the price of the combination changes accordingly.

Regards
Pankaj


With reference to my above post, I've still got no solution. I'll elaborate on this. Lets say I've a product-X that is available in three possible combinations (or attributes) -
a) 1Kg
B) 500g
c) 250g
The default combination is 1Kg. Therefore the mass updation module shows the price for 1Kg combination against X. What I want is that my mass updation module shows all the three combinations and their corresponding prices so that when updating the price, i can update the price for all the tree combinations.
Hope this makes it clear and hope someone can give me a solution.

16722_asMkrFJRMzQtLmOFL7t2_t

Share this post


Link to post
Share on other sites

Hello,

it's a great tool, but I have some Problems with the names of products!

If I added a product via the copyfunction in PS-catalog and edited the new one ( name, description, price,...), massupdate show me both times the same name. The previous Namechange take no effect (only) in massupdate.

Have anyone an idea?

Thanks!

Share this post


Link to post
Share on other sites