Import Product Personalizations – Comprehensive Guide
Personalization Import (Example .CSV) – Note your .CSV file will look different than the example provided here.
If you are utilizing variant pricing it will accept $1.00 to add to the base product price or -$1.00 to subtract from the base product price.
Please note: anything separated with a | (pipe symbol) must also be separated in the .CSV file itself as well in order for the system to determine which values to look for.
Below is a breakdown of each header that can be added into the product personalization import and their meaning.
——————————————————————————————————————-
Product Id – A system generated Id used to identify the product
Product SKU – The SKU for the set of options.
Product Name – The main product name
Vendor Name – Name of the main product’s vendor
Question ID|Answer ID – The system generated id for identifying a specific personalization ‘question’ (ie: color, size, etc..) and a specific personalization ‘answer’ (ie: red, large, etc..)
Question|Answer – This is the personalization ‘question’ (ie: color, size, etc..) and personalization ‘answer’ (ie: red, large, etc..)
Answer Input Type – This is the type of input the customer would select from. (ie: dropdown, checkbox, text field, etc…)
In Line Help – This is a ‘help-box’ typically a ? that the customer can click to be given further information.
Max Characters – This sets the max allowed characters for the Answer ‘input’. (ie: 50 character limit on a ‘text field’ type input.)
Required – This sets whether an answer is required. If Y then the customer must input text or choice depending on your input type.
Track Inventory – This can be a Y or N and determines if you wish to track a specific question/answer.
Question Enabled – This determines if the questions will appear on the front end with either a Y or N
Question Sort Order – This uses a number to determine in which order to set the question. (ie, 1,2,3,4 etc…) Please note the system is auto set to 0 meaning it will appear in the order you input it into the system. )
Exclude from best seller report – This will exclude a specific personalization question/answer from the Best Seller Report.
Quantity – This will set how many of the personalization ‘answer’ is available
Price – This price is in addition to the ‘Product’ price.
SKU – The SKU for the specific personalization
Swatch Image – ie. red.png (This will go into the _import/_images) folder of your FTP. Upon import this image is copied and given a photo ID (ie. red.png > becomes 123.png)
If already created in the system this will contain a photo ID (system generated) name such as 1234.jpg.
Swatch Image Alt/Title Tag – Describes the image.
Swatch Image Image URL Link – This is a direct URL image (ie. www.test.com/red.png)
Swatch Image Height – This is represented in pixels (ie. 400)
Swatch Image Width – This is represented in pixels (ie 200)
Swatch Image New Window URL – A new Window will open to display the image.
Main Photo – This is the ‘main photo’ that will appear on the product detail page.
Main Photo Alt/Title Tag – Describes the main photo image.
Main Photo Caption – Displays text for the main photo image.
Main Photo Image URL Link – This is a direct URL image (ie. www.test.com/red.png)
%C2%A0){kind=link}
Main Photo Height – This is represented in pixels (ie. 400)
Main Photo Width – This is represented in pixels (ie. 200)
Large Photo – The image displayed when clicking on the ‘main photo’.
Large Photo Alt/Title Tag – Describes the main photo image.
Large Photo Image URL Link – This is a direct URL image (ie. www.test.com/red.png)
Large Photo Height – This is represented in pixels (ie. 400)
Large Photo Width – This is represented in pixels (ie. 200)
Answer Enabled – This will determine if the personalization ‘Answer’ should display with either a Y or N.
Default – This will set if a specific ‘answer’ will be the default choice display (example, client arrives on the product detail page. The first choice they see is shirt color: red)
Inventory Level – This will allow you to specific the physical inventory for an ‘answer’ personalization.
Low Inventory Notify Level – This will send out a notification email to the inventory amount specified.
Weight – This will allow you set a weight for the specific personalization. (note: this will be passed to various shipping methods. Examples include,: real-time carriers and order-weight – flat rate shipping)
Cost – This is the reported ‘cost’ of the specific personalization.
Download Filename – Should the item be a download file this will allow you to specific the file name.
Answer Sort Order – This allows you to sort the specific personalization ‘answer’ (ie, 1,2,3,4 etc…) Please note the system is auto set to 0 meaning it will appear in the order you input it into the system.