Import Product Components
Below are the fields available for importing Product Components. These will be used for Assembly, Assortment, Kit and Matrix Products. To import components, go to File > Import Data > Product Components.
Create an Excel spreadsheet with your column headings for each field name you wish to import. Using Import Data, map the file location for your spreadsheet to the Filename, choose the correct worksheet if you have multiple sheets in your Excel file, name your import, then use the Columns tab in order to map each Column to its corresponding field. To add multiple components to a single product, simply list the “Parent Product ID” on each row with the next component. Parent Products must already exist in Acctivate in order to import components.
Required fields for Component Import: Parent Product ID, Quantity, Subcomponent Product ID and Subcomponent Warehouse.
Make sure to add the full component list when importing. Acctivate clears out the component list for the parent prior to completing the import.
|Component Product ID||Text(40)||Component Product ID, must match existing Product in Acctivate|
|Component Warehouse||Text||Warehouse for component Product ID, must match Warehouse ID defined in Configuration Manager.|
|Parent Product ID||Text(40)||Product ID for Assembly, Kit, etc. Must match existing Product ID in Acctivate|
|Quantity||Number||Number of pieces of the component product in Assembly or Kit.|
|Sequence||Number||Order in which you would like to list your components for Assembly or Kit.|
|Variable Quantity||Yes/No||For Variable Assembly, if the quantity may vary per assembly this will check the box on the component.|
Import Data Specs
• Import Customer Information
• Import Customer Product IDs
• Import Inventory Receipts
• Import Inventory Transfers
• Import Lot/Serial Numbers
• Import Products
• Import Product Class
• Import Product Components
• Import Product Prices
• Import Product Type
• Import Alternate Product IDs
• Import Shipments
• Import Warehouse Locations
• Sales Order Import Mapped Fields