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
...
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 | ||
|---|---|---|
| ||
 Make sure the images have a repeatable pattern of the boards so that they look seamless if put together:  |
Field values in the CSV template for the “Wallpaper” 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 |
Wizart | |||||
collection_name | Name of the collection. All wallcoverings from the same collection will be displayed in the catalog inside the corresponding folder. | yes | no | no | text |
Wallpaper | |||||
product_name | Name/code of an article will be displayed in the catalog under the corresponding article image | yes | no | no | text |
Wallpaper 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 |
wp_ |
001 | |||||
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 | no | text |
wallpaper image 01.jpg | |||||
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 | no | float, numbers only |
between: 0.01,15 | 1.06 | |||||
repeat_width | Width of the imported pattern. All measurements must be in meters. | yes | no | no | float, numbers only between: 0.01,10 | 1.06 |
pattern_repeat | Repeat of repeated pattern. All measurements must be indicated in meters. | no | no | no | float | 0.64 |
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 | no | float | 0.32 |
product_link |
product_link
Product link on the |
website. | no | yes | no | text |
wallpaper_roll_length | Length of wallpaper roll. All measurements must be indicated in meters. | no | no | no | numbers only, between: 0.01, 30 | 10 |
color | Colors of wallpaper pattern (use comma to separate colors) | no | no | yes | text |
blue, red | |||||
base | Wallpaper backing material, for example non-hoven, vinyl, etc. | no | no | no | text |
non-woven wallpaper | |||||
coating | Wallpaper coating material type, for example vinyl, acrylic, flock, etc. | no | no | no | text |
product_transparency
product_transparency
no
no
float, up to 100
interior
vinyl | |||||
interior_type | Describe what interior type where the product can be used in, for example: kitchen, bathroom, bedroom. | 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. | no | no | yes | text |
geometric | |||
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
Promotional price
Links to different sites
The context values are separated by commas.
no
yes
text
context_currency
context_currency
Specify currencies for the required regions.
no
yes
text
Product find store action
washability_rating
unit
texture
no | text | This wallcovering is packaged and sold in a commercial bolt that is 54" wide x 90' long. It has a random match. It is unpasted, washable and scrubbable vinyl. This heavily textured, fabric-backed vinyl paper has a linen pattern, and it comes in three different colors. | ||
texture | Product texture type which describes how the product feels, for example wood, stone, etc. | no | no | no |
text |
stone | |||
country_of_origin | Country of origin (where the product was produced). | no | no |
text
no | text | USA | |
removal_type | Wallpaper removal type, for example strippable, peelable, wet. | no | no |
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
no |
light_fastness
text | strippable | |||||
product_transparency | Degree of product transparency. Applies only for visualization. | no | no | no | float, between:0,100 | 0 |
reverse | Reverse alternate length: yes/no. If not specified, the value will be ‘no’. | no | no |
no |
pattern_repeat
pattern_repeat
Repeat of repeated pattern. All measurements must be indicated in meters.
no
no
float
mural
bool | no |
mural | Mural: yes/no |
no
If not specified, the value will be ‘no’. |
main_colour
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
no | no | no | bool | no | ||
product_availability | Product availability: can be in_stock, out_of_stock or preorder. Value by default is ‘in_stock’. | no | no | no | bool | in_stock |
product_regular_price | Regular price per product | no | yes | no | float | 100.99 |
product_promotional_price | Promotional price per product | no | yes | no | float | 70.99 |
product_layout | How wallpaper should be applied on the wall: horizontal/vertical. If not specified, wallpaper will be applied vertically | no | no |
no | bool | vertical |
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
no | no | no | bool | wall, ceiling | ||
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. You can add the following types of context for the product items:
Use comma to separate values. | 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. |
features | Specify wallcovering features, for example washable, strippable, etc. | no | no | no | text | washable, strippable |
pattern_scale | Specify pattern scale: small, medium, large, extra large. | no | no | no | text | large |
installation_method | Specify installation method, for example, pre-pasted, self-adhesive, paste the wall, etc. | no | no | no | text | paste the wall |
additional_data | This column can be completed with any data if there are no columns which cover this information | no | no | no | text |