Before updating your Level 2 catalog, you must prepare a CSV file using the specific Level 2 Index Template. The template used is different from the Standard Catalog template (RoundtripProductsTemplate_Level_2.csv).
Note: Make sure the column headers remain unaltered (i.e., name changed, not removed or font changed).
File Format: The file must be saved as a CSV (comma delimited) file. In Excel, use Save as and select CSV (comma delimited) from the save as type drop-down list.
Image Upload: If you are uploading image files, you must create a ZIP file containing ONLY the images (referenced in the Image Name column) and the Catalog CSV file. If you do not upload images, the system will automatically display the logo set for your Supplier Store.
Index Catalog Template Fields
| Column | Field Name | Description | Mandatory |
|---|---|---|---|
| A | Code | Product item number or code (SKU). Must be a unique ID. | Y |
| B | Name | Name of Product (2000 Char limit). | Y |
| C | Description | Description of Product (2000 Char limit). | N |
| D | Indicative Price | The base price without any discounts applied. | N |
| E | Manufacturer Name | The name of the manufacturer. | N |
| F | Manufacturer Part ID | The manufacturers part number. | N |
| G | Category | Enter the relevant UNSPSC product code for the category of the product or catalog. | Y |
| H | Units | Enter the relevant Unit of Measure code (like DZN for Dozen). Defaults to "EA" (Each) if left blank. |
N |
| I | Quantity Available | Leave Blank. This field is not used for Level 2 Index Catalogs. | N |
| J | Link | Hyperlink to a specific webpage or online document (for product information). | N |
| K | Lead Time | Indicates the number of days lead time to ship the product. | N |
| L | Allow Decimal | Enter Y if the product can be bought in decimal quantities (e.g., 1.5). Default is N. | N |
| M | Image Name |
Name of image file (e.g.,
A few tips when using URLs:
|
N |
| N | Discount |
Leave Blank. This field is not used for Level 2 Index Catalogs. To have the discounted price visible to the customer, please enter the discounted price in the Price column. |
N |
| O-Y | Hazardous, CAS, Search Terms, etc. | Additional fields for product specification (see template for full list). | N |
.){kind=link}
Update an Existing Level 2 Catalog
To make changes to the product data in your Level 2 Index Catalog, you must upload a new file.
Navigate to Catalogs on the left panel
Select View Catalogs.
Click into the customer's catalog, you are updating the catalog for.
Press the More Actions button on the top right and click on Upload Catalog File.
-
Select Browse to attach the updated CSV file.
Note: If the zip file does not upload after selecting Browse and the zip file is too large. We recommend splitting the file into small files > zip all files together > and try uploading.
-
Only 1 file can be uploaded at a time and you must wait for the file to successfully attach, before proceeding forward.
If you attempt to attach multiple files, by selecting Browse. The previous file will disappear because only 1 file can be uploaded at a time.
Below is a sample of a successfully attached file, that is ready to proceed forward.
-
If the file fails (i.e. not accepted and attached), you will receive a failed message, as shown below. Please review the file and:
Confirm the file size is less than 100MB.
The file is saved as a CSV.
All fields are completed, according to the information provided in the Index Catalog Template Fields chart (above) and
The file column headers have not been altered (i.e., name changed, not removed or font changed).
-
In the drop-down under Products not in upload section, select:
Keep Them: Any products that were in the original catalog but are not present in your new upload file will remain in the catalog.
Remove them: Any products not in the upload file will be deleted from the catalog.
Select OK.
You will be routed to the Catalogs In Progress screen.
-
The uploaded file will go into Processing catalog status (i.e. Unimarket is currently uploading the catalog products, check back again later).
You can refresh your screen to view if the status has update or you can log out of your profile and return later (Note: An email notification will not be sent out, notifying when file has been uploaded and ready for review).
If an error occurs, refer to the Error Resolution section below.
If no errors occur and the Level 2 file disappears. This means the items were successfully upload.
Navigate to Catalogs on the left panel.
Select View Catalogs.
Click into the customer's catalog, you are updating the Level 2 file for.
-
Review the updated item(s) on the Draft Products tab.
Note: If you have more files to upload, select More Actions > Upload Catalog File and begin at Step 4 (above). Once all the files have been successfully uploaded, you can proceed to the next step to Publish all the items.
To publish all items, select Publish for Review.
A pop-up box will appear, to confirm publishing by selecting Publish.
Error Resolution
Note: Catalogs not completed in the Catalogs in Progress screen, will be deleted one month after being loaded. For assistance, please contact the Unimarket Support team within your profile.
If you receive an error, please:
Confirm the file size is less than 100MB.
The file is saved as a CSV.
All fields are completed, according to the information provided in the Index Catalog Template Fields chart (above)
The column headers have not been altered (i.e., name changed, not removed or font changed) AND
Follow the applicable instructions below, to resolve the error recieved.
Validation errors were found in products
Description: Information provided did not meet the file upload criteria (e.g., trademark/copyright icon included).
-
Resolution Steps: Click View to see the error(s). Manually Update the item in Unimarket and select OK.
If you prefer to make corrections on the file, Click More Actions > select Delete All Errors and Finish to delete the entire upload.
Error when processing data load
Description: The file is unreadable by Unimarket (e.g., file format is not CSV, or an incorrect header was used).
Resolution Steps: Click More Actions, select Finish, and then select Delete All Errors and Finish to delete the entire upload. Fix the file outside of Unimarket and re-upload.
Catalogue errors were found
Description: An error occurred when loading the data file.
Resolution Steps: Click More Actions > select Delete All Errors and Finish to delete the entire upload > and re-upload.
An error occurred uploading the file - please try again
Description: The file is unreadable by Unimarket (e.g., file format is not CSV, or an incorrect header was used).
Resolution Steps: Click More Actions, select Finish, and then select Delete All Errors and Finish to delete the entire upload. Fix the file outside of Unimarket and re-upload.
Results/Validation
Catalog Vetting and Approval
| Customer Setting | Action when you press Publish for Review | Notes |
|---|---|---|
| Vetting Disabled | Your changes will be immediately available to any buyers that have access to the Catalog. | |
| Vetting Enabled | Your updates will be sent to your customer for their review. Your roundtrip catalog and the previous index file will remain available during the review. | Once you select Publish, you will be unable to make further changes until the customer accepts or rejects the submission. If they decline, they will send a note via the Comments Tab. |
View the Index Catalog
To see how your index catalog looks to the customer:
Go to Catalogs -> View Catalogs.
Click on your recently updated catalog name.
Click on the Buyer View tab to see what the customer would see, if they searched for those products.
Alternatively, try searching for a product using the Search field at the top of the screen.