Batch Print - Separate Data Source when Printing

Issues related to label design (working with databases, data processing, RFID encoding etc.) and printing (from NiceLabel Express, NiceLabel Pro, NiceForm and NicePrint)

Moderators: Georges, milos, NiceLabel Support Team

Post Reply
bdahlgren
Newcomer
Posts: 1
Joined: Mon Apr 27, 2020 11:03 pm

Batch Print - Separate Data Source when Printing

Post by bdahlgren » Mon Apr 27, 2020 11:23 pm

I have a excel spreadsheet data source that provides a sku, quantity and name. Each sku is unique with a unique quantity value. The quantity dictates how many labels get printed of each sku. One sheet of labels contains 5 individual labels. I am having trouble getting it to print and cut correctly.

For example: I have sku S1000 and I want to print 3 labels (which means that the sheet of labels should have 2 labels that remain empty) then it should cut after that set of 5. Then the printer moves onto the second sku, S1500 with quantity of 7 and it prints 5 labels then 3 labels and then cuts. I want it to be able to cut after each sku and if the sku has over 5 labels to print in batches of 5.

Example
Sku: S1000, qty 3
Sku: S1500, qty 7

I can attach pictures if needed.

User avatar
Mytch
NiceLabel Support
NiceLabel Support
Posts: 138
Joined: Fri Jul 13, 2018 10:26 pm
Location: Milwaukee, Wisconsin
Contact:

Re: Batch Print - Separate Data Source when Printing

Post by Mytch » Tue Apr 28, 2020 11:43 pm

bdahlgren,

This should be done via Document Properties and define your Batch Printing definition or simply Cutter definition:
2020-04-28_16h39_51.png
2020-04-28_16h39_51.png (24.82 KiB) Viewed 414 times
2020-04-28_16h40_03.png
2020-04-28_16h40_03.png (19.59 KiB) Viewed 414 times
Both should accomplish the same task. Batch Printing can be used for other functionality, whereas the Cutter configuration is just for defining when the cutter operates. When your data source changes (SKU), the cutter can be engaged. I don't exactly understand the other requirement "I want it to be able to cut after each sku and if the sku has over 5 labels to print in batches of 5", but maybe this also accomplishes your goal.

Regards,
Mytch

Post Reply