Perch Shop: Displaying ex VAT & inc VAT on Product Listing

Glen · Jul 6th 2021

Hi All

I'm currently building a full online shop for trade customers only, so it shows all prices as ex VAT but I also wish to include the inc VAT price too for those not VAT registered.

I've got it to work perfectly on a single product page but am having problems displaying it on a product list page, this is what I've got so far to display the product listing...

Code

perch_shop_products([
'category' => 'products/'.perch_get('path').'/',
'template' => 'products/list-category.html',
'each' => function($item) {
$item['incVAT'] = perch_shop_products([
'template' => 'products/ex_vat.html',
$VAT = '1.20',
$incVAT = number_format($exVAT * $VAT, 2),
], true);
return $item;
},
]);

Display More

...this is basically listing all the ex VAT prices for all products in one string... £6.255.757.506.256.257.506.255.655.9997.993.4946.997.958.35 inc VAT.

Any help to get this to work out the inc VAT price for each product individually would be much appreciated.

Glen

Mxkert · Jul 6th 2021

Did not try it, but can you try using:

Code

$item['incVAT'] = perch_shop_product($item['slug'], [
'template' => 'products/ex_vat.html',
$VAT = '1.20',
$incVAT = number_format($exVAT * $VAT, 2),
], true);

So you would use the perch_shop_product function to get a single product (using the slug) in the each-loop, instead of getting ALL the products.

Glen · Jul 6th 2021

Hi Mxkert many thanks for your help.

Unfortunately, I am still getting all the ex VAT prices listed like so...

£5.656.255.757.506.256.257.506.255.9997.993.4946.997.958.35 inc VAT

Glen

Mxkert · Jul 6th 2021

What does your list-category.html template looks like?

Glen · Jul 6th 2021

Quote from Mxkert

What does your list-category.html template looks like?

Code

<perch:before>
<div class="container">
<div class="row row-cols-1 row-cols-md-4 g-4">
</perch:before>
<div class="col">
<div class="card h-100 text-center">
<div class="card-body">
<img src="<perch:shop id="image" type="image" label="Image" width="350" height="350" crop="true">" class="card-img-top" alt="<perch:shop id="title">">
<h5 class="card-title mt-3"><a href="/product/<perch:shop id="slug" type="slug">" class="stretched-link"><perch:shop id="title"></a></h5>
</div>
<div class="card-footer">
<p class="card-text h5 mb-1"><perch:shop id="price" type="shop_currency_value"></p>
<p class="small text-muted mb-1">£<perch:shop id="incVAT"> inc VAT</p>
</div>
</div>
</div>
<perch:after>
</div>
</div>
</perch:after>

Display More

Mxkert · Jul 6th 2021

Wait, your each function is not formatted correctly I think.

Code

// Here you get the value for 'exc. VAT' for the product matching the slug
$exVAT = perch_shop_product($item['slug'], [
'template' => 'products/ex_vat.html'
], true);
// Declare VAT amount
$VAT = '1.20';
// Use the 'exc. VAT' value and the VAT amount to set the 'inc. VAT' amount
$item['incVAT'] = number_format($exVAT * $VAT, 2),
return $item;

Display More

Again doing this from the top of my head, sorry.

Glen · Jul 6th 2021

Thank you so much Mxkert for your help so far, we're getting there.

I am now getting just one amount but I'm getting the same amount on each product listed... £6.79 inc VAT.

Code

perch_shop_products([
'category' => 'products/'.perch_get('path').'/',
'template' => 'products/list-category.html',
'each' => function($item) {
$exVAT = perch_shop_product($item['slug'], [
'template' => 'products/ex_vat.html'
], true);
$VAT = '1.20';
$item['incVAT'] = number_format($exVAT * $VAT, 2);
return $item;
},
]);

Display More

Mxkert · Jul 6th 2021

If you change $exVAT to $item['exVAT'] everywhere?

