Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Info

We have updated the uploading process by adding some validation steps; several definitions in Data Mapping have also been changed. If you have any questions or issues while uploading SKUs and/or CSV files, please contact support@wizart.ai

...

Please note that some fields are not available for certain product types. Check the table below for more info.

Colors and symbols used:

  1. Green - available, i.e. you can specify this info for this product type;

  2. Red - not available, i.e. this field is not available in the CSV for this very product type;

  3. Yellow - recommended field, i.e. it is not required, but we do recommend filling this one in for a more accurate visualization result or simply for giving more details on the product);

  4. An asterisk (*) means that this field is required, i.e. must be completed.

  5. Digits separated by commas for min and max allowed values.

Fields

Wallpaper

Murals

Borders

Decals

Plaster

Brand

Paint

Wall Panel

brand_name

*

*

*

*

*

Collection

collection_name

*

*

*

*

*

Product

product_name

*

*

*

*

*

Unique_SKU_IDProduct

unique_sku_id

*

*

*

*

*

*

product_image

*

*

*

*

0.01,15

product_width

*

*

*

*

**

, 0.01,15

0.01,15

0.01,15

0.01,9

product_length

*

*

*

*

*

0.01,15

0.01,15

0.01,15

0.01,9

pattern_length

*

*

*

*

0.01,15

0.01,15

0.01,15

0.01,15

0.01,9

pattern_width

*

*

*

*

*

0.01,15

0.01,15

0.01,15

0.01,15

0.01,9

0.01,9

pattern_offset

repeatable

No

By default

No

By default

customized_size

No

By default

No

By default

width_options

height_options

flip

No

By default

black_white

product_link

product_

link

coverage

area_coverage

wallpaper_roll_length

0.01,30

color

/colour

Base

base

Coating

coating

texture

product_transparency

Application

application_surface

Wall

By default

Wall

By default

Wall

By default

Wall

By default

interior

style

interior_type

style

pattern

material

product_description

country

product_availability

In stock

By default

In stock

By default

In stock

By default

In stock

By default

In stock

By default

washability_rating

unit

coom_type

product_regular_price

product_promotional_price

price_per_m2

promotional_price_per_m2

price_per_container

promotional_price_per_container

product_context

context_currency

Product find store action

country_of_origin

removal_type

light_fastness

repeat_width

*

0.01,10

reverse

pattern_repeat

mural

main_colour

article_layout

wallpaper_roll_length

article_application_type

article_add_to_cart_action

product_layout

application_surface

features

pattern_scale

installation_method

usage

resistance

sheen

coating_type

opacity

cleanup

container_size

drying_time

recommended_coats

warranty

lifestyle

wall_panel_product_shape

surface_finish

packvage_quantity

product_thickness

design_type

weight

slat_width

slat_thickness

felt_backing_thickness

gap_width

All up-to-date CSV templates for various wall product types, as well as sample completed CSV files for these product types, can be downloaded from the table below:

Fields

Wallpaper

Murals

Borders

Decals

Plaster

Paint

Wall Panels

Tile

Laminate

Vinyl Flooring

Hardwood flooring

Engineered wood flooring

Carpet tile

Carpet roll

Rug

CSV template (empty)

View file
nameDefault mapping template_Wallpaper.csv

View file
nameDefault mapping template_Wall_mural.csv

View file
nameDefault mapping template_Wall_border.csv

View file
nameDefault mapping template_Wall_decals.csv

View file
nameDefault mapping template_Plaster.csv

View file
nameDefault mapping template_Paint.csv

View file
nameDefault mapping template_Wall_panels.csv

View file
nameDefault mapping template_Tile.csv

View file
nameDefault mapping template_Laminate.csv

View file
nameDefault mapping template_Vinyl_flooring.csv

View file
nameDefault mapping template_Hardwood_flooring.csv

View file
nameDefault mapping template_Engineered_wood_flooring.csv

View file
nameDefault mapping template_Carpet_tile.csv

View file
nameDefault mapping template_Carpet_roll.csv

View file
nameDefault mapping template_Rug.csv

CSV file sample

View file
nameExample_Wallpaper.csv

View file
nameExample_Wall_mural.csv

View file
nameExample_Wall_border.csv

View file
nameExample_Wall_decals.csv

View file
nameExample_Plaster.csv

View file
nameExample_Paint.csv

View file
nameExample_Wall_panels.csv

View file
nameExample_Tile.csv

View file
nameExample_Laminate.csv

View file
nameExample_Vinyl_flooring.csv

View file
nameExample_Hardwood_flooring.csv

View file
nameExample_Engineered_wood_flooring.csv

View file
nameExample_Carpet_tile.csv

View file
nameExample_Carpet_roll.csv

View file
nameExample_Rug.csv

The table below describes each field of the CSV file in detail (for wall product types only):

Fields

Description

Can be edited in the CSV

Can be edited in the
product card

Value

Brand_name

Brand name. All collections of this brand will be displayed in the catalog inside the corresponding folder.

No

Yes

Can be any numeric and/or text values.

Collection_name

Name of the collection. All wallpapers from the same collection will be displayed in the catalog inside the corresponding folder.

No

Yes

Can be any numeric and/or text values.

Product_name

Name/code of an article will be displayed in the catalog under the corresponding article image

Yes

Yes

Can be any numeric and/or text values.

Unique_SKU_ID

Unique SKU ID/code in your database. This value is required for successful integration with your e-catalogue

No

Yes

