Manual File Upload

WARNING: You must upload your entire product catalogue, every time.
The file you are uploading is considered to be the absolute source of truth. Any products/SKUs missing from the upload will be deleted from your Fruugo catalogue. After deletion, these products cannot be brought back, they must be recreated.

WARNING: After initial upload of your products, you must use your existing template file to update your catalogue. Starting from a fresh file every time increases the chances of a product/sku being missed and then removed from your Fruugo catalogue.

Click here to read about making updates to your catalogue.

1 Manual File Upload
- 1.1 Background
- 1.2 Adding your first products
  - 1.2.1 Before you begin
    - 1.2.1.1 Attribute mapping
    - 1.2.1.2 Fruugo File Upload Template
  - 1.2.2 Entering your product data for the first time
    - 1.2.2.1 Selecting a category
    - 1.2.2.2 Entering Attributes
  - 1.2.3 Verifying your product data
  - 1.2.4 Readying your product data for upload
    - 1.2.4.1 Readying your product data for upload - Windows
    - 1.2.4.2 Readying your product data for upload - MacOS
  - 1.2.5 Confirming the file has saved correctly
  - 1.2.6 Uploading your product data
- 1.3 Updating your existing catalogue
  - 1.3.1 Before you begin
  - 1.3.2 Updating product data
    - 1.3.2.1 New Products/SKUs
    - 1.3.2.2 Removing a Product/SKU
    - 1.3.2.3 Updating a Product/SKU
  - 1.3.3 Verifying your product data
  - 1.3.4 Version control and readying your product data for upload
  - 1.3.5 Saving as a CSV
  - 1.3.6 Confirming the file has saved correctly
  - 1.3.7 Uploading your product data

Background

During your application, you will have been asked to select your “Data integration platform”. If you selected “Manual file upload”, you will have an “Add Products” button in the top right of My Catalogue.

If this button is not visible, you have not selected this option, and this guide will not be applicable to you.

Adding your first products

This is for users who have not yet uploaded any product data. If you have existing product data, skip to updating your existing catalogue.

Before you begin

Attribute mapping

You can access your current attribute mapping at any time, to review, or make changes

An attribute can only be mapped to one Fruugo Attribute.

Changes to mappings will effect all products/SKUs in your catalogue

You will be asked to map any custom attributes you wish to upload to the standard Fruugo attributes.

The Attribute1, Attribute2, etc, names in the Attribute (left) column correspond to the same fields in the template file.

You can map as many of the 10 available fields as you require - including none.

Attributes are optional and may not apply to every product/SKU in your catalogue and can be left blank when appropriate - e.g. “clasp type” does not likely apply to furniture.

Fruugo File Upload Template

You can download an empty File Upload Template at any time by clicking the “Download Template” button.

We strongly recommend that you use Excel to complete the spreadsheet. Other tools are not supported and will likely cause issues.

The Fruugo File Upload Template spreadsheet contains extensive use of formulas and data validation to help ensure you provide the data in the correct format. Whilst all care has been taken to ensure that users cannot enter the wrong data, attempts to alter the structure of the document will cause problems when uploading your product catalogue in to Fruugo.
Mandatory fields are highlighted in Blue.
We recommend that you fill in every column for each product.
If adding many records, the spreadsheet may run slowly when data validation is in progress. Please be patient.
Review the full Fruugo category tree by viewing the 'Fruugo Categories - Read Only' sheet.
Familiarise yourself with the layout of the template file before entering any data.

Entering your product data for the first time

If you are looking to update your existing catalogue - click here.

Save this file frequently to avoid data loss

Use sheet 'Enter Data Here' to enter your product data. We recommend entering 'ProductId' (Column A) and 'SkuId' (Column B) first. These should be unique, or a unique combination, for each product/SKU.

Selecting a category

Fruugo Categories are a tree structure, with branches (the intermediary sub-categories) and leaves (the final sub-category). Only leaf nodes are valid categories. You can see all possible Fruugo Categories on the 'Fruugo Categories - Read Only' sheet.

When selecting a category, select each level in turn, starting with the 'Master Category' (Column F). Once selected, the options in 'Sub-category level 2' (Column G) will update accordingly. Continue selecting options until 'Valid category?' (Column M) reads VALID and is highlighted green, see below.

If a category selection is invalid, Column M will read INVALID and highlighted in red

Column M will show “INVALID” in two scenarios

You have not selected all required sub-categories. This is shown in the example above when the final leaf node has not been selected, e.g. where Column I is missing “Bird Cage Bird Baths” from Row 2.
If you have changed a higher level sub-category without clearing the choices at the lower levels. E.g. If you change the Master Category, you must clear, and then reselect, all other sub-categories for that product.

If you are entering multiple products or SKUs in to the same category, you can copy and paste the selections between rows.

Entering Attributes

Data entered in to Columns AB to AK (Attribute1, Attribute2, …, Attribute10) should match the attribute mapping you have previously set up.

