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. |
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
|
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