Skip to content

Quick Bite: Uploading a Range List to Match Local Codes to Products

Erudus is a powerful data platform with a range of business-improving tools and solutions, and though we’ve made it as user-friendly as possible, we know it’s important to have a resource for our customers to get answers to their questions and learn how to use Erudus to it’s full advantage. Enter Knowledge Base, the user manual in which you can learn everything you’ll conceivably ever need to know about using Erudus.


And we’re here to show you the sort of information you can find on there, and help you get to grips with everything Erudus.

So far we’ve covered:

This time we're turning our attention to “Uploading a Range List to Match Local Codes to Products”.

This article shows you how to upload your product or range list with local codes to automatically add local codes to multiple products at once. In order to do this, you MUST have the TRADE GTIN/BARCODE and LOCAL CODE on a range or product list.

Step 1 - Access Your Member Dashboard

Click the Member Dashboard button from the user dashboard.

Step 2 - Access Your Product List

From your Member Dashboard, you can click on the "Products" button to display any local codes you have added to products in the Erudus database.

Step 3 - Upload a CSV file

To access the matching tool to upload your local codes click the link titled 'upload a CSV file' highlighted below.

Step 4 - CSV file layout

This is the screen where you will upload your file to do the code matching, you need to do is ensure that the file you are about to upload is in the correct format and is arranged in the correct way.

The format and arrangement are detailed below.

Step 5 - Your product list

Below is an example of a product list, the only data you need on this in order to match local codes is the trade-unit (or outer) GTIN/barcode and the local code.

These two columns are shown below, the others need to be deleted before saving the file as this data is not needed.

Step 6 - Save file as .csv

The next step is to save the file as a CSV file.

To do this click 'file' and 'save as' you then need to ensure that the file format is selected as CSV (shown below) and save the file in the desired location ready for upload.

Step 7 - Upload your file

Upload the file using the 'choose file' button and select the CSV file you saved in Step 6.

Once this is selected click the upload button.

Step 8 - Results of product matching

Your screen will now display any local codes which it managed to match as well as any it didn't.

Depending on which barcode or GTIN has been attached to the product it sometimes can have trouble matching up. Matching can also fail if the product in question isn't listed on Erudus. We are working to reduce this gap in products and you can help by emailing your product or range list to support@erudus.com.

In the below screenshot you can see the messages displayed.

Step 9 - Viewing matched local codes

By moving back to the products screen you can now see any codes which have been matched.

The local codes are displayed on the right-hand side of the screen as shown below.

See the Knowledge Base page on “Uploading a Range List to Match Local Codes to Products” here.

Explore Knowledge Base here.

You may also be interested in…

You should know... Erudus offers video tutorials
You should know... Erudus offers video tutorials

You may also be interested in…

Quick Bite: Creating a Product Visibility Report

Read

You may also be interested in…

Blue Erudus tips and tricks lightbulb icon in the middle of a  dark blue background with light blue fingerprint pattern
Blue Erudus tips and tricks lightbulb icon in the middle of a  dark blue background with light blue fingerprint pattern

You may also be interested in…

Quick Bite: Updating your Supplier profile details

Read