What is a product list?
A product list is an Excel sheet that a user can complete. This Excel sheet can then be imported into the system by PromoCat. In this way, many products can be loaded at once and you always have a backup of these products.
Conditions
Before you fill in the product list, there are a number of conditions you must meet. These are requirements imposed by our system. If you do not comply with these conditions, we will not be able to import the product list.
- Always adhere to our format (Download format). Do not remove any columns that are included in the standard format. These are required columns.
- Do not add columns that are not in the format or not specified in this documentation. Custom names cannot be imported.
- The image names in the list must exactly match the file names. For example, if you have "bidon-blauw.jpg", it must appear exactly like that in the list.
- There must always be an image specified in the "Image 1" column. Without an image, the list cannot be imported. We only support JPG or PNG file types.
- Product images should be 600 x 600 pixels, which is the ideal resolution. If this is not the case (for example, if the image is wider than it is tall), the image will be automatically scaled to 600 x 600 pixels and any empty space will be filled with a white background.
- There must always be a price specified for each product (which tier it applies to does not matter). This can be an amount, "on request", or "free".
- All columns have a limit of 1024 characters. Only the "Product description" column has a limit of 65,536 characters.
- The file must always be saved with the UTF-8 character set and ";" as the delimiter. We only import UTF-8. If not, you may see characters like "�". It is recommended to save as a .CSV file (More information: Doc. save as .CSV (UTF-8))
- Every row you create in the list must have a unique variant code. Make it as unique as possible.
You can do this, for example, with your company name (Example: "PC1000-1, PC1000-2, etc."), where PC stands for PromoCat. A variant code may only occur once per supplier, even if you use multiple product lists (multiple assortments). - It is forbidden to use a "/" in the following columns: Product code, Product name, Variant code, Variant name, Image, and Price. This character is a delimiter, and we will not be able to import the list in this case. It is allowed in other columns.
- When applying updates, we only accept delta (new) images. Existing images do not need to be re-uploaded.
How does it work?
Download the product list (Download here).
Then open the product list in Excel or another program that can handle it (e.g., LibreOffice).
All specifications shown here are required specifications. They must always be completed and remain unchanged.
Then fill in the product list and save it with the UTF-8 character set. Preferably save as a .CSV file type and separate with ";" (Doc. save as .CSV (UTF-8)).
You can also add product categories to your product list. You can do this up to a maximum of 4 category levels.
Important
It is not possible to add products to the standard PromoCat categories. You can only assign products to your own customer categories or create new categories. This is case-sensitive. A difference of a single letter will create a new category.
These categories will then be included during import (on request), and the products will be placed in your webshop under the category specified in the list. You can choose from the following entries:
Name (Add to product list) | Value | Explanation |
---|---|---|
Sub-sub-subcategory | Text | The underlying category of the 'Sub-sub-category' above. |
Main category | Text | The category without any parent categories. |
Subcategory | Text | The category under the 'Main category' above. |
Sub-subcategory | Text | The category under the 'Subcategory' above. |
You can also add extra images to a product. You do this by creating a column next to "Image 1", for example "Image 2". You can continue doing this up to a maximum of 10 images.
The main image of a variant is always the most unique image within the product set (based on the file name). If within the same product set (grouping of multiple variants) you have the same image for all variants as "Image 1", and "Image 2" is unique for each variant, then the image from the "Image 2" column will become the main image.
However, if the image is unique across all image columns, then "Image 1" remains the main image.
Examples:
Name (Add to product list) | Value | Explanation |
---|---|---|
Image 4 | .png, .jpg | The fourth image in the product list |
Image ... (Max 7) | .png, .jpg | The ...th image in the product list |
Image 1 | .png, .jpg | The first image in the product list |
Image 2 | .png, .jpg | The second image in the product list |
Image 3 | .png, .jpg | The third image in the product list |
Important
It is important during import that the file name exactly matches the Excel entry. The system is case-sensitive when importing images. If you have "Afbeelding1.png", there must not be "afbeelding1.png" with lowercase letters in the list.
In the product list, you can specify multiple product tiers. By default, "Price > 1" is displayed, where 1 in this case represents both the tier and the quantity.
If you want more tiers for a single product, you can create new columns, for example "Price > 10"; in this case, 10 represents a tier of 10.
If you leave "Price > 1" empty and only fill in "Price > 10", the minimum order quantity will be 10. If you fill in both, the product will have a tier of 1 and a tier of 10.
Examples:
Name (Add to product list) | Value | Explanation |
---|---|---|
Price > 1 | Numbers | The tier starting at 1 piece, where 1 also equals the minimum order quantity. |
Price > 50 | Numbers | The tier of 50 pieces. If this is the lowest tier you enter, it will also be the minimum order quantity. |
Price > ... | Numbers | Choose a tier yourself. |
It is also possible to add VAT to a product. You can do this by creating a new column named "BTW". Under the "BTW" column, enter the percentage of VAT that should be applied.
Example:
Name (Add to product list) | Value | Explanation |
---|---|---|
BTW | Numbers, digits, text | Specify which VAT percentage applies. |
There are multiple VAT percentages. You can find an overview of VAT percentages below.
Percentage (value) | Value | Explanation |
---|---|---|
high | Text | Indicates a high VAT percentage of 21%. |
low | Text | Indicates a low VAT percentage of 9%. |
0 | Number | Indicates that no VAT should be applied. A percentage of 0% will be used. |
EAN codes are used for Google ShoppingFeed. If you use this and want to add these products to your webshop, you are required to add "EAN code" to your product list. If you do not, your ShoppingFeed will be rejected by Google.
Name (Add to product list) | Value | Explanation |
---|---|---|
EAN code | Numbers, digits | This is a unique numeric combination that identifies a product based on a European system. |
Are you looking for more specifications to distinguish your variants? For example by color, finish, weight, content, etc.? You can use the specifications below.
You can add these specifications in a new column after "Variant name" and before "Image 1". Do this by right-clicking on a column and selecting "Insert". Then enter the desired specification in that column.
Note: You must fill in attributes for each variant of your product set. If you have multiple variants, you must fill them in as well.
Detailed specifications:
Name (Add to product list) | Value | Explanation |
---|---|---|
Version | Text, numbers, digits | Distinguish between variants within your product by adding a version (type, finish). For example, "With print", "Without print". By adding this attribute, customers will get a dropdown choice in the webshop. |
Weight | Text, numbers, digits | Specify the weight of your product. |
Dimensions | Text, numbers, digits | Add dimensions to your product. This can be done in various ways, such as "20x20 cm", "20x100x50 cm", etc. |
Length | Text, numbers, digits | Specify the length of your product. |
Width | Text, numbers, digits | Specify the width of your product. |
Height | Text, numbers, digits | Specify the height of your product. |
Diameter | Text, numbers, digits | Specify the diameter of your product. |
Volume | Text, numbers, digits | Show the volume (size, content, capacity) of a product. For example, "10 liters". |
Material | Text, numbers, digits | Specify what the product is made of. This can be a list of multiple items. |
Content | Text, numbers, digits | Specify what the product contains. For example, "2 apples and a kiwi". |
Packaging | Text, numbers, digits | Specify what the product's packaging is. For example, "Crate", "Cardboard", "Plastic", etc. |
Filling | Text, numbers, digits | Specify what is inside the product. For example, "Praline", "Chocolate", "Down", "Feathers", etc. |
Charge | Text, numbers, digits | Specify the product's electric charge. For example, "2400 mAh". |
Power | Text, numbers, digits | Specify the power (wattage, voltage) of the product. For example, "50 Watt". |
Ampere | Text, numbers, digits | Specify the amperage of the product. For example, "16A". |
Capacity | Numbers, digits | Distinguish variants within your product set by adding capacity (size). For example, "32GB", "10GB", "5 Liter", "8 Liter". This attribute will give customers a dropdown choice in the webshop. |
Pressure (atmosphere) | Text, numbers, digits | Specify how much pressure (tension) the product has. For example, "2 bar". |
Ink color | Text, numbers, digits | Specify the ink color of the product. For example, "Blue". |
Supplier | Text, numbers, digits | Specify the supplier of this product (Displayed to customers). |
Printing information | Text, numbers, digits | Provide additional printing information about the product. For example, "Printing on request". |
Country of origin | Text, numbers, digits | Specify where the product comes from. For example, "China", "Dubai", "Netherlands", etc. |
Sustainable | Yes, No | Is the product sustainable "Yes" or "No". |
Hazardous | Yes, No | Is the product hazardous "Yes" or "No". |
Product description | Text, numbers, digits, HTML | Add a product description to your product. You may use HTML, for example to denote bold text in the webshop. |
Color | Text | Distinguish variants within your product set by adding a color. You can do this in various ways, for example "Multicolor", "Red / Blue", "Orange - Red", "Yellow", etc. (Note: We only use basic colors. If you enter "turquoise", it will be displayed as "Green" or "Rainbow" if not recognized by us.) |
Brand | Text, numbers, digits | Specify the brand of your product. |
Textile specifications:
Name (Add to product list) | Value | Explanation |
---|---|---|
Neck | Text, numbers, digits | Specify the type of neckline the product has. For example, "V-neck", "Round neck", etc. |
Material | Text, numbers, digits | Specify what the product is made of. This can be a list of multiple items. |
Fit | Text, numbers, digits | Specify the fit of the product. For example, "Slim fit", "Regular", "Relaxed", etc. |
Closure | Text, numbers, digits | Specify the type of closure the product has. For example, "Zipper", "Buttons", etc. |
Safety rating | Text, numbers, digits | Specify the safety rating of the product. For example, "S1", "S2", etc. (Important for certain workwear). |
Size | Text, numbers, digits | Specify the size of the product. For example, "S", "M", "3XL", "10/8", "114", etc. |
Gender | Text | Specify who the product is intended for. For example, "Male", "Female", "Unisex", etc. |
Sleeves | Text, numbers, digits | Specify the type of sleeves the product has. For example, "Long sleeves", "Short sleeves", etc. |
My product list is ready, what now?
Is your product list complete and do you want the new products or changes to appear on your portal? Create a ticket in the portal. We will process it as soon as possible.