Support Forums

Success · 04-10-2008, 02:05 AM

Are we able to mass move listings of a category to another category?

Very useful when you are reorganizing or changing your classified categories.

Mike-N-Tosh · 04-10-2008, 08:29 AM

That's not a built in function that I am aware of. When I need to do things such as that, I usually just do it in the database itself directly.

A full backup in case something goes awry. An export of the tables that are directly affected in csv format. Then edit the csv file offline. Then an import and voila.

-Mike

juven14 · 04-10-2008, 09:12 AM

This would be easier to do in phpmyadmin, something like this:

UPDATE class_products SET section=2 WHERE section=1

I think the tables have changed in v4 so you would need to identify the proper table for listings. Be sure to backup your database in case this results in unexpected behavior.

***Eric Barnes*** · 04-10-2008, 10:01 AM

Or you could delete the category they are currently in and it will give you the choice as to which category to move them too.

04-10-2008, 02:05 AM	#1
Success Senior Member Join Date: Jul 2007 Posts: 116 Rep Power: 11	Mass Move listings of a category to another category Are we able to mass move listings of a category to another category? Very useful when you are reorganizing or changing your classified categories. __________________ Using V4++ Developer... and loving it.

04-10-2008, 08:29 AM	#2
Mike-N-Tosh 68 Evangelist & Developer Join Date: Jan 2007 Location: Pennsylvania, USA Posts: 1,641 Rep Power: 47	That's not a built in function that I am aware of. When I need to do things such as that, I usually just do it in the database itself directly. A full backup in case something goes awry. An export of the tables that are directly affected in csv format. Then edit the csv file offline. Then an import and voila. -Mike __________________ Mike-N-Tosh IndianaPC.org - A community website (v3.1.10 Developer - heavily modified) Sandbox (v3.1.10, v4.0.9, 4.1.5) Visit My blog for tips, tricks, tutorials, reviews for 68 Classifieds as well as my store with Templates, Mods & Docs Web Hosting \| Web Design & Development \| 68 Classifieds Customizations I am not a 68C employee, just a user and try to help out

04-10-2008, 09:12 AM	#3
juven14 Moderator Join Date: Mar 2006 Location: Texas Posts: 2,221 Rep Power: 61	This would be easier to do in phpmyadmin, something like this: UPDATE class_products SET section=2 WHERE section=1 I think the tables have changed in v4 so you would need to identify the proper table for listings. Be sure to backup your database in case this results in unexpected behavior. __________________ John Snyder PHP Developer

04-10-2008, 10:01 AM	#4
*Eric Barnes* 68 Classifieds Staff Join Date: Mar 2006 Location: Belmont, NC Posts: 5,163 Rep Power: 119	Or you could delete the category they are currently in and it will give you the choice as to which category to move them too. __________________ Eric Barnes 68 Classifieds Developer Please do not send me a private message asking for support. Instead use these open forums or our ticket system. Customer Area \| Issue Tracker \| Documentation \| 68C Mods \| Submit a Ticket \| 68 @ Twitter \| My Modules

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Adding 'category' to 'new listings' display	Chaslie	v3.1 Modules & Modifications	5	01-31-2008 03:31 PM
Main Category search results - include subcategory listings	spaceboy	v3.1 Questions & Support	0	12-10-2007 02:57 PM
How to display category total listings?	dankellaway	v3.1 Questions & Support	2	03-13-2007 01:25 PM
Extrafields to be displayed on the search results and category listings page	objelland	v3.1 Questions & Support	1	01-13-2007 08:50 AM
Displaying extra field in Search and category listings	Bucketman	v3.0 Questions & Support	3	04-26-2006 09:48 AM