Jump to content

Ordering when out of stock , code or ideas ?

Recommended Posts

Hello, looking for some help on order/inventory management.

We take orders on items we both have in stock and don't. From what I can tell squarespace does not support keeping an inventory in Squarespace yet still taking orders, which is fine, so I have everything set to unlimited inventory.

What I would love to be able to do is take the export from squarespace and import it into something, like perhaps Access, then be able to enter my actual inventory then determine what product I need to order. Presently I am doing this with a Pivot table and a bunch of "getpivotdata" formulas which gets messy, especially when new items come up. Anyone out there have anything that may work for my needs, or do I basically need to try and learn Access to see if I can get what I need.

Link to comment
  • Replies 6
  • Created
  • Last Reply

Top Posters In This Topic

How extensive is your inventory? ie how many products, and how many variants?

Edited by paul2009

Improve your online store with our extensions.
About: Squarespace Circle Leader since 2017. I value honesty, transparency, appreciation and great design ♥.
Work: Squarespace Developer and founder of SF Digital, building the features Squarespace didn't include™.
Content: Links in my posts may refer to SF Digital products or may be affiliate links.

Buy me a coffee

Link to comment

There's not an ideal solution for this scenario and without seeing the site it's difficult to offer specific advice. Here are a couple of ideas.

Rather than unlimited inventory, you may want to consider setting your stock levels to their actual level, plus an arbitrary figure such as 1000. For example, if you have 78 of a particular variant, set the stock level to 1078. When a stock level falls below 1000, you'll know that you cannot meet demand. Importing stock levels into a spreadsheet and subtracting 1000 from each figure, will then instantly show you the negative stock levels and help you replenish stock.

Another option is to set stock levels correctly to prevent backorders. When stock reaches zero, provide the customer with a simple form that emails or texts them when the item is back in stock, encouraging them to order.

Improve your online store with our extensions.
About: Squarespace Circle Leader since 2017. I value honesty, transparency, appreciation and great design ♥.
Work: Squarespace Developer and founder of SF Digital, building the features Squarespace didn't include™.
Content: Links in my posts may refer to SF Digital products or may be affiliate links.

Buy me a coffee

Link to comment
  • 2 years later...
  • 2 weeks later...

Create an account or sign in to comment

You need to be a member in order to leave a comment

×
×
  • 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.