Struggling with the concept and implementation of how to progress with my system. I have searched for a long time and although Bubble excels at various things it is also a bit behind in others.
Anyhow due to Covid i am needing to move away from excel based systems and make them into online apps. I am not a developer so with limited experience i have managed to get a few things done, but can’t fathom this one out.
So we have a lot of hardware products to sell - say 2000+, These products are put into categories, so for example we have Bricks and blocks, Decorating etc.
Our end user doesn’t have the time to go through each line to make an order, so we list each category and the user ticks if they want that category. (There is a further lot of questions per category to whittle things down more but for this stage lets say they select Decorating only)
So user has selected decorating, this returns all the products in that area, lets say 10 items.
The user then can change/input the qty they require per product
I then need to store these items as an order (Allocations), so we can run pick lists and get the order out.
How do i manage to get this done? What is the most efficient way?
My base logic here is:
User selects category > Retrieve products from category(list) > make changes to list of products > Save changes (Either in the products table or in a separate table).
I am going round in circles, tried looking at backend workflows to move data from Products table to a order table, tried looking at exporting a csv to make changes and then re upload csv (Can’t be done due to bubble limits).
Any input would be really appreciated, this sort of workflow is key to our system.