Below we review:
- Step-by-step how to fill in a PRICAT and which columns must contain which information
- How you can save your file in .csv semicolon separated format
Review of pricat
- A Pricat file is an Excel file that collects all relevant master data found on the goods you would like to sell in Magasin.
Correct completion of a PRICAT based on columns:
Dessin: Here you must enter the products design/item number/article number. The field is handled in different ways depending on the type of goods to be created. This can be divided into 2 categories:
• Clothing - Dessin shall be specified here, without size or color. Therefore, the same dessin may well appear on a large number of products, as long as the size and color are indicated in a later column.
• Housing/cosmetics/other - The product's article number must be stated here. Article number cannot be identical on 2 different items.
Product name: The name of the product shall be entered here. If the item is to be sold online, it will be indicated here displayed on the online site. Brand name must not be entered in the field, this is created by the magazine.
Barcode: Enter the barcode for the individual goods here.
Size name: NOTE only applies to clothing - Enter the size name here, e.g. XL. If it is about shoes, these must always be specified in EU sizes, e.g. 39.
Size ID: NOTE only applies to clothing - Enter the Size ID for the item here. eg XL. If it is about shoes, these must always be specified in EU sizes, e.g. 39. Must a different Size ID be used to order the item. So please contact Supply Chain regarding this.
Color name: NOTE only applies to clothing - The name of the item must be entered here - this could for example be "Black", "Navy" or the like. It is important that the color is specified with a name here, and not a number. The color name will be displayed online, therefore it must be specified as the name.
Color ID: NOTE only applies to clothing - The color ID must be entered here, in number-based format - This can be, for example, "001" or "560" - This is used to link with Dessin in Magasin's system. So that the goods are formed correctly with different colors. If using a non-number-based color specification, the same can be specified here as has been specified in the "Color name" column
Hierarchy1 - The brand name of the product shall be entered here - This is used to determine which brand name the product will be given in the magasin's system.
Hierarchy2 - Gender must be indicated here - in other words, is the item a men's, women's or unisex.
Hierarchy3 - Here you must state which product type/category it is. Are we talking about trousers, T-shirts or coffee tables? - The more precise the information, the better the goods can be presented. The product type is also used for tracking bags etc. therefore, a correct statement is better for the sale of your goods.
Purchase price: - A purchase price of the goods must always be stated here ex VAT. If the goods are to be sold as consignment goods, it is not a requirement for the sale of goods to fill in this.
Sales Price DKK: - The current selling price in DKK must be entered here, incl. VAT.
RetailPriceNO: - The current selling price in NOK must be entered here incl. VAT.
RetailPriceSEK: - The current selling price in SEK must be entered here incl. VAT.
Season: - The season for the product shall be stated here. Is it a seasonal item or a NOOS. If it is a NOOS item - then this can be specified as "Stabel". Is the item seasonal, such as AW or SS. Then this shall be specified as SS or AW as well as the current year. 23 or similar.
Materiale - The type of material the product mostly consists of shall be stated here. This could be, for example, "70% Cotton".
Materiale2 - This field must be used if the item contains more than 1 type of material. The field is filled in with the 2nd part of the material composition eg "10% polyester".
Materiale3 - This field is used if the item contains more than 2 types of materials. The field is filled with the 3rd part of the material composition, e.g. "5% Elastane".
Materiale4 - This field is used if the item contains more than 3 types of material. The field is filled with the 4th part of the material composition, Ex. "5% Wool".
long Description DK - The long description of the item, which is used for the online site, must be entered here. It is important that the text is adequate. The better the text, the better the sales can be. The text inserted here must always be in Danish. If the text is not available in Danish, we recommend this as a translator. Or you must enter an English text in the next column.
Long description UK - The Long description in English shall be entered here. If no other texts are available, our site will always choose the English text.
There must be no line breaks in the long descriptions. If you require this, you should use the HTML code <br>.
Long description SE - Enter here the long description in Swedish, if this is not available, the field can be left blank.
There must be no line breaks in the long descriptions. If you require this, you should use the HTML code <br>.
Long description NO - Enter here the long description in Norwegian, if this is not available, the field can be left blank.
There must be no line breaks in the long descriptions. If you require this, you should use the HTML code <br>.
Billedreference/2/3/4/5/6/7 - The name of the images sent to the products shall be entered here. That is, if the image is named "1234567.jpg" Then you must write in this field. 1234567 - First field "Billedreference" is the first image displayed online - 2/3/4/5/6/7 are the next ones in the numerical order counting up. We always recommend that you christen the images as the barcode on the item. If it is clothing, then you only have to baptize based on one size and not all of them. You choose which one. Sending pictures via URL links - Then you must replace the "Image reference" name in the column header to be "Imageurl1" 2/3/4/5/6/7. The link is simply inserted into the field.
WSmachinewash - To be entered only if it is relevant for customers to know. It is indicated here whether the item can withstand machine washing - please indicate with washing instructions.
WSTumbling - Only filled in if it is relevant for customers to know. Write here whether the item can withstand being put in the tumble dryer, preferably at maximum degrees.
WSDryClean - To be entered only if it is relevant for customers to know. State here whether the item can withstand being cleaned.
Tariff Code - The correct tariff/item code for the item shall be filled in here, used when the items are sold abroad. These are also called “intrastat codes”. It is important that these are correct and specific to the goods. The complete overview of valid 8-digit item codes can be found via this link: Item codes on DST
Country of origin (Oprindelsesland) - The country in which the goods were produced must be stated - This must always be stated as 2 letters. If it is, for example, Denmark, then this must be entered as "DK"
Before uploading - Make sure you send this in CSV Semi colon format. Otherwise, the file will not be loaded. Remember to format all numbers indicated with "E+12" in the add code to numbers, and remove zeros after the comma. This car typically only has a barcode and a product code in the file.
Do you experience challenges with saving your file in CSV semicolon separated and can only select comma delimited see attached guide.
Depending on agreed upload access, PRICAT must either be sent to Sortiment@Magasin.dk in an email in CSV format or uploaded via FTP server (see guide below).
Submitting Pricat FTP Windows:
Enter in the path: FTP.magasin.dk - You will now be presented with a new login window.
Here you simply log in with your login details - NOTE these are given after a complete onboarding. If you are a new partner, the pricat must be sent to you as previously stated.
Pricats must be in the "Items" folder
Pricat is now uploaded. You will receive an email when the file is uploaded correctly in our system - It usually takes a maximum of 2 hours.
Submitting Pricats FTP Mac:
Download the program: Filezilla here: https://filezilla-project.org/download.php?platform=osx
The program is free and does not harm your computer.
Once you have downloaded this, you must write the following:
Host: FTP.magasin.dk
Username: Enter your provided username here
Password: Enter your provided password here.
Gate: 21
You can then drag your files into the correct folder. Use the "Items" folder for submitting Pricats.
If you are a new partner, the pricat must be sent to you as previously stated.
Pricat is now uploaded. You will receive an email when the file is uploaded correctly in our system - It usually takes a maximum of 2 hours.
Glossary:
Master data - Is an expression of master data, which can span all information relating to products to be sold. It can be prices, dimensions, colors, images and the like.