Managing your product catalogue

Owned by Will Mac
Last updated: Aug 01, 2023
10 min read

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.

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 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.

Fruugo File Upload Template

  • 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

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

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

 

 

Entering Attributes

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

Verifying your product data

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

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

  1. File -> Click File > Options > Advanced.

  2. Under Editing options, clear the Use system separators check box.

  3. Set Decimal separator to period (.)

  4. Set Thousands separator to comma (,)

  5. Click OK

Then:

  1. Select the data-import.csv' sheet, and go to File > Save As…

  2. Click 'File Format' and select 'Comma-separated values (.csv)'

  3. Give the file a suitable name, e.g. 'data-import.csv', and save

  4. 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.

  5. 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

 

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

  1. To do this, select the 'data-import.csv' sheet, and go to File > Save As…

  2. Click 'File Format' and select 'Comma-separated values (.csv)'

  3. Give the file a suitable name, e.g. 'data-import.csv', and save

     

     

  4. 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.

     

  5. 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).

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’

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

 

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

Updating your existing catalogue

Before you begin

Find your existing Fruugo File Upload Template which you saved as part of readying your product data for upload.

Updating product data

New Products/SKUs

New products/SKUs can be added as new lines. Fruugo will treat any new ProductID, or ProductID/SKUID combination, as a new item.

Removing a Product/SKU

All you need to do is delete the contents of the row.

You can safely re-use rows to add new products as long as they have a new ProductID, or ProductID/SKUID combination.

Updating a Product/SKU

When a product data file is uploaded, and Fruugo recognises a ProductID or ProductID/SKUID combination, we will update details for that Product/SKU.

For example, if you want to update a product description, all you need to do is change the text in Column Y (Description).

Changing the ProductID or ProductID/SKUID combination will cause the system to treat the row as a new item, and to delete the old item.

Verifying your product data

Version control and readying your product data for upload

Saving as a CSV

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

  1. To do this, select the 'data-import.csv' sheet, and go to File > Save As…

  2. Click 'File Format' and select 'Comma-separated values (.csv)'

  3. Give the file a suitable name, e.g. 'data-import.csv', and save

     

     

  4. 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.

     

  5. 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, 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).

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’

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

 

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