Additional fields for matrix (style variant) items only in the table below.
|
Mandatory |
Field Name |
Field description |
Example Value |
|
Attribute |
A property for the item that will appear in a text box. No limit to how many of these you can map. |
Hand wash only |
|
|
Boolean Attribute |
An attribute for the item that is either 0/1 (True/False). You can map up to 10 of these. These Boolean attributes can then be used in creation of filters. |
TRUE |
|
|
Case Quantity |
Assigns a case quantity for the item. Causes the +/- buttons in the catalog view to increment in the defined intervals. (must be integer = whole numbers) |
12 |
|
|
Description |
The Name/Description for the item (this is the short one - long desc. is another field) |
Silk scarf |
|
|
Display code |
An additional code you can upload for the item (does not have to be unique per item) Use this field when you need a different code to be displayed instead of your unique item code. You can also upload images using this code, thereby allowing you to load the same image for multiple items, since the Display code does not have to be unique. |
ABC321 |
|
|
Fixed Price |
A boolean field. If set to "True" the item will be added to the cart without any discount being applied, regardless of any other definition in the system (campaign, item/main category/account discount value, etc..).The sales rep cannot change the price on the cart even if he has permission to do so. |
TRUE |
|
|
Future Availability |
Future inventory quantity - upload a value for the future inventory of an item that is currently out of stock for back orders |
55 |
|
|
Future Availability Date |
Future inventory date of an item that is currently out of stock. Can be used to place back orders. Format: M/d/yyyy |
12/8/2012 |
|
|
Hide in Catalog |
Item is hidden (deleted to recycle bin). |
TRUE |
|
|
Ignore Auto Discount |
If set to "True" the item will be added to the cart without any discount being applied, regardless of any other definition in the system (campaign, item/main category/account discount value, etc..). The sales rep may change the price in the cart if he has permission to do so. |
FALSE |
|
|
Inventory |
The inventory of the item (must be integer = whole numbers) |
76 |
|
|
Yes |
Item Code |
Item Code (must be unique for each item) |
XYZ321 |
|
Item Discount |
A percentage discount for the item |
25 |
|
|
Long Description |
A long description of the item that can appear in the item details view in the catalog. |
<text. . .> |
|
|
Yes |
Main Category |
The Name of the Main Category of the item (usually Brand name) |
MyBrand |
|
Manufacturer Code |
Code given to the Brand/Main Category | ||
|
Cost Price |
In the case of a manual price edit made by the sales rep on the cart, the price will turn red if it goes below this amount (the Admin can prevent editing of prices. For details see: How to grant or take away permission for sales reps to edit order price on cart) Also if the Cost Price field is given a value, this is the value used in the calculation of the item margin and order margin. Margin is calculated by the difference between Cost Price and the price used on the cart. Item Margin calculation: Margin= Total price - Total Cost * 100 Total price |
4.5 |
|
|
Minimum Quantity |
The minimum quantity that is expected to be ordered for the item. Will mark the order quantity in red if it is lower than this minimum quantity. The item quantity will automatically increment to this value when the sales reps taps the "+" on the catalog. Subsequent taps on the "+" will increment the quantity by 1. (Value must be an integer = whole number) |
10 |
|
|
Retail Price |
Item Price (don't inidicate the currency - currency is set in the ERP configuration culture setting, for more details on this see the article: All About Pricing |
77.5 |
|
|
Price List |
The price for the item according to this price list. You can map as many price lists as you require. |
72 |
|
|
Property 1 - Property 8 |
Any property of the item. The heading of the column will serve as the title of the property. Properties serve as criteria in the advanced search tool on the iPad catalog to narrow results in the catalog. Properties can also be used to sort items in Filters. |
<any text or numbers> |
|
|
UPC |
UPC code for the item - can be used to scan items with a barcode scanner. |
123456789 |
|
|
Wholesale Price |
Wholesale price of the item (or any other price, you can rename the field title later) |
50.25 |
Fields for Matrix Items only:
For more info on matrix items and using these fields see: Matrix Items
| Field Name | Filed description | Example Value 1 | Example Value 2 |
| Style Code | All variants belonging to the same style should have the same Style Code | XYZ456 | JKL987 |
| Style Description | A description that will appear for the item (a general description of the style, not specific to the color/size variants) | Cotton blouse | Collar |
| Dimension 1 (Color) | Horizontal dimension (usually color) of the matrix item. This field is the color's code. | 890 | 554 |
| Dimension 1 (Color Desc) | Horizontal dimension of the matrix (usually color) represent a row in the matrix view. This is the name of the color that will appear on the matrix view (a picture of every color can be added by the Pepperi Admin) | Red | Green |
| Dimension 2 (Size) | Vertical dimension code (usually size) of the matrix item. This field is the size code. | 3 | 2 |
| Dimension 2 (Size Desc) | Vertical dimension of the matrix (usually size) represents columns in the matrix view. | L | M |
| Dimension 2 Group | The size scale this item belongs to. For details on setting up size scales see:Variant Dimensions Configuration |
Shoe sizes | Clothing size |
4 comments
well done
Looks like the FieldName "Item Name" dosen't exist, but is named "Name" ? Would also be nice to know the limits, fx. String 80 Chars or alike for fields where a limit exists.
Using the import wizard select 'Description' for name.
Item 'Property' 9 is in reality 'Second Category' and creates automatically a Catalogue Filter for each value.
Please sign in to leave a comment.