Glen · Jul 6th 2021

Quote from Mxkert

If you change $exVAT to $item['exVAT'] everywhere?

I get the same result unfortunately...

Code

'each' => function($item) {
$item['exVAT'] = perch_shop_product($item['slug'], [
'template' => 'products/ex_vat.html'
], true);
$VAT = '1.20';
$item['incVAT'] = number_format($item['exVAT'] * $VAT, 2);
return $item;
},

Mxkert · Jul 6th 2021

What does your ex_vat.html look like?

And what do you see on the page when you use the following:

Code

'each' => function($item) {
$item['exVAT'] = perch_shop_product($item['slug'], [
'template' => 'products/ex_vat.html'
], true);
$VAT = '1.20';
$item['incVAT'] = number_format($item['exVAT'] * $VAT, 2);
print_r($item['exVAT']);
echo '<br>';
echo $item['incVAT'];
echo '<br><br>';
// return $item;
},

Display More

Glen · Jul 6th 2021

Quote from Mxkert

What does your ex_vat.html look like?

Code

<perch:shop id="price">

Glen · Jul 6th 2021

Quote from Mxkert

And what do you see on the page when you use the following:

Code

'each' => function($item) {

$item['exVAT'] = perch_shop_product($item['slug'], [

'template' => 'products/ex_vat.html'

], true);

$VAT = '1.20';

$item['incVAT'] = number_format($item['exVAT'] * $VAT, 2);

            print_r($item['exVAT']);

            echo '<br>';

            echo $item['incVAT'];

echo '<br><br>';

// return $item;

},

Display More

5.656.255.757.506.256.257.506.255.9997.993.4946.997.958.35

6.79

5.656.255.757.506.256.257.506.255.9997.993.4946.997.958.35

6.79

5.656.255.757.506.256.257.506.255.9997.993.4946.997.958.35

6.79

5.656.255.757.506.256.257.506.255.9997.993.4946.997.958.35

6.79

5.656.255.757.506.256.257.506.255.9997.993.4946.997.958.35

6.79

5.656.255.757.506.256.257.506.255.9997.993.4946.997.958.35

6.79

5.656.255.757.506.256.257.506.255.9997.993.4946.997.958.35

6.79

5.656.255.757.506.256.257.506.255.9997.993.4946.997.958.35

6.79

5.656.255.757.506.256.257.506.255.9997.993.4946.997.958.35

6.79

5.656.255.757.506.256.257.506.255.9997.993.4946.997.958.35

6.79

5.656.255.757.506.256.257.506.255.9997.993.4946.997.958.35

6.79

5.656.255.757.506.256.257.506.255.9997.993.4946.997.958.35

6.79

5.656.255.757.506.256.257.506.255.9997.993.4946.997.958.35

6.79

5.656.255.757.506.256.257.506.255.9997.993.4946.997.958.35

6.79

Mxkert · Jul 12th 2021

Sorry Glen, I forgot about this thread.

What happens if you change it to

Code

$item['exVAT'] = perch_shop_product('', [
'template' => 'products/ex_vat.html',
'filter' => 'slug',
'match' => 'eq',
'value' => $item['slug'],
], true);

Glen · Jul 23rd 2021

Hi Mxkert

Thank you for your help.

So sorry for the delay, I have had to spend more time on other projects.

Quote from Mxkert

Sorry Glen, I forgot about this thread.

What happens if you change it to

Code

$item['exVAT'] = perch_shop_product('', [

'template' => 'products/ex_vat.html',

'filter' => 'slug',

'match' => 'eq',

'value' => $item['slug'],

], true);

...unfortunately, no data is displayed / passed to the template.

Glen

tonyastley · Aug 25th 2021

Try having a look here: Perch Shop Show Product Price with VAT by default

I used a perch template filter to modify the price.

Glen · Aug 27th 2021

tonyastley you sir are an absolute superstar - works perfectly