When creating a hosted catalog you will be required to upload a CSV file that follows our Hosted Catalog Template that includes your product details. This template follows a specific format so that the fields can be matched correctly into Unimarket. If your Catalog file has errors it will fail to load and you will be able to correct these errors in Unimarket. See the Creating a Catalog article for more information.
The Catalog Template is a CSV (Comma Separated Value) file, this a text file which can be easily edited in a spreadsheet application like Excel. The Template has a header which sorts the information into fields that display on the Products in Unimarket.
What do the fields in the catalog template mean?
|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 UNSPC product code for the category of the product or catalog.||Y|
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.
|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.
|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|
Download the template and save as a CSV file. To do this, within excel, click on Save as and select CSV (comma delimited) from the save as type drop down list.
Images must be in JPEG, JPG, PNG or GIF format to be accepted by Unimarket. This includes images hosted online. Images greater than 500x500 pixels will be resized to 500x500, images smaller than this will stay their original size.
Adding Images to a Catalog Using a Zip File
If you have image files you want to add to the catalog you need to:
- Gather your 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)
- Create a ZIP file which contains ONLY the images and the Catalog CSV file
Once you have the completed ZIP file you can upload this using the Create Catalog function and the images will be visible in Unimarket.
|Note: Once you have uploaded the catalog, your images will be hosted on Unimarket. When you Export your 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), including the image URL in the Image Name column will ensure that image appears as the product image. (i.e. https//:yourwesbite.com/imagename.jpg)
You can find a guide on Creating a Catalog on the dedicated help page.
Tips and Tricks