OpenERP 6.1 POS: lookup by barcode (EAN13 or Reference)

Whats the status on this? May be able to help. Possibly built-in EAN13 and UPC support will be needed for products in 6.1? Also, it would be nice to have a toggleable 'scan by default' preference that allows users to default to an EAN/UPC default input and autoselect modality that can be overriden per-line-item on the fly.

Another thing is scanner/scales, which is really an entirely other monster and will probably need its own ticket!

Obviously I am coming from a very grocery/retail perspective on this, with a United States bias.

As far as I can tell, this is a very hot issue that is high on the radar for OpenERP. If 6.1 can round-off this already strong OOTB POS functionality, adoption rates will skyrocket. Many retail market SMEs in the US are awaiting a more rock-solid open source & integrated POS solution... and internationally this is in very high demand as well. Let's make this happen!

Implementation in search method from POS interface must checked, but IMO if proxy layer implements search method there is no reason to it does not works.

Hello Ahmad Khayyat,

Thanks for your Contribution : Rerooting and Cristian Salamea

For now It needed lot of changes regarding your suggestion what you suggested in bug specification.
currently I can consider this issue as opinion because this issue needs more clarification and discusstion.

You can post this issue on feedback.openerp.com also, Our quality team members will definatly review this.

@Experts: Would you please provide us your precious inputs regarding this.

Thanks.

@Vishal,
please Add some value in ref product field.
Try to search this value in product search field in POS interface.

There is no results.

Regards,

IMHo

This lack of feature is always present not just in POS.

IMHO the "search" function for product must:

Search by EAN >> not found?
Search by REF >> not found?
Search by NAme .....

Even IMHO we need an extra field "UPC" EAN is common used in Europe but America use UPC. with UPC we need:

Search by EAN >> not found?
Search by UPC >> not found?
Search by REF >> not found?
Search by NAme .....

In almost all enviroments with normalized products it will improve a lot the speed of search.

Regards.

Hello Cristian Salamea,

Are you taking about touch screen pos ?

I have checked in pos backend and by using Advanced Filter I am able to fine Reference as well as EAN number. Would you please give video where you faced the problem?

Any thing missing ?

Thanks and waiting for your reply.

Vishal Parmar,

Thank you for reviewing this report.

I attached a screenshot showing my attempt to search a product by its EAN13 or its Reference fields. The value shown in the search box is both the Reference and the EAN13 for one product, for demonstration purposes. As you can see in the screenshot, there are no matches. This means that neither the Reference field nor the EAN13 field are searched.

This is what I was reporting in my original report above. Is this considered an opinion, or is it something else suggested by other contributors to this bug report?

I appreciate everyone's input, but if the issue described here, without any other improvements, can be fixed easily and soon, then we can move other improvements and suggestions into their own bug reports. I think that searching products by Reference and EAN13 in the touch-screen POS is essential for the POS to be usable. Otherwise, it would take the cashier a long time to enter products into the POS.

Hello Ahmad Khayyat,

I agree with you. It should be search by using product reference and EAN13.

Thanks.

hi,

It shuld be search by using EAN13.

Hello,

Please do not forget to support UPC's also, for those of us across the pond. As it is I cannot even create a database of products as it (OpenERP) checks for EAN13 barcodes and does not accept UPC codes. Although I appreciate a need to check EAN13 codes an option to disable this will allow us in North America to use this excellent software.

PS do not know why the inability to scan items into POS gets only a low priority.

Thank You

I agree that this needs to be set to a higher priority. We have over 2000 products to search through all of these using the POS touch interface is less than convenient. Especially when a quick pull of the trigger would automatically select the correct product and eliminate the human error potential.

Moreover, as has been stated that this is such basic functionality that the product can not be seen as a complete solution until it is implemented.

Please reconsider its priority and fix this as soon as possible.

I think this bug should have important priority to be fixed. POS without barcode reader support is odd, and I thing it is not too difficult to fix the bug. CMIIW.

I would think that the ability to lookup by EAN and UPC would be a requirement before you could call it a POS system/module.

With this commit you can make it get the product by entering the EAN13 code in the "Search" field (probably using your barcode reader):
http://bazaar.launchpad.net/~guerrerocarlos/openobject-addons/point_of_sale_6.1_barcode/revision/6699

I'm working right now in:
* Make it also work with the "Reference" of the products
* Automatically "addToOrder"

[FIX] point_of_sale: search product by "Reference" field:
http://bazaar.launchpad.net/~guerrerocarlos/openobject-addons/point_of_sale_6.1_barcode/revision/6700

Hi Carlos.

The change is great!

Can you make the merge proposal for trunk please?.

I saw the change i dont know why it not already working Out of the box on
stable.

Regards,

GOOD job folk!

2012/3/23 Carlos Guerrero <email address hidden>