Can be any numeric and/or text values. SKU ID cannot be repeated within the same collection, but can belong to several different collections.

Product_image

Article image name from the ZIP file. There is no need to add extension (.jpg, .png, or .jpeg) to the file name

No

No

text/
multiselect.

product_width

Width of wallpaper 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

Yes

Please mention NUMERIC VALUE only, not adding units of measurement (m, cm, etc.):

product_length

Length of wallpaper. 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

Yes

Please mention NUMERIC VALUE only, not adding units of measurement (m, cm, etc.):

pattern_length

Length of the pattern itself.

Usually, the pattern length is the same as the product length.

All measurements must be indicated in meters.

Yes

Yes

Please mention NUMERIC VALUE only, not adding units of measurement (m, cm, etc.):

pattern_width

Width of the pattern itself.

Usually, the pattern width is the same as the product width.

All measurements must be indicated in meters.

Yes

Yes

Please mention NUMERIC VALUE only, not adding units of measurement (m, cm, etc.):

pattern_offset

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.

Yes

Yes

Please, mention NUMERIC VALUE only, not adding measurements like meters, cm etc.

repeatable

Possible values: Yes / No
Yes – the mural is applied repeatedly horizontally
No – the mural is applied in the center of the wall
The default value is “No”

Yes

Yes

Yes/No

customized_size

Possible values: Yes / No
No – the mural is printed always using the same dimensions
Yes – the mural is printed in different dimensions to adjust to a wall.
The default value is “No”

Yes

Yes

Yes/No

width_options

Separated by commas, indicate additional options for product dimensions (for example, 6.25, 7.4, 8.9) in meters

Yes

Yes

float, multiselect

height_options

Separated by commas, indicate additional options for product dimensions (for example, 6.25, 7.4, 8.9) in meters

Yes

Yes

float, multiselect

flip

Flip (yes, no)

Yes

Yes

Yes/No

black_white

yes, no

Yes

Yes

Yes/No

product_link

Link to SKU on main website

Yes

Yes

Full link

area_coverage

Package coverage. All measurements must be indicated in square meters.

Yes

Yes

float

color/colour

Colors of wallpaper pattern (use comma to separate colors)

Yes

Yes

text

Base

Basis of wallpaper

Yes

Yes

text

Coating

Coating of wallpaper (use comma to separate coatings)

Yes

Yes

text

texture

Texture of wallpaper (use comma to separate textures)

Yes

Yes

text

product_transparency

Yes

Yes

float

Application_surface

The default value is “Wall”

Yes

Yes

text (wall, floor)

interior

Type of a room a product is going to be used in: bedroom, kitchen, etc.

Yes

Yes

text

style

Describe style of wallpaper (use comma to separate styles)

Yes

Yes

text

material

Describe the material your product is made of

Yes

Yes

text

product_description

Description of article: up to 1000 symbols

Yes

Yes

text

country

Country of origin (where wallpaper was produced)

Yes

Yes

text

product_availability

Can be in stock, Out of stock. Default in stock.

Yes

Yes

in stock, Out of stock, Preorder

product_regular_price

Regular price: numeric value

Yes

Yes

float

product_promotional_price

Promotional price: numeric value

Yes

Yes

float

price_per_m2

Price per m2.

Yes

Yes

float

promotional_price_per_m2

Promotional
price per m2.

Yes

Yes

float

product_context

You can add the following types of context for the product items:

  • Price

  • Discount price

  • Country / Region

  • Type of application

  • Links to different sites

The context values are separated by commas.

Yes

Yes

text

context_currency

You can specify different types of currencies for the required regions.

Yes

Yes

text

Product find store action

Yes

Yes

washability_rating

Specify washability rating of wallpaper article

Yes

Yes

SpongeableWashable 
Extra Washable 
Scrubbable

unit

In the CSV file, 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

Yes

Select

room_type

Type of room where this particular wallpaper design could be applied (use comma to separate room types)

Yes

Yes

Bedroom, living-room, kitchen

removal_type

Specify removal type of wallpaper article

Yes

Yes

Strippable 
Peelable
Wet Removable

light_fastness

Light fastness is simply the degree to which wallpaper will keep its color in sunlight.

Yes

Yes

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

Yes

Please mention NUMERIC VALUE only, not adding measurements (m, cm, etc.):

reverse

Reverse alternate length: yes/no. If not specified, the value will be ‘no’.

Yes

Yes

Yes
No

pattern_repeat

Repeat of repeated pattern. All measurements must be indicated in meters.

Yes

Yes

Please mention NUMERIC VALUE only, not adding measurements like meters, cm etc.

mural

Mural: yes/no

If not specified, the value will be ‘no’.

Yes

Yes

Yes
No

main_colour

Main color of wallpaper pattern

Yes

Yes

text (Green, blue)

article_layout

How wallpaper should be applied on the wall: horizontal/vertical. If not specified, wallpaper will be applied vertically

Yes

Yes

Horizontal
Vertical

wallpaper_roll_length

Length of wallpaper roll. All measurements must be indicated in meters.

Yes

Yes

Please mention NUMERIC VALUE only, not adding measurements like meters, cm etc.:

article_application_type

Type of surface where the article could be applied.

If not specified, the value will be ‘wall’.

Please use lowercase letters.

Yes

Yes

wall
floor

article_add_to_cart_action

Link to shopping cart functionality on the main website

Yes

Yes

Link

pattern

Type of the pattern

Yes

Yes

abstract, floral, vintage, etc