00:00:11:23 - 00:00:13:12
In this tutorial,
we're going to take a little bit.
00:00:13:12 - 00:00:16:17
Of a look at the Veracore product
categorization options.
00:00:18:06 - 00:00:20:25
So as part of our Veracore integration,
we allow for the.
00:00:20:25 - 00:00:24:15
Products that you sync from Veracore via
the product sync, which was covered
00:00:24:15 - 00:00:28:13
in a previous tutorial to also
be assigned to categories so that you can
00:00:28:13 - 00:00:31:28
mimic your Veracore product
hierarchy structure within Infigo.
00:00:32:13 - 00:00:35:04
Essentially assigning
all of your products that need it into.
00:00:35:04 - 00:00:38:00
Categories and subcategories.
00:00:38:00 - 00:00:40:22
As we saw
with one part of the customer import.
00:00:41:04 - 00:00:44:04
This part of the integration,
we had to use Veracore datasheet
00:00:44:04 - 00:00:46:13
exports to provide the category
information.
00:00:47:17 - 00:00:49:23
It's also recommended
that you run the product sync.
00:00:49:23 - 00:00:52:03
Prior
to completing the product categorization.
00:00:52:03 - 00:00:53:20
Steps so that you have your.
00:00:53:20 - 00:00:59:04
Required products
within Infigo before you proceed.
00:01:00:10 - 00:01:01:15
So the first step here is.
00:01:01:15 - 00:01:03:24
Actually within Vercore itself.
00:01:03:24 - 00:01:06:14
So this is the download
the offer categorization
00:01:06:14 - 00:01:09:00
data sheet from the Veracore system.
00:01:09:28 - 00:01:12:00
This can potentially be scheduled
from within.
00:01:12:00 - 00:01:12:27
Veracore to be done.
00:01:12:27 - 00:01:16:28
Automatically just ensure that
the report contains the same important.
00:01:16:28 - 00:01:21:11
Columns in the same locations
as a table that you can see here,
00:01:23:01 - 00:01:24:21
So Column A must be the offer.
00:01:24:21 - 00:01:26:18
ID and then columns P to.
00:01:26:18 - 00:01:29:25
V must be level one, level
two, etc., etc..
00:01:30:08 - 00:01:31:11
So please also make sure.
00:01:31:11 - 00:01:32:21
That the level. Columns are.
00:01:32:21 - 00:01:35:28
Blank
if no subcategories are needed to be used.
00:01:36:15 - 00:01:38:12
A hierarchy of seven categories.
00:01:38:12 - 00:01:42:20
And subcategories
can be used as a maximum.
00:01:43:27 - 00:01:44:21
You can see what we need.
00:01:44:21 - 00:01:46:28
Here is column A, which is the offer. ID.
00:01:49:04 - 00:01:51:20
And then we have
the levels of categorization, which is
00:01:51:20 - 00:01:56:01
from P to V.
00:01:57:02 - 00:01:59:02
Now, the next thing we need to do
is to place this.
00:01:59:02 - 00:02:03:12
File in a pre-agreed directory
on our local. Machine,
00:02:03:12 - 00:02:05:18
and then we're going to do some linking
with the.
00:02:05:20 - 00:02:06:13
Figo system.
00:02:06:13 - 00:02:08:02
Itself, using an area.
00:02:08:02 - 00:02:10:25
That we call upload folders.
00:02:10:25 - 00:02:11:15
So if we go into.
00:02:11:15 - 00:02:14:00
Our Infigo admin area
search upload folders,
00:02:15:29 - 00:02:22:11
then open that in a new tab.
00:02:22:11 - 00:02:24:04
All we're doing at this stage is creating.
00:02:24:04 - 00:02:28:11
A folder that we're going to link to from
a separate area within Infigo itself.
00:02:28:11 - 00:02:29:15
So there's no distinct.
00:02:29:15 - 00:02:30:16
Settings here apart
00:02:30:16 - 00:02:34:19
from some initial naming conventions
and a few of the optional bits of data.
00:02:35:21 - 00:02:40:27
If I just go to add new upload location,
I'm just going to add a few names to.
00:02:40:27 - 00:02:42:00
Do with my category sync.
00:02:43:13 - 00:02:44:03
And then make sure
00:02:44:03 - 00:02:48:06
that's active.
00:02:48:06 - 00:02:55:26
And then once that row
has been filled out, I can click insert.
00:02:55:26 - 00:02:57:10
You'll see if I can manage. That.
00:02:57:10 - 00:03:01:07
It takes me to an actual folder directory
which as we've just created,
00:03:01:07 - 00:03:11:10
this is empty at the moment.
00:03:11:10 - 00:03:12:08
With that created, I'm
00:03:12:08 - 00:03:15:17
going to go back to my configuration
settings for the Veracore plugin.
00:03:15:17 - 00:03:16:15
So this.
00:03:16:15 - 00:03:18:04
Is what we've seen a few times in.
00:03:18:04 - 00:03:19:21
Previous tutorials.
00:03:19:21 - 00:03:20:20
We just go to our.
00:03:20:20 - 00:03:22:26
Connect plugin screen and go to.
00:03:22:26 - 00:03:30:07
Configure our Veracore settings.
00:03:30:07 - 00:03:32:03
The table working for this particular.
00:03:32:03 - 00:03:37:08
Section is right at the bottom, so it's
sync product categories via datasheet.
00:03:37:08 - 00:03:41:09
And you can see there's
three available options.
00:03:44:15 - 00:03:45:17
The first thing we need to do.
00:03:45:17 - 00:03:48:10
Is to select an upload. Location name.
00:03:48:20 - 00:03:50:04
So this is just going to show.
00:03:50:04 - 00:03:54:04
Us the list of the upload folders that we
have available within our Infigo system.
00:03:54:16 - 00:03:56:23
So in this case,
we've just got a list of one
00:03:57:06 - 00:04:00:26
as that corresponds
to what we just created.
00:04:00:26 - 00:04:02:28
so this is the location where
00:04:02:28 - 00:04:07:08
the sync will look for the CSV files
with a name that matches the naming.
00:04:07:08 - 00:04:08:19
Convention
00:04:09:06 - 00:04:11:07
that's within or specified
00:04:11:07 - 00:04:14:27
within the box underneath.
00:04:14:27 - 00:04:17:07
So here we are
looking for a specific naming convention.
00:04:18:05 - 00:04:22:06
It should be files with the dot CSV file
extension only.
00:04:22:25 - 00:04:26:16
And you need to make sure that the search
string matches against the names.
00:04:26:16 - 00:04:28:20
Of the file. Exactly.
00:04:28:20 - 00:04:30:08
So this parameter can contain a.
00:04:30:08 - 00:04:31:28
Combination of.
00:04:31:28 - 00:04:34:28
Valid
literal path and wildcard. Characters.
00:04:34:28 - 00:04:37:12
So asterisk and question. Marks,
for example.
00:04:37:23 - 00:04:38:09
But it doesn't.
00:04:38:09 - 00:04:44:25
Support regular expressions.
00:04:44:25 - 00:04:47:03
So for example,
we might put something in here, such.
00:04:47:03 - 00:04:49:06
As one of our wildcards
00:04:50:24 - 00:04:53:28
category.csv
00:04:53:28 - 00:04:58:21
Then we can select all category templates
from the dropdown.
00:04:59:07 - 00:05:00:14
In my case, I'm just going to.
00:05:00:14 - 00:05:03:13
Stick to the default category layout.
00:05:03:13 - 00:05:06:29
And then just as a point of reference,
you have a CSV file format button
00:05:06:29 - 00:05:07:17
which just gives you
00:05:07:17 - 00:05:11:06
a little bit more information
as to what the different columns.
00:05:11:11 - 00:05:13:10
In that csv Sheet.
00:05:13:10 - 00:05:16:14
Can actually contain.
00:05:16:14 - 00:05:17:14
For automatic.
00:05:17:14 - 00:05:18:07
Import.
00:05:18:07 - 00:05:22:18
You do require Infigos sync,
which is covered in a different tutorial.
00:05:23:04 - 00:05:25:22
So this is a Windows application
that we provide.
00:05:26:18 - 00:05:30:00
which actually is like a live link.
00:05:30:00 - 00:05:31:29
So that will, that will.
00:05:32:04 - 00:05:34:11
Look for any. Changes to specific folders.
00:05:35:16 - 00:05:37:22
It will pick up that file.
00:05:37:22 - 00:05:39:12
And then it will be imported into your.
00:05:39:12 - 00:05:41:09
Infigo platform automatically
00:05:41:09 - 00:05:43:22
when it's dropped in the folder
that's been specified.
00:05:44:16 - 00:05:46:29
You can of course decide
just to import it manually.
00:05:46:29 - 00:05:49:16
If you want to control when this happens.
00:05:49:16 - 00:05:53:22
We'll cover manual import a bit later on.
00:05:53:22 - 00:05:55:18
So the datasheet will cover an offer.
00:05:55:18 - 00:05:59:21
ID that will link to a product
within Veracore itself.
00:06:00:16 - 00:06:01:23
It will also have a. Series of.
00:06:01:23 - 00:06:05:04
Level columns that will determine
the categories and subcategories.
00:06:05:04 - 00:06:06:13
That need to be created.
00:06:06:13 - 00:06:07:15
And the product.
00:06:07:15 - 00:06:10:13
That they need to be assigned to.
00:06:10:22 - 00:06:12:11
An offer ID can exist.
00:06:12:11 - 00:06:15:13
On multiple rows in the datasheet
if it should be assigned to
00:06:15:13 - 00:06:17:26
multiple categories.
00:06:18:05 - 00:06:19:24
The import will iterate through the.
00:06:19:24 - 00:06:21:00
CSV file.
00:06:21:00 - 00:06:22:10
And for each level it finds.
00:06:22:10 - 00:06:24:20
It will create a new category.
00:06:24:20 - 00:06:28:11
And for each category it creates will
automatically assign the correct mapping.
00:06:28:11 - 00:06:35:05
Value to ensure it's
mapped to Veracore correctly.
00:06:35:05 - 00:06:37:17
The display order of the products
is predetermined,
00:06:37:24 - 00:06:39:12
so the order in which they appear within.
00:06:39:12 - 00:06:41:23
The CSV file itself.
00:06:42:27 - 00:06:44:18
Okay then for manual syncing
00:06:44:18 - 00:06:48:03
So after you create your upload folder
and when the folder.
00:06:48:03 - 00:06:50:00
Within your Connect: Veracore.
00:06:50:00 - 00:06:51:24
Integration settings.
00:06:51:24 - 00:06:54:12
All you need to do is to simply go to that
upload folder.
00:06:54:12 - 00:06:56:16
Again and manually input.
00:06:56:16 - 00:06:59:22
The CSV file into that folder.
00:06:59:22 - 00:07:00:29
So for example, if I.
00:07:00:29 - 00:07:04:07
Go to my upload folders. Tab.
00:07:04:21 - 00:07:08:11
You'll see that I have a manage button
next to the folder that have created.
00:07:09:05 - 00:07:11:07
Which takes me. To a folder structure.
00:07:11:13 - 00:07:13:29
And gives me the ability.
To upload an additional file.