Tuesday, May 29, 2018

How To Print 1x1 Shipping label on a 2x2 A4 Generic Sticker Paper

When you are running a startup, you will face numerous business problems on a daily basis. Some problems are within your core competency and some fall outside your comfort zone. Being a startup founder, you really cant afford to not solve the problem because it falls outside your comfort zone. Also at times, you only need to be street smart to solve the problem and move on :)

I recently faced one such, not so interesting problem, but it was essential for me to solve it.

Background

We ship books to our customers in India and we recently moved to Delhivery as our delivery partner. Have you noticed the stickers on the packaging, when you receive deliveries from Amazon/Flipkart/Delhivery etc? Those stickers are called Shipping Label. It has bunch of information like:

  • Who is the package for.
  • Where is it coming from
  • Contact details of the client 
  • Contents of the package and its approximate value
  • And many other things.
This is how a Shipping Label looks:

When we create the shipment in Delhivery portal, they generate the shipping label for us. Shippers are supposed to print it and affix it on the shipment. So far it feels normal and business as usual, what's the problem is not clear?

The Problem

We usually we ship in bulk, hence we ship to hundreds of our customers in one batch. Delhivery generates a PDF with 1 shipping label on every page, hence if we are shipping 100 shipments, Delhivery will generate the PDF with 100 pages i.e. 1 label on each page in a 1x1 format.

If we had access to a specialised printer which could print these stickers on a sticker roll, that we would be sorted. But unfortunately we didn't have that printer.

There are generic sticker papers available in the market to print shipping labels. However each A4 size generic sticker paper would cost around Rs. 5. Its not optimal from cost as well as resources perspective to print just one sticker on the entire A4 page.

Considering the size of the Shipping Label, we could easily print 4 shipping labels on one A4 size paper. If we were able to do it, the cost of printing one label will drop 4 folds. Something like this


Initially you might think, why is saving few bucks so important. Thats because of a simple concept called unit economics. If you ever want to get your startup in the successful zone, you need to get the unit economics right :D!

The Solution

Now that we know whats the problem and why we need to solve it, lets focus on how did I get it done.

Speed of execution is everything in startup world. I had to solve this in way that its easily doable by any non-tech operations guy, at the same time I didn't have the luxury to build a sophisticated custom solution. 

So, what did I do? I tried to breakdown the problem into smaller steps and try to solve each of those smaller steps.

  • First thing I observed in the Shipping Label's PDF was that, There was some extra information around the shipping labels like the footer of the page and some more unimportant stuff. 
  • In order to arrange it in 2x2 format I need to trim the unimportant stuff. For this I looked for a site that could help me trim all the PDF pages in one go. Sejda was perfect for this. The free plan has some restrictions but we could live with those.
  • You could upload the PDF and you could crop all pages with a mask in one go. What I got after that was a PDF with all pages having only the important stuff.
  • Next, I need to export each page as a separate image either in PNG or JPEG format. This was necessary so that I could use mail merge to actually arrange the shipping labels in 2x2 format.
  • I exported the PDF pages to png using pdf2png site. The result was a zip file with all the PDF pages exported as PNG files.
  • Final step was to use "Microsoft Word Mail Merge" to arrange these images in 2x2 grid. I followed the this nice article, to get that done.
  • Once I followed the steps, I finally got a 2x2 grid of all my shipping labels. These could be printed on a generic A4 paper with a 2x2 sticker grid.
  • In the end, I had a very low tech solution (which could be easily followed by any Operations guy) to a business problem.
The entire solution is in line with the theory suggested by Mark Watney, from The Martian :)
You solve one problem... and you solve the next one... and then the next. And If you solve enough problems, you get to come home!


Voilà, my job here was done!

