How can I efficiently print barcode labels for received PO items on Shopify POS?

We are in our first month with Shopify POS. We moved from Intuit POS to Shopify POS. One of our biggest pain points is barcode printing, especially with received items from PO. For example, if I have a PO that contains 300 individual items, ranging in quantities from 1 to 5 for each item, after I go through and receive the items, I cannot instruct Stocky or Shopify to print only the labels from the items I received. This was possible in Intuit POS. After I did the receive process, I would click generate labels and it would print barcode labels to sheets of Avery labels on a printer. With Shopify, after I receive the items, I then have to go in and search for each item (hundreds of items) and then click Print Barcode and then go in and adjust the inventory for each barcode label. With Intuit POS, this took minutes. It now takes me hours. How close is Shopify to adding this feature. Without it, I’m not sure if Shopify will work for many of us coming from Intuit POS, especially those of us who have 100’s of items on a PO and generate barcode labels. Thank you

Thank you so much for posting this. We are on the fence about switching from QB POS and I’ve been trying to watch all of the Shopify demo videos. Saw one on printing tickets and thought ā€œSurely, it cannot be this difficult to print tickets for a PO.ā€ I currently print hundreds of tickets a day, I cannot imagine any scenario where this would get more difficult. Please post updates if you find any easier way. Thank you

This issue was discusseed in our office yesterday. It is going to slow down printing barcodes tremendously. Because so many retailers are transitioning from Quickbooks to Shopify I am hopeful this issue will be addressed soon to make the process more efficient. The fact the Shopify Community Administrators are not responding AT LEAST daily is very disappointing.

So we have not yet tested this to see if it works but we had a meeting with shopify this morning and were shown this process to print labels for just the received products. It is only for Dymo printers. Is this what you are using?

We have a Dymo lablewriter 4xl printer that I was unable to set up a few days again. I’m hoping it will work when we try again.

Thank you. We looked at this but given the volume of labels, we use the Avery Label Sheets (8.5 x 11 with 30 labels per sheet). It would be quite expensive and time consuming to use the Dymo printer as it does single labels and we are often printing 100’s at a time. Shopify should have a way to chose multiple printers and associated Label Template.

I ended up using Microsoft Word and Excel to print labels for my store after migrating. Using the mailings tab on word and using the CSV file from Stocky I made a custom label template on Word, filled in the data from the Excel spreadsheet. Had to make a macro to expand the csv for how many was received. Word probably already has a sticker template for Avery labels. Its a little clunky and I wish shopify would make a way to print on printers other than Dymo.

Hi everyone! Thank you for sharing your feedback here about this concern. I can tell from your comments that this is a really important issue for you all. While we always share merchant feedback from our community forums to our developers, I would also encourage you all to reach out to our dedicated Quickbooks Migration team to let them know that this is a needed feature for you:

Direct phone line: +1 833 476 1302

Hours Of Operation: Monday - Friday, 9am - 4pm EST

Shopify POS for QuickBooks Merchants

The more feedback we receive the better the chance is that we can get this feature implemented!

Shay, thank you. I spoke with the Shopify team in June, before we rolled this out when we discovered this issue. The team said they added the request with the developers. If, however, this cannot be fixed, I may not be able to use Shopify as I am spending far too much time and frustration to print labels. Best guess is it has consumed 15+ more hours each week just for this task (then add in the fact that the label template doesn’t properly align with any label sheet). The steps to print on Avery Sheets after receiving are the following:

  • Receive Items on the PO (Hundreds)
  • Go to Retail Bar Code Labels
  • Click Print Labels
  • Search for each individual item and click to select the item (do this 100’s of times)
  • Click Print
  • Scroll through the 100’s of items that were selected from the newly received PO and then adjust the quantities for each item, matching the quantity received. Do this for 100’s of items.
  • Print

