How to make Multiple prices change in one go

Ask the community
,
1

Hi, I have a Tourism website we set up tours around Africa and have various accommodation advertised on our site.

For each accommodation/tour we have a price listed in its own text box. We have over 100 different prices on the website. These change periodically and are currently very labour intensive to amend.

My question: is there a way to set up a database or spreadsheet so that we can populate the different prices so the various text boxes get automatically update on the website?

1 Like
2

Hi,
I’m not sure I understand your question, are you trying to update the database with a csv? Are you using wix stores?

3

Hi Or thanks for your response

Maybe if you have a look at the site it might help https://www.buptours.co.za/botswana-lodge-safaris this is a good page to show you what I mean as there are lots of lodges there to show you what I mean.

I do not have a database or wix stores.

But next to every lodge or hotel I offer or even the set itineraries I have a text box with the price of that lodge etc which i manually type into the text bok. I have loads of options 100 odd lodges and every year when the price goes up I have to manually change them all which takes forever and some times the same lodge appears on different pages so the room for error is big.

I have linked spreadsheets to another part of my website (Fact sheet tables for the lodges) which has made my life so much easier in that part of the site. So when i discovered that, I thought there must be way to help me out with the prices.

I am guessing a database and then I link one cell in that data base to the text box for the lodge. So when I change that cell in the data base it will change on the site, but I cant figure it out or if there is a easier way to to it.

I hope that help to describe my problem a bit better

Many thanks in advance for you help

4

Hi,
First of all I noticed you have a lot of pages with similar design, I’d recommend you to check out dynamic pages .
You can connect the the elements you want to the database and they’ll be populated automatically, check out this article about database and connecting to data.