The scope of e-commerce is very diverse and exists in the stage of rapid development. As in any market, there is healthy competition between the services through which online stores are built. Magento and Shopify are two powerful and competing platforms.
Shopify is an easy-to-use and secure e-commerce service, which has seen ratings grow rapidly in recent years. We should note that this service has become a top leader among representatives of small and medium-sized businesses, as the platform is quite comfortable and able to work with various segments and businesses.
You can also try the free 14-day trial version.
Shopify is a SAAS (software as a service) platform, so you don’t have to think about your own hosting and security. It is is an easy-to-use and customizable platform. When using this platform, you don’t need to take the time to delve into programming or master the maintenance of your website. You can spend your time developing the advancement of your online store.
When our team of developers was presented with the task of data migration from Magento to Shopify, we decided to delve more thoroughly into the study of this issue. As our own practice showed, the number of willing entrepreneurs to move their online store from the Magento platform to Shopify is constantly growing. This isn’t an easy task: you have to move data from the old service system to a new one.
For a clear understanding of Magento to Shopify product migration, we have prepared this detailed step-by-step set of instructions. For a developer with this goal in mind, there are two possible ways to solve the issue:
First of all, let’s describe the simplest way to transform your product lines. Let’s start with the service Cart2Cart that allows you to migrate a site from Magento to Shopify. Cart2Cart is a unique online shopping cart migration tool which provides the opportunity to perform full-scale data migration automatically. The service supports 75+ eCommerce
All you need to do is to select the source and target shopping carts and the number of objects you want to transfer. For example:
- transferring the category of source storage to an assembly of automated collections will cost you $59+;
- reserving order identifiers in the target store: $49+;
- creating 301 redirects in your target vault after migration: $59+;
- migrating categories and product SEO URLs: $59+;
- migration of images from product descriptions, category descriptions and descriptions of blog posts: $49+;
- increasing the number of products in the Target Store: $29+
Follow this link and observe what products can be moved and what the price of migration is: https://www.shopping-cart-migration.com/shopping-cart-migration-options/1066-magento-to-shopify-migration.
As you can see
It should be noted: the number of online-shops with similar numbers of goods and orders is quite small. On one of our projects, there were about 7,000 products, 10,000 customers, and 3,000 orders. In this case, the transfer of data will also cost more. With help of that service, however, we didn’t reach the main goal. This application didn’t allow our team of Shopify developers to flexibly configure the data migration. Our client set the task to transfer the data in a new form with a new structure, which was simply impossible with the Cart2Cart service. Due to these circumstances, we continued to search for other solutions.
The project that we developed included the Linnworks inventory management system.
“Linnworks by Linn Systems is a cloud-based order and inventory management solution designed for item-based businesses and retailers. It features deep shipping and order management capabilities along with standard inventory management functions. Users can also monitor their stock across all channels”.
We studied particular qualities of this system and found the option of writing a custom solution for moving data from one system to another. This service has the ability to conveniently transfer data in various ways. For example, export data directly to another server for further processing. This operation can be performed on a regular basis if you want to maintain the databases of the two systems in the same state.
So, the first stage of the configuration was quite simple and, to start, we rented a VPS (Virtual Private Server). VPS is a service within which a virtual dedicated server is provided to the user. The technical implementation of VPS is based on the sharing of physical server resources on a number of virtual servers. In terms of operating systems, management VPS is similar to a physical dedicated server. In particular, you get
Firstly, set the name to export task:
Then, in the third step, we configured the connection to the purchased server via sFTP. In this plan, Linnworks allows you to flexibly configure the saving of data files in the desired directories on the server.
At the next stage, our specialists were able to specify the exact data for the goods needed to be exported:
Then, developers began to create a schedule for automatic data export. Here, you can also flexibly configure the following:
We can successfully say that this is the entire setup process. Now, on our VPS, there is the most current export of data from Magento that we can work with.
In the previous steps, we described how to export information from Magento; however, this is not enough. We should now import this data into Shopify.
To achieve this goal, we decided to write our own application, which will handle the uploading of information and transfer of it to Shopify. We implemented this functionality in the form of a Shopify application. Access to this feature is situated in the admin area.
In the application, the owner has the opportunity to form a list of SKUs (Stock Keeping Units), that he wants to transfer. This is one of the requirements, especially since Cart2Cart didn’t fit.
For development, we chose the Laravel framework and the PHP programming language.
“Laravel is a free open source web-framework designed for development using the Model Model Controller MVC (English Model View Controller)”.
For a DBMS (Database Management Systems) we used MySQL.The files on the server are stored in this form:
The application works with these files. Since the amount of data is quite large, the entire process of parsing this information is divided into portions
But, on the production server, we used a slightly different, more correct approach with Supervisord service (http://supervisord.org/). This is an indispensable component when you need to monitor a particular process on the server.
This is required for the queue manager.
For this, a special file is created where the handler is written. As a handler, we have a script that unloads the goods from the CSV file into Shopify using the Shopify API.
It looks like this:
Additionally, we store the relationship of product identifiers in Shopify to the SKU (Stock Keeping Unit) of goods in Linnworks. We do this in order to be able to update products in Shopify when they are updated in Linnworks. This supports the full synchronization of goods in two databases - Shopify and Linnworks.
As you can understand from the article, the process of moving data from Magento to Shopify looks like a non-trivial process. The result will depend on the path, tools, and resources you have chosen. There
Before preparing for migration, you must answer a number of questions:
- What kind of data do you want to transfer?
- How much data?
- Do I need to maintain the relevance of the data in the source database after the movement?
The answers to these questions directly affect the way in which this process will be performed and what results will follow.
If you need help to understand this process, contact our team of Makebecool developers.