If this is your first visit, check our documentation. To post, register or login.
Forums / Setting Up Categories, Products, Attributes / bulk modify category names?

bulk modify category names?

Locked

Started by limousin on 13 May 2010, 7:55 AM · Views: 895

Results 1 to 5 of 5
This thread is locked. New replies are disabled.
13 May 2010, 7:55 AM
#1
limousin avatar

limousin

New Zenner

Join Date:
Nov 2008
Posts:
20
Plugin Contributions:
0

bulk modify category names?

Hi all,

Can anyone tell me if it is possible to modify a bulk of category names in one go.

my situation.

I have uploaded a csv file from my supplier but it is French and I want to have all the categories/sub categories in English, now I know I can change them manually but changing 500+ category names will take some time and it has to be done regularly to modify the stock levels pricing etc.

What I want is a way of typing it all up once and then to run a command to implement the changes e.g

change informatique to computing and so forth.

Hope this is clear and hope someone can help me.

something tells me its going to be with the use of sql or easy populate but some nice clear instructions would be great either way.

Many thanks:smile:

Dave

13 May 2010, 9:18 AM
#2
kobra avatar

kobra

Black Belt

Join Date:
Aug 2005
Location:
Arizona
Posts:
31,500
Plugin Contributions:
4

Re: bulk modify category names?

Change you csv first

Zen-Venom Get Bitten

13 May 2010, 11:22 AM
#3
limousin avatar

limousin

New Zenner

Join Date:
Nov 2008
Posts:
20
Plugin Contributions:
0

Re: bulk modify category names?

Hi, thanks for the suggestion but that doesn't help me, in fact it would be harder as I have around 25,000 entries in the csv, 10 categories and in them around 500 sub categories.

I update the csv file regularly so would hve to modify the 25,000 entries every time.

I need to be able to write up all the original category names / new category names and have something that can implement the change every time i reload the csv.

Hope this makes sense.

15 May 2010, 6:52 AM
#4
limousin avatar

limousin

New Zenner

Join Date:
Nov 2008
Posts:
20
Plugin Contributions:
0

Re: bulk modify category names?

Hi, thanks for that, sounds interesting and sort of right but I am concerned that products change all the time and so as you say, new products will be added but wont know where to go so I will still have to go through every week and organize anywhere from 10 - 1000 products.

I am sure there must be someone on here that knows how to make this work with mysql command.

in theory it sounds so simple but I am not very good with sql.

I presume I could write a sql / text file translating all the french categories to english and then using a command? change to?

e.g

CHANGE COMPUTERS TO COMPUTING
CHANGE PRINTERS TO PRINTING
CHANGE SOFTWARE TO PROGRAMS
ETC ETC

please help.

Thanks again hoping for a solution soon.:smile:

15 May 2010, 7:17 AM
#5
tino_schlegel avatar

tino_schlegel

Totally Zenned

Join Date:
Nov 2007
Location:
Melbourne, Australia
Posts:
532
Plugin Contributions:
0

Re: bulk modify category names?

The easiest is to use excel. Why would you mess with mysql when you can use excel to to the job.

Replace ALL occurrences of COMPUTERS with COMPUTING in your excel sheet
And so on.

When you are done, upload the new excel file and thats it. Cant do it easier with mysql