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:
Green - available, i.e. you can specify this info for this product type;
Red - not available, i.e. this field is not available in the CSV for this very product type;
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);
An asterisk (*) means that this field is required, i.e. must be completed.
Digits separated by commas for min and max allowed values.
Fields | Wallpaper | Murals | Borders | Decals | Plaster |
---|
Paint | Wall Panel |
---|---|
brand_name | * |
*
*
*
*
collection_name | * |
*
*
*
*
product_name | * |
*
*
*
*
unique_sku_id | * |
*
*
*
*
product_image | * |
*
*
*
| |||||
product_width | * |
*
*
*
, |
|
|
| |||
product_length |
*
*
*
*
|
|
|
| ||
pattern_length |
*
*
*
*
|
|
|
|
| |
pattern_width |
*
*
*
*
|
|
|
|
|
| ||
pattern_offset | |||||||
repeatable |
No
By default
By default
customized_size |
No
By defaultNo
By defaultwidth_options | |||||||
height_options |
flip
No
By default
black_white
product_link | |||||||
product_ |
coverage |
wallpaper_roll_length |
| ||||||
color |
base |
coating | |||||||
texture | |||||||
product_transparency |
application_surface |
By default
Wall
By default
Wall
By default
Wall
By default
interior
interior_type | |||||||
style | |||||||
pattern | |||||||
material | |||||||
product_description |
product_availability |
In stock
By defaultIn stock
By default
In stock
By default
In stock
By default
In stock
By default
washability_rating
unit
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 |
| |||||||
reverse | |||||||
pattern_repeat | |||||||
mural |
main_colour
article_layout
wallpaper_roll_length
article_application_type
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) |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
CSV file sample |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
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 | 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/ |
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 | Yes | Yes/No |
customized_size | Possible values: Yes / 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 | Yes | Yes | float |
product_context | You can add the following types of context for the product items:
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 |
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 |
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 |
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 |
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 |
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 |
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 |