When creating a hosted catalog, suppliers are required to upload a CSV file following our Hosted Catalog Template, that includes product details. The template is specifically formatted to match fields correctly into Unimarket.
If your catalog file generates an error, the file will fail to load and the supplier must correct the error(s) in Unimarket. Refer to help article Creating a Catalog, for additional information.
The Template
The catalog template is a CSV (Comma Separated Value) file, which is a text file that can be easily edited in a spreadsheet application like Excel. The template has a header that sorts the information into fields, associated with the product in Unimarket.
Once the template is downloaded, use the chart below to complete the catalog required columns and > Save the update file as a CSV file. To do this in Excel, click on Save as > Select CSV (comma delimited) from the save as type drop down list.
What do the fields in the catalog template mean?
| Column | Field Name | Description | Mandatory |
| A | Code | Product item number or code (SKU). This must be a unique ID. | Y |
| B | Name | Name of Product (2000 Char limit). | Y |
| C | Description | Description of Product (you may also wish to enter the quantity, e.g. "Box of 12"). | N |
| D | List Price | Price of the item before any discounts. Can be a dollar amount (with no commas) or set as RFQ (Request for Quote) | Y |
| E | Manufacturer Name | The name of the manufacturer. | N |
| F | Manufacturer Part ID | The manufacturers part number. | N |
| G | Form | Enter the form you want to link to the product. For more information on Forms, please refer to Creating Catalog Forms. | N |
| H | Category | Enter the relevant UNSPSC product code for the category of the product or catalog. | Y |
| I | Units |
Enter the relevant Unit of Measure code (like DZN for Dozen etc.). If left blank, the product will default to "EA" for Each). See the Unimarket Units of Measure article for more examples. |
N |
| J | Quantity Available | This field is used for the quantity in stock. This should only be used if you have a limited number of items in stock. If the Quantity available is 0 customers will not be able to Order this product. If you do not wish to enter a quantity please leave the field blank. | N |
| K | Link | Hyperlink to a specific webpage or online document that provides critical product information, not already listed in the Description. | N |
| L | Lead Time | Indicates the number of days lead time to ship the product. | N |
| M | Allow Decimal | If the product can be purchased in decimal quantities (like 1.5 pounds of ground meat) then enter Y. The default is N. | N |
| N | Image Name | Name of image to be provided in zip file (add image extension to name i.e. picture.jpg), or URL for the image, i.e. http://www.yourwebsite.com/imagename.jpg Images can be PNG, JPG or GIF format. |
N |
| O | Discount | A percentage discount off the list price. | N |
| P | Hazardous Class | GHS classification of hazards is divided into class. 1- 9. They can also have divisions. 1.1, 1.2 (Class.Division) | N |
| Q | Hazardous UN Number | UN number (United Nations numbers) are four-digit numbers that identify hazardous materials, different to UNSPSC Code | N |
| R | Safety Data Sheet | A link to the Safety Data Sheet which can be displayed so that the user can click to view the SDS | N |
| S | CAS Number | CAS Registry Number - also referred to as CASRN or CAS Number, is a unique numerical identifier assigned by the Chemical Abstracts Service (CAS). Format: XXXXXXX-YY-Z. For More Information On CAS Registry Numbers | N |
| T | Search Terms | Other terms that suppliers can add that assist in the search for item. Comma separated. | N |
| U | Pack Quantity | Pack Quantity is the quantity in one pack. (This must be entered as a number). | N |
| V | Controlled | Flag that indicates if the item is restricted or controlled. | N |
| W | Green | Indicates if the item is green. | N |
| X | Indigenous | Indicates if the item is indigenous. | N |
| Y | Energy Star | Indicates if the item is Energy Star. | N |
| Z | Recyclable | Indicates if the item can be recycled. | N |
| AA | Taxable | Indicates if the item has tax applied. | N |
Images
Images must be in JPEG, JPG, PNG or GIF format to be accepted by Unimarket, including images hosted online. Images greater than 500x500 pixels will be resized to 500x500 and smaller pixel image sizes, will remain in their original size.
Adding Images to a Catalog Using a Zip File
If you have image files you desire to add to the catalog, please:
- Gather the images and confirm they are in JPEG, JPG, PNG or GIF format. Reference the file name of the image in the Image Name column of catalog file (i.e imagename.jpg) and
- Create a ZIP file that contains ONLY the images and the Catalog CSV file
Once completed, upload the zip file using the Create Catalog function and the images will be visible in Unimarket.
| Note: Once the catalog is uploaded, the images will be hosted on Unimarket. When Exporting the Active Products, you will see a URL in the Image Name column. So you won't need to upload them if you make any other changes. |
Adding Images to a Catalog Using a URL
If the images you wish to include in your catalog are available online (e.g. on an online store), insert the image URL in the Image Name column. To ensure the image appears as the product image. (i.e. https//:yourwesbite.com/imagename.jpg).
Watch this short video on the steps to add Images to your Catalog items
Tips and Tricks
|
Upload Catalog
To upload the catalog, refer to help article Creating a Catalog for instructions.