Window: Import Product
[Created: 11/01/2003 - Updated: 24/07/2005 ]
Description: Import Products
Help: The Import Products Window is an interim table which is used when importing external data into the system. Selecting the 'Process' button will either add or modify the appropriate records.
Tab: Import Product
[Created: 11/01/2003 - Updated: 02/01/2000 ]
Description: Import Products
Help: Before importing, iDempiere checks the Unit of Measure (default if not set), the Product Category (default if not set), the Business Partner, the Currency (defaults to accounting currency if not set), the Product Type (only Items and Services), the uniqueness of UPC, Key and uniqueness and existence of the Vendor Product No.iDempiere tries to map to existing products, if the UPC, the Key and the Vendor Product No matches (in this sequence). If the imported record could be matched, product field values will only be overwritten, if the corresponding Import field is explicitly defined. Example: the Product Category will only be overwritten if explicitly set in the Import.
Tab Level: 0
Table 10: Import Product - Fields
Table: Report Parameters
| Name | Description | Help | Technical Info |
|---|---|---|---|
| Import Product | Import Item or Service | i_product.I_Product_ID numeric(10) ID | |
| Imported | Has this import been processed | The Imported check box indicates if this import has been processed. | i_product.I_IsImported character(1) Yes-No |
| Product | Product, Service, Item | Identifies an item which is either purchased or sold in this organization. | i_product.M_Product_ID numeric(10) Search |
| Import Error Message | Messages generated from import process | The Import Error Message displays any error messages generated during the import process. | i_product.I_ErrorMsg character varying(2000) String |
| Tenant | Tenant for this installation. | A Tenant is a company or a legal entity. You cannot share data between Tenants. | i_product.AD_Client_ID numeric(10) Table Direct |
| Organization | Organizational entity within tenant | An organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations. | i_product.AD_Org_ID numeric(10) Table Direct |
| Search Key | Search key for the record in the format required - must be unique | A search key allows you a fast method of finding a particular record.If you leave the search key empty, the system automatically creates a numeric number. The document sequence used for this fallback number is defined in the "Maintain Sequence" window with the name "DocumentNo_", where TableName is the actual name of the table (e.g. C_Order). | i_product.Value character varying(40) String |
| Name | Alphanumeric identifier of the entity | The name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length. | i_product.Name character varying(255) String |
| Description | Optional short description of the record | A description is limited to 255 characters. | i_product.Description character varying(255) String |
| Document Note | Additional information for a Document | The Document Note is used for recording any additional information regarding this product. | i_product.DocumentNote character varying(2000) Text |
| Comment/Help | Comment or Hint | The Help field contains a hint, comment or help about the use of this item. | i_product.Help character varying(2000) Text |
| UPC/EAN | Bar Code (Universal Product Code or its superset European Article Number) | Use this field to enter the bar code for the product in any of the bar code symbologies (Codabar, Code 25, Code 39, Code 93, Code 128, UPC (A), UPC (E), EAN-13, EAN-8, ITF, ITF-14, ISBN, ISSN, JAN-13, JAN-8, POSTNET and FIM, MSI/Plessey, and Pharmacode) | i_product.UPC character varying(30) String |
| SKU | Stock Keeping Unit | The SKU indicates a user defined stock keeping unit. It may be used for an additional bar code symbols or your own schema. | i_product.SKU character varying(30) String |
| UOM Code | UOM EDI X12 Code | The Unit of Measure Code indicates the EDI X12 Code Data Element 355 (Unit or Basis for Measurement) | i_product.X12DE355 character varying(4) String |
| UOM | Unit of Measure | The UOM defines a unique non monetary Unit of Measure | i_product.C_UOM_ID numeric(10) Table Direct |
| Product Category Key | i_product.ProductCategory_Value character varying(40) String | ||
| Product Category | Category of a Product | Identifies the category which this product belongs to. Product categories are used for pricing and selection. | i_product.M_Product_Category_ID numeric(10) Table Direct |
| Product Type | Type of product | The type of product also determines accounting consequences. | i_product.ProductType character(1) List |
| Classification | Classification for grouping | The Classification can be used to optionally group products. | i_product.Classification character(1) String |
| Volume | Volume of a product | The Volume indicates the volume of the product in the Volume UOM of the Tenant | i_product.Volume numeric Amount |
| Weight | Weight of a product | The Weight indicates the weight of the product in the Weight UOM of the Tenant | i_product.Weight numeric Amount |
| Shelf Width | Shelf width required | The Shelf Width indicates the width dimension required on a shelf for a product | i_product.ShelfWidth numeric(10) Integer |
| Shelf Height | Shelf height required | The Shelf Height indicates the height dimension required on a shelf for a product | i_product.ShelfHeight numeric Amount |
| Shelf Depth | Shelf depth required | The Shelf Depth indicates the depth dimension required on a shelf for a product | i_product.ShelfDepth numeric(10) Integer |
| Units Per Pallet | Units Per Pallet | The Units per Pallet indicates the number of units of this product which fit on a pallet. | i_product.UnitsPerPallet numeric(10) Integer |
| Discontinued | This product is no longer available | The Discontinued check box indicates a product that has been discontinued. | i_product.Discontinued character(1) Yes-No |
| Discontinued At | Discontinued At indicates Date when product was discontinued | i_product.DiscontinuedAt timestamp without time zone Date | |
| Customs Tariff Number | Customs Tariff Number, usually the HS-Code | i_product.CustomsTariffNumber character varying(20) String | |
| Image URL | URL of image | URL of image; The image is not stored in the database, but retrieved at runtime. The image can be a gif, jpeg or png. | i_product.ImageURL character varying(120) URL |
| Description URL | URL for the description | i_product.DescriptionURL character varying(120) URL | |
| Attribute Set | Product Attribute Set | Define Product Attribute Sets to add additional attributes and values to the product. You need to define a Attribute Set if you want to enable Serial and Lot Number tracking. | i_product.M_AttributeSet_ID numeric(10) Table Direct |
| Group1 | i_product.Group1 character varying(255) String | ||
| Group2 | i_product.Group2 character varying(255) String | ||
| Business Partner Key | The Key of the Business Partner | i_product.BPartner_Value character varying(40) String | |
| Business Partner | Identifies a Business Partner | A Business Partner is anyone with whom you transact. This can include Vendor, Customer, Employee or Salesperson | i_product.C_BPartner_ID numeric(10) Search |
| ISO Currency Code | Three letter ISO 4217 Code of the Currency | For details - http://www.unece.org/trade/rec/rec09en.htm | i_product.ISO_Code character(3) String |
| Currency | The Currency for this record | Indicates the Currency to be used when processing or reporting on this record | i_product.C_Currency_ID numeric(10) Table Direct |
| List Price | List Price | The List Price is the official List Price in the document currency. | i_product.PriceList numeric Costs+Prices |
| PO Price | Price based on a purchase order | The PO Price indicates the price for a product per the purchase order. | i_product.PricePO numeric Costs+Prices |
| Standard Price | Standard Price | The Standard Price indicates the standard or normal price for a product on this price list | i_product.PriceStd numeric Costs+Prices |
| Limit Price | Lowest price for a product | The Price Limit indicates the lowest price for a product stated in the Price List Currency. | i_product.PriceLimit numeric Costs+Prices |
| Royalty Amount | (Included) Amount for copyright, etc. | i_product.RoyaltyAmt numeric Amount | |
| Price effective | Effective Date of Price | The Price Effective indicates the date this price is for. This allows you to enter future prices for products which will become effective when appropriate. | i_product.PriceEffective timestamp without time zone Date |
| Partner Product Key | Product Key of the Business Partner | The Business Partner Product Key identifies the number used by the Business Partner for this product. It can be printed on orders and invoices when you include the Product Key in the print format. | i_product.VendorProductNo character varying(40) String |
| Partner Category | Product Category of the Business Partner | The Business Partner Category identifies the category used by the Business Partner for this product. | i_product.VendorCategory character varying(30) String |
| Manufacturer | Manufacturer of the Product | The manufacturer of the Product (used if different from the Business Partner / Vendor) | i_product.Manufacturer character varying(30) String |
| Minimum Order Qty | Minimum order quantity in UOM | The Minimum Order Quantity indicates the smallest quantity of this product which can be ordered. | i_product.Order_Min numeric Integer |
| Order Pack Qty | Package order size in UOM (e.g. order set of 5 units) | The Order Pack Quantity indicates the number of units in each pack of this product. | i_product.Order_Pack numeric Integer |
| Cost per Order | Fixed Cost Per Order | The Cost Per Order indicates the fixed charge levied when an order for this product is placed. | i_product.CostPerOrder numeric Costs+Prices |
| Promised Delivery Time | Promised days between order and delivery | The Promised Delivery Time indicates the number of days between the order date and the date that delivery was promised. | i_product.DeliveryTime_Promised numeric(10) Integer |
| Import Products | Imports products from a file into the application | Import Products will bring a file of products, in a predefined format into the application.The Parameters are default values for null import record values, they do not overwrite any data.If you select an existing price list and you have List, Standard, and Limit Price defined, they are directly created/updated. | i_product.Processing character(1) Button |
| Processed | The document has been processed | The Processed checkbox indicates that a document has been processed. | i_product.Processed character(1) Yes-No |