If this is your first visit, check our documentation. To post, register or login.
Forums / Setting Up Categories, Products, Attributes / Category - Product Reorganization

Category - Product Reorganization

Started by dave224 on 15 May 2022, 4:06 PM · Views: 1,487

Results 1 to 4 of 4
15 May 2022, 4:06 PM
#1
dave224 avatar

dave224

Zen Follower

Join Date:
Jun 2012
Posts:
481
Plugin Contributions:
0

Category - Product Reorganization

I'm thinking about reorganizing categories/subcategories and the products within them. Can anyone provide tips on how to best accomplish the reorganization? Is the best approach to build a new store? Or are there other techniques that hopefully are easier, maybe by editing the products_to_categories, categories, and categories_description tables?

Two of 11 current top level categories need reorganization. The others do not need to be changed. The two top level categories that need reorganization have multiple subcategories. The subcategory titles and the products contained within them will need to change. As an example, the products currently in subcategory A will need to be separated and moved into newly named subcategories A' through say F', etc. The number of subcategories in each reorganized top level category will change from the current number, and the number of products in each subcategory will change, but the products themselves will not be modified, only their location in the category structure. Some of the products have attributes, and the inventory for some of them are tracked by the Products with Attributes Stock (SBA) plugin.

TIA for any tips/advice.

Dave
zc157c, PHP 8.0.2, mysql 8.0, lots of plugins and customization

15 May 2022, 7:23 PM
#2
lat9 avatar

lat9

Administrator

Join Date:
Sep 2009
Location:
Stuart, FL
Posts:
14,140
Plugin Contributions:
56

Re: Category - Product Reorganization

Are you using an "URL Mangler", e.g. Ceon URI Mappings or Ultimate SEO URLs?

15 May 2022, 7:27 PM
#3
dave224 avatar

dave224

Zen Follower

Join Date:
Jun 2012
Posts:
481
Plugin Contributions:
0

Re: Category - Product Reorganization

I am not using a URL mangler.:D

16 May 2022, 10:26 AM
#4
lat9 avatar

lat9

Administrator

Join Date:
Sep 2009
Location:
Stuart, FL
Posts:
14,140
Plugin Contributions:
56

Re: Category - Product Reorganization

There's also the URL Redirection Manager (https://www.zen-cart.com/downloads.php?do=file&id=2152) which, IIRC, needs some work to run under current (i.e. 7.4 and above) versions of PHP, but it might help to get customers who have bookmarked the old product links to a product's new home.