wordpress - Edit booking duration for multiple products on WooCommerce -


i've imported on 200 products system using csv import suite but, see, cannot edit booking duration nor product availability automatically. meaning have go each product individually if want set proper booking duration.

is there way edit 1 (or any) of options below?

  • change default booking settings. if possible, where?
  • using simple update query in database. if possible, table?
  • add fields in csv file. if possible, fields?

i found properties needed in db , created script update. see code below in case needs. remember adapt needs.

replace `db_site`.one_postmeta (post_id, meta_key, meta_value) (select id, '_wc_booking_base_cost', '' `db_site`.one_posts post_type = 'product'); replace `db_site`.one_postmeta (post_id, meta_key, meta_value) (select id, '_wc_booking_calendar_display_mode', 'always_visible' `db_site`.one_posts post_type = 'product'); replace `db_site`.one_postmeta (post_id, meta_key, meta_value) (select id, '_wc_booking_duration_type', 'fixed' `db_site`.one_posts post_type = 'product'); replace `db_site`.one_postmeta (post_id, meta_key, meta_value) (select id, '_wc_booking_duration', 21 `db_site`.one_posts post_type = 'product'); replace `db_site`.one_postmeta (post_id, meta_key, meta_value) (select id, '_wc_booking_duration_unit', 'day' `db_site`.one_posts post_type = 'product'); replace `db_site`.one_postmeta (post_id, meta_key, meta_value) (select id, '_wc_booking_user_can_cancel', 'yes' `db_site`.one_posts post_type = 'product'); replace `db_site`.one_postmeta (post_id, meta_key, meta_value) (select id, '_wc_booking_cancel_limit', 8 `db_site`.one_posts post_type = 'product'); replace `db_site`.one_postmeta (post_id, meta_key, meta_value) (select id, '_wc_booking_cancel_limit_unit', 'day' `db_site`.one_posts post_type = 'product'); replace `db_site`.one_postmeta (post_id, meta_key, meta_value) (select id, '_wc_booking_min_date', 2 `db_site`.one_posts post_type = 'product'); replace `db_site`.one_postmeta (post_id, meta_key, meta_value) (select id, '_wc_booking_min_date_unit', 'week' `db_site`.one_posts post_type = 'product'); replace `db_site`.one_postmeta (post_id, meta_key, meta_value) (select id, '_wc_booking_buffer_period', 8 `db_site`.one_posts post_type = 'product'); replace `db_site`.one_postmeta (post_id, meta_key, meta_value) (select id, '_wc_review_count', 0 `db_site`.one_posts post_type = 'product'); replace `db_site`.one_postmeta (post_id, meta_key, meta_value) (select id, '_wc_booking_cost', '' `db_site`.one_posts post_type = 'product'); replace `db_site`.one_postmeta (post_id, meta_key, meta_value) (select id, '_wc_display_cost', '' `db_site`.one_posts post_type = 'product'); replace `db_site`.one_postmeta (post_id, meta_key, meta_value) (select id, '_wc_booking_min_duration', 1 `db_site`.one_posts post_type = 'product'); replace `db_site`.one_postmeta (post_id, meta_key, meta_value) (select id, '_wc_booking_max_duration', 1 `db_site`.one_posts post_type = 'product'); replace `db_site`.one_postmeta (post_id, meta_key, meta_value) (select id, '_wc_booking_enable_range_picker', 'no' `db_site`.one_posts post_type = 'product'); replace `db_site`.one_postmeta (post_id, meta_key, meta_value) (select id, '_wc_booking_qty', 1 `db_site`.one_posts post_type = 'product'); replace `db_site`.one_postmeta (post_id, meta_key, meta_value) (select id, '_wc_booking_has_persons', 'no' `db_site`.one_posts post_type = 'product'); replace `db_site`.one_postmeta (post_id, meta_key, meta_value) (select id, '_wc_booking_person_qty_multiplier', 'no' `db_site`.one_posts post_type = 'product'); replace `db_site`.one_postmeta (post_id, meta_key, meta_value) (select id, '_wc_booking_person_cost_multiplier', 'no' `db_site`.one_posts post_type = 'product'); replace `db_site`.one_postmeta (post_id, meta_key, meta_value) (select id, '_wc_booking_min_persons_group', 1 `db_site`.one_posts post_type = 'product'); replace `db_site`.one_postmeta (post_id, meta_key, meta_value) (select id, '_wc_booking_max_persons_group', '' `db_site`.one_posts post_type = 'product'); replace `db_site`.one_postmeta (post_id, meta_key, meta_value) (select id, '_wc_booking_has_person_types', 'no' `db_site`.one_posts post_type = 'product'); replace `db_site`.one_postmeta (post_id, meta_key, meta_value) (select id, '_wc_booking_has_resources', 'no' `db_site`.one_posts post_type = 'product'); replace `db_site`.one_postmeta (post_id, meta_key, meta_value) (select id, '_wc_booking_resources_assignment', 'customer' `db_site`.one_posts post_type = 'product'); replace `db_site`.one_postmeta (post_id, meta_key, meta_value) (select id, '_wc_booking_max_date', 12 `db_site`.one_posts post_type = 'product'); replace `db_site`.one_postmeta (post_id, meta_key, meta_value) (select id, '_wc_booking_max_date_unit', 'month' `db_site`.one_posts post_type = 'product'); replace `db_site`.one_postmeta (post_id, meta_key, meta_value) (select id, '_wc_booking_first_block_time', '' `db_site`.one_posts post_type = 'product'); replace `db_site`.one_postmeta (post_id, meta_key, meta_value) (select id, '_wc_booking_requires_confirmation', 'no' `db_site`.one_posts post_type = 'product'); replace `db_site`.one_postmeta (post_id, meta_key, meta_value) (select id, '_wc_booking_default_date_availability', 'available' `db_site`.one_posts post_type = 'product'); replace `db_site`.one_postmeta (post_id, meta_key, meta_value) (select id, '_wc_booking_check_availability_against', '' `db_site`.one_posts post_type = 'product'); replace `db_site`.one_postmeta (post_id, meta_key, meta_value) (select id, '_wc_booking_resouce_label', '' `db_site`.one_posts post_type = 'product'); replace `db_site`.one_postmeta (post_id, meta_key, meta_value) (select id, '_wc_booking_availability', 'a:0:{}' `db_site`.one_posts post_type = 'product'); replace `db_site`.one_postmeta (post_id, meta_key, meta_value) (select id, '_wc_booking_pricing', 'a:0:{}' `db_site`.one_posts post_type = 'product'); replace `db_site`.one_postmeta (post_id, meta_key, meta_value) (select id, '_wc_memberships_product_viewing_restricted_message', '' `db_site`.one_posts post_type = 'product'); replace `db_site`.one_postmeta (post_id, meta_key, meta_value) (select id, '_wc_memberships_use_custom_product_viewing_restricted_message', 'no' `db_site`.one_posts post_type = 'product'); replace `db_site`.one_postmeta (post_id, meta_key, meta_value) (select id, '_wc_memberships_product_purchasing_restricted_message', '' `db_site`.one_posts post_type = 'product'); replace `db_site`.one_postmeta (post_id, meta_key, meta_value) (select id, '_wc_memberships_use_custom_product_purchasing_restricted_message', 'no' `db_site`.one_posts post_type = 'product'); replace `db_site`.one_postmeta (post_id, meta_key, meta_value) (select id, '_wc_memberships_force_public', 'no' `db_site`.one_posts post_type = 'product'); replace `db_site`.one_postmeta (post_id, meta_key, meta_value) (select id, '_wc_memberships_exclude_discounts', 'no' `db_site`.one_posts post_type = 'product');

