When creating a Standard (Hosted) Catalog, suppliers must upload a CSV (Comma Separated Value) file that adheres to the Unimarket Hosted Catalog Template. This template is specifically formatted, to ensure product details are correctly mapped into Unimarket fields.
Template Requirements
File Format: The file must be saved as a CSV (Comma Separated Value) file. In applications like Excel, use the Save as function and select CSV (comma delimited) from the file type dropdown.
Headers: The column headers must remain unaltered (not removed or changed), to ensure the file loads correctly.
Errors: If your catalog file generates an error during upload. The file will fail to load, and you must correct the error(s) in Unimarket. Refer to the help article Creating/Uploading a Standard (Hosted) Catalog for troubleshooting.
Template Field Descriptions
The following chart outlines the purpose, constraints, and mandatory status of each column in the catalog template:
| 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 Character 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 manufacturer's part number. | N |
| G | Form | Enter the name of the form you want to link to the product (e.g., for size or color options). For more information, 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). 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. Only use this field if you have a limited number of items. If left blank, quantity is unlimited. If the quantity is 0, customers will not be able to order the product. Tip: This column limits the amount a customer can order for the lifetime of your catalog. | N |
| K | Link | Hyperlink to a specific webpage or online document that provides critical product information. | 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), enter Y. The default is N. | N |
| N | Image Name | Name of the image file to be provided in a ZIP file (e.g., picture.jpg), or a URL for the image (e.g., http://www.yourwebsite.com/imagename.jpg). |
N |
| O | Discount | A percentage discount off the list price. | N |
| P | Hazardous Class | GHS classification of hazards (divided into class 1-9, with optional divisions like 1.1 or 1.2). | N |
| Q | Hazardous UN Number | Four-digit UN number (United Nations number) that identifies hazardous materials. | N |
| R | Safety Data Sheet | A link to the Safety Data Sheet (SDS) which the user can click to view. | N |
| S | CAS Number |
CAS Registry Number (unique numerical identifier). Format: XXXXXXX-YY-Z. |
N |
| T | Search Terms | Other terms that assist in the search for the item. These should be comma separated. Tip: Product Code, Name, and Description are all searchable fields. | N |
| U | Pack Quantity | The quantity in one pack. 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 certified. | N |
| Z | Recyclable | Indicates if the item can be recycled. | N |
| AA | Taxable | Indicates if the item has tax applied. | N |
Adding Images to Your Catalog
Images must be in JPEG, JPG, PNG, or GIF format. Images larger than 500x500 pixels will be resized; smaller images will remain in their original size.
Method 1: Using a ZIP File
Gather all images and ensure they are in the correct format.
Reference the exact file name of the image in the Image Name column (e.g.,
imagename.jpg).Create a ZIP file that contains ONLY the images and the Catalog CSV file.
Upload the ZIP file using the Create Catalog function.
Note: You can only use one image method at a time. Image names cannot contain spaces (e.g., use yourimagename.jpg, not your image name.jpg). Once uploaded, the images are hosted on Unimarket. When you export products later, you will see a URL in the Image Name column.
Method 2: Using a URL
If the images are already hosted online (e.g., on an online store), insert the full image URL in the Image Name column to ensure the image appears as the product image (e.g.,
https//:yourwesbite.com/imagename.jpg).
What's Next/Related
Creating Catalog Forms (For linking products to forms)
You can also watch a short video on this process: