The table below describes each field of the CSV file in detail.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 “Paint” product type:
FIELDS | DESCRIPTION | REQUIRED (must be completed) | FILTER | VALUE, LIMIT | 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 products from the same collection will be displayed in the catalog inside the corresponding folder. | yes | no | no | text | Paint |
product_name | Name/code of an SKU that will be displayed in the catalog under the corresponding article image | yes | no | no | text | Paint 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 | paint_001 |
product_image | SKU 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 | paint image 01.jpg | ||||
pattern_width | Width of the pattern itself (usually the same as the product width). | yes | no | no | float, numbers only, up to 15 meters | 0.5 |
product_link | Product link on the |
website. | no | yes | no | text | ||
usage | If the covering can be used interior/exterior and on what surfaces. For example: interior, exterior, base, previously painted, new concrete, plaster, masonry, wood, primed metal. | no | no | no | text | interior, exterior, plaster |
sheen | Type of sheen, for example, satin, semi-gloss, matte, flat. | no | no | no | text | Matte, Gloss, Eggshell |
application_surface | The surface where the product can be applied on: wall, ceiling, floor. | no | no | no | multiselect | wall, ceiling, floor |
color | Product color. | no | no | yes | text | blue |
product_coverage | Package/container quantity of coverage. All measurements must be indicated in square meters. | no | no | no | float | 6 |
coating_type | Describe coating type. It can be water-based, oil-based, acrylic. | no | no | no | text | water-based |
opacity | Describe the degree of stain opacity, for example semi-transparent, semi-solid, or solid. | no | no | no | float, up to 100 | semi-transparent |
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, bathroom |
product_description | Description of the product: up to 1000 symbols. | no | no | no | text | |
country_of_origin | Country of origin (where the product 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 |
price_per_container | Price per container. | no | yes | no | float, numbers only | 85.95 |
promotional_price_per_container | Promotional price per product container. | no | yes | no | float, numbers only | 75.59 |
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 (if you use different currencies for the domains, please state them in this field. Example “USD, EUR”. | no | yes | no | text | $,€,€,€,kr. |
cleanup | Specify cleanup method, for example, water, solvent. | no | no | no | text | solvent |
features | Product features, for example, washable, fast-drying, self-priming. | no | no | no | text | fast-drying |
container_size | Container size. | no | no | no | float | 3.63 |
drying_time | Drying time. | no | no | no | text | 12 |
recommended_coats | Number of recommended coats. | no | no | no | float | 1 |
warranty | Product warranty. | no | no | no | text | 5 |
resistance | Resistance types: Mildew-Resistant Coating, Scuff Resistant, etc. | no | no | no | text | Mildew-Resistant Coating |
lifestyle | Product lifestyle options, for example, eco-friendly, pet-friendly, kid-friendly. | no | no | no | text | eco-friendly |
additional_data | This column can be completed with any data if there are no columns which cover this information | no | no | no | text |