Magento Store Manager Blog

Store Manager for Magento news and announcements

Magento 2: Get Product IDs Exported to CSV

Need to export from your Magento 2 products with IDs to CSV file? Generally, for inventory management inside Magento, like different catalog updates, SKU is used as unique product identifier. So necessity to get CSV with Magento entity IDs usually emerges in special situations, for instance, when you want to integrate with some third-party system or management solutions.

Magento 1 VS Magento 2 Export Product IDs

In Magento 1 there was included the possibility to do the task with Dataflow profiles export. Magento 2 Export/Import is deprived of the default functionality to get the list of product IDs.

magento 2 export ids

Naturally, if you have enough tech background, you can retrieve all of products via API or create some custom script to accomplish the task. If you do not have idea how to cope with it, in this tutorial I will show you the way to do it without changing Magento core files or hiring a developer to assist you.

The easiest and the most common approach is CSV export. Yes, it was mentioned above that it is not possible using out-of-the-box export means, that it why it is necessary to expand default functionality with enhanced possibilities using extension.

Store Manager for Magento app is a perfect solution for that. Why? It works equally good with both Magento 1 and Magento 2, does not require to be installed on your shop as you can connect remotely and the best thing is that you can use all the features of the software free for 14 days without limitations.

Get File Containing Magento 2 Product IDs Using Store Manager!

Select Collection of Products With IDs to Be Exported

The application includes wide management possibilities, so you can make use of advanced filters to receive a collection of all products IDs, get those of products from particular category, retrieve goods IDs associated with configurable, bundle or grouped products, etc.

magento 2 export entity ids

Export IDs Along with Other Necessary Product Details

Store Manager for Magento allows to decide what columns you want to include in the output export file. So apart from the collection of product IDs, you can also export necessary product-related fields, like SKU, name, category, some specific attributes, prices, quantity etc.

To select data to be exported simply drag necessary column from the left and drop them to the right pane of the window at the following step:

magento 2 export entity ids and skus

Automate Magento 2 CSV Export to Make It Regular

In case export of product IDs and related details is not one-off occasion, it is a good idea to automate the procedure and make it running without your involvement each regular period of time. This is especially true in case you need CSV with products IDs for integration with external systems.

Store Manager for Magento has built-in AutoExport functionality that allows to set up scheduled task without special efforts. You just need to configure export settings once and indicate when exactly and how often your further exports should be performed.

magento 2 export ids automatically

Export Product IDs from Magento 2 Store to CSV FREE!

Google Increases Meta Description Length

Meta description comprises the key information placed on a web page. It is aimed to help users understand if such content would be interesting and useful for them. Nevertheless, most content managers use meta descriptions (or snippets) not only to let users know if their websites contain information they searched for, but also to entice them to click on their page link and get higher rank in search results list.

Previously Google snippet limit made 160 symbols. Recently it was announced to have increased to 230 characters:

“We recently made a change to provide more descriptive and useful snippets, to help people better understand how pages are relevant to their searches. This resulted in snippets becoming slightly longer, on average.”

What are the grounds of such alteration?

Google explains the change by the increased effectiveness of more informative snippets. Small meta description contained only those words or phrases, that are often typed in the search field. It was used more likely to make a person visit a website, but not to describe the core of this or that article, especially, if the content was commercial and could persuade the reader make a purchase.

The increased meta description length has probably its own pros and cons. On the one hand, it gives a better insight to an article and seems to be more helpful for a user. Besides, it provides more space for a content writer to use more catchy phrases and call to actions. But on the other hand, a person would not necessarily like to spend time reading through dozens of long snippets. In fact, he or she is more likely to look for the shortest ones containing the phrase they are searching for. Though this seems to be wrong and even more time-consuming, but so is our nature - we can’t stand wasting time doing things we consider unnecessary.

Do I need to change my previous page snippets and use longer ones from now forth?

It depends on your content type, your goals and own suggestions concerning the issue. Delivering too much key information in meta description you can relieve a user from the necessity to visit your page with no benefit for you. However, short snippets with no clear explanation of the content will probably be bypassed. So the best decision is presumably to try to find the golden middle making your meta descriptions both informative and catchy.

New Beta version of Amazon Integration is available for Magento store owners!

eMagicOne team is glad to share new Amazon Integration Beta version (0.9.2.233) for Store Manager for Magento!

magento amazon new beta

Integrate your Magento store with one of the worlds largest and most popular selling channels with ease, exporting and synchronizing product listings and arranging orders with no efforts.

Let us check what enhancements the new Beta version brings to users:

