Comments alessandro started the conversationJanuary 10, 2018 at 3:24pmhello I'm using your theme for a real estate website for holiday homes. For each accommodation I set up the prices in the vacancies. now after one year I need to update automatically all dates from 2017 to 2018 so used two UPDATE query on the tables 6d2aQ_byt_accommodation_vacancies_days updating the day value using UPDATE 6d2aQ_byt_accommodation_vacancies_days set 'day'=DATE_ADD('day', INTERVAL 1 YEAR); and on the table 6d2aQ_byt_accommodation_vacancies UPDATE 6d2aQ_byt_accommodation_vacancies SET `start_date'= DATE_ADD(`start_date', INTERVAL 1 YEAR), 'end_date'= DATE_ADD('end_date', INTERVAL 1 YEAR); now on the tables all dated are shifted of +1 year.. but the now front end don't show the vacancies. all accommodations doens't show prices and seems that are not available for booking can you help me? thanks 2,057Theme repliedJanuary 11, 2018 at 10:02amHi,Unfortunately there is no bulk update of vacancies feature within the theme and we cannot debug which dates have been skipped with your sql query manually.I recommend you create the vacancies for 2018 via the admin interface.Best regards, themeenergy supportalessandro repliedJanuary 11, 2018 at 3:11pmso it means that your theme is useless? how an real estate o travel agency that has hundreds of product can update the catalog without rebuild it?this is a very important feature!on the admin panel all vacancies are updated to 2018.in which other table do you store information about the vacancies?6d2aQ_byt_accommodation_vacancies_days6d2aQ_byt_accommodation_vacancies some other tables?cheers 2,057Theme repliedJanuary 12, 2018 at 7:44amHi,No, only these two tables are used.Thanks,Best regards, themeenergy support Sign in to reply ...
hello
I'm using your theme for a real estate website for holiday homes.
For each accommodation I set up the prices in the vacancies.
now after one year I need to update automatically all dates from 2017 to 2018
so used two UPDATE query on the tables 6d2aQ_byt_accommodation_vacancies_days
updating the day value using UPDATE 6d2aQ_byt_accommodation_vacancies_days set 'day'=DATE_ADD('day', INTERVAL 1 YEAR);
and on the table 6d2aQ_byt_accommodation_vacancies
UPDATE 6d2aQ_byt_accommodation_vacancies SET `start_date'= DATE_ADD(`start_date', INTERVAL 1 YEAR), 'end_date'= DATE_ADD('end_date', INTERVAL 1 YEAR);
now on the tables all dated are shifted of +1 year.. but the now front end don't show the vacancies.
all accommodations doens't show prices and seems that are not available for booking
can you help me?
thanks
Hi,
Unfortunately there is no bulk update of vacancies feature within the theme and we cannot debug which dates have been skipped with your sql query manually.
I recommend you create the vacancies for 2018 via the admin interface.
Best regards,
themeenergy support
so it means that your theme is useless?
how an real estate o travel agency that has hundreds of product can update the catalog without rebuild it?
this is a very important feature!
on the admin panel all vacancies are updated to 2018.
in which other table do you store information about the vacancies?
6d2aQ_byt_accommodation_vacancies_days
6d2aQ_byt_accommodation_vacancies
some other tables?
cheers
Hi,
No, only these two tables are used.
Thanks,
Best regards,
themeenergy support