This project should not be too difficult. Currently we copy and paste pictures into a Word document and create shelf labels from it. This of course is kind of tedious. Instead we want to be able to have these labels created by retrieving pictures and product information from the database (SQL).
Our goal is to print on the label
(1) A resized picture of the product
(2) The Product Number.
(3) Whether the product can be restocked.
-all this can be sourced from the database.
We want to be able to print a label by requesting them in two ways.
(1) with the actual product numbers (we need to be able to request more than one label at once)
(2) with the shelf code which is where the products are located in the warehouse
For example shelf code(401-003-008) means section 401, shelf 2, product 8)
-we want to be able to enter a range
401-would print all labels in section 401
401-003 (would print all balloons in section 401 on shelf 3)
A sample of what we want has been included in the attachment.