In the following post, we shed light on how to import shipping tracking number to Magento 2. Although you cannot do that with the default Magento platform, there is one reliable solution that enables not only the rich import functionality but provides robust export capabilities and offers tons of other features that dramatically improved every integration. Let’s figure out how to import shipping information to Magento 2 seamlessly.'
Table of contents
- 1 Magento 2 Tracking Number Import
- 2 How to import and export Magento 2 tracking/shipping codes
- 3 Improved Import and Export extension features
- 4 Other Notable Features
- 5 Conclusion
Magento 2 Tracking Number Import
Meet the Improved Import & Export Magento 2 extension – a module that enables the missing functionality saving you from tons of manual work on a daily basis. With the help of the plugin, you can easily import tracking numbers from files of numerous formats available at different sources. In addition to tracking data, the Improved Import & Export Magento 2 extension lets you transfer invoices, shipments, and status updates in a fully automated manner!
- Import orders and invoice them automatically;
- Ship orders after import;
- Add tracking number if it was absent during the import;
- Change the order status after the import;
- Create credit memos automatically.
As you can see, the Improved Import & Export Magento 2 extension completely revamps the way you import orders to Magento 2. The same is about the shipping tracking number import; thus, you can concentrate on other more important tasks while our module does everything for you.
Powerful Tracking Number Import for Magento 2
In combination with multiple other features, the Improved Import & Export Magento 2 extension introduces the most powerful tracking number import functionality along with other import features. You can use the module to import all the necessary Magento 2 entities, attributes with all the corresponding information, CMS pages, etc. Similar opportunities are available for multiple export processes. The extension provides the ability to automate tracking number import and apply mapping to it if necessary. And all operations are fully controllable from the admin section of the module. Due to extended connectivity options (described below), you can easily import tracking number to Magento 2 as well as transfer other data to your website from any external source via multiple file formats. Integration with your warehouse, shipper, or fulfillment center has never been so easy.
How to import and export Magento 2 tracking/shipping codes
As you may know Improved Import and Export extension allows importing and exporting Magento 2 orders. Entity ‘Orders’ includes every data that is stored in the orders along with Shipping and Tracking information. One of the use-cases of orders import is import of parcel tracking codes. Tracking code import can be performed using only four attributes of the orders.
- You can only import tracking codes for orders that have already been created
- You can only import tracking codes for orders with created shipping
- You can use order increment IDs or shipping increment IDs for importing tracking codes
- You can use order table, an delete all attributes expect the four: shipment_track:shipment_increment_id or increment_id, shipment_track:track_number, shipment_track:title, shipment_track:carrier_code
Let’s take a look at the tables we will be using to import tracking codes. There will be two tables, depending on which indentificator we will be using:
1) Order increment ID as identificator:
2) Shipping increment ID as identificator:
As you can see, these two tables differ only in the first column (attribute) which is used to identify either order (first illustration) or shipment (second illustration). Other than that, these tables are identical and use the following attributes:
|Attribute name||Reference||Values||Value example|
|increment_id||Order number is used to identify the order the tracking number should be imported for||Order number displayed under Sales > Orders
Can be any value depending on the increment pattern you use
|shipment_track:shipment_increment_id||ID of the shipment you have created for the order||Can be located under Sales > Orders > Shipping
Can be any value depending on the increment pattern you use for the orders
|shipment_track:track_number||Tracking number of the shipping||Can be any value depending on the increment pattern you use for the orders||4555555555|
|shipment_track:title||Shipping service name||Can be located under Stores > Shipping > Carriers
Depends on the carrier you are using
|United States Postal Service|
|shipment_track:carrier_code||Shipping service code||Can be located under Stores > Shipping > Carriers
Depends on the carrier you are using
You can find sample tracking code import table in the
Improved Import and Export extension features
Extended Connectivity Options
The Improved Import & Export Magento 2 extension allows importing tracking numbers and other order data via multiple file formats. While Magento 2 supports CSV only and most third-party extensions add XML to the game, our module goes much further. It allows you to import a tracking number to Magento 2 from CSV, XML, JSON, ODS, and Excel files. Thus, you no longer need to convert the external output to the only format supported in Magento.
Furthermore, the Improved Import & Export extension enables you to import tracking numbers from multiple sources. The module support FTP/SFTP connections representing two powerful options. First of all, you can use your local server as a point of data exchange. As for the second option, it is any remote server. Choose a solution that better satisfies your business needs and give it a try.
Alternatively, you can leverage two more options. One of them is a Dropbox account that can be seamlessly connected to your Magento 2 website providing tracking number import opportunities. At the same time, you can transfer all the necessary data to your e-commerce store right from a direct URL.
Another data source is not related to file transfers, but it can substantially improve the way you import tracking numbers to Magento 2. The point at issue is the Google Sheets import provided by the Improved Import & Export Magento 2 extension. You can freely move any data stored in Google Sheets to your e-commerce website including shipping tracking numbers. The process can be fully automated, and you can apply the mapping if necessary. Below, you can see its illustration:
At the same time, the Improved Import & Export Magento 2 extension lets you import tracking numbers and other order data to Magento 2 using an API connection. The module supports SOAP API, REST API, and GraphQL API integration.
Unlimited Import Profiles
The more vendors you have, the more import profiles you can create. The Improved Import & Export Magento 2 extension sets no limits so that you can create an individual approach to every connection. Furthermore, it is possible to create multiple import profiles for the same integration making the data exchange as flexible as possible. Thus, the plugin allows you to import tracking numbers and credit memos separately.
The Improved Import & Export Magento 2 extension also offers a system of triggers. Thus, a selected process may launch specific actions. For instance, the Magento 2 tracking number import may change the status of the corresponding order and send a notification to the appropriate customer. The module lets you create multiple various combinations of triggers and related events making the backend routine fully automated.
Another astonishing feature of the Improved Import & Export Magento 2 extension is the ability to create schedules. As mentioned above, the module lets you import tracking numbers to Magento 2 automatically. You have several options to choose from when it comes to schedules. First of all, it is possible to create any custom update period with the help of a default cron syntax. At the same time, the extension offers a list of predefined update intervals. You can use the same rules to customize them.
If necessary, a new profile may be suitable for a manual run only. This opportunity is useful if you don’t have any frequent updates. For example, your partner sends data in random order with large intervals between them. Thus, you may choose the manual Magento 2 import to save system resources used for running an empty job. However, you can also launch every scheduled manually in the same asynchronous mode. Thus, no frequent update provided before a schedule is delayed.
The following gif image illustrates how to configure a new schedule or enable a job for a manual run:
With the Improved Import & Export Magento 2 extension, you can monitor all the details of every import and export. Each job has a history section where you can view not only all runs but also download a log of each one.
To view the details of your Magento 2 tracking number import job, go to the corresponding profile and click the “View History” button:
You will be redirected to a screen with all runs. The download link is available in a related grid of the section:
When launching a job manually, you can see a progress bar as well as the imported data:
In case of errors, The Improved Import & Export Magento 2 extension offers a detailed log with mistakes that are to be fixed:
Rich Mapping Opportunities
Another feature that makes the Improved Import & Export Magento 2 extension such a flexible tool is its mapping functionality. The plugin not only allows you to map attributes but also provides the ability to match or even edit their values. Let’s take a look at each mapping feature in more detail.
The difference between standards used to store data in various systems leads to the inability to import that data from one platform to another directly. Due to the same reason, you always have to match external attributes to ones used in Magento 2 before every import. Unfortunately, the Magento 2 import of tracking numbers and other order data is not an exception.
By default, you should edit third-party tables making their content acceptable in terms of Magento 2 standards. The more data you have in a table, the more work should be done. And it is a manual work that requires lots of time, patience, and concentration. However, you can dramatically improve the default routine with the Improved Import & export Magento 2 extension. Our module lets you use a robust mapping interface to match external attributes to ones used internally. Since most import files have a custom structure, our module becomes a number one time saver not only for the Magento 2 tracking number import but other data transfers.
With the help of the extension, you can make any external output suitable for the Magento 2 import. In the corresponding mapping section, you can find and apply presets for the import tables. Consequently, you don’t need either edit data files manually or match any attributes on your own. This procedure is reduced to a few clicks only. Merely select a platform which is the source of your import file and apply the corresponding mapping preset.
In case of data transfers from Magento 1 to Magento 2, the algorithm looks as follows:
You choose a preset in the ‘Select a Platform’ field and click the ‘Load Map Attributes’ button. That’s all the mapping process! Note that it is possible to view sample files. The corresponding links are provided below the drop-down with presets.
How does everything work? The Improved Import & Export extension maps attributes automatically while you spend time on something else. The module compares system attributes of Magento 2 with ones from the import file and maps fields unsuitable for system requirements. In the end, you get a grid with matched attributes:
Please, contact our support regarding mapping presets for your specific business case. Leave your requests here:
At the same time, the Improved Import & Export Magento 2 extension provides the ability to do the following procedure manually but in the admin section of your store – not by editing data tables directly.
While in the corresponding import profile, proceed to its mapping section. There, you can see the ‘System Attribute’ column – select a default Magento 2 attribute. Next, proceed to the ‘Import Attribute’ column and specify a corresponding import attribute which is used in the import file.
If necessary, you can apply hardcoded or default values for specific attributes. They are added to each imported item in the corresponding column. For example, you can specify the same store view for all elements in the document. Add the appropriate hardcoded value to the corresponding attribute.
Also, note that there is the black bin icon designed to remove mapping items. You can also find the ‘Validate’ button between the rows. Click it to complete the procedure.
The Improved Import & Export Magento 2 extension dramatically enhances its mapping opportunities by introducing the ability to map attribute values. It is no longer necessary to import random values or edit them manually. With our module, you can quickly match external attribute values to the corresponding values used in Magento 2. The mapping section above adds all the necessary tools. You select an external attribute, map it to the one used internally, and repeat the same action for the values of the external attribute.
It is worth mentioning that every mapping scheme you create is saved for further updates. Thus, there is no need to apply mapping manually on every import. The mapping procedure is turned into a one-time process. In case of the default tools, you need to edit data files before every import procedure.
Let’s take a look at the example for better understanding of the feature. You have an update file that contains product data. Some products include the “color” attribute which, in its turn, has multiple values. Let’s assume that the values are “deep-blue” and “ultramarine-blue”. But in your database, there is only one value – “blue”. With the help of the Improved Import & Export Magento 2 extension, you can map both external values to the corresponding one used inside your store. As a result, the imported products will get the new color attribute value.
In addition to the ability to map attribute values, you can also edit multiple values in bulk using various rules. The Improved Import & Export Magento 2 extension provides the ability to apply rules to change attribute values. Furthermore, rules can be combined to implement more precise edits.
First of all, you can add a prefix to any attributes. Let’s take a look at a situation with values we’ve just described in the previous chapter. Imagine, that you need to replace the “blue” value with “dark-blue”. Depending on the number of products in your database, this process may last endlessly. What do we offer instead? You can att the “dark-” prefix automatically within just a few clicks.
You can apply the same logic while adding a suffix. And. As we’ve just mentioned, it is possible to combine both rules. Besides, the Improved Import & Export Magento 2 extension provides the ability to split data stored in one block to multiple ones. As you might have already guessed, the opposite action is fully supported, so you can effortlessly merge data from various blocks into one.
Note that you can use RegEx to edit values in the source file. There are no limits on the number of combinations you can create while editing attribute values. For further information, follow this link: How to Modify Attribute Values During Import and Export in Magento 2.
Other Notable Features
Continuing the topic of mapping capabilities of the Improved Import & Export Magento 2 extension, we’d like to draw your attention to the category mapping functionality of the module. Of course, it is not something helpful regarding the Magento 2 import of tracking numbers, but when it comes to other transfers, category mapping saves lots of time.
The appropriate tool is available in the Map Categories section of your import profile. You need to load values from the ‘categories’ column of the import table by clicking the ‘Load Categories From Import File’ button.
Next, add the first category to be mapped. Click the ‘Add New’ button – A grid will be displayed. In the ‘Import category path’ column, choose an external category from the import table. Now, select an appropriate Magento 2 category in the ‘New category path’ column just like shown below:
Note that it is possible to create new categories to import products to them right from the profile page. Hit the ‘New Category’ button, specify a name of your new category, and select a parent category. The number of new categories is unlimited.
Another crucial feature of the Improved Import & Export Magento 2 extension is the ability to import and export attributes, attribute sets, and attribute values as a separate entity. It is especially useful in case of migration from other platforms or scaling your business.
Since the traditional approach to attribute transfers requires tons of time and effort, the provided import/export capabilities dramatically improve the corresponding routine. With our module, you can easily import/export the relevant data within just a few clicks.
As mentioned above, you can use multiple file formats and sources to run the transfer. The mapping processes described above can also be streamlined when you import or export attributes and their values. Note that all attribute details are seamlessly moved. The Improved Import & Export Magento 2 extension allows importing/exporting attribute properties, options, swatches, etc.
Besides, you can generate new attributes on the fly. This feature is described in the following chapter. Creating attribute groups, attribute set names, and multiple attribute sets during import is no longer a problem. Furthermore, by using store views separation, you can create individual attribute labels and options on their basis. As for data updates, they involve such actions as the ability to renew data for attribute labels and option values. And you can use store views as the basis of the update.
As for the creation of attributes on the fly, the Improved Import & Export Magento 2 module saves you from issues caused by the lack of the corresponding data in the import file. The idea behind this feature is illustrated below.
An attribute name is replaced with the data necessary to create a missing attribute. Specify an attribute set, scopes, frontend labels, and other parameters using the following general format:
Note that a pipe symbol is used to separate values, and each attribute column begins with ‘attribute’. Below, you can see the example of the scheme used to create attributes on the fly:
For further information, follow this link: Product attributes import.
To discover more features of the Improved Import & Export Magento 2 extension, watch the following video:
Now, you know the most efficient way to import tracking numbers to Magento 2 along with other product details. As you can see, the Improved Import & Export Magento 2 extension provides tons of useful features that substantially improve the way you transfer data between your e-commerce store and external platforms. Please, follow the link below for further information. And, don’t hesitate to contact our