Back end sort order changed by csv import

I have been correcting product image errors by making the corrections in a CSV file and importing the file.

But after changing the display order of the products in each category (alpha by product name), I just noticed that the latest import reverted the sort order back to the way it was before the back-end changes.

Please could you let me know how the sorting works and if there is a way to enter a sort order column in the corrections csv file to ensure that the sort order does not change from the way it is set in the back end.

Many thanks

Jim

nicolas wrote:

Indeed, there is no ordering handling on the import. That's something we'll have to add in the future.

That's going to be a problem if I need to reorder every time I do a price change which I plan to do using the automated data update process you mentioned last week. Is there a work around in the meantime?

How is the initial order determined. Is it in the order or the original import file?

Would it solve the problem if I exported all the data, deleted everything from the database, and then reimported the data with the main products arranged alphabetically within each category? The default product order within each category should then be alphabetical.

Thanks

Jim

Thanks, Nicolas, that solves all the problems.

Jim

Hi,
I have change the product order in the module in question to sort products by a product column. After that the default option "ordering" disappeared. How can I get it back, cos now want to order the products via "ordering" again.

Thanks

Aleks

oh, I forgot to ask. Is it still impossible to get the product ordering thru the csv import?

I'm sorry, you have misunderstood what I meant.
I did not mean the ordering column in the product listing. I meant the option "ordering" in the select drop down in the product listing module. It's not there since i chose the other option.

With the "category_ordering" you can sort only categories but not products, right?

Aleks