Magento Store Manager Blog

Store Manager for Magento news and announcements

Make Magento Product Prices End in .99

Lots of Magento stores have nice-looking pricing on their products, like "9.99", "204.95" and so on. These smart prices make buyer misjudge the real value of the product, giving the physiological feelling that the price is lower, even though the difference is minimal.

This pricing technique is often called ‘left digit effect’, where customers tend to ignore cents on the right and it subconsciously convinces them to round price down to the total value they see on the left.

How to Set Smart Prices in Magento?

That's easily done as well if you enter prices manually, but let's say if prices in database are daily updated using file from supplier, not all the prices there might look nice for the eyes. Manually checking each product’s price one-by-one and adjusting them to be "presentable" might take considerable amount of time.

Since there is no way to perform operation with default Magento means, you avoid tedious updating prices using Store Manager for Magento application. This is multi-functional desktop solution and one of its capabilities allows rounding and modifying product prices in bulk with a few clicks.

Try price adjusting FREE via Store Manager without obligations!

Make Magento Prices End in Closest 0.99

With Store Manager for Magento we can make massive price modifications to a bunch of selected products with the help of Multi-Editor tool built-in the application.

The only condition is that goods should belong to the sale attribute set.

To adjust Magento prices the steps will be as follows:

  1. Select goods to adjust prices for (from the same attribute set, as was mentioned above). You can use powerful filtering possibilities of Store Manager for Magento.

  2. magento filter products by attribute set

  3. Open Multi-Editors -> Product Multi Editor window from products grid or context menu.

  4. magento edit prices massively

  5. Navigate to Prices tab (or Product Details tab if you use Magento 2) and find ‘Price’ field. Next to it you will see sell with “Expression” caption. Click at the button with three dots to open Expression editor.

  6. magento adjust prices formula

    Expression is the formula that allows you make bulk modifications with the help of various functions. In Expression editor you will see examples of most widely used expressions and useful hints to create formula and check if it is correct.

    We can apply the ROUND function to round a price (as they are usually different) and make it end with .99. To do this you need to use the following formula -

    ROUND([ATTRIBUTE(price)]) - 0.01
    magento prices end 99 formula

  7. Press Ok and tick “Update” box next to price field you modify. After that you will see process logs.

  8. magento edit multiple prices

  9. Check the results.

magento price update logs

95 Versus 99: Choose Price Delta for Adjustment

Another point that may have crossed your mind: why do some companies use .99 and others use .95? Well, this is absolutely individual. Find what works best for you. It’s a good idea to run AB testing to check and see which pricing and discounts trigger your customers to purchase the most.

Try changing some to .99 and see how your customers respond. Then make prices end .95 and then compare results.

By the way, for prices to end .95 the price delta will be 5, so the formula is the following:

ROUND([ATTRIBUTE(price)]) - 0.05
magento price delta

Test out different techniques from time to time to see if your customers’ purchase behaviors change.

Make Your Magento Prices Attractive in Seconds!

Operation Hours During Winter Holidays

eMagicOne Support Schedule

Dear customers,

Joyful festive season is upon us and it means that it’s time to celebrate. Hope you are enjoying every cheerful holiday moment, though if you decide to contact us during this period, here is our working schedule during these days:

Monday January, 2nd - Closed
Friday January, 6th - Limited*
Monday January, 9th - Closed

* Note that during the mentioned period there will be limited staff available and the best method to contact us will be via e-mail.

During the other days not mentioned in the list, we'll be working according to the usual schedule.

It may take a bit longer than usual to get back to you with the support response during these days. We will do our best to make sure your live chats, emails and social media queries are answered as quickly as you expect them to be.

Meanwhile, you will have full access to your licenses and software will be available for purchase

Thank you so much for your understanding.

Happy holidays to everyone!

Welcome 2017! Happy New Year!

2017 is on the way and it is now time to officially welcome it. We are very excited and want to share this feeling with you.

emagicone new year 2017

eMagicOne Team Wishes You Happy New Year!

With this festive holiday mood we wish you to have a great and successful new year ahead!

Moreover, we would like to celebrate with you by offering a gift to our current and future clients:

$50 voucher * - NEW-LVNF-YEAR

*applicable to products starting from $100!

Celebration Time

This promotion is valid till January 10th, 2017!

Thanks for Being With Us!

We want to thank you for growing your business with us this year. It has been a pleasure helping you reach your goals, and we look forward to contributing to your success in 2017.

We wish you all the best in the year to come.

