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
...
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 | ||
|---|---|---|
| ||
|
Field values in the CSV template for the “Rug” 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, 255 characters |
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, 255 characters |
Rug | |||||
product_name | Name/code of an SKU that will be displayed in the catalog under the corresponding article image | yes | no | no | text, 255 characters |
Rug 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 |
rug_ |
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/multiselect |
rug image 02.png | |||||
product_width | Width of flooring. All measurements must be indicated in meters. | yes | no | no | float, numbers only, up to 15 meters |
1.6 | |||||
product_length | Width of flooring. All measurements must be indicated in meters. | yes | no | no | float, numbers only, up to 15 meters |
2.3 | |||||
product_shape | Product shape: round, square. | yes | no | no | bool |
square | |||||
pile_height | Pile height of flooring. All measurements must be indicated in meters. | no | no | no | float, numbers only, up to 0,5 meters |
0.01 | |||||
pattern_width | Width of the pattern itself (usually the same as the product width). | no | no | no | float, numbers only, up to 15 meters |
pattern_length | Width of the pattern itself (usually the same as the product width). | no | no | no | float, numbers only, up to 15 meters |
product_link | Product link on the manufacturer's website. | no | yes | no | text |
product_description | Description of the product: up to 1000 symbols. | no | no | no | text |
country_of_origin |
Country of origin | no | no | no | text |
USA | |||||
material | The material which the product is made from. | no | no | no | text |
Wool | |||||
backing_material | Backing material of a rug. | no | no | no | text |
woven polypropylene | |||||
color | Product color. | no | no | yes | text |
Elcho | ||||||
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 |
style
Specify what design style the product fits the best. | no | no | yes | text |
modern | |||||
pattern | Pattern displayed on the product. | no | no | yes | text |
flower | |||||
application_surface | The product can be applied on floor only. | no | no | no | multiselect |
floor | |||||
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, only numbers |
50.99 | |||||
product_promotional_price | Promotional price per product | no | yes | no | float, only numbers |
45.89 |
product_context |
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. |
yes
text
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. | ||||||
construction | Describe pile construction type, for example cut pile, loop pile, cut and loop pile, frieze, saxony, berber pile. | no | no | no | text | Loop pile |
additional_data | This column can be completed with any data if there are no columns which cover this information | no | no | no | text |