> With this commit you can make it get the product by entering the EAN13
> code in the "Search" field (probably using your barcode reader):
>
> http://bazaar.launchpad.net/~guerrerocarlos/openobject-addons/point_of_sale_6.1_barcode/revision/6699
>
> I'm working right now in:
> * Make it also work with the "Reference" of the products
> * Automatically "addToOrder"
>
> --
> You received this bug notification because you are subscribed to OpenERP
> Project Group.
> https://bugs.launchpad.net/bugs/949664
>
> Title:
> OpenERP 6.1 POS: lookup by barcode (EAN13 or Reference)
>
> Status in OpenERP Addons (modules):
> Confirmed
>
> Bug description:
> Products can be looked up in the Point of Sale interface only using their
> names.
> Lookup by barcode is essential for a point of sale system.
> Neither of the product fields that can be used to store barcodes (EAN13,
> Reference) can be searched in the Point of Sale interface. This makes the
> Point of Sale system very hard to use efficiently.
>
> To manage notifications about this bug go to:
> https://bugs.launchpad.net/openobject-addons/+bug/949664/+subscriptions
>

--
--------------------
Saludos Cordiales

Nhomar G. Hernandez M.
+58-414-4110269
Skype: nhomar00
Web-Blog: http://geronimo.com.ve
Servicios IT: http://vauxoo.com
Linux-Counter: 467724
Correos:
<email address hidden>
<email address hidden>
twitter @nhomar

Thanks Carlos..
That is great news!

Now, when can we expect these changes to make it to the main repo?
And, when can we expect it to be available in OpenERP Online?

Merge Proposal:
https://code.launchpad.net/~guerrerocarlos/openobject-addons/point_of_sale_6.1_barcode__merge/+merge/99129

Carlos, does this code return if a 'code' is defined, regardless of whether it matches or not, without checking 'EAN13' or 'name'?

Example:

A product with code = '1111', no EAN13, and name = 'product 1', and search query = 'product'.
Expected behovior: match on name.
What will your code do after the mismatch on the 'code' field?

You are right, I fixed it so now it has the expected result, it is at:
https://code.launchpad.net/~guerrerocarlos/openobject-addons/point_of_sale_6.1_barcode__merge

Its ok Carlos. Thank you.

But there are some problems. Yes now, I can search product with EAN13, but it's important that search and select product with barcode reader.

If the product is found, the product selection must be automatic. It's so slow that click the product on the search page. it's important that search and select product with only barcode reader. Should not need to click with the mouse.

Hi

  I added code that automatically adds a product when receiving an <enter> on the search field when the search returns one result.

  That should make possible adding items to the cart using only the barcode reader.

Arturo.

Great! I checked the pos.js files and it had a lot of changes, I took only the part that makes the <Enter> to add the producto to the Order and commited it to:
https://code.launchpad.net/~guerrerocarlos/openobject-addons/point_of_sale_6.1_barcode__merge

So the POS is now able to:
* Search by product Name
* Search by EAN13
* Search by Reference
* Automatically adds the product to the order when using a bar code reader.

Arturo, I recommend you to commit the other changes in the code using bzr so that they can also be merged into the code, including all the changes you may have done to other files, so that it all works together.

Thanks for committing the changes, Carlos.

I actually tried to do it myself but somehow ended up attaching the .js file instead. I'll read the instructions more carefully next time.

Arturo.

Thanks Carlos.

Now, searching and adding product with barcode reader is ok

If anyone is implementing the point of sale in a real store with led Display, this might be usefull to solve the -javascript to COM port- communication:

https://launchpad.net/openerp-leddisplay

How-to:
https://github.com/guerrerocarlos/OpenERP-ledDisplay

I'm fairly new to OpenERP and would really like to get the Barcode functionality to work as described. Can somebody advise me what i need to do exactly. So far i have attempted to simply switch out the pos.js file with the latest one available here. This caused errors when trying to access POS. Please excuse my naivety in this area. Some step by step instructions would be great :)

Hi,

Thanks to Carlos. I've integrated his module by replacing the point_of_sale addon of my OpenERP 6.1 installation with his version.

I think that this functionnality will be integrated with OpenERP v.7.0 :
http://www.openerp.com/node/1269#h.suxrdd9z3i6r : it says "Using either hierarchical product categories, instant search or a bar code scanner gets you quickly to the product at hand."

Cheers,
Kod

Hello ,

           It has been fixed in the following branch : https://code.launchpad.net/~openerp-dev/openobject-addons/trunk-opw-575341-port-sgo

          Revno : 8186
          Revid : <email address hidden>

Thanks

Hello, Everyone, Do you now if this feature is implemented in OpenERP7 too?

PoS on 6.1 is not working fine for me:

* sometimes barcode scanner beeps but no product is added on PoS and it doesn't warns about not found product
* sometimes it can't find a product and shows a lot of warnings

With attached patch it works much better (for me), basically it fixes the number filter applied to received input and adds a warning if the barcode readed has less than 13 characters which happens to me sometimes, maybe caused by high interval between numbers on barcode scanner, I also raised that interval to 100ms.

I have to second the big need to implement search/validation for UPC codes and not only EAN13. In South America UPC is also widely used and we are struggling with POS implementations. We'd be grateful with any developer that can shed some light on this. Should we open a specific ticket for this?

Do anybody facing issue regarding manual retriving with search field ? Searching works ok, but once I want to do new try and click to "erease button" I got attached error. Do anybody have the same issue ?