Often it is necessary to import products, customers, orders, or other data types to Magento 2 from a third-party MySQL database. However, Magento 2 doesn’t let you do that. Although the default tools don’t support such file sources as external databases, there are several ways to synchronize Magento 2 with external databases.
In the following post, we shed light on how to achieve this goal in two different ways. Firstly, we describe a common approach that involves the default Magento 2 import solution. It requires tons of manual work and cannot be automated. You need to run a CSV export from your MySQL database, match third-party attributes to ones used in Magento 2, and import your MySQL table into your e-commerce website.
On the contrary, you will find out how to avoid numerous unnecessary chores while importing data to Magento 2 from a MySQL database. This approach involves the Improved Import & Export extension. The module combines MySQL database connection and other data import activities within a single interface right in your Magento 2 admin.
After that, we shed light on several MySQL facts as well as describe the core features of the Improved Import & Export extension. To make the long story short, let’s see how to import data from an external MySQL database to Magento 2.
In the following article, you will find the most common Magento 2 integrity constraint violation issues described. Below, we combine answers from different platforms to cover as many examples as necessary for keeping this material epistemic and clear. You can find more tips in this article: Magento 2 Cookbook. Continue Reading
A new server-side scripting language was introduced in 1994. Its name was PHP, and it was designed for web development. Nowadays, the language is used on more than 2 million web servers and 244 million websites. During last twenty years, numerous PHP books have been publish to help developers better master it. In below, you will find the best PHP books which could help you a lot with learning PHP. Continue Reading
In this post we gathered information about the most popular self-hosted e-commerce platforms. Magento, PrestaShop, Zen Cart, and other solutions are described in the article. We tried to show their major features, as well as positive and negative aspects.
Lack of a native Unicode support was one of the biggest PHP drawbacks. In 2005, developers decided to change this. The newly formed project was designed to provide a native Unicode support to PHP. To achieve this goal, developers decided to use the ICU library (International Components for Unicode). Another significant feature of the project was representing UTF-16 text strings. It was planned to release the project as version 6.0, but we can see only PHP 5.3 and PHP 5.4, both without Unicode integration. As of 2015, there is an ongoing work on a new major version of PHP – PHP 7. The PHP 6 with its unicode experiment had never been released, so the name was abandoned.
UPD (23.06.15): PHP 7 – release date, performance, features, changes
UPD (13.07.15): Interview with Dmitry Stogov
UPD (25.08.15): PHP 7 on Magento EE
UPD (27.08.15): Deprecated functionality which will be removed in PHP 7
UPD (01.09.15): PHP 7.0.0 RC 1
UPD (07.09.2015): PHP 7.0.0 RC2 has been released. PHP 7 will be available on the 12th of November.
UPD (15.09.15): PHP 7 and WordPress, Return types, Scalar types, Threading for PHP, PHP7 Reference, php7cc
UPD (22.09.15): Backwards compatibility issues, PHP 7 screencasts, and a new overview
UPD (29.09.15): PHP 7 tutorial
UPD (26.10.2015): The Acquisition of Zend and PhpStorm 9
UPD (07.11.2015): PHP 7 Hidden Features
UPD (24.11.15) PHP 7 Docker Image for Magento 2
UPD (24.11.15) PHP 7 vs HHVM
UPD (01.12.15): PHP 7 RC 8 has been released
UPD (03.12.15): PHP 7 HAS BEEN RELEASED!!!
WordPress is a blogging platform and a CMS based on PHP and MySQL. It relies on a template system with a template processor and a plugin architecture. More than 23% of the top 10 million sites are based on WordPress, at the same time it is the most popular blogging system with over 60 million websites. Continue Reading
Integration of new solutions into different systems can become a headache without the knowledge of correct debugging. In case of Magento, such simple constructions as print_r() or var_dump() , var_export() don’t work. Because of heavyweight constructions, you need to investigate the new effective ways to find intermediate values or broken places. Fortunately, there are a lot of tools and methods designed to turn the debugging into a developer friendly process. Continue Reading
PHP is a web development language, which is also used for a general-purpose programming. It is installed on more than 2.1 million web servers and 240 million websites. PHP can be mixed with HTML and used in combination with various frameworks and templating engines. The code itself is usually processed by an interpreter. The PHP interpreter is implemented as a native module of a web server or as a Common Gateway Interface executable (CGI). After the interpretation and execution, the PHP code is sent in a form of resulting output to its client by a web server. Usually, it is a part of the generated web page. PHP code can generate an HTML code of a web page, an image, etc. The canonical PHP interpreter is a free software, which is released under the PHP License. It can be deployed on most web servers and works with almost every operating system. In addition, PHP can be used in standalone graphical applications, because it supports a command-line interface capability. Continue Reading