Title: markboulder's Replies | WordPress.org --- # markboulder [ ](https://wordpress.org/support/users/markboulder/) * [Profile](https://wordpress.org/support/users/markboulder/) * [Topics Started](https://wordpress.org/support/users/markboulder/topics/) * [Replies Created](https://wordpress.org/support/users/markboulder/replies/) * [Reviews Written](https://wordpress.org/support/users/markboulder/reviews/) * [Topics Replied To](https://wordpress.org/support/users/markboulder/replied-to/) * [Engagements](https://wordpress.org/support/users/markboulder/engagements/) * [Favorites](https://wordpress.org/support/users/markboulder/favorites/) Search replies: ## Forum Replies Created Viewing 12 replies - 1 through 12 (of 12 total) * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Enterprise Shipping for Pitney Bowes] Developer Account Required?](https://wordpress.org/support/topic/developer-account-required/) * Thread Starter [markboulder](https://wordpress.org/support/users/markboulder/) * (@markboulder) * [2 years, 4 months ago](https://wordpress.org/support/topic/developer-account-required/#post-17422370) * Hi, * Thanks again for your follow up. I’ve been in communication with Pitney Bowes support and it sounds like it may require an eCommerce PitneyShip account in order for this to work, but the support from them hasn’t been great, so I don’t feel confident in that. Do you happen to know if that is the case? I was finally put in touch with the account manager for my client so I’m hoping he’ll be able to provide more information. * Ultimately, the client is actually more interested in having all WooCommerce transactions sent to their PitneyShip account and printing labels from there vs. the WP admin, in addition to getting the correct PitneyShip live rates for customers at checkout. Does your plugin also send Woo transactions to PitneyShip such that they could print from there if they’d prefer? * While working on this, we also came across [https://www.pitneybowes.com/us/support/article/000089540/connecting-your-woocommerce-store-to-pitneyship.html](https://www.pitneybowes.com/us/support/article/000089540/connecting-your-woocommerce-store-to-pitneyship.html) which details a way to connect Woo and PitneyShip such that: “Connecting your WooCommerce store to the PitneyShip allows you to manage data between both platforms.” which of course is very vague and provides no further details on what that means. There was no “add store” option anywhere on the client PitneyShip account which is where I was told that an “eCommerce level” account was needed in order to enable that, but no solid information on what that connection using their method actually achieves. * Thanks again for all of your help. Please let me know if you have any more information to share based on the above. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Enterprise Shipping for Pitney Bowes] Developer Account Required?](https://wordpress.org/support/topic/developer-account-required/) * Thread Starter [markboulder](https://wordpress.org/support/users/markboulder/) * (@markboulder) * [2 years, 4 months ago](https://wordpress.org/support/topic/developer-account-required/#post-17411021) * Thanks for your reply. I set up an account using that link yet when I click on the “login” link in the PB Ship Admin I get a message after logging in of: * Your login attempt failed. The user is not authorized to access Merchant Portal. * Is there some kind of additional step I need to take? Also, it’s not clear to me how I’d link the client PB account to the developer account to. In general I’m a bit confused about the steps to set this all up. Do you have any documentation available? * The query being echoed is the following, the first is after activating the plugin, and the second is on the admin page for the plugin: * First: * ```wp-block-code SELECT o.ID order_id ,o.post_type channel ,o.post_status ,m.meta_id ,DATE_FORMAT(MAX(s.meta_value),'%Y-%m-%d')shipped ,d.meta_value delivery_est ,IFNULL(IFNULL((SELECT meta_value FROM wp_postmeta WHERE meta_key='_shipping_first_name' AND post_id=o.ID LIMIT 1),(SELECT meta_value FROM wp_postmeta WHERE meta_key='_billing_first_name' AND post_id=o.ID LIMIT 1)),'')fname ,(SELECT 1 FROM wp_postmeta JOIN wp_options ON option_name=CONCAT('sms_sb_',meta_value) WHERE meta_key='_billing_phone' AND post_id=o.ID LIMIT 1)subscribe ,(SELECT meta_value FROM wp_postmeta LEFT JOIN wp_options ON option_name=CONCAT('pb_unsb_',meta_value) WHERE option_name IS NULL AND meta_key='_billing_phone' AND post_id=o.ID LIMIT 1)phone ,(SELECT LOWER(meta_value) FROM wp_postmeta LEFT JOIN wp_options ON option_name=CONCAT('pb_unsb_',meta_value) WHERE option_name IS NULL AND meta_key='_billing_email' AND post_id=o.ID LIMIT 1)email ,IFNULL(m.meta_key,'')label ,IFNULL(m.meta_value,'')label_meta FROM wp_posts o JOIN wp_postmeta s ON s.post_id=o.ID AND s.meta_key='_last_shipped' AND s.meta_value>=NOW()-INTERVAL 30 DAY LEFT JOIN wp_postmeta d ON d.post_id=o.ID AND d.meta_key='delivery_est' AND DATE_FORMAT(d.meta_value,'%Y-%m-%d')>DATE_FORMAT(s.meta_value,'%Y-%m-%d') JOIN wp_postmeta m ON m.post_id=o.ID AND m.meta_key LIKE '_pb_label_meta%' AND m.meta_value NOT LIKE '%inbound%' AND m.meta_value NOT LIKE '%cancel%' AND m.meta_value NOT LIKE '%returnToSender%' AND m.meta_value NOT LIKE '%delivered,%' WHERE o.post_type IN ('import_order','shop_order') AND (LENGTH('0')>1 OR (d.post_id IS NULL OR DATE_FORMAT(d.meta_value,'%Y-%m-%d') BETWEEN DATE_FORMAT(NOW()-INTERVAL 3 DAY,'%Y-%m-%d') AND DATE_FORMAT(NOW()+INTERVAL 10 DAY,'%Y-%m-%d'))) AND o.post_status NOT IN ('wc-cancelled','trash') ORDER BY m.meta_id DESC LIMIT 50; ``` * Second: * SELECT n.option_value store_name ,(SELECT option_value FROM wp_options WHERE option_name=’woocommerce_store_address’)address,(SELECT option_value FROM wp_options WHERE option_name=’woocommerce_store_address_2′)address_2,(SELECT option_value FROM wp_options WHERE option_name=’woocommerce_store_city’)city,(SELECT option_value FROM wp_options WHERE option_name=’woocommerce_default_country’)ctry_state,(SELECT option_value FROM wp_options WHERE option_name=’woocommerce_store_postcode’)zip,( SELECT option_value FROM wp_options WHERE option_name=’woocommerce_store_tel’) tel,IFNULL(NULLIF((SELECT option_value FROM wp_options WHERE option_name=’woocommerce_email_from_address’),”),( SELECT option_value FROM wp_options WHERE option_name=’admin_email’))emailFROM wp_options nWHERE option_name=’blogname’; * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[ICS Calendar] Events not showing (including preview site)](https://wordpress.org/support/topic/events-not-showing-including-preview-site/) * Thread Starter [markboulder](https://wordpress.org/support/users/markboulder/) * (@markboulder) * [2 years, 11 months ago](https://wordpress.org/support/topic/events-not-showing-including-preview-site/#post-16910823) * Awesome, thank you so much for your quick fix! * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[ICS Calendar] Events not showing (including preview site)](https://wordpress.org/support/topic/events-not-showing-including-preview-site/) * Thread Starter [markboulder](https://wordpress.org/support/users/markboulder/) * (@markboulder) * [2 years, 11 months ago](https://wordpress.org/support/topic/events-not-showing-including-preview-site/#post-16910772) * Great, thank you so much for the assistance. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[ICS Calendar] Events not showing (including preview site)](https://wordpress.org/support/topic/events-not-showing-including-preview-site/) * Thread Starter [markboulder](https://wordpress.org/support/users/markboulder/) * (@markboulder) * [2 years, 11 months ago](https://wordpress.org/support/topic/events-not-showing-including-preview-site/#post-16910740) * Please refer to the html version of the calendar I posted: [https://outlook.office365.com/calendar/published/dc1cb749af0546f7a4dc98f298b41ff2@seuplift.org/ea4899b35c7544d1b64e896b8427a4b26259028811832111781/calendar.html](https://outlook.office365.com/calendar/published/dc1cb749af0546f7a4dc98f298b41ff2@seuplift.org/ea4899b35c7544d1b64e896b8427a4b26259028811832111781/calendar.html) You’ll see events specifically for Aug 1 and Aug 2 that are not showing on the ICS calendar preview. For example, the following shows on the html version, but not the ICS preview: * Hosford-Abernethy NA (HAND) Executive Committee Meeting * Tue 8/1/2023 7:00 PM – 8:00 PM * Forum: [Themes and Templates](https://wordpress.org/support/forum/themes-and-templates/) In reply to: [[Twenty Thirteen] Change Behavior and Positioning of sub-menu](https://wordpress.org/support/topic/change-behavior-and-positioning-of-sub-menu/) * Thread Starter [markboulder](https://wordpress.org/support/users/markboulder/) * (@markboulder) * [11 years, 3 months ago](https://wordpress.org/support/topic/change-behavior-and-positioning-of-sub-menu/#post-5897585) * That was very helpful! Thanks so much! * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Events Manager - Calendar, Bookings, Tickets, and more!] Location Submission Form and Custom Taxonomy](https://wordpress.org/support/topic/location-submission-form-and-custom-taxonomy/) * Thread Starter [markboulder](https://wordpress.org/support/users/markboulder/) * (@markboulder) * [12 years, 10 months ago](https://wordpress.org/support/topic/location-submission-form-and-custom-taxonomy/#post-4013797) * Thanks for chiming in Marcus. I’ve already created the custom taxonomy, and have applied it to the search forms successfully. What I need to do is have the taxonomy show up on the locations submission form, so that users can choose this taxonomy when creating a location. It shows up on the backend create location form and works great, it just doesn’t show up as an option on the front end location submission form. Any way to enable this? What file controls this form, and what would I need to add to show the custom taxonomy as an option? Thanks so much for your help. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Events Manager - Calendar, Bookings, Tickets, and more!] Location Submission Form and Custom Taxonomy](https://wordpress.org/support/topic/location-submission-form-and-custom-taxonomy/) * Thread Starter [markboulder](https://wordpress.org/support/users/markboulder/) * (@markboulder) * [12 years, 10 months ago](https://wordpress.org/support/topic/location-submission-form-and-custom-taxonomy/#post-4013744) * I need locations to be able to be assigned to more than one of these taxonomies and am using these for custom taxonomy archive pages and searching, so custom location attributes would not meet my needs. I wouldn’t imagine that adding this custom taxonomy as an option on the Location Submission form is that complicated( it already shows on the backend add/edit location page). Any ideas? * Also, any ideas for my other question regarding enabling approval status for locations? * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Events Manager - Calendar, Bookings, Tickets, and more!] Custom Taxonomy Locations Page](https://wordpress.org/support/topic/custom-taxonomy-locations-page/) * Thread Starter [markboulder](https://wordpress.org/support/users/markboulder/) * (@markboulder) * [13 years, 2 months ago](https://wordpress.org/support/topic/custom-taxonomy-locations-page/#post-3603731) * I am still struggling with this, and any help would be appreciated. I added in the slug rewrite: * ``` 'rewrite' => array( 'slug' => 'supplier', 'with_front' => false, 'hierarchical' => true ), ``` * and also added in a custom taxonomy to ‘posts’ just to see if it was specific to EM. It is, because I see the archive page at mysite.com/test/tesing , “test” being the cust. tax. name, and “testing” being one of the terms. * Why is this not working for the locations taxonomy? It certainly is possible, as event categories are a custom taxonomy for a custom post (events), and are able to display pages by event category. What needs to be done to enable this same thing for my custom taxonomy on locations? * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Events Manager - Calendar, Bookings, Tickets, and more!] Custom Taxonomy Locations Page](https://wordpress.org/support/topic/custom-taxonomy-locations-page/) * Thread Starter [markboulder](https://wordpress.org/support/users/markboulder/) * (@markboulder) * [13 years, 2 months ago](https://wordpress.org/support/topic/custom-taxonomy-locations-page/#post-3603687) * Thanks for that. I added it, and of course that added the events categories to locations. If that’s the only solution, though not ideal, I could work with that- however using the shortcode simply displays all the locations. I tried location_category =”Cat Name” , location_category=”2″ and location_category=2 . All show every location. Also, when I go to mysite.com/locations/cat-slug nothing shows. Likewise with mysite.com/cat-slug. What do I have to do to get either the shortcode working, or the url showing a category archive page. I would really prefer to use the custom taxonomy that I already created for locations, and display a taxonomy archive page for that. For example mysite.com/locations/cust-tax-slug/ * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Events Manager - Calendar, Bookings, Tickets, and more!] Searching Multiple Categories](https://wordpress.org/support/topic/searching-multiple-categories/) * Thread Starter [markboulder](https://wordpress.org/support/users/markboulder/) * (@markboulder) * [13 years, 2 months ago](https://wordpress.org/support/topic/searching-multiple-categories/#post-3603682) * This is development work for a client, so unfortunately I can’t freely give out the development link (plus it’s currently restricted by ip address). I am referring to events-search.php. I have searched the forums extensively, and the only solution I saw suggested adding a multi-select, or replacing the select with a checkbox group, but I am still not sure how and where I’d modify the corresponding sql statement. The function wp_dropdown_categories could perhaps be replaced with wp_category_checklist but I’m not quite sure how to implement that effectively, and more importantly, what else I’d need to modify in events manager to make it work. From events-search.php: * ``` 0, 'orderby' =>'name', 'name' => 'category', 'hierarchical' => true, 'taxonomy' => EM_TAXONOMY_CATEGORY, 'selected' => $selected, 'show_option_none' => get_option('dbem_search_form_categories_label'), 'class'=>'em-events-search-category')); EM_Object::ms_global_switch_back(); //if switched above, switch back ?> ``` * I really appreciate any ideas on this one. I currently have a number of categories that need to have the capability to be multi-selected and displayed with the search (ie, show all posts that match any of the selected categories). * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Plugin: Events Manager] Discounts to mulitple ticket purchases](https://wordpress.org/support/topic/plugin-events-manager-discounts-to-mulitple-ticket-purchases/) * Thread Starter [markboulder](https://wordpress.org/support/users/markboulder/) * (@markboulder) * [14 years, 1 month ago](https://wordpress.org/support/topic/plugin-events-manager-discounts-to-mulitple-ticket-purchases/#post-2753866) * Yes, it has a coupon option, but I don’t see anywhere to apply a discount for purchasing multiple tickets at once. Viewing 12 replies - 1 through 12 (of 12 total)