00:00:07:15 - 00:00:08:28
This example demonstrates the
00:00:08:28 - 00:00:12:13
tiered pricing capability
of the generic pricing script.
00:00:13:00 - 00:00:16:04
By enabling tiered pricing,
the administrator can ensure that
00:00:16:04 - 00:00:20:13
different prices can be utilized depending
on the quantity of a product ordered.
00:00:21:26 - 00:00:24:24
For example,
purchasing one of a product configuration
00:00:25:01 - 00:00:28:28
may be a different price per unit
than purchasing ten of them or 50 of them.
00:00:29:21 - 00:00:32:27
Tier pricing allows us to factor
in this change in price
00:00:32:27 - 00:00:35:13
based on quantity.
00:00:36:00 - 00:00:39:01
So the first thing I want to show you
here is a sample product
00:00:39:01 - 00:00:41:23
which is available
for you to use as a reference.
00:00:42:07 - 00:00:45:13
So I've created a storefront
which has a few examples
00:00:45:13 - 00:00:47:20
of pricing scripts in action.
00:00:47:20 - 00:00:50:08
You can get this
just by going to
00:00:50:08 - 00:00:53:11
https://training.infigosoftware.com/pricingscripts
00:00:53:22 - 00:00:57:18
And for this particular tutorial,
it's product number three,
00:00:57:18 - 00:01:03:09
which is the tier pricing script.
00:01:03:09 - 00:01:04:15
So this sample product
00:01:04:15 - 00:01:07:15
contains it's got a description
of the purpose of the product,
00:01:08:06 - 00:01:11:29
it's got the configuration
of the pricing script,
00:01:11:29 - 00:01:14:19
which we'll talk about
a little bit later on.
00:01:14:19 - 00:01:18:12
It's got a visual version of the CSV
that's utilized
00:01:18:12 - 00:01:20:01
for this particular product.
00:01:20:01 - 00:01:23:12
So you can see the data
that's been fed into the background
00:01:24:27 - 00:01:26:00
and the right at the bottom.
00:01:26:00 - 00:01:30:21
It's got a functional version
of that pricing script in action.
00:01:30:21 - 00:01:34:17
So you're able to choose the relevant
configurations of the two attributes
00:01:35:03 - 00:01:46:03
and put an appropriate price.
00:01:46:03 - 00:01:46:13
Okay.
00:01:46:13 - 00:01:49:15
So next up,
let's take a look at the CSV format
00:01:49:15 - 00:01:53:12
that's utilized
for this particular product.
00:01:53:12 - 00:01:56:10
Again, you can see an example of it
on the actual product itself,
00:01:56:19 - 00:01:58:27
but we'll take a look
at the actual CSV document.
00:01:59:23 - 00:02:03:05
So the CSV has been formatted
with multiple rows
00:02:03:05 - 00:02:05:17
for each attribute combination.
00:02:05:17 - 00:02:10:00
So you see, for example, that I've got a
row here which looks at a one and B one,
00:02:10:12 - 00:02:12:15
but then further down I've got another row
00:02:12:16 - 00:02:14:06
that's dealing with the same combination.
00:02:14:06 - 00:02:16:15
So A one and B one.
00:02:17:10 - 00:02:23:06
What changes between these two rows
is the quantity value,
00:02:23:06 - 00:02:25:27
which could then mean
a change in the unit price
00:02:27:06 - 00:02:28:05
once we eventually
00:02:28:05 - 00:02:32:02
activate tier pricing,
the system knows that any quantity
00:02:32:13 - 00:02:36:22
requested by the customer will sit
within one of those defined brackets.
00:02:37:05 - 00:02:40:07
So using the data in this CSV
as an example,
00:02:40:23 - 00:02:43:10
if we call a price for a one, B one,
00:02:43:28 - 00:02:46:25
if we look for a quantity of eight
00:02:46:25 - 00:02:50:08
that sits within this bracket here
because the next bracket starts ten.
00:02:50:18 - 00:02:53:12
So that means it will be £2 per unit.
00:02:54:23 - 00:02:57:14
If we're looking for a quantity of 25,
00:02:57:14 - 00:02:59:22
then it's going to be
using this particular row here
00:02:59:22 - 00:03:02:27
because the next bracket up
is a quantity of 50.
00:03:03:15 - 00:03:05:20
So that means that it's £1.60 per unit
00:03:06:23 - 00:03:08:29
and then if we're looking at a quantity
of 70
00:03:09:08 - 00:03:11:17
that's above our maximum
00:03:12:01 - 00:03:17:11
specified tier here, so we know that
it will be usable utilizing the maximum,
00:03:17:11 - 00:03:20:13
which would be this one,
which means it's £1.20
00:03:20:13 - 00:03:26:13
per unit.
00:03:26:13 - 00:03:30:01
So of course
we have to upload this CSV to our global
00:03:30:01 - 00:03:33:04
additional data area
which we've seen in previous tutorials.
00:03:33:15 - 00:03:36:14
Assuming that we've performed
that task already,
00:03:36:22 - 00:03:40:01
we actually need to configure
this capability on a product level.
00:03:40:23 - 00:03:42:29
So I'm just going to go back to
00:03:42:29 - 00:03:46:07
our product variance
settings for that particular product.
00:03:47:20 - 00:03:50:10
You can see that we've enabled
the generic pricing script
00:03:50:10 - 00:03:55:01
as we've seen in previous tutorials.
00:03:55:01 - 00:03:57:26
If I open out this configuration box
a bit,
00:03:57:27 - 00:04:00:27
you can see that there's a few lines
being utilized in there
00:04:01:05 - 00:04:07:14
in order to configure this tier pricing.
00:04:07:14 - 00:04:09:29
So as a reminder,
we only need to enter lines
00:04:09:29 - 00:04:14:04
within the pricing script
configuration box, which we wish to change
00:04:14:10 - 00:04:18:04
from the default script configuration
shown in the blue box below it.
00:04:19:01 - 00:04:22:12
So in this particular example,
a few entries are required.
00:04:22:25 - 00:04:25:26
So we need to file path entry.
00:04:25:26 - 00:04:29:20
So this needs to identify the CSV
to utilize from our global
00:04:29:20 - 00:04:32:06
additional data area.
00:04:32:06 - 00:04:34:23
We've got quantity column name.
00:04:34:23 - 00:04:40:15
So this identifies the column containing
quantity data within this CSV via
00:04:40:15 - 00:04:44:19
the column had a name, so you can see that
we've registered it as quantity
00:04:46:05 - 00:04:47:11
and that matches with
00:04:47:11 - 00:04:52:28
our CSV header.
00:04:52:28 - 00:04:55:01
We've also got use tier price.
00:04:55:05 - 00:04:56:21
Now this is simply a true
00:04:56:21 - 00:05:00:17
or false value specifying
how to utilize the data from this CSV.
00:05:01:04 - 00:05:05:07
So if we've got true specified here,
then it will use the tier
00:05:05:07 - 00:05:09:21
pricing configuration
that we've been discussing.
00:05:09:21 - 00:05:13:01
Then the final one we've got here
is just to activate the debug mode.
00:05:13:08 - 00:05:16:04
So this isn't specifically necessary
for the tier pricing.
00:05:16:11 - 00:05:19:14
This is just going to give us
some additional information when we start
00:05:19:14 - 00:05:26:19
testing this particular set up.
00:05:26:19 - 00:05:32:08
So with all that information,
input and saved, we can now click on test.
00:05:32:27 - 00:05:36:09
Now Test Mode runs
the default configuration of the product
00:05:36:15 - 00:05:41:00
within the admin area itself and provides
feedback on the data
00:05:41:00 - 00:05:44:01
that's returned from it.
00:05:44:01 - 00:05:45:18
In order to be able to utilize this,
00:05:45:18 - 00:05:49:20
you do need a default configuration
which is expected to return a price.
00:05:50:00 - 00:05:54:03
So for example, you may have to specify
pre-selected attributes, values
00:05:54:13 - 00:05:58:01
so that it actually knows
where to look in the CSV document.
00:05:59:19 - 00:06:01:20
So if I click test,
00:06:01:20 - 00:06:04:14
you see there's loads of information
that appears at the top of the screen
00:06:04:14 - 00:06:07:18
to show us how that particular script
00:06:07:18 - 00:06:09:26
is being run in that particular scenario.
00:06:11:02 - 00:06:13:23
And because we've got the debug mode
activated,
00:06:13:23 - 00:06:17:20
we get much more information
than we otherwise would.
00:06:17:20 - 00:06:21:08
Then of course, as we saw minutes
a couple of minutes ago, if we go to view
00:06:21:08 - 00:06:24:04
product page, we can actually take a look
at that in action.
00:06:24:20 - 00:06:29:10
So if I choose different configurations
of the attributes, I get a certain price.
00:06:29:24 - 00:06:32:26
Then if I start playing around
with the quantity,
00:06:32:26 - 00:06:38:10
it will pull the modified
price data from that CSV.