not best sql script i've created job :)


-

Comments

Post a Comment

Popular posts from this blog

python - How to insert QWidgets in the middle of a Layout? -

Image
i'm using qt framework build graphical user interface. use qgridlayout position qwidgets neatly. gui looks this: my application regularly adds new widgets gui @ runtime. these new widgets not added @ end of qlayout, somewhere in middle. the procedure bit cumbersome. applied on figure above, need take out widg_c , widg_d , ... qgridlayout. next, add widg_x and widg_y , , put other widgets again. how remove widgets qgridlayout: for in reversed(range(mygridlayout.count())): self.itemat(i).widget().setparent(none) ### as long you're dealing small amount of widgets, procedure not disaster. in application display lot of small widgets - perhaps 50 or more! application freezes second while procedure ongoing, annoying user. there way insert widgets somewhere in qlayout, without need take out other widgets? edit: apparently solution qvboxlayout simple. use function insertwidget(..) instead of addwidget(..) . docs can found link: http://doc.qt.io/qt-5/qboxlayou
Read more

python - serve multiple gunicorn django instances under nginx ubuntu -

i need serve 2 webs apps (django) on gunicorn under different domain names using nginx on ubuntu. started using tutorial: https://www.digitalocean.com/community/tutorials/how-to-set-up-django-with-postgres-nginx-and-gunicorn-on-ubuntu-16-04 it worked fine 1 using that. tried same thing second gives me 502 gateway second domain. tried following tutorial: http://michal.karzynski.pl/blog/2013/10/29/serving-multiple-django-applications-with-nginx-gunicorn-supervisor/ i'm @ part run gunicorn start script: sudo bin/gunicorn_start i response: starting webuildblack root traceback (most recent call last): file "/home/devin/webuildblack/bin/gunicorn", line 7, in <module> gunicorn.app.wsgiapp import run importerror: no module named 'gunicorn.app'; 'gunicorn' not package you have named program gunicorn.py gunicorn -package. rename file , remove gunicorn.pyc file.
Read more

module - Prestashop displayPaymentReturn hook url -

i new prestashop developer , trying create paymentmodule. have got show payment method can not proceed purchase because not know hot works. does know should redirect run hooddisplaypaymentreturn method? i happy if explain me complete navigation map make purchase. anyway, can find relation between hooks , pages? when have new module payment rely on simplest provided prestashop: bankwire. inside can find 3 hooks. hookpayment: public function hookpayment($params) { if (!$this->active) return; if (!$this->checkcurrency($params['cart'])) return; $this->smarty->assign(array( 'this_path' => $this->_path, 'this_path_bw' => $this->_path, 'this_path_ssl' => tools::getshopdomainssl(true, true).__ps_base_uri__.'modules/'.$this->name.'/' )); return $this->display(__file__, 'payment.tpl'); } hookdisplaypaymenteu: public fun
Read more