Rearranging products and categories in osCommerce

After creating categories and products in your osCommerce, you will want to have them organized. You do not have to worry about the order or where they were originally created as you have the ability to transfer them around from within the admin area. Follow the instructions below to learn how to move categories and products in your osCommerce program.

Moving products and categories in your osCommerce admin panel

  1. Log into your osCommerce admin interface.
  2. click catalog menu option

    Under the left hand menu find and click the Catalog button.

  3. From here, select the Categories/Products option.
  4. click the move button

    You are now on the Categories/Products page where you will see products and categories listed. Find the product or category you want to move and click on the name. This will highlight an arrow to the far right and you will see several buttons in the right hand panel. Click on the Move button. In our example, we are going to move the Dog collar product.

  5. select the destination folder for the item

    The right hand panel changes to display a dropdown for you to select the destination category for the move. Highlight the destination in the dropdown and click on the Move button at the bottom. This will move your category or product to the desired location. Below is a before and after display showing the move for the Dog collar from no category to the Dogs category.

    Before After
    before the product has been moved

    after the product has been moved

Thoughts on “Rearranging products and categories in osCommerce

  • If want alphabetical order in any languaje, just need to change Query order in boxes module:

    includes/modules/boxes/bn_categories.php

    change:

    $categories_query = tep_db_query(“select c.categories_id, cd.categories_name, c.parent_id from ” . TABLE_CATEGORIES . ” c, ” . TABLE_CATEGORIES_DESCRIPTION . ” cd where c.parent_id = ‘0’ and c.categories_id = cd.categories_id and cd.language_id='” . (int)$languages_id .”‘ order by sort_order, cd.categories_name”);

     

    For:

    $categories_query = tep_db_query(“select c.categories_id, cd.categories_name, c.parent_id from ” . TABLE_CATEGORIES . ” c, ” . TABLE_CATEGORIES_DESCRIPTION . ” cd where c.parent_id = ‘0’ and c.categories_id = cd.categories_id and cd.language_id='” . (int)$languages_id .”‘ order by cd.categories_name, sort_order”);

     

    Invert that order in any categories queries and  templates modules to. That do the trick !!

Was this article helpful? Let us know!