In addition to helping you save costs and increase your margin, here are seven reasons you should use a spreadsheet to track orders and deliveries.<\/p>\n\n\n\n
Tracking orders and deliveries in a spreadsheet helps you:<\/p>\n\n\n\n
- \n
- Use formulas to calculate totals, subtotals, profits, discounts, costs, and other relevant functions, which reduces manual error.<\/li>\n\n\n\n
- Sort and filter data based on specific criteria like order date, customer name, or product type. This helps you make informed decisions.<\/li>\n\n\n\n
- Create charts, graphs, and tables to analyse your information. You can gain insights about optimal delivery times, product demand and make relevant decisions.<\/li>\n\n\n\n
- Have multiple people work on delivery tracking. Most spreadsheet software allows for collaborative work.<\/li>\n\n\n\n
- Add as many columns as possible, adjust formulas and add more sheets to your requirement. This makes spreadsheets very flexible and customisable.<\/li>\n\n\n\n
- Integrate your spreadsheet into e-commerce software, SMS marketing platforms<\/a>, or inventory management software to reduce data entry.<\/li>\n\n\n\n
- Look up historical data in a spreadsheet, adjust the scale of orders, and quickly back up a spreadsheet into the cloud.<\/li>\n<\/ul>\n\n\n\n
Spreadsheets are FREE compared to other market solutions. They come incorporated with the OS, like Microsoft Office, are open source, like WPS, or can even be accessed online, like Google Sheets.<\/p>\n\n\n\n
Learn 10 unique ways to use bulk SMS for logistics<\/a><\/p>\n\n\n\n
Step-by-step tutorial on using a spreadsheet for managing orders and deliveries<\/strong><\/h2>\n\n\n\n
In this tutorial, we will help you set up a logistics tracking spreadsheet in Excel. <\/p>\n\n\n\n
For this tutorial, the column headers and data have been simplified. We made certain delivery assumptions, like delivery charges. And we used a delivery location city instead of an address. <\/p>\n\n\n\n
Setting up the spreadsheet <\/strong><\/h3>\n\n\n\n
Step 1: Open a clean slate to get started<\/strong><\/p>\n\n\n\n
Download Excel if you don’t have it installed yet, use any open-source provider like WPS, or use Google Sheets. Open the spreadsheet software. <\/p>\n\n\n\n
You should see a new Workbook when you launch the application. If you don\u2019t, go to the \u201cFile\u201d menu and select \u201cNew\u201d and then \u201cBlank Workbook\u201d.<\/p>\n\n\n\n
<\/figure>\n\n\n\n
Step 2: Define your columns<\/strong><\/p>\n\n\n\n
This is the most essential part. Your columns will represent the different pieces of information that you want to track.<\/p>\n\n\n\n
For example, if you are a small food business, you may want to list down “Food Items Ordered”, “Quantity”, “Order Instruction”, and “Delivery Time & Date” besides “Price”, “Discount”, and “Destination”.<\/p>\n\n\n\n
But if you are an electronics business, consider adding “Unit Price”, “Delivery Date”, “Delivery Status”, “Tracking Number”, and “Courier Details”.<\/p>\n\n\n\n
The type of data tracked by both businesses will be based on the company’s nature, the KPIs and the delivery considerations. <\/p>\n\n\n\n
What does that mean?<\/p>\n\n\n\n
In the food business, delivery times and customer satisfaction are paramount. But in electronics, product functionality, customisation and support are more important- which comes after order and delivery.<\/p>\n\n\n\n
Information to include on your spreadsheet tracker <\/strong><\/h4>\n\n\n\n
While you can create a sheet with pretty much any combination of data, the following list comprises headers that you should have:<\/p>\n\n\n\n
- \n
- Customer Name<\/strong>: Provided by the customer.<\/li>\n\n\n\n
- Customer Contact<\/strong>: Provided by the customer<\/li>\n\n\n\n
- Order Number<\/strong>: Generated by you and shared with the customer. This number is to track the order once it leaves your premises.<\/li>\n\n\n\n
- Serial number\/Order ID<\/strong>: Generated by you but different from the order number. This number is for in-house tracking. <\/li>\n\n\n\n
- Order Date<\/strong>: The date the customer placed the order.<\/li>\n\n\n\n
- Product\/Service Specifications<\/strong>: Include as many details as possible, including the product code of the product\/service.<\/li>\n\n\n\n
- Quantity<\/strong>: The quantity as ordered by your customer.<\/li>\n\n\n\n
- Unit Price<\/strong>: Price of one unit of the product\/service that the customer ordered.<\/li>\n\n\n\n
- Total Price<\/strong>: Quantity multiplied by the unit price.<\/li>\n\n\n\n
- Delivery Address<\/strong>: Provided by the customer.<\/li>\n\n\n\n
- Delivery Date<\/strong>: The date your customer receives their order.<\/li>\n\n\n\n
- Order\/Delivery Status<\/strong>: The status of delivery from your location (for example, processing, shipped, delivered).<\/li>\n\n\n\n
- Payment Status<\/strong>: The payment status for each order (for example, unpaid, paid, prepaid).<\/li>\n\n\n\n
- Priority<\/strong>: This column lists the urgency status of the orders (for example, urgent, regular, and very urgent). <\/li>\n\n\n\n
- Notes<\/strong>: Add any additional entries about the order in this column for future reference. <\/li>\n<\/ul>\n\n\n\n
Here\u2019s what it\u2019ll look like for an electronics and food business.<\/p>\n\n\n\n
<\/figure>\n\n\n\n
For an e-commerce business, consider adding the following:<\/p>\n\n\n\n
- \n
- Tracking Number<\/strong>: The number your logistics partner sends you to track the parcel.<\/li>\n\n\n\n
- Shipping Fee<\/strong>: The fee your carrier will charge you to deliver to your customer. <\/li>\n\n\n\n
- Shipping Method<\/strong>: Consider adding this column if you work with multiple shipping partners.<\/li>\n<\/ul>\n\n\n\n
If you are a service-based business, consider adding the following: <\/p>\n\n\n\n
- \n
- Service Time<\/strong>: The time you rendered the service to your customer.<\/li>\n\n\n\n
- Service Provider<\/strong>: The name of the person who provided the service to your customer.<\/li>\n\n\n\n
- Service Status<\/strong>: The status of the service as reported by your customer.<\/li>\n<\/ul>\n\n\n\n
If you are a food order and delivery business, you can add the following for on-time delivery tracking in Excel:<\/p>\n\n\n\n
- \n
- Delivery Instructions<\/strong>: Any additional instructions about the customer’s delivery.<\/li>\n\n\n\n
- Delivery Status<\/strong>: This shows whether the order is still at your location or dispatched.<\/li>\n\n\n\n
- Courier<\/strong>: The person who took the food order.<\/li>\n\n\n\n
- Delivery Time<\/strong>: This column will be updated after delivery has been made.<\/li>\n<\/ul>\n\n\n\n
Entering and tracking orders<\/strong><\/h3>\n\n\n\n
Step 1: Input the data<\/strong><\/p>\n\n\n\n
Once your logistics tracking Excel spreadsheet is set up, you can input your data. Fill in the details as your orders pour in. <\/p>\n\n\n\n
When you start a new order, select a new row to fill in. <\/p>\n\n\n\n
For example, you can only fill in delivery information that you know, like the name of the person making the delivery, any delivery instructions you receive and the delivery address. For “Delivery Status”, you can enter “pending”. You can only provide a Delivery Time and Delivery Date when the order is received by your customer.<\/p>\n\n\n\n
One way to do it is to enter the estimated delivery time and date. However, if you are not too keen on re-entering data repeatedly, we suggest you enter this data only when your customer confirms.<\/p>\n\n\n\n
<\/figure>\n\n\n\n
Step 2: Tracking order status<\/strong><\/p>\n\n\n\n
As you populate your logistics tracking spreadsheet, some patterns will emerge. Depending on the vocabulary you use for order status tracking, your orders may be either processing, delivered or en-route. <\/p>\n\n\n\n
You can use the sort and filter tool to view orders based on specific criteria. <\/p>\n\n\n\n
<\/figure>\n\n\n\n
For example, select the \u201cDelivery Destination\u201d column to view orders by delivery location and click “Sort & Filter”. From the drop-down, select “Filter”. This will add a filter to the column. <\/p>\n\n\n\n
<\/figure>\n\n\n\n
Now all you need to do is click on the small arrow in the corner and select the items you want to filter your sheet based on. <\/p>\n\n\n\n
<\/figure>\n\n\n\n
<\/figure>\n\n\n\n
You can also select a range of values in the pop-up box to see relevant data.<\/p>\n\n\n\n
Step 3: Highlight orders that require action<\/strong><\/p>\n\n\n\n
Use conditional formatting to see which orders need attention. Do this when you have collected sufficient data.<\/p>\n\n\n\n
For example, if you have multiple orders running in a month and want to see how many have been shipped, select the entire data in the Delivery column, click “Conditional Formatting”, and select “Highlight Cell Rules”. Next, click on “Text that contains..”. In the pop-up, enter “Shipped”. Choose the formatting style and click ok.<\/p>\n\n\n\n
<\/figure>\n\n\n\n
<\/figure>\n\n\n\n
This will highlight all the shipped orders as per the formatting rule. As the Shipped orders pop up on the sheet, you can see how many orders have been shipped, the priority status and the delivery method used. <\/p>\n\n\n\n
<\/figure>\n\n\n\n
Managing e-commerce deliveries – H3<\/strong><\/h3>\n\n\n\n
Step 1: Define and assign delivery methods<\/strong><\/p>\n\n\n\n
Before sending your orders, look at the available delivery options. Consider:<\/p>\n\n\n\n
- \n
- Standard Shipping<\/li>\n\n\n\n
- Express Shipping<\/li>\n\n\n\n
- Local Pickup<\/li>\n\n\n\n
- Same-day delivery<\/li>\n\n\n\n
- International delivery<\/li>\n<\/ul>\n\n\n\n
Once you decide on the options, connect with operators in your area and set up partnerships to help you deliver to your customer’s location.<\/p>\n\n\n\n
As you go live and the orders start coming in, enter the delivery method and operator details in your sheet in separate columns. <\/p>\n\n\n\n
This data will help you see which methods are commonly used by your customers and which operator is most effective for your operation. <\/p>\n\n\n\n
You can use conditional formatting to highlight a combination of delivery methods and operators most suitable for your business. <\/p>\n\n\n\n
Discover the 35 e-commerce tools you need to grow your business<\/a>\u00a0<\/p>\n\n\n\n
Step 2: Tracking delivery status<\/strong><\/p>\n\n\n\n
Tracking delivery status is simply updating the delivery status from when the order leaves your premises to when it reaches the customer.<\/p>\n\n\n\n
You can start by marking the delivery status as “pending” as the order arrives. As the order leaves your premises, you can mark the order “Enroute” or “Shipped”. As the order reaches the customer, mark the order “Delivered”.<\/p>\n\n\n\n
You can use your vocabulary and add more levels. <\/p>\n\n\n\n
However, if you ship more than 20 orders daily, updating each order as the status changes can be cumbersome. Set a time and update the delivery status once or twice daily to streamline the process. <\/p>\n\n\n\n
Automating the process <\/strong><\/h3>\n\n\n\n
Consider doing any or all of the following to automate your spreadsheet:<\/p>\n\n\n\n
Step1: Use <\/strong>Excel tracking templates<\/strong><\/p>\n\n\n\n
Download an Excel order & delivery tracking template with predefined column headers, formatting and formulas. Use this sheet as a starting point and adjust it to create one for your business. You can get simple delivery order templates and advanced templates with data validation rules, formulas and even scripts.<\/p>\n\n\n\n
Step 2: Add formulas<\/strong><\/p>\n\n\n\n
To quicken the pace of filling the sheet, add formulas. Use \u201cSUM\u201d to calculate the totals, \u201cCOUNT\u201d to count the number of orders, and regular multiplication and division to process the data. Use \u201cIF\u201d to create constructs and \u201cVLOOKUP\u201d to look through data and analyse it. <\/p>\n\n\n\n
Step3: Import data<\/strong><\/p>\n\n\n\n
For a business not starting from scratch, this is a good option. Fill your sheet with relevant data from the past to get started. Now apply formulas, functions, and formatting to get insights from the data.<\/p>\n\n\n\n
Step 4: Use scripts (optional)<\/strong><\/p>\n\n\n\n
Use this automation technique if you are proficient in VBA. Write a script in VBA to automate any repetitive task and embed the code on your sheet. <\/p>\n\n\n\n
For example, if you want to see reports generated on a sheet, embed a script for it on a button on your sheet. When you click the button, the script will run in the background and display the results.<\/p>\n\n\n\n
Step 5: Use the data validation tool<\/strong><\/p>\n\n\n\n
The data validation tool helps you set a predefined list for any cell on your sheet. Select the cells for any column with a limited set of entry values and use the tool to automate data entry.<\/p>\n\n\n\n
<\/figure>\n\n\n\n
<\/figure>\n\n\n\n
<\/figure>\n\n\n\n
Step 6: Use conditional formatting<\/strong><\/p>\n\n\n\n
As the name suggests, the tool formats data based on the conditions provided. If you wish to highlight orders by a specific customer and his order status, select the customer name column and apply conditional formatting. <\/p>\n\n\n\n
Step 7: Use the SMS plugin<\/strong><\/p>\n\n\n\n
With an SMS plugin<\/a>, you can automate sending updates about the orders from within Excel to your customers. You only need to download and install the plugin in your spreadsheet, and you\u2019re good to go.<\/p>\n\n\n\n
Let’s see how this works.<\/p>\n\n\n\n
Sending orders and delivery SMS to customers directly from the sheet <\/strong><\/h4>\n\n\n\n
For this section, we will use SMSCountry\u2019s Excel plugin<\/a>. If you don’t already have an account with SMSCountry, you can sign up <\/a>or book a demo<\/a> to see how it works.<\/p>\n\n\n\n
Step 1: Download the plugin<\/strong><\/p>\n\n\n\n
Access the plugin from the SMSCountry website. Download and install the plugin.<\/p>\n\n\n\n
Step 2: Open your spreadsheet<\/strong><\/p>\n\n\n\n
Once the file is installed, open MS Excel to reveal the plugin showing SMSCountry in the ribbon. Click on SMSCountry to see all the options.<\/p>\n\n\n\n
<\/figure>\n\n\n\n
<\/figure>\n\n\n\n
Step 3: Log in<\/strong><\/p>\n\n\n\n
Log in using your SMSCountry username and password. If you don\u2019t have an account, you can sign up for free<\/a>.<\/p>\n\n\n\n
<\/figure>\n\n\n\n
<\/figure>\n\n\n\n
Step 4: Upload\/Open your order and delivery sheet<\/strong><\/p>\n\n\n\n
You can upload data, add new data to a sheet or use an existing sheet to send SMS from Excel. Open the relevant sheet and click on \u201cSend SMS\u201d.<\/p>\n\n\n\n
Step 5: Compose SMS<\/strong><\/p>\n\n\n\n
You will see a pop-up on the screen. Enter your SMS and select the fields you want to add to the SMS. You can choose one set of data or a range for your SMS. A range of fields means multiple SMS will be sent. <\/p>\n\n\n\n
Select \u201cPreview And Send\u201d to see how your message will look to your customer.<\/p>\n\n\n\n
<\/figure>\n\n\n\n
Step 6: Send SMS<\/strong><\/p>\n\n\n\n
Hit the send button to send the SMS. Ensure you are connected to the web. You should receive a confirmation message from SMSCountry. You can also schedule the SMS to be sent at a later time.<\/p>\n\n\n\n
Now head back to the SMSCountry dashboard to check the reports.<\/p>\n\n\n\n
Generating reports<\/strong><\/h3>\n\n\n\n
Step 1: Define your requirements<\/strong><\/p>\n\n\n\n
Identify which data points you want to include in your report. <\/p>\n\n\n\n
For example, if you want to create a report about deliveries, you may add delivery methods, delivery times, delivery operators, delivery dates and delivery locations. <\/p>\n\n\n\n
Step 2: Create a Report sheet<\/strong><\/p>\n\n\n\n
Always create a separate sheet in your Excel workbook for your reports. You can merge different reports on the same sheet; refrain from adding reports to your main data sheets.<\/p>\n\n\n\n
Step 3: Use formulas<\/strong><\/p>\n\n\n\n
Use formulas like “SUM”, “AVERAGE”, “COUNT”, “VLOOKUP”, and “LOOKUP to aggregate, summarise and display data based on specified criteria. You can also display total orders, payments received, pending payments, average delivery times and order fulfilment rates. <\/p>\n\n\n\n
Step 4: Add charts and graphs<\/strong><\/p>\n\n\n\n
Visuals make things easier to understand. Choose appropriate graphs from the “Charts” section on the “Insert” tab to create a view of your data. <\/p>\n\n\n\n
<\/figure>\n\n\n\n
<\/figure>\n\n\n\n
Step 5: Format the report<\/strong><\/p>\n\n\n\n
Lastly, format the report for readability and presentation. Use font styles, colours and cell borders to highlight important information or visualise data trends.<\/p>\n\n\n\n
Scale your business with a spreadsheet and SMS <\/strong><\/h2>\n\n\n\n
There you have it. <\/p>\n\n\n\n
Now you can start your own customer tracking spreadsheet in Excel and manage orders and deliveries without worrying. <\/p>\n\n\n\n
Once you get your database up, scale it further by keeping your customers informed. We recommend SMSCountry <\/a>as your SMS partner.<\/p>\n\n\n\n
SMSCountry SMS plugin keeps customers updated on delivery status, from payment to complete delivery, anywhere in the world. It’s fast, reliable and is backed by an army of customer support to help you delight your customers.<\/p>\n\n\n\n
Schedule a demo<\/a> or sign-up<\/a> and try out the platform yourself.<\/p>\n","protected":false},"excerpt":{"rendered":"
As an SME in the e-commerce and logistics businesses, order tracking and fulfilment software can bite deep into your budget. The solution? Create a logistics tracking spreadsheet in Excel and keep all costs low. This blog will take you through creating your spreadsheet from scratch. You will also learn which column headers to use and<\/p>\n","protected":false},"author":15,"featured_media":5138,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[468],"tags":[489,490,491],"class_list":{"0":"post-5129","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-tutorials","8":"tag-e-commerce","9":"tag-logistics-orders","10":"tag-sms"},"yoast_head":"\n
How to Track E-commerce Orders And Deliveries with a Spreadsheet + SMS<\/title>\n<meta name=\"description\" content=\"Learn how to manage orders and deliveries from your spreadsheet automatically. See how SMSCountry's bulk SMS service will supercharge your delivery process.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.smscountry.com\/blog\/logistics-tracking-spreadsheet-excel\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Track E-commerce Orders And Deliveries with a Spreadsheet + SMS\" \/>\n<meta property=\"og:description\" content=\"Learn how to manage orders and deliveries from your spreadsheet automatically. See how SMSCountry's bulk SMS service will supercharge your delivery process.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.smscountry.com\/blog\/logistics-tracking-spreadsheet-excel\/\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-13T01:49:43+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-05-31T08:41:53+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.smscountry.com\/blog\/wp-content\/uploads\/2023\/07\/How-to-Manage-E-commerce-Orders-And-Deliveries-From-a-Spreadsheet-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"620\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Uroosa Kanwal\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Uroosa Kanwal\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"12 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.smscountry.com\/blog\/logistics-tracking-spreadsheet-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.smscountry.com\/blog\/logistics-tracking-spreadsheet-excel\/\"},\"author\":{\"name\":\"Uroosa Kanwal\",\"@id\":\"https:\/\/www.smscountry.com\/blog\/#\/schema\/person\/6ae6cecbfddcc7433176b0f83a476a06\"},\"headline\":\"How to Track E-commerce And Logistics Orders And Deliveries From a Spreadsheet (+ How SMS Can Help You)\",\"datePublished\":\"2023-07-13T01:49:43+00:00\",\"dateModified\":\"2024-05-31T08:41:53+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.smscountry.com\/blog\/logistics-tracking-spreadsheet-excel\/\"},\"wordCount\":2486,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.smscountry.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.smscountry.com\/blog\/logistics-tracking-spreadsheet-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.smscountry.com\/blog\/wp-content\/uploads\/2023\/07\/How-to-Manage-E-commerce-Orders-And-Deliveries-From-a-Spreadsheet-1.png\",\"keywords\":[\"E-commerce\",\"Logistics Orders\",\"SMS\"],\"articleSection\":[\"Tutorials\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.smscountry.com\/blog\/logistics-tracking-spreadsheet-excel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.smscountry.com\/blog\/logistics-tracking-spreadsheet-excel\/\",\"url\":\"https:\/\/www.smscountry.com\/blog\/logistics-tracking-spreadsheet-excel\/\",\"name\":\"How to Track E-commerce Orders And Deliveries with a Spreadsheet + SMS\",\"isPartOf\":{\"@id\":\"https:\/\/www.smscountry.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.smscountry.com\/blog\/logistics-tracking-spreadsheet-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.smscountry.com\/blog\/logistics-tracking-spreadsheet-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.smscountry.com\/blog\/wp-content\/uploads\/2023\/07\/How-to-Manage-E-commerce-Orders-And-Deliveries-From-a-Spreadsheet-1.png\",\"datePublished\":\"2023-07-13T01:49:43+00:00\",\"dateModified\":\"2024-05-31T08:41:53+00:00\",\"description\":\"Learn how to manage orders and deliveries from your spreadsheet automatically. See how SMSCountry's bulk SMS service will supercharge your delivery process.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.smscountry.com\/blog\/logistics-tracking-spreadsheet-excel\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.smscountry.com\/blog\/logistics-tracking-spreadsheet-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.smscountry.com\/blog\/logistics-tracking-spreadsheet-excel\/#primaryimage\",\"url\":\"https:\/\/www.smscountry.com\/blog\/wp-content\/uploads\/2023\/07\/How-to-Manage-E-commerce-Orders-And-Deliveries-From-a-Spreadsheet-1.png\",\"contentUrl\":\"https:\/\/www.smscountry.com\/blog\/wp-content\/uploads\/2023\/07\/How-to-Manage-E-commerce-Orders-And-Deliveries-From-a-Spreadsheet-1.png\",\"width\":1200,\"height\":620,\"caption\":\"How to Track E-commerce and Logistics Orders And Deliveries From a Spreadsheet\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.smscountry.com\/blog\/logistics-tracking-spreadsheet-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.smscountry.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Track E-commerce And Logistics Orders And Deliveries From a Spreadsheet (+ How SMS Can Help You)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.smscountry.com\/blog\/#website\",\"url\":\"https:\/\/www.smscountry.com\/blog\/\",\"name\":\"\",\"description\":\"Also Read:\",\"publisher\":{\"@id\":\"https:\/\/www.smscountry.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.smscountry.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.smscountry.com\/blog\/#organization\",\"name\":\"smscountry\",\"url\":\"https:\/\/www.smscountry.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.smscountry.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.smscountry.com\/blog\/wp-content\/uploads\/2022\/09\/SMSCountry-Logo.png\",\"contentUrl\":\"https:\/\/www.smscountry.com\/blog\/wp-content\/uploads\/2022\/09\/SMSCountry-Logo.png\",\"width\":729,\"height\":299,\"caption\":\"smscountry\"},\"image\":{\"@id\":\"https:\/\/www.smscountry.com\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.smscountry.com\/blog\/#\/schema\/person\/6ae6cecbfddcc7433176b0f83a476a06\",\"name\":\"Uroosa Kanwal\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.smscountry.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/www.smscountry.com\/blog\/wp-content\/uploads\/2023\/01\/63313fc7927fc9137ef9a7bf-60a209e6c997c766936b4572-1675849215287-96x96.jpeg\",\"contentUrl\":\"https:\/\/www.smscountry.com\/blog\/wp-content\/uploads\/2023\/01\/63313fc7927fc9137ef9a7bf-60a209e6c997c766936b4572-1675849215287-96x96.jpeg\",\"caption\":\"Uroosa Kanwal\"},\"description\":\"I thought my destiny was somewhere in the numbers! As I sat in front of the screen frantically coding in Oracle and Linux for my finals\ud83d\udcbb. Later, I gravitated towards financial roles and always imagined myself secluded in a room behind rolls of parchment ticking off numbers and taking inventory\ud83d\udcdc. That was back in 2012. Now I use all of these experiences to help you understand software tools, and the world of customer communication.\",\"sameAs\":[\"https:\/\/www.linkedin.com\/in\/uroosa-kanwal\/\"],\"url\":\"https:\/\/www.smscountry.com\/blog\/author\/uroosa\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Track E-commerce Orders And Deliveries with a Spreadsheet + SMS","description":"Learn how to manage orders and deliveries from your spreadsheet automatically. See how SMSCountry's bulk SMS service will supercharge your delivery process.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.smscountry.com\/blog\/logistics-tracking-spreadsheet-excel\/","og_locale":"en_US","og_type":"article","og_title":"How to Track E-commerce Orders And Deliveries with a Spreadsheet + SMS","og_description":"Learn how to manage orders and deliveries from your spreadsheet automatically. See how SMSCountry's bulk SMS service will supercharge your delivery process.","og_url":"https:\/\/www.smscountry.com\/blog\/logistics-tracking-spreadsheet-excel\/","article_published_time":"2023-07-13T01:49:43+00:00","article_modified_time":"2024-05-31T08:41:53+00:00","og_image":[{"width":1200,"height":620,"url":"https:\/\/www.smscountry.com\/blog\/wp-content\/uploads\/2023\/07\/How-to-Manage-E-commerce-Orders-And-Deliveries-From-a-Spreadsheet-1.png","type":"image\/png"}],"author":"Uroosa Kanwal","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Uroosa Kanwal","Est. reading time":"12 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.smscountry.com\/blog\/logistics-tracking-spreadsheet-excel\/#article","isPartOf":{"@id":"https:\/\/www.smscountry.com\/blog\/logistics-tracking-spreadsheet-excel\/"},"author":{"name":"Uroosa Kanwal","@id":"https:\/\/www.smscountry.com\/blog\/#\/schema\/person\/6ae6cecbfddcc7433176b0f83a476a06"},"headline":"How to Track E-commerce And Logistics Orders And Deliveries From a Spreadsheet (+ How SMS Can Help You)","datePublished":"2023-07-13T01:49:43+00:00","dateModified":"2024-05-31T08:41:53+00:00","mainEntityOfPage":{"@id":"https:\/\/www.smscountry.com\/blog\/logistics-tracking-spreadsheet-excel\/"},"wordCount":2486,"commentCount":0,"publisher":{"@id":"https:\/\/www.smscountry.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.smscountry.com\/blog\/logistics-tracking-spreadsheet-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/www.smscountry.com\/blog\/wp-content\/uploads\/2023\/07\/How-to-Manage-E-commerce-Orders-And-Deliveries-From-a-Spreadsheet-1.png","keywords":["E-commerce","Logistics Orders","SMS"],"articleSection":["Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.smscountry.com\/blog\/logistics-tracking-spreadsheet-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.smscountry.com\/blog\/logistics-tracking-spreadsheet-excel\/","url":"https:\/\/www.smscountry.com\/blog\/logistics-tracking-spreadsheet-excel\/","name":"How to Track E-commerce Orders And Deliveries with a Spreadsheet + SMS","isPartOf":{"@id":"https:\/\/www.smscountry.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.smscountry.com\/blog\/logistics-tracking-spreadsheet-excel\/#primaryimage"},"image":{"@id":"https:\/\/www.smscountry.com\/blog\/logistics-tracking-spreadsheet-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/www.smscountry.com\/blog\/wp-content\/uploads\/2023\/07\/How-to-Manage-E-commerce-Orders-And-Deliveries-From-a-Spreadsheet-1.png","datePublished":"2023-07-13T01:49:43+00:00","dateModified":"2024-05-31T08:41:53+00:00","description":"Learn how to manage orders and deliveries from your spreadsheet automatically. See how SMSCountry's bulk SMS service will supercharge your delivery process.","breadcrumb":{"@id":"https:\/\/www.smscountry.com\/blog\/logistics-tracking-spreadsheet-excel\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.smscountry.com\/blog\/logistics-tracking-spreadsheet-excel\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.smscountry.com\/blog\/logistics-tracking-spreadsheet-excel\/#primaryimage","url":"https:\/\/www.smscountry.com\/blog\/wp-content\/uploads\/2023\/07\/How-to-Manage-E-commerce-Orders-And-Deliveries-From-a-Spreadsheet-1.png","contentUrl":"https:\/\/www.smscountry.com\/blog\/wp-content\/uploads\/2023\/07\/How-to-Manage-E-commerce-Orders-And-Deliveries-From-a-Spreadsheet-1.png","width":1200,"height":620,"caption":"How to Track E-commerce and Logistics Orders And Deliveries From a Spreadsheet"},{"@type":"BreadcrumbList","@id":"https:\/\/www.smscountry.com\/blog\/logistics-tracking-spreadsheet-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.smscountry.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to Track E-commerce And Logistics Orders And Deliveries From a Spreadsheet (+ How SMS Can Help You)"}]},{"@type":"WebSite","@id":"https:\/\/www.smscountry.com\/blog\/#website","url":"https:\/\/www.smscountry.com\/blog\/","name":"","description":"Also Read:","publisher":{"@id":"https:\/\/www.smscountry.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.smscountry.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.smscountry.com\/blog\/#organization","name":"smscountry","url":"https:\/\/www.smscountry.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.smscountry.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.smscountry.com\/blog\/wp-content\/uploads\/2022\/09\/SMSCountry-Logo.png","contentUrl":"https:\/\/www.smscountry.com\/blog\/wp-content\/uploads\/2022\/09\/SMSCountry-Logo.png","width":729,"height":299,"caption":"smscountry"},"image":{"@id":"https:\/\/www.smscountry.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.smscountry.com\/blog\/#\/schema\/person\/6ae6cecbfddcc7433176b0f83a476a06","name":"Uroosa Kanwal","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.smscountry.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/www.smscountry.com\/blog\/wp-content\/uploads\/2023\/01\/63313fc7927fc9137ef9a7bf-60a209e6c997c766936b4572-1675849215287-96x96.jpeg","contentUrl":"https:\/\/www.smscountry.com\/blog\/wp-content\/uploads\/2023\/01\/63313fc7927fc9137ef9a7bf-60a209e6c997c766936b4572-1675849215287-96x96.jpeg","caption":"Uroosa Kanwal"},"description":"I thought my destiny was somewhere in the numbers! As I sat in front of the screen frantically coding in Oracle and Linux for my finals\ud83d\udcbb. Later, I gravitated towards financial roles and always imagined myself secluded in a room behind rolls of parchment ticking off numbers and taking inventory\ud83d\udcdc. That was back in 2012. Now I use all of these experiences to help you understand software tools, and the world of customer communication.","sameAs":["https:\/\/www.linkedin.com\/in\/uroosa-kanwal\/"],"url":"https:\/\/www.smscountry.com\/blog\/author\/uroosa\/"}]}},"_links":{"self":[{"href":"https:\/\/www.smscountry.com\/blog\/wp-json\/wp\/v2\/posts\/5129","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.smscountry.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.smscountry.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.smscountry.com\/blog\/wp-json\/wp\/v2\/users\/15"}],"replies":[{"embeddable":true,"href":"https:\/\/www.smscountry.com\/blog\/wp-json\/wp\/v2\/comments?post=5129"}],"version-history":[{"count":15,"href":"https:\/\/www.smscountry.com\/blog\/wp-json\/wp\/v2\/posts\/5129\/revisions"}],"predecessor-version":[{"id":9572,"href":"https:\/\/www.smscountry.com\/blog\/wp-json\/wp\/v2\/posts\/5129\/revisions\/9572"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.smscountry.com\/blog\/wp-json\/wp\/v2\/media\/5138"}],"wp:attachment":[{"href":"https:\/\/www.smscountry.com\/blog\/wp-json\/wp\/v2\/media?parent=5129"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.smscountry.com\/blog\/wp-json\/wp\/v2\/categories?post=5129"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.smscountry.com\/blog\/wp-json\/wp\/v2\/tags?post=5129"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
- Delivery Status<\/strong>: This shows whether the order is still at your location or dispatched.<\/li>\n\n\n\n
- Service Provider<\/strong>: The name of the person who provided the service to your customer.<\/li>\n\n\n\n
- Shipping Fee<\/strong>: The fee your carrier will charge you to deliver to your customer. <\/li>\n\n\n\n
- Customer Contact<\/strong>: Provided by the customer<\/li>\n\n\n\n
- Look up historical data in a spreadsheet, adjust the scale of orders, and quickly back up a spreadsheet into the cloud.<\/li>\n<\/ul>\n\n\n\n