Feature:

  • Shipping support has been implemented in current BETA version of Amazon Integration. Now, Settings tab allows to establish shipping methods when synchronizing products.

  • magento amazon shipping mehtods

    Improvements:

  • Now, category list can be filtered when adding products to listing.
  • Confirmation message has been added when deleting the account.

  • magento amazon delete account

  • Mapping products process has been improved with possibility to select all fields for association at one time. Also, mapping will take place according to the priority and availability of value in this field.
  • When adding products to listing, they can be automatically mapped to the existing ones on Amazon Marketplace.
  • There were visual changes made in plugin interface.

  • magento amazon visual changes

  • Inventory tab grid has been expanded with an option that allows to show calculated product price and quantity that will be synchronized with Amazon.
  • Fixes:

  • Suggested categories list selection has been fixed in current version of the addon.
  • "Details" link for listing logs has been enhanced. Now, it is shown for listings with all statuses, except for those, that have "Submitted" status.
  • Previously, when deleting operation logs, not all related tables data was removed. The issue has been fixed.
  • Status of listings that have just been synchronized is now displayed properly.
  • An error that occured while checking formulas for prices set by the user has been fixed. Now, the regional parameters are correctly considered.

  • Important note

    Before the update of the addon, we recommend you to backup all Amazon Integration files to some local folder in case you want to roll back to older version of the addon. You can check the list of the details that need to be saved following this article.

    In case you use previous Beta version of Amazon Addon (ver. 0.9.1.209), it is enough to save listing configuration settings and AmazonIntegration.dll file (C:\%ProgramFiles% \eMagicOne\Store Manager for Magento\Plugins\) to some local folder. To get back to previous Beta, follow the next steps:

    1. Go to Raw Table Editor section accessible in Tools section of Store Manager.
    2. Filter the tables related to Amazon addon among all the available ones.
    3. Highlight the filtered tables and launch to Script to Clipboard/Drop option in the context menu.

    4. magento amazon tables

    5. After that, proceed to Custom SQL tab, paste the tables and press Execute SQL button.

    6. magento amazon expression

    7. Close Store Manager and copy the previously saved old AmazonIntegration.dll file you have been using to C:\%ProgramFiles%\eMagicOne\Store Manager for Magento\Plugins\.
    8. Load previously saved settings to the Amazon Integration.Load previously saved settings to the Amazon Integration.

    Once all the backups are saved, you may proceed with Amazon Integration Beta installation using this link - Download Magento Amazon Integration addon.

    Current Amazon Integration Beta version is compatible with Store Manager starting from version 3.11.0.2063. If you are using older version of Store Manager, than it is specified and want to update Amazon addon to the version 0.9.2.233, you have to update the application first.

    *Amazon Integration is already built in Store Manager software and cannot be used without it. If you do not have Store Manager, try Trial version of the application and check all the possibilities of the addon and other functionality Store Manager offers.

    Limited Support on January, 1st

    Dear Customers,

    Please be advised that on Monday, January 1st eMagicOne will be providing limited support. If you have a question, please contact us via e-mail. Phone support and live chat will be temporarily unavailable.

    Your requests received during that day will be replied according to the queue.

    Your patience during this period is greatly appreciated. We will be back in full force and ready to help you on Tuesday, January 2nd at our usual support hours.

    Thank you for staying with us.

    During this period you will still have full access to your licenses. Besides, feel free to buy our software anytime at - https://store.emagicone.com

    Sincerely,

    eMagicOne Team.

    New Year, New Sale!

    Holiday greetings from eMagicOne company! We hope this year you had a great time and we wish you happiness, prosperity, and most importantly, lots of fun for the upcoming year!

    Thanks 2017!

    So, before we welcome 2018, here is a little flashback of what eMagicOne has achieved during the last year:

    • Added support of latest Magento versions;
    • Implemented Related Product Generator to automatically generate and associate related, up-sell and cross-sell products;
    • Included ability to add Magento 2 product videos to Media Gallery;
    • Added SMTP support to schedule abandoned cart, general/custom report emails;
    • Developed import/export of Magento cart rules (coupon codes);
    • Implemented functionality to automatically export and import Magento custom options;
    • Included ability to perform automated product export;
    • Introduced new lookbooks templates into PDF catalog creator addon;
    • Redesigned and improved eBay Integration addon;
    • Launched renewed version on Amazon Integration addon.

    This is only a snapshot of a few main features introduced this year in our Magento solutions. Don’t you think that you have already missed out a lot? Don’t wait anymore. Give a try!

    See You in 2018!

    We do have some great surprises coming in 2018, so stay tuned.

    Wishing you a wonderful holiday and a prosperous New Year full of incredible things ahead!

    Ready, Set, Christmas!

    The countdown to Christmas has already started! eMagicOne company wishes you all the best for the upcoming holidays and offers you a great possibility to enhance your Magento stores with innovative features and functionalities before you wrap for Christmas celebrations.

    Renewed Magento Amazon Integration Addon is Available in Beta Version!

    Good news for Magento store owners!

    We are constantly working on improvement of Store Manager software and addons are not the exception.

    eMagicOne team is happy to announce the renewed BETA version of Amazon Integration that has just been developed.

    magento amazon integration module

    Integrate your Magento-based store with one of the world’s biggest marketplaces: export products, synchronize existing ones from your online store to Amazon, process orders to expand your business and increase the circle of potential clients.

    You can download renewed Beta Amazon Integration version of the addon following this link - Download Magento Amazon Integration addon.

    Current Amazon Integration Beta version is compatible with Store Manager starting from version 3.11.0.2063. If you are using older version of Store Manager, than it is specified and want to update Amazon addon to the version 0.9.1.209, you have to update the application first.

    Important note

    Before the update, we recommend you to backup all Amazon Integration files to some local folder in case you need to roll back to older version of the addon. You need to save the following details:

    1. AmazonIntegration.dll file (to find it, navigate to C:\%ProgramFiles% \eMagicOne\Store Manager for Magento\Plugins\)
    2. AmazonIntegration folder (can be found in c:\Users\%username%\appData\Local\eMagicOne Store Manager for Magento\)
    3. amazon_integration folder (go to c:\Users\%username%\appData\Local\eMagicOne Store Manager for Magento\LocalMySQLData\data\)
    4. Use Database Backup/Restore option to create backup of the tables, related to Amazon Integration, namely sm_amazon_categories and sm_amazon_products tables.
    5. magento amazon integration module


    Let us take a closer look at the list of new features and improvements this Beta version delivers to Magento users

    Features:

    1. Product listings have been added in current version of Amazon Integration.

    2. magento store manager amazon integration

    3. The log list of recently performed operations is now available in this version of the addon.

    4. magento amazon integration logs

    5. The possibility to schedule and execute task has been implemented.

    6. magento amazon integration scheduled task

    Improvements:

    1. Now, the parameters of the window are saved after closing the Amazon addon. Correspondingly, the same size of the form is uploaded and used after next opening of the Integration.
    2. The list of suggested categories is now available to use at the step of mapping categories.

    3. magento amazon integration suggested categories

    4. The Amazon category search has been improved with quick search filter.
    5. The possibility to save and load the listing settings has been added.
    6. The placement of Integration elements has been changed. The interface of the addon has been enhanced as well.

    7. magento amazon integration interface

    8. The ability to choose the field to export product quantity from has been added in new BETA version of Amazon Integration addon.
    9. Export quantity of products according to specific rules is available in this version of addon.

    Once all of the backups are done, you can proceed to the update following these steps:

    1. Download Amazon Integration installation .exe file on your PC. Proceed with installation steps with a special setup wizard. It is recommended to close Store Manager before you continue with further steps.

    2. magento amazon setup wizard

    3. Read and accept Licence Agreement.
    4. Select Store Manager the Integration should be installed on (Store Manager for Magento in your case).

    5. magento amazon installation

    How to return back the old version?

    There can be reasons why you might want to get back the old version of Amazon Addon you have been previously using. For such case, you should proceed with the following steps:

    1. Go to Raw Table Editor section accessible in Tools section of Store Manager.
    2. Filter the tables related to Amazon addon among all the available ones.
    3. Highlight the filtered tables and launch to Script to Clipboard/Drop option in the context menu.

    4. magento amazon tables

    5. After that, proceed to Custom SQL tab, paste the tables and press Execute SQL button.

    6. magento amazon expression

    7. Close Store Manager and copy the previously saved old AmazonIntegration.dll file you have been using to C:\%ProgramFiles%\eMagicOne\Store Manager for Magento\Plugins\. Proceed the same way with AmazonIntegration folder to C:\Users\%username%\appData\Local\eMagicOne Store Manager for Magento\ and amazon_integration folder to C:\Users\%username%\appData\Local\eMagicOne Store Manager for Magento\LocalMySQLData\data\.
    8. Restore tables related to Amazon, previously saved in .sql file.

    Please, note, that Amazon Integration is running in demo mode by default. This means, that you will be able to export up to 10 items for testing. Find more details on Amazon Integration following this link - https://www.mag-manager.com/magento-amazon-integration/

    *Amazon Integration is already built in Store Manager software and cannot be used without it. If you do not have Store Manager, try Trial version of the application and check all the possibilities of the addon and other functionality Store Manager offers.

    Wishing You Happy Thanksgiving

    Thanksgiving is coming up, and we are extremely excited to share the spirit of upcoming holidays! These are very special days and there wouldn’t be a better occasion for us to express our gratitude and offer exhilarating discounts.

    Thanks you!

    All of us at eMagicOne are grateful to everyone who’s joined our community throughout all these years. You’ve helped us grow and build better software products for your Magento online stores.
    Everyday we are tying harder and harder to reach higher goals and bring top-level user experience for you, our dearest customers. Thanks for keeping us inspired and encouraged!

    Happy Thanksgiving and a joyous holiday season!