How to Import Shipping Tracking Numbers to Magento 2
It is essential to provide customers with all the information about the goods and services you sell. While displaying all product details is an obvious and easy-to-implement task, managing tracking numbers in Magento 2 is way more sophisticated. For instance, your e-commerce website doesn’t let you transfer them from an external system. Consequently, you cannot automate the integration between Magento 2 and shipping providers. However, there is a tool that addresses the existing issues and enables seamless synchronization of your e-commerce website and third-party platforms.
In the following post, we shed light on how to import shipping tracking numbers to Magento 2. Since you cannot do that with the default Magento platform, it is necessary to leverage the Improved Import & Export extension. This reliable solution enables rich import functionality, provides robust export capabilities and offers tons of other features that dramatically enhance every integration. Let’s figure out how to import shipping information to Magento 2 seamlessly.
Below, you will learn about Magento 2 tracking number import. We provide a list of all features that Improved Import & Export delivers in this dimension. After that, you will figure out how to import and export Magento 2 tracking/shipping codes. The last chapter of this article described other features associated with our extension.
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
- 6 Magento 2 Tracking Number Import FAQ
- 6.1 How to import tracking codes to Magento 2 automatically?
- 6.2 How to import shipping numbers to Magento 2 from external systems?
- 6.3 How to import tracking codes to Magento 2 via API?
- 6.4 How to import tracking codes to Magento 2 via ODS files?
- 6.5 How to import shipping codes to Magento 2 via XLSX files?
- 6.6 How to import tracking numbers to Magento 2 via JSON files?
- 6.7 How to import tracking codes to Magento 2 via compressed files?
- 6.8 How to import shipping number data to Magento 2 from Google Sheets?
- 6.9 How to import shipping numbers to Magento 2 from Dropbox?
- 6.10 How to import shipping numbers to Magento 2 from Google Drive?
- 6.11 How to export tracking numbers from Magento 2?
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;
- Get shipment generated upon 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.
- Product SKUs and the number of items assigned to a shipment must be specified.
- You can create shipments and invoice orders automatically only upon enabling the related options during configuring the import job.
If the ‘Send Email from New Tracks’ option is enabled upon importing a new tracking number a customer whom the order is assigned to will receive a notification to the email address specified in the customer contact info.
The data table for importing tracking numbers uses 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: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
|shipment_track:skus||List of shipped items under the tracking code with their SKUs and quantity||Can be found within the order information at Sales > Order > Order Page||WSH09-29-Green:1;WSH09-29-White:1|
You can find sample tracking code import table in the
Read more about Google Sheet Master Table
Thanks to the tracking code import you can easily add shipment info to an order. Another use-case that’ll help you avoid manual involvement into order staging is autogeneration of invoices and shipments upon implementing the tracking code and shipped items data. Knowing the tracking code, you can massively update order statuses from ‘Pending‘ to ‘Shipped‘ with a single import job run.
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, ZIP 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 three more options. One of them is a Dropbox account that can be seamlessly connected to your Magento 2 website providing tracking number import opportunities. Google Drive source allows you to access tracking data stored within a folder in your cloud disk. 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:
Get Improved Import & Export Magento 2 Extension
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.
Read the extension manual on Attributes Mapping
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.
Read about Attribute Values Mapping
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.
Read about Attribute Values Editing
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.
Get Improved Import & Export Magento 2 Extension
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.
Attributes Import and Export
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.
Attributes On The Fly
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
Get Improved Import & Export Magento 2 Extension
Magento 2 Tracking Number Import FAQ
Below, we provide answers to questions that Magento 2 users often ask when it comes to the features of shipping number import with the help of the Improved Import & Export Magento 2 extension.
How to import tracking codes to Magento 2 automatically?
If you need to transfer shipping numbers to Magento 2 on a regular basis, it is necessary to install a third-party tool. Unfortunately, the default import/export solutions don’t let you create import jobs that run on schedule. Therefore, we recommend you use the Improved Import & Export extension to import tracking numbers to Magento 2 automatically. The extension leverages cron so that you can create a schedule of updates. Next, the module does everything for you.
How to import shipping numbers to Magento 2 from external systems?
While the default Magento 2 import mechanisms block the import of third-party data that doesn’t follow the system’s requirements, you can use the Improved Import & Export extension to circumvent these restrictions. The module lets you create a mapping scheme matching any external values to the default Magento 2 attributes. Consequently, any external data is easily adapted to the native standards of your e-commerce website. The most intriguing aspect is that you do everything right in your admin.
How to import tracking codes to Magento 2 via API?
You need to use the Improved Import & Export Magento 2 extension to import tracking codes to Magento 2 via API. Our extension lets you create the connection between the two systems transferring any data, including shipping numbers. Any import job provides an interface where you can specify the parameters necessary to put the two systems together.
How to import tracking codes to Magento 2 via ODS files?
If the shipping number data is stored in an ODS file, you no longer need to convert it to a CSV file to fit the Magento 2 requirements. With the Improved Import & Export Magento 2 extension, it is possible to import ODS files to your ecommerce website without any necessity to run the conversion.
How to import shipping codes to Magento 2 via XLSX files?
If the tracking code data is stored in an XLSX file, you no longer need to convert it to a CSV file to fit the Magento 2 requirements. With the Improved Import & Export Magento 2 extension, it is possible to import XLSX files to your ecommerce website without any necessity to run the conversion.
How to import tracking numbers to Magento 2 via JSON files?
If the shipping code data is stored in an ODS file, you no longer need to convert it to a CSV file to fit the Magento 2 requirements. With the Improved Import & Export Magento 2 extension, it is possible to import JSON files to your ecommerce website without any necessity to run the conversion.
How to import tracking codes to Magento 2 via compressed files?
If the tracking code data is stored in a compressed file, you can also transfer it to Magento 2 with the help of the Improved Import & Export extension. However, there are two requirements to follow. Firstly, your file archive should be in a ZIP or TAR format. Secondly, the compressed data should be stored in a CSV, XML, ODS, XLSX, or JSON file.
How to import shipping number data to Magento 2 from Google Sheets?
If your shipping codes are stored in Google Sheets, it is no longer a problem. There is no need to export it from the service and then transfer the output to Magento 2. The Improved Import & Export lets you move the corresponding information straight from Google Sheets to your e-commerce website. It is only necessary to specify the address of the corresponding data table.
How to import shipping numbers to Magento 2 from Dropbox?
In addition to Google Sheets, the Improved Import & Export module lets you transfer shipping codes to Magento 2 from Dropbox. Your data should be stored in CSV, XML, ODS, XLSX, or JSON. If it is a compressed file, it should be in a ZIP or TAR format.
How to import shipping numbers to Magento 2 from Google Drive?
In addition to Google Sheets and Dropbox, the Improved Import & Export module lets you transfer tracking numbers to Magento 2 from Google Drive. Your data should be stored in CSV, XML, ODS, XLSX, or JSON. If it is a compressed file, it should be in a ZIP or TAR format.
How to export tracking numbers from Magento 2?
You can also export tracking numbers from Magento 2 with the help of the Improved Import & Export extension. Ask our specialists for further information.