Basic Packing List using Barcode Scanner within Excel

  • Estado: Closed
  • Premio: $200
  • Propuestas recibidas: 5
  • Ganador: bizwizz

Resumen del concurso

My online shopping cart is capable of exporting invoices in Excel for orders placed through our store. We want to be able to use the Excel invoice so that the item list for each order, can be verified using a barcode scanner, as it scans the actual product that is being placed in the box.

The SKU# that is in the exported invoice is always under column "D" , starting at row 2 and continuing down depending on how many items the customer ordered. The different invoices are indicated by the different invoice numbers in column "A".

My company is having difficulty with shipping complete orders, constantly missing items, and I believe that if we can create a system - that as each item is scanned and put in the shipping box, it will be "crossed off" the invoice as filled item. If there is a number mismatch, the program needs to create a beep or other notification indicating that there is not a correct item. If there are items that are not yet picked and filled, they need to be indicated differently as well (such as a different colored cells).

I have a quality Wasp Barcode gun and barcode creation software. The Barcode gun acts as a normal input device, such as a keyboard. If I highlight a Excel Cell and scan a barcode, the barcode number/text instantly appears within that cell.

I think my request is as simple as a few equations in excel indicating that the barcode number scanned is identical to the item SKU number from the invoice.

Here is what I would like the process for my employees to be, perhaps this will clarify what I am asking.

Employee downloads the invoices that need to be picked, packed and shipped.
Employee opens an excel document that has been created by you, where it imports the pertinent data from the downloaded invoices.
Employee walks over to the merchandise, scans the merchandise, and the software chances the line item of the item that is scanned from "red" to "green", indicating he selected the correct merchandise. If the wrong merchandise is scanned, the line changes to the color "orange" (an audible indicator is preferred in addition to the color change, but not critical).
Employee walks over to the merchandise, and repeats the process for all remaining items.
Once all items under the same invoice number are correctly identified and packed, that invoice (group of items) changes to "blue", indicating a 100% correctly pulled and packed order.

I have attached a sample document of the Excel invoice document we use, for your reference. The document name will always be the SAME/CONSISTENT, as will the tabs, and labels within the document - which should make for easy use as an OBDC data source for auto-importing. Note: Item # on second tab is the SKU# (these will be changed by me to all-numerical text)

I am quite flexible on how this "program" is made, it does not need to be developed within Excel, but it does require the use of the Excel data source. Please contact me for clarifications, suggestions, optional improvements. I will reward great ideas and additional options/features to simplify what I am trying to accomplish.

Habilidades recomendadas

Comentarios del empleador

“Bizwizz is amazing! He made improvements beyond the original design and he did not hesitate. Very creative! He had daily communication. When I need work done again, I\'m going straight to Bizwizz! ”

Imagen del perfil Technosteve, United States.

Tablero de aclaración pública

Aún sin mensajes.

Cómo comenzar con los concursos

  • Publica tu concurso

    Publica tu concurso Fácil y rápido

  • Recibe montones de propuestas

    Consigue toneladas de propuestas De todo el mundo

  • Elige la mejor propuesta

    Elige la mejor propuesta ¡Descarga fácilmente los archivos!

Publica un concurso ahora o únete a nosotros hoy