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. |
| 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 “Plaster” 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 |
Plaster | |
product_name | Name |
of an |
SKU that will be displayed in the catalog under the corresponding article image | yes | no | no | text |
Plaster 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 |
plaster_ |
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/multiselect |
plaster image 01.jpg | |||||
pattern_length | Length of the pattern itself. | yes | no | no | float, only numbers, up to 15 meters; unit. - meter |
0.5 | |||||
pattern_width | Width of the pattern itself. | yes | no | no | float, only numbers, up to 15 meters; unit. - meter |
0.5 | ||||||
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, unit. - meter | 0 |
product_link |
product_link
Product link on the |
website. | no | yes | no | text |
product_coverage | Package coverage. All measurements must be indicated in square meters. | no | no | no | float, unit. - square meters | 3.5 |
color | Product color |
. | no | no |
yes | text |
pink |
texture |
Product texture type which describes how the product feels, for example wood, stone, etc. | no | no | no | text |
cotton |
application_surface |
The surface where the product can be applied on |
: wall, floor, ceiling | no | no |
no | text |
wall, ceiling | |||||
interior_type | Describe what interior type where the product can be used in, for example: kitchen, bathroom, bedroom, basement. | no | no | yes | text |
living room,bedroom,hallway,homeoffice | |||||
style | Specify what design style the product fits the best. | no | no | yes | text |
modern | |||||
material | Describe the material a product is made of. | no | no | no | text |
cotton fibers | |||||
product_description | Description of the product. | no | no | no | text, up to 1000 symbols |
Plaster will add lightness to the interior and help create a peaceful atmosphere. The application possibilities are endless - apply on your own or combine with other types of coatings. | |||||
country_of_origin | Country of origin (where wallcovering was produced) | no | no | no | text |
USA | |||||
product_availability | Product availability: can be in stock or out of stock. Value by default is ‘in stock’. | no | no | no | bool |
in_ |
stock | |||||
product_regular_price | Regular price per product | no | yes | no | float |
18.2 | |||||
product_promotional_price | Promotional price per product | no | yes | no | float |
15 |
product_context |
You can add the following types of context for the product items:
Price
Promotional price
Country of otigin
Installation method
Links to different sites
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. That’s how to use the context in the CSV: “site_A, site_B“. Use comma to separate values. If you have any questions, please contact support@wizart.ai. | no | yes | no | text | en, da, de,nl,sv |
context_currency |
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, easy mixing, etc. | no | no |
no | text | easy mixing | ||||
usage | If the covering can be used interior/exterior and on what surfaces. For example: interior, exterior, countertops, walkways, etc. | no | no | no | text | interior |
resistance | Specify types of product resistance, for example water, mildew resistance, etc. | no | no | no | text | resistance water |
sheen | Type of sheen, for example, matte, glossy, etc. | no | no | no |
text | matte | ||
coating_type | Describe coating type. It can be water-based, acrylic-based, lime, cement, mud, stucco. | no | no |
no | text | water-based | ||||
additional_data | This column can be completed with any data if there are no columns which cover this information | no | no | no | text |