Jump to content

Need Inventory Tracking Help - All Day Counts

Recommended Posts

Site URL: https://www.85thdayllc.com

Desperately need a more intuitive inventory tracking system. The export by product or export all products option is a huge mess of a spreadsheet. Need a way to export an "all day count" of how many units of a specific product has sold in a given date range. For example, we have a bakery and need a way to tell our baker how many loaves of sourdough he sold that day so that he can plan for his next bake. But, ideally that would apply to all 128 items in our online grocery market so we get an "all day" count of what has been sold each day, rather than an exhausting list organized by order, where we have to go in and tally up sales manually. THERE HAS TO BE A SMARTER WAY. Please let us know if you have any suggestions for ways to track this!

Link to comment
  • Replies 3
  • Views 455
  • Created
  • Last Reply

I think we may need to do the filtering based on the downloaded spreadsheet with macro/script, or else we have to parse the order confimation email into google spreadsheet and extract data there

BeyondSpace - Squarespace Website Developer

🖼️ Lightbox Studio (Enable Pinch/Zoom on lightbox)
🗓️ Delivery Date Picker (Squarespace Date picker form field)
💫 Gallery block 7.1 workaround
🥳 Sparkplugin Customisations Browsers (Browse +100 Spark plugin customisations)
🥳 Elfsight Template Browsers (Browse +1000 Elfsight widget Templates)

If you find my answer useful, let's leave a like or upvote so others with the same issue can find their solution. Thank you!

 

Link to comment
  • 2 months later...
On 12/15/2020 at 8:30 PM, Bct said:

This would be extremely useful. We have the same issue. Hopefully someone with more experience can chime in. 

I think you should take advantage of Commerse API to tweak how the data is returned

BeyondSpace - Squarespace Website Developer

🖼️ Lightbox Studio (Enable Pinch/Zoom on lightbox)
🗓️ Delivery Date Picker (Squarespace Date picker form field)
💫 Gallery block 7.1 workaround
🥳 Sparkplugin Customisations Browsers (Browse +100 Spark plugin customisations)
🥳 Elfsight Template Browsers (Browse +1000 Elfsight widget Templates)

If you find my answer useful, let's leave a like or upvote so others with the same issue can find their solution. Thank you!

 

Link to comment

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Squarespace Webinars

Free online sessions where you’ll learn the basics and refine your Squarespace skills.

Hire a Designer

Stand out online with the help of an experienced designer or developer.