Renue Receiving Form - User Guide
What is this?
A phone-friendly form for the Florida warehouse team to log incoming deliveries and attach lab certificates (COAs) to products. No login required - open it on any phone or tablet.
Overview
The form has two tabs at the top:
- Product Receiving - log a delivery when stock arrives (date, product, batch info, units, condition, who received it, photo).
- COA Uploads - attach a lab certificate (potency, heavy metals, microbials, or aggregated PDF) to a product and batch that was already received.
Every submission is saved to a shared Google Sheet and an email alert goes out to the team automatically. You do not need to notify anyone separately.
Logging a Receiving Record
Use this tab every time a delivery arrives at the warehouse.
1
Open the Product Receiving tab (it's selected by default).
3
Type the Product Name. Matching products appear as you type - pick one from the list if you see it.
4
Check New Label? if this delivery uses new label artwork you haven't seen before.
5
Enter the Batch Number from the product packaging.
6
Pick the Batch Date (Month/Year) and choose whether it's an MFG (manufacture) or EXP (expiration) date.
7
Enter Units Received and any Inspection notes (condition of the boxes, damage, etc).
8
Enter your name in Received By.
9
Add any extra Notes, and optionally attach a photo of the product with Image of Product.
10
Tap Submit Receiving Record. Wait for the confirmation message before leaving the page.
Fields marked with * are required. If a required field is missing, the form will tell you which one before it lets you submit.
Uploading COAs
Use this tab once lab results (Certificates of Analysis) come back for a batch that has already been logged in the Test Results sheet.
1
Open the COA Uploads tab.
2
Type the Product Name exactly as it appears in the Test Results sheet.
3
Enter the Batch Number exactly as it appears in the Test Results sheet.
4
Attach whichever documents you have: Potency, Heavy Metals, Microbials, and/or Aggregated (PDF, JPG, or PNG). You don't need all four at once - upload what you have and come back later for the rest.
5
Tap Upload COA Documents.
"No matching record found"?
The COA tab attaches files to an EXISTING row in the Test Results sheet - it matches on Product Name and Batch Number exactly. If that row doesn't exist yet (the batch was never logged in Test Results, or the product name/batch number is typed slightly differently than the sheet), the upload will fail with this error. Fix: double check the Product Name and Batch Number match the Test Results sheet exactly (including spelling and spacing), or ask Sander to add the row first.
Email Alerts
Every submission - a receiving record or a COA upload - triggers an automatic email to the RBS team (warehouse, ops, and management). You don't need to send a follow-up email; the alert IS the notification.
- Receiving Record alerts show the product, batch info, units received, inspection notes, and the product photo if one was attached.
- COA Upload alerts show which documents were uploaded (Potency / Heavy Metals / Microbials / Aggregated) and link to each one, with a note for any still missing.
Troubleshooting
Submission failed / error message on submit
Check your internet connection and try again. If it keeps failing, take a screenshot of the error and send it to Sander - do not re-enter the same data over and over, as it may have already saved.
Image didn't attach / upload seems stuck
Large photos can take a little longer over warehouse wifi. Wait a few seconds after tapping submit before retrying. If the photo still won't attach, you can submit the record without it and send the photo to Sander separately.
"No matching record found" on a COA upload
See the Uploading COAs section above - this means the batch hasn't been added to the Test Results sheet yet.
Product name doesn't appear in the suggestions
You can still type the full name manually - the suggestion list is just a shortcut for known products. Type the product name as it's known in the sheets.
Sander maintains this form. If something looks broken, an upload keeps failing, or you're not sure what to enter, contact Sander directly rather than working around the problem.