Food label printer

[75]

I butcher a complete deer, so I will need labels for 2 haunch’s, 2 back straps, shoulders and mince.
Let’s say I have created a spreadsheet with 7 lines For the items above.
column 1 will be date packed, column 2 will be meat, ie haunch, mince etc, column 3 would be weight, column 4 price.
column 2, 3 and 4 on each line Will be different.

I am looking to get the printer to print off each line as a label. I think the link shows how to do it. I haven’t had time to play with it though.

PM me if the link doesn't help but that's exactly what I do. I have a template set up with dropdowns for species, cuts, weights, date etc. I then just set up the spreadsheet for what I'd like printed, save it and then select the relevant rows in P Touch.

 

[75]

When you open PTouch it just mirrors your spreadsheet data in the bottom half of the screen. You just check the box against the rows you want printed. My template is a bit messy but PTouch only looks up certain cells and ignores the rest so it doesn't matter. As it only prints checked rows you can either have loads of rows for each cut (i.e. 8 rows for steaks if you have 8 packs to label) or have a single row for each cut and select only the "steak" row and print it 8 times on the print menu. If you do manual cut of the labels when you're finished then they all still end up on the same strip.

I've obviously deleted a bit of data from the label sheet (my address and phone number).

 

[willie_gunn]

Question. How do you take the data from a SS and import it into P editor so it prints out all your labels in one hit?
currently I am printing one at a time and changing the data which takes me as long to do as it does to butcher the deer.
Or does anyone know a video showing how to do it?

This is exactly what I do - fill in the spreadsheet with all the cuts and then print them in one go using the Merge function.

Your venison label that you created in P-Touch should be linked to the Excel sheet where you enter the details of the various cuts from the carcass.

If you have not done so already, what you will need to do is to link the fields in the label with the fields in the Excel sheet. To do this open the P-Touch editor software and click on "File", "Database", "Connect" and then use the browse function to find the spreadsheet.

It may then ask you to "connect" the relevant fields. This should be pretty obvious, but it will look something like this:



Basically what you're doing is telling P-Touch for each field where it should look in the spreadsheet. Not every field has to have a link to the spreadsheet - for example my Hunter ID number is the same every time, so I just have it as a regular text field on the label.

I use the same spreadsheet all the time to enter the detail of the cuts, as I have set it up with drop-down boxes for species, etc. Basically I set up the first roe (species, cull date, packing date, carcass ID number, cut, weight, etc.) and then copy that line down enought times to cover all the vacuum packs I have from the carcass. Then when it comes to printing the labels, P-Touch offers various options, such as to print every record in the spreadsheet, print a specific record, or print a range of records. Be sure to choose the right option, as there's nothing more annoying than seeing labels spewing out of the printer for the 3 deer you butchered last time rather than just the first 7 or records you actually wanted this time

If you're still stuck, drop me your email address and I can share the label template, the spreadsheet, and instructions on how it all works.