Product categories import problem – how to order

  • Resolved leanneoleary

    (@leanneoleary)


    2 years, 8 months ago

    I imported over 200 categories from another site (not wordpress) using webtoffee import/ export. There was no option to import the ordering of the categories but I thought I would easily solve this once they were all imported.

    However, the IDs have not been kept the same after the import and it is not clear how to match the new taxonomy_id with the object_id so I can amend the term_order in the term_relationships table.

    Also, is not easy to reorder over 200 categories manually in the admin panel. In fact it seems impossible.

    Can you suggest a way for me get these reordered correctly?

Viewing 4 replies - 1 through 4 (of 4 total)

  • Hello,

    Webtoffee import/ export is a third party plugin which we are unable to provide support for in this particular forum. I’d suggest reaching out to the plugin developer directly for further assistance: https://www.webtoffee.com/support/

    Also, is not easy to reorder over 200 categories manually in the admin panel. In fact it seems impossible.

    You can go to Screen Options and change Number of items per page to show all your categories. Once that’s done you can drag and drop to reorder categories manually.

    Link to image: https://snipboard.io/VDrT0w.jpg

    Thread Starter leanneoleary

    (@leanneoleary)

    Thankyou for your reply.

    I understand its a third party plugin, but I was hoping for some information on how the tables are linked for the product categories so that I could perform an update using SQL query myself.

    Re-ordering 200 categories manually, even with all categories displayed on one screen would be difficult, but not impossible.

    Mirko P.

    (@rainfallnixfig)

    Hi @leanneoleary,

    There doesn’t seem to be an easy way to do this via SQL as product categories exist in at least 5 different tables within the database. However, note that this falls outside our scope of support on this forum.

    There is a free plugin here that has a simplified UI and will do the job making it easier to rearrange product categories.

    * https://www.ads-software.com/plugins/taxonomy-terms-order/

    If the plugin doesn’t work or if you want to achieve this with customization, we’d recommend hiring a customization expert listed at https://woocommerce.com/customizations/.

    Cheers.

    • This reply was modified 2 years, 7 months ago by Mirko P..
    Mirko P.

    (@rainfallnixfig)

    Hi there,

    We’ve not seen any activity on this thread for a while, so I’m marking this thread as resolved.

    Feel free to start a new thread if you have any more questions.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Product categories import problem – how to order’ is closed to new replies.