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

qt - QML MouseArea onWheel event not working properly when inside QML Scrollview -

i have mousearea inside scrollview inside rectangle . implemented zoom feature zooms in/out when pressing ctrl , scrolling mouse wheel. however, zooms in when scrollview way @ top, , zooms out when scrollview way @ bottom. there additional logic handle external drag , drop of files. issue should able replicated long text inside textedit big enough scrollview . apparently bug before, can't work properly. tried solution in following link: qtquick2: handle onwheel event inside of scrollview rectangle { id: palgenrectangle layout.minimumwidth: 50 property string display //width:800 color: "white" scrollview { id: palgentextscrollview anchors.fill: parent mousearea { id: mousearea anchors.fill: parent onwheel: { if (wheel.modifiers & qt.controlmodifier){ if (wheel.angledelta.y > 0) { mainte...
Read more

java - is not an enclosing class / new Intent Cannot Resolve Constructor -

thanks checking out question! i have relativly ismple loop add onclicklistener each imageview add layout, when trying add new intent it, gives me 1 of following errors: string[] imageurls = imageurlsstring.split("/"); (int = 0; < imageurls.length; i++){ imageview image = new imageview(this); image.setlayoutparams(new android.view.viewgroup.layoutparams(getpx(182),getpx(256))); image.setpadding(getpx(3),getpx(3),getpx(3),getpx(3)); final string imageurl = ".../images/" + imageurls[i]; picasso.with(this).load(imageurl).into(image); image.setonclicklistener(new view.onclicklistener() { @override public void onclick(view view) { intent intent; intent = new intent(this, imageactivity.class); intent.putextra("url", imageurl); startactivity(intent); } }); linearlayout.addview(image)...
Read more

python - Error importing VideoFileClip from moviepy : AttributeError: 'PermissionError' object has no attribute 'message' -

i'm using jupyter notebook. have tried anaconda console well. tried importing both ways shown below from moviepy.editor import videofileclip moviepy.video.io.videofileclip import videofileclip both of them gave me same error. full trace below attributeerror traceback (most recent call last) <ipython-input-10-9afa9d6e87c4> in <module>() 6 import glob 7 import math ----> 8 moviepy.editor import videofileclip 9 moviepy.video.io.videofileclip import videofileclip c:\program files\anaconda3\lib\site-packages\moviepy\editor.py in <module>() 20 # clips 21 ---> 22 .video.io.videofileclip import videofileclip 23 .video.io.imagesequenceclip import imagesequenceclip 24 .video.io.downloader import download_webfile c:\program files\anaconda3\lib\site-packages\moviepy\video\io\videofileclip.py in <module>() 1 import os 2 ----> 3 moviepy.video.videoclip import videoclip ...
Read more