Understanding CSV Fields

An exhaustive list of CSV fields supported in the ArchiPro product editor.

When you upload your product inventory to ArchiPro using a CSV file, the columns of data can be mapped to certain fields within the ArchiPro product editor. The table below lists all the fields that can be mapped and imported using a CSV file, with a brief description of the content and formatting requirements

Some fields in the ArchiPro product editor have to be entered manually; these are listed here.

Column	Description	Required formatting	Example
Supplier Product ID	Your ID for the product. This ID should be consistent across all variants within a product. We use this ID to match updates to existing ArchiPro products.	Required for all CSV uploads (if ArchiPro Product ID is not available)	45334343 Iron-man-mirror1
ArchiPro Product ID	The Archipro ID for the product. We can use this ID to match updates to existing ArchiPro products.	Required for all CSV uploads (if Supplier Product ID is not available)	122204
Product Title	The name of your product.	Optional for CSV upload Up to 55 characters	Iron Man Mirror
Category	The primary Archipro category the product sits within.	Optional for CSV upload This can be an exact match to Archipro categories Accepted format: {category}/.../{category}	Bathroom Mirrors Bathroom / Showers / Shower Trays & Drains
Product Range	A range the product sits in	Optional for CSV upload	Avengers
Manufacturer brand	The company who produced and manufactured the product	Optional for CSV upload	Disney
Designer	The designer behind the product	Optional for CSV upload	Stan Lee
Year	The year the product was produced	Optional for CSV upload	2021
Warranty	The warranty period (number) in months.	Optional for CSV upload Include a unit (years, weeks) if not using months.	12 12 months 12 years 12 weeks
Website Referral Link	Link to product on your website. Typically, this will be the same product URL as it appears on your website and should be unique for each product.	Optional for CSV upload	http://www.ironman.co.nz/iron-man-mirror
Product Description	The description of the product	Optional for CSV upload	Modular wall mirror made from wood and brass.
Specifications	Any technical specifications about the product.	Optional for CSV upload	95+CRI LED used
Scope Of Use	Scope of use helps explain to the customer how the product works and the settings, applications, locations or projects it is suitable for. You could describe how the product is used, how it is applied, which situations or settings it is most suited to, and/or where its use should be avoided.	Optional for CSV upload	Designed to be hung on the wall.
Performance	The performance qualities of the product. You could describe how the product performs, the longevity of the product, what improvements have been made, and/or what warranties are provided.	Optional for CSV upload
Custom Section Label 1, 2, and 3	The title for the Custom section. Up to 3 Custom sections are available for import.	Optional for CSV upload	Care instructions
Custom Section Value 1, 2, and 3	The information within the related custom section label.	Optional for CSV upload	Hand wash only
Product Image	The full hosted image URL for the image.	Optional for CSV upload Supported image formats include GIF, JPG, and PNG. Multiple images can be separated by spaces, tabs, semicolons, pipes \|, or new lines. (Google Sheets: Alt+Enter or Excel: Ctrl+Alt+Enter). Ensure the URL leads directly to the image, not a page that includes the image. The maximum file size for your image is 20mb per photo. The minimum pixel size is 1000 x 1000px with a resolution of between 72 and 300 dpi.	https://www.ironman.co.nz/image.jpg https://archipro.co.nz/assets/images/6612312312?width=1920
Videos	The full hosted image URL for the product.	Optional for CSV upload Must be a Vimeo or YouTube link.	https://www.youtube.com/watch?v=eOrNdBpGMv8 https://vimeo.com/226053498
SEO Title	The SEO title that will appear when searched via Google. Often the same as the product title.	Optional for CSV upload Up to 60 characters.	Iron Man Mirror - Bathroom Mirrors NZ
SEO Description	The description for google search results.	Optional for CSV upload Up to 165 characters.	This product range is great for apartments where space is minimal. These bathroom mirrors can be made in a wide range of woodgrain colour finishes.
Search Tags	The tags on the product that support search on ArchiPro	Optional for CSV upload Multiple tags can be separated by spaces, tabs, semicolons, pipes \|, or new lines. We recommend a minimum of five tags, and that the total characters do not exceed 20.	European oak, Wood floors, Sustainable flooring, Engineered oak
Product Variant Barcode	The manufacturer’s barcode for the variant. Also known as the UPC.	Optional for CSV upload Up to 64 characters	123456789102
Variant SKU	The variant SKU, used within your business to identify the product. The Variant SKU identifies which variants are new, and which need updating.	Optional for CSV upload Up to 255 characters	SQ3579
Variant Image	The full hosted image URL for an image of a product variant.	Optional for CSV upload Only 1 image per variant. Supported image formats include GIF, JPG, and PNG. Ensure the URL leads directly to the image, not a page that includes the image. The maximum file size for your image is 20mb per photo. The minimum pixel size is 1000 x 1000px with a resolution of between 72 and 300 dpi.	https://www.ironman.co.nz/ironmanblack.jpg
Colour name	The colour title	Optional for CSV upload Up to 32 characters	Black
Colour hex	The hex code for the colour.	Optional for CSV upload	#000000
Swatch image	If no hex code is available, you can use a dedicated swatch image to show the colour. This could include textures and patterns.	Optional for CSV upload Supported image formats include GIF, JPG, and PNG. Ensure the URL leads directly to the image, not a page that includes the image. The maximum file size for your image is 20mb per photo. The minimum pixel size is 1000 x 1000px with a resolution of between 72 and 300 dpi.	https://www.ironman.co.nz/ironmanblackswatch.jpg
Material	The material of the product	Optional for CSV upload Up to 32 characters	Brass
Length, Width, Height, Diameter and Depth (mm)	These are individual input fields	Optional for CSV upload Include the unit if not using mm. Up to 5 characters.	5000 500cm 5m
Weight (kg)	Weight in kg.	Optional for CSV upload Include the unit if not using kg. Up to 5 characters.	5 5000g
Volume (ml)	Volume in ml.	Optional for CSV upload Include the unit if not using ml. Up to 5 characters.	5000 5L
Custom Variant Label 1, 2 and 3	Custom variant options that may be relevant to the product. Up to 3 Custom variants are available.	Optional for CSV upload	LED Light Type
Custom Variant Value 1, 2, and 3	The value to select for the related custom variant label.	Optional for CSV upload	Red Light
Downloads	The full URL for downloads. E.g. CAD/BIM files, Installation details, Certifications, etc.	Optional for CSV upload	http://www.ironman.co.nz/iron-man-mirror
Product Price	The price of the product or variant.	Optional for CSV upload Enter numbers and decimal points (.) only. Prices are accepted in cents. Include decimal points (.) to convert to dollars	75.00 7500
Price Per	The type of pricing.	Optional for CSV upload Defaults to Price per 'Unit'. Other accepted values: Metre, Square Metre, Cubic metre, and Box.	Metre Box
Sale Price	If the product is on sale, this is its sale price. Only enter a sale price if the sale status is set as Yes (next column). Leave this field blank to only display the standard price.	Optional for CSV upload Enter numbers and decimal points (.) only. Prices are accepted in cents. Include decimal points (.) to convert to dollars	70.00 7000
On Sale	Is the product "on sale". This will control whether or not the sale price is active. Enter Yes if the product or variant should display a sale price. Enter No if the product isn't on sale. Leave the field blank to only display the standard price.	Optional for upload Accepted formats include: Yes, No	Yes No
Sell online	Whether the product, and its variants, are enabled for purchase. If yes, the "Add to cart" button will be displayed.	Optional for upload Accepted formats include: Yes, No	Yes No
Stock	The number of products or variants in stock.	Optional for upload For ‘unlimited’ stock, set the stock as greater than or equal to 99999.	10
Back order	Whether the variants are enabled for backorder when out of stock. If yes, the "Add to cart" button will remain when our of stock and show a lead time that is specified.	Optional for upload Accepted formats include: Yes, No	Yes No
Made to order	Whether the variants are made to order.	Optional for upload Accepted formats include: Yes, No	Yes No
Indent	Whether the variants are indent or coming from overseas.	Optional for upload Accepted formats include: Yes, No	Yes No
Lead time	The lead time it takes for the product to be manufactured. This will inform the customer’s delivery expectations.	Optional for upload Default to weeks	8 weeks 8
Shipping	The shipping profile that is applied to the variant. Shipping profile names need to match the created profiles already found in ArchiPro or when exported directly from ArchiPro.	Optional for upload	Free shipping

How does CSV match with existing products?

CSV Product Matching follows this hierarchy to find a match:

Supplier Product ID from third-party system. When you import products from a third-party system, the products include a Supplier Product ID. This ID is stored in the ArchiPro system to ensure any future product imports will match.
If you have created product listings in ArchiPro, they will not have a Supplier Product ID. When this is the case, ArchiPro will use the following steps to determine a match.

Exact match on the Website URL for the Product
Exact match on SKU (master variant and variants all have SKUs)
Exact match on title

If none of the above are matched, the product is imported as a ‘new product’ with the status set to 'pending approval'.

If there is a match, the selected fields are updated, and the Supplier Product ID is set on the matching record so that future CSV imports will get the same match.

Fields not currently available for import from the CSV tool.

We are looking to implement these fields in the future. Until then, these will need to be added manually from the product editor.

Dimension Diagram
Package sizing
Sample price
Sample shipping
Low stock notifications
Stock status level
Link professionals