Import Alternate Product IDs

Starting in Acctivate version 10.3, users will be able to add multiple alternate product IDs to a given product. This will allow for more detailed reporting as well as enable you to have webstore specific IDs.

See the notes column for tips and acceptable data to import into the fields. To import Products go to File > Import Data > Product Alt IDs. 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. For a general guide on how data imports work within Acctivate, click here.

Product ID and Alternate Product ID are required fields for this import. The others are optional but can provide greater context and usability for reports and webstore inventory exports.

Data Field Type(Length) Notes
Alt Description Char(4095) Description
Alt Product ID Char(159) Alternate Description, available for product lookup and custom reports
Assigned By (Webstore ID) Char(50) The webstore ID that this alternate product ID should be assigned to.
Note Char(4095) Comment
Primary Yes/No Alternate ID will be set as the default
Product ID Char(40) Required. Product ID existing in Acctivate
Type Char(3) Alt/UPC/Web. Determines whether this is an simple alternate ID, a UPC, or a webstore specific ID


Posted in Uncategorized - Last modified on January 17, 2019
Still need help?
Search all content on this site, contact support at 817-870-1311, or create a support ticket.