Rating 5 stars - 1 votes

Change Product Position in Category in Magento 2 via Import/Export

Default import/export method does not allow to change product position in category in Magento 2 using CSV file. It is possible to do it manually for each category in Products-> Categories -> Products in Category -> set position ‘from’ and ‘to’. This approach is helpful and easy when you have a few products per category. In case you have large inventory, manually sorting options in category manually may be cumbersome. Especially, taking into account that default sorting allows up to see 200 per page. If you have more products, you need to switch between the pages.


Instead of this, we offer you a quick way to change product position in category in Magento 2 using import/export functionality available in Store Manager for Magento application. In this tutorial will be demonstrated how to update sort order of products within the category in bulk, having in file only 2 fields: identifier (SKU, ID, EAN etc) and position.

Download 14-day version free to try it out!

Download Free

Get CSV Prepared for Product Positioning

It is the initial step of the procedure. The easiest way to get CSV with product data is export.


Hint! You can run export by category, selecting appropriate filter before the procedure.


  1. Launch Product Import/Export and select ‘Export’.


  2. Choose directory where exported file will be saved on your PC.


  3. If prior to export you have filtered or selected the products to be brought to CSV, indicate corresponding option at this step. Otherwise check option so that all goods to be exported.


  4. At the next step you can change column and information delimiters if you have some specific configuration or leave everything as it here and proceed next.


  5. Select fields to export by simply dragging and dropping necessary ones from the left pane to the right or use navigation buttons in the middle. Basically you need 2 fields: identifier (ID, SKU, EAN code or any other unique value) and ‘Position in a category’.


  6. Note! If your goods are assigned to a few categories, it is advisable to export also field with ‘Category Path’ to visually see positions per corresponding category.

  7. Preview result and hit ‘Finish’. You can use the option to open CSV right after procedure to continue with its editing.


Use Import to Change Product Position in Category in Magento 2

Now when you have CSV file with necessary data generated, you can simply make changes in the position column and re-import the file again.



Note! If in your file in ‘Position in a category’ there are multiple values divided by separator symbol (pipe by default), it means that the product is assigned to more than 1 category and you can indicate sorting position per each.

Run Import/Export -> Import and proceed with the following actions:

  1. Select file with changes to be applied.


  2. Preview it and make sure that the data are displayed correctly.


  3. If you have not made edits to column headers, they should be automatically mapped to database fields.


  4. If you are importing position, let’s say together with new product data in suppliers file you can link necessary fields yourself.


  5. Select import method to add new products with set positions or update existing ones and hit ‘Import’.


Here you go! Store Manager for Magento extends functionality offered by default Magento.


Update Magento 2 Product Positions Massively Using CSV!

Try Now

COMMENTS
Be the first to comment.