16 comments:

  1. It is really a helpful blog to find some different source to add my knowledge.Shipping from China to US

    ReplyDelete
  2. Packing function in SAP system is very important for Distribution centers and Retail outlet stores in order to exchange their goods data requirements between suppliers and Ship-to parties. The Ship-to parties can scan and check the goods through Pallet/Carton label information.

    ReplyDelete
  3. The shipping can definitely be the most intimidating. Once you get your system down it isn’t to hard. And once you have a few sales under your belt you get the idea of cost so you don’t actually have to measure and weigh the item before hand. In the beginning you will want to measure and weigh it, at least a good estimate so you have an accurate shipping quote.It takes time for me to box stuff up, so I usually charge a handling fee as well.I decided to write my e-book that comes out Monday that goes into more depth about everything shipping! I hope it can help clarify some things for everyone! 🙂Professional Shipping Companies

    ReplyDelete
  4. I LOVED the tips about purchasing items that you’ll use more than just one time because of an impulse buy! I was in Scotland this year and it started to rain (as it always does) and I bought a compactable umbrella instead of a plastic poncho! This was so informative and helpful.Yoga Clothing

    ReplyDelete
  5. Hi, Try galleon.ph. I always perfer galleon when it comes to buying items from amazon, ebay and other online store that dont ship here in the Philippines, check their website. less hassle they had cash on delivery service.
    Digital Marketing

    ReplyDelete
  6. we prefer medium-sized shoeboxes, since more of these fit in our larger shipping containers, which helps us maximize your shipping donation. This also helps ensure children receive similar sized shoebox gifts at outreach events. We do accept and ship every shoebox we receive, regardless of size.
    best breweries in Sacramento

    ReplyDelete
  7. Hello, Really what a blog! I got to know the entire process of shipping a car from one region to a different region. dsd delivery is a effective get all your distribution needs covered.
    Hemp Crop Insurance

    ReplyDelete
  8. An awesome list there. I have to say that I learned about carrying some of the things the hard way, like a torch of some kind is so important for the reasons you gave and definitely slippers for the bathroom. Ear plus are another essential item and eye mask I can usually do without. I would add headphones to the list, to listen to music or else just while being on the phone is a lit more private.
    Nonton Anime

    ReplyDelete
  9. we prefer medium-sized shoeboxes, since more of these fit in our larger shipping containers, which helps us maximize your shipping donation. This also helps ensure children receive similar sized shoebox gifts at outreach events. We do accept and ship every shoebox we receive, regardless of size.
    Free Prague Guide

    ReplyDelete
  10. It is really a helpful blog to find some different source to add my knowledge. Shipping from China to Amazon FBA

    ReplyDelete
  11. we prefer medium-sized shoeboxes, since more of these fit in our larger shipping containers, which helps us maximize your shipping donation. This also helps ensure children receive similar sized shoebox gifts at outreach events. We do accept and ship every shoebox we receive, regardless of size.
    hawaiian yoga pants

    ReplyDelete
  12. I love all your ideas. I've always thought I should get involved in one of those Cookies for Soldiers programs or something. Thanks for sharing amazing information.
    Bandarapoker

    ReplyDelete
  13. we prefer medium-sized shoeboxes, since more of these fit in our larger shipping containers, which helps us maximize your shipping donation. This also helps ensure children receive similar sized shoebox gifts at outreach events. We do accept and ship every shoebox we receive, regardless of size.
    swim with dolphins kona

    ReplyDelete
  14. we prefer medium-sized shoeboxes, since more of these fit in our larger shipping containers, which helps us maximize your shipping donation. This also helps ensure children receive similar sized shoebox gifts at outreach events. We do accept and ship every shoebox we receive, regardless of size.yubi store

    ReplyDelete
  15. we prefer medium-sized shoeboxes, since more of these fit in our larger shipping containers, which helps us maximize your shipping donation. This also helps ensure children receive similar sized shoebox gifts at outreach events. We do accept and ship every shoebox we receive, regardless of size.Tent rental

    ReplyDelete
  16. We read your blog , share most useful information in blog . Shipping from China to Amazon FBA

    ReplyDelete

Have some Fun!