variant and invariant and creating order

[Omrico]

Hello, and thank you so much for reading my post. I have a table of products, variants, inventory, and orders. The reason of the separation of the variant table is because each product has unique variants names (some of the products are single products without variants)

im trying to create a form to add a new order and facing a problem when its comes to add a new a specific product/variant.

should I select product and then variant and then quantity? Is there a way to make it easier ? Kind of “invoice line” when you select product, quantity? 
please advise 

thank you so much 🙏🏻

[TheTimeSavingCo]

I'd recommend setting it up so that all orders select from the Variant table, and so even for the products without variants you'd create a Variant record for it so that it could be selected.  The idea is that the Variant table becomes more of like a 'Sellable items' table

Creating multiple line items for an order will be an issue though, and if that's something you want to do you'd end up with an 'Orders' table and a 'Line Items' table.  You'd need to use another form software like Fillout (https://www.fillout.com/) as Airtable forms don't let you create multiple linked records via one form submission

[Omrico]

Thank you so much for your replay 🙏🏻🙏🏻

I only need one product per order, in case will need more then one, will submit 2 separate orders, 

my question is which way we pick the product in the order ? Is that only product or product, variant, quantity? 
which way is the best to track inventory, purchase order from supplier and while they workflow?

thank you so much 

[TheTimeSavingCo]

my question is which way we pick the product in the order ? Is that only product or product, variant, quantity?

Yeap I'd recommend picking only from the Variant table

---

which way is the best to track inventory, purchase order from supplier and while they workflow?

I'd suggest creating a 'Movement' type table where each record represents either incoming or outgoing stock.  Each of these records would be linked to a single Variant record and you'd create a rollup field to sum and get the current stock values.  And so a fulfilled Purchase Order would show up as an incoming 'Movement' record, does that make sense?

[Omrico]

hi, thanks 

without selecting quantity? Then how can we track the inventory in that way?

[TheTimeSavingCo]

You'd definitely need a quantity field anywhere you wanted to track the stock.  So the 'Movement' table would need it as well as the 'Order' table!

[ScottWorld]

@Omrico 

Note that, as previously mentioned above, none of this can be done with Airtable’s forms, so you would need to turn to Fillout’s advanced forms for Airtable.

Fillout is 100% free and offers hundreds of features that Airtable’s native forms don’t offer, including the ability to update Airtable records from a form, display Airtable lookup fields & Airtable rollup fields & Airtable attachments & formulas on forms, dynamically & conditionally filter linked record fields by any values that you would like, perform math or other live calculations on your forms, accept payments on forms, create multi-page forms with conditional paths, create new linked records on a form, display as many fields as you want to see in a linked record selection list (including attachments), and more.

Hope this helps! If you’d like to hire an expert Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld 

[TheTimeSavingCo]

@ScottWorldHm, everything Omrico needs to do can be achieved by native forms as far as I can tell, why do they need to use Fillout?

[Omrico]

Are you guys amazing and so helpful!

You guys think it’s a good to start with the AI Tool as a first step to make it ?