X-Cart forums

[tls]

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.

[qualiteam]

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.

[tls]

Thanks, I'll try that.