Jump to content

Managing Database

Recommended Posts

We have a question regarding the uploading and organising of information for our 'business directory' on our website.
We have a spreadsheet with all the details (name, type, address, number, opening hours etc) for businesses in our area and would like to use this to create a local 'Traders Directory' for users to search on our website. The Traders will be organised into :
  1. Type (Categories) - eg. Baker, Bank, Dry Cleaner etc
  2. Description (Tags) -  eg. Open Late, Delivery, Vegetarian etc
Also - by 'Good Trader' - ie. those businesses that we would recommend and 'All Traders' which would be a general directory for everyone else.
We are not sure how best to organise this information on the back-end of the website.  Currently we have used Blog posts for each individual business (see example below) , but are finding it difficult to manage this information (there will be close to 300 individual businesses).
 
For the users, the Categories and Tags will make it easier to navigate and search the different businesses, but for us, organising this via the Content Management System is laborious and difficult to organise.  Ideally, we'd like to upload our existing Excel database to Square Space, but understand that's not possible? 
 
If we have no option but to create individual business /traders as stand alone blog posts on the Blog Management Page, these will just appear all together and will be difficult for us to organise  (ie. no folders etc).  Currently there are only 4 posts, but when there are 300+ businesses it will be much harder to manage and update.
 
What would you suggest?!
Thanks
 

index.png

Link to comment
  • Replies 0
  • Views 319
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Posted Images

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.