Creative Hive

Creating buzz for your business

  • About
  • Blog
  • Free Class
  • A Sale A Day
  • Contact
  • Student Login

How to create a wholesale linesheet in Microsoft Word or Pages for Mac

  • Facebook60
  • Twitter16
  • Pinterest693
  • 769shares

How to create a wholesale linesheet in Microsoft Word or Pages for Mac

Over at the Academy of Handmade, I wrote a post on 5 things to consider before you jump in and do wholesale.

If you're inspired and you think you'd like to take wholesale on, awesome!

I'm right here with you on that and think it's a great source of income.

Here's a list of the 7 steps you need to take to turn on your wholesale game.

One of those steps is creating your wholesale linesheet.

But you're not quite sure how to create a wholesale linesheet so here's a technical how-to for non-techies:

Using just Microsoft Word or Pages for Mac, you can create a wholesale linesheet that is super easy to set up and maintain.

You don't need to pay for a subscription or service, you don't need to hire a graphic designer.

All you need to do how to do is insert tables and photos, which I promise is as easy is making text bold or center aligned.

This tutorial will show you how to make your wholesale linesheet in Word, but the same concept applies to Pages so it's easy to translate for Mac users!

Bonus: Download my free editable wholesale order form template to go with your linesheet!

Getting started

The first thing you want to do is open Microsoft Word (or Pages) and create a blank document.

Then decide on a size for your linesheet and your page orientation.

For size, I would recommend with the standard printing paper size of 8.5 x 11″ or half of that which is 5.5 x 8.5″.

You can set your own size too.

How to create a wholesale linesheet in Microsoft Word or Pages for Mac

Your orientation could be vertical or horizontal, that's up to you!

How to create a wholesale linesheet in Microsoft Word or Pages for Mac

Add in your logo, contact info and page numbers

You can do this by going to the Insert tab and insert a Header. The default or first option will work.

How to create a wholesale linesheet in Microsoft Word or Pages for Mac

Then insert a Picture and browse to the location of your logo.

This will insert your logo into your header and every additional page you make will include this logo.

How to create a wholesale linesheet in Microsoft Word or Pages for Mac

Then you can insert a Text Box to enter in your contact information so stores will know how to reach you or submit orders.

How to create a wholesale linesheet in Microsoft Word or Pages for Mac

Once you've filled in your contact information, you'll need to remove the border on the Text Box (and also remove the background color- even though the white matches the current background).

Do this by right clicking on the corner of the Text Box and select Format Shape from the menu that appears.

How to create a wholesale linesheet in Microsoft Word or Pages for Mac

The screen below will appear on the side.

Fill is the background color for the Text Box.

Line is the border, which is black by default.

Select “No Fill” and “No Line” for both.

How to create a wholesale linesheet in Microsoft Word or Pages for Mac

To make the contact info in my Text Box look even better and fit with my logo, I removed the “space after paragraph” and changed the blue links to black text.

How to create a wholesale linesheet in Microsoft Word or Pages for Mac

My header now looks like this, and it will be the same for every page after this!

How to create a wholesale linesheet in Microsoft Word or Pages for Mac

It would be a good idea to add automatic page numbering on the bottom of your pages as well:

How to create a wholesale linesheet in Microsoft Word or Pages for Mac

I like using the “Page 1 of 1” format because the store owner will know how many pages to expect in your linesheet and know if a page is missing. No surprises here!

Getting your products in there

How to create a wholesale linesheet in Microsoft Word or Pages for Mac

To get your products in your linesheet, you'll first need to create the structure for it!

Go to the Insert tab and insert a Table. Each product goes into their own little box, so in the above example (see the orange boxes), there will be 12 products – 3 across and 4 down. You can decide how many products you want to go in each page.

Once you've inserted your table, click your mouse inside the first top left box (these little boxes are called “cells”).

Then Insert a picture of your first product! You do this by going to the Insert tab, and select Pictures, just like how you did for your logo at the top of the page.

How to create a wholesale linesheet in Microsoft Word or Pages for Mac

Make sure the photos you've selected are all the same size!

Next, click in the next “cell” or box, to the right of the one you were just in. Insert a photo in there too.

Rinse and repeat until all your products are in the page!

You'll now have something that looks like this:

How to create a wholesale linesheet in Microsoft Word or Pages for Mac

Add product information

You'll now need to add product info like:

  1. Product name
  2. Price
  3. Size
  4. Item ID

To do this, click inside a cell just to the right of your product photo. Hit Enter to start a new line. And start typing!

How to create a wholesale linesheet in Microsoft Word or Pages for Mac

Repeat for all your products.

You'll then have something that looks like this. We're getting close!

How to create a wholesale linesheet in Microsoft Word or Pages for Mac

Finishing up…

This next step is the magic key to turning this into something super beautiful!

