Product Fields

Field Name Field Type Field Description Field Restrictions Notes Example Input
Active Boolean Active products can be sold through all channels including eBay, web shop and control panel. If inactive a product cannot be sold. Y or N or Yes or No or True or False Y
Approved Boolean Only visible products can be seen on your webshop. Only applicable to customers with the web shop module installed. Y or N or Yes or No or True or False Y
Artist/Author List List of artist and authors related to product Comma separated list Robbie Williams, Elton John
Asset Account Text String The asset account code for the product as it appears in your accounting program. Max Length: 10 20001
Availability Description Text String Displayed to customer. Typically used to explain when product will become available. No restriction, can contain html Available in 2 days.
Base Unit of Measure Text String The base unit of measure. Max Length: 10 ea
Base Unit Per Quantity Text String For display purposes only. Multiplies the actual qty by this qty. For example if base unit qty is 1.9 then a qty of 2 will display as 3.8 2 decimal places 1.5
Brand Text String The brand name or manufacturer of the product. Max Length: 50 Nike
Cartons List List of cartons that make up this product. Separate article labels will be created and printed for each carton automatically.. Semicolon separated string Qty:Weight:Width:Length:Heigth:Cubic:Packed:Barcode; 2:0.5:0.2:0.1:0.4:0.002:Y:1234567890123;
Category Full Path List (Product Category) List List of categories that the product is assigned to. Separate each category in a path with a ">" sign. A product can be assigned to multiple categories. Semicolon separated string Use ">" to represent category path Computers > Accessories > Mice; IT Equipment > Laptop Accessories
Category ID List  (Product Category) List List of categories that the product is assigned to. Semicolon separated string Use the system generated ID of the category as it appears in your database. 10;34
Category Name List  (Product Category) List List of categories that the product is assigned to. Semicolon separated string Use the name of the category as it appears in your database. Mice;Laptop Accessories
Cost of Sales Account Text String The COGS account for the product as it appears in your accounting program. Max Length: 10 20001
Cost Price Decimal The suppliers cost price. For reporting purposes. 2 decimal places 1.5
Cross-Sell Products List Cross sell related items. Items will appear in the related products area on your templates. Comma separated string SKU1, SKU2, SKU3 ABC123, GDE123, JJEE345
Cubic (Shipping) Decimal Used for shipping calculations. The cubic of the product in meters. 6 decimal places cubic meters 0.2556
Custom Label/Code Text String Populating this field is optional and is pushed through to accounting applications, eBay and other 3rd party applications instead of SKU when it is populated. SKU is limited tospecific characters while this field allows for more character types including spaces and special characters. Max Length: 50 ABC 123
Date Added DATE The date the product was added to the system. YYYY/MM/DD YYYY/MM/DD
Date Of Arrival DATE The date the product arrived from supplier. YYYY/MM/DD YYYY/MM/DD
Delete Product If Yes Boolean Will delete product from database if contains "Y" Y or N or Yes or No or True or False Y
Description Text String Description field are long text fields that can contain html, images, videos and other content. You can edit these fields in source code mode or using the WYSIWYG (human friendly)editor. These fields are used to describe products in detail and are visible to customers. No restriction, can contain html My product description
Description URL Text String Description to be fetched from third party website will be downloaded to your server and updated whenever the third party description is updated. Only use this feature if you havethe permission of the third party website owner. URL Must be fully qualified URL to .txt file containing description hosted online. System will download description from here an insert into database. http://www.mydomain.com/desc/sku1.txt
Display Template Text String Determines the template that this product uses on your website front end. For design purposes. Max Length: 25 Name of html templaten file as it appears in the /products/ folder in your template system. sample
Ebay Description Text String The eBay description field is only used when you want to display a different description on eBay to what is displayed your own web shop. No restriction, can contain html My eBay description.
Ebay Items List List List of eBay items. Add items to eBay by adding them to a listing template using this field. Semicolon separated string Listing Template ID|Design Template ID|eBay Category 1|eBay Category 2|eBay Store Category 1|eBay Store Category 2; 1|3;
Editable Kit Boolean If enabled the customer can edit the kit on your website front end. Only available on websites created after April 2013. Y or N or Yes or No or True or False Y
Expense Account Text String The Expense account for the product as it appears in your accounting program. Max Length: 10 4001
Extra Options List Options are non-inventoried extras you offer the customer at the point of purchase. For example, the option to pay for gift wrapping or enter a gift message. ^ separated list. ** Represents option name, * Represents option default attribute. Semi colon separate attributes within an option. For text entry fields eg a gift message use*-TEXT_FIELD- **Option Name;*Default Attribute;Attribute 1=+5;Attribute 2=+10;Attribute 3=+15 **Gift Wrapping;*No Thanks;Red=+5;Silver=+5;Green=+5^**Another Option;*No Thanks;Red=+5;Silver=+5;Green=+5^**Gift Message;*-TEXT_FIELD-;
Features Text String This refers to the physical or measurable characteristics of a product or service. No restriction, can contain html Packed full of features!
Flat Rate Shipping Charge List The flat rate shipping charges related to the product. Used in fixed rate shipping methods. Semicolon separated string shipping_method:1st_parcel_cost,sub_parcel_cost,maximum_cost; standard shipping:9.95,5.00,20;express shipping:12.95,6.00,30;
Format Text String The format of the item. Eg: Soft Cover. This is not a searchable field by default No restriction, can contain html DVD
Free Gifts List Buy this item and get any one of these items free. Free items will appear as buying options in shopping cart when this item is added to cart. Comma separated list SKU1, SKU2, SKU3, SKU4... H-4532, ODF6334, D-7254
Generate URL Automatically Boolean The system will auto generate a URL for the product. If N you must specify a URI inthe product URL field. Default is Y and product name is used for URI. Y or N or Yes or No or True or False Y
Group Text String If this item is part of a group of items that require a minimum qty to be purchased then you can assign it to a group below. You can setup your groups by going to > Inventory &g; Item Groups. Item Group Name / ID Name or ID of Group as it appears in your database Marked Down Items
Height m (Actual) Decimal The actual assembled height of the product. 3 decimal places meters 0.5
Height m (Shipping) Decimal Used for shipping calculations. The height of the product in meters. 3 decimal places meters 0.6
Ignore Product If Yes Boolean Product will not be imported if "Y" Y or N or Yes or No or True or False N
Image Alt 01 URL Text String 1st alternate product image. Images will be re-sized as per your image re-size settings in admin > system setup > image settings. URL (Supported Tags: USERNAME=Username, MD5PASSWORD=MD5 Encoded Password, SKU=SKU). Image will be downloaded from specified location. Must be fully qualified URL to an image file hosted online. System will download image from here an insert into file system. Use the string "DELETE" to delete an image. http://www.mydomain.com/assets/images/sku1.jpg
Image Alt 02 URL Text String 2nd alternate product image. Images will be re-sized as per your image re-size settings in admin > system setup > image settings. URL (Supported Tags: USERNAME=Username, MD5PASSWORD=MD5 Encoded Password, SKU=SKU). Image will be downloaded from specified location. Must be fully qualified URL to an image file hosted online. System will download image from here an insert into file system. Use the string "DELETE" to delete an image. http://www.mydomain.com/assets/images/sku1.jpg
Image Alt 03 URL Text String 3rd alternate product image. Images will be re-sized as per your image re-size settings in admin > system setup > image settings. URL (Supported Tags: USERNAME=Username, MD5PASSWORD=MD5 Encoded Password, SKU=SKU). Image will be downloaded from specified location. Must be fully qualified URL to an image file hosted online. System will download image from here an insert into file system. Use the string "DELETE" to delete an image. http://www.mydomain.com/assets/images/sku1.jpg
Image Alt 04 URL Text String 4th alternate product image. Images will be re-sized as per your image re-size settings in admin > system setup > image settings. URL (Supported Tags: USERNAME=Username, MD5PASSWORD=MD5 Encoded Password, SKU=SKU). Image will be downloaded from specified location. Must be fully qualified URL to an image file hosted online. System will download image from here an insert into file system. Use the string "DELETE" to delete an image. http://www.mydomain.com/assets/images/sku1.jpg
Image Alt 05 URL Text String 5th alternate product image. Images will be re-sized as per your image re-size settings in admin > system setup > image settings. URL (Supported Tags: USERNAME=Username, MD5PASSWORD=MD5 Encoded Password, SKU=SKU). Image will be downloaded from specified location. Must be fully qualified URL to an image file hosted online. System will download image from here an insert into file system. Use the string "DELETE" to delete an image. http://www.mydomain.com/assets/images/sku1.jpg
Image URL (Main Image) Text String Main product image. Images will be re-sized as per your image re-size settings in admin > system setup > image settings. URL (Supported Tags: USERNAME=Username, MD5PASSWORD=MD5 Encoded Password, SKU=SKU). Image will be downloaded from specified location. Must be fully qualified URL to an image file hosted online. System will download image from here an insert into file system. Use the string "DELETE" to delete an image. http://www.mydomain.com/assets/images/sku1.jpg
Image XML Alt 01 Data Text String 1st alternate product image. Images will be re-sized as per your image re-size settings in admin > system setup > image settings. Base64 Encoded Image Data. Image will be download from specified location. For XML imports only.
Image XML Alt 02 Data Text String 2nd alternate product image. Images will be re-sized as per your image re-size settings in admin > system setup > image settings. Base64 Encoded Image Data. Image will be download from specified location. For XML imports only.
Image XML Alt 03 Data Text String 3rd alternate product image. Images will be re-sized as per your image re-size settings in admin > system setup > image settings. Base64 Encoded Image Data. Image will be download from specified location. For XML imports only.
Image XML Alt 04 Data Text String 4th alternate product image. Images will be re-sized as per your image re-size settings in admin > system setup > image settings. Base64 Encoded Image Data. Image will be download from specified location. For XML imports only.
Image XML Alt 05 Data Text String 5th alternate product image. Images will be re-sized as per your image re-size settings in admin > system setup > image settings. Base64 Encoded Image Data. Image will be download from specified location. For XML imports only.
Image XML Data (Main Image) Text String Main product image. Images will be re-sized as per your image re-size settings in admin > system setup > image settings. Base64 Encoded Image Data For XML imports only.
In Stock Boolean Virtual items have unlimited stock holding. If virtual the qty in stock will be ignored on your web shop front end. Only applicable to customers with the web shop module installed. Y or N or Yes or No or True or False Will set store quantity to 999. Not recommended to use. Instead we recommend importing an actual warehouse qty or using the virtual flag for perpetual stock. Y
Income Account Text String The income account for the product as it appears in your accounting program. Max Length: 10 5001
Internal Notes Text String Internal product notes for your reference only No restriction, can contain html This is a fragile product, always package carefully.
Item Is Bought Boolean Flags product as Bought within third party accounting software Y or N or Yes or No or True or False This will be auto populated by SAASU if you are running the import products from SAASU module. Y
Item Is Inventoried Boolean Flags product as Inventoried within third party accounting software Y or N or Yes or No or True or False This will be auto populated by SAASU if you are running the import products from SAASU module. Y
Item Is Sold Boolean Flags product as Sold within third party accounting software Y or N or Yes or No or True or False Y
Job Text String The default job of the item. This will be passed to the job field in MYOB and other accounting applications when this item is sold. You can manually change the job assigned to anitem on order from the orders edit page. Max Length: 255 Name or ID of Job as it appears in your database. Job XYZ
Kitting List Kitting is the process in which individually separate but related items are grouped, packaged, and supplied together as one unit. For example, in ordering a PC online, a customermay select memory, drives, peripherals, and software from several alternatives. The supplier then creates a customised kit that is assembled and shipped as one unit. SKU=quantity:price_breakdown:min_qty:max_qty:assemble_group, … ABC123=2,DEF456=4
Length m (Actual) Decimal The actual assembled length of the product. 3 decimal places meters 0.5
Length m (Shipping) Decimal Used for shipping calculations. The length of the product in meters. 3 decimal places meters 0.45
Main Image Download URL Text String Images that are fetched from third party websites will be downloaded to your server and updated whenever the third party image is updated. Only use this feature if you have thepermission of the third party website owner. URL (Max Length: 255) Must be fully qualified URL to an image file hosted online. System will download image from here an insert into file system. Use the string "DELETE" to delete an image. http://www.mydomain.com/assets/images/sku1.jpg
Min Order Qty List (User Group) List The minimum order quantity of the product for this user group. You can have multiple min order qty levels/user groups and assign different customers to different user groups. Comma separated string user_group:min_qty;multiplier_qty;max_qty, ... 1:5;5;25,2:5;5;25,
Model # Text String The manufacturers model # of the item. Eg:PSU82A. This is not a searchable field by default Max Length: 25 D-007
Multi-level Pricing List Multi-Level Pricing enables you to offer quantity discounts on the items you sell on a price group level. You can have multiple qty breaks or bands. Comma separated string user_group:min_qty-max_qty=price, ... 1:0-6=12.00,1:6-15=13.00,1:15-20=10.00,
Name Text String The name of the product as it appears to customers and on invoices. Max Length: 150 Red T-Shirt - Small
Numbers Of Labels To Print Text String Determines number of product labels to print during picking (not shipping labels). EVERY = Print 1 Label For Each Item; 0 = Do Not Print Label; 1 to 99 = Print ? Label(s) For AnyNumber Of Products. EVERY | 0 | 1-99 EVERY
Parent SKU Text String The product parent SKU Max Length: 25 D-001
Pick Zone Text String Where this product is located in your warehouse. Max Length: 25 A
Pre-defined Packages List pre-defined packages allows the system to automatically package orders based the package sizes you have made available. Name or ID of pre-defined packages that this product can be packaged into as they appear in your database. Box-A, Box-C, Satchel-A
Preorder Qty Integer The qty of product available to be purchased on pre-orders. 200
Price Decimal The price of the product 2 decimal places Currency symbol not required. 19.95
Price List (User Group) List The price of the product for this user group. You can have multiple price levels/user groups and assign different customers to different user groups. user_group:price, ... 1:19.95, 2:18.95, 3:17.95
Primary Supplier Text String Name or ID of the product supplier. Suppliers can be configured in Products > Suppliers > Add Supplier Max Length: 50 Name or ID of supplier as it appears in your database. Acme Supplies
Promotion Expiry Date DATETIME The date that the promotion ends YYYY/MM/DD 00:00 YYYY/MM/DD 00:00
Promotion ID Text String Promotion ID for your internal tracking. Max Length: 25 12
Promotion Price Decimal The promotion price will override all price level between the dates specified. 2 decimal places
Promotion Start Date DATETIME The date that the promotion starts YYYY/MM/DD 00:00 YYYY/MM/DD 00:00
Purchase Tax Code Text String The purchase tax code as it appears in your accounting system. Max Length: 10 6001
Qty In Stock Integer Total quantity in stock for specified warehouse. Used for stock take. Used to replace the qty in a warehouse. 99
Qty In Stock List List For importing a list of quantities for multiple warehouses. Will update the qty in stock for each warehouse specified. Comma separated string quantity;warehouse_id 10;1,20,2
Reorder Qty Integer For reporting purposes. The qty you typically order with your supplier, used when generating purchasing report 10
Requires Packaging Boolean Determines whether or not product requires packaging Y or N or Yes or No or True or False
Restock Qty Integer For reporting purposes. When qty in stock gets below this qty you will be alerted in purchasing reports. 2
Restricted To User Group(s) List Used to restrict products to defined user groups. Semicolon separated list group id;group id 2;3
RRP Decimal The Recommended Retail Price of the product is used for descriptive purposes only. The RRP will only show when the products price is less than the RRP. 2 decimal places 9.95
Search Keywords Text String Hidden search keywords are words that people may use when trying to find your products. These may include misspelt words. Search keywords must be comma separated. Search keywordsare not visible to the naked eye but are searchable Max Length: 255 Shirt, blouse, jumper
Selling Unit of Measure Text String Unit of measure that the product is sold in. Eg: each or carton Max Length: 10 each
SEO Meta Description Text String Meta description tags, while not important to search engine rankings, are extremely important in gaining user click-through from SERPs. Meta descriptions can be any length, butsearch engines generally truncate snippets longer than 160 characters. It is best to keep meta descriptions between 150 and 160 characters. Max Length: 255 My SEO description for Google.
SEO Meta Keywords Text String Meta keywords are ignored by all major search engines. We do not recommend populating this field. Max Length: 255 shirt, red, cotton
SEO Page Title Text String A title tag is the main text that describes an online document. It is the second most important on–page SEO element (the most important being overall content), and appears in three key places: browsers, search engine results pages, and external websites. A maximum amount of 70 characters will display in the search results. The engines will show an ellipsis, "..." to indicatethat a title tag has been cut off. Max Length: 100 Red T-Shirt
Serial Tracking Boolean A title tag is the main text that describes an online document. It is the second most important on–page SEO element (the most important being overall content), and appears in three key places: browsers, search engine results pages, and external websites. A maximum amount of 70 characters will display in the search results. The engines will show an ellipsis, "..." to indicatethat a title tag has been cut off. Y or N or Yes or No or True or False Y
Shipping Category Text String Shipping Categories can be used to determine the shipping methods & rates that are used for a product. Leave as "default" if unsure. Max Length: 255 The name or ID of the shipping category of this product as it appears in your database. fragile goods
Shipping Weight Decimal Used for shipping calculations. The weight of the product in kilograms. Weight (kg) kg 0.5
Short Description Text String The short description field is used to provide a brief product description and are visible to customers. Max Length: 255 Nice shirt for everyday use.
SKU* Text String The unique identifier for the product, its stock keeping unit. Max Length: 25, cannot contain spaces or special characters. The unique identifier of the product. Required for all imports. A-0987
Sort Order 1 Integer Used to sort products in lists on your website front end. 5
Sort Order 2 Integer Determines the template that this product uses on your website front end. For design purposes. 99
Specifications Text String A product specification is a written declaration of an item's features. Product specification creates a high degree of assurance. No restriction, can contain html Made of cotton, red in colour and high in quality.
Specifics List A list of the products specifics ie. colours & sizes available Semicolon separated list Specific Type:Specific Value|Specific Value|...|Specific Value; Colour:Red; Size:Small
Split for Warehouse Picking Boolean Whether or not the product requires separate shipping labels for dispatch. Y or N or Yes or No or True or False Y
Stock Adjustment Integer Increases/Decreases quantity of stock in warehouse Used to increase the qty in stock for a given warehouse by a set amount. 2
Subtitle Text String The subtitle of the product appears below the name of the product on product pages. Max Length: 56 Quality shirt at a good price
Subtype Text String An additional type field for descriptive purposes only. Max Length: 50
Supplier Item Code Text String If your supplier has an item code that differs from your SKU or ITEM CODE enter it here. This is used for exports and reports Max Length: 50 D-00087
Tax Free Item Boolean If enabled, the item will be listed as a tax free product Y or N or Yes or No or True or False N
Tax Inclusive Boolean If enabled, the product will be inclusive of tax. Y or N or Yes or No or True or False Y
Terms And Conditions Text String General and special arrangements, provisions, requirements, rules, specifications, and standards that form an integral part of an product and service agreement No restriction, can contain html Purchaser must be 18 years of age or older.
Type Text String The item type. Eg: Genuine or Generic. This is not a searchable field by default Max Length: 100
UPC/EAN Text String The primary barcode number for the product. Max Length: 100 Use *RANDOM* to create a random UPC 7.42E+11
Upsell Products List Upsell related items. Items will appear in the "you may also like" area on your templates. Comma separated string SKU1, SKU2, SKU3 ABC123, GDE123, JJEE345
Virtual Boolean Virtual products are products that hold no stock. If you mark a product as virtual it is deemed to always be in stock and will appear as such on your website. Ideal for dropshipped products or service items. Y or N or Yes or No or True or False Y
Voucher / Reward Points List Links product to a gift voucher program to turn it into a virtual gift voucher. Comma separated string program_title:VOUCHER|REWARD;points_value;extra_points_per_dollar;ONLY|EXTRA, ... Gift Voucher:VOUCHER
Warehouse Locations List Where this product is located in your warehouse. You can assign multiple pick locations to a product. A pick location is more granular than a pick zone. Use pick zone for broaderlocation management. Semi colon separated string warehouse_name::location_id::pick_priority::location_type; ... primary warehouse::A-01::1::pick
Warranty Text String The products warranty. For example 12 month return to base. No restriction, can contain html 12 month warranty
When To Repeat On Standing Orders Text String Determines how the order repeats on standing / recurring orders. Default or Once or Always Once
Width m (Actual) Decimal The actual assembled width of the product. 3 decimal places meters 0.556
Width m (Shipping) Decimal Used for shipping calculations. The width of the product in meters. 3 decimal places meters 0.567
Misc Text String Custom field. You can create up to 50 of your own custom or misc fields by going to admin > customisable fields. Once added they will be available to import to. No restriction, can contain html Anything you like

  • Last Modified: 21/11/2016 Neto Version: 6.3