How To Import/Export Product Position In Magento Easily

    Akshaya Rane
Listen to this article

You want to maximize your conversion rate, right?

There are various ways of optimizing conversion in an e-commerce site. You may have tried some of these already. But do you know that the products’ position also plays a large role in the overall conversion on your Magento site?

By default, Magento provides some easy tool to set this up.

Along with the number of products displayed on the page, you can also edit the order the products display in your storefront. For instance, you may want the products to show according to name, or maybe you wish to list them by the manufacturer. Adjusting the products display order can help your customers find them more easily.

Using the Default Product Sorting Options

Magento provides the following setting to change the order products are displayed – Stores -> Configuration -> Catalog

product position magento

Where to specify this position?

If you navigate to Categories & check any category, it shows details like,

magento product position updateHere, you can specify the position number for products the order in which it should be displayed.

Wasn’t that easy?  Now if you navigate to this category on the front end, the products will be listed as per the position you specified.

An additional feature we can offer…

The default method provided in Magento is ideal when you have less number of products. But when the products are large in numbernavigating to a particular category and then to the desired product to specify a position can get quite tedious for the administrator.

Instead, what we can provide is a general purpose import facility for the administrator. Here, Admin can select any category as like shown on

magento product pos

As per the selection, this interface will then generate a CSV file which will contain details like Category name, Category ID, a list of product names and their current position.

The administrator can now simply make changes in the position column and re-import the file again. And, as per the specified position, corresponding category-product combination position will be updated.

There you go!

How do YOU update product positions in Magento? Let us know your thoughts in the comments below. 🙂

Akshaya Rane

Akshaya Rane

One Response

  1. Hello,
    Can I export the list of the category (or all categories) with the positions and afterwards do the import for different storeview? How does the exported file look like?

Leave a Reply

Your email address will not be published. Required fields are marked *

Get The Latest Updates

Subscribe to our Newsletter

A key to unlock the world of open-source. We promise not to spam your inbox.

Suggested Reads

Join our 55,000+ Subscribers

    The Wisdm Digest delivers all the latest news, and resources from the world of open-source businesses to your inbox.

    Suggested Reads