Bar Code for price over $99.99

[Diane-Maplewood]

The regular UPC bar code does not allow for prices over $99.99. How do I
change this, or what bar code symbology will work for this? I am using
Access 2003 and an ActiveX Control to place the bar code.

 

[Arvin Meyer [MVP]]

There's lots of great Barcode info at:

http://www.adams1.com/pub/russadam/share.html

I'm surprised that UPC doesn't handle prices >= $100. In know that Code 39
does handle numbers over 100.

 

[Tony Toews [MVP]]

The regular UPC bar code does not allow for prices over $99.99. How do I
change this, or what bar code symbology will work for this?

How do stores sell TVs and computers and such priced over $99.99 then?

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Thomas Lutz]

UPC bar codes do not encode the price of an item in the bar code. The
only data encoded in the bar code is the UPC number which consists of
a manufacturer ID number and an item number that is assigned by the
manufacturer. The price of an item is stored in a database somewhere
that is keyed off the UPC number.
The only exception to this is with Bookland bar codes where you can
have a price supplemental consisting of a 5 digit number containing a
"5" followed by a price ranging from 0001 (one cent) to 9999 ($99.99)

The price supplemental is a small additional bar code that appears to
the right of the main UPC symbol.

 

[Diane-Maplewood]

My goal is to bar code invoices to be scanned at the register. Maplewood
processes beef and pork for customers, as well as process venison into
sausage products. We run 100's of invoices a week- all have unique prices
and many over $100. We need to improve accuracy and speed things up.

The invoice and price is generated in Access once we enter the product's
final weights for the customer. If I cannot print a bar code which encodes a
price for over $99.99, then...

I need to encode the invoice number in the bar code
and somehow send the invoice#=price to the POS system?

Can this be done "automatically" in Access when an invoice is "printed"?

This should be a lot easier...
Your help is appreciated.

 

[Tony Toews [MVP]]

My goal is to bar code invoices to be scanned at the register. Maplewood
processes beef and pork for customers, as well as process venison into
sausage products. We run 100's of invoices a week- all have unique prices
and many over $100. We need to improve accuracy and speed things up.

The invoice and price is generated in Access once we enter the product's
final weights for the customer. If I cannot print a bar code which encodes a
price for over $99.99, then...

When I think about it this is what the butcher shop or deli section of
a grocery store does on a routine basis. However as that uses a UPC
code it might have a limit of $99.99.

Now do you folks need to use UPC codes or not? That is does your
till handle standard grocery store or convenience items? Or does your
till handle just your products. Is your till an industry standard
system or is it an Access based app on a PC with a cash drawer?

If just your products and an Access based app on a PC with a cash
drawer then you can do anything you want with the barcode and read
that into the PC.

However if you must use UPC codes then things get considerably
trickier.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Diane-Maplewood]

We are switching over to a new POS system in about a month. I'm not sure if
it is Access, but it is a database application (through NCR). I understand
that it will read any type of bar code- it does not have to be a UPC. I'm
assuming that since the bar code we would like to print on the invoice is
only used by us (in-house), we can assign any number to it (as long as it
does not duplicate other product UPC that we sell in the store).

Then I would just need some way to send the code, and price, to the
'register' POS system so that it can be identified when the bar code is
scanned. ??

What information should I ask our POS System vendor that may help figure
this out?
Thanks again for your assistance.
Diane

 

[Tony Toews [MVP]]

We are switching over to a new POS system in about a month. I'm not sure if
it is Access, but it is a database application (through NCR). I understand
that it will read any type of bar code- it does not have to be a UPC. I'm
assuming that since the bar code we would like to print on the invoice is
only used by us (in-house), we can assign any number to it (as long as it
does not duplicate other product UPC that we sell in the store).

So if you are not selling any other products that require UPC codes
then what you could do is have a long two section bar code. The first
section is your invoice number and the second section being the price.
Thus you could see how many packages didn't get paid for. This
assumes that the NCR POS software can handle this.

However I suspect that given that you are purchasing an NCR POS system
that you do indeed sell other UPC items and that the vendor may not be
willing to customize their system to meet your requirements.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Diane-Maplewood]

I am meeting with the vendor tomorrow, so will find out if there are any
limitations as far as bar code type. Do you have any suggestions on what
other questions I should ask to figure out a way to 'automate' the sending of
information to this POS database (if all bar code types are supported)??
Thank you for your time.