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!
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. |
Field values in the CSV template for the “Wall Mural” product type:
FIELDS | DESCRIPTION | REQUIRED (must be completed) | FILTER | VALUE, LIMITS | Brand_nameEXAMPLE | ||||||
brand_name | Brand name. All collections of this brand will be displayed in the catalog inside the corresponding folder. | yes | no | no | text | Collection_nameWizart | |||||
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 | Product_nameWall Mural | |||||
product_name | Name/code of an article will be displayed in the catalog under the corresponding article image | yes | no | no | text | Unique_SKU_IDMural 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 | Product_imagemural-01 | |||||
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/multiselect | product_widthmural.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, up to 15 meters | product_length4.05 | |||||
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 | no | float, numbers only, up to 15 meters | pattern_length2.7 | |||||
pattern_length | Length of the pattern itself. | yes | no | no | float, numbers only, up to 15 meters | pattern_width2.7 | |||||
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. | repeatableyes | no | no | float, numbers only, up to 15 meters | 4.05 | |
repeatable | Possible values: Yes / No | no | no | bool | . The default value is “No” Yes – the mural is applied repeatedly horizontally | ||||||
The default value is “No” | |||||||||||
no | no | no | bool | yes | |||||||
customized_size | Possible values: Yes / No. The default value is “No” No – the mural is printed always using the same dimensions | no | no | no | bool | width_optionsno | |||||
width_options | Possible width options of the product. Separated by commas, indicate additional options for product width in meters | no | no | no | float, multiselect? | height_options4.05,3.1,2.7 | |||||
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 | no | float, multiselect? | 2.7,2.2,1.5 | |||||
product_link | product_link | Link to an SKU Product link on the manufacturer's website. | no | yes | no | text | |||||
color | Product colorColors of wallpaper pattern (use comma to separate colors). | no | no no | yes | text | Basered, pink | |||||
base | Wallpaper backing material, for example non-hoven, vinyl, etc. | no | no | no | text | Coatingnon-woven | |||||
coating | Wallpaper coating material type, for example vinyl, acrylic, flock, etc. | no | no | no | text | textureacrylic | |||||
texture | Product texture type which describes how the product feels, for example wood, stone, etc. | no | no | no | text | product_transparencycanvas | |||||
product_transparency | Degree of product transparency. Applies only for visualization. | no | 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'.Please use lowercase letters. | no | no | no | text | interiorwall, ceiling | ||||
interior_type | Describe what interior type where the product can be used in, for example: kitchen, bathroom, bedroom. | no | no | yes | text | styleliving room,bedroom,hallway,homeoffice | |||||
style | Specify what design style the product fits the best. | no | no | yes | text | patternmodern | |||||
pattern | Pattern displayed on the product. | no | no | yes | text | materialgeometric | |||||
material | Describe the material a product is made of. | no | no | no | text | product_descriptionvinyl | |||||
product_description | Description of the product: up to 1000 symbols | no | no | text | countryno | text | Whether you want a room refresh or a total space transformation, wall murals and wallpaper are a simple and stylish way to update your home wall decor. | ||||
country_of_origin | Country of origin (where wallcovering was produced) | no | no | no | text | product_availabilityUSA | |||||
product_availability | Product availability: can be in stock or out of stock. Value by default is ‘in stock’. | no | no | no | bool | productin_ | regular_pricestock | ||||
product_regular_price | Regular price per product. | no | yes | no | float | product_promotional_price100.99 | |||||
product_promotional_price | Promotional price per product. | no | yes | no | float | price_per_m270.99 | |||||
price_per_m2 | Price per m2. | no | yes | no | float | promotional_price_per_m250 | |||||
promotional_price_per_m2 | Promotional price per m2. | no | yes | no | float | product_context40 | |||||
product_context | You can add the following types of context for the product items: Price The context values are separated by commasContext 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. | no | yes | no | text | en, da, de,nl,sv | |||||
context_currency | context_currency | Specify Context currency (if you use different currencies for the required regionsdomains, please state them in this field. Example “USD, EUR”. | no | yes | no | text | $,€,€,€,kr. | ||||
features | Specify wallcovering features, for example washable, strippable, easy mixing, etc. | no | no | no | text | washable | |||||
pattern_scale | Specify pattern scale: small, medium, large, extra large. | no | no | no | text | extra large | |||||
additional_data | This column can be completed with any data if there are no columns which cover this information | no | no | no | text |