Updating category Product position

[bsnmcahi12]

hi i have a CSV file that has SKU and Category Position number for each product.

How can use this CSV to update all the products position value in the category?

is there a PHP script i can run?

Martin

[bsnmcahi12]

i have 1000 products? the only way to update the product position of each one is through the admin panel?

[Store_Manager]

Since no one replied to you for a few days, if you do not mind, I can offer you alternative. There is Store Manager for Magento application that allows to change position of product in the category.  If this is one-time procedure you can use free version (use the link in my signature to download).

If your products belong just to one category you need to have in the file just SKU and position. In case the product is assigned to more than one category, you will need 3 colums - sku, positio and category path.
Here is tutorial -
https://www.mag-manager.com/useful-articles/tipstricks/sort-magento-products-within-a-category/

In case anyone have the script to do the task, please, share.

[BlackQubersdev]

Hi bro,

 No need to specify it one by one. There is an extension available for making the position just by drag and drop from the admin manage categories itself.

Please check the below url 

http://www.magentocommerce.com/magento-connect/product-sorting-sequence-drag-and-drop.html