Importing Tracking Data CSV file with Shipment Tracking Pro in WooCommerce
This article would cover the CSV file importing feature of the WooCommerce Shipment Tracking plugin. We will show you how this nifty feature could help you manage bulk orders easily.
WooCommerce is a great platform for online store owners to sell their products to a larger audience. They can use various shipping or carrier plugins that will help them ship the products to their customers. But as the number of orders increases on the store, it becomes quite a challenge to manage all the orders and assign shipment tracking IDs to each one of them.
The WooCommerce Shipment Tracking Pro plugin plays an important role in making the entire shipment tracking ID assignment process easier for store owners. It is very simple to use and improve productivity in your WooCommerce store.
Preparing the CSV file
CSV stands for Comma Separated Values. This type of file is used to store tabular data (numbers and text) in plain text. Our Shipping Tracking Pro plugin has a pre-defined format. You can refer the following image below.
As you can see in the image above, we have created a table that has four columns – ID, Carrier, TrackingNumber, and ShippingDate. The ID column represents the order number. You can find the order number as shown in the screenshot below.
Similarly, we have copied the order numbers 31 and 32 and pasted them into the ID column.
Now in the Carrier column, we have entered the shipping service names and in the TrackingNumber column, we have entered the respective tracking IDs.
Note: You will get these shipment IDs from the respective shipping service. For instance, FedEx provided the tracking number 8420971641824 for order number 30.
In the ShippingDate column, you have to enter the date and time of shipping in the given format. After doing the above steps, you have to export this table as a CSV file. You can refer this article to know how to create a CSV file.
You can also create the CSV files using Note++ as well. The desired encoding of CSV is UTF-8 which is supported by most of the text editors.
You can either choose the CSV file from the computer or provide FTP information to do a bulk import of tracking data. There is flexibility to change the delimiter to some other symbol other than ‘,’.
After importing, the tracking data gets updated for individual orders and order status gets marked as Completed, which in-turn trigger order completion email with tracking details to the customer.
Importing the CSV file into the Shipment Tracking Pro plugin
Now that you have created the CSV file, you can import it to the plugin by going into the Installed Plugins and then click on the Import option in the plugin’s section as shown in the image below.
Doing this you will see another page that would allow you to add the CSV file. You can refer to the image below.
Now as soon as you have chosen the file, you have to click on the Update file and import. Doing this will show the following message.
You can further go to the Order summary page and open any order to check whether the import was successful or not. In this example, we will go and check the UPS order i.e, order number 32.
On the right section of the order number #32, you would find the following section that shows the Shipment Tracking interface. It would look something like in the following image.