Gestion de stock & commandes / Inventory Management & Order

Ask for Help
1

Bonjour.
Étant nouveau sur glide, j’aurais quelques questions.

Pour un projet personnel (une pme travaillant avec les acteurs de la grande distribution) je voudrais savoir s’il est possible de faire :

Je souhaiterais faire une app gestion des stocks ayant plusieurs composantes :

  • Il faudrait un onglet avec tout les produits incluant également le stock actuel du dépôt, pouvant être “ajouter au panier”
  • Une fois plusieurs produits ajouté,il faudrait pouvoir sélectionner le magasin choisis dans un autre onglet
  • Exemple : Carrefour Toulouse 060000000 Adresse etc
  • Une fois le magasin choisis, il faudrait un bouton “commande” permettant d’envoyer la commande mais également de délivrer le bon de commande (en pdf par exemple).
  • Évidemment, quand la commande est envoyer, les stocks actuels du dépôt devrait être mis à jours.
  • Cela serait-il possible de mettre ça en place avec Glide ?

Merci à tous pour vos réponses par avance.

Edit : English Version

Hello,
Being new to Glide, I have a few questions.

For a personal project (a small business working with large retail players), I would like to know if it’s possible to do the following:

I would like to create an inventory management app with several components:

  • There should be a tab with all the products, including the current stock in the warehouse, with the option to “add to cart.”
  • Once several products are added, it should be possible to select the chosen store from another tab.
    • Example: Carrefour Toulouse 060000000 Address, etc.
  • Once the store is selected, there should be an “order” button to submit the order and also generate a purchase order (in PDF format, for example).
  • Of course, when the order is placed, the current stock in the warehouse should be updated.
  • Would it be possible to set this up with Glide?

Thank you all in advance for your answers.

Sorry for my poor english, it’s not my native language.

2

Yes, those should all be possible.

Create a custom form. On entry to the form, set a unique ID so that later it can be used as the “order ID”.

Have an “order lines” table, record the “order ID” above for each line.

Just add a field in the custom form to store the store ID.

This should write a row to an Orders table, with the key being the “Order ID” you generated earlier. With that setup, you have a parent row in the Orders table, and its children in “Order Lines”.

Then, use PDFMonkey/DocsAutomator, build the required JSON and HTML to generate a PDF.

When a button is clicked, you should be able to both add a row in the Orders table, and trigger a webhook workflow to:

  • Loop through rows in the Order Lines table that contains the specified “Order ID”.
  • Find the related product row in the Products table.
  • Calculate the quantity to deduce (-1 * quantity order).
  • Increment the quantity be the negative amount above.
1 Like
3

Hey.
Thanks a lot for all the information, so that’s should be possible even for a beginner like me .

Now, all that’s left is to work on glide for understand everything.
Gonna be some hard work for now.
Thanks !

2 Likes
4

You can try going through some lessons here.

1 Like
5

I gonna check this, i see some lessons are in french so it’s even better.

Thanks again dude !

1 Like