| Active | *Product Data > 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 | *Product Data > Approved | Boolean | Only visible products can be seen on your webstore. Only applicable to customers with the webstore module installed. This is the Approved to show on Webstore field in your control panel. | Y or N or Yes or No or True or False | | Y |
| Approved on POS | *Product Data > Approved for Maropost Commerce POS | Boolean | Only visible products can be seen on Maropost Commerce POS. Only applicable to customers with the Maropost Commerce POS module installed. | Y or N or Yes or No or True or False | | Y |
| Approved on Amazon AU | *Product Data > Approved for Amazon AU | Boolean | Only visible products will be synced to Amazon Australia. Only applicable to customers with the Amazon Australia channel installed. | Y or N or Yes or No or True or False | | Y |
| Approved on Catch | *Product Data > Approved for Catch | Boolean | Only approved products will be synced to Catch. Only applicable to customers with the Catch sales channel installed. | Y or N or Yes or No or True or False | | Y |
| Approved for Mobile App | | Boolean | Deprecated | Y or N or Yes or No or True or False | | Y |
| Artist/Author | *Product Data > Artist/Author | List | List of artist and authors related to product | Comma separated list | | Robbie Williams, Elton John |
| Asset Account | *Product Data > Asset | Text String | The asset account code for the product as it appears in your accounting program. | Max Length: 10 | | 20001 |
| Availability Description | *Product Data > 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 | *Product Data > Base Unit of Measure | Text String | The base unit of measure. | Max Length: 10 | | ea |
| Base Unit Per Quantity | *Product Data > 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 | *Product Data > Brand | Text String | The brand name or manufacturer of the product. | Max Length: 50 | | Nike |
| Brochure URL | Image and URLs > Brochure URL | Text String | Web address for a brochure file from a suppliers web site. You can customise your webstore theme to display the link on product pages. | Max length: 2083 | | https://www.mysupplier.com/products/sampleproductbrochure01.pdf |
| Cartons | Cartons > 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) | Category Table > 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) | Category Table > 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) | Category Table > 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 | *Product Data > 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 | Pricing > Cost Price | Decimal | The suppliers cost price. For reporting purposes. | 4 decimal places | Not available with Maropost Commerce Cloud Inventory. | 1.5 |
| Cross-Sell Products | Cross Sells | List | Cross sell related items. Items will appear in the related products area on your templates. |
Import: Comma separated string
Export: Pipe separated string
|
Import: SKU1, SKU2, SKU3
Export: SKU1|SKU2|SKU3
|
Import: ABC123, GDE123, JJEE345
Export: ABC123|GDE123|JJEE345
|
| Cubic (Shipping) | *Product Data > Cubic (Shipping) | Decimal | Used for shipping calculations. The cubic of the product in meters. | 6 decimal places | cubic meters | 0.2556 |
| Custom Label/Code | *Product Data > 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 to specific characters while this field allows for more character types including spaces and special characters. | Max Length 50 | | ABC 123 |
| Date Added | *Product Data > Date Added | DATE | The date the product was added to the system. | YYYY/MM/DD | | YYYY/MM/DD |
| Date Of Arrival | *Product Data > 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 | This field is not available when Maropost Commerce Cloud Inventory is installed. | Y |
| Description | *Product Data > 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 (no html) | *Product Data > Description(No html) | Text String | Product description with all HTML elements removed. | | | |
| 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 have the 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 (in simple import)
Website Design Template (for complex import)
| | Text String | Determines the template that this product uses on your website front end. For design purposes. | Max Length: 25 | Name of html template file as it appears in the /products/ folder in your template system. | sample |
| Ebay Description | *Product Data > 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 | *Product Data > 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 of IDs separated by the | character. |
[Listing Template ID]|[Design Template ID]|[eBay Category 1]|[eBay Category 2]|[eBay Store Category 1]|[eBay Store Category 2];
Leave category values blank for category mapping to assign category values to the listing.
| 1|4||||; |
| Editable Kit | *Product Data > Editable Kits | 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 |
| ePID for eBay <site name> | | Text | Import the eBay product identifier for a specific eBay site (e.g. ePID for eBay Australia, ePID for eBay UK, ePID for eBay United States) | | | 1840908568 |
| Expense Account | *Product Data > Expense Account | Text String | The Expense account for the product as it appears in your accounting program. | Max Length: 10 | | 4001 |
| Extra Options | *Product Data > 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 | *Product Data > 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 |
Deprecated. Instead, use fields named after your flat rate shipping method.
"Fixed Rate per Product Method 1st Parcel Cost", "Fixed Rate per Product Method maximum cost" and "Fixed Rate per Product Method" Subsequent Parcel Cost".
| 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 | *Product Data > 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 URL in the product URL field. Default is Y and product name is used for URL. Import only. | Y or N or Yes or No or True or False. | | Y |
| Group | *Product Data > Group | Text String | If this item is part of a group of items that require a minimum quantity to be purchased you can assign it to a group. You can set up your groups by following the steps here. | Product Group Name / ID | Name or ID of Group as it appears in your database | Marked Down Items |
| Height m (Actual) | *Product Data > Height m (Actual) | Decimal | The actual assembled height of the product. | 3 decimal places | meters | 0.5 |
| Height m (Shipping) | *Product Data > 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 | Image and URLs > Extra Image 01 URL (Thumbnail) | Text String | 1st alternate product image. Images will be re-sized as per your settings in Settings & tools > All settings & tools > 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 | Image and URLs > Extra Image 02 URL | Text String | 2nd alternate product image. Images will be re-sized as per your settings in Settings & tools > All settings & tools > 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 | Image and URLs > Extra Image 03 URL | Text String | 3rd alternate product image. Images will be re-sized as per your settings in Settings & tools > All settings & tools > 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 | Image and URLs > Extra Image 04 URL | Text String | 4th alternate product image. Images will be re-sized as per your settings in Settings & tools > All settings & tools > 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 | Image and URLs > Extra Image 05 URL | Text String | 5th alternate product image. Images will be re-sized as per your settings in Settings & tools > All settings & tools > 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) | Image and URLs > Image URL | Text String | Main product image. Images will be re-sized as per your settings in Settings & tools > All settings & tools > 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 settings in Settings & tools > All settings & tools > 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 settings in Settings & tools > All settings & tools > 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 settings in Settings & tools > All settings & tools > 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 settings in Settings & tools > All settings & tools > 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 settings in Settings & tools > All settings & tools > 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 settings in Settings & tools > All settings & tools > Image settings. | Base64 Encoded Image Data | For XML imports only. | |
| In Stock | *Product Data > 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 | *Product Data > Income Account | Text String | The income account for the product as it appears in your accounting program. | Max Length: 10 | | 5001 |
| Incoming Qty | *Product Data > Incoming Qty | Integer | The amount of stock that has been ordered for a product. | Whole numbers only (no decimals). | | 34 |
| Internal Notes | *Product Data > 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 | *Product Data > 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 an item on order from the orders edit page. | Max Length: 255 | Name or ID of Job as it appears in your database. | Job XYZ |
| Kit components | *Product Data > Kit Components | 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, … | Standard kit
ABC123=2,DEF456=4
Editable kit
ABC123=2: 9.95:1:5,DEF456=4:25.95:1:1 |
| Length m (Actual) | *Product Data > Length m (Actual) | Decimal | The actual assembled length of the product. | 3 decimal places | meters | 0.5 |
| Length m (Shipping) | *Product Data > 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 the permission 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;multiplier_qty_start,... | 1:5;5;25;5,2:10;5;50;5, |
| Model # | *Product Data > 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 | Pricing > 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:1-6=12.00,1:7-15=11.00,1:16-20=10.00,1:21-0=8, |
| Name | *Product Data > 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 | *Product Data > 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 |
| Origin country | *Product Data > Origin Country | Alpha 2 | 2 character country code matching https://www.iban.com/country-codes | Max Length: 2 | Invalid values will be imported as blanks. | AU |
| Parent SKU | *Product Data > Parent SKU | Text String | The product parent SKU. | Max Length: 25 | Only populates after the Inventory Cache process runs (every 6 hours). | D-001 |
| Pick Zone | *Product Data > Pick Zone | Text String | Where this product is located in your warehouse. | Max Length: 25 | | A |
| Pre-defined Packages | *Product Data > 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 | *Product Data > Preorder Qty | Integer | The qty of product available to be purchased on pre-orders. | | | 200 |
| Price (Default) | Pricing > Price (Default) | Integer | Your default price group for products, configured in Customer Settings. | 2 decimal places | | 59.99 |
| 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 |
*Product Data > Primary Supplier
| Text String | Name or ID of the product supplier. Suppliers can be set up in Products > Suppliers > Add Supplier | Max Length: 50 | Name or ID of supplier as it appears in your database. | Acme Supplies |
| Product URL | Image and URLs > Product URL | Text String | The URL of the product you want for your webstore. | Must contain no spaces. | Do not include your website domain. | /my-excellent-product |
| Primary Warehouse ID | Primary Warehouse ID | Integer | The primary location of the product stock matching to a warehouse ID. | | Import only. | 1 |
| Promotion Expiry Date | *Product Data > 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 | Pricing > Promotion Price | Decimal | The promotion price will override all price level between the dates specified. | 2 decimal places | | |
| Promotion Start Date | *Product Data > 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
Import only | | 6001 |
| Qty In Stock | *Product Data > Qty In Stock | Integer | Total quantity in stock for specified warehouse. Used for stock take. | Cannot be updated when Maropost Commerce Cloud Inventory is installed. | 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. Cannot be updated when Maropost Commerce Cloud Inventory is installed. | quantity;warehouse_id | 10;1,20,2 |
| Reorder Qty | *Product Data > Reorder Qty | Integer | For reporting purposes. The qty you typically order with your supplier, used when generating purchasing report | | | 10 |
| Requires Packaging | *Product Data > Requires Packaging | Boolean | Determines if this product can be packaged (boxed) with other products | Y or N or Yes or No or True or False | | |
| Restock Qty | *Product Data > Restock Qty | Integer | For reporting purposes. When qty in stock gets below this qty you will be alerted in purchasing reports. | | | 10 |
| Restock Warning Level | *Product Data > Restock Warning Level | Integer |
For sending the email notification when the stock is lower than this level. | | | 20 |
| Restricted To User Group(s) | *Product Data > Restricted To User Group(s) | List | Used to restrict products to defined user groups. | Semicolon separated list | group id;group id | 2;3 |
| RRP | Pricing > 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 | *Product Data > 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 | *Product Data > 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 | SEO Data > 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 | SEO Data > 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 | SEO Data > 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 | *Product Data > Serial Tracking | Boolean | Whether or not serial tracking of individual products apply to this product. | Y or N or Yes or No or True or False | | Y |
| Shipping Category | *Product Data > 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 | *Product Data > Weight (Shipping) | Decimal | Used for shipping calculations. The weight of the product in kilograms. | Weight (kg) | kg | 0.5 |
| Short Description | *Product Data > 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 | *Product Data > 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 | *Product Data > Sort Order 1 | Integer | Used to sort products in lists on your website front end. | | | 5 |
| Sort Order 2 | *Product Data > Sort Order 2 | Integer | Used to sort products in lists on your website front end. | | | 99 |
| Specifications | *Product Data > 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 | *Product Data > Specifics | List | A list of the products specifics ie. colours & sizes available | Semicolon separated list | Specific Type:Specific Value | Colour:Red;Size:Medium;Style:Polo; |
| Split for Warehouse Picking | *Product Data > 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 | *Product Data > 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 | *Product Data > Subtype | Text String | An additional type field for descriptive purposes only. | Max Length: 50 | | |
| Supplier Item Code | *Product Data > 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 Category | *Product Data > Tax Category | String | Tax category for US merchants. Refer to the categories available on the product page. | Books, Bottled Water, Candy, Clothing, Digital Goods, Food & Groceries, Magazine, Magazines & Subscriptions, Non-Prescriptions, Other Exempt, Prepared Foods, Prescription, Religious books, Soft Drinks, Software as a Service, Supplements, Textbook. | Only used if your Maropost Commerce site is set to US. | Books |
| Tax Free Item | *Product Data > Tax Free Item | Boolean | If Yes the product will be imported as tax free. | Y or N or Yes or No or True or False | | Y |
| Tax Inclusive | *Product Data > 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 | *Product Data > 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 | *Product Data > Type | Text String | The item type. Eg: Genuine or Generic. This is not a searchable field by default | Max Length: 100 | | |
| UPC/EAN | *Product Data > UPC/EAN | Text String | The primary barcode number for the product. | Max Length: 100 | Use *RANDOM* to create a random UPC | 7456546712456 |
| Upsell Products | | List | Upsell related items. Items will appear in the “you may also like” area on your templates. |
Import: Comma separated string
Export: Pipe separated string
|
Import: SKU1, SKU2, SKU3
Export: SKU1|SKU2|SKU3
|
Import: ABC123, GDE123, JJEE345
Export: ABC123|GDE123|JJEE345
|
| Virtual | *Product Data > 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 | On the product, this controls the inventory policy, setting it to Track Inventory for this SKU or Do Not Track Inventory for this SKU. | Y |
| Voucher / Reward Points | | List | Links product to a gift voucher program to turn it into a virtual gift voucher. Required to identify the product as a voucher. | Comma separated string | [program_title]:[VOUCHER|REWARD];[points_value];[extra_points_per_dollar];[ONLY|EXTRA], | VIPs:REWARD;0;1;ONLY |
| Warehouse Locations | *Product Data > 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 broader location management. | Semi colon separated string | warehouse_name::
location_id::
pick_priority::
location_type; … | primary warehouse::A-01::1::pick |
| Warranty | *Product Data > 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) | *Product Data > Width m (Actual) | Decimal | The actual assembled width of the product. | 3 decimal places | meters | 0.556 |
| Width m (Shipping) | *Product Data > 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. | No restriction, can contain html | | Anything you like |