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

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
Step by Step Guide

Connect: Veracore Product Categorization

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.

As with the Customer Import, for this part of the integration we had to use Veracore's datasheet exports to provide the category information.

Run the product sync prior to completing the product categorization steps.

Creation Date: Feb 28, 2023
Created By: Sam Webster

1. Download the Offer Categorization datasheet from Veracore

This can potentially be scheduled from within Veracore to be done automatically. Just ensure that the report contains the same important columns in the same locations as the table shown below*. 

*Row 1 - Column A must be Offer ID and Columns P - Q must be Level 1, Level 2, etc. Please also make sure the level columns are blank if no subcategories are being used.

A hierarchy of 7 categories and subcategories can be used.

2. Place the file into a pre-agreed directory on local machine.

3. Click on Upload Folders

Click on Upload Folders

4. Click on Add New Upload Location

Click on Add New Upload Location

5. Click on Insert

Click on Insert

6. Type "conn"

Type "conn"

7. Click on Connect Plugins

Click on Connect Plugins

8. Click on Configure

Click on Configure

9. Click on Sync Product Categories via Data sheet

Click on Sync Product Categories via Data sheet

10. Select an Upload Location

Upload location where sync will look for CSV files with name that matches below naming convention

Select an Upload Location

11. Type a naming convention, such as "*_category.csv"

File naming convention (should be files with .csv file extension only).
The search string to match against the names of files.
This parameter can contain a combination of valid literal path and wildcard (* and ?) characters, but it doesn't support regular expressions.
File is renamed to Synced___[FILENAME]___[Timestamp].[FileExtension] after sync.

Type a naming convention, such as "*_category.csv"

12. Select Default from Default Category Template:

Select Default from Default Category Template:

13. Automatic import

  • Our windows application, Infigo Sync, will then pick up that file and import it into your Infigo platform automatically. You can of course decide just to import it manually if you wanted to control when this happens (manual import will be covered later).

  • The datasheet will contain an Offer ID that will link to a product in Veracore. It will also have a series of 'Levels' column that will determine the categories and sub-categories that need to be created and the product to be assigned to.

  • An  Offer ID can exist on multiple rows in the datasheet if it should be assigned to multiple categories.

  • The import will iterate through the CSV file and for each Level it finds it will create a new category. And for each category it creates we will automatically assign the correct mapping value to ensure it is mapped to Veracore correctly.

  • The display order of the products is predetermined to the order in which they appear on the CSV file. 

Automatic import

14. Manual syncing

After you create your Upload Folder and link the folder in Connect: Veracore - simply go to the Upload Folder, and upload your CSV file. Attached to this article is a sample CSV. 

15. Click on Upload Folders

Click on Upload Folders

16. Click on Manage

Click on Manage

17. Click on Upload

Click on Upload

18. Sample CSV template

Sample CSV template
Alternate Search Terms