Jump to content

(SOLVED) Change products price at once


Recommended Posts

Hello, is there a way, maybe in the database, or other place, to change several prices at once, I have 280 products and almost 200 has the same price, I need to change them all, but I dont want to do it 1 by 1, can I do it, all at once? Please glad if you could help me

Link to comment
Share on other sites

You may use the Import tool (tab Tools/Import)

You can import a CSV file of 2 columns :
first for id_product (that must be the same than the one you see in your catalog)
second for the new price


How can I make that only changes the price but keep the descripction, name and all that? Ive just tried and replace one product with the new price, but with other name and no description
Link to comment
Share on other sites

Sorry for the advise for admin import that is not working.
You should have a 3 columns CSV : ID;name;price
and select the correct columns during import.
But testing, I had problems, import seems having some bug for such use.

You can look :
- search the forum about bulk or mass update
- search in prestatools.com for free contribution.
Or try this one (never tested personnaly)
http://www.prestashop.com/forums/viewthread/14679/P165/modules___development/mass_update_module

Link to comment
Share on other sites

Here you go...
I have attached the module that I use on my Prestashop version 1.2.5
It's great and basic as all I ever need to change is description and price.

Regards,


Hi ive just installed the module, and dont see where to access to it, whenever I click configure once installed I dont see my products, where do i exactly access to this tool after installed
Link to comment
Share on other sites

Lo there,

Is this module installed but you click the configure button and nothing happens?
Is this module installed but you click the configure button and it loads to the config screen but you don't see any products?
Is the module not installed properly so you can't see it in your backoffice?

I attached a pic of how it looks inmy backoffice/modules...

Regards,

16901_NpXLzVaHCCdt5YcOiP6x_t

Link to comment
Share on other sites

  • 4 weeks later...

WOW, what a useful module. Thank you for your contribution, Mandrin. It could have same me a lot of time if you had found it earlier.

is it possible to add product ID to the table? It would be easier to use ID instead of product name. Some of my game accessories products share similar names. You could easily mix product up and enter wrong info.

Link to comment
Share on other sites

  • 3 months later...
  • 1 month later...
  • 2 months later...

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...