Remember, attributes are optional and may not apply to every product/SKU in your catalogue and can be left blank when appropriate - e.g. “clasp type” does not likely apply to furniture.

You can access your current attribute mapping at any time, to review, or make changes

An attribute can only be mapped to one Fruugo Attribute.

Changes to mappings will effect all products/SKUs in your catalogue

Verifying your product data

Once you have entered all your products/SKUs, please review your data and ensure it is accurate to the best of your knowledge

Ensure that all mandatory fields have been completed. Mandatory fields are highlighted in blue. Any product/SKU with missing mandatory fields will not be available for sale.

Ensure that all categories are valid - review Column M. Any product/SKU with an invalid category will not be available for sale.

When you are happy that all products/SKUs have valid categories and all mandatory data has been supplied, please proceed to the next step.

Readying your product data for upload

For Windows, click here to jump to readying your product data for upload - Windows, or see immediately below

For Mac, click here to jump to readying your product data for upload - MacOS

Readying your product data for upload - Windows

We strongly recommend you save a backup copy of the Fruugo File Upload Template file before you proceed. You will need the .xlsx files to update your catalogue in the future.

To upload your product data, you need to save the 'data-import.csv' sheet as a separate CSV file.

File -> Click File > Options > Advanced.
Under Editing options, clear the Use system separators check box.
Set Decimal separator to period (.)
Set Thousands separator to comma (,)
Click OK

Then:

Select the data-import.csv' sheet, and go to File > Save As…
Click 'File Format' and select 'Comma-separated values (.csv)'
Give the file a suitable name, e.g. 'data-import.csv', and save
You will get a warning that the file format does not support multiple sheets, that only the active sheet will be saved, and some functionality will be lost. This is expected and can ignored. Click OK to proceed.
Check file has been saved to the location chosen, and then close Excel.

Now, confirm that your file has saved correctly.

Readying your product data for upload - MacOS

We strongly recommend you save a backup copy of the Fruugo File Upload Template file before you proceed. You will need the .xlsx files to update your catalogue in the future.

To upload your product data, you need to save the 'data-import.csv' sheet as a separate CSV file.

To do this, select the 'data-import.csv' sheet, and go to File > Save As…
Click 'File Format' and select 'Comma-separated values (.csv)'
Give the file a suitable name, e.g. 'data-import.csv', and save
You will get a warning (see below) that the file format does not support multiple sheets, that only the active sheet will be saved, and some functionality will be lost. This is expected. Click OK to proceed.
Check file has been saved to the location chosen, and then close Excel.

Confirming the file has saved correctly

Open the .csv file in a text editor - e.g. Notepad or TextEdit. The first line should look like this

ProductId,SkuId,EAN,ISBN,Brand,Category,Imageurl1,Imageurl2,Imageurl3,Imageurl4,Imageurl5,StockStatus,StockQuantity,LeadTime,PackageWeight,Language,Title,Description,AttributeColor,AttributeSize,Attribute1,Attribute2,Attribute3,Attribute4,Attribute5,Attribute6,Attribute7,Attribute8,Attribute9,Attribute10,Currency,NormalPriceWithoutVAT,VATRate

If it does not - e.g. it contains semi-colons (;) - close the text editor, reopen this file in Excel, and follow the instructions above exactly, remembering to select the 'data-import.csv' sheet (step 1) before saving (step 2).

If you see:
Master Category, Sub-category level 2, Sub-category level 3, Sub-category level 4, Sub-category level 5, Sub-category level 6, Sub-category level 7, Valid category?
in the CSV file, you have saved the “Enter Data Here” sheet, instead of the “data-import.csv” sheet.

Uploading your product data

Log in to the Fruugo retailer portal - https://retailer.fruugo.com
Go to 'My Catalogue'
Click 'Add Products'
Review your Attribute mapping is correct, and click ‘Next’

If you make changes to the attribute mapping, ensure that these changes are reflected in the file you are about to upload.

Click ‘Upload Template’ button, and select the file you wish to upload

When choosing a file to upload, you must upload the .csv file you created in the previous steps

WARNING: You must upload your entire product catalogue, every time.
The file you are uploading is considered to be the absolute source of truth. Any products/SKUs missing from the upload will be deleted from your Fruugo catalogue.

If the upload is successful, you will see this screen. If see an error appear in the bottom right, please go back and follow the steps for confirming the file has saved correctly.

Click “Back to My Catalogue” in the top left, and your products will soon appear in My Catalogue.

Congratulations! You’ve successfully uploaded your product data catalogue to Fruugo!

Updating your existing catalogue

This section is for users who already have product data. If you have not yet uploaded any product data, please jump back to Adding your first products.

WARNING: You must upload your entire product catalogue, every time.
The file you are uploading is considered to be the absolute source of truth. Any products/SKUs missing from the upload will be deleted from your Fruugo catalogue.