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!
Expand | ||
---|---|---|
| ||
Images for individual planks: or The prepared product pattern with layout should have a completely repeating pattern for seamless visualization. |
FIELDS | DESCRIPTION | REQUIRED (must be completed) | VALUE, LIMITS |
EXAMPLE | ||||
brand_name | Brand name. All collections of this brand will be displayed in the catalog inside the corresponding folder. | yes | 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 | text, 255 characters |
Laminate | ||||
product_name | Name/code of an SKU that will be displayed in the catalog under the corresponding article image | yes | no | text, 255 characters |
Laminate 01 | ||||
unique_sku_id | Unique SKU ID/code in your database. This value is required for successful integration with your e-catalogue. | yes | no | text |
laminate 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 | text/multiselect Image title, no extension. |
laminate image 01_01, laminate 01_02, laminate image 01_03 | ||||
product_width | Width of flooring. All measurements must be indicated in meters. | yes | no | float, numbers only, up to 5 meters |
0.192 | ||||
product_length | Length of flooring. All measurements must be indicated in meters. | yes | no | float, numbers only, up to 5 meters |
1.285 | ||||
product_thickness | Thickness of flooring. All measurements must be indicated in meters. | no | no | float, numbers only, up to 0,5 meters (rounding up to three tenths) |
0.012 | |
pattern_width | Width of the |
imported pattern. All measurements must be in meters. | no | no | float, numbers only, up to 9 meters |
0.5 |
pattern_length |
Lenght of the |
imported pattern. All measurements must be in meters. | 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 |
1_2_offset, 1_3_offset, no_offse | |
product_link | Product link on the |
website. | no | yes | text | ||
edge_selection | Specify if the edge line should be applied for layout generation. Possible values: Yes / 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 | text |
64,64,64 | ||||
product_description | Description of the product: up to 1000 symbols. | no | no | text |
Laminate Flooring uses bevelled edges to add an extra layer of distinction to the high quality design. The muted shades of this floor allow it to blend seamlessly with a wide range of interior designs, whilst the beautiful grain pattern offers great variation across the boards. | ||||
package_quantity | Number of products in a package. | no | no | int, only numbers |
6 | ||||
package_coverage | Package quantity of coverage. All measurements must be indicated in square meters. | no | no | float, only numbers |
1.48 | ||||
resistance | Specify types of product resistance, for example water, mildew resistance, etc. | no | no | text |
resistance for water |
country |
_of_origin | Country of origin (where the product was produced). | no | no | text |
USA | ||||
material | The material which the product is made from. | no | no | text |
Oak | ||||
color | Product color. | no | no | text |
Grey | ||||
product_edge | Product edge (for example, micro-bevel, rolled, scraped edge, square edge, pillowed). | no | no | text |
micro-bevel | |||||
surface_finish | Surface finish material (for example: oil, varnish). | no | no | text | varnish |
flooring_product_shape | Specify item shape (plank, tile, sheet, rectangle, hexagon). | no | no | text |
plank | ||||
texture | Flooring texture type which describes how the product feels, for example wood, stone, etc. | 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 | text |
living room,bedroom,hallway,homeoffice | ||||
style | Specify what design style the product fits the best. | no | no | text |
modern | ||||
pattern | Pattern displayed on the product. NOT TO BE CONFUSED WITH TEXTURE! Tile/floor pattern (wood, brick, stone, flowers) | no | no | text |
wood | |
application_surface | The surface where the product can be applied on: wall, floor |
. | no | no | multiselect | floor | |
installation_method | Specify the installation method (glue, nails, float, staple). | no | no | text | Locking System |
subfloor | Specify the surface on which you can install the flooring. | 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 | bool |
in_ |
stock | |||||
price_per_m2 | Price per m2. | no | yes | float, only numbers | 14.99 |
promotional_price_per_m2 |
Promotional price |
per |
m2. |
Promotional
no | yes | float, only numbers |
price per m2.
11.99 | ||||
price_per_package | Price per product package. | no | yes | float, only numbers |
22.19 | ||||
promotional_price_per_package | Promotional price per product package. | no | yes | float, only numbers |
17.75 | |
product_context | "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. |
no
yes
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 | 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 | text | $,€,€,€,kr. |
gloss | Describe the degree of gloss. It may vary between low, medium, and high. | 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 | text | medium |
lifestyle | Specify product lifestyle options, for example eco-friendly, pet-friendly, kid-friendly. | no | no | text | eco-friendly |
warranty | Describe product warranty. | 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 | text | interior |
additional_data | This column can be completed with any data if there are no columns which cover this information | no | no | text |