Show details for Connect: Veracore Product Categorization | CI_Veracore_003

Connect: Veracore Product Categorization | CI_Veracore_003

As part of our Veracore integration we allow for the products that you sync from Veracore via the Products sync to also be assigned to categories so that you can mimic your Veracore product hierarchy structure in Infigo - essentially assigning all your products that need it into Categories and Sub Categories.

Tutorial Video Transcript

A transcript of our tutorial video, ensuring you can find exactly what you need, when you need it.

You can search this page to find the relevant time-stamp in the video. Also, this text can be used as part of the tutorial search feature.

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.

 

Incomplete