The table below describes each field of the CSV file in detail.
We've updated fields in the CSV files:
added some new fields for broad product descriptions (column “FIELDS NEW!”, highlighted in green);
rename some fields (column “FIELDS NEW!”, highlighted in yellow);
delete some field (column “FIELDS OLD!”, crossed off).
...
FIELDS
OLD!
...
FIELDS
NEW!
Please check our detailed requirements for the files imported to the PIM account. If you have any questions or issues while uploading SKU's and CSV files, please contact us via support@wizart.ai
| Tip |
|---|
Before preparing the files, please check our Image File Requirements. |
| Expand | ||
|---|---|---|
| ||
Images for individual planks:  or The prepared product pattern with layout should have a completely repeating pattern for seamless visualization. 
|
Field values in the CSV template for the “Engineered Wood Flooring” product type:
FIELDS | DESCRIPTION | REQUIRED (must be completed) | FILTER | VALUE, LIMITS |
EXAMPLE | |||||
brand_name | Brand name. All collections of this brand will be displayed in the catalog inside the corresponding folder. | yes | no | no | text, 255 characters |
Wizart | |||||
collection_name | Name of the collection. All products from the same collection will be displayed in the catalog inside the corresponding folder. | yes | no | no | text, 255 characters |
Engineered Flooring | |||||
product_name | Name/code of an SKU that will be displayed in the catalog under the corresponding article image | yes | no | no | text, 255 characters |
Engineered Flooring 01 | |||||
unique_sku_id | Unique SKU ID/code in your database. This value is required for successful integration with your e-catalogue. | yes | no | no | text |
engineered flooring 001 | |||||
product_image | SKU image name from the ZIP file. There is no need to add extension (.jpg, .png, or .jpeg) to the file name. | yes | no | no | text/multiselect |
engineered flooring image 01_01, laminate 01_02, engineered flooring image 01_03 or engineered flooring image 01_ | |||||
product_width | Width of flooring. All measurements must be indicated in meters. | yes | no | no | float, numbers only, up to 5 meters |
0.192 | |||||
product_length | Length of flooring. All measurements must be indicated in meters. | yes | no | no | float, numbers only, up to 5 meters |
1.285 | |||||
product_thickness | Thickness of flooring. All measurements must be indicated in meters. | no | no | no | float, numbers only, up to 0,5 meters |
0.012 | |||||
pattern_width | Width of the pattern itself (usually the same as the product width). | no | no | no | float, numbers only, up to 9 meters |
0.5 | |||||
pattern_length | Length of the pattern itself (usually the same as the product length). | no | no | no | float, numbers only, up to 9 meters |
0.5 | |
layouts | The way in which flooring pieces (boards, tiles) are arranged. |
no
no
multiselect
Possible values: 1_2_offset, 1_3_offset, no_offset, random_offset |
, |
herringbone, chervron, basket_weave. |
no | no | no | multiselect | 1_2_offset, 1_3_offset, no_offse | |
product_link | Product link on the |
website. | no | yes | no | text |
edge_selection | Specify if the edge line should be applied for layout generation. Possible values: Yes / No | no | no | no | bool | yes |
edge_color | Please provide the RGB format for the edge line color to replace the automatically assigned color if needed. For example: "165,42,42" | no | no | no | text | 64,64,64 |
product_description | Description of the product: up to 1000 symbols. | no | no |
text
no | text | Engineered wood flooring brings that warmth and comfort into your home and consists of cross-ply layers glued on top of each other with a top layer of real wood. Although they look just like solid wood floors, engineered flooring is more stable, durable and friendlier to your budget. They are also really simple to lay with a variety of different locking systems. With a wide range of colours and engineered wood such as oak, ash, walnut and more, browse our engineered wood flooring today. | |||
package_quantity | Number of products in a package. | no | no | no | int, only numbers |
6 | |||||
package_coverage | Package quantity of coverage. All measurements must be indicated in square meters. | no | no | no | float, only numbers |
1.48 | |||||
resistance | Specify types of product resistance, for example water, mildew resistance, etc. | no | no | no | text |
resistance for water | |||||
country_of_origin | Country of origin (where the product was produced). | no | no | no | text |
USA | |||||
material | The material which the product is made from. | no | no | no | text |
Oak | |||||
color | Product color. | no | no | yes | text |
Grey | |||||
product_edge | Product edge (for example, micro-bevel, rolled, scraped edge, square edge, pillowed). | no | no | no | text |
micro-bevel | ||||||
surface_finish | Surface finish material (for example: oil, varnish). | no | no | no | text | varnish |
flooring_product_shape | Specify item shape (plank, tile, sheet, rectangle, hexagon). | no | no | no | text |
plank | |||||
texture | Flooring texture type which describes how the product feels, for example wood, stone, etc. | no | no | no | text |
distressed | |||||
interior_type | Describe what interior type where the product can be used in, for example: kitchen, bathroom, bedroom, basement. | no | no | yes | text |
living room,bedroom,hallway,homeoffice | |||||
style | Specify what design style the product fits the best. | no | no | yes | text |
modern | |||||
pattern | Pattern displayed on the product. NOT TO BE CONFUSED WITH TEXTURE! Tile/floor pattern (wood, brick, stone, flowers) | no | no | yes | text |
wood | |
application_surface | The |
product can be applied on |
floor only. | no | no | no | multiselect | floor | |
installation_method | Specify the installation method (glue, nails, float, staple). | no | no | no | text | Locking System |
subfloor | Specify the surface on which you can install the flooring. | no | no | no | text |
Particle board | |||||
product_availability | Product availability: can be in stock or out of stock. Value by default is ‘in stock’. | no | no | no | bool |
in_ |
stock | ||||||
price_per_m2 | Price per m2. | no | yes | no | float, only numbers | 14.99 |
promotional_price_per_m2 |
Promotional price |
per |
m2 |
. | no | yes | no | float, only numbers |
price per m2.
11.99 | |||||
price_per_package | Price per product package. | no | yes | no | float, only numbers |
22.19 | |||||
promotional_price_per_package | Promotional price per product package. | no | yes | no | float, only numbers |
17.75 |
product_context |
You can add the following types of context for the product items:
Price
Promotional price
Country of otigin
Installation method
Links to different sites
Context for products (if you have several domains for different cities/states/countries, and each of your domains has a different stock, the context gives you an opportunity to ‘hide’ some products that are not available for this particular area; put different links to the corresponding domain for each product; set different prices and currencies for each domain. That’s how to use the context in the CSV: “site_A, site_B“. Use comma to separate values. If you have any questions, please contact support@wizart.ai. | no | yes | no | text |
en, da, de,nl,sv | ||||||
context_currency | Context currency (if you use different currencies for the domains, please state them in this field). Example “USD, EUR”. | no | yes | no | text | $,€,€,€,kr. |
gloss | Describe the degree of gloss. It may vary between low, medium, and high. | no | no | no | text | Brushed |
shade | Describe the degree of shade. Flooring products have variations in color ranging from low, medium or natural, to high variation. | no | no | no | text | medium |
lifestyle | Specify product lifestyle options, for example eco-friendly, pet-friendly, kid-friendly. | no | no | no | text | eco-friendly |
warranty | Describe product warranty. | no | no | no | text | 3 |
usage | If the covering can be used interior/exterior and on what surfaces. For example: interior, exterior, countertops, walkways, etc. | no | no | no | text | interior |
additional_data | This column can be completed with any data if there are no columns which cover this information | no | no | no | text |