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|
|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.|