Happy Holidays!


  • 1 order = 1 coupon. Online redemption is required. Coupon is considered as redeemed when an order is completed, funds were charged and the license is generated. In case you apply coupon in the cart and do not complete checkout process, the discount won't be active once the usage is expired. Order is processed within a few minutes. In case your order has not processed yet, please place a new order (in case of duplicate, we will return the duplicated charged sum).
  • This code is not valid with other offers or discounts and cannot be combined with them.
  • The discounts are time-limited and cannot be back-dated after they expire. Unused discounts are not refunded or returned in any way.
  • The discount can only be applied to products starting from $100. All the services will be sold for the regular price.

How to Create Magento Layered Navigation Filters and Simplify Site Search

Customers, browsing your online catalog, are likely to leave it, if they can’t easily find items they are looking for. Whenever your store is abundant in categories and products, it might be time-consuming process to access desired merchandise instantly.

Being a store owner, you should always keep one step ahead to respond to customers’ needs and ensure positive shopping experience. This can easily be fulfilled via Magento layered navigation, as one of the most convenient search tools.

magento layered navigation filters

What is Magento Layered Navigation?

Magento layered navigation is a facility that allows to configure product filters on storefront and makes product search more flexible. It displays at category page and when customer clicks on certain criterion, items matching this criterion within certain category will instantly display in results.

You can add filters by product categories, price range and any Magento attribute in layered navigation.

Setting Up Layered Navigation Filters

1. General Settings

  1. Navigate to System->Configuration->Catalog section in the Admin panel.
  2. Expand Layered Navigation menu and specify the following:
    • Display product count - this option allows to display number of products beside each filter option, so that customers will see how many items exist for each attribute, available in the layered navigation.
    • Price Navigation Step Calculation - this option lets classify the products by price in the navigation. There are three options - Automatic (equalize price ranges), Automatic (equalize product count), Manual. The first two methods allow to calculate ranges automatically, when manual method requires you to set price intervals.

magento layered navigation settings in admin

2. Category Settings

Layered Navigation in Magento depends on category settings. First you have to make the category anchor. Anchor category incorporates products that are assigned to it and all the subcategories. To make the category anchor, proceed with the following actions:

  1. Navigate to Catalog->Manage Categories in the admin panel.
  2. Select the category, Magento layered navigation filters should be available within.
  3. Open category in edit mode.
  4. Switch to Display Settings tab, and set ‘Is Anchor’ option to ‘Yes’.
  5. Save category updates.

magento layered navigation settings in admin

3. Attribute Settings

In order to display attributes in Magento layered navigation you have to configure their properties as it is outlined below.


Attributes of input type ‘Dropdown’, ‘Multiselect’, ‘Price’ can be used in layered navigation for product filtering
  1. Use in Layered Navigation - select ‘Filterable (with results)’ or ‘Filterable (no results)’ in this dropdown.
  2. Use in Search Result Layered Navigation - choose ‘Yes’ in this dropdown.

magento attribute in layered navigation settings


If you have included some attribute in layered navigation and marked it as ‘Filterable (with results)’ but no product in the category has its value assigned, the attribute and assigned value will not display in the layered navigation at all.

If you have marked the attribute as ‘Filterable (no results)’, its values will display in the layered navigation with 0 result even if no product has these values assigned.

If you need to bulk assign attribute values to products and display these Magento attributes in layered navigation you can easily fulfill this task with Store Manager for Magento -

Magento layered navigation simplifies user browsing and saves time on product search. If your site keeps immense number of products, creating easy navigation filters is a must-have.

How to Export Magento Attribute Sets to CSV [Video]

Magento attribute set is actually a collection of attributes used to create certain range of products. Having diverse product catalog, you would definitely set multiple attribute sets and moving to another Magento shop, you might need to transfer them to .csv.

magento export of attribute sets

The video below demonstrates how to easily adjust export settings and get feed with necessary attribute sets in several clicks only.

Magento admin does not provide export functionality for attribute sets, but this task can be easily accomplished with Store Manager for Magento and its export wizard. In order to export attribute sets with all associated attributes, you are supposed to configure settings via the wizard.

  1. Open Magento attribute set export wizard.
  2. magento export of attribute sets

  3. Select 'Export' action on the first step.
  4. Specify path to the file, attribute sets will be stored in.
  5. Indicate what attribute sets should be pulled out to .csv: all existing attribute sets, filtered or selected at the moment Magento attribute sets.
  6. magento export of attribute sets

  7. Set file delimiters on the following step or leave default ones.
  8. Preview data to be exported and choose after export actions.

Related tutorial on Magento attribute set export is available by this link -

Use Store Manager for Magento to make data management more approachable and perform tasks quicklier.