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 |
pattern_offset | pattern_offset | Specify how much the next tile must be shifted so that the pattern matches – numeric value in meters. In case of straight/random match leave this cell empty or enter 0. All measurements must be indicated in meters. | no | no | float |
product_link | product_link | Link to an SKU on the main 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 |
product_transparency | product_transparency |
| no | no | float, up to 100 |
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 |
product_description | product_description | Description of the product: up to 1000 symbols | 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 |
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 |
| |||||
| |||||
| |||||
texture | texture | Product texture type which describes how the product feels, for example wood, stone, etc. | no | no | text |
country | country_of_origin | Country of origin (where the product was produced). | no | no | text |
removal_type | removal_type | Wallpaper removal type, for example strippable, peelable, wet. | no | no | text |
| |||||
repeat_width | repeat_width | Width of the pattern itself. Usually, the Repeat Width is the same as the Product Width. All measurements must be indicated in meters. | yes | no | float |
reverse | reverse | Reverse alternate length: yes/no. If not specified, the value will be ‘no’. | no | no |
|
pattern_repeat | pattern_repeat | Repeat of repeated pattern. All measurements must be indicated in meters. | no | no | float |
mural | mural | Mural: yes/no | no | no |
|
If not specified, the value will be ‘no’. | |||||
| |||||
article_layout | product_layout | How wallpaper should be applied on the wall: horizontal/vertical. If not specified, wallpaper will be applied vertically | no | no |
|
wallpaper_roll_length | wallpaper_roll_length | Length of wallpaper roll. All measurements must be indicated in meters. | no | no | numbers only, between: 0.01, 30 |
article_application_type | application_surface | Type of surface where the product can be applied on. If not specified, the value will be ‘wall’. Please use lowercase letters. | no | no | text |
| |||||
features | Specify wallcovering features, for example washable, strippable, etc. | no | no | text | |
pattern_scale | Specify pattern scale: small, medium, large, extra large. | no | no | text | |
installation_method | Specify installation method, for example, pre-pasted, self-adhesive, paste the wall, etc. | 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 |