So the template should have an āunlimited stockā feature to fix this. If not then I need to resubmit the template.
I also just reviewed your email. I can either send you a copy with the unlimited stock feature or can show you how to implement it.
Iām happy with either.
Let me know whatās easiest for you to do.
I just emailed you the instructions!
Iām also copying here for anyone curious or that purchased the template that wants to implement the same feature.
Note: You will need to add the āunlimited stockā booleans to the app interface if you want to be able to edit product and inventory stock using the app and not just Google Sheets.
Let me know if this works for you!
1. On the āproductsā sheet, add a new boolean field to toggle if the product should have unlimited stock.
2. Then, update the āsold outā tag field to the screenshot below:
NEXT you will need to pull in a lookup for the product so that the new feature can be recognized in the cart, otherwise, even when users add items, they app will keep them from moving forward to purchase because the condition must be setup to recognize that the product selected doesnāt have inventory tracked.
3. On the āinventoryā tab, create two new columns, one to toggle infinite stock for the inventory, and another a lookup column to pull in the value to see if the related product for the inventory is marked as āinfinitestockā.
4. Create a new IFTHEN column with the same setup as the screenshot below.
5. On the ācartā tab, change the āinventoryLOOKUPā to pull from the new āinventoryAvailableIFTHENā column. Screenshot below.
it would be much easier if you do stock recognitionā¦ if left empty, that means is unlimitedā¦ so users donāt need to think about it
Nice add. If users want to implement that method then that also works.
The original template was designed for tracked inventory, so the update was implemented in the method above for that purpose.
Has anyone managed to successfully write successful checkouts back onto the sheet?
I would like to see all orders quickly so I know total quantities for each product?
The most updated version for GlideCart has Stripe, which writes back the order as paid on the orders sheet. Is that what youāre looking for?
What I am looking for.
Once an orde has been made the name , item and quantity ordered is then sent back the Google sheet.
Ideally I would use a pivot table to see how much of each item I had to prepare or organise
With Stripe payment, the order is already recorded when itās purchased. The items are recorded to a āhiddenā sheet labeled āApp:Salesā.
In the Glidecart template, the template is already configured to crosscheck that the order submitted was actually paid for if the payment method is Stripe. So, you already have access to view and manage all of the orders on the āMy Ordersā tab when you are viewing as an Admin.
This is for all orders, including if they were paid with Stripe or not.
Thank you.
Will check it out.
Can you explain how to do this, please?
Will this work with Stripe Connect?
Does Glidecart work with Stripe Connect, like with a marketplace style setup?
yes, it will work with all kinds of payments using Stripeā¦ just set up the event you need in webhook settings
I recently downloaded this template, however I cannot get Stripe to work. the Pay via Stripe button is not visible, how do I connect Stripe? Thank you!
Are you on a free plan? The Buy button is only available on paid plans.
I have a business paid plan
Have you gone through and configured the Buy button, so itās linked to your stripe account?
yes, the condition for the purchase button is set to be visible when stripeREL is not empty. stripeREL is empty everywhere in my table
Ok, Iām not familiar with the template. How is the relation column set up? Relations take a value in one table and look for a matching value in another table. If the relation is empty, that means it didnāt find any matches. I would need to see more, with how thatās configured and what the data looks like to give you a definite answer. Iām sure @Lisa will chime in eventually since itās her template, but until then I would need more information to help.
