Related
Recommended
Engagement
  • Author Author: kellyhensen
  • Date Created: Date Created
  • Last Updated Last Updated:
  • Views 13860 views
  • Likes 10 likes
  • Comments 8 comments

Open Source Inventory Warehousing System -- Episode 534

MAYER MAKES Engineering Resin (https://mayermakes.at/engineering-resin/)3D basics Color Ampule Black

 

For a lot of makers, selling their creations is a big goal.
Unsatisfied with the current options to sell DIY products Clem started building his own website. When many orders trickle in, it's easy to confuse items when packing. So Clem uses the REST API of his website a Raspberry pi 3A+ and a Barcode Scanner to build a warehousing system that helps you pack Orders and ship them out ASAP!

 

Supplemental Content:

Bill of Material:

Product Name Manufacturer Quantity
"MULTICOMP PRO Industrial Pushbutton Switch Multicomp pro 1 Buy Now
"PRO SIGNAL HDMI to VGA Adaptor Lead" Pro signal 1 Buy Now
"OPTICON Black USB Barcode CCD Scanner" Opticon 1 Buy Now
Raspberry PI 3A+  1 No longer stocked - see alternative below
Alternative:
"DFROBOT Single Board Computer Lattepanda Dfrobot 1 Buy Now
"ALCOSWITCH - TE CONNECTIVITY Industrial Pushbutton Switch Alcoswitch 1 Buy Now

Additional Parts:

Old PC monitor
Vga cable
PMMA for lasercutting or other material for mounting the SBC
MAYER MAKES Engineering Resin 
Actions
Parents

  • clem, I personally don't like your warehouse system, mine took me about 6 months of programming in Perl, a C-like language suited for strings, and I don't like python. I personally think you missed the boat. everything in a bar-code.LOL, my large online DB is punished published with MySQL.  www.phoenixtrading.biz currently, I have over 1/4 million records, I, in fact, you have two parts the Info table which has all the stuff about the product. and a link to the manufactures table. Second or third you need your history table, invoice table, and quotes which turn into invoices. If you go further you need a purchasing table. 

    how do you add a part?? Description, etc with a barcode?

    I use Apache as the user interface. 

  • in reply to phoenixcomm

    So where do I start:
    the preface Airplane

    this project is only showcasing 1 simple API call and making use of the Json response.
    Its only getting the orders that are ready for shipping and helps packing these orders one by one by matching barcodes.
    So the whole station has only one purpose: packing orders. nothing else.
    Focus on one specific task is the intended approach to avoid packing errors.

    The backend is a Webserver running Woocommerce and dokan with a few plugins and customizations (mainly for compliancy with GPDR/Commerce laws)
    so a lot of databases with MySQL behind it.
    So all the databases and connections you mentioned are there and mostly operational (I have recently nuked the build to rebuild it without legacy residue)

    How do you add a part:
    Simple you can use the full extend of the Dokan API and Woocommerce Rest API or just enter it on the Website if you don't want to do it automated.
    Also some settings are not accessible via API because pushing them in  would break compatibility with security updates pushed by maintainers of the main repos.
    here is some documentation: https://wedevsofficial.github.io/dokan/

    In there are code variants for php, JS, python, bash, and ruby.

    the User interface can therefore be whatever code you want to write or just the website.
    Which of course you can use with Keyboard and mouse.

    the barcode reader is only there for the packing station as shown in the video.

Comment
  • in reply to phoenixcomm

    So where do I start:
    the preface Airplane

    this project is only showcasing 1 simple API call and making use of the Json response.
    Its only getting the orders that are ready for shipping and helps packing these orders one by one by matching barcodes.
    So the whole station has only one purpose: packing orders. nothing else.
    Focus on one specific task is the intended approach to avoid packing errors.

    The backend is a Webserver running Woocommerce and dokan with a few plugins and customizations (mainly for compliancy with GPDR/Commerce laws)
    so a lot of databases with MySQL behind it.
    So all the databases and connections you mentioned are there and mostly operational (I have recently nuked the build to rebuild it without legacy residue)

    How do you add a part:
    Simple you can use the full extend of the Dokan API and Woocommerce Rest API or just enter it on the Website if you don't want to do it automated.
    Also some settings are not accessible via API because pushing them in  would break compatibility with security updates pushed by maintainers of the main repos.
    here is some documentation: https://wedevsofficial.github.io/dokan/

    In there are code variants for php, JS, python, bash, and ruby.

    the User interface can therefore be whatever code you want to write or just the website.
    Which of course you can use with Keyboard and mouse.

    the barcode reader is only there for the packing station as shown in the video.

Children
No Data