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! | DESCRIPTION | REQUIRED (must be completed) | VALUE, LIMITS | |
Brand_name | brand_name | Brand name. All collections of this brand will be displayed in the catalog inside the corresponding folder. | yes | no | text |
Collection_name | collection_name | Name of the collection. All wallcoverings from the same collection will be displayed in the catalog inside the corresponding folder. | yes | no | text |
Product_name | product_name | Name/code of an article will be displayed in the catalog under the corresponding article image | yes | no | text |
Unique_SKU_ID | unique_sku_id | Unique SKU ID/code in your database. This value is required for successful integration with your e-catalogue | yes | no | text |
Product_image | product_image | Article 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 |
product_width | product_width | Width of wallcoverings roll. All measurements must be indicated in meters. The unit of measurement can be changed in your PIM account. Please contact support@wizart.ai for help. | yes | no | float,numbers only, up to 15 meters |
product_length | product_length | Length of wallcovering. All measurements must be indicated in meters. The unit of measurement can be changed in your PIM account. Please contact support@wizart.ai for help. | yes | no | float, numbers only, up to 15 meters |
pattern_length | pattern_length | Length of the pattern itself. | yes | no | float, numbers only, up to 15 meters |
pattern_width | pattern_width | Width of the pattern itself. | yes | no | float, numbers only, up to 15 meters |
Usually, the pattern width is the same as the product width. | |||||
All measurements must be indicated in meters. | |||||
repeatable | repeatable | Possible values: Yes / No | no | no | bool |
Yes – the mural is applied repeatedly horizontally | |||||
No – the mural is applied in the center of the wall | |||||
The default value is “No” | |||||
customized_size | customized_size | Possible values: Yes / No. The default value is “No” No – the mural is printed always using the same dimensions | no | no | bool |
width_options | width_options | Possible width options of the product. Separated by commas, indicate additional options for product width in meters | no | no | float, multiselect? |
height_options | height_options | Possible height options of the product. Separated by commas, indicate additional options for product height (for example, 6.25, 7.4, 8.9) in meters | no | no | float, multiselect? |
product_link | product_link | Link to an SKU on the manufacturer's website | no | yes | text |
color | color | Colors of wallpaper pattern (use comma to separate colors) | no | no | text |
Base | base | Wallpaper backing material, for example non-hoven, vinyl, etc. | no | no | text |
Coating | coating | Wallpaper coating material type, for example vinyl, acrylic, flock, etc. | no | no | text |
texture | texture | Product texture type which describes how the product feels, for example wood, stone, etc. | no | no | text |
product_transparency | product_transparency | Degree of product transparency. Applies only for visualization. | no | no | float, 100 |
Application_surface | application_surface | Type of surface where the product can be applied on. If not specified, the value will be ‘wall’, 'ceiling'. | no | no | text |
interior | interior_type | Describe what interior type where the product can be used in, for example: kitchen, bathroom, bedroom. | no | no | text |
style | style | Specify what design style the product fits the best. | no | no | text |
pattern | pattern | Pattern displayed on the product. | no | no | text |
material | material | Describe the material a product is made of. | no | no | text |
product_description | product_description | Description of the product: up to 1000 symbols | no | no | text |
country | country_of_origin | Country of origin (where wallcovering was produced) | no | no | text |
product_availability | product_availability | Product availability: can be in stock or out of stock. Value by default is ‘in stock’. | no | no | bool |
product_regular_price | product_regular_price | Regular price per product. | no | yes | float |
product_promotional_price | product_promotional_price | Promotional price per product. | no | yes | float |
price_per_m2 | price_per_m2 | Price per m2. | no | yes | float |
promotional_price_per_m2 | promotional_price_per_m2 | Promotional price per m2. | no | yes | float |
product_context | product_context | You can add the following types of context for the product items: Price The context values are separated by commas. | no | yes | text |
context_currency | context_currency | Specify currencies for the required regions. | no | yes | text |
features | Specify wallcovering features, for example washable, strippable, easy mixing, etc. | no | no | text | |
pattern_scale | Specify pattern scale: small, medium, large, extra large. | no | no | text | |
additional_data | This column can be completed with any data if there are no columns which cover this information | no | no | text |