Possible Solution:

  1. Shopify (or Stocky) generates a way to save a report of items just received and associated quantities from the PO that can be merged into a Retail Bar Code Printing Script.
  2. Or, Shopify (or Stocky, when you click Done when receiving items, instead of only integrating with Dymo, integrate with Retail Bar Code temples so the items and associated quantities can be printed to label sheets.

One last question, if there is a dedicated Shopify POS QuickBooks Migration Team, why wouldn’t they be monitoring this Group?

To Shopify - a possible solution to provide your development team. In Retail Barcode Labels, after I press Print Labels, why not provide the ability to search for Items by the PO. If I could search for a PO Number and then it pulled up everything in that PO, it would end the Individual items searches. At that point, I would have a list of everything in that PO. In this solution, I would then have an option to either individually select items or press Select All Items from the search. From there, I can press Print Labels and pick from one of my templates.

Hi DDREAM I’m wondering if you have tried an alternative label printing app? We haven’t gotten to the point of printing labels for new PO’s received but I think Barcode Man app will do what you want. The Retail Barcode app from Shopify doesn’t work for the labels we use so we have gone third party. When I just checked here i what I see about importing a CSV from Stocky

Shopify support has been less than stellar. It’s very disappointing that the help articles are generic and, it appears, the support staff are not elevating questions they are unable to answer to technical support. Had I known skus are not supported when we import from QB POS we would never have chosen Shopify POS.

Shopify support or community monitors need to research this and post if this is an actual solution. The migration is already way too time consuming to put another work around on our plate.

Thank you. I researched Barcode Man and they do not offer this feature. In fact, in their review section, someone is also indicating this feature does not exist. Shopify needs to address this as it requires countless hours to generate barcode labels when receiving from a purchase order. It simply is not sustainable. It would be nice to hear if Shopify will address this soon, otherwise I may need to start the process all over again obtaining a new POS system.

Shay, do you know if the Shopify Development Team is considering addressing this issue? As ā€œStoresā€ get closer to the cutoff date in October for the Intuit POS system, and for those who then switch to Shopify, this will really impact them. For me, I am spending far too much time to print labels and may need to switch if a solution is not created.

Steps I used to make labels:

  • Make label sized blank document (https://www.avery.com/help/article/finding-a-word-template-on-a-windows-pc)
  • Download the .csv of a received Purchase Order on Stocky
  • Because I want to display product variants on my tags I have to edit the file in excel. Find and replace ā€˜Default Title’ with ’ ’ so that products without multiple variants don’t all have ā€˜Default Title’ on each tag.
  • I use a macro to expand the list so that each product has its own line so if I ordered 3, there will be 3 rows so 3 tags print. Choose a column that has the quantity ordered when the dialog box opens. Macro at bottom of post.
  • Once saved, back in word with the blank label template open, click ā€˜Select Recipients’ and choose the edited .csv
  • Now you edit the document to your liking using the Insert Merge Fields tab - this will fill out sequentially the data from the spread sheet to make labels.
  • Once finished you can select Finish & Merge and choose the printer.
  • there may be some differences because I use thermal labels, but I was able to make nearly identical labels as on quickbooks.

Dim i As Long, j As Long, k As Long, m As Long

With Worksheets(1)

i = InputBox(ā€œEnter the number of the column that contains the quantities.ā€)

For j = .Range(ā€œA1ā€).CurrentRegion.Rows.Count To 2 Step -1

For k = 1 To .Range(ā€œa1ā€).Offset(j - 1, i - 1).Value - 1

.Cells(j, 1).EntireRow.Insert

For m = 1 To .Range(ā€œA1ā€).CurrentRegion.Columns.Count

.Cells(j, m).Value = .Cells(j + k, m).Value

Next m

Next k

Next j

End With

I checked to find the latest login for Shopify Community Manager was 7-25-23. That tells me this discussion is not being monitored.

For any of the Group Admins, can you ask the product team at Shopify if they have any information on a possible solution. As October is nearing, this will be a huge frustration and disappointment for anyone converting from QB POS to Shopify POS. Thank you

Hi everyone! Firstly, I want to assure you that the threads on this board are being actively monitored and we have a range of associates who work in and moderate our community forums.

Thank you for your continued feedback on this. I recognize that the current functionality of the Shopify POS and Stocky app is not suitable for your needs when it comes to managing large POs. At this time, I don’t have any further update as to if/when this feature will be made available.

All your feedback provided here has been shared, and will continue to be shared, with our developers for further consideration. I encourage you to contact our retail support team and quickbook migrations team directly as well, if you haven’t already.

We’ve been using Shopify POS for about two months. I can’t believe the difficulty in getting help for any kind of issues. I’m spending way way too much time entering and receiving items then printing labels each day. I just came to this forum thinking I must be doing something incorrectly that it’s so time consuming. Apparently, we’re all feeling this.