Support

Home Forums Event Espresso Premium Delivery options and shipping costs

Delivery options and shipping costs

Posted: June 30, 2013 at 4:05 am


Joël van de Pol

June 30, 2013 at 4:05 am

My client offers two delivery options for bought tickets: You can either get them at arrival or they can be shipped via mail. I know how I can add an additional question in the plugin, but is there a way to add additional shipping costs to the total price depending on the delivery option?


Dean

June 30, 2013 at 11:50 pm

Hi Joel,

You may want to try the pre release add on Price Modifier. It uses questions to modify the overall price of the ticket. However it does not at this time work alongside Multiple Event Registration add on.

https://eventespresso.com/wiki/espresso-price-modifier/


Joël van de Pol

July 1, 2013 at 2:47 am

Thanks for your answer. I have two delivery options, the first modifies the price, the second doesn’t. Unfortunately, the free option isn’t displayed. I tried this:
Selbstabholung|0.00,Postversand|8.00
Selbstabholung|0,Postversand|8.00
Selbstabholung|,Postversand|8.00
Selbstabholung,Postversand|8.00

None of those work. Is there a solution or is it a bug?


Dean

July 1, 2013 at 3:54 am

Hi,

This is the correct format: Selbstabholung|0.00,Postversand|8.00

It is expected behaviour for just one price to appear. Adding a price modifier of zero doesnt modify the price so it ignores it. As soon as you make the price modifier a penny/cent or more then it will affect the price.


Joël van de Pol

July 1, 2013 at 5:31 am

I think it should still show in the dropmenu.


Joël van de Pol

July 1, 2013 at 5:47 am

Because I want to give two options without making one of them the default. There might also be two free options and one with a fee, which would also be impossible.


Dean

July 1, 2013 at 6:29 am

Hi Joel,

I will certainly add this as a feature request, but currently it isnt possible with the default add on without making some changes to the code, which could be a total re-write of the add on. As I say though I will certainly add this to the feature request list.


Joël van de Pol

July 1, 2013 at 8:30 am

Great, thanks. Unfortunately, I notice now that the amount isn’t added to the total price on the confirmation page.


Dean

July 2, 2013 at 12:48 am

Hi,

I am not seeing that issue on my test server, do you have an example page on your site I can look at please?


Joël van de Pol

July 2, 2013 at 2:01 am

Here. You can choose any event. The checkbox at the end of the form is supposed to add 8 euros, yet it doesn’t show on the confirmation page.


Dean

July 2, 2013 at 2:12 am

Hi

Thanks for the link, that clarifies the issue. The Seating chart pricing over rules other pricing options. It seems the price modifier doesnt affect the seating chart. I’ll raise a ticket and see if we can get that resolved.


Joël van de Pol

July 8, 2013 at 6:33 am

Thanks. I’ve edited the plugin files to solve this problem.


Joël van de Pol

July 8, 2013 at 9:01 am

Okay, I thought I fixed it, but I didn’t.

In the database entry of the primary attendee, final_price is modified correctly, while total_cost stays unchanged.

In EE_Price_Modifier.class.php the final_price is updated with the following lines:

<code>$SQL = &#039;UPDATE &#039;. EVENTS_ATTENDEE_TABLE .&#039; SET final_price = final_price &#039; . $plus_or_minus . &#039; %f where id = %d&#039;;	
					if ( ! $wpdb-&gt;query( $wpdb-&gt;prepare( $SQL, $price_mod, $attendee_id ))) { $success = FALSE; }</code>

I added code to update the total price likewise, but it didn’t work. I don’t know where the total price is generated and updated, can you please help me with this?


Joël van de Pol

July 8, 2013 at 9:03 am

Here’s the code again.

<pre class=”brush: php; gutter: true; first-line: 1; highlight: []; html-script: false”>$SQL = 'UPDATE '. EVENTS_ATTENDEE_TABLE .' SET final_price = final_price ' . $plus_or_minus . ' %f where id = %d';
if ( ! $wpdb->query( $wpdb->prepare( $SQL, $price_mod, $attendee_id ))) {
$success = FALSE;
}


Joël van de Pol

July 8, 2013 at 9:04 am

Last try. Sorry.

<pre class=”brush: php; gutter: true; first-line: 1; highlight: []; html-script: false”>$SQL = 'UPDATE '. EVENTS_ATTENDEE_TABLE .' SET final_price = final_price ' . $plus_or_minus . ' %f where id = %d';
if ( ! $wpdb->query( $wpdb->prepare( $SQL, $price_mod, $attendee_id ))) {
$success = FALSE;
}


Sidney Harrell

July 8, 2013 at 12:02 pm

In the confirmation page template, it’s using $display_cost. It’s getting that from includes/process-registration/payment_page.php line 183. The $total_cost it uses there is getting overwritten by the seating chart add-on up on line 124. What you might want to do is update the seating chart seat purchase price where you are updating the final_price now.


Joël van de Pol

July 8, 2013 at 2:17 pm

Thanks for your help, it works.

The support post ‘Delivery options and shipping costs’ is closed to new replies.

Have a question about this support post? Create a new support post in our support forums and include a link to this existing support post so we can help you.

Event Espresso