Import sort order
 

I have hundreds of items in several categories that need to sort a certain way.(by SKU) It is a huge amount of work to use the numbers on the left side to get them into the right order. But it's easy for me to make a spreadsheet in the right order with a column showing the sort order number.

Is there a table that holds this data? I can use PHPmyadmin to import the data, but I can't figure out where the data is.

Re: Import sort order
 

I think you may try to update the "orderby" column in the "xc_category_products" database table.

But create a full backup of your website first, just in case something goes wrong.

Re: Import sort order
 

Thanks, I'll try that.