I am in need for some food for thought. I am working on a form for Inventory Movement.
EXAMPLE: Lets say I remove 5 of product "A" from shelf "X1" and then place 3 of product "A" on shelf "W3" and the other 2 on shelf "Z9"
What would be involved in this form?
What would be the best layout to use a barcode scanner for all input.
EXAMPLE: Use the barcode scanner to Scan Shelf "X1" then Scan Product "A" 3 times (Or input 3 manually) and then Scan Shelf "W3" and so on. So the database knows after the second SHELF SCAN it is to move on to the next product?
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database.
Split up all multi-value fields into single values:
Split up fields that belong to other things into separate tables:
Make sure that all record…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes.
Assigning simple products to configurable: We assigned simple products…