Updating CRM using Barcode Scanner RRS feed

  • Question

  • Hello,

    I would like to incorporate a Barc Code Scanner with CRM to scan products coming in or going out to either either checked in or checked out. The scanner would scan two codes, the [product code and its Box number] and update the product status as either (checked in or checked out).

    similar example


    Scanning items is easy as the Barcode scanner acts a key board.

    My solution is to have an excel import file with columns for BoxNumber and ProductCode, the two codes would be scanned to each columns and save the import file to a root location for it to be picked up by an SSIS package and then update CRM to change the status as either checked in or checked out. However this idea seems backward, any ideas please !!!

    i guess a web service would be needed since it not recommended to update the CRM database directly

    Many thanks for the help !

    Every day i learn something new.

    Sunday, October 12, 2014 4:58 PM