Import Product Component

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.

Data Field Type (Length) Notes
Product Component  
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.
Cost Number
Note Text
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.