We're going to remove all the black lines. Right click anywhere inside your table and select Table Properties from the menu.

A window will appear. Click on Borders and Shadings at the bottom.

How to create a wholesale linesheet in Microsoft Word or Pages for Mac

In the new Borders and Shading window, click on “None” to remove ALL the borders!

This will feel so satisfying!

How to create a wholesale linesheet in Microsoft Word or Pages for Mac

 Here's what we have now, in all its glory:

How to create a wholesale linesheet in Microsoft Word or Pages for Mac

Saving your file

Save your file first as a Word document. This makes it editable so you can update your linesheet easily in the future.

Then Save your file again as a PDF file so you can email your linesheet to stores or send your linesheet to printing services.

To save as a PDF, Save As the file and under “Save as type”, select PDF from the menu.

How to create a wholesale linesheet in Microsoft Word or Pages for Mac

And there you have it.

Bonus: Download my free editable wholesale order form template to go with your linesheet!

How to create a wholesale linesheet in Microsoft Word or Pages for Mac

If you need more help on how to do wholesale, Handmade Marketing That Works is a self-paced course that goes talks about wholesale in-depth.

It's super affordable and it covers many areas of marketing as well, like social media and email marketing.

If you liked this post, you'll love Handmade Marketing That Works. Get instant access to the course today.

Grab my free editable wholesale order form template on your way out

wholesale-order-form-template-download

 


  • Facebook60
  • Twitter16
  • Pinterest693
  • 769shares

Other helpful articles you might like:

A Look Inside my First 15-Year-Old Business Journal For today’s post, I thought I would do something a little different. I’m going to flip through and talk about my very first business journal from ...
How to raise your prices You need to raise your prices. Have only about a quadrillion people tell you this about your products? Or deep in your heart, you know you're n...
How to respond to “I could make that” in your handmade bus... You're busting your butt doing a craft show on a hot and humid Saturday. Your booth catches the eyes of two women and they walk over. They l...
What I’m Grateful For (Thanksgiving Edition) Since it's Thanksgiving today I thought it would be fun to do a Thanksgiving edition post. I will share with you the top four things that I am ...

Comments

  1. Christina Lowry says

    June 4, 2015 at 8:33 pm

    Thanks so much for this fantastic step by step tutorial. I have used it to create a professional looking line sheet that I am really pleased with! :)

    Reply
    • Mei says

      June 6, 2015 at 8:44 am

      I’m so happy to hear that Christina!!

      Reply
  2. Andrea says

    July 30, 2015 at 12:21 pm

    Wow!!! This tutorial is worth it’s weight in gold!! I love it and it will save me much frustration. Thank you so much for all you do:-)

    Reply
    • Mei says

      July 30, 2015 at 12:22 pm

      You’re sooo welcome, Andrea! I’d love to see what you come up with. Just send me an email! :)

      Reply
  3. stella says

    October 13, 2015 at 1:27 pm

    Hi thanks for the info. I got stuck in inserting my pictures having trouble with the cell

    Reply
    • Mei says

      October 13, 2015 at 3:51 pm

      Hey Stella! Can you be more specific with where you’re having trouble? If you can explain what’s happening on your end, I might be able to lend a hand!

      Reply
  4. Julieanne Steedman says

    March 30, 2016 at 8:37 pm

    I can’t say thanks enough. I have been stressing all week about creating this, contemplating signing up for websites and what-not. It took me like 20 minutes. Thanks SO much!

    Reply
    • Mei says

      March 31, 2016 at 1:30 pm

      I’m so happy this helped, Julieanne! I was faced with the same challenges. So many programs out there that help you make linesheets but cost a monthly recurring fee (that I couldn’t justify since it’s not a monthly recurring thing they need to support…)

      Word is my best friend for making all sorts of print material! :)

      Reply
    • Ellen Lyons says

      May 24, 2016 at 5:12 pm

      Feeling hopeful after also stressing about this issue as I prepare for the American Made Show in Dallas. Not having a line sheet is not an option. Thank you Mei!

      Reply
  5. dan says

    September 15, 2016 at 3:59 pm

    This was super helpful! Just one question. My PDF comes out to around 60 mb, which means I can’t attach it to an email. How can I make it under 25mb? Should I resize my photos and upload them again? Or do you have a method to reduce the size of a PDF.

    Thanks!

    Reply
    • Mei says

      September 26, 2016 at 7:39 am

      If you have Adobe Acrobat, you can open your PDF, and resave it with lower image quality settings. Here’s a tutorial: https://acrobatusers.com/tutorials/reducing-file-size
      Or try: https://smallpdf.com/compress-pdf

      Reply
  6. Jules says

    September 20, 2016 at 10:55 am

    Excellent tutorial, Mei! Thank you for putting in the time and effort to share this information. I continue to learn so much from you, and I’m forever grateful! You rock!! :)

    <3
    Jules

    Reply
    • Mei says

      September 26, 2016 at 7:39 am

      I’m glad you found this helpful, Jules!

      Reply
  7. Sharon says

    October 8, 2016 at 2:57 pm

    This is great! Thanks so much for sharing this information! So helpful and exactly what I was looking for. I really appreciate it! :-D

    Reply
  8. Janice says

    January 9, 2017 at 2:17 pm

    This is exactly what I needed, so thank you so much for putting this together for all of us who want to take our business to the next level.

    Reply
  9. Katie says

    February 2, 2017 at 3:27 pm

    This was a fantastic tutorial!!!! Easy to follow. Thanks!!

    Reply
  10. Ashlee says

    April 4, 2017 at 7:44 pm

    Hi Mei,
    2 questions. Is it necessary to include retail price and how do you feel about including more than one photo for the product? We have larger houseware products.

    Reply
  11. Nafiisah Mamode Ally says

    April 23, 2017 at 6:42 am

    Great tutorial, easy to follow and create a new line sheet. Thanks so much for sharing!

    Reply
  12. Vikie says

    June 11, 2017 at 8:23 am

    Thanks it was easy to follow witj great results.

    Reply
  13. Donna Harmon says

    September 27, 2017 at 11:38 am

    So easy to understand. Thank you for sharing.

    Reply
  14. Jenn - Being Whimsical Cards says

    November 6, 2017 at 7:51 pm

    Thank you thank you thank you. Your tutorial was so easy to understand, I had it completed in no time.

    Reply
  15. Rolene Johnson says

    December 21, 2017 at 9:06 am

    Thanks for info! I do a variety of jewelry items and some seasonal products. Should I try to fit as much as possible on one sheet, or divide up with necklaces on one sheet, earrings on another, or divide by “collections”? How many sheets would be acceptable to have for a potential wholesale customer?

    Reply
  16. Virginia says

    April 16, 2018 at 2:02 pm

    Mei,

    Thank you so much for this template! I found it super helpful before I presented my line at my first boutique! She loved the line and will be bringing it on as part of her collection.

    Can’t wait to check out the wholesale order sheet.

    Reply
  17. Sue says

    April 21, 2018 at 10:29 am

    Thankyou Mei! Very helpful indeed

    Reply
  18. lauren says

    April 4, 2019 at 4:40 pm

    I did this and I still can’t fit more than two rows on a page. My line sheet is now 14 pages long when it needs to only be 5 or 6!

    Reply
  19. Joyce Dowridge says

    August 2, 2019 at 2:14 pm

    Thank you so much for putting the step by step instructions on how to do a Line Sheet. When my potential buyer asked me for one, I didn’t have a clue. I googled and found you! I created my sheet very easily and it’s nice. Now I will check out your Wholesale Order Form Template!

    Reply
  20. Grace-M says

    September 16, 2019 at 7:32 am

    I found this really helpful. Thank you so much.

    Reply
  21. Justine says

    January 12, 2021 at 4:05 pm

    Great information, thank you so much

    Reply
  22. essaywritersbot.com says

    February 9, 2021 at 9:42 am

    You should take part in a contest for one of the highest quality blogs online.
    I most certainly will recommend this web site!

    Reply
  23. Jigme says

    May 19, 2021 at 2:54 pm

    Thank you so much for this step by step guide. We’re also looking to create line sheet and this really helped :)

    Reply
  24. Jennifer Fiske says

    August 13, 2021 at 12:52 pm

    Thank you so much! This was so helpful!

    Reply

Trackbacks

  1. What is a Line Sheet and How You Can Use It to Increase Sales with Ease says:
    April 24, 2016 at 8:40 pm

    […] CreativeHive site also has a handy DIY line sheet tutorial that walks you through the whole […]

    Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

I'm Mei ('may') from Minneapolis. I want to help you build a sustainable, profitable handmade business that makes you consistent income and sales. I only ever teach or recommend marketing, social media, pricing, production and branding tips that I've personally used in my own handmade business and that I know work.
Read More…

Famous Posts You’ll Love

2014 Income Report for my Handmade Business Pricing Handmade Items Guide 7 Steps to Start Selling Wholesale and Bring in the Big Bucks! How to take perfect product photos on a white background How to make your own logo for under $5 What to do when people complain that your prices are too high

As seen on

Mei Pak on Creative Live

Design Sponge
Oh My! Handmade
Create & Thrive
Handmade Success
Handmadeology
Launch Grow Joy

Looking for something?

Categories

  • Advertising
  • Branding
  • Business Growth
  • Business Lifestyle
  • Design
  • Ecommerce
  • Etsy
  • How-to
  • Long-term strategy
  • Marketing
  • Photography
  • Podcasts
  • Pricing
  • Reviews
  • Social Media
  • Wholesale

Copyright © 2022 Mei Pak at Creative Hive Co.