How to manage your products & stock like a pro

Home / How to manage your products & stock like a pro
Do you store and manage online store products, printed marketing material, e-commerce stock, stock for retails stores or just store a lot of business related material?

Do you store and manage online store products, printed marketing material, e-commerce stock, stock for retails stores or just store a lot of business related material?


Managing your inventory and product stock can get confusing fast. Between manufacturing, ordering, storing and fulfilling orders,  staff can get easily overwhelmed. The biggest mistake you can make is to manage your stock on an ad hoc basis.


However, managing your stock doesn’t have to be hard. By using simple spreadsheets and getting organised at the beginning, you can save yourself time and money – without using expensive software programs.


Here are the three main elements to getting your products organised and efficient. Download our Stock Management Guide for more detailed info, free templates and spreadsheets. OK, Let’s get started!


1.   Create a product List 

Knowing exactly what products you stock sounds simple, but essential information is often overlooked. Keep an up to date and detailed product list to be used as a master for all other management documents and spreadsheets.

Key elements of your product list are
– SKU Codes
– Product Names
– Description
– Attributes
– Unit Prices


Versatile lists can also include information on suppliers and discontinued stock. Download our guide for your free product list template.

2.    Manage your stock inventory

Knowing exactly how much stock you have is the simplest and easiest way no to lose anything. Lost stock will straight up hurt your bottom line. Managing your incoming and outgoing stock is essential for re-ordering and keeping everything up to date. Your stock inventory will help you keep track of

– In stock quantity
– Average sales
– Re-order quantities
– Re-ordering dates
– Re-ordering lead times


All these numbers can easily be calculated using an excel spreadsheet. Inventory and stock management systems can integrate with your ordering system, however they can be too expensive for start up stores. Using a spreadsheet is a simple way to get started.

3.   Manage your stock locations

Managing the location and movements of your stock is one on the hardest things as a small business owner. If your garage or shed is the location of your mini-warehouse then space constraints are going to be the #1 factor. Organisation will be the key to making your warehouse work.

– Managing your stock locations will includes
– Picking bays
– Stock replenishment
– Palette storage


Managing your stock locations is the trickiest and most time consuming part of storing your products at home. Using stock location codes will make it easier to track and locate stock. If your store has more than 5 orders a day it may be time to move your warehousing and distribution to a professional company.


Now that you understand the three main parts of organising and managing your online stock products, you are on the way to running an efficient system that is ready for growth. Are you ready start creating your lists and inventories? Download our Stock Management e-Guide by clicking here. 
Want to know more about Quickmail’s warehousing and fulfilment services? Contact us on 08 9493 0477.




unique wedding invitations

I have been exploring for a little bit for high quality articleѕ or weblog posts on this sort of area. Exploring in Yahoo I at last stumbled upon your site.

Reading this information, I am glad to express that I’ve found just what I needed. I certainly will make sure I keep looking on your blog regularly!

hair color loreal

Excellent post. I used to be checking continuously this
weblog and I’m impressed! Extremely useful info specially the final
section 🙂


Leave a Comment

Facebook Feed

DHL in New Zealand sent prospects the world's largest direct mail package - an envelope over 3 feet by 2 feet!

Think of ways to make your package the most intriguing, the most provocative, the most unusual one that your prospect will receive that week!
... See MoreSee Less

View on Facebook

7 Reasons to Use Direct Mail

Direct mail enters an individual’s home and is consumed on a one-to-one basis. This gives you much more time with your customer, time to engage them in a relaxed environment
at a time of their choosing.

The physicality of a mailing adds another dimension to the brand experience. Using your customers’ senses, you can stimulate and entertain, getting them to reassess your
brand and drive response.

Direct marketing works best when it’s made relevant for the recipient, with tailor-made content appealing directly to the consumer. New digital printing technology can make this
personalisation even easier.

Direct mail is the most likely form of communication to get a response from a customer, with the cost of every response
measured with accuracy. As it’s a tangible object, DM is also likely to hang around.

Reports have demonstrated the enduring effectiveness of direct mail, with the Direct Mail Association stating 65% of consumers
of all ages have made a purchase as a result of direct mail.

Direct mail is unique in that mailings can be produced in a wide variety of formats, using different shapes, sizes, colours and materials to create a surprising and memorable brand experience that will stay in the home for weeks and even months.

Adding direct mail to an integrated campaign can raise the campaign’s effectiveness by up to 62% (BrandScience), while bridging technologies such as QR codes and augmented reality make it simple for consumers to go from print to digital.

Source: VoPP
... See MoreSee